package com.talentcard.server.mapper;

import java.util.List;
import java.util.Map;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.talentcard.server.entity.MerchantDisplayPolicyMerchant;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface DisplayServiceMapper extends BaseMapper<MerchantDisplayPolicyMerchant> {

    @Select("""
            <script>
            select m.id as merchantId,
                   m.merchant_name as merchantName,
                   case
                     when m.merchant_type = 'parking' then 'parking'
                     when m.merchant_type = 'medical' then 'medical'
                     when m.merchant_type = 'apartment' then 'apartment'
                     when exists (select 1 from shopping_topic_merchant s1 where s1.merchant_id = m.id and s1.deleted = 0 and s1.category_key = 'housing') then 'housing'
                     when exists (select 1 from shopping_topic_merchant s2 where s2.merchant_id = m.id and s2.deleted = 0 and s2.category_key = 'car') then 'car'
                     when exists (select 1 from shopping_topic_merchant s3 where s3.merchant_id = m.id and s3.deleted = 0 and s3.category_key = 'appliance') then 'appliance'
                     else m.merchant_type
                   end as category,
                   m.merchant_type as merchantType,
                   m.contact_name as contactName,
                   m.contact_mobile as contactMobile,
                   m.logo_url as logoUrl,
                   m.cover_url as coverUrl,
                   m.address,
                   m.business_status as businessStatus,
                   m.longitude,
                   m.latitude,
                   m.usage_instructions as handlingInstructions,
                   m.rights_text as rightsText,
                   m.service_label as serviceLabel,
                   m.is_recommend as recommend,
                   m.sort_no as sortNo,
                   m.status,
                   (select count(*) from merchant_card_benefit b where b.merchant_id = m.id) as policyCount,
                   m.created_at as createdAt,
                   m.updated_at as updatedAt
            from merchant m
            where m.deleted = 0
              and (
                    m.merchant_type in ('parking', 'medical', 'apartment')
                    or exists (
                        select 1
                        from shopping_topic_merchant sm
                        where sm.merchant_id = m.id
                          and sm.deleted = 0
                          and sm.category_key in ('housing', 'car', 'appliance')
                    )
                  )
              <if test="category != null and category != ''">
                <choose>
                  <when test="category == 'housing' or category == 'car' or category == 'appliance'">
                    and m.merchant_type = 'shopping'
                    and exists (
                        select 1
                        from shopping_topic_merchant sm
                        where sm.merchant_id = m.id
                          and sm.deleted = 0
                          and sm.category_key = #{category}
                    )
                  </when>
                  <otherwise>
                    and m.merchant_type = #{category}
                  </otherwise>
                </choose>
              </if>
              <if test="status != null">and m.status = #{status}</if>
              <if test="keyword != null and keyword != ''">
                and (m.merchant_name like concat('%', #{keyword}, '%')
                     or m.contact_mobile like concat('%', #{keyword}, '%')
                     or m.address like concat('%', #{keyword}, '%'))
              </if>
            order by m.sort_no desc, m.id desc
            limit #{size} offset #{offset}
            </script>
            """)
    List<Map<String, Object>> selectAdminPage(@Param("category") String category,
                                              @Param("keyword") String keyword,
                                              @Param("status") Integer status,
                                              @Param("size") int size,
                                              @Param("offset") int offset);

    @Select("""
            <script>
            select count(*)
            from merchant m
            where m.deleted = 0
              and (
                    m.merchant_type in ('parking', 'medical', 'apartment')
                    or exists (
                        select 1
                        from shopping_topic_merchant sm
                        where sm.merchant_id = m.id
                          and sm.deleted = 0
                          and sm.category_key in ('housing', 'car', 'appliance')
                    )
                  )
              <if test="category != null and category != ''">
                <choose>
                  <when test="category == 'housing' or category == 'car' or category == 'appliance'">
                    and m.merchant_type = 'shopping'
                    and exists (
                        select 1
                        from shopping_topic_merchant sm
                        where sm.merchant_id = m.id
                          and sm.deleted = 0
                          and sm.category_key = #{category}
                    )
                  </when>
                  <otherwise>
                    and m.merchant_type = #{category}
                  </otherwise>
                </choose>
              </if>
              <if test="status != null">and m.status = #{status}</if>
              <if test="keyword != null and keyword != ''">
                and (m.merchant_name like concat('%', #{keyword}, '%')
                     or m.contact_mobile like concat('%', #{keyword}, '%')
                     or m.address like concat('%', #{keyword}, '%'))
              </if>
            </script>
            """)
    Long countAdminPage(@Param("category") String category,
                        @Param("keyword") String keyword,
                        @Param("status") Integer status);

    @Select("""
            <script>
            select m.id as merchantId,
                   m.merchant_name as merchantName,
                   case
                     when m.merchant_type = 'parking' then 'parking'
                     when m.merchant_type = 'medical' then 'medical'
                     when m.merchant_type = 'apartment' then 'apartment'
                     when exists (select 1 from shopping_topic_merchant s1 where s1.merchant_id = m.id and s1.deleted = 0 and s1.category_key = 'housing') then 'housing'
                     when exists (select 1 from shopping_topic_merchant s2 where s2.merchant_id = m.id and s2.deleted = 0 and s2.category_key = 'car') then 'car'
                     when exists (select 1 from shopping_topic_merchant s3 where s3.merchant_id = m.id and s3.deleted = 0 and s3.category_key = 'appliance') then 'appliance'
                     else m.merchant_type
                   end as category,
                   m.merchant_type as merchantType,
                   m.contact_name as contactName,
                   m.contact_mobile as contactMobile,
                   m.logo_url as logoUrl,
                   m.cover_url as coverUrl,
                   m.address,
                   m.business_status as businessStatus,
                   m.longitude,
                   m.latitude,
                   m.usage_instructions as handlingInstructions,
                   m.rights_text as rightsText,
                   m.service_label as serviceLabel,
                   m.is_recommend as recommend,
                   m.sort_no as sortNo,
                   m.status,
                   (select count(*) from merchant_card_benefit b where b.merchant_id = m.id) as policyCount,
                   m.created_at as createdAt,
                   m.updated_at as updatedAt
            from merchant m
            where m.deleted = 0
              and m.id = #{serviceId}
              and (
                    m.merchant_type in ('parking', 'medical', 'apartment')
                    or exists (
                        select 1
                        from shopping_topic_merchant sm
                        where sm.merchant_id = m.id
                          and sm.deleted = 0
                          and sm.category_key in ('housing', 'car', 'appliance')
                    )
                  )
            limit 1
            </script>
            """)
    Map<String, Object> selectAdminDetail(@Param("serviceId") Long serviceId);
}