<?php
include_once 'code/init.php';
// include_once 'function-news.php';
$from = 20130801;
$to = 20130831;


function jour_jouren2($jour,$get)
{
// echo " $jour + $get <br/> ";
	static $presta_jour ;
	$from = $get ;
 $presta_jour = array('nynnnnn' => $get, 'nnynnnn' => date("Ymd", strtotime("+1 day", strtotime($from))), 'nnnynnn' => date("Ymd", strtotime("+2 day", strtotime($from))), 'nnnnynn' => date("Ymd", strtotime("+3 day", strtotime($from))), 'nnnnnyn' => date("Ymd", strtotime("+4 day", strtotime($from))), 'nnnnnny' => date("Ymd", strtotime("+5 day", strtotime($from))), 'ynnnnnn' => date("Ymd", strtotime("+6 day", strtotime($from)))) ;
 return $presta_jour[$jour] ;
}

function get_prest_sem($from ,$to,&$clients)
{
// $rc1 = dbi_query("SELECT client_id FROM ".TABLE_CLIENT." WHERE client_actif='0'  AND client_prospect=1 AND client_genre!='FORMATION' ") ;	
// $inc1='( 0  ';
	// while($cl1 = dbi_fetch_row($rc1))
	// {
			// $inc1.=' , '.$cl1['client_id'];
	// }
// $inc1.=') '	;
$id=0;
$p=array();

$db=debutsem(date('Y', strtotime($from)),date('m', strtotime($from)),date('d', strtotime($from)));
$dbto=debutsem(date('Y', strtotime($to)),date('m', strtotime($to)),date('d', strtotime($to)));
$fin = date("Ymd", strtotime("+6 day", strtotime($dbto)));
while($db < $fin )
	{

$and = date("Ymd", strtotime("+6 day", strtotime($db)));
// echo " $db + $and // ???????";
$presta_jour1 = array('nynnnnn' => '1', 'nnynnnn' => '2', 'nnnynnn' => '3', 'nnnnynn' => '4', 'nnnnnyn' => '5', 'nnnnnny' => '6', 'ynnnnnn' => '0')  ;
$presta_jour2 = array('1' => 'nynnnnn', '2' => 'nnynnnn', '3' => 'nnnynnn', '4' => 'nnnnynn', '5' => 'nnnnnyn', '6' => 'nnnnnny', '0' => 'ynnnnnn')  ;
// echo "!! $db < $from !! ";
if($db < $from && $and > $to)
{
$q2 = dbi_query("SELECT p.* FROM ".TABLE_PREST." p  WHERE presta_date_debut !=0 AND presta_date_debut <= $to AND (p.presta_date_fin >= $from OR p.presta_date_fin IS NULL)  ");
// echo " +++ ";
}
elseif($db < $from)
{
$q2 = dbi_query("SELECT p.* FROM ".TABLE_PREST." p  WHERE presta_date_debut !=0 AND presta_date_debut <= $and AND (p.presta_date_fin >= $from OR p.presta_date_fin IS NULL)  ");
// echo " --- ";
}
elseif($and > $to)
{
$q2 = dbi_query("SELECT p.* FROM ".TABLE_PREST." p  WHERE presta_date_debut !=0 AND presta_date_debut <= $to AND (p.presta_date_fin >= $db OR p.presta_date_fin IS NULL)  ");

// echo " ^^^ ";
}
else
{
$q2 = dbi_query("SELECT p.* FROM ".TABLE_PREST." p  WHERE  presta_date_debut !=0 AND presta_date_debut <= $and AND (p.presta_date_fin >= $db OR p.presta_date_fin IS NULL) ");
// echo " $$$ ";
}
	while($prest = dbi_fetch_row($q2))
	{
	$presta_jour=$prest['presta_jour'];
	if($prest['presta_jour']== 'nnnnnnn' || $prest['presta_jour']== '' || $prest['presta_jour']== NULL )
	$prest['presta_jour']=$presta_jour2[date("w",strtotime($prest['presta_date_fin']))];
	
		$data = array('jour' => $prest['presta_jour'], 'deb' => $prest['presta_Hdeb'], 'duree' => $prest['presta_Hduree'], 'inter' => $prest['inter_id'], 'taux' => $prest['presta_forfait']) ;
		
		$q1 = dbi_query("SELECT * FROM ".TABLE_PRESTA_MODIF." WHERE presta_id = ".$prest['presta_id']." AND start <= $and  order by `start`, `date`") ;
	
		
		while (($m = dbi_fetch_row($q1)) )
		{
				$jour = $m['jour'] === NULL ? $data['jour'] : $m['jour'] ;
				$date=jour_jouren2($jour,$db);
				
				if($date>=$m['start']) {
				$data['jour'] = $m['jour'] === NULL ? $data['jour'] : $m['jour'] ;
				$data['deb'] = $m['Hdeb'] === NULL ? $data['deb'] : $m['Hdeb'] ;
				$data['duree'] = $m['Hduree'] === NULL ? $data['duree'] : $m['Hduree'] ;
				$data['inter'] = $m['inter_id'] === NULL ? $data['inter'] : $m['inter_id'] ;
				$data['taux'] = $m['taux'] === NULL ? $data['taux'] : $m['taux'] ;
				$data['tauxHT'] = $m['tauxHT'] === NULL ? $data['tauxHT'] : $m['tauxHT'] ;
				}
		}
$jour=$data['jour'];
$date=jour_jouren2($jour,$db);
// echo "  $date >= $from  && $date <= $to <br/>";
if( $date >= $from  && $date <= $to && $date >=$prest['presta_date_debut'] && ($date <= $prest['presta_date_fin'] || $prest['presta_date_fin'] == NULL)) {
$heurefin=addDuree($data['deb'],$data['duree']);
$qexcept=dbi_query("SELECT * FROM ".TABLE_EXCEPT." WHERE (date BETWEEN ".$db." AND ".$and.") AND presta_id=".$prest['presta_id']." AND new_presta_id IS NULL ");
	
				
	if($rr = dbi_fetch_row($qexcept)){

	dbi_query("INSERT INTO prest201308 values ('', ".$rr['excpt_id']." ,".$prest['presta_id']." ,	".$date." ,	'".$data['jour']."' ,	".$data['deb']." ,	".$data['duree']." ,	".$heurefin." ,	".$data['duree']." ,	".$prest['client_id']." ,	".$data['inter']." ,	".$prest['agence_id'].")");			
						// $p[] = array(
						// 'id' => $prest['presta_id'],
						// 'excpt_id' => $rr['excpt_id'],
						// 'client_id' => $prest['client_id'],
						// 'agence_id' => $prest['agence_id'],
						// 'nbH' => '',
						// 'taux' => $data['taux'],
						// 'tauxHT' => $data['tauxHT'],
						// 'type' => 'e',
						// 'date' => $date,
						// 'jour' => $data['jour'],
						// 'inter_id' => $data['inter'],
						// 'deb' => $data['deb'],
						// 'typepre' => $prest['presta_recur'],
						// 'duree' => $data['duree'],
						// 'debp' => $prest['presta_date_debut'],
						// 'finp' => $prest['presta_date_fin'],
						// 'presta_jour' => $presta_jour,
						// 'fin' => $heurefin) ;	
						// if (!in_array($prest['client_id'],$clients)) $clients[]=$prest['client_id'];
				

					
			}
						else
			{

					// $p[] = array(
					// 'id' => $prest['presta_id'],
					// 'client_id' => $prest['client_id'],
					// 'nbH' => '',
					// 'taux' => $data['taux'],
					// 'tauxHT' => $data['tauxHT'],
					// 'type' => 'p',
					// 'date' => $date,
					// 'jour' => $data['jour'],
					// 'inter_id' => $data['inter'],
					// 'deb' => $data['deb'],
					// 'typepre' => $prest['presta_recur'],
					// 'duree' => $data['duree'],
					// 'debp' => $prest['presta_date_debut'],
					// 'finp' => $prest['presta_date_fin'],
					// 'presta_jour' => $presta_jour,
					// 'fin' => $heurefin) ;
					
				
			}


			
		}


	}

	$timed=$db;
	$db = date("Ymd", strtotime("+7 day", strtotime($timed)));
	}

	return $p;
	


}


	$clients=array();
	$pre=get_prest_sem( $from,$to ,$clients);
	echo '<pre>';
	print_r($pre);
	echo '</pre>';
	

 
 ?>