func_prijava.php

Dokumenacija za ovu datoteku.

<?
/**************************************************************************************
 Studentski Informacijski servis, 2004
 **************************************************************************************
 func_pred_prijava.php
 repozitorij funkcija za prijavljivanje ispita


 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.
 **************************************************************************************/
//
// funckija vraca naziv predmeta na osnovu id-a
//
function getPredmetNaziv($pred_id){
                 $query = "SELECT naziv_predmeta
                                   FROM predmet
                                   WHERE predmet_ID = '$pred_id'";
                 
                 $result = mysql_query($query) or
                                  die(mysql_error());
                                  
                 $row = mysql_fetch_array($result);
                 return $row[0];
         }

//
// funkcija vraca datum rok-a na osnovu id-a
//
function getRokDatum($rok_id){
                 $query = "SELECT datum_vrijeme
                                   FROM rok
                                   WHERE rok_ID = '$rok_id'";
                 
                 $result = mysql_query($query) or
                                  die(mysql_error());
                                  
                 $row = mysql_fetch_array($result);
                 return $row[0];
         }

//
// funkcija provjera da li je ispit vec prijavljen
//
function provjeraPrijave($rok_id, $id){
                 $query = "SELECT student_ID
                                   FROM prijava_ispita
                                   WHERE rok_ID = '$rok_id'
                                   AND student_ID = '$id'";
                 
                 $result = mysql_query($query) or
                                  die(mysql_error());
                                  
                 $broj = mysql_num_rows($result);
                 return $broj;
         }

         
//
// funkcija obavlja sav posao oko prijavljivanja ispita
// pocev od izbora predmeta, pa preko izbora roka
// pa do sacuvavanja informacija o prijavljenom ispitu
//
function prijava($odsjek, $naziv_od, $id, $action, $predmet, $rok){
        if (!isset($action)){
                
                $sem_poc = getSemestarPocetak($id);
                $sem_kraj = getSemestarKraj($id);
                $datum = date("Y-m-d h:m:s");
                $query_predmet_odsjek =
                                                "SELECT DISTINCT predmet.predmet_ID
                                                FROM    odsjek_predmet, predmet, rok
                                                WHERE   odsjek_predmet.odsjek_ID='$odsjek'
                                                AND             predmet.predmet_ID = odsjek_predmet.predmet_ID
                                                AND             odsjek_predmet.datum_kraja = '0000-00-00'
                                                AND             predmet.semestar_pocetak BETWEEN $sem_poc AND $sem_kraj
                                                AND             predmet.semestar_polaganje BETWEEN $sem_poc AND $sem_kraj
                                                AND             predmet.predmet_ID=rok.predmet_ID
                                                AND             rok.datum_vrijeme >= '$datum'";
                
                $result_predmet_odsjek = mysql_query($query_predmet_odsjek) or die(mysql_error());

                if (mysql_num_rows($result_predmet_odsjek)==0){
                                        printRokoviStart(_EXAMENROLTITLE, 350);
                                        printServisGreska( _EXAMENROLERRORNOSUBJECTS.$naziv_od);
                                        printRokoviKraj();
                                        die();
                                         }

                else {
                        $broj = 0;
                        while ($row_predmet_odsjek = mysql_fetch_array($result_predmet_odsjek)){

                                $query_polozeni =
                                        "SELECT DISTINCT predmet_ID
                                        FROM   pismeni_ispit
                                        WHERE  student_ID='$id'
                                        AND    ocjena_pismeni IS NOT NULL ";
                                $result_polozeni = mysql_query($query_polozeni) or die(mysql_error());

                                $row_polozeni = mysql_fetch_array($result_polozeni);

                                if ($row_predmet_odsjek[0] != $row_polozeni['predmet_ID']){

                                $pred_id = $row_predmet_odsjek[0];
                                $ime_predmeta = getPredmetNaziv($pred_id);

                                        if (isset($ime_predmeta)) {
                                                $predmet_content[$broj] = "<option value = ".$pred_id.">" . $ime_predmeta ."</option>\n";
                                                $broj++;
                                        }
                                }
                        }
                printPrijavaStart(_EXAMENROLTITLE);
                printPrijavaPredmetForm($predmet_content, $broj);
                }

        }

        elseif($action=="rok"){
                  if ($predmet != 0){
                        $pred_id = $predmet;
                        $naziv = getPredmetNaziv($pred_id);
                    
                        $query_puta_pred_prijava = "SELECT prijava_ispita_ID FROM prijava_ispita WHERE predmet_ID = '$pred_id' AND student_ID = '$id'"; 
                        $result_puta_pred_prijava = mysql_query($query_puta_pred_prijava) or
                                                                          die(mysql_error());
          
                        $broj = mysql_num_rows($result_puta_pred_prijava);
                        $broj++;
          
                        $datum = date("Y-m-d h:m:s");
                        $query_rok_predmet="SELECT * FROM rok WHERE predmet_ID='$pred_id' AND datum_vrijeme >= '$datum'";
                        $result_rok_predmet = mysql_query($query_rok_predmet) or die(mysql_error());                    
                        
                        $broj_rok = 0;
                        while($row_rok_predmet = mysql_fetch_array($result_rok_predmet)){
                                        if (provjeraPrijave($row_rok_predmet['rok_ID'], $id) == 0){
                                                $datum_roka = $row_rok_predmet['datum_vrijeme'];
                                                $rok_content[$broj_rok] = "<option value = ".$row_rok_predmet['rok_ID'].">" . $datum_roka . "</option>\n";                                              
                                                $broj_rok++;
                                        }                                       
                        }
                printPrijavaStart(_EXAMENROLTITLE);
                printPrijavaRokForm($naziv, $rok_content, $broj_rok, $broj, $pred_id);
          }
          else {
                  printRokoviStart(_EXAMENROLTITLE);
                  printServisGreska(_EXAMENROLERRORSUBJECTNOTCHOSEN);
                  printRokoviKraj();
                  die();
                }
        }
  
        elseif($action=="prijava"){
                if ($rok!= 0){
                   $rok_id = $rok;
                   $sad = date("Y-m-d");
                   $pred_id = $predmet;
                   $query = "INSERT INTO prijava_ispita VALUES ('auto_increment', '$id', '$pred_id','$rok_id','$sad')";
                   $result = mysql_query($query) or die(mysql_error());
                   
                   $datum_ispita = getRokDatum($rok);              
                   $naziv = getPredmetNaziv($pred_id);  
                   printPrijavaStart(_EXAMENROLTITLE);
                   printPrijavaPrijavljenForm($naziv, $datum_ispita);   
                }
                else {
                        printRokoviStart(_EXAMENROLTITLE, 350);
                        printServisGreska(_EXAMENROLERRORDATENOTCHOSEN);
                        printRokoviKraj();
                        die();
                }
        }

        else {
                printRokoviStart(_EXAMENROLTITLE, 350);
                printServisGreska(_SSERVICESGENERALERROR);
                printRokoviKraj();
                die();
           }
}
?>  

---