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