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 update(ListRequest $request, $referen)
{
$empresa = Session::get('empresa');
$input = Input::all();
$pedimento = \DB::connection('users')->table('optr01')->select('ref_transport1', 'ref_tipo')->where('pk_referencia', $referen)->first();
$result = Checklist::where('chk_opera', $pedimento->ref_tipo)->where('chk_transport', $pedimento->ref_transport1)->get();
foreach ($result as $res) {
$doc = $input['id_' . $res->id];
$digital = 0;
$fisico = 0;
if (isset($input['exp_digital_' . $res->id])) {
$digital = $input['exp_digital_' . $res->id];
}
if (isset($input['exp_material_' . $res->id])) {
$fisico = $input['exp_material_' . $res->id];
}
Record::updateOrCreate(['exp_referen' => $referen, 'exp_document' => $doc], ['exp_material' => $fisico, 'exp_company' => $empresa, 'exp_digital' => $digital]);
//$id = 'chk'.$request->chk_id;
}
return redirect()->back();
}
public function storeState(Request $request)
{
$checklist = Checklist::where('record_id', $request->get('record_id'))->where('name', $request->get('page_id'))->first();
$patient = Record::find($request->get('record_id'));
$patient->update(['update_timestamp' => date('Y-m-d')]);
$update_checklist = Checklist::where('record_id', $request->get('record_id'))->where('name', $request->get('page_id'))->update(['record_id' => $request->get('record_id'), 'name' => $request->get('page_id'), 'description' => $request->get('page_name'), 'value' => $request->get('task')]);
return redirect()->back()->with('message', $request->get('page_name') . ' ' . 'status was successfully updated')->with('msg_type', 'success');
}
public static function showDemographics($record_id)
{
$record = Record::find($record_id);
if (Auth::user()->status == 'IDLE') {
Auth::user()->addStatus('BCW', $record->id);
}
// Check if there are checklist entries for this record
if (count($record->checklist) != count($record->getList())) {
// Delete first all related checklist
Checklist::where('record_id', $record->id)->delete();
// Generate list for this record
foreach ($record->getList() as $list) {
$record->checklist()->save(new Checklist($list));
}
}
$dispositions = Disposition::all();
$record = Record::find($record->id);
// Reinstantiate.. To reflect immediately the changes in checklist
return view('admin.demographics', compact('record', 'dispositions'));
}
