@@ -59,7 +59,7 @@ |
||
59 | 59 | * @param array $props_n_values incoming values from the database |
60 | 60 | * @param string $timezone incoming timezone as set by the model. If not set the timezone for |
61 | 61 | * the website will be used. |
62 | - * @return EE_Attendee |
|
62 | + * @return EE_Currency_Payment_Method |
|
63 | 63 | */ |
64 | 64 | public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
65 | 65 | return new self( $props_n_values, TRUE, $timezone ); |
@@ -1,7 +1,8 @@ |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
4 | 4 | exit('No direct script access allowed'); |
5 | +} |
|
5 | 6 | /** |
6 | 7 | * Event Espresso |
7 | 8 | * |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) |
|
4 | 4 | exit('No direct script access allowed'); |
5 | 5 | |
6 | 6 | /** |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | * |
27 | 27 | * ------------------------------------------------------------------------ |
28 | 28 | */ |
29 | -class EE_Currency_Payment_Method extends EE_Base_Class{ |
|
29 | +class EE_Currency_Payment_Method extends EE_Base_Class { |
|
30 | 30 | |
31 | 31 | /** Currency to Payment Method Link ID @var CPM_ID*/ |
32 | 32 | protected $_CPM_ID = NULL; |
@@ -48,9 +48,9 @@ discard block |
||
48 | 48 | * date_format and the second value is the time format |
49 | 49 | * @return EE_Attendee |
50 | 50 | */ |
51 | - public static function new_instance( $props_n_values = array(), $timezone = null, $date_formats = array() ) { |
|
52 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone, $date_formats ); |
|
53 | - return $has_object ? $has_object : new self( $props_n_values, false, $timezone, $date_formats ); |
|
51 | + public static function new_instance($props_n_values = array(), $timezone = null, $date_formats = array()) { |
|
52 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone, $date_formats); |
|
53 | + return $has_object ? $has_object : new self($props_n_values, false, $timezone, $date_formats); |
|
54 | 54 | } |
55 | 55 | |
56 | 56 | |
@@ -61,8 +61,8 @@ discard block |
||
61 | 61 | * the website will be used. |
62 | 62 | * @return EE_Attendee |
63 | 63 | */ |
64 | - public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
|
65 | - return new self( $props_n_values, TRUE, $timezone ); |
|
64 | + public static function new_instance_from_db($props_n_values = array(), $timezone = null) { |
|
65 | + return new self($props_n_values, TRUE, $timezone); |
|
66 | 66 | } |
67 | 67 | |
68 | 68 | } |
@@ -46,7 +46,7 @@ |
||
46 | 46 | * @param array $props_n_values incoming values from the database |
47 | 47 | * @param string $timezone incoming timezone as set by the model. If not set the timezone for |
48 | 48 | * the website will be used. |
49 | - * @return EE_Attendee |
|
49 | + * @return EE_Datetime_Ticket |
|
50 | 50 | */ |
51 | 51 | public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
52 | 52 | return new self( $props_n_values, TRUE, $timezone ); |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -35,9 +35,9 @@ discard block |
||
35 | 35 | * date_format and the second value is the time format |
36 | 36 | * @return EE_Attendee |
37 | 37 | */ |
38 | - public static function new_instance( $props_n_values = array(), $timezone = null, $date_formats = array() ) { |
|
39 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone, $date_formats ); |
|
40 | - return $has_object ? $has_object : new self( $props_n_values, false, $timezone, $date_formats ); |
|
38 | + public static function new_instance($props_n_values = array(), $timezone = null, $date_formats = array()) { |
|
39 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone, $date_formats); |
|
40 | + return $has_object ? $has_object : new self($props_n_values, false, $timezone, $date_formats); |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | |
@@ -48,7 +48,7 @@ discard block |
||
48 | 48 | * the website will be used. |
49 | 49 | * @return EE_Attendee |
50 | 50 | */ |
51 | - public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
|
52 | - return new self( $props_n_values, TRUE, $timezone ); |
|
51 | + public static function new_instance_from_db($props_n_values = array(), $timezone = null) { |
|
52 | + return new self($props_n_values, TRUE, $timezone); |
|
53 | 53 | } |
54 | 54 | } //end EE_Datetime_Ticket class |
@@ -69,7 +69,7 @@ discard block |
||
69 | 69 | /** |
70 | 70 | * @Export Event Espresso data - routes export requests |
71 | 71 | * @access public |
72 | - * @return void | bool |
|
72 | + * @return false|null | bool |
|
73 | 73 | */ |
74 | 74 | public function export() { |
75 | 75 | |
@@ -605,7 +605,7 @@ discard block |
||
605 | 605 | * @recursive function for exporting table data and merging the results with the next results |
606 | 606 | * @access private |
607 | 607 | * @param array $models_to_export keys are model names (eg 'Event', 'Attendee', etc.) and values are arrays of query params like on EEM_Base::get_all |
608 | - * @return array on success, FALSE on fail |
|
608 | + * @return boolean on success, FALSE on fail |
|
609 | 609 | */ |
610 | 610 | private function _get_export_data_for_models( $models_to_export = array() ) { |
611 | 611 | $table_data = FALSE; |
@@ -1,4 +1,6 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
3 | 5 | /** |
4 | 6 | * EE_Export class |
@@ -256,10 +258,10 @@ discard block |
||
256 | 258 | if( $field_name == 'STA_ID' ){ |
257 | 259 | $state_name_field = EEM_State::instance()->field_settings_for( 'STA_name' ); |
258 | 260 | $csv_row[ __( 'State', 'event_espresso' ) ] = $attendee_row[ $state_name_field->get_qualified_column() ]; |
259 | - }elseif( $field_name == 'CNT_ISO' ){ |
|
261 | + } elseif( $field_name == 'CNT_ISO' ){ |
|
260 | 262 | $country_name_field = EEM_Country::instance()->field_settings_for( 'CNT_name' ); |
261 | 263 | $csv_row[ __( 'Country', 'event_espresso' ) ] = $attendee_row[ $country_name_field->get_qualified_column() ]; |
262 | - }else{ |
|
264 | + } else{ |
|
263 | 265 | $csv_row[ $field_obj->get_nicename() ] = $attendee_row[ $field_obj->get_qualified_column() ]; |
264 | 266 | } |
265 | 267 | } |
@@ -313,9 +315,9 @@ discard block |
||
313 | 315 | $value_on_model_obj = $field_obj->prepare_for_set_from_db( $raw_db_value ); |
314 | 316 | if( $pretty_schema === true){ |
315 | 317 | return $field_obj->prepare_for_pretty_echoing( $value_on_model_obj ); |
316 | - }elseif( is_string( $pretty_schema ) ) { |
|
318 | + } elseif( is_string( $pretty_schema ) ) { |
|
317 | 319 | return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema ); |
318 | - }else{ |
|
320 | + } else{ |
|
319 | 321 | return $field_obj->prepare_for_get( $value_on_model_obj ); |
320 | 322 | } |
321 | 323 | } |
@@ -370,7 +372,7 @@ discard block |
||
370 | 372 | ); |
371 | 373 | if( $event_id ){ |
372 | 374 | $query_params[0]['EVT_ID'] = $event_id; |
373 | - }else{ |
|
375 | + } else{ |
|
374 | 376 | $query_params[ 'force_join' ][] = 'Event'; |
375 | 377 | } |
376 | 378 | $registration_rows = $reg_model->get_all_wpdb_results( $query_params ); |
@@ -394,11 +396,11 @@ discard block |
||
394 | 396 | $field = $reg_model->field_settings_for($field_name); |
395 | 397 | if($field_name == 'REG_final_price'){ |
396 | 398 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_final_price'], 'localized_float' ); |
397 | - }elseif( $field_name == 'REG_count' ){ |
|
399 | + } elseif( $field_name == 'REG_count' ){ |
|
398 | 400 | $value = sprintf( __( '%s of %s', 'event_espresso' ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_count', $reg_row['Registration.REG_count'] ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size' ] ) ); |
399 | - }elseif( $field_name == 'REG_date' ) { |
|
401 | + } elseif( $field_name == 'REG_date' ) { |
|
400 | 402 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_date'], 'no_html' ); |
401 | - }else{ |
|
403 | + } else{ |
|
402 | 404 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ $field->get_qualified_column() ] ); |
403 | 405 | } |
404 | 406 | $reg_csv_array[$this->_get_column_name_for_field($field)] = $value; |
@@ -470,12 +472,12 @@ discard block |
||
470 | 472 | if( $reg_row[ 'Attendee_CPT.ID' ]){ |
471 | 473 | if($att_field_name == 'STA_ID'){ |
472 | 474 | $value = EEM_State::instance()->get_var( array( array( 'STA_ID' => $reg_row[ 'Attendee_Meta.STA_ID' ] ) ), 'STA_name' ); |
473 | - }elseif($att_field_name == 'CNT_ISO'){ |
|
475 | + } elseif($att_field_name == 'CNT_ISO'){ |
|
474 | 476 | $value = EEM_Country::instance()->get_var( array( array( 'CNT_ISO' => $reg_row[ 'Attendee_Meta.CNT_ISO' ] ) ), 'CNT_name' ); |
475 | - }else{ |
|
477 | + } else{ |
|
476 | 478 | $value = $this->_prepare_value_from_db_for_display( EEM_Attendee::instance(), $att_field_name, $reg_row[ $field_obj->get_qualified_column() ] ); |
477 | 479 | } |
478 | - }else{ |
|
480 | + } else{ |
|
479 | 481 | $value = ''; |
480 | 482 | } |
481 | 483 | |
@@ -493,7 +495,7 @@ discard block |
||
493 | 495 | /* @var $answer EE_Answer */ |
494 | 496 | if( $answer_row[ 'Question.QST_ID' ] ){ |
495 | 497 | $question_label = $this->_prepare_value_from_db_for_display( EEM_Question::instance(), 'QST_admin_label', $answer_row[ 'Question.QST_admin_label' ] ); |
496 | - }else{ |
|
498 | + } else{ |
|
497 | 499 | $question_label = sprintf( __( 'Question $s', 'event_espresso' ), $answer_row[ 'Answer.QST_ID' ] ); |
498 | 500 | } |
499 | 501 | $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
@@ -523,7 +525,7 @@ discard block |
||
523 | 525 | if( ! $event_slug ) { |
524 | 526 | $event_slug = __( 'unknown', 'event_espresso' ); |
525 | 527 | } |
526 | - }else{ |
|
528 | + } else{ |
|
527 | 529 | $event_slug = __( 'all', 'event_espresso' ); |
528 | 530 | } |
529 | 531 | $filename = sprintf( "registrations-for-%s", $event_slug ); |
@@ -593,7 +595,7 @@ discard block |
||
593 | 595 | $filename = get_bloginfo('name') . '-' . $export_name; |
594 | 596 | $filename = sanitize_key( $filename ) . '-' . $this->today; |
595 | 597 | return $filename; |
596 | - } else { |
|
598 | + } else { |
|
597 | 599 | EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
598 | 600 | } |
599 | 601 | return false; |
@@ -629,8 +631,7 @@ discard block |
||
629 | 631 | // $field->set_date_format('Y-m-d'); |
630 | 632 | // $field->set_time_format('H:i:s'); |
631 | 633 | $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(),'Y-m-d','H:i:s'); |
632 | - } |
|
633 | - else{ |
|
634 | + } else{ |
|
634 | 635 | $model_data_array[$column_name] = $model_object->get($field->get_name()); |
635 | 636 | } |
636 | 637 | } |
@@ -500,11 +500,11 @@ |
||
500 | 500 | }else{ |
501 | 501 | $question_label = sprintf( __( 'Question $s', 'event_espresso' ), $answer_row[ 'Answer.QST_ID' ] ); |
502 | 502 | } |
503 | - if( isset( $answer_row[ 'Question.QST_type'] ) && $answer_row[ 'Question.QST_type' ] == EEM_Question::QST_type_state ) { |
|
504 | - $reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID( $answer_row[ 'Answer.ANS_value' ] ); |
|
505 | - } else { |
|
506 | - $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
|
507 | - } |
|
503 | + if( isset( $answer_row[ 'Question.QST_type'] ) && $answer_row[ 'Question.QST_type' ] == EEM_Question::QST_type_state ) { |
|
504 | + $reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID( $answer_row[ 'Answer.ANS_value' ] ); |
|
505 | + } else { |
|
506 | + $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
|
507 | + } |
|
508 | 508 | } |
509 | 509 | $registrations_csv_ready_array[] = apply_filters( 'FHEE__EE_Export__report_registrations__reg_csv_array', $reg_csv_array, $reg_row ); |
510 | 510 | } |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | -do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | +do_action('AHEE_log', __FILE__, __FUNCTION__, ''); |
|
3 | 3 | /** |
4 | 4 | * EE_Export class |
5 | 5 | * |
@@ -39,11 +39,11 @@ discard block |
||
39 | 39 | * @access private |
40 | 40 | * @param array $request_data |
41 | 41 | */ |
42 | - private function __construct( $request_data = array() ) { |
|
42 | + private function __construct($request_data = array()) { |
|
43 | 43 | $this->_req_data = $request_data; |
44 | - $this->today = date("Y-m-d",time()); |
|
45 | - require_once( EE_CLASSES . 'EE_CSV.class.php' ); |
|
46 | - $this->EE_CSV= EE_CSV::instance(); |
|
44 | + $this->today = date("Y-m-d", time()); |
|
45 | + require_once(EE_CLASSES.'EE_CSV.class.php'); |
|
46 | + $this->EE_CSV = EE_CSV::instance(); |
|
47 | 47 | } |
48 | 48 | |
49 | 49 | |
@@ -55,10 +55,10 @@ discard block |
||
55 | 55 | * @param array $request_data |
56 | 56 | * @return \EE_Export |
57 | 57 | */ |
58 | - public static function instance( $request_data = array() ) { |
|
58 | + public static function instance($request_data = array()) { |
|
59 | 59 | // check if class object is instantiated |
60 | - if ( self::$_instance === NULL or ! is_object( self::$_instance ) or ! ( self::$_instance instanceof EE_Export )) { |
|
61 | - self::$_instance = new self( $request_data ); |
|
60 | + if (self::$_instance === NULL or ! is_object(self::$_instance) or ! (self::$_instance instanceof EE_Export)) { |
|
61 | + self::$_instance = new self($request_data); |
|
62 | 62 | } |
63 | 63 | return self::$_instance; |
64 | 64 | } |
@@ -72,15 +72,15 @@ discard block |
||
72 | 72 | public function export() { |
73 | 73 | |
74 | 74 | // in case of bulk exports, the "actual" action will be in action2, but first check regular action for "export" keyword |
75 | - if ( isset( $this->_req_data['action'] ) && strpos( $this->_req_data['action'], 'export' ) === FALSE ) { |
|
75 | + if (isset($this->_req_data['action']) && strpos($this->_req_data['action'], 'export') === FALSE) { |
|
76 | 76 | // check if action2 has export action |
77 | - if ( isset( $this->_req_data['action2'] ) && strpos( $this->_req_data['action2'], 'export' ) !== FALSE ) { |
|
77 | + if (isset($this->_req_data['action2']) && strpos($this->_req_data['action2'], 'export') !== FALSE) { |
|
78 | 78 | // whoop! there it is! |
79 | 79 | $this->_req_data['action'] = $this->_req_data['action2']; |
80 | 80 | } |
81 | 81 | } |
82 | 82 | |
83 | - $this->_req_data['export'] = isset( $this->_req_data['export'] ) ? $this->_req_data['export'] : ''; |
|
83 | + $this->_req_data['export'] = isset($this->_req_data['export']) ? $this->_req_data['export'] : ''; |
|
84 | 84 | |
85 | 85 | switch ($this->_req_data['export']) { |
86 | 86 | case 'report': |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | break; |
95 | 95 | |
96 | 96 | case 'registrations_report_for_event': |
97 | - $this->report_registrations_for_event( $this->_req_data['EVT_ID'] ); |
|
97 | + $this->report_registrations_for_event($this->_req_data['EVT_ID']); |
|
98 | 98 | break; |
99 | 99 | |
100 | 100 | case 'attendees': |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | break; |
107 | 107 | |
108 | 108 | default: |
109 | - EE_Error::add_error(__('An error occurred! The requested export report could not be found.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ) ; |
|
109 | + EE_Error::add_error(__('An error occurred! The requested export report could not be found.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
110 | 110 | return FALSE; |
111 | 111 | break; |
112 | 112 | |
@@ -124,7 +124,7 @@ discard block |
||
124 | 124 | * Downloads a CSV file with all the columns, but no data. This should be used for importing |
125 | 125 | * @return null kills execution |
126 | 126 | */ |
127 | - function export_sample(){ |
|
127 | + function export_sample() { |
|
128 | 128 | $event = EEM_Event::instance()->get_one(); |
129 | 129 | $this->_req_data['EVT_ID'] = $event->ID(); |
130 | 130 | $this->export_all_event_data(); |
@@ -150,23 +150,23 @@ discard block |
||
150 | 150 | $state_country_query_params = array(); |
151 | 151 | $question_group_query_params = array(); |
152 | 152 | $question_query_params = array(); |
153 | - if ( isset( $this->_req_data['EVT_ID'] )) { |
|
153 | + if (isset($this->_req_data['EVT_ID'])) { |
|
154 | 154 | // do we have an array of IDs ? |
155 | 155 | |
156 | - if ( is_array( $this->_req_data['EVT_ID'] )) { |
|
157 | - $EVT_IDs = array_map( 'sanitize_text_field', $this->_req_data['EVT_ID'] ); |
|
158 | - $value_to_equal = array('IN',$EVT_IDs); |
|
156 | + if (is_array($this->_req_data['EVT_ID'])) { |
|
157 | + $EVT_IDs = array_map('sanitize_text_field', $this->_req_data['EVT_ID']); |
|
158 | + $value_to_equal = array('IN', $EVT_IDs); |
|
159 | 159 | $filename = 'events'; |
160 | 160 | } else { |
161 | 161 | // generate regular where = clause |
162 | - $EVT_ID = absint( $this->_req_data['EVT_ID'] ); |
|
162 | + $EVT_ID = absint($this->_req_data['EVT_ID']); |
|
163 | 163 | $value_to_equal = $EVT_ID; |
164 | 164 | $event = EE_Registry::instance()->load_model('Event')->get_one_by_ID($EVT_ID); |
165 | 165 | |
166 | - $filename = 'event-' . ( $event instanceof EE_Event ? $event->slug() : __( 'unknown', 'event_espresso' ) ); |
|
166 | + $filename = 'event-'.($event instanceof EE_Event ? $event->slug() : __('unknown', 'event_espresso')); |
|
167 | 167 | |
168 | 168 | } |
169 | - $event_query_params[0]['EVT_ID'] =$value_to_equal; |
|
169 | + $event_query_params[0]['EVT_ID'] = $value_to_equal; |
|
170 | 170 | $related_models_query_params[0]['Event.EVT_ID'] = $value_to_equal; |
171 | 171 | $related_through_reg_query_params[0]['Registration.EVT_ID'] = $value_to_equal; |
172 | 172 | $datetime_ticket_query_params[0]['Datetime.EVT_ID'] = $value_to_equal; |
@@ -210,42 +210,42 @@ discard block |
||
210 | 210 | |
211 | 211 | ); |
212 | 212 | |
213 | - $model_data = $this->_get_export_data_for_models( $models_to_export ); |
|
213 | + $model_data = $this->_get_export_data_for_models($models_to_export); |
|
214 | 214 | |
215 | - $filename = $this->generate_filename ( $filename ); |
|
215 | + $filename = $this->generate_filename($filename); |
|
216 | 216 | |
217 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $model_data )) { |
|
218 | - EE_Error::add_error(__("'An error occurred and the Event details could not be exported from the database.'", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
|
217 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $model_data)) { |
|
218 | + EE_Error::add_error(__("'An error occurred and the Event details could not be exported from the database.'", "event_espresso"), __FILE__, __FUNCTION__, __LINE__); |
|
219 | 219 | } |
220 | 220 | } |
221 | 221 | |
222 | - function report_attendees(){ |
|
222 | + function report_attendees() { |
|
223 | 223 | $attendee_rows = EEM_Attendee::instance()->get_all_wpdb_results( |
224 | 224 | array( |
225 | - 'force_join' => array( 'State', 'Country' ), |
|
225 | + 'force_join' => array('State', 'Country'), |
|
226 | 226 | 'caps' => EEM_Base::caps_read_admin |
227 | 227 | ) |
228 | 228 | ); |
229 | 229 | $csv_data = array(); |
230 | - foreach( $attendee_rows as $attendee_row ){ |
|
230 | + foreach ($attendee_rows as $attendee_row) { |
|
231 | 231 | $csv_row = array(); |
232 | - foreach( EEM_Attendee::instance()->field_settings() as $field_name => $field_obj ){ |
|
233 | - if( $field_name == 'STA_ID' ){ |
|
234 | - $state_name_field = EEM_State::instance()->field_settings_for( 'STA_name' ); |
|
235 | - $csv_row[ __( 'State', 'event_espresso' ) ] = $attendee_row[ $state_name_field->get_qualified_column() ]; |
|
236 | - }elseif( $field_name == 'CNT_ISO' ){ |
|
237 | - $country_name_field = EEM_Country::instance()->field_settings_for( 'CNT_name' ); |
|
238 | - $csv_row[ __( 'Country', 'event_espresso' ) ] = $attendee_row[ $country_name_field->get_qualified_column() ]; |
|
239 | - }else{ |
|
240 | - $csv_row[ $field_obj->get_nicename() ] = $attendee_row[ $field_obj->get_qualified_column() ]; |
|
232 | + foreach (EEM_Attendee::instance()->field_settings() as $field_name => $field_obj) { |
|
233 | + if ($field_name == 'STA_ID') { |
|
234 | + $state_name_field = EEM_State::instance()->field_settings_for('STA_name'); |
|
235 | + $csv_row[__('State', 'event_espresso')] = $attendee_row[$state_name_field->get_qualified_column()]; |
|
236 | + }elseif ($field_name == 'CNT_ISO') { |
|
237 | + $country_name_field = EEM_Country::instance()->field_settings_for('CNT_name'); |
|
238 | + $csv_row[__('Country', 'event_espresso')] = $attendee_row[$country_name_field->get_qualified_column()]; |
|
239 | + } else { |
|
240 | + $csv_row[$field_obj->get_nicename()] = $attendee_row[$field_obj->get_qualified_column()]; |
|
241 | 241 | } |
242 | 242 | } |
243 | 243 | $csv_data[] = $csv_row; |
244 | 244 | } |
245 | 245 | |
246 | - $filename = $this->generate_filename ( 'contact-list-report' ); |
|
246 | + $filename = $this->generate_filename('contact-list-report'); |
|
247 | 247 | |
248 | - $handle = $this->EE_CSV->begin_sending_csv( $filename); |
|
248 | + $handle = $this->EE_CSV->begin_sending_csv($filename); |
|
249 | 249 | $this->EE_CSV->write_data_array_to_csv($handle, $csv_data); |
250 | 250 | $this->EE_CSV->end_sending_csv($handle); |
251 | 251 | } |
@@ -262,18 +262,18 @@ discard block |
||
262 | 262 | $countries_that_have_an_attendee = EEM_Country::instance()->get_all(array(0=>array('Attendee.ATT_ID'=>array('IS NOT NULL')))); |
263 | 263 | // $states_to_export_query_params |
264 | 264 | $models_to_export = array( |
265 | - 'Country'=>array(array('CNT_ISO'=>array('IN',array_keys($countries_that_have_an_attendee)))), |
|
266 | - 'State'=>array(array('STA_ID'=>array('IN',array_keys($states_that_have_an_attendee)))), |
|
265 | + 'Country'=>array(array('CNT_ISO'=>array('IN', array_keys($countries_that_have_an_attendee)))), |
|
266 | + 'State'=>array(array('STA_ID'=>array('IN', array_keys($states_that_have_an_attendee)))), |
|
267 | 267 | 'Attendee'=>array(), |
268 | 268 | ); |
269 | 269 | |
270 | 270 | |
271 | 271 | |
272 | - $model_data = $this->_get_export_data_for_models( $models_to_export ); |
|
273 | - $filename = $this->generate_filename ( 'all-attendees' ); |
|
272 | + $model_data = $this->_get_export_data_for_models($models_to_export); |
|
273 | + $filename = $this->generate_filename('all-attendees'); |
|
274 | 274 | |
275 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $model_data )) { |
|
276 | - EE_Error::add_error(__('An error occurred and the Attendee data could not be exported from the database.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ); |
|
275 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $model_data)) { |
|
276 | + EE_Error::add_error(__('An error occurred and the Attendee data could not be exported from the database.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
277 | 277 | } |
278 | 278 | } |
279 | 279 | |
@@ -285,19 +285,19 @@ discard block |
||
285 | 285 | * @param boolean|string $pretty_schema true to display pretty, a string to use a specific "Schema", or false to NOT display pretty |
286 | 286 | * @return string |
287 | 287 | */ |
288 | - protected function _prepare_value_from_db_for_display( $model, $field_name, $raw_db_value, $pretty_schema = true ) { |
|
289 | - $field_obj = $model->field_settings_for( $field_name ); |
|
290 | - $value_on_model_obj = $field_obj->prepare_for_set_from_db( $raw_db_value ); |
|
291 | - if( $field_obj instanceof EE_Datetime_Field ) { |
|
292 | - $field_obj->set_date_format( EE_CSV::instance()->get_date_format_for_csv( $field_obj->get_date_format( $pretty_schema ) ), $pretty_schema ); |
|
293 | - $field_obj->set_time_format( EE_CSV::instance()->get_time_format_for_csv( $field_obj->get_time_format( $pretty_schema ) ), $pretty_schema ); |
|
288 | + protected function _prepare_value_from_db_for_display($model, $field_name, $raw_db_value, $pretty_schema = true) { |
|
289 | + $field_obj = $model->field_settings_for($field_name); |
|
290 | + $value_on_model_obj = $field_obj->prepare_for_set_from_db($raw_db_value); |
|
291 | + if ($field_obj instanceof EE_Datetime_Field) { |
|
292 | + $field_obj->set_date_format(EE_CSV::instance()->get_date_format_for_csv($field_obj->get_date_format($pretty_schema)), $pretty_schema); |
|
293 | + $field_obj->set_time_format(EE_CSV::instance()->get_time_format_for_csv($field_obj->get_time_format($pretty_schema)), $pretty_schema); |
|
294 | 294 | } |
295 | - if( $pretty_schema === true){ |
|
296 | - return $field_obj->prepare_for_pretty_echoing( $value_on_model_obj ); |
|
297 | - }elseif( is_string( $pretty_schema ) ) { |
|
298 | - return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema ); |
|
299 | - }else{ |
|
300 | - return $field_obj->prepare_for_get( $value_on_model_obj ); |
|
295 | + if ($pretty_schema === true) { |
|
296 | + return $field_obj->prepare_for_pretty_echoing($value_on_model_obj); |
|
297 | + }elseif (is_string($pretty_schema)) { |
|
298 | + return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema); |
|
299 | + } else { |
|
300 | + return $field_obj->prepare_for_get($value_on_model_obj); |
|
301 | 301 | } |
302 | 302 | } |
303 | 303 | |
@@ -306,7 +306,7 @@ discard block |
||
306 | 306 | * and the questions associated with the registrations |
307 | 307 | * @param int $event_id |
308 | 308 | */ |
309 | - function report_registrations_for_event( $event_id = NULL ){ |
|
309 | + function report_registrations_for_event($event_id = NULL) { |
|
310 | 310 | $reg_fields_to_include = array( |
311 | 311 | 'TXN_ID', |
312 | 312 | 'ATT_ID', |
@@ -338,126 +338,126 @@ discard block |
||
338 | 338 | array( |
339 | 339 | 'OR' => array( |
340 | 340 | //don't include registrations from failed or abandoned transactions... |
341 | - 'Transaction.STS_ID' => array( 'NOT IN', array( EEM_Transaction::failed_status_code, EEM_Transaction::abandoned_status_code ) ), |
|
341 | + 'Transaction.STS_ID' => array('NOT IN', array(EEM_Transaction::failed_status_code, EEM_Transaction::abandoned_status_code)), |
|
342 | 342 | //unless the registration is approved, in which case include it regardless of transaction status |
343 | 343 | 'STS_ID' => EEM_Registration::status_id_approved |
344 | 344 | ), |
345 | - 'Ticket.TKT_deleted' => array( 'IN', array( true, false ) ) |
|
345 | + 'Ticket.TKT_deleted' => array('IN', array(true, false)) |
|
346 | 346 | ), |
347 | - 'order_by' => array('Transaction.TXN_ID'=>'asc','REG_count'=>'asc'), |
|
348 | - 'force_join' => array( 'Transaction', 'Ticket', 'Attendee' ), |
|
347 | + 'order_by' => array('Transaction.TXN_ID'=>'asc', 'REG_count'=>'asc'), |
|
348 | + 'force_join' => array('Transaction', 'Ticket', 'Attendee'), |
|
349 | 349 | 'caps' => EEM_Base::caps_read_admin |
350 | 350 | ), |
351 | 351 | $event_id |
352 | 352 | ); |
353 | - if( $event_id ){ |
|
354 | - $query_params[0]['EVT_ID'] = $event_id; |
|
355 | - }else{ |
|
356 | - $query_params[ 'force_join' ][] = 'Event'; |
|
353 | + if ($event_id) { |
|
354 | + $query_params[0]['EVT_ID'] = $event_id; |
|
355 | + } else { |
|
356 | + $query_params['force_join'][] = 'Event'; |
|
357 | 357 | } |
358 | - $registration_rows = $reg_model->get_all_wpdb_results( $query_params ); |
|
358 | + $registration_rows = $reg_model->get_all_wpdb_results($query_params); |
|
359 | 359 | //get all questions which relate to someone in this group |
360 | 360 | $registration_ids = array(); |
361 | - foreach( $registration_rows as $reg_row ) { |
|
362 | - $registration_ids[] = intval( $reg_row[ 'Registration.REG_ID'] ); |
|
361 | + foreach ($registration_rows as $reg_row) { |
|
362 | + $registration_ids[] = intval($reg_row['Registration.REG_ID']); |
|
363 | 363 | } |
364 | 364 | // EEM_Question::instance()->show_next_x_db_queries(); |
365 | - $questions_for_these_regs_rows = EEM_Question::instance()->get_all_wpdb_results(array(array('Answer.REG_ID'=>array('IN',$registration_ids)))); |
|
366 | - foreach($registration_rows as $reg_row){ |
|
367 | - if ( is_array( $reg_row ) ) { |
|
365 | + $questions_for_these_regs_rows = EEM_Question::instance()->get_all_wpdb_results(array(array('Answer.REG_ID'=>array('IN', $registration_ids)))); |
|
366 | + foreach ($registration_rows as $reg_row) { |
|
367 | + if (is_array($reg_row)) { |
|
368 | 368 | $reg_csv_array = array(); |
369 | - if( ! $event_id ){ |
|
369 | + if ( ! $event_id) { |
|
370 | 370 | //get the event's name and Id |
371 | - $reg_csv_array[ __( 'Event', 'event_espresso' ) ] = sprintf( __( '%1$s (%2$s)', 'event_espresso' ), $this->_prepare_value_from_db_for_display( EEM_Event::instance(), 'EVT_name', $reg_row[ 'Event_CPT.post_title'] ), $reg_row[ 'Event_CPT.ID' ] ); |
|
371 | + $reg_csv_array[__('Event', 'event_espresso')] = sprintf(__('%1$s (%2$s)', 'event_espresso'), $this->_prepare_value_from_db_for_display(EEM_Event::instance(), 'EVT_name', $reg_row['Event_CPT.post_title']), $reg_row['Event_CPT.ID']); |
|
372 | 372 | } |
373 | - $is_primary_reg = $reg_row[ 'Registration.REG_count' ] == '1' ? true : false; |
|
373 | + $is_primary_reg = $reg_row['Registration.REG_count'] == '1' ? true : false; |
|
374 | 374 | /*@var $reg_row EE_Registration */ |
375 | - foreach($reg_fields_to_include as $field_name){ |
|
375 | + foreach ($reg_fields_to_include as $field_name) { |
|
376 | 376 | $field = $reg_model->field_settings_for($field_name); |
377 | - if($field_name == 'REG_final_price'){ |
|
378 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_final_price'], 'localized_float' ); |
|
379 | - }elseif( $field_name == 'REG_count' ){ |
|
380 | - $value = sprintf( __( '%s of %s', 'event_espresso' ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_count', $reg_row['Registration.REG_count'] ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size' ] ) ); |
|
381 | - }elseif( $field_name == 'REG_date' ) { |
|
382 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_date'], 'no_html' ); |
|
383 | - }else{ |
|
384 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ $field->get_qualified_column() ] ); |
|
377 | + if ($field_name == 'REG_final_price') { |
|
378 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row['Registration.REG_final_price'], 'localized_float'); |
|
379 | + }elseif ($field_name == 'REG_count') { |
|
380 | + $value = sprintf(__('%s of %s', 'event_espresso'), $this->_prepare_value_from_db_for_display($reg_model, 'REG_count', $reg_row['Registration.REG_count']), $this->_prepare_value_from_db_for_display($reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size'])); |
|
381 | + }elseif ($field_name == 'REG_date') { |
|
382 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row['Registration.REG_date'], 'no_html'); |
|
383 | + } else { |
|
384 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row[$field->get_qualified_column()]); |
|
385 | 385 | } |
386 | 386 | $reg_csv_array[$this->_get_column_name_for_field($field)] = $value; |
387 | - if($field_name == 'REG_final_price'){ |
|
387 | + if ($field_name == 'REG_final_price') { |
|
388 | 388 | //add a column named Currency after the final price |
389 | 389 | $reg_csv_array[__("Currency", "event_espresso")] = EE_Config::instance()->currency->code; |
390 | 390 | } |
391 | 391 | } |
392 | 392 | //get pretty status |
393 | - $stati = EEM_Status::instance()->localized_status( array( |
|
394 | - $reg_row[ 'Registration.STS_ID' ] => __( 'unknown', 'event_espresso' ), |
|
395 | - $reg_row[ 'TransactionTable.STS_ID' ] => __( 'unknown', 'event_espresso' ) ), |
|
393 | + $stati = EEM_Status::instance()->localized_status(array( |
|
394 | + $reg_row['Registration.STS_ID'] => __('unknown', 'event_espresso'), |
|
395 | + $reg_row['TransactionTable.STS_ID'] => __('unknown', 'event_espresso') ), |
|
396 | 396 | FALSE, |
397 | - 'sentence' ); |
|
398 | - $reg_csv_array[__("Registration Status", 'event_espresso')] = $stati[ $reg_row[ 'Registration.STS_ID' ] ]; |
|
397 | + 'sentence'); |
|
398 | + $reg_csv_array[__("Registration Status", 'event_espresso')] = $stati[$reg_row['Registration.STS_ID']]; |
|
399 | 399 | //get pretty trnasaction status |
400 | - $reg_csv_array[__("Transaction Status", 'event_espresso')] = $stati[ $reg_row[ 'TransactionTable.STS_ID' ] ]; |
|
401 | - $reg_csv_array[ __( 'Transaction Amount Due', 'event_espresso' ) ] = $is_primary_reg ? $this->_prepare_value_from_db_for_display( EEM_Transaction::instance(), 'TXN_total', $reg_row[ 'TransactionTable.TXN_total' ], 'localized_float' ) : '0.00'; |
|
402 | - $reg_csv_array[ __( 'Amount Paid', 'event_espresso' )] = $is_primary_reg ? $this->_prepare_value_from_db_for_display( EEM_Transaction::instance(), 'TXN_paid', $reg_row[ 'TransactionTable.TXN_paid' ], 'localized_float' ) : '0.00'; |
|
400 | + $reg_csv_array[__("Transaction Status", 'event_espresso')] = $stati[$reg_row['TransactionTable.STS_ID']]; |
|
401 | + $reg_csv_array[__('Transaction Amount Due', 'event_espresso')] = $is_primary_reg ? $this->_prepare_value_from_db_for_display(EEM_Transaction::instance(), 'TXN_total', $reg_row['TransactionTable.TXN_total'], 'localized_float') : '0.00'; |
|
402 | + $reg_csv_array[__('Amount Paid', 'event_espresso')] = $is_primary_reg ? $this->_prepare_value_from_db_for_display(EEM_Transaction::instance(), 'TXN_paid', $reg_row['TransactionTable.TXN_paid'], 'localized_float') : '0.00'; |
|
403 | 403 | $payment_methods = array(); |
404 | 404 | $gateway_txn_ids_etc = array(); |
405 | 405 | $payment_times = array(); |
406 | - if( $is_primary_reg && $reg_row[ 'TransactionTable.TXN_ID' ] ){ |
|
406 | + if ($is_primary_reg && $reg_row['TransactionTable.TXN_ID']) { |
|
407 | 407 | $payments_info = EEM_Payment::instance()->get_all_wpdb_results( |
408 | 408 | array( |
409 | 409 | array( |
410 | - 'TXN_ID' => $reg_row[ 'TransactionTable.TXN_ID' ], |
|
410 | + 'TXN_ID' => $reg_row['TransactionTable.TXN_ID'], |
|
411 | 411 | 'STS_ID' => EEM_Payment::status_id_approved |
412 | 412 | ), |
413 | - 'force_join' => array( 'Payment_Method' ), |
|
413 | + 'force_join' => array('Payment_Method'), |
|
414 | 414 | |
415 | 415 | ), |
416 | 416 | ARRAY_A, |
417 | 417 | 'Payment_Method.PMD_admin_name as name, Payment.PAY_txn_id_chq_nmbr as gateway_txn_id, Payment.PAY_timestamp as payment_time' ); |
418 | 418 | |
419 | - foreach( $payments_info as $payment_method_and_gateway_txn_id ){ |
|
420 | - $payment_methods[] = isset( $payment_method_and_gateway_txn_id[ 'name' ] ) ? $payment_method_and_gateway_txn_id[ 'name' ] : __( 'Unknown', 'event_espresso' ); |
|
421 | - $gateway_txn_ids_etc[] = isset( $payment_method_and_gateway_txn_id[ 'gateway_txn_id' ] ) ? $payment_method_and_gateway_txn_id[ 'gateway_txn_id' ] : ''; |
|
422 | - $payment_times[] = isset( $payment_method_and_gateway_txn_id[ 'payment_time' ] ) ? $payment_method_and_gateway_txn_id[ 'payment_time' ] : ''; |
|
419 | + foreach ($payments_info as $payment_method_and_gateway_txn_id) { |
|
420 | + $payment_methods[] = isset($payment_method_and_gateway_txn_id['name']) ? $payment_method_and_gateway_txn_id['name'] : __('Unknown', 'event_espresso'); |
|
421 | + $gateway_txn_ids_etc[] = isset($payment_method_and_gateway_txn_id['gateway_txn_id']) ? $payment_method_and_gateway_txn_id['gateway_txn_id'] : ''; |
|
422 | + $payment_times[] = isset($payment_method_and_gateway_txn_id['payment_time']) ? $payment_method_and_gateway_txn_id['payment_time'] : ''; |
|
423 | 423 | } |
424 | 424 | |
425 | 425 | } |
426 | - $reg_csv_array[ __( 'Payment Date(s)', 'event_espresso' ) ] = implode( ',', $payment_times ); |
|
427 | - $reg_csv_array[ __( 'Payment Method(s)', 'event_espresso' ) ] = implode( ",", $payment_methods ); |
|
428 | - $reg_csv_array[ __( 'Gateway Transaction ID(s)', 'event_espresso' )] = implode( ',', $gateway_txn_ids_etc ); |
|
426 | + $reg_csv_array[__('Payment Date(s)', 'event_espresso')] = implode(',', $payment_times); |
|
427 | + $reg_csv_array[__('Payment Method(s)', 'event_espresso')] = implode(",", $payment_methods); |
|
428 | + $reg_csv_array[__('Gateway Transaction ID(s)', 'event_espresso')] = implode(',', $gateway_txn_ids_etc); |
|
429 | 429 | |
430 | 430 | //get whether or not the user has checked in |
431 | - $reg_csv_array[__("Check-Ins", "event_espresso")] = $reg_model->count_related( $reg_row[ 'Registration.REG_ID'] , 'Checkin' ); |
|
431 | + $reg_csv_array[__("Check-Ins", "event_espresso")] = $reg_model->count_related($reg_row['Registration.REG_ID'], 'Checkin'); |
|
432 | 432 | //get ticket of registration and its price |
433 | 433 | $ticket_model = EE_Registry::instance()->load_model('Ticket'); |
434 | - if( $reg_row[ 'Ticket.TKT_ID'] ) { |
|
435 | - $ticket_name = $this->_prepare_value_from_db_for_display( $ticket_model, 'TKT_name', $reg_row[ 'Ticket.TKT_name' ] ); |
|
434 | + if ($reg_row['Ticket.TKT_ID']) { |
|
435 | + $ticket_name = $this->_prepare_value_from_db_for_display($ticket_model, 'TKT_name', $reg_row['Ticket.TKT_name']); |
|
436 | 436 | $datetimes_strings = array(); |
437 | - foreach( EEM_Datetime::instance()->get_all_wpdb_results( array( array( 'Ticket.TKT_ID' => $reg_row[ 'Ticket.TKT_ID' ] ), 'order_by' => array( 'DTT_EVT_start' => 'ASC' ), 'default_where_conditions' => 'none' ) ) as $datetime){ |
|
438 | - $datetimes_strings[] = $this->_prepare_value_from_db_for_display( EEM_Datetime::instance(), 'DTT_EVT_start', $datetime[ 'Datetime.DTT_EVT_start'] ); |
|
437 | + foreach (EEM_Datetime::instance()->get_all_wpdb_results(array(array('Ticket.TKT_ID' => $reg_row['Ticket.TKT_ID']), 'order_by' => array('DTT_EVT_start' => 'ASC'), 'default_where_conditions' => 'none')) as $datetime) { |
|
438 | + $datetimes_strings[] = $this->_prepare_value_from_db_for_display(EEM_Datetime::instance(), 'DTT_EVT_start', $datetime['Datetime.DTT_EVT_start']); |
|
439 | 439 | } |
440 | 440 | |
441 | 441 | } else { |
442 | - $ticket_name = __( 'Unknown', 'event_espresso' ); |
|
443 | - $datetimes_strings = array( __( 'Unknown', 'event_espresso' ) ); |
|
442 | + $ticket_name = __('Unknown', 'event_espresso'); |
|
443 | + $datetimes_strings = array(__('Unknown', 'event_espresso')); |
|
444 | 444 | } |
445 | 445 | $reg_csv_array[$ticket_model->field_settings_for('TKT_name')->get_nicename()] = $ticket_name; |
446 | 446 | $reg_csv_array[__("Datetimes of Ticket", "event_espresso")] = implode(", ", $datetimes_strings); |
447 | 447 | //get datetime(s) of registration |
448 | 448 | |
449 | 449 | //add attendee columns |
450 | - foreach($att_fields_to_include as $att_field_name){ |
|
450 | + foreach ($att_fields_to_include as $att_field_name) { |
|
451 | 451 | $field_obj = EEM_Attendee::instance()->field_settings_for($att_field_name); |
452 | - if( $reg_row[ 'Attendee_CPT.ID' ]){ |
|
453 | - if($att_field_name == 'STA_ID'){ |
|
454 | - $value = EEM_State::instance()->get_var( array( array( 'STA_ID' => $reg_row[ 'Attendee_Meta.STA_ID' ] ) ), 'STA_name' ); |
|
455 | - }elseif($att_field_name == 'CNT_ISO'){ |
|
456 | - $value = EEM_Country::instance()->get_var( array( array( 'CNT_ISO' => $reg_row[ 'Attendee_Meta.CNT_ISO' ] ) ), 'CNT_name' ); |
|
457 | - }else{ |
|
458 | - $value = $this->_prepare_value_from_db_for_display( EEM_Attendee::instance(), $att_field_name, $reg_row[ $field_obj->get_qualified_column() ] ); |
|
452 | + if ($reg_row['Attendee_CPT.ID']) { |
|
453 | + if ($att_field_name == 'STA_ID') { |
|
454 | + $value = EEM_State::instance()->get_var(array(array('STA_ID' => $reg_row['Attendee_Meta.STA_ID'])), 'STA_name'); |
|
455 | + }elseif ($att_field_name == 'CNT_ISO') { |
|
456 | + $value = EEM_Country::instance()->get_var(array(array('CNT_ISO' => $reg_row['Attendee_Meta.CNT_ISO'])), 'CNT_name'); |
|
457 | + } else { |
|
458 | + $value = $this->_prepare_value_from_db_for_display(EEM_Attendee::instance(), $att_field_name, $reg_row[$field_obj->get_qualified_column()]); |
|
459 | 459 | } |
460 | - }else{ |
|
460 | + } else { |
|
461 | 461 | $value = ''; |
462 | 462 | } |
463 | 463 | |
@@ -465,56 +465,56 @@ discard block |
||
465 | 465 | } |
466 | 466 | |
467 | 467 | //make sure each registration has the same questions in the same order |
468 | - foreach($questions_for_these_regs_rows as $question_row){ |
|
469 | - if( ! isset($reg_csv_array[$question_row[ 'Question.QST_admin_label']])){ |
|
470 | - $reg_csv_array[$question_row[ 'Question.QST_admin_label' ] ] = null; |
|
468 | + foreach ($questions_for_these_regs_rows as $question_row) { |
|
469 | + if ( ! isset($reg_csv_array[$question_row['Question.QST_admin_label']])) { |
|
470 | + $reg_csv_array[$question_row['Question.QST_admin_label']] = null; |
|
471 | 471 | } |
472 | 472 | } |
473 | 473 | //now fill out the questions THEY answered |
474 | - foreach( EEM_Answer::instance()->get_all_wpdb_results( array( array( 'REG_ID' => $reg_row[ 'Registration.REG_ID' ] ), 'force_join' => array( 'Question' ) ) ) as $answer_row){ |
|
474 | + foreach (EEM_Answer::instance()->get_all_wpdb_results(array(array('REG_ID' => $reg_row['Registration.REG_ID']), 'force_join' => array('Question'))) as $answer_row) { |
|
475 | 475 | /* @var $answer EE_Answer */ |
476 | - if( $answer_row[ 'Question.QST_ID' ] ){ |
|
477 | - $question_label = $this->_prepare_value_from_db_for_display( EEM_Question::instance(), 'QST_admin_label', $answer_row[ 'Question.QST_admin_label' ] ); |
|
478 | - }else{ |
|
479 | - $question_label = sprintf( __( 'Question $s', 'event_espresso' ), $answer_row[ 'Answer.QST_ID' ] ); |
|
476 | + if ($answer_row['Question.QST_ID']) { |
|
477 | + $question_label = $this->_prepare_value_from_db_for_display(EEM_Question::instance(), 'QST_admin_label', $answer_row['Question.QST_admin_label']); |
|
478 | + } else { |
|
479 | + $question_label = sprintf(__('Question $s', 'event_espresso'), $answer_row['Answer.QST_ID']); |
|
480 | 480 | } |
481 | - if( isset( $answer_row[ 'Question.QST_type'] ) && $answer_row[ 'Question.QST_type' ] == EEM_Question::QST_type_state ) { |
|
482 | - $reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID( $answer_row[ 'Answer.ANS_value' ] ); |
|
481 | + if (isset($answer_row['Question.QST_type']) && $answer_row['Question.QST_type'] == EEM_Question::QST_type_state) { |
|
482 | + $reg_csv_array[$question_label] = EEM_State::instance()->get_state_name_by_ID($answer_row['Answer.ANS_value']); |
|
483 | 483 | } else { |
484 | - $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
|
484 | + $reg_csv_array[$question_label] = $this->_prepare_value_from_db_for_display(EEM_Answer::instance(), 'ANS_value', $answer_row['Answer.ANS_value']); |
|
485 | 485 | } |
486 | 486 | } |
487 | - $registrations_csv_ready_array[] = apply_filters( 'FHEE__EE_Export__report_registrations__reg_csv_array', $reg_csv_array, $reg_row ); |
|
487 | + $registrations_csv_ready_array[] = apply_filters('FHEE__EE_Export__report_registrations__reg_csv_array', $reg_csv_array, $reg_row); |
|
488 | 488 | } |
489 | 489 | } |
490 | 490 | |
491 | 491 | //if we couldn't export anything, we want to at least show the column headers |
492 | - if(empty($registrations_csv_ready_array)){ |
|
492 | + if (empty($registrations_csv_ready_array)) { |
|
493 | 493 | $reg_csv_array = array(); |
494 | 494 | $model_and_fields_to_include = array( |
495 | 495 | 'Registration' => $reg_fields_to_include, |
496 | 496 | 'Attendee' => $att_fields_to_include |
497 | 497 | ); |
498 | - foreach($model_and_fields_to_include as $model_name => $field_list){ |
|
498 | + foreach ($model_and_fields_to_include as $model_name => $field_list) { |
|
499 | 499 | $model = EE_Registry::instance()->load_model($model_name); |
500 | - foreach($field_list as $field_name){ |
|
500 | + foreach ($field_list as $field_name) { |
|
501 | 501 | $field = $model->field_settings_for($field_name); |
502 | - $reg_csv_array[$this->_get_column_name_for_field($field)] = null;//$registration->get($field->get_name()); |
|
502 | + $reg_csv_array[$this->_get_column_name_for_field($field)] = null; //$registration->get($field->get_name()); |
|
503 | 503 | } |
504 | 504 | } |
505 | 505 | $registrations_csv_ready_array [] = $reg_csv_array; |
506 | 506 | } |
507 | - if( $event_id ){ |
|
508 | - $event_slug = EEM_Event::instance()->get_var( array( array( 'EVT_ID' => $event_id ) ), 'EVT_slug' ); |
|
509 | - if( ! $event_slug ) { |
|
510 | - $event_slug = __( 'unknown', 'event_espresso' ); |
|
507 | + if ($event_id) { |
|
508 | + $event_slug = EEM_Event::instance()->get_var(array(array('EVT_ID' => $event_id)), 'EVT_slug'); |
|
509 | + if ( ! $event_slug) { |
|
510 | + $event_slug = __('unknown', 'event_espresso'); |
|
511 | 511 | } |
512 | - }else{ |
|
513 | - $event_slug = __( 'all', 'event_espresso' ); |
|
512 | + } else { |
|
513 | + $event_slug = __('all', 'event_espresso'); |
|
514 | 514 | } |
515 | - $filename = sprintf( "registrations-for-%s", $event_slug ); |
|
515 | + $filename = sprintf("registrations-for-%s", $event_slug); |
|
516 | 516 | |
517 | - $handle = $this->EE_CSV->begin_sending_csv( $filename); |
|
517 | + $handle = $this->EE_CSV->begin_sending_csv($filename); |
|
518 | 518 | $this->EE_CSV->write_data_array_to_csv($handle, $registrations_csv_ready_array); |
519 | 519 | $this->EE_CSV->end_sending_csv($handle); |
520 | 520 | } |
@@ -524,7 +524,7 @@ discard block |
||
524 | 524 | * @param EE_Model_Field_Base $field |
525 | 525 | * @return string |
526 | 526 | */ |
527 | - protected function _get_column_name_for_field(EE_Model_Field_Base $field){ |
|
527 | + protected function _get_column_name_for_field(EE_Model_Field_Base $field) { |
|
528 | 528 | return $field->get_nicename()."[".$field->get_name()."]"; |
529 | 529 | } |
530 | 530 | |
@@ -537,17 +537,17 @@ discard block |
||
537 | 537 | function export_categories() { |
538 | 538 | // are any Event IDs set? |
539 | 539 | $query_params = array(); |
540 | - if ( isset( $this->_req_data['EVT_CAT_ID'] )) { |
|
540 | + if (isset($this->_req_data['EVT_CAT_ID'])) { |
|
541 | 541 | // do we have an array of IDs ? |
542 | - if ( is_array( $this->_req_data['EVT_CAT_ID'] )) { |
|
542 | + if (is_array($this->_req_data['EVT_CAT_ID'])) { |
|
543 | 543 | // generate an "IN (CSV)" where clause |
544 | - $EVT_CAT_IDs = array_map( 'sanitize_text_field', $this->_req_data['EVT_CAT_ID'] ); |
|
544 | + $EVT_CAT_IDs = array_map('sanitize_text_field', $this->_req_data['EVT_CAT_ID']); |
|
545 | 545 | $filename = 'event-categories'; |
546 | - $query_params[0]['term_taxonomy_id'] = array('IN',$EVT_CAT_IDs); |
|
546 | + $query_params[0]['term_taxonomy_id'] = array('IN', $EVT_CAT_IDs); |
|
547 | 547 | } else { |
548 | 548 | // generate regular where = clause |
549 | - $EVT_CAT_ID = absint( $this->_req_data['EVT_CAT_ID'] ); |
|
550 | - $filename = 'event-category#' . $EVT_CAT_ID; |
|
549 | + $EVT_CAT_ID = absint($this->_req_data['EVT_CAT_ID']); |
|
550 | + $filename = 'event-category#'.$EVT_CAT_ID; |
|
551 | 551 | $query_params[0]['term_taxonomy_id'] = $EVT_CAT_ID; |
552 | 552 | } |
553 | 553 | } else { |
@@ -559,11 +559,11 @@ discard block |
||
559 | 559 | 'Term_Taxonomy' => $query_params |
560 | 560 | ); |
561 | 561 | |
562 | - $table_data = $this->_get_export_data_for_models( $tables_to_export ); |
|
563 | - $filename = $this->generate_filename ( $filename ); |
|
562 | + $table_data = $this->_get_export_data_for_models($tables_to_export); |
|
563 | + $filename = $this->generate_filename($filename); |
|
564 | 564 | |
565 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $table_data )) { |
|
566 | - EE_Error::add_error(__('An error occurred and the Category details could not be exported from the database.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ); |
|
565 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $table_data)) { |
|
566 | + EE_Error::add_error(__('An error occurred and the Category details could not be exported from the database.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
567 | 567 | } |
568 | 568 | } |
569 | 569 | |
@@ -574,13 +574,13 @@ discard block |
||
574 | 574 | * @param string - export_name |
575 | 575 | * @return string on success, FALSE on fail |
576 | 576 | */ |
577 | - private function generate_filename ( $export_name = '' ) { |
|
578 | - if ( $export_name != '' ) { |
|
579 | - $filename = get_bloginfo('name') . '-' . $export_name; |
|
580 | - $filename = sanitize_key( $filename ) . '-' . $this->today; |
|
577 | + private function generate_filename($export_name = '') { |
|
578 | + if ($export_name != '') { |
|
579 | + $filename = get_bloginfo('name').'-'.$export_name; |
|
580 | + $filename = sanitize_key($filename).'-'.$this->today; |
|
581 | 581 | return $filename; |
582 | - } else { |
|
583 | - EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
|
582 | + } else { |
|
583 | + EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__); |
|
584 | 584 | } |
585 | 585 | return false; |
586 | 586 | } |
@@ -593,12 +593,12 @@ discard block |
||
593 | 593 | * @param array $models_to_export keys are model names (eg 'Event', 'Attendee', etc.) and values are arrays of query params like on EEM_Base::get_all |
594 | 594 | * @return array on success, FALSE on fail |
595 | 595 | */ |
596 | - private function _get_export_data_for_models( $models_to_export = array() ) { |
|
596 | + private function _get_export_data_for_models($models_to_export = array()) { |
|
597 | 597 | $table_data = FALSE; |
598 | - if ( is_array( $models_to_export ) ) { |
|
599 | - foreach ( $models_to_export as $model_name => $query_params ) { |
|
598 | + if (is_array($models_to_export)) { |
|
599 | + foreach ($models_to_export as $model_name => $query_params) { |
|
600 | 600 | //check for a numerically-indexed array. in that case, $model_name is the value!! |
601 | - if(is_int($model_name)){ |
|
601 | + if (is_int($model_name)) { |
|
602 | 602 | $model_name = $query_params; |
603 | 603 | $query_params = array(); |
604 | 604 | } |
@@ -606,17 +606,17 @@ discard block |
||
606 | 606 | $model_objects = $model->get_all($query_params); |
607 | 607 | |
608 | 608 | $table_data[$model_name] = array(); |
609 | - foreach($model_objects as $model_object){ |
|
609 | + foreach ($model_objects as $model_object) { |
|
610 | 610 | $model_data_array = array(); |
611 | 611 | $fields = $model->field_settings(); |
612 | - foreach($fields as $field){ |
|
612 | + foreach ($fields as $field) { |
|
613 | 613 | $column_name = $field->get_nicename()."[".$field->get_name()."]"; |
614 | - if($field instanceof EE_Datetime_Field){ |
|
614 | + if ($field instanceof EE_Datetime_Field) { |
|
615 | 615 | // $field->set_date_format('Y-m-d'); |
616 | 616 | // $field->set_time_format('H:i:s'); |
617 | - $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(),'Y-m-d','H:i:s'); |
|
617 | + $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(), 'Y-m-d', 'H:i:s'); |
|
618 | 618 | } |
619 | - else{ |
|
619 | + else { |
|
620 | 620 | $model_data_array[$column_name] = $model_object->get($field->get_name()); |
621 | 621 | } |
622 | 622 | } |
@@ -79,10 +79,6 @@ discard block |
||
79 | 79 | * @ access public |
80 | 80 | * @param string $title - heading for the form |
81 | 81 | * @param string $intro - additional text explaing what to do |
82 | - * @param string $page - EE Admin page to direct form to - in the form "espresso_{pageslug}" |
|
83 | - * @param string $action - EE Admin page route array "action" that form will direct to |
|
84 | - * @param string $type - type of file to import |
|
85 | - * @ return string |
|
86 | 82 | */ |
87 | 83 | public function upload_form ( $title, $intro, $form_url, $action, $type ) { |
88 | 84 | |
@@ -121,7 +117,7 @@ discard block |
||
121 | 117 | /** |
122 | 118 | * @Import Event Espresso data - some code "borrowed" from event espresso csv_import.php |
123 | 119 | * @access public |
124 | - * @return boolean success |
|
120 | + * @return boolean|null success |
|
125 | 121 | */ |
126 | 122 | public function import() { |
127 | 123 | |
@@ -269,8 +265,7 @@ discard block |
||
269 | 265 | * update that event, instead of adding a new event). |
270 | 266 | * @access public |
271 | 267 | * @param array $csv_data_array - the array containing the csv data produced from EE_CSV::import_csv_to_model_data_array() |
272 | - * @param array $fields_to_save - an array containing the csv column names as keys with the corresponding db table fields they will be saved to |
|
273 | - * @return TRUE on success, FALSE on fail |
|
268 | + * @return boolean |
|
274 | 269 | */ |
275 | 270 | public function save_csv_data_array_to_db( $csv_data_array, $model_name = FALSE ) { |
276 | 271 | |
@@ -367,7 +362,7 @@ discard block |
||
367 | 362 | * we need to insert a new row for that ID, and then map from the non-existent ID |
368 | 363 | * to the newly-inserted real ID. |
369 | 364 | * @param type $csv_data_array |
370 | - * @param type $export_from_site_a_to_b |
|
365 | + * @param boolean $export_from_site_a_to_b |
|
371 | 366 | * @param type $old_db_to_new_db_mapping |
372 | 367 | * @return array updated $old_db_to_new_db_mapping |
373 | 368 | */ |
@@ -484,7 +479,6 @@ discard block |
||
484 | 479 | * @param type $id_in_csv |
485 | 480 | * @param type $model_object_data |
486 | 481 | * @param EEM_Base $model |
487 | - * @param type $old_db_to_new_db_mapping |
|
488 | 482 | * @return |
489 | 483 | */ |
490 | 484 | protected function _decide_whether_to_insert_or_update_given_data_from_same_db( $id_in_csv, $model_object_data, $model ) { |
@@ -594,7 +588,7 @@ discard block |
||
594 | 588 | * @param type $object_id |
595 | 589 | * @param string $model_name |
596 | 590 | * @param array $old_db_to_new_db_mapping |
597 | - * @param type $export_from_site_a_to_b |
|
591 | + * @param boolean $export_from_site_a_to_b |
|
598 | 592 | * @return int |
599 | 593 | */ |
600 | 594 | protected function _find_mapping_in( $object_id, $model_name, $old_db_to_new_db_mapping, $export_from_site_a_to_b) { |
@@ -131,43 +131,43 @@ discard block |
||
131 | 131 | if ( isset( $_REQUEST['import'] )) { |
132 | 132 | if( isset( $_POST['csv_submitted'] )) { |
133 | 133 | |
134 | - switch ( $_FILES['file']['error'][0] ) { |
|
135 | - case UPLOAD_ERR_OK: |
|
136 | - $error_msg = FALSE; |
|
137 | - break; |
|
138 | - case UPLOAD_ERR_INI_SIZE: |
|
139 | - $error_msg = __("'The uploaded file exceeds the upload_max_filesize directive in php.ini.'", "event_espresso"); |
|
140 | - break; |
|
141 | - case UPLOAD_ERR_FORM_SIZE: |
|
142 | - $error_msg = __('The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form.', "event_espresso"); |
|
143 | - break; |
|
144 | - case UPLOAD_ERR_PARTIAL: |
|
145 | - $error_msg = __('The uploaded file was only partially uploaded.', "event_espresso"); |
|
146 | - break; |
|
147 | - case UPLOAD_ERR_NO_FILE: |
|
148 | - $error_msg = __('No file was uploaded.', "event_espresso"); |
|
149 | - break; |
|
150 | - case UPLOAD_ERR_NO_TMP_DIR: |
|
151 | - $error_msg = __('Missing a temporary folder.', "event_espresso"); |
|
152 | - break; |
|
153 | - case UPLOAD_ERR_CANT_WRITE: |
|
154 | - $error_msg = __('Failed to write file to disk.', "event_espresso"); |
|
155 | - break; |
|
156 | - case UPLOAD_ERR_EXTENSION: |
|
157 | - $error_msg = __('File upload stopped by extension.', "event_espresso"); |
|
158 | - break; |
|
159 | - default: |
|
160 | - $error_msg = __('An unknown error occurred and the file could not be uploaded', "event_espresso"); |
|
161 | - break; |
|
162 | - } |
|
134 | + switch ( $_FILES['file']['error'][0] ) { |
|
135 | + case UPLOAD_ERR_OK: |
|
136 | + $error_msg = FALSE; |
|
137 | + break; |
|
138 | + case UPLOAD_ERR_INI_SIZE: |
|
139 | + $error_msg = __("'The uploaded file exceeds the upload_max_filesize directive in php.ini.'", "event_espresso"); |
|
140 | + break; |
|
141 | + case UPLOAD_ERR_FORM_SIZE: |
|
142 | + $error_msg = __('The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form.', "event_espresso"); |
|
143 | + break; |
|
144 | + case UPLOAD_ERR_PARTIAL: |
|
145 | + $error_msg = __('The uploaded file was only partially uploaded.', "event_espresso"); |
|
146 | + break; |
|
147 | + case UPLOAD_ERR_NO_FILE: |
|
148 | + $error_msg = __('No file was uploaded.', "event_espresso"); |
|
149 | + break; |
|
150 | + case UPLOAD_ERR_NO_TMP_DIR: |
|
151 | + $error_msg = __('Missing a temporary folder.', "event_espresso"); |
|
152 | + break; |
|
153 | + case UPLOAD_ERR_CANT_WRITE: |
|
154 | + $error_msg = __('Failed to write file to disk.', "event_espresso"); |
|
155 | + break; |
|
156 | + case UPLOAD_ERR_EXTENSION: |
|
157 | + $error_msg = __('File upload stopped by extension.', "event_espresso"); |
|
158 | + break; |
|
159 | + default: |
|
160 | + $error_msg = __('An unknown error occurred and the file could not be uploaded', "event_espresso"); |
|
161 | + break; |
|
162 | + } |
|
163 | 163 | |
164 | 164 | if ( ! $error_msg ) { |
165 | 165 | |
166 | - $filename = $_FILES['file']['name'][0]; |
|
166 | + $filename = $_FILES['file']['name'][0]; |
|
167 | 167 | $file_ext = substr( strrchr( $filename, '.' ), 1 ); |
168 | - $file_type = $_FILES['file']['type'][0]; |
|
169 | - $temp_file = $_FILES['file']['tmp_name'][0]; |
|
170 | - $filesize = $_FILES['file']['size'][0] / 1024;//convert from bytes to KB |
|
168 | + $file_type = $_FILES['file']['type'][0]; |
|
169 | + $temp_file = $_FILES['file']['tmp_name'][0]; |
|
170 | + $filesize = $_FILES['file']['size'][0] / 1024;//convert from bytes to KB |
|
171 | 171 | |
172 | 172 | if ( $file_ext=='csv' ) { |
173 | 173 | |
@@ -302,10 +302,10 @@ discard block |
||
302 | 302 | unset($csv_data_array[EE_CSV::metadata_header]); |
303 | 303 | } |
304 | 304 | /** |
305 | - * @var $old_db_to_new_db_mapping 2d array: toplevel keys being model names, bottom-level keys being the original key, and |
|
306 | - * the value will be the newly-inserted ID. |
|
307 | - * If we have already imported data from the same website via CSV, it shoudl be kept in this wp option |
|
308 | - */ |
|
305 | + * @var $old_db_to_new_db_mapping 2d array: toplevel keys being model names, bottom-level keys being the original key, and |
|
306 | + * the value will be the newly-inserted ID. |
|
307 | + * If we have already imported data from the same website via CSV, it shoudl be kept in this wp option |
|
308 | + */ |
|
309 | 309 | $old_db_to_new_db_mapping = get_option('ee_id_mapping_from'.sanitize_title($old_site_url),array()); |
310 | 310 | if( $old_db_to_new_db_mapping){ |
311 | 311 | EE_Error::add_attention(sprintf(__("We noticed you have imported data via CSV from %s before. Because of this, IDs in your CSV have been mapped to their new IDs in %s", "event_espresso"),$old_site_url,site_url())); |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | -do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | +do_action('AHEE_log', __FILE__, __FUNCTION__, ''); |
|
3 | 3 | /** |
4 | 4 | * EE_Import class |
5 | 5 | * |
@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | */ |
57 | 57 | public static function instance() { |
58 | 58 | // check if class object is instantiated |
59 | - if ( self::$_instance === NULL or ! is_object( self::$_instance ) or ! ( self::$_instance instanceof EE_Import )) { |
|
59 | + if (self::$_instance === NULL or ! is_object(self::$_instance) or ! (self::$_instance instanceof EE_Import)) { |
|
60 | 60 | self::$_instance = new self(); |
61 | 61 | } |
62 | 62 | return self::$_instance; |
@@ -66,7 +66,7 @@ discard block |
||
66 | 66 | * Resets the importer |
67 | 67 | * @return EE_Import |
68 | 68 | */ |
69 | - public static function reset(){ |
|
69 | + public static function reset() { |
|
70 | 70 | self::$_instance = null; |
71 | 71 | return self::instance(); |
72 | 72 | } |
@@ -84,27 +84,27 @@ discard block |
||
84 | 84 | * @param string $type - type of file to import |
85 | 85 | * @ return string |
86 | 86 | */ |
87 | - public function upload_form ( $title, $intro, $form_url, $action, $type ) { |
|
87 | + public function upload_form($title, $intro, $form_url, $action, $type) { |
|
88 | 88 | |
89 | - $form_url = EE_Admin_Page::add_query_args_and_nonce( array( 'action' => $action ), $form_url ); |
|
89 | + $form_url = EE_Admin_Page::add_query_args_and_nonce(array('action' => $action), $form_url); |
|
90 | 90 | |
91 | 91 | ob_start(); |
92 | 92 | ?> |
93 | 93 | <div class="ee-upload-form-dv"> |
94 | - <h3><?php echo $title;?></h3> |
|
95 | - <p><?php echo $intro;?></p> |
|
94 | + <h3><?php echo $title; ?></h3> |
|
95 | + <p><?php echo $intro; ?></p> |
|
96 | 96 | |
97 | 97 | <form action="<?php echo $form_url?>" method="post" enctype="multipart/form-data"> |
98 | - <input type="hidden" name="csv_submitted" value="TRUE" id="<?php echo time();?>"> |
|
99 | - <input name="import" type="hidden" value="<?php echo $type;?>" /> |
|
98 | + <input type="hidden" name="csv_submitted" value="TRUE" id="<?php echo time(); ?>"> |
|
99 | + <input name="import" type="hidden" value="<?php echo $type; ?>" /> |
|
100 | 100 | <input type="file" name="file[]" size="90" > |
101 | - <input class="button-primary" type="submit" value="<?php _e( 'Upload File', 'event_espresso' );?>"> |
|
101 | + <input class="button-primary" type="submit" value="<?php _e('Upload File', 'event_espresso'); ?>"> |
|
102 | 102 | </form> |
103 | 103 | |
104 | 104 | <p class="ee-attention"> |
105 | - <b><?php _e( 'Attention', 'event_espresso' );?></b><br/> |
|
106 | - <?php echo sprintf( __( 'Accepts .%s file types only.', 'event_espresso' ), $type ) ;?> |
|
107 | - <?php echo __( 'Please only import CSV files exported from Event Espresso, or compatible 3rd-party software.', 'event_espresso' );?> |
|
105 | + <b><?php _e('Attention', 'event_espresso'); ?></b><br/> |
|
106 | + <?php echo sprintf(__('Accepts .%s file types only.', 'event_espresso'), $type); ?> |
|
107 | + <?php echo __('Please only import CSV files exported from Event Espresso, or compatible 3rd-party software.', 'event_espresso'); ?> |
|
108 | 108 | </p> |
109 | 109 | |
110 | 110 | </div> |
@@ -125,13 +125,13 @@ discard block |
||
125 | 125 | */ |
126 | 126 | public function import() { |
127 | 127 | |
128 | - require_once( EE_CLASSES . 'EE_CSV.class.php' ); |
|
128 | + require_once(EE_CLASSES.'EE_CSV.class.php'); |
|
129 | 129 | $this->EE_CSV = EE_CSV::instance(); |
130 | 130 | |
131 | - if ( isset( $_REQUEST['import'] )) { |
|
132 | - if( isset( $_POST['csv_submitted'] )) { |
|
131 | + if (isset($_REQUEST['import'])) { |
|
132 | + if (isset($_POST['csv_submitted'])) { |
|
133 | 133 | |
134 | - switch ( $_FILES['file']['error'][0] ) { |
|
134 | + switch ($_FILES['file']['error'][0]) { |
|
135 | 135 | case UPLOAD_ERR_OK: |
136 | 136 | $error_msg = FALSE; |
137 | 137 | break; |
@@ -161,32 +161,32 @@ discard block |
||
161 | 161 | break; |
162 | 162 | } |
163 | 163 | |
164 | - if ( ! $error_msg ) { |
|
164 | + if ( ! $error_msg) { |
|
165 | 165 | |
166 | - $filename = $_FILES['file']['name'][0]; |
|
167 | - $file_ext = substr( strrchr( $filename, '.' ), 1 ); |
|
168 | - $file_type = $_FILES['file']['type'][0]; |
|
169 | - $temp_file = $_FILES['file']['tmp_name'][0]; |
|
170 | - $filesize = $_FILES['file']['size'][0] / 1024;//convert from bytes to KB |
|
166 | + $filename = $_FILES['file']['name'][0]; |
|
167 | + $file_ext = substr(strrchr($filename, '.'), 1); |
|
168 | + $file_type = $_FILES['file']['type'][0]; |
|
169 | + $temp_file = $_FILES['file']['tmp_name'][0]; |
|
170 | + $filesize = $_FILES['file']['size'][0] / 1024; //convert from bytes to KB |
|
171 | 171 | |
172 | - if ( $file_ext=='csv' ) { |
|
172 | + if ($file_ext == 'csv') { |
|
173 | 173 | |
174 | - $max_upload = $this->EE_CSV->get_max_upload_size();//max upload size in KB |
|
175 | - if ( $filesize < $max_upload || true) { |
|
174 | + $max_upload = $this->EE_CSV->get_max_upload_size(); //max upload size in KB |
|
175 | + if ($filesize < $max_upload || true) { |
|
176 | 176 | |
177 | - $wp_upload_dir = str_replace( array( '\\', '/' ), DS, wp_upload_dir()); |
|
178 | - $path_to_file = $wp_upload_dir['basedir'] . DS . 'espresso' . DS . $filename; |
|
177 | + $wp_upload_dir = str_replace(array('\\', '/'), DS, wp_upload_dir()); |
|
178 | + $path_to_file = $wp_upload_dir['basedir'].DS.'espresso'.DS.$filename; |
|
179 | 179 | |
180 | - if( move_uploaded_file( $temp_file, $path_to_file )) { |
|
180 | + if (move_uploaded_file($temp_file, $path_to_file)) { |
|
181 | 181 | |
182 | 182 | // convert csv to array |
183 | - $this->csv_array = $this->EE_CSV->import_csv_to_model_data_array( $path_to_file ); |
|
183 | + $this->csv_array = $this->EE_CSV->import_csv_to_model_data_array($path_to_file); |
|
184 | 184 | |
185 | 185 | // was data successfully stored in an array? |
186 | - if ( is_array( $this->csv_array ) ) { |
|
186 | + if (is_array($this->csv_array)) { |
|
187 | 187 | |
188 | - $import_what = str_replace( 'csv_import_', '', $_REQUEST['action'] ); |
|
189 | - $import_what = str_replace( '_', ' ', ucwords( $import_what )); |
|
188 | + $import_what = str_replace('csv_import_', '', $_REQUEST['action']); |
|
189 | + $import_what = str_replace('_', ' ', ucwords($import_what)); |
|
190 | 190 | $processed_data = $this->csv_array; |
191 | 191 | $this->columns_to_save = FALSE; |
192 | 192 | |
@@ -205,33 +205,33 @@ discard block |
||
205 | 205 | |
206 | 206 | } |
207 | 207 | // save processed codes to db |
208 | - if ( $this->save_csv_data_array_to_db( $processed_data, $this->columns_to_save ) ) { |
|
208 | + if ($this->save_csv_data_array_to_db($processed_data, $this->columns_to_save)) { |
|
209 | 209 | return TRUE; |
210 | 210 | |
211 | 211 | } |
212 | 212 | } else { |
213 | 213 | // no array? must be an error |
214 | - EE_Error::add_error(sprintf(__("No file seems to have been uploaded", "event_espresso")), __FILE__, __FUNCTION__, __LINE__ ); |
|
214 | + EE_Error::add_error(sprintf(__("No file seems to have been uploaded", "event_espresso")), __FILE__, __FUNCTION__, __LINE__); |
|
215 | 215 | return FALSE; |
216 | 216 | } |
217 | 217 | |
218 | 218 | } else { |
219 | - EE_Error::add_error(sprintf(__("%s was not successfully uploaded", "event_espresso"),$filename), __FILE__, __FUNCTION__, __LINE__ ); |
|
219 | + EE_Error::add_error(sprintf(__("%s was not successfully uploaded", "event_espresso"), $filename), __FILE__, __FUNCTION__, __LINE__); |
|
220 | 220 | return FALSE; |
221 | 221 | } |
222 | 222 | |
223 | 223 | } else { |
224 | - EE_Error::add_error( sprintf(__("%s was too large of a file and could not be uploaded. The max filesize is %s' KB.", "event_espresso"),$filename,$max_upload), __FILE__, __FUNCTION__, __LINE__ ); |
|
224 | + EE_Error::add_error(sprintf(__("%s was too large of a file and could not be uploaded. The max filesize is %s' KB.", "event_espresso"), $filename, $max_upload), __FILE__, __FUNCTION__, __LINE__); |
|
225 | 225 | return FALSE; |
226 | 226 | } |
227 | 227 | |
228 | 228 | } else { |
229 | - EE_Error::add_error( sprintf(__("%s had an invalid file extension, not uploaded", "event_espresso"),$filename), __FILE__, __FUNCTION__, __LINE__ ); |
|
229 | + EE_Error::add_error(sprintf(__("%s had an invalid file extension, not uploaded", "event_espresso"), $filename), __FILE__, __FUNCTION__, __LINE__); |
|
230 | 230 | return FALSE; |
231 | 231 | } |
232 | 232 | |
233 | 233 | } else { |
234 | - EE_Error::add_error( $error_msg, __FILE__, __FUNCTION__, __LINE__ ); |
|
234 | + EE_Error::add_error($error_msg, __FILE__, __FUNCTION__, __LINE__); |
|
235 | 235 | return FALSE; |
236 | 236 | } |
237 | 237 | |
@@ -272,7 +272,7 @@ discard block |
||
272 | 272 | * @param array $fields_to_save - an array containing the csv column names as keys with the corresponding db table fields they will be saved to |
273 | 273 | * @return TRUE on success, FALSE on fail |
274 | 274 | */ |
275 | - public function save_csv_data_array_to_db( $csv_data_array, $model_name = FALSE ) { |
|
275 | + public function save_csv_data_array_to_db($csv_data_array, $model_name = FALSE) { |
|
276 | 276 | |
277 | 277 | |
278 | 278 | $success = FALSE; |
@@ -282,22 +282,22 @@ discard block |
||
282 | 282 | $export_from_site_a_to_b = true; |
283 | 283 | // first level of array is not table information but a table name was passed to the function |
284 | 284 | // array is only two levels deep, so let's fix that by adding a level, else the next steps will fail |
285 | - if($model_name){ |
|
285 | + if ($model_name) { |
|
286 | 286 | $csv_data_array = array($csv_data_array); |
287 | 287 | } |
288 | 288 | // begin looking through the $csv_data_array, expecting the toplevel key to be the model's name... |
289 | 289 | $old_site_url = 'none-specified'; |
290 | 290 | |
291 | 291 | //hanlde metadata |
292 | - if(isset($csv_data_array[EE_CSV::metadata_header]) ){ |
|
292 | + if (isset($csv_data_array[EE_CSV::metadata_header])) { |
|
293 | 293 | $csv_metadata = array_shift($csv_data_array[EE_CSV::metadata_header]); |
294 | 294 | //ok so its metadata, dont try to save it to ehte db obviously... |
295 | - if(isset($csv_metadata['site_url']) && $csv_metadata['site_url'] == site_url()){ |
|
295 | + if (isset($csv_metadata['site_url']) && $csv_metadata['site_url'] == site_url()) { |
|
296 | 296 | EE_Error::add_attention(sprintf(__("CSV Data appears to be from the same database, so attempting to update data", "event_espresso"))); |
297 | 297 | $export_from_site_a_to_b = false; |
298 | - }else{ |
|
299 | - $old_site_url = isset( $csv_metadata['site_url']) ? $csv_metadata['site_url'] : $old_site_url; |
|
300 | - EE_Error::add_attention(sprintf(__("CSV Data appears to be from a different database (%s instead of %s), so we assume IDs in the CSV data DO NOT correspond to IDs in this database", "event_espresso"),$old_site_url,site_url())); |
|
298 | + } else { |
|
299 | + $old_site_url = isset($csv_metadata['site_url']) ? $csv_metadata['site_url'] : $old_site_url; |
|
300 | + EE_Error::add_attention(sprintf(__("CSV Data appears to be from a different database (%s instead of %s), so we assume IDs in the CSV data DO NOT correspond to IDs in this database", "event_espresso"), $old_site_url, site_url())); |
|
301 | 301 | }; |
302 | 302 | unset($csv_data_array[EE_CSV::metadata_header]); |
303 | 303 | } |
@@ -306,40 +306,40 @@ discard block |
||
306 | 306 | * the value will be the newly-inserted ID. |
307 | 307 | * If we have already imported data from the same website via CSV, it shoudl be kept in this wp option |
308 | 308 | */ |
309 | - $old_db_to_new_db_mapping = get_option('ee_id_mapping_from'.sanitize_title($old_site_url),array()); |
|
310 | - if( $old_db_to_new_db_mapping){ |
|
311 | - EE_Error::add_attention(sprintf(__("We noticed you have imported data via CSV from %s before. Because of this, IDs in your CSV have been mapped to their new IDs in %s", "event_espresso"),$old_site_url,site_url())); |
|
309 | + $old_db_to_new_db_mapping = get_option('ee_id_mapping_from'.sanitize_title($old_site_url), array()); |
|
310 | + if ($old_db_to_new_db_mapping) { |
|
311 | + EE_Error::add_attention(sprintf(__("We noticed you have imported data via CSV from %s before. Because of this, IDs in your CSV have been mapped to their new IDs in %s", "event_espresso"), $old_site_url, site_url())); |
|
312 | 312 | } |
313 | 313 | $old_db_to_new_db_mapping = $this->save_data_rows_to_db($csv_data_array, $export_from_site_a_to_b, $old_db_to_new_db_mapping); |
314 | 314 | |
315 | 315 | //save the mapping from old db to new db in case they try re-importing the same data from the same website again |
316 | - update_option('ee_id_mapping_from'.sanitize_title($old_site_url),$old_db_to_new_db_mapping); |
|
316 | + update_option('ee_id_mapping_from'.sanitize_title($old_site_url), $old_db_to_new_db_mapping); |
|
317 | 317 | |
318 | - if ( $this->_total_updates > 0 ) { |
|
319 | - EE_Error::add_success( sprintf(__("%s existing records in the database were updated.", "event_espresso"),$this->_total_updates)); |
|
318 | + if ($this->_total_updates > 0) { |
|
319 | + EE_Error::add_success(sprintf(__("%s existing records in the database were updated.", "event_espresso"), $this->_total_updates)); |
|
320 | 320 | $success = true; |
321 | 321 | } |
322 | - if ( $this->_total_inserts > 0 ) { |
|
323 | - EE_Error::add_success(sprintf(__("%s new records were added to the database.", "event_espresso"),$this->_total_inserts)); |
|
322 | + if ($this->_total_inserts > 0) { |
|
323 | + EE_Error::add_success(sprintf(__("%s new records were added to the database.", "event_espresso"), $this->_total_inserts)); |
|
324 | 324 | $success = true; |
325 | 325 | } |
326 | 326 | |
327 | - if ( $this->_total_update_errors > 0 ) { |
|
328 | - EE_Error::add_error(sprintf(__("'One or more errors occurred, and a total of %s existing records in the database were <strong>not</strong> updated.'", "event_espresso"),$this->_total_update_errors), __FILE__, __FUNCTION__, __LINE__ ); |
|
327 | + if ($this->_total_update_errors > 0) { |
|
328 | + EE_Error::add_error(sprintf(__("'One or more errors occurred, and a total of %s existing records in the database were <strong>not</strong> updated.'", "event_espresso"), $this->_total_update_errors), __FILE__, __FUNCTION__, __LINE__); |
|
329 | 329 | $error = true; |
330 | 330 | } |
331 | - if ( $this->_total_insert_errors > 0 ) { |
|
332 | - EE_Error::add_error(sprintf(__("One or more errors occurred, and a total of %s new records were <strong>not</strong> added to the database.'", "event_espresso"),$this->_total_insert_errors), __FILE__, __FUNCTION__, __LINE__ ); |
|
331 | + if ($this->_total_insert_errors > 0) { |
|
332 | + EE_Error::add_error(sprintf(__("One or more errors occurred, and a total of %s new records were <strong>not</strong> added to the database.'", "event_espresso"), $this->_total_insert_errors), __FILE__, __FUNCTION__, __LINE__); |
|
333 | 333 | $error = true; |
334 | 334 | } |
335 | 335 | |
336 | 336 | //lastly, we need to update the datetime and ticket sold amounts |
337 | 337 | //as those may ahve been affected by this |
338 | - EEM_Datetime::instance()->update_sold( EEM_Datetime::instance()->get_all() ); |
|
338 | + EEM_Datetime::instance()->update_sold(EEM_Datetime::instance()->get_all()); |
|
339 | 339 | EEM_Ticket::instance()->update_tickets_sold(EEM_Ticket::instance()->get_all()); |
340 | 340 | |
341 | 341 | // if there was at least one success and absolutely no errors |
342 | - if ( $success && ! $error ) { |
|
342 | + if ($success && ! $error) { |
|
343 | 343 | return TRUE; |
344 | 344 | } else { |
345 | 345 | return FALSE; |
@@ -371,81 +371,81 @@ discard block |
||
371 | 371 | * @param type $old_db_to_new_db_mapping |
372 | 372 | * @return array updated $old_db_to_new_db_mapping |
373 | 373 | */ |
374 | - public function save_data_rows_to_db( $csv_data_array, $export_from_site_a_to_b, $old_db_to_new_db_mapping ) { |
|
375 | - foreach ( $csv_data_array as $model_name_in_csv_data => $model_data_from_import ) { |
|
374 | + public function save_data_rows_to_db($csv_data_array, $export_from_site_a_to_b, $old_db_to_new_db_mapping) { |
|
375 | + foreach ($csv_data_array as $model_name_in_csv_data => $model_data_from_import) { |
|
376 | 376 | //now check that assumption was correct. If |
377 | - if ( EE_Registry::instance()->is_model_name($model_name_in_csv_data)) { |
|
377 | + if (EE_Registry::instance()->is_model_name($model_name_in_csv_data)) { |
|
378 | 378 | $model_name = $model_name_in_csv_data; |
379 | - }else { |
|
379 | + } else { |
|
380 | 380 | // no table info in the array and no table name passed to the function?? FAIL |
381 | - EE_Error::add_error( __('No table information was specified and/or found, therefore the import could not be completed','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ); |
|
381 | + EE_Error::add_error(__('No table information was specified and/or found, therefore the import could not be completed', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
382 | 382 | return FALSE; |
383 | 383 | } |
384 | 384 | /* @var $model EEM_Base */ |
385 | 385 | $model = EE_Registry::instance()->load_model($model_name); |
386 | 386 | |
387 | 387 | //so without further ado, scanning all the data provided for primary keys and their inital values |
388 | - foreach ( $model_data_from_import as $model_object_data ) { |
|
388 | + foreach ($model_data_from_import as $model_object_data) { |
|
389 | 389 | //before we do ANYTHING, make sure the csv row wasn't just completely blank |
390 | 390 | $row_is_completely_empty = true; |
391 | - foreach($model_object_data as $field){ |
|
392 | - if($field){ |
|
391 | + foreach ($model_object_data as $field) { |
|
392 | + if ($field) { |
|
393 | 393 | $row_is_completely_empty = false; |
394 | 394 | } |
395 | 395 | } |
396 | - if($row_is_completely_empty){ |
|
396 | + if ($row_is_completely_empty) { |
|
397 | 397 | continue; |
398 | 398 | } |
399 | 399 | //find the PK in the row of data (or a combined key if |
400 | 400 | //there is no primary key) |
401 | - if($model->has_primary_key_field()){ |
|
402 | - $id_in_csv = $model_object_data[$model->primary_key_name()]; |
|
403 | - }else{ |
|
401 | + if ($model->has_primary_key_field()) { |
|
402 | + $id_in_csv = $model_object_data[$model->primary_key_name()]; |
|
403 | + } else { |
|
404 | 404 | $id_in_csv = $model->get_index_primary_key_string($model_object_data); |
405 | 405 | } |
406 | 406 | |
407 | 407 | |
408 | - $model_object_data = $this->_replace_temp_ids_with_mappings( $model_object_data, $model, $old_db_to_new_db_mapping, $export_from_site_a_to_b ); |
|
408 | + $model_object_data = $this->_replace_temp_ids_with_mappings($model_object_data, $model, $old_db_to_new_db_mapping, $export_from_site_a_to_b); |
|
409 | 409 | //now we need to decide if we're going to add a new model object given the $model_object_data, |
410 | 410 | //or just update. |
411 | - if($export_from_site_a_to_b){ |
|
412 | - $what_to_do = $this->_decide_whether_to_insert_or_update_given_data_from_other_db( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ); |
|
413 | - }else{//this is just a re-import |
|
414 | - $what_to_do = $this->_decide_whether_to_insert_or_update_given_data_from_same_db( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ); |
|
411 | + if ($export_from_site_a_to_b) { |
|
412 | + $what_to_do = $this->_decide_whether_to_insert_or_update_given_data_from_other_db($id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping); |
|
413 | + } else {//this is just a re-import |
|
414 | + $what_to_do = $this->_decide_whether_to_insert_or_update_given_data_from_same_db($id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping); |
|
415 | 415 | } |
416 | - if( $what_to_do == self::do_nothing ) { |
|
416 | + if ($what_to_do == self::do_nothing) { |
|
417 | 417 | continue; |
418 | 418 | } |
419 | 419 | |
420 | 420 | //double-check we actually want to insert, if that's what we're planning |
421 | 421 | //based on whether this item would be unique in the DB or not |
422 | - if( $what_to_do == self::do_insert ) { |
|
422 | + if ($what_to_do == self::do_insert) { |
|
423 | 423 | //we're supposed to be inserting. But wait, will this thing |
424 | 424 | //be acceptable if inserted? |
425 | - $conflicting = $model->get_one_conflicting( $model_object_data, false ); |
|
426 | - if($conflicting){ |
|
425 | + $conflicting = $model->get_one_conflicting($model_object_data, false); |
|
426 | + if ($conflicting) { |
|
427 | 427 | //ok, this item would conflict if inserted. Just update the item that it conflicts with. |
428 | 428 | $what_to_do = self::do_update; |
429 | 429 | //and if this model has a primary key, remember its mapping |
430 | - if($model->has_primary_key_field()){ |
|
430 | + if ($model->has_primary_key_field()) { |
|
431 | 431 | $old_db_to_new_db_mapping[$model_name][$id_in_csv] = $conflicting->ID(); |
432 | 432 | $model_object_data[$model->primary_key_name()] = $conflicting->ID(); |
433 | - }else{ |
|
433 | + } else { |
|
434 | 434 | //we want to update this conflicting item, instead of inserting a conflicting item |
435 | 435 | //so we need to make sure they match entirely (its possible that they only conflicted on one field, but we need them to match on other fields |
436 | 436 | //for the WHERE conditions in the update). At the time of this comment, there were no models like this |
437 | - foreach($model->get_combined_primary_key_fields() as $key_field){ |
|
437 | + foreach ($model->get_combined_primary_key_fields() as $key_field) { |
|
438 | 438 | $model_object_data[$key_field->get_name()] = $conflicting->get($key_field->get_name()); |
439 | 439 | } |
440 | 440 | } |
441 | 441 | } |
442 | 442 | } |
443 | - if( $what_to_do == self::do_insert ) { |
|
444 | - $old_db_to_new_db_mapping = $this->_insert_from_data_array( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ); |
|
445 | - }elseif( $what_to_do == self::do_update ) { |
|
446 | - $old_db_to_new_db_mapping = $this->_update_from_data_array( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ); |
|
447 | - }else{ |
|
448 | - throw new EE_Error( sprintf( __( 'Programming error. We shoudl be inserting or updating, but instead we are being told to "%s", whifh is invalid', 'event_espresso' ), $what_to_do ) ); |
|
443 | + if ($what_to_do == self::do_insert) { |
|
444 | + $old_db_to_new_db_mapping = $this->_insert_from_data_array($id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping); |
|
445 | + }elseif ($what_to_do == self::do_update) { |
|
446 | + $old_db_to_new_db_mapping = $this->_update_from_data_array($id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping); |
|
447 | + } else { |
|
448 | + throw new EE_Error(sprintf(__('Programming error. We shoudl be inserting or updating, but instead we are being told to "%s", whifh is invalid', 'event_espresso'), $what_to_do)); |
|
449 | 449 | } |
450 | 450 | } |
451 | 451 | } |
@@ -466,13 +466,13 @@ discard block |
||
466 | 466 | * @param array $old_db_to_new_db_mapping by reference so it can be modified |
467 | 467 | * @return string one of the consts on this class that starts with do_* |
468 | 468 | */ |
469 | - protected function _decide_whether_to_insert_or_update_given_data_from_other_db( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ) { |
|
469 | + protected function _decide_whether_to_insert_or_update_given_data_from_other_db($id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping) { |
|
470 | 470 | $model_name = $model->get_this_model_name(); |
471 | 471 | //if it's a site-to-site export-and-import, see if this modelobject's id |
472 | 472 | //in the old data that we know of |
473 | - if( isset($old_db_to_new_db_mapping[$model_name][$id_in_csv]) ){ |
|
473 | + if (isset($old_db_to_new_db_mapping[$model_name][$id_in_csv])) { |
|
474 | 474 | return self::do_update; |
475 | - }else{ |
|
475 | + } else { |
|
476 | 476 | return self::do_insert; |
477 | 477 | } |
478 | 478 | } |
@@ -487,11 +487,11 @@ discard block |
||
487 | 487 | * @param type $old_db_to_new_db_mapping |
488 | 488 | * @return |
489 | 489 | */ |
490 | - protected function _decide_whether_to_insert_or_update_given_data_from_same_db( $id_in_csv, $model_object_data, $model ) { |
|
490 | + protected function _decide_whether_to_insert_or_update_given_data_from_same_db($id_in_csv, $model_object_data, $model) { |
|
491 | 491 | //in this case, check if this thing ACTUALLY exists in the database |
492 | - if( $model->get_one_conflicting( $model_object_data ) ){ |
|
492 | + if ($model->get_one_conflicting($model_object_data)) { |
|
493 | 493 | return self::do_update; |
494 | - }else{ |
|
494 | + } else { |
|
495 | 495 | return self::do_insert; |
496 | 496 | } |
497 | 497 | } |
@@ -510,55 +510,55 @@ discard block |
||
510 | 510 | * @param boolean $export_from_site_a_to_b |
511 | 511 | * @return array updated model object data with temp IDs removed |
512 | 512 | */ |
513 | - protected function _replace_temp_ids_with_mappings( $model_object_data, $model, $old_db_to_new_db_mapping, $export_from_site_a_to_b ) { |
|
513 | + protected function _replace_temp_ids_with_mappings($model_object_data, $model, $old_db_to_new_db_mapping, $export_from_site_a_to_b) { |
|
514 | 514 | //if this model object's primary key is in the mapping, replace it |
515 | - if( $model->has_primary_key_field() && |
|
515 | + if ($model->has_primary_key_field() && |
|
516 | 516 | $model->get_primary_key_field()->is_auto_increment() && |
517 | - isset( $old_db_to_new_db_mapping[ $model->get_this_model_name() ] ) && |
|
518 | - isset( $old_db_to_new_db_mapping[ $model->get_this_model_name() ][ $model_object_data[ $model->primary_key_name() ] ] ) ) { |
|
519 | - $model_object_data[ $model->primary_key_name() ] = $old_db_to_new_db_mapping[ $model->get_this_model_name() ][ $model_object_data[ $model->primary_key_name() ] ]; |
|
517 | + isset($old_db_to_new_db_mapping[$model->get_this_model_name()]) && |
|
518 | + isset($old_db_to_new_db_mapping[$model->get_this_model_name()][$model_object_data[$model->primary_key_name()]])) { |
|
519 | + $model_object_data[$model->primary_key_name()] = $old_db_to_new_db_mapping[$model->get_this_model_name()][$model_object_data[$model->primary_key_name()]]; |
|
520 | 520 | } |
521 | 521 | |
522 | - try{ |
|
522 | + try { |
|
523 | 523 | $model_name_field = $model->get_field_containing_related_model_name(); |
524 | 524 | $models_pointed_to_by_model_name_field = $model_name_field->get_model_names_pointed_to(); |
525 | - }catch( EE_Error $e ){ |
|
525 | + } catch (EE_Error $e) { |
|
526 | 526 | $model_name_field = NULL; |
527 | 527 | $models_pointed_to_by_model_name_field = array(); |
528 | 528 | } |
529 | - foreach( $model->field_settings( true ) as $field_obj ){ |
|
530 | - if( $field_obj instanceof EE_Foreign_Key_Int_Field ) { |
|
529 | + foreach ($model->field_settings(true) as $field_obj) { |
|
530 | + if ($field_obj instanceof EE_Foreign_Key_Int_Field) { |
|
531 | 531 | $models_pointed_to = $field_obj->get_model_names_pointed_to(); |
532 | 532 | $found_a_mapping = false; |
533 | - foreach( $models_pointed_to as $model_pointed_to_by_fk ) { |
|
533 | + foreach ($models_pointed_to as $model_pointed_to_by_fk) { |
|
534 | 534 | |
535 | - if( $model_name_field ){ |
|
536 | - $value_of_model_name_field = $model_object_data[ $model_name_field->get_name() ]; |
|
537 | - if( $value_of_model_name_field == $model_pointed_to_by_fk ) { |
|
538 | - $model_object_data[ $field_obj->get_name() ] = $this->_find_mapping_in( |
|
539 | - $model_object_data[ $field_obj->get_name() ], |
|
535 | + if ($model_name_field) { |
|
536 | + $value_of_model_name_field = $model_object_data[$model_name_field->get_name()]; |
|
537 | + if ($value_of_model_name_field == $model_pointed_to_by_fk) { |
|
538 | + $model_object_data[$field_obj->get_name()] = $this->_find_mapping_in( |
|
539 | + $model_object_data[$field_obj->get_name()], |
|
540 | 540 | $model_pointed_to_by_fk, |
541 | 541 | $old_db_to_new_db_mapping, |
542 | 542 | $export_from_site_a_to_b ); |
543 | 543 | $found_a_mapping = true; |
544 | 544 | break; |
545 | 545 | } |
546 | - }else{ |
|
547 | - $model_object_data[ $field_obj->get_name() ] = $this->_find_mapping_in( |
|
548 | - $model_object_data[ $field_obj->get_name() ], |
|
546 | + } else { |
|
547 | + $model_object_data[$field_obj->get_name()] = $this->_find_mapping_in( |
|
548 | + $model_object_data[$field_obj->get_name()], |
|
549 | 549 | $model_pointed_to_by_fk, |
550 | 550 | $old_db_to_new_db_mapping, |
551 | 551 | $export_from_site_a_to_b ); |
552 | 552 | $found_a_mapping = true; |
553 | 553 | } |
554 | 554 | //once we've found a mapping for this field no need to continue |
555 | - if( $found_a_mapping ) { |
|
555 | + if ($found_a_mapping) { |
|
556 | 556 | break; |
557 | 557 | } |
558 | 558 | |
559 | 559 | |
560 | 560 | } |
561 | - }else{ |
|
561 | + } else { |
|
562 | 562 | //it's a string foreign key (which we leave alone, because those are things |
563 | 563 | //like country names, which we'd really rather not make 2 USAs etc (we'd actually |
564 | 564 | //prefer to just update one) |
@@ -566,8 +566,8 @@ discard block |
||
566 | 566 | } |
567 | 567 | } |
568 | 568 | // |
569 | - if( $model instanceof EEM_Term_Taxonomy ){ |
|
570 | - $model_object_data = $this->_handle_split_term_ids( $model_object_data ); |
|
569 | + if ($model instanceof EEM_Term_Taxonomy) { |
|
570 | + $model_object_data = $this->_handle_split_term_ids($model_object_data); |
|
571 | 571 | } |
572 | 572 | return $model_object_data; |
573 | 573 | } |
@@ -579,11 +579,11 @@ discard block |
||
579 | 579 | * @param type $model_object_data |
580 | 580 | * @return array new model object data |
581 | 581 | */ |
582 | - protected function _handle_split_term_ids( $model_object_data ){ |
|
583 | - if( isset( $model_object_data['term_id'] ) && isset( $model_object_data[ 'taxonomy' ]) && apply_filters( 'FHEE__EE_Import__handle_split_term_ids__function_exists', function_exists( 'wp_get_split_term' ), $model_object_data ) ) { |
|
584 | - $new_term_id = wp_get_split_term( $model_object_data[ 'term_id' ], $model_object_data[ 'taxonomy' ] ); |
|
585 | - if( $new_term_id ){ |
|
586 | - $model_object_data[ 'term_id' ] = $new_term_id; |
|
582 | + protected function _handle_split_term_ids($model_object_data) { |
|
583 | + if (isset($model_object_data['term_id']) && isset($model_object_data['taxonomy']) && apply_filters('FHEE__EE_Import__handle_split_term_ids__function_exists', function_exists('wp_get_split_term'), $model_object_data)) { |
|
584 | + $new_term_id = wp_get_split_term($model_object_data['term_id'], $model_object_data['taxonomy']); |
|
585 | + if ($new_term_id) { |
|
586 | + $model_object_data['term_id'] = $new_term_id; |
|
587 | 587 | } |
588 | 588 | } |
589 | 589 | return $model_object_data; |
@@ -597,18 +597,18 @@ discard block |
||
597 | 597 | * @param type $export_from_site_a_to_b |
598 | 598 | * @return int |
599 | 599 | */ |
600 | - protected function _find_mapping_in( $object_id, $model_name, $old_db_to_new_db_mapping, $export_from_site_a_to_b) { |
|
601 | - if( isset( $old_db_to_new_db_mapping[ $model_name ][ $object_id ] ) ){ |
|
600 | + protected function _find_mapping_in($object_id, $model_name, $old_db_to_new_db_mapping, $export_from_site_a_to_b) { |
|
601 | + if (isset($old_db_to_new_db_mapping[$model_name][$object_id])) { |
|
602 | 602 | |
603 | - return $old_db_to_new_db_mapping[ $model_name ][ $object_id ]; |
|
604 | - }elseif( $object_id == '0' || $object_id == '' ) { |
|
603 | + return $old_db_to_new_db_mapping[$model_name][$object_id]; |
|
604 | + }elseif ($object_id == '0' || $object_id == '') { |
|
605 | 605 | //leave as-is |
606 | 606 | return $object_id; |
607 | - }elseif( $export_from_site_a_to_b ){ |
|
607 | + }elseif ($export_from_site_a_to_b) { |
|
608 | 608 | //we couldn't find a mapping for this, and it's from a different site, |
609 | 609 | //so blank it out |
610 | 610 | return NULL; |
611 | - }elseif( ! $export_from_site_a_to_b ) { |
|
611 | + }elseif ( ! $export_from_site_a_to_b) { |
|
612 | 612 | //we coudln't find a mapping for this, but it's from thsi DB anyway |
613 | 613 | //so let's just leave it as-is |
614 | 614 | return $object_id; |
@@ -623,36 +623,36 @@ discard block |
||
623 | 623 | * @param type $old_db_to_new_db_mapping |
624 | 624 | * @return array updated $old_db_to_new_db_mapping |
625 | 625 | */ |
626 | - protected function _insert_from_data_array( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ) { |
|
626 | + protected function _insert_from_data_array($id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping) { |
|
627 | 627 | //remove the primary key, if there is one (we don't want it for inserts OR updates) |
628 | 628 | //we'll put it back in if we need it |
629 | - if($model->has_primary_key_field() && $model->get_primary_key_field()->is_auto_increment()){ |
|
629 | + if ($model->has_primary_key_field() && $model->get_primary_key_field()->is_auto_increment()) { |
|
630 | 630 | $effective_id = $model_object_data[$model->primary_key_name()]; |
631 | 631 | unset($model_object_data[$model->primary_key_name()]); |
632 | - }else{ |
|
633 | - $effective_id = $model->get_index_primary_key_string( $model_object_data ); |
|
632 | + } else { |
|
633 | + $effective_id = $model->get_index_primary_key_string($model_object_data); |
|
634 | 634 | } |
635 | 635 | //the model takes care of validating the CSV's input |
636 | - try{ |
|
636 | + try { |
|
637 | 637 | $new_id = $model->insert($model_object_data); |
638 | - if( $new_id ){ |
|
638 | + if ($new_id) { |
|
639 | 639 | $old_db_to_new_db_mapping[$model->get_this_model_name()][$id_in_csv] = $new_id; |
640 | 640 | $this->_total_inserts++; |
641 | - EE_Error::add_success( sprintf(__("Successfully added new %s (with id %s) with csv data %s", "event_espresso"),$model->get_this_model_name(),$new_id, implode(",",$model_object_data))); |
|
642 | - }else{ |
|
641 | + EE_Error::add_success(sprintf(__("Successfully added new %s (with id %s) with csv data %s", "event_espresso"), $model->get_this_model_name(), $new_id, implode(",", $model_object_data))); |
|
642 | + } else { |
|
643 | 643 | $this->_total_insert_errors++; |
644 | 644 | //put the ID used back in there for the error message |
645 | - if($model->has_primary_key_field()){ |
|
645 | + if ($model->has_primary_key_field()) { |
|
646 | 646 | $model_object_data[$model->primary_key_name()] = $effective_id; |
647 | 647 | } |
648 | - EE_Error::add_error( sprintf(__("Could not insert new %s with the csv data: %s", "event_espresso"),$model->get_this_model_name(),http_build_query($model_object_data)), __FILE__, __FUNCTION__, __LINE__ ); |
|
648 | + EE_Error::add_error(sprintf(__("Could not insert new %s with the csv data: %s", "event_espresso"), $model->get_this_model_name(), http_build_query($model_object_data)), __FILE__, __FUNCTION__, __LINE__); |
|
649 | 649 | } |
650 | - }catch(EE_Error $e){ |
|
650 | + } catch (EE_Error $e) { |
|
651 | 651 | $this->_total_insert_errors++; |
652 | - if($model->has_primary_key_field()){ |
|
652 | + if ($model->has_primary_key_field()) { |
|
653 | 653 | $model_object_data[$model->primary_key_name()] = $effective_id; |
654 | 654 | } |
655 | - EE_Error::add_error( sprintf(__("Could not insert new %s with the csv data: %s because %s", "event_espresso"),$model->get_this_model_name(),implode(",",$model_object_data),$e->getMessage()), __FILE__, __FUNCTION__, __LINE__ ); |
|
655 | + EE_Error::add_error(sprintf(__("Could not insert new %s with the csv data: %s because %s", "event_espresso"), $model->get_this_model_name(), implode(",", $model_object_data), $e->getMessage()), __FILE__, __FUNCTION__, __LINE__); |
|
656 | 656 | } |
657 | 657 | return $old_db_to_new_db_mapping; |
658 | 658 | } |
@@ -665,55 +665,55 @@ discard block |
||
665 | 665 | * @param array $old_db_to_new_db_mapping |
666 | 666 | * @return array updated $old_db_to_new_db_mapping |
667 | 667 | */ |
668 | - protected function _update_from_data_array( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ) { |
|
669 | - try{ |
|
668 | + protected function _update_from_data_array($id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping) { |
|
669 | + try { |
|
670 | 670 | //let's keep two copies of the model object data: |
671 | 671 | //one for performing an update, one for everthing else |
672 | 672 | $model_object_data_for_update = $model_object_data; |
673 | - if($model->has_primary_key_field()){ |
|
673 | + if ($model->has_primary_key_field()) { |
|
674 | 674 | $conditions = array($model->primary_key_name() => $model_object_data[$model->primary_key_name()]); |
675 | 675 | //remove the primary key because we shouldn't use it for updating |
676 | 676 | unset($model_object_data_for_update[$model->primary_key_name()]); |
677 | - }elseif($model->get_combined_primary_key_fields() > 1 ){ |
|
677 | + }elseif ($model->get_combined_primary_key_fields() > 1) { |
|
678 | 678 | $conditions = array(); |
679 | - foreach($model->get_combined_primary_key_fields() as $key_field){ |
|
679 | + foreach ($model->get_combined_primary_key_fields() as $key_field) { |
|
680 | 680 | $conditions[$key_field->get_name()] = $model_object_data[$key_field->get_name()]; |
681 | 681 | } |
682 | - }else{ |
|
683 | - $model->primary_key_name();//this shoudl just throw an exception, explaining that we dont have a primary key (or a combine dkey) |
|
682 | + } else { |
|
683 | + $model->primary_key_name(); //this shoudl just throw an exception, explaining that we dont have a primary key (or a combine dkey) |
|
684 | 684 | } |
685 | 685 | |
686 | - $success = $model->update($model_object_data_for_update,array($conditions)); |
|
687 | - if($success){ |
|
686 | + $success = $model->update($model_object_data_for_update, array($conditions)); |
|
687 | + if ($success) { |
|
688 | 688 | $this->_total_updates++; |
689 | - EE_Error::add_success( sprintf(__("Successfully updated %s with csv data %s", "event_espresso"),$model->get_this_model_name(),implode(",",$model_object_data_for_update))); |
|
689 | + EE_Error::add_success(sprintf(__("Successfully updated %s with csv data %s", "event_espresso"), $model->get_this_model_name(), implode(",", $model_object_data_for_update))); |
|
690 | 690 | //we should still record the mapping even though it was an update |
691 | 691 | //because if we were going to insert somethign but it was going to conflict |
692 | 692 | //we would have last-minute decided to update. So we'd like to know what we updated |
693 | 693 | //and so we record what record ended up being updated using the mapping |
694 | - if( $model->has_primary_key_field() ){ |
|
695 | - $new_key_for_mapping = $model_object_data[ $model->primary_key_name() ]; |
|
696 | - }else{ |
|
694 | + if ($model->has_primary_key_field()) { |
|
695 | + $new_key_for_mapping = $model_object_data[$model->primary_key_name()]; |
|
696 | + } else { |
|
697 | 697 | //no primary key just a combined key |
698 | - $new_key_for_mapping = $model->get_index_primary_key_string( $model_object_data ); |
|
698 | + $new_key_for_mapping = $model->get_index_primary_key_string($model_object_data); |
|
699 | 699 | } |
700 | - $old_db_to_new_db_mapping[ $model->get_this_model_name() ][ $id_in_csv ] = $new_key_for_mapping; |
|
701 | - }else{ |
|
700 | + $old_db_to_new_db_mapping[$model->get_this_model_name()][$id_in_csv] = $new_key_for_mapping; |
|
701 | + } else { |
|
702 | 702 | $matched_items = $model->get_all(array($conditions)); |
703 | - if( ! $matched_items){ |
|
703 | + if ( ! $matched_items) { |
|
704 | 704 | //no items were matched (so we shouldn't have updated)... but then we should have inserted? what the heck? |
705 | 705 | $this->_total_update_errors++; |
706 | - EE_Error::add_error( sprintf(__("Could not update %s with the csv data: '%s' for an unknown reason (using WHERE conditions %s)", "event_espresso"),$model->get_this_model_name(),http_build_query($model_object_data),http_build_query($conditions)), __FILE__, __FUNCTION__, __LINE__ ); |
|
707 | - }else{ |
|
706 | + EE_Error::add_error(sprintf(__("Could not update %s with the csv data: '%s' for an unknown reason (using WHERE conditions %s)", "event_espresso"), $model->get_this_model_name(), http_build_query($model_object_data), http_build_query($conditions)), __FILE__, __FUNCTION__, __LINE__); |
|
707 | + } else { |
|
708 | 708 | $this->_total_updates++; |
709 | - EE_Error::add_success( sprintf(__("%s with csv data '%s' was found in the database and didn't need updating because all the data is identical.", "event_espresso"),$model->get_this_model_name(),implode(",",$model_object_data))); |
|
709 | + EE_Error::add_success(sprintf(__("%s with csv data '%s' was found in the database and didn't need updating because all the data is identical.", "event_espresso"), $model->get_this_model_name(), implode(",", $model_object_data))); |
|
710 | 710 | } |
711 | 711 | } |
712 | - }catch(EE_Error $e){ |
|
712 | + } catch (EE_Error $e) { |
|
713 | 713 | $this->_total_update_errors++; |
714 | - $basic_message = sprintf(__("Could not update %s with the csv data: %s because %s", "event_espresso"),$model->get_this_model_name(),implode(",",$model_object_data),$e->getMessage()); |
|
715 | - $debug_message = $basic_message . ' Stack trace: ' . $e->getTraceAsString(); |
|
716 | - EE_Error::add_error( "$basic_message | $debug_message", __FILE__, __FUNCTION__, __LINE__ ); |
|
714 | + $basic_message = sprintf(__("Could not update %s with the csv data: %s because %s", "event_espresso"), $model->get_this_model_name(), implode(",", $model_object_data), $e->getMessage()); |
|
715 | + $debug_message = $basic_message.' Stack trace: '.$e->getTraceAsString(); |
|
716 | + EE_Error::add_error("$basic_message | $debug_message", __FILE__, __FUNCTION__, __LINE__); |
|
717 | 717 | } |
718 | 718 | return $old_db_to_new_db_mapping; |
719 | 719 | } |
@@ -722,28 +722,28 @@ discard block |
||
722 | 722 | * Gets the number of inserts performed since importer was instantiated or reset |
723 | 723 | * @return int |
724 | 724 | */ |
725 | - public function get_total_inserts(){ |
|
725 | + public function get_total_inserts() { |
|
726 | 726 | return $this->_total_inserts; |
727 | 727 | } |
728 | 728 | /** |
729 | 729 | * Gets the number of insert errors since importer was instantiated or reset |
730 | 730 | * @return int |
731 | 731 | */ |
732 | - public function get_total_insert_errors(){ |
|
732 | + public function get_total_insert_errors() { |
|
733 | 733 | return $this->_total_insert_errors; |
734 | 734 | } |
735 | 735 | /** |
736 | 736 | * Gets the number of updates performed since importer was instantiated or reset |
737 | 737 | * @return int |
738 | 738 | */ |
739 | - public function get_total_updates(){ |
|
739 | + public function get_total_updates() { |
|
740 | 740 | return $this->_total_updates; |
741 | 741 | } |
742 | 742 | /** |
743 | 743 | * Gets the number of update errors since importer was instantiated or reset |
744 | 744 | * @return int |
745 | 745 | */ |
746 | - public function get_total_update_errors(){ |
|
746 | + public function get_total_update_errors() { |
|
747 | 747 | return $this->_total_update_errors; |
748 | 748 | } |
749 | 749 |
@@ -1,4 +1,6 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
3 | 5 | /** |
4 | 6 | * EE_Import class |
@@ -295,7 +297,7 @@ discard block |
||
295 | 297 | if(isset($csv_metadata['site_url']) && $csv_metadata['site_url'] == site_url()){ |
296 | 298 | EE_Error::add_attention(sprintf(__("CSV Data appears to be from the same database, so attempting to update data", "event_espresso"))); |
297 | 299 | $export_from_site_a_to_b = false; |
298 | - }else{ |
|
300 | + } else{ |
|
299 | 301 | $old_site_url = isset( $csv_metadata['site_url']) ? $csv_metadata['site_url'] : $old_site_url; |
300 | 302 | EE_Error::add_attention(sprintf(__("CSV Data appears to be from a different database (%s instead of %s), so we assume IDs in the CSV data DO NOT correspond to IDs in this database", "event_espresso"),$old_site_url,site_url())); |
301 | 303 | }; |
@@ -376,7 +378,7 @@ discard block |
||
376 | 378 | //now check that assumption was correct. If |
377 | 379 | if ( EE_Registry::instance()->is_model_name($model_name_in_csv_data)) { |
378 | 380 | $model_name = $model_name_in_csv_data; |
379 | - }else { |
|
381 | + } else { |
|
380 | 382 | // no table info in the array and no table name passed to the function?? FAIL |
381 | 383 | EE_Error::add_error( __('No table information was specified and/or found, therefore the import could not be completed','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ); |
382 | 384 | return FALSE; |
@@ -400,7 +402,7 @@ discard block |
||
400 | 402 | //there is no primary key) |
401 | 403 | if($model->has_primary_key_field()){ |
402 | 404 | $id_in_csv = $model_object_data[$model->primary_key_name()]; |
403 | - }else{ |
|
405 | + } else{ |
|
404 | 406 | $id_in_csv = $model->get_index_primary_key_string($model_object_data); |
405 | 407 | } |
406 | 408 | |
@@ -410,7 +412,7 @@ discard block |
||
410 | 412 | //or just update. |
411 | 413 | if($export_from_site_a_to_b){ |
412 | 414 | $what_to_do = $this->_decide_whether_to_insert_or_update_given_data_from_other_db( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ); |
413 | - }else{//this is just a re-import |
|
415 | + } else{//this is just a re-import |
|
414 | 416 | $what_to_do = $this->_decide_whether_to_insert_or_update_given_data_from_same_db( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ); |
415 | 417 | } |
416 | 418 | if( $what_to_do == self::do_nothing ) { |
@@ -430,7 +432,7 @@ discard block |
||
430 | 432 | if($model->has_primary_key_field()){ |
431 | 433 | $old_db_to_new_db_mapping[$model_name][$id_in_csv] = $conflicting->ID(); |
432 | 434 | $model_object_data[$model->primary_key_name()] = $conflicting->ID(); |
433 | - }else{ |
|
435 | + } else{ |
|
434 | 436 | //we want to update this conflicting item, instead of inserting a conflicting item |
435 | 437 | //so we need to make sure they match entirely (its possible that they only conflicted on one field, but we need them to match on other fields |
436 | 438 | //for the WHERE conditions in the update). At the time of this comment, there were no models like this |
@@ -442,9 +444,9 @@ discard block |
||
442 | 444 | } |
443 | 445 | if( $what_to_do == self::do_insert ) { |
444 | 446 | $old_db_to_new_db_mapping = $this->_insert_from_data_array( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ); |
445 | - }elseif( $what_to_do == self::do_update ) { |
|
447 | + } elseif( $what_to_do == self::do_update ) { |
|
446 | 448 | $old_db_to_new_db_mapping = $this->_update_from_data_array( $id_in_csv, $model_object_data, $model, $old_db_to_new_db_mapping ); |
447 | - }else{ |
|
449 | + } else{ |
|
448 | 450 | throw new EE_Error( sprintf( __( 'Programming error. We shoudl be inserting or updating, but instead we are being told to "%s", whifh is invalid', 'event_espresso' ), $what_to_do ) ); |
449 | 451 | } |
450 | 452 | } |
@@ -472,7 +474,7 @@ discard block |
||
472 | 474 | //in the old data that we know of |
473 | 475 | if( isset($old_db_to_new_db_mapping[$model_name][$id_in_csv]) ){ |
474 | 476 | return self::do_update; |
475 | - }else{ |
|
477 | + } else{ |
|
476 | 478 | return self::do_insert; |
477 | 479 | } |
478 | 480 | } |
@@ -491,7 +493,7 @@ discard block |
||
491 | 493 | //in this case, check if this thing ACTUALLY exists in the database |
492 | 494 | if( $model->get_one_conflicting( $model_object_data ) ){ |
493 | 495 | return self::do_update; |
494 | - }else{ |
|
496 | + } else{ |
|
495 | 497 | return self::do_insert; |
496 | 498 | } |
497 | 499 | } |
@@ -522,7 +524,7 @@ discard block |
||
522 | 524 | try{ |
523 | 525 | $model_name_field = $model->get_field_containing_related_model_name(); |
524 | 526 | $models_pointed_to_by_model_name_field = $model_name_field->get_model_names_pointed_to(); |
525 | - }catch( EE_Error $e ){ |
|
527 | + } catch( EE_Error $e ){ |
|
526 | 528 | $model_name_field = NULL; |
527 | 529 | $models_pointed_to_by_model_name_field = array(); |
528 | 530 | } |
@@ -543,7 +545,7 @@ discard block |
||
543 | 545 | $found_a_mapping = true; |
544 | 546 | break; |
545 | 547 | } |
546 | - }else{ |
|
548 | + } else{ |
|
547 | 549 | $model_object_data[ $field_obj->get_name() ] = $this->_find_mapping_in( |
548 | 550 | $model_object_data[ $field_obj->get_name() ], |
549 | 551 | $model_pointed_to_by_fk, |
@@ -558,7 +560,7 @@ discard block |
||
558 | 560 | |
559 | 561 | |
560 | 562 | } |
561 | - }else{ |
|
563 | + } else{ |
|
562 | 564 | //it's a string foreign key (which we leave alone, because those are things |
563 | 565 | //like country names, which we'd really rather not make 2 USAs etc (we'd actually |
564 | 566 | //prefer to just update one) |
@@ -601,14 +603,14 @@ discard block |
||
601 | 603 | if( isset( $old_db_to_new_db_mapping[ $model_name ][ $object_id ] ) ){ |
602 | 604 | |
603 | 605 | return $old_db_to_new_db_mapping[ $model_name ][ $object_id ]; |
604 | - }elseif( $object_id == '0' || $object_id == '' ) { |
|
606 | + } elseif( $object_id == '0' || $object_id == '' ) { |
|
605 | 607 | //leave as-is |
606 | 608 | return $object_id; |
607 | - }elseif( $export_from_site_a_to_b ){ |
|
609 | + } elseif( $export_from_site_a_to_b ){ |
|
608 | 610 | //we couldn't find a mapping for this, and it's from a different site, |
609 | 611 | //so blank it out |
610 | 612 | return NULL; |
611 | - }elseif( ! $export_from_site_a_to_b ) { |
|
613 | + } elseif( ! $export_from_site_a_to_b ) { |
|
612 | 614 | //we coudln't find a mapping for this, but it's from thsi DB anyway |
613 | 615 | //so let's just leave it as-is |
614 | 616 | return $object_id; |
@@ -629,7 +631,7 @@ discard block |
||
629 | 631 | if($model->has_primary_key_field() && $model->get_primary_key_field()->is_auto_increment()){ |
630 | 632 | $effective_id = $model_object_data[$model->primary_key_name()]; |
631 | 633 | unset($model_object_data[$model->primary_key_name()]); |
632 | - }else{ |
|
634 | + } else{ |
|
633 | 635 | $effective_id = $model->get_index_primary_key_string( $model_object_data ); |
634 | 636 | } |
635 | 637 | //the model takes care of validating the CSV's input |
@@ -639,7 +641,7 @@ discard block |
||
639 | 641 | $old_db_to_new_db_mapping[$model->get_this_model_name()][$id_in_csv] = $new_id; |
640 | 642 | $this->_total_inserts++; |
641 | 643 | EE_Error::add_success( sprintf(__("Successfully added new %s (with id %s) with csv data %s", "event_espresso"),$model->get_this_model_name(),$new_id, implode(",",$model_object_data))); |
642 | - }else{ |
|
644 | + } else{ |
|
643 | 645 | $this->_total_insert_errors++; |
644 | 646 | //put the ID used back in there for the error message |
645 | 647 | if($model->has_primary_key_field()){ |
@@ -647,7 +649,7 @@ discard block |
||
647 | 649 | } |
648 | 650 | EE_Error::add_error( sprintf(__("Could not insert new %s with the csv data: %s", "event_espresso"),$model->get_this_model_name(),http_build_query($model_object_data)), __FILE__, __FUNCTION__, __LINE__ ); |
649 | 651 | } |
650 | - }catch(EE_Error $e){ |
|
652 | + } catch(EE_Error $e){ |
|
651 | 653 | $this->_total_insert_errors++; |
652 | 654 | if($model->has_primary_key_field()){ |
653 | 655 | $model_object_data[$model->primary_key_name()] = $effective_id; |
@@ -674,12 +676,12 @@ discard block |
||
674 | 676 | $conditions = array($model->primary_key_name() => $model_object_data[$model->primary_key_name()]); |
675 | 677 | //remove the primary key because we shouldn't use it for updating |
676 | 678 | unset($model_object_data_for_update[$model->primary_key_name()]); |
677 | - }elseif($model->get_combined_primary_key_fields() > 1 ){ |
|
679 | + } elseif($model->get_combined_primary_key_fields() > 1 ){ |
|
678 | 680 | $conditions = array(); |
679 | 681 | foreach($model->get_combined_primary_key_fields() as $key_field){ |
680 | 682 | $conditions[$key_field->get_name()] = $model_object_data[$key_field->get_name()]; |
681 | 683 | } |
682 | - }else{ |
|
684 | + } else{ |
|
683 | 685 | $model->primary_key_name();//this shoudl just throw an exception, explaining that we dont have a primary key (or a combine dkey) |
684 | 686 | } |
685 | 687 | |
@@ -693,23 +695,23 @@ discard block |
||
693 | 695 | //and so we record what record ended up being updated using the mapping |
694 | 696 | if( $model->has_primary_key_field() ){ |
695 | 697 | $new_key_for_mapping = $model_object_data[ $model->primary_key_name() ]; |
696 | - }else{ |
|
698 | + } else{ |
|
697 | 699 | //no primary key just a combined key |
698 | 700 | $new_key_for_mapping = $model->get_index_primary_key_string( $model_object_data ); |
699 | 701 | } |
700 | 702 | $old_db_to_new_db_mapping[ $model->get_this_model_name() ][ $id_in_csv ] = $new_key_for_mapping; |
701 | - }else{ |
|
703 | + } else{ |
|
702 | 704 | $matched_items = $model->get_all(array($conditions)); |
703 | 705 | if( ! $matched_items){ |
704 | 706 | //no items were matched (so we shouldn't have updated)... but then we should have inserted? what the heck? |
705 | 707 | $this->_total_update_errors++; |
706 | 708 | EE_Error::add_error( sprintf(__("Could not update %s with the csv data: '%s' for an unknown reason (using WHERE conditions %s)", "event_espresso"),$model->get_this_model_name(),http_build_query($model_object_data),http_build_query($conditions)), __FILE__, __FUNCTION__, __LINE__ ); |
707 | - }else{ |
|
709 | + } else{ |
|
708 | 710 | $this->_total_updates++; |
709 | 711 | EE_Error::add_success( sprintf(__("%s with csv data '%s' was found in the database and didn't need updating because all the data is identical.", "event_espresso"),$model->get_this_model_name(),implode(",",$model_object_data))); |
710 | 712 | } |
711 | 713 | } |
712 | - }catch(EE_Error $e){ |
|
714 | + } catch(EE_Error $e){ |
|
713 | 715 | $this->_total_update_errors++; |
714 | 716 | $basic_message = sprintf(__("Could not update %s with the csv data: %s because %s", "event_espresso"),$model->get_this_model_name(),implode(",",$model_object_data),$e->getMessage()); |
715 | 717 | $debug_message = $basic_message . ' Stack trace: ' . $e->getTraceAsString(); |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | * generate_question_form_inputs_for_object |
227 | 227 | * |
228 | 228 | * @access protected |
229 | - * @param bool|object $object $object |
|
229 | + * @param EE_Base_Class|null $object $object |
|
230 | 230 | * @param array $input_types |
231 | 231 | * @return array |
232 | 232 | */ |
@@ -324,7 +324,7 @@ discard block |
||
324 | 324 | * add_temp_option |
325 | 325 | * @access public |
326 | 326 | * @param \EE_Question_Option $QSO EE_Question_Option |
327 | - * @return boolean |
|
327 | + * @return boolean|null |
|
328 | 328 | */ |
329 | 329 | public function add_temp_option( EE_Question_Option $QSO ) { |
330 | 330 | $this->_QST->add_temp_option( $QSO ); |
@@ -336,8 +336,8 @@ discard block |
||
336 | 336 | * set property values for question form input |
337 | 337 | * @access public |
338 | 338 | * @param string $property |
339 | - * @param mixed $value |
|
340 | - * @return mixed |
|
339 | + * @param boolean $value |
|
340 | + * @return boolean|null |
|
341 | 341 | */ |
342 | 342 | public function set( $property = NULL, $value = NULL ) { |
343 | 343 | if ( ! empty( $property ) ) { |
@@ -376,7 +376,7 @@ discard block |
||
376 | 376 | /** |
377 | 377 | * get_meta |
378 | 378 | * @access public |
379 | - * @param mixed $key |
|
379 | + * @param string $key |
|
380 | 380 | * @return mixed |
381 | 381 | */ |
382 | 382 | public function get_meta( $key = FALSE ) { |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -82,14 +82,14 @@ discard block |
||
82 | 82 | * @access public |
83 | 83 | * @return \EE_Question_Form_Input |
84 | 84 | */ |
85 | - public function __construct( EE_Question $QST = NULL, EE_Answer $ANS = NULL, $q_meta = array() ) { |
|
86 | - if ( empty( $QST ) || empty( $ANS ) ) { |
|
87 | - EE_Error::add_error( __( 'An error occurred. A valid EE_Question or EE_Answer object was not received.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ ); |
|
85 | + public function __construct(EE_Question $QST = NULL, EE_Answer $ANS = NULL, $q_meta = array()) { |
|
86 | + if (empty($QST) || empty($ANS)) { |
|
87 | + EE_Error::add_error(__('An error occurred. A valid EE_Question or EE_Answer object was not received.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
88 | 88 | return NULL; |
89 | 89 | } |
90 | 90 | $this->_QST = $QST; |
91 | 91 | $this->_ANS = $ANS; |
92 | - $this->set_question_form_input_meta( $q_meta ); |
|
92 | + $this->set_question_form_input_meta($q_meta); |
|
93 | 93 | $this->set_question_form_input_init(); |
94 | 94 | } |
95 | 95 | |
@@ -101,9 +101,9 @@ discard block |
||
101 | 101 | * @param array $q_meta |
102 | 102 | * @return void |
103 | 103 | */ |
104 | - public function set_question_form_input_meta( $q_meta = array() ) { |
|
105 | - $default_q_meta = array( 'att_nmbr' => 1, 'ticket_id' => '', 'date' => '', 'time' => '', 'input_name' => '', 'input_id' => '', 'input_class' => '', 'input_prefix' => 'qstn', 'append_qstn_id' => TRUE, 'htmlentities' => TRUE, 'allow_null' => FALSE ); |
|
106 | - $this->_QST_meta = array_merge( $default_q_meta, $q_meta ); |
|
104 | + public function set_question_form_input_meta($q_meta = array()) { |
|
105 | + $default_q_meta = array('att_nmbr' => 1, 'ticket_id' => '', 'date' => '', 'time' => '', 'input_name' => '', 'input_id' => '', 'input_class' => '', 'input_prefix' => 'qstn', 'append_qstn_id' => TRUE, 'htmlentities' => TRUE, 'allow_null' => FALSE); |
|
106 | + $this->_QST_meta = array_merge($default_q_meta, $q_meta); |
|
107 | 107 | } |
108 | 108 | |
109 | 109 | |
@@ -115,10 +115,10 @@ discard block |
||
115 | 115 | */ |
116 | 116 | public function set_question_form_input_init() { |
117 | 117 | $qstn_id = $this->_QST->system_ID() ? $this->_QST->system_ID() : $this->_QST->ID(); |
118 | - $this->_set_input_name( $qstn_id ); |
|
119 | - $this->_set_input_id( $qstn_id ); |
|
120 | - $this->_set_input_class( $qstn_id ); |
|
121 | - $this->set_question_form_input_answer( $qstn_id ); |
|
118 | + $this->_set_input_name($qstn_id); |
|
119 | + $this->_set_input_id($qstn_id); |
|
120 | + $this->_set_input_class($qstn_id); |
|
121 | + $this->set_question_form_input_answer($qstn_id); |
|
122 | 122 | } |
123 | 123 | |
124 | 124 | |
@@ -129,12 +129,12 @@ discard block |
||
129 | 129 | * @param $qstn_id |
130 | 130 | * @return void |
131 | 131 | */ |
132 | - private function _set_input_name( $qstn_id ) { |
|
133 | - if ( ! empty( $qstn_id ) ) { |
|
134 | - $ANS_ID = $this->get( 'ANS_ID' ); |
|
135 | - $qstn_id = ! empty( $ANS_ID ) ? '[' . $qstn_id . '][' . $ANS_ID . ']' : '[' . $qstn_id . ']'; |
|
132 | + private function _set_input_name($qstn_id) { |
|
133 | + if ( ! empty($qstn_id)) { |
|
134 | + $ANS_ID = $this->get('ANS_ID'); |
|
135 | + $qstn_id = ! empty($ANS_ID) ? '['.$qstn_id.']['.$ANS_ID.']' : '['.$qstn_id.']'; |
|
136 | 136 | } |
137 | - $this->QST_input_name = $this->_QST_meta[ 'append_qstn_id' ] && ! empty( $qstn_id ) ? $this->_QST_meta[ 'input_prefix' ] . $this->_QST_meta[ 'input_name' ] . $qstn_id : $this->_QST_meta[ 'input_prefix' ] . $this->_QST_meta[ 'input_name' ]; |
|
137 | + $this->QST_input_name = $this->_QST_meta['append_qstn_id'] && ! empty($qstn_id) ? $this->_QST_meta['input_prefix'].$this->_QST_meta['input_name'].$qstn_id : $this->_QST_meta['input_prefix'].$this->_QST_meta['input_name']; |
|
138 | 138 | } |
139 | 139 | |
140 | 140 | |
@@ -145,13 +145,13 @@ discard block |
||
145 | 145 | * @param string $property |
146 | 146 | * @return mixed |
147 | 147 | */ |
148 | - public function get( $property = NULL ) { |
|
149 | - if ( ! empty( $property ) ) { |
|
150 | - if ( EEM_Question::instance()->has_field( $property ) ) { |
|
151 | - return $this->_QST->get( $property ); |
|
152 | - } else if ( EEM_Answer::instance()->has_field( $property ) ) { |
|
153 | - return $this->_ANS->get( $property ); |
|
154 | - } else if ( $this->_question_form_input_property_exists( __CLASS__, $property ) ) { |
|
148 | + public function get($property = NULL) { |
|
149 | + if ( ! empty($property)) { |
|
150 | + if (EEM_Question::instance()->has_field($property)) { |
|
151 | + return $this->_QST->get($property); |
|
152 | + } else if (EEM_Answer::instance()->has_field($property)) { |
|
153 | + return $this->_ANS->get($property); |
|
154 | + } else if ($this->_question_form_input_property_exists(__CLASS__, $property)) { |
|
155 | 155 | return $this->{$property}; |
156 | 156 | } |
157 | 157 | } |
@@ -167,13 +167,13 @@ discard block |
||
167 | 167 | * @param string $property |
168 | 168 | * @return boolean |
169 | 169 | */ |
170 | - private function _question_form_input_property_exists( $classname, $property ) { |
|
170 | + private function _question_form_input_property_exists($classname, $property) { |
|
171 | 171 | // first try regular property exists method which works as expected in PHP 5.3+ |
172 | - $prop = EEH_Class_Tools::has_property( $classname, $property ); |
|
173 | - if ( ! $prop ) { |
|
172 | + $prop = EEH_Class_Tools::has_property($classname, $property); |
|
173 | + if ( ! $prop) { |
|
174 | 174 | // use reflection for < PHP 5.3 as a double check when property is not found, possible due to access restriction |
175 | - $reflector = new ReflectionClass( $classname ); |
|
176 | - $prop = $reflector->hasProperty( $property ); |
|
175 | + $reflector = new ReflectionClass($classname); |
|
176 | + $prop = $reflector->hasProperty($property); |
|
177 | 177 | } |
178 | 178 | return $prop; |
179 | 179 | } |
@@ -186,9 +186,9 @@ discard block |
||
186 | 186 | * @param $qstn_id |
187 | 187 | * @return void |
188 | 188 | */ |
189 | - private function _set_input_id( $qstn_id ) { |
|
190 | - $input_id = isset( $this->_QST_meta[ 'input_id' ] ) && ! empty( $this->_QST_meta[ 'input_id' ] ) ? $this->_QST_meta[ 'input_id' ] : sanitize_key( strip_tags( $this->_QST->get( 'QST_display_text' ) ) ); |
|
191 | - $this->QST_input_id = $this->_QST_meta[ 'append_qstn_id' ] && ! empty( $qstn_id ) ? $input_id . '-' . $qstn_id : $input_id; |
|
189 | + private function _set_input_id($qstn_id) { |
|
190 | + $input_id = isset($this->_QST_meta['input_id']) && ! empty($this->_QST_meta['input_id']) ? $this->_QST_meta['input_id'] : sanitize_key(strip_tags($this->_QST->get('QST_display_text'))); |
|
191 | + $this->QST_input_id = $this->_QST_meta['append_qstn_id'] && ! empty($qstn_id) ? $input_id.'-'.$qstn_id : $input_id; |
|
192 | 192 | } |
193 | 193 | |
194 | 194 | |
@@ -199,7 +199,7 @@ discard block |
||
199 | 199 | * @return void |
200 | 200 | */ |
201 | 201 | private function _set_input_class() { |
202 | - $this->QST_input_class = isset( $this->_QST_meta[ 'input_class' ] ) ? $this->_QST_meta[ 'input_class' ] : ''; |
|
202 | + $this->QST_input_class = isset($this->_QST_meta['input_class']) ? $this->_QST_meta['input_class'] : ''; |
|
203 | 203 | } |
204 | 204 | |
205 | 205 | |
@@ -210,12 +210,12 @@ discard block |
||
210 | 210 | * @param mixed int | string $qstn_id |
211 | 211 | * @return void |
212 | 212 | */ |
213 | - public function set_question_form_input_answer( $qstn_id ) { |
|
213 | + public function set_question_form_input_answer($qstn_id) { |
|
214 | 214 | // check for answer in $_REQUEST in case we are reprocessing a form after an error |
215 | - if ( isset( $this->_QST_meta[ 'EVT_ID' ] ) && isset( $this->_QST_meta[ 'att_nmbr' ] ) && isset( $this->_QST_meta[ 'date' ] ) && isset( $this->_QST_meta[ 'time' ] ) && isset( $this->_QST_meta[ 'price_id' ] ) ) { |
|
216 | - if ( isset( $_REQUEST[ 'qstn' ][ $this->_QST_meta[ 'EVT_ID' ] ][ $this->_QST_meta[ 'att_nmbr' ] ][ $this->_QST_meta[ 'date' ] ][ $this->_QST_meta[ 'time' ] ][ $this->_QST_meta[ 'price_id' ] ][ $qstn_id ] ) ) { |
|
217 | - $answer = $_REQUEST[ 'qstn' ][ $this->_QST_meta[ 'EVT_ID' ] ][ $this->_QST_meta[ 'att_nmbr' ] ][ $this->_QST_meta[ 'date' ] ][ $this->_QST_meta[ 'time' ] ][ $this->_QST_meta[ 'price_id' ] ][ $qstn_id ]; |
|
218 | - $this->_ANS->set( 'ANS_value', $answer ); |
|
215 | + if (isset($this->_QST_meta['EVT_ID']) && isset($this->_QST_meta['att_nmbr']) && isset($this->_QST_meta['date']) && isset($this->_QST_meta['time']) && isset($this->_QST_meta['price_id'])) { |
|
216 | + if (isset($_REQUEST['qstn'][$this->_QST_meta['EVT_ID']][$this->_QST_meta['att_nmbr']][$this->_QST_meta['date']][$this->_QST_meta['time']][$this->_QST_meta['price_id']][$qstn_id])) { |
|
217 | + $answer = $_REQUEST['qstn'][$this->_QST_meta['EVT_ID']][$this->_QST_meta['att_nmbr']][$this->_QST_meta['date']][$this->_QST_meta['time']][$this->_QST_meta['price_id']][$qstn_id]; |
|
218 | + $this->_ANS->set('ANS_value', $answer); |
|
219 | 219 | } |
220 | 220 | } |
221 | 221 | } |
@@ -230,40 +230,40 @@ discard block |
||
230 | 230 | * @param array $input_types |
231 | 231 | * @return array |
232 | 232 | */ |
233 | - static function generate_question_form_inputs_for_object( $object = FALSE, $input_types = array() ) { |
|
234 | - if ( ! is_object( $object ) ) { |
|
233 | + static function generate_question_form_inputs_for_object($object = FALSE, $input_types = array()) { |
|
234 | + if ( ! is_object($object)) { |
|
235 | 235 | return FALSE; |
236 | 236 | } |
237 | 237 | $inputs = array(); |
238 | - $fields = $object->get_model()->field_settings( FALSE ); |
|
238 | + $fields = $object->get_model()->field_settings(FALSE); |
|
239 | 239 | // $pk = $object->ID(); <<< NO! |
240 | 240 | // EEH_Debug_Tools::printr( $object, get_class( $object ) . '<br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
241 | 241 | // EEH_Debug_Tools::printr( $fields, '$fields <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
242 | 242 | // EEH_Debug_Tools::printr( $input_types, '$input_types <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
243 | - foreach ( $fields as $field_ID => $field ) { |
|
244 | - if ( $field instanceof EE_Model_Field_Base ) { |
|
243 | + foreach ($fields as $field_ID => $field) { |
|
244 | + if ($field instanceof EE_Model_Field_Base) { |
|
245 | 245 | // echo '<h4>$field_ID : ' . $field_ID . ' <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span></h4>'; |
246 | 246 | // EEH_Debug_Tools::printr( $field, '$field <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
247 | - if ( isset( $input_types[ $field_ID ] ) ) { |
|
247 | + if (isset($input_types[$field_ID])) { |
|
248 | 248 | // get saved value for field |
249 | - $value = $object->get( $field_ID ); |
|
249 | + $value = $object->get($field_ID); |
|
250 | 250 | // echo '<h4>$value : ' . $value . ' <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span></h4>'; |
251 | 251 | // if no saved value, then use default |
252 | 252 | $value = $value !== NULL ? $value : $field->get_default_value(); |
253 | 253 | // if ( $field_ID == 'CNT_active' ) |
254 | 254 | // echo '<h4>$value : ' . $value . ' <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span></h4>'; |
255 | 255 | // determine question type |
256 | - $type = isset( $input_types[ $field_ID ] ) ? $input_types[ $field_ID ][ 'type' ] : 'TEXT'; |
|
256 | + $type = isset($input_types[$field_ID]) ? $input_types[$field_ID]['type'] : 'TEXT'; |
|
257 | 257 | // input name |
258 | - $input_name = isset( $input_types[ $field_ID ] ) && isset( $input_types[ $field_ID ][ 'input_name' ] ) ? $input_types[ $field_ID ][ 'input_name' ] . '[' . $field_ID . ']' : $field_ID; |
|
258 | + $input_name = isset($input_types[$field_ID]) && isset($input_types[$field_ID]['input_name']) ? $input_types[$field_ID]['input_name'].'['.$field_ID.']' : $field_ID; |
|
259 | 259 | // css class for input |
260 | - $class = isset( $input_types[ $field_ID ][ 'class' ] ) && ! empty( $input_types[ $field_ID ][ 'class' ] ) ? ' ' . $input_types[ $field_ID ][ 'class' ] : ''; |
|
260 | + $class = isset($input_types[$field_ID]['class']) && ! empty($input_types[$field_ID]['class']) ? ' '.$input_types[$field_ID]['class'] : ''; |
|
261 | 261 | // whether to apply htmlentities to answer |
262 | - $htmlentities = isset( $input_types[ $field_ID ][ 'htmlentities' ] ) ? $input_types[ $field_ID ][ 'htmlentities' ] : TRUE; |
|
262 | + $htmlentities = isset($input_types[$field_ID]['htmlentities']) ? $input_types[$field_ID]['htmlentities'] : TRUE; |
|
263 | 263 | // whether to apply htmlentities to answer |
264 | - $label_b4 = isset( $input_types[ $field_ID ][ 'label_b4' ] ) ? $input_types[ $field_ID ][ 'label_b4' ] : FALSE; |
|
264 | + $label_b4 = isset($input_types[$field_ID]['label_b4']) ? $input_types[$field_ID]['label_b4'] : FALSE; |
|
265 | 265 | // whether to apply htmlentities to answer |
266 | - $use_desc_4_label = isset( $input_types[ $field_ID ][ 'use_desc_4_label' ] ) ? $input_types[ $field_ID ][ 'use_desc_4_label' ] : FALSE; |
|
266 | + $use_desc_4_label = isset($input_types[$field_ID]['use_desc_4_label']) ? $input_types[$field_ID]['use_desc_4_label'] : FALSE; |
|
267 | 267 | |
268 | 268 | // create EE_Question_Form_Input object |
269 | 269 | $QFI = new EE_Question_Form_Input( |
@@ -283,9 +283,9 @@ discard block |
||
283 | 283 | ) |
284 | 284 | ), |
285 | 285 | array( |
286 | - 'input_id' => $field_ID . '-' . $object->ID(), |
|
286 | + 'input_id' => $field_ID.'-'.$object->ID(), |
|
287 | 287 | 'input_name' => $input_name, |
288 | - 'input_class' => $field_ID . $class, |
|
288 | + 'input_class' => $field_ID.$class, |
|
289 | 289 | 'input_prefix' => '', |
290 | 290 | 'append_qstn_id' => FALSE, |
291 | 291 | 'htmlentities' => $htmlentities, |
@@ -294,21 +294,21 @@ discard block |
||
294 | 294 | ) |
295 | 295 | ); |
296 | 296 | // does question type have options ? |
297 | - if ( in_array( $type, array( 'DROPDOWN', 'RADIO_BTN', 'CHECKBOX' ) ) && isset ( $input_types[ $field_ID ] ) && isset ( $input_types[ $field_ID ][ 'options' ] ) ) { |
|
298 | - foreach ( $input_types[ $field_ID ][ 'options' ] as $option ) { |
|
299 | - $option = stripslashes_deep( $option ); |
|
300 | - $option_id = ! empty( $option[ 'id' ] ) ? $option[ 'id' ] : 0; |
|
301 | - $QSO = EE_Question_Option::new_instance( array( 'QSO_value' => (string)$option_id, 'QSO_desc' => $option[ 'text' ], 'QSO_deleted' => FALSE ) ); |
|
297 | + if (in_array($type, array('DROPDOWN', 'RADIO_BTN', 'CHECKBOX')) && isset ($input_types[$field_ID]) && isset ($input_types[$field_ID]['options'])) { |
|
298 | + foreach ($input_types[$field_ID]['options'] as $option) { |
|
299 | + $option = stripslashes_deep($option); |
|
300 | + $option_id = ! empty($option['id']) ? $option['id'] : 0; |
|
301 | + $QSO = EE_Question_Option::new_instance(array('QSO_value' => (string) $option_id, 'QSO_desc' => $option['text'], 'QSO_deleted' => FALSE)); |
|
302 | 302 | // all QST (and ANS) properties can be accessed indirectly thru QFI |
303 | - $QFI->add_temp_option( $QSO ); |
|
303 | + $QFI->add_temp_option($QSO); |
|
304 | 304 | } |
305 | 305 | } |
306 | 306 | // we don't want ppl manually changing primary keys cuz that would just lead to total craziness man |
307 | - if ( $field_ID == $object->get_model()->primary_key_name() ) { |
|
308 | - $QFI->set( 'QST_disabled', TRUE ); |
|
307 | + if ($field_ID == $object->get_model()->primary_key_name()) { |
|
308 | + $QFI->set('QST_disabled', TRUE); |
|
309 | 309 | } |
310 | 310 | //EEH_Debug_Tools::printr( $QFI, '$QFI <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
311 | - $inputs[ $field_ID ] = $QFI; |
|
311 | + $inputs[$field_ID] = $QFI; |
|
312 | 312 | // if ( $field_ID == 'CNT_active' ) { |
313 | 313 | // EEH_Debug_Tools::printr( $QFI, '$QFI <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
314 | 314 | // } |
@@ -326,8 +326,8 @@ discard block |
||
326 | 326 | * @param \EE_Question_Option $QSO EE_Question_Option |
327 | 327 | * @return boolean |
328 | 328 | */ |
329 | - public function add_temp_option( EE_Question_Option $QSO ) { |
|
330 | - $this->_QST->add_temp_option( $QSO ); |
|
329 | + public function add_temp_option(EE_Question_Option $QSO) { |
|
330 | + $this->_QST->add_temp_option($QSO); |
|
331 | 331 | } |
332 | 332 | |
333 | 333 | |
@@ -339,13 +339,13 @@ discard block |
||
339 | 339 | * @param mixed $value |
340 | 340 | * @return mixed |
341 | 341 | */ |
342 | - public function set( $property = NULL, $value = NULL ) { |
|
343 | - if ( ! empty( $property ) ) { |
|
344 | - if ( EEM_Question::instance()->has_field( $property ) ) { |
|
345 | - $this->_QST->set( $property, $value ); |
|
346 | - } else if ( EEM_Answer::instance()->has_field( $property ) ) { |
|
347 | - $this->_ANS->set( $property, $value ); |
|
348 | - } else if ( $this->_question_form_input_property_exists( __CLASS__, $property ) ) { |
|
342 | + public function set($property = NULL, $value = NULL) { |
|
343 | + if ( ! empty($property)) { |
|
344 | + if (EEM_Question::instance()->has_field($property)) { |
|
345 | + $this->_QST->set($property, $value); |
|
346 | + } else if (EEM_Answer::instance()->has_field($property)) { |
|
347 | + $this->_ANS->set($property, $value); |
|
348 | + } else if ($this->_question_form_input_property_exists(__CLASS__, $property)) { |
|
349 | 349 | echo "<hr>$property is a prop of QFI"; |
350 | 350 | $this->{$property} = $value; |
351 | 351 | return TRUE; |
@@ -366,9 +366,9 @@ discard block |
||
366 | 366 | * whether it was trashed or not. |
367 | 367 | * @return EE_Question_Option |
368 | 368 | */ |
369 | - public function options( $notDeletedOptionsOnly = TRUE, $selected_value_to_always_include = NULL ) { |
|
369 | + public function options($notDeletedOptionsOnly = TRUE, $selected_value_to_always_include = NULL) { |
|
370 | 370 | $temp_options = $this->_QST->temp_options(); |
371 | - return ! empty( $temp_options ) ? $temp_options : $this->_QST->options( $notDeletedOptionsOnly, $selected_value_to_always_include ); |
|
371 | + return ! empty($temp_options) ? $temp_options : $this->_QST->options($notDeletedOptionsOnly, $selected_value_to_always_include); |
|
372 | 372 | } |
373 | 373 | |
374 | 374 | |
@@ -379,8 +379,8 @@ discard block |
||
379 | 379 | * @param mixed $key |
380 | 380 | * @return mixed |
381 | 381 | */ |
382 | - public function get_meta( $key = FALSE ) { |
|
383 | - return $key && isset( $this->_QST_meta[ $key ] ) ? $this->_QST_meta[ $key ] : FALSE; |
|
382 | + public function get_meta($key = FALSE) { |
|
383 | + return $key && isset($this->_QST_meta[$key]) ? $this->_QST_meta[$key] : FALSE; |
|
384 | 384 | } |
385 | 385 | |
386 | 386 |
@@ -117,7 +117,7 @@ discard block |
||
117 | 117 | * @param string $log_type !see the acceptable values of LOG_type in EEM__Change_Log::__construct |
118 | 118 | * @param mixed $message array|string of the message you want to record |
119 | 119 | * @param EE_Base_Class $related_model_obj |
120 | - * @return EE_Change_Log |
|
120 | + * @return EE_Attendee |
|
121 | 121 | */ |
122 | 122 | public function log($log_type,$message,$related_model_obj){ |
123 | 123 | if($related_model_obj instanceof EE_Base_Class){ |
@@ -145,7 +145,7 @@ discard block |
||
145 | 145 | * @param mixed $related_obj_id |
146 | 146 | * @param string $related_obj_type |
147 | 147 | * @throws EE_Error |
148 | - * @return EE_Change_Log |
|
148 | + * @return EE_Attendee |
|
149 | 149 | */ |
150 | 150 | public function gateway_log( $message, $related_obj_id, $related_obj_type ){ |
151 | 151 | if( ! EE_Registry::instance()->is_model_name($related_obj_type)){ |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) |
|
4 | 4 | exit('No direct script access allowed'); |
5 | 5 | |
6 | 6 | /** |
@@ -25,7 +25,7 @@ discard block |
||
25 | 25 | * |
26 | 26 | * ------------------------------------------------------------------------ |
27 | 27 | */ |
28 | -class EEM_Change_Log extends EEM_Base{ |
|
28 | +class EEM_Change_Log extends EEM_Base { |
|
29 | 29 | |
30 | 30 | /** |
31 | 31 | * the related object was created log type |
@@ -68,19 +68,19 @@ discard block |
||
68 | 68 | * @access protected |
69 | 69 | * @return EEM_Change_Log |
70 | 70 | */ |
71 | - protected function __construct( $timezone = null ){ |
|
71 | + protected function __construct($timezone = null) { |
|
72 | 72 | global $current_user; |
73 | - $this->singular_item = __('Log','event_espresso'); |
|
74 | - $this->plural_item = __('Logs','event_espresso'); |
|
73 | + $this->singular_item = __('Log', 'event_espresso'); |
|
74 | + $this->plural_item = __('Logs', 'event_espresso'); |
|
75 | 75 | $this->_tables = array( |
76 | 76 | 'Log'=> new EE_Primary_Table('esp_log', 'LOG_ID') |
77 | 77 | ); |
78 | 78 | $models_this_can_attach_to = array_keys(EE_Registry::instance()->non_abstract_db_models); |
79 | 79 | $this->_fields = array( |
80 | 80 | 'Log'=>array( |
81 | - 'LOG_ID'=> new EE_Primary_Key_Int_Field('LOG_ID', __('Log ID','event_espresso')), |
|
81 | + 'LOG_ID'=> new EE_Primary_Key_Int_Field('LOG_ID', __('Log ID', 'event_espresso')), |
|
82 | 82 | 'LOG_time'=>new EE_Datetime_Field('LOG_time', __("Log Time", 'event_espresso'), false, time()), |
83 | - 'OBJ_ID'=>new EE_Foreign_Key_String_Field('OBJ_ID', __("Object ID (int or string)", 'event_espresso'), true, NULL,$models_this_can_attach_to), |
|
83 | + 'OBJ_ID'=>new EE_Foreign_Key_String_Field('OBJ_ID', __("Object ID (int or string)", 'event_espresso'), true, NULL, $models_this_can_attach_to), |
|
84 | 84 | 'OBJ_type'=>new EE_Any_Foreign_Model_Name_Field('OBJ_type', __("Object Type", 'event_espresso'), true, NULL, $models_this_can_attach_to), |
85 | 85 | 'LOG_type'=>new EE_Enum_Text_Field('LOG_type', __("Type of log entry", "event_espresso"), false, self::type_debug, |
86 | 86 | array( |
@@ -92,24 +92,24 @@ discard block |
||
92 | 92 | self::type_gateway=> __("Gateway Interaction (IPN or Direct Payment)", 'event_espresso'), |
93 | 93 | )), |
94 | 94 | 'LOG_message'=>new EE_Maybe_Serialized_Text_Field('LOG_message', __("Log Message (body)", 'event_espresso'), true), |
95 | - 'LOG_wp_user' => new EE_WP_User_Field('LOG_wp_user', __("User who was logged in while this occurred", 'event_espresso'), true ), |
|
95 | + 'LOG_wp_user' => new EE_WP_User_Field('LOG_wp_user', __("User who was logged in while this occurred", 'event_espresso'), true), |
|
96 | 96 | |
97 | 97 | )); |
98 | 98 | $this->_model_relations = array(); |
99 | - foreach($models_this_can_attach_to as $model){ |
|
100 | - if( $model == 'WP_User' ){ |
|
101 | - $this->_model_relations[ $model ] = new EE_Belongs_To_Relation(); |
|
102 | - }elseif( $model != 'Change_Log' ) { |
|
99 | + foreach ($models_this_can_attach_to as $model) { |
|
100 | + if ($model == 'WP_User') { |
|
101 | + $this->_model_relations[$model] = new EE_Belongs_To_Relation(); |
|
102 | + }elseif ($model != 'Change_Log') { |
|
103 | 103 | $this->_model_relations[$model] = new EE_Belongs_To_Any_Relation(); |
104 | 104 | } |
105 | 105 | } |
106 | 106 | //use completely custom caps for this |
107 | 107 | $this->_cap_restriction_generators = false; |
108 | 108 | //caps-wise this is all-or-nothing: if you have the default role you can access anything, otherwise nothing |
109 | - foreach( $this->_cap_contexts_to_cap_action_map as $cap_context => $action ) { |
|
110 | - $this->_cap_restrictions[ $cap_context ][ EE_Restriction_Generator_Base::get_default_restrictions_cap() ] = new EE_Return_None_Where_Conditions(); |
|
109 | + foreach ($this->_cap_contexts_to_cap_action_map as $cap_context => $action) { |
|
110 | + $this->_cap_restrictions[$cap_context][EE_Restriction_Generator_Base::get_default_restrictions_cap()] = new EE_Return_None_Where_Conditions(); |
|
111 | 111 | } |
112 | - parent::__construct( $timezone ); |
|
112 | + parent::__construct($timezone); |
|
113 | 113 | } |
114 | 114 | |
115 | 115 | /** |
@@ -119,11 +119,11 @@ discard block |
||
119 | 119 | * @param EE_Base_Class $related_model_obj |
120 | 120 | * @return EE_Change_Log |
121 | 121 | */ |
122 | - public function log($log_type,$message,$related_model_obj){ |
|
123 | - if($related_model_obj instanceof EE_Base_Class){ |
|
122 | + public function log($log_type, $message, $related_model_obj) { |
|
123 | + if ($related_model_obj instanceof EE_Base_Class) { |
|
124 | 124 | $obj_id = $related_model_obj->ID(); |
125 | 125 | $obj_type = $related_model_obj->get_model()->get_this_model_name(); |
126 | - }else{ |
|
126 | + } else { |
|
127 | 127 | $obj_id = NULL; |
128 | 128 | $obj_type = NULL; |
129 | 129 | } |
@@ -147,9 +147,9 @@ discard block |
||
147 | 147 | * @throws EE_Error |
148 | 148 | * @return EE_Change_Log |
149 | 149 | */ |
150 | - public function gateway_log( $message, $related_obj_id, $related_obj_type ){ |
|
151 | - if( ! EE_Registry::instance()->is_model_name($related_obj_type)){ |
|
152 | - throw new EE_Error(sprintf(__("'%s' is not a model name. A model name must be provided when making a gateway log. Eg, 'Payment', 'Payment_Method', etc", "event_espresso"),$related_obj_type)); |
|
150 | + public function gateway_log($message, $related_obj_id, $related_obj_type) { |
|
151 | + if ( ! EE_Registry::instance()->is_model_name($related_obj_type)) { |
|
152 | + throw new EE_Error(sprintf(__("'%s' is not a model name. A model name must be provided when making a gateway log. Eg, 'Payment', 'Payment_Method', etc", "event_espresso"), $related_obj_type)); |
|
153 | 153 | } |
154 | 154 | $log = EE_Change_Log::new_instance(array( |
155 | 155 | 'LOG_type'=>EEM_Change_Log::type_gateway, |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | * @param array $query_params @see EEM_Base::get_all |
169 | 169 | * @return array of arrays |
170 | 170 | */ |
171 | - public function get_all_efficiently($query_params){ |
|
171 | + public function get_all_efficiently($query_params) { |
|
172 | 172 | return $this->_get_all_wpdb_results($query_params); |
173 | 173 | } |
174 | 174 |
@@ -1,7 +1,8 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
4 | 4 | exit('No direct script access allowed'); |
5 | +} |
|
5 | 6 | |
6 | 7 | /** |
7 | 8 | * Event Espresso |
@@ -99,7 +100,7 @@ discard block |
||
99 | 100 | foreach($models_this_can_attach_to as $model){ |
100 | 101 | if( $model == 'WP_User' ){ |
101 | 102 | $this->_model_relations[ $model ] = new EE_Belongs_To_Relation(); |
102 | - }elseif( $model != 'Change_Log' ) { |
|
103 | + } elseif( $model != 'Change_Log' ) { |
|
103 | 104 | $this->_model_relations[$model] = new EE_Belongs_To_Any_Relation(); |
104 | 105 | } |
105 | 106 | } |
@@ -123,7 +124,7 @@ discard block |
||
123 | 124 | if($related_model_obj instanceof EE_Base_Class){ |
124 | 125 | $obj_id = $related_model_obj->ID(); |
125 | 126 | $obj_type = $related_model_obj->get_model()->get_this_model_name(); |
126 | - }else{ |
|
127 | + } else{ |
|
127 | 128 | $obj_id = NULL; |
128 | 129 | $obj_type = NULL; |
129 | 130 | } |
@@ -292,7 +292,7 @@ |
||
292 | 292 | * which would happen if some of the registrations had a price modifier while others didn't. |
293 | 293 | * In order to support that, we'd probably need a LIN_ID on registrations or something. |
294 | 294 | * @param EE_Registration $registration |
295 | - * @return EEM_Line_ITem |
|
295 | + * @return EE_Base_Class|null |
|
296 | 296 | */ |
297 | 297 | public function get_line_item_for_registration( EE_Registration $registration ) { |
298 | 298 | return $this->get_one( $this->line_item_for_registration_query_params( $registration )); |
@@ -1,4 +1,6 @@ |
||
1 | -<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | /** |
3 | 5 | * Event Espresso |
4 | 6 | * |
@@ -103,41 +103,41 @@ discard block |
||
103 | 103 | * @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) |
104 | 104 | * @return \EEM_Line_Item |
105 | 105 | */ |
106 | - protected function __construct( $timezone ) { |
|
107 | - $this->singular_item = __('Line Item','event_espresso'); |
|
108 | - $this->plural_item = __('Line Items','event_espresso'); |
|
106 | + protected function __construct($timezone) { |
|
107 | + $this->singular_item = __('Line Item', 'event_espresso'); |
|
108 | + $this->plural_item = __('Line Items', 'event_espresso'); |
|
109 | 109 | |
110 | 110 | $this->_tables = array( |
111 | - 'Line_Item'=>new EE_Primary_Table('esp_line_item','LIN_ID') |
|
111 | + 'Line_Item'=>new EE_Primary_Table('esp_line_item', 'LIN_ID') |
|
112 | 112 | ); |
113 | - $line_items_can_be_for = apply_filters( 'FHEE__EEM_Line_Item__line_items_can_be_for', array('Ticket','Price', 'Event' ) ); |
|
113 | + $line_items_can_be_for = apply_filters('FHEE__EEM_Line_Item__line_items_can_be_for', array('Ticket', 'Price', 'Event')); |
|
114 | 114 | $this->_fields = array( |
115 | 115 | 'Line_Item' => array( |
116 | - 'LIN_ID' => new EE_Primary_Key_Int_Field( 'LIN_ID', __( "ID", "event_espresso" ) ), |
|
117 | - 'LIN_code' => new EE_Slug_Field( 'LIN_code', __( "Code for index into Cart", "event_espresso" ), TRUE ), |
|
118 | - 'TXN_ID' => new EE_Foreign_Key_Int_Field( 'TXN_ID', __( "Transaction ID", "event_espresso" ), TRUE, NULL, 'Transaction' ), |
|
119 | - 'LIN_name' => new EE_Full_HTML_Field( 'LIN_name', __( "Line Item Name", "event_espresso" ), FALSE, '' ), |
|
120 | - 'LIN_desc' => new EE_Full_HTML_Field( 'LIN_desc', __( "Line Item Description", "event_espresso" ), TRUE ), |
|
121 | - 'LIN_unit_price' => new EE_Money_Field( 'LIN_unit_price', __( "Unit Price", "event_espresso" ), FALSE, 0 ), |
|
122 | - 'LIN_percent' => new EE_Float_Field( 'LIN_percent', __( "Percent", "event_espresso" ), FALSE, 0 ), |
|
123 | - 'LIN_is_taxable' => new EE_Boolean_Field( 'LIN_is_taxable', __( "Taxable", "event_espresso" ), FALSE, FALSE ), |
|
124 | - 'LIN_order' => new EE_Integer_Field( 'LIN_order', __( "Order of Application towards total of parent", "event_espresso" ), FALSE, 1 ), |
|
125 | - 'LIN_total' => new EE_Money_Field( 'LIN_total', __( "Total (unit price x quantity)", "event_espresso" ), FALSE, 0 ), |
|
126 | - 'LIN_quantity' => new EE_Integer_Field( 'LIN_quantity', __( "Quantity", "event_espresso" ), TRUE, 1 ), |
|
127 | - 'LIN_parent' => new EE_Integer_Field( 'LIN_parent', __( "Parent ID (this item goes towards that Line Item's total)", "event_espresso" ), TRUE, NULL ), |
|
128 | - 'LIN_type' => new EE_Enum_Text_Field( 'LIN_type', __( "Type", "event_espresso" ), FALSE, 'line-item', array( |
|
116 | + 'LIN_ID' => new EE_Primary_Key_Int_Field('LIN_ID', __("ID", "event_espresso")), |
|
117 | + 'LIN_code' => new EE_Slug_Field('LIN_code', __("Code for index into Cart", "event_espresso"), TRUE), |
|
118 | + 'TXN_ID' => new EE_Foreign_Key_Int_Field('TXN_ID', __("Transaction ID", "event_espresso"), TRUE, NULL, 'Transaction'), |
|
119 | + 'LIN_name' => new EE_Full_HTML_Field('LIN_name', __("Line Item Name", "event_espresso"), FALSE, ''), |
|
120 | + 'LIN_desc' => new EE_Full_HTML_Field('LIN_desc', __("Line Item Description", "event_espresso"), TRUE), |
|
121 | + 'LIN_unit_price' => new EE_Money_Field('LIN_unit_price', __("Unit Price", "event_espresso"), FALSE, 0), |
|
122 | + 'LIN_percent' => new EE_Float_Field('LIN_percent', __("Percent", "event_espresso"), FALSE, 0), |
|
123 | + 'LIN_is_taxable' => new EE_Boolean_Field('LIN_is_taxable', __("Taxable", "event_espresso"), FALSE, FALSE), |
|
124 | + 'LIN_order' => new EE_Integer_Field('LIN_order', __("Order of Application towards total of parent", "event_espresso"), FALSE, 1), |
|
125 | + 'LIN_total' => new EE_Money_Field('LIN_total', __("Total (unit price x quantity)", "event_espresso"), FALSE, 0), |
|
126 | + 'LIN_quantity' => new EE_Integer_Field('LIN_quantity', __("Quantity", "event_espresso"), TRUE, 1), |
|
127 | + 'LIN_parent' => new EE_Integer_Field('LIN_parent', __("Parent ID (this item goes towards that Line Item's total)", "event_espresso"), TRUE, NULL), |
|
128 | + 'LIN_type' => new EE_Enum_Text_Field('LIN_type', __("Type", "event_espresso"), FALSE, 'line-item', array( |
|
129 | 129 | self::type_line_item => __("Line Item", "event_espresso"), |
130 | 130 | self::type_sub_line_item => __("Sub-Item", "event_espresso"), |
131 | 131 | self::type_sub_total => __("Subtotal", "event_espresso"), |
132 | 132 | self::type_tax_sub_total => __("Tax Subtotal", "event_espresso"), |
133 | 133 | self::type_tax => __("Tax", "event_espresso"), |
134 | 134 | self::type_total => __("Total", "event_espresso"), |
135 | - self::type_cancellation => __( 'Cancellation', 'event_espresso' ) |
|
135 | + self::type_cancellation => __('Cancellation', 'event_espresso') |
|
136 | 136 | ) |
137 | 137 | ), |
138 | - 'OBJ_ID' => new EE_Foreign_Key_Int_Field( 'OBJ_ID', __( 'ID of Item purchased.', 'event_espresso' ), TRUE, NULL, $line_items_can_be_for ), |
|
139 | - 'OBJ_type' =>new EE_Any_Foreign_Model_Name_Field( 'OBJ_type', __( "Model Name this Line Item is for", "event_espresso" ), TRUE, NULL, $line_items_can_be_for ), |
|
140 | - 'LIN_timestamp' => new EE_Datetime_Field('LIN_timestamp', __('When the line item was created','event_espresso'), false, time(), $timezone ), |
|
138 | + 'OBJ_ID' => new EE_Foreign_Key_Int_Field('OBJ_ID', __('ID of Item purchased.', 'event_espresso'), TRUE, NULL, $line_items_can_be_for), |
|
139 | + 'OBJ_type' =>new EE_Any_Foreign_Model_Name_Field('OBJ_type', __("Model Name this Line Item is for", "event_espresso"), TRUE, NULL, $line_items_can_be_for), |
|
140 | + 'LIN_timestamp' => new EE_Datetime_Field('LIN_timestamp', __('When the line item was created', 'event_espresso'), false, time(), $timezone), |
|
141 | 141 | ) |
142 | 142 | ); |
143 | 143 | $this->_model_relations = array( |
@@ -148,7 +148,7 @@ discard block |
||
148 | 148 | ); |
149 | 149 | $this->_model_chain_to_wp_user = 'Transaction.Registration.Event'; |
150 | 150 | $this->_caps_slug = 'transactions'; |
151 | - parent::__construct( $timezone ); |
|
151 | + parent::__construct($timezone); |
|
152 | 152 | } |
153 | 153 | |
154 | 154 | |
@@ -159,9 +159,9 @@ discard block |
||
159 | 159 | * @param EE_Transaction|int $transaction |
160 | 160 | * @return EE_Line_Item[] |
161 | 161 | */ |
162 | - public function get_all_of_type_for_transaction( $line_item_type, $transaction ){ |
|
163 | - $transaction = EEM_Transaction::instance()->ensure_is_ID( $transaction ); |
|
164 | - return $this->get_all( array( array( |
|
162 | + public function get_all_of_type_for_transaction($line_item_type, $transaction) { |
|
163 | + $transaction = EEM_Transaction::instance()->ensure_is_ID($transaction); |
|
164 | + return $this->get_all(array(array( |
|
165 | 165 | 'LIN_type' => $line_item_type, |
166 | 166 | 'TXN_ID' => $transaction |
167 | 167 | ))); |
@@ -175,14 +175,14 @@ discard block |
||
175 | 175 | * @param EE_Transaction|int $transaction |
176 | 176 | * @return \EE_Base_Class[] |
177 | 177 | */ |
178 | - public function get_all_non_ticket_line_items_for_transaction( $transaction ) { |
|
179 | - $transaction = EEM_Transaction::instance()->ensure_is_ID( $transaction ); |
|
180 | - return $this->get_all( array( array( |
|
178 | + public function get_all_non_ticket_line_items_for_transaction($transaction) { |
|
179 | + $transaction = EEM_Transaction::instance()->ensure_is_ID($transaction); |
|
180 | + return $this->get_all(array(array( |
|
181 | 181 | 'LIN_type' => self::type_line_item, |
182 | 182 | 'TXN_ID' => $transaction, |
183 | 183 | 'OR' => array( |
184 | - 'OBJ_type*notticket' => array( '!=', 'Ticket'), |
|
185 | - 'OBJ_type*null' => array( 'IS_NULL' )) |
|
184 | + 'OBJ_type*notticket' => array('!=', 'Ticket'), |
|
185 | + 'OBJ_type*null' => array('IS_NULL')) |
|
186 | 186 | ))); |
187 | 187 | } |
188 | 188 | |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | * because if there are spam bots afoot there will be LOTS of line items |
193 | 193 | * @return int count of how many deleted |
194 | 194 | */ |
195 | - public function delete_line_items_with_no_transaction(){ |
|
195 | + public function delete_line_items_with_no_transaction() { |
|
196 | 196 | /** @type WPDB $wpdb */ |
197 | 197 | global $wpdb; |
198 | 198 | $time_to_leave_alone = apply_filters( |
@@ -200,13 +200,13 @@ discard block |
||
200 | 200 | ); |
201 | 201 | $query = $wpdb->prepare( |
202 | 202 | 'DELETE li |
203 | - FROM ' . $this->table() . ' li |
|
204 | - LEFT JOIN ' . EEM_Transaction::instance()->table(). ' t ON li.TXN_ID = t.TXN_ID |
|
203 | + FROM ' . $this->table().' li |
|
204 | + LEFT JOIN ' . EEM_Transaction::instance()->table().' t ON li.TXN_ID = t.TXN_ID |
|
205 | 205 | WHERE t.TXN_ID IS NULL AND li.LIN_timestamp < %s', |
206 | 206 | // use GMT time because that's what TXN_timestamps are in |
207 | - gmdate( 'Y-m-d H:i:s', time() - $time_to_leave_alone ) |
|
207 | + gmdate('Y-m-d H:i:s', time() - $time_to_leave_alone) |
|
208 | 208 | ); |
209 | - return $wpdb->query( $query ); |
|
209 | + return $wpdb->query($query); |
|
210 | 210 | } |
211 | 211 | |
212 | 212 | |
@@ -219,10 +219,10 @@ discard block |
||
219 | 219 | * @param \EE_Base_Class $object |
220 | 220 | * @return EE_Line_Item[] |
221 | 221 | */ |
222 | - public function get_line_item_for_transaction_object( $TXN_ID, EE_Base_Class $object ){ |
|
223 | - return $this->get_all( array( array( |
|
222 | + public function get_line_item_for_transaction_object($TXN_ID, EE_Base_Class $object) { |
|
223 | + return $this->get_all(array(array( |
|
224 | 224 | 'TXN_ID' => $TXN_ID, |
225 | - 'OBJ_type' => str_replace( 'EE_', '', get_class( $object )), |
|
225 | + 'OBJ_type' => str_replace('EE_', '', get_class($object)), |
|
226 | 226 | 'OBJ_ID' => $object->ID() |
227 | 227 | ))); |
228 | 228 | } |
@@ -238,16 +238,16 @@ discard block |
||
238 | 238 | * @param array $OBJ_IDs |
239 | 239 | * @return EE_Line_Item[] |
240 | 240 | */ |
241 | - public function get_object_line_items_for_transaction( $TXN_ID, $OBJ_type = 'Event', $OBJ_IDs = array() ){ |
|
241 | + public function get_object_line_items_for_transaction($TXN_ID, $OBJ_type = 'Event', $OBJ_IDs = array()) { |
|
242 | 242 | $query_params = array( |
243 | 243 | 'OBJ_type' => $OBJ_type, |
244 | 244 | // if incoming $OBJ_IDs is an array, then make sure it is formatted correctly for the query |
245 | - 'OBJ_ID' => is_array( $OBJ_IDs ) && ! isset( $OBJ_IDs['IN'] ) ? array( 'IN', $OBJ_IDs ) : $OBJ_IDs |
|
245 | + 'OBJ_ID' => is_array($OBJ_IDs) && ! isset($OBJ_IDs['IN']) ? array('IN', $OBJ_IDs) : $OBJ_IDs |
|
246 | 246 | ); |
247 | - if ( $TXN_ID ) { |
|
247 | + if ($TXN_ID) { |
|
248 | 248 | $query_params['TXN_ID'] = $TXN_ID; |
249 | 249 | } |
250 | - return $this->get_all( array( $query_params )); |
|
250 | + return $this->get_all(array($query_params)); |
|
251 | 251 | } |
252 | 252 | |
253 | 253 | |
@@ -262,8 +262,8 @@ discard block |
||
262 | 262 | * @param EE_Promotion $promotion |
263 | 263 | * @return EE_Line_Item |
264 | 264 | */ |
265 | - public function get_existing_promotion_line_item( EE_Line_Item $parent_line_item, EE_Promotion $promotion ) { |
|
266 | - return $this->get_one( array( |
|
265 | + public function get_existing_promotion_line_item(EE_Line_Item $parent_line_item, EE_Promotion $promotion) { |
|
266 | + return $this->get_one(array( |
|
267 | 267 | array( |
268 | 268 | 'TXN_ID' => $parent_line_item->TXN_ID(), |
269 | 269 | 'LIN_parent' => $parent_line_item->ID(), |
@@ -284,8 +284,8 @@ discard block |
||
284 | 284 | * @param EE_Line_Item $parent_line_item |
285 | 285 | * @return EE_Line_Item[] |
286 | 286 | */ |
287 | - public function get_all_promotion_line_items( EE_Line_Item $parent_line_item ) { |
|
288 | - return $this->get_all( array( |
|
287 | + public function get_all_promotion_line_items(EE_Line_Item $parent_line_item) { |
|
288 | + return $this->get_all(array( |
|
289 | 289 | array( |
290 | 290 | 'TXN_ID' => $parent_line_item->TXN_ID(), |
291 | 291 | 'LIN_parent' => $parent_line_item->ID(), |
@@ -302,8 +302,8 @@ discard block |
||
302 | 302 | * @param EE_Registration $registration |
303 | 303 | * @return EEM_Line_ITem |
304 | 304 | */ |
305 | - public function get_line_item_for_registration( EE_Registration $registration ) { |
|
306 | - return $this->get_one( $this->line_item_for_registration_query_params( $registration )); |
|
305 | + public function get_line_item_for_registration(EE_Registration $registration) { |
|
306 | + return $this->get_one($this->line_item_for_registration_query_params($registration)); |
|
307 | 307 | } |
308 | 308 | |
309 | 309 | /** |
@@ -312,14 +312,14 @@ discard block |
||
312 | 312 | * @param array $original_query_params any extra query params you'd like to be merged with |
313 | 313 | * @return array like EEM_Base::get_all()'s $query_params |
314 | 314 | */ |
315 | - public function line_item_for_registration_query_params( EE_Registration $registration, $original_query_params = array() ) { |
|
316 | - return array_replace_recursive( $original_query_params, array( |
|
315 | + public function line_item_for_registration_query_params(EE_Registration $registration, $original_query_params = array()) { |
|
316 | + return array_replace_recursive($original_query_params, array( |
|
317 | 317 | array( |
318 | 318 | 'OBJ_ID' => $registration->ticket_ID(), |
319 | 319 | 'OBJ_type' => 'Ticket', |
320 | 320 | 'TXN_ID' => $registration->transaction_ID() |
321 | 321 | ) |
322 | - ) ); |
|
322 | + )); |
|
323 | 323 | } |
324 | 324 | |
325 | 325 |
@@ -43,7 +43,7 @@ discard block |
||
43 | 43 | /** |
44 | 44 | * return an array of Base types. Keys are INTs which are used in the database, |
45 | 45 | * values are text-representations of the base type. |
46 | - * @return array |
|
46 | + * @return integer |
|
47 | 47 | */ |
48 | 48 | public function get_base_types(){ |
49 | 49 | return $this->base_types; |
@@ -121,7 +121,7 @@ discard block |
||
121 | 121 | * instantiate a new price type object with blank/empty properties |
122 | 122 | * |
123 | 123 | * @access public |
124 | - * @return mixed array on success, FALSE on fail |
|
124 | + * @return EE_Price_Type array on success, FALSE on fail |
|
125 | 125 | */ |
126 | 126 | public function get_new_price_type() { |
127 | 127 | return EE_Price_Type::new_instance(); |
@@ -33,11 +33,11 @@ discard block |
||
33 | 33 | public $type = NULL; |
34 | 34 | |
35 | 35 | /** |
36 | - * Price Base types |
|
37 | - * |
|
38 | - * @access private |
|
39 | - * @var int |
|
40 | - */ |
|
36 | + * Price Base types |
|
37 | + * |
|
38 | + * @access private |
|
39 | + * @var int |
|
40 | + */ |
|
41 | 41 | public $base_types = null; |
42 | 42 | |
43 | 43 | /** |
@@ -144,8 +144,8 @@ discard block |
||
144 | 144 | * |
145 | 145 | * @param type $query_params |
146 | 146 | * @param boolean $allow_blocking if TRUE, matched objects will only be deleted if there is no related model info |
147 | - * that blocks it (ie, there' sno other data that depends on this data); if false, deletes regardless of other objects |
|
148 | - * which may depend on it. Its generally advisable to always leave this as TRUE, otherwise you could easily corrupt your DB |
|
147 | + * that blocks it (ie, there' sno other data that depends on this data); if false, deletes regardless of other objects |
|
148 | + * which may depend on it. Its generally advisable to always leave this as TRUE, otherwise you could easily corrupt your DB |
|
149 | 149 | * @return boolean |
150 | 150 | */ |
151 | 151 | public function delete_permanently($query_params = array(), $allow_blocking = true) { |
@@ -21,8 +21,8 @@ discard block |
||
21 | 21 | * |
22 | 22 | * ------------------------------------------------------------------------ |
23 | 23 | */ |
24 | -require_once ( EE_MODELS . 'EEM_Soft_Delete_Base.model.php' ); |
|
25 | -require_once ( EE_CLASSES . 'EE_Price_Type.class.php' ); |
|
24 | +require_once (EE_MODELS.'EEM_Soft_Delete_Base.model.php'); |
|
25 | +require_once (EE_CLASSES.'EE_Price_Type.class.php'); |
|
26 | 26 | |
27 | 27 | |
28 | 28 | class EEM_Price_Type extends EEM_Soft_Delete_Base { |
@@ -45,7 +45,7 @@ discard block |
||
45 | 45 | * values are text-representations of the base type. |
46 | 46 | * @return array |
47 | 47 | */ |
48 | - public function get_base_types(){ |
|
48 | + public function get_base_types() { |
|
49 | 49 | return $this->base_types; |
50 | 50 | } |
51 | 51 | |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | * @param type $base_type_int |
55 | 55 | * @return type |
56 | 56 | */ |
57 | - public function get_base_type_name($base_type_int){ |
|
57 | + public function get_base_type_name($base_type_int) { |
|
58 | 58 | return $this->base_types[$base_type_int]; |
59 | 59 | } |
60 | 60 | |
@@ -79,27 +79,27 @@ discard block |
||
79 | 79 | * @access protected |
80 | 80 | * @return void |
81 | 81 | */ |
82 | - protected function __construct( $timezone = NULL ) { |
|
82 | + protected function __construct($timezone = NULL) { |
|
83 | 83 | $this->base_types = array( |
84 | - EEM_Price_Type::base_type_base_price => __('Price','event_espresso'), |
|
85 | - EEM_Price_Type::base_type_discount => __('Discount','event_espresso'), |
|
86 | - EEM_Price_Type::base_type_surcharge => __('Surcharge','event_espresso'), |
|
87 | - EEM_Price_Type::base_type_tax => __('Tax','event_espresso') ); |
|
88 | - $this->singular_item = __('Price Type','event_espresso'); |
|
89 | - $this->plural_item = __('Price Types','event_espresso'); |
|
84 | + EEM_Price_Type::base_type_base_price => __('Price', 'event_espresso'), |
|
85 | + EEM_Price_Type::base_type_discount => __('Discount', 'event_espresso'), |
|
86 | + EEM_Price_Type::base_type_surcharge => __('Surcharge', 'event_espresso'), |
|
87 | + EEM_Price_Type::base_type_tax => __('Tax', 'event_espresso') ); |
|
88 | + $this->singular_item = __('Price Type', 'event_espresso'); |
|
89 | + $this->plural_item = __('Price Types', 'event_espresso'); |
|
90 | 90 | |
91 | 91 | $this->_tables = array( |
92 | - 'Price_Type'=>new EE_Primary_Table('esp_price_type','PRT_ID') |
|
92 | + 'Price_Type'=>new EE_Primary_Table('esp_price_type', 'PRT_ID') |
|
93 | 93 | ); |
94 | 94 | $this->_fields = array( |
95 | 95 | 'Price_Type'=>array( |
96 | - 'PRT_ID'=>new EE_Primary_Key_Int_Field('PRT_ID', __('Price Type ID','event_espresso')), |
|
97 | - 'PRT_name'=>new EE_Plain_Text_Field('PRT_name', __('Price Type Name','event_espresso'), false, ''), |
|
98 | - 'PBT_ID'=>new EE_Enum_Integer_Field('PBT_ID', __('Price Base type ID, 1 = Price , 2 = Discount , 3 = Surcharge , 4 = Tax','event_espresso'), false, EEM_Price_Type::base_type_base_price, $this->base_types), |
|
99 | - 'PRT_is_percent'=>new EE_Boolean_Field('PRT_is_percent', __('Flag indicating price is a percentage','event_espresso'), false, false), |
|
100 | - 'PRT_order'=>new EE_Integer_Field('PRT_order', __('Order in which price should be applied. ','event_espresso'), false, 0), |
|
101 | - 'PRT_deleted'=>new EE_Trashed_Flag_Field('PRT_deleted', __('Flag indicating price type has been trashed','event_espresso'), false, false), |
|
102 | - 'PRT_wp_user' => new EE_WP_User_Field('PRT_wp_user', __('Price Type Creator ID', 'event_espresso'), FALSE ), |
|
96 | + 'PRT_ID'=>new EE_Primary_Key_Int_Field('PRT_ID', __('Price Type ID', 'event_espresso')), |
|
97 | + 'PRT_name'=>new EE_Plain_Text_Field('PRT_name', __('Price Type Name', 'event_espresso'), false, ''), |
|
98 | + 'PBT_ID'=>new EE_Enum_Integer_Field('PBT_ID', __('Price Base type ID, 1 = Price , 2 = Discount , 3 = Surcharge , 4 = Tax', 'event_espresso'), false, EEM_Price_Type::base_type_base_price, $this->base_types), |
|
99 | + 'PRT_is_percent'=>new EE_Boolean_Field('PRT_is_percent', __('Flag indicating price is a percentage', 'event_espresso'), false, false), |
|
100 | + 'PRT_order'=>new EE_Integer_Field('PRT_order', __('Order in which price should be applied. ', 'event_espresso'), false, 0), |
|
101 | + 'PRT_deleted'=>new EE_Trashed_Flag_Field('PRT_deleted', __('Flag indicating price type has been trashed', 'event_espresso'), false, false), |
|
102 | + 'PRT_wp_user' => new EE_WP_User_Field('PRT_wp_user', __('Price Type Creator ID', 'event_espresso'), FALSE), |
|
103 | 103 | ) |
104 | 104 | ); |
105 | 105 | $this->_model_relations = array( |
@@ -107,10 +107,10 @@ discard block |
||
107 | 107 | 'WP_User' => new EE_Belongs_To_Relation(), |
108 | 108 | ); |
109 | 109 | //this model is generally available for reading |
110 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = new EE_Restriction_Generator_Public(); |
|
110 | + $this->_cap_restriction_generators[EEM_Base::caps_read] = new EE_Restriction_Generator_Public(); |
|
111 | 111 | //all price types are "default" in terms of capability names |
112 | 112 | $this->_caps_slug = 'default_price_types'; |
113 | - parent::__construct( $timezone ); |
|
113 | + parent::__construct($timezone); |
|
114 | 114 | |
115 | 115 | } |
116 | 116 | |
@@ -156,15 +156,15 @@ discard block |
||
156 | 156 | $ID = $query_params[0][$this->get_primary_key_field()->get_name()]; |
157 | 157 | |
158 | 158 | //check if any prices use this price type |
159 | - $prc_query_params = array(array('PRT_ID'=>array('IN',$would_be_deleted_price_type_ids))); |
|
160 | - if ( $prices = $this->get_all_related($ID,'Price',$prc_query_params)) { |
|
159 | + $prc_query_params = array(array('PRT_ID'=>array('IN', $would_be_deleted_price_type_ids))); |
|
160 | + if ($prices = $this->get_all_related($ID, 'Price', $prc_query_params)) { |
|
161 | 161 | $prices_names_and_ids = array(); |
162 | - foreach($prices as $price){ |
|
162 | + foreach ($prices as $price) { |
|
163 | 163 | /* @var $price EE_Price */ |
164 | 164 | $prices_names_and_ids[] = $price->name()."(".$price->ID().")"; |
165 | 165 | } |
166 | - $msg = sprintf(__('The Price Type(s) could not be deleted because there are existing Prices that currently use this Price Type. If you still wish to delete this Price Type, then either delete those Prices or change them to use other Price Types.The prices are: %s', 'event_espresso'),implode(",",$prices_names_and_ids)); |
|
167 | - EE_Error::add_error( $msg, __FILE__, __FUNCTION__, __LINE__ ); |
|
166 | + $msg = sprintf(__('The Price Type(s) could not be deleted because there are existing Prices that currently use this Price Type. If you still wish to delete this Price Type, then either delete those Prices or change them to use other Price Types.The prices are: %s', 'event_espresso'), implode(",", $prices_names_and_ids)); |
|
167 | + EE_Error::add_error($msg, __FILE__, __FUNCTION__, __LINE__); |
|
168 | 168 | return FALSE; |
169 | 169 | } |
170 | 170 |
@@ -1,4 +1,6 @@ |
||
1 | -<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | /** |
3 | 5 | * Event Espresso |
4 | 6 | * |
@@ -165,7 +165,7 @@ |
||
165 | 165 | * |
166 | 166 | * @access public |
167 | 167 | * @param $STA_ID |
168 | - * @return mixed array on success, FALSE on fail |
|
168 | + * @return boolean array on success, FALSE on fail |
|
169 | 169 | */ |
170 | 170 | public function delete_by_ID( $STA_ID = FALSE ) { |
171 | 171 |
@@ -64,11 +64,11 @@ discard block |
||
64 | 64 | |
65 | 65 | |
66 | 66 | /** |
67 | - * reset_cached_states |
|
68 | - * |
|
69 | - * @access private |
|
70 | - * @return void |
|
71 | - */ |
|
67 | + * reset_cached_states |
|
68 | + * |
|
69 | + * @access private |
|
70 | + * @return void |
|
71 | + */ |
|
72 | 72 | public function reset_cached_states() { |
73 | 73 | EEM_State::$_active_states = array(); |
74 | 74 | EEM_State::$_all_states = array(); |
@@ -78,11 +78,11 @@ discard block |
||
78 | 78 | |
79 | 79 | |
80 | 80 | /** |
81 | - * _get_states |
|
82 | - * |
|
83 | - * @access private |
|
84 | - * @return array |
|
85 | - */ |
|
81 | + * _get_states |
|
82 | + * |
|
83 | + * @access private |
|
84 | + * @return array |
|
85 | + */ |
|
86 | 86 | public function get_all_states() { |
87 | 87 | if ( ! self::$_all_states ) { |
88 | 88 | self::$_all_states = $this->get_all( array( 'order_by'=>array( 'STA_name'=>'ASC' ), 'limit'=> array( 0, 99999 ))); |
@@ -161,12 +161,12 @@ discard block |
||
161 | 161 | |
162 | 162 | |
163 | 163 | /** |
164 | - * delete a single state from db via their ID |
|
165 | - * |
|
166 | - * @access public |
|
167 | - * @param $STA_ID |
|
168 | - * @return mixed array on success, FALSE on fail |
|
169 | - */ |
|
164 | + * delete a single state from db via their ID |
|
165 | + * |
|
166 | + * @access public |
|
167 | + * @param $STA_ID |
|
168 | + * @return mixed array on success, FALSE on fail |
|
169 | + */ |
|
170 | 170 | public function delete_by_ID( $STA_ID = FALSE ) { |
171 | 171 | |
172 | 172 | if ( ! $STA_ID ) { |
@@ -21,8 +21,8 @@ discard block |
||
21 | 21 | * |
22 | 22 | * ------------------------------------------------------------------------ |
23 | 23 | */ |
24 | -require_once ( EE_MODELS . 'EEM_Base.model.php' ); |
|
25 | -require_once ( EE_CLASSES . 'EE_State.class.php' ); |
|
24 | +require_once (EE_MODELS.'EEM_Base.model.php'); |
|
25 | +require_once (EE_CLASSES.'EE_State.class.php'); |
|
26 | 26 | |
27 | 27 | class EEM_State extends EEM_Base { |
28 | 28 | |
@@ -33,9 +33,9 @@ discard block |
||
33 | 33 | // array of all active states |
34 | 34 | private static $_active_states = FALSE; |
35 | 35 | |
36 | - protected function __construct( $timezone = NULL ) { |
|
37 | - $this->singular_item = __('State/Province','event_espresso'); |
|
38 | - $this->plural_item = __('States/Provinces','event_espresso'); |
|
36 | + protected function __construct($timezone = NULL) { |
|
37 | + $this->singular_item = __('State/Province', 'event_espresso'); |
|
38 | + $this->plural_item = __('States/Provinces', 'event_espresso'); |
|
39 | 39 | |
40 | 40 | $this->_tables = array( |
41 | 41 | 'State'=> new EE_Primary_Table('esp_state', 'STA_ID') |
@@ -43,10 +43,10 @@ discard block |
||
43 | 43 | |
44 | 44 | $this->_fields = array( |
45 | 45 | 'State'=>array( |
46 | - 'STA_ID'=> new EE_Primary_Key_Int_Field('STA_ID', __('State ID','event_espresso')), |
|
47 | - 'CNT_ISO'=> new EE_Foreign_Key_String_Field('CNT_ISO', __('Country ISO Code','event_espresso'), false, NULL, 'Country'), |
|
48 | - 'STA_abbrev' => new EE_Plain_Text_Field('STA_abbrev', __('State Abbreviation','event_espresso'), false, ''), |
|
49 | - 'STA_name' => new EE_Plain_Text_Field('STA_name', __('State Name','event_espresso'), false, ''), |
|
46 | + 'STA_ID'=> new EE_Primary_Key_Int_Field('STA_ID', __('State ID', 'event_espresso')), |
|
47 | + 'CNT_ISO'=> new EE_Foreign_Key_String_Field('CNT_ISO', __('Country ISO Code', 'event_espresso'), false, NULL, 'Country'), |
|
48 | + 'STA_abbrev' => new EE_Plain_Text_Field('STA_abbrev', __('State Abbreviation', 'event_espresso'), false, ''), |
|
49 | + 'STA_name' => new EE_Plain_Text_Field('STA_name', __('State Name', 'event_espresso'), false, ''), |
|
50 | 50 | 'STA_active'=> new EE_Boolean_Field('STA_active', __('State Active Flag', 'event_espresso'), false, false) |
51 | 51 | )); |
52 | 52 | $this->_model_relations = array( |
@@ -55,9 +55,9 @@ discard block |
||
55 | 55 | 'Venue'=>new EE_Has_Many_Relation(), |
56 | 56 | ); |
57 | 57 | //this model is generally available for reading |
58 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = new EE_Restriction_Generator_Public(); |
|
58 | + $this->_cap_restriction_generators[EEM_Base::caps_read] = new EE_Restriction_Generator_Public(); |
|
59 | 59 | //@todo: only show STA_active |
60 | - parent::__construct( $timezone ); |
|
60 | + parent::__construct($timezone); |
|
61 | 61 | } |
62 | 62 | |
63 | 63 | |
@@ -84,8 +84,8 @@ discard block |
||
84 | 84 | * @return array |
85 | 85 | */ |
86 | 86 | public function get_all_states() { |
87 | - if ( ! self::$_all_states ) { |
|
88 | - self::$_all_states = $this->get_all( array( 'order_by'=>array( 'STA_name'=>'ASC' ), 'limit'=> array( 0, 99999 ))); |
|
87 | + if ( ! self::$_all_states) { |
|
88 | + self::$_all_states = $this->get_all(array('order_by'=>array('STA_name'=>'ASC'), 'limit'=> array(0, 99999))); |
|
89 | 89 | } |
90 | 90 | return self::$_all_states; |
91 | 91 | } |
@@ -100,14 +100,14 @@ discard block |
||
100 | 100 | * @param bool $flush_cache |
101 | 101 | * @return array |
102 | 102 | */ |
103 | - public function get_all_active_states( $countries = array(), $flush_cache = FALSE ) { |
|
104 | - if ( ! self::$_active_states || $flush_cache ) { |
|
105 | - $countries = is_array( $countries ) && ! empty( $countries ) ? $countries : EEM_Country::instance()->get_all_active_countries(); |
|
106 | - self::$_active_states = $this->get_all( array( |
|
107 | - array( 'STA_active' => TRUE, 'CNT_ISO' => array( 'IN', array_keys( $countries ))), |
|
108 | - 'order_by' => array( 'STA_name'=>'ASC' ), |
|
109 | - 'limit' => array( 0, 99999 ), |
|
110 | - 'force_join' => array( 'Country' ) |
|
103 | + public function get_all_active_states($countries = array(), $flush_cache = FALSE) { |
|
104 | + if ( ! self::$_active_states || $flush_cache) { |
|
105 | + $countries = is_array($countries) && ! empty($countries) ? $countries : EEM_Country::instance()->get_all_active_countries(); |
|
106 | + self::$_active_states = $this->get_all(array( |
|
107 | + array('STA_active' => TRUE, 'CNT_ISO' => array('IN', array_keys($countries))), |
|
108 | + 'order_by' => array('STA_name'=>'ASC'), |
|
109 | + 'limit' => array(0, 99999), |
|
110 | + 'force_join' => array('Country') |
|
111 | 111 | )); |
112 | 112 | } |
113 | 113 | return self::$_active_states; |
@@ -119,8 +119,8 @@ discard block |
||
119 | 119 | * get_all_states_of_active_countries |
120 | 120 | * @return array |
121 | 121 | */ |
122 | - public function get_all_states_of_active_countries(){ |
|
123 | - if ( $states = $this->get_all( array( array( 'Country.CNT_active' => TRUE, 'STA_active' => TRUE ), 'order_by' => array( 'Country.CNT_name' => 'ASC', 'STA_name' => 'ASC' )))) { |
|
122 | + public function get_all_states_of_active_countries() { |
|
123 | + if ($states = $this->get_all(array(array('Country.CNT_active' => TRUE, 'STA_active' => TRUE), 'order_by' => array('Country.CNT_name' => 'ASC', 'STA_name' => 'ASC')))) { |
|
124 | 124 | return $states; |
125 | 125 | } |
126 | 126 | return FALSE; |
@@ -132,11 +132,11 @@ discard block |
||
132 | 132 | * get_all_states_of_active_countries |
133 | 133 | * @return array |
134 | 134 | */ |
135 | - public function get_all_active_states_for_these_countries( $countries ){ |
|
136 | - if ( ! $countries ) { |
|
135 | + public function get_all_active_states_for_these_countries($countries) { |
|
136 | + if ( ! $countries) { |
|
137 | 137 | return FALSE; |
138 | 138 | } |
139 | - if ( $states = $this->get_all( array( array( 'Country.CNT_ISO' => array( 'IN', array_keys( $countries )), 'STA_active' => TRUE ), 'order_by' => array( 'Country.CNT_name' => 'ASC', 'STA_name' => 'ASC' )))) { |
|
139 | + if ($states = $this->get_all(array(array('Country.CNT_ISO' => array('IN', array_keys($countries)), 'STA_active' => TRUE), 'order_by' => array('Country.CNT_name' => 'ASC', 'STA_name' => 'ASC')))) { |
|
140 | 140 | return $states; |
141 | 141 | } |
142 | 142 | return FALSE; |
@@ -148,11 +148,11 @@ discard block |
||
148 | 148 | * get_all_states_of_active_countries |
149 | 149 | * @return array |
150 | 150 | */ |
151 | - public function get_all_states_for_these_countries( $countries ){ |
|
152 | - if ( ! $countries ) { |
|
151 | + public function get_all_states_for_these_countries($countries) { |
|
152 | + if ( ! $countries) { |
|
153 | 153 | return FALSE; |
154 | 154 | } |
155 | - if ( $states = $this->get_all( array( array( 'Country.CNT_ISO' => array( 'IN', array_keys( $countries ))), 'order_by' => array( 'Country.CNT_name' => 'ASC', 'STA_name' => 'ASC' )))) { |
|
155 | + if ($states = $this->get_all(array(array('Country.CNT_ISO' => array('IN', array_keys($countries))), 'order_by' => array('Country.CNT_name' => 'ASC', 'STA_name' => 'ASC')))) { |
|
156 | 156 | return $states; |
157 | 157 | } |
158 | 158 | return FALSE; |
@@ -167,15 +167,15 @@ discard block |
||
167 | 167 | * @param $STA_ID |
168 | 168 | * @return mixed array on success, FALSE on fail |
169 | 169 | */ |
170 | - public function delete_by_ID( $STA_ID = FALSE ) { |
|
170 | + public function delete_by_ID($STA_ID = FALSE) { |
|
171 | 171 | |
172 | - if ( ! $STA_ID ) { |
|
172 | + if ( ! $STA_ID) { |
|
173 | 173 | return FALSE; |
174 | 174 | } |
175 | 175 | |
176 | 176 | // retrieve a particular transaction |
177 | - $where_cols_n_values = array( array( 'STA_ID' => $STA_ID )); |
|
178 | - if ( $answer = $this->delete ( $where_cols_n_values )) { |
|
177 | + $where_cols_n_values = array(array('STA_ID' => $STA_ID)); |
|
178 | + if ($answer = $this->delete($where_cols_n_values)) { |
|
179 | 179 | return TRUE; |
180 | 180 | } else { |
181 | 181 | return FALSE; |
@@ -188,15 +188,15 @@ discard block |
||
188 | 188 | * @param string $state_ID |
189 | 189 | * @return string |
190 | 190 | */ |
191 | - public function get_state_name_by_ID( $state_ID ){ |
|
192 | - if( isset( self::$_all_states[ $state_ID ] ) && |
|
193 | - self::$_all_states[ $state_ID ] instanceof EE_State ){ |
|
194 | - return self::$_all_states[ $state_ID ]->name(); |
|
191 | + public function get_state_name_by_ID($state_ID) { |
|
192 | + if (isset(self::$_all_states[$state_ID]) && |
|
193 | + self::$_all_states[$state_ID] instanceof EE_State) { |
|
194 | + return self::$_all_states[$state_ID]->name(); |
|
195 | 195 | } |
196 | - $names = $this->get_col( array( array( 'STA_ID' => $state_ID ), 'limit' => 1), 'STA_name' ); |
|
197 | - if( is_array( $names ) && ! empty( $names ) ){ |
|
198 | - return reset( $names ); |
|
199 | - }else{ |
|
196 | + $names = $this->get_col(array(array('STA_ID' => $state_ID), 'limit' => 1), 'STA_name'); |
|
197 | + if (is_array($names) && ! empty($names)) { |
|
198 | + return reset($names); |
|
199 | + } else { |
|
200 | 200 | return ''; |
201 | 201 | } |
202 | 202 | } |
@@ -1,4 +1,6 @@ discard block |
||
1 | -<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | /** |
3 | 5 | * EEH_URL helper |
4 | 6 | * Helper class for URL-related PHP functions |
@@ -62,7 +64,7 @@ discard block |
||
62 | 64 | isset($results['response']['code']) && |
63 | 65 | $results['response']['code'] == '200'){ |
64 | 66 | return true; |
65 | - }else{ |
|
67 | + } else{ |
|
66 | 68 | return false; |
67 | 69 | } |
68 | 70 | } |