Funkcije | |
| polozeni ($id, $action) | |
|
||||||||||||
|
Definirano u liniji 27 datoteke func_pispiti.php. Reference _FINEXAMSREQUESERRORNOGRADES, _FINEXAMSREQUESTSUCCESS, _SSERVICESGENERALERROR, printPolozeniIspitiForm(), printServisGreska(), queryresult.
00027 {
00028 if (!isset($action)){
00029 $query = "SELECT pismeni_ispit.predmet_ID, usmeni_ispit.ocjena_konacna, usmeni_ispit.datum_upisa_konacne_ocjene
00030 FROM usmeni_ispit, pismeni_ispit
00031 WHERE pismeni_ispit.student_ID='$id'
00032 AND usmeni_ispit.pismeni_ispit_ID = pismeni_ispit.pismeni_ispit_ID
00033 AND ocjena_konacna IS NOT NULL";
00034 $result = mysql_query($query) or die(mysql_error());
00035 if (mysql_num_rows($result) == 0){
00036 printServisGreska(_FINEXAMSREQUESERRORNOGRADES);
00037 }
00038 else {
00039 $broj = mysql_num_rows($result);
00040 $_SESSION['broj'] = $broj;
00041
00042 $prosjecna = 0;
00043
00044 $query_zahtjev_br = "SELECT zahtjev_potvrda_id FROM zahtjev_potvrda WHERE student_ID='$id' AND tip_potvrde='2'";
00045 $result_zahtjev_br = mysql_query($query_zahtjev_br) or die(mysql_error());
00046 $broj_zahtjeva = mysql_num_rows($result_zahtjev_br);
00047 $broj_zahtjeva++;
00048
00049 $count = 0;
00050 while ($row = mysql_fetch_array($result)){
00051
00052 $predmet_id = $row['predmet_ID'];
00053
00054 $query_pred = "SELECT naziv_predmeta FROM predmet WHERE predmet_ID='$predmet_id'";
00055 $result_pred = mysql_query($query_pred) or die(mysql_error());
00056
00057 $row_pred = mysql_fetch_array($result_pred);
00058
00059 $polozeni_pred[$count][0] = $row_pred['naziv_predmeta'];
00060 $polozeni_pred[$count][1] = $row['ocjena_konacna'];
00061 $polozeni_pred[$count][2] = $row['datum_upisa_konacne_ocjene'];
00062
00063 $prosjecna += $row['ocjena_konacna'];
00064 $count++;
00065 }
00066 $prosjecna = $prosjecna/$broj;
00067 $query_poslano = "SELECT zahtjev_potvrda_id FROM zahtjev_potvrda WHERE student_ID='$id' AND tip_potvrde='2'";
00068 $result_poslano = mysql_query($query_poslano) or die(mysql_error());
00069 $_SESSION['poslano'] = mysql_num_rows($result_poslano);
00070 printPolozeniIspitiForm($polozeni_pred, $count, $prosjecna, $broj_zahtjeva);
00071 }
00072 }
00073
00074 elseif($action=="zahtjev"){
00075 $sad = date("Y-m-d");
00076 $query = "INSERT INTO zahtjev_potvrda VALUES ('auto_increment', '$id', '2', 'Null', '$sad')";
00077 $result = mysql_query($query) or die(mysql_error());
00078 printServisGreska(_FINEXAMSREQUESTSUCCESS);
00079 }
00080 else {
00081 printServisGreska(_SSERVICESGENERALERROR);
00082
00083 }
00084 $query = "SELECT broj_protokola FROM evidencija_potvrda WHERE student_ID='$id'";
00085 $result = mysql_query($query) or die(mysql_error());
00086 $odradjeno = mysql_num_rows($result);
00087 $_SESSION['odradjeno']=$odradjeno;
00088 }
|
1.3.2