graph2_ben.php

<?php
/*
 * Factux le facturier libre
 * Copyright (C) 2003-2005 Guy Hendrickx, 2017 Thomas Ingles
 * 
 * Licensed under the terms of the GNU  General Public License:
 * 		http://opensource.org/licenses/GPL-3.0
 * 
 * For further information visit:
 * 		http://factux.free.fr
 * 
 * File Name: fckconfig.js
 * 	Editor configuration settings.
 * 
 * * * Version:  5.0.0
 * * * * Modified: 07/10/2016
 * 
 * File Authors:
 * 		Guy Hendrickx
 *.
 */
require_once("include/verif.php");
include_once("include/config/common.php");
$annee_1 = (isset($_GET['annee_1']))?$_GET['annee_1']:date("Y");
for ($i=1;$i<=12;$i++){
 $sql = "
 SELECT SUM(tot_htva)
 FROM " . $tblpref ."bon_comm 
 WHERE MONTH(" . $tblpref ."bon_comm.date) = '$i' 
 AND YEAR(" . $tblpref ."bon_comm.date) = $annee_1;
 ";
 $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
 $da = mysql_fetch_array($req);
 $sql = "
 SELECT SUM(prix)
 FROM " . $tblpref ."depense
 WHERE MONTH(" . $tblpref ."depense.date) = '$i' 
 AND YEAR(" . $tblpref ."depense.date) = $annee_1;
 ";
 $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
 $ta = mysql_fetch_array($req);

 $entre[$i] = $da['SUM(tot_htva)'] - $ta['SUM(prix)'];
}
include("graph_circulaire_base.php");#Graphique sectoriel au format GIF