0) ? $pageRecord : 100; $varQueryString = formatURLQueryString('page,pageRecord', array($_REQUEST)); $url = formatURLQueryString('sort_by,sort_desc,page,pageRecord', array($_REQUEST)); $pageNum = 0; $total = 0; $today = date('Y-m-d'); $sql = 'SELECT v.company, v.vendor_id, v.status, v.last_update' . ($viewall ? ', v.name, v.priority, c.contact_email, cntry.name AS country' : '') . ' FROM vendor v ' . ($viewall ? ' LEFT JOIN vend_contact vc ON v.vendor_id = vc.vendor_id AND vc.master = "Y" LEFT JOIN contact c ON vc.contact_id = c.contact_id LEFT JOIN country cntry ON c.orchard_country = cntry.id' : ''); $sql .= ' INNER JOIN vendor_proposed_term vcc ON v.vendor_id=vcc.vendor_id LEFT JOIN vendor_proposed_term vcc2 ON vcc.vendor_id = vcc2.vendor_id AND vcc2.cont_start <= ? AND ((vcc2.cont_start = "0000-00-00") OR (vcc2.cont_end >= ? OR vcc2.cont_end IS NULL OR vcc2.cont_end = "0000-00-00")) AND vcc.cont_start < vcc2.cont_start'; $dataParams->addDataParam('s', $today); $dataParams->addDataParam('s', $today); $sql .= ' WHERE v.status <> "signed" AND v.status <> "deletion" AND vcc2.vendor_proposed_term_id IS NULL AND vcc.cont_start <= ?'; $dataParams->addDataParam('s', $today); if (!isOwnerInSession('orchard')) { $sql .= ownerFilterSubQuery(' AND v.owner'); $dataParams = addSessionOwnerDataParam($dataParams); } if ($status) { $sql .= ' AND v.status = ?'; $dataParams->addDataParam('s', $status); } if ($ca_rep) { $sql .= ' AND vcc.orchrep_name = ?'; $dataParams->addDataParam('s', $ca_rep); } switch ($sort_by){ case 'id': $order_by = 'v.vendor_id'; break; case 'company': $order_by = "v.company"; break; case 'name': $order_by = 'v.name'; break; case 'prio': $order_by = 'v.priority'; break; case 'email': $order_by = 'c.contact_email'; break; case 'country': $order_by = 'cntry.name'; break; case 'status': $order_by = 'v.status'; break; case 'last_update': $order_by = 'last_update'; break; default: $order_by = "last_update"; $sort_desc = 1; } $sql .= ' GROUP BY v.vendor_id ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : '') . (!$viewall ? ' LIMIT 0, 5' : ''); $cur_deal_result = $wrapperObj->executeQuery($sql, $dataParams); if ($cur_deal_result === false) { showierror($sql); } $total = count($cur_deal_result); $pageNum = ceil($total/$pageRecord); $page = $page > $pageNum ? $pageNum : $page; if ($viewall) { if ($total) { echo paginate($page, $pageRecord, $pageNum, $varQueryString); } } ?>

Prospective Content Deals

Label ID Company Agreement Status Last Updated
No prospective content deals found.