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

$allowed_type = array('gif','png','jpg','jpeg');
    
                                        //doctor photo
                                        $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 = "../item/". $thumb;
                                         move_uploaded_file($_FILES['do_photo']['tmp_name'], @$thumbpath);
                                            // compress($thumbpath, $thumbpath, 90);
                        $fgr = $thumb;
                                            
                                     }


 echo $SQL = "INSERT INTO tbl_item set item_type='com',name='$iname',wname='$wname',sku='$sku',unit='$unit',dim_type='$dim_type',dm_l='$l',dm_w='$w',dm_h='$h',manfu='$manfu',upc='$upc',ean='$ean',weight='$wval',w_unit='$wunit',brand='$brand',mpn='$mpn',isbn='$mpn',sale_price='$sale_price',s_account='$s_account',s_description='$s_description',cost_price='$cost_price',  p_account='$p_account',p_description='$p_account',inventory_acc='$inventory_acc',openstock='$openstock',reorderpoint='$reorderpoint',item_stotal='$stotal',item_ctotal='$ctotal',ser_stotal='$sstotal',ser_ctotal='$sctotal',file='$fgr'    ";
    
    
          if ($con->query($SQL) === TRUE) {

             $last_id = $con->insert_id;

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

          $iname = $state[$i];
          $Qty1 = $Qty[$i];
          $price1 = $price[$i];
          $tprice2 = $tprice[$i];
          

           

             $sql = "INSERT INTO tbl_com_item set type='aitem',itemid='$last_id',item_name='$iname',qty='$Qty1',sell_price='$price1',cost_price='$tprice2'";
             $result = mysqli_query($con, $sql) or die(mysqli_error($con));  
           }
         }
       
        
         
       }

       if(@$_POST["sstate"] == '')
{}
else
{
             $number = count($_POST["sstate"]);  
    
 if($number > 0)  
 {  
      for($i=0; $i<$number; $i++)  
      {  

          $iserv = $sstate[$i];
          $sQty1 = $sQty[$i];
          $sprice1 = $sprice[$i];
          $stprice2 = $stprice[$i];
          

          

             $sqls = "INSERT INTO tbl_com_item set type='aiserv',itemid='$last_id',item_name='$iserv',qty='$sQty1',sell_price='$sprice1',cost_price='$stprice2'";
             $results = mysqli_query($con, $sqls) or die(mysqli_error($con));  
           }
         }
       
        
         
       }


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

   }
   else
   {
      echo "<script>;
                window.location.href='../composite_item_list.php?err=false';
                </script>";
   }
  


?>