[ASK]

ASK YII2[SOLVED]

master ane nubi mau nanya ni…

Ceritanya ane buat chart penjualan…

tapi ga bener2…

kriteria yg ane butuhin yaitu Menampilkan Jumlah total berat gram per tanggal.

<?php

$sql = "SELECT no_bon,tgl,berat_gram, (select sum(berat_gram) from jual where no_bon ) as total from jual"; [color="#FF0000"]<- disini ane butuh distinct tapi ga fungsi / salah kodingnya kali ya ?.[/color]

$rawData = Yii::$app->db->createCommand($sql)->queryAll();

$rawData = \backend\models\Jual::find($sql)->select(‘tgl’)->orderBy([‘tgl’ => SORT_ASC])->distinct()->all(); [color="#FF0000"]<- pake ini distinct nya work tp bingung cara sum berat gram per tanggalnya.[/color]

$main_data = [];

foreach ($rawData as $data) {

&#036;main_data[] = [


    'name' =&gt; &#036;data['tgl'],


    'y' =&gt;&#036;data['total'] *1,


    'drilldown' =&gt; &#036;data['no_bon']


];

}

$main = json_encode($main_data);

$sql = "SELECT no_bon,tgl,berat_gram, (select sum(berat_gram) from jual where no_bon ) as total from jual";

$rawData = Yii::$app->db->createCommand($sql)->queryAll();

$rawData = \backend\models\Jual::find($sql)->select(‘tgl’)->orderBy([‘tgl’ => SORT_ASC])->distinct()->all();

$sub_data = [];

foreach ($rawData as $data) {

&#036;sub_data[] = [


    'id' =&gt; &#036;data['no_bon'],


    'name' =&gt; ['Total'],


    'data' =&gt;[&#036;data['total'] *1]


];

}

$sub = json_encode($sub_data);

?>

<?php

Tolong Bantuannya Master.