Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /**
- * @author Luka Bubalo, David Cavar Lacic, Matko Krleza
- * @copyright 2015
- */
- include_once ('DataBaseConnection.php');
- include_once ('Imenik.php');
- class InernaStatistika(){
- public function __construct(){}
- public function getBrojIspitaPoDatumu(){
- $connection = new DataBaseConnection();
- $connection = $connection->getConnection();
- $query = "SELECT datum_test, COUNT(*) AS vrijednost FROM test GROUP BY datum_test";
- $result = $connection->prepare($query);
- $result ->execute();
- $ArrayReturn = array();
- while( $r = $result->fetch(PDO::FETCH_ASSOC)) {
- $datum = $r['datum_test'];
- $count = $r['vrijednost'];
- $push = array( $datum, $count );
- array_push( $ArrayReturn, $push);
- }
- return ( $ArrayReturn );
- }
- public function getBrojIspitaPoTezini(){
- $connection = new DataBaseConnection();
- $connection = $connection->getConnection();
- $query = "SELECT tezina_test, COUNT(*) AS vrijednost FROM test GROUP BY tezina_test";
- $result = $connection->prepare($query);
- $result ->execute();
- $ArrayReturn = array();
- while( $r = $result->fetch(PDO::FETCH_ASSOC)) {
- $tezina = $r['tezina_test'];
- $count = $r['vrijednost'];
- $push = array( $tezina, $count );
- array_push( $ArrayReturn, $push);
- }
- return( $ArrayReturn );
- }
- public static function compare( &$a, &$b ){
- return ($a['1'] <= $b['1']);
- }
- public function getPodkategorijaPokretanje(){
- $connection = new DataBaseConnection();
- $connection = $connection->getConnection();
- $query = "SELECT subkategorija_subkategorija, COUNT(*) AS vrijednost FROM subkategorija GROUP BY subkategorija_subkategorija";
- $result = $connection->prepare($query);
- $result ->execute();
- $ArrayReturn = array();
- while( $r = $result->fetch(PDO::FETCH_ASSOC)) {
- $subkategorija = $r['subkategorija_subkategorija'];
- $count = $r['vrijednost'];
- $push = array( $subkategorija, $count );
- array_push( $ArrayReturn, $push);
- }
- usort( $ArrayReturn, array('InternaStatistika','compare');
- return( $ArrayReturn );
- }
- public function getNadkategorijaPokretanje(){
- $Imenik = new Imenik();
- $ArrayRetrun = $this -> getPodkategorijaPokretanje();
- $BrojPokretanjaNadKategorije = array( "algebra" => 0, "analitička_geometrija" => 0, "geometrija" => 0, "trigonometrija" => 0, "funckije" => 0, "kombinatorika_i_vjerojatnosti" => 0 );
- foreach( $ArrayReturn as $key => $value ){
- $key['0'] = $podkategorija;
- $nadkategorija = Imenik.getNadkategorija( $podkategorija );
- $BrojPokretanjaNadKategorije['nadkategorija'] += $key['1'];
- }
- return ($BrojPokretanjaNadkategorije);
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement