public function __construct() { $this->r_cloudBankServer = CloudBankServer::Singleton(); }
#!/usr/bin/php <?php require_once dirname(__FILE__) . '/../server/CloudBankServer.php'; $p_account_name = $argv[1]; $p_date = $argv[2]; CloudBankServer::Singleton()->beginTransaction(); $v_ledgerAccountID = CloudBankServer::Singleton()->execQuery('SELECT id FROM ledger_account WHERE name = :name', array(':name' => $p_account_name)); if (!$v_ledgerAccountID) { exit; } CloudBankServer::Singleton()->execQuery(' UPDATE event SET is_cleared = 1 WHERE ( credit_ledger_account_id = :ledger_account_id OR debit_ledger_account_id = :ledger_account_id ) AND date <= :date ', array(':ledger_account_id' => $v_ledgerAccountID[0]['id'], ':date' => $p_date)); CloudBankServer::Singleton()->commitTransaction();
#!/usr/bin/php <?php require_once dirname(__FILE__) . '/../server/CloudBankServer.php'; require_once dirname(__FILE__) . '/../server/SchemaDef.php'; // require_once('SCA/SCA.php'); CloudBankServer::Singleton()->tryQuery(' ALTER TABLE event ADD statement_item_id VARCHAR(16) '); CloudBankServer::Singleton()->tryQuery(' ALTER TABLE event ADD is_cleared BOOLEAN DEFAULT 0 '); CloudBankServer::Singleton()->tryQuery('DROP VIEW account_events'); $g_createSchemaStatements = SchemaDef::CreateSchemaStatements(); foreach (array('account_events', 'statement_item', 'statement_item_unmatched', 'event_statement_item_match', 'event_matched') as $v_dBObject) { CloudBankServer::Singleton()->tryQuery($g_createSchemaStatements[$v_dBObject]); }
#!/usr/bin/php <?php require_once dirname(__FILE__) . '/../server/CloudBankServer.php'; require_once dirname(__FILE__) . '/../server/SchemaDef.php'; require_once 'SCA/SCA.php'; foreach (SchemaDef::CreateSchemaStatements() as $v_dBObject => $v_sQLStatement) { CloudBankServer::Singleton()->tryQuery($v_sQLStatement); } $v_ledgerAccountService = SCA::getService(dirname(__FILE__) . '/../server/LedgerAccountService.php'); $v_ledgerAccountService->createBeginningAccount();