/*
 *
 *  * | Licensed 未经许可不能去掉「OPENIITA」相关版权
 *  * +----------------------------------------------------------------------
 *  * | Author: xw2sy@163.com
 *  * +----------------------------------------------------------------------
 *
 *  Copyright [2024] [OPENIITA]
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 * /
 */

package cc.iotkit.data.service;

import cc.iotkit.common.api.PageRequest;
import cc.iotkit.common.api.Paging;
import cc.iotkit.common.utils.MapstructUtils;
import cc.iotkit.common.utils.StringUtils;
import cc.iotkit.data.dao.IJPACommData;
import cc.iotkit.data.dao.SysPostRepository;
import cc.iotkit.data.model.TbSysPost;
import cc.iotkit.data.system.ISysPostData;
import cc.iotkit.data.util.PageBuilder;
import cc.iotkit.data.util.PredicateBuilder;
import cc.iotkit.model.system.SysPost;
import com.querydsl.core.types.Predicate;
import com.querydsl.jpa.impl.JPAQueryFactory;
import lombok.RequiredArgsConstructor;
import org.springframework.context.annotation.Primary;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Objects;

import static cc.iotkit.data.model.QTbSysPost.tbSysPost;
import static cc.iotkit.data.model.QTbSysUser.tbSysUser;
import static cc.iotkit.data.model.QTbSysUserPost.tbSysUserPost;

/**
 * @Author：tfd
 * @Date：2023/5/30 18:20
 */
@Primary
@Service
@RequiredArgsConstructor
public class SysPostDataImpl implements ISysPostData, IJPACommData<SysPost, Long> {

    private final SysPostRepository postRepository;


    private final JPAQueryFactory jpaQueryFactory;

    @Override
    public JpaRepository getBaseRepository() {
        return postRepository;
    }

    @Override
    public Class getJpaRepositoryClass() {
        return TbSysPost.class;
    }

    @Override
    public Class getTClass() {
        return SysPost.class;
    }

    @Override
    public Paging<SysPost> findAll(PageRequest<SysPost> pageRequest) {
        return PageBuilder.toPaging(
                postRepository.findAll(
                        buildQueryCondition(pageRequest.getData()), PageBuilder.toPageable(pageRequest))
                , SysPost.class
        );
    }

    @Override
    public List<Long> selectPostListByUserId(Long userId) {
        return jpaQueryFactory.select(tbSysPost.id)
                .from(tbSysPost)
                .leftJoin(tbSysUserPost).on(tbSysUserPost.postId.eq(tbSysPost.id))
                .leftJoin(tbSysUser).on(tbSysUser.id.eq(tbSysUserPost.userId))
                .where(PredicateBuilder.instance()
                        .and(tbSysUser.id.eq(userId))
                        .build()).fetch();
    }

    @Override
    public List<SysPost> selectPostList(SysPost post) {
        List<TbSysPost> ret = jpaQueryFactory.selectFrom(tbSysPost).where(buildQueryCondition(post))
                .orderBy(tbSysPost.postSort.asc()).fetch();
        return MapstructUtils.convert(ret, SysPost.class);
    }

    @Override
    public boolean checkPostNameUnique(SysPost post) {
        final TbSysPost ret = jpaQueryFactory.selectFrom(tbSysPost)
                .where(PredicateBuilder.instance()
                        .and(tbSysPost.postName.eq(post.getPostName()))
                        .and(Objects.nonNull(post.getId()), () -> tbSysPost.id.eq(post.getId()))
                        .build()).fetchOne();
        return Objects.isNull(ret);
    }

    @Override
    public boolean checkPostCodeUnique(SysPost post) {
        final TbSysPost ret = jpaQueryFactory.selectFrom(tbSysPost)
                .where(PredicateBuilder.instance()
                        .and(tbSysPost.postCode.eq(post.getPostCode()))
                        .and(Objects.nonNull(post.getId()), () -> tbSysPost.id.eq(post.getId()))
                        .build()).fetchOne();
        return Objects.isNull(ret);
    }

    private Predicate buildQueryCondition(SysPost post) {
        return PredicateBuilder.instance()
                .and(StringUtils.isNotBlank(post.getPostCode()), () -> tbSysPost.postCode.like(post.getPostCode()))
                .and(StringUtils.isNotBlank(post.getPostName()), () -> tbSysPost.postName.like(post.getPostName()))
                .and(StringUtils.isNotBlank(post.getStatus()), () -> tbSysPost.status.eq(post.getStatus())).build();
    }
}
