public static function log($processname, $action, User $user, $fired_at, $field, $param, $param_id, $param_value, $start_quantity, $end_quantity, $table, $purpose) { $log['proccess'] = $processname; $log['action'] = $action; $log['user_name'] = $user->getName(); $log['user_id'] = $user->id; $log['field'] = $field; $log['fired_at'] = $fired_at; $log['param'] = $param; $log['table'] = $table; $log['param_value'] = $param_value; $log['param_id'] = $param_id; $log['start_quantity'] = $start_quantity; $log['end_quantity'] = $end_quantity; $log['message'] = $purpose; InventoryLog::create($log); }
public function generate(Request $r) { if ($r->has('check_list') && $r->has('reporttype') && $r->has('reporttarget') && $r->has('start_date') && $r->has('end_date')) { $ids = $r->get('check_list'); $input = $r->all(); $dompdf = new PDF(); $reporttype = $input['reporttype']; $reporttarget = ucfirst($input['reporttarget']); $table = 'bepc\\Models\\' . $reporttarget; $start_date = $input['start_date']; $end_date = $input['end_date']; switch ($input['reporttype']) { case 'Withdraw': case 'Deposit': $data = $this->{$input}['reporttarget']->findAll($ids); $log = []; foreach ($data as $item) { $log[$item->id] = \bepc\Models\InventoryLog::where('param_id', '=', $item['id'])->where('action', '=', strtolower($input['reporttype']))->where('table', '=', $table)->whereDate('created_at', '>=', $start_date)->whereDate('created_at', '<=', $end_date)->get(); } $pdf = PDF::loadView('self.blade.pdf.' . $input['reporttype'], compact('data', 'log', 'reporttype')); return $pdf->stream(); break; case 'Summary': break; case 'Delivery': break; case 'Purchase': break; case 'Inventory': $data = $this->{$input}['reporttarget']->findAll($ids); $log = []; foreach ($data as $item) { $log[$item->id] = \bepc\Models\InventoryLog::where('param_id', '=', $item['id'])->where('table', '=', $table)->whereDate('created_at', '>=', $start_date)->whereDate('created_at', '<=', $end_date)->get(); } $pdf = PDF::loadView('self.blade.pdf.' . $input['reporttype'], compact('data', 'log', 'reporttype')); return $pdf->stream(); break; default: break; } } else { return redirect()->back()->withErrors('Missing input. Try again'); } }
public function all() { return InventoryLog::all(); }