<?php
use Orchard\Service\Ows\Carveouts;
require_once('functions.php');

$physicalPricingTierValue = isset($physicalPricingTierValue) ? $physicalPricingTierValue : '-';
$pdoWrapperObj = getPDOQueryWrapper();
$sqlProductPhysical = 'SELECT
pp.exclusive_for,
pp.explicit,
pp.wholesale_price,
ppp.name as packaging,
ppp.id as packaging_id,
pp.hmv_notes,
pp.meeting_notes,
pp.id as product_id,
pp.embargo_date,
pp.pricing,
pp.discount,
pp.box_lot,
pp.initial_stock,
pp.pline,
pp.individual,
pp.units_per_set,
pp.display_configuration,
pp.exportable,
pp.manufacturing_obligation,
pp.production_notes,
pp.japan_distribution,
pp.edition
FROM product_physical pp
LEFT JOIN product_physical_packaging ppp
    ON ppp.id = pp.packaging_id
WHERE pp.release_id = ?';
$productPhysicalResult = $pdoWrapperObj->executeQuery($sqlProductPhysical, [$release_id]);
if ($productPhysicalResult === false) {
    show_pdo_error($sqlProductPhysical, $pdoWrapperObj->getLastStatement());
}
$productPhysicalData = $productPhysicalResult[0];

$physicalProductPackagingQuery = 'SELECT id, name FROM product_physical_packaging WHERE display_flag="Y"';
$physicalProductPackagingResult = $pdoWrapperObj->executeQuery($physicalProductPackagingQuery, []);
if ($physicalProductPackagingResult === false) {
    show_pdo_error($physicalProductPackagingQuery, $pdoWrapperObj->getLastStatement());
}
$logger = Zend_Registry::get('applicationLoggerOA');
$carveoutsClient = new Carveouts($logger);
if ($isCCMPhysicalSupplyChainInfoOaEnabled) {
    $storeResults = $carveoutsClient->getPhysicalStores();
    $productPhysicalSupplyChainMetadataInfo = getProductPhysicalSupplyChainInfo($pdoWrapperObj, $release_id);
    foreach ($storeResults as $id => $name) {
        $storeResults[$id] = [
            'name' => $name,
            'sale_start_date' => '',
            'initial_stock' => ''
        ];
    }
    if (!empty($productPhysicalSupplyChainMetadataInfo)) {
        foreach ($productPhysicalSupplyChainMetadataInfo as $row) {
            $id = $row['store_id'];
            if (isset($storeResults[$id])) {
                $storeResults[$id]['sale_start_date'] = $row['sale_start_date'];
                $storeResults[$id]['initial_stock'] = $row['initial_stock'];
            }
        }
    }
    $carveoutResults = $carveoutsClient->getReleaseCarveoutResult($upc);
    $restrictedDms = array();
    foreach ($carveoutResults['store'] as $key => $dmsProperties) {
        $restrictedDms[$key] = $dmsProperties["dms_name"];
    }
    foreach ($storeResults as $key => &$value) {
        $value['restricted'] = isset($restrictedDms[$key]);

        if ($value['restricted']) {
            $value['sale_start_date'] = '';
            $value['initial_stock'] = '';
        }
    }
    unset($value);
}

$USSupplyChainInfo = array();
$canadaSupplyChainInfo = array();
$supplyChainReturnInfoQuery = 'SELECT returnability, return_disposition, store_id FROM product_physical_supply_chain_info WHERE product_id = ?';
$supplyChainReturnInfoResult = $pdoWrapperObj->executeQuery($supplyChainReturnInfoQuery, [$release_id]);
if ($supplyChainReturnInfoResult === false) {
    show_pdo_error($supplyChainReturnInfoQuery, $pdoWrapperObj->getLastStatement());
}
foreach ($supplyChainReturnInfoResult as $value) {
    if ($value['store_id'] == STORE_ID_FOR_US) {
        $USSupplyChainInfo = $value;
    } elseif ($value['store_id'] == STORE_ID_FOR_CANADA) {
        $canadaSupplyChainInfo = $value;
    }
}

if ($isOaJapanPhysicalFieldsEnabled) {
    $phoneticTranslationsQuery = 'SELECT field_name, phonetic_translation FROM release_phonetic_translations WHERE release_id = ? AND language_id = 24';
    $phoneticTranslationsResult = $pdoWrapperObj->executeQuery($phoneticTranslationsQuery, [$release_id]);
    if ($phoneticTranslationsResult === false) {
        show_pdo_error($phoneticTranslationsQuery, $pdoWrapperObj->getLastStatement());
    }
    foreach ($phoneticTranslationsResult as $item) {
        if ($item['field_name'] == 'release_name') {
            $japaneseReleaseName = $item['phonetic_translation'];
        } elseif ($item['field_name'] == 'artist_name') {
            $japaneseArtistName = $item['phonetic_translation'];
        }
    }
}

$distributionFormatId = isset($distribution_format_id) ? $distribution_format_id : $rel_row['distribution_format_id'];
$explicit = isset($explicit) ? $explicit : $productPhysicalData['explicit'];
$wholesalePrice = isset($wholesale_price) ? $wholesale_price : $productPhysicalData['wholesale_price'];
$exclusiveFor = isset($exclusive_for) ? $exclusive_for : $productPhysicalData['exclusive_for'];
$packagingId = isset($packaging_id) ? $packaging_id : $productPhysicalData['packaging_id'];
$hmvNotes = isset($hmv_notes) ? $hmv_notes : $productPhysicalData['hmv_notes'];
$meetingNotes = isset($meeting_notes) ? $meeting_notes : $productPhysicalData['meeting_notes'];
$productId = isset($product_id) ? $product_id : $productPhysicalData['product_id'];
$embargoDate = isset($embargo_date) ? $embargo_date : $productPhysicalData['embargo_date'];
$pricing = isset($pricing) ? $pricing : $productPhysicalData['pricing'];
$discount = isset($discount) ? $discount : $productPhysicalData['discount'];
$boxLot = isset($box_lot) ? $box_lot : $productPhysicalData['box_lot'];
$initialStock = isset($initial_stock) ? $initial_stock : $productPhysicalData['initial_stock'];
$pLine = isset($pline) ? $pline : $productPhysicalData['pline'];
$individual = isset($individual) ? $individual : $productPhysicalData['individual'];
$unitsPerSet = isset($units_per_set) ? $units_per_set : $productPhysicalData['units_per_set'];
$exportable = isset($exportable) ? $exportable : $productPhysicalData['exportable'];
$manufacturingObligation = isset($manufacturingObligation) ? $manufacturingObligation : $productPhysicalData['manufacturing_obligation'];
$productionNotes = isset($productionNotes) ? $productionNotes : $productPhysicalData['production_notes'];
$displayConfiguration = isset($displayConfiguration) ? $displayConfiguration : $productPhysicalData['display_configuration'];
$japanDistribution = isset($japanDistribution) ? $japanDistribution : $productPhysicalData['japan_distribution'];
$edition = isset($edition) ? $edition : $productPhysicalData['edition'];

$USReturnability = isset($USReturnability) ? $USReturnability : $USSupplyChainInfo['returnability'];
$canadaReturnability = isset($canadaReturnability) ? $canadaReturnability : $canadaSupplyChainInfo['returnability'];
$USReturnDisposition = isset($USReturnDisposition) ? $USReturnDisposition : $USSupplyChainInfo['return_disposition'];
$canadaReturnDisposition = isset($canadaReturnDisposition) ? $canadaReturnDisposition : $canadaSupplyChainInfo['return_disposition'];

/*
    This panel has been used in in_content and label_processing page
    so we have changed form action accordingly
*/
if ($currentPage == 'edit_ex_release') {
    $actionLocation = '/cont_mgmt/edit_ex_release.php';
} else {
    $actionLocation = '/cont_mgmt/edit_release.php';
}
$productTypeSql = 'SELECT dfm.distribution_format_media_id, dfm.name
                    FROM distribution_format df
                    INNER JOIN distribution_format_media dfm
                    ON dfm.distribution_format_media_id = df.distribution_format_media_id
                    WHERE df.display_flag = "Y" AND df.`context_type` = "physical"
                    GROUP BY df.distribution_format_media_id
                    ORDER BY df.distribution_format_media_format_id DESC, df.distribution_format_media_id ASC';
$productTypeResult = $pdoWrapperObj->executeQuery($productTypeSql, []);
if ($productTypeResult === false) {
    show_pdo_error($productTypeSql, $pdoWrapperObj->getLastStatement());
}

$productTypeFormatQuery = 'SELECT distribution_format_media_format_id,name FROM distribution_format_media_format ORDER BY name';
$productTypeFormatResult = $pdoWrapperObj->executeQuery($productTypeFormatQuery, []);
if ($productTypeFormatResult === false) {
    show_pdo_error($productTypeFormatQuery, $pdoWrapperObj->getLastStatement());
}

$configurationMappingData = array();
$configurationMappingQuery = 'SELECT distribution_format_media_id, distribution_format_media_format_id '
    . 'FROM distribution_format WHERE distribution_format_id = ?';
$configurationMappingResult = $pdoWrapperObj->executeQuery($configurationMappingQuery, [$distributionFormatId]);
if ($configurationMappingResult === false) {
    show_pdo_error($configurationMappingQuery, $pdoWrapperObj->getLastStatement());
}
$configurationMappingData = array(
    'distribution_format_media_id'        => $configurationMappingResult[0]['distribution_format_media_id'],
    'distribution_format_media_format_id' => $configurationMappingResult[0]['distribution_format_media_format_id']
);

$countryOfOriginQuery  = 'SELECT country_of_origin FROM releases WHERE release_id = ?';
$countryOfOriginResult = $pdoWrapperObj->executeQuery($countryOfOriginQuery, [$release_id]);
if ($countryOfOriginResult === false) {
    show_pdo_error($countryOfOriginQuery, $pdoWrapperObj->getLastStatement());
}
$countryOfOriginData = $countryOfOriginResult[0];
?>
<div class="panelHeader">
    <h3>Physical Metadata</h3>
</div>
<form name="physical_product" id="physical_product" action="<?=$actionLocation?>" method="post" >
    <div class="panelContent no-border-bottom">
        <input type="hidden" name="upc" value="<?=$upc?>">
        <input type="hidden" name="release_id" value="<?=$release_id?>">
        <input type="hidden" name="a" value="physical_product_metadata">
        <input type="hidden" name="product_id" value="<?=$productId?>">
        <table class="form">
            <tr>
                <th><span class="warning-text">*</span> Product Type:</th>
                <td>
                    <select id="distribution_format_media_id" name="distribution_format_media_id" class="small" onchange="getDisplayConfiguration();">
                        <option value="">Select One</option>
                        <?php
                        foreach ($productTypeResult as $productType) {?>
                            <option value="<?=$productType['distribution_format_media_id']?>" <?=($configurationMappingData['distribution_format_media_id'] == $productType['distribution_format_media_id'] ? 'selected' : '')?>><?=$productType['name']?></option>
                        <?php
                        }?>
                    </select>
                </td>
            </tr>
            <tr>
                <th><span class="warning-text">*</span> Format:</th>
                <td>
                    <select id="distribution_format_media_format_id" name="distribution_format_media_format_id" class="small" onchange="getDisplayConfiguration();">
                        <option value="">Select One</option>
                        <?php
                        foreach ($productTypeFormatResult as $productTypeFormat) {?>
                            <option value="<?=$productTypeFormat['distribution_format_media_format_id']?>" <?=($configurationMappingData['distribution_format_media_format_id'] == $productTypeFormat['distribution_format_media_format_id'] ? 'selected' : '')?>><?=$productTypeFormat['name']?></option>
                        <?php
                        }?>
                    </select>
                </td>
            </tr>
            <tr>
                <th><span class="warning-text">*</span> Units Per Set:</th>
                <td>
                    <input id="units_per_set" type="text" size="13" name="units_per_set" value="<?=$unitsPerSet?>" class="textField small" onchange="getDisplayConfiguration();">
                </td>
            </tr>
            <tr>
                <th><span class="warning-text">*</span> Display Configuration:</th>
                <td>
                    <input id="display_configuration" type="text" size="30" maxlength="128" name="display_configuration" value="<?=htmlspecialchars($displayConfiguration);?>" class="textField small">
                </td>
            </tr>
            <tr>
                <th><span class="warning-text">*</span>Packaging:</th>
                <td>
                    <select name="packaging_id" class="small">
                        <option value="">Select One</option>
                    <?php
                    foreach ($physicalProductPackagingResult as $physicalProductPackaging) {?>
                        <option value="<?=$physicalProductPackaging['id']?>" <?=(($packagingId == $physicalProductPackaging['id']) ? 'selected' : '')?>><?=$physicalProductPackaging['name']?></option>
                    <?php
                    }?>
                    </select>
                </td>
            </tr>
            <tr>
                <th>Embargo Date:</th>
                <td>
                    <input type="text" name="embargo_date" value="<?=$embargoDate?>" readonly="readonly" type="text" size="10" maxlength="10" class="textFieldDate small">
                    <a href="#" onclick="showCal('Cal10');"><img src="/images/icoCalendar.gif" border="0" alt="Calendar" align="absmiddle"></a>
                </td>
            </tr>
            <tr>
                <th>Orchard Pricing:</th>
                <td>
                    <?=$physicalPricingTierValue?>
                    <br />
                    <a href="/pricing/product/<?= $rel_row['release_id'] ?>/override" >Manage Pricing</a>
                </td>
            </tr>
            <tr>
                <th>Discount Policy:</th>
                <td>
                    <textarea rows="4" cols="50"  name="discount" class="textField small"><?=$discount?></textarea>
                </td>
            </tr>
            <tr>
                <th>
                    Projections:
                </th>
                <td>
                    <a href="/goals/?release_id=<?= $rel_row["release_id"]; ?>">
                        View/Edit Projections
                    </a>
                </td>
            </tr>

            <!-- Japan Physical Fields: Japan Distribution, Japanese Release Name -->
            <? if ($isOaJapanPhysicalFieldsEnabled) { ?>
            <tr>
                <th>Japan Distribution:</th>
                <td>
                    <select name="japan_distribution">
                        <option
                            value="no"
                            <?=($japanDistribution == 'no' ? 'selected' : '')?>
                        >
                            No
                        </option>
                        <option
                            value="yes_only"
                            <?=($japanDistribution == 'yes_only' ? 'selected' : '')?>
                        >
                            Yes, Japan Only
                        </option>
                        <option
                            value="yes_other"
                            <?=($japanDistribution == 'yes_other' ? 'selected' : '')?>
                        >
                            Yes, Japan and other territories
                        </option>
                    </select>
                <td>
            </tr>
            <tr>
                <th>Japanese Release Name:</th>
                <td>
                    <?=($japaneseReleaseName ? $japaneseReleaseName : 'N/A')?>
                <td>
            </tr>
            <? } ?>

        </table>
        <table class="form">
             <tr>
                <th>Box Lot:</th>
                <td>
                    <input maxlength="128" type="text" size="13" name="box_lot" value="<?=$boxLot?>" class="textField small">
                </td>
            </tr>
            <tr>
                <th><?='Initial Stock'?>:</th>
                <td>
                    <input maxlength="128" type="text" size="13" name="initial_stock" value="<?=$initialStock?>" class="textField small">
                </td>
            </tr>
            <tr>
                <th><span class="warning-text">*</span> Explicit:</th>
                <td>
                    <select name="explicit" class="small">
                        <option value="">Select One</option>
                        <option value="Y" <?=(($explicit == 'Y') ? 'selected' : '')?>>Yes</option>
                        <option value="N" <?=(($explicit == 'N') ? 'selected' : '')?>>No</option>
                    </select>
                </td>
            </tr>
             <tr>
                <th>Exclusive For:</th>
                <td>
                    <input maxlength="128" type="text" size="35" name="exclusive_for" value="<?=$exclusiveFor?>" class="textField small">
                </td>
            </tr>
            <tr>
                <th class="required"><span class="required">*</span>P-Line:</th>
                <td>
                    <input minlength="1" type="text" size="35" name="p_line" value="<?=$pLine?>" class="textField small">
                </td>
            </tr>
            <tr>
                <th class="required"><span class="required">*</span>Artist Individual:</th>
                <td>
                    <select name="individual" class="small">
                        <option value="" <?=(($individual === null) ? 'selected' : '')?>>Select</option>
                        <option value="Y" <?=(($individual === 'Y') ? 'selected' : '')?>>Yes</option>
                        <option value="N" <?=(($individual === 'N') ? 'selected' : '')?>>No</option>
                    </select>
                </td>
            </tr>
            <tr>
                <th>Exportable:</th>
                <td>
                    <select name="exportable" class="small">
                        <option value="" <?=(($exportable === null) ? 'selected' : '')?>>N/A</option>
                        <option value="Y" <?=(($exportable === 'Y') ? 'selected' : '')?>>Yes</option>
                        <option value="N" <?=(($exportable === 'N') ? 'selected' : '')?>>No</option>
                    </select>
                </td>
            </tr>
            <tr>
                <th>Manufacturing Obligation:</th>
                <td>
                    <select name="manufacturing_obligation" class="small">
                        <option value="" <?=(($manufacturingObligation === null) ? 'selected' : '')?>>N/A</option>
                        <option value="Y" <?=(($manufacturingObligation === 'Y') ? 'selected' : '')?>>Yes</option>
                        <option value="N" <?=(($manufacturingObligation === 'N') ? 'selected' : '')?>>No</option>
                    </select>
                </td>
            </tr>
            <tr>
                <th>Country of Origin:</th>
                <td>
                    <select class="small" name="country_of_origin">
                        <option value="">Choose One:</option>
                        <option value="">-----------------------------</option>
                        <?php
                        $countryQuery = 'SELECT id, name FROM country ORDER BY name';
                        $countryResult = $pdoWrapperObj->executeQuery($countryQuery, []);
                        if ($countryResult === false) {
                            show_pdo_error($countryResult, $pdoWrapperObj->getLastStatement());
                        }
                        foreach ($countryResult as $countryRow) { ?>
                            <option value="<?php echo $countryRow['id']?>"
                                <?php
                                if ($countryOfOriginData['country_of_origin'] == $countryRow['id']) {
                                    echo ' selected="selected"';
                                } ?> >
                                <?php echo $countryRow['name']; ?>
                            </option>
                        <?php
                        } ?>
                    </select>
                </td>
            </tr>
            <tr>
                <th>Production Notes:</th>
                <td>
                    <textarea rows="4" cols="50"  name="production_notes" class="textField small"><?=$productionNotes?></textarea>
                </td>
            </tr>

            <!-- Japan Physical Fields: Edition, Japanese Artist Name -->
            <? if ($isOaJapanPhysicalFieldsEnabled) { ?>
            <tr>
                <th>Edition:</th>
                <td>
                    <select name="edition">
                        <option
                            value=""
                            <?=(!$edition ? 'selected' : '')?>
                        >
                            N/A
                        </option>
                        <option
                            value="normal_edition"
                            <?=($edition == 'normal_edition' ? 'selected' : '')?>
                        >
                            Normal Edition
                        </option>
                        <option
                            value="first_run_limited_edition"
                            <?=($edition == 'first_run_limited_edition' ? 'selected' : '')?>
                        >
                            First Run Limited Edition
                        </option>
                        <option
                            value="initial_limited_edition"
                            <?=($edition == 'initial_limited_edition' ? 'selected' : '')?>
                        >
                            Initial Limited Edition
                        </option>
                        <option
                            value="limited_edition"
                            <?=($edition == 'limited_edition' ? 'selected' : '')?>
                        >
                            Limited Edition
                        </option>
                        <option
                            value="period_limited_edition"
                            <?=($edition == 'period_limited_edition' ? 'selected' : '')?>
                        >
                            Period Limited Edition
                        </option>
                    </select>
                <td>
            </tr>
            <tr>
                <th>Japanese Artist Name:</th>
                <td>
                    <?=($japaneseArtistName ? $japaneseArtistName : 'N/A')?>
                <td>
            </tr>
            <? } ?>

        </table>

    </div>
    <div class="panelContent no-border-bottom top-margin">
        <div class="panelSummary">Supply Chain Return Info</div>
        <table class="form">
            <tr>
                <th>Returnability</th>
                <td><em>Is this product returnable?</em></td>
            </tr>
            <tr>
                <th>United States</th>
                <td>
                    <select name="USReturnability" class="small">
                        <option value="" <?=(($USReturnability === null) ? 'selected' : '')?>>Select Returnability</option>
                        <option value="Y" <?=(($USReturnability === 'Y') ? 'selected' : '')?>>Yes</option>
                        <option value="N" <?=(($USReturnability === 'N') ? 'selected' : '')?>>No</option>
                    </select>
                </td>
            </tr>
            <tr>
                <th>Canada</th>
                <td>
                    <select name="canadaReturnability" class="small">
                        <option value="" <?=(($canadaReturnability === null) ? 'selected' : '')?>>Select Returnability</option>
                        <option value="Y" <?=(($canadaReturnability === 'Y') ? 'selected' : '')?>>Yes</option>
                        <option value="N" <?=(($canadaReturnability === 'N') ? 'selected' : '')?>>No</option>
                    </select>
                </td>
            </tr>
        </table>
        <table class="form">
            <tr>
                <th>Return Disposition</th>
                    <td><em>If this product gets returned, what should we do with it?</em></td>
            </tr>
            <tr>
                <th>United States</th>
                <td>
                    <select name="USReturnDisposition" class="small">
                        <option value="" <?=(($USReturnDisposition === null) ? 'selected' : '')?>>Select Return Disposition</option>
                        <option value="Keep" <?=(($USReturnDisposition === 'Keep') ? 'selected' : '')?>>Keep</option>
                        <option value="Scrap" <?=(($USReturnDisposition === 'Scrap') ? 'selected' : '')?>>Scrap</option>
                    </select>
                </td>
            </tr>
            <tr>
                <th>Canada</th>
                <td>
                    <select name="canadaReturnDisposition" class="small">
                        <option value="" <?=(($canadaReturnDisposition === null) ? 'selected' : '')?>>Select Return Disposition</option>
                        <option value="Keep" <?=(($canadaReturnDisposition === 'Keep') ? 'selected' : '')?>>Keep</option>
                        <option value="Scrap" <?=(($canadaReturnDisposition === 'Scrap') ? 'selected' : '')?>>Scrap</option>
                    </select>
                </td>
            </tr>
        </table>      
    </div>
    
    <?php if ($isCCMPhysicalSupplyChainInfoOaEnabled) { ?>
    <div class="panelContent no-border-bottom top-margin supply-chain-info">
        <h5 class="panelHeader">Supply Chain Specific Info</h5>
        <table class="form">
            <tbody>
            <?php foreach ($storeResults as $index => $store) {
                $name = is_array($store) ? $store['name'] : $store;
                $saleDate = is_array($store) ? ($store['sale_start_date'] ?? '') : '';
                $stock = is_array($store) ? ($store['initial_stock'] ?? '') : '';

            ?>
            <tr>
                <th><?php echo htmlspecialchars($name); ?></th>

                <th><label>Sales Start Date:</label></th>
                <td>
                    <input 
                        type="date" 
                        name="physical_sales_start_date[<?php echo $index; ?>]" 
                        id="sales_start_date_<?php echo $index; ?>"
                        value="<?php echo htmlspecialchars($saleDate); ?>"
                        <?= $store['restricted'] ? 'disabled title="This supply chain is carved out."' : '' ?>
                    >
                </td>

                <th><label>Initial Stock:</label></th>
                <td>
                    <input 
                        type="number" 
                        name="physical_initial_stock[<?php echo $index; ?>]" 
                        id="initial_stock_<?php echo $index; ?>" 
                        min="0"
                        value="<?php echo htmlspecialchars($stock); ?>"
                        <?= $store['restricted'] ? 'disabled title="This supply chain is carved out."' : '' ?>
                    >
                </td>
            </tr>
            <?php } ?>
            </tbody>
        </table>
    </div>
    <?php } ?>
    <div class="panelContent top-margin">
        <div class="panelButtons">
            <input type="submit" value="Submit" class="btn btn-primary btn-sm" />
        </div>
    </div>
</form>
<script language="javascript">
    addCalendar("Cal10", "Select Date", "embargo_date", "physical_product");
</script>
<script language="javascript">
    function getDisplayConfiguration() {
        var productType = $('#distribution_format_media_id option:selected').text();
        var format = $('#distribution_format_media_format_id option:selected').text();
        var productFormat = (format !== 'Select One') ? format : '';
        var unitsPerSet = $('#units_per_set').val();
        var displayConfiguration = unitsPerSet + ' x ' + productType + ' ' + productFormat;
        $('#display_configuration').val(displayConfiguration);
    }
</script>