public function show($projectId, $faultImprovementId)
{
$project = \App\Entities\Project::findOrFail($projectId);
$faultImprovement = \App\Entities\FaultImprovement::findOrFail($faultImprovementId);
$checklist = $faultImprovement->checkitem->checklist;
return view('fault-improvements.show', compact('project', 'faultImprovement', 'checklist'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
//To delete the table data before creating new ones
\App\Entities\ProjectNote::truncate();
\App\Entities\Project::truncate();
\App\Entities\Client::truncate();
\App\Entities\User::truncate();
factory(\App\Entities\User::class, 10)->create();
factory(\App\Entities\User::class)->create(['name' => 'Eduardo Junior', 'email' => '*****@*****.**', 'password' => bcrypt('test'), 'remember_token' => str_random(10)]);
factory(\App\Entities\Client::class, 10)->create();
factory(\App\Entities\Project::class, 10)->create();
factory(\App\Entities\ProjectNote::class, 50)->create();
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
}
public function works($projectId, Request $request)
{
$mainflowTypeId = $request->query('mainflow_type_id');
$detailingflowTypeId = $request->query('detailingflow_type_id');
$project = \App\Entities\Project::findOrFail($projectId);
$query = \App\Entities\ProjectWork::query();
if (!empty($mainflowTypeId)) {
$query->whereHas('detailingflowType', function ($query) use($mainflowTypeId) {
$query->whereMainflowTypeId($mainflowTypeId);
});
$mainflowTypeName = \App\Entities\MainflowType::findOrFail($mainflowTypeId)->name;
}
if (!empty($detailingflowTypeId)) {
$query->whereDetailingflowTypeId($detailingflowTypeId);
$detailingflowTypeName = \App\Entities\DetailingflowType::findOrFail($detailingflowTypeId)->name;
}
$works = $query->get();
return view('bids.works', compact('project', 'works', 'mainflowTypeName', 'detailingflowTypeName'));
}
public function hasMember($memberId, $projectId)
{
$member = Project::find($projectId)->members()->where('user_id', $memberId)->limit(1)->get();
return count($member) ? $member[0] : false;
}
public function show($projectId, $date)
{
$project = \App\Entities\Project::findOrFail($projectId);
return view('project-constructiondailies.show', compact('project', 'date'));
}
public function show($projectId, $workId)
{
$project = \App\Entities\Project::findOrFail($projectId);
$work = \App\Entities\ProjectWork::findOrFail($workId);
return view('project-works.show')->withProject($project)->withWork($work);
}
public function addMember($projectId, $userId)
{
return Project::find($projectId)->members()->attach($userId);
}
public function finance($id)
{
$project = Project::findOrFail($id);
return view('projects.finance')->withProject($project);
}
