coolmee11
(Coolmee11)
January 5, 2014, 6:11am
1
saya udh berhasil menambahkan filter rentang tanggal pada cgridview dan berhasil, tapi saat export ke excel datanya ikut semuanya, seharusnya yg ke export itu cuman data yang ke filter tadi.
master2 ada yg bisa bantu saya nggak??
ini model, controller & viewnya:
[color=#000000]<<konfirmasipembayaran>> model[/color]
[color=#000000] [/color]
[color=#000000]public function search() {[/color]
[color=#000000] // Warning: Please modify the following code to remove attributes that[/color]
[color=#000000] // should not be searched.[/color]
[color=#000000] [/color]
[color=#000000] $criteria = new CDbCriteria;[/color]
[color=#000000] [/color]
[color=#000000] $criteria->compare(‘id_konfirmasi’, $this->id_konfirmasi);[/color]
[color=#000000] $criteria->compare(‘id_pembeli’, $this->id_pembeli, true);[/color]
[color=#000000] $criteria->compare(‘no_faktur’, $this->no_faktur, true);[/color]
[color=#000000] $criteria->compare(‘jenis_pembayaran’, $this->jenis_pembayaran, true);[/color]
[color=#000000] $criteria->compare(‘id_rek_tujuan’, $this->id_rek_tujuan);[/color]
[color=#000000] $criteria->compare(‘jumlah’, $this->jumlah);[/color]
[color=#000000] $criteria->compare(‘tanggal’, $this->tanggal, true);[/color]
[color=#000000] $criteria->compare(‘kode_validasi’, $this->kode_validasi, true);[/color]
[color=#000000] $criteria->compare(‘pemegang_rek’, $this->pemegang_rek, true);[/color]
[color=#000000] $criteria->compare(‘no_rek’, $this->no_rek, true);[/color]
[color=#000000] [/color]
[color=#000000] if(!empty($this->from_date) && empty($this->to_date))[/color]
[color=#000000] {[/color]
[color=#000000] $criteria->condition = “tanggal >= ‘$this->from_date’”; // date is database date column field[/color]
[color=#000000] }elseif(!empty($this->to_date) && empty($this->from_date))[/color]
[color=#000000] {[/color]
[color=#000000] $criteria->condition = “tanggal <= ‘$this->to_date’”;[/color]
[color=#000000] }elseif(!empty($this->to_date) && !empty($this->from_date))[/color]
[color=#000000] {[/color]
[color=#000000] $criteria->condition = “tanggal >= ‘$this->from_date’ and tanggal <= ‘$this->to_date’”;[/color]
[color=#000000] }[/color]
[color=#000000] [/color]
[color=#000000] return new CActiveDataProvider($this, array([/color]
[color=#000000] ‘criteria’ => $criteria,[/color]
[color=#000000] ));[/color]
[color=#000000] }[/color]
[color=#000000] [/color]
[color=#000000]<<konfirmasipembayarancontroller>>[/color]
[color=#000000] [/color]
[color=#000000]public function actionFilter()[/color]
[color=#000000] {[/color]
[color=#000000] $model=new KonfirmasiPembayaran(‘search’);[/color]
[color=#000000] $model->unsetAttributes(); // clear any default values[/color]
[color=#000000] if(isset($_GET[‘KonfirmasiPembayaran’]))[/color]
[color=#000000] $model->attributes=$_GET[‘KonfirmasiPembayaran’];[/color]
[color=#000000] [/color]
[color=#000000] unset(Yii::app()->request->cookies[‘from_date’]); // first unset cookie for dates[/color]
[color=#000000] unset(Yii::app()->request->cookies[‘to_date’]);[/color]
[color=#000000] [/color]
[color=#000000] if(!empty($_POST))[/color]
[color=#000000] {[/color]
[color=#000000] Yii::app()->request->cookies[‘from_date’] = new CHttpCookie(‘from_date’, $_POST[‘from_date’]); // define cookie for from_date[/color]
[color=#000000] Yii::app()->request->cookies[‘to_date’] = new CHttpCookie(‘to_date’, $_POST[‘to_date’]);[/color]
[color=#000000] $model->from_date = $_POST[‘from_date’];[/color]
[color=#000000] $model->to_date = $_POST[‘to_date’];[/color]
[color=#000000] }[/color]
[color=#000000] [/color]
[color=#000000] $this->render(‘filter’,array([/color]
[color=#000000] ‘model’=>$model,[/color]
[color=#000000] ));[/color]
[color=#000000] }[/color]
[color=#000000] [/color]
[color=#000000] public function actionExportExcel()[/color]
[color=#000000] {[/color]
[color=#000000] $model = new KonfirmasiPembayaran();[/color]
[color=#000000] $model->attributes = $_POST[‘konfirmasipembayaran’];[/color]
[color=#000000] [/color]
[color=#000000] if(isset($_POST[‘KonfirmasiPembayaran’]))[/color]
[color=#000000] $model->attributes=$_POST[‘KonfirmasiPembayaran’];[/color]
[color=#000000] [/color]
[color=#000000] if(!empty($_POST))[/color]
[color=#000000] {[/color]
[color=#000000] Yii::app()->request->cookies[‘from_date’] = new CHttpCookie(‘from_date’, $_POST[‘from_date’]); // define cookie for from_date[/color]
[color=#000000] Yii::app()->request->cookies[‘to_date’] = new CHttpCookie(‘to_date’, $_POST[‘to_date’]);[/color]
[color=#000000] $model->from_date = $_POST[‘from_date’];[/color]
[color=#000000] $model->to_date = $_POST[‘to_date’];[/color]
[color=#000000] }[/color]
[color=#000000] [/color]
[color=#000000] $this->widget(‘ext.EExcelView’, array([/color]
[color=#000000] ‘title’=>‘Report’,[/color]
[color=#000000] ‘dataProvider’ => $model->search(),[/color]
[color=#000000] ‘filter’=>$model,[/color]
[color=#000000] ‘grid_mode’=>‘export’,[/color]
[color=#000000] ‘columns’ => array([/color]
[color=#000000] ‘id_konfirmasi’,[/color]
[color=#000000] ‘id_pembeli’,[/color]
[color=#000000] ‘no_faktur’,[/color]
[color=#000000] ‘jenis_pembayaran’,[/color]
[color=#000000] ‘jumlah’,[/color]
[color=#000000] ‘tanggal’,[/color]
[color=#000000] ‘pemegang_rek’,[/color]
[color=#000000] [/color]
[color=#000000] [/color]
[color=#000000] ),[/color]
[color=#000000] ));[/color]
[color=#000000] }[/color]
[color=#000000] [/color]
[color=#000000]<<filter>> view[/color]
[color=#000000] [/color]
[color=#000000]<?php [/color]
[color=#000000][color=#666666]/* @var $this KonfirmasiPembayaranController */ [/color][/color]
[color=#000000][color=#666666]/* @var $model KonfirmasiPembayaran */ [/color][/color]
[color=#000000] [/color]
[color=#000000][color=#000088]$this[/color][color=#339933]->[/color][color=#004000]breadcrumbs[/color][color=#339933]=[/color][color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘Konfirmasi Pembayarans’[/color][color=#339933]=>[/color][color=#990000]array[/color]color=#009900 [/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘Manage’[/color][color=#339933],[/color][/color]
[color=#000000][color=#009900])[/color][color=#339933];[/color][/color]
[color=#000000] [/color]
[color=#000000][color=#000088]$this[/color][color=#339933]->[/color][color=#004000]menu[/color][color=#339933]=[/color][color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#990000]array[/color][color=#009900]([/color][color=#0000FF]‘label’[/color][color=#339933]=>[/color][color=#0000FF]‘List KonfirmasiPembayaran’[/color][color=#339933],[/color] [color=#0000FF]‘url’[/color][color=#339933]=>[/color][color=#990000]array[/color]color=#009900 [/color][color=#009900])[/color][color=#339933],[/color][/color]
[color=#000000] [color=#990000]array[/color][color=#009900]([/color][color=#0000FF]‘label’[/color][color=#339933]=>[/color][color=#0000FF]‘Create KonfirmasiPembayaran’[/color][color=#339933],[/color] [color=#0000FF]‘url’[/color][color=#339933]=>[/color][color=#990000]array[/color]color=#009900 [/color][color=#009900])[/color][color=#339933],[/color][/color]
[color=#000000][color=#009900])[/color][color=#339933];[/color][/color]
[color=#000000] [/color]
[color=#000000]Yii[color=#339933]::[/color][color=#004000]app[/color]color=#009900 [/color][color=#339933]->[/color][color=#004000]clientScript[/color][color=#339933]->[/color][color=#004000]registerScript[/color][color=#009900]([/color][color=#0000FF]‘search’[/color][color=#339933],[/color] [color=#0000FF]"[/color][/color]
[color=#000000][color=#0000FF]$(’.search-button’).click(function(){[/color][/color]
[color=#000000][color=#0000FF] $(’.search-form’).toggle();[/color][/color]
[color=#000000][color=#0000FF] return false;[/color][/color]
[color=#000000][color=#0000FF]});[/color][/color]
[color=#000000][color=#0000FF]$(’.search-form form’).submit(function(){[/color][/color]
[color=#000000][color=#0000FF] $.fn.yiiGridView.update(‘konfirmasi-pembayaran-grid’, {[/color][/color]
[color=#000000][color=#0000FF] data: $(this).serialize()[/color][/color]
[color=#000000][color=#0000FF] });[/color][/color]
[color=#000000][color=#0000FF] return false;[/color][/color]
[color=#000000][color=#0000FF]});[/color][/color]
[color=#000000][color=#0000FF]"[/color][color=#009900])[/color][color=#339933];[/color][/color]
[color=#000000]?> [/color]
[color=#000000] [/color]
[color=#000000]<h1>Report Konfirmasi Pembayaran</h1>[/color]
[color=#000000] [/color]
[color=#000000]<?php [color=#666666]//echo CHtml::beginForm(array(‘konfirmasipembayaran/exportexcel’)); ?> [/color][/color]
[color=#000000] [/color]
[color=#000000]<?php [color=#000088]$form[/color][color=#339933]=[/color][color=#000088]$this[/color][color=#339933]->[/color][color=#004000]beginWidget[/color][color=#009900]([/color][color=#0000FF]‘CActiveForm’[/color][color=#339933],[/color] [color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘id’[/color][color=#339933]=>[/color][color=#0000FF]‘page-form’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘enableAjaxValidation’[/color][color=#339933]=>[/color][color=#009900]true [/color][color=#339933],[/color][/color]
[color=#000000][color=#009900])[/color][color=#009900])[/color][color=#339933];[/color] ?> [/color]
[color=#000000] [/color]
[color=#000000]<b>From :</b>[/color]
[color=#000000]<?php [/color]
[color=#000000][color=#000088]$this[/color][color=#339933]->[/color][color=#004000]widget[/color][color=#009900]([/color][color=#0000FF]‘zii.widgets.jui.CJuiDatePicker’[/color][color=#339933],[/color] [color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘name’[/color][color=#339933]=>[/color][color=#0000FF]‘from_date’[/color][color=#339933],[/color] [color=#666666]// name of post parameter [/color][/color]
[color=#000000] [color=#0000FF]‘value’[/color][color=#339933]=>[/color]Yii[color=#339933]::[/color][color=#004000]app[/color]color=#009900 [/color][color=#339933]->[/color][color=#004000]request[/color][color=#339933]->[/color][color=#004000]cookies[/color][color=#009900][[/color][color=#0000FF]‘from_date’[/color][color=#009900]][/color][color=#339933]->[/color][color=#004000]value[/color][color=#339933],[/color] [color=#666666]// value comes from cookie after submittion [/color][/color]
[color=#000000] [color=#0000FF]‘options’[/color][color=#339933]=>[/color][color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘showAnim’[/color][color=#339933]=>[/color][color=#0000FF]‘fold’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘dateFormat’[/color][color=#339933]=>[/color][color=#0000FF]‘yy-mm-dd’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#009900])[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘htmlOptions’[/color][color=#339933]=>[/color][color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘style’[/color][color=#339933]=>[/color][color=#0000FF]‘height:20px;’[/color][/color]
[color=#000000] [color=#009900])[/color][color=#339933],[/color][/color]
[color=#000000][color=#009900])[/color][color=#009900])[/color][color=#339933];[/color][/color]
[color=#000000]?> [/color]
[color=#000000]<b>To :</b>[/color]
[color=#000000]<?php [/color]
[color=#000000][color=#000088]$this[/color][color=#339933]->[/color][color=#004000]widget[/color][color=#009900]([/color][color=#0000FF]‘zii.widgets.jui.CJuiDatePicker’[/color][color=#339933],[/color] [color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘name’[/color][color=#339933]=>[/color][color=#0000FF]‘to_date’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘value’[/color][color=#339933]=>[/color]Yii[color=#339933]::[/color][color=#004000]app[/color]color=#009900 [/color][color=#339933]->[/color][color=#004000]request[/color][color=#339933]->[/color][color=#004000]cookies[/color][color=#009900][[/color][color=#0000FF]‘to_date’[/color][color=#009900]][/color][color=#339933]->[/color][color=#004000]value[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘options’[/color][color=#339933]=>[/color][color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘showAnim’[/color][color=#339933]=>[/color][color=#0000FF]‘fold’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘dateFormat’[/color][color=#339933]=>[/color][color=#0000FF]‘yy-mm-dd’[/color][color=#339933],[/color][/color]
[color=#000000] [/color]
[color=#000000] [color=#009900])[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘htmlOptions’[/color][color=#339933]=>[/color][color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘style’[/color][color=#339933]=>[/color][color=#0000FF]‘height:20px;’[/color][/color]
[color=#000000] [color=#009900])[/color][color=#339933],[/color][/color]
[color=#000000][color=#009900])[/color][color=#009900])[/color][color=#339933];[/color][/color]
[color=#000000]?> [/color]
[color=#000000]<?php [color=#B1B100]echo[/color] CHtml[color=#339933]::[/color][color=#004000]submitButton[/color]color=#009900 [/color][color=#339933];[/color] ?> [/color]
[color=#000000]<?php [color=#000088]$this[/color][color=#339933]->[/color][color=#004000]endWidget[/color]color=#009900 [/color][color=#339933];[/color] ?> [/color]
[color=#000000] [/color]
[color=#000000]<?php [color=#B1B100]echo[/color] CHtml[color=#339933]::[/color][color=#004000]beginForm[/color]color=#009900 [/color][color=#339933];[/color] ?> [/color]
[color=#000000] [/color]
[color=#000000]<?php [color=#000088]$this[/color][color=#339933]->[/color][color=#004000]widget[/color][color=#009900]([/color][color=#0000FF]‘zii.widgets.grid.CGridView’[/color][color=#339933],[/color] [color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘id’[/color][color=#339933]=>[/color][color=#0000FF]‘konfirmasi-pembayaran-grid’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘dataProvider’[/color][color=#339933]=>[/color][color=#000088]$model[/color][color=#339933]->[/color][color=#004000]search[/color]color=#009900 [/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘filter’[/color][color=#339933]=>[/color][color=#000088]$model[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘columns’[/color] [color=#339933]=>[/color] [color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘id_konfirmasi’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘id_pembeli’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘no_faktur’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘jenis_pembayaran’[/color][color=#339933],[/color][/color]
[color=#000000][color=#666666]// ‘id_rek_tujuan’, [/color][/color]
[color=#000000] [color=#0000FF]‘jumlah’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘tanggal’[/color][color=#339933],[/color][/color]
[color=#000000][color=#666666]// ‘kode_validasi’, [/color][/color]
[color=#000000] [color=#0000FF]‘pemegang_rek’[/color][color=#339933],[/color][/color]
[color=#000000][color=#666666]// ‘no_rek’, [/color][/color]
[color=#000000] [color=#990000]array[/color][color=#009900]([/color][/color]
[color=#000000] [color=#0000FF]‘header’[/color][color=#339933]=>[/color][color=#0000FF]‘Status’[/color][color=#339933],[/color][/color]
[color=#000000] [color=#0000FF]‘value’[/color][color=#339933]=>[/color][color=#0000FF]’$data->statusnya’[/color][/color]
[color=#000000] [color=#009900])[/color][color=#339933],[/color][/color]
[color=#000000] [color=#009900])[/color][color=#339933],[/color][/color]
[color=#000000][color=#009900])[/color][color=#009900])[/color][color=#339933];[/color] ?> [/color]
[color=#000000] [/color]
[color=#000000]<?php [color=#B1B100]echo[/color] CHtml[color=#339933]::[/color][color=#004000]submitButton[/color]color=#009900 [/color][color=#339933];[/color] ?> [/color]
[color=#000000]<?php [color=#B1B100]echo[/color] CHtml[color=#339933]::[/color][color=#004000]endForm[/color]color=#009900 [/color][color=#339933];[/color] ?> [/color]