Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions /

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Update fields by date

Go to End

3 Posts   693 Views


Community Member, 58 Posts

30 December 2012 at 2:01pm

Hi, I have problem.
I try to write function to change fields in DB when date exceeds specific date

I have DataObject "Obiekt"


class Obiekt extends DataObject {

    static $db = array(
        'NrObiektu' => 'Int',
        'Title' => 'Varchar(255)',
        'Created' => 'Date',
        'Waznosc' => 'Date', //for when to display the object
"Status" => "Enum('Oplacony, Nieoplacony')",

    static $indexes = array(
        "URLSegment" => true

    public function getCMSFields() {
        $fields = parent::getCMSFields();
        return $fields;

    function onBeforeWrite() {


I don't know how write this and where placed this (maybe to function or init() or other place?)
Maybe by DB:: ?

Now I have to check date like this

        $now = date('Y-m-d H:i:s');
        $where = "Waznosc < '$now'";

I want to when $where is true change field Status from Oplacony to Nieoplacony

Sorry for my bad English


Community Member, 541 Posts

8 January 2013 at 4:45pm

Edited: 08/01/2013 4:48pm

You need to convert the Database value into a unix timestamp so your conditional statement would be something like

strtotime($this->Waznosc) < time()

time() returns the current time as Unix Time Stamp so you don't need to worry about formatting it like with date()

As an aside strtotime() is also great for calculating things like strtotime('next Sunday') or strtotime('Yesterday')


Community Member, 58 Posts

8 January 2013 at 10:47pm

THX For replay but I solved this by Cron