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; }