PHP Model_Order::save方法代碼示例

 public function action_commit()
 {
     $user_id = \Session::get(self::SESSION_KEY_USER_ID);
     $user = Model_Member::find($user_id);
     $address = \Session::get(self::SESSION_KEY_ADDRESS);
     /*------make order----------------------------------------------------------*/
     $order = new Model_Order();
     $order->member_id = $user->id;
     $order->postalcode = $address['postalcode'];
     $order->destination = $address['address'] . $address['billname'] . $address['companyname'];
     $date = time();
     $order->order_date = date('Y-m-d H:i:s', $date);
     $order->print_flag = 0;
     $order->status = 0;
     $order->save();
     /*-----make orderline------------------------*/
     $cart = \Session::get(self::SESSION_KEY_CART);
     foreach ($cart['orders'] as $orderline) {
         $item_id = $orderline['item_id'];
         $item = Model_Item::find($item_id);
         $num = $orderline['quantity'];
         $size = $orderline['size'];
         $neworderline = new Model_Orderline();
         $neworderline->order_id = $order->id;
         $neworderline->item_id = $item_id;
         $neworderline->num = $num;
         $neworderline->size = $size;
         $neworderline->save();
         $earning = new Model_Earning();
         $earning->member_id = $user->id;
         $earning->item_id = $item_id;
         $earning->size = $size;
         switch ($size) {
             case 'S':
                 $unit_price = $neworderline->item->unit_price_s;
                 break;
             case 'M':
                 $unit_price = $neworderline->item->unit_price_m;
                 break;
             case 'L':
                 $unit_price = $neworderline->item->unit_price_m;
                 break;
             default:
                 $unit_price = $neworderline->item->unit_price;
                 break;
         }
         $earning->unit_price = $unit_price;
         $earning->num = $num;
         $earning->date = date('Y-m-d H:i:s', $date);
         $earning->category = $item->category;
         $earning->item_name = $item->name;
         $now = date('Ymd');
         $birthday = date('Ymd', strtotime($user->birthday));
         $earning->age = (int) floor(($now - $birthday) / 10000);
         $earning->save();
     }
     \Session::delete(self::SESSION_KEY_CART);
     return Response::redirect('index.php/message/commit');
 }

 public function setOrderServiceCompleteAction()
 {
     $sn = strtoupper(trim($this->_getParam('sn')));
     $result = 0;
     $ofd = new Model_OrderForDriver($sn);
     $order = new Model_Order($sn);
     if ($ofd->exists() && $ofd->get('driver_code') == $this->code && $order->get('status') < Model_Order::STATUS_SERVICE_COMPLATE) {
         $order->set('status', Model_Order::STATUS_SERVICE_COMPLATE);
         $result = $order->save();
     }
     $this->sendResult($result);
 }

 /**
  *
  * view affiliates and payments
  */
 public function action_pay()
 {
     //create an order and mark it as paid to the user_id
     if (is_numeric($this->request->param('id'))) {
         //get the user
         $user = new Model_User($this->request->param('id'));
         if ($user->loaded()) {
             //commissions due to pay
             $query = DB::select(DB::expr('SUM(amount) total'))->from('affiliates')->where('id_user', '=', $user->id_user)->where('date_to_pay', '<', Date::unix2mysql())->where('status', '=', Model_Affiliate::STATUS_CREATED)->group_by('id_user')->execute();
             $due_to_pay = $query->as_array();
             $due_to_pay = isset($due_to_pay[0]['total']) ? $due_to_pay[0]['total'] : 0;
             if ($due_to_pay > 0) {
                 //create the order
                 $order = new Model_Order();
                 $order->id_user = $user->id_user;
                 $order->amount = $due_to_pay * -1;
                 //we add the order as a negative, since we pay, we don't get paid.
                 $order->currency = 'USD';
                 $order->paymethod = 'paypal';
                 $order->pay_date = Date::unix2mysql();
                 $order->notes = 'Affiliate Commissions';
                 $order->status = Model_Order::STATUS_PAID;
                 try {
                     $order->save();
                     //update the commissions
                     DB::update('affiliates')->set(array('date_paid' => Date::unix2mysql(), 'status' => Model_Affiliate::STATUS_PAID, 'id_order_payment' => $order->id_order))->where('id_user', '=', $user->id_user)->where('date_to_pay', '<', Date::unix2mysql())->where('status', '=', Model_Affiliate::STATUS_CREATED)->execute();
                     Alert::set(Alert::SUCCESS, __('Commission Paid'));
                 } catch (Exception $e) {
                 }
             }
         }
     }
     $this->template->title = __('Affiliates Payments');
     $query = DB::select(DB::expr('SUM(amount) total'))->select('id_user')->from('affiliates')->where('date_to_pay', '<', Date::unix2mysql())->where('status', '=', Model_Affiliate::STATUS_CREATED)->group_by('id_user')->having('total', '>=', core::config('affiliate.payment_min'))->execute();
     $users_to_pay = $query->as_array('id_user');
     $total_to_pay = 0;
     foreach ($users_to_pay as $key => $value) {
         $total_to_pay += $value['total'];
     }
     $users = new Model_User();
     if (count($users_to_pay)) {
         $users = $users->where('id_user', 'in', array_keys($users_to_pay))->where('status', '=', Model_User::STATUS_ACTIVE)->find_all();
     }
     $this->render('oc-panel/pages/affiliate/pay', array('users' => $users, 'total_to_pay' => $total_to_pay, 'users_to_pay' => $users_to_pay));
 }

 /**
  * creates an order
  * @param  Model_Ad $ad    
  * @param  Model_User $user          
  * @param  integer   $id_product  
  * @param  numeric   $amount      
  * @param  string   $currency    
  * @param  string   $description 
  * @return Model_Order                
  */
 public static function new_order(Model_Ad $ad, $user, $id_product, $amount, $currency = NULL, $description = NULL, $featured_days = NULL)
 {
     if ($currency === NULL) {
         $currency = core::config('payment.paypal_currency');
     }
     if ($description === NULL) {
         $description = Model_Order::product_desc($id_product);
     }
     //get if theres an unpaid order for this product and this ad
     $order = new Model_Order();
     $order->where('id_ad', '=', $ad->id_ad)->where('id_user', '=', $user->id_user)->where('status', '=', Model_Order::STATUS_CREATED)->where('id_product', '=', $id_product)->where('amount', '=', $amount)->where('currency', '=', $currency)->limit(1)->find();
     //if no unpaid create order
     if (!$order->loaded()) {
         //add coupon ID and discount only if not AD_SELL
         if (Model_Coupon::valid($id_product)) {
             $amount = Model_Coupon::price($id_product, $amount);
             $order->id_coupon = Model_Coupon::current()->id_coupon;
         }
         //create order
         $order = new Model_Order();
         $order->id_user = $user->id_user;
         $order->id_ad = $ad->id_ad;
         $order->id_product = $id_product;
         $order->currency = $currency;
         $order->amount = $amount;
         $order->description = $description;
         //store how many days the ad is featured
         if ($featured_days !== NULL and is_numeric($featured_days)) {
             $order->featured_days = $featured_days;
         }
         try {
             $order->save();
         } catch (Exception $e) {
             throw HTTP_Exception::factory(500, $e->getMessage());
         }
         //send email to user with link to pay
         $url_checkout = $user->ql('default', array('controller' => 'ad', 'action' => 'checkout', 'id' => $order->id_order));
         $replace = array('[ORDER.ID]' => $order->id_order, '[ORDER.DESC]' => $order->description, '[URL.CHECKOUT]' => $url_checkout);
         //$user->email('new-order',$replace);
     }
     return $order;
 }

 public function action_commit()
 {
     $orders = \Session::get(self::ORDER);
     if (count($orders['cart']) == 0) {
         Response::redirect('index.php/controlsystem/order/order');
     }
     $post = $_POST;
     $order = new Model_Order();
     $order->postalcode = $post['postalcode1'] . '-' . $post['postalcode2'];
     $order->destination = $post['address'];
     $order->print_flag = false;
     $order->status = false;
     $date = date("Y-m-d", time());
     $order->order_date = $date;
     $customer = Model_Member::query()->where('name', $post['customer_name'])->get_one();
     if (!empty($customer)) {
         $order->member_id = $customer->id;
     } else {
         $order->member_id = null;
     }
     $order->save();
     $order_id = $order->id;
     //make orderlines
     $orders = \Session::get(self::ORDER);
     foreach ($orders['cart'] as $orderline) {
         $item_id = $orderline['item_id'];
         $item = Model_Item::find($item_id);
         $num = $orderline['num'];
         $size = strtoupper($orderline['size']);
         $neworderline = new Model_Orderline();
         $neworderline->order_id = $order->id;
         $neworderline->item_id = $item_id;
         $neworderline->num = $num;
         $neworderline->size = $size;
         $neworderline->save();
         $earning = new Model_Earning();
         if (!empty($customer)) {
             $earning->member_id = $customer->id;
         } else {
             $earning->member_id = null;
         }
         $earning->item_id = $item_id;
         $earning->size = $size;
         switch ($size) {
             case 'S':
                 $unit_price = $neworderline->item->unit_price_s;
                 break;
             case 'M':
                 $unit_price = $neworderline->item->unit_price_m;
                 break;
             case 'L':
                 $unit_price = $neworderline->item->unit_price_m;
                 break;
             default:
                 $unit_price = $neworderline->item->unit_price;
                 break;
         }
         $earning->unit_price = $unit_price;
         $earning->num = $num;
         $earning->date = $date;
         $earning->category = $item->category;
         $earning->item_name = $item->name;
         $now = date('Ymd');
         if (!empty($customer)) {
             $birthday = date('Ymd', strtotime($customer->birthday));
             $earning->age = (int) floor(($now - $birthday) / 10000);
         } else {
             $birthday = null;
             $earning->age = 0;
         }
         $earning->save();
     }
     return View::forge('controlsystem/order/commit');
 }

 /**
  * [new_order description]
  * @param  Model_User    $user    [description]
  * @param  Model_Product $product [description]
  * @param  boolean       check_match_product, if set to false will update the order with the product if different
  * @return [type]                 [description]
  */
 public static function new_order(Model_User $user, Model_Product $product, $match_product = TRUE)
 {
     $order = new Model_Order();
     if ($user->loaded() and $product->loaded()) {
         //get if theres an unpaid order for this user we wwill use it..
         $order->where('id_user', '=', $user->id_user)->where('status', '=', Model_Order::STATUS_CREATED);
         //also check that matches the product for the order
         if ($match_product === TRUE) {
             $order->where('id_product', '=', $product->id_product)->where('amount', '=', $product->final_price())->where('currency', '=', $product->currency);
         }
         $order->limit(1)->find();
         //order didnt exist so lets create it.
         if ($order->loaded() === FALSE) {
             //create order
             $order = new Model_Order();
             $order->id_user = $user->id_user;
         }
         // no matter what happens if product is different save! this will also save the order if its new ;)
         if ($order->id_product != $product->id_product) {
             $order->ip_address = ip2long(Request::$client_ip);
             $order->id_product = $product->id_product;
             $order->currency = $product->currency;
             //add coupon ID and discount
             if (Model_Coupon::current()->loaded()) {
                 $order->id_coupon = Model_Coupon::current()->id_coupon;
             }
             $order->amount = $product->final_price();
             $order->VAT = euvat::vat_percentage();
             $order->VAT_number = $user->VAT_number;
             $order->country = $user->country;
             $order->city = $user->city;
             $order->postal_code = $user->postal_code;
             $order->address = $user->address;
             try {
                 $order->save();
             } catch (Exception $e) {
                 throw HTTP_Exception::factory(500, $e->getMessage());
             }
         }
     }
     return $order;
 }

 public function orderDetailAction()
 {
     $this->view->activeMenu = 'orders';
     $sn = trim($this->_getParam('sn'));
     if (empty($sn)) {
         $this->error('SN Does not exists.');
         return;
     }
     $order = new Model_Order($sn);
     if (!$order->exists() || $order->get('user_id') != $this->user->get('id')) {
         $this->error('Order does not exists.');
         return;
     }
     $this->view->order = $order;
     $ofd = new Model_OrderForDriver($sn);
     $driverAssigned = false;
     $vehicleAssigned = false;
     if ($ofd->exists() && !empty($ofd->get('driver_code'))) {
         $driverAssigned = new Model_Driver($ofd->get('driver_code'));
     }
     if ($ofd->exists() && !empty($ofd->get('vehicle_id'))) {
         $vehicleAssigned = new Model_Vehicle($ofd->get('vehicle_id'));
     }
     $this->view->driverAssigned = $driverAssigned;
     $this->view->vehicleAssigned = $vehicleAssigned;
     $this->view->vehicleTypes = (new Model_VehicleType())->fetchPagedList(1, 999999)['rows'];
     if (!$this->_request->isXmlHttpRequest()) {
         return;
     }
     // edit order
     $arp = new AjaxResponse();
     $arp->setStatus(AjaxResponse::STATUS_FAILED);
     $availableParams = array('forwho', 'city', 'contact-name', 'contact-email', 'contact-phone', 'passenger-names', 'passenger-phone', 'passenger-num', 'when', 'pickup-address', 'dropoff-address', 'vehicle', 'payment-method', 'notes');
     $via = $this->_getParam('via-address');
     $viaToSave = array();
     if (is_array($via)) {
         foreach ($via as $k => $v) {
             if (!empty($v)) {
                 $viaToSave[] = $v;
             }
         }
     }
     $via = json_encode($viaToSave);
     foreach ($availableParams as $paramName) {
         $value = trim($this->getParam($paramName, ''));
         $colName = str_replace('-', '_', $paramName);
         $order->set($colName, $value);
     }
     $order->set('via', $via);
     $order->save();
     $arp->setStatus(AjaxResponse::STATUS_OK);
     $arp->setMessage($sn);
     $this->json($arp);
 }

 protected function saveEnrol($iAccountId, $iUserId, $aMeals, $sDayEnd)
 {
     $aMealIdsAll = array();
     // get submited meals id
     for ($i = 0; $i < 7; $i++) {
         if (isset($_POST['day' . $i])) {
             $aMealIdsAll = array_merge($aMealIdsAll, $_POST['day' . $i]);
         }
     }
     // wyszukujemy zamowienia
     $aOrderedMeals = array();
     $aOrderIndex = array();
     $oOrder = new Model_Order();
     $oCourse = new Model_Course();
     $iIndex = 0;
     $sDate = '';
     // rozpoczynamy transakcje
     $oOrder->transaction(true);
     // iterujemy po posilkach w danym tyg.
     foreach ($aMeals as $iMealId => $aMeal) {
         // sprawdzamy czy data nie jest starsza niz obecna
         if (strtotime($aMeal['date'] . ' ' . $sDayEnd) < time()) {
             continue;
         }
         // sprawdzamy czy zmieniono danie na obecny dzien
         if ($aMeal['date'] == date('Y-m-d')) {
             // czyscimy tekst paska informacyjnego
             $this->oCurrentUser->propertie('aMealName', '');
         }
         // zmieniamy na kolejny dzien index tablicy $aMealIds
         if ($sDate != $aMeal['date']) {
             // czyscimy zapisy na wszystkie dania tego dnia
             $oOrder->removeEnrols($iAccountId, $iUserId, $aMeal['date']);
             $sDate = $aMeal['date'];
             $iIndex++;
         }
         // sprawdzamy czy posilek z danego tyg zostal wybrany przez uzytkownika
         if (in_array($iMealId, $aMealIdsAll)) {
             // zapisujemy nowy
             $oOrder->reset();
             $oOrder->date = $aMeal['date'];
             $oOrder->user_id = (int) $this->oCurrentUser->user_id;
             $oOrder->meal_id = (int) $iMealId;
             $oOrder->price = (double) $aMeal['price'];
             $oOrder->account_id = (int) $this->oCurrentUser->account_id;
             if (!$oOrder->save()) {
                 throw new Lithium_Exception('catering.saving_failed');
             }
             // sprawdzamy ilosc zamowien na ten dzien
             $iCount = $oOrder->countOrders((int) $this->oCurrentUser->user_id, $aMeal['date']);
             if ($iCount > 1) {
                 $aOrders = $oOrder->getOrdersForDiscount((int) $this->oCurrentUser->user_id, $aMeal['date']);
                 foreach ($aOrders as $aOrder) {
                     $aOrder['discount'] = (int) $aOrder['discount'];
                     // gdy znizka rowna 0 nie ma co przeliczac
                     if ($aOrder['discount']) {
                         $oOrder->reset();
                         $oOrder->order_id = $aOrder['order_id'];
                         $oOrder->price = round($aOrder['price'] * $aOrder['discount'] / 100, 2);
                         if (!$oOrder->save()) {
                             //								throw new Lithium_Exception( 'catering.saving_failed' );
                         }
                     }
                 }
             }
         }
     }
     if (!$oOrder->transaction()) {
         throw new Lithium_Exception('save_meals_failed');
     }
     $aMeta = $this->mTemplate->aMeta;
     $aMeta[] = '<meta http-equiv="refresh" content="1;url=' . $this->mTemplate->anchor() . '" />';
     $this->mTemplate->aMeta = $aMeta;
     $this->mTemplate->content = $this->getLang('save_meals_successfully');
 }

 /**
  * pay an invoice, renders the paymenthods button, anyone with an ID of an order can pay it, we do not have control
  * @return [type] [description]
  */
 public function action_checkout()
 {
     $order = new Model_Order($this->request->param('id'));
     if ($order->loaded()) {
         //if paid...no way jose
         if ($order->status != Model_Order::STATUS_CREATED) {
             Alert::set(Alert::INFO, __('This order was already paid.'));
             $this->redirect(Route::url('default'));
         }
         //update order based on the price and the amount of
         $days = core::get('featured_days');
         if (is_numeric($days) and ($price = Model_Order::get_featured_price($days)) !== FALSE) {
             $order->amount = $price;
             //get price from config
             $order->featured_days = $days;
             $order->save();
         }
         //template header
         $this->template->title = __('Checkout') . ' ' . Model_Order::product_desc($order->id_product);
         Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Home'))->set_url(Route::url('default')));
         Breadcrumbs::add(Breadcrumb::factory()->set_title($this->template->title));
         Controller::$full_width = TRUE;
         $this->template->bind('content', $content);
         $this->template->content = View::factory('pages/ad/checkout', array('order' => $order));
     } else {
         //throw 404
         throw HTTP_Exception::factory(404, __('Page not found'));
     }
 }

 public function editOrderForDriverAction()
 {
     $sn = $this->_getParam('sn');
     if (empty($sn)) {
         $this->error('nothing to edit');
         return;
     }
     $order = new Model_Order($sn);
     $ofd = new Model_OrderForDriver($sn);
     $ofd->set('sn', $sn);
     $availableParams = array('driver-code', 'vehicle-id', 'contact-name', 'contact-phone', 'pickup-address', 'pickup-coordinates', 'dropoff-address', 'dropoff-coordinates', 'payment-method', 'notes');
     foreach ($availableParams as $paramName) {
         $value = trim($this->_getParam($paramName, ''));
         $colName = str_replace('-', '_', $paramName);
         $ofd->set($colName, $value);
     }
     $when = strtotime(trim($this->_getParam('when', '')));
     $ofd->set('when', $when);
     $via = trim($this->_getParam('via', ''));
     $viaArray = explode("\n", $via);
     foreach ($viaArray as $k => $v) {
         $viaArray[$k] = trim($v);
         if (empty($viaArray[$k])) {
             unset($viaArray[$k]);
         }
     }
     $ofd->set('via', json_encode($viaArray));
     $viaCoordinates = trim($this->_getParam('via-coordinates', ''));
     $viaCoordinatesArray = explode("\n", $viaCoordinates);
     foreach ($viaCoordinatesArray as $k => $v) {
         $viaCoordinatesArray[$k] = trim($v);
         if (empty($viaCoordinatesArray[$k])) {
             unset($viaCoordinatesArray[$k]);
         }
     }
     $ofd->set('via_coordinates', json_encode($viaCoordinatesArray));
     $ofd->save();
     if ($this->_getParam('driver-code', '') && $order->get('status') < Model_Order::STATUS_DRIVER_ASSIGNED) {
         $order->set('status', Model_Order::STATUS_DRIVER_ASSIGNED);
         $order->save();
     }
     $this->_redirect('order-detail?sn=' . $sn);
 }

 protected function saveOrders($iAccountId, $iUserId, $aMeals)
 {
     $aMealIdsAll = array();
     // get submited meals id
     for ($i = 0; $i < 7; $i++) {
         if (isset($_POST['day' . $i])) {
             $aMealIdsAll = array_merge($aMealIdsAll, $_POST['day' . $i]);
         }
     }
     // wyszukujemy zamowienia
     $aOrderedMeals = array();
     $aOrderIndex = array();
     $oOrder = new Model_Order();
     $oCourse = new Model_Course();
     $iIndex = 0;
     $sDate = '';
     // rozpoczynamy transakcje
     $oOrder->transaction(true);
     // iterujemy po posilkach w danym tyg.
     foreach ($aMeals as $iMealId => $aMeal) {
         // zmieniamy na kolejny dzien index tablicy $aMealIds
         if ($sDate != $aMeal['date']) {
             // czyscimy zapisy na wszystkie dania tego dnia
             $oOrder->removeEnrols($iAccountId, $iUserId, $aMeal['date']);
             $sDate = $aMeal['date'];
             $iIndex++;
         }
         // sprawdzamy czy posilek z danego tyg zostal wybrany przez uzytkownika
         if (in_array($iMealId, $aMealIdsAll)) {
             // zapisujemy nowy
             $oOrder->reset();
             $oOrder->date = $aMeal['date'];
             $oOrder->user_id = (int) $iUserId;
             $oOrder->meal_id = (int) $iMealId;
             $oOrder->price = (double) $aMeal['price'];
             $oOrder->account_id = (int) $iAccountId;
             if (!$oOrder->save()) {
                 throw new Lithium_Exception('Catering.saving_failed');
             }
             // sprawdzamy ilosc zamowien na ten dzien
             $iCount = $oOrder->countOrders((int) $iUserId, $aMeal['date']);
             if ($iCount > 1) {
                 $aOrders = $oOrder->getOrdersForDiscount((int) $iUserId, $aMeal['date']);
                 foreach ($aOrders as $aOrder) {
                     $aOrder['discount'] = (int) $aOrder['discount'];
                     // gdy znizka rowna 0 nie ma co przeliczac
                     if ($aOrder['discount']) {
                         $oOrder->reset();
                         $oOrder->order_id = $aOrder['order_id'];
                         $oOrder->price = round($aOrder['price'] * $aOrder['discount'] / 100, 2);
                         if (!$oOrder->save()) {
                             //								throw new Lithium_Exception( 'catering.saving_failed' );
                         }
                     }
                 }
             }
         }
     }
     if (!$oOrder->transaction()) {
         if (IN_PRODUCTION) {
             return false;
         } else {
             throw new Lithium_Exception('catering.saving_failed');
         }
     }
     return true;
 }

 /**
  * Tests to ensure that a saved order cannot have new products added to it
  *
  * @return null
  */
 public function test_saved_order_is_fixed()
 {
     // Create a new product first
     $product = new Model_Vendo_Product();
     $product->set_fields(array('name' => 'Unit Test', 'price' => '9.99', 'description' => 'This is a unit test.', 'order' => '1'));
     $product->save();
     $order = new Model_Order();
     $order->user_id = self::$user->id;
     $order->address_id = self::$user->address_id;
     $order->contact_id = self::$contact->id;
     $order->add_product($product, 1);
     $order->save();
     try {
         $order->add_product($product, 1);
     } catch (Exception $e) {
         $this->assertEquals('Saved orders cannot be modified!', $e->getMessage());
         $order->delete();
         $product->delete();
         return;
     }
     $order->delete();
     $product->delete();
     $this->fail('Orders cannot be modified once saved.');
 }