salah satu cara menggunakan highchart di Yii cara menggunakan highchart di Yii, di controller $connection=Yii::app()->db; $sql = select distinct sono, (totaljual - totalbeli) as untung from ( select a.soheaderid, a.sono as sono, as pono, a.sodate as sodate,(a.amount*ratevalue) as totaljual,0 as totalbeli,b.fullname as customer, as supplier, c.fullname as employeename from soheader a inner join addressbook b on b.addressbookid = a.addressbookid left join employee c on c.employeeid = a.employeeid union select ff.soheaderid, gg.sono, ab.pono, ab.docdate,0,(select sum(poqty*netprice*ratevalue) from podetail zz where zz.poheaderid = ab.poheaderid),,bb.fullname, from poheader ab inner join addressbook bb on bb.addressbookid = ab.addressbookid inner join podetail cc on cc.poheaderid = ab.poheaderid inner join prmaterial dd on dd.prmaterialid = cc.prdetailid inner join deliveryadvicedetail ee on ee.deliveryadvicedetailid = dd.deliveryadvicedetailid inner join sodetail ff on ff.sodetailid = ee.sodetailid inner join soheader gg on gg.soheaderid = ff.soheaderid ) zzz ; if (isset($_GET[startperiod])) { $sql .= where lower(zzz.sono) like %.$_GET[sono].% and sodate between .$_GET[startperiod]. and .$_GET[endperiod]. and zzz.sono is not null; } $sql .= group by sono; $dataProvider=new CSqlDataProvider($sql,array( keyField => soheaderid, )); $this->render(index,array( dataProvider=>$dataProvider, )); } di view:
Posted on: Thu, 25 Sep 2014 04:47:33 +0000