public function get_attachments($id = 0, $target_type = "", $type = "")
{
$id = $id ? $id : $this->id;
if ($id && !empty($target_type)) {
$attachments = new WT_Attachment();
$result = $attachments->query("attachment_target={$target_type}&attachment_target_id={$id}&attachment_type={$type}");
if ($result) {
return $result;
}
}
return array();
}
function get_track_row_html($row)
{
global $wpdb, $_wt_options;
$row = (array) $row;
$track_id = $row["track_id"];
$track_title = $row["track_title"];
$track_label = $row["track_label"];
$artist = new WT_Artist();
$artist = $artist->db_out($row);
$artist_name = $artist["artist_name"];
$artist_id = $artist["artist_id"];
$attachment = new WT_Attachment();
$track_attached = $attachment->query("attachment_target=album&attachment_type=track&attachment_type_id={$track_id}");
//print_r($track_attached);
//echo "<br/>";
$album_attached = array();
foreach ($track_attached as $track_a) {
if (!in_array($track_a["attachment_target_id"], $album_attached)) {
$album_id = $track_a["attachment_target_id"];
$album_title = $wpdb->get_var("SELECT album_title FROM " . WORDTOUR_ALBUMS . " WHERE album_id={$album_id}");
$album_attached[] = array("id" => $album_id, "title" => $album_title);
}
}
//$num_of_albums = $wpdb->get_var("SELECT COUNT(*) FROM ".WORDTOUR_EVENTS." WHERE event_artist_id=".$row["artist_id"]);
$delete_class = "action-delete_track:track_id-{$track_id}:_nonce-" . wp_create_nonce(WT_Track::NONCE_DELETE);
$edit_class = "track_id-{$track_id}";
$edit_link = admin_url("admin.php?page=wt_tracks&action=edit&track_id=" . $row["track_id"]);
$html = "<tr>\n\t\t\t\t<th class='check-column'>";
if ($num_of_events == 0) {
$html .= "<input type='checkbox' value='{$track_id}'/>";
}
$html .= "</th>\n\t\t\t\t<td>{$track_id}</td>\n\t\t\t\t<td>\n\t\t\t\t\t<strong><a title='Edit' href='{$edit_link}' class='row-title'>{$track_title}</a></strong>\n\t\t\t\t\t<br>\n\t\t\t\t\t<span class='quickedit'>\n\t\t\t\t\t\t<a class='{$edit_class}' title='Edit this track' href='#'>Quick Edit</a> |\n\t\t\t\t\t</span>\n\t\t\t\t\t<span>\n\t\t\t\t\t\t<a title='Edit this track' href='" . admin_url("admin.php?page=wt_tracks&action=edit&track_id=" . $row["track_id"]) . "'>Edit</a>\n\t\t\t\t\t</span>";
$html .= "| <span class='delete'>\n\t\t\t\t\t\t<a title='Delete this track' class='{$delete_class}' href='#'>Delete</a>\n\t\t\t\t\t</span>";
$html .= "</td>\n\t\t\t\t<td>";
$albums = array();
foreach ($album_attached as $album) {
$albums[] = "<a href='" . admin_url("admin.php?page=wt_albums&action=edit&album_id=" . $album["id"]) . "'>{$album['title']}</a>";
}
$html .= implode(", ", $albums);
$html .= "</td>\n\t\t\t\t<td><a href='" . admin_url("admin.php?page=wt_artists&action=edit&artist_id=" . $artist_id) . "'>{$artist_name}</a></td>\n\t\t\t\t<td>{$track_label}</td>\n\t\t\t</tr>";
return $html;
}
