msdGetDiscount.php

<?php
/** @var msDiscount $msDiscount */
/** @var pdoTools $pdoTools */
$pdoTools = $modx->getService('pdoTools');
$msDiscount = $modx->getService('msDiscount');
$date = $pdoTools->getStore('msd_date');
$usergroups = array_keys($msDiscount->getUserGroups($modx->user->id));
$sales = !empty($date)
	? $msDiscount->getSales($date, true)
	: $msDiscount->getSales();
if (empty($sale)) {
	$sale = $pdoTools->getStore('msd_sale');
}
if (!empty($sale)) {
	$tmp = array_map('trim', explode(',', $sale));
	foreach ($sales as $id => $sale) {
		if (!in_array($id, $tmp)) {
			unset($sales[$id]);
		}
	}
}
if (!empty($row) && is_array($row)) {
	$mode = 'prepare';
	if (!empty($row['id'])) {
		$id = $row['id'];
	}
} else {
	$mode = 'standalone';
	if (!empty($frontend_css)) {
		$frontend_css = str_replace('[[+assetsUrl]]', $msDiscount->config['assetsUrl'], $frontend_css);
		$modx->regClientCSS($frontend_css);
	}
	if (!empty($frontend_js)) {
		$frontend_js = str_replace('[[+assetsUrl]]', $msDiscount->config['assetsUrl'], $frontend_js);
		$modx->regClientScript($frontend_js);
	}
	if (empty($id)) {
		$id = $modx->resource->id;
	}
}
$vendorsgroups = array_keys($msDiscount->getProductVendors($id));
$remains = $discount = 0;
if (!empty($id) && !empty($sales)) {
	foreach ($sales as $sale) {
		// Check user groups
		if (!empty($sale['users'])) {
			$required = array();
			foreach ($sale['users'] as $gid => $type) {
				if ($type == 'out' && in_array($gid, $usergroups)) {
					unset($sales[$idx]);
					continue(2);
				}
				if ($type == 'in') {
					$required[] = $gid;
				}
			}
			if (!empty($required) && !array_intersect($required, $usergroups)) {
				unset($sales[$idx]);
				continue;
			}
		}
		// Check product groups
		if (!empty($sale['products'])) {
			$groups_in = $groups_out = array();
			foreach ($sale['products'] as $gid => $type) {
				if ($type == 'out') {
					$groups_out[] = $gid;
					unset($sale['products'][$gid]);
				} else {
					$groups_in[] = $gid;
				}
			}
		}
		// Check product vendors groups
		if (!empty($sale['vendors'])) {
			$vendors_in = $vendors_out = array();
			foreach ($sale['vendors'] as $gid => $type) {
				if ($type == 'out') {
					$vendors_out[] = $gid;
					unset($sale['vendors'][$gid]);
				} else {
					$vendors_in[] = $gid;
				}
			}
		}
		if (!empty($groups_out) || !empty($groups_in)) {
			$ids = $modx->getParentIds($id);
			$ids[] = $id;

			$q = $modx->newQuery('msCategoryMember', array('product_id' => $id));
			$q->select('category_id');
			$tstart = microtime(true);
			if ($q->prepare() && $q->stmt->execute()) {
				$modx->queryTime += microtime(true) - $tstart;
				$modx->executedQueries++;
				if ($tmp = $q->stmt->fetchAll(PDO::FETCH_COLUMN)) {
					$ids = array_merge($ids, $tmp);
				}
			}
			$ids = array_unique($ids);
			$where = count($ids) > 1
				? array('document:IN' => $ids)
				: array('document' => $ids[0]);

			$q = $modx->newQuery('modResourceGroupResource', $where);
			$q->select('document_group');
			$tstart = microtime(true);
			if ($q->prepare() && $q->stmt->execute()) {
				$modx->queryTime += microtime(true) - $tstart;
				$modx->executedQueries++;
				$groups = $q->stmt->fetchAll(PDO::FETCH_COLUMN);
				if ((!empty($groups_out) && array_intersect($groups_out, $groups)) && (empty($vendors_out) && empty($vendors_in))) {
					continue;
				} elseif ((!empty($groups_in) && !array_intersect($groups_in, $groups) && (empty($vendors_out) && empty($vendors_in)))) {
					continue;
				}
			}
		}
		if (!empty($vendors_in) || !empty($vendors_out)) {
			if ((!empty($vendors_out) && array_intersect($vendors_out, $vendorsgroups))) {
				continue;
			} elseif ((!empty($vendors_in) && !array_intersect($vendors_in, $vendorsgroups))) {
				continue;
			}
		}

		// Product match
		$tmp_remains = ($sale['ends'] != '0000-00-00 00:00:00')
			? strtotime($sale['ends']) - time()
			: 0;
		if (strpos($sale['discount'], '%') !== false && (empty($discount) || strpos($discount, '%') !== false)) {
			$sale['discount'] = str_replace('%', '', $sale['discount']);
			$discount = str_replace('%', '', $discount);
			if ($sale['discount'] > $discount) {
				$discount = $sale['discount'] . '%';
				$remains = $tmp_remains;
			}
		} elseif (is_numeric($sale['discount']) && is_numeric($discount)) {
			if ($sale['discount'] > $discount) {
				$discount = $sale['discount'];
				$remains = $tmp_remains;
			}
		} else {
			$discount = $sale['discount'];
			$remains = $tmp_remains;
		}
	}
}

$arr = array(
	'sale_discount' => $discount,
	'remains' => $remains,
);
if ($mode == 'standalone') {
	$pdoTools->config['nestedChunkPrefix'] = 'minishop2_';
    if (!empty($discount) && !empty($remains)) {
        return !empty($tpl)
		? $pdoTools->getChunk($tpl, $arr)
		: print_r($arr, true);
    }
} else {
	$row = array_merge($row, $arr);

	return $modx->toJSON($row);
}