ModifiedDeltaField.inc.php 802 Bytes
<?php

class ModifiedDeltaField extends DBFieldExpr
{
	private $modifiedName;

    public function __construct()
    {
        parent::__construct('modified', 'documents', 'Modified Delta');
        $this->setAlias('ModifiedDelta');
        $this->isValueQuoted(false);
    }

    public function modifyName($sql)
    {
    	$this->modifiedName = $sql;
    	$now = date('Y-m-d');


    	return "cast('$now' as date)";
    }

    public function modifyValue($value)
    {
    	return "cast($this->modifiedName + $value as date)";
    }

    public function getInputRequirements()
    {
        return array('value'=>array('type'=>FieldInputType::DATEDIFF));
    }

    public function is_valid()
    {
        return DefaultOpCollection::validateParent($this, DefaultOpCollection::$between);
    }
}

?>