IDCOL/api/application/controllers/Home.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

include_once(FCPATH . 'application/controllers/Base_Controller.php');
class Home extends Base_Controller {

    public function __construct() {
        parent::__construct();
        $this->load->model('Lamp_model');
    }

    // 设备统计信息
    public function data(){
    	$data = array(
    		'day_new_count' => 0,
    		'day_faulty_count' => 0,
    		'total_light_count' => 0,
    		'light_up_count' => 0,
    		'online_count' => 0,
    		'faulty_count' => 0,
    	);

        $date = date('Y-m-d 00:00:00',time());

        $role = $this->get_user_info('role');
        if ($role == SYSTEM_ADMIN) {
            $data['total_light_count'] = $this->Lamp_model->get_count();
            $data['day_new_count'] = $this->Lamp_model->get_count(['createtime >='=>$date]);

            $join = [['table'=>'network as N','cond'=>'N.id = L.networkid','type'=>'inner']];
            $total = $this->Lamp_model->get_list_by_multi_join(['N.status'=>1,'L.logtime >='=>$date,'L.devstatus !='=>0], 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['day_faulty_count'] = $total['total'];

            $join = [['table'=>'network as N','cond'=>'N.id = L.networkid','type'=>'inner']];
            $total = $this->Lamp_model->get_list_by_multi_join(['N.status'=>1,'L.status'=>1], 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['light_up_count'] = $total['total'];

            $join = [['table'=>'network as N','cond'=>'N.id = L.networkid','type'=>'inner']];
            $total = $this->Lamp_model->get_list_by_multi_join(['N.status'=>1], 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['online_count'] = $total['total'];

            $join = [['table'=>'network as N','cond'=>'N.id = L.networkid','type'=>'inner']];
            $total = $this->Lamp_model->get_list_by_multi_join(['N.status'=>1,'L.devstatus !='=>0], 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['faulty_count'] = $total['total'];
        }else{
            $company = $this->get_user_info('company');
            $where = ['P.company'=>$company];
            $join = [
                ['table'=>'project as P','cond'=>'P.id = L.projectid','type'=>'inner']
            ];
            $total = $this->Lamp_model->get_list_by_multi_join($where, 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['total_light_count'] = $total['total'];

            $where['L.createtime >='] = $date;
            $total = $this->Lamp_model->get_list_by_multi_join($where, 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['day_new_count'] = $total['total'];
            unset($where['L.createtime >=']);

            $join[] = ['table'=>'project as P','cond'=>'P.id = L.projectid','type'=>'inner'];
            $where['N.status'] = 1;
            $total = $this->Lamp_model->get_list_by_multi_join($where, 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['online_count'] = $total['total'];

            $where['L.status'] = 1;
            $total = $this->Lamp_model->get_list_by_multi_join($where, 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['light_up_count'] = $total['total'];
            unset($where['L.status']);

            $where['L.devstatus !='] = 0;
            $total = $this->Lamp_model->get_list_by_multi_join($where, 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['faulty_count'] = $total['total'];

            $where['L.devstatus !='] = 0;
            $where['L.logtime >='] = $date;
            $total = $this->Lamp_model->get_list_by_multi_join($where, 'count(*) as total',NULL, NULL, $join, NULL, NUll, 'L', true);
            $data['day_faulty_count'] = $total['total'];
        }

    	exit(json_result('0000',$this->response['0000'],$data));
    }

    // 发用电量统计信息
    public function sta_info(){
    	$data = array(
    		'electricity' => 0,
    		'CO2_reduction' => 0,
    		'SO2_reduction' => 0,
    		'TCE_reduction' => 0
    	);

    	exit(json_result('0000',$this->response['0000'],$data));
    }

    // 设备统计列表
    public function dev_list(){

    	exit(json_result('0000',$this->response['0000'],array('list'=>array())));
    }

    // 故障信息列表
    public function alarm_list(){

    	exit(json_result('0000',$this->response['0000'],array()));
    }

    // 字段管理
    public function fields(){
        $userid = $this->get_user_info('id');
        $data = $this->User_model->get_user_field($userid);
        if (empty($data) || empty($data['lampfield'])) {
            $fieldstr = "number,lampstatus,updatetime,lighteness,address,lamppower,chargestage,battvoltage,overtimes,solarpower,isfaulted,status,section";
        }else{
            if ($data['lampfield'] == 'number,lampstatus,updatetime,lighteness,address,lamppower,chargestage,battvoltage,overtimes,solarpower,isfaulted,status') {
                $data['lampfield'] .= ',section';
            }
            $fieldstr = $data['lampfield'];
        }

        // 系统默认
        $def = array(
            array('name'=>'路灯编号','field'=>'L.number','fields1'=>'number','enname'=>'Lamp number'),
            array('name'=>'路段','field'=>'L.section','fields1'=>'section','enname'=>'Road'),
            array('name'=>'路灯状态','field'=>'L.status as lampstatus,L.lighteness','fields1'=>'lampstatus','enname'=>'Lamp status'),
            array('name'=>'信号状态','field'=>'N.protocoltype,N.status as status,N.rssi,N.snr','fields1'=>'status','enname'=>'Network status'),
            array('name'=>'更新时间','field'=>'L.logtime as updatetime','fields1'=>'updatetime','enname'=>'Update time'),
            array('name'=>'路灯亮度(%)','field'=>'L.lighteness','fields1'=>'lighteness','enname'=>'Brightness(%)'),
            array('name'=>'无线模块地址','field'=>'L.address','fields1'=>'address','enname'=>'Wireless module address'),
            array('name'=>'路灯功率(W)','field'=>'L.lamppower','fields1'=>'lamppower','enname'=>'Lamp power(W)'),
            array('name'=>'蓄电池充电阶段','field'=>'L.chargestage','fields1'=>'chargestage','enname'=>'Charging stage'),
            array('name'=>'蓄电池电压(V)','field'=>'L.battvoltage','fields1'=>'battvoltage','enname'=>'Battery voltage(V)'),
            array('name'=>'蓄电池总过放次数','field'=>'L.overtimes','fields1'=>'overtimes','enname'=>'Over discharge times'),
            array('name'=>'太阳能板功率(W)','field'=>'L.solarpower','fields1'=>'solarpower','enname'=>'Solar panel power(W)'),
            array('name'=>'是否故障','field'=>'L.isfaulted','fields1'=>'isfaulted','enname'=>'Fault'),
        );

        // 路灯信息
        $lampinfo = array(
            array('name'=>'当前策略','field'=>'L.policyid','fields1'=>'policyid','enname'=>'Current strategy'),
            array('name'=>'路灯id','field'=>'L.id','fields1'=>'id','enname'=>'Lamp ID'),
            array('name'=>'网络名称','field'=>'N.networkname','fields1'=>'networkname','enname'=>'Network name'),
            array('name'=>'项目名称','field'=>'P.projectname','fields1'=>'projectname','enname'=>'Project name'),
            array('name'=>'经度','field'=>'L.longitude','fields1'=>'longitude','enname'=>'Longitude'),
            array('name'=>'纬度','field'=>'L.latitude','fields1'=>'latitude','enname'=>'Latitude'),
            array('name'=>'sim卡号','field'=>'N.simid','fields1'=>'simid','enname'=>'SIM card number'),
            array('name'=>'套餐剩余','field'=>'N.packageSurplus','fields1'=>'packageSurplus','enname'=>'Package surplus'),
            array('name'=>'路灯类型','field'=>'L.lamptype','fields1'=>'lamptype','enname'=>'Lamp type'),
            array('name'=>'太阳能板类型','field'=>'L.boardtype','fields1'=>'boardtype','enname'=>'Solar panel type'),
            array('name'=>'太阳能板功率(W)','field'=>'L.boardpower','fields1'=>'boardpower','enname'=>'Solar panel power(W)'),
            array('name'=>'蓄电池类型','field'=>'L.batterytype','fields1'=>'batterytype','enname'=>'Battery type'),
            array('name'=>'蓄电池AH数(ah)','field'=>'L.batteryah','fields1'=>'batteryah','enname'=>'Battery capacity(ah)'),
            array('name'=>'负载功率(W)','field'=>'L.loadpower','fields1'=>'loadpower','enname'=>'Load power(W)'),
            array('name'=>'蓄电池剩余电量','field'=>'L.electricleft','fields1'=>'electricleft','enname'=>'Remaining battery capacity(Ah)'),
        );

        // 路灯信息日志
        $lamp_info_log = array(
            array('name'=>'路灯电压(V)','field'=>'L.lampvoltage','fields1'=>'lampvoltage','enname'=>'Lamp voltage(V)'),
            array('name'=>'路灯电流(A)','field'=>'L.lampcurrent','fields1'=>'lampcurrent','enname'=>'Lamp current(A)'),
            array('name'=>'灯头温度(℃)','field'=>'L.lamptemper as temper','fields1'=>'temper','enname'=>'Lamp temperature(℃)'),
        );

        $solar_info_log = array(
            array('name'=>'太阳能板电压(V)','field'=>'L.solarvoltage','fields1'=>'solarvoltage','enname'=>'Solar panel voltage(V)'),
            array('name'=>'太阳能板电流(A)','field'=>'L.solarcurrent','fields1'=>'solarcurrent','enname'=>'Solar panel current(A)')
        );

        // 蓄电池信息日志
        $battery_info_log = array(
            array('name'=>'蓄电池状态','field'=>'L.battstatus','fields1'=>'battstatus','enname'=>'Battery status'),
            array('name'=>'蓄电池充电电流(A)','field'=>'L.chargecurrent','fields1'=>'chargecurrent','enname'=>'Charging current(A)'),
            array('name'=>'蓄电池放电电流(A)','field'=>'L.discharcurrent','fields1'=>'discharcurrent','enname'=>'Discharging current(A)'),
            array('name'=>'蓄电池充电功率(w)','field'=>'L.chargepower','fields1'=>'chargepower','enname'=>'Charging power(w)'),
            array('name'=>'蓄电池放电功率(w)','field'=>'L.dischargepower','fields1'=>'dischargepower','enname'=>'Discharging power(w)'),
            array('name'=>'蓄电池表面温度(℃)','field'=>'L.batttemper','fields1'=>'batttemper','enname'=>'Battery surface temperature(℃)'),
            array('name'=>'蓄电池总电量','field'=>'L.electrictotal','fields1'=>'electrictotal','enname'=>'Total battery capacity(Ah)'),
            array('name'=>'蓄电池电量SOC(%)','field'=>'L.electricSOC','fields1'=>'electricSOC','enname'=>'Battery SOC(%)'),
            array('name'=>'当天最低电压(V)','field'=>'L.voltagedaymin','fields1'=>'voltagedaymin','enname'=>'Minimum voltage(V)'),
            array('name'=>'当天最高电压(V)','field'=>'L.voltagedaymax','fields1'=>'voltagedaymax','enname'=>'Highest voltage(V)'),
            array('name'=>'当天充电安时数(ah)','field'=>'L.daychargeah','fields1'=>'daychargeah','enname'=>'Charging AH(ah)'),
            array('name'=>'当天放电安时数(ah)','field'=>'L.daydischarah','fields1'=>'daydischarah','enname'=>'Discharging AH(ah)'),
            array('name'=>'当天充电最大功率(W)','field'=>'L.daychargemaxpow','fields1'=>'daychargemaxpow','enname'=>'Charging max-power(W)'),
            array('name'=>'当天放电最大功率(W)','field'=>'L.daydischarmaxpow','fields1'=>'daydischarmaxpow','enname'=>'Discharging max-power(W)'),
            array('name'=>'当天灯亮时间(hh:mm)','field'=>'L.daychargemincurrent','fields1'=>'daychargemincurrent','enname'=>'Turn-on duration'),
            array('name'=>'当天充电最大电流(A)','field'=>'L.daycharmaxcurrent','fields1'=>'daycharmaxcurrent','enname'=>'Highest charging current(A)'),
            array('name'=>'当天充电时间(hh:mm)','field'=>'L.daydischargemincurrent','fields1'=>'daydischargemincurrent','enname'=>'Charging duration'),
            array('name'=>'当天放电最大电流(A)','field'=>'L.daydischarmaxcurrent','fields1'=>'daydischarmaxcurrent','enname'=>'Highest discharging current(A)'),
            array('name'=>'当天蓄电池最低温度(℃)','field'=>'L.daybattmintemper','fields1'=>'daybattmintemper','enname'=>'Battery min-temperature(℃)'),
            array('name'=>'当天蓄电池最高温度(℃)','field'=>'L.daybattmaxtemper','fields1'=>'daybattmaxtemper','enname'=>'Battery max-temperature(℃)'),
        );

        $electric_info_log = array(
            array('name'=>'当天发电量(kWh)','field'=>'L.daygeneration','fields1'=>'daygeneration','enname'=>'Power generation(kWh)'),
            array('name'=>'当天用电量(kWh)','field'=>'L.dayconsumption','fields1'=>'dayconsumption','enname'=>'Power consumption(kWh)'),
            array('name'=>'累计发电量(kWh)','field'=>'L.totalgeneration','fields1'=>'totalgeneration','enname'=>'Cumulative power generation(kWh)'),
            array('name'=>'累计用电量(kWh)','field'=>'L.totalconsumption','fields1'=>'totalconsumption','enname'=>'Cumulative power consumption(kWh)'),
        );

        $system_info_log = array(
            array('name'=>'系统电压(V)','field'=>'L.sysvoltage','fields1'=>'sysvoltage','enname'=>'System voltage(V)'),
            array('name'=>'系统电流(A)','field'=>'L.syscurrent','fields1'=>'syscurrent','enname'=>'System current(A)'),
            array('name'=>'控制器温度(℃)','field'=>'L.temper as controlTemper','fields1'=>'controlTemper','enname'=>'Controller temperature(℃)'),
        );

        // 历史信息日志
        $history_info_log = array(
            array('name'=>'运行天数','field'=>'L.rundays','fields1'=>'rundays','enname'=>'Running duration'),
            array('name'=>'蓄电池总充满次数','field'=>'L.fulltimes','fields1'=>'fulltimes','enname'=>'Full charge times'),
            array('name'=>'蓄电池总充电安时数(ah)','field'=>'L.totalchargeah','fields1'=>'totalchargeah','enname'=>'Total charge AH(ah)'),
            array('name'=>'蓄电池总放电安时数(ah)','field'=>'L.totaldischarah','fields1'=>'totaldischarah','enname'=>'Total discharge AH(ah)'),
        );
        $fields = array_merge($def,$lampinfo,$lamp_info_log,$solar_info_log,$battery_info_log,$electric_info_log,$system_info_log,$history_info_log);
        $def = explode(',', $fieldstr);
        foreach ($fields as &$v) {
            if (in_array($v['fields1'], $def)) {
                $v['select'] = '1';
            }else{
                $v['select'] = '0';
            }
        }
        exit(json_result('0000',$this->response['0000'],array('list'=>$fields)));
    }

    // 路灯下拉列表
    public function lamp_list(){
        $networkid = intval($this->input->post('networkid',true));
        $projectid = intval($this->input->post('projectid',true));
        if (empty($networkid) && empty($projectid)) {
            exit(json_result('0405',$this->response['0405'],array()));
        }
        if (!empty($networkid)) {
            $data = $this->Lamp_model->get_list(array('networkid'=>$networkid), 'number,id');
        }else{
            $data = $this->Lamp_model->get_list(array('projectid'=>$projectid), 'number,id');
        }
        exit(json_result('0000',$this->response['0000'],$data));
    }

    // 获取单个路灯的经纬度
    public function get_lng_lat(){
        $lampid = $this->input->post('lampid',true);
        $projectid = $this->input->post('projectid',true);
        $section = $this->input->post('section',true);
        $lampData = array();
        if (!empty($lampid)) {
            $where = array('id'=>$lampid,'longitude !='=>0,'latitude !='=>0);
            if (!empty($section)) {
                $where['section'] = $section;
            }
            $lampData = $this->Lamp_model->get_one($where,'longitude,latitude');
        }
        if (!empty($projectid)) {
            $where = array('projectid'=>$projectid,'longitude !='=>0,'latitude !='=>0);
            if (!empty($section)) {
                $where['section'] = $section;
            }
            $lampData = $this->Lamp_model->get_one($where,'longitude,latitude');
        }

        if (empty($lampData)) {
            $lampData = array('longitude'=>0,'latitude'=>0);
        }
        exit(json_result('0000',$this->response['0000'],$lampData));
    }
}