| 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="Web Development,Mobile App Development" />
<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>
$( function() {
$( "#datepicker" ).datepicker();
} );
</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">Pending Payment Report</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>Pending Payment Listing:</h4>
<!-- <table class="table table-bordered"> <thead>
<tr><th>#</th><th>Client Name</th><th>Work Details</th><th>Order Date</th><th>Order Number</th> <th>Name & Phone</th><th>T:Amount</th></tr> </thead> <tbody>
<?php
/*$tdate=date("Y-m-d");
$query="where follow_date<'".$tdate."'";
$sql5="SELECT * FROM pflollowup ".$query." and fid IN (SELECT MAX(fid) FROM pflollowup GROUP BY pid)";
$result5=mysql_query($sql5);
$j=1;
while($row5=mysql_fetch_array($result5))
{$pid=$row5['pid'];
$sql7="select * from leads where lid='$pid'";
$result7=mysql_query($sql7);
$row7=mysql_fetch_array($result7);
$sql="select * from payment_followup where name='$pid'";
$result=mysql_query($sql)or die(mysql_error());
$row=mysql_fetch_array($result);
if($row5['type']!="Full"){
$pdate=date("d-m-Y", strtotime($row['Invoice_date']));
?>
<tr><th scope="row"><?php echo $j;?></th>
<td><?php echo $row7['name_firm'];?></td>
<td><?php echo $row['Work_details'];?></td>
<td><?php echo $pdate;?></td>
<td><?php echo $row['Invoice_number'];?></td>
<td><?php echo $row['followup_person_name']."<br>".$row['Phone_number'];?></td>
<td><?php echo $row['Amount'];?></td>
<td><a href="payment_followup_add.php?id=<?php echo $row['name']."&iid=".$row['Invoice_number'];;?>"><img src="images/icons/marketing.png" width="28px" height="28px" alt="View"></a></td></tr>
<?php $j=$j+1;}}*/?>
</tbody></table>
-->
<table class="table table-bordered"> <thead>
<tr><th>#</th><th>Client Name</th><th>Remarks</th>
<th>Order Date</th><th>Order Number</th><th>Name & Phone</th>
<th>T:Amount</th><th>Balance</th></tr> </thead> <tbody>
<?php
$sqlj="select * from payment_followup where payment_closed!='closed'";
$resultj=mysql_query($sqlj)or die(mysql_error());
$j1=1;
while($rowj=mysql_fetch_array($resultj)){
$pidj=$rowj['name'];
$sql7="select * from leads where lid='$pidj'";
$result7=mysql_query($sql7);
$row7=mysql_fetch_array($result7);
$pdate=date("d-m-Y", strtotime($rowj['Invoice_date']));
$tdate=date("Y-m-d");
$query="where pid='$pidj'";
$sql5="SELECT * FROM pflollowup ".$query." and fid IN (SELECT MAX(fid) FROM pflollowup GROUP BY pid)";
$result5=mysql_query($sql5);
$row5=mysql_fetch_array($result5);
if($row5['type']!="Full"){
if($row5['follow_date']<$tdate){
?>
<tr><th scope="row"><?php echo $j1;?></th>
<td><?php echo $row7['name_firm'];?></td>
<td><?php echo $row5['remarks'];?></td>
<td><?php echo $pdate;?></td>
<td><?php echo $rowj['Invoice_number'];?></td>
<td><?php echo $rowj['followup_person_name']."<br>".$rowj['Phone_number'];?></td>
<td><?php echo $rowj['Amount'];?></td>
<td><?php if($rowj['balance']=='0'){echo $rowj['pending_amount'];}else{echo $rowj['balance'];}?></td>
<td><a href="payment_followup_add.php?id=<?php echo $rowj['name']."&iid=".$rowj['Invoice_number'];;?>"><img src="images/icons/marketing.png" width="28px" height="28px" alt="View"></a></td></tr>
<?php $j1=$j1+1;}}}?>
</tbody></table>
</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>