addDataParam('s', $publisher_id); $pub_lic_grand_total_result = $wrapperObj->executeQuery($pub_lic_grand_total, $dataParams); if ($pub_lic_grand_total_result === false) { showierror($pub_lic_grand_total); } $pub_lic_grand_total_row = $pub_lic_grand_total_result[0]; $grandTotalLic = $pub_lic_grand_total_row["total"]; $pub_lic_query = "SELECT pl.license_no, pl.publisher_license_no, pl.effective_date , pl.expiration_date, pl.status, pl.license_type, pl.ownership , t.id as track_unique_id, t.track_name, t.cd, t.track_id , r.release_name, r.upc,r.display_upc, a.artist_id, a.name as artist_name FROM publishers_license pl LEFT JOIN track t ON t.id = pl.track_id LEFT JOIN releases r ON r.upc = t.upc LEFT JOIN artist_info a ON a.artist_id = r.artist_id WHERE pl.publisher_id = ? AND r.not_for_distribution != 'SMEAnalyticsDummy' "; $dataParams = new QueryData(); $dataParams->addDataParam('s', $publisher_id); //echo $pub_lic_query; switch ($sort_by) { case 'artist_name': $order_by .= 'artist_name'; break; case 'upc': $order_by .= 'upc'; break; case 'track_name': $order_by .= 'track_name'; break; case 'license_no': $order_by .= 'license_no'; break; case 'publisher_license_no': $order_by .= 'publisher_license_no'; break; case 'effective_date': $order_by .= 'pl.effective_date '; break; case 'expiration_date': $order_by .= 'pl.expiration_date'; break; case 'status': $order_by .= 'status'; break; case 'license_type': $order_by .= 'license_type'; break; case 'ownership': $order_by .= 'ownership'; break; default: $order_by .= 'license_no'; } $pub_lic_query .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : '') . (!$viewall ? ' LIMIT 0, 5' : ''); //echo $pub_lic_query; $pub_lic_result = $wrapperObj->executeQuery($pub_lic_query, $dataParams); if ($pub_lic_result === false) { showierror($pub_lic_query); } $total = count($pub_lic_result); $pageNum = ceil($total/$pageRecord); $page = $page > $pageNum ? $pageNum : $page; if ($viewall) { if ($total) { echo paginate($page, $pageRecord, $pageNum, $varQueryString); } } ?>

Publisher License

0) { ?>

Viewing of - View All


License No	Artist	Release Name	UPC	Track	Publisher's License #	Status	License Type	Effective Date	Expiration Date	Ownership
	">	">									">Edit

No Publisher License found.