<?php
require 'ami_env.php';
$oResponse = AMI::getSingleton('response');
$oResponse->start();
$modId = 'news';
$oNewsModelList = AMI::getResourceModel($modId . '/table')->getList();
$oNewsModelList
->addColumns(array('date_created', 'header', 'id'))
->addWhereDef(
DB_Query::getSnippet('AND %s = %s')
->plain($oNewsModelList->getFieldName('public'))
->plain(1)
)
->addWhereDef(
DB_Query::getSnippet('AND %s = %s')
->plain($oNewsModelList->getFieldName('lang'))
->q('ru')
)
->addOrder('date_created', ' desc')
->setLimitParameters(0, 3)
->load();
$res = '<table>';
$res .= '<tr><th>Дата</th><th>Название</th></tr>';
foreach($oNewsModelList as $oNewsModelItem) {
$res .= '<tr><td>' . $oNewsModelItem->date_created . '</td><td>' . $oNewsModelItem->header . '</td></tr>';
}
$res .= '</table>';
$oResponse->write($res);
$oResponse->send();