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

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

    public $__table = 'invhist';             // table name
    public $invhist_id;                      // int4(4)  not_null default_nextval%28%28invhist_invhist_id_seq%29%3A%3Aregclass%29 primary_key
    public $invhist_itemsite_id;             // int4(4)  
    public $invhist_transdate;               // timestamptz(8)  default_%28now%29%3A%3Atimestamp%286%29%20with%20time%20zone
    public $invhist_transtype;               // bpchar(-1)  
    public $invhist_invqty;                  // numeric(-1)  
    public $invhist_invuom;                  // text(-1)  
    public $invhist_ordnumber;               // text(-1)  
    public $invhist_docnumber;               // text(-1)  
    public $invhist_qoh_before;              // numeric(-1)  
    public $invhist_qoh_after;               // numeric(-1)  
    public $invhist_unitcost;                // numeric(-1)  
    public $invhist_acct_id;                 // int4(4)  
    public $invhist_xfer_warehous_id;        // int4(4)  
    public $invhist_comments;                // text(-1)  
    public $invhist_posted;                  // bool(1)  default_true
    public $invhist_imported;                // bool(1)  
    public $invhist_hasdetail;               // bool(1)  default_false
    public $invhist_ordtype;                 // text(-1)  
    public $invhist_analyze;                 // bool(1)  default_true
    public $invhist_user;                    // text(-1)  default_%22current_user%22%28%29
    public $invhist_created;                 // timestamptz(8)  not_null default_now%28%29
    public $invhist_costmethod;              // bpchar(-1)  not_null
    public $invhist_value_before;            // numeric(-1)  not_null
    public $invhist_value_after;             // numeric(-1)  not_null
    public $invhist_series;                  // int4(4)  

    
    /* the code above is auto generated do not remove the tag below */
    ###END_AUTOCODE
    
    function applyFilters($q, $au, $roo)
    {
        
        $id = DB_DataObject::Factory('invdetail');
        $this->_join .= "
            RIGHT JOIN invdetail AS join_invdetail ON
            invhist.invhist_id = join_invdetail.invdetail_invhist_id";
        $this->selectAs($id, '%s', 'join_invdetail');
    
        $id = DB_DataObject::Factory('location');
        $this->_join .= "
            LEFT JOIN location AS join_location ON
            join_invdetail.invdetail_location_id = join_location.location_id";
        $this->selectAs($id, '%s', 'join_location');
    
        if (!empty($_REQUEST['invdetail_location_id'])) {
            $l = (int) $_REQUEST['invdetail_location_id'];
            $this->whereAdd(
                "invdetail_location_id = $l"
            );
        }
        
        
        
        
        /*
         does not work (not needed yet..)
         if (!empty($q['_with_item'])) {
            $itemsite = DB_DataObject::Factory('item');
            
            $this->_join .= "
                INNER JOIN itemsite AS join_invhist_itemsite_id ON
                invhist_itemsite_id = join_invhist_itemsite_id.itemsite_id";
            $this->selectAs($itemsite, '%s', 'join_invhist_itemsite_id');
            
            $item = DB_DataObject::Factory('item');
            
            $this->_join .= "
                INNER JOIN item AS join_invhist_item ON
                join_invhist_itemsite_id.itemsite_item_id = join_invhist_item.item_id";
            $this->selectAs($item, '%s', 'join_invhist_item');
        }
        */
    }
    function details()
    {
        if (!$this->invhist_hasdetail) {
            return false;
        }
        $d = DB_DAtaObject::factory('invdetail');
        $d->invdetail_invhist_id = $this->pid();
        return $d->fetchAll();
         
    }
    
}