|
Server IP : 10.128.40.6 / Your IP : 216.73.216.233 Web Server : Apache System : Linux webd006.cluster128.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : logmcpe ( 111175) PHP Version : 7.3.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/logmcpe/www/TEST/www/../../TMCPRO/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// include 'code/init.php' ;
// 7
include 'includes/config_tmcpro.php' ;
// exit() ;
include 'includes/stable_functions_tmcpro.php' ;
include('file_tache.php');
function convertToHoursMins($time, $format = '%02d:%02d') {
if ($time < 1) {
return;
}
$hours = floor($time / 60);
$minutes = ($time % 60);
return sprintf($format, $hours, $minutes);
}
function count_week_days($__date_from, $__date_to, $__holidays_between=array(), $__weekend_days=array()) {
$total_days_count = $__date_to > $__date_from ? round(($__date_to - $__date_from)/(24*3600)) : 0;
$full_weeks_count = floor($total_days_count/7);
$weekend_days_count = $full_weeks_count*count($__weekend_days);
$days_left_uncovered = $total_days_count - $full_weeks_count*7;
for($i = 0; $i < $days_left_uncovered; $i++) {
$date_to_check = $i ? strtotime("+{$i} day", $__date_from) : $__date_from;
if(in_array(date('N', $date_to_check), $__weekend_days)) {
$weekend_days_count++;
}
}
$week_days_count = $total_days_count - $weekend_days_count - count($__holidays_between);
return $week_days_count;
}
function type_pre_GET ($value =12)
{
$tab = array(10 => 'Viste medicale', 11 => 'Entretien', 12 => 'Autre ');
return $tab[$value] ;
}
// $R=dbi_query("SELECT client_id id, concat(client_nom, ' ', client_pnom) civ, client_prospect, IF(client_genre='SERENA',1,0) as serena, IF(client_genre='FORMATION',1,0) as formation FROM ".TABLE_CLIENT." where agence_id=$agence ".( $_SESSION['client_actif']=='off' ? "" : "AND client_actif='0'")." ");
// $R=dbi_query("SELECT client_id id, concat(client_nom, ' ', client_pnom) civ, client_prospect, IF(client_genre='SERENA',1,0) as serena, IF(client_genre='FORMATION',1,0) as formation FROM ".TABLE_CLIENT." where agence_id=$agence ".( $_SESSION['client_actif']=='off' ? "" : "AND client_actif='0'")." ");
// exit() ;
function daysfr ($value = 0)
{
$tab = array(0 => 'Dimanche', 1 => 'Lundi', 2 => 'Mardi', 3 => 'Mercredi', 4 => 'Jeudi', 5 => 'Vendredi', 6 => 'Samedi');
return $tab[$value];
}
if($_POST['rowid']>0)
{
$id_relance_programee =$_POST['rowid'] ;
}
function daysfr_new ($value = 0)
{
$tab = array('Sun' => 'Dimanche', 'Mon' => 'Lundi', 'Tue' => 'Mardi', 'Wed' => 'Mercredi', 'Thu' => 'Jeudi', 'Fri' => 'Vendredi', 'Sat' => 'Samedi');
return $tab[$value];
}
// $days = daysfr('Mon') ;
// echo $days."<br/>" ;
// exit() ;
function date_prestation_to_jour($dat)
{
$a=int2date_autre_format_deux($dat) ;
$dt = strtotime($a);
$day = date("D", $dt);
$jour=daysfr_new($day) ;
return $jour ;
// return $day ;
}
function debutsem($year,$month,$day) {
$num_day = date('w', mktime(0,0,0,$month,$day,$year));
$premier_jour = mktime(0,0,0, $month,$day-(!$num_day?7:$num_day)+1,$year);
$datedeb = date('Ymd', $premier_jour);
return $datedeb;
}
$R=dbi_query("SELECT client_id id, concat(client_nom) civ FROM client ");
$CLIENTS=array();
while($cl = dbi_fetch_row($R))
{
$CLIENTS []=$cl['id'];
}
function jour_jouren2($jour,$get)
{
static $presta_jour ;
$from = $get ;
$presta_jour = array('1' => $get, '2' => date("Ymd", strtotime("+1 day", strtotime($from))), '3' => date("Ymd", strtotime("+2 day", strtotime($from))), '4' => date("Ymd", strtotime("+3 day", strtotime($from))), '5' => date("Ymd", strtotime("+4 day", strtotime($from))), '6' => date("Ymd", strtotime("+5 day", strtotime($from))), '0' => date("Ymd", strtotime("+6 day", strtotime($from)))) ;
return $presta_jour[$jour] ;
}
if(!empty($_GET['salarie_id']))
{
$_SESSION["salarie_id"]=$_GET['salarie_id'];
}
$cleint_id=$_SESSION["salarie_id"] ;
function get_prest_sem( $interdispo,$from ,$to,$agence,$CLIENTS)
{
$id=0;
$p=array();
// $week_end = $to ;
$salarie_id = $interdispo ;
$data = array();
$now = new DateTime();
$start = $from ;
$end = $to;
// $end = $now -> format('Ymt');
$date = $start ;
$i=0 ;
while ($date <= $end )
{
// $q = dbi_query("
// SELECT * FROM PRESTATIONS p where presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL)
// AND p.presta_id IN ( select presta_id FROM PRESTATIONS_MODIF WHERE salarie_id = $salarie_id )
// ");
$q = dbi_query("
SELECT * FROM PRESTATIONS p where presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL)
AND ( p.presta_id IN (select presta_id FROM PRESTATIONS WHERE salarie_id = $salarie_id ) OR p.presta_id IN ( select presta_id FROM PRESTATIONS_MODIF WHERE salarie_id = $salarie_id ) )
AND ( p.presta_recur IS NULL OR p.presta_recur NOT IN ( SELECT presta_id FROM PRESTATIONS where presta_date_fin < $date ) )
");
// echo "
// SELECT * FROM PRESTATIONS p where presta_date_debut <= $date AND (p.presta_date_fin >= $date OR p.presta_date_fin IS NULL)
// AND (p.presta_id IN (select presta_id FROM PRESTATIONS WHERE salarie_id = $salarie_id ) OR p.presta_id IN ( select presta_id FROM PRESTATIONS_MODIF WHERE salarie_id = $salarie_id ) )
// ".'<br>';
// exit() ;
while($prest = dbi_fetch_row($q))
{
$date_presta_sem = $prest['presta_date_debut'] ;
$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$prest['presta_id']." order by start, modif_id ") ;
while (($m = dbi_fetch_row($q1)) && $date >= $m['start'])
{
if( $m['presta_sem'] != NULL ) $date_presta_sem = $m['start'];
if( $prest['presta_sem'] > 1 ) {
if($m['presta_jour'] !== NULL && $date >= $m['start']) {
$date_presta_sem = $m['start'];
$date_presta_sem = date("Ymd", strtotime('monday this week', strtotime(int2date_autre_format($date_presta_sem))));
}
}
$prest['client_id'] = $m['client_id'] === NULL ? $prest['client_id'] : $m['client_id'] ;
$prest['salarie_id'] = $m['salarie_id'] === NULL ? $prest['salarie_id'] : $m['salarie_id'] ;
$prest['presta_sem'] = $m['presta_sem'] === NULL ? $prest['presta_sem'] : $m['presta_sem'] ;
$prest['presta_jour'] = $m['presta_jour'] === NULL ? $prest['presta_jour'] : $m['presta_jour'] ;
$prest['presta_Hdeb'] = $m['presta_Hdeb'] === NULL ? $prest['presta_Hdeb'] : $m['presta_Hdeb'] ;
$prest['presta_date_debut'] = $m['presta_date_debut'] === NULL ? $prest['presta_date_debut'] : $m['presta_date_debut'] ;
$prest['presta_Hduree'] = $m['presta_Hduree'] === NULL ? $prest['presta_Hduree'] : $m['presta_Hduree'] ;
$prest['chantier_id'] = $m['chantier_id'] === NULL ? $prest['chantier_id'] : $m['chantier_id'] ;
$prest['presta_forfait'] = $m['presta_forfait'] === NULL ? $prest['presta_forfait'] : $m['presta_forfait'] ;
}
if( $prest['salarie_id'] == $salarie_id ) {
// if($date == '20200806')
// echo $prest["presta_id"].' ** ';
$day = date("w", strtotime( int2date_autre_format($date)));
// if( $day == $prest['presta_jour']){
if( $day == $prest['presta_jour'] OR ( $date == $prest['presta_date_debut'] && $prest['presta_date_debut'] == $prest['presta_date_fin'] ) ){
// $istart = str_pad($prest['presta_Hdeb'] / 10000 , 2, '0', STR_PAD_LEFT) ;
$hstart = str_pad((int)($prest['presta_Hdeb'] / 10000) , 2, '0', STR_PAD_LEFT) ;
// $hstart = str_pad(round($prest['presta_Hdeb'] / 10000, 0) , 2, '0', STR_PAD_LEFT) ;
$mstart = str_pad(($prest['presta_Hdeb'] % 10000)/100 , 2, '0', STR_PAD_LEFT);
$hend = str_pad(round(addDuree($prest['presta_Hdeb'], $prest['presta_Hduree']) / 10000, 0) , 2, '0', STR_PAD_LEFT) ;
$mend = str_pad((addDuree($prest['presta_Hdeb'], $prest['presta_Hduree']) % 10000)/100 , 2, '0', STR_PAD_LEFT);
$istart = int2date_autre_format($date).' '.$hstart.':'.$mstart.':00';
$iend = int2date_autre_format($date).' '.$hend.':'.$mend.':00';
$EXP = dbi_fetch_row(dbi_query("SELECT date_presta FROM EXCEPTIONS WHERE presta_id = ".$prest['presta_id']." AND date_presta = ".$date." " )) ; ;
if($EXP ){} else {
if( $prest['presta_sem'] == 1 )
{
$Clt = dbi_fetch_row(dbi_query("SELECT * FROM client WHERE client_id = ".$prest['client_id'] ." " )) ;
$data[$i]['presta_id'] = $prest["presta_id"];
$data[$i]['client_id'] = $prest["client_id"];
$data[$i]['presta_Hdeb'] = $prest["presta_Hdeb"];
$data[$i]['presta_Hduree'] = $prest["presta_Hduree"];
$data[$i]['presta_jour'] = $prest["presta_jour"];
$data[$i]['presta_date_debut'] = $prest["presta_date_debut"];
if($prest['client_id'] == $TMCPROCLIENTID)
$data[$i]['title'] = '('. convertToHoursMins($prest['presta_Hduree'], '%01dh%02d').") ".$prest['prestation_motif'];
else
$data[$i]['title'] = '('. convertToHoursMins($prest['presta_Hduree'], '%01dh%02d').") ".$Clt["client_nom"];
// $data[$i]['title'] = '('. convertToHoursMins($prest['presta_Hduree'], '%01dh%02d').") ".$Clt["client_nom"];
$data[$i]['start'] = $istart;
$data[$i]['end'] = $iend;
$data[$i]['date'] = $date;
++$i;
}
else
{
$nbre =count_week_days(strtotime(int2date_autre_format($date_presta_sem,'d.m.Y')), strtotime(int2date_autre_format($date,'d.m.Y')));
$modolo = $nbre % $prest['presta_sem'] ;
if( $modolo == 0) {
$Clt = dbi_fetch_row(dbi_query("SELECT * FROM client WHERE client_id = ".$prest['client_id'] ." " )) ;
$data[$i]['presta_id'] = $prest["presta_id"];
$data[$i]['client_id'] = $prest["client_id"];
$data[$i]['presta_Hdeb'] = $prest["presta_Hdeb"];
$data[$i]['presta_Hduree'] = $prest["presta_Hduree"];
$data[$i]['presta_jour'] = $prest["presta_jour"];
if($prest['client_id'] == $TMCPROCLIENTID)
$data[$i]['title'] = '('. convertToHoursMins($prest['presta_Hduree'], '%01dh%02d').") ".$prest['prestation_motif'];
else
$data[$i]['title'] = '('. convertToHoursMins($prest['presta_Hduree'], '%01dh%02d').") ".$Clt["client_nom"];
$data[$i]['start'] = $istart;
$data[$i]['end'] = $iend;
$data[$i]['date'] = $date;
++$i;
}
}
}
}
}
// echo date("Ymd", strtotime( int2date_autre_format($date))).' !! '.$prest['presta_id'].' $$ '.$prest['presta_jour'].'<br>';
}
// $date = time2int($time) ;
$date = date("Ymd", strtotime("+1 day", strtotime($date)));
}
// $presta_Hduree /= 60 ;
// echo "=ddddfyyyy===> $presta_Hduree <br/>" ;
// echo '<pre>';
// print_r($data);
// echo '</pre>';
/*
exit() ;
// echo "===> rr <br/>" ;
$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)));
echo " ---> $db /ssssss/ $and <br/> ";
$fin=date('Ymd',int2time($dbto)+6*24*3600 );
while($db < $fin )
{
$and = date('Ymd',int2time($db)+6*24*3600 );
$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') ;
$q2 = dbi_query("SELECT p.* FROM PRESTATIONS p, client c WHERE p.client_id=c.client_id AND ((presta_date_debut <= $db) OR (presta_jour = 'nnnnnnn' OR presta_jour is NULL)) AND presta_date_debut < $and AND (p.presta_date_fin >= $db OR p.presta_date_fin >= $and OR p.presta_date_fin IS NULL) ");
// $q2 = dbi_query("SELECT p.* FROM ".TABLE_PREST." p, ".TABLE_CLIENT." c WHERE p.client_id=c.client_id and p.agence_id=$agence AND presta_date_debut <= $and AND (p.presta_date_fin >= $db OR p.presta_date_fin IS NULL) ");
// $q2 = dbi_query("SELECT * FROM ".TABLE_PREST." p where p.client_id=".$clien['client_id']." AND p.agence_id=$agence AND presta_date_debut < $to AND (p.presta_date_fin >= $from OR p.presta_date_fin >= $to OR p.presta_date_fin IS NULL) ");
while($prest = dbi_fetch_row($q2))
{
if($prest['presta_jour']== 'nnnnnnn' || $prest['presta_jour']== '' || $prest['presta_jour']== NULL )
$prest['presta_jour']=$presta_jour2[date("w",strtotime($prest['presta_date_fin']))];
// echo "===============FFFFFFFFFFF===>".$prest['presta_jour']."<br/>" ;
$data = array('jour' => $prest['presta_jour'], 'deb' => $prest['presta_Hdeb'], 'duree' => $prest['presta_Hduree'], 'inter' => $prest['salarie_id'], 'taux' => $prest['presta_forfait']) ;
// $q1 = dbi_query("SELECT * FROM ".TABLE_PRESTA_MODIF." WHERE presta_id = ".$prest['presta_id']." order by `start`, `date`") ;
$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$prest['presta_id']." AND start <= $and order by `start`, `date`") ;
// echo " ---> $db - KKKKK OOOPPPPP - $and <br/> ";
// echo $prest['presta_jour'].' !! ';
while (($m = dbi_fetch_row($q1)) )
{
$jour = $m['presta_jour'] === NULL ? $data['jour'] : $m['presta_jour'] ;
$date=jour_jouren2($jour,$db);
if($date>=$m['start']) {
// if($m['start'] <= $to)
// {
$data['jour'] = $m['jour'] === NULL ? $data['jour'] : $m['jour'] ;
$data['deb'] = $m['Hdeb'] === NULL ? $data['deb'] : $m['Hdeb'] ;
$data['duree'] = $m['presta_Hduree'] === NULL ? $data['duree'] : $m['presta_Hduree'] ;
$data['inter'] = $m['salarie_id'] === NULL ? $data['inter'] : $m['salarie_id'] ;
$data['taux'] = $m['taux'] === NULL ? $data['taux'] : $m['taux'] ;
}
}
$jour=$data['jour'];
if ($data['inter']==$interdispo)
{
$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']." ");
if($rr = dbi_fetch_row($qexcept)){
}
else{
if (in_array($prest['client_id'], $CLIENTS))
{
echo "!kk! ".$jour." / $db !! <br/>";
$presta=array("presta_id" => $prest['presta_id'],"presta_desc" => $prest['presta_desc'] , "presta_date_debut" => $prest['presta_date_debut'] , "presta_Hdeb" => $data['deb'] , "presta_Hduree" => $data['duree'] , "presta_recur" => $prest['presta_recur'] , "presta_date_fin" => $prest['presta_date_fin'] , "presta_jour" => $jour , "presta_forfait" => $prest['presta_jour'] , "presta_forfaitHT" => $prest['presta_forfaitHT'], "presta_status" => $prest['presta_status'] , "presta_sem" => $prest['presta_sem'] , "client_id" => $prest['client_id'] , "inter_id" => $data['inter'] , "agence_id" => $prest['agence_id'], "date" => jour_jouren2($jour,$db));
$p[$id]= $presta;
++$id;
}
}
}
}
$db = time2int(add_day(int2time($db),7) );
}*/
return $data;
}
$salarie_idd=$_SESSION["salarie_id"] ;
$salarie_id=$_SESSION["salarie_id"] ;
// I suppose you already have the php variables filled in. Whether it is static information or data from the database. Name your variables according to the names contained in the file template.htm
// I capture and store the content of the template.htm file
// I suppose you already have the php variables filled in. Whether it is static information or data from the database. Name your variables according to the names contained in the file template.htm
// I capture and store the content of the template.htm file
// chmod("contrat/contrat51.doc",0777);
// unlink("contrat/contrat51.doc");
// echo "test<br/>" ;
// exit() ;
if(!empty($_POST['annexe_CDD']))
{
$salarie_contrat_id = $_POST['salarie_contrat_id'] ;
// echo "===>".$salarie_contrat_id."<br/>" ;
// exit() ;
list($salarie_contrat_date_debut , $salarie_contrat_date_fin ) = dbi_fetch_row(dbi_query("SELECT salarie_contrat_date_debut , salarie_contrat_date_fin FROM `salarie_contrat` WHERE salarie_contrat_id = $salarie_contrat_id ")) ;
$pre=get_prest_sem( $salarie_id ,$salarie_contrat_date_debut,$salarie_contrat_date_fin ,47,$CLIENTS);
print_r($_POST['inter']);
// echo " $from ++++++++ $to ";
// echo '<pre>';
// print_r($_POST);
// echo '</pre>' ;
$taille=count($pre) ;
// echo "===>".$taille."<br/>" ;
for ($i=0 ; $i<$taille ; $i++){
list($client_nom) = dbi_fetch_row(dbi_query("SELECT client_nom FROM `client` WHERE `client_id` = ".$pre[$i]['client_id'] )) ;
// $desc = daysfr($pre[$i]['presta_jour'])." de ".int2heure($pre[$i]['presta_Hdeb'])." à <strong> ".int2heure(addDuree($pre[$i]['presta_Hdeb'], $pre[$i]['presta_Hduree']) )." : ".$client_nom." (".int2date($pre[$i]['date']).") " ;
// dbi_query("INSERT INTO `annexe_trie_CDD` (`id`, `jour`, `description` , presta_id,date_prestation ,client_id) VALUES (NULL, '".$pre[$i]['presta_jour']."', '".addslashes($desc)."' ,'".$pre[$i]['presta_id']."','".$pre[$i]['date']."','".$pre[$i]['client_id']."')") ;
$desc = "<strong>".date_prestation_to_jour($pre[$i]['date'])." ".int2date($pre[$i]['date'])." </strong> de ".int2heure($pre[$i]['presta_Hdeb'])." à ".int2heure(addDuree($pre[$i]['presta_Hdeb'], $pre[$i]['presta_Hduree']) )." : ".$client_nom ;
if($pre[$i]['date']>= $salarie_contrat_date_debut AND $pre[$i]['date'] <= $salarie_contrat_date_fin ){
dbi_query("INSERT INTO `annexe_trie_CDD` (`id`, `jour`, `description` , presta_id,date_prestation, client_id ) VALUES (NULL, '".$pre[$i]['presta_jour']."', '".addslashes($desc)."' ,'".$pre[$i]['presta_id']."','".$pre[$i]['date']."' ,'".$pre[$i]['client_id']."' )") ;
}
}
$op = count($_POST['id']) ;
// echo "=ssssssssssssssssss=>".$op."<br/>" ;
// exit() ;
for ($i=0 ; $i<$op ; $i++){
// echo " AA ==>".$_POST[$i]['id'].'<br/>' ;
// echo " AA ==>".$_POST[]['id'].'<br/>' ;
list($description,$client_id)= dbi_fetch_row(dbi_query("SELECT description , client_id FROM annexe_trie_CDD WHERE id = ".$_POST['id'][$i]." ORDER BY jour , presta_Hdeb ASC")) ;
list($client_nom ,$client_adr1 ,$client_adr2,$client_adr3 , $client_ville , $client_cp ) = dbi_fetch_row(dbi_query("SELECT client_nom , client_adr1 , client_adr2,client_adr3 ,client_ville , client_cp FROM `client` WHERE `client_id` = ".$client_id )) ;
// echo " ==>".$description."<br/>" ;
$list_prestation .= " ".$description." ".$client_adr1." ".$client_adr2." ".$client_adr3." ".$client_cp." ".$client_ville."<br/>";
}
// exit() ;
dbi_query("TRUNCATE TABLE annexe_trie_CDD ") ;
// echo $list_prestation ;
// exit() ;
header("Content-type: application/vnd.ms-word");
if(!empty(file_get_contents ( "annexe/annexe_cdd.html" )))
{
if($_POST['annexe_ach_remplacement'] == "annexe_ach_remplacement"){
header("Content-Disposition: attachment; Filename=annexe_ach_remplacement.doc");
$content = file_get_contents ( "annexe/annexe_ach_remplacement.html" );
}
elseif($_POST['annexe_ach_accr'] == "annexe_ach_accr"){
header("Content-Disposition: attachment; Filename=annexe_ach_accro.doc");
$content = file_get_contents ( "annexe/annexe_ach_accro.html" );
}
else
{
header("Content-Disposition: attachment; Filename=Annexe_CDD.doc");
$content = file_get_contents ( "annexe/annexe_cdd.html" );
}
$content = str_replace ( 'list_prestation' , $list_prestation , $content );
echo $content;
}
}
if(!empty($_POST['annexe']))
{
$long=count($_POST['presta_id']) ;
// echo "ddddddddd==>".$long."<br/>" ;
// exit() ;
// echo "ddddddddddddddddddddddddddddddddd <br/>" ;
// echo "yyy <br/>" ;
for ($i=0 ; $i<$long ; $i++){
// echo "xxx <br/>" ;
$q = dbi_query(" SELECT * FROM PRESTATIONS p where presta_id = ".$_POST['presta_id'][$i]." and `presta_date_fin` IS NULL" );
while($prest = dbi_fetch_row($q))
{
$date_presta_sem = $prest['presta_date_debut'] ;
$q1 = dbi_query("SELECT * FROM PRESTATIONS_MODIF WHERE presta_id = ".$prest['presta_id']." order by start, modif_id ") ;
// while (($m = dbi_fetch_row($q1)) && $date >= $m['start'])
while (($m = dbi_fetch_row($q1)))
{
if( $m['presta_sem'] != NULL ) $date_presta_sem = $m['start'];
$prest['salarie_id'] = $m['salarie_id'] === NULL ? $prest['salarie_id'] : $m['salarie_id'] ;
$prest['presta_sem'] = $m['presta_sem'] === NULL ? $prest['presta_sem'] : $m['presta_sem'] ;
$prest['presta_jour'] = $m['presta_jour'] === NULL ? $prest['presta_jour'] : $m['presta_jour'] ;
$prest['presta_Hdeb'] = $m['presta_Hdeb'] === NULL ? $prest['presta_Hdeb'] : $m['presta_Hdeb'] ;
$prest['presta_Hduree'] = $m['presta_Hduree'] === NULL ? $prest['presta_Hduree'] : $m['presta_Hduree'] ;
}
if( $prest['salarie_id'] == $salarie_id ) {
$b[] = $prest ;
}
}
}
// echo "<pre>" ;
// print_r($b) ;
// echo "</pre>" ;
$taillee = count($b) ;
for ($i=0 ; $i<$taillee ; $i++){
list($client_nom ,$client_adr1 ,$client_adr2,$client_adr3 , $client_ville , $client_cp ) = dbi_fetch_row(dbi_query("SELECT client_nom , client_adr1 , client_adr2 ,client_adr3 , client_ville , client_cp FROM `client` WHERE `client_id` = ".$b[$i]['client_id'] )) ;
$line[$i] = daysfr($b[$i]['presta_jour'])." de <strong> ".int2heure($b[$i]['presta_Hdeb'])." à ".int2heure(addDuree($b[$i]['presta_Hdeb'], $b[$i]['presta_Hduree']) )." </strong> : ".$client_nom." ".$client_adr1." ".$client_adr2." ".$client_adr3." ".$client_cp." ".$client_ville."<br/>";
}
print_r($line) ;
dbi_query("TRUNCATE TABLE annexe_trie ") ;
// exit() ;
header("Content-type: application/vnd.ms-word");
header("Content-Disposition: attachment; Filename=Annexe.doc");
// echo file_get_contents("annexe_cdi.html");
if(!empty(file_get_contents ( "annexe/annexe_cdi.html" )))
{
// $line_0 = "test" ;
// $line_1 = "test 2 " ;
// $line_2 = "mecredi" ;
// $line_3 = "jeudi" ;
// $line_4 = "vendredi" ;
// $line_6 = "Samedi" ;
// $line_7 = "dimanche" ;
// $line_8 = "sam";
// $line_9 = "lundi_2" ;
// echo file_get_contents("annexe_cdi.html");
$content = file_get_contents ( "annexe/annexe_cdi.html" );
$content = str_replace ( '$line[0]' , $line[0] , $content );
$content = str_replace ( '$line[1]' , $line[1] , $content );
$content = str_replace ( '$line[2]' , $line[2] , $content );
$content = str_replace ( '$line[3]' , $line[3] , $content );
$content = str_replace ( '$line[4]' , $line[4] , $content );
$content = str_replace ( '$line[5]' , $line[5] , $content );
$content = str_replace ( '$line[6]' , $line[6] , $content );
$content = str_replace ( '$line[7]' , $line[7] , $content );
$content = str_replace ( '$line[8]' , $line[8] , $content );
$content = str_replace ( '$line[9]' , $line[9] , $content );
$content = str_replace ( '$line[10]' , $line[10] , $content );
$content = str_replace ( '$line[11]' , $line[11] , $content );
$content = str_replace ( '$line[12]' , $line[12] , $content );
$content = str_replace ( '$line[13]' , $line[13] , $content );
$content = str_replace ( '$line[14]' , $line[14] , $content );
$content = str_replace ( '$line[15]' , $line[15] , $content );
echo $content;
}
}
$q_con = dbi_query("SELECT * FROM `salarie_contrat` WHERE `salarie_id` =".$salarie_id );
// echo "SELECT * FROM `salarie_contrat` WHERE `salarie_id` =".$salarie_id ;
// for($i=0 ; $i<3 ; $i++)
while($cl_q_con=dbi_fetch_row($q_con))
{
// echo " => ".$cl_q_con['salarie_contrat_date_debut']."<br/>" ;
if($cl_q_con['contrat_type_id'] == 1)
{
$content = file_get_contents ( "file/template.htm" );
}
if($cl_q_con['contrat_type_id'] == 2)
{
$content = file_get_contents ( "file/templatedeux.htm" );
}
if($cl_q_con['contrat_type_id'] == 3)
{
$content = file_get_contents ( "file/templatetrois.htm" );
}
if($cl_q_con['contrat_type_id'] == 4)
{
$content = file_get_contents ( "file/CDD_ACCR_ACTIVITE.htm" );
// echo "test <br/>" ;
// exit() ;
}
if($cl_q_con['contrat_type_id'] == 10)
{
$content = file_get_contents ( "file/ACH_ACCR_ACTIVITE.htm" );
// echo "test <br/>" ;
// exit() ;
}
// echo "===>".$cl_q_con['contrat_type_id']."<br/>" ;
if($cl_q_con['contrat_type_id'] == 11)
{
// echo "test <br/>" ;
// exit() ;
$content = file_get_contents ("file/ACH_REMPLACEMENT.htm");
}
if($cl_q_con['contrat_type_id'] == 17)
{
$content = file_get_contents ("file/avenant_duree.htm");
}
if($cl_q_con['contrat_type_id'] == 6)
{
$content = file_get_contents ( "file/CDD_REMPLACEMENT.htm" );
// echo "test <br/>" ;
// exit() ;
}
if(!empty($cl_q_con['info_contrat_id']))
{
list($salarie_contrat_date_signatureee , $salarie_contrat_duree_mensuelleee,$contrat_type_id )=dbi_fetch_row(dbi_query("SELECT salarie_contrat_date_signature, salarie_contrat_duree_mensuelle,contrat_type_id FROM `salarie_contrat` WHERE `salarie_contrat_id` = ".$cl_q_con['info_contrat_id'])) ;
if($contrat_type_id== 1)
$contra_typee="le CDI" ;
else
$contra_typee="l'avenant" ;
$content = str_replace ( '$contra_typee' , $contra_typee , $content );
$salarie_contrat_date_signatureee = int2date($salarie_contrat_date_signatureee) ;
$content = str_replace ( '$salarie_contrat_date_signatureee' , $salarie_contrat_date_signatureee , $content );
$content = str_replace ( '$salarie_contrat_duree_mensuelleee' , $salarie_contrat_duree_mensuelleee , $content );
}
// Attention to the path to the template file. here it is in the same directory as export.php otherwise give the correct path.
// Now, I replace the variables one by one. Tedious method but "Cameroon is hot, we will do how". Will optimize with experience
$q_salar= dbi_fetch_row( dbi_query("SELECT * FROM `salarie` s ,etablissement e where s.etablissement_id=e.etablissement_id and salarie_id = ".$salarie_id)) ;
$titrefacture="tttt";
// echo "==> ".$q_salar['salarie_nom'] ;
$salarienom= $q_salar['salarie_nom'];
$salarieprenom= $q_salar['salarie_prenom'];
$salarie_nom_naissance= $q_salar['salarie_nom_naissance'];
$info_siege=dbi_fetch_row(dbi_query( "SELECT * FROM `etablissement` WHERE `etablissement_type_id` = 1 "));
$adresS = $info_siege['etablissement_adr1']." ".$info_siege['etablissement_adr2']." ".$info_siege['etablissement_adr3']. " ".$info_siege['etablissement_cp']." ".$info_siege['etablissement_ville'] ;
// echo "==> $adresS <br/> " ;
// exit() ;
// $adresS=strtoupper($adresS) ;
// $etablissement_SIREN = $info_siege['etablissement_SIREN'] ;
$etablissement_code_APE = $info_siege['etablissement_code_APE'] ;
$etablissement_SIREN = $info_siege['etablissement_SIREN'] ;
$representant = $info_siege['etablissement_Prenom']. " ".$info_siege['etablissement_Nom_represnt'] ;
$etablissement_Qualite = $info_siege['etablissement_Qualite'] ;
// mb_detect_encoding($etablissement_Qualite , 'UTF-8');
// echo "====> $etablissement_Qualite <br/> " ;
// exit();
// $etablissement_Qualite = "Gérant" ;
// $etablissement_Qualite =
// echo "====> $representant <br/> " ;
// echo "====> $etablissement_code_APE <br/> " ;
// echo "====> $etablissement_SIREN <br/> " ;
// echo "====> $adresS <br/> " ;
$content = str_replace ( '$adresS' , $adresS , $content );
$content = str_replace ( '$etablissement_SIREN' , $etablissement_SIREN , $content );
$content = str_replace ( '$etablissement_code_APE' , $etablissement_code_APE , $content );
$content = str_replace ( '$representant' , $representant , $content );
$content = str_replace ( '$etablissement_Qualite' , $etablissement_Qualite , $content );
// exit() ;
list($organisme_retarait,$organisme_retarait_adr,$organisme_prevoyance,$organisme_prevoyance_adr,$nom_mutuelle,$numero_contrat) = dbi_fetch_row(dbi_query("SELECT organisme_retarait,organisme_retarait_adr,organisme_prevoyance,organisme_prevoyance_adr,nom_mutuelle,numero_contrat FROM `avantage_sociaux`")) ;
$retarait_info = $organisme_retarait." ".$organisme_retarait_adr ;
$prevoyance_info = $organisme_prevoyance." ".$organisme_prevoyance_adr ;
// $mutuelle_iknfo = $nom_mutuelle." ".$numero_contrat ;
$content = str_replace ( '$retarait_info' , $retarait_info , $content );
$content = str_replace ( '$prevoyance_info' , $prevoyance_info , $content );
$content = str_replace ( '$nom_mutuelle' , $nom_mutuelle , $content );
$content = str_replace ( '$numero_contrat' , $numero_contrat , $content );
$chaine_sal_nom = $salarienom." ".$salarieprenom ;
$content = str_replace ( '$chaine_sal_nom' , $chaine_sal_nom , $content );
$salariedatenaissance= int2date($q_salar['salarie_date_naissance']);
$salarie_date_anciennete = $q_salar['salarie_date_anciennete'] ;
$todayyy=date('Ymd') ;
// echo "$todayyy===>".$salarie_date_anciennete."<br/>" ;
// echo "==>".$cl_q_con['salarie_contrat_date_debut']."<br/>" ;
// exit() ;
// exit() ;
if($salarie_date_anciennete >= $cl_q_con['salarie_contrat_date_debut']){
$article_un_p_deux = "Le salarié signataire déclare ne pas avoir travaillé dans une
entreprise de propreté depuis au moins 12 mois et en conséquence ne pas avoir
d’expérience professionnelle lors de son embauche qui puisse être retenue pour
l’attribution de la prime d’expérience " ;
// echo "bbb <br/>" ;
}else {
$firstDate = int2date_autre_format($salarie_date_anciennete) ;
$secondDate = int2date_autre_format($cl_q_con['salarie_contrat_date_debut']) ;
$dateDifference = abs(strtotime($secondDate) - strtotime($firstDate));
$years = floor($dateDifference / (365 * 60 * 60 * 24));
$months = floor(($dateDifference - $years * 365 * 60 * 60 * 24) / (30 * 60 * 60 * 24));
$days = floor(($dateDifference - $years * 365 * 60 * 60 * 24 - $months * 30 * 60 * 60 *24) / (60 * 60 * 24));
$ch_y =$years." ans et ".$months." mois " ;
// echo "===>".$nbmonth."<br/>" ;
$article_un_p_deux = "Il est reconnu au salarié signataire
".$ch_y." d'expérience professionnelle
à partir des certificats transmis par lui-même pour l'attribution
de la prime d'expérience " ;
}
// exit() ;
$salarie_nationalite= $q_salar['salarie_nationalite'];
// echo " ==> $salarie_nationalite <br/>" ;
$content = str_replace ( '$salarie_nationalite' , $salarie_nationalite , $content );
// exit() ;
// $Demeurant = $q_salar['salarie_adr1']." <br/>".$q_salar['salarie_adr2']." <br/>".$q_salar['salarie_cp']." <br/> ".$q_salar['salarie_ville'] ;
// $Demeurant = ." <br/>".$q_salar['salarie_adr2']." <br/>".$q_salar['salarie_cp']." <br/> ".$q_salar['salarie_ville'] ;
$salarie_contrat_Motif_absence=$q_salar['salarie_contrat_Motif_absence'] ;
$content = str_replace ( '$salarie_contrat_Motif_absence' , $salarie_contrat_Motif_absence , $content );
$etablissement_nom=$q_salar['etablissement_nom'] ;
$content = str_replace ( '$etablissement_nom' , $etablissement_nom , $content );
$salarieadr1=$q_salar['salarie_adr1'] ;
$content = str_replace ( '$salarieadr1' , $salarieadr1 , $content );
$salarieadr2=$q_salar['salarie_adr2']." ".$q_salar['salarie_adr3'] ;
$content = str_replace ( '$salarieadr2' , $salarieadr2 , $content );
$salariecp=$q_salar['salarie_cp'] ;
$content = str_replace ( '$salariecp' , $salariecp , $content );
list($salariecategoriedesignation , $salariecategoriedesignationcourt)=dbi_fetch_row(dbi_query("SELECT salarie_categorie_designation , salarie_categorie_designation_court FROM `salarie_categorie` WHERE `salarie_categorie_id` =".$q_salar['salarie_categorie_id'])) ;
$content = str_replace ( '$salariecategoriedesignation' , $salariecategoriedesignation , $content );
// list($salarie_horaire) =dbi_fetch_row(dbi_query("SELECT * FROM `grille_salarie` WHERE `salarie_categorie_id` = ".$q_salar['salarie_categorie_id']." AND `position_ID` = ".$q_salar['salarie_position']." AND `echelon` = ".$q_salar['salarie_echelon'] )) ;
// $content = str_replace ( '$salarie_horaire' , $salarie_horaire , $content );
if($q_salar['salarie_categorie_id'] > 4 )
{
$salarieechelon= "" ;
$aa= $salariecategoriedesignationcourt ;
}
else{
$salarieechelon= "échelon ".$q_salar['salarie_echelon'] ;
$aa= $salariecategoriedesignationcourt."".$q_salar['salarie_echelon'] ;
}
$content = str_replace ( '$aa' , $aa , $content );
$content = str_replace ( '$salarieechelon' , $salarieechelon , $content );
list($salarieposition ) = dbi_fetch_row(dbi_query(" SELECT Position FROM `position` WHERE `position_ID` = ".$q_salar['salarie_position'])) ;
;
$content = str_replace ( '$salarieposition' , $salarieposition , $content );
// $salarieposition=$q_salar['salarie_categorie_designation_court'] ;
// $content = str_replace ( '$salarieposition' , $salarieposition , $content );
// ki
// echo "==> ".$salariecategoriedesignationcourt."<br/>" ;
// exit() ;
$salarieville=$q_salar['salarie_ville'] ;
$content = str_replace ( '$salarieville' , $salarieville , $content );
$salariecontratexperience=$cl_q_con['salarie_contrat_experience'] ;
$content = str_replace ( '$salariecontratexperience' , $salariecontratexperience , $content );
$salarie_genre=$q_salar['salarie_genre'] ;
if($salarie_genre == 1)
{
$salariegenre = "Monsieur" ;
}
else
{
$salariegenre = "Madame" ;
}
$content = str_replace ( '$salariegenre' , $salariegenre , $content );
$documents_fournis_id=$q_salar['documents_fournis_id'] ;
list($type_document)= dbi_fetch_row( dbi_query("SELECT type_document FROM `Documents_Fournis` WHERE `documents_fournis_id` = ".$q_salar['documents_fournis_id'])) ;
$content = str_replace ( '$type_document' , $type_document , $content );
// $salarievillenaissance= $q_salar['salarie_ville_naissance'];
$Vnenaissance=$q_salar['salarie_ville_naissance'] ;
$content = str_replace ( '$Vnenaissance' , $Vnenaissance , $content );
$salariepaysnaissance= $q_salar['salarie_pays_naissance'];
$salarienationalite= $q_salar['salarie_nationalite'];
$content = str_replace ( '$salarienationalite' , $salarienationalite , $content );
$salariedocumentnumero= $q_salar['salarie_document_numero'];
$salariedocumentdatevalidite= int2date($q_salar['salarie_document_date_validite']);
if(!empty($q_salar['salarie_numero_secu']))
{
$salarienumerosecu = $q_salar['salarie_numero_secu'];
}
else
{
$salarienumerosecu ="non immatriculé(e)" ;
}
list($etablissementnumurssaf ,$etablissement_zone_mobilite , $etablissementnom , $etablissement_ville )= dbi_fetch_row( dbi_query("SELECT etablissement_URSSAF ,etablissement_zone_mobilite, etablissement_nom,etablissement_ville FROM `etablissement` where etablissement_id = ".$q_salar['etablissement_id'])) ;
$etablissementnumurssaf = $etablissementnumurssaf."(".$etablissement_ville.")" ;
$content = str_replace ( '$etablissement_ville' , $etablissement_ville , $content );
$content = str_replace ( '$etablissementnom' , $etablissementnom , $content );
$content = str_replace ( '$etablissementnumurssaf' , $etablissementnumurssaf , $content );
$content = str_replace ( '$article_un_p_deux' , $article_un_p_deux , $content );
$salarieid_debut="0".$q_salar['salarie_id']."*" ;
$salarieid_fin="0".$q_salar['salarie_id']."#" ;
$content = str_replace ( '$salarieid_debut' , $salarieid_debut , $content );
$content = str_replace ( '$salarieid_fin' , $salarieid_fin , $content );
$salariecontratdatesignature= int2date($cl_q_con['salarie_contrat_date_signature']) ;
$content = str_replace ( '$salariecontratdatesignature' , $salariecontratdatesignature , $content );
list($contratsignatairenom )= dbi_fetch_row( dbi_query("SELECT contrat_signataire_nom FROM `contrat_signataire` where contrat_signataire_id = ".$cl_q_con['contrat_signataire_id'])) ;
$content = str_replace ( '$contratsignatairenom' , $contratsignatairenom , $content );
list($salarie_nom, $salarie_prenom , $sal_echelon_remplace , $salarie_categorie_id_remplace) = dbi_fetch_row(dbi_query("SELECT salarie_nom,salarie_prenom, salarie_echelon , salarie_categorie_id FROM `salarie` WHERE `salarie_id` = ".$cl_q_con['id_salarie_abs'])) ;
$salarie_remplacont = $salarie_nom." ".$salarie_prenom ;
if($salarie_categorie_id_remplace > 0){
list($salariecategoriedesignatioremplc , $salariecategoriedesignationcourt_remplac)=dbi_fetch_row(dbi_query("SELECT salarie_categorie_designation , salarie_categorie_designation_court FROM `salarie_categorie` WHERE `salarie_categorie_id` =".$salarie_categorie_id_remplace)) ;
$content = str_replace ( '$salariecategoriedesignatioremplc' , $salariecategoriedesignatioremplc , $content );
}
$content = str_replace ( '$salarie_remplacont' , $salarie_remplacont , $content );
// echo $sal_echelon_remplace."<br/>" ;
if($salarie_categorie_id_remplace > 4 )
{
$sal_echelon_remplace= "" ;
// $aa= $salariecategoriedesignationcourt ;
}
else{
$sal_echelon_remplace= "échelon ".$sal_echelon_remplace ;
// $aa= $salariecategoriedesignationcourt."".$q_salar['salarie_echelon'] ;
}
$content = str_replace ( '$sal_echelon_remplace' , $sal_echelon_remplace , $content );
// $content = str_replace ( '$aa' , $aa , $content );
// $content = str_replace ( '$salarieechelon' , $salarieechelon , $content );
$salarie_contr_date_deb_abs=int2date($cl_q_con['salarie_contr_date_deb_abs']) ;
// $content = str_replace ( '$Motif_absence' , $Motif_absence , $content );
$content = str_replace ( '$salarie_contr_date_deb_abs' , $salarie_contr_date_deb_abs , $content );
$salarie_contr_date_fin_abs=int2date($cl_q_con['salarie_contr_date_fin_abs']) ;
// $content = str_replace ( '$Motif_absence' , $Motif_absence , $content );
$content = str_replace ( '$salarie_contr_date_fin_abs' , $salarie_contr_date_fin_abs , $content );
$motif_absence=$cl_q_con['salarie_contrat_Motif_absence'] ;
// $content = str_replace ( '$Motif_absence' , $Motif_absence , $content );
$content = str_replace ( '$motif_absence' , $motif_absence , $content );
// echo "=====> ".$salarie_contrat_Motif_absence."<br/>" ;
// exit() ;
$salarie_contrat_date_fin = int2date($cl_q_con['salarie_contrat_date_fin']);
$content = str_replace ( '$salarie_contrat_date_fin' , $salarie_contrat_date_fin , $content );
// ACH
$dateo = $cl_q_con['salarie_contrat_date_fin'];
$salarie_cotrat__fin_plus_jour = date('d/m/Y', strtotime($dateo. ' + 1 days'));
$content = str_replace ( '$salarie_cotrat__fin_plus_jour' , $salarie_cotrat__fin_plus_jour , $content );
$salarie_contrat_heures_complement = $cl_q_con['salarie_contrat_heures_complement'];
$content = str_replace ( '$salarie_contrat_heures_complement' , $salarie_contrat_heures_complement , $content );
$salarie_contrat_duree_accroissement = $cl_q_con['salarie_contrat_duree_accroissement'];
$content = str_replace ( '$salarie_contrat_duree_accroissement' , $salarie_contrat_duree_accroissement , $content );
if($cl_q_con['salarie_contrat_Motif_accroissement']== 1)
{
$salarie_contrat_Motif_accroissement = " attribution d un chantier ponctuel" ;
}
if($cl_q_con['salarie_contrat_Motif_accroissement']== 2)
{
$salarie_contrat_Motif_accroissement = " d'une commande exceptionnelle d'un client habituel" ;
}
$content = str_replace ( '$salarie_contrat_Motif_accroissement' , $salarie_contrat_Motif_accroissement , $content );
// echo "$salarie_contrat_duree_accroissement <br/>" ;
// echo "$salarie_contrat_Motif_accroissement <br/>" ;
// exit() ;
$salarie_contrat_duree_periode_essai = $cl_q_con['salarie_contrat_duree_periode_essai'] ;
$content = str_replace ( '$salarie_contrat_duree_periode_essai' , $salarie_contrat_duree_periode_essai , $content );
// echo "==> ".$salarie_contrat_date_fin."<br/>" ;
// exit() ;
$salariecontratdatedebut = int2date($cl_q_con['salarie_contrat_date_debut']);
$salariecontratfinperiodeessai = int2date($cl_q_con['salarie_contrat_fin_periode_essai']);
$salarie_contrat_fin_periode_essai = int2date($cl_q_con['salarie_contrat_fin_periode_essai']);
$content = str_replace ( '$salarie_contrat_fin_periode_essai' , $salarie_contrat_fin_periode_essai , $content );
$salariecontratdatesignature = int2date($cl_q_con['salarie_contrat_date_signature']);
$salariecontratheuredebut = $cl_q_con['salarie_contrat_heure_debut'] ;
$content = str_replace ( '$salariecontratheuredebut' , $salariecontratheuredebut , $content );
$salarie_contrat_remuneration = $cl_q_con['salarie_contrat_remuneration'] ;
$content = str_replace ( '$salarie_contrat_remuneration' , $salarie_contrat_remuneration , $content );
$mensuelle = $cl_q_con['salarie_contrat_duree_mensuelle'];
$mensuelle = number_format( $mensuelle , 2, ',', ' ') ;
$content = str_replace ( '$mensuelle' , $mensuelle , $content );
// echo "==>".$q_salar['salarie_id']."<br/>";
$salarie_categorie_id = $q_salar['salarie_categorie_id'];
$salarie_echelon = $q_salar['salarie_echelon'];
$salarie_position = $q_salar['salarie_position'];
list($salarie_categorie_designation)=dbi_fetch_row(dbi_query("SELECT salarie_categorie_designation FROM `salarie_categorie` WHERE `salarie_categorie_id` = $salarie_categorie_id "));
list($salarie_horaire)= dbi_fetch_row(dbi_query("SELECT salarie_horaire FROM `grille_salarie` WHERE `salarie_categorie_id` = $salarie_categorie_id AND `position_ID` = $salarie_position AND `echelon` = $salarie_echelon"));
// echo "===".$salarie_horaire ;
// exit() ;
$content = str_replace ( '$salarie_categorie_designation' , $salarie_categorie_designation , $content );
$remuneration = $salarie_horaire ;
$content = str_replace ( '$remuneration' , $remuneration , $content );
list($dfs)= dbi_fetch_row( dbi_query("SELECT dfs FROM `dfs_table` where `id_dfs` = 1")) ;
$content = str_replace ( '$dfs' , $dfs , $content );
$salarie_contrat_duree_preavis = $cl_q_con['salarie_contrat_duree_preavis'];
$content = str_replace ( '$salarie_contrat_duree_preavis' , $salarie_contrat_duree_preavis , $content );
// echo "==> $salarie_contrat_duree_preavis <br/>" ;
// exit() ;
// $content = str_replace ( '$salariecontratdureemensuelle' , $salariecontratdureemensuelle , $content );
$content = str_replace ( '$titrefacture' , $titrefacture , $content );
$content = str_replace ( '$salarienom' , $salarienom , $content );
$content = str_replace ( '$salarieprenom' , $salarieprenom , $content );
$content = str_replace ( '$salarie_nom_naissance' , $salarie_nom_naissance , $content );
$content = str_replace ( '$salariedatenaissance' , $salariedatenaissance , $content );
$content = str_replace ( '$salarievillenaissance' , $salarievillenaissance , $content );
$content = str_replace ( '$salariepaysnaissance' , $salariepaysnaissance , $content );
$content = str_replace ( '$salariedocumentnumero' , $salariedocumentnumero , $content );
$content = str_replace ( '$salariedocumentdatevalidite' , $salariedocumentdatevalidite , $content );
$content = str_replace ( '$salarienumerosecu' , $salarienumerosecu , $content );
$content = str_replace ( '$salariecontratdatedebut' , $salariecontratdatedebut , $content );
$content = str_replace ( '$salariecontratfinperiodeessai' , $salariecontratfinperiodeessai , $content );
$content = str_replace ( '$salariecontratdatesignature' , $salariecontratdatesignature , $content );
$content = str_replace ( '$etablissement_zone_mobilite' , $etablissement_zone_mobilite , $content );
// The rest of the file in step 3
// Code to be inserted in step 2 AT THE END OF THE CODE
// $filenameaaa = "contrat/contrattttt.doc" ;
// touch ('$filenameaaa' );
$filename = "file/contrat".$cl_q_con['salarie_contrat_id'].".doc" ;
if(file_exists($filename)) { unlink ($filename); }
touch ( $filename );
if ( is_writable ( $filename )) {
if (! $handle = fopen ( $filename , 'a' )) {
echo "Unable to open file ($filename)" ;
exit ;
}
if ( fwrite ( $handle , $content ) === FALSE ) {
echo "Unable to write to file ($filename)" ;
exit ;
}
// echo "<a href='$filename'> telecharger</a>" ;
fclose ( $handle );
} else {
echo "The file $filename is not writable." ;
}
// $filename = "contrat/contrat".$cl_q_con['salarie_contrat_id'].".doc" ;
}
if($_GET['sup'] == 1 )
{
dbi_query("DELETE FROM `salarie_contrat` WHERE `salarie_contrat`.`salarie_contrat_id` =".$_GET['salarie_contrat_id']) ;
header('Location:salarie_contrat.php?msg=contrat bien supprimé&color=success');
}
// if(!empty($_POST))
// {
// $salarie_date_naissancea= dateMCPROint($_POST['salarie_date_naissance']) ;
// $salarie_document_date_validitea= dateMCPROint($_POST['salarie_document_date_validite']) ;
// $salarie_date_naissance= $salarie_date_naissancea ;
// $salarie_ville_naissance=$_POST['salarie_ville_naissance'] ;
// $salarie_pays_naissance=$_POST['salarie_pays_naissance'] ;
// $salarie_nationalite=$_POST['salarie_nationalite'] ;
// $salarie_document=$_POST['salarie_document'] ;
// $salarie_document_numero=$_POST['salarie_document_numero'] ;
// $salarie_document_date_validite=$salarie_document_date_validitea ;
// $salarie_numero_secu=$_POST['salarie_numero_secu'] ;
// dbi_query( " UPDATE salarie
// SET
// salarie_date_naissance = '$salarie_date_naissance',
// salarie_ville_naissance = '$salarie_ville_naissance',
// salarie_pays_naissance = '$salarie_pays_naissance',
// salarie_nationalite = '$salarie_nationalite',
// salarie_document = '$salarie_document',
// salarie_document_numero = '$salarie_document_numero',
// salarie_document_date_validite = '$salarie_document_date_validite',
// salarie_numero_secu = '$salarie_numero_secu'
// WHERE salarie_id = $salarie_id ") ;
// }
?>
<!DOCTYPE html>
<html>
<head>
<?php include('header.php'); ?>
<script type="text/javascript" src="plugins/selectize/selectize.js"></script>
<link rel="stylesheet" type="text/css" href="plugins/selectize/selectize.css" />
<script type="text/javascript" src="plugins/selectize/selectize.min.js"></script>
<link rel="stylesheet" type="text/css" href="plugins/selectize/selectize.default.css" />
<link rel="stylesheet" href="../../plugins/summernote/summernote-bs4.css">
<!-- jQuery 2.2.3 -->
<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
<!-- Bootstrap 3.3.6 -->
<script src="bootstrap/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
<style type="text/css">
.modal-backdrop {
/* bug fix - no overlay */
display: none;
}
</style>
</head>
<body class="hold-transition sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<!-- TOP MENU -->
<nav class="main-header navbar navbar-expand navbar-white navbar-light">
<!-- Menu extensible -->
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
</li>
<div class="btn-group">
<a href="salarie_contarts.php" > <button type="button" class="btn btn-primary"> <i class="fas fa-plus"></i> CONTRAT</button> </a>
</div>
  <li> <h3><a href="#myModal_tache_all" id="custId" data-toggle="modal" > <button type="button" class="btn btn-primary" > <i class="fas fa-plus"></i> TACHE</button> </a></h3></li>
<!-- liens TOP MENU GAUCHE modal -->
</ul>
<!-- liens TOP MENU DROITE -->
<ul class="navbar-nav ml-auto">
<li class="nav-item">
<a href="login.php?dec=1" class="nav-link">
<i class="nav-icon fas fa-power-off"></i>
</a>
</li>
</ul>
</nav> <!-- fin du TOP MENU -->
<!-- BARRE DE NAVIGATION -->
<?php include('menu.php'); ?>
<div class="modal fade" id="myModal_tache_all" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="fetch_tache_all" ></div>
</div>
</div>
</div>
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="content-wrapper">
<section class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1><?php echo $q['salarie_nom']." ".$q['salarie_prenom'] ;?></h1>
</div>
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="index.php">Accueil</a></li>
<li class="breadcrumb-item"><a href="salaries2.php">Salariés</a></li>
<li class="breadcrumb-item active">Contrats </li>
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="modal fade" id="myModal" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="fetch" ></div>
</div>
</div>
</div>
<div class="modal fade" id="myModal_cdd" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="fetch_cdd" ></div>
</div>
</div>
</div>
<div class="modal fade" id="myModal_ach_remplacement" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="fetch_ach" ></div>
</div>
</div>
</div>
<div class="modal fade" id="myModal_accro" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="fetch_accro" ></div>
</div>
</div>
</div>
<div class="modal fade" id="myModal_CDI" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="fetch_CDI" ></div>
</div>
</div>
</div>
<script language="JavaScript">
function toggle(source) {
checkboxes = document.getElementsByName('id[]');
for(var i=0, n=checkboxes.length;i<n;i++) {
checkboxes[i].checked = source.checked;
}
}
</script>
</div>
<!-- /.content-header -->
<!-- PAGE PRINCIPALE -->
<div class="content">
<div class="container-fluid">
<!-- PASSAGE A LA COLONNE DE DROITE-->
<div class="col-lg-12">
<!-- CARD DE DROITE-->
<div class="card card-info">
<?php include('menu_salarie_haut.php'); ?>
<?php
if(isset($_GET["msg"])){
?>
<div class="alert alert-<?php echo $_GET["color"]; ?> alert-dismissible col-12" role="alert">
<strong><?php echo $_GET["color"].': '; ?></strong><?php echo $_GET["msg"]; ?>.
<button type="button" class="close" data-dismiss="alert" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<?php
}
?>
<div class="card-body">
<?php
$q= dbi_query("SELECT * FROM salarie_contrat where salarie_id = ".$salarie_id." ORDER BY `salarie_contrat`.`salarie_contrat_date_debut` ASC") ;
?>
<table id="" class="table table-bordered table-hover">
<thead>
<tr>
<th>Date de début</th>
<th>Date de fin</th>
<th>Type de contrat</th>
<th>Durée</th>
<!-- <th>Fin de Période d'essai</th> <!-- /.Table Client - Champs client_cp -->
<!-- /.Table Client - Champs client_ville
<th>Rémunération Horaire Brute</th>
<th>Signataire</th> -->
<th></th>
</tr>
</thead>
<tbody>
<?php
while($cl=dbi_fetch_row($q))
{
list($nom) =dbi_fetch_row(dbi_query(" SELECT salarie_nom , salarie_prenom FROM `salarie` WHERE salarie_id =".$cl['salarie_id'])) ;
list($contrat_signataire_nom) =dbi_fetch_row(dbi_query("SELECT contrat_signataire_nom FROM `contrat_signataire` WHERE `contrat_signataire_id` =".$cl['contrat_signataire_id'])) ;
if($cl['salarie_contrat_fin_periode_essai']== 19991130)
{
$salarie_contrat_fin_periode_essai = "--" ;
}
else
{
// echo "baba" ;
$salarie_contrat_fin_periode_essai = int2date($cl['salarie_contrat_fin_periode_essai']) ;
}
if($cl['contrat_type_id']==1){ $contrat_type= "CDI" ; }
if($cl['contrat_type_id']==4){ $contrat_type= "CDD ACCR ACTIVITE" ; }
if($cl['contrat_type_id']==10){ $contrat_type= "ACH ACCR ACTIVITE" ; }
if($cl['contrat_type_id']==11){ $contrat_type= "ACH REMPLACEMENT" ; }
if($cl['contrat_type_id']==17){ $contrat_type= "Avenant duree" ; }
if($cl['contrat_type_id']==6){ $contrat_type= "CDD REMPLACEMENT" ; }
// if($cl['contrat_type_id']==1){ $contrat_type= "CDI" ; }
?>
<tr>
<td><?php echo int2date($cl['salarie_contrat_date_debut'] ) ; ?></td>
<td><?php echo int2date($cl['salarie_contrat_date_fin']) ;?></td>
<td><?php echo $contrat_type ;?></td>
<td><?php echo $cl['salarie_contrat_duree_mensuelle'] ; ?></td>
<!-- <td><?php // echo $cl['salarie_contrat_heure_debut'] ; ?></td>-->
<!-- <td><?php //echo $salarie_contrat_fin_periode_essai; ?></td>
<td><?php //echo $cl['salarie_contrat_remuneration'] ; ?></td>
<td><?php //echo $contrat_signataire_nom ; ?></td>-->
<td align="">
<?php
$filename = "file/contrat".$cl['salarie_contrat_id'].".doc" ;
if ( is_writable ( $filename )) {
if (! $handle = fopen ( $filename , 'a' )) {
echo "Unable to open file ($filename)" ;
exit ;
}
if ( fwrite ( $handle , $content ) === FALSE ) {
echo "Unable to write to file ($filename)" ;
exit ;
}
?>
<a class="btn btn-primary btn-sm" target="_blank" href="<?php echo $filename;?>"><i class="fas fa-file"> Voir
</i> </a>
<?php
// echo "<a href='$filename'> telecharger</a>" ;
fclose ( $handle );
} else {
echo "The file $filename is not writable." ;
}
?>
<a class="btn btn-info btn-sm" href="salarie_modifcontrat.php?salarie_contrat_id=<?php echo$cl['salarie_contrat_id'] ; ?>&contrat_type_id=<?php echo$cl['contrat_type_id'] ; ?>">
<i class="fas fa-pencil-alt"></i> Editer
</a>
<a class="btn btn-danger btn-sm" href="salarie_contrat.php?salarie_contrat_id=<?php echo $cl['salarie_contrat_id'] ; ?>&sup=1" onclick="return confirm('Voulez-vous vraiment supprimer cet contrat ?');">
<i class="fas fa-trash"> Supprimer
</i>
</a>
<?php if($cl['contrat_type_id'] == 4 OR $cl['contrat_type_id'] == 6 ){echo '<a class="btn btn-warning btn-sm" href="#myModal_cdd" id="custId" data-toggle="modal" data-id="'.$cl['salarie_contrat_id'].'"> Annexe CDD </a>';?>
</a>
<?php
}
?>
<?php if($cl['contrat_type_id'] == 1 OR $cl['contrat_type_id'] == 17 ){echo '<a class="btn btn-warning btn-sm" href="#myModal_CDI" id="custId" data-toggle="modal" data-id="'.$cl['salarie_contrat_id'].'"> Annexe CDI </a>';?>
</a>
<?php
}
?>
<?php if($cl['contrat_type_id'] == 11 ){echo '<a class="btn btn-warning btn-sm" href="#myModal_ach_remplacement" id="custId" data-toggle="modal" data-id="'.$cl['salarie_contrat_id'].'"> Annexe ach remplacement</a>';?>
</a>
<?php
}
?>
<?php if($cl['contrat_type_id'] == 10 ){echo '<a class="btn btn-warning btn-sm" href="#myModal_accro" id="custId" data-toggle="modal" data-id="'.$cl['salarie_contrat_id'].'"> Annexe ach ACCR ACTIVITE</a>';?>
</a>
<?php
}
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- /.col-md-6 -->
</div>
<!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
<div class="p-3">
<h5>Title</h5>
<p>Sidebar content</p>
</div>
</aside>
<!-- /.control-sidebar -->
<?php include('footerr.php'); ?>
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<script type="text/javascript">
$(document).ready(function(){
$('#myModal_tache_all').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'tache_ajax_nv_all.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch_tache_all').html(data);//Show fetched data from database
}
});
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$(".custom_link").click(function(){
href= $(this).attr('href');
window.location=href;
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal_CDI').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ajax_CDI.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch_CDI').html(data);//Show fetched data from database
}
});
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal_ach_remplacement').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ach_remplacement_ajax.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch_ach').html(data);//Show fetched data from database
}
});
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal_accro').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ach_accro.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch_accro').html(data);//Show fetched data from database
}
});
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal_cdd').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ajax_CDDe.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch_cdd').html(data);//Show fetched data from database
}
});
});
});
</script>
</body>
</html>