| 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
//ALTER TABLE `orders` ADD `payment_place` INT NOT NULL AFTER `payment_status`;
//TER TABLE `orders` ADD `gstn` VARCHAR(255) NOT NULL AFTER `payment_place`;
require_once 'core.php';
$valid['success'] = array('success' => false, 'messages' => array(), 'order_id' => '');
// print_r($valid);
if($_POST) {
$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 = "INSERT INTO `orders`(`order_date`, `client_name`, `client_contact`, `mechanicname`, `supervisor_name`, `vehicle_type`, `vehicle_name`, `delivery_date`, `delivery_time`, `sub_total`, `vat`, `total_amount`, `discount`, `grand_total`, `paid`, `due`, `payment_type`, `payment_status`, `payment_place`, `gstn`, `order_status`, `user_id`) VALUES ('$orderDate', '$clientName', '$clientContact', '$mechanicName', '$supervisorName', '$vehicleType', '$vehicleName', '$deliveryDate', '$deliveryTime', '$subTotalValue', '$vatValue', '$totalAmountValue', '$discount', '$grandTotalValue', '$paid', '$dueValue', '$paymentType', '$paymentStatus','$paymentPlace','$gstn', 1,'$userid')";
$order_id;
$orderStatus = false;
if($connect->query($sql) === true) {
$order_id = $connect->insert_id;
$valid['order_id'] = $order_id;
$orderStatus = true;
}else{
echo $connect->error.'\n';
echo $sql;
exit;
}
// echo $_POST['productName'];
$orderItemStatus = false;
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 ('$order_id', '".$_POST['productName'][$x]."', '".$_POST['quantity'][$x]."', '".$_POST['rateValue'][$x]."', '".$_POST['totalValue'][$x]."', 1)";
$connect->query($orderItemSql);
if($x == count($_POST['productName'])) {
$orderItemStatus = true;
}
} // while
} // /for quantity
$valid['success'] = true;
$valid['messages'] = "Successfully Added";
echo json_encode($valid);
header('location:fetchOrder.php');
$connect->close();
} // /if $_POST
// echo json_encode($valid);