public function getLastestSales(Request $request, $day = 1) { $arr = []; $to = Carbon::now(); //$to = Carbon::parse('2016-03-6'); $fr = $to->copy()->subDay($day); $dss = DailySales::whereBetween('date', [$fr->format('Y-m-d'), $to->format('Y-m-d')])->where('branchid', $request->user()->branchid)->get(); foreach ($this->dateInterval($fr, $to) as $key => $date) { $filtered = $dss->filter(function ($item) use($date) { return $item->date->format('Y-m-d') == $date->format('Y-m-d') ? $item : null; }); $obj = new StdClass(); $obj->date = $date; $obj->dailysale = $filtered->first(); $arr[$key] = $obj; } return array_reverse($arr); }