Got it working with the following method. There’s probably a better way to do it but this is good enough for it’s purpose. Added IF statement for options if($_POST[‘date’] === ‘HIGH’){ $order=”meta_value_num”; $sort=”DESC”; } elseif ($_POST[‘date’] === ‘LOW’){ $order=”meta_value_num”; $sort=”ASC”; } elseif ($_POST[‘date’] === ‘ASC’){ $order=”date”; $sort=”ASC”; } elseif ($_POST[‘date’] === ‘DESC’){ $order=”date”; $sort=”DESC”; } … Read more
I figured it out afterwards. Ended up using a different approach, I’m posting it in case someone has the same issue <?php date_default_timezone_set(‘America/Argentina/Buenos_Aires’); $posts_by_date_field = new WP_Query(array( ‘post_type’ => ‘post’, ‘posts_per_page’ => -1, ‘meta_key’ => ‘fecha’, ‘orderby’ => ‘meta_value’, ‘order’ => ‘ASC’, ‘meta_type’ => ‘DATE’ )); if ($posts_by_date_field->have_posts()) : while ($posts_by_date_field->have_posts()) : $posts_by_date_field->the_post(); // LOOP … Read more
I don’t think this can be cleanly expressed in WP query API. YOu can query for posts matching all of terms in a set or any of terms in a set, but there is no concept of how many terms matched. You would need to write either: Very custom SQL for the query you want … Read more
You can use a meta_query in addition to your tax_query : https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters I have in which if statement you want to use it so I put it in the of the code. $names = array( ‘fields’ => ‘names’ ); $prac_names = get_terms(‘attorney-practice’, $names); $prac_matches = array_shift(preg_grep (‘(‘. $search .’)’, $prac_names)); $off_names = get_terms(‘office-location’, $names); $off_matches … Read more
If you make the changes directly through SQL you won’t trigger the order change event and that’s why the email is not being sent. Instead of changing order via SQL you need to use some predefined function like update_status : $ord = new WC_Order($ID); //ID of the order $ord->update_status(‘completed’)
Looks like I was overcomplicating things. This is the solution: add_filter( ‘woocommerce_email_classes’, ‘custom_woocommerce_email_classes’, 10, 1 ); function custom_woocommerce_email_classes( $email_classes ) { $email_classes[ ‘WC_Email_Customer_On_Review_Request’ ] = include_once ‘includes/classes/class-wc-email-customer-on-review-request.php’; // Register custom trigger to send on-hold email when status is switched from on-review to on-hold. add_action( ‘woocommerce_order_status_on-review_to_on-hold_notification’, [ $email_classes[ ‘WC_Email_Customer_On_Hold_Order’ ], ‘trigger’ ], 10, 2 ); return … Read more
Without knowing what Realia_Post_Type_Property::get_properties() does and returns, this is a bit tricky to answer. But essentially, you want to to sort an array using PHP. Unless Realia_Post_Type_Property::get_properties() allows you to get a sorted list of posts, your best bet is probably to use wp_list_sort(). That function sorts a list of objects, based on one or … Read more
You probably can find some way to make MySQL do the sort for you, but an alternative approach is to make it into an ASC/DESC order by adding additional meta in which you put a numeric sort order value based on whether it is apple, bag, etc and update it when the post is saved. … Read more
Loop random posts and display odd and even based on two alternating meta values?
The orderby argument is limited by what is possible in MySQL, and it’s not good at natural alphanumeric sorting like you describe. Possible options include: Rewriting the values with leading zeros, e.g. “CA05” Creating a separate “Sort Order” column that just stores an integer, and ordering by that. Separating the letters and numbers into two … Read more