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']; } if($vendor_type == "vendor"){ ?>
| Orchard Closer: | executeQuery($user_query, $data_params); if ($user_result === false) { show_pdo_error($user_query, $wrapperObj->getLastStatement()); } if (count($user_result)) { ?> =$user_result[0]['f_name'] . ' ' . $user_result[0]['l_name']?> |
|---|---|
| Budgeted Advance: | =$budgeted_advance?> |
| Advance Offered: | =$advance_offered?> |
| Advance Recoupment Explanation: | =$advance_recoup_explanation?> |
| Payout Currency: | =$currency_arr[$currency_id]?> |
| Proposed Term (Years): | =$proposed_term?> |
| Proposed Rollover Period (Years): | =$proposed_rollover_period?> |
| Digital Distribution Type: | if(!empty($distribution_type) && is_array($distribution_type) && isset($distribution_type[0])){ $distribution_type_name = array(); $sql = 'select name from distribution_type dt where id in (' . implode(', ', array_fill(0, count($distribution_type), '?')) . ')'; $data_params = []; foreach ($distribution_type as $type) { $data_params[] = $type; } $rs = $wrapperObj->executeQuery($sql, $data_params); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } if (count($rs)) { foreach ($rs as $row) { $distribution_type_name[] = $row['name']; } } echo implode(',',$distribution_type_name); } ?> |
| Sound Recording Copyright Owner Representative: | =($srco_rep=='Y' ? 'Yes' : ($srco_rep=='N' ? 'N' : '')) ?> |
| Synchronization Admin: | =$sync_admin_commission?> |
| Status: | =ucwords(str_replace('_',' ',$pro_status))?> |
| Chance to Close: | =($chance_to_close < 1) ? (($chance_to_close*100).'%') : ''?> |
| Show Credit Card: | =$show_credit_card?> |
| Estimated to Close: | =$eta_to_close_year.'Q'.$eta_to_close_quarter?> |
|---|---|
| Exclusive: | =ucwords(str_replace('_',' ',$exclusive))?> |
| Encoding Fees Cap Back Catalog: | =$encoding_fees_cap_back_ctlg?> |
| Encoding Fees Cap New Release: | =$encoding_fees_cap_new_release?> |
| Rights Granted: | if(count($rights_granted)){ $rights_granted_arr = array(); foreach($rights_granted as $v){ $rights_granted_arr[] = ucwords(str_replace('_',' ',$v)); } echo implode(',',$rights_granted_arr); } ?> |
| YouTube Composition Clause: | =($youtube_composition_clause=='Y' ? 'Yes' : 'No')?> |
| Opt-Out Clause: | =($opt_out=='Y' ? 'Yes' : 'No')?> |
| Apply FX Spread: | =($apply_fx_spread=='Y' ? 'Yes' : 'No')?> |
| Negotiated Changes: | =$negotiated_changes?> |
|---|---|
| Digital Split: | =$digital_split?> |
| Physical Split: | =$physical_split?> |
| Possible Track Restrictions: | =$possible_track_restrictions=='Y' ? 'Yes' : ($possible_track_restrictions=='N' ? 'No' : '')?> |
| Take Full Track Publishing from: | =$oms_type?> |
| Take Ringtone Publishing from: | =$ringtone_publishing_type?> |
| OMS Mechanical Administration Commission: | =$oms_fee_percentage ? (($oms_fee_percentage*100).'%') : ''?> |
| Marketing Restrictions: | =$marketing_restrictions=='Y' ? 'Yes' : ($marketing_restrictions=='N' ? 'No' : '')?> |
| Orchard Assignment Right Restriction: | =$orchard_assignment_right_restriction=='Y' ? 'Yes' : ($orchard_assignment_right_restriction=='N' ? 'No' : '')?> |
| Third Party Responsibility: | =ucwords($third_party_responsibility)?> |
| Additional Requests/Explanations/Notes: | =htmlspecialchars(stripslashes($additional_notes))?> |
|---|
| Reserve Rate: | =$reserveRate*100?>% |
|---|---|
| Number of months before payout starts: | =$numberOfMonths?> |
| Number of installments: | =$numberOfInstallments?> |
| Contract Terms: | =$contractTerms?> |
|---|
| Current Restrictions | |||
DMS Master $sql_old = 'SELECT customer_name FROM customer_master_master WHERE customer_master_master_id IN (0' . trim($dms_master_carveout_str,',') . ') ORDER BY customer_name'; $sql = "select vcdg.vendor_proposed_term_id, vcdg.customer_master_master_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_proposed_dms_master_restriction vcdg inner join customer_master_master cmm on cmm.customer_master_master_id = vcdg.customer_master_master_id where vcdg.vendor_proposed_term_id = ?"; $dms_master_view_result = $wrapperObj->executeQuery($sql, [$vendor_proposed_term_id]); if ($dms_master_view_result === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $dms_master_row_arr = array(); $dms_master_restriction_str = ''; if (count($dms_master_view_result)) { foreach ($dms_master_view_result as $row) { $dms_master_row_arr[$row['distribution_type']][] = $row['customer_master_master_name']; $dms_master_restriction_str = (!empty($dms_master_restriction_str) ? $dms_master_restriction_str . ',' : '') . $row['customer_master_master_id']; } } foreach($dms_master_row_arr as $k=>$v){?>
|
DMS Carveouts $dms_row_arr = array(); $dms_carveout_arr = array(); if($dms_carveout_str){ $dms_carveout_arr = explode(',', $dms_carveout_str); $sql = 'SELECT name FROM customer_master WHERE customer_id IN (' . implode(', ', array_fill(0, count($dms_carveout_arr), '?')) . ') ORDER BY name'; $data_params = []; foreach ($dms_carveout_arr as $str) { $data_params[] = $str; } $dms_view_result = $wrapperObj->executeQuery($sql, $data_params); if ($dms_view_result === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } 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 $territory_carveout_arr = array(); if($territory_carveout_str){ $territory_carveout_arr = explode(',', $territory_carveout_str); $sql = 'SELECT name FROM country WHERE id IN (' . implode(', ', array_fill(0, count($territory_carveout_arr), '?')) . ') ORDER BY name'; $data_params = []; foreach ($territory_carveout_arr as $territory) { $data_params[] = $territory; } $terr_view_result = $wrapperObj->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"]); } } } if(!empty($terr_row_arr)) echo implode(', ',$terr_row_arr); ?> |
|
| Sync Admin Split: | =$sync_admin_commission?> |
|---|---|
| Sync Admin Response Time: | =$sync_admin_response_time?> |
| Sync Admin Type of Deal: | =ucwords(str_replace('_',' ',$sync_admin_type_of_deal))?> |
| Publishing Administration Split: | =$publishing_admin_commission?> |
| Publishing Administration Limit Grant of Rights: | =$publishing_admin_limit_grant_of_rights?> |
| Publishing Administration Misc Previsions: | =$publishing_admin_misc_provisions?> |
| Royalty Collection Split: | =$royalty_collection_commission?> |
| Orchard Compilation Agreement: | echo ($orchard_compilation_agreement=='Y' ? 'Yes' : 'No')?> |
| Orchard Compilation Split (Label Share): | echo ($orchard_compilation_split * 100).'%'?> |
| Orchard Compilation Authorization Required: | echo ($orchard_compilation_authorization_required=='Y' ? 'Yes' : 'No')?> |
| Syncronization Admin Territory: | $sync_admin_territory_arr = array(); if($sync_admin_territory){ $sync_admin_territory_arr = explode(',', $sync_admin_territory); $sql = 'SELECT name FROM country WHERE id IN (' . implode(', ', array_fill(0, count($sync_admin_territory_arr), '?')) . ') ORDER BY name'; $data_params = []; foreach ($sync_admin_territory_arr as $territory) { $data_params[] = $territory; } $terr_result = $wrapperObj->executeQuery($sql, $data_params); if ($terr_result === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $terr_row_arr = array(); if (count($terr_result)) { foreach ($terr_result as $terr_row) { array_push($terr_row_arr, $terr_row["name"]); } } } if(!empty($terr_row_arr)) echo implode(',',$terr_row_arr); ?> |
|---|---|
| Publishing Admin Territory: | $publishing_admin_territory_arr = array(); if($publishing_admin_territory){ $publishing_admin_territory_arr = explode(',', $publishing_admin_territory); $sql = 'SELECT name FROM country WHERE id IN (' . implode(', ', array_fill(0, count($publishing_admin_territory_arr), '?')) . ') ORDER BY name'; $data_params = []; foreach ($publishing_admin_territory_arr as $territory) { $data_params[] = $territory; } $terr_result = $wrapperObj->executeQuery($sql, $data_params); if ($terr_result === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $terr_row_arr = array(); if (count($terr_result)) { foreach ($terr_result as $terr_row) { array_push($terr_row_arr, $terr_row["name"]); } } } if(!empty($terr_row_arr)) echo implode(',',$terr_row_arr); ?> |
| Royalty Collection Territory: | $royalty_collection_territory_arr = array(); if($royalty_collection_territory){ $royalty_collection_territory_arr = explode(',', $royalty_collection_territory); $sql = 'SELECT name FROM country WHERE id IN (' . implode(', ', array_fill(0, count($royalty_collection_territory_arr), '?')) . ') ORDER BY name'; $data_params = []; foreach ($royalty_collection_territory_arr as $territory) { $data_params[] = $territory; } $terr_result = $wrapperObj->executeQuery($sql, $data_params); if ($terr_result === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $terr_row_arr = array(); if (count($terr_result)) { foreach ($terr_result as $terr_row) { array_push($terr_row_arr, $terr_row["name"]); } } } if(!empty($terr_row_arr)) echo implode(',',$terr_row_arr); ?> |