<?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);


                                        $dr_photo =  $_FILES['do_photo']['name'];
                                        if($_FILES['do_photo']['error'] > 0) 
                                        {    
                                           $fgr='';
                                            //echo "<script>alert('no aviyu');</script>";
                                          }else{
                                
                                             // include("compression.php");
                                         $thumb = $_FILES["do_photo"];
                                         $thumb =  $_FILES['do_photo']['name'];
                                         @$thumbpath = "../expense/". $thumb;
                                         move_uploaded_file($_FILES['do_photo']['tmp_name'], @$thumbpath);
                                            // compress($thumbpath, $thumbpath, 90);
                        $fgr = $thumb;
                         }

if(@$_POST["cat_nameb"] != '')
{
  // echo '1';

     $number = count($_POST["cat_nameb"]);  
 if($number > 0)  
 {  
      for($i=0; $i<$number; $i++)  
      {  

          $ex_date1 = $ex_dateb[$i];
          $customer1 = $customerb[$i];
          $vendor1 = $vendorb[$i];

          $amt1 = $amtb[$i];
          $amt_cur1 = $amt_curb[$i];
          $cat_name1 = $cat_nameb[$i];
           
                $sql = "INSERT INTO tbl_expense set ex_date='$ex_date1',cat_name='$cat_name1',amt_cur='$amt_cur1',amt='$amt1',vendor='$vendor1',customer='$customer1'
"; 
       $result = mysqli_query($con, $sql) or die(mysqli_error($con));  
 }  
}
    
 $SQL = "INSERT INTO tbl_expense set ex_date='$ex_date',cat_name='$cat_name',amt_cur='$amt_cur',amt='$amt',vendor='$vendor',invoice='$invoice',ex_desc='$ex_desc',customer='$customer',image='$fgr' 
";
    
          if ($con->query($SQL) === TRUE) {

                        $_SESSION['flash_message'] = 'add';
       
        
       echo "<script>;
                window.location.href='../expense_list.php';
                </script>";

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

}
else
{
  

    
 $SQL = "INSERT INTO tbl_expense set ex_date='$ex_date',cat_name='$cat_name',amt_cur='$amt_cur',amt='$amt',vendor='$vendor',invoice='$invoice',ex_desc='$ex_desc',customer='$customer',image='$fgr' 
";
    
          if ($con->query($SQL) === TRUE) {

                        $_SESSION['flash_message'] = 'add';
       
        
       echo "<script>;
                window.location.href='../expense_list.php';
                </script>";

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

}

  


?>