addDataParam('i', $vendor_id); if (!$no_url) { $cd_received_query .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } else { $cd_received_query .= ''; } $cd_received_result = $wrapperObj->executeQuery($cd_received_query, $dataParams); if ($cd_received_result === false) { showierror($cd_received_query); } $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); $varTable = ''; $varTable .= ''; $varTable .= ''; if (count($cd_received_result) > 0) { $rci = 0; foreach ($cd_received_result as $cd_received_row) { $row_class = (++$rci & 1) ? '' : 'alt'; preventFormulaInjection($cd_received_row["release_name"]); $varTable .= ' '; $varTable .= ''; } ?> '; } $varTable .= '

'.($no_url ? 'Artist' : (sortColumnHeader('Artist', 'an', 'vendor_id=' . $vendor_id))).'	'.($no_url ? 'UPC' : (sortColumnHeader('UPC', 'upc', 'vendor_id=' . $vendor_id))).'	'.($no_url ? 'Release Name' : (sortColumnHeader('Release Name', 'rn', 'vendor_id=' . $vendor_id))).'	'.($no_url ? 'Release Date' : (sortColumnHeader('Release Date', 'rd', 'vendor_id=' . $vendor_id))).'	'.($no_url ? 'Label' : (sortColumnHeader('Label', 'rl', 'vendor_id=' . $vendor_id))).'	'.($no_url ? 'Genre' : (sortColumnHeader('Genre', 'genre', 'vendor_id=' . $vendor_id))).'
'.htmlspecialchars($cd_received_row["artist_name"]).'	'; $release_status = $cd_received_row["release_status"]; $release_id = $cd_received_row["release_id"]; $path = ($release_status != "in_content" ? "edit_ex_release.php?release_id=".$release_id : 'view_release.php?upc='.$cd_received_row["upc"]); $varTable .= $no_url ? '"'. $cd_received_row["display_upc"] .'"' : ''.$cd_received_row["display_upc"].''; $varTable .= '	'.htmlspecialchars($cd_received_row["release_name"]).'	'.format_date($cd_received_row["release_date"]).'	'.$cd_received_row["label"].'	'.$cd_received_row["genre"].'
No CD Received.

'; ?>