public function renderDashboard()
{
$now = Carbon::now()->toDateTimeString();
$clients = Client::all();
$user_activity = UserActivity::latest()->get();
foreach ($user_activity as $ua) {
DB::table('user_activities_read_status')->insert(['user_id' => $ua->user->id, 'activity_id' => $ua->id, 'is_read' => 1]);
}
foreach ($clients as $client) {
$client->client_id = $client->id + 999;
}
$active_invoices = Invoice::active()->get();
$overdue_invoices = Invoice::overdue()->get();
$thirty_day_invocies = Invoice::paidInLastThirtyDays()->get();
$previous_thirty_day_invocies = Invoice::paidInPreviousThirtyDays()->get();
$this_year_invoices = Invoice::paidThisCalenderYear()->get();
$last_year_invoices = Invoice::paidLastCalenderYear()->get();
$this_financial_year_invoices = Invoice::paidThisFinancialYear()->get();
$last_financial_year_invoices = Invoice::paidLastFinancialYear()->get();
$active_total = $active_invoices->sum('amount');
$overdue_total = $overdue_invoices->sum('amount');
$thirty_day_total = $thirty_day_invocies->sum('amount');
$previous_thirty_day_total = $previous_thirty_day_invocies->sum('amount');
$this_year_total = $this_year_invoices->sum('amount');
$last_year_total = $last_year_invoices->sum('amount');
$this_financial_year_total = $this_financial_year_invoices->sum('amount');
$last_financial_year_total = $last_financial_year_invoices->sum('amount');
$active_quotes = Quote::active()->get();
$accepted_quotes = Quote::issuedThisFinancialYear()->accepted()->get();
$accepted_quotes_total = $accepted_quotes->sum('amount');
$position_difference = $thirty_day_total - $previous_thirty_day_total;
if ($this_year_total !== 0 && $last_year_total !== 0) {
$year_difference_percent = $this_year_total / $last_year_total * 100;
} else {
$year_difference_percent = 0;
}
if ($this_financial_year_total !== 0 && $last_financial_year_total !== 0) {
$financial_year_difference_percent = $this_financial_year_total / $last_financial_year_total * 100;
} else {
$financial_year_difference_percent = 0;
}
$projected_fy_earnings = $this_financial_year_total + $accepted_quotes_total;
$projected_fy_earnings_percent = $projected_fy_earnings / $last_financial_year_total * 100;
foreach ($active_invoices as $invoice) {
$invoice->client_id = $invoice->client_id + 999;
if ($invoice->client_specific_id < 10) {
$invoice->client_specific_id = sprintf("%02d", $invoice->client_specific_id);
}
$issue_date = Carbon::parse($invoice->issue_date);
$due_date = Carbon::parse($invoice->due_date);
$invoice->terms_diff = $issue_date->diffInDays($due_date);
if ($now > $due_date) {
$invoice->is_overdue = true;
} else {
$invoice->is_overdue = false;
}
}
foreach ($active_quotes as $quote) {
$quote->client_id = $quote->client_id + 999;
if ($quote->client_specific_id < 10) {
$quote->client_specific_id = sprintf("%02d", $quote->client_specific_id);
}
}
return view('app.dashboard', ['clients' => $clients, 'active_total' => $active_total, 'overdue_total' => $overdue_total, 'thirty_day_total' => $thirty_day_total, 'previous_thirty_day_total' => $previous_thirty_day_total, 'this_year_total' => $this_year_total, 'last_year_total' => $last_year_total, 'this_financial_year_total' => $this_financial_year_total, 'last_financial_year_total' => $last_financial_year_total, 'position_diffeence' => $position_difference, 'year_difference_percent' => $year_difference_percent, 'financial_year_difference_percent' => $financial_year_difference_percent, 'projected_fy_earnings' => $projected_fy_earnings, 'projected_fy_earnings_percent' => $projected_fy_earnings_percent, 'active_invoices' => $active_invoices, 'active_quotes' => $active_quotes, 'user_activity' => $user_activity]);
}