mgsmus Halletdim hocam cok sagolun.
$sell = DB::table('customer_orders')
->whereIn('order_status_id', [OrderStatus::PENDING,OrderStatus::DELIVERED])
->select(
DB::raw('sum(paid) as income'),
DB::raw("0 as expense"),
DB::raw("DATE_FORMAT(created_at, '%M-%Y') new_date"),
DB::raw("DATE_FORMAT(created_at, '%M') month_name"),
DB::raw('YEAR(created_at) year, MONTH(created_at) month'),
)
->groupby('year', 'month');
$buy = DB::table('buyings')
->whereIn('order_status_id', [OrderStatus::PENDING,OrderStatus::DELIVERED])
->select(
DB::raw("0 as income"),
DB::raw('sum(paid) as expense'),
DB::raw("DATE_FORMAT(created_at, '%M-%Y') new_date"),
DB::raw("DATE_FORMAT(created_at, '%M') month_name"),
DB::raw('YEAR(created_at) year, MONTH(created_at) month')
)
->groupby('year', 'month')
->unionAll($sell)
->orderBy('month')
->get()
->where('year',2021)->groupBy('month')->map(function(Collection $rows) {
return [
'income' => $rows->sum('income'),
'expense' => $rows->sum('expense'),
'months' => $rows[0]->month_name,
];
}
);
birilerine gerekirse buraya burakiyorum