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);
|
}
|
|
|
}
|
