static function init(pool $pool, $url) { $r = new request($url); $r->pool = $pool; $pool->attach($r); return $r; }
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']]); ?>
protected function getDb() { $db = pool::db($this->dbKey, $this->hash); $db->table($this->table, $this->fields); return $this->db = $db; }
foreach ($priAddr as $_addr) { list($start, $end) = explode('|', $_addr); // IF IS PRIVATE if ($longIp >= ip2long($start) && $longIp <= ip2long($end)) { return true; } } } return false; } //检查是否在客户端是否是内网ip //isPrivateIp($_SERVER['REMOTE_ADDR']) || exit('forbbidden'); include_once '../include/config.php'; $dsnName = get($_GET, 'dsn', 'db'); $table = get($_GET, 'table'); $db = pool::db($dsnName); if ('generate' == get($_GET, 'act')) { /** 生成校验函数内字符串 */ foreach ($db->query('show full COLUMNS from ' . $table) as $row) { $type = strpos($row['Type'], '(') !== false ? substr($row['Type'], 0, strpos($row['Type'], '(')) : $row['Type']; $emptyV = $row['Default'] != null ? "'" . $row['Default'] . "'" : (in_array($type, array('tinyint', 'smallint', 'mediumint', 'int', 'bigint', 'decimal', 'float', 'double', 'enum')) ? 'null' : "''"); $checkData .= sprintf("\r\n\t\tcase '%s':\r\n\t\t\t\$arr[\$k]=empty(\$v)?%s:\$v;\r\n\t\tbreak;", $row['Field'], $emptyV); } // 生成基本类 $fields = implode(',', util::quote(array_keys($_POST['field']))); $ds_table = str_replace('_', '/', $table); $mod = SYS_PATH . 'include/' . $ds_table . '.php'; $str = file_get_contents(SYS_PATH . 'tools/code/include.php'); $str = str_replace(array('__dsnName__', '__table__', '__ds_table__', '__fields__', '__checkData__'), array($dsnName, $table, $ds_table, $fields, $checkData), $str, $checkData); file::save($mod, $str); //生成表管理类