addDataParam('i', $trackdown_user_id); if(isset($activity_type) && trim($activity_type)!= ''){ $query .= ' AND ta.activity_type = ?'; $dataParams->addDataParam('s', $activity_type); } switch ($sort_by){ case 'artist_name': $order_by = "a.name"; break; case 'release_name': $order_by = 'r.release_name'; break; case 'artist_id': $order_by = 'a.artist_id'; break; case 'upc': $order_by = 'r.upc'; break; case 'activity_date': $order_by = 'ta.activity_date'; break; case 'activity_type': $order_by = 'ta.activity_type'; break; case 'track_name': $order_by = 't.track_name'; break; case 'cd': $order_by = 't.cd'; break; case 'track_id': $order_by = 't.track_id'; break; case 'label': $order_by = 'r.label'; break; default: $order_by = " ta.activity_date"; $sort_by = 'activity_date'; break; } $err_msg = ""; $query .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); if (!$no_url) { $query .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } if($err_msg == "") { $result = $wrapperObj->executeQuery($query, $dataParams); if ($result === false) { showierror($query); } $sql = 'SELECT FOUND_ROWS() AS total'; $dataParams = new QueryData(); $total_count = $wrapperObj->executeQuery($sql, $dataParams); if ($total_count === false) { showierror($sql); } $total_count_row = $total_count[0]; $total = $total_count_row['total']; $pageNum = ceil($total/$pageRecord); $varTable = ""; $varTable .= ""; $i = 0; $rci = 0; if (count($result)) { $rci = 0; foreach ($result as $row) { $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ""; } $varTable .= "

".($no_url ? "Imprint Label" : sortColumnHeader('Imprint Label', 'label', $url))."	".($no_url ? "Artist ID" : sortColumnHeader('Artist ID', 'artist_id', $url))."	".($no_url ? "Artist Name" : sortColumnHeader('Artist Name', 'artist_name', $url))."	".($no_url ? "Release Name" : sortColumnHeader('Release Name', 'release_name', $url))."	".($no_url ? "Track Name" : sortColumnHeader('Track Name', 'track_name', $url))."	".($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url))."	".($no_url ? "CD" : sortColumnHeader('CD', 'cd', $url))."	".($no_url ? "Track #" : sortColumnHeader('Track #', 'track_id', $url))."	".($no_url ? "Activty Date" : sortColumnHeader('Activity Date', 'activity_date', $url))."	".($no_url ? "Activity Type" : sortColumnHeader('Activity Type', 'activity_type', $url))."
{$row['label']}	{$row['artist_id']}	".($no_url?$row['artist_name']:"{$row['artist_name']}")."	".($no_url?$row['release_name']:"{$row['release_name']}")."	{$row['track_name']}	".($no_url?'"'.$row['display_upc'].'"':$row['display_upc'])."	{$row['cd']}	{$row['track_id']}	".format_date($row['activity_date'],true)."	{$row['activity_type']}

"; } else { $varTable .= "

No catalogs found.

"; } } ?>