# ShiftDrawerCommentServiceImpl.java

    package cloud.wconnect.frontoffice.service.drawercount.impl;

    import cloud.wconnect.frontoffice.entity.drawercount.ShiftDrawerComment;
    import cloud.wconnect.frontoffice.mapper.drawercount.ShiftDrawerCommentMapper;
    import cloud.wconnect.frontoffice.service.drawercount.IShiftDrawerCommentService;
    import com.baomidou.dynamic.datasource.annotation.DS;
    import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import org.springframework.stereotype.Service;

    import java.util.List;

    /**
     * <p>
     *  服务实现类
     * </p>
     *
     * @author lichen
     * @since 2023-03-27
     */
    @Service
    @DS("ratelog_manage")
    public class ShiftDrawerCommentServiceImpl extends ServiceImpl<ShiftDrawerCommentMapper, ShiftDrawerComment> implements IShiftDrawerCommentService {

        /**
         * 获取抽屉评论列表
         *
         * @param propertyId    资产id
         * @param drawerCountId 抽屉id
         * @return java.util.List<cloud.wconnect.frontoffice.entity.drawercount.ShiftDrawerComment>
         * @author lichen
         * @date 2025/12/29
         */
        @Override
        public List<ShiftDrawerComment> listByDrawerCountId(int propertyId, Integer drawerCountId) {
            LambdaQueryWrapper<ShiftDrawerComment> shiftDrawerCommentLambdaQueryWrapper = new LambdaQueryWrapper<>();
            shiftDrawerCommentLambdaQueryWrapper.eq(ShiftDrawerComment::getPropertyId, propertyId);
            shiftDrawerCommentLambdaQueryWrapper.eq(ShiftDrawerComment::getDrawerCountId, drawerCountId);
            shiftDrawerCommentLambdaQueryWrapper.orderByDesc(ShiftDrawerComment::getId);
            return list(shiftDrawerCommentLambdaQueryWrapper);
        }
    }