function OpenAccount1($PersonalCard, $Name, $Address, $BankAccountNo, $PartnerType, $dtBirthDay, $PlaceOfBirth, $dtDateIssue, $PlaceIssue, $ZipCode, $Country, $Email, $Phone, $Fax, $CompanyAddress, $CompanyPhone, $MailingAddress, $MailingPhone)
{
$class_name = $this->class_name;
$function_name = 'OpenAccount1';
$this->_ERROR_CODE = '0000';
if (0) {
//authenUser(func_get_args(), $this, $function_name) > 0 ){
$Name = '';
$Address = '';
$Account = '';
$Status = '';
$RespString = 'Invalid user/Password';
$OldNewAccount = '';
write_my_log('VCB-test', $_SERVER['REMOTE_ADDR'] . ' function_name ' . $function_name . ' Input PersonalCard ' . $PersonalCard . ' Name ' . $Name . ' Address ' . $Address . ' BankAccountNo ' . $BankAccountNo . ' PartnerType ' . $PartnerType . ' dtBirthDay ' . $dtBirthDay . ' PlaceOfBirth ' . $PlaceOfBirth . ' dtDateIssue ' . $dtDateIssue . ' PlaceIssue ' . $PlaceIssue . ' ZipCode ' . $ZipCode . ' Country ' . $Country . ' Email ' . $Email . ' Phone ' . $Phone . ' Fax ' . $Fax . ' CompanyAddress ' . $CompanyAddress . ' CompanyPhone ' . $CompanyPhone . ' MailingAddress ' . $MailingAddress . ' MailingPhone ' . $MailingPhone . ' ErrorCode ' . $this->_ERROR_CODE . ' ' . date('Y-m-d h:i:s'));
mailSMTP('*****@*****.**', '*****@*****.**', '*****@*****.**', '', '', 'Ket noi VietCombank test', 'Test ket noi VietComBank ' . $_SERVER['REMOTE_ADDR'] . ' function_name ' . $function_name . ' Input PersonalCard ' . $PersonalCard . ' Name ' . $Name . ' Address ' . $Address . ' BankAccountNo ' . $BankAccountNo . ' PartnerType ' . $PartnerType . ' dtBirthDay ' . $dtBirthDay . ' PlaceOfBirth ' . $PlaceOfBirth . ' dtDateIssue ' . $dtDateIssue . ' PlaceIssue ' . $PlaceIssue . ' ZipCode ' . $ZipCode . ' Country ' . $Country . ' Email ' . $Email . ' Phone ' . $Phone . ' Fax ' . $Fax . ' CompanyAddress ' . $CompanyAddress . ' CompanyPhone ' . $CompanyPhone . ' MailingAddress ' . $MailingAddress . ' MailingPhone ' . $MailingPhone . ' ErrorCode ' . $this->_ERROR_CODE . ' ' . date('Y-m-d h:i:s') . ' ErrorCode ' . $this->_ERROR_CODE);
$array_input['PersonalCard'] = new SOAP_Value('PersonalCard', 'string', $PersonalCard);
$array_input['Name'] = new SOAP_Value('Name', 'string', $Name);
$array_input['Account'] = new SOAP_Value('Account', 'string', $Account);
$array_input['State'] = new SOAP_Value('State', 'string', $State);
$array_input['ResponseCode'] = new SOAP_Value('ResponseCode', 'string', $this->_ERROR_CODE);
$array_input['RespString'] = new SOAP_Value('RespString', 'string', $RespString);
$array_input['OldNewAccount'] = new SOAP_Value('OldNewAccount', 'string', $OldNewAccount);
return returnXML(func_get_args(), $this->class_name, $function_name, $array_input, $this);
}
if (!required($Name)) {
$this->_ERROR_CODE = 8013;
$RespString = 'Name is null';
}
if ($this->_ERROR_CODE == '0000' && !required($BankAccountNo)) {
$this->_ERROR_CODE = 8016;
$RespString = 'BankAccountNo is null';
}
if ($this->_ERROR_CODE == '0000' && !required($PersonalCard)) {
$this->_ERROR_CODE = 8072;
$RespString = 'PersonalCard is null';
}
if ($this->_ERROR_CODE == '0000' && isset($PartnerType) && strlen($PartnerType) > 0 && !in_array($PartnerType, array('C', 'F', 'P'))) {
$this->_ERROR_CODE = 8028;
$RespString = 'Invalid PartnerType';
}
if ($this->_ERROR_CODE == '0000') {
$BankName = 'VietComBank';
$pos = strpos($Name, ' ');
$FirstName = substr($Name, 0, $pos + 1);
$LastName = substr($Name, $pos + 1);
$query = sprintf("CALL Sp_aaaaOpenPrivateAccount_VCB\r\n('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", $FirstName, $LastName, $PartnerType, $Address, $MailingAddress, $Phone, $MailingPhone, $Email, $dtBirthDay, $PersonalCard, $dtDateIssue, $PlaceIssue, 'F', $BankAccountNo, $Country, $BankName);
$result = $this->_MDB2_WRITE->extended->getAll($query);
$this->_MDB2_WRITE->disconnect();
$Name = '';
$Address = '';
$Account = '';
$Status = '';
$RespString = '';
$OldNewAccount = '';
if (empty($result) || is_object($result)) {
$this->_ERROR_CODE = 8049;
} else {
if (isset($result[0]['varerror'])) {
if ($result[0]['varerror'] == -1) {
$this->_ERROR_CODE = 8051;
//exception
$RespString = 'EPS-err : exception';
}
//if($result[0]['varerror'] == -2) $this->_ERROR_CODE = 18052;// duplicate cardno
if ($result[0]['varerror'] == -3) {
$this->_ERROR_CODE = 8053;
//invalid countryName
$RespString = 'EPS-err invalid country name';
}
if ($result[0]['varerror'] == -4) {
$this->_ERROR_CODE = 8054;
//update account err
$RespString = 'EPS-err update account';
}
if ($result[0]['varerror'] == -5) {
$this->_ERROR_CODE = 8055;
//insert investor err
$RespString = 'EPS-err insert Investor';
}
if ($result[0]['varerror'] == -6) {
$this->_ERROR_CODE = 8056;
//ins MoneyBalance err
$RespString = 'EPS-err insert Balance';
}
if ($result[0]['varerror'] == -2 || $result[0]['varerror'] == 0) {
$Name = $result[0]['v_sfullname'];
$Address = $result[0]['sresidentaddress'];
$Account = $result[0]['v_saccountno'];
$Status = $result[0]['v_iisactive'] ? 'A' : 'H';
$OldNewAccount = $result[0]['v_icreated'] ? 0 : 1;
$RespString = 'Sucess';
}
} else {
$this->_ERROR_CODE = 8049;
$RespString = 'EPS-err: db err';
}
}
}
$array_input['PersonalCard'] = new SOAP_Value('PersonalCard', 'string', $PersonalCard);
$array_input['Name'] = new SOAP_Value('Name', 'string', $Name);
$array_input['Account'] = new SOAP_Value('Account', 'string', $Account);
$array_input['State'] = new SOAP_Value('State', 'string', $Status);
$array_input['ResponseCode'] = new SOAP_Value('ResponseCode', 'string', $this->_ERROR_CODE);
$array_input['RespString'] = new SOAP_Value('RespString', 'string', $RespString);
$array_input['OldNewAccount'] = new SOAP_Value('OldNewAccount', 'string', $OldNewAccount);
write_my_log('VCB-test', $_SERVER['REMOTE_ADDR'] . ' function_name ' . $function_name . ' Input PersonalCard ' . $PersonalCard . ' Name ' . $Name . ' Address ' . $Address . ' BankAccountNo ' . $BankAccountNo . ' PartnerType ' . $PartnerType . ' dtBirthDay ' . $dtBirthDay . ' PlaceOfBirth ' . $PlaceOfBirth . ' dtDateIssue ' . $dtDateIssue . ' PlaceIssue ' . $PlaceIssue . ' ZipCode ' . $ZipCode . ' Country ' . $Country . ' Email ' . $Email . ' Phone ' . $Phone . ' Fax ' . $Fax . ' CompanyAddress ' . $CompanyAddress . ' CompanyPhone ' . $CompanyPhone . ' MailingAddress ' . $MailingAddress . ' MailingPhone ' . $MailingPhone . ' Output Account' . $Account . ' State A ' . ErrorCode . $this->_ERROR_CODE . ' ' . date('Y-m-d h:i:s'));
mailSMTP('*****@*****.**', '*****@*****.**', '*****@*****.**', '', '', 'Ket noi VietCombank test', 'Test ket noi VietComBank ' . $_SERVER['REMOTE_ADDR'] . ' function_name ' . $function_name . ' Input PersonalCard ' . $PersonalCard . ' Name ' . $Name . ' Address ' . $Address . ' BankAccountNo ' . $BankAccountNo . ' PartnerType ' . $PartnerType . ' dtBirthDay ' . $dtBirthDay . ' PlaceOfBirth ' . $PlaceOfBirth . ' dtDateIssue ' . $dtDateIssue . ' PlaceIssue ' . $PlaceIssue . ' ZipCode ' . $ZipCode . ' Country ' . $Country . ' Email ' . $Email . ' Phone ' . $Phone . ' Fax ' . $Fax . ' CompanyAddress ' . $CompanyAddress . ' CompanyPhone ' . $CompanyPhone . ' MailingAddress ' . $MailingAddress . ' MailingPhone ' . $MailingPhone . ' Output Account' . $Account . ' State A ' . ErrorCode . $this->_ERROR_CODE . ' ' . date('Y-m-d h:i:s'));
return returnXML(func_get_args(), $this->class_name, $function_name, $array_input, $this);
}
function getListInvalidFutureBuyingOrder($OrderDate, $StockExchangeID)
{
// End 20100723 - Them $StockExchangeID ------------------------------------------------------- //
$function_name = 'getListInvalidFutureBuyingOrder';
$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);
}
if (!required($OrderDate)) {
$this->_ERROR_CODE = 30480;
} elseif (!required($StockExchangeID)) {
$this->_ERROR_CODE = 30001;
} else {
// $query = sprintf( "CALL sp_getListInvalidFutureBuyingOrder('%s' )", $OrderDate );
$query = sprintf("CALL sp_getListInvalidFutureBuyingOrder('%s', '%s' )", $OrderDate, $StockExchangeID);
$rs = $this->_MDB2_WRITE->extended->getAll($query);
$this->_MDB2_WRITE->disconnect();
$count = count($rs);
for ($i = 0; $i < $count; $i++) {
// 20100723 - Quang change ---------------------------------
// $vip = checkVIPAccount($AccountNo);// 1: exist 0: not exist
$vip = checkVIPAccount($rs[$i]['accountno']);
// 1: exist 0: not exist
// End 20100723 - Quang change -----------------------------
if (strpos(PAGODA_ACCOUNT, $rs[$i]['accountno']) === false && $vip == 0) {
if ($rs[$i]['ordersideid'] == ORDER_BUY) {
switch ($rs[$i]['bankid']) {
case DAB_ID:
$dab =& new CDAB();
$dab_rs = $dab->cancelBlockMoney($rs[$i]['bankaccount'], $rs[$i]['accountno'], $rs[$i]['id'], $rs[$i]['amount']);
break;
case VCB_ID:
$dab =& new CVCB();
$newOrderID = $rs[$i]['id'] . $rs[$i]['unitcode'];
$dab_rs = $dab->cancelBlockMoney($rs[$i]['accountno'], $newOrderID, $rs[$i]['amount']);
break;
case NVB_ID:
$dab =& new CNVB();
$dab_rs = $dab->cancelBlockMoney(substr($rs[$i]['id'] . date("His"), 3), $rs[$i]['bankaccount'], $rs[$i]['amount'], $rs[$i]['id']);
break;
case OFFLINE:
$query = sprintf("CALL sp_VirtualBank_Cancel('%s', %u, %u, %f, '%s')", $rs[$i]['accountno'], OFFLINE, $rs[$i]['id'], $rs[$i]['amount'], $function_name);
$this->_MDB2_WRITE->connect();
$off_rs = $this->_MDB2_WRITE->extended->getRow($query);
$this->_MDB2_WRITE->disconnect();
$dab_rs = $off_rs['varerror'];
break;
}
// switch
if ($dab_rs == 0) {
$success = 1;
} else {
$success = 0;
}
$this->_MDB2_WRITE->connect();
$query = sprintf("CALL sp_updateFromApprovedToDeniedForFutureBuyingOrder( %u, %u )", $rs[$i]['id'], $success);
$update_rs = $this->_MDB2_WRITE->extended->getRow($query);
$this->_MDB2_WRITE->disconnect();
}
// BUY order
$bank_result .= $rs[$i]['accountno'] . " " . $rs[$i]['id'] . " " . $rs[$i]['amount'] . " --> " . $dab_rs . "\r\n";
$arraySMS['Phone'] = $rs[$i]['mobilephone'];
$OrderSide = $rs[$i]['ordersideid'] == ORDER_BUY ? "Mua" : "Ban";
$arraySMS['Content'] = "EPS: Lenh " . $OrderSide . " " . $rs[$i]['symbol'] . " - TK: " . $rs[$i]['accountno'] . " khong hop le do sai gia Tran/San";
sendSMS($arraySMS);
}
// PAGODA_ACCOUNT
}
// for
mailSMTP('Quản lý Đặt lệnh', '*****@*****.**', '*****@*****.**', '*****@*****.**', '', 'Danh sách lệnh đặt trước không hợp lệ - StockExchangeID:' . $StockExchangeID, 'Danh sách lệnh đặt trước không hợp lệ \\r\\n <br>' . $bank_result);
// mailSMTP('Quản lý Đặt lệnh','*****@*****.**','*****@*****.**','*****@*****.**', '', 'Danh sách lệnh đặt trước không hợp lệ - StockExchangeID:'.$StockExchangeID,'Danh sách lệnh đặt trước không hợp lệ \r\n <br>'.$bank_result);
$filename = $_SERVER['DOCUMENT_ROOT'] . "/bank/unlock/" . date("Ymd");
file_put_contents($filename, $bank_result);
}
return returnXML(func_get_args(), $this->class_name, $function_name, $this->_ERROR_CODE, $this->items, $this);
}
}
}
if (!empty($bcc)) {
if (is_array($bcc)) {
foreach ($bcc as $bcc_addr) {
$mail->AddCC($bcc_addr);
}
} else {
$mail->AddCC($bcc);
}
}
$mail->WordWrap = 50;
// set word wrap
$mail->IsHTML(true);
$mail->CharSet = "UTF-8";
$mail->Subject = $subject;
$mail->Body = $message;
$mail->Port = 25;
$ok = $mail->Send();
//if($ok) echo 'phpmailer ok';
//else
//{
// echo 'phpmailer fail <br />';
// echo $mail->ErrorInfo . '<br />';
//}
$mail->SmtpClose();
return $ok;
}
//mailSMTP('Quang Tran', '*****@*****.**', array('*****@*****.**', '*****@*****.**', '*****@*****.**'), NULL, NULL, 'Test mail', 'MAKENO KEMENO');
$ok = mailSMTP('Quang Tran', '*****@*****.**', NULL, NULL, NULL, 'Test mail', 'MAKENO KEMENO');
print_r($ok);
