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 = array('L.projectid'=>$project_id);
        $filter = 'L.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['L.manu'] = $company;
                $filter .= ' AND L.manu = '.$company;
            }elseif ($type == 3) {
                // $filter['L.supplier'] = $company;
                $filter .= ' AND L.supplier = '.$company;
            }elseif ($type == 4) {
                // $filter['L.po'] = $company;
                $filter .= ' AND L.po = '.$company;
            }else {
                // $filter['L.upazilla'] = $company;
                // $filter .= ' AND L.upazilla = '.$company;
                $filter .= ' AND P.cityid = '.$company;
            }
        }
        // if (!empty($section)) $filter['L.section'] = $section;
        if (!empty($section)) $filter .= ' AND L.section = "'.$section.'"';
        $offline = $this->input->post('offline', true);
        // if (!empty($offline)) $filter['L.netstatus'] = 0;
        if (!empty($offline)) $filter .= ' AND L.netstatus = 0';
        $online = $this->input->post('online', true);
        // if (!empty($online)) $filter['L.netstatus'] = 1;
        if (!empty($online)) $filter .= ' AND L.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['L.number|L.section|L.address'] = $keyword;
        if ($keyword !== '' && $keyword !== null) $filter .= ' AND (L.number like "%'.$keyword.'%" OR L.section like "%'.$keyword.'%" OR L.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';
            }else{
                $fields .= ",RI.updatetime";
            }
            $join = array();
            $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']);
        $data['total_data']['install_num'] = $this->Lamp_model->get_count(array('projectid'=>$project_id));
        $data['total_data']['light_num'] = $this->Lamp_model->get_count(array('projectid'=>$project_id,'netstatus'=>1,'status'=>1));
        $data['total_data']['online_num'] = $this->Lamp_model->get_count(array('projectid'=>$project_id,'netstatus'=>1));

        $data['total_data']['fault_count'] = $this->Lamp_model->get_fault_count(array('L.projectid'=>$project_id,'L.isfaulted'=>1,'AI.status'=>0), $role, '', $userid,$project_id);
        $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_total('L.projectid', $pid_arr, 'L.id') : array();
        $result = $this->Lamp_model->get_count(['projectid'=>$pid_arr]);
        $data['total'] = $res['total'];
        $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);
        $clientid = $this->input->post('clientid',true);
        $version = $this->session->userdata('version');


        $lamp_id = $this->input->post('lamp_id', true);
        if (empty($lamp_id)) {
            exit(json_result('0411', $this->response['0411'], array()));
        }
        $ids = explode(',', $lamp_id);
        $status = 1;
        foreach ($ids as $v) {
            $record['cmdtype'] = 0;
            $record['relateid'] = $v;
            $record['statuscmd'] = 0;
            $record['updatetime'] = date("Y-m-d H:i:s");
            $recordid = $this->Batmanage_model->get_record_id($record, 'batch_update_cmd');
            if(!$recordid){
                exit(json_result('0009', $this->response['0009'], array()));
            }
            if ($recordid != -1) {
                $status = 0;
                $cmd = '{"cmd_type":"batch_update_cmd","cmd_id":'.$recordid.'}';
                $lampData = $this->Lamp_model->getOne($v,'N.status,N.protocoltype,L.protocoltype as lampprotocoltype');
                if ($lampData['protocoltype'] == 4 || $lampData['protocoltype'] == 6) {
                    $url = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['SERVER_NAME'].'/api/device/lampcontrol/update_asy';
                    doAsyncRequest($url,['clientid'=>$clientid,'username'=>$username,'client_key'=>$client_key,'token'=>$token,'version'=>$version,'lamp_id'=>$v]);
                    continue;
                }
                if (isset($lampData['protocoltype']) && $lampData['protocoltype'] != 0) {
                    $cmdret = send_cmd($cmd,1,0,$lampData['protocoltype']);
                    if ($cmdret === false) {
                        sleep(1);
                        $cmdret = send_cmd($cmd,1,0,$lampData['protocoltype']);
                    }
                }else{
                    $cmdret = send_cmd($cmd,0,0,$lampData['protocoltype']);
                    if ($cmdret === false) {
                        sleep(1);
                        $cmdret = send_cmd($cmd,0,0,$lampData['protocoltype']);
                    }
                }
                if($cmdret === false){
                    exit(json_result('0008', $this->response['0008'], array()));
                }
            }
        }
        sleep(2);
        if ($status) {
            exit(json_result('0406', $this->response['0406'], array()));
        }else{
            exit(json_result('0407', $this->response['0407'], array()));
        }

    }

    // 异步更新数据
    public function update_asy(){
        $lamp_id = $this->input->post('lamp_id',true);
        $lampData = $this->Lamp_model->getOne($lamp_id,'L.number,N.protocoltype,L.protocoltype as lampprotocoltype,L.address,L.networkid,N.status,N.deviceid');
        if ($lampData['lampprotocoltype'] == 0) {
            $address = '';
            if (mb_strlen($lampData['address']) >= 8) {
                $address = mb_substr($lampData['address'], -8);
            }else{
                $address = '00000000';
            }
            $sendData = $address.'0300004646';

            if ($lampData['protocoltype'] == 4) {
                $res = lampMqttCmd('/IDCOL/CmdInput/'.$lampData['address'],'/IDCOL/CmdOutput/'.$lampData['address'],pack('H*','0001'.$sendData));
            }else{
                // $cmd .= crc16(pack('H*',$sendData));
                device_cmd($lampData['deviceid'],pack('H*',$sendData));
                $cmd = '{"type":"cmd","deviceId":"'.$lampData['address'].'"}';
                $info = send_lorawan_915($cmd);
                $res = array();
                if (!empty($info)) {
                    $info = json_decode($info,true);
                    if ($info && $info['res'] == 0) $res['msg'] = $info['resInfo'];
                }
                $file = fopen('./file/lorawan.txt', 'a+');
                fwrite($file, $res.'----'.date('Y-m-d H:i:s',time()).'
');
                fclose($file);
                // die;
            }
            
            if (!empty($res)) {
                $msg1 = $res['msg'];
                // 数据校验
                $msg = mb_substr($msg1, 10);
                $t = 0;
                for ($i=0; $i < mb_strlen($msg) / 2 - 1; $i++) {
                    $s = mb_substr($msg, $i*2,2);
                    $t += base_convert($s, 16, 10);
                }
                $t = base_convert($t, 10, 16);
                if (mb_strlen($t) > 2) {
                    $t = mb_substr($t, -2);
                }elseif($t <= 1){
                    $t = '0'.$t;
                }
                if ($t == mb_substr($msg, -2)) {  
                    // 校验通过，解析数据
                    $updatetime = date('Y-m-d H:i:s',time());
                    // 系统信息
                    $systemInfoStr = mb_substr($msg1, 16,6);
                    $systemInfo = array(
                        'sysvoltage' => base_convert(mb_substr($systemInfoStr, 0,2), 16, 10),
                        'syscurrent' => base_convert(mb_substr($systemInfoStr, 2,2), 16, 10),
                        'temper' => bitDecode(mb_substr($systemInfoStr, 4,2)),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $this->db->insert('system_info_log', $systemInfo);

                    // 路灯信息
                    $lampInfoStr = mb_substr($msg1, 22,12);
                    $lampInfo = array(
                        'lampvoltage' => round(base_convert(mb_substr($lampInfoStr, 2,4), 16, 10)/10,1),
                        'lampcurrent' => round(base_convert(mb_substr($lampInfoStr, 6,4), 16, 10)/100,2),
                        'temper' => bitDecode(mb_substr($lampInfoStr, 10,2)),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $lampInfo['lamppower'] = round($lampInfo['lampvoltage'] * $lampInfo['lampcurrent'],2);
                    $light = base_convert(mb_substr($lampInfoStr, 0,2), 16, 2);
                    if (mb_strlen($light) == 8) {
                        $lampInfo['lighteness'] = base_convert(mb_substr($light, -7), 2, 10);
                        $lampInfo['lampstatus'] = 1;
                    }else{
                        $lampInfo['lighteness'] = 0;
                        $lampInfo['lampstatus'] = 0;
                    }
                    $this->db->insert('lamp_info_log', $lampInfo);

                    // 太阳能信息
                    $solarInfoStr = mb_substr($msg1, 34,8);
                    $solarInfo = array(
                        'solarvoltage' => round(base_convert(mb_substr($solarInfoStr, 0,4), 16, 10)/10,1),
                        'solarcurrent' => round(base_convert(mb_substr($solarInfoStr, 4,4), 16, 10)/100,2),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $solarInfo['solarpower'] = round($solarInfo['solarvoltage'] * $solarInfo['solarcurrent'],2);
                    $this->db->insert('solar_info_log', $solarInfo);

                    // 蓄电池信息
                    $batterInfoStr = mb_substr($msg1, 42,70);
                    $batteryInfo = array(
                        'battvoltage' => round(base_convert(mb_substr($batterInfoStr, 2,4), 16, 10)/10,1),
                        'chargecurrent' => round(base_convert(mb_substr($batterInfoStr, 6,4), 16, 10)/100,2),
                        'discharcurrent' => round(base_convert(mb_substr($batterInfoStr, 10,4), 16, 10)/100,2),
                        'batttemper' => bitDecode(mb_substr($batterInfoStr, 14,2)),
                        'electrictotal' => base_convert(mb_substr($batterInfoStr, 16,4),16,10),
                        'electricleft' => base_convert(mb_substr($batterInfoStr, 20,4),16,10),
                        'electricSOC' => base_convert(mb_substr($batterInfoStr, 24,2),16,10),
                        'voltagedaymin' => round(base_convert(mb_substr($batterInfoStr, 26,4),16,10)/10,1),
                        'voltagedaymax' => round(base_convert(mb_substr($batterInfoStr, 30,4),16,10)/10,1),
                        'daychargeah' => round(base_convert(mb_substr($batterInfoStr, 34,4),16,10)/10,1),
                        'daydischarah' => round(base_convert(mb_substr($batterInfoStr, 38,4),16,10)/10,1),
                        'daychargemaxpow' => round(base_convert(mb_substr($batterInfoStr, 42,4),16,10)/10,1),
                        'daydischarmaxpow' => round(base_convert(mb_substr($batterInfoStr, 46,4),16,10)/10,1),
                        'daychargemincurrent' => base_convert(mb_substr($batterInfoStr, 50,4),16,10),
                        'daycharmaxcurrent' => round(base_convert(mb_substr($batterInfoStr, 54,4),16,10)/100,2),
                        'daydischargemincurrent' => base_convert(mb_substr($batterInfoStr, 58,4),16,10),
                        'daydischarmaxcurrent' => round(base_convert(mb_substr($batterInfoStr, 62,4),16,10)/100,2),
                        'daybattmintemper' => bitDecode(mb_substr($batterInfoStr, 66,2)),
                        'daybattmaxtemper' => bitDecode(mb_substr($batterInfoStr, 68,2)),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $batteryInfo['chargepower'] = round($batteryInfo['chargecurrent'] * $batteryInfo['battvoltage'],2);
                    $batteryInfo['dischargepower'] = round($batteryInfo['discharcurrent'] * $batteryInfo['battvoltage'],2);
                    $chargestage = base_convert(mb_substr($solarInfoStr, 0,2), 16, 2);
                    $chargestage = mb_strlen($chargestage) < 8 ? mb_substr('00000000'.$chargestage, -8) : $chargestage;

                    $batteryInfo['chargestage'] = base_convert(mb_substr($chargestage, 0,4).'0000', 2, 10);
                    $batteryInfo['battstatus'] = base_convert(mb_substr($chargestage, -4), 2, 10);
                    $this->db->insert('battery_info_log', $batteryInfo);

                    // 发用电量信息
                    $eleInfoStr = mb_substr($msg1, 112,24);
                    $eleInfo = array(
                        'daygeneration' => round(base_convert(mb_substr($eleInfoStr, 0,4),16,10)/10,1),
                        'dayconsumption' => round(base_convert(mb_substr($eleInfoStr, 4,4),16,10)/10,1),
                        'totalgeneration' => round(base_convert(mb_substr($eleInfoStr, 8,8),16,10)/10,1),
                        'totalconsumption' => round(base_convert(mb_substr($eleInfoStr, 16,8),16,10)/10,1),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $this->db->insert('electric_info_log', $eleInfo);

                    // 历史数据信息
                    $historyInfoStr = mb_substr($msg1, 136,12);
                    $historyInfo = array(
                        'rundays' => base_convert(mb_substr($historyInfoStr, 0,4),16,10),
                        'overtimes' => base_convert(mb_substr($historyInfoStr, 4,4),16,10),
                        'fulltimes' => base_convert(mb_substr($historyInfoStr, 8,4),16,10),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $historyInfo['totalchargeah'] = $batteryInfo['daychargeah'];
                    $historyInfo['totaldischarah'] = $batteryInfo['daydischarah'];
                    $this->db->insert('history_info_log', $historyInfo);

                    // 故障信息
                    $alarmInfoStr = mb_substr($msg1, 148,8);
                    $alarmInfo = array(
                        'alarmtype' => 0,
                        'stralarmtype' => '',
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $alarmArr = array('0'=>'过放','1'=>'超压','2'=>'负载短路','3'=>'电池故障','4'=>'内部超温','5'=>'外部超温','7'=>'负载开路','8'=>'输出电容超压保护','10'=>'电池板短路','11'=>'电池板超压','13'=>'充电逆流','15'=>'锂电池低温关闭充电');
                    $isfaulted = 0;
                    if ($alarmInfoStr != '00000000') {
                        $res = base_convert($alarmInfoStr, 16, 2);
                        var_dump($res);
                        $res = strrev($res);
                        $t = array();
                        for ($i=0; $i < mb_strlen($res); $i++) { 
                            if (mb_substr($res, $i,1) == 1 && isset($alarmArr[$i])) {
                                $t[] = $alarmArr[$i];
                            }
                        }
                        if (!empty($t)) {
                            $alarmInfo['alarmtype'] = base_convert($alarmInfoStr, 16, 10);
                            $alarmInfo['stralarmtype'] = implode(',', $t);
                        }
                    }
                    if (!empty($alarmInfo['stralarmtype'])) {
                        $this->db->insert('alarm_info_log', $alarmInfo);
                        $isfaulted = 1;
                    }
                    $this->Lamp_model->update(array('id'=>$lamp_id),array('status'=>$lampInfo['lampstatus'],'lighteness'=>$lampInfo['lighteness'],'isfaulted'=>$isfaulted));
                    if ($lampData['status'] == 0) $this->Network_model->update(array('id'=>$lampData['networkid']),array('status'=>1));
                }
            }
            
        }elseif ($lampData['lampprotocoltype'] == 1) {
            $sendData = '0103000a0002e409';
            $res = lampMqttCmd('/IDCOL/CmdInput/'.$lampData['address'],'/IDCOL/CmdOutput/'.$lampData['address'],pack('H*','0001'.$sendData));
            if (!empty($res) && strtolower(crc16(pack('H*',mb_substr($res['msg'], 0,-4)))) == strtolower(mb_substr($res['msg'], -4))) {
                $sysInfoStr = $res['msg'];
                $sendData = '010300fd003115ee';
                $res = lampMqttCmd('/IDCOL/CmdInput/'.$lampData['address'],'/IDCOL/CmdOutput/'.$lampData['address'],pack('H*','0001'.$sendData));
                if (!empty($res) && strtolower(crc16(pack('H*',mb_substr($res['msg'], 0,-4)))) == strtolower(mb_substr($res['msg'], -4))) {
                    $data = array();
                    $msg = $res['msg'];
                    // 校验通过，解析数据
                    $updatetime = date('Y-m-d H:i:s',time());
                    // 系统信息
                    $systemInfo = array(
                        'sysvoltage' => base_convert(mb_substr($sysInfoStr, 6,2), 16, 10),
                        'syscurrent' => base_convert(mb_substr($sysInfoStr, 8,2), 16, 10),
                        'temper' => bitDecode(mb_substr($msg, 30,2)),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $this->db->insert('system_info_log', $systemInfo);

                    // 路灯信息
                    $lampInfoStr = mb_substr($msg, 34,12);
                    $lampInfo = array(
                        'lampvoltage' => round(base_convert(mb_substr($lampInfoStr, 0,4), 16, 10)/10,1),
                        'lampcurrent' => round(base_convert(mb_substr($lampInfoStr, 4,4), 16, 10)/100,2),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                        'lamppower' => base_convert(mb_substr($lampInfoStr, 8,4), 16, 10),
                    );

                    $light = base_convert(mb_substr($msg, 6,2), 16, 2);
                    if (base_convert(mb_substr('00000000'.$light, -7), 2, 10) > 0) {
                        $lampInfo['lighteness'] = base_convert(mb_substr($light, -7), 2, 10);
                        $lampInfo['lampstatus'] = 1;
                    }else{
                        $lampInfo['lighteness'] = 0;
                        $lampInfo['lampstatus'] = 0;
                    }
                    $this->db->insert('lamp_info_log', $lampInfo);

                    // 太阳能信息
                    $solarInfoStr = mb_substr($msg, 46,12);
                    $solarInfo = array(
                        'solarvoltage' => round(base_convert(mb_substr($solarInfoStr, 0,4), 16, 10)/10,1),
                        'solarcurrent' => round(base_convert(mb_substr($solarInfoStr, 4,4), 16, 10)/100,2),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $solarInfo['solarpower'] = round($solarInfo['solarvoltage'] * $solarInfo['solarcurrent'],2);
                    $this->db->insert('solar_info_log', $solarInfo);

                    // 蓄电池信息
                    // $batterInfoStr = mb_substr($msg, 42,70);
                    $batteryInfo = array(
                        'battvoltage' => round(base_convert(mb_substr($msg, 22,4), 16, 10)/10,1),
                        'chargecurrent' => round(base_convert(mb_substr($msg, 26,4), 16, 10)/100,2),
                        // 'discharcurrent' => round(base_convert(mb_substr($msg, 10,4), 16, 10)/100,2),
                        'batttemper' => bitDecode(mb_substr($msg, 32,2)),
                        // 'electrictotal' => base_convert(mb_substr($msg, 16,4),16,10),
                        // 'electricleft' => base_convert(mb_substr($msg, 20,4),16,10),
                        'electricSOC' => base_convert(mb_substr($msg, 18,4),16,10),
                        'voltagedaymin' => round(base_convert(mb_substr($msg, 62,4),16,10)/10,1),
                        'voltagedaymax' => round(base_convert(mb_substr($msg, 66,4),16,10)/10,1),
                        'daychargeah' => base_convert(mb_substr($msg, 86,4),16,10),
                        'daydischarah' => base_convert(mb_substr($msg, 90,4),16,10),
                        'daychargemaxpow' => base_convert(mb_substr($msg, 78,4),16,10),
                        'daydischarmaxpow' => base_convert(mb_substr($msg, 82,4),16,10),
                        'daychargemincurrent' => base_convert(mb_substr($msg, 174,4),16,10),
                        'daycharmaxcurrent' => round(base_convert(mb_substr($msg, 70,4),16,10)/100,2),
                        'daydischargemincurrent' => base_convert(mb_substr($msg, 194,4),16,10),
                        'daydischarmaxcurrent' => round(base_convert(mb_substr($msg, 74,4),16,10)/100,2),
                        'daybattmintemper' => doubBitDecode(mb_substr($msg, 162,4)),
                        'daybattmaxtemper' => doubBitDecode(mb_substr($msg, 158,4)),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $batteryInfo['chargepower'] = round($batteryInfo['chargecurrent'] * $batteryInfo['battvoltage'],2);
                    // $batteryInfo['dischargepower'] = round($batteryInfo['discharcurrent'] * $batteryInfo['battvoltage'],2);
                    $status = base_convert(mb_substr($msg, 8,2),16,10);
                    if (mb_strlen($light) == 8 && mb_substr($light, 0,1) == 1) {
                        $batteryInfo['battstatus'] = 1;
                    }else{
                        if ($status != 0){
                            $batteryInfo['battstatus'] = 2;
                        }else{
                            $batteryInfo['battstatus'] = 0;
                        }
                    }

                    $batteryInfo['chargestage'] = $status;
                    $this->db->insert('battery_info_log', $batteryInfo);

                    // 发用电量信息
                    // $eleInfoStr = mb_substr($msg1, 112,24);
                    $eleInfo = array(
                        'daygeneration' => round(base_convert(mb_substr($msg, 94,4),16,10)/1000,3),
                        'dayconsumption' => round(base_convert(mb_substr($msg, 98,4),16,10)/1000,3),
                        'totalgeneration' => round(base_convert(mb_substr($msg, 134,8),16,10)/1000,3),
                        'totalconsumption' => round(base_convert(mb_substr($msg, 142,8),16,10)/1000,3),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $this->db->insert('electric_info_log', $eleInfo);

                    // 历史数据信息
                    $historyInfoStr = mb_substr($msg, 102,28);
                    $historyInfo = array(
                        'rundays' => base_convert(mb_substr($historyInfoStr, 0,4),16,10),
                        'overtimes' => base_convert(mb_substr($historyInfoStr, 4,4),16,10),
                        'fulltimes' => base_convert(mb_substr($historyInfoStr, 8,4),16,10),
                        'totalchargeah' => base_convert(mb_substr($historyInfoStr, 12,8),16,10),
                        'totaldischarah' => base_convert(mb_substr($historyInfoStr, 20,8),16,10),
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $this->db->insert('history_info_log', $historyInfo);

                    // 故障信息
                    $alarmInfoStr = mb_substr($msg, 10,8);
                    $alarmInfo = array(
                        'alarmtype' => 0,
                        'stralarmtype' => '',
                        'updatetime' => $updatetime,
                        'lampid' => $lamp_id,
                    );
                    $alarmArr = array('10'=>'BMS过充保护','11'=>'电池低温保护，停止充电','12'=>'电池反接','13'=>'电容超压','14'=>'感应探头损坏','15'=>'负载开路','16'=>'蓄电池过放','17'=>'蓄电池超压','18'=>'欠压警告','19'=>'负载短路','20'=>'负载功率过大或负载过流','21'=>'控制器温度过高','22'=>'外部环境温度过高','23'=>'光伏输入功率过大','24'=>'光伏输入端短路','25'=>'光伏输入端超压','26'=>'太阳板逆流','27'=>'太阳板工作点超压','28'=>'太阳板反接');
                    $isfaulted = 0;
                    if ($alarmInfoStr != '00000000') {
                        $res = base_convert($alarmInfoStr, 16, 2);
                        var_dump($res);
                        $res = strrev($res);
                        $t = array();
                        for ($i=0; $i < mb_strlen($res); $i++) { 
                            if (mb_substr($res, $i,1) == 1 && isset($alarmArr[$i])) {
                                $t[] = $alarmArr[$i];
                            }
                        }
                        if (!empty($t)) {
                            $alarmInfo['alarmtype'] = base_convert($alarmInfoStr, 16, 10);
                            $alarmInfo['stralarmtype'] = implode(',', $t);
                        }
                    }
                    if (!empty($alarmInfo['stralarmtype'])) {
                        $this->db->insert('alarm_info_log', $alarmInfo);
                        $isfaulted = 1;
                    }
                    $this->Lamp_model->update(array('id'=>$lamp_id),array('status'=>$lampInfo['lampstatus'],'lighteness'=>$lampInfo['lighteness'],'isfaulted'=>$isfaulted));
                    if ($lampData['status'] == 0) $this->Network_model->update(array('id'=>$lampData['networkid']),array('status'=>1));
                }
            }
            
        }
    }

    // 灯控的开启/关闭(支持批量处理)
    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 = '12'.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),30);
        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];
            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()));
    }

    // 默认巡检设置
    private function patrol_set($lampid,$time = null){
        if (isset($time) && !empty($time)) {
            $where['id']                = $lampid;
            $update['patroltype']       = 1;
            $update['patrolinterval']   = $time;
            $update['updatetime']       = date("Y-m-d H:i:s");
            $update['nextquerytime']    = date("Y-m-d H:i:s");

            $ret = $this->Patrol_model->get_one($where);
            if(empty($ret)){
                $update['id'] = $where['id'];
                $this->Patrol_model->add($update);
            } else {
                $this->Patrol_model->update($update,$where);
            }
            $res = $this->Lamp_model->getOne($lampid,'N.protocoltype,L.address,L.protocoltype AS lampprotocoltype');
            if ($res['protocoltype'] == 4) {
                $sendData = '000101A501';;
                $sendData .= bitSubStr(base_convert(intval($time/5), 10, 16));
                lampMqttCmd('/lamp/WriteIn/'.$res['address'],'/lamp/WriteOut/'.$res['address'],pack('H*', $sendData),0);
                return;
            }
            if (isset($res['protocoltype']) && $res['protocoltype'] != 0) {
                $cmd = '{"cmd_type":"set_patrol_cmd","cmd_id":'.$where['id'].',"broadcast":0}';
                $cmdret = send_cmd($cmd,1, 0,$res['protocoltype']);
                // if ($cmdret === false) {
                //     sleep(1);
                //     $cmdret = send_cmd($cmd,1, 0,$res['protocoltype']);
                // }
            }
        }
        
        //$cmd = '{"cmd_type":"patrol_cmd","cmd_id":'.$where['id'].',"broadcast":0}';
        //$cmdret = send_cmd($cmd, 1);
    }

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

        $workmode         = $this->input->post('workmode',true);
        $worktimefirst    = $this->input->post('worktimefirst',true);
        $workpowerfirst   = $this->input->post('workpowerfirst',true);
        $worktimesencond  = $this->input->post('worktimesencond',true);
        $workpowersencond = $this->input->post('workpowersencond',true);
        $worktimethird    = $this->input->post('worktimethird',true);
        $workpowerthird   = $this->input->post('workpowerthird',true);
        $worktimeforth    = $this->input->post('worktimeforth',true);
        $workpowerforth   = $this->input->post('workpowerforth',true);
        $voptically       = $this->input->post('voptically',true);
        $delaytime        = $this->input->post('delaytime',true);
        $ledloadcurrent   = $this->input->post('ledloadcurrent',true);
        $powercmd         = $this->input->post('powercmd',true);
        $switchfeature    = $this->input->post('switchfeature',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/device/lampcontrol/set_load_asy';

        foreach ($lampList as $l) {
            doAsyncRequest($url,['clientid'=>$clientid,'username'=>$username,'client_key'=>$client_key,'token'=>$token,'version'=>$version,'lamp_id'=>$l['id'],'workmode'=>$workmode,'worktimefirst'=>$worktimefirst,'workpowerfirst'=>$workpowerfirst,'worktimesencond'=>$worktimesencond,'workpowersencond'=>$workpowersencond,'worktimethird'=>$worktimethird,'workpowerthird'=>$workpowerthird,'worktimeforth'=>$worktimeforth,'workpowerforth'=>$workpowerforth,'voptically'=>$voptically,'delaytime'=>$delaytime,'ledloadcurrent'=>$ledloadcurrent,'powercmd'=>$powercmd,'switchfeature'=>$switchfeature]);
            
        }
        exit();
    }

    //更新负载设置
    public function set_load_asy(){
        $res = $this->load_update();
        $clientid = $this->input->post('clientid',true);
        $lampid = $this->input->post('lamp_id',true);
        $data = $this->Lamp_model->getData(array('id'=>$lampid),'projectid,networkid,address,number');
        if ($res['msg'] == '0000') {
            $projectData = $this->Project_model->getData(array('id'=>$data['projectid']),'projectname');
            $networkData = $this->Network_model->getData(array('id'=>$data['networkid']),'networkname');
            
            $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']}\".",0,1);
        }
        if (empty($res['result'])) {
            // exit(json_result($res['msg'],$res['msg'],array('number'=>$data['number'])));
            $data = ['code'=>$res['msg'],'status'=>2,'msg'=>$res['msg'],'data'=>['number'=>$data['number'],'type'=>'set_load','id'=>$lamp_id]];
            exit(send_websocket($clientid,$data));
        }else{
            // exit(json_result($res['msg'],$this->response[$res['msg']],array('number'=>$data['number'])));
            $data = ['code'=>$res['msg'],'status'=>2,'msg'=>$this->response[$res['msg']],'data'=>['number'=>$data['number'],'type'=>'set_load','id'=>$lamp_id]];
            exit(send_websocket($clientid,$data));
        }
    }

    //更新负载设置
    private function load_update(){
        $where['relateid']          = $this->input->post('lamp_id',true);
        $update['relateid']          = $this->input->post('lamp_id',true);
        $update['workmode']         = $this->input->post('workmode',true);
        $update['worktimefirst']    = $this->input->post('worktimefirst',true);
        $update['workpowerfirst']   = $this->input->post('workpowerfirst',true);
        $update['worktimesencond']  = $this->input->post('worktimesencond',true);
        $update['workpowersencond'] = $this->input->post('workpowersencond',true);
        $update['worktimethird']    = $this->input->post('worktimethird',true);
        $update['workpowerthird']   = $this->input->post('workpowerthird',true);
        $update['worktimeforth']    = $this->input->post('worktimeforth',true);
        $update['workpowerforth']   = $this->input->post('workpowerforth',true);
        $update['voptically']       = $this->input->post('voptically',true);
        $update['delaytime']        = $this->input->post('delaytime',true);
        $update['ledloadcurrent']   = $this->input->post('ledloadcurrent',true);
        $update['powercmd']         = $this->input->post('powercmd',true);
        $update['switchfeature']    = $this->input->post('switchfeature',true);
        $update['updatetime']       = date("Y-m-d H:i:s");

        return $this->load_set($where, $update, 0);
    }

    private function load_set($where,$update,$broadcast){
        $ret = $this->Load_model->get_data_by_filter(['relateid'=>$update['relateid'],'cmdtype'=>0]);
        if(empty($ret)){
            // $update['id'] = $where['id'];
            $id = $this->Load_model->insert($update);
        } else {
            $this->Load_model->update(['id'=>$ret['id']],$update);
            $id = $ret['id'];
        }
        
        $cmd = '{"cmd_type":"load_param_cmd","cmd_id":'.$id.',"broadcast":'.$broadcast.'}';
        $lampProData = $this->Lamp_model->getOne($where['relateid'],'N.protocoltype,L.address,L.protocoltype AS lampprotocoltype,N.deviceid');
        if (($lampProData['protocoltype'] == 4 || $lampProData['protocoltype'] == 6) && $lampProData['lampprotocoltype'] == 0) {
            $address = '';
            if (mb_strlen($lampProData['address']) >= 8) {
                $address = mb_substr($lampProData['address'], -8);
            }else{
                $address = '00000000';
            }
            $sendData = '10040010';
            $sendData .= bitSubStr(base_convert($update['workmode'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['worktimefirst'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['workpowerfirst'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['worktimesencond'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['workpowersencond'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['worktimethird'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['workpowerthird'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['worktimeforth'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['workpowerforth'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['delaytime'], 10, 16));
            $sendData .= doubBitSubStr(base_convert(intval($update['voptically']*10), 10, 16));
            $sendData .= doubBitSubStr(base_convert(intval($update['ledloadcurrent']), 10, 16));
            $sendData .= bitSubStr(base_convert($update['powercmd'], 10, 16));
            $sendData .= bitSubStr(base_convert($update['switchfeature'], 10, 16));
            $sum = 0;
            for ($i=0; $i < mb_strlen($sendData)/2; $i++) { 
                if ($i == 0) continue;
                $t = mb_substr($sendData, $i*2,2);
                $sum += base_convert($t, 16, 10);
            }
            $sum = base_convert($sum, 10, 16);
            $sendData .= bitSubStr($sum);
            $sendData = $address.$sendData;
            
            if ($lampProData['protocoltype'] == 4) {
                $res = lampMqttCmd('/IDCOL/CmdInput/'.$lampProData['address'],'/IDCOL/CmdOutput/'.$lampProData['address'],pack('H*','0001'.$sendData));
            }else{
                device_cmd($lampProData['deviceid'],pack('H*',$sendData));
                $cmd = '{"type":"cmd","deviceId":"'.$lampProData['address'].'"}';
                $info = send_lorawan_915($cmd);
                $res = array();
                if (!empty($info)) {
                    $info = json_decode($info,true);
                    if ($info && $info['res'] == 0) $res['msg'] = $info['resInfo'];
                }
            }
            
            if (empty($res)) {
                return array('result'=>1,'msg'=>'0016');
            }else{
                $msg1 = $res['msg'];
                // 数据校验
                $msg = mb_substr($msg1, 10);
                $t = 0;
                for ($i=0; $i < mb_strlen($msg) / 2 - 1; $i++) {
                    $s = mb_substr($msg, $i*2,2);
                    $t += base_convert($s, 16, 10);
                }
                $t = base_convert($t, 10, 16);
                if (mb_strlen($t) > 2) {
                    $t = mb_substr($t, -2);
                }elseif($t <= 1){
                    $t = '0'.$t;
                }
                if ($t == mb_substr($msg, -2)) {  
                    if (mb_substr($msg1, -10,-2) == '10040010') {
                        return array('result'=>1,'msg'=>'0000');
                    }else{
                        return array('result'=>1,'msg'=>'0010');
                    }
                }else{
                    return array('result'=>1,'msg'=>'0010');
                }
            }
        }

        if (isset($lampProData['protocoltype']) && $lampProData['protocoltype'] != 0) {
            $cmdret = send_cmd($cmd,1,30,$lampProData['protocoltype']);
            if ($cmdret === false) {
                sleep(1);
                $cmdret = send_cmd($cmd,1,30,$lampProData['protocoltype']);
            }
        }else{
            $cmdret = send_cmd($cmd,0,30,$lampProData['protocoltype']);
            if ($cmdret === false) {
                sleep(1);
                $cmdret = send_cmd($cmd,0,30,$lampProData['protocoltype']);
            }
        }
        
        $res = array(); 
        if (empty($cmdret)){
            $res['result'] = 1;
            $res['msg']    = '0016';
            return $res;
        }
        
        if($cmdret === false){
            $res['result'] = 1;
            $res['msg']    = '0008';
        } else {
            $res = json_decode($cmdret, true);
            if ($res['result'] == false) {
                $res['result'] = 0;
                $version = $this->input->post('version',true);
                if (empty($version)) {
                    $res['msg'] = empty($res['msg']) ? '未知错误' : transfer_error_tips($res['msg']);
                }else{
                    $res['msg'] = empty($res['msg']) ? 'Unknown error' : $res['msg'];
                }
            } else {
                $res['result'] = 1;
                $res['msg']    = '0000';
            }
        }
        return $res;
    }


    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['role'] = $this->input->post('role',true);
        $data['token'] = $this->input->post('token',true);
        $lamp_id = $this->input->post('lamp_id',true);
        $data['clientid'] = $this->input->post('clientid',true);
        $data['version'] = $this->session->userdata('version');

        $data['batterytype']              = $this->input->post('batterytype',true);//蓄电池类型 
        $data['vovervoltage']              = $this->input->post('vovervoltage',true);//超压电压
        $data['vlimitedcharge']              = $this->input->post('vlimitedcharge',true);//充电限制电压
        // $vlimitedcharge              = $this->input->post('vlimitedcharge',true);//Full charge voltage
        $data['vpromoterecover']          = $this->input->post('vpromoterecover',true);//充电返回电压
        $data['vpromotecharge']           = $this->input->post('vpromotecharge',true);//提升充电电压
        // $vpromotecharge           = $this->input->post('vpromotecharge',true);//提升充电电压 Direct charge voltage
        $data['vfloatingcharge']          = $this->input->post('vfloatingcharge',true);  // 浮充充电电压
        $data['voverdischargerecover']          = $this->input->post('voverdischargerecover',true);  // 过放返回电压
        $data['tempcompmin']              = $this->input->post('tempcompmin',true);  // 温度补偿最低温度
        $data['tempcompmax']              = $this->input->post('tempcompmax',true);  // 温度补偿最高温度
        // $tempcompmax              = $this->input->post('tempcompmax',true);  // Reduced start voltage 
        // $tempcompmax              = $this->input->post('tempcompmax',true);  // Reduced end voltage
        // $tempcompmax              = $this->input->post('tempcompmax',true);  // Light control voltage
        // $tempcompmax              = $this->input->post('tempcompmax',true);  // Light control delay time
        

        $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 ($lampList as $l) {
            $data['lamp_id'] = $l;
            doAsyncRequest($url,$data);
            
        }
    }

    // public function set_battery_asy(){
    //     $res = $this->battery_update();
    //     $clientid = $this->input->post('clientid',true);
    //     $lampid = $this->input->post('lamp_id',true);
    //     $data = $this->Lamp_model->getData(array('id'=>$lampid),'projectid,networkid,address,number');
    //     if ($res['msg'] == '0000') {
    //         $projectData = $this->Project_model->getData(array('id'=>$data['projectid']),'projectname');
    //         $networkData = $this->Network_model->getData(array('id'=>$data['networkid']),'networkname');
            
    //         $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']}\".",0,1);
    //     }
    //     if (empty($res['result'])) {
    //         // exit(json_result($res['msg'],$res['msg'],array('number'=>$data['number'])));
    //         $data = ['code'=>$res['msg'],'status'=>2,'msg'=>$res['msg'],'data'=>['number'=>$data['number'],'type'=>'set_load','id'=>$lamp_id]];
    //         exit(send_websocket($clientid,$data));
    //     }else{
    //         // exit(json_result($res['msg'],$this->response[$res['msg']],array('number'=>$data['number'])));
    //         $data = ['code'=>$res['msg'],'status'=>2,'msg'=>$this->response[$res['msg']],'data'=>['number'=>$data['number'],'type'=>'set_load','id'=>$lamp_id]];
    //         exit(send_websocket($clientid,$data));
    //     }
    // }

    //更新蓄电池设置
    public function set_battery_asy(){
        $clientid = $this->input->post('clientid',true);
        $where['id']                        = $this->input->post('lamp_id',true);//路灯id
        $data['batterytype']              = $this->input->post('batterytype',true);//蓄电池类型 
        $data['vovervoltage']              = $this->input->post('vovervoltage',true);//超压电压
        $data['vlimitedcharge']              = $this->input->post('vlimitedcharge',true);//充电限制电压
        // $vlimitedcharge              = $this->input->post('vlimitedcharge',true);//Full charge voltage
        $data['vpromoterecover']          = $this->input->post('vpromoterecover',true);//充电返回电压
        $data['vpromotecharge']           = $this->input->post('vpromotecharge',true);//提升充电电压
        // $vpromotecharge           = $this->input->post('vpromotecharge',true);//提升充电电压 Direct charge voltage
        $data['vfloatingcharge']          = $this->input->post('vfloatingcharge',true);  // 浮充充电电压
        $data['voverdischargerecover']          = $this->input->post('voverdischargerecover',true);  // 过放返回电压
        $data['tempcompmin']              = $this->input->post('tempcompmin',true);  // 温度补偿最低温度
        $data['tempcompmax']              = $this->input->post('tempcompmax',true);  // 温度补偿最高温度
        // $tempcompmax              = $this->input->post('tempcompmax',true);  // Reduced start voltage 
        // $tempcompmax              = $this->input->post('tempcompmax',true);  // Reduced end voltage
        // $tempcompmax              = $this->input->post('tempcompmax',true);  // Light control voltage
        // $tempcompmax              = $this->input->post('tempcompmax',true);  // Light control delay time
        $lampData = $this->Lamp_model->get_one($where,'projectid,address,number');
        $sendData = '100100010000000000';
        foreach ($data as $v) {
            if ($v === null || $v === '') {
                $lampData = $this->Lamp_model->getOne($where['id'],'number');
                $data = ['code'=>'0007','status'=>2,'msg'=>$this->response['0007'],'data'=>['number'=>$lampData['number'],'type'=>'set_load','id'=>$where['id']]];
                exit(send_websocket($clientid,$data));
            }
        }
        
        $len = doubBitSubStr(base_convert(intval(mb_strlen($sendData)/4), 10, 16)).bitSubStr(base_convert(intval(mb_strlen($sendData)/2), 10, 16));
        // $sendData = '0110e002'.$len.$sendData;
        $sendData .= crc16(pack('H*',$sendData));
        $res = lampMqttCmd('/IDCOL/CmdInput/'.$lampData['address'],'/IDCOL/CmdOutput/'.$lampData['address'],pack('H*','0001'.$sendData));

        
        $lampData = $this->Lamp_model->getData(array('id'=>$lampid),'projectid,address,number');
        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_load','id'=>$lamp_id]];
            exit(send_websocket($clientid,$data));
        }else{
            $data = ['code'=>$res['msg'],'status'=>2,'msg'=>$this->response[$res['msg']],'data'=>['number'=>$lampData['number'],'type'=>'set_load','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 : '';
        $upazilla = $this->input->post('upazilla',true);
        $data["upazilla"] = !empty($upazilla) ? $upazilla : '';
        $po = $this->input->post('po',true);
        $data["po"] = !empty($po) ? $po : '';
        $manu = $this->input->post('manu',true);
        $data["manu"] = !empty($manu) ? $manu : '';
        $protocoltype = $this->input->post('protocoltype',true);
        $data['protocoltype'] = $protocoltype;

        $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 == 3) {
                $data["supplier"] = $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()));
            }   

            $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'];
            }

            $data['createtime'] = date('Y-m-d H:i:s',time());

            $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()));
            }

            $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)));
    }

    // 获取负载参数设置
    public function load_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->getOne($lamp_id,'N.status,N.protocoltype,L.protocoltype as lampprotocoltype,L.address,L.number,N.deviceid');

        $cmd = '{"cmd_type":"get_load_setting_cmd","cmd_id":'.$lamp_id.',"broadcast":0}';
        
        if (($lampData['protocoltype'] == 4 || $lampData['protocoltype'] == 6) && $lampData['lampprotocoltype'] == 0) {
            $address = '';
            if (mb_strlen($lampData['address']) >= 8) {
                $address = mb_substr($lampData['address'], -8);
            }else{
                $address = '00000000';
            }
            $sendData = $address.'0304001014';
            
            if ($lampData['protocoltype'] == 4) {
                $res = lampMqttCmd('/IDCOL/CmdInput/'.$lampData['address'],'/IDCOL/CmdOutput/'.$lampData['address'],pack('H*','0001'.$sendData));
            }else{
                device_cmd($lampData['deviceid'],pack('H*',$sendData));
                $cmd = '{"type":"cmd","deviceId":"'.$lampData['address'].'"}';
                $info = send_lorawan_915($cmd);
                $res = array();
                if (!empty($info)) {
                    $info = json_decode($info,true);
                    if ($info && $info['res'] == 0) $res['msg'] = $info['resInfo'];
                }
            }
            
            if (empty($res)) {
                exit(json_result('0016', $this->response['0016']));
            }else{
                $msg1 = $res['msg'];
                // 数据校验
                $msg = mb_substr($msg1, 10);
                $t = 0;
                for ($i=0; $i < mb_strlen($msg) / 2 - 1; $i++) {
                    $s = mb_substr($msg, $i*2,2);
                    $t += base_convert($s, 16, 10);
                }
                $t = base_convert($t, 10, 16);
                if (mb_strlen($t) > 2) {
                    $t = mb_substr($t, -2);
                }elseif($t <= 1){
                    $t = '0'.$t;
                }
                if ($t == mb_substr($msg, -2)) {  
                    $data = array();
                    $dataStr = mb_substr($msg1, 16);
                    $data['workmode']         = base_convert(mb_substr($dataStr, 0,2), 16, 10);
                    $data['worktimefirst']    = base_convert(mb_substr($dataStr, 2,2), 16, 10);
                    $data['workpowerfirst']   = base_convert(mb_substr($dataStr, 4,2), 16, 10);
                    $data['worktimesencond']  = base_convert(mb_substr($dataStr, 6,2), 16, 10);
                    $data['workpowersencond'] = base_convert(mb_substr($dataStr, 8,2), 16, 10);
                    $data['worktimethird']    = base_convert(mb_substr($dataStr, 10,2), 16, 10);
                    $data['workpowerthird']   = base_convert(mb_substr($dataStr, 12,2), 16, 10);
                    $data['worktimeforth']    = base_convert(mb_substr($dataStr, 14,2), 16, 10);
                    $data['workpowerforth']   = base_convert(mb_substr($dataStr, 16,2), 16, 10);
                    $data['delaytime']        = base_convert(mb_substr($dataStr, 18,2), 16, 10);
                    $data['voptically']       = round(base_convert(mb_substr($dataStr, 20,4), 16, 10)/10,1);
                    $data['ledloadcurrent']   = round(base_convert(mb_substr($dataStr, 24,4), 16, 10),2);
                    $data['powercmd']         = base_convert(mb_substr($dataStr, 28,2), 16, 10);
                    $data['switchfeature']    = base_convert(mb_substr($dataStr, 30,2), 16, 10);
                    exit(json_result('0000', $this->response['0000'], $data));
                }else{
                    exit(json_result('0010', $this->response['0010']));
                }
            }
            
        }
        if (isset($lampData['protocoltype']) && $lampData['protocoltype'] != 0) {
            $cmdret = send_cmd($cmd,1,30,$lampData['protocoltype']);
            if ($cmdret === false) {
                sleep(1);
                $cmdret = send_cmd($cmd,1,30,$lampData['protocoltype']);
            }
        }else{
            $cmdret = send_cmd($cmd,0,30,$lampData['protocoltype']);
            if ($cmdret === false) {
                sleep(1);
                $cmdret = send_cmd($cmd,0,30,$lampData['protocoltype']);
            }
        }
        if (empty($cmdret)) exit(json_result('0016',$this->response['0016']));
        $r = json_decode($cmdret, true);
        if ($r['result'] == false) {
            $version = $this->session->userdata('version');
            if (empty($version)) {
                $msg = empty($r['msg']) ? '未知错误' : transfer_error_tips($r['msg']);
            }else{
                $msg = empty($r['msg']) ? 'Unknown error' : $r['msg'];
            }
            exit(json_result('other', $msg));
        }
        $res = $this->Load_model->get_data_by_filter(['relateid'=>$lamp_id,'cmdtype'=>0]);
        if (empty($res)) {
            $update['workmode']         = '0';
            $update['worktimefirst']    = '4';
            $update['workpowerfirst']   = '80';
            $update['worktimesencond']  = '1';
            $update['workpowersencond'] = '40';
            $update['worktimethird']    = '8';
            $update['workpowerthird']   = '30';
            $update['worktimeforth']    = '0';
            $update['workpowerforth']   = '30';
            $update['voptically']       = '5';
            $update['delaytime']        = '1';
            $update['ledloadcurrent']   = '330';
            $update['powercmd']         = '1';
            $update['switchfeature']    = '1';
            $res = $update;
        }
        unset($res['id']);
        unset($res['updatetime']);
        $data = $res;
        
        exit(json_result('0000', $this->response['0000'], $data));
    }

    private function format_date_en($date){
        $h = floor($date/3600);
        $h = $h > 10 ? $h : '0'.$h;
        $t = floor($date%3600/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['workmode']         = '0';
            $update['worktimefirst']    = '4';
            $update['workpowerfirst']   = '80';
            $update['worktimesencond']  = '1';
            $update['workpowersencond'] = '40';
            $update['worktimethird']    = '8';
            $update['workpowerthird']   = '30';
            $update['worktimeforth']    = '0';
            $update['workpowerforth']   = '30';
            $update['voptically']       = '5';
            $update['delaytime']        = '1';
            $update['ledloadcurrent']   = '330';
            $update['powercmd']         = '1';
            $update['switchfeature']    = '1';
        }else{  // 蓄电池参数
            $update['batterytype']              = '0';//蓄电池类型
            $update['capacity0']                 = '200';//蓄电池容量
            $update['capacity1']                 = '';//蓄电池容量
            $update['vovervoltage']             = '16';//超压电压 
            $update['vlimitedcharge']           = '15.5';//充电限制电压
            $update['vbalancecharge']           = '14.6';//均衡充电电压
            $update['vpromotecharge0']           = '14.4';//提升充电电压/过充电压(锂电池)
            $update['vpromotecharge1']           = '12.6';//提升充电电压/过充电压(锂电池)
            $update['vfloatingcharge']          = '13.8';//浮充充电电压
            $update['vpromoterecover0']          = '13.2';//提升充电恢复电压/过充返回电压(锂电池)
            $update['vpromoterecover1']          = '12';//提升充电恢复电压/过充返回电压(锂电池)
            $update['voverdischargerecover0']    = '12.6';//过放恢复电压
            $update['voverdischargerecover1']    = '11';//过放恢复电压
            $update['vundervoltagewarn']        = '12';//欠压警告电压
            $update['voverdischarge0']           = '11';//过放电压
            $update['voverdischarge1']           = '9';//过放电压
            $update['balancechargetime']        = '1';//均衡充电时间
            $update['promotechargetime']        = '4';//提升充电时间 
            $update['balanceinterval']          = '30';//均衡充电间隔
            $update['tempcompensation']         = '-4';//温度补偿系数
            $update['tempcompmax']              = '99';//温度补偿最高温度 
            $update['tempcompmin']              = '-40';//温度补偿最低温度 
            $update['turnfloatingcurrent']      = '20';//转浮充的电流 
            $update['vsystem']                  = '12';//系统电压
            $update['minusnocharge']            = '0';//零下禁充
            $update['chargemode']               = '0';//充电模式
        }
        exit(json_result('0000',$this->response['0000'],$update));
    }

    // 获取蓄电池设置
    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->getOne($lamp_id,'N.status,N.protocoltype,L.address,L.protocoltype as lampprotocoltype,L.number,N.deviceid');
        // if ($lampData['status'] == 0) {
        //     exit(json_result('0412',$this->response['0412'],array()));
        // }

        $cmd = '{"cmd_type":"get_battery_setting_cmd","cmd_id":'.$lamp_id.',"broadcast":0}';

        if (($lampData['protocoltype'] == 4 || $lampData['protocoltype'] == 6) && $lampData['lampprotocoltype'] == 0) {
            $address = '';
            if (mb_strlen($lampData['address']) >= 8) {
                $address = mb_substr($lampData['address'], -8);
            }else{
                $address = '00000000';
            }
            $sendData = $address.'030328204b';
            
            if ($lampData['protocoltype'] == 4) {
                $res = lampMqttCmd('/IDCOL/CmdInput/'.$lampData['address'],'/IDCOL/CmdOutput/'.$lampData['address'],pack('H*','0001'.$sendData));
            }else{
                device_cmd($lampData['deviceid'],pack('H*',$sendData));
                $cmd = '{"type":"cmd","deviceId":"'.$lampData['address'].'"}';
                $info = send_lorawan_915($cmd);
                $res = array();
                if (!empty($info)) {
                    $info = json_decode($info,true);
                    if ($info && $info['res'] == 0) $res['msg'] = $info['resInfo'];
                }
            }

            if (empty($res)) {
                exit(json_result('0016', $this->response['0016']));
            }else{
                $msg1 = $res['msg'];
                // 数据校验
                $msg = mb_substr($msg1, 10);
                $t = 0;
                for ($i=0; $i < mb_strlen($msg) / 2 - 1; $i++) {
                    $s = mb_substr($msg, $i*2,2);
                    $t += base_convert($s, 16, 10);
                }
                $t = base_convert($t, 10, 16);
                if (mb_strlen($t) > 2) {
                    $t = mb_substr($t, -2);
                }elseif($t <= 1){
                    $t = '0'.$t;
                }
                if ($t == mb_substr($msg, -2)) {  
                    $data = array();
                    $dataStr = mb_substr($msg1, 16);
                    $data['batterytype']              = base_convert(mb_substr($dataStr, 56,2), 16, 10);//蓄电池类型
                    $data['capacity']                 = base_convert(mb_substr($dataStr, 0,4), 16, 10);//蓄电池容量
                    $data['capacity1']                 = base_convert(mb_substr($dataStr, 0,4), 16, 10);//蓄电池容量
                    $data['vovervoltage']             = round(base_convert(mb_substr($dataStr, 4,4), 16, 10)/10,1);//超压电压 
                    $data['vlimitedcharge']           = round(base_convert(mb_substr($dataStr, 8,4), 16, 10)/10,1);//充电限制电压
                    $data['vbalancecharge']           = round(base_convert(mb_substr($dataStr, 12,4), 16, 10)/10,1);//均衡充电电压
                    $data['vpromotecharge0']           = round(base_convert(mb_substr($dataStr, 16,4), 16, 10)/10,1);//提升充电电压/过充电压(锂电池)
                    $data['vpromotecharge1']           = round(base_convert(mb_substr($dataStr, 16,4), 16, 10)/10,1);//提升充电电压/过充电压(锂电池)
                    $data['vfloatingcharge']          = round(base_convert(mb_substr($dataStr, 20,4), 16, 10)/10,1);//浮充充电电压
                    $data['vpromoterecover0']          = round(base_convert(mb_substr($dataStr, 24,4), 16, 10)/10,1);//提升充电恢复电压/过充返回电压(锂电池)
                    $data['vpromoterecover1']          = round(base_convert(mb_substr($dataStr, 24,4), 16, 10)/10,1);//提升充电恢复电压/过充返回电压(锂电池)
                    $data['voverdischargerecover0']    = round(base_convert(mb_substr($dataStr, 28,4), 16, 10)/10,1);//过放恢复电压
                    $data['voverdischargerecover1']    = round(base_convert(mb_substr($dataStr, 28,4), 16, 10)/10,1);//过放恢复电压
                    $data['vundervoltagewarn']        = round(base_convert(mb_substr($dataStr, 32,4), 16, 10)/10,1);//欠压警告电压
                    $data['voverdischarge0']           = round(base_convert(mb_substr($dataStr, 36,4), 16, 10)/10,1);//过放电压
                    $data['voverdischarge1']           = round(base_convert(mb_substr($dataStr, 36,4), 16, 10)/10,1);//过放电压
                    $data['balancechargetime']        = base_convert(mb_substr($dataStr, 40,2), 16, 10);//均衡充电时间
                    $data['promotechargetime']        = base_convert(mb_substr($dataStr, 42,2), 16, 10);//提升充电时间 
                    $data['balanceinterval']          = base_convert(mb_substr($dataStr, 44,2), 16, 10);//均衡充电间隔
                    $data['tempcompensation']         = base_convert(mb_substr($dataStr, 46,2), 16, 10);//温度补偿系数
                    $data['tempcompmax']              = bitDecode(mb_substr($dataStr, 48,2));//温度补偿最高温度 
                    $data['tempcompmin']              = bitDecode(mb_substr($dataStr, 50,2));//温度补偿最低温度 
                    $data['turnfloatingcurrent']      = round(base_convert(mb_substr($dataStr, 52,4), 16, 10)/100,2);//转浮充的电流 
                    $data['vsystem']                  = base_convert(mb_substr($dataStr, 58,2), 16, 10);//系统电压
                    $data['minusnocharge']            = base_convert(mb_substr($dataStr, 60,2), 16, 10);//零下禁充
                    $data['chargemode']               = base_convert(mb_substr($dataStr, 62,2), 16, 10);//充电模式
                    exit(json_result('0000', $this->response['0000'], $data));
                }else{
                    exit(json_result('0010', $this->response['0010']));
                }
            }
            
        }
        if (isset($lampData['protocoltype']) && $lampData['protocoltype'] != 0) {
            $cmdret = send_cmd($cmd,1,30,$lampData['protocoltype']);
            if ($cmdret === false) {
                sleep(1);
                $cmdret = send_cmd($cmd,1,30,$lampData['protocoltype']);
            }
        }else{
            $cmdret = send_cmd($cmd,0,30,$lampData['protocoltype']);
            if ($cmdret === false) {
                sleep(1);
                $cmdret = send_cmd($cmd,0,30,$lampData['protocoltype']);
            }
        }
        if (empty($cmdret)) exit(json_result('0016',$this->response['0016']));
        $r = json_decode($cmdret, true);
        if ($r['result'] == false) {
            $version = $this->session->userdata('version');
            if (empty($version)) {
                $msg = empty($r['msg']) ? '未知错误' : transfer_error_tips($r['msg']);
            }else{
                $msg = empty($r['msg']) ? 'Unknown error' : $r['msg'];
            }
            exit(json_result('other', $msg));
        }
        $res = $this->Battery_model->getOne($lamp_id);
        if (empty($res)) {
            $update['batterytype']              = '0';//蓄电池类型
            $update['capacity0']                 = '200';//蓄电池容量
            $update['capacity1']                 = '';//蓄电池容量
            $update['vovervoltage']             = '16';//超压电压 
            $update['vlimitedcharge']           = '15.5';//充电限制电压
            $update['vbalancecharge']           = '14.6';//均衡充电电压
            $update['vpromotecharge0']           = '14.4';//提升充电电压/过充电压(锂电池)
            $update['vpromotecharge1']           = '12.6';//提升充电电压/过充电压(锂电池)
            $update['vfloatingcharge']          = '13.8';//浮充充电电压
            $update['vpromoterecover0']          = '13.2';//提升充电恢复电压/过充返回电压(锂电池)
            $update['vpromoterecover1']          = '12';//提升充电恢复电压/过充返回电压(锂电池)
            $update['voverdischargerecover0']    = '12.6';//过放恢复电压
            $update['voverdischargerecover1']    = '11';//过放恢复电压
            $update['vundervoltagewarn']        = '12';//欠压警告电压
            $update['voverdischarge0']           = '11';//过放电压
            $update['voverdischarge1']           = '9';//过放电压
            $update['balancechargetime']        = '1';//均衡充电时间
            $update['promotechargetime']        = '4';//提升充电时间 
            $update['balanceinterval']          = '30';//均衡充电间隔
            $update['tempcompensation']         = '-4';//温度补偿系数
            $update['tempcompmax']              = '99';//温度补偿最高温度 
            $update['tempcompmin']              = '-40';//温度补偿最低温度 
            $update['turnfloatingcurrent']      = '20';//转浮充的电流 
            $update['vsystem']                  = '12';//系统电压
            $update['minusnocharge']            = '0';//零下禁充
            $update['chargemode']               = '0';//充电模式
            $res = $update;
        }

        $data = $res;
        unset($data['id']);
        unset($data['updatetime']);
        exit(json_result('0000', $this->response['0000'], $data));
    }

    // 灯控相关数据
    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 + $timezone['value']*3600);
            $endDate = date('Y-m-d H:i:s',strtotime($dateArr[1]) - 8*3600 + $timezone['value']*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 + $timezone['value']*3600);
            $endDate = date('Y-m-d H:i:s',strtotime(date('Y-m-d 23:59:59',time())) - 8*3600 + $timezone['value']*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,loadcurrent as lampcurrent,loadpower as lamppower,updatetime',$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,updatetime,DayOverDisChgTimes as overtimes';
            $res = $this->RealtimeInfoLog_model->get_list($where, $fields,$count, ($page-1)*$count, 'updatetime desc,id desc');
        }else{
            $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) {
                // $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 = $res[1];
        }
        $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'];

        $data = ['patrolinterval'=>$lampData['patrolinterval']];
        if ($type == 0) {  // 路灯
            $sql = 'select LI.loadvoltage as lampvoltage,LI.loadcurrent as lampcurrent,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'],8,$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));
    }
}