PHP Products::getAllInfo方法代码示例

 public function ProductImage($productid, $maxWidth = 100, $maxHeight = 100, $showall = false)
 {
     $NS = new Zend_Session_Namespace('Default');
     $this->view->width = $maxWidth;
     $this->view->height = $maxHeight;
     $this->view->showall = $showall;
     $this->view->resources = ProductsMedia::getMediabyProductId($productid, "*", $NS->langid);
     $this->view->productdata = Products::getAllInfo($productid, $NS->langid);
     return $this->view->render('partials/media.phtml');
 }

 public function get($productid)
 {
     $this->authenticate();
     if (empty($productid)) {
         throw new Shineisp_Api_Exceptions(400002, ":: 'productid' field");
         exit;
     }
     $product = new Products();
     $details = $product->getAllInfo($productid);
     $details['ProductsUpgrades'] = ProductsUpgrades::getItemsbyProductID($productid);
     return $details;
 }

 public static function getRefundInfo($orderid)
 {
     $service = self::getDetail($orderid);
     $product = $service['Products'];
     $productid = $product['product_id'];
     $productInfo = Products::getAllInfo($productid);
     $isrefundable = intval($productInfo['isrefundable']);
     $priceRefund = 0;
     if ($isrefundable > 0) {
         $pricePaid = $service['price'];
         $date = explode(' ', $service['date_start']);
         $date = array_shift($date);
         list($yyyy, $mm, $dd) = explode('-', $date);
         $tsStartService = mktime(0, 0, 0, $mm, $dd, $yyyy);
         $date = explode(' ', $service['date_end']);
         $date = array_shift($date);
         list($yyyy, $mm, $dd) = explode('-', $date);
         $tsEndService = mktime(0, 0, 0, $mm, $dd, $yyyy);
         $tsToday = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
         $dayService = round(($tsEndService - $tsStartService) / (60 * 60 * 24));
         $priceServiceForDay = $pricePaid / $dayService;
         $tsRemain = 0;
         $priceRefund = false;
         if ($tsEndService > $tsToday) {
             $dayRemain = round(($tsEndService - $tsToday) / (60 * 60 * 24));
             $priceRefund = round($priceServiceForDay * $dayRemain, 2);
         }
     }
     $result = array('productid' => $productid, 'refund' => $priceRefund);
     return $result;
 }

 /**
  * saveAll
  * Save all the data in the database
  * @param array $params
  * @param integer $id
  */
 public static function saveAll($params, $id = "")
 {
     $orders = new Orders();
     $translator = Shineisp_Registry::getInstance()->Zend_Translate;
     $currentStatus = "";
     try {
         // Set the new values
         if (is_numeric($id)) {
             $orders = Doctrine::getTable('Orders')->find($id);
             $currentStatus = $orders->status_id;
             // used to detect status changes
         }
         if (!empty($params) && is_array($params)) {
             $params['date_start'] = !empty($params['date_start']) ? $params['date_start'] : new Zend_Date();
             $params['order_date'] = !empty($params['order_date']) ? $params['order_date'] : new Zend_Date();
             $customer = Customers::getAllInfo($params['customer_id']);
             $isp_id = $customer['isp_id'];
             $orders->order_date = Shineisp_Commons_Utilities::formatDateIn($params['order_date']);
             $orders->customer_id = $params['customer_id'];
             $orders->isp_id = $isp_id;
             $orders->status_id = $params['status_id'];
             $orders->invoice_id = !empty($params['invoice_id']) ? $params['invoice_id'] : null;
             $orders->note = $params['note'];
             $orders->is_renewal = $params['is_renewal'] == 1 ? 1 : 0;
             $orders->expiring_date = Shineisp_Commons_Utilities::formatDateIn($params['expiring_date']);
             $orders->vat = $params['vat'];
             $orders->total = $params['total'];
             $orders->grandtotal = $params['total'] + $params['vat'];
             // Save the data
             $orders->save();
             $id = is_numeric($id) ? $id : $orders->getIncremented();
             // Status changed? Let's call set_status. This is needed to properly log all status change.
             if (isset($params['status_id']) && $params['status_id'] != $currentStatus) {
                 self::logStatusChange($id, $params['status_id']);
             }
             // Add a fastlink to a order
             $link_exist = Fastlinks::findlinks($id, 'orders');
             $link = new Fastlinks();
             if (count($link_exist) == 0) {
                 $link->controller = "orders";
                 $link->action = "edit";
                 $link->params = json_encode(array('id' => $id));
                 $link->customer_id = $params['customer_id'];
                 $link->sqltable = "orders";
                 $link->id = $id;
                 $link->code = Shineisp_Commons_Utilities::GenerateRandomString();
             } else {
                 $link = Doctrine::getTable('Fastlinks')->find($link_exist[0]['fastlink_id']);
                 $link->code = $params['fastlink'];
             }
             $link->save();
             // Save the message note and send an alert
             if (!empty($params['message'])) {
                 $order = self::getAllInfo($id, null, true);
                 $link = Fastlinks::findlinks($id, $params['customer_id'], 'orders');
                 $isp = Isp::find($isp_id);
                 $retval = Shineisp_Commons_Utilities::getEmailTemplate('order_message');
                 if ($retval) {
                     $in_reply_to = md5($id);
                     // Save the message written by the ISP owner
                     Messages::addMessage($params['message'], null, null, $id, null, $isp_id);
                     // Create the array with all the placeholders
                     $placeholders['fullname'] = $order[0]['Customers']['firstname'] . " " . $order[0]['Customers']['lastname'];
                     $placeholders['url'] = "http://" . $_SERVER['HTTP_HOST'] . "/index/link/id/" . $link[0]['code'];
                     $placeholders['orderid'] = sprintf("%03s", $id) . " - " . Shineisp_Commons_Utilities::formatDateOut($order[0]['order_date']);
                     $placeholders['messagetype'] = $translator->translate('Order Details');
                     $placeholders['message'] = $params['message'];
                     Shineisp_Commons_Utilities::sendEmailTemplate(Contacts::getEmails($order[0]['Customers']['customer_id']), 'order_message', $placeholders, $in_reply_to, null, null, null, $order[0]['Customers']['language_id']);
                     // Change the URL for the administrator
                     $placeholders['url'] = "http://" . $_SERVER['HTTP_HOST'] . "/admin/login/link/id/" . $link[0]['code'] . "/keypass/" . Shineisp_Commons_Hasher::hash_string($isp->email);
                     // Send a message to the administrator
                     Shineisp_Commons_Utilities::sendEmailTemplate($isp->email, 'order_message_admin', $placeholders, $in_reply_to);
                 }
             }
             // Saving the domain
             if (!empty($params['domains_selected'])) {
                 self::SaveDomainsDetails($params, $id);
             } else {
                 if (!empty($params['products'])) {
                     $date_end = null;
                     // Get the product information
                     $product = Products::getAllInfo($params['products']);
                     // Manage the details of the order
                     if (!empty($params['billingcycle_id'])) {
                         $months = BillingCycle::getMonthsNumber($params['billingcycle_id']);
                         // Add months to the starting date
                         if ($months > 0) {
                             $params['date_end'] = Shineisp_Commons_Utilities::add_date($params['date_start'], null, $months);
                         }
                     }
                     // Format the dates before to save them in the database
                     $params['date_end'] = Shineisp_Commons_Utilities::formatDateIn($params['date_end']);
                     $params['date_start'] = Shineisp_Commons_Utilities::formatDateIn($params['date_start']);
                     if (!empty($product['Taxes']['tax_id'])) {
//.........这里部分代码省略.........

 public function create($params)
 {
     $this->authenticate();
     $uuid = $params['uuid'];
     $customers = Customers::find($uuid);
     if (empty($customers)) {
         throw new Shineisp_Api_Exceptions(400006, ":: 'uuid' not valid");
         exit;
     }
     $trancheid = intval($params['trancheid']);
     $tranche = ProductsTranches::getTranchebyId($trancheid);
     if (empty($tranche)) {
         throw new Shineisp_Api_Exceptions(400006, ":: 'trancheid' not valid");
         exit;
     }
     #Check Products
     if (empty($params['products']) && !is_array($params['products'])) {
         throw new Shineisp_Api_Exceptions(400006, ":: not 'products' choose");
         exit;
     }
     foreach ($params['products'] as $product) {
         $productid = intval($product['productid']);
         $billingid = intval($product['billingid']);
         $ttry = ProductsTranches::getTranchesBy_ProductId_BillingId($productid, $billingid);
         if (empty($ttry)) {
             throw new Shineisp_Api_Exceptions(400006, ":: 'productid' or 'bilingid' not valid");
             exit;
         }
         $ttry = array_shift($ttry);
         if ($ttry['tranche_id'] != $trancheid) {
             throw new Shineisp_Api_Exceptions(400006, ":: 'bilingid' not valid");
             exit;
         }
     }
     $id = $customers['customer_id'];
     $isVATFree = Customers::isVATFree($id);
     if ($params['status'] == "complete") {
         $status = Statuses::id('complete', 'orders');
     } else {
         $status = Statuses::id('tobepaid', 'orders');
     }
     $theOrder = Orders::create($customers['customer_id'], $status, $params['note']);
     foreach ($params['products'] as $product) {
         $productid = intval($product['productid']);
         $billingid = intval($product['billingid']);
         $quantity = intval($product['quantity']);
         $p = Products::getAllInfo($productid);
         Orders::addItem($productid, $quantity, $billingid, $trancheid, $p['ProductsData'][0]['name'], array());
     }
     $orderID = $theOrder['order_id'];
     if ($params['sendemail'] == 1) {
         Orders::sendOrder($orderID);
     }
     $banks = Banks::find($params['payment'], "*", true);
     if (!empty($banks[0]['classname'])) {
         $class = $banks[0]['classname'];
         if (class_exists($class)) {
             // Get the payment form object
             $banks = Banks::findbyClassname($class);
             $gateway = new $class($orderID);
             $gateway->setFormHidden(true);
             $gateway->setRedirect(true);
             $gateway->setUrlOk($_SERVER['HTTP_HOST'] . "/orders/response/gateway/" . md5($banks['classname']));
             $gateway->setUrlKo($_SERVER['HTTP_HOST'] . "/orders/response/gateway/" . md5($banks['classname']));
             $gateway->setUrlCallback($_SERVER['HTTP_HOST'] . "/common/callback/gateway/" . md5($banks['classname']));
             return $gateway->CreateForm();
         }
     }
     throw new Shineisp_Api_Exceptions(400006, ":: bad request");
     exit;
 }

 /**
  * Check the product and redirect the user to the right destination
  */
 public function addAction()
 {
     try {
         $isVATFree = false;
         $session = new Zend_Session_Namespace('Default');
         if (empty($session->cart)) {
             $session->cart = new Cart();
         }
         // Get the sent parameters
         $request = $this->getRequest()->getParams();
         if (!empty($request['product_id']) && is_numeric($request['product_id'])) {
             // Check the quantity value posted
             if (!empty($request['quantity']) && is_numeric($request['quantity'])) {
                 // Get all the info about the product selected
                 $product = Products::getAllInfo($request['product_id']);
                 // Check if the user has been logged in
                 if (!empty($this->customer['customer_id'])) {
                     // Set the customer for the active cart
                     $session->cart->setCustomer($this->customer['customer_id']);
                     // Check if the user is VAT free
                     $isVATFree = Customers::isVATFree($session->cart->getCustomerId());
                 }
                 $priceInfo = Products::getPriceSelected($request['product_id'], $request['term'], $isVATFree);
                 $item = new CartItem();
                 if ($session->cart->getItem($request['product_id'])) {
                     $item = $session->cart->getItem($request['product_id']);
                     $session->cart->updateItem($item, $item->getQty() + 1);
                 } else {
                     // Add the items to the cart:
                     $item->setId($request['product_id'])->setSku($product['sku'])->setName($product['ProductsData'][0]['name'])->setCost($product['cost'])->setTerm($request['term'])->setQty($request['quantity'])->setUnitprice($priceInfo['unitprice'])->setTaxId($product['tax_id'])->setSetupfee($priceInfo['setupfee'])->setType(Products::getProductType($request['product_id']));
                     $session->cart->addItem($item);
                 }
                 // Check if a hosting product is present in the cart
                 if ($session->cart->getCustomer()) {
                     $this->_helper->redirector('summary', 'cart', 'default');
                 } else {
                     $this->_helper->redirector('contacts');
                 }
             }
             // Quantity is not correct and the user is redirected to the homepage
             $this->_helper->redirector('index', 'index', 'default');
         }
     } catch (Exception $e) {
         $this->_helper->redirector('index', 'index', 'default', array('mex' => $e->getMessage()));
     }
 }

 /**
  * export the content in a excel file
  * @param array $items
  */
 public function bulk_xml($items = array())
 {
     // Get the records from the customer table
     $data = self::get_customers($items);
     $xml = new ExSimpleXMLElement('<shineisp></shineisp>');
     $customers = $xml->addChild('customers');
     foreach ($data as $item) {
         $customer = $customers->addChild('customer');
         $customer->addAttribute('id', $item['customer_id']);
         $customer->addChildCData('company', $item['company']);
         $customer->addChild('firstname', $item['firstname']);
         $customer->addChild('lastname', $item['lastname']);
         $customer->addChild('gender', $item['gender']);
         $customer->addChild('email', $item['email']);
         $customer->addChild('password', $item['password']);
         $customer->addChild('birthdate', $item['birthdate']);
         $customer->addChild('birthplace', $item['birthplace']);
         $customer->addChild('birthdistrict', $item['birthdistrict']);
         $customer->addChild('birthcountry', $item['birthcountry']);
         $customer->addChild('birthnationality', $item['birthnationality']);
         $customer->addChild('taxpayernumber', $item['taxpayernumber']);
         $customer->addChild('vat', $item['vat']);
         $customer->addChild('birthnationality', $item['birthnationality']);
         $ctype = $customer->addChild('companytype', $item['CompanyTypes']['name']);
         $ctype->addAttribute('type_id', $item['type_id']);
         $legalform = $customer->addChild('companytype', $item['Legalforms']['name']);
         $legalform->addAttribute('legalform_id', $item['legalform_id']);
         $status = $customer->addChild('companytype', $item['Statuses']['status']);
         $status->addAttribute('status_id', $item['status_id']);
         $cgroup = $customer->addChild('companytype', $item['CustomersGroups']['name']);
         $cgroup->addAttribute('group_id', $item['group_id']);
         $customer->addChildCData('note', $item['note']);
         $language = $customer->addChild('language', $item['Languages']['language']);
         $language->addAttribute('language_id', $item['language_id']);
         $customer->addChild('issubscriber', $item['issubscriber']);
         $customer->addChild('created_at', $item['created_at']);
         $customer->addChild('updated_at', $item['updated_at']);
         $customer->addChild('taxfree', $item['taxfree']);
         $addresses = $customer->addChild('addresses');
         foreach ($item['Addresses'] as $addr) {
             $address = $addresses->addChild('address');
             $address->addAttribute('address_id', $addr['address_id']);
             $address->addChild('address', $addr['address']);
             $address->addChild('city', $addr['city']);
             $address->addChild('postcode', $addr['code']);
             $address->addChild('countrycode', $addr['Countries']['code']);
             $country = $address->addChild('country', $addr['Countries']['name']);
             $country->addAttribute('country_id', $addr['country_id']);
             $address->addChild('area', $addr['area']);
             $address->addChild('latitude', $addr['latitude']);
             $address->addChild('longitude', $addr['longitude']);
         }
         $contacts = $customer->addChild('contacts');
         foreach ($item['Contacts'] as $cnt) {
             $contact = $contacts->addChild('contact');
             $contact->addAttribute('contact_id', $cnt['contact_id']);
             $mycnt = $contact->addChild('contact', $cnt['contact']);
             $mycnt->addAttribute('type_id', $cnt['type_id']);
             $mycnt->addAttribute('label', $cnt['ContactsTypes']['name']);
         }
         $orders = $customer->addChild('orders');
         foreach ($item['Orders'] as $odr) {
             $order = $orders->addChild('order');
             $order->addAttribute('order_id', $odr['order_id']);
             $order->addChild('order_date', $odr['order_date']);
             $order->addChild('total', $odr['total']);
             $order->addChild('cost', $odr['cost']);
             $order->addChild('vat', $odr['vat']);
             $order->addChild('grandtotal', $odr['grandtotal']);
             $details = $order->addChild('details');
             foreach ($odr['OrdersItems'] as $dtl) {
                 $detail = $details->addChild('detail');
                 $detail->addAttribute('detail_id', $dtl['detail_id']);
                 $detail->addAttribute('status_id', $dtl['status_id']);
                 $arrProduct = Products::getAllInfo($dtl['product_id']);
                 if (!empty($arrProduct)) {
                     $product = $detail->addChild('product');
                     $product->addAttribute('product_id', $dtl['product_id']);
                     $product->addAttribute('sku', $arrProduct['sku']);
                     if (!empty($arrProduct['ProductsData'])) {
                         $product->addChildCData('name', $arrProduct['ProductsData'][0]['name']);
                     }
                 }
                 $detail->addChild('date_start', $dtl['date_start']);
                 $detail->addChild('date_end', $dtl['date_end']);
                 $detail->addChild('quantity', $dtl['quantity']);
                 $detail->addChildCData('description', $dtl['description']);
                 $detail->addChild('cost', $dtl['cost']);
                 $detail->addChild('price', $dtl['price']);
                 $detail->addChild('setupfee', $dtl['setupfee']);
                 $detail->addChild('status_id', $dtl['status_id']);
             }
         }
     }
     $xml->saveXML(PUBLIC_PATH . "/tmp/customers.xml");
     if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
//.........这里部分代码省略.........

 /**
  * Get product info
  * @return Json
  */
 public function getproductinfoAction()
 {
     $ns = new Zend_Session_Namespace('Admin');
     $id = $this->getRequest()->getParam('id');
     $product = Products::getAllInfo($id, $ns->langid);
     die(json_encode($product));
 }

 /**
  * Calculate the subtotal for each product in the cart
  *
  * @param integer $id        	
  * @param integer $qty        	
  * @param boolean $isvatfree        	
  * @return ArrayObject
  */
 private function calcSubtotal(CartItem $item, $isvatfree = false)
 {
     foreach ($this->items as $item) {
         $isrecurring = false;
         $months = 0;
         $percentage = 0;
         $tax = 0;
         if ("domain" == $item->getType()) {
             $item->setIsrecurring(true);
             // Get the billyng cycle / term / recurring period price
             if ($item->getTerm()) {
                 $priceInfo = ProductsTranches::getTranchebyId($item->getTerm());
                 $item->setBillingid($priceInfo['BillingCycle']['billing_cycle_id']);
                 $months = $priceInfo['BillingCycle']['months'];
             } else {
                 $priceInfo = BillingCycle::getDefaultDomainBillingCycle();
                 $item->setBillingid($priceInfo['billing_cycle_id']);
                 $months = $priceInfo['months'];
             }
             $unitprice = $item->getUnitPrice();
             $setupfee = 0;
             // Calculate the price per Quantity
             $subtotal = $unitprice * $item->getQty();
             // check the taxes
             if (Taxes::get_percentage($item->getTaxId())) {
                 $percentage = Taxes::get_percentage($item->getTaxId());
                 $tax = $subtotal * $percentage / 100;
                 $price = $subtotal * (100 + $percentage) / 100;
             }
         } else {
             // Get all the product information
             $product = Products::getAllInfo($item->getId());
             // Check the type of the product and get the price information
             if ($product['ProductsAttributesGroups']['isrecurring']) {
                 $item->setIsrecurring(true);
                 // Get the billyng cycle / term / recurring period price
                 $priceInfo = ProductsTranches::getTranchebyId($item->getTerm());
                 // Price multiplier
                 $months = $priceInfo['BillingCycle']['months'];
                 $unitprice = $priceInfo['price'];
                 $setupfee = $priceInfo['setupfee'];
                 // Calculate the price per the months per Quantity
                 $subtotal = $unitprice * $months * $item->getQty();
                 $item->setBillingid($priceInfo['BillingCycle']['billing_cycle_id']);
             } else {
                 $item->setIsrecurring(false);
                 $unitprice = $product['price_1'];
                 $setupfee = $product['setupfee'];
                 // Calculate the price per Quantity
                 $subtotal = $unitprice * $item->getQty();
             }
             // check the taxes for each product
             if (!empty($product['tax_id']) && !$isvatfree) {
                 if (!empty($product['Taxes']['percentage']) && is_numeric($product['Taxes']['percentage'])) {
                     $percentage = $product['Taxes']['percentage'];
                     $tax = $subtotal * $percentage / 100;
                     $price = $subtotal * (100 + $percentage) / 100;
                 }
             }
         }
         // ... and add the setup fees
         $price = $subtotal + $setupfee;
         $item->setSubtotals(array('months' => $months, 'subtotal' => $subtotal, 'setupfee' => $setupfee, 'price' => $price, 'taxes' => $tax, 'percentage' => $percentage));
     }
     return $this->items;
 }

 public function create($params)
 {
     $this->authenticate();
     $uuid = $params['uuid'];
     $customers = Customers::findWithUuid($uuid);
     if (empty($customers)) {
         throw new Shineisp_Api_Exceptions(400006, ":: 'uuid' not valid");
         exit;
     }
     $trancheid = intval($params['trancheid']);
     $tranche = ProductsTranches::getTranchebyId($trancheid);
     if (empty($tranche)) {
         throw new Shineisp_Api_Exceptions(400006, ":: 'trancheid' not valid");
         exit;
     }
     #Check Products
     if (empty($params['products']) && !is_array($params['products'])) {
         throw new Shineisp_Api_Exceptions(400006, ":: not 'products' choose");
         exit;
     }
     foreach ($params['products'] as $product) {
         $productid = intval($product['productid']);
         $billingid = intval($product['billingid']);
         $ttry = ProductsTranches::getTranchesBy_ProductId_BillingId($productid, $billingid);
         if (empty($ttry)) {
             throw new Shineisp_Api_Exceptions(400006, ":: 'productid' or 'bilingid' not valid");
             exit;
         }
         $ttry = array_shift($ttry);
         if ($ttry['tranche_id'] != $trancheid) {
             throw new Shineisp_Api_Exceptions(400006, ":: 'bilingid' not valid");
             exit;
         }
     }
     $id = $customers['customer_id'];
     if ($params['status'] == "complete") {
         $status = Statuses::id('complete', 'orders');
     } else {
         $status = Statuses::id('tobepaid', 'orders');
     }
     $theOrder = Orders::create($customers['customer_id'], $status, $params['note']);
     foreach ($params['products'] as $product) {
         $productid = intval($product['productid']);
         $billingid = intval($product['billingid']);
         $quantity = intval($product['quantity']);
         $p = Products::getAllInfo($productid);
         $options = array('uuid' => $product['uuid']);
         $upgrade = false;
         if (array_key_exists('upgrade', $product) && $product['upgrade'] != false) {
             $orderItemsUpgrade = OrdersItems::findByUUID($product['upgrade']);
             $fromUpgrade = $orderItemsUpgrade->toArray();
             $upgrade = $fromUpgrade['detail_id'];
         }
         $ts_start = false;
         if (array_key_exists('ts_start', $product) && $product['ts_start'] != false) {
             $ts_start = $product['ts_start'];
         }
         Orders::addItem($productid, $quantity, $billingid, $trancheid, $p['ProductsData'][0]['name'], $options, $upgrade, $ts_start);
     }
     $orderID = $theOrder['order_id'];
     if ($params['sendemail'] == 1) {
         Orders::sendOrder($orderID);
     }
 }