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); }