PHP Model_Base_Category::get_all_child_category_id Examples

Example #1

File: product.php Project: khoapld/wjshop

 public static function count_by_category($category_id)
 {
     $category_ids = Model_Base_Category::get_all_child_category_id($category_id);
     $ids = join(',', $category_ids);
     $sql = "\n                SELECT `p`.`id`\n                FROM `product_categories` `pc`\n                LEFT JOIN `products` `p` ON `pc`.`product_id` = `p`.`id`\n                WHERE `pc`.`category_id` IN ({$ids})\n                AND `p`.`status` = 1\n                GROUP BY `p`.`id`\n            ";
     try {
         $query = DB::query($sql)->execute()->as_array();
         return count($query);
     } catch (Exception $e) {
         Log::write('ERROR', $e->getMessage());
     }
     return false;
 }