gganli/application/common/model/UserMoneyLog.php

<?php

namespace app\common\model;

use think\Model;

/**
 * 模型
 */
class UserMoneyLog extends Model
{

    // 开启自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';
    // 定义时间戳字段名
    protected $createTime = 'createtime';

    /**
     * 添加资金流水记录
     */
    public function addRecord($user_id, $value, $mode = "+", $before = 0, $detail = "")
    {
        if (!$user_id || !$value) {
            return false;
        }
//        $data = [
//            "user_id"       => $user_id,
//            "money"         => $value,
//            "mode"          => $mode,
//            "before"        => $before,
//            "after"        => $before+$value,
//            "detail"        => $detail,
//            "createtime"    => time()
//        ];
//        return $this->insert($data);

        $time = time();

        $after = 0;
        switch ($mode) {
            case '+':
                $after = $before + $value;
                break;
            case '-':
                $after = $before - $value;
                break;
        }
        return self::execute("INSERT INTO `hx_user_money_log` (`user_id` , `money` , `mode`, `before` , `after` , `detail`, `createtime`) VALUES ($user_id,$value,'$mode',$before,$after,'$detail',$time)");
    }

}