|
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/../../mcg/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
echo "rrrrr <br/>" ;
// include 'code/init.php' ;
// 6
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] ;
}
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];
}
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 ;
}
$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();
$salarie_id = $interdispo ;
$data = array();
$now = new DateTime();
$start = $from ;
$end = $to;
$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 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 ) )
");
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 ) {
$day = date("w", strtotime( int2date_autre_format($date)));
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;
}
}
}
}
}
}
$date = date("Ymd", strtotime("+1 day", strtotime($date)));
}
return $data;
}
$salarie_idd=$_SESSION["salarie_id"] ;
$salarie_id=$_SESSION["salarie_id"] ;
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/>";
}
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 );
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['contrat_type_id']."<br/>" ;
// exit() ;
// echo " => ".$cl_q_con['salarie_contrat_date_debut']."<br/>" ;
if($cl_q_con['contrat_type_id'] == 1)
{
$content = file_get_contents ( "file/CDI_TPS_PARTIEL.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= utf8_decode($q_salar['salarie_nom']);
$salarieprenom= utf8_decode($q_salar['salarie_prenom']);
echo "==>".$salarieprenom."<br/>" ;
exit() ;
$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/> " ;
date_default_timezone_set('Europe/Paris'); // Changez selon votre fuseau horaire
<?php
// Exécution de la requête SQL pour obtenir les indisponibilités du salarié
$info_indispo = dbi_query("SELECT * FROM indisponibilite WHERE salarie_id = " . $salarie_id);
$disponibilites = [
'LUNDI' => ['de' => '', 'à' => '', 'et_de' => '', 'et_à' => ''],
'MARDI' => ['de' => '', 'à' => '', 'et_de' => '', 'et_à' => ''],
'MERCREDI' => ['de' => '', 'à' => '', 'et_de' => '', 'et_à' => ''],
'JEUDI' => ['de' => '', 'à' => '', 'et_de' => '', 'et_à' => ''],
'VENDREDI' => ['de' => '', 'à' => '', 'et_de' => '', 'et_à' => ''],
'SAMEDI' => ['de' => '', 'à' => '', 'et_de' => '', 'et_à' => ''],
];
// Parcourir les résultats de la requête SQL
while ($indisponibilite = dbi_fetch_row($info_indispo)) {
$jour = strtoupper($indisponibilite['disponibilite_jour']);
$heure_debut = date("H\hi", strtotime($indisponibilite['disponibilite_heurs_debu']));
$heure_fin = date("H\hi", strtotime($indisponibilite['disponibilite_heurs_fin']));
if (empty($disponibilites[$jour]['de'])) {
$disponibilites[$jour]['de'] = $heure_debut;
$disponibilites[$jour]['à'] = $heure_fin;
} else {
$disponibilites[$jour]['et_de'] = $heure_debut;
$disponibilites[$jour]['et_à'] = $heure_fin;
}
}
// Formatage de la sortie
$html = "";
foreach ($disponibilites as $jour => $horaires) {
$html .= str_pad($jour, 15, " ", STR_PAD_RIGHT) . " de " . str_pad($horaires['de'], 5, " ", STR_PAD_RIGHT) . " à " . str_pad($horaires['à'], 5, " ", STR_PAD_RIGHT) .
" et de " . str_pad($horaires['et_de'], 5, " ", STR_PAD_RIGHT) . " à " . str_pad($horaires['et_à'], 5, " ", STR_PAD_RIGHT) . "\n";
}
// Affichage de la sortie
// echo "<pre>" . $output . "</pre>";
// Enregistrement dans un fichier .htm
$content = str_replace ( '$html' , $html , $content );
// Afficher la date au format d/m/y
$date_actuelle = date("d/m/y");
$heure_actuelle = date("H\hi") ;
$content = str_replace ( '$date_actuelle' , $date_actuelle , $content );
$content = str_replace ( '$heure_actuelle' , $heure_actuelle , $content );
$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` = 0 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');
}
?>
<!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 -->
<aside class="main-sidebar sidebar-dark-primary elevation-4">
<!-- Brand Logo -->
<a href="index3.html" class="brand-link">
<img src="dist/img/logomcpro.png" alt="AdminLTE Logo" class="brand-image img-circle elevation-3"
style="opacity: .8">
<span class="brand-text font-weight-light">MC PRO</span>
</a>
<!-- Sidebar -->
<div class="sidebar">
<!-- Sidebar user panel (optional) -->
<div class="user-panel mt-3 pb-3 mb-3 d-flex">
<div class="image">
<img src="dist/img/user2-160x160.jpg" class="img-circle elevation-2" alt="User Image">
</div>
<div class="info">
<a href="#" class="d-block">Steeven ROBLOT</a>
</div>
</div>
<?php include('menu.php') ?>
<!-- Sidebar Menu -->
</div>
<!-- /.sidebar -->
</aside>
<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_sal.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>