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']]);
}
<div class="bankuser-form">
<?php
$form = ActiveForm::begin();
?>
<?php
if (isset($id_pool) && $id_pool != '') {
?>
<input type="hidden" value="<?php
echo $id_pool;
?>
" name="BankPool[id_pool]">
<?php
echo $form->field($model, 'id_bank', ['options' => ['class' => 'col-xs-3', "id" => "id_extend"]])->dropDownList(ArrayHelper::map(bank::find()->all(), "id_bank", "bank_id"), ['maxlength' => true])->label('Bank ID');
?>
<div class="form-group" >
<div class="col-sm-2" style="padding-left: 15px;padding-top:27px">
<a href="index.php?r=bank/create" target="_blank"><?php
echo $m = Html::Button("NEW BANK", ['class' => 'btn btn-success']);
?>
</a>
</div>
<?php
}
?>
<?php
if (isset($id_bank) && $id_bank != '') {
?>
