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

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

    public $__table = 'vendinfo';            // table name
    public $vend_id;                         // int4(4)  not_null default_nextval%28%28vend_vend_id_seq%29%3A%3Aregclass%29 primary_key
    public $vend_name;                       // text(-1)  
    public $vend_lastpurchdate;              // date(4)  
    public $vend_active;                     // bool(1)  
    public $vend_po;                         // bool(1)  
    public $vend_comments;                   // text(-1)  
    public $vend_pocomments;                 // text(-1)  
    public $vend_number;                     // text(-1)  unique_key unique_key
    public $vend_1099;                       // bool(1)  
    public $vend_exported;                   // bool(1)  
    public $vend_fobsource;                  // bpchar(-1)  
    public $vend_fob;                        // text(-1)  
    public $vend_terms_id;                   // int4(4)  
    public $vend_shipvia;                    // text(-1)  
    public $vend_vendtype_id;                // int4(4)  
    public $vend_qualified;                  // bool(1)  
    public $vend_ediemail;                   // text(-1)  
    public $vend_ediemailbody;               // text(-1)  
    public $vend_edisubject;                 // text(-1)  
    public $vend_edifilename;                // text(-1)  
    public $vend_accntnum;                   // text(-1)  
    public $vend_emailpodelivery;            // bool(1)  
    public $vend_restrictpurch;              // bool(1)  
    public $vend_edicc;                      // text(-1)  
    public $vend_curr_id;                    // int4(4)  default_basecurrid%28%29
    public $vend_cntct1_id;                  // int4(4)  
    public $vend_cntct2_id;                  // int4(4)  
    public $vend_addr_id;                    // int4(4)  
    public $vend_match;                      // bool(1)  not_null default_false
    public $vend_ach_enabled;                // bool(1)  not_null default_false
    public $vend_ach_accnttype;              // text(-1)  
    public $vend_ach_use_vendinfo;           // bool(1)  not_null default_true
    public $vend_ach_indiv_number;           // text(-1)  not_null default_
    public $vend_ach_indiv_name;             // text(-1)  not_null default_
    public $vend_ediemailhtml;               // bool(1)  not_null default_false
    public $vend_ach_routingnumber;          // bytea(-1)  not_null default_%5C%5Cx00
    public $vend_ach_accntnumber;            // bytea(-1)  not_null default_%5C%5Cx00
    public $vend_taxzone_id;                 // int4(4)  

    
   /**
    * Getter / Setter for $vend_curr_id
    *
    * @param    mixed   (optional) value to assign
    * @access   public
    */
    public function curr() {
        return func_num_args() ? $this->link('vend_curr_id', func_get_arg(0)) : $this->link('vend_curr_id');
    }

   /**
    * Getter / Setter for $vend_addr_id
    *
    * @param    mixed   (optional) value to assign
    * @access   public
    */
    public function addr() {
        return func_num_args() ? $this->link('vend_addr_id', func_get_arg(0)) : $this->link('vend_addr_id');
    }

   /**
    * Getter / Setter for $vend_taxzone_id
    *
    * @param    mixed   (optional) value to assign
    * @access   public
    */
    public function taxzone() {
        return func_num_args() ? $this->link('vend_taxzone_id', func_get_arg(0)) : $this->link('vend_taxzone_id');
    }

   /**
    * Getter / Setter for $vend_vendtype_id
    *
    * @param    mixed   (optional) value to assign
    * @access   public
    */
    public function vendtype() {
        return func_num_args() ? $this->link('vend_vendtype_id', func_get_arg(0)) : $this->link('vend_vendtype_id');
    }
    
    /**
    * Getter / Setter for $vend_terms_id
    *
    * @param    mixed   (optional) value to assign
    * @access   public
    */
    public function terms() {
        return func_num_args() ? $this->link('vend_terms_id', func_get_arg(0)) : $this->link('vend_terms_id');
    }


    /* the code above is auto generated do not remove the tag below */
    ###END_AUTOCODE
    
    function  findInternal($int_name, $cur)
    {
        //DB_DataObject::DebugLevel(1);
        $ve = $this->factory($this->tableName());
        $ve->vend_curr_id = $cur->pid();
        // CRMACCT
        $ve->whereAdd(" charass_getvalue('CRMACCT',
                        (SELECT crmacct_id FROM crmacct where crmacct_vend_id = vend_id LIMIT 1),
                        'INTERNALCOMPANY') = '{$this->escape($int_name)}'");
        // fixme INTERNALCOMPANY must  be added to contacts
        $matches = $ve->count();
        if (!$matches || $matches > 1) {
            return false;
        }
        $ve->find(true);
        
        return $ve;
        
    }
    
    
    function applyFilters($q,$au, $roo)
    {
         if (!empty($q['search']['name'])) {
            $v = $this->escape($q['search']['name']);
            $this->whereAdd("vend_name ILIKE '%$v%' or vend_number ILIKE '%$v%' ");
        }
         if (!empty($q['query']['vend_name'])) {
            $v = $this->escape($q['query']['vend_name']);
            $this->whereAdd("vend_name ILIKE '%$v%' or vend_number ILIKE '%$v%' ");
        }
        
        if (!empty($q['_with_char'])) {
            $ch = DB_DAtaObject::Factory('char');
            $ch->char_crmaccounts = 1;
            
            //if (!$ch->count() < 2) {
            //    $ch->initDatabase();
            //}
            $ch->find();
            while ($ch->fetch()) {
                $nm = 'vend_char_' . strtolower(preg_replace('/[^a-z]+/i','_', $ch->char_name));
            
                $this->selectAdd("
                    charass_getvalue('CRMACCT',
                            (SELECT crmacct_id FROM crmacct where crmacct_vend_id = vend_id LIMIT 1),
                            '{$this->escape($ch->char_name)}') as $nm
                ");
                
                if (!empty($q['sort']) && $q['sort'] == $nm) {
                    $dir = (empty($q['dir']) || $q['dir'] == 'ASC') ? 'ASC' : 'DESC';
                    $this->orderBy("charass_getvalue('CRMACCT',
                                   (SELECT crmacct_id FROM crmacct where crmacct_vend_id = vend_id LIMIT 1),
                                   '{$this->escape($ch->char_name)}') $dir");
                }
            }
             
        }
    }
    
    function beforeInsert($q,$roo)
    {
        foreach ($this->defaults() as $k => $v){
            if(!isset($this->$k)){
                $this->$k = $v;
            }
        }
    }
    
    function beforeUpdate($old, $q,$roo)
    {
        if(!empty($q['_remove_addr'])){
            $vendaddrinfo = DB_DataObject::factory('vendaddrinfo');
            $vendaddrinfo->vendaddr_vend_id = $this->pid();
            $addrs = $vendaddrinfo->fetchAll();
            foreach ($addrs as $addr){
                $addr->delete();
            }
            $roo->jok('UPDATED');
        }
        
    }
    
    function beforeDelete($dependants_array, $roo){
        $roo->addEvent("DELETE", $this);
        $this->delete();
        $roo->jok("Deleted");
    }

    function defaults()
    {
        return array(
            'vend_accnt_id' => -1,
            'vend_vendtype_id' => $this->sqlValue("getvendtypeid('NORMAL'::text)"),
            'vend_active' => true,
            'vend_curr_id' => $this->sqlValue("baseCurrId()"),
            'vend_terms_id' => $this->sqlValue("fetchmetricvalue('DefaultTerms'::text)"),
            'vend_taxzone_id' => $this->sqlValue("gettaxzoneid('NO TAX')"),
            'vend_shipvia' => $this->sqlValue("fetchdefaultshipvia()"),
        );
    }
         
    
}