function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$category_id = $requests['category_id'];
$asin = $requests['asin'];
$body = $requests['body'];
$satisfaction_level = $requests['satisfaction_level'];
// ----------
$c_review_comment = db_review_add_write_c_review_comment4asin_c_member_id($asin, $u);
if ($c_review_comment) {
$p = array('c_review_id' => $c_review_comment['c_review_id']);
openpne_redirect('pc', 'page_h_review_list_product', $p);
}
$product = db_review_write_product4asin($asin);
if (!$product) {
handle_kengen_error();
}
$this->set('inc_navi', fetch_inc_navi('h'));
$this->set('category_id', $category_id);
$this->set('asin', $asin);
$this->set('body', $body);
$this->set('satisfaction_level', $satisfaction_level);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$category_id = $requests['category_id'];
$asin = $requests['asin'];
$body = $requests['body'];
$satisfaction_level = $requests['satisfaction_level'];
// ----------
$c_review_comment = db_review_add_write_c_review_comment4asin_c_member_id($asin, $u);
if ($c_review_comment) {
$p = array('c_review_id' => $c_review_comment['c_review_id']);
openpne_redirect('pc', 'page_h_review_list_product', $p);
}
$product = db_review_write_product4asin($asin);
if (!$product) {
handle_kengen_error();
}
//c_reviewへ登録
$c_review_id = do_c_review_add_insert_c_review($product, $category_id);
//c_review_commentへ登録
if ($c_review_id) {
do_c_review_add_insert_c_review_comment($c_review_id, $u, $body, $satisfaction_level);
}
if (OPENPNE_USE_POINT_RANK) {
//レビューを書いた人にポイント付与
$point = db_action_get_point4c_action_id(6);
db_point_add_point($u, $point);
}
$p = array('c_review_id' => $c_review_id);
openpne_redirect('pc', 'page_h_review_list_product', $p);
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$c_review_comment_id = $requests['c_review_comment_id'];
$asin = $requests['asin'];
// ----------
$c_review_comment = db_review_add_write_c_review_comment4asin_c_member_id($asin, $u);
if (!$c_review_comment) {
handle_kengen_error();
}
$product = db_review_write_product4asin($asin);
if (!$product) {
handle_kengen_error();
}
$this->set('inc_navi', fetch_inc_navi("h"));
$this->set('c_review_comment_id', $c_review_comment_id);
$this->set('asin', $asin);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$category_id = $requests['category_id'];
$asin = $requests['asin'];
$body = $requests['body'];
$satisfaction_level = $requests['satisfaction_level'];
$err_msg = $requests['err_msg'];
// ----------
// c_reviewをAmazonの最新データに更新
$c_review_id = db_review_c_review_id4asin($asin);
db_review_update_old_c_review($c_review_id);
// 登録済みならh_review_editへ飛ばす
$c_review_comment = db_review_add_write_c_review_comment4asin_c_member_id($asin, $u);
if ($c_review_comment) {
$_REQUEST['c_review_id'] = $c_review_comment['c_review_id'];
$_REQUEST['asin'] = $asin;
openpne_forward('pc', 'page', "h_review_edit");
exit;
}
$this->set('inc_navi', fetch_inc_navi("h"));
$satisfaction = array("5" => "★★★★★ 5", "4" => "★★★★ 4", "3" => "★★★ 3", "2" => "★★ 2", "1" => "★ 1");
$this->set('category_id', $category_id);
$this->set('asin', $asin);
$this->set('body', $body);
$this->set('satisfaction_level', $satisfaction_level);
$this->set('satisfaction', $satisfaction);
$this->set('err_msg', $err_msg);
$product = db_review_write_product4asin($asin);
if (!$product) {
handle_kengen_error();
}
$this->set('product', $product);
return 'success';
}
function p_h_review_write_product4asin($asin)
{
return db_review_write_product4asin($asin);
}
function db_review_update_old_c_review($c_review_id)
{
$timestamp = date('Y-m-d H:i:s', strtotime('-1 month'));
$sql = 'SELECT * FROM c_review' . ' WHERE c_review_id = ?' . ' AND r_datetime < ?';
$params = array(intval($c_review_id), $timestamp);
$c_review = db_get_row($sql, $params);
if ($c_review) {
$asin = $c_review['asin'];
$product = db_review_write_product4asin($asin);
if ($product) {
$data = array('title' => $product['ItemAttributes']['Title'], 'release_date' => $product['ItemAttributes']['PublicationDate'], 'manufacturer' => $product['ItemAttributes']['Manufacturer'], 'author' => $product['author'], 'image_small' => $product['SmallImage']['URL'], 'image_medium' => $product['MediumImage']['URL'], 'image_large' => $product['LargeImage']['URL'], 'url' => $product['DetailPageURL'], 'asin' => $product['ASIN'], 'list_price' => $product['ListPrice']['FormattedPrice'], 'retail_price' => $product['OfferSummary']['LowestUsedPrice']['FormattedPrice'], 'r_datetime' => db_now());
foreach ($data as $key => $value) {
if (is_null($value)) {
$data[$key] = '';
}
}
$where = array('c_review_id' => intval($c_review_id));
db_update('c_review', $data, $where);
}
}
}
