<?php

require_once(__DIR__ . '/../../../vendor/autoload.php');
require_once('constants.php');

use Orchard\Service\GraphqlGateway as GraphqlGatewayServiceClient;
use Orchard\FeatureFlags\Context\AccountContext;
use Orchard\FeatureFlags\FeatureService;
use Orchard\Messages\WebMessage;
use Orchard\Mysqli\QueryData;
use Orchard\Mysqli\Wrapper as MysqliWrapper;

$logger = Zend_Registry::get('applicationLoggerOA');
$awsConfigs = yaml_parse_file(APPLICATION_PATH . '/configs/aws.yml');
$userContext = AccountContext::fromLegacy((string)$_SESSION['S_USERID'], 'oa');
$featuresService = new FeatureService($logger);

$isOaParticipantIdentifierEnabled = $featuresService->isVariant(
    'oa_participant_identifier',
    'enabled',
    $userContext
);

$isOaSpotifyArtistKeyEnabled = $featuresService->isVariant(
    'ccm_oa_spotify_artist_key',
    'enabled',
    $userContext
);

$isUpdateSpotifyAppleIdsWithGraphqlEnabled = $featuresService->isVariant(
    'update_spotify_apple_ids_with_graphql',
    'enabled',
    $userContext
);

$isOAFeatureToPrimaryEnabled = $featuresService->isVariant(
    'oa_feature_to_primary',
    'enabled',
    $userContext
);

if ($isUpdateSpotifyAppleIdsWithGraphqlEnabled) {
    $isOaParticipantIdentifierEnabled = false;
}

$userId = $_SESSION['S_USERID'];
$graphqlGatewayServiceClient = new GraphqlGatewayServiceClient($userId, $logger);

$wrapperObj = new MysqliWrapper($mysqli);
$release_id = getReleaseIdByUpc($wrapperObj, $upc);
// *******************************Fetch vendor_id and subaccount_id*******************************
$vendorSql = 'SELECT p.vendor_id, p.subaccount_id FROM project p
    INNER JOIN releases r ON r.project_id = p.project_id WHERE r.upc = ?';
$dataParams = new QueryData();
$dataParams->addDataParam('i', $upc);
$vendorResult = $wrapperObj->executeQuery($vendorSql, $dataParams);
if ($vendorResult === false) {
    showierror($vendorSql);
}
$vendorResult = $vendorResult[0];
// *****************************************************************************
if ($action == 'edit' and $release_artist_id) {
    if (trim($artist_name) && (empty($apple_artist) || ctype_digit($apple_artist)) && (empty($spotify_artist) || ctype_alnum($spotify_artist))) {
        $sql = 'UPDATE release_artist SET artist_name = ?, role = ?';
        if (!$isOaParticipantIdentifierEnabled && !$isUpdateSpotifyAppleIdsWithGraphqlEnabled) {
            $sql .= ', url = ?';
        }
        $sql .= ' WHERE release_artist_id = ?';
        $data_params = new QueryData();
        $data_params->addDataParam('s', trimCommas($artist_name));
        $data_params->addDataParam('s', $role);
        if (!$isOaParticipantIdentifierEnabled && !$isUpdateSpotifyAppleIdsWithGraphqlEnabled) {
            $data_params->addDataParam('s', $url);
        }
        $data_params->addDataParam('i', $release_artist_id);
        if ($wrapperObj->executeQuery($sql, $data_params, MysqliWrapper::RETURN_AFFECTED_ROWS) === false) {
            showierror($sql);
        }
        // *******************************Update Artist URIs*****************************
        $isParticipantSaveFailed = false;
        if ($isOaParticipantIdentifierEnabled) {
            $artistInfo = $vendorResult;
            $artistInfo['orchard_artist_name'] = $artist_name;

            $artistInfo['store_id'] = APPLE_STORE_ID;
            if (!empty($apple_artist)) {
                $artistInfo['store_artist_id'] = $apple_artist;
                updateArtistURIs($wrapperObj, $artistInfo);
            } else {
                deleteParticipantIdentifier($wrapperObj, $artistInfo);
            }

            $artistInfo['store_id'] = SPOTIFY_STORE_ID;
            if (!empty($spotify_artist)) {
                $artistInfo['store_artist_id'] = $spotify_artist;
                updateArtistURIs($wrapperObj, $artistInfo);
            } else {
                deleteParticipantIdentifier($wrapperObj, $artistInfo);
            }
        } elseif ($isUpdateSpotifyAppleIdsWithGraphqlEnabled) {
            if (!empty($labelParticipantId)){
                $artistInfo = $vendorResult;
                $artistInfo['vendorId'] = $artistInfo['vendor_id'];
                $artistInfo['subaccountId'] = $artistInfo['subaccount_id'];
                $artistInfo['name'] = trim($artist_name);
                $artistInfo['id'] = $labelParticipantId;
                $artistInfo['spotifyId'] = !empty($spotify_artist) ? trim($spotify_artist) : null;
                $artistInfo['appleMusicId'] = !empty($apple_artist) ? trim($apple_artist) : null;
                $artistInfo['spotifyArtistKey'] = !empty($spotify_artist_key) ? trim($spotify_artist_key) : null;
                unset($artistInfo['vendor_id']);
                unset($artistInfo['subaccount_id']);
                $updateParticipant = $graphqlGatewayServiceClient->updateParticipantById($artistInfo);
                if ($updateParticipant['errors']) {
                    $isParticipantSaveFailed = true;
                }
            } else {
                $artistInfo = $vendorResult;
                $artistInfo['vendorId'] = $artistInfo['vendor_id'];
                $artistInfo['subaccountId'] = $artistInfo['subaccount_id'];
                $artistInfo['name'] = trim($artist_name);
                $artistInfo['spotifyId'] = !empty($spotify_artist) ? trim($spotify_artist) : null;
                $artistInfo['appleMusicId'] = !empty($apple_artist) ? trim($apple_artist) : null;
                $artistInfo['spotifyArtistKey'] = !empty($spotify_artist_key) ? trim($spotify_artist_key) : null;
                unset($artistInfo['vendor_id']);
                unset($artistInfo['subaccount_id']);
                $createParticipant = $graphqlGatewayServiceClient->createLabelParticipants($artistInfo);
                if ($createParticipant['errors']) {
                    $isParticipantSaveFailed = true;
                }
            }
        }
        // ******************************************************************************
        $msg = $isParticipantSaveFailed === true ? '&err_msg[]=jbs19120' : '&confirm_msg=jbs19101';
        header("Location: manage_release_artists.php?upc=$upc" . $msg);
        exit();
    } else {
        $msg = '';

        if (!trim($artist_name)) {
            $msg .= '&err_msg[]=jbs19102';
        }
        if (!empty($apple_artist) && !ctype_digit($apple_artist)) {
            $encrypt = WebMessage::getParamHandler('Encrypt');
            $apple_artist_id = '<b style="color:#000000;">1419227</b>';
            $msg_apple_artist_id = $encrypt->process($apple_artist_id);
            $msg .= '&err_msg[]=32edty66&msg_apple_artist_id=' . $msg_apple_artist_id;            
        }
        if (!empty($spotify_artist) && !ctype_alnum($spotify_artist)) {
            $encrypt = WebMessage::getParamHandler('Encrypt');
            $spotify_artist_id = '<b style="color:#000000;">3Nrfpe0tUJi4K4DXYWgMUX</b>';
            $msg_spotify_artist_id = $encrypt->process($spotify_artist_id);
            $msg .= '&err_msg[]=32edty65&msg_spotify_artist_id=' . $msg_spotify_artist_id;
        }
        header("Location: manage_release_artists.php?upc=$upc" . $msg);
        exit();
    }
} elseif ($action == 'add') {
    if (trim($artist_name)) {
        $urlQuerystr = ', url';
        $urlPlaceholder = ', ?';
        if ($isOaParticipantIdentifierEnabled || $isUpdateSpotifyAppleIdsWithGraphqlEnabled) {
            $urlQuerystr = '';
            $urlPlaceholder = '';
        }
        $sql = 'INSERT INTO release_artist (upc, artist_name'. $urlQuerystr .', role, release_id)
            VALUES (?, ?'. $urlPlaceholder .', ?, ?)';
        $data_params = new QueryData();
        $data_params->addDataParam('i', $upc);
        $data_params->addDataParam('s', trimCommas($artist_name));
        if (!$isOaParticipantIdentifierEnabled && !$isUpdateSpotifyAppleIdsWithGraphqlEnabled) {
            $data_params->addDataParam('s', $url);
        }
        $data_params->addDataParam('s', $role);
        $data_params->addDataParam('i', $release_id);
        if ($wrapperObj->executeQuery($sql, $data_params, MysqliWrapper::RETURN_INSERT_ID) === false) {
            showierror($sql);
        }

        $msg = 'jbs19103';
        header("Location: manage_release_artists.php?upc=$upc&confirm_msg=$msg");
        exit();
    } else {
        $msg = 'jbs19102';
        header("Location: manage_release_artists.php?upc=$upc&err_msg=$msg");
        exit();
    }
} elseif ($action == 'delete' and $release_artist_id) {
    $sql = 'DELETE FROM release_artist WHERE release_artist_id = ? AND upc = ?';
    $data_params = new QueryData();
    $data_params->addDataParam('i', $release_artist_id);
    $data_params->addDataParam('i', $upc);
    if ($wrapperObj->executeQuery($sql, $data_params, MysqliWrapper::RETURN_AFFECTED_ROWS) === false) {
        showierror($sql);
    }
    $msg = 'jbs19104';
    header("Location: manage_release_artists.php?upc=$upc&confirm_msg=$msg");
    exit();
}

$sql = 'SELECT release_artist_id, artist_name, url, role FROM release_artist WHERE release_id = ?';
$data_params = new QueryData();
$data_params->addDataParam('i', $release_id);
$result = $wrapperObj->executeQuery($sql, $data_params);
if ($result === false) {
    showierror($sql);
}
$artistUriClass = '';
if ($isOaParticipantIdentifierEnabled && is_array($result)) {
    $piResult = fetchParticipantIdentifier($wrapperObj, $vendorResult);

    foreach ($result as $key => $value) {
        foreach ($piResult as $row) {
            $storeArtistId = $row['orchard_artist_name_md5'] == md5($value['artist_name']) ? $row['store_artist_id']: null;
            if (!is_null($storeArtistId) && $row['store_id'] == APPLE_STORE_ID) {
                $result[$key]['apple_artist_id'] = $storeArtistId;
            } elseif (!is_null($storeArtistId) && $row['store_id'] == SPOTIFY_STORE_ID) {
                $result[$key]['spotify_artist_id'] = $storeArtistId;
            }
        }
    }
    $artistUriClass = 'artist_uri';
} elseif ($isUpdateSpotifyAppleIdsWithGraphqlEnabled && is_array($result)) {
    $vendorDetails['vendor_id'] = $vendor_id;
    $vendorDetails['subaccount_id'] = !empty($subaccountId) ? $subaccountId : 0;
    $participantIdentifierData = $graphqlGatewayServiceClient->getParticipantIdsByProductId(strval($release_id));
    if (!empty($participantIdentifierData)) {
        foreach ($result as $key => $value) {
            $normalized_release_artist_name = mb_strtolower(preg_replace('/\s+/u', '', $value['artist_name']), 'UTF-8');
            foreach ($participantIdentifierData as $participantIdentifier) {
                $normalized_participant_name = mb_strtolower(preg_replace('/\s+/u', '', $participantIdentifier['labelParticipant']['name']), 'UTF-8');
                if ($normalized_release_artist_name == $normalized_participant_name) {
                    $result[$key]['apple_artist_id'] = isset($participantIdentifier['labelParticipant']['appleMusicId']) ? $participantIdentifier['labelParticipant']['appleMusicId'] : null;
                    $result[$key]['spotify_artist_id'] = isset($participantIdentifier['labelParticipant']['spotifyId']) ? $participantIdentifier['labelParticipant']['spotifyId'] : null;
                    $result[$key]['spotify_artist_key'] = isset($participantIdentifier['labelParticipant']['spotifyArtistKey']) ? $participantIdentifier['labelParticipant']['spotifyArtistKey'] : null;
                    $result[$key]['id'] = $participantIdentifier['labelParticipant']['id'];
                }
            }
        }
    }
    $artistUriClass = 'artist_uri';
}
if ($isOAFeatureToPrimaryEnabled && !array_search("feature_to_primary", $release_track_artist_roles)) {
    array_splice($release_track_artist_roles, 9, 0, "feature_to_primary" );
}
?>
<div class="panelHeader">
    <h3>Manage Release Artists</h3>
</div>
<div class="panelContent">
    <table class="data">
        <tr>
            <th>Artist Name</th>
            <th>Artist Role</th>
            <?php if ($isOaParticipantIdentifierEnabled || $isUpdateSpotifyAppleIdsWithGraphqlEnabled) {?>
                <th>
                    Spotify Artist URI
                    <?php if (!$isOaSpotifyArtistKeyEnabled) { ?>
                    <div class="help-tooltip spotify-artist">
                        <img src="/oa/images/icon-info.png" />
                        <span class="tooltiptext">
                            Please only enter the alphanumeric ID portion of the Spotify Artist URI
                            e.g. https://open.spotify.com/artist/3Nrfpe0tUJi4K4DXYWgMUX
                        </span>
                    </div>
                    <?php } ?>
                </th>
                <th>
                    Apple Artist ID
                    <div class="help-tooltip apple-artist">
                        <img src="/oa/images/icon-info.png" />
                        <span class="tooltiptext">
                            Please only enter the numerical ID portion of the URL
                            e.g. music.apple.com/us/artist/1419227
                        </span>
                    </div>
                </th>
             <?php } else { ?>
                <th>URL</th>
            <?php } ?>
            <th></th>
        </tr>
        <?php $rci = 0;
        foreach ($result as $row) {
            $row_class = (++$rci & 1) ? '' : 'alt'; ?>
                <form id="updateArtistForm-<?=$rci?>" action="<?=$_SERVER['SCRIPT_NAME']?>" method="post" name="edit_rel_artist">
                    <input type="hidden" name="action" value="edit" />
                    <input type="hidden" name="upc" value="<?=$upc?>" />
                    <input type="hidden" name="release_artist_id" value="<?=$row['release_artist_id']?>" />
                    <tr class="<?=$row_class?>">
                        <td>
                            <input type="text" name="artist_name" maxlength="255" 
                            value="<?=htmlspecialchars($row['artist_name'])?>" class="textField small" />
                        </td>
                        <td>
                            <select id="artistsRole-<?=$rci?>" name="role" class="small">
                                <?php foreach ($release_track_artist_roles as $artist_role) {?>
                                    <option value="<?=$artist_role?>" <?=$row['role'] ?
                                    (($row['role']==$artist_role) ? "selected":"") : ""?>>
                                    <?=($artist_role == 'performer') ? 'Primary Artist'
                                        : ($artist_role == 'feature_to_primary' ? 'Display Featuring as Primary'
                                        : ucwords($artist_role))?>
                                    </option>
                                <?php } ?>
                            </select>
                        </td>
                        <?php if ($isOaParticipantIdentifierEnabled) {?>
                            <td class="<?=$artistUriClass?>">
                                spotify:artist:<input type="text" name="spotify_artist" value="<?=$row['spotify_artist_id']?>"
                                class="textField small" maxlength="255" />
                            </td>
                            <td class="<?=$artistUriClass?>">
                                music.apple.com/artist/<input type="text" name="apple_artist" value="<?=$row['apple_artist_id']?>"
                                class="textField small" maxlength="255" />
                            </td>
                        <?php } elseif ($isUpdateSpotifyAppleIdsWithGraphqlEnabled) {?>
                            <input type='hidden' id='labelParticipantId' name='labelParticipantId' value="<?=isset($row['id'])?$row['id']:null;?>">
                            <td class="<?=$artistUriClass?>">
                                spotify:artist:
                                <?php if ($isOaSpotifyArtistKeyEnabled) { ?>
                                <div class="help-tooltip-spotify spotify-artist">
                                    <img src="/oa/images/icon-info.png"/>
                                    <span class="tooltiptext">
                                        Please only enter the alphanumeric ID portion of the Spotify Artist URI
                                        e.g. https://open.spotify.com/artist/3Nrfpe0tUJi4K4DXYWgMUX
                                    </span>
                                </div>
                                <?php } ?>
                                <input type="text" name="spotify_artist" value="<?=$row['spotify_artist_id']?>"
                                class="textField small" maxlength="255" /><br>

                                <?php if ($isOaSpotifyArtistKeyEnabled) { ?>
                                <span class="spotifyAppKey">APP Key</span>
                                <div class="help-tooltip-spotify spotify-artist">
                                    <img src="/oa/images/icon-info.png"/>
                                    <span class="tooltiptext">
                                        APP (Artist Profile Protection) was a feature launched by Spotify in 2026. <a href="https://artists.spotify.com/blog/introducing-artist-profile-protection" target="_blank" rel="noopener noreferrer">Read the Press Release</a>
                                    </span>
                                </div>
                                <input type="password" name="spotify_artist_key" value="<?=$row['spotify_artist_key']?>"
                                class="spotifyAppKeyTxt textField small" maxlength="255"/>
                            <?php } ?>
                            </td>
                            <td class="<?=$artistUriClass?>">
                                music.apple.com/artist/<input type="text" name="apple_artist" value="<?=$row['apple_artist_id']?>"
                                class="textField small" maxlength="255" />
                            </td>
                        <?php } else { ?>
                            <td>
                                http://<input type="text" name="url" value="<?=$row['url']?>" class="textField small" maxlength="156" />
                            </td>
                        <?php } ?>
                        <td>
                            <?php if ($isOAFeatureToPrimaryEnabled) { ?>
                                <button type="button" onclick="handleConfirmIfFeatureToPrimaryArtist('updateArtistForm', <?=$rci?>)" class="btn btn-default btn-sm">
                                    Update
                                </button>
                            <?php } else { ?>
                                <input type="submit" value="Update" class="btn btn-default btn-sm" />
                            <?php } ?>

                            <input type="button" value="Remove" class="btn btn-default btn-sm"
                            onclick="confirmDelete('manage_release_artists.php?upc=<?=$upc?>&action=delete&release_artist_id=<?=$row['release_artist_id']?>');" />
                        </td>
                    </tr>
                </form>
        <?php
        }
        $row_class = (++$rci & 1) ? '' : 'alt'; ?>
        <form id="addArtistForm-<?=$rci?>" action="<?=$_SERVER['SCRIPT_NAME']?>" method="post" name="add_rel_artist">
            <input type="hidden" name="action" value="add" />
            <input type="hidden" name="upc" value="<?=$upc?>" />
                <tr class="<?=$row_class?>">
                    <td><input type="text" name="artist_name" maxlength="255" value="" class="textField small" /></td>
                    <td>
                        <select id="artistsRole-<?=$rci?>" name="role" class="small">
                            <?php foreach ($release_track_artist_roles as $artist_role) {?>
                                <option value="<?=$artist_role?>" <?=$row['role'] ?
                                (($row['role']=="$artist_role") ? "selected":"") : ""?>>
                                <?=($artist_role == 'performer') ? 'Primary Artist' : ($artist_role == 'feature_to_primary' ?
                                'Display Featuring as Primary' : ucwords($artist_role))?></option>
                            <?php } ?>
                        </select>
                    </td>
                    <?php if ($isOaParticipantIdentifierEnabled || $isUpdateSpotifyAppleIdsWithGraphqlEnabled) {?>
                        <td></td>
                        <td></td>
                    <?php } else { ?>
                        <td>http://<input type="text" name="url" value="" class="textField small" maxlength="156" /></td>
                    <?php } ?>
                    <td>
                        <?php if ($isOAFeatureToPrimaryEnabled) {?>
                            <button type="button" onclick="handleConfirmIfFeatureToPrimaryArtist('addArtistForm', <?=$rci?>)" class="btn btn-primary btn-sm">
                                Add
                            </button>
                        <?php } else { ?>
                            <input type="submit" value="Add" class="btn btn-primary btn-sm" />
                        <?php } ?>
                    </td>
                </tr>
            </form>
    </table>
</div>