IDCOL/api/application/controllers/Lampcontrol.php

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

include_once(FCPATH . 'application/controllers/Base_Controller.php');
class Lampcontrol extends Base_Controller {
	
    private $chargeStageMap = array(0=>'没有充电',16=>'MPPT充电',32=>'均衡充电',48=>'提升充电',64=>'浮充',''=>'未知状态');

    public function __construct() {
        parent::__construct();
        $this->load->model('Company_model');
        $this->load->model('Project_model');
        $this->load->model('Network_model');
        $this->load->model('Lamp_model');
        $this->load->model('Batmanage_model');
        $this->load->model('Patrol_model'); 
        $this->load->model('Load_model');
        $this->load->model('Battery_model');
        $this->load->model('Alarm_model');
        // $this->load->model('Zone_model');
        $this->load->model('Videomonitor_model');
        $this->load->model('Modbus_load_model');
        $this->load->model('Modbus_battery_model');
        $this->load->model('Global_location_model');
        $this->load->model('RealtimeInfoLog_model');
    }

    // 灯控列表
    public function get() {
        $userid = $this->get_user_info('id');
        $role = $this->get_user_info('role');
        $company = $this->input->post('company',true);

        $project_id = intval($this->input->post('project_id', true));
        if (empty($project_id)) exit(json_result('0007',$this->response['0007']));
        $fields = $this->input->post('fields', true);
        $field1 = $this->input->post('field1', true);
        $pid_arr = $project_id;
        $timezone = $this->Project_model->get_timezone_by_projectid($project_id);

        $filter = 'L.projectid = '.$project_id;
        $countWhere = array('projectid = '.$project_id);
        $network_id = $this->input->post('network_id', true);
        $section = $this->input->post('section', true);
        $type = intval($this->input->post('type', true));
        $company = intval($this->input->post('company', true));
        if (!empty($type) && !empty($company)) {
            
            if ($type == 2) {
                $filter .= ' AND L.manu = '.$company;
                $countWhere[] = 'manu = '.$company;
            }elseif ($type == 3) {
                $filter .= ' AND L.supplier = '.$company;
                $countWhere[] = 'supplier = '.$company;
            }elseif ($type == 4) {
                $filter .= ' AND L.po = '.$company;
                $countWhere[] = 'po = '.$company;
            }else {
                $filter .= ' AND P.cityid = '.$company;
            }
        }
        if (!empty($section)) {
            $filter .= ' AND L.section = "'.$section.'"';
            $countWhere[] = 'section = "'.$section.'"';
        }
        $offline = $this->input->post('offline', true);
        if (!empty($offline)) {
            $filter .= ' AND L.netstatus = 0';
            $countWhere[] = 'netstatus = 0';
        }
        $online = $this->input->post('online', true);
        if (!empty($online)) {
            $filter .= ' AND L.netstatus= 1';
            $countWhere[] = 'netstatus = 1';
        }

        // 分页数据
        $page = intval($this->input->post('page',true));
        $page = empty($page) ? 1 : $page;
        $count = intval($this->input->post('count',true));
        $limit = empty($count) ? 10 : $count;
        $offset = ($page - 1)*$count;

        $keyword = $this->input->post('keyword', true);
        if ($keyword !== '' && $keyword !== null) {
            $filter .= ' AND (L.number like "%'.$keyword.'%" OR L.section like "%'.$keyword.'%" OR L.address like "%'.$keyword.'%")';
            $countWhere[] = '(number like "%'.$keyword.'%" OR section like "%'.$keyword.'%" OR address like "%'.$keyword.'%")';
        }

        $status = $this->input->post('status', true);
        if (!empty($status)) {
            // $filter['AI.isfaulted'] = $status;
            $filter .= ' AND (AI.batstatus != 0 OR AI.panelstatus != 0 OR AI.lampstatus != 0 OR AI.tempstatus != 0)';
        }
        // $alarmtype = $this->input->post('alarmtype', true);
        // if (!empty($alarmtype)) $filter['AI.alarmtype'] = $alarmtype;
        // 记录用户选择的字段
        if (!empty($field1)) {
            $fieldData = array('userid'=>$userid,'lampfield'=>$field1);
            $this->User_model->update_user_field($fieldData);
        }

        $lite = $this->input->post('lite', true);
        $version = $this->session->userdata('version');
        if ($lite == 1) {
            if(empty($fields)){
                $fields = 'L.id, L.number,L.address,RI.updatetime,RI.loadpower,RI.batvoltage as battvoltage,L.netstatus,L.lighteness,L.status,L.battstatus,L.chargestage';
            }else{
                $fields .= ",RI.updatetime";
            }
            $join = array();
            $join[] = ['table'=>'(select t1.* from realtime_info_log t1, (select lampid, max(updatetime) as maxtime from realtime_info_log group by lampid) t2 where t1.lampid = t2.lampid and t1.updatetime = t2.maxtime) as RI', 'cond'=>'L.id = RI.lampid', 'type'=>'left'];
            $data['lamps'] = $this->Lamp_model->get_list_by_join($filter, $fields,$limit, $offset, $join, "L.number ASC", NUll, 'L');
        } else {
            if(empty($fields) || empty($field1)){
                $fields = 'L.id, L.number, IFNULL(L.status,0) as status, L.isfaulted, L.address, L.lamppower, L.electricSOC, L.battvoltage, L.chargestage, RI.updatetime, RI.updatetime as modifytime,L.overtimes,L.boardpower,L.lighteness as light,L.projectid,L.devstatus as online,P.projectname as project_name,L.section,L.loadtype,P.timezone as timezoneid';
            }else{
                $fields .= ",L.id,L.projectid,L.section,L.loadtype,P.timezone as timezoneid";
            }

            $download = intval($this->input->post('download',true));
            if (!empty($download)) {
                $limit = null;
                $offset = null;
            }

            $join = array();

            $join[] = ['table'=>'project as P', 'cond'=>'L.projectid = P.id', 'type'=>'left'];
            // $join[] = ['table'=>'(select t1.* from alarm_info_log t1, (select lampid, max(updatetime) as maxtime from alarm_info_log group by lampid) t2 where t1.lampid = t2.lampid and t1.updatetime = t2.maxtime) as AI', 'cond'=>'L.id = AI.lampid', 'type'=>'left'];
            $join[] = ['table'=>'(select t1.* from warning_info_log t1, (select lampid, max(updatetime) as maxtime from warning_info_log group by lampid) t2 where t1.lampid = t2.lampid and t1.updatetime = t2.maxtime) as AI', 'cond'=>'L.id = AI.lampid', 'type'=>'left'];
            $join[] = ['table'=>'(select t1.* from history_info_log t1, (select lampid, max(updatetime) as maxtime from history_info_log group by lampid) t2 where t1.lampid = t2.lampid and t1.updatetime = t2.maxtime) as HI', 'cond'=>'L.id = HI.lampid', 'type'=>'left'];
            $join[] = ['table'=>'(select t1.* from realtime_info_log t1, (select lampid, max(updatetime) as maxtime from realtime_info_log group by lampid) t2 where t1.lampid = t2.lampid and t1.updatetime = t2.maxtime) as RI', 'cond'=>'L.id = RI.lampid', 'type'=>'left'];
            $data['lamps'] = $this->Lamp_model->get_list_by_join($filter, $fields,$limit, $offset, $join, "L.number ASC", NUll, 'L');
            // $data['lamps'] = $this->Lamp_model->get_list_in('L.projectid', $pid_arr, $fields, $filter);
            // var_dump(microtime());
            $indexArr = [2=>'16',3=>'32',4=>'48',5=>'64'];
            if (empty($version)) {
                $chargeStageMap = array(0=>'没有充电',1=>'启动充电',6=>'限流',7=>'充满',16=>'MPPT充电',32=>'均衡充电',48=>'提升充电',64=>'浮充',''=>'未知状态');
                $battstatusArr = array(0=>'空闲',1=>'放电',2=>'充电',3=>'一边充电一边放电',''=>'未知状态');
                $unknown = '未知状态';
            }else{
                $chargeStageMap = array(0=>'There is no charge',1=>'Start charging',6=>'Current limiting',7=>'Full',16=>'MPPT charging',32=>'Equalizing charge',48=>'Improve charging',64=>'Floating',''=>'Unknown state');
                $battstatusArr = array(0=>'Free',1=>'Discharge',2=>'Charge',3=>'Discharge while charging',''=>'Unknown state');
                $unknown = 'Unknown state';
            }
            if (!empty($download)) {
                $fieldArr = explode(',', $field1);
                $fieldArr[] = 'iccid';

                $temp = [];
                $i = 1;
                foreach ($data['lamps'] as $key => &$value) {
                    $value['section'] = empty($value['section']) ? '' : $value['section'];
                    if (isset($value['updatetime']) && $value['updatetime'] == '0000-00-00 00:00:00') {
                        $value['updatetime'] = null;
                    }
                    if (array_key_exists('lamppower',$value)) {
                        $value['lamppower']   = !empty($value['lamppower']) ? $value['lamppower'] : "0";
                    }
                    // 故障信息处理
                    if (array_key_exists('alarmStatus',$value)) {
                        if (empty($value['batstatus']) && $value['panelstatus'] && $value['lampstatus'] && $value['tempstatus']) {
                            if (empty($version)) {
                                $value['isfaulted'] = '无';
                            }else{
                                $value['isfaulted'] = 'Nothing';
                            }
                            
                        }else{
                            $batstatus = $this->config->item('batstatus');
                            $panelstatus = $this->config->item('panelstatus');
                            $lampstatus = $this->config->item('lampstatus');
                            $tempstatus = $this->config->item('tempstatus');
                            $temp2 = array();
                            if (isset($batstatus[$value['batstatus']])) $temp2[] = $batstatus[$value['batstatus']];
                            if (isset($panelstatus[$value['panelstatus']])) $temp2[] = $panelstatus[$value['panelstatus']];
                            if (isset($lampstatus[$value['lampstatus']])) $temp2[] = $lampstatus[$value['lampstatus']];
                            if (isset($tempstatus[$value['tempstatus']])) $temp2[] = $tempstatus[$value['tempstatus']];
                            if (!empty($temp2)) {
                                $value['isfaulted'] = implode(',', $temp2);
                            }else{
                                $value['isfaulted'] = 'Nothing';
                            }
                                
                        }
                    }
                    if (array_key_exists('lampstatus',$value)) {
                        $value['lampstatus'] = !empty($value['lampstatus']) ? $value['lampstatus'] : "0";
                    }
                    if (array_key_exists('electricSOC',$value)) {
                        $value['electricSOC'] = !empty($value['electricSOC']) ? $value['electricSOC'] : "0";
                    }
                    if (array_key_exists('battvoltage',$value)) {
                        $value['battvoltage'] = !empty($value['battvoltage']) ? $value['battvoltage'] : "0";
                    }
                    if (array_key_exists('chargestage',$value)) {
                        $value['chargestage'] = isset($value['chargestage']) ? $chargeStageMap[$value['chargestage']] : $unknown;
                    }
                    if (array_key_exists('battstatus',$value)) {
                        $value['battstatus'] = isset($value['battstatus']) ? $battstatusArr[$value['battstatus']] : $unknown;
                    }
                    if (array_key_exists('overtimes',$value)) {
                        $value['overtimes'] = !empty($value['overtimes']) ? $value['overtimes'] : 0;
                    }
                    if (array_key_exists('solarpower',$value)) {
                        $value['solarpower'] = !empty($value['solarpower']) ? $value['solarpower'] : 0;
                    }
                    if (array_key_exists('iccid',$value)) {
                        $value['iccid'] = !empty($value['iccid']) ? $value['iccid'] : '';
                    }
                    if (array_key_exists('updatetime',$value)) {
                        $value['updatetime']   = !empty($value['updatetime']) ? $value['updatetime'] : '';
                        // 通过时区修改时间
                        if (!empty($value['updatetime'])) {
                            $timezone = $this->Project_model->get_timezone_by_projectid($value['projectid']);
                            if ($timezone['value'] != 8) {
                                $value['updatetime'] = date_change($value['updatetime'],8,$timezone['value']);
                            }
                        }
                    }
                    // 当前策略
                    if (array_key_exists('policyid',$value)) {
                        if (empty($value['policyid'])) {
                            $value['policyid'] = '';
                        }else{
                            $policyData = $this->db->query('select name from policy_info where id = '.$value['policyid'])->row_array();
                            if (empty($policyData) || empty($policyData['name'])) {
                                $value['policyid'] = '';
                            }else{
                                $value['policyid'] = $policyData['name'];
                            }
                        }
                    }
                    
                    $temp[$key][] = $i;
                    foreach ($fieldArr as $f) {
                        if ($f == 'lampstatus') {
                            if (empty($version)) {
                                $temp[$key][] = empty($value[$f]) ? '关灯' : '开灯';
                            }else{
                                $temp[$key][] = empty($value[$f]) ? 'off' : 'on';
                            }
                            continue;
                        }
                        if ($f == 'status') {
                            if (empty($version)) {
                                $temp[$key][] = empty($value[$f]) ? '不在线' : '在线';
                            }else{
                                $temp[$key][] = empty($value[$f]) ? 'off-line' : 'online';
                            }
                            continue;
                        }
                        if ($f == 'daychargemincurrent' || $f == 'daydischargemincurrent') {
                            $t = floor($value[$f]/3600) < 10 ? '0'.floor($value[$f]/3600) : floor($value[$f]/3600);
                            $m = ceil($value[$f]%3600/60) < 10 ? '0'.ceil($value[$f]%3600/60) : ceil($value[$f]%3600/60);
                            $temp[$key][] = $t.':'.$m;
                            continue;
                        }

                        $temp[$key][] = $value[$f];
                    }
                    $i ++;
                }
                $title1 = get_fields_by_type($field1,$version);
                if (empty($version)) {
                    $title2 = array_merge(array('编号'),$title1);
                }else{
                    $title2 = array_merge(array('Number'),$title1);
                }
                $title = [];
                foreach ($title2 as $t) {
                    $title[0][] = $t;
                }
                $title[0][] = 'iccid';
                $data = array_merge($title,$temp);
                $path = push_excel($data,'lampinfoExcel_'.date('Ymd'));
                exit(json_result('0000', $this->response['0000'], array('path'=>$path)));
            }

            foreach ($data['lamps'] as $key => &$value) {
                $value['section'] = empty($value['section']) ? '' : $value['section'];
                if (isset($value['updatetime']) && $value['updatetime'] == '0000-00-00 00:00:00') {
                    $value['updatetime'] = null;
                }
                if (array_key_exists('lamppower',$value)) {
                    $value['lamppower']   = !empty($value['lamppower']) ? $value['lamppower'] : "0";
                }

                // 故障信息处理
                if (array_key_exists('alarmStatus',$value)) {
                    if (empty($value['batstatus']) && $value['panelstatus'] && $value['lampstatus'] && $value['tempstatus']) {
                        if (empty($version)) {
                            $value['isfaulted'] = '无';
                        }else{
                            $value['isfaulted'] = 'Nothing';
                        }
                        
                    }else{
                        $batstatus = $this->config->item('batstatus');
                        $panelstatus = $this->config->item('panelstatus');
                        $lampstatus = $this->config->item('lampstatus');
                        $tempstatus = $this->config->item('tempstatus');
                        $temp2 = array();
                        if (isset($batstatus[$value['batstatus']])) $temp2[] = $batstatus[$value['batstatus']];
                        if (isset($panelstatus[$value['panelstatus']])) $temp2[] = $panelstatus[$value['panelstatus']];
                        if (isset($lampstatus[$value['lampstatus']])) $temp2[] = $lampstatus[$value['lampstatus']];
                        if (isset($tempstatus[$value['tempstatus']])) $temp2[] = $tempstatus[$value['tempstatus']];
                        if (!empty($temp2)) {
                            $value['isfaulted'] = implode(',', $temp2);
                        }else{
                            $value['isfaulted'] = 'Nothing';
                        }
                            
                    }
                }

                if (array_key_exists('lampstatus',$value)) {
                    $value['lampstatus'] = !empty($value['lampstatus']) ? $value['lampstatus'] : "0";
                }
                if (array_key_exists('electricSOC',$value)) {
                    $value['electricSOC'] = !empty($value['electricSOC']) ? $value['electricSOC'] : "0";
                }
                if (array_key_exists('battvoltage',$value)) {
                    $value['battvoltage'] = !empty($value['battvoltage']) ? $value['battvoltage'] : "0";
                }
                if (array_key_exists('chargestage',$value)) {
                    $value['chargestage'] = isset($value['chargestage']) && isset($chargeStageMap[$value['chargestage']]) ? $chargeStageMap[$value['chargestage']] : $unknown;
                }
                if (array_key_exists('battstatus',$value)) {
                    $value['battstatus'] = isset($value['battstatus']) ? $battstatusArr[$value['battstatus']] : $unknown;
                }
                if (array_key_exists('overtimes',$value)) {
                    $value['overtimes'] = !empty($value['overtimes']) ? $value['overtimes'] : 0;
                }
                if (array_key_exists('solarpower',$value)) {
                    $value['solarpower'] = !empty($value['solarpower']) ? $value['solarpower'] : 0;
                }
                // 当前策略
                if (array_key_exists('policyid',$value)) {
                    if (empty($value['policyid'])) {
                        $value['policyid'] = '';
                    }else{
                        $policyData = $this->db->query('select name from policy_info where id = '.$value['policyid'])->row_array();
                        if (empty($policyData) || empty($policyData['name'])) {
                            $value['policyid'] = '';
                        }else{
                            $value['policyid'] = $policyData['name'];
                        }
                    }
                }

                if (array_key_exists('updatetime',$value)) {
                    $value['updatetime']   = !empty($value['updatetime']) ? $value['updatetime'] : '';

                    // 通过时区修改时间
                    if (!empty($value['updatetime'])) {
                        // $value['timezoneid'];
                        if($timezone === null) $timezone = $this->db->query('select value from timezone where id = '.$value['timezoneid'])->row_array();
                        // var_dump($timezone);die;
                        $value['updatetime'] = set_timezone($value['updatetime'],$timezone['value']); 
                        // if ($timezone['value'] != 8) {
                        //     $value['updatetime'] = date_change($value['updatetime'],0,$timezone['value']);
                        // }
                    }
                }
            }
            if (!empty($project_id)) {
                
            }
        }

        // unset($filter['page']);
        // unset($filter['count']);
        $countWheret1 = implode(' AND ', $countWhere);
        $data['total_data']['install_num'] = $this->Lamp_model->get_count($countWheret1);
        $countWheret = $countWhere;
        $countWheret[] = 'lighteness > 0';
        $countWheret[] = 'netstatus = 1';
        $countWheret1 = implode(' AND ', $countWheret);
        $data['total_data']['light_num'] = $this->Lamp_model->get_count($countWheret1);
        $countWheret = $countWhere;
        $countWheret[] = 'netstatus = 1';
        $countWheret1 = implode(' AND ', $countWheret);
        $data['total_data']['online_num'] = $this->Lamp_model->get_count($countWheret1);

        $filter2 = $filter.' AND (AI.batstatus != 0 OR AI.panelstatus != 0 OR AI.lampstatus != 0 OR AI.tempstatus != 0)';
        $join2 = array();
        $join2[] = ['table'=>'project as P', 'cond'=>'L.projectid = P.id', 'type'=>'left'];
        $join2[] = ['table'=>'(select lampid,max(updatetime) as maxTime from warning_info_log group by lampid) as WI','cond'=>'WI.lampid = L.id','type'=>'inner'];
        $join2[] = ['table'=>'warning_info_log as AI','cond'=>'WI.lampid = AI.lampid AND WI.maxTime = AI.updatetime','type'=>'inner'];
        $res = $this->Lamp_model->get_list_by_multi_join($filter2, 'count(*) total',null, null, $join2, "L.number ASC", NUll, 'L',true);

        $data['total_data']['fault_count'] = $res['total'];
        $data['total_data']['light_rate'] = empty($data['total_data']['install_num']) ? '0' : round($data['total_data']['light_num']/$data['total_data']['install_num'],4)*100;
        $data['total_data']['light_rate'] .= '%';
        $data['total_data']['online_rate'] = empty($data['total_data']['install_num']) ? '0' : round($data['total_data']['online_num']/$data['total_data']['install_num'],4)*100;
        $data['total_data']['online_rate'] .= '%';
        $data['total_data']['fault_rate'] = empty($data['total_data']['install_num']) ? '0' : round($data['total_data']['fault_count']/$data['total_data']['install_num'],4)*100;
        $data['total_data']['fault_rate'] .= '%';
        // $data['total_data']['network_num'] = $this->Network_model->get_count(['projectid'=>$project_id,'type'=>1]);

        // $res = $this->Lamp_model->get_list_by_multi_join($filter, 'count(*) total',$limit, $offset, $join, "L.number ASC", NUll, 'L',true);
        // $result = !empty($pid_arr) ? $this->Lamp_model->get_count(['projectid'=>$pid_arr]) : array();

        $result = $this->Lamp_model->get_count(['projectid'=>$pid_arr]);
        $data['total'] = $result;
        $data['count'] = $result;
        // $data['fault'] = $res['total'];
        exit(json_result('0000', $this->response['0000'], $data));
    }

    // 更新灯控信息
    public function update() {
        $role = $this->get_user_info('role');
        $username = $this->input->post('username',true);
        $client_key = $this->input->post('client_key',true);
        $token = $this->input->post('token',true);
        $type = intval($this->input->post('type',true));
        $lamp_id = $this->input->post('lamp_id',true);


        $lamp_id = $this->input->post('lamp_id', true);
        if (empty($lamp_id)) {
            exit(json_result('0411', $this->response['0411'], array()));
        }
        $ids = explode(',', $lamp_id);
        $list = $this->Lamp_model->get_list(['id'=>$ids],'address');
        $cmd = empty($type) ? '01' : '02';
        foreach ($list as $v) {

            $this->send_cmd('18',$v['address'],$cmd,'0000000000','0100',0);

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

    // 灯控的开启/关闭(支持批量处理)
    public function turnonoff(){
        $username = $this->input->post('username',true);
        $role = $this->input->post('role',true);
        $client_key = $this->input->post('client_key',true);
        $token = $this->input->post('token',true);
        $type = intval($this->input->post('type',true));
        $lamp_id = $this->input->post('lamp_id',true);
        $clientid = $this->input->post('clientid',true);
        $version = $this->session->userdata('version');

        $lampArr = explode(',', $lamp_id);

        $url = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['SERVER_NAME'].'/api/lampcontrol/dimming_asy';
        $lightness = empty($type) ? 0 : 100;
        foreach ($lampArr as $l) {
            doAsyncRequest($url,['clientid'=>$clientid,'username'=>$username,'client_key'=>$client_key,'token'=>$token,'version'=>$version,'type'=>$type,'lamp_id'=>$l,'lightness'=>$lightness,'role'=>$role]);
        }
        
        exit();
    }

    // 灯控调光
    public function dimming(){
        $username = $this->input->post('username',true);
        $role = $this->input->post('role',true);
        $client_key = $this->input->post('client_key',true);
        $token = $this->input->post('token',true);
        $lamp_id = $this->input->post('lamp_id',true);
        $lightness = $this->input->post('lightness',true);
        $clientid = $this->input->post('clientid',true);
        $version = $this->session->userdata('version');

        $lampArr = explode(',', $lamp_id);

        // $lampList = $this->Lamp_model->get_list_in('L.id', $lampArr, 'L.id,N.protocoltype', array());
        $url = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['SERVER_NAME'].'/api/lampcontrol/dimming_asy';
        
        foreach ($lampArr as $l) {
            doAsyncRequest($url,['clientid'=>$clientid,'username'=>$username,'client_key'=>$client_key,'token'=>$token,'version'=>$version,'lamp_id'=>$l,'lightness'=>$lightness,'role'=>$role]);
        }
        
        exit();
    }

    public function dimming_asy(){
        set_time_limit(0);
        $lamp_id = intval($this->input->post('lamp_id',true));
        $lightness = intval($this->input->post('lightness',true));
        $clientid = $this->input->post('clientid',true);
        $version = $this->input->post('version',true);
        if (empty($lamp_id)) {
            exit(json_result('0400', $this->response['0400'], array()));
        }
        $lampData = $this->Lamp_model->get_one(['id'=>$lamp_id],'number,address,id');

        $seq = get_seq();
        $seq = '01';

        // $sendData = '14'.PROTOCOL_VERSION.$seq.'0000000000';
        $sendData = $lightness > 0 ? '01' : '00';
        $lightness2 = empty($lightness) ? '00' : '00'.base_convert($lightness, 10, 16);
        $sendData .= strlen($lightness2) == 2 ? $lightness2 : substr($lightness2, -2);
        $sendData .= '00';

        // $sendData .= crc16(pack('H*',$sendData));
        // $res = lampMqttCmd('/IDCOL/CmdInput/'.$lampData['address'],'/IDCOL/CmdOutput/'.$lampData['address'],pack('H*',$sendData),10);
        $res = $this->send_cmd('14',$lampData['address'],$sendData);
        
        if (empty($res)) {
            $data = ['code'=>'0016','status'=>2,'msg'=>$this->response['0016'],'data'=>['number'=>$lampData['number'],'type'=>'dimming','id'=>$lamp_id]];
            exit(send_websocket($clientid,$data));
        }else{
            $res['msg'] = unpack('H*', $res['msg'])[1];

            set_log('dimming_asy.txt',$res['msg']);
            if (strtolower(crc16(pack('H*',substr($res['msg'], 0,-4)))) == strtolower(substr($res['msg'], -4)) && strtolower(substr($res['msg'], 18,2)) == '01') {
                if ($lightness != 0) {
                    $this->Lamp_model->update(array('status'=>1,'lighteness'=>$lightness),array('id'=>$lampData['id']));
                }else{
                    $this->Lamp_model->update(array('status'=>0,'lighteness'=>0),array('id'=>$lampData['id']));
                }

                $lampData = $this->Lamp_model->get_project_company(array('L.id'=>$lamp_id),'P.projectname,L.number,L.address');
                $this->add_operation_log('cmd',"\"{$lampData['projectname']}\"项目下的编号为\"{$lampData['number']}\"、无线模块地址为\"{$lampData['address']}\"的路灯调光\"{$lightness}%\"",0);
                $this->add_operation_log('cmd',"Light dimming:\"{$lampData['number']}\".Wireless module address:\"{$lampData['address']}\".Project name:\"{$lampData['projectname']}\".Lighteness:\"{$lightness}%\"",0,1);
                $data = ['code'=>'0000','status'=>2,'msg'=>$this->response['0000'],'data'=>['number'=>$lampData['number'],'type'=>'dimming','id'=>$lamp_id]];
                exit(send_websocket($clientid,$data));
            }else{
                $data = ['code'=>'0010','status'=>2,'msg'=>$this->response['0010'],'data'=>['number'=>$lampData['number'],'type'=>'dimming','id'=>$lamp_id]];
                exit(send_websocket($clientid,$data));
            }
        }

    }

    // 删除灯控(支持批量处理)
    public function del(){
        $role = $this->get_user_info('role');

        $lamp_ids = $this->input->post('lamp_ids',true);
        if (empty($lamp_ids)) {
            exit(json_result('0400', $this->response['0400'], array()));
        }

        $ids = explode(",", $lamp_ids);

        // 获取灯控信息
        $dataArr = $this->Lamp_model->get_list(['id'=>$ids]);

        // 修改网络跟项目下灯控数量
        foreach ($dataArr as $data) {
            $temp = array();
            $temp['faultcount'] = $data['isfaulted'] > 0 ? 1 : 0;
            $temp['lampcount'] = 1;
            $temp['projectid'] = $data['projectid'];
            // $this->Network_model->minus_lamp_count($data);
            $this->Project_model->minus_lamp_count($temp);
            // $netData = $this->Network_model->getOne($data['networkid'],'gatewaytype,protocoltype');
            // if ($netData['protocoltype'] == 6) $this->remove_device('00000000'.$data['address']);
            // if (isset($netData) && $netData['gatewaytype'] == 'direct' && !empty($data['networkid'])) {// 直连设备
            //     // 删除网络
            //     // $this->Zone_model->delOne($data['networkid']);
            //     $this->Network_model->delData(array('id'=>$data['networkid']));
            //     $cmdstr = '{"cmd_type":"delete_network_cmd","cmd_id":'.$data['networkid'].'}';
            //     // send_cmd($cmdstr,0);
            //     if (isset($netData['protocoltype']) && $netData['protocoltype'] != 0) {
            //         $cmdret = send_cmd($cmdstr,1,0,$netData['protocoltype']);
            //         if ($cmdret === false) {
            //             sleep(1);
            //             $cmdret = send_cmd($cmdstr,1,0,$netData['protocoltype']);
            //         }
            //     }else{
            //         $cmdret = send_cmd($cmdstr,0,0,$netData['protocoltype']);
            //         if ($cmdret === false) {
            //             sleep(1);
            //             $cmdret = send_cmd($cmdstr,0,0,$netData['protocoltype']);
            //         }
            //     }
            // }
        }
        // 删除灯控告警信息
        $this->Alarm_model->delete(['lampid'=>$ids]);

        foreach ($ids as $v) {
            $lampData = $this->Lamp_model->get_project_company(array('L.id'=>$v),'P.projectname,L.number,L.address');
            $this->add_operation_log('delete',"删除\"{$lampData['projectname']}\"项目下的编号为\"{$lampData['number']}\"、无线模块地址为\"{$lampData['address']}\"的路灯",0);
            $this->add_operation_log('delete',"Delete lamp:\"{$lampData['number']}\".Wireless module address:\"{$lampData['address']}\".Project name:\"{$lampData['projectname']}\"",0,1);
        }
        $this->Lamp_model->delete(['id'=>$ids]);
        $this->RealtimeInfoLog_model->delete(['lampid'=>$ids]);

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

    // 更新负载设置
    public function modbus_set_load(){
        $data['username'] = $this->input->post('username',true);
        $data['client_key'] = $this->input->post('client_key',true);
        $data['token'] = $this->input->post('token',true);
        $data['lamp_id'] = $this->input->post('lamp_id',true);
        $data['clientid'] = $this->input->post('clientid',true);
        $data['version'] = $this->session->userdata('version');
        $data['role'] = $this->input->post('role',true);

        // $data['light_voltage']         = $this->input->post('light_voltage',true);
        $data['intell_power']    = $this->input->post('intell_power',true);
        $data['light_type']   = $this->input->post('light_type',true);
        $data['load_current']   = $this->input->post('load_current',true);
        $data['first_light_time']    = $this->input->post('first_light_time',true);
        $data['first_light_human_power']   = $this->input->post('first_light_human_power',true);
        $data['first_light_unman_power']    = $this->input->post('first_light_unman_power',true);
        $data['second_light_time']   = $this->input->post('second_light_time',true);
        $data['second_light_human_power']       = $this->input->post('second_light_human_power',true);
        $data['second_light_unman_power']        = $this->input->post('second_light_unman_power',true);
        $data['third_light_time']   = $this->input->post('third_light_time',true);
        $data['third_light_human_power']         = $this->input->post('third_light_human_power',true);
        $data['third_light_unman_power']    = $this->input->post('third_light_unman_power',true);
        $data['fourth_light_time']    = $this->input->post('fourth_light_time',true);
        $data['fourth_light_human_power']    = $this->input->post('fourth_light_human_power',true);
        $data['fourth_light_unman_power']    = $this->input->post('fourth_light_unman_power',true);
        $data['fifth_light_time']    = $this->input->post('fifth_light_time',true);
        $data['fifth_light_human_power']    = $this->input->post('fifth_light_human_power',true);
        $data['fifth_light_unman_power']    = $this->input->post('fifth_light_unman_power',true);
        $data['sixth_light_time']    = $this->input->post('sixth_light_time',true);
        $data['sixth_light_human_power']    = $this->input->post('sixth_light_human_power',true);
        $data['sixth_light_unman_power']    = $this->input->post('sixth_light_unman_power',true);
        $data['seventh_light_time']    = $this->input->post('seventh_light_time',true);
        $data['seventh_light_human_power']    = $this->input->post('seventh_light_human_power',true);
        $data['seventh_light_unman_power']    = $this->input->post('seventh_light_unman_power',true);
        $data['tenth_light_time']    = $this->input->post('tenth_light_time',true);
        $data['tenth_light_human_power']    = $this->input->post('tenth_light_human_power',true);
        $data['tenth_light_unman_power']    = $this->input->post('tenth_light_unman_power',true);
        // foreach ($data as $key => $value) {
        //     $data[$key] = urldecode($value);
        // }
        $lampArr = explode(',', $data['lamp_id']);
        // $lampList = $this->Lamp_model->get_list_in('L.id', $lampArr, 'L.id,N.protocoltype', array());
        $url = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['SERVER_NAME'].'/api/lampcontrol/set_load_asy';
        foreach ($lampArr as $l) {
            $data['lamp_id'] = $l;
            var_dump($url);
            doAsyncRequest($url,$data);
        }
    }

    public function set_load_asy(){
        $file = fopen('../upload/test.txt', 'w');
        fwrite($file, 'string');
        fclose($file);
        $clientid = $this->input->post('clientid',true);
        $lampid = $this->input->post('lamp_id',true);

        $data['intell_power']    = $this->input->post('intell_power',true);
        $data['light_type']   = $this->input->post('light_type',true);
        $data['load_current']   = $this->input->post('load_current',true);
        $data['first_light_time']    = $this->input->post('first_light_time',true);
        $data['first_light_human_power']   = $this->input->post('first_light_human_power',true);
        $data['first_light_unman_power']    = $this->input->post('first_light_unman_power',true);
        $data['second_light_time']   = $this->input->post('second_light_time',true);
        $data['second_light_human_power']       = $this->input->post('second_light_human_power',true);
        $data['second_light_unman_power']        = $this->input->post('second_light_unman_power',true);
        $data['third_light_time']   = $this->input->post('third_light_time',true);
        $data['third_light_human_power']         = $this->input->post('third_light_human_power',true);
        $data['third_light_unman_power']    = $this->input->post('third_light_unman_power',true);
        $data['fourth_light_time']    = $this->input->post('fourth_light_time',true);
        $data['fourth_light_human_power']    = $this->input->post('fourth_light_human_power',true);
        $data['fourth_light_unman_power']    = $this->input->post('fourth_light_unman_power',true);
        $data['fifth_light_time']    = $this->input->post('fifth_light_time',true);
        $data['fifth_light_human_power']    = $this->input->post('fifth_light_human_power',true);
        $data['fifth_light_unman_power']    = $this->input->post('fifth_light_unman_power',true);
        $data['sixth_light_time']    = $this->input->post('sixth_light_time',true);
        $data['sixth_light_human_power']    = $this->input->post('sixth_light_human_power',true);
        $data['sixth_light_unman_power']    = $this->input->post('sixth_light_unman_power',true);
        $data['seventh_light_time']    = $this->input->post('seventh_light_time',true);
        $data['seventh_light_human_power']    = $this->input->post('seventh_light_human_power',true);
        $data['seventh_light_unman_power']    = $this->input->post('seventh_light_unman_power',true);
        $data['tenth_light_time']    = $this->input->post('tenth_light_time',true);
        $data['tenth_light_human_power']    = $this->input->post('tenth_light_human_power',true);
        $data['tenth_light_unman_power']    = $this->input->post('tenth_light_unman_power',true);

        $sendData = '';
        foreach ($data as $key => $value) {
            $word = '';
            if ($key == 'intell_power' || $key == 'light_type') {
                $word = substr('0'.base_convert($value, 10, 16), -1);
            }elseif (strpos('light_time', $key)) {
                $t = explode(':', $value);
                $m = $t[0]*60+$t[1];
                $m = round($m/10);
                $word = substr('00'.base_convert($m, 10, 16), -2);
            }elseif ($key == 'load_current') {
                $word = substr('0000'.base_convert(round($value/10), 10, 16), -4);
            }else{
                $word = substr('00'.base_convert($value, 10, 16), -2);
            }
            $sendData .= $word;
        }

        $sendData .= '0000';

        $lampData = $this->Lamp_model->getData(array('id'=>$lampid),'projectid,address,number');

        $res = $this->send_cmd('12',$lampData['address'],$sendData);

        if (!empty($res)) {
            $msg = unpack('H*', $res['msg'])[1];
            if (substr($msg, 18,2) == '02') {
                $data = ['code'=>'0010','status'=>2,'msg'=>$this->response['0010'],'data'=>['number'=>$lampData['number'],'type'=>'set_load','id'=>$lampid]];
                exit(send_websocket($clientid,$data));
            }
            $projectData = $this->Project_model->getData(array('id'=>$lampData['projectid']),'projectname');
            
            $this->add_operation_log('update',"修改\"{$projectData['projectname']}\"项目下的编号为\"{$lampData['number']}\"、无线模块地址为\"{$lampData['address']}\"的路灯负载参数");
            $this->add_operation_log('update',"Update the load setting of the street lamp:\"{$lampData['number']}\".Wireless module address:\"{$lampData['address']}\".Project name:\"{$projectData['projectname']}\".",0,1);
            $data = ['code'=>'0000','status'=>2,'msg'=>$this->response['0000'],'data'=>['number'=>$lampData['number'],'type'=>'set_load','id'=>$lampid]];
            exit(send_websocket($clientid,$data));
        }else{
            $data = ['code'=>'0016','status'=>2,'msg'=>$this->response['0016'],'data'=>['number'=>$lampData['number'],'type'=>'set_load','id'=>$lampid]];
            exit(send_websocket($clientid,$data));
        }
    }

    private function format_date($date){
        return intval(explode(':', $date)[0]) * 3600 + intval(explode(':', $date)[1]) * 60;
    }

    // 更新蓄电池设置
    public function set_battery(){
        $data['username'] = $this->input->post('username',true);
        $data['client_key'] = $this->input->post('client_key',true);
        $data['token'] = $this->input->post('token',true);
        $lamp_id = $this->input->post('lamp_id',true);
        $data['clientid'] = $this->input->post('clientid',true);
        $data['role'] = $this->input->post('role',true);
        $data['version'] = $this->session->userdata('version');
        
        $data['battery_count']                 = $this->input->post('battery_count',true);  // 电池串数
        $data['system_voltage']                 = $this->input->post('system_voltage',true);  // 电池电压
        $data['battery_type']              = $this->input->post('battery_type',true);  //蓄电池类型
        $data['overvoltage']                  = $this->input->post('overvoltage',true) * 1000;  // 超压电压
        $data['char_limit_voltage']            = $this->input->post('char_limit_voltage',true) * 1000;  // 充电限制电压
        $data['equ_char_voltage']               = $this->input->post('equ_char_voltage',true) * 1000; // 均衡充电电压
        $data['increa_char_voltage']           = $this->input->post('increa_char_voltage',true) * 1000;  // 提升充电电压
        $data['float_char_voltage']    = $this->input->post('float_char_voltage',true) * 1000;  // 浮充充电电压
        $data['increa_char_return_voltage']               = $this->input->post('increa_char_return_voltage',true) * 1000;  // 提升充电返回电压
        $data['over_dischar_return_voltage']          = $this->input->post('over_dischar_return_voltage',true) * 1000; // 过放返回电压
        $data['battery_under_voltage']           = $this->input->post('battery_under_voltage',true) * 1000;  // 欠压警告电压  新增
        $data['over_dischar_voltage']           = $this->input->post('over_dischar_voltage',true) * 1000;  // 过放电压
        $data['discharge_limit_voltage']               = $this->input->post('discharge_limit_voltage',true) * 1000;  // 放电限制电压 新增
        $data['equ_char_time']               = $this->input->post('equ_char_time',true) * 60;  // 均衡充电时间
        $data['increa_char_time']               = $this->input->post('increa_char_time',true) * 60;  // 提升充电时间
        $data['balan_char_interval']               = $this->input->post('balan_char_interval',true);  // 均衡充电间隔
        $data['temper_compen_coeff']               = $this->input->post('temper_compen_coeff',true);  // 温度补偿系数
        $data['char_upper_limit_temper']           = $this->input->post('char_upper_limit_temper',true);  // 上限温度
        $data['char_lower_limit_temper']           = $this->input->post('char_lower_limit_temper',true);  // 下限温度
        $data['reduced_start_voltage']         = $this->input->post('reduced_start_voltage',true) * 1000;  // 智能功率起始电压
        $data['reduced_stop_voltage']         = $this->input->post('reduced_stop_voltage',true) * 1000;  // 智能功率结束电压
        $data['light_voltage']         = $this->input->post('light_voltage',true);  // 光控电压
        $data['light_delay_time']         = $this->input->post('light_delay_time',true);  // 光控延时时间
        
        $lampArr = explode(',', $lamp_id);
        // $lampList = $this->Lamp_model->get_list_in('L.id', $lampArr, 'L.id,N.protocoltype', array());
        $url = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['SERVER_NAME'].'/api/lampcontrol/set_battery_asy';

        foreach ($lampArr as $l) {
            $data['lampid'] = $l;
            doAsyncRequest($url,$data);
        }
        exit();
    }

    //更新蓄电池设置
    public function set_battery_asy(){
        $clientid = $this->input->post('clientid',true);
        $where['id']                        = $this->input->post('lamp_id',true);//路灯id

        $data['system_voltage']                 = $this->input->post('system_voltage',true);  // 电池电压
        $data['battery_count']                 = $this->input->post('battery_count',true);  // 电池串数
        $data['battery_type']              = $this->input->post('battery_type',true);  //蓄电池类型
        if ($data['battery_type'] == 1 || $data['battery_type'] == 2) {
            $data['battery_count'] = 1;
        }
        $data['overvoltage']                  = $this->input->post('overvoltage',true);  // 超压电压
        $data['char_limit_voltage']            = $this->input->post('char_limit_voltage',true);  // 充电限制电压
        $data['equ_char_voltage']               = $this->input->post('equ_char_voltage',true); // 均衡充电电压
        $data['increa_char_voltage']           = $this->input->post('increa_char_voltage',true);  // 提升充电电压
        $data['float_char_voltage']    = $this->input->post('float_char_voltage',true);  // 浮充充电电压
        $data['increa_char_return_voltage']               = $this->input->post('increa_char_return_voltage',true);  // 提升充电返回电压
        $data['over_dischar_return_voltage']          = $this->input->post('over_dischar_return_voltage',true); // 过放返回电压
        $data['battery_under_voltage']           = $this->input->post('battery_under_voltage',true);  // 欠压警告电压  新增
        $data['over_dischar_voltage']           = $this->input->post('over_dischar_voltage',true);  // 过放电压
        $data['discharge_limit_voltage']               = $this->input->post('discharge_limit_voltage',true) * 60;  // 放电限制电压 新增
        $data['equ_char_time']               = $this->input->post('equ_char_time',true) * 60;  // 均衡充电时间
        $data['increa_char_time']               = $this->input->post('increa_char_time',true) * 60;  // 提升充电时间
        $data['balan_char_interval']               = $this->input->post('balan_char_interval',true);  // 均衡充电间隔
        $data['temper_compen_coeff']               = $this->input->post('temper_compen_coeff',true);  // 温度补偿系数
        $data['char_lower_limit_temper']           = $this->input->post('char_lower_limit_temper',true);  // 下限温度
        $data['char_upper_limit_temper']           = $this->input->post('char_upper_limit_temper',true);  // 上限温度
        $data['reduced_start_voltage']         = $this->input->post('reduced_start_voltage',true);  // 智能功率起始电压
        $data['reduced_stop_voltage']         = $this->input->post('reduced_stop_voltage',true);  // 智能功率结束电压
        $data['light_voltage']         = $this->input->post('light_voltage',true);  // 光控电压
        $data['light_voltage']  *= 10;
        $data['light_delay_time']         = $this->input->post('light_delay_time',true);  // 光控延时时间

        $lampData = $this->Lamp_model->get_one($where,'projectid,address,number');
        $sendData = '';
        foreach ($data as $k=>$v) {
            if ($k == 'light_voltage' || $k == 'light_delay_time' || $k == 'balan_char_interval' || $k == 'temper_compen_coeff') {
                $word = substr('00'.base_convert($v, 10, 16), -2);
            }elseif ($k == 'char_upper_limit_temper' || $k == 'char_lower_limit_temper') {
                if ($v < 0){
                    $word = '1'.substr('0000000000000000'.base_convert(substr('0000'.base_convert(abs($v), 10, 16), -4), 16, 2), -15);
                    $word = substr('0000'.base_convert($word, 2, 16), -4);
                }else{
                    $word = substr('0000'.base_convert($v, 10, 16), -4);
                }
            }elseif ($k == 'battery_type' || $k == 'battery_count') {
                $word = substr('0'.base_convert($v, 10, 16), -1);
            }elseif ($k == 'system_voltage') {
                $word = $v.'';
            }else{
                $word = substr('0000'.base_convert($v, 10, 16), -4);
            }
            
            $sendData .= $word;
        }

        $res = $this->send_cmd('10',$lampData['address'],$sendData);

        
        if (!empty($res)) {
            $projectData = $this->Project_model->get_one(array('id'=>$lampData['projectid']),'projectname');
            
            $this->add_operation_log('update',"修改\"{$projectData['projectname']}\"项目下的编号为\"{$lampData['number']}\"、无线模块地址为\"{$lampData['address']}\"的路灯蓄电池参数");
            $this->add_operation_log('update',"Update the lamp battery setting:\"{$lampData['number']}\".Wireless module address:\"{$lampData['address']}\".Project name:\"{$projectData['projectname']}\".",0,1);
            $data = ['code'=>'0000','status'=>2,'msg'=>$this->response['0000'],'data'=>['number'=>$lampData['number'],'type'=>'set_battery','id'=>$lamp_id]];
            exit(send_websocket($clientid,$data));
        }else{
            $data = ['code'=>'0016','status'=>2,'msg'=>$this->response['0016'],'data'=>['number'=>$lampData['number'],'type'=>'set_battery','id'=>$lamp_id]];
            exit(send_websocket($clientid,$data));
        }
    }

    // 添加编辑灯控
    public function save() {
        $role = $this->get_user_info('role');
        
        $where['id']       = $this->input->post('lamp_id',true);
        $data['projectid'] = $this->input->post('project_id',true);
        $data['number']    = $this->input->post('lamp_no',true);
        $data['section']   = $this->input->post('section',true);
        $data['address']   = $this->input->post('address',true);
        $data['longitude'] = doubleval($this->input->post('longitude',true));
        $data['latitude']  = doubleval($this->input->post('latitude',true));
        
        if ($data['longitude'] < -180 || $data['longitude'] > 180) exit(json_result('0421',$this->response['0421']));
        if ($data['latitude'] < -90 || $data['latitude'] > 90) exit(json_result('0422',$this->response['0422']));

        $poleheight = $this->input->post('poleheight',true);
        if ($poleheight !== null) {
            $data['poleheight'] = $poleheight;
        }
        $data["polediameter"] = $this->input->post('polediameter',true);
        $data["polematerial"] = $this->input->post('polematerial',true);
        $data["lighttype"] = $this->input->post('lighttype',true);
        $data["lamptype"] = $this->input->post('lamptype',true);
        $data["boardtype"] = $this->input->post('boardtype',true);
        $data["batterytype"] = $this->input->post('batterytype',true);
        $data["boardpower"] = $this->input->post('boardpower',true);
        $data["batteryah"] = $this->input->post('batteryah',true);


        $wattage = $this->input->post('wattage',true);
        $data["wattage"] = !empty($wattage) ? $wattage : 0;

        $supplier = $this->input->post('supplier',true);
        $data["supplier"] = !empty($supplier) ? $supplier : 0;
        $po = $this->input->post('po',true);
        $data["po"] = !empty($po) ? $po : 0;
        $manu = $this->input->post('manu',true);
        $data["manu"] = !empty($manu) ? $manu : 0;
        $protocoltype = $this->input->post('protocoltype',true);
        $data['protocoltype'] = $protocoltype;

        $data['model'] = intval($this->input->post('model',true));
        $data['power'] = intval($this->input->post('power',true));


        $loadtype = $this->input->post('loadtype',true);
        if ($loadtype !== null) {
            $data["loadtype"] = intval($loadtype);
        }

        $role = $this->get_user_info('role');
        $company = $this->get_user_info('company');
        if ($role != SYSTEM_ADMIN) {
            if ($role == 2) {
                $data["manu"] = $company;
            }elseif ($role == 4) {
                $data["po"] = $company;
            }else{
                exit(json_result('0013',$this->response['0013']));
            }
        }
        
        // 控制器协议类型
        $version = $this->session->userdata('version');

        if (strlen($data['number']) > 6) exit(json_result('0408', $this->response['0408'], array()));
        if (empty($data['projectid'])) exit(json_result('0308', $this->response['0308'], array()));
        if (empty($data['number'])) exit(json_result('0409', $this->response['0409'], array()));
        if (!is_numeric($data['number']) || $data['number'] < 1 || $data['number'] > 999999) exit(json_result('0410', $this->response['0410'], array()));
        if (empty($data['address'])) exit(json_result('0805', $this->response['0805'], array()));
        if (is_float($data['address'])) {
            $data['address'] = strval(intval(ceil($data['address'])));
        }
        $is_true = preg_match('/^[A-Fa-f0-9]+$/', $data['address']);
        if (empty($is_true)) exit(json_result('0414', $this->response['0414'], array()));
        $data = remove_null_params($data);
        if (empty($where['id'])) {
            if ($this->Lamp_model->getDataCount(array('number'=>$data['number'], 'projectid'=>$data['projectid'])) > 0) {
                exit(json_result('0401', $this->response['0401'], array()));
            }   
            $fascal_year = $this->input->post('fascal_year',true);
            if (empty($fascal_year)) $fascal_year = date('Y-m-d');
            $data['fascal_year'] = $fascal_year;

            $fascal_year_phase = $this->input->post('fascal_year_phase',true);
            if (empty($fascal_year_phase)) $fascal_year_phase = date('Y');
            $data['fascal_year_phase'] = $fascal_year_phase.'-'.date('Y',strtotime($fascal_year_phase.' +1 year'));

            $lamp = $this->Lamp_model->get_one(array('address'=>$data['address']),'projectid,number');
            if (!empty($lamp)) {
                $projectid = $lamp['projectid'];
                $number = $lamp['number'];
                $projectname = $this->Project_model->getNameById($projectid);
                if (empty($version)) {
                    exit(json_result('0404', "该无线模块地址已被【{$projectname}】项目,【{$number}】编号的灯控使用", array()));
                }else{
                    exit(json_result('other', "The wireless module address has been used by \"{$projectname}\" project, and \"{$number}\" serial number", array()));
                }
            }
            $projectData = $this->Project_model->get_one(['id'=>$data['projectid']],'patrolinterval,cityid,projectname');
            if (empty($data['longitude']) && empty($data['latitude']) && !empty($projectData['cityid'])) {
                $globalData = $this->Global_location_model->getOne($projectData['cityid'],'longitude,latitude');
                $data['longitude'] = $globalData['longitude'];
                $data['latitude'] = $globalData['latitude'];
            }
            $createtime = $this->input->post('createtime',true);
            $data['createtime'] = empty($createtime) ? date('Y-m-d H:i:s',time()) : $createtime;

            $lampid = $this->Lamp_model->add($data);

            $this->Project_model->add_lamp_count(array('lampcount'=>1,'faultcount'=>0,'projectid'=>$data['projectid']));

            $lampId = intval($lampid);
            $this->add_operation_log('insert',"在\"{$projectData['projectname']}\"项目里添加编号为\"{$data['number']}\"、无线模块地址为\"{$data['address']}\"的路灯",0);
            $this->add_operation_log('insert',"Add lamp:\"{$data['number']}\".Wireless module address:\"{$data['address']}\".Project name:\"{$projectData['projectname']}\"",0,1);
        } else {

            if ($this->Lamp_model->getDataCount(array('number'=>$data['number'], 'projectid'=>$data['projectid']), $where['id']) > 0) {
                exit(json_result('0401', $this->response['0401'], array()));
            }

            $fascal_year = $this->input->post('fascal_year',true);
            if (!empty($fascal_year)) $data['fascal_year'] = $fascal_year;

            $fascal_year_phase = $this->input->post('fascal_year_phase',true);
            if (!empty($fascal_year_phase)) $data['fascal_year_phase'] = $fascal_year_phase;

            $lamp = $this->Lamp_model->get_one(array('address'=>$data['address'], 'id !='=>$where['id']),'projectid,number');
            if (!empty($lamp)) {
                $projectid = $lamp['projectid'];
                $number = $lamp['number'];
                $projectname = $this->Project_model->getNameById($projectid);
                if (empty($version)) {
                    exit(json_result('0404', "该无线模块地址已被【{$projectname}】项目,【{$number}】编号的灯控使用", array()));
                }else{
                    exit(json_result('other', "The wireless module address has been used by \"{$projectname}\" project, and \"{$number}\" serial number", array()));
                }
            }


            $old = $this->Lamp_model->get_one($where,'isfaulted,projectid,address,protocoltype');
            if ($old['projectid'] != $data['projectid']) {
                $new['projectid']  = $data['projectid'];
                $new['faultcount'] = $old['isfaulted'] > 0 ? 1 : 0;
                $this->Project_model->add_lamp_count($new);

                $old['faultcount'] = $new['faultcount'];
                $this->Project_model->minus_lamp_count($old);
            }
            // $oldNet = $this->Network_model->getData(array('id'=>$old['networkid']));
            if ($old['address'] != $data['address'] || $protocoltype != $old['protocoltype']) {

            }   

            $this->Lamp_model->update($data,$where);
            $projectData = $this->Project_model->getData(array('id'=>$data['projectid']),'projectname');
            $this->add_operation_log('update',"修改\"{$projectData['projectname']}\"项目下的编号为\"{$data['number']}\"、无线模块地址为\"{$data['address']}\"的路灯信息");
            $this->add_operation_log('update',"Update lamp:\"{$data['number']}\".Wireless module address:\"{$data['address']}\".Project name:\"{$projectData['projectname']}\".",0,1);

            //更新负载设置和蓄电池设置
            if (isset($_POST['workmode'])) {
                $res = $this->load_update();
                if ($res['result'] == 1) {
                    $this->add_operation_log('update',"修改\"{$projectData['projectname']}\"项目下的\"{$networkData['networkname']}\"网络里的编号为\"{$data['number']}\"、无线模块地址为\"{$data['address']}\"的路灯负载参数");
                    $this->add_operation_log('update',"Update the load setting of the street lamp:\"{$data['number']}\".Wireless module address:\"{$data['address']}\".Project name:\"{$projectData['projectname']}\".Network name:\"{$networkData['networkname']}\".",1,1);
                }else{
                    exit(json_result($res['msg'],$res['msg'],array()));
                }
            }
            if (isset($_POST['capacity'])) {
                $res = $this->battery_update();
                if ($res['result'] == 1) {
                    $this->add_operation_log('update',"修改\"{$projectData['projectname']}\"项目下的\"{$networkData['networkname']}\"网络里的编号为\"{$data['number']}\"、无线模块地址为\"{$data['address']}\"的路灯蓄电池参数");
                    $this->add_operation_log('update',"Update the lamp battery setting:\"{$data['number']}\".Wireless module address:\"{$data['address']}\".Project name:\"{$projectData['projectname']}\".Network name:\"{$networkData['networkname']}\".",1,1);
                }else{
                    exit(json_result($res['msg'],$res['msg'],array()));
                }
            }

            $lampId = intval($where['id']);
        }

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


    private function format_date_en($date){
        $h = floor($date/60);
        $h = $h > 10 ? $h : '0'.$h;
        $t = floor($date%60);
        $t = $t > 10 ? $t : '0'.$t;
        return $h.':'.$t;
    }

    // 新控制器获取默认参数值
    public function get_data(){
        $type = $this->input->post('type',true);
        $type = empty($type) ? 1 : $type;
        $update = array();
        if ($type == 1) { // 负载参数
            $update['intell_power']    = '2';
            $update['light_type']    = '1';
            $update['load_current']    = '900';
            $update['first_light_time']    = '00:30';
            $update['first_light_human_power']   = '50';
            $update['first_light_unman_power']    = '20';
            $update['second_light_time']   = '00:30';
            $update['second_light_human_power']       = '70';
            $update['second_light_unman_power']        = '30';
            $update['third_light_time']   = '02:00';
            $update['third_light_human_power']         = '100';
            $update['third_light_unman_power']    = '50';
            $update['fourth_light_time']    = '00:30';
            $update['fourth_light_human_power']    = '70';
            $update['fourth_light_unman_power']    = '30';
            $update['fifth_light_time']    = '00:30';
            $update['fifth_light_human_power']    = '70';
            $update['fifth_light_unman_power']    = '30';
            $update['sixth_light_time']    = '04:00';
            $update['sixth_light_human_power']    = '30';
            $update['sixth_light_unman_power']    = '10';
            $update['seventh_light_time']    = '00:00';
            $update['seventh_light_human_power']    = '100';
            $update['seventh_light_unman_power']    = '50';
            $update['tenth_light_time']    = '00:00';
            $update['tenth_light_human_power']    = '50';
            $update['tenth_light_unman_power']    = '20';
        }else{  // 蓄电池参数

            $update['system_voltage']                 = '12';  // 电池电压
            $update['battery_type']              = '1';  //蓄电池类型
            $update['overvoltage']                  = '15.5';  // 超压电压
            $update['char_limit_voltage']            = '15.0';  // 充电限制电压
            $update['equ_char_voltage']               = '14.6'; // 均衡充电电压
            $update['increa_char_voltage']           = '14.4';  // 提升充电电压
            $update['float_char_voltage']    = '13.8';  // 浮充充电电压
            $update['increa_char_return_voltage']               = '13.2';  // 提升充电返回电压
            $update['over_dischar_return_voltage']          = '12.6'; // 过放返回电压
            $update['battery_under_voltage']           = '12.0';  // 欠压警告电压  新增
            $update['over_dischar_voltage']           = '11.1';  // 过放电压
            $update['discharge_limit_voltage']               = '10.6';  // 放电限制电压 新增
            $update['equ_char_time']               = '120';  // 均衡充电时间
            $update['increa_char_time']               = '120';  // 提升充电时间
            $update['balan_char_interval']               = '30';  // 均衡充电间隔
            $update['temper_compen_coeff']               = '5';  // 温度补偿系数
            $update['char_upper_limit_temper']           = '60';  // 上限温度
            $update['char_lower_limit_temper']           = '-30';  // 下限温度
            $update['reduced_start_voltage']         = '11.5';  // 智能功率起始电压
            $update['reduced_stop_voltage']         = '10.0';  // 智能功率结束电压
            $update['light_voltage']         = '5';  // 光控电压
            $update['light_delay_time']         = '20';  // 光控延时时间

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

    // 新控制器获取参数设置
    public function get_load() {
        $lamp_id = $this->input->post('lamp_id', true);
        if (empty($lamp_id)) {
            exit(json_result('0400', $this->response['0400'], array()));
        }
        $lampData = $this->Lamp_model->get_one(['id'=>$lamp_id],'address,number');

        $res = $this->send_cmd('13',$lampData['address'],'');

            
        if (empty($res)) {
            exit(json_result('0016', $this->response['0016']));
        }else{
            // if (strtolower(crc16(pack('H*',substr($res['msg'], 0,-4)))) == strtolower(substr($res['msg'],-4))) {
            $res['msg'] = unpack('H*', $res['msg'])[1];
                $data = array();
                $data['intell_power'] = base_convert(substr($res['msg'], 18,1), 16, 10).''; // 智能功率
                $data['light_type'] = base_convert(substr($res['msg'], 19,1), 16, 10).''; // 灯控模式
                $data['load_current'] = (base_convert(substr($res['msg'], 20,4), 16, 10)*10).''; // 负载电流
                $data['first_light_time'] = base_convert(substr($res['msg'], 24,2), 16, 10).''; // 第一段亮灯时间
                $data['first_light_human_power'] = base_convert(substr($res['msg'], 26,2), 16, 10).''; // 第一段有人功率
                $data['first_light_unman_power'] = base_convert(substr($res['msg'], 28,2), 16, 10).''; // 第一段无人功率
                $data['second_light_time'] = base_convert(substr($res['msg'], 30,2), 16, 10).''; // 第二段亮灯时间
                $data['second_light_human_power'] = base_convert(substr($res['msg'], 32,2), 16, 10).''; // 第二段有人功率
                $data['second_light_unman_power'] = base_convert(substr($res['msg'], 34,2), 16, 10).''; // 第二段无人功率
                $data['third_light_time'] = base_convert(substr($res['msg'], 36,2), 16, 10).''; // 第三段亮灯时间
                $data['third_light_human_power'] = base_convert(substr($res['msg'], 38,2), 16, 10).''; // 第三段有人功率
                $data['third_light_unman_power'] = base_convert(substr($res['msg'], 40,2), 16, 10).''; // 第三段无人功率
                $data['fourth_light_time'] = base_convert(substr($res['msg'], 42,2), 16, 10).''; // 第四段亮灯时间
                $data['fourth_light_human_power'] = base_convert(substr($res['msg'], 44,2), 16, 10).''; // 第四段有人功率
                $data['fourth_light_unman_power'] = base_convert(substr($res['msg'], 46,2), 16, 10).''; // 第四段无人功率
                $data['fifth_light_time'] = base_convert(substr($res['msg'], 48,2), 16, 10).''; // 第五段亮灯时间
                $data['fifth_light_human_power'] = base_convert(substr($res['msg'], 50,2), 16, 10).''; // 第五段有人功率
                $data['fifth_light_unman_power'] = base_convert(substr($res['msg'], 52,2), 16, 10).''; // 第五段无人功率
                $data['sixth_light_time'] = base_convert(substr($res['msg'], 54,2), 16, 10).''; // 第六段亮灯时间
                $data['sixth_light_human_power'] = base_convert(substr($res['msg'], 56,2), 16, 10).''; // 第六段有人功率
                $data['sixth_light_unman_power'] = base_convert(substr($res['msg'], 58,2), 16, 10).''; // 第六段无人功率
                $data['seventh_light_time'] = base_convert(substr($res['msg'], 60,2), 16, 10).''; // 第七段亮灯时间
                $data['seventh_light_human_power'] = base_convert(substr($res['msg'], 62,2), 16, 10).''; // 第七段有人功率
                $data['seventh_light_unman_power'] = base_convert(substr($res['msg'], 64,2), 16, 10).''; // 第七段无人功率
                $data['tenth_light_time'] = base_convert(substr($res['msg'], 66,2), 16, 10).''; // 晨亮时间
                $data['tenth_light_human_power'] = base_convert(substr($res['msg'], 68,2), 16, 10).''; // 晨亮有人功率
                $data['tenth_light_unman_power'] = base_convert(substr($res['msg'], 70,2), 16, 10).''; // 晨亮无人功率
                // $data['tenth_light_human_power'] = base_convert(substr($res['msg'], 64,2), 16, 10).''; // 晨亮有人功率
                // $data['tenth_light_unman_power'] = base_convert(substr($res['msg'], 68,2), 16, 10).''; // 晨亮无人功率
                // $data['begin_voltage'] = round(base_convert(substr($res['msg'], 146,4), 16, 10)/10,1).''; // 智能功率USER1起始电压
                // $data['end_voltage'] = round(base_convert(substr($res['msg'], 150,4), 16, 10)/10,1).''; // 智能功率USER1终止电压
                // $data['end_current'] = round(base_convert(substr($res['msg'], 158,4), 16, 10)/100,2).''; // 智能功率USER1终止电流
                $res = $data;
            // }else{
            //     exit(json_result('0010', $this->response['0010']));
            // }
        }
        
        // $res['load_current'] = number_format($res['load_current'],2);
        // $res['end_current'] = number_format($res['end_current'],2);
        // $res['end_voltage'] = number_format($res['end_voltage'],1);
        // $res['begin_voltage'] = number_format($res['begin_voltage'],1);
        $res['first_light_time'] = $this->format_date_en($res['first_light_time']*10);
        $res['second_light_time'] = $this->format_date_en($res['second_light_time']*10);
        $res['third_light_time'] = $this->format_date_en($res['third_light_time']*10);
        $res['fourth_light_time'] = $this->format_date_en($res['fourth_light_time']*10);
        $res['fifth_light_time'] = $this->format_date_en($res['fifth_light_time']*10);
        $res['sixth_light_time'] = $this->format_date_en($res['sixth_light_time']*10);
        $res['seventh_light_time'] = $this->format_date_en($res['seventh_light_time']*10);
        $res['tenth_light_time'] = $this->format_date_en($res['tenth_light_time']*10);
        // unset($res['id']);
        // unset($res['updatetime']);
        $data = $res;
        
        exit(json_result('0000', $this->response['0000'], $data));
    }

    // 获取蓄电池设置
    public function battery_setting() {
        $lamp_id = $this->input->post('lamp_id', true);
        if (empty($lamp_id)) {
            exit(json_result('0400', $this->response['0400'], array()));
        }

        $lampData = $this->Lamp_model->get_one(['id'=>$lamp_id],'address,number,projectid');

        $res = $this->send_cmd('11',$lampData['address'],'');

        
        // $lampData = $this->Lamp_model->getData(array('id'=>$lamp_id),'projectid,address,number');
        // var_dump($res);
        if (!empty($res)) {
            $info = unpack('H*', $res['msg'])[1];
            $data['system_voltage']                 = substr($info, 18,2) == 'ff' ? '0' : intval(substr($info, 18,2));  // 电池电压
            $data['battery_count']                 = base_convert(substr($info, 20,1), 16, 10);  // 电池串数
            $data['battery_type']              = base_convert(substr($info, 21,1), 16, 10);  //蓄电池类型
            $data['overvoltage']                  = round(base_convert(substr($info, 22,4), 16, 10)/1000,1);  // 超压电压
            $data['char_limit_voltage']            = round(base_convert(substr($info, 26,4), 16, 10)/1000,1);  // 充电限制电压
            $data['equ_char_voltage']               = round(base_convert(substr($info, 30,4), 16, 10)/1000,1); // 均衡充电电压
            $data['increa_char_voltage']           = round(base_convert(substr($info, 34,4), 16, 10)/1000,1);  // 提升充电电压
            $data['float_char_voltage']    = round(base_convert(substr($info, 38,4), 16, 10)/1000,1);  // 浮充充电电压
            $data['increa_char_return_voltage']               = round(base_convert(substr($info, 42,4), 16, 10)/1000,1);  // 提升充电返回电压
            $data['over_dischar_return_voltage']          = round(base_convert(substr($info, 46,4), 16, 10)/1000,1); // 过放返回电压
            $data['battery_under_voltage']           = round(base_convert(substr($info, 50,4), 16, 10)/1000,1);  // 欠压警告电压  新增
            $data['over_dischar_voltage']           = round(base_convert(substr($info, 54,4), 16, 10)/1000,1);  // 过放电压
            $data['discharge_limit_voltage']               = round(base_convert(substr($info, 58,4), 16, 10)/1000,1);  // 放电限制电压 新增
            $data['equ_char_time']               = base_convert(substr($info, 62,4), 16, 10);  // 均衡充电时间
            $data['increa_char_time']               = base_convert(substr($info, 66,4), 16, 10);  // 提升充电时间
            $data['balan_char_interval']               = base_convert(substr($info, 70,2), 16, 10);  // 均衡充电间隔
            $data['temper_compen_coeff']               = base_convert(substr($info, 72,2), 16, 10);  // 温度补偿系数

            $char_lower_limit_temper           = base_convert(substr($info, 74,2), 16, 2); // 下限温度
            if (substr(substr('00000000'.$char_lower_limit_temper, -8), 0,1) == 1) {
                $data['char_lower_limit_temper'] = 0 - base_convert(substr('0000000'.$char_lower_limit_temper, -7), 2, 10);
            }else{
                $data['char_lower_limit_temper'] = base_convert($char_lower_limit_temper, 2, 10);
            }

            $char_upper_limit_temper           = base_convert(substr($info, 76,2), 16, 2);  // 上限温度
            if (substr(substr('00000000'.$char_upper_limit_temper, -8), 0,1) == 1) {
                $data['char_upper_limit_temper'] = 0 - base_convert(substr('0000000'.$char_upper_limit_temper, -7), 2, 10);
            }else{
                $data['char_upper_limit_temper'] = base_convert($char_upper_limit_temper, 2, 10);
            }

            $data['reduced_start_voltage']         = round(base_convert(substr($info, 78,4), 16, 10)/1000,1);  // 智能功率起始电压
            $data['reduced_stop_voltage']         = round(base_convert(substr($info, 82,4), 16, 10)/1000,1);  // 智能功率结束电压
            $data['light_voltage']         = round(base_convert(substr($info, 86,2), 16, 10)/10);  // 光控电压
            $data['light_delay_time']         = base_convert(substr($info, 88,2), 16, 10);  // 光控延时时间
            
            exit(json_result('0000',$this->response['0000'],$data));
        }else{
            exit(json_result('0016',$this->response['0016']));
        }
    }

    // 灯控相关数据
    public function viewloglist() {
        $lamp_id = $this->input->post('lamp_id',true);
        $datatype = $this->input->post('datatype',true);
        if (empty($lamp_id)) {
            exit(json_result('0400', $this->response['0400'], array()));
        }
        if ($datatype == 'lampinfo') {

            $fields = "number,projectid,address,longitude,latitude,section,boardpower,lamptype,boardtype,batteryah,loadpower,devstatus,loadtype,supplier,upazilla,po,manu,protocoltype,updatetime,status";

            $res = $this->Lamp_model->get_one(['id'=>$lamp_id],$fields);
            if (empty($res)) {
                exit(json_result('0000', $this->response['0006'], array()));
            }
            $version = $this->session->userdata('version');
            if (!empty($version)) {
                $polemaType = ['冷镀锌'=>'Cold galvanizing','热镀锌'=>'Hot galvanizing','不锈钢'=>'Stainless steel'];
                $lightType = ['LED灯'=>'LED lamp','钠灯'=>'Sodium lamp','节能灯'=>'Energy saving light'];
                $lampType = ['太阳能路灯'=>'Solar street lamp','景观灯'=>'Landscape lamp','庭院灯'=>'Garden light'];
                $boardType = ['单晶板'=>'Single crystal plate','多晶板'=>'Polycrystalline plate','非晶板'=>'Amorphous plate'];
                $batteryType = ['铅酸电池'=>'Lead acid battery','锂电池'=>'Lithium battery'];
                if (!preg_match('/^[A-Za-z\s*]+$/', $res['lamptype'])) {
                    $res['lamptype'] = empty($lampType[$res['lamptype']]) ? '' : $lampType[$res['lamptype']];
                }
                if (!preg_match('/^[A-Za-z\s*]+$/', $res['boardtype'])) {
                    $res['boardtype'] = empty($boardType[$res['boardtype']]) ? '' : $boardType[$res['boardtype']];
                }
            }else{
                $polemaType = ['Cold galvanizing'=>'冷镀锌','Hot galvanizing'=>'热镀锌','Stainless steel'=>'不锈钢'];
                $lightType = ['LED lamp'=>'LED灯','Sodium lamp'=>'钠灯','Energy saving light'=>'节能灯'];
                $lampType = ['Solar street lamp'=>'太阳能路灯','Landscape lamp'=>'景观灯','Garden light'=>'庭院灯'];
                $boardType = ['Single crystal plate'=>'单晶板','Polycrystalline plate'=>'多晶板','Amorphous plate'=>'非晶板'];
                $batteryType = ['Lead acid battery'=>'铅酸电池','Lithium battery'=>'锂电池'];

                if (preg_match('/^[A-Za-z\s*]+$/', $res['lamptype'])) {
                    $res['lamptype'] = empty($lampType[$res['lamptype']]) ? '' : $lampType[$res['lamptype']];
                }
                if (preg_match('/^[A-Za-z\s*]+$/', $res['boardtype'])) {
                    $res['boardtype'] = empty($boardType[$res['boardtype']]) ? '' : $boardType[$res['boardtype']];
                }
            }

            // if ($res["isfaulted"] == 0) {
            //     $res["isfaulted"] = '正常';
            // }else{
                
            // }
            // $alarmData = $this->Alarm_model->get_one_by_filter(array('lampid'=>$lamp_id,'status'=>0),'stralarmtype');
            // $version = $this->session->userdata('version');
            // if (empty($version)) {
            //     $res['isfaulted'] = empty($alarmData['stralarmtype']) ? '正常' : $alarmData['stralarmtype'];
            // }else{
            //     $res['isfaulted'] = empty($alarmData['stralarmtype']) ? 'Normal' : alarm_translate($alarmData['stralarmtype']);
            // }
            
            $timezone = $this->Project_model->get_timezone_by_projectid($res['projectid']);
            $res["updatetime"] = date_change($res["updatetime"],8,$timezone['value']);

            $data = array(
                "lamp_no" => $res["number"], 
                "project_name" => $this->Project_model->getNameById($res["projectid"]), 
                "address" => $res["address"], 
                "longitude" => $res["longitude"], 
                "latitude" => $res["latitude"], 
                "isfaulted" => $res["devstatus"], 
                "section" => $res["section"], 
                "boardpower" => floatval($res["boardpower"]), 
                "lamptype" => $res['lamptype'],
                "boardtype" => $res['boardtype'], 
                "batteryah" => $res["batteryah"],
                "loadpower" => $res["loadpower"],
                'status' => $res['status'],
                // 'batterytype' => $res['batterytype'],
                'protocoltype'=>intval($res['protocoltype']),
                'supplier'=>intval($res['supplier']),
                'upazilla'=>intval($res['upazilla']),
                'po'=>intval($res['po']),
                'manu'=>intval($res['manu']),
                "updatetime" => $res["updatetime"], 
                'loadtype' => $res['loadtype']
            );
            // $msisdn = $this->db->query('select iccid from msisdn where imsi = "'.$res['simid'].'"')->row_array();
            // if (empty($msisdn) || empty($msisdn['iccid'])) {
            //     $data['iccid'] = '';
            // }else{
            //     $data['iccid'] = $msisdn['iccid'];
            // }
            // if ($res['protocoltype'] != 1 && $res['protocoltype'] != 2) {
            //     unset($data['packageSurplus']);
            //     unset($data['simid']);
            // }
            // $username = $this->get_user_info('username');
            // if ($username == 'zns') {
            //     $data['monthly_can_usage'] = intval($res['monthly_can_usage']);
            //     $data['monthly_already_usage'] = round($res['monthly_already_usage'],2);
            // }

            exit(json_result('0000', $this->response['0000'], $data));
        }
        $table_map = array('system_info_log','lamp_info_log','solar_info_log','battery_info_log','electric_info_log','history_info_log');
        $table = in_array($datatype, $table_map) ? $datatype : 'system_info_log';
        $res = $this->Lamp_model->getForInfoLog($lamp_id, $table);
        $lampData = $this->Lamp_model->get_one(['id'=>$lamp_id],'projectid');
        $timezone = $this->Project_model->get_timezone_by_projectid($lampData['projectid']);
        if(!$res){
            exit(json_result('0000', $this->response['0006'], array()));
        }
        if ($table == 'battery_info_log') {
            if (isset($res['daydischargemincurrent'])) {
                $h = floor($res['daydischargemincurrent']/3600);
                $h = $h < 10 ? '0'.$h : $h;
                $i = intval($res['daydischargemincurrent']/60)%60;
                $i = $i < 10 ? '0'.$i : $i;
                $res['daydischargemincurrent'] = $h.':'.$i;
            }
            if (isset($res['daychargemincurrent'])) {
                $h = floor($res['daychargemincurrent']/3600);
                $h = $h < 10 ? '0'.$h : $h;
                $i = intval($res['daychargemincurrent']/60)%60;
                $i = $i < 10 ? '0'.$i : $i;
                $res['daychargemincurrent'] = $h.':'.$i;
            }
        }
        $res["updatetime"] = date_change($res["updatetime"],8,$timezone['value']);
        exit(json_result('0000', $this->response['0000'], $res));
    }

    // 灯控历史数据
    public function historylist() {
        $lamp_id = $this->input->post('lamp_id',true);
        $datatype = $this->input->post('datatype',true);
        $page = intval($this->input->post('page',true));
        $count = intval($this->input->post('count',true));

        $count = empty($count) ? 16 : $count;
        if (empty($lamp_id)) {
            exit(json_result('0400', $this->response['0400'], array()));
        }
        $date = $this->input->post('date',true);
        $beginDate = '';
        $endDate = '';

        // 按时区修改时间
        $lampData = $this->Lamp_model->get_one(['id'=>$lamp_id],'projectid,protocoltype');
        $timezone = $this->Project_model->get_timezone_by_projectid($lampData['projectid']);

        if (!empty($date)) {
            $dateArr = explode('/', $date);
            $beginDate = date('Y-m-d H:i:s',strtotime($dateArr[0]) - 8*3600);
            $endDate = date('Y-m-d H:i:s',strtotime(date('Y-m-d 23:59:59',strtotime($dateArr[1]))) - 8*3600);
            // $beginDate = $dateArr[0];
            // $endDate = $dateArr[1];
            if (strtotime($endDate) - strtotime($beginDate) > 31*24*3600) {
                exit(json_result('0418',$this->response['0418']));
            }
        }else{
            $beginDate = date('Y-m-d H:i:s',strtotime(date('Y-m-d 00:00:00',time())) - 8*3600);
            $endDate = date('Y-m-d H:i:s',strtotime(date('Y-m-d 23:59:59',time())) - 8*3600);
        }
        if($page < 1){
            $page = 1;
        }
        

        $download = intval($this->input->post('download'));
        if (!empty($download)) {
            if (empty($date)) exit(json_result('0007',$this->response['0007']));
            $dataList = array();

            // 路灯
            $lampInfoList = $this->Lamp_model->getListForInfoLog($lamp_id, 'lamp_info_log', null, null,$beginDate,$endDate);
            $temp = array();
            $i = 1;
            if (empty($this->version)) {
                $lampStatusArr = array(0=>'关灯',1=>'开灯');
                $title = array('序号','亮度%','状态','电压(V)','电流(A)','功率(W)','当天放电最大功率(W)','当天亮灯时长(HH:MM)','更新时间');
                $name = '路灯';
            }else{
                $lampStatusArr = array(0=>'off',1=>'on');
                $title = array('Number','Brightness%','Status','Voltage(V)','Current(A)','Power(W)','Maximum discharge power of the day(W)','dayLighting duration(HH:MM)','Update time');
                $name = 'Lamp';
            }
            foreach ($lampInfoList as $k=>$l) {
                $temp[$k][] = $i;
                $temp[$k][] = $l['lighteness'];
                $temp[$k][] = $lampStatusArr[$l['lampstatus']];
                $temp[$k][] = $l['lampvoltage'];
                $temp[$k][] = $l['lampcurrent'];
                $temp[$k][] = $l['lamppower'];
                $temp[$k][] = $l['daydischarmaxpow'];
                $h = floor($l['daychargemincurrent'] / 3600);
                $h = $h < 10 ? '0'.$h : $h;
                $m = ceil($l['daychargemincurrent'] % 3600 / 60);
                $m = $m < 10 ? '0'.$m : $m;
                $temp[$k][] = $h.':'.$m;
                $temp[$k][] = date_change($l["updatetime"],8,$timezone['value']);
                $i ++;
            }
            $title1 = [];
            foreach ($title as $t) {
                $title1[0][] = $t;
            }
            $data = array_merge($title1,$temp);
            $dataList[] = array('name'=>$name,'dataList'=>$data);

            // 蓄电池
            $lampInfoList = $this->Lamp_model->getListForInfoLog($lamp_id, 'battery_info_log', null, null,$beginDate,$endDate);
            $temp = array();
            $i = 1;
            if (empty($this->version)) {
                $name = '蓄电池';
                if ($lampData['protocoltype'] == 2) {
                    $chargeStageMap = array(0=>'没有充电',1=>'等待',2=>'初始',3=>'MPPT',4=>'恒压',5=>'恒流',6=>'浮充',7=>'均衡',8=>'提升',9=>'涓流',10=>'完成',''=>'未知状态');
                }else{
                    $chargeStageMap = array(0=>'没有充电',1=>'启动充电',6=>'限流',7=>'充满',16=>'MPPT充电',32=>'均衡充电',48=>'提升充电',64=>'浮充',''=>'未知状态');
                }
                $battstatusArr = array(0=>'空闲',1=>'放电',2=>'充电',3=>'一边充电一边放电',''=>'未知状态');
                $unknown = '未知状态';
                $title = array('序号','系统电压(V)','系统电流(A)','MOS温度(℃)','电池状态','充电阶段','电池电压(V)','当天最低电压(V)','当天最高电压(V)','电池温度(℃)','当天电池最低温度(℃)','当天电池最高温度(℃)','更新时间');
            }else{
                $name = 'Battery';
                if ($lampData['protocoltype'] == 2) {
                    $chargeStageMap = array(0=>'There is no charge',1=>'wait for',2=>'initial',3=>'MPPT',4=>'Constant voltage',5=>'constant current',6=>'floating charge',7=>'equilibrium',8=>'Promote',9=>'Trickle',10=>'complete',''=>'Unknown state');
                }else{
                    $chargeStageMap = array(0=>'There is no charge',1=>'Start charging',6=>'Current limiting',7=>'Full',16=>'MPPT charging',32=>'Equalizing charge',48=>'Improve charging',64=>'Floating',''=>'Unknown state');
                }
                $battstatusArr = array(0=>'Free',1=>'Discharge',2=>'Charge',3=>'Discharge while charging',''=>'Unknown state');
                $unknown = 'Unknown state';
                $title = array('Serial number','System voltage(V)','System current(A)','MOS temperature(℃)','Battery status','Charging stage','Battery voltage(V)','The lowest voltage of the day(V)','Maximum Voltage of the Day(V)','Battery temperature(℃)','Battery minimum temperature for the day(℃)','The highest temperature of the battery on that day(℃)','Update time');
            }
            $indexArr = [2=>'16',3=>'32',4=>'48',5=>'64'];
            foreach ($lampInfoList as $k=>$l) {
                $temp[$k][] = $i;
                $temp[$k][] = $l['sysvoltage'];
                $temp[$k][] = $l['syscurrent'];
                $temp[$k][] = $l['temper'];
                $temp[$k][] = $battstatusArr[$l['battstatus']];
                if ($lampData['protocoltype'] == 1) {
                    $l['chargestage'] = isset($indexArr[intval($l['chargestage'])]) ? $indexArr[intval($l['chargestage'])] : $l['chargestage'];
                }
                $temp[$k][] = $chargeStageMap[$l['chargestage']];
                $temp[$k][] = $l['battvoltage'];
                $temp[$k][] = $l['voltagedaymin'];
                $temp[$k][] = $l['voltagedaymax'];
                $temp[$k][] = $l['batttemper'];
                $temp[$k][] = $l['daybattmintemper'];
                $temp[$k][] = $l['daybattmaxtemper'];
                $temp[$k][] = date_change($l["updatetime"],8,$timezone['value']);
                $i ++;
            }
            $title1 = [];
            foreach ($title as $t) {
                $title1[0][] = $t;
            }
            $data = array_merge($title1,$temp);
            $dataList[] = array('name'=>$name,'dataList'=>$data);

            // 太阳能
            $lampInfoList = $this->Lamp_model->getListForInfoLog($lamp_id, 'solar_info_log', null, null,$beginDate,$endDate);
            $temp = array();
            $i = 1;
            if (empty($this->version)) {
                $name = '太阳能';
                $title = array('序号','电压(V)','电流(A)','功率(W)','当天充电最大功率(WH)','当天充电时长(HH:MM)','更新时间');
            }else{
                $name = 'Solar';
                $title = array('Number','Voltage(V)','Current(A)','Power(W)','Maximum Power Charged on the Day(W)','day Charging time(HH:MM)','Update time');
            }
            foreach ($lampInfoList as $k=>$l) {
                $temp[$k][] = $i;
                $temp[$k][] = $l['solarvoltage'];
                $temp[$k][] = $l['solarcurrent'];
                $temp[$k][] = $l['solarpower'];
                $temp[$k][] = $l['daychargemaxpow'];
                $h = floor($l['daydischargemincurrent'] / 3600);
                $h = $h < 10 ? '0'.$h : $h;
                $m = ceil($l['daydischargemincurrent'] % 3600 / 60);
                $m = $m < 10 ? '0'.$m : $m;
                $temp[$k][] = $h.':'.$m;
                $temp[$k][] = date_change($l["updatetime"],8,$timezone['value']);
                $i ++;
            }
            $title1 = [];
            foreach ($title as $t) {
                $title1[0][] = $t;
            }
            $data = array_merge($title1,$temp);
            $dataList[] = array('name'=>$name,'dataList'=>$data);

            // 系统
            $lampInfoList = $this->Lamp_model->getListForInfoLog($lamp_id, 'system_info_log', null, null,$beginDate,$endDate);
            $temp = array();
            $i = 1;
            if (empty($this->version)) {
                $name = '系统';
                $title = array('序号','系统电压(V)','系统电流(A)','控制器温度(℃)','更新时间');
            }else{
                $name = 'System';
                $title = array('Serial number','System voltage(V)','System current(A)','Control temperature(℃)','Update time');
            }
            foreach ($lampInfoList as $k=>$l) {
                $temp[$k][] = $i;
                $temp[$k][] = $l['sysvoltage'];
                $temp[$k][] = $l['syscurrent'];
                $temp[$k][] = $l['temper'];
                $temp[$k][] = date_change($l["updatetime"],8,$timezone['value']);
                $i ++;
            }
            $title1 = [];
            foreach ($title as $t) {
                $title1[0][] = $t;
            }
            $data = array_merge($title1,$temp);
            $dataList[] = array('name'=>$name,'dataList'=>$data);

            $path = push_excel($dataList,'historyInfoExcel_'.date('Ymd'),1);
            exit(json_result('0000', $this->response['0000'], array('path'=>$path)));
        }
        // $table_map = array('system_info_log','lamp_info_log','solar_info_log','battery_info_log','electric_info_log','history_info_log');
        $table = !empty($datatype) ? $datatype : 'system_info_log';
        if ($table == 'lamp_info_log') {
            $table = 'realtime_info_log';
            $total = $this->RealtimeInfoLog_model->get_count(['lampid'=>$lamp_id,'updatetime >='=>$beginDate,'updatetime <='=>$endDate]);
            $res = $this->RealtimeInfoLog_model->get_list(['lampid'=>$lamp_id,'updatetime >='=>$beginDate,'updatetime <='=>$endDate], 'loadvoltage as lampvoltage,lighteness,loadcurrent as lampcurrent,loadpower as lamppower,updatetime,loadWorkTimeDay as daychargemincurrent,daydischarmaxpow',$count, ($page-1)*$count, 'updatetime desc,id desc', NUll);
            // $res = $this->Lamp_model->getListForInfoLog($lamp_id, $table, ($page-1)*$count, $count,$beginDate,$endDate);
        }elseif ($table == 'system_info_log') {
            $total = $this->Lamp_model->getCountForInfoLog($lamp_id, $table,$beginDate,$endDate);
            $res = $this->Lamp_model->getListForInfoLog($lamp_id, $table, ($page-1)*$count, $count,$beginDate,$endDate);
        }elseif ($table == 'battery_info_log') {
            $join = [
                // ['table'=>'history_info_log as HI','cond'=>'HI.lampid = RI.lampid and HI.updatetime = RI.updatetime','type'=>'inner'],
            ];
            $where = ['lampid'=>$lamp_id,'updatetime >='=>$beginDate,'updatetime <='=>$endDate];
            $total = $this->RealtimeInfoLog_model->get_count($where,'count(*) as total');
            $fields = 'batvoltage as battvoltage,chgtemper as batttemper,updatetime,DayOverDisChgTimes as overtimes,battstatus,chargestage,voltagedaymin,voltagedaymax,daybattmintemper,daybattmaxtemper';
            $res = $this->RealtimeInfoLog_model->get_list($where, $fields,$count, ($page-1)*$count, 'updatetime desc,id desc');
        }else{

            $join = [
                // ['table'=>'history_info_log as HI','cond'=>'HI.lampid = RI.lampid and HI.updatetime = RI.updatetime','type'=>'inner'],
            ];
            $where = ['lampid'=>$lamp_id,'updatetime >='=>$beginDate,'updatetime <='=>$endDate];
            $total = $this->RealtimeInfoLog_model->get_count($where,'count(*) as total');
            $fields = 'panelvoltage as solarvoltage,updatetime,panelcurrent as solarcurrent,panelpower as solarpower,daychargemaxpow';
            $res = $this->RealtimeInfoLog_model->get_list($where, $fields,$count, ($page-1)*$count, 'updatetime desc,id desc');
            // $total = $this->Lamp_model->getCountForInfoLog($lamp_id, $table,$beginDate,$endDate);
            // $res = $this->Lamp_model->getListForInfoLog($lamp_id, $table, ($page-1)*$count, $count,$beginDate,$endDate);
        }
        

        if(!$res){
            exit(json_result('0000', $this->response['0006'], array()));
        }else{
            
            $arr = [2=>'16',3=>'32',4=>'48',5=>'64'];
            foreach ($res as &$v) {
                if (isset($v['lighteness'])) {
                    $v['lampstatus'] = empty($v['lighteness']) ? '0' : '1';
                }
                if (isset($v['daychargemincurrent'])) $v['daychargemincurrent'] = intval($v['daychargemincurrent']);
                // $v['updatetime'] = date_change($v["updatetime"],8,$timezone['value']);
                $v['updatetime'] = set_timezone($v["updatetime"],$timezone['value']);
                if ($lampData['protocoltype'] == 1 && $table == 'battery_info_log') {
                    $v['chargestage'] = isset($arr[intval($v['chargestage'])]) ? $arr[intval($v['chargestage'])] : $v['chargestage'];
                }
                if ($table == 'system_info_log') {
                    $v['lampid'] = $v['number'];
                }
            }
        }
        $data = array(
            'total' => ceil($total/$count),
            'list' => $res
        );
        exit(json_result('0000', $this->response['0000'], $data));
    }

    // 修改路灯位置
    public function change_location(){
        $id = intval($this->input->post('id',true));
        $type = intval($this->input->post('type',true));
        $data['longitude'] = $this->input->post('longitude',true);
        $data['latitude'] = $this->input->post('latitude',true);
        $data['updatetime'] = date('Y-m-d H:i:s',time());
        if (empty($id) || empty($type) || !isset($data['longitude']) || !isset($data['latitude'])) {
            exit(json_result('0007',$this->response['0007'],array()));
        }

        if ($type == 1) {
            $this->Lamp_model->update($data,array('id'=>$id));
        }else{
            $this->Videomonitor_model->update($data,array('id'=>$id));
        }
        exit(json_result('0000',$this->response['0000'],array()));
    }

    // 同步巡检
    public function set_patrol_cmd(){
        $id = intval($this->input->post('id',true));
        if (empty($id)) exit(json_result('0007',$this->response['0007'],array('id'=>$id)));
        $lampData = $this->Lamp_model->getOne($id,'N.status,N.protocoltype,L.address,L.protocoltype as lampprotocoltype,L.number');
        $cmd = '{"cmd_type":"set_sync_patrol_cmd","cmd_id":'.$id.'}';
        $cmdret = send_cmd($cmd,0,30,$lampData['protocoltype']);
        if ($cmdret === false) {
            sleep(1);
            $cmdret = send_cmd($cmd,0,30,$lampData['protocoltype']);
        }
        exit(json_result('0000',$this->response['0000'],array('id'=>$id)));
    }

    // 批量添加
    public function batchInput(){
        set_time_limit(0);
        $userid = $this->get_user_info('id');
        // $idArr = $this->get_section_by_user();

        $role = $this->get_user_info('role');
        $companyid = $this->get_user_info('companyid');

        $type = intval($this->input->post('type',true));

        if ($type == 1) {  // 验证
            $indexArr = ['A'=>'number','B'=>'address','C'=>'company_name','D'=>'projectid','E'=>'devicetype','F'=>'networkid','G'=>'protocoltype','H'=>'lampprotocoltype','I'=>'section','J'=>'longitude','K'=>'latitude','L'=>'poleheight','M'=>'polediameter','N'=>'polematerial','O'=>'lighttype','P'=>'lamptype','Q'=>'boardtype','R'=>'batterytype','S'=>'boardpower','T'=>'batteryah','U'=>'loadpower','V'=>'loadtype'];
            $data = $this->batch_import($indexArr);
        }else{  // 创建
            $data = $this->input->post('lampData',true);

            if (empty($data)) exit(json_result('0007',$this->response['0007']));
            $data = json_decode($data,true);
        }
        foreach ($data as &$v) {
            if ($type == 1 && is_float($v['address'])) $v['address'] = strval(intval(ceil($v['address'])));
        }
        $res = 0;

        $typeArr = ['tcp'=>0,'nb'=>1,'gprs'=>2,'lorawan'=>3,'MQTT'=>4,'WeLoraWan'=>6,'onenet'=>7];
        $this->db->trans_begin();
        $msg = [];
        $patrol_arr = array();
        foreach ($data as $key => $value) {
            $num = $key+2;
            $value['number'] = trim($value['number']);
            if (!isset($value['number']) || $value['number'] == '') {
                $res = 1;
                if (empty($this->version)) {
                    $msg[] = '表格第'.$num.'行，路灯编号不能为空';
                }else{
                    $msg[] = 'Table '.$num.' row.Lamp number can not be empty';
                }
            }else{
                if (!is_numeric($value['number']) && ($value['number'] <= 0 || $value['number'] > 999999)) {
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，路灯编号为1-999999的数字';
                    }else{
                        $msg[] = 'Table '.$num.' row.The number of street lamps numbered 1-999999';
                    }
                }
            }
            // if ($type == 1 && is_float($value['address'])) {
            //     $value['address'] = strval(intval(ceil($value['address'])));
            // }
            $value['address'] = trim($value['address']);
            if (empty($value['address'])) {
                $res = 1;
                
                if (empty($this->version)) {
                    $msg[] = '表格第'.$num.'行，无线模块地址不能为空';
                }else{
                    $msg[] = 'Table '.$num.' row.Address of the wireless module can not be empty';
                }
            }else{
                $status = preg_match('/^[A-Fa-f0-9]+$/', $value['address']);
                if (empty($status)) {
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，无线模块地址为16进制数';
                    }else{
                        $msg[] = 'Table '.$num.' row.Wireless module address is 16 hexadecimal';
                    }
                }else{
                    if ($this->Lamp_model->getDataCount(['address'=>$value['address']])) {
                        $res = 1;
                        if (empty($this->version)) {
                            $msg[] = '表格第'.$num.'行，无线模块地址已经存在';
                        }else{
                            $msg[] = 'Table '.$num.' row.Wireless module address already exists';
                        }
                    }
                }
            }
            $value['company_name'] = trim($value['company_name']);
            if (empty($value['company_name'])) {
                $res = 1;
                if (empty($this->version)) {
                    $msg[] = '表格第'.$num.'行，公司名称不能为空';
                }else{
                    $msg[] = 'Table '.$num.' row.Company name cannot be empty';
                }
            }
            $value['projectid'] = trim($value['projectid']);
            if (empty($value['projectid'])) {
                $res = 1;
                if (empty($this->version)) {
                    $msg[] = '表格第'.$num.'行，项目名称不能为空';
                }else{
                    $msg[] = 'Table '.$num.' row.Project name cannot be empty';
                }
            }else{
                $projectid = $this->Project_model->project_exist_by_name($role,$userid,$companyid,$value['projectid'],$value['company_name']);
                if (empty($projectid)) {
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，项目不存在，请先创建项目';
                    }else{
                        $msg[] = 'Table '.$num.' row.The project does not exist. Please create a project first.';
                    }
                    $value['projectid'] = 0;
                }else{
                    $value['projectid'] = $projectid;
                    $this->Project_model->add_lamp_count(array('faultcount'=>0,'projectid'=>$projectid));
                    if ($this->Lamp_model->getDataCount(['projectid'=>$value['projectid'],'number'=>$value['number']])) {
                        $res = 1;
                        if (empty($this->version)) {
                            $msg[] = '表格第'.$num.'行，路灯编号已经存在';
                        }else{
                            $msg[] = 'Table '.$num.' row lamp number already exists';
                        }
                    }
                }
            }

            if($type != 1 && isset($typeArr[$value['protocoltype']]) && $typeArr[$value['protocoltype']] == 6){
                $this->add_device($value['address']);
            }

            $value['devicetype'] = intval(trim($value['devicetype']));

            if ($value['devicetype'] == 0) { // 非直连设备
                unset($value['protocoltype']);
                $value['networkid'] = trim($value['networkid']);
                if (empty($value['networkid'])) {
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，非直连设备网络编号不能为空';
                    }else{
                        $msg[] = 'Table '.$num.' row.Indirect device network number cannot be empty';
                    }
                }else{
                    $networkid = $this->Network_model->project_exist_by_name($value['projectid'],$value['networkid']);
                    // var_dump($this->db->last_query());die;
                    if (empty($networkid)) {
                        $res = 1;
                        if (empty($this->version)) {
                            $msg[] = '表格第'.$num.'行，网络不存在，请先添加网络';
                        }else{
                            $msg[] = 'Table '.$num.' row.The network does not exist. Please add the network first';
                        }
                    }else{
                        $this->Network_model->add_lamp_count(array('faultcount'=>0,'networkid'=>$networkid));
                        $value['networkid'] = $networkid;
                    }
                }
            }elseif ($value['devicetype'] == 1) { // 直连设备
                $value['protocoltype'] = trim($value['protocoltype']);
                if (empty($value['protocoltype'])) {
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，协议类型不能为空';
                    }else{
                        $msg[] = 'Table '.$num.' row.Protocol type cannot be empty';
                    }
                }else{
                    if (!isset($typeArr[$value['protocoltype']])) {
                        $res = 1;
                        if (empty($this->version)) {
                            $msg[] = '表格第'.$num.'行，协议类型不存在';
                        }else{
                            $msg[] = 'Table '.$num.' row.Protocol type not exists';
                        }
                    }
                }

                // 创建直连网络
                $number = mb_strlen($value['address']) == 13 ? base_convert($value['address'], 16, 10) : $value['address'];
                if ($this->Network_model->getDataCount(array('devicesn'=>$number))) {
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，无线模块地址已被使用';
                    }else{
                        $msg[] = 'Table '.$num.' row.Wireless module address has been used';
                    }
                }
                // 创建网络
                // $networkData['id']  = $this->Zone_model->insert(array(
                //     'name'   => $number,
                //     'parent' => $value['projectid'] ,
                //     'level'  => 4
                // )); 
                // 控制器协议类型
                $value['lampprotocoltype'] = trim($value['lampprotocoltype']);
                if (empty($value['lampprotocoltype'])) {
                    $networkData['devicetype'] = 0;
                }else{
                    if ($value['lampprotocoltype'] == 'ModBus') {
                        $networkData['devicetype'] = 3;
                    }elseif ($value['lampprotocoltype'] == 'LightBus') {
                        $networkData['devicetype'] = 0;
                    }else{
                        $networkData['devicetype'] = 0;
                    }
                }
                $networkData['networkid'] = $number;
                $networkData['gatewaytype'] = 'direct';
                $networkData['protocoltype'] = empty($typeArr[$value['protocoltype']]) ? 'tcp' : $typeArr[$value['protocoltype']];
                $networkData['projectid'] = $value['projectid'];
                $networkData['devicesn'] = $number;
                $networkData['networkname'] = $number;
                $networkData['type'] = 1;
                $networkData['lampcount'] = 1;
                $networkData['createtime'] = date('Y-m-d H:i:s',time());

                if ($type == 1) {
                    $this->db->insert('network',$networkData);
                    $value['networkid'] = $this->db->insert_id();
                }else{
                    $value['networkid'] = $this->Network_model->insert($networkData);
                }
            }else{
                $res = 1;
                if (empty($this->version)) {
                    $msg[] = '表格第'.$num.'行，设备类型选择错误';
                }else{
                    $msg[] = 'Table '.$num.' row.Device type selection error';
                }
            }
            unset($value['protocoltype']);

            // 控制器协议类型
            $value['lampprotocoltype'] = trim($value['lampprotocoltype']);
            if (empty($value['lampprotocoltype'])) {
                $res = 1;
                
                if (empty($this->version)) {
                    $msg[] = '表格第'.$num.'行，协议类型不能为空';
                }else{
                    $msg[] = 'Table '.$num.' row.Protocol type can not be empty';
                }
            }else{
                if ($value['lampprotocoltype'] == 'ModBus') {
                    $value['protocoltype'] = 1;
                }elseif ($value['lampprotocoltype'] == 'LightBus') {
                    $value['protocoltype'] = 0;
                }else{
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，协议类型选择错误';
                    }else{
                        $msg[] = 'Table '.$num.' row.Protocol type selection error';
                    }
                }
            }
            unset($value['lampprotocoltype']);

            $value['longitude'] = trim($value['longitude']);
            if (empty($value['longitude'])) {
                $value['longitude'] = 0;
            }else{
                if (!is_numeric($value['longitude']) || $value['longitude'] > 180 || $value['longitude'] < -180) {
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，经度输入错误';
                    }else{
                        $msg[] = 'Table '.$num.' row longitude input error';
                    }
                }
            }

            $value['latitude'] = trim($value['latitude']);
            if (empty($value['latitude'])) {
                $value['latitude'] = 0;
            }else{
                if (!is_numeric($value['latitude']) || $value['latitude'] > 90 || $value['latitude'] < -90) {
                    $res = 1;
                    if (empty($this->version)) {
                        $msg[] = '表格第'.$num.'行，纬度输入错误';
                    }else{
                        $msg[] = 'Table '.$num.' row latitude input error';
                    }
                }
            }
            if (empty($value['latitude']) && empty($value['longitude']) && !empty($value['projectid'])) {
                $projectData = $this->Project_model->getOne($value['projectid'],'cityid');
                if (!empty($projectData['cityid'])){
                    $globalData = $this->Global_location_model->getOne($projectData['cityid'],'longitude,latitude');
                    $value['longitude'] = $globalData['longitude'];
                    $value['latitude'] = $globalData['latitude'];
                }
            }
            
            $value['loadtype'] = trim($value['loadtype']);
            if (empty($value['loadtype']) || $value['loadtype'] == '0' || $value['loadtype'] == '1') {
                if ($value['loadtype'] == '1') {
                    $value['loadtype'] = 1;
                }else{
                    $value['loadtype'] = 0;
                }
            }else{
                $res = 1;
                if (empty($this->version)) {
                    $msg[] = '表格第'.$num.'行，负载类型错误';
                }else{
                    $msg[] = 'Table '.$num.' row load type error';
                }
            }

            if (trim($value['poleheight']) == '') {
                unset($value['poleheight']);
            }else{
                $value['poleheight'] = trim($value['poleheight']);
            }
            if (trim($value['polediameter']) == '') {
                unset($value['polediameter']);
            }else{
                $value['polediameter'] = trim($value['polediameter']);
            }
            if (trim($value['section']) == '') {
                $value['section'] = '';
                $res = 1;
                if (empty($this->version)) {
                    $msg[] = '表格第'.$num.'行，路段不能为空';
                }else{
                    $msg[] = 'Table '.$num.' row. Section cannot be empty';
                }
            }else{
                $value['section'] = trim($value['section']);
            }
            if (trim($value['polematerial']) == '') {
                unset($value['polematerial']);
            }else{
                $value['polematerial'] = trim($value['polematerial']);
            }
            if (trim($value['lighttype']) == '') {
                unset($value['lighttype']);
            }else{
                $value['lighttype'] = trim($value['lighttype']);
            }
            if (trim($value['lamptype']) == '') {
                unset($value['lamptype']);
            }else{
                $value['lamptype'] = trim($value['lamptype']);
            }
            if (trim($value['boardtype']) == '') {
                unset($value['boardtype']);
            }else{
                $value['boardtype'] = trim($value['boardtype']);
            }
            if (trim($value['batterytype']) == '') {
                unset($value['batterytype']);
            }else{
                $value['batterytype'] = trim($value['batterytype']);
            }
            if (trim($value['boardpower']) == '') {
                unset($value['boardpower']);
            }else{
                $value['boardpower'] = trim($value['boardpower']);
            }
            if (trim($value['batteryah']) == '') {
                unset($value['batteryah']);
            }else{
                $value['batteryah'] = trim($value['batteryah']);
            }
            if (trim($value['loadpower']) == '') {
                unset($value['loadpower']);
            }else{
                $value['loadpower'] = trim($value['loadpower']);
            }

            $value['createtime'] = date('Y-m-d H:i:s',time());
            $value['updatetime'] = date('Y-m-d H:i:s',time());
            unset($value['company_name']);
            if (is_null($value['networkid'])) {
                unset($value['networkid']);
            }
            $lamp_id = $this->Lamp_model->insert($value);
            $patrol_arr[] = array('lampid'=>$lamp_id,'projectid'=>$value['projectid']);
        }

        if ($res || $type == 1) {
            $this->db->trans_rollback();
            exit(json_result('0000',$this->response['0000'],['lampData'=>$data,'msg'=>$msg]));
        }else{
            $this->db->trans_commit();
            // foreach ($patrol_arr as $patrol) {
            //     $projectData = $this->Project_model->getOne($patrol['projectid'],'patrolinterval');
            //     $this->patrol_set($patrol['lampid'],$projectData['patrolinterval']);
            // }
            exit(json_result('0000',$this->response['0000']));
        }
    }

    // 路灯历史数据曲线图
    public function lamp_history_data(){
        $type = intval($this->input->post('type',true));
        $lampId = intval($this->input->post('lampid',true));
        if (empty($lampId)) exit(json_result('0007',$this->response['0007']));

        $dateType = intval($this->input->post('dateType',true));
        $date = $this->input->post('date',true);

        if ($dateType == 0) { // 一天
            $beginDate = date('Y-m-d H:i:s',time()-24*3600);
            $endDate = date('Y-m-d H:i:s',time());
        }elseif ($dateType == 1) {  // 三天
            $beginDate = date('Y-m-d H:i:s',time()-24*3600*3);
            $endDate = date('Y-m-d H:i:s',time());
        }elseif ($dateType == 2) {  //  七天
            $beginDate = date('Y-m-d H:i:s',time()-24*3600*7);
            $endDate = date('Y-m-d H:i:s',time());
        }elseif ($dateType == 3) {  //  十四天
            $beginDate = date('Y-m-d H:i:s',time()-24*3600*14);
            $endDate = date('Y-m-d H:i:s',time());
        }else{   // 选择时间
            if (empty($date)) exit(json_result('0007',$this->response['0007']));
            $res = explode('/', $date);
            if (strtotime($res[1]) - strtotime($res[0]) > 31 * 24 * 3600) {
                exit(json_result('0418',$this->response['0418']));
            }
            $beginDate = $res[0];
            $endDate = date('Y-m-d 23:59:59',strtotime($res[1]));
            // var_dump($endDate);die;
        }
        $sql = "SELECT P.id,P.patrolinterval FROM lampinfo AS L LEFT JOIN project as P on P.id = L.projectid  WHERE L.id = {$lampId} limit 1";        
        $lampData = $this->db->query($sql)->row_array();
        $timezoneData = $this->Project_model->get_timezone_by_projectid($lampData['id']);
        $timezone = $timezoneData['value'];

        $beginDate = date('Y-m-d H:i:s',strtotime($beginDate) - $timezone * 3600);
        $endDate = date('Y-m-d H:i:s',strtotime($endDate) - $timezone * 3600);

        $data = ['patrolinterval'=>$lampData['patrolinterval']];
        if ($type == 0) {  // 路灯
            $sql = 'select LI.loadvoltage as lampvoltage,LI.loadcurrent as lampcurrent,LI.lighteness,LI.loadpower as lamppower,LI.updatetime from realtime_info_log as LI where LI.lampid = '.$lampId.' and LI.updatetime >= "'.$beginDate.'" and LI.updatetime <= "'.$endDate.'"';

            $list = $this->db->query($sql)->result_array();
            $temp = [];
            foreach ($list as $value) {
                $temp['lampvoltage'][] = $value['lampvoltage'];
                $temp['lampcurrent'][] = $value['lampcurrent'];
                $temp['lamppower'][] = $value['lamppower'];
                $temp['lighteness'][] = $value['lighteness'];
                $temp['updatetime'][] = date_change($value['updatetime'],0,$timezone);
                if (!isset($data['maxcurrent'])) {
                    $data['maxcurrent'] = $value['lampcurrent'];
                }else{
                    $data['maxcurrent'] = $value['lampcurrent'] > $data['maxcurrent'] ? $value['lampcurrent'] : $data['maxcurrent'];
                }
                // if (!isset($data['maxdaychargemincurrent'])) {
                //     $data['maxdaychargemincurrent'] = $value['daychargemincurrent'];
                // }else{
                //     $data['maxdaychargemincurrent'] = $value['daychargemincurrent'] > $data['maxdaychargemincurrent'] ? $value['daychargemincurrent'] : $data['maxdaychargemincurrent'];
                // }
                if (!isset($data['mincurrent'])) {
                    $data['mincurrent'] = $value['lampcurrent'];
                }else{
                    $data['mincurrent'] = $value['lampcurrent'] < $data['mincurrent'] ? $value['lampcurrent'] : $data['mincurrent'];
                }
                if (!isset($data['maxvoltage'])) {
                    $data['maxvoltage'] = $value['lampvoltage'];
                }else{
                    $data['maxvoltage'] = $value['lampvoltage'] > $data['maxvoltage'] ? $value['lampvoltage'] : $data['maxvoltage'];
                }
                if (!isset($data['minvoltage'])) {
                    $data['minvoltage'] = $value['lampvoltage'];
                }else{
                    $data['minvoltage'] = $value['lampvoltage'] < $data['minvoltage'] ? $value['lampvoltage'] : $data['minvoltage'];
                }
                if (!isset($data['maxpower'])) {
                    $data['maxpower'] = $value['lamppower'];
                }else{
                    $data['maxpower'] = $value['lamppower'] > $data['maxpower'] ? $value['lamppower'] : $data['maxpower'];
                }
                if (!isset($data['minpower'])) {
                    $data['minpower'] = $value['lamppower'];
                }else{
                    $data['minpower'] = $value['lamppower'] < $data['minpower'] ? $value['lamppower'] : $data['minpower'];
                }
                if (!isset($data['maxlighteness'])) {
                    $data['maxlighteness'] = $value['lighteness'];
                }else{
                    $data['maxlighteness'] = $value['lighteness'] > $data['maxlighteness'] ? $value['lighteness'] : $data['maxlighteness'];
                }
                if (!isset($data['minlighteness'])) {
                    $data['minlighteness'] = $value['lighteness'];
                }else{
                    $data['minlighteness'] = $value['lighteness'] < $data['minlighteness'] ? $value['lighteness'] : $data['minlighteness'];
                }
                // if (isset($data['maxdaychargemincurrent'])) {
                //     $h = floor($data['maxdaychargemincurrent'] / 3600);
                //     $h = $h < 10 ? '0'.$h : $h;
                //     $m = floor($data['maxdaychargemincurrent'] / 3600 % 60);
                //     $m = $m < 10 ? '0'.$m : $m;
                //     $data['maxdaychargemincurrent'] = $h.':'.$m;
                // }
            }
            $list = $temp;
        }elseif ($type == 1) { // 蓄电池
            $sql = 'select batvoltage as battvoltage,batcurrent as chargecurrent,chgtemper as batttemper,batpower as chargepower,updatetime from realtime_info_log where lampid = '.$lampId.' and updatetime >= "'.$beginDate.'" and updatetime <= "'.$endDate.'"';
            $list = $this->db->query($sql)->result_array();
            $temp = [];
            foreach ($list as $value) {
                $temp['battvoltage'][] = $value['battvoltage'];
                $temp['updatetime'][] = date_change($value['updatetime'],8,$timezone);
                
                $batterycurrent = $value['chargecurrent'];
                $temp['batterycurrent'][] = $batterycurrent;
                
                $batterypower = $value['chargepower'];
                $temp['batterypower'][] = $batterypower;
                if (!isset($data['maxcurrent'])) {
                    $data['maxcurrent'] = $batterycurrent;
                }else{
                    $data['maxcurrent'] = $batterycurrent > $data['maxcurrent'] ? $batterycurrent : $data['maxcurrent'];
                }
                if (!isset($data['mincurrent'])) {
                    $data['mincurrent'] = $batterycurrent;
                }else{
                    $data['mincurrent'] = $batterycurrent < $data['mincurrent'] ? $batterycurrent : $data['mincurrent'];
                }
                if (!isset($data['maxvoltage'])) {
                    $data['maxvoltage'] = $value['battvoltage'];
                }else{
                    $data['maxvoltage'] = $value['battvoltage'] > $data['maxvoltage'] ? $value['battvoltage'] : $data['maxvoltage'];
                }
                if (!isset($data['minvoltage'])) {
                    $data['minvoltage'] = $value['battvoltage'];
                }else{
                    $data['minvoltage'] = $value['battvoltage'] < $data['minvoltage'] ? $value['battvoltage'] : $data['minvoltage'];
                }
                if (!isset($data['maxbatttemper'])) {
                    $data['maxbatttemper'] = $value['batttemper'];
                }else{
                    $data['maxbatttemper'] = $value['batttemper'] > $data['maxbatttemper'] ? $value['batttemper'] : $data['maxbatttemper'];
                }
                if (!isset($data['minbatttemper'])) {
                    $data['minbatttemper'] = $value['batttemper'];
                }else{
                    $data['minbatttemper'] = $value['batttemper'] < $data['minbatttemper'] ? $value['batttemper'] : $data['minbatttemper'];
                }
                if (!isset($data['maxpower'])) {
                    $data['maxpower'] = round($batterypower,2);
                }else{
                    $data['maxpower'] = $batterypower > $data['maxpower'] ? round($batterypower,2) : round($data['maxpower'],2);
                }
                if (!isset($data['minpower'])) {
                    $data['minpower'] = round($batterypower,2);
                }else{
                    $data['minpower'] = $batterypower < $data['minpower'] ? round($batterypower,2) : round($data['minpower'],2);
                }

            }
            $list = $temp;
        }elseif ($type == 2) {  // 太阳能板
            $sql = 'select SI.panelvoltage as solarvoltage,SI.panelcurrent as solarcurrent,SI.panelpower as solarpower,SI.updatetime from realtime_info_log as SI where SI.lampid = '.$lampId.' and SI.updatetime >= "'.$beginDate.'" and SI.updatetime <= "'.$endDate.'"';
            $list = $this->db->query($sql)->result_array();
            $temp = [];
            foreach ($list as $value) {
                $temp['solarvoltage'][] = $value['solarvoltage'];
                $temp['solarcurrent'][] = $value['solarcurrent'];
                $temp['solarpower'][] = $value['solarpower'];
                $temp['updatetime'][] = date_change($value['updatetime'],8,$timezone);
                if (!isset($data['maxcurrent'])) {
                    $data['maxcurrent'] = $value['solarcurrent'];
                }else{
                    $data['maxcurrent'] = $value['solarcurrent'] > $data['maxcurrent'] ? $value['solarcurrent'] : $data['maxcurrent'];
                }
                if (!isset($data['mincurrent'])) {
                    $data['mincurrent'] = $value['solarcurrent'];
                }else{
                    $data['mincurrent'] = $value['solarcurrent'] < $data['mincurrent'] ? $value['solarcurrent'] : $data['mincurrent'];
                }
                if (!isset($data['maxvoltage'])) {
                    $data['maxvoltage'] = $value['solarvoltage'];
                }else{
                    $data['maxvoltage'] = $value['solarvoltage'] > $data['maxvoltage'] ? $value['solarvoltage'] : $data['maxvoltage'];
                }
                // if (!isset($data['maxdaydischargemincurrent'])) {
                //     $data['maxdaydischargemincurrent'] = $value['daydischargemincurrent'];
                // }else{
                //     $data['maxdaydischargemincurrent'] = $value['daydischargemincurrent'] > $data['maxdaydischargemincurrent'] ? $value['daydischargemincurrent'] : $data['maxdaydischargemincurrent'];
                // }
                if (!isset($data['minvoltage'])) {
                    $data['minvoltage'] = $value['solarvoltage'];
                }else{
                    $data['minvoltage'] = $value['solarvoltage'] < $data['minvoltage'] ? $value['solarvoltage'] : $data['minvoltage'];
                }
                if (!isset($data['maxpower'])) {
                    $data['maxpower'] = $value['solarpower'];
                }else{
                    $data['maxpower'] = $value['solarpower'] > $data['maxpower'] ? $value['solarpower'] : $data['maxpower'];
                }
                if (!isset($data['minpower'])) {
                    $data['minpower'] = $value['solarpower'];
                }else{
                    $data['minpower'] = $value['solarpower'] < $data['minpower'] ? $value['solarpower'] : $data['minpower'];
                }
                if (isset($data['maxdaydischargemincurrent'])) {
                    $h = floor($data['maxdaydischargemincurrent'] / 3600);
                    $h = $h < 10 ? '0'.$h : $h;
                    $m = floor($data['maxdaydischargemincurrent'] / 3600 % 60);
                    $m = $m < 10 ? '0'.$m : $m;
                    $data['maxdaydischargemincurrent'] = $h.':'.$m;
                }
            }
            $list = $temp;
        }else{  // 电量
            $sql = 'select daychargeah,daydischarah,updatetime from battery_info_log where lampid = '.$lampId.' and updatetime >= "'.$beginDate.'" and updatetime <= "'.$endDate.'"';
            $list = $this->db->query($sql)->result_array();
            $temp = [];
            foreach ($list as $value) {
                $temp['daychargeah'][] = $value['daychargeah'];
                $temp['daydischarah'][] = $value['daydischarah'];
                $temp['updatetime'][] = date_change($value['updatetime'],8,$timezone);
                if (!isset($data['maxdaychargeah'])) {
                    $data['maxdaychargeah'] = $value['daychargeah'];
                }else{
                    $data['maxdaychargeah'] = $value['daychargeah'] > $data['maxdaychargeah'] ? $value['daychargeah'] : $data['maxdaychargeah'];
                }
                if (!isset($data['mindaychargeah'])) {
                    $data['mindaychargeah'] = $value['daychargeah'];
                }else{
                    $data['mindaychargeah'] = $value['daychargeah'] < $data['mindaychargeah'] ? $value['daychargeah'] : $data['mindaychargeah'];
                }
                if (!isset($data['maxdaydischarah'])) {
                    $data['maxdaydischarah'] = $value['daydischarah'];
                }else{
                    $data['maxdaydischarah'] = $value['daydischarah'] > $data['maxdaydischarah'] ? $value['daydischarah'] : $data['maxdaydischarah'];
                }
                if (!isset($data['mindaydischarah'])) {
                    $data['mindaydischarah'] = $value['daydischarah'];
                }else{
                    $data['mindaydischarah'] = $value['daydischarah'] < $data['mindaydischarah'] ? $value['daydischarah'] : $data['mindaydischarah'];
                }
            }
            $list = $temp;
        }

        if (empty($list)) {
            $data['list'] = new StdClass();
        }else{
            $data['list'] = $list;
        }
        exit(json_result('0000',$this->response['0000'],$data));
    }
}