protected function _list($model, $map, $sortBy = '', $asc = false) { #var_dump($map);exit; $join = 'LEFT JOIN users u ON D.user_id=u.id'; //取得满足条件的记录数 $count = $model->alias('D')->join($join)->where($map)->count('D.id'); #echo $count;exit; if ($count > 0) { //创建分页对象 if (!empty($_REQUEST['numPerPage'])) { $listRows = $_REQUEST['numPerPage']; } else { $listRows = 10; } $p = new \Extcom\Lib\Page($count, $listRows); $p->setConfig('prev', '<span class="pageprev"></span>'); $p->setConfig('next', '<span class="pagenext"></span>'); // $currentPage = $_REQUEST['pageNum'] ? $_REQUEST['pageNum'] : 1; $currentPage = $_REQUEST['p'] ? $_REQUEST['p'] : 1; $p->firstRow = ($currentPage - 1) * $listRows; //分页查询数据 $voList = $model->alias('D')->field(array('company_name', 'company_license', 'D.mobile', 'D.status', 'contact', 'D.created', 'username', 'D.user_id', 'D.id'))->join($join)->where($map)->order('D.created desc')->limit($p->firstRow . ',' . $p->listRows)->select(); //模板赋值显示 $this->assign('list', $voList); $this->assign('page', $p->show()); return $voList; } return; }
protected function _list($model, $map, $sortBy = '', $asc = false) { $join = 'LEFT JOIN users u ON A.user_id=u.id'; //取得满足条件的记录数 $count = $model->alias('A')->join($join)->where($map)->count('A.id'); R('Com/getDevelopers'); if ($count > 0) { //创建分页对象 if (!empty($_REQUEST['numPerPage'])) { $listRows = $_REQUEST['numPerPage']; } else { $listRows = 10; } $p = new \Extcom\Lib\Page($count, $listRows); $p->setConfig('prev', '<span class="pageprev"></span>'); $p->setConfig('next', '<span class="pagenext"></span>'); // $currentPage = $_REQUEST['pageNum'] ? $_REQUEST['pageNum'] : 1; $currentPage = $_REQUEST['p'] ? $_REQUEST['p'] : 1; $p->firstRow = ($currentPage - 1) * $listRows; //分页查询数据 $voList = $model->alias('A')->field(array('A.id', 'A.name', 'A.status', 'app_key', 'app_id', 'username', "A.user_id", 'A.created'))->join($join)->where($map)->order('A.created desc')->limit($p->firstRow . ',' . $p->listRows)->select(); $developers = M('Developers'); foreach ($voList as $k => $vo) { $voList[$k]['company_name'] = $developers->where(array('user_id' => $vo['user_id']))->getField('company_name'); } #var_dump($voList);exit; //模板赋值显示 $this->assign('list', $voList); $this->assign('page', $p->show()); return $voList; } return; }
protected function _list($model, $map, $sortBy = '', $asc = false) { $join = ' LEFT JOIN pay_code P ON I.pay_code=P.pay_code LEFT JOIN applications A ON I.application_id=A.id LEFT JOIN developers D ON I.user_id=D.user_id LEFT JOIN users u ON I.user_id=u.id '; $map = $_REQUEST['status'] ? array('I.status' => array('eq', $_REQUEST['status'])) + $this->_filter('I') : $this->_filter('I'); //取得满足条件的记录数 $count = $model->alias('I')->join($join)->where($map)->group('I.id')->select(); $count = count($count); /*echo $count; echo $model->getlastSql();exit;*/ if ($count > 0) { //创建分页对象 if (!empty($_REQUEST['numPerPage'])) { $listRows = $_REQUEST['numPerPage']; } else { $listRows = 10; } $p = new \Extcom\Lib\Page($count, $listRows); $p->setConfig('prev', '<span class="pageprev"></span>'); $p->setConfig('next', '<span class="pagenext"></span>'); // $currentPage = $_REQUEST['pageNum'] ? $_REQUEST['pageNum'] : 1; $currentPage = $_REQUEST['p'] ? $_REQUEST['p'] : 1; $p->firstRow = ($currentPage - 1) * $listRows; //分页查询数据 $voList = $model->alias('I')->field(array('I.id', 'I.name', 'A.status', 'I.iap_key', 'I.pay_code', 'I.created', 'I.status', 'application_id', 'app_id', 'A.name AS app_name', 'D.company_name', 'u.username', 'P.fee'))->join($join)->where($map)->group('I.id')->order('I.created desc')->limit($p->firstRow . ',' . $p->listRows)->select(); //模板赋值显示 R('Com/getDevelopers'); $this->assign('list', $voList); $this->assign('page', $p->show()); #var_dump($voList);exit; return $voList; } R('Com/getDevelopers'); return; }
/** +---------------------------------------------------------- * 根据表单生成查询条件 * 进行列表过滤 +---------------------------------------------------------- * @access protected +---------------------------------------------------------- * @param Model $model 数据对象 * @param HashMap $map 过滤条件 * @param string $sortBy 排序 * @param boolean $asc 是否正序 +---------------------------------------------------------- * @return void +---------------------------------------------------------- * @throws ThinkExecption +---------------------------------------------------------- */ protected function _list($model, $map, $sortBy = '', $asc = false) { //排序字段 默认为主键名 if (!empty($_REQUEST['_order'])) { $order = $_REQUEST['_order']; } else { $order = !empty($sortBy) ? $sortBy : $model->getPk(); } //排序方式默认按照倒序排列 //接受 sost参数 0 表示倒序 非0都 表示正序 if (isset($_REQUEST['_sort'])) { $sort = $_REQUEST['_sort'] == 'asc' ? 'asc' : 'desc'; //zhanghuihua@msn.com } else { $sort = $asc ? 'desc' : 'asc'; } //取得满足条件的记录数 $count = $model->where($map)->count('id'); if ($count > 0) { //创建分页对象 if (!empty($_REQUEST['numPerPage'])) { $listRows = $_REQUEST['numPerPage']; } else { $listRows = 10; } $p = new \Extcom\Lib\Page($count, $listRows); $p->setConfig('prev', '<span class="pageprev"></span>'); $p->setConfig('next', '<span class="pagenext"></span>'); // $currentPage = $_REQUEST['pageNum'] ? $_REQUEST['pageNum'] : 1; $currentPage = isset($_REQUEST['p']) ? $_REQUEST['p'] : 1; $p->firstRow = ($currentPage - 1) * $listRows; //分页查询数据 $voList = $model->where($map)->order("`" . $order . "` " . $sort)->limit($p->firstRow . ',' . $p->listRows)->select(); //模板赋值显示 $this->assign('list', $voList); if ($count > $listRows) { $this->assign('page', $p->show()); } return $voList; } return; }
public function statDetail() { $name = CONTROLLER_NAME; $model = D($name); $join = ' LEFT JOIN users u ON S.user_id=u.id LEFT JOIN applications A ON S.application_id=A.id LEFT JOIN developers D ON S.user_id=D.user_id LEFT JOIN iaps I ON S.iap_id=I.id '; $map = $this->_filter('S'); #var_dump($map);exit; //取得满足条件的记录数 $count = $model->alias('S')->join($join)->where($map)->count('S.id'); #echo $count;exit; if ($count > 0) { //创建分页对象 if (!empty($_REQUEST['numPerPage'])) { $listRows = $_REQUEST['numPerPage']; } else { $listRows = 10; } $p = new \Extcom\Lib\Page($count, $listRows); $p->setConfig('prev', '<span class="pageprev"></span>'); $p->setConfig('next', '<span class="pagenext"></span>'); // $currentPage = $_REQUEST['pageNum'] ? $_REQUEST['pageNum'] : 1; $currentPage = $_REQUEST['p'] ? $_REQUEST['p'] : 1; $p->firstRow = ($currentPage - 1) * $listRows; //分页查询数据 $field = array('S.mobile', 'S.application_id', 'S.created', 'S.fee', 'S.status', 'S.client_status', 'S.operator', 'A.name', 'D.company_name', 'u.username', 'A.app_id', 'S.user_id', 'I.name as iap_name', 'I.iap_key'); $voList = $model->alias('S')->field($field)->join($join)->where($map)->order('`created` desc')->limit($p->firstRow . ',' . $p->listRows)->select(); //模板赋值显示 R('Com/getApps'); $this->assign('list', $voList); $this->assign('page', $p->show()); } $this->display(); return; }
public function statApp() { $name = CONTROLLER_NAME; $model = D($name); $join = ' LEFT JOIN users u ON S.user_id=u.id LEFT JOIN applications A ON S.application_id=A.id LEFT JOIN developers D ON S.user_id=D.user_id '; $map = array('S.status' => array('eq', 1)) + $this->_filter('S'); if (isset($_REQUEST['user_id'])) { $_REQUEST['user_id'] += 0; $map = $map + array('S.user_id' => array('eq', $_REQUEST['user_id'])); } #var_dump($map);exit; //取得满足条件的记录数 $counts = $model->alias('S')->field('S.id')->join($join)->where($map)->group('S.application_id')->select(); $count = count($counts); #echo $model->getLastSql();exit; R('Com/getDevelopers'); if ($count > 0) { //创建分页对象 if (!empty($_REQUEST['numPerPage'])) { $listRows = $_REQUEST['numPerPage']; } else { $listRows = 10; } $p = new \Extcom\Lib\Page($count, $listRows); $p->setConfig('prev', '<span class="pageprev"></span>'); $p->setConfig('next', '<span class="pagenext"></span>'); // $currentPage = $_REQUEST['pageNum'] ? $_REQUEST['pageNum'] : 1; $currentPage = $_REQUEST['p'] ? $_REQUEST['p'] : 1; $p->firstRow = ($currentPage - 1) * $listRows; //分页查询数据 $field = array('SUM(fee) AS total', 'S.application_id', 'A.name', 'A.app_key', 'D.company_name', 'u.username', 'A.user_id', 'A.id'); $voList = $model->alias('S')->field($field)->join($join)->where($map)->group('S.application_id')->order('S.created desc')->limit($p->firstRow . ',' . $p->listRows)->select(); #var_dump($voList);exit; //模板赋值显示 $this->assign('list', $voList); $this->assign('page', $p->show()); } $this->display(); }