1 | 2 | simandl | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
2 | | | <html> |
3 | | | <head> |
4 | | | <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2"> |
5 | | | <style type="text/css" media="screen"> @import "style.css"; </style> |
6 | | | <title>Editace úkonu</title> |
7 | | | </head> |
8 | | | <link rel="stylesheet" type="text/css" href="style.css"> |
9 | | | </head> |
10 | | | <body topmargin=0 leftmargin=10> |
11 | | | <? |
12 | | | include("header.htm"); |
13 | | | require('grab_globals.lib.php'); |
14 | | | include ("fce.php"); |
15 | | | $spojeni = MySQL_Connect($db_host, $db_user, $db_pass); |
16 | | | MySQL_Select_DB($db_name); |
17 | | | |
18 | | | if(!@$action) |
19 | | | { |
20 | | | $dbukon=MySQL_Query("SELECT * FROM ukony WHERE id='$id' "); |
21 | | | $dbukon=MySQL_Fetch_Array($dbukon); |
22 | | | echo ' |
23 | | | |
24 | | | <b>Editace úkonu pro uživatele '.id_to_name($dbukon["clen"]).':</b><br> |
25 | | | <form action="edit_ukon.php?action=zapis" method=POST> |
26 | | | <table> |
27 | | | <tr> |
28 | | | <td class=text>Datum:</td><td><input class=field name="datum" type="text" value="'.sql2datum($dbukon["datum"]).'" size=25></td> |
29 | | | <td class=text><a href=del_ukon.php?id='.$id.'>Smazat tento úkon!</a></td> |
30 | | | </tr> |
31 | | | <tr> |
32 | | | <td class=text>Typ udalosti:</td> |
33 | | | <td> |
34 | | | <select class=field name="udalost">'; |
35 | | | $dotaz=MySQL_Query("SELECT * from udalosti ORDER BY id"); |
36 | | | $count=MySQL_Num_Rows($dotaz); |
37 | | | $count++; |
38 | | | for ($i=1;$i<$count;$i++) |
39 | | | { |
40 | | | $radek=MySQL_Fetch_Array($dotaz); |
41 | | | echo '<option '; if($dbukon["udalost"]==$radek["id"]){ echo 'selected';} echo' value='.$radek["id"].'>'.$radek["nazev"].'</option>'; |
42 | | | } |
43 | | | echo '</select> |
44 | | | </td> |
45 | | | </tr> |
46 | | | <tr> |
47 | | | <td class=text>Předmětné IP:</td> |
48 | | | <td> |
49 | | | <select class=field name="predmet">'; |
50 | | | $dotaz=MySQL_Query("SELECT * FROM ipecka WHERE clen=".$dbukon["clen"]." ORDER BY ip"); |
51 | | | $count=MySQL_Num_Rows($dotaz); |
52 | | | $count++; |
53 | | | echo '<option value=0>není</option>'; |
54 | | | $ipecko=id_to_ipecko($dbukon["predmet"]); |
55 | | | for ($i=1;$i<$count;$i++) |
56 | | | { |
57 | | | $radek=MySQL_Fetch_Array($dotaz); |
58 | | | echo '<option '; if($ipecko==$radek["ip"]){ echo 'selected';} echo' value='.$radek["id"].'>'.$radek["ip"].'</option>'; |
59 | | | } |
60 | | | echo '</select> |
61 | | | </td> |
62 | | | </tr> |
63 | | | <tr> |
64 | | | <td class=text>Adresa:</td> |
65 | | | <td> |
66 | | | <select class=field name="adresa">'; |
67 | | | $dotaz=MySQL_Query("SELECT * from adresy ORDER BY ulice,cp,byt"); |
68 | | | $count=MySQL_Num_Rows($dotaz); |
69 | | | $count++; |
70 | | | echo '<option value=0>není</option>'; |
71 | | | for ($i=1;$i<$count;$i++) |
72 | | | { |
73 | | | $radek=MySQL_Fetch_Array($dotaz); |
74 | | | echo '<option '; if($dbukon["adresa"]==$radek["id"]){ echo 'selected';} echo' value='.$radek["id"].'>'.$radek["ulice"]." ".$radek["cp"]." byt ".$radek["byt"].'</option>'; |
75 | | | } |
76 | | | echo '</select> |
77 | | | </td> |
78 | | | </tr> |
79 | | | <tr> |
80 | | | <td class=text>Finance:</td> |
81 | | | <td> |
82 | | | <select class=field name="finance">'; |
83 | | | $dotaz=MySQL_Query("SELECT * from finance ORDER BY datum"); |
84 | | | $count=MySQL_Num_Rows($dotaz); |
85 | | | $count++; |
86 | | | echo '<option value=0>není</option>'; |
87 | | | for ($i=1;$i<$count;$i++) |
88 | | | { |
89 | | | $radek=MySQL_Fetch_Array($dotaz); |
90 | | | echo '<option '; if($dbukon["finance"]==$radek["id"]){ echo 'selected';} echo' value='.$radek["id"].'>'.$radek["datum"]." ".$radek["hodnota"]."K. ".$radek["pokladna"].'</option>'; |
91 | | | } |
92 | | | echo '</select> |
93 | | | </td> |
94 | | | </tr> |
95 | | | <tr> |
96 | | | <td class=text>Majetek:</td> |
97 | | | <td> |
98 | | | <select class=field name="majetek">'; |
99 | | | $dotaz=MySQL_Query("SELECT * from majetek ORDER BY id"); |
100 | | | $count=MySQL_Num_Rows($dotaz); |
101 | | | $count++; |
102 | | | echo '<option value=0>není</option>'; |
103 | | | for ($i=1;$i<$count;$i++) |
104 | | | { |
105 | | | $radek=MySQL_Fetch_Array($dotaz); |
106 | | | echo '<option '; if($dbukon["majetek"]==$radek["id"]){ echo 'selected';} echo' value='.$radek["id"].'>'.id_to_zarizeni($radek["zarizeni"])." ".$radek["komentar"]." ".$radek["scislo"]." ".$radek["mac"]." ".id_to_adresa($radek["adresa"]).'</option>'; |
107 | | | } |
108 | | | echo '</select> |
109 | | | </td> |
110 | | | </tr> |
111 | | | |
112 | | | <tr> |
113 | | | <td class=text valign=top>Komentář:</td><td><textarea class=fieldthin name="komentar" rows=8 cols=25>'.$dbukon["komentar"].'</textarea></td> |
114 | | | </tr> |
115 | | | </table> |
116 | | | |
117 | | | <input class=field type="submit" name="OK" value=" ulož změny "> |
118 | | | <input name="id" type="hidden" value="'.$id.'"> |
119 | | | <input name="clen" type="hidden" value="'.$dbukon["clen"].'"> |
120 | | | </form> |
121 | | | |
122 | | | '; |
123 | | | } |
124 | | | else |
125 | | | { |
126 | | | $datum=datum2sql($datum); |
127 | | | $result = MySQL_Query("UPDATE ukony SET clen='$clen',udalost='$udalost',predmet='$predmet',datum='$datum',komentar='$komentar',adresa='$adresa',finance='$finance',majetek='$majetek' WHERE id='$id'"); |
128 | | | |
129 | | | if (!$result) { |
130 | | | echo "<br><b>Výsledek : ".mysql_error()."</b>"; |
131 | | | } else { |
132 | | | echo "<br><b>Úkon uživatele ".id_to_name($clen)." byl úspěšně změněn!</b>"; |
133 | | | } |
134 | | | |
135 | | | } |
136 | | | |
137 | | | MySQL_Close($spojeni); |
138 | | | ?> |
139 | | | <br> |
140 | | | <br> |
141 | | | <img src=images/arrow.jpg> <a href="javascript:history.go(-2)" class=odkaz>zpět</a> |
142 | | | |
143 | | | </body> |
144 | | | </html> |