DMS Master
getVendorCarveoutsByVendorId($vendor_id)['message'];
echo 'NEW STORE OPTOUT:
';
foreach ($distributionTypeList as $distId => $type) {
echo '' . $type . ':'
. ((is_array($vendorCarveouts['optout']) && in_array($distId, $vendorCarveouts['optout'])) ? ' Yes ' : ' No ');
}
echo '';
$sql = 'select vcdg.vendor_contract_id, (select distinct name from distribution_type where id = vcdg.distribution_type_id) as distribution_type, cmm.customer_name as customer_master_master_name
from vendor_dms_master_restriction vcdg
inner join customer_master_master cmm on cmm.customer_master_master_id = vcdg.customer_master_master_id
where vcdg.vendor_contract_id = ?';
$rs = $wrapperObj->executeQuery($sql, [$id + $old_contract_id]);
if ($rs === false) {
show_pdo_error($sql, $wrapperObj->getLastStatement());
}
$customer_master_master_name_arr = array();
foreach ($rs as $row) {
$customer_master_master_name_arr[$row['distribution_type']][] = $row['customer_master_master_name'];
}
foreach($customer_master_master_name_arr as $k=>$v){
natcasesort($v); ?>
|
DMS Carveouts
executeQuery($sql, $data_params);
if ($dms_result === false) {
show_pdo_error($sql, $wrapperObj->getLastStatement());
}
$dms_row_arr = array();
foreach ($dms_result as $dms_row) {
array_push($dms_row_arr,$dms_row["name"]);
}
natcasesort($dms_row_arr);
echo implode(', ',$dms_row_arr);
?>
|
Territory Restrictions
executeQuery($sql, $data_params);
if ($terr_result === false) {
show_pdo_error($sql, $wrapperObj->getLastStatement());
}
$terr_row_arr = array();
foreach ($terr_result as $terr_row) {
array_push($terr_row_arr,$terr_row["name"]);
}
natcasesort($terr_row_arr);
echo implode(', ',$terr_row_arr);
?>
|
executeQuery($sql, [$id]);
if ($result === false) {
show_pdo_error($sql, $wrapperObj->getLastStatement());
}
?>
Physical Rights Notes
|