static public function bill_shoplist_purchase_returns($id)
{
$shop_list = Db::view("bill_product",true)
->view("specif","shop_id,guige_name,price,num as spe_num,expiration_date","bill_product.specif_id=specif.id","left")
->view("company","dw_name,dw_num","company.id=bill_product.company_id","left")
->view("product_shop","title,freight,if_code,serial_number,pl_type","specif.shop_id=product_shop.id","left")
->where("bill_product.bill_id",'=',$id)
// ->where("bill_product.num",'>',"bill_product.return_goods_num")
->where('bill_product.num','exp',Db::raw('>bill_product.return_goods_num'))
->select();
return $shop_list;
}
Thinkphp5.1字段两互比
最新推荐文章于 2023-09-01 11:45:51 发布