102 lines
3.8 KiB
PHP
102 lines
3.8 KiB
PHP
|
<?php
|
|||
|
|
namespace app\controllers\admin;
|
|||
|
|
use Illuminate\Support\Facades\DB;
|
|||
|
|
use Yii;
|
|||
|
|
use yii\web\Controller;
|
|||
|
|
use yii\web\Response;
|
|||
|
|
use app\model\user;
|
|||
|
|
class UserController extends CommonController{
|
|||
|
|
//获取用户列表，参数keyword,status
|
|||
|
|
public function actionUserList(){
|
|||
|
|
$request = Yii::$app->request;
|
|||
|
|
if ($request->isPost){
|
|||
|
|
$result=axios_request();
|
|||
|
|
$keyword=$result['keyword'];
|
|||
|
|
$satus=$result['status']?$result['status']:2;
|
|||
|
|
$sql="select * from {{%ybwm_users}} where status=".$satus;
|
|||
|
|
if($keyword){
|
|||
|
|
$sql.=" and CONCAT(IFNULL(username,''),IFNULL(phone,'')) LIKE CONCAT('%','$keyword','%')";
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
$data= YII::$app->db->createCommand($sql)->queryAll();
|
|||
|
|
$count=count($data);
|
|||
|
|
return $this->result(1,'成功',$data,$count);
|
|||
|
|
}
|
|||
|
|
return $this->result(2,'请求异常');
|
|||
|
|
}
|
|||
|
|
//用户添加
|
|||
|
|
public function actionSave(){
|
|||
|
|
$request = Yii::$app->request;
|
|||
|
|
if($request->isPost){
|
|||
|
|
$result=axios_request();
|
|||
|
|
$res= YII::$app->db->createCommand('select * from {{%ybwm_users}} where username=:username', ['username' =>trim($result['username'])])->queryOne();
|
|||
|
|
if($res){
|
|||
|
|
return $this->result(2,'用户名已存在');
|
|||
|
|
}else{
|
|||
|
|
$salt=random(8);
|
|||
|
|
$auth_key=Yii::$app->params['authkey'];
|
|||
|
|
$password=sha1(trim($result['password']).'--'.$salt.'--'.$auth_key);
|
|||
|
|
$data=array(
|
|||
|
|
'uniacid'=>$result['uniacid'],
|
|||
|
|
'phone'=>trim($result['phone']),
|
|||
|
|
'headimgurl'=>$result['headimgurl'],
|
|||
|
|
'username'=>trim($result['username']),
|
|||
|
|
'salt'=>$salt,
|
|||
|
|
'password'=>$password,
|
|||
|
|
'joindate'=>date('Y-m-d H:i:s',time()),
|
|||
|
|
'joinip'=>getIp(),
|
|||
|
|
'lastvisit'=>date('Y-m-d H:i:s',time()),
|
|||
|
|
'register_type'=>0,
|
|||
|
|
|
|||
|
|
);
|
|||
|
|
$re= YII::$app->db->createCommand()->insert('{{%ybwm_users}}',$data)->execute();
|
|||
|
|
if($re){
|
|||
|
|
return $this->result(1,'成功');
|
|||
|
|
}else{
|
|||
|
|
return $this->result(2,'网络异常，请稍后再试');
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
return $this->result(2,'请求异常');
|
|||
|
|
}
|
|||
|
|
//用户信息编辑
|
|||
|
|
public function actionUsave(){
|
|||
|
|
$request = Yii::$app->request;
|
|||
|
|
if($request->isPost){
|
|||
|
|
$result=axios_request();
|
|||
|
|
$res= YII::$app->db->createCommand('select * from {{%ybwm_users}} where uid=:uid', ['uid' =>$result['uid']])->queryOne();
|
|||
|
|
if(!$res){
|
|||
|
|
return $this->result(2,'用户不存在');
|
|||
|
|
}else{
|
|||
|
|
$data=array('phone'=>$result['phone']);
|
|||
|
|
if(trim($result['password'])!==$res['password']){
|
|||
|
|
$data['password']=$salt=random(8);
|
|||
|
|
$auth_key=Yii::$app->params['authkey'];
|
|||
|
|
$data['password']=sha1(trim($result['password']).'--'.$salt.'--'.$auth_key);
|
|||
|
|
}
|
|||
|
|
$re=YII::$app->db->createCommand()->update('{{%ybwm_users}}', $data, 'uid=:uid', ['uid' =>$result['uid']])->execute();
|
|||
|
|
if($re!==false){
|
|||
|
|
return $this->result(1,'成功');
|
|||
|
|
}else{
|
|||
|
|
return $this->result(2,'网络异常，请稍后再试');
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
return $this->result(2,'请求异常');
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public function actionDelete(){
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public function actionDemo()
|
|||
|
|
{
|
|||
|
|
$keyword='17607186026';
|
|||
|
|
$sql="select * from users where status=2";
|
|||
|
|
|
|||
|
|
$sql.=" and CONCAT(username,phone) LIKE CONCAT('%',#{$keyword},'%')";
|
|||
|
|
dd($sql);die;
|
|||
|
|
}
|
|||
|
|
}
|