| 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">
<!-- App favicon -->
<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">
<!--Swiper slider css-->
<link href="assets/libs/swiper/swiper-bundle.min.css" rel="stylesheet" type="text/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>
#chartdiv {
width: 100%;
height: 295px;
}
</style>
<!--pie-chart --><!-- index page sales reviews visitors pie chart -->
<script src="js/pie-chart.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
$('#demo-pie-1').pieChart({
barColor: '#2dde98',
trackColor: '#eee',
lineCap: 'round',
lineWidth: 8,
onStep: function (from, to, percent) {
$(this.element).find('.pie-value').text(Math.round(percent) + '%');
}
});
$('#demo-pie-2').pieChart({
barColor: '#8e43e7',
trackColor: '#eee',
lineCap: 'butt',
lineWidth: 8,
onStep: function (from, to, percent) {
$(this.element).find('.pie-value').text(Math.round(percent) + '%');
}
});
$('#demo-pie-3').pieChart({
barColor: '#ffc168',
trackColor: '#eee',
lineCap: 'square',
lineWidth: 8,
onStep: function (from, to, percent) {
$(this.element).find('.pie-value').text(Math.round(percent) + '%');
}
});
$('#demo-pie-6').pieChart({
barColor: '#ffc168',
trackColor: '#eee',
lineCap: 'square',
lineWidth: 8,
onStep: function (from, to, percent) {
$(this.element).find('.pie-value').text(Math.round(percent) + '%');
}
});
$('#demo-pie-7').pieChart({
barColor: '#ffc168',
trackColor: '#eee',
lineCap: 'square',
lineWidth: 8,
onStep: function (from, to, percent) {
$(this.element).find('.pie-value').text(Math.round(percent) + '%');
}
});
});
</script>
</head>
<body>
<!-- Begin page -->
<div id="layout-wrapper">
<?php
include 'header.php';
?>
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="main-content">
<div class="page-content wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-xxl-12">
<div class="row">
<div class="col-xxl-7">
<div class="row">
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-info-subtle text-info rounded">
<i class="bx bx-user-voice"></i>
</div>
</div>
<h4 class="mt-3">
<?php
$sql="select * from leads";
$result=mysqli_query($con,$sql);?>
<strong><?php echo mysqli_num_rows($result);?></strong>
</h4>
<p class="mb-0 text-muted"><a href="lead_management.php">Total Leads</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-primary-subtle text-primary rounded">
<i class="bx bx-user"></i>
</div>
</div>
<h4 class="mt-3">
<?php
$sql1="select * from marketing_activities where lead_priority='Hot'";
$result1=mysqli_query($con,$sql1);
$sql2="select * from customer_details";
$result2=mysqli_query($con,$sql2);
?>
<strong><?php echo mysqli_num_rows($result1);?></strong>
</h4>
<p class="mb-0 text-muted"><a href="hot_leads_report.php">Hot Activities</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-warning-subtle text-warning rounded">
<i class="bx bx-injection"></i>
</div>
</div>
<h4 class="mt-3">
<strong><?php echo mysqli_num_rows($result2);?></strong>
</h4>
<p class="mb-0 text-muted"><a href="customer_reports.php">Customers</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-danger-subtle text-danger rounded">
<i class="bx bx-user-pin"></i>
</div>
</div>
<h4 class="mt-3">
<?php
$sql4="select * from marketing_activities where lead_status='Lost Lead'";
$result4=mysqli_query($con,$sql4);?>
<strong><?php echo mysqli_num_rows($result4);?></strong>
</h4>
<p class="mb-0 text-muted"><a href="lost_leads_report.php">Lost Leads</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-secondary-subtle text-secondary rounded">
<i class="bx bx-copy-alt"></i>
</div>
</div>
<h4 class="mt-3">
<?php
$date=date('Y-m-d');
$sql3="SELECT * FROM pflollowup where follow_date<'$date' and type!='Full' and fid IN (SELECT MAX(fid) FROM pflollowup GROUP BY pid)";
$result3=mysqli_query($con,$sql3);
$sqlj="select * from payment_followup where payment_closed!='closed'";
$resultj=mysqli_query($con,$sqlj)or die(mysqli_error());
$j1=1;
while($rowj=mysqli_fetch_array($resultj)){
$pidj=$rowj['name'];
$tdatej=date("Y-m-d");
$queryj="where pid='$pidj'";
$sql5j="SELECT * FROM pflollowup ".$queryj." and fid IN (SELECT MAX(fid) FROM pflollowup GROUP BY pid)";
$result5j=mysqli_query($con,$sql5j);
$row5j=mysqli_fetch_array($result5j);
if($row5j['type']!="Full"){
if($row5j['follow_date']<$tdatej){
$j1=$j1+1;}}}
?>
<strong><?php echo $j1-1;?></strong> </h4>
<p class="mb-0 text-muted"><a href="pending_payment_report.php">Pending Payment</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-success-subtle text-success rounded">
<i class="bx bx-wallet"></i>
</div>
</div>
<h4 class="mt-3 d-flex align-items-center"><?php
$sql5="select * from leads where follow_date='$date' and lid NOT IN (SELECT lid FROM marketing_activities GROUP BY lid);";
$result5=mysqli_query($con,$sql5);
//$sql6="select * from marketing_activities where follow_date='$date' group by lid having max(mid) order by mid";
$sql6="SELECT * FROM marketing_activities WHERE follow_date='$date' and lead_status!='Lost Lead' and mid IN (SELECT MAX(mid) FROM marketing_activities GROUP BY lid);";
$result6=mysqli_query($con,$sql6);
$t=mysqli_num_rows($result5)+mysqli_num_rows($result6);
//$t=mysql_num_rows($result6);
//$sql771="select * from marketing_activities where follow_date<='$date' group by lid having max(mid) order by mid desc";
$sql771="SELECT * FROM marketing_activities WHERE follow_date<'$date' and lead_status!='Lost Lead' and lead_status!='Closed' and mid IN (SELECT MAX(mid) FROM marketing_activities GROUP BY lid);";
$result771=mysqli_query($con,$sql771);
?>
<strong><?php echo $t;?></strong>
</h4>
<p class="mb-0 text-muted"><a href="today_followup_report.php">Today Followup</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-success-subtle text-success rounded">
<i class="bx bx-wallet"></i>
</div>
</div>
<h4 class="mt-3 d-flex align-items-center"><?php $sql7="SELECT * FROM pflollowup WHERE follow_date='$date' and fid IN (SELECT MAX(fid) FROM pflollowup GROUP BY pid);";
$result7=mysqli_query($con,$sql7);?>
<?php echo mysqli_num_rows($result7);?>
</h4>
<p class="mb-0 text-muted"><a href="today_payment_report.php">Todays Payment</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-success-subtle text-success rounded">
<i class="bx bx-wallet"></i>
</div>
</div>
<h4 class="mt-3 d-flex align-items-center"><?php echo mysqli_num_rows($result771);?>
</h4>
<p class="mb-0 text-muted"><a href="pending_report.php">Pending Followup</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-success-subtle text-success rounded">
<i class="bx bx-wallet"></i>
</div>
</div>
<h4 class="mt-3 d-flex align-items-center"><?php
$sql881="SELECT * FROM leads WHERE lid NOT IN(SELECT lid FROM marketing_activities)";
$result881=mysqli_query($con,$sql881);
?>
<?php echo mysqli_num_rows($result881);?> </h4>
<p class="mb-0 text-muted"><a href="nofollowup.php">No Followup</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-success-subtle text-success rounded">
<i class="bx bx-wallet"></i>
</div>
</div>
<h4 class="mt-3 d-flex align-items-center">0</h4>
<p class="mb-0 text-muted"><a href="service_notification.php">Service Notifications</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-success-subtle text-success rounded">
<i class="bx bx-wallet"></i>
</div>
</div>
<h4 class="mt-3 d-flex align-items-center"><?php
$todate=date("Y-m-d",strtotime("+5 days"));
$sql5="select * from leads where follow_date>'$date' and follow_date<='$todate' and lid NOT IN (SELECT lid FROM marketing_activities GROUP BY lid);";
$result5=mysqli_query($con,$sql5);
//$sql6="select * from marketing_activities where follow_date='$date' group by lid having max(mid) order by mid";
$sql6="SELECT * FROM marketing_activities WHERE follow_date>'$date' and follow_date<='$todate' and lead_status!='Lost Lead' and mid IN (SELECT MAX(mid) FROM marketing_activities GROUP BY lid);";
$result6=mysqli_query($con,$sql6);
$t=mysqli_num_rows($result5)+mysqli_num_rows($result6);
//$t=mysql_num_rows($result6);
//$sql771="select * from marketing_activities where follow_date<='$date' group by lid having max(mid) order by mid desc";
$sql771="SELECT * FROM marketing_activities WHERE follow_date<'$date' and lead_status!='Lost Lead' and lead_status!='Closed' and mid IN (SELECT MAX(mid) FROM marketing_activities GROUP BY lid);";
$result771=mysqli_query($con,$sql771);
?><?php echo $t;?></h4>
<p class="mb-0 text-muted"><a href="upcoming_followup_report.php">Upcoming Followup</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card">
<div class="card-body">
<div class="avatar-sm">
<div class="avatar-title fs-4xl bg-success-subtle text-success rounded">
<i class="bx bx-wallet"></i>
</div>
</div>
<h4 class="mt-3 d-flex align-items-center"><?php
$todate=date("Y-m-d",strtotime("+15 days"));
$sql6="SELECT * FROM `service` WHERE `nextdate`>'$date' and `nextdate`<='$todate'";
$result6=mysqli_query($con,$sql6);
$ts=mysqli_num_rows($result6);
?><?php echo mysqli_num_rows($result6);?> </h4>
<p class="mb-0 text-muted"><a href="upcoming_services.php">Upcoming
Services</a></p>
</div>
</div>
</div>
</div>
</div>
<div class="col-xxl-5">
<div class="card card-height-100">
<div class="card-header d-flex align-items-center">
<h6 class="card-title mb-0 flex-grow-1">Total Reports</h6>
</div>
<div class="card-body">
<?php
$sqlm="select * from leads where source_lead='Marketing'";
$resultm=mysql1_query($con,$sqlm);
$sqln="select * from leads where source_lead='Newspaper'";
$resultn=mysqli_query($con,$sqln);
$sqld="select * from leads where source_lead='Direct'";
$resultd=mysqli_query($con,$sqld);
$sqlw="select * from leads where source_lead='Website'";
$resultw=mysqli_query($con,$sqlw);
$sqlr="select * from leads where source_lead='Reference'";
$resultr=mysqli_query($con,$sqlr);?>
<div id="piechart"></div>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
// Load google charts
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
// Draw the chart and set the chart values
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Task', 'Hours per Day'],
['Hot Leads', <?php echo mysql_num_rows($result1);?>],
['Lost Leads', <?php echo mysql_num_rows($result4);?>],
['Marketing', <?php echo mysql_num_rows($resultm);?>],
['Newspaper', <?php echo mysql_num_rows($resultn);?>],
['Direct', <?php echo mysql_num_rows($resultd);?>],
['Website', <?php echo mysql_num_rows($resultw);?>],
['Reference', <?php echo mysql_num_rows($resultr);?>]
]);
// Optional; add a title and set the width and height of the chart
var options = {'title':'TMK SYSTEMS', 'width':550, 'height':355};
// Display the chart inside the <div> element with id="piechart"
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- container-fluid -->
</div>
<?php
include 'footer.php';
?>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<script src="http://code.jquery.com/jquery-1.11.0.min.js"></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="assets/libs/list.js/list.min.js"></script>
<!--Swiper slider js-->
<script src="assets/libs/swiper/swiper-bundle.min.js"></script>
<!-- apexcharts -->
<script src="assets/libs/apexcharts/apexcharts.min.js"></script>
<!--dashboard doctor init js-->
<script src="assets/js/pages/dashboard-doctor.init.js"></script>
<!-- App js -->
<script src="assets/js/app.js"></script>
</body>
</html>