114 lines
2.5 KiB
PHP
114 lines
2.5 KiB
PHP
<?php
|
||
|
||
namespace app\model;
|
||
|
||
use think\Db;
|
||
use think\Log;
|
||
|
||
/**
|
||
* Class UsersManager
|
||
* @package app\model
|
||
* @author: cavan
|
||
* 负责对Users用户表进行增删查改的工作
|
||
*/
|
||
class UsersManager extends Base
|
||
{
|
||
/**
|
||
* 返回码：用户名已存在
|
||
*
|
||
* @var integer
|
||
*/
|
||
public static $RET_CODE_IS_USERNAME_EXIST = -1;
|
||
|
||
/**
|
||
* 返回码： 成功
|
||
*/
|
||
public static $RET_CODE_SUCCESS = 1;
|
||
|
||
/**
|
||
* 调用delUser()时，没有任何修改返回这个参数0
|
||
*
|
||
* @var integer
|
||
*/
|
||
public static $RET_CODE_NO_MODIFY = 0;
|
||
|
||
/**
|
||
* createUser function
|
||
*
|
||
* @param [返回码,数据] $user_info
|
||
* @return success code
|
||
*/
|
||
public function createUser($user_info){
|
||
|
||
if( $this->isUserNameExist($user_info["user_name"]))
|
||
{
|
||
return [UsersManager::$RET_CODE_IS_USERNAME_EXIST,NULL];
|
||
}
|
||
|
||
$ret = Db::name('users')->insert($user_info);
|
||
dump($ret);
|
||
if( $ret )
|
||
{
|
||
// 成功
|
||
return [UsersManager::$RET_CODE_SUCCESS,$ret];
|
||
}
|
||
else
|
||
{
|
||
// 失败
|
||
return [$ret,NULL];
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 以标签的形式删除一个用户（不实际删除，只做标记）
|
||
*
|
||
* @param [type] $user_id
|
||
* @return void
|
||
*/
|
||
public function delUserWithTag($user_id)
|
||
{
|
||
|
||
$ret_code = Db::name('users')->update(["user_id"=>$user_id,"is_deleted"=>1 ]);//没有任何修改返回0
|
||
if( UsersManager::$RET_CODE_NO_MODIFY == $ret_code )
|
||
{
|
||
return [UsersManager::$RET_CODE_NO_MODIFY,NULL];
|
||
}
|
||
else{
|
||
return [UsersManager::$RET_CODE_SUCCESS,$ret_code];
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 通过用户ID找到用户信息
|
||
*
|
||
* @param [type] $user_id
|
||
* @return void
|
||
*/
|
||
public function findUserInfoByName($user_name)
|
||
{
|
||
// print( 'finduserInfobyname:'.$user_name);
|
||
return Db::name('users')->where(['user_name'=>$user_name])->select();
|
||
}
|
||
|
||
/**
|
||
* 通过用户ID找到用户信息
|
||
*
|
||
* @param [type] $user_id
|
||
* @return void
|
||
*/
|
||
public function findUserInfo($user_id)
|
||
{
|
||
return Db::name('users')->where(['user_id'=>$user_id,'is_deleted'=>0])->select();
|
||
}
|
||
|
||
/**
|
||
* isUserNameExist function
|
||
*
|
||
* @param [string] $user_name
|
||
* @return boolean
|
||
*/
|
||
public function isUserNameExist($user_name)
|
||
{
|
||
return Db::name('users')->where('user_name', $user_name)->column('user_name');
|
||
}
|
||
} |