<?php

// echo "test fffffffffffffffffffffffffffffffff<br/>" ; 


// exit() ; 
// require __DIR__ . '/vendor_sms_recu/autoload.php';
// include 'includes_sms_recu/ovh.php';
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;



$a = dbi_query("SELECT * FROM `chantier`") ; 

while($b=dbi_fetch_row($a))
{
  if($b['chantier_debut']== $b['chantier_fin'])
  {
	  dbi_query("UPDATE chantier SET `chantier_recur` = '0' WHERE chantier_ID = ".$b['chantier_ID']) ; 
  }
	
}



				foreach ($messagesDetails as $messagesDetail) {
					
					
					
					
					// echo "<pre>" ; 
					// print_r($messagesDetail) ; 
					// echo "</pre>" ; 
					// echo "==>".$messagesDetail['sender']."<br/>" ;
					
					list($id_sms_recu) = dbi_fetch_row(dbi_query(" SELECT id_sms_recu FROM `sms_recu` WHERE `id` = ".$messagesDetail['id'])) ; 
					
					// echo "====>  $id_sms_recu <br/>" ; 
					if($id_sms_recu == "")
					{
						$date_only = date2int_DSI(substr($messagesDetail['creationDatetime'],0,10))  ;

						// echo "==> $date_only <br/>" ; 
						// exit() ; 
						
						$heure_only=substr($messagesDetail['creationDatetime'],11,5) ; 
						
						 $heure_forma = heure2int($heure_only) ; 
						dbi_query("INSERT INTO `sms_recu` (`id_sms_recu`, `id`, `message`, `sender`, `date_recu`, date_only ,heure_only,heure_forma) VALUES (NULL, '".$messagesDetail['id']."', '".addslashes($messagesDetail['message'])."', '".$messagesDetail['sender']."', '".$messagesDetail['creationDatetime']."', '".$date_only."', '".$heure_only."', '".$heure_forma."')") ; 
					
					
					    dbi_query("INSERT INTO `boit_send_receives` (`id_sms`, `message`, `number`, `date_full`, date_only ,heure_only,heure_forma,type) VALUES ('".$messagesDetail['id']."', '".addslashes($messagesDetail['message'])."', '".$messagesDetail['sender']."', '".$messagesDetail['creationDatetime']."', '".$date_only."', '".$heure_only."', '".$heure_forma."',1)") ; 
					
						
					}
					
					
					// exit() ; 
					
					
					$sender = str_replace('+33', '0',$messagesDetail['sender']);
					// echo "ddd==>$sender <br/>"  ;
					 
					  list($client_nom)=  dbi_fetch_row(dbi_query("SELECT client_nom  FROM contact con , client c  where contact_tele1 =  $sender and c.client_id = con.client_id ")) ; 
					
					// echo "===> ".$messagesDetail['creationDatetime']."<br/>" ; 
					// echo "===> ".substr($messagesDetail['creationDatetime'],0,10)."<br/>" ; 
					// echo "===> ".substr($messagesDetail['creationDatetime'],11,5)."<br/>" ; 
					
					
					}












list($nbr_sms) = dbi_fetch_row(dbi_query(" SELECT count(*) FROM `sms_recu` ")) ; 
				
list($value) = dbi_fetch_row(dbi_query("select value_sms  from  config_sms where  id = 1")) ; 



$notif = $nbr_sms - $value  ; 
				
				
				
				
				
// ini_set('display_errors','on');
// error_reporting(E_ALL);
  ?>

   <script language="Javascript">
   function GetIdBureau()
   {
		var id="";
  	  id = document.admin_form.admin_id.value ;
	if( id > 0 || id=="INDEFINI" )
	  window.location = "index.php?id="+id;
	  	else
	window.location = "index.php";
   }
</script>
<?php


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

if(!empty($_GET['id']))
{
	$_SESSION['MCPRO']['user_id']= $_GET['id']  ;
}


$today = date("Y-m-d H:i:s");  
$Admin_ID = $_SESSION['MCPRO']['admin'] ;
$user_id=$_SESSION['MCPRO']['user_id'] ; 



session_start();

if( !empty($_GET['d'])) {
$uid = $_GET['i'];
$date = $_GET['d'];
include_once('libbox/lib/class.imap3.php');
$email1 = new Imap();
$connect1 = $email1->connect('{ssl0.ovh.net/pop3/ssl/novalidate-cert}INBOX','contact@mc-pro.fr','Steeven2411' );
$inbox1 = $email1->delMessages('html',$date); 

}


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

		  
 // echo "<pre>" ; 
 // print_r($_POST) ; 
 // echo "<pre>" ; 
 $page="index.php"; 
 
 if(!empty($_POST['tache_date_fin']))
						{ 
 $tache_date_fin= dateformaint($_POST['tache_date_fin']) ;
						}
 // echo "==> $tache_date_fin <br/>" ; 
 // exit() ; 
          
		  $date_creation = date("Ymd");  
		  
						$tache_sujet=addslashes($_POST['tache_sujet']) ; 
						
						// $tache_date_fin=$_POST['tache_date_fin'] ; 
						
						$tache_Priorite=$_POST['tache_Priorite'] ;  
						$salarie_id=$_POST['salarie_id'] ; 
						$client_id=$_POST['client_id'] ; 
						$user_id=$_POST['user_id'] ; 
						$tache_designation=addslashes($_POST['tache_designation']) ;
			
						
					
					dbi_query(" INSERT INTO  tache (
					tache_sujet, 
					tache_date_fin,
					tache_Priorite, 
					salarie_id,	
					client_id,	 
					user_id,
			
					date_creation
 )
 VALUES 
 (
 
 '$tache_sujet',
 '$tache_date_fin',
 '$tache_Priorite',
 '$salarie_id',
 '$client_id',
 '83',

 '$date_creation'
 
)") ;

list($tache_idd)=dbi_fetch_row(dbi_query("SELECT max(tache_id) FROM `tache`")) ; 
header("Location:fetch_record.php?msg=tache bien ajouté&color=success&page=$page&rowid=$tache_idd");
			 }





?>
<!DOCTYPE html>
	 
<html>
			<head>

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


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

  <!-- Navbar -->
  <nav class="main-header navbar navbar-expand navbar-white navbar-light">
    <!-- Left navbar links -->
    <ul class="navbar-nav">
	
      <li class="nav-item">
        <a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
      </li>
	   <li>
		 <h3> <!--bouton -->  </h3>
		</li>
      <li class="nav-item d-none d-sm-inline-block">
        <a href="index.html" class="nav-link"><!--Accueil --></a>
      </li>
	 
      <li class="nav-item d-none d-sm-inline-block">
        <a href="#" class="nav-link"><!--Contact --></a>
      </li>
	  
	  
	  <?php if($notif !=0 ){ ?>
	   <li class="nav-item dropdown">
        <a class="nav-link" data-toggle="dropdown" href="#">
          <i class="far fa-bell"></i>
          <span class="badge badge-warning navbar-badge">M</span>
        </a>
        <div class="dropdown-menu dropdown-menu-lg dropdown-menu-right">
          <span class="dropdown-item dropdown-header"><?php echo $notif ;  ?> Notifications</span>
          <div class="dropdown-divider"></div>
          <a href="sms_.php" class="dropdown-item">
            <i class="fas fa-envelope mr-2"></i> <?php echo $notif ;  ?>  Nouveaux message
            <span class="float-right text-muted text-sm">1 mins</span>
          </a>
          
          <div class="dropdown-divider"></div>
          <a href="sms_recuuu.php" class="dropdown-item dropdown-footer">Voie tous les messages</a>
        </div>
      </li>
	  
	  <?php  }?>
    </ul>

    <!-- SEARCH FORM
    <form class="form-inline ml-3">
      <div class="input-group input-group-sm">
        <input class="form-control form-control-navbar" type="search" placeholder="Search" aria-label="Search">
        <div class="input-group-append">
          <button class="btn btn-navbar" type="submit">
            <i class="fas fa-search"></i>
          </button>
        </div>
      </div>
    </form>
 -->

	
  </nav>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
  <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>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
         <div class="container-fluid">
        <div class="row mb-2">



<div  class="modal fade" id="myModal" role="dialog" class="modal fade task-modal-single in" tabindex="-1"  aria-labelledby="myLargeModalLabel" >
  <div class="modal-dialog modal-lg">
    <div class="modal-content data">
		<div id="fetch" ></div>
		
           
        </div>
    </div>
</div>



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

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <!-- Small boxes (Stat box) -->
        <div class="row">
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-info">
              <div class="inner">
                <h3> </h3>
				
                <p>+LIVRAISON</p>
              </div>
              <div class="icon">
                <i class="ion ion-bag"></i>
              </div>
              <a  href="nvclivraison.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
		  
		  
          <!-- ./col -->
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-success">
              <div class="inner">
                <h3> </h3>

                <p>+CONTROLE</p>
              </div>
              <div class="icon">
                <i class="ion ion-stats-bars"></i>
              </div>
              <a  href="nvcontrole.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
          <!-- ./col -->
        
          <!-- ./col -->
      
		  
		
		  
		  
		  
		  
          <!-- ./col -->
        </div>
        <!-- /.row -->
        <!-- Main row -->
    
          <!-- Left col -->
		  
		  <?php
		  $Admin_ID = 83 ; 
		  // $suivi = dbi_query(" SELECT * FROM sous_tache st , tache t  where st.tache_id = t.tache_id AND sous_tache_status = 0 AND  st.user_id =  $Admin_ID  ") ; 
		   $suivi = dbi_query(" SELECT * FROM sous_tache st , tache t  where st.tache_id = t.tache_id AND sous_tache_status = 0 AND  st.user_id =  $user_id  ORDER BY st.sous_tache_date_fin ASC  ") ;
		  ?>

				<section class="content">
					<div class="row">
						<div class="col-12">
							<div class="card card-primary">
															
															
															
															
																	
														
															

									<div class="card-body">
									
									
					
									        	
																	
																	
										<div class="onglet_dotted">
											<div style="width:100%; float:left; vertical-align:top" class="header_ray">
												<div id="tab">
													<div class="box-body">
														<table id="" class="table table-hover">
			
														</table><!-- /.table -->
													</div><!-- /.box-body -->
												</div><!-- /.tab -->
											</div><!-- /.header_ray -->
										</div><!-- /.onglet_dotted -->
								    </div><!-- /.card-body -->
							    </div><!-- /.card card-primary card-outline -->
							</div> <!-- /.col-12 -->
						</div>  <!-- /.row -->
				</section> <!-- /.section -->
     
	
   
   	
				
        </div>
        <!-- /.row (main row) -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-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>
<!-- Page Script -->

<!-- AdminLTE for demo purposes -->
<script src="../dist/js/demo.js"></script>
<!-- <script src="libbox/loadingoverlay.js"></script> -->
<!-- jQuery -->
<script src="//code.jquery.com/jquery-2.1.1.min.js"></script>
<!-- Bootstrap -->
<script src="//cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha.6/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="../plugins/datatables/jquery.dataTables.js"></script>
<script src="../plugins/datatables-bs4/js/dataTables.bootstrap4.js"></script>
<!-- loading-overlay -->

<script>
  $(function () {
    $("#example1").DataTable();
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
    });
  });
</script>


<script src="../plugins/select2/js/select2.full.min.js"></script>

<script>
  $(function () {
    //Initialize Select2 Elements
    $('.select2').select2()

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

</body>
<?php

//vider la table automate_salarie on rempli cet table dans la page anomalies_salarie.php // include planning_prestation.php

dbi_query("TRUNCATE TABLE automate_salarie") ; 

?>
</html>