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); }