<?php 
   require_once 'include/utils/utils.php';
   require_once 'includes/Loader.php';
   vimport ('includes.runtime.EntryPoint');
   require_once 'SUtiles.php';
   @session_start();
   
   $current_user = Users_Record_Model::getCurrentUserModel();
   $roleid = $current_user->get('roleid');
   $userId = $current_user->get('id');
   global $adb;
   
   $res = false;
   
   $idsToDelete = explode(",", $_GET['idsToDelete']);
   
  $query = "UPDATE etat_stock SET grossiste = '".addslashes($_POST["grossiste"])."', date = '".$_POST["date"]."',
            modified_by = '".$userId."', date_modification = NOW() where id = '".$_POST["idEtatStock"]."' " ;
  $res = $adb->pquery($query);
  
  
  
  for ($y = 0; $y < sizeof($_POST["produit"]); $y++) {
  
	  $lot = empty($_POST["lot"][$y]) ? 'null' : '"'.$_POST["lot"][$y].'"';
	  $dper = empty($_POST["dper"][$y]) ? 'null' : '"'.$_POST["dper"][$y].'"';
	  $qte = empty($_POST["qte"][$y]) ? 'null' : '"'.$_POST["qte"][$y].'"';
      
	  //Insert
	  if($_POST["ids"][$y] == 0){
		   $query2 = "INSERT INTO `lignes_etat_stock` (`id_etat_stock` , `produit`, `lot`, `dper`, `qte`)
		   VALUES ('".$_POST["idEtatStock"]."','".addslashes($_POST["produit"][$y])."',".$lot.",".$dper.",".$qte.");";
		   $adb->query($query2);
	  //Update	   
	  }elseif($_POST["ids"][$y] != 0){
		   $query = "UPDATE lignes_etat_stock SET produit = '".addslashes($_POST["produit"][$y])."', lot = ".$lot.",
			dper = ".$dper." , qte = ".$qte." where id = '".$_POST["ids"][$y]."' " ;
		   $adb->pquery($query);
	  }
	}
  
    //Deleted
	  for ($x = 0; $x < sizeof($idsToDelete); $x++) {
		  $query = "DELETE FROM lignes_etat_stock WHERE id = '".$idsToDelete[$x]."'";
		  $adb->pquery($query);
		}

  //Ajax
  if($res == true){
   echo '1';
  }else{
   echo '0';
  }

   
 ?>