0,0 → 1,219 |
<? |
function AskLockM() { |
global $menu; |
global $headline; |
global $periode; |
global $dtformatshort; |
|
$pl_num = $_REQUEST['pl_num']; |
|
if (!isset($pl_num) || $pl_num <= 0) { |
Error("AskLockM: Interner Fehler: Plannummer fehlt oder ist ungültig!"); |
return; |
} |
|
$ps_1 = $_REQUEST['ps_1']; |
$ps_2 = $_REQUEST['ps_2']; |
$ps_3 = $_REQUEST['ps_3']; |
$ps_4 = $_REQUEST['ps_4']; |
$ps_5 = $_REQUEST['ps_5']; |
$ps_6 = $_REQUEST['ps_6']; |
$sx_prnum = $_REQUEST['sx_prnum']; |
$sx_prname = $_REQUEST['sx_prname']; |
$nav = "ps_1=$ps_1&ps_2=$ps_2&ps_3=$ps_3&ps_4=$ps_4&ps_5=$ps_5&ps_6=$ps_6&"; |
$nav .= "sx_prnum=$sx_prnum&sx_prname=$sx_prname&menu=$menu&headline=$headline"; |
$db = OpenDB(); |
$query = "select pl_prnum, pr_name from plan, project where "; |
$query .= "pr_num = pl_prnum and pl_num = $pl_num"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$data =fetchDB($result, 0); |
$pr_num = $data[0]; |
$pr_name = $data[1]; |
|
# Ermitteln des Anfangsdatums des gewaehlten Projekts. |
$query = "select ta_start from task where ta_plnum = $pl_num order by ta_start"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($result, 0); |
$ta_start = $data[0]; |
|
$query = "select ab_datum from abschluss where ab_prnum = $pr_num order by ab_datum desc"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
if (numrowsDB($result) > 0) { |
$data =fetchDB($result, 0); |
$ab_datum = $data[0]; |
} else |
$ab_datum = 0; |
|
$mon = gmdate("n", $ta_start); |
$year = gmdate("Y", $ta_start); |
$dt = gmmktime(0, 0, 0, $mon, 1, $year); |
|
if ($ab_datum > $dt) |
$dt = $ab_datum; |
|
$mon = date("n"); |
$year = date("Y"); |
$dte = gmmktime(0, 0, 0, $mon, 1, $year); |
?> |
<form name="lock" action="plan.php" method="post"> |
<input type="hidden" name="menu" value="<? echo "$menu"; ?>"> |
<input type="hidden" name="headline" value="<? echo "$headline"; ?>"> |
<input type="hidden" name="pr_num" value="<? echo "$pr_num"; ?>"> |
<input type="hidden" name="pl_num" value="<? echo "$pl_num"; ?>"> |
<input type="hidden" name="ab_datum" value="<? echo "$ab_datum"; ?>"> |
<input type="hidden" name="ps_1" value="<? echo "$ps_1"; ?>"> |
<input type="hidden" name="ps_2" value="<? echo "$ps_2"; ?>"> |
<input type="hidden" name="ps_3" value="<? echo "$ps_3"; ?>"> |
<input type="hidden" name="ps_4" value="<? echo "$ps_4"; ?>"> |
<input type="hidden" name="ps_5" value="<? echo "$ps_5"; ?>"> |
<input type="hidden" name="ps_6" value="<? echo "$ps_6"; ?>"> |
<input type="hidden" name="sx_prnum" value="<? echo "$sx_prnum"; ?>"> |
<input type="hidden" name="sx_prname" value="<? echo "$sx_prname"; ?>"> |
<input type="hidden" name="func" value="LockProject"> |
<table class="input"> |
<tr> |
<th class="sel" colspan=2>Projekt abschließen</th> |
</tr> |
<tr> |
<td>Projekt:</td> |
<td><? echo "$pr_num $pr_name"; ?></td> |
</tr> |
<tr> |
<td>Letzter Abschluß:</td> |
<td><? if ($ab_datum > 0) echo GetShortDate($ab_datum); else echo "- - - - -"; ?></td> |
</tr> |
<tr> |
<td>Projektabschluß bis:</td> |
<td><select name="datum"> |
<? |
$mon = gmdate("n", $dt); |
$year = gmdate("Y", $dt); |
$akt = gmmktime(0, 0, 0, $mon, 1, $year); |
$emon = gmdate("n", $dte); |
$eyear = gmdate("Y", $dte); |
|
while ($akt < $dte) { |
echo "<option value=\"$akt\""; |
|
$mon++; |
|
if ($mon > 12) { |
$mon = 1; |
$year++; |
} |
|
if ($mon == $emon && $year == $eyear) |
echo " selected"; |
|
echo ">" . GetShortDate($akt) . "</option>\n"; |
$akt = gmmktime(0, 0, 0, $mon, 1, $year); |
} |
?> |
</select> |
</td> |
</tr> |
</table> |
<table class="indent"><tr><td> |
<? |
Button("Projekt abschließen", "lock"); |
echo "</td><td>"; |
ButtonLink("Abbrechen", "plan.php", "plchange=plchange&$nav"); |
echo "</td></tr></table></form>\n"; |
closeDB($db); |
} |
|
function LockProject() { |
global $menu; |
global $headline; |
global $unum; |
|
$pr_num = $_REQUEST['pr_num']; |
$datum = $_REQUEST['datum']; |
$pl_num = $_REQUEST['pl_num']; |
$ab_datum = $_REQUEST['ab_datum']; |
|
if (!isset($pr_num) || $pr_num <= 0) { |
Error("LockProject: Interner Fehler: Projektnummer wurde nicht übergeben!"); |
return; |
} |
|
if (!isset($datum) || $datum <= 0) { |
Error("LockProject: Interner Fehler: Datum wurde nicht übergeben!"); |
return; |
} |
|
if (!isset($pl_num) || $pl_num <= 0) { |
Error("LockProject: Interner Fehler: Plannummer wurde nicht übergeben!"); |
return; |
} |
|
if (!isset($ab_datum)) |
$ab_datum = 0; |
|
$mon = gmdate("n", $datum); |
$year = gmdate("Y", $datum); |
$dat = gmmktime(0, 0, 0, $mon, daysinmonth($mon, $year), $year); |
$db = OpenDB(); |
|
$query = "select co_abschluss from counter"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$data = fetchDB($result, 0); |
$co_abschluss = $data[0] + 1; |
|
if (!QueryDB($db, "begin")) { |
closeDB($db); |
return; |
} |
|
$query = "update wdone set wd_edit = false where wd_prnum = $pr_num and "; |
$query .= "wd_datum <= $dat"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return; |
} |
|
$query = "insert into abschluss (ab_num, ab_datum, ab_user, ab_prnum,"; |
$query .= "ab_plnum) values ($co_abschluss, $dat, $unum, $pr_num, "; |
$query .= "$pl_num)"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return; |
} |
|
$query = "update counter set co_abschluss = $co_abschluss"; |
|
if (!QueryDB($db, $query)) { |
QueryDB($db, "rollback"); |
closeDB($db); |
return; |
} |
|
QueryDB($db, "commit"); |
closeDB($db); |
} |
|
?> |