='".$Start."' AND data<='".$End."' ORDER BY funzione"; echo "Query=".$Query.$CR; $Result = $Db->Exec($Query); $TotRec = $Db->Numrows($Result); echo "TotRec=".$TotRec.$CR; //exit(); $TabFunctions = array(); echo "".chr(10); echo " ".chr(10); echo " ".chr(10); //print_r($TabFunctions); //exit(); //---------------------------------------------------------------------------------------------------------------- // //---------------------------------------------------------------------------------------------------------------- $Query = "SELECT * FROM logs WHERE data>='".$Start."' AND data<='".$End."' ORDER BY DATA DESC"; //$Query = "SELECT * FROM logs WHERE data='2014-09-11'"; //echo "Query=".$Query.$CR; $Result = $Db->Exec($Query); $TotRec = $Db->Numrows($Result); //echo "TotRec=".$TotRec.$CR; //exit(); $TabData = array(); $TabTotali = array(); for ($Rec=0;$Rec<$TotRec; $Rec++) { $Record = $Db->Fetch($Result, $Rec); $Data = $Record["data"]; $Account = $Record["email"]; $Function = $Record["funzione"]; //echo "Data=".$Data.$CR; //echo "Account=".$Account.$CR; //echo "Function=".$Function.$CR; if (isset($TabData[$Data]["accounts"][$Account])) { $TabData[$Data]["accounts"][$Account]++; } else { $TabData[$Data]["accounts"][$Account] = 1; } if (isset($TabData[$Data]["functions"][$Function])) { $TabData[$Data]["functions"][$Function]++; } else { $TabData[$Data]["functions"][$Function] = 1; } } //print_r($TabData); //exit(); foreach($TabData as $Data => $Item) { //print_r($Item); $RichiesteTotali = 0; foreach($Item["functions"] as $Funzione => $Richieste) { //echo "Funzione=".$Funzione."
"; //echo "Richieste=".$Richieste."
"; $RichiesteTotali += $Richieste; } //echo "RichiesteTotali=".$RichiesteTotali."
"; //exit(); $Utenti = count($Item["accounts"]); //echo "Data=".$Data."
"; echo " ".chr(10); echo " ".chr(10); } //echo "

DATA	".chr(10); echo "	RICHIESTE	".chr(10); echo "	UTENTI	".chr(10); for ($Rec=0;$Rec<$TotRec; $Rec++) { $Record = $Db->Fetch($Result, $Rec); $TabFunctions[] = $Record[0]; echo "	".$Record[0]."	".chr(10); } echo "
".$Data."	".chr(10); echo "	".$RichiesteTotali."	".chr(10); echo "	".$Utenti."	".chr(10); for ($Ind=0; $Ind"; //print_r($Item["functions"]); $Richieste = 0; if(isset($Item["functions"][$Funzione]) == TRUE) { $Richieste = $Item["functions"][$Funzione]; } //echo "Richieste=".$Richieste." "; echo "	".$Richieste."	".chr(10); if (isset($TabTotali[$Funzione]) == TRUE) { $TabTotali[$Funzione] += $Richieste; } else { $TabTotali[$Funzione] = 0; } } echo "

"; //echo "".chr(10); echo " ".chr(10); echo " ".chr(10); echo " ".chr(10); echo " ".chr(10); exit(); //---------------------------------------------------------------------------------------------------------------- // //---------------------------------------------------------------------------------------------------------------- ?>

DATA	".chr(10); echo "	RICHIESTE	".chr(10); echo "	UTENTI	".chr(10); for ($Ind=0; $Ind".$TabFunctions[$Ind]."	".chr(10); } echo "
TOTALI	".chr(10); echo "		".chr(10); echo "		".chr(10); foreach($TabTotali as $Funzione => $Totale) { echo "	".$Totale."	".chr(10); } echo "