|
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/clickonn/Admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
error_reporting(E_ERROR | E_PARSE);
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("Includes/db.php");;
?>
<!doctype html>
<html lang="en">
<head>
<?php include 'Includes/head.php'; ?>
</head>
<body data-sidebar="dark">
<!-- <body data-layout="horizontal" data-topbar="dark"> -->
<!-- Begin page -->
<div id="layout-wrapper">
<?php include 'Includes/header.php'; ?>
<!-- ========== Left Sidebar Start ========== -->
<div class="vertical-menu">
<div data-simplebar class="h-100">
<!--- Sidemenu -->
<?php include 'Includes/sidebar.php'; ?>
<!-- Sidebar -->
</div>
</div>
<!-- Left Sidebar End -->
<div class="main-content">
<div class="page-content">
<div class="container-fluid">
<!-- start page title -->
<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18"> Vendor </h4>
</div>
</div>
</div>
<!-- end page title -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<div class="row">
<div class="col-md-10"></div>
<div class="col-md-2" style="padding: 13px;">
</div>
<br>
</div>
<table id="datatable-buttons" class="table table-bordered dt-responsive nowrap w-100">
<thead>
<tr>
<th>#</th>
<th>Status</th>
<th>Name</th>
<th>Company Name</th>
<th>Executive Name</th>
<th>Email</th>
<th>Mobile</th>
<th>Package</th>
<th>Add Date </th>
<th>End Date </th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
// session_start();
// $executive_id = $_SESSION['id'];
$count = 1;
// Fetch only records where executive_id is not 0 or NULL and join with tbl_field
$sql = "SELECT v.*, f.name AS executive_name
FROM tbl_vendore v
LEFT JOIN tbl_field f ON v.executive_id = f.id
WHERE v.executive_id IS NOT NULL AND v.executive_id != 0
ORDER BY v.id DESC";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($sql_row = mysqli_fetch_assoc($sql_res)) {
?>
<tr>
<td><?php echo $count; ?></td>
<td>
<?php
if ($sql_row['status'] == '0') {
echo '<span class="badge badge-pill badge-soft-info font-size-11">Pending</span>';
} elseif ($sql_row['status'] == '1') {
echo '<span class="badge badge-pill badge-soft-success font-size-11">Approve</span>';
} elseif ($sql_row['status'] == '2') {
echo '<span class="badge badge-pill badge-soft-danger font-size-11">Reject</span>';
} elseif ($sql_row['status'] == '3') {
echo '<span class="badge badge-pill badge-soft-warning font-size-11">Package Over</span>';
}
?>
</td>
<td><?php echo $sql_row['name']; ?></td>
<td><?php echo $sql_row['cname']; ?></td>
<th> <strong class="text-info"><?php echo $sql_row['executive_name']; ?></strong></th>
<td><?php echo $sql_row['email']; ?></td>
<td><?php echo $sql_row['phone']; ?></td>
<td><?php echo $sql_row['package']; ?></td>
<td><?php echo date('d-m-Y', strtotime($sql_row['add_date'])); ?></td>
<td><?php echo date('d-m-Y', strtotime($sql_row['end_date'])); ?></td>
<!-- <td><?php echo $sql_row['add_date']; ?></td>
<td><?php echo $sql_row['end_date']; ?></td> -->
<td>
<a href="./vendor_view.php?id=<?php echo $sql_row['id']; ?>" class="text-primary">
<i class="fa fa-eye font-size-18"></i>
</a>
<a href="./action/delete.php?id=<?php echo $sql_row['id']; ?>&table=vendor" class="text-primary">
<i class="fa fa-trash font-size-18"></i>
</a>
</td>
</tr>
<?php
$count++;
}
?>
</tbody>
</table>
</div>
</div>
</div> <!-- end col -->
</div> <!-- end row -->
<!-- end row -->
<!-- end row -->
<!-- end row -->
</div>
<!-- container-fluid -->
</div>
<!-- End Page-content -->
<footer class="footer">
<?php include 'Includes/footer.php'; ?>
</footer>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<!-- Right Sidebar -->
<!-- /Right-bar -->
<!-- Right bar overlay-->
<div class="rightbar-overlay"></div>
<?php include 'Includes/bscript.php'; ?>
</body>
</html>