invisio v2.0

<?php
			ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
			session_start();
			$empids = $_SESSION['empids'];
			include("config.php");
			date_default_timezone_set('Asia/Muscat');
 			$de = date('d-m-Y  H:i:s');
			$sno =1;
			$result = $js->query('SELECT * FROM `expenses` ORDER BY `id`');
			$result->execute();
			while($row = $result->fetch(PDO::FETCH_ASSOC)) {
				$nw = $row['id']+1;
			}
			
			$sno = 'EXPFET'.$nw;
			$paiddate = $_POST['paiddate'];
			//$paiddate = date("d-m-Y", strtotime($ii));

$heads = $_POST['heads'];
			 $r_sub = $_POST['r_sub'];
			 if($r_sub == '')
			 {
			 	$r_sub = '';
			 }
			 $r_cash = $_POST['r_cash'];
			 $r_mode = $_POST['r_mode'];
			  if($r_mode == 'Cash')
			 {
				$banks = '';
			 }
			 else
			 {
				$banks = $_POST['banks']; 
				
			 }
			 
			 $vats = $_POST['vats'];
			 $vatpaidto = $_POST['vatpaidto'];
			 $r_remarks = $_POST['r_remarks'];
			 
			 $js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$sql = $js->prepare('INSERT INTO `expenses` (`expid`, `expdate`, `expheads`, `expsubheads`, `expamount`, `pmode`, `banks`, `vatstatus`, `vatpaidto`, `premarks`, `enteredby`, `addedtime`) VALUES (:sno, :paiddate, :heads, :r_sub, :r_cash, :r_mode, :banks, :vats, :vatpaidto, :r_remarks, :empids, :de)');
			$status = $sql->execute(array(':sno' => $sno,
										':paiddate' => $paiddate,
										':heads' => $heads,
										':r_sub' => $r_sub,
										':r_cash' => $r_cash,
										':r_mode' => $r_mode,
										':banks' => $banks,
										':vats' => $vats, 
										':vatpaidto' => $vatpaidto,
										':r_remarks' => $r_remarks,
										':empids' => $empids,
										':de' => $de));
			
			if ($status)
	{
?>
	 <script type="text/javascript">
	alert("Have Successfully Added Expense");
window.open("printexpensevoucher.php?id=<?php echo $nw?>");
				window.location = 'companyexpense.php';	
</script>
<?php 
	}
			
	 ?>