admin1/Home/Controller/ProjectController.class.php

<?php
namespace Home\Controller;
use Think\Controller;
include '../Common/function.php';
class ProjectController extends ComController {
    public function index(){
        $Data=I();
        if(isset($Data['list'])){

            $GetPage=$Data['pageCurrent'];//第几页
            $GetSize=$Data['pageSize'];//每页条数
            $Page=($GetPage-1)*$GetSize;
//            $Map=array();
//            if(!empty($Data['company_code'])){
//                $Map['company_code']=$Data['company_code'];
//            }


            //明天 連貫操作sp_owner
            if(!empty($Data['company_code'])) {
                $Countsql = "SELECT COUNT(*) AS tp_count FROM ytiot_t_project_details where company_code = '{$Data['company_code']}'";
                $Count = selcount($Countsql);
            }else{
                $Countsql = "SELECT COUNT(*) AS tp_count FROM ytiot_t_project_details";
                $Count = selcount($Countsql);
            }
//            $List=M('owner_compare as o')
//                ->join('sp_owner as p on o.device_id=p.owner_code')
////                ->join('sp_owner_company as c on p.company=c.owner_id')
//                ->limit($Page,$GetSize)
//                ->field('o.device_id,o.bao_id,p.owner_name,p.company')
//                ->where($Map)
//                ->select();
            if(!empty($Data['company_code'])) {
                $Listsql = "SELECT * FROM ytiot_t_project_details where company_code = '{$Data['company_code']}' LIMIT $Page,$GetSize";
                $List = add($Listsql);
            }else{
                $Listsql = "SELECT * FROM ytiot_t_project_details LIMIT $Page,$GetSize";
                $List = add($Listsql);
            }
            $list2 =array();
            foreach ($List as $key=>$value){
                $Companysql="SELECT device_num FROM ytiot_t_project_device WHERE company_code = {$value['company_code']}";
                $Company=add($Companysql);
                $device_num=0;
                foreach ($Company as $key1=>$value1){
                    if ($key1==0){
                    $device_num=$value1['device_num'];
                    }else{
                        $device_num+=$value1['device_num'];
                    }
                }
                $list2[$key]['company_code'] = $value['company_code'];
                $list2[$key]['company_name'] = $value['company_name'];
                $list2[$key]['company_username'] = $value['company_username'];
                $list2[$key]['company_phone'] = $value['company_phone'];
                $list2[$key]['approach_time'] = $value['approach_time'];
                $list2[$key]['complete_time'] = $value['complete_time'];
                $list2[$key]['check_time'] = $value['check_time'];
                $list2[$key]['device_num'] = $device_num;
            }
            $Info = array(
                'totalRow' => $Count,
                'list'     => $list2,
            );
            echo json_encode($Info);
        }
        else
        {
            $this->display();
        }

    }
    public function deldata(){
        $Data=I();
        if (session('power')==2){
            $this->mtReturn(300,'本账号没有该权限，如需开通请联系管理员',1);
        }else {
            $wx_sql = "SELECT * FROM ytiot_t_project_monitor where company_code = ".$Data['id'];
            $used_data = add($wx_sql);
            $wx_sql1 = "SELECT * FROM ytiot_t_project_details where company_code = ".$Data['id'];
            $used_data1 = add($wx_sql1);
            $wx_sql2 = "SELECT * FROM ytiot_t_project_device where company_code = ".$Data['id'];
            $used_data2 = add($wx_sql2);
            $ressql1="delete from ytiot_t_project_monitor where company_code = '{$Data['id']}'";
            $res1=addDataInfo($ressql1);
            $ressql2="delete from ytiot_t_project_details where company_code = '{$Data['id']}'";
            $res2=addDataInfo($ressql2);
            $ressql3="delete from ytiot_t_project_device where company_code = '{$Data['id']}'";
            $res3=addDataInfo($ressql3);
            if($res1&&$res2&&$res3){
                //日志开始
                $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---删除项目信息配置删除单位编号：'.$Data['id']."\r\n";
                $data_log1 ='删除前ytiot_t_project_monitor表数据：'.json_encode($used_data)."\r\n";
                $data_log2 ='删除前ytiot_t_project_details表数据：'.json_encode($used_data1)."\r\n";
                $data_log3 ='删除前ytiot_t_project_device表数据：'.json_encode($used_data2)."\r\n";
                file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                file_put_contents($filename_log, $data_log2, FILE_APPEND|LOCK_EX);
                file_put_contents($filename_log, $data_log3, FILE_APPEND|LOCK_EX);
                //日志开始结束
                $this->mtReturn(200,'删除成功'.$Data['id']);
            }else{
                $this->mtReturn(300,'删除失败');
            }


        }

    }
    public function project_edit(){
        $Data=I();
        if (session('power')==2){
            $this->mtReturn(300,'本账号没有该权限，如需开通请联系管理员',1);
        }else {
            switch ($Data['type']) {
                case 'edit':
                    //company
                    $Listsql = "SELECT * FROM ytiot_t_project_details where company_code = '{$Data['code']}'";
                    $List = add($Listsql);
                    $this->assign('list',$List[0]);
                    $Listsql1 = "SELECT * FROM ytiot_t_project_device where company_code = '{$Data['code']}'";
                    $List1 = add($Listsql1);
                    $this->assign('list1',$List1);
                    $Listsql2 = "SELECT * FROM ytiot_t_project_monitor where company_code = '{$Data['code']}'";
                    $List2 = add($Listsql2);
                    $this->assign('list2',$List2);
                    $this->display();
                    break;
                case 'savacompany':
                    $wx_sql = "SELECT * FROM ytiot_t_project_details where company_code = '{$Data['company_code']}'";
                    $wx = add($wx_sql);
                    $detailsql="update ytiot_t_project_details set company_name='{$Data['company_name']}',company_username='{$Data['company_username']}',company_phone='{$Data['company_phone']}',approach_time='{$Data['approach_time']}',complete_time='{$Data['complete_time']}',check_time='{$Data['check_time']}' where company_code = '{$Data['company_code']}'";
                    $detail=addDataInfo($detailsql);
                    if($detail){
                        //日志代码开始
                        $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---项目信息配置编辑(ytiot_t_project_details表)单位编号：'.$Data['company_code']."数据\r\n";
                        $data_log1 ='修改前数据：'.json_encode($wx)."\r\n";
                        $data_log2 ='修改的数据：'.json_encode($Data)."\r\n";
                        $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                        file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                        file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                        file_put_contents($filename_log, $data_log2, FILE_APPEND|LOCK_EX);
                        //日志代码结束
                        echo json_encode(array('statusCode'=> 200,'message'=>'编辑成功'+$detail));
                    }else{
                        echo json_encode(array('statusCode'=> 300,'message'=>'编辑失败，请确认是否有内容更新'));
                    }
                    break;
                case 'savadevice':
                    $wx_sql = "SELECT * FROM ytiot_t_project_device where id = '{$Data['device_id']}'";
                    $wx = add($wx_sql);
                    $devicesql="update ytiot_t_project_device set device_name='{$Data['device_name']}',specifications='{$Data['specifications']}',device_num={$Data['device_num']},data_info='{$Data['data_info']}' where id = {$Data['device_id']}";
                    $device=addDataInfo($devicesql);
                    if($device){
                        //日志代码开始
                        $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---项目信息配置编辑(ytiot_t_project_device表)ID：'.$Data['device_id']."数据\r\n";
                        $data_log1 ='修改前数据：'.json_encode($wx)."\r\n";
                        $data_log2 ='修改的数据：'.json_encode($Data)."\r\n";
                        $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                        file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                        file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                        file_put_contents($filename_log, $data_log2, FILE_APPEND|LOCK_EX);
                        //日志代码结束
                        echo json_encode(array('statusCode'=> 200,'message'=>'编辑成功'));
                    }else{
                        echo json_encode(array('statusCode'=> 300,'message'=>'编辑失败，请确认是否有内容更新'));
                    }
                    break;
                case 'savamonitor':
                    $wx_sql = "SELECT * FROM ytiot_t_project_monitor where id = '{$Data['monitor_id']}'";
                    $wx = add($wx_sql);
                    $monitorsql="update ytiot_t_project_monitor set monitor_son='{$Data['monitor_son']}',monitor_type='{$Data['monitor_type']}',monitor_sum={$Data['monitor_sum']},data_info='{$Data['data_info']}' where id = {$Data['monitor_id']}";
                    $monitor=addDataInfo($monitorsql);
                    if($monitor){
                        //日志代码开始
                        $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---项目信息配置编辑(ytiot_t_project_monitor表)ID：'.$Data['monitor_id']."数据\r\n";
                        $data_log1 ='修改前数据：'.json_encode($wx)."\r\n";
                        $data_log2 ='修改的数据：'.json_encode($Data)."\r\n";
                        $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                        file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                        file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                        file_put_contents($filename_log, $data_log2, FILE_APPEND|LOCK_EX);
                        //日志代码结束
                        echo json_encode(array('statusCode'=> 200,'message'=>'编辑成功'));
                    }else{
                        echo json_encode(array('statusCode'=> 300,'message'=>'编辑失败，请确认是否有内容更新'));
                    }
                    break;
            }
        }

    }
    public function add(){
        $Data=I();
        switch ($Data['type']) {
            case 'project':
                //company
                $company=M('owner_company')->select();
                $this->assign('companylist',$company);
                $this->display();
                break;
            case 'sevaport':
                $adddevicesql="insert into ytiot_t_project_device values('','{$Data['device_name']}','{$Data['specifications']}',{$Data['device_num']},'{$Data['company_code']}','{$Data['data_info']}')";
                $res=addDataInfo($adddevicesql);
                $data=array('device_name'=>$Data['device_name'],'specifications'=>$Data['specifications'],'device_num'=>$Data['device_num'],'company_code'=>$Data['company_code'],'data_info'=>$Data['data_info']);
                //日志开始
                $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'项目信息配置新增（ytiot_t_project_device表）\r\n';
                $data_log1 ='新增数据：'.json_encode($data)."\r\n";
                file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                //日志结束
                    echo $res;

                break;
            case 'savacompany':
                $company1=M('owner_company')->where(array('owner_id'=> $Data['company_code']))->select();
                $addcompanysql="insert into ytiot_t_project_details values('','{$Data['company_code']}','{$company1['0']['owner_name']}','{$Data['company_username']}','{$Data['company_phone']}','{$Data['approach_time']}','{$Data['complete_time']}','{$Data['check_time']}')";
                $res=addDataInfo($addcompanysql);
                if($res){
                    $data =array('company_code'=>$Data['company_code'],'company_name'=>$company1['0']['owner_name'],'company_username'=>$Data['company_username'],'company_phone'=>$Data['company_phone'],'approach_time'=>$Data['approach_time'],'complete_time'=>$Data['complete_time'],'check_time'=>$Data['check_time']);
                    //日志开始
                    $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                    $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'项目信息配置新增（ytiot_t_project_details表）\r\n';
                    $data_log1 ='新增数据：'.json_encode($data)."\r\n";
                    file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                    file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                    //日志结束
                    echo json_encode(array('statusCode'=> 200,'message'=>'新增成功'));
                }else{
                    echo json_encode(array('statusCode'=> 300,'message'=>'新增失败'));
                }
                break;
            case 'sevamonitor':
                $addmonitorsql="insert into ytiot_t_project_monitor values('','{$Data['monitor_son']}','{$Data['monitor_type']}',{$Data['monitor_sum']},'{$Data['company_code']}','{$Data['data_info']}')";
                $data = array('monitor_son'=>$Data['monitor_son'],'monitor_type'=>$Data['monitor_type'],'monitor_sum'=>$Data['monitor_sum'],'company_code'=>$Data['company_code'],'data_info'=>$Data['data_info']);
                //日志开始
                $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'项目信息配置新增(ytiot_t_project_monitor表)\r\n';
                $data_log1 ='新增数据：'.json_encode($data)."\r\n";
                file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                //日志结束
                $res1=addDataInfo($addmonitorsql);
                    echo $res1;

                break;
        }

    }
}