invisio v2.0

<?php

session_start();

$empids = $_SESSION['empids'];
include('config.php');
$id = $_POST['id'];
$stats = $_POST['stats'];
$descr = $_POST['descr'];
$amount = $_POST['amount'];
$package = $_POST['package'];
$currency = $_POST['currency'];

$sql1 = $js->prepare('UPDATE customer_entry SET enquirystatus = :stats WHERE id = :id');
			$status1 = $sql1->execute(array(':stats' => $stats,
											':id' => $id));	
											
date_default_timezone_set('Asia/Muscat');
 	$de = date('Y-m-d  H:i:s');
	$entry = date('Y-m-d');
	
	$day = date('d');
	$month = date('m');
	$year = date('Y');
	$pyear = date('y');
	$prevy = $year - 1;
	
	$result = $js->query('SELECT * FROM `invoiced` ORDER BY `id`');
	$result->execute();
	echo $cc = $result->rowCount();
	
	if($cc == '0')
	{
		$invid = 'FET|202223|1110';	
	}
	else
	{
	  while($row = $result->fetch(PDO::FETCH_ASSOC)) 
	  {
		  $nw = $row['invid'];
	  }
	}
	if($cc == '0')
	{
		$invid = 'FET|202223|1110';
	}
	else
	{
		$sub = substr($nw,11);
		$sno = $sub + 1;
		$invid = 'FET|'.$prevy.$pyear.'|'.$sno; 
	}
	
		$sql = $js->prepare('INSERT INTO `invoiced` (`cust`, `invid`, `invdate`, `descr`, `invamount`, `currency`, `package`, `addedby`, `addedat` ) VALUES (:id, :invid, :entry, :descr, :amount, :currency, :package, :empids, :de)');
			$statuss = $sql->execute(array(':id' => $id,
											':invid' => $invid,
											':entry' => $entry, 
											':descr' => $descr,
											':amount' => $amount,
											':currency' => $currency,
											':package' => $package,
											':empids' => $empids,
											':de' => $de)); 
	  
			
?>