Funkcije | |
| indeksStart ($id, $semestar) | |
| indeksDetails ($id, $pred_id) | |
| indeksAllBySemester ($id) | |
| indeksNoOral ($id) | |
| indeksMissExams ($id, $semestar, $odsjek) | |
| indeksStats ($id) | |
|
|
Definirano u liniji 171 datoteke func_indeks.php. Reference printIndexAllBySemester(), query, resulttoRim().
00171 {
00172
00173 // informacije o svim polozenim ispitima
00174 $query = "SELECT predmet.naziv_predmeta, pismeni_ispit.ocjena_pismeni, usmeni_ispit.ocjena_usmeni, usmeni_ispit.ocjena_konacna, usmeni_ispit.datum_upisa_konacne_ocjene, predmet.predmet_ID, predmet.semestar_polaganje
00175 FROM predmet, usmeni_ispit, pismeni_ispit
00176 WHERE pismeni_ispit.student_ID = '$id'
00177 AND usmeni_ispit.pismeni_ispit_id = pismeni_ispit.pismeni_ispit_id
00178 AND usmeni_ispit.ocjena_konacna IS NOT NULL
00179 AND pismeni_ispit.predmet_ID = predmet.predmet_ID
00180 ORDER BY predmet.semestar_polaganje ASC";
00181
00182 $result = mysql_query($query) or die(mysql_error());
00183 $broj_rezultata = mysql_num_rows($result);
00184
00185 $broj = 0;
00186
00187 while ($row = mysql_fetch_array($result)){
00188 $ispitContent[$broj][0] = $row[0];
00189 $ispitContent[$broj][1] = $row[1];
00190 $ispitContent[$broj][2] = $row[2];
00191 $ispitContent[$broj][3] = $row[3];
00192 $ispitContent[$broj][4] = $row[4];
00193 $ispitContent[$broj][5] = $row[5];
00194 $ispitContent[$broj][6] = $row[6];
00195 $broj++;
00196 }
00197
00198
00199 printIndexAllBySemester($_SESSION['index'], $_SESSION['ime_prezime'], $_SESSION['naziv_od'], toRim($_SESSION['semestar'], $broj_rezultata), $ispitContent, $broj, $broj_rezultata);
00200 }
|
|
||||||||||||
|
Definirano u liniji 71 datoteke func_indeks.php. Reference printIndexDetails()toRim().
00071 {
00072
00073 // detalji ispita
00074 $query_ispit = "SELECT predmet.naziv_predmeta, rok.datum_vrijeme, pismeni_ispit.bodovi_pismeni, pismeni_ispit.ocjena_pismeni, usmeni_ispit.datum_upisa_konacne_ocjene, usmeni_ispit.bodovi_usmeni, usmeni_ispit.ocjena_usmeni, usmeni_ispit.ocjena_konacna
00075 FROM predmet, pismeni_ispit, usmeni_ispit, rok
00076 WHERE pismeni_ispit.student_ID = '$id'
00077 AND pismeni_ispit.predmet_ID = '$pred_id'
00078 AND pismeni_ispit.predmet_ID = predmet.predmet_ID
00079 AND pismeni_ispit.rok_ID = rok.rok_ID
00080 AND usmeni_ispit.pismeni_ispit_id = pismeni_ispit.pismeni_ispit_id";
00081
00082
00083 $result_ispit = mysql_query($query_ispit) or die(mysql_error());
00084 $row_ispit = mysql_fetch_array($result_ispit);
00085
00086 // detalji o nastavi
00087 $query_nastava = "SELECT semestar_pocetak, semestar_polaganje
00088 FROM predmet
00089 WHERE predmet_ID = '$pred_id'";
00090
00091 $result_nastava = mysql_query($query_nastava) or die(mysql_error());
00092 $row_nastava = mysql_fetch_array($result_nastava);
00093
00094 // detalji o profesor
00095 $query_prof = "SELECT predavac.ime_predavaca, predavac.prezime_predavaca
00096 FROM predavac, predavac_predmet
00097 WHERE predavac_predmet.predmet_ID = '$pred_id'
00098 AND predavac_predmet.predavac_ID = predavac.predavac_ID
00099 AND predavac_predmet.datum_kraja ='0000-00-00'
00100 AND predavac.tip_predavaca = 'profesor'
00101 OR predavac.tip_predavaca = 'predavac'";
00102
00103 $result_prof = mysql_query($query_prof) or die(mysql_error());
00104 $row_prof = mysql_fetch_array($result_prof);
00105
00106 // detalji o asistentu
00107 $query_ass = "SELECT predavac.ime_predavaca, predavac.prezime_predavaca
00108 FROM predavac, predavac_predmet
00109 WHERE predavac_predmet.predmet_ID = '$pred_id'
00110 AND predavac_predmet.predavac_ID = predavac.predavac_ID
00111 AND predavac_predmet.datum_kraja !='0000-00-00'
00112 AND predavac.tip_predavaca = 'asistent'";
00113
00114 $result_ass = mysql_query($query_ass) or die(mysql_error());
00115 $broj_ass = 0;
00116
00117 while ($row_ass = mysql_fetch_array($result_ass)){
00118 $assist[$broj_ass] = substr($row_ass[0], 0, 1).". ".$row_ass[1];
00119 $broj_ass++;
00120 }
00121
00122 // za racunanje prosjecne ocjene na predmetu (AVG nije normalan)
00123 $query_avgrade = "SELECT usmeni_ispit.ocjena_konacna
00124 FROM usmeni_ispit, pismeni_ispit
00125 WHERE pismeni_ispit.predmet_ID = '$pred_id'
00126 AND usmeni_ispit.pismeni_ispit_ID = pismeni_ispit.pismeni_ispit_ID
00127 AND usmeni_ispit.ocjena_konacna IS NOT NULL";
00128
00129 $result_avgrade = mysql_query($query_avgrade) or die(mysql_error());
00130 $nm_ocjena = mysql_num_rows($result_avgrade);
00131
00132 $sum = 0;
00133 while ($row_avgrade = mysql_fetch_array($result_avgrade)){
00134 $sum += $row_avgrade[0];
00135 }
00136 $avg_ocjena = $sum/$nm_ocjena;
00137
00138 // za broj prijava
00139 $query_nrprijava = "SELECT prijava_ispita_ID
00140 FROM prijava_ispita
00141 WHERE predmet_ID = '$pred_id'
00142 AND student_ID = '$id'";
00143
00144 $result_nrprijava = mysql_query($query_nrprijava) or die(mysql_error());
00145 $nr_prijava = mysql_num_rows($result_nrprijava);
00146
00147 // za racunanje prosjecne ocjene studenta u skolovanju (AVG je debil)
00148 $query_avsingles = "SELECT usmeni_ispit.ocjena_konacna
00149 FROM usmeni_ispit, pismeni_ispit
00150 WHERE pismeni_ispit.student_ID = '$id'
00151 AND usmeni_ispit.pismeni_ispit_ID = pismeni_ispit.pismeni_ispit_ID
00152 AND usmeni_ispit.ocjena_konacna IS NOT NULL";
00153
00154 $result_avsingles = mysql_query($query_avsingles) or die(mysql_error());
00155 $nm_singles = mysql_num_rows($result_avsingles);
00156
00157 $sum_singles = 0;
00158 while ($row_avsingles = mysql_fetch_array($result_avsingles)){
00159 $sum_singles += $row_avsingles[0];
00160 }
00161 $avg_singles = $sum_singles/$nm_singles;
00162
00163 printIndexDetails($_SESSION['index'], $_SESSION['ime_prezime'], $_SESSION['naziv_od'], toRim($_SESSION['semestar']), $row_ispit, $row_nastava, $row_prof, $assist, $broj_ass, $avg_ocjena, $nr_prijava, $avg_singles);
00164 }
|
|
||||||||||||||||
|
Definirano u liniji 279 datoteke func_indeks.php. Reference printIndexMissExams(), query, resulttoRim().
00279 {
00280 $query_polozeni =
00281 "SELECT predmet_ID
00282 FROM pismeni_ispit
00283 WHERE student_ID='$id'
00284 AND ocjena_pismeni != '5'";
00285 $result_polozeni = mysql_query($query_polozeni) or die(mysql_error());
00286
00287 $broj_polozeni = mysql_num_rows($result_polozeni);
00288 if ($broj_polozenii != 0){
00289 $count = 0;
00290 while ($row_polozeni = mysql_fetch_array($result_polozeni)){
00291 $pid[$count] = $row_polozeni[0];
00292 $count++;
00293 }
00294 }
00295 else {
00296 $count = 1;
00297 $pid[0] = 0;
00298 }
00299
00300 // svasta se radi da se simulira subquery....
00301 $query_start =
00302 "SELECT predmet.naziv_predmeta, predmet.predmet_ID , predmet.semestar_polaganje
00303 FROM odsjek_predmet, predmet
00304 WHERE odsjek_predmet.odsjek_ID = ' $odsjek'
00305 AND odsjek_predmet.datum_kraja = '0000-00-00'
00306 AND odsjek_predmet.predmet_ID NOT IN (";
00307
00308 $broj = 0;
00309 $query_add = "";
00310 while ($broj < $count){
00311 $query_add .= "'".$pid[$broj]."', ";
00312
00313 $broj++;
00314 }
00315 $len = strlen($query_add);
00316 $query_add = substr($query_add, 0, ($len-2));
00317
00318 $query_end =
00319 ")
00320 AND odsjek_predmet.predmet_ID = predmet.predmet_ID
00321 AND predmet.semestar_polaganje < '$semestar'
00322 ORDER BY predmet.semestar_polaganje ASC";
00323
00324 $query = $query_start . $query_add . $query_end;
00325 $result = mysql_query($query) or die(mysql_error());
00326
00327 $broj = 0;
00328
00329 while ($row = mysql_fetch_array($result)){
00330 $ispitContent[$broj][0] = $row[0];
00331 $ispitContent[$broj][1] = $row[1];
00332 $ispitContent[$broj][2] = $row[2];
00333 $broj++;
00334 }
00335 printIndexMissExams($_SESSION['index'], $_SESSION['ime_prezime'], $_SESSION['naziv_od'], toRim($_SESSION['semestar']), $ispitContent, $broj);
00336 }
|
|
|
Definirano u liniji 207 datoteke func_indeks.php. Reference printIndexNoOral(), query, resulttoRim().
00207 {
00208 $query_usmeni =
00209 "SELECT pismeni_ispit.pismeni_ispit_ID
00210 FROM usmeni_ispit, pismeni_ispit
00211 WHERE pismeni_ispit.student_ID = '$id'
00212 AND pismeni_ispit.pismeni_ispit_ID = usmeni_ispit.pismeni_ispit_ID";
00213
00214 $result_usmeni = mysql_query($query_usmeni) or die(mysql_error());
00215
00216 $broj_usmeni = mysql_num_rows($result_usmeni);
00217 if ($broj_usmeni != 0){
00218 $count = 0;
00219 while ($row_usmeni = mysql_fetch_array($result_usmeni)){
00220 $pid[$count] = $row_usmeni[0];
00221 $count++;
00222 }
00223 }
00224 else {
00225 $count =1;
00226 $pid[0] = 0;
00227 }
00228
00229 // detalji o predmetima iz kojih nije polozen usmeni ispit
00230 $query_start =
00231 "SELECT predmet.naziv_predmeta, pismeni_ispit.bodovi_pismeni, pismeni_ispit.ocjena_pismeni, rok.datum_vrijeme, pismeni_ispit.datum_upisa_pismeni_ocjene, predmet.predmet_ID, predmet.semestar_polaganje, pismeni_ispit.pismeni_ispit_ID
00232 FROM predmet, pismeni_ispit, rok
00233 WHERE pismeni_ispit.student_ID = '$id'
00234 AND pismeni_ispit.pismeni_ispit_ID NOT IN (";
00235
00236
00237 $broj = 0;
00238 $query_add = "";
00239 while ($broj < $count){
00240 $query_add .= "'".$pid[$broj]."', ";
00241 $broj++;
00242 }
00243
00244 $len = strlen($query_add);
00245 $query_add = substr($query_add, 0, ($len-2));
00246
00247 $query_end = "
00248 )
00249 AND pismeni_ispit.predmet_ID = predmet.predmet_ID
00250 AND pismeni_ispit.rok_ID = rok.rok_ID
00251 ORDER BY predmet.semestar_polaganje ASC";
00252
00253 $query = $query_start . $query_add . $query_end;
00254
00255
00256 $result = mysql_query($query) or die(mysql_error());
00257
00258 $broj_rezultata = mysql_num_rows($result);
00259 $broj = 0;
00260
00261 while ($row = mysql_fetch_array($result)){
00262 $ispitContent[$broj][0] = $row[0];
00263 $ispitContent[$broj][1] = $row[1];
00264 $ispitContent[$broj][2] = $row[2];
00265 $ispitContent[$broj][3] = substr($row[3], 0, 10);
00266 $ispitContent[$broj][4] = $row[4];
00267 $ispitContent[$broj][5] = $row[5];
00268 $ispitContent[$broj][6] = $row[6];
00269 $broj++;
00270 }
00271 printIndexNoOral($_SESSION['index'], $_SESSION['ime_prezime'], $_SESSION['naziv_od'], toRim($_SESSION['semestar']), $ispitContent, $broj, $broj_rezultata);
00272 }
|
|
||||||||||||
|
Definirano u liniji 31 datoteke func_indeks.php. Reference printIndexStart(), query, resulttoRim().
00031 {
00032
00033 //
00034 // uzmi naziv predmeta, ocjenu pismeni, usmeni, konacnu za 5 posljenjih polozenih ispita
00035 //
00036 $query = "SELECT predmet.naziv_predmeta, pismeni_ispit.ocjena_pismeni, usmeni_ispit.ocjena_usmeni, usmeni_ispit.ocjena_konacna, usmeni_ispit.datum_upisa_konacne_ocjene, predmet.predmet_ID
00037 FROM predmet, usmeni_ispit, pismeni_ispit
00038 WHERE pismeni_ispit.student_ID = '$id'
00039 AND usmeni_ispit.pismeni_ispit_id = pismeni_ispit.pismeni_ispit_id
00040 AND usmeni_ispit.ocjena_konacna IS NOT NULL
00041 AND pismeni_ispit.predmet_ID = predmet.predmet_ID
00042 ORDER BY usmeni_ispit.datum_upisa_konacne_ocjene DESC
00043 LIMIT 0,5";
00044
00045 $result = mysql_query($query) or die(mysql_error());
00046
00047 $broj_rezultata = mysql_num_rows($result);
00048
00049 $broj = 0;
00050
00051 while ($row = mysql_fetch_array($result)){
00052 $ispitContent[$broj][0] = $row[0];
00053 $ispitContent[$broj][1] = $row[1];
00054 $ispitContent[$broj][2] = $row[2];
00055 $ispitContent[$broj][3] = $row[3];
00056 $ispitContent[$broj][4] = $row[4];
00057 $ispitContent[$broj][5] = $row[5];
00058 $broj++;
00059 }
00060
00061
00062 printIndexStart($_SESSION['index'], $_SESSION['ime_prezime'], $_SESSION['naziv_od'], toRim($_SESSION['semestar']), $ispitContent,
00063 $broj, $broj_rezultata);
00064
00065 }
|
|
|
Definirano u liniji 343 datoteke func_indeks.php. Reference printIndexStats()toRim().
00343 {
00344
00345 $query_ukup =
00346 "SELECT usmeni_ispit.pismeni_ispit_ID, usmeni_ispit.ocjena_konacna
00347 FROM usmeni_ispit, pismeni_ispit
00348 WHERE pismeni_ispit.student_ID='$id'
00349 AND usmeni_ispit.pismeni_ispit_ID = pismeni_ispit.pismeni_ispit_ID
00350 AND usmeni_ispit.ocjena_konacna != '5'";
00351
00352 $result_ukup = mysql_query($query_ukup) or die(mysql_error());
00353 $count_ukup = mysql_num_rows($result_ukup);
00354
00355 $sum = 0;
00356 while ($row_ukup = mysql_fetch_array($result_ukup)){
00357 $sum += $row_ukup[1];
00358 }
00359 $mimaxav[0] = $sum/$count_ukup;;
00360
00361 $query_MAX =
00362 "SELECT MAX(usmeni_ispit.ocjena_konacna), MIN(usmeni_ispit.ocjena_konacna)
00363 FROM usmeni_ispit, pismeni_ispit
00364 WHERE pismeni_ispit.student_ID='$id'
00365 AND usmeni_ispit.pismeni_ispit_ID = pismeni_ispit.pismeni_ispit_ID
00366 AND usmeni_ispit.ocjena_konacna != '5'";
00367
00368 $result_MAX = mysql_query($query_MAX) or die(mysql_error());
00369 $row_MAX = mysql_fetch_row($result_MAX);
00370 $mimaxav[1] =$row_MAX[0];
00371 $mimaxav[2] =$row_MAX[1];
00372
00373
00374 $query_max_pred =
00375 "SELECT predmet.predmet_ID, predmet.naziv_predmeta
00376 FROM usmeni_ispit, pismeni_ispit, predmet
00377 WHERE pismeni_ispit.student_ID='$id'
00378 AND usmeni_ispit.pismeni_ispit_ID = pismeni_ispit.pismeni_ispit_ID
00379 AND usmeni_ispit.ocjena_konacna = '$row_MAX[0]'
00380 AND predmet.predmet_ID = pismeni_ispit.predmet_ID";
00381
00382
00383 $result_max_pred = mysql_query($query_max_pred) or die(mysql_error());
00384 $count_max_pred = mysql_num_rows($result_max_pred);
00385 $broj_max=0;
00386 while($row_max_pred = mysql_fetch_array($result_max_pred)){
00387 $predmet_max[0][$broj_max] = $row_max_pred[0];
00388 $predmet_max[1][$broj_max] = $row_max_pred[1];
00389
00390 $broj_max++;
00391 }
00392
00393 $query_min_pred =
00394 "SELECT predmet.predmet_ID, predmet.naziv_predmeta
00395 FROM usmeni_ispit, pismeni_ispit, predmet
00396 WHERE pismeni_ispit.student_ID='$id'
00397 AND usmeni_ispit.pismeni_ispit_ID = pismeni_ispit.pismeni_ispit_ID
00398 AND usmeni_ispit.ocjena_konacna = '$row_MAX[1]'
00399 AND predmet.predmet_ID = pismeni_ispit.predmet_ID";
00400
00401
00402 $result_min_pred = mysql_query($query_min_pred) or die(mysql_error());
00403 $count_min_pred = mysql_num_rows($result_min_pred);
00404 $broj_min=0;
00405 while($row_min_pred = mysql_fetch_array($result_min_pred)){
00406 $predmet_min[0][$broj_min] = $row_min_pred[0];
00407 $predmet_min[1][$broj_min] = $row_min_pred[1];
00408
00409 $broj_min++;
00410 }
00411
00412 $qprijava_uk =
00413 "SELECT prijava_ispita_id
00414 FROM prijava_ispita
00415 WHERE student_ID = '$id'";
00416
00417 $prijava_uk_rez = mysql_query($qprijava_uk) or die(mysql_error());
00418 $count_prij = mysql_num_rows($prijava_uk_rez);
00419
00420 $ispita_po_prijavi = $count_prij / $count_ukup;
00421
00422
00423
00424
00425
00426 printIndexStats($_SESSION['index'], $_SESSION['ime_prezime'], $_SESSION['naziv_od'], toRim($_SESSION['semestar']), $count_ukup, $mimaxav, $predmet_max, $broj_max, $predmet_min, $broj_min, $count_prij, $ispita_po_prijavi);
00427 }
|
1.3.2