function cw_file_area_save($type, $for_customer_id, $data) { global $tables, $customer_id, $var_dirs, $app_dir; $insert = array('customer_id' => $for_customer_id, 'by_customer_id' => $customer_id, 'filename' => $data['filename'], 'date' => cw_core_get_time(), 'md5' => md5(file_get_contents($data['file_path']))); if ($data['descr']) { $insert['descr'] = $data['descr']; } if ($data['id']) { $insert['id'] = $data['id']; } $file_id = cw_array2insert($type, $insert); if ($file_id) { $file_info = explode('.', $data['filename'], 2); $stored_file_name = $file_info[0] . '_' . $file_id . '.' . $file_info[1]; $files_dir = $var_dirs['documents'] . '/' . $type; if (!is_dir($files_dir)) { @mkdir($files_dir); } $new_file_path = $files_dir . '/' . $stored_file_name; @copy($data['file_path'], $new_file_path); @unlink($data['file_path']); $new_file_path = cw_relative_path($new_file_path, $app_dir); db_query("update " . $tables[$type] . " set file_path='" . addslashes($new_file_path) . "' where file_id='{$file_id}'"); } return $file_id; }
function cw_save_salesman_order($cart_tmp, $doc_id = 0) { $salesman_order = array(); $products = $cart_tmp['products']; $save_fields = array('product_id', 'productcode', 'product', 'warehouse', 'taxed_price', 'taxes', 'extra_data', 'catalog_price', 'product_options', 'amount', 'new', 'free_price', 'price', 'items_in_stock'); if (is_array($products)) { foreach ($products as $k => $v) { if ($v['deleted']) { unset($products[$k]); continue; } foreach ($v as $field => $val) { if (!in_array($field, $save_fields)) { unset($products[$k][$field]); } } } } $salesman_order['cart'] = addslashes(serialize($products)); $salesman_order['customer_id'] = $cart_tmp['customer_id']; $salesman_order['salesman_customer_id'] = $cart_tmp['salesman_customer_id']; $salesman_order['status'] = 0; if ($doc_id) { $salesman_order['id'] = $doc_id; } return cw_array2insert('salesman_orders', $salesman_order, true); }
function cw_barcode_create_template($title) { $to_insert = array('data' => addslashes(serialize(array('rows' => 5, 'cols' => 10, 'width' => 100, 'height' => 100))), 'layout' => 'barcode', 'title' => $title); $layout_id = cw_array2insert('layouts', $to_insert); $to_insert = array('layout_id' => $layout_id, 'template' => 'addons/barcode/layout.tpl', 'class' => 'barcode_layout'); cw_array2insert('layouts_templates', $to_insert); return $layout_id; }
function add() { global $added_data, $REQUEST_METHOD; if ($REQUEST_METHOD == "POST") { $added_data['default_status'] = serialize($added_data['default_status']); cw_array2insert('product_stages_library', $added_data); cw_header_location("index.php?target=product_stages"); } }
function product_stages_add() { global $new_product_stage, $REQUEST_METHOD, $product_id, $default_status; if ($REQUEST_METHOD == "POST") { $new_stage_data = array('product_id' => $product_id, 'stage_lib_id' => $new_product_stage['stage_lib_id'], 'period' => $new_product_stage['period'], 'status' => !empty($default_status['new_product_stage']) ? '-1' : (!empty($new_product_stage['status']) ? serialize($new_product_stage['status']) : ''), 'active' => !empty($new_product_stage['active']) ? 1 : 0); cw_array2insert('product_stages_product_settings', $new_stage_data); cw_header_location("index.php?target=products&mode=details&product_id={$product_id}&js_tab=product_stages"); } }
function cw_array2insert_esc($tab, $arr) { foreach ($arr as $k => $v) { if (preg_match("'\\''", $v)) { $arr[$k] = addslashes($v); } } return cw_array2insert($tab, $arr); }
function cw_add_class_data($data, $product_id) { global $tables; # Update class data $comp = $data['class']; $comp['product_id'] = $product_id; cw_unset($comp, "product_option_id"); $comp = cw_addslashes($comp); $product_option_id = cw_query_first_cell("SELECT product_option_id FROM {$tables['product_options']} WHERE class = '{$comp['class']}' AND product_id = '{$comp['product_id']}'"); $is_new = empty($product_option_id); if (!empty($product_option_id)) { cw_array2update("product_options", $comp, "product_option_id = '{$product_option_id}'"); } else { $product_option_id = cw_array2insert("product_options", $comp); } # Update class multilanguage data db_query("DELETE FROM {$tables['product_options_lng']} WHERE product_option_id = '{$product_option_id}'"); foreach ($data['product_options_lng'] as $v) { $v['product_option_id'] = $product_option_id; $v = cw_addslashes($v); cw_array2insert("product_options_lng", $v, true); } # Update class options $ids = array(); foreach ($data['product_options_values'] as $k => $opt) { $opt['product_option_id'] = $product_option_id; $old_option_id = $opt['option_id']; cw_unset($opt, "option_id"); $opt = cw_addslashes($opt); $option_id = cw_query_first_cell("SELECT option_id FROM {$tables['product_options_values']} WHERE product_option_id = '{$product_option_id}' AND name = '{$opt['name']}'"); if (empty($option_id)) { $option_id = cw_array2insert("product_options_values", $opt); } else { cw_array2update("product_options_values", $opt, "option_id = '{$option_id}'"); } $ids[$old_option_id] = $option_id; } # Update class option multilanguage data db_query("DELETE FROM {$tables['product_options_values_lng']} WHERE option_id = '{$option_id}'"); foreach ($data['product_options_values_lng'] as $v) { if (!isset($ids[$v['option_id']])) { continue; } $v['option_id'] = $ids[$v['option_id']]; $v = cw_addslashes($v); cw_array2insert("product_options_values_lng", $v, true); } # Detect and delete old product option class options $ids = cw_query_column("SELECT option_id FROM {$tables['product_options_values']} WHERE product_option_id = '{$product_option_id}' AND option_id NOT IN ('" . implode("','", $ids) . "')"); if (!empty($ids)) { db_query("DELETE FROM {$tables['product_options_values']} WHERE product_option_id = '{$product_option_id}' AND option_id IN ('" . implode("','", $ids) . "')"); db_query("DELETE FROM {$tables['product_options_values_lng']} WHERE option_id IN ('" . implode("','", $ids) . "')"); db_query("DELETE FROM {$tables['products_options_ex']} WHERE option_id IN ('" . implode("','", $ids) . "')"); } }
function add_video($product_id) { global $new_video; assert('!empty($product_id) /* ' . __FUNCTION__ . ' */'); $new_video['product_id'] = $product_id; $new_video_id = cw_array2insert('product_video', $new_video, false, array('product_id', 'pos', 'title', 'descr', 'code')); if ($new_video_id) { cw_add_top_message('Video added'); } return $new_video_id; }
function cw_send_simple_mail($from, $to, $subject, $body, $extra_headers = array(), $files = array()) { global $current_language; if (empty($to)) { return; } $to = cw_real_mail_address($to); $language = $language ? $language : $current_language; $_files = implode(",", $files); cw_array2insert('mail_spool', cw_addslashes(array('mail_from' => $from, 'mail_to' => $to, 'subject' => $subject, 'body' => $body, 'crypted' => false, 'files' => $_files))); return; }
function cw_serials_add($customer_id, $product_id, $serial) { global $tables; $count = cw_query_first_cell("select count(*) from {$tables['serial_numbers']} where sn='{$serial}' and product_id='{$product_id}'"); if ($count) { return false; } $serial = trim($serial); if (empty($serial)) { return true; } $to_insert = array('sn' => $serial, 'product_id' => $product_id, 'doc_id' => 0, 'warehouse_customer_id' => $customer_id, 'date' => time()); cw_array2insert('serial_numbers', $to_insert); return true; }
function dashboard_action_update() { if ($_SERVER['REQUEST_METHOD'] != 'POST') { dashboard_redirect(); } $dashboard = $_POST['dashboard']; if (empty($dashboard)) { dashboard_redirect(); } foreach ($dashboard as $name => $dash) { $data = array('name' => $name, 'pos' => intval($dash['pos']), 'active' => intval($dash['active'])); cw_array2insert('dashboard', $data, true); } $top_message = array('content' => cw_get_langvar_by_name('msg_ppd_filetypes_updated_succes'), 'type' => 'I'); dashboard_redirect(); }
function cw_system_messages_add($code, $msg, $type = SYSTEM_MESSAGE_COMMON, $severity = SYSTEM_MESSAGE_INFO) { global $tables; $code = mysql_real_escape_string($code); $msg = mysql_real_escape_string($msg); $type = intval($type); $existing = cw_query_first("SELECT code, hidden FROM {$tables['system_messages']} WHERE code='{$code}'"); $data = array('date' => cw_core_get_time(), 'message' => $msg, 'type' => $type, 'severity' => $severity); if ($existing) { $ret = cw_array2update('system_messages', $data, "code='{$code}'"); } else { $data['code'] = $code; $data['hidden'] = 0; $ret = cw_array2insert('system_messages', $data); } return $ret; }
function cw_objects_add_to_set($objects, $type = 'P') { global $tables, $customer_id; if (is_array($objects) && count($objects)) { $objects = array_unique($objects); $objects = array_filter($objects, function ($object) { return !empty($object) && is_numeric($object); }); if (count($objects)) { foreach ($objects as $object) { if (!cw_objects_check_exist($object, $type)) { cw_array2insert("objects_set", array("object_id" => $object, "customer_id" => $customer_id, "set_type" => $type)); } } return TRUE; } } return FALSE; }
function cw_messages_create_new_message($customer_id, $sender_name, $recipient_id, $recipient_email, $subject, $body, $conversation_id) { global $config, $current_location; cw_load('email'); // sent message (incoming folder) $new_message_id = cw_array2insert('messages', array('subject' => $subject, 'body' => $body, 'sender_id' => $customer_id, 'recipient_id' => $recipient_id, 'sending_date' => cw_core_get_time(), 'conversation_id' => !empty($conversation_id) ? $conversation_id : 0, 'conversation_customer_id' => $recipient_id)); // duplicate for sent folder $current_conversation_id = !empty($conversation_id) ? $conversation_id : $new_message_id; $duplicate_message_id = cw_array2insert('messages', array('subject' => $subject, 'body' => $body, 'sender_id' => $customer_id, 'recipient_id' => $recipient_id, 'sending_date' => cw_core_get_time(), 'read_status' => 1, 'conversation_id' => $current_conversation_id, 'conversation_customer_id' => $customer_id, 'type' => 2, 'link_id' => $new_message_id)); // unite message if they have not been united $data = array('link_id' => $duplicate_message_id); if (empty($conversation_id)) { $data['conversation_id'] = $new_message_id; } cw_array2update('messages', $data, "message_id = '{$new_message_id}'"); // send notification email to recipient // notification is sent from system email and says about new received message from Sender at <sitename> $from = $config['Company']['site_administrator']; /* $mail_subject = "The notification of a new message"; $mail_body = '<b>You have received a new message from "' . $sender_name . '" at <a href="' . $current_location . '">'; $mail_body .= $config['Company']['company_name'] . '</a></b><br />'; $mail_body .= '<b>Subject:</b> ' . $subject . '<br />'; $mail_body .= '<b>Body:</b> ' . nl2br($body) . '<br />'; $mail_body .= '<a href="' . $current_location . '/index.php?target=message_box&mode=new'; $mail_body .= '&contact_id=' . $customer_id . '&conversation_id=' . $current_conversation_id . '">Link to reply</a><br />'; cw_send_simple_mail($from, $recipient_email, $mail_subject, $mail_body); */ global $smarty; $smarty->assign('sender_name', $sender_name); $smarty->assign('current_location', $current_location); $smarty->assign('config', $config); $smarty->assign('subject', $subject); $smarty->assign('body', $body); $smarty->assign('customer_id', $customer_id); $smarty->assign('recipient_id', $recipient_id); $smarty->assign('current_conversation_id', $current_conversation_id); $smarty->assign('new_message_id', $new_message_id); cw_call('cw_send_mail', array($from, $recipient_email, 'addons/messaging_system/mail/new_message_subj.tpl', 'addons/messaging_system/mail/new_message.tpl')); return $new_message_id; }
function on_profile_modify($customer_id, $profile) { if (!isset($profile['mailing_list'])) { return true; } $user = \Customer\get($customer_id); if (empty($user)) { return null; } global $tables; db_query("DELETE FROM {$tables['newslist_subscription']} WHERE email='{$user['email']}' AND list_id NOT IN ('" . join("','", array_keys($profile['mailing_list'])) . "')"); foreach ($profile['mailing_list'] as $lid => $v) { if (!is_numeric($lid) || $lid < 1) { continue; } $is_subscribed = (bool) cw_query("SELECT list_id FROM {$tables['newslist_subscription']} WHERE email='{$user['email']}' AND list_id='{$lid}'"); if (!$is_subscribed && $v) { $data = array('list_id' => $lid, 'email' => $user['email']); cw_array2insert('newslist_subscription', $data); } } }
function cw_ebay_add_data_from_file() { global $tables; $path = addon_files_location_path . addon_conditions_data_file_name; if (!file_exists($path) || !is_readable($path)) { return array('content' => 'File "' . addon_conditions_data_file_name . '" does not exist or not readable.', 'type' => 'E'); } if (($handle = fopen($path, "r")) !== FALSE) { $attribute_id = cw_query_first_cell("SELECT attribute_id FROM {$tables['attributes']} WHERE field = 'ebay_category' AND addon = 'ebay'"); if (empty($attribute_id)) { fclose($handle); return array('content' => 'Error in attribute "ebay Category". Wrong parameter ID.', 'type' => 'E'); } db_query("DELETE FROM {$tables['attributes_default']} WHERE attribute_id = " . $attribute_id); // Prepare attributes data $attributes = array(); $attributes[""] = array("value" => "-- Inherited from parent --", "value_key" => 0); while (($data = fgetcsv($handle)) !== FALSE) { $category_id = intval($data[0]); if (!is_numeric($category_id) || $category_id <= 0) { continue; } $category_name = addslashes(trim($data[1])); $attributes[$category_name] = array("value" => $category_name, "value_key" => $category_id); } fclose($handle); if (count($attributes)) { ksort($attributes); $orderby = 0; // Add to cw_attributes_default foreach ($attributes as $attribute) { cw_array2insert("attributes_default", array("value" => $attribute["value"], "value_key" => $attribute["value_key"], "attribute_id" => $attribute_id, "orderby" => $orderby++, "active" => 1)); } } } else { return array('content' => 'File "' . addon_conditions_data_file_name . '" not readable.', 'type' => 'E'); } return array('content' => 'The operation completed successfully.', 'type' => 'I'); }
function cw_ps_offer_bundle_update($product_id, $update_data) { global $tables, $config; $product_id = (int) $product_id; $offer_id = cw_query_first_cell("SELECT offer_id FROM {$tables['ps_offers']} WHERE pid='{$product_id}'"); if (empty($offer_id)) { // There is no offer for this product yet. Create it $data = array('title' => "Product #{$product_id} bundle", 'description' => 'Buy products together and get discount ' . $update_data['discount'] . ($update_data['disctype'] == PS_DISCOUNT_TYPE_PERCENT ? '%' : $config['General']['currency_symbol']), 'startdate' => time(), 'enddate' => 9999999999.0, 'exlusive' => 0, 'position' => -1, 'active' => 1, 'priority' => -1, 'pid' => $product_id, 'auto' => $update_data['auto'], 'repeat' => 0); $offer_id = cw_array2insert('ps_offers', $data); // Add offer to all domains $attribute_id = cw_call('cw_attributes_filter', array(array('field' => 'domains', 'item_type' => 'PS'), true, 'attribute_id')); $data = array('item_id' => $offer_id, 'attribute_id' => $attribute_id, 'value' => 0, 'item_type' => 'PS'); cw_array2insert('attributes_values', $data); } $cond_id = cw_query_first_cell("SELECT cond_id FROM {$tables['ps_conditions']} WHERE offer_id='{$offer_id}' AND type='" . PS_SPEC_PRODUCTS . "'"); if (empty($cond_id)) { // Create condition $data = array('type' => PS_SPEC_PRODUCTS, 'offer_id' => $offer_id); $cond_id = cw_array2insert('ps_conditions', $data); $data = array('cond_id' => $cond_id, 'offer_id' => $offer_id, 'object_id' => $product_id, 'quantity' => 1, 'object_type' => PS_OBJ_TYPE_PRODS); cw_array2insert('ps_cond_details', $data); // Create bonus $data = array('offer_id' => $offer_id, 'type' => PS_DISCOUNT, 'apply' => PS_APPLY_PRODS, 'discount' => floatval($_POST['discount']), 'disctype' => intval($_POST['disctype'])); $bonus_id = cw_array2insert('ps_bonuses', $data); $data = array('bonus_id' => $bonus_id, 'offer_id' => $offer_id, 'object_id' => $product_id, 'quantity' => 1, 'object_type' => PS_OBJ_TYPE_PRODS); cw_array2insert('ps_bonus_details', $data); } // Add new selected products foreach ($update_data['bundle'] as $k => $v) { if ($v['id'] == $product_id || empty($v['id'])) { continue; } $data = array('cond_id' => $cond_id, 'offer_id' => $offer_id, 'object_id' => $v['id'], 'quantity' => 1, 'object_type' => PS_OBJ_TYPE_PRODS); cw_array2insert('ps_cond_details', $data); $data = array('bonus_id' => $bonus_id, 'offer_id' => $offer_id, 'object_id' => $v['id'], 'quantity' => 1, 'object_type' => PS_OBJ_TYPE_PRODS); cw_array2insert('ps_bonus_details', $data); } $data = array('discount' => floatval($update_data['discount']), 'disctype' => intval($update_data['disctype'])); cw_array2update('ps_bonuses', $data, "offer_id='{$offer_id}' AND type='" . PS_DISCOUNT . "'"); return $offer_id; }
function dod_modify_bonuses($generator_id) { global $tables, $bonus_names; global $dod_bonuses, $dod_bonus; if (empty($generator_id)) { $GLOBALS['_dod_bonuses'] =& $dod_bonuses; cw_session_register('_dod_bonuses'); $GLOBALS['_dod_bonus'] =& $dod_bonus; cw_session_register('_dod_bonus'); return array(true, null); //return array(false, 'generator Id was not provided'); } db_query("DELETE FROM {$tables['dod_bonuses']} WHERE generator_id = '{$generator_id}'"); db_query("DELETE FROM {$tables['dod_bonus_details']} WHERE generator_id = '{$generator_id}'"); $available_fields = array('bonus_id' => 'int', 'generator_id' => 'int', 'type' => 'string', 'apply' => 'int', 'coupon' => 'string', 'discount' => 'float', 'disctype' => 'int'); $excl_from_base_list = array('bonus_id'); foreach ($excl_from_base_list as $field) { if (isset($available_fields[$field])) { unset($available_fields[$field]); } } $optional_fields = array('discount', 'disctype'); $date_fields = array(); $skip_striptags_fields = array(); if (empty($dod_bonuses[DOD_DISCOUNT])) { $dod_bonuses[DOD_DISCOUNT] = 1; $unused_dod_discount_bonus = 1; } else { $unused_dod_discount_bonus = 0; } if (empty($dod_bonuses) || !is_array($dod_bonuses)) { return array(true, null); } $available_btypes = array(DOD_DISCOUNT, DOD_FREE_PRODS, DOD_FREE_SHIP, DOD_COUPON); $bonuses = array(); foreach ($dod_bonuses as $bonus_type => $trash) { if (!isset($dod_bonus[$bonus_type]) || empty($dod_bonus[$bonus_type]) || !in_array($bonus_type, $available_btypes)) { unset($dod_bonuses[$bonus_type]); } else { $bonuses[$bonus_type] = $dod_bonus[$bonus_type]; } } unset($dod_bonus); if (empty($dod_bonuses) || empty($bonuses)) { return array(true, null); } $GLOBALS['_dod_bonuses'] =& $dod_bonuses; cw_session_register('_dod_bonuses'); $errors = array(); $tmp_optional_fields = $optional_fields; foreach ($bonuses as $bonus_type => $input_data) { $optional_fields = $tmp_optional_fields; $additional_lang_data = array(); $pids = $cids = array(); $input_data['generator_id'] = $generator_id; $input_data['type'] = $bonus_type; if ($bonus_type != DOD_COUPON) { $input_data['coupon'] = 1; if ($input_data['apply'] == DOD_APPLY_PRODS || $bonus_type == DOD_FREE_PRODS || $bonus_type == DOD_DISCOUNT) { if (!isset($input_data['products']) && !isset($input_data['cats']) && !isset($input_data['mans']) && !isset($input_data['attr']) || empty($input_data['products']) && empty($input_data['cats']) && empty($input_data['mans']) && empty($input_data['attr'])) { $additional_lang_data = array('bonus' => cw_get_langvar_by_name($bonus_names[$bonus_type])); $errors[] = cw_get_langvar_by_name('msg_dod_bonus_incorrect', $additional_lang_data); continue; } if (isset($input_data['products']) && !empty($input_data['products'])) { $products_data = array(); foreach ($input_data['products'] as $product_data) { $product_data['id'] = trim($product_data['id']); $products_data[$product_data['id']] = $product_data['quantity']; } $pids = array_keys($products_data); $pids = cw_query_column("SELECT product_id as id FROM {$tables['products']} WHERE product_id IN ('" . implode("','", $pids) . "')"); } if (isset($input_data['cats']) && !empty($input_data['cats'])) { $cats_data = array(); foreach ($input_data['cats'] as $cat_data) { $cat_data['id'] = trim($cat_data['id']); $cats_data[$cat_data['id']] = $cat_data['quantity']; } $cids = array_keys($cats_data); $cids = cw_query_column("SELECT category_id as id FROM {$tables['categories']} WHERE category_id IN ('" . implode("','", $cids) . "')"); } if (isset($input_data['mans']) && !empty($input_data['mans'])) { $mids = array_values($input_data['mans']); } if (isset($input_data['attr'])) { // Prepare attributes data if (isset($input_data['attr']) && !empty($input_data['attr'])) { $attr_data = array(); foreach ($input_data['attr'] as $a_data) { $attr_data[trim($a_data['attribute_id'])] = array('quantity' => $a_data['quantity'], 'value' => current($a_data['value']), 'operation' => $a_data['operation']); } $attrids = array_keys($attr_data); $attrids = cw_query_column("SELECT attribute_id as id FROM {$tables['attributes']} WHERE attribute_id IN ('" . implode("','", $attrids) . "')"); } } if (empty($pids) && empty($cids) && empty($mids) && empty($attrids)) { $additional_lang_data = array('bonus' => cw_get_langvar_by_name($bonus_names[$bonus_type])); $errors[] = cw_get_langvar_by_name('msg_dod_bonus_incorrect', $additional_lang_data); continue; } } } if ($bonus_type != DOD_DISCOUNT && $bonus_type != DOD_FREE_SHIP) { $input_data['discount'] = $input_data['disctype'] = null; } elseif ($bonus_type == DOD_FREE_SHIP) { $input_data['disctype'] = null; } else { $optional_fields = array(); } if (in_array($bonus_type, array(DOD_FREE_PRODS, DOD_COUPON))) { $optional_fields[] = 'apply'; } $data = array(); foreach ($date_fields as $field) { if (isset($input_data[$field]) && !empty($input_data[$field])) { $input_data[$field] = cw_core_strtotime($input_data[$field]); } } $error = null; foreach ($available_fields as $field => $field_type) { if (isset($input_data[$field])) { $result = settype($input_data[$field], $field_type); if ($result === false) { $error = 'msg_dod_incorrect_field_type'; $additional_lang_data = array('field_name' => $field); break; } if (empty($input_data[$field]) && !($bonus_type == DOD_DISCOUNT && $unused_dod_discount_bonus)) { if (in_array($field, $optional_fields)) { $data[$field] = null; } else { $additional_lang_data = array('bonus' => cw_get_langvar_by_name($bonus_names[$bonus_type])); $error = 'msg_dod_bonus_incorrect'; break; } } else { if ($field_type == 'string' && !in_array($field, $skip_striptags_fields)) { $input_data[$field] = cw_strip_tags($input_data[$field]); } $data[$field] =& $input_data[$field]; } } else { if ($field_type == 'bool') { $data[$field] = 0; } else { if (in_array($field, $optional_fields)) { $data[$field] = null; } else { $additional_lang_data = array('bonus' => cw_get_langvar_by_name($bonus_names[$bonus_type])); $error = 'msg_dod_bonus_incorrect'; break; } } } } if (!empty($error)) { $errors[] = cw_get_langvar_by_name($error, $additional_lang_data); continue; } if (empty($data)) { continue; } if ($data['type'] == DOD_DISCOUNT) { $data['unused'] = $unused_dod_discount_bonus; } $bonus_id = cw_array2insert($tables['dod_bonuses'], cw_addslashes($data)); if ($bonus_type == DOD_FREE_SHIP) { foreach ($input_data['methods'] as $trash => $shipping_id) { $data = array('generator_id' => $generator_id, 'bonus_id' => $bonus_id, 'object_id' => $shipping_id, 'object_type' => DOD_OBJ_TYPE_SHIPPING); cw_array2insert($tables['dod_bonus_details'], cw_addslashes($data)); } } if ($bonus_type != DOD_COUPON) { if ($input_data['apply'] == DOD_APPLY_PRODS || $bonus_type == DOD_FREE_PRODS || $bonus_type == DOD_DISCOUNT) { if (!empty($pids)) { $data = array(); $data['generator_id'] = $generator_id; $data['bonus_id'] = $bonus_id; foreach ($pids as $pid) { $data['object_id'] = $pid; $data['object_type'] = DOD_OBJ_TYPE_PRODS; $data['quantity'] = $products_data[$pid]; if (empty($data['quantity'])) { $data['quantity'] = 1; } cw_array2insert($tables['dod_bonus_details'], cw_addslashes($data)); } } if (!empty($cids)) { $data = array(); $data['generator_id'] = $generator_id; $data['bonus_id'] = $bonus_id; foreach ($cids as $cid) { $data['object_id'] = $cid; $data['object_type'] = DOD_OBJ_TYPE_CATS; $data['quantity'] = $cats_data[$cid]; if (empty($data['quantity'])) { $data['quantity'] = 1; } cw_array2insert($tables['dod_bonus_details'], cw_addslashes($data)); } } if (!empty($mids)) { $data = array(); $data['generator_id'] = $generator_id; $data['bonus_id'] = $bonus_id; $data['quantity'] = 1; foreach ($mids as $mid) { $data['object_id'] = $mid; $data['object_type'] = DOD_OBJ_TYPE_MANS; cw_array2insert($tables['dod_bonus_details'], cw_addslashes($data)); } } // Save attributes to condition details if (!empty($attrids)) { $data = array(); $data['generator_id'] = $generator_id; $data['bonus_id'] = $bonus_id; $data['quantity'] = 1; foreach ($attrids as $aid) { $data['object_id'] = $aid; $data['object_type'] = DOD_OBJ_TYPE_ATTR; $data['param1'] = $attr_data[$aid]['value']; $data['param2'] = $attr_data[$aid]['operation']; cw_array2insert($tables['dod_bonus_details'], cw_addslashes($data)); } } } } unset($bonuses[$bonus_type]); } if (!empty($bonuses)) { $GLOBALS['_dod_bonus'] =& $bonuses; cw_session_register('_dod_bonus'); } if (!empty($errors)) { $error = implode("<br />\n", $errors); return array(false, $error); } return array(true, null); }
if ($REQUEST_METHOD == "POST" && $action == "add_review") { if (!empty($review_new['message'])) { $review_new['status'] = $config['estore_products_review']['status_created_reviews']; $review_new['email'] = $user_account['email']; $review_id = cw_call('cw_review_add_new_review_manual', array($review_new, 0)); } if (!empty($review_id)) { $review_data = cw_query_first("SELECT * FROM {$tables['products_reviews']} WHERE review_id='{$review_id}'"); foreach ($rating as $attr_id => $vote) { // update vote value $exists = cw_query_first_cell("SELECT vote_id FROM {$tables['products_votes']} WHERE review_id = '{$review_id}' AND attribute_id ='{$attr_id}'"); if ($exists) { cw_array2update('products_votes', array('vote_value' => $vote), "review_id = '{$review_id}' AND attribute_id ='{$attr_id}'"); } else { cw_array2insert('products_votes', array('remote_ip' => $review_data['remote_ip'], 'vote_value' => $vote, 'product_id' => $review_data['product_id'], 'customer_id' => $review_data['customer_id'], 'review_id' => $review_id, 'attribute_id' => $attr_id)); } cw_review_recalculate_avg_rating($review_data['product_id'], $attr_id); } cw_review_recalculate_avg_rating($review_data['product_id']); cw_add_top_message(cw_get_langvar_by_name('txt_thank_you_for_review')); } else { cw_add_top_message(cw_get_langvar_by_name('err_filling_form'), 'E'); } cw_header_location("index.php?target=global_reviews"); } $items_per_page_targets[$target] = 10; $total_items = cw_call('cw_review_get_global_review', array()); $navigation = cw_core_get_navigation($target, $total_items, $page); $global_reviews = cw_call('cw_review_get_global_review', array('', '', " ORDER BY {$tables['products_reviews']}.ctime DESC ", "LIMIT {$navigation['first_page']}, {$navigation['objects_per_page']}", FALSE)); $items_per_page_targets[$target] = PHP_INT_MAX;
function import_products($xcart_conf) { extract($xcart_conf); extract(cw_vers_diff_attr($conn)); fout("<br /><br />Import of manufacturers, Products, Categories...<br />"); $cats = cw_table_copy_from_xcart_lit_sn($conn, 'categories', "categoryid as category_id, parentid as parent_id, if(avail='Y',1,0) as status, category, description, order_by"); cw_table_copy_from_xcart_lit($conn, 'xcart_categories', 'cw_categories_stats', "categoryid as category_id, views_stats"); cw_table_copy_from_xcart_lit_sn($conn, 'categories_lng', "UPPER(code) as code, categoryid as category_id, category, description"); cw_table_copy_from_xcart_lit_sn($conn, 'products_categories', "categoryid as category_id, productid as product_id,\n\t\t if(main='Y',1,0) as main, orderby"); $prods = cw_table_copy_from_xcart_comm_sn($conn, 'products', "productid as product_id, if(forsale='Y',1,0) as status"); cw_table_copy_from_xcart_lit($conn, 'xcart_products', 'cw_products_stats', "productid as product_id, views_stats, sales_stats, del_stats"); cw_table_copy_from_xcart_lit($conn, 'xcart_products', 'cw_products_warehouses_amount', "productid as product_id, avail"); cw_table_copy_from_xcart_lit_sn($conn, 'products_lng', "UPPER(code) as code, productid as product_id, product,descr,fulldescr,keywords"); db_query("TRUNCATE TABLE cw_products_prices"); $sql = "select priceid as price_id, prc.productid as product_id, quantity, price, list_price,\n\t\tvariantid as variant_id, membershipid as membership_id from xcart_pricing prc\n\t\tleft join xcart_products prd on prc.productid=prd.productid order by product_id, variant_id"; $prices = cw_query($sql, $conn); foreach ($prices as $arr) { cw_array2insert_esc('cw_products_prices', $arr); } // Memberships db_query("Delete from cw_memberships where membership_id!=0"); $mbrsh = cw_query("select * from xcart_memberships where membershipid!=0", $conn); $level = cw_query_first_cell("select level from cw_access_levels where membership_id=0 and area='A'"); db_query("Delete from cw_access_levels where membership_id!=0"); foreach ($mbrsh as $v) { extract($v); if ($area == 'A' || $area == 'P') { $area = 'A'; } else { $area = 'C'; } $membership_id = $membershipid; $show_prices = 1; cw_array2insert_esc('cw_memberships', compact('membership_id', 'area', 'membership', 'active', 'orderby', 'flag', 'show_prices')); if ($area == 'A') { cw_array2insert_esc('cw_access_levels', compact('membership_id', 'area', 'level')); } } db_query("Delete from cw_memberships_lng where membership_id!=0"); $mbrshl = cw_query("select * from xcart_memberships_lng where membershipid!=0", $conn); foreach ($mbrshl as $v) { extract($v); $membership_id = $membershipid; $code = strtoupper($code); cw_array2insert_esc('cw_memberships_lng', compact('membership_id', 'code', 'membership')); } cw_table_copy_from_xcart_lit($conn, 'xcart_products', 'cw_products_memberships', "productid as product_id, 0 as memberships_id"); cw_table_copy_from_xcart_lit($conn, 'xcart_categories', 'cw_categories_memberships', "categoryid as category_id, 0 as memberships_id"); $catmem = cw_query("select * from xcart_category_memberships", $conn); $prodmem = cw_query("select * from xcart_product_memberships", $conn); foreach ($catmem as $v) { extract($v); $membership_id = $membershipid; $category_id = $categoryid; cw_array2insert('cw_categories_memberships', compact('category_id', 'membership_id')); } foreach ($prodmem as $v) { extract($v); $membership_id = $membershipid; $product_id = $productid; cw_array2insert('cw_products_memberships', compact('product_id', 'membership_id')); } // manufacturers $mans = cw_table_copy_from_xcart_comm_sn($conn, 'manufacturers', "manufacturerid as manufacturer_id,\n\t\tprovider as warehouse_customer_id, if(avail='Y',1,0) as avail"); cw_table_copy_from_xcart_comm_sn($conn, 'manufacturers_lng', 'manufacturerid as manufacturer_id, UPPER(code) as code'); // Set Attributes: 0 for domains; Meta Tags, manufacturer_id for products, etc. if ($withcurls) { $tmp = cw_query("SELECT * from xcart_clean_urls", $conn); $clean_urls = array(); foreach ($tmp as $v) { extract($v); $clean_urls[$resource_type][$resource_id] = str_replace('.', '-', $clean_url); } } else { $tmp = cw_query("Select 'C' as type, categoryid as id, LCASE(category) as name from xcart_categories\n\t\t\tunion Select 'P' as type, productid as id, LCASE(product) as name from xcart_products\n\t\t\tunion Select 'M' as type, manufacturerid as id, LCASE(manufacturer) as name from xcart_manufacturers", $conn); $clean_urls = array(); $curls = array(); foreach ($tmp as $v) { extract($v); $cu = preg_replace("'[^a-z0-9]+'s", ' ', $name); $cu = str_replace(' ', '-', $cu); $i = 1; $curl = $cu; while (in_array($curl, $curls)) { $curl = $cu . '-' . $i++; } $clean_urls[$type][$id] = $curl; $curls[] = $curl; } unset($curls); } unset($tmp); if ($pwithmeta) { $prodmeta = cw_query("Select productid as id, 'P' as type, product, manufacturerid,\n\t\t meta_description, meta_keywords, title_tag, add_date from xcart_products", $conn); } else { $prodmeta = cw_query("Select productid as id, 'P' as type, product, descr,\n\t\t\tmanufacturerid, add_date from xcart_products", $conn); foreach ($prodmeta as $k => $v) { extract($v); $prodmeta[$k]['title_tag'] = trim($product); $descr = preg_replace("'</?[a-z]+.*?>'is", " ", $descr); $descr = trim(preg_replace("'\\s+'", " ", $descr)); $prodmeta[$k]['meta_description'] = $descr; $mk = preg_replace("'[^a-z]+'is", " ", $product); $prodmeta[$k]['meta_keywords'] = str_replace(' ', ', ', trim($mk)); } } db_query("TRUNCATE TABLE cw_products_system_info"); $admin = cw_query_first_cell("select customer_id from cw_customers where usertype='A' limit 1"); foreach ($prodmeta as $v) { extract($v); cw_set_attr($type, 'domains', $id, 0); cw_set_attr($type, 'meta_title', $id, $title_tag); cw_set_attr($type, 'meta_keywords', $id, $meta_keywords); cw_set_attr($type, 'meta_description', $id, $meta_description); if (isset($clean_urls[$type]) && isset($clean_urls[$type][$id])) { cw_set_attr($type, 'clean_url', $id, $clean_urls[$type][$id]); } cw_set_attr($type, 'manufacturer_id', $id, $manufacturerid); $product_id = $id; $creation_customer_id = $modification_customer_id = $admin; $creation_date = $modification_date = $add_date; cw_array2insert('cw_products_system_info', compact('product_id', 'creation_customer_id', 'creation_date', 'modification_customer_id', 'modification_date')); } if ($cwithmeta) { $catmeta = cw_query("Select categoryid as id, 'C' as type, category,\n\t\t meta_description, meta_keywords, title_tag from xcart_categories", $conn); } else { foreach ($cats as $k => $v) { extract($v); $catmeta[$k]['title_tag'] = trim($category); $descr = preg_replace("'</?[a-z]+.*?>'is", " ", $description); $descr = trim(preg_replace("'\\s+'", " ", $descr)); $catmeta[$k]['meta_description'] = $descr; $mk = preg_replace("'[^a-z]+'is", " ", $category); $catmeta[$k]['meta_keywords'] = str_replace(' ', ', ', trim($mk)); $catmeta[$k]['type'] = 'C'; $catmeta[$k]['id'] = $category_id; } } foreach ($catmeta as $v) { extract($v); cw_set_attr($type, 'domains', $id, 0); cw_set_attr($type, 'meta_title', $id, $title_tag); cw_set_attr($type, 'meta_keywords', $id, $meta_keywords); cw_set_attr($type, 'meta_description', $id, $meta_description); if (isset($clean_urls[$type]) && isset($clean_urls[$type][$id])) { cw_set_attr($type, 'clean_url', $id, $clean_urls[$type][$id]); } } if ($cwithmeta) { $manmeta = cw_query("Select manufacturerid as id, 'M' as type, manufacturer,\n\t\t meta_description, meta_keywords, title_tag from xcart_manufacturers", $conn); } else { foreach ($mans as $k => $v) { extract($v); $manmeta[$k]['title_tag'] = trim($manufacturer); $descr = preg_replace("'</?[a-z]+.*?>'is", " ", $descr); $descr = trim(preg_replace("'\\s+'", " ", $descr)); $manmeta[$k]['meta_description'] = $descr; $mk = preg_replace("'[^a-z]+'is", " ", $manufacturer); $manmeta[$k]['meta_keywords'] = str_replace(' ', ', ', trim($mk)); $manmeta[$k]['type'] = 'M'; $manmeta[$k]['id'] = $manufacturer_id; } } if (is_array($manmeta)) { foreach ($manmeta as $v) { extract($v); cw_set_attr($type, 'domains', $id, 0); cw_set_attr($type, 'meta_title', $id, $title_tag); cw_set_attr($type, 'meta_keywords', $id, $meta_keywords); cw_set_attr($type, 'meta_description', $id, $meta_description); if (isset($clean_urls[$type]) && isset($clean_urls[$type][$id])) { cw_set_attr($type, 'clean_url', $id, $clean_urls[$type][$id]); } } } // Grab categories, products (Thumbnails & Detailed), and manufacturers related Images cw_imgs_copy($xcart_conf, 'xcart_images_C', 'cw_categories_images_thumb', 'categories_images_thumb'); cw_imgs_copy($xcart_conf, 'xcart_images_T', 'cw_products_images_thumb', 'products_images_thumb', 70); cw_imgs_copy($xcart_conf, 'xcart_images_P', 'cw_products_images_det', 'products_images_det'); cw_imgs_copy($xcart_conf, 'xcart_images_D', 'cw_products_detailed_images', 'products_detailed_images', 800); cw_imgs_copy($xcart_conf, 'xcart_images_M', 'cw_manufacturer_images', 'manufacturer_images', 150); // Variants -- Classes cw_table_copy_from_xcart_comm($conn, 'xcart_variants', 'cw_product_variants', "variantid as variant_id, productid as product_id, concat(productcode,variantid) as eancode"); cw_table_copy_from_xcart_lit($conn, 'xcart_variant_items', 'cw_product_variant_items', "optionid as option_id, variantid as variant_id"); // Variants -- available in stock -- adding to cw_products_warehouses_amount, // where we alredy have 'avail' field for variants equal 0 (for prods without variants) $var_prod_avail = cw_query("Select variantid as variant_id, productid as product_id, avail from xcart_variants", $conn); foreach ($var_prod_avail as $v) { cw_array2insert('cw_products_warehouses_amount', $v); } cw_table_copy_from_xcart_comm($conn, 'xcart_classes', 'cw_product_options', "classid as product_option_id, class as field,\n\t\tclasstext as name, productid as product_id, if(avail='Y',1,0) as avail, is_modifier as type"); cw_table_copy_from_xcart_comm($conn, 'xcart_class_options', 'cw_product_options_values', "classid as product_option_id, option_name as name, if(avail='Y',1,0) as avail,\n\t\t optionid as option_id, if(modifier_type='\$',0,1) as modifier_type"); cw_table_copy_from_xcart_lit($conn, 'xcart_class_lng', 'cw_product_options_lng', "UPPER(code) as code, classid as product_option_id, classtext as name"); db_query("TRUNCATE TABLE cw_product_options_values_lng"); db_query("TRUNCATE TABLE cw_customers_warehouses"); // Product Links --- cw_table_copy_from_xcart_comm($conn, 'xcart_product_links', 'cw_linked_products', "productid1 as product_id, productid2 as linked_product_id, 1 as active"); // Featured Products cw_table_copy_from_xcart_lit_sn($conn, 'featured_products', "productid as product_id, 0 as category_id,\n\t\tproduct_order, if(avail='Y',1,0) as avail"); // Product review, ratings cw_table_copy_from_xcart_comm($conn, 'xcart_product_reviews', 'cw_products_reviews', "productid as product_id"); cw_table_copy_from_xcart_comm($conn, 'xcart_product_votes', 'cw_products_votes', "productid as product_id, vote_value/20 as vote_value"); // Taxes, tax rates cw_table_copy_from_xcart_comm_sn($conn, 'taxes', "taxid as tax_id, if(active='Y',1,0) as active,\n\t\t if(price_includes_tax='Y',1,0) as price_includes_tax, if(display_including_tax='Y',1,0) as display_including_tax"); cw_table_copy_from_xcart_comm_sn($conn, 'tax_rates', "rateid as rate_id, taxid as tax_id, zoneid as zone_id,\n\t\t 0 as wherehouse_customer_id"); db_query("DELETE from cw_languages_alt where name rlike '^tax\\_[0-9]+\$'"); cw_import_config($conn); // Menu -- Make top categories featured -- and add 8 top categories (with subcategories) to Top Menu db_query("Update cw_categories set featured=1 where parent_id=0 and status=1"); db_query("Update cw_categories set tm_active=1 where parent_id!=0"); $ids = cw_query_first_cell("select group_concat(category_id) as cids from\n\t\t(select category_id from cw_categories where parent_id=0 and status=1 order by order_by limit 8) cat"); db_query("Update cw_categories set tm_active=1 where category_id in ({$ids})"); cw_cat_tree_building(); db_query("TRUNCATE TABLE cw_categories_subcount"); cw_recalc_subcat_count(0); }
$doc_id = $print_doc_id; } if ($action == 'set_template' and $current_area == 'A') { if (is_array($label_data['elements'])) { foreach ($label_data['elements'] as $k => $el) { if (empty($el)) { unset($label_data['elements'][$k]); } } } $data = addslashes(serialize($label_data)); cw_array2update('layouts', array('data' => $data), "layout='{$target}'"); cw_header_location("index.php?target={$target}&mode=layout&doc_id={$doc_id}"); } if ($action == 'create_template' && $current_area == 'A' && $template['title']) { $layout_id = cw_array2insert('layouts', array('title' => $template['title'], 'layout' => 'docs_' . $docs_type)); db_query("update {$tables['docs_info']} set layout_id='{$layout_id}'"); cw_header_location("index.php?target={$target}&mode=layout&doc_id={$doc_id}"); } if ($action == 'copy_layout_template' && $current_area == 'A' && $template['source_layout_id'] && $template['source_layout_id'] != $template['layout_id']) { cw_web_copy_layout($template['source_layout_id'], $template['layout_id']); cw_header_location("index.php?target={$target}&mode=layout&doc_id={$doc_id}"); } if ($action == 'delete_template' && $current_area == 'A') { cw_web_delete_layout($template['layout_id']); db_query("update {$tables['docs_info']} set layout_id=0 where layout_id='" . $template['layout_id'] . "'"); cw_header_location("index.php?target={$target}&mode=layout&doc_id={$doc_id}"); } $info_type = 1; if (in_array($current_area, array('A', 'P'))) { $info_type += 512 + 8192;
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_user_update_contract($contract_id, $contract) { global $tables; $to_insert = array('title' => $contract['title'], 'content' => $contract['content']); if ($contract_id) { $to_insert['contract_id'] = $contract_id; } return cw_array2insert('user_contracts', $to_insert, true); }
function add($product_id, $category_id, $main = true) { // TODO: Implement return cw_array2insert(); }
# # Update shipping table # if (is_array($posted_data)) { foreach ($posted_data as $rate_id => $v) { cw_array2update("shipping_rates", array("minweight" => cw_convert_number($v['minweight']), "maxweight" => cw_convert_number($v['maxweight']), "mintotal" => cw_convert_number($v['mintotal']), "maxtotal" => cw_convert_number($v['maxtotal']), "rate" => cw_convert_number($v['rate']), "item_rate" => cw_convert_number($v['item_rate']), "rate_p" => cw_convert_number($v['rate_p']), "overweight" => cw_convert_number($v['overweight']), "overweight_rate" => cw_convert_number($v['overweight_rate']), "rate_p" => cw_convert_number($v['rate_p']), "weight_rate" => cw_convert_number($v['weight_rate'])), "rate_id='{$rate_id}' {$warehouse_condition} {$type_condition}"); } $top_message['content'] = cw_get_langvar_by_name("msg_shipping_rates_upd"); } } if ($action == "add") { # # Add new shipping rate # if ($shipping_id_new) { cw_array2insert("shipping_rates", array("shipping_id" => $shipping_id_new, "minweight" => cw_convert_number($minweight_new), "maxweight" => cw_convert_number($maxweight_new), "maxamount" => cw_convert_number($maxamount_new), "mintotal" => cw_convert_number($mintotal_new), "maxtotal" => cw_convert_number($maxtotal_new), "rate" => cw_convert_number($rate_new), "item_rate" => cw_convert_number($item_rate_new), "rate_p" => cw_convert_number($rate_p_new), "weight_rate" => cw_convert_number($weight_rate_new), "warehouse_customer_id" => $user_account['warehouse_customer_id'], "zone_id" => $zone_id_new, "type" => $type, "overweight" => cw_convert_number($overweight_new), "overweight_rate" => cw_convert_number($overweight_rate_new))); $top_message['content'] = cw_get_langvar_by_name("msg_shipping_rate_add"); } } cw_header_location("index.php?target=shipping_rates&zone_id={$zone_id}&shipping_id={$shipping_id}&type={$type}"); } $zone_condition = $zone_id != "" ? "and {$tables['shipping_rates']}.zone_id='{$zone_id}'" : ""; $method_condition = $shipping_id != "" ? "and {$tables['shipping_rates']}.shipping_id='{$shipping_id}'" : ""; $shipping_rates = cw_query("SELECT {$tables['shipping_rates']}.*, {$tables['shipping']}.shipping, {$tables['shipping']}.shipping_time, {$tables['shipping']}.destination FROM {$tables['shipping']}, {$tables['shipping_rates']} WHERE {$tables['shipping_rates']}.shipping_id={$tables['shipping']}.shipping_id AND {$tables['shipping']}.active=1 {$warehouse_condition} {$type_condition} {$zone_condition} {$method_condition} " . ($type == "R" ? " AND code!='' " : '') . " ORDER BY {$tables['shipping']}.orderby, {$tables['shipping_rates']}.maxweight"); # # Prepare zones list # $zones = array(array("zone_id" => 0, "zone" => cw_get_langvar_by_name("lbl_zone_default"))); $_tmp = cw_query("SELECT zone_id, zone_name as zone FROM {$tables['zones']} WHERE 1 {$warehouse_condition} and is_shipping=1 ORDER BY zone_id"); if (!empty($_tmp)) { $zones = cw_array_merge($zones, $_tmp);
if (!empty($list['list_id'])) { cw_array2update('newslists', $list_values, "list_id='{$list['list_id']}'"); $top_message['content'] = cw_get_langvar_by_name("msg_adm_newslist_upd"); } else { $list_values['lngcode'] = empty($edit_lng) ? $current_language : $edit_lng; cw_array2insert('newslists', $list_values); $list['list_id'] = db_insert_id(); $top_message['content'] = cw_get_langvar_by_name("msg_adm_newslists_add"); } db_query("delete from {$tables['newslists_memberships']} where list_id='{$list['list_id']}'"); if (is_array($memberships)) { $arr_to_insert = array(); $arr_to_insert['list_id'] = $list['list_id']; foreach ($memberships as $membership_id) { $arr_to_insert['membership_id'] = $membership_id; cw_array2insert('newslists_memberships', $arr_to_insert, true); } } } else { $top_message = array('content' => cw_get_langvar_by_name('err_filling_form'), 'type' => 'E'); $nwslt_object =& cw_session_register('nwslt_object'); $nwslt_object['fill_error'] = $fill_error; $nwslt_object['list'] = $list; cw_header_location("index.php?target={$target}&list_id=" . $list['list_id']); } cw_header_location("index.php?target={$target}&list_id=" . $list['list_id']); } $location[] = array(cw_get_langvar_by_name('lbl_news_management'), 'index.php?target=' . $target); if (isset($_GET['list_id'])) { if (!empty($list_id)) { $list = cw_query_first("select * from {$tables['newslists']} WHERE list_id='{$list_id}'");
<?php if (!$user_type) { $user_type = 'C'; } cw_load('user', 'profile_fields'); if ($action == 'update_status' && is_array($upd_flag)) { foreach ($upd_flag as $field_id => $v) { db_query("delete from {$tables['register_fields_avails']} where field_id='{$field_id}' and (area like '" . $user_type . "_%' or area like '#" . $user_type . "_%' or area = '#{$user_type}')"); if ($upd[$field_id]) { foreach ($upd[$field_id] as $area => $state) { $ins = array('is_avail' => $state['a'], 'is_required' => $state['r'], 'field_id' => $field_id, 'area' => $area); cw_array2insert('register_fields_avails', $ins, true); } } } cw_header_location("index.php?target={$target}&user_type={$user_type}&js_tab=profile_options"); } if ($action == 'update_fields' && is_array($update)) { foreach ($update as $k => $v) { if ($k == 0) { if ($v['field']) { cw_profile_fields_add_field($v); } } else { cw_profile_fields_update_field($k, $v); } } cw_header_location("index.php?target={$target}&mode=fields&js_tab=addition_fields"); } if ($action == 'delete_fields' && is_array($update)) {
continue; } if ($k) { $v['rule_id'] = $k; } if (empty($v['target'])) { continue; } cw_array2insert('user_actions_rules', $v, true); } foreach ($upd_action as $k => $v) { if ($v['del'] == 'Y') { db_query("delete from {$tables['user_actions']} where action_id='{$k}'"); db_query("update {$tables['user_actions_rules']} set action_id=0 where action_id='{$k}'"); continue; } if ($k) { $v['action_id'] = $k; } if (empty($v['title'])) { continue; } cw_array2insert('user_actions', $v, true); } cw_header_location('index.php?target=log'); } $targets = cw_query("select * from {$tables['user_actions_rules']} order by target, orderby"); $smarty->assign('targets', $targets); $user_actions = cw_query("select * from {$tables['user_actions']} order by title"); $smarty->assign('user_actions', $user_actions); $smarty->assign('main', 'log');
function cw_faq_update_path($rubrik_id) { global $tables; $path = array(); $path[] = $rubrik_id; $level = 0; cw_faq_generate_path($rubrik_id, $path); db_query("delete from {$tables['faq_rubrik_parents']} where rubrik_id='{$rubrik_id}'"); foreach ($path as $val) { cw_array2insert('faq_rubrik_parents', array('rubrik_id' => $rubrik_id, 'parent_rubrik_id' => $val, 'level' => $level++), 1); } return $path; }
$add_coupon['apply_product_once'] = 1; } elseif ($how_to_apply_c == 2) { $add_coupon['apply_product_once'] = 0; $add_coupon['apply_category_once'] = 0; } else { $add_coupon['apply_product_once'] = 1; $add_coupon['apply_category_once'] = 0; } break; } if (empty($add_coupon['coupon']) || empty($add_coupon['discount']) && $add_coupon['coupon_type'] != 'free_ship' || cw_query_first_cell("select count(*) from {$tables['discount_coupons']} where coupon='{$add_coupon['coupon']}'") > 0) { $saved_coupon_data = $add_coupon; $top_message = array('content' => cw_get_langvar_by_name('msg_err_discount_coupons_add'), 'type' => 'E'); cw_header_location("index.php?target={$target}&mode=add"); } else { cw_array2insert('discount_coupons', $add_coupon, 1, array('coupon', 'discount', 'coupon_type', 'minimum', 'times', 'per_user', 'expire', 'status', 'product_id', 'category_id', 'recursive', 'apply_category_once', 'apply_product_once')); $top_message['content'] = cw_get_langvar_by_name('msg_discount_coupons_add'); cw_session_unregister('saved_coupon_data'); } cw_header_location("index.php?target={$target}"); } if ($mode == 'add') { $smarty->assign('main', 'add_new_coupon'); } else { $coupons = cw_query("select * from {$tables['discount_coupons']}"); $smarty->assign('coupons', $coupons); $smarty->assign('main', 'coupons'); } $smarty->assign('coupon_data', $saved_coupon_data); $smarty->assign('current_main_dir', 'addons'); $smarty->assign('current_section_dir', 'discount_coupons');