Exemplo n.º 1
0
                 $data['tgai_reachdevTime1'] = date("Y-m-d H:i:s", strtotime($_GET[devDateTime]));
                 //print_r($data);
                 //exit;
                 if ($db->query_insert("tb_geoalertinfo", $data)) {
                     $res = 1;
                 } else {
                     $res = 0;
                 }
                 echo "SMS";
             }
         }
     }
 } else {
     //print_r($fetAlertImeiInfo);
     if ($_GET[inoutFlag] == $_GET[inoutPoint]) {
         $smsStatus = sendSMSAlert($aid);
         if ($smsStatus) {
             $data['tgai_assignDevId'] = $devImei;
             $data['tgai_geoAssignId'] = $aid;
             $data['tgai_inoutStatus'] = 0;
             $data['tgai_alertCount'] = 1;
             $data['tgai_alertType'] = $_GET[inoutPoint];
             $data['tgai_reachdevTime1'] = date("Y-m-d H:i:s", strtotime($_GET[devDateTime]));
             //print_r($data);
             //exit;
             if ($db->query_insert("tb_geoalertinfo", $data)) {
                 $res = 1;
             } else {
                 $res = 0;
             }
             echo "SMS";
Exemplo n.º 2
0
function smsmAlertFunc($gid, $aid, $src, $nooftime, $inout, $devDateTime, $devImei, $inorout)
{
    $db = new Database(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
    $db->connect();
    //print_r($_GET);
    //echo "<br><br>";
    $getAlertImeiInfo = "SELECT * FROM tb_geoalertinfo WHERE tgai_assignDevId = '" . $devImei . "' AND tgai_createDate like '" . date("Y-m-d", strtotime($devDateTime)) . "%' ORDER BY tgai_id DESC LIMIT 0,1";
    $resAlertImeiInfo = $db->query($getAlertImeiInfo);
    if ($db->affected_rows == 0) {
        if ($inout == 'in' && $inorout == $inout) {
            $smsStatus = sendSMSAlert($aid, $devDateTime);
            if ($smsStatus) {
                $data['tgai_assignDevId'] = $devImei;
                $data['tgai_geoAssignId'] = $aid;
                $data['tgai_inoutStatus'] = 0;
                $data['tgai_alertCount'] = 1;
                $data['tgai_alertType'] = $inout;
                $data['tgai_reachdevTime1'] = date("Y-m-d H:i:s", strtotime($devDateTime));
                //print_r($data);
                if ($db->query_insert("tb_geoalertinfo", $data)) {
                    $res = 1;
                } else {
                    $res = 0;
                }
                echo "SMS";
            }
        } elseif ($inout == 'out' && $inorout != $inout) {
            $data['tgai_assignDevId'] = $devImei;
            $data['tgai_geoAssignId'] = $aid;
            $data['tgai_inoutStatus'] = 0;
            $data['tgai_alertCount'] = 1;
            $data['tgai_alertType'] = $inout;
            $data['tgai_reachdevTime1'] = date("Y-m-d H:i:s", strtotime($devDateTime));
            //print_r($data);
            if ($db->query_insert("tb_geoalertinfo", $data)) {
                $res = 1;
            } else {
                $res = 0;
            }
        }
    } else {
        $fetAlertImeiInfo = $db->fetch_array($resAlertImeiInfo);
        $getAlertInfo = "SELECT * FROM tb_geoalertinfo WHERE tgai_geoAssignId = " . $aid . " AND tgai_createDate like '" . date("Y-m-d", strtotime($devDateTime)) . "%'";
        $resAlertInfo = $db->query($getAlertInfo);
        $fetAlertInfo = $db->fetch_array($resAlertInfo);
        /*echo $fetAlertImeiInfo[tgai_geoAssignId]." ".$aid." ".$fetAlertImeiInfo[tgai_inoutStatus]." ".$nooftime." ".$fetAlertImeiInfo[tgai_alertCount]." ". $inorout." ".$inout;
        		
        		echo "<pre>";
        		print_r($fetAlertImeiInfo);
        		//print_r($fetAlertInfo);
        		echo "</pre>";*/
        if ($fetAlertImeiInfo[tgai_geoAssignId] == $aid && $fetAlertImeiInfo[tgai_inoutStatus] == 0) {
            //echo $fetAlertImeiInfo[tgai_alertCount]."<".$nooftime."<br>";
            if ($inout == 'in' && $inorout != $inout) {
                $data['tgai_inoutStatus'] = 1;
                $data['tgai_reachdevTime2'] = date("Y-m-d H:i:s", strtotime($devDateTime));
                //print_r($data);
                //exit;
                if ($db->query_update("tb_geoalertinfo", $data, "tgai_id=" . $fetAlertInfo[tgai_id])) {
                    $res = 1;
                } else {
                    $res = 0;
                }
            } elseif ($inout == 'out' && $inorout == $inout) {
                $smsStatus = sendSMSAlert($aid, $devDateTime);
                if ($smsStatus) {
                    $data['tgai_inoutStatus'] = 1;
                    $data['tgai_reachdevTime2'] = date("Y-m-d H:i:s", strtotime($devDateTime));
                    //print_r($data);
                    //exit;
                    if ($db->query_update("tb_geoalertinfo", $data, "tgai_id=" . $fetAlertInfo[tgai_id])) {
                        $res = 1;
                    } else {
                        $res = 0;
                    }
                    echo "SMS";
                }
            }
        } elseif ($fetAlertImeiInfo[tgai_geoAssignId] != $aid && $fetAlertImeiInfo[tgai_inoutStatus] == 1 && $fetAlertInfo[tgai_alertCount] < $nooftime) {
            //print_r($fetAlertImeiInfo);
            if ($inout == 'in' && $inorout == $inout) {
                $smsStatus = sendSMSAlert($aid, $devDateTime);
                if ($smsStatus) {
                    $data['tgai_assignDevId'] = $devImei;
                    $data['tgai_geoAssignId'] = $aid;
                    $data['tgai_inoutStatus'] = 0;
                    $data['tgai_alertCount'] = $fetAlertInfo[tgai_alertCount] + 1;
                    $data['tgai_alertType'] = $inout;
                    $data['tgai_reachdevTime1'] = date("Y-m-d H:i:s", strtotime($devDateTime));
                    //print_r($data);
                    if ($db->query_insert("tb_geoalertinfo", $data)) {
                        $res = 1;
                    } else {
                        $res = 0;
                    }
                    echo "SMS";
                }
            } elseif ($inout == 'out' && $inorout != $inout) {
                $data['tgai_assignDevId'] = $devImei;
                $data['tgai_geoAssignId'] = $aid;
                $data['tgai_inoutStatus'] = 0;
                $data['tgai_alertCount'] = $fetAlertInfo[tgai_alertCount] + 1;
                $data['tgai_alertType'] = $inout;
                $data['tgai_reachdevTime1'] = date("Y-m-d H:i:s", strtotime($devDateTime));
                //print_r($data);
                if ($db->query_insert("tb_geoalertinfo", $data)) {
                    $res = 1;
                } else {
                    $res = 0;
                }
            }
        }
    }
}