public function actionAa()
{
//更改订单状态
$orders = PayOrder::sn('56a82aeab957e');
$time = time();
$order_id = $orders->order_id;
$sql1 = "update fin_pay_order set order_status = '4',order_pay_time = '{$time}' where order_id = {$order_id}";
$user_id = $orders->user_id;
$coin = $orders->order_price;
//给用户添加金币
$student = Students::findOne($user_id);
$money = $student->stu_money + $coin;
$stu_id = $student->stu_id;
$sql2 = "update fin_students set stu_money = '{$money}' where stu_id = '{$stu_id}'";
//生成记录
$sql3 = "insert into fin_payment(user_id,payment_type,payment_addtime,payment_money,payment_note,payment_way) values('{$user_id}','1','{$time}','{$coin}','充值金币','2')";
$connection = \Yii::$app->db;
$transaction = $connection->beginTransaction();
try {
$connection->createCommand($sql1)->execute();
$connection->createCommand($sql2)->execute();
$connection->createCommand($sql3)->execute();
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
echo $e->getMessage();
}
}
/**
* 支付宝服务器异步通知页面
*/
public function actionNotifyUrl()
{
$this->enableCsrfValidation = false;
require_once '../../vendor/alipay/lib/alipay_core.function.php';
require_once '../../vendor/alipay/lib/alipay_md5.function.php';
require_once '../../vendor/alipay/lib/alipay_notify.class.php';
require_once '../../vendor/alipay/lib/alipay_submit.class.php';
$alipay_config = Yii::$app->params['alipay']['alipay_config'];
//计算得出通知验证结果
$alipayNotify = new \AlipayNotify($alipay_config);
$verify_result = $alipayNotify->verifyNotify();
if ($verify_result) {
//验证成功
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//请在这里加上商户的业务逻辑程序代
//——请根据您的业务逻辑来编写程序（以下代码仅作参考）——
//获取支付宝的通知返回参数，可参考技术文档中服务器异步通知参数列表
//商户订单号
$out_trade_no = $_POST['out_trade_no'];
$type = substr($out_trade_no, 0, 3);
//支付宝交易号
$trade_no = $_POST['trade_no'];
//交易状态
$trade_status = $_POST['trade_status'];
if ($type == '110') {
//更改订单状态
$orders = GoodsOrder::sn($out_trade_no);
$time = time();
$order_id = $orders->order_id;
$sql1 = "update fin_goods_order set order_status = '4',order_pay_time = '{$time}' where order_id = {$order_id}";
$user_id = $orders->user_id;
$order_amount = $orders->order_amount;
$order_price = $orders->order_price;
$coin = $order_price - $order_amount;
//给用户减金币
$student = Students::findOne($user_id);
$money = $student->stu_money - $coin;
$stu_id = $student->stu_id;
$sql2 = "update fin_students set stu_money = '{$money}' where stu_id = '{$stu_id}'";
//生成记录
$sql3 = "insert into fin_payment(user_id,payment_type,payment_addtime,payment_money,payment_note,payment_way) values('{$user_id}','1','{$time}','{$coin}','商家订单','2')";
$connection = \Yii::$app->db;
$transaction = $connection->beginTransaction();
try {
$connection->createCommand($sql1)->execute();
$connection->createCommand($sql2)->execute();
$connection->createCommand($sql3)->execute();
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
echo $e->getMessage();
}
} elseif ($type == '100') {
//更改订单状态
$orders = PayOrder::sn($out_trade_no);
$time = time();
$order_id = $orders->order_id;
$sql1 = "update fin_pay_order set order_status = '4',order_pay_time = '{$time}' where order_id = {$order_id}";
$user_id = $orders->user_id;
$coin = $orders->order_price;
//给用户添加金币
$student = Students::findOne($user_id);
$money = $student->stu_money + $coin;
$stu_id = $student->stu_id;
$sql2 = "update fin_students set stu_money = '{$money}' where stu_id = '{$stu_id}'";
//生成记录
$sql3 = "insert into fin_payment(user_id,payment_type,payment_addtime,payment_money,payment_note,payment_way) values('{$user_id}','1','{$time}','{$coin}','充值金币','2')";
$connection = \Yii::$app->db;
$transaction = $connection->beginTransaction();
try {
$connection->createCommand($sql1)->execute();
$connection->createCommand($sql2)->execute();
$connection->createCommand($sql3)->execute();
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
echo $e->getMessage();
}
}
if ($_POST['trade_status'] == 'TRADE_FINISHED') {
//判断该笔订单是否在商户网站中已经做过处理
//如果没有做过处理，根据订单号（out_trade_no）在商户网站的订单系统中查到该笔订单的详细，并执行商户的业务程序
//如果有做过处理，不执行商户的业务程序
//注意：
//该种交易状态只在两种情况下出现
//1、开通了普通即时到账，买家付款成功后。
//2、开通了高级即时到账，从该笔交易成功时间算起，过了签约时的可退款时限（如：三个月以内可退款、一年以内可退款等）后。
//调试用，写文本函数记录程序运行情况是否正常
//logResult("这里写入想要调试的代码变量值，或其他运行的结果记录");
//logResult($_POST['trade_status']);
} else {
if ($_POST['trade_status'] == 'TRADE_SUCCESS') {
//判断该笔订单是否在商户网站中已经做过处理
//如果没有做过处理，根据订单号（out_trade_no）在商户网站的订单系统中查到该笔订单的详细，并执行商户的业务程序
//如果有做过处理，不执行商户的业务程序
//注意：
//该种交易状态只在一种情况下出现——开通了高级即时到账，买家付款成功后。
//调试用，写文本函数记录程序运行情况是否正常
//logResult("这里写入想要调试的代码变量值，或其他运行的结果记录");
//logResult($_POST['trade_status']);
}
}
//——请根据您的业务逻辑来编写程序（以上代码仅作参考）——
echo "success";
//请不要修改或删除
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
} else {
//验证失败
echo "fail";
//调试用，写文本函数记录程序运行情况是否正常
//logResult("这里写入想要调试的代码变量值，或其他运行的结果记录");
}
}
public function actionPwd()
{
$request = Yii::$app->request->post();
//修改用户密码
if ($request['type'] == 'pwd') {
if (!empty($request['oldpassword']) && !empty($request['password']) && !empty($request['ispassword'])) {
$User = new User();
$re = $User->password($request['stu_id'], md5($request['oldpassword']));
if ($re) {
preg_match('/\\w{5,17}/', $request['password'], $str);
preg_match('/\\w{5,17}/', $request['ispassword'], $strs);
//验证是否合法
if ($str && $strs) {
//验证密码密码是否一致
if ($request['password'] == $request['ispassword']) {
//修改支付密码
$user = User::findOne($request['stu_id']);
$user->user_password = md5($request['ispassword']);
$res = $user->save();
if ($res) {
$this->success('修改成功!', ['student/info']);
} else {
$this->error('修改失败!', ['student/studentsave']);
}
} else {
$this->error('密码与确认密码不一致请重新输入!', ['student/studentsave']);
}
} else {
$this->error('密码必须6-18位!', ['student/studentsave']);
}
} else {
$this->error('旧密码错误!', ['student/studentsave']);
}
} else {
$this->error('数据不能为空!', ['student/studentsave']);
}
//修改支付密码
} else {
if ($request['type'] == 'pay') {
if (!empty($request['paypassword']) && !empty($request['ispaypassword']) && !empty($request['code']) && !empty($request['stu_id'])) {
preg_match('/\\w{5,17}/', $request['paypassword'], $str);
preg_match('/\\w{5,17}/', $request['ispaypassword'], $strs);
//验证是否合法
if ($str && $strs) {
//验证密码密码是否一致
if ($request['paypassword'] == $request['ispaypassword']) {
//验证验证码是否合法
$code = new Code();
$code = $code->getUsercode($request['str_phone']);
if ($code == $request['code']) {
//修改支付密码
$stu = Students::findOne($request['stu_id']);
$stu->stu_pwd = md5($request['ispaypassword']);
$res = $stu->save();
if ($res) {
$this->success('修改成功!', ['student/info']);
} else {
$this->error('修改失败!', ['student/studentsave']);
}
} else {
$this->error('验证码错误!', ['student/studentsave']);
}
} else {
$this->error('密码与确认密码不一致请重新输入!', ['student/studentsave']);
}
} else {
$this->error('密码必须6-18位!', ['student/studentsave']);
}
} else {
$this->error('数据不能为空!', ['student/studentsave']);
}
//手机验证
} else {
if ($request['type'] == 'phone') {
if (!empty($request['phone']) && !empty($request['code'])) {
$User = new User();
$re = $User->phone($request['phone']);
if (!$re) {
preg_match('/(13[0-9]|15[012356789]|17[678]|18[0-9]|14[57])[0-9]{8}/', $request['phone'], $str);
//验证是否合法
if ($str) {
//修改支付密码
$user = User::findOne($request['stu_id']);
$user->user_phone = $request['phone'];
$res1 = $user->save();
$user = Students::findOne($request['stu_id']);
$user->stu_phone = $request['phone'];
$res2 = $user->save();
if ($res1 && $res2) {
$this->success('修改成功!', ['student/info']);
} else {
$this->error('修改失败!', ['student/studentsave']);
}
} else {
$this->error('手机号码格式不正确!', ['student/studentsave']);
}
} else {
$this->error('手机号码已存在!', ['student/studentsave']);
}
} else {
$this->error('数据不能为空!', ['student/studentsave']);
}
}
}
}
}
