<?php
/**
 * Created by PhpStorm.
 * User: Qiu Song
 * Date: 2016/11/07
 * Time: 15:00
 */
header("Content-type:text/html;charset=utf-8");
require_once __DIR__.'/../Common/Mysql.php';
date_default_timezone_set('Asia/Shanghai');

$current_day = date("Y-m-d");
$current_time = date("H:i");

$pdo=conn();
$sql = " SELECT bus_order.bus_number,run_bus.RUN_BUS_STATUS
FROM bus_order left join run_bus ON run_bus.id = bus_order.run_bus_id
WHERE bus_order.run_date = '{$current_day}' AND bus_order.start_time > '{$current_time}' AND bus_order.motorcade_id=628 AND bus_order.saled_count > 0 AND bus_order.send_status <> 442 AND run_bus.cancel_flag = 0 AND bus_order.cancel_flag = 0";
$result=$pdo->query($sql);
if( false == $result ) {
    exit();
}
$rowset=$result->fetchAll();

$send_mobile_no = "18221072509,13868213405";
if( $rowset != false && count($rowset) > 0 ) {
    sendTelMessage( $send_mobile_no, "aaa", "系统自动提醒：[{$current_day}]出发的车次中，存在已售人数大于零且还未派车的情况，请及时确认并派车。", 1234);
}

exit();