// SPDX-FileCopyrightText: 2021 Harald Eilertsen // // SPDX-License-Identifier: AGPL-3.0-or-later /* * code used for giglogadmin for the open page where everyone sees the list of * concerts. First function displays filters by city, venue and the second one * builds the table with concerts */ function giglogadmin_getfilters() { global $wpdb; //echo (var_dump($_POST["selectvenue"])); $results = $wpdb->get_results('select distinct wpgvenue_city from wpg_venues'); $select = '

'; $select .= 'wpgvenue_city . '"'; if (isset($_POST["selectcity"]) && $_POST["selectcity"] == $row->wpgvenue_city) { $select .= ' selected = "selected"'; } $select .= ' >' . $row->wpgvenue_city . ''; } if (isset($_POST["selectcity"]) && $_POST["selectcity"] != "ALL") { $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 .= 'id . '"'; if (isset($_POST["selectvenue"]) && $_POST["selectvenue"] == $rowv->id) { $select .= ' selected = "selected"'; } $select .= ' >' . $rowv->wpgvenue_name . ''; } //end IF that checks if city was selected } $select .= '

'; return $select; } function giglogadmin_getconcerts() { global $wpdb; // Shortcodes RETURN content, so store in a variable to return $content = ''; // $content .= ''; $content .= ''; // 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'); //echo($_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 FROM wpg_concerts wpgc, wpg_bands wpgb, wpg_venues wpgv where wpgc.band=wpgb.id and wpgc.venue = wpgv.id and wpgconcert_date >= CURDATE()"; $query .= ($cty == "ALL") ? "" : " and wpgv.wpgvenue_city='" . $cty . "'"; $query .= ($venue == "0") ? "" : " and wpgv.id='" . $venue . "'"; $query .= " order by wpgv.wpgvenue_city, wpgconcert_date, wpgc.id"; //echo($query); $results = $wpdb->get_results($query); $lastType = ''; foreach ($results AS $row) { $content .= ''; if ($lastType != '' && $lastType != $row->wpgvenue_city) { $content .= ''; } if ($lastType == '') { $content .= ''; } // Modify these to match the database structure // $content .= ''; $content .= ''; $content .= ''; $content .= ''; $fdate = strtotime($row->wpgconcert_date); $newformat = date('d.M.Y', $fdate); //$content .= DATE_FORMAT($fdate,'%d.%b.%Y'); $content .= ''; $content .= ''; $content .= ''; $content .= ''; $lastType = $row->wpgvenue_city; } $content .= '

CITY	ID	BAND	VENUE	DATE	TICKETS	EVENT
CITY	BAND	VENUE	DATE	TICKETS	EVENT
' . $row->wpgvenue_city . '
' . $row->wpgvenue_city . '
' . $row->id. '		' . $row->band . '	' . $row->venue . '	' . $newformat . '	Tickets	Event link

'; // return the table return $content; }