| 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
include('connection.php');
$pid=$_GET['id'];
$iid=$_GET['iid'];
$name=$_POST['customer_id'];
$status=$_POST['status'];
$amount_paying=$_POST['amount_paying'];
$remarks=$_POST['remarks'];
$follow_date=$_POST['follow_date'];
$follow_time=$_POST['follow_time'];
$sql2="select * from payment_followup where name='$pid' and Invoice_number='$iid'";
$result=mysqli_query($con,$sql2)or die(mysqli_error());
$row=mysqli_fetch_array($result);
//echo $row['balance'];
if($row['balance']!="0"){
$balance=$row['balance']-$amount_paying;
}else{
$balance=$row['pending_amount']-$amount_paying;
}
if($status=='Full'){$status1='closed';$aa="Amount='0',";}
else{$status1='continues';$aa="";}
$date=date("Y-m-d");
if(isset($_REQUEST['submit']))
{
$sql="insert into pflollowup(pid,type,todaydate,paid_amount,follow_date,follow_time,remarks,invoice_number)values('$pid','$status','$date','$amount_paying','$follow_date','$follow_time','$remarks','$iid')";
mysqli_query($con,$sql);
$sql1="update payment_followup set $aa balance='$balance',payment_closed='$status1' where name='$pid' and Invoice_number='$iid'";
mysqli_query($con,$sql1);
//echo $sql; echo $sql1;
header('location:payment_followup.php?log=insert');
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=payment_followup.php?log=insert">';
}
?>