isVariant( 'oa_feature_to_primary', 'enabled', $userContext ); $isFocusTracksEnabled = $featuresServiceClient->isVariant( 'incfeatures_focus_track_oa', 'enabled', $userContext ); $isSingleFocusTracksEnabled = $featuresServiceClient->isVariant( 'incfeatures_single_focus_track_oa', 'enabled', $userContext ); $showWavTrackDownloadLink = check_user_permission(367) ? true : false; ?> addDataParam('i', $upc); $result = $wrapperObj->executeQuery($query, $data_params); if ($result === false) { showierror($query); } $product_type_id = $result[0]['product_type_id']; $not_for_distribution = $result[0]['not_for_distribution']; $isnotFilmOrTv = ($product_type_id != 3 && $product_type_id != 2) ? true : false; $trackPhysicalSelect = ''; $trackPhysicalJoin = ''; if ($isPhysical) { $trackPhysicalSelect = ', tp.side '; $trackPhysicalJoin = ' LEFT JOIN track_physical tp on tp.track_id = t.id '; } $explicit_lyrics = ($isnotFilmOrTv) ? ' t.explicit_lyrics, ' : ''; $sql = 'SELECT t.id, t.track_name, t.upc, t.cd, t.track_id, t.dmclips, t.isrc, t.length_minute, t.length_seconds, t.writer, t.credit, t.mechanical, t.royalty_collection, t.publishing_admin, t.sync_admin, t.publisher, t.publish_company, t.dpd_license, ' . $explicit_lyrics. ' t.version, t.download_price, t.p_line, t.hidden, t.offer_type, t.third_party_publisher, t.track_type, t.meta_language, tv.youtube_video_id, ft.start_date as focus_track_start_date, ft.focus_track_id, ts.isrc as spatial_isrc' . $trackPhysicalSelect . ' FROM track t LEFT JOIN track_video tv on tv.id = t.id LEFT JOIN focus_track ft on ft.unique_track_id = t.id LEFT JOIN track_additional_isrc ts on ts.track_id = t.id and ts.type = \'atmos\' and ts.deleted_at IS NULL' . $trackPhysicalJoin . ' WHERE t.upc = ? ORDER BY t.cd, t.track_id, t.track_name'; $data_params = new QueryData(); $data_params->addDataParam('i', $upc); $track_result = $wrapperObj->executeQuery($sql, $data_params); if ($track_result === false) { showierror($sql); } if (count($track_result) > 0) { $trackIds = array_map(function($track) { return $track['id']; }, $track_result); $sql = 'SELECT name, type, track_id FROM track_artist WHERE track_id IN ' . '(' . implode(',', array_fill(0, count($trackIds), '?')) . ')' .' ORDER BY type, id'; $dataParams = new QueryData(); foreach ($trackIds as $val) { $dataParams->addDataParam('i', $val); } $track_artist = $wrapperObj->executeQuery($sql, $dataParams); if ($track_artist === false) { showierror($sql); } $track_artists = array(); foreach ($track_artist as $track_artist_row) { $artist_type = ucwords($track_artist_row['type']); if (!isset($track_artists[$track_artist_row['track_id']][$artist_type])) { $track_artists[$track_artist_row['track_id']][$artist_type] = array(); } $track_artists[$track_artist_row['track_id']][$artist_type][] = $track_artist_row['name']; } if ($isnotFilmOrTv) { $get_writer_sql = 'select group_concat(writer_name SEPARATOR ", ") as writer, unique_track_id from track_writer where unique_track_id IN ' . '(' . implode(',', array_fill(0, count($trackIds), '?')) . ')' . ' GROUP BY unique_track_id'; $dataParams = new QueryData(); foreach ($trackIds as $val) { $dataParams->addDataParam('i', $val); } $get_writer_rs = $wrapperObj->executeQuery($get_writer_sql, $dataParams); if ($get_writer_rs === false) { showierror($get_writer_sql); } $writers = array(); foreach ($get_writer_rs as $writer) { $writers[$writer['unique_track_id']] = $writer['writer']; } } if (!empty($trackIds) && $isDigitalProduct) { $owsTrackLyricsServiceClient = new OwsLyricsServiceClient(logger: $logger); try { $trackLyrics = $owsTrackLyricsServiceClient->getLyricsByTrackIds($trackIds, 'oa', $_SESSION['S_USERID']); } catch (\Exception $e) { throw $e; } } if (!empty($trackIds)) { try { $owsTrackServiceClient = new OwsTrackServiceClient(logger: $logger); $performertIds['tuids'] = implode(',', $trackIds); $tracksPerformers = $owsTrackServiceClient->getOwsTrackPerformerData($performertIds); } catch (\Exception $e) { $logger->error($e->getMessage()); } $performerNames = []; if (!empty($tracksPerformers)) { foreach ($tracksPerformers as $trackPerformers) { $performerList = []; if (!empty($trackPerformers['performers'])) { foreach($trackPerformers['performers'] as $performerName) { $performerList[] = $performerName['birth_name']; } } $performerNames[$trackPerformers['tuid']] = $performerList; } } } if ($expanded) { ?>

Track List (Expanded)

addDataParam('i', $track_row['id']); $get_publisher_rs = $wrapperObj->executeQuery($get_publisher_sql, $data_params); if ($get_publisher_rs === false) { showierror($get_publisher_sql); } $get_publisher_row = $get_publisher_rs[0]; $track_row['publisher'] = $get_publisher_row['publisher']; } $row_class = (++$rci & 1) ? '' : 'alt'; ?> false, 'Label Control'=>false, 'License'=>false, 'Mixed'=>false, 'None'=>false); $mechanical_clearance = 'None'; if (count($tmp_publishers)) { foreach ($tmp_publishers as $each_publisher) { if ($each_publisher == 'Public Domain') { $tmp_old_publisher['Public Domain'] = true; } elseif ($each_publisher == 'Label Control') { $tmp_old_publisher['Label Control'] = true; } else { $tmp_old_publisher['License'] = true; } } if ($tmp_old_publisher['Public Domain'] && !$tmp_old_publisher['Label Control'] && !$tmp_old_publisher['License']) { $mechanical_clearance = 'PD'; } elseif (!$tmp_old_publisher['Public Domain'] && $tmp_old_publisher['Label Control'] && !$tmp_old_publisher['License']) { $mechanical_clearance = 'Label Control'; } elseif (!$tmp_old_publisher['Public Domain'] && !$tmp_old_publisher['Label Control'] && $tmp_old_publisher['License']) { $mechanical_clearance = 'License'; } else { $mechanical_clearance ='Mixed'; } } } ?>
Track Number ISRC Type Track Name Track Lyrics Track Version Run Time CD Volume Side Primary Artist(s) Featured Artist(s) Remixer(s) Explicit Focus Track Offer Type Track Writer(s) Third Party Publishers Download Link (Stereo MP3) Download Link (Stereo WAV) Edit
Stereo -
Dolby Atmos - 		'; } elseif ($track_row['track_type'] == 'music') { echo ''; } else { echo '-NONE-'; } ?> :: " href="/cont_mgmt/download_track_audio.php?user=&upc=&isrc=&asset_type=MP3_192" target="_blank" > " href="/cont_mgmt/download_track_audio.php?user=&upc=&isrc=&asset_type=WAV" target="_blank" > Edit
  • Performing Rights Organization:
  • DPD Licence:
  • Demo Clip:
  • Retail Track Price:
  • (P) Line Info:
  • Merch:
  • Hidden Track:
  • Royalty Collection:
  • Pub Admin:
  • Sync Admin:
  • Hidden Track:
  • Video ID:
    array(), 'Publisher' => array() ); foreach ($track_artists[$track_row['id']] as $artist_type => $artist_names) { $requiredTypes[$artist_type] = $artist_names; } if (count($performers) > 0) { $requiredTypes['TrackPerformer'] = $performers; } if ($isnotFilmOrTv && !empty($track_row['publisher'])) { $publishers = explode(',', $track_row['publisher']); $requiredTypes['Publisher'] = $publishers; } $track_artists = $requiredTypes; if (count($track_artists)) { foreach ($track_artists as $artist_type => $artist_names) { $type = strtolower($artist_type); if (!in_array($type, array('performer', 'mastered by', 'recording artist', 'featuring', 'remixer'))) { $tmp_artist_type = ''; switch ($type) { case 'classical conductor': case 'conductor': $tmp_artist_type = 'Conductor'; break; case 'classical ensemble': case 'ensemble': $tmp_artist_type = 'Ensemble'; break; case 'composer': $tmp_artist_type = 'Composer'; break; case 'orchestra': $tmp_artist_type = 'Orchestra'; break; case 'trackperformer': $tmp_artist_type = 'Performer(s)'; break; case 'publisher': if ($isnotFilmOrTv) { $tmp_artist_type = 'Publisher'; } break; default: $tmp_artist_type = $artist_type; } $artist_name = implode(', ', $artist_names); if (!empty($artist_name)) { ?>
  • :
  • Mechanical Clearance:

Track List

Track Number ISRC Type Track Name Track Lyrics Track Version Run Time CD Volume Side Primary Artist(s) Featured Artist(s) Display Featuring as Primary Remixer(s) Explicit Focus Track Offer Type Track Writer(s) Third Party Publishers Download Link (Stereo MP3) Download Link (Stereo WAV) Edit
Stereo -
Dolby Atmos - 		'; } elseif ($track_row['track_type'] == 'music') { echo ''; } else { echo '-NONE-'; } ?> Y
N N 		:: Edit

Track List