function getMap() { $params = array("gc_id" => $this->id, "gc_code" => $this->code, "gc_from" => $this->from_like, "gc_to" => $this->to_like, 'gc_message' => $this->message_like, 'gc_amount' => $this->amount, 'gc_amount_min' => $this->amount_min, 'gc_amount_max' => $this->amount_max, 'gc_remainder' => $this->remainder, 'gc_remainder_min' => $this->remainder_min, 'gc_remainder_max' => $this->remainder_max, 'gc_date_created' => $this->date_created, 'gc_date_created_min' => $this->date_created_min, 'gc_date_created_max' => $this->date_created_max, 'gc_sendtype' => $this->sendtype, 'gc_status' => $this->status, 'sort_by' => $this->sort_by, 'sort_order' => $this->sort_order, 'paginator' => $this->paginator, 'purchased_order_id' => $this->purchased_order_id); if ($this->use_paginator === true) { $params['paginator'] = null; $params['paginator'] = execQueryPaginator('SELECT_GC_LIST_BY_FILTER', $params); } return $params; }
function searchPgCustomerReviews($search_filter, $pg_enable) { if ($pg_enable == PAGINATOR_ENABLE) { $search_filter['use_paginator'] = true; } return execQueryPaginator('SELECT_CUSTOMER_REVIEWS_BY_FILTER', $search_filter); }
function searchPgMenu($filter, $pg_enable = PAGINATOR_ENABLE) { if ($pg_enable == PAGINATOR_ENABLE) { $filter['use_paginator'] = true; } return execQueryPaginator('SELECT_CMS_MENU_LIST', $filter); }
function selectProductSearchResultPg($params, $pg_enable) { if ($pg_enable == PAGINATOR_ENABLE) { $params['use_paginator'] = true; } return execQueryPaginator('SELECT_PRODUCT_SEARCH_RESULTS', $params); }
function getPgSearchCustomersResult() { if ($this->_customers_search_filter === null) { return ''; } if ($this->_customers_search_filter['type'] == 'custom' && !preg_match("/^[0-9]+\$/", $this->_customers_search_filter['search_string'])) { $attrs_to_search = array('FirstName', 'LastName', 'Email', 'Phone'); $attrs_ids = execQuery('SELECT_ATTRS_GROUP_IDS_BY_ATTR_NAMES', $attrs_to_search); $this->_customers_search_filter['attr_group_ids'] = array(); foreach ($attrs_ids as $v) { $this->_customers_search_filter['attr_group_ids'][] = $v['ag_id']; } } else { unset($this->_customers_search_filter['attr_group_ids']); } if (!isset($this->_customers_search_filter['currency_code'])) { $this->_customers_search_filter['currency_code'] = modApiFunc('Localization', 'getCurrencyCodeById', modApiFunc('Localization', 'getLocalMainCurrency')); } $this->_customers_search_filter['main_currency_code'] = modApiFunc('Localization', 'getCurrencyCodeById', modApiFunc('Localization', 'getLocalMainCurrency')); return execQueryPaginator('SELECT_SEARCH_CUSTOMERS', $this->_customers_search_filter); }
function getParams() { global $application; $this->params['category_id'] = $this->category_id; $this->params['product_id_list_to_ignore'] = $this->product_id_list_to_ignore; $this->params['product_id_list_to_select'] = $this->product_id_list_to_select; $this->params['select_mode_recursiveness'] = $this->select_mode_recursiveness; $this->params['select_mode_uniqueness'] = $this->select_mode_uniqueness; $this->params['filter']['status']['online_only'] = $this->select_online_products_only; $this->params['filter']['status']['exact_values'] = $this->select_online_products_only == true ? PRODUCT_STATUS_ONLINE : null; $this->params['filter']['membership_visibility']['active'] = $this->membership_filter; if ($this->sort_by === SORT_BY_RAND) { $this->params['rand'] = rand(); } // - . if (IN_CATEGORY_RECURSIVELY === $this->select_mode_recursiveness or IN_CATEGORY_RECURSIVELY_WITHOUT_CURRENT === $this->select_mode_recursiveness) { $c =& $application->getInstance('CCategoryInfo', $this->category_id); if ($this->select_online_products_only === true) { // online - $this->params['filter']['status']['online_subcat_ids'] = $c->_getOnlineSubCategories(); } else { $this->params['category_left'] = $c->getCategoryTagValue('left'); $this->params['category_right'] = $c->getCategoryTagValue('right'); } } $this->params['filter']['stock_level']['min_value'] = $this->filter_stock_level_min; $this->params['filter']['stock_level']['max_value'] = $this->filter_stock_level_max; $this->params['filter']['stock_level']['sort_flag'] = $this->sort_by == SORT_BY_PRODUCT_QUANTITY_IN_STOCK; $this->params['filter']['stock_level']['product_to_skip'] = modApiFunc('Product_Options', 'getEntitiesWhichUseInventoryTracking', 'product'); $this->params['filter']['type']['exact_values'] = $this->filter_product_type_id_list; $this->params['filter']['name']['like_values'] = $this->filter_product_name_like_values; $this->params['filter']['name']['search_condition'] = $this->filter_product_name_search_condition; $this->params['filter']['manufacturer']['exact_values'] = $this->filter_manufacturer_id_list; $this->params['filter']['price']['min_value'] = $this->filter_sale_price_min; $this->params['filter']['price']['max_value'] = $this->filter_sale_price_max; $this->params['filter']['price']['sort_flag'] = $this->sort_by == SORT_BY_PRODUCT_SALE_PRICE; $this->params['filter']['list_price']['min_value'] = $this->filter_list_price_min; $this->params['filter']['list_price']['max_value'] = $this->filter_list_price_max; $this->params['filter']['list_price']['sort_flag'] = $this->sort_by == SORT_BY_PRODUCT_LIST_PRICE; $this->params['filter']['per_item_shipping_cost']['min_value'] = $this->filter_per_item_shipping_cost_min; $this->params['filter']['per_item_shipping_cost']['max_value'] = $this->filter_per_item_shipping_cost_max; $this->params['filter']['per_item_shipping_cost']['sort_flag'] = $this->sort_by == SORT_BY_PRODUCT_PER_ITEM_SHIPPING_COST; $this->params['filter']['per_item_handling_cost']['min_value'] = $this->filter_per_item_handling_cost_min; $this->params['filter']['per_item_handling_cost']['max_value'] = $this->filter_per_item_handling_cost_max; $this->params['filter']['per_item_handling_cost']['sort_flag'] = $this->sort_by == SORT_BY_PRODUCT_PER_ITEM_HANDLING_COST; $this->params['filter']['weight']['min_value'] = $this->filter_weight_min; $this->params['filter']['weight']['max_value'] = $this->filter_weight_max; $this->params['filter']['weight']['sort_flag'] = $this->sort_by == SORT_BY_PRODUCT_WEIGHT; $this->params['filter']['sku']['like_values'] = $this->filter_sku_like_values; $this->params['filter']['sku']['search_condition'] = $this->filter_sku_search_condition; $this->params['filter']['sku']['sort_flag'] = $this->sort_by == SORT_BY_PRODUCT_SKU; $this->params['filter']['short_description']['like_values'] = $this->filter_short_description_like_values; $this->params['filter']['short_description']['search_condition'] = $this->filter_short_description_search_condition; $this->params['filter']['detailed_description']['like_values'] = $this->filter_detailed_description_like_values; $this->params['filter']['detailed_description']['search_condition'] = $this->filter_detailed_description_search_condition; $this->params['filter']['page_title']['like_values'] = $this->filter_page_title_like_values; $this->params['filter']['page_title']['search_condition'] = $this->filter_page_title_search_condition; $this->params['filter']['meta_keywords']['like_values'] = $this->filter_meta_keywords_like_values; $this->params['filter']['meta_keywords']['search_condition'] = $this->filter_meta_keywords_search_condition; $this->params['filter']['meta_description']['like_values'] = $this->filter_meta_description_like_values; $this->params['filter']['meta_description']['search_condition'] = $this->filter_meta_description_search_condition; $this->params['sort_by'] = $this->sort_by; $this->params['sort_direction'] = $this->sort_direction; $this->params['cur_membership'] = modApiFunc('Customer_Account', 'getCurrentSignedCustomerGroupID'); // if ($this->use_paginator === true) { $this->params['paginator'] = null; $this->params['paginator'] = execQueryPaginator('SELECT_PRODUCT_LIST', $this->params); } return $this->params; }
/** * Builds paginator data for the query to search labels */ function searchPgLabels($search_filter, $pg_enable) { if ($pg_enable == PAGINATOR_ENABLE) { $search_filter['use_paginator'] = true; } return execQueryPaginator('SELECT_LABELS_BY_FILTER', $search_filter); }
function getTimelineHeaders() { modAPIFunc('paginator', 'setCurrentPaginatorName', "TimelinePaginator"); $text_filter_data = modApiFunc('Timeline', 'getFilterByText'); if ($text_filter_data != null and isset($text_filter_data[0]) and isset($text_filter_data[1]) and is_array($text_filter_data[1])) { list($user_input, $index_words_list) = $text_filter_data; } else { $index_words_list = null; } $params = array('index_words_list' => $index_words_list, 'types' => $this->getFilterByTypes(), 'paginator' => null); $params['paginator'] = execQueryPaginator('SELECT_TIMELINE_HEADERS', $params); return execQuery('SELECT_TIMELINE_HEADERS', $params); }