langsung saja ya gan ane mau pke tcpdf tapi dengan query sql caranya gmna ya gan, coding ane kaya gini
public function actionDownloadPdf()
{
$session=new CHttpSession;
$session->open();
Yii::import('application.extensions.vena.*');
require_once('tcpdf/tcpdf.php');
require_once('tcpdf/config/lang/ind.php');
if(isset($session['Kondisibarang_records']))
{
$model=$session['Kondisibarang_records'];
}
else/*
$model = Kondisibarang::model()->findAll();
$html = $this->renderPartial('downloadpdf', array(
'model'=>$model
), true);
*/
$sql="SELECT t.*, s.namakondisi, c.nomorunit, b.namabarang, d.namaunit FROM kondisibarang AS t, kondisi as s, individubarang as a, barang as b, mengolahindividu as c, unit as d
WHERE t.idindividubarang=a.idindividu and c.nomorunit=d.nomorunit and a.idindividu=c.idindividu and a.idbarang=b.idbarang and s.idkondisi=t.idkondisi and t.tanggal=(SELECT MAX (tanggal) FROM kondisibarang
WHERE kondisibarang.idindividubarang = t.idindividubarang)";
$dataProvider=new CSqlDataProvider($sql);
//die($html);
$html = $this->renderPartial('downloadpdf', array(
'dataProvider'=>$dataProvider
), true);
$pdf = new TCPDF();
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(Yii::app()->name);
$pdf->SetTitle('Kondisi Barang Report');
$pdf->SetSubject('Kondisi Barang Report');
//$pdf->SetKeywords('example, text, report');
$pdf->SetHeaderData('', 0, "Report", '');
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, "Laporan: ".Yii::app()->name, "");
$pdf->setHeaderFont(Array('helvetica', '', <img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='8)' />);
$pdf->setFooterFont(Array('helvetica', '', 6));
$pdf->SetMargins(15, 18, 15);
$pdf->SetHeaderMargin(5);
$pdf->SetFooterMargin(10);
$pdf->SetAutoPageBreak(TRUE, 0);
$pdf->SetFont('dejavusans', '', 7);
$pdf->AddPage();
$pdf->writeHTML($html, true, false, true, false, '');
$pdf->LastPage();
$pdf->Output("Kondisi.pdf", "I");
}