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

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

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

extract($_POST);

 $bid  = $_GET['id'];

 $sql = "select * from tbl_invoice where id='$bid'";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
$sql_row = mysqli_fetch_assoc($sql_res);
 $fe_img = $sql_row['file'];


 $dr_photo =  $_FILES['do_photo']['name'];
                                                         $fmgg = $fe_img;

 if(strlen($_FILES['do_photo']['name']) != 0) {

                                                   
                                                    $newThumb = $_FILES['do_photo']['name'];
                                                    $thumbPath = "../salesorder/" . $newThumb;
                                                    move_uploaded_file($_FILES['do_photo']['tmp_name'], $thumbPath);
                                                    
                                                    $fmgg = $newThumb;

                                                     unlink("../salesorder/" . $fe_img);
                                                  }




  $SQL = "UPDATE tbl_invoice set cust_name='$cust_name',vehno='$vehno',so_no='$so_no',gst_no='$gst_no',ref_no='$ref_no',so_date='$so_date',ship_date='$ship_date',pay_terms='$pay_terms',sales_person='$sales_person',sub_total='$subtotalval',adjustment='$adjust',total='$totalval',cnote='$cnote',term_con='$term_con',file='$fmgg'";
    
    
       


            if ($con->query($SQL) === TRUE) {

            
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];
          $discount1 = $discount[$i];
          $percen1 = $percen[$i];
          $tprice1 = $tprice[$i];
           $autoi1 = $auto[$i];

           // $last_id = $con->insert_id;

            // $qru = "select * from tbl_item where name='$state1'";
            //     $ress = mysqli_query($con,$qru);                                     
            //     $res1 = mysqli_fetch_assoc($ress);

            //     $qty = $res1['openstock'] - $Qty[$i];
            //       $query = "update tbl_item SET openstock='$qty' where name='$state1'";
            //       $res = mysqli_query($con,$query); 


             $sql = "UPDATE tbl_invo_item set soid='$bid',item_name='$state1',qty='$Qty1',rate='$price1',discount='$discount1',dis_type='$percen1',amt='$tprice1' where id='$autoi1' ";
             $result = mysqli_query($con, $sql) or die(mysqli_error($con));  
           }
         }
       
                   $_SESSION['flash_message'] = 'iedit';
        
       echo "<script>;
                window.location.href='../invoice_list.php';
                </script>";

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


?>