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]); } } }