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;
|
||
}
|
||
} |