public function getGrafik(Request $req) { $res = []; $loga = []; $logb = []; $ids = []; $logobat = data_log_barang::join('data_barang', 'data_barang.id_barang', '=', 'data_log_barang.id_barang')->where(DB::raw('MONTH(data_log_barang.created_at)'), date('m'))->where('data_log_barang.id_gudang', 0)->orderBy('total', 'DESC')->groupBy('data_log_barang.id_barang')->select('data_barang.id_barang', 'data_barang.nm_barang', DB::raw('count(data_log_barang.id_barang) as total'))->take(5)->get(); foreach ($logobat as $a) { $loga[] = ['obat' => $a->nm_barang, 'value' => $a->total]; $ids[] = $a->id_barang; } $res['obat'] = $loga; return json_encode($res); }