Subversion Repositories public

<?
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&uuml;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&uuml;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&auml;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&uuml;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&ouml;schen!<br><br>
           Wollen Sie wirklich diesen Task unwiederbringlich l&ouml;schen?<br>
      </td>
   </tr>
   <tr>
      <td><center><input type="button" name="yes" value="L&ouml;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&uuml;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&uuml;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&uuml;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 &uuml;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&ouml;schen!<br><br>
           Wollen Sie wirklich dieses Template mit allen Daten
           unwiederbringlich l&ouml;schen?<br>
      </td>
   </tr>
   <tr>
      <td><center><input type="button" name="yes" value="L&ouml;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 &uuml;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&ouml;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');
?>