application/controllers/admincpAdminuser.php

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/**
 * 管理员管理
 * @author lxn
*/
class Adminuser extends CI_Controller
{
    private static $data = array();
    public function __construct()
    {
        parent::__construct();
        $this->load->model('Role_model', 'role');
        $this->load->model('Admin_model', 'admin');
        $this->load->model('Public_model', 'public');
        $this->load->model('Webcommon_model','common');//积分流水表
        self::$data['header'] = $this->public->header('管理员');
        self::$data['left'] = $this->public->leftmenu('adminuser');
        self::$data['footer'] = $this->public->footer();
        $this->load->library('Session');
        $this->public->authentication();
    }

    /**
     * 顾问列表
     */
    public function index()
    {            
        if($_GET){
            //获取Datatables发送的参数 必要
            $draw = $_GET['draw'];//这个值作者会直接返回给前台
            //排序
            $order_column = $_GET['order']['0']['column'];//那一列排序，从0开始
            $order_dir = $_GET['order']['0']['dir'];//ase desc 升序或者降序
            //拼接排序sql
            $orderSql = "";
            if(isset($order_column)){
                $i = intval($order_column);
                switch($i){
                    case 0;$orderSql = " order by adminId ".$order_dir;break; //ID
                    case 3;$orderSql = " order by roleId ".$order_dir;break; //分类
                    default;$orderSql = '';
                }
            }
            //搜索
            $search = $_GET['search']['value'];//获取前台传过来的过滤条件
             
            //分页
            $start = $_GET['start'];//从多少开始
            $length = $_GET['length'];//数据长度
            $limitSql = '';
            $limitFlag = isset($_GET['start']) && $length != -1 ;
            if ($limitFlag ) {
                $limitSql = " LIMIT ".intval($start).", ".intval($length);
            }
            //定义查询数据总记录数sql
            $sumSql = "SELECT count(*) as sum FROM admin as a  WHERE a.deleteFlag=0";
            //定义过滤条件查询过滤后的记录数sql
            $sumSqlWhere =" and (a.adminName LIKE '%".$search."%'  or a.realName LIKE '%".$search."%')";
            //条件过滤后记录数 必要
            $recordsFiltered = 0;
            //表的总记录数 必要
            $recordsTotal = 0;
            //查询总数
            $total =  $this->common->getsqldata($sumSql);
            //           var_dump($total);exit;
            $recordsTotal = $total[0]['sum'];
        
            $totalResultSql = "SELECT a.*  FROM admin as a  WHERE a.deleteFlag=0";
        
            if(strlen($search)>0){
                //记录总数
                $total = $this->common->getsqldata($sumSql.$sumSqlWhere);
                $recordsFiltered = $total[0]['sum'];
                $list =$this->common->getsqldata($totalResultSql.$sumSqlWhere.$orderSql.$limitSql);
            }else{
                //记录总数
                $recordsFiltered = $recordsTotal;
                $list = $this->common->getsqldata($totalResultSql.$orderSql.$limitSql);
            }
             
            header("Content-Type:text/html;charset=utf-8");
//             $list = $this->catsort($list,0,1);
            foreach($list as $key=>$value)
            {
                $roleInfo = $this->role->getRoleRow( $value['roleId']);
                $list[$key]['roleName'] = $roleInfo['roleName'];
            }
            exit(json_encode(array(
                "draw" => intval($draw),
                "recordsTotal" => intval($recordsTotal),
                "recordsFiltered" => intval($recordsFiltered),
                "data" => $list
            )));
        }else {
             $this->load->view('admincp/adminuser/adminuserlist', self::$data);
        }
              
    }
    
    /**
     * 添加/修改页
     */
    public function edit($adminId = 0)
    {
        $adminId = $this->input->get_post('adminId');
        // 获取栏目信息
        $roleInfo = $this->role->getRoleList('','roleId,roleName',100);    
        $adminUserInfo = $this->admin->getAdminRow($adminId);   
        self::$data['adminId'] = $adminId;
        self::$data['adminUserInfo'] = $adminUserInfo;
        self::$data['roleList'] = $roleInfo;
        $this->load->view('admincp/adminuser/adminuserinfo', self::$data);
    }
    /**
     * 添加/修改页
     */
    public function editpass()
    {
        self::$data['adminName'] = $_SESSION['adminName'];
        $this->load->view('admincp/adminuser/editpass', self::$data);
    }
    /**
     * 添加/修改数据库
     */
    public function updatepass()
    {

        $referer = !empty($url) ? $this->config->item('base_url') . base64_decode($url) : $this->config->item('base_url') . '/admincp/adminuser/editpass';
        $oldpassword = $this->input->post('password');
        $newpassword = $this->input->post('newpassword');
        $newpassword2 = $this->input->post('newpassword2');

        if ($newpassword!=$newpassword2){
            $msg =  '修改失败!,两次密码不同';
            $isok = 1;
            echo $this ->public->message( $msg, $referer, $isok, array(), array('keyword'=>'adminuser'));exit;
        }
//        var_dump($_SESSION);exit;
        $adminId = $_SESSION['adminId'];
        $adminUserInfo = $this->admin->getAdminRow($adminId);
        if (md5($oldpassword)!=$adminUserInfo['password']){
            $msg =  '修改失败!,原密码错误';
            $isok = 1;
            echo $this ->public->message( $msg, $referer, $isok, array(), array('keyword'=>'adminuser'));exit;
        }

            $userData = array(
                'password' => md5($newpassword),
            );
//            var_dump($userData);exit;
            $bool = $this->admin->setAdminByID($userData, $adminId);

            $msg = $bool ? '修改成功!' : '修改失败!';

            $isok = $bool ? 0 : 1;

        echo $this ->public->message( $msg, $referer, $isok, array(), array('keyword'=>'adminuser'));exit;
    }
    /**
     * 添加/修改数据库
     */
    public function updateData()
    {
        $url = trim($this->input->get_post('backurl'));
        $referer = !empty($url) ? $this->config->item('base_url') . base64_decode($url) : $this->config->item('base_url') . '/admincp/adminuser';
        $adminId = $this->input->post('adminId');
        $adminName = $this->input->post('adminName');
        $realName = $this->input->post('realName');
        $password = $this->input->post('password');
        $roleId = $this->input->post('roleId');
        
    
        if (empty($adminId))
        {
            $password = md5($password);
            $userData = array(
                    'adminName' => $adminName,
                    'realName' => $realName,
                    'password' => $password,
                    'roleId' => $roleId
            );
            $bool = $this->admin->insertData( $userData );
            $msg = $bool ? '添加成功!' : '添加失败!';          	
            $isok = $bool ? 0 : 1;
        }
        else
        {   
            $userData = array(
                    'adminName' => $adminName,
                    'realName' => $realName,                 
                    'roleId' => $roleId
            );
            if(!empty($password))
            {
                $password = md5($password);
                $userData = array_merge($userData,array('password'=>$password));
            }
            $bool = $this->admin->setAdminByID($userData, $adminId);
            $msg = $bool ? '修改成功!' : '修改失败!';
            	
            $isok = $bool ? 0 : 1;
        }	
		echo $this ->public -> message( $msg, $referer, $isok, array(), array('keyword'=>'adminuser'));exit;
    }
    
    /**
     * 检查栏目名称和关键字唯一
     * */
    public function ajaxcheck()
    {
        $res = array('status' => 0);
        $adminId = $this->input->post('adminId');
        $adminName = $this->input->post('adminName');
      
        $data = $this->admin->checkUnique(trim($adminName),$adminId);
        if(!empty($data))
        {
            $res['status'] = 1;
        }
        echo json_encode($res);
    }
    
    /**
     * 删除角色
     */
    public function delete()
    {
        $res = array(
                'err' => 1,
                'msg' => '系统错误'
        );
        $adminId = trim($this->input->get_post('adminId'));
        $adminInfo = $this->admin->getAdminRow($adminId);
        if (empty($adminInfo))
        {
            $res['msg'] = '参数错误';
            echo json_encode($res);
            exit();
        }
        $bool = $this->admin->delete( $adminId );
        $res['err'] = $bool ? 0 : 1;
        $res['msg'] = $bool ? '删除成功' : '删除失败';
        echo json_encode($res);
        exit();
    }
    public function qrcode()
    {
        $this->load->view('admincp/adminuser/qrcode', self::$data);
    }

    public   function generateQRfromGoogle($widhtHeight ='150')
    {
        $chl = "http://m-dev.zhiyuntcm.com/#/register";
        $chl = urlencode($chl);
        echo '<img src="https://api.qrserver.com/v1/create-qr-code/?size='.$widhtHeight.'x'.$widhtHeight.'   
    &data='.$chl.'" alt="QR code" />';
    }
}