EEM_Registration - Code Metrics - Inspection of "Daily Inspection: Merge branch 'master' into BUG-9..." - eventespresso/event-espresso-core - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — BUG-9962-improper-sprintf-usag... (604098)

unknown

created 2016-08-11 21:27 UTC

EEM_Registration D

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	677
Duplicated Lines	14.92 %

Coupling/Cohesion

Components	2
Dependencies	23

Importance

Changes

Metric	Value
dl	101
loc	677
rs	4.5042
c	0
b	0
f	0
wmc	40
lcom	2
cbo	23

20 Methods

Rating	Name	Duplication	Size	Complexity
A	reg_status_array()	0	4	2
A	_get_registration_status_array()	0	17	4
A	get_reg_months_and_years()	0	10	1
A	get_all_registrations_for_attendee()	0	6	2
A	get_registration_for_reg_url_link()	0	6	2
A	get_registration_for_transaction_attendee()	0	9	1
B	get_registrations_per_day_report()	0	24	2
B	get_registrations_per_day_and_per_status_report()	52	52	4
A	get_registrations_per_event_report()	0	23	2
B	get_registrations_per_event_and_per_status_report()	49	49	4
A	get_primary_registration_for_transaction_ID()	0	6	2
A	get_event_registration_count()	0	9	2
A	delete_registrations_with_no_transaction()	0	6	1
A	count_registrations_checked_into_datetime()	0	23	1
B	count_registrations_checked_into_event()	0	25	1
B	get_latest_registration_for_each_of_given_contacts()	0	52	5
B	__construct()	0	43	1
A	reg_statuses_that_allow_payment()	0	10	1
A	active_reg_statuses()	0	11	1
A	inactive_reg_statuses()	0	10	1

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_Registration 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_Registration, 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_Soft_Delete_Base.model.php' );
require_once ( EE_CLASSES . 'EE_Registration.class.php' );
/**
 *
 * Registration Model
 *
 * @package			Event Espresso
 * @subpackage		includes/models/
 * @author				Mike Nelson, Brent Christensen
 *
 * ------------------------------------------------------------------------
 */
class EEM_Registration extends EEM_Soft_Delete_Base {

  	// private instance of the Registration object
	protected static $_instance = NULL;

	/**
	 * Keys are the status IDs for registrations (eg, RAP, RCN, etc), and the values
	 * are status codes (eg, approved, cancelled, etc)
	 * @var array
	 */
	private static $_reg_status;

	/**
	 * The value of REG_count for a primary registrant
	 */
	const PRIMARY_REGISTRANT_COUNT = 1;

	/**
	 * Status ID (STS_ID on esp_status table) to indicate an INCOMPLETE registration.
	 * Initial status for registrations when they are first created
	 * Payments are NOT allowed.
	 * Automatically toggled to whatever the default Event registration status is upon completion of the attendee information reg step
	 * NO space reserved.
	 * Registration is NOT active
	 */
	const status_id_incomplete = 'RIC';

	/**
	 * Status ID (STS_ID on esp_status table) to indicate an UNAPPROVED registration.
	 * Payments are NOT allowed.
	 * Event Admin must manually toggle STS_ID for it to change
	 * No space reserved.
	 * Registration is active
	 */
	const status_id_not_approved = 'RNA';

	/**
	 * Status ID (STS_ID on esp_status table) to indicate registration is PENDING_PAYMENT .
	 * Payments are allowed.
	 * STS_ID will automatically be toggled to RAP if payment is made in full by the attendee
	 * No space reserved.
	 * Registration is active
	 */
	const status_id_pending_payment = 'RPP';

	/**
	 * Status ID (STS_ID on esp_status table) to indicate registration is on the WAIT_LIST .
	 * Payments are allowed.
	 * STS_ID will automatically be toggled to RAP if payment is made in full by the attendee
	 * No space reserved.
	 * Registration is active
	 */
	const status_id_wait_list = 'RWL';

	/**
	 * Status ID (STS_ID on esp_status table) to indicate an APPROVED registration.
	 * the TXN may or may not be completed ( paid in full )
	 * Payments are allowed.
	 * A space IS reserved.
	 * Registration is active
	 */
	const status_id_approved = 'RAP';

	/**
	 * Status ID (STS_ID on esp_status table) to indicate a registration was CANCELLED by the attendee.
	 * Payments are NOT allowed.
	 * NO space reserved.
	 * Registration is NOT active
	 */
	const status_id_cancelled = 'RCN';

	/**
	 * Status ID (STS_ID on esp_status table) to indicate a registration was DECLINED by the Event Admin
	 * Payments are NOT allowed.
	 * No space reserved.
	 * Registration is NOT active
	 */
	const status_id_declined = 'RDC';



	/**
	 *    private constructor to prevent direct creation
	 *
	 * @Constructor
	 * @access protected
	 * @param string $timezone string representing the timezone we want to set for returned Date Time Strings (and any incoming timezone data that gets saved).
	 *    Note this just sends the timezone info to the date time model field objects.  Default is NULL (and will be assumed using the set timezone in the 'timezone_string' wp option)
	 * @return \EEM_Registration

	 */
	protected function __construct( $timezone = null ) {
		$this->singular_item = __('Registration','event_espresso');
		$this->plural_item = __('Registrations','event_espresso');

		$this->_tables = array(

			'Registration'=>new EE_Primary_Table('esp_registration','REG_ID')
		);
		$this->_fields = array(

			'Registration'=>array(
				'REG_ID'=>new EE_Primary_Key_Int_Field('REG_ID', __('Registration ID','event_espresso')),
				'EVT_ID'=>new EE_Foreign_Key_Int_Field('EVT_ID', __('Event ID','event_espresso'), false, 0, 'Event'),
				'ATT_ID'=>new EE_Foreign_Key_Int_Field('ATT_ID', __('Attendee ID','event_espresso'), false, 0, 'Attendee'),
				'TXN_ID'=>new EE_Foreign_Key_Int_Field('TXN_ID', __('Transaction ID','event_espresso'), false, 0, 'Transaction'),
				'TKT_ID'=>new EE_Foreign_Key_Int_Field('TKT_ID', __('Ticket ID','event_espresso'), false, 0, 'Ticket'),
				'STS_ID'=>new EE_Foreign_Key_String_Field('STS_ID', __('Status ID','event_espresso'), false, EEM_Registration::status_id_incomplete, 'Status'),
				'REG_date'=>new EE_Datetime_Field('REG_date', __('Time registration occurred','event_espresso'), false, time(), $timezone ),
				'REG_final_price'=>new EE_Money_Field('REG_final_price', __('Registration\'s share of the transaction total','event_espresso'), false, 0),
				'REG_paid'=>new EE_Money_Field('REG_paid', __('Amount paid to date towards registration','event_espresso'), false, 0),
				'REG_session'=>new EE_Plain_Text_Field('REG_session', __('Session ID of registration','event_espresso'), false, ''),
				'REG_code'=>new EE_Plain_Text_Field('REG_code', __('Unique Code for this registration','event_espresso'), false, ''),
				'REG_url_link'=>new EE_Plain_Text_Field('REG_url_link', __('String to be used in URL for identifying registration','event_espresso'), false, ''),
				'REG_count'=>new EE_Integer_Field('REG_count', __('Count of this registration in the group registration ','event_espresso'), true, 1),
				'REG_group_size'=>new EE_Integer_Field('REG_group_size', __('Number of registrations on this group','event_espresso'), false, 1),
				'REG_att_is_going'=>new EE_Boolean_Field('REG_att_is_going', __('Flag indicating the registrant plans on attending','event_espresso'), false, false),
				'REG_deleted' => new EE_Trashed_Flag_Field('REG_deleted', __('Flag indicating if registration has been archived or not.', 'event_espresso'), false, false )
			)
		);
		$this->_model_relations = array(

			'Event'=>new EE_Belongs_To_Relation(),
			'Attendee'=>new EE_Belongs_To_Relation(),
			'Transaction'=>new EE_Belongs_To_Relation(),
			'Ticket'=>new EE_Belongs_To_Relation(),
			'Status'=>new EE_Belongs_To_Relation(),
			'Answer'=>new EE_Has_Many_Relation(),
			'Checkin'=>new EE_Has_Many_Relation(),
			'Registration_Payment' => new EE_Has_Many_Relation(),
			'Payment'=>new EE_HABTM_Relation( 'Registration_Payment' ),
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
			'Message' => new EE_Has_Many_Any_Relation( false ) //allow deletes even if there are messages in the queue related
		);
		$this->_model_chain_to_wp_user = 'Event';

		parent::__construct( $timezone );

	}



	/**
	 * reg_statuses_that_allow_payment
	 * a filterable list of registration statuses that allow a registrant to make a payment
	 *
	 * @access public
	 * @return array
	 */
	public static function reg_statuses_that_allow_payment() {
		return apply_filters(
			'FHEE__EEM_Registration__reg_statuses_that_allow_payment',
			array(
				EEM_Registration::status_id_approved,
				EEM_Registration::status_id_pending_payment,
				EEM_Registration::status_id_wait_list,
			)
		);
	}



	/**
	 * inactive_reg_statuses
	 * a filterable list of registration statuses that are not considered active
	 *
	 * @access public
	 * @return array
	 */
	public static function active_reg_statuses() {
		return apply_filters(
			'FHEE__EEM_Registration__reg_statuses_that_allow_payment',
			array(
				EEM_Registration::status_id_approved,
				EEM_Registration::status_id_pending_payment,
				EEM_Registration::status_id_wait_list,
				EEM_Registration::status_id_not_approved,
			)
		);
	}



	/**
	 * inactive_reg_statuses
	 * a filterable list of registration statuses that are not considered active
	 *
	 * @access public
	 * @return array
	 */
	public static function inactive_reg_statuses() {
		return apply_filters(
			'FHEE__EEM_Registration__reg_statuses_that_allow_payment',
			array(
				EEM_Registration::status_id_incomplete,
				EEM_Registration::status_id_cancelled,
				EEM_Registration::status_id_declined,
			)
		);
	}



	/**
	 * 		get list of registration statuses
	 *
	 *
	 *		@access public
	 *		@param array $exclude The status ids to exclude from the returned results
	 *		@param bool  $translated If true will return the values as singular localized strings
	 *		@return array
	 */
	public static function reg_status_array( $exclude = array(), $translated = FALSE ) {
		EEM_Registration::instance()->_get_registration_status_array( $exclude );
		return $translated ? EEM_Status::instance()->localized_status( self::$_reg_status, FALSE, 'sentence') : self::$_reg_status;
	}



	/**
	 * 	get list of registration statuses
	 * @access private
	 * @param array $exclude
	 * @return array
	 */
	private function _get_registration_status_array( $exclude = array() ) {
		//in the very rare circumstance that we are deleting a model's table's data
		//and the table hasn't actually been created, this could have an error
		/** @type WPDB $wpdb */
		global $wpdb;
		if( EEH_Activation::table_exists( $wpdb->prefix . 'esp_status' ) ){
			$SQL = 'SELECT STS_ID, STS_code FROM '. $wpdb->prefix . 'esp_status WHERE STS_type = "registration"';
			$results = $wpdb->get_results( $SQL );
			self::$_reg_status = array();
			foreach ( $results as $status ) {
				if ( ! in_array( $status->STS_ID, $exclude )) {
					self::$_reg_status[ $status->STS_ID ] = $status->STS_code;
				}
			}
		}

	}




	/**
	 * This returns a wpdb->results array of all registration date month and years matching the incoming query params and grouped by month and year.
	 * @param  array  $where_params Array of query_params as described in the comments for EEM_Base::get_all()
	 * @return wpdb results array
	 */
	public function get_reg_months_and_years( $where_params ) {
		$query_params[0] = $where_params;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
		$query_params['group_by'] = array('reg_year', 'reg_month');
		$query_params['order_by'] = array( 'REG_date' => 'DESC' );
		$columns_to_select = array(
			'reg_year' => array('YEAR(REG_date)', '%s'),
			'reg_month' => array('MONTHNAME(REG_date)', '%s')
			);
		return $this->_get_all_wpdb_results( $query_params, OBJECT, $columns_to_select );
	}




	/**
	*		retrieve ALL registrations for a particular Attendee from db
	* 		@access		public
	* 		@param		int		$ATT_ID
	*		@return 	EE_Registration[]
	*/
	public function get_all_registrations_for_attendee( $ATT_ID = 0 ) {
		if ( ! $ATT_ID ) {
			return FALSE;
		}
		return $this->get_all( array( array( 'ATT_ID' => $ATT_ID )));
	}



	/**
	 * Gets a registration given their REG_url_link. Yes, this should usually
	 * be passed via a GET parameter.
	 * @param string $REG_url_link
	 * @return EE_Registration
	 */
	public function get_registration_for_reg_url_link($REG_url_link){
		if(!$REG_url_link){
			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 $this->get_one(array(array('REG_url_link'=>$REG_url_link)));
	}




	/**
	*		retrieve registration for a specific transaction attendee from db
	*
	* 		@access		public
	* 		@param	int	$TXN_ID
	* 		@param    int		$ATT_ID
	* 		@param    int		$att_nmbr 	in case the ATT_ID is the same for multiple registrations (same details used) then the attendee number is required
	*		@return 		mixed		array on success, FALSE on fail
	*/
	public function get_registration_for_transaction_attendee( $TXN_ID = 0, $ATT_ID = 0, $att_nmbr = 0 ) {
		return $this->get_one(array(
			array(
				'TXN_ID'=>$TXN_ID,
				'ATT_ID'=>$ATT_ID
			),
			'limit'=>array( min( ( $att_nmbr-1 ), 0 ), 1 )
		));
	}


	/**
	*		get the number of registrations per day  for the Registration Admin page Reports Tab.
	 *		(doesn't utilize models because it's a fairly specialized query)
	* 		@access		public
	 *		@param $period string which can be passed to php's strtotime function (eg "-1 month")
	 *		@return stdClass[] with properties regDate and total
	*/
	public function get_registrations_per_day_report( $period = '-1 month' ) {

		$sql_date = $this->convert_datetime_for_query( 'REG_date', date("Y-m-d H:i:s", strtotime($period) ), 'Y-m-d H:i:s', 'UTC' );
		$where = array( 'REG_date' => array( '>=', $sql_date ), 'STS_ID' => array( '!=', EEM_Registration::status_id_incomplete ) );

		if ( ! EE_Registry::instance()->CAP->current_user_can( 'ee_read_others_registrations', 'reg_per_day_report' ) ) {
			$where['Event.EVT_wp_user'] = get_current_user_id();
		}

		$query_interval = EEH_DTT_Helper::get_sql_query_interval_for_offset( $this->get_timezone(), 'REG_date' );

		$results = $this->_get_all_wpdb_results(
				array(
					$where,
					'group_by'=>'regDate',
					'order_by'=>array('REG_date'=>'ASC')
				),
				OBJECT,
				array(
					'regDate'=>array( 'DATE(' . $query_interval . ')','%s'),
					'total'=>array('count(REG_ID)','%d')
				));
		return $results;
	}


	/**
	 * Get the number of registrations per day including the count of registrations for each Registration Status.
	 * Note: EEM_Registration::status_id_incomplete registrations are excluded from the results.
	 *
	 * @param string $period
	 *
	 * @return stdClass[] with properties Registration_REG_date and a column for each registration status as the STS_ID
	 *                    (i.e. RAP)
	 */
	public function get_registrations_per_day_and_per_status_report( $period = '-1 month' ) {

		global $wpdb;
		$registration_table = $wpdb->prefix . 'esp_registration';
		$event_table = $wpdb->posts;
		$sql_date = date("Y-m-d H:i:s", strtotime($period) );

		//prepare the query interval for displaying offset
		$query_interval = EEH_DTT_Helper::get_sql_query_interval_for_offset( $this->get_timezone(), 'dates.REG_date' );

		//inner date query
		$inner_date_query = "SELECT DISTINCT REG_date from $registration_table ";
		$inner_where = " WHERE";
		//exclude events not authored by user if permissions in effect
		if ( ! EE_Registry::instance()->CAP->current_user_can( 'ee_read_others_registrations', 'reg_per_event_report' ) ) {
			$inner_date_query .= "LEFT JOIN $event_table ON ID = EVT_ID";
			$inner_where .= " post_author = " . get_current_user_id() . " AND";
		}
		$inner_where .= " REG_date >= '$sql_date'";
		$inner_date_query .= $inner_where;

		//start main query
		$select = "SELECT DATE($query_interval) as Registration_REG_date, ";
		$join = '';
		$join_parts = array();
		$select_parts = array();

		//loop through registration stati to do parts for each status.
		foreach ( EEM_Registration::reg_status_array() as $STS_ID => $STS_code ) {
			if ( $STS_ID === EEM_Registration::status_id_incomplete ) {
				continue;
			}
			$select_parts[] = "COUNT($STS_code.REG_ID) as $STS_ID";
			$join_parts[] = "$registration_table AS $STS_code ON $STS_code.REG_date = dates.REG_date AND $STS_code.STS_ID = '$STS_ID'";
		}

		//setup the selects
		$select .= implode(', ', $select_parts );
		$select .= " FROM ($inner_date_query) AS dates LEFT JOIN ";

		//setup the joins
		$join .= implode( " LEFT JOIN ", $join_parts );

		//now let's put it all together
		$query = $select . $join . ' GROUP BY Registration_REG_date';

		//and execute it
		$results = $wpdb->get_results(
			$query,
			ARRAY_A
		);
		return $results;
	}






	/**
	*		get the number of registrations per event  for the Registration Admin page Reports Tab
	* 		@access		public
	 * @param $period string which can be passed to php's strtotime function (eg "-1 month")
	 *		@return stdClass[] each with properties event_name, reg_limit, and total
	*/
	public function get_registrations_per_event_report( $period = '-1 month' ) {

		$date_sql = $this->convert_datetime_for_query( 'REG_date', date( "Y-m-d H:i:s", strtotime( $period )), 'Y-m-d H:i:s', 'UTC' );
		$where = array( 'REG_date' => array( '>=', $date_sql ), 'STS_ID' => array( '!=', EEM_Registration::status_id_incomplete ) );

		if ( ! EE_Registry::instance()->CAP->current_user_can( 'ee_read_others_registrations', 'reg_per_event_report' ) ) {
			$where['Event.EVT_wp_user'] = get_current_user_id();
		}
		$results = $this->_get_all_wpdb_results(array(
			$where,
			'group_by'=>'Event.EVT_name',
			'order_by'=>'Event.EVT_name',
			'limit'=>array(0,24)),
			OBJECT,
			array(
				'event_name'=>array('Event_CPT.post_title','%s'),
				'total'=>array('COUNT(REG_ID)','%s')
			)
		);

		return $results;

	}


	/**
	 * Get the number of registrations per event grouped by registration status.
	 * Note: EEM_Registration::status_id_incomplete registrations are excluded from the results.
	 *
	 * @param string $period
	 *
	 * @return stdClass[] with properties `Registration_Event` and a column for each registration status as the STS_ID
	 *                    (i.e. RAP)
	 */
	public function get_registrations_per_event_and_per_status_report( $period = '-1 month' ) {

		global $wpdb;
		$registration_table = $wpdb->prefix . 'esp_registration';
		$event_table = $wpdb->posts;
		$sql_date = date("Y-m-d H:i:s", strtotime($period) );

		//inner date query
		$inner_date_query = "SELECT DISTINCT EVT_ID, REG_date from $registration_table ";
		$inner_where = " WHERE";
		//exclude events not authored by user if permissions in effect
		if ( ! EE_Registry::instance()->CAP->current_user_can( 'ee_read_others_registrations', 'reg_per_event_report' ) ) {
			$inner_date_query .= "LEFT JOIN $event_table ON ID = EVT_ID";
			$inner_where .= " post_author = " . get_current_user_id() . " AND";
		}
		$inner_where .= " REG_date >= '$sql_date'";
		$inner_date_query .= $inner_where;

		//build main query
		$select = "SELECT Event.post_title as Registration_Event, ";
		$join = '';
		$join_parts = array();
		$select_parts = array();

		//loop through registration stati to do parts for each status.
		foreach ( EEM_Registration::reg_status_array() as $STS_ID => $STS_code ) {
			if ( $STS_ID === EEM_Registration::status_id_incomplete ) {
				continue;
			}
			$select_parts[] = "COUNT($STS_code.REG_ID) as $STS_ID";
			$join_parts[] = "$registration_table AS $STS_code ON $STS_code.EVT_ID = dates.EVT_ID AND $STS_code.STS_ID = '$STS_ID' AND $STS_code.REG_date = dates.REG_date";
		}

		//setup the selects
		$select .= implode( ', ', $select_parts );
		$select .= " FROM ($inner_date_query) AS dates LEFT JOIN $event_table as Event ON Event.ID = dates.EVT_ID LEFT JOIN ";

		//setup remaining joins
		$join .= implode( " LEFT JOIN ", $join_parts );

		//now put it all together
		$query = $select . $join . ' GROUP BY Registration_Event';

		//and execute
		$results = $wpdb->get_results(
			$query,
			ARRAY_A
		);
		return $results;
	}


	/**
	 * Returns the EE_Registration of the primary attendee on the transaction id provided
	 * @param int $TXN_ID
	 * @return EE_Registration
	 */
	public function get_primary_registration_for_transaction_ID( $TXN_ID = 0){
		if( ! $TXN_ID ){
			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 $this->get_one(array(array('TXN_ID'=>$TXN_ID,'REG_count'=>  EEM_Registration::PRIMARY_REGISTRANT_COUNT)));
	}


	/**
	 *		get_event_registration_count
	 *
	 *		@access public
	 *		@param int $EVT_ID
	 *		@param boolean $for_incomplete_payments
	 *		@return int
	 */
	public function get_event_registration_count ( $EVT_ID, $for_incomplete_payments = FALSE ) {
		// we only count approved registrations towards registration limits
		$query_params = array( array( 'EVT_ID' => $EVT_ID, 'STS_ID' => self::status_id_approved ) );
		if( $for_incomplete_payments ){
			$query_params[0]['Transaction.STS_ID']=array('!=',  EEM_Transaction::complete_status_code);
		}

		return $this->count($query_params);
	}

	/**
	 * Deletes all registrations with no transactions. Note that this needs to be very efficient
	 * and so it uses wpdb directly
	 * @global WPDB $wpdb
	 * @return int number deleted
	 */
	public function delete_registrations_with_no_transaction() {
		/** @type WPDB $wpdb */
		global $wpdb;
		return $wpdb->query(
				'DELETE r FROM ' . $this->table() . ' r LEFT JOIN ' . EEM_Transaction::instance()->table() . ' t ON r.TXN_ID = t.TXN_ID WHERE t.TXN_ID IS NULL' );
	}

	/**
	 *  Count registrations checked into (or out of) a datetime
	 *
	 * @param int $DTT_ID datetime ID
	 * @param boolean $checked_in whether to count registrations checked IN or OUT
	 * @return int
	 */
	public function count_registrations_checked_into_datetime( $DTT_ID, $checked_in = true) {
		global $wpdb;
		//subquery to get latest checkin
		$query = $wpdb->prepare(
			'SELECT '
				. 'COUNT( DISTINCT checkins.REG_ID ) '
			. 'FROM ' . EEM_Checkin::instance()->table() . ' AS checkins INNER JOIN'
				. '( SELECT '
					. 'max( CHK_timestamp ) AS latest_checkin, '
					. 'REG_ID AS REG_ID '
				. 'FROM ' . EEM_Checkin::instance()->table() . ' '
				. 'WHERE DTT_ID=%d '
				. 'GROUP BY REG_ID'
			. ') AS most_recent_checkin_per_reg '
			. 'ON checkins.REG_ID=most_recent_checkin_per_reg.REG_ID '
				. 'AND checkins.CHK_timestamp = most_recent_checkin_per_reg.latest_checkin '
			. 'WHERE '
				. 'checkins.CHK_in=%d',
			$DTT_ID,
			$checked_in
		);
		return (int)$wpdb->get_var( $query );
	}

	/**
	 *  Count registrations checked into (or out of) an event.
	 *
	 * @param int $EVT_ID event ID
	 * @param boolean $checked_in whether to count registrations checked IN or OUT
	 * @return int
	 */
	public function count_registrations_checked_into_event( $EVT_ID, $checked_in = true ) {
		global $wpdb;
		//subquery to get latest checkin
		$query = $wpdb->prepare(
			'SELECT '
				. 'COUNT( DISTINCT checkins.REG_ID ) '
			. 'FROM ' . EEM_Checkin::instance()->table() . ' AS checkins INNER JOIN'
				. '( SELECT '
					. 'max( CHK_timestamp ) AS latest_checkin, '
					. 'REG_ID AS REG_ID '
				. 'FROM ' . EEM_Checkin::instance()->table() . ' AS c '
				. 'INNER JOIN ' . EEM_Datetime::instance()->table() . ' AS d '
				. 'ON c.DTT_ID=d.DTT_ID '
				. 'WHERE d.EVT_ID=%d '
				. 'GROUP BY REG_ID'
			. ') AS most_recent_checkin_per_reg '
			. 'ON checkins.REG_ID=most_recent_checkin_per_reg.REG_ID '
				. 'AND checkins.CHK_timestamp = most_recent_checkin_per_reg.latest_checkin '
			. 'WHERE '
				. 'checkins.CHK_in=%d',
			$EVT_ID,
			$checked_in
		);
		return (int)$wpdb->get_var( $query );
	}





	/**
	 * The purpose of this method is to retrieve an array of
	 * EE_Registration objects that represent the latest registration
	 * for each ATT_ID given in the function argument.
	 *
	 * @param array $attendee_ids
	 * @return EE_Registration[]
	 */
	public function get_latest_registration_for_each_of_given_contacts( $attendee_ids = array() ) {
		//first do a native wp_query to get the latest REG_ID's matching these attendees.
		global $wpdb;
		$registration_table = $wpdb->prefix . 'esp_registration';
		$attendee_table = $wpdb->posts;
		$attendee_ids = is_array( $attendee_ids )
			? array_map( 'absint', $attendee_ids )
			: array( (int) $attendee_ids );
		$attendee_ids = implode( ',', $attendee_ids );


		//first we do a query to get the registration ids
		// (because a group by before order by causes the order by to be ignored.)
		$registration_id_query = "
			SELECT registrations.registration_ids as registration_id
			FROM (
				SELECT
					Attendee.ID as attendee_ids,
					Registration.REG_ID as registration_ids
				FROM $registration_table AS Registration
				JOIN $attendee_table AS Attendee
					ON Registration.ATT_ID = Attendee.ID
					AND Attendee.ID IN ( $attendee_ids )
				ORDER BY Registration.REG_ID DESC
			  ) AS registrations
			  GROUP BY registrations.attendee_ids
		";

		$registration_ids = $wpdb->get_results(
			$registration_id_query,
			ARRAY_A
		);

		if ( empty( $registration_ids ) ) {
			return array();
		}

		$ids_for_model_query = array();
		//let's flatten the ids so they can be used in the model query.
		foreach ( $registration_ids as $registration_id ) {
			if ( isset( $registration_id['registration_id'] ) ) {
				$ids_for_model_query[] = $registration_id['registration_id'];
			}
		}

		//construct query
		$_where = array(
			'REG_ID' => array( 'IN', $ids_for_model_query )
		);

		return $this->get_all( array( $_where ) );
	}



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


eventespresso / event-espresso-core