summaryrefslogtreecommitdiffstats
path: root/includes/admin/views/_concerts_table.php
diff options
context:
space:
mode:
authorAndreaChirulescu <andrea.chirulescu@gmail.com>2021-09-05 16:00:29 +0200
committerAndreaChirulescu <andrea.chirulescu@gmail.com>2021-09-05 16:00:29 +0200
commit143d4f534090f95417205b68e133978640c6d3a5 (patch)
treee32796a155ec37ed1db4f8b8a5c99481bd9b4b25 /includes/admin/views/_concerts_table.php
parentac2c4cf783e117b0c5bf3fe6d32de795382ede56 (diff)
parent20a05190275d3dce43061fad1d30f3d4847c8f1f (diff)
downloadgigologadmin-143d4f534090f95417205b68e133978640c6d3a5.tar.gz
gigologadmin-143d4f534090f95417205b68e133978640c6d3a5.tar.bz2
gigologadmin-143d4f534090f95417205b68e133978640c6d3a5.zip
Merge branch 'dev' of https://code.volse.net/wordpress/plugins/gigologadmin.git into andreaschanges
# Conflicts: # includes/admin/views/giglog_admin_page.php
Diffstat (limited to 'includes/admin/views/_concerts_table.php')
-rw-r--r--includes/admin/views/_concerts_table.php199
1 files changed, 199 insertions, 0 deletions
diff --git a/includes/admin/views/_concerts_table.php b/includes/admin/views/_concerts_table.php
new file mode 100644
index 0000000..37459a3
--- /dev/null
+++ b/includes/admin/views/_concerts_table.php
@@ -0,0 +1,199 @@
+<?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
+ {
+ 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();
+ }
+
+ 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><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 = [];
+
+ // 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;
+
+ $concerts = GiglogAdmin_Concert::find_concerts($filter);
+
+ $lastType = '';
+
+ foreach ( $concerts AS $concert ) {
+ $content .= '<tr class="assignitr">';
+
+ if ($lastType != '' && $lastType != $concert->venue()->city()) {
+ $content .= '<td>' . $concert->city() . '</td></tr><tr>';
+ }
+
+ if ($lastType == '' ) {
+ $content .= '<td>' . $concert->venue()->city() . '</td></tr><tr>';
+ }
+ // Modify these to match the database structure
+ // $content .= '<td>' . $row->id. '</td>';
+ $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>';
+ $content .= '<td>' . $this->mark_new_concert($concert) . '</td>';
+
+ $content .= '<td>' . $this->assign_role_for_user_form('photo1', $concert) . '</td>';
+ $content .= '<td>' . $this->assign_role_for_user_form('photo2', $concert) . '</td>';
+ $content .= '<td>' . $this->assign_role_for_user_form('rev1', $concert) . '</td>';
+ $content .= '<td>' . $this->assign_role_for_user_form('rev2', $concert) . '</td>';
+
+ $content .= '<td>' . self::STATUS_LABELS[$concert->status()] . '</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;
+ }
+
+ 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...");
+
+
+ if ( !empty($cty) ) {
+ //second drop down for venue
+ $select .= \EternalTerror\ViewHelpers\select_field(
+ "selectvenue",
+ array_map(
+ fn($venue) => [$venue->id(), $venue->name()],
+ GiglogAdmin_Venue::venues_in_city($cty)
+ ),
+ filter_input(INPUT_POST, 'selectvenue', FILTER_SANITIZE_SPECIAL_CHARS),
+ "Select venue...");
+ }
+ //option to select own concerts only
+ $select .= '<input class="ownconc" type="checkbox" value="1"';
+ if(isset($_POST['my_checkbox'])) $select .=' checked="checked" ';
+ $select.=' name="my_checkbox">Show own concerts only</input>';
+
+ $select .= '<input type="submit" value="APPLY"></form>';
+
+ return $select;
+ }
+
+ 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>';
+ }
+
+ /**
+ * 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="Your"/>'
+ . '</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;
+ }
+ }
+}