cw_array2insert('products_votes', array('remote_ip' => $review_data['remote_ip'], 'vote_value' => $vote, 'product_id' => $review_data['product_id'], 'customer_id' => $review_data['customer_id'], 'review_id' => $review_id, 'attribute_id' => $attr_id));
}
cw_review_recalculate_avg_rating($review_data['product_id'], $attr_id);
}
cw_review_recalculate_avg_rating($review_data['product_id']);
// if some changed
if ($review_data['email'] != $review['email'] || $review_data['message'] != $review['message']) {
$status = $config['estore_products_review']['status_created_reviews'];
}
// update review
$update_review_data = array();
$update_review_data['email'] = $review['email'];
$update_review_data['message'] = $review['message'];
$update_review_data['status'] = $status;
cw_array2update('products_reviews', $update_review_data, "review_id = '{$review_id}'");
}
}
cw_add_ajax_block(array('id' => 'review_management_container', 'action' => 'append', 'content' => ''));
}
$review = array();
if (!empty($review_id) && !empty($product_id) && $config['estore_products_review']['customer_reviews'] == 'Y' && cw_review_avail_by_settings($product_id, $_customer_id, $extended_review_customer_id)) {
$review = cw_query_first("SELECT * FROM {$tables['products_reviews']} r WHERE r.review_id='{$review_id}' AND r.customer_id='{$_customer_id}'");
if ($config['estore_products_review']['customer_voting'] == 'Y') {
$attribute_votes = cw_review_get_attribute_vote_values($review);
}
}
$smarty->assign('review', $review);
$smarty->assign('attribute_votes', $attribute_votes);
$smarty->assign('current_section_dir', 'main');
$smarty->assign('main', 'estore_review_management');
$smarty->assign('home_style', 'popup');
<?php
global $smarty, $tables, $customer_id;
$extended_review_customer_id =& cw_session_register("extended_review_customer_id", 0);
$_customer_id = $customer_id;
if (!empty($extended_review_customer_id)) {
$_customer_id = $extended_review_customer_id;
}
if (defined('IS_AJAX') && !empty($review_id)) {
cw_load('ajax');
$review = cw_query_first("\n SELECT r.*, v.vote_value\n FROM {$tables['products_reviews']} r\n LEFT JOIN {$tables['products_votes']} v ON r.review_id = v.review_id\n WHERE r.review_id='{$review_id}' AND r.customer_id='{$_customer_id}'\n ");
$review['attribute_votes'] = cw_review_get_attribute_vote_values($review);
$review['p_vote'] = cw_query_first_cell("SELECT COUNT(*) FROM {$tables['products_reviews_ratings']} WHERE review_id = {$review['review_id']} AND rate = 1");
$review['n_vote'] = cw_query_first_cell("SELECT COUNT(*) FROM {$tables['products_reviews_ratings']} WHERE review_id = {$review['review_id']} AND rate = 2");
$smarty->assign('review_item', $review);
$avail_by_settings = cw_review_avail_by_settings($review['product_id'], $_customer_id, $extended_review_customer_id);
$smarty->assign('avail_by_settings', $avail_by_settings);
cw_add_ajax_block(array('id' => 'customer_review_item_' . $review_id, 'action' => 'update', 'template' => 'addons/estore_products_review/customer_reviews_management_item.tpl'));
}
