executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } foreach ($rs as $row) { $orch_users_arr[$row['id']] = $row['name']; } $country_arr = array(); //get country name from id $sql = "select id, name from country"; $rs = $wrapperObj->executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } foreach ($rs as $row) { $country_arr[$row['id']] = $row['name']; } $dms_master_arr = array(); //get dms master name from id $sql = "select customer_id, name from customer_master"; $rs = $wrapperObj->executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } foreach ($rs as $row) { $dms_master_arr[$row['customer_id']] = $row['name']; } $dms_master_master_arr = array(); //get dms master master name from id $sql = "select customer_master_master_id, customer_name from customer_master_master"; $rs = $wrapperObj->executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } foreach ($rs as $row) { $dms_master_master_arr[$row['customer_master_master_id']] = $row['customer_name']; } $currency_arr = array(); $sql = "select currency_id, currency from currency"; $rs = $wrapperObj->executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } foreach ($rs as $row) { $currency_arr[$row['currency_id']] = $row['currency']; } //GET VENDOR PROPOSED TERM FIELDS $sql = "select vpt.vendor_proposed_term_id, if(vendor_type='vendor',(select company from vendor where vendor_id=vpt.vendor_id),(select company from oms_client where oms_client_id=vpt.vendor_id)) as company, vpt.parent_vendor_contract_id as contract_id, vpt.vendor_id, if(vpt.vendor_type='oms_client','omsclient','vendor') as vendor_type, vpt.proposed_territory_carve_out as territory_carve_out, vpt.proposed_dms_carve_out as dms_carve_out, (select group_concat(vpdr.customer_master_master_id) from vendor_proposed_dms_master_restriction vpdr where vpdr.vendor_proposed_term_id = vpt.vendor_proposed_term_id) as dms_master_carve_out, vpt.currency_id, vpt.sync_admin_commission, vpt.royalty_collection_commission, vpt.publishing_admin_commission, vpt.exclusive, vpt.negotiated_changes, vpt.encoding_fees_cap_back_ctlg, vpt.encoding_fees_cap_new_release, vpt.digital_split, vpt.physical_split, vpt.possible_track_restrictions, vpt.oms_type, vpt.oms_fee_percentage, vpt.marketing_restrictions, vpt.orchard_assignment_right_restriction, vpt.third_party_responsibility, (select group_concat(distribution_type_id) from vendor_proposed_term_distribution_type where vendor_proposed_term_id = vpt.vendor_proposed_term_id group by vpt.vendor_proposed_term_id) as distribution_type_ids , vpt.cont_start, vpt.cont_end, vpt.sync_admin_territory, vpt.sync_admin_response_time, vpt.sync_admin_type_of_deal, vpt.royalty_collection_territory, vpt.publishing_admin_territory, vpt.publishing_admin_limit_grant_of_rights, vpt.publishing_admin_misc_provisions, vpt.orchrep_name, vpt.parent_vendor_contract_id, vpt.ringtone_publishing_type, vpt.other_rights_option, vpt.other_rights_text, vpt.advance_recoupable_percentage, vpt.extend_until_recouped, vpt.special_product_split, vpt.special_product_carve_out, vpt.payment_interval, vpt.pay_after, vpt.show_credit_card, IF(vpt.accounting_approval IS NULL AND vpt.legal_approval IS NULL AND vpt.executive_approval IS NULL, 'accounting', IF(vpt.accounting_approval IS NOT NULL AND vpt.legal_approval IS NULL AND vpt.executive_approval IS NULL, 'legal', IF(vpt.accounting_approval IS NOT NULL AND vpt.legal_approval IS NOT NULL AND vpt.executive_approval IS NULL, 'executive','all'))) as role , vpca.amount, vpca.currency_id, vpca.due_type, vpca.date_paid, vpca.exchange_rate, vpca.description, vptc.orchard_compilation_agreement, vptc.orchard_compilation_split, vptc.orchard_compilation_authorization_required from vendor_proposed_term vpt left join vendor_proposed_contract_advance vpca on vpca.vendor_proposed_term_id = vpt.vendor_proposed_term_id left join vendor_proposed_term_compilation vptc ON vptc.vendor_proposed_term_id = vpt.vendor_proposed_term_id ".$whereClause; $rs = $wrapperObj->executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $vendor_proposed_terms_arr = array(); $vendors_oms_waiting = array(); foreach ($rs as $row) { $vendors_oms_waiting[] = $row['vendor_id']; $unique_key = $row['vendor_id'].'_'.$row['vendor_type'].'_'.($row['contract_id'] ? $row['contract_id'] : 'null'); $vendor_proposed_terms_arr[$unique_key]['contract_id'] = $row['contract_id']; $vendor_proposed_terms_arr[$unique_key]['vendor_id'] = $row['vendor_id']; $vendor_proposed_terms_arr[$unique_key]['vendor_type'] = $row['vendor_type']; $vendor_proposed_terms_arr[$unique_key]['company'] = $row['company']; $vendor_proposed_terms_arr[$unique_key]['currency_id'] = $row['currency_id']; $vendor_proposed_terms_arr[$unique_key]['sync_admin_commission'] = $row['sync_admin_commission']; $vendor_proposed_terms_arr[$unique_key]['royalty_collection_commission'] = $row['royalty_collection_commission']; $vendor_proposed_terms_arr[$unique_key]['publishing_admin_commission'] = $row['publishing_admin_commission']; $vendor_proposed_terms_arr[$unique_key]['exclusive'] = $row['exclusive']; $vendor_proposed_terms_arr[$unique_key]['negotiated_changes'] = $row['negotiated_changes']; $vendor_proposed_terms_arr[$unique_key]['encoding_fees_cap_back_ctlg'] = $row['encoding_fees_cap_back_ctlg']; $vendor_proposed_terms_arr[$unique_key]['encoding_fees_cap_new_release'] = $row['encoding_fees_cap_new_release']; $vendor_proposed_terms_arr[$unique_key]['digital_split'] = $row['digital_split']; $vendor_proposed_terms_arr[$unique_key]['physical_split'] = $row['physical_split']; $vendor_proposed_terms_arr[$unique_key]['possible_track_restrictions'] = $row['possible_track_restrictions']; $vendor_proposed_terms_arr[$unique_key]['oms_type'] = $row['oms_type']; $vendor_proposed_terms_arr[$unique_key]['oms_fee_percentage'] = $row['oms_fee_percentage']; $vendor_proposed_terms_arr[$unique_key]['marketing_restrictions'] = $row['marketing_restrictions']; $vendor_proposed_terms_arr[$unique_key]['orchard_assignment_right_restriction'] = $row['orchard_assignment_right_restriction']; $vendor_proposed_terms_arr[$unique_key]['third_party_responsibility'] = $row['third_party_responsibility']; $vendor_proposed_terms_arr[$unique_key]['distribution_type_ids'] = $row['distribution_type_ids']; $vendor_proposed_terms_arr[$unique_key]['sync_admin_territory'] = $row['sync_admin_territory']; $vendor_proposed_terms_arr[$unique_key]['sync_admin_response_time'] = $row['sync_admin_response_time']; $vendor_proposed_terms_arr[$unique_key]['sync_admin_type_of_deal'] = $row['sync_admin_type_of_deal']; $vendor_proposed_terms_arr[$unique_key]['royalty_collection_territory'] = $row['royalty_collection_territory']; $vendor_proposed_terms_arr[$unique_key]['publishing_admin_territory'] = $row['publishing_admin_territory']; $vendor_proposed_terms_arr[$unique_key]['publishing_admin_limit_grant_of_rights'] = $row['publishing_admin_limit_grant_of_rights']; $vendor_proposed_terms_arr[$unique_key]['publishing_admin_misc_provisions'] = $row['publishing_admin_misc_provisions']; $vendor_proposed_terms_arr[$unique_key]['orchrep_name'] = $row['orchrep_name']; $vendor_proposed_terms_arr[$unique_key]['parent_vendor_contract_id'] = $row['parent_vendor_contract_id']; $vendor_proposed_terms_arr[$unique_key]['territory_carve_out'] = $row['territory_carve_out']; $vendor_proposed_terms_arr[$unique_key]['dms_carve_out'] = $row['dms_carve_out']; $vendor_proposed_terms_arr[$unique_key]['dms_master_carve_out'] = $row['dms_master_carve_out']; $vendor_proposed_terms_arr[$unique_key]['role'] = $row['role']; $vendor_proposed_terms_arr[$unique_key]['vendor_proposed_term_id'] = $row['vendor_proposed_term_id']; $vendor_proposed_terms_arr[$unique_key]['amount'] = $row['amount']; $vendor_proposed_terms_arr[$unique_key]['currency_id'] = $row['currency_id']; $vendor_proposed_terms_arr[$unique_key]['due_type'] = $row['due_type']; $vendor_proposed_terms_arr[$unique_key]['description'] = $row['description']; $vendor_proposed_terms_arr[$unique_key]['ringtone_publishing_type'] = $row['ringtone_publishing_type']; $vendor_proposed_terms_arr[$unique_key]['advance_recoupable_percentage'] = $row['advance_recoupable_percentage']; $vendor_proposed_terms_arr[$unique_key]['extend_until_recouped'] = $row['extend_until_recouped']; $vendor_proposed_terms_arr[$unique_key]['other_rights_option'] = $row['other_rights_option']; $vendor_proposed_terms_arr[$unique_key]['other_rights_text'] = $row['other_rights_text']; $vendor_proposed_terms_arr[$unique_key]['special_product_split'] = $row['special_product_split']; $vendor_proposed_terms_arr[$unique_key]['special_product_carve_out'] = $row['special_product_carve_out']; $vendor_proposed_terms_arr[$unique_key]['payment_interval'] = $row['payment_interval']; $vendor_proposed_terms_arr[$unique_key]['pay_after'] = $row['pay_after']; $vendor_proposed_terms_arr[$unique_key]['show_credit_card'] = $row['show_credit_card']; $vendor_proposed_terms_arr[$unique_key]['orchard_compilation_agreement'] = $row['orchard_compilation_agreement']; $vendor_proposed_terms_arr[$unique_key]['orchard_compilation_split'] = $row['orchard_compilation_split']; $vendor_proposed_terms_arr[$unique_key]['orchard_compilation_authorization_required'] = $row['orchard_compilation_authorization_required']; } $vendor_contracts_arr = array(); if(count($vendors_oms_waiting)){ //GET VENDOR CONTRACT FIELDS $sql = "select if(vendor_type='vendor',(select company from vendor where vendor_id=vcon.vendor_id),(select company from oms_client where oms_client_id=vcon.vendor_id)) as company, vcon.id as contract_id, vcon.vendor_id, if(vcon.vendor_type='oms_client','omsclient','vendor') as vendor_type, vcon.territory_carve_out, vcon.dms_carve_out, (select group_concat(vpdr.customer_master_master_id) from vendor_dms_master_restriction vpdr where vpdr.vendor_contract_id = vcon.id) as dms_master_carve_out, vcon.currency_id, vcon.sync_admin_commission, vcon.royalty_collection_commission, vcon.publishing_admin_commission, vcon.exclusive, vcon.negotiated_changes, vcon.encoding_fees_cap_back_ctlg, vcon.encoding_fees_cap_new_release, vcon.digital_split, vcon.physical_split, vcon.possible_track_restrictions, vcon.oms_type, vcon.oms_fee_percentage, vcon.marketing_restrictions, vcon.orchard_assignment_right_restriction, vcon.third_party_responsibility, (select group_concat(distribution_type_id) from vendor_contract_distribution_type where vendor_contract_id = vcon.id group by vcon.id) as distribution_type_ids, vcon.cont_start, vcon.cont_end, vcon.sync_admin_territory, vcon.sync_admin_response_time, vcon.sync_admin_type_of_deal, vcon.royalty_collection_territory, vcon.publishing_admin_territory, vcon.publishing_admin_limit_grant_of_rights, vcon.publishing_admin_misc_provisions, vcon.orchrep_name, vcon.ringtone_publishing_type, vcon.parent_vendor_contract_id, vcon.advance_recoupable_percentage, vcon.extend_until_recouped, vcon.other_rights_option, vcon.other_rights_text, vcon.special_product_split, vcon.special_product_carve_out, vcon.payment_interval, vcon.pay_after, vcon.show_credit_card, vca.amount, vcon.currency_id, vca.due_type, vca.date_paid, vca.exchange_rate, vca.description, vcc.orchard_compilation_agreement, vcc.orchard_compilation_split, vcc.orchard_compilation_authorization_required from vendor_contract vcon left join vendor_contract_advance vca on vca.contract_id = vcon.id left join vendor_contract_compilation vcc ON vcc.vendor_contract_id = vcon.id where vcon.vendor_id in(0".implode(',',$vendors_oms_waiting).") "; $rs = $wrapperObj->executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } foreach ($rs as $row) { $unique_key = $row['vendor_id'].'_'.$row['vendor_type'].'_'.($row['contract_id'] ? $row['contract_id'] : 'null'); $vendor_contracts_arr[$unique_key]['contract_id'] = $row['contract_id']; $vendor_contracts_arr[$unique_key]['vendor_id'] = $row['vendor_id']; $vendor_contracts_arr[$unique_key]['vendor_type'] = $row['vendor_type']; $vendor_contracts_arr[$unique_key]['company'] = $row['company']; $vendor_contracts_arr[$unique_key]['currency_id'] = $row['currency_id']; $vendor_contracts_arr[$unique_key]['sync_admin_commission'] = $row['sync_admin_commission']; $vendor_contracts_arr[$unique_key]['royalty_collection_commission'] = $row['royalty_collection_commission']; $vendor_contracts_arr[$unique_key]['publishing_admin_commission'] = $row['publishing_admin_commission']; $vendor_contracts_arr[$unique_key]['exclusive'] = $row['exclusive']; $vendor_contracts_arr[$unique_key]['negotiated_changes'] = $row['negotiated_changes']; $vendor_contracts_arr[$unique_key]['encoding_fees_cap_back_ctlg'] = $row['encoding_fees_cap_back_ctlg']; $vendor_contracts_arr[$unique_key]['encoding_fees_cap_new_release'] = $row['encoding_fees_cap_new_release']; $vendor_contracts_arr[$unique_key]['digital_split'] = $row['digital_split']; $vendor_contracts_arr[$unique_key]['physical_split'] = $row['physical_split']; $vendor_contracts_arr[$unique_key]['possible_track_restrictions'] = $row['possible_track_restrictions']; $vendor_contracts_arr[$unique_key]['oms_type'] = $row['oms_type']; $vendor_contracts_arr[$unique_key]['oms_fee_percentage'] = $row['oms_fee_percentage']; $vendor_contracts_arr[$unique_key]['marketing_restrictions'] = $row['marketing_restrictions']; $vendor_contracts_arr[$unique_key]['orchard_assignment_right_restriction'] = $row['orchard_assignment_right_restriction']; $vendor_contracts_arr[$unique_key]['third_party_responsibility'] = $row['third_party_responsibility']; $vendor_contracts_arr[$unique_key]['distribution_type_ids'] = $row['distribution_type_ids']; $vendor_contracts_arr[$unique_key]['sync_admin_territory'] = $row['sync_admin_territory']; $vendor_contracts_arr[$unique_key]['sync_admin_response_time'] = $row['sync_admin_response_time']; $vendor_contracts_arr[$unique_key]['sync_admin_type_of_deal'] = $row['sync_admin_type_of_deal']; $vendor_contracts_arr[$unique_key]['royalty_collection_territory'] = $row['royalty_collection_territory']; $vendor_contracts_arr[$unique_key]['publishing_admin_territory'] = $row['publishing_admin_territory']; $vendor_contracts_arr[$unique_key]['publishing_admin_limit_grant_of_rights'] = $row['publishing_admin_limit_grant_of_rights']; $vendor_contracts_arr[$unique_key]['publishing_admin_misc_provisions'] = $row['publishing_admin_misc_provisions']; $vendor_contracts_arr[$unique_key]['orchrep_name'] = $row['orchrep_name']; $vendor_contracts_arr[$unique_key]['parent_vendor_contract_id'] = $row['parent_vendor_contract_id']; $vendor_contracts_arr[$unique_key]['territory_carve_out'] = $row['territory_carve_out']; $vendor_contracts_arr[$unique_key]['dms_carve_out'] = $row['dms_carve_out']; $vendor_contracts_arr[$unique_key]['dms_master_carve_out'] = $row['dms_master_carve_out']; $vendor_contracts_arr[$unique_key]['role'] = ''; $vendor_contracts_arr[$unique_key]['vendor_proposed_term_id'] = ''; $vendor_contracts_arr[$unique_key]['amount'] = $row['amount']; $vendor_contracts_arr[$unique_key]['currency_id'] = $row['currency_id']; $vendor_contracts_arr[$unique_key]['due_type'] = $row['due_type']; $vendor_contracts_arr[$unique_key]['description'] = $row['description']; $vendor_contracts_arr[$unique_key]['ringtone_publishing_type'] = $row['ringtone_publishing_type']; $vendor_contracts_arr[$unique_key]['advance_recoupable_percentage'] = $row['advance_recoupable_percentage']; $vendor_contracts_arr[$unique_key]['extend_until_recouped'] = $row['extend_until_recouped']; $vendor_contracts_arr[$unique_key]['other_rights_option'] = $row['other_rights_option']; $vendor_contracts_arr[$unique_key]['other_rights_text'] = $row['other_rights_text']; $vendor_contracts_arr[$unique_key]['special_product_split'] = $row['special_product_split']; $vendor_contracts_arr[$unique_key]['special_product_carve_out'] = $row['special_product_carve_out']; $vendor_contracts_arr[$unique_key]['payment_interval'] = $row['payment_interval']; $vendor_contracts_arr[$unique_key]['pay_after'] = $row['pay_after']; $vendor_contracts_arr[$unique_key]['show_credit_card'] = $row['show_credit_card']; $vendor_contracts_arr[$unique_key]['orchard_compilation_agreement'] = $row['orchard_compilation_agreement']; $vendor_contracts_arr[$unique_key]['orchard_compilation_split'] = $row['orchard_compilation_split']; $vendor_contracts_arr[$unique_key]['orchard_compilation_authorization_required'] = $row['orchard_compilation_authorization_required']; } } //THESE ARE THE DEFAULT VALUES FOR A NEW DRAFT CONTRACT. HOLD OFF BY ESHAH /* $default_value_arr = array( "contract_id"=>0, "vendor_id"=>0, "company"=>0, "currency_id"=>'', "sync_admin_commission"=>0, "royalty_collection_commission"=>0, "publishing_admin_commission"=>0, "exclusive"=>'', "negotiated_changes"=>'', "encoding_fees_cap_back_ctlg"=>0, "encoding_fees_cap_new_release"=>0, "digital_split"=>0, "physical_split"=>0, "possible_track_restrictions"=>'', "oms_type"=>'', "oms_fee_percentage"=>'', "marketing_restrictions"=>'', "orchard_assignment_right_restriction"=>'', "third_party_responsibility"=>'', "distribution_type_ids"=>'', "cont_start"=>0, "cont_end"=>0, "sync_admin_territory"=>'', "sync_admin_response_time"=>0, "sync_admin_type_of_deal"=>'', "royalty_collection_territory"=>'', "publishing_admin_territory"=>'', "publishing_admin_limit_grant_of_rights"=>'', "publishing_admin_misc_provisions"=>'', "orchrep_name"=>0, "parent_vendor_contract_id"=>0, "vendor_type"=>'', "territory_carve_out"=>'', "dms_carve_out"=>'', "dms_master_carve_out"=>'' );*/ $big_array = array(); //NEW PROPOSED TERM IS ADDED AS FULL FORM. FIELDS ARE COMPARED WITH DEFAULT VALUE $full_form_changes = array(); foreach($vendor_proposed_terms_arr as $key=>$value){ $tmp_key = explode('_',$key); if($tmp_key[2]=='null'){ $full_form_changes[$key] = $vendor_proposed_terms_arr[$key]; } } //PROPOSED TERM WAS CREATED AS AMENDMENT. FIELDS ARE COMPARED WITH ITS PARENT CONTRACT $amendment_changes = array(); $amendment_changes = array_intersect_key($vendor_contracts_arr,$vendor_proposed_terms_arr); //echo "
";
	//print_r($full_form_changes);
	//print_r($vendor_proposed_terms_arr);
	//echo "
"; //exit(); //PUT ALL CONTRACTS IN THE BIG DISPLAY ARRAY //IF THE DRAFT CONTRACT IS NOT AN AMENDMENT, JUST COPY THE WHOLE THING TO BIG ARRAY, IF IT IS, GET THE DIFFERENCE ONLY foreach($full_form_changes as $key=>$value){ //$big_array[$key] = compare_contracts($default_value_arr,$full_form_changes[$key],array('parent_vendor_contract_id','vendor_type','contract_id','vendor_id','company')); $big_array[$key] = $full_form_changes[$key]; } foreach($amendment_changes as $key=>$value){ $big_array[$key] = compare_contracts($vendor_contracts_arr[$key],$vendor_proposed_terms_arr[$key],array('parent_vendor_contract_id','vendor_type','contract_id','vendor_id','company')); } if($user_role != 'all' && $user_role){ switch ($sort_by){ case 'company': $order_by = 'company'; $big_array = multisort($big_array,'company',($sort_desc ? false : true),1); break; case 'contact_name': $order_by = 'contact_name'; $big_array = multisort($big_array,'contact_name',($sort_desc ? false : true),1); break; case 'priority': $order_by = "priority"; $big_array = multisort($big_array,'priority',($sort_desc ? false : true),1); break; case 'orch_rep': $order_by = "orch_rep"; $big_array = multisort($big_array,'orch_rep',($sort_desc ? false : true),1); break; default: $order_by = "company"; $sort_by ='company'; $sort_desc = 0; $big_array = multisort($big_array,'company',($sort_desc ? false : true),1); } $total = count($big_array); if($pageRecord){ $pageNum = ceil($total/$pageRecord); } $big_array = array_slice($big_array, ($page-1)*$pageRecord, $pageRecord); if ($total && !$reason_of_rejection && $user_role) { echo paginate($page, $pageRecord, $pageNum, $varQueryString, 'top'); } if($reason_of_rejection){?>

Label Contract Approval

Reason of Rejection:

Label Contract Approval

$row){ $row_class = (++$rci & 1) ? '' : 'alt'; $tmp_key = explode('_',$key); $is_amendment = $tmp_key[2]=="null" ? false : true; //CHECK IF THERE IS A REJECTION BEFORE. IF YES, GRAB THE LAST REJECTION AND DISPLAY $sql = "SELECT id, date_changed, date_rejected, rejected_by, reason_of_rejection, change_detail FROM vendor_proposed_term_change_history vptch WHERE vptch.vendor_proposed_term_id = ".$row['vendor_proposed_term_id']." and date_changed >= ( SELECT date_rejected FROM vendor_proposed_term_change_history WHERE date_rejected is not null and vendor_proposed_term_id = ".$row['vendor_proposed_term_id']." ORDER BY date_rejected desc limit 1 ) order by date_changed"; $rs = $wrapperObj->executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $has_rejection_history = false; //THIS ARRAY STORE THE HISTORY ON AND BEYOND THE LAST DATE OF REJECTION $history_arr = array(); foreach ($rs as $get_rejection_row) { $history_arr[$get_rejection_row['id']]['date_changed'] = $get_rejection_row['date_changed']; $history_arr[$get_rejection_row['id']]['date_rejected'] = $get_rejection_row['date_rejected']; $history_arr[$get_rejection_row['id']]['rejected_by'] = $get_rejection_row['rejected_by']; $history_arr[$get_rejection_row['id']]['reason_of_rejection'] = $get_rejection_row['reason_of_rejection']; $history_arr[$get_rejection_row['id']]['change_detail'] = $get_rejection_row['change_detail']; } if(count($history_arr)){ $has_rejection_history = true;} ?>
, Contract | View Draft Contract | View Parent Contract
    $field_value){ if($row['vendor_type']=='omsclient'){ if(!in_array($field_name,$oms_fields)){ continue; } } if(!in_array($field_name, $carveout_fields)){ $difference_arr = added_removed($field_value['old'],$field_value['new']); if(in_array($field_name,$terr_fields)){ $difference_arr['added'] = GetTerrName($difference_arr['added'], $wrapperObj); $difference_arr['removed'] = GetTerrName($difference_arr['removed'], $wrapperObj); }elseif($field_name == "dms_carve_out"){ $difference_arr['added'] = GetCMName($difference_arr['added'], $wrapperObj); $difference_arr['removed'] = GetCMName($difference_arr['removed'], $wrapperObj); }elseif($field_name == "dms_master_carve_out"){ $difference_arr['added'] = GetCMMName($difference_arr['added'], $wrapperObj); $difference_arr['removed'] = GetCMMName($difference_arr['removed'], $wrapperObj); } ?>
  • : Added - ; Removed -
    • $field_value){ if($row['vendor_type']=='omsclient'){ if(!in_array($field_name,$oms_fields)){ continue; } } if(!in_array($field_name, $carveout_fields)){ if(in_array($field_name,$terr_fields)){ $field_value = GetTerrName($field_value, $wrapperObj); }elseif($field_name == "dms_carve_out"){ $field_value = GetCMName($field_value, $wrapperObj); }elseif($field_name == "dms_master_carve_out"){ $field_value = GetCMMName($field_value, $wrapperObj); }elseif($field_name == "orchrep_name"){ $field_value = getRepName($field_value, $wrapperObj); }elseif($field_name == "distribution_type_ids"){ $field_value = GetDistName($field_value, $wrapperObj); } ?>
  • :
$value){ if($value['date_rejected']){?>

Note: This deal was previously rejected on by because ""

The following changes were made since last rejection:

$value){ if(!$value['date_rejected']){?>

No label is waiting for approval.
"; // print_r($big_array); // echo ""; // exit(); //=====================================================IF USER ROLE IS ALL============================================================== if($reason_of_rejection){?>

Label Contract Approval

Reason of Rejection:
$value){ if($value['role']=='accounting'){ $big_array_for_accounting[$key] = $big_array[$key]; } if($value['role']=='legal'){ $big_array_for_legal[$key] = $big_array[$key]; } if($value['role']=='executive'){ $big_array_for_executive[$key] = $big_array[$key]; } } //FOLLOWING LOOP IS RUN 3 TIMES FOR DISPLAYING THE SAME PANEL FOR THREE ROLES if($display_only == 'accounting'){ $role_arr = array('accounting'); }elseif ($display_only == 'legal'){ $role_arr = array('legal'); }elseif ($display_only == 'executive'){ $role_arr = array('executive'); }else{ $role_arr = array('accounting','legal','executive'); } foreach($role_arr as $ro){ $tmp_array = ${'big_array_for_'.$ro}; //=======================================SORTING ON ARRAYS FOR DIFFERENT ROLES================================================= if($display_only!='all'){ switch ($sort_by){ case 'company': $order_by = 'company'; $tmp_array = multisort($tmp_array,'company',($sort_desc ? false : true),1); break; case 'contact_name': $order_by = 'contact_name'; $tmp_array = multisort($tmp_array,'contact_name',($sort_desc ? false : true),1); break; case 'priority': $order_by = "priority"; $tmp_array = multisort($tmp_array,'priority',($sort_desc ? false : true),1); break; case 'orch_rep': $order_by = "orch_rep"; $tmp_array = multisort($tmp_array,'orch_rep',($sort_desc ? false : true),1); break; default: $order_by = "company"; $sort_by ='company'; $sort_desc = 0; $tmp_array = multisort($tmp_array,'company',($sort_desc ? false : true),1); } $total = count($tmp_array); if($pageRecord){ $pageNum = ceil($total/$pageRecord); } $tmp_array = array_slice($tmp_array, ($page-1)*$pageRecord, $pageRecord); } if ($total && !$reason_of_rejection && $ro) { echo paginate($page, $pageRecord, $pageNum, $varQueryString, 'top'); } ?>

Label Contract Approval -

$row){ $row_class = (++$rci & 1) ? '' : 'alt'; $tmp_key = explode('_',$key); $is_amendment = $tmp_key[2]=="null" ? false : true; //CHECK IF THERE IS A REJECTION BEFORE. IF YES, GRAB THE LAST REJECTION AND DISPLAY $sql = "SELECT id, date_changed, date_rejected, rejected_by, reason_of_rejection, change_detail FROM vendor_proposed_term_change_history vptch WHERE vptch.vendor_proposed_term_id = ".$row['vendor_proposed_term_id']." and date_changed >= ( SELECT date_rejected FROM vendor_proposed_term_change_history WHERE date_rejected is not null and vendor_proposed_term_id = ".$row['vendor_proposed_term_id']." ORDER BY date_rejected desc limit 1 ) order by date_changed"; $rs = $wrapperObj->executeQuery($sql, []); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } $has_rejection_history = false; //THIS ARRAY STORE THE HISTORY ON AND BEYOND THE LAST DATE OF REJECTION $history_arr = array(); foreach ($rs as $get_rejection_row) { $history_arr[$get_rejection_row['id']]['date_changed'] = $get_rejection_row['date_changed']; $history_arr[$get_rejection_row['id']]['date_rejected'] = $get_rejection_row['date_rejected']; $history_arr[$get_rejection_row['id']]['rejected_by'] = $get_rejection_row['rejected_by']; $history_arr[$get_rejection_row['id']]['reason_of_rejection'] = $get_rejection_row['reason_of_rejection']; $history_arr[$get_rejection_row['id']]['change_detail'] = $get_rejection_row['change_detail']; } if(count($history_arr)){ $has_rejection_history = true;} ?>
, Contract | View Draft Contract | View Parent Contract
    $field_value){ if($row['vendor_type']=='omsclient'){ if(!in_array($field_name,$oms_fields)){ continue; } } if(!in_array($field_name, $carveout_fields)){ $difference_arr = added_removed($field_value['old'],$field_value['new']); if(in_array($field_name,$terr_fields)){ $difference_arr['added'] = GetTerrName($difference_arr['added'], $wrapperObj); $difference_arr['removed'] = GetTerrName($difference_arr['removed'], $wrapperObj); }elseif($field_name == "dms_carve_out"){ $difference_arr['added'] = GetCMName($difference_arr['added'], $wrapperObj); $difference_arr['removed'] = GetCMName($difference_arr['removed'], $wrapperObj); }elseif($field_name == "dms_master_carve_out"){ $difference_arr['added'] = GetCMMName($difference_arr['added'], $wrapperObj); $difference_arr['removed'] = GetCMMName($difference_arr['removed'], $wrapperObj); } ?>
  • : Added - ; Removed -
    • $field_value){ if($row['vendor_type']=='omsclient'){ if(!in_array($field_name,$oms_fields)){ continue; } } if(!in_array($field_name, $carveout_fields)){ if(in_array($field_name,$terr_fields)){ $field_value = GetTerrName($field_value, $wrapperObj); }elseif($field_name == "dms_carve_out"){ $field_value = GetCMName($field_value, $wrapperObj); }elseif($field_name == "dms_master_carve_out"){ $field_value = GetCMMName($field_value, $wrapperObj); }elseif($field_name == "orchrep_name"){ $field_value = getRepName($field_value, $wrapperObj); }elseif($field_name == "distribution_type_ids"){ $field_value = GetDistName($field_value, $wrapperObj); } ?>
  • :
$value){ if($value['date_rejected']){?>

Note: This deal was previously rejected on by because ""

The following changes were made since last rejection:

$value){ if(!$value['date_rejected']){?>