Funkcije | |
| doSearch ($id, $odsjek, $keyword) | |
| doSearchPred ($id, $odsjek, $keyword, $red, $stranica) | |
| countSearchPred ($id, $query_broj, $stranica, $keyword, $gore) | |
| numberSearchPages ($stranica, $broj_obavjestenja, $tip, $keyword, $id) | |
| doSearchSSS ($id, $keyword, $red, $stranica) | |
| countSearchsss ($id, $query_broj, $stranica, $keyword, $gore) | |
| doSearchdg ($id, $odsjek,$keyword) | |
| doSearchdp ($id,$keyword) | |
| doSearchlg ($keyword) | |
| doSearchlp ($id, $keyword) | |
|
||||||||||||||||||||||||
|
Definirano u liniji 391 datoteke func_search.php. Reference _SEARCHRESULTSSUM, _SEARCHRESULTSSUMRESULT, idnumberSearchPages(). Referencirano od doSearchPred().
00391 {
00392
00393 $result_broj = mysql_query($query_broj) or
00394 die(mysql_error());
00395
00396 $broj_obavjestenja = mysql_num_rows($result_broj);
00397
00398 if ($gore == "1"){
00399 echo "
00400 <h3><font color=\"#4B4B4B\"><strong>"._SEARCHRESULTSFOR." <font color=\"#FF0000\">".$keyword."</font>, "._SEARCHRESULTSSUM." ".$broj_obavjestenja." "._SEARCHRESULTSSUMRESULT."<br/><br/></h3>";
00401 }
00402 $tip = "pred";
00403 numberSearchPages($stranica, $broj_obavjestenja, $tip, $keyword, $id);
00404 }
|
|
||||||||||||||||||||||||
|
Definirano u liniji 565 datoteke func_search.php. Reference _SEARCHRESULTSSUM, _SEARCHRESULTSSUMRESULT, idnumberSearchPages(). Referencirano od doSearchSSS().
00565 {
00566
00567 $result_broj = mysql_query($query_broj) or die(mysql_error());
00568
00569 $broj_obavjestenja = mysql_num_rows($result_broj);
00570
00571 if ($gore == "1") {
00572 echo "
00573 <h3><font color=\"#4B4B4B\"><strong>"._SEARCHRESULTSFOR." <font color=\"#FF0000\">".$keyword."</font>, "._SEARCHRESULTSSUM." ".$broj_obavjestenja." "._SEARCHRESULTSSUMRESULT."<br/><br/></h3>";
00574 }
00575 $tip = "sss";
00576 numberSearchPages($stranica, $broj_obavjestenja, $tip, $keyword, $id);
00577 }
|
|
||||||||||||||||
|
Definirano u liniji 31 datoteke func_search.php. Reference _SEARCHTOSHORT, getSemestarKraj(), getSemestarPocetak(), id, printRokoviKraj(), printSearchStart()printServisGreska().
00031 {
00032 if (($keyword=="") || (strlen($keyword)<3)){
00033 printServisGreska(_SEARCHTOSHORT);
00034 printRokoviKraj();
00035 }
00036 else {
00037 //
00038 // trazimo keyword u obavjestenjima predmeta...
00039 //
00040 $sem_poc = getSemestarPocetak($id);
00041 $sem_kraj = getSemestarKraj($id);
00042
00043 $query_predmeti =
00044 "SELECT DISTINCT obavjestenje.obavjestenje_ID
00045 FROM obavjestenje, obavjestenje_predavac, odsjek_predmet, predmet
00046 WHERE odsjek_predmet.odsjek_ID = '$odsjek'
00047 AND obavjestenje_predavac.obavjestenje_ID = obavjestenje.obavjestenje_ID
00048 AND obavjestenje_predavac.predmet_ID = odsjek_predmet.predmet_ID
00049 AND obavjestenje.status_obavjestenja = 'objavljeno'
00050 AND predmet.predmet_ID = obavjestenje_predavac.predmet_ID
00051 AND odsjek_predmet.datum_kraja = '0000-00-00'
00052 AND predmet.semestar_pocetak >= $sem_poc
00053 AND predmet.semestar_pocetak <= $sem_kraj
00054 AND predmet.semestar_polaganje >= $sem_poc
00055 AND predmet.semestar_polaganje <= $sem_kraj
00056 AND obavjestenje.obavjestenje_ID =obavjestenje_predavac.obavjestenje_ID
00057 ORDER BY obavjestenje.obavjestenje_ID";
00058
00059
00060 $result_predmeti = mysql_query($query_predmeti) or
00061 die(mysql_error());
00062
00063 if (mysql_num_rows($result_predmeti)!=0){
00064 $count = 0;
00065 // opet kerefeke za ubrzanje query-a
00066 while ($row_predmeti = mysql_fetch_array($result_predmeti)){
00067 $oid[$count] = $row_predmeti[0];
00068 $count++;
00069 }
00070
00071 $query_op_start =
00072 "SELECT obavjestenje.obavjestenje_ID
00073 FROM obavjestenje
00074 WHERE obavjestenje.text LIKE '%$keyword%'
00075 OR obavjestenje.naslov LIKE '%$keyword%'
00076 HAVING obavjestenje.obavjestenje_ID IN (";
00077
00078 $broj = 0;
00079 $query_op_add = "";
00080 while ($broj < $count){
00081 $query_op_add .= "'".$oid[$broj]."', ";
00082 $broj++;
00083 }
00084 $len = strlen($query_op_add);
00085 $query_op_add = substr($query_op_add, 0, ($len-2));
00086
00087
00088 $query_op_end =
00089 ")";
00090
00091 $query_op = $query_op_start.$query_op_add.$query_op_end;
00092
00093
00094
00095 $result_op = mysql_query($query_op) or die(mysql_error());
00096 $broj_op = mysql_num_rows($result_op);
00097 }
00098 else {
00099 $broj_op = 0;
00100 }
00101
00102
00103
00104 //
00105 // hajmo sad traziti keyword u obavjestenjima sluzbe...
00106 //
00107 $query_sss =
00108 "SELECT obavjestenje.obavjestenje_ID
00109 FROM obavjestenje, obavjestenje_sss, sss
00110 WHERE obavjestenje.tip_obavjestenja = 'sss'
00111 AND obavjestenje_sss.obavjestenje_ID = obavjestenje.obavjestenje_ID
00112 AND obavjestenje_sss.sss_ID = sss.sss_ID
00113 AND obavjestenje.status_obavjestenja = 'objavljeno'
00114 ORDER BY obavjestenje_sss.datum_postavljanja DESC";
00115
00116 $result_sss = mysql_query($query_sss) or
00117 die(mysql_error());
00118
00119 if (mysql_num_rows($result_sss)!=0){
00120 $count_sss = 0;
00121 // opet kerefeke za ubrzanje query-a
00122 while ($row_sss = mysql_fetch_array($result_sss)){
00123 $oid_sss[$count_sss] = $row_sss[0];
00124 $count_sss++;
00125 }
00126
00127 $query_os_start =
00128 "SELECT obavjestenje.obavjestenje_ID
00129 FROM obavjestenje
00130 WHERE obavjestenje.text LIKE '%$keyword%'
00131 OR obavjestenje.naslov LIKE '%$keyword%'
00132 HAVING obavjestenje.obavjestenje_ID IN (";
00133
00134 $broj_sss = 0;
00135 $query_os_add = "";
00136 while ($broj_sss < $count_sss){
00137 $query_os_add .= "'".$oid_sss[$broj_sss]."', ";
00138 $broj_sss++;
00139 }
00140 $len_sss = strlen($query_os_add);
00141 $query_os_add = substr($query_os_add, 0, ($len_sss-2));
00142
00143 $query_os_end =
00144 ")
00145 ";
00146
00147 $query_os = $query_os_start.$query_os_add.$query_os_end;
00148
00149
00150 $result_os = mysql_query($query_os) or die(mysql_error());
00151 $broj_os = mysql_num_rows($result_os);
00152 }
00153 else {
00154 $broj_os = 0;
00155 }
00156 ;
00157
00158 //
00159 // trazimo u generalnim downloadima...
00160 //
00161 $query_downgen =
00162 "SELECT DISTINCT upload.upload_ID
00163 FROM odsjek_predmet, predmet, upload
00164 WHERE odsjek_predmet.odsjek_ID = '$odsjek'
00165 AND predmet.predmet_ID = upload.predmet_ID
00166 AND odsjek_predmet.datum_kraja = '0000-00-00'
00167 AND predmet.semestar_pocetak >= $sem_poc
00168 AND predmet.semestar_pocetak <= $sem_kraj
00169 AND predmet.semestar_polaganje >= $sem_poc
00170 AND predmet.semestar_polaganje <= $sem_kraj";
00171
00172 $result_downgen = mysql_query($query_downgen) or
00173 die(mysql_error());
00174 if (mysql_num_rows($result_downgen)!=0){
00175 $count_dg = 0;
00176 // opet kerefeke za ubrzanje query-a
00177 while ($row_downgen = mysql_fetch_array($result_downgen)){
00178 $dgid[$count_dg] = $row_downgen[0];
00179 $count_dg++;
00180 }
00181
00182 $query_dg_start =
00183 "SELECT upload.upload_ID
00184 FROM upload
00185 WHERE upload.opis_dokumenta LIKE '%$keyword%'
00186 OR upload.naziv_dokumenta LIKE '%$keyword%'
00187 HAVING upload.upload_ID IN (";
00188
00189 $broj_dg = 0;
00190 $query_dg_add = "";
00191 while ($broj_dg < $count_dg){
00192 $query_dg_add .= "'".$dgid[$broj_dg]."', ";
00193 $broj_dg++;
00194 }
00195 $len_dg = strlen($query_dg_add);
00196 $query_dg_add = substr($query_dg_add, 0, ($len_dg-2));
00197
00198 $query_dg_end =
00199 ")";
00200
00201 $query_dg = $query_dg_start.$query_dg_add.$query_dg_end;
00202
00203 $result_dg = mysql_query($query_dg) or die(mysql_error());
00204 $broj_dg = mysql_num_rows($result_dg);
00205 }
00206 else {
00207 $broj_dg = 0;
00208 }
00209
00210 //
00211 // trazimo u personalnim downloadima...kako je lijepo kad su tabele jednostavne... :)
00212 //
00213 $query_dp =
00214 "SELECT down_personal_ID
00215 FROM downloadi_personal
00216 WHERE student_id = '$id'
00217 AND down_opis LIKE '%$keyword%'
00218 OR down_ime LIKE '%$keyword%'";
00219
00220 $result_dp = mysql_query($query_dp) or die(mysql_error());
00221 $broj_dp = mysql_num_rows($result_dp);
00222
00223
00224 //
00225 // trazimo u generalnim linkovima
00226 //
00227 $query_lg=
00228 "SELECT links_ID
00229 FROM linkovi_links
00230 WHERE links_opis LIKE '%$keyword%'
00231 OR links_naziv LIKE '%$keyword%'";
00232
00233 $result_lg = mysql_query($query_lg) or die(mysql_error());
00234 $broj_lg = mysql_num_rows($result_lg);
00235
00236
00237 //
00238 // i napokon, trazimo u personalnim linkovima...
00239 //
00240 $query_lp =
00241 "SELECT links_id
00242 FROM linkovi_personal_links
00243 WHERE student_id = '$id'
00244 AND links_opis LIKE '%$keyword%'
00245 OR links_naziv LIKE '%$keyword%'";
00246
00247 $result_lp = mysql_query($query_lp) or die(mysql_error());
00248 $broj_lp = mysql_num_rows($result_lp);
00249
00250 printSearchStart($broj_op, $broj_os, $broj_dg, $broj_dp, $broj_lg, $broj_lp, $keyword);
00251 }
00252
00253 }
|
|
||||||||||||||||
|
Definirano u liniji 582 datoteke func_search.php. Reference _SEARCHRESULTGENDOWNFOR, getSemestarKraj(), getSemestarPocetak(), id, printDownGeneral(), printRokoviKraj()printRokoviStart().
00582 {
00583 $sem_poc = getSemestarPocetak($id);
00584 $sem_kraj = getSemestarKraj($id);
00585 //
00586 // trazimo u generalnim downloadima...
00587 //
00588 $query_downgen =
00589 "SELECT DISTINCT upload.upload_ID
00590 FROM odsjek_predmet, predmet, upload
00591 WHERE odsjek_predmet.odsjek_ID = '$odsjek'
00592 AND predmet.predmet_ID = upload.predmet_ID
00593 AND odsjek_predmet.datum_kraja = '0000-00-00'
00594 AND predmet.semestar_pocetak >= $sem_poc
00595 AND predmet.semestar_pocetak <= $sem_kraj
00596 AND predmet.semestar_polaganje >= $sem_poc
00597 AND predmet.semestar_polaganje <= $sem_kraj";
00598
00599 $result_downgen = mysql_query($query_downgen) or
00600 die(mysql_error());
00601 $count_dg = 0;
00602 // opet kerefeke za ubrzanje query-a
00603 while ($row_downgen = mysql_fetch_array($result_downgen)){
00604 $dgid[$count_dg] = $row_downgen[0];
00605 $count_dg++;
00606 }
00607
00608 $query_dg_start =
00609 "SELECT upload.upload_id, upload.naziv_dokumenta, upload.opis_dokumenta, upload.datum_uploada, upload.velicina
00610 FROM upload
00611 WHERE upload.opis_dokumenta LIKE '%$keyword%'
00612 OR upload.naziv_dokumenta LIKE '%$keyword%'
00613 HAVING upload.upload_ID IN (";
00614
00615 $broj_dg = 0;
00616 $query_dg_add = "";
00617 while ($broj_dg < $count_dg){
00618 $query_dg_add .= "'".$dgid[$broj_dg]."', ";
00619 $broj_dg++;
00620 }
00621 $len_dg = strlen($query_dg_add);
00622 $query_dg_add = substr($query_dg_add, 0, ($len_dg-2));
00623
00624 $query_dg_end =
00625 ")";
00626
00627 $query_dg = $query_dg_start.$query_dg_add.$query_dg_end;
00628
00629 $result_dg = mysql_query($query_dg) or die(mysql_error());
00630
00631 $brojac=0;
00632 while ($row_predmeti = mysql_fetch_array($result_dg)){
00633 $down_general[$brojac][0] = $row_predmeti[0];
00634 $down_general[$brojac][1] = $row_predmeti[1];
00635 $down_general[$brojac][2] = $row_predmeti[2];
00636 $down_general[$brojac][3] = $row_predmeti[3];
00637 $down_general[$brojac][4] = round(($row_predmeti[4]/1024),2)." KB";
00638
00639 $down_general[$brojac][1] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $down_general[$brojac][1]);
00640 $down_general[$brojac][2] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $down_general[$brojac][2]);
00641
00642 $keyword1 = ucfirst($keyword);
00643 $down_general[$brojac][1] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $down_general[$brojac][1]);
00644 $down_general[$brojac][2] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $down_general[$brojac][2]);
00645
00646 $keyword2 = strtoupper($keyword);
00647 $down_general[$brojac][1] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $down_general[$brojac][1]);
00648 $down_general[$brojac][2] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $down_general[$brojac][2]);
00649
00650 $brojac++;
00651 }
00652
00653
00654 printRokoviStart(_SEARCHRESULTGENDOWNFOR." <font color=\"#FF0000\">".$keyword."</font>", 724);
00655 printDownGeneral($down_general, $brojac, $pid);
00656 printRokoviKraj();
00657 }
|
|
||||||||||||
|
Definirano u liniji 662 datoteke func_search.php. Reference _SEARCHRESULTPERSDOWNFOR, printDownPersonal(), printRokoviKraj()printRokoviStart().
00662 {
00663
00664 $query_dp =
00665 "SELECT down_personal_ID, down_ime, down_opis, down_size, down_datum
00666 FROM downloadi_personal
00667 WHERE student_id = '$id'
00668 AND down_opis LIKE '%$keyword%'
00669 OR down_ime LIKE '%$keyword%'";
00670
00671 $result_personal = mysql_query($query_dp) or die(mysql_error());
00672
00673 $brojac_personal = 0;
00674 while ($row_personal = mysql_fetch_array($result_personal)){
00675 $down_personal[$brojac_personal][0] = $row_personal[0];
00676 $down_personal[$brojac_personal][1] = $row_personal[1];
00677 $down_personal[$brojac_personal][2] = $row_personal[2];
00678 $down_personal[$brojac_personal][3] = round(($row_personal[3]/1024),2)." KB";
00679 $down_personal[$brojac_personal][4] = $row_personal[4];
00680
00681
00682 $down_personal[$brojac_personal][1] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $down_personal[$brojac_personal][1]);
00683 $down_personal[$brojac_personal][2] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $down_personal[$brojac_personal][2]);
00684
00685 $keyword1 = ucfirst($keyword);
00686 $down_personal[$brojac_personal][1] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $down_personal[$brojac_personal][1]);
00687 $down_personal[$brojac_personal][2] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $down_personal[$brojac_personal][2]);
00688
00689 $keyword2 = strtoupper($keyword);
00690 $down_personal[$brojac_personal][1] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $down_personal[$brojac_personal][1]);
00691 $down_personal[$brojac_personal][2] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $down_personal[$brojac_personal][2]);
00692
00693 $brojac_personal++;
00694
00695 }
00696 printRokoviStart(_SEARCHRESULTPERSDOWNFOR." <font color=\"#FF0000\">".$keyword."</font>", 724);
00697 printDownPersonal($down_personal, $brojac_personal);
00698 printRokoviKraj();
00699 }
|
|
|
Definirano u liniji 701 datoteke func_search.php. Reference _SEARCHRESULTGENLINKSFOR, printLinkoviSearch(), printRokoviKraj(), printRokoviStart()result.
00701 {
00702
00703 $query_lg=
00704 "SELECT links_url, links_naziv, links_opis
00705 FROM linkovi_links
00706 WHERE links_opis LIKE '%$keyword%'
00707 OR links_naziv LIKE '%$keyword%'";
00708
00709 $result = mysql_query($query_lg) or die(mysql_error());
00710
00711
00712 $brojac_url = 0;
00713 while ($row = mysql_fetch_array($result)){
00714 $link_url[$brojac_url][0] = $row[0];
00715 $link_url[$brojac_url][1] = $row[1];
00716 $link_url[$brojac_url][2] = $row[2];
00717
00718
00719 $link_url[$brojac_url][1] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $link_url[$brojac_url][1]);
00720 $link_url[$brojac_url][2] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $link_url[$brojac_url][2]);
00721
00722 $keyword1 = ucfirst($keyword);
00723 $link_url[$brojac_url][1] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $link_url[$brojac_url][1]);
00724 $link_url[$brojac_url][2] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $link_url[$brojac_url][2]);
00725
00726 $keyword2 = strtoupper($keyword);
00727 $link_url[$brojac_url][1] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $link_url[$brojac_url][1]);
00728 $link_url[$brojac_url][2] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $link_url[$brojac_url][2]);
00729
00730 $brojac_url++;
00731 }
00732 printRokoviStart(_SEARCHRESULTGENLINKSFOR." <font color=\"#FF0000\">".$keyword."</font>", 724);
00733 printLinkoviSearch($link_url, $brojac_url, "general");
00734 printRokoviKraj();
00735 }
|
|
||||||||||||
|
Definirano u liniji 738 datoteke func_search.php. Reference _SEARCHRESULTPERSLINKSFOR, printLinkoviSearch(), printRokoviKraj(), printRokoviStart()result.
00738 {
00739
00740 $query_lg=
00741 "SELECT links_url, links_naziv, links_opis, links_ID
00742 FROM linkovi_personal_links
00743 WHERE student_id = '$id'
00744 AND links_opis LIKE '%$keyword%'
00745 OR links_naziv LIKE '%$keyword%'";
00746
00747 $result = mysql_query($query_lg) or die(mysql_error());
00748
00749
00750 $brojac_url = 0;
00751 while ($row = mysql_fetch_array($result)){
00752 $link_url[$brojac_url][0] = $row[0];
00753 $link_url[$brojac_url][1] = $row[1];
00754 $link_url[$brojac_url][2] = $row[2];
00755 $link_url[$brojac_url][3] = $row[3];
00756
00757 $link_url[$brojac_url][1] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $link_url[$brojac_url][1]);
00758 $link_url[$brojac_url][2] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $link_url[$brojac_url][2]);
00759
00760 $keyword1 = ucfirst($keyword);
00761 $link_url[$brojac_url][1] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $link_url[$brojac_url][1]);
00762 $link_url[$brojac_url][2] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $link_url[$brojac_url][2]);
00763
00764 $keyword2 = strtoupper($keyword);
00765 $link_url[$brojac_url][1] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $link_url[$brojac_url][1]);
00766 $link_url[$brojac_url][2] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $link_url[$brojac_url][2]);
00767
00768 $brojac_url++;
00769 }
00770 printRokoviStart(_SEARCHRESULTPERSLINKSFOR." <font color=\"#FF0000\">".$keyword."</font>", 724);
00771 printLinkoviSearch($link_url, $brojac_url, "personal");
00772 printRokoviKraj();
00773 }
|
|
||||||||||||||||||||||||
|
Definirano u liniji 259 datoteke func_search.php. Reference countSearchPred(), getColor(), getObavPerPage(), getSemestarKraj(), getSemestarPocetak(), id, noNews(), nr_set_obavprintObavjestenje().
00259 {
00260
00261 $nr_set_obav = getObavPerPage($id);
00262 //
00263 // funkcija ispisuje rezultate pretrage...
00264 //
00265 $sem_poc = getSemestarPocetak($id);
00266 $sem_kraj = getSemestarKraj($id);
00267
00268 $query_predmeti =
00269 "SELECT DISTINCT obavjestenje.obavjestenje_ID
00270 FROM obavjestenje, obavjestenje_predavac, odsjek_predmet, predmet
00271 WHERE odsjek_predmet.odsjek_ID = '$odsjek'
00272 AND obavjestenje_predavac.obavjestenje_ID = obavjestenje.obavjestenje_ID
00273 AND obavjestenje_predavac.predmet_ID = odsjek_predmet.predmet_ID
00274 AND obavjestenje.status_obavjestenja = 'objavljeno'
00275 AND predmet.predmet_ID = obavjestenje_predavac.predmet_ID
00276 AND odsjek_predmet.datum_kraja = '0000-00-00'
00277 AND predmet.semestar_pocetak >= $sem_poc
00278 AND predmet.semestar_pocetak <= $sem_kraj
00279 AND predmet.semestar_polaganje >= $sem_poc
00280 AND predmet.semestar_polaganje <= $sem_kraj
00281 AND obavjestenje.obavjestenje_ID =obavjestenje_predavac.obavjestenje_ID
00282 ORDER BY obavjestenje.obavjestenje_ID";
00283
00284 $result_predmeti = mysql_query($query_predmeti) or
00285 die(mysql_error());
00286 $count = 0;
00287 // opet kerefeke za ubrzanje query-a
00288 while ($row_predmeti = mysql_fetch_array($result_predmeti)){
00289 $oid[$count] = $row_predmeti[0];
00290 $count++;
00291 }
00292
00293 $query_op_start =
00294 "SELECT obavjestenje.naslov, obavjestenje.text, obavjestenje.obavjestenje_ID
00295 FROM obavjestenje
00296 WHERE obavjestenje.text LIKE '%$keyword%'
00297 OR obavjestenje.naslov LIKE '%$keyword%'
00298 HAVING obavjestenje.obavjestenje_ID IN (";
00299
00300 $broj = 0;
00301 $query_op_add = "";
00302 while ($broj < $count){
00303 $query_op_add .= "'".$oid[$broj]."', ";
00304 $broj++;
00305 }
00306 $len = strlen($query_op_add);
00307 $query_op_add = substr($query_op_add, 0, ($len-2));
00308
00309 $query_op_end =
00310 ")
00311 ";
00312 $query_op_l = "LIMIT ". $red.", ". $nr_set_obav;
00313
00314
00315 $query_op_export = $query_op_start.$query_op_add.$query_op_end;
00316
00317 $query_op = $query_op_export.$query_op_l;
00318
00319
00320 countSearchPred($id, $query_op_export, $stranica, $keyword, 1);
00321
00322 $result_ob_prof = mysql_query($query_op) or
00323 die(mysql_error());
00324
00325
00326 if (mysql_num_rows($result_ob_prof)==0){
00327 noNews();
00328 }
00329 else {
00330
00331
00332 while ($row_ob_prof = mysql_fetch_array($result_ob_prof)){
00333
00334 $ob_id= $row_ob_prof[2];
00335 $query_prof =
00336 "SELECT predavac.ime_predavaca, predavac.prezime_predavaca, obavjestenje_predavac.datum_postavljanja
00337 FROM predavac, obavjestenje_predavac
00338 WHERE obavjestenje_predavac.obavjestenje_ID = '$ob_id'
00339 AND predavac.predavac_ID = obavjestenje_predavac.predavac_ID";
00340 $result_prof = mysql_query($query_prof) or
00341 die(mysql_error());
00342
00343 $row_prof = mysql_fetch_array($result_prof);
00344
00345 $query_pred = "SELECT predmet.naziv_predmeta
00346 FROM predmet, obavjestenje_predavac
00347 WHERE obavjestenje_predavac.obavjestenje_ID = '$ob_id'
00348 AND predmet.predmet_ID = obavjestenje_predavac.predmet_ID";
00349
00350 $result_pred = mysql_query($query_pred) or
00351 die(mysql_error());
00352
00353 if (mysql_num_rows($result_pred)!==0){
00354
00355 $row_pred = mysql_fetch_array($result_pred);
00356
00357
00358 $headPr = $row_pred['naziv_predmeta'];
00359 $naslovPr = $row_ob_prof[0];
00360 $textPr = $row_ob_prof[1];
00361 $datumPr = $row_prof[2];
00362 $profesor = $row_prof['ime_predavaca'] . " " . $row_prof['prezime_predavaca'];
00363 $color = getColor($id, 2);
00364 $picture = "small.jpg";
00365
00366 $textPr = nl2br($textPr);
00367
00368 $textPr = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $textPr);
00369 $naslovPr = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $naslovPr);
00370 $keyword1 = ucfirst($keyword);
00371 $textPr = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $textPr);
00372 $naslovPr = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $naslovPr);
00373 $keyword2 = strtoupper($keyword);
00374 $textPr = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $textPr);
00375 $naslovPr = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $naslovPr);
00376
00377
00378 printObavjestenje($headPr, $naslovPr, $textPr, $datumPr, $profesor, $color, $picture);
00379
00380 }
00381
00382 }
00383 }
00384 countSearchPred($id, $query_op_export, $stranica, $keyword, 0);
00385 }
|
|
||||||||||||||||||||
|
Definirano u liniji 456 datoteke func_search.php. Reference _SSERVICE, countSearchsss(), getColor(), getObavPerPage(), id, noNews(), nr_set_obavprintObavjestenje().
00456 {
00457
00458 $nr_set_obav = getObavPerPage($id);
00459 //
00460 // funkcija ispisuje rezultate pretrage...
00461 //
00462 $query_sss =
00463 "SELECT obavjestenje.obavjestenje_ID
00464 FROM obavjestenje, obavjestenje_sss, sss
00465 WHERE obavjestenje.tip_obavjestenja = 'sss'
00466 AND obavjestenje_sss.obavjestenje_ID = obavjestenje.obavjestenje_ID
00467 AND obavjestenje_sss.sss_ID = sss.sss_ID
00468 AND obavjestenje.status_obavjestenja = 'objavljeno'";
00469
00470 $result_sss = mysql_query($query_sss) or die(mysql_error());
00471 $count_sss = 0;
00472 // opet kerefeke za ubrzanje query-a
00473 while ($row_sss = mysql_fetch_array($result_sss)){
00474 $oid_sss[$count_sss] = $row_sss[0];
00475 $count_sss++;
00476 }
00477
00478 $query_os_start =
00479 "SELECT obavjestenje.naslov, obavjestenje.text, obavjestenje.obavjestenje_ID
00480 FROM obavjestenje
00481 WHERE obavjestenje.text LIKE '%$keyword%'
00482 OR obavjestenje.naslov LIKE '%$keyword%'
00483 HAVING obavjestenje.obavjestenje_ID IN (";
00484
00485 $broj_sss = 0;
00486 $query_os_add = "";
00487
00488 while ($broj_sss < $count_sss){
00489 $query_os_add .= "'".$oid_sss[$broj_sss]."', ";
00490 $broj_sss++;
00491 }
00492
00493 $len_sss = strlen($query_os_add);
00494 $query_os_add = substr($query_os_add, 0, ($len_sss-2));
00495
00496 $query_os_end =
00497 ")
00498 ";
00499
00500 $query_os_l = "LIMIT ". $red.", ". $nr_set_obav;
00501
00502 $query_os_export = $query_os_start.$query_os_add.$query_os_end;
00503 $query_os = $query_os_export.$query_os_l;
00504
00505
00506 countSearchsss($id, $query_os_export, $stranica, $keyword, 1);
00507
00508
00509
00510 $result_os_sss = mysql_query($query_os) or die(mysql_error());
00511
00512 if (mysql_num_rows($result_os_sss)==0){
00513 noNews();
00514 }
00515
00516 else {
00517
00518 while ($row_os_sss = mysql_fetch_array($result_os_sss)){
00519 $ob_id= $row_os_sss[2];
00520
00521 $query_sss =
00522 "SELECT sss.ime_sss, sss.prezime_sss, obavjestenje_sss.datum_postavljanja
00523 FROM sss, obavjestenje_sss
00524 WHERE obavjestenje_sss.obavjestenje_ID = '$ob_id'
00525 AND sss.sss_ID = obavjestenje_sss.sss_ID ";
00526
00527
00528
00529
00530 $result_sss = mysql_query($query_sss) or die(mysql_error());
00531
00532 $row_sss = mysql_fetch_array($result_sss);
00533
00534
00535 $headPr = _SSERVICE;
00536 $naslovPr = $row_os_sss[0];
00537 $textPr = $row_os_sss[1];
00538 $datumPr = $row_sss[2];
00539 $autor = $row_sss[0] . " " . $row_sss[1];
00540 $color = getColor($id, 3);
00541 $picture = "smallo.jpg";
00542
00543 $textPr = nl2br($textPr);
00544
00545 $textPr = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $textPr);
00546 $naslovPr = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $naslovPr);
00547 $keyword1 = ucfirst($keyword);
00548 $textPr = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $textPr);
00549 $naslovPr = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $naslovPr);
00550 $keyword2 = strtoupper($keyword);
00551 $textPr = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $textPr);
00552 $naslovPr = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $naslovPr);
00553
00554
00555 printObavjestenje($headPr, $naslovPr, $textPr, $datumPr, $autor, $color, $picture);
00556 }
00557 }
00558 countSearchsss($id, $query_os_export, $stranica, $keyword, 0);
00559 }
|
|
||||||||||||||||||||||||
|
Definirano u liniji 410 datoteke func_search.php. Reference getObavPerPage(), idnr_set_obav. Referencirano od countSearchPred()countSearchsss().
00410 {
00411
00412 $nr_set_obav = getObavPerPage($id);
00413 //
00414 // na osnovu broja obavjestenja pravi izbor stranica
00415 //
00416 echo " <center><table cellpadding=\"0\" cellspacing=\"0\">\n";
00417 echo " <tr>\n";
00418 echo " <td width=\"15\"><div align=\"center\">\n";
00419
00420 if (isset($stranica) && $stranica<>1){
00421 echo " <font color=\"#4B4B4B\" class=\"textsize1\"><strong>";
00422 echo " <a href=\"search.php?&tip=".$tip."&keyword=" . $keyword . "&stranica=" . ($stranica-1) . "\"><<</a></div></strong></font></td>\n";
00423 }
00424 else {
00425 echo " <font color=\"#B6B6B6\" class=\"textsize1\"><strong>";
00426 echo "<<</div></strong></font></td>\n";
00427 }
00428
00429 for ($i=0; $i<($broj_obavjestenja / $nr_set_obav); $i++){
00430 $j = $i;
00431 echo " <td width=\"15\"><div align=\"center\">\n";
00432 if (++$j != $stranica){
00433 echo " <font color=\"#4B4B4B\" class=\"textsize1\"><strong>";
00434 echo " <a href=\"search.php?&tip=".$tip."&keyword=" . $keyword . "&stranica=" . $j . "\"> ". $j . " </a></div></strong></font></td>\n";
00435 }
00436 else {
00437 echo " <font color=\"#B6B6B6\" class=\"textsize1\"><strong>";
00438 echo $j . "</a></div></strong></font></td>\n";
00439 }
00440 }
00441 echo " <td width=\"15\"><div align=\"center\">\n";
00442
00443
00444 if (isset($stranica) and $stranica < $j){
00445 echo " <font color=\"#4B4B4B\" class=\"textsize1\"><strong>";
00446 echo " <a href=\"search.php?&tip=".$tip."&keyword=" . $keyword . "&stranica=" . ($stranica+1) . "\">>></a></div></strong></font></td>\n";
00447 }
00448 else {
00449 echo " <font color=\"#B6B6B6\" class=\"textsize1\"><strong>";
00450 echo ">></div></strong></font></td>\n";
00451 }
00452 echo " </tr></table></center>\n";
00453 }
|
1.3.2