}
}
if (!$myCheckout->check_return_shipment()) {
$cust_conn = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD);
mysql_select_db(DB_NAME, $cust_conn);
$cust_sql = sprintf("SELECT * FROM users,current WHERE current.email=users.email");
$cust_result = mysql_query($cust_sql) or die(mysql_error());
$cust_obj = mysql_fetch_object($cust_result);
$myCheckout->username = $cust_obj->username;
$myCheckout->email = $cust_obj->email;
$myCheckout->first_name = $cust_obj->first_name;
$myCheckout->last_name = $cust_obj->last_name;
mysql_free_result($cust_result);
$myCheckout->insert_new_shipment();
} else {
$myCheckout->set_shipment_data();
}
$myCheckout->show_ordered_rows();
$search_in = $myCheckout->get_order_num_string();
$query_stock = sprintf("SELECT art_no, amount AS on_stock FROM stock WHERE art_no IN (%s) ORDER BY art_no", $search_in);
$res_stock = mysql_query($query_stock);
if (mysql_fetch_assoc($res_stock)) {
while ($stock = mysql_fetch_assoc($res_stock)) {
$stock_array[$stock['art_no']] = $stock['on_stock'];
}
} else {
header("Location:index.php");
}
if (isset($_SESSION['user_id'])) {
?>
include './includes/header.html';
if (isset($_SESSION['user_id'])) {
if (isset($_GET['kraj'])) {
if ($_GET['kraj'] == 'Zavrsite') {
?>
<?php
}
}
$myConfirm = new db_stock_cart($_SESSION['custom_num']);
if ($myConfirm->get_number_of_records() == 0) {
header("Location: " . PROD_IDX);
}
// uputi korisnika nazad ako vise nema narudbi
$myConfirm->show_ordered_rows();
$myConfirm->set_shipment_data();
$sql_errors = 0;
foreach ($myConfirm->order_array as $val) {
$update_stock = sprintf("UPDATE stock SET amount = amount - %d, last_buy = NOW() WHERE art_no = '%s'", $val['quantity'], $val['product_id']);
if (!mysql_query($update_stock)) {
$sql_errors++;
}
}
if ($sql_errors == 0) {
$myConfirm->close_order();
} else {
$myConfirm->error = $myConfirm->messages(1);
}
?>
<h2>Vasa Narudzba </h2>
