00001 <?
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032 function kontaktProfesora($id, $odsjek){
00033
00034
00035 $sem_poc = getSemestarPocetak($id);
00036 $sem_kraj = getSemestarKraj($id);
00037
00038 $query = "SELECT DISTINCT predavac.email, predavac.ime_predavaca, predavac.prezime_predavaca
00039 FROM odsjek_predmet, predmet, predavac, predavac_predmet
00040 WHERE odsjek_predmet.odsjek_ID='$odsjek'
00041 AND predmet.predmet_ID = odsjek_predmet.predmet_ID
00042 AND predmet.semestar_pocetak BETWEEN $sem_poc AND $sem_kraj
00043 AND predmet.semestar_polaganje BETWEEN $sem_poc AND $sem_kraj
00044 AND predavac_predmet.datum_kraja = '0000-00-00'
00045 AND predavac_predmet.predmet_ID = predmet.predmet_ID
00046 AND predavac_predmet.predavac_ID = predavac.predavac_ID
00047 AND predavac.tip_predavaca = 'profesor'";
00048
00049 $result = mysql_query($query) or die(mysql_error());
00050
00051 if (mysql_num_rows($result) == 0){
00052 printServisGreska(_CONTACTNOPROF);
00053 }
00054 else {
00055
00056 $content[0] = "";
00057 $broj = 0;
00058 while ($row = mysql_fetch_array($result)){
00059
00060 $content[$broj] .= " <option value=\"".$row[0]."\">".$row[1]." ".$row[2]."</option>\n";
00061 $broj++;
00062 }
00063 $naslov = _CONTACTCHOSEPROF;
00064 printKontakt($naslov, $content, $broj, _PROFESOR);
00065
00066 }
00067
00068 }
00069
00070
00071
00072
00073
00074 function kontaktAsistenta($id, $odsjek){
00075
00076
00077 $sem_poc = getSemestarPocetak($id);
00078 $sem_kraj = getSemestarKraj($id);
00079
00080 $query = "SELECT DISTINCT predavac.email, predavac.ime_predavaca, predavac.prezime_predavaca
00081 FROM odsjek_predmet, predmet, predavac, predavac_predmet
00082 WHERE odsjek_predmet.odsjek_ID='$odsjek'
00083 AND predmet.predmet_ID = odsjek_predmet.predmet_ID
00084 AND predmet.semestar_pocetak BETWEEN $sem_poc AND $sem_kraj
00085 AND predmet.semestar_polaganje BETWEEN $sem_poc AND $sem_kraj
00086 AND predavac_predmet.datum_kraja = '0000-00-00'
00087 AND predavac_predmet.predmet_ID = predmet.predmet_ID
00088 AND predavac_predmet.predavac_ID = predavac.predavac_ID
00089 AND predavac.tip_predavaca = 'asistent'";
00090
00091 $result = mysql_query($query) or die(mysql_error());
00092
00093 if (mysql_num_rows($result) == 0){
00094 printServisGreska(_CONTACTNOASSIST);
00095 }
00096 else {
00097
00098 $content[0] = "";
00099 $broj = 0;
00100 while ($row = mysql_fetch_array($result)){
00101
00102 $content[$broj] .= "<option value=\"".$row[0]."\">".$row[1]." ".$row[2]."</option>\n";
00103 $broj++;
00104 }
00105 $naslov = _CONTACTCHOSEASSIST;
00106 printKontakt($naslov, $content, $broj, _ASSISTENT);
00107
00108 }
00109
00110 }
00111
00112
00113
00114
00115
00116 function kontaktSSS(){
00117
00118
00119 $query = "SELECT DISTINCT sss.email, sss.ime_sss, sss.prezime_sss
00120 FROM sss";
00121
00122 $result = mysql_query($query) or die(mysql_error());
00123
00124 if (mysql_num_rows($result) == 0){
00125 printServisGreska(_CONTACTNOSERVICE);
00126 }
00127 else {
00128
00129 $content[0] = "";
00130 $broj = 0;
00131 while ($row = mysql_fetch_array($result)){
00132
00133 $content[$broj] .= "<option value=\"".$row[0]."\">".$row[1]." ".$row[2]."</option>\n";
00134 $broj++;
00135 }
00136 $naslov = _CONTACTCHOSESERVICE;
00137 printKontakt($naslov, $content, $broj, _SERVICEWORKER);
00138
00139 }
00140
00141 }
00142
00143
00144
00145
00146
00147 function kontaktSendMail($email, $subject, $text, $id){
00148
00149 if (($email!="") && ($email!=-1)){
00150 if ($subject!=""){
00151 if ($text!=""){
00152
00153 $query = "SELECT email, ime_studenta, prezime_studenta
00154 FROM student
00155 WHERE student_ID = $id";
00156
00157 $result = mysql_query($query) or die(mysql_error());
00158 $row = mysql_fetch_array($result);
00159
00160 $headers ="From: ". $row[1]." ".$row[2]." <".$row[0].">\n";
00161 $headers .="Reply-To: ". $row[1]." ".$row[2]." <".$row[0].">\n";
00162 $headers .="MIME-Version: 1.0\r\n";
00163 $headers.="Content-Type: text;\n";
00164 $headers.="X-Sender: ". $row[1]." ".$row[2]." <".$row[0].">\n";
00165 $headers.="X-Mailer: Studentski Informacijski Servis @ ETF\n";
00166 $headers .= "Return-Path: <".$row[0].">\n";
00167 $headers.="Content-Type: text;\n";
00168
00169 mail($email, $subject, $text, $headers);
00170 printServisGreska(_CONTACTMESSAGESENT);
00171 }
00172 else {
00173 printServisGreska(_CONTACTNOMESSAGETEXT);
00174 }
00175 }
00176 else {
00177 printServisGreska(_CONTACTNOMESSAGETITLE);
00178 }
00179 }
00180 else {
00181 printServisGreska(_CONTACTNOMESSAGEDEST);
00182 }
00183 }
00184
00185 ?>