addDataParam('s', $old_date);
$dataParams->addDataParam('s', $today);
if ($membersString <> "") {
$membersArray = explode(',' , $membersString);
foreach ($membersArray as $member) {
$dataParams->addDataParam('i', $member);
}
}
if($_REQUEST['type']=="trans_to_content"){
$sql2 = "select SQL_CALC_FOUND_ROWS r.upc upc,r.display_upc, a.artist_id, v.vendor_id vid, r.ingestion_completed ingestion_completed, a.name artist_name,r.release_date release_date, r.release_name release_name, v.company vendor_name, concat(ou.f_name, ' ', ou.l_name) as username
from releases r
inner join artist_info a on a.artist_id = r.artist_id
inner join vendor v on v.vendor_id = a.vendor_id
left join orchadmin_users ou on ou.id = v.assigned_to
where r.release_status = 'in_content' and r.not_for_distribution != 'SMEAnalyticsDummy' and r.ingestion_completed between ? and ?
" . (($membersString <> "") ? " AND v.assigned_to in (" . implode(',', array_fill(0, count($membersArray), '?')) . ")" : "") . "
group by r.upc";
}elseif ($_REQUEST['type']=="deletions_entered"){
$sql1 = "SELECT SQL_CALC_FOUND_ROWS r.upc upc,r.display_upc, a.artist_id, v.vendor_id vid, a.name artist_name,r.release_date release_date, r.release_name release_name, v.company vendor_name, fd.date_deleted date_deleted, concat(ou.f_name, ' ', ou.l_name) as username
FROM releases r
INNER JOIN full_deletions fd ON r.upc = fd.upc
INNER JOIN artist_info a ON a.artist_id = r.artist_id
INNER JOIN vendor v ON v.vendor_id = a.vendor_id
LEFT JOIN orchadmin_users ou ON ou.id = v.assigned_to
WHERE r.deletions = 'Y'and r.not_for_distribution != 'SMEAnalyticsDummy' AND fd.date_deleted between ? and ?
" . (($membersString <> "") ? " AND v.assigned_to in (" . implode(',', array_fill(0, count($membersArray), '?')) . ")" : "") . "
GROUP BY r.upc";
}
$sql = 'SELECT SQL_CALC_FOUND_ROWS x.*
FROM (
SELECT a.artist_id, a.upc,a.display_upc, a.label, a.release_id, a.release_date, c.vendor_id, c.name artist_name,
v.company vendor_name, MIN(d.date) AS ingestion_completed, MAX(d.date) AS status_date, a.release_name, c.name,
v.company, v.assigned_to, CONCAT(ou.f_name, " ", ou.l_name) AS username,
(SELECT GROUP_CONCAT(`status` ORDER BY release_status_id DESC)
FROM release_status WHERE release_id = a.release_id AND `status` = "label_confirmation") AS `status`
FROM releases a
INNER JOIN artist_info c ON a.artist_id = c.artist_id
INNER JOIN vendor v ON c.vendor_id = v.vendor_id
LEFT JOIN orchadmin_users ou ON ou.id = v.assigned_to
LEFT OUTER JOIN release_status d ON a.release_id = d.release_id
WHERE a.release_status != "in_content" AND a.release_name <> "" AND a.not_for_distribution != "SMEAnalyticsDummy"
GROUP BY a.release_id
) AS x
WHERE x.`status` LIKE "label_confirmation%"
AND x.status_date BETWEEN ? and ?
' . (($membersString <> '') ? ' AND x.assigned_to in (' . implode(',', array_fill(0, count($membersArray), '?')) . ')' : '');
if($_REQUEST['type']=="deletions_entered"){
$sql = $sql1;
}elseif ($_REQUEST['type']=="trans_to_content"){
$sql = $sql2;
}
$sql .= " ORDER BY " . $order_by . ($sort_desc ? " DESC" : "");
$sql .= !$no_url ? ' LIMIT ?, ?' : '';
if (!$no_url) {
$dataParams->addDataParam('i', (($page - 1) * $pageRecord));
$dataParams->addDataParam('i', $pageRecord);
}
$rs = $wrapperObj->executeQuery($sql, $dataParams);
if ($rs === false) {
showierror($sql);
}
$dataParams = new QueryData();
$sql = "SELECT FOUND_ROWS() AS total";
$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);
?>
';
if($_REQUEST['type']=="deletions_entered"){
$varTable .='
| '.($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url)).' |
'.($no_url ? "PM Associated" : sortColumnHeader('Person Associated', 'username', $url)).' |
'.($no_url ? "Release Name" : sortColumnHeader('Release Name', 'release_name', $url)).' |
'.($no_url ? "Artist Name" : sortColumnHeader('Artist Name', 'artist_name', $url)).' |
'.($no_url ? "Label/Company" : sortColumnHeader('Label/Company', 'label', $url)).' |
'.($no_url ? "Release Date" : sortColumnHeader('Release Date', 'release_date', $url)).' |
'.($no_url ? "Date Deleted" : sortColumnHeader('Date Deleted', 'date_deleted', $url)).' |
';
}elseif($_REQUEST['type']=="trans_to_content"){
$varTable .='
'.($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url)).' |
'.($no_url ? "PM Associated" : sortColumnHeader('Person Associated', 'username', $url)).' |
'.($no_url ? "Release Name" : sortColumnHeader('Release Name', 'release_name', $url)).' |
'.($no_url ? "Artist Name" : sortColumnHeader('Artist Name', 'artist_name', $url)).' |
'.($no_url ? "Label/Company" : sortColumnHeader('Label/Company', 'label', $url)).' |
'.($no_url ? "Release Date" : sortColumnHeader('Release Date', 'release_date', $url)).' |
'.($no_url ? "Date Added" : sortColumnHeader('Date Added', 'ingestion_completed', $url)).' |
';
}else{
$varTable .='
'.($no_url ? "Release ID" : sortColumnHeader('Release ID', 'release_id', $url)).' |
'.($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url)).' |
'.($no_url ? "PM Associated" : sortColumnHeader('Person Associated', 'username', $url)).' |
'.($no_url ? "Release Name" : sortColumnHeader('Release Name', 'release_name', $url)).' |
'.($no_url ? "Artist Name" : sortColumnHeader('Artist Name', 'artist_name', $url)).' |
'.($no_url ? "Label/Company" : sortColumnHeader('Label/Company', 'label', $url)).' |
'.($no_url ? "Release Date" : sortColumnHeader('Release Date', 'release_date', $url)).' |
';
}
$varTable .='
';
if (count($rs) > 0) {
$rci = 0;
foreach ($rs as $result) {
$row_class = (++$rci & 1) ? '' : 'alt'; ?>
';
if($_REQUEST['type']=="deletions_entered"){
$varTable .='
'.($no_url ? '"' . $result['display_upc'] . '"' : ''.$result['display_upc'].'').' |
'.$result['username'].' |
'.($no_url ? $result['release_name'] : ''.$result['release_name'].'').' |
'.($no_url ? $result['artist_name'] : ''.$result['artist_name'].'').' |
'.($no_url ? $result['vendor_name'] : ''.$result['vendor_name'].'').' |
'.$result['release_date'].' |
'.$result['date_deleted'].' |
';
}elseif($_REQUEST['type']=="trans_to_content"){
$varTable .='
'.($no_url ? '"' . $result['display_upc'] . '"' : ''.$result['display_upc'].'').' |
'.$result['username'].' |
'.($no_url ? $result['release_name'] : ''.$result['release_name'].'').' |
'.($no_url ? $result['artist_name'] : ''.$result['artist_name'].'').' |
'.($no_url ? $result['vendor_name'] : ''.$result['vendor_name'].'').' |
'.$result['release_date'].' |
'.$result['ingestion_completed'].' |
';
}else{
$varTable .='
'.($no_url ? $result['release_id'] : ''.$result['release_id'].'').' |
"'.$result['display_upc'].'" |
'.$result['username'].' |
'.($no_url ? $result['release_name'] : ''.$result['release_name'].'').' |
'.$result['artist_name'].' |
'.($no_url ? $result['vendor_name'] : ''.$result['vendor_name'].'').' |
'.$result['release_date'].' |
';
}
$varTable .='
';
}
}
else {
$varTable .= '
| No Label Copy Status Reported. |
';
}
$varTable .='
';
?>