/** @see WP_Widget::widget */
function widget($args, $instance)
{
extract($args);
$title = apply_filters('widget_title', $instance['title']);
?>
<?php
echo $before_widget;
?>
<?php
if ($title) {
echo $before_title . $title . $after_title;
}
?>
<?php
$artists = WT_Artist::all();
echo "<ul>";
foreach ($artists as $artist) {
echo "<li><strong><a href='" . wt_get_permalink("artist", $artist["artist_id"], array("%name%" => $artist["artist_name"])) . "'>" . $artist["artist_name"] . "</a></strong></li>";
}
echo "</ul>";
?>
<?php
echo $after_widget;
?>
<?php
}
function get_artist_field()
{
echo '<select id="wt-sc-artist" name="artist" size="7" style="height:auto;width:100%;" MULTIPLE="true" >
<option value="" selected="true">All Artists</option>';
$artists = WT_Artist::all();
foreach ($artists as $artist) {
echo "<option value=" . $artist["artist_id"] . ">" . $artist["artist_name"] . "</option>";
}
echo '</select>';
}
function render_edit_rows_page(&$event_id, &$page)
{
global $wpdb, $wt_msg;
$dbQuery = array("all" => "SELECT count(*) FROM " . WORDTOUR_EVENTS . " AS e", "published" => "SELECT count(*) FROM " . WORDTOUR_EVENTS . " AS e WHERE e.event_published = 1", "upcoming" => "SELECT count(*) FROM " . WORDTOUR_EVENTS . " AS e WHERE e.event_published = 1 AND e.event_start_date >= CURDATE()", "archive" => "SELECT count(*) FROM " . WORDTOUR_EVENTS . " AS e WHERE e.event_published = 1 AND e.event_start_date < CURDATE()", "unpublished" => "SELECT count(*) FROM " . WORDTOUR_EVENTS . " AS e WHERE e.event_published = 0", "artists" => WT_Artist::all(), "tour" => WT_Tour::all(), "status" => get_all_status(), "venues" => WT_Venue::all(), "date" => $wpdb->get_results("SELECT \n\t\t\t\t\t\t\t\t\t\t DISTINCT YEAR(event_start_date) AS year,\n\t\t\t\t\t\t\t\t\t\t MONTH(event_start_date) AS month, \n\t\t\t\t\t\t\t\t\t\t MONTHNAME(event_start_date) AS month_name \n\t\t\t\t\t\t\t\t\t\t FROM " . WORDTOUR_EVENTS . " WHERE event_published = 1 ORDER BY event_start_date DESC", "ARRAY_A"));
# GENERATE LIST
$list = new WT_List();
$list->set_columns('events', array('event_check' => '', 'event_id' => 'ID', 'event_date' => 'Date', 'event_location' => 'Location', 'event_status' => 'Status', 'artist' => 'Artist', 'artists' => 'Additional Artists', 'tour' => 'Tour', 'extra_info' => ' '));
$list->get_results("SELECT SQL_CALC_FOUND_ROWS * \n\t\tFROM " . WORDTOUR_EVENTS . " AS e LEFT JOIN " . WORDTOUR_VENUES . " AS v \n\t\tON e.event_venue_id = v.venue_id \n\t\tLEFT JOIN " . WORDTOUR_EVENTS_META . " AS m \n\t\tON e.event_meta_id = m.meta_id\n\t\tLEFT JOIN " . WORDTOUR_ARTISTS . " AS a\n\t\tON e.event_artist_id = a.artist_id\n\t\tLEFT JOIN " . WORDTOUR_TOUR . " AS t\n\t\tON e.event_tour_id = t.tour_id \n\t\t " . get_query_mode_sql() . " \n\t\tORDER BY e.event_start_date DESC,e.id,e.event_is_headline", $_GET['paged']);
global $_wt_options;
?>
<div class="wrap">
<h2>Events</h2>
</div>
<ul class="subsubsub" style='float:none;'>
<?php
link_query_html("all", "All", admin_url("admin.php?page={$page}"), "event_date", $dbQuery["all"], 0);
link_query_html("published", "Published", admin_url("admin.php?page={$page}"), "event_date", $dbQuery["published"], 1);
link_query_html("upcoming", "Upcoming", admin_url("admin.php?page={$page}"), "event_date", $dbQuery["upcoming"], 0);
link_query_html("archive", "Archive", admin_url("admin.php?page={$page}"), "event_date", $dbQuery["archive"], 0);
link_query_html("unpublished", "Unpublished", admin_url("admin.php?page={$page}"), "event_date", $dbQuery["unpublished"], 0, 0);
?>
</ul>
<form method="get" action="<?php
echo admin_url("admin.php?page={$page}");
?>
">
<input type="hidden" name="page" value="<?php
echo $page;
?>
"></input>
<input type="hidden" name="event_date" value="<?php
echo $_GET["event_date"];
?>
"></input>
<select name="date">
<option value="">Show All Dates</option>
<?php
foreach ($dbQuery["date"] as $date) {
echo "<option " . ($date["year"] . $date["month"] == $_GET["date"] ? "selected" : "") . " value=\"" . $date["year"] . $date["month"] . "\">" . $date["month_name"] . " " . $date["year"] . "</option>";
}
?>
</select>
<?php
echo generate_select_html('', 'venue', array_associate_val_to_key($dbQuery["venues"], "venue_id", "venue_name"), $_GET["venue"], array("value" => "", "text" => "Show All Venues"));
echo generate_select_html('', 'status', $dbQuery["status"], $_GET["status"], array("value" => "", "text" => "Show All Status"));
echo generate_select_html('', 'artist', array_associate_val_to_key($dbQuery["artists"], "artist_id", "artist_name"), $_GET["artist"], array("value" => "", "text" => "Show All Artists"));
echo generate_select_html('', 'tour', array_associate_val_to_key($dbQuery["tour"], "tour_id", "tour_name"), $_GET["tour"], array("value" => "", "text" => "Show All Tour"));
?>
<input class="button-secondary" type="submit" value="Filter"/>
</form>
<div style="margin-right:15px;margin-bottom:15px;margin-top:15px;">
<div class="wordtour-alert wordtour-alert-error" style="margin-left:0px;margin-right:0px;"></div>
<div class="wordtour-toolbar ui-corner-all" style="margin-left:0px;margin-right:0px;overflow:hidden;">
<div class="ui-helper-clearfix">
<div title="Add New Event" id="wordtour-button-add"></div>
<div title="Delete Event" id="wordtour-button-delete"></div>
<div class="navigation tablenav">
<?php
if ($list->is_paging()) {
?>
<div class="tablenav-pages">
<?php
$list->render_paging();
?>
</div>
<?php
}
?>
</div>
</div>
</div>
<?php
$list->render("events-list", "event_rows");
}
include 'track.php';
exit;
}
}
function get_query_mode_sql()
{
$sql = array();
if (!empty($_GET["artist"])) {
$sql[] = "track_artist_id = {$_GET['artist']}";
}
if (count($sql) > 0) {
return " WHERE " . implode(" AND ", $sql);
}
return "";
}
$dbQuery = array("artists" => WT_Artist::all());
# GENERATE LIST
$list = new WT_List();
$list->set_columns('events', array('cb' => '', 'album_id-col' => 'ID', 'album_title-col' => 'Title', 'album_artist' => 'Artist', 'album_label' => 'Label'));
# GENERATE LIST
$list = new WT_List();
$list->set_columns('events', array('cb' => '', 'track_id-col' => 'ID', 'track_title-col' => 'Title', 'track_albums' => 'Albums', 'track_artist' => 'Artist', 'track_label' => 'Label'));
$list->get_results("SELECT SQL_CALC_FOUND_ROWS * FROM " . WORDTOUR_TRACKS . " as t LEFT JOIN " . WORDTOUR_ARTISTS . " as a ON a.artist_id = t.track_artist_id " . get_query_mode_sql() . " ORDER BY t.track_title ASC", $_GET['paged']);
?>
<div class="wrap">
<h2>Tracks</h2>
</div>
<form method="get" action="<?php
echo admin_url("admin.php");
}
if (!empty($venue["venue_state"])) {
$address[] = $venue["venue_state"];
}
if (!empty($venue["venue_country"])) {
$address[] = $venue["venue_country"];
}
echo "<a class='ui-selectee' href='#'><strong>{$venue['venue_name']}</strong><br/><small>" . implode(",", $address) . "</small></a>";
}
?>
</div>
<?php
}
if ($_GET["page"] == "all_artists") {
$artists = WT_Artist::all();
$artistObj = new WT_Artist();
?>
<div class="wordtour-selectable">
<?php
foreach ($artists as $value) {
$artist = $artistObj->db_out($value);
echo "<a class='ui-selectee' href='#'><strong>{$artist['artist_name']}</strong></a>";
}
?>
</div>
<?php
}
if ($_GET["page"] == "all_tour") {
function wt_group_artists_tour_json()
{
global $wpdb;
$json = array();
$artists = WT_Artist::all();
foreach ($artists as $artist) {
$artist_id = $artist["artist_id"];
$artist_name = $artist["artist_name"];
$tours = $wpdb->get_results($wpdb->prepare(WT_Event::sql_all_tables("tour_id as id,tour_name as name", array("meta" => 0, "venue" => 0, "artists" => 0, "tour" => 1)) . " AND e.event_artist_id={$artist_id} GROUP BY e.event_tour_id ASC"), "ARRAY_A");
$json[] = array("artist" => array("id" => $artist_id, "name" => $artist_name), "tour" => $tours);
}
return json_encode($json);
}
