= ? OR vcc2.cont_end IS NULL OR
vcc2.cont_end = "0000-00-00")) AND vcc.cont_start < vcc2.cont_start
where vcc2.vendor_proposed_term_id IS NULL AND vcc.cont_start <= ? AND
vcc.orchrep_name = ? AND v.status <> "signed" AND v.status <> "deletion"';
$dataParams = [];
$dataParams[] = $today;
$dataParams[] = $today;
$dataParams[] = $today;
$dataParams[] = $_SESSION['S_USERID'];
if (!isOwnerInSession('orchard')) {
$sql .= ownerFilterSubQuery(' AND v.owner');
$dataParams = addSessionOwnerDataParam($dataParams);
}
$sql .= ' GROUP BY status ';
$deal_summary = $pdoWrapper->executeQuery($sql, $dataParams);
if ($deal_summary === false) {
show_pdo_error($sql, $pdoWrapper->getLastStatement());
}
?>
| Content Deals |
|
| Total Content Deals |
|
|---|
| No content deals found. |