Anton Kunaev antk25

## Вывод производителей товаров MS2.php
<?php
$q = $modx->newQuery('msVendor');
$q->innerJoin('msProductData', 'msProductData', '`msProductData`.`vendor` = `msVendor`.`id`');
$q->innerJoin('msProduct', 'msProduct', array(
 '`msProductData`.`id` = `msProduct`.`id`',
 'msProduct.deleted' => 0,
 'msProduct.published' => 1
));
$q->groupby('msVendor.id');
$q->sortby('name','ASC');

## Вывод количества товаров в категории.php
<?php
if (empty($parent)) {$parent = $modx->resource->id;}
$pids = array_merge(array($parent), $modx->getChildIds($parent));
$ids = array();

$q = $modx->newQuery('msProduct');
$q->where(array('class_key' => 'msProduct','parent:IN' => $pids,'published' => 1,'deleted' => 0));
$q->select('`msProduct`.`id`');
if ($q->prepare() && $q->stmt->execute()) {
    $ids = $q->stmt->fetchAll(PDO::FETCH_COLUMN);

## Вывод пустых и не пустых tv параметров.txt
[[+tv.formSize:notempty=`<li>[[+tv.formSize]]</li>`]]

## Вывод последних сообщений easycomm
[[!ecMessages?
&threads=`*`
&limit=`1`
&sortby=`date`
&sortdir=`DESC`
]]

## Дерево ресурсов.php
<?php
$parent = 3;
$exclude_parents = array(100500,123456);
$template = 4;

$ids = $modx->getChildIds($parent));
$q = $modx->newQuery('modResource', array('parent:IN' => $ids, 'OR:id:IN' => $ids));
$q->andCondition(array('id:NOT IN' => $exclude_parents, 'template' => $template));
$q->select('id,pagetitle,parent');
$resources = array();

## Вывод ссылок на дополнительные категории товара.php
<?php
if (empty($id)) {$id = $modx->resource->id;}if (empty($tpl)) {$tpl = '@INLINE <a href="[[~[[+id]]]]">[[+pagetitle]]</a>';}
$pdo = $modx->getService('pdoFetch');

$conditions = array('product_id' => $id);
$options = array(
        'innerJoin' => array(
                'msCategory' => array('on' => 'msCategoryMember.category_id = msCategory.id')
        ),
        'select' => array('msCategory' => 'all'),

## Выводим количество комментариев Tickets.php
<?php
if ($thread = $modx->getObject('TicketThread', array('resource' => $id))) {
        echo $thread->get('comments');
}

## вычитание TV
[[*prib:subtract=`[[*netto]]`]]

## addplace.sh
#!/bin/bash

# MySQL root password
ROOTPASS='password'
TIMEZONE='Europe/Moscow'

MYSQLPASS=`< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12`
SFTPPASS=`< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12`
PASSWORD=`< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12`
##############

## addsite.sh
#!/bin/bash

# MySQL root password
ROOTPASS='password'
TIMEZONE='Europe/Moscow'

MYSQLPASS=`< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12`
SFTPPASS=`< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12`
PASSWORD=`< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12`
##############
	<?php
	$q = $modx->newQuery('msVendor');
	$q->innerJoin('msProductData', 'msProductData', '`msProductData`.`vendor` = `msVendor`.`id`');
	$q->innerJoin('msProduct', 'msProduct', array(
	'`msProductData`.`id` = `msProduct`.`id`',
	'msProduct.deleted' => 0,
	'msProduct.published' => 1
	));
	$q->groupby('msVendor.id');
	$q->sortby('name','ASC');
	<?php
	if (empty($parent)) {$parent = $modx->resource->id;}
	$pids = array_merge(array($parent), $modx->getChildIds($parent));
	$ids = array();

	$q = $modx->newQuery('msProduct');
	$q->where(array('class_key' => 'msProduct','parent:IN' => $pids,'published' => 1,'deleted' => 0));
	$q->select('`msProduct`.`id`');
	if ($q->prepare() && $q->stmt->execute()) {
	$ids = $q->stmt->fetchAll(PDO::FETCH_COLUMN);
	[[!ecMessages?
	&threads=`*`
	&limit=`1`
	&sortby=`date`
	&sortdir=`DESC`
	]]
	<?php
	$parent = 3;
	$exclude_parents = array(100500,123456);
	$template = 4;

	$ids = $modx->getChildIds($parent));
	$q = $modx->newQuery('modResource', array('parent:IN' => $ids, 'OR:id:IN' => $ids));
	$q->andCondition(array('id:NOT IN' => $exclude_parents, 'template' => $template));
	$q->select('id,pagetitle,parent');
	$resources = array();
	<?php
	if (empty($id)) {$id = $modx->resource->id;}if (empty($tpl)) {$tpl = '@INLINE <a href="[[~[[+id]]]]">[[+pagetitle]]</a>';}
	$pdo = $modx->getService('pdoFetch');

	$conditions = array('product_id' => $id);
	$options = array(
	'innerJoin' => array(
	'msCategory' => array('on' => 'msCategoryMember.category_id = msCategory.id')
	),
	'select' => array('msCategory' => 'all'),
	<?php
	if ($thread = $modx->getObject('TicketThread', array('resource' => $id))) {
	echo $thread->get('comments');
	}
	#!/bin/bash

	# MySQL root password
	ROOTPASS='password'
	TIMEZONE='Europe/Moscow'

	MYSQLPASS=`< /dev/urandom tr -dc _A-Z-a-z-0-9 \| head -c12`
	SFTPPASS=`< /dev/urandom tr -dc _A-Z-a-z-0-9 \| head -c12`
	PASSWORD=`< /dev/urandom tr -dc _A-Z-a-z-0-9 \| head -c12`
	##############