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