/**
* メンバーリスト取得
*/
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;
}
