<?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();