$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");
