package com.fzzy.api.view.pr;

import com.bstek.dorado.annotation.DataProvider;
import com.bstek.dorado.annotation.DataResolver;
import com.bstek.dorado.annotation.Expose;

import com.bstek.dorado.data.provider.Page;
import com.fzzy.api.entity.ApiComData;
import com.fzzy.api.utils.ContextUtil;
import com.fzzy.api.view.repository.ApiComDataRep;

import lombok.extern.slf4j.Slf4j;

import org.apache.commons.lang.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.stereotype.Component;

import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * @Desc: 通用接口数据表 管理入口
 * @author: Andy
 * @update-time: 2022/10/8
 */
@Slf4j
@Component
public class ApiComDataPR {

    @Autowired
    private ApiComDataRep rep;

    /**
     * apiComDataPR#listAll
     *
     * @return
     */
    @DataProvider
    public List<ApiComData> listAll() {
        return rep.findAll();
    }

    /**
     * apiComDataPR#updateSave
     *
     * @param entity
     */
    @DataResolver
    public void updateSave(ApiComData entity) {
        // 手动将doradoEntity对象转换为标准Bean对象
        ApiComData data = new ApiComData();
        BeanUtils.copyProperties(entity, data);
        rep.save(data);
    }

    /**
     * apiComDataPR#delData
     *
     * @param data
     */
    @Expose
    public String delData(ApiComData data) {

        rep.deleteById(data.getId());

        return null;
    }

    /**
     * apiComDataPR#pageList
     *
     * @return
     */
    @SuppressWarnings("serial")
    @DataProvider
    public void pageList(Page<ApiComData> page, Map<String, Object> param) {
        //多参数分页查询
        Pageable pageable = PageRequest.of(page.getPageNo() - 1, page.getPageSize(), Sort.Direction.DESC, "uploadTime");

        if (null == param) {
            org.springframework.data.domain.Page<ApiComData> japPage = rep.findAll(pageable);
            page.setEntityCount((int) japPage.getTotalElements());
            page.setEntities(japPage.getContent());

            return;
        }

        Specification<ApiComData> specification = new Specification<ApiComData>() {
            public Predicate toPredicate(Root<ApiComData> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
                List<Predicate> predicates = new ArrayList<Predicate>(); //所有的断言

                String str = (String) param.get("kqdm");
                if (StringUtils.isNotBlank(str)) {
                    Predicate predicate1 = cb.equal(root.get("kqdm"), str);
                    predicates.add(predicate1);
                }
                str = (String) param.get("inteId");
                if (StringUtils.isNotBlank(str)) {
                    Predicate predicate2 = cb.equal(root.get("inteId"), str);
                    predicates.add(predicate2);
                }

                Date start = (Date) param.get("start");
                if (null != start) {
                    Predicate predicate3 = cb.greaterThan(root.<Date>get("uploadTime"), ContextUtil.getCurZero(start));
                    predicates.add(predicate3);
                }
                Date end = (Date) param.get("end");
                if (null != end) {
                    Predicate predicate4 = cb.lessThan(root.<Date>get("uploadTime"), ContextUtil.getNextZero(end));
                    predicates.add(predicate4);
                }

                return cb.and(predicates.toArray(new Predicate[0]));
            }
        };

        log.debug("---------分页参数查询----------{}", param.toString());
        org.springframework.data.domain.Page<ApiComData> japPage = rep.findAll(specification, pageable);
        page.setEntityCount((int) japPage.getTotalElements());
        page.setEntities(japPage.getContent());
    }

}