function getCreditCardSettings($visible_only = true)
{
//
global $application;
$tables = $this->getTables();
$columns = $tables['credit_card_settings']['columns'];
$query = new DB_Select();
$query->addSelectField($columns["id"], "id");
$query->addSelectField($columns["name"], "name");
$query->addSelectField($columns["tag"], "tag");
$query->addSelectField($columns["sort_order"], "sort_order");
$query->addSelectField($columns["visible"], "visible");
if ($visible_only === true) {
$query->WhereValue($columns["visible"], DB_EQ, DB_TRUE);
}
$query->SelectOrder($columns['sort_order']);
$result = $application->db->getDB_Result($query);
$res = array();
foreach ($result as $credit_card_info) {
$res[$credit_card_info["tag"]] = array("id" => $credit_card_info["id"], "sort_order" => $credit_card_info["sort_order"], "name" => (string) $credit_card_info["name"], "tag" => (string) $credit_card_info["tag"], "visible" => (string) $credit_card_info["visible"]);
}
return $res;
}
function getPersonInfoCustomAttributeList($variant_id)
{
global $application;
$tables = $this->getTables();
$s = $tables['person_info_variants_to_attributes']['columns'];
$a = $tables['person_attributes']['columns'];
$query = new DB_Select();
$query->addSelectField($a['tag'], 'tag');
$query->addSelectField($s['name'], 'name');
$query->WhereValue($s['variant_id'], DB_EQ, $variant_id);
$query->WhereAND();
$query->WhereField($a['id'], DB_EQ, $s['attribute_id']);
$query->WhereAND();
$query->WhereValue($a['is_custom'], DB_EQ, 1);
$query->SelectOrder($s['sort']);
$result = $application->db->getDB_Result($query);
return $result;
}
function _addInputType($type_name, $type_values = array(), $it_id = '')
{
global $application;
$result = array();
// magic numbers: 9 is the maximal pre-defined input type
if ($it_id > 0 && $it_id <= 9) {
return;
}
// removing empty values
if (!is_array($type_values)) {
$type_values = array($type_values);
}
foreach ($type_values as $k => $v) {
if (!trim($v)) {
unset($type_values[$k]);
}
}
$tables = modApiFunc('Catalog', 'getTables');
$it = $tables['input_types']['columns'];
$itv = $tables['input_type_values']['columns'];
$i = new DB_Replace('input_types');
if ($it_id) {
$i->addReplaceValue($it_id, $it['ut_id']);
}
$i->addReplaceValue($type_name, $it['name']);
$result['new_input_type'] = $application->db->getDB_Result($i);
if ($it_id) {
$result['insert_type_id'] = $it_id;
} else {
$result['insert_type_id'] = $application->db->DB_Insert_Id();
}
//adding values for new type
$id = $result['insert_type_id'];
if (is_array($type_values) && !empty($type_values)) {
$saved_values = array();
if ($it_id) {
$query = new DB_Select();
$query->addSelectField($itv['id'], 'id');
$query->WhereValue($itv['it_id'], DB_EQ, $id);
$query->SelectOrder($itv['id'], 'ASC');
$saved_values = $application->db->getDB_Result($query);
if (!$saved_values) {
$saved_values = array();
} else {
foreach ($saved_values as $k => $v) {
$saved_values[$k] = $v['id'];
}
}
}
$index = 1;
foreach ($type_values as $i => $value) {
$old_id = array_shift($saved_values);
if ($old_id) {
$upd = new DB_Update('input_type_values');
$upd->addMultiLangUpdateValue($itv['value'], $value, $itv['id'], $old_id, 'Catalog');
$upd->WhereValue($itv['id'], DB_EQ, $old_id);
$application->db->getDB_Result($upd);
} else {
$ins = new DB_Insert('input_type_values');
$ins->addInsertValue($id, $itv['it_id']);
$ins->addMultiLangInsertValue($value, $itv['value'], $itv['id'], 'Catalog');
$application->db->getDB_Result($ins);
}
$result['new_input_values'][] = $value;
}
if (!empty($saved_values)) {
$d1 = new DB_Delete("input_type_values");
$d1->deleteMultiLangField($itv['value'], $itv['id'], 'Catalog');
$d1->WhereValue($itv['id'], DB_IN, '(\'' . implode('\', \'', $saved_values) . '\')');
$application->db->getDB_Result($d1);
}
} elseif ($it_id) {
$d1 = new DB_Delete("input_type_values");
$d1->deleteMultiLangField($itv['value'], $itv['id'], 'Catalog');
$d1->WhereValue($itv['it_id'], DB_EQ, $it_id);
$application->db->getDB_Result($d1);
}
return $result;
}
function getTopicEmails($topic_id, $search_email = null)
{
global $application;
$tables = $this->getTables();
$etable = 'subscription_email';
$ecolumns =& $tables[$etable]['columns'];
$atable = 'email_address';
$acolumns =& $tables[$atable]['columns'];
$query = new DB_Select($atable);
$query->addSelectField($acolumns['email_id']);
$query->addSelectField($acolumns['customer_id']);
$query->addSelectField($acolumns['email']);
$query->addSelectField($acolumns['lng']);
$query->addInnerJoin($etable, $ecolumns['email_id'], DB_EQ, $acolumns['email_id']);
$query->WhereValue($ecolumns['topic_id'], DB_EQ, $topic_id);
if (!empty($search_email)) {
$query->WhereAND();
$query->WhereValue($acolumns['email'], DB_LIKE, '%' . $search_email . '%');
}
$query->SelectOrder($acolumns['email'], 'ASC');
$query = modApiFunc('paginator', 'setQuery', $query);
$res = $application->db->getDB_Result($query);
return $res;
}
function getPersonInfoGroupAttrs($group_id, $attr_vis = PERSON_INFO_GROUP_ATTR_ALL)
{
global $application;
$tables = $this->getTables();
$pia_table = $tables['ca_person_info_attrs']['columns'];
$atg_table = $tables['ca_attrs_to_groups']['columns'];
$query = new DB_Select();
$query->addSelectTable('ca_person_info_attrs');
$query->addSelectTable('ca_attrs_to_groups');
$query->addSelectField($pia_table['attr_id'], 'attr_id');
$query->addSelectField($pia_table['attr_name'], 'attr_name');
$query->addSelectField($pia_table['lang_code'], 'lang_code');
$query->setMultiLangAlias('_ml_name', 'ca_attrs_to_groups', $atg_table['visible_name'], $atg_table['ag_id'], 'Customer_Account');
$query->addSelectField($query->getMultiLangAlias('_ml_name'), 'visible_name');
$query->addSelectField($atg_table['is_visible'], 'is_visible');
$query->addSelectField($atg_table['is_required'], 'is_required');
$query->Where($atg_table['group_id'], DB_EQ, $group_id);
$query->WhereAND();
$query->Where($pia_table['attr_id'], DB_EQ, $atg_table['attr_id']);
if ($attr_vis == PERSON_INFO_GROUP_ATTR_VISIBLE) {
$query->WhereAND();
$query->WhereValue($atg_table['is_visible'], DB_EQ, 'Y');
} elseif ($attr_vis == PERSON_INFO_GROUP_ATTR_HIDDEN) {
$query->WhereAND();
$query->WhereValue($atg_table['is_visible'], DB_EQ, 'N');
}
$query->SelectOrder($atg_table['sort_order']);
$res = $application->db->getDB_Result($query);
$group_name = $this->getPersonInfoGroupNameByID($group_id);
if ($group_name == 'Customer') {
$attrs = $res;
return $attrs;
}
foreach ($res as $k => $attr_info) {
if ($attr_vis == PERSON_INFO_GROUP_ATTR_ALL) {
$attrs[] = $attr_info;
}
if ($attr_vis == PERSON_INFO_GROUP_ATTR_VISIBLE) {
if ($this->__isCOAttrVisible($this->detectCOPITypeID($group_name), $this->detectCOAttrID($attr_info['attr_name']))) {
$attrs[] = $attr_info;
}
}
if ($attr_vis == PERSON_INFO_GROUP_ATTR_HIDDEN) {
if ($this->__isCOAttrHidden($this->detectCOPITypeID($group_name), $this->detectCOAttrID($attr_info['attr_name']))) {
$attrs[] = $attr_info;
}
}
}
return $attrs;
}
function getCFldValues()
{
global $application;
$values = "";
if ($this->mode == "add") {
$values = "";
if (isset($this->field_data['postdata']['customFieldValues'])) {
$values = $this->field_data['postdata']['customFieldValues'];
}
} else {
$itid = $this->field_data[0]['input_type_id'];
$tables = modAPIFunc("Catalog", "getTables");
$t_input_type_values = $tables['input_type_values']['columns'];
$query = new DB_Select();
$query->setMultiLangAlias('_ml_value', 'input_type_values', $t_input_type_values['value'], $t_input_type_values['id'], 'Catalog');
$query->addSelectField($query->getMultiLangAlias('_ml_value'), 'value');
$query->WhereValue($t_input_type_values['it_id'], DB_EQ, $itid);
$query->SelectOrder($t_input_type_values['id'], 'ASC');
$result = $application->db->getDB_Result($query);
foreach ($result as $r) {
$values .= modApiFunc('Catalog', 'getInputTypeActualValue', $r['value']) . "\n";
}
}
return "<textarea class=\"form-control\"" . $this->HtmlForm->genInputTextAreaField(20, 'customFieldValues', 5) . " id='customFieldValues' disabled=disabled>" . $values . "</textarea>";
}
function sendMessagesPortion3($num)
{
global $application;
loadCoreFile('ascHtmlMimeMail.php');
$mailer = new ascHtmlMimeMail();
$tables = $this->getTables();
$table = 'newsletter_temp';
$columns =& $tables[$table]['columns'];
$query = new DB_Select($table);
$query->addSelectField($columns['recipient_value']);
$query->addSelectField($columns['key_unsubscribe']);
$query->addSelectField($columns['lng']);
$query->WhereValue($columns['recipient_num'], DB_EQ, $num);
$query->SelectOrder($columns['recipient_id'], 'ASC');
$query->SelectLimit(0, PORTION_MAX_MESSAGES_NUM);
$res = $application->db->getDB_Result($query);
$addr_num = count($res);
$start_time = $this->microtime_float();
$sent_count = 0;
// getting the default language
$default_language = modApiFunc('MultiLang', 'getDefaultLanguage');
// saving the current language
$current_language = modApiFunc('MultiLang', 'getLanguage');
// storing the current letter_id
$letter_id = $this->_currentMessage['letter_id'];
while ($this->microtime_float() - $start_time < PORTION_MAX_EXPORT_TIME && $sent_count < $addr_num) {
//
//
//
// setting the language
if (!$res[$sent_count]['lng']) {
$res[$sent_count]['lng'] = $default_language;
}
modApiFunc('MultiLang', 'setLanguage', $res[$sent_count]['lng']);
// reading the newsletter for the language
$this->_currentMessage = $this->getMessageInfo($letter_id);
$from = $this->_currentMessage['letter_from_name'] . ' <' . $this->_currentMessage['letter_from_email'] . '>';
$mailer->setFrom($from);
$mailer->setSubject($this->_currentMessage['letter_subject']);
$html_tmpl = "<html><head><title>{$this->_currentMessage['letter_subject']}</title></head><body>{$this->_currentMessage['letter_html']}</body></html>";
$html_log = str_replace('%KEY_UNSUBSCRIBE%', $res[$sent_count]['key_unsubscribe'], $this->_currentMessage['letter_html']);
$mailer->setHtml(str_replace('%KEY_UNSUBSCRIBE%', $res[$sent_count]['key_unsubscribe'], $html_tmpl));
$result = $mailer->send(array($res[$sent_count]['recipient_value']));
$mailer->resetMessageBuilt();
$this->addNewsletterToTimeline($res[$sent_count]['recipient_value'], $this->_currentMessage['letter_subject'], $html_log, $result);
$sent_count++;
// :
/*debug*/
//usleep(200000);
}
// restoring the current language
modApiFunc('MultiLang', 'setLanguage', $current_language);
if ($sent_count) {
$this->_sentCountTotal += $sent_count;
$this->removeEmails($num, $sent_count);
}
if ($this->_sentCountTotal < $this->_totalRecipients) {
$sending_status = 'PROCESSING';
} else {
$sending_status = 'COMPLETED';
$this->_sentCountTotal = $this->_totalRecipients;
$this->updateMessage($this->_currentMessage['letter_id'], array('letter_sent_date' => date('Y-m-d G:i:s')));
}
return array('errors' => '', 'warnings' => '', 'sent_total' => $this->_sentCountTotal, 'sending_status' => $sending_status);
}
/**
* Reencrypts temporary data on the server. The step of replacing RSA keys.
* It selects encrypted data by chunks from the database. It reencrypts it and
* saves back to the temporary table. If all data are reencrypted, returns
* b_finished =true in the returned array, false otherwise.
*
* @param string $rsa_private_key_cryptrsa_format old RSA private key, which
* was used to encrypt data, stored in the DB
* @param string $new_rsa_public_key_asc_format new RSA public key, which is
* used to encrypt data, decrypted by the old RSA private key.
*/
function ReplaceRSAKeyPairStep2ReencryptTmpData($rsa_private_key_cryptrsa_format, $new_rsa_public_key_asc_format)
{
global $application;
$new_rsa_public_key_cryptrsa_format = modApiFunc("Crypto", "convert_rsa_public_key_from_asc_into_cryptrsa_format", $new_rsa_public_key_asc_format);
/**
* Read out from the temporary table 500 records at a time (empirical
* value).
*
* Reencrypt by chunks, that have the same Blowfish key, it is about
* 10 database records. The decryption of one blowfish key (RSA), if no
* mathematical libraries exist, can take 10 sec.
* Check the timeout after each chunk - 2 sec.
* If no records are left and the timeout is over, exit.
*
* Write what has been reencrypted to the database.
*/
$tmp_table_name = "order_person_data" . $this->getTmpTableSuffix();
// TableInfo only, but not data. Refer to the table using AVACTIS.
$opd_tmp_info = clone_db_table_info("Checkout", "order_person_data", $tmp_table_name);
$opd_tmp = $opd_tmp_info['columns'];
# get Person Info data. Total record number.
$query = new DB_Select();
$query->addSelectField($query->fCount('*'), 'count');
$query->Where($opd_tmp['b_encrypted'], DB_EQ, "1");
$result = $application->db->getDB_Result($query);
$n_total = $result[0]['count'];
# get Person Info data.
$query = new DB_Select();
$query->addSelectField($opd_tmp['id'], 'id');
$query->addSelectField($opd_tmp['value'], 'value');
$query->addSelectField($opd_tmp['encrypted_secret_key'], 'encrypted_secret_key');
$query->addSelectField($opd_tmp['rsa_public_key_asc_format'], 'rsa_public_key_asc_format');
$query->Where($opd_tmp['b_encrypted'], DB_EQ, "1");
$query->WhereAnd();
$query->Where($opd_tmp['id'], DB_GTE, $this->ReplaceRSAKeyPairStep2ReencryptTmpDataOrderPersonDataId);
$query->SelectOrder($opd_tmp['id']);
$query->SelectLimit(0, 500);
$_person_data = $application->db->getDB_Result($query);
if (sizeof($_person_data) == 0) {
//No unreencrypted data is left. The reencryption is completed.
return array("error_msg" => "", "b_finished" => true, "progress_position" => 1.0);
} else {
$i = 0;
// a number of record from order_person_data
$start_time = time();
while (time() - $start_time < 2) {
//Process one block with the same blowfish key.
$rsa_encrypted_blowfish_key = $_person_data[$i]['encrypted_secret_key'];
/*
If the loaded Private key doesn't match the Public key storing in the database -
output an error message. Don't rewrite anything in the database.
*/
$old_rsa_public_key_asc_format = $_person_data[$i]['rsa_public_key_asc_format'];
$old_rsa_public_key_cryptrsa_format = modApiFunc("Crypto", "convert_rsa_public_key_from_asc_into_cryptrsa_format", $old_rsa_public_key_asc_format);
if (modApiFunc("Crypto", "rsa_do_public_key_match_private_key", $old_rsa_public_key_cryptrsa_format, $rsa_private_key_cryptrsa_format) === true) {
//BEGIN decrypt blowfish key.
$rsa_obj = new Crypt_RSA();
$blowfish_key = $rsa_obj->decrypt($rsa_encrypted_blowfish_key, $rsa_private_key_cryptrsa_format);
$new_blowfish_key = modApiFunc("Crypto", "blowfish_gen_blowfish_key");
$new_encrypted_blowfish_key = $rsa_obj->encrypt($new_blowfish_key, $new_rsa_public_key_cryptrsa_format);
//END decrypt blowfish key.
//Bulk INSERT will increase the rate greatly!
for (; $i < sizeof($_person_data) && $_person_data[$i]['encrypted_secret_key'] == $rsa_encrypted_blowfish_key; $i++) {
$decrypted_value = modApiFunc("Crypto", "blowfish_decrypt", base64_decode($_person_data[$i]['value']), $blowfish_key);
//Store decrypted data:
$query = new DB_Update($tmp_table_name);
$query->addUpdateValue($opd_tmp['value'], base64_encode(modApiFunc("Crypto", "blowfish_encrypt", $decrypted_value, $new_blowfish_key)));
$query->addUpdateValue($opd_tmp['encrypted_secret_key'], $new_encrypted_blowfish_key);
$query->addUpdateValue($opd_tmp['rsa_public_key_asc_format'], $new_rsa_public_key_asc_format);
$query->WhereValue($opd_tmp['id'], DB_EQ, $_person_data[$i]['id']);
$application->db->getDB_Result($query);
$this->ReplaceRSAKeyPairStep2ReencryptTmpDataOrderPersonDataId = $_person_data[$i]['id'] + 1;
$this->saveState();
//Don't lose reencrypted data and save correct number
//of the last processed record. Otherwise the timeout can occur during the
//SQL query and data in the session will be incorrect.
}
if ($i >= sizeof($_person_data)) {
break;
}
} else {
//Report an error: keys don't match.
$MessageResources =& $application->getInstance('MessageResources');
$msg = $MessageResources->getMessage('CRYPTO_RSA_PUBLIC_PRIVATE_KEYS_MISMATCH_DECRYPT_ERROR');
return array("error_msg" => $msg, "b_finished" => false, "progress_position" => 0.0);
}
}
# get Person Info data. Total record count.
$query = new DB_Select();
$query->addSelectField($query->fCount('*'), 'count');
$query->Where($opd_tmp['b_encrypted'], DB_EQ, "1");
$query->WhereAnd();
$query->Where($opd_tmp['id'], DB_LT, $this->ReplaceRSAKeyPairStep2ReencryptTmpDataOrderPersonDataId);
$result = $application->db->getDB_Result($query);
$n_done = $result[0]['count'];
return array("error_msg" => "", "b_finished" => false, "progress_position" => 1.0 * $n_done / $n_total);
}
}
/**
* Reelects the default value for the option of the type 'SS'
*
* @param int $option_id - option ID
* @param int $value_id - ID of the value, dominating in the reelection
* (if it is null, no dominating value exists)
*
* @return true it was successfully reelected, false otherwise
*/
function __chooseAndSetDefaultValueForOption($option_id, $value_id = 0)
{
global $application;
$tables = $this->getTables();
$values = $tables['po_options_values']['columns'];
$query = new DB_Select();
$query->addSelectTable('po_options_values');
$query->addSelectField($values['value_id'], 'value_id');
$query->addSelectField($values['is_default'], 'is_default');
$query->WhereValue($values['option_id'], DB_EQ, $option_id);
$query->SelectOrder($values['sort_order'], 'ASC');
$res = $application->db->getDB_Result($query);
if (!is_array($res)) {
return false;
}
if (!empty($res)) {
$default_ids = array();
foreach ($res as $k => $v) {
if ($v['is_default'] == 'Y') {
$default_ids[] = $v['value_id'];
}
}
if (empty($default_ids)) {
$new_default_id = $value_id > 0 ? $value_id : $res[0]['value_id'];
$query = new DB_Update('po_options_values');
$query->addUpdateValue($values['is_default'], 'Y');
$query->WhereValue($values['value_id'], DB_EQ, $new_default_id);
$application->db->PrepareSQL($query);
return $application->db->DB_Exec();
} elseif (count($default_ids) == 1) {
if ($value_id > 0) {
$query = new DB_Update('po_options_values');
$query->addUpdateValue($values['is_default'], 'N');
$query->WhereValue($values['value_id'], DB_EQ, $default_ids[0]);
$application->db->PrepareSQL($query);
if ($application->db->DB_Exec()) {
$query = new DB_Update('po_options_values');
$query->addUpdateValue($values['is_default'], 'Y');
$query->WhereValue($values['value_id'], DB_EQ, $value_id);
$application->db->PrepareSQL($query);
return $application->db->DB_Exec();
} else {
return false;
}
}
return true;
} else {
$query = new DB_Update('po_options_values');
$query->addUpdateValue($values['is_default'], 'N');
$query->WhereValue($values['option_id'], DB_EQ, $option_id);
$application->db->PrepareSQL($query);
if ($application->db->DB_Exec()) {
$new_default_id = $value_id > 0 ? $value_id : $default_ids[0];
$query = new DB_Update('po_options_values');
$query->addUpdateValue($values['is_default'], 'Y');
$query->WhereValue($values['value_id'], DB_EQ, $new_default_id);
$application->db->PrepareSQL($query);
return $application->db->DB_Exec();
} else {
return false;
}
}
}
return true;
}
function getFilesListForProduct($product_id)
{
global $application;
$tables = $this->getTables();
$file_table = $tables['pf_files']['columns'];
$query = new DB_Select();
$query->addSelectTable('pf_files');
$query->addSelectField('*');
$query->WhereValue($file_table['product_id'], DB_EQ, $product_id);
$query->SelectOrder($file_table['file_id'], 'ASC');
return $application->db->getDB_Result($query);
}
/**
* Deletes old records in the news table.
* After that <= NEWS_MAX_COUNT records remain.
*/
function deleteOldNews()
{
global $application;
$tables = $this->getTables();
$columns = $tables['news']['columns'];
# select the latest date piece of news among the remain ones in the table...
$query = new DB_Select('news');
$query->addSelectField($columns['date'], 'NewsDate');
$query->SelectOrder($columns['date'], 'DESC');
$query->SelectLimit($this->settings[NEWS_MAX_COUNT] - 1, 1);
$result = $application->db->getDB_Result($query);
if ($result == NULL) {
return;
}
# ...delete all the latest news @ check this line
$query = new DB_Delete('news');
$query->WhereValue($columns['date'], DB_LT, $result[0]['NewsDate']);
$query->WhereAND();
$query->WhereValue($columns['type'], DB_EQ, 'avactis');
$application->db->getDB_Result($query);
}
function __searchOrders()
{
global $application;
$tables = modApiStaticFunc('Checkout', 'getTables');
$orders_table = $tables['orders']['columns'];
$query = new DB_Select();
$query->addSelectTable('orders');
$query->addSelectField($orders_table['id'], 'order_id');
$query->WhereValue($orders_table['person_id'], DB_EQ, $this->base_info['ID']);
if ($this->orders_filter['type'] == 'id') {
$query->WhereAND();
$query->WhereValue($orders_table['id'], DB_EQ, $this->orders_filter['order_id']);
}
$query->SelectGroup($orders_table['id']);
$query->SelectOrder($orders_table['id'], 'DESC');
$oids_wo_filter = array();
$res = $application->db->getDB_Result($query);
for ($i = 0; $i < count($res); $i++) {
$oids_wo_filter[] = $res[$i]['order_id'];
}
if ($this->orders_filter['type'] != 'custom' and ($this->orders_filter['order_status'] == ORDER_STATUS_ALL or empty($oids_wo_filter))) {
$this->__setOrdersIDs($oids_wo_filter);
return;
}
$query = new DB_Select();
$query->addSelectTable('orders');
$query->addSelectField($orders_table['id'], 'order_id');
if ($this->orders_filter['type'] == 'quick') {
$query->WhereValue($orders_table['status_id'], DB_EQ, $this->orders_filter['order_status']);
}
if ($this->orders_filter['type'] == 'custom') {
$from_date = implode("-", array($this->orders_filter['year_from'], $this->orders_filter['month_from'], $this->orders_filter['day_from'])) . ' 00:00:00';
$to_date = implode("-", array($this->orders_filter['year_to'], $this->orders_filter['month_to'], $this->orders_filter['day_to'])) . ' 23:59:59';
$query->WhereValue($orders_table['date'], DB_GTE, $from_date);
$query->WhereAND();
$query->WhereValue($orders_table['date'], DB_LTE, $to_date);
if ($this->orders_filter['order_status'] != ORDER_STATUS_ALL) {
$query->WhereAND();
$query->WhereValue($orders_table['status_id'], DB_EQ, $this->orders_filter['order_status']);
}
if ($this->orders_filter['order_payment_status'] != ORDER_PAYMENT_STATUS_ALL) {
$query->WhereAND();
$query->WhereValue($orders_table['payment_status_id'], DB_EQ, $this->orders_filter['order_payment_status']);
}
}
$query->WhereAND();
$query->Where($orders_table['id'], DB_IN, "('" . implode("','", $oids_wo_filter) . "')");
$oids_with_filter = array();
$res = $application->db->getDB_Result($query);
for ($i = 0; $i < count($res); $i++) {
$oids_with_filter[] = $res[$i]['order_id'];
}
$this->__setOrdersIDs($oids_with_filter);
}
/**
* @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);
}
