我有两个连接表..我需要对所有行求和,但是当我使用代码时
DB::raw('sum(items.it_price_egp_in) As sum1'),
我只是得到 items.it_price_egp_in 中的选定值而不是所有行的总和 请检查代码中的注释
这里是控制器代码
$data = Item::select('items.it_photo_name','items.it_arabic_name','items.it_english_name','items.it_cod_1','items.id','items.shp_no_for_it','items.it_buy_date','items.it_qut_1','items.it_created_date','items.it_storaged_date','items.it_out_of_stock','items.it_price_egp_in','items.it_other_fees_in','items.it_price_usd_out','items.it_supp_shipping_fees_out','items.it_other_fees_out','shipments.shp_destination_shipping_fees','shipments.shp_customs_fees','shipments.shp_permission_receive_fees','shipments.shp_storage_fees','shipments.shp_mid_fees','shipments.shp_other_fees_out','shipments.shp_clearance_fees','shipments.shp_trans_fees_out','shipments.shp_trans_fees_in','shipments.shp_other_fees_in','shipments.shp_no',// sum(items.it_price_egp_in) not working good just give value in table but i need to sum all (items.it_price_egp_in) that contain ('items.shp_no_for_it','=','shipments.shp_no')
DB::raw('sum(items.it_price_egp_in) As sum1'),DB::raw('SUM(shipments.shp_trans_fees_in + shipments.shp_other_fees_in) As fees_in'),DB::raw('SUM(shipments.shp_destination_shipping_fees + shipments.shp_customs_fees + shipments.shp_permission_receive_fees
+ shipments.shp_storage_fees + shipments.shp_mid_fees + shipments.shp_other_fees_out
+ shipments.shp_clearance_fees + shipments.shp_trans_fees_out) As fees_out'),// DB::raw('SUM(sum1 + sum2) As prc_in'),DB::raw('SUM(items.it_price_usd_out + items.it_supp_shipping_fees_out + items.it_other_fees_out) As prc_out')
)
->join('shipments','shipments.shp_no')
->groupBy('items.it_photo_name','shipments.shp_no')
->get();