Custom Curd

Hi All i’am new in YII

i have table transaksi with field id, credit, debet

i was creat CURD table with gii, and i’ll show saldo in view with my query(i have query to do)

please help me to costom my model controller and view

thanks

you cab write the custom query on model search function

please see this

i hope it’s may be some help.

hi Maggie, thanks your answer

but i’ll custom mvc. field in my table id, credit, debet and i’ve query to show saldo like that and curd from gii for this table


SELECT t1.id as Id, t1.debet as Debet, t1.kecil_credit as Credit, 

	CASE WHEN t1.id<>t2.id 

		then @saldo:=debet-kecil_credit, etc




i’ll saldo in view, help me