<?php


include 'includes/config_tmcpro.php' ;
	include 'includes/stable_functions_tmcpro.php' ;
	
	
	$a= dbi_query("SELECT  DISTINCT(client_id) FROM `chantier` where  ( chantier_debut<= 20220401 AND chantier_fin >=  20220430 ) OR  (chantier_debut<= 20220430  AND chantier_fin = 0 ) OR  (`chantier_debut` LIKE '202204%' AND `chantier_fin` LIKE '202204%' ) OR (chantier_debut<= 20220401 AND ( chantier_fin BETWEEN 20220401 AND 20220431))" );
              
			  
			while ($b=dbi_fetch_row($a))
			{
				list($name) = dbi_fetch_row(dbi_query("SELECT client_nom FROM `client` WHERE `client_id` = ".$b['client_id'])) ; 
				
				
                
                list($jan) = dbi_fetch_row(dbi_query("SELECT total FROM `facture` WHERE `client_id` = ".$b['client_id']." AND date_debut LIKE '202201%'")) ; 				
			    list($feb) = dbi_fetch_row(dbi_query("SELECT total FROM `facture` WHERE `client_id` = ".$b['client_id']." AND date_debut LIKE '202202%'")) ; 
				list($mars) = dbi_fetch_row(dbi_query("SELECT total FROM `facture` WHERE `client_id` = ".$b['client_id']." AND date_debut LIKE '202203%'")) ; 
			   
			    $janh = round($jan/1.2, 2)  ;
				$febh = round($feb/1.2, 2)  ;
				$marsh = round($mars/1.2, 2)  ;
			    echo " ==>  -- ".$b['client_id']." ===".$jan."-- $feb  -- $mars <br/>" ;
				echo " ==>  -- ".$b['client_id']." ===".$janh."-- $febh  -- $marsh <br/>" ;
				
				$som = $janh + $febh + $marsh ; 
				
				$augmetation = round($som  * 0.016 , 2) ;
				// $augmetationn = round($som  * 0.0161 , 2) ;
				
				echo "$augmetation ** $augmetationn <br/>" ; 
				
				$chantier_designation = " <p>Régularisation 1er trimestre suite évolution de la grille des salaires de la propreté au 01/01/2022.</p> " ;
				$chantier_forfaitmensuel = 	$augmetation ; 
				$chantier_TVA = 20 ;
				$chantier_debut = 20220426 ; 
			    $chantier_fin   = 20220426 ;
				$client_id =  $b['client_id'] ;
				$chantier_type_id = 1 ; 
				
				$chantier_ponctuel = 1; 
				
				// dbi_query("INSERT INTO chantier (chantier_designation, chantier_forfaitmensuel,chantier_TVA,chantier_debut,chantier_fin,client_id,chantier_type_id,chantier_ponctuel)
				// VALUES                       ('$chantier_designation', '$chantier_forfaitmensuel','$chantier_TVA','$chantier_debut','$chantier_fin' ,'$client_id','$chantier_type_id','$chantier_ponctuel')") ; 
			
			 $namee = addslashes($name) ; 
			dbi_query("INSERT INTO `augmentat` (`id`, `nom`, `jan`, `feb`, `mars`, `augmen`) VALUES (NULL, '$namee', '$janh', '$febh', '$marsh', '$chantier_forfaitmensuel')") ; 
			exit() ; 
			
			}

?>