<?php

/**
 * -- Dump accnt and backaccnt from HK
 * 
 *
 */
require_once 'Pman.php';
 
class Pman_Xtuple_dumpAccnt extends Pman
{
    static $cli_desc = "Dump accnt and backaccnt from HK";
    
    var $cli = false;
    
    function getAuth() {
        
        
        $ff = HTML_FlexyFramework::get();
        if (!empty($ff->cli)) {
            $this->cli = true;
            return true;
        }
        die("NOT ALLOWED");
    }
    
    function get()
    {
        
        $accnt = DB_DataObject::factory('accnt');
        $accnt->joinAddBankaccnt();
        $accnt->SelectAdd("
            (SELECT curr_abbr FROM curr_symbol WHERE curr_id = accnt_curr_id) AS accnt_curr_abbr,
            (SELECT curr_abbr FROM curr_symbol WHERE curr_id = bankaccnt_curr_id) AS bankaccnt_curr_abbr
        ");
        $accnt->find();
        $accnts = array();
        while ($accnt->fetch()){
            $line = $accnt->toArray();
            foreach($line as $k=>$v) {
                if (is_string($v) && !strlen($v)) {
                    unset($line[$k]);
                }
                
            }
            
            $accnts[] = json_encode($line);
        }
        echo "[\n". implode(",\n", $accnts) . "]";
        
        exit;
    }
    
    
    
}