"Y" ORDER BY cmm.customer_master_master_id'; $customer_result = $wrapperObj->executeQuery($customer_q, []); if ($customer_result === false) { show_pdo_error($customer_q, $wrapperObj->getLastStatement()); } $logger = Zend_Registry::get('applicationLoggerOA'); $userId = $_SESSION['S_USERID']; $owsContractsServiceClient = new OwsContractsServiceClient(logger: $logger); foreach ($customer_result as $customer_row) { $new_id = $customer_row['customer_master_master_id']; if ($new_id != $old_id) { if ($i == 0) { $labelList = 'labelList[' . $new_id . '] = [ "' . $customer_row['name'] . '"'; $valueList = 'valueList[' . $new_id . '] = [ "' . $customer_row['customer_id'] . '"'; } else { $labelList .= $labelList . '];\n'; $labelList .= $valueList . '];\n'; $labelList = 'labelList[' . $new_id . '] = [ "' . $customer_row['name'] . '"'; $valueList = 'valueList[' . $new_id . '] = [ "' . $customer_row['customer_id'] . '"'; } } else { $labelList .= ', "' . $customer_row['name'] . '"'; $valueList .= ', "' . $customer_row['customer_id'] . '"'; } $old_id = $new_id; $i++; } $thelabels = ""; $thevalues = ""; $dms_query = 'SELECT customer_id, name from customer_master WHERE physical <> "Y" and customer_master_master_id is not null order by name'; $dms_result = $wrapperObj->executeQuery($dms_query, []); if ($dms_result === false) { show_pdo_error($dms_query, $wrapperObj->getLastStatement()); } foreach ($dms_result as $dms_row) { $thelabels .= ",\"" . str_replace('"', '\"', $dms_row["name"]) . "\""; $thevalues .= ",\"" . $dms_row["customer_id"] . "\""; } //GET TERRITORY ARRAY FOR ALL TERRITORY MULTI-SELECT LIST $terr_query = 'SELECT id, name FROM country ORDER BY name'; $terr_query_rs = $wrapperObj->executeQuery($terr_query, []); if ($terr_query_rs === false) { show_pdo_error($terr_query, $wrapperObj->getLastStatement()); } $territory_array = array(); $territory_result = array(); foreach ($terr_query_rs as $terr_query_row) { $territory_array[$terr_query_row['id']] = $terr_query_row['name']; $territory_result[$terr_query_row['name']] = $terr_query_row['id']; } $dms_master_query = 'SELECT customer_master_master_id, customer_name from customer_master_master order by customer_name'; $dms_master_result = $wrapperObj->executeQuery($dms_master_query, []); if ($dms_master_result === false) { show_pdo_error($dms_master_query, $wrapperObj->getLastStatement()); } ?> executeQuery($getCurrency, []); if ($getCurrency_rs === false) { show_pdo_error($getCurrency, $wrapperObj->getLastStatement()); } foreach ($getCurrency_rs as $getCurrency_row) { $currency_arr[$getCurrency_row['id']] = $getCurrency_row['currency_name'].' ('.$getCurrency_row['ISO_4217_code'].')'; } if($vendor_type=="vendor"){ ?> getServiceTypes($userId); ?>
* Orchard Closer:
Service Type:
Budgeted Advance: ">
(Enter 0 if no advance)
Proposed Term: ">
(Enter number of Years)
Proposed Rollover Period " class="small">
(Enter number of Years)
* Digital Distribution Type: executeQuery($distribution_type_query, []); if ($distribution_type_result === false) { show_pdo_error($distribution_type_query, $wrapperObj->getLastStatement()); } $i=0; foreach ($distribution_type_result as $distribution_type_row) { $distribution_type_name=$distribution_type_row['name']; $distribution_type_id=$distribution_type_row['id']; ?>
/>
Other Rights: onclick="checkOtherRights(this);">Any and All onclick="checkOtherRights(this);">Other > onclick="checkOtherRights(this);">None
Sound Recording Copyright Owner Representative:
Status:
Status Detail:
*Chance to Close:
* Estimated to Close:
* Encoding Fees Cap Back Catalog: onclick="$('input#encoding_fees_cap_back_ctlg').val('');">Default >Other
* Encoding Fees Cap New Release:

Extend term until amount is recouped?
Advance Recoupable Percentage:
For 75%, enter 0.75
Negotiated Changes:
* Digital Split
(eg. Enter 0.1 for 10%)
Physical Split
(eg. Enter 0.1 for 10%)
Possible Track Restriction Detail:
Take Full Track Publishing
Take Ringtone Publishing
Take Physical Full Track Publishing:
OMS Mechanical Administration Commission
Special Product Split:
Special Product Carveout:     Country


Select/Clear All 		Continent


Select/Clear All
* Payment Interval:
* Pay After:
* Payout Currency:
YouTube Composition Clause:
Opt-Out Clause:
Apply FX Spread:

Physical Reserves

Reserve Rate:

For 25%, enter 0.25
Reserves are taken from revenue minus returns
Please enter 0 for any custom reserve schedules
Number of months before payout starts:

Reserves will be held for the amount of periods entered
Payout will occur during the following month
Number of installments:

Installments are paid out over consecutive months
Contract Terms:

* Please be aware that these contract terms are client facing notes
Current Restrictions

DMS Master

executeQuery($sql, [$vendor_proposed_term_id]); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $customer_master_master_name_arr = array(); if (count($rs)) { 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){?>
    :

DMS

executeQuery($sql, $data_params); if ($dms_view_result === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $dms_row_arr = array(); if (count($dms_view_result)) { foreach ($dms_view_result as $dms_row) { array_push($dms_row_arr, $dms_row['name']); } } echo implode(', ', $dms_row_arr); ?>

Territory

executeQuery($sql, $data_params); if ($terr_view_result === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $terr_row_arr = array(); if (count($terr_view_result)) { foreach ($terr_view_result as $terr_row) { array_push($terr_row_arr, $terr_row['name']); } } echo implode(', ', $terr_row_arr); ?>

DMS Carveouts


Select/Clear All 		Territory

Select/Clear All 		Continent

Select/Clear All
Sync Admin Split
(For 75%, enter 0.75, enter 0 if no split)
Royalty Collection Split
(For 75%, enter 0.75, enter 0 if no split)
SX Royalty Collection Split
(For 75%, enter 0.75)
Orchard Compilation Agreement:
Orchard Compilation Split (Label Share):
(For 75%, enter 0.75)
Orchard Compilation Authorization Required:
Status
Syncronization Admin Territory
Select/Clear All
Royalty Collection Territory
Select/Clear All