| 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();
$type=$_SESSION["type"];
$eids=$_SESSION["userid"];
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="Admin & Dashboard" name="description">
<meta content="Web Drop Developers" 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">
</head>
<body>
<!-- Begin page -->
<div id="layout-wrapper">
<?php include('header.php'); ?>
<!-- ============================================================== -->
<div class="main-content">
<div class="page-content wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-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 where followup_excecutive='$eids'";
$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' and followup_excecutive='$eids'";
$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-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);
$count_up=0;
$date=date('Y-m-d');
//$sql="select * from marketing_activities group by lid order by mid desc";
$sql="SELECT * FROM marketing_activities WHERE mid IN (SELECT MAX(mid) FROM marketing_activities GROUP BY lid);";
$result=mysqli_query($con,$sql)or die(mysqli_error());
$i=1;
$todate=date("Y-m-d",strtotime("+5 days"));
while($row=mysqli_fetch_array($result))
{
$lid=$row['lid'];//echo $lid." - ".$row['mid']." - ".$row['follow_date']."<br>";
$sql1="select * from leads where lid=$lid";
$result1=mysqli_query($con,$sql1)or die(mysqli_error());
$row1=mysqli_fetch_array($result1);
if(($row['follow_date']>$date)&&($row['follow_date']<=$todate)){
if($row['lead_status']!='Lost Lead'){
$count_up++;
}
}
}
//$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 $count_up;?></h4>
<p class="mb-0 text-muted"><a href="upcoming_followup_report.php">Upcoming Followup</a></p>
</div>
</div>
</div>
<?php
$sql4="select * from marketing_activities where lead_status='Lost Lead'";
$result4=mysqli_query($con,$sql4);?>
</div>
</div>
<div class="col-md-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">TMK SYSTEMS REPORTS</h6>
<script src="https://cdn.jsdelivr.net/npm/apexcharts"></script>
</div>
<div class="card-body">
<div id="chart"></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- container-fluid -->
</div>
<!-- End Page-content -->
<?php include('footer.php'); ?>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<?php
$sqlm="select * from leads where source_lead='Marketing'";
$resultm=mysqli_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);?>
<script>
var options = {
series: [<?php echo mysqli_num_rows($result1);?>,<?php echo mysqli_num_rows($result4);?>,<?php echo mysqli_num_rows($resultm);?>,<?php echo mysqli_num_rows($resultn);?>,<?php echo mysqli_num_rows($resultd);?>,<?php echo mysqli_num_rows($resultw);?>,<?php echo mysqli_num_rows($resultr);?>],
chart: {
type: 'pie',
},
stroke: {
colors: ['#fff']
},
fill: {
opacity: 0.8
},
labels: ['Hot Leads', 'Lost Leads', 'Marketing', 'Newspaper', 'Direct', 'Website', 'Reference'],
responsive: [{
breakpoint: 480,
options: {
chart: {
width: 100
},
legend: {
position: 'bottom'
}
}
}]
};
var chart = new ApexCharts(document.querySelector("#chart"), options);
chart.render();
</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>