/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
$expensesss = Expense::where('project_id', '=', 0)->first();
$expensess = Expense::where('project_id', '=', 0)->orderBy('paid_on', 'desc')->get();
$clients = Client::orderBy('created_at', 'desc')->get();
$projects = Project::orderBy('created_at', 'desc')->get();
$expenses = Expense::where('project_id', '>', 0)->orderBy('paid_on', 'desc')->get();
$payments = Payment::orderBy('created_at', 'desc')->get();
$hours = Hour::where('amount_paid', '<', 0)->orderBy('day_worked', 'desc')->get();
return view('home', compact('projects', 'expenses', 'payments', 'hours', 'clients', 'expensess', 'expensesss'));
}
public function storepayment(CreatePaymentRequest $request)
{
$hour = Hour::find($request->employee_id);
$hourspaid = $hour->where('amount_paid', '=', '')->where('employee_id', '=', $request->employee_id)->sum('hours');
$hours = Hour::where('employee_id', '=', $request->employee_id)->where('amount_paid', '=', '')->groupBy('project_id')->get();
foreach ($hours as $hour) {
Expense::create(['project_id' => $hour->project_id, 'employee_id' => $request->employee_id, 'paid_on' => $request->paid_on, 'amount_paid' => round($request->amount_paid / $hourspaid * $hour->where('project_id', '=', $hour->project->id)->where('amount_paid', '=', '')->where('employee_id', '=', $request->employee_id)->sum('hours'), 2), 'reimbursment' => 2, 'office' => 2]);
}
$hours = Hour::where('employee_id', '=', $request->employee_id)->where('amount_paid', '=', '')->get();
foreach ($hours as $hour) {
$update = Hour::where('id', '=', $hour->id)->update(['amount_paid' => round($request->amount_paid / $request->hours * $hour->hours, 2)]);
}
//add a Pay Check table and send all $request info over
return view('hours.createpayment', compact('hours', 'hour', 'hourspaid'));
}
static function clientHours($hour_id)
{
$hour = Hour::where('id', $hour_id)->first();
return $hour;
}