127 行
4.1 KiB
PHP
可执行文件
127 行
4.1 KiB
PHP
可执行文件
<?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,
|
|
];
|
|
}
|
|
}
|