1#@!#!123s

��JFIF�� 1#@!#!123s

: / var / www / html / projects / app.eltorofashions.com /

Filename : invoice_save.php

back

<?php
session_start();
if(isset($_SESSION['login'])){
include "main.php"; 
//if(isset($_POST['submit']){
//echo $_POST['username'];
if(isset($_POST['submit'])){
$agentcode=$_POST['agentcode'];
$invoiceno=$_POST['invoiceno'];
$date=$_POST['date'];
$party=addslashes($_POST['party']);
$amount=$_POST['amount'];
$balance=$_POST['amount'];
$days=$_POST['days'];
$date1 = strtotime($date);
$date3 = date('Y-m-d',$date1); 

$duedate2 = strtotime("+".$days." days", strtotime($date3));
$duedate3 = date("Y-m-d", $duedate2);

$sql1="SELECT invoice From invoice";
$result1=$conn->query($sql1);
while($row1=$result1->fetch_assoc()) {
if ($invoiceno==$row1['invoice']){

	 header('Location: create_invoice.php?value=true&code='.$agentcode);
	exit;
}
}

$sql="INSERT INTO invoice (agent_code, invoice, actualdate, party, amount, balance, due_date,due_days, status,del)
VALUES ('$agentcode','$invoiceno','$date3','$party','$amount','$balance' ,'$duedate3','$days','Not paid','1')";
if ($conn->query($sql) === TRUE) {
    header('Location: invoicelist.php?status=All&agent=All');
} 
}
}
else
{
    header ('location:index.php');
}
?>