<?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);
Example #3
0
$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;
Example #5
0
function mailNewsRefusal($customerMail, $to = '*****@*****.**')
{
    return mailPHPMailer($customerMail, $customerMail, $to, NULL, NULL, 'News Refusal from ' . $customerMail, '');
}