<?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;