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