|
Server IP : 162.214.80.37 / Your IP : 216.73.216.68 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/www/crm/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
if (!isset($_SESSION['uid'])) {
header("Location: login.php");
}
$se = $_SESSION["uid"];
include 'include/config.php';
?>
<!doctype html>
<html lang="en">
<?php include 'include/head.php'; ?>
<body>
<!-- <body data-layout="horizontal"> -->
<!-- Begin page -->
<div id="layout-wrapper">
<?php include 'include/header.php'; ?>
<!-- ========== Left Sidebar Start ========== -->
<div class="vertical-menu">
<div data-simplebar class="h-100">
<!--- Sidemenu -->
<?php include 'include/menu.php'; ?>
<!-- Sidebar -->
</div>
</div>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<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">Client Database </h4>
<div class="page-title-right">
<a href="client_follow_add.php"><button type="submit" class="btn btn-primary w-md">Add</button></a>
</div>
</div>
</div>
</div>
<!-- end page title -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header">
<!-- -->
<form method="POST">
<div class="row">
<div class="col-lg-3">
<div>
<div class="mb-3">
<label for="example-text-input" class="form-label">Country</label>
<select class="form-select" name="contry" id="country">
<option value="">Select Country</option>
<?php
$result = mysqli_query($con,"SELECT * FROM countries");
while($row = mysqli_fetch_array($result)) {
?>
<option value="<?php echo $row['id'];?>"><?php echo $row['name'] ;?></option>
<?php
}
?>
</select>
</div>
</div>
</div>
<div class="col-lg-3" id="sta">
<div class="mb-3">
<label for="example-text-input" class="form-label">State</label>
<select class="form-select" name="state" id="state">
<option value="">Select State</option>
<?php
$result = mysqli_query($con,"select * from tbl_states where country_id ='101'");
while($row = mysqli_fetch_array($result)) {
?>
<option value="<?php echo $row['id'];?>"><?php echo $row['name'] ;?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="col-lg-3" id="sta1">
<div class="mb-3">
<label for="example-text-input" class="form-label">City</label>
<select class="form-select" name="city" id="city">
<option value="">Select State First</option>
</select>
</div>
</div>
<div class="col-lg-3">
<div>
<div class="mb-3">
<label for="example-text-input" class="form-label">Religion</label>
<select class="form-select" name="religion" id="religion">
<option value="">Select Religion</option>
<?php
$result = mysqli_query($con,"SELECT * FROM tbl_religion");
while($row = mysqli_fetch_array($result)) {
?>
<option value="<?php echo $row['id'];?>"><?php echo $row['name'] ;?></option>
<?php
}
?>
</select>
</div>
</div>
</div>
</div>
<div class="mt-4">
<button type="submit" name="find" class="btn btn-primary w-md">Submit</button>
</div>
</form>
</div>
<div class="card-body">
<table id="datatable-buttons" class="table table-bordered dt-responsive nowrap w-100">
<thead>
<tr>
<th>#</th>
<th>Customer Name</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if(isset($_POST['find']))
{
$v1 = $_POST['contry'];
@$v2 = $_POST['city'];
@$v3 = $_POST['state'];
@$v4 = $_POST['religion'];
if ($v1 != '' && $v1!='all') {
$vv1 = " AND country='$v1'";
} else {
$vv1 = '';
}
if ($v2 != '' && $v2!='all') {
$vv2 = " AND state='$v2'";
} else {
$vv2 = '';
}
if ($v3 != '' && $v3!='all') {
$vv3 = " AND city='$v3'";
} else {
$vv3 = '';
}
if ($v4 != '' && $v4!='all') {
$vv4 = " AND religion='$v4'";
} else {
$vv4 = '';
}
$count = 1;
$sql = "select * from tbl_user where filter IS NULL $vv1 $vv2 $vv3 $vv4";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($sql_row = mysqli_fetch_assoc($sql_res)){
$name = $sql_row['fname'] . $sql_row['lname'];
?>
<tr>
<td><?php echo $count; ?></td>
<td><?php echo $name; ?></td>
<td>
<a href="./customer_view.php?id=<?php echo $sql_row['id']; ?>" class=" text-primary">
<i class="fa fa-eye font-size-18"></i>
</a>
</td>
</tr>
<?php } } ?>
</tbody>
</table>
</div>
</div>
</div> <!-- end col -->
</div> <!-- end row -->
</div> <!-- container-fluid -->
</div>
<!-- End Page-content -->
<?php include 'include/footer.php'; ?>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<!-- Right Sidebar -->
<?php include 'include/rightsidebar.php'; ?>
<!-- /Right-bar -->
<!-- Right bar overlay-->
<div class="rightbar-overlay"></div>
<?php include 'include/bscript.php'; ?>
<script type="text/javascript">
// $(document).ready(function() {
// $('#country').on('change', function() {
// var conID = $(this).val();
// // alert(conID);
// $.ajax({
// type: 'POST',
// url: 'Ajax/get_state.php',
// data: {state: conID },
// success: function(response) {
// // alert(response);
// $('#sta').html(response);
// }
// });
// });
// });
</script>
<script type="text/javascript">
$(document).ready(function() {
$('#sta').hide();
$('#sta1').hide();
$('#country').on('change', function() {
var conID = $(this).val();
// alert(conID);
$.ajax({
type: 'POST',
url: 'Ajax/get_state_city.php',
data: {state: conID },
success: function(response) {
if(response==1)
{
$('#sta').show();
$('#sta1').show();
}
else
{
$('#sta').hide();
$('#sta1').hide();
}
}
});
});
});
</script>
<script type="text/javascript">
$(document).ready(function() {
$('#state').on('change', function() {
var stateID = $(this).val();
// alert(conID);
$.ajax({
type: 'POST',
url: 'Ajax/get_citys.php',
data: {city: stateID },
success: function(response) {
// alert(response);
$('#city').html(response);
// content.html(response);
}
});
});
});
</script>
</body>
<!-- Mirrored from themesbrand.com/minia/layouts/tables-datatable.html by HTTrack Website Copier/3.x [XR&CO'2014], Sat, 20 May 2023 06:14:37 GMT -->
</html>