package com.zbooksoft.gdmis.operate;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.ruili.wcp.common.SpringContextUtil;
|
import com.ruili.wcp.common.StringUtil;
|
import com.ruili.wcp.data.entity.config.View;
|
import com.ruili.wcp.service.config.ViewService;
|
import com.ruili.wcp.web.model.AjaxResponse;
|
import com.ruili.wcp.web.model.ErrorInfo;
|
import com.zbooksoft.gdmis.data.entity.PackingManage;
|
import com.zbooksoft.gdmis.service.CatSmxxService;
|
import com.zbooksoft.gdmis.service.CatYswjxxService;
|
import com.zbooksoft.gdmis.service.PackingManageService;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.jdbc.core.BatchPreparedStatementSetter;
|
import org.springframework.jdbc.core.JdbcTemplate;
|
|
import java.sql.PreparedStatement;
|
import java.sql.SQLException;
|
import java.text.DecimalFormat;
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Description:原始文件信息操作方法
|
* @Author: zhai
|
* @Date: 2024/8/15
|
**/
|
public class CatYswjxxOperate {
|
private static final Logger logger = LoggerFactory.getLogger(CatYswjxxOperate.class);
|
CatYswjxxService catYswjxxService = (CatYswjxxService) SpringContextUtil.getBean("catYswjxxServiceImpl");
|
CatSmxxService catSmxxService = (CatSmxxService) SpringContextUtil.getBean("catSmxxServiceImpl");
|
PackingManageService packingManageService = (PackingManageService) SpringContextUtil.getBean("packingManageServiceImpl");
|
ViewService viewService = (ViewService) SpringContextUtil.getBean("viewServiceImpl");
|
JdbcTemplate jdbcTemplate = (JdbcTemplate) SpringContextUtil.getBean("jdbcTemplate");
|
|
/**
|
* 退回待著录
|
*
|
* @param viewId
|
* @param idList
|
* @return
|
*/
|
public AjaxResponse submitCheck(Long viewId, ArrayList<Long> idList) {
|
|
View view = viewService.getViewById(viewId);
|
int state = 2;
|
String strSql = "update " + view.getMainTableName() + " set yszt = " + state;
|
try {
|
jdbcTemplate.batchUpdate(strSql + " where " + view.getIdField() + "=?", new BatchPreparedStatementSetter() {
|
@Override
|
public void setValues(PreparedStatement ps, int i) throws SQLException {
|
ps.setLong(1, idList.get(i));// 下标从1开始
|
}
|
|
@Override
|
public int getBatchSize() {
|
return idList.size();
|
}
|
});
|
|
return new AjaxResponse(true);
|
} catch (Exception e) {
|
logger.error(e.getMessage(), e);
|
return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
|
}
|
}
|
|
/**
|
* 验收后中数据进行撤回
|
*
|
* @param viewId
|
* @param idList
|
* @return
|
*/
|
public AjaxResponse revocationCheck(Long viewId, ArrayList<Long> idList) {
|
|
View view = viewService.getViewById(viewId);
|
int state = 0;
|
String strSql = "update " + view.getMainTableName() + " set yszt = " + state;
|
try {
|
jdbcTemplate.batchUpdate(strSql + " where " + view.getIdField() + "=?", new BatchPreparedStatementSetter() {
|
@Override
|
public void setValues(PreparedStatement ps, int i) throws SQLException {
|
ps.setLong(1, idList.get(i));// 下标从1开始
|
}
|
|
@Override
|
public int getBatchSize() {
|
return idList.size();
|
}
|
});
|
|
return new AjaxResponse(true);
|
} catch (Exception e) {
|
logger.error(e.getMessage(), e);
|
return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
|
}
|
}
|
|
/**
|
* 是否可借阅
|
*
|
* @param viewId
|
* @param idList
|
* @return
|
*/
|
public AjaxResponse isBorrow(Long viewId, ArrayList<Long> idList) {
|
//纸质借阅状态，0可外借，1不可借出
|
View view = viewService.getViewById(viewId);
|
int state = 1;
|
String strSql = "update " + view.getMainTableName() + " set JYZT = " + state;
|
try {
|
jdbcTemplate.batchUpdate(strSql + " where " + view.getIdField() + "=?", new BatchPreparedStatementSetter() {
|
@Override
|
public void setValues(PreparedStatement ps, int i) throws SQLException {
|
ps.setLong(1, idList.get(i));// 下标从1开始
|
}
|
|
@Override
|
public int getBatchSize() {
|
return idList.size();
|
}
|
});
|
|
return new AjaxResponse(true);
|
} catch (Exception e) {
|
logger.error(e.getMessage(), e);
|
return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
|
}
|
}
|
|
|
/**
|
* 原始文件装盒
|
*
|
* @return
|
*/
|
public AjaxResponse packagingBoxYs(Long viewId, ArrayList<Long> idList) {
|
try {
|
String box = "0001";
|
String maxBoxSql = "select max(box_number) from BUS_PACKING_MANAGE WHERE TYPE = 1";
|
String boxNum = jdbcTemplate.queryForObject(maxBoxSql, String.class);
|
if (boxNum != null || "".equals(boxNum)) {
|
int num = Integer.parseInt(boxNum);
|
num += 1;
|
DecimalFormat df = new DecimalFormat("0000");
|
box = df.format(num);
|
}
|
int newPage = 0;
|
View view = viewService.getViewById(viewId);
|
String mainTableName = view.getMainTableName();
|
for (int i = 0; i < idList.size(); i++) {
|
String selectSql = "select * from " + mainTableName + " where id = " + idList.get(i);
|
Map<String, Object> map = jdbcTemplate.queryForMap(selectSql);
|
String itemNum = StringUtil.nullToEmpty(map.get("DH")).trim();
|
String id = StringUtil.nullToEmpty(map.get("ID")).trim();
|
String ajId = StringUtil.nullToEmpty(map.get("AJ_ID")).trim();
|
QueryWrapper<PackingManage> packingManageQueryWrapper = new QueryWrapper<>();
|
packingManageQueryWrapper.eq("item_id", idList.get(i));
|
PackingManage packingManage = new PackingManage();
|
List<PackingManage> packingManageList = packingManageService.list(packingManageQueryWrapper);
|
if (packingManageList.size() > 0) {
|
packingManage = packingManageList.get(0);
|
}
|
packingManage.setItemId(id);
|
packingManage.setAjId(ajId);
|
packingManage.setCreateTime(new java.util.Date());
|
packingManage.setType(1);
|
String zzys = map.get("ZZYS") == null ? "0" : map.get("ZZYS").toString();
|
if (newPage + Integer.parseInt(zzys) > 500) {
|
int num = Integer.parseInt(box);
|
num += 1;
|
DecimalFormat df = new DecimalFormat("0000");
|
String newBox = df.format(num);
|
box = newBox;
|
newPage = Integer.parseInt(zzys);
|
} else {
|
newPage = newPage + Integer.parseInt(zzys);
|
}
|
packingManage.setItemNum(itemNum + "-" + box);
|
packingManage.setBoxNumber(box);
|
packingManageService.saveOrUpdate(packingManage);
|
String updateSql = "update " + mainTableName + " set HH = '" + box + "' where id = " + idList.get(i);
|
jdbcTemplate.update(updateSql);
|
}
|
return new AjaxResponse(true);
|
} catch (Exception e) {
|
logger.error(e.getMessage(), e);
|
return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
|
}
|
}
|
|
/**
|
* 文件装盒
|
*
|
* @return
|
*/
|
public AjaxResponse packagingBoxCg(Long viewId, ArrayList<Long> idList) {
|
try {
|
//分成果和原始 原始盒子命名规则最大号，成果文件报告号
|
//解析纸张大小， 获取最大盒子号，进行装盒 500页
|
String box = "01";
|
int newPage = 0;
|
View view = viewService.getViewById(viewId);
|
String mainTableName = view.getMainTableName();
|
String selectSqlOne = "select * from " + mainTableName + " where id = " + idList.get(0);
|
Map<String, Object> mapList = jdbcTemplate.queryForMap(selectSqlOne);
|
String sl = mapList.get("SL") == null ? "0" : mapList.get("SL").toString();
|
for (int i = 1; i <= Integer.parseInt(sl); i++) {
|
DecimalFormat df = new DecimalFormat("00");
|
String cover = df.format(i);
|
for (int j = 0; j < idList.size(); j++) {
|
String selectSql = "select * from " + mainTableName + " where id = " + idList.get(j);
|
Map<String, Object> map = jdbcTemplate.queryForMap(selectSql);
|
String zzys = map.get("ZZYS") == null ? "0" : map.get("ZZYS").toString();
|
|
String id = StringUtil.nullToEmpty(map.get("ID")).trim();
|
String dh = StringUtil.nullToEmpty(map.get("DH")).trim();
|
String bgbh = StringUtil.nullToEmpty(map.get("BGBH")).trim();
|
String ajId = StringUtil.nullToEmpty(map.get("AJ_ID")).trim();
|
|
|
PackingManage packingManage = new PackingManage();
|
packingManage.setItemNum(dh + "-" + i);
|
packingManage.setItemId(id);
|
packingManage.setAjId(ajId);
|
packingManage.setType(0);
|
packingManage.setCreateTime(new java.util.Date());
|
|
//计算盒号
|
if (newPage + Integer.parseInt(zzys) > 500) {
|
int num = Integer.parseInt(box);
|
num += 1;
|
String newBox = df.format(num);
|
box = newBox;
|
newPage = Integer.parseInt(zzys);
|
packingManage.setBoxNumber(bgbh + "-" + cover + "-" + newBox);
|
} else {
|
newPage = newPage + Integer.parseInt(zzys);
|
packingManage.setBoxNumber(bgbh + "-" + cover + "-" + box);
|
}
|
packingManageService.saveOrUpdate(packingManage);
|
}
|
|
}
|
|
// for (int i = 0; i < idList.size(); i++) {
|
// String selectSql = "select * from " + mainTableName + " where id = " + idList.get(i);
|
// Map<String, Object> map = jdbcTemplate.queryForMap(selectSql);
|
// String zzys = map.get("ZZYS") == null ? "0" : map.get("ZZYS").toString();
|
// String dh = map.get("DH") == null ? "0" : map.get("DH").toString();
|
// if (newPage + Integer.parseInt(zzys) > 500) {
|
// int num = Integer.parseInt(box);
|
// num += 1;
|
// DecimalFormat df = new DecimalFormat("0000");
|
// String newBox = df.format(num);
|
// box = newBox;
|
// newPage = Integer.parseInt(zzys);
|
// } else {
|
// newPage = newPage + Integer.parseInt(zzys);
|
// }
|
// String updateSql = "update " + mainTableName + " set HH = '" + box + "' where id = " + idList.get(i);
|
// jdbcTemplate.update(updateSql);
|
//
|
//
|
// //查询拆分了几份
|
// QueryWrapper<PackingManage> packingManageQueryWrapper = new QueryWrapper<>();
|
// packingManageQueryWrapper.eq("item_id", idList.get(i));
|
// List<PackingManage> packingManageList = packingManageService.list(packingManageQueryWrapper);
|
// for (int j = 0; j < packingManageList.size(); j++) {
|
// PackingManage packingManage = packingManageList.get(j);
|
// if (newPage + Integer.parseInt(zzys) > 500) {
|
// int num = Integer.parseInt(box);
|
// num += 1;
|
// DecimalFormat df = new DecimalFormat("00");
|
// String newBox = df.format(num);
|
// box = newBox;
|
// newPage = Integer.parseInt(zzys);
|
// packingManage.setBoxNumber(dh + "-" + newBox);
|
// } else {
|
// newPage = newPage + Integer.parseInt(zzys);
|
// packingManage.setBoxNumber(dh + "-" + box);
|
// }
|
// if (j == 0) {
|
// String updateSql = "update " + mainTableName + " set HH = '" + dh + "-" + box + "' where id = " + idList.get(i);
|
// jdbcTemplate.update(updateSql);
|
// }
|
// packingManageService.saveOrUpdate(packingManage);
|
// }
|
// }
|
return new AjaxResponse(true);
|
} catch (Exception e) {
|
logger.error(e.getMessage(), e);
|
return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
|
}
|
}
|
|
/**
|
* 取消发布
|
*
|
* @param viewId
|
* @param idList
|
* @return
|
*/
|
public AjaxResponse createArchiveCode(Long viewId, ArrayList<Long> idList) {
|
try {
|
Long aLong = idList.get(0);
|
String selectSql = "select AJ_ID from CAT_ITEM_YSWJXX where id = " + aLong;
|
Map<String, Object> map = jdbcTemplate.queryForMap(selectSql);
|
Long ajId = map.get("AJ_ID") == null ? 0 : Long.parseLong(map.get("AJ_ID").toString());
|
String sql = "select DH FROM CAT_FILE_AJJXX where id = " + ajId;
|
Map<String, Object> stringObjectMap = jdbcTemplate.queryForMap(sql);
|
String maxDH = stringObjectMap.get("DH") == null ? "" : stringObjectMap.get("DH").toString();
|
for (int i = 0; i < idList.size(); i++) {
|
String sqlSelect = "select JNXH from CAT_ITEM_YSWJXX where id = " + idList.get(i);
|
Map<String, Object> stringObjectMap1 = jdbcTemplate.queryForMap(sqlSelect);
|
String jnxh = stringObjectMap1.get("JNXH") == null ? "" : stringObjectMap1.get("JNXH").toString();
|
String dh = maxDH + "-" + jnxh;
|
String updateSql = "update CAT_ITEM_YSWJXX set DH = '" + dh + "' where ID = " + idList.get(i);
|
jdbcTemplate.update(updateSql);
|
}
|
return new AjaxResponse(true);
|
} catch (Exception e) {
|
logger.error(e.getMessage(), e);
|
return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
|
}
|
}
|
|
}
|
