/**
* getting array of all orders
* @return array $orders
*/
function get_all_orders(&$pag_info)
{
$orders = array();
$total = db_query_to_row("SELECT COUNT(id) as total FROM orders WHERE status > 0");
if ($total) {
$count = $total['total'];
$p = new Pagination();
$page = isset($_GET['page']) ? abs((int) $_GET['page']) : 1;
$pag_info = $p->calculate_pages($count, 10, $page);
$orders = db_query_to_array("SELECT o.*, u.first_name, u.last_name FROM orders as o LEFT JOIN users as u ON u.id = o.user_id WHERE o.status > 0 ORDER BY o.id DESC " . $pag_info['limit']);
if ($orders) {
foreach ($orders as &$order) {
$week_numbers = get_order_weeks($order['id']);
$order['week_number'] = '';
foreach ($week_numbers as $week) {
$order['week_number'] = $week;
break;
}
}
}
}
return $orders;
}
<?php
if (!($order_id = $_SESSION['order_id']) || !isset($_SESSION['user'])) {
header('location: /');
exit;
}
import('checkout');
import('store');
$materials = get_materials();
$campaign_orders = get_campaign_orders($order_id);
$order_weeks = get_order_weeks($order_id);
$banner_orders = get_additional_orders_by_type($order_id, 1);
$poster_orders = get_additional_orders_by_type($order_id, 2);
$rollup_orders = get_additional_orders_by_type($order_id, 3);
$campaign_stores = get_campaign_stores($order_id);
$campaign_totals = get_campaign_items_total($order_id);
$campaign_orders_list = get_campaign_orders_list($order_id);
$prices = get_campaign_prices();
$add_prices = get_additional_prices();
$template_name = '';
if ($campaign_orders && !$banner_orders && !$poster_orders && !$rollup_orders) {
$template_name = 'campaign_checkout';
} elseif (!$campaign_orders && $banner_orders && !$poster_orders && !$rollup_orders) {
$template_name = 'banners_checkout';
} elseif (!$campaign_orders && !$banner_orders && $poster_orders && !$rollup_orders) {
$template_name = 'posters_checkout';
} elseif (!$campaign_orders && !$banner_orders && !$poster_orders && $rollup_orders) {
$template_name = 'rollups_checkout';
} elseif ($campaign_orders || $banner_orders || $poster_orders || $rollup_orders) {
$template_name = 'full_checkout';
}
