public function destroyAll($id)
{
//
$Sequencings = Sequencing::where('POrecord_id', '=', $id)->get()->all();
$POrecord = $Sequencings[0]->POrecord;
foreach ($Sequencings as $Sequencing) {
$Sequencing->delete();
}
$POrecord->status = 'Library';
$POrecord->save();
return \Redirect::to('research/ngs/projects/show/' . $POrecord->project->id)->with('message', 'You have no Sequencing record!');
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$POrecord = POcase::findOrFail($id);
$Examination = Examination::where('POrecord_id', '=', $POrecord->id)->get()->toArray();
$ExaminationCheck = Examination::where('POrecord_id', '=', $POrecord->id)->get()->all();
$labmans = DB::table('users')->select('id', 'name')->get();
$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();
$user = User::find(\Auth::id());
$Sequencings = Sequencing::where('POrecord_id', '=', $POrecord->id)->get()->toArray();
$newSequencings = [];
foreach ($Sequencings as $Sequencing) {
$flag = 1;
foreach ($Examination as $Exam) {
if ($Exam['Sequencing_id'] == $Sequencing['id']) {
$flag = 0;
break;
}
}
if ($flag) {
array_push($newSequencings, $Sequencing);
}
}
return view('research.examination.edit')->with('user', $user)->with('project', $project)->with('labmans', $labmans)->with('POrecord', $POrecord)->with('newSequencings', $newSequencings)->with('Examination', $Examination)->with('ExaminationCheck', $ExaminationCheck);
}
