﻿﻿??????????????
﻿﻿??????????????
<?php
   include('session.php');
?>

<?php

include 'connection.php';

if(isset($_GET['idk']))
{
     $delsql = "DELETE FROM registration WHERE id=".$_GET['idk'];
     $conn->query($delsql);
      exit;
}

?>

<?php
 
// Username is root
$user = 'anilpzp6_account';
$password = 'Anil@321#$'; 
  
// Database name is gfg
$database = 'anilpzp6_account'; 
  
// Server is localhost with
// port number 3308
$servername='localhost';
$mysqli = new mysqli($servername, $user, 
                $password, $database);
  
// Checking for connections
if ($mysqli->connect_error) {
    die('Connect Error (' . 
    $mysqli->connect_errno . ') '. 
    $mysqli->connect_error);
}

$user = $_SESSION['user_name'];
  
// SQL query to select data from database
$sql = "SELECT * FROM users where gstin = '$user' LIMIT 1";
$result = $mysqli->query($sql);
// $mysqli->close(); 
//$a=0;
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Consignment | Xcel Training Institute</title>
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" href="../images/logo-wide.png">
    <!-- Base Styling  -->
    <link rel="stylesheet" href="assets/main/css/fonts.css">
    <link rel="stylesheet" href="assets/main/css/style.css">
    <script src="https://code.jquery.com/jquery-3.6.4.min.js" integrity="sha256-oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl+cbzUq8=" crossorigin="anonymous"></script>
    <style>
    .btn{
            background-color: red;
            border: none;
            color: white;
            padding: 5px 5px;
            text-align: center;
            text-decoration: none;
            display: inline-block;
            font-size: 20px;
            margin: 4px 2px;
            cursor: pointer;
            border-radius: 20px;
        }
        .green{
            background-color: #199319;
        }
        .red{
            background-color: red;
        }
        </style>
</head>

<body>
    <div id="main-wrapper" class="show">


      <?php
         include "sidebar.php";
         ?>


         <?php
         include "header.php";
         ?>


          <div class="content-body">
            <div class="warper container-fluid">
                <div class="new-patients main_container">
                   
       <div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="card-title">Consignment</h4>
                                </div>
                                <div class="card-body">
                                    <div class="basic-form">
                                        <form action="insert-invoice.php" method="post" enctype="multipart/form-data">

                                            <div class="row">
                                                <div class="">
                                    <h4 class="">Office Details</h4>
                                </div>
                                                <?php   // LOOP TILL END OF DATA 
                while($rows=$result->fetch_assoc())
                { 
             ?>
                                                                      
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">GSTIN No.</label>
                                                        <input type="text" class="form-control" placeholder="GSTIN No." name="gstin" value="<?php echo $rows['gstin'];?>">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Booking Office</label>
                                                        <input type="text" class="form-control" placeholder="Booking Office" name="office" value="<?php echo $rows['office'];?>">
                                                    </div>
                                                </div>
                                                
                                                
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Office Address</label>
                                                        <input type="text" class="form-control" placeholder="Office Address" name="address" value="<?php echo $rows['address'];?>">
                                                    </div>
                                                </div>
                                                
                                                <?php }?>
                                                
                                                <div class="">
                                    <h4 class="">Consignment Details</h4>
                                </div>

                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Consignment Note No</label>
                                                        <input type="text" class="form-control" placeholder="Consignment Note No" name="consno">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Date <strong>(Use Format DD/MM/YYYY)</strong></label>
                                                        <input type="text" class="form-control" placeholder="Date" name="edate">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Origin</label>
                                                        <input type="text" class="form-control" placeholder="Origin" name="origin">
                                                    </div>
                                                </div>

                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Destination</label>
                                                        <input type="text" class="form-control" placeholder="Destination" name="destination">
                                                    </div>
                                                </div>
                                                
                                                
                                                <div class="">
                                    <h4 class="">Full Description of Contents</h4>
                                </div>

                                                <div class="col-xl-12">
                                                    <div class="form-group">
                                                        <label class="form-label">Description</label>
                                                        <input type="text" class="form-control" placeholder="Description" name="description">
                                                    </div>
                                                </div>
                                                
                                                <div class="">
                                    <h4 class="">Shipment Details</h4>
                                </div>

                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">No. of Package</label>
                                                        <input type="text" class="form-control" placeholder="Customer Name" name="custname">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Total Weight</label>
                                                        <input type="text" class="form-control" placeholder="Customer Address" name="custadd">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Type of Load</label>
                                                        <input type="text" class="form-control" placeholder="Customer GSTIN No" name="custgst">
                                                    </div>
                                                </div>
                                                
                                                <div class="">
                                    <h4 class="">Shipment Insurance Details</h4>
                                </div>

                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Value </label>
                                                        <input type="text" class="form-control" placeholder="Value" name="custname">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">All Owners Risk</label>
                                                        <input type="text" class="form-control" placeholder="All Owners Risk" name="custadd">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">All Carriers Risk</label>
                                                        <input type="text" class="form-control" placeholder="All Carriers Risk" name="custgst">
                                                    </div>
                                                </div>
                                                
                                                
                                                 <div class="">
                                    <h4 class="">Consignor Details</h4>
                                </div>

                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Consignor Name</label>
                                                        <input type="text" class="form-control" placeholder="Consignor Name" name="custname">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Consignor Address</label>
                                                        <input type="text" class="form-control" placeholder="Consignor Address" name="custadd">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Consignor Pin / Zip Code </label>
                                                        <input type="text" class="form-control" placeholder="Consignor Pin / Zip Code" name="custgst">
                                                    </div>
                                                </div>
                                                
                                                
                                                <div class="">
                                    <h4 class="">Consignee  Details</h4>
                                </div>

                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Consignee  Name</label>
                                                        <input type="text" class="form-control" placeholder="Consignee  Name" name="custname">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Consignor Address</label>
                                                        <input type="text" class="form-control" placeholder="Consignee  Address" name="custadd">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Consignor Pin / Zip Code </label>
                                                        <input type="text" class="form-control" placeholder="Consignee  Pin / Zip Code" name="custgst">
                                                    </div>
                                                </div>
                                                
                                                
                                                <div class="">
                                    <h4 class="">Payment  Details</h4>
                                </div>

                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Paid MR No. </label>
                                                        <input type="text" class="form-control" placeholder="Paid MR No. " name="custname">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">TBB Bill No. </label>
                                                        <input type="text" class="form-control" placeholder="TBB Bill No. " name="custadd">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">To Pay  </label>
                                                        <input type="text" class="form-control" placeholder="To Pay " name="custgst">
                                                    </div>
                                                </div>
                                                
                                                
                                            
                                            <div class="">
                                    <h4 class="">Amount Details</h4>
                                </div>

                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Freight Charges</label>
                                                        <input type="number" class="form-control" placeholder="Freight Charges" name="convcharge">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Fuel Surcharges</label>
                                                        <input type="number" class="form-control" placeholder="Fuel Surcharges" name="igst">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">DC Charge</label>
                                                        <input type="number" class="form-control" placeholder="DC Charge" name="cgst">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">DD Charge</label>
                                                        <input type="number" class="form-control" placeholder="DD Charge" name="sgst">
                                                    </div>
                                                </div>
                                                
                                                
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">FOV Ch.@</label>
                                                        <input type="number" class="form-control" placeholder="FOV Ch.@" name="igst">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Docs. Charge</label>
                                                        <input type="number" class="form-control" placeholder="Docs. Charge" name="cgst">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">TOTAL</label>
                                                        <input type="number" class="form-control" placeholder="TOTAL" name="sgst">
                                                    </div>
                                                </div>
                                                
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Convenience. Charge</label>
                                                        <input type="number" class="form-control" placeholder="Convenience. Charge" name="sgst">
                                                    </div>
                                                </div>
                                            
                                            
                                            <div class="form-group text-right">
                                                <button type="submit" class="btn btn-primary float-end ">Save</button>
                                            </div>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                </div>
            </div>
        </div>
        <!-- End section content -->

        <?php
   include('footer.php');
?>


    </div>
  
  
  <script>
        document.getElementById('add-subject').addEventListener('click', function() {
            var container = document.getElementById('marksheet-container');
            var row = document.createElement('div');
            row.className = 'row';
            row.innerHTML = `
        <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">G. C. No</label>
                                                        <input type="text" class="form-control" placeholder="G. C. No" name="gcno[]">
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Particulars</label>
                                                        <input type="text" class="form-control" placeholder="Particulars" name="particulars[]">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Weight</label>
                                                        <input type="text" class="form-control" placeholder="Weight" name="weight[]">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Rate</label>
                                                        <input type="text" class="form-control" placeholder="Rate" name="rate[]">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Amount</label>
                                                        <input type="text" class="form-control" placeholder="Amount" name="amount[]">
                                                    </div>
                                                </div>
           
    `;
            container.appendChild(row);
        });
    </script>

    

    <!-- popper js -->
    <script src="assets/plugins/popper/popper.min.js"></script>

    <!-- Bootstrap -->
    <script src="assets/plugins/bootstrap/js/bootstrap.js"></script>

    <!-- Moment -->
    <script src="assets/plugins/moment/moment.min.js"></script>

    <!-- Date Range Picker -->
    <script src="assets/plugins/daterangepicker/daterangepicker.min.js"></script>

    <!-- Datatable -->
    <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="assets/js/init-tdatatable.js"></script>

    <!-- Chart js -->
    <script src="assets/plugins/chart/chart/Chart.min.js"></script>
    <script src="assets/js/charts-custom.js"></script>

    <!-- Main Custom JQuery -->
    <script src="assets/js/toggleFullScreen.js"></script>
    <script src="assets/js/main.js"></script>

</body>
</html>