package com.web.kanban.service.internal;

import com.app.base.data.ApiResponseResult;
import com.web.kanban.service.HgKanbanService;
import com.web.kanban.service.NingboEveService;
import org.springframework.data.domain.PageRequest;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

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


@Service(value = "NingboEveService")
@Transactional(propagation = Propagation.REQUIRED)
public class NingboEveImpl extends NingboEvePrcUtils implements NingboEveService {



    @Override
    public ApiResponseResult getPRC_APP_KANBAN_NZSDT(PageRequest pageRequest) throws Exception {
        List<Object> list = getPRC_APP_KANBAN_NZSDT_prc("PRC_APP_KANBAN_NZSDT",
                pageRequest.getPageSize(), pageRequest.getPageNumber());
        if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
            return ApiResponseResult.failure(list.get(1).toString());
        }
        Map map = new HashMap();
        map.put("list1", list.get(1));
        map.put("list2", list.get(2));
        map.put("list3", list.get(3));
        map.put("list4", list.get(4));
//        map.put("list5", list.get(5));
        return ApiResponseResult.success().data(map);

    }

    @Override
    public ApiResponseResult getPRC_APP_KANBAN_DYSDT(PageRequest pageRequest) throws Exception {
        List<Object> list = getPRC_APP_KANBAN_DYSDT_prc("PRC_APP_KANBAN_DYSDT",
                pageRequest.getPageSize(), pageRequest.getPageNumber());
        if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
            return ApiResponseResult.failure(list.get(1).toString());
        }
        Map map = new HashMap();
        map.put("list1", list.get(1));
        map.put("list2", list.get(2));
        map.put("list3", list.get(3));
        map.put("list4", list.get(4));
//        map.put("list5", list.get(5));
        return ApiResponseResult.success().data(map);
    }

    @Override
    public ApiResponseResult getPRC_APP_KANBAN_K1SDT(PageRequest pageRequest) throws Exception {
        List<Object> list = getPRC_APP_KANBAN_K1SDT_prc("prc_app_kanban_k1sdt",
                pageRequest.getPageSize(), pageRequest.getPageNumber());
        if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
            return ApiResponseResult.failure(list.get(1).toString());
        }
        Map map = new HashMap();
        map.put("list1", list.get(1));
        map.put("list2", list.get(2));
        map.put("list3", list.get(3));
        map.put("list4", list.get(4));
//        map.put("list5", list.get(5));
        return ApiResponseResult.success().data(map);
    }

    @Override
    public ApiResponseResult getPRC_APP_KANBAN_K2SDT(PageRequest pageRequest) throws Exception {
        List<Object> list = getPRC_APP_KANBAN_K2SDT_prc("PRC_APP_KANBAN_K2SDT",
                pageRequest.getPageSize(), pageRequest.getPageNumber());
        if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
            return ApiResponseResult.failure(list.get(1).toString());
        }
        Map map = new HashMap();
        map.put("list1", list.get(1));
        map.put("list2", list.get(2));
        map.put("list3", list.get(3));
        map.put("list4", list.get(4));
//        map.put("list5", list.get(5));
        return ApiResponseResult.success().data(map);
    }
}