7940 Posts in 1543 Topics by 946 members
|Go to End|
1 December 2011 at 1:47am
I´ve searched everywhere in web, but can´t find an solution.
I´m using DOM to save dates. Is it possible to delete the entries when the date is expired?
In php I can simply say: $query_delete_date = "DELETE FROM datetable WHERE date < DATE_SUB(NOW(), INTERVAL 1 DAY)";
But is there an nice way of writing a function into the DataObject-file?
Here´s my code from the DataObject:
$fields = singleton('Termin')->summaryFields();
class Termin extends DataObject
static $db = array (
'Datum' => 'Date',
'Text' => 'Text'
static $has_one = array (
'Aktuelles' => 'Aktuelles',
'Author' => 'Member'
//Fields to show in the DOM table
static $summary_fields = array(
static $default_sort = "Datum ASC";
//Fields for the DOM Popup
public function getCMSFields()
return new FieldSet(
$currentMember = Member::currentMember();
$this->AuthorID = $currentMember->ID;
I hope someone can help me.
2 December 2011 at 2:09am
I figered out, that I can better use the filter clause in the DOM. So I wanna filter the dates that were older than today's date.
$terminmanager = new DataObjectManager(
$this->Datum < date('Y-m-d')
But this doesn´t work either. Does someone see the mistake?
|Go to Top|