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);
}
