caiping/app/admin/controller/Proprietor.php

<?php
/**
 * @copyright Copyright (c) 2021 勾股工作室
 * @license https://opensource.org/licenses/Apache-2.0
 * @link https://www.gougucms.com
 */

declare (strict_types = 1);

namespace app\admin\controller;

use app\admin\BaseController;
use app\admin\model\Admin as AdminList;
use app\admin\validate\AdminCheck;
use avatars\MDAvatars;
use think\exception\ValidateException;
use think\facade\Db;
use think\facade\View;
use think\facade\Session;
use think\App;
use think\facade\Cache;

use app\admin\controller\Role;
use app\admin\model\Department as DepartmentModel;

class Proprietor extends BaseController
{

    public function __construct(App $app)
    {
        parent::__construct($app);

        $this->Role = new Role($this->app);
        $this->Department = new DepartmentModel();
    }

    public function index()
    {
        if (request()->isAjax()) {

            // 获取单位名称
            $session_admin = get_config('app.session_admin');
            $id = Session::get($session_admin)['id'];
            $unit_name = Db::name('admin')->where('id', $id)->value('unit_name');

            $param = get_params();

            $proprietorDepartmentIds = Db::name("department")
                ->where([
                    ["delete_time", "=", 0],
                    ["pid", "=", 0],
                    ["type", "=", 1], //1表示业主
                    ["entrust_unit", "=", $unit_name] // 确保只获取当前财评所属单位关联的业主单位
                ])->column('id');//找到业主部门354
            $where = [
                ['status', '>=', 0],
                ['unit_name', 'in', $proprietorDepartmentIds]
            ];

            if (!empty($param['keywords'])) {
                $keywordWhere = ['id|username|nickname|desc|mobile', 'like', '%'. $param['keywords']. '%'];
                $where = array_merge($where, [$keywordWhere]);
            }

            $rows = empty($param['limit']) ? get_config('app.page_size') : $param['limit'];
            $proprietor = AdminList::where($where)->with('Department')
                ->order('create_time asc')
                ->paginate($rows, false, ['query' => $param])
                ->each(function ($item, $key) {
                    $groupId = Db::name('AdminGroupAccess')->where(['uid' => $item->id])->column('group_id');
                    $groupName = Db::name('AdminGroup')->where('id', 'in', $groupId)->column('title');
                    $item->groupName = implode(',', $groupName);
                    $item->last_login_time = empty($item->last_login_time) ? '-' : date('Y-m-d H:i', $item->last_login_time);
                })->toArray();

            return table_assign(0, '', $proprietor);
        } else {
            return view();
        }
    }
    

    //添加/编辑
    public function add()
    {	
		if (request()->isAjax()) {
			$param = get_params();

            if (!empty($param['id']) && $param['id'] > 0) { //对已存在账号的编辑

                try {//验证编辑信息
                    validate(AdminCheck::class)->scene('edit')->check($param);
                } catch (ValidateException $e) {
                    // 验证失败 输出错误信息
                    return to_assign(1, $e->getError());
                }
                if (!empty($param['edit_pwd'])) {
                    //修改密码
                    if (empty($param['edit_pwd_confirm']) or $param['edit_pwd_confirm'] !== $param['edit_pwd']) {
                        return to_assign(1, '两次密码不一致');
                    }
                    
                    $param['salt'] = set_salt(20);
                    $param['pwd'] = set_password($param['edit_pwd'], $param['salt']);
                }
                // 启动事务
                Db::startTrans();
                try {

                    Db::name('Admin')->where(['id' => $param['id']])->strict(false)->field(true)->update($param);   //更新密码


                    if (!isset($param['thumb']) || $param['thumb'] == '') {//头像更新
                        $char = mb_substr($param['nickname'], 0, 1, 'utf-8');
                        Db::name('Admin')->where('id', $param['id'])->update(['thumb' => $this->to_avatars($char)]);
                    }

                    // 获取单位名称
                    $unit_name = self::get_unitName($param['id']);
                    $data = [
                        'unit_name' => $unit_name,//更新用户信息的所属部门
                        'user_type' => Db::name('Department')->where('id', $unit_name)->value('type'),
                        'admin_group_id' => $param['admin_group_id'],//更新用户角色
                    ];
                     Db::name('admin')->where('id', $param['id'])->data($data)->update();

                    add_log('edit', $param['id'], $param);
                    //清除菜单\权限缓存
                    clear_cache('adminMenu');
                    clear_cache('adminRules');
                    // 提交事务
                    Db::commit();
                } catch (\Exception $e) {
                    // 回滚事务
                    Db::rollback();
                    return to_assign(1, '提交失败:' . $e->getMessage());
                }
            } else {    //新增账号

                try {//验证信息
                    validate(AdminCheck::class)->scene('add')->check($param);
                } catch (ValidateException $e) {
                    // 验证失败 输出错误信息
                    return to_assign(1, $e->getError());
                }
                //加密
                $param['salt'] = set_salt(20);
                $param['pwd'] = set_password($param['pwd'], $param['salt']);
                // 启动事务
                Db::startTrans();
                try {
                    
                    foreach ($param['group_id'] as $k => $v) {//用户角色
                        $param['admin_group_id'] = $v;
                    }
                    //插入用户并返回插入的id
                    $uid = Db::name('Admin')->strict(false)->field(true)->insertGetId($param);

                    unset($param['admin_group_id']);

                    if($param['is_principal'] == 1){//是部门负责人
                        Db::name('department')->where('id', $param['did'])->data(['leader_id' => $uid])->update();
                    }

                    if (!isset($param['thumb']) || $param['thumb'] == '') {//头像处理
                        $char = mb_substr($param['nickname'], 0, 1, 'utf-8');
                        Db::name('Admin')->where('id', $uid)->update(['thumb' => $this->to_avatars($char)]);
                    }

                    // 获取业主单位名称
                    $unit_name = self::get_unitName($uid);

                    $data = [
                        'unit_name' => $unit_name,
                        'user_type' => Db::name('Department')->where('id', $unit_name)->value('type'),
                    ];

                    Db::name('admin')->where('id', $uid)->data($data)->update();

                    add_log('add', $uid, $param);
                    // 提交事务
                    Db::commit();
                } catch (\Exception $e) {
                    // 回滚事务，回到最初
                    Db::rollback();
                    return to_assign(1, '提交失败:' . $e->getMessage());
                }
            }
            return to_assign(0,"操作成功");
		}else{
		    
			$id = empty(get_params('id')) ? 0 : get_params('id');
            // dump($id);
            $permission = Db::name('admin')->where('id', get_login_admin('id'))->value('permission');

            $unit_name = Db::name('admin')->where('id', get_login_admin('id'))->value('unit_name');

            $where_d = array();
            $where_g = array();

            if($permission == 0){
                //业主部门找在他委托下的
                //$where_d[] =["entrust_unit", "=", $unit_name];
                $where_d[]=["unit_name","=",get_login_admin('unit_name')];
                $where_g[] = [
                    ["pid","=",Db::name("admin_group")->where( 'title',  "业主")->value("id")],
                ];
            }

            $department = Db::name('Department')
                    ->where('status', '>=', 0)//正常
                    ->where($where_d)
                    ->find();


            $group = Db::name('AdminGroup')
                    ->whereOr($where_g)
                    ->select()->toarray();

			if ($id > 0) {//编辑时
				$admin = get_admin(get_params('id'));

                $leader_id = Db::name('Department')->where('id', $admin['did'])->value('leader_id');

                if($leader_id == $id){
                    $is_principal = 1;
                }else{
                    $is_principal = 0;
                }
                
                View::assign('is_principal', $is_principal);
				View::assign('admin', $admin);
			}

            View::assign('permission', $permission);
			View::assign('department', $department);

            View::assign('group', $group);
			View::assign('id', $id);
			return view();
		}
    }

    public function to_avatars($char)
    {
        $defaultData = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N',
            'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'S', 'Y', 'Z',
            '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
            '零', '壹', '贰', '叁', '肆', '伍', '陆', '柒', '捌', '玖', '拾',
            '一', '二', '三', '四', '五', '六', '七', '八', '九', '十');
        if (isset($char)) {
            $Char = $char;
        } else {
            $Char = $defaultData[mt_rand(0, count($defaultData) - 1)];
        }
        $OutputSize = min(512, empty($_GET['size']) ? 36 : intval($_GET['size']));

        $Avatar = new MDAvatars($Char, 256, 1);
        $avatar_name = '/avatars/avatar_256_' . set_salt(10) . time() . '.png';
        $path = get_config('filesystem.disks.public.url') . $avatar_name;
        $res = $Avatar->Save('.' . $path, 256);
        $Avatar->Free();

        return $path;
    }

    //查看
    public function view()
    {
		$id = get_params('id');
		$rule = get_admin_rule();

		$user_groups = Db::name('AdminGroupAccess')
                ->alias('a')
                ->join("AdminGroup g", "a.group_id=g.id", 'LEFT')
                ->where("a.uid='{$id}' and g.status='1'")
                ->select()
                ->toArray();
		$groups = $user_groups ?: [];

		$rules = [];
		foreach ($groups as $g) {
			$rules = array_merge($rules, explode(',', trim($g['rules'], ',')));
		}
		$rules = array_unique($rules);

		$role_rule = create_tree_list(0, $rule, $rules);

        $role_rule = $this->Role->remove_checked_false($role_rule);

		$department = get_department();
        // dump($department);
        $position = Db::name('Position')->where('status', '>=', 0)->order('create_time asc')->select();
		View::assign('department', $department);
        View::assign('position', $position);
        View::assign('role_rule', $role_rule);
        View::assign('admin', get_admin($id));		
		add_log('view', get_params('id'));
        return view('', ['admin' => get_admin(get_params('id'))]);
    }
    //删除
    public function delete()
    {
        $id = get_params("id");
        if($id == 1){
            return to_assign(0, "超级管理员，不能删除");
        }
        $data['status'] = '-1';//改为已被删除，但是不会在admin里消失
        $data['id'] = $id;
        $data['update_time'] = time();
        if (Db::name('Admin')->update($data) !== false) {
            add_log('delete', $id);
            return to_assign(0, "删除业主成功");
        } else {
            return to_assign(1, "删除失败");
        }
    }

    public function get_unitName($id){

        $did = Db::name('Admin')->where('id', $id)->value('did');

        $pid = $did;
        
        while($pid != 0){   

            $value = Db::name('department')->where('id', $pid)->column('id,pid,title')[0];
            $id = $value['id'];
            $pid = $value['pid'];
            $title = $value['title'];  
        }

        return $id;
    }


}