public function edit($id) { $sql = \DB::select("select s.id,s.consecutive, s.label, s.level, w.watersource_name as name, s.created_at from sampling s\n inner join watersource w on w.id = s.watersource_id\n inner join concession_watersource cw on cw.watersource_id = w.id\n inner join concession c on c.id = cw.concession_id\n inner join entity e on e.id = c.agent_id \n where s.analysis_id = " . $id); if (COUNT($sql) < 0) { $sql = \DB::select("select s.id, s.consecutive, s.label, s.level, ss.name, s.created_at from sampling s\n inner join sampling_site ss on ss.id = s.sampling_site_id\n inner join entity e on e.id = ss.agent_id\n where s.analysis_id = " . $id); } $view = Auth::user()->getView(); $analysis = Analysis::findOrFail($id); $entities = Entity::getEntities(); return view('analysis.edit', compact('view', 'analysis', 'entities', 'sql')); }
public function edit($id) { $view = Auth::user()->getView(); $resolutions = Resolution::all(); $files = File::all(); $fileTypes = Filetype::all(); $viabilities = Viability::all(); $entities = Entity::getEntities(); $concession = Concession::findOrFail($id); return view('concessions.edit', compact('resolutions', 'files', 'fileTypes', 'viabilities', 'concession', 'view', 'entities')); }