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