public function pepsi(Request $request) { /* $components = ['062BFFD1637011E5B83800FF59FBB323', '063278FF637011E5B83800FF59FBB323', '0631FF85637011E5B83800FF59FBB323', '062C796C637011E5B83800FF59FBB323', '0615D0AA637011E5B83800FF59FBB323', '06163FD0637011E5B83800FF59FBB323']; */ $components = ['08BA6275637011E5B83800FF59FBB323', '08BABBC7637011E5B83800FF59FBB323', '08BA0B96637011E5B83800FF59FBB323', '061BC1EB637011E5B83800FF59FBB323', '06229D04637011E5B83800FF59FBB323', '06232D26637011E5B83800FF59FBB323', '08BD2EDD637011E5B83800FF59FBB323', '08BD8844637011E5B83800FF59FBB323', '08BDE48E637011E5B83800FF59FBB323', '08BE401B637011E5B83800FF59FBB323', '08BE97FC637011E5B83800FF59FBB323', '08BEEB6C637011E5B83800FF59FBB323']; $data = []; $branches = \App\Models\Branch::orderBy('code')->get(); if ($request->input('year') != '' && $request->input('branchid') != '') { foreach ($components as $key => $value) { $date = \Carbon\Carbon::parse($request->input('year') . '-01-01'); $results = \App\Models\Purchase2::select(DB::raw('date, SUM(qty) AS qty, SUM(tcost) AS tcost'))->where('componentid', $value)->where('branchid', $request->input('branchid'))->where(DB::raw('YEAR(date)'), $request->input('year'))->groupBy(DB::raw('YEAR(date)'))->groupBy(DB::raw('MONTH(date)'))->get(); for ($i = 0; $i < 12; $i++) { $filtered = $results->filter(function ($item) use($date) { return $item->date->format('Y-m') == $date->format('Y-m') ? $item : null; }); $data[$key][$date->format('Y-m-d')] = $filtered->first(); $date->addMonth(); } } } if ($request->input('data') != '') { return $data; } return view('blank')->with('branches', $branches)->with('data', $data); }
public function makeAddView(Request $request) { $branches = Branch::orderBy('code')->get(); return view('masterfiles.employee.add')->with('branches', $branches); }
public function delinquent(Request $request) { $branchs = Branch::orderBy('code')->get(['code', 'descriptor', 'id']); $arr = []; $arr_wd = []; $arr_wo = []; foreach ($branchs as $key => $branch) { $backup = Backup::where('branchid', $branch->id)->where('processed', 1)->orderBy('year', 'DESC')->orderBy('month', 'DESC')->orderBy('filename', 'DESC')->first(['filename', 'uploaddate']); //$arr[$key]['branch'] = $branch; //$arr[$key]['backup'] = $backup; if (is_null($backup)) { array_push($arr_wo, ['code' => $branch->code, 'descriptor' => $branch->descriptor, 'branchid' => $branch->id, 'filename' => null, 'uploaddate' => null, 'date' => null]); } else { array_push($arr_wd, ['code' => $branch->code, 'descriptor' => $branch->descriptor, 'branchid' => $branch->id, 'filename' => is_null($backup) ? '' : $backup->filename, 'uploaddate' => is_null($backup) ? '' : $backup->uploaddate, 'date' => is_null($backup) ? '' : $backup->uploaddate->format('Y-m-d H:i:s')]); } } $arr_wd = array_values(array_sort($arr_wd, function ($value) { return $value['date']; })); $arr_wo = array_values(array_sort($arr_wo, function ($value) { return $value['code']; })); //return view('backup.delinquent')->with('backups', collect($arr)); //$arr = [$arr_wo, $arr_wd]; return collect([$arr_wo, $arr_wd]); }