Subversion Repositories public

Compare Revisions

Ignore whitespace Rev 3 → Rev 4

/pm/trunk/ejournal.php
0,0 → 1,212
<?php
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');
 
$drm = array(true, false, false, false, true, true, true, true);
$headline = 33;
 
require_once('menu.inc');
 
function ShowEJournal() {
global $rstufe;
global $menu;
global $headline;
 
if ($rstufe != 0 && $rstufe != 1) {
Error("Berechtigungsfehler!");
return;
}
 
$nav = "mitarbeiter='+document.journal.mitarbeiter.value+'&aktion='+document.journal.aktion.value+'&von='+document.journal.von.value+'&bis='+document.journal.bis.value+'&menu=$menu&headline=$headline";
 
$mitarbeiter = $_REQUEST['mitarbeiter'];
$aktion = $_REQUEST['aktion'];
$von = $_REQUEST['von'];
$bis = $_REQUEST['bis'];
 
if (!isset($von) || !isset($bis)) {
$zeite = time();
$zeits = $zeite - 30 * 86400;
$day = gmdate("j", $zeits);
$mon = gmdate("n", $zeits);
$year = gmdate("Y", $zeits);
$dvon = gmmktime(0, 0, 0, $mon, $day, $year);
$von = "$day.$mon.$year";
$day = gmdate("j", $zeite);
$mon = gmdate("n", $zeite);
$year = gmdate("Y", $zeite);
$dbis = gmmktime(23, 59, 59, $mon, $day, $year);
$bis = "$day.$mon.$year";
} else {
$ds = explode(".", $von);
$de = explode(".", $bis);
$dvon = gmmktime(0, 0, 0, $ds[1], $ds[0], $ds[2]);
$dbis = gmmktime(23, 59, 59, $de[1], $de[0], $de[2]);
}
 
$db = OpenDB();
?>
<form name="journal" action="ejournal.php" method="post">
<input type="hidden" name="menu" value="<? echo "$menu"; ?>">
<input type="hidden" name="headline" value="<? echo "$headline"; ?>">
<table class="input">
<tr>
<td>Mitarbeiter:</td>
<td><select name="mitarbeiter" onChange="javascript:MoveTo('ejournal.php','<? echo "$nav"; ?>')">
<option value="0">Alle</option>
<?
$query = "select distinct ej_uid, mi_nname, mi_vname from ejournal, mitarbeiter where ";
$query .= "mi_num = ej_uid order by mi_nname, mi_vname";
 
if (!($result = QueryDB($db, $query))) {
closeDB($db);
return;
}
 
$anz = numrowsDB($result);
$i = 0;
$flag = false;
 
while ($i < $anz) {
$data = fetchDB($result, $i);
$ej_uid = $data[0];
$mi_nname = $data[1];
$mi_vname = $data[2];
 
if (isset($mitarbeiter) && $mitarbeiter == $ej_uid) {
echo " <option value=\"$ej_uid\" selected>$mi_nname $mi_vname</option>\n";
$flag = true;
} else
echo " <option value=\"$ej_uid\">$mi_nname $mi_vname</option>\n";
 
$i++;
}
 
if (!$flag)
$mitarbeiter = 0;
?>
</select>
</td>
</tr>
<tr>
<td>Aktion:</td>
<td><select name="aktion" onChange="javascript:MoveTo('ejournal.php','<? echo "$nav"; ?>')">
<option value="0">Alle</option>
<?
$query = "select distinct kj_num, kj_text from ejournal, key_jtype where ";
$query .= "kj_num = ej_type and ej_date between $dvon and $dbis ";
 
if (isset($mitarbeiter) && $mitarbeiter > 0)
$query .= "and ej_uid = $mitarbeiter ";
 
$query .= "order by kj_num";
 
if (!($result = QueryDB($db, $query))) {
closeDB($db);
return;
}
 
$anz = numrowsDB($result);
$i = 0;
$flag = false;
 
while ($i < $anz) {
$data = fetchDB($result, $i);
$kj_num = $data[0];
$kj_text = $data[1];
 
if (isset($aktion) && $aktion == $kj_num) {
echo " <option value=\"$kj_num\" selected>$kj_text</option>\n";
$flag = true;
} else
echo " <option value=\"$kj_num\">$kj_text</option>\n";
 
$i++;
}
 
if (!$flag)
$aktion = 0;
?>
</select>
</td>
</tr>
<tr>
<td>Zeitraum von:</td>
<td><input type="text" name="von" value="<? echo "$von"; ?>" onChange="javascript:CheckDate(this, false)" size=10 maxlength=10></td>
</tr>
<tr>
<td>Zeitraum bis:</td>
<td><input type="text" name="bis" value="<? echo "$bis"; ?>" onChange="javascript:CheckDate(this, false)" size=10 maxlength=10></td>
</tr>
<tr>
<td colspan=2>
<?
Button("Zeitraum setzen", "journal");
?>
</td>
</tr>
</table>
</form>
<?
$query = "select ej_num, ej_date, ej_text, kj_text, mi_nname, mi_vname from ";
$query .= "ejournal, key_jtype, mitarbeiter where kj_num = ej_type and ";
$query .= "mi_num = ej_uid and ej_date between $dvon and $dbis ";
 
if (isset($mitarbeiter) && $mitarbeiter > 0)
$query .= "and ej_uid = $mitarbeiter ";
 
if (isset($aktion) && $aktion > 0)
$query .= "and ej_type = $aktion ";
 
$query .= "order by ej_date desc, mi_nname, mi_vname";
 
if (!($result = QueryDB($db, $query))) {
closeDB($db);
return;
}
 
$anz = numrowsDB($result);
 
if ($anz <= 0)
return;
 
$i = 0;
?>
<br>
<table class="sel">
<tr>
<th class="sel">Datum</th>
<th class="sel">Ausgef&uuml;hrt von</th>
<th class="sel">Aktion</th>
<th class="sel">Anmerkung</th>
</tr>
<?
while ($i < $anz) {
$data = fetchDB($result, $i);
$ej_num = $data[0];
$ej_date = $data[1];
$ej_text = $data[2];
$kj_text = $data[3];
$mi_nname = $data[4];
$mi_vname = $data[5];
 
echo "<tr><td class=\"sel\">" . date("d.m.Y H:i:s", $ej_date) . "</td>\n";
echo "<td class=\"sel\">$mi_nname $mi_vname</td>\n";
echo "<td class=\"sel\">$kj_text</td>\n";
echo "<td class=\"sel\">$ej_text</td></tr>\n";
$i++;
}
 
echo "</table>\n";
closeDB($db);
}
 
ShowEJournal();
 
require_once('footer.inc');
?>