public function workmethod($id)
{
$doc = WmsDoc::findOrFail($id);
//return view('pdf.workmethod', compact('doc'));
$pdf = PDF::loadView('pdf.workmethod', compact('doc'));
$file = public_path('filebank/company/' . $doc->for_company_id . '/wms/' . $doc->name . ' v' . $doc->version . ' ref-' . $doc->id . ' ' . '.pdf');
if (file_exists($file)) {
unlink($file);
}
$pdf->save($file);
return $pdf->stream();
//return $pdf->download('invoice.pdf');
//PDF::loadHTML($html)->setPaper('a4')->setOrientation('landscape')->setOption('margin-bottom', 0)->save('myfile.pdf')
}
/**
* Get Steps for specific WMS doc
*/
public function getSteps(Request $request, $id)
{
$wms_doc = WmsDoc::findOrFail($id);
$steps = WmsStep::where('doc_id', $wms_doc->id)->get();
$wms_steps = [];
$wms_hazards = [];
$wms_controls = [];
foreach ($steps as $step) {
$array = [];
$array['id'] = $step->id;
$array['doc_id'] = $step->doc_id;
$array['name'] = $step->name;
$array['order'] = $step->order;
$array['master'] = $step->master;
$array['master_id'] = $step->master_id;
$wms_steps[] = $array;
// Hazards
$hazards = WmsHazard::where('step_id', $step->id)->get();
foreach ($hazards as $hazard) {
$array = [];
$array['id'] = $hazard->id;
$array['step_id'] = $step->id;
$array['name'] = $hazard->name;
$array['order'] = $hazard->order;
$array['master'] = $hazard->master;
$array['master_id'] = $hazard->master_id;
$wms_hazards[] = $array;
}
// Controls
$controls = WmsControl::where('step_id', $step->id)->get();
foreach ($controls as $control) {
$array = [];
$array['id'] = $control->id;
$array['step_id'] = $step->id;
$array['name'] = $control->name;
$array['order'] = $control->order;
$array['master'] = $control->master;
$array['master_id'] = $control->master_id;
$array['res_principle'] = $control->res_principle;
$array['res_company'] = $control->res_company;
$array['res_worker'] = $control->res_worker;
$wms_controls[] = $array;
}
}
$json = [];
$json[] = $wms_doc;
$json[] = $wms_steps;
$json[] = $wms_hazards;
$json[] = $wms_controls;
return $json;
}
