Membuat report dalam bentuk pdf di yii

Buat Agan2 yg udah pernah bikin laporan kedalam bentuk pdf di yii tolong dong kasih tahu plugin apa yg digunakan, terus langkah-langkah penggunaannya…mohon bantuannya

wah kemaren juga nemu masalah ginian, meskipun bnyak plugin danextention… tapi akhirnya ane berhasil merombaknya menjadi excel, karena menghindari nulis cell atu-atu males gan… heheh…

ikut izin mantengin ya gan mana tahu ada yang kasih masukkan bagus…

Agan Aqge… La tutorialnya mana…Mohon di beri link nya…

terimkasih sebalumnya…!

gak punya gan… maksdunya waktu diminta bikin php ane menyakinkan kalo excel lebih baik gitu…

sorry gan…

coba dimmari gan


http://www.yiiframework.com/forum/index.php?/topic/8214-export-report-to-excel

http://www.yiiframework.com/forum/index.php?/topic/6647-yii-with-generating-and-printing-reports-charts-etc


public function actionDownload()

  {

	Yii::import('application.extensions.fpdf.*');

    require_once("pdf.php");

    $pdf = new PDF();

    $pdf->title='Absence Rule List';

    $pdf->AddPage('P');

    $pdf->setFont('Arial','B',12);


    // definisi font

    $pdf->setFont('Arial','B',<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='8)' />;


    // menuliskan tabel

    $header = array('No','ID','Schedule Name','Time In','Time Out');

    $model=new Absrule('searchwstatus');

    $dataprovider=$model->searchwstatus();

    $dataprovider->pagination=false;

    $data = $dataprovider->getData();

    //var_dump($dataku);

    $w= array(20,25,30,30,30);


    $pdf->SetTableHeader();

    //Header

    for($i=0;$i<count($header);$i++)

        $pdf->Cell($w[$i],7,$header[$i],1,0,'C',true);

    $pdf->Ln();

    $pdf->SetTableData();

    //Data

    $fill=false;

    $i=0;

    foreach($data as $datas)

    {

        $i=$i+1;

        $pdf->Cell($w[0],6,$i,'LR',0,'L',$fill);

        $pdf->Cell($w[1],6,$datas['absruleid'],'LR',0,'C',$fill);

        $pdf->Cell($w[2],6,Absschedule::model()->findByPk($datas['absscheduleid'])->absschedulename,'LR',0,'L',$fill);

        $pdf->Cell($w[3],6,$datas['difftimein'],'LR',0,'C',$fill);

        $pdf->Cell($w[4],6,$datas['difftimeout'],'LR',0,'C',$fill);

        $pdf->Ln();

        $fill=!$fill;

    }

    $pdf->Cell(array_sum($w),0,'','T');




    // me-render ke browser

    $pdf->Output('absencerule.pdf','D');

  }

Ini code punya ane gan…buat nampilin semua data,tapi ane bingung cara menampilkan data berdasarkan pencarian tertentu

Yii::import(‘application.vendors.*’);

	 require_once('Fpdf/fpdf.php');


 	 &#036;pdf = new FPDF();





 	// definisi halaman ‘L’ untuk Landcape dan ‘P’ untuk Potrait


 	&#036;pdf-&gt;AddPage('L');





 	// definisi font


 	&#036;pdf-&gt;setFont('Arial','B',15);





 	// menuliskan text ke page


	 &#036;pdf-&gt;Text(10,10,'DAFTAR DATA-DATA MARK TYPE INSURANCE ');  	 


 	// definisi font


 	&#036;pdf-&gt;setFont('Arial','B',<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='8)' />;





 	// menuliskan tabel


 


	 &#036;y_initial = 21;


     &#036;y_axis1 = 25;


     &#036;pdf-&gt;setFont('Arial','',<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='8)' />;


     &#036;pdf-&gt;setFillColor(233,233,233);


     &#036;pdf-&gt;setY(&#036;y_axis1);


     &#036;pdf-&gt;setX(10);


     &#036;pdf-&gt;cell(10,6,'NO',1,0,'C',1);


     &#036;pdf-&gt;cell(15,6,'ID',1,0,'C',1);


     &#036;pdf-&gt;cell(30,6,'Mark Type Insurance',1,0,'C',1);


     &#036;pdf-&gt;cell(58,6,'Insurance Name',1,0,'C',1);


     &#036;pdf-&gt;cell(40,6,'Mark Risk Category',1,0,'C',1);


     &#036;pdf-&gt;cell(35,6,'GlassCount',1,0,'C',1);


     &#036;pdf-&gt;cell(30,6,'Group CLosing',1,0,'C',1);


     &#036;pdf-&gt;cell(30,6,'Prorate',1,0,'C',1);


     &#036;pdf-&gt;cell(30,6,'Active',1,0,'C',1);


     &#036;pdf-&gt;Ln();


 


	 &#036;a=1;


	 &#036;n=0;


	 


	 //&#036;results = MarkRiskcategory::model()-&gt;findAll();


     //&#036;jumlah =count( &#036;results );


	 


	&#036;criteria = new CDbCriteria();


	&#036;criteria-&gt;order = &quot;id DESC&quot;;


	&#036;criteria-&gt;limit=1;


	&#036;jumlah = MarkTypeinsurance::model()-&gt;find(&#036;criteria);








	//&#036;ma=MarkRiskcategory::model()-&gt;findByPk(&#036;criteria);


	//&#036;pdf-&gt;cell(10,1,&#036;exemple-&gt;id,1,0,'C',1);


	


	 while (&#036;a&lt;=&#036;jumlah-&gt;id)


	 {	 	


		&#036;model=MarkTypeinsurance::model()-&gt;findByPk(&#036;a);


	     if(&#036;model-&gt;id&#33;='')


	     {


	     &#036;n=&#036;n+1;


	     &#036;pdf-&gt;SetDrawColor(0,80,180);


         &#036;pdf-&gt;SetFillColor(255,255,255);


         &#036;pdf-&gt;SetTextColor(0,0,0);


		 


		 		 


		 


		 &#036;pdf-&gt;cell(10,6,&#036;n,1,0,'C',1);


	     &#036;pdf-&gt;cell(15,6,&#036;model-&gt;id,1,0,'C',1);


	     &#036;pdf-&gt;cell(30,6,&#036;model-&gt;id_mark_typeinsurance,1,0,'C',1);


	     &#036;pdf-&gt;cell(58,6,&#036;model-&gt;insurance_name,1,0,'C',1);


	     //&#036;pdf-&gt;cell(35,6,&#036;model-&gt;mark_riskcategory_id,1,0,'C',1);


	     &#036;pdf-&gt;cell(40,6,markRiskcategory::model()-&gt;findByPk(&#036;model-&gt;mark_riskcategory_id)-&gt;categoryname,1,0,'C',1);


	     &#036;pdf-&gt;cell(35,6,&#036;model-&gt;glaccount,1,0,'C',1);


	     &#036;pdf-&gt;cell(30,6,&#036;model-&gt;group_closing,1,0,'C',1);


	     


		 //cek kondisi prorate


	     if(&#036;model-&gt;prorate==1)


		 {&#036;pro='Yes';}else{&#036;pro='No';}


	     &#036;pdf-&gt;cell(30,6,&#036;pro,1,0,'C',1);


	     


		 //cek kondisi Active


	     if(&#036;model-&gt;active==1)


		 {&#036;act='Yes';}else{&#036;act='No';}


		 &#036;pdf-&gt;cell(30,6,&#036;act,1,0,'C',1);


	     &#036;pdf-&gt;Ln();


	     


	     &#036;y = &#036;y_initial + &#036;row;


	     // me-render ke browser


	     }


	     &#036;a++;


     }


     //PRINT HASIL


     &#036;namafile = 'Mark Type Insurance.pdf';


	 &#036;tujuan = 'D'; // donlot


	 &#036;pdf-&gt;Output(&#036;namafile, &#036;tujuan);

@kendru, berarti udah bisa jalan kan? kalo gitu cm masalah query aja ya mas?

cari contoh2 query aja mas, misal





$model = new Rekening;

$cari = $model->findAllByAttributes(array('jenis'=>$jenis));



terus nanti foreach hasil $cari ditampilkan sesuai rancangan cell nya