DA
Size: a a a
DA
А
А
А
А
А
АН
<?php
$sql="SELECT * FROM `afisha` where date>UNIX_TIMESTAMP() group by inner_id,str_date order by date limit 0,10";
$q=$modx->query($sql);
$res="";
if ($q){
$arr=$q->fetchAll(PDO::FETCH_ASSOC);
$group=[];
foreach ($arr as $item){
$group[$item['inner_id']][]=$item['str_date'];
}
foreach ($group as $key=>$item){
$obj=$modx->getObject('modResource',$key);
if ($obj){
$field['id']=$obj->id;
$field['pagetitle']=$obj->pagetitle;
$field['image']=$obj->getTVValue(1);
$field['image_list']=$obj->getTVValue(4);
$field['date_list']=implode('|',$item);
if (!$field['image']){
$imgs=json_decode($field['image_list']);
$field['image']=$imgs[1]->image;
if (!$field['image']) $field['image']=$imgs[0]->image;
}
$res.=$modx->getChunk('afisha',$field);
}
}
}
return $res;АС
E
EG
EG
ИБ
AG
AG
AG
ИБ
ИБ
ИБ
AG
ИБ