Весь код:
$app = self::app(); $submission = $event->getSubject(); // получаем объект события $params = $event->getParameters(); // получаем доп параметры $appParams = $params['appParams']; $item = $params['item']; $subject ='Письмо...'; $elementCategId = $item->getPrimaryCategoryID(); if ($elementCategId =2) { $elementIMEI = $item->getElement('52d6af12-239b-46f0-967f-b457e8f52b49'); $dataIMEI = (array)$elementIMEI->data(); // получаем данные элемента IMEI $elementsFinde = array( '_itemcategory' => '1', '52d6af12-239b-46f0-967f-b457e8f52b49'=>$dataIMEI['value']); $items = JBModelFilter::model()->search($elementsFinde,'and',false,1,false,0,1,''); if (count($items) > 0) { //отправляем письмо $userEmail = JFactory::getUser($items[0]->created_by)->email; if ($userEmail) { $userLayout = $appParams->get('global.jbzoo_cart_config.email-user-layout-payment'); $app->jbemail->sendByItem($userEmail, $subject, $items[0], $userLayout); } }
Получаем ошибку на search.
1146 - Table 'galove_checkimei.yizyb_zoo_jbzoo_index_' doesn't exist SQL=SELECT DISTINCT tItem.id as id FROM yizyb_zoo_item AS tItem LEFT JOIN yizyb_zoo_jbzoo_index_ AS tIndex ON tIndex.item_id = tItem.id LEFT JOIN yizyb_zoo_jbzoo_sku AS tSku ON tSku.item_id = tItem.id LEFT JOIN yizyb_zoo_category_item AS tCategoryItem ON tCategoryItem.item_id = tItem.id WHERE tItem.access IN (1,5) AND tItem.state = '1' AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2015-05-26 10:09:58') AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2015-05-26 10:09:58') AND tItem.searchable = '1' AND tItem.application_id = '1' AND (tCategoryItem.category_id IN (1)) ORDER BY tItem.priority DESC LIMIT 1
Параметры exact и type оставили по умолчанию, не знаем что это.