<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// error_reportinog(E_ALL);
// ini_set("display_errors", 1);
// exit() ; 
// error_reporting(E_ALL);
// ini_set("display_errors", 1);


// ini_set('display_errors','Off');
// ini_set('error_reporting', E_ALL );
define('WP_DEBUG', false);
define('WP_DEBUG_DISPLAY', false);
// ini_set('memory_limit', '1000M');

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

										if(!empty( $_GET["id_etab"]))
										{
										$_SESSION["id_etab"] = $_GET["id_etab"];
										}
										
										
									

if(isset($_POST['fact']) && isset($_POST['save']))
{
	// echo "<pre>" ;
	// print_r($_POST) ; 
	// echo "</pre>" ;
	// date2int_DSI() ; 
	// exit() ; 
	foreach($_POST['fact'] as $id => $montant){
		if($montant) {

			//payerFacture($id, $montant, $_POST['mode'][$id]) ;
			payerFacture($id, $montant, $_POST['mode'][$id],NULL, $_POST['chek'][$id], $_POST['bank'][$id],$_POST['date_reg'][$id]) ;
			}
		}
}
elseif(isset($_POST['relance']) )
{
	include 'includes/factureV3.php';
	$clients_relances = array();
	
	foreach($_POST['fact'] as $id => $montant) 
	{
		// on relance pour chaque facture
		$f = new Facture ($id, true);
		list($relance, $fact_id, $client_id) = dbi_fetch_row(dbi_query("SELECT relance, fact_id, client_id FROM ".TABLE_FACT." WHERE fact_id = ".$id));
		$relance++;

		if (!is_dir("factures/$client_id"))
		{
			mkdir("factures/$client_id", 0755) ;
			chmod("factures/$client_id", 0755) ;
		}

		$f->Output("factures/$client_id/$id-$relance.pdf", 'F');
		
		dbi_query("UPDATE ".TABLE_FACT." SET relance = $relance WHERE fact_id = ".$fact_id) ;
		
		if(!in_array($client_id,$clients_relances)) $clients_relances[]=$client_id;
		
	}
	
	foreach($clients_relances as $client_id)
	{
		$email = dbi_fetch_row(dbi_query("SELECT client_email, client_fmail FROM ".TABLE_CLIENT." WHERE client_id='$client_id' AND agence_id = '$agence'")) ;
		
		if($email['client_email']!='' && $email['client_fmail']=='1') envoyer_email('relance',$client_id);
		
	}
	
}

?>
		                             <script language="Javascript">
										   function GetIdBureauB()
										   {
												var id_etab="";
											  id_etab = document.client_statu_form.client_etab.value ;
											if( id_etab > 0 || id_etab=="INDEFINI" )
											  window.location = "reglement_nv_nv.php?id_etab="+id_etab;
												else
											window.location = "reglement_nv_nv.php";
										   }
									</script>
<?
$order  = " c.client_nom ASC " ; 
if($_SESSION["id_etab"]== 2 ){
	  $order  = " c.reglement_id ASC " ; 
	}elseif($_SESSION["id_etab"]== 3) {
		
     $order  = " f.num_fact ASC " ; 	
	}
	else{
		$order  = " c.client_nom ASC " ; 
	}

 
$query = dbi_query("SELECT f.client_id, client_pnom, client_nom, f.num_fact, c.client_reglement,c.reglement_id, 
f.fact_id, total,total-sum(if(p.montant is null, 0, p.montant))-sum(if(a.montant is null, 0, a.montant)) AS paye,
if(a.montant is null, 0, a.montant) avoir,
f.date_fact, f.relance, IF(client_genre='SERENA',1,0) as serena
FROM ".TABLE_FACT." f
LEFT JOIN ".TABLE_PAIEMENT." p ON f.fact_id=p.fact_id AND f.client_id=p.client_id
LEFT JOIN ".TABLE_AVOIR." a ON f.fact_id = a.fact_id
LEFT JOIN ".TABLE_CLIENT." c ON c.client_id = f.client_id
WHERE f.agence_id=$agence
GROUP BY date_fact, f.fact_id, total
HAVING paye > 0.001
ORDER BY serena, ".(empty($order) ? 'num_fact' : $order)) ;



// }

$total_paye=0;
$total_serena=0;
$total_clients=0;
$total_cesu=0;
$total_prelevement=0;
$total_cheque=0;
$total_virement=0;
$total_especes=0;
$serena=0;
		
while($f = dbi_fetch_row($query))
{
	if ($f['serena']) $total_serena+=$f['paye'];
	else $total_clients+=$f['paye'];
	$total_paye+=$f['paye'];
	
	switch ($f['reglement_id']) {
		case 1:
			$total_prelevement+=$f['paye'];
		break;
		case 2:
			$total_cheque+=$f['paye'];
		break;
		case 3:
			$total_cesu+=$f['paye'];
		break;
		case 4:
			$total_virement+=$f['paye'];
		break;
		case 5:
			$total_especes+=$f['paye'];
		break;
	}
}
mysqli_data_seek($query,0);
// print_header ();


?>
<!DOCTYPE html>
<html>

<head>
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
 <!-- Enregistrer le titre de la page --><title> LogMCPRO</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">

												<!-- Google Font: Source Sans Pro -->
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
    <style>
.myCollapse {
    display: none;
}
.myCollapse.in {
    display: block;
}
  .modal-header {
    padding: 15px;
    border-bottom: 1px solid #e5e5e5;
}
  .modal-header {
    background: #226faa;
    background: -webkit-gradient(linear,left top,right top,from(#226faa),color-stop(37%,#2989d8),to(#72c0d3));
    background: linear-gradient(to right,#226faa 0,#2989d8 37%,#72c0d3 100%);
    border-radius: 6px;
    color: #fff;
    padding: 18px;
    border-bottom-left-radius: 0;
    border-bottom-right-radius: 0;
    border-color: transparent;
}

.modal-header .close {
    margin-top: -3px;
    font-size: 24px;
    font-weight: 400;
    color: #fff;
    opacity: .9;
    width: 28px;
    height: 28px;
    padding-bottom: 0;
    padding-left: 1px;
}
button.close {
    padding: 0;
    cursor: pointer;
    background: 0 0;
    border: 0;
    -webkit-appearance: none;
    -moz-appearance: none;
    appearance: none;
}



  </style>
  <!-- DataTables -->
  <link rel="stylesheet" href="../plugins/datatables-bs4/css/dataTables.bootstrap4.css">
  												<!-- overlayScrollbars -->
  <link rel="stylesheet" href="../dist/css/adminlte.min.css">
</head>

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

		<nav class="main-header navbar navbar-expand navbar-white navbar-light">
			<!-- Menu extensible -->
			<ul class="navbar-nav">

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


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

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

 <!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->
 <!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
		<div class="content-wrapper">
			<!-- Content Header (Page header) -->
			<div class="content-header">
			  <div class="container-fluid">
				<div class="row mb-2">
				  <div class="col-sm-6">
					<h1 class="m-0 text-dark"></h1>
				  </div><!-- /.col -->
				  <div class="col-sm-6">

				  </div><!-- /.col -->
				</div><!-- /.row -->
			  </div><!-- /.container-fluid -->
			</div>
			<!-- /.content-header -->





			<!-- PAGE PRINCIPALE -->
			<div class="content">
				<div class="container-fluid">
					<div class="row">

						<!-- DEFINITION DES COLONNES -->


					  <!-- PASSAGE A LA COLONNE DE DROITE-->
						<div class="col-lg-12">							
							<div class="row">
								<div class="col-lg-12">
								  <!-- CARD DE DROITE-->
									<div class="card card-info">
                    <div class="card-header">

        							<h3 class="card-title"> <i class="far fa-flag"></i>       ENREGISTREMENT DES REGLEMENTS  </h3>
        							</div>

										<div class="card-body">
											<!-- ><section class="content"> CARD DE DROITE-->
											<?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  }
												// $q = dbi_query("SELECT * FROM ".TABLE_PAIEMENT." p LEFT JOIN ".TABLE_FACT." f USING(fact_id) LEFT JOIN reglementt r USING(reg_id) where p.client_id = '$client_id' AND p.agence_id='$agence' order by num_fact DESC") ;
												// if(mysqli_num_rows($q))
												// {
												?><br clear="all" />
												<div id="tab">
												<div class="box-body">
												
												
												
                 <form id="client_statu_form" name="client_statu_form" method="POST"  action="">
					    <div class="form-row">
				
		                        <div class="form-group col-md-6">
								  <div class="input-group">
									<?php  $qa = dbi_query("SELECT * FROM `etablissement`") ;  ?>
								<select class="form-control select" style="width: 100%;" id="client_etab" name="client_etab" onchange="GetIdBureauB()"; >
									<option value="1" <?php if($_SESSION["id_etab"]== 1 ){echo "selected"  ;} ?>  >Par nom </option>
									<option value="2" <?php if($_SESSION["id_etab"]== 2 ){echo "selected"  ;} ?>  >Par type </option>
									<option value="3" <?php if($_SESSION["id_etab"]== 3 ){echo "selected"  ;} ?>  >Par N° facture </option>
								</select>







									</div>
								</div>
						</div>	
				 </form>												
												
<form name ="formhatim"action="<?=$_SERVER['REQUEST_URI']?>" method="post">
<table align="center" width="100%" >
  <tr>
<td width="50%">
    <div align="center">
        <div class="rbroundbox_g_s" align="center" valign="middle" style="width:220px; font-size:large; margin-top:15px; background-color: #f2f2f2; border: 1px solid #ccc; border-radius: 8px; padding: 10px;">
            <div align="center" valign="middle" class="rbtop_g_s"></div>
            <div align="center" class="rbcontent_g_s" valign="middle">
                <div style="font-size:18px; margin-bottom: 10px;">Solde : <span style="color: #337ab7;"><?=$total_paye?> €</span></div>
                <div style="font-size:14px; line-height: 1.5;">
                    Clients : <span style="color: #5cb85c;"><?=$total_clients?> €</span><br />
                <!--     Serena : <span style="color: #d9534f;"><? //=$total_serena?> €</span>  -->
                </div>
            </div>
            <div align="center" valign="middle" class="rbbot_g_s"></div>
        </div>
    </div>
</td>

<td width="50%">
    <div align="center">
        <div class="rbroundbox_g_s" align="center" valign="middle" style="width:220px; font-size:large; margin-top:15px; background-color: #f2f2f2; border: 1px solid #ccc; border-radius: 8px; padding: 10px;">
            <div align="center" valign="middle" class="rbtop_g_s"></div>
            <div align="center" class="rbcontent_g_s" valign="middle">
                <div style="font-size:18px; margin-bottom: 10px;">Prélèvement : <span style="color: #337ab7;"><?=$total_prelevement?> €</span></div>
                <div style="font-size:14px; line-height: 1.5;">
                    Chèque : <span style="color: #5cb85c;"><?=$total_cheque?> €</span><br />
                    CESU : <span style="color: #d9534f;"><?=$total_cesu?> €</span><br />
                    Virement : <span style="color: #f0ad4e;"><?=$total_virement?> €</span><br />
                  <!--  Espèces : <span style="color: #5bc0de;"><? // =$total_especes?> €</span><br /> -->
                </div>
            </div>
            <div align="center" valign="middle" class="rbbot_g_s"></div>
        </div>
    </div>
</td>


  </tr>
 <tr>
    <td colspan="2" align="center">
        <input class="btn btn-primary" type="submit" name="save" value="Enregistrer les règlements saisis" class="bigbutton">
    </td>
    <td>
        <!-- <input type="submit" name="relance" value="Relancer les factures non-réglées" class="bigbutton"> -->
    </td>
</tr>


	<tr> <td> </td> </tr>	<tr> <td> </td> </tr>	

												
												
												
												<table id="" class="table table-hover">
												<thead>
												     <td  class="td_listingb"></td>
													  <td width="6%" class="td_listin1b" align="">N°</td>
													  <td width="18%" class="td_listig1b" align="">Client</td>
													  <td width="10%" class="td_listig1b" align="">Net &agrave; payer</td>
													  <td width="15%" class="td_listig1b" align="">Reçu</td>
													  <td width="15%" class="td_listig1b" align="">Type de réglement</td>
													  <td width="10%" class="td_listin1b" align="">N° cheque</td>
													  <td width="10%" class="td_listng1b" align="">Banque</td>
													  <td> Date de réglement </td>
													  <td width="10%" class="td_lising1b" align="">Date</td>
													 
													  <td width="5%" class="td_listng1b" align="">PDF</td>
													
												</thead>
												       <?php


												$compteur=0;
												$previous=1;
												$serena=0;
														$c = 0 ; 
														$b = 1000 ;
														$yas = 10000 ; 
													while($f = dbi_fetch_row($query))
													{
														if (!($compteur % 2)) $style='td_listing0';
														else $style='td_listing1';
														$compteur++;
														
														$icone  = '<img src="images/icones/client.png" width="16" height="16" border="0" alt="">';

														$serena=$f['serena'];
														if (($serena)&&!($serenap)) echo '<tr><td class="td_listing0" colspan="12" style="padding-left:10px; height=20px">
														<h2>Serena</h2></td></tr>';
														if ($serena) $icone  = '<img src="images/icones/serena.gif" width="16" height="16" border="0" alt="">';
														$serenap=$f['serena'];
														
												?>
											<tbody>
												        <tr>
          <TD class="<?=$style?>"><?=$icone?></TD>
          <td align="" class="<?=$style?>" style="padding:8px">FA-
            <?=$f['num_fact']?></td>
          <td align="left" class="<?=$style?>" style="padding:8px">   <a href="fcfacturation3.php?client_id= <?php echo $f['client_id'] ; ?>" target="" > 
            <?=strtoupper($f['client_nom']).' '.ucwords(strtolower($f['client_pnom']))?>
            </a></td>
			
          <td align="" class="<?=$style?>" style="padding:8px" ><input type="hidden" id="<?=$c?>"  value="<?=number_format($f['paye'], 2, ', ', '')?>"> <?=number_format($f['paye'], 2, ', ', '')?>
            &euro;
            <?=($f['avoir'] > 0) ? '<br>(avoir de '.number_format($f['avoir'], 2, ', ', ' ').' &euro;)' : ''?> </td>
			<script>
function afficher(id,id1,id3) {
if(document.getElementById(id3).checked)
{
var testin =document.getElementById(id).value;
document.getElementById(id1).value=testin;
}
else
{
document.getElementById(id1).value="";
}
}
</script>
		<? 
		// echo "==>".$f['reglement_id']."<br/>" 
		
		?>
          <td  class="<?=$style?>" style="padding:8px"><input type="text" id="<?=$b?>" name="fact[<?=$f['fact_id']?>]" value="" size="6"> <input type="checkbox" id="<?=$yas?>" onclick="afficher(<?=$c?>,<?=$b?>,<?=$yas?>)"></td>
          <td  class="<?=$style?>" style="padding:8px"><?=get_drop_down_reglementt("mode[".$f['fact_id']."]", '', $f['reglement_id'])?></td>
          <td  class="<?=$style?>" style="padding:8px"><input type="text" name="chek[<?=$f['fact_id']?>]" value="" size="8"></td>
		  <?
		  if($f['reglement_id']== 2)
		  {
		  // echo "--->".$f['client_id'] ; 
		$client_id=   $f['client_id']  ; 
		  $bnk = dbi_fetch_row(dbi_query("SELECT * FROM `paiement`  WHERE client_id='$client_id' AND agence_id = '$agence' ORDER BY `paiement`.`paiement_id`  DESC limit 0,1")) ;
		  // echo $bnk  ; 
		  
		  
		  // echo "kkk-".$bnk['banque'] ; 
		  ?>
          <td align="" class="<?=$style?>" style="padding:8px"><input type="text" name="bank[<?=$f['fact_id']?>]" value="<?=$bnk['banque']?>" size="8"></td>
		  <?
		  }
		  else
		  {
		  ?>
		  <td align="" class="<?=$style?>" style="padding:8px"><input type="text" name="bank[<?=$f['fact_id']?>]" value="" size="8"></td>
		  <?
		  }
		  ?>
		  <td> <input type="date" class="form-control" data-inputmask-alias="datetime" data-inputmask-inputformat="dd/mm/yyyy" data-mask name="date_reg[<?=$f['fact_id']?>]" placeholder="jj/mm/aaaa" value="<?php echo date('Y-m-d'); ?>"></td>
          <td align="" class="<?=$style?>" style="padding:8px"><?=int2date($f['date_fact'])?></td>
      
         
		 <td style=""><a href="code/fact.php?fid=<?=$f['fact_id']?>" target="_blank" class="btn btn-info btn-sm"> <i class="fas fa-eye"></i> </a>

													
            <?php
	if ($f['avoir'])
	{
		$qa = dbi_query("SELECT * FROM ".TABLE_AVOIR." WHERE fact_id = ".$f['fact_id']." AND agence_id = $agence") ;
		while($a = dbi_fetch_row($qa))
			printf('<br><a href="avoir.php?aid=%d" target="_blank">Avoir n&ordm;%d</a>', $a['avoir_id'], $a['num_avoir']);
	}
?></td>
        </tr>
        <?php
		 
		$b ++ ;$c ++ ; $yas ++ ; 
	}
	?>
														
												
												
											</tbody>
												</table>
												
												
												  <tr>
    <td colspan="2" align="center"><input class="btn btn-primary"  type="submit" name="save" value="Enregistrer les règlements saisis" class="bigbutton">
      &nbsp;&nbsp;&nbsp;
     <!-- <input type="submit" name="relance" value="Relancer les factures non-réglées" class="bigbutton"></td>  -->
  </tr>
</table>

													</div>
													   </div>
												
											


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


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

			</div>
				<!-- /.row -->
		</div><!-- /.container-fluid -->
    </div>


  <!-- 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 -->
  <footer class="main-footer">
    <div class="float-right d-none d-sm-block">
      <b>Version</b> 3.0.1
    </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>
<!-- DataTables -->
<script src="../plugins/datatables/jquery.dataTables.js"></script>
<script src="../plugins/datatables-bs4/js/dataTables.bootstrap4.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 () {
    // Summernote
    // $('.textarea').summernote()
  // }) ;



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

</script>

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