private function ProtokollHeader($idtm_protokoll)
{
$Protokoll = ProtokollRecord::finder()->findBy_idtm_protokoll($idtm_protokoll);
$this->pdf->SetXY(25, 60);
$this->pdf->SetDrawColor(43, 51, 43);
$this->pdf->SetFont('Helvetica', '', 10);
$this->pdf->Cell(185, 5, strtoupper('Protokollnotiz zum Termin am ' . date('j.n.Y', strtotime($Protokoll->prt_cdate))), 0, 0, 'B', 0);
$this->pdf->Ln();
$this->pdf->SetX(25);
$this->pdf->SetDrawColor(43, 51, 43);
$this->pdf->SetFont('Helvetica', '', 10);
$this->pdf->Cell(185, 5, strtoupper('Projekt: ' . utf8_decode($Protokoll->idtm_termin)), 0, 0, 'B', 0);
$this->pdf->Ln();
//$this->pdf->SetX(28);
$this->pdf->SetXY(25, 105);
$this->pdf->SetDrawColor(43, 51, 43);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(50, 5, 'Thema ', 'B');
$this->pdf->Cell(100, 5, utf8_decode($Protokoll->prt_name), 'B', 1);
$this->pdf->SetX(25);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(50, 5, 'Moderator ', 'B');
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(100, 5, utf8_decode(OrganisationRecord::finder()->findByidtm_organisation($Protokoll->idtm_organisation)->org_name), 'B', 1);
$this->pdf->SetX(25);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(50, 5, 'Typ ', 'B');
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(100, 5, utf8_decode(ProtokollTypeRecord::finder()->findByPK($Protokoll->idta_protokoll_type)->prt_type_name), 'B', 1);
$this->pdf->SetX(25);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(50, 5, 'Ort ', 'B');
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(100, 5, utf8_decode($Protokoll->prt_location), 'B', 1);
$this->pdf->SetX(25);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(50, 5, 'Datum ', 'B');
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(100, 5, utf8_decode($Protokoll->prt_cdate), 'B', 1);
$this->pdf->Ln();
$this->pdf->SetX(25);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(50, 5, 'Eingeladen ', 'B', 0);
$this->pdf->SetFont('Arial', '', 10);
$criteria = new TActiveRecordCriteria();
$criteria->Condition = "idtm_activity = :suchtext";
$criteria->Parameters[':suchtext'] = $Protokoll->idtm_termin;
$criteria->OrdersBy["idtm_organisation"] = 'asc';
$AnwesendPP = ActivityParticipantsView::finder()->findAll($criteria);
$i = 0;
foreach ($AnwesendPP as $InvitedP) {
if ($i > 0) {
$this->pdf->SetX(25);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(50, 5, ' ', 'B');
}
$this->pdf->Cell(50, 5, utf8_decode(OrganisationRecord::finder()->findByPK($InvitedP->idtm_organisation)->org_vorname) . ' ' . utf8_decode($InvitedP->org_name), 'B', 0);
$this->pdf->Cell(50, 5, $InvitedP->act_part_anwesend == 1 ? 'anwesend' : '', 'B', 1);
$i++;
}
$this->pdf->Ln();
}
public function dtgList_viewChildren($sender, $param)
{
$url = $this->getRequest()->constructUrl('page', "reports.protokoll.a_Protokoll", array('idtm_protokoll' => $sender->CommandParameter, 'idtm_termin' => ProtokollRecord::finder()->findByPk($sender->CommandParameter)->idtm_termin));
$this->Response->redirect($url);
}
public function deleteButtonClicked($sender, $param)
{
$tempus = 'ed' . $this->primarykey;
$deleteRecord = ProtokollRecord::finder();
$deleteRecord->deleteAll('idtm_protokoll = ?', $this->{$tempus}->Text);
$this->Response->redirect($this->getRequest()->constructUrl('page', $this->exitURL));
}
protected function getSelected()
{
$this->ProtokollRecord = ProtokollRecord::finder()->findByPk($this->idtm_protokoll);
}
private function ProtokollHeader($idtm_protokoll)
{
$Protokoll = ProtokollRecord::finder()->findBy_idtm_protokoll($idtm_protokoll);
$this->pdf->SetY(48);
//$this->pdf->SetX(20);
$this->pdf->SetFillColor(234, 242, 220);
$this->pdf->SetDrawColor(234, 242, 220);
$this->pdf->SetFont('Helvetica', 'B', 12);
$this->pdf->Cell(185, 6, 'Thema - ' . utf8_decode($Protokoll->prt_name), 1, 0, 'B', 1);
$this->pdf->Ln(7);
//$this->pdf->SetX(28);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(30, 5, 'Moderator: ', 0);
$this->pdf->SetFont('Arial', 'B', 10);
$this->pdf->Cell(60, 5, utf8_decode(OrganisationRecord::finder()->findByidtm_organisation($Protokoll->idtm_organisation)->org_name), 0);
$this->pdf->Ln();
//$this->pdf->SetX(28);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(30, 5, 'Typ: ', 0);
$this->pdf->SetFont('Arial', 'B', 10);
$this->pdf->Cell(60, 5, utf8_decode(ProtokollTypeRecord::finder()->findByPK($Protokoll->idta_protokoll_type)->prt_type_name), 0);
$this->pdf->Ln();
//$this->pdf->SetX(28);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(30, 5, 'Ort: ', 0);
$this->pdf->SetFont('Arial', 'B', 10);
$this->pdf->Cell(60, 5, utf8_decode($Protokoll->prt_location), 0);
$this->pdf->Ln();
//$this->pdf->SetX(28);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(30, 5, 'Datum: ', 0);
$this->pdf->SetFont('Arial', 'B', 10);
$this->pdf->Cell(60, 5, utf8_decode($Protokoll->prt_cdate), 0);
$this->pdf->Ln(7);
//$this->pdf->SetX(20);
$this->pdf->SetFillColor(234, 242, 220);
$this->pdf->SetDrawColor(234, 242, 220);
$this->pdf->SetFont('Arial', 'B', 12);
$this->pdf->Cell(185, 6, 'Eingeladen ', 1, 0, 'B', 1);
$this->pdf->Ln(7);
$criteria = new TActiveRecordCriteria();
$criteria->Condition = "idtm_termin = :suchtext";
$criteria->Parameters[':suchtext'] = $Protokoll->idtm_termin;
$criteria->OrdersBy["idtm_organisation"] = 'asc';
$InvitedPP = TerminOrganisationView::finder()->findAll($criteria);
foreach ($InvitedPP as $InvitedP) {
$this->pdf->SetX(20);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(30, 5, 'T: ', 0);
$this->pdf->SetFont('Arial', 'B', 10);
$this->pdf->Cell(60, 5, utf8_decode($InvitedP->org_name), 0);
$this->pdf->Ln();
}
//$this->pdf->SetX(20);
$this->pdf->SetFillColor(234, 242, 220);
$this->pdf->SetDrawColor(234, 242, 220);
$this->pdf->SetFont('Arial', 'B', 12);
$this->pdf->Cell(185, 6, 'Anwesend ', 1, 0, 'B', 1);
$this->pdf->Ln(7);
$criteria = new TActiveRecordCriteria();
$criteria->Condition = "idtm_activity = :suchtext";
$criteria->Parameters[':suchtext'] = $Protokoll->idtm_termin;
$criteria->OrdersBy["idtm_organisation"] = 'asc';
$AnwesendPP = ActivityParticipantsView::finder()->findAll($criteria);
foreach ($AnwesendPP as $InvitedP) {
$this->pdf->SetX(20);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(30, 5, 'T: ', 0);
$this->pdf->SetFont('Arial', 'B', 10);
$this->pdf->Cell(60, 5, utf8_decode($InvitedP->org_name), 0);
$this->pdf->Cell(60, 5, utf8_decode($InvitedP->act_part_notiz), 0);
$this->pdf->Cell(10, 5, $InvitedP->act_part_anwesend == 1 ? 'Ja' : 'Nein', 0);
$this->pdf->Ln();
}
}
