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