<?php

namespace app\api\logic;
use app\common\logic\Basic as BasicLogic;
use app\common\model\user\Settlement as ModelSettlementRecord;
use think\Db;


class SettlementRecord extends BasicLogic
{

    protected $model;

    protected function initialize()
    {
        $this->model = new ModelSettlementRecord();
    }
    

    /**
     * 统计拥有累计结算金额
     *
     * @return void
     */
    public function totalMoney($user_id)
    {
        $total = $this->model->where(['user_id'=>$user_id,'status'=>1])->sum('change_money');
        return empty($total) ? 0 : $total;
    }

    /**
     * 获取结算记录
     *
     * @return void
     */
    public function getList($user_id,$page,$pageSize)
    {
        $list = $this->model->field('id,title,change_money,create_time,status')->where(['user_id'=>$user_id])->page($page,$pageSize)->order('id desc')->select();
        return empty($list) ? [] : $list;
    }


    /**
     * 记录佣金
     *
     * @return void
     */
    public static function writeLog($type,$money,$user_id,$memo)
    {
        Db::startTrans();
        try {
            ModelSettlementRecord::create(['user_id' => $user_id,'title'=>$memo,'type'=> $type, 'change_money' => $money, 'status' => 1,'create_time'=>time()]);
            Db::commit();
        } catch (\Exception $e) {
            Db::rollback();
        }
    }


}