PHP Orders::find方法代码示例

 public function indexAction()
 {
     $auth = $this->session->get('auth');
     $id = $auth[uid];
     $orders = Orders::find(array("conditions" => "u_id = :uid:", "bind" => array("uid" => $id), "order" => "o_id DESC"));
     $this->view->orders = $orders;
 }

 public function indexAction()
 {
     $undeliveredorders = Orders::find(array("o_delivery = 0", "order" => "o_id"));
     $this->view->undelivered = $undeliveredorders;
     $deliveredorders = Orders::find(array("o_delivery = 1", "order" => "o_id"));
     $this->view->delivered = $deliveredorders;
 }

 public function getSend($id)
 {
     date_default_timezone_set('Asia/Shanghai');
     $date = date('Y-m-d H:i:s');
     $order = Orders::find($id);
     $order->status = 'sent';
     $order->SendDate = $date;
     $order->save();
     return Redirect::to(URL::route('incomplete'));
 }

 public function indexAction()
 {
     $auth = $this->session->get('auth');
     $this->view->name = $auth[name];
     $date = date('Y-m-d');
     echo $date;
     $orders = Orders::find("o_delivery = 0");
     $nosorders = count($orders);
     $contact = Contact::find("co_status = 0");
     $noscontact = count($contact);
     $users = Userdetails::find();
     $nosusers = count($users);
     $result = Orders::sum(array('column' => 'o_price', "conditions" => "o_date = :date:", "bind" => array("date" => $date)));
     /*$phql="SELECT SUM(o_price) AS costs FROM Orders where o_date='2015-12-11'";
     	$result = $this->modelsManager->executeQuery($phql);*/
     $this->view->nosorders = $nosorders;
     $this->view->noscontact = $noscontact;
     $this->view->nosusers = $nosusers;
     $this->view->nossale = $result;
 }

 /**
  * Attach a hosting service to a domain name
  * 
  * 
  * @param integer $orderID
  * @param integer $domainID
  */
 public static function addDomain($orderID, $domainID)
 {
     if (is_numeric($orderID) && is_numeric($domainID)) {
         $order = Orders::find($orderID);
         if (!empty($order)) {
             foreach ($order->OrdersItems as $detail) {
                 // 	    			if ($detail->Products['type'] == "hosting") {
                 #if(FALSE === self::check_domains_in_order($orderID, $domainID)){
                 $domain = new OrdersItemsDomains();
                 $domain['domain_id'] = $domainID;
                 $domain['order_id'] = $orderID;
                 $domain['orderitem_id'] = $detail['detail_id'];
                 $domain->save();
                 #}
                 // 	    			}
             }
             return true;
         }
     }
     return false;
 }

 public function postFaxOrders()
 {
     $pid = Session::get('pid');
     if (Session::get('job_id') == FALSE) {
         $job_id = '';
     } else {
         $job_id = Session::get('job_id');
     }
     $orders_id = Input::get('orders_id');
     $html = $this->page_orders($orders_id)->render();
     $filename = __DIR__ . "/../../public/temp/orders_" . time() . "_" . Session::get('user_id') . ".pdf";
     $this->generate_pdf($html, $filename);
     while (!file_exists($filename)) {
         sleep(2);
     }
     $row1 = Orders::find($orders_id);
     if ($row1->orders_labs != '') {
         $file_original = "Laboratory Order";
     }
     if ($row1->orders_radiology != '') {
         $file_original = "Imaging Order";
     }
     if ($row1->orders_cp != '') {
         $file_original = "Cardiopulmonary Order";
     }
     if ($row1->orders_referrals != '') {
         $file_original = "Referral Order";
     }
     $row2 = Addressbook::find($row1->address_id);
     $result_message = $this->fax_document($pid, $file_original, 'yes', $filename, $file_original, $row2->fax, $row2->displayname, $job_id, 'yes');
     Session::forget('job_id');
     unlink($filename);
     echo $result_message;
 }

 public function cancelOrder($id)
 {
     $response = array();
     $output = array();
     try {
         /**
          * TODO: include user id to ensure validation before cancelling the order.
          */
         // Update the order in the database
         $order = Orders::find($id);
         $order->status = AppConstants::$avialable_status['cancelled'];
         $order->save();
         $response['response_code'] = ResponseCodes::$response_code['success']['code'];
         $response['response_message'] = ResponseCodes::$response_code['success']['response_message'];
         $response['output'] = $output;
         echo json_encode($response);
     } catch (Exception $e) {
         Log::error($e->getMessage());
         $response['response_code'] = ResponseCodes::$response_code['internal_server_error']['code'];
         $response['response_message'] = ResponseCodes::$response_code['internal_server_error']['response_message'];
         $response['output'] = $output;
         echo json_encode($response);
     }
 }

 /**
  * Create a new Order
  *
  * @return boolean
  */
 public function createOrder()
 {
     if (!$this->getOrderid()) {
         $theOrder = Orders::create($this->getCustomerId(), Statuses::id('tobepaid', 'orders'), null);
         // For each item in the cart
         foreach ($this->getItems() as $item) {
             $item = Orders::addOrderItem($item);
         }
         $this->setOrderid($theOrder['order_id']);
         // Send the email to confirm the order
         Orders::sendOrder($theOrder['order_id']);
         return Orders::getOrder();
     } else {
         return Orders::find($this->getOrderid());
     }
 }

 public function sendInvoice($uuid, $order_uuid = null, $service_uuid = null, $urlemail)
 {
     $this->authenticate();
     $customers = Customers::findWithUuid($uuid);
     if (empty($customers)) {
         throw new Shineisp_Api_Exceptions(400007, ":: 'uuid' not valid");
         exit;
     }
     $id = $customers['customer_id'];
     if ($order_uuid == null && $service_uuid == null) {
         throw new Shineisp_Api_Exceptions(400007, ":: 'order_uuid' not valid and 'service_uuid' not valid");
     }
     #TODO get order from $order_uuid
     if ($service_uuid != null) {
         $objService = OrdersItems::findByUUID($service_uuid);
         if ($objService == false) {
             return false;
         }
         $service = $objService->toArray();
         $orderid = $service['order_id'];
         $order = Orders::find($orderid);
         $fastlink = Invoices::sendInvoice($order->invoice_id, $urlemail);
     }
 }