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);
//生成表管理类
