public function getIncomeVsExpenseReports()
{
$income = Transaction::with('banks')->where('cr', '!=', '0.00')->sum('bal');
$expense = Transaction::with('banks')->where('dr', '!=', '0.00')->sum('bal');
$inmex = $income - $expense;
$start = Carbon::now()->startOfMonth();
$end = Carbon::now()->endOfMonth();
$monthincome = Transaction::whereBetween('date', [$start, $end])->where('type', '=', 'Income')->sum('bal');
$monthexpense = Transaction::whereBetween('date', [$start, $end])->where('type', '=', 'Expense')->sum('bal');
$inmexm = $monthincome - $monthexpense;
$charts = $this->getIncomeVsExpenseChartData();
return view('transaction.incomevsexpense', compact('lists', 'accounts', 'income', 'expense', 'inmex', 'monthincome', 'monthexpense', 'inmexm', 'charts'));
}
public function get_data_report($date_start, $date_end, $user_id)
{
$results = Transaction::whereBetween('date_order', [$date_start, $date_end])->join('transaction_users', 'transaction_users.transaction_id', '=', 'transactions.id')->join('packages', 'transaction_users.package_id', '=', 'packages.id')->join('status', 'transactions.status_id', '=', 'status.id')->join('users', 'transaction_users.user_id', '=', 'users.id')->select('transactions.invoice_number', 'status.name as status_trans', 'transactions.date_order', 'transaction_users.qty', 'transaction_users.end_date', 'transaction_users.status', 'packages.name as package_name', 'packages.price_opr', 'packages.unit', 'users.name as user_name')->whereBetween('transaction_users.end_date', [$date_start, $date_end])->where('transaction_users.status', '=', 'Selesai')->where('transaction_users.user_id', '=', $user_id)->get();
return $results;
}
public function getPieChartData()
{
$start = Carbon::now()->startOfMonth();
$end = Carbon::now()->endOfMonth();
$monthincome = Transaction::whereBetween('date', [$start, $end])->where('type', '=', 'Income')->sum('amount');
$monthexpense = Transaction::whereBetween('date', [$start, $end])->where('type', '=', 'Expense')->sum('amount');
$pieincome = intval($monthincome);
$pieexpense = intval($monthexpense);
$piecharts["chart"] = ["type" => "pie"];
$piecharts['credits'] = ['enabled' => false];
$piecharts["title"] = ["text" => "Income vs Expense"];
$piecharts["subtitle"] = ["text" => date('F Y')];
$piecharts["series"] = [["name" => "Income", "data" => $pieincome], ["name" => "Expense", "data" => $pieexpense]];
return [$pieincome, $pieexpense];
}
