tp3.2 事务

开启事务：M()->startTrans();

提交事务：M()->commit();

回滚事务：M()->rollback();

public function afresh(){
        M()->startTrans();//开启事务
        try{
            $id = I('get.id');//钱包记录id
            $uid = I('uid'); //渠道用户id
            $amount = I('amount'); //原有金额
            $createdAt = I('created_at'); //创建时间
            empty($id)?E('缺少必要参数id'):'';
            empty($uid)?E('缺少必要参数uid'):'';
            empty($amount)?E('缺少必要参数amount'):'';
            empty($createdAt)?E('缺少必要参数createdAt'):'';

            //1.原有金额 $amount
            //2.重新该渠道该天获得当日佣金（收益）
            $agentAmount = $this->getAgentAmount($uid,$createdAt);

            //3.重新算出的佣金更新对应钱包记录金额
            $model = M('cps_wallet_record','cy_');
            $data['amount'] = $agentAmount;
            $model->where(['id'=>$id])->save($data);

            //4.更新用户钱包余额（原钱包余额-当前金额+重新算出的佣金）
            $User = M('cps_user','cy_ct_');
            $oldMoney = $User->where()->getField('money');
            $newMoney = $oldMoney-$amount+$agentAmount;
            $User->where(['id'=>$uid])->save(['money'=>$newMoney]);

            M()->commit();//提交

            $this->return['status'] = 1;
            $this->return['message'] = '重算当日收益成功';

        }catch (\Exception $ex){
            M()->rollback();//回滚
            $this->return['message'] = $ex->getMessage();
        }
        $this->ajaxReturn($this->return);
    }