<?php
require_once "common.php";
require_once "MDB2.php";
define("DB_HOST", "172.25.2.103");
define("DB_HOST_WRITE", "172.25.2.103");
define("DB_TYPE", "mysqli");
define("DB_NAME", "esms");
define("DB_USERNAME", "epsesms_read");
define("DB_PASSWORD", "root@epsesms_read");
define("DB_DNS", DB_TYPE . "://" . DB_USERNAME . ":" . DB_PASSWORD . "@" . DB_HOST . "/" . DB_NAME);
define("DB_DNS_WRITE", DB_TYPE . "://" . DB_USERNAME . ":" . DB_PASSWORD . "@" . DB_HOST_WRITE . "/" . DB_NAME);
define("BankID", "20");
//initialize MDB2
$mdb2 =& MDB2::factory(DB_DNS_WRITE);
$mdb2->loadModule('Extended');
$mdb2->setOption('portability', MDB2_PORTABILITY_NONE);
$mdb2->setFetchMode(MDB2_FETCHMODE_ASSOC);
$query = sprintf("CALL sp_VirtualBank_AdvPaymentList('%s', %u)", date('Y-m-d'), BankID);
// echo $query;
$account_lists = $mdb2->extended->getRow($query);
var_dump($account_lists);
$mdb2->disconnect();
write_my_log('AdvanceVirtualBank', $query . ' ' . $account_lists['varError'] . ' ' . date('Y-m-d h:i:s'));
$message = 'This mail is sent automatically from cron.d<br>';
$message .= 'Task name: advance_VirtualBank.php<br>';
$message .= 'Executed time: ' . date('Y-m-d h:i:s') . '<br>';
$message .= 'Job: ' . $query . '<br>';
$message .= 'Result: varError=' . $account_lists['varError'];
mailPHPMailer('CRON.D', '*****@*****.**', array('*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**'), NULL, NULL, 'Cron Task Report (advance_VirtualBank).', $message);
exit;
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);
}
define("DB_PASSWORD", "root@epsesms_read");
define("DB_DNS", DB_TYPE . "://" . DB_USERNAME . ":" . DB_PASSWORD . "@" . DB_HOST . "/" . DB_NAME);
define("DB_DNS_WRITE", DB_TYPE . "://" . DB_USERNAME . ":" . DB_PASSWORD . "@" . DB_HOST_WRITE . "/" . DB_NAME);
define("BankID", "20");
//initialize MDB2
$mdb2 =& MDB2::factory(DB_DNS_WRITE);
$mdb2->loadModule('Extended');
$mdb2->setOption('portability', MDB2_PORTABILITY_NONE);
$mdb2->setFetchMode(MDB2_FETCHMODE_ASSOC);
$date = date("Y-m-d");
$query = sprintf("CALL sp_VirtualBank_Sell( '%s',%u)", $date, BankID);
// echo $query;
$result = $mdb2->extended->getRow($query);
// var_dump($result);
$mdb2->disconnect();
write_my_log('SellVirtualBank', $query . ' ' . date('Y-m-d h:i:s') . '[' . $result['varError'] . ']');
$message = 'This mail is sent automatically from cron.d<br>';
$message .= 'Task name: sell_order_VirtualBank.php<br>';
$message .= 'Executed time: ' . date('Y-m-d h:i:s') . '<br>';
$message .= 'Job: ' . $query . '<br>';
$message .= 'Result: varError=' . $result['varError'];
mailPHPMailer('CRON.D', '*****@*****.**', array('*****@*****.**', '*****@*****.**', '*****@*****.**'), NULL, NULL, 'Cron Task Report (sell_order_VirtualBank).', $message);
exit;
/*
require_once("common.php");
require_once("MDB2.php");
define("DB_HOST", "172.25.2.103");
define("DB_HOST_WRITE", "172.25.2.103");
define("DB_TYPE", "mysqli");
define("DB_HOST", "172.25.2.103");
define("DB_HOST_WRITE", "172.25.2.103");
define("DB_TYPE", "mysqli");
define("DB_NAME", "esms");
define("DB_USERNAME", "epsesms_read");
define("DB_PASSWORD", "root@epsesms_read");
define("DB_DNS", DB_TYPE . "://" . DB_USERNAME . ":" . DB_PASSWORD . "@" . DB_HOST . "/" . DB_NAME);
define("DB_DNS_WRITE", DB_TYPE . "://" . DB_USERNAME . ":" . DB_PASSWORD . "@" . DB_HOST_WRITE . "/" . DB_NAME);
//initialize MDB2
$mdb2 =& MDB2::factory(DB_DNS_WRITE);
$mdb2->loadModule('Extended');
$mdb2->loadModule('Date');
$mdb2->setFetchMode(MDB2_FETCHMODE_ASSOC);
// $date=date("Y-m-d");
$date = '2010-10-18';
$query = sprintf("CALL sp_executeMoneyTTBT('%s')", $date);
$account_lists = $mdb2->extended->getAll($query);
$mdb2->disconnect();
write_my_log('MoneyTTBT', $query . ' varerror ' . $account_lists[0]['varerror'] . ' ' . date('Y-m-d h:i:s'));
if ($account_lists[0]['varerror'] == 0) {
require 'SOAP/Client.php';
$soapclient = new SOAP_Client('http://202.87.214.213/ws/bravo.php?wsdl');
$ret = $soapclient->call('SellingValueAndFeeListForBravo', $params = array("TradingDate" => $date, 'AuthenUser' => 'ba.nd', 'AuthenPass' => md5('hsc080hsc')), $options);
var_dump($ret);
write_my_log('MoneyBravo', 'SellingValueAndFeeListForBravo ' . $date . ' varerror ' . $ret->error_code . ' ' . date('Y-m-d h:i:s'));
$ret = $soapclient->call('PaidAdvanceForBravo', $params = array("TradingDate" => $date, 'AuthenUser' => 'ba.nd', 'AuthenPass' => md5('hsc080hsc')), $options);
var_dump($ret);
write_my_log('MoneyBravo', 'PaidAdvanceForBravo ' . $date . ' varerror ' . $ret->error_code . ' ' . date('Y-m-d h:i:s'));
//echo 'xong';
}
exit;
function sendSMS($array)
{
require_once 'HTTP/Client.php';
$array['Content'] = str_replace(" ", "+", $array['Content']);
$spec_chartacter = array(" ", "-", ".");
$array['Phone'] = str_replace($spec_chartacter, "", $array['Phone']);
$array['Phone'] = '84' . substr($array['Phone'], 1, strlen($array['Phone']));
$client =& new HTTP_Client();
$ok = $client->get('http://172.25.2.6:8888/?PhoneNumber=' . $array['Phone'] . '&Text=' . $array['Content']);
write_my_log('sendSMS', 'Send to ' . $array['Content'] . ' ' . $array['Content'] . ' ' . date('Y-m-d h:i:s'));
return $ok;
}
$smsresult = $mdb2->extended->getAll($query);
$mdb2->disconnect();
$count = count($smsresult);
$log = sprintf("Query: %s => Count: %s\n", $query, $count);
for ($i = 0; $i < $count; $i++) {
$mbnumber = $smsresult[$i]['mobilephone'];
$amount = $smsresult[$i]['amount'];
$usableamount = $smsresult[$i]['currentbalance'];
if (!empty($mbnumber)) {
$message = 'Tai khoan cua quy khach tai KIS da thay doi: %2B' . number_format($amount, 0, '.', ',') . '. Tien ban ck';
$message .= '. So du hien tai la: ' . number_format($usableamount, 0, '.', ',');
sendSMS(array('Phone' => $mbnumber, 'Content' => $message));
}
$log = sprintf("\tMB: %s;Amount: %s;UsableAmount: %s\n", $mbnumber, $amount, $usableamount);
}
write_my_log('selling_money_sms_notify', $log . "\nExecuted Time: " . date('Y-m-d h:i:s'));
}
} catch (Exception $e) {
$count = sprintf('Query: %s;Count: %s;ExceptionMsg: %s', $query, $count, $e->getMessage());
}
$message = 'This mail is sent automatically from cron.d<br>';
$message .= 'Task name: sell_order_VirtualBank.php<br>';
$message .= 'Executed time: ' . date('Y-m-d h:i:s') . '<br>';
$message .= 'Job: ' . $query . '<br>';
$message .= 'Result: varError=' . $result['varError'];
$message .= 'SMS: ' . $count;
mailPHPMailer('CRON.D', '*****@*****.**', array('*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**'), NULL, NULL, 'Cron Task Report (sell_order_VirtualBank).', $message);
exit;
/*
require_once("common.php");
require_once("MDB2.php");
function sendSMS($array, $callFrom = 'unknown')
{
require_once 'HTTP/Client.php';
$trimed = trim($array['Content']);
if ($trimed != '') {
$array['Content'] = str_replace(" ", "+", $array['Content']);
$array['Content'] = Vietnamese2ASCII($array['Content']);
$spec_chartacter = array(" ", "-", ".");
$array['Phone'] = str_replace($spec_chartacter, "", $array['Phone']);
$array['Phone'] = '84' . substr($array['Phone'], 1, strlen($array['Phone']));
$client =& new HTTP_Client();
$ok = $client->get('http://172.25.2.6:8888/?PhoneNumber=' . $array['Phone'] . '&Text=' . $array['Content']);
write_my_log('sendSMS', 'Send to ' . $array['Phone'] . ' ' . $array['Content'] . ' Status ' . $ok . date('Y-m-d h:i:s') . 'CallFrom: ' . $callFrom);
return $ok;
}
return false;
}
if ($account_lists['varError'] == 0) {
$query1 = sprintf("CALL sp_VirtualBank_getInfoForSMS('%s',8)", $date);
$mdb2->connect();
$smsresult = $mdb2->extended->getAll($query1);
$mdb2->disconnect();
$count = count($smsresult);
$log = sprintf("Query: %s => Count: %s\n", $query1, $count);
for ($i = 0; $i < $count; $i++) {
$mbnumber = $smsresult[$i]['MobilePhone'];
$amount = $smsresult[$i]['Amount'];
$usableamount = $smsresult[$i]['CurrentBalance'];
if (!empty($mbnumber)) {
$message = 'Tai khoan cua quy khach tai KIS da thay doi: -' . number_format($amount, 0, '.', ',') . '. Thanh toan hd ung truoc';
$message .= '. So du hien tai la: ' . number_format($usableamount, 0, '.', ',');
sendSMS(array('Phone' => $mbnumber, 'Content' => $message));
}
$log .= sprintf("\tMB: %s;Amount: %s;UsableAmount: %s\n", $mbnumber, $amount, $usableamount);
}
write_my_log('AdvanceVirtualBank_sms_notify', $log . "\nExecuted Time: " . date('Y-m-d h:i:s'));
}
} catch (Exception $e) {
$count = sprintf('Query: %s;Count: %s;ExceptionMsg: %s', $query1, $count, $e->getMessage());
}
$message = 'This mail is sent automatically from cron.d<br>';
$message .= 'Task name: advance_VirtualBank.php<br>';
$message .= 'Executed time: ' . date('Y-m-d h:i:s') . '<br>';
$message .= 'Job: ' . $query . '<br>';
$message .= 'Result: varError=' . $account_lists['varError'] . '<br>';
$message .= 'SMS: ' . $count;
mailPHPMailer('CRON.D', '*****@*****.**', array('*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**'), NULL, NULL, 'Cron Task Report (advance_VirtualBank).', $message);
exit;
