addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $prosp_label_result = $wrapperObj->executeQuery($sql, $dataParams); if ($prosp_label_result === 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 = $total_count[0]['total']; $pageNum = ceil($total/$pageRecord); $varTable .=' '.($no_url ? "UPC" : sortColumnHeader('UPC', 'upc', $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_name', $url)).' '. ($no_url ? "Date Deleted" : sortColumnHeader('Date Deleted', 'date_deleted', $url)).' '. ($no_url ? "Compliance Check Date" : sortColumnHeader('Compliance Check Date', 'compliance_check_date', $url)).' '. ($no_url ? "Compliance Check Satisfactory" : sortColumnHeader('Compliance Check Satisfactory', 'compliance_check_satisfactory', $url)).' '; if (count($prosp_label_result)) { $rci = 0; foreach ($prosp_label_result as $results) { // release search type based on `display_upc` feature flag $releaseSearchParam = "release_id=" . $results["release_id"]; $row_class = (++$rci & 1) ? '' : 'alt'; $varTable .= ' '.($no_url ? '"' . $results['display_upc'] . '"' : ''.$results['display_upc'].'').' '.($no_url ? $results['release_name'] : ''.$results['release_name'].'').' '.($no_url ? $results['artist_id'] : ''.$results['artist_name'].'').' '.($no_url ? $results['vendor_id'] : ''.$results['label_name'].'').' '.$results['date_deleted'].' '.$results['compliance_check_date'].' '.$results['compliance_check_satisfactory'].' '; } } else { $varTable .= ' No Deletions Found. '; } $varTable .= ''; ?>