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