public function bindListTermine()
{
$today = date("Y-m-d");
$SQL = "SELECT tm_termin.* FROM tm_termin INNER JOIN tm_termin_organisation ON tm_termin.idtm_termin = tm_termin_organisation.idtm_termin WHERE tm_termin_organisation.idtm_organisation='" . $this->User->getUserOrgId($this->User->getUserId()) . "' ORDER BY ter_startdate ASC";
$this->lstTermine->DataSource = TerminRecord::finder()->findAllBySQL($SQL);
$this->lstTermine->dataBind();
}
/**
*
* @param <int> $ResZeitID The time id, passed by the repeater: 61 => 15:00 -> 15*4+1
* @param <int> $idtm_ressource The Key-Field for the Ressource
*/
public function checkRessourceStatus($ResZeitID, $idtm_organisation)
{
$filterDate = date('Y-m-d', $this->res_selected_date->TimeStamp);
//the calculation of the time-string
$hourresult = round(($ResZeitID - 1) / 4 - 0.26, 0);
$minuteresult = round((($ResZeitID - 1) / 4 - $hourresult) * 60 + 1, 0);
$mySQL = "SELECT tm_termin.* FROM tm_termin INNER JOIN vv_termin_organisation ON tm_termin.idtm_termin = vv_termin_organisation.idtm_termin WHERE ter_starttime <= '" . $hourresult . ":" . $minuteresult . "'";
$mySQL .= " AND ter_endtime >= '" . $hourresult . ":" . $minuteresult . "' AND idtm_organisation = " . $idtm_organisation . " AND ter_startdate = DATE('" . $filterDate . "')";
//print_r($mySQL);
$Results = TerminRecord::finder()->findAllBySQL($mySQL);
if (count($Results) >= 1) {
return "resFull";
} else {
return "resFree";
}
}
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 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 lstCCPrtRepSave($sender, $param)
{
$item = $param->Item;
$RCEditRecord = ProtokollDetailRecord::finder()->findByPK($item->idtm_protokoll_detail->Text);
$RCEditRecord->prtdet_descr = $item->prtdet_descr->Text;
$RCEditRecord->prtdet_topic = $item->prtdet_topic->Text;
$RCEditRecord->prtdet_wvl = $item->prtdet_wvl->Checked ? 1 : 0;
$RCEditRecord->idtm_protokoll = $item->idtm_protokoll->Text;
$RCEditRecord->idta_protokoll_ergebnistype = $item->idta_protokoll_ergebnistype->Text;
if ($item->idtm_activity->Text == 0 or $item->idtm_activity->Text == '') {
$CheckStart = TerminRecord::finder()->findByPK($this->page->edidtm_termin->Text)->idtm_activity;
if ($CheckStart > 0) {
$RCEditRecord->idtm_activity = $CheckStart;
}
} else {
$RCEditRecord->idtm_activity = $item->idtm_activity->Text;
}
$RCEditRecord->save();
$sender->EditItemIndex = -1;
$this->load_prtdetailsgroup();
}
public function TSavedButtonClicked($sender, $param)
{
$tempus = $this->primarykey;
if ($this->termin_edit_status->Text == '1') {
$AEditRecord = TerminRecord::finder()->findByPK($this->{$tempus}->Text);
} else {
$AEditRecord = new TerminRecord();
}
//HIDDEN
foreach ($this->hiddenfields as $recordfield) {
$edrecordfield = $recordfield;
$AEditRecord->{$recordfield} = $this->{$edrecordfield}->Value;
}
//DATUM
foreach ($this->datfields as $recordfield) {
$edrecordfield = $recordfield;
$AEditRecord->{$recordfield} = date('Y-m-d', $this->{$edrecordfield}->TimeStamp);
}
//LIST
foreach ($this->listfields as $recordfield) {
$edrecordfield = $recordfield;
$AEditRecord->{$recordfield} = $this->{$edrecordfield}->Text;
}
//BOOL
foreach ($this->boolfields as $recordfield) {
$edrecordfield = $recordfield;
$AEditRecord->{$recordfield} = $this->{$edrecordfield}->Checked ? 1 : 0;
}
foreach ($this->timefields as $recordfield) {
$edrecordfield = $recordfield;
$AEditRecord->{$recordfield} = $this->{$edrecordfield}->Text;
}
foreach ($this->fields as $recordfield) {
$edrecordfield = $recordfield;
$AEditRecord->{$recordfield} = $this->{$edrecordfield}->Text;
}
$AEditRecord->save();
$this->bindListTermin();
$this->ParticipantbindList();
$this->RessourcebindList();
$this->termin_edit_status->Text = 1;
$this->idtm_termin->Text = $AEditRecord->idtm_termin;
$this->getPage()->getClientScript()->registerEndScript('xdhxs', "scheduler.load('" . $this->getRequest()->constructUrl('page', 'termin.TerminConnector') . "')");
}
