コード例 #1
0
ファイル: zone.php プロジェクト: BetterBetterBetter/B3App
 function getRegionList($country_id)
 {
     $db = $this->getDbo();
     $data = $db->loadObjectList();
     //print"<pre>"; print_r($data);
     require_once JPATH_SITE . '/components/com_tjfields/helpers/geo.php';
     $tjGeoHelper = TjGeoHelper::getInstance('TjGeoHelper');
     $rows = $tjGeoHelper->getRegionList($country_id, 'com_quick2cart');
     return $rows;
 }
コード例 #2
0
ファイル: orders.php プロジェクト: BetterBetterBetter/B3App
 /**
  * Export order payment stats into a csv file.
  *
  * @return void
  *
  * @since 3.0
  */
 public function payment_csvexport()
 {
     $db = JFactory::getDBO();
     $lang = JFactory::getLanguage();
     $lang->load('com_quick2cart', JPATH_SITE);
     $query = $db->getQuery(true);
     $query->select("i.id, i.name, i.email, i.user_info_id,i.cdate, i.transaction_id, i.processor, i.order_tax, i.order_tax_details");
     $query->select("i.order_shipping, i.order_shipping_details,  i.amount, i.status, i.ip_address");
     $query->from('#__kart_orders AS i');
     $db->setQuery($query);
     $results = $db->loadObjectList();
     $csvDataString .= implode(";", $headColumn);
     $csvDataString .= "\n";
     $csvData = null;
     $csvData .= " Order_Id, Order_Date, User_Name, User_IP, Order_Tax, Order_Tax_details, Order_Shipping, Order_Shipping_details";
     $csvData .= ", Order_Amount, Order_Status, Payment_Gateway, Cart_Items, billing_email, billing_first_name, billing_last_name, billing_phone";
     $csvData .= ", billing_address, billing_city, billing_state, billing_country_name, billing_postal_code, shipping_email";
     $csvData .= ", shipping_first_name, shipping_last_name, shipping_phone";
     $csvData .= ", shipping_address, shipping_city, shipping_state, shipping_country_name, shipping_postal_code";
     $csvData .= "\n";
     $filename = "Orders_" . date("Y-m-d_H-i", time());
     header("Content-type: application/vnd.ms-excel");
     header("Content-disposition: csv" . date("Y-m") . ".csv");
     header("Content-disposition: filename=" . $filename . ".csv");
     // Get geo manager obj
     require_once JPATH_SITE . '/components/com_tjfields/helpers/geo.php';
     $tjGeoHelper = TjGeoHelper::getInstance('TjGeoHelper');
     foreach ($results as $result) {
         if ($result->id) {
             $order_tax_details = str_replace(",", ";", $result->order_tax_details);
             $order_shipping_details = addslashes(str_replace(",", ";", $result->order_shipping_details));
             $csvData .= '"' . $result->id . '"' . ',' . '"' . $result->cdate . '"';
             $csvData .= ',' . '"' . JFactory::getUser($result->user_info_id)->username . '"';
             $csvData .= ',' . '"' . $result->ip_address . '"' . ',' . '"' . $result->order_tax . '"';
             $csvData .= ',' . $order_tax_details . ',' . '"' . $result->order_shipping . '"';
             $csvData .= ',' . $order_shipping_details . ',' . '"' . $result->amount . '"' . ',';
             switch ($result->status) {
                 case 'C':
                     $orderstatus = JText::_('QTC_CONFR');
                     break;
                 case 'RF':
                     $orderstatus = JText::_('QTC_REFUN');
                     break;
                 case 'S':
                     $orderstatus = JText::_('QTC_SHIP');
                     break;
                 case 'P':
                     $orderstatus = JText::_('QTC_PENDIN');
                     break;
             }
             $query = "SELECT count(order_item_id) FROM #__kart_order_item WHERE order_id =" . $result->id;
             $db->setQuery($query);
             $cart_items = $db->loadResult();
             $csvData .= '"' . $orderstatus . '"' . ',' . '"' . $result->processor . '"' . ',' . '"' . $cart_items . '"' . ',';
             // 	Getting billind detail
             $query = $db->getQuery(true);
             $query->select("ou.*");
             $query->from('#__kart_users as ou');
             $query->where("ou.address_type='BT' AND ou.user_id =" . $result->user_info_id);
             $query->where("ou.order_id=" . $result->id);
             $query->order("id DESC");
             $db->setQuery($query);
             $billin = $db->loadObject();
             if ($billin) {
                 // Getting country and region names from their codes.
                 if (is_numeric($billin->country_code)) {
                     $billin->country_code = $tjGeoHelper->getCountryNameFromId($billin->country_code);
                 }
                 if (is_numeric($billin->state_code)) {
                     $billin->state_code = $tjGeoHelper->getRegionNameFromId($billin->state_code);
                 }
                 $csvData .= '"' . $billin->user_email . '"';
                 $csvData .= ',' . '"' . $billin->firstname . '"';
                 $csvData .= ',' . '"' . $billin->lastname . '"';
                 $csvData .= ',' . '"' . $billin->phone . '"';
                 $csvData .= ',' . '"' . $billin->address . '"';
                 $csvData .= ',' . '"' . $billin->city . '"';
                 $csvData .= ',' . '"' . $billin->state_code . '"';
                 $csvData .= ',' . '"' . $billin->country_code . '"';
                 $csvData .= ',' . '"' . $billin->zipcode . '"' . ',';
             }
             $query = $db->getQuery(true);
             $query->select("ou.*");
             $query->from('#__kart_users as ou');
             $query->where("ou.address_type='ST' AND ou.user_id =" . $result->user_info_id);
             $query->where("ou.order_id=" . $result->id);
             $query->order("id DESC");
             $db->setQuery($query);
             $shipping = $db->loadObject();
             if ($shipping) {
                 // Getting country and region names from their codes.
                 if (is_numeric($shipping->country_code)) {
                     $shipping->country_code = $tjGeoHelper->getCountryNameFromId($shipping->country_code);
                 }
                 if (is_numeric($shipping->state_code)) {
                     $shipping->state_code = $tjGeoHelper->getRegionNameFromId($shipping->state_code);
                 }
                 $csvData .= '"' . $shipping->user_email . '"';
                 $csvData .= ',' . '"' . $shipping->firstname . '"';
                 $csvData .= ',' . '"' . $shipping->lastname . '"';
                 $csvData .= ',' . '"' . $shipping->phone . '"' . ',';
                 $csvData .= '"' . $shipping->address . '"';
                 $csvData .= ',' . '"' . $shipping->city . '"';
                 $csvData .= ',' . '"' . $shipping->state_code . '"';
                 $csvData .= ',' . '"' . $shipping->country_code . '"';
                 $csvData .= ',' . '"' . $shipping->zipcode . '"' . ',';
             }
             print $csvData .= "\n";
         }
     }
     ob_clean();
     print $csvData;
     exit;
 }
コード例 #3
0
ファイル: orders.php プロジェクト: BetterBetterBetter/B3App
 function getCustomers($store_id)
 {
     $db = JFactory::getDBO();
     $query = $this->buildCustomer($store_id);
     if (!empty($query)) {
         $this->_data = $this->_getList($query, $this->getState('limitstart'), $this->getState('limit'));
         require_once JPATH_SITE . '/components/com_tjfields/helpers/geo.php';
         $tjGeoHelper = TjGeoHelper::getInstance('TjGeoHelper');
         foreach ($this->_data as $item) {
             $item->countryName = '';
             $item->countryName = $tjGeoHelper->getCountryNameFromId($item->country_code);
         }
         return $this->_data;
     } else {
         return;
     }
 }
コード例 #4
0
ファイル: zoneform.php プロジェクト: BetterBetterBetter/B3App
 /**
  * Get list of regions from given country
  *
  * @param   int  $country_id  Country id
  *
  * @return  array
  */
 public function getRegionList($country_id)
 {
     require_once JPATH_SITE . '/components/com_tjfields/helpers/geo.php';
     $tjGeoHelper = TjGeoHelper::getInstance('TjGeoHelper');
     $rows = $tjGeoHelper->getRegionList($country_id, 'com_quick2cart');
     return $rows;
 }
コード例 #5
0
 function getuserState($country_id)
 {
     if (!empty($country_id)) {
         /*$db = JFactory::getDBO();
         		$query="SELECT r.id,r.region FROM #__tj_region AS r LEFT JOIN #__tj_country as c
         		ON r.country_id=c.id where c.id=" . $country_id;
         		$db->setQuery($query);
         		$rows = $db->loadAssocList();*/
         require_once JPATH_SITE . '/components/com_tjfields/helpers/geo.php';
         $tjGeoHelper = TjGeoHelper::getInstance('TjGeoHelper');
         $rows = (array) $tjGeoHelper->getRegionList($country_id, 'com_quick2cart');
         return $rows;
     }
 }
コード例 #6
0
ファイル: helper.php プロジェクト: BetterBetterBetter/B3App
 /**
  * Method to add country name, region name.
  *
  * @param   string  &$orderlist  orderlist
  *
  * @since   2.2
  *
  * @return   null
  */
 public function addCountryRegionNames(&$orderlist)
 {
     require_once JPATH_SITE . '/components/com_tjfields/helpers/geo.php';
     $tjGeoHelper = TjGeoHelper::getInstance('TjGeoHelper');
     if (!empty($orderlist['order_info'])) {
         foreach ($orderlist['order_info'] as $key => $info) {
             // If country code contain text.
             $countryName = $info->country_code;
             if (is_numeric($info->country_code)) {
                 $countryName = $tjGeoHelper->getCountryNameFromId($info->country_code);
             }
             if ($countryName) {
                 // Generate new field
                 $orderlist['order_info'][$key]->country_name = $countryName;
             }
             // Get Region code.
             $stateName = $info->state_code;
             if (is_numeric($info->state_code)) {
                 $stateName = $tjGeoHelper->getRegionNameFromId($info->state_code);
             }
             if ($stateName) {
                 // Generate new field
                 $orderlist['order_info'][$key]->state_name = $stateName;
             }
         }
     }
     return $orderlist;
 }