<?php
namespace Home\Controller;
use Think\Controller;
//include '../Common/function.php';
class ManholeCoverController extends ComController {

 public function index()
    {
        $Data=I();
        $ResData=M()->query("SELECT count(a.id) as sl FROM sp_iw2017 a JOIN sp_owner b ON a.device_code=b.owner_code WHERE b.company=".$Data['companyid']." AND b.dwtype=128 and a.clzt=0;");
        $this->assign('wcl',$ResData[0]['sl']);
        $this->assign('companyid',$Data['companyid']);
        $this->display('Index/manhole_cover');
    }

    public function change()
    {
        $Data=I('');
        $page = $Data['page'];
        $size = 20;
        $startpage=($page - 1) * 20;
        switch ($Data['type'])
        {
            case 'untreated':
                $sql = "select a.id,a.device_status,a.time,b.owner_name,a.clzt from sp_iw2017 a join sp_owner b on a.device_code=b.owner_code  where b.company=".$Data['companyid']." and b.dwtype=128 and a.clzt=0 order by time desc limit ".$startpage.",".$size;
                break;
            case 'treated':
                $sql = "select a.id,a.device_status,a.time,b.owner_name,a.clzt from sp_iw2017 a join sp_owner b on a.device_code=b.owner_code  where b.company=".$Data['companyid']." and b.dwtype=128 and a.clzt=1 order by time desc limit ".$startpage.",".$size;
                break;
            default:
                $sql = "select a.id,a.device_status,a.time,b.owner_name,a.clzt from sp_iw2017 a join sp_owner b on a.device_code=b.owner_code  where b.company=".$Data['companyid']." and b.dwtype=128 order by time desc limit ".$startpage.",".$size;
                break;
        }
        $ResData=M()->query($sql);
        echo json_encode($ResData);
//        print_r($ResData);exit();
//        $this->assign('ResData',$ResData);
//        $this->display('Index/manhole_cover-list');
    }


//    //无用
//    public function change1()
//     {
//        $Data=I('');
//		$Map['company']=$Data['companyid'];
//		$type=$Data['type'];
//		//echo $type;exit();
//		 switch ($type)
//		     {
//		     	case 'untreated':
//                    $ResData=M()->query("select sp_hj2017.time, sp_hj2017.data2, sp_owner.owner_name, sp_hj2017.clzt, sp_hj2017.id, sp_hj2017.data4 from sp_owner join sp_hj2017 on sp_owner.owner_code=sp_hj2017.device_code where company=".$Map['company']." and clzt=0 order by time desc");
//		     		break;
//			    case 'treated':
//                    $ResData=M()->query("select sp_hj2017.time, sp_hj2017.data2, sp_owner.owner_name, sp_hj2017.clzt, sp_hj2017.id, sp_hj2017.data4 from sp_owner join sp_hj2017 on sp_owner.owner_code=sp_hj2017.device_code where company=".$Map['company']." and clzt=1 order by time desc");
//		     		break;
//		     	default:
//                    $ResData=M()->query("select sp_hj2017.time, sp_hj2017.data2, sp_owner.owner_name, sp_hj2017.clzt, sp_hj2017.id, sp_hj2017.data4 from sp_owner join sp_hj2017 on sp_owner.owner_code=sp_hj2017.device_code where company=".$Map['company']." order by time desc");
//
//                    break;
//		     }
////		     echo $clzt;exit();
////	    $ResData=M('v_hj2017')->where($Map)->select();
////        $ResData=M()->query("select sp_hj2017.time, sp_hj2017.data2, sp_owner.owner_name, sp_hj2017.clzt, sp_hj2017.id, sp_hj2017.data4 from sp_owner join sp_hj2017 on sp_owner.owner_code=sp_hj2017.device_code where company=".$Map['company']." and ".$clzt." order by time desc");
//		$this->assign('ResData',$ResData);
//        $this->display('Index/fire-list');
//     }
}

?>