IDCOL/api/application/controllers/Common.php

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

class Common extends CI_Controller {
    
    var $response;
    var $userinfo;
    var $version;

    public function __construct() {
        parent::__construct();
        $this->load->model('User_model');
        $this->response = $this->config->config['response_en'];

        $version = 1;
        $this->session->set_userdata('version', $version);
        $this->version = $version;
    }

    public function login() {
        $username = $this->input->post('username',true);
        $password = $this->input->post('password',true);
        $client_key = $this->input->post('client_key',true);
        $role = $this->input->post('role',true);
        $code = $this->input->post('code',true);
        $os = intval($this->input->post('os',true));

        if(empty($client_key)) exit(json_result('0003', $this->response['0003']));
        if(empty($username) || empty($password)) exit(json_result('0100', $this->response['0100']));
        $password = md5($password);

        if(empty($os) && empty($code)) exit(json_result('0105', $this->response['0105']));
        if (empty($os) && !isset($_SESSION['login_code'])) exit(json_result('0106',$this->response['0106']));
        if (empty($os) && $_SESSION['login_code'] != $code) exit(json_result('0107',$this->response['0107']));

        $user = $this->User_model->get_one(array('username'=>$username,'role'=>$role));
        if(!empty($user)) {
            if ($user['password'] != $password) {
                exit(json_result('0101', $this->response['0101']));
            }
            $data = array(
                'token' => generate_token($username, $password, $client_key),
                'username' => $user['username'],
                'id' => $user['id'],
                'role' => intval($user['role']),
                'name' => $user['name'],
                'privilege' => $user['privilege'],
                'avatar' => empty($user['avatar']) ? '' : base_url($user['avatar'])
            );
            
            $this->userinfo = $user;
            exit(json_result('0000', $this->response['0000'], $data));
        } else {
            exit(json_result('0102', $this->response['0102']));
        }
    }

    // 图片上传
    public function update_file(){

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

        $path = '../upload/image';
        $config['file_name'] = md5(uniqid());   // 设置图片名字
       
        if (!file_exists($path)) {
            mkdir($path);
        }
        $config['upload_path']      = $path.'/';   // 设置图片上传路径
        $config['allowed_types']    = '*';  // 设置图片上传格式
        $config['max_size']     = 10240;   // 设置文件上传大小
        
        $this->load->library('upload', $config);

        if ( ! $this->upload->do_upload('file'))
        {
            $error = array('error' => $this->upload->display_errors('',''));

            // if (empty($this->version)) {
                // $data = array('error'=>transfer_error_tips($error['error']));
            // }else{
                $data = array('error'=>$error['error']);
            // }
            exit(json_result('0012',$this->response['0012'],$data));
        }
        else
        {
            $data = $this->upload->data();

            $imagePath = '/upload/image/'.$data['file_name'];
            
            exit(json_result('0000',$this->response['0000'],array('path'=>base_url($imagePath))));
        }
    }

    public function get_country() {
        $this->load->model('Global_location_model');
        $version = $this->session->userdata('version');
        if (empty($version)) {
            $data = $this->Global_location_model->get_list(['level'=>1,'id'=>92], 'id, english_name as name',null,null,'convert(english_name using gbk) ASC,id DESC');
        }else{
            $data = $this->Global_location_model->get_list(['level'=>1,'id'=>92], 'id, english_name as name',null,null,'convert(english_name using gbk) ASC,id DESC');
        }
        
        exit(json_result('0000', $this->response['0000'], ['list'=>$data]));
    }

    public function get_province() {
        $country_id = intval($this->input->post('countryId',true));
        $country_id = 92;

        $this->load->model('Global_location_model');
        $version = $this->session->userdata('version');
        if (empty($country_id)) {
            exit(json_result('0000', $this->response['0000'], ['list'=>[]]));
        }else{
            $where = ['level'=>2, 'pid'=>$country_id];
        }
        if (empty($version)) {
            $data = $this->Global_location_model->get_list($where, 'id, english_name as name',null,null,'convert(english_name using gbk) ASC,id DESC');
        }else{
            $data = $this->Global_location_model->get_list($where, 'id, english_name as name',null,null,'convert(english_name using gbk) ASC,id DESC');
        }
        exit(json_result('0000', $this->response['0000'], ['list'=>$data]));
    }
    public function get_city() {
        $province_id = intval($this->input->post('provinceId',true));

        $this->load->model('Global_location_model');
        $version = $this->session->userdata('version');
        if (empty($province_id)) {
            exit(json_result('0000', $this->response['0000'], ['list'=>[]]));
        }else{
            $where = ['level'=>3, 'pid'=>$province_id];
        }
        if (empty($version)) {
            $data = $this->Global_location_model->get_list($where, 'id, english_name as name',null,null,'convert(english_name using gbk) ASC,id DESC');
        }else{
            $data = $this->Global_location_model->get_list($where, 'id, english_name as name',null,null,'convert(english_name using gbk) ASC,id DESC');
        }
        exit(json_result('0000', $this->response['0000'], ['list'=>$data]));
    }
    public function get_area() {
        $cityId = intval($this->input->post('cityId',true));

        $this->load->model('Global_location_model');
        $version = $this->session->userdata('version');
        if (empty($cityId)) {
            exit(json_result('0000', $this->response['0000'], ['list'=>[]]));
        }else{
            $where = ['level'=>4, 'pid'=>$cityId];
        }
        if (empty($version)) {
            $data = $this->Global_location_model->get_list($where, 'id, english_name as name',null,null,'convert(english_name using gbk) ASC,id DESC');
        }else{
            $data = $this->Global_location_model->get_list($where, 'id, english_name as name',null,null,'convert(english_name using gbk) ASC,id DESC');
        }
        exit(json_result('0000', $this->response['0000'], ['list'=>$data]));
    }

    public function get_code_image(){
        $type = intval($this->input->post('type',true));

        $this->load->helper('captcha');

        if (!file_exists('../upload')) mkdir('../upload');
        if (!file_exists('../upload/image')) mkdir('../upload/image');
        if (!file_exists('../upload/image/code')) mkdir('../upload/image/code');
        $url = '/upload/image/code';
        $code = rand(1000,9999);
        $vals = array(
            'word'      => $code,
            'img_path'  => '../upload/image/code/',
            'img_url'   => $url,
            'img_width' => 120,
            'font_path' => '../file/font/PingFangRegular.ttf',
            'img_height'    => 36,
            'expiration'    => 600,
            'word_length'   => 4,
            'font_size' => 20,
            'img_id'    => 'Imageid',
        );
        
        $cap = create_captcha($vals);
        $filename = $cap['filename'];
        $url .= '/'.$filename;
        $this->load->library('session');
        if ($type == 0) {
            $this->session->set_userdata('login_code', $code);
        }else {
            $this->session->set_userdata('password_code', $code);
        }

        exit(json_result('0000',$this->response['0000'],array('path'=>base_url($url))));
    }
    public function workmode() {
        $version = $this->session->userdata('version');
        if (empty($version)) {
            $data = (object)array(
                0 => '纯光控、光控开负载、光控关负载',
                1 => '光控开负载，延时1小时后关闭负载',
                2 => '光控开负载，延时2小时后关闭负载',
                3 => '光控开负载，延时3小时后关闭负载',
                4 => '光控开负载，延时4小时后关闭负载',
                5 => '光控开负载，延时5小时后关闭负载',
                6 => '光控开负载，延时6小时后关闭负载',
                7 => '光控开负载，延时7小时后关闭负载',
                8 => '光控开负载，延时8小时后关闭负载',
                9 => '光控开负载，延时9小时后关闭负载',
                10 => '光控开负载，延时10小时后关闭负载',
                11 => '光控开负载，延时11小时后关闭负载',
                12 => '光控开负载，延时12小时后关闭负载',
                13 => '光控开负载，延时13小时后关闭负载',
                14 => '光控开负载，延时14小时后关闭负载',
                15 => '手动模式',
                16 => '调试模式',
                17 => '常开模式'
            );
        }else{
            $data = (object)array(
                0 => 'Pure light control, light control open load, light control load',
                1 => 'Light control open load, delay 1 hours to close the load',
                2 => 'Light control open load, delay 2 hours to close the load',
                3 => 'Light control open load, delay 3 hours to close the load',
                4 => 'Light control open load, delay 4 hours to close the load',
                5 => 'Light control open load, delay 5 hours to close the load',
                6 => 'Light control open load, delay 6 hours to close the load',
                7 => 'Light control open load, delay 7 hours to close the load',
                8 => 'Light control open load, delay 8 hours to close the load',
                9 => 'Light control open load, delay 9 hours to close the load',
                10 => 'Light control open load, delay 10 hours to close the load',
                11 => 'Light control open load, delay 11 hours to close the load',
                12 => 'Light control open load, delay 12 hours to close the load',
                13 => 'Light control open load, delay 13 hours to close the load',
                14 => 'Light control open load, delay 14 hours to close the load',
                15 => 'Manual mode',
                16 => 'Debug mode',
                17 => 'Open mode'
            );
        }
        
        exit(json_result('0000', $this->response['0000'], $data));
    }


    // 批量导入
    function test(){
        $indexArr = ['D'=>'area','F'=>'shen','G'=>'city'];
        // $config['file'] = md5(uniqid());   // 设置文件名字
        // $path = '../upload/file';
        
        // if (!file_exists($path)) {
        //     mkdir($path);
        // }
        // $config['upload_path']      = $path.'/';   // 设置文件上传路径
        // $config['file_name']      = date('YmdHis',time());   // 设置文件上传路径
        // $config['allowed_types']    = 'xls|xlsx';  // 设置文件上传格式
        // $config['max_size']     = 1024*2;   // 设置文件上传大小
        
        // $this->load->library('upload', $config);
        // if ( ! $this->upload->do_upload('file')){
        //     // 文件上传失败
        //     $error = array('error' => $this->upload->display_errors('',''));
        //     if (empty($this->version)) {
        //         exit(json_result('0012',$this->response['0012'],array('error'=>transfer_error_tips($error['error']))));
        //     }elseif ($this->version == 2) {
        //         exit(json_result('0012',$this->response['0012'],array('error'=>transfer_error_tips_ru($error['error']))));
        //     }else{
        //         exit(json_result('0012',$this->response['0012'],array('error'=>$error['error'])));
        //     }
            
        // }
        // else{
            // 文件上传成功
            // $data = $this->upload->data();

            // $filePath = $data['full_path'];
            $filePath = '../upload/test.xls';
            $this->load->library('phpExcel/PHPExcel');

            $reader = PHPExcel_IOFactory::createReader('Excel5'); //设置以Excel5格式(Excel97-2003工作簿)

            $PHPExcel = $reader->load($filePath); // 载入excel文件  
            $sheet = $PHPExcel->getSheet(0); // 读取第一個工作表  
            $highestRow = $sheet->getHighestRow(); // 取得总行数  
            // $highestColumm = $sheet->getHighestColumn(); // 取得总列数  
              
            /** 循环读取每个单元格的数据 */  
            $k = 0;
            $data = array();
            for ($row = 1; $row <= $highestRow; $row++)    //行号从1开始  
            {  
                if ($row < 2) continue; // 跳过标题行
                foreach ($indexArr as $key => $value) {
                    $res = $sheet->getCell($key.$row)->getValue();

                    if (is_object($res)) {
                        $res= $res->__toString();
                    }
                    $data[$k][$value] = $res;  
                }

                $k ++;
            }
            // var_dump($data);
            $temp = array();
            foreach ($data as $key => $value) {
                if (!isset($temp[$value['area']])) $temp[$value['area']] = $value;
            }
            // $temp = array_unique(array_column($data, 'shen'));
            foreach ($temp as $key => $value) {
                $res = $this->db->query('select id from global_location where english_name = "'.$value['city'].'" and level = 3')->row_array();
                if (!empty($res) && !empty($res['id'])){
                    $res2 = $this->db->query('select id from global_location where english_name = "'.$value['area'].'" and level = 4')->row_array();
                    if (!empty($res2) && !empty($res2['id'])) continue;
                    $data = array('level'=>4,'english_name'=>$value['area'],'pid'=>$res['id'],'timezone'=>6);
                    $this->db->insert('global_location', $data);
                }
                
            }
            var_dump($temp);
            // 批量写入数据
            // return $data;
        // }
    }
}