<?php
namespace app\workerapi\logic;


use Exception;
use think\facade\Db;
use think\facade\Log;
use app\common\logic\BaseLogic;
use app\common\model\user\User;
use app\adminapi\logic\user\UserLogic;
use app\common\model\property\PropertyHead;
use app\common\service\wechat\WeChatMnpService;
use app\common\model\group_activity\GroupActivity;


/**
 * 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 = GroupActivity::alias("a")
            ->leftJoin("group_user_order b","a.id=b.group_activity_id")
            ->where('a.group_category_id',$params['id'])
            ->field([
                'a.id','a.title',
                'SUM(CASE WHEN refund_status = 0 THEN 1 ELSE 0 END) AS pay_count',
                'SUM(CASE WHEN refund_status > 0 THEN 1 ELSE 0 END) AS refund_count'
                ]
            )
            ->group('a.id') 
            ->select()
            ->toArray();
        return $lists;
    }
}