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(); }