addDataParam('i', $vendor_id); if ($upc) { $dataParams->addDataParam('i', $upc); } $sql = 'SELECT COUNT(tr.track_restriction_id) AS total_count FROM track_restriction tr INNER JOIN releases r ON tr.upc = r.upc INNER JOIN artist_info a ON a.artist_id = r.artist_id WHERE tr.restriction_type = "territory" AND r.not_for_distribution != "SMEAnalyticsDummy" AND a.vendor_id = ? ' . ($upc ? ' AND r.upc = ?' : ''); $country_count = $wrapperObj->executeQuery($sql, $dataParams); if ($country_count === false) showierror($sql); $country_count_row = $country_count[0]; $total_territory_carveouts = $country_count_row['total_count']; $sql = 'SELECT COUNT(tr.track_restriction_id) AS total_count FROM track_restriction tr INNER JOIN releases r ON tr.upc = r.upc INNER JOIN artist_info a ON a.artist_id = r.artist_id WHERE tr.restriction_type = "carveout" AND r.not_for_distribution != "SMEAnalyticsDummy" AND a.vendor_id = ? ' . ($upc ? ' AND r.upc = ?' : ''); $dms_count = $wrapperObj->executeQuery($sql, $dataParams); if ($dms_count === false) showierror($sql); $dms_count_row = $dms_count[0]; $total_dms_carveouts = $dms_count_row['total_count']; $sql = 'SELECT COUNT(tr.track_restriction_id) AS total_count FROM track_restriction tr INNER JOIN releases r ON tr.upc = r.upc INNER JOIN artist_info a ON a.artist_id = r.artist_id WHERE tr.restriction_type = "master_carveout" AND r.not_for_distribution != "SMEAnalyticsDummy" AND a.vendor_id = ? ' . ($upc ? ' AND r.upc = ?' : ''); $dms_master_count = $wrapperObj->executeQuery($sql, $dataParams); if ($dms_master_count === false) showierror($sql); $dms_master_count_row = $dms_master_count[0]; $total_master_carveouts = $dms_master_count_row['total_count']; $tr_restr_query = "SELECT t.id, t.track_id, t.cd, t.isrc, t.track_name, r.release_name, a.name AS artist_name, a.artist_id, r.upc FROM artist_info a INNER JOIN releases r ON a.artist_id = r.artist_id INNER JOIN track t ON t.upc = r.upc INNER JOIN track_restriction tr ON tr.upc = t.upc AND tr.cd = t.cd AND tr.track_id = t.track_id WHERE a.vendor_id = ? AND r.not_for_distribution != 'SMEAnalyticsDummy' " . ($upc ? ' AND r.upc = ?' : '') . " GROUP BY t.id"; switch ($sort_by) { case 'isrc': $order_by = 't.isrc'; break; case 'artist_name': $order_by = 'a.name'; break; case 'release_name': $order_by = 'r.release_name'; break; case 'track_name': $order_by = 't.track_name'; break; default: $order_by = 'a.name'; } $tr_restr_query .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); $tr_restr_result = $wrapperObj->executeQuery($tr_restr_query, $dataParams); if ($tr_restr_result === false) showierror($tr_restr_query); $total = count($tr_restr_result); $pageNum = ceil($total/$pageRecord); $page = $page > $pageNum ? $pageNum : $page; if ($viewall) { if ($total) { echo paginate($page, $pageRecord, $pageNum, $varQueryString); } } ?>

Track Carveouts

Add/Edit Carveout

0) { ?>

Territory Carveouts:
DMS Carveouts:
DMS Master Carveouts:
View All

addDataParam('i', $tr_restr_row['upc']); $dataParams->addDataParam('i', $tr_restr_row['cd']); $dataParams->addDataParam('i', $tr_restr_row['track_id']); $sql = 'SELECT c.name AS country FROM track_restriction tr INNER JOIN country c ON c.id = tr.territory_or_dms_id WHERE tr.restriction_type = "territory" AND tr.upc = ? AND tr.cd = ? AND tr.track_id = ?'; $terr_results = $wrapperObj->executeQuery($sql, $dataParams); if ($terr_results === false) { showierror($sql); } $country = array(); $CountryName = ''; foreach ($terr_results as $terr_row) $country[] = $terr_row['country']; $CountryName = implode(', ', $country); $sql = 'SELECT cm.name AS dms_name FROM track_restriction tr INNER JOIN customer_master cm ON cm.customer_id = tr.territory_or_dms_id WHERE tr.restriction_type = "carveout" AND tr.upc = ? AND tr.cd = ? AND tr.track_id = ?'; $dms_results = $wrapperObj->executeQuery($sql, $dataParams); if ($dms_results === false) { showierror($sql); } $dms = array(); $DMSName = ''; foreach ($dms_results as $dms_row) $dms[] = $dms_row['dms_name']; $DMSName = implode(', ', $dms); $sql = 'SELECT cmm.customer_name AS dms_master FROM track_restriction tr INNER JOIN customer_master_master cmm ON cmm.customer_master_master_id = tr.territory_or_dms_id WHERE tr.restriction_type = "master_carveout" AND tr.upc = ? AND tr.cd = ? AND tr.track_id = ?'; $dms_master_results = $wrapperObj->executeQuery($sql, $dataParams); if ($dms_master_results === false) showierror($sql); $dms_master = array(); $DMSMasterName = ''; foreach ($dms_master_results as $dms_master_row) $dms_master[] = $dms_master_row['dms_master']; $DMSMasterName = implode(', ', $dms_master); ?>

				DMS Master Carveouts	DMS Carveouts	Territory Carveouts
Track Name	ISRC	Artist Name	Release Name	DMS Master Carveouts	DMS Carveouts	Territory Carveouts
				50 ? trim(substr($DMSMasterName, 0, 50), ', ') . '...' : $DMSMasterName)?>	50 ? trim(substr($DMSName, 0, 50), ', ') . '...' : $DMSName)?>	50 ? trim(substr($CountryName, 0, 50), ', ') . '...' : $CountryName)?>

No carveouts found.