|
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
|
2 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
|
3 |
|
4 <head> |
|
5 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
|
6 <link href="css/db.css" rel="STYLESHEET" type="TEXT/CSS" /> |
|
7 |
|
8 <title>Aktualisieren Produkte</title> |
|
9 </head> |
|
10 |
|
11 <body> |
|
12 <div class="float-r"><img src="img/node-tree.png" border="0" alt="Produktdaten bearbeiten" title="Produktdaten bearbeiten"/></div> |
|
13 <?php |
|
14 |
|
15 /** |
|
16 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
17 * @copyright 07/2011 |
|
18 * |
|
19 * UPDATE Produkt |
|
20 */ |
|
21 |
|
22 error_reporting(E_ALL ^ E_NOTICE); |
|
23 |
|
24 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
|
25 $dbc = new dbconnection(); |
|
26 |
|
27 $pid = $_GET["uid"]; |
|
28 if (!$pid) $pid=1; |
|
29 $ok = $_POST["ok"]; |
|
30 $submit = $_POST["upd"]; |
|
31 $prod = $_POST["prod"]; |
|
32 if (!$prod['okn']) $ok=false; |
|
33 |
|
34 // echo "pid=$pid, submit=$submit<br />\n"; |
|
35 if (!$ok || !$submit) |
|
36 { |
|
37 if (!$submit) |
|
38 { |
|
39 $sql = "SELECT produkt_ID, prod_name, prod_group_ID, produkt_hier, ag_ID, imp_ID, conn_ID, Bemerkung FROM Produkt |
|
40 WHERE produkt_ID = $pid"; |
|
41 if ($result = $dbc ->queryObjectArray($sql)) |
|
42 { |
|
43 foreach ($result as $row) |
|
44 { |
|
45 $prod['pnr'] = $row->produkt_ID; |
|
46 $prod['pname'] = $row->prod_name; |
|
47 $prod['grp'] = $row->prod_group_ID; |
|
48 $prod['ag'] = $row->ag_ID; |
|
49 $prod['imp'] = $row->imp_ID; |
|
50 $prod['conn'] = $row->conn_ID; |
|
51 $prod['pbem'] = $row->Bemerkung; |
|
52 |
|
53 } |
|
54 |
|
55 } |
|
56 |
|
57 } |
|
58 include ("form/produkt_form.inc.php"); |
|
59 |
|
60 if ($submit) |
|
61 { |
|
62 $frage = "Alle Angaben ok?"; |
|
63 echo "<tr> |
|
64 <td class=\"red\" valign=\"top\" align=\"left\">$frage</td> |
|
65 <td align=\"left\"><input type=\"checkbox\" name=\"ok\" value=\"1\""; |
|
66 if ($ok) echo "checked"; |
|
67 echo "></td>\n</tr>\n"; |
|
68 } |
|
69 |
|
70 echo "<tr>\n"; |
|
71 echo " |
|
72 <td> </td> |
|
73 <td align=\"left\"><input class=\"button\" type=\"submit\" value=\"ändern\" name=\"upd\" title=\"update\" /></td>\n"; |
|
74 echo "</tr>\n"; |
|
75 echo "</table>\n"; |
|
76 echo "</div>\n"; |
|
77 echo "</form>\n"; |
|
78 |
|
79 } |
|
80 else |
|
81 { // Daten o.k. -> speichern |
|
82 |
|
83 echo "<div align='center'>\n"; |
|
84 $prod['pname'] = substr($prod['pname'],0,200); |
|
85 if ($prod['pbem']) $prod['pbem']=substr($prod['pbem'],0,500); else $prod['pbem']=null; |
|
86 if ($prod['ag']== -1) $prod['ag'] = null; |
|
87 if ($prod['imp']== -1) $prod['imp'] = null; |
|
88 if ($prod['conn']== -1) $prod['conn'] = null; |
|
89 |
|
90 // Hierarchie ermitteln |
|
91 $sql = "SELECT prod_ber_ID FROM Produkt_Gruppe WHERE prod_group_ID = " . $prod['grp']; |
|
92 $bid = $dbc -> querySingleItem($sql); |
|
93 $phier = $bid . "-" . $prod['grp'] . "-" . $prod['pnr']; |
|
94 /* |
|
95 if ($prod['pbem']) $prod['pbem']="'" . str_replace("'","\"",substr($prod['pbem'],0,500)) . "'"; else $prod['pbem']="NULL"; |
|
96 if ($prod['ag']== -1) $ag = "NULL"; else $ag = "'" . $prod['ag'] . "'"; |
|
97 if ($prod['imp']== -1) $prod['imp'] = "NULL"; |
|
98 if ($prod['conn']== -1) $prod['conn'] = "NULL"; |
|
99 $sql = "UPDATE Produkt SET |
|
100 prod_name = '" . $prod['pname'] . "', |
|
101 prod_group_ID = " . $prod['grp'] . ", |
|
102 ag_ID = $ag, |
|
103 imp_ID = " . $prod['imp'] . ", |
|
104 conn_ID = " . $prod['conn'] . ", |
|
105 Bemerkung = " . $prod['pbem'] . " |
|
106 WHERE produkt_ID = $pid"; |
|
107 $ret = $dbc -> execute($sql); |
|
108 */ |
|
109 $stmt = $dbc -> stmtinit(); |
|
110 if (is_object($stmt)) |
|
111 { |
|
112 $stmt -> prepare("UPDATE Produkt SET |
|
113 prod_name = ?, |
|
114 prod_group_ID = ?, |
|
115 ag_ID = ?, |
|
116 imp_ID = ?, |
|
117 conn_ID = ?, |
|
118 Bemerkung = ? |
|
119 WHERE produkt_ID = $pid"); |
|
120 $stmt -> bind_param('sisiis', $prod['pname'],$prod['grp'],$prod['ag'],$prod['imp'],$prod['conn'],$prod['pbem']); |
|
121 $ret = $stmt -> execute(); |
|
122 } |
|
123 if (!$ret) echo "error update :" . $dbc -> error ."<br /> |
|
124 sql = $sql<br />\n"; |
|
125 else |
|
126 { |
|
127 echo "<p class='green'><b>Produktdaten zu ID '" . $prod['pnr'] . "' wurden erfolgreich gespeichert.</b></p>\n"; |
|
128 echo "<br /><br />\n"; |
|
129 |
|
130 // Anzeigen gespeicherter Produktdaten |
|
131 include ("inc/produkt_dat_show.inc.php"); |
|
132 } |
|
133 $dbc -> close(); |
|
134 echo "</div>\n"; |
|
135 echo "<p> <a href=\"prod_hier.php\" target=\"_self\" title=\"Produkthierarchie\">Zur Produkthierarchie</a></p>\n"; |
|
136 echo "<p> <a href=\"produkt_ins.php\" target=\"_self\" title=\"Produkt erfassen\">Weiteres Produkt erfassen</a></p>\n"; |
|
137 |
|
138 } |
|
139 |
|
140 |
|
141 ?> |
|
142 </body> |
|
143 </html> |