Пример #1
0
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;
}
Пример #2
0
/**
 * 登録されているファイルをリストアップする
 *
 * @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;
}
Пример #3
0
 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';
 }
Пример #4
0
/**
 * ポータル用画像ファイルリストを取得する
 *
 * @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;
}
Пример #5
0
/**
 * 申請者リスト取得
 *
 * @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;
}