package com.nanometer.smartlab.controller;
|
|
import java.io.InputStream;
|
import java.math.BigDecimal;
|
import java.util.*;
|
|
import javax.annotation.Resource;
|
|
import com.nanometer.smartlab.entity.BaseMeta;
|
import com.nanometer.smartlab.entity.SysLaboratory;
|
import com.nanometer.smartlab.service.*;
|
import org.apache.commons.lang.StringUtils;
|
import org.apache.log4j.Logger;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.apache.poi.ss.usermodel.Row;
|
import org.apache.poi.ss.usermodel.Sheet;
|
import org.apache.poi.ss.usermodel.Workbook;
|
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
|
import org.primefaces.context.RequestContext;
|
import org.primefaces.event.FileUploadEvent;
|
import org.primefaces.model.LazyDataModel;
|
import org.primefaces.model.SortOrder;
|
import org.primefaces.model.UploadedFile;
|
import org.springframework.context.annotation.Scope;
|
import org.springframework.stereotype.Controller;
|
|
import com.nanometer.smartlab.entity.SysController;
|
import com.nanometer.smartlab.entity.SysLaboratoryContainer;
|
import com.nanometer.smartlab.util.Constants;
|
import com.nanometer.smartlab.util.FacesUtils;
|
|
/**
|
* Created by cmower on 17/11/20.
|
*/
|
@Controller
|
@Scope("session")
|
public class LaboratoryContainerMngController extends BaseController {
|
|
private static final long serialVersionUID = 101543880938627455L;
|
|
private static Logger logger = Logger.getLogger(LaboratoryContainerMngController.class);
|
|
@Resource
|
private SysLaboratoryContainerService sysLaboratoryContainerService;
|
|
@Resource
|
private SysControllerService sysControllerService;
|
@Resource
|
private BaseMetaService baseMetaService;
|
@Resource
|
private SysLaboratoryService sysLaboratoryService;
|
@Resource
|
private SysProjectService sysProjectService;
|
/**
|
* 数据源
|
*/
|
private LazyDataModel<SysLaboratoryContainer> dataModel;
|
/**
|
* 数据模型
|
*/
|
private SysLaboratoryContainer sysLaboratoryContainer=new SysLaboratoryContainer();
|
/**
|
* 选中的list
|
*/
|
private List<SysLaboratoryContainer> selectedList;
|
|
private List<SysController> controllers;
|
|
private String laboratoryType;
|
private String laboratoryName;
|
private String project;
|
private String controllerName;
|
|
private int action;
|
|
/** 左右门危险性质显示Flag */
|
private int characterRenderedFlag;
|
|
public void onNewBtnClick() {
|
|
if (this.selectedList == null || this.selectedList.size() == 0) {
|
this.sysLaboratoryContainer = new SysLaboratoryContainer();
|
this.action = Constants.ACTION_ADD;
|
this.setCharacterRenderedFlag(0);
|
RequestContext.getCurrentInstance().execute("PF('dialog').show()");
|
}
|
if (this.selectedList.size() == 1) {
|
this.sysLaboratoryContainer = this.sysLaboratoryContainerService
|
.getSysLaboratoryContainer(this.selectedList.get(0).getId());
|
if(this.baseMetaService.getBaseMetaKey(this.sysLaboratoryContainer.getType()).equals("200")) {
|
// 智能柜时，左右门危险性质可配置
|
this.setCharacterRenderedFlag(1);
|
}else {
|
this.setCharacterRenderedFlag(0);
|
this.sysLaboratoryContainer.setCharacterLeft(null);
|
this.sysLaboratoryContainer.setCharacterRight(null);
|
}
|
this.sysLaboratoryContainer.setId(null);
|
this.action = Constants.ACTION_ADD;
|
this.setCharacterRenderedFlag(0);
|
RequestContext.getCurrentInstance().execute("PF('dialog').show()");
|
}
|
if (this.selectedList.size() > 1) {
|
FacesUtils.warn("不允许选择两条和两条以上的数据。");
|
return;
|
}
|
//this.sysLaboratoryContainer = new SysLaboratoryContainer();
|
|
}
|
|
public void onEditBtnClick() {
|
if (this.selectedList == null || this.selectedList.size() == 0) {
|
FacesUtils.warn("请选择数据。");
|
return;
|
}
|
if (this.selectedList.size() > 1) {
|
FacesUtils.warn("只能选择一个数据进行修改。");
|
return;
|
}
|
this.sysLaboratoryContainer = this.sysLaboratoryContainerService
|
.getSysLaboratoryContainer(this.selectedList.get(0).getId());
|
this.action = Constants.ACTION_EDIT;
|
|
if(this.baseMetaService.getBaseMetaKey(this.sysLaboratoryContainer.getType()).equals("200")) {
|
// 智能柜时，左右门危险性质可配置
|
this.setCharacterRenderedFlag(1);
|
}else {
|
this.setCharacterRenderedFlag(0);
|
this.sysLaboratoryContainer.setCharacterLeft(null);
|
this.sysLaboratoryContainer.setCharacterRight(null);
|
}
|
System.out.println(this.sysLaboratoryContainer.getControllerCode());
|
RequestContext.getCurrentInstance().execute("PF('dialog').show()");
|
}
|
|
public void onSaveBtnClick() {
|
try {
|
|
// 新建
|
if (this.action == Constants.ACTION_ADD) {
|
if (this.sysLaboratoryContainer == null) {
|
FacesUtils.warn("新建对象为空。");
|
return;
|
}
|
|
boolean inputCheckFlag = false;
|
|
if(this.sysLaboratoryContainer.getContainerCode()==null || this.sysLaboratoryContainer.getContainerCode().equals("")) {
|
FacesUtils.error("请输入临时存储库条码", "请输入临时存储库条码");
|
inputCheckFlag = true;
|
}
|
|
if(this.sysLaboratoryContainer.getInfoCode()==null || this.sysLaboratoryContainer.getInfoCode().equals("")) {
|
FacesUtils.error("请输入临时存储库状态码", "请输入临时存储库状态码");
|
inputCheckFlag = true;
|
}
|
|
if(this.sysLaboratoryContainer.getName()==null || this.sysLaboratoryContainer.getName().equals("")) {
|
FacesUtils.error("请输入临时存储库名称", "请输入临时存储库名称");
|
inputCheckFlag = true;
|
}
|
|
if(inputCheckFlag) {
|
return;
|
}
|
|
if (this.sysLaboratoryContainerService
|
.isSysLaboratoryContainerExist(this.sysLaboratoryContainer.getContainerCode(), null)) {
|
FacesUtils.warn("临时存储库条码已存在。");
|
return;
|
}
|
System.out.println(sysLaboratoryContainer.getContainerCode());
|
|
this.sysLaboratoryContainerService.insertSysLaboratoryContainer(sysLaboratoryContainer);
|
|
FacesUtils.info("新建成功。");
|
RequestContext.getCurrentInstance().execute("PF('dialog').hide()");
|
// 修改
|
} else if (this.action == Constants.ACTION_EDIT) {
|
if (this.sysLaboratoryContainer == null) {
|
FacesUtils.warn("修改对象为空。");
|
return;
|
}
|
|
boolean inputCheckFlag = false;
|
|
if(this.sysLaboratoryContainer.getContainerCode()==null || this.sysLaboratoryContainer.getContainerCode().equals("")) {
|
FacesUtils.error("请输入临时存储库条码", "请输入临时存储库条码");
|
inputCheckFlag = true;
|
}
|
|
if(this.sysLaboratoryContainer.getInfoCode()==null || this.sysLaboratoryContainer.getInfoCode().equals("")) {
|
FacesUtils.error("请输入临时存储库状态码", "请输入临时存储库状态码");
|
inputCheckFlag = true;
|
}
|
|
if(this.sysLaboratoryContainer.getName()==null || this.sysLaboratoryContainer.getName().equals("")) {
|
FacesUtils.error("请输入临时存储库名称", "请输入临时存储库名称");
|
inputCheckFlag = true;
|
}
|
|
if(inputCheckFlag) {
|
return;
|
}
|
|
if (this.sysLaboratoryContainerService.isSysLaboratoryContainerExist(
|
this.sysLaboratoryContainer.getContainerCode(), this.sysLaboratoryContainer.getId())) {
|
FacesUtils.warn("临时存储库条码已存在。");
|
return;
|
}
|
|
// sysLaboratoryContainer.setProject(null);
|
// sysLaboratoryContainer.getProject();
|
|
this.sysLaboratoryContainerService.updateSysLaboratoryContainer(sysLaboratoryContainer);
|
|
FacesUtils.info("修改成功。");
|
RequestContext.getCurrentInstance().execute("PF('dialog').hide()");
|
}
|
} catch (Exception e) {
|
logger.error("操作失败。", e);
|
FacesUtils.warn("操作失败。");
|
}
|
}
|
|
public void export2Excel(){
|
|
try {
|
List<Map> list = sysLaboratoryContainerService.exportExcelList(laboratoryType, laboratoryName,project,controllerName);
|
sysLaboratoryContainerService.export2Excel(list);
|
}catch (Exception e){
|
e.printStackTrace();
|
FacesUtils.warn("导出失败");
|
}
|
}
|
|
public void uploadFile(FileUploadEvent event) {
|
System.out.println("=========导入开始=====");
|
List<BaseMeta> typeList=baseMetaService.getBaseMetaList("container_type");
|
List<BaseMeta> struList=baseMetaService.getBaseMetaList("container_structure");
|
List<BaseMeta> charList=baseMetaService.getBaseMetaList("reagent_character");
|
List<SysLaboratory> sysLaboratories=sysLaboratoryService.getAllSysLaboratoryList();
|
List<SysController> sysControllers=sysControllerService.getAllControllerList();
|
try{
|
UploadedFile file = event.getFile();
|
InputStream is=file.getInputstream();
|
boolean isExcel2003=true;
|
if (file.getFileName().matches("^.+\\.(?i)(xlsx)$")) {
|
isExcel2003 = false;
|
}
|
Workbook wb=null;
|
if(isExcel2003) {
|
wb = new HSSFWorkbook(is);
|
}else{
|
wb = new XSSFWorkbook(is);
|
}
|
Sheet sheet=wb.getSheetAt(0);
|
List<SysLaboratoryContainer> sysLaboratoryContainers = new ArrayList<>();
|
int totalRows = sheet.getPhysicalNumberOfRows();
|
Row row=null;
|
int totalCells=0;
|
for (int i = 1; i < totalRows; i++) {
|
List<String> valuesList=new ArrayList<String>();
|
row=sheet.getRow(i);
|
|
totalCells= row.getPhysicalNumberOfCells();
|
//System.out.println("====="+totalCells);
|
|
// 目前导入文件11列，不满足条件的情况跳过
|
/*if (totalCells != 12) {
|
throw new Exception("导入文件格式不正确");
|
}*/
|
|
for (int t = 0; t < totalCells; t++) {
|
String cellInfo="";
|
if (row.getCell(t) != null) {
|
|
if (row.getCell(t).getCellTypeEnum().toString().equals("NUMERIC")) {
|
cellInfo = String.valueOf(row.getCell(t).getNumericCellValue());
|
if(t==2){
|
cellInfo=new BigDecimal(Double.valueOf(row.getCell(t).getNumericCellValue())).toString();
|
}
|
if(t==4){
|
cellInfo=new BigDecimal(Double.valueOf(row.getCell(t).getNumericCellValue())).toString();
|
}
|
} else {
|
cellInfo = row.getCell(t).getStringCellValue();
|
}
|
|
}
|
valuesList.add(cellInfo);
|
}
|
if (valuesList.size() != 10){
|
break;
|
}
|
System.out.println("value : "+valuesList);
|
SysLaboratoryContainer sysLaboratoryContainer=new SysLaboratoryContainer();
|
sysLaboratoryContainer.setLaboratoryId(getLabId(sysLaboratories,valuesList.get(0)));
|
if (!valuesList.get(1).replace(" ","").isEmpty()){
|
List<String> projects = Arrays.asList(valuesList.get(1).split(","));
|
for (String project : projects) {
|
//不存再就直接推出
|
if (!sysProjectService.isExistProject(project)) {
|
throw new Exception("课题组不存在,（" + i + "行）");
|
}
|
}
|
//都存在就设置
|
sysLaboratoryContainer.setProject(valuesList.get(1).replace(" ",""));
|
}else{
|
sysLaboratoryContainer.setProject(null);
|
}
|
sysLaboratoryContainer.setControllerCode(getConCode(sysControllers,valuesList.get(2)));
|
sysLaboratoryContainer.setContainerCode(valuesList.get(3));
|
sysLaboratoryContainer.setType(getBaseMetaId(typeList,valuesList.get(4)));
|
sysLaboratoryContainer.setInfoCode(valuesList.get(5));
|
sysLaboratoryContainer.setStructure(getBaseMetaId(struList,valuesList.get(6)));
|
sysLaboratoryContainer.setName(valuesList.get(7));
|
if(valuesList.get(4).equals("智能柜")){
|
sysLaboratoryContainer.setCharacterLeft(getBaseMetaId(charList,valuesList.get(8)));
|
sysLaboratoryContainer.setCharacterRight(getBaseMetaId(charList,valuesList.get(9)));
|
}
|
sysLaboratoryContainers.add(sysLaboratoryContainer);
|
}
|
sysLaboratoryContainerService.insertSysReagentList(sysLaboratoryContainers);
|
FacesUtils.info("导入成功。");
|
}catch (Exception ex){
|
ex.printStackTrace();
|
FacesUtils.info("导入失败。");
|
}
|
}
|
|
public Long getBaseMetaId(List<BaseMeta> list,String name){
|
Long id=null;
|
for(int i=0;i<list.size();i++){
|
if(name.equals(list.get(i).getMetaValue())){
|
id=list.get(i).getId();
|
}
|
}
|
return id;
|
}
|
|
public Long getLabId(List<SysLaboratory> list,String name){
|
Long id=null;
|
for(int i=0;i<list.size();i++){
|
if(list.get(i).getName().equals(name)){
|
id=list.get(i).getId();
|
}
|
}
|
return id;
|
}
|
|
public String getConCode(List<SysController> list,String name){
|
String id="";
|
for(int i=0;i<list.size();i++){
|
if(list.get(i).getControllerName().equals(name)){
|
id=list.get(i).getControllerCode();
|
}
|
}
|
return id;
|
|
}
|
|
public void onDeleteBtnClick() {
|
try {
|
if (this.selectedList == null || this.selectedList.size() == 0) {
|
FacesUtils.warn("请选择数据。");
|
return;
|
}
|
|
this.sysLaboratoryContainerService.deleteSysLaboratoryContainer(this.selectedList);
|
|
FacesUtils.info("删除成功。");
|
} catch (Exception e) {
|
logger.error("操作失败。", e);
|
FacesUtils.warn("操作失败。");
|
}
|
}
|
|
public void containerTypeChanged() {
|
|
if(this.baseMetaService.getBaseMetaKey(this.sysLaboratoryContainer.getType()).equals("200")) {
|
// 智能柜时，左右门危险性质可配置
|
this.setCharacterRenderedFlag(1);
|
}else {
|
this.setCharacterRenderedFlag(0);
|
this.sysLaboratoryContainer.setCharacterLeft(null);
|
this.sysLaboratoryContainer.setCharacterRight(null);
|
}
|
}
|
|
@SuppressWarnings("serial")
|
public LazyDataModel<SysLaboratoryContainer> getDataModel() {
|
if (this.dataModel == null) {
|
this.dataModel = new LazyDataModel<SysLaboratoryContainer>() {
|
@Override
|
public List<SysLaboratoryContainer> load(int first, int pageSize, String sortField, SortOrder sortOrder,
|
Map<String, Object> filters) {
|
List<SysLaboratoryContainer> list = null;
|
try {
|
int count = sysLaboratoryContainerService.getSysLaboratoryContainerTotalCount(laboratoryType,
|
laboratoryName,null,project);
|
this.setRowCount(count);
|
if (count > 0) {
|
list = sysLaboratoryContainerService.getSysLaboratoryContainerList(laboratoryType,
|
laboratoryName,null,project, first, pageSize);
|
}
|
selectedList = new ArrayList<> ();
|
} catch (Exception e) {
|
logger.error(e);
|
}
|
return list;
|
}
|
|
@Override
|
public SysLaboratoryContainer getRowData(String rowKey) {
|
// Iterator<SysLaboratoryContainer> iterator = this.iterator();
|
// if (iterator != null) {
|
// SysLaboratoryContainer su = null;
|
// while (iterator.hasNext()) {
|
// su = iterator.next();
|
// if (rowKey.equals(su.getId())) {
|
// return su;
|
// }
|
// }
|
// }
|
Long id=Long.valueOf(rowKey);
|
return sysLaboratoryContainerService.getSysLaboratoryContainer(id);
|
}
|
};
|
}
|
return dataModel;
|
}
|
|
public SysLaboratoryContainer getSysLaboratoryContainer() {
|
return sysLaboratoryContainer;
|
}
|
|
public void setSysLaboratoryContainer(SysLaboratoryContainer sysLaboratoryContainer) {
|
this.sysLaboratoryContainer = sysLaboratoryContainer;
|
}
|
|
public List<SysLaboratoryContainer> getSelectedList() {
|
return selectedList;
|
}
|
|
public void setSelectedList(List<SysLaboratoryContainer> selectedList) {
|
this.selectedList = selectedList;
|
}
|
|
public int getAction() {
|
return action;
|
}
|
|
public String getLaboratoryType() {
|
return laboratoryType;
|
}
|
|
public void setLaboratoryType(String laboratoryType) {
|
this.laboratoryType = laboratoryType;
|
}
|
|
public String getLaboratoryName() {
|
return laboratoryName;
|
}
|
|
public void setLaboratoryName(String laboratoryName) {
|
this.laboratoryName = laboratoryName;
|
}
|
|
public int getCharacterRenderedFlag() {
|
return characterRenderedFlag;
|
}
|
|
public void setCharacterRenderedFlag(int characterRenderedFlag) {
|
this.characterRenderedFlag = characterRenderedFlag;
|
}
|
|
public List<SysController> getControllers() {
|
this.controllers = sysControllerService.getAllControllerList();
|
|
return controllers;
|
}
|
|
public void setControllers(List<SysController> controllers) {
|
this.controllers = controllers;
|
}
|
|
public String getProject() {
|
return project;
|
}
|
|
public void setProject(String project) {
|
this.project = project;
|
}
|
|
public String getControllerName() {
|
return controllerName;
|
}
|
|
public void setControllerName(String controllerName) {
|
this.controllerName = controllerName;
|
}
|
}
|
