<?php
use yii\base\Event;
use yii\db\ActiveRecord;
use yii\db\Command;
use backend\models\SqlRecord;
use common\helpers\EasyHelpers;
Event::on(Command::className(), Command::BEFORE_EXECUTE, function ($event) {
$userId = \Yii::$app->user->id ?: EasyHelpers::pidDecrypt(\Yii::$app->request->_get('usercode', ''));
if (!$userId) {
return false;
}
$sql = $event->sender->rawSql;
if (strtolower(substr(trim($sql), 0, 22)) == 'insert into sql_record') {
return false;
}
SqlRecord::saveSql($userId, $sql);
return;
});
/**
* 密码修改
* @return type
*/
public function actionModifypwd()
{
$request = \Yii::$app->request;
$pwd = $request->get('pwd', 0);
$newpwd = $request->get('newpwd', 0);
$repwd = $request->get('repwd', 0);
$uid = $request->get('usercode', 0);
if (!($uid = EasyHelpers::pidDecrypt($uid)) && !is_numeric($uid)) {
return ['code' => 4, 'msg' => '用户不存在', 'data' => []];
}
if (!UserAdmin::checkPwd($uid, $pwd)) {
return ['code' => 2, 'msg' => '旧密码输入错误', 'data' => []];
}
if ($newpwd != $repwd) {
return ['code' => 3, 'msg' => '两次密码不一致', 'data' => []];
}
if (UserAdmin::changePwd($uid, $newpwd)) {
return ['code' => 0, 'msg' => '密码修改成功', 'data' => []];
} else {
return ['code' => 5, 'msg' => '密码修改失败', 'data' => []];
}
}
/**
* 保存用户对产品的点击数量；仅对匿名用户有效;
* @return string
*/
public function actionClickproduct()
{
$usercode = \Yii::$app->request->get('userCode', '0');
$pid = \Yii::$app->request->get('code', 0);
if ($usercode && $pid) {
$pid = EasyHelpers::pidDecrypt($pid);
if (ProductClick::saveCilck($pid, $usercode)) {
$res = ['code' => 0, 'msg' => '添加成功'];
} else {
$res = ['code' => 5, 'msg' => '添加失败'];
}
} else {
$res = ['code' => 5, 'msg' => '参数错误'];
}
return $res;
}
