package com.web.kanban.service.internal;

import com.app.base.data.ApiResponseResult;
import com.utils.UserUtil;
import com.web.kanban.service.HgKanbanService;
import com.web.lytreport.service.LytReportService;
import com.web.lytreport.service.internal.ReportPrcUtils;
import org.springframework.data.domain.PageRequest;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import javax.servlet.http.HttpServletResponse;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service(value = "HgKanbanService")
@Transactional(propagation = Propagation.REQUIRED)
public class HgKanbanlmpl extends HgReportPrcUtils implements HgKanbanService {



	/**
	 * 获取仓库待入库看板报表
	 **/
	public ApiResponseResult getPRC_KB_DEPOTS(PageRequest pageRequest) throws Exception {
		List<Object> list = getPRC_KB_DEPOTS_Prc("Prc_Kb_Depots",
				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);

	}

	/**
	 * iqc看板
	 * @param pageRequest
	 * @return
	 * @throws Exception
	 */
	@Override
	public ApiResponseResult getPRC_KB_IQC(PageRequest pageRequest)throws Exception  {
		List<Object> list = getPRC_KB_IQC_prc("PRC_KB_IQC",
				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);

	}

	/**
	 * 线头看板
	 * @param pageRequest
	 * @return
	 */
	@Override
	public ApiResponseResult getPRC_APP_KANBAN_DATA_DCDC(PageRequest pageRequest) {
		List<Object> list = getPRC_APP_KANBAN_DATA_DCDC_prc("PRC_APP_KANBAN_DATA_DCDC",
				pageRequest.getPageSize(), pageRequest.getPageNumber(),"V21");
		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);
	}

	/**
	 * 获取v24
	 * @param pageRequest
	 * @return
	 */
	@Override
	public ApiResponseResult getV23Kanban(PageRequest pageRequest) {
		List<Object> list = getPRC_APP_KANBAN_DATA_DCDC_prc("PRC_APP_KANBAN_DATA_PCB",
				pageRequest.getPageSize(), pageRequest.getPageNumber(),"V23");
		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);
	}

	/**
	 * 获取v23
	 * @param pageRequest
	 * @return
	 */
	@Override
	public ApiResponseResult getV24Kanban(PageRequest pageRequest) {
		List<Object> list = getPRC_APP_KANBAN_DATA_DCDC_prc("PRC_APP_KANBAN_DATA_PCB",
				pageRequest.getPageSize(), pageRequest.getPageNumber(),"V24");
		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);
	}


	/**
	 * 总看板
	 * @param pageRequest
	 * @return
	 */
	@Override
	public ApiResponseResult getPRC_APP_KANBAN_DATA_ZKB(PageRequest pageRequest) {
		List<Object> list = getPRC_APP_KANBAN_DATA_ZKB_prc("PRC_APP_KANBAN_DATA_ZKB",
				pageRequest.getPageSize(), pageRequest.getPageNumber(),"V21");
		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));
		map.put("list6", list.get(6));
		map.put("list7", list.get(7));
		return ApiResponseResult.success().data(map);
	}


	/**
	 * 总看板v23
	 * @param pageRequest
	 * @return
	 */
	@Override
	public ApiResponseResult getGeneralPanelV23(PageRequest pageRequest) {
		List<Object> list = getPRC_APP_KANBAN_DATA_ZKB_prc("PRC_APP_KANBAN_DATA_ZPCB",
				pageRequest.getPageSize(), pageRequest.getPageNumber(),"V23");
		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));
		map.put("list6", list.get(6));
		map.put("list7", list.get(7));
		return ApiResponseResult.success().data(map);
	}

	/**
	 * 总看板v24
	 * @param pageRequest
	 * @return
	 */
	@Override
	public ApiResponseResult getGeneralPanelV24(PageRequest pageRequest) {
		List<Object> list = getPRC_APP_KANBAN_DATA_ZKB_prc("PRC_APP_KANBAN_DATA_ZPCB",
				pageRequest.getPageSize(), pageRequest.getPageNumber(),"V24");
		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));
		map.put("list6", list.get(6));
		map.put("list7", list.get(7));
		return ApiResponseResult.success().data(map);
	}


}