public function onPreInit($param)
{
//error_reporting(E_ALL ^ E_NOTICE);
$request_user = $_GET['user'];
$request_password = $_GET['pass'];
$authManager = $this->Application->getModule('auth');
if (!$authManager->login($request_user, $request_password)) {
exit;
}
$this->getResponse()->appendHeader("Content-Type:" . $this->header);
echo '<?xml version="1.0" ?><ta_kosten_status>';
$SQL = "SELECT * FROM ta_kosten_status";
$Results = KostenStatusRecord::finder()->findAllBySQL($SQL);
foreach ($Results as $Result) {
echo "<row idta_kosten_status='" . $Result->idta_kosten_status . "'>";
echo "<kst_status_name>" . $Result->kst_status_name . "</kst_status_name>";
echo "</row>";
}
echo '</ta_kosten_status>';
exit;
}
public function onLoad($param)
{
date_default_timezone_set('Europe/Berlin');
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
$this->RCedidtm_organisation->Text = $this->User->getUserOrgId($this->User->getUserId());
$tmpstartdate = new DateTime();
$tmpstartdate->modify("-30days");
$this->zeiterfassung_datestart->setDate($tmpstartdate->format("Y-m-d"));
$tmpstartdate->modify("45days");
$this->zeiterfassung_dateende->setDate($tmpstartdate->format("Y-m-d"));
$this->bindListRCValue();
$idta_kostenstatus = PFH::build_SQLPullDown(KostenStatusRecord::finder(), "ta_kosten_status", array("idta_kosten_status", "kst_status_name"));
$idta_kostenstatus["Alle"] = "Alle anzeigen";
$this->idta_kosten_status->DataSource = $idta_kostenstatus;
$this->idta_kosten_status->dataBind();
$this->idta_kosten_status->Text = "Alle";
$idtm_activity = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_name", "act_pspcode"), "idta_activity_type = 2", "act_name ASC");
$idtm_activity["Alle"] = "Alle anzeigen";
$this->idtm_activity->DataSource = $idtm_activity;
$this->idtm_activity->dataBind();
$this->idtm_activity->Text = "Alle";
}
}
public function createZeitPullDown()
{
//Als erstes die Organisation
if ($this->User->getIsAdmin()) {
$this->RCedidtm_organisation->Text = "";
} else {
$this->RCedidtm_organisation->Text = $this->User->getUserOrgId($this->User->getUserId());
}
$this->RCedidta_kosten_status->DataSource = PFH::build_SQLPullDown(KostenStatusRecord::finder(), "ta_kosten_status", array("idta_kosten_status", "kst_status_name"));
$this->RCedidta_kosten_status->dataBind();
$PRTREE = new PFHierarchyPullDown();
$PRTREE->setStructureTable("tm_prozess");
$PRTREE->setRecordClass(ProzessRecord::finder());
$PRTREE->setPKField("idtm_prozess");
$PRTREE->setField("pro_name");
$PRTREE->letsrun();
$this->RCedidtm_prozess->DataSource = $PRTREE->myTree;
$this->RCedidtm_prozess->dataBind();
$fahrt_status = array(1 => "abbrechenbar", 2 => "ausweisbar", 3 => "privat");
$this->fahrt_status->DataSource = $fahrt_status;
$this->fahrt_status->dataBind();
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_activity");
$HRKEYTest->setRecordClass(ActivityRecord::finder());
$HRKEYTest->setPKField("idtm_activity");
$HRKEYTest->setField("act_name");
$HRKEYTest->setStartNode($this->UserStartId);
$HRKEYTest->setSQLCondition("idta_activity_type = 2");
$HRKEYTest->letsrun();
$this->FFidtm_activity->DataSource = $HRKEYTest->myTree;
$this->FFidtm_activity->dataBind();
$this->FFidtm_activity->Text = $this->UserStartId;
$this->RCedzeit_date->setDate(date('Y-m-d', time()));
// $this->RCedidtm_activity->DataSource=PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(),"tm_activity",array("idtm_activity","act_name","act_pspcode"),"idta_activity_type = 2","act_name ASC");
// $this->RCedidtm_activity->dataBind();
}
