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\controller\Message;
use app\common\controller\Orde;
use app\common\model\UserLevel;
use think\facade\Db;
use think\facade\Request;
use think\facade\Session;
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;

            $where=[];
            $where[]=["admin","<>",1];
//            var_dump($where);die();
            $list = Db::name('user')
                ->where($where)
                ->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']);
                }
                if ($v["add_time"]){
                    $list['data'][$k]['add_time'] = date('Y-m-d H:i',$v['add_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 delete_user()
    {
        $id=input("id");
        $where["id"]=$id;
        User::where($where)->delete();
        json_result(200,"删除成功");
    }
    // 设置等级
    public function update_leve()
    {
        $id=input("id");
        $level=input("level");
       User::update(["vip_level"=>$level],["id"=>$id]);
        json_result(200,"设置成功");

    }


    // 对账号的金额进行操作
    public function update_user_money()
    {
        $id=input("id");
        $field=input("field");
        $value=input("value");
        $where["id"]=$id;
        $user=User::where($where)->find();
        $update[$field]=$value;
        User::update($update,$where);
        $status=0;
        $name="系统充值成功";

        if ($value<$user[$field]){// 查看账号增加还是减少
            $name="系统扣除";
            $status=1;
            $moneys= $user[$field]-$value;
            $content="系统已为您充值$moneys 通证";
        }else{
            $moneys=$value- $user[$field];
            $content="系统已为您充值$moneys 保证金";
        }
        Message::add_message($id,1,$name,$content);

        // 添加记录
      switch ($field){
          case "money"://通证余额
                Orde::Finance($id,$name."通证",$moneys,$status,2);
              break;
          case "ensure_money":// 保证金
              Orde::bond_finance($id,$name."保证金",$moneys,$status);
              break;
          case "push_money":// 可售额度
//              Orde::bond_finance($id,$name."可售额度",$moneys,$status);
              break;
//          case "pool_money":// 矿池矿金
//              Orde::bond_finance($id,$name,$moneys,$status);
//              break;
      }

    }


    // 密码重置
    public function update_pwd()
    {
        $id=input("id");
        $pwd=input("pwd");

        $data["pwd"] = password_hash($pwd, PASSWORD_DEFAULT);;
        User::update($data,["id"=>$id]);
        json_result(200,"重置成功");

    }

    // 用户收款信息
    public function usermessage()
    {

        if (Request::isPost()) {
            $data = Request::post();
            $adminid=input("user_id");
            $where["user_id"]=$adminid;
            \app\common\model\UserMessage::update($data,$where);

            json_result(200, "修改成功", $data);
        }


            $adminid=input("user_id");
            $where["user_id"]=$adminid;
            $code=\app\common\model\UserMessage::where($where)->find();
            if (!$code){
                \app\common\model\UserMessage::create($where);
                $code=\app\common\model\UserMessage::where($where)->find();
            }

            View::assign("user",$code);
            return View::fetch();



    }

    // 封号
    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 is_admin()
    {
        $id=input("id");
        $where["id"]=$id;
        $user=User::where($where)->find();
        if ($user->is_admin==0){
            $update["is_admin"]=1;
        }else{
            $update["is_admin"]=0;
        }
        User::update($update,$where);
        json_result(200,"操作成功");
    }

//用户充值
//    public function chongzhi()
//    {
//
//    }

    // 用户通证记录
    public function tongxingzheng()
    {
        if (Request::isPost()) {
            $name = input("name");
            $page = input("page") ?: 1;
            $limit = input("limit") ?: 10;
            $where = [];
            $user_id=input("user_id");
//            $where["user_id"]=$user_id;
            $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,"设置成功");

    }

    // 通证详情
    public function certificateshow()
    {
        if (Request::isPost()) {
            $name = input("name");
            $page = input("page") ?: 1;
            $limit = input("limit") ?: 10;
            $where = [];
            $user_id=input("user_id");
            $where["user_id"]=$user_id;
//            $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];

        }
        $user_id=input("user_id");
        View::assign("user_id",$user_id);
        return View::fetch();
    }
    /**
     * 持有订单列表
     */
    public function push()
    {
        if (Request::isPost()) {
            $name = input("name");
            $page = input("page") ?: 1;
            $limit = input("limit") ?: 10;
            $where = [];
            $user_id=input("user_id");
            $where["buy_user|push_user"]=$user_id;
//            $where[]=["status",">",0];
//            $where[]=["is_admin","=",0];
            $list = \app\common\model\Order::where($where)->order("status asc,id desc")->paginate(["list_row" => $limit, "page" => $page])->each(function ($item) use ($user_id) {

                $user = \app\common\model\User::where(["id" => $item["buy_user"]])->field("name")->find();
                $item["user_name"] = $user->name;
                $item["add_time"]=date("Y-m-d H:i:s",$item["add_time"]);
                if ($item["stat_time"]){
                    $item["stat_time"]=date("Y-m-d H:i:s",$item["stat_time"]);
                }
                if ($item["end_time"]){
                    $item["end_time"]=date("Y-m-d H:i:s",$item["end_time"]);
                }
                switch ($item["status"]){
                    case 0:$item["status"]="未匹配";break;
                    case 1:$item["status"]="已匹配或待支付";break;
                    case 2:$item["status"]="已上传数据";break;
                    case 3:$item["status"]="已完成";break;
                    case 4:$item["status"]="已撤销";break;
                    case 5:$item["status"]="交易失败";break;
                }
                $item["biaoshu"]="";
                if ($user_id==$item["buy_user"]){
                    $item["biaoshu"]="购买";
                }elseif($user_id==$item["push_user"]){
                    $item["biaoshu"]="卖出";
                }

                if ($item["image"]){
                    $item["image"]=explode(",",$item["image"]);
                }
                return $item;

            })->toArray();

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

        $user_id=input("user_id");
        View::assign("user_id",$user_id);
        return View::fetch();
    }

}