Exemplos de app\models data_log_barang::join em PHP

Exemplo n.º 1

Arquivo: LapranSubGudangController.php Projeto: pedangkayu/rsos-git

 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);
 }