|
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>Eingabe Produkte</title> |
|
9 </head> |
|
10 |
|
11 <body> |
|
12 <div class="float-r"><img src="img/node-tree.png" border="0" alt="Produktdaten eingeben" title="Produktdaten eingeben"/></div> |
|
13 |
|
14 <?php |
|
15 |
|
16 /** |
|
17 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
18 * @copyright 07/2011 |
|
19 * |
|
20 * INSERT Produkt |
|
21 */ |
|
22 |
|
23 error_reporting(E_ALL ^ E_NOTICE); |
|
24 |
|
25 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
|
26 //$dbc = new dbconnection(); |
|
27 |
|
28 $ok = $_POST["ok"]; |
|
29 $submit = $_POST["ins"]; |
|
30 $prod = $_POST["prod"]; |
|
31 if (!$prod['okn']) $ok=false; |
|
32 |
|
33 // print_r($prd); |
|
34 // echo "<br><br>\n"; |
|
35 |
|
36 if (!$ok || !$submit) |
|
37 { |
|
38 include_once("form/produkt_form.inc.php"); |
|
39 |
|
40 if ($submit == "eingeben" ) |
|
41 { |
|
42 $frage = "Alle Angaben ok?"; |
|
43 echo "<tr> |
|
44 <td class=\"red\" valign=\"top\" align=\"left\">$frage</td> |
|
45 <td align=\"left\"><input type=\"checkbox\" name=\"ok\" value=\"1\""; |
|
46 if ($ok) echo "checked"; |
|
47 echo "></td>\n</tr>\n"; |
|
48 } |
|
49 |
|
50 echo "<tr>\n"; |
|
51 echo " |
|
52 <td> </td> |
|
53 <td align=\"left\"><input class=\"button\" type=\"submit\" value=\"eingeben\" name=\"ins\" title=\"insert\" /></td>\n"; |
|
54 echo "</tr>\n"; |
|
55 echo "</table>\n"; |
|
56 echo "</div>\n"; |
|
57 echo "</form>\n"; |
|
58 |
|
59 } |
|
60 else |
|
61 { |
|
62 if (!isset($dbc) || !$dbc) |
|
63 $dbc = new dbconnection(); |
|
64 |
|
65 // Daten speichern |
|
66 echo "<div align='center'>\n"; |
|
67 $prod['pname'] = substr($prod['pname'],0,200); |
|
68 if ($prod['pbem']) $prod['pbem']=substr($prod['pbem'],0,500); else $prod['pbem']=null; |
|
69 if ($prod['ag']== -1) $prod['ag']= null; |
|
70 if ($prod['imp']== -1) $prod['imp'] = null; |
|
71 if ($prod['conn']== -1) $prod['conn'] = null; |
|
72 |
|
73 // Produkt-Nr. |
|
74 $sql = "SELECT COUNT(*) FROM Produkt WHERE produkt_ID = " . $prod['pnr']; |
|
75 $anz = $dbc -> querySingleItem($sql); |
|
76 if ($anz == 1) |
|
77 { |
|
78 // max produkt_ID ermitten, um neue ID zu erhalten |
|
79 $sql = "SELECT MAX(produkt_ID) FROM Produkt"; |
|
80 $mp = $dbc -> querySingleItem($sql); |
|
81 $prod['pnr'] = $mp + 1; |
|
82 } |
|
83 |
|
84 // Hierarchie ermitteln |
|
85 $sql = "SELECT prod_ber_ID FROM Produkt_Gruppe WHERE prod_group_ID = " . $prod['grp']; |
|
86 $bid = $dbc -> querySingleItem($sql); |
|
87 $phier = $bid . "-" . $prod['grp'] . "-" . $prod['pnr']; |
|
88 /* |
|
89 if ($prod['pbem']) $prod['pbem']="'" . str_replace("'","\"",substr($prod['pbem'],0,500)) . "'"; else $prod['pbem']="NULL"; |
|
90 if ($prod['ag']== -1) $ag = "NULL"; else $ag = "'" . $prod['ag'] . "'"; |
|
91 if ($prod['imp']== -1) $prod['imp'] = "NULL"; |
|
92 if ($prod['conn']== -1) $prod['conn'] = "NULL"; |
|
93 $sql = "INSERT INTO Produkt (produkt_ID,prod_name,prod_group_ID,produkt_hier,ag_ID,imp_ID,conn_ID,Bemerkung) |
|
94 VALUES (" . |
|
95 $prod['pnr'] . ", '" . |
|
96 $prod['pname'] . "', " . |
|
97 $prod['grp'] . ", '" . |
|
98 $phier . "', " . |
|
99 $ag . ", " . |
|
100 $prod['imp'] . ", " . |
|
101 $prod['conn'] . ", " . |
|
102 $prod['pbem'] . |
|
103 ") "; |
|
104 $result=$dbc->execute($sql); |
|
105 */ |
|
106 $stmt = $dbc -> stmtinit(); |
|
107 if (is_object($stmt)) |
|
108 { |
|
109 $stmt -> prepare("INSERT INTO Produkt (produkt_ID,prod_name,prod_group_ID,produkt_hier,ag_ID,imp_ID,conn_ID,Bemerkung) |
|
110 VALUES (?,?,?,?,?,?,?)"); |
|
111 $stmt -> bind_param('sissiis', $prod['pname'],$prod['grp'],$prod['ag'],$phier,$prod['imp'],$prod['conn'],$prod['pbem']); |
|
112 $result -> $stmt -> execute(); |
|
113 } |
|
114 if ($dbc->error) echo "error: " . $dbc->error . "<br \>sql=$sql<br \><br \>\n"; |
|
115 if ($result) |
|
116 { |
|
117 echo "<p class='green'><b>Produktdaten zu ID '" . $prod['pnr'] . "' wurden erfolgreich gespeichert.</b></p>\n"; |
|
118 echo "<br /><br />\n"; |
|
119 |
|
120 // Anzeigen gespeicherter Produktdaten |
|
121 include ("inc/produkt_dat_show.inc.php"); |
|
122 } |
|
123 $dbc -> close(); |
|
124 echo "</div>\n"; |
|
125 echo "<p> <a href=\"prod_hier.php\" target=\"_self\" title=\"Produkthierarchie\">Zur Produkthierarchie</a></p>\n"; |
|
126 echo "<p> <a href=\"produkt_ins.php\" target=\"_self\" title=\"Produkt erfassen\">Weiteres Produkt erfassen</a></p>\n"; |
|
127 |
|
128 } |
|
129 |
|
130 ?> |
|
131 |
|
132 </body> |
|
133 </html> |