public function SavedButtonClicked($sender, $param) { $Datensatz = ActivityRecord::finder()->findByPK($this->edidtm_activity->Text); $Datensatz->act_descr = $this->edact_descr->Text; $Datensatz->save(); $sender->Text = "Saved"; }
private function load_all_cats($TTSQL) { $rows = ActivityRecord::finder()->findAllbySQL($TTSQL); foreach ($rows as $row) { $this->subcats[$row->parent_idtm_activity][] = $row->idtm_activity; $this->parentcats[$row->idtm_activity] = $row->parent_idtm_activity; } }
public function callback_MyCallbackDrop($sender, $param) { if ($this->page->isCallback && $this->page->isPostBack) { $theObjectContainingParameters = $param->CallbackParameter; $Record = ActivityRecord::finder()->findBy_idtm_activity($theObjectContainingParameters->idtm_activity); $Record->parent_idtm_activity = $theObjectContainingParameters->parent_idtm_activity; $Record->save(); } }
public function bindListCostActivityValue() { $SQL = "SELECT a.idtm_activity AS idtm_activity, a.act_name AS act_name, a.act_dauer AS act_dauer,SUM( act_dauer * res_kosten *8 ) AS ttact_kosten FROM tm_activity a INNER JOIN tm_organisation b ON a.idtm_organisation = b.idtm_organisation INNER JOIN tm_ressource c ON b.idtm_ressource = c.idtm_ressource GROUP BY act_name, idtm_activity ORDER BY act_startdate"; $this->ActivityKostenListe->VirtualItemCount = count(ActivityRecord::finder()->findAllBySQL($SQL)); $criteria = new TActiveRecordCriteria(); $criteria->setLimit($this->ActivityKostenListe->PageSize); $criteria->setOffset($this->ActivityKostenListe->PageSize * $this->ActivityKostenListe->CurrentPageIndex); $this->ActivityKostenListe->DataKeyField = 'idta_activity'; $this->ActivityKostenListe->DataSource = ActivityRecord::finder()->findAllBySQL($SQL); $this->ActivityKostenListe->dataBind(); $this->generateRisikoGraph(ActivityRecord::finder()->findAllBySQL($SQL)); }
public function createRfCPullDown() { //Als erstes die Organisation $this->RfCedsuggest_idtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4"); $this->RfCedsuggest_idtm_organisation->dataBind(); //Als erstes die Organisation $this->RfCedgenemigt_idtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4"); $this->RfCedgenemigt_idtm_organisation->dataBind(); //einlesen der aktivitaeten $this->RfCedidtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_pspcode", "act_name")); $this->RfCedidtm_activity->dataBind(); }
public function onInit($param) { parent::onInit($param); //Globale definition fuer dieses Dokument $this->finder = ZieleRecord::finder(); $this->MASTERRECORD = new ZieleRecord(); if (!$this->isPostBack) { switch ($this->Request['modus']) { case 0: $sql = "SELECT idta_ziele_type, zie_type_name FROM ta_ziele_type"; $data = PFH::convertdbObjectArray(ZieleTypeRecord::finder()->findAllBySql($sql), array("idta_ziele_type", "zie_type_name")); $this->idta_ziele_type->DataSource = $data; $this->idta_ziele_type->dataBind(); $HRKEYTest = new PFHierarchyPullDown(); $HRKEYTest->setStructureTable("tm_ziele"); $HRKEYTest->setRecordClass(ZieleRecord::finder()); $HRKEYTest->setPKField("idtm_ziele"); $HRKEYTest->setField("zie_name"); $HRKEYTest->letsrun(); $this->parent_idtm_ziele->DataSource = $HRKEYTest->myTree; $this->parent_idtm_ziele->dataBind(); $this->idtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_pspcode", "act_name"), "idta_activity_type = 2"); $this->idtm_activity->dataBind(); break; case 1: $sql = "SELECT idta_ziele_type, zie_type_name FROM ta_ziele_type"; $data = PFH::convertdbObjectArray(ZieleTypeRecord::finder()->findAllBySql($sql), array("idta_ziele_type", "zie_type_name")); $this->edidta_ziele_type->DataSource = $data; $this->edidta_ziele_type->dataBind(); $HRKEYTest = new PFHierarchyPullDown(); $HRKEYTest->setStructureTable("tm_ziele"); $HRKEYTest->setRecordClass(ZieleRecord::finder()); $HRKEYTest->setPKField("idtm_ziele"); $HRKEYTest->setField("zie_name"); $HRKEYTest->letsrun(); $this->edparent_idtm_ziele->DataSource = $HRKEYTest->myTree; $this->edparent_idtm_ziele->dataBind(); $this->fillValues($this->getSelected($this->Request[$this->primarykey])); $this->edidtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_pspcode", "act_name"), "idta_activity_type = 2"); $this->edidtm_activity->dataBind(); //$this->bindListed(); break; default: break; } $this->viewPanel->ActiveViewIndex = $this->Request['modus']; } }
public function TSavedButtonClicked() { foreach ($this->RepActListe->Items as $item) { //if($item->ItemType==='Item' || $item->ItemType==='AlternatingItem'){ if ($item->edanwenden->Checked) { $myEditRecord = ActivityRecord::finder()->findByPK($item->idtm_activity->Text); $myEditRecord->act_startdate = $item->edttact_startdate->Text; $myEditRecord->act_enddate = $item->edttact_enddate->Text; $myEditRecord->save(); $item->act_startdate->Text = $myEditRecord->act_startdate; $item->act_enddate->Text = $myEditRecord->act_enddate; } // } } $this->bindTerminListe(); }
public function initPullDown() { $this->idta_protokoll_ergebnistype->dataSource = PFH::build_SQLPullDown(ProtokollErgebnistypeRecord::finder(), "ta_protokoll_ergebnistype", array("idta_protokoll_ergebnistype", "prt_ergtype_name")); $this->idta_protokoll_ergebnistype->dataBind(); $HRKEYTest = new PFHierarchyPullDown(); $HRKEYTest->setStructureTable("tm_activity"); $HRKEYTest->setRecordClass(ActivityRecord::finder()); $HRKEYTest->setPKField("idtm_activity"); $HRKEYTest->setField("act_name"); $CheckStart = TerminRecord::finder()->findByPK($this->page->edidtm_termin->Text)->idtm_activity; if ($CheckStart > 0) { $HRKEYTest->setStartNode($CheckStart); } $HRKEYTest->letsrun(); $this->idtm_activity->DataSource = $HRKEYTest->myTree; $this->idtm_activity->dataBind(); }
public function onPreInit($param) { if (isset($_GET['idtm_termin'])) { $TerminRecord = TerminRecord::finder()->findByPK($_GET['idtm_termin']); } else { echo "Kein Termin"; exit; } date_default_timezone_set('Europe/Berlin'); $v = new vcalendar(); // initiate new CALENDAR $v->setConfig('pliq_hpartner', 'planlogiq.com'); // config with site domain $e = new vevent(); // initiate a new EVENT $SDateArray = explode('-', $TerminRecord->ter_startdate); $EDateArray = explode('-', $TerminRecord->ter_enddate); $STimeArray = explode(':', $TerminRecord->ter_starttime); $ETimeArray = explode(':', $TerminRecord->ter_endtime); $e->setProperty('categories', ActivityRecord::finder()->findByPK($TerminRecord->idtm_activity)->act_name); // catagorize $e->setProperty('dtstart', $SDateArray[0], $SDateArray[1], $SDateArray[2], $STimeArray[0], $STimeArray[1], 00); // 24 dec 2006 19.30 $e->setProperty('dtend', $EDateArray[0], $EDateArray[1], $EDateArray[2], $ETimeArray[0], $ETimeArray[1], 00); // 24 dec 2006 19.30 //$e->setProperty( 'duration' // , 0, 0, 3 ); // 3 hours $e->setProperty('summary', $TerminRecord->ter_betreff); // describe the event $e->setProperty('description', $TerminRecord->ter_descr); // describe the event $e->setProperty('location', $TerminRecord->ter_ort); // locate the event $v->addComponent($e); // add component to calendar /* alt. production */ // $v->returnCalendar(); // generate and redirect output to user browser /* alt. dev. and test */ $str = $v->createCalendar(); // generate and get output in string, for testing? $this->getResponse()->appendHeader("Content-Type:" . $this->header); $this->getResponse()->appendHeader("Content-Disposition:inline;filename=" . $this->docName . '.' . $this->ext); echo $str; $writer->save('php://output'); exit; }
public static function cleanStrukturStruktur() { //sql statement to find elements without matching parent $sql = "SELECT idtm_activity FROM tm_activity WHERE idtm_activity NOT IN (SELECT a.idtm_activity FROM tm_activity a INNER JOIN tm_activity b ON a.parent_idtm_activity = b.idtm_activity) AND idtm_activity > 1"; $StrukturElements = ActivityRecord::finder()->findAllBySql($sql); foreach ($StrukturElements as $StrukturElement) { WerteRecord::finder()->deleteAll('idtm_activity = ?', $StrukturElement->idtm_activity); ActivityRecord::finder()->deleteByidtm_activity($StrukturElement->idtm_activity); //debug only echo "DE\n"; } unset($StrukturElements); //null-Werte entfernen $sql = "SELECT idtm_activity FROM tm_activity WHERE ISNULL(act_lft)"; $StrukturElements = ActivityRecord::finder()->findAllBySql($sql); foreach ($StrukturElements as $StrukturElement) { WerteRecord::finder()->deleteAll('idtm_activity = ?', $StrukturElement->idtm_activity); ActivityRecord::finder()->deleteByidtm_activity($StrukturElement->idtm_activity); //debug only echo "DE\n"; } unset($StrukturElements); }
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" ?><tm_activity>'; $SQL = "SELECT * FROM tm_activity WHERE idta_activity_type = '2'"; $Results = ActivityRecord::finder()->findAllBySQL($SQL); foreach ($Results as $Result) { echo "<row idtm_activity='" . $Result->idtm_activity . "'>"; echo "<parent_idtm_activity>" . $Result->parent_idtm_activity . "</parent_idtm_activity>"; echo "<act_name>" . $Result->act_name . "</act_name>"; echo "<act_pspcode>" . $Result->act_pspcode . "</act_pspcode>"; echo "</row>"; } echo '</tm_activity>'; 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 addNewDetailGroup($sender, $param) { $newprtdetRecord = new ProtokollDetailRecord(); $newprtdetRecord->idtm_protokoll_detail_group = $param->CallbackParameter; $newprtdetRecord->idta_protokoll_ergebnistype = 3; $newprtdetRecord->idtm_protokoll = $this->edidtm_protokoll->Data; $CheckStart = TerminRecord::finder()->findByPK($this->page->edidtm_termin->Text)->idtm_activity; if ($CheckStart > 0) { $newprtdetRecord->idtm_activity = $CheckStart; } else { $newprtdetRecord->idtm_activity = ActivityRecord::finder()->findByparent_idtm_activity(0)->idtm_activity; } $newprtdetRecord->prtdet_wvl = 0; $newprtdetRecord->save(); $newaufgabenRecord = new AufgabenRecord(); $newaufgabenRecord->auf_id = $newprtdetRecord->idtm_protokoll_detail; $newaufgabenRecord->auf_tabelle = 'tm_protokoll_detail'; $newaufgabenRecord->auf_name = 'Protokollpunkt'; $newaufgabenRecord->idtm_organisation = 1; $newaufgabenRecord->auf_deleted = 0; $newaufgabenRecord->save(); $this->load_prtdetailsgroup(); }
public function TSavedButtonClicked() { foreach ($this->RepActListe->Items as $item) { //if($item->ItemType==='Item' || $item->ItemType==='AlternatingItem'){ if ($item->edanwenden->Checked) { $myEditRecord = ActivityRecord::finder()->findByPK($item->idtm_activity->Text); $myEditRecord->act_gp = $item->edttact_gp->Text; $myEditRecord->act_fp = $item->edttact_fp->Text; $myEditRecord->act_faz = $item->edttact_faz->Text; $myEditRecord->act_fez = $item->edttact_fez->Text; $myEditRecord->act_saz = $item->edttact_saz->Text; $myEditRecord->act_sez = $item->edttact_sez->Text; $myEditRecord->save(); $item->act_faz->Text = $myEditRecord->act_faz; $item->act_fez->Text = $myEditRecord->act_fez; $item->act_saz->Text = $myEditRecord->act_saz; $item->act_sez->Text = $myEditRecord->act_sez; } // } } $this->dataBind(); }
protected function getSelected() { $this->ActivityRecord = ActivityRecord::finder()->findByPk($this->idtm_activity); }
private function generateZeitVerlaufImage($idtm_activity = 0) { if ($idtm_activity > 0) { $myActInSQL = "(act_lft BETWEEN " . ActivityRecord::finder()->findByPK($idtm_activity)->act_lft . " AND " . ActivityRecord::finder()->findByPK($idtm_activity)->act_rgt . ")"; $xdata1 = array(); $xdata2 = array(); $ytitle = array("Stunden"); $title = array("Monat"); $legend = array("verbar", "nicht verbar"); $ii = 0; $sql = "SELECT DATE_FORMAT(zeit_date,'%Y%m') AS zeit_date, SUM(CASE WHEN idta_kosten_status='1' THEN zeit_dauer ELSE 0 END) AS zeit_dauer, SUM(CASE WHEN idta_kosten_status='2' OR idta_kosten_status='3' THEN zeit_dauer ELSE 0 END) AS zeit_break FROM tm_zeiterfassung INNER JOIN tm_activity ON tm_zeiterfassung.idtm_activity = tm_activity.idtm_activity WHERE " . $myActInSQL . " AND YEAR(zeit_date) = YEAR(NOW()) GROUP BY DATE_FORMAT(zeit_date,'%Y-%m') LIMIT 0, 15 "; $ActiveRecord = ZeiterfassungRecord::finder()->findAllBySQL($sql); if (is_array($ActiveRecord)) { foreach ($ActiveRecord as $DetailRecord) { $xdata1[] = "[" . $DetailRecord->zeit_date . "," . $DetailRecord->zeit_dauer . "]"; $xdata2[] = "[" . $DetailRecord->zeit_date . "," . $DetailRecord->zeit_break . "]"; $ii++; if ($ii > 12) { break; } } unset($ActiveRecord); if (count($xdata1) > 1) { $xdata1 = implode(',', $xdata1); $xdata2 = implode(',', $xdata2); } } if (count($xdata1) >= 1) { $this->getPage()->getClientScript()->registerEndScript('xzvi', "drawPFMultiChart('ZeitVerlaufImage',new Array({$xdata1}),new Array({$xdata2}),'line')"); } else { $xdata1[] = "[0,'no Data']"; $xdata2[] = "[0,'no Data']"; $this->getPage()->getClientScript()->registerEndScript('xzvi', "drawPFMultiChart('ZeitVerlaufImage',new Array({$xdata1}),new Array({$xdata2}),'line')"); } unset($xdata1, $xdata2); $this->generateActivityCookieImage($idtm_activity, $myActInSQL); $this->generateActivityTypeCookieImage($idtm_activity, $myActInSQL); $this->generateActivityVerlaufImage($idtm_activity, $myActInSQL); } }
public function bindRepeaterPhasen2($sender, $param) { $item = $param->Item; if ($item->ItemType === 'Item' || $item->ItemType === 'AlternatingItem') { $criteria = new TActiveRecordCriteria(); $criteria->Condition = "parent_idtm_activity = :suchtext2"; $criteria->Parameters[':suchtext2'] = $item->Data->idtm_activity; $item->RepPhasen2->DataSource = ActivityRecord::finder()->findAll($criteria); $item->RepPhasen2->dataBind(); } }
<?php /* * To change this template, choose Tools | Templates * and open the template in the editor. */ Prado::using('Application.3rdParty.Classes.PHPExcel'); Prado::using('Application.3rdParty.Classes.PHPExcel.Writer.*'); $workbook = new PFExcel(); $sheet = $workbook->getActiveSheet(); $sheet->setTitle('RISKLOGIQ'); $sheet->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE); $sheet->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); $sheet->getRowDimension('1')->setRowHeight(50); $workbook->getActiveSheet()->getStyle('A1')->applyFromArray(array('font' => array('bold' => true, 'size' => 12, 'color' => array('rgb' => 'FF00FF00')), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT), 'borders' => array('top' => array('style' => PHPExcel_Style_Border::BORDER_THIN)), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR, 'rotation' => 90, 'startcolor' => array('argb' => 'FFA0A0A0'), 'endcolor' => array('argb' => 'FFFFFFFF'))), 'A3:E3'); $workbook->getActiveSheet()->duplicateStyle($workbook->getActiveSheet()->getStyle('A1'), 'B1:ZZ1'); $sheet->setCellValue('A1', "RISKLOGIQ"); $sheet->mergeCells('A1:B1'); $Records = ActivityRecord::finder()->findAll(); $counter = 5; foreach ($Records as $Record) { $sheet->setCellValue('A' . $counter, $Record->act_pspcode); $sheet->setCellValue('B' . $counter, $Record->act_name); $sheet->setCellValue('C' . $counter, $Record->act_dauer); $sheet->setCellValue('D' . $counter, $Record->act_faz); $sheet->setCellValue('E' . $counter, $Record->act_fez); $counter++; } $workbook->generate('Excel2007', 'risklogiq2009');
public function get_PSPParents($Node) { $SQL = "SELECT * FROM ta_activity_activity WHERE idtm_activity = '" . $Node->idtm_activity . "'"; $Result = count(ActivityActivityRecord::finder()->findAllBySQL($SQL)); if ($Result >= 1) { $SSQL = "SELECT * FROM tm_activity WHERE "; $counter = 0; foreach (ActivityActivityRecord::finder()->findAllBySQL($SQL) as $Results) { $counter == 0 ? $SSQL .= "idtm_activity = '" . $Results->pre_idtm_activity . "'" : ($SSQL .= " OR idtm_activity = '" . $Results->pre_idtm_activity . "'"); $counter++; } return ActivityRecord::finder()->findAllBySQL($SSQL); } }