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) {
$main_data[] = [
'name' => $data['tgl'],
'y' =>$data['total'] *1,
'drilldown' => $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) {
$sub_data[] = [
'id' => $data['no_bon'],
'name' => ['Total'],
'data' =>[$data['total'] *1]
];
}
$sub = json_encode($sub_data);
?>
<?php
Tolong Bantuannya Master.