Файловый менеджер - Редактировать - /home/d46091/invoice.ecogenix.in/transporter.php
Назад
<?php require_once('includes/connection.php'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { $vehicle_no = $_POST['vehicle_no']; $vehicle_model = $_POST['vehicle_model']; $vehicle_capacity = $_POST['vehicle_capacity']; $vehicle_insurance_validy = $_POST['vehicle_insurance_validy']; $status = $_POST['status']; $transporter_name = $_POST['transporter_name']; $created_at = date('Y-m-d H:i:s'); $stmt = $conn->prepare( "INSERT INTO `vehicle_master` (`vehicle_no`, `vehicle_model`, `vehicle_capacity`, `vehicle_insurance_validy`, `status`, `created_at`) VALUES (?, ?, ?, ?, ?, ?)" ); if (! $stmt) { die("Prepare failed: " . $conn->error); } $stmt->bind_param("ssssss", $vehicle_no, $vehicle_model, $vehicle_capacity, $vehicle_insurance_validy, $status, $created_at); if (! $stmt->execute()) { die("Vehicle insert failed: " . $stmt->error); } $vehicle_id = $conn->insert_id; $stmt->close(); $stmt2 = $conn->prepare( "INSERT INTO `broker_master` (`vehicle_id`, `transporter_name`, `status`, `created_at`, `updated_at`) VALUES (?, ?, ?, ?, ?)" ); if (! $stmt2) { die("Prepare broker insert failed: " . $conn->error); } $stmt2->bind_param("issss", $vehicle_id, $transporter_name, $status, $created_at, $created_at); if ($stmt2->execute()) { echo "<script> alert('Transporter added successfully!'); window.location.href = 'transporter.php'; </script>"; } else { die("Broker insert failed: " . $stmt2->error); } $stmt2->close(); } require_once('includes/header.php'); ?> <div class="content"> <nav class="navbar navbar-expand-lg navbar-light bg-light mb-4"> <div class="container-fluid"> <button id="sidebarToggle" class="btn btn-outline-secondary d-md-none mr-auto"> <span class="navbar-toggler-icon"></span> </button> <a class="navbar-brand d-md-none" href="#">ECOGENIX</a> <div class="d-flex"> <!-- <input class="form-control me-2" type="search" placeholder="Search" aria-label="Search"> --> <!-- <button class="btn btn-outline-success" type="submit">Search</button> --> </div> </div> </nav> <div class="container-fluid"> <div class="row"> <div class="col-12"> <h2 class="mb-4">Transporter Dashboard</h2> </div> </div> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-header d-flex justify-content-between align-items-center"> <span>Transporter's Inventory</span> <div> <!-- <button class="btn btn-sm btn-outline-primary">Export</button> --> <button class="btn btn-sm btn-primary" data-bs-toggle="modal" data-bs-target="#addVendorModal">Add New</button> </div> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-striped table-hover"> <thead> <tr> <th>ID</th> <th>Transportar Name</th> <th>Vehicle Number</th> <th>Vehicle Model</th> <th>Vehicle Capacity</th> <th>Vehicle Insurance Valid</th> <th>Actions</th> </tr> </thead> <tbody> <?php $query = "SELECT broker_master.*, vehicle_master.* FROM `broker_master` LEFT JOIN `vehicle_master` ON vehicle_master.id = broker_master.vehicle_id"; $result = $conn->query($query); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo "<tr> <td>{$row['id']}</td> <td>{$row['transporter_name']}</td> <td>{$row['vehicle_no']}</td> <td>{$row['vehicle_model']}</td> <td>{$row['vehicle_capacity']}</td> <td>{$row['vehicle_insurance_validy']}</td> <td> <a href='transportar_edit.php?id={$row['id']}' class='btn btn-sm btn-warning'><i class='fa-solid fa-pen'></i></a> </td> </tr>"; } } else { echo '<tr><td colspan="5" class="text-center">No records found.</td></tr>'; } ?> </tbody> </table> </div> <!-- <nav> <ul class="pagination justify-content-center"> <li class="page-item disabled"> <a class="page-link" href="#" tabindex="-1">Previous</a> </li> <li class="page-item active"><a class="page-link" href="#">1</a></li> <li class="page-item"><a class="page-link" href="#">2</a></li> <li class="page-item"><a class="page-link" href="#">3</a></li> <li class="page-item"> <a class="page-link" href="#">Next</a> </li> </ul> </nav> --> </div> </div> </div> </div> </div> </div> <!-- Add Item Modal --> <div class="modal fade" id="addVendorModal" tabindex="-1" aria-labelledby="addVendorModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <form action="" method="POST"> <!-- Replace with your actual form handler --> <div class="modal-header"> <h5 class="modal-title" id="addVendorModalLabel">Add Transporter Details</h5> <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> </div> <div class="modal-body"> <div class="mb-3"> <label for="transporter_name" class="form-label">Transportar Name</label> <input type="text" class="form-control" id="transporter_name" name="transporter_name" required> </div> <div class="mb-3"> <label for="vehicle_no" class="form-label">Vehicle Number</label> <input type="text" class="form-control" id="vehicle_no" name="vehicle_no" required> </div> <div class="mb-3"> <label for="vehicle_model" class="form-label">Vehicle Model</label> <input type="text" class="form-control" id="vehicle_model" name="vehicle_model" required> </div> <div class="mb-3"> <label for="vehicle_capacity" class="form-label">Vehicle Capacity</label> <input type="text" class="form-control" id="vehicle_capacity" name="vehicle_capacity" required> </div> <div class="mb-3"> <label for="vehicle_insurance_validy" class="form-label">Vehicle Insurance Date</label> <input type="date" class="form-control" id="vehicle_insurance_validy" name="vehicle_insurance_validy" required> </div> <!-- Status --> <div class="mb-3"> <label for="status" class="form-label">Status</label> <select class="form-select" id="status" name="status" required> <option value="1">Active</option> <option value="0">Deactive</option> </select> </div> </div> <div class="modal-footer"> <button type="submit" class="btn btn-success">Save Item</button> <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button> </div> </form> </div> </div> </div> <?php require_once('includes/footer.php'); ?>
| ver. 1.4 |
Github
|
.
| PHP 8.1.32 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка