<?php

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

 include('file_tache.php');
 $client_id=$_SESSION["client_id"] ;


function string2url($chaine) {
 $chaine = trim($chaine);
 $chaine = strtr($chaine, "A?A???à?â?????O?????ô???EEEEèéêëCç??II??îïU?UUù?ûü???","aaaaaaaaaaaaooooooooooooeeeeeeeecciiiiiiiiuuuuuuuuynn");
 $chaine = strtr($chaine,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","abcdefghijklmnopqrstuvwxyz");
 $chaine = preg_replace('#([^.a-z0-9]+)#i', '-', $chaine);
        $chaine = preg_replace('#-{2,}#','',$chaine);
        $chaine = preg_replace('#-$#','',$chaine);
        $chaine = preg_replace('#^-#','',$chaine);
 return $chaine;
}


if(isset($_POST['dom_client']) && isset($_POST['actionform']) && $_POST['actionform']=='Enregistrer')
{
// print_r($_POST);
$dom_client=addslashes($_POST['dom_client']);
$info_tel=addslashes($_POST['info_tel']);
$mat_prod=addslashes($_POST['mat_prod']);
$instr_tra=addslashes($_POST['instr_tra']);
$url_map = addslashes($_POST['url_map']);
dbi_query ("INSERT INTO ".instructions." VALUES ('', '$dom_client','$info_tel', '$mat_prod', '$instr_tra','$client_id','$agence','$url_map')");
}
if(isset($_POST['dom_client']) && isset($_POST['actionform']) && $_POST['actionform']=='Modifier')
{
// print_r($_POST);
$instr_id=$_POST['instr_id'];
// $dom_client=string2url($_POST['dom_client']);
// $info_tel=addslashes($_POST['info_tel']);
// $mat_prod=addslashes($_POST['mat_prod']);
// $instr_tra=addslashes($_POST['instr_tra']);$url_map = $_POST['url_map'];
dbi_query ("UPDATE ".instructions." SET dom_client='".(addslashes($_POST['dom_client'])).
"', info_tel='".(addslashes ($_POST['info_tel']))."', url_map='".(addslashes($_POST['url_map']))."', mat_prod='".(addslashes($_POST['mat_prod']))."', instr_tra='".(addslashes ($_POST['instr_tra'])).
"' WHERE  instr_id = '".$instr_id."'");

// echo "UPDATE ".instructions." SET dom_client='".(addslashes($_POST['dom_client'])).
// "', info_tel='".(addslashes ($_POST['info_tel']))."', url_map='".(addslashes($_POST['url_map']))."', mat_prod='".(addslashes($_POST['mat_prod']))."', instr_tra='".(addslashes ($_POST['instr_tra'])).
// "' WHERE  instr_id = '".$instr_id."' <br/>" ;
// exit() ;

header('Location:fcinstruction.php?msg=Instruction bien Modifié&color=success');
}

$intructions= dbi_query("SELECT * FROM ".instructions." WHERE  client_id=$client_id ") ;
$i=dbi_fetch_row($intructions);
if($i){
$instr_id=$i['instr_id'];
$dom_client=stripslashes ($i['dom_client']);
$info_tel=stripslashes ($i['info_tel']);
$mat_prod=stripslashes ($i['mat_prod']);
$instr_tra=stripslashes ($i['instr_tra']);
$url_map=stripslashes ($i['url_map']);

$_GET['action']='edit';
}



	// if($_GET['action']=='sup')
	    // {
			// $contact_id=$_GET['id'];

	// $sreussie=dbi_query("DELETE FROM ".contact." WHERE contact_id = $contact_id") ;

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

		// }

	// if($_POST['modifier']== "modifier" )
	// {



	// $contact_nom=addslashes($_POST['contact_nom']);
	// $contact_pnom=addslashes($_POST['contact_pnom']);
	// $contact_fonction=addslashes($_POST['contact_fonction']);
	// $contact_tele1=addslashes($_POST['contact_tele1']);
	// $contact_tele2=addslashes($_POST['contact_tele2']);
	// $contact_email=addslashes($_POST['contact_email']);

			// dbi_query(" UPDATE contact SET contact_nom = '$contact_nom', contact_pnom = '$contact_pnom',  contact_fonction = '$contact_fonction', `contact_tele1` = '$contact_tele1', contact_tele2 = '$contact_tele2', contact_email = '$contact_email' WHERE contact_id = ".$_POST['contact_id']);


	// }







			 // $qq =dbi_query("SELECT * FROM `categorie`") ;


			 // if(!empty($_POST) AND $_POST['modifier']!= "modifier")
			 // {

		 // echo "$cleint_id <br/>" ;
                       // $contact_nom=$_POST['contact_nom'] ;
					    // $contact_pnom=$_POST['contact_pnom'] ;
						// $contact_fonction=$_POST['contact_fonction'] ;
						// $contact_tele1=$_POST['contact_tele1'] ;
						// $contact_tele2=$_POST['contact_tele2'] ;
						// $contact_email=$_POST['contact_email'] ;


					// dbi_query(" INSERT INTO  contact (
					// contact_nom,
					// contact_pnom,
					// contact_fonction,
					// contact_tele1,
					// contact_tele2,
					// contact_email,
					// client_id
 // )
 // VALUES
 // (

 // '$contact_nom',
 // '$contact_pnom',
 // '$contact_fonction',
 // '$contact_tele1',
 // '$contact_tele2',
 // '$contact_email',
 // '$client_id'
// )") ;

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

$q= dbi_fetch_row(dbi_query("SELECT * FROM client where client_id = ".$client_id)) ;

?>


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


	  <li>
    <!-- bouton lfouK-->
	  </li>



    </ul>

 <!-- liens TOP MENU DROITE -->
    <ul class="navbar-nav ml-auto">
     <!-- Placer ici l'élément à positionner à droite du TOP MENU -->
    </ul>

  </nav>  <!-- fin du TOP MENU -->




<!-- BARRE DE NAVIGATION -->
<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" 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="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['client_nom'] ; ?> &nbsp - &nbsp <?php echo $q['client_cp'] ; ?> &nbsp <?php echo $q['client_ville'] ; ?> </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="clients2.php">Clients</a></li>
              <li class="breadcrumb-item active"> Instructions </li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>


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

    <!-- PAGE PRINCIPALE -->



  <div class="col-lg-12">
    <div class="card card-secondary">
        <?php include('menu_client_haut.php'); ?>
    </div>

    <div class="card">
      <div class="card-body">
        <section class="content">



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


            <?php
			 $qm = dbi_query("SELECT * FROM contact where  client_id = '$client_id'") ;
			?>


            <!-- /.card-header -->
            <div class="card-body">

			 <form id="form_instr" name="form_instr" method="POST" action="">




  <div class="form-row">





            <!-- /.card-header -->
			    <div class="form-group col-md-12">

            <strong color="red">  <span class="p-3 mb-2 bg-secondary text-white" > <i class="fas fa-bus"></i> Accès au domicile du client    </span>                </strong>
            <br/>


                <textarea class="textarea" placeholder="Place some text here"
                          style="width: 100%; height: 200px; font-size: 18px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="dom_client"  > <?php if(isset($dom_client)) echo $dom_client;?></textarea>
              </div>




                <div class="form-group col-md-12">
              <strong color="red"> <span class="p-3 mb-2 bg-secondary text-white" > <i class="fas fa-phone"></i> Intsructions pour le télépointage   </span>                </strong>
                  <br/>


                <textarea class="textarea" placeholder="Place some text here"
                          style="width: 100%; height: 200px; font-size: 18px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="info_tel"  > <?php if(isset($info_tel)) echo $info_tel;?></textarea>
              </div>


              <div class="form-group col-md-12">
                <strong color="red"> <span class="p-3 mb-2 bg-secondary text-white" > <i class="fas fa-archive"></i> Matériel et produits   </span>                </strong>
                    <br/>


                <textarea class="textarea" placeholder="Place some text here"
                          style="width: 100%; height: 200px; font-size: 18px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="mat_prod"  > <?php if(isset($mat_prod)) echo $mat_prod;?> </textarea>
              </div>



	   <div class="form-group col-md-12">
       <strong color="red"> <span class="p-3 mb-2 bg-secondary text-white" > <i class="fas fa-bars"></i> Intsructions de travail   </span>                </strong>
           <br/>


                <textarea class="textarea" placeholder="Place some text here"
                          style="width: 100%; height: 200px; font-size: 18px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="instr_tra"  > <?php if(isset($instr_tra)) echo $instr_tra;?>  </textarea>
              </div>



	   <div class="form-group col-md-12">
       <strong color="red"> <span class="p-3 mb-2 bg-secondary text-white" > <i class="fas fa-map"></i> URL Google Map  </span>                </strong>
           <br/>


                <textarea class="textarea" placeholder="Place some text here"
                          style="width: 100%; height: 200px; font-size: 18px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" name="url_map"  > <?php if(isset($url_map)) echo $url_map;?>  </textarea>
              </div>


	 <br/>
	<div align="center">
	 <?php if( isset($_GET['action']) && $_GET['action']=='edit' ){?>
      <input type="submit" class="btn btn-primary"  name="actionform" value="Modifier" onclick="return valider()" />
	  <input type="hidden" name="action" value="Modifier"/>
	  <input type="hidden" name="instr_id" value="<?=$instr_id?>"/>


    <?php } else{ ?>
	  <input type="submit" class="btn btn-primary" name="actionform" value="Enregistrer" onclick="return valider()" />

<?php } ?>
	</div>
	</div>
</form>



            </div>
            <!-- /.card-body -->
          </div>
          <!-- /.card -->
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->
    </section>
    <!-- /.content -->
  </div>
  <!-- NE PAS TOUCHER AU DESSUS DESSOUS -->









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

<script type="text/javascript">
$(document).ready(function(){
    $('#myModal').on('show.bs.modal', function (e) {
        var rowid = $(e.relatedTarget).data('id');
        $.ajax({
            type : 'post',
            url : 'ajaxModifierContact.php', //Here you will fetch records
            data :  'rowid='+ rowid, //Pass $id
            success : function(data){
            $('#fetch').html(data);//Show fetched data from database
            }
        });
     });
});


</script>
<script src="../../plugins/summernote/summernote-bs4.min.js"></script>
<script>
  $(function () {
    // Summernote
    $('.textarea').summernote()
  })
</script>

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