admin1/Home/Controller/ProjectController.class.php.bak.20200601

<?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();
        $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)
            $this->mtReturn(200,'删除成功'.$Data['id']);
        else
            $this->mtReturn(300,'删除失败');
    }
    public function project_edit(){
        $Data=I();
        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':
                $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){
                    echo json_encode(array('statusCode'=> 200,'message'=>'编辑成功'+$detail));
                }else{
                    echo json_encode(array('statusCode'=> 300,'message'=>'编辑失败，请确认是否有内容更新'));
                }
                break;
            case 'savadevice':
                $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){
                    echo json_encode(array('statusCode'=> 200,'message'=>'编辑成功'));
                }else{
                    echo json_encode(array('statusCode'=> 300,'message'=>'编辑失败，请确认是否有内容更新'));
                }
                break;
            case 'savamonitor':
                $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){
                    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);
                    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){
                    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']}')";
                $res1=addDataInfo($addmonitorsql);
                    echo $res1;

                break;
        }

    }
}