<?php
/* * ***********************  Change History  *****************************
  07/28/2006 - Paulo Kuong
  -    Added code for new fields: payment_type, wire_info

  12/15/2006 - Paulo Kuong
  -    Added MySpace field
 * ********************************************************************** */

use Orchard\Service\Encryption\Crypt;
require_once(__DIR__ . '/../../../vendor/autoload.php');
use Orchard\Mysqli\QueryData;
use Orchard\Mysqli\Wrapper as MysqliWrapper;
use Orchard\FeatureFlags\Context\AccountContext;
use Orchard\FeatureFlags\FeatureService;
$wrapperObj = new MysqliWrapper($mysqli);

$tinField = 'v.encrypted_tin';
$foreignTinField = 'v.encrypted_foreign_tin';
$vendorLocalizedTemplate = isset($vendorLocalizedTemplate) ? $vendorLocalizedTemplate : null;

$logger = Zend_Registry::get('applicationLoggerOA');
$awsConfigs = yaml_parse_file(APPLICATION_PATH . '/configs/aws.yml');
$userContext = AccountContext::fromLegacy((string)$_SESSION['S_USERID'], 'oa');
$owsFeaturesServiceClient = new FeatureService($logger);
$isQuarterbackLabelManagersInOAEnabled = $owsFeaturesServiceClient->isVariant(
    'quarterback_label_managers_in_oa',
    'enabled',
    $userContext
);

$isEditDeletedLabelsEnabled = $owsFeaturesServiceClient->isVariant(
    'edit_deleted_labels',
    'enabled',
    $userContext
);

$isSapVendorIdEnabled = $owsFeaturesServiceClient->isVariant(
    'sap_vendor_id',
    'enabled',
    $userContext
);

$isProjectedFirstYearRevenueEnabled = $owsFeaturesServiceClient->isVariant(
    'add_projected_first_year_revenue',
    'enabled',
    $userContext
);

$isW8LOBEnabled = $owsFeaturesServiceClient->isVariant(
    'w8_lob',
    'enabled',
    $userContext
);

$isTransferPricingCountryEnabled = $owsFeaturesServiceClient->isVariant(
    'transfer_pricing_country',
    'enabled',
    $userContext
);

$isAddUSWhtTreatyOptFieldEnabled = $owsFeaturesServiceClient->isVariant(
    'oa_add_us_wht_treaty_opt_field',
    'enabled',
    $userContext
);

$quarterbackLabelManager = $isQuarterbackLabelManagersInOAEnabled ? ', v.quarterback_label_manager' : '';
$sapVendorId = $isSapVendorIdEnabled ? ', v.sap_vendor_id' : '';
$projectedFirstYearRevenue = $isProjectedFirstYearRevenueEnabled ? ', v.projected_first_year_revenue' : '';
$w8LOB = $isW8LOBEnabled ? ', v.w8_lob' : '';
$transferPricingCountry = ($isTransferPricingCountryEnabled) ? ', v.transfer_pricing_country' : '';
$usWhtTreatyOptIn = ($isAddUSWhtTreatyOptFieldEnabled) ? ', v.us_wht_treaty_opt_in' : '';

$vend_query = "SELECT v.name, v.label_identifier, v.date_created, v.payment_type, v.company, v.last_update, v.referral, v.join_vendor_id, v.owner, v.priority, v.region, v.primary_genre, v.est_total_releases, v.est_total_tracks
    , co.name AS country, ge.genre as p_genre, re.region as r_region, ROUND(v.overall_priority, 0) AS overall_priority, CONCAT_WS(' ', ou.f_name, ou.l_name) AS assigned_to, v.status, v.website, v.tax_form_received
    , v.w8_tax_form_date, " . $tinField . ", v.tax_id_type, " . $foreignTinField . ", v.checks, v.tax_name, co2.name as tax_id_country, v.wel_email_sender, v.wel_email_send_date, v.myspace_url, v.show_release_builder, v.recurring_payment_threshold
    , v.is_distributor, v.is_owned, v.support_contact_email, v.first_statement_period"
    . $quarterbackLabelManager . $sapVendorId . $projectedFirstYearRevenue . $w8LOB . $transferPricingCountry . $usWhtTreatyOptIn ."
    FROM vendor v
    LEFT JOIN country co ON co.id = v.country
    LEFT JOIN country co2 ON co2.id = v.tax_id_country
    LEFT JOIN region re ON v.region = re.region_id
    LEFT JOIN genre ge ON v.primary_genre = ge.genre_id
    LEFT JOIN orchadmin_users ou ON ou.id = v.assigned_to
    WHERE v.vendor_id = ?
    GROUP BY v.vendor_id";
$data_params = new QueryData();
$data_params->addDataParam('i', $vendor_id);
$vend_result = $wrapperObj->executeQuery($vend_query, $data_params);
if ($vend_result === false) {
    showierror($vend_query);
}

$vend_row = $vend_result[0];

$soundscan_query = 'SELECT country_id,soundscan_code FROM soundscan_codes sc WHERE sc.vendor_id = ?';
$data_params = new QueryData();
$data_params->addDataParam('i', $vendor_id);
$soundscan_result = $wrapperObj->executeQuery($soundscan_query, $data_params);
if ($soundscan_result === false) {
    showierror($soundscan_query);
}
foreach ($soundscan_result as $data) {
    $soundscan_row[$data['country_id']] = $data['soundscan_code'];
}

if ($isQuarterbackLabelManagersInOAEnabled && $vend_row['quarterback_label_manager']) {
    $quarterbackLabelManager_query = 'SELECT CONCAT_WS(" ", f_name, l_name) AS user_name
        FROM orchadmin_users WHERE id = ?';
    $data_params = new QueryData();
    $data_params->addDataParam('i', $vend_row['quarterback_label_manager']);
    $result = $wrapperObj->executeQuery($quarterbackLabelManager_query, $data_params);
    if ($result === false) {
        showierror($quarterbackLabelManager_query);
    }
    $vend_row['quarterback_label_manager'] = $result[0]['user_name'];
}

$tax_id_type = $vend_row['tax_id_type'];
$tax_id_types = array(
    'corporation' => 'Corporation',
    'individual' => 'Individual',
    'other' => 'Other',
    'w9_individual' => 'W9 - Individual',
    'w9_c_corporation' => 'W9 - C Corporation',
    'w9_s_corporation' => 'W9 - S Corporation',
    'w9_partnership' => 'W9 - Partnership',
    'w9_trust_estate' => 'W9 - Trust / Estate',
    'w9_llc' => 'W9 - LLC',
    'w9_sole_proprietor' => 'W9 - Sole Proprietor',
    'w9_single_member_llc' => 'W9 - Single Member LLC',
    'w8_corporation' => 'W8 - Corporation',
    'w8_disregarded_entity' => 'W8 - Disregarded Entity',
    'w8_partnership' => 'W8 - Partnership',
    'w8_simple_trust' => 'W8 - Simple Trust',
    'w8_grantor_trust' => 'W8 - Grantor Trust',
    'w8_complex_trust' => 'W8 - Complex Trust',
    'w8_estate' => 'W8 - Estate',
    'w8_government' => 'W8 - Government',
    'w8_central_bank_of_issue' => 'W8 - Central Bank of Issue',
    'w8_tax_exempt_organization' => 'W8 - Tax-Exempt Organization',
    'w8_private_foundation' => 'W8 - Private Foundation',
    'w8_international_organization' => 'W8 - International Organization',
    'w8_individual' => 'W8 - Individual'
);

if(array_key_exists($vend_row['tax_id_type'], $tax_id_types )) {
    $tax_id_type = $tax_id_types[$vend_row['tax_id_type']];
}

if ($isW8LOBEnabled) {
    $w8_lob = $vend_row['w8_lob'];
    $w8_lob_options = array(
        'government' => 'Government',
        'tax_exempt_pension_trust_or_pension_fund' => 'Tax-exempt pension trust or pension fund',
        'other_tax_exempt_organization' => 'Other tax-exempt organization',
        'publicly_traded_corporation' => 'Publicly traded corporation',
        'subsidiary_of_a_publicly_traded_corporation' => 'Subsidiary of a publicly traded corporation',
        'company_that_meets_the_ownership_and_base_erosion_test' => 'Company that meets the ownership and base erosion test',
        'company_that_meets_the_derivative_benefits_test' => 'Company that meets the derivative benefits test',
        'company_with_an_item_of_income_that_meets_active_trade_or_business_test' => 'Company with an item of income that meets active trade or business test',
        'favorable_discretionary_determination_by_the_US_competent_authority_received' => 'Favorable discretionary determination by the U.S. competent authority received',
        'no_lob_article_in_treaty' => 'No LOB article in treaty',
        'not_a_W_8BEN_E_form' => 'N/A - not a W-8BEN-E form',
        'not_a_W_8BEN_E_form_or_no_tax_treaty' => 'N/A - Not a W-8BEN-E Form or no tax treaty',
        'other' => 'Other'
    );
    if (array_key_exists($vend_row['w8_lob'], $w8_lob_options)) {
        $w8_lob = $w8_lob_options[$vend_row['w8_lob']];
    }
}

if ($isTransferPricingCountryEnabled) {
    $transfer_pricing_country = $vend_row['transfer_pricing_country'];
    $transfer_pricing_country_options = array(
        'finetunes' => 'Finetunes',
        'fluve' => 'Fluve',
        'ioda_brazil' => 'IODA Brazil',
        'orchard_as' => 'Orchard AS',
        'orchard_eu' => 'Orchard EU',
        'orchard_gmbh' => 'Orchard GmbH',
        'orchard_ny' => 'Orchard NY',
        'phonofile' => 'Phonofile',
        'red_essential' => 'Red Essential',
        'sme_argentina' => 'SME Argentina',
        'sme_australia' => 'SME Australia',
        'sme_austria' => 'SME Austria',
        'sme_belgium' => 'SME Belgium',
        'sme_brazil' => 'SME Brazil',
        'sme_canada' => 'SME Canada',
        'sme_central_america' => 'SME Central America',
        'sme_chile' => 'SME Chile',
        'sme_china' => 'SME China',
        'sme_colombia' => 'SME Colombia',
        'sme_czech_republic' => 'SME Czech Republic',
        'sme_denmark' => 'SME Denmark',
        'sme_east_africa' => 'SME East Africa',
        'sme_ecuador' => 'SME Ecuador',
        'sme_finland' => 'SME Finland',
        'sme_france' => 'SME France',
        'sme_germany' => 'SME Germany',
        'sme_greece' => 'SME Greece',
        'sme_hong_kong' => 'SME Hong Kong',
        'sme_hungary' => 'SME Hungary',
        'sme_india' => 'SME India',
        'sme_indonesia' => 'SME Indonesia',
        'sme_ireland' => 'SME Ireland',
        'sme_israel' => 'SME Israel',
        'sme_italy' => 'SME Italy',
        'sme_korea' => 'SME Korea',
        'sme_malaysia' => 'SME Malaysia',
        'sme_mexico' => 'SME Mexico',
        'sme_middle_east' => 'SME Middle East',
        'sme_netherlands' => 'SME Netherlands',
        'sme_new_zealand' => 'SME New Zealand',
        'sme_norway' => 'SME Norway',
        'sme_peru' => 'SME Peru',
        'sme_philippines' => 'SME Philippines',
        'sme_poland' => 'SME Poland',
        'sme_portugal' => 'SME Portugal',
        'sme_russia' => 'SME Russia',
        'sme_singapore' => 'SME Singapore',
        'sme_south_africa' => 'SME South Africa',
        'sme_spain' => 'SME Spain',
        'sme_sweden' => 'SME Sweden',
        'sme_switzerland' => 'SME Switzerland',
        'sme_taiwan' => 'SME Taiwan',
        'sme_thailand' => 'SME Thailand',
        'sme_turkey' => 'SME Turkey',
        'sme_united_kingdom' => 'SME United Kingdom',
        'sme_uruguay' => 'SME Uruguay',
        'sme_venezuela' => 'SME Venezuela',
        'sme_vietnam' => 'SME Vietnam',
        'sme_west_africa' => 'SME West Africa'
    );
    if (array_key_exists($vend_row['transfer_pricing_country'], $transfer_pricing_country_options)) {
        $transfer_pricing_country = $transfer_pricing_country_options[$vend_row['transfer_pricing_country']];
    }
}

if ($isAddUSWhtTreatyOptFieldEnabled) {
    $us_wht_treaty_opt_in = $vend_row['us_wht_treaty_opt_in'];
    $us_wht_treaty_opt_in_options = array(
        1 => 'Opt In',
        0 => 'Opt Out'
    );
    if (array_key_exists($vend_row['us_wht_treaty_opt_in'], $us_wht_treaty_opt_in_options)) {
        $us_wht_treaty_opt_in = $us_wht_treaty_opt_in_options[$vend_row['us_wht_treaty_opt_in']];
    }
}

$payment_type = $vend_row['payment_type'];
$payment_types = array(
    'check' => 'Check',
    'wire' => 'Wire',
    'travelex' => 'Travelex',
    'sony_ach' => 'Sony ACH',
    'sony_eft' => 'Sony EFT'
);

if(array_key_exists($vend_row['payment_type'], $payment_types )) {
    $payment_type = $payment_types[$vend_row['payment_type']];
}

?>
<?php
$isSuiteTestAppFeatureEnabled = $owsFeaturesServiceClient->isVariant(
    'oa_solfege_account_info',
    'enabled',
    $userContext
);
if($isSuiteTestAppFeatureEnabled) {
    include_once('../includes/suite_oa_application.inc');
    ?>
    <script type="text/javascript">
        embedSuiteModule('label-info-form', { vendorId: "<?=$vendor_id?>", editVendorOwner: <?= json_encode(check_user_permission(376)); ?> });
    </script>
    <?php
    $hideContractDetails = hideContractDetails($vendor_id);
    ?>
    <!-- tax info -->
    <div class="panelHeader">
        <h3>Tax & Payment Info</h3>
        <?php
            if (check_user_permission(36) && !$hideContractDetails) {
                if(($isEditDeletedLabelsEnabled && $vend_row['status'] == 'deletion')
                    || $vend_row['status'] == 'signed') {
        ?>
        <ul>
            <li><a class="btn btn btn-link btn-sm" href="/cont_mgmt/edit_vendor.php?vendor_id=<?=$vendor_id ?>">Edit</a></li>
        </ul>
        <?php
        }} ?>
    </div>
    <div class="panelContent" id="label_info">
        <?php
        if (!$hideContractDetails) {
        ?>
        <table class="form">
            <?php if ($isSapVendorIdEnabled) { ?>
                  <tr><th>SAP Vendor ID:</th>
                      <td><?=$vend_row['sap_vendor_id']?></td>
                  </tr>
            <?php } ?>

            <?php if ($vend_row['status'] == 'signed' || $vend_row['status'] == 'deletion') { ?>
              <tr><th>Payment Type:</th>
                  <td><?=$payment_type ?></td>
              </tr>
              <tr><th>Checks Payable:</th>
                  <td><?=$vend_row["checks"] ?></td>
              </tr>
              <tr><th>Tax Name:</th>
                  <td><?=$vend_row["tax_name"] ?></td>
              </tr>
              <tr><th>Tax Form Received:</th>
                  <td><?=($vend_row['tax_form_received'] == 'Y' ? 'Yes' : 'No') ?></td>
              </tr>
              <tr><th>W8 Tax Form Date:</th>
                  <td><?=$vend_row['w8_tax_form_date'] ?></td>
              </tr>
              <?php
              $fieldName = 'encrypted_tin';
              $tin = (!empty(trim($vend_row[$fieldName]))) ? 'Y' : 'N';
              if (check_user_role($wrapperObj, 25)) {
                  $tin = Crypt::decryptAndHide($vend_row[$fieldName], 4);
              }
              ?>
              <tr><th>US Tax ID:</th>
                  <td><?=$tin ?></td>
              </tr>
              <tr><th>Tax ID Type:</th>
                  <td><?=$tax_id_type ?></td>
              </tr>
              <?php
              $fieldName = 'encrypted_foreign_tin';
              $foreignTin = (!empty(trim($vend_row[$fieldName]))) ? 'Y' : 'N';
              if (check_user_role($wrapperObj, 25)) {
                  $foreignTin = Crypt::decryptAndHide($vend_row['encrypted_foreign_tin'], 4);
              }
              ?>
              <tr><th>Foreign Tax ID:</th>
                  <td><?=$foreignTin ?></td>
              </tr>
            <?php } ?>
        </table>

        <table class="form">
            <?php
            if ($vend_row['status'] == 'signed' || $vend_row['status'] == 'deletion') { ?>
              <tr><th>Tax ID Country:</th>
                  <td><?=$vend_row["tax_id_country"] ?></td>
              </tr>
              <?php if ($isAddUSWhtTreatyOptFieldEnabled) { ?>
               <tr><th>US WHT Treaty Opt In/Opt Out:</th>
                    <td><?=$us_wht_treaty_opt_in ?></td>
               </tr>
              <?php } ?>
              <tr><th>Allow ALW Release Builder:</th>
                  <td><?=$vend_row['show_release_builder'] ?></td>
              </tr>
              <tr><th>Recurring Payment Threshold:</th>
                  <?php $currency_data = activeContractId($wrapperObj, $vendor_id); ?>
                  <td><span id="currency_symbol"><?=$currency_data['currency_symbol'] ?></span>&nbsp;<?=substr(number_format($vend_row['recurring_payment_threshold'], 3, '.', ''), 0, -1); ?>&nbsp;<span id="currency_iso_code"><?=$currency_data['currency_ISO_4217_code'] ?></span></td>
              </tr>
              <?php
                  $statementPeriodQuery = 'SELECT CONCAT(year, "-", LPAD(month, 2, 0)) AS statement_period FROM period WHERE period_id = ?';
                  $statementPeriodData = new QueryData();
                  $statementPeriodData->addDataParam('i', $vend_row['first_statement_period']);
                  $statementPeriod = $wrapperObj->executeQuery($statementPeriodQuery, $statementPeriodData);
                  if ($statementPeriod === false) {
                      showierror($statementPeriod);
                  }
                  $statementYearMonth = $statementPeriod[0];
              ?>
              <?php if ($isProjectedFirstYearRevenueEnabled) {
                setlocale(LC_MONETARY, 'en_US.UTF-8');
                ?>
                <tr>
                    <th>Projected First Year Revenue:</th>
                    <td>&nbsp;<?=money_format('%.2n', substr(number_format($vend_row['projected_first_year_revenue'], 3, '.', ''), 0, -1)); ?>&nbsp;<span>USD</span>
                    </td>
                </tr>
              <?php } ?>
            <?php } ?>
        </table>
        <?php
        } else {
            $sub_heading = 'Tax and Payment Information is now visible only in the Abacus application.';
            $showGoToAbacus = true;
            include 'panelLabelContractInfo.inc';
        ?>
        <?php } ?>
    </div>
    <!-- tax info -->
    <?php
}
else {
?>
<div class="panelHeader">
    <h3>Label Info</h3>
    <?php
        if (check_user_permission(36)) {
            if(($isEditDeletedLabelsEnabled && $vend_row['status'] == 'deletion')
                || $vend_row['status'] == 'signed') {
    ?>
    <ul>
        <li><a class="btn btn btn-link btn-sm" href="/cont_mgmt/edit_vendor.php?vendor_id=<?=$vendor_id ?>">Edit</a></li>
    </ul>
    <?php
    }} ?>
</div>
<div class="panelContent" id="label_info">
    <table class="form">
        <?php
        if ($vend_row['status'] == 'signed' || $vend_row['status'] == 'deletion') {?>
        <tr>
            <th>Contact Name:</th>
            <td><?=$vend_row["name"] ?></td>
        </tr>
        <?php
        } ?>
        <tr>
            <th>Label Type:</th>
            <td><?=$vend_row["label_identifier"] ?></td>
        </tr>
        <tr>
            <th>Owner:</th>
            <td><?=$vend_row["owner"] ?></td>
        </tr>
        <tr>
            <th>Owned and Operated:</th>
            <td><?=$vend_row["is_owned"] ?></td>
        </tr>
        <tr>
            <th>Distributor:</th>
            <td><?=$vend_row['is_distributor'] ?></td>
        </tr>
        <tr>
            <th>Relationship Manager:</th>
            <td><?=$vend_row['assigned_to'] ?></td>
        </tr>

        <?php if ($isQuarterbackLabelManagersInOAEnabled) { ?>
            <tr>
                <th>Secondary Relationship Manager:</th>
                <td><?=$vend_row['quarterback_label_manager'] ?></td>
            </tr>
        <?php } ?>

        <tr>
            <th>Date Created:</th>
            <td><?=$vend_row["date_created"] ?></td>
        </tr>
        <tr>
            <th>Last Updated:</th>
            <td><?=format_date($vend_row["last_update"]) ?></td>
        </tr>
        <?php
        if ($vend_row['is_distributor'] == 'N') { ?>
        <tr>
            <th>SoundScan Code US:</th>
            <td><?=$soundscan_row[1] ?></td>
        </tr>
        <tr>
            <th>SoundScan Code CA:</th>
            <td><?=$soundscan_row[2] ?></td>
        </tr>
        <?php
        }
        ?>
        <tr>
            <th>Support Contact Email:</th>
            <td><?=$vend_row['support_contact_email']?></td>
        </tr>
            <?php
        if ($isSapVendorIdEnabled) { ?>
            <tr>
                <th>SAP Vendor ID:</th>
                <td><?=$vend_row['sap_vendor_id']?></td>
            </tr>
        <?php } ?>
    </table>

    <table class="form">
        <tr>
            <th>Label Priority:</th>
            <td><?=$vend_row["priority"] ?></td>
        </tr>
        <th>Est. # of Releases/Tracks:</th>
        <td><?=$vend_row["est_total_releases"] ?> / <?=$vend_row["est_total_tracks"] ?></td>
        </tr>
        <tr>
            <th>Genre:</th>
            <td><?=$vend_row["p_genre"] ?></td>
        </tr>
        <tr>
            <th>Country:</th>
            <td><?=$vend_row['country'] ?></td>
        </tr>
        <?php
        if ($vend_row['status'] == 'signed' || $vend_row['status'] == 'deletion') { ?>
        <tr>
            <th>Region:</th>
            <td><?=$vend_row["r_region"] ?></td>
        </tr>
        <tr><th>Website:</th>
            <td><a href="http://<?=$vend_row['website'] ?>" title="Go to Website"><?=$vend_row['website'] ?></a></td>
        </tr>
        <?php }
        if (!empty($vendorLocalizedTemplate)) { ?>
            <tr>
                <th>Default Sales Sheet</th>
                <td><?php echo $vendorLocalizedTemplate->template_name; ?></td>
            </tr>
        <?php } ?>
        <tr>
        <?php if ($isProjectedFirstYearRevenueEnabled) {
            setlocale(LC_MONETARY, 'en_US.UTF-8');
            ?>
            <tr>
                <th>Projected First Year Revenue:</th>
                <td>&nbsp;<?=money_format('%.2n', substr(number_format($vend_row['projected_first_year_revenue'], 3, '.', ''), 0, -1)); ?>&nbsp;<span>USD</span>
                </td>
            </tr>
        <?php } ?>
    </table>

    <table class="form">
        <?php
        if ($vend_row['status'] == 'signed' || $vend_row['status'] == 'deletion') { ?>
        <tr>
            <th>Payment Type:</th>
            <td><?=$payment_type ?></td>
        </tr>
        <tr>
            <th>Checks Payable:</th>
            <td><?=$vend_row["checks"] ?></td>
        </tr>
        <tr>
            <th>Tax Name:</th>
            <td><?=$vend_row["tax_name"] ?></td>
        </tr>
        <tr><th>Tax Form Received:</th>
            <td><?=($vend_row['tax_form_received'] == 'Y' ? 'Yes' : 'No') ?></td>
        </tr>
        <tr><th>W8 Tax Form Date:</th>
            <td><?=$vend_row['w8_tax_form_date'] ?></td>
        </tr>
        <?php
        $fieldName = 'encrypted_tin';
        $tin = (!empty(trim($vend_row[$fieldName]))) ? 'Y' : 'N';
        if (check_user_role($wrapperObj, 25)) {
            $tin = Crypt::decryptAndHide($vend_row[$fieldName], 4);
        }
        ?>
        <tr>
            <th>US Tax ID:</th>
            <td><?=$tin ?></td>
        </tr>
        <tr>
            <th>Tax ID Type:</th>
            <td><?=$tax_id_type ?></td>
        </tr>
        <?php if ($isW8LOBEnabled) { ?>
        <tr>
            <th>W8 LOB:</th>
            <td><?=$w8_lob ?></td>
        </tr>
        <?php } ?>
        <?php
        $fieldName = 'encrypted_foreign_tin';
        $foreignTin = (!empty(trim($vend_row[$fieldName]))) ? 'Y' : 'N';
        if (check_user_role($wrapperObj, 25)) {
            $foreignTin = Crypt::decryptAndHide($vend_row['encrypted_foreign_tin'], 4);
        }
        ?>
        <tr>
            <th>Foreign Tax ID:</th>
            <td><?=$foreignTin ?></td>
        </tr>
        <tr>
            <th>Tax ID Country:</th>
            <td><?=$vend_row["tax_id_country"] ?></td>
        </tr>
        <?php if ($isAddUSWhtTreatyOptFieldEnabled) { ?>
        <tr>
            <th>US WHT Treaty Opt In/Opt Out:</th>
            <td><?=$us_wht_treaty_opt_in ?></td>
        </tr>
        <?php } ?>
        <tr>
            <th>Allow ALW Release Builder:</th>
            <td><?=$vend_row['show_release_builder'] ?></td>
        </tr>
        <tr>
            <th>Recurring Payment Threshold:</th>
            <?php $currency_data = activeContractId($wrapperObj, $vendor_id); ?>
            <td><span id="currency_symbol"><?=$currency_data['currency_symbol'] ?></span>&nbsp;<?=substr(number_format($vend_row['recurring_payment_threshold'], 3, '.', ''), 0, -1); ?>&nbsp;<span id="currency_iso_code"><?=$currency_data['currency_ISO_4217_code'] ?></span></td>
        </tr>
        <?php
            $statementPeriodQuery = 'SELECT CONCAT(year, "-", LPAD(month, 2, 0)) AS statement_period FROM period WHERE period_id = ?';
            $statementPeriodData = new QueryData();
            $statementPeriodData->addDataParam('i', $vend_row['first_statement_period']);
            $statementPeriod = $wrapperObj->executeQuery($statementPeriodQuery, $statementPeriodData);
            if ($statementPeriod === false) {
                showierror($statementPeriod);
            }
            $statementYearMonth = $statementPeriod[0];
        ?>
        <?php
        }
        if ($vend_row['wel_email_sender']) { ?>
        <tr>
            <?php
            $getusernam = 'select concat(f_name," ", l_name) as full_name from orchadmin_users where id = ?';
            $data_params = new QueryData();
            $data_params->addDataParam('i', $vend_row['wel_email_sender']);
            $getusernamrs = $wrapperObj->executeQuery($getusernam, $data_params);
            if ($getusernamrs === false) {
                showierror($getusernam);
            }
            list($sender) = $getusernamrs[0];
            ?>
    </table>
    <table class="form full">
        <tr><th>Welcome Email was sent by:</th>
            <td><?=$sender ?> <b>on</b> <?=$vend_row['wel_email_send_date'] ?></td>
        </tr>
        <?php
        } ?>
    </table>
</div>

    <?php
}
?>