<?php

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


 include('file_tache.php');

if(!empty($_GET['salarie_id']))
{
$_SESSION["salarie_id"]=$_GET['salarie_id'];

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



$salarie_idd=$_SESSION["salarie_id"] ;

$req =dbi_query("SELECT * FROM `dcp_type`") ;

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

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

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

			 // echo "<pre>" ;
// print_r($_GET) ;
// echo "</pre>" ;
				 // echo "bbb <br/>" ;
				 // exit() ;
}

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

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

				 // echo "==> ".$_POST['salarie_dcp_date_debut']."<br/>" ;

// $salarie_dcp_date_debuta= dateMCPROint($_POST['salarie_dcp_date_debut']) ;
$salarie_dcp_date_debuta= date2int_DSI($_POST['salarie_dcp_date_debut']) ;
// echo "=llk=> $salarie_dcp_date_debuta <br/> " ;
// exit() ;
if($_POST['salarie_dcp_date_fin']=="")
{
	$salarie_dcp_date_fin= NULL;

	// exit() ;
}
else
{
$salarie_dcp_date_fina= date2int_DSI($_POST['salarie_dcp_date_fin']) ;
}

						$salarie_dcp_date_debut= $salarie_dcp_date_debuta ;
						$salarie_dcp_heure_debut=$_POST['salarie_dcp_heure_debut'] ;
						$salarie_dcp_date_fin= $salarie_dcp_date_fina ;
						$salarie_dcp_heure_fin=$_POST['salarie_dcp_heure_fin'] ;
						$dcp_type_id=$_POST['dcp_type'] ;



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

// exit();

					    					// if($salarie_dcp_date_fin=="")
											// {

												// echo "test" ;
												// exit() ;
											// }

											$salarie_planning = 0 ;

											if($dcp_type_id == 1 or $dcp_type_id == 10 or $dcp_type_id == 14  or $dcp_type_id == 28 ){
												$salarie_planning = 1;
											}


						dbi_query(" INSERT INTO salarie_dcp (

						salarie_dcp_date_debut,
						salarie_dcp_heure_debut,
						salarie_dcp_date_fin,
						salarie_dcp_heure_fin,
						salarie_id,
						dcp_type_id,
						salarie_planning

						)

						VALUES (

						'$salarie_dcp_date_debut',
						'$salarie_dcp_heure_debut',
						'$salarie_dcp_date_fin',
						'$salarie_dcp_heure_fin',
						$salarie_idd,
						'$dcp_type_id',
						'$salarie_planning'








 )") ;
			 }




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


				$salarie_dcp_id= $_POST['salarie_dcp_id'] ;
$salarie_dcp_date_debuta= date2int_DSI($_POST['salarie_dcp_date_debut']) ;
// $salarie_dcp_date_fina= dateMCPROint($_POST['salarie_dcp_date_fin']) ;


if($_POST['salarie_dcp_date_fin']=="")
{
	$salarie_dcp_date_fina= NULL;

	// exit() ;
}
else
{
$salarie_dcp_date_fina= date2int_DSI($_POST['salarie_dcp_date_fin']) ;
}

						$salarie_dcp_date_debut= $salarie_dcp_date_debuta ;
						$salarie_dcp_heure_debut=$_POST['salarie_dcp_heure_debut'] ;
						$salarie_dcp_date_fin= $salarie_dcp_date_fina ;
						$salarie_dcp_heure_fin=$_POST['salarie_dcp_heure_fin'] ;
						$dcp_type_id=$_POST['dcp_type'] ;

	$salarie_planning = 0 ;

											if($dcp_type_id == 1 or $dcp_type_id == 10 or $dcp_type_id == 14  or $dcp_type_id == 28 ){
												$salarie_planning = 1;
											}


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

						dbi_query(" UPDATE salarie_dcp  SET

						salarie_dcp_date_debut = '$salarie_dcp_date_debut',
						salarie_dcp_heure_debut = '$salarie_dcp_heure_debut',
						salarie_dcp_date_fin =  '$salarie_dcp_date_fin',
						salarie_dcp_heure_fin =  '$salarie_dcp_heure_fin',


						dcp_type_id = '$dcp_type_id',
						salarie_planning = '$salarie_planning'
				where salarie_dcp_id = $salarie_dcp_id


				") ;
			 }



	$q= dbi_fetch_row(dbi_query("SELECT * FROM salarie where salarie_id = ".$salarie_id)) ;
// 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">







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

  <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">dcps </li>
           </ol>
         </div>
       </div>
     </div><!-- /.container-fluid -->
   </section>




 			   									   					  		  <?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
        }
       ?>


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


              <div class="card-body">
   <form action="" method="POST">

   <?php

   $q= dbi_query("SELECT * FROM salarie_dcp where salarie_id = ".$salarie_idd." ORDER BY `salarie_dcp`.`salarie_dcp_date_debut` DESC") ;
 				 if(!empty($_GET['salarie_dcp_id']))
			 {

				 $red= dbi_fetch_row(dbi_query("SELECT * FROM salarie_dcp where salarie_dcp_id = ".$_GET['salarie_dcp_id'])) ;
			     // echo "===>".$red['salarie_dcp_date_debut']."<br/>" ;
				 // echo "===>".$red['salarie_dcp_heure_debut']."<br/>" ;

				 $heurdeb = $red['salarie_dcp_heure_debut'] ;
				 $heurfin = $red['salarie_dcp_heure_fin'] ;


			 }
   ?>
 <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-2">
      <label>Demande du</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_dcp_date_demande" <?php if(!empty($red['salarie_dcp_date_demande']) ) echo "value=".int2date_autre_format($red['salarie_dcp_date_demande']) ;?> placeholder="jj/mm/aaaa">
                  </div>

    </div>


    <div class="form-group col-md-2">
      <label>du</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_dcp_date_debut" <?php if(!empty($red['salarie_dcp_date_debut']) ) echo "value=".int2date_autre_format($red['salarie_dcp_date_debut']) ;?> placeholder="jj/mm/aaaa">
                  </div>

   </div>


    <div class="form-group col-md-2">
       <label for="inputAddresse">Heure</label>


	<input type="time" id="appt"   class="form-control" name="salarie_dcp_heure_debut"  value="<?=$heurdeb?>" required>
  </div>
     <?php//  $chantier_fin =    int2date_autre_format($red['chantier_fin'])  ;  ?>
  <div class="form-group col-md-2">
      <label>Au</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_dcp_date_fin" <?php if(($red['salarie_dcp_date_fin'])!= 00000000) echo "value=".int2date_autre_format($red['salarie_dcp_date_fin']) ;?> placeholder="jj/mm/aaaa" >
                  </div>
	 </div>


	 <div class="form-group col-md-2">
      <label for="inputsociete">Heure</label>

	  <input type="time" id="appt"   class="form-control" name="salarie_dcp_heure_fin"  value="<?=$heurfin?>" >

   </div>

    <div <div class="form-group col-md-2"><!-- Liste déroulante statut -->
                <label>Motif</label>
                <select class="form-control" name="dcp_type">
                          <?php
				while($etabs = dbi_fetch_row($req))
				{

				?>
					<option value="<?=$etabs['dcp_type_id'] ?>"  <?php if($red['dcp_type_id'] == $etabs['dcp_type_id'] )echo 'selected' ;  ?> ><?=$etabs['dcp_type_description'] ?></option>
					<?php
				}

				?>
                </select>
    </div>






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




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




  <?php
  if(!empty($red['salarie_dcp_id']))
  {
  ?>
  <input type="hidden" name="salarie_dcp_id" value="<?=$red['salarie_dcp_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">
      <div class="row">
        <div class="col-12">

            </div>
            <!-- /.card-header -->
            <div class="card-body">
                <!-- <table id="example1" class="table table-hover">    *********** j'ai enlevé id pour que le trie fonctionne -->
			   <table id="" class="table table-bordered table-hover">
                <thead>
                <tr>
                  <th>Date de la demande</th>
                  <th>Date de début</th>     		<!-- /.Table Client - Champs client_nom -->
                  <th align="center">Heure</th> 		<!-- /.Table Client - Champs client_adr1 -->
                  <th>Date de fin</th> 	<!-- /.Table Client - Champs client_cp -->
                  <th align="center">Heure</th>		<!-- /.Table Client - Champs client_ville -->
                  <th>Motif</th>
				  <th></th>


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

					if($cl['salarie_dcp_date_fin'] ==00000000)
						$dateFin = "Pas date de Fin" ;
					else
					$dateFin = int2date($cl['salarie_dcp_date_fin']) ;

				// echo "==> $dateFin " ;

					list($motif)= dbi_fetch_row(dbi_query("SELECT dcp_type_description FROM `dcp_type` where dcp_type_id =".$cl['dcp_type_id'])) ;
					?>

					<tr>
                  <td></td>
                  <td><?=int2date($cl['salarie_dcp_date_debut'])?></td>
                 <td align="center"><?=$cl['salarie_dcp_heure_debut'] ?></td>
                <td><?=$dateFin?></td>
                 <td align="center"><?=$cl['salarie_dcp_heure_fin'] ?></td>
				 <td><?=$motif ?></td>

				<td>

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

			       </a>

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

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