"Y" AND r.release_status = "in_content" AND er.upc is NULL AND r.format NOT IN ("Cassette", "DVD", "12\" Vinyl Single", "Vinyl") AND eod.upc IS NULL GROUP BY r.upc ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); if (!$no_url) { $sql .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $release_data = $wrapperObj->executeQuery($sql, $dataParams); if ($release_data === false) { showierror($sql); } if (count($release_data) > 0) { $dataParams = new QueryData(); $sql = 'SELECT FOUND_ROWS() AS total'; $total_count = $wrapperObj->executeQuery($sql, $dataParams); if ($total_count === false) { showierror($sql); } $total = $total_count[0]['total']; $pageNum = ceil($total/$pageRecord); $varTable = ' '; $rci = 0; foreach ($release_data as $RowData) { list($varRelease, $varUPC,$varDisplayUpc, $varPriority, $varArtistID, $varVendorID, $varArtist, $varGenre, $varVendorLabel, $varDateAdded) = array_values($RowData); $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ' '; } $varTable .= '

' . ($no_url ? "Label/Company" : sortColumnHeader('Label/Company', 'vlbl', $url)) . '	' . ($no_url ? "Artist" : sortColumnHeader('Artist', 'an', $url)) . '	' . ($no_url ? "Release Name" : sortColumnHeader('Release Name', 'rn', $url)) . '	' . ($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url)) . '	' . ($no_url ? "Date Added" : sortColumnHeader('Date Added', 'date_added', $url)) . '	' . ($no_url ? "Genre" : sortColumnHeader('Genre', 'genre', $url)) . '	' . ($no_url ? "Initial Priority" : sortColumnHeader('Initial Priority', 'prio', $url)) . '
'.($no_url ? $varVendorLabel : '' . $varVendorLabel . '').'	'.($no_url ? $varArtist : ('' . $varArtist . '')).'	'.($no_url ? $varRelease : ('' . $varRelease . '')).'	'.($no_url ? '"' . $varDisplayUpc . '"': '' . $varDisplayUpc . '').'	' . format_date($varDateAdded) . '	' . $varGenre . '	' . $varPriority . '

'; } break; case 'rwd': $varCrumbText = 'Releases Awaiting Delivery'; switch ($sort_by) { case 'rn': $order_by = 'r.release_name'; break; case 'upc': $order_by = 'r.upc'; break; case 'art': $order_by = 'artist'; break; case 'date_added': $order_by = 'r.ingestion_completed'; break; case 'vlbl': $order_by = 'vendor_label'; break; case 'genre': $order_by = 'g.genre'; break; case 'prio': $order_by = 'r.priority'; break; case 'stat': $order_by = 'r.ingestion_completed'; break; default: $order_by = 'r.priority'; $sort_by = 'prio'; } $dataParams = new QueryData(); $sql = 'SELECT SQL_CALC_FOUND_ROWS r.release_name, r.upc,r.display_upc, r.priority, r.artist_id, a.vendor_id, a.name AS artist, (SELECT genre FROM genre WHERE genre_id = r.genre_id) AS genre, (SELECT company FROM vendor WHERE vendor_id = a.vendor_id) AS vendor_label, r.ingestion_completed FROM artist_info a INNER JOIN releases r ON a.artist_id = r.artist_id LEFT JOIN delivery_history dd ON r.upc = dd.upc WHERE dd.upc IS NULL AND r.deletions <> "Y" AND r.release_status = "in_content" AND r.upc IN ( SELECT ss.upc FROM sony_status ss WHERE ss.upc = r.upc and type = "metadata" AND ss.result = "SUCCEEDED") AND r.upc IN ( SELECT ss.upc FROM sony_status ss WHERE ss.upc = r.upc and type = "image" AND ss.result = "SUCCEEDED") AND r.upc IN ( SELECT ss.upc FROM sony_status ss WHERE ss.upc = r.upc and type = "audio" AND ss.result = "SUCCEEDED") AND r.upc IN ( SELECT ss.upc FROM sony_status ss WHERE ss.upc = r.upc and type = "delivery" AND ss.result = "SUCCEEDED") GROUP BY r.upc ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); if (!$no_url) { $sql .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $release_data = $wrapperObj->executeQuery($sql, $dataParams); if ($release_data === false) { showierror($sql); } if (count($release_data) > 0) { $dataParams = new QueryData(); $sql = 'SELECT FOUND_ROWS() AS total'; $total_count = $wrapperObj->executeQuery($sql, $dataParams); if ($total_count === false) { showierror($sql); } $total = $total_count[0]['total']; $pageNum = ceil($total/$pageRecord); $varTable = ' '; $rci = 0; foreach ($release_data as $RowData) { list($varRelease, $varUPC,$varDisplayUpc, $varLabel, $varPriority, $varArtistID, $varVendorID, $varArtist, $varGenre, $varVendorLabel, $varDateAdded) = array_values($RowData); $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ' '; } $varTable .= '

' . ($no_url ? "Label/Company" : sortColumnHeader('Label/Company', 'vlbl', $url)) . '	' . ($no_url ? "Artist" : sortColumnHeader('Artist', 'an', $url)) . '	' . ($no_url ? "Release Name" : sortColumnHeader('Release Name', 'rn', $url)) . '	' . ($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url)) . '	' . ($no_url ? "Date Added" : sortColumnHeader('Date Added', 'date_added', $url)) . '	' . ($no_url ? "Genre" : sortColumnHeader('Genre', 'genre', $url)) . '	' . ($no_url ? "Initial Priority" : sortColumnHeader('Initial Priority', 'prio', $url)) . '
'.($no_url ? $varVendorLabel : '' . $varVendorLabel . '').'	'.($no_url ? $varArtist : '' . $varArtist . '').'	'.($no_url ? $varRelease : '' . $varRelease . '').'	'.($no_url ? '"'. $varDisplayUpc . '"' : '' . $varDisplayUpc . '').'	' . format_date($varDateAdded) . '	' . $varGenre . '	' . $varPriority . '

'; } break; case 'rfme': $varCrumbText = 'Releases Failed Encoding - Metadata'; switch ($sort_by) { case 'rn': $order_by = 'r.release_name'; break; case 'upc': $order_by = 'r.upc'; break; case 'art': $order_by = 'artist'; break; case 'date_added': $order_by = 'r.ingestion_completed'; break; case 'vlbl': $order_by = 'vendor_label'; break; case 'genre': $order_by = 'g.genre'; break; case 'prio': $order_by = 'r.priority'; break; case 'stat': $order_by = 'r.ingestion_completed'; break; default: $order_by = 'r.priority'; $sort_by = 'prio'; } $dataParams = new QueryData(); $sql = 'SELECT SQL_CALC_FOUND_ROWS r.release_name, r.upc,r.display_upc, r.priority, a.artist_id, a.vendor_id, a.name AS artist, g.genre, (SELECT company FROM vendor WHERE vendor_id = a.vendor_id) AS vendor_label, r.ingestion_completed FROM artist_info a INNER JOIN releases r ON a.artist_id = r.artist_id INNER JOIN sony_status ss ON ss.upc = r.upc LEFT JOIN genre g ON r.genre_id = g.genre_id LEFT JOIN delivery_history dd ON dd.upc = ss.upc AND encoder_id = 1 WHERE ss.type = "metadata" AND ss.result = "FAILED" AND ss.date IN (SELECT max(date) FROM sony_status WHERE upc = ss.upc AND ss.type = type) AND dd.upc IS NULL AND r.release_status = "in_content" GROUP BY r.upc ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); if (!$no_url) { $sql .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $release_data = $wrapperObj->executeQuery($sql, $dataParams); if ($release_data === false) { showierror($sql); } if (count($release_data) > 0) { $dataParams = new QueryData(); $sql = 'SELECT FOUND_ROWS() AS total'; $total_count = $wrapperObj->executeQuery($sql, $dataParams); if ($total_count === false) { showierror($sql); } $total = $total_count[0]['total']; $pageNum = ceil($total/$pageRecord); $varTable = ' '; $rci = 0; foreach ($release_data as $RowData) { list($varRelease, $varUPC,$varDisplayUpc, $varPriority, $varArtistID, $varVendorID, $varArtist, $varGenre, $varVendorLabel, $varDateAdded) = array_values($RowData); $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ' '; } $varTable .= '

' . ($no_url ? "Label/Company" : sortColumnHeader('Label/Company', 'vlbl', $url)) . '	' . ($no_url ? "Artist" : sortColumnHeader('Artist', 'an', $url)) . '	' . ($no_url ? "Release Name" : sortColumnHeader('Release Name', 'rn', $url)) . '	' . ($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url)) . '	' . ($no_url ? "Date Added" : sortColumnHeader('Date Added', 'date_added', $url)) . '	' . ($no_url ? "Genre" : sortColumnHeader('Genre', 'genre', $url)) . '	' . ($no_url ? "Initial Priority" : sortColumnHeader('Initial Priority', 'prio', $url)) . '
'.($no_url ? $varVendorLabel : '' . $varVendorLabel . '').'	'.($no_url ? $varArtist : '' . $varArtist . '').'	'.($no_url ? $varRelease : '' . $varRelease . '').'	'.($no_url ? '"' . $varDisplayUpc . '"' : '' . $varDisplayUpc . '').'	' . format_date($varDateAdded) . '	' . $varGenre . '	' . $varPriority . '

'; } break; case 'rfae': $varCrumbText = 'Releases Failed Encoding - Audio'; switch ($sort_by) { case 'rn': $order_by = 'r.release_name'; break; case 'upc': $order_by = 'r.upc'; break; case 'art': $order_by = 'artist'; break; case 'date_added': $order_by = 'r.ingestion_completed'; break; case 'vlbl': $order_by = 'vendor_label'; break; case 'genre': $order_by = 'g.genre'; break; case 'prio': $order_by = 'r.priority'; break; case 'stat': $order_by = 'r.ingestion_completed'; break; default: $order_by = 'r.priority'; $sort_by = 'prio'; } $dataParams = new QueryData(); $sql = 'SELECT SQL_CALC_FOUND_ROWS r.release_name, r.upc,r.display_upc, r.priority, a.artist_id, a.vendor_id, a.name AS artist, g.genre, (SELECT company FROM vendor WHERE vendor_id = a.vendor_id) AS vendor_label, r.ingestion_completed FROM artist_info a INNER JOIN releases r ON a.artist_id = r.artist_id INNER JOIN sony_status ss ON ss.upc = r.upc LEFT JOIN genre g ON r.genre_id = g.genre_id LEFT JOIN delivery_history dd ON dd.upc = ss.upc AND encoder_id = 1 WHERE ss.type = "audio" AND ss.result = "FAILED" AND ss.date IN (SELECT max(date) FROM sony_status WHERE upc = ss.upc AND ss.type = type) AND dd.upc IS NULL AND r.release_status = "in_content" GROUP BY r.upc ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); if (!$no_url) { $sql .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $release_data = $wrapperObj->executeQuery($sql, $dataParams); if ($release_data === false) { showierror($sql); } if (count($release_data) > 0) { $dataParams = new QueryData(); $sql = 'SELECT FOUND_ROWS() AS total'; $total_count = $wrapperObj->executeQuery($sql, $dataParams); if ($total_count === false) { showierror($sql); } $total = $total_count[0]['total']; $pageNum = ceil($total/$pageRecord); $varTable = ' '; $rci = 0; foreach ($release_data as $RowData) { list($varRelease, $varUPC,$varDisplayUpc, $varPriority, $varArtistID, $varVendorID, $varArtist, $varGenre, $varVendorLabel, $varDateAdded) = array_values($RowData); $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ' '; } $varTable .= '

' . ($no_url ? "Label/Company" : sortColumnHeader('Label/Company', 'vlbl', $url)) . '	' . ($no_url ? "Artist" : sortColumnHeader('Artist', 'an', $url)) . '	' . ($no_url ? "Release Name" : sortColumnHeader('Release Name', 'rn', $url)) . '	' . ($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url)) . '	' . ($no_url ? "Date Added" : sortColumnHeader('Date Added', 'date_added', $url)) . '	' . ($no_url ? "Genre" : sortColumnHeader('Genre', 'genre', $url)) . '	' . ($no_url ? "Initial Priority" : sortColumnHeader('Initial Priority', 'prio', $url)) . '
'.($no_url ? $varVendorLabel : '' . $varVendorLabel . '').'	'.($no_url ? $varArtist : '' . $varArtist . '').'	'.($no_url ? $varRelease : '' . $varRelease . '').'	'.($no_url ? '"' . $varDisplayUpc . '"' : '' . $varDisplayUpc . '').'	' . format_date($varDateAdded) . '	' . $varGenre . '	' . $varPriority . '

'; } break; case 'rfie': $varCrumbText = 'Releases Failed Encoding - Image'; switch ($sort_by) { case 'rn': $order_by = 'r.release_name'; break; case 'upc': $order_by = 'r.upc'; break; case 'art': $order_by = 'artist'; break; case 'date_added': $order_by = 'r.ingestion_completed'; break; case 'vlbl': $order_by = 'vendor_label'; break; case 'genre': $order_by = 'g.genre'; break; case 'prio': $order_by = 'r.priority'; break; case 'stat': $order_by = 'r.ingestion_completed'; break; default: $order_by = 'r.priority'; $sort_by = 'prio'; } $dataParams = new QueryData(); $sql = 'SELECT SQL_CALC_FOUND_ROWS r.release_name, r.upc,r.display_upc, r.priority, a.artist_id, a.vendor_id, a.name AS artist, g.genre, (SELECT company FROM vendor WHERE vendor_id = a.vendor_id) AS vendor_label, r.ingestion_completed FROM artist_info a INNER JOIN releases r ON a.artist_id = r.artist_id INNER JOIN sony_status ss ON ss.upc = r.upc LEFT JOIN genre g ON r.genre_id = g.genre_id LEFT JOIN delivery_history dd ON dd.upc = ss.upc AND encoder_id = 1 WHERE ss.type = "image" AND ss.result = "FAILED" AND ss.date IN (SELECT max(date) FROM sony_status WHERE upc = ss.upc AND ss.type = type) AND dd.upc IS NULL AND r.release_status = "in_content" GROUP BY r.upc ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); if (!$no_url) { $sql .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $release_data = $wrapperObj->executeQuery($sql, $dataParams); if ($release_data === false) { showierror($sql); } if (count($release_data) > 0) { $dataParams = new QueryData(); $sql = 'SELECT FOUND_ROWS() AS total'; $total_count = $wrapperObj->executeQuery($sql, $dataParams); if ($total_count === false) { showierror($sql); } $total = $total_count[0]['total']; $pageNum = ceil($total/$pageRecord); $varTable = ' '; $rci = 0; foreach ($release_data as $RowData) { list($varRelease, $varUPC,$varDisplayUpc, $varPriority, $varArtistID, $varVendorID, $varArtist, $varGenre, $varVendorLabel, $varDateAdded) = array_values($RowData); $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ' '; } $varTable .= '

' . ($no_url ? "Label/Company" : sortColumnHeader('Label/Company', 'vlbl', $url)) . '	' . ($no_url ? "Artist" : sortColumnHeader('Artist', 'an', $url)) . '	' . ($no_url ? "Release Name" : sortColumnHeader('Release Name', 'rn', $url)) . '	' . ($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $url)) . '	' . ($no_url ? "Date Added" : sortColumnHeader('Date Added', 'date_added', $url)) . '	' . ($no_url ? "Genre" : sortColumnHeader('Genre', 'genre', $url)) . '	' . ($no_url ? "Initial Priority" : sortColumnHeader('Initial Priority', 'prio', $url)) . '
'.($no_url ? $varVendorLabel : '' . $varVendorLabel . '').'	'.($no_url ? $varArtist : '' . $varArtist . '').'	'.($no_url ? $varRelease : '' . $varRelease . '').'	'.($no_url ? '"' . $varDisplayUpc . '"' : '' . $varDisplayUpc . '').'	' . format_date($varDateAdded) . '	' . $varGenre . '	' . $varPriority . '

'; } break; } ?>