PHP comquick2cartHelper::getorderinfo方法代码示例

 function updatestatus($order_id, $status, $comment = '', $send_mail = 1, $store_id = 0)
 {
     global $mainframe;
     $params = JComponentHelper::getParams('com_quick2cart');
     $comquick2cartHelper = new comquick2cartHelper();
     switch ($status) {
         case 'C':
             /// to reduce stock
             $usestock = $params->get('usestock');
             $outofstock_allowship = $params->get('outofstock_allowship');
             if ($usestock == 1) {
                 $comquick2cartHelper->updateItemStock($order_id);
             }
             $comquick2cartHelper->updateStoreFee($order_id);
     }
     $mainframe = JFactory::getApplication();
     $db = JFactory::getDBO();
     if ($send_mail == 1) {
         if (!empty($store_id)) {
             $query = 'SELECT o.status FROM `#__kart_order_item` as o WHERE o.order_id =' . $order_id . ' AND o.`store_id`=' . $store_id . ' order by `order_item_id`';
             //die(" work is in progress(store product status change) die in helper ");
         } else {
             $query = "SELECT o.status FROM #__kart_orders as o WHERE o.id =" . $order_id;
         }
         $db->setQuery($query);
         $order_oldstatus = $db->loadResult();
     }
     $res = new stdClass();
     // UPDATING STORE ORDER CHANGES
     if (!empty($store_id)) {
         // change ORDER_ITEM STATUS// here i want order_item_id to update status of all order item releated to store
         $isOrderStatusChanged = $comquick2cartHelper->updateOrderItemStatus($order_id, $store_id, $status);
         if (empty($isOrderStatusChanged)) {
             //	return ;
         }
     } else {
         // IF admin changes ORDER status
         $res->status = $status;
         $res->id = $order_id;
         if (!$db->updateObject('#__kart_orders', $res, 'id')) {
             return 2;
         }
         $isOrderStatusChanged = $comquick2cartHelper->updateOrderItemStatus($order_id, 0, $status);
         // UPDATE ORDER ITEM STATUS ALSO
     }
     //START Q2C Sample development
     $query = "SELECT o.* FROM #__kart_orders as o WHERE o.id =" . $order_id;
     $db->setQuery($query);
     $orderobj = $db->loadObject();
     $dispatcher = JDispatcher::getInstance();
     JPluginHelper::importPlugin('system');
     $result = $dispatcher->trigger('Onq2cOrderUpdate', array($orderobj));
     //Call the plugin and get the result
     //END Q2C Sample development
     if ($send_mail == 1 && $order_oldstatus != $status) {
         $params = JComponentHelper::getParams('com_quick2cart');
         //$adminemails = comquick2cartHelper::adminMails();
         $query = "SELECT ou.user_id,ou.user_email,ou.firstname FROM #__kart_users as ou WHERE ou.address_type='BT' AND ou.order_id = " . $order_id;
         $db->setQuery($query);
         $orderuser = $db->loadObjectList();
         //Change for backward compatiblity for user info not saving order id against it
         if (empty($orderuser)) {
             $query = "SELECT ou.user_id,ou.user_email,ou.firstname\n\t\t\t\tFROM #__kart_users as ou \n\t\t\t\tWHERE ou.address_type='BT' AND ou.order_id IS NULL AND ou.user_id = (SELECT o.user_info_id FROM #__kart_orders as o WHERE o.id =" . $order_id . ")";
             $db->setQuery($query);
             $orderuser = $db->loadObjectList();
         }
         $orderuser = $orderuser[0];
         switch ($status) {
             case 'C':
                 $orderstatus = JText::_('QTC_CONFR');
                 /*for invoice*/
                 $jinput = JFactory::getApplication()->input;
                 $jinput->set('orderid', $order_id);
                 $order = $order_bk = $comquick2cartHelper->getorderinfo($order_id);
                 $this->orderinfo = $order['order_info'];
                 $this->orderitems = $order['items'];
                 $this->orders_site = 1;
                 $this->orders_email = 1;
                 $this->order_authorized = 1;
                 if ($this->orderinfo[0]->address_type == 'BT') {
                     $billemail = $this->orderinfo[0]->user_email;
                 } else {
                     if ($this->orderinfo[1]->address_type == 'BT') {
                         $billemail = $this->orderinfo[1]->user_email;
                     }
                 }
                 $fullorder_id = $order['order_info'][0]->prefix . $order_id;
                 if (!JFactory::getUser()->id && $params->get('guest')) {
                     $jinput->set('email', md5($billemail));
                 }
                 // check for view override
                 $view = $comquick2cartHelper->getViewpath('orders', 'invoice');
                 ob_start();
                 include $view;
                 $invoicehtml = ob_get_contents();
                 ob_end_clean();
                 /*for invoice*/
                 break;
             case 'RF':
                 $orderstatus = JText::_('QTC_REFUN');
//.........这里部分代码省略.........

 /**
  * Render view.
  *
  * @param   array  $tpl  An optional associative array of configuration settings.
  *
  * @since   1.0
  * @return   null
  */
 public function display($tpl = null)
 {
     $user = JFactory::getUser();
     $mainframe = JFactory::getApplication();
     require_once JPATH_SITE . '/components/com_quick2cart/helpers/media.php';
     // create object of media helper class
     $this->media = new qtc_mediaHelper();
     $model = $this->getModel('cartcheckout');
     $input = JFactory::getApplication()->input;
     $layout = $input->get('layout', '');
     // Send to joomla's registration of guest ckout is off
     if ($layout == 'cancel' || $layout == 'orderdetails') {
         $input->set('remote', 1);
         $sacontroller = new quick2cartController();
         $sacontroller->execute('clearcart');
     } else {
         $params = $this->params = JComponentHelper::getParams('com_quick2cart');
         $guestcheckout = $params->get('guest');
         if ($guestcheckout == 0 && !$user->id) {
             $itemid = $input->get('Itemid');
             // $uri=JRoute::_('index.php?option=com_quick2cart&view=cartcheckout&Itemid=' . $itemid,false);
             $rurl = 'index.php?option=com_quick2cart&view=cartcheckout&Itemid=' . $itemid;
             $returnurl = base64_encode($rurl);
             $mainframe->redirect(JRoute::_('index.php?option=com_users&return=' . $returnurl, false), $msg);
         }
         // GETTING CART ITEMS
         JLoader::import('cart', JPATH_SITE . DS . 'components' . DS . 'com_quick2cart' . DS . 'models');
         //			$cartmodel = new Quick2cartModelcart;
         //		$cart = $cartmodel->getCartitems();
         // Amol change
         $cartCheckoutModel = new Quick2cartModelcartcheckout();
         $cart = $cartCheckoutModel->getCheckoutCartitemsDetails();
         // Amol change end
         $this->cart = $cart;
         $session = JFactory::getSession();
         $cops = $session->get('coupon');
         if (!empty($cops)) {
             // Check for expiry
             $cop_array = array();
             foreach ($cops as $cop) {
                 $valid_coupan = $model->getcoupon($cop['code']);
                 if (!empty($valid_coupan)) {
                     $cop_array[] = $cop;
                 }
             }
             $this->coupon = $cop_array;
         } else {
             $this->coupon = array();
         }
         $user = JFactory::getUser();
         if ($user->id != 0) {
             $userdata = $model->userdata();
             $this->userdata = $userdata;
         }
         if ($layout == 'payment') {
             $orders_site = '1';
             $orderid = $session->get('order_id');
             $comquick2cartHelper = new comquick2cartHelper();
             $order = $comquick2cartHelper->getorderinfo($orderid);
             if (!empty($order)) {
                 if (is_array($order)) {
                     $this->orderinfo = $order['order_info'];
                     $this->orderitems = $order['items'];
                 } elseif ($order == 0) {
                     $this->undefined_orderid_msg = 1;
                 }
                 // $payhtml = $model->getpayHTML($order['order_info'][0]->processor,$orderid);
                 JLoader::import('payment', JPATH_SITE . DS . 'components' . DS . 'com_quick2cart' . DS . 'models');
                 $paymodel = new Quick2cartModelpayment();
                 $payhtml = $paymodel->getHTML($order['order_info'][0]->processor, $orderid);
                 $this->payhtml = $payhtml[0];
             } else {
                 $this->undefined_orderid_msg = 1;
             }
             $orders_site = '1';
             $this->orders_site = $orders_site;
             // Make cart empty
             JLoader::import('cart', JPATH_SITE . DS . 'components' . DS . 'com_quick2cart' . DS . 'models');
             $Quick2cartModelcart = new Quick2cartModelcart();
             $Quick2cartModelcart->empty_cart();
         } else {
             // START Q2C Sample development
             $dispatcher = JDispatcher::getInstance();
             JPluginHelper::importPlugin('system');
             // Call the plugin and get the result
             $result = $dispatcher->trigger('OnBeforeq2cCheckoutCartDisplay');
             $beforecart = '';
             if (!empty($result)) {
                 $beforecart = $result[0];
             }
             $this->beforecart = $beforecart;
             $result = $dispatcher->trigger('OnAfterq2cCheckoutCartDisplay');
//.........这里部分代码省略.........

 /**
  * public function to build Invoice HTML & send it to buyer
  *
  * @param   INTEGER  $order_id   order_id
  * @param   STRING   $status     status
  * @param   STRING   $comment    comment
  * @param   INTEGER  $send_mail  send_mail
  * @param   INTEGER  $store_id   store_id
  *
  * @return  boolean
  */
 public function sendInvoice($order_id, $status, $comment = '', $send_mail = 1, $store_id = 0)
 {
     $mainframe = JFactory::getApplication();
     $db = JFactory::getDBO();
     $params = JComponentHelper::getParams('com_quick2cart');
     $comquick2cartHelper = new comquick2cartHelper();
     // Load language file as require from backend add product.
     JFactory::getLanguage()->load('com_quick2cart', JPATH_SITE);
     // START Q2C Sample development
     $query = "SELECT o.* FROM #__kart_orders as o WHERE o.id =" . $order_id;
     $db->setQuery($query);
     $orderobj = $db->loadObject();
     // $adminemails = comquick2cartHelper::adminMails();
     $query = "SELECT ou.user_id,ou.user_email,ou.firstname FROM #__kart_users as ou WHERE ou.address_type='BT' AND ou.order_id = " . $order_id;
     $db->setQuery($query);
     $orderuser = $db->loadObjectList();
     // Change for backward compatiblity for user info not saving order id against it
     if (empty($orderuser)) {
         $query = "SELECT ou.user_id,ou.user_email,ou.firstname\n\t\tFROM #__kart_users as ou\n\t\tWHERE ou.address_type='BT' AND ou.order_id IS NULL AND ou.user_id = (SELECT o.user_info_id FROM #__kart_orders as o WHERE o.id =" . $order_id . ")";
         $db->setQuery($query);
         $orderuser = $db->loadObjectList();
     }
     $orderuser = $orderuser[0];
     $jinput = JFactory::getApplication()->input;
     $jinput->set('orderid', $order_id);
     $order = $order_bk = $comquick2cartHelper->getorderinfo($order_id);
     $this->orderinfo = $order['order_info'];
     $this->orderitems = $order['items'];
     $this->orders_site = 1;
     $this->orders_email = 1;
     $this->order_authorized = 1;
     if ($this->orderinfo[0]->address_type == 'BT') {
         $billemail = $this->orderinfo[0]->user_email;
     } elseif ($this->orderinfo[1]->address_type == 'BT') {
         $billemail = $this->orderinfo[1]->user_email;
     }
     $fullorder_id = $order['order_info'][0]->prefix . $order_id;
     if (!JFactory::getUser()->id && $params->get('guest')) {
         $jinput->set('email', md5($billemail));
         $this->calledFromOnePageCkout = 1;
     }
     // Check for view override
     $view = $comquick2cartHelper->getViewpath('orders', 'invoice');
     ob_start();
     include $view;
     $invoicehtml = ob_get_contents();
     ob_end_clean();
     $fullorder_id = $orderobj->prefix . $order_id;
     if (!empty($store_id)) {
         $productStatus = $comquick2cartHelper->getProductStatus($order_id);
         $body = JText::sprintf('QTC_STORE_PRODUCT_STATUS_CHANGE_BODY', $productStatus);
     } else {
         $body = JText::_('COM_QUICK2CART_INVOICE_BODY');
     }
     $site = $mainframe->getCfg('sitename');
     if ($comment) {
         $comment = str_replace('{COMMENT}', $comment, JText::_('QTC_COMMENT_TEXT'));
         $find = array('{ORDERNO}', '{STATUS}', '{SITENAME}', '{NAME}', '{COMMENTTEXT}');
         $replace = array($fullorder_id, JText::_('QTC_CONFR'), $site, $orderuser->firstname, $comment);
     } else {
         $find = array('{ORDERNO}', '{STATUS}', '{SITENAME}', '{NAME}', '{COMMENTTEXT}');
         $replace = array($fullorder_id, JText::_('QTC_CONFR'), $site, $orderuser->firstname, '');
     }
     $body = str_replace($find, $replace, $body);
     $guest_email = '';
     if (!$orderuser->user_id && $params->get('guest')) {
         $guest_email = "&email=" . md5($orderuser->user_email);
     }
     $Itemid = $comquick2cartHelper->getitemid('index.php?option=com_quick2cart&view=orders');
     $tempLink = JRoute::_('index.php?option=com_quick2cart&view=orders&layout=order' . $guest_email . '&orderid=' . $order_id . '&Itemid=' . $Itemid);
     $link = JUri::root() . substr($tempLink, strlen(JUri::base(true)) + 1);
     $order_link = '<a href="' . $link . '">' . JText::_('QTC_ORDER_GUEST_LINK') . '</a>';
     $body = str_replace('{LINK}', $order_link, $body);
     $body = nl2br($body);
     // GETTING BODY AND MAIL SUBJECT
     if (!empty($invoicehtml)) {
         $body = $body . '<div>' . JText::_('QTC_ORDER_INVOICE_IN_MAIL') . '</div>';
         $body = $body . $invoicehtml;
         $subject = JText::sprintf('QTC_INVOICE_MAIL_SUB', $site, $fullorder_id);
     } else {
         $subject = JText::sprintf('QTC_STATUS_CHANGE_SUBJECT', $fullorder_id);
     }
     // Call the plugin and get the result
     $dispatcher = JDispatcher::getInstance();
     JPluginHelper::importPlugin('system');
     $result = $dispatcher->trigger('OnBeforeq2cOrderUpdateEmail', array($orderobj, $subject, $body));
     if (!empty($result[0])) {
         $subject = $result[0][0];
         $body = $result[0][1];
//.........这里部分代码省略.........