<?php

/*************************  Change History  *****************************
 * 03/30/2006 - Jian Wu
 * -    Added release_date column
 * -    Added Generate Sony XML metadata link
 *
 * 04/03/2006 - Jian Wu
 * -    Fixed sub query that returns more than one row for carveout check.
 *
 * 04/04/2006 - Jian Wu
 * -    Switched contracts and carvetouts columns.
 *
 * 03/27/2007 - Jian  Wu
 * -    Updated metadata link to use Orchard XML.
 ************************************************************************/
require_once __DIR__ . '/../../../vendor/autoload.php';
use Orchard\Mysqli\QueryData;
use Orchard\Mysqli\Wrapper as MysqliWrapper;
$wrapperObj = new MysqliWrapper($mysqli);

use Orchard\Service\ReleaseProductType;
use Orchard\FeatureFlags\Context\AccountContext;
use Orchard\FeatureFlags\FeatureService;

$page = ($page && is_numeric($page)) ? $page : 1;
$sort_by = isset($sort_by) ? stripslashes($sort_by) : '';
$sort_desc = ($sort_desc) ? stripslashes($sort_desc) : 0;

$pageRecord = ($pageRecord && is_numeric($pageRecord)) ? $pageRecord : 100;
$varQueryString = formatURLQueryString('page,pageRecord', array($_REQUEST));
$url = formatURLQueryString('sort_by,sort_desc,page,pageRecord', array($_REQUEST));
$pageNum = 0;
$total = 0;

$logger = Zend_Registry::get('applicationLoggerOA');
$featuresService = new FeatureService($logger);

$isBulkDeletionPerReleaseIdEnabled = $featuresService->isVariant(
    'bulk_deletion_per_release_id',
    'enabled',
    AccountContext::fromLegacy((string)$_SESSION['S_USERID'], 'oa')
);

$selectFields = '';
$joinDistributionFormat = '';
$productType = '';
$selectFields = ' r.sale_start_date, df.context_type AS format_context, r.distribution_format_id, r.product_type_id,';
$joinDistributionFormat = 'LEFT JOIN distribution_format df ON df.distribution_format_id = r.distribution_format_id';

$selectFields .= ' pst.subtype, r.format, ';
$selectResolutionField = '(SELECT tv.resolution FROM track t LEFT JOIN track_video tv ON t.id = tv.id WHERE t.upc = r.upc GROUP BY t.upc) AS resolution, ';
$selectdistributionMedia = '(SELECT dfmt.name FROM distribution_format dft LEFT JOIN distribution_format_media dfmt
    ON dft.distribution_format_media_id = dfmt.distribution_format_media_id WHERE dft.distribution_format_id = r.distribution_format_id) AS format_media_name, ';
$joinFormatMediaName = 'LEFT JOIN distribution_format_media dfm ON dfm.distribution_format_media_id = df.distribution_format_media_format_id';
$joinProductSubtype = 'LEFT JOIN product_subtype pst ON pst.id = r.product_subtype_id';


$acct = new target_percentage();

$total_artist = $acct->GetTotalArtists('vendor', $vendor_id, $wrapperObj);
$total_releases = $acct->GetTotalReleases($wrapperObj, 'vendor', $vendor_id);
$total_tracks = $acct->GetTotalTracks($wrapperObj, 'vendor', $vendor_id);

$art_rel_query = "SELECT SQL_CALC_FOUND_ROWS s.subaccount_name, s.subaccount_id, a.artist_id, a.name, a.artist_id, r.release_id, r.release_name, r.release_date, r.upc, r.display_upc, r.ingestion_completed, r.product_code, r.deletions, $selectFields
			$selectResolutionField
			$selectdistributionMedia
			(SELECT COUNT(id) FROM track WHERE upc = r.upc AND track_type = 'video') AS video_track_count,
			(SELECT COUNT(id) FROM track WHERE upc = r.upc) AS track_count_per_release
		FROM artist_info a
			INNER JOIN releases r ON a.artist_id  = r.artist_id
			LEFT JOIN subaccount s ON s.subaccount_id = r.subaccount_id
			$joinDistributionFormat
			$joinFormatMediaName
			$joinProductSubtype
		WHERE a.vendor_id = ? 
            AND r.not_for_distribution != 'SMEAnalyticsDummy'
            AND r.release_status = 'in_content'
		GROUP BY r.upc";

switch ($sort_by) {
    case 'added':
        $order_by = "r.ingestion_completed";
        break;
    case 'upc':
        $order_by = 'r.upc';
        break;
    case 'an':
        $order_by = 'a.name';
        break;
    case 'rn':
        $order_by = 'r.release_name';
        break;
    case 'rd':
        $order_by = 'r.release_date';
        break;
    // below case ri is under bulk_deletion_per_release_id feature
    case 'ri':
        $order_by = 'r.release_id';
    case 'aid':
        $order_by = 'a.artist_id';
        break;
    case 'sa':
        $order_by = 's.subaccount_name';
        break;
    case 'pc':
        $order_by = 'r.product_code';
        break;
    // below cases pt and ssd are under oa_catalog_fields feature
    case 'pt':
        $order_by = '
        CASE
            WHEN df.distribution_format_id = 1 AND df.context_type = "digital" THEN -3
            WHEN r.product_type_id = 3 THEN -2
            WHEN r.distribution_format_id = 57 THEN -1
            ELSE r.product_type_id
        END';
        break;
    case 'fm':
        $order_by = 'resolution, r.format';
        break;
    case 'ssd':
        $order_by = 'r.sale_start_date';
        break;
    default:
        $order_by = 'r.release_date';
        $sort_by = 'rd';
        $sort_desc = 1;
}

$art_rel_query .= ' ORDER BY ' . $order_by . ($sort_desc ? ' DESC' : '');
$dataParams = new QueryData();
$dataParams->addDataParam('i', $vendor_id);

if (!$viewall && !$viewmore) {
    $art_rel_query .= ' LIMIT 0, 10';
}
else {
    $art_rel_query .= ' LIMIT ?, ?';
    $dataParams->addDataParam('i', (($page - 1) * $pageRecord));
    $dataParams->addDataParam('i', $pageRecord);
}

$art_rel_result = $wrapperObj->executeQuery($art_rel_query, $dataParams);

if ($art_rel_result === false) {
    showierror($art_rel_query);
}

$query = 'SELECT FOUND_ROWS() AS total';
$dataParams = new QueryData();
$totalReleases = $wrapperObj->executeQuery($query, $dataParams);

if ($totalReleases === false) {
    showierror($query);
}

$total_row = $totalReleases[0];
$total = $totalReleasesCount = $total_row['total'];
$pageNum = ceil($totalReleasesCount / $pageRecord);
$page = $page > $pageNum ? $pageNum : $page;

if ($viewall or $viewmore) {
    if ($total) {
        echo paginate($page, $pageRecord, $pageNum, $varQueryString);
    }
} ?>
<div class="panelHeader">
    <h3>Catalog</h3>
    <?php if (check_user_permission(37)) { ?>
        <ul>
            <?php
            if (!isset($isLableContract)) {
               $isLableContract = check_label_contract($vendor_id, $wrapperObj);
            }
            if ($isLableContract and $vendor_status != 'deletion') {
                ?>
                <li><a href="/cont_mgmt/add_artist.php?vendor_id=<?= $vendor_id ?>" class="btn btn-link btn-sm">Add Artist</a></li>
            <?php
            } ?>
                <li><a href="/cont_mgmt/bulk_takedown_update.php" class="btn btn-link btn-sm">Bulk Takedown</a></li>
                <li><a href="/cont_mgmt/bulk_deletion.php?vendor_id=<?= $vendor_id ?>" class="btn btn-link btn-sm">Bulk Deletion</a></li>
        </ul>
    <?php } ?>
</div>
<div class="panelContent">
    <?php if ($art_rel_result > 0) { ?>
        <div class="panelSummary">
            <ul>
                <li>Artists: <?= $total_artist ?></li>
                <li>Releases: <?= $totalReleasesCount ?></li>
                <li>Tracks: <?= array_sum(array_values($total_tracks)) ?></li>
                <li class="right">
                    <?php
                    if (!$viewall) {
                        if ($viewmore) {
                            ?>
                            <a href="/cont_mgmt/view_vendor.php?vendor_id=<?= $vendor_id ?>">View Fewer</a> /
                        <?php
                        }
                        else {
                            ?>
                            <a href="/cont_mgmt/view_vendor.php?vendor_id=<?= $vendor_id ?>&viewmore=1">View
                                More</a> /
                        <?php } ?>
                        <a href="/cont_mgmt/view_all_catalog.php?vendor_id=<?= $vendor_id ?>">View All</a>
                    <?php
                    } ?>
                </li>
            </ul>
        </div>

        <table class="data" id="catalog-table">
            <tr>
                <th><?= sortColumnHeader('Artist ID', 'aid', $url) ?></th>
                <th class="center"><?= sortColumnHeader('Artist Name', 'an', $url) ?></th>
                <th class="center"><?= sortColumnHeader('UPC', 'upc', $url) ?></th>
                <?php if ($isBulkDeletionPerReleaseIdEnabled) { ?>
                    <th class='center'><?= sortColumnHeader('Release Id', 'ri', $url) ?></th>
                <?php } ?>
                <th class='center'><?= sortColumnHeader('Product Type', 'pt', $url) ?></th>
                <th class="center"><?=sortColumnHeader('Format', 'fm', $url) ?></th>
                <th class="center"><?= sortColumnHeader('Product Code', 'pc', $url) ?></th>
                <th class="center"><?= sortColumnHeader('Release Name', 'rn', $url) ?></th>
                <?php if ($vend_row['is_distributor'] == 'Y') { ?>
                    <th class="center"><?= sortColumnHeader('Subaccount', 'sa', $url) ?></th>
                <?php } ?>
                <th class="center"><?= sortColumnHeader('Release Date', 'rd', $url) ?></th>
                <th class="center"><?= sortColumnHeader('Date Added', 'added', $url) ?></th>
                <th class='center'><?= sortColumnHeader('Sale Start Date', 'ssd', $url) ?></th>
                <?php if (check_user_permission(39)) { ?>
                        <th class="center">Contract</th>
                <?php } ?>
                <th class="center">Carveouts</th>
                <th class="center">Release Status</th>
            </tr>
            <?php
            $rci = 0;
            $stream_token = getToken("stream", $wrapperObj);

            foreach ($art_rel_result as $art_rel_row) {
                $row_class = (++$rci & 1) ? '' : 'alt'; ?>
                <tr class="<?= $row_class ?>">
                    <td><?= $art_rel_row["artist_id"] ?></td>
                    <td>
                        <a href="/cont_mgmt/view_artist.php?artist_id=<?= $art_rel_row["artist_id"] ?>"><?= $art_rel_row["name"] ?></a>
                    </td>
                    <td class="center"><?php if ($art_rel_row['deletions'] == 'Y') {
                            echo '<del>';
                        } ?><?=
                        $art_rel_row["display_upc"] ?><?php if ($art_rel_row['deletions'] == 'Y') {
                            echo '</del>';
                        } ?></td>
                    <?php if ($isBulkDeletionPerReleaseIdEnabled) { ?>
                        <td class="center"><?=$art_rel_row['release_id']?> </td>
                    <?php } ?>
                    <?php
                        $releaseProductType = new ReleaseProductType();
                        $productType = $releaseProductType->getDisplayTextForReleaseType($art_rel_row);
                        if ($art_rel_row['format_context'] == 'physical' && $art_rel_row['format_media_name'] != null) {
                            $productType .= ' - ' . $art_rel_row['format_media_name'];
                        }
                        if (($art_rel_row['product_type_id'] == 2 || $art_rel_row['product_type_id'] == 3) && $art_rel_row['subtype'] != null) {
                            $productType .= ' - ' . $art_rel_row['subtype'];
                        }
                    ?>
                    <td class='center'><?=$productType ?></td>
                    <?php
                        $col_value = '';
                        if ($art_rel_row['product_type_id'] == 2 || $art_rel_row['product_type_id'] == 3) { // for Film/TV releases
                            $col_value = $art_rel_row['resolution'];
                        }
                        if ($art_rel_row['product_type_id'] == 1 && $productType !== 'Music Video') { //for Physical and Digital Audio releases
                            $col_value = $art_rel_row['format'];
                        }
                    ?>
                    <td class="center"><?=$col_value?></td>
                    <td class="center"><?=$art_rel_row['product_code']?> </td>
                    <td>
                         <a
                            href="/cont_mgmt/view_release.php?upc=<?= $art_rel_row["upc"] ?>"><?php if ($art_rel_row['deletions'] == 'Y') {
                                echo '<del>';
                            } ?><?=
                            htmlspecialchars($art_rel_row["release_name"]) ?><?php if ($art_rel_row['deletions'] == 'Y') {
                                echo '</del>';
                            } ?></a></td>
                    <?php if ($vend_row['is_distributor'] == 'Y') { ?>
                        <td><?php if ($art_rel_row["subaccount_name"] != "") { ?>
                                <a href="/subaccount/viewsubaccount/subaccount_id/<?php echo $art_rel_row["subaccount_id"]; ?>"><?php echo $art_rel_row["subaccount_name"]; ?></a>
                            <?php
                            }
                            else {
                                echo "--"; //Display none when no subaccount name exists
                            }
                            ?>
                        </td>
                    <?php } ?>
                    <td class="center"><?= format_date($art_rel_row["release_date"]) ?></td>
                    <td class="center"><?= format_date($art_rel_row["ingestion_completed"]) ?></td>
                    <td class='center'><?= format_date($art_rel_row['sale_start_date']) ?></td>
                    <?php if (check_user_permission(39)) { ?>
                        <td><?php
                            if ($vend_row["contract_id"] != "") {
                                echo "NA";
                            }
                            else {
                                echo "Unavailable";
                            } ?>
                        </td>
                    <?php }
                    $carveoutSql = "SELECT IF((SELECT restriction_id FROM release_dms_master_restriction WHERE upc = r.upc ORDER BY restriction_id DESC LIMIT 1) > 0
                                    OR (SELECT restriction_id FROM release_dms_restriction WHERE upc = r.upc ORDER BY restriction_id DESC LIMIT 1) > 0
                                    OR (SELECT restriction_id FROM release_territory_restriction  WHERE upc = r.upc ORDER BY restriction_id DESC LIMIT 1) > 0, 'Yes', 'No') AS carveouts
                                FROM releases r WHERE r.upc = ?";
                    $dataParams = new QueryData();
                    $dataParams->addDataParam('i', $art_rel_row['upc']);
                    $results = $wrapperObj->executeQuery($carveoutSql, $dataParams);
                    if ($results === false) {
                        showierror($carveoutSql);
                    }
                    $row = $results[0];
                    ?>
                    <td class="center"><?php echo (count($results) > 0) ? $row['carveouts'] : ''; ?></td>
                    <td align="center"><?php if ($art_rel_row["upc"]) { ?><a
                            href="/warehouse/individual_upc_overall_andy.php?upc=<?= $art_rel_row["upc"] ?>"><img
                                    src="/images/icoStatus.gif" border="0" alt="Status"/></a><?php } ?></td>
                </tr>
            <?php } ?>
        </table>
    <?php
    }
    else {
        ?>
        <table class="data">
            <tr>
                <td>No catalogs found.</td>
            </tr>
        </table>
    <?php
    } ?>
</div>
<?php
if ($viewall or $viewmore) {
    if ($total) {
        echo paginate($page, $pageRecord, $pageNum, $varQueryString, 'bottom');
        echo '<br />';
    }
} ?>