<?php
/**
 * Table Definition for metric
 */
require_once 'DB/DataObject.php';

class Pman_Xtuple_DataObjects_Metric extends DB_DataObject 
{
    ###START_AUTOCODE
    /* the code below is auto generated do not remove the above tag */

    public $__table = 'metric';              // table name
    public $metric_id;                       // int4(4)  not_null default_nextval%28%28metric_metric_id_seq%29%3A%3Aregclass%29 primary_key
    public $metric_name;                     // text(-1)  
    public $metric_value;                    // text(-1)  
    public $metric_module;                   // text(-1)  

    
    /* the code above is auto generated do not remove the tag below */
    ###END_AUTOCODE
    
    function applyFilters($q, $au, $roo)
    {
        if(!empty($q['search']['name'])){
            $this->whereAdd("
                metric_name ILIKE '%{$this->escape($q['search']['name'])}%'
            ");
        }
    }
    
    function beforeInsert($q, $roo)
    {
        if($this->isNameExist()){
            $roo->jerr("{$this->metric_name} already exists!");
        }
    }
    
    function beforeUpdate($old, $q, $roo)
    {
        if($this->isNameExist()){
            $roo->jerr("{$this->metric_name} already exists!");
        }
    }
    
    function isNameExist()
    {
        $metric = DB_DataObject::factory('metric');
        $metric->metric_name = $this->metric_name;
        
        if(!empty($this->metric_id)){
            $metric->whereAdd("
                metric_id != {$this->metric_id}
            ");
        }
        
        return ($metric->count()) ? true : false;
    }
}