diff options
Diffstat (limited to 'includes/admin')
| -rw-r--r-- | includes/admin/views/giglog_admin_page.php | 95 |
1 files changed, 47 insertions, 48 deletions
diff --git a/includes/admin/views/giglog_admin_page.php b/includes/admin/views/giglog_admin_page.php index bd91299..86398bf 100644 --- a/includes/admin/views/giglog_admin_page.php +++ b/includes/admin/views/giglog_admin_page.php @@ -83,6 +83,27 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) { return $select; } + + static function adminactions() //didn't get this one to work, the point was to create the drop down menu with a function, but it works fine to create it directly in the query + { + global $wpdb; + $query = "SELECT id,wpgs_name from wpg_pressstatus" ; + $statuses = $wpdb->get_results($query); + + $select = '<form method="POST" action=""><select name="selectstatus">'; + + foreach ( $statuses AS $sts ) { + + $select .= '<option value="' . $sts . '">'; + $select .= $sts -> wpgs_name . '</option>'; + } + + $select .= '</select>'; + $select .= '<input type="submit" value="Adminstatus"></form>'; + return $select; + } + + static function get_concerts() { @@ -97,7 +118,10 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) { $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>'; + <th>STATUS</th>'; + if (current_user_can('administrator')) //($hf_username == 'etadmin') + $content .= '<th>AdminOptions</th>'; + $content .= '</tr>'; // Use the submitted "city" if any. Otherwise, use the default/static value. $cty = filter_input( INPUT_POST, 'selectcity', FILTER_SANITIZE_SPECIAL_CHARS ); @@ -146,11 +170,20 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) { $content .= '<td>'.GiglogAdmin_AdminPage::returnuser('photo2', $row->id ).'</td>'; $content .= '<td>'.GiglogAdmin_AdminPage::returnuser('rev1', $row->id ).'</td>'; $content .= '<td>'.GiglogAdmin_AdminPage::returnuser('rev2', $row->id ).'</td>'; - $content .= '<td class="adminbuttons">'.$row -> wpgs_name; + $content .= '<td>'.$row -> wpgs_name.'</td>'; 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 .= '<td class="adminbuttons">'; + $stquery = "SELECT id,wpgs_name from wpg_pressstatus" ; + $statuses = $wpdb->get_results($stquery); + $content .= '<form method="POST" action=""><input type="hidden" name="cid" value="' . $row->id. '" /><select name="selectstatus">'; + foreach ( $statuses AS $sts ) + { + $content .= '<option value="'.$sts->id. '">'.$sts -> wpgs_name .'</option>'; + } + $content .= '</select>'; + $content .= '<input type="submit" value="Set status"></form>'; + $content .= '</td>'; + } $content .= '</tr>'; $lastType = $row->wpgvenue_city; } @@ -162,7 +195,7 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) { } static function update() - { + { global $wpdb; if ('POST' !== $_SERVER['REQUEST_METHOD']) return; @@ -188,51 +221,17 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) { $url3=$_SERVER['REQUEST_URI']; header("Refresh: 1; URL=$url3"); //reload page } - - if(isset($_POST['reqsent'])) - { - GiglogAdmin_AdminPage::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'])) + + //handling the admin drop down menu + if(isset($_POST['selectstatus'])) { - $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 + $usql = "UPDATE wpg_concertlogs SET wpgcl_status=".$_POST['selectstatus']." WHERE wpgcl_concertid=".$_POST['cid']; + $uresults = $wpdb->get_results($usql); + //$url2=$_SERVER['REQUEST_URI']; //doesn't seem to be needed actually, leaving here just in case + //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 - } + } static function assignconcert($p1, $c) |