gabs77
Messages postés
379
Date d'inscription
mardi 6 décembre 2005
Statut
Membre
Dernière intervention
8 octobre 2008
19 mai 2006 à 17:17
g tester sa ne change rien
voila l'integralité de ma page PHP ( Bon courage, si vous avez la patience de voir le script et de parvenir a me venir en aide )
elle est décomposée en 3 parties qui se répète
- une date
- 2 date afin d'effectuer des statistiques sur ue periode
- sans date donc l'integralite de la table
g mis en vert la partie concernée et en rouge le srcipt
<?php
if ($_POST['date']=='O')//si on fixe une date
{
$mois = isset($_POST['mois'])?$_POST['mois']:null;
$an = isset($_POST['an'])?$_POST['an']:null;
}
if ($_POST['date']=='E')//si on fixe deux date
{
$mois = isset($_POST['mois'])?$_POST['mois']:null;
$an = isset($_POST['an'])?$_POST['an']:null;
$mois2 = isset($_POST['mois2'])?$_POST['mois2']:null;
$an2 = isset($_POST['an2'])?$_POST['an2']:null;
}
$inst = isset($_POST['inst'])?$_POST['inst']:null;
$dep = isset($_POST['dep'])?$_POST['dep']:null;
$imp = isset($_POST['imp'])?$_POST['imp']:null;
$res = isset($_POST['res'])?$_POST['res']:null;
$ordi = isset($_POST['ord'])?$_POST['ord']:null;
$port = isset($_POST['por'])?$_POST['por']:null;
$ensem = isset($_POST['ens'])?$_POST['ens']:null;
//$inter = $inst + $dep;
//compte les types d'intervention
include('../config.php');
echo 'Nb d\'intervention par matériel:
';
//compte les types materiels
if (isset($_POST['date'])&&($_POST['date']=='O'))
{//si le mois et l'année est posté
if (isset($_POST['inst']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin like '%$mois-$an' AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('O_req_install_all '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$inst_all=$data1['type_mat'];
}
}
//compte les types materiels Imprimante
if (isset($_POST['imp']))
{
$sql2 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin like '%$mois-$an' AND type_mat='$imp' ";
$req2 = mysql_query($sql2) or die('O_req_install_imp '.mysql_error());
if ($data2 = mysql_result($req2,0))
{
$inst_imp=$data2['type_mat'];
}
}
//compte les types materiels Réseau
if (isset($_POST['res']))
{
$sql3 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin like '%$mois-$an' AND type_mat='$res'";
$req3 = mysql_query($sql3) or die('O_req_install_res '.mysql_error());
if ($data3 = mysql_result($req3,0))
{
$inst_res=$data3['type_mat'];
}
}
//compte les types materiels Ordinateur
if (isset($_POST['ord']))
{
$sql4 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin like '%$mois-$an' AND type_mat='$ordi'";
$req4 = mysql_query($sql4) or die('O_req_install_ord '.mysql_error());
if ($data4 = mysql_result($req4,0))
{
$inst_ord=$data4['type_mat'];
}
}
//compte les types materiels Portables
if (isset($_POST['por']))
{
$sql5 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin like '%$mois-$an' AND type_mat='$port'";
$req5 = mysql_query($sql5) or die('O_req_install_por '.mysql_error());
if ($data5 = mysql_result($req5,0))
{
$inst_por=$data5['type_mat'];
}
}
//compte les types materiels Ensemble
if (isset($_POST['ens']))
{
$sql6 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin like '%$mois-$an' AND type_mat='$ensem'";
$req6 = mysql_query($sql6) or die('O_req_install_ens '.mysql_error());
if ($data6 = mysql_result($req6,0))
{
$inst_ens=$data6['type_mat'];
}
}
}
if (isset($_POST['dep']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin like '%$mois-$an' AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('O_req_dep_all '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$dep_all=$data1['type_mat'];
}
}
//compte les types materiels Imprimante
if (isset($_POST['imp']))
{
$sql2 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin like '%$mois-$an' AND type_mat='$imp' ";
$req2 = mysql_query($sql2) or die('O_req_dep_imp '.mysql_error());
if ($data2 = mysql_result($req2,0))
{
$dep_imp=$data2['type_mat'];
}
}
//compte les types materiels Réseau
if (isset($_POST['res']))
{
$sql3 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin like '%$mois-$an' AND type_mat='$res'";
$req3 = mysql_query($sql3) or die('O_req_dep_res '.mysql_error());
if ($data3 = mysql_result($req3,0))
{
$dep_res=$data3['type_mat'];
}
}
//compte les types materiels Ordinateur
if (isset($_POST['ord']))
{
$sql4 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin like '%$mois-$an' AND type_mat='$ordi'";
$req4 = mysql_query($sql4) or die('O_req_dep_ord '.mysql_error());
if ($data4 = mysql_result($req4,0))
{
$dep_ord=$data4['type_mat'];
}
}
//compte les types materiels Portables
if (isset($_POST['por']))
{
$sql5 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin like '%$mois-$an' AND type_mat='$port'";
$req5 = mysql_query($sql5) or die('O_req_dep_por '.mysql_error());
if ($data5 = mysql_result($req5,0))
{
$dep_por=$data5['type_mat'];
}
}
//compte les types materiels Ensemble
if (isset($_POST['ens']))
{
$sql6 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin like '%$mois-$an' AND type_mat='$ensem'";
$req6 = mysql_query($sql6) or die('O_req_dep_ens '.mysql_error());
if ($data6 = mysql_result($req6,0))
{
$dep_ens=$data6['type_mat'];
}
}
}
if (isset($_POST['inst'])||isset($_POST['dep']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE (type_inter='$inst' OR type_inter='$dep') AND date_fin like '%$mois-$an' AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('O_req_dep_install '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$inst_dep_all=$data1['type_mat'];
}
}
}
}
elseif (isset($_POST['date'])&&($_POST['date']=='E'))
{//si le mois et l'année est posté
if (isset($_POST['inst']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('E_req_install_all '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$inst_all=$data1['type_mat'];
}
}
//compte les types materiels Imprimante
if (isset($_POST['imp']))
{
$sql2 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_finBETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$imp' ";
$req2 = mysql_query($sql2) or die('E_req_install_imp '.mysql_error());
if ($data2 = mysql_result($req2,0))
{
$inst_imp=$data2['type_mat'];
}
}
//compte les types materiels Réseau
if (isset($_POST['res']))
{
$sql3 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$res'";
$req3 = mysql_query($sql3) or die('E_req_install_res '.mysql_error());
if ($data3 = mysql_result($req3,0))
{
$inst_res=$data3['type_mat'];
}
}
//compte les types materiels Ordinateur
if (isset($_POST['ord']))
{
$sql4 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$ordi'";
$req4 = mysql_query($sql4) or die('E_req_install_ord '.mysql_error());
if ($data4 = mysql_result($req4,0))
{
$inst_ord=$data4['type_mat'];
}
}
//compte les types materiels Portables
if (isset($_POST['por']))
{
$sql5 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$port'";
$req5 = mysql_query($sql5) or die('E_req_install_por '.mysql_error());
if ($data5 = mysql_result($req5,0))
{
$inst_por=$data5['type_mat'];
}
}
//compte les types materiels Ensemble
if (isset($_POST['ens']))
{
$sql6 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$ensem'";
$req6 = mysql_query($sql6) or die('E_req_install_ens '.mysql_error());
if ($data6 = mysql_result($req6,0))
{
$inst_ens=$data6['type_mat'];
}
}
}
if (isset($_POST['dep']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('E_req_dep_all '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$dep_all=$data1['type_mat'];
}
}
//compte les types materiels Imprimante
if (isset($_POST['imp']))
{
$sql2 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$imp' ";
$req2 = mysql_query($sql2) or die('E_req_dep_imp '.mysql_error());
if ($data2 = mysql_result($req2,0))
{
$dep_imp=$data2['type_mat'];
}
}
//compte les types materiels Réseau
if (isset($_POST['res']))
{
$sql3 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$res'";
$req3 = mysql_query($sql3) or die('E_req_dep_res '.mysql_error());
if ($data3 = mysql_result($req3,0))
{
$dep_res=$data3['type_mat'];
}
}
//compte les types materiels Ordinateur
if (isset($_POST['ord']))
{
$sql4 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$ordi'";
$req4 = mysql_query($sql4) or die('E_req_dep_ord '.mysql_error());
if ($data4 = mysql_result($req4,0))
{
$dep_ord=$data4['type_mat'];
}
}
//compte les types materiels Portables
if (isset($_POST['por']))
{
$sql5 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$port'";
$req5 = mysql_query($sql5) or die('E_req_dep_por '.mysql_error());
if ($data5 = mysql_result($req5,0))
{
$dep_por=$data5['type_mat'];
}
}
//compte les types materiels Ensemble
if (isset($_POST['ens']))
{
$sql6 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND date_fin BETWEEN ('%$mois-$an' AND '%$mois2-$an2') AND type_mat='$ensem'";
$req6 = mysql_query($sql6) or die('E_req_dep_ens '.mysql_error());
if ($data6 = mysql_result($req6,0))
{
$dep_ens=$data6['type_mat'];
}
}
}
if (isset($_POST['inst'])||isset($_POST['dep']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE (type_inter='$inst' OR type_inter='$dep') AND date_fin BETWEEN ('??-$mois-$an' AND '??-$mois2-$an2') AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('E_req_dep_install '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$inst_dep_all=$data1['type_mat'];
}
}
}
}else{//si le mois et l'année n'est pas posté
if (isset($_POST['inst']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('N_req_install_all '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$inst_all=$data1['type_mat'];
}
}
//compte les types materiels Imprimante
if (isset($_POST['imp']))
{
$sql2 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND type_mat='$imp' ";
$req2 = mysql_query($sql2) or die('N_req_install_imp '.mysql_error());
if ($data2 = mysql_result($req2,0))
{
$inst_imp=$data2['type_mat'];
}
}
//compte les types materiels Réseau
if (isset($_POST['res']))
{
$sql3 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND type_mat='$res'";
$req3 = mysql_query($sql3) or die('N_req_install_res '.mysql_error());
if ($data3 = mysql_result($req3,0))
{
$inst_res=$data3['type_mat'];
}
}
//compte les types materiels Ordinateur
if (isset($_POST['ord']))
{
$sql4 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND type_mat='$ordi'";
$req4 = mysql_query($sql4) or die('N_req_install_ord '.mysql_error());
if ($data4 = mysql_result($req4,0))
{
$inst_ord=$data4['type_mat'];
}
}
//compte les types materiels Portables
if (isset($_POST['por']))
{
$sql5 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND type_mat='$port'";
$req5 = mysql_query($sql5) or die('N_req_install_por '.mysql_error());
if ($data5 = mysql_result($req5,0))
{
$inst_por=$data5['type_mat'];
}
}
//compte les types materiels Ensemble
if (isset($_POST['ens']))
{
$sql6 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$inst' AND type_mat='$ensem'";
$req6 = mysql_query($sql6) or die('N_req_install_ens '.mysql_error());
if ($data6 = mysql_result($req6,0))
{
$inst_ens=$data6['type_mat'];
}
}
}
if (isset($_POST['dep']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('N_req_dep_all '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$dep_all=$data1['type_mat'];
}
}
//compte les types materiels Imprimante
if (isset($_POST['imp']))
{
$sql2 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND type_mat='$imp' ";
$req2 = mysql_query($sql2) or die('N_req_dep_imp '.mysql_error());
if ($data2 = mysql_result($req2,0))
{
$dep_imp=$data2['type_mat'];
}
}
//compte les types materiels Réseau
if (isset($_POST['res']))
{
$sql3 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND type_mat='$res'";
$req3 = mysql_query($sql3) or die('N_req_dep_res '.mysql_error());
if ($data3 = mysql_result($req3,0))
{
$dep_res=$data3['type_mat'];
}
}
//compte les types materiels Ordinateur
if (isset($_POST['ord']))
{
$sql4 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND type_mat='$ordi'";
$req4 = mysql_query($sql4) or die('N_req_dep_ord '.mysql_error());
if ($data4 = mysql_result($req4,0))
{
$dep_ord=$data4['type_mat'];
}
}
//compte les types materiels Portables
if (isset($_POST['por']))
{
$sql5 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND type_mat='$port'";
$req5 = mysql_query($sql5) or die('N_req_dep_por '.mysql_error());
if ($data5 = mysql_result($req5,0))
{
$dep_por=$data5['type_mat'];
}
}
//compte les types materiels Ensemble
if (isset($_POST['ens']))
{
$sql6 = "SELECT COUNT( * ) FROM $table_hist WHERE type_inter='$dep' AND type_mat='$ensem'";
$req6 = mysql_query($sql6) or die('N_req_dep_ens '.mysql_error());
if ($data6 = mysql_result($req6,0))
{
$dep_ens=$data6['type_mat'];
}
}
}
if (isset($_POST['inst'])||isset($_POST['dep']))
{
if (isset($_POST['imp'])||isset($_POST['res'])||isset($_POST['ord'])||isset($_POST['por'])||isset($_POST['ens']))
{
$sql1 = "SELECT COUNT( * ) FROM $table_hist WHERE (type_inter='$inst' OR type_inter='$dep') AND (type_mat='$imp' OR type_mat='$res' OR type_mat='$ordi' OR type_mat='$port' OR type_mat='$ensem') ";
$req1 = mysql_query($sql1) or die('N_req_install_dep '.mysql_error());
if ($data1 = mysql_result($req1,0))
{
$inst_dep_all=$data1['type_mat'];
}
}
}
}
if (!isset($inst_imp)) {$inst_imp ='0';}
if (!isset($dep_imp)) {$dep_imp ='0';}
if (!isset($inst_res)) {$inst_res ='0';}
if (!isset($dep_res)) {$dep_res ='0';}
if (!isset($inst_ord)) {$inst_ord ='0';}
if (!isset($dep_ord)) {$dep_ord ='0';}
if (!isset($inst_por)) {$inst_por ='0';}
if (!isset($dep_por)) {$dep_por ='0';}
if (!isset($inst_ens)) {$inst_ens ='0';}
if (!isset($dep_ens)) {$dep_ens ='0';}
if (!isset($inst_all)) {$inst_all ='0';}
if (!isset($dep_all)) {$dep_all ='0';}
if (!isset($inst_dep_all)) {$inst_dep_all ='0';}
if (!isset($mois)) {$mois =null;}
if (!isset($an)) {$an =null;}
if (!isset($mois2)) {$mois2 =null;}
if (!isset($an2)) {$an2 =null;}
if ($_POST['date']=='O')
{
$date = $mois.' '.$an;
}
elseif ($_POST['date']=='E')
{
$date='entre '.$mois.' '.$an.' et '.$mois2.' '.$an2;
}else{
$date=null;
}
//afficher les resultat dans un tableaux
echo'';
echo'----
Statistique : '.$date.', ';
echo'----
, Installation, Dépannage, ';
echo'----
Imprimante, '.$inst_imp.', '.$dep_imp.', ';
echo'----
Réseau, '.$inst_res.', '.$dep_res.', ';
echo'----
Ordinateur, '.$inst_ord.', '.$dep_ord.', ';
echo'----
Portable, '.$inst_por.', '.$dep_por.', ';
echo'----
Ensemble, '.$inst_ens.', '.$dep_ens.', ';
echo'----
Intervention, '.$inst_all.', '.$dep_all.', ';
echo'----
Intervention, '.$inst_dep_all.', ';
echo'
';
//afficher les reultat sous forme d'histogramme
include('../test/Nouveau dossier/histogram.php');
?>