/**
* getting user last additional order details
* @param int $user_id
* @param int $type
* @return array $additional_orders or false
*/
function get_last_additional_banner_order($user_id, $type)
{
$query = 'SELECT o.id FROM `orders` as o INNER JOIN additional_orders_items as a ON a.order_id=o.id WHERE o.user_id = ' . $user_id . ' AND a.type = ' . $type . ' ORDER BY o.id DESC LIMIT 1';
$order = db_query_to_list($query, 'id');
if ($order) {
$additional_orders = get_additional_orders_by_type($order[0], $type);
if ($additional_orders) {
return $additional_orders;
}
}
return false;
}
<?php
if (!($order_id = $_SESSION['order_id']) || !isset($_SESSION['user'])) {
header('location: /');
exit;
}
import('checkout');
$full_price = 0;
if ($campaign_orders = get_campaign_orders($order_id)) {
$full_price += get_campaign_order_total_price($order_id, $campaign_orders);
}
if ($banner_orders = get_additional_orders_by_type($order_id, 1)) {
$full_price += get_additional_order_total_price($banner_orders, 1);
}
if ($poster_orders = get_additional_orders_by_type($order_id, 2)) {
$full_price += get_additional_order_total_price($poster_orders, 2);
}
if ($rollup_orders = get_additional_orders_by_type($order_id, 3)) {
$full_price += get_additional_order_total_price($rollup_orders, 3);
}
update_in_db('orders', array('total_price' => $full_price, 'status' => 1), "user_id = {$_SESSION['user']['id']} AND id = {$order_id}");
unset($_SESSION['order_id']);
header('location: /test/orders');
exit;
