public function getAssignedOrders() { $input = Input::all(); $response = array(); try { $response['status'] = "1"; $response['msg'] = "Success"; $ApiRedis = new ApiRedis(); $db = $this->redisDb; $orderProcessed = $ApiRedis->getOrderSpliceQueue($input['zone_id'], $db); $orderIds = array(); $orders = array(); foreach ($orderProcessed['assigned'] as $k => $v) { if ($k > 0) { $orderHash = $ApiRedis->getOrderFromHash($k, $db); if (empty($orderHash['address'])) { $orderHash['address'] = ""; } $order[$k] = $orderHash; $orderIds[] = $k; } } if (count($orderIds) > 0) { $orderData = Order::select("order.id", "order.order_number", "order.market_office_city_delivery_zone_id", "customer.full_name", "driver.first_name", "driver.last_name", "order.customer_delivery_address", DB::raw("driver.id AS driver_id"))->join("customer", "customer.id", "=", "order.customer_id")->leftJoin('driver', 'driver.id', '=', 'order.driver_id')->whereIn("order.id", $orderIds)->get(); foreach ($orderData as $value) { $order[$value["id"]]["id"] = $value["id"]; $order[$value["id"]]["order_number"] = $value["order_number"] != "" ? $value["order_number"] : " "; $order[$value["id"]]["customer_name"] = $value["full_name"] != "" ? $value["full_name"] : " "; if ($value['last_name'] != null || $value['first_name'] != null) { $order[$value["id"]]["driver_name"] = $value["first_name"] . " " . $value["last_name"]; } else { $order[$value["id"]]["driver_name"] = ""; } $order[$value["id"]]["show_driver"] = true; if ($order[$value["id"]]["address"] == "") { $order[$value["id"]]["address"] = $value['customer_delivery_address'] != "" ? $value['customer_delivery_address'] : " "; } } } $response['orders'] = $order; } catch (Exception $e) { Log::error($e); $response['status'] = '0'; $msg = (array) $e->getMessage(); $response['msg'] = $msg[0]; } return Response::json($response); }
protected function getOrderHash($k, $v, $db) { $orderHash = array(); $ApiRedis = new ApiRedis(); $orderHash = $ApiRedis->getOrderFromHash($k, $db); $orderHash['destination_note'] = ""; if ($v == "3") { $orderHash['order_status'] = "Processing Unassigned"; } else { if ($v == "5") { $orderHash['order_status'] = "Assigned"; } else { if ($v == "6") { $orderHash['order_status'] = "Processing Assigned"; } else { if ($v == "7") { $orderHash['order_status'] = "Started"; } else { if ($v == "9") { $orderHash['order_status'] = "Cancelling"; } else { $orderHash['order_status'] = "Unassigned"; } } } } } if (empty($orderHash['address'])) { $orderHash['address'] = ""; } $orderHash["notes"] = ""; if (!empty($orderHash['reason'])) { $orderHash["notes"] .= "<img src='images/bullet.jpg'> " . $orderHash['reason'] . "<br>"; } if (!empty($orderHash['sms'])) { if ($orderHash['sms'] == true) { $orderHash["notes"] .= "<img src='images/bullet.jpg'> Late sms send."; } } $orderHash["notes"] = $orderHash["notes"] != "" ? $orderHash["notes"] : " "; return $orderHash; }