<?php
|
|
namespace app\operations\model\user;
|
|
use app\common\model\user\CardRecord as CardRecordModel;
|
|
/**
|
* 会员卡记录模型
|
*/
|
class CardRecord extends CardRecordModel
|
{
|
/**
|
* 获取列表记录
|
*/
|
public function getList($data)
|
{
|
$model = $this;
|
if ($data['search']) {
|
$model = $model->where('card_name|nickName', 'like', '%' . $data['search'] . '%');
|
}
|
if ($data['status'] >= 0) {
|
if ($data['status'] == 0) {
|
$model = $model->where('expire_time', '<', time());
|
} else {
|
$model = $model->where('expire_time', '>=', time());
|
}
|
|
}
|
$list = $model->alias('r')
|
->where('pay_status', '=', 20)
|
->where('r.is_delete', '=', 0)
|
->with(['card', 'user'])
|
->join('user u', 'u.user_id=r.user_id')
|
->join('user_card c', 'c.card_id=r.card_id')
|
->field('r.*')
|
->order(['r.create_time' => 'desc'])
|
->paginate($data);
|
return $list;
|
}
|
|
/**
|
* 延期
|
*/
|
public function delay($data)
|
{
|
$isExist = self::checkExistByUserId($this['user_id'], $data['order_id']);
|
if ($isExist) {
|
$this->error = "该会员已存在会员卡，请勿延期";
|
return false;
|
}
|
$update['expire_time'] = strtotime($data['expire_time']);
|
if ($update['expire_time'] < $this['expire_time']) {
|
$this->error = "延期日期不能小于当前有效期";
|
return false;
|
}
|
return $this->save($update);
|
}
|
|
/**
|
* 获取微信购买卡的金额
|
*/
|
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)
|
->where('pay_type', '=', 20)
|
->sum("money");
|
|
return $money;
|
}
|
|
}
|
