<?php

namespace app\operations\model\user;

use app\common\model\user\BalanceOrder as BalanceOrderModel;

/**
 * 充值模型
 */
class BalanceOrder extends BalanceOrderModel
{
    /**
     * 列表
     */
    public function getList($params)
    {
        $model = $this->alias('log');
        !empty($params['search']) && $model = $model->where('user.nickName', 'like', "%{$params['search']}%");
        //搜索时间段
        if (isset($params['value1']) && $params['value1'] != '') {
            $sta_time = array_shift($params['value1']);
            $end_time = array_pop($params['value1']);
            $model = $model->whereBetweenTime('log.create_time', $sta_time, date('Y-m-d 23:59:59', strtotime($end_time)));
        }
        $list = $model->with(['user'])
            ->join('user', 'user.user_id = log.user_id')
            ->order(['log.create_time' => 'desc'])
            ->field('log.*')
            ->paginate($params);
        foreach ($list as $key => &$value) {
                $value['snapshot'] = json_decode($value['snapshot'],true);
            }    
        return $list;    
    }
    /**
     * 获取充值金额
     */
    public function getTotalPayByDate($day,$user_ids=[],$in='true')
    {
        $start = strtotime($day);
        $end = strtotime($day) + 86399;
        $model = $this;
        if(!empty($user_ids)){
            if($in){
                $model = $model->where('user_id', 'in', $user_ids);
            }else{
                $model = $model->where('user_id', 'not in', $user_ids);
            }
        }
        $money = $model->where('create_time', 'between', "$start,$end")
            ->where('pay_status', '=', 20)
            ->sum("pay_price");

        return $money;
    }
}