source: OpenPNE/branches/work/cake/koko/webapp_ext/lib/koko/db_koko.php @ 7737

<?php

//---- ココ基本情報  ----

/**
 * メンバーIDからココ情報をページャで取得
 * 位置情報復号化済
 * 引数：$c_member_id, ページャ指定
 * 返り値：array:ココ情報
 */
function p_koko_get_koko_list4c_member_id($c_member_id, $page_size=10, $page=1)
{
    $sql = 'SELECT * FROM koko WHERE c_member_id = ?'.
           ' ORDER BY r_datetime DESC';
    $params = array(intval($c_member_id));
    $list = db_get_all_page($sql, $page, $page_size, $params);

    $sql = 'SELECT COUNT(*) FROM koko WHERE c_member_id = ?';
    $total_num = db_get_one($sql, $params);

    if ($total_num != 0) {
        $total_page_num =  ceil($total_num / $page_size);
        if ($page >= $total_page_num) {
            $next = false;
        } else {
            $next = true;
        }

        if ($page <= 1) {
            $prev = false;
        } else {
            $prev = true;
        }
    }

    return array(util_koko_decrypt_location_assoc($list), $prev, $next, $total_num);
}

/**
 * 最新のココ情報を取得
 * 位置情報復号化済
 * 引数：$c_member_id
 * 返り値：array
 */
function db_koko_get_latest_koko4c_member_id($c_member_id) {
    $sql = 'SELECT * FROM koko WHERE c_member_id = ? ORDER BY r_datetime DESC';
    $params = array(intval($c_member_id));
    $data = db_get_row($sql, $params);
    return util_koko_decrypt_location($data);
}




//---- ココ日記 ----


?>