<?php
/**
 * Title: Shop Manager
 * Icon: fa-shopping-cart
 * Group: Economy
 * Order: 10
 * Description: Add, preview, hide and remove database shop offers.
 */

if (!defined('ACP_ROOT')) {
	http_response_code(403);
	die('Direct access denied.');
}

$items = getItemList();

db()->execute("
	CREATE TABLE IF NOT EXISTS `znote_shop_offers` (
		`id` int NOT NULL AUTO_INCREMENT,
		`type` int NOT NULL,
		`itemid` int DEFAULT NULL,
		`count` int NOT NULL DEFAULT '1',
		`description` varchar(255) NOT NULL,
		`points` int NOT NULL DEFAULT '10',
		`active` tinyint NOT NULL DEFAULT '1',
		`sort_order` int NOT NULL DEFAULT '0',
		`created_by` int DEFAULT NULL,
		`created_at` int DEFAULT NULL,
		`updated_at` int DEFAULT NULL,
		PRIMARY KEY (`id`),
		KEY `active_sort` (`active`, `sort_order`, `id`)
	) ENGINE=InnoDB;
");

function acp_shop_offer_columns(): array {
	$columns = [];
	$rows = db()->fetchAll("SHOW COLUMNS FROM `znote_shop_offers`;");

	if (is_array($rows)) {
		foreach ($rows as $row) {
			if (!empty($row['Field'])) {
				$columns[(string)$row['Field']] = true;
			}
		}
	}

	return $columns;
}

function acp_shop_ensure_offer_schema(): void {
	$columns = acp_shop_offer_columns();

	if (empty($columns['active'])) {
		db()->execute("ALTER TABLE `znote_shop_offers` ADD `active` tinyint NOT NULL DEFAULT '1' AFTER `points`;");
		$columns['active'] = true;
	}
	if (empty($columns['sort_order'])) {
		db()->execute("ALTER TABLE `znote_shop_offers` ADD `sort_order` int NOT NULL DEFAULT '0' AFTER `active`;");
		$columns['sort_order'] = true;
	}
	if (empty($columns['updated_at'])) {
		db()->execute("ALTER TABLE `znote_shop_offers` ADD `updated_at` int DEFAULT NULL AFTER `created_at`;");
		$columns['updated_at'] = true;
	}

	$indexes = db()->fetchAll("SHOW INDEX FROM `znote_shop_offers` WHERE `Key_name` = 'active_sort';");
	if (empty($indexes) && !empty($columns['active']) && !empty($columns['sort_order'])) {
		db()->execute("ALTER TABLE `znote_shop_offers` ADD KEY `active_sort` (`active`, `sort_order`, `id`);");
	}
}

acp_shop_ensure_offer_schema();

function acp_shop_pack_outfit_pair(string $raw): int|false {
	if (!preg_match('/^\s*(\d+)\s*,\s*(\d+)\s*$/', $raw, $m)) {
		return false;
	}

	return ((int)$m[1] * 10000) + (int)$m[2];
}

function acp_shop_unpack_outfit_pair(int $packed): string {
	$male = (int)floor($packed / 10000);
	$female = (int)($packed % 10000);

	return $male . ',' . $female;
}

function acp_shop_offer_type_label(int $type): string {
	$types = [
		1 => t('acp.shp.type_item'),
		2 => t('acp.shp.type_premium'),
		3 => t('acp.shp.type_gender'),
		4 => t('acp.shp.type_name'),
		5 => t('acp.shp.type_outfit'),
		6 => t('acp.shp.type_mount'),
		7 => t('acp.shp.type_custom'),
		8 => t('acp.shp.type_custom'),
	];

	return $types[$type] ?? t('acp.shp.type_custom');
}

function acp_shop_public_asset_url(string $url): string {
	if ($url === '' || preg_match('~^(https?:)?//~i', $url) || $url[0] === '/') {
		return $url;
	}

	return acp_site($url);
}

function acp_shop_item_image_url(int $itemId): string {
	global $config;

	if (function_exists('znote_item_image_url')) {
		return acp_shop_public_asset_url(znote_item_image_url($itemId));
	}

	$server = trim((string)($config['shop']['imageServer'] ?? ''), '/');
	$typeExt = trim((string)($config['shop']['imageType'] ?? 'gif'), '.');

	if ($server === '' || $itemId <= 0) {
		return '';
	}

	if (preg_match('~^https?://~i', $server)) {
		return $server . '/' . $itemId . '.' . $typeExt;
	}

	if (str_contains($server, '.')) {
		return 'http://' . $server . '/' . $itemId . '.' . $typeExt;
	}

	return acp_shop_public_asset_url($server . '/' . $itemId . '.' . $typeExt);
}

function acp_shop_outfit_server_url(): string {
	global $config;

	$server = trim((string)($config['show_outfits']['imageServer'] ?? ''));
	if ($server === '') {
		return '';
	}

	if (preg_match('~^(https?:)?//~i', $server) || substr($server, 0, 1) === '/') {
		return $server;
	}

	return acp_site($server);
}

function acp_shop_outfit_image_url(int $outfitId, int $addons, int $mountId = 0): string {
	$server = acp_shop_outfit_server_url();
	if ($server === '' || $outfitId <= 0) {
		return '';
	}

	$url = $server
		. '?id=' . $outfitId
		. '&addons=' . $addons
		. '&head=78&body=68&legs=58&feet=76&direction=2';

	if ($mountId > 0) {
		$url .= '&mount=' . $mountId;
	}

	return $url;
}

function acp_shop_offer_preview(array $offer, array $items): string {
	global $config;

	$type = intv($offer['type'] ?? 0);
	$itemId = intv($offer['itemid'] ?? 0);
	$count = intv($offer['count'] ?? 0);

	if ($type === 5 && !empty($config['show_outfits']['imageServer'])) {
		$male = (int)floor($itemId / 10000);
		$female = (int)($itemId % 10000);

		return '<img class="acp-shop-preview-img" src="' . h(acp_shop_outfit_image_url($male, $count)) . '" alt="">'
			. '<img class="acp-shop-preview-img" src="' . h(acp_shop_outfit_image_url($female, $count)) . '" alt="">';
	}

	if ($type === 6 && !empty($config['show_outfits']['imageServer'])) {
		return '<img class="acp-shop-preview-img" src="' . h(acp_shop_outfit_image_url(128, 3, $itemId)) . '" alt="">';
	}

	if (!empty($config['shop']['showImage']) && $itemId > 0) {
		return '<img class="acp-shop-preview-item" src="' . h(acp_shop_item_image_url($itemId)) . '" alt="">';
	}

	return '<span class="is-muted">' . h($items[$itemId] ?? '#' . $itemId) . '</span>';
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
	$shopAction = (string)($_POST['shop_offer_action'] ?? '');
	$now = time();

	if ($shopAction === 'add') {
		$type = intv($_POST['type'] ?? 0);
		$itemRaw = trim((string)($_POST['itemid'] ?? ''));
		$count = max(0, intv($_POST['count'] ?? 0));
		$points = max(1, intv($_POST['points'] ?? 0));
		$sortOrder = intv($_POST['sort_order'] ?? 0);
		$description = substr(trim((string)($_POST['description'] ?? '')), 0, 255);
		$itemId = false;

		if ($type === 5) {
			$itemId = acp_shop_pack_outfit_pair($itemRaw);
			if ($itemId === false) {
				acp_flash_error(t('acp.shp.outfit_field_error'));
			}
		} elseif (preg_match('/^\d+$/', $itemRaw)) {
			$itemId = (int)$itemRaw;
		}

		if ($type <= 0 || $description === '' || $points <= 0 || $itemId === false) {
			acp_flash_error(t('acp.shp.missing_fields'));
		} else {
			$created = db()->execute("
				INSERT INTO `znote_shop_offers`
					(`type`, `itemid`, `count`, `description`, `points`, `active`, `sort_order`, `created_by`, `created_at`, `updated_at`)
				VALUES
					(?, ?, ?, ?, ?, 1, ?, ?, ?, ?);
			", [$type, $itemId, $count, $description, $points, $sortOrder, (int)$user_data['id'], $now, $now]);
			if ($created) {
				acp_log('shop.offer_add', $description, ['type' => $type, 'points' => $points]);
				acp_flash_success(t('acp.shp.offer_added'));
			} else {
				acp_flash_error(t('acp.shp.offer_add_failed'));
			}
			acp_redirect('shop');
		}
	}

	if ($shopAction === 'toggle') {
		$id = intv($_POST['id'] ?? 0);
		$updated = db()->execute("
			UPDATE `znote_shop_offers`
			SET `active` = CASE WHEN `active` = 1 THEN 0 ELSE 1 END,
				`updated_at` = ?
			WHERE `id` = ?
			LIMIT 1;
		", [$now, $id]);
		if ($updated) { acp_log('shop.offer_toggle', '#' . $id); }
		$updated ? acp_flash_success(t('acp.shp.status_updated')) : acp_flash_error(t('acp.shp.status_failed'));
		acp_redirect('shop');
	}

	if ($shopAction === 'delete') {
		$id = intv($_POST['id'] ?? 0);
		$deleted = db()->execute("DELETE FROM `znote_shop_offers` WHERE `id` = ? LIMIT 1;", [$id]);
		if ($deleted) { acp_log('shop.offer_delete', '#' . $id); }
		$deleted ? acp_flash_success(t('acp.shp.removed')) : acp_flash_error(t('acp.shp.remove_failed'));
		acp_redirect('shop');
	}

	if (in_array($shopAction, ['bulk_enable', 'bulk_disable', 'bulk_delete'], true)) {
		$ids = array_values(array_filter(array_map('intv', (array)($_POST['ids'] ?? []))));

		if (!$ids) {
			acp_flash_error(t('acp.shp.bulk_none_selected'));
			acp_redirect('shop');
		}

		$placeholders = implode(',', array_fill(0, count($ids), '?'));

		if ($shopAction === 'bulk_delete') {
			$done = db()->execute("DELETE FROM `znote_shop_offers` WHERE `id` IN ({$placeholders});", $ids);
		} else {
			$active = ($shopAction === 'bulk_enable') ? 1 : 0;
			$done = db()->execute("
				UPDATE `znote_shop_offers` SET `active` = ?, `updated_at` = ? WHERE `id` IN ({$placeholders});
			", array_merge([$active, $now], $ids));
		}

		if ($done !== false) {
			acp_log('shop.offer_bulk_' . $shopAction, implode(',', $ids), ['count' => count($ids)]);
			acp_flash_success(t('acp.shp.bulk_done', ['n' => count($ids)]));
		} else {
			acp_flash_error(t('acp.shp.bulk_failed'));
		}

		acp_redirect('shop');
	}
}

$offers = db()->fetchAll("SELECT * FROM `znote_shop_offers` ORDER BY `active` DESC, `sort_order` ASC, `id` ASC;");
$offers = is_array($offers) ? $offers : [];
$activeOffers = 0;
$hiddenOffers = 0;
foreach ($offers as $offer) {
	!empty($offer['active']) ? $activeOffers++ : $hiddenOffers++;
}

$itemImageTemplate = acp_shop_item_image_url(999999);
if ($itemImageTemplate !== '') {
	$itemImageTemplate = str_replace('999999', '{id}', $itemImageTemplate);
}
?>

<div class="acp-stats">
	<?php
	acp_stat(t('acp.shp.stat_db_offers'), count($offers), 'fa-tags', null, 'blue');
	acp_stat(t('acp.shp.stat_active'), $activeOffers, 'fa-check-circle', null, 'green');
	acp_stat(t('acp.shp.stat_hidden'), $hiddenOffers, 'fa-eye-slash', null, 'amber');
	acp_stat(t('acp.shp.stat_orders'), acp_count("SELECT COUNT(*) AS `c` FROM `znote_shop_orders`;"), 'fa-history', acp_url('shop_orders'), 'purple');
	?>
</div>

<!-- ------------------------------------------------------- Add offer -->
<section class="acp-card acp-shop-form-card">
	<header class="acp-card-head">
		<h2><?= h(t('acp.shp.add_offer_title')) ?></h2>
		<p><?= h(t('acp.shp.add_offer_sub')) ?></p>
	</header>
	<div class="acp-card-body">
		<form method="post">
			<?= acp_csrf_field() ?>
			<input type="hidden" name="shop_offer_action" value="add">

			<div class="acp-row acp-shop-form-row">
				<div class="acp-field">
					<label class="acp-label" for="type"><?= h(t('acp.shp.type_label')) ?></label>
					<select class="acp-select" id="type" name="type">
						<option value="1"><?= h(t('acp.shp.type_item')) ?></option>
						<option value="2"><?= h(t('acp.shp.type_premium')) ?></option>
						<option value="3"><?= h(t('acp.shp.type_gender')) ?></option>
						<option value="4"><?= h(t('acp.shp.type_name')) ?></option>
						<option value="5"><?= h(t('acp.shp.outfit_option')) ?></option>
						<option value="6"><?= h(t('acp.shp.type_mount')) ?></option>
						<option value="8"><?= h(t('acp.shp.type_custom')) ?></option>
					</select>
				</div>
				<div class="acp-field">
					<label class="acp-label" for="itemid"><?= h(t('acp.shp.item_id')) ?></label>
					<div class="acp-shop-id-field">
						<input class="acp-input" id="itemid" name="itemid" placeholder="2160 or 128,136" required>
						<div class="acp-shop-live-preview"
						     id="shopOfferPreview"
						     data-item-template="<?= h($itemImageTemplate) ?>"
						     data-outfit-server="<?= h(acp_shop_outfit_server_url()) ?>">
							<span class="is-muted"><?= h(t('acp.shp.preview_label')) ?></span>
						</div>
					</div>
					<p class="acp-hint"><?= h(t('acp.shp.outfit_hint')) ?></p>
				</div>
				<div class="acp-field">
					<label class="acp-label" for="description"><?= h(t('acp.shp.description')) ?></label>
					<input class="acp-input" id="description" name="description" maxlength="255" placeholder="5 x Crystal coin" required>
				</div>
			</div>

			<div class="acp-row acp-shop-form-row">
				<div class="acp-field">
					<label class="acp-label" for="count"><?= h(t('acp.shp.count_label')) ?></label>
					<input class="acp-input" id="count" name="count" type="number" min="0" value="1" required>
				</div>
				<div class="acp-field">
					<label class="acp-label" for="points"><?= h(t('acp.shp.points')) ?></label>
					<input class="acp-input" id="points" name="points" type="number" min="1" value="10" required>
				</div>
				<div class="acp-field">
					<label class="acp-label" for="sort_order"><?= h(t('acp.shp.sort_order')) ?></label>
					<input class="acp-input" id="sort_order" name="sort_order" type="number" value="0">
				</div>
			</div>

			<div class="acp-actions">
				<button class="acp-btn acp-btn--green" type="submit"><i class="fa fa-plus"></i> <?= h(t('acp.shp.add_offer_btn')) ?></button>
			</div>
		</form>
	</div>
</section>

<!-- ------------------------------------------------------- Current offers -->
<section class="acp-card acp-shop-offers-card">
	<header class="acp-card-head">
		<h2><?= h(t('acp.shp.db_offers_title')) ?></h2>
		<p><?= h(t('acp.shp.db_offers_sub')) ?></p>
	</header>
	<div class="acp-card-body is-flush">
		<?php if ($offers): ?>
			<form id="acpShopBulkForm" method="post">
				<?= acp_csrf_field() ?>
				<input type="hidden" name="shop_offer_action" id="acpShopBulkAction" value="">
			</form>

			<div class="acp-toolbar" id="acpShopBulkBar" hidden>
				<span class="is-muted"><span id="acpShopBulkCount">0</span> <?= h(t_default('acp.shp.bulk_selected', 'selected')) ?></span>
				<div class="acp-actions is-tight">
					<button type="submit" form="acpShopBulkForm" class="acp-btn acp-btn--sm"
							onclick="document.getElementById('acpShopBulkAction').value='bulk_enable';">
						<i class="fa fa-eye"></i> <?= h(t_default('acp.shp.bulk_enable', 'Show selected')) ?>
					</button>
					<button type="submit" form="acpShopBulkForm" class="acp-btn acp-btn--ghost acp-btn--sm"
							onclick="document.getElementById('acpShopBulkAction').value='bulk_disable';">
						<i class="fa fa-eye-slash"></i> <?= h(t_default('acp.shp.bulk_disable', 'Hide selected')) ?>
					</button>
					<button type="submit" form="acpShopBulkForm" class="acp-btn acp-btn--red acp-btn--sm"
							onclick="document.getElementById('acpShopBulkAction').value='bulk_delete'; return confirm('<?= h(t_default('acp.shp.bulk_confirm_delete', 'Delete every selected offer? This cannot be undone.')) ?>');">
						<i class="fa fa-trash"></i> <?= h(t_default('acp.shp.bulk_delete', 'Delete selected')) ?>
					</button>
				</div>
			</div>
			<?php if (count($offers) > 8): ?>
				<div class="acp-toolbar">
					<div style="display:flex;gap:8px;flex:1 1 320px;max-width:460px;">
						<input class="acp-input" type="search" data-acp-search-input="acpShopOfferTable"
							   placeholder="<?= h(t_default('acp.shp.search_placeholder', 'Search offers...')) ?>">
					</div>
					<span class="is-muted" data-acp-search-count="acpShopOfferTable"></span>
				</div>
			<?php endif; ?>
			<div class="acp-table-wrap">
				<table class="acp-table acp-shop-offers-table" data-sortable id="acpShopOfferTable">
					<thead>
						<tr>
							<th><input type="checkbox" id="acpShopBulkAll" aria-label="<?= h(t_default('acp.shp.bulk_select_all', 'Select all')) ?>"></th>
							<th>#</th>
							<th><?= h(t('acp.shp.col_preview')) ?></th>
							<th><?= h(t('acp.shp.col_offer')) ?></th>
							<th class="is-num"><?= h(t('acp.shp.col_points')) ?></th>
							<th><?= h(t('acp.shp.col_status')) ?></th>
							<th class="is-num"><?= h(t('acp.shp.col_actions')) ?></th>
						</tr>
					</thead>
					<tbody>
						<?php foreach ($offers as $offer): ?>
							<tr data-acp-search="<?= h(strtolower((string)($offer['description'] ?? ''))) ?>">
								<td><input type="checkbox" class="acp-shop-bulk-check" form="acpShopBulkForm" name="ids[]" value="<?= intv($offer['id'] ?? 0) ?>"></td>
								<td class="is-muted"><?= intv($offer['id'] ?? 0) ?></td>
								<td><?= acp_shop_offer_preview($offer, $items) ?></td>
								<td>
									<strong><?= h($offer['description'] ?? '') ?></strong><br>
									<span class="is-muted">
										<?= h(acp_shop_offer_type_label(intv($offer['type'] ?? 0))) ?> -
										<?= intv($offer['type'] ?? 0) === 5 ? h(acp_shop_unpack_outfit_pair(intv($offer['itemid'] ?? 0))) : intv($offer['itemid'] ?? 0) ?>,
										<?= h(t('acp.shp.count_label2')) ?> <?= intv($offer['count'] ?? 0) ?>
									</span>
								</td>
								<td class="is-num"><strong><?= intv($offer['points'] ?? 0) ?></strong></td>
								<td>
									<span class="acp-pill <?= !empty($offer['active']) ? 'acp-pill--green' : 'acp-pill--grey' ?>">
										<?= !empty($offer['active']) ? h(t('acp.shp.active_pill')) : h(t('acp.shp.hidden_pill')) ?>
									</span>
								</td>
								<td class="is-nowrap is-num acp-shop-offer-actions">
									<form class="acp-inline-form" method="post">
										<?= acp_csrf_field() ?>
										<input type="hidden" name="shop_offer_action" value="toggle">
										<input type="hidden" name="id" value="<?= intv($offer['id'] ?? 0) ?>">
										<button class="acp-btn acp-btn--ghost acp-btn--sm" type="submit">
											<?= !empty($offer['active']) ? h(t('acp.shp.hide')) : h(t('acp.shp.show')) ?>
										</button>
									</form>
									<form class="acp-inline-form" method="post" data-confirm="<?= h(t('acp.shp.confirm_remove')) ?>">
										<?= acp_csrf_field() ?>
										<input type="hidden" name="shop_offer_action" value="delete">
										<input type="hidden" name="id" value="<?= intv($offer['id'] ?? 0) ?>">
										<button class="acp-btn acp-btn--red acp-btn--sm" type="submit" title="<?= h(t('acp.shp.remove_offer')) ?>" aria-label="<?= h(t('acp.shp.remove_offer')) ?>"><i class="fa fa-times"></i></button>
									</form>
								</td>
							</tr>
						<?php endforeach; ?>
					</tbody>
				</table>
			</div>
		<?php else: ?>
			<?php acp_empty(t('acp.shp.empty'), 'fa-tags'); ?>
		<?php endif; ?>
	</div>
</section>

<script>
(function () {
	var all   = document.getElementById('acpShopBulkAll');
	var boxes = Array.prototype.slice.call(document.querySelectorAll('.acp-shop-bulk-check'));
	var bar   = document.getElementById('acpShopBulkBar');
	var count = document.getElementById('acpShopBulkCount');
	if (!all || !bar) return;

	function refresh() {
		var checked = boxes.filter(function (b) { return b.checked; });
		bar.hidden = checked.length === 0;
		if (count) count.textContent = checked.length;
		all.checked = checked.length > 0 && checked.length === boxes.length;
		all.indeterminate = checked.length > 0 && checked.length < boxes.length;
	}

	all.addEventListener('change', function () {
		boxes.forEach(function (b) { if (!b.closest('tr').hidden) b.checked = all.checked; });
		refresh();
	});
	boxes.forEach(function (b) { b.addEventListener('change', refresh); });
})();
</script>