/** @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 }
public function defaults() { global $_wt_options; parent::defaults(WORDTOUR_TRACKS); $default_artist = $_wt_options->options("default_artist"); if (!empty($default_artist) && empty($this->data["track_artist_id"])) { $id = $_wt_options->options("default_artist"); $artist = new WT_Artist($id); $data = $artist->retrieve(); if ($data) { $this->data["track_artist_id"] = $id; $this->data["artist_name"] = $data["artist_name"]; } } $this->data = array_merge($this->data, array("track_id" => "", "track_title" => "", "track_lyrics" => "", "track_genre" => array())); return $this->data; }
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>'; }
public function template($data = null, $show_poster = 0, $show_artist_poster = 0) { global $_wt_options; if (!$data) { $data = $this->data; } $db = $this->dbprepere; // get artist info $artist = new WT_Artist($data["event_artist_id"]); $artist_data = $artist->template($data); // get venue info $venue = new WT_Venue($data["event_venue_id"]); $venue_data = $venue->template($data); // get tour info if ($data["event_tour_id"] > 0) { $tour = new WT_Tour($data["event_tour_id"]); $tour_data = $tour->template($data); } $event_poster_id = $data["event_thumbnail"] ? $data["event_thumbnail"]["id"] : $this->get_thumbnail("event"); $event_poster = $db->media_out($event_poster_id); if ($data["event_on_sale"] == "0000-00-00") { $onsale = ""; } else { $onsale_date = strtotime($data["event_on_sale"]); if ($onsale_date < time()) { $onsale = ""; } else { $onsale = $data["event_on_sale"]; } } $opening = array(); $opening_array = array(); if (is_array($data["event_more_artists"])) { foreach ($data["event_more_artists"] as $a) { $opening[] = ucwords($a["name"]); $a["url"] = $db->link_out(wt_get_permalink("artist", $a["id"], array("%name%" => $a["name"]))); $opening_array[] = $a; } $opening = implode(", ", $opening); } $genre = $this->get_genre_tpl("event"); $google_map_str = wt_get_map_str($data); $tpl = array("show_comments" => $db->int_out($data["comment_status"]), "show_rsvp" => $db->int_out($data["rsvp_status"]), "show_gallery" => $db->int_out($data["gallery_status"]), "show_flickr" => $db->int_out($data["flickr_status"]), "date" => $db->date_display($data["event_start_date"]), "date_raw" => $data["event_start_date"], "genre" => implode(", ", $genre), "genre_array" => $genre, "artists" => $db->str_out($opening, 1), "artists_array" => $opening_array, "opening" => $db->str_out($data["event_opening_act"], 1), "onsale" => $onsale, "time" => $db->time_out($data["event_start_time"]), "end_date_raw" => $data["event_end_date"], "end_date" => $db->date_display($data["event_end_date"]), "end_time" => $db->time_out($data["event_end_time"]), "status" => $data["event_status"], "description" => $db->html_out($data["event_notes"]), "short_description" => $db->html_teaser_out($data["event_notes"]), "title" => $db->str_out($data["event_title"], 1), "type" => !empty($data["event_type"]) ? $db->str_out(ucwords($data["event_type"]), 1) : "", "artist" => $artist_data, "tour" => $tour_data, "venue" => $venue_data, "poster" => $event_poster, "tickets" => $db->link_out($data["tkts_url"]), "phone" => $db->str_out($data["tkts_phone"]), "admission" => $db->str_out($data["tkts_price"]), "comments" => $db->int_out($data["comment_count"]), "rsvp" => $db->int_out($data["rsvp_count"]), "url" => $db->link_out(wt_get_permalink("event", $data["event_id"], array("%date%" => $data["event_start_date"], "%name%" => $data["venue_name"]))), "machinetag" => $machinetag); return $tpl; }
public function bio($atts = null, $content = null, $code = "") { require_once WT_PLUGIN_PATH . 'admin/template.php'; require_once WT_PLUGIN_PATH . 'admin/handlers.php'; require_once WT_PLUGIN_PATH . 'dwoo/dwooAutoload.php'; $dwoo = new Dwoo(); if ($atts["artist"]) { $artist = new WT_Artist($atts["artist"]); $artist->retrieve(); if ($artist->data) { $tpl = $artist->template(); include WT_PLUGIN_PATH . 'theme/layout.renderer.php'; return $html; } } return ""; }
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");
function artists_rows($rows) { global $wpdb; if (!$rows) { ?> <tr class="empty"> <td colspan="5"><p>No Artists Found</p></td> </tr> <?php } else { ?> <?php $artist = new WT_Artist(); foreach ($rows as $row) { echo get_artist_row_html($artist->db_out($row)); } } }
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") { $tours = WT_Tour::all();
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); }
$artist->delete_all(json_decode(stripslashes($_POST["id"])), $_POST["_nonce"]); $artist->db_response("json"); } break; case "default_artist": $id = $_POST["artist_id"]; if ($id) { $artist = new WT_Artist($id); $artist->set_default(1); $artist->db_response("json"); } break; case "remove_default_artist": $id = $_POST["artist_id"]; if ($id) { $artist = new WT_Artist($id); $artist->set_default(""); $artist->db_response("json"); } break; // TOUR // TOUR case "get_tour": $tour = new WT_Tour($_POST["tour_id"]); if (!empty($_POST["tour_id"])) { $tour->retrieve(); } else { $tour->defaults(); } echo json_encode($tour->db_out(null, 0)); break;