package com.aps.core.mapper;

import java.util.List;
import java.util.Set;

import com.aps.core.domain.ApsShop;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.jetbrains.annotations.NotNull;

/**
 * 车间Mapper接口
 * 
 * @author ruoyi
 * @date 2025-04-14
 */
@Mapper
public interface ApsShopMapper extends BaseMapper<ApsShop>
{
    /**
     * 查询车间
     * 
     * @param id 车间主键
     * @return 车间
     */
    public ApsShop selectApsShopById(String id);

    /**
     * 查询车间列表
     * 
     * @param apsShop 车间
     * @return 车间集合
     */
    public List<ApsShop> selectApsShopList(ApsShop apsShop);

    /**
     * 新增车间
     * 
     * @param apsShop 车间
     * @return 结果
     */
    public int insertApsShop(ApsShop apsShop);

    /**
     * 修改车间
     * 
     * @param apsShop 车间
     * @return 结果
     */
    public int updateApsShop(ApsShop apsShop);

    /**
     * 删除车间
     * 
     * @param id 车间主键
     * @return 结果
     */
    public int deleteApsShopById(String id);

    /**
     * 批量删除车间
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteApsShopByIds(String[] ids);


    @Select("""
        <script>
            select * from aps_shop where 1 = 0
            <if test="!codes.isEmpty()"> or shop_name in
                <foreach collection="names" item="item" open="(" separator="," close=")">
                    #{item}
                </foreach>                                 
            </if> 
        </script>
    """)
    List<ApsShop> selectApsByName(@NotNull Set<String> names);

    @Select("select * from aps_shop where plant_code = #{orgCode}")
    List<ApsShop> selectApsByFactory(String orgCode);

    @Select("""
        <script>
            select * from aps_shop where 1 = 0
            <if test="!codes.isEmpty()"> or shop_code in
                <foreach collection="codes" item="item" open="(" separator="," close=")">
                    #{item}
                </foreach>                                 
            </if> 
        </script>
    """)
    List<ApsShop> selectByCodes(Set<String> codes);
}