$cc_eg->change_property("category_id", USE_IN_WHERE, true); $cc_eg->change_property("category_id", USE_IN_SELECT, true); $columns_number = $cc_eg->get_db_values(); // clear delete parameters from request for ($i = 1; $i <= $columns_number; $i++) { $delete_param = "categories_columns_delete_" . $i; if (isset($_GET[$delete_param])) { unset($_GET[$delete_param]); } if (isset($_POST[$delete_param])) { unset($_POST[$delete_param]); } } set_session("session_settings", ""); // show success message $t->parse("success_block", false); } } } else { foreach ($r->parameters as $key => $value) { $sql = " SELECT setting_value FROM " . $table_prefix . "global_settings "; $sql .= " WHERE setting_type='products' AND setting_name='" . $key . "'"; $sql .= " AND ( site_id=1 OR site_id=" . $db->tosql($param_site_id, INTEGER) . ") "; $sql .= " ORDER BY site_id DESC "; $r->set_value($key, get_db_value($sql)); } // check data for categories columns $cc_eg->set_value("category_id", 0); $cc_eg->change_property("column_id", USE_IN_SELECT, true); $cc_eg->change_property("column_id", USE_IN_WHERE, false); $cc_eg->change_property("category_id", USE_IN_WHERE, true);
} else { if ($echo_this) { echo $xml_string .= $xml; $xml_string = null; } else { $xml_string .= $xml; } } } if ($show_stats == 1) { $t = new VA_Template($settings["admin_templates_dir"]); $t->set_file("main", "admin_export_google_base.html"); $countries = array(NOT_SPECIFIED_GB, US_MSG_GB, UK_DE_FR_MSG_GB, JP_MSG_GB, GOOGLE_RECOMEND_GB); if ($error) { $t->set_var('error_msg', $error); $t->parse('block_error', false); $t->set_var('block_stats', ''); $t->set_var('feed_button', ''); } else { $t->set_var('block_error', ''); $t->set_var('gb_file_name', $google_base_filename); $t->set_var('country', $countries[$google_base_country]); $t->set_var('work_time', round($workTime, 3)); $t->set_var('path', trim($site_url, '/') . $google_base_save_path . $google_base_filename); if ($warning) { $t->set_var('mess_style', 'color:red;float:left;margin-bottom:4px;'); $t->set_var('mess_text', ERRORS_MSG); foreach ($warning as $it_id => $warning_item) { $t->set_var('warning_mess', ''); $t->set_var('warning_mess_block', ''); $t->set_var('id', '');
if ($table == "orders") { if ($max_id > $exported_order_id) { $sql = " UPDATE " . $table_prefix . "admins SET exported_order_id=" . $db->tosql($max_id, INTEGER); $sql .= " WHERE admin_id=" . $db->tosql(get_session("session_admin_id"), INTEGER); $db->query($sql); } } } } exit; } } } if (strlen($errors)) { $t->set_var("errors_list", $errors); $t->parse("errors", false); } if ($template_errors) { $t->set_var("errors_list", $template_errors); $t->parse("template_errors", false); } if ($template_success) { $t->set_var("success_message", $template_success); $t->parse("template_success", false); } $t->set_var("category_id", htmlspecialchars($category_id)); $t->set_var("id", htmlspecialchars($id)); $t->set_var("ids", htmlspecialchars($ids)); $t->set_var("s_on", htmlspecialchars($s_on)); $t->set_var("s_ne", htmlspecialchars($s_ne)); $t->set_var("s_kw", htmlspecialchars($s_kw));
$day_after_end = mktime(0, 0, 0, $end_date[MONTH], $end_date[DAY] + 1, $end_date[YEAR]); $sql = " SELECT COUNT(*) FROM " . $table_prefix . "orders "; $sql .= " WHERE order_status=" . $db->tosql($status_id, INTEGER); $sql .= " AND order_placed_date>=" . $db->tosql($start_date, DATE); $sql .= " AND order_placed_date<" . $db->tosql($day_after_end, DATE); $period_orders = get_db_value($sql); if (isset($stats[$key]["total"])) { $stats[$key]["total"] += $period_orders; } else { $stats[$key]["total"] = $period_orders; } if ($period_orders > 0) { $period_orders = "<a href=\"admin_orders.php?s_os=" . $status_id . "&s_sd=" . va_date($date_edit_format, $start_date) . "&s_ed=" . va_date($date_edit_format, $end_date) . "\"><b>" . $period_orders . "</b></a>"; } $t->set_var("period_orders", $period_orders); $t->parse("stats_periods", true); } $t->parse("statuses_stats", true); } foreach ($stats as $key => $stat_info) { $t->set_var("start_date", va_date($date_edit_format, $stat_info["date_start"])); $t->set_var("end_date", va_date($date_edit_format, $stat_info["date_end"])); $t->set_var("stat_title", $stat_info["title"]); $t->set_var("period_total", $stat_info["total"]); $t->parse("stats_titles", true); $t->parse("stats_totals", true); } $t->set_var("admin_orders_href", "admin_orders.php"); $t->set_var("admin_order_href", $order_details_site_url . "admin_order.php"); $t->set_var("admin_invoice_html_href", "admin_invoice_html.php"); $t->set_var("admin_invoice_pdf_href", "admin_invoice_pdf.php");