bts/php/app/admin/controller/Usermanage.php

<?php
/**
 *
 * User: anyluck
 * Date: 2020/6/2
 * Time: 17:31
 */

namespace app\admin\controller;


use app\common\controller\Backend;
use app\common\model\UserLevel;
use think\facade\Db;
use think\facade\Request;
use think\facade\View;
use  app\common\model\User;
class Usermanage extends Backend
{
 // 用户管理

    // 用户列表
    public function index()
    {
        if (Request::isPost()) {
            $keys = Request::post('keys', '', 'trim');
            $page = Request::post('page') ? Request::post('page') : 1;
            $limit=input("limit")?:10;
            $list = Db::name('user')
                ->where('mail|phone|name','like',"%".$keys."%")
                ->order('id desc')
                ->paginate(['list_rows' =>$limit, 'page' => $page])
                ->toArray();
            foreach ($list['data'] as $k=>$v){
                if ($v['update_time']){
                    $list['data'][$k]['update_time'] = date('Y-m-d H:i',$v['update_time']);
                }
            }
            return $result = ['code' => 0, 'msg' => lang('get info success'), 'data' => $list['data'], 'count' => $list['total']];
        }

        $vip=UserLevel::select();
        View::assign("vip",$vip);
        return View::fetch();
    }

    // 设置等级
    public function update_leve()
    {
        $id=input("id");
        $level=input("level");
       User::update(["vip_level"=>$level],["id"=>$id]);
        json_result(200,"设置成功");

    }

    // 用户详细信息
    public function show()
    {

    }

    // 密码重置
    public function update_pwd()
    {

    }

    // 封号
    public function fenhao()
    {
        $id=input("id");

        $user=\app\common\model\User::where(["id"=>$id])->field("status")->find();
        if ($user->status==1){
            $update["status"]=0;
        }else{
            $update["status"]=1;
        }
        \app\common\model\User::update($update,["id"=>$id]);
        json_result(200,"操作成功");
    }
//用户充值
    public function chongzhi()
    {
        
    }

    // 用户通证记录
    public function tongxingzheng()
    {
        if (Request::isPost()) {
            $name = input("name");
            $page = input("page") ?: 1;
            $limit = input("limit") ?: 10;
            $where = [];
            $where["daili"]=0;
            $list = \app\common\model\Finance::where($where)->order("id desc")->paginate(["list_row" => $limit, "page" => $page])->each(function ($item) {
                $user =User::where(["id" => $item["user_id"]])->field("name")->find();
                $item["user_name"] = $user->name;
                $item["add_time"]=date("Y-m-d H:i:s",$item["add_time"]);

                return $item;
            })->toArray();
            return $result = ['code' => 0, 'msg' => lang('get info success'), 'data' => $list['data'] ?: [], 'count' => $list['total'] ?: 0];

        }

        return View::fetch();


    }

    //设置会员等级
    public function update_level()
    {
        if (Request::isPost()) {
            $name = input("name");
            $page = input("page") ?: 1;
            $limit = input("limit") ?: 10;
            $where = [];
            $list = UserLevel::where($where)->order("id desc")->paginate(["list_row" => $limit, "page" => $page])->each(function ($item) {
                return $item;
            })->toArray();
            return $result = ['code' => 0, 'msg' => lang('get info success'), 'data' => $list['data'] ?: [], 'count' => $list['total'] ?: 0];

        }

        return View::fetch();
        
    }

    // 删除等级
    public function del_user_level()
    {
        $id=input("id");
        $user_level=UserLevel::where(["id"=>$id])->find();
        // 查看是否有会员有该等级
        $user=User::where(["vip_level"=>$user_level->level])->count();
        if ($user){
            json_result(400,"当前等级下有会员不能删除");
        }
        UserLevel::where(["id"=>$id])->delete();
        json_result(200,"删除成功");

    }

    // 添加等级
    public function add_user_level()
    {
        $data=Request::post();
        $user_level=UserLevel::where(["level"=>$data["level"]])->find();
        if ($user_level){
            json_result(400,"当前等级已经存在，请重新添加一个吧");
        }

        UserLevel::create($data);
        json_result(200,"添加成功",$data);
    }

    // 更新
    public function update_user_level()
    {
        $id=input("id");
        $filed=input("field");
        $value=input("value");
        if ($filed=="level"){
            $userlevel=UserLevel::where(["level"=>$filed])->find();
            if ($userlevel){
                json_result(400,"当前等级已经存在");
            }
        }
        UserLevel::where(["id"=>$id])->update([$filed=>$value]);
        json_result(200,"设置成功");

    }
}