EEM_Event - Code Metrics - Inspection of "Daily Inspection: Removed the REST API add-on [tou..." - eventespresso/event-espresso-core - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Branch — TASK-9118-extensions-page (04eaec)

unknown
created 2016-05-26 21:32 UTC
EEM_Event F

↳ Parent: Project
Complexity

Total Complexity
Size/Duplication

Total Lines	660
Duplicated Lines	17.27 %
Coupling/Cohesion

Components	2
Dependencies	29
Importance

Changes	1
Bugs	0	Features	0
Metric	Value
c	1
b	0
f	0
dl	114
loc	660
rs	1.1478
wmc	71
lcom	2
cbo	29
16 Methods

Rating	Name	Duplication	Size	Complexity
B	__construct()	0	87	2
A	instance()	12	12	2
A	set_default_reg_status()	0	10	2
A	get_all_question_groups()	0	6	1
A	get_all_event_question_groups()	9	9	3
A	get_event_question_groups()	9	9	3
A	get_question_groups_for_event()	0	19	4
A	get_questions_in_groups()	17	17	2
A	get_options_for_question()	16	16	2
A	_generate_question_input_name()	0	54	2
C	get_active_events()	16	31	7
B	get_upcoming_events()	11	25	6
D	get_expired_events()	12	51	10
D	get_inactive_events()	12	35	9
A	add_relationship_to()	0	18	3
C	assemble_array_of_groups_questions_and_options()	0	48	13
How to fix Duplicated Code Complexity

Duplicated Code

Duplicate code is one of the most pungent code smells. A rule that is often used is to re-structure code once it is duplicated in three or more places.
Common duplication problems, and corresponding solutions are:
If you have the same expression in different places: Extract expression to a method
If you have the same method in different sub-classes: Extract method, and pull up field to the parent class
If you have the same code in unrelated classes: Consider extracting the code to a new class, and injecting that class
Complex Class

Tip: Before tackling complexity, make sure that you eliminate any duplication first. This often can reduce the size of classes significantly.
Complex classes like EEM_Event often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes. You can also have a look at the cohesion graph to spot any un-connected, or weakly-connected components.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use EEM_Event, and based on these observations, apply Extract Interface, too.
<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed');
require_once( EE_MODELS . 'EEM_CPT_Base.model.php');
/**
 *
 * EEM_Event Model
 *
 * extends EEM_CPT_Base which extends EEM_Base
 *
 * @package			Event Espresso
 * @subpackage		includes/models/
 * @author				Michael Nelson, Brent Christensen
 *
 */
class EEM_Event  extends EEM_CPT_Base{

	/**
	 * constant used by status(), indicating that no more tickets can be purchased for any of the datetimes for the event
	 */
	const sold_out = 'sold_out';

	/**
	 * constant used by status(), indicating that upcoming event dates have been postponed (may be pushed to a later date)
	 */
	const postponed = 'postponed';

	/**
	 * constant used by status(), indicating that the event will no longer occur
	 */
	const cancelled = 'cancelled';



	/**
	 * @var string
	 */
	protected static $_default_reg_status = NULL;


	/**
	 * private instance of the Event object
	 * @var EEM_Event
	 */
	protected static $_instance = NULL;



	/**
	 *        This function is a singleton method used to instantiate the EEM_Event object
	 *
	 * @access public
	 * @param string $timezone
	 * @return EEM_Event
	 */
	public static function instance( $timezone = NULL ){


		// check if instance of EEM_Event already exists
		if ( ! self::$_instance instanceof EEM_Event ) {
			// instantiate Espresso_model
			self::$_instance = new self( $timezone );
		}
		//we might have a timezone set, let set_timezone decide what to do with it
		self::$_instance->set_timezone( $timezone );
		// EEM_Event object
		return self::$_instance;
	}


	/**
	 * Adds a relationship to Term_Taxonomy for each CPT_Base
	 * @param string $timezone
	 * @return EEM_Event

	 */
	protected function __construct($timezone = null){

		EE_Registry::instance()->load_model( 'Registration' );

		$this->singular_item = __('Event','event_espresso');
		$this->plural_item = __('Events','event_espresso');

		// to remove Cancelled events from the frontend, copy the following filter to your functions.php file
		// add_filter( 'AFEE__EEM_Event__construct___custom_stati__cancelled__Public', '__return_false' );
		// to remove Postponed events from the frontend, copy the following filter to your functions.php file
		// add_filter( 'AFEE__EEM_Event__construct___custom_stati__postponed__Public', '__return_false' );
		// to remove Sold Out events from the frontend, copy the following filter to your functions.php file
		//	add_filter( 'AFEE__EEM_Event__construct___custom_stati__sold_out__Public', '__return_false' );

		$this->_custom_stati = apply_filters(
			'AFEE__EEM_Event__construct___custom_stati',
			array(
				EEM_Event::cancelled => array(
					'label' => __('Cancelled', 'event_espresso'),
					'public' => apply_filters( 'AFEE__EEM_Event__construct___custom_stati__cancelled__Public', TRUE )
				),
				EEM_Event::postponed => array(
					'label' => __('Postponed', 'event_espresso'),
					'public' => apply_filters( 'AFEE__EEM_Event__construct___custom_stati__postponed__Public', TRUE )
				),
				EEM_Event::sold_out => array(
					'label' => __('Sold Out', 'event_espresso'),
					'public' => apply_filters( 'AFEE__EEM_Event__construct___custom_stati__sold_out__Public', TRUE )
				)
			)
		);

		self::$_default_reg_status = empty( self::$_default_reg_status ) ? EEM_Registration::status_id_pending_payment : self::$_default_reg_status;

		$this->_tables = array(

			'Event_CPT'=>new EE_Primary_Table( 'posts','ID' ),
			'Event_Meta'=> new EE_Secondary_Table( 'esp_event_meta', 'EVTM_ID', 'EVT_ID' )
		);

		$this->_fields = array(

			'Event_CPT'=>array(
				'EVT_ID'=>new EE_Primary_Key_Int_Field( 'ID', __( 'Post ID for Event','event_espresso' )),
				'EVT_name'=>new EE_Plain_Text_Field( 'post_title', __( 'Event Name','event_espresso' ), FALSE, '' ),
				'EVT_desc'=>new EE_Post_Content_Field( 'post_content', __( 'Event Description', 'event_espresso' ), FALSE, '' ),
				'EVT_slug'=>new EE_Slug_Field( 'post_name', __( 'Event Slug', 'event_espresso' ), FALSE, '' ),
				'EVT_created'=>new EE_Datetime_Field( 'post_date', __( 'Date/Time Event Created', 'event_espresso' ), FALSE, time()),
				'EVT_short_desc'=>new EE_Simple_HTML_Field( 'post_excerpt', __( 'Event Short Description', 'event_espresso' ), FALSE,'' ),
				'EVT_modified'=>new EE_Datetime_Field( 'post_modified', __( 'Date/Time Event Modified', 'event_espresso' ), FALSE, time()),
				'EVT_wp_user'=>new EE_WP_User_Field( 'post_author', __( 'Event Creator ID', 'event_espresso'), FALSE),
				'parent'=>new EE_Integer_Field( 'post_parent', __( 'Event Parent ID', 'event_espresso' ), FALSE, 0 ),
				'EVT_order'=>new EE_Integer_Field( 'menu_order', __( 'Event Menu Order', 'event_espresso' ), FALSE, 1 ),
				'post_type'=>new EE_WP_Post_Type_Field('espresso_events'),// EE_Plain_Text_Field( 'post_type', __( 'Event Post Type', 'event_espresso' ), FALSE, 'espresso_events' ),
				'status' => new EE_WP_Post_Status_Field( 'post_status', __( 'Event Status', 'event_espresso' ), FALSE, 'draft', $this->_custom_stati )
			),
			'Event_Meta'=>array(
				'EVTM_ID'=> new EE_DB_Only_Float_Field( 'EVTM_ID', __( 'Event Meta Row ID','event_espresso' ), FALSE ),
				'EVT_ID_fk'=>new EE_DB_Only_Int_Field( 'EVT_ID', __( 'Foreign key to Event ID from Event Meta table', 'event_espresso' ), FALSE ),
				'EVT_display_desc'=>new EE_Boolean_Field( 'EVT_display_desc', __( 'Display Description Flag', 'event_espresso' ), FALSE, 1 ),
				'EVT_display_ticket_selector'=>new EE_Boolean_Field( 'EVT_display_ticket_selector', __( 'Display Ticket Selector Flag', 'event_espresso' ), FALSE, 1 ),
				'EVT_visible_on'=>new EE_Datetime_Field( 'EVT_visible_on', __( 'Event Visible Date', 'event_espresso' ), TRUE, time()),
				'EVT_additional_limit'=>new EE_Integer_Field( 'EVT_additional_limit', __( 'Limit of Additional Registrations on Same Transaction', 'event_espresso' ), TRUE, 10 ),
				'EVT_default_registration_status'=>new EE_Enum_Text_Field(
					'EVT_default_registration_status', __( 'Default Registration Status on this Event', 'event_espresso' ), FALSE, EEM_Event::$_default_reg_status, EEM_Registration::reg_status_array()
				),
				'EVT_member_only'=>new EE_Boolean_Field( 'EVT_member_only', __( 'Member-Only Event Flag', 'event_espresso' ), FALSE, FALSE ),
				'EVT_phone'=> new EE_Plain_Text_Field('EVT_phone', __( 'Event Phone Number', 'event_espresso' ), FALSE ),
				'EVT_allow_overflow'=>new EE_Boolean_Field(  'EVT_allow_overflow', __( 'Allow Overflow on Event', 'event_espresso' ), FALSE, FALSE ),
				'EVT_timezone_string'=>new EE_Plain_Text_Field( 'EVT_timezone_string', __( 'Timezone (name) for Event times', 'event_espresso' ), FALSE ),
				'EVT_external_URL'=>new EE_Plain_Text_Field( 'EVT_external_URL', __( 'URL of Event Page if hosted elsewhere', 'event_espresso' ), TRUE ),
				'EVT_donations'=>new EE_Boolean_Field( 'EVT_donations', __( 'Accept Donations?', 'event_espresso' ), FALSE, FALSE )

			));

		$this->_model_relations = array(

			'Registration'=>new EE_Has_Many_Relation(),
			'Datetime'=>new EE_Has_Many_Relation(),
			'Question_Group'=>new EE_HABTM_Relation('Event_Question_Group'),
			'Venue'=>new EE_HABTM_Relation('Event_Venue'),
			'Term_Taxonomy'=>new EE_HABTM_Relation('Term_Relationship'),
			'Message_Template_Group' => new EE_HABTM_Relation('Event_Message_Template'),
			'Attendee'=>new EE_HABTM_Relation('Registration'),
			'WP_User' => new EE_Belongs_To_Relation(),
		);
		//this model is generally available for reading
		$this->_cap_restriction_generators[ EEM_Base::caps_read ] = new EE_Restriction_Generator_Public();
		parent::__construct( $timezone );
	}



	/**
	 * @param string $default_reg_status
	 */
	public static function set_default_reg_status( $default_reg_status ) {
		self::$_default_reg_status = $default_reg_status;
		//if EEM_Event has already been instantiated, then we need to reset the `EVT_default_reg_status` field to use the new default.
		if ( self::$_instance instanceof EEM_Event ) {
			self::$_instance->_fields['Event_Meta']['EVT_default_registration_status'] = new EE_Enum_Text_Field(
				'EVT_default_registration_status', __( 'Default Registration Status on this Event', 'event_espresso' ), false, $default_reg_status, EEM_Registration::reg_status_array()
			);
			self::$_instance->_fields['Event_Meta']['EVT_default_registration_status']->_construct_finalize( 'Event_Meta', 'EVT_default_registration_status', 'EEM_Event' );
		}
	}



	/**
	*		get_question_groups
	*
	* 		@access		public
	*		@return 		array
	*/
	public function get_all_question_groups() {
		return EE_Registry::instance()->load_model( 'Question_Group' )->get_all( array(

			array( 'QSG_deleted' => FALSE ),
			'order_by' => array( 'QSG_order' => 'ASC' )
		));
	}






	/**
	*		get_question_groups
	*
	* 		@access		public
	* 		@param		int $EVT_ID
	*		@return 		array
	*/
	public function get_all_event_question_groups( $EVT_ID = 0 ) {

		if ( ! isset( $EVT_ID) || ! absint( $EVT_ID )) {
			EE_Error::add_error( __( 'An error occurred. No Event Question Groups could be retrieved because an Event ID was not received.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
			return FALSE;
class Author {
    private $name;

    public function __construct($name) {
        $this->name = $name;
    }

    public function getName() {
        return $this->name;
    }
}

abstract class Post {
    public function getAuthor() {
        return 'Johannes';
    }
}

class BlogPost extends Post {
    public function getAuthor() {
        return new Author('Johannes');
    }
}

class ForumPost extends Post { /* ... */ }

function my_function(Post $post) {
    echo strtoupper($post->getAuthor());
}
		}
		return EE_Registry::instance()->load_model( 'Event_Question_Group' )->get_all( array(

			array( 'EVT_ID' => $EVT_ID )
		));
	}





	/**
	*		get_question_groups
	*
	* 		@access		public
	* 		@param		int $EVT_ID
	* 		@param		boolean	$for_primary_attendee
	*		@return 		array
	*/
	public function get_event_question_groups( $EVT_ID = 0, $for_primary_attendee = TRUE ) {

		if ( ! isset( $EVT_ID) || ! absint( $EVT_ID )) {
			EE_Error::add_error( __( 'An error occurred. No Event Question Groups could be retrieved because an Event ID was not received.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
			return FALSE;
class Author {
    private $name;

    public function __construct($name) {
        $this->name = $name;
    }

    public function getName() {
        return $this->name;
    }
}

abstract class Post {
    public function getAuthor() {
        return 'Johannes';
    }
}

class BlogPost extends Post {
    public function getAuthor() {
        return new Author('Johannes');
    }
}

class ForumPost extends Post { /* ... */ }

function my_function(Post $post) {
    echo strtoupper($post->getAuthor());
}
		}
		return EE_Registry::instance()->load_model( 'Event_Question_Group' )->get_all( array(

			array( 'EVT_ID' => $EVT_ID, 'EQG_primary' => $for_primary_attendee )
		));
	}






	/**
	*		get_question_groups
	*
	* 		@access		public
	* 		@param		int $EVT_ID
	* 		@param		EE_Registration 	$registration
	*		@return 		array
	*/
	public function get_question_groups_for_event( $EVT_ID = 0, EE_Registration $registration ) {

		if ( ! isset( $EVT_ID) || ! absint( $EVT_ID )) {
			EE_Error::add_error( __( 'An error occurred. No Question Groups could be retrieved because an Event ID was not received.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
			return FALSE;
class Author {
    private $name;

    public function __construct($name) {
        $this->name = $name;
    }

    public function getName() {
        return $this->name;
    }
}

abstract class Post {
    public function getAuthor() {
        return 'Johannes';
    }
}

class BlogPost extends Post {
    public function getAuthor() {
        return new Author('Johannes');
    }
}

class ForumPost extends Post { /* ... */ }

function my_function(Post $post) {
    echo strtoupper($post->getAuthor());
}
		}

		$where_params = array(
			'Event_Question_Group.EVT_ID' => $EVT_ID,
			'Event_Question_Group.EQG_primary' => $registration->count() == 1 ? TRUE : FALSE,
			'QSG_deleted' => FALSE
		);

		return EE_Registry::instance()->load_model( 'Question_Group' )->get_all( array(

			$where_params,
			'order_by' => array('QSG_order' => 'ASC')
		));

	}







	/**
	*		get_question_target_db_column
	*
	* 		@access		public
	* 		@param		string		$QSG_IDs  csv list of $QSG IDs
	*		@return 		array
	*/
	public function get_questions_in_groups( $QSG_IDs = '' ) {


		if ( empty( $QSG_IDs )) {
			EE_Error::add_error( __( 'An error occurred. No Question Group IDs were received.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
			return FALSE;
class Author {
    private $name;

    public function __construct($name) {
        $this->name = $name;
    }

    public function getName() {
        return $this->name;
    }
}

abstract class Post {
    public function getAuthor() {
        return 'Johannes';
    }
}

class BlogPost extends Post {
    public function getAuthor() {
        return new Author('Johannes');
    }
}

class ForumPost extends Post { /* ... */ }

function my_function(Post $post) {
    echo strtoupper($post->getAuthor());
}
		}

		return EE_Registry::instance()->load_model( 'Question' )->get_all( array(

			array(
				'Question_Group.QSG_ID' => array( 'IN', $QSG_IDs ),
				'QST_deleted' => FALSE,
				'QST_admin_only' => is_admin()
			),
			'order_by' => 'QST_order'
		));

	}







	/**
	*		get_options_for_question
	*
	* 		@access		public
	* 		@param		string		$QST_IDs  csv list of $QST IDs
	*		@return 		array
	*/
	public function get_options_for_question( $QST_IDs ) {


		if ( empty( $QST_IDs )) {
			EE_Error::add_error( __( 'An error occurred. No Question IDs were received.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
			return FALSE;
class Author {
    private $name;

    public function __construct($name) {
        $this->name = $name;
    }

    public function getName() {
        return $this->name;
    }
}

abstract class Post {
    public function getAuthor() {
        return 'Johannes';
    }
}

class BlogPost extends Post {
    public function getAuthor() {
        return new Author('Johannes');
    }
}

class ForumPost extends Post { /* ... */ }

function my_function(Post $post) {
    echo strtoupper($post->getAuthor());
}
		}

		return EE_Registry::instance()->load_model( 'Question_Option' )->get_all( array(

			array(
				'Question.QST_ID' => array( 'IN', $QST_IDs ),
				'QSO_deleted' => FALSE
			),
			'order_by' => 'QSO_ID'
		));

	}



	/**
	 *        _get_question_target_db_column
	 *
	 * @access 	public
	 * @param 	EE_Registration $registration (so existing answers for registration are included)
	 * @param 	int 	$EVT_ID 	so all question groups are included for event (not just answers from registration).
	 * @throws EE_Error
	 * @return 	array
	 */
	public function assemble_array_of_groups_questions_and_options( EE_Registration $registration, $EVT_ID = 0 ) {

		if ( empty( $EVT_ID ) ) {
			throw new EE_Error( __( 'An error occurred. No EVT_ID is included.  Needed to know which question groups to retrieve.', 'event_espresso' ) );
		}

		$questions = array();

		// get all question groups for event
		$qgs = $this->get_question_groups_for_event( $EVT_ID, $registration );
		if ( !empty( $qgs ) ) {
			foreach ( $qgs as $qg ) {
			 	$qsts = $qg->questions();
			 	$questions[ $qg->ID() ] = $qg->model_field_array();
			 	$questions[ $qg->ID() ]['QSG_questions'] = array();
			 	foreach ( $qsts as $qst ) {
			 		if ( $qst->is_system_question() )
			 			continue;
			 		$answer = EEM_Answer::instance()->get_one( array( array( 'QST_ID' => $qst->ID(), 'REG_ID' => $registration->ID() ) ) );
			 		$answer = $answer instanceof EE_Answer ? $answer : EEM_Answer::instance()->create_default_object();
			 		$qst_name = $qstn_id = $qst->ID();
			 		$ans_id = $answer->ID();
			 		$qst_name = !empty( $ans_id ) ?  '[' . $qst_name . '][' . $ans_id . ']' : '[' . $qst_name . ']';
			 		$input_name = '';
			 		$input_id = sanitize_key( $qst->display_text() );
			 		$input_class = '';
			 		$questions[$qg->ID()]['QSG_questions'][$qst->ID()] = $qst->model_field_array();
		 			$questions[ $qg->ID() ]['QSG_questions'][ $qst->ID() ]['QST_input_name'] = 'qstn' . $input_name . $qst_name;
					$questions[ $qg->ID() ]['QSG_questions'][ $qst->ID() ]['QST_input_id'] = $input_id . '-' . $qstn_id;
					$questions[ $qg->ID() ]['QSG_questions'][ $qst->ID() ]['QST_input_class'] = $input_class;
					$questions[ $qg->ID() ]['QSG_questions'][ $qst->ID() ]['QST_options'] = array();
					$questions[ $qg->ID() ]['QSG_questions'][ $qst->ID() ]['qst_obj'] = $qst;
					$questions[ $qg->ID() ]['QSG_questions'][ $qst->ID() ]['ans_obj'] = $answer;

					if ( $qst->type() == 'RADIO_BTN' || $qst->type() == 'CHECKBOX' || $qst->type() == 'DROPDOWN' ) {
						$QSOs = $qst->options(TRUE,$answer->value());
						if ( is_array( $QSOs ) ) {
							foreach ( $QSOs as $QSO_ID => $QSO ) {
								$questions[ $qg->ID() ]['QSG_questions'][ $qst->ID() ]['QST_options'][ $QSO_ID ] = $QSO->model_field_array();
							}
						}
					}

			 	}
			}
		}
		return $questions;
	}







	/**
	*		_get_question_target_db_column
	*
	* 		@access		private
	* 		@param		$QST
	*		@return 		string		string
	*/
	private function _generate_question_input_name( $QST ) {

		if ( $QST->QST_system ) {
			$qst_name = $QST->QST_system;
/*			switch( $QST->QST_system ) {

				case 1 :
						$qst_name = $QST->QST_ID . '-fname';
					break;

				case 2 :
						$qst_name = $QST->QST_ID . '-lname';
					break;

				case 3 :
						$qst_name = $QST->QST_ID . '-email';
					break;

				case 4 :
						$qst_name = $QST->QST_ID . '-address';
					break;

				case 5 :
						$qst_name = $QST->QST_ID . '-address2';
					break;

				case  6  :
						$qst_name = $QST->QST_ID . '-city';
					break;

				case 7 :
						$qst_name = $QST->QST_ID . '-state';
					break;

				case 8 :
						$qst_name = $QST->QST_ID . '-zip';
					break;

				case 9 :
						$qst_name = $QST->QST_ID . '-country';
					break;

				case 10 :
						$qst_name = $QST->QST_ID . '-phone-' . $QST->QST_ID;
					break;

			}*/

		} else {
			//$qst_name = $QST->QST_ID . '-' . str_replace( array( ' ', '-', '.' ), '_', strtolower( $QST->QST_display_text ));
			$qst_name = $QST->QST_ID;
		}
		return $qst_name;
	}







	/**
	 * Gets all events that are published and have event start time earlier than now and an event end time later than now
	 *
	 * @access public
	 * @param  array  $query_params An array of query params to further filter on (note that status and DTT_EVT_start and DTT_EVT_end will be overridden)
	 * @param bool    $count whether to return the count or not (default FALSE)
	 * @return array 	EE_Event objects
	 */
	public function get_active_events( $query_params, $count = FALSE ) {
		if ( array_key_exists( 0, $query_params ) ) {
			$where_params = $query_params[0];
			unset( $query_params[0] );
		} else {
			$where_params = array();
		}

		//if we have count make sure we don't include group by
		if ( $count && isset( $query_params['group_by'] ) ) {
			unset( $query_params['group_by'] );
		}

		//let's add specific query_params for active_events - keep in mind this will override any sent status in the query AND any date queries.
		$where_params['status'] = 'publish';
		//if already have where params for DTT_EVT_start or DTT_EVT_end then append these conditions
		if ( isset( $where_params['Datetime.DTT_EVT_start'] ) ) {
			$where_params['Datetime.DTT_EVT_start******'] = array('<',  EEM_Datetime::instance()->current_time_for_query( 'DTT_EVT_start' ) );
		} else {
			$where_params['Datetime.DTT_EVT_start'] = array('<',  EEM_Datetime::instance()->current_time_for_query( 'DTT_EVT_start' ) );
		}

		if ( isset( $where_params['Datetime.DTT_EVT_end'] ) ) {
			$where_params['Datetime.DTT_EVT_end*****'] = array('>', EEM_Datetime::instance()->current_time_for_query( 'DTT_EVT_end' ) );
		} else {
			$where_params['Datetime.DTT_EVT_end'] = array('>', EEM_Datetime::instance()->current_time_for_query( 'DTT_EVT_end' ) );
		}
		$query_params[0] = $where_params;
		// don't use $query_params with count() because we don't want to include additional query clauses like "GROUP BY" 
		return $count ? $this->count( array( $where_params ), 'EVT_ID', true ) : $this->get_all( $query_params );
	}





	/**
	 * get all events that are published and have an event start time later than now
	 *
	 * @access public
	 * @param  array 	$query_params An array of query params to further filter on (Note that status and DTT_EVT_start will be overridden)
	 * @param bool    $count whether to return the count or not (default FALSE)
	 * @return array               EE_Event objects
	 */
	public function get_upcoming_events( $query_params, $count = FALSE ) {
		if ( array_key_exists( 0, $query_params ) ) {
			$where_params = $query_params[0];
			unset( $query_params[0] );
		} else {
			$where_params = array();
		}

		//if we have count make sure we don't include group by
		if ( $count && isset( $query_params['group_by'] ) ) {
			unset( $query_params['group_by'] );
		}

		//let's add specific query_params for active_events - keep in mind this will override any sent status in the query AND any date queries.
		$where_params['status'] = 'publish';
		//if there are already query_params matching DTT_EVT_start then we need to modify that to add them.
		if ( isset( $where_params['Datetime.DTT_EVT_start'] ) ) {
			$where_params['Datetime.DTT_EVT_start*****'] = array('>', EEM_Datetime::instance()->current_time_for_query( 'DTT_EVT_start' ) );
		} else {
			$where_params['Datetime.DTT_EVT_start'] = array('>', EEM_Datetime::instance()->current_time_for_query( 'DTT_EVT_start' ) );
		}
		$query_params[0] = $where_params;
		// don't use $query_params with count() because we don't want to include additional query clauses like "GROUP BY" 
		return $count ? $this->count( array( $where_params ), 'EVT_ID', true ) : $this->get_all( $query_params );
	}


	/**
	 * This only returns events that are expired.  They may still be published but all their datetimes have expired.
	 *
	 * @access public
	 * @param  array  $query_params An array of query params to further filter on (note that status and DTT_EVT_end will be overridden)
	 * @param bool    $count whether to return the count or not (default FALSE)
	 * @return array 	EE_Event objects
	 */
	public function get_expired_events( $query_params, $count = FALSE ) {

		$where_params = isset( $query_params[0] ) ? $query_params[0] : array();

		//if we have count make sure we don't include group by
		if ( $count && isset( $query_params['group_by'] ) ) {
			unset( $query_params['group_by'] );
		}

		//let's add specific query_params for active_events - keep in mind this will override any sent status in the query AND any date queries.
		if ( isset( $where_params['status'] ) ) {
			unset( $where_params['status'] );
		}
		$exclude_query = $query_params;
		if ( isset( $exclude_query[0] ) ) {
			unset( $exclude_query[0] );
		}
		$exclude_query[0] = array( 'Datetime.DTT_EVT_end' => array( '>', EEM_Datetime::instance()->current_time_for_query( 'DTT_EVT_end' ) ) );
		//first get all events that have datetimes where its not expired.
		$event_ids = $this->_get_all_wpdb_results( $exclude_query, OBJECT_K, 'Event_CPT.ID' );
		$event_ids = array_keys( $event_ids );

		//if we have any additional query_params, let's add them to the 'AND' condition
		$and_condition = array(
			'Datetime.DTT_EVT_end' => array( '<', EEM_Datetime::instance()->current_time_for_query( 'DTT_EVT_end' ) ),
			'EVT_ID' =>  array( 'NOT IN', $event_ids )
			);

		if ( isset( $where_params['OR'] ) ) {
			$and_condition['OR'] = $where_params['OR'];
			unset( $where_params['OR'] );
		}

		if ( isset( $where_params['Datetime.DTT_EVT_end'] ) ) {
			$and_condition['Datetime.DTT_EVT_end****'] = $where_params['Datetime.DTT_EVT_end'];
			unset( $where_params['Datetime.DTT_EVT_end'] );
		}

		if ( isset( $where_params['Datetime.DTT_EVT_start'] ) ) {
			$and_condition['Datetime.DTT_EVT_start'] = $where_params['Datetime.DTT_EVT_start'];
			unset( $where_params['Datetime.DTT_EVT_start'] );
		}

		//merge remaining $where params with the and conditions.
		$and_condtion = array_merge( $and_condition, $where_params );
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}

		$where_params['AND'] = $and_condition;
		$query_params[0] = $where_params;
		// don't use $query_params with count() because we don't want to include additional query clauses like "GROUP BY" 
		return $count ? $this->count( array( $where_params ), 'EVT_ID', true ) : $this->get_all( $query_params );
	}



	/**
	 * This basically just returns the events that do not have the publish status.
	 * @param  array  $query_params  An array of query params to further filter on (note that status will be overwritten)
	 * @param  boolean $count        whether to return the count or not (default FALSE)
	 * @return EE_Event[]            array of EE_Event objects
	 */
	public function get_inactive_events( $query_params, $count = FALSE ) {
		$where_params = isset( $query_params[0] ) ? $query_params[0] : array();

		//let's add in specific query_params for inactive events.
		if ( isset( $where_params['status'] ) ) {
			unset( $where_params['status'] );
		}

		//if we have count make sure we don't include group by
		if ( $count && isset( $query_params['group_by'] ) ) {
			unset( $query_params['group_by'] );
		}

		//if we have any additional query_params, let's add them to the 'AND' condition
		$where_params['AND']['status'] = array( '!=', 'publish' );

		if ( isset( $where_params['OR'] ) ) {
			$where_params['AND']['OR'] = $where_params['OR'];
			unset( $where_params['OR'] );
		}

		if ( isset( $where_params['Datetime.DTT_EVT_end'] ) ) {
			$where_params['AND']['Datetime.DTT_EVT_end****'] = $where_params['Datetime.DTT_EVT_end'];
			unset( $where_params['Datetime.DTT_EVT_end'] );
		}

		if ( isset( $where_params['Datetime.DTT_EVT_start'] ) ) {
			$where_params['AND']['Datetime.DTT_EVT_start'] = $where_params['Datetime.DTT_EVT_start'];
			unset( $where_params['Datetime.DTT_EVT_start'] );
		}

		$query_params[0] = $where_params;
		// don't use $query_params with count() because we don't want to include additional query clauses like "GROUP BY" 
		return $count ? $this->count( array( $where_params ), 'EVT_ID', true ) : $this->get_all( $query_params );
	}


	/**
	 * This is just injecting into the parent add_relationship_to so we do special handling on price relationships because we don't want to override any existing global default prices but instead insert NEW prices that get attached to the event.
	 * See parent for param descriptions
	 */
	public function add_relationship_to($id_or_obj,$other_model_id_or_obj, $relationName, $where_query = array()){

		if ( $relationName == 'Price' ) {
			//let's get the PRC object for the given ID to make sure that we aren't dealing with a default
			$prc_chk = $this->get_related_model_obj($relationName)->ensure_is_obj($other_model_id_or_obj);
			//if EVT_ID = 0, then this is a default
			if ( $prc_chk->get('EVT_ID') == 0 ) {
				//let's set the prc_id as 0 so we force an insert on the add_relation_to carried out by relation
				$prc_chk->set('PRC_ID', 0);
			}

			//run parent
			return parent::add_relationship_to($id_or_obj, $prc_chk, $relationName, $where_query);
		}

		//otherwise carry on as normal
		return parent::add_relationship_to($id_or_obj,$other_model_id_or_obj, $relationName, $where_query);
	}



}
// End of file EEM_Event.model.php
// Location: /includes/models/EEM_Event.model.php

eventespresso / event-espresso-core
