= DATE_SUB(CURDATE(), INTERVAL 30 DAY), 1, 0)) AS new_releases';
$sql .=' FROM vendor v
LEFT JOIN vend_contact vc ON vc.vendor_id = v.vendor_id AND vc.master = "Y"
LEFT JOIN contact vcc ON vcc.contact_id = vc.contact_id ';
if(check_user_role($wrapperObj, 9))
$sql .= ' LEFT JOIN artist_info a ON v.vendor_id = a.vendor_id
LEFT JOIN releases r ON a.artist_id = r.artist_id AND r.deletions <> "Y" ';
$sql .= ' WHERE v.priority IN (1, 2)
AND v.status = "signed" ';
if (!isOwnerInSession('orchard')) {
$sql .= ownerFilterSubQuery(' AND v.owner');
$dataParams = addSessionOwnerDataParam($dataParams);
} else if (check_user_role($wrapperObj, 3)) {
$sql .= ' AND v.assigned_to = ?';
$dataParams->addDataParam('i', $_SESSION['S_USERID']);
}
else if(check_user_role($wrapperObj, 10))
$sql .= ' AND v.assigned_to = 138 ';
switch ($sort_by){
case 'vendor_id':
$order_by = "v.vendor_id";
break;
case 'company':
$order_by = 'v.company';
break;
case 'name':
$order_by = 'v.name';
break;
case 'owner':
$order_by = 'v.owner';
break;
case 'total_rel':
$order_by = 'total_releases';
break;
case 'new_rel':
$order_by = 'new_releases';
break;
default:
$order_by = "v.priority, v.company";
$sort_by = 'prio';
}
$sql .= '
GROUP BY v.vendor_id
ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : '') . (!$viewall ? ' LIMIT 0, 5' : '');
$top_vend = $wrapperObj->executeQuery($sql, $dataParams);
if ($top_vend === false) {
showierror($sql);
}
$total = count($top_vend);
$pageNum = ceil($total/$pageRecord);
$page = $page > $pageNum ? $pageNum : $page;
if ($viewall) {
if ($total) {
echo paginate($page, $pageRecord, $pageNum, $varQueryString);
}
} ?>
|
|
|
|
|
|
# PA Releases |
# New PA Releases |
# P1 Screeenshots |
# Screenshots |
|
|
|---|
| Label ID |
Company |
Contact Name |
Owner |
|---|
|
|
|
|
= DATE_SUB(CURDATE(), INTERVAL 30 DAY), 1, 0)) AS new_priority_a_releases
FROM mkt_priority mp
INNER JOIN releases r ON mp.upc = r.upc AND r.deletions <> "Y" AND r.release_status = "in_content"
INNER JOIN artist_info a ON a.artist_id = r.artist_id
INNER JOIN vendor v ON v.vendor_id = a.vendor_id
WHERE v.vendor_id = ?
GROUP BY v.vendor_id';
$dataParams->addDataParam('i', $top_vend_row['vendor_id']);
$mkt_rel_result = $wrapperObj->executeQuery($sql, $dataParams);
if ($mkt_rel_result === false) {
showierror($sql);
}
$mkt_rel_row = $mkt_rel_result[0];
$priority_a_releases = $mkt_rel_row['priority_a_releases'];
$new_priority_a_releases = $mkt_rel_row['new_priority_a_releases'];
$dataParams = new QueryData();
$sql = 'SELECT SUM(x.sst_count) AS total_sst, SUM(IF(x.priority = 1, x.sst_count, 0)) AS priority_1_sst
FROM (SELECT COUNT(screenshot_id) AS sst_count, priority, s.type
FROM screenshot s
WHERE type = "label"
AND id = ?
GROUP BY id
UNION
SELECT COUNT(s.screenshot_id) AS sst_count, s.priority, s.type
FROM screenshot s
INNER JOIN artist_info a ON s.id = a.artist_id
WHERE s.type = "artist"
AND a.vendor_id IS NOT NULL
AND a.vendor_id = ?
GROUP BY a.vendor_id
UNION
SELECT COUNT(s.screenshot_id) AS sst_count, s.priority, s.type
FROM screenshot s
INNER JOIN releases r ON r.upc = s.id
INNER JOIN artist_info a ON a.artist_id = r.artist_id
WHERE s.type = "release"
AND r.release_status = "in_content"
AND a.vendor_id IS NOT NULL
AND r.deletions <> "Y"
AND a.vendor_id = ?
GROUP BY a.vendor_id
) x';
$dataParams->addDataParam('i', $top_vend_row['vendor_id']);
$dataParams->addDataParam('i', $top_vend_row['vendor_id']);
$dataParams->addDataParam('i', $top_vend_row['vendor_id']);
$p1_result = $wrapperObj->executeQuery($sql, $dataParams);
if ($p1_result === false) {
showierror($sql);
}
$p1_row = $p1_result[0];
$priority_1_sst = $p1_row['priority_1_sst'];
$total_sst = $p1_row['total_sst'];
?>
|
|
|
|
|
|
|
|
| No top labels. |