/** * Lists all Barang models. * @return mixed */ public function actionIndex() { $searchModel = new BarangSearch(); $dataProvider = $searchModel->searchBarangUmum(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(); */ return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'querys' => $querys]); }