addDataParam('i', $summary_user_id);
}
if ($nlbl) {
$sql .= ' AND v.date_created >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)';
}
$sql .= ' GROUP BY v.vendor_id
HAVING v.vendor_id > 0';
if (!$aggregator_login) {
$sql .= ' UNION
SELECT v.vendor_id, v.name AS contact_name, v.company, v.priority,
min(vcr.cont_start) AS cont_start
FROM vendor v
LEFT OUTER JOIN vendor_contract vcr ON v.vendor_id = vcr.vendor_id
WHERE v.status = "signed"' . ownerFilterSubQuery(' AND v.owner');
$dataParams = addSessionOwnerDataParam($dataParams);
if ($nlbl) {
$sql .= ' AND v.date_created >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)';
}
$sql .= ' GROUP BY v.vendor_id
HAVING v.vendor_id > 0';
}
$vendor_data = $wrapperObj->executeQuery($sql, $dataParams);
if ($vendor_data === false) {
showierror($sql);
}
$total = count($vendor_data);
$mainarray = array();
if ($total) {
$pageNum = ceil($total/$pageRecord);
$page = $page > $pageNum ? $pageNum : $page;
foreach ($vendor_data as $RowData) {
$varReleasesPending = $pendingArr[$RowData['vendor_id']]['releases_pending'];
$varTracksPending = $pendingArr[$RowData['vendor_id']]['tracks_pending'];
$subarray = array('vendor_id'=>$RowData['vendor_id'], 'company'=>$RowData['company'], 'contact_name'=>$RowData['contact_name'], 'priority'=>$RowData['priority'], 'pending_releases'=>$varReleasesPending, 'pending_tracks'=>$varTracksPending, 'cont_start'=>$RowData['cont_start']);
$mainarray[] = $subarray;
}
switch($sort_by) {
case 'ln':
$order_by = 'company';
$mainarray = multisort($mainarray, $order_by, ($sort_desc ? false : true), 4);
break;
case 'lid':
$order_by = 'vendor_id';
$mainarray = multisort($mainarray, $order_by, ($sort_desc ? false : true), 2);
break;
case 'cn':
$order_by = 'contact_name';
$mainarray = multisort($mainarray, $order_by, ($sort_desc ? false : true), 4);
break;
case 'lp':
$order_by = 'priority';
$mainarray = multisort($mainarray, $order_by, ($sort_desc ? false : true), 2);
break;
case 'sdate':
$order_by = 'cont_start';
$mainarray = multisort($mainarray, $order_by, ($sort_desc ? false : true), 4);
break;
case 'pr':
$order_by = 'pending_releases';
$mainarray = multisort($mainarray, $order_by, ($sort_desc ? false : true), 2);
break;
case 'pt':
$order_by = 'pending_tracks';
$mainarray = multisort($mainarray, $order_by, ($sort_desc ? false : true), 2);
break;
default:
$sort_by = 'ln';
$order_by = 'company';
$mainarray = multisort($mainarray, $order_by, ($sort_desc ? false : true), 4);
}
}
?>