/** * all braches by date //dailysales/all */ public function allBranchByDate(Carbon $date) { $ads = []; // array of dailysales //$bb = Branch::orderBy('code', 'ASC')->get(); $bb = $this->branch->all(['code', 'descriptor', 'mancost', 'id']); //return $bb = $this->branch->getByCriteria(new ActiveBranch)->all(['code', 'descriptor', 'mancost', 'id']); foreach ($bb as $b) { // each bossbranch $ds = DailySales::whereBranchid($b->id)->where('date', $date->format('Y-m-d'))->first(); if (is_null($ds)) { $ads[$b->code]['ds'] = NULL; } $ads[$b->code]['ds'] = $ds; $ads[$b->code]['br'] = $b; } return array_sort_recursive($ads); return array_sort($ads, function ($value) { return $value; }); }