phpstock/app/admin/controller/Share.php

<?php


namespace app\admin\controller;

use app\BaseController;
use think\Request;
use think\facade\Db;
class Share extends BaseController
{
    /**
     * 显示资源列表
     *
     * @return \think\Response
     */
    public function index()
    {
        $post  =$this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(101,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }
        $page = isset($post['page']) ? intval($post['page']): 1;
        $size = isset($post['size']) ? intval($post['size']):10;
        $condition=[];
        $condition[]=["is_del","=",0];
        $count =Db::name("role_share")->where($condition)->count();
        $total = ceil($count/$size)>1 ? ceil($count/$size) : 1;
        $page = $page>=$total?intval($total):$page;
        $list = Db::name("role_share")->where($condition)->page($page,$size)->select();
        $result = [];
        foreach ($list as $key=>$val){
            $temp = [];
            $temp['id']=$val['id'];

            $menu = Db::name("admin_menu")->where("id in ({$val['action_collect']})")->column("menu_name");
            $temp['actionlist']=implode(",",$menu);
            $userid = [];
            $val['share_user']!=""&&$val['share_user']!=0  ?$userid[]=$val['share_user']:"";
            $val['to_user']!=""&&$val['to_user']!=0  ?$userid[]=$val['to_user']:"";
            $cond = ['id' => $userid];
            $user = GetUserlist($token, $cond);
            $share_name = "";
            $to_name = "";

            if ($user['code'] == 0 && !empty($user['data'])) {
                foreach ($user['data'] as $v) {

                    if($val['share_user']==$v['id']){
                        $share_name= isset($v['nickname']) ?$v['nickname']:"";
                    }
                    if($val['to_user']==$v['id']){
                        $to_name= isset($v['nickname']) ?$v['nickname']:"";
                    }
                }
            }

            $temp['share_user']=$share_name;
            $togroup = $val['to_group']!=""&&$val['to_group']!=0?Db::name("role_group")->where("id","=",
                $val["to_group"])->find()
                :['group_name'=>""];

            $temp['to_user']=$to_name;
            $temp['to_group']=$togroup['group_name'];
            $temp['status']=$val['status'];
            $temp['action']=$val['action'];
            $temp['addtime']=$val['addtime'];
            array_push($result,$temp);
        }
        return  app_show(0,"获取成功",['list'=>$result,"count"=>$count]);
    }

    /**
     * 显示创建资源表单页.
     *
     * @return \think\Response
     */
    public function create()
    {
        $post  =$this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(101,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }
        $collect = isset($post['collect']) ? trim($post['collect']):"";
        $user = isset($post['userid']) ? intval($post['userid']):"";
        $touser = isset($post['touserid']) ? intval($post['touserid']):"";
        $togroup = isset($post['togroupid']) ? intval($post['togroupid']):"";
        $action = isset($post['action']) ? intval($post['action']):"";
        if($collect==""){
            return error_show(1002,"菜单数据不能为空");
        }
        if($user==""){
            return error_show(1003,"数据源用户不能为空");
        }
        if($touser=="" && $togroup==""){
            return error_show(1004,"共享用户或用户组不能为空");
        }
        if($action===""){
            return error_show(1005,"共享数据权限不能为空");
        }
        $data=[
            "action_collect"=>$collect,
            "share_user"=>$user,
            "to_user"=>$touser,
            "to_group"=>$togroup,
            "action"=>$action,
            "status"=>1,
            "addtime"=>date("Y-m-d H:i:s"),
            "updatetime"=>date("Y-m-d H:i:s")
        ];
        $result= Db::name("role_share")->save($data);
        return $result ? app_show(0,"新建成功"):error_show(1006,"新建失败");
    }

    /**
     * 保存新建的资源
     *
     * @param  \think\Request  $request
     * @return \think\Response
     */
    public function save()
    {
        $post  =$this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(1001,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }
        $id = isset($post['id'])&&$post['id']!="" ? intval($post['id']):"";
        $collect = isset($post['collect'])&&$post['collect']!="" ? trim($post['collect']):"";
        $user = isset($post['userid'])&&$post['userid']!="" ? intval($post['userid']):"";
        $touser = isset($post['touserid'])&&$post['touserid']!="" ? intval($post['touserid']):"";
        $togroup = isset($post['togroupid'])&&$post['togroupid']!="" ? intval($post['togroupid']):"";
        $action = isset($post['action'])&&$post['action']!="" ? trim($post['action']):"";
        $info = Db::name("role_share")->where("id","=",$id)->find();
        if(!$info){
            return error_show(1002,"未找到对应数据");
        }
        if($collect==""){
            return error_show(1002,"菜单数据不能为空");
        }
        if($user==""){
            return error_show(1003,"数据源用户不能为空");
        }
        if($touser=="" && $togroup==""){
            return error_show(1004,"共享用户或用户组不能为空");
        }
//        if($action===""){
//            return error_show(1005,"共享数据权限不能为空");
//        }
        $data=[
            "action_collect"=>$collect,
            "share_user"=>$user,
            "to_user"=>$touser,
            "to_group"=>$togroup,
            "action"=>$action,
            "updatetime"=>date("Y-m-d H:i:s")
        ];
        $result= Db::name("role_share")->where("id","=",$id)->update($data);
        return $result ? app_show(0,"更新成功"):error_show(1006,"更新失败");
    }

    /**
     * 显示指定的资源
     *
     * @param  int  $id
     * @return \think\Response
     */
    public function read()
    {
        $post  =$this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(1001,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }
        $id = isset($post['id'])&&$post['id']!=""  ? intval($post['id']):"";
        $info =  Db::name("role_share")->where([["id","=",$id],["is_del","=",0]])->find();
        if(!$info){
            return error_show(1002,"未找到对应数据");
        }

        $menu =Db::name("admin_menu")->where("id in ({$info['action_collect']})")->column("menu_name");

        $info['actionlist']=implode(",",$menu);

        $userid = [];
        $info['share_user']!=""&&$info['share_user']!=0  ?$userid[]=$info['share_user']:"";
        $info['to_user']!=""&&$info['to_user']!=0  ?$userid[]=$info['to_user']:"";
        $cond = ['id' => $userid];
        $user = GetUserlist($token, $cond);
        $share_name = "";
        $to_name = "";
        if ($user['code'] == 0 && !empty($user['data'])) {
            foreach ($user['data'] as $v) {
                if($info['share_user']==$v['id']){
                    $share_name= isset($v['nickname']) ?$v['nickname']:"";
                }
                if($info['to_user']==$v['id']){
                    $to_name= isset($v['nickname']) ?$v['nickname']:"";
                }
            }
        }
        $info['to_group']==0 ? $info['to_group']='':"";
        $togroup= $info['to_group']!="" ?Db::name("role_group")->where("id","=",$info["to_group"])->find()
            :['group_name'=>""];
        $info['share_user_name']=$share_name;
        $info['to_user_name'] = $to_name;
        $info['to_group_name'] = $togroup['group_name'];
        return   app_show(0,"获取成功",$info);
    }

    /**
     * 显示编辑资源表单页.
     *
     * @param  int  $id
     * @return \think\Response
     */
    public function status()
    {
        $post  =$this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(1001,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }
        $id = isset($post['id']) ? intval($post['id']):"";
        if($id==""){
            return error_show(1002,"参数id 不能为空");
        }
        $info =  Db::name("role_share")->where([["id","=",$id],["is_del","=",0]])->find();
        if(!$info){
            return error_show(1002,"未找到对应数据");
        }
        $status =  isset($post['status']) && $post['status']!=""? intval($post['status']):"";
        if($status===""){
            return error_show(1002,"参数status 不能为空");
        }
        if(!in_array($status,[0,1])){
            return error_show(1002,"参数status 无效");
        }
        $info['status']=$status;
        $info['updatetime']=date("Y-m-d H:i:s");
        $msg = $status==1?"启用":"禁用";
        $update = Db::name("role_share")->save($info);
        return  $update? app_show(0,"{$msg}成功"):error_show(1004,"{$msg}失败");
    }

    /**
     * 保存更新的资源
     *
     * @param  \think\Request  $request
     * @param  int  $id
     * @return \think\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * 删除指定资源
     *
     * @param  int  $id
     * @return \think\Response
     */
    public function delete()
    {
        $post  =$this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if($token==""){
            return error_show(1001,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0){
            return error_show($effetc['code'],$effetc['message']);
        }
        $id = isset($post['id']) ? intval($post['id']):"";
        if($id==""){
            return error_show(1002,"参数id 不能为空");
        }
        $info =  Db::name("role_share")->where([["id","=",$id],["is_del","=",0]])->find();
        if(!$info){
            return error_show(1002,"未找到对应数据");
        }
        $info["status"]=0;
        $info["is_del"]=1;
        $info["updatetime"]=date("Y-m-d H:i:s");
        $update = Db::name("role_share")->save($info);
        return  $update? app_show(0,"删除成功"):error_show(1004,"删除失败");
    }
}