[msProductRemains] Компонент учёта остатков товара

&fields=article,pagetitle,tv1,size,size,gallery,gallery,tv3

всё вручную, и не всё еще может нормально само устанавливаться — нужно тестировать.

[[!getRemains:toPlaceholder=`remains`? &id=[[+id]]]]

[[+remains:is=``:then=`<span class="no-remains">Нет в наличии</span>`:else=`<button class="btn btn-default" type="submit" name="ms2_action" value="cart/add"><i class="glyphicon glyphicon-barcode"></i> В корзину</button>`]]

$rem = $this->modx->getObject('msprRemains', array(
	'product_id' => $product_id
	,'options' => $this->modx->toJSON($where)
));

public function get()
    {
        $list = [];
        $q = $this->modx->newQuery('modResource');
        $q->leftJoin('msProductData', 'Data', ['modResource.id = Data.id']);
        $q->leftJoin('msVendor', 'Vendor', ['Data.vendor = Vendor.id']);
        $q->innerJoin('msInformUserArrival', 'Arrival', ['modResource.id = Arrival.res_id']);
        $q->innerJoin('msInformUserMailing', 'Mailing', ['Arrival.mailing_index = Mailing.index']);
        $q->select($this->modx->getSelectColumns('modResource', 'modResource', 'product.'));
        $q->select($this->modx->getSelectColumns('msProductData', 'Data', 'product.'));
        $q->select($this->modx->getSelectColumns('msVendor', 'Vendor', 'product.vendor.'));
        $q->select($this->modx->getSelectColumns('msInformUserArrival', 'Arrival', 'arrival_'));
        $q->select($this->modx->getSelectColumns('msInformUserMailing', 'Mailing', 'mailing_'));
        $q->where([
            'published' => 1,
            'deleted' => 0,
            'iu_count:>' => 0,
            'Arrival.status:IN' => [1, 3],
            'Mailing.active' => 1,
        ]);
//        if (!$this->msInformUser->useCron) {
            $q->limit($this->config['limitSend']);
//        }
        if ($q->prepare() && $q->stmt->execute()) {
            while ($row = $q->stmt->fetch(PDO::FETCH_ASSOC)) {
                $list[] = $row;
            }
        }
//        $this->modx->cacheManager->set('iustockout', $list, 7200);

        if (!empty($list)) {
            $this->prepareSending($list);
        }
        return true;
    }

'iu_count:>' => 0,

&leftJoin=`{ "Remains":{ "class":"msprRemains","on":"msProduct.id = Remains.product_id" } }`
    &select=`{ "msProduct":"*","Remains":"SUM(Remains.remains) as remains" }`
    &loadModels=`msproductremains`

public function getRemainsValues(array $fields, array $ids) {
		$filters = array();
		$q = $this->modx->newQuery('modResource');
		$q->leftJoin('msprRemains', 'Remains', ['modResource.id = Remains.product_id']);
$q->select($this->modx->getSelectColumns('msprRemains', 'Remains'));
 

		 $q->where(array('modResource.id:IN' => $ids));
	 	 $q->select('modResource.id,' . implode(',', $fields));
		$tstart = microtime(true);
		if ($q->prepare() && $q->stmt->execute()) {
			$this->modx->queryTime += microtime(true) - $tstart;
			$this->modx->executedQueries++;
			while ($row = $q->stmt->fetch(PDO::FETCH_ASSOC)) {
				foreach ($row as $k => $v) {
					$v = str_replace('"', '"', trim($v));
					if ($k == 'id') {
						continue;
					}
					elseif (isset($filters[$k][$v])) {
						$filters[$k][$v][$row['id']] = $row['id'];
					}
					else {
						$filters[$k][$v] = array($row['id'] => $row['id']);
					}
				}
			}
		}
		else {
			$this->modx->log(modX::LOG_LEVEL_ERROR, "[mSearch2] Error on get filter params.\nQuery: " . $q->toSQL() .
				"\nResponse: " . print_r($q->stmt->errorInfo(), 1)
			);
		}

		return $filters;
	}

[[!getRemains:toPlaceholder=`remains`? &id=`[[+id]]`]]

[[!+remains:lt=`1`:then=`<div class="no-remains">Нет в наличии</div>`:else=`<span><button class="btn btn-primary list-prod__submit" type="submit" name="ms2_action" value="cart/add">Купить</button></span>`]]

{'msOptions' | snippet: [
                'product' => $id,
                'options' => 'option_size',
                'tpl' => 'tpl-msOptions'
            ]}

{foreach $options as $name => $values}
    <div class="options-title"><b>{('ms2_product_' ~ $name) | lexicon}</b></div>
    {foreach $values as $value index=$index}
        <label class="options-label">
            
        <input type="radio" value="{$values[$index]}" name="options[{$name}]" {if $index == 0}checked="checked"{/if}/>
            <span>{$values[$index]}</span>
        </label>
    {/foreach}
{/foreach}