예제 #1
0
 function getOrderList()
 {
     global $application;
     $tables = modApiFunc('Checkout', 'getTables');
     $o = $tables['orders']['columns'];
     $request =& $application->getInstance('Request');
     $order_id_list = $request->getValueByKey('order_id');
     $export_all = $request->getValueByKey('export_all');
     //                                        id-
     $query = new DB_Select();
     $query->addSelectField($o['id'], 'id');
     if ($export_all == null || $export_all == 'false') {
         $query->WhereField($o['id'], DB_IN, ' (' . implode(',', $order_id_list) . ') ');
     }
     $result = $application->db->getDB_Result($query);
     $plain_list = array();
     foreach ($result as $item) {
         $plain_list[] = $item['id'];
     }
     return $plain_list;
 }
예제 #2
0
 /**
  * This function calculates hash from checkout form fields array.
  * @author Andrei V. Zhuravlev
  *
  */
 function updateCheckoutFormHash()
 {
     global $application;
     $tables = $this->getTables();
     $pa = $tables['person_attributes']['columns'];
     $piva = $tables['person_info_variants_to_attributes']['columns'];
     $s = new DB_Select();
     $s->addSelectTable('person_attributes');
     $s->addSelectTable('person_info_variants_to_attributes');
     $s->WhereField($piva['attribute_id'], DB_EQ, $pa['id']);
     $checkout_data = $application->db->getDB_Result($s);
     //query fields
     $hash = md5(serialize($checkout_data));
     /*$tables = Configuration::getTables();
             $ss = $tables['store_settings']['columns'];
     
             $u = new DB_Update('store_settings');
             $u->addUpdateValue('variable_value',$hash);
             $u->WhereValue('variable_name', DB_EQ, SYSCONFIG_CHECKOUT_FORM_HASH);
             $application->db->getDB_Result($u);*/
     $cache = CCacheFactory::getCache('hash');
     $cache->write(SYSCONFIG_CHECKOUT_FORM_HASH, $hash);
     return $hash;
 }
 /**
  *
  *
  * @author Alexandr Girin
  * @param
  * @return
  */
 function DeleteOrders($ordersId)
 {
     modApiFunc('EventsManager', 'throwEvent', 'OrdersWillBeDeleted', $ordersId);
     global $application;
     $tables = $this->getTables();
     $on = $tables['order_notes']['columns'];
     $opd = $tables['order_person_data']['columns'];
     $opr = $tables['order_prices']['columns'];
     $otx = $tables['order_taxes']['columns'];
     $otdo = $tables['order_tax_display_options']['columns'];
     $op = $tables['order_product']['columns'];
     $opca = $tables['order_product_custom_attributes']['columns'];
     $opta = $tables['order_product_to_attributes']['columns'];
     $opot = $tables['order_product_options']['columns'];
     $o = $tables['orders']['columns'];
     $DB_IN_string = "('" . implode("', '", $ordersId) . "')";
     $query = new DB_Select();
     $query->addSelectField($op['id'], 'id');
     $query->WhereField($op['order_id'], DB_IN, $DB_IN_string);
     $order_products_id = $application->db->getDB_Result($query);
     foreach ($order_products_id as $key => $order_product_id) {
         $order_products_id[$key] = $order_product_id['id'];
     }
     $query = new DB_Delete('order_notes');
     $query->WhereField($on['order_id'], DB_IN, $DB_IN_string);
     $application->db->getDB_Result($query);
     $query = new DB_Delete('order_person_data');
     $query->WhereField($opd['order_id'], DB_IN, $DB_IN_string);
     $application->db->getDB_Result($query);
     $query = new DB_Delete('order_prices');
     $query->WhereField($opr['order_id'], DB_IN, $DB_IN_string);
     $application->db->getDB_Result($query);
     $query = new DB_Delete('order_taxes');
     $query->WhereField($otx['order_id'], DB_IN, $DB_IN_string);
     $application->db->getDB_Result($query);
     $query = new DB_Delete('order_tax_display_options');
     $query->WhereField($otdo['order_id'], DB_IN, $DB_IN_string);
     $application->db->getDB_Result($query);
     $query = new DB_Delete('order_product');
     $query->WhereField($op['order_id'], DB_IN, $DB_IN_string);
     $application->db->getDB_Result($query);
     $query = new DB_Delete('order_product_custom_attributes');
     $query->WhereField($opca['product_id'], DB_IN, "('" . implode("', '", $order_products_id) . "')");
     $application->db->getDB_Result($query);
     $query = new DB_Delete('order_product_to_attributes');
     $query->WhereField($opta['product_id'], DB_IN, "('" . implode("', '", $order_products_id) . "')");
     $application->db->getDB_Result($query);
     $query = new DB_Select();
     $query->addSelectField($opot['option_value'], 'option_value');
     $query->WhereValue($opot['is_file'], DB_EQ, 'Y');
     $query->WhereAND();
     $query->Where($opot['order_product_id'], DB_IN, "('" . implode("', '", $order_products_id) . "')");
     $__res = $application->db->getDB_Result($query);
     if (count($__res) > 0) {
         foreach ($__res as $oinfo) {
             if ($oinfo['option_value'] != '') {
                 modApiFunc('Shell', 'removeDirectory', dirname($oinfo['option_value']));
             }
         }
     }
     $query = new DB_Delete('order_product_options');
     $query->WhereField($opot['order_product_id'], DB_IN, "('" . implode("', '", $order_products_id) . "')");
     $application->db->getDB_Result($query);
     modApiFunc("PromoCodes", "DeleteOrders", $ordersId);
     modApiFunc("TaxExempts", "DeleteOrders", $ordersId);
     modApiFunc('GiftCertificateApi', 'DeleteOrders', $ordersId);
     $query = new DB_Delete('orders');
     $query->WhereField($o['id'], DB_IN, $DB_IN_string);
     $application->db->getDB_Result($query);
 }
 /**
  *
  *
  * @return array -               .
  */
 function getPromoCodesListFull($b_active_only = true, $cost_type_id = NULL, $b_between_start_date_and_date_only = true, $b_times_to_use_greater_than_times_used = true, $promo_code_id = NULL, $use_paginator = false)
 {
     global $application;
     ///        $tables = call_user_func(array($__CLASS__, "getTables");
     $tables = $this->getTables();
     $tr = $tables['promo_codes_coupons_table']['columns'];
     $result_array = array();
     $query = new DB_Select();
     $query->addSelectField($tr["id"], "id");
     $query->addSelectField($tr["min_subtotal"], "min_subtotal");
     $query->addSelectField($tr["promo_code"], "promo_code");
     $query->addSelectField($tr["campaign_name"], "campaign_name");
     $query->addSelectField($tr["b_ignore_other_discounts"], "b_ignore_other_discounts");
     $query->addSelectField($tr["status"], "status");
     $query->addSelectField($tr["discount_cost"], "discount_cost");
     $query->addSelectField($tr["discount_cost_type_id"], "discount_cost_type_id");
     $query->addSelectField($tr["start_date"], "start_date");
     $query->addSelectField($tr["end_date"], "end_date");
     $query->addSelectField($tr["times_to_use"], "times_to_use");
     $query->addSelectField($tr["times_used"], "times_used");
     $query->addSelectField($tr["categories_affected"], "cats");
     $query->addSelectField($tr["products_affected"], "prods");
     $query->addSelectField($tr["free_shipping"], "free_shipping");
     $query->addSelectField($tr["free_handling"], "free_handling");
     $query->addSelectField($tr["strict_cart"], "strict_cart");
     $query->WhereValue('', '', '1');
     if ($cost_type_id !== NULL) {
         $query->WhereAnd();
         $query->WhereValue($tr["discount_cost_type_id"], DB_EQ, $cost_type_id);
     }
     if ($b_active_only === true) {
         $query->WhereAND();
         $query->WhereValue($tr["status"], DB_EQ, 1);
     }
     if ($b_times_to_use_greater_than_times_used === true) {
         $query->WhereAND();
         $query->WhereField($tr["times_to_use"], DB_GT, $tr["times_used"]);
     }
     if ($promo_code_id !== NULL) {
         $query->WhereAND();
         $query->WhereValue($tr["id"], DB_EQ, $promo_code_id);
     }
     if ($use_paginator == true) {
         $query = modApiFunc('paginator', 'setQuery', $query);
     }
     $query->SelectOrder($tr['id']);
     $result_rows = $application->db->getDB_Result($query);
     foreach ($result_rows as $row) {
         if ($b_between_start_date_and_date_only === true) {
             //         ,                                                     ,                .
             //                                .                   .
             //         ,                          0       0       0        start_date
             //                                    0       0       0        (end_date + 1     )           .
             if ($this->is_coupon_not_expired(strtotime($row['start_date']), strtotime($row['end_date'])) === true) {
                 $result_array[] = $row;
             } else {
                 //                                   ,                   .
             }
         } else {
             $result_array[] = $row;
         }
     }
     return $result_array;
 }
 /**
  * Gets a list of available info  block tags by all actions.
  *
  *@param array $actionsList - a list of all actions
  *
  *@return array - a list of tags associated with actions
  */
 function getAvailableTagsList($actionsList)
 {
     global $application;
     $tables = $this->getTables();
     $i2a = $tables['infotags_to_action']['columns'];
     $ni = $tables['notification_infotags']['columns'];
     $b2a = $tables['blocktags_to_action']['columns'];
     $nb = $tables['notification_blocktags']['columns'];
     $i2b = $tables['infotags_to_blocktag']['columns'];
     $tagsList = array();
     foreach ($actionsList as $actionInfo) {
         $tagsList[$actionInfo['Id']] = array();
         $query = new DB_Select();
         $query->addSelectField($ni['id'], 'Id');
         $query->addSelectField($ni['name'], 'InfoTag');
         $query->WhereField($ni['id'], DB_EQ, $i2a["ni_id"]);
         $query->WhereAnd();
         $query->WhereValue($i2a['na_id'], DB_EQ, $actionInfo['Id']);
         $result = $application->db->getDB_Result($query);
         $InfoTags = array();
         foreach ($result as $InfoTag) {
             $InfoTags[$InfoTag['Id']] = $InfoTag['InfoTag'];
         }
         $tagsList[$actionInfo['Id']]['InfoTags'] = $InfoTags;
         $query = new DB_Select();
         $query->addSelectField($nb['id'], 'Id');
         $query->addSelectField($nb['name'], 'BlockTag');
         $query->WhereField($nb['id'], DB_EQ, $b2a["nb_id"]);
         $query->WhereAnd();
         $query->WhereValue($b2a['na_id'], DB_EQ, $actionInfo['Id']);
         $result = $application->db->getDB_Result($query);
         $tagsList[$actionInfo['Id']]['BlockTags'] = array();
         foreach ($result as $BlockTag) {
             $query = new DB_Select();
             $query->addSelectField($ni['id'], 'Id');
             $query->addSelectField($ni['name'], 'InfoTag');
             $query->WhereField($ni['id'], DB_EQ, $i2b["ni_id"]);
             $query->WhereAnd();
             $query->WhereValue($i2b['nb_id'], DB_EQ, $BlockTag['Id']);
             $_result = $application->db->getDB_Result($query);
             $InfoTags = array();
             foreach ($_result as $InfoTag) {
                 $InfoTags[$InfoTag['Id']] = $InfoTag['InfoTag'];
             }
             $tagsList[$actionInfo['Id']]['BlockTags'][$BlockTag['Id']] = array("BlockTag" => $BlockTag['BlockTag'], "BlockInfoTags" => $InfoTags);
         }
     }
     return $tagsList;
 }
 /**
  * Gets modifiers of default combination from the entity.
  *
  * @param string $parent_entity - entity name
  * @param int $entity_id - ID of the entity
  * @return array(
  *  'price' => sum of price modificators and values included in the combination
  * ,'weight' => sum of weight modificators and values included in the combination
  * ,'shipping_cost' => sum of shipping cost modificators and values included in the combination
  * ,'handling_cost' => sum of handling cost modificators and values included in the combination
  * )
  */
 function getModifiersOfDefaultCombination($parent_entity, $entity_id)
 {
     $modifiers = $this->__getInnerVar("_MODIFIERS");
     if (!empty($modifiers)) {
         global $application;
         $tables = $this->getTables();
         $options_table = $tables['po_options']['columns'];
         $values_table = $tables['po_options_values']['columns'];
         $query = new DB_Select();
         $query->addSelectTable('po_options');
         $query->addSelectTable('po_options_values');
         foreach ($modifiers as $mod) {
             $query->addSelectField($query->fSum($values_table[$mod . '_modifier']), $mod);
         }
         $query->WhereValue($values_table['is_default'], DB_EQ, 'Y');
         $query->WhereAND();
         $query->WhereValue($options_table['parent_entity'], DB_EQ, $parent_entity);
         $query->WhereAND();
         $query->WhereValue($options_table['entity_id'], DB_EQ, $entity_id);
         $query->WhereAND();
         $query->WhereField($values_table['option_id'], DB_EQ, $options_table['option_id']);
         return array_shift(array_values($application->db->getDB_Result($query)));
     } else {
         return array();
     }
 }
 /**
  * A constructor.
  */
 function NotificationContent($condition = array())
 {
     global $application;
     $this->notificationId = $condition['notification_id'];
     $this->orderId = isset($condition['order_id']) ? $condition['order_id'] : NULL;
     $this->actionId = $condition['action_id'];
     $this->gift_cert = isset($condition['gc_obj']) ? $condition['gc_obj'] : NULL;
     $this->MessageResources =& $application->getInstance('MessageResources', "notifications-messages", "AZ");
     $this->customerAccount = null;
     $this->haveToSend = $this->getNotificationInfo($this->notificationId);
     if (!$this->haveToSend) {
         return;
     }
     if (isset($condition['status'])) {
         if ($condition['status'] == 'order') {
             $orderNewStatus = modApiFunc("Checkout", "getOrderStatusList", $condition['statuses']['new_status']);
             $orderNewStatus = $orderNewStatus[$condition['statuses']['new_status']]['id'];
             $tables = Notifications::getTables();
             $naov = $tables['notification_action_option_values']['columns'];
             $ov2n = $tables['option_values_to_notification']['columns'];
             $query = new DB_Select();
             $query->addSelectField($ov2n['value'], 'value');
             $query->WhereValue($naov['nao_id'], DB_EQ, 1);
             $query->WhereAnd();
             $query->WhereValue($ov2n['n_id'], DB_EQ, $this->notificationId);
             $query->WhereAnd();
             $query->WhereField($ov2n['naov_id'], DB_EQ, $naov['id']);
             $query->WhereAnd();
             $query->WhereValue($naov['key'], DB_EQ, $orderNewStatus);
             $result = $application->db->getDB_Result($query);
             if (isset($result[0]['value']) && $result[0]['value'] == 'true') {
                 $this->haveToSend = true;
                 $orderOldStatus = modApiFunc("Checkout", "getOrderStatusList", $condition['statuses']['old_status']);
                 $this->OrderOldStatus = $orderOldStatus[$condition['statuses']['old_status']]['name'];
             } else {
                 $this->haveToSend = false;
             }
         }
         if ($condition['status'] == 'payment') {
             $orderNewPaymentStatus = modApiFunc("Checkout", "getOrderPaymentStatusList", $condition['statuses']['new_status']);
             $orderNewPaymentStatus = $orderNewPaymentStatus[$condition['statuses']['new_status']]['id'];
             $tables = Notifications::getTables();
             $naov = $tables['notification_action_option_values']['columns'];
             $ov2n = $tables['option_values_to_notification']['columns'];
             $query = new DB_Select();
             $query->addSelectField($ov2n['value'], 'value');
             $query->WhereValue($naov['nao_id'], DB_EQ, 2);
             $query->WhereAnd();
             $query->WhereValue($ov2n['n_id'], DB_EQ, $this->notificationId);
             $query->WhereAnd();
             $query->WhereField($ov2n['naov_id'], DB_EQ, $naov['id']);
             $query->WhereAnd();
             $query->WhereValue($naov['key'], DB_EQ, $orderNewPaymentStatus);
             $result = $application->db->getDB_Result($query);
             if (isset($result[0]['value']) && $result[0]['value'] == 'true') {
                 $this->haveToSend = true;
                 $orderOldStatus = modApiFunc("Checkout", "getOrderPaymentStatusList", $condition['statuses']['old_status']);
                 $this->OrderOldPaymentStatus = $orderOldStatus[$condition['statuses']['old_status']]['name'];
             } else {
                 $this->haveToSend = false;
             }
         }
     }
     if ($this->actionId == 4) {
         /*
                                                          :                                    .
                   ,                              ,
                      ,                                      ,      $this->haveToSend
                        false,                       .
         
                                       ,  . .                                                   ,
                     ,                    ,                              ,
                                   .                                   prepareEmailTextAndSubject.
         
         
                    : QuantityInStock   LowStockLevel.
         
                                                          :
            -
            -
         
                                ,                           :
            -                     (           )
            -                    (                                                 )
         
                                                         :
            -             ProductLowLevelInStock                                        ,
         
                                 .
         */
         $this->haveToSend = false;
         $orderInfo = modApiFunc("Checkout", "getOrderInfo", $this->orderId, modApiFunc("Localization", "whichCurrencyToDisplayOrderIn", $this->orderId));
         foreach ($orderInfo['Products'] as $productInfo) {
             //check if the attributes of the product QuantityInStock and LowStockLevel is visible
             if (!modApiFunc("Catalog", "isProductAttributeVisible", $productInfo['storeProductID'], 3) or !modApiFunc("Catalog", "isProductAttributeVisible", $productInfo['storeProductID'], 6)) {
                 //                        ,
                 continue;
             }
             $_productInfo = new CProductInfo($productInfo['storeProductID']);
             if ($_productInfo->whichStockControlMethod() == PRODUCT_OPTIONS_INVENTORY_TRACKING) {
                 $productQuantityInStock = modApiFunc('Product_Options', 'getQuantityInStockByInventoryTable', 'product', $productInfo['storeProductID']);
             } else {
                 $productQuantityInStock = $_productInfo->getProductTagValue('QuantityInStock', PRODUCTINFO_NOT_LOCALIZED_DATA);
             }
             $productLowLevelInStock = $_productInfo->getProductTagValue('LowStockLevel', PRODUCTINFO_NOT_LOCALIZED_DATA);
             //
             //
             if (is_numeric($productLowLevelInStock) and is_numeric($productQuantityInStock)) {
                 if ($productQuantityInStock <= $productLowLevelInStock) {
                     $this->haveToSend = true;
                     $this->_LowLevelProducts[] = $productInfo['storeProductID'];
                 }
             }
         }
     }
     if ($this->actionId == 5) {
         $this->haveToSend = false;
         //                            downloadable products,                              $this->haveToSend = true;
         // id        - $this->orderId
         if (count(modApiFunc('Product_Files', 'getHotlinksListForOrder', $this->orderId)) > 0) {
             $this->haveToSend = true;
         }
     }
     if ($this->actionId == 6) {
         $this->haveToSend = true;
         $this->customerRegData = $condition['reg_data'];
         $this->customerAccount = $this->customerRegData['account'];
     }
     if ($this->actionId >= 7 and $this->actionId <= 13) {
         $this->haveToSend = true;
         $this->customerAccount = $condition['account_name'];
     }
     if ($this->actionId == 14) {
         $this->haveToSend = true;
         $this->inventory_info = $condition['inventory_info'];
     }
     if ($this->actionId == 15) {
         $this->haveToSend = true;
         $this->review_data = modApiFunc('Customer_Reviews', 'searchCustomerReviews', array('cr_id' => $condition['cr_id']));
         if (!$this->review_data) {
             $this->haveToSend = false;
         } else {
             $this->review_data = $this->review_data[0];
         }
     }
     if ($this->actionId == 16) {
         $this->haveToSend = false;
         if (count(modApiFunc('GiftCertificateApi', 'getGiftCertificatesForOrderId', $this->orderId)) > 0) {
             // receive a list of GCs purchased in specified order_id
             $this->haveToSend = true;
         }
     }
     if ($this->actionId == 17) {
         $this->haveToSend = true;
         //check conditions
         //$this->haveToSend = false;
     }
     if ($this->actionId == 18) {
         $this->haveToSend = true;
         //check conditions
         //$this->haveToSend = false;
     }
 }
 /**
  * @param int $category_id - ID
  * @param array $period = ('begin' => timestamp, 'end' => timestamp) -
  *
  * @param int $limit -                   (
  *                          ,    STAT_NO_LIMIT)
  * @param int $what_category = STAT_CATEGORY_THIS_ONLY ||
  * STAT_CATEGORY_RECURSIVE -
  *
  * @param int $what_products = STAT_PRODUCTS_ALL ||
  * STAT_PRODUCTS_EXISTS_ONLY -                                 ,
  *
  */
 function getProductsSellingStat($category_id, $period, $limit = STAT_NO_LIMIT, $what_category = STAT_CATEGORY_THIS_ONLY, $what_products = STAT_PRODUCTS_EXISTS_ONLY)
 {
     global $application;
     $tables = $this->getTables();
     $ps_table = $tables['stat_products_sold']['columns'];
     $categories_ids = array();
     if ($what_category == STAT_CATEGORY_RECURSIVE) {
         $categories = modApiFunc('Catalog', 'getSubcategoriesFullListWithParent', $category_id, false, false);
         foreach ($categories as $cat_info) {
             $categories_ids[] = $cat_info['id'];
         }
     } else {
         $categories_ids[] = $category_id;
     }
     $query = new DB_Select();
     $query->addSelectField($ps_table['product_id'], 'product_id');
     $query->addSelectField($query->fSum($ps_table['quantity']), 'sum_quantity');
     $query->addSelectTable('stat_products_sold');
     $query->WhereValue($ps_table['categories_ids'], DB_REGEXP, '[[.vertical-line.]]' . implode('|', $categories_ids) . '[[.vertical-line.]]');
     $query->WhereAND();
     $query->Where($ps_table['time'], DB_GTE, $period['begin']);
     $query->WhereAND();
     $query->Where($ps_table['time'], DB_LTE, $period['end']);
     if ($what_products == STAT_PRODUCTS_EXISTS_ONLY) {
         $catalog_tables = modApiStaticFunc('Catalog', 'getTables');
         $query->addSelectTable('products');
         $query->WhereAND();
         $query->WhereField($ps_table['product_id'], DB_EQ, $catalog_tables['products']['columns']['id']);
     }
     $query->SelectGroup('product_id');
     $query->SelectOrder('sum_quantity', 'DESC');
     if ($limit != STAT_NO_LIMIT) {
         $query->SelectLimit(0, $limit);
     }
     return $application->db->getDB_Result($query);
 }