<?php

namespace Common\Model;

use Think\Model;

//[1.8.50]
/**
 * 角色-用户表
 * Class JurisdictionUserModel
 * @package Common\Model
 */
class JurisdictionUserModel extends BaseModel
{
    protected $tableName = 'jurisdiction_user';
    protected $fields = array(
        'id',                   //int(11) NOT NULL AUTO_INCREMENT,
        'login_name',           //varchar(255) DEFAULT NULL COMMENT '登录名',
        'password',             //varchar(255) DEFAULT NULL COMMENT '登录密码',
        'name',                 //varchar(255) DEFAULT NULL COMMENT '用户姓名',
        'add_time',             //varchar(20) DEFAULT NULL COMMENT '添加时间',
        'jurisdiction_group_id',//int(11) DEFAULT '0' COMMENT '角色权限组id',
        'user_type',            //tinyint(1) DEFAULT '0' COMMENT '0新建的角色   1合伙人    2代理商    3商户     4店长   5导购员',
        'system_user_id',       //int(11) DEFAULT '0' COMMENT '系统角色id',
        'state',                //tinyint(1) DEFAULT '1' COMMENT '1正常   0删除',
        'status',               //tinyint(1) DEFAULT '1' COMMENT '1正常    0禁用',
        'pid',                  //int(11) DEFAULT '0' COMMENT '该用户的创建者id   本表id',
        'openid',               //varchar(255) DEFAULT NULL,微信openid
        'avatar',               //varchar(255) DEFAULT NULL COMMENT '用户头像',
        'avatar_id',            //varchar(255) DEFAULT '0' COMMENT '头像图片id',
        'first_pid',            //int(11) DEFAULT '0' COMMENT '所属系统角色在当前表里的ID',
    );

    /**
     * @param $map
     * @return mixed
     */
    /**
     * 添加商户信息
     */
    public function addUser($data)
    {
        $res = $this->add($data);
        return $res;
    }

    //编辑代理商信息
    public function updateUser($map, $data)
    {
        if (isset($data['login_name'])) {
            $data['login_name'] = trim($data['login_name']);
            if (!strlen($data['login_name'])) {
                return false;
            }
            $save['login_name'] = $data['login_name'];
        }
        if (isset($data['password'])) {
            $data['password'] = trim($data['password']);
            if (!strlen($data['password'])) {
                return false;
            }
            $save['password'] = $data['password'];
        }
        if (isset($data['name'])) {
            $data['name'] = trim($data['name']);
            if (!strlen($data['name'])) {
                return false;
            }
            $save['name'] = $data['name'];
        }
        if (isset($data['openid'])) {
            $save['openid'] = $data['openid'];
        }
        if (isset($data['avatar'])) {
            $save['avatar'] = $data['avatar'];
        }
        if (isset($data['avatar_id'])) {
            $save['avatar_id'] = $data['avatar_id'];
        }
        if (isset($data['status'])) {
            $data['status'] = trim($data['status']);
            if ($data['status'] !== 0 && $data['status'] !== 1) {
                return false;
            }
            $save['status'] = $data['status'];
        }
        if (!empty($save)) {
            $res = $this->where($map)->save($save);
            return $res;
        } else {
            return false;
        }
    }

    /**
     * 删除用户
     * @param $map
     * @return mixed
     */
    public function delUser($map)
    {
        $res = $this->where($map)->save(array('state' => 0, 'status' => 0));
        return $res;
    }

    /**
     * 获取全部登录列表
     */
    public function getManagerList($where, $page, $limit)
    {
        $list = $this->alias('u')
            ->join('ls_jurisdiction_group as g on u.jurisdiction_group_id=g.id')
            ->where($where)
            ->field('u.id,u.login_name,u.name,u.add_time,u.status,g.role_name')
            ->page($page . ',' . $limit)
            ->select();
        $count = $this->alias('u')
            ->join('ls_jurisdiction_group as g on u.jurisdiction_group_id=g.id')
            ->where($where)
            ->count();
        return [
            'list' => $list ? $list : [],
            'count' => $count ? $count : 0,
        ];
    }
}