summaryrefslogtreecommitdiffstats
path: root/includes/admin/views/giglog_import_gigs.php
diff options
context:
space:
mode:
Diffstat (limited to 'includes/admin/views/giglog_import_gigs.php')
-rw-r--r--includes/admin/views/giglog_import_gigs.php133
1 files changed, 0 insertions, 133 deletions
diff --git a/includes/admin/views/giglog_import_gigs.php b/includes/admin/views/giglog_import_gigs.php
deleted file mode 100644
index 758981e..0000000
--- a/includes/admin/views/giglog_import_gigs.php
+++ /dev/null
@@ -1,133 +0,0 @@
-<?php
-
-// SPDX-FileCopyrightText: 2021 Andrea Chirulescu <andrea.chirulescu@gmail.com>
-// SPDX-FileCopyrightText: 2021 Harald Eilertsen <haraldei@anduin.net>
-//
-// SPDX-License-Identifier: AGPL-3.0-or-later
-
-if ( ! class_exists( 'GiglogAdmin_ImportGigsPage' ) ) {
- require_once __DIR__ . '/../../class-giglogadmin-concert.php';
- require_once __DIR__ . '/../../class-giglogadmin-venue.php';
-
- class GiglogAdmin_ImportGigsPage {
- static function render_html(): void {
- ?>
- <div class="wrap">
- <h1>Import gigs</h1>
- <p>Import gig data from a tab separated data file.</p>
- <form action="<?php menu_page_url( 'giglog_import' ); ?>" enctype="multipart/form-data" method="post">
- <?php wp_nonce_field( plugin_basename( __FILE__ ), 'giglog_import_nonce' ); ?>
- <label for="giglog_import_file">File: </label>
- <input type="file" name="giglog_import_file" id="giglog_import_file">
- <?php submit_button(); ?>
- </form>
- </div>
- <?php
- }
-
- static function submit_form(): void {
- if ( 'POST' === $_SERVER['REQUEST_METHOD'] && current_user_can( 'upload_files' ) && ! empty( $_FILES['giglog_import_file']['tmp_name'] ) ) {
- if ( isset( $_POST['giglog_import_nonce'] ) && wp_verify_nonce( $_POST['giglog_import_nonce'], plugin_basename( __FILE__ ) ) ) {
- self::process_upload( $_FILES['giglog_import_file'] );
- } else {
- header( "{$_SERVER['SERVER_PROTOCOL']} 403 Forbidden" );
- wp_die( 'CSRF validation failed.', 403 );
- }
- }
- }
-
- /**
- * Imports concert data from a file with tab separated values.
- *
- * The file must contain the following columns each separated by _one_
- * tab character:
- *
- * 1. Concertname
- * 2. Venuename or numeric venue id
- * 3. Concert date
- * 4. Ticket link
- * 5. Event info link
- *
- * Empty lines are ignored.
- *
- * @return void
- *
- * @param array<int, mixed> $file
- */
- static function process_upload( array $file ): void {
- $fo = new SplFileObject( $file['tmp_name'] );
- $importerrors = array();
- $rid = 0;
-
- foreach ( $fo as $line ) {
- $rid++;
- $line = trim( $line );
- if ( ! empty( $line ) ) {
- try {
- self::process_line( $line );
- } catch ( Exception $e ) {
- $importerrors[] = "Error importing line {$rid}: {$e->getMessage()}";
- }
- }
- }
-
- if ( ! empty( $importerrors ) ) {
- echo implode( '<br>', $importerrors );
- } else {
- echo ( 'All rows imported ok' );
- }
- }
-
- static function process_line( string $line ) : void {
- $resultArray = explode( "\t", $line );
-
- // unsure if this is needed, considering we are also checking if
- // each individual important field is missing. But if they are not
- // replaced by tabs, then everything gets shifted so probably best
- // to check if a value is empty and NOT replaced by tab
-
- if ( count( $resultArray ) < 6 ) {
- throw new Exception( 'missing a field' );
- }
-
- if ( ! preg_match( '/\d{4}\-\d{2}-\d{2}/', $resultArray[3] ) ) {
- throw new Exception( 'invalid date: ' . esc_html( $resultArray[3] ) );
- }
-
- if ( empty( trim( $resultArray[0] ) ) ) {
- throw new Exception( 'missing concert name' );
- }
-
- if ( empty( trim( $resultArray[1] ) ) ) {
- throw new Exception( 'missing venue' );
- }
-
- if ( empty( trim( $resultArray[2] ) ) ) {
- throw new Exception( 'missing city' );
- }
-
- $condate = date( 'Y-m-d', strtotime( $resultArray[3] ) );
-
- if ( $condate < date( 'Y-m-d' ) ) {
- throw new Exception( 'has date in the past: ' . esc_html( $resultArray[3] ) );
- }
-
- $cname = trim( $resultArray[0] );
- $venue = trim( $resultArray[1] );
-
- if ( is_numeric( $venue ) ) {
- $venue = GiglogAdmin_Venue::get( intval( $venue ) );
- if ( ! $venue ) {
- throw new Exception( "invalid venue id: {$venue}" );
- }
- } else {
- $venue = GiglogAdmin_Venue::find_or_create( $venue, trim( $resultArray[2] ) );
- }
-
- $ticketlink = trim( $resultArray[4] );
- $eventlink = trim( $resultArray[5] );
-
- GiglogAdmin_Concert::create( $cname, $venue->id(), $condate, $ticketlink, $eventlink );
- }
- }
-}