$pdf->Text(230 / 2 - $pdf->GetStringWidth('Lippo Mall Kemang') / 2, 26, 'Lippo Mall Kemang'); $pdf->SetFont('Times', '', 12); $pdf->Text(230 / 2 - $pdf->GetStringWidth('Jl. Pangeran Antasari 36 Jakarta Selatan - 12150') / 2, 33, 'Jl. Pangeran Antasari 36 Jakarta Selatan - 12150'); //$pdf->setDrawColor(105,102,102); $pdf->Line(10, 36, 210 - 5, 36); $pdf->SetFont('Arial', '', 22); $pdf->Text(230 / 2 - $pdf->GetStringWidth('Report Redeem Point') / 2, 45, 'Report Redeem Point'); $awal = date('d F Y', strtotime($tgl1)); $akhir = date('d F Y', strtotime($tgl2)); $periode = "{$awal} to {$akhir}"; $pdf->SetFont('Arial', '', 14); $pdf->Text(230 / 2 - $pdf->GetStringWidth($periode) / 2, 54, $periode); //$pdf->Line(10, 10, 210-10, 10); $pdf->SetXY(10, 60); $pdf->SetFont('Helvetica', '', 12); $content = Redeem::model()->with(array('member', 'user', 'detail_redeem'))->findAll(array('condition' => 'redeem_date BETWEEN :date1 AND :date2', 'order' => 't.id_member DESC', 'params' => array(':date1' => $tgl1, ':date2' => $tgl2))); if (is_null($content)) { $pdf->SetFont('Helvetica', '', 48); $pdf->Text(290 / 2 - $pdf->GetStringWidth("No Data Found") / 2, 84, "No Data Found"); $pdf->Output(); Yii::app()->end(); } $sql = "SELECT voucher.voucher_name,SUM(detail_redeem.voucher_number) as jumlah FROM\r\n\t redeem JOIN detail_redeem ON redeem.id_redeem = detail_redeem.id_redeem\r\n\t JOIN voucher ON voucher.id_voucher = detail_redeem.id_voucher WHERE redeem_date BETWEEN '" . $tgl1 . "' AND '" . $tgl2 . "'\r\n\t GROUP BY voucher.id_voucher ORDER BY jumlah DESC "; $results = Yii::app()->db->createCommand($sql)->queryAll(); $pdf->SetFont('Arial', '', 16); $text_color = '0,0,0'; $back_color = '255,255,255'; $pdf->Text(10, 70, 'Summary'); $pdf->Line(10, 72, 100, 72); $pdf->SetXY(10, 75); $columns = array();