summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--includes/admin/views/giglog_admin_page.php205
-rw-r--r--includes/venue.php10
2 files changed, 213 insertions, 2 deletions
diff --git a/includes/admin/views/giglog_admin_page.php b/includes/admin/views/giglog_admin_page.php
index 9f9786c..ec397f4 100644
--- a/includes/admin/views/giglog_admin_page.php
+++ b/includes/admin/views/giglog_admin_page.php
@@ -17,16 +17,217 @@
*/
if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) {
+ require_once __DIR__ . '/../../venue.php';
+
class GiglogAdmin_AdminPage {
static function render_html() {
?>
<div class="wrap">
<h1>Giglog Admin</h1>
- <p><?php echo giglogadmin_getfiltersphotog(); ?></p>
- <p><?php echo giglogadmin_getconcertsphotog(); ?></p>
+
+ <p>The available slots are marked with the green checkbox.
+ If you click on it, it will be assigned to you and if you no longer
+ wish to cover that concert, click on the red icon and you will be
+ unassigned. A mail should be sent to the admin when this happens,
+ but in order for the accreditation request to be sent, you have to
+ mail live@eternal-terror.com with the template containing concert
+ information. There might be some exceptions, but those are discussed
+ case by case. So whenever you want a concert, assign yourself and send
+ the template no later than 3 weeks before the concert.</p>
+
+ <p>Admin will try to keep the concert status updated so that you know
+ what the accreditation status is. You will get personal message if this
+ is really close to the concert date.</p>
+
+ <p><?php echo GiglogAdmin_AdminPage::get_filters() ?></p>
+ <p><?php echo GiglogAdmin_AdminPage::get_concerts() ?></p>
</div>
<?php
}
+
+ static function get_filters()
+ {
+ global $wpdb;
+
+ //echo (var_dump($_POST["selectvenue"]));
+
+ $results = $wpdb->get_results('select distinct wpgvenue_city from wpg_venues');
+ $select= '<form method="POST" action=""><select name="selectcity">';
+ $select.='<option value="ALL" ';
+ if(isset($_POST["selectcity"]) && $_POST["selectcity"] == "ALL")
+ { $select.= ' selected = "selected"';}
+ $select.='> All cities</option>';
+ foreach ( $results AS $row )
+ {
+ $select.='<option value="'.$row->wpgvenue_city.'"';
+ if(isset($_POST["selectcity"]) && $_POST["selectcity"] == $row->wpgvenue_city)
+ { $select.= ' selected = "selected"';}
+ $select.=' >'. $row->wpgvenue_city.'</option>';
+ }
+
+ if(isset($_POST["selectcity"]) && $_POST["selectcity"] != "ALL")
+ {
+ $select.='</select>';
+ //second drop down for venue
+
+ $vquery = "select id, wpgvenue_name from wpg_venues";
+ $vquery.= " where wpgvenue_city='".$_POST["selectcity"]."'";
+ $resultsv = $wpdb->get_results($vquery);
+ $select.= '<select name="selectvenue">';
+ $select.='<option value="0" ';
+ if(isset($_POST["selectvenue"]) && $_POST["selectvenue"] == "0")
+ { $select.= ' selected = "selected"';}
+ $select.='> All venues</option>';
+
+ foreach ( $resultsv AS $rowv )
+ {
+ $select.='<option value="'.$rowv->id.'"';
+ if(isset($_POST["selectvenue"]) && $_POST["selectvenue"] == $rowv->id)
+ { $select.= ' selected = "selected"';}
+ $select.=' >'. $rowv->wpgvenue_name.'</option>';
+ }
+ //end IF that checks if city was selected
+ }
+ $select.='</select><input type="submit" value="Filter"></form>';
+ return $select;
+ }
+
+ static function get_concerts()
+ {
+ $hf_user = wp_get_current_user();
+ $hf_username = $hf_user->user_login;
+ $roles = ( array ) $hf_user->roles;
+ global $wpdb;
+
+ $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>BAND</th><th>VENUE</th><th>DATE</th><th> </th>
+ <th>PHOTO1</th><th>PHOTO2</th><th>TEXT1</th><th>TEXT2</th>
+ <th>STATUS</th></tr>';
+
+ // Use the submitted "city" if any. Otherwise, use the default/static value.
+ $cty = filter_input( INPUT_POST, 'selectcity' );
+ $cty = $cty ? $cty: 'ALL';
+
+ $venue = filter_input( INPUT_POST, 'selectvenue' );
+ $venue = $venue ? $venue : '0';
+
+
+ $query = "SELECT wpgc.id, wpgb.wpgband_name as band, wpgv.wpgvenue_name as venue, wpgc.wpgconcert_date, wpgc.wpgconcert_tickets, wpgc.wpgconcert_event, wpgv.wpgvenue_city, wpgv.wpgvenue_webpage, wpgps.wpgs_name
+ FROM wpg_concerts wpgc, wpg_bands wpgb, wpg_venues wpgv, wpg_pressstatus wpgps, wpg_concertlogs wpgcl
+ where wpgc.band=wpgb.id
+ and wpgc.venue = wpgv.id
+ and wpgconcert_date >= CURDATE()
+ and wpgps.id = wpgcl.wpgcl_status
+ and wpgcl.wpgcl_concertid=wpgc.id";
+
+ $query .= ($cty == "ALL") ? "" : " and wpgv.wpgvenue_city='" .$cty ."'";
+ $query .= ($venue == "0") ? "" : " and wpgv.id='" .$venue ."'";
+ $query .=" order by wpgv.wpgvenue_city, wpgconcert_date" ;
+ $results = $wpdb->get_results($query);
+
+ $lastType = '';
+ foreach ( $results AS $row ) {
+ $content .= '<tr class="assignitr">';
+
+ if($lastType != '' && $lastType != $row->wpgvenue_city) {
+ $content .= '<td>'.$row->wpgvenue_city.'</td></tr><tr>';
+ }
+
+ if ($lastType == '' ) {
+ $content .= '<td>'.$row->wpgvenue_city.'</td></tr><tr>';
+ }
+ // Modify these to match the database structure
+ // $content .= '<td>' . $row->id. '</td>';
+ $content .= '<td></td>';
+ $content .= '<td>' . $row->band. '</td>';
+ $content .= '<td>' . $row->venue. '</td>';
+ $fdate = strtotime($row->wpgconcert_date);
+ $newformat = date('d.M.Y',$fdate);
+
+ //$content .= DATE_FORMAT($fdate,'%d.%b.%Y');
+ $content .= '<td>' .$newformat. '</td>';
+ $content .= '<td></td>'; //.giglogadmin_getpublishstatus($row->id ).'</td>';
+ $content .= '<td>'.giglogadmin_returnuser('photo1', $row->id ).'</td>';
+ $content .= '<td>'.giglogadmin_returnuser('photo2', $row->id ).'</td>';
+ $content .= '<td>'.giglogadmin_returnuser('rev1', $row->id ).'</td>';
+ $content .= '<td>'.giglogadmin_returnuser('rev2', $row->id ).'</td>';
+ $content .= '<td class="adminbuttons">'.$row -> wpgs_name;
+ if (current_user_can('administrator')) //($hf_username == 'etadmin')
+ $content .= '<span><form method="POST" action=""> <input type="hidden" name="cid" value="' . $row->id. '" /><input type="submit" name="reqsent" value="REQSENT"/><input type="submit" name="phok" value="PHOK"/><input type="submit" name="txtok" value="TXOK"/><input type="submit" name="allok" value="ALLOK"/><input type="submit" name="rej" value="REJ"/>
+ </form></span>';
+ $content .= '</td>';
+ $content .= '</tr>';
+ $lastType = $row->wpgvenue_city;
+ }
+ $content .= '</table>';
+
+ if(isset($_POST['assignitem']))
+ {
+ echo (giglogadmin_assignconcert($_POST['pid'],$_POST['cid']));
+
+ $url2=$_SERVER['REQUEST_URI'];
+ header("Refresh: 1; URL=$url2"); //reload page
+ }
+
+ if(isset($_POST['unassignitem']))
+ {
+ echo (giglogadmin_unassignconcert($_POST['pid'],$_POST['cid']));
+
+ $url3=$_SERVER['REQUEST_URI'];
+ header("Refresh: 1; URL=$url3"); //reload page
+ }
+
+ if(isset($_POST['reqsent']))
+ {
+ echo (giglogadmin_assignconcert($_POST['pid'],$_POST['cid']));
+ $usql = "UPDATE wpg_concertlogs SET wpgcl_status=2 WHERE wpgcl_concertid=".$_POST['cid'];
+ $uresults = $wpdb->get_results($usql);
+ $url2=$_SERVER['REQUEST_URI'];
+ header("Refresh: 1; URL=$url2"); //reload page
+ }
+
+ if(isset($_POST['phok']))
+ {
+ $usql = "UPDATE wpg_concertlogs SET wpgcl_status=3 WHERE wpgcl_concertid=".$_POST['cid'];
+ $uresults = $wpdb->get_results($usql);
+
+ $url2=$_SERVER['REQUEST_URI'];
+ header("Refresh: 1; URL=$url2"); //reload page
+ }
+
+ if(isset($_POST['txtok']))
+ {
+ $usql = "UPDATE wpg_concertlogs SET wpgcl_status=4 WHERE wpgcl_concertid=".$_POST['cid'];
+ $uresults = $wpdb->get_results($usql);
+
+ $url2=$_SERVER['REQUEST_URI'];
+ header("Refresh: 1; URL=$url2"); //reload page
+ }
+
+ if(isset($_POST['allok']))
+ {
+ $usql = "UPDATE wpg_concertlogs SET wpgcl_status=5 WHERE wpgcl_concertid=".$_POST['cid'];
+ $uresults = $wpdb->get_results($usql);
+
+ $url2=$_SERVER['REQUEST_URI'];
+ header("Refresh: 1; URL=$url2"); //reload page
+ }
+
+ if(isset($_POST['rej']))
+ {
+ $usql = "UPDATE wpg_concertlogs SET wpgcl_status=6 WHERE wpgcl_concertid=".$_POST['cid'];
+ $uresults = $wpdb->get_results($usql);
+
+ $url2=$_SERVER['REQUEST_URI'];
+ header("Refresh: 1; URL=$url2"); //reload page
+ }
+
+ // return the table
+ return $content;
+ }
}
}
?>
diff --git a/includes/venue.php b/includes/venue.php
index 8edb136..de144fd 100644
--- a/includes/venue.php
+++ b/includes/venue.php
@@ -48,5 +48,15 @@ if ( !class_exists('GiglogAdmin_Venue') ) {
return array_map(function ($r) { return $r->wpgvenue_city; }, $results);
}
+
+ static function venues_in_city($city)
+ {
+ global $wpdb;
+ $q = $wpdb->prepare(
+ "select id, wpgvenue_name from wpg_venues where wpgvenue_city=?", $city);
+ $results = $wpdb->get_results($q);
+
+ return array_map(function ($r) { return [$r->id, $r->wpgvenue_name]; }, $results);
+ }
}
}