/[informatika.old]/html/obavijest.php
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Annotation of /html/obavijest.php

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.15.2.2 - (hide annotations)
Wed Aug 2 13:10:00 2000 UTC (23 years, 9 months ago) by dpavlin
Branch: dbi
Changes since 1.15.2.1: +2 -1 lines 
dodane nedostajuæi "from tablica,..."
1 dpavlin 1.1 <?
2    
3     include("inc/head.inc");
4 dpavlin 1.4 include("inc/prava.inc");
5 dpavlin 1.14 include("inc/print_bool2.inc");
6 dpavlin 1.7 include("inc/bgcolor.inc");
7 dpavlin 1.1
8 dpavlin 1.4 if (isset($kontakt_osoba_id) && $what!="relogin") {
9 dpavlin 1.15.2.1 $sth = $dbh->prepare("select ime,prezime,passwd,prava from kontakt_osobe where aktivna=true and id=$kontakt_osoba_id");
10     $sth->execute();
11     $korow=$sth->fetchrow_hash();
12 dpavlin 1.7 # print "--$korow[passwd] | $md5_passwd | $passwd ";
13     $prava=$korow[prava];
14     print "<small>Trenutno ste prijavljeni kao $korow[ime] $korow[prezime], ako je to krivo odaberite <a href=\"$PHP_SELF?what=relogin\">ovaj link</a>.</small>";
15 dpavlin 1.15 $curr_md5_passwd=md5($korow[passwd]);
16 dpavlin 1.7 if ( (!isset($md5_passwd) && $korow[passwd] != $passwd) ||
17 dpavlin 1.4 (isset($md5_passwd) && $curr_md5_passwd != $md5_passwd) ) {
18     include("inc/auth.inc");
19     $what="auth";
20     echo "<big>Upisana je neispravna loznika!</big>";
21     session_destroy();
22     print '<p><a href="index.php">Povratak na poèetnu stranicu</a>';
23     } else {
24     session_register("md5_passwd");
25 dpavlin 1.15 $md5_passwd=md5($korow[passwd]);
26 dpavlin 1.4 }
27     }
28    
29 dpavlin 1.7 #print "--$pr_ko--";
30 dpavlin 1.4
31     if (! isset($kontakt_osoba_id)) {
32     include("inc/auth.inc");
33     $what="auth";
34    
35     } elseif (! isset($id)) {
36 dpavlin 1.2 include("inc/obavjest-forma.inc");
37 dpavlin 1.7 } elseif (isset($id) && $what!="auth") {
38 dpavlin 1.2
39 dpavlin 1.15.2.1 $sth = $dbh->prepare("
40 dpavlin 1.1 select osobe.id as id,ime,prezime,tel,lokacije.naziv as lok,sifra,
41     org_jed.naziv as orgjed,org_pod_jed.pod_naziv as orgpodjed,
42 dpavlin 1.7 lok_racunala as lokrac,objekt,kat,soba,z_rac,podesavanje,
43     umrezavanje,shell
44 dpavlin 1.15.2.2 from osobe,lokacije,org_jed,org_pod_jed
45 dpavlin 1.1 where osobe.id=$id
46     and lokacija_id=lokacije.id and org_jed_id=org_jed.id
47     and org_pod_jed_id=org_pod_jed.pod_id
48     order by lokacije.naziv,org_jed.naziv
49     ");
50    
51 dpavlin 1.15.2.1 $sth->execute();
52    
53     if ($row=$sth->fetchrow_hash()) {
54 dpavlin 1.1
55     print "
56     <h1>Podaci o osobi</h1>
57    
58     <table>
59     <tr><td><small>Ime i prezime:</small></td>
60     <td>$row[ime] $row[prezime]</td>
61     <td><small>Tel:</small> $row[tel]</td></tr>
62     <tr><td><small>Org. jedinica:</small></td>
63     <td>$row[orgjed]</td>
64     <td><small>©ifra radnika:</small> $row[sifra]</td></tr>
65     <tr><td><small>Podjedinica:</small></td>
66     <td>$row[orgpodjed]</td>
67     <td><small>Lokacija raèunala:</small></td></tr>
68     <tr><td><small>Lokacija:</small></td>
69     <td>$row[lok]</td>
70     <td>$row[lokrac]</td></tr>
71     <tr><td><small>Objekt/soba/kat:</small></td>
72     <td>$row[objekt] / $row[soba] / $row[kat]</td>
73     <td><small>® raèunala:</small> $row[z_rac]</td></tr>
74 dpavlin 1.14 <tr><td>Shell: ".print_bool($row[shell])."</td>
75     <td>Umre¾avanje: ".print_bool($row[umrezavanje])."</td>
76     <td>Pode¹avanje: ".print_bool($row[podesavanje])."</td>
77 dpavlin 1.1 </table>
78     ";
79    
80 dpavlin 1.13
81     if ($prava & $pr_promjena) {
82     print "<small><a href=\"osoba.php?what=select-osoba&id=$id\">[promjeni podatke o osobi]</a></small>";
83     }
84    
85 dpavlin 1.4 // kreiraj statuse, zapamti da li je instaliran
86    
87     $instaliran=0;
88    
89 dpavlin 1.15.2.1 $sth = $dbh->prepare("select status.id as status_id,datum,opis,ime,prezime,status_tip_id as st
90 dpavlin 1.4 from status,kontakt_osobe,status_tip
91     where kontakt_osoba_id=kontakt_osobe.id and status_tip_id=status_tip.id
92 dpavlin 1.6 and osoba_id=$id order by datum");
93 dpavlin 1.15.2.1 $sth->execute();
94 dpavlin 1.4
95     $statusi="";
96    
97 dpavlin 1.15.2.1 $nr=0;
98     while($row=$sth->fetchrow_hash()) {
99     if ($row[st] != 2) {
100     $statusi.="<tr ".bgcolor()."><td><small>$row[datum]</small></td><td>$row[opis]</td><td>$row[ime] $row[prezime]</td></tr>";
101     } else {
102     $statusi.="<tr ".bgcolor()."><td><small>$row[datum]</small></td><td><a href=\"promjene.php?osoba_id=$id&status_id=$row[status_id]\">$row[opis]</a></td><td>$row[ime] $row[prezime]</td></tr>";
103 dpavlin 1.4 }
104 dpavlin 1.15.2.1 if ($row[st] == 6) { $instaliran = 1; };
105     $nr++;
106     }
107    
108     if ($nr == 0) {
109 dpavlin 1.4 $statusi.="<p><big>Nema podataka o korisnièkom raèunu</big>";
110     }
111    
112    
113 dpavlin 1.15.2.1 $sth = $dbh->prepare("select racuni.login as login,
114 dpavlin 1.1 racuni.passwd as passwd,e_mail.alias as email
115 dpavlin 1.15.2.2 from racuni,e_mail
116 dpavlin 1.1 where racuni.osoba_id=$id and e_mail.osoba_id=$id");
117 dpavlin 1.15.2.1 $sth->execute();
118 dpavlin 1.1
119 dpavlin 1.15.2.1 if ($row=$sth->fetchrow_hash()) {
120 dpavlin 1.1
121     print "
122     <h1>Podaci o korisnièkom raèunu</h1>
123    
124     <table>
125     <tr><td>Korisnièka oznaka:</td><td><tt>$row[login]</tt></td></tr>
126 dpavlin 1.4 ";
127 dpavlin 1.7 if ($prava & $pr_instalacija) {
128 dpavlin 1.4 print "<tr><td>Lozinka:</td><td><tt>$row[passwd]</tt></td></tr>";
129     } else {
130     print "<tr><td colspan=2><i>Nemate ovla¹tenja vidjeti lozinku ovog korisnika!</i></td></tr>";
131     }
132     print "
133 dpavlin 1.1 <tr><td>E-mail adresa:</td><td><tt>$row[email]@pliva.hr</tt></td></tr>
134     </table>
135     ";
136    
137     } else {
138     print "<p><big>Nema podataka o korisnièkom raèunu</big>";
139     }
140 dpavlin 1.2
141 dpavlin 1.3
142     print "
143 dpavlin 1.5 <h1>Podaci o statusima korisnièkog raèuna</h1>
144 dpavlin 1.3
145 dpavlin 1.7 <form action=oznaci.php>
146     <input type=hidden name=kontakt_osoba_id value=$kontakt_osoba_id>
147     <input type=hidden name=osoba_id value=$id>
148    
149     <table border=0>
150 dpavlin 1.4 <tr><th>datum</th><th>status</th><th>status postavio/la</th></tr>
151 dpavlin 1.10 $statusi";
152 dpavlin 1.7
153 dpavlin 1.10 $statusi="<tr>";
154    
155     if ($prava == $pr_admin) {
156     $statusi.="<td><select name=date_offset>
157     <option value=>danas</option>
158     <option value=1>sutra</option>";
159     $dani=array("nedjelju","ponedjeljak","utorak","srijedu",
160     "èetvrtak","petak","subotu");
161     for ($d=2; $d<10; $d++) {
162     $statusi.="<option value=$d>u ".$dani[(date("w")+$d) % 7].", ". date("d.m.Y",time()+$d*24*60*60)."</option>";
163     }
164     $statusi.="</select></td>";
165     } else {
166     $statusi.="<td align=right><b>Dodati status:</b></td>";
167     }
168    
169     $statusi.="<td><select name=status_tip_id>";
170 dpavlin 1.7
171 dpavlin 1.15.2.1 $sth = $dbh->prepare("select id,opis
172 dpavlin 1.7 from status_tip
173     where id >= 5
174     ");
175 dpavlin 1.15.2.1 $sth->execute();
176 dpavlin 1.7
177 dpavlin 1.10 $num_prava=0;
178    
179 dpavlin 1.15.2.1 while ($row=$sth->fetchrow_hash()) {
180 dpavlin 1.9 if ($prava & pow(2,$row[id])) {
181 dpavlin 1.10 $statusi.="<option value=$row[id]>$row[opis]</option>\n";
182     $num_prava++;
183 dpavlin 1.9 }
184 dpavlin 1.7 }
185    
186 dpavlin 1.10 $statusi.="</select></td>
187     <td>$korow[ime] $korow[prezime]</td>
188     <td><input type=submit value=\"Dodaj\"></td></tr>";
189 dpavlin 1.7
190 dpavlin 1.10 if ($num_prava>0) {
191     print "$statusi";
192     }
193    
194     print "
195 dpavlin 1.7 </table>
196     </form>
197    
198 dpavlin 1.8 <small>Broj trenutnog zahtjeva: $id</small>
199     <hr>
200 dpavlin 1.7 ";
201 dpavlin 1.8
202 dpavlin 1.15.2.1 } else { // nema rezultata
203 dpavlin 1.8 print "<p><big>Nema podataka o osobi sa id-jem $id</big>";
204 dpavlin 1.15.2.1 }
205 dpavlin 1.8
206     include("inc/obavjest-forma.inc");
207 dpavlin 1.2
208     } // isset($id)
209 dpavlin 1.7
210 dpavlin 1.11 print "<p>Povratak na ";
211     if (isset($HTTP_REFERER)) {
212     print "<a href=\"$HTTP_REFERER\">stranicu sa koje ste do¹li</a> ili ";
213     }
214     print "<a href=\"/\">poèetnu stranicu</a>.";
215    
216 dpavlin 1.7
217     include("inc/footer.inc");
218 dpavlin 1.2
219     ?>
220 dpavlin 1.1
  ViewVC Help
Powered by ViewVC 1.1.26