| Server IP : 92.204.40.98 / Your IP : 216.73.216.201 Web Server : LiteSpeed System : Linux amster.dnsfors.com 4.18.0-553.111.1.el8_10.x86_64 #1 SMP Sun Mar 8 20:06:07 EDT 2026 x86_64 User : tmksyste ( 2190) PHP Version : 8.3.31 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/tmksyste/domains/tmksystems.in/public_html/crmapp/ |
Upload File : |
<?php
session_start();
include 'connection.php';
?>
<!doctype html>
<html lang="en" data-layout="vertical" data-sidebar="dark" data-sidebar-image="img-1" data-sidebar-size="lg" data-preloader="disable" data-theme="default" data-topbar="light" data-bs-theme="light" data-theme-color="0">
<head>
<meta charset="utf-8">
<title>TMK System - Dashboard</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Minimal Admin & Dashboard Template" name="description">
<meta content="Themesbrand" name="author">
<link rel="shortcut icon" href="assets/images/favicon.png">
<!-- Fonts css load -->
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link id="fontsLink" href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700&display=swap" rel="stylesheet">
<!--datatable css-->
<link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css" >
<!--datatable responsive css-->
<link rel="stylesheet" href="https://cdn.datatables.net/responsive/2.2.9/css/responsive.bootstrap.min.css" >
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css">
<!-- Layout config Js -->
<script src="assets/js/layout.js"></script>
<!-- Bootstrap Css -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css">
<!-- Icons Css -->
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css">
<!-- App Css-->
<link href="assets/css/app.min.css" rel="stylesheet" type="text/css">
<!-- custom Css-->
<link href="assets/css/custom.min.css" rel="stylesheet" type="text/css">
<style>
#buttons-datatables > tbody > tr > td {
word-break: break-all !important;
white-space: normal;
}
</style>
</head>
<body>
<!-- Begin page -->
<div id="layout-wrapper">
<?php
include 'header.php';
?>
<!-- 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">
<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Customer Reports</a></li>
<li class="breadcrumb-item active">Customer Listing</li>
</ol>
</div>
</div>
</div>
</div>
<!-- end page title -->
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<h5 class="card-title mb-0">Customer Listing:</h5>
</div>
<div class="card-body">
<form action="" method="post" id="points_list">
<div class="row">
<div class="col-md-2">
<div class="form-group ">
<label>Product : </label>
<select class="form-control" name ="product" required>
<option value="0">Select Product</option>
<?php
$sqlsp="select * from product_list order by name asc";
$resultsp=mysqli_query($con,$sqlsp)or die(mysqli_error());
while($rowsp=mysqli_fetch_array($resultsp)){
?>
<option value="<?php echo $rowsp['name'];?>"><?php echo $rowsp['name'];?></option>
<?php }?>
</select>
</div>
</div>
<div class="col-md-2">
<div class="form-group ">
<label>Area : </label>
<select class="form-control" name ="area" required>
<option value="0">Select Area</option>
<?php
$sqlar="SELECT DISTINCT `city` FROM `customer_details` order by `city` asc";
$resultar=mysqli_query($con,$sqlar)or die(mysqli_error());
while($rowar=mysqli_fetch_array($resultar)){
?>
<option value="<?php echo $rowar['city'];?>"><?php echo $rowar['city'];?></option>
<?php }?>
</select>
</div>
</div>
<div class="col-md-2">
<div class="form-group ">
<label>Panchayath/Muncipality : </label>
<select class="form-control" name ="munci" required>
<option value="0">Select Panchayath/Muncipality</option>
<?php
$sqlm="SELECT DISTINCT `munci` FROM `customer_details` order by `munci` asc";
$resultm=mysqli_query($con,$sqlm)or die(mysqli_error());
while($rowm=mysqli_fetch_array($resultm)){
?>
<option value="<?php echo $rowm['munci'];?>"><?php echo $rowm['munci'];?></option>
<?php }?>
</select>
</div>
</div>
<div class="col-md-2">
<div class="form-group ">
<label>Thaluk : </label>
<select class="form-control" name ="thaluk" required id="regionlc">
<option value="0">Select Thaluk</option>
<?php
$sqlt="SELECT DISTINCT `thaluk` FROM `customer_details` order by `thaluk` asc";
$resultt=mysqli_query($con,$sqlt)or die(mysqli_error());
while($rowt=mysqli_fetch_array($resultt)){
?>
<option value="<?php echo $rowt['thaluk'];?>"><?php echo $rowt['thaluk'];?></option>
<?php }?>
</select>
</div>
</div>
<div class="col-md-2">
<div class="form-group ">
<label>District : </label>
<select class="form-control" name ="district" required id="zonelc">
<option value="0">Select District</option>
<option value="Alappuzha">Alappuzha</option>
<option value="Ernakulam">Ernakulam</option>
<option value="Idukki">Idukki</option>
<option value="Kannur">Kannur</option>
<option value="Kasaragod">Kasaragod</option>
<option value="Kollam">Kollam</option>
<option value="Kottayam">Kottayam</option>
<option value="Kozhikode">Kozhikode</option>
<option value="Malappuram">Malappuram</option>
<option value="Palakkad">Palakkad</option>
<option value="Pathanamthitta">Pathanamthitta</option>
<option value="Thiruvananthapuram">Thiruvananthapuram</option>
<option value="Thrissur">Thrissur</option>
<option value="Wayanad">Wayanad</option>
</select>
</div>
</div>
<div class="col-md-2">
<label></label>
<div class="form-group text-center no-gutters mb-5">
<button class="btn btn-info btn-md btn-block text-uppercase" name="submit" type="submit" value="submit" onclick="sendData()">SUBMIT</button>
</div>
</div>
</div>
</form>
<table id="buttons-datatables" class="table nowrap dt-responsive align-middle table-hover table-bordered" style="width:100%;">
<thead>
<tr><th>#</th><th>Bill No</th><th>Client <br>Name</th>
<th>Product</th><th>Contact <br>Person</th><th>Muncipality/ <br>Panchayath</th><th>Thaluk</th><th>District</th><th>Payment Date</th><th>Taxable <br>Amount</th><th>Total <br>Amount</th> </tr> </thead> <tbody>
<?php
$sql="select * from customer_details order by cid desc";
$result=mysqli_query($con,$sql) or die(mysqli_error());
$i=1;
while($row=mysqli_fetch_array($result))
{
$lid=$row['lid']; $cid=$row['cid'];
$sql1="select * from leads where lid='$lid'";
$result1=mysqli_query($con,$sql1) or die(mysqli_error());
$row1=mysqli_fetch_array($result1);
if($row['pdate']=='0000-00-00')
$pdate='';
else
$pdate=date("d-m-Y", strtotime($row['pdate']));
//$pdate=date("d-m-Y", strtotime($row['pdate']));
$lid2=$row['lid'];
?>
<tr> <th scope="row"><?php echo $i;?></th>
<td><?php echo $row['order_no'];?></td>
<td><?php if($row1['name_firm']!=""){
echo $row1['name_firm'];}
else{echo $row['customer'];}?></td>
<td><?php echo $row['product'];?></td>
<td><?php if($row['phone']!=""){
echo $row['phone'];}
else{
echo $row1['contact_name1']."<br>".$row1['number1'];}?></td>
<td><?php echo $row['munci'];?></td>
<td><?php echo $row['thaluk'];?></td>
<td><?php echo $row['district'];?></td>
<td><?php echo $pdate;?></td>
<td><?php echo $row['famount'];?></td>
<td><?php echo $row['total_amount'];?></td>
</tr>
<?php $i=$i+1;}?>
</tbody> </table>
</div>
</div>
</div><!--end col-->
</div><!--end row-->
</div>
<!-- container-fluid -->
</div>
<!-- End Page-content -->
<?php
include 'footer.php';
?>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<script>
function sendData()
{
$.ajax({
type : 'POST',
url : "customer_report_ajax.php",
data : $("#points_list").serialize(),
success : function(result){
//$("#mark_list_table").load(" #mark_list_table");
// $("#mark_list_table").replaceWith(result);
$("#buttons-datatables").hide().html(result).fadeIn('fast');
}
});
event.preventDefault();
}
</script>
<!-- JAVASCRIPT -->
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/js/plugins.js"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js" integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>
<!--datatable js-->
<script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.2.9/js/dataTables.responsive.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.print.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.html5.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="assets/js/pages/datatables.init.js"></script>
<!-- App js -->
<script src="assets/js/app.js"></script>
</body>
</html>