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);
}
function COTC($check_ip)
{
//initialize MDB2
/*$this->_MDB2 = initTradingBoard();
$this->_MDB2_WRITE = initTradingBoard();*/
$this->_MDB2 = initDB();
$this->_MDB2_WRITE = initWriteDB();
$this->_ERROR_CODE = $check_ip;
$this->class_name = get_class($this);
$this->items = array();
$arr = array('insertBuyOrder' => array('input' => array('AccountNo', 'StockID', 'OrderQuantity', 'OrderPrice', 'Session', 'FromTypeID', 'Note', 'OrderDate', 'IsAssigner', 'IsGotPaper', 'CreatedBy', 'AccountNoContra', 'CompanyNameContra'), 'output' => array('ID')), 'insertSellOrder' => array('input' => array('AccountNo', 'StockID', 'OrderQuantity', 'OrderPrice', 'Session', 'FromTypeID', 'Note', 'OrderDate', 'IsAssigner', 'IsGotPaper', 'CreatedBy', 'AccountNoContra', 'CompanyNameContra'), 'output' => array('ID')), 'updateSellOrder' => array('input' => array('OrderID', 'OrderQuantity', 'OrderPrice', 'UpdatedBy'), 'output' => array()), 'updateBuyOrder' => array('input' => array('OrderID', 'OrderQuantity', 'OrderPrice', 'AccountNo', 'UpdatedBy'), 'output' => array()), 'deleteOrder' => array('input' => array('OrderID', 'AccountNo', 'UpdatedBy'), 'output' => array()), 'listOrders' => array('input' => array('OrderDate', 'AccountID', 'OrderStockStatusID'), 'output' => array('OrderID', 'AccountNo', 'StockID', 'Symbol', 'OrderQuantity', 'OrderPrice', 'OrderSideID', 'OrderSideName', 'Session', 'OrderStockStatusID', 'StatusName', 'OrderStyleID', 'OrderStyleName', 'FromName', 'OldOrderID', 'Note', 'OrderDate', 'OrderAgencyFee', 'StockExchangeID', 'ExchangeName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'BankID', 'BankName', 'BankShortName', 'CompanyName', 'OldPrice', 'BlockedValue', 'IsNewEdit', 'OrderNumber', 'AccountID', 'FromTypeID', 'IsUnBlocked', 'BranchID', 'AccountNoContra', 'CompanyNameContra')), 'listOrdersWithLimitation' => array('input' => array('OrderDate', 'AccountID', 'OrderStockStatusID'), 'output' => array('OrderID', 'AccountNo', 'StockID', 'Symbol', 'OrderQuantity', 'OrderPrice', 'OrderSideID', 'OrderSideName', 'Session', 'OrderStockStatusID', 'StatusName', 'OrderStyleID', 'OrderStyleName', 'FromName', 'OldOrderID', 'Note', 'OrderDate', 'OrderAgencyFee', 'StockExchangeID', 'ExchangeName', 'CreatedBy', 'CreatedDate', 'UpdatedBy', 'UpdatedDate', 'BankID', 'BankName', 'BankShortName', 'CompanyName', 'OldPrice', 'BlockedValue', 'IsNewEdit', 'OrderNumber', 'AccountID', 'FromTypeID', 'IsUnBlocked', 'BranchID', 'AccountNoContra', 'CompanyNameContra')), 'insertCancelOrderForHN' => array('input' => array('OrderQuantity', 'Session', 'FromTypeID', 'OldOrderID', 'Note', 'OrderDate', 'IsAssigner', 'CreatedBy'), 'output' => array('ID')), 'getOrderInfoToCall' => array('input' => array('OrderID'), 'output' => array('OrderID', 'AccountNo', 'Symbol', 'OrderQuantity', 'OrderPrice', 'OrderStyleName', 'OrderSideName', 'OldOrderID', 'OldPrice', 'Note', 'StockExchangeID', 'IsNewEdit', 'AccountNoContra', 'CompanyNameContra')), 'updateTFlag' => array('input' => array('OrderID', 'TFlag', 'UpdatedBy'), 'output' => array()), 'stockDetailWithoutConfirmList' => array('input' => array('TradingDate', 'TFlag'), 'output' => array('ID', 'OrderNumber', 'AccountNo', 'OrderSideName', 'Symbol', 'MatchedQuantity', 'MatchedPrice', 'Note', 'TradingDate', 'StockExchangeID', 'OrderSideID', 'OrderID', 'TFlag')), 'executeStockOfBuyingDealWithTFlag' => array('input' => array('ID', 'UpdatedBy', 'TFlag'), 'output' => array()), 'executeStockOfSellingDealWithTFlag' => array('input' => array('ID', 'UpdatedBy', 'TFlag'), 'output' => array()), 'editPriceOfTransferBuyingOrder' => array('input' => array('OrderID', 'OrderPrice', 'AccountNo', 'UpdatedBy'), 'output' => array()), 'editPriceOfSellingOrder' => array('input' => array('OrderID', 'NewOrderPrice', 'UpdatedBy'), 'output' => array()), 'updateFromEditingtoTransfer' => array('input' => array('OrderID', 'UpdatedBy'), 'output' => array()), 'updateFromTransferToEditing' => array('input' => array('OrderID', 'UpdatedBy'), 'output' => array()), 'updateFromTransferingToTransferWithMatchedOrFailed' => array('input' => array('OrderID', 'IsMatched', 'UpdatedBy', 'MatchedQuantity'), 'output' => array()), 'updateFromTransferingToTransfered' => array('input' => array('OrderID', 'UpdatedBy'), 'output' => array()), 'updateFromTransferedToTransfering' => array('input' => array('OrderID', 'UpdatedBy'), 'output' => array()));
parent::__construct($arr);
}
public function testInstallationDB()
{
global $db, $config, $adminPassword, $adminLogin;
dropDB();
$resInit = initDB();
$this->assertNotEquals(FALSE, $resInit);
$resPass = $db->query("INSERT " . $config['db']['prefix'] . "users VALUES (NULL, '{$adminLogin}','{$adminPassword}','',1);");
$this->assertNotEquals(FALSE, $resPass);
upgradeDB(FALSE);
$result = $db->checkDB();
reinitDB();
$this->assertEquals(TRUE, $result);
}
function signup()
{
initDB($db, $username, $password);
//$sql = "SELECT * FROM `users` WHERE `account`= 'ryan';";
$pwd = md5($_POST['pwd']);
$sql = "INSERT INTO users (account,pwd,status) VALUES ('" . $_POST['account'] . "','" . $pwd . "','0')";
// $sql = "SELECT * FROM `users` ;";
$result = mysql_query($sql) or die('MySQL query error');
// $arr = array('status' => true, 'b' => 2, 'c' => 3, 'd' => 4, 'e' => 5);
echo true;
//print_r($arr);
//mysql_close($database_link);
}
function GetAllIDs()
{
// Connect to db
$conn = initDB();
// Get URNs (persons/links)
$sql1 = "SELECT DISTINCT resp_id FROM survey";
$result1 = mysqli_query($conn, $sql1);
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
$arr_id[] = $row1['resp_id'];
}
$arr_id = array_unique($arr_id);
//remove duplicate values
sort($arr_id);
return $arr_id;
// Free result set
mysqli_free_result($result1);
mysqli_close($conn);
}
function upgradeDB($showresult = true)
{
global $db, $config;
$curConfig = $db->fetchOne("select valeur from `" . $config['db']['prefix'] . "config` where cle = 'version';");
while ($curConfig['valeur'] !== $config['version']) {
$file = '../var/DB/upgrade_' . $curConfig['valeur'] . '.sql';
if ($showresult) {
echo "upgrading from " . $curConfig['valeur'] . " : {$file}\n";
}
$ret = initDB($file);
if ($ret === FALSE) {
echo "Problème lors de l'upgrade : {$file}\n";
exit;
} else {
$curConfig = $db->fetchOne("select valeur from `" . $config['db']['prefix'] . "config` where cle = 'version';");
if ($showresult) {
echo "Upgraded to " . $curConfig['valeur'] . "\n";
}
}
}
if ($showresult) {
echo "Done\n";
}
}
<?php
/**
administration
**/
//defaults, directories
require_once "./settings.php";
//begin db
$db = initDB();
if (!connectDB($db)) {
debug($db['msg']);
die;
}
session_cache_expire(SESSION_EXPIRE);
session_save_path(SESSION_PATH);
session_start();
define(U09A, true);
//if ($u09a) define (U09A, true);
//else if ($_SESSION['u09a']) define (U09A, $_SESSION['u09a']);
//$_SESSION['u09a'] = U09A;
$r = $_REQUEST;
reset($r);
$key = key($r);
$v = $_REQUEST[$key];
reset($r);
$k = key($r);
if (!$_SESSION['isadmin'] && $k == "login") {
if ($r['user'] == USERNAME && $r['pass'] == PASSWORD) {
$_SESSION['isadmin'] = true;
<?php
include_once "./../includes/channel_vars.php";
include_once "./../includes/init_database.php";
$dbh = initDB();
if (isset($_POST['yes'])) {
$id = $_POST['id'];
$gid = $_POST['gid'];
$query = "UPDATE tag SET tag_group_id = -1 WHERE tag_id={$id}";
$result = mysql_query($query, $dbh);
header("Location: edit_tag_group.php?id={$gid}");
} else {
if (isset($_POST['no'])) {
$gid = $_POST['gid'];
header("Location: edit_tag_group.php?id={$gid}");
} else {
$id = $_GET['id'];
$gid = $_GET['gid'];
$query = "SELECT tag_name FROM tag WHERE tag_id={$id}";
$result = mysql_query($query, $dbh);
$row = mysql_fetch_array($result, MYSQL_NUM);
?>
<html>
<head>
<title><?php
echo $global_channel_name;
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
// обработка параметров
$currencies = explode(';', $_REQUEST['c']);
// какие валюты запрошены
$currencyBase = $_REQUEST['b'];
// какая - базовая
$dtTo = $_REQUEST['to'];
// только конец диапазона, потому что вынимаем всегда на год назад
// если базовая не рубль, мы её принудительно включим в перечень запрошенных, если её там нет, чтобы данные по ней вытащить из источника и/или базы
if ($currencyBase != 'RUB') {
if (array_search($currencyBase, $currencies) === false) {
$currencies[] = $currencyBase;
}
}
// инициализация базы
$db = new SQLite3('rates.db');
initDB($db);
// обновляем базу по запрошенному перечню и дате конца периода
updateDB($db, $currencies, $dtTo);
// готовим ответ, обращаясь уже к базе
// здесь будем вынимать данные, заполнять пустые даты, приводить курсы к базовой валюте, пересчитывая по рублю
$res['data'] = prepareResponse($db, $currencies, $currencyBase, $dtTo);
// отправляем приложению
header('Access-Control-Allow-Origin: *');
header('Content-type: application/json');
echo json_encode($res);
// ------------------------------------------------
// готовим данные
function prepareResponse($db, $currencies, $currencyBase, $dtTo)
{
$res = array();
// для каждой валюты в запросе
function getItinerary($IID)
{
$connection = initDB();
$query;
if ($IID == 0) {
$query = "SELECT * FROM Itinerary";
} else {
$query = "SELECT * FROM Itinerary WHERE IID='" . $IID . "'";
}
$result = mysql_query($query);
//or die ("Query Failed ".mysql_error());
$itineraryID = 0;
$itineraryData;
while ($row = mysql_fetch_array($result)) {
$GID = $row['GID'];
$FID = $row['FID'];
$SID = $row['SID'];
//Retrieve Guest Information
$query2 = "SELECT * FROM Guest WHERE GID='" . $GID . "'";
$result2 = mysql_query($query2);
$row2 = mysql_fetch_array($result2);
$firstName = $row2['FirstName'];
$lastName = $row2['LastName'];
//Retrieve Travel Schedule Information
$query3 = "SELECT * FROM Schedule WHERE SID='" . $SID . "'";
$result3 = mysql_query($query3);
$row3 = mysql_fetch_array($result3);
$travelDate = $row3['Date'];
//Retrieve Sector Information
$query3 = "SELECT * FROM Flights WHERE FID='" . $FID . "'";
$result3 = mysql_query($query3);
$row3 = mysql_fetch_array($result3);
$sourceSID = $row3['SourceSID'];
$destSID = $row3['DestSID'];
$fName = $row3['FName'];
$query4 = "SELECT Sector FROM Sectors WHERE SID='" . $sourceSID . "'";
$result4 = mysql_query($query4);
$row4 = mysql_fetch_array($result4);
$source = $row4['Sector'];
$query4 = "SELECT Sector FROM Sectors WHERE SID='" . $destSID . "'";
$result4 = mysql_query($query4);
$row4 = mysql_fetch_array($result4);
$dest = $row4['Sector'];
//Build GuestItinerary object
$guestItinerary = new GuestItinerary();
$guestItinerary->set_FID($FID);
$guestItinerary->set_FName($fName);
$guestItinerary->set_SID($SID);
$guestItinerary->set_source($source);
$guestItinerary->set_dest($dest);
$guestItinerary->set_travelDate($travelDate);
$guestItinerary->set_GID($GID);
$guestItinerary->set_firstName($firstName);
$guestItinerary->set_lastName($lastName);
$itineraryData[$itineraryID] = $guestItinerary;
$itineraryID = $itineraryID + 1;
}
closeDB($connection);
return $itineraryData;
}
<?php
require_once dirname(__FILE__) . '/../db.php';
$conn = initDB();
$stmt = $conn->prepare("insert into points (x, y) values(?, ?)");
$stmt->bind_param('dd', $_POST["x"], $_POST["y"]);
$stmt->execute();
$stmt->close();
$conn->close();
function checkQuotaAccountIsExisted($AccountNo)
{
$function_name = 'checkQuotaAccountIsExisted';
$struct = '{urn:' . $this->class_name . '}' . $function_name . 'Struct';
if (authenUser(func_get_args(), $this, $function_name) > 0) {
return returnXML(func_get_args(), $this->class_name, $function_name, $this->_ERROR_CODE, $this->items, $this);
}
$MDB2 = initDB();
$query = sprintf("SELECT f_quota_QuotaAccount_IsExisted('%s') AS Boolean", $AccountNo);
$result = $MDB2->extended->getRow($query);
$this->items[0] = new SOAP_Value('item', $struct, array("Boolean" => new SOAP_Value("Boolean", "string", $result['boolean'])));
return returnXML(func_get_args(), $this->class_name, $function_name, $this->_ERROR_CODE, $this->items, $this);
}
//room exists, returning link to it
$roomId = $value->rooms_id;
}
}
if ($roomId == null) {
//room doesn't exist, creating one and returning a link
$addRoomResult = $roomClient->addRoomWithModeration(array('SID' => $session->return->session_id, 'name' => $fromHash . $toHash, 'roomtypes_id' => 1, 'comment' => 'Call room', 'numberOfPartizipants' => 2, 'ispublic' => true, 'appointment' => false, 'isDemoRoom' => false, 'demoTime' => 0, 'isModeratedRoom' => true))->return;
if ($addRoomResult > 0) {
$roomId = $addRoomResult;
} else {
dieWithMessage(METHOD_GETCALLEELINK, 'Failed to add a room');
}
}
$setUserObjectResult = $userClient->setUserObjectAndGenerateRoomHash(array('SID' => $session->return->session_id, 'username' => $callerName, 'firstname' => $callerName, 'lastname' => '', 'profilePictureUrl' => '', 'email' => '', 'externalUserId' => 0, 'externalUserType' => 'caller', 'room_id' => $roomId, 'becomeModeratorAsInt' => 0, 'showAudioVideoTestAsInt' => 2))->return;
if ($setUserObjectResult != null) {
showResult(METHOD_GETCALLEELINK, OM_SERVER_ADDRESS . '/openmeetings/main.lzx.swf8.swf?secureHash=' . $setUserObjectResult);
} else {
dieWithMessage(METHOD_GETCALLEELINK, "Setting user object failed");
}
} else {
dieWithMessage(METHOD_GETCALLEELINK, "Login failed");
}
}
//End of function definitions
if ($_REQUEST["method"] && ($_REQUEST["arg0"] && $_REQUEST["arg1"])) {
initDB();
call_user_func($_REQUEST["method"], $_REQUEST["arg0"], $_REQUEST["arg1"], $_REQUEST["arg2"]);
disposeAndClose();
} else {
dieWithMessage('METHOD ERROR', "No method given or argument list is broken");
}
function AdvanceForDAB($AdvancePaperID, $OrderBankID)
{
$ERROR_CODE = 0;
$mdb2 = initDB();
$advancelist = array('AccountNo' => '0', 'RefOrderID' => 0, 'Amount' => 0, 'OrderBankID' => '0', 'BravoCode' => '0', 'ErrorCode' => '0');
if ($AdvancePaperID == '' || $AdvancePaperID <= 0) {
$advancelist[$i]['ErrorCode'] = 20001;
}
if ($advancelist[$i]['ErrorCode'] == 0) {
$query11 = sprintf("CALL sp_AdvancePaper_ByAdvPaperID('%s', '%s')", $AdvancePaperID, $OrderBankID);
$result = $mdb2->extended->getAll($query11);
$num_row = count($result);
if ($num_row > 0) {
if ($OrderBankID == DAB_ID) {
$dab =& new CDAB();
if ($result[0]['apbankid'] != DAB_ID) {
$lender = 0;
} else {
$lender = 1;
}
for ($i = 0; $i < $num_row; $i++) {
if ($result[$i]['orderidstring'] == '' || $result[$i]['accountno'] == '' || $result[$i]['contractno'] == '') {
$chkbankaccount = -99;
} else {
$chkbankaccount = $dab->sellAdvance($result[$i]['accountno'], $result[$i]['bankaccount'], $result[$i]['contractno'] ? $result[$i]['contractno'] : 0, $lender, $result[$i]['amount'] ? $result[$i]['amount'] : 0, $result[0]['advancefee'] ? $result[0]['advancefee'] : 0, $result[$i]['orderidstring'] ? $result[$i]['orderidstring'] : 0);
}
write_my_log_path('DAB-Advance1', 'AdvancePaperID ' . $AdvancePaperID . ' Account No' . $result[$i]['accountno'] . ' ContractNo ' . $result[$i]['contractno'] . ' BankAccount ' . $result[$i]['bankaccount'] . ' AdvanceAmount ' . $result[$i]['amount'] . ' AdvanceFee ' . $result[0]['advancefee'] . ' orderid ' . $result[$i]['orderidstring'] . ' orderbankid ' . $OrderBankID . ' Advance bankid ' . $result[$i]['apbankid'] . ' T3OrderDate ' . $result[$i]['t3orderdate'] . ' Error ' . $chkbankaccount . ' ' . date('Y-m-d h:i:s'), ADVANCE_PATH);
/*
-1: unauthenticate partner
-2: invalid parameters
-3: invalid date
-4: can't pay in advance to this custaccount
0: sell (advance) successful
1: invalid custaccount
2: invalid adv_amount
3: sell (advance) successful but can't send SMS to customer
5: sell (advance) unsuccessful
10: has already paid in advance
20: out of loan limit
99: unknown error
*/
switch ($chkbankaccount) {
case '0':
//sucess
$ERROR_CODE = 0;
break;
case '3':
//sucess
$ERROR_CODE = 0;
break;
case '-1':
//unauthenticate partner
$ERROR_CODE = 18132;
break;
case '-2':
//invalid parameters
$ERROR_CODE = 18133;
break;
case '-3':
//invalid date
$ERROR_CODE = 18134;
break;
case '-4':
//can't pay in advance to this custaccount
$ERROR_CODE = 20030;
break;
case '1':
//invalid custaccount
$ERROR_CODE = 20031;
break;
case '2':
//invalid adv_amount
$ERROR_CODE = 20032;
break;
case '5':
//sell (advance) unsuccessful
$ERROR_CODE = 20033;
break;
case '10':
//has already paid in advance
$ERROR_CODE = 20034;
break;
case '20':
//out of loan limit
$ERROR_CODE = 20035;
break;
case '-99':
//Advance Data error
$ERROR_CODE = 20036;
break;
case '99':
//Unknown error
$ERROR_CODE = 20027;
break;
default:
//deafulr error
$ERROR_CODE = 20028;
break;
}
//}
}
}
}
}
return $ERROR_CODE;
//$advancelist;
}
function checkAccountIsActive($AccountNo)
{
$mdb = initDB();
$query = sprintf("CALL sp_CheckAccount_IsActive('%s')", $AccountNo);
$rs = $mdb->extended->getRow($query);
$mdb->disconnect();
$result = $rs['varerror'];
if ($result <= 0) {
return false;
} else {
return true;
}
}
/**
* Get list of raw sensornames and
* check if there are unknown sensor-columns or
* if there are sensors in readable name array that are not available
*/
function checkSensorNameList()
{
//$database = new SQLiteDatabase(SQLITENAME, 0666, $error);
if (!file_exists(SQLITENAME . '.sqlite3')) {
initDB();
}
$database = new PDO('sqlite:' . SQLITENAME . '.sqlite3');
// Set errormode to exceptions
$database->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//Get info about table and check if column-name exists
$query = "PRAGMA table_info('sensorvalues')";
$sensorNameExists = false;
$i = 0;
if ($result = $database->query($query)) {
$firstLine = TRUE;
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
if ($firstLine) {
$firstLine = FALSE;
continue;
}
$colnames[] = $row['name'];
}
global $sensorNames;
foreach ($sensorNames as $key => $value) {
$knownSensors[] = $key;
}
global $listOfUnknownSensors;
$listOfUnknownSensors = array_diff($colnames, $knownSensors);
//Sensors that are not in list of known ones
$listOfSensorsNotToDisplay = array_diff($knownSensors, $colnames);
//Sensors that are in list of known ones but not found in db
//Remove Sensore that are named but not found in db from list, so they cannot be chosen with sensor-checkbox
global $ListOfSensorsToIgnore;
$listOfSensorsNotToDisplay = array_merge($ListOfSensorsToIgnore, $listOfSensorsNotToDisplay);
foreach ($listOfSensorsNotToDisplay as $key => $value) {
unset($sensorNames[$value]);
}
}
}
