| Server IP : 213.186.33.4 / Your IP :
216.73.216.146 [
Web Server : Apache System : Linux webm002.cluster103.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : dealkatnwc ( 662330) PHP Version : 7.0.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/dealkatnwc/www/GARAGE/php_action/ |
Upload File : |
<?php
require_once 'core.php';
$valid['success'] = array('success' => false, 'messages' => array());
if($_POST) {
$orderId = $_POST['orderId'];
$orderDate = date('Y-m-d', strtotime($_POST['orderDate']));
$clientName = $_POST['clientName'];
$clientContact = $_POST['clientContact'];
$mechanicName = $_POST['mname'];
$supervisorName = $_POST['sname'];
$vehicleName = $_POST['vname'];
$vehicleType = $_POST['vtype'];
$deliveryDate = $_POST['deliverydate'];
$deliveryTime = $_POST['deliverytime'];
$subTotalValue = $_POST['subTotalValue'];
$vatValue = $_POST['vatValue'];
$totalAmountValue = $_POST['totalAmountValue'];
$discount = $_POST['discount'];
$grandTotalValue = $_POST['grandTotalValue'];
$paid = $_POST['paid'];
$dueValue = $_POST['dueValue'];
$paymentType = $_POST['paymentType'];
$paymentStatus = $_POST['paymentStatus'];
$paymentPlace = $_POST['paymentPlace'];
$gstn = $_POST['gstn'];
$userid = $_SESSION['userId'];
$sql = "UPDATE orders SET order_date = '$orderDate', client_name = '$clientName', client_contact = '$clientContact',mechanicname = '$mechanicName',supervisor_name = '$supervisorName',vehicle_type = '$vehicleType',vehicle_name = '$vehicleName',delivery_date = '$deliveryDate',delivery_time = '$deliveryTime', sub_total = '$subTotalValue', vat = '$vatValue', total_amount = '$totalAmountValue', discount = '$discount', grand_total = '$grandTotalValue', paid = '$paid', due = '$dueValue', payment_type = '$paymentType', payment_status = '$paymentStatus', order_status = 1 ,user_id = '$userid',payment_place = '$paymentPlace' , gstn = '$gstn' WHERE order_id = {$orderId}";
$connect->query($sql);
$readyToUpdateOrderItem = false;
// add the quantity from the order item to product table
for($x = 0; $x < count($_POST['productName']); $x++) {
// product table
$updateProductQuantitySql = "SELECT product.quantity FROM product WHERE product.product_id = ".$_POST['productName'][$x]."";
$updateProductQuantityData = $connect->query($updateProductQuantitySql);
while ($updateProductQuantityResult = $updateProductQuantityData->fetch_row()) {
// order item table add product quantity
$orderItemTableSql = "SELECT order_item.quantity FROM order_item WHERE order_item.order_id = {$orderId}";
$orderItemResult = $connect->query($orderItemTableSql);
$orderItemData = $orderItemResult->fetch_row();
$editQuantity = $updateProductQuantityResult[0] + $orderItemData[0];
$updateQuantitySql = "UPDATE product SET quantity = $editQuantity WHERE product_id = ".$_POST['productName'][$x]."";
$connect->query($updateQuantitySql);
} // while
if(count($_POST['productName']) == count($_POST['productName'])) {
$readyToUpdateOrderItem = true;
}
} // /for quantity
// remove the order item data from order item table
for($x = 0; $x < count($_POST['productName']); $x++) {
$removeOrderSql = "DELETE FROM order_item WHERE order_id = {$orderId}";
$connect->query($removeOrderSql);
} // /for quantity
if($readyToUpdateOrderItem) {
// insert the order item data
for($x = 0; $x < count($_POST['productName']); $x++) {
$updateProductQuantitySql = "SELECT product.quantity FROM product WHERE product.product_id = ".$_POST['productName'][$x]."";
$updateProductQuantityData = $connect->query($updateProductQuantitySql);
while ($updateProductQuantityResult = $updateProductQuantityData->fetch_row()) {
$updateQuantity[$x] = $updateProductQuantityResult[0] - $_POST['quantity'][$x];
// update product table
$updateProductTable = "UPDATE product SET quantity = '".$updateQuantity[$x]."' WHERE product_id = ".$_POST['productName'][$x]."";
$connect->query($updateProductTable);
// add into order_item
$orderItemSql = "INSERT INTO order_item (order_id, product_id, quantity, rate, total, order_item_status)
VALUES ({$orderId}, '".$_POST['productName'][$x]."', '".$_POST['quantity'][$x]."', '".$_POST['rateValue'][$x]."', '".$_POST['totalValue'][$x]."', 1)";
$connect->query($orderItemSql);
} // while
} // /for quantity
}
$valid['success'] = true;
$valid['messages'] = "Successfully Updated";
$connect->close();
header('location:'.$_SERVER['HTTP_REFERER']);
echo json_encode($valid);
} // /if $_POST
// echo json_encode($valid);