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