public function getTotalAmount($projectId) { $project = Project::findOrFail($projectId); $dailyLaborSets = $project->dailyLabors->groupBy('pivot.daily_labor_id'); $totalAmountSet = $dailyLaborSets->map(function ($dailyLabors) { return $dailyLabors->sum('pivot.amount'); }); return response()->json(['total_amount' => $totalAmountSet]); }
public function store($projectId, Request $request) { $project = Project::findOrFail($projectId); $dailyRecord = $project->dailyRecords()->whereDate((new DailyRecord())->getTable() . '.created_at', '=', new Carbon('today'))->first(); if ($dailyRecord) { $dailyRecord->update(['inspection_record' => $request->input('inspection_record'), 'important_record' => $request->input('important_record')]); } else { $project->dailyRecords()->create(['inspection_record' => $request->input('inspection_record'), 'important_record' => $request->input('important_record')]); } return response()->json(); }
public function getBouncesByProject($projectId, Request $request) { $project = Project::findOrFail($projectId); $query = $project->costEstimations(); if ($request->has('cost_estimation_id')) { $costEstimation = $project->costEstimations()->findOrFail($request->input('cost_estimation_id')); $query->whereDate('settled_at', '<=', $costEstimation->settled_at); } $costEstimations = $query->with('bounces')->get(); $results = $costEstimations->map(function ($costEstimation) { return $costEstimation->bounces; })->collapse()->map($this->getJsonTransformer()); return response()->json(['cost_estimation_bounces' => $results]); }
public function show($projectId, $checklistId) { $project = Project::findOrFail($projectId); $checklist = ProjectChecklist::findOrFail($checklistId); return view('project-checklists.show')->withProject($project)->withChecklist($checklist); }