|
Server IP : 10.128.40.6 / Your IP : 216.73.217.20 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/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$where1="";
$where2="";
$selected="";
if($_GET['id'] && !empty($_GET['id']) )
{
if($_GET['id']>0)
{
$id=$_GET['id'];
$tabbursel=dbi_fetch_row((dbi_query('SELECT * FROM etablissement where etablissement_id='.$_GET['id']))) ;
$etablissement_id=$tabbursel['etablissement_id'];
$etablissement_nom=$tabbursel['etablissement_nom'];
$where1=" where etablissement_id != $etablissement_id ";
$where2=" AND etablissement_id = $etablissement_id ";
}
elseif($_GET['id']=="INDEFINI")
{
$where2=" ";
$etablissement_id=$_GET['id'];
$selected='selected="selected"';
}
}
if(!empty($_POST))
{
// echo '<pre>';
// print_r($_POST);
// echo '</pre>';
// exit() ;
}
$debut_de_ce_mois = sprintf("%04d%02d%02d", date('Y'), date('m'), 1);
$fin_de_ce_mois = sprintf("%04d%02d%02d", date('Y'), date('m'), date('t'));
// $salarie_contrat_date_debut= dateMCPROint($_POST['debu']) ;
// $salarie_contrat_date_debut= dateMCPROint($_POST['debu']) ;
if(!empty($_POST))
{
// echo "test <br/>" ;
$from = dateformaint($_POST['debut']) ;
$to = dateformaint($_POST['fin']) ;
// echo "$from == > $to <br/>" ;
// exit() ;
}
else
{
$from = date('Ym').'01' ;
$to = date('Ym').'31' ;
// echo "$from == > $to <br/>" ;
// $from=int2date_autre_format($from) ;
// $to=int2date_autre_format($to) ;
// ************************************************************************************************echo "$from == > $to <br/>" ;
// exit() ;
}
$debP = $datedebut = $from;
$finP = $datefin = $to;
$TotN = 0 ;
$TotS = 0 ;
// echo "==> $from ==> $to <br/>" ;
// $chant=dbi_query("SELECT * FROM chantier c, fact_chantier fc,client cl WHERE c.agence_id=".$agence." AND cl.client_id=c.client_id AND c.Chantier_ID=fc.Chantier_ID AND Chantier_recur='0' AND Chantier_fin between $from and $to $where2 ORDER BY client_nom ");
?>
<!DOCTYPE html>
<html>
<head>
<?php include('header.php'); ?>
</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">
<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">
<!-- 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>
<!-- 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>Evolution clients</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">Statistiques</a></li>
<li class="breadcrumb-item active">Evolution clients</li>
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<!-- PAGE PRINCIPALE -->
<section class="content">
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<div class="col-2">
<div class="info-box mb-2 bg-primary">
<div class="info-box-content">
<span class="info-box-text"><b> <h1><center><div id='TOTALREG'><?php echo number_format( $TOTALREG, 2, ',', ' ').'<sup style="font-size: 20px">€ </sup>';?></div></center></h1></b></span>
</div>
</div>
</div>
<table style="position:absolute; top:62px; right:24px;">
<form id="bureau_form" name="bureau_form" method="POST" action="sb.php">
<tr>
<td align="left" valign="top" class="td_listing0">
<select class="form-control" id="client_bureau" name="client_bureau" onchange="GetIdBureau()";>
<option selected="selected" value=""> Tous les Etablissements </option>
<?php if(isset($etablissement_id) && isset($etablissement_nom)) { ?>
<option selected="selected" value="<?=$etablissement_id ?>"><?=$etablissement_nom?></option>
<?php } ?>
<?php
$etab=dbi_query("SELECT * FROM `etablissement` $where1") or die(mysql_error());
while($et=dbi_fetch_row($etab)){ ?>
<option value="<?php echo $et['etablissement_id']?>"><?php echo $et['etablissement_nom'] ?></option>
<?php } ?>
<option <?=$selected ?> value="INDEFINI">INDEFINI</option>
</select>
</td>
</tr>
</form>
</table>
<br/>
<div class="onglet_dotted">
<div style="width:100%; float:left; vertical-align:top" class="header_ray">
<form action="" method="POST">
<div class="form-row">
<div class="form-group col-md-4">
<label>Du</label>
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text"><i class="far fa-calendar-alt"></i></span>
</div>
<?php $fromm = int2date_autre_format($from) ;
// echo "==>".$fromm."<br/>" ;
?>
<input type="date" class="form-control" placeholder="jj/mm/aaaa" name="debut" value='<?= $fromm ?>' >
</div>
</div>
<div class="form-group col-md-4">
<label>Au</label>
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text"><i class="far fa-calendar-alt"></i></span>
</div>
<?php
// echo "==>".$to."<br/>" ;
$too = int2date_autre_format($to) ;
// echo "==>".$too."<br/>" ;
?>
<input type="date" class="form-control" placeholder="jj/mm/aaaa" name="fin" value='<?= $too ?>' >
</div>
</div>
</div>
<button type="submit" class="btn btn-info">Afficher</button>
</form>
<br/><br/>
<?php
$chant=dbi_query("SELECT * FROM chantier c,client cl WHERE cl.client_id=c.client_id AND Chantier_debut between $from and $to $where2 AND chantier_recur = 1 ORDER BY client_nom ");
// echo "SELECT * FROM chantier c,client cl WHERE cl.client_id=c.client_id AND Chantier_debut between $from and $to $where2 AND chantier_recur = 1 ORDER BY client_nom <br/> " ;
?>
<div id="tab">
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<TR>
<TD bgcolor= "Gray" align="center" colspan=4 ><b> NOUVEAUX CHANTIERS </b></TD>
</tr>
<TR>
<th align="center">id</th>
<th align="center">Nom du client</th>
<th align="center">Etablissement</th>
<th align="center">Montant du chantier</th>
</TR>
</thead>
<tbody>
<?php while($c=dbi_fetch_row($chant)){
$tauxtva=$c['chantier_forfaitmensuel']*($c['Chantier_TVA']/100);
list($etablissement_nom) =dbi_fetch_row(dbi_query('select etablissement_nom from etablissement where etablissement_id ='.$c['etablissement_id'])) ;
?>
<TR>
<TD align="center"><?=$c['chantier_ID']?></TD>
<?php if($client_id!=$c['client_id']) { ?>
<TD><?=strtoupper($c['client_nom']).' '.ucwords(strtolower($c['client_pnom']))?></TD>
<?php } else { ?>
<TD></TD>
<?php }
$TotS+=$c['chantier_forfaitmensuel'];
?>
<TD align="center"><?=$etablissement_nom ?></TD>
<TD align="center"><?=number_format($c['chantier_forfaitmensuel'], 2, ",", " ").' €'; ?></TD>
</TR>
<?php
// echo $client_id.' ! '.$c['client_id'].' == ';
} ?>
<TR>
<TD align="center" colspan=4 ><b><?=number_format($TotS, 2, ",", " ").' €'; ?></b></TD>
</tr>
</tbody>
</table><!-- /.table -->
</div><!-- /.box-body -->
</div><!-- /.tab -->
<?php $tot_nouv_reg=$TotS ;
$chant=dbi_query("SELECT * FROM chantier c,client cl WHERE cl.client_id=c.client_id AND Chantier_recur='1' AND Chantier_fin between $from and $to $where2 ORDER BY client_nom ");
$TotS = 0;
?>
<div id="tab">
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<TR>
<TD bgcolor="Gray" align="center" colspan=4><b> CHANTIERS ARRETES </span> </b></TD>
</tr>
<TR>
<th align="center">id</th>
<th align="center">Nom du client</th>
<th align="center">Etablissement</th>
<th align="center">Montant du chantier</th>
</TR>
</thead>
<tbody>
<TR>
</TR>
<?php while($c=dbi_fetch_row($chant)){
$tauxtva=$c['chantier_forfaitmensuel']*($c['Chantier_TVA']/100);
list($etablissement_nom) =dbi_fetch_row(dbi_query('select etablissement_nom from etablissement where etablissement_id ='.$c['etablissement_id'])) ;
?>
<TR>
<TD align="center"><?=$c['chantier_ID']?></TD>
<?php if($client_id!=$c['client_id']) { ?>
<TD><?=strtoupper($c['client_nom']).' '.ucwords(strtolower($c['client_pnom']))?></TD>
<?php } else { ?>
<TD></TD>
<?php }
$TotS+=$c['chantier_forfaitmensuel'];
?>
<TD align="center"><?=$etablissement_nom ?></TD>
<TD align="center"><?=number_format($c['chantier_forfaitmensuel'], 2, ",", " ").' €'; ?></TD>
</TR>
<?php
// echo $client_id.' ! '.$c['client_id'].' == ';
} ?>
<TR>
<TD align="center" colspan=4 ><b><?=number_format($TotS, 2, ",", " ").' €'; ?></b></TD>
</TR>
<?php $tot_arr=$TotS ; ?>
</tbody>
</table><!-- /.table -->
</div><!-- /.box-body -->
</div><!-- /.tab -->
<?php
$chant=dbi_query("SELECT * FROM chantier c,client cl WHERE cl.client_id=c.client_id AND Chantier_debut between $from and $to $where2 AND chantier_recur = 0 ORDER BY client_nom ");
$TotS = 0;
?>
<div id="tab">
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<TD bgcolor="Gray" align="center" colspan=4 ><b> NOUVEAUX CHANTIERS PONCTUELS </b></TD>
</tr>
<Tr>
<th align="center">id</th>
<th align="center">Nom du client</th>
<th align="center">Etablissement</th>
<th align="center">Montant du chantier</th>
</tr>
</thead>
<tbody>
<?php while($c=dbi_fetch_row($chant)){
$tauxtva=$c['chantier_forfaitmensuel']*($c['Chantier_TVA']/100);
list($etablissement_nom) =dbi_fetch_row(dbi_query('select etablissement_nom from etablissement where etablissement_id ='.$c['etablissement_id'])) ;
?>
<TR>
<TD align="center"><?=$c['chantier_ID']?></TD>
<?php if($client_id!=$c['client_id']) { ?>
<TD><?=strtoupper($c['client_nom']).' '.ucwords(strtolower($c['client_pnom']))?></TD>
<?php } else { ?>
<TD></TD>
<?php }
$TotS+=$c['chantier_forfaitmensuel'];
?>
<TD align="center"><?=$etablissement_nom ?></TD>
<TD align="center"><?=number_format($c['chantier_forfaitmensuel'], 2, ",", " ").' €'; ?></TD>
</TR>
<?php
// echo $client_id.' ! '.$c['client_id'].' == ';
} ?>
<TR>
<TD align="center" colspan=4 ><b><?=number_format($TotS, 2, ",", " ").' €'; ?></b></TD>
</TR>
<?php $tot_nouv_pnc=$TotS ;
// $diff = ($tot_nouv_pnc + $tot_nouv_reg ) - $tot_arr ;
$diff = $tot_nouv_reg - $tot_arr ;
// echo "==>".$diff ;
?>
</tbody>
</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>
<?php include('footerr.php'); ?>
<script>
$(function () {
var TOTALREG ="<?php echo number_format( $diff, 2, ',', ' ').' € ';?>";
$('#TOTALREG').html(TOTALREG);
})
</script>
<script language="Javascript">
function GetIdBureau()
{
var id="";
id = document.bureau_form.client_bureau.value ;
if( id > 0 || id=="INDEFINI" )
window.location = "sb.php?id="+id;
else
window.location = "sb.php";
}
</script>
</body>
</html>