<?php

namespace app\api\model;

use app\common\model\MoneyLog;
use app\common\model\ScoreLog;
use think\Db;
use think\Model;

class UserScoreLog extends Model
{
    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';
    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = false;

    protected $append = [
        'type_text'
    ];

    public function getCreatetimeAttr($value)
    {
        return date('Y-m-d H:i', $value);
    }

    public function getTypeList()
    {
        return ['1' => '购物返积分', '2' => '积分商城兑换'];
    }

    public function getTypeTextAttr($value, $data)
    {
        $value = $value ? $value : (isset($data['type']) ? $data['type'] : '');
        $list = $this->getTypeList();
        return isset($list[$value]) ? $list[$value] : '';
    }

    public function selectPageData($where, $page, $limit,$betweenTime)
    {
        $total = $this
            ->where($where)
            ->whereTime('createtime','between',$betweenTime)
            ->count();

        $list = $this
            ->where($where)
            ->whereTime('createtime','between',$betweenTime)
            ->field('score,after,type,createtime')
            ->page($page, $limit)
            ->select();
        return ['total' => $total, 'list' => $list];
    }

    public function setDecScore($userId,$score){
        Db::startTrans();
        $oldscore = Db::name('user')->where('id', $userId)->value('score');
        try {
            $res1 = Db::name('user')->where('id',$userId)->setDec('score',$score);
            $data = [
                'user_id' => $userId,
                'type' => 2,
                'score' => $score,
                'before' => $oldscore,
                'after' => $oldscore-$score,
                'createtime' => time(),
            ];
            $res2 = $this->save($data);
            if ($res1 && $res2 ) {
                Db::commit();
                return true;
            }else{
                return false;
            }
        } catch (Exception $e) {
            Db::rollback();
            return false;
        }
    }
}