hey DorsetDigital! thank’s to you for you’r interest!
I understant what’s you said, and thinking like you. And i trying to test with the SetDateFormat.
So In my error.log:
[2018-12-24 11:47:38] error-log.ERROR: Uncaught Exception Error: “Call to a member function setDateFormat() on string” at /var/www/silverstripe/app/src/Page.php line 116 {“exception”:"[object] (Error(code: 0): Call to a member function setDateFormat() on string at /var/www/silverstripe/app/src/Page.php:116)"}
So i found this solution, but it’s not realy sexy…
in my dB this is the table ‘MediaPage’:
|Colonne|Type|
|ID|int(11)
|ExternalLink|varchar(255)
|Abstract|mediumtext
|Date|date
|MediaTypeID|int(11)
//News-Tag-Jeunes
public function RecentJeunes()
{
$list1 = ArrayList::create();
//
$sqlQuery = new SQLSelect();
$sqlQuery->setFrom('MediaPage');
$sqlQuery->selectField('*');
$sqlQuery->addInnerJoin('MediaPage_Categories','"MediaPage_Categories"."MediaPageID" = "MediaPage"."ID"');
$sqlQuery->addWhere('"MediaPage_Categories"."MediaTagID" = 1');
$sqlQuery->setOrderBy('Date', 'DESC');
// $sqlQuery->setGroupBy(...);
// $sqlQuery->setHaving(...);
$sqlQuery->setLimit(3);
//$sqlQuery->setDistinct(true);
//
// Execute and return a Query object
$results = $sqlQuery->execute();
//
// Iterate over results
//print_r($results);
//
foreach($results as $row) {
//
$type = SiteTree::get()->byID($row['MediaPageID']);
if ($type) {
$name = $type->title;
} else {
$name="";
}
//
$list1->push(
new ArrayData(array(
//'mDates'=>$row['Date'],
'mDatesD'=>date('d',strtotime($row['Date'])),
'mDatesM'=>date('m',strtotime($row['Date'])),
'mDatesY'=>date('Y',strtotime($row['Date'])),
'mAbstract'=>$row['Abstract'],
'mTitle'=>$name,
)
)
);
//
//print_r($list1);
return $list1;
}
<article>
<span class="title">Jeunes</span>
<% loop $RecentJeunes %>
<%-- p class="infos">$Title - $Date - $Abstract.LimitWordCount(10)</p --%>
<div class="event">
<div class="fatDate">
<span class="dayOfMonth">$mDatesD</span>
<span class="month">$mDatesM</span>
<span class="year">$mDatesY</span>
<p> </p>
</div>
<div class="fatText">
<h3>$mTitle.UpperCase</h3>
$mAbstract.LimitWordCount(10)
<p> </p>
</div>
<a href="$InternalLink" class="readMore"> >> Read More...</a>
</div>
<% end_loop %>
</article>
if you can tel me more, i realy appreciate!
Thanks.