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); }