function cw_payment_delete($payment_id)
{
global $tables;
db_query("delete from {$tables['payment_methods']} where payment_id='{$payment_id}'");
db_query("delete from {$tables['payment_methods_lng']} where payment_id='{$payment_id}'");
db_query("delete from {$tables['payment_quotes']} where payment_id='{$payment_id}'");
db_query("delete from {$tables['payment_methods_memberships']} where payment_id='{$payment_id}'");
db_query("delete from {$tables['payment_settings']} where payment_id='{$payment_id}'");
if ($tables['payments_shippings']) {
db_query("delete from {$tables['payments_shippings']} where payment_id='{$payment_id}'");
}
cw_attributes_cleanup($payment_id, 'G');
}
function cw_shipping_delete($shipping_id)
{
global $tables;
$shipping_id = cw_query_first_cell($sql = "select shipping_id from {$tables['shipping']} as s, {$tables['shipping_carriers']} as sc where sc.addon = '' and sc.carrier_id = s.carrier_id and shipping_id='{$shipping_id}'");
if ($shipping_id) {
db_query("delete from {$tables['shipping']} where shipping_id='{$shipping_id}'");
db_query("delete from {$tables['shipping_rates']} where shipping_id='{$shipping_id}'");
db_query("delete from {$tables['products_shipping']} where shipping_id='{$shipping_id}'");
db_query("delete from {$tables['shipping_cods']} where shipping_id='{$shipping_id}'");
db_query("delete from {$tables['payments_shippings']} where shipping_id='{$shipping_id}'");
cw_attributes_cleanup($shipping_id, 'D');
}
}
function cw_dod_generate()
{
global $tables, $config, $current_language;
$generator = cw_query_first("select * from {$tables['dod_generators']} where active=1 and startdate<='" . time() . "' and enddate>'" . time() . "' and dod_interval<>0 order by position asc, generator_id asc");
if (!empty($generator)) {
//check last generation date
$last_gen_date = $generator['current_offer_date'];
$hrs_since_last_generation = intval((time() - $last_gen_date) / 3600);
$generate_again = false;
if ($generator['dod_interval_type'] == 'D') {
$generate_again = $hrs_since_last_generation >= $generator['dod_interval'] * 24;
$offer_enddate = min($generator['enddate'], time() + $generator['dod_interval'] * 24 * 3600);
} elseif ($generator['dod_interval_type'] == 'T') {
$dod_period_hrs = intval(($generator['enddate'] - $generator['startdate']) / 3600);
$hrs_interval = intval($dod_period_hrs / $generator['dod_interval']);
$generate_again = $hrs_since_last_generation >= $hrs_interval;
$offer_enddate = min($generator['enddate'], time() + $dod_period_hrs / $generator['dod_interval'] * 3600);
}
if ($generate_again || $_GET['force_generate']) {
if (!empty($generator['used_pids'])) {
$used_pids = explode(';', $generator['used_pids']);
} else {
$used_pids = array();
}
$dod_products = cw_query_column("select dbd.object_id from {$tables['dod_bonus_details']} dbd inner join {$tables['dod_bonuses']} db on db.generator_id=dbd.generator_id and db.bonus_id=dbd.bonus_id and db.type='" . DOD_DISCOUNT . "' where dbd.generator_id='{$generator['generator_id']}' and dbd.object_type='" . DOD_OBJ_TYPE_PRODS . "'");
$dod_categories = cw_query_column("select dbd.object_id from {$tables['dod_bonus_details']} dbd inner join {$tables['dod_bonuses']} db on db.generator_id=dbd.generator_id and db.bonus_id=dbd.bonus_id and db.type='" . DOD_DISCOUNT . "' where dbd.generator_id='{$generator['generator_id']}' and dbd.object_type='" . DOD_OBJ_TYPE_CATS . "'");
$dod_manufacturers = cw_query_column("select dbd.object_id from {$tables['dod_bonus_details']} dbd inner join {$tables['dod_bonuses']} db on db.generator_id=dbd.generator_id and db.bonus_id=dbd.bonus_id and db.type='" . DOD_DISCOUNT . "' where dbd.generator_id='{$generator['generator_id']}' and dbd.object_type='" . DOD_OBJ_TYPE_MANS . "'");
$dod_attributes = cw_query("select dbd.* from {$tables['dod_bonus_details']} dbd inner join {$tables['dod_bonuses']} db on db.generator_id=dbd.generator_id and db.bonus_id=dbd.bonus_id and db.type='" . DOD_DISCOUNT . "' where dbd.generator_id='{$generator['generator_id']}' and dbd.object_type='" . DOD_OBJ_TYPE_ATTR . "'");
//select products by dod conditions
$data = array();
$dod_data_where_pids = '';
if ($dod_products) {
$dod_data_where_pids = "{$tables['products']}.product_id in ('" . implode("','", $dod_products) . "')";
}
if ($dod_categories) {
$data['search_in_subcategories'] = 1;
$data['category_ids'] = $dod_categories;
}
if ($dod_manufacturers) {
$manufacturer_id_attribute = cw_query_first_cell("select attribute_id from {$tables['attributes']} where field='manufacturer_id' and addon='manufacturers'");
if ($manufacturer_id_attribute) {
if (!isset($ret_params)) {
$ret_params = array();
}
if (!isset($ret_params['query_joins'])) {
$ret_params['query_joins'] = array();
}
$ret_params['query_joins']['atv_manufacturer'] = array('tblname' => 'attributes_values', 'on' => "{$tables['products']}.product_id=atv_manufacturer.item_id and atv_manufacturer.item_type='P' and atv_manufacturer.attribute_id = '{$manufacturer_id_attribute}' and atv_manufacturer.code in ('{$current_language}', '') and atv_manufacturer.value in ('" . implode("','", $dod_manufacturers) . "')", 'is_inner' => 1);
}
}
if ($dod_attributes) {
$param2_sql = array('eq' => '=', 'lt' => '<', 'le' => '<=', 'gt' => '>', 'ge' => '=>');
foreach ($dod_attributes as $attr_data_k => $attr_data) {
$is_def_values = cw_query_first("select * from {$tables['attributes_default']} where attribute_value_id='{$attr_data['param1']}' and attribute_id='{$attr_data['object_id']}'");
//print_r($is_def_values);print("<br><br>");
$sql_operation = $param2_sql[$attr_data['param2']];
if (empty($sql_operation)) {
continue;
}
if (!isset($ret_params)) {
$ret_params = array();
}
if (!isset($ret_params['query_joins'])) {
$ret_params['query_joins'] = array();
}
if ($is_def_values) {
$ret_params['query_joins']['atv_dod_' . $attr_data_k] = array('tblname' => 'attributes_values', 'on' => "{$tables['products']}.product_id=atv_dod_{$attr_data_k}.item_id and atv_dod_{$attr_data_k}.item_type='P' and atv_dod_{$attr_data_k}.attribute_id = '{$attr_data['object_id']}' and atv_dod_{$attr_data_k}.code in ('{$current_language}', '')", 'is_inner' => 1);
$ret_params['query_joins']['atd_dod_' . $attr_data_k] = array('tblname' => 'attributes_default', 'on' => "atd_dod_{$attr_data_k}.attribute_value_id=atv_dod_{$attr_data_k}.value and atv_dod_{$attr_data_k}.attribute_id=atd_dod_{$attr_data_k}.attribute_id and atd_dod_{$attr_data_k}.value{$sql_operation}'" . addslashes($is_def_values['value']) . "'", 'is_inner' => 1);
} else {
$ret_params['query_joins']['atv_dod_' . $attr_data_k] = array('tblname' => 'attributes_values', 'on' => "{$tables['products']}.product_id=atv_dod_{$attr_data_k}.item_id and atv_dod_{$attr_data_k}.item_type='P' and atv_dod_{$attr_data_k}.attribute_id = '{$attr_data['object_id']}' and atv_dod_{$attr_data_k}.code in ('{$current_language}', '') and atv_dod_{$attr_data_k}.value{$sql_operation}'{$attr_data['param1']}'", 'is_inner' => 1);
}
}
}
global $user_account, $current_area, $items_per_page_targets, $target;
$items_per_page_targets[$target] = 1;
$new_pid = 0;
$safety_cnt = 1000;
while (!$new_pid && $safety_cnt > 0) {
if (!empty($data) || !empty($dod_data_where_pids)) {
$data['sort_field'] = 'rand';
$data['flat_search'] = 1;
$dod_data_where = array();
if (!empty($dod_data_where_pids)) {
$dod_data_where[] = $dod_data_where_pids;
}
if (!empty($used_pids)) {
$dod_data_where[] = "{$tables['products']}.product_id not in ('" . implode("','", $used_pids) . "')";
}
$data['where'] = implode(' and ', $dod_data_where);
list($products, $nav, $product_filter) = cw_func_call('cw_product_search', array('data' => $data, 'user_account' => $user_account, 'current_area' => $current_area, 'info_type' => 8, 'product_id_only' => 1), $ret_params);
}
$product = reset($products);
//print_r(array('product'=>$product));print("<br><br>");
$new_pid = $product['product_id'];
if (!$new_pid) {
if ($generator['no_item_repeat']) {
break;
} else {
if (!empty($used_pids)) {
array_shift($used_pids);
} else {
break;
}
}
}
$safety_cnt--;
}
//die;
if ($new_pid) {
$used_pids[] = $new_pid;
}
$generator['used_pids'] = implode(';', $used_pids);
$regenerate_offer = true;
if ($regenerate_offer) {
//regenerate offer
if (!empty($generator['current_offer_id'])) {
$offer_ids = array($generator['current_offer_id']);
$offer_ids_query = implode("', '", $offer_ids);
db_query("DELETE FROM {$tables['ps_offers']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['ps_bonuses']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['ps_bonus_details']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['ps_conditions']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['ps_cond_details']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['attributes_values']} WHERE item_id IN ('" . $offer_ids_query . "') and item_type='PS'");
foreach ($offer_ids as $offer_id) {
cw_image_delete($offer_id, PS_IMG_TYPE);
}
cw_attributes_cleanup($offer_ids, PS_ATTR_ITEM_TYPE);
cw_cache_clean('shipping_rates');
}
if ($new_pid) {
cw_log_add('dod_generator', array('new DOD product selected' => $new_pid));
$new_offer_id = cw_array2insert('ps_offers', array('title' => 'Deal Of The Day', 'description' => $generator['description'], 'startdate' => time(), 'enddate' => $offer_enddate, 'active' => 1));
}
$current_offer_id = 0;
if ($new_offer_id) {
$mdm_attribute_id = cw_query_first_cell("select attribute_id from {$tables['attributes']} where addon='multi_domains' and item_type='PS'");
if ($mdm_attribute_id) {
cw_array2insert('attributes_values', array('item_id' => $new_offer_id, 'attribute_id' => $mdm_attribute_id, 'value' => 0, 'code' => '', 'item_type' => 'PS'));
}
//copy bonus and bonus details
$dod_bonuses = cw_query("select * from {$tables['dod_bonuses']} where generator_id='{$generator['generator_id']}' and unused=0");
foreach ($dod_bonuses as $dod_bonus) {
$_dod_bonus = $dod_bonus;
unset($_dod_bonus['generator_id']);
$_dod_bonus['offer_id'] = $new_offer_id;
$new_bonus_id = cw_array2insert('ps_bonuses', $_dod_bonus);
if ($_dod_bonus['type'] == 'D' && $_dod_bonus['apply'] == 3) {
cw_array2insert('ps_bonus_details', array('bonus_id' => $new_bonus_id, 'offer_id' => $new_offer_id, 'object_id' => $new_pid, 'quantity' => 1, 'object_type' => DOD_OBJ_TYPE_PRODS));
} else {
$dod_bonus_details = cw_query("select * from {$tables['dod_bonus_details']} where generator_id='{$generator['generator_id']}' and bonus_id='{$dod_bonus['bonus_id']}'");
if (!empty($dod_bonus_details)) {
foreach ($dod_bonus_details as $dod_bonus_detail) {
$_dod_bonus_detail = $dod_bonus_detail;
unset($_dod_bonus_detail['generator_id']);
$_dod_bonus_detail['offer_id'] = $new_offer_id;
$_dod_bonus_detail['bonus_id'] = $new_bonus_id;
cw_array2insert('ps_bonus_details', $_dod_bonus_detail);
}
}
}
}
$new_cond_id = cw_array2insert('ps_conditions', array('type' => 'P', 'total' => '0.00', 'offer_id' => $new_offer_id));
if ($new_cond_id) {
cw_array2insert('ps_cond_details', array('cond_id' => $new_cond_id, 'offer_id' => $new_offer_id, 'object_id' => $new_pid, 'quantity' => 1, 'object_type' => DOD_OBJ_TYPE_PRODS));
}
$current_offer_id = $new_offer_id;
}
}
//update dod_generator fields
cw_array2update('dod_generators', array('current_offer_id' => $current_offer_id, 'used_pids' => $generator['used_pids'], 'current_offer_date' => $current_offer_id ? time() : 0), "generator_id='{$generator['generator_id']}'");
if ($current_offer_id && !empty($config['deal_of_day']['dod_news_template']) && $config['deal_of_day']['dod_newslist']) {
$newslist = cw_query_first("select * from {$tables['newslists']} where list_id='" . $config['deal_of_day']['dod_newslist'] . "' and avail=1");
if (!empty($newslist)) {
//create message
global $smarty;
$smarty->assign('promotion', $generator);
$smarty->assign('product_id', $new_pid);
$product_info = cw_func_call('cw_product_get', array('id' => $new_pid, 'user_account' => $user_account, 'info_type' => 65535));
$smarty->assign('product', $product_info);
$smarty->assign('news_message', $config['deal_of_day']['dod_news_template']);
$message = cw_display("addons/deal_of_day/admin/generate_news.tpl", $smarty, false, $newslist['lngcode']);
$smarty->assign('news_message', $config['deal_of_day']['dod_news_template_subject']);
$message_subject = cw_display("addons/deal_of_day/admin/generate_news.tpl", $smarty, false, $newslist['lngcode']);
// $message = $smarty->display('addons/deal_of_day/admin/generate_news.tpl');
print $message_subject . "<hr />" . $message;
if (!empty($message)) {
cw_array2insert('newsletter', array('subject' => $message_subject, 'body' => $message, 'created_date' => time(), 'send_date' => time(), 'updated_date' => time(), 'status' => 'N', 'list_id' => $config['deal_of_day']['dod_newslist'], 'show_as_news' => 1, 'allow_html' => 1));
}
}
}
}
}
return $new_pid;
}
function cw_review_recalculate_avg_rating($product_id, $attribute_id = 0)
{
global $tables;
cw_load('attributes');
$query = "";
$field = "rating";
if (!empty($attribute_id)) {
$query = " AND attribute_id = " . $attribute_id;
} else {
$attribute_id = cw_query_first_cell("\n SELECT attribute_id\n FROM {$tables['attributes']}\n WHERE field = 'rating' AND addon = 'estore_products_review'\n ");
}
// recalculate avg rating
$avg = cw_query_first_cell("\n SELECT avg(vote_value)\n FROM {$tables['products_votes']}\n WHERE product_id = '{$product_id}' {$query} AND vote_value>0\n ");
// the average rating is stored with the attributes
$item_id = $product_id;
$item_type = 'P';
cw_attributes_cleanup($item_id, $item_type, null, $attribute_id);
cw_array2insert('attributes_values', array('item_id' => $item_id, 'item_type' => $item_type, 'attribute_id' => $attribute_id, 'value' => $avg));
}
function ps_delete()
{
global $tables, $top_message;
if ($_SERVER['REQUEST_METHOD'] != 'POST') {
ps_redirect();
}
global $offer_ids;
if (empty($offer_ids) || !is_array($offer_ids)) {
ps_redirect();
}
$offer_ids = array_unique(array_map('ps_process_ids', array_keys($offer_ids)));
$offer_ids_query = implode('\', \'', $offer_ids);
db_query("DELETE FROM {$tables['ps_offers']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['ps_bonuses']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['ps_bonus_details']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['ps_conditions']} WHERE offer_id IN ('" . $offer_ids_query . "')");
db_query("DELETE FROM {$tables['ps_cond_details']} WHERE offer_id IN ('" . $offer_ids_query . "')");
foreach ($offer_ids as $offer_id) {
cw_image_delete($offer_id, PS_IMG_TYPE);
}
cw_attributes_cleanup($offer_ids, PS_ATTR_ITEM_TYPE);
$top_message['content'] = cw_get_langvar_by_name('msg_ps_deleted');
cw_cache_clean('shipping_rates');
ps_redirect();
}
function cw_product_options_product_build_flat_post($params, $return)
{
global $config, $tables;
extract($params);
$where = "";
if (!$product_id) {
$product_id = cw_query_column("select product_id from {$tables['products']}");
}
if (!is_array($product_id)) {
$product_id = array($product_id);
}
$index = 0;
foreach ($product_id as $pid) {
# kornev, only available options - we are preparing the customer data
# kronev, since it's duplicates - we ahould make it short
$options = cw_query("select field, name, product_option_id from {$tables['product_options']} where product_id='{$pid}' and avail=1");
if (!$options) {
continue;
}
foreach ($options as $option) {
$field = cw_call('cw_attributes_cleanup_field', array('product_options_' . $option['field']));
$att = cw_call('cw_attributes_filter', array(array('field' => $field, 'addon' => 'product_options'), true));
$att_id = $att['attribute_id'];
if ($attribute_field && !$att_id) {
$att_id = cw_call('cw_attributes_get_attribute_by_field', array($attribute_field));
if ($att_id) {
cw_array2update('attributes', array('name' => $option['name'], 'field' => $field, 'orderby' => $option['orderby']), "attribute_id='{$att_id}'");
}
}
# kornev, we are making this if there are no attribute only
# kornev, then the customer is able to re-name it
if (!$att_id) {
$att_id = cw_func_call('cw_attributes_create_attribute', array('data' => array('name' => $option['name'], 'field' => 'product_options_' . $option['field'], 'type' => 'multiple_selectbox', 'active' => 1, 'is_show' => 1, 'orderby' => $option['orderby'], 'addon' => 'product_options', 'item_type' => 'P', 'is_show_addon' => 0, 'protection' => ATTR_PROTECTION_FIELD | ATTR_PROTECTION_TYPE | ATTR_PROTECTION_DELETE), 'language' => $config['default_admin_language']));
}
$lngs = cw_query("select name, code from {$tables['product_options_lng']} where product_option_id='{$option['product_option_id']}'");
if ($lngs) {
foreach ($lngs as $lng) {
if (!cw_query_first_cell("select count(*) from {$tables['attributes_lng']} where code='{$lng['code']}' and attribute_id='{$att_id}'")) {
cw_func_call('cw_attributes_update_lng', array('attribute_id' => $att_id, 'data' => $lng, 'language' => $lng['code']));
}
}
}
$values = cw_query("select orderby, avail as active, name as value, option_id from {$tables['product_options_values']} where product_option_id='{$option['product_option_id']}' and avail=1");
# kornev, in the product_options case we should remove all of the values firstly
# kornev, we should cleanup the appropriate attribute only;
cw_attributes_cleanup($pid, 'P', null, $att_id);
# kornev, we should add the default values - because in the multi-select the translation is stored here
# kornev, the attributes values store the attribute_value_id actually in the value field
$att_values = array();
if ($values) {
foreach ($values as $att_value) {
# kornev, try to define the attribute_value_id by value
$att_value['attribute_value_id'] = cw_query_first_cell("select attribute_value_id from {$tables['attributes_default']} where attribute_id='{$att_id}' and value='" . addslashes($att_value['value']) . "'");
$att_values[] = $att_value['attribute_value_id'] = cw_call('cw_attributes_update_default_value', array('attribute_id' => $att_id, 'data' => $att_value, 'language' => $config['default_admin_language']));
$lngs = cw_query("select name as value, code from {$tables['product_options_values_lng']} where option_id='{$att_value['option_id']}'");
if ($lngs) {
foreach ($lngs as $lng) {
$att_value = array_merge($att_value, $lng);
cw_call('cw_attributes_update_default_value', array('attribute_id' => $att_id, 'data' => $att_value, 'language' => $lng['code']));
}
}
# kornev, now store the value
}
}
if ($att_values) {
cw_func_call('cw_attributes_save_attribute', array('item_id' => $pid, 'item_type' => 'P', 'attributes' => array($field => $att_values)));
}
$index++;
if ($tick > 0 && $updated % $tick == 0) {
cw_flush('.');
}
if ($tick > 0 && $updated / $tick % 100 == 0) {
cw_flush('<br/>');
}
}
}
}
function cw_attributes_save($item_id, $item_type, $attributes, $language = null, $extra = array())
{
global $config, $current_language, $tables;
$all_languages = cw_func_call('cw_core_get_available_languages');
if ($extra['update_posted_only']) {
$prefilled_attributes = $attributes;
}
$attributes = cw_func_call('cw_attributes_get', array('item_id' => $item_id, 'item_type' => $item_type, 'prefilled' => $attributes, 'is_default' => $extra['is_default']));
if ($extra['update_posted_only']) {
$_attributes = array();
foreach ($prefilled_attributes as $attr_name => $posted_attr) {
$_attributes[$attr_name] = $attributes[$attr_name];
}
$attributes = $_attributes;
}
# kornev, cannot make it - because the hidden attributes;
$language = $language ? $language : $current_language;
# kornev, store the default values with '' language - this way we are able to select it in the right way
// if ($language == $config['default_admin_language']) $language = '';
if (is_array($attributes)) {
foreach ($attributes as $v) {
# kornev, do not update the hidden values here, the hidden values have to be updated by cw_attributes_save_attribute
if ($v['type'] == 'hidden') {
continue;
}
# kornev, only the text data is multi-lng - clean it with language
if (in_array($v['type'], array('text', 'textarea'))) {
cw_attributes_cleanup($item_id, $item_type, $language, $v['attribute_id']);
} else {
cw_attributes_cleanup($item_id, $item_type, null, $v['attribute_id']);
}
foreach ($v['values'] as $value) {
# kornev, the text attribute might be multilng on this stage
# kornev, the selectbox are store the attribute value # - so it's translated on the set attribute stage
if (in_array($v['type'], array('text', 'textarea'))) {
cw_array2insert('attributes_values', array('item_id' => $item_id, 'item_type' => $item_type, 'attribute_id' => $v['attribute_id'], 'value' => $value, 'code' => $language));
# kornev, we should check the amount of the values - because the multi-lng values might be required to save as default
if (count($all_languages) != cw_query_first_cell("select count(*) from {$tables['attributes_values']} where item_id = '{$item_id}' and item_type = '{$item_type}' and attribute_id = '{$v['attribute_id']}'")) {
foreach ($all_languages as $code => $tmp) {
if (!cw_query_first_cell("select count(*) from {$tables['attributes_values']} where item_id = '{$item_id}' and item_type = '{$item_type}' and attribute_id = '{$v['attribute_id']}' and code = '{$code}'")) {
$dfv = cw_call('cw_attributes_get_attribute_default_value', array('attribute_id' => $v['attribute_id'], 'language' => $code));
if ($dfv[0]['value']) {
cw_array2insert('attributes_values', array('item_id' => $item_id, 'item_type' => $item_type, 'attribute_id' => $v['attribute_id'], 'value' => $dfv[0]['value'], 'code' => $code));
}
}
}
}
} else {
cw_array2insert('attributes_values', array('item_id' => $item_id, 'item_type' => $item_type, 'attribute_id' => $v['attribute_id'], 'value' => $value));
}
}
}
}
return $attributes;
}
