<?php
session_start();
include '../Includes/db.php';
 // include'../compression.php';

// $uid = $_SESSION["userId"];

 date_default_timezone_set('Asia/Kolkata');
 $cudate = date("Y-m-d") ;

extract($_POST);

             
if($itype == 'Tax Invoice'){

$sqlu = "SELECT * FROM `tbl_invoice` where itype='Tax Invoice' ORDER BY id DESC";

    $sql_resu = mysqli_query($con, $sqlu) or die(mysqli_error($con));

     $sql_rowu = mysqli_fetch_array($sql_resu);

             if($sql_rowu['ino'] == '')

     {

      $ino ='01';

     }

     else

     {

              $in = $sql_rowu['ino'] + 1 ;

        $ino = sprintf('%02d', $in);



     }
}
else
{
    $ino = " ";
}

    

$SQL = "INSERT INTO tbl_invoice set name='$name',phno='$phno',cadd='$cadd',pmode='$pmode',type='$type',subtotalval='$subtotalval',cgst='$cgstval',
         sgst='$sgstval',totalval='$totalval',add_date='$cudate',ino='$ino',itype='$itype'";
    
    
             if ($con->query($SQL) === TRUE) {

             $last_id = $con->insert_id;
            
if(@$_POST["state"] == '')
{}
else
{
          echo   $number = count($_POST["state"]);  
    
 if($number > 0)  
 {  
      for($i=0; $i<$number; $i++)  
      {  

          $state1 = $state[$i];
          $Qty1 = $Qty[$i];
          $price1 = $price[$i];
          $hsn1 = $hsn[$i];
          $tprice1 = $tprice[$i];
          $pcs1 = $pcs[$i];
          $huid1 = $huid[$i];
          $gwt1 = $gwt[$i];
          $dwt1 = $dwt[$i];
          $nwt1 = $nwt[$i];
          $lwt1 = $lwt[$i];
          $damt1 = $damt[$i];
          $purity1 = $purity[$i];
          $stone1 = $stone[$i];

          

             $sql = "INSERT INTO tbl_item set invid='$last_id',product='$state1',hsn='$hsn1',qty='$Qty1',rate='$price1',purity='$purity1',huid='$huid1',pcs='$pcs1',gwt='$gwt1',dwt='$dwt1',damt='$damt1',nwt='$nwt1',lwt='$lwt1',stone='$stone1',totalprice='$tprice1' ";
             $result = mysqli_query($con, $sql) or die(mysqli_error($con));  
           }
         }
       
                echo "<script>;
        alert('Data Added Succesfully');
                        window.location.href='../invoice_list.php';
                        </script>";

   }
 }
   else
   {
      echo "<script>;
                window.location.href='../invoice_list.php';
                </script>";
   }
	


?>