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