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

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

    public $__table = 'custtype';            // table name
    public $custtype_id;                     // int4(4)  not_null default_nextval%28%28custtype_custtype_id_seq%29%3A%3Aregclass%29 primary_key
    public $custtype_code;                   // text(-1)  not_null unique_key
    public $custtype_descrip;                // text(-1)  not_null
    public $custtype_char;                   // bool(1)  not_null default_false

    
    /* the code above is auto generated do not remove the tag below */
    ###END_AUTOCODE
    
    static $_defaults = array(
            array(
                'custtype_code' => 'NORMAL',
                'custtype_descrip' => 'Normal Customer',
                'custtype_char' => false,
            ),
            array(
                'custtype_code' => 'INTERNALCOMPANY',
                'custtype_descrip' => 'Internal Company',
                'custtype_char' => false,
            ), 
            array(
                'custtype_code' => 'ONLINE',
                'custtype_descrip' => 'Online Customer',
                'custtype_char' => false,
            ),        
    );
    
    
    function initDatabase()
    {
        
        foreach(self::$_defaults as $data) {
            
            $d = DB_DataObject::Factory('custtype');
            $d->custtype_code = $data['custtype_code'];
            if ($d->count()) {
                continue;
            }
            $d = DB_DataObject::Factory('custtype');
            $d->setFrom($data);
            $d->insert();
        }
        
        $d = DB_DataObject::Factory('custtype');
        if($d->get('custtype_code', 'NORMAL')){
            $metric = DB_DataObject::Factory('metric');
            $metric->query("SELECT setmetric('DefaultCustType', '{$d->pid()}')");
        }
        
    }
    
}