1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / app.eltorofashions.com /
Filename : invoice_update.php
back
<?php 
session_start();
if(isset($_SESSION['login'])){
include "main.php"; 
//if(isset($_POST['submit']){
//echo $_POST['username'];
if(isset($_POST['submit'])){
echo $invoiceid=$_POST['invoiceid'];
echo $oldinvoice=$_POST['oldinvoice'];
echo "<br>".$agentcode=$_POST['agentcode'];
echo "<br>".$invoiceno=$_POST['invoiceno'];
echo "<br>".$date=$_POST['date'];
echo "<br>".$party=addslashes($_POST['party']);
echo "<br>".$amount=$_POST['amount'];

//calculate balance amount
$paysql="SELECT sum(amount) as Payamount FROM `payment` WHERE `invoice` = '$invoiceno' and del=1";
$payres=$conn->query($paysql);
$payrow=$payres->fetch_assoc();
echo "<br><br>".$payrow['Payamount'];
$paidamount=$payrow['Payamount'];

$retsql="SELECT sum(returnamount) as Retamount FROM `returninvoice` where invoiceid='$invoiceno' and del=1";
$retres=$conn->query($retsql);
$retrow=$retres->fetch_assoc();
echo "<br><br>".$retrow['Retamount'];
$returnedamount=$retrow['Retamount'];

echo "<br><br>".$balance=$amount-$paidamount-$returnedamount;

echo "<br>".$days=$_POST['days'];
$date1 = strtotime($date);
$date3 = date('Y-m-d',$date1);
$duedate2 = strtotime("+".$days." days", strtotime($date3));
$duedate3 = date("Y-m-d", $duedate2);
if($oldinvoice != $invoiceno){
$sql1="SELECT invoice From invoice";
$result1=$conn->query($sql1);
while($row1=$result1->fetch_assoc()) {
if ($invoiceno==$row1['invoice']){

	 header('Location: invoiceedit.php?value=true&invoice='.$oldinvoice);
	exit;
}
}
}

$sql="UPDATE invoice SET agent_code='$agentcode', invoice ='$invoiceno' , actualdate='$date3', party='$party', amount='$amount', balance='$balance',  due_date ='$duedate3',due_days ='$days' Where invoice_id='$invoiceid'";

if ($conn->query($sql) === TRUE) {
    header('Location: invoicelist.php?status=All&agent=All');
} 
}
}
else
{
    header ('location:index.php');
}
?>