ms2ordersManager.php

<?php
/*****************************************************
 ** Вывод списка заказов пользователей
 ** 
 ** 
 ****************************************************/

$tpl = $modx->getOption('tpl', $scriptProperties, '');
$pdoTools = $modx->getService('pdoTools');
$pdo = $modx->getService('pdoFetch');
$pdo->setConfig(array(
	'tpl' => $tpl,
	'class' => 'msOrder',
	'loadModels' => 'minishop2',
	'leftJoin' => array(
		'Status' => array(
				'class' => 'msOrderStatus',
				'on' => 'msOrder.status = Status.id'
			),
		'Delivery' => array(
				'class' => 'msDelivery',
				'on' => 'msOrder.delivery = Delivery.id'
			),
		'Payment' => array(
				'class' => 'msPayment',
				'on' => 'msOrder.payment = Payment.id'
			)
	),
	'select' => array(
		'msOrder' 	=> 'msOrder.*',
		'Status' 	=> 'Status.name',
		'Delivery'  => 'Delivery.name as dname',
		'Payment' 	=> 'Payment.name as pname',
	),
	'groupby' => 'msOrder.id',
	'sortby' => 'msOrder.createdon',
	'sortdir' => 'DESC',
));
$pdo = $pdo->run();
return $pdo;