Example #1
0
<?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();
Example #3
0
    $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") {