db_query("update {$tables['discount_coupons']} set status='{$v['status']}' where coupon='{$coupon}'"); } $top_message["content"] = cw_get_langvar_by_name("msg_discount_coupons_upd"); cw_header_location("index.php?target={$target}"); } if ($action == 'delete' && is_array($posted_data)) { foreach ($posted_data as $coupon => $v) { if ($v['to_delete']) { db_query("delete from {$tables['discount_coupons']} where coupon='{$coupon}'"); } } $top_message["content"] = cw_get_langvar_by_name("msg_discount_coupons_upd"); cw_header_location("index.php?target={$target}"); } if ($action == 'add') { cw_core_process_date_fields($add_coupon, array('' => array('expire' => 0))); switch ($apply_to) { case '': $add_coupon['product_id'] = 0; $add_coupon['category_id'] = 0; break; case 'product': $add_coupon['category_id'] = 0; $add_coupon['apply_product_once'] = $add_coupon['how_to_apply_p']; break; case 'category': $add_coupon['product_id'] = 0; if ($add_coupon['how_to_apply_c'] == 1) { $add_coupon['apply_product_once'] = 1; } elseif ($how_to_apply_c == 2) { $add_coupon['apply_product_once'] = 0;
case 'is_logged': case 'current_area': case 'REQUEST_URI': case 'REQUEST_METHOD': case 'GET_POST': case 'target_code': case 'cwsid': case 'HTTP_REFERER': case 'REDIRECT_URL': $orderby_qry = " order by `{$logging_search['sortby']}` " . ($logging_search['sortdir'] ? 'desc' : 'asc'); break; } if ($REQUEST_METHOD == "POST") { if ($action == "filter_logs") { $date_fields = array('date' => array('date_start' => 0, 'date_end' => 1)); cw_core_process_date_fields($logs_filter, $date_fields, array()); foreach ($log_columns as $lc_k => $lc_v) { if (!intval($lc_v['fixed'])) { $log_columns[$lc_k]['display'] = !empty($logs_cols[$lc_k]); } } $logging_filter = $logs_filter; } elseif ($action == 'archive_logs') { if (!file_exists($var_dirs['logs_archive'])) { mkdir($var_dirs['logs_archive']); } $curr_year = date('Y'); if (!file_exists($var_dirs['logs_archive'] . '/' . $curr_year)) { mkdir($var_dirs['logs_archive'] . '/' . $curr_year); } $curr_month = date('m');
$search_data['users'][$usertype] = 0; } cw_header_location("index.php?target={$target}&mode=search"); } elseif ($action == 'delete_search_load') { if ($current_loaded_search_id) { db_query("delete from {$tables['saved_search']} where ss_id = '{$current_loaded_search_id}'"); $current_loaded_search_id = 0; $save_search_id = 0; $search_data['users'][$usertype] = 0; } cw_header_location("index.php?target={$target}&mode=search"); } elseif ($REQUEST_METHOD == "POST") { $current_loaded_search_id = 0; $date_fields = array('admin' => array('creation_date_start' => 0, 'creation_date_end' => 1, 'modify_date_start' => 0, 'modify_date_end' => 1), 'orders' => array('order_date_start' => 0, 'order_date_end' => 1), 'marketing' => array('docs_start' => 0, 'docs_end' => 1), 'saldo' => array('date_start' => 0, 'date_end' => 1)); $multiple_fields = array('sale' => array('membership', 'sales_manager', 'language'), 'mail' => array('news_list')); cw_core_process_date_fields($posted_data, $date_fields, $multiple_fields); if (!empty($posted_data)) { $posted_data['orders']['orders_product'] = intval($orders_product); // for now it accepts only one ID $search_data['users'][$usertype] = $posted_data; // TODO: remove js_tab based on custom smarty block js_tabs $search_data['users'][$usertype]['js_tab'] = $js_tab; } $search_data['users'][$usertype]['search_sections'] = $search_sections; // if (!empty($search_data['users'][$usertype]['orders'])) { // cw_call('cw_doc_save_history_totals_by_customer', array(array())); // } if (!empty($search_data['users'][$usertype]['orders']['orders_count_from']) || !empty($search_data['users'][$usertype]['orders']['orders_count_to']) || !empty($search_data['users'][$usertype]['orders']['avg_subtotal_from']) || !empty($search_data['users'][$usertype]['orders']['avg_subtotal_to']) || !empty($search_data['users'][$usertype]['orders']['total_spent_from']) || !empty($search_data['users'][$usertype]['orders']['total_spent_to'])) { db_query("delete from {$tables['customers_docs_stats_processed_docs']}"); db_query("delete from {$tables['customers_docs_stats']}"); $valid_statuses = cw_query_column("select code from {$tables['order_statuses']} where inventory_decreasing=1");
$presaved_content_section =& cw_session_register('presaved_content_section', array()); $file_upload_data =& cw_session_register('file_upload_data'); $top_message =& cw_session_register('top_message'); cw_load('category', 'image', 'attributes', 'files'); cw_image_clear(array('cms_images')); if ($REQUEST_METHOD == 'POST') { switch ($action) { case 'update_content_section': case 'add_new_content_section': if ($action == 'update_content_section' && empty($contentsection_id)) { cw_header_location('index.php?target=cms&mode=add'); } if (!empty($content_section) && is_array($content_section)) { //$content_section = array_map('trim', $content_section); cw_core_process_date_fields($content_section, array(0 => array('start_date' => 0, 'end_date' => 1))); $content_section['orderby'] = intval($content_section['orderby']); $content_section['display_on_404'] = empty($content_section['display_on_404']) ? 'N' : 'Y'; $content_section['active'] = empty($content_section['active']) ? 'N' : 'Y'; $content_section['parse_smarty_tags'] = !empty($content_section['parse_smarty_tags']); $presaved_content_section = $content_section; /* * Validation */ cw_include('include/lib/formvalidator/formvalidator.php', INCLUDE_NO_GLOBALS); // Errors $validator = new FormValidator(); $validator->addValidation("service_code", "req", cw_get_langvar_by_name('msg_ab_err_servicecode_is_empty')); $validator->addValidation("service_code", "varname", cw_get_langvar_by_name('msg_ab_err_wrong_servicecode_format')); if (!$validator->ValidateForm($content_section)) { cw_add_top_message($validator->GetErrors(), 'E');
<?php cw_load('cart', 'files', 'mail', 'user'); if ($action == 'update') { $date_fields = array('' => array('event_date' => 0)); cw_core_process_date_fields($event_details, $date_fields); if (!$event_details['title']) { $top_message = array('type' => 'E', 'content' => cw_get_langvar_by_name('err_giftreg_required_fields_msg')); $event_details_sess =& cw_session_register('event_details_sess', $event_details); cw_header_location("index.php?target=giftreg_manage&event_id={$event_id}"); } $event_id = cw_query_first_cell("select event_id from {$tables['giftreg_events']} where event_id='{$event_id}' and customer_id='{$customer_id}'"); if (!$event_id) { $count = cw_query_first_cell("select count(*) FROM {$tables['giftreg_events']} WHERE customer_id='{$customer_id}'"); if ($count < $config['estore_gift']['events_lists_limit']) { $event_id = cw_array2insert('giftreg_events', array('customer_id' => $customer_id)); } else { $error = 'events_limit_exceeded'; } } if (empty($error)) { cw_array2update('giftreg_events', $event_details, "event_id='{$event_id}'", array('status', 'title', 'event_date', 'description', 'html_content', 'guestbook')); } else { $top_message = array('type' => 'E', 'content' => cw_get_langvar_by_name('err_giftreg_events_lists_limit')); } cw_header_location("index.php?target=gifts&mode=events&event_id={$event_id}"); } if ($action == 'guestbook') { $events_creator = cw_query_first_cell("select customer_id from {$tables['giftreg_events']} where event_id='{$event_id}' and guestbook=1"); if (!$events_creator) { cw_header_location("index.php?target={$target}&mode=events");
<?php $saved_post_data =& cw_session_register('saved_post_data'); $filter_surveys =& cw_session_register('filter_surveys', array()); if ($action == 'update_details' && is_array($posted_data)) { cw_core_process_date_fields($posted_data, array('' => array('valid_from_date' => 0, 'expires_data' => 1)), null); $fields_to_update = array('survey_type', 'valid_from_date', 'expires_data', 'publish_results', 'display_on_frontpage'); if ($edited_language == $config['default_admin_language']) { $fields_to_update = array_merge($fields_to_update, array('header', 'footer', 'complete', 'survey')); } cw_array2update('surveys', $posted_data, "survey_id = '{$survey_id}'"); $posted_data['code'] = $edited_language; $posted_data['survey_id'] = $survey_id; cw_array2insert('surveys_lng', $posted_data, true, array('survey_id', 'survey', 'header', 'footer', 'complete', 'code')); $top_message['content'] = cw_get_langvar_by_name('txt_survey_is_modifyed'); cw_header_location("index.php?target={$target}&survey_id=" . $survey_id); } if ($action == 'update_structure' && is_array($posted_data)) { $fields_to_update = array('answers_type', 'col', 'orderby'); $fields_to_update_answer = array('textbox_type', 'orderby'); if ($edited_language == $config['default_admin_language']) { $fields_to_update = array_merge($fields_to_update, array('question')); $fields_to_update_answer = array_merge($fields_to_update_answer, array('answer')); } foreach ($posted_data as $qid => $d) { if ($qid == 0 && empty($d['question'])) { continue; } if ($qid == 0) { $qid = cw_array2insert('survey_questions', array('survey_id' => $survey_id, 'question' => $d['question']), false, array('survey_id', 'question')); }
cw_load('map', 'warehouse', 'product', 'accounting', 'taxes', 'doc'); if (in_array($action, array('update', 'delete')) || in_array($mode, array('delete', 'delete_all'))) { cw_include('include/orders/process.php'); } if ($action == 'print' && is_array($doc_ids)) { global $doc_id; $doc_id = implode(',', array_keys($doc_ids)); cw_include('include/orders/order.php'); } if ($action == 'reset') { $search_data['profit_reports'] = array(); cw_header_location("index.php?target={$target}&mode=search"); } if ($REQUEST_METHOD == "POST" && is_array($posted_data)) { $date_fields = array('basic' => array('creation_date_start' => 0, 'creation_date_end' => 1)); cw_core_process_date_fields($posted_data, $date_fields); $posted_data['js_tab'] = $js_tab; $search_data['profit_reports'][$docs_type] = $posted_data; $search_data['profit_reports'][$docs_type]['search_sections'] = $search_sections; cw_header_location("index.php?target={$target}&mode=search"); } if (empty($search_data['profit_reports'][$docs_type])) { $search_data['profit_reports'] = array(); $date = getdate(cw_core_get_time()); $search_data['profit_reports'][$docs_type] = array('basic' => array('creation_date_start' => mktime(0, 0, 0, $date['mon'], 1, $date['year']), 'creation_date_end' => mktime(23, 59, 59, $date['mon'], $date['mday'], $date['year'])), 'search_sections' => array('tab_search_orders' => 1)); } if (empty($search_data['profit_reports'][$docs_type]['sort_field'])) { $search_data['profit_reports'][$docs_type]['sort_field'] = 'product'; $search_data['profit_reports'][$docs_type]['sort_direction'] = 0; } if ($sort && in_array($sort, array('product_id', 'product', 'cost', 'avg_price', 'avg_profit', 'qty', 'total_cost', 'total_sales', 'total_profit', 'margin', 'markup'))) {
function cw_doc_update_quotes($doc_id, $quotes) { global $tables; if ($quotes) { $sum_comission = 0; foreach ($quotes as $quote_id => $quote) { cw_core_process_date_fields($quote, array('' => array('exp_mail_before' => 0, 'exp_mail_after' => 0, 'exp_date' => 0))); if (!$quote['exp_date']) { unset($quote['exp_date']); } $quote_info = cw_query_first("select * from {$tables['docs_quotes']} where doc_quote_id='{$quote_id}'"); if ($quote['paid'] == $quote_info['total']) { $quote['status'] = 'C'; } if (in_array($quote['status'], array('C', 'P'))) { $quote['paid'] = $quote_info['total']; $sum_comission += $quote_info['commission']; } cw_array2update('docs_quotes', $quote, "doc_quote_id='{$quote_id}'"); } $doc = cw_call('cw_doc_get', array($doc_id)); cw_doc_update_commissions($doc_id, $doc, $sum_comission); } }
<?php define('AOM', 1); $aom_orders =& cw_session_register('aom_orders'); cw_load('doc', 'aom', 'taxes', 'warehouse', 'ean', 'product', 'cart', 'cart_process', 'category', 'web'); $error_message = ''; if ($action == 'functions') { cw_display('addons/pos/printer_functions_ajax.tpl', $smarty); exit(0); } if ($action == 'search_products') { cw_core_process_date_fields($posted_data, null, array('' => array('manufacturers', 'categories', 'suppliers'))); $aom_data = array(); $aom_data['categories_orig'] = $posted_data['categories_orig']; $aom_data['categories'] = $posted_data['categories']; if ($posted_data['attribute_names']['manufacturer_id'] && !empty($posted_data['attribute_names']['manufacturer_id'][0])) { $aom_data['attribute_names']['manufacturer_id'] = $posted_data['attribute_names']['manufacturer_id']; } $aom_data['product_id'] = $posted_data['product_id']; $aom_data['by_title'] = true; $aom_data['by_keywords'] = true; $aom_data['by_shortdescr'] = true; $aom_data['by_fulldescr'] = true; $aom_data['by_eancode'] = true; $aom_data['by_sku'] = true; $aom_data['substring'] = $posted_data['substring']; $aom_data['substring_exact'] = $posted_data['substring_exact']; $aom_data['limit'] = 30; $aom_data['flat_search'] = 1; $aom_data['sort_field'] = 'product'; $aom_data['sort_direction'] = 1;
if (!empty($delete_contentsections) && is_array($delete_contentsections)) { $delete_contentsections = array_keys($delete_contentsections); db_query("DELETE FROM {$tables['cms']} WHERE contentsection_id IN ('" . implode("','", $delete_contentsections) . "')"); db_query("DELETE FROM {$tables['cms_restrictions']} WHERE contentsection_id IN ('" . implode("','", $delete_contentsections) . "')"); db_query("DELETE FROM {$tables['cms_user_counters']} WHERE contentsection_id IN ('" . implode("','", $delete_contentsections) . "')"); db_query("DELETE FROM {$tables['cms_alt_languages']} WHERE contentsection_id IN ('" . implode("','", $delete_contentsections) . "')"); foreach ($delete_contentsections as $contentsection_id) { cw_image_delete($contentsection_id, 'cms_images'); cw_call('cw_attributes_cleanup', array($contentsection_id, 'AB')); } } break; case 'update_filters': if (!empty($filter) && is_array($filter)) { $date_fields = array(0 => array('start_filter_date' => 0, 'end_filter_date' => 1)); cw_core_process_date_fields($filter, $date_fields); $contentsections_filter = array('type' => $filter['type'], 'name' => stripslashes($filter['name']), 'target' => $filter['target'], 'url' => stripslashes($filter['url']), 'skin' => $filter['skin'], 'service_code' => stripslashes($filter['service_code']), 'start_date' => intval($filter['start_filter_date']), 'end_date' => intval($filter['end_filter_date']), 'sort_field' => 'service_code', 'sort_direction' => 0, 'attributes' => $attributes, 'offers' => $content_section['offers']); if (!empty($content_section_clean_urls) && is_array($content_section_clean_urls)) { $contentsections_filter['clean_urls'] = array(); foreach ($content_section_clean_urls as $cs_filter_cu) { $filter_clean_url = trim($cs_filter_cu['value']); if (!empty($filter_clean_url)) { $contentsections_filter['clean_urls'][] = $filter_clean_url; } } } if (!empty($restricted_attributes)) { $contentsections_filter['restricted_attributes'] = $restricted_attributes; } } break;
cw_product_update_system_info($product_id, array('supplier_customer_id' => $product_data['supplier'])); cw_group_edit_copy_system_info($product_id, array('supplier_customer_id' => $product_data['supplier'])); cw_warehouse_recalculate($product_id); cw_product_filter_recalculate_price_ranges(); // tags if (!empty($product_data['tags'])) { $tags = explode(',', $product_data['tags']); cw_tags_set_product_tags($tags, $product_id); } else { cw_tags_clear_product_tags($product_id); } } else { cw_add_top_message($fillerror, 'E'); $product_modified_data = $product_data; $product_modified_data['product_id'] = $product_id; cw_core_process_date_fields($product_modified_data, null, array('' => array('membership_ids', 'status'))); if ($file_upload_data['products_images_thumb']) { $file_upload_data['products_images_thumb']['is_redirect'] = false; $product_modified_data['image_thumb'] = $file_upload_data['products_images_thumb']; } if ($file_upload_data['products_images_det']) { $file_upload_data['products_images_det']['is_redirect'] = false; $product_modified_data['image_det'] = $file_upload_data['products_images_det']; } } cw_refresh($product_id); } if ($REQUEST_METHOD == "POST" && $action == "attributes_modify" && (AREA_TYPE == 'A' || AREA_TYPE == 'V')) { $product_data['attributes'] = $attributes; cw_call('cw_attributes_save', array('item_id' => $product_id, 'item_type' => 'P', 'attributes' => $product_data['attributes'], 'language' => $edited_language, array('is_default' => false))); $top_message = array('content' => cw_get_langvar_by_name('msg_adm_product_wholesale_upd'), 'type' => 'I');