PHP initDB函数代码示例

function getDoaramaURL($league_nm, $date)
{
    //TODO, could get all doaramas at once eventually to optimize
    $league_key = $league_nm . "-" . $date;
    //TODO: replace with your own DB implementation
    //Getting our doarama key for the given date
    $conn = initDB();
    $sql = "SELECT doarama_key FROM doaramas WHERE league_key = ?";
    $rows = run_stmt_query($conn, $sql, "s", array($league_key));
    $doarama_key = $rows[0]['doarama_key'];
    // Get names for activity, very important to sort by date_created to ensure that the names match the track logs
    $sql = "SELECT u.name\n\t\t\t\tFROM user_activity ua\n\t\t\t\tJOIN user u ON (u.user_id = ua.user_id)\n\t\t\t\tWHERE ua.league_key = ?\n\t\t\t\tORDER BY ua.date_created";
    $rows = run_stmt_query($conn, $sql, "s", array($league_key));
    $url = "http://api.doarama.com/api/0.2/visualisation?k={$doarama_key}";
    $url .= "&avatarBaseUrl=http%3A%2F%2Fwww.yourwebsite.com%2Favatar%2F";
    $url .= "&dzml=http%3A%2F%2Fwww.yourwebsite.com%2Ftask.dzml";
    foreach ($rows as $row) {
        $name = $row["name"];
        $name = ucwords(strtolower($name));
        $nameParts = preg_split("/ /", $name);
        $formattedName = "unknown";
        //Take a name like 'aaron price' and convert it to 'AaronP'
        if (count($nameParts) == 1) {
            $formattedName = $nameParts[0];
        } elseif (count($nameParts) > 1) {
            $formattedName = $nameParts[0] . $nameParts[1][0];
        }
        $url .= "&name={$formattedName}";
    }
    return $url;
}

function queryDB_RAW($SQL)
{
    initDB();
    global $db_connection;
    $result = $db_connection->query($SQL, MYSQLI_USE_RESULT);
    return $result;
}

function uploadTrack($track_filepath, $user_id, $task_date)
{
    //Upload track to Doarama (create new activity)
    $data = array('gps_track' => "@{$track_filepath}");
    $response = doCurl("activity", $data, $user_id);
    $data = json_decode($response, true);
    $activity_id = $data["id"];
    //Next set activity info https://api.doarama.com/api/0.2/activityType
    /* 27	Fly - Hang Glide
       28	Fly - Sailplane / Glider
       29	Fly - Paraglide	*/
    $data = '{"activityTypeId":29}';
    //TODO: refactor to not just be paragliding
    doCurl("activity/{$activity_id}", $data, $user_id);
    //TODO: replace with your own DB initialization.  I set mine to transactional since I don't want to populate
    //it with bad entries if the track upload fails.
    $conn = initDB();
    $conn->autocommit(FALSE);
    //Create a key for our local DB that we can use to link to a visualization.
    //I use a key that given a date and a competition name will map to one specific visualization for that day
    $league_key = "socal-{$task_date}";
    //TODO: factor out for other leagues.
    //Create an entry in the DB that maps a doarama activity_id to a unique_user_id in your local DB
    //Since naming pilots in the API is done in the order of upload, if you want to name the tracks with
    //user names make sure to be able to query your DB for activities that map to the end visualization
    //and can be sorted in the order they were created.  I've setup my DB to populate date_created automatically
    $sql = "INSERT INTO user_activities (USER_ID, ACTIVITY_ID, LEAGUE_KEY) VALUES (?, ?, ?)";
    $types = "iis";
    $params = array($user_id, $activity_id, $league_key);
    insert_row($conn, $sql, $types, $params);
    //TODO replace with your own DB implementation
    //TODO: update with your own DB implementation
    //Try to find the doarama_key in our DB from our league_key, if we don't get any results it means we haven't
    //yet created a visualization so we'll need to make one and save the Doarama Key in our DB
    $sql = "SELECT doarama_key FROM doaramas WHERE league_key = ?";
    $rows = run_stmt_query($conn, $sql, "s", array($league_key));
    if (count($rows) < 1) {
        // Create Visualization
        $data = '{"activityIds":[' . $activity_id . ']}';
        $response = doCurl("visualisation", $data, $user_id);
        //get doarama_key
        $data = json_decode($response, true);
        $doarama_key = $data["key"];
        //TODO: update with your own DB implementation
        //insert into DB
        $sql = "INSERT INTO doaramas (league_key, doarama_key) VALUES (?, ?)";
        $types = "ss";
        $params = array($league_key, $doarama_key);
        insert_row($conn, $sql, $types, $params);
    } else {
        $doarama_key = $rows[0]['doarama_key'];
        // Add activity to visualization
        $data = '{"visualisationKey" : "' . $doarama_key . '", "activityIds": [' . $activity_id . ']}';
        doCurl("visualisation/addActivities", $data, $user_id);
    }
    //TODO: update with your DB implementation
    //all done now, can commite the transaction
    $conn->commit();
    $conn->close();
}

function insert($table, $array)
{
    $db_handle = initDB();
    $query = "INSERT INTO {$table} ({$array['0']}) VALUES ({$array['1']})";
    echo $query;
    $result = $db_handle->exec($query) or die("Unable add data to {$table}");
    print_r($result);
}

function getEnvironmentData()
{
    initDB($db, $username, $password);
    $sql = "SELECT * FROM `temperature`; ";
    $result = mysql_query($sql) or die('MySQL query error');
    while ($row = mysql_fetch_assoc($result)) {
        $arr[] = $row;
    }
    return json_encode($arr);
}

 function CQuota($check_remoter)
 {
     $this->_MDB2 = initDB();
     $this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = '0';
     $this->items = array();
     $this->class_name = get_class($this);
     $arr = array('InsertQuotaRate' => array('input' => array('Rate', 'TDate', 'CreatedBy'), 'output' => array('ID')), 'UpdateQuotaRate' => array('input' => array('QuotaRateID', 'Rate', 'UpdatedBy'), 'output' => array()), 'DeleteQuotaRate' => array('input' => array('QuotaRateID', 'UpdatedBy'), 'output' => array()), 'ConfirmQuotaRate' => array('input' => array('QuotaRateID', 'UpdatedBy'), 'output' => array()), 'DeleteConfirmedQuotaRate' => array('input' => array('QuotaRateID', 'UpdatedBy'), 'output' => array()), 'GetQuotaRateList' => array('input' => array('WhereClause', 'TimeZone'), 'output' => array('ID', 'RateProceeds', 'T', 'IsConfirmed', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'UpdateConfirmedQuotaRate' => array('input' => array('QuotaRateID', 'Rate', 'UpdatedBy'), 'output' => array('ID')), 'InsertQuotaSetting' => array('input' => array('QuotaAmount', 'CreatedBy'), 'output' => array('ID')), 'UpdateQuotaSetting' => array('input' => array('QuotaSettingID', 'QuotaAmount', 'UpdatedBy'), 'output' => array()), 'DeleteQuotaSetting' => array('input' => array('QuotaSettingID', 'UpdatedBy'), 'output' => array()), 'ConfirmQuotaSetting' => array('input' => array('QuotaSettingID', 'UpdatedBy'), 'output' => array()), 'GetQuotaSettingList' => array('input' => array('WhereClause', 'TimeZone'), 'output' => array('ID', 'QuotaAmount', 'SetDate', 'IsConfirmed', 'IsExec', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'InsertQuotaStockPercent' => array('input' => array('StockSymbol', 'StockExchangeID', 'PercentPrice', 'CreatedBy'), 'output' => array('ID')), 'UpdateQuotaStockPercent' => array('input' => array('QuotaStockPercentID', 'PercentPrice', 'UpdatedBy'), 'output' => array()), 'GetQuotaStockPercentList' => array('input' => array('WhereClause', 'TimeZone'), 'output' => array('ID', 'PercentPrice', 'StockID', 'Symbol', 'StockExchangeID', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'GetQuotaStockPercentInfo' => array('input' => array('QuotaStockPercentID'), 'output' => array('ID', 'PercentPrice', 'StockID', 'Symbol', 'StockExchangeID')), 'GetQuotaRateInfo' => array('input' => array('QuotaRateID'), 'output' => array('ID', 'RateProceeds', 'T')), 'GetQuotaSettingInfo' => array('input' => array('QuotaSettingID'), 'output' => array('ID', 'QuotaAmount', 'SetDate')), 'InsertQuotaAccount' => array('input' => array('AccountID', 'CreatedBy'), 'output' => array('ID')), 'GetQuotaAccountList' => array('input' => array('AccountNo', 'CreatedBy', 'FromDate', 'ToDate'), 'output' => array('ID', 'AccountID', 'AccountNo', 'FullName', 'OrginalQuota', 'UsableQuota', 'DayToProceed', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'UpdateQuotaAccountDayToProceed' => array('input' => array('QuotaAccountID', 'DayToProceed', 'UpdatedBy'), 'output' => array()), 'DeleteQuotaAccount' => array('input' => array('QuotaAccountID', 'UpdatedBy'), 'output' => array()), 'GetQuotaAccountInfo' => array('input' => array('QuotaAccountID'), 'output' => array('ID', 'AccountID', 'AccountNo', 'FullName', 'OrginalQuota', 'UsableQuota', 'DayToProceed', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'InsertQuotaTransfer' => array('input' => array('FromAccountID', 'ToAccountID', 'QuotaAmount', 'Note', 'CreatedBy'), 'output' => array('ID')), 'DeleteQuotaTransfer' => array('input' => array('QuotaTransferID', 'UpdatedBy'), 'output' => array()), 'ConfirmQuotaTransfer' => array('input' => array('QuotaTransferID', 'UpdatedBy'), 'output' => array()), 'GetQuotaTransferList' => array('input' => array('FromAccountNo', 'ToAccountNo', 'TransferDate', 'IsConfirmed', 'CreatedBy'), 'output' => array('ID', 'FromAccountID', 'ToAccountID', 'FromAccountNo', 'ToAccountNo', 'QuotaAmount', 'TransferDate', 'IsConfirmed', 'Note', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'GetQuotaAccountDetail' => array('input' => array('AccountNo'), 'output' => array('ID', 'AccountID', 'AccountNo', 'FullName', 'OrginalQuota', 'UsableQuota', 'DayToProceed', 'CardNo', 'Amount')), 'InsertQuotaDepositWithdraw' => array('input' => array('AccountID', 'QuotaAmount', 'Note', 'Type', 'CreatedBy'), 'output' => array('ID')), 'DeleteQuotaDepositWithdraw' => array('input' => array('QuotaDepositWithdrawID', 'UpdatedBy'), 'output' => array()), 'ConfirmQuotaDepositWithdraw' => array('input' => array('QuotaDepositWithdrawID', 'UpdatedBy'), 'output' => array()), 'GetQuotaDepositWithdrawList' => array('input' => array('AccountNo', 'TradingDate', 'IsConfirmed', 'Type', 'CreatedBy'), 'output' => array('ID', 'AccountID', 'AccountNo', 'FullName', 'QuotaAmount', 'TradingDate', 'Note', 'IsConfirmed', 'Type', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'InsertQuotaPayment4TDebt' => array('input' => array('AccountID', 'Amount', 'CreatedBy'), 'output' => array('ID')), 'DeleteQuotaPayment4TDebt' => array('input' => array('PaymentID', 'UpdatedBy'), 'output' => array()), 'ConfirmQuotaPayment4TDebt' => array('input' => array('PaymentID', 'UpdatedBy'), 'output' => array()), 'GetQuotaTDebtList' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'AccountID', 'AccountNo', 'FullName', 'PaymentAmount', 'DebtAmount', 'TradingDate', 'PaymentDate', 'IsPaid', 'NumDay', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'GetQuotaPayment4TDebtList' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'AccountID', 'AccountNo', 'FullName', 'PaymentAmount', 'TradingDate', 'IsConfirmed', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'GetQuotaPayment4TDebtInfo' => array('input' => array('Payment4TDebtID'), 'output' => array('AccountID', 'AccountNo', 'PaymentAmount', 'IsConfirmed')), 'GetQuotaPayment4TDebtDetail' => array('input' => array('Payment4TDebtID'), 'output' => array('ID', 'TDebtID', 'Amount', 'DebtAmount', 'PaymentAmount')), 'ConfirmPaymentInterest' => array('input' => array('TDebtInterestID', 'UpdatedBy'), 'output' => array('ID', 'AccountID', 'AccountNo', 'FullName', 'QuotaAmount', 'TradingDate', 'Note', 'IsConfirmed', 'Type', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'QuotaProcessReset' => array('input' => array('TradingDate', 'CreatedBy'), 'output' => array()), 'QuotaProcessCalculate' => array('input' => array('TradingDate', 'CreatedBy'), 'output' => array()), 'GetDebtInterestList' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'AccountNo', 'AccountID', 'FullName', 'InterestAmount', 'TradingDate', 'InterestRate', 'IsPaid', 'CreatedBy', 'UpdatedBy', 'CreatedDate', 'UpdatedDate')), 'GetAccountDebt' => array('input' => array('AccountID'), 'output' => array('DebtAmount', 'DebtAmountTotal', 'PaymentAmount', 'InterestAmount')), 'QuotaTDebt' => array('input' => array('TradingDate', 'CreatedBy'), 'output' => array()), 'GetTDebtDetailList' => array('input' => array('TdebtID'), 'output' => array('TDebtID', 'OrderID', 'OrderNumber', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'TradingDate', 'PaymentDate')), 'GetQuota4Bravo' => array('input' => array('TradingDate'), 'output' => array('AccountID', 'AccountNo', 'DebtAmount', 'BravoCode')), 'InsertQuota4AcountVB' => array('input' => array('AccountID', 'AccountNo', 'Amount', 'Note', 'TradingDate', 'CreatedBy'), 'output' => array()), 'InsertListOfQuota4AcountVB' => array('input' => array('TradingDate'), 'output' => array('AccountID', 'AccountNo', 'DebtAmount', 'BravoCode', 'ErrorCode')));
     parent::__construct($arr);
 }

function reinitDB()
{
    global $db, $config, $adminPassword, $adminLogin;
    //Nettoyage des précedents tests en cas d'interuption
    dropDB();
    initDB();
    upgradeDB(FALSE);
    $ret = $db->query($sql = "INSERT " . $config['db']['prefix'] . "users VALUES (NULL, '{$adminLogin}','{$adminPassword}','',1);");
    return $ret;
}

 function __construct($check_ip)
 {
     //initialize MDB2
     $this->_MDB2 = initDB();
     $this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = $check_ip;
     $this->class_name = get_class($this);
     $this->items = array();
     $arr = array('insertMortageContract' => array('input' => array('ContractNo', 'BankID', 'AccountNo', 'IsAssigner', 'LoanInterestRate', 'OverdueInterestRate', 'LoanPeriod', 'ContractValue', 'ContractDate', 'ReleaseDate', 'BlockedDate', 'SendDate', 'MatureDate', 'CreatedBy'), 'output' => array('ID')), 'updateMortageContract' => array('input' => array('MortageContractID', 'BankID', 'LoanInterestRate', 'OverdueInterestRate', 'LoanPeriod', 'ContractValue', 'ContractDate', 'ReleaseDate', 'BlockedDate', 'SendDate', 'MatureDate', 'UpdatedBy'), 'output' => array()), 'updateDateInMortageContract' => array('input' => array('MortageContractID', 'ReleaseDate', 'BlockedDate', 'SendDate', 'MatureDate', 'UpdatedBy'), 'output' => array()), 'insertStockSupplement' => array('input' => array('MortageContractID', 'TotalMoney', 'SupplementDate', 'Note', 'lstMoneyDown', 'lstMortageContractDetailID', 'CreatedBy'), 'output' => array('ID')), 'insertStockSupplementDetail' => array('input' => array('StockSupplementID', 'StockID', 'Quantity', 'PercentRate', 'MarketPrice', 'LoanMoney', 'CreatedBy'), 'output' => array('ID')), 'insertMoneySupplement' => array('input' => array('MortageContractID', 'AmountMoney', 'lstMoneyDown', 'lstMortageContractDetailID', 'Note', 'CreatedBy'), 'output' => array('ID')), 'insertMortageContractDetail' => array('input' => array('MortageContractID', 'StockID', 'Quantity', 'PercentRate', 'MarketPrice', 'LoanMoney', 'CreatedBy'), 'output' => array('ID')), 'updateMoney' => array('input' => array('MortageContractID', 'UpdatedBy'), 'output' => array()), 'updateStock' => array('input' => array('MortageContractID', 'UpdatedBy'), 'output' => array()), 'approveStockSupplement' => array('input' => array('StockSupplementID', 'lstMoneyDown', 'lstMortageContractDetailID', 'UpdatedBy'), 'output' => array()), 'approveMoneySupplement' => array('input' => array('MoneySupplementID', 'lstMoneyDown', 'lstMortageContractDetailID', 'UpdatedBy'), 'output' => array()), 'returnStockSupplement' => array('input' => array('StockSupplementID', 'lstMoneyDown', 'lstMortageContractDetailID', 'UpdatedBy'), 'output' => array()), 'returnMoneySupplement' => array('input' => array('MoneySupplementID', 'lstMoneyDown', 'lstMortageContractDetailID', 'UpdatedBy'), 'output' => array()), 'listMortageContracts' => array('input' => array('TimeZone'), 'output' => array('MortageContractID', 'ContractNo', 'BankID', 'BankName', 'AccountID', 'AccountNo', 'FullName', 'IsAssigner', 'LoanInterestRate', 'OverdueInterestRate', 'LoanPeriod', 'ContractValue', 'ContractDate', 'ReleaseDate', 'BlockedDate', 'SendDate', 'MatureDate', 'ContractStatus', 'Released', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listMortageContractsWithFilter' => array('input' => array('Condition', 'TimeZone'), 'output' => array('MortageContractID', 'ContractNo', 'BankID', 'BankName', 'AccountID', 'AccountNo', 'FullName', 'IsAssigner', 'LoanInterestRate', 'OverdueInterestRate', 'LoanPeriod', 'ContractValue', 'ContractDate', 'ReleaseDate', 'BlockedDate', 'SendDate', 'MatureDate', 'ContractStatus', 'Released', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listMortageContractsOwnSupplement' => array('input' => array('TimeZone'), 'output' => array('MortageContractID', 'ContractNo', 'BankID', 'BankName', 'AccountID', 'AccountNo', 'FullName', 'IsAssigner', 'LoanInterestRate', 'OverdueInterestRate', 'LoanPeriod', 'ContractValue', 'ContractDate', 'ReleaseDate', 'BlockedDate', 'SendDate', 'MatureDate', 'ContractStatus', 'Released', 'MoneySupplementAmount', 'StockSupplementAmount', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listMortageContractsOwnSupplementWithFilter' => array('input' => array('Condition', 'TimeZone'), 'output' => array('MortageContractID', 'ContractNo', 'BankID', 'BankName', 'AccountID', 'AccountNo', 'FullName', 'IsAssigner', 'LoanInterestRate', 'OverdueInterestRate', 'LoanPeriod', 'ContractValue', 'ContractDate', 'ReleaseDate', 'BlockedDate', 'SendDate', 'MatureDate', 'ContractStatus', 'Released', 'MoneySupplementAmount', 'StockSupplementAmount', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listAvailStocks' => array('input' => array('AccountID'), 'output' => array('StockID', 'Quantity', 'Symbol', 'ParValue')), 'listAvailStocksWhenEdit' => array('input' => array('MortageContractID', 'AccountID'), 'output' => array('StockID', 'Quantity', 'Symbol', 'ParValue')), 'listStockSupplement' => array('input' => array('TimeZone'), 'output' => array('StockSupplementID', 'MortageContractID', 'TotalMoney', 'SupplementDate', 'Note', 'IsConfirmed', 'lstMoneyDown', 'lstMortageContractDetailID', 'BankID', 'ContractNo', 'AccountID', 'ContractValue', 'BankName', 'AccountNo', 'InvestorID', 'FullName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listStockSupplementWithFilter' => array('input' => array('Condition', 'TimeZone'), 'output' => array('StockSupplementID', 'MortageContractID', 'TotalMoney', 'SupplementDate', 'Note', 'IsConfirmed', 'lstMoneyDown', 'lstMortageContractDetailID', 'BankID', 'ContractNo', 'AccountID', 'ContractValue', 'BankName', 'AccountNo', 'InvestorID', 'FullName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listMoneySupplement' => array('input' => array('TimeZone'), 'output' => array('MoneySupplementID', 'MortageContractID', 'AmountMoney', 'SupplementDate', 'lstMoneyDown', 'lstMortageContractDetailID', 'Note', 'IsConfirmed', 'ContractNo', 'BankID', 'AccountID', 'ContractValue', 'BankName', 'AccountNo', 'InvestorID', 'FullName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listMoneySupplementWithFilter' => array('input' => array('Condition', 'TimeZone'), 'output' => array('MoneySupplementID', 'MortageContractID', 'AmountMoney', 'SupplementDate', 'lstMoneyDown', 'lstMortageContractDetailID', 'Note', 'IsConfirmed', 'ContractNo', 'BankID', 'AccountID', 'ContractValue', 'BankName', 'AccountNo', 'InvestorID', 'FullName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listStockAndMoneySupplement' => array('input' => array('TimeZone'), 'output' => array('MortageContractID', 'MoneySupplement', 'SupplementDate', 'lstMoneyDown', 'lstMortageContractDetailID', 'Note', 'IsConfirmed', 'StockSupplementMoney', 'ContractNo', 'BankID', 'AccountID', 'BankName', 'AccountNo', 'InvestorID', 'FullName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listStockAndMoneySupplementWithFilter' => array('input' => array('Condition', 'TimeZone'), 'output' => array('MortageContractID', 'MoneySupplement', 'SupplementDate', 'lstMoneyDown', 'lstMortageContractDetailID', 'Note', 'IsConfirmed', 'StockSupplementMoney', 'ContractNo', 'BankID', 'AccountID', 'BankName', 'AccountNo', 'InvestorID', 'FullName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'getMortageContractDetails' => array('input' => array('MortageContractID'), 'output' => array('MortageContractDetailID', 'StockID', 'Quantity', 'PercentRate', 'MarketPrice', 'LoanMoney', 'Symbol', 'MoneyDown')), 'getStockSupplementDetails' => array('input' => array('StockSupplementID'), 'output' => array('StockSupplementDetailID', 'StockID', 'Quantity', 'PercentRate', 'MarketPrice', 'LoanMoney', 'Symbol')), 'deleteMortageContract' => array('input' => array('MortageContractID', 'UpdatedBy'), 'output' => array()), 'deleteUnPaidMortageContract' => array('input' => array('MortageContractID', 'UpdatedBy'), 'output' => array()), 'deleteStockSupplement' => array('input' => array('StockSupplementID', 'UpdatedBy'), 'output' => array()), 'deleteMoneySupplement' => array('input' => array('MoneySupplementID', 'UpdatedBy'), 'output' => array()), 'checkContractNo' => array('input' => array('ContractNo'), 'output' => array('MortageContractID')), 'updateNormalWhenMortage' => array('input' => array('AccountNo', 'Symbol', 'Quantity', 'TradingDate', 'UpdatedBy'), 'output' => array()), 'insertMortageWithoutConfirmed' => array('input' => array('AccountNo', 'Symbol', 'Quantity', 'TradingDate', 'CreatedBy', 'BankID'), 'output' => array('ID')), 'updateMortageWithoutConfirmed' => array('input' => array('MortageHistoryID', 'Quantity', 'UpdatedBy', 'BankID'), 'output' => array()), 'deleteMortageWithoutConfirmed' => array('input' => array('MortageHistoryID', 'UpdatedBy'), 'output' => array()), 'getMortageHistoryList' => array('input' => array('AccountNo', 'FromDate', 'ToDate', 'IsConfirmed'), 'output' => array('ID', 'AccountNo', 'Symbol', 'Quantity', 'MortageDate', 'IsConfirmed', 'ShortName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'BankID', 'StockExchangeID')), 'confirmMortageHistory' => array('input' => array('MortageHistoryID', 'UpdatedBy'), 'output' => array()), 'confirmMortageHistory' => array('input' => array('MortageHistoryID', 'UpdatedBy'), 'output' => array()), 'NewInsertMortageContract' => array('input' => array('ContractNo', 'AccountNo', 'Amount', 'PercentRate', 'BankID', 'MortageDate', 'Note', 'CreatedBy', 'EndDate'), 'output' => array('ID')), 'NewUpdateMortageContract' => array('input' => array('ID', 'ContractNo', 'Amount', 'PercentRate', 'BankID', 'MortageDate', 'Note', 'UpdatedBy', 'EndDate'), 'output' => array()), 'NewDeleteMortageContract' => array('input' => array('MortageContractID', 'UpdatedBy'), 'output' => array()), 'NewInsertMortageDetailWithoutConfirmed' => array('input' => array('MortageID', 'AccountNo', 'Symbol', 'Quantity', 'TradingDate', 'CreatedBy', 'Note', 'Price'), 'output' => array('ID')), 'NewUpdateMortageDetailWithoutConfirmed' => array('input' => array('MortageDeatailID', 'Quantity', 'UpdatedBy', 'Note', 'Price'), 'output' => array()), 'NewDeleteMortageDetailWithoutConfirmed' => array('input' => array('MortageContractID', 'UpdatedBy'), 'output' => array()), 'NewConfirmMortage' => array('input' => array('MortageContractID', 'UpdatedBy'), 'output' => array()), 'NewGetMortageList' => array('input' => array('FromDate', 'ToDate', 'AccountNo', 'ContractNo', 'IsConfirmed', 'CreatedBy'), 'output' => array('ID', 'ContractNo', 'AccountID', 'AccountNo', 'FullName', 'Amount', 'PercentRate', 'BankID', 'ShortName', 'MortageDate', 'Note', 'IsConfirmed', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'ReleaseDate', 'EndDate')), 'NewGetMortageDetailList' => array('input' => array('MortageID'), 'output' => array('ID', 'StockID', 'Symbol', 'Quantity', 'DetailDate', 'Note', 'IsConfirmed', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'Price')), 'NewConfirmMortageDetail' => array('input' => array('MortageDetailID', 'UpdatedBy'), 'output' => array()), 'NewGetMortageWithConditionList' => array('input' => array('WhereClause', 'TimeZone'), 'output' => array('ID', 'ContractNo', 'AccountID', 'AccountNo', 'FullName', 'Amount', 'PercentRate', 'BankID', 'ShortName', 'MortageDate', 'Note', 'IsConfirmed', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'ReleaseDate', 'EndDate')), 'getMortageDetailQuantityWithoutConfirmed' => array('input' => array('AccountID', 'StockID'), 'output' => array('Quantity')), 'getTotalQuantityCanBeMortaged' => array('input' => array('AccountID', 'StockID', 'TradingDate'), 'output' => array('Quantity')), 'getAmountCollect' => array('input' => array('ContractNo'), 'output' => array('MortageID', 'Amount', 'AmountCollect')), 'getMortageInfo' => array('input' => array('ContractNo'), 'output' => array('MortageID', 'ContractNo', 'AccountNo', 'AccountID', 'MortageDate', 'ReleaseDate', 'EndDate', 'PercentRate', 'Amount', 'BankID', 'ShortName', 'Note', 'AmountCollect')), 'insertDisbursement' => array('input' => array('AccountID', 'Amount', 'Note', 'CreatedBy', 'TypeID', 'BankID'), 'output' => array('ID')), 'confirmDisbursement' => array('input' => array('DisbursementID', 'AccountNo', 'Amount', 'Note', 'UpdatedBy', 'BankID'), 'output' => array()), 'confirmDisbursementForOddStock' => array('input' => array('DisbursementID', 'AccountNo', 'Amount', 'Note', 'UpdatedBy', 'BankID'), 'output' => array()), 'getDisbursement' => array('input' => array('AccountNo', 'CreatedBy', 'FromDate', 'ToDate', 'BankID'), 'output' => array('ID', 'AccountNo', 'Amount', 'Note', 'IsExec', 'IsBravo', 'CreatedDate', 'CreatedBy', 'TypeID', 'FullName', 'BankID', 'BankName')), 'deleteDisbursement' => array('input' => array('DisbursementID', 'UpdatedBy'), 'output' => array()), 'InsertExtraCollectDisbursement' => array('input' => array('AccountID', 'Amount', 'BankID', 'TradingDate', 'Note', 'TranTypeID', 'CreatedBy'), 'output' => array('ID')), 'DeleteExtraCollectDisbursement' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'GetListExtraCollectDisbursement' => array('input' => array('FromDate', 'ToDate', 'TranTypeID', 'IsConfirmed', 'AccountNo', 'BankID'), 'output' => array('ID', 'AccountID', 'AccountNo', 'FullName', 'Amount', 'BankAccount', 'BankID', 'ShortName', 'TradingDate', 'Note', 'TranTypeID', 'IsConfirmed', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'ConfirmExtraCollectDisbursement' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()));
     parent::__construct($arr);
 }

 function CEmployee($check_ip)
 {
     //initialize MDB2
     $this->_MDB2 = initDB();
     $this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = $check_ip;
     $this->class_name = get_class($this);
     $this->items = array();
     $arr = array('listGroups' => array('input' => array('TimeZone'), 'output' => array('ID', 'GroupName', 'Description', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listFilterGroups' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'GroupName', 'Description', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'deleteGroup' => array('input' => array('GroupID', 'UpdatedBy'), 'output' => array()), 'insertGroup' => array('input' => array('GroupName', 'Description', 'CreatedBy'), 'output' => array('ID')), 'updateGroup' => array('input' => array('GroupID', 'GroupName', 'Description', 'UpdatedBy'), 'output' => array()), 'insertEmployeeGroup' => array('input' => array('EmployeeID', 'GroupID', 'CreatedBy'), 'output' => array('ID')), 'deleteEmployeeGroup' => array('input' => array('EmployeeID', 'GroupID', 'UpdatedBy'), 'output' => array()), 'listEmployeesInGroup' => array('input' => array('GroupID', 'TimeZone'), 'output' => array('UserName', 'EmployeeID')), 'listEmployeesNotInGroup' => array('input' => array('GroupID', 'TimeZone'), 'output' => array('UserName', 'EmployeeID')), 'insertGroupFunction' => array('input' => array('FunctionID', 'GroupID', 'CreatedBy'), 'output' => array('ID')), 'deleteGroupFunction' => array('input' => array('GroupID'), 'output' => array()), 'listFunctionsInGroup' => array('input' => array('GroupID', 'TimeZone'), 'output' => array('FunctionID', 'FunctionName', 'ParentID')), 'listFunctionsNotInGroup' => array('input' => array('GroupID', 'TimeZone'), 'output' => array('FunctionID', 'FunctionName')), 'listChildFunctions' => array('input' => array('FunctionID', 'TimeZone'), 'output' => array('FunctionID', 'FunctionName', 'Description')), 'listFunctions' => array('input' => array('TimeZone'), 'output' => array('FunctionID', 'FunctionName', 'Description')), 'listEmployees' => array('input' => array('TimeZone'), 'output' => array('ID', 'UserName', 'PassWord', 'FirstName', 'LastName', 'Phone', 'CardNo', 'CardNoDate', 'CardNoIssuer', 'ResidentAddress', 'Ethnic', 'BankAccount', 'BankName', 'DepartmentName', 'ContactAddress', 'IsActive', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listFilterEmployees' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'UserName', 'PassWord', 'FirstName', 'LastName', 'Phone', 'CardNo', 'CardNoDate', 'CardNoIssuer', 'ResidentAddress', 'Ethnic', 'BankAccount', 'BankName', 'DepartmentName', 'ContactAddress', 'IsActive', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'deleteEmployee' => array('input' => array('EmployeeID', 'UpdatedBy'), 'output' => array()), 'insertEmployee' => array('input' => array('UserName', 'PassWord', 'FirstName', 'LastName', 'Phone', 'CardNo', 'CardNoDate', 'CardNoIssuer', 'ResidentAddress', 'Ethnic', 'BankAccount', 'BankID', 'DepartmentID', 'ContactAddress', 'IsActive', 'CreatedBy'), 'output' => array('ID')), 'updateEmployee' => array('input' => array('EmployeeID', 'FirstName', 'LastName', 'Phone', 'CardNo', 'CardNoDate', 'CardNoIssuer', 'ResidentAddress', 'Ethnic', 'BankAccount', 'BankID', 'DepartmentID', 'ContactAddress', 'IsActive', 'UpdatedBy'), 'output' => array()), 'listGroupsContainEmployee' => array('input' => array('EmployeeID', 'TimeZone'), 'output' => array('GroupID', 'GroupName')), 'listGroupsNotContainEmployee' => array('input' => array('EmployeeID', 'TimeZone'), 'output' => array('GroupID', 'GroupName')), 'insertEmployeeFunction' => array('input' => array('EmployeeID', 'FunctionID', 'CreatedBy'), 'output' => array('ID')), 'deleteEmployeeFunction' => array('input' => array('EmployeeID'), 'output' => array()), 'listFunctionsBelongToEmployee' => array('input' => array('EmployeeID', 'TimeZone'), 'output' => array('FunctionID', 'FunctionName', 'ParentID')), 'listFunctionsNotBelongToEmployee' => array('input' => array('EmployeeID', 'TimeZone'), 'output' => array('FunctionID', 'FunctionName')), 'listAssignedFunctionsOfEmployee' => array('input' => array('EmployeeID', 'ParentID', 'TimeZone'), 'output' => array('FunctionID', 'FunctionName')), 'listAssignedParentFunction' => array('input' => array('EmployeeID'), 'output' => array('FunctionID', 'FunctionName')), 'login' => array('input' => array(), 'output' => array('ID', 'BranchID')), 'changePassword' => array('input' => array('UserName', 'OldPassword', 'NewPassword', 'UpdatedBy'), 'output' => array()), 'getBranchID' => array('input' => array('UserName'), 'output' => array('BranchID')), 'getFunctionWithParentID' => array('input' => array('ParentID', 'EmployeeID'), 'output' => array('ID', 'FunctionName')), 'getAllFunctionList' => array('input' => array(), 'output' => array('ID', 'FunctionName', 'ParentID', 'Description')), 'insertSetOfEmployeeFunction' => array('input' => array('EmployeeID', 'SetOfFunctionID', 'CreatedBy'), 'output' => array('InsertedEmployeeFunctionID', 'SuccessdedFunctionID', 'FailedFunctionID')), 'insertSetOfEmployeeGroup' => array('input' => array('EmployeeID', 'SetOfGroupID', 'CreatedBy'), 'output' => array('InsertedEmployeeGroupID', 'SuccessdedGroupID', 'FailedGroupID')), 'deleteSetOfEmployeeGroup' => array('input' => array('EmployeeID', 'SetOfGroupID', 'UpdatedBy'), 'output' => array('SuccessdedGroupID', 'FailedGroupID')), 'insertSetOfGroupFunction' => array('input' => array('GroupID', 'SetOfFunctionID', 'CreatedBy'), 'output' => array('InsertedGroupFunctionID', 'SuccessdedFunctionID', 'FailedFunctionID')), 'deleteSetOfFunction4Employee' => array('input' => array('EmployeeID', 'SetOfFunctionID', 'UpdatedBy'), 'output' => array('SuccessdedFunctionID', 'FailedFunctionID')), 'deleteSetOfFunction4Group' => array('input' => array('GroupID', 'SetOfFunctionID', 'UpdatedBy'), 'output' => array('SuccessdedFunctionID', 'FailedFunctionID')), 'insertSetOfEmployee4Group' => array('input' => array('GroupID', 'SetOfEmployeeID', 'CreatedBy'), 'output' => array('InsertedEmployeeGroupID', 'SuccessdedEmployeeID', 'FailedEmployeeID')), 'deleteSetOfEmployee4Group' => array('input' => array('GroupID', 'SetOfEmployeeID', 'UpdatedBy'), 'output' => array('SuccessdedEmployeeID', 'FailedEmployeeID')));
     parent::__construct($arr);
 }

 function __construct($check_ip)
 {
     //initialize MDB2
     $this->_MDB2 = initDB();
     $this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = $check_ip;
     $this->class_name = get_class($this);
     $this->items = array();
     $arr = array('insertOrderTemp' => array('input' => array('OrderNumber', 'AccountNo', 'Symbol', 'OrderQuantity', 'OrderPrice', 'OrderStyleID', 'MatchedQuantity', 'OrderSideName', 'StockExchangeID', 'OrderDate', 'CreatedBy'), 'output' => array('OrderTempID')), 'insertStockDetail' => array('input' => array('ConfirmNo', 'OrderNumber', 'AccountID', 'StockID', 'MatchedQuantity', 'MatchedPrice', 'OrderSideID', 'MatchedSession', 'TradingDate', 'CreatedBy'), 'output' => array('StockDetailID')), 'insertSellingOrderForTransactionExecute' => array('input' => array('OrderNumber', 'AccountNo', 'Symbol', 'OrderQuantity', 'OrderPrice', 'Session', 'OrderStyleID', 'Note', 'StockExchangeID', 'OrderDate', 'CreatedBy'), 'output' => array('ID')), 'insertBuyingOrderForTransactionExecute' => array('input' => array('OrderNumber', 'AccountNo', 'Symbol', 'OrderQuantity', 'OrderPrice', 'Session', 'OrderStyleID', 'Note', 'StockExchangeID', 'OrderDate', 'CreatedBy'), 'output' => array('ID')), 'insertBuyingOrderForTransactionExecuteWithoutBlockingMoney' => array('input' => array('OrderNumber', 'AccountNo', 'Symbol', 'OrderQuantity', 'OrderPrice', 'Session', 'OrderStyleID', 'Note', 'StockExchangeID', 'OrderDate', 'CreatedBy'), 'output' => array('ID')), 'insertBuyingOrderForTransactionExecuteWithReservingMoney' => array('input' => array('OrderNumber', 'AccountNo', 'Symbol', 'OrderQuantity', 'OrderPrice', 'Session', 'OrderStyleID', 'Note', 'StockExchangeID', 'OrderDate', 'CreatedBy'), 'output' => array('ID')), 'insertStockDetailOnline' => array('input' => array('ConfirmNo', 'OrderNumber', 'MatchedQuantity', 'MatchedPrice', 'MatchedSession', 'TradingDate', 'CreatedBy'), 'output' => array('ID')), 'insertStockDetailForExecuteTransaction' => array('input' => array('ConfirmNo', 'OrderNumber', 'MatchedQuantity', 'MatchedPrice', 'MatchedSession', 'TradingDate', 'CreatedBy'), 'output' => array('ID')), 'insertStockDetailForKLDK' => array('input' => array('ConfirmNo', 'OrderNumber', 'MatchedQuantity', 'MatchedPrice', 'MatchedSession', 'TradingDate', 'CreatedBy'), 'output' => array('ID')), 'updateOrderTemp' => array('input' => array('ID', 'AccountNo', 'OrderQuantity', 'OrderStyleID', 'Price'), 'output' => array()), 'executeStockOfBuyingDeal' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'executeStockOfSellingDeal' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'executeMoneyForSellingTransaction' => array('input' => array('TradingDate', 'UpdatedBy'), 'output' => array()), 'executeMoneyForBuyingTransaction' => array('input' => array('TradingDate', 'UpdatedBy'), 'output' => array()), 'executeMoneyForBuyingTransactionOfAccount' => array('input' => array('AccountID', 'AmountMoney', 'TradingDate', 'Updatedby'), 'output' => array()), 'executeEndTransaction' => array('input' => array('TradingDate'), 'output' => array()), 'confirmMatchedAgencyFee' => array('input' => array('TradingDate'), 'output' => array()), 'updateStockDetail' => array('input' => array('ID', 'OrderNumber', 'AccountNo', 'MatchedQuantity', 'UpdatedBy'), 'output' => array()), 'editBuyingOrderWhenExecTransaction' => array('input' => array('OrderID', 'OrderQuantity', 'OrderPrice', 'OrderStyleID', 'AccountNo', 'UpdatedBy'), 'output' => array()), 'editSellingOrderWhenExecTransaction' => array('input' => array('OrderID', 'OrderQuantity', 'OrderPrice', 'OrderStyleID', 'UpdatedBy'), 'output' => array()), 'listWarningOrderTemp' => array('input' => array('TradingDate', 'StockExchangeID'), 'output' => array('OrderTempID', 'OrderNumber', 'AccountNo', 'OrderSide', 'Symbol', 'OrderQuantity', 'OrderPrice', 'OrderStyleName', 'OrderDate', 'ExchangeName', 'StockExchangeID', 'OrderSideID', 'OrderStyleID', 'MatchedQuantity', 'Value')), 'getPrivateStockDetailWithoutConfirmList' => array('input' => array('OrderNumber', 'TradingDate'), 'output' => array('ID', 'ConfirmNo', 'OrderNumber', 'AccountNo', 'OrderSide', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'Note', 'TradingDate', 'StockExchangeID', 'OrderSideID')), 'getStockDetailWithoutConfirmList' => array('input' => array('OrderDate'), 'output' => array('ID', 'ConfirmNo', 'OrderNumber', 'AccountNo', 'OrderSide', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'TradingDate', 'StockExchangeID', 'OrderSideID', 'Note')), 'getOrderWithoutOrderNumberList' => array('input' => array('OrderDate', 'StockExchangeID'), 'output' => array('ID', 'OrderNumber', 'AccountNo', 'OrderSide', 'Symbol', 'OrderQuantity', 'OrderPrice', 'Session', 'StatusName', 'OrderStyleName', 'FromName', 'StockExchangeID')), 'getStockDetailWithConfirmList' => array('input' => array('OrderDate'), 'output' => array('ID', 'ConfirmNo', 'OrderNumber', 'OrderSide', 'AccountNo', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'MatchedSession', 'MatchedAgencyFee', 'Note', 'StockExchangeID')), 'getFullStockDetailWithConfirmList' => array('input' => array('OrderDate'), 'output' => array('ID', 'ConfirmNo', 'OrderNumber', 'OrderSide', 'AccountNo', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'MatchedSession', 'MatchedAgencyFee', 'MatchedValue', 'Commission', 'LogMoney', 'TMoney', 'StockExchangeID')), 'getReportStockList' => array('input' => array('TradingDate'), 'output' => array('Symbol', 'Mua', 'Ban')), 'getStockDetailWithoutExecAgencyFeeList' => array('input' => array('TradingDate'), 'output' => array('ID', 'ConfirmNo', 'OrderNumber', 'AccountNo', 'OrderSide', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'Note', 'TradingDate', 'StockExchangeID', 'OrderSideID')), 'getStockDetailAfterExecMoney' => array('input' => array('TradingDate'), 'output' => array('ID', 'ConfirmNo', 'OrderNumber', 'OrderSide', 'AccountNo', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'MatchedSession', 'MatchedAgencyFee', 'Note', 'StockExchangeID')), 'checkOrderIsWarningOrNormal' => array('input' => array('OrderTempID'), 'output' => array()), 'getNextOrderNumber' => array('input' => array('TradingDate'), 'output' => array('OrderNumber')), 'getNextConfirmNo' => array('input' => array('TradingDate'), 'output' => array('ConfirmNo')), 'getAccountWithBuyingTransactionList' => array('input' => array('TradingDate'), 'output' => array('AccountID', 'AccountNo', 'AmountMoney')), 'getAuctionForXML' => array('input' => array('OrderDate', 'BankID'), 'output' => array('FileName')), 'getAllSellForXML' => array('input' => array('OrderDate', 'BankID'), 'output' => array('FileName')), 'getAllCancelBidForXML' => array('input' => array('OrderDate', 'BankID'), 'output' => array('FileName')), 'getDABLockMoneyFile' => array('input' => array(), 'output' => array('FileContent')), 'DABgetListOrderInfo' => array('input' => array('OrderDate'), 'output' => array('OrderID', 'AccountNo', 'Value')), 'DABgetResultFile' => array('input' => array('FileName'), 'output' => array('FileContent')), 'CheckTransaction' => array('input' => array(), 'output' => array()), 'getBuyInfo' => array('input' => array('OrderDate'), 'output' => array("AccountNo", "Amount")), 'getBuyInfoForChecking' => array('input' => array(), 'output' => array("AccountNo", "LogMoney")), 'getSellInfo' => array('input' => array('OrderDate'), 'output' => array("AccountNo", "Amount")), 'getSellInfoForChecking' => array('input' => array(), 'output' => array("AccountNo", "TMoney")), 'getBuyInfoForBravo' => array('input' => array('OrderDate'), 'output' => array("AccountNo", "Amount", "Fee", "BranchName")), 'getSellInfoForBravo' => array('input' => array('OrderDate'), 'output' => array("AccountNo", "Amount", "Fee", "BranchName")), 'getBuyInfoForBravoChecking' => array('input' => array(), 'output' => array("AccountNo", "LogMoney")), 'getSellInfoForBravoChecking' => array('input' => array(), 'output' => array("AccountNo", "TMoney")), 'editMoney' => array('input' => array('OrderID', 'NewValue'), 'output' => array()), 'cutMoney' => array('input' => array('OrderID'), 'output' => array()), 'insertMissingDeal' => array('input' => array('OrderNumber', 'AccountNo', 'Symbol', 'StockExchangeID', 'Quantity', 'Price', 'OrderSideID', 'Session', 'TradingDate', 'Note', 'CreatedBy'), 'output' => array('OrderID')), 'getOrderListToEditOrAuction' => array('input' => array('OrderID', 'AccountNo'), 'output' => array('ID', 'AccountNo', 'Symbol', 'OrderQuantity', 'OrderPrice', 'Note', 'OrderSide')), 'getMoneyBeforeCutting' => array('input' => array('OrderID'), 'output' => array('TotalAmount')), 'calculateAveragePrices' => array('input' => array(), 'output' => array()), 'getOrderTempMissingList' => array('input' => array('OrdeDate', 'IsValid', 'StockExchangeID'), 'output' => array('OrderID', 'OrderNumber', 'Symbol', 'AccountNo', 'OrderQuantity', 'OrderPrice', 'OrderSideName', 'OrderStyleID', 'OrderStyleName', 'StockExchangeID', 'StockExchange', 'OrderMissingStatus')), 'updateOrderTempMissing' => array('input' => array('OrderID', 'AccountNo'), 'output' => array()), 'updateOrderTempMissingIsValidField' => array('input' => array('OrderID'), 'output' => array()), 'changeOrderStatusToFailed' => array('input' => array('OrderID', 'CreatedBy'), 'output' => array()), 'deleteDeal' => array('input' => array('ID'), 'output' => array()), 'editDeal' => array('input' => array('ID', 'AccountNo', 'Quantity', 'CreatedBy'), 'output' => array()), 'getListStockDetailForExecTrans' => array('input' => array('TradingDate', 'AccountNo', 'StockExchangeID'), 'output' => array('ID', 'OrderNumber', 'AccountNo', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'OrderSideName', 'MatchedSession', 'MatchedAgencyFee', 'IsExist')), 'getStockBalanceListForTTBT' => array('input' => array('TradingDate', 'AccountNo'), 'output' => array('AccountNo', 'Symbol', 'T3Quantity', 'AccountID', 'StockID')), 'executeStockTTBTPrivateAccount' => array('input' => array('AccountID', 'StockID', 'T3Quantity', 'TradingDate'), 'output' => array('ID')), 'getAdditionCommission' => array('input' => array('TradingDate', 'UpdatedBy'), 'output' => array()), 'insertAdditionallyCommission' => array('input' => array('TradingDate', 'MinCommission', 'CreatedBy'), 'output' => array()), 'lockMoney' => array('input' => array('OrderID', 'Amount', 'AccountNo'), 'output' => array()), 'getMatchedOrderUnLocked' => array('input' => array(), 'output' => array('OrderID', 'AccountNo', 'Symbol')), 'getInvalidBankIDOfMatchedOrder' => array('input' => array(), 'output' => array('OrderID', 'AccountNo', 'Symbol')), 'getStockDetailWithoutConfirmForHOSE' => array('input' => array('TradingDate', 'TFlag'), 'output' => array('ID', 'OrderNumber', 'AccountNo', 'OrderSideName', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'Note', 'TradingDate', 'StockExchangeID', 'OrderSideID', 'OrderID', 'TFlag')), 'updateTFlagForHOSE' => array('input' => array('OrderID', 'TFlag', 'UpdatedBy'), 'output' => array()), 'updateTFlagForHNX' => array('input' => array('OrderID', 'TFlag', 'UpdatedBy'), 'output' => array()), 'getStockDetailWithoutConfirmForHNX' => array('input' => array('TradingDate', 'TFlag'), 'output' => array('ID', 'OrderNumber', 'AccountNo', 'OrderSideName', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'Note', 'TradingDate', 'StockExchangeID', 'OrderSideID', 'OrderID', 'TFlag')), 'getMatchedQuantityGreaterThanOrderQuantity' => array('input' => array(), 'output' => array('AccountNo', 'Symbol', 'OrderID', 'MatchedQuantity', 'OrderQuantity')), 'confirmBuyOrderForVirtualBank' => array('input' => array('TradingDate', 'BankID'), 'output' => array()), 'cancelBuyOrderForVirtualBank' => array('input' => array('TradingDate', 'BankID'), 'output' => array()), 'getListMatchNotCutMoney' => array('input' => array('TradingDate', 'BankID', 'AccountNo'), 'output' => array('AccountNo', 'LockID', 'AccountID', 'OrderID', 'Symbol', 'MatchedQuantity', 'Value', 'Commission')), 'getList4Unlock' => array('input' => array('TradingDate', 'BankID', 'AccountNo'), 'output' => array('AccountNo', 'AccountID', 'LockID', 'BidAmount', 'OrderID', 'OrderNumber', 'OrderPrice', 'OrderQuantity', 'Symbol', 'StatusName')), 'unLockForVirtualBank' => array('input' => array('AccountID', 'LockID', 'BankID', 'LockAmount', 'UpdatedBy'), 'output' => array()), 'checkAuctionForVirtualBank' => array('input' => array('TradingDate', 'BankID'), 'output' => array('OrderID', 'AccountNo', 'Symbol', 'Amount', 'BidAmount', 'Delta')), 'getAuctionForNVB' => array('input' => array('OrderDate'), 'output' => array()));
     parent::__construct($arr);
 }

 function CBravoMoney($check_ip)
 {
     //initialize _MDB2
     $this->_MDB2 = initDB();
     $this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = $check_ip;
     //$this->_TIME_ZONE = get_timezon();
     $this->items = array();
     $this->class_name = get_class($this);
     $arr = array('SellingValueAndFeeListForBravo' => array('input' => array('TradingDate'), 'output' => array('AccountNo', 'Amount', 'Fee', 'Bank', 'BravoError', 'Tax')), 'SellingValueAndFeeListForBravoTDate' => array('input' => array('TradingDate'), 'output' => array('AccountNo', 'Amount', 'Fee', 'Bank', 'BravoError', 'Tax')), 'BuyingValueAndFeeListForBravo' => array('input' => array('TradingDate'), 'output' => array('AccountNo', 'Amount', 'Fee', 'Bank', 'BravoError')), 'PaidAdvanceForBravo' => array('input' => array('TradingDate'), 'output' => array('AccountNo', 'Amount', 'Fee', 'Bank', 'BravoError', 'BankID', 'OrderBankBravoCode')), 'CloseBravoAccount' => array('input' => array('AccountNo'), 'output' => array()));
     parent::__construct($arr);
 }

 function CBank($check_ip)
 {
     //initialize _MDB2
     $this->_MDB2 = initDB();
     $this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = $check_ip;
     //$this->_TIME_ZONE = get_timezon();
     $this->items = array();
     $this->class_name = get_class($this);
     $arr = array('listBank' => array('input' => array('TimeZone'), 'output' => array('ID', 'BankName', 'ShortName', 'Phone', 'BankAddress', 'Fax', 'Email', 'MaximumLoanMoney', 'MinimumLoanMoney', 'MaximumPayMoney', 'MinimumPayMoney', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listBankWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'BankName', 'ShortName', 'Phone', 'BankAddress', 'Fax', 'Email', 'MaximumLoanMoney', 'MinimumLoanMoney', 'MaximumPayMoney', 'MinimumPayMoney', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'addBank' => array('input' => array('BankName', 'ShortName', 'Phone', 'BankAddress', 'Fax', 'Email', 'MaximumLoanMoney', 'MinimumLoanMoney', 'MaximumPayMoney', 'MinimumPayMoney', 'CreatedBy'), 'output' => array('ID')), 'updateBank' => array('input' => array('ID', 'BankName', 'ShortName', 'Phone', 'BankAddress', 'Fax', 'Email', 'MaximumLoanMoney', 'MinimumLoanMoney', 'MaximumPayMoney', 'MinimumPayMoney', 'UpdatedBy'), 'output' => array()), 'deleteBank' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'listBankLoan' => array('input' => array('TimeZone'), 'output' => array('ID', 'BankID', 'BankName', 'LoanPeriod', 'LoanInterestRate', 'OverdueInterestRate', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listBankLoanWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'BankID', 'BankName', 'LoanPeriod', 'LoanInterestRate', 'OverdueInterestRate', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'addBankLoan' => array('input' => array('BankID', 'LoanPeriod', 'LoanInterestRate', 'OverdueInterestRate', 'CreatedBy'), 'output' => array('ID')), 'updateBankLoan' => array('input' => array('ID', 'BankID', 'LoanPeriod', 'LoanInterestRate', 'OverdueInterestRate', 'UpdatedBy'), 'output' => array()), 'deleteBankLoan' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'listRate' => array('input' => array('TimeZone'), 'output' => array('ID', 'BankID', 'BankName', 'FromValue', 'ToValue', 'PercentRate', 'UseMarketPrice', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listRateWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'BankID', 'BankName', 'FromValue', 'ToValue', 'PercentRate', 'UseMarketPrice', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'addRate' => array('input' => array('BankID', 'FromValue', 'ToValue', 'PercentRate', 'UseMarketPrice', 'CreatedBy'), 'output' => array('ID')), 'updateRate' => array('input' => array('ID', 'BankID', 'FromValue', 'ToValue', 'PercentRate', 'UseMarketPrice', 'UpdatedBy'), 'output' => array()), 'deleteRate' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'listSpecialRate' => array('input' => array('TimeZone'), 'output' => array('ID', 'BankID', 'BankName', 'StockID', 'StockName', 'FromValue', 'ToValue', 'PercentRate', 'UseMarketPrice', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listSpecialRateWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'BankID', 'BankName', 'StockID', 'StockName', 'FromValue', 'ToValue', 'PercentRate', 'UseMarketPrice', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'addSpecialRate' => array('input' => array('BankID', 'StockID', 'FromValue', 'ToValue', 'PercentRate', 'UseMarketPrice', 'CreatedBy'), 'output' => array('ID')), 'updateSpecialRate' => array('input' => array('ID', 'BankID', 'StockID', 'FromValue', 'ToValue', 'PercentRate', 'UseMarketPrice', 'UpdatedBy'), 'output' => array()), 'deleteSpecialRate' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'getPercentRate' => array('input' => array('BankID', 'StockID', 'MarketPrice'), 'output' => array('PercentRate', 'UseMarketPrice')), 'getTransactionTypeList' => array('input' => array(), 'output' => array('ID', 'Name', 'Type', 'Description')), 'getTransactionList' => array('input' => array('TimeZone', 'WhereClause'), 'output' => array('ID', 'AccountID', 'AccountNo', 'InvestorName', 'Amount', 'IsConfirmed', 'TransactionStatus', 'TransTypeName', 'TransTypeID', 'BankID', 'BankName', 'TradingDate', 'CreatedBy', 'UpdatedBy', 'TransactionBankID', 'TransactionBankName', 'CreatedDate', 'UpdatedDate', 'Note', 'TransBankBravoCode')), 'getAccountBankInfo' => array('input' => array('AccountID', 'BankID'), 'output' => array('AccountID', 'BankID', 'BankAccount', 'Amount', 'LockAmount', 'UsableAmount')), 'insertDeposit' => array('input' => array('AccountID', 'BankID', 'TransactionBankID', 'Amount', 'DepositDate', 'Note', 'CreatedBy'), 'output' => array('ID')), 'deleteDeposit' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'cofirmDeposit' => array('input' => array('ID', 'UpdatedBy', 'TransactionBankID', 'TransactionBankBravoCode', 'AccountNo', 'Amount', 'Note'), 'output' => array()), 'insertWithdrawal' => array('input' => array('AccountID', 'BankID', 'TransactionBankID', 'Amount', 'WithdrawalDate', 'Note', 'CreatedBy'), 'output' => array('ID')), 'deleteWithdrawal' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'cofirmWithdrawal' => array('input' => array('ID', 'UpdatedBy', 'TransactionBankID', 'TransactionBankBravoCode', 'AccountNo', 'Amount', 'Note'), 'output' => array()), 'getBankList' => array('input' => array(), 'output' => array('BankID', 'BankName', 'ShortName')), 'getVirtualBankOfAccount' => array('input' => array('AccountNo'), 'output' => array('AccountID', 'AccountNo', 'BankID', 'BankName', 'BankShortName')), 'getBankListForWD' => array('input' => array(), 'output' => array('BankID', 'BankName', 'ShortName')), 'getBankListByType' => array('input' => array('Type'), 'output' => array('BankID', 'BankName', 'ShortName')), 'getBankListByType4Account' => array('input' => array('Type', 'AccountID '), 'output' => array('BankID', 'BankAccount', 'BankName', 'ShortName')), 'insertInternalTransfer' => array('input' => array('FromAccountID', 'ToAccountID', 'BankID', 'Amount', 'TransactionDate', 'Note', 'CreatedBy'), 'output' => array('ID')), 'deleteInternalTransfer' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'confirmInternalTransfer' => array('input' => array('ID', 'UpdatedBy', 'FromAccountNo', 'ToAccountNo', 'Amount'), 'output' => array()), 'getListInternalTransfer' => array('input' => array('TimeZone', 'WhereClause'), 'output' => array('ID', 'FromAccountID', 'FromAccountNo', 'FromInvestorName', 'ToAccountID', 'ToAccountNo', 'ToInvestorName', 'Amount', 'TransactionStatus', 'IsConfirmed', 'BankID', 'BankName', 'TradingDate', 'CreatedBy', 'UpdatedBy')), 'updateAllAdvRate' => array('input' => array('BankID', 'RateForBank', 'RateForEPS', 'MinAdvCommission'), 'output' => array('varError')), 'listAllAdvRate' => array('input' => array('BankID'), 'output' => array('BankID', 'BankName', 'ShortName', 'RateForBank', 'RateForEPS', 'MinAdvCommission')), 'ReportVirtualBank_ReportTransactionByAccount' => array('input' => array('BankID', 'AccountNo', 'FromDate', 'ToDate'), 'output' => array('TradingDate', 'TransName', 'Note', 'Amount', 'Type', 'TransactionBankName', 'ConfirmedDate', 'PrevBalance', 'CreatedBy', 'UpdatedBy', 'SortDate')), 'ReportVirtualBank_GetAccountBalanceByDate' => array('input' => array('BankID', 'AccountNo', 'FromDate', 'ToDate'), 'output' => array('PrevBalance', 'NextBalance', 'AccountNo', 'InvestorName')));
     parent::__construct($arr);
 }

 function CVCBBank($check_ip)
 {
     //initialize _MDB2
     $this->_MDB2 = initDB();
     //$this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = $check_ip;
     //$this->_TIME_ZONE = get_timezon();
     $this->items = array();
     $this->class_name = get_class($this);
     $arr = array('sellfile' => array('input' => array('TradingDate'), 'output' => array()), 'buyfile' => array('input' => array('TradingDate'), 'output' => array()), 'LogFile' => array('input' => array('Type'), 'output' => array('FileContent')), 'BuyAndVSDFeeFile' => array('input' => array('TradingDate'), 'output' => array()), 'GetVSDFeeResult' => array('input' => array(), 'output' => array('Refno', 'OrderID', 'UnitCode', 'AccountNo', 'Amount', 'ErrorCode', 'Note')), 'UpdateIsCollectedVSDFee' => array('input' => array(), 'output' => array('Refno', 'OrderID', 'UnitCode', 'AccountNo', 'Amount', 'VCBResult', 'Note', 'UpdateIsCollectedResult')));
     parent::__construct($arr);
 }

 function CPayment($check_ip)
 {
     //initialize _MDB2
     $this->_MDB2 = initDB();
     $this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = $check_ip;
     $this->_TIME_ZONE = get_timezon();
     $this->items = array();
     $this->class_name = get_class($this);
     $arr = array('updateNormalWhenPayment' => array('input' => array('AccountNo', 'Symbol', 'Quantity', 'TradingDate', 'UpdatedBy'), 'output' => array()), 'getSoldMortage' => array('input' => array('AccountNo', 'TradingDate'), 'output' => array('AccountNo', 'Symbol', 'Quantity', 'FullName')), 'insertPaymentWithoutConfirmed' => array('input' => array('AccountNo', 'Symbol', 'Quantity', 'TradingDate', 'CreatedBy', 'BankID'), 'output' => array('ID')), 'updatePaymentWithoutConfirmed' => array('input' => array('PaymentHistoryID', 'Quantity', 'UpdatedBy', 'BankID'), 'output' => array()), 'deletePaymentWithoutConfirmed' => array('input' => array('PaymentHistoryID', 'UpdatedBy'), 'output' => array()), 'getPaymentHistoryList' => array('input' => array('AccountNo', 'FromDate', 'ToDate', 'IsConfirmed'), 'output' => array('ID', 'AccountNo', 'Symbol', 'Quantity', 'PaymentDate', 'IsConfirmed', 'ShortName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'BankID', 'StockExchangeID')), 'confirmPaymentHistory' => array('input' => array('PaymentHistoryID', 'UpdatedBy'), 'output' => array()), 'insertCollectDebt' => array('input' => array('AccountNo', 'Payment', 'PaymentInterest', 'ContractNo', 'CreatedBy', 'BankID', 'ContractBankID', 'MortageID'), 'output' => array('ID')), 'updateCollectDebt' => array('input' => array('CollectDebtID', 'AccountNo', 'Payment', 'PaymentInterest', 'ContractNo', 'UpdatedBy', 'BankID', 'ContractBankID', 'MortageID'), 'output' => array()), 'deleteCollectDebt' => array('input' => array('CollectDebtID', 'UpdatedBy'), 'output' => array()), 'getCollectDebtList' => array('input' => array('AccountNo', 'ContractNo', 'FromDate', 'ToDate', 'IsBank'), 'output' => array('CollectDebtID', 'AccountNo', 'FullName', 'Payment', 'PaymentInterest', 'ContractNo', 'IsBank', 'IsBravo', 'BankAccount', 'BankName', 'BravoCode', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'BankID', 'ContractBankID', 'ShortName')), 'confirmCollectDebt' => array('input' => array('CollectDebtID', 'UpdatedBy'), 'output' => array()), 'NewInsertPaymentDetailWithoutConfirmed' => array('input' => array('MortageID', 'AccountNo', 'Symbol', 'Quantity', 'TradingDate', 'CreatedBy', 'Note'), 'output' => array('ID')), 'NewUpdatePaymentDetailWithoutConfirmed' => array('input' => array('PaymentDetailID', 'Quantity', 'UpdatedBy', 'Note'), 'output' => array()), 'NewDeletePaymentDetailWithoutConfirmed' => array('input' => array('PaymentDetailID', 'UpdatedBy'), 'output' => array()), 'NewGetPaymentDetailList' => array('input' => array('AccountNo', 'Symbol', 'FromDate', 'ToDate'), 'output' => array('ID', 'MortageID', 'AccountID', 'AccountNo', 'StockID', 'Symbol', 'Quantity', 'PaymentDate', 'Note', 'IsConfirmed', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'FullName')), 'NewConfirmPaymentDetail' => array('input' => array('PaymentDetailID', 'UpdatedBy'), 'output' => array()), 'NewGetPaymentDetailListWithCondition' => array('input' => array('WhereClause', 'TimeZone'), 'output' => array('ID', 'MortageID', 'AccountID', 'AccountNo', 'StockID', 'Symbol', 'Quantity', 'PaymentDate', 'Note', 'IsConfirmed', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'FullName')));
     parent::__construct($arr);
 }

 function CTradingRegister($check_ip)
 {
     //initialize _MDB2
     $this->_MDB2 = initDB();
     $this->_MDB2_WRITE = initWriteDB();
     $this->_ERROR_CODE = $check_ip;
     //$this->_TIME_ZONE = get_timezon();
     $this->items = array();
     $this->class_name = get_class($this);
     $arr = array('listTradingRegisterWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'AccountID', 'AccountNo', 'InvestorName', 'StockID', 'Symbol', 'Quantity', 'StockStatusID', 'StockStatusName', 'RegisterDate', 'Note', 'StockRegisterType', 'IsConfirmed', 'MobilePhone', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'StockExchangeID')), 'listAccountStock' => array('input' => array('AccountNo', 'StockID'), 'output' => array('InvestorName', 'InvestorCardNo', 'QuantityOfNormalStock', 'QuantityOfBlockedStock', 'QuantityOfNormalStockNotConfirm', 'QuantityOfBlockedStockNotConfirm')), 'listAccountStockW' => array('input' => array('AccountNo', 'StockID'), 'output' => array('InvestorName', 'InvestorCardNo', 'QuantityOfNormalStock', 'QuantityOfBlockedStock', 'QuantityOfNormalStockNotConfirmW', 'QuantityOfBlockedStockNotConfirmW')), 'addTradingRegister' => array('input' => array('AccountNo', 'StockID', 'Quantity', 'StockStatusID', 'RegisterDate', 'Note', 'StockRegisterType', 'CreatedBy', 'RegPrice'), 'output' => array('ID')), 'updateTradingRegister' => array('input' => array('ID', 'AccountNo', 'StockID', 'Quantity', 'Note', 'StockRegisterType', 'UpdatedBy'), 'output' => array()), 'approveTradingRegister' => array('input' => array('ID', 'StockRegisterType', 'StockTradingType', 'UpdatedBy', 'MobilePhone', 'AccountNo', 'StockSymbol', 'Quantity'), 'output' => array()), 'deleteTradingRegister' => array('input' => array('ID', 'StockRegisterType', 'UpdatedBy'), 'output' => array()), 'getStockQuantity' => array('input' => array('AccountNo', 'StockID'), 'output' => array('QuantityOfNormalStock', 'QuantityOfMortageStock', 'QuantityOfBlockedStock')), 'listAccountProfit' => array('input' => array(), 'output' => array('AccountID', 'AccountNo', 'InvestorName', 'Profit')), 'getLastProfitDate' => array('input' => array(), 'output' => array('ProfitDate')), 'approveAccountProfit' => array('input' => array('AccountNo', 'ApproveDate', 'Note', 'UpdatedBy'), 'output' => array('ID')), 'addProfitHistory' => array('input' => array('FromDate', 'ToDate', 'ApproveDate', 'Note', 'UpdatedBy'), 'output' => array('ID')), 'listProfitHistory' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'FromDate', 'ToDate', 'ProfitDate', 'Note', 'CreatedBy', 'CreatedDate')), 'listEventWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'StockID', 'Symbol', 'StockExchangeID', 'EventTypeID', 'EventTypeName', 'LastRegistrationDate', 'ExpireDate', 'BeginTranferDate', 'EndTranferDate', 'BeginRegisterDate', 'EndRegisterDate', 'Rate', 'Price', 'EventStatus', 'EventStatus1', 'IsRound1', 'IsRound', 'NumberTransfer', 'Note', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'UBCKDate')), 'listDividendPrivilegeWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'EventID', 'AccountID', 'AccountNo', 'InvestorName', 'StockID', 'Symbol', 'EventTypeID', 'EventTypeName', 'StockQtty', 'NormalPrivilegeQtty', 'IncrementStockQtty', 'LimitPrivilegeQtty', 'IsConfirmed1', 'IsConfirmed', 'MoneyDividend', 'RemainingStockDivident', 'RemainingMoneyByStockDivident', 'MobilePhone', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'BankID')), 'listEventDividendWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'StockID', 'Symbol', 'EventTypeID', 'EventTypeName', 'LastRegistrationDate', 'ExpireDate', 'BeginTranferDate', 'EndTranferDate', 'BeginRegisterDate', 'EndRegisterDate', 'Rate', 'Price', 'EventStatus', 'EventStatus1', 'IsRound1', 'IsRound', 'NumberTransfer', 'Note', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'UBCKDate')), 'listEventBuyingStockWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'StockID', 'Symbol', 'EventTypeID', 'EventTypeName', 'LastRegistrationDate', 'ExpireDate', 'BeginTranferDate', 'EndTranferDate', 'BeginRegisterDate', 'EndRegisterDate', 'Rate', 'Price', 'EventStatus', 'EventStatus1', 'IsRound1', 'IsRound', 'NumberTransfer', 'Note', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'UBCKDate')), 'listTransferPrivilegeWithFilter' => array('input' => array('Where', 'TimeZone'), 'output' => array('ID', 'EventID', 'AccountIDFrom', 'AccountNoFrom', 'InvestorNameFrom', 'AccountIDTo', 'AccountNoTo', 'InvestorNameTo', 'StockID', 'Symbol', 'EventID', 'EventTypeID', 'EventTypeName', 'PrivilegeQuantity', 'IsConfirmed1', 'IsConfirmed', 'Note', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'listEventByAccountNo' => array('input' => array('AccountNo', 'Where', 'TimeZone'), 'output' => array('ID', 'AccountID', 'AccountNo', 'InvestorName', 'StockID', 'Symbol', 'EventTypeID', 'EventTypeName', 'StockQuantity', 'UBCKDate', 'StockRegistration', 'LastRegistrationDate', 'ExpireDate', 'BeginTranferDate', 'EndTranferDate', 'BeginRegisterDate', 'EndRegisterDate', 'Rate', 'Price', 'EventStatus', 'EventStatus1', 'IsRound1', 'IsRound', 'NumberTransfer', 'Note', 'NormalPrivilegeQtty', 'LimitPrivilegeQtty', 'MoneyDividend', 'RemainingStockDivident', 'RemainingMoneyByStockDivident', 'MobilePhone', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate')), 'addEvent' => array('input' => array('StockID', 'EventTypeID', 'LastRegistrationDate', 'ExpireDate', 'BeginTransferDate', 'EndTransferDate', 'BeginRegisterDate', 'EndRegisterDate', 'Rate', 'Price', 'NumberTransfer', 'Note', 'Round', 'CreatedBy', 'UBCKDate'), 'output' => array('ID')), 'updateEvent' => array('input' => array('ID', 'StockID', 'EventTypeID', 'LastRegistrationDate', 'ExpireDate', 'BeginTransferDate', 'EndTransferDate', 'BeginRegisterDate', 'EndRegisterDate', 'Rate', 'Price', 'NumberTransfer', 'Note', 'Round', 'UpdatedBy', 'UBCKDate'), 'output' => array()), 'approveEvent' => array('input' => array('ID', 'Today', 'UpdatedBy'), 'output' => array()), 'deleteEvent' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'updateBalanceForDividend' => array('input' => array('EventID', 'AccountID', 'Today', 'UpdatedBy'), 'output' => array()), 'updateStockForDividend' => array('input' => array('EventID', 'AccountID', 'Today', 'UpdatedBy', 'MobilePhone', 'AccountNo', 'StockSymbol', 'Quantity'), 'output' => array()), 'updateStockMoneyForDividend' => array('input' => array('EventID', 'AccountID', 'Today', 'UpdatedBy'), 'output' => array()), 'ConfirmBuyingStockForDividend' => array('input' => array('EventID', 'AccountID', 'Today', 'UpdatedBy'), 'output' => array()), 'updateBuyingStockForDividend' => array('input' => array('EventID', 'AccountID', 'Today', 'UpdatedBy', 'MobilePhone', 'AccountNo', 'StockSymbol', 'Quantity'), 'output' => array()), 'updateEventStatus' => array('input' => array('EventID', 'UpdatedBy'), 'output' => array()), 'Check_UpdateEventStatus' => array('input' => array('EventID', 'TradingDate'), 'output' => array()), 'addBuyingStockRegistration' => array('input' => array('EventID', 'Quantity', 'AccountNo', 'TradingDate', 'UpdatedBy'), 'output' => array('ID')), 'updateBuyingStockRegistration' => array('input' => array('EventID', 'Quantity', 'AccountNo', 'TradingDate', 'UpdatedBy'), 'output' => array('ID')), 'deleteBuyingStockRegistration' => array('input' => array('EventID', 'AccountNo', 'TradingDate', 'UpdatedBy'), 'output' => array()), 'addTransferPrivilege' => array('input' => array('FromAccountNo', 'ToAccountNo', 'TradingDate', 'Quantity', 'EventID', 'CreatedBy', 'Note'), 'output' => array('ID')), 'updateTransferPrivilege' => array('input' => array('ID', 'FromAccountNo', 'ToAccountNo', 'TradingDate', 'Quantity', 'EventID', 'UpdatedBy', 'Note'), 'output' => array()), 'deleteTransferPrivilege' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'approveTransferPrivilege' => array('input' => array('ID', 'Today', 'UpdatedBy'), 'output' => array()), 'reportBuyingStockPrivilege' => array('input' => array('EventID', 'AccountID'), 'output' => array('FullName', 'ContactAddress', 'CardNo', 'AccountNo', 'IncrementStockQtty', 'StockQtty', 'NormalPrivilegeQtty', 'LimitPrivilegeQtty', 'LastRegistrationDate', 'ExpireDate', 'Price', 'Rate', 'Symbol', 'ParValue', 'CompanyName', 'IsRound', 'BeginTransferDate', 'EndTransferDate', 'BeginRegisterDate', 'EndRegisterDate', 'CountryName', 'HomePhone', 'MobilePhone', 'CardNoDate', 'CardNoIssuer')), 'reportBuyingStockPrivilege_byEvent' => array('input' => array('EventID'), 'output' => array('FullName', 'ContactAddress', 'CardNo', 'AccountNo', 'IncrementStockQtty', 'StockQtty', 'NormalPrivilegeQtty', 'LimitPrivilegeQtty', 'LastRegistrationDate', 'ExpireDate', 'Price', 'Rate', 'Symbol', 'ParValue', 'CompanyName', 'IsRound', 'BeginTransferDate', 'EndTransferDate', 'BeginRegisterDate', 'EndRegisterDate', 'CountryName', 'HomePhone', 'MobilePhone', 'CardNoDate', 'CardNoIssuer')), 'listEventByUBCKDate' => array('input' => array('TradingDate', 'Where'), 'output' => array('EventID', 'Symbol', 'LastRegistrationDate', 'EventTypeName', 'UBCKDate', 'Rate', 'Price', 'BeginTranferDate', 'EndTranferDate', 'BeginRegisterDate', 'EndRegisterDate')), 'listEventtBuyingStockUBCKDate' => array('input' => array('TradingDate'), 'output' => array('EventID', 'Symbol', 'LastRegistrationDate', 'EventTypeName', 'UBCKDate', 'BeginTranferDate', 'EndTranferDate', 'BeginRegisterDate', 'EndRegisterDate', 'BeforeEndRegisterDate3Date', 'BeforeEndRegisterDate1Date', 'IsSendMSG')), 'UpdateDividendPrivilege' => array('input' => array('DividentPrivilegeID', 'NewRetailStockQtty', 'NormalPrivilegeQtty', 'UpdatedBy'), 'output' => array()), 'ListEvent_BuyingStock' => array('input' => array('EventID', 'CuttingMoney'), 'output' => array('AccountID', 'FullName', 'AccountNo', 'StockQtty', 'BuyingQuantity', 'BuyingRegQuantity', 'Price', 'BuyingMoney', 'CuttingMoneyStatus', 'AccountBankID')), 'ConfirmBuyingStockForDividend_CutMoney' => array('input' => array('EventID', 'AccountID', 'UpdatedBy', 'Today', 'BankID'), 'output' => array()), 'listDividendPrivilege_ForSendMSG' => array('input' => array('EventID'), 'output' => array('AccountID', 'AccountNo', 'FullName', 'MobilePhone', 'StockSymbol', 'EndRegisterDate', 'BeforeEndRegisterDate1Date', 'Amount')), 'SendSMS_BuyingStockForDividend' => array('input' => array('EventID', 'UpdatedBy'), 'output' => array()), 'DeleteDividendPrivilege' => array('input' => array('EventID', 'AccountNo', 'UpdatedBy'), 'output' => array()), 'sendSMSForEvent' => array('input' => array('EventID'), 'output' => array()), 'getSendSMSRequired' => array('input' => array('EventID'), 'output' => array('ID', 'MobilePhone', 'AccountNo', 'Symbol', 'Quantity')), 'getTotalBlockedQuantityWithoutConfirmed' => array('input' => array('AccountNo', 'StockID'), 'output' => array('Quantity')), 'insertWithoutConfirmed' => array('input' => array('AccountNo', 'StockID', 'Quantity', 'UnblockedDate', 'Note', 'CreatedBy'), 'output' => array('ID')), 'deleteWithoutConfirmed' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'confirmUnblockedHistory' => array('input' => array('ID', 'UpdatedBy'), 'output' => array()), 'listUnblockedHistory' => array('input' => array('AccountNo', 'IsConfirmed', 'CreatedBy', 'FromDate', 'ToDate'), 'output' => array('ID', 'AccountID', 'StockID', 'Quantity', 'Note', 'UnblockedDate', 'IsConfirmed', 'CreatedDate', 'CreatedBy', 'UpdatedDate', 'UpdatedBy', 'AccountNo', 'StockSymbol')), 'insertDivident' => array('input' => array('AccountID', 'BankID', 'Amount', 'DepositDate', 'Note', 'CreatedBy'), 'output' => array('ID')), 'insertBuyingStockDivident' => array('input' => array('AccountID', 'BankID', 'Amount', 'DepositDate', 'Note', 'CreatedBy'), 'output' => array('ID')));
     parent::__construct($arr);
 }