Получить список товара по номеру заказа в плагине
Aug 1, 2016
Добрый день!
При изменении статуса заказа хочу отправлять письмо контрагенту — сообщать об изменении заказа. Это с вашей помощью мы сделали. Теперь при отправке этого письма хочется заполнить шаблон smarty и отправить его. Для этого надо получить список товара по номеру заказа, чтобы заполнить таблицу в письме. Пытаюсь сделать так:
$modx->switchContext('web');
$modx->invokeEvent('OnHandleRequest');
$modx->smarty->assign('order', $object->toArray());
$response = $this->modx->runProcessor('basket/mgr/orders/products/getdata',
array(
"order_id" => $this->object->get('id'),
), array(
'processors_path' => MODX_CORE_PATH.'components/basket/processors/',
)
);
$data = $response->getResponse()
$modx->smarty->assign('order_data', $data);
unset($data);
$message = $modx->smarty->fetch("message/order_submitted/contractor.tpl");
$subject = "Ваш заказ принят";
$object->Contractor->sendEmail($message, array(
"subject" => $subject,
));
Получаю ошибку:
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
Could not load class: OrderProduct from mysql.orderproduct.
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
No class specified for loadClass
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
Could not load class
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
No class specified for loadClass
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
Could not load class !
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
No class specified for loadClass
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
No class specified for loadClass
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
Could not load class: OrderProduct from mysql.orderproduct.
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
OrderProduct::getSelectColumns() is not a valid static method.
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
Could not load class: OrderProduct from mysql.orderproduct.
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
Could not load class OrderProduct
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
modSiteWebGetlistProcessor
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM WHERE ( ``.`order_id` = '8' AND ``.`quantity` > '0' )' at line 1
)
[2016-08-01 09:06:54] (ERROR @ /manager/components/console/connectors/console.php)
SELECT COUNT(DISTINCT *) FROM WHERE ( ``.`order_id` = '8' AND ``.`quantity` > '0' )
Array
(
[success] => 1
[message] =>
[count] => 0
[total] => 0
[limit] => 20
[page] => 0
[object] => Array
(
)
[sum] => 0
[original_sum] => 0
[discount] => 0
[quantity] => 0
[positions] => 0
)
Подскажите, что надо сделать? Заранее спасибо!