/**
  * Custom SQL join for orderby
  *
  * @param string   $join_sql
  * @param wp_query $query
  *
  * @return string
  */
 public static function posts_join_orderby($join_sql, $query)
 {
     global $wpdb;
     switch ($query->get('orderby')) {
         case 'venue':
             $join_sql .= " LEFT JOIN {$wpdb->postmeta} tribe_order_by_venue_meta ON {$wpdb->posts}.ID = tribe_order_by_venue_meta.post_id AND tribe_order_by_venue_meta.meta_key='_EventVenueID' LEFT JOIN {$wpdb->posts} tribe_order_by_venue ON tribe_order_by_venue_meta.meta_value = tribe_order_by_venue.ID ";
             break;
         case 'organizer':
             $join_sql .= " LEFT JOIN {$wpdb->postmeta} tribe_order_by_organizer_meta ON {$wpdb->posts}.ID = tribe_order_by_organizer_meta.post_id AND tribe_order_by_organizer_meta.meta_key='_EventOrganizerID' LEFT JOIN {$wpdb->posts} tribe_order_by_organizer ON tribe_order_by_organizer_meta.meta_value = tribe_order_by_organizer.ID ";
             break;
         default:
             break;
     }
     return apply_filters('tribe_events_query_posts_join_orderby', $join_sql);
 }
Ejemplo n.º 2
0
 /**
  * Custom SQL order by statement for Event Start Date result order.
  *
  * @param string  $order_sql
  * @param wp_query $query
  * @return string
  */
 public static function posts_orderby($order_sql, $query)
 {
     global $wpdb;
     if ($query->tribe_is_event || $query->tribe_is_event_category) {
         $order = !empty($query->order) ? $query->order : $query->get('order');
         $orderby = !empty($query->orderby) ? $query->orderby : $query->get('orderby');
         $order_sql = "DATE({$wpdb->postmeta}.meta_value) {$order}, TIME({$wpdb->postmeta}.meta_value) {$order}";
         switch ($orderby) {
             case 'venue':
                 $order_sql = "tribe_order_by_venue.post_title {$order}, " . $order_sql;
                 break;
             case 'organizer':
                 $order_sql = "tribe_order_by_organizer.post_title {$order}, " . $order_sql;
                 break;
             case 'title':
                 $order_sql = "{$wpdb->posts}.post_title {$order}, " . $order_sql;
                 break;
             case 'menu_order':
                 $order_sql = "{$wpdb->posts}.menu_order ASC, " . $order_sql;
                 break;
             case 'event_date':
             default:
                 // we've already setup $order_sql
                 break;
         }
     }
     return $order_sql;
 }
 /**
  * Adds a custom SQL join when ordering by venue or organizer is desired.
  *
  * @param string   $join_sql
  * @param wp_query $query
  *
  * @return string
  */
 public static function posts_join_venue_organizer($join_sql, $query)
 {
     // bail if this is not a query for event post type
     if ($query->get('post_type') !== Tribe__Events__Main::POSTTYPE) {
         return $join_sql;
     }
     global $wpdb;
     switch ($query->get('orderby')) {
         case 'venue':
             $join_sql .= " LEFT JOIN {$wpdb->postmeta} tribe_order_by_venue_meta ON {$wpdb->posts}.ID = tribe_order_by_venue_meta.post_id AND tribe_order_by_venue_meta.meta_key='_EventVenueID' LEFT JOIN {$wpdb->posts} tribe_order_by_venue ON tribe_order_by_venue_meta.meta_value = tribe_order_by_venue.ID ";
             break;
         case 'organizer':
             $join_sql .= " LEFT JOIN {$wpdb->postmeta} tribe_order_by_organizer_meta ON {$wpdb->posts}.ID = tribe_order_by_organizer_meta.post_id AND tribe_order_by_organizer_meta.meta_key='_EventOrganizerID' LEFT JOIN {$wpdb->posts} tribe_order_by_organizer ON tribe_order_by_organizer_meta.meta_value = tribe_order_by_organizer.ID ";
             break;
         default:
             return $join_sql;
             break;
     }
     /**
      * Ensures we add the matching corresponding code to the order clause.
      *
      * We use posts_clauses (as opposed to posts_orderby) in this case to avoid
      * it being overwritten by Tribe__Events__Admin_List methods.
      *
      * @see Tribe__Events__Admin_List
      */
     add_filter('posts_clauses', array(__CLASS__, 'posts_orderby_venue_organizer'), 100, 2);
     if (has_filter('tribe_events_query_posts_join_orderby')) {
         /**
          * Historically this filter has only been useful to modify the joins setup
          * in relation to organizers and venues. In future it may have a more general
          * application or may be removed.
          *
          * @deprecated since 4.0.2
          *
          * @var string $join_sql
          */
         $join_sql = apply_filters('tribe_events_query_posts_join_orderby', $join_sql);
         _doing_it_wrong('tribe_events_query_posts_join_orderby (filter)', 'To modify joins in relation to venues and organizers specifically you are encouraged to use the tribe_events_query_posts_join_venue_organizer hook.', '4.0.2');
     }
     /**
      * Provides an opportunity to modify the join condition added to the query when
      * ordering by venue or organizer.
      *
      * @var string $join_sql
      */
     return apply_filters('tribe_events_query_posts_join_venue_organizer', $join_sql);
 }
 /**
  * Custom SQL order by statement for Event Start Date result order.
  *
  * @param string  $order_sql
  * @param wp_query $query
  * @return string
  */
 public static function posts_orderby($order_sql, $query)
 {
     global $wpdb;
     if ($query->tribe_is_event || $query->tribe_is_event_category) {
         $order = !empty($query->order) ? $query->order : $query->get('order');
         $orderby = !empty($query->orderby) ? $query->orderby : $query->get('orderby');
         $order_sql = "DATE({$wpdb->postmeta}.meta_value) {$order}, TIME({$wpdb->postmeta}.meta_value) {$order}";
         do_action('log', 'orderby', 'default', $orderby);
         switch ($orderby) {
             case 'venue':
                 $order_sql = "tribe_order_by_venue.post_title {$order}, " . $order_sql;
                 break;
             case 'organizer':
                 $order_sql = "tribe_order_by_organizer.post_title {$order}, " . $order_sql;
                 break;
             case 'title':
                 $order_sql = "{$wpdb->posts}.post_title {$order}, " . $order_sql;
                 break;
             case 'menu_order':
                 $order_sql = "{$wpdb->posts}.menu_order ASC, " . $order_sql;
                 break;
             case 'event_date':
                 // we've already setup $order_sql
                 break;
         }
     } else {
         if ($query->tribe_is_multi_posttype) {
             if ($query->get('orderby') == 'date' || $query->get('orderby') == '') {
                 $order_sql = str_replace("{$wpdb->posts}.post_date", 'post_date', $order_sql);
             }
         }
     }
     $order_sql = apply_filters('tribe_events_query_posts_orderby', $order_sql, $query);
     return $order_sql;
 }