/** * Lists all Barang models. * @return mixed */ public function actionIndex() { $searchModel = new BarangSearch(); $dataProvider = $searchModel->searchBaranunkwon(Yii::$app->request->queryParams); $model = new Barang(); $querys = Barang::find()->from('dbc002.b0001 AS db1')->leftJoin('dbc002.b1001 AS db2', 'db1.KD_BARANG = db2.KD_TYPE')->where(['NM_TYPE' => 'FDSFDG'])->all(); /* var_dump($querys); $query= new Query; $query->select('*') ->from('dbc002.b0001 AS db1') ->leftJoin('dbm000.b1001 AS db2', 'db1.KD_BARANG = db2.KD_TYPE') ->where(['db2.NM_TYPE' =>'FDSFDG']); $command = $query->createCommand(); $resp = $command->queryAll(); */ /* select * from dbc002.b0001 AS db1 LEFT JOIN dbm000.b1001 AS db2 on db1.KD_BARANG = db2.KD_TYPE WHERE db2.NM_TYPE = 'FDSFDG' $querys = Barang::find()->with('tbesm')->where(['tbesm.NM_TYPE' => 'FDSFDG'])->asArray()->all(); */ /*Tambahal menu side Dinamik */ $sideMenu_control = 'umum_datamaster'; return $this->render('index', ['sideMenu_control' => $sideMenu_control, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'querys' => $querys]); }