public function show($referen)
{
$empresa = Session::get('empresa');
Checklist::where('chk_referen', $referen)->delete();
$documentos = \DB::connection('master')->table('mdb_tipodocum')->select('doc_clave', 'doc_nombre')->get();
foreach ($documentos as $doc) {
$result = Result::where('res_referen', $referen)->first();
if (!empty($result)) {
$validacion = Validation::where('attribute_id', 9)->where('id', $result->validations_id)->whereRaw('SUBSTRING_INDEX(val_data, "|", 1) = ' . $doc->doc_clave)->count();
if ($validacion > 0) {
$imagen = \DB::connection('users')->table('opauimg')->where('pk_referencia', $referen)->where('imgtipodoc', $doc->doc_clave)->count();
if ($imagen > 0) {
$check = 1;
} else {
$check = 0;
}
} else {
$check = 2;
}
} else {
$check = 0;
}
$data = ["chk_referen" => $referen, "chk_document" => $doc->doc_nombre, "chk_status" => $check, "chk_company" => $empresa];
Checklist::create($data);
}
$result = Checklist::where('chk_company', $empresa)->get();
return view('list_document')->with(['document' => $result, 'referen' => $referen]);
}
public function store(ListRequest $request)
{
$campos = $request->all();
Checklist::create($campos);
return redirect()->back();
}
