get_results( $wpdb->prepare("
SELECT meta_value, COUNT( * ) as meta_value_count FROM $wpdb->commentmeta
LEFT JOIN $wpdb->comments ON $wpdb->commentmeta.comment_id = $wpdb->comments.comment_ID
WHERE meta_key = 'rating'
AND comment_post_ID = %d
AND comment_approved = '1'
AND meta_value > 0
GROUP BY meta_value
", $product->get_id() ) );
foreach ( $raw_counts as $count ) {
$counts[ $count->meta_value ] = $count->meta_value_count;
}
return $counts;
}
function fr_woo_rating_icons_html($rating, $count){
$html = '';
if($rating > 0){
$rating = round($rating, 2);
for ($i = 1; $i <= 5; $i++){
if ($i <= $rating){
$active = ' active';
}else{
$half = $i - 0.5;
if($half <= $rating){
$active = ' halfactive';
}else{
$active ='';
}
}
$html .= '★';
}
}
return $html;
}
remove_action( 'woocommerce_cart_collaterals', 'woocommerce_cross_sell_display' );
add_action( 'woocommerce_checkout_before_order_review_heading', 'blockpress_woo_order_checkout' );
add_action( 'woocommerce_checkout_after_order_review', 'blockpress_woo_after_order_checkout' );
add_action( 'woocommerce_before_checkout_form', 'blockpress_woo_style_checkout' );
add_action( 'woocommerce_before_cart', 'blockpress_woo_style_cart' );
add_action( 'woocommerce_after_cart_table', 'woocommerce_cross_sell_display' );
function blockpress_woo_order_checkout() {
echo '';
}
function blockpress_woo_after_order_checkout() {
echo '
';
}
function blockpress_woo_style_checkout() {
echo blockpress_generate_incss('checkoutcart');
echo blockpress_generate_incss('woocheckout');
}
function blockpress_woo_style_cart() {
echo blockpress_generate_incss('checkoutcart');
echo blockpress_generate_incss('woocart');
}
// pros and cons in comment form
add_filter('woocommerce_product_review_comment_form_args', 'blockpress_add_woo_pros_cons_form_fields');
function blockpress_add_woo_pros_cons_form_fields($comment_form){
if ( get_option( 'woocommerce_enable_review_rating' ) === 'yes' ) {
global $product;
$productid = $product->get_id();
$userid = get_current_user_id();
$commented = get_user_meta($userid, '_added_woo_pros_cons', true);
if(empty($commented) || !is_array($commented)){
$flagged = false;
}elseif(in_array($productid, $commented)){
$flagged = true;
}else{
$flagged = false;
}
if(!$flagged){
$comment_form['comment_field'] .= '';
}
}
return $comment_form;
}
// Save Negative, positive
function blockpress_add_neg_comment( $comment_id ){
if ( isset($_POST['comment_post_ID']) && (!empty( $_POST['neg_comment']) || !empty($_POST['pos_comment'])) && 'product' === get_post_type( absint( $_POST['comment_post_ID'] ) ) ) {
if(!empty($_POST['neg_comment'])){
add_comment_meta( $comment_id, 'neg_comment', sanitize_textarea_field( $_POST['neg_comment'] ), true );
}
if(!empty($_POST['pos_comment'])){
add_comment_meta( $comment_id, 'pos_comment', sanitize_textarea_field( $_POST['pos_comment'] ), true );
}
$comment = get_comment( $comment_id );
$userid = $comment->user_id;
$postid = $comment->comment_post_ID;
$commented = get_user_meta($userid, '_added_woo_pros_cons', true);
if(empty($commented) || !is_array($commented)){
$commented = array();
}
$commented[] = $postid;
add_user_meta($userid, '_added_woo_pros_cons', $commented, true);
}
}
add_action( 'comment_post', 'blockpress_add_neg_comment' );
// pros and cons in comment text
function blockpress_wc_comment_neg_get( $comment ) {
$out = '';
$pros_review = get_comment_meta( $comment->comment_ID, 'pos_comment', true );
$cons_review = get_comment_meta( $comment->comment_ID, 'neg_comment', true );
if($pros_review || $cons_review){$out .='';}
$classcol = (!empty($cons_review) && !empty($pros_review)) ? 'fr-one-half ' : '';
if(isset($pros_review) && $pros_review != '') {
$pros_reviews = explode(PHP_EOL, $pros_review);
$proscomment = '';
foreach ($pros_reviews as $pros) {
$proscomment .='';
}
$out .='';
};
if(isset($cons_review) && $pros_review != '') {
$cons_reviews = explode(PHP_EOL, $cons_review);
$conscomment = '';
foreach ($cons_reviews as $cons) {
$conscomment .='';
}
$out .='';
};
if($pros_review || $cons_review){$out .= '
';}
return $out;
}
function blockpress_wc_comment_neg( $comment ) {
echo blockpress_wc_comment_neg_get($comment);
}
add_action( 'woocommerce_review_comment_text', 'blockpress_wc_comment_neg', 12 );
add_action( 'add_meta_boxes', 'blockpress_add_pros_meta_to_panel', 35 );
function blockpress_add_pros_meta_to_panel(){
add_meta_box( 'blockpress_woo_pros_section_edit_comment', esc_html__( "Pros and Cons", "blockpress" ), 'blockpress_woo_cm_edit_pros_cons', 'comment', 'normal' );
}
//Render pros, cons in Comment Edit screen
function blockpress_woo_cm_edit_pros_cons($comment){
if ( !isset( $comment->comment_ID ) ) return;
if ( !isset( $comment->comment_post_ID ) ) return;
$post_id = $comment->comment_post_ID;
$post_type = get_post_type( $post_id );
if($post_type !=='product') return;
$pos_comment = get_comment_meta( $comment->comment_ID, 'pos_comment', true );
$neg_comment = get_comment_meta( $comment->comment_ID, 'neg_comment', true );
$prosconsRow ='';
if( !empty($pos_comment) || !empty($neg_comment) ) {
$prosconsRow .= '
|
|
';
}
if($prosconsRow){
echo '';
}
}
//Save pros cons values from Comment editor
function blockpress_wc_neg_comment_save( $data ) {
if ( ! isset($_POST['neg_comment'], $_POST['pos_comment'] ) )
return $data;
if(!empty($_POST['neg_comment'])){
update_comment_meta( $data['comment_ID'], 'neg_comment', sanitize_textarea_field( $_POST['neg_comment'] ) );
}
if(!empty($_POST['pos_comment'])){
update_comment_meta( $data['comment_ID'], 'pos_comment', sanitize_textarea_field( $_POST['pos_comment'] ) );
}
return $data;
}
add_filter( 'wp_update_comment_data', 'blockpress_wc_neg_comment_save', 1 );
//Add custom column for Products
function blockpress_woo_rev_comment_columns( $columns )
{
$columns['blockpress_woo_user_review_column'] = esc_html__( 'Product Review', 'blockpress' );
return $columns;
}
add_filter( 'manage_edit-comments_columns', 'blockpress_woo_rev_comment_columns' );
function blockpress_woo_rev_comment_column( $column, $comment_ID )
{
if ( 'blockpress_woo_user_review_column' == $column ) {
$pos_comment = get_comment_meta($comment_ID, 'pos_comment', true);
$neg_comment = get_comment_meta($comment_ID, 'neg_comment', true);
if(isset($pos_comment) && $pos_comment != '') {
echo ''.__('+ PROS:', 'blockpress').' '.$pos_comment.'
';
};
if(isset($neg_comment) && $neg_comment != '') {
echo ''.__('- CONS:', 'blockpress').' '.$neg_comment.'
';
};
echo '
';
}
}
add_filter( 'manage_comments_custom_column', 'blockpress_woo_rev_comment_column', 10, 2 );