0) ? $page : 1; $sort_by = isset($sort_by) ? stripslashes($sort_by) : 'activity_date'; $sort_desc = ($sort_desc) ? stripslashes($sort_desc) : 0; $pageRecord = (is_numeric($pageRecord) && $pageRecord>0) ? $pageRecord : 100; $varQueryString = formatURLQueryString('page,pageRecord', array($_REQUEST)); $url = formatURLQueryString('sort_by,sort_desc,page,pageRecord', array($_REQUEST)); $pageNum = 0; $total = 0; $no_url = isset($no_url) ? $no_url : false; $query = 'SELECT SQL_CALC_FOUND_ROWS ta.activity_type, ta.activity_date, ta.upc, ta.cd, ta.track_id, t.track_name, r.release_name, a.artist_id, a.name as artist_name, r.label FROM trackdown_activity ta INNER JOIN track t ON t.upc = ta.upc AND ta.cd = t.cd AND ta.track_id = t.track_id INNER JOIN releases r ON r.upc = t.upc INNER JOIN artist_info a ON a.artist_id = r.artist_id WHERE ta.trackdown_user_id = ? AND user_type="oa" AND r.not_for_distribution != "SMEAnalyticsDummy"'; $dataParams = new QueryData(); $dataParams->addDataParam('i', $orchadmin_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); } else { $query.= ''; } 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']}	{$row['upc']}	{$row['cd']}	{$row['track_id']}	".format_date($row['activity_date'],true)."	{$row['activity_type']}

"; } else { $varTable .= "

No catalogs found.

"; } } ?>