static function table_list()
{
$table_alias = $table = self::$table = "et_user";
$table_alias = 'u';
$join = '';
if (empty($table_alias)) {
throw new ErrorException("table is not defined");
}
//$request = http_request("rows","page","sidx","sord");
$request = PtLib\http_request("rows", "page", "sidx", "sord", "mobile", "nick_name");
$limit = $request['rows'];
$page = $request['page'];
$sort = $request['sidx'];
$sort_type = $request['sord'];
//fields
$select_fields = " u.*";
if (empty($limit)) {
$limit = 20;
}
if (empty($page)) {
$page = 1;
}
if (empty($sort)) {
$sort = "id";
$sort_type = "desc";
} else {
if (empty($sort_type)) {
$sort_type = "desc";
}
}
//where
$args = array();
$where = " where 1=1 ";
if ($request['mobile']) {
$where .= " and u.mobile = ?";
$args[] = $request['mobile'];
}
if ($request['nick_name']) {
$where .= " and u.nick_name = ?";
$args[] = $request['nick_name'];
}
//order
$order = "";
if ($sort) {
$order = "order by {$table_alias}." . addslashes($sort) . " " . $sort_type;
}
$sql = "select count({$table_alias}.id) as total from {$table} as {$table_alias} {$join} {$where} ";
//$count_res = db()->select_row($sql,$args);
$count_res = PtLib\db()->select_row($sql, $args);
$records = $count_res['total'];
$response = new stdClass();
$response->page = $page;
//cur page
if ($records > 0) {
$total_pages = ceil($records / $limit);
} else {
$total_pages = 1;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$response->total = $total_pages;
//total pages
$response->records = $records;
//count
$skip = ($page - 1) * $limit;
$sql = "select {$select_fields} from {$table} as {$table_alias} {$join} {$where} {$order} limit {$skip},{$limit} ";
//$rows = db()->select_rows($sql,$args);
$rows = PtLib\db()->select_rows($sql, $args);
foreach ($rows as $row) {
$response->rows[] = array('id' => $row['id'], "cell" => $row);
}
return $response;
}
