File "class-sp-event-performance-importer.php"
Full Path: /home/londdqdw/public_html/06/wp-content/plugins/sportspress/includes/admin/importers/class-sp-event-performance-importer.php
File size: 7.24 KB
MIME-type: text/x-php
Charset: utf-8
<?php
/**
* Event Performance importer - import box scores into SportsPress.
*
* @author ThemeBoy
* @category Admin
* @package SportsPress/Admin/Importers
* @version 2.7.13
*/
if ( ! defined( 'ABSPATH' ) ) {
exit; // Exit if accessed directly
}
if ( class_exists( 'WP_Importer' ) ) {
class SP_Event_Performance_Importer extends SP_Importer {
/**
* __construct function.
*
* @access public
* @return void
*/
public function __construct() {
$this->import_page = 'sp_event_performance_csv';
$this->import_label = esc_attr__( 'Import Box Score', 'sportspress' );
$this->columns = array(
'sp_player' => esc_attr__( 'Player', 'sportspress' ),
);
$performance_labels = sp_get_var_labels( 'sp_performance' );
if ( $performance_labels && is_array( $performance_labels ) && sizeof( $performance_labels ) ) {
$this->columns = array_merge( $this->columns, $performance_labels );
}
}
/**
* import function.
*
* @access public
* @param array $array
* @param array $columns
* @return void
*/
function import( $array = array(), $columns = array( 'sp_player' ) ) {
$this->imported = $this->skipped = 0;
if ( ! is_array( $array ) || ! sizeof( $array ) ) :
$this->footer();
die();
endif;
$rows = array_chunk( $array, sizeof( $columns ) );
// Get event ID and team ID from post vars
$event = ( empty( $_POST['sp_event'] ) ? false : sanitize_text_field( wp_unslash( $_POST['sp_event'] ) ) );
$teams = ( empty( $_POST['sp_teams'] ) ? false : sanitize_text_field( wp_unslash( $_POST['sp_teams'] ) ) );
$index = ( empty( $_POST['sp_index'] ) ? false : sanitize_text_field( wp_unslash( $_POST['sp_index'] ) ) );
$team = ( empty( $_POST['sp_team'] ) ? false : sanitize_text_field( wp_unslash( $_POST['sp_team'] ) ) );
$team_players = array( 0 );
$team_performance = array();
$name_index = (int) array_search( 'sp_player', $columns );
foreach ( $rows as $row ) :
$row = array_filter( $row );
if ( empty( $row ) ) {
continue;
}
$player_name = sp_array_value( $row, $name_index );
if ( ! $player_name ) :
$this->skipped ++;
continue;
endif;
$player_object = get_page_by_title( stripslashes( $player_name ), OBJECT, 'sp_player' );
if ( $player_object ) :
// Get player ID
$player_id = $player_object->ID;
else :
// Insert player
$player_id = wp_insert_post(
array(
'post_type' => 'sp_player',
'post_status' => 'publish',
'post_title' => wp_strip_all_tags( $player_name ),
)
);
// Flag as import
update_post_meta( $player_id, '_sp_import', 1 );
endif;
$team_players[] = $player_id;
$player = array();
foreach ( $columns as $i => $key ) :
if ( 'sp_player' === $key ) {
continue;
}
// Get performance object.
$perf_column = get_page_by_path( $key, OBJECT, 'sp_performance' );
// Check if it has time format and convert it to seconds.
if ( is_object( $perf_column ) && 'time' == get_post_meta( $perf_column->ID, 'sp_format', true ) ) {
$player[ $key ] = sp_value_time( sp_array_value( $row, $i, '0' ) );
}else{
$player[ $key ] = sp_array_value( $row, $i, '' );
}
endforeach;
$team_performance[ $player_id ] = $player;
endforeach;
if ( $event && $team ) :
$the_players = get_post_meta( $event, 'sp_player', false );
$players = array();
for ( $i = 0; $i < $teams; $i++ ) :
if ( $index == $i ) :
array_push( $players, $team_players );
else :
array_push( $players, sp_array_between( $the_players, 0, $i ) );
endif;
endfor;
sp_update_post_meta_recursive( $event, 'sp_player', $players );
$this->imported = sizeof( $team_players ) - 1;
$performance = (array) get_post_meta( $event, 'sp_players', true );
$performance = array_filter( $performance );
$performance[ $team ] = $team_performance;
update_post_meta( $event, 'sp_players', $performance );
endif;
// Show Result
echo '<div class="updated settings-error below-h2"><p>
' . wp_kses_post( sprintf( __( 'Import complete - imported <strong>%1$s</strong> rows and skipped <strong>%2$s</strong>.', 'sportspress' ), esc_html( $this->imported ), esc_html( $this->skipped ) ) ) . '
</p></div>';
$this->import_end( $event );
}
/**
* Performs post-import cleanup of files and the cache
*/
function import_end( $event = 0 ) {
echo '<p>' . esc_html__( 'All done!', 'sportspress' ) . ' <a href="' . esc_url( admin_url(
add_query_arg(
array(
'post' => $event,
'action' => 'edit',
),
'post.php'
)
) ) . '">' . esc_html__( 'View Event', 'sportspress' ) . '</a>' . '</p>';
do_action( 'import_end' );
}
/**
* greet function.
*
* @access public
* @return void
*/
function greet() {
$event = sp_array_value( $_REQUEST, 'event', 0 );
echo '<div class="narrow">';
if ( $event ) {
$args = array_merge(
$_REQUEST,
array(
'import' => 'sp_event_performance_csv',
'step' => '1',
)
);
echo '<p>' . esc_html__( 'Hi there! Choose a .csv file to upload, then click "Upload file and import".', 'sportspress' ) . '</p>';
echo '<p>' . wp_kses_post( sprintf( __( 'Box scores need to be defined with columns in a specific order. <a href="%s">Click here to download a sample</a>.', 'sportspress' ), esc_url( plugin_dir_url( SP_PLUGIN_FILE ) ) . 'dummy-data/event-performance-sample.csv' ) ) . '</p>';
wp_import_upload_form( add_query_arg( $args, 'admin.php' ) );
} else {
echo '<p><a href="' . esc_url( admin_url( add_query_arg( array( 'post_type' => 'sp_event' ), 'edit.php' ) ) ) . '">' . sprintf( esc_html__( 'Select %s', 'sportspress' ), esc_html__( 'Event', 'sportspress' ) ) . '</a></p>';
}
echo '</div>';
}
/**
* options function.
*
* @access public
* @return void
*/
function options() {
$event = sp_array_value( $_REQUEST, 'event', 0, 'key' );
$teams = sp_array_value( $_REQUEST, 'teams', 0, 'key' );
$index = sp_array_value( $_REQUEST, 'index', 0, 'key' );
$team = sp_array_value( $_REQUEST, 'team', 0, 'key' );
$include = get_post_meta( $event, 'sp_team', false );
?>
<table class="form-table">
<tbody>
<tr>
<th scope="row"><label><?php esc_html_e( 'Event', 'sportspress' ); ?></label><br/></th>
<td>
<a href="<?php echo esc_url( get_post_permalink( $event ) ); ?>" target="_blank">
<?php echo esc_html( get_the_title( $event ) ); ?>
</a>
<input type="hidden" name="sp_event" value="<?php echo esc_attr( $event ); ?>">
<input type="hidden" name="sp_teams" value="<?php echo esc_attr( $teams ); ?>">
<input type="hidden" name="sp_index" value="<?php echo esc_attr( $index ); ?>">
</td>
</tr>
<tr>
<th scope="row"><label><?php esc_html_e( 'Team', 'sportspress' ); ?></label><br/></th>
<td>
<?php
$args = array(
'post_type' => 'sp_team',
'name' => 'sp_team',
'values' => 'ID',
'selected' => $team,
'include' => $include,
);
sp_dropdown_pages( $args );
?>
</td>
</tr>
</tbody>
</table>
<?php
}
}
}