public function index()
{
$userDB = M('user');
$counts = $userDB->count();
$Page = new \Think\VshowPage($counts, 10);
$show = $Page->show();
$userList = $userDB->field('id,username,truename,last_login,last_ip')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign('page', $show);
$this->assign('userList', $userList);
$this->display();
}
public function getWorkList()
{
// 根据用户的选择，动态获取分页排序
$type = I('post.t');
$sort = I('post.s');
$page = I('post.p');
$_GET['p'] = $page;
$sortMap = array('sort-new' => 'works_pubtime', 'sort-hot' => 'click_counts', 'sort-col' => 'collect_counts', 'sort-prc' => 'praise_counts');
$worksDB = M('works');
$counts = $worksDB->where(array('is_delete' => 0))->count();
$Page = new \Think\VshowPage($counts, 8);
$show = $Page->show();
$fieldStr = 'w.id,works_name,works_author,works_pubtime,works_image,avater_path,';
$fieldStr .= 'praise_counts,collect_counts,comment_counts,click_counts';
$jointoCounts = 'vs_works_counts as c on w.id = c.works_id';
$jointoUser = '******';
$allWorkList = $worksDB->alias('w')->where(array('is_delete' => 0))->field($fieldStr)->join($jointoCounts)->join($jointoUser)->limit($Page->firstRow . ',' . $Page->listRows)->order($sortMap[$sort] . ' DESC')->select();
$this->ajaxReturn($allWorkList);
}
