1 |
<? |
2 |
|
3 |
// TODO: provjeravati da li kontakt osoba ima privilegije za upis |
4 |
// statusa u bazu!! |
5 |
|
6 |
$conn = pg_connect("dbname=informatika user=dpavlin"); |
7 |
if (isset($date_offset) && $date_offset!=0) { |
8 |
$result = pg_Exec ($conn, " |
9 |
insert into status (osoba_id,kontakt_osoba_id,datum, |
10 |
status_tip_id) |
11 |
values ($osoba_id,$kontakt_osoba_id,now()+$date_offset, |
12 |
$status_tip_id) |
13 |
"); |
14 |
} else { |
15 |
$result = pg_Exec ($conn, " |
16 |
insert into status (osoba_id,kontakt_osoba_id,datum, |
17 |
status_tip_id) |
18 |
values ($osoba_id,$kontakt_osoba_id,'now'::datetime, |
19 |
$status_tip_id) |
20 |
"); |
21 |
} |
22 |
|
23 |
if ($result) { |
24 |
if ($status_tip_id==4 | $status_tip_id==10) { |
25 |
$sql1="update racuni set aktivan=false where osoba_id=$osoba_id"; |
26 |
$sql2="update osobe set aktivna=false where id=$osoba_id"; |
27 |
pg_Exec ($conn,"$sql1"); |
28 |
pg_Exec ($conn,"$sql2"); |
29 |
} |
30 |
Header("Location: obavijest.php?id=$osoba_id"); |
31 |
} else { |
32 |
include("inc/head.inc"); |
33 |
print "GreĀ¹ka kod upisa podataka u bazu!"; |
34 |
} |
35 |
|
36 |
?> |