function db_image_c_image_list($page, $page_size, &$pager) { $db =& db_get_instance('image'); $sql = 'SELECT c_image_id FROM c_image ORDER BY c_image_id DESC'; $id_list = $db->get_col_page($sql, $page, $page_size); $c_image_list = array(); foreach ($id_list as $c_image_id) { $sql = 'SELECT c_image_id, filename, r_datetime FROM c_image WHERE c_image_id = ?'; $params = array(intval($c_image_id)); $c_image_list[] = $db->get_row($sql, $params); } $sql = 'SELECT COUNT(*) FROM c_image'; $total_num = $db->get_one($sql); $pager = util_make_pager($page, $page_size, $total_num); return $c_image_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; }
function execute($requests) { $target_c_commu_id = $requests['target_c_commu_id']; $page = $requests['page']; $page_size = 100; // コミュ情報 $c_commu = db_commu_c_commu4c_commu_id2($target_c_commu_id); // コミュニティメンバ取得 list($c_member_list, $is_prev, $is_next, $total_num, $start_num, $end_num) = db_admin_commu_c_members4c_commu_id($target_c_commu_id, $page_size, $page); if (empty($c_member_list)) { // 存在しないコミュはコミュリストにリダイレクト openpne_redirect('admin', 'page_list_c_commu'); } $this->set('c_commu', $c_commu); $this->set('c_member_list', $c_member_list); $this->set('target_c_commu_id', $target_c_commu_id); $this->set('page', $page); $this->set('page_size', $page_size); $pager = util_make_pager($page, $page_size, $total_num); $this->set('pager', $pager); return 'success'; }
/** * ポータル用画像ファイルリストを取得する * * @param int $page * @param int $page_size * @param array $pager */ function db_portal_image_list($page, $page_size, &$pager) { $sql = 'SELECT * FROM portal_image ORDER BY portal_image_id DESC'; $portal_image_list = db_get_all_page($sql, $page, $page_size); $sql = 'SELECT COUNT(*) FROM portal_image'; $total_num = db_get_one($sql); $pager = util_make_pager($page, $page_size, $total_num); return $portal_image_list; }
/** * 申請者リスト取得 * * @param int $page * @param int $page_size * @param array $pager * @param array $cond_list * @param string $mail_address * @param array $order * @return array $c_member_pre_list */ function _db_admin_c_member_pre_list($page, $page_size, &$pager, $cond_list, $mail_address, $order) { $c_member_pre_list = _db_admin_c_member_pre_cond_list($cond_list, $mail_address, $order); $total_num = count($c_member_pre_list); $c_member_pre_list = array_slice($c_member_pre_list, ($page - 1) * $page_size, $page_size); if ($total_num > 0) { $pager = util_make_pager($page, $page_size, $total_num); } else { $pager = array('page_size' => $page_size); } return $c_member_pre_list; }