Report Pdf Tcpdf

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");

	}

Mohon bantuannya nya

kenapa ga pake model langsung aja…

mksudnya dimodel itu bagaimana???

sudah saya coba dimodel menggunakan csqldataprovider saya panggil tidak mau, mohon bntuannta mastaaa