0,0 → 1,956 |
<? |
require_once('version.inc'); |
require_once('dbaccess.inc'); |
require_once('language.inc'); |
require_once('header.inc'); |
require_once('settings.inc'); |
require_once('helper.inc'); |
require_once('crypt.inc'); |
|
$drm = array(false, false, true, true, true, true, true, true); |
|
require_once('menu.inc'); |
require_once('knumber.inc'); |
|
$func = $_REQUEST['func']; |
|
function EditTask($pt_num, $neu=false) { |
$menu = $_REQUEST['menu']; |
global $unum; |
global $rstufe; |
global $phase; |
global $numphase; |
|
$pt_lfd = $_REQUEST['pt_lfd']; |
$pt_level = $_REQUEST['pt_level']; |
$pt_name = $_REQUEST['pt_name']; |
$pt_color = $_REQUEST['pt_color']; |
$pt_meeting = $_REQUEST['pt_meeting']; |
$pt_phase = $_REQUEST['pt_phase']; |
$color = $_REQUEST['color']; |
|
if (!isset($color) || strlen($color) <= 0) |
$color = "ffffcc"; |
|
if ($neu) { |
$pt_tnum = $pt_num; |
$pt_num = 0; |
} |
else |
$pt_tnum = $_REQUEST['pt_tnum']; |
|
if (!isset($pt_lfd) || $pt_lfd <= 0) |
$pt_lfd = 1; |
|
$db = OpenDB(); |
|
if (!$neu) { |
$query = "select pt_tnum, pt_lfd, pt_level, pt_name, pt_color, "; |
$query .= "pt_meeting, pt_phase from ptemp where pt_num = $pt_num"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return; |
} |
|
$numrows = numrowsDB($result); |
|
if ($numrows != 1) { |
Error("Interner Fehler: Task \"$pt_num\" existiert nicht!<br>"); |
closeDB($db); |
return; |
} |
|
$data = fetchDB($result, 0); |
$pt_tnum = $data[0]; |
$pt_lfd = $data[1]; |
$pt_level = $data[2]; |
$pt_name = $data[3]; |
$pt_color = $data[4]; |
$pt_meeting = $data[5]; |
$pt_phase = $data[6]; |
$color = dechex($pt_color); |
$len = strlen($color); |
|
while ($len < 6) { |
$color = "0" . $color; |
$len++; |
} |
} |
else if (isset($pt_color)) { |
$color = dechex($pt_color); |
$len = strlen($color); |
|
while ($len < 6) { |
$color = "0" . $color; |
$len++; |
} |
} |
|
if (isset($pt_meeting) && ($pt_meeting == "t" || $pt_meeting == "f")) { |
if ($pt_meeting == "f") |
$pt_meeting = 0; |
else |
$pt_meeting = 1; |
} |
|
# Den Namen des Templates hinschreiben |
if (!$neu) { |
$query = "select te_name from tempidx where te_num = $pt_tnum"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($result, 0); |
$te_name = $data[0]; |
echo "<p class=\"cry\">Template: $te_name</p>"; |
} |
?> |
<br> |
<form name="Task" action="templates.php" method="post"> |
<input type="hidden" name="pt_num" value="<? echo "$pt_num"; ?>"> |
<input type="hidden" name="pt_tnum" value="<? echo "$pt_tnum"; ?>"> |
<input type="hidden" name="headline" value="28"> |
<input type="hidden" name="menu" value="<? echo "$menu"; ?>"> |
<input type="hidden" name="pt_lfd" value="<? echo "$pt_lfd"; ?>"> |
<input type="hidden" name="func" value="SaveTask"> |
|
<table class="input"> |
<tr> |
<td>Level:</td> |
<td><input type="text" class="inputmust" name="pt_level" value="<? echo "$pt_level"; ?>" size=1 maxlength=1></td> |
</tr> |
<tr> |
<td>Taskname:</td> |
<td><input type="text" class="inputmust" name="pt_name" value="<? echo "$pt_name"; ?>" size=40 maxlength=50></td> |
</tr> |
<tr> |
<td>Farbe:</td> |
<td><input type="text" name="color" value="<? echo "$color"; ?>" size=8 maxlength=6> |
<?php |
echo "<button type=\"button\" onClick=\"javascript:open_window('templates.php?header=1&func=GetColor&target=window.opener.document.Task.color', 'Farbwahl', 217, 57)\">"; |
echo "<img src=\"image/coloredit.png\" border=0 width=15 height=15 alt=\"Farbwahl\"></button>"; |
?> |
</td> |
</tr> |
<tr> |
<td>Meilenstein:</td> |
<?php |
if ($pt_meeting) { |
echo "<td><input type=\"checkbox\" name=\"pt_meeting\" value=\"1\" checked></td>\n"; |
} else { |
echo "<td><input type=\"checkbox\" name=\"pt_meeting\" value=\"1\"></td>\n"; |
} |
?> |
</tr> |
<?php |
if ($phase == 1) { |
echo "<tr><td>Phase:</td>\n<td>"; |
$query = "select kp_num, kp_phase from key_phase order by kp_num"; |
$result = QueryDB($db, $query); |
|
if (!$result) |
return; |
|
$numrows = numrowsDB($result); |
$row = 0; |
echo "<select name=\"pt_phase\">\n"; |
|
while ($row < $numrows) { |
$data = fetchDB($result, $row); |
$kp_num = $data[0]; |
$kp_phase = $data[1]; |
|
if ($pt_phase == $kp_num) |
echo "<option value=\"$kp_num\" selected>$kp_num. $kp_phase</option>\n"; |
else |
echo "<option value=\"$kp_num\">$kp_num. $kp_phase</option>\n"; |
|
$row++; |
} |
|
echo "</td></tr>\n"; |
} |
?> |
<tr> |
</table> |
<table class="indent"><tr><td> |
<? |
ButtonSubmit("Task Speichern", "Task"); |
?> |
</td></tr></table> |
</form> |
<?php |
closeDB($db); |
} |
|
function EditTemplate($te_num, $edit=true) { |
$headline = $_REQUEST['headline']; |
$menu = $_REQUEST['menu']; |
global $unum; |
global $rstufe; |
global $phase; |
global $numphase; |
|
$nav = "te_num=$te_num&menu=$menu&headline=$headline"; |
|
if (!isset($te_num) || $te_num < 1) { |
Error("Interner Fehler! Templatenummer fehlt oder ist ungültig!<br>"); |
return; |
} |
|
$db = OpenDB(); |
# Den Namen des Templates hinschreiben. |
$query = "select te_name from tempidx where te_num = $te_num"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($result, 0); |
$te_name = $data[0]; |
|
echo "<p class=\"cry\">Template: $te_name</p>\n"; |
|
# Das Template optisch aufbauen. |
$query = "select pt_num, pt_tnum, pt_lfd, pt_level, pt_name, pt_color, "; |
$query .= "pt_meeting, pt_phase from ptemp where pt_tnum = $te_num "; |
$query .= "order by pt_lfd"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return; |
} |
|
$numrows = numrowsDB($result); |
$row = 0; |
$pt_lfd = 0; |
|
if ($numrows > 0) { |
$db2 = OpenDB(); |
|
/* if ($edit) { |
echo "<table class=\"indent\"><tr><td>\n"; |
ButtonLink("Task Einfügen", "templates.php", "taskadd=$pt_tnum&pt_lfd=1&$nav"); |
// echo "<a href=\"#\" onClick=\"javascript:MoveTo('template.php','taskadd=$pt_tnum&pt_lfd=1&$nav')\"><img src=\"image/button_taskinsert.png\" border=0 alt=\"Einfuegen\"></a>\n"; |
echo "</td></tr></table>\n"; |
} |
*/ |
?> |
<table class="sel"> |
<tr> |
<?php |
if ($edit) |
echo "<th class=\"sel\">Aktion</th>\n"; |
?> |
<th class="sel">Nr.</center></th> |
<th class="sel">Taskname</th> |
<th class="sel">Typ</th> |
</tr> |
<?php |
$snum = "1"; |
$olevel = 0; |
|
while ($row < $numrows) { |
$data = fetchDB($result, $row); |
$pt_num = $data[0]; |
$pt_tnum = $data[1]; |
$pt_lfd = $data[2]; |
$pt_level = $data[3]; |
$pt_name = $data[4]; |
$pt_color = $data[5]; |
|
if ($data[6] == "t") |
$pt_meeting = 1; |
else |
$pt_meeting = 0; |
|
$pt_phase = $data[7]; |
|
$query = "select pt_level from ptemp where pt_tnum = $te_num and pt_lfd > $pt_lfd order by pt_lfd"; |
$result2 = QueryDB($db2, $query); |
$nr = numrowsDB($result2); |
|
if ($nr > 0) { |
$data = fetchDB($result2, 0); |
$xlevel = $data[0]; |
} else { |
$xlevel = $pt_level; |
} |
|
if ($olevel == 0) { |
$level = 0; |
$olevel = $pt_level; |
$dir = -3; |
} else if ($olevel < $pt_level) { |
$level = $pt_level - 1; |
$olevel = $pt_level; |
$dir = -3; |
} else if ($olevel == $pt_level) { |
$level = $pt_level - 1; |
$dir = 0; |
} else if ($olevel > $pt_level) { |
$level = $pt_level - 1; |
$olevel = $pt_level; |
$dir = -1; |
} |
|
echo "<tr>"; |
|
if ($edit) { |
echo "<td class=\"selakt\"><table border=0 cellspacing=0 cellpadding=0><tr>\n"; |
echo "<td><a href=\"#\" onClick=\"javascript:MoveTo('templates.php','taskadd=$pt_tnum&pt_lfd=$pt_lfd&$nav')\"><img src=\"image/new.png\" border=0 alt=\"Neu\"></a></td>\n"; |
echo "<td><a href=\"#\" onClick=\"javascript:MoveTo('templates.php','edittask=$pt_num&$nav')\"><img src=\"image/edit.png\" border=0 alt=\"Edit\"></a></td>\n"; |
echo "<td><a href=\"#\" onClick=\"javascript:MoveTo('templates.php','deletetask=$pt_num&pt_tnum=$pt_tnum&$nav')\"><img src=\"image/editdelete.png\" border=0 alt=\"Delete\"></a></td>\n"; |
echo "</tr></table>\n"; |
echo "</td>\n"; |
} |
|
$snum = kNumber ($snum, $level, $dir); |
|
if ($phase == 1 && $numphase == 1 && isset($pt_phase)) { |
if (strpos($snum, ".")) { |
$sarr = explode(".", $snum); |
$sarr[0] = (string)$pt_phase; |
$snum = implode(".", $sarr); |
} else { |
$snum = (string)$pt_phase; |
} |
} |
|
echo "<td class=\"sel\">$snum</td>\n<td class=\"sel\">$pt_name</td>\n"; |
|
if ($pt_meeting) { |
echo "<td class=\"sel\"><b>Meilenstein</b></td>\n"; |
} else if ($pt_level == 1 || $xlevel > $pt_level) { |
echo "<td class=\"sel\"><i>Ordner</i></td>\n"; |
} else { |
echo "<td class=\"sel\">Task</td>\n"; |
} |
|
echo "</tr>\n"; |
$row++; |
} |
|
$pt_lfd++; |
echo "</table>\n"; |
|
if ($edit) { |
echo "<table class=\"indent\"><tr><td>\n"; |
ButtonLink("Task Anhängen", "templates.php", "taskadd=$pt_tnum&pt_lfd=$pt_lfd&$nav"); |
echo "</td></tr></table>\n"; |
// echo "<a href=\"#\" onClick=\"javascript:MoveTo('templates.php','taskadd=$pt_tnum&pt_lfd=$pt_lfd&$nav')\"><img src=\"image/button_taskappend.png\" border=0 alt=\"Einfuegen\"></a>\n"; |
} |
|
echo "</form>\n"; |
closeDB($db); |
closeDB($db2); |
} else { |
closeDB($db); |
EditTask($te_num, true); |
} |
} |
|
function SaveTask() { |
global $phase; |
$pt_num = $_REQUEST['pt_num']; |
$pt_tnum = $_REQUEST['pt_tnum']; |
$pt_lfd = $_REQUEST['pt_lfd']; |
$pt_level = $_REQUEST['pt_level']; |
$pt_name = $_REQUEST['pt_name']; |
$pt_color = $_REQUEST['pt_color']; |
$color = $_REQUEST['color']; |
$pt_meeting = $_REQUEST['pt_meeting']; |
$pt_phase = $_REQUEST['pt_phase']; |
|
# Plausibilitaetspruefungen |
$err = 0; |
|
if (!isset($pt_tnum) || $pt_tnum < 1) { |
Error("Interner Fehler: Template-Indexnummer fehlt!<br>"); |
$err = 1; |
} |
|
if (!isset($pt_lfd) || $pt_lfd < 1) { |
Error("Interner Fehler: Keine oder ungültige ID-Nummer!<br>"); |
$err = 1; |
} |
|
if (strlen($pt_name) < 1) { |
Error("Ein Task muss einen Namen haben!<br>"); |
$err = 1; |
} |
|
if (!isset($pt_color) && strlen($color) != 6) { |
Error("Ungueltiger Farbcode!<br>"); |
$err = 1; |
} |
|
if ($err == 1) { |
return false; |
} |
|
# Umwandlungen |
if (!isset($pt_color)) |
$pt_color = hexdec($color); |
|
if (!isset($pt_meeting)) |
$pt_meeting = 0; |
|
$db = OpenDB(); |
|
# Aendern wir einen bestehenden Datensatz, oder speichern wir einen |
# neuen? |
if (isset($pt_num) && $pt_num > 0) { // neuer Datensatz? |
$query = "select pt_num from ptemp where pt_num = $pt_num"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return false; |
} |
|
$numrows = numrowsDB($result); |
|
# Gibt es den Datensatz bereits, dann aendern wir ihn. |
if ($numrows == 1) { |
$query = "update ptemp set pt_name = '$pt_name', pt_color = '$pt_color',"; |
$query .= "pt_meeting = '$pt_meeting', pt_level = $pt_level,"; |
|
if ($phase == 1) |
$query .= "pt_tnum = $pt_tnum, pt_lfd = $pt_lfd, pt_phase = $pt_phase "; |
else |
$query .= "pt_tnum = $pt_tnum, pt_lfd = $pt_lfd "; |
|
$query .= "where pt_num = $pt_num"; |
|
if (!TQueryDB($db, $query)) { |
closeDB($db); |
return false; |
} |
|
closeDB($db); |
return true; |
} |
} |
|
# Der Datensatz existiert nicht und deshalb fuegen wir ihn ein. Es |
# muss jedoch geprueft werden, ob die ID bereits existiert. Existiert |
# sie, muessen alle IDs >= $pt_lfd um 1 erhoeht werden und der |
# Datensatz anschliessend eingefuegt werden. |
$query = "select pt_lfd from ptemp where pt_tnum = $pt_tnum and pt_lfd = $pt_lfd"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return false; |
} |
|
$numrows = numrowsDB($result); |
|
if ($numrows == 1) { |
# Alle IDs um 1 nach hinten schieben! |
$query = "select pt_num, pt_lfd from ptemp where pt_tnum = $pt_tnum and pt_lfd >= $pt_lfd order by pt_lfd desc"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return false; |
} |
|
$numrows = numrowsDB($result); |
$row = 0; |
$db2 = OpenDB(); |
|
while ($row < $numrows) { |
$data = fetchDB($result, $row); |
$num = $data[0]; |
$id = $data[1] + 1; |
$query = "update ptemp set pt_lfd = $id where pt_num = $num"; |
|
if (!TQueryDB($db2, $query)) { |
closeDB($db); |
closeDB($db2); |
return false; |
} |
|
$row++; |
} |
|
closeDB($db2); |
} |
|
# Nun wird der neue Datensatz tatsaechlich geschrieben. |
$query = "select co_ptemp from counter"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return false; |
} |
|
$data = fetchDB($result, 0); |
$pt_num = $data[0] + 1; |
|
QueryDB($db, "begin"); |
$query = "insert into ptemp (pt_num, pt_tnum, pt_lfd, "; |
$query .= "pt_name, pt_color, pt_meeting,"; |
$query .= "pt_level, pt_phase) values ("; |
$query .= "$pt_num, $pt_tnum, $pt_lfd, "; |
$query .= "'$pt_name', $pt_color, "; |
$query .= "'$pt_meeting', "; |
|
if ($phase == 1) |
$query .= "$pt_level, $pt_phase)"; |
else |
$query .= "$pt_level, 0)"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return false; |
} |
|
$query = "update counter set co_ptemp = $pt_num"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return false; |
} |
|
QueryDB($db, "commit"); |
closeDB($db); |
return true; |
} |
|
function AskDeleteTask($pt_num) { |
$headline = $_REQUEST['headline']; |
$menu = $_REQUEST['menu']; |
$pt_tnum = $_REQUEST['pt_tnum']; |
$nav = "pt_num=$pt_num&pt_tnum=$pt_tnum&func=DeleteTask&menu=$menu&headline=28"; |
|
$db = OpenDB(); |
$query = "select te_name from tempidx where te_num = $pt_tnum"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($result, 0); |
$te_name = $data[0]; |
echo "<p class=\"cry\">Template: $te_name</p>"; |
closeDB($db); |
?> |
<br> |
<form action="templates.php" method="post"> |
<table border=2 class="alarm"> |
<tr><td colspan=2><big>Warnung!</big><br><br> |
Sie sind im Begriff einen Task zu löschen!<br><br> |
Wollen Sie wirklich diesen Task unwiederbringlich löschen?<br> |
</td> |
</tr> |
<tr> |
<td><center><input type="button" name="yes" value="Löschen" onClick="javascript:MoveTo('templates.php','yes=yes&<? echo "$nav"; ?>')"></center></td> |
<td><center><input type="button" name="no" value="Abbruch" onClick="javascript:MoveTo('templates.php','no=no&<? echo "$nav"; ?>')"></center></td> |
</tr> |
</table> |
</form> |
<?php |
} |
|
function DeleteTask() { |
$pt_num = $_REQUEST['pt_num']; |
|
if (!isset($pt_num) || $pt_num <= 0) { |
Error("Error: Interner Fehler: Ungültige oder fehlende Seriennummer!"); |
return false; |
} |
|
$db = OpenDB(); |
QueryDB($db, "begin"); |
$query = "delete from ptemp where pt_num = $pt_num"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return false; |
} |
|
QueryDB($db, "commit"); |
closeDB($db); |
return true; |
} |
|
function GetColor() { |
$target = $_REQUEST['target']; |
?> |
<map name="farbe"> |
<area shape="rect" coords="1,1,26,10" href="javascript:Farbe('255','128','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="28,1,53,10" href="javascript:Farbe('255','255','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="55,1,80,10" href="javascript:Farbe('128','255','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="82,1,107,10" href="javascript:Farbe('0','255','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="109,1,134,10" href="javascript:Farbe('128','255','255','<? echo "$target"; ?>')"> |
<area shape="rect" coords="136,1,161,10" href="javascript:Farbe('0','128','255','<? echo "$target"; ?>')"> |
<area shape="rect" coords="163,1,188,10" href="javascript:Farbe('255','128','192','<? echo "$target"; ?>')"> |
<area shape="rect" coords="190,1,215,10" href="javascript:Farbe('255','128','255','<? echo "$target"; ?>')"> |
<area shape="rect" coords="1,12,26,21" href="javascript:Farbe('255','0','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="28,12,53,21" href="javascript:Farbe('255','255','0''<? echo "$target"; ?>')"> |
<area shape="rect" coords="55,12,80,21" href="javascript:Farbe('128','255','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="82,12,107,21" href="javascript:Farbe('0','255','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="109,12,134,21" href="javascript:Farbe('0','255','255','<? echo "$target"; ?>')"> |
<area shape="rect" coords="136,12,161,21" href="javascript:Farbe('0','128','192','<? echo "$target"; ?>')"> |
<area shape="rect" coords="163,12,188,21" href="javascript:Farbe('128','128','192','<? echo "$target"; ?>')"> |
<area shape="rect" coords="190,12,215,21" href="javascript:Farbe('255','0','255','<? echo "$target"; ?>')"> |
<area shape="rect" coords="1,23,26,32" href="javascript:Farbe('128','64','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="28,23,53,32" href="javascript:Farbe('255','128','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="55,23,80,32" href="javascript:Farbe('0','255','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="82,23,107,32" href="javascript:Farbe('0','128','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="109,23,134,32" href="javascript:Farbe('0','64','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="136,23,161,32" href="javascript:Farbe('128','128','255','<? echo "$target"; ?>')"> |
<area shape="rect" coords="163,23,188,32" href="javascript:Farbe('128','0','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="190,23,215,32" href="javascript:Farbe('255','0','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="1,34,26,43" href="javascript:Farbe('128','0','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="28,34,53,43" href="javascript:Farbe('255','128','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="55,34,80,43" href="javascript:Farbe('0','128','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="82,34,107,43" href="javascript:Farbe('0','128','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="109,34,134,43" href="javascript:Farbe('0','0','255','<? echo "$target"; ?>')"> |
<area shape="rect" coords="136,34,161,43" href="javascript:Farbe('0','0','160','<? echo "$target"; ?>')"> |
<area shape="rect" coords="163,34,188,43" href="javascript:Farbe('128','0','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="190,34,215,43" href="javascript:Farbe('128','0','255','<? echo "$target"; ?>')"> |
<area shape="rect" coords="1,45,26,54" href="javascript:Farbe('64','0','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="28,45,53,54" href="javascript:Farbe('128','64','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="55,45,80,54" href="javascript:Farbe('0','64','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="82,45,107,54" href="javascript:Farbe('0','64','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="109,45,134,54" href="javascript:Farbe('0','0','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="136,45,161,54" href="javascript:Farbe('0','0','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="163,45,188,54" href="javascript:Farbe('64','0','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="190,45,215,54" href="javascript:Farbe('64','0','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="1,56,26,65" href="javascript:Farbe('0','0','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="28,56,53,65" href="javascript:Farbe('128','128','0','<? echo "$target"; ?>')"> |
<area shape="rect" coords="55,56,80,65" href="javascript:Farbe('128','128','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="82,56,107,65" href="javascript:Farbe('128','128','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="109,56,134,65" href="javascript:Farbe('64','128','128','<? echo "$target"; ?>')"> |
<area shape="rect" coords="136,56,161,65" href="javascript:Farbe('192','192','192','<? echo "$target"; ?>')"> |
<area shape="rect" coords="163,56,188,65" href="javascript:Farbe('64','64','64','<? echo "$target"; ?>')"> |
<area shape="rect" coords="190,56,215,65" href="javascript:Farbe('255','255','255','<? echo "$target"; ?>')"> |
</map> |
<img src="image/farben.png" width="217" height="67" border="0" vspace="3" alt="" usemap="#farbe"> |
<form name="schliessen"> |
<input type="button" name="close" value="Schliessen" onClick="javascript:self.close()"> |
</form> |
<?php |
} |
|
function TempNew($te_num=0) { |
$menu = $_REQUEST['menu']; |
$te_name = $_REQUEST['te_name']; |
$te_zweck = $_REQUEST['te_zweck']; |
|
if ($te_num > 0) { |
$db = OpenDB(); |
$query = "select te_name, te_zweck from tempidx where te_num = $te_num"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($result, 0); |
$te_name = $data[0]; |
$te_zweck = $data[1]; |
closeDB($db); |
} |
?> |
<form name="Temp" action="templates.php" method="post"> |
<input type="hidden" name="headline" value="28"> |
<input type="hidden" name="menu" value="<? echo "$menu"; ?>"> |
<?php |
if ($te_num > 0) { |
echo "<input type=\"hidden\" name=\"te_num\" value=\"$te_num\">\n"; |
echo "<input type=\"hidden\" name=\"func\" value=\"tempupdate\">\n"; |
} else |
echo "<input type=\"hidden\" name=\"func\" value=\"tempsave\">\n"; |
?> |
<input type="hidden" name="pt_lfd" value="1"> |
|
<table class="input"> |
<tr> |
<td>Template Name:</td> |
<td><input type="text" class="inputmust" name="te_name" value="<? echo "$te_name"; ?>" size=40 maxlength=60></td> |
</tr> |
<tr> |
<td>Beschreibung:</td> |
<td><textarea name="te_zweck" rows=5 cols=60><? echo "$te_zweck"; ?></textarea></td> |
</tr> |
</table> |
<table class="indent"><tr><td> |
<? |
ButtonSubmit("Speichern", "Temp"); |
?> |
</td></tr></table> |
</form> |
<?php |
} |
|
function TempSave() { |
global $menu; |
$te_name = $_REQUEST['te_name']; |
$te_zweck = $_REQUEST['te_zweck']; |
|
if (!isset($te_name) || strlen($te_name) <= 0) { |
Error("Sie müssen unbedingt einen Templatenamen angeben!<br>"); |
return -1; |
} |
|
if (!isset($te_zweck)) |
$te_zweck = ""; |
|
$db = OpenDB(); |
$query = "select co_tempidx from counter"; |
$result = QueryDB($db, $query); |
|
if (!$result) { |
closeDB($db); |
return -1; |
} |
|
$data = fetchDB($result, 0); |
$co_tempidx = $data[0] + 1; |
|
QueryDB($db, "begin"); |
$query = "insert into tempidx (te_num, te_name, te_zweck) values "; |
$query .= "($co_tempidx, '$te_name', '$te_zweck')"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return -1; |
} |
|
$query = "update counter set co_tempidx = $co_tempidx"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return -1; |
} |
|
QueryDB($db, "commit"); |
return $co_tempidx; |
} |
|
function TempUpdate() { |
global $menu; |
$te_num = $_REQUEST['te_num']; |
$te_name = $_REQUEST['te_name']; |
$te_zweck = $_REQUEST['te_zweck']; |
|
if (!isset($te_num) || $te_num <= 0) { |
Error("Error: Interner Fehler: Seriennummer fehlt!"); |
return false; |
} |
|
if (!isset($te_name) || strlen($te_name) <= 0) { |
Error("Sie müssen unbedingt einen Templatenamen angeben!<br>"); |
return false; |
} |
|
if (!isset($te_zweck)) |
$te_zweck = ""; |
|
$db = OpenDB(); |
$query = "update tempidx set te_name = '$te_name', te_zweck='$te_zweck' "; |
$query .= "where te_num = $te_num"; |
|
if (!TQueryDB($db, $query)) { |
closeDB($db); |
return false; |
} |
|
return true; |
} |
|
function TempDelAsk($te_num) { |
$headline = $_REQUEST['headline']; |
$menu = $_REQUEST['menu']; |
$nav = "te_num=$te_num&menu=$menu&func=TempDelReal&headline=28"; |
|
if (!isset($te_num) || $te_num <= 0) { |
Error("Interner Fehler: Es wurde keine Templatenummer übergeben!"); |
return false; |
} |
?> |
<br> |
<form action="templates.php" method="post"> |
<table border=2 class="alarm"> |
<tr><td colspan=2><big>Warnung!</big><br><br> |
Sie sind im Begriff alle erfassten Tasks dieses Templates zu |
löschen!<br><br> |
Wollen Sie wirklich dieses Template mit allen Daten |
unwiederbringlich löschen?<br> |
</td> |
</tr> |
<tr> |
<td><center><input type="button" name="yes" value="Löschen" onClick="javascript:MoveTo('templates.php','yes=yes&<? echo "$nav"; ?>')"></center></td> |
<td><center><input type="button" name="no" value="Abbruch" onClick="javascript:MoveTo('templates.php','no=no&<? echo "$nav"; ?>')"></center></td> |
</tr> |
</table> |
</form> |
<?php |
} |
|
function TempDel() { |
$te_num = $_REQUEST['te_num']; |
|
if (!isset($te_num) || $te_num <= 0) { |
Error("Interner Fehler: Es wurde keine Templatenummer übergeben!"); |
return false; |
} |
|
$db = OpenDB(); |
QueryDB($db, "begin"); |
$query = "delete from ptemp where pt_tnum = $te_num"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return false; |
} |
|
$query = "delete from tempidx where te_num = $te_num"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return false; |
} |
|
QueryDB($db, "commit"); |
closeDB($db); |
return true; |
} |
|
$tempdel = $_REQUEST['tempdel']; |
$tempedit = $_REQUEST['tempedit']; |
$taskadd = $_REQUEST['taskadd']; |
$edittask = $_REQUEST['edittask']; |
$deletetask = $_REQUEST['deletetask']; |
$edittemp = $_REQUEST['edittemp']; |
|
if (isset($tempdel) && $tempdel > 0) |
$func = "tempdel"; |
|
if (isset($tempedit) && $tempedit > 0) |
$func = "tempedit"; |
|
if (isset($taskadd) && $taskadd > 0) |
$func = "taskadd"; |
|
if (isset($edittask) && $edittask > 0) |
$func = "edittask"; |
|
if (isset($deletetask) && $deletetask > 0) |
$func = "deletetask"; |
|
if (isset($edittemp) && $edittemp > 0) |
$func = "edittemp"; |
|
if ($func == "tempnew") { |
TempNew(); |
} |
|
if ($func == "edittemp") |
TempNew($edittemp); |
|
if ($func == "tempsave") { |
$num = TempSave(); |
|
if ($num < 0) |
TempNew(); |
else |
EditTemplate($num); |
} |
|
if ($func == "tempupdate") { |
$te_num = $_REQUEST['te_num']; |
|
if (!TempUpdate()) |
TempNew($te_num); |
} |
|
if ($func == "tempdel") { |
TempDelAsk($tempdel); |
} |
|
if ($func == "TempDelReal") { |
if (isset($_REQUEST['yes'])) |
$x = TempDel(); |
else |
$x = false; |
?> |
<form action="forms.php" method="post"> |
<input type="hidden" name="templates" value="templates"> |
<input type="hidden" name="menu" value="4"> |
<br> |
<? |
if ($x) { |
?> |
<p class="cry">Template wurde erfolgreich gelöscht!</p> |
<? |
} |
?> |
<input type="submit" name="submit" value="Weiter -->"> |
</form> |
<?php |
} |
|
if ($func == "tempedit") { |
EditTemplate($tempedit); |
} |
|
if ($func == "GetColor") { |
GetColor(); |
} |
|
if ($func == "SaveTask") { |
if (SaveTask()) { |
$pt_tnum = $_REQUEST['pt_tnum']; |
EditTemplate($pt_tnum); |
} else { |
$pt_tnum = $_REQUEST['pt_num']; |
EditTask($pt_tnum, true); |
} |
} |
|
if ($func == "taskadd") |
EditTask($taskadd, true); |
|
if ($func == "edittask") |
EditTask($edittask, false); |
|
if ($func == "deletetask") |
AskDeleteTask($deletetask); |
|
if ($func == "DeleteTask") { |
if (isset($_REQUEST['yes'])) { |
DeleteTask(); |
} |
|
$pt_tnum = $_REQUEST['pt_tnum']; |
EditTemplate($pt_tnum); |
} |
|
require('footer.inc'); |
?> |