public function getClosed() { $previousRecord = ""; $data['previousRecord'] = $previousRecord; $nextRecord = ""; $data['nextRecord'] = $nextRecord; $purchaseordersCount = purchaseorder::where('status', 'closed')->count(); $data['purchaseordersCount'] = $purchaseordersCount; $data['orderType'] = "closed"; $purchaseorders = purchaseorder::where('status', 'closed')->get(); $data['purchaseorders'] = $purchaseorders; return view("tablelayout", $data); }
public function getOrder($id) { $match = ['purchaseorders_id' => $id]; $data['orders'] = orders::where($match)->get(); $data['total'] = $data['orders']->sum('amount'); $data['totalquantity'] = orders::where('purchaseorders_id', $id)->count(); $purchaseorder = purchaseorder::find($id); if ($purchaseorder->user_id != Auth::user()->id) { return redirect("/home"); } $data['purchaseOrder'] = $purchaseorder; $status = ""; switch ($data['purchaseOrder']->status) { case "pending": $status = "<b style = 'color:orange'>pending</b>"; break; case "cancelled": $status = "<b style = 'color:orange'>cancelled</b>"; break; case "on-delivery-process": $status = "<b style = 'color:green'>on-delivery-process</b>"; break; case "closed": $status = "<b style = 'color:green'>closed</b>"; break; } $data['status'] = $status; $deadlineColor = "black"; if ($purchaseorder->status == "pending" || $purchaseorder->status == "on-delivery-process") { $datetime1 = new DateTime(date("Y-m-d")); $datetime2 = new DateTime($purchaseorder->deadline); $interval = $datetime1->diff($datetime2); $days = $interval->days; if ($days < 3) { $deadlineColor = "red"; } else { if ($days < 5) { $deadlineColor = "orange"; } else { if ($days == 7) { $deadlineColor = "green"; } } } } $data['deadlineColor'] = $deadlineColor; return view('orderdetails', $data); }