function execute($requests)
{
$v = array();
$target_c_review_comment_ids = $requests['target_c_review_comment_ids'];
// レビューが選択されていない場合はエラー
if (!$target_c_review_comment_ids) {
admin_client_redirect('review_list', "レビューが選択されていません");
}
$id_ary = split(":", $target_c_review_comment_ids);
$v = array();
$review_list = array();
foreach ($id_ary as $id) {
$review = db_review_edit_c_review_comment4c_review_comment_id($id);
if (!$review) {
admin_client_redirect('review_list', '指定されたレビューは存在しません');
}
$review['c_review'] = db_review_list_product_c_review4c_review_id($review['c_review_id']);
$member = db_member_c_member4c_member_id($review['c_member_id']);
$review['c_member'] = $member;
array_push($review_list, $review);
}
$this->set('review_list', $review_list);
$this->set('target_c_review_comment_ids', $target_c_review_comment_ids);
$v['SNS_NAME'] = SNS_NAME;
$v['OPENPNE_VERSION'] = OPENPNE_VERSION;
$this->set($v);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$c_review_id = $requests['c_review_id'];
$page = $requests['page'];
// ----------
$page_size = 30;
// c_reviewをAmazonの最新データに更新
db_review_update_old_c_review($c_review_id);
$c_review = db_review_list_product_c_review4c_review_id($c_review_id);
if (!$c_review) {
handle_kengen_error();
}
$this->set('inc_navi', fetch_inc_navi('h'));
$this->set('c_review', $c_review);
list($c_review_list, $is_prev, $is_next, $total_num, $start_num, $end_num) = db_review_list_product_c_review_list4c_review_id($c_review_id, $page, $page_size);
$this->set('c_review_list', $c_review_list);
$this->set("is_prev", $is_prev);
$this->set("is_next", $is_next);
$this->set("page", $page);
$this->set("total_num", $total_num);
$this->set('start_num', $start_num);
$this->set('end_num', $end_num);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$c_commu_id = $requests['target_c_commu_id'];
$c_review_id = $requests['c_review_id'];
// ----------
//--- 権限チェック
//レビューコメント作者 かつ コミュニティ参加者
$status = db_common_commu_status($u, $c_commu_id);
if (!$status['is_commu_member']) {
handle_kengen_error();
}
//---
foreach ($c_review_id as $value) {
// レビューの存在を確認
if (!db_review_list_product_c_review4c_review_id($value)) {
continue;
}
// 重複登録の禁止
if (db_review_c_member_review_c_review_id4c_review_id_c_member_id($value, $u, $c_commu_id)) {
continue;
}
do_c_member_review_insert_c_commu_review($value, $u, $c_commu_id);
}
$p = array('target_c_commu_id' => $c_commu_id);
openpne_redirect('pc', 'page_c_member_review', $p);
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$c_review_id = $requests['c_review_id'];
// ----------
$c_review = db_review_list_product_c_review4c_review_id($c_review_id);
if (!$c_review) {
handle_kengen_error();
}
$this->set('inc_navi', fetch_inc_navi('h'));
$this->set('c_review', $c_review);
return 'success';
}
function execute($requests)
{
$v = array();
$target_c_review_comment_id = $requests['target_c_review_comment_id'];
$v = array();
$review = db_review_edit_c_review_comment4c_review_comment_id($target_c_review_comment_id);
if (!$review) {
admin_client_redirect('review_list', '指定されたレビューは存在しません');
}
$review['c_review'] = db_review_list_product_c_review4c_review_id($review['c_review_id']);
$member = db_member_c_member4c_member_id($review['c_member_id']);
$review['c_member'] = $member;
$this->set('review', $review);
$v['SNS_NAME'] = SNS_NAME;
$v['OPENPNE_VERSION'] = OPENPNE_VERSION;
$this->set($v);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$c_review_id = $requests['c_review_id'];
// ----------
//--- 権限チェック
//レビューコメント作者以外
if (db_review_clip_add_c_review_id4c_review_id_c_member_id($c_review_id, $u)) {
openpne_redirect('pc', 'page_h_review_clip_list');
}
//---
$c_review = db_review_list_product_c_review4c_review_id($c_review_id);
if (!$c_review) {
handle_kengen_error();
}
do_h_review_clip_add_insert_c_review_clip($c_review_id, $u);
openpne_redirect('pc', 'page_h_review_clip_list');
}
function p_h_review_list_product_c_review4c_review_id($c_review_id)
{
return db_review_list_product_c_review4c_review_id($c_review_id);
}
function monitor_review_list4c_review_id($c_review_comment_id, $page_size, $page)
{
$page = intval($page);
$page_size = intval($page_size);
$where = " WHERE c_review_comment_id = ? ";
$params[] = intval($c_review_comment_id);
$select = "SELECT c_review_comment.*";
$from = " FROM c_review_comment";
$order = " ORDER BY r_datetime desc";
$sql = $select . $from . $where . $order;
$list = db_get_all_limit($sql, ($page - 1) * $page_size, $page_size, $params);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
$list[$key]['c_review'] = db_review_list_product_c_review4c_review_id($value['c_review_id']);
}
$sql = "SELECT COUNT(*) " . $from . $where;
$total_num = db_get_one($sql, $params);
$total_page_num = ceil($total_num / $page_size);
$next = $page < $total_page_num;
$prev = $page > 1;
return array($list, $prev, $next, $total_num, $total_page_num);
}
