<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// $text = '<p>Test paragraph.</p><!-- Comment --> <a href="#fragment">Other text</a>';
// echo strip_tags($text);
// echo "\n";
// $str = "O'Reilly? Pour faire suite à notre échange téléphonique ce matin et notre échange d'arguments. ";
// echo addslashes($str);
// $fld_value =  str_replace ( "\"", "&quot;", $str ) ;
// echo ' $$$$$$$$$$$ '.$fld_value;
$pagemenu = basename($_SERVER["PHP_SELF"]) ;
$uid = $_GET['i'];
$date = $_GET['d'];
include_once('libbox/lib/class.imap3.php');
$email = new Imap();
$connect = $email->connect('{ssl0.ovh.net/pop3/ssl/novalidate-cert}INBOX','contact@mc-pro.fr','Nathalie2606' );

$inbox = $email->getMessages('html',$date);
// echo "$date";
// echo '<pre>';
// print_r($_POST);
// echo '</pre>';
// $inbox = $email->getFiles($_POST);

$Admin_ID = $_SESSION['MCPRO']['admin'];


$client = dbi_fetch_row( dbi_query("SELECT * FROM contact where  contact_email = '".$inbox['data'][0]['from']['address']."'") );

// echo '<pre>';
// print_r($client);
// echo '</pre>';
	
function selection_suivi ( $name='') {
	$str='<select class="form-control select2" style="width: 100%;"  name="'.$name.'" id="'.$name.'">';
	$suivi = dbi_query("SELECT suivi_intitule, suivi_id 
FROM suivi 
WHERE  `suivi_client` = '1'  ORDER BY suivi_ordre") ;
	while ($a = dbi_fetch_row($suivi))
	{
		$str.='<option value="'.$a['suivi_id'].'">'.$a['suivi_intitule'].'</option>';
		$str.='<option value="'.$a['suivi_id'].'"'.($a['suivi_id']==28?' selected="selected"':'').'>'.$a['suivi_intitule'].'</option>';
	}
	$str.='</select>';
	return $str;
}

function selection_biais ($suivi_biais=0, $name='') {
	$str='<select name="'.$name.'">';
	$suivi = dbi_query("SELECT suivi_biais_intitule, suivi_biais_id FROM suivi_biais ORDER BY suivi_biais_ordre") ;
	while ($a = dbi_fetch_row($suivi))
	{
		$str.='<option value="'.$a['suivi_biais_id'].'"'.($a['suivi_biais_id']==$suivi_biais?' selected="selected"':'').'>'.$a['suivi_biais_intitule'].'</option>';
	}
	$str.='</select>';
	return $str;
}

function selection_biais_suiviPP2 ($name='',$suivi_biais=0 , $idd=0) {
	$str='<select class="form-control select2" required style="width: 100%;"  name="'.$name.'" id="'.$name.'">';
	// $str.='<option value="" selected > ----- choisir Action ---- </option>';
	// $suivi = dbi_query("SELECT suivi_biais_intitule, suivi_biais_id FROM suivi_biais WHERE  suivi_parentt > 0 AND  suivi_parentt IN ( SELECT suivi_biais_id FROM suivi_biais ) ORDER BY ordre") ;
	$suivi = dbi_query("SELECT suivi_biais_intitule, suivi_biais_id FROM suivi_biais where suivi_parentt = 28  ORDER BY ordre") ;
	while ($a = dbi_fetch_row($suivi))
	{
		$str.='<option value="'.$a['suivi_biais_id'].'"'.($a['suivi_biais_id']==$suivi_biais?' selected="selected"':'').'>'.$a['suivi_biais_intitule'].'</option>';
	}
	$str.='</select>';
	return $str;
}

function getPostDateH ()
{
	return date("Y-m-d H:i:s");
}

if(isset($_POST['suivi_biais_id']) && $_POST['suivi_biais_id'] > 0 ){
	
	
$Admin_ID = $_POST['admin_id']  ;
$suivi_id = $_POST['suivi_id']  ;
$suivi = dbi_fetch_row(dbi_query("SELECT * FROM suivi_biais WHERE  suivi_biais_id = '".$_POST['suivi_biais_id']."' ")) ; 
$suivi_parentt = $suivi['suivi_parentt'] ; 


$suivipar = dbi_fetch_row(dbi_query("SELECT * FROM test_suivi WHERE  suivi_id = '".$suivi_parentt."'  AND client_id = '".$_POST['client_id']."'  ") ); 
if(count($suivipar) > 0 ) 
{
	$suivi_parent_id = $suivipar['client_suivi_id'];
	
	// echo ' ************* ';
}
else
{
	
	dbi_query("INSERT INTO test_suivi (client_id, suivi_date, suivi_id,suivi_parent_id,client_suivi_clos,Admin_ID) 
	    VALUES ('".$_POST['client_id']."', '$date', '".$suivi_parentt."','0','0','".$Admin_ID."')");
	$suivi_parent_id = $conn->insert_id ;
	
}

$date_control = date("Ymd"); 
$today = date("Y-m-d H:i:s"); 
// echo $today ;
// ECHO "INSERT INTO test_suivi 
		// (client_id, suivi_date, suivi_id,suivi_biais_id, suivi_parent_id, annotation,Admin_ID, inter_id, suivi_programme, client_suivi_clos,date_control,today) 
// echo "INSERT INTO test_suivi 
		// (client_id, suivi_date, suivi_id,suivi_biais_id, suivi_parent_id, annotation,Admin_ID, inter_id, suivi_programme, client_suivi_clos,date_control,today) 
		
		// VALUES ('".$_POST['client_id']."', '$date', '".$suivi_id ."','".$_POST['suivi_biais_id']."', '".$suivi_parent_id."', '".nl2br($_POST['suivi_annotation'])."',  '".$Admin_ID."', '".$_POST['salarie_id']."', '1','0', '".$date_control."', '".$today."')";		
		// VALUES ('".$_POST['client_id']."', '$today', '".$suivi_parent_id ."','".$_POST['suivi_biais_id']."', '".$suivi_parent_id."', '".nl2br($_POST['suivi_annotation'])."',  '".$Admin_ID."', '".$_POST['salarie_id']."', '1','0', '".$date_control."', '".$today."')" ;

$suivi_annotation = mysqli_real_escape_string($conn, $_POST['suivi_annotation']);
dbi_query("INSERT INTO test_suivi 
		(client_id, suivi_date, suivi_id,suivi_biais_id, suivi_parent_id, annotation,Admin_ID, inter_id, suivi_programme, client_suivi_clos,date_control,today) 
		
		VALUES ('".$_POST['client_id']."', '$date', '".$suivi_id ."','".$_POST['suivi_biais_id']."', '".$suivi_parent_id."', '".nl2br($suivi_annotation)."',  '".$Admin_ID."', '".$_POST['salarie_id']."', '1','0', '".$date_control."', '".$today."')");
		
	
	




}

// $suivipar = dbi_fetch_row(dbi_query("SELECT * FROM test_suivi WHERE  suivi_biais_id = '".$suivi_parentt."'  AND client_id = '".$_POST['client_id']."'  ") ); 

// if($suivipar) 
// {

	// $suivi_parent_id = 	$suivipar['client_suivi_id'];
// }	
// elseif{
	// $suivi_parent_id = 0;
		// dbi_query("INSERT INTO test_suivi (client_id, suivi_date, suivi_id,suivi_parent_id,client_suivi_clos,Admin_ID) 
	    // VALUES ('".$_POST['client_id']."', '$date', '".$suivi_parentt."','0','0','".$Admin_ID."')");
		// $suivi_parent_id = $conn->insert_id ;
			// echo '<pre>';
// print_r($conn);
// echo '</pre>';
// }
// echo " **** ".$suivi_parent_id;
// $date = getPostDateH();
// echo "SELECT * FROM test_suivi WHERE  suivi_biais_id = '".$_POST['suivi_biais_id']."'  AND client_id = '".$_POST['client_id']."'  ";
// dbi_query("INSERT INTO test_suivi (client_id, suivi_date, suivi_id,suivi_parent_id,client_suivi_clos,Admin_ID) 
	// VALUES ('".$_POST['client_id']."', '$date', '".$suivi_parentt."','0','0','".$Admin_ID."')");
	
	
	
	
// echo "SELECT * FROM suivi_biais WHERE  suivi_biais_id = '".$_POST['suivi_biais_id']."' ";


	// $date_control = date("Ymd"); 
	// $today = date("Y-m-d H:i:s"); 
		// dbi_query("INSERT INTO test_suivi 
		// (client_id, suivi_date, suivi_id,suivi_biais_id, suivi_parent_id, annotation,Admin_ID, inter_id, suivi_programme, client_suivi_clos,Admin_ID_clos,date_control,today) 
		
		// VALUES ('".$_POST['client_id']."', '$date', '".$_POST['suivi_id']."','".$_POST['suivi_biais_id']."', '".$_POST['suivi_parent_id']."', '".nl2br($_POST['suivi_annotation'])."',  '".$Admin_ID."', '".$_POST['salarie_id']."', '1', '".$client_suivi_clos."', '".$Admin_ID_clos."', '".$date_control."', '".$today."')");
		
	
	
	
// echo "SELECT suivi_biais_id FROM suivi_biais WHERE  suivi_biais_id = '".$_POST['suivi_biais_id']."' ";
	// echo '<pre>';
// print_r($suivipar);
// echo '</pre>';
// }


?> 
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>MC PRO </title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta name="viewport" content="width=device-width, initial-scale=1">

  <!-- Font Awesome -->
  <link rel="stylesheet" href="../plugins/fontawesome-free/css/all.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="../dist/css/adminlte.min.css">
  <!-- Google Font: Source Sans Pro -->
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
  
  
  	<script>
function notification() {
	// alert(" jjj ");
$.ajax({
    url: "mailnotific.php", // Ton fichier ou se trouve ton chat
    success:
        function(retour){
        $('#NOT').html(retour); // rafraichi toute ta DIV "bien sur il lui faut un id "
    }
});
 
}
setInterval(notification, 10000);
// setInterval(refresh(), 3000); // Répète la fonction toutes les 10 sec
</script>

</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 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>
    </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 (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">
  
  <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark"><!--Dashboard --></h1>
          </div><!-- /.col -->
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb"></li>
              <li class="breadcrumb "></li>
            </ol>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
	
    <section class="content">
      <div class="container-fluid">
        <div class="row">


<div class="modal fade" id="myModal">
        <div class="modal-dialog modal-lg">
          <div class="modal-content">
            <div class="modal-header">
              <h4 class="card-title"><b><i class='far fa-clock'> Ajouter Un Suivi</i></b></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 action="" method="POST" id="my_form">
							
								<div class="form-row">
										












																					
									<div class="form-group col-md-6"><!-- Liste déroulante jour -->  
										<label>Type de suivi </label>
										<?php  echo selection_suivi( 'suivi_id')	?>

									</div>
										
									<div class="form-group col-md-6"><!-- Liste déroulante jour -->  
										<label>Action </label>
										<?php  echo selection_biais_suiviPP2( 'suivi_biais_id')	?>

									</div>
									<div class="form-group col-md-6"><!-- Liste déroulante jour -->  
										<label>Client concerné </label>
										<select class="form-control select2" style="width: 100%;" name="client_id" id="client_id">
											<?php
												
											$req =dbi_query("SELECT * FROM client WHERE client_statut = '1' ") ;
											while(  $sal=dbi_fetch_row($req)) { ?>
												<option value="<?php echo $sal['client_id'] ; ?>"  <?php if( $sal['client_id']== $client['client_id']) echo "SELECTED"  ; ?>><?php echo $sal['client_nom']; ?></option>
												<?php   } ?>
										</select>
									</div>
									
									<div class="form-group col-md-6"><!-- Liste déroulante jour -->  
										<label>Salarié concerné </label>
										<select class="form-control select2" style="width: 100%;" name="salarie_id" id="salarie_id">
										<option value="0">--- Aucun salarié --- </option>
											<?php
												
											$req =dbi_query("SELECT * FROM salarie WHERE salarie_statut = '1' ") ;
											while(  $sal=dbi_fetch_row($req)) { ?>
												<option value="<?php echo $sal['salarie_id'] ; ?>"  ><?php echo $sal['salarie_nom']." ".$sal['salarie_prenom']; ?></option>
												<?php   } ?>
										</select>
									</div>
									
									<div class="form-group col-md-6"><!-- Liste déroulante jour -->  
										<label>Administratif </label>
										<select class="form-control select" style="width: 100%;" id="admin_id" name="admin_id" >
											<?php 
												$etab=dbi_query("SELECT * FROM users where etat = '1'  ");
												while($et=dbi_fetch_row($etab)){ 
											?>
											<option value="<?php echo $et['Admin_ID'];?>" ><?php echo $et['user_nom']."  ".$et['user_prenom']?></option>
											<?php } ?>
										</select>

									</div>
									
									
									
									<div class="form-group col-md-4">
											<label>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" id="date" name="date" placeholder="jj/mm/aaaa" value='<?php echo date("Y-m-d");?>' required=""> 
											</div>
									</div>

									<div class="form-group col-md-2">
											<label for="inputAddresse">Heure</label>
											<input type="time" id="heure" min="05:00" max="22:00" class="form-control" name="heure" value="<?php echo date("H:i");?>" required="">
									</div>
									
									<div class="form-group col-md-12">
										<label for="inputAddresse">Désignation</label>
										<textarea class="textarea" placeholder="Placez du texte ici" style="width: 100%; height: 400px; font-size: 16px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="suivi_annotation"   >
										<?php 
											$str = strip_tags($inbox['data'][0]['message']);
											$str = addslashes(trim($str));
											echo $str;
											?>
										
										</textarea>
									</div>
									

							
									
									
									

								</div>  
						</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="nouvelle_action_suivi"  class="btn btn-primary" >Ajouter action</button>
							</form>
        </div>

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

		  
		  
		  
        <div class="col-md-12">
          <div class="card">
           
            <!-- /.card-header -->
            <div class="card-body">
              <div class="mailbox-read-info">
                <h5>Objet :<?php echo $inbox['data'][0]['subject']; ?></h5>
                <h6>De : <?php echo $inbox['data'][0]['from']['address'] ; ?>
                  <span class="mailbox-read-time float-right"><?php echo $inbox['data'][0]['date']; ?></span></h6>
              </div>

              <!-- /.mailbox-controls -->
              <div class="mailbox-read-message">
				<?php echo $inbox['data'][0]['message']; ?>
              </div>
              <!-- /.mailbox-read-message -->
            </div>
            <!-- /.card-body -->
            <div class="card-footer bg-white">
              <ul class="mailbox-attachments d-flex align-items-stretch clearfix">
			  
				<?php 
					foreach ($inbox['data'][0]['attachments'] as $key => $value) {
						$email->getFiles($inbox['data'][0]['attachments'][$key]);
						
						// $arr[3] sera mis à jour avec chaque valeur de $arr...
						// echo "{$key} => {$value} ";
						// print_r($arr);
						// echo $inbox['data'][0]['attachments'][$key]['file'].'<br>';
						$filename = 'mailattch/'.$inbox['data'][0]['attachments'][$key]['file'];
						$fas = 'camera';
						$ext = pathinfo($filename, PATHINFO_EXTENSION);
						// echo $ext.' ********** ';
						if( $ext == 'docx')
							$fas = 'file-word';
						elseif( $ext == 'pdf')
							$fas = 'file-pdf';
// echo $filename . ': ' . filesize($filename) . ' bytes';
				?>
				<li>
                  <span class="mailbox-attachment-icon has-img"><img style='width:100px;height:100px;' src="<?php echo $filename;?>" alt="Attachment"></span>

                  <div class="mailbox-attachment-info">
                    <a href="print.php?name=<?php echo $filename;?>" class="mailbox-attachment-name"><i class="fas fa-<?php echo $fas;?>"></i> <?php echo $inbox['data'][0]['attachments'][$key]['file'];?></a>
                        <span class="mailbox-attachment-size clearfix mt-1">
                          <span> <?php 
						  $taille = filesize($filename) ;
						  if($taille > 0 ) $taille = $taille / (1000*1024);
							  
						  echo number_format( $taille , 2, ',', ' ').' MB ';?> </span>
                          <a href="print.php?name=<?php echo $filename;?>" class="btn btn-default btn-sm float-right"><i class="fas fa-cloud-download-alt"></i></a>
                        </span>
                  </div>
                </li>
				<?php				
					}
				?>
              </ul>
            </div>
            <!-- /.card-footer -->
            <div class="card-footer">
		
				<div class="float-left">
					
				</div>
				<div class="float-right">
					<a href="<?php echo 'mailbox.php?action=delete&d='.$_GET['d'].'&i='.$_GET['i'];?>" class="btn btn-default btn-sm float-right"> <i class="far fa-trash-alt"></i> Supprimer l'Email </a>
				</div>
              
            </div>
            <!-- /.card-footer -->
          </div>
          <!-- /.card -->
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  <footer class="main-footer">
    <div class="float-right d-none d-sm-block">
      <b>Version</b> 3.0.2
    </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(){
   // $("#my_form").on("submit", function () {
        // var hvalue = $('.suivi_annotation').text();
        // $(this).append("<input type='hidden' name='suivi_annotation' value=' " + hvalue.trim() + " '/>");
    // });
	
			$("#suivi_id").on('change',function(){	
		var suivi_id = $(this).val();
				if(suivi_id > 0){
					$.ajax({
					type:'POST',
					url: 'ajaxmailsuivi.php',
					data:'suivi_id='+suivi_id,
					success:function(html){
						$("#suivi_biais_id").html(html);
						}
					});
				}					
		 });
});
</script>
<?php
// echo '<pre>';
// print_r( $inbox['data'][0]['attachments']);
// echo '</pre>';
 
// echo '<pre>';
// print_r($inbox);
// echo '</pre>';

// echo ' ---------------------------------------- ';
// echo '<pre>';
// print_r($inbox);
// echo '</pre>';
// echo '<pre>';
// print_r($inbox['attachments']);
// echo '</pre>';
// $ok = $email->getFiles($inbox['data'][0]['attachments'][0]);

// $OK = $email->getFiles($inbox['data'][0]['attachments'][0]);
// echo json_encode($ok);
?>
</body>
</html>