Coupon Display/Query Error

December 7th, 2011 #1

Thread Starter

Amateur

Coupon Display/Query Error

Under the "coupon categories" page [tpl-coupon-cats.php] there is a count next to the categories link; when such a link is selected you are taken to the page for that category [taxonomy-coupon_category.php] which has two sections labeled "Active Coupons" and "Unreliable Coupons" both of which are empty.

Inside the [taxonomy-coupon_category.php] page the function for retrieving the Active Coupons is as follows:

PHP Code:


                    query_posts(array(

                            'post_type' => APP_POST_TYPE,

                            APP_TAX_CAT => $term->slug,

                            'caller_get_posts' => 1,

                            'paged' => $paged,

                            'not_expired_coupons' => true,

                            'meta_query' => array(

                                                            'relation' => 'OR',



                                                            // Get rid of low success

                                                            array(

                                                                    'key' => 'clpr_votes_percent',

                                                                    'value' => array( 0, 50 ),

                                                                    'compare' => 'NOT BETWEEN',

                                                                    'type' => 'numeric',

                                                            ),



                                                            // 0% Coupons with no votes are new coupons

                                                            array(

                                                                    'key' => 'clpr_votes_down',

                                                                    'value' => array(0,0),

                                                                    'compare' => 'BETWEEN',

                                                                    'type' => 'numeric'

                                                            )

                                                        )

                    ));

This should return the coupons which are either at 0% w/ no down-votes OR between (50,100], which we can call the expected-set, but for some reason it does not and instead returns nothing. {We have a few coupons with a single up-vote (and therefore at 100%) that we are testing; that vote is from the admin if that is of any import.}

When the above is altered to remove the meta_query key/value pair from the array all coupons are shown, as expected. When the the meta_query takes the value of one of its two subarrays the result is the null set instead of the expected subportion of the expected-set.

Furthermore, the portion of code to return "Unreliable Coupons" also returns nothing; it is as follows:

PHP Code:


                    // show all coupons with <= than 50% success (excluding 0%) for this category and setup pagination

                    $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;                

                    query_posts(array(

                            "filter_unreliable" => true,

                            'post_type' => APP_POST_TYPE,

                            APP_TAX_CAT => $term->slug,

                            'caller_get_posts' => 1,

                            'paged' => $paged

                    ));