addDataParam('i', $proposal_id); $sql1 .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : ''); if (!$no_url) { $sql1 .= ' LIMIT ?, ?'; $dataParams->addDataParam('i', (($page - 1) * $pageRecord)); $dataParams->addDataParam('i', $pageRecord); } $rs = $wrapperObj->executeQuery($sql1, $dataParams); if ($rs === false) { showierror($sql1); } $sql = 'SELECT FOUND_ROWS() AS total'; $dataParams = new QueryData(); $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 .= ''; if($target_type=="track"){ $varTable.=''; }elseif($target_type=="release"){ $varTable.=''; }elseif($target_type=="vendor"){ $varTable.=''; } foreach ($rs as $row) { if($target_type=="track"){ $varTable.=''; }elseif($target_type=="release"){ $varTable.=''; }elseif($target_type=="vendor"){ $varTable.=''; } } $varTable .= '

'.($no_url ? "Label" : sortColumnHeader('Label','company',$url)).'	'.($no_url ? "UPC" : sortColumnHeader('UPC','upc',$url)).'	'.($no_url ? "CD" : sortColumnHeader('CD','cd',$url)).'	'.($no_url ? "Track #" : sortColumnHeader('Track #','track_id',$url)).'	'.($no_url ? "Track Name" : sortColumnHeader('Track Name','track_name',$url)).'	'.($no_url ? "Release Name" : sortColumnHeader('Release Name','release_name',$url)).'	'.($no_url ? "Artist Name" : sortColumnHeader('Artist Name','name',$url)).'	'.($no_url ? "Changed By" : sortColumnHeader('Changed By','username',$url)).'
'.($no_url ? "Label" : sortColumnHeader('Label','company',$url)).'	'.($no_url ? "UPC" : sortColumnHeader('UPC','upc',$url)).'	'.($no_url ? "Release Name" : sortColumnHeader('Release Name','release_name',$url)).'	'.($no_url ? "Artist Name" : sortColumnHeader('Artist Name','name',$url)).'	'.($no_url ? "Changed By" : sortColumnHeader('Changed By','username',$url)).'
'.($no_url ? "Label" : sortColumnHeader('Label','company',$url)).'	'.($no_url ? "Opt-in / Opt-out" : sortColumnHeader('Opt-in / Opt-out','optin_or_out',$url)).'	'.($no_url ? "Changed By" : sortColumnHeader('Changed By','username',$url)).'
'.($no_url ? $row['company'] : (''.$row['company'].'')).'	'.($no_url ? '"'.$row['display_upc'].'"' : $row['display_upc']).'	'.$row['cd'].'	'.$row['track_id'].'	'.($no_url ? $row['track_name'] : ('   '.$row['track_name'])).'	'.($no_url ? $row['release_name'] : (''.$row['release_name'].'')).'	'.($no_url ? $row['artist_name'] : (''.$row['artist_name'].'')).'	'.$row['username'].'
'.($no_url ? $row['company'] : (''.$row['company'].'')).'	'.($no_url ? '"'.$row['display_upc'].'"' : (''.$row['display_upc'].'')).'	'.($no_url ? $row['release_name'] : ('   '.$row['release_name'].'')).'	'.($no_url ? $row['artist_name'] : (''.$row['artist_name'].'')).'	'.$row['username'].'
'.($no_url ? $row['company'] : (''.$row['company'].'')).'	'.ucwords($row['optin_or_out']).'	'.$row['username'].'

'; ?>