Location: PHPKode > projects > TheoPlan > pm/ejournal.php
<?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');
?>
Return current item: TheoPlan