laravel - Laravel - 2 个日期和 customer_id 的 cloumns 总和

Question

我想在 2 个日期（payment_date）、customer_id 和付款状态 1 之间获得 SUM 金额、service_charge 和 GST

这些是我的桌子

我想让输出是这样的：

帮我写laravel模型函数。在此先感谢您的帮助

标签： laraveleloquentlaravel-8

Answer 1

Hopefully, this can help you to build the query.

DB::table('ss_transaction')
     ->join('ss_service_charge','ss_service_charge.ss_transaction_id','ss_transaction.id')
      ->select(
        'payment_date',
        'total_amount',
        "total_service_charge", 
        "total_gst", 
       DB::raw('COUNT(amount) as Shipment_count'))
      ->groupBy('payment_date')
      ->where('pay_status',1)
      ->get();