<?php

include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$pagemenu = basename($_SERVER["PHP_SELF"]) ;

 include('file_tache.php');

// echo "<pre>" ;
// print_r($_GET) ;
// echo "</pre>" ;
if(!empty($_GET['salarie_id']))
{
$_SESSION["salarie_id"]=$_GET['salarie_id'];

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



$salarie_idd=$_SESSION["salarie_id"] ;

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

// $salarie_id = 87 ;
// $salarie_idd = 87 ;

if($_GET['sup']== 1)
{

	dbi_query("DELETE FROM `salarie_vm`
WHERE 	salarie_vm_id  =".$_GET['salarie_vm_id']) ;

header('Location:salarie_vm.php?msg=bien supprimé&color=success');


				 // echo "bbb <br/>" ;
				 // exit() ;
}



			 if(!empty($_POST) and isset($_POST['Enregistrer_multiEmployeurs']) )
			 {
                 $multiEmployeurs  = 0 ; 
				 if(!empty( $_POST['multiEmployeurs'])) {
				 $multiEmployeurs  =   1 ;  }
                
				dbi_query(" UPDATE `salarie` SET `multiEmployeurs` = '".$multiEmployeurs."' WHERE `salarie`.`salarie_id` = $salarie_idd ") ; 
				
				header('Location:salarie_vm.php?msg=Modificatin bien ajouté&color=success');


			 }


						 if(!empty($_POST) and isset($_POST['Enregistrer']) and empty($_POST['tache_Priorite']) )
			 {

				 // echo "<pre>" ;
// print_r($_POST) ;
// echo "</pre>" ;
				 // echo "bbb <br/>" ;


				 if(!empty($_POST['salarie_vm_date_prev']))
				 {
$salarie_vm_date_preva= date2int_DSI($_POST['salarie_vm_date_prev']) ;
				 }


				 if(!empty($_POST['salarie_vm_date_rdv']))
				 {
$salarie_vm_date_rdva= date2int_DSI($_POST['salarie_vm_date_rdv']) ;
				 }

		 // exit() ;


// $salarie_vm_date_rdva= dateMCPROint($_POST['salarie_vm_date_rdv']) ;

						$salarie_vm_date_prev= $salarie_vm_date_preva ;
						$salarie_vm_date_rdv= $salarie_vm_date_rdva ;
						$salarie_vm_valid=$_POST['salarie_vm_valid'] ;







						dbi_query(" INSERT INTO salarie_vm (

						salarie_vm_date_prev,
						salarie_vm_date_rdv,
						salarie_vm_valid,
						salarie_id )

						VALUES (

						'$salarie_vm_date_prev',
						'$salarie_vm_date_rdv',
						'$salarie_vm_valid',
						 '$salarie_idd'


 )") ;
 
 
 
 
  
  
  // echo "<pre>" ; 
  // print_r($_POST);
  // echo "</pre>" ; 
  
  // exit(); 
 $dateRdv = $_POST['salarie_vm_date_prev'];

// Créer un objet DateTime
$date = new DateTime($dateRdv);

// Soustraire un mois
$date->modify('-1 month');

// Ajouter l'heure courante
$currentTime = date("H:i");
$formattedDate = $date->format("Y-m-d") . "T" . $currentTime;

$date_heure_creation = $date->format("d-m-Y") . "T" . $currentTime;


  list($tache_id) = dbi_fetch_row(dbi_query("SELECT max(tache_id) FROM `tache` WHERE `salarie_id` = ".$salarie_idd." AND `tache_titre_id` = 23 ORDER BY `tache_id` DESC")) ;
 $user_id_creation = 83; 
dbi_query("INSERT INTO sous_tache 
 (tache_id,sous_tache_designation, sous_tache_date_fin,user_id, sous_tache_status,actif,date_creation,user_id_creation,date_heure_creation,date_heure_creation_forma_date,PRIORITAIRE)
 VALUES
 ('".$tache_id."','RH - visite médicale : Prendre rdv pour la prochaine visite','".$formattedDate."','84','0','1','".int2date($date->format("Y-m-d"))."','.$user_id_creation.','".$date_heure_creation."','".$formattedDate."','0')") ;

 
 
 
header('Location:salarie_vm.php?msg=bien ajouté&color=success');
			 }




							 if(!empty($_GET['salarie_vm_id'])  and isset($_POST['Modifier']))
			 {

               // echo "<pre>" ; 
			   // print_r($_POST) ; 
			   // echo "</pre>" ; 
                // exit() ; 
				$salarie_vm_id= $_POST['salarie_vm_id'] ;
				 if(!empty($_POST['salarie_vm_date_prev']))
				 {
$salarie_vm_date_preva= date2int_DSI($_POST['salarie_vm_date_prev']) ;
				 }


				 if(!empty($_POST['salarie_vm_date_rdv']))
				 {
$salarie_vm_date_rdva= date2int_DSI($_POST['salarie_vm_date_rdv']) ;
				 }
 // echo "==>".$salarie_vm_date_rdva."<br/>" ; 
 // exit() ; 

						$salarie_vm_date_prev= $salarie_vm_date_preva ;
						$salarie_vm_date_rdv= $salarie_vm_date_rdva ;
						$salarie_vm_valid=$_POST['salarie_vm_valid'] ;





								// UPDATE table
// SET colonne_1 = 'valeur 1', colonne_2 = 'valeur 2', colonne_3 = 'valeur 3'
// WHERE condition

						dbi_query(" UPDATE salarie_vm  SET

						salarie_vm_date_prev = '$salarie_vm_date_prev',
						salarie_vm_date_rdv =  '$salarie_vm_date_rdv',
						salarie_vm_valid =  '$salarie_vm_valid'


				where salarie_vm_id = $salarie_vm_id


				") ;

				header('Location:salarie_vm.php?msg=bien modifé&color=success');
			 }



	$q= dbi_fetch_row(dbi_query("SELECT * FROM  salarie_vm where 	salarie_id = ".$salarie_id." ORDER BY `salarie_vm`.`salarie_vm_date_prev` DESC")) ;
// header('Content-type: text/html; charset=UTF-8');
	?>





<!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">

<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>

<script src="bootstrap/js/bootstrap.min.js"></script>

<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>

<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>
	  &nbsp <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-->

    </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">Visites médicales </li>
           </ol>
         </div>
       </div>
     </div><!-- /.container-fluid -->
   </section>


   <!-- Content Header (Page header) -->

   <!-- /.content-header -->

   <!-- PAGE PRINCIPALE -->
   <div class="content">
     <div class="container-fluid">
       <div class="row">
   <!-- DEFINITION DES COLONNES -->


</div>


         <!-- 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'); ?>

              <div class="card-body">
			  
			  
	
  
  
  
  <?php 
// Récupération de la valeur $multiEmployeurs depuis la base de données
list($multiEmployeurs) = dbi_fetch_row(dbi_query("SELECT multiEmployeurs FROM `salarie` WHERE `salarie_id` = $salarie_idd")); 
// echo "SELECT multiEmployeurs FROM `salarie` WHERE `salarie_id` = $salarie_idd  <br/> " ; 
// echo "==>".$multiEmployeurs."<br/>" ;
?>
<form action="" method="POST">
  <div class="form-row">
    <div class="form-group col-md-4 d-flex align-items-center">
      <div class="form-check">
        <!-- Case à cocher avec condition pour ajouter "checked" si $multiEmployeurs est égal à 1 -->
        <input type="checkbox" id="multiEmployeurs" value="1" name="multiEmployeurs" class="form-check-input" 
        <?php if($multiEmployeurs == 1) echo 'checked'; ?>>
        <label class="form-check-label ml-2" for="multiEmployeurs">Multi-employeurs</label>
      </div>
    </div>
  </div>

  <button type="submit" name="Enregistrer_multiEmployeurs" class="btn btn-primary">Enregistrer</button>
</form>


			<div class="separator"></div>  
		<hr><hr>	  
			  
   <form action="" method="POST">

   <?php

   $q= dbi_query("SELECT * FROM salarie_vm where salarie_id = ".$salarie_idd." ORDER BY
    (salarie_vm_date_rdv = 0 AND salarie_vm_date_prev != 0) DESC,
    salarie_vm_date_rdv DESC ") ;
 				 if(!empty($_GET['salarie_vm_id']))
			 {

				 $red= dbi_fetch_row(dbi_query("SELECT * FROM salarie_vm where salarie_vm_id = ".$_GET['salarie_vm_id'])) ;
			     // echo "===>".$red['salarie_vm_date_prev']."<br/>" ;
				 // echo "===>".$red['salarie_vm_heure_debut']."<br/>" ;

				 $heurdeb = $red['salarie_vm_heure_debut'] ;
				 $heurfin = $red['salarie_vm_valid'] ;


			 }
   ?>
 <div class="form-row">






  </div> <!-- ///////Permet de passer à la ligne suivante -->

 <!-- ///////Ligne société & Catégorie -->

<!-- ///////Ligne -->

  <div class="form-row">
    <div class="form-group col-md-4">
      <label>Date Pr&#233;visionnelle</label>
	  <div class="input-group">
                    <div class="input-group-prepend">
                      <span class="input-group-text"><i class="far fa-calendar-alt"></i></span>
                    </div>
                    <input type="date" class="form-control" data-inputmask-alias="datetime" data-inputmask-inputformat="dd/mm/yyyy" data-mask name="salarie_vm_date_prev" <?php if(!empty($red['salarie_vm_date_prev']) AND $red['salarie_vm_date_prev']!=00000000 ) echo "value=".int2date_autre_format($red['salarie_vm_date_prev']) ;?> placeholder="jj/mm/aaaa" maxlength="10">
                  </div>

   </div>



  <div class="form-group col-md-4">
      <label>Date du RDV</label>
	  <div class="input-group">
                    <div class="input-group-prepend">
                      <span class="input-group-text"><i class="far fa-calendar-alt"></i></span>
                    </div>
                    <input type="date" class="form-control" data-inputmask-alias="datetime" data-inputmask-inputformat="dd/mm/yyyy" data-mask name="salarie_vm_date_rdv" <?php if(!empty($red['salarie_vm_date_rdv']) AND $red['salarie_vm_date_rdv']!=00000000  ) echo "value=".int2date_autre_format($red['salarie_vm_date_rdv']) ;?> placeholder="jj/mm/aaaa" maxlength="10" >
                  </div>
	 </div>


      <div class="form-group col-md-3">
      <label>Certificat reçu</label>
	<select class="form-control"  name="salarie_vm_valid" >


				 <option value="999" selected=" " disabled="disabled">Certificat reçu ?</option>



                           <option value="Oui" <?php if($red['salarie_vm_valid']== 'Oui') echo 'SELECTED'; ?>  >Oui </option>
                           <option value="Non" <?php if($red['salarie_vm_valid']== 'Non') echo 'SELECTED'; ?>>Non </option>
    </select>
      </div>

  </div>


<!-- ///////Ligne -->




<!-- ///////Ligne Code Postal & Ville -->




  <?php
  if(!empty($red['salarie_vm_id']))
  {
  ?>
  <input type="hidden" name="salarie_vm_id" value="<?=$red['salarie_vm_id'] ?>">
    <button type="submit" name="Modifier" class="btn btn-primary">Modifier</button>
  <?php
  }
  else
  {
  ?>
  <button type="submit" name="Enregistrer"  class="btn btn-primary">Enregistrer</button>
  <?php
  }
  ?>
</form>






              </div>

 <section class="content">

 					  		  <?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="row">
        <div class="col-12">

            </div>
            <!-- /.card-header -->
            <div class="card-body">
              <table id="" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>Date Pr&#233;visionnelle</th>     		<!-- /.Table Client - Champs client_nom -->
                  <th>Date du RDV</th> 		<!-- /.Table Client - Champs client_adr1 -->
                  <th>Certificat reçu ?</th> 	<!-- /.Table Client - Champs client_cp -->
				  <th></th>


                </tr>
                </thead>
                <tbody>
				<?php
				while($cl=dbi_fetch_row($q))
				{

					if( $cl['salarie_vm_date_prev'] == 00000000	)
					{
                           $salarie_vm_date_prev= "---" ;
					}
					else
					{
						   $salarie_vm_date_prev=int2date($cl['salarie_vm_date_prev']);
					}


						if( $cl['salarie_vm_date_rdv'] == 00000000	)
					{
                           $salarie_vm_date_rdv= "---" ;
					}
					else
					{
						   $salarie_vm_date_rdv=int2date($cl['salarie_vm_date_rdv']);
					}



					// list($motif)= dbi_fetch_row(dbi_query("SELECT absence_motif_description FROM `absence_motif` where absence_motif_id =".$cl['absence_type_id'])) ;
					?>

					<tr>
                  <td><?=$salarie_vm_date_prev?></td>
                <td><?=$salarie_vm_date_rdv?></td>
                 <td><?=$cl['salarie_vm_valid'] ?></td>

				<td>

				   <a class="btn btn-info btn-sm" href="salarie_vm.php?salarie_vm_id=<?=$cl['salarie_vm_id']?>&amp">
              <i class="fas fa-pencil-alt"> Editer</i>

			       </a>

					<a class="btn btn-danger btn-sm" href="salarie_vm.php?salarie_vm_id=<?=$cl['salarie_vm_id']?>&sup=1" onclick="return confirm('Voulez-vous vraiment la supprimer ?');">

				    <i class="fas fa-trash"> Supprimer
                              </i>


				   </a>
				   </td>



                </tr>

					<?php
				}
				?>




                </tbody>

              </table>
            </div>
            <!-- /.card-body -->
          </div>
          <!-- /.card -->
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->
    </section>


			</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>

</body>
</html>