<?php
namespace app\workerapi\logic;

use app\common\logic\BaseLogic;
use app\common\model\property\PropertyHead;
use app\common\model\group_activity\GroupOrder;

/**
 * PropertyHead逻辑
 * Class PropertyHeadLogic
 * @package app\adminapi\logic
 */
class PropertyHeadLogic extends BaseLogic
{


    /**
     * @notes 获取详情
     * @param $params
     * @return array
     * @author likeadmin
     * @date 2024/09/19 10:48
     */
    public static function detail($params): array
    {
        return PropertyHead::findOrEmpty($params['id'])->append(['city_text'])->toArray();
    }

    public static function groupActivityDetail($params): array
    {   
        $lists = GroupOrder::alias("a")
            ->leftJoin("group_activity b","a.group_activity_id=b.id")
            ->leftJoin("group_user_order c","a.id=c.group_order_id")
            ->where('a.group_category_id',$params['id'])
            ->field([
                'a.id','a.status','a.num','a.end_time','b.title',
                'SUM(CASE WHEN c.status <> 1 THEN 1 ELSE 0 END) AS refund_num'
                ]
            )
            ->group('a.id') 
            ->select()
            ->toArray();
        return $lists;
    }
}