<?php
header('content-type:text/html;charset=utf-8');

//日志打印
function log_Printing($Data,$log_name){
    $log = "[时间" . date("Y-m-d H:i:s") . "]报警数据：" . json_encode($Data) . "\r\n";
    $filename_log = "/var/www/html/jdxf/log/".$log_name . date("Y-m-d") . ".log";
    file_put_contents($filename_log, $log, FILE_APPEND | LOCK_EX);
    return 1;
}

function http_post_advertise($url,$data){        //封装curl方法
    $ch = curl_init();     //初始化
    curl_setopt($ch, CURLOPT_URL, $url);      //请求地址
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, true);
//https协议需要以下两行，否则请求不成功
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
//post方法所需要的参数
    curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
//    curl_setopt($ch, CURLOPT_HTTPHEADER,array());
    $result = curl_exec($ch);
    curl_close($ch);
    return $result;        //返回所获取的方法
}

function displaycounter($counterfile) {
    $fp = fopen($counterfile,"rw");
    $num = fgets($fp,5);
    $num += 1;
//        print "您是第 "."$num"." 个看巴泷计数器的家伙";
    exec( "rm -rf $counterfile");
    exec( "echo $num > $counterfile");
    return $num;
}

//function ala_bj_js(){
//    $counterfile = "balong.txt";//存储数值的文件名几路径
//
//
//    if (!file_exists($counterfile)) {
//        exec( "echo 0 > $counterfile");
//    }
//
//    displaycounter($counterfile);
//}


function http_post_advertise1($url,$data){        //封装curl方法
    $header  = array(
        'appKey:'.'748935525548687361',
        'Content-Type:'.'application/json'
    );
    $ch = curl_init();     //初始化
    curl_setopt($ch, CURLOPT_URL, $url);      //请求地址
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, true);
//https协议需要以下两行，否则请求不成功
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
//post方法所需要的参数
    curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
    curl_setopt($ch, CURLOPT_HTTPHEADER,$header);
    $result = curl_exec($ch);
    curl_close($ch);
    return $result;        //返回所获取的方法
}

function addInt($sql){
    $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'jdxf', 3306);
    mysqli_query($link,"set character set 'utf8'");
    $res1 = mysqli_query($link,$sql);
    //mysqli_free_result($res1);
    mysqli_close($link);
    return $res1;

}
//报警主机未处理总数量
function fireIndex($company){
    $link = mysqli_connect('127.0.0.1', 'root', 'Yt2018IoT', 'jdxf', 3306);
    $sql  = "SELECT COUNT(*) FROM sp_owner, sp_hj2017 WHERE sp_hj2017.device_code=sp_owner.owner_code AND sp_owner.company=".$company." AND sp_hj2017.clzt=0";
    $result = mysqli_query($link, $sql);
    $row = $result->fetch_assoc();
    $row=$row['COUNT(*)'];
    mysqli_free_result($result);
    mysqli_close($link);
    return $row;
}

//水系统未处理总数量
function indexOne($company){
    $link = mysqli_connect('127.0.0.1', 'root', 'Yt2018IoT', 'jdxf', 3306);

    $sql  = "SELECT COUNT(*) FROM sp_owner, sp_sj2017 WHERE sp_sj2017.device_code=sp_owner.owner_code AND sp_owner.company=".$company." AND sp_sj2017.clzt=0";
    $result = mysqli_query($link, $sql);
    $row = $result->fetch_assoc();
    $row=$row['COUNT(*)'];
    //echo $row;
    mysqli_free_result($result);
    mysqli_close($link);
    return $row;
}

//测控终端未处理总数量
function measureIndex($company){
    $link = mysqli_connect('127.0.0.1', 'root', 'Yt2018IoT', 'jdxf', 3306);
    $sql  = "select COUNT(*) from sp_v_rtu2017_2 where company=".$company." AND sp_v_rtu2017_2.clzt=0";
    $result = mysqli_query($link, $sql);
    $row = $result->fetch_assoc();
    $row=$row['COUNT(*)'];
    mysqli_free_result($result);
    mysqli_close($link);
    return $row;
}


function fireinfoIndex($id){
    $link = mysqli_connect('127.0.0.1', 'root', 'Yt2018IoT', 'jdxf', 3306);
    $sql  = "select sp_sj2017.id, sp_sj2017.clwb, sp_sj2017.time, sp_sj2017.device_code, sp_sj2017.data4, sp_sj2017.clzt, sp_sj2017.data1,sp_sj2017.clr, sp_sj2017.clsj, sp_sj2017.clnr, sp_owner.company, sp_owner.dwtype, sp_owner.owner_name,sp_owner_company.h5 from sp_owner JOIN sp_sj2017 ON sp_sj2017.device_code=sp_owner.owner_code JOIN sp_owner_company on sp_owner.company=sp_owner_company.owner_id WHERE sp_sj2017.id=".$id;
    $result = mysqli_query($link,$sql);
    while ($row = $result->fetch_assoc()) {
        if ($row['dwtype'] == 5){
            if ($row['data1'] == 'LL1'){
                $row['wtype']='低位';
            }else if($row['data1'] == 'LL2'){
                $row['wtype']='高位';
            }else if($row['data1'] == 'LL4'){
                $row['wtype']= '离线';
            }else{
                $row['wtype']= $row['data1'];
            }
        }else if ($row['dwtype'] == 2){
            if ($row['data1'] == 'WP1'){
                $row['wtype']= '低压';
            }else if ($row['data1'] == 'WP2'){
                $row['wtype']= '高压';
            }else if ($row['data1'] == 'WP4'){
                $row['wtype']= '离线';
            }else{
                $row['wtype']= $row['data1'];
            }
        }else{
            $row['wtype']= $row['dwtype'];
        }

        if ($row['clzt'] == 0){
            $row['clstatus']= '未处理';
        }else if ($row['clzt'] == 1){
            $row['clstatus']= '已处理';
        }else{
            $row['clstatus']= $row['clzt'];
        }
        $data[]=$row;
    }
    mysqli_free_result($result);
    mysqli_close($link);
    return $data;

}

function add($sql){
    $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytIoT', 3306);
    mysqli_query($link,"set character set 'utf8'");
    $res1 = mysqli_query($link,$sql);
    $list=array();
//    print_r($sql);
//    exit();
//    if (!empty($row = $res1->fetch_assoc())){
        while ($row = $res1->fetch_assoc()) {
            $list[]=$row;
        }
        mysqli_free_result($res1);
        mysqli_close($link);
        return $list;
//    }else{
//        mysqli_free_result($res1);
//        mysqli_close($link);
//        return null;
//    }


}

function add66($sql){
    $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytIoT', 3306);
    mysqli_query($link,"set character set 'utf8'");
    $res1 = mysqli_query($link,$sql);
    if($res1==FALSE){
        return $list=null;
    }
    $list=array();
    while ($row = $res1->fetch_assoc()) {
        $list[]=$row;
    }
    mysqli_free_result($res1);
    mysqli_close($link);
    return $list;
}

function addDataInfo($sql){
    $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytIoT', 3306);
    mysqli_query($link,"set character set 'utf8'");
    $res1 = mysqli_query($link,$sql);
    //mysqli_free_result($res1);
    mysqli_close($link);
    return $res1;

}

function add88($sql){
    $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'jdxf', 3306);
    mysqli_query($link,"set character set 'utf8'");
    $res1 = mysqli_query($link,$sql);
    //mysqli_free_result($res1);
    mysqli_close($link);
    return $res1;

}

//    获取本月第一天
function getthemonth($date)
{
    $firstday = date('Y-m-01', strtotime($date));
    $lastday = date('Y-m-d', strtotime("$firstday +1 month -1 day"));
    return $firstday;
}

//获取本周第一天
function getzy($date)
{
    $first=1;
    $w=date('w',strtotime($date));
    $week_start=date('Y-m-d',strtotime("$date -".($w ? $w - $first : 6).' days'));
    return $week_start;
}

function  wxts($url,$array){
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
    curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (compatible; MSIE 5.01; Windows NT 5.0)');
    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
    curl_setopt($ch, CURLOPT_AUTOREFERER, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $array);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    $info = curl_exec($ch);
    if (curl_errno($ch)) {
        $info = 'ERROR: ' . curl_error($ch);
    }
    curl_close($ch);
}


function ytapi_query($sql){
    $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytapi', 3306);
    mysqli_query($link,"set character set 'utf8'");
    $res1 = mysqli_query($link,$sql);
    if($res1==FALSE){
        return $list=null;
    }
    $list=array();
    while ($row = $res1->fetch_assoc()) {
        $list[]=$row;
    }
    mysqli_free_result($res1);
    mysqli_close($link);
    return $list;
}

function ytapi_insert($sql){
    $link = mysqli_connect('47.98.201.187', 'root', 'Yt2018IoT', 'ytapi', 3306);
    mysqli_query($link,"set character set 'utf8'");
    $res1 = mysqli_query($link,$sql);
    //mysqli_free_result($res1);
    mysqli_close($link);
    return $res1;

}