= DATE_SUB(CURDATE(), INTERVAL 7 DAY)';
if ($summary_user_id) {
$dataParams->addDataParam('i', $summary_user_id);
}
}else {
$sql = 'SELECT vendor_id
FROM vendor v
WHERE v.status = "signed"
' . ownerFilterSubQuery(' AND v.owner') . '
AND date_created >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)';
$dataParams = addSessionOwnerDataParam($dataParams);
}
$new_label = $wrapperObj->executeQuery($sql, $dataParams);
if ($new_label === false) {
showierror($sql);
}
$varTotalNewLabels = count($new_label);
// count outstainding # number of releases
$varOutstandingReleases = $varTotalESTReleases - $varReleaseReceived;
if ($varOutstandingReleases < 0)
$varOutstandingReleases = 0;
$owner_id = getSessionOwnerDetails($wrapperObj)['owner_ids'];
//cout labels in partner's territories
$dataParams = new QueryData();
$getPartnerTerrLabels = "select distinct v.vendor_id from vendor v
INNER join vend_contact vc on vc.vendor_id = v.vendor_id
INNER JOIN contact vcc on vcc.contact_id = vc.contact_id
INNER JOIN(
SELECT distinct c.id
FROM agreement a
LEFT JOIN agreement_territory at ON a.agreement_id = at.agreement_id
LEFT JOIN country c ON c.id = at.territory_id
WHERE a.service_type = 'owner' AND at.type IN ('regular', 'exclusive')
" . ownerFilterSubQuery(' and a.service_id', $owner_id) . "
) x on x.id = vcc.orchard_country";
$dataParams = addSessionOwnerDataParam($dataParams, 'i', $owner_id);
$getPartnerTerrLabels_rs = $wrapperObj->executeQuery($getPartnerTerrLabels, $dataParams);
if ($getPartnerTerrLabels_rs === false) {
showierror($getPartnerTerrLabels);
}
$labels_in_terr = count($getPartnerTerrLabels_rs);
?>
| Labels from my territory |
|
>
| All labels |
|
>| New labels |
|
>| Releases Expected |
|
>| Releases Received |
|
>| Outstanding releases |
|