<?php check_user_security("my_orders"); $orders_currency = get_setting_value($settings, "orders_currency", 0); $html_template = get_setting_value($block, "html_template", "block_user_orders.html"); $t->set_file("block_body", $html_template); $t->set_var("user_orders_href", get_custom_friendly_url("user_orders.php")); $t->set_var("user_order_href", get_custom_friendly_url("user_order.php")); $t->set_var("user_home_href", get_custom_friendly_url("user_home.php")); $t->set_var("user_order_payment_href", get_custom_friendly_url("user_order_payment.php")); $t->set_var("user_invoice_pdf_href", get_custom_friendly_url("user_invoice_pdf.php")); $t->set_var("user_invoice_html_href", get_custom_friendly_url("user_invoice_html.php")); $s = new VA_Sorter($settings["templates_dir"], "sorter_img.html", get_custom_friendly_url("user_orders.php")); $s->set_default_sorting(1, "desc"); $s->set_sorter(ORDER_NUMBER_COLUMN, "sorter_id", "1", "order_id"); $s->set_sorter(ORDER_ADDED_COLUMN, "sorter_date", "2", "order_placed_date"); $s->set_sorter(STATUS_MSG, "sorter_status", "3", "order_status"); $s->set_sorter(ORDER_TOTAL_COLUMN, "sorter_total", "4", "order_total"); $n = new VA_Navigator($settings["templates_dir"], "navigator.html", get_custom_friendly_url("user_orders.php")); // set up variables for navigator $sql = " SELECT COUNT(*) FROM " . $table_prefix . "orders o "; $sql .= " WHERE o.user_id=" . $db->tosql(get_session("session_user_id"), INTEGER); if (isset($site_id)) { $sql .= " AND o.site_id=" . $db->tosql($site_id, INTEGER, true, false); } else { $sql .= " AND o.site_id=1"; } $db->query($sql); $db->next_record(); $total_records = $db->f(0); $records_per_page = 25;
if ($operation == "delete") { // delete an item $cart_item_id = get_param("cart_item_id"); $sql = " DELETE FROM " . $table_prefix . "saved_items "; $sql .= " WHERE cart_item_id=" . $db->tosql($cart_item_id, INTEGER); $sql .= " AND user_id=" . $db->tosql($_COOKIE['wishlist_user_id'], INTEGER); $db->query($sql); } } $html_template = get_setting_value($block, "html_template", "block_user_wishlist.html"); $t->set_file("block_body", $html_template); $t->set_var("user_wishlist_href", get_custom_friendly_url("user_wishlist.php")); $t->set_var("cart_retrieve_href", get_custom_friendly_url("cart_retrieve.php")); $t->set_var("user_home_href", get_custom_friendly_url("user_home.php")); $t->set_var("wishlist_message", "<p>Here is a list of the items you have selected.</p>Your wishlist is saved on this browser on this computer only. If you want to see your wishlist from another computer please <a href=\"./user_login.php?return_page=" . urlencode($site_url . get_custom_friendly_url('user_wishlist.php')) . "\">login to save it</a>.<br /><br />"); $s = new VA_Sorter($settings["templates_dir"], "sorter_img.html", get_custom_friendly_url("user_wishlist.php")); $s->set_parameters(false, true, true, false); $s->set_default_sorting(6, "desc"); $s->set_sorter(PROD_NAME_MSG, "sorter_item_name", "1", "si.item_name"); $s->set_sorter(PRICE_MSG, "sorter_price", "2", "si.price"); $s->set_sorter(QTY_MSG, "sorter_quantity", "3", "si.quantity"); $s->set_sorter(WISHLIST_BOUGHT_MSG, "sorter_quantity_bought", "4", "si.quantity_bought"); $s->set_sorter(TYPE_MSG, "sorter_type", "5", "st.type_name"); $s->set_sorter(CART_SAVED_DATE_COLUMN, "sorter_date", "6", "si.date_added"); $n = new VA_Navigator($settings["templates_dir"], "navigator.html", get_custom_friendly_url("user_wishlist.php")); // set up variables for navigator $sql = " SELECT COUNT(*) FROM " . $table_prefix . "saved_items si "; $sql .= " WHERE si.user_id=" . $db->tosql($_COOKIE['wishlist_user_id'], INTEGER); $sql .= " AND si.cart_id=0 "; $db->query($sql); $db->next_record();
$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"); $t->set_var("admin_href", "admin.php"); $t->set_var("admin_import_href", "admin_import.php"); $t->set_var("admin_export_href", "admin_export.php"); $t->set_var("admin_invoice_pdf_href", "admin_invoice_pdf.php"); $t->set_var("admin_packing_pdf_href", "admin_packing_pdf.php"); $t->set_var("admin_orders_bom_pdf_href", "admin_orders_bom_pdf.php"); $s = new VA_Sorter($settings["admin_templates_dir"], "sorter_img.html", "admin_orders.php"); $s->set_parameters(false, true, true, false); $s->set_default_sorting(1, "desc"); $s->set_sorter(ORDER_NUMBER_COLUMN, "sorter_id", "1", "o.order_id"); $s->set_sorter(ORDER_ADDED_COLUMN, "sorter_date", "2", "o.order_placed_date"); $s->set_sorter(STATUS_MSG, "sorter_status", "3", "o.order_status"); $s->set_sorter(ADMIN_ORDER_TOTAL_MSG, "sorter_total", "4", "o.order_total"); if (get_setting_value($order_info, "show_delivery_country_id", 0) == 1) { $s->set_sorter(EMAIL_TO_MSG, "sorter_ship_to", "5", "o.delivery_country_id"); } else { $s->set_sorter(EMAIL_TO_MSG, "sorter_ship_to", "5", "o.country_id"); } $s->set_sorter(SITE_NAME_MSG, "sorter_site_name", "6", "sti.site_name"); $n = new VA_Navigator($settings["admin_templates_dir"], "navigator.html", "admin_orders.php"); include_once "./admin_header.php"; include_once "./admin_footer.php";
if ($db_type != 'postgre') { $sql_params["distinct"] = " ic.category_id, i.item_id"; } } else { $sql_params["distinct"] = " i.item_id"; } $total_records = VA_Products::count($sql_params, VIEW_CATEGORIES_ITEMS_PERM); $sql_params["distinct"] = ""; $details_parameters = $pass_parameters; // use all parameters for details page if ($friendly_urls && $page_friendly_url) { for ($fp = 0; $fp < sizeof($page_friendly_params); $fp++) { unset($pass_parameters[$page_friendly_params[$fp]]); } } $s = new VA_Sorter($settings["templates_dir"], "sorter_img.html", $products_page, "sort", "", $pass_parameters); // use products order for category only if results grouped by categories or it is only one category products available $category_order = $products_group_by_cats || !$show_sub_products && ($category_id || !$is_search && !$is_manufacturer && !$is_user); if ($products_sortings) { $s->set_parameters(false, true, true, false); $s->set_default_sorting(1, "asc"); if ($category_order) { $s->set_sorter(PROD_SORT_DEFAULT_MSG, "sorter_default", "1", "ic.item_order, i.item_order, i.item_id", "ic.item_order, i.item_order, i.item_id", "ic.item_order DESC, i.item_order, i.item_id"); } else { $s->set_sorter(PROD_SORT_DEFAULT_MSG, "sorter_default", "1", "i.item_order, i.item_id", "i.item_order, i.item_id", "i.item_order DESC, i.item_id"); } if ($db_type == "mysql") { $s->set_sorter(PRICE_MSG, "sorter_price", "2", "i.price", "IF(i.is_sales=1, i.sales_price + COALESCE(i.properties_price,0), i.price + COALESCE(i.properties_price,0) )", "IF(i.is_sales=1, i.sales_price + COALESCE(i.properties_price,0), i.price + COALESCE(i.properties_price,0) ) DESC"); } elseif ($db_type == "access") { $s->set_sorter(PRICE_MSG, "sorter_price", "2", "i.price", "IIF(i.is_sales=1, (i.sales_price + IIF(ISNULL(i.properties_price),0,i.properties_price)), (i.price + IIF(ISNULL(i.properties_price),0,i.properties_price)) )", "IIF(i.is_sales=1, (i.sales_price + IIF(ISNULL(i.properties_price),0,i.properties_price)), (i.price + IIF(ISNULL(i.properties_price),0,i.properties_price)) ) DESC"); } elseif ($db_type == "postgre") {