<?php

// include 'code/init.php' ;

include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// echo "<pre>" ; 
// print_r($_GET) ; 
// echo "</pre>" ; 
if(!empty($_GET['salarie_id']))
{
$_SESSION["salarie_id"]=$_GET['salarie_id'];

}
 $cleint_id=$_SESSION["salarie_id"] ; 

// echo "<pre>" ; 
// prinhht_r($_POST) ; 
// echo "</pre>" ;

$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() ; 

$q_con = dbi_query("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/>" ;
$content = file_get_contents (  "file/template.htm" );  // 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` where salarie_id = ".$salarie_id)) ; 
  
  
$titrefacture="tttt";

// echo "==> ".$q_salar['salarie_nom'] ; 

$salarienom= $q_salar['salarie_nom'];
$salarieprenom= $q_salar['salarie_prenom'];
$salariedatenaissance= int2date($q_salar['salarie_date_naissance']);

$salarie_nationalite= $q_salar['salarie_nationalite'];




$Demeurant = $q_salar['salarie_adr1']." ".$q_salar['salarie_adr2']." ".$q_salar['salarie_cp']." ".$q_salar['salarie_ville']  ;



$salarievillenaissance= $q_salar['salarie_ville_naissance'];

$salariepaysnaissance= $q_salar['salarie_pays_naissance'];
$salarienationalite= $q_salar['salarie_nationalite'];
$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é" ; 	
}




list($etablissementnumurssaf ,$etablissement_zone_mobilite )= dbi_fetch_row( dbi_query("SELECT etablissement_num_urssaf ,etablissement_zone_mobilite  FROM `etablissement` where etablissement_id = ".$q_salar['etablissement_id'])) ; 

$salariecontratdatedebut = int2date($cl_q_con['salarie_contrat_date_debut']);
$salariecontratfinperiodeessai = int2date($cl_q_con['salarie_contrat_fin_periode_essai']);
$salariecontratdatesignature = int2date($cl_q_con['salarie_contrat_date_signature']);

$mensuelle = $cl_q_con['salarie_contrat_duree_mensuelle'];
$remuneration = $cl_q_con['salarie_contrat_remuneration'];





$content = str_replace ( '$remuneration' , $remuneration , $content ); 


$content = str_replace ( '$mensuelle' , $mensuelle , $content ); 
// $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 ( '$salariedatenaissance' , $salariedatenaissance , $content ); 
$content = str_replace ( '$salarievillenaissance' , $salarievillenaissance , $content ); 

$content = str_replace ( '$salariepaysnaissance' , $salariepaysnaissance , $content ); 
$content = str_replace ( '$salarienationalite' , $salarie_nationalite , $content ); 
$content = str_replace ( '$Demeurant' , $Demeurant , $content ); 
$content = str_replace ( '$salariedocumentnumero' , $salariedocumentnumero , $content ); 
$content = str_replace ( '$salariedocumentdatevalidite' , $salariedocumentdatevalidite , $content ); 
$content = str_replace ( '$salarienumerosecu' , $salarienumerosecu , $content ); 

$content = str_replace ( '$etablissementnumurssaf' , $etablissementnumurssaf , $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>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
 <title> LogMCPRO | Contrat</title>
												
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="../plugins/fontawesome-free/css/all.min.css">
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  <link rel="stylesheet" href="../dist/css/adminlte.min.css">
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
</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_nvcontrat.php" >  <button type="button" class="btn btn-primary">NOUVEAU CONTRAT</button> </a>
                  
                  </div>
<!-- liens TOP MENU GAUCHE-->
     
    </ul>
   

 <!-- liens TOP MENU DROITE -->
    <ul class="navbar-nav ml-auto">
     <!-- Placer ici l'élément à positionner à droite du TOP MENU -->
    </ul>
  
  </nav>  <!-- fin du TOP MENU -->
  
  
<!-- BARRE DE NAVIGATION -->

	<?php include('menu.php'); ?>

 <!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark"></h1>
          </div><!-- /.col -->
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
             
            </ol>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

    <!-- PAGE PRINCIPALE -->
    <div class="content">
      <div class="container-fluid">
        <div class="row">
	  <!-- DEFINITION DES COLONNES -->	
          <div class="col-lg-3">
		  
	 <!-- WIDGET AVEC LE NOM DU CLIENT -->	

<?php include('widget_salarie.php'); ?>
			  
		 <!-- BARRE DE NAVIGATION DU CLIENT -->		  
            
<?php include('menu_salarie.php'); ?>
			
</div>
          
          <!-- PASSAGE A LA COLONNE DE DROITE-->
          <div class="col-lg-9">
		  <!-- CARD DE DROITE-->
            <div class="card">
              <div class="card-header">
                <h5 class="m-0"><i class="nav-icon far fa-address-card"></i> CONTRATS</h5>
              </div>
			  
			  
			  	  <?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">&times;</span>
          </button>
        </div>
        <?php
        }
       ?>
              <div class="card-body">
   
   

 
 
  <?php
  
  $q= dbi_query("SELECT * FROM salarie_contrat where salarie_id = ".$salarie_id) ; 
  ?>
 
  <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>Date d'embauche</th>     		<!-- /.Table Client - Champs client_nom -->
                  <th>Heure d'Embauche</th> 		<!-- /.Table Client - Champs client_adr1 -->
                  <th>Fin de Période d'essai</th> 	<!-- /.Table Client - Champs client_cp -->
                  <th>Durée Mensuelle</th>		<!-- /.Table Client - Champs client_ville -->
                  <th>Rémunération Horaire Brute</th>
				  <th>Date de signature</th>
				  <th>Signataire</th>
				   <th>Afficher</th>
				   <th>Editer</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'])) ; 
					?>
					
					<tr>
                  <td><?php echo int2date($cl['salarie_contrat_date_debut'] ) ; ?></td>
                 <td><?php echo $cl['salarie_contrat_heure_debut'] ; ?></td>
                <td><?php echo int2date($cl['salarie_contrat_fin_periode_essai']); ?></td>
                 <td><?php echo $cl['salarie_contrat_duree_mensuelle'] ; ?></td>
				 <td><?php echo $cl['salarie_contrat_remuneration'] ; ?></td>
				 <td><?php echo int2date($cl['salarie_contrat_date_signature'])  ;?></td>
				 <td><?php echo $nom ; ?></td>
				 <th><?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 ; 
  } 
  echo  "<a href='$filename'> telecharger</a>" ; 
  fclose ( $handle ); 
 }  else  { 
  echo  "The file $filename is not writable." ; 
 }	
				 ?></th>
				 
				 
				 				 	<td align="center">
				   
				   <a href="">
              <span class="nav-icon fas fa-edit"  style="color: black;" ></span>

                   </a>
				   	   <a href="salarie_contrat.php?salarie_contrat_id=<?php echo$cl['salarie_contrat_id'] ; ?>&sup=1" onclick="return confirm('Voulez-vous vraiment supprimer cet contrat ?');">
              
				   <span class="fas fa-trash-alt nav-icon"  style="color: black;" ></span>
				   </a>
				   </td>
				 
                </tr>
					
					<?php
				}
				?>
                
                           
                
               
                </tbody>
                <tfoot>
     <tr>
                  <th>Date d'embauche</th>     		<!-- /.Table Client - Champs client_nom -->
                  <th>Heure d'Embauche</th> 		<!-- /.Table Client - Champs client_adr1 -->
                  <th>Fin de Période d'essai</th> 	<!-- /.Table Client - Champs client_cp -->
                  <th>Durée Mensuelle</th>		<!-- /.Table Client - Champs client_ville -->
                  <th>Rémunération Horaire Brute</th>
				  <th>Date de signature</th>
				  <th>Signataire</th>
				  <th>Afficher</th>
				   <th>Editer</th>
                </tr>
                </tfoot>
              </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 -->
  <footer class="main-footer">
    <div class="float-right d-none d-sm-block">
      <b>Version</b> 3.0.1
    </div>
    <strong>Copyright &copy; 2014-2019 <a href="http://adminlte.io">AdminLTE.io</a>.</strong> All rights
    reserved.
  </footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->

<!-- jQuery -->
<script src="../plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../dist/js/demo.js"></script>
<script type="text/javascript">
	$(document).ready(function(){
		$(".custom_link").click(function(){
			href=  $(this).attr('href');
			window.location=href;
		});
	});
</script>
</body>
</html>