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