|
Server IP : 10.128.40.6 / Your IP : 216.73.216.233 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/feuillesroute/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// echo "<pre>" ;
// print_r($_GET) ;
// echo "</pre>" ;
// if(!empty($_GET['client_id']))
// {
// $_SESSION["client_id"]=$_GET['client_id'];
// }
// $cleint_id=$_SESSION["client_id"] ;
// $_SESSION["cleint_id"]= NULL ;
//Php code
//Months
$months = array('Janvier','Février','Mars','Avril','Mai','Juin','Juillet','Août','Septembre','Octobre','Novembre ','Décembre ');
for($i=1 ; $i<=12 ; $i++)
{
// echo date('Y').$i."01 <br/>" ;
if($i<10){
$from= date('Y')."0".$i."01" ;
$to= date('Y')."0".$i."31" ;
$fromm[]= date('Y')."0".$i."01" ;
$tto[]= date('Y')."0".$i."31" ;
}else{
$fromm[]= date('Y').$i."01" ;
$too[]= date('Y').$i."31" ;
$from= date('Y').$i."01" ;
$to= date('Y').$i."31" ;
}
list($tot)=dbi_fetch_row( dbi_query("SELECT sum(chantier_forfaitmensuel) FROM chantier c,client cl WHERE cl.client_id=c.client_id AND Chantier_debut between $from and $to AND chantier_recur = 1 ORDER BY client_nom "));
list($tt)=dbi_fetch_row( dbi_query("SELECT sum(chantier_forfaitmensuel) FROM chantier c,client cl WHERE cl.client_id=c.client_id AND Chantier_recur='1' AND Chantier_fin between $from and $to ORDER BY client_nom "));
$nouv[] = $tot ;
// number_format($tot, 2, ".", " ") ;
$art[] = $tt ;
// number_format($tt , 2, ".", " ") ;
// echo
}
// echo"<pre/>" ;
// print_r($nouv) ;
// echo"<pre/>" ;
// echo"<pre/>" ;
// print_r($art) ;
// echo"<pre/>" ;
//first Data
$data_1 = array($nouv[0], $nouv[1], $nouv[2], $nouv[3], $nouv[4], $nouv[5], $nouv[6],$nouv[7],$nouv[8],$nouv[9],$nouv[10],$nouv[11]);
//Second Data
$data_2 = array($art[0], $art[1], $art[2], $art[3], $art[4], $art[5], $art[6],$art[7], $art[8], $art[9], $art[10], $art[11])
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css" integrity="sha384-xOolHFLEh07PJGoPkLv1IbcEPTNtaed2xpHsD9ESMhqIYd0nLMwNLD69Npy4HI+N" crossorigin="anonymous">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!-- Enregistrer le titre de la page --><title> LogMCPRO | ETABLISSEMENTS</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">
<!-- overlayScrollbars -->
<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">
<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">
<!-- DataTables -->
<link rel="stylesheet" href="../../plugins/datatables-bs4/css/dataTables.bootstrap4.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">
</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>
<!-- bouton haut-->
</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 -->
<!-- Couleur et caracteristiques de la barre de navigation-->
<?php include('menu.php'); ?>
<!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="content-wrapper">
<!-- TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
<section class="content-header">
<div class="container-fluid">
<div class="row">
<div class="col-sm-9">
</div>
<div class="col-sm-3">
<ol class="breadcrumb float-sm-right">
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<!-- FIN DU TITRE DE LA PAGE PRINCIPALE A PLACE ENTRE LES BALISES H1 & ARBORESCENCE SUR LA DROITE-->
<section class="content">
<div class="row">
<div class="col-12">
<div class="card card-primary card-outline">
<div class="card-header">
<div class="row">
<div class="col-sm-11"><h3 class="card-title"> <i class="nav-icon fas fa-id-card"></i> Graphique </h3> </div>
<div class="col-sm-1"></div>
</div>
</div>
<!-- /.card-header -->
<div class="card-body">
<div class="chart">
<canvas id="areaChart" style="min-height: 500px; height: 1000px; max-height: 250px; max-width: 100%;"></canvas>
</div>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- NE PAS TOUCHER AU DESSUS DESSOUS -->
<!-- DEBUT DU PIED DE PAGE -->
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.1
</div>
<strong>Copyright © 2019 MCPRO</strong>
</footer>
<!-- FIN DU PIED DE PAGE -->
<!-- NE PAS TOUCHER CI-DESSOUS -->
<!-- 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 src="https://code.jquery.com/jquery-3.6.1.js" integrity="sha256-3zlB5s2uwoUzrXK3BT7AX3FyvojsraNFxCc2vC/7pNI=" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-Fy6S3B9q64WdZWQUiU+q4/2Lc9npb8tCaSX9FK7E8HnRr0Jz8D6OP9dO5Vg3Q9ct" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.4/Chart.bundle.min.js"></script>
<script>
$(function () {
/* ChartJS
* -------
* Here we will create a few charts using ChartJS
*/
//--------------
//- AREA CHART -
//--------------
// Get context with jQuery - using jQuery's .get() method.
var areaChartCanvas = $('#areaChart').get(0).getContext('2d')
var areaChartData = {
labels : <?php echo json_encode($months)?>,
datasets: [
{
label : 'NOUVEAUX CHANTIERS',
backgroundColor : '#E97369',
borderColor : '#E97369',
pointRadius : true,
pointColor : '#3b8bba',
pointStrokeColor : 'rgba(60,141,188,1)',
pointHighlightFill : '#fff',
pointHighlightStroke: 'rgba(60,141,188,1)',
data : <?php echo json_encode($data_1)?>
},
{
label : 'CHANTIERS ARRETES',
backgroundColor : '#F3C2AE',
borderColor : '#F3C2AE',
pointRadius : true,
pointColor : 'rgba(210, 214, 222, 1)',
pointStrokeColor : '#c1c7d1',
pointHighlightFill : '#fff',
pointHighlightStroke: 'rgba(220,220,220,1)',
data : <?php echo json_encode($data_2)?>
},
]
}
var areaChartOptions = {
maintainAspectRatio : true,
responsive : true,
legend: {
display: true
},
scales: {
xAxes: [{
gridLines : {
display : true,
}
}],
yAxes: [{
gridLines : {
display : true,
}
}]
}
}
// This will get the first returned node in the jQuery collection.
new Chart(areaChartCanvas, {
type: 'line',
data: areaChartData,
options: areaChartOptions
})
//-------------
//- LINE CHART -
//--------------
})
</script>
</body>
</html>