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

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

    public $__table = 'flgrp';               // table name
    public $flgrp_id;                        // int4(4)  not_null default_nextval%28flgrp_flgrp_id_seq%29 primary_key
    public $flgrp_flhead_id;                 // int4(4)  
    public $flgrp_flgrp_id;                  // int4(4)  
    public $flgrp_order;                     // int4(4)  
    public $flgrp_name;                      // text(-1)  
    public $flgrp_descrip;                   // text(-1)  
    public $flgrp_subtotal;                  // bool(1)  not_null default_false
    public $flgrp_summarize;                 // bool(1)  not_null default_false
    public $flgrp_subtract;                  // bool(1)  not_null default_false
    public $flgrp_showstart;                 // bool(1)  not_null default_true
    public $flgrp_showend;                   // bool(1)  not_null default_true
    public $flgrp_showdelta;                 // bool(1)  not_null default_true
    public $flgrp_showbudget;                // bool(1)  not_null default_true
    public $flgrp_showstartprcnt;            // bool(1)  not_null default_false
    public $flgrp_showendprcnt;              // bool(1)  not_null default_false
    public $flgrp_showdeltaprcnt;            // bool(1)  not_null default_false
    public $flgrp_showbudgetprcnt;           // bool(1)  not_null default_false
    public $flgrp_prcnt_flgrp_id;            // int4(4)  not_null default_%28-1%29
    public $flgrp_showdiff;                  // bool(1)  not_null default_false
    public $flgrp_showdiffprcnt;             // bool(1)  not_null default_false
    public $flgrp_showcustom;                // bool(1)  not_null default_false
    public $flgrp_showcustomprcnt;           // bool(1)  not_null default_false
    public $flgrp_usealtsubtotal;            // bool(1)  not_null default_false
    public $flgrp_altsubtotal;               // text(-1)  

    
    /* the code above is auto generated do not remove the tag below */
    ###END_AUTOCODE
    function items()
    {
        $x = DB_DataObject::Factory('flitem');
        $x->flitem_flgrp_id = $this->pid();
        $x->orderBy('flitem_order ASC');
        return $x->fetchAll();
    }
    
    function groupAsArrays()
    {
        $groups = array();
        $flgrp = DB_DataObject::factory('flgrp');
        $flgrp->flgrp_flgrp_id = $this->pid();
        $flgrp->find();
        while ($flgrp->fetch()){
            $groups[$flgrp->flgrp_name] = $flgrp->toArray();
            $groups[$flgrp->flgrp_name]['groups'] = $flgrp->groupAsArrays();
            $groups[$flgrp->flgrp_name]['items'] = $flgrp->itemsAsArrays();
        }
        return $groups;
    }
    
    function itemsAsArrays()
    {
        $items = array();
        $flitem = DB_DataObject::factory('flitem');
        $flitem->flitem_flhead_id = $this->flgrp_flhead_id;
        $flitem->flitem_flgrp_id = $this->pid();
        $flitem->find();
        while ($flitem->fetch()){
            if($flitem->flitem_accnt_id > 0){
                HTML_FlexyFramework::get()->page->jerr('item accnt id is set');
            }
            $items[$flitem->pid()] = $flitem->toArray();
        }
        return $items;
    }
}