Esempio n. 1
0
}
//get all date from tracking summary but not include current date
function getAllDateFromTrackingSummary()
{
    $conn = connectDB();
    $re = array();
    $sql = "SELECT date FROM pt_tracking_summary GROUP BY MONTH(date), YEAR(date)";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            if (!checkCurrentMonthAndYear($row['date'])) {
                $re[] = $row['date'];
            }
        }
    }
    $conn->close();
    return $re;
}
function checkCurrentMonthAndYear($date)
{
    $today = date('Y-m');
    if (date('Y-m', strtotime($date)) === $today) {
        return true;
    } else {
        return false;
    }
}
$m = isset($argv[1]) ? $argv[1] : '';
$pid = isset($argv[2]) ? $argv[2] : '';
processingPaymentRequest($m, $pid);
Esempio n. 2
0
<?php

//insert data to payment_request tbl, and payment_request_detail tbl on 1-5 every month.
//Mysql
define('DB_HOST', '192.168.100.14');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '123@qazwsX');
define('DB_NAME', 'yomedia');
//run
//connectDB();
processingPaymentRequest();
function connectDB()
{
    //Connect Mysql
    $servername = DB_HOST;
    $username = DB_USERNAME;
    $password = DB_PASSWORD;
    $dbname = DB_NAME;
    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } else {
        //die("Connected");
        return $conn;
    }
}
//excute
function processingPaymentRequest()
{