USKYZHAF/Home/Controller/PermissionBindingController.class.php

<?php

namespace Home\Controller;

use Think\Controller;

class PermissionBindingController extends ComController
{
    //权限绑定列表
    public function  getPermissionBindingList(){
        $Data = I();
        $page=$Data['page'];
        $number=$Data['number'];
        $statur=($page-1)*$number;
        $openid_data = M()->query("select a.id,a.id,a.username,a.phone,b.owner_name,a.statusid from sp_owner_phone as a join sp_owner_company as b on a.owner_code=b.owner_id ORDER BY a.time desc LIMIT ".$statur.",".$number);

        $total_data = M()->query("select count(*) as total from sp_owner_phone as a join sp_owner_company as b on a.owner_code=b.owner_id");
        $res['msg'] = '操作成功';
        $res['flag'] = true;
        $res['total'] = $total_data[0]['total'];
        $res['data'] = $openid_data;
        echo json_encode($res);
    }

    public function getphoneList(){
        $phone_data = M()->query("select phone from sp_wx_customuser");
        $res['msg'] = '操作成功';
        $res['flag'] = true;
        $res['data'] = $phone_data;
        echo json_encode($res);

    }

    public function setPermissionBinding()
    {
        $Data = I();
        $phone = $Data['phone'];
        $name = $Data['name'];
        $power = $Data['power'];
        $company_code = $Data['company_code'];
        if (empty($phone) && empty($name) && empty($power) && empty($company_code)) {
            $res['msg'] = '操作失败，缺少重要参数';
            $res['flag'] = false;
            echo json_encode($res);
            exit();
        }

        $openid_data = M()->query("select * from sp_wx_customuser where phone='" . $phone . "'");

        $data['owner_code'] = $company_code;
        $data['username'] = $name;
        $data['status'] = 0;
        $data['types'] = 3;
        $data['phone'] = $phone;
        $data['time'] = date('Y-m-d H:i:s', time());
        $data['data1'] = $openid_data[0]['openid'];
        $data['data2'] = "1,2,3,4,5,6,7,8,9,a";
        $data['sfsg'] = 0;
        $data['statusid'] = $power;
        $R = M("owner_phone")->add($data);
        if ($R){
            $res['msg'] = '操作成功';
            $res['flag'] = true;
            echo json_encode($res);
        }else{
            $res['msg'] = '操作失败';
            $res['flag'] = false;
            echo json_encode($res);
        }
    }
}