1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
<?php
/*
* Copyright (C) 2021 Harald Eilertsen, Andrea Chirulescu
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
if ( !class_exists( 'GiglogAdmin_ImportGigsPage' ) ) {
require_once __DIR__ . '/../../band.php';
require_once __DIR__ . '/../../concert.php';
require_once __DIR__ . '/../../concertlogs.php';
require_once __DIR__ . '/../../venue.php';
class GiglogAdmin_ImportGigsPage {
static function render_html() {
?>
<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() {
if ('POST' === $_SERVER['REQUEST_METHOD'] && current_user_can('upload_files') && !empty($_FILES['giglog_import_file']['tmp_name'])) {
$nonce = $_POST['giglog_import_nonce'];
$valid_nonce = isset($nonce) && wp_verify_nonce($nonce);
GiglogAdmin_ImportGigsPage::process_upload($_FILES['giglog_import_file']);
}
}
/**
* Imports concert data from a file with tab separated values.
*
* The file must contain the following columns each separated by _one_
* tab character:
*
* 1. Bandname
* 2. Venuename
* 3. Concert date
* 4. Ticket link
* 5. Event info link
*
* Empty lines are ignored.
*/
static function process_upload($file) {
$newconcert= [];
$fo = new SplFileObject($file['tmp_name']);
foreach ($fo as $line) {
$line = trim( $line );
if ( empty($line) ) {
// Skip empty lines
continue;
}
$resultArray = explode("\t", $line);
$band = trim($resultArray[0]);
$venue = trim($resultArray[1]);
$condate = date('Y-m-d', strtotime($resultArray[2]));
$ticketlink = trim($resultArray[3]);
$eventlink = trim($resultArray[4]);
//first item in the row should be band $resultArray[0]; second should be venue $resultArray[1]; third should be concert date $resultArray[2];
//fourth item is ticketlink $resultArray[3]; fifth item is eventlink $resultArray[4];
$newconcert[0] = GiglogAdmin_Band::find_or_create($band);
if (is_numeric($venue))
$newconcert[1] = $venue;
else {
$newconcert[1] = GiglogAdmin_Venue::find_or_create($venue);
}
//not sure how to check dates, hopefully manual verification of files will take care of it
$cresults = GiglogAdmin_Concert::get($newconcert[0], $newconcert[1], $condate);
if ($cresults) {
error_log( 'DUPLICATE ROW detected: '
. ' BAND ' . $band . ' with band ID ' . $newconcert[0]
. ', VENUE ' . $venue . ' with venue ID ' . $newconcert[1]
. ', CONCERTDATE ' . $condate);
} else {
$id = GiglogAdmin_Concert::create(
$newconcert[0],
$newconcert[1],
$condate,
$ticketlink,
$eventlink);
error_log( 'NEW CONCERT ADDED: '
. ' ID: ' . $id
. ' BAND ' . $band . ' with band ID ' . $newconcert[0]
. ', VENUE ' . $venue . ' with venue ID ' . $newconcert[1]
. ', CONCERTDATE ' . $condate
. ', Ticket LINK ' . $ticketlink
. ', Event LINK ' . $eventlink);
GiglogAdmin_Concertlogs::add($id);
}
}
}
}
}
|
