progeny() public static method

progeny Retrieve all the categories children of one passed through parameter, checking data from bottom to top.
public static progeny ( [int] $id, &$list, [array] $fields = ['id', 'name'] )
$id [int]
$fields [array]
示例#1
0
 public function scopeRefine($query, $filters)
 {
     foreach ($filters as $key => $value) {
         switch ($key) {
             case 'category':
                 $children = \Cache::remember('progeny_of_' . $value, 15, function () use($value) {
                     Category::progeny($value, $children, ['id']);
                     return $children;
                 });
                 $children[] = ["id" => $value * 1];
                 $query->whereIn('category_id', $children);
                 break;
             case 'conditions':
                 $query->where('condition', 'LIKE', $value);
                 break;
             case 'brands':
                 $query->where('brand', 'LIKE', $value);
                 break;
             case 'min':
             case 'max':
                 $min = array_key_exists('min', $filters) ? trim($filters['min']) != '' ? $filters['min'] : '' : '';
                 $max = array_key_exists('max', $filters) ? trim($filters['max']) != '' ? $filters['max'] : '' : '';
                 if ($min != '' && $max != '') {
                     $query->whereBetween('price', [$min, $max]);
                 } elseif ($min == '' && $max != '') {
                     $query->where('price', '<=', $max);
                 } elseif ($min != '' && $max == '') {
                     $query->where('price', '>=', $min);
                 }
                 break;
             default:
                 if ($key != 'category_name' && $key != 'search' && $key != 'page') {
                     //changing url encoded character by the real ones
                     $value = urldecode($value);
                     //applying filter to json field
                     $query->whereRaw("features LIKE '%\"" . $key . "\":%\"%" . str_replace('/', '%', $value) . "%\"%'");
                 }
                 break;
         }
     }
 }
示例#2
0
文件: Category.php 项目: rolka/antVel
 /**
  * $id category to searh progeny , $list array to use, $fields that you need
  */
 public static function progeny($id, &$list, $fields = ['id', 'name'])
 {
     $childs = Category::childsOf($id)->select($fields)->get();
     if (is_null($childs)) {
         return;
     }
     foreach ($childs as $value) {
         $list[] = $value->toArray();
         Category::progeny($value->id, $list, $fields);
     }
     return;
 }
示例#3
0
 /**
  * countingProductsByCategory
  * Products total by category collection
  * @param  [type] $all_products refine products
  * @param  [type] $categories   refine categories
  * @return [array] filter used in the product list view menu
  */
 public static function countingProductsByCategory($all_products, $categories)
 {
     $filters = ['category' => []];
     foreach ($categories as $value) {
         $category_id = $value['id'];
         $childs = \Cache::remember('progeny_of_' . $category_id, 15, function () use($category_id) {
             Category::progeny($category_id, $childs, ['id']);
             return $childs;
         });
         $all = $childs;
         $childs = [];
         foreach ((array) $all as $val) {
             $childs[] = $val['id'];
         }
         $qty = 0;
         if ($all_products) {
             $qty = $all_products->where('category_id', $category_id)->count();
             $qty += $all_products->filter(function ($item) use($childs) {
                 return in_array($item->category_id, $childs);
             })->count();
         }
         if ($qty) {
             $filters['category'][$category_id]['id'] = $category_id;
             $filters['category'][$category_id]['name'] = $value['name'];
             $filters['category'][$category_id]['qty'] = $qty;
         }
     }
     //Order by qty
     if (isset($filters['category'])) {
         $filters['category'] = collect($filters['category'])->sortByDesc('qty');
     }
     return $filters;
 }