Esempio n. 1
0
 private function delinquent(Request $request)
 {
     //$branchs = Branch::orderBy('code')->get(['code', 'descriptor', 'id']);
     $branchs = $this->branch->all(['code', 'descriptor', 'id']);
     $arr = [];
     $arr_wl = [];
     $arr_wo = [];
     $arr_wd = [];
     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']);
         if (is_null($backup)) {
             array_push($arr_wo, ['code' => $branch->code, 'descriptor' => $branch->descriptor, 'branchid' => $branch->id, 'filename' => null, 'uploaddate' => null, 'date' => null]);
         } else {
             //$d = filename_to_date2($backup->filename);
             //$date = Carbon::parse($d->format('Y-m-d').' '.$backup->uploaddate->format('H:i:s'));
             $a = ['code' => $branch->code, 'descriptor' => $branch->descriptor, 'branchid' => $branch->id, 'filename' => $backup->filename, 'uploaddate' => $backup->uploaddate, 'date' => $backup->date];
             $diff = $backup->date->diffInDays($this->dr->now, false);
             if ($diff > 1) {
                 array_push($arr_wd, $a);
             } else {
                 array_push($arr_wl, $a);
             }
             // push latest
         }
     }
     $arr_wo = array_values(array_sort($arr_wo, function ($value) {
         return $value['code'];
     }));
     $arr_wl = array_values(array_reverse(array_sort($arr_wl, function ($value) {
         return $value['uploaddate'];
     })));
     $arr_wd = array_values(array_sort($arr_wd, function ($value) {
         return $value['date'];
     }));
     return collect([$arr_wo, $arr_wl, $arr_wd]);
 }
Esempio n. 2
0
 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]);
 }