private static function monthlySales() { $thisMonth = date("Y-m"); $lastMonth = date("Y-m", strtotime($thisMonth . ' -1 day')); $thisMonthSales = 0; $lastMonthSales = 0; //Orders from today $thisMonthOrders = DB::table('orders')->where('created_at', 'like', "{$thisMonth}%")->get(); foreach ($thisMonthOrders as $month) { $thisMonthSales += Order::find($month->id)->orderCost(); } //Orders from yesterday $lastMonthOrders = DB::table('orders')->where('created_at', 'like', "{$lastMonth}%")->get(); foreach ($lastMonthOrders as $lastMonth) { $lastMonthSales += Order::find($lastMonth->id)->orderCost(); } $percentage = @round(($lastMonthSales - $thisMonthSales) / $lastMonthSales * 100, 2); //determine if percentage is up or down. //This passes a value which determines which sign is displayed. $diff = 'none'; if ($percentage > 0) { $diff = 'down'; $percentage = abs($percentage); } else { if ($percentage < 0) { $diff = 'up'; $percentage = abs($percentage); } else { $diff = 'none'; $percentage = abs($percentage); } } $stats = array('sales' => number_format($thisMonthSales, 2), 'percentage' => $percentage, 'diff' => $diff); return $stats; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $order = Order::find($id); $order->delete(); Session::flash('message', 'Order Deleted!'); return Redirect::to(URL::previous()); }