} } 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>