Every now and then we need to create a list of taxonomies that are not just empty, but are also not found in the posts for that page.
I recently found a pretty sweet solution over on Stack Overflow and wanted to share.
|
1 2 3 4 5 6 7 8 |
$my_query = new WP_Query( $my_args ); $post_ids = wp_list_pluck( $my_query->posts, 'ID' ); $my_terms = get_terms( array( 'taxonomy' => 'my-terms', 'hide_empty' => true, 'object_ids' => $post_ids, ) ); |
We often have to do queries for post IDs which we then use for a later query. However, I don’t think WordPress has a way to return just the result set we want which is a one dimensional array of post_ids. Instead it returns an array of objects (or arrays) with a post_id property. One way to get those post_ids into their own one dimensional array is to loop through your results and pick them out one by one…boring.
If you run into a similar problem try using array_columns to automagically pull a one dimensional array of post_ids out of a two dimensional array.
|
1 2 3 4 5 6 7 8 |
//Get our post_ids $product_ids = $wpdb->get_results( $wpdb->prepare( "SELECT post_id FROM pkwp_postmeta WHERE (meta_key='_sku' OR meta_key='_product_sku') AND meta_value REGEXP %s", '.{2} '.$_GET['state'].'.*' ) ); // Pull our our post_ids into it's own array $product_ids = array_column($product_ids, 'post_id'); // Use this new array to limit a different post's results. $query->set('post__in', $product_ids); |
We recently imported a large number of orders and files from and older legacy / custom Ecommerce site into a Woocommerce site.
There are a lot of tales to tell in this adventure, but a big one was getting all of these files attached correctly to the product variations downloadable file.
It took a while to find a good solution, but thankfully Chris Hawkins had a good answer for me over on Stack Overflow.
Here is essentially what my solution looked like:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
$limit = 10000; $offset = 0 * $limit; $orders = get_posts( array( 'post_type' => 'shop_order', 'post_status' => 'wc-completed', 'posts_per_page' => $limit, 'offset' => $offset ) ); foreach ( $orders as $order ) { regen_woo_downloadable_product_permissions( $order->ID, true ); } /** * Regenerate the WooCommerce download permissions for an order * @param Integer $order_id */ function regen_woo_downloadable_product_permissions( $order_id ){ // Remove all existing download permissions for this order. // This uses the same code as the "regenerate download permissions" action in the WP admin (https://github.com/woocommerce/woocommerce/blob/3.5.2/includes/admin/meta-boxes/class-wc-meta-box-order-actions.php#L129-L131) // An instance of the download's Data Store (WC_Customer_Download_Data_Store) is created and // uses its method to delete a download permission from the database by order ID. $data_store = WC_Data_Store::load( 'customer-download' ); $data_store->delete_by_order_id( $order_id ); // Run WooCommerce's built in function to create the permissions for an order (https://docs.woocommerce.com/wc-apidocs/function-wc_downloadable_product_permissions.html) // Setting the second "force" argument to true makes sure that this ignores the fact that permissions // have already been generated on the order. wc_downloadable_product_permissions( $order_id, true ); } |
This only needs to be run once for each order so this can be run from almost anywhere. Make sure to update your offset until you make it through all your orders AND that you already have all your files in place.
That is it! I hope this helps someone!
Sometimes we need to add a new account menu item for Woocommerce. If you have the same problem the code below should get you 90% of the way there. Just need to build out your own template part.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
add_filter ( 'woocommerce_account_menu_items', 'jb_add_woo_item' ); function jb_add_woo_item( $menu_links ){ $new = array( 'attendance' => 'Seminar Attendance' ); // array_slice() is good when you want to add an element between the other ones $menu_links = array_slice( $menu_links, 0, 1, true ) + $new + array_slice( $menu_links, 1, NULL, true ); return $menu_links; } add_filter( 'woocommerce_get_endpoint_url', 'jb_hook_endpoint', 10, 4 ); function jb_hook_endpoint( $url, $endpoint, $value, $permalink ){ if( $endpoint === 'attendance' ) { // ok, here is the place for your custom URL, it could be external $url = site_url().'/my-account/attendance/'; } return $url; } add_action( 'init', 'jb_attendance_new_endpoints' ); function jb_attendance_new_endpoints() { add_rewrite_endpoint( 'attendance', EP_ROOT | EP_PAGES ); } // MY ACCOUNT add_action( 'woocommerce_account_attendance_endpoint', 'jb_attendance_endpoint_content' ); function jb_attendance_endpoint_content() { get_template_part('templates/woocommerce/my-account/attendance'); } |
I have run into this a few times and it always bothers me. Google has an auto fill function for forms that is sometimes really handy as a user, but sometimes breaks ui elements if you are a dev.
This is especially bad with the Google Address search because it seems to reset your autofill / autocomplete attributes each time you focus on the element.
If you are running into this issue here is a good thread with a couple good solutions for hiding the autofill.
The jQuery solution is what I found worked best for myself.
I needed to setup some text search functionality on a page and the client really wanted the searched words to be highlighted.
I found a great library for exactly this over on The Art of the Web.
They do a great job of explaining this library so please check them out to learn more!