how to use data (2 group) in dataProvider.

bungkhan · March 27, 2011, 11:27am

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).

	&lt;?php  


		&#036;this-&gt;widget('zii.widgets.CListView', array(


			'dataProvider'=&gt;&#036;dataProvider,


			'itemView'=&gt;'_viewSlip',    


		    'template'=&gt;'{sorter}  {items} &lt;hr/&gt; {pager}'


		));		


	?&gt;

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.

bungkhan · March 27, 2011, 3:39pm

Simple demo data

Revenue

Revenue1 1000

Revenue2 2000

Revenue3 3000

Total 6000

Expenditure

Expenditure 2000

Expenditure 3000

Expenditure 5000

Total 10000

thank alot

chriscao · November 4, 2011, 1:36am

I also want to know how to deal with it.