invisio v2.0

<?php

session_start();
	$empids = $_SESSION['empids'];
	
	ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
	
	$type = $_POST['ptype'];
	$cust = $_POST['client'];
	$pid = $_POST['pid'];
	$special = $_POST['special'];
	$paiddate = $_POST['paiddate'];
	$vats = $_POST['vats'];
	$amount = $_POST['r_cash'];
	$pmode = $_POST['r_mode'];
	$paidto = $_POST['paidto'];
	$payremarks = $_POST['payremarks'];
	$descr = $_POST['descr'];
	
	include("config.php");
			date_default_timezone_set('Asia/Muscat');
 			$de = date('Y-m-d  H:i:s');
			$sno =1;
			$result = $js->query('SELECT * FROM `customer_expense` ORDER BY `id`');
			$result->execute();
			while($row = $result->fetch(PDO::FETCH_ASSOC)) {
				$nw = $row['id']+1;
			}
			
			$sno = 'CUSTEXPFET'.$nw;

if($pmode == 'Cash')
			 {
				$banks = '';
			 }
			 else
			 {
				$banks = $_POST['banks']; 
				
			 }
			 			 
			 $js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			 
			 
			 $sql = $js->prepare('INSERT INTO `customer_expense` (`expid`, `custid`, `paydate`, `payhead`, `paysubhead`, `payamount`, `pmode`, `banks`, `vatstatus`, `premarks`, 				              `paidto`, `pdescription`,  `enteredby`, `addedat`) VALUES (:sno, :cust, :paiddate, :type, :pid, :amount, :pmode, :banks, :vats, :payremarks, :paidto, :descr, :empids, :de)');
			$status = $sql->execute(array(':sno' => $sno,
										':cust' => $cust,
										':paiddate' => $paiddate,
										':type' => $type,
										':pid' => $pid,
										':amount' => $amount,
										':pmode' => $pmode,
										':banks' => $banks,
										':vats' => $vats, 
										':payremarks' => $payremarks,
										':paidto' => $paidto,
										':descr' => $descr,
										':empids' => $empids,
										':de' => $de));
			
			if ($status)
	{
?>
	 <script type="text/javascript">
	alert("Have Successfully Added Expense");
window.open("print_custexpvoucher.php?id=<?php echo $sno?>");
				window.location = 'select_customerexpense.php';	
</script>
<?php 
	}
			
	 ?>