public static function getProductsOnCate($cate_id, $limit)
{
/*Tim danh sach con neu co*/
if ($cate_id == 1) {
// loai my pham
$arrayChildCateId = Cate::getSecChildId($cate_id);
} else {
//loai thoitrang suckhoe
$arrayChildCateId = Cate::getFirstChildId($cate_id);
}
if (count($arrayChildCateId) > 0) {
//Co con
$products = Products::join("cates", "products.cate_id", "=", "cates.id")->join("discounts", "discounts.id", "=", "cates.discount_id")->select(["products.*", "cates.name as cate", "cates.alias as cate_alias", "discounts.percent as percent"])->whereIn("cate_id", $arrayChildCateId)->orderBy("products.updated_at")->paginate($limit);
} else {
//Khong co con
$products = Products::join("cates", "products.cate_id", "=", "cates.id")->join("discounts", "discounts.id", "=", "cates.discount_id")->select(["products.*", "cates.name as cate", "cates.alias as cate_alias", "discounts.percent as percent"])->where("cate_id", $cate_id)->orderBy("products.updated_at")->paginate($limit);
}
return $products;
}
