summaryrefslogtreecommitdiffstats
path: root/includes/admin/views/_concerts_table.php
diff options
context:
space:
mode:
Diffstat (limited to 'includes/admin/views/_concerts_table.php')
-rw-r--r--includes/admin/views/_concerts_table.php330
1 files changed, 165 insertions, 165 deletions
diff --git a/includes/admin/views/_concerts_table.php b/includes/admin/views/_concerts_table.php
index 1b01d75..efa55e2 100644
--- a/includes/admin/views/_concerts_table.php
+++ b/includes/admin/views/_concerts_table.php
@@ -1,129 +1,129 @@
- <?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_ConcertsTable"))
+<?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_ConcertsTable"))
+{
+ class GiglogAdmin_ConcertsTable
{
- class GiglogAdmin_ConcertsTable
- {
- const STATUS_LABELS = [
- '',
- 'Accred Requested',
- 'Photo Approved',
- 'Text Approved',
- 'Photo and Text Approved',
- 'Rejected'
- ];
-
- private string $username;
-
- public function __construct() {
- $this->username = wp_get_current_user()->user_login;
- }
+ const STATUS_LABELS = [
+ '',
+ 'Accred Requested',
+ 'Photo Approved',
+ 'Text Approved',
+ 'Photo and Text Approved',
+ 'Rejected'
+ ];
+
+ private string $username;
+
+ public function __construct() {
+ $this->username = wp_get_current_user()->user_login;
+ }
- public function render(): string
- {
- return $this->render_filters()
- . $this->render_concerts_table();
- }
+ public function render(): string
+ {
+ return $this->render_filters()
+ . $this->render_concerts_table();
+ }
- private function render_concerts_table() : string
- {
- $content = '<table class="assignit">';
- // $content .= '</tr><th>CITY</th><th>ID</th><th>BAND</th><th>VENUE</th><th>DATE</th></tr>';
+ private function render_concerts_table() : string
+ {
+ $content = '<table class="assignit">';
+ // $content .= '</tr><th>CITY</th><th>ID</th><th>BAND</th><th>VENUE</th><th>DATE</th></tr>';
- $content .= '<tr class="assignithrow"><th>CITY</th><th>NAME</th><th>VENUE</th><th>DATE</th>';
- if(!is_admin())
- $content .= '<th>EVENT</th><th>TICKETS</th>';
+ $content .= '<tr class="assignithrow"><th>CITY</th><th>NAME</th><th>VENUE</th><th>DATE</th>';
+ if(!is_admin())
+ $content .= '<th>EVENT</th><th>TICKETS</th>';
- else
- {
- $content .= '<th> </th><th>PHOTO1</th><th>PHOTO2</th><th>TEXT1</th><th>TEXT2</th><th>STATUS</th>';
- if (current_user_can('administrator'))
- $content .= '<th>AdminOptions</th>';
- }
- $content .= '</tr>';
+ else
+ {
+ $content .= '<th> </th><th>PHOTO1</th><th>PHOTO2</th><th>TEXT1</th><th>TEXT2</th><th>STATUS</th>';
+ if (current_user_can('administrator'))
+ $content .= '<th>AdminOptions</th>';
+ }
+ $content .= '</tr>';
- $filter = [];
+ $filter = [];
- // Use the submitted "city" if any. Otherwise, use the default/static value.
- $cty = filter_input( INPUT_POST, 'selectcity', FILTER_SANITIZE_SPECIAL_CHARS );
- if ($cty) $filter['city'] = $cty;
+ // Use the submitted "city" if any. Otherwise, use the default/static value.
+ $cty = filter_input( INPUT_POST, 'selectcity', FILTER_SANITIZE_SPECIAL_CHARS );
+ if ($cty) $filter['city'] = $cty;
- $venue = filter_input( INPUT_POST, 'selectvenue', FILTER_SANITIZE_SPECIAL_CHARS );
- if ($venue) $filter['venue_id'] = $venue;
+ $venue = filter_input( INPUT_POST, 'selectvenue', FILTER_SANITIZE_SPECIAL_CHARS );
+ if ($venue) $filter['venue_id'] = $venue;
- if(isset($_POST['ownconcerts']) && $_POST['ownconcerts'] == '1')
+ if(isset($_POST['ownconcerts']) && $_POST['ownconcerts'] == '1')
$filter['currentuser'] = wp_get_current_user()->user_login;
- $concerts = GiglogAdmin_Concert::find_concerts($filter);
+ $concerts = GiglogAdmin_Concert::find_concerts($filter);
- $lastType = '';
+ $lastType = '';
- foreach ( $concerts AS $concert ) {
- $content .= '<tr class="assignitr">';
+ foreach ( $concerts AS $concert ) {
+ $content .= '<tr class="assignitr">';
- if ($lastType != '' && $lastType != $concert->venue()->city()) {
- $content .= '<td>' . $concert->venue()->city() . '</td>">';
- }
+ if ($lastType != '' && $lastType != $concert->venue()->city()) {
+ $content .= '<td>' . $concert->venue()->city() . '</td>">';
+ }
- if ($lastType == '' ) {
- $content .= '<td>' . $concert->venue()->city() . '</td>';
- }
- // Modify these to match the database structure
- // $content .= '<td>' . $row->id. '</td>';
- // $content .= '<td>' . $row->id. '</td>';
- if ($lastType != '' && $lastType == $concert->venue()->city()) $content .= '<td></td>';
- $content .= '<td>'. $concert->cname() . '</td>';
- $content .= '<td>' . $concert->venue()->name() . '</td>';
- $fdate = strtotime($concert->cdate());
- $newformat = date('d.M.Y',$fdate);
-
- //$content .= DATE_FORMAT($fdate,'%d.%b.%Y');
- $content .= '<td>' . $newformat . '</td>';
- if(!is_admin()){
+ if ($lastType == '' ) {
+ $content .= '<td>' . $concert->venue()->city() . '</td>';
+ }
+ // Modify these to match the database structure
+ // $content .= '<td>' . $row->id. '</td>';
+ // $content .= '<td>' . $row->id. '</td>';
+ if ($lastType != '' && $lastType == $concert->venue()->city()) $content .= '<td></td>';
+ $content .= '<td>'. $concert->cname() . '</td>';
+ $content .= '<td>' . $concert->venue()->name() . '</td>';
+ $fdate = strtotime($concert->cdate());
+ $newformat = date('d.M.Y',$fdate);
+
+ //$content .= DATE_FORMAT($fdate,'%d.%b.%Y');
+ $content .= '<td>' . $newformat . '</td>';
+ if(!is_admin()){
$content .= '<td><a target="_blank" href="'.$concert->eventlink() .'">Link</a></td>';
$content .= '<td><a target="_blank" href="'.$concert->tickets() .'">Tickets</a></td>';
- }
- else {
- $content .= '<td class="publishstatus">' . $this->mark_new_concert($concert) . '</td>';
+ }
+ else {
+ $content .= '<td class="publishstatus">' . $this->mark_new_concert($concert) . '</td>';
- $content .= '<td class="assigneduser">' . $this->assign_role_for_user_form('photo1', $concert) . '</td>';
- $content .= '<td class="assigneduser">' . $this->assign_role_for_user_form('photo2', $concert) . '</td>';
- $content .= '<td class="assigneduser">' . $this->assign_role_for_user_form('rev1', $concert) . '</td>';
- $content .= '<td class="assigneduser">' . $this->assign_role_for_user_form('rev2', $concert) . '</td>';
+ $content .= '<td class="assigneduser">' . $this->assign_role_for_user_form('photo1', $concert) . '</td>';
+ $content .= '<td class="assigneduser">' . $this->assign_role_for_user_form('photo2', $concert) . '</td>';
+ $content .= '<td class="assigneduser">' . $this->assign_role_for_user_form('rev1', $concert) . '</td>';
+ $content .= '<td class="assigneduser">' . $this->assign_role_for_user_form('rev2', $concert) . '</td>';
- $content .= '<td>' . self::STATUS_LABELS[$concert->status()] . '</td>';
+ $content .= '<td>' . self::STATUS_LABELS[$concert->status()] . '</td>';
- if (current_user_can('administrator')) {
- $content .=
- '<td class="adminbuttons">'
- . $this->adminactions($concert)
- . '</td>';
- }
+ if (current_user_can('administrator')) {
+ $content .=
+ '<td class="adminbuttons">'
+ . $this->adminactions($concert)
+ . '</td>';
}
- $content .= '</tr>';
- $lastType = $concert->venue()->city();
}
- $content .= '</table>';
-
- // return the table
- return $content;
+ $content .= '</tr>';
+ $lastType = $concert->venue()->city();
}
+ $content .= '</table>';
- private function render_filters() : string
- {
- $cty = filter_input(INPUT_POST, 'selectcity', FILTER_SANITIZE_SPECIAL_CHARS);
+ // return the table
+ return $content;
+ }
+
+ private function render_filters() : string
+ {
+ $cty = filter_input(INPUT_POST, 'selectcity', FILTER_SANITIZE_SPECIAL_CHARS);
- $select = '<form method="POST" action="">FILTER DATA:';
- $select .= \EternalTerror\ViewHelpers\select_field(
- "selectcity",
- array_map(fn($city) => [$city, $city], GiglogAdmin_Venue::all_cities()),
- $cty,
- "Select city...");
+ $select = '<form method="POST" action="">FILTER DATA:';
+ $select .= \EternalTerror\ViewHelpers\select_field(
+ "selectcity",
+ array_map(fn($city) => [$city, $city], GiglogAdmin_Venue::all_cities()),
+ $cty,
+ "Select city...");
if ( !empty($cty) ) {
@@ -136,80 +136,80 @@
),
filter_input(INPUT_POST, 'selectvenue', FILTER_SANITIZE_SPECIAL_CHARS),
"Select venue...");
- }
- if(is_admin()) {
- //option to select own concerts only
- $select .= '<input name="ownconcerts" class="ownconc" type="checkbox" value="1"'
- . checked(isset($_POST['ownconcerts']) ? $_POST['ownconcerts'] : false)
- . '><label for="ownconcerts">Show own concerts only</label>';
- }
- $select .= '<input type="submit" value="APPLY"></form>';
+ }
+ if(is_admin()) {
+ //option to select own concerts only
+ $select .= '<input name="ownconcerts" class="ownconc" type="checkbox" value="1"'
+ . checked(isset($_POST['ownconcerts']) ? $_POST['ownconcerts'] : false)
+ . '><label for="ownconcerts">Show own concerts only</label>';
+ }
+ $select .= '<input type="submit" value="APPLY"></form>';
- return $select;
- }
+ return $select;
+ }
- private function adminactions( GiglogAdmin_Concert $concert ) : string
- {
- return
+ private function adminactions( GiglogAdmin_Concert $concert ) : string
+ {
+ return
'<form method="POST" action="">'
. '<input type="hidden" name="cid" value="' . $concert->id() . '" />'
. \EternalTerror\ViewHelpers\select_field(
'selectstatus',
array_map(fn($i) => [ $i, self::STATUS_LABELS[$i] ], range(1, count(self::STATUS_LABELS) - 1)),
$concert->status())
- . '<input type="submit" value="SetStatus">'
- . '<input type="submit" name ="edit" value="EDIT">'
- . '</form>';
- }
+ . '<input type="submit" value="SetStatus">'
+ . '<input type="submit" name ="edit" value="EDIT">'
+ . '</form>';
+ }
- /**
- * Display a mark on the concert if it is new.
- * I.e. imported/created within the last ten days.
- *
- * @return null|string
- */
- private function mark_new_concert(GiglogAdmin_Concert $concert) : string
- {
- $now = new DateTime();
- $new_entry = $now->diff($concert->created())->days <= 10;
- if ($new_entry) {
- return '<span style="color:green">NEW</span>';
- }
- else {
- return '';
- }
- }
+ /**
+ * Display a mark on the concert if it is new.
+ * I.e. imported/created within the last ten days.
+ *
+ * @return null|string
+ */
+ private function mark_new_concert(GiglogAdmin_Concert $concert) : string
+ {
+ $now = new DateTime();
+ $new_entry = $now->diff($concert->created())->days <= 10;
+ if ($new_entry) {
+ return '<span style="color:green">NEW</span>';
+ }
+ else {
+ return '';
+ }
+ }
- private function assign_role_for_user_form(string $role, GiglogAdmin_Concert $concert) : ?string
- {
- $roles = $concert->roles();
- $assigned_user = array_key_exists($role, $roles) ? $roles[$role] : NULL;
-
- //first check if current slot is taken by current user
- if ( $assigned_user == $this->username ) {
- $f = '<form class="unassignit" method="POST" action="">'
- . ' <input type="hidden" name="cid" value="' . $concert->id() . '" />'
- . ' <input type="hidden" name="pid" value="' . $role . '" />'
- . ' <input type="submit" name="unassignitem" value=""/>'
- . '</form>';
- }
- elseif ( $assigned_user ) { //check if slot is taken by another user
- $f = '<span class="takenby">Taken</span>'
- . '<div class="takenby">Taken by ' . $assigned_user . '</div>';
- }
- elseif ( array_search($this->username, $roles) ) {
- // other slots for this concert are taken by user
- $f = '<span class="taken_by_self">-</span>';
- }
- else { //not taken by anyone
- $f = '<form method="POST" action="">'
- . ' <input type="hidden" name="cid" value="' . $concert->id() . '" />'
- . ' <input type="hidden" name="pid" value="' . $role. '" />'
- . ' <input type="submit" name="assignitem" value=""/>'
- . '</form>';
- }
+ private function assign_role_for_user_form(string $role, GiglogAdmin_Concert $concert) : ?string
+ {
+ $roles = $concert->roles();
+ $assigned_user = array_key_exists($role, $roles) ? $roles[$role] : NULL;
+
+ //first check if current slot is taken by current user
+ if ( $assigned_user == $this->username ) {
+ $f = '<form class="unassignit" method="POST" action="">'
+ . ' <input type="hidden" name="cid" value="' . $concert->id() . '" />'
+ . ' <input type="hidden" name="pid" value="' . $role . '" />'
+ . ' <input type="submit" name="unassignitem" value=""/>'
+ . '</form>';
+ }
+ elseif ( $assigned_user ) { //check if slot is taken by another user
+ $f = '<span class="takenby">Taken</span>'
+ . '<div class="takenby">Taken by ' . $assigned_user . '</div>';
+ }
+ elseif ( array_search($this->username, $roles) ) {
+ // other slots for this concert are taken by user
+ $f = '<span class="taken_by_self">-</span>';
+ }
+ else { //not taken by anyone
+ $f = '<form method="POST" action="">'
+ . ' <input type="hidden" name="cid" value="' . $concert->id() . '" />'
+ . ' <input type="hidden" name="pid" value="' . $role. '" />'
+ . ' <input type="submit" name="assignitem" value=""/>'
+ . '</form>';
+ }
- return $f;
+ return $f;
+ }
+ }
}
- }
- }