func_pispiti.php

Dokumenacija za ovu datoteku.

<?
/**************************************************************************************
 Studentski Informacijski servis, 2004
 **************************************************************************************
 func_pispiti.php
 funkcija priprema informacije za prikaz forme za slanje zahtjeva
 za izdavanje potvrde o polozenim ispitima


 Srdjan Segvic - srle
 **************************************************************************************
 **************************************************************************************
 This program is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU Library General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with this program; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 **************************************************************************************/
function polozeni($id, $action){
        if (!isset($action)){
                $query = "SELECT pismeni_ispit.predmet_ID, usmeni_ispit.ocjena_konacna, usmeni_ispit.datum_upisa_konacne_ocjene 
                          FROM   usmeni_ispit, pismeni_ispit 
                          WHERE  pismeni_ispit.student_ID='$id'
                          AND    usmeni_ispit.pismeni_ispit_ID = pismeni_ispit.pismeni_ispit_ID
                          AND    ocjena_konacna IS NOT NULL";
                $result = mysql_query($query) or die(mysql_error());
                if (mysql_num_rows($result) == 0){                      
                        printServisGreska(_FINEXAMSREQUESERRORNOGRADES);
                }
                else {
                        $broj = mysql_num_rows($result);
                        $_SESSION['broj'] = $broj;
        
                        $prosjecna = 0;
        
                        $query_zahtjev_br = "SELECT zahtjev_potvrda_id FROM zahtjev_potvrda WHERE student_ID='$id' AND tip_potvrde='2'";
                        $result_zahtjev_br = mysql_query($query_zahtjev_br) or die(mysql_error());                                                      
                        $broj_zahtjeva = mysql_num_rows($result_zahtjev_br);
                        $broj_zahtjeva++;
                        
                        $count = 0;                               
                        while ($row = mysql_fetch_array($result)){
          
                                $predmet_id = $row['predmet_ID'];
          
                                $query_pred = "SELECT naziv_predmeta FROM predmet WHERE predmet_ID='$predmet_id'";
                                $result_pred = mysql_query($query_pred) or die(mysql_error());
          
                                $row_pred = mysql_fetch_array($result_pred);
          
                                $polozeni_pred[$count][0] = $row_pred['naziv_predmeta'];
                                $polozeni_pred[$count][1] = $row['ocjena_konacna'];
                                $polozeni_pred[$count][2] = $row['datum_upisa_konacne_ocjene'];
                                
                                $prosjecna += $row['ocjena_konacna'];
                                $count++;
                        }
                        $prosjecna = $prosjecna/$broj;
                        $query_poslano = "SELECT zahtjev_potvrda_id FROM zahtjev_potvrda WHERE student_ID='$id' AND tip_potvrde='2'";
                        $result_poslano = mysql_query($query_poslano) or die(mysql_error());
                        $_SESSION['poslano'] = mysql_num_rows($result_poslano);
                        printPolozeniIspitiForm($polozeni_pred, $count, $prosjecna, $broj_zahtjeva);
                }
        }

        elseif($action=="zahtjev"){
                $sad = date("Y-m-d");
                $query = "INSERT INTO zahtjev_potvrda VALUES ('auto_increment', '$id', '2', 'Null', '$sad')";      
                $result = mysql_query($query) or die(mysql_error());
                printServisGreska(_FINEXAMSREQUESTSUCCESS);
        }
        else {
                printServisGreska(_SSERVICESGENERALERROR);
        
        }
        $query = "SELECT broj_protokola FROM evidencija_potvrda WHERE student_ID='$id'";
        $result = mysql_query($query) or die(mysql_error());
        $odradjeno = mysql_num_rows($result);                                           
        $_SESSION['odradjeno']=$odradjeno;
}       
?>

---