<?
require_once __DIR__ . '/../../../vendor/autoload.php';

use Orchard\Mysqli\QueryData;
use Orchard\Mysqli\Wrapper as MysqliWrapper;
use Orchard\Service\Ows\Product as OwsProductServiceClient;
use Orchard\Service\Ows\Contracts as OwsContractsServiceClient;
use Orchard\FeatureFlags\Context\AccountContext;
use Orchard\FeatureFlags\FeatureService;
use Orchard\Service\Ows\Track as OwsTrackServiceClient;
use Web\Accounting\ProductTerritorySplit;

function build_sorter($key)
{
    return function ($a, $b) use ($key) {
        return strnatcmp(strtolower($a[$key]), strtolower($b[$key]));
    };
}

$logger = Zend_Registry::get('applicationLoggerOA');
$featuresServiceClient = new FeatureService($logger);
$userContext = AccountContext::fromLegacy((string)$_SESSION['S_USERID'], 'oa');
$productTerritorySplitEnabled = $featuresServiceClient->isVariant(
    'product_by_territory_split',
    'enabled',
    $userContext
);
$wrapperObj = new MysqliWrapper($mysqli);
$pdoWrapperObj = getPDOQueryWrapper();

$owsContracts = new OwsContractsServiceClient(logger: $logger);
$hideContractDetails = hideContractDetails($vendor_id);
$userId = $_SESSION['S_USERID'];

switch ($sort_by) {
	case 'name':
		$order_by = 'name';
		break;
	case 'ctype':
		$order_by = 'vc.master';
		break;
	default:
		$order_by = 'name';
}
$activeTermfields = 'vcon.unlimited_roll, vcon.rollover_length_in_months, vcon.payment_interval, ';

$serviceDMSMasterArrangements = array(451,549,570,682,705,1277,1351,1505,1594,1608,1609,1611,1613,1614,1621,
    1622,1624,1626,1628,1631,1632,1633,1646,1647,1650,1651,1652,1653,1654,1655,1656,1657,1658,1662,1663,1666,
    1670,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681);

if($vendor_type == "vendor"){
        $sql = "select vcon.id as contract_id, vcon.contract_type, vcon.digital_split, vcon.physical_split, " . $activeTermfields . "
        group_concat(dt.name) as dist_type, vcon.oms_fee_percentage, vcon.sync_admin_commission,
        vcon.royalty_collection_commission, vcon.sx_royalty_collection_commission, vcon.topspin_rate,
        vcon.publishing_admin_commission, vcon.cont_start, IF(vcon.contract_type = 'per_release_term',
        if(vcon.cont_start = '0000-00-00' or vcon.release_term <= 0,'0000-00-00',vcon.cont_start + interval vcon.release_term month),vcon.cont_end) AS contract_end,
        concat(ou.f_name, ' ', ou.l_name) as orchrep_name, vcc.orchard_compilation_split
        from vendor_contract vcon
        left join vendor_contract_distribution_type vcdt on vcdt.vendor_contract_id = vcon.id
        left join orchadmin_users ou ON ou.id=vcon.orchrep_name
        inner join distribution_type dt on dt.id = vcdt.distribution_type_id
        left join vendor_contract_compilation vcc ON vcc.vendor_contract_id = vcon.id
        where vcon.vendor_id = ? and vcon.cont_start <= '".date("Y-m-d")."' and vcon.vendor_type = 'vendor'
        group by vcon.id
        HAVING contract_end >= '".date("Y-m-d")."' OR contract_end = '0000-00-00' OR contract_end IS NULL";
}else{
	$sql = "select vcon.id as contract_id, vcon.sync_admin_commission, vcon.royalty_collection_commission, vcon.sx_royalty_collection_commission, vcon.topspin_rate, vcon.publishing_admin_commission, vcon.cont_start, vcon.cont_end AS contract_end, concat(ou.f_name, ' ', ou.l_name) as vcon.orchrep_name
				from vendor_contract vcon
				left join orchadmin_users ou ON ou.id=vcon.orchrep_name
				where vcon.vendor_id = ? and vcon.cont_start <= '".date("Y-m-d")."' and vcon.vendor_type = 'oms_client'
				group by vcon.id
				HAVING contract_end >= '".date("Y-m-d")."' OR contract_end = '0000-00-00' OR contract_end IS NULL";
}
$dataParams = new QueryData();
$dataParams->addDataParam('i', $vendor_id);
$contacts_data = $wrapperObj->executeQuery($sql, $dataParams);
if ($contacts_data === false) {
    showierror($sql);
}

$contract_arr = array();
$contract_start_arr = array();
$contract_end_arr = array();
foreach ($contacts_data as $contacts_data_row) {
	$contract_arr[$contacts_data_row['contract_id']]['contract_id'] = $contacts_data_row['contract_id'];
	$contract_arr[$contacts_data_row['contract_id']]['cont_start'] = $contacts_data_row['cont_start'];
	$contract_arr[$contacts_data_row['contract_id']]['contract_end'] = $contacts_data_row['contract_end'];
	$contract_arr[$contacts_data_row['contract_id']]['sync_admin_commission'] = $contacts_data_row['sync_admin_commission'];
	$contract_arr[$contacts_data_row['contract_id']]['royalty_collection_commission'] = $contacts_data_row['royalty_collection_commission'];
	$contract_arr[$contacts_data_row['contract_id']]['sx_royalty_collection_commission'] = $contacts_data_row['sx_royalty_collection_commission'];
	$contract_arr[$contacts_data_row['contract_id']]['topspin_rate'] = $contacts_data_row['topspin_rate'];
	$contract_arr[$contacts_data_row['contract_id']]['publishing_admin_commission'] = $contacts_data_row['publishing_admin_commission'];
	$contract_arr[$contacts_data_row['contract_id']]['orchrep_name'] = $contacts_data_row['orchrep_name'];
    $contract_arr[$contacts_data_row['contract_id']]['unlimited_roll'] = $contacts_data_row['unlimited_roll'];
    $contract_arr[$contacts_data_row['contract_id']]['rollover_length_in_months'] = $contacts_data_row['rollover_length_in_months'];
    $contract_arr[$contacts_data_row['contract_id']]['payment_interval'] = $contacts_data_row['payment_interval'];

	if($vendor_type == "vendor"){
		$contract_arr[$contacts_data_row['contract_id']]['contract_type'] = $contacts_data_row['contract_type'];
		$contract_arr[$contacts_data_row['contract_id']]['digital_split'] = $contacts_data_row['digital_split'];
		$contract_arr[$contacts_data_row['contract_id']]['physical_split'] = $contacts_data_row['physical_split'];
		$contract_arr[$contacts_data_row['contract_id']]['dist_type'] = $contacts_data_row['dist_type'];
		$contract_arr[$contacts_data_row['contract_id']]['oms_fee_percentage'] = $contacts_data_row['oms_fee_percentage'];
        $orchard_compilation_split = $contacts_data_row['orchard_compilation_split'];
        $contract_arr[$contacts_data_row['contract_id']]['orchard_compilation_split'] = $orchard_compilation_split;
	}
	$contract_start_arr[] = $contacts_data_row['cont_start'];
	$contract_end_arr[] = $contacts_data_row['contract_end'];
}

array_multisort($contract_start_arr,SORT_ASC, SORT_STRING, $contract_arr, $contract_end_arr);

$lastest_contract = array_pop($contract_arr);

if(!empty($lastest_contract)){

	$contract_id = $lastest_contract['contract_id'];
	$sync_admin_commission = $lastest_contract['sync_admin_commission'];
	$royalty_collection_commission = $lastest_contract['royalty_collection_commission'];
	$sx_royalty_collection_commission = $lastest_contract['sx_royalty_collection_commission'];
	$topspin_rate = $lastest_contract['topspin_rate'];
	$publishing_admin_commission = $lastest_contract['publishing_admin_commission'];
	$cont_start	= $lastest_contract['cont_start'];
	$cont_end   = $lastest_contract['contract_end'];
	$orchrep_name   = $lastest_contract['orchrep_name'];
    $unlimited_roll = $lastest_contract['unlimited_roll'];
    $rollover_length_in_months = $lastest_contract['rollover_length_in_months'];
    $payment_interval = $lastest_contract['payment_interval'];

	if($vendor_type == "vendor"){
		$digital_split = $lastest_contract['digital_split'];
		$physical_split = $lastest_contract['physical_split'];
		$dist_type = $lastest_contract['dist_type'];
		$oms_fee_percentage = $lastest_contract['oms_fee_percentage'];
        $orchard_compilation_split   = $lastest_contract['orchard_compilation_split'];
	}

    $owsProductService = new OwsProductServiceClient(logger: $logger);

    $productTerritorySplitData = $owsContracts->getProductTerritorySplitDataByVendor(
        $vendor_id,
        $userId
    );
    $productTerritorySplitHelper = new ProductTerritorySplit($logger);
    $productTerritorySplits = $productTerritorySplitHelper->fetch($vendor_id, $userId);

    $productSplitData = $owsContracts->getProductSplitDataByVendor($vendor_id, $userId);
    $productArrangementData = $productSplitData['items'];
    if (is_array($productArrangementData) && !empty($productArrangementData)) {
        foreach ($productArrangementData as $splitData) {
            $upcs[] = $splitData['upc'];
        }
        $productData = $owsProductService->getProductsDataByBulkUpc(
            array('upcs' => $upcs, 'sort_param' => 'release_name', 'sort_direction' => 'asc')
        );
    }

    try {
        $owsTrackService = new OwsTrackServiceClient(logger: $logger);

        $trackSplitData = $owsContracts->getTrackSplitDataByVendor($vendor_id);
        $trackArrangementData = $trackSplitData['items'];
        if (is_array($trackArrangementData) && !empty($trackArrangementData)) {
            foreach ($trackArrangementData as $splitData) {
                $track_ids[] = $splitData['track_unique_id'];
            }
            $tuids = implode(',', $track_ids);
            $tracksData = $owsTrackService->getTracksData($tuids);
        }
    } catch (\Exception $e) {
        $logger->error($e->getMessage());
    }

    $colspan = "7";
?>

<div class="panelHeader" id="active-terms-panel">
    <?php 
        $headerTitle = $hideContractDetails ? "Active Contracts" : "Active Terms";
        $contractsHistory = $hideContractDetails ? "View Contract History" : "View Contracts";
        $contractsUrl = "/cont_mgmt/view_all_agreements.php?{$vendor_type}_id=" . ${$vendor_type . '_id'};
    ?>
    <h3><?= $headerTitle ?></h3>
    <ul>
        <li>
            <?php if ($hideContractDetails) { ?>
                <img src="/oa/images/clock.png" style="width:13px;">
            <?php } ?>
            <a href="<?= $contractsUrl ?>" class="btn btn-link btn-sm"><?= $contractsHistory ?></a>
        </li>
    </ul>
</div>
<?php
    $sql = 'SELECT vca.id,vca.amount,vca.currency_id,vca.exchange_rate,vca.description,vca.date_paid,p.`year`,p.`month`,cr.ISO_4217_code,cr.currency_name
            FROM vendor_contract_advance AS vca
            LEFT JOIN period AS p ON p.period_id = vca.apply_to_period_id
            LEFT JOIN currencies AS cr ON vca.currency_id = cr.id
            WHERE vca.contract_id = ?';

    $dataParams = new QueryData();
    $dataParams->addDataParam('i', $contract_id);
    $rs = $wrapperObj->executeQuery($sql, $dataParams);
    if ($rs === false) {
        showierror($sql);
    }
    $divStyleTag = $hideContractDetails ? 'style="display:grid;"' : '';
?>
<div class="panelContent sub-panel-container" id="active-terms-container">
    <div class ="sub-panel-grid full-width" <?php echo $divStyleTag; ?>>
        <div class="col-md-4 field-column">
            <?php if ($hideContractDetails) { ?>
                    <span style="margin-right:20px"><strong><?=$contract_id?></strong></span>
                    <a href="/cont_mgmt/view_vend_contract.php?id=<?=$contract_id?>">Click here for Service and Territory Carveouts.</a>
                <?php  } else { ?>
                <label class="no-margin">Active Contract</label>
                <span class="visible-block">
                    <a href="/cont_mgmt/view_vend_contract.php?id=<?=$contract_id?>"><?=$contract_id?></a>
                </span>
            <?php  } ?>
        </div>
        <?php if(!$hideContractDetails) { ?>
        <div class="col-md-4 field-column">
            <label>Effective Date</label>
            <span class="visible-block"><?=format_date($cont_start)?></span>
        </div>
        <div class="col-md-4 field-column">
            <label>Contract Initial Term Expiration Date</label>
            <span class="visible-block"><?=format_date($cont_end)?></span>
        </div>
        <div class="col-md-4 field-column">
            <label>Unlimited roll</label>
            <span class="visible-block"><?=($unlimited_roll == 'Y' ? 'Yes' : 'No')?></span>
        </div>
        <div class="col-md-4 field-column">
            <label>Orchard Closer</label>
            <span class="visible-block"><?=implode(',', array_unique(explode(',', $orchrep_name)))?></span>
        </div>
        <div class="col-md-4 field-column">
            <label>Payment Interval</label>
            <span class="visible-block"><?=$payment_interval?></span>
        </div>
    </div>
    <?php
        $table = '<table class="table sub-panel-table">';
        echo $table;
    ?>
        <thead>
            <tr>
                <th colspan="<?=$colspan?>">
                    <label class="no-margin">Split Type</label>
                    <span class="pull-right"><label class="no-margin">Split To Label</label></span>
                </th>
            </tr>
        </thead>
        <tbody id="special-arrangements">
            <tr class="sub-panel-table-header exclude-row">
                <td colspan="<?=$colspan?>">Special Arrangements</td>
            </tr>
            <?
            $dimTransactionTypes = getTransactionTypes($client);
            if ($contract_id) {
                $vendorTransactionTypes = getVendorTransactionTypes($pdoWrapperObj, $contract_id, $vendor_id);
            }
            unset($dimTransactionTypes['SB']);
            unset($dimTransactionTypes['DB']);
            unset($dimTransactionTypes['RE']);
            unset($vendorTransactionTypes['SB']);
            unset($vendorTransactionTypes['DB']);
            unset($vendorTransactionTypes['RE']);

            $vendorTransactionTypeResult = getTransactionTypeByTerritoryArrangementData($wrapperObj, $vendor_id, $contract_id);
            if (!empty($vendorTransactionTypeResult)) {
                foreach ($vendorTransactionTypeResult as $vtcRow) {
                    if ($vtcRow['transaction_type'] != 'DB' && $vtcRow['transaction_type'] != 'SB' && $vtcRow['transaction_type'] != 'RE') { ?>
                        <tr>
                            <td colspan="6"><?=$vtcRow['name']?></td>
                            <td><?=$dimTransactionTypes[$vtcRow['transaction_type']]['transactiontypeabbr'] . ' - ' . $dimTransactionTypes[$vtcRow['transaction_type']]['transactiontypedesc']?>
                                <span class="pull-right"><?=$vtcRow["territory_transaction_split"] * 100?>%</span>
                            </td>
                        </tr>
            <?
                    }
                }
            }
            if (!empty($vendorTransactionTypes)) {
                foreach ($vendorTransactionTypes as $transactionTypes => $vendorTransactionDetails) { ?>
                    <tr>
                        <td colspan="<?=$colspan?>"><?=$dimTransactionTypes[$vendorTransactionDetails['transaction_type']]['transactiontypeabbr'] . ' - ' . $dimTransactionTypes[$vendorTransactionDetails['transaction_type']]['transactiontypedesc']?>
                            <span class="pull-right"><?=$vendorTransactionDetails['transaction_split'] * 100?>%</span>
                        </td>
                    </tr>
                <?php
                }
            }
            $vendorDmsContractResult = getSpecialDmsArrangementData($wrapperObj, $vendor_id, $contract_id);
            if (!empty($vendorDmsContractResult)) {
                foreach ($vendorDmsContractResult as $vdcRow) { ?>
                    <tr>
                        <td colspan="<?=$colspan?>"><?=$vdcRow['name']?><span class="pull-right"><?=$vdcRow['dms_split'] * 100?>%</span></td>
                    </tr>
            <?
                }
            }
            $vendorMasterdmsContractResult = getDmsMasterArrangementData($wrapperObj, $vendor_id, $contract_id);
            if (!empty($vendorMasterdmsContractResult)) {
                foreach ($vendorMasterdmsContractResult as $vdmcRow) {
                    if (!in_array($vdmcRow['customer_master_master_id'], $serviceDMSMasterArrangements)) { ?>
                        <tr>
                            <td colspan="<?=$colspan?>"><?=$vdmcRow['customer_name']?><span class="pull-right"><?=$vdmcRow['dms_master_split'] * 100?>%</span></td>
                        </tr>
                    <?
                    }
                }
            }
            $vendorTerritoryContractResult = getTerritoryArrangementData($wrapperObj, $vendor_id, $contract_id);
            if (!empty($vendorTerritoryContractResult)) {
                foreach ($vendorTerritoryContractResult as $vtmRow) { ?>
                    <tr>
                        <td colspan="<?=$colspan?>"><?=$vtmRow['name']?><span class="pull-right"><?=$vtmRow['territory_split'] * 100?>%</span></td>
                    </tr>
            <? }
            } ?>
            <tr class="toggle-row-panel">
                <td colspan="<?=$colspan?>">
                    <button class="btn btn-link btn-sm pull-right expand-collapse-btn"></button>
                </td>
            </tr>
        </tbody>
        <tbody id="base-distribution">
            <tr class="sub-panel-table-header">
                <td colspan="<?=$colspan?>">Base Distribution</td>
            </tr>
            <tr>
                <td colspan="<?=$colspan?>">Base Split to Label<span class="pull-right"><?=$digital_split * 100?>%</span></td>
            </tr>
        </tbody>
        <tbody id="track-arrangements">
            <tr class="sub-panel-table-header exclude-row">
                <td colspan="<?=$colspan?>">Track Arrangements</td>
            </tr>
            <tr class="exclude-row">
                <th colspan="3"><label class="no-margin">Track Name</label></th>
                <th colspan="2"><label class="no-margin">Artist Name</label></th>
                <th><label class="no-margin">ISRC</label></th>
                <th class="text-right"><label class="no-margin">Split to label</label></th>
            </tr>
            <?php if (is_array($tracksData) && !empty($tracksData)) {
                foreach ($tracksData as $tracks) {
                    $key = array_search($tracks['tuid'], array_column($trackArrangementData, 'track_unique_id'));
                    $artist_name = '';
                    if (!empty($tracks['artists'])) {
                        $artist_key = array_search('performer', array_column($tracks['artists'], 'type'));
                        $artist_name = $tracks['artists'][$artist_key]['name'];
                    }
                ?>
                    <tr>
                        <td colspan="3"><?=$tracks['track_name']?></td>
                        <td colspan="2"><?=$artist_name?></td>
                        <td><?=$tracks['isrc']?></td>
                        <td class="text-right"><?=$trackArrangementData[$key]['track_split'] * 100?>%</td>
                    </tr>
                <?php }
            } else { ?>
                <tr>
                    <td colspan="<?=$colspan?>">No track arrangements.</td>
                </tr>
            <?php } ?>
            <tr id="track-arranagement-toggle" class="toggle-row-panel">
                <td colspan="<?=$colspan?>">
                    <button class="btn btn-link btn-sm pull-right expand-collapse-btn"></button>
                </td>
            </tr>
        </tbody>
        <?php if ($productTerritorySplitEnabled) { ?>
        <tbody id="product-territory-arrangements">
            <tr class="sub-panel-table-header exclude-row">
                <td colspan="<?=$colspan?>">Product By Territory Arrangements</td>
            </tr>
            <tr class="exclude-row">
                <th class="col-md-4"><label class="no-margin">Release Name</label></th>
                <th><label class="no-margin">Artist Name</label></th>
                <th><label class="no-margin">Product Type</label></th>
                <th><label class="no-margin">Format</label></th>
                <th><label class="no-margin">UPC</label></th>
                <th><label class="no-margin">Territory</label></th>
                <th class="text-right"><label class="no-margin">Split to label</label></th>
            </tr>
            <?php if (!empty($productTerritorySplits['rows'])) { ?>
            <?php foreach ($productTerritorySplits['rows'] as $pts) { ?>
            <tr>
                <td><?=$pts['release_name']?></td>
                <td><?=$pts['artist_name']?></td>
                <td class="col-md-2"><?=$pts['context_type']?></td>
                <td><?=$pts['format']?></td>
                <td><?=$pts['upc']?></td>
                <td><?=$pts['territory']?></td>
                <td class="text-right"><?=$pts['split_to_label']?></td>
            </tr>
            <?php } ?>
            <?php if ($productTerritorySplits['total_count'] > 50) { ?>
            <tr>
                <td id="product-territory-arrangement-view-all" colspan="<?=$colspan?>"></td>
            </tr>
            <?php } ?>
            <?php } else { ?>
            <tr>
                <td colspan="<?=$colspan?>">No product by territory arrangements.</td>
            </tr>
            <?php } ?>
            <tr id="product-territory-arrangements-toggle" class="toggle-row-panel">
                <td colspan="<?=$colspan?>">
                    <button class="btn btn-link btn-sm pull-right expand-collapse-btn"></button>
                </td>
            </tr>
        </tbody>
        <?php } ?>
        <tbody id="product-arrangements">
            <tr class="sub-panel-table-header exclude-row">
                <td colspan="<?=$colspan?>">Product Arrangements</td>
            </tr>
            <tr class="exclude-row">
                <th colspan="2"><label class="no-margin">Release Name</label></th>
                <th><label class="no-margin">Artist Name</label></th>
                <th><label class="no-margin">Product Type</label></th>
                <th><label class="no-margin">Format</label></th>
                <th><label class="no-margin">UPC</label></th>
                <th class="text-right"><label class="no-margin">Split to label</label></th>
            </tr>
            <?php if (!empty($productData['items'])) {
                foreach ($productData['items'] as $products) {
                    $key = array_search($products['upc'], array_column($productArrangementData, 'upc'));
                ?>
                    <tr>
                        <td colspan="2"><?=$products['product_name']?></td>
                        <td><?=$products['artist_name']?></td>
                        <td><?=$products['context_type']?></td>
                        <td><?=$products['format']?></td>
                        <td><?=$products['upc']?></td>
                        <td class="text-right"><?=$productArrangementData[$key]['product_split'] * 100?>%</td>
                    </tr>
                <?php }
            } else { ?>
                <tr>
                    <td colspan="<?=$colspan?>">No product arrangements.</td>
                </tr>
            <?php } ?>
            <tr id="product-arranagement-toggle" class="toggle-row-panel">
                <td colspan="<?=$colspan?>">
                    <button class="btn btn-link btn-sm pull-right expand-collapse-btn"></button>
                </td>
            </tr>
        </tbody>
        <tbody id="services">
            <tr class="sub-panel-table-header exclude-row">
                <td colspan="<?=$colspan?>">Services</td>
            </tr>
            <?php
            if ($sync_admin_commission) { ?>
                <tr>
                    <td colspan="<?=$colspan?>">Sync Admin<span class="pull-right"><?=$sync_admin_commission * 100?>%</span></td>
                </tr>
            <?php
            }
            $vendorMasterdmsContractResult = getDmsMasterArrangementData($wrapperObj, $vendor_id, $contract_id);
            if (!empty($vendorMasterdmsContractResult)) {
                foreach ($vendorMasterdmsContractResult as $vdmcRow) {
                    if (in_array($vdmcRow['customer_master_master_id'], $serviceDMSMasterArrangements)) { ?>
                        <tr>
                            <td colspan="<?=$colspan?>"><?=$vdmcRow['customer_name']?><span class="pull-right"><?=$vdmcRow['dms_master_split'] * 100?>%</span></td>
                        </tr>
                    <?
                    }
                }
            } ?>
            <tr id="services-toggle" class="toggle-row-panel">
                <td colspan="<?=$colspan?>">
                    <button class="btn btn-link btn-sm pull-right expand-collapse-btn"></button>
                </td>
            </tr>
        </tbody>
    </table>
    <table class="table table-bordered sub-panel-table no-margin">
        <tbody id="advance-table">
            <tr class="exclude-row">
                <th class="col-md-4"><label class="no-margin">Advance</label></th>
                <th><label class="no-margin">Amount</label></th>
                <th><label class="no-margin">Currency</label></th>
                <th><label class="no-margin">Exchange Rate</label></th>
                <th><label class="no-margin">Date Paid</label></th>
                <th><label class="no-margin">Apply to Period</label></th>
                <? if(check_user_permission(44)){?>
                <th></th>
                <? } ?>
            </tr>
            <?
            if (!empty($rs)) {
                foreach ($rs as $row) { ?>
            <tr>
                <td><?=htmlspecialchars($row['description'])?></td>
                <td><?=money_format("%!n",$row['amount'])?></td>
                <td><?=isset($row['currency_name']) ? $row['currency_name'].' ('.$row['ISO_4217_code'].')' : ''?></td>
                <td><?=($row['exchange_rate'] ? $row['exchange_rate'] : '')?></td>
                <td><?=($row['date_paid']!='0000-00-00' ? $row['date_paid'] : '')?></td>
                <td><?php if($row['year'] != '') echo $row['year'].'M'.$row['month'];?></td>
                <? if (check_user_permission(44)) { ?>
                <td>
                    <label>
                        <a href="/cont_mgmt/edit_rate_date_paid.php?id=<?=$row['id']?>&<?=($vendor_type == "vendor" ? ('vendor_id='.$vendor_id) : ('oms_client_id='.$oms_client_id))?>">Record Payment</a>
                    </label>
                </td>
                <? } ?>
            </tr>
            <?
                }
            } else { ?>
            <tr>
                <td colspan="7">No Advanced Payment Information.</td>
            </tr>
            <?
            } ?>
            <tr class="toggle-row-panel">
                <td colspan="7">
                    <button class="btn btn-link btn-sm pull-right expand-collapse-btn"></button>
                </td>
            </tr>
        </tbody>
    </table>
    <?php
        } else {
            echo '</div>';
            $sub_heading = 'To view this information, please follow the link below to the Abacus application.';
            $main_heading = 'Label’s Share and other Contract information is visible only in Abacus';
            $showGoToAbacus = true;
            include 'panelLabelContractInfo.inc';
        }
    ?>
</div>
<?php
            }   else {
				include("../cont_mgmt/includes/panelActiveProposedTerms.inc");
			} ?>

<script type="text/javascript" src="/scripts/expand-collapse-table.js"></script>
<script type="text/javascript">
    var productTerritorySplitEnabled = <?= ($productTerritorySplitEnabled) ? $productTerritorySplitEnabled : 0 ?>;
    jQuery(document).ready(function () {
        var specialArrangementLength = jQuery('#special-arrangements tr').length,
            baseDistributionLength = jQuery('#base-distribution tr').length,
            servicesLength = jQuery('#services tr').length;
        if (specialArrangementLength < 3) {
            jQuery('#special-arrangements').hide();
        }
        if (baseDistributionLength < 2) {
            jQuery('#base-distribution').hide();
        }
        if (servicesLength < 3) {
            jQuery('#services').hide();
        }

        jQuery('#services').expandCollapseTablePanel({
            showLimit: '5',
            excludeRow: '2'
        });

        jQuery('#special-arrangements').expandCollapseTablePanel({
            showLimit: '5',
            excludeRow: '2'
        });

        var productArrangementLength = jQuery('#product-arrangements tr').length;
        if (productArrangementLength > 50) {
            jQuery('#product-arranagement-toggle').removeClass("toggle-row-panel");
            jQuery('.viewMoreProductArrangement').show();
            jQuery('#product-arrangements').append('<tr class="viewMoreProductArrangementexclude-row"><td colspan="6"><a class="btn btn-link btn-sm pull-right" target="_blank" href="/cont_mgmt/product_arrangement.php?id=<?php echo $contract_id; ?>&editMode=0">View More</a></td></tr>');

        } else {
            jQuery('product-arranagement-toggle').show();
            jQuery('#product-arranagement-toggle').addClass("toggle-row-panel");
            jQuery('#product-arrangements').expandCollapseTablePanel({
                showLimit: '5',
                excludeRow: '3'
            });
        }
        jQuery('#advance-table').expandCollapseTablePanel({
            showLimit: '10',
            excludeRow: '2'
        });

        if (productTerritorySplitEnabled) {
            var productTerritoryArrangementLen = <?= $productTerritorySplits['total_count'] ?>;
            if (productTerritoryArrangementLen > 50) {
                jQuery('#product-territory-arrangement-view-all').append('<a class="btn btn-link btn-sm pull-right" target="_blank" href="/cont_mgmt/product_territory_arrangement.php?id=<?= $contract_id ?>&editMode=0">View More</a>');
            }
            jQuery('#product-territory-arrangements-toggle').addClass("toggle-row-panel");
            jQuery('#product-territory-arrangements').expandCollapseTablePanel({
                showLimit: '5',
                excludeRow: '3'
            });
        }

        var trackArrangementLength = jQuery('#track-arrangements tr').length;
        if (trackArrangementLength > 50) {
            jQuery('#track-arranagement-toggle').removeClass("toggle-row-panel");
            jQuery('.viewMoreTrackArrangement').show();
            jQuery('#track-arrangements').append('<tr class="viewMoreTrackArrangement exclude-row"><td colspan="6"><a class="btn btn-link btn-sm pull-right" target="_blank" href="/cont_mgmt/track_arrangement.php?id=<?php echo $contract_id; ?>&editMode=0">View More</a></td></tr>');

        } else {
            jQuery('track-arranagement-toggle').show();
            jQuery('#track-arranagement-toggle').addClass("toggle-row-panel");
            jQuery('#track-arrangements').expandCollapseTablePanel({
                showLimit: '5',
                excludeRow: '3'
            });
        }
    });
</script>