public function getResult(AdminRequest $request)
{
if ($request->referen != '') {
$referen = '';
} else {
$referen = $request->referen;
}
$resultado = Result::join('aud_validations', 'aud_results.validations_id', '=', 'aud_validations.id')->join('aud_anexo22', 'aud_validations.anexo22_id', '=', 'aud_anexo22.id')->join('aud_infractions', 'aud_anexo22.infractions_id', '=', 'aud_infractions.id')->leftjoin('aud_solutions', 'aud_results.id', '=', 'aud_solutions.results_id')->select('aud_solutions.id as idsol', 'res_referen', 'aud_results.id as id', 'a22_name', 'val_description', 'inf_fundament', 'inf_description', 'inf_valmax', 'res_status', 'inf_fine')->where('res_status', 0)->where('res_referen', 'like', '%' . $referen . '%')->orderby('res_referen')->get();
return view('results')->with(['result' => $resultado]);
}
public function show($id)
{
$detalle = Result::join('aud_validations', 'aud_results.validations_id', '=', 'aud_validations.id')->select('attribute_id')->where('aud_results.id', $id)->first();
return redirect()->back()->with('detalle', $detalle);
}
