function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$c_review_comment_id = $requests['c_review_comment_id'];
// ----------
//--- 権限チェック
//レビューコメント作者
if (!db_review_edit_c_review_comment4c_review_comment_id_c_member_id($c_review_comment_id, $u)) {
handle_kengen_error();
}
//---
$c_review_id = db_review_common_c_review_id4c_review_comment_id($c_review_comment_id);
do_h_review_edit_delete_c_review_comment($c_review_comment_id);
//コメント件数が0件になった場合は
// c_review / c_review_clip / c_commu_review を削除する
if (db_review_count_c_review_comment4c_review_id($c_review_id) === 0) {
do_delete_c_review4c_review_id($c_review_id);
}
$p = array('c_member_id' => $u);
openpne_redirect('pc', 'page_fh_review_list_member', $p);
}
function do_common_count_c_review_comment4c_review_id($c_review_id)
{
return db_review_count_c_review_comment4c_review_id($c_review_id);
}
function db_review_clip_list_h_review_clip_list4c_member_id($c_member_id, $page, $page_size = 30)
{
$sql = "SELECT * FROM c_review AS cr, c_review_clip AS crc" . " WHERE crc.c_review_id = cr.c_review_id" . " AND c_member_id = ?" . " ORDER BY crc.r_datetime";
$params = array(intval($c_member_id));
$list = db_get_all_page($sql, $page, $page_size, $params);
//カテゴリの表示名を取得
$category_disp = do_review_review_add_category_disp();
//$lstに書き込み数 + カテゴリ名 を追加
foreach ($list as $key => $value) {
$list[$key]['write_num'] = db_review_count_c_review_comment4c_review_id($value['c_review_id']);
$list[$key]['category_disp'] = $category_disp[$value['c_review_category_id']];
}
$sql = "SELECT COUNT(*) FROM c_review_clip WHERE c_member_id = ?";
$params = array(intval($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;
}
}
$start_num = ($page - 1) * $page_size + 1;
$end_num = ($page - 1) * $page_size + $page_size > $total_num ? $total_num : ($page - 1) * $page_size + $page_size;
return array($list, $prev, $next, $total_num, $start_num, $end_num);
}
