/** * メンバーリスト取得 */ function db_admin_c_member_list($page, $page_size, &$pager) { $sql = 'SELECT c_member_id FROM c_member ORDER BY c_member_id'; $ids = db_get_col_page($sql, $page, $page_size); $c_member_list = array(); foreach ($ids as $id) { $c_member_list[] = db_member_c_member4c_member_id($id, true, true, 'private'); } $sql = 'SELECT COUNT(*) FROM c_member'; $total_num = db_get_one($sql); $pager = util_make_pager($page, $page_size, $total_num); return $c_member_list; }
/** * 登録されているファイルをリストアップする * * @param int $page * @param int $page_size * @param int &$pager */ function db_file_c_file_list($page, $page_size, &$pager) { $sql = 'SELECT c_file_id FROM c_file ORDER BY c_file_id DESC'; $id_list = db_get_col_page($sql, $page, $page_size); $c_file_list = array(); foreach ($id_list as $i => $c_file_id) { $sql = 'SELECT c_file_id, filename, original_filename, r_datetime, bin FROM c_file WHERE c_file_id = ?'; $params = array(intval($c_file_id)); $c_file_list[$i] = db_get_row($sql, $params); $c_file_list[$i]['size'] = strlen($c_file_list[$i]['bin']); unset($c_file_list[$i]['bin']); } $sql = 'SELECT COUNT(*) FROM c_file'; $total_num = db_get_one($sql); $pager = util_make_pager($page, $page_size, $total_num); return $c_file_list; }