51 $ret = duplicate_record ($tab, $key, $val); |
51 $ret = duplicate_record ($tab, $key, $val); |
52 if ($ret) |
52 if ($ret) |
53 { |
53 { |
54 $pzid_new=$ret; |
54 $pzid_new=$ret; |
55 // duplizieren Schritte |
55 // duplizieren Schritte |
56 $sql = "INSERT INTO Proz_Step SELECT NULL, $pzid_new, proz_step FROM Proz_Step WHERE proz_ID=$pzid ORDER BY proz_step_ID"; |
56 $sql = "INSERT INTO Proz_Step SELECT NULL, $pzid_new, proz_step,step_stat_ID,step_bem FROM Proz_Step WHERE proz_ID=$pzid ORDER BY proz_step_ID"; |
57 $rets = $dbc -> execute($sql); |
57 $rets = $dbc -> execute($sql); |
58 if ($ret && $rets) |
58 if ($ret && $rets) |
59 { |
59 { |
60 $addr = $_SERVER["PHP_SELF"] . "?i=$pzid_new&c=1"; |
60 $addr = $_SERVER["PHP_SELF"] . "?i=$pzid_new&c=1"; |
61 header("Location: $addr"); |
61 header("Location: $addr"); |
367 { // INSERT o.k. |
367 { // INSERT o.k. |
368 // info_ID ermitteln |
368 // info_ID ermitteln |
369 $pzid = $dbc -> insertId(); |
369 $pzid = $dbc -> insertId(); |
370 } |
370 } |
371 } |
371 } |
372 if ($result && is_array($pz["step"])) |
372 if ($result && is_array($pz["step"]) && count($pz["step"])>0) |
373 { // INSERT Prozessschritte |
373 { // INSERT Prozessschritte |
374 $sql = "DELETE FROM Proz_Step WHERE proz_ID = $pzid"; |
374 $sql = "DELETE FROM Proz_Step WHERE proz_ID = $pzid"; |
375 $retd = $dbc -> execute($sql); |
375 $retd = $dbc -> execute($sql); |
376 if ($retd) |
376 if ($retd) |
377 { |
377 { |
|
378 $rets = 1; |
378 $stmt -> prepare("INSERT INTO Proz_Step (proz_ID,proz_step,step_stat_ID,step_bem) VALUES(?,?,?,?)"); |
379 $stmt -> prepare("INSERT INTO Proz_Step (proz_ID,proz_step,step_stat_ID,step_bem) VALUES(?,?,?,?)"); |
379 for ($k=0; $k<count($pz["step"]); $k++) |
380 for ($k=0; $k<count($pz["step"]); $k++) |
380 { |
381 { |
381 if ($pz["step"][$k]) |
382 if ($pz["step"][$k]) |
382 { |
383 { |
383 if ($pz["ststat"][$k] == -1) $pz["ststat"][$k] = null; |
384 if ($pz["ststat"][$k] == -1) $pz["ststat"][$k] = null; |
384 if ($pz["stbem"][$k] < "!") $pz["stbem"][$k] = null; |
385 if ($pz["stbem"][$k] < "!") $pz["stbem"][$k] = null; |
385 $stmt -> bind_param('isis',$pzid, $pz["step"][$k], $pz["ststat"][$k], $pz["stbem"][$k]); |
386 $stmt -> bind_param('isis',$pzid, $pz["step"][$k], $pz["ststat"][$k], $pz["stbem"][$k]); |
386 $rets = $stmt -> execute(); |
387 $rets = $rets && $stmt -> execute(); |
387 if (!$rets) $rets = false; |
|
388 } |
388 } |
389 } |
389 } |
390 if (!$rets) echo "error INSERT Projekt-Schritt: $stmt->error<br />\n"; |
390 if (!$rets) echo "error INSERT Projekt-Schritt: $stmt->error<br />\n"; |
391 } |
391 } |
392 else echo "error INSERT Projekt-Schritt: $dbc->error<br />\n"; |
392 else echo "error INSERT Projekt-Schritt: $dbc->error<br />\n"; |
393 } |
393 } |
|
394 else $rets = 1; |
394 } |
395 } |
395 |
396 |
396 if ($result && $rets) |
397 if ($result && $rets) |
397 { |
398 { |
398 echo "<p class='green'><b>Projekt '".$pz["bez"]."' mit ID '$pzid' wurden erfolgreich gespeichert.</b></p>\n"; |
399 echo "<p class='green'><b>Projekt '".$pz["bez"]."' mit ID '$pzid' wurden erfolgreich gespeichert.</b></p>\n"; |