/** * 活动列表 */ function action_list() { $table = self::$table; $table_alias = 'a'; $join = ' inner join et_user as u on u.id = a.uid '; if (empty($table_alias)) { throw new ErrorException("table is not defined"); } //$request = http_request("rows","page","sidx","sord"); $request = PtLib\http_request("verify", "production_status", "ship_status", "uid", "rows", "page", "sidx", "sord", "activity_id", "activity_name", "username", "mobile", 'startDate', 'endDate', 'pass', 'status', 'success'); $limit = $request['rows']; $page = $request['page']; $sort = $request['sidx']; $sort_type = $request['sord']; $username = $request['username']; //fields $select_fields = " a.production_status,a.ship_status,a.status,a.verify,a.id,a.name,a.uid,a.sale_count,a.sale_target,a.sale_total,a.start_time,a.sale_profit,a.end_time,a.period,a.thumb_svg_url,a.thumb_img_url"; //where $args = array(); if (empty($limit)) { $limit = 20; } if (empty($page)) { $page = 1; } if (empty($sort)) { $sort = "id"; $sort_type = "desc"; } else { if (empty($sort_type)) { $sort_type = "desc"; } } $where = " where 1=1 "; $args = array(); if ($request['uid']) { $where .= 'and a.uid = ? '; $args[] = $request['uid']; } if ($request['verify'] === "0" || $request['verify'] > 0) { $where .= 'and a.verify = ? '; $args[] = $request['verify']; } if ($request['status'] === "0" || $request['status'] > 0) { if ($request['status'] == 1) { //进行中 $where .= 'and a.start_time < now() and now() < a.end_time and a.status = 1'; } if ($request['status'] == 10) { //结束 $where .= 'and now() > a.end_time and a.status > 0'; } if ($request['status'] == 0) { //草稿 $where = 'and a.status = 0 '; } if ($request['status'] == 2) { //失败的 $where = 'and a.status = 2 '; } if ($request['status'] == 3) { //成功的 $where = 'and a.status = 3 '; } } if ($request['activity_id']) { $where .= " and a.id = ? "; $args[] = $request['activity_id']; } if ($request['activity_name']) { $where .= " and a.name like '%" . mysql_escape($request['activity_name']) . "%' "; } //order $order = ""; if ($sort) { $order = "order by a." . addslashes($sort) . " " . $sort_type; } $sql = "select count(a.id) as total from {$table} as a {$join} {$where} "; //$count_res = db()->select_row($sql,$args); $count_res = PtLib\db()->select_row($sql, $args); $records = $count_res['total']; $response = new stdClass(); $response->page = $page; //cur page if ($records > 0) { $total_pages = ceil($records / $limit); } else { $total_pages = 1; } if ($page > $total_pages) { $page = $total_pages; } $response->total = $total_pages; //total pages $response->records = $records; //count $skip = ($page - 1) * $limit; $sql = "select {$select_fields} from {$table} as a {$join} {$where} {$order} limit {$skip},{$limit} "; //$rows = db()->select_rows($sql,$args); $rows = PtLib\db()->select_rows($sql, $args); foreach ($rows as $row) { $response->rows[] = array('id' => $row['id'], "cell" => $row); } return $response; }
function get_table_list($table, $table_alias, $join = '') { #$join = ''; //fields $select_fields = " {$table_alias}.* "; if (empty($table_alias)) { throw new ErrorException("table is not defined"); } // $request = http_request("rows","page","sidx","sord"); $request = PtLib\http_request("rows", "page", "sidx", "sord"); $limit = $request['rows']; $page = $request['page']; $sort = $request['sidx']; $sort_type = $request['sord']; if (empty($limit)) { $limit = 20; } if (empty($page)) { $page = 1; } if (empty($sort)) { $sort = "id"; $sort_type = "desc"; } else { if (empty($sort_type)) { $sort_type = "desc"; } } //where $args = array(); $where = " where 1=1 "; //order $order = ""; if ($sort) { $order = "order by {$table_alias}." . addslashes($sort) . " " . $sort_type; } $sql = "select count({$table_alias}.id) as total from {$table} as {$table_alias} {$join} {$where} "; $count_res = db()->select_row($sql, $args); #$count_res = PtLib\db()->select_row($sql,$args); $records = $count_res['total']; $response = new stdClass(); $response->page = $page; //cur page if ($records > 0) { $total_pages = ceil($records / $limit); } else { $total_pages = 1; } if ($page > $total_pages) { $page = $total_pages; } $response->total = $total_pages; //total pages $response->records = $records; //count $skip = ($page - 1) * $limit; $sql = "select {$select_fields} from {$table} as {$table_alias} {$join} {$where} {$order} limit {$skip},{$limit} "; $rows = db()->select_rows($sql, $args); #$rows = PtLib\db()->select_rows($sql,$args); foreach ($rows as $row) { $response->rows[] = array('id' => $row['id'], "cell" => $row); } return $response; }