public function getOrder($id) { $data['orders'] = orders::where('purchaseorders_id', $id)->get(); $previousOrder = ""; $nextOrder = ""; $data['previousOrder'] = $previousOrder; $data['nextOrder'] = $nextOrder; $data['total'] = $data['orders']->sum('amount'); $data['totalquantity'] = orders::where('purchaseorders_id', $id)->count(); $purchaseorder = purchaseorder::find($id); $data['purchaseOrder'] = $purchaseorder; $status = ""; $form = ""; // switch($data['purchaseOrder']->status){ // case "pending": // $status = "<b style = 'color:orange'>pending</b>"; // $form = "<form action = '' method = 'post'> // ".csrf_field()." // <input type = 'hidden' name = 'purchaseorders_id' value = '".$id."'/> // <input type = 'submit' name = 'btnProcessDelivery' value = 'Process delivery' /> // </form>"; // break; // case "cancelled": // $status = "<b style = 'color:orange'>cancelled</b>"; // $form = ""; // break; // case "on-delivery-process": // $status = "<b style = 'color:green'>on-delivery-process</b>"; // $form = "<form action = '' method = 'post'> // ".csrf_field()." // <input type = 'hidden' name = 'purchaseorders_id' value = '".$id."'/> // <input type = 'submit' name = 'btnClose' value = 'Close' /> // </form>"; // break; // case "closed": // $status = "<b style = 'color:green'>closed</b>"; // $form = ""; // 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; $data['audittrails'] = audittrail::where('purchaseorder_id', $purchaseorder->id)->get(); return view('orderdetails', $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); }