127 lines
2.9 KiB
PHP
127 lines
2.9 KiB
PHP
<?php
|
|
|
|
namespace app\admin\model\app\activity;
|
|
|
|
use think\Model;
|
|
|
|
|
|
class Userticket extends Model
|
|
{
|
|
|
|
|
|
|
|
|
|
|
|
// 表名
|
|
protected $name = 'app_activity_user_ticket';
|
|
|
|
// 自动写入时间戳字段
|
|
protected $autoWriteTimestamp = 'integer';
|
|
|
|
// 定义时间戳字段名
|
|
protected $createTime = 'createtime';
|
|
protected $updateTime = false;
|
|
protected $deleteTime = false;
|
|
|
|
// 追加属性
|
|
protected $append = [
|
|
'status_text'
|
|
];
|
|
|
|
|
|
/**
|
|
* 获取报名统计信息
|
|
* @return void
|
|
*/
|
|
public function getApplyTotalData($activityId){
|
|
$data = [];
|
|
|
|
//已签到
|
|
$data['signined'] = self::where([
|
|
'activity_id'=>$activityId,
|
|
'sign'=>1,
|
|
'status'=>1
|
|
])->count();
|
|
|
|
|
|
//报名成功
|
|
$data['success'] = self::where([
|
|
'activity_id'=>$activityId,
|
|
'status'=>1
|
|
])->count();
|
|
|
|
//未签到
|
|
$data['un_signined'] = $data['success'] - $data['signined'];
|
|
$data['un_signined'] = $data['un_signined'] >= 0 ? $data['un_signined'] : 0;
|
|
|
|
//总报名人数
|
|
$data['all_apply'] = self::where([
|
|
'activity_id'=>$activityId
|
|
])->count();
|
|
|
|
//待审核
|
|
$data['un_audit'] = self::where([
|
|
'activity_id'=>$activityId,
|
|
'status'=>0
|
|
])->count();
|
|
|
|
return $data;
|
|
}
|
|
|
|
|
|
|
|
public function getStatusList()
|
|
{
|
|
return ['1' => __('Status 1'), '0' => __('Status 0'), '2' => __('Status 2')];
|
|
}
|
|
|
|
public function getSignList()
|
|
{
|
|
return ['1' => __('Sign 1'), '0' => __('Sign 0')];
|
|
}
|
|
|
|
|
|
public function getStatusTextAttr($value, $data)
|
|
{
|
|
$value = $value ? $value : (isset($data['status']) ? $data['status'] : '');
|
|
$list = $this->getStatusList();
|
|
return isset($list[$value]) ? $list[$value] : '';
|
|
}
|
|
|
|
|
|
public function getUseTimeTextAttr($value, $data)
|
|
{
|
|
$value = $value ? $value : (isset($data['use_time']) ? $data['use_time'] : '');
|
|
return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
|
|
}
|
|
|
|
protected function setUseTimeAttr($value)
|
|
{
|
|
return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
|
|
}
|
|
|
|
|
|
public function activity()
|
|
{
|
|
return $this->belongsTo('app\admin\model\app\Activity', 'activity_id', 'id', [], 'LEFT')->setEagerlyType(0);
|
|
}
|
|
|
|
|
|
public function user()
|
|
{
|
|
return $this->belongsTo('app\admin\model\User', 'user_id', 'id', [], 'LEFT')->setEagerlyType(0);
|
|
}
|
|
|
|
|
|
public function ticket()
|
|
{
|
|
return $this->belongsTo('Ticket', 'ticket_id', 'id', [], 'LEFT')->setEagerlyType(0);
|
|
}
|
|
|
|
|
|
public function form()
|
|
{
|
|
return $this->belongsTo('app\admin\model\app\activity\apply\Form', 'apply_info_id', 'id', [], 'LEFT')->setEagerlyType(0);
|
|
}
|
|
}
|