php - WooCommerce category tree with all products -


i need display category tree , full list of products under each category.

i used wp_query full list of products still unable show categories/sub-categories , list related products under each of them. looking way require least possible queries database.

any help? (no html or jquery needed, need result array)

the final result this.

subcat 1

----- product 1

----- product 2

----- subcategory1 of subcat 1

-------- product 1

-------- product 2

-------- product 3

subcat 2

----- product 1

----- product 2

----- product 3

    <?php     // remove breadcrumb if needed     $post_id = yiw_post_id();     if( get_post_meta( $post_id, '_show_breadcrumbs_page', true ) == 'no' ) {         remove_action( 'woocommerce_before_main_content', 'woocommerce_breadcrumb', 20, 0 );     }      if( get_post_meta( $post_id, '_slogan_page', true ) ) {         get_template_part('slogan');     }     /**      * woocommerce_before_main_content hook      *      * @hooked woocommerce_output_content_wrapper - 10 (outputs opening divs content)      * @hooked woocommerce_breadcrumb - 20      */     do_action('woocommerce_before_main_content'); ?>      <h1 class="page-title"><?php if( get_post_meta( yiw_post_id(), '_show_title_page', true ) == 'yes' ) woocommerce_page_title(); ?></h1>      <div class="clear"></div>      <?php if ( is_tax() && get_query_var( 'paged' ) == 0 ) : ?>         <?php echo '<div class="term-description">' . yiw_addp( term_description() ) . '</div>'; ?>     <?php elseif ( ! is_search() && get_query_var( 'paged' ) == 0 && ! empty( $shop_page ) && is_object( $shop_page ) ) : ?>         <?php echo '<div class="page-description">' . apply_filters( 'the_content', $shop_page->post_content ) . '</div>'; ?>     <?php endif; ?>      <?php if ( have_posts() ) : ?>         <?php         $args = array(             'taxonomy' => 'product_cat',         );          $cats = get_categories($args);          foreach ( $cats $cat ):             if ( !$cat->parent ):                 echo '<div class="clear"></div><h1>' . $cat->name . '</h1>';                  // display products directly associated product category todo: display direct products                 $args = array( 'post_type' => 'product', 'posts_per_page' => -1, 'product_cat' => $cat->slug, 'tax_query' => array( array( 'taxonomy' => 'product_cat', 'field' => 'slug', 'terms' => $cat->slug, 'include_children' => false  ) ) );                  $wp_query = new wp_query( $args );                  ?>                 <?php                 /**                 * woocommerce_pagination hook                 *                 * @hooked woocommerce_pagination - 10                 * @hooked woocommerce_result_count - 20                 * @hooked woocommerce_catalog_ordering - 30                 */                 do_action( 'woocommerce_before_shop_loop' );                 ?>                  <?php woocommerce_product_loop_start(); ?>                  <?php woocommerce_product_subcategories(); $woocommerce_loop['loop'] = 0; $woocommerce_loop['columns'] = 0; ?>                  <?php while ( have_posts() ) : the_post(); ?>                      <?php woocommerce_get_template_part( 'content', 'product' ); ?>                  <?php endwhile; // end of loop. ?>                  <?php                                    // children product categories                 $subcats = get_categories( array( 'hide_empty' => 0, 'parent' => $cat->term_id, 'taxonomy' => 'product_cat' ) );                  if ( count($subcats) > 0 ):                     $original_query = $wp_query;                      foreach ( $subcats $subcat ):                         set_query_var('category_header_level', 2);                         set_query_var('category', $subcat);                         woocommerce_get_template_part( 'archive-product-child-category', 'loop' );                      endforeach;                     $wp_query = null;                     $wp_query = $original_query;                     wp_reset_postdata();                  endif;                 else:                 /*  $args = array( 'post_type' => 'product', 'posts_per_page' => -1, 'product_cat' => $cat->slug );                     $wp_query = new wp_query( $args );                     ?>                     <?php                     /**                     * woocommerce_pagination hook                     *                     * @hooked woocommerce_pagination - 10                     * @hooked woocommerce_result_count - 20                     * @hooked woocommerce_catalog_ordering - 30                     */                 /*  do_action( 'woocommerce_before_shop_loop' );                     ?>                      <?php woocommerce_product_loop_start(); ?>                      <?php woocommerce_product_subcategories(); $woocommerce_loop['loop'] = 0; $woocommerce_loop['columns'] = 0; ?>                      <?php while ( have_posts() ) : the_post(); ?>                          <?php woocommerce_get_template_part( 'content', 'product' ); ?>                      <?php endwhile; // end of loop. ?>                     <?php */                  endif;         endforeach;         $wp_query = null;         $wp_query = $original_query;         wp_reset_postdata();         ?>           <?php woocommerce_product_loop_end(); ?>          <?php do_action('woocommerce_after_shop_loop'); ?>      <?php else : ?>          <?php if ( ! woocommerce_product_subcategories( array( 'before' => woocommerce_product_loop_start( false ), 'after' => woocommerce_product_loop_end( false ) ) ) ) : ?>             <div class="clear"></div>             <p><?php _e( 'no products found match selection.', 'woocommerce' ); ?></p>          <?php endif; ?>      <?php endif; ?>       <div class="clear"></div>      <?php         /**          * woocommerce_pagination hook          *          * @hooked woocommerce_pagination - 10          * @hooked woocommerce_catalog_ordering - 20          */         do_action( 'woocommerce_pagination' );     ?>  <?php     /**      * woocommerce_after_main_content hook      *      * @hooked woocommerce_output_content_wrapper_end - 10 (outputs closing divs content)      */     do_action('woocommerce_after_main_content'); ?>  <?php     /**      * woocommerce_sidebar hook      *      * @hooked woocommerce_get_sidebar - 10      */     do_action('woocommerce_sidebar'); ?>

taken answer prafulla kumar sahu question


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more