grid->column($field, $label)
->using(ACTIVITY_STATUS::getAll())
->label([
ACTIVITY_STATUS::NOT_STARTED->value => 'default',
ACTIVITY_STATUS::IN_PROGRESS->value => 'success',
ACTIVITY_STATUS::ENDED->value => 'warning',
ACTIVITY_STATUS::CLOSED->value => 'danger',
]);
}
/**
* 添加活动类型列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnActivityType(string $field = 'type', string $label = '活动类型'): Column
{
return $this->grid->column($field, $label)
->using(ACTIVITY_TYPE::getAll())
->label([
ACTIVITY_TYPE::GIFT_PACKAGE->value => 'info',
ACTIVITY_TYPE::TIME_LIMITED->value => 'primary',
ACTIVITY_TYPE::TASK->value => 'success',
ACTIVITY_TYPE::SIGN_IN->value => 'warning',
ACTIVITY_TYPE::FESTIVAL->value => 'danger',
]);
}
/**
* 添加条件类型列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnConditionType(string $field = 'condition_type', string $label = '条件类型'): Column
{
return $this->grid->column($field, $label)->using(CONDITION_TYPE::getAll());
}
/**
* 添加参与状态列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnParticipationStatus(string $field = 'completion_status', string $label = '参与状态'): Column
{
return $this->grid->column($field, $label)
->using(PARTICIPATION_STATUS::getAll())
->label([
PARTICIPATION_STATUS::IN_PROGRESS->value => 'primary',
PARTICIPATION_STATUS::COMPLETED->value => 'success',
PARTICIPATION_STATUS::FAILED->value => 'danger',
]);
}
/**
* 添加奖励状态列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnRewardStatus(string $field = 'reward_status', string $label = '奖励状态'): Column
{
return $this->grid->column($field, $label)
->using(REWARD_STATUS::getAll())
->label([
REWARD_STATUS::NOT_CLAIMED->value => 'default',
REWARD_STATUS::CLAIMED->value => 'success',
REWARD_STATUS::EXPIRED->value => 'danger',
]);
}
/**
* 添加奖励类型列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnRewardType(string $field = 'reward_type', string $label = '奖励类型'): Column
{
return $this->grid->column($field, $label)->using(REWARD_TYPE::getAll());
}
/**
* 添加奖励来源类型列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnRewardSourceType(string $field = 'source_type', string $label = '奖励来源'): Column
{
return $this->grid->column($field, $label)->using(REWARD_SOURCE_TYPE::getAll());
}
/**
* 添加活动时间范围列
*
* @param string $startField 开始时间字段
* @param string $endField 结束时间字段
* @param string $label 标签名
* @return Column
*/
public function columnActivityTimeRange(string $startField = 'start_time', string $endField = 'end_time', string $label = '活动时间'): Column
{
return $this->grid->column($startField, $label)->display(function ($startTime) use ($endField) {
$endTime = $this->{$endField};
return date('Y-m-d H:i:s', strtotime($startTime)) . '
至
' . date('Y-m-d H:i:s', strtotime($endTime));
});
}
/**
* 添加活动状态标签列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnActivityStatusWithAutoUpdate(string $field = 'status', string $label = '活动状态'): Column
{
return $this->grid->column($field, $label)->display(function ($status) {
$now = time();
$startTime = strtotime($this->start_time);
$endTime = strtotime($this->end_time);
// 自动计算实际状态
$actualStatus = $status;
if ($status == ACTIVITY_STATUS::NOT_STARTED->value && $now >= $startTime) {
$actualStatus = ACTIVITY_STATUS::IN_PROGRESS->value;
} elseif ($status == ACTIVITY_STATUS::IN_PROGRESS->value && $now >= $endTime) {
$actualStatus = ACTIVITY_STATUS::ENDED->value;
}
$statusText = ACTIVITY_STATUS::getAll()[$actualStatus] ?? '未知';
$statusClass = '';
switch ($actualStatus) {
case ACTIVITY_STATUS::NOT_STARTED->value:
$statusClass = 'default';
break;
case ACTIVITY_STATUS::IN_PROGRESS->value:
$statusClass = 'success';
break;
case ACTIVITY_STATUS::ENDED->value:
$statusClass = 'warning';
break;
case ACTIVITY_STATUS::CLOSED->value:
$statusClass = 'danger';
break;
}
$html = "{$statusText}";
// 如果实际状态与数据库状态不同,添加提示
if ($actualStatus != $status) {
$html .= " 需更新";
}
return $html;
});
}
/**
* 添加活动参与人数列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnParticipantCount(string $field = 'id', string $label = '参与人数'): Column
{
return $this->grid->column($field, $label)->display(function ($id) {
return \App\Module\Activity\Models\ActivityParticipation::where('activity_id', $id)->count();
});
}
/**
* 添加活动完成人数列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnCompletedCount(string $field = 'id', string $label = '完成人数'): Column
{
return $this->grid->column($field, $label)->display(function ($id) {
return \App\Module\Activity\Models\ActivityParticipation::where('activity_id', $id)
->where('completion_status', PARTICIPATION_STATUS::COMPLETED->value)
->count();
});
}
/**
* 添加活动奖励领取人数列
*
* @param string $field 字段名
* @param string $label 标签名
* @return Column
*/
public function columnRewardClaimedCount(string $field = 'id', string $label = '奖励领取人数'): Column
{
return $this->grid->column($field, $label)->display(function ($id) {
return \App\Module\Activity\Models\ActivityParticipation::where('activity_id', $id)
->where('reward_status', REWARD_STATUS::CLAIMED->value)
->count();
});
}
}