"") { foreach ($membersArray as $member) { $dataParams[] = $member; } } $sql2 = "SELECT SQL_CALC_FOUND_ROWS r.upc, a.artist_id, v.vendor_id vid, a.name artist_name,r.release_date, r.release_name, v.company vendor_name, fd.date_deleted 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 WHERE r.release_status = 'in_content' AND r.deletions = 'Y' and fd.date_deleted between ? and ? ".(($membersString <> "") ? " AND v.assigned_to in (". implode(',', array_fill(0, count($membersArray), '?')) .")" : "")." GROUP BY r.upc"; $rs2 = $pdoWrapperObj->executeQuery($sql2, $dataParams); if ($rs2 === false) show_pdo_error($sql2, $pdoWrapperObj->getLastStatement()); $num3 = count($rs2); $sql3 = "SELECT SQL_CALC_FOUND_ROWS r.upc, a.artist_id, v.vendor_id vid, r.ingestion_completed, a.name artist_name,r.release_date, r.release_name, v.company vendor_name 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 WHERE r.release_status = 'in_content' AND r.ingestion_completed BETWEEN ? AND ? ".(($membersString <> "") ? " AND v.assigned_to in (". implode(',', array_fill(0, count($membersArray), '?')) .")" : "")." GROUP BY r.upc"; $rs3 = $pdoWrapperObj->executeQuery($sql3, $dataParams); if ($rs3 === false) show_pdo_error($sql3, $pdoWrapperObj->getLastStatement()); $num2 = count($rs3); ?>

Label Copy Status Report

Refine Result by Past "> days and members

Please select member(s)

'.($viewall ? sortColumnHeader('Date Range', 'date_range', $url) : 'Date Range').' '.($viewall ? sortColumnHeader('Report Description', 'report_description', $url) : 'Report Description').' '.($viewall ? sortColumnHeader('Total', 'total', $url) : 'Total').' '; $varTable .=' Past ' . ((isset($_REQUEST['range']) && ctype_digit($_REQUEST['range'])) ? $_REQUEST['range'] : "7") . ' days Releases Transferred to Content '.($no_url ? $num2 : ''.$num2.'').' Past ' . ((isset($_REQUEST['range']) && ctype_digit($_REQUEST['range'])) ? $_REQUEST['range'] : "7") . ' days Releases with deletions entered '.($no_url ? $num3 : ''.$num3.'').'

'; echo $varTable; ?>