public function getcompareproduct($id, $cate)
{
return array("template" => Template::Compare_Cate($cate, $id), "product" => Product::select(array(DB::raw("check_coupon(pro_product.id,pro_product.cid_cate,1) AS discountcoupon"), DB::raw("check_coupon(pro_product.id,pro_product.cid_cate,2) AS coupons"), DB::raw("get_review(pro_product.id,1) AS rating"), DB::raw("get_review(pro_product.id,2) AS countrating"), DB::raw("get_price(pro_supplier_product.id,pro_supplier_product.discount) AS discount"), DB::raw("get_sale_price(pro_supplier_product.id,pro_supplier_product.saleprice) AS saleprice"), "market_supplier.name AS myname", "pro_product.cid_series", "pro_supplier_product.cid_supplier", "pro_product.id", "pro_product.id AS myid", "pro_product.name", "pro_product.isprice", "pro_supplier_product.stock_num", "pro_product.is_shopping"))->whereRaw("pro_product.id ={$id} AND pro_product.status='1' AND pro_product.is_status_cate='1' AND pro_product.is_status_series='1' ")->join("pro_supplier_product", function ($join) {
$join->on("pro_product.id", "=", "pro_supplier_product.cid_product");
})->join("market_supplier", function ($join) {
$join->on("market_supplier.id", "=", "pro_supplier_product.cid_supplier");
})->first());
}
