/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
//
$reportCheck = ReportCheck::findOrFail($id);
$labmans = DB::table('users')->select('id', 'name')->get();
$POrecord = $reportCheck->POrecord;
$analysis = Analysis::where('POrecord_id', '=', $POrecord->id)->first();
$customersJoinQuery = DB::table('customers')->select(DB::raw('id AS c_id'), 'institute', 'department', 'c_name');
$usersJoinQuery = DB::table('users')->select(DB::raw('id AS u_id'), 'name');
$project = DB::table('projects')->leftJoin(DB::raw('(' . $customersJoinQuery->toSql() . ') i'), function ($join) {
$join->on('projects.Customer_id', '=', 'i.c_id');
})->leftJoin(DB::raw('(' . $usersJoinQuery->toSql() . ') j'), function ($join) {
$join->on('projects.salesman', '=', 'u_id');
})->where('projects.id', $POrecord->project->id)->first();
return view('research.reportCheck.edit')->with('project', $project)->with('labmans', $labmans)->with('POrecord', $POrecord)->with('analysis', $analysis)->with('reportCheck', $reportCheck);
}
