package com.web.kanban.service.internal;

import com.app.base.data.ApiResponseResult;
import com.web.kanban.service.GltKanbanService;
import com.web.kanban.service.HgKanbanService;
import org.apache.camel.api.management.ManagedOperation;
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.*;

@Service(value = "GltKanbanService")
@Transactional(propagation = Propagation.REQUIRED)
public class GltKanbanlmpl extends GltReportPrcUtils implements GltKanbanService {

	/**
	 * 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
	 * @throws Exception
	 */
	@Override
	public ApiResponseResult getWarehouse(PageRequest pageRequest) throws Exception {
		List<Object> list = getWarehouseKanban("Prc_Kb_Depots");
		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));

		List li=(List)list.get(2);
		List lt= new ArrayList();
		for (Object o : li) {
			Map str= (Map) o;
			Iterator<String> iter = str.keySet().iterator();
			while(iter.hasNext()){
				Map map1=new HashMap();
				String key=iter.next();
				String value = (String) str.get(key);
				map1.put("name",key);
				map1.put("num",value);
				System.out.println(key+" "+value);
				lt.add(map1);
			}
		}
		map.put("list2", lt);
		map.put("list3", list.get(3));
		map.put("list4", list.get(4));
		map.put("list5", list.get(5));
		System.out.println(map);
		return ApiResponseResult.success().data(map);
	}


}