public function search($params) { $id = isset($_GET['id']) ? $_GET['id'] : ""; $id_bank = isset($_GET['id_bank']) ? $_GET['id_bank'] : ''; $query = BankPool::find(); if (!isset($params['sort'])) { $query->orderBy(['created_at' => SORT_DESC]); } $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pagesize' => '10']]); $this->load($params); if (!$this->validate()) { return $dataProvider; } if ($id) { $query->andFilterWhere(["bank_pool.id_pool" => $id]); if (isset($params['BankPoolSearch']['id_bank'])) { $id_bank = bank::find()->where(["bank_id" => $params['BankPoolSearch']['id_bank']])->one()->id_bank; } } if ($id_bank) { $query->andFilterWhere(["bank.id_bank" => $id_bank]); if (isset($params['BankPoolSearch']['id_pool'])) { $id = pool::find()->where(["pool_id" => $params['BankPoolSearch']['id_pool']])->one()->id_pool; $query->andFilterWhere(["bank_pool.id_pool" => $id]); } } $query->select('bank.bank_id,pool.pool_id,bank_pool.*')->join("LEFT JOIN", 'bank', "bank.id_bank=bank_pool.id_bank")->join("LEFT JOIN", 'pool', "pool.id_pool=bank_pool.id_pool")->all(); return $dataProvider; }
public function actionIndex() { $id = isset($_GET['id']) ? $_GET['id'] : null; $id_bank = isset($_GET['id_bank']) ? $_GET['id_bank'] : null; $model = new BankPool(); $searchModel = new BankPoolSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $k = pool::find()->where(["id_pool" => $id])->one(); $b = bank::find()->where(["id_bank" => $id_bank])->one(); return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model, 'id' => $id, 'id_bank' => $id_bank, 'pool_id' => $k['pool_id'], 'bank' => $b['name']]); }
?> </a> </div> <?php } ?> <?php if (isset($id_bank) && $id_bank != '') { ?> <input type="hidden" value="<?php echo $id_bank; ?> " name="BankPool[id_bank]"> <?php echo $form->field($model, 'id_pool', ['options' => ['class' => 'col-xs-3', "id" => "id_extend"]])->dropDownList(ArrayHelper::map(pool::find()->all(), "id_pool", "pool_id"), ['maxlength' => true])->label('Pool ID'); ?> <div class="form-group" > <div class="col-sm-2" style="padding-left: 15px;padding-top:27px"> <a href="index.php?r=pool/create" target="_blank"><?php echo $m = Html::Button("NEW POOL", ['class' => 'btn btn-success']); ?> </a> </div> <?php } ?> <?php echo $form->field($model, 'funding_amount', ['options' => ['class' => 'col-xs-6']]); ?>