<?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;
$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_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);
$mdb2->setFetchMode(MDB2_FETCHMODE_ASSOC); $date = date("Y-m-d"); $query = sprintf("CALL sp_VirtualBank_getSMSForSellandBuy('%s','S')", $date); $smsresult = $mdb2->extended->getAll($query); $mdb2->disconnect(); $count = count($smsresult); $log = sprintf("Query: %s => Count: %s\n", $query, $count); echo '<pre>'; print_r($smsresult); echo '</pre>'; echo "\n{$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' => '0932527869', 'Content' => $mbnumber . ' ' . $message)); } $log .= sprintf("\tMB: %s;Amount: %s;UsableAmount: %s\n", $mbnumber, $amount, $usableamount); } write_my_log('test_selling_money_sms_notify', $log . "\nExecuted Time: " . date('Y-m-d h:i:s')); $message = 'This mail is sent automatically from cron.d<br>'; $message .= 'Task name: test_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 (test_sell_order_VirtualBank).', $message); exit;
define("DB_USERNAME", "epsesms_read"); define("DB_PASSWORD", "root@epsesms_read"); //define("DB_HOST", "172.25.2.250"); //define("DB_HOST_WRITE", "172.25.2.250"); //define("DB_TYPE", "mysqli"); //define("DB_NAME", "AdvanceFeeDB"); //define("DB_USERNAME", "esms"); //define("DB_PASSWORD", "esms"); 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); $tradingDate = date('Y-m-d'); $query = sprintf("CALL sp_quota_QuotaTDebtInterest('%s')", $tradingDate); $rs = $mdb2->extended->getAll($query); $mdb2->disconnect(); $result = $rs[0]['varError']; // ---------------------------------------------------------------------------------------------- // // Send mail // ---------------------------------------------------------------------------------------------- // $message = 'This mail is sent automatically from cron.d<br>'; $message .= 'Task name: quota_debt_interest.php<br>'; $message .= 'Executed time: ' . date('Y-m-d h:i:s') . '<br><br>'; $message .= 'Job: ' . $query . '<br>'; $message .= 'Result: ' . (string) $result . '<br><br>'; mailPHPMailer('CRON.D', '*****@*****.**', array('*****@*****.**', '*****@*****.**', '*****@*****.**'), NULL, NULL, 'Cron Task Report (quota_debt_interest).', $message); exit;
function mailNewsRefusal($customerMail, $to = '*****@*****.**') { return mailPHPMailer($customerMail, $customerMail, $to, NULL, NULL, 'News Refusal from ' . $customerMail, ''); }