I have table
CREATE TABLE pay_slip
(
empID
int(11) NOT NULL,
genreID
int(11) NOT NULL,
datepay
date NOT NULL,
total
float(8,2) DEFAULT NULL,
PRIMARY KEY (empID
,genreID
,datepay
),
[size="1"] KEY fk_pay_employee_has_pay_genre_pay_genre1
(genreID
),
KEY fk_pay_employee_has_pay_genre_pay_employee
(empID
),
…
…
[/size]) ENGINE=InnoDB DEFAULT CHARSET=utf8
i use CListView for show data (data it show).
<?php
$this->widget('zii.widgets.CListView', array(
'dataProvider'=>$dataProvider,
'itemView'=>'_viewSlip',
'template'=>'{sorter} {items} <hr/> {pager}'
));
?>
i have 2 group (from table genre) in dataProvider. (Revenue and expenditure).
but i want to show detail and summary Revenue, expenditure in payinslip per mount.
help me please.