|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/builty/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("inc/config.php");
?>
<!DOCTYPE html>
<html lang="en">
<?php require "inc/head.php"; ?>
<body>
<!-- header-->
<?php require "inc/header.php"; ?>
<!-- End Main-content Top bar-->
<!-- main-content-->
<div class="wrapper">
<?php require "inc/sidebar.php"; ?>
<div id="content">
<div class="row mb-4">
<div class="col-12 col-sm-12">
<div class="row">
<div class="col-12 col-md-12 mb-4">
<div class="card redial-border-light redial-shadow">
<div class="card-body" style="overflow: visible;">
<h6 class="header-title pl-3 redial-relative">Bilty</h6>
<?php
$id = $_GET['id'];
$query = "SELECT * FROM builties WHERE id='$id'";
$query_run = mysqli_query($conn, $query);
if (mysqli_num_rows($query_run) > 0) {
foreach ($query_run as $row) {
$lengths = explode(',', $row['length']);
$widths = explode(',', $row['width']);
$heights = explode(',', $row['height']);
$charge_weights = explode(',', $row['charge_weight']);
$quantities = explode(',', $row['demention_quantity']);
$volumes = explode(',', $row['volume']);
$amounts = explode(',', $row['total_weight']);
$box_weights = explode(',', $row['box_weight']);
$box_quantities = explode(',', $row['box_quantity']);
$box_total_weights = explode(',', $row['total_box_weight']);
$final_total_weight = $row['total_charged_weight'];
?>
<form action="add_builty.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="id" value="<?php echo $row['id']; ?>">
<div class="row">
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Consignor</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<select name="consignor" id="consignor" class="form-control">
<option value="">Select Consignee</option>
<?php
// Reuse same $clientQuery if needed
$clientQuery1 = "SELECT client_name FROM clients";
$clientResult1 = mysqli_query($conn, $clientQuery1);
while ($clientRow1 = mysqli_fetch_assoc($clientResult1)) {
$selected = ($clientRow1['client_name'] == $row['consignor']) ? 'selected' : '';
echo "<option value='" . $clientRow1['client_name'] . "' $selected>" . $clientRow1['client_name'] . "</option>";
}
?>
</select>
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Origin</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="origin" id="origin" class="form-control" placeholder="Origin">
</div>
</div>
</div>
<input type="hidden" name="consignor_state" value="Uttar Pradesh">
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Origin Address</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="origin_address" id="origin_address" class="form-control" placeholder="Origin Address">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Origin GST No</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="origin_gst" id="origin_gst" class="form-control" placeholder="Origin GST No.">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Origin Phone</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="origin_phone" id="origin_phone" class="form-control" placeholder="Origin Phone.">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Origin E-way Bill No.</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="origin_eway" id="origin_eway" class="form-control" placeholder="Origin E-way Bill No..">
</div>
</div>
</div>
<!-- Consignee -->
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Consignee</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<select name="consignee" id="consignee" class="form-control">
<option value="">Select Consignee</option>
<?php
// Reuse same $clientQuery if needed
$clientQuery2 = "SELECT client_name FROM clients";
$clientResult2 = mysqli_query($conn, $clientQuery2);
while ($clientRow2 = mysqli_fetch_assoc($clientResult2)) {
$selected = ($clientRow2['client_name'] == $row['consignee']) ? 'selected' : '';
echo "<option value='" . $clientRow2['client_name'] . "' $selected>" . $clientRow2['client_name'] . "</option>";
}
?>
</select>
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Destination</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="destination" id="destination" class="form-control" placeholder="Destination">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Destination Address</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="destination_address" id="destination_address" class="form-control" placeholder="Destination Address">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Destination GSTIN</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="destination_gst" id="destination_gst" class="form-control" placeholder="Destination GSTIN">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Destination Phone</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="destination_phone" id="destination_phone" class="form-control" placeholder="Destination Phone">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Destination E-way Bill No.</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="destination_eway" id="destination_eway" class="form-control" placeholder="Destination E-way Bill No.">
</div>
</div>
</div>
<input type="hidden" name="invoice_no" value="<?php echo $row['invoice_no']; ?>" id="invoice_no">
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">G.R. No</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="grno" class="form-control" value="<?php echo $row['grno']; ?>" id="grno" placeholder="G.R. No" readonly>
<!-- <input type="text" name="grno" class="form-control" placeholder="G.R. No"> -->
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">QACL</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="qacl" value="<?php echo $row['qacl']; ?>" class="form-control" placeholder="QACL">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Transport Method</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<select name="transport_by" id="transport_by" class="form-control">
<option value="">Select Transport Method</option>
<option value="By Train" <?php echo ($row['transport_by'] == 'By Train') ? 'selected' : '' ?>>By Train</option>
<option value="By Air" <?php echo ($row['transport_by'] == 'By Air') ? 'selected' : '' ?>>By Air</option>
<option value="By Surface" <?php echo ($row['transport_by'] == 'By Surface') ? 'selected' : '' ?>>By Surface</option>
<option value="By Express" <?php echo ($row['transport_by'] == 'By Express') ? 'selected' : '' ?>>By Express</option>
</select>
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Booking Date</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="booking_date" value="<?php echo $row['booking_date']; ?>" id="bookingDate" class="form-control" placeholder="Booking Date">
<!-- <input type="date" name="booking_date" class="form-control" placeholder="Booking Date"> -->
</div>
</div>
</div>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">
<script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>
<script>
flatpickr("#bookingDate", {
dateFormat: "d-m-Y", // DD-MM-YYYY format
allowInput: true
});
</script>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Booking Time</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="time" name="booking_time" value="<?php echo $row['booking_time']; ?>" class="form-control" placeholder="Booking Time">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">No. Of Package</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="pkg_total" value="<?php echo $row['pkg_total']; ?>" class="form-control" placeholder="No. Of Package">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Type Of Packing</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="pkg_type" value="<?php echo $row['pkg_type']; ?>" class="form-control" placeholder="Type Of Packing">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Party Name</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="party_name" value="<?php echo $row['party_name']; ?>" class="form-control" placeholder="Party Name">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Party Invoice No</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="party_invoice" value="<?php echo $row['party_invoice']; ?>" class="form-control" placeholder="Party Invoice No">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Select State</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<select name="state" class="form-control" required>
<option value="">Select State</option>
<option value="Andhra Pradesh" <?php echo ($row['state'] == 'Andhra Pradesh') ? 'selected' : '' ?>>Andhra Pradesh</option>
<option value="Arunachal Pradesh" <?php echo ($row['state'] == 'Arunachal Pradesh') ? 'selected' : '' ?>>Arunachal Pradesh</option>
<option value="Assam" <?php echo ($row['state'] == 'Assam') ? 'selected' : '' ?>>Assam</option>
<option value="Bihar" <?php echo ($row['state'] == 'Bihar') ? 'selected' : '' ?>>Bihar</option>
<option value="Chhattisgarh" <?php echo ($row['state'] == 'Chhattisgarh') ? 'selected' : '' ?>>Chhattisgarh</option>
<option value="Goa" <?php echo ($row['state'] == 'Goa') ? 'selected' : '' ?>>Goa</option>
<option value="Gujarat" <?php echo ($row['state'] == 'Gujarat') ? 'selected' : '' ?>>Gujarat</option>
<option value="Haryana" <?php echo ($row['state'] == 'Haryana') ? 'selected' : '' ?>>Haryana</option>
<option value="Himachal Pradesh" <?php echo ($row['state'] == 'Himachal Pradesh') ? 'selected' : '' ?>>Himachal Pradesh</option>
<option value="Jharkhand" <?php echo ($row['state'] == 'Jharkhand') ? 'selected' : '' ?>>Jharkhand</option>
<option value="Karnataka" <?php echo ($row['state'] == 'Karnataka') ? 'selected' : '' ?>>Karnataka</option>
<option value="Kerala" <?php echo ($row['state'] == 'Kerala') ? 'selected' : '' ?>>Kerala</option>
<option value="Madhya Pradesh" <?php echo ($row['state'] == 'Madhya Pradesh') ? 'selected' : '' ?>>Madhya Pradesh</option>
<option value="Maharashtra" <?php echo ($row['state'] == 'Maharashtra') ? 'selected' : '' ?>>Maharashtra</option>
<option value="Manipur" <?php echo ($row['state'] == 'Manipur') ? 'selected' : '' ?>>Manipur</option>
<option value="Meghalaya" <?php echo ($row['state'] == 'Meghalaya') ? 'selected' : '' ?>>Meghalaya</option>
<option value="Mizoram" <?php echo ($row['state'] == 'Mizoram') ? 'selected' : '' ?>>Mizoram</option>
<option value="Nagaland" <?php echo ($row['state'] == 'Nagaland') ? 'selected' : '' ?>>Nagaland</option>
<option value="Odisha" <?php echo ($row['state'] == 'Odisha') ? 'selected' : '' ?>>Odisha</option>
<option value="Punjab" <?php echo ($row['state'] == 'Punjab') ? 'selected' : '' ?>>Punjab</option>
<option value="Rajasthan" <?php echo ($row['state'] == 'Rajasthan') ? 'selected' : '' ?>>Rajasthan</option>
<option value="Sikkim" <?php echo ($row['state'] == 'Sikkim') ? 'selected' : '' ?>>Sikkim</option>
<option value="Tamil Nadu" <?php echo ($row['state'] == 'Tamil Nadu') ? 'selected' : '' ?>>Tamil Nadu</option>
<option value="Telangana" <?php echo ($row['state'] == 'Telangana') ? 'selected' : '' ?>>Telangana</option>
<option value="Tripura" <?php echo ($row['state'] == 'Tripura') ? 'selected' : '' ?>>Tripura</option>
<option value="Uttar Pradesh" <?php echo ($row['state'] == 'Uttar Pradesh') ? 'selected' : '' ?>>Uttar Pradesh</option>
<option value="Uttarakhand" <?php echo ($row['state'] == 'Uttarakhand') ? 'selected' : '' ?>>Uttarakhand</option>
<option value="West Bengal" <?php echo ($row['state'] == 'West Bengal') ? 'selected' : '' ?>>West Bengal</option>
<option value="Andaman and Nicobar Islands" <?php echo ($row['state'] == 'Andaman and Nicobar Islands') ? 'selected' : '' ?>>Andaman and Nicobar Islands</option>
<option value="Chandigarh" <?php echo ($row['state'] == 'Chandigarh') ? 'selected' : '' ?>>Chandigarh</option>
<option value="Dadra and Nagar Haveli and Daman and Diu" <?php echo ($row['state'] == 'Dadra and Nagar Haveli and Daman and Diu') ? 'selected' : '' ?>>Dadra and Nagar Haveli and Daman and Diu</option>
<option value="Delhi" <?php echo ($row['state'] == 'Delhi') ? 'selected' : '' ?>>Delhi</option>
<option value="Jammu and Kashmir" <?php echo ($row['state'] == 'Jammu and Kashmir') ? 'selected' : '' ?>>Jammu and Kashmir</option>
<option value="Ladakh" <?php echo ($row['state'] == 'Ladakh') ? 'selected' : '' ?>>Ladakh</option>
<option value="Lakshadweep" <?php echo ($row['state'] == 'Lakshadweep') ? 'selected' : '' ?>>Lakshadweep</option>
<option value="Puducherry" <?php echo ($row['state'] == 'Puducherry') ? 'selected' : '' ?>>Puducherry</option>
</select>
</div>
</div>
</div>
<div class="container">
<h3 class="text-center">Dynamic Dimension Calculator</h3>
<form id="dimensionForm">
<div id="dimensionContainer">
<!-- First row for Dimensions -->
<?php
$dimensionCount = count($lengths);
for ($i = 0; $i < $dimensionCount; $i++):
?>
<div class="row dimension-row">
<div class="col-sm-2 form-group">
<label>Length (L)</label>
<input type="number" name="length[]" value="<?php echo $lengths[$i]; ?>" class="form-control length">
</div>
<div class="col-sm-2 form-group">
<label>Width (W)</label>
<input type="number" name="width[]" value="<?php echo $widths[$i]; ?>" class="form-control width">
</div>
<div class="col-sm-2 form-group">
<label>Height (H)</label>
<input type="number" name="height[]" value="<?php echo $heights[$i]; ?>" class="form-control height">
</div>
<div class="col-sm-2 form-group">
<label>Charge Weight</label>
<input type="number" name="charge_weight[]" value="<?php echo $charge_weights[$i]; ?>" class="form-control charge-weight">
</div>
<div class="col-sm-1 form-group">
<label>Qty</label>
<input type="number" name="demention_quantity[]" value="<?php echo $quantities[$i]; ?>" class="form-control quantity">
</div>
<div class="col-sm-2 form-group">
<label>Volume</label>
<input type="number" name="volume[]" value="<?php echo $volumes[$i]; ?>" class="form-control volume" readonly>
</div>
<div class="col-sm-2 form-group">
<label>Weight</label>
<input type="number" name="total_weight[]" value="<?php echo $amounts[$i]; ?>" class="form-control amount" readonly>
</div>
<div class="col-sm-1">
<button type="button" class="btn btn-danger remove-btn" style="<?php echo $i === 0 ? 'display:none;' : ''; ?>">✖</button>
</div>
</div>
<?php endfor; ?>
</div>
<button type="button" class="btn btn-primary add-btn">+ Add More</button>
<hr>
<!-- New Box Section -->
<h4>Box Weight Section</h4>
<div id="boxContainer">
<?php
$boxCount = count($box_weights);
for ($j = 0; $j < $boxCount; $j++):
?>
<div class="row box-row">
<div class="col-sm-3 form-group">
<label>Box Weight (kg)</label>
<input type="number" name="box_weight[]" value="<?php echo $box_weights[$j]; ?>" class="form-control box-weight">
</div>
<div class="col-sm-3 form-group">
<label>Box Quantity</label>
<input type="number" name="box_quantity[]" value="<?php echo $box_quantities[$j]; ?>" class="form-control box-quantity">
</div>
<div class="col-sm-3 form-group">
<label>Total Box Weight</label>
<input type="number" name="total_box_weight[]" value="<?php echo $box_total_weights[$j]; ?>" class="form-control box-total-weight" readonly>
</div>
<div class="col-sm-1">
<button type="button" class="btn btn-danger remove-box-btn" style="<?php echo $j === 0 ? 'display:none;' : ''; ?>">✖</button>
</div>
</div>
<?php endfor; ?>
</div>
<button type="button" class="btn btn-secondary add-box-btn">+ Add Box</button>
<hr>
<div class="total-container mb-4">
<label><strong>Total Charged Weight:</strong></label>
<input type="number" name="total_charged_weight" value="<?php echo $row['total_charged_weight'] ?>" id="finalTotal" class="form-control" readonly>
</div>
</form>
</div>
<style>
.dimension-row, .box-row { display: flex; flex-wrap: wrap; align-items: center; gap: 10px; margin-bottom: 10px; }
.dimension-row .form-group, .box-row .form-group { width: 150px; text-align: center; margin-bottom: 0; }
.remove-btn, .remove-box-btn { margin-top: 25px; }
.total-container { margin-top: 20px; }
.quantity{
width: 90px;
}
@media (max-width: 768px) {
.dimension-row, .box-row { flex-direction: column; align-items: flex-start; }
.dimension-row .form-group, .box-row .form-group { width: 100%; }
.quantity {
width: 338px;
}
}
</style>
<!-- <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> -->
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Said to Content</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="saidtocontent" value="<?php echo $row['saidtocontent']; ?>" class="form-control" placeholder="Said to Content">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Quantity</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="quantity" value="<?php echo $row['quantity']; ?>" class="form-control" placeholder="Quantity">
</div>
</div>
</div>
<table class="table table-bordered">
<tr>
<th>Particulars</th>
<th>Rate (Kg)</th>
<th>Amount</th>
</tr>
<tr>
<td>Freight</td>
<td><input type="text" class="form-control rate" name="freight_rate" value="<?php echo $row['freight_rate']; ?>" data-target="freight_amount" placeholder="Rate (Kg)"></td>
<td>
<input type="number" class="form-control amount" id="freight_amount_display" value="<?php echo $row['freight_amount']; ?>" placeholder="Amount" readonly>
<input type="hidden" name="freight_amount" id="freight_amount">
</td>
</tr>
<tr>
<td>C.O.D</td>
<td><input type="text" class="form-control rate" name="cod_rate" value="<?php echo $row['cod_rate']; ?>" data-target="cod_amount" placeholder="Rate (Kg)"></td>
<td>
<input type="number" class="form-control amount" id="cod_amount_display" value="<?php echo $row['cod_amount']; ?>" placeholder="Amount" readonly>
<input type="hidden" name="cod_amount" id="cod_amount">
</td>
</tr>
<tr>
<td>F.O.V</td>
<td><input type="text" class="form-control rate" name="fov_rate" value="<?php echo $row['fov_rate']; ?>" data-target="fov_amount" placeholder="Rate (Kg)"></td>
<td>
<input type="number" class="form-control amount" id="fov_amount_display" value="<?php echo $row['fov_amount']; ?>" placeholder="Amount" readonly>
<input type="hidden" name="fov_amount" id="fov_amount">
</td>
</tr>
<tr>
<td>Doc Charges</td>
<td>
<!-- You can leave the rate blank or remove it entirely if unused -->
<input type="text" class="form-control" name="doc_rate" placeholder="N/A" disabled>
</td>
<td>
<input type="number" class="form-control amount" value="<?php echo $row['doc_amount'] ?>" id="doc_amount_display" placeholder="Amount">
<input type="hidden" name="doc_amount" value="<?php echo $row['doc_amount'] ?>" id="doc_amount">
</td>
</tr>
<tr>
<td>Cartage</td>
<td><input type="text" class="form-control rate" name="cartage_rate" value="<?php echo $row['cartage_rate'] ?>" data-target="cartage_amount" placeholder="Rate (Kg)"></td>
<td>
<input type="number" class="form-control amount" id="cartage_amount_display" value="<?php echo $row['cartage_amount'] ?>" placeholder="Amount" readonly>
<input type="hidden" name="cartage_amount" id="cartage_amount">
</td>
</tr>
<tr>
<td>Labour Handling</td>
<td><input type="text" class="form-control rate" name="labour_rate" value="<?php echo $row['labour_rate'] ?>" data-target="labour_amount" placeholder="Rate (Kg)"></td>
<td>
<input type="number" class="form-control amount" id="labour_amount_display" value="<?php echo $row['labour_amount'] ?>" placeholder="Amount" readonly>
<input type="hidden" name="labour_amount" id="labour_amount">
</td>
</tr>
<tr>
<td>IGST @</td>
<td>
<input type="text" class="form-control rate" name="gst_rate" id="gst_rate" data-target="gst_amount" placeholder="Rate (%)" readonly>
</td>
<td>
<input type="number" class="form-control amount" id="gst_amount_display" placeholder="Amount" readonly>
<input type="hidden" name="gst_amount" id="gst_amount">
</td>
</tr>
<tr>
<td>SGST @</td>
<td>
<input type="text" class="form-control rate" name="sgst_rate" id="sgst_rate" data-target="sgst_amount" placeholder="Rate (%)" readonly>
</td>
<td>
<input type="number" class="form-control amount" id="sgst_amount_display" placeholder="Amount" readonly>
<input type="hidden" name="sgst_amount" id="sgst_amount">
</td>
</tr>
<tr>
<td>CGST @</td>
<td>
<input type="text" class="form-control rate" name="cgst_rate" id="cgst_rate" data-target="cgst_amount" placeholder="Rate (%)" readonly>
</td>
<td>
<input type="number" class="form-control amount" id="cgst_amount_display" placeholder="Amount" readonly>
<input type="hidden" name="cgst_amount" id="cgst_amount">
</td>
</tr>
<tr>
<td>Any Other Charges</td>
<td><input type="text" class="form-control" name="other_rate" value="<?php echo $row['other_rate'] ?>" placeholder="Rate (Manual)"></td>
<td>
<input type="number" class="form-control amount" id="other_amount_display" value="<?php echo $row['other_amount'] ?>" placeholder="Amount (Manual)" oninput="calculateTotal()">
<input type="hidden" name="other_amount" value="<?php echo $row['other_amount'] ?>" id="other_amount">
</td>
</tr>
<tr>
<td><strong>Total</strong></td>
<td colspan="2">
<input type="number" class="form-control" id="total_amount_display" value="<?php echo $row['total_amount'] ?>" placeholder="Total" readonly>
<input type="hidden" name="total_amount" value="<?php echo $row['total_amount'] ?>" id="total_amount">
</td>
</tr>
</table>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Delivery Detail</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="delivery_detail" value="<?php echo $row['delivery_detail']; ?>" class="form-control" placeholder="Delivery Detail">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Delivery Date</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="delivery_date" value="<?php echo $row['delivery_date']; ?>" class="form-control" placeholder="Delivery Date">
</div>
</div>
</div>
<?php
$ttb_origin = isset($row['ttb_origin']) ? $row['ttb_origin'] : ''; // e.g., "TTB Origin" or "To Pay"
?>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">TBB at Origin / To Pay</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<select name="ttb_origin" class="form-control">
<option value="TTB Origin" <?php echo ($ttb_origin == 'TTB Origin') ? 'selected' : '' ?>>TBB at Origin</option>
<option value="To Pay" <?php echo ($ttb_origin == 'To Pay') ? 'selected' : '' ?>>To Pay</option>
</select>
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Paid</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="paid" value="<?php echo $row['paid']; ?>" class="form-control" placeholder="paid">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Amount</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="text" name="amount" class="form-control" value="<?php echo $row['amount']; ?>" placeholder="Amount">
</div>
</div>
</div>
<div class="col-12 col-sm-2 text-sm-right align-self-center">
<label class="redial-font-weight-600 mb-3">Attachment</label>
</div>
<div class="col-12 col-sm-10">
<div class="row">
<div class="col-12 col-sm-12 mb-3">
<input type="file" name="attachment" accept=".jpg,.jpeg,.png,.gif,.pdf">
<input type="hidden" name="attachment_old" value="<?php echo $row['attachment']; ?>">
</div>
<div class="col-12 col-sm-2">
<?php
$file = "sublier/" . $row['attachment'];
$extension = strtolower(pathinfo($file, PATHINFO_EXTENSION));
if (in_array($extension, ['jpg', 'jpeg', 'png', 'gif'])) {
echo '<img src="' . $file . '" width="60px"/>';
} elseif ($extension == 'pdf') {
echo '<a href="' . $file . '" target="_blank"><img src="pdf-icon.png" width="40px"> View PDF</a>';
} else {
echo 'No valid file';
}
?>
</div>
</div>
</div>
<input type="hidden" name="status" value="<?php echo $row['status']; ?>">
<?php
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
die("Unauthorized access. Please log in.");
}
$query = "SELECT id FROM employees WHERE id = '$se'";
$result = mysqli_query($conn, $query);
$emp_id = "";
if ($result && mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$emp_id = $row['id'];
}
?>
<input type="hidden" name="emp_id" value="<?php echo htmlspecialchars($emp_id); ?>">
<div class="btn-group mb-2" style="margin-left: 39%;">
<button type="submit" name="update_builty" class="btn btn-outline-success">Update</button>
</div>
</div>
</form>
<?php }} ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- End main-content-->
<!-- Top To Bottom-->
<a href="#" class="scrollup text-center redial-bg-primary redial-rounded-circle-50">
<h4 class="text-white mb-0"><i class="icofont icofont-long-arrow-up"></i></h4>
</a>
<!-- End Top To Bottom-->
<!-- jQuery -->
<style>
table {
width: 100%;
border-collapse: collapse;
}
th, td {
border: 1px solid #ddd;
padding: 8px;
text-align: left;
}
th {
background-color: #f4f4f4;
}
input {
width: 100%;
padding: 6px;
box-sizing: border-box;
}
</style>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<!-- Client Change Start -->
<script>
function loadConsignorDetails() {
var consignor = $('#consignor').val();
if (consignor) {
$.ajax({
url: 'fetch_client_details1.php',
method: 'POST',
data: { consignor: consignor },
success: function (response) {
try {
var data = JSON.parse(response);
if (data) {
$('#origin').val(data.destination || '');
$('#origin_address').val(data.client_address || '');
$('#origin_gst').val(data.client_gst || '');
$('#origin_phone').val(data.phone || '');
$('#origin_eway').val(data.client_eway || '');
}
} catch (e) {
console.error("Invalid JSON from consignor:", response);
}
}
});
}
}
function loadConsigneeDetails() {
var consignee = $('#consignee').val();
if (consignee) {
$.ajax({
url: 'fetch_client_details.php',
method: 'POST',
data: { consignee: consignee },
success: function (response) {
try {
var data = JSON.parse(response);
if (data) {
$('#destination').val(data.destination || '');
$('#destination_address').val(data.client_address || '');
$('#destination_gst').val(data.client_gst || '');
$('#destination_phone').val(data.phone || '');
$('#destination_eway').val(data.client_eway || '');
}
} catch (e) {
console.error("Invalid JSON from consignee:", response);
}
}
});
}
}
$(document).ready(function () {
loadConsignorDetails();
loadConsigneeDetails();
});
$('#consignor').on('change', loadConsignorDetails);
$('#consignee').on('change', loadConsigneeDetails);
</script>
<!-- Client Change end -->
<!-- transport By start -->
<script>
$(document).ready(function () {
const gstRates = {
"By Train": 5,
"By Air": 18,
"By Express": 0,
"By Surface": 0
};
// Amount variables
let freight_amount = 0;
let cod_amount = 0;
let fov_amount = 0;
let cartage_amount = 0;
let labour_amount = 0;
let other_amount = parseFloat($("#other_amount").val()) || 0;
let selectedState = $('select[name="state"]').val();
// --- INIT: Recalculate all amounts on page load ---
function initializeAmounts() {
const totalWeight = parseFloat($("#finalTotal").val()) || 0;
$(".rate").each(function () {
const rate = parseFloat($(this).val()) || 0;
const targetId = $(this).data("target");
const amount = rate * totalWeight;
switch (targetId) {
case "freight_amount": freight_amount = amount; break;
case "cod_amount": cod_amount = amount; break;
case "fov_amount": fov_amount = amount; break;
case "cartage_amount": cartage_amount = amount; break;
case "labour_amount": labour_amount = amount; break;
}
$("#" + targetId).val(amount.toFixed(0));
$("#" + targetId + "_display").val(amount.toFixed(0));
});
// Other + document
const docVal = $("#doc_amount_display").val();
const doc = !isNaN(docVal) && docVal !== "" ? parseFloat(docVal) : 0;
$("#doc_amount").val(doc.toFixed(0));
}
$('#transport_by').on('change', function () {
updateGSTFields();
});
$('select[name="state"]').on('change', function () {
selectedState = $(this).val();
updateGSTFields();
});
function updateGSTFields() {
const transportMode = $('#transport_by').val();
const gstRate = gstRates[transportMode] || 0;
const subtotal = calculateSubtotal();
if (!selectedState || selectedState === "") {
$('#gst_rate, #gst_amount, #gst_amount_display').val('');
$('#sgst_rate, #cgst_rate, #sgst_amount, #cgst_amount').val('');
$('#sgst_amount_display, #cgst_amount_display').val('');
return;
}
if (selectedState === "Uttar Pradesh") {
const halfGst = gstRate / 2;
$('#gst_rate, #gst_amount, #gst_amount_display').val('');
$('#sgst_rate').val(halfGst);
$('#cgst_rate').val(halfGst);
const halfGstAmount = (subtotal * halfGst) / 100;
$('#sgst_amount, #sgst_amount_display').val(halfGstAmount.toFixed(0));
$('#cgst_amount, #cgst_amount_display').val(halfGstAmount.toFixed(0));
} else {
$('#sgst_rate, #cgst_rate, #sgst_amount, #cgst_amount').val('');
$('#sgst_amount_display, #cgst_amount_display').val('');
$('#gst_rate').val(gstRate);
const gstAmount = (subtotal * gstRate) / 100;
$('#gst_amount, #gst_amount_display').val(gstAmount.toFixed(0));
}
calculateTotal();
}
function calculateSubtotal() {
let subtotal = 0;
subtotal += parseFloat(freight_amount) || 0;
subtotal += parseFloat(cod_amount) || 0;
subtotal += parseFloat(fov_amount) || 0;
subtotal += parseFloat(cartage_amount) || 0;
subtotal += parseFloat(labour_amount) || 0;
subtotal += parseFloat(other_amount) || 0;
const docVal = $("#doc_amount_display").val();
const doc = !isNaN(docVal) && docVal !== "" ? parseFloat(docVal) : 0;
$("#doc_amount").val(doc.toFixed(0));
subtotal += doc;
return subtotal;
}
$(document).on("input", ".rate", function () {
const rate = parseFloat($(this).val()) || 0;
const targetId = $(this).data("target");
const totalWeight = parseFloat($("#finalTotal").val()) || 0;
const amount = rate * totalWeight;
switch (targetId) {
case "freight_amount": freight_amount = amount; break;
case "cod_amount": cod_amount = amount; break;
case "fov_amount": fov_amount = amount; break;
case "cartage_amount": cartage_amount = amount; break;
case "labour_amount": labour_amount = amount; break;
}
$("#" + targetId).val(amount.toFixed(0));
$("#" + targetId + "_display").val(amount.toFixed(0));
updateGSTFields();
calculateTotal();
});
$(document).on("input", "#other_amount_display", function () {
other_amount = parseFloat($(this).val()) || 0;
$('#other_amount').val(other_amount.toFixed(0));
calculateTotal();
});
$(document).on("change", "#doc_amount_display", function () {
const docVal = $(this).val();
const doc = !isNaN(docVal) && docVal !== "" ? parseFloat(docVal) : 0;
$("#doc_amount").val(doc.toFixed(0));
updateGSTFields();
calculateTotal();
});
function calculateTotal() {
let total = calculateSubtotal();
const gst = parseFloat($('#gst_amount').val()) || 0;
const sgst = parseFloat($('#sgst_amount').val()) || 0;
const cgst = parseFloat($('#cgst_amount').val()) || 0;
total += gst + sgst + cgst;
$("#total_amount_display").val(total.toFixed(0));
$("#total_amount").val(total.toFixed(0));
}
// ✅ INITIALIZE EVERYTHING ON PAGE LOAD
initializeAmounts();
updateGSTFields();
calculateTotal();
});
let lastWeight = $("#finalTotal").val();
setInterval(function () {
const currentWeight = $("#finalTotal").val();
if (currentWeight !== lastWeight) {
lastWeight = currentWeight;
recalculateAmountsFromWeight(); // 👈 call your function when value changes
}
}, 300); // check every 300ms
function recalculateAmountsFromWeight() {
const totalWeight = parseFloat($("#finalTotal").val()) || 0;
$(".rate").each(function () {
const rate = parseFloat($(this).val()) || 0;
const targetId = $(this).data("target");
const amount = rate * totalWeight;
switch (targetId) {
case "freight_amount": freight_amount = amount; break;
case "cod_amount": cod_amount = amount; break;
case "fov_amount": fov_amount = amount; break;
case "cartage_amount": cartage_amount = amount; break;
case "labour_amount": labour_amount = amount; break;
}
$("#" + targetId).val(amount.toFixed(0));
$("#" + targetId + "_display").val(amount.toFixed(0));
});
updateGSTFields();
calculateTotal();
}
</script>
<!-- Transport By End -->
<!-- B0x Detail Start -->
<script>
$(document).ready(function () {
function calculateWeight(row) {
let length = parseFloat(row.find(".length").val()) || 0;
let width = parseFloat(row.find(".width").val()) || 0;
let height = parseFloat(row.find(".height").val()) || 0;
let chargeWeight = parseFloat(row.find(".charge-weight").val()) || 1;
let quantity = parseFloat(row.find(".quantity").val()) || 0;
let volume = length * width * height;
row.find(".volume").val(volume.toFixed(2));
let weight = (volume / chargeWeight) * quantity;
row.find(".amount").val(weight.toFixed(2));
calculateTotalWeight();
calculateTotalQuantity();
}
function calculateBoxWeight(row) {
let boxWeight = parseFloat(row.find(".box-weight").val()) || 0;
let boxQuantity = parseFloat(row.find(".box-quantity").val()) || 0;
let totalBoxWeight = boxWeight * boxQuantity;
row.find(".box-total-weight").val(totalBoxWeight.toFixed(2));
calculateTotalWeight();
calculateTotalQuantity();
}
// function calculateTotalWeight() {
// let totalWeight = 0;
// $(".amount").each(function () {
// totalWeight += parseFloat($(this).val()) || 0;
// });
// $(".box-total-weight").each(function () {
// totalWeight += parseFloat($(this).val()) || 0;
// });
// $("#finalTotal").val(totalWeight.toFixed(0));
// }
function calculateTotalWeight() {
let totalWeight = 0;
// Sum all dynamic dimension weights
$(".dimension-row").each(function () {
totalWeight += parseFloat($(this).find(".amount").val()) || 0;
});
// Sum all box weights
$(".box-row").each(function () {
totalWeight += parseFloat($(this).find(".box-total-weight").val()) || 0;
});
// Update the total weight field (override old DB value)
$("#finalTotal").val(totalWeight.toFixed(2));
}
function calculateTotalQuantity() {
let totalQty = 0;
$(".quantity").each(function () {
totalQty += parseInt($(this).val()) || 0;
});
$(".box-quantity").each(function () {
totalQty += parseInt($(this).val()) || 0;
});
$("input[name='quantity']").val(totalQty);
}
$(document).on("input", ".length, .width, .height, .charge-weight, .quantity", function () {
let row = $(this).closest(".dimension-row");
calculateWeight(row);
});
$(document).on("input", ".box-weight, .box-quantity", function () {
let row = $(this).closest(".box-row");
calculateBoxWeight(row);
});
$(".add-btn").click(function () {
let newRow = $(".dimension-row:first").clone();
newRow.find("input").val("");
newRow.find(".volume, .amount").val("0");
newRow.find(".remove-btn").show();
$("#dimensionContainer").append(newRow);
calculateTotalQuantity();
});
$(".add-box-btn").click(function () {
let newBoxRow = $(".box-row:first").clone();
newBoxRow.find("input").val("");
newBoxRow.find(".box-total-weight").val("0");
newBoxRow.find(".remove-box-btn").show();
$("#boxContainer").append(newBoxRow);
calculateTotalQuantity();
});
$(document).on("click", ".remove-btn", function () {
$(this).closest(".dimension-row").remove();
calculateTotalWeight();
calculateTotalQuantity();
});
$(document).on("click", ".remove-box-btn", function () {
$(this).closest(".box-row").remove();
calculateTotalWeight();
calculateTotalQuantity();
});
});
</script>
<!-- Box Detail End -->
<script src="dist/js/plugins.min.js"></script>
<script src="dist/js/common.js"></script>
</body>
</html>