public function queryAction() { list($page, $sidx, $limit, $sord, $start) = getRequestParams(); $model = $this->getModel(); $user_id = is_user_login(); $condition = array("user_id" => $user_id); $search = I("_search"); if (!empty($search)) { $condition = array_merge($condition, getOneSearchParams()); } $ret = $model->relation(true)->where($condition)->order("{$sidx} {$sord}")->limit("{$start},{$limit}")->select(); $count = $model->where($condition)->count(); if ($count > 0 && $limit > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } $channels = M("Channel")->where(array("brand_id" => get_brand_id()))->select(); $response = array("page" => $page, "total" => $total_pages, "records" => $count, "rows" => $ret); $this->ajaxReturn($response); }
public function payHistoryQueryAction() { list($page, $sidx, $limit, $sord, $start) = getRequestParams(); $filters = I("filters", '', ''); $brand_id = get_brand_id(); $condition = array("brand_id" => $brand_id, "type" => 3); $search = I("_search"); if (!empty($search)) { $condition = array_merge($condition, getOneSearchParams()); } $model = D("Review"); $count = $model->where($condition)->count(); $ret = $model->relation(true)->where($condition)->order("{$sidx} {$sord},id desc")->limit("{$start},{$limit}")->select(); foreach ($ret as $key => $value) { $contract = json_decode($value['extension'], true); $original = !empty($value['original_extension']) ? json_decode($value['original_extension'], true) : null; $ret[$key]['extension'] = $contract; $ret[$key]['original_extension'] = $original; } if ($count > 0 && $limit > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } $response = array("page" => $page, "total" => $total_pages, "records" => $count, "rows" => $ret); $this->ajaxReturn($response); }