| 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/public_html/applications/ |
Upload File : |
<!DOCTYPE HTML>
<html>
<head>
<title>Channel4Net | Tables</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="keywords" content="Glance Design Dashboard Responsive web template, Bootstrap Web Templates, Flat Web Templates, Android Compatible web template,
SmartPhone Compatible web template, free WebDesigns for Nokia, Samsung, LG, SonyEricsson, Motorola web design" />
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Bootstrap Core CSS -->
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- Custom CSS -->
<link href="css/style.css" rel='stylesheet' type='text/css' />
<!-- font-awesome icons CSS -->
<link href="css/font-awesome.css" rel="stylesheet">
<!-- //font-awesome icons CSS -->
<!-- side nav css file -->
<link href='css/SidebarNav.min.css' media='all' rel='stylesheet' type='text/css'/>
<!-- side nav css file -->
<!-- js-->
<script src="js/jquery-1.11.1.min.js"></script>
<script src="js/modernizr.custom.js"></script>
<!--webfonts-->
<link href="//fonts.googleapis.com/css?family=PT+Sans:400,400i,700,700i&subset=cyrillic,cyrillic-ext,latin-ext" rel="stylesheet">
<!--//webfonts-->
<!-- Metis Menu -->
<script src="js/metisMenu.min.js"></script>
<script src="js/custom.js"></script>
<link href="css/custom.css" rel="stylesheet">
<!--//Metis Menu -->
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<link rel="stylesheet" href="/resources/demos/style.css">
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<script type="text/javascript">
$(function() {
$("#datepicker").datepicker({ dateFormat: "dd-mm-yy" }).val()
});
</script>
<link href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css" rel='stylesheet' type='text/css' />
<link href="https://cdn.datatables.net/buttons/1.5.6/css/buttons.dataTables.min.css" rel='stylesheet' type='text/css' />
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.flash.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.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/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js"></script>
<script>$(document).ready(function() {
$('#example').DataTable( {
dom: 'Bfrtip',
buttons: [
'copy', 'csv', 'excel', 'pdf', 'print'
]
} );
} );
</script>
</head>
<body class="cbp-spmenu-push">
<div class="main-content">
<?php include('sidemenu.php');?>
<?php include('connection.php');error_reporting(0);?>
<!-- main content start-->
<div id="page-wrapper">
<div class="main-page">
<div class="tables">
<h2 class="title1">Marketing Activities</h2>
<?php if($_REQUEST['log']=="insert"){?>
<div class="alert alert-success" role="alert">
<strong>Well done!</strong> You successfully inserted new lead details.
</div>
<?php }?>
<?php if($_REQUEST['log']=="edit"){?>
<div class="alert alert-info" role="alert">
<strong>Well done!</strong> You successfully edited lead details.
</div>
<?php }?>
<?php if($_REQUEST['log']=="delete"){?>
<div class="alert alert-danger" role="alert">
<strong>Oh snap!</strong> You successfully deleted lead details.
</div>
<?php }?>
<div class="bs-example widget-shadow" data-example-id="bordered-table">
<h4>Activity Listing:</h4>
<form name="form" action="" method="post">
<input type="text" class="form-control" id="datepicker" style="float:left; width:38%;margin-right:25px;" placeholder="Pick Followup Date" name="date" autocomplete="off">
<select class="form-control" name="excecutive" style="float:left; width:38%;">
<option value="">FOLLOW UP EXCECUTIVE</option>
<?php
$sqll="select * from login where type='employee'";
$resultl=mysql_query($sqll);
while($rowl=mysql_fetch_array($resultl)){?>
<option value="<?php echo $rowl['id'];?>"><?php echo $rowl['Name'];?></option>
<?php }?>
</select>
<input type="submit" class="btn btn-primary" value="Search" name="submit" style="float:right;width:100px;">
<div class="clearfix"></div><br>
</form>
<?php
$tdate=date("Y-m-d");
$date=date("Y-m-d", strtotime($_POST['date']));
$excecutive=$_POST['excecutive'];//1969-12-31 1970-01-01
$dd="1970-01-01";
if($date!=$dd && $excecutive!=""){$query="where followup_excecutive='".$excecutive."' and follow_date<'".$date."'";}
else if($date!=$dd){$query="where follow_date<'".$date."'";}
else if($excecutive!=""){$query="where followup_excecutive='".$excecutive."'";}
else if($date==$dd && $excecutive==""){$query="where follow_date<'".$tdate."'";}
else{$query="where follow_date<'".$tdate."'";}
//$sql="select * from marketing_activities ".$query." order by mid desc";
$sql="SELECT * FROM marketing_activities ".$query." and mid IN (SELECT MAX(mid) FROM marketing_activities GROUP BY lid)";
//echo $sql;
$result=mysql_query($sql) or die(mysql_error());
$i=1;
if($i!=0){
?>
<table class="table table-bordered" id="example">
<thead>
<tr><th>#</th><th width="11%">Added Date <br> Followup Date</th><th>Firm Name</th><th>Whatsapp<br>Mobile Number</th><th>Lead Priority<br>Status</th><th>Contact Person <br>Details</th><th>Excecutive</th><th>Remarks</th><th>Options</th></tr> </thead> <tbody>
<?php
while($row=mysql_fetch_array($result))
{if($row['lead_status']!="Lost Lead"){
$lid=$row['lid'];
$sql1="select * from leads where lid=$lid";//echo $sql1;
$result1=mysql_query($sql1) or die(mysql_error());
$row1=mysql_fetch_array($result1);
$eid=$row['followup_excecutive'];
$sql2="select * from login where id=$eid";
$result2=mysql_query($sql2);
$row2=mysql_fetch_array($result2);
if($row['follow_date']=='0000-00-00'){$fdate="<font color='red'>No Date</font>";}
else{$fdate=date("d-m-Y", strtotime($row['follow_date']));}
?>
<tr><th scope="row"><?php echo $i;?></th>
<td width="11%"><?php echo date("d-m-Y", strtotime($row['date']))."<br>".$fdate;?></td>
<td><?php echo $row1['name_firm'];?></td>
<td><?php echo $row['whatsapp']."<br>".$row['number1'];?></td>
<td><?php echo $row['lead_priority'];?><br><?php echo $row['lead_status'];?></td>
<td><?php echo $row['contact_name1'];?><br><?php echo $row['designation1'];?><br><?php echo $row['number1'];?></td>
<td><?php echo $row2['Name'];?></td>
<td><?php echo $row['remarks'];?></td>
<td><a href="activity_add.php?id=<?php echo $lid;?>"><img src="images/icons/marketing.png" width="28px" height="28px" alt="View"></a></td></tr>
<?php $i=$i+1;}}?>
</tbody> </table>
<?php }?>
</div>
</div>
</div>
</div>
<?php include('footer.php');?>
</div>
<!-- side nav js -->
<script src='js/SidebarNav.min.js' type='text/javascript'></script>
<script>
$('.sidebar-menu').SidebarNav()
</script>
<!-- //side nav js -->
<!-- Classie --><!-- for toggle left push menu script -->
<script src="js/classie.js"></script>
<script>
var menuLeft = document.getElementById( 'cbp-spmenu-s1' ),
showLeftPush = document.getElementById( 'showLeftPush' ),
body = document.body;
showLeftPush.onclick = function() {
classie.toggle( this, 'active' );
classie.toggle( body, 'cbp-spmenu-push-toright' );
classie.toggle( menuLeft, 'cbp-spmenu-open' );
disableOther( 'showLeftPush' );
};
function disableOther( button ) {
if( button !== 'showLeftPush' ) {
classie.toggle( showLeftPush, 'disabled' );
}
}
</script>
<!-- //Classie --><!-- //for toggle left push menu script -->
<!--scrolling js-->
<script src="js/jquery.nicescroll.js"></script>
<script src="js/scripts.js"></script>
<!--//scrolling js-->
<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.js"> </script>
</body>
</html>