0,0 → 1,618 |
<? |
require_once('version.inc'); |
require_once('dbaccess.inc'); |
require_once('language.inc'); |
require_once('header.inc'); |
require_once('crypt.inc'); |
require_once('settings.inc'); |
require_once('helper.inc'); |
|
$headline = 26; |
$drm = array(true, false, false, false, false, true, false); |
|
require_once('menu.inc'); |
|
function ShowWDONE() { |
global $datetime; |
global $leneinheit; |
|
$db = OpenDB(); |
$query = "select wd_num, wd_prnum, mi_nname, mi_vname, wd_datum, "; |
$query .= "wd_hours, ta_name, wd_task from wdone, mitarbeiter, task where "; |
$query .= "mi_num = wd_minum and ta_num = wd_task "; |
$query .= "order by wd_prnum, mi_nname, mi_vname, wd_task, wd_datum desc"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
|
if ($anz <= 0) { |
closeDB($db); |
Error("Es gibt keine Datensätze zum Anzeigen!"); |
return; |
} |
?> |
<table class="sel"> |
<tr> |
<th class="sel">Lfd.</th> |
<th class="sel">PrNr.</th> |
<th class="sel">Mitarbeiter</th> |
<th class="sel">Datum / Zeit</th> |
<th class="sel">Stunden</th> |
<th class="sel">TaNum.</th> |
<th class="sel">Taskname</th> |
</tr> |
<? |
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$wd_num = $data[0]; |
$wd_prnum = $data[1]; |
$mi_nname = $data[2]; |
$mi_vname = $data[3]; |
$wd_datum = $data[4]; |
$wd_hours = $data[5]; |
$ta_name = $data[6]; |
$ta_num = $data[7]; |
echo "<tr>\n<td class=\"selnum\">$wd_num</td>\n"; |
echo "<td class=\"selnum\">$wd_prnum</td>\n"; |
echo "<td class=\"sel\">$mi_nname $mi_vname</td>\n"; |
echo "<td class=\"selnum\">" . gmdate($datetime, $wd_datum) . "</td>\n"; |
echo "<td class=\"selnum\">" . FormatNum($wd_hours, 3) . " (PT: " . FormatNum($wd_hours / $leneinheit, 3) . ")</td>\n"; |
echo "<td class=\"selnum\">$ta_num</td>\n"; |
echo "<td class=\"sel\">$ta_name</td>\n</tr>\n"; |
$i++; |
} |
|
echo "</table>\n"; |
closeDB($db); |
} |
|
function ShowTASK() { |
global $datetime; |
|
$db = OpenDB(); |
$query = "select ta_num, pl_num, pl_prnum, ta_id, ta_name, ta_meeting, "; |
$query .= "ta_start, ta_duration, ta_level, ta_hash from task, plan "; |
$query .= "where pl_num = ta_plnum "; |
$query .= "order by pl_prnum, ta_id"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
|
if ($anz <= 0) { |
closeDB($db); |
Error("Esgibt keine Datensätze zum Anzeigen!"); |
return; |
} |
?> |
<table class="sel"> |
<tr> |
<th class="sel">TaNr.</th> |
<th class="sel">PlNr.</th> |
<th class="sel">PrNr.</th> |
<th class="sel">Lfd.</th> |
<th class="sel">Level</th> |
<th class="sel">Taskname</th> |
<th class="sel">Art</th> |
<th class="sel">Startdatum</th> |
<th class="sel">Dauer in T.</th> |
<th class="sel">Hash</th> |
</tr> |
<? |
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$ta_num = $data[0]; |
$pl_num = $data[1]; |
$pl_prnum = $data[2]; |
$ta_id = $data[3]; |
$ta_name = $data[4]; |
$ta_meeting = $data[5]; |
$ta_start = $data[6]; |
$ta_duration = $data[7]; |
$ta_level = $data[8]; |
$ta_hash = $data[9]; |
|
echo "<tr>\n<td class=\"selnum\">$ta_num</td>\n"; |
echo "<td class=\"selnum\">$pl_num</td>\n"; |
echo "<td class=\"selnum\">$pl_prnum</td>\n"; |
echo "<td class=\"selnum\">$ta_id</td>\n"; |
echo "<td class=\"selnum\">$ta_level</td>\n"; |
echo "<td class=\"sel\">$ta_name</td>\n"; |
echo "<td class=\"sel\">"; |
|
if ($ta_meeting == 0) |
echo "Task"; |
else |
echo "Meilenstein"; |
|
echo "</td>\n"; |
echo "<td class=\"sel\">" . gmdate($datetime, $ta_start) . "</td>\n"; |
echo "<td class=\"selnum\">$ta_duration (" . gmdate($datetime, $ta_start+$ta_duration*86400) . ")</td>\n"; |
echo "<td class=\"sel\">$ta_hash</td>\n</tr>\n"; |
$i++; |
} |
|
echo "</table>\n"; |
closeDB($db); |
} |
|
function ShowALLOCATION() { |
global $datetime; |
|
$db = OpenDB(); |
$query = "select al_num, ta_name, mi_nname, mi_vname, "; |
$query .= "al_hours, al_pstart, al_task from allocation, task, mitarbeiter "; |
$query .= "where ta_num = al_task and mi_num = al_ressource "; |
$query .= "order by ta_name, mi_nname, mi_vname, al_pstart desc"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
|
if ($anz <= 0) { |
closeDB($db); |
Error("Esgibt keine Datensätze zum Anzeigen!"); |
return; |
} |
?> |
<table class="sel"> |
<tr> |
<th class="sel">AlNr.</th> |
<th class="sel">TaskNr.</th> |
<th class="sel">Taskname</th> |
<th class="sel">Mitarbeiter</th> |
<th class="sel">Tage</th> |
<th class="sel">Datum</th> |
</tr> |
<? |
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$al_num = $data[0]; |
$ta_name = $data[1]; |
$mi_nname = $data[2]; |
$mi_vname = $data[3]; |
$al_hours = $data[4]; |
$al_pstart = $data[5]; |
$al_task = $data[6]; |
|
echo "<tr>\n<td class=\"selnum\">$al_num</td>\n"; |
echo "<td class=\"selnum\">$al_task</td>\n"; |
echo "<td class=\"sel\">$ta_name</td>\n"; |
echo "<td class=\"sel\">$mi_nname $mi_vname</td>\n"; |
echo "<td class=\"selnum\">" . FormatNum($al_hours, 3) . "</td>\n"; |
echo "<td class=\"sel\">" . gmdate($datetime, $al_pstart) . "</td>\n"; |
$i++; |
} |
|
echo "</table>\n"; |
closeDB($db); |
} |
|
function ShowCALENDAR() { |
global $datetime; |
|
$db = OpenDB(); |
$query = "select ca_num, ca_prnum, ca_minum, ca_task, "; |
$query .= "ca_writer, ca_date, ca_end, ca_title, ca_status from "; |
$query .= "calendar "; |
$query .= "order by ca_prnum, ca_date desc"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
|
if ($anz <= 0) { |
closeDB($db); |
Error("Es gibt keine Datensätze zum Anzeigen!"); |
return; |
} |
Error("Anzahl Datensätze: $anz"); |
?> |
<table class="sel"> |
<tr> |
<th class="sel">Lfd.</th> |
<th class="sel">PrNr.</th> |
<th class="sel">Mitarbeiter</th> |
<th class="sel">Taskname</th> |
<th class="sel">Verfasser</th> |
<th class="sel">Start Datum / Zeit</th> |
<th class="sel">Ende Datum / Zeit</th> |
<th class="sel">Titel</th> |
<th class="sel">Status</th> |
</tr> |
<? |
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$ca_num = $data[0]; |
$ca_prnum = $data[1]; |
$ca_minum = $data[2]; |
$ca_task = $data[3]; |
$ca_writer = $data[4]; |
$ca_date = $data[5]; |
$ca_end = $data[6]; |
$ca_title = $data[7]; |
$ca_status = $data[8]; |
|
if (isset($ca_minum) && $ca_minum > 0) { |
$query = "select mi_nname, mi_vname from mitarbeiter where mi_num = $ca_minum"; |
|
if (!($resmi = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($resmi, 0); |
$mi_nname = $data[0]; |
$mi_vname = $data[1]; |
} else { |
$mi_nname = ""; |
$mi_vname = ""; |
} |
|
$query = "select mi_nname, mi_vname from mitarbeiter where mi_num = $ca_writer"; |
|
if (!($reswr = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($reswr, 0); |
$wr_nname = $data[0]; |
$wr_vname = $data[1]; |
|
if (isset($ca_task) && $ca_task > 0) { |
$query = "select ta_name from task where ta_num = $ca_task"; |
|
if (!($resta = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($resta, 0); |
$ta_name = $data[0]; |
} else |
$ta_name = ""; |
|
echo "<tr>\n<td class=\"selnum\">$ca_num</td>\n"; |
echo "<td class=\"selnum\">$ca_prnum</td>\n"; |
echo "<td class=\"sel\">$mi_nname $mi_vname</td>\n"; |
echo "<td class=\"sel\">$ta_name</td>\n"; |
echo "<td class=\"sel\">$wr_nname $wr_vname</td>\n"; |
echo "<td class=\"selnum\">" . gmdate($datetime, $ca_date) . "</td>\n"; |
echo "<td class=\"selnum\">" . gmdate($datetime, $ca_end) . "</td>\n"; |
echo "<td class=\"sel\">$ca_title</td>\n\n"; |
echo "<td class=\"sel\">"; |
|
switch ($ca_status) { |
case 0: echo "Erledigt"; break; |
default: echo "Offen"; |
} |
|
echo "</td>\n</tr>\n"; |
$i++; |
} |
|
echo "</table>\n"; |
closeDB($db); |
} |
|
function WDONETime() { |
$db = OpenDB(); |
$query = "select wd_num, wd_datum from wdone"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
$korr = 0; |
|
if ($anz > 0) |
QueryDB($db, "begin"); |
|
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$wd_num = $data[0]; |
$wd_datum = $data[1]; |
|
$hour = gmdate("G", $wd_datum); |
|
if ($hour == 0) { |
$i++; |
continue; |
} |
|
$diff = 24 - $hour; |
$wd_datum = $wd_datum + ($diff * 3600); |
$query = "update wdone set wd_datum = $wd_datum where wd_num = $wd_num"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return; |
} |
|
$korr++; |
$i++; |
} |
|
if ($anz > 0) |
QueryDB($db, "commit"); |
|
closeDB($db); |
Error("Es wurden $korr Datensätze korrigiert!"); |
} |
|
function TASKTime() { |
$db = OpenDB(); |
$query = "select ta_num, ta_start from task"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
$korr = 0; |
|
if ($anz > 0) |
QueryDB($db, "begin"); |
|
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$ta_num = $data[0]; |
$ta_start = $data[1]; |
|
$hour = gmdate("G", $ta_start); |
$min = gmdate("i", $ta_start); |
$sec = gmdate("s", $ta_start); |
|
if ($min != 0 || $sec != 0) |
$ta_start = gmmktime(0, 0, 0, gmdate("n", $ta_start), gmdate("j", $ta_start), gmdate("Y", $ta_start)); |
else { |
if ($hour == 0) { |
$i++; |
continue; |
} |
|
$diff = 24 - $hour; |
$ta_start = $ta_start + ($diff * 3600); |
} |
|
$query = "update task set ta_start = $ta_start where ta_num = $ta_num"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return; |
} |
|
$korr++; |
$i++; |
} |
|
if ($anz > 0) |
QueryDB($db, "commit"); |
|
closeDB($db); |
Error("Es wurden $korr Datensätze korrigiert!"); |
} |
|
function ALLOCATIONTime() { |
$db = OpenDB(); |
$query = "select al_num, al_pstart from allocation"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
$korr = 0; |
|
if ($anz > 0) |
QueryDB($db, "begin"); |
|
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$al_num = $data[0]; |
$al_pstart = $data[1]; |
|
$hour = gmdate("G", $al_pstart); |
$min = gmdate("i", $al_pstart); |
$sec = gmdate("s", $al_pstart); |
|
if ($min != 0 || $sec != 0) |
$al_pstart = gmmktime(0, 0, 0, gmdate("n", $al_pstart), gmdate("j", $al_pstart), gmdate("Y", $al_pstart)); |
else { |
if ($hour == 0) { |
$i++; |
continue; |
} |
|
$diff = 24 - $hour; |
$al_pstart = $al_pstart + ($diff * 3600); |
} |
|
$query = "update allocation set al_pstart = $al_pstart where al_num = $al_num"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return; |
} |
|
$korr++; |
$i++; |
} |
|
if ($anz > 0) |
QueryDB($db, "commit"); |
|
closeDB($db); |
Error("Es wurden $korr Datensätze korrigiert!"); |
} |
|
function CALENDARTime() { |
$db = OpenDB(); |
$query = "select ca_num, ca_date, ca_end from calendar"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
$korr = 0; |
|
if ($anz > 0) |
QueryDB($db, "begin"); |
|
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$ca_num = $data[0]; |
$ca_date = $data[1]; |
$ca_end = $data[2]; |
|
$hour = gmdate("G", $ca_date); |
$min = gmdate("i", $ca_date); |
$sec = gmdate("s", $ca_date); |
|
if ($min != 0 || $sec != 0) |
$ca_date = gmmktime(0, 0, 0, gmdate("n", $ca_date), gmdate("j", $ca_date), gmdate("Y", $ca_date)); |
else { |
if ($hour == 0) { |
$i++; |
continue; |
} |
|
$diff = 24 - $hour; |
$ca_date = $ca_date + ($diff * 3600); |
} |
|
$hour = gmdate("G", $ca_end); |
$min = gmdate("i", $ca_end); |
$sec = gmdate("s", $ca_end); |
|
if ($min != 0 || $sec != 0) |
$ca_end = gmmktime(0, 0, 0, gmdate("n", $ca_end), gmdate("j", $ca_end), gmdate("Y", $ca_end)); |
else { |
if ($hour == 0) { |
$i++; |
continue; |
} |
|
$diff = 24 - $hour; |
$ca_end = $ca_end + ($diff * 3600); |
} |
|
$query = "update calendar set ca_date = $ca_date, ca_end = $ca_end where ca_num = $ca_num"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return; |
} |
|
$korr++; |
$i++; |
} |
|
if ($anz > 0) |
QueryDB($db, "commit"); |
|
closeDB($db); |
Error("Es wurden $korr Datensätze korrigiert!"); |
} |
|
function Auswahl() { |
global $menu; |
|
$nav = "headline=26&menu=$menu"; |
echo "<table class=\"indent\"><tr><td colspan=2>Tabelle WDONE</td></tr>\n"; |
echo "<tr><td>\n"; |
ButtonLink("WDONE", "dbview.php", "$nav&func=WDONE"); |
echo "</td><td>\n"; |
ButtonLink("WDONE Zeitkorrektur", "dbview.php", "$nav&func=WDONETIME"); |
echo "</td></tr><tr><td colspan=2>Tabelle TASK</td></tr><tr><td>\n"; |
ButtonLink("TASK", "dbview.php", "$nav&func=TASK"); |
echo "</td><td>"; |
ButtonLink("TASK Zeitkorrektur", "dbview.php", "$nav&func=TASKTIME"); |
echo "</td></tr><tr><td colspan=2>Tabelle ALLOCATION</td></tr><tr><td>\n"; |
ButtonLink("ALLOCATION", "dbview.php", "$nav&func=ALLOCATION"); |
echo "</td><td>"; |
ButtonLink("ALLOCATION Zeitkorrektur", "dbview.php", "$nav&func=ALLOCATIONTIME"); |
echo "</td></tr><tr><td colspan=2>Tabelle CALENDAR</td></tr><tr><td>\n"; |
ButtonLink("CALENDAR", "dbview.php", "$nav&func=CALENDAR"); |
echo "</td><td>"; |
ButtonLink("CALENDAR Zeitkorrektur", "dbview.php", "$nav&func=CALENDARTIME"); |
echo "</td></tr></table>\n"; |
} |
|
$func = $_REQUEST['func']; |
$done = false; |
|
if (!isset($func)) { |
Auswahl(); |
$done = true; |
} |
|
if ($func == "WDONE") { |
ShowWDONE(); |
$done = true; |
} |
|
if ($func == "WDONETIME") |
WDONETime(); |
|
if ($func == "TASK") { |
ShowTASK(); |
$done = true; |
} |
|
if ($func == "TASKTIME") |
TASKTime(); |
|
if ($func == "ALLOCATION") { |
ShowALLOCATION(); |
$done = true; |
} |
|
if ($func == "ALLOCATIONTIME") |
ALLOCATIONTime(); |
|
if ($func == "CALENDAR") { |
ShowCALENDAR(); |
$done = true; |
} |
|
if ($func == "CALENDARTIME") |
CALENDARTime(); |
|
if (!$done) |
Auswahl(); |
|
require_once('footer.inc'); |
?> |