<?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;
|
}
|
}
|
