4 * -- Dump accnt and backaccnt from HK
8 require_once 'Pman.php';
10 class Pman_Xtuple_dumpAccnt extends Pman
12 static $cli_desc = "Dump accnt and backaccnt from HK";
19 $ff = HTML_FlexyFramework::get();
20 if (!empty($ff->cli)) {
30 $accnt = DB_DataObject::factory('accnt');
31 $accnt->joinAddBankaccnt();
33 (SELECT curr_abbr FROM curr_symbol WHERE curr_id = accnt_curr_id) AS accnt_curr_abbr,
34 (SELECT curr_abbr FROM curr_symbol WHERE curr_id = bankaccnt_curr_id) AS bankaccnt_curr_abbr
38 while ($accnt->fetch()){
39 $line = $accnt->toArray();
40 foreach($line as $k=>$v) {
41 if (is_string($v) && !strlen($v)) {
47 $accnts[] = json_encode($line);
49 echo "[\n". implode(",\n", $accnts) . "]";