private function LetterContent($idtm_protokoll)
{
$SQL = "SELECT idtm_protokoll_detail_group FROM ta_protokoll_detail_group WHERE idtm_protokoll = " . $idtm_protokoll;
$execSQL = "SELECT * FROM vv_protokoll_detail WHERE idtm_protokoll_detail_group IN (" . $SQL . ") ORDER BY idtm_protokoll_detail DESC";
$ProtokollDetails = ProtokollDetailView::finder()->findAllBySQL($execSQL);
$this->pdf->Ln(10);
$this->pdf->SetX(25);
$this->pdf->SetFillColor(234, 242, 220);
$this->pdf->SetDrawColor(234, 242, 220);
$this->pdf->SetFont('Helvetica', '', 12);
$this->pdf->Cell(185, 6, strtoupper('Protokoll'), 0, 1);
$this->InternalCounter++;
foreach ($ProtokollDetails as $ProtokollDetail) {
$this->pdf->Ln(7);
$this->pdf->SetX(25);
$this->pdf->SetFont('Arial', '', 11);
$this->pdf->SetFillColor(116, 145, 97);
$this->pdf->SetDrawColor(116, 145, 97);
$this->pdf->SetTextColor(0, 0, 0);
$this->pdf->Cell(150, 4, $this->InternalCounter . ' \\\\ ' . utf8_decode($ProtokollDetail->prtdet_topic), 'B', 1);
$this->InternalCounter++;
$this->pdf->SetLeftMargin(25);
$this->pdf->SetFillColor(255, 255, 255);
$this->pdf->SetTextColor(0, 0, 0);
$myHTML = $this->wiki2html($ProtokollDetail->prtdet_descr);
$this->pdf->WriteHTML(utf8_decode($myHTML));
if ($ProtokollDetail->idta_protokoll_ergebnistype < 3) {
$SubSQL = "SELECT * FROM tm_aufgaben WHERE auf_tabelle = 'tm_protokoll_detail' AND auf_id = " . $ProtokollDetail->idtm_protokoll_detail . " AND auf_deleted = 0";
$PrtSubAufagben = AufgabenRecord::finder()->findAllBySQL($SubSQL);
foreach ($PrtSubAufagben as $PrtAufgabe) {
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->Cell(5, 5, '\\\\', 0, 0);
$this->pdf->SetTextColor(217, 0, 0);
$this->pdf->Cell(145, 5, ' Auftrag', 0, 1);
$this->pdf->SetFillColor(255, 255, 255);
$this->pdf->SetFont('Arial', '', 10);
$this->pdf->SetTextColor(43, 51, 43);
$this->pdf->MultiCell(150, 6, utf8_decode($PrtAufgabe->auf_beschreibung), 0, 1);
$this->pdf->SetDrawColor(217, 0, 0);
$this->pdf->Cell(90, 5, ' Wer', 'B', 0);
$this->pdf->Cell(30, 5, ' Bis', 'B', 0);
$this->pdf->Cell(30, 5, ' Erledigt', 'B', 1);
$this->pdf->Cell(90, 8, " " . utf8_decode(OrganisationRecord::finder()->findByPk($PrtAufgabe->idtm_organisation)->org_name), 0, 0);
$this->pdf->Cell(30, 8, $PrtAufgabe->auf_tdate, 0, 0);
$this->pdf->Cell(30, 8, $PrtAufgabe->auf_done == 1 ? $PrtAufgabe->auf_ddate : '-', 0, 1);
}
$SubSQL = "";
}
}
}
private function bindActivityProtokollListe($idtm_activity)
{
if ($this->CCProtokollDetailGroupListPageSize->Text <= 1 and $this->CCProtokollDetailGroupListPageSize->Text != '') {
$this->ActivityProtokollListe->PageSize = 5;
} else {
$this->ActivityProtokollListe->PageSize = 1 * $this->CCProtokollDetailGroupListPageSize->Text;
}
$SKNode = $idtm_activity >= 1 ? $idtm_activity : $this->UserStartId;
$sqlall = "SELECT idtm_protokoll_detail FROM vv_protokoll_detail_aufgabe";
$sqlcount = "SELECT count(idtm_protokoll_detail) AS idtm_protokoll_detail FROM vv_protokoll_detail_aufgabe";
$sql = " WHERE (act_lft BETWEEN " . ActivityRecord::finder()->findByPK($SKNode)->act_lft . " AND " . ActivityRecord::finder()->findByPK($SKNode)->act_rgt . ")";
if ($this->CBAufgabeDone->Text == 0 and $this->CBAufgabeDone->Text != '') {
$sql .= " AND (auf_done = " . $this->CBAufgabeDone->Text . " AND idta_protokoll_ergebnistype<3)";
}
if ($this->CBAufgabeDone->Text == 1 and $this->CBAufgabeDone->Text != '') {
$sql .= " AND (auf_done = " . $this->CBAufgabeDone->Text . " OR idta_protokoll_ergebnistype>2)";
}
if ($this->CBidta_organisation_art->Text >= 0 and $this->CBidta_organisation_art->Text != '') {
$sql .= " AND (idta_organisation_art = " . $this->CBidta_organisation_art->Text . ")";
}
$this->ActivityProtokollListe->VirtualItemCount = ProtokollDetailView::finder()->findBySQL($sqlcount . $sql)->idtm_protokoll_detail;
$sql .= " ORDER BY prtdet_cdate DESC";
$sql .= " LIMIT " . $this->ActivityProtokollListe->CurrentPageIndex * $this->ActivityProtokollListe->PageSize . ", " . $this->ActivityProtokollListe->PageSize;
$exeSQL = "SELECT * FROM vv_protokoll_detail WHERE idtm_protokoll_detail IN (" . $sqlall . $sql . ") LIMIT " . $this->ActivityProtokollListe->CurrentPageIndex * $this->ActivityProtokollListe->PageSize . ", " . $this->ActivityProtokollListe->PageSize;
$this->ActivityProtokollListe->DataSource = ProtokollDetailView::finder()->findAllBySQL($exeSQL);
$this->ActivityProtokollListe->dataBind();
}
public function load_prtdetailsEdit($sender, $param)
{
$criteria = new TActiveRecordCriteria();
$criteria->Condition = "idtm_protokoll_detail_group = :suchtext";
$criteria->Parameters[':suchtext'] = $param->CommandParameter;
$criteria->OrdersBy['idtm_protokoll_detail'] = 'DESC';
$sender->DataSource = ProtokollDetailView::finder()->findAll($criteria);
$sender->dataBind();
}
