package com.ld.igds.check;
|
|
import com.bstek.bdf2.core.orm.hibernate.HibernateDao;
|
import com.ld.igds.check.dto.CheckItemData;
|
import com.ld.igds.check.dto.CheckUpdateResult;
|
import com.ld.igds.check.service.CoreCheckStandardService;
|
import com.ld.igds.models.*;
|
import com.ld.igds.util.ContextUtil;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 检验项 ---- 管理业务
|
*
|
* @author: chen
|
*/
|
@Component(CheckStandardManager.BEAN_ID)
|
public class CheckStandardManager extends HibernateDao {
|
|
public static final String BEAN_ID = "check.checkStandardManager";
|
|
@Autowired
|
private CoreCheckStandardService checkStandardService;
|
|
/**
|
* 根据参数获取化验项列表
|
*
|
* @param checkId
|
* @param companyId
|
* @param foodVariety
|
* @return
|
*/
|
public List<CheckItemData> listCheckItem(String companyId, String checkId,
|
String foodVariety) {
|
if (StringUtils.isEmpty(companyId)) {
|
companyId = ContextUtil.getCompanyId();
|
}
|
|
List<CheckItemData> list = null;
|
if (null != checkId)
|
list = checkStandardService.getCheckItemById(checkId, companyId);
|
|
if (list == null || list.isEmpty()) {
|
list = checkStandardService.getCheckItemByStandard(companyId, checkId, foodVariety);
|
}
|
|
return list;
|
}
|
|
public CheckUpdateResult updateCheckItems(String checkId, String companyId, List<CheckItemData> checkItems) {
|
|
CheckUpdateResult result = new CheckUpdateResult();
|
if (null == checkItems || checkItems.isEmpty()) {
|
return result;
|
}
|
if (StringUtils.isEmpty(companyId)) {
|
companyId = ContextUtil.getCompanyId();
|
}
|
|
for (CheckItemData item : checkItems) {
|
if (null == item.getCheckId()) {
|
item.setCheckId(checkId);
|
}
|
item.setCompanyId(companyId);
|
if (item.getUpperLimit() == null) {
|
item.setUpperLimit(0.0);
|
}
|
|
if (null != item.getDeNum() && item.getDeNum() > 0) {
|
result.setDeSum(result.getDeSum() + item.getDeNum());
|
}
|
if (null != item.getAddNum() && item.getAddNum() > 0) {
|
result.setAddSum(result.getAddSum() + item.getAddNum());
|
}
|
if (null != item.getAddPrice() && item.getAddPrice() > 0) {
|
result.setAddPriceSum(result.getAddPriceSum()
|
+ item.getAddPrice());
|
}
|
if (null != item.getDePrice() && item.getDePrice() > 0) {
|
result.setDePriceSum(result.getDePriceSum() + item.getDePrice());
|
}
|
|
//如果没有外键不执行持久化操作
|
if (null == checkId) return result;
|
|
// 先更新，更新失败则新增
|
int i = checkStandardService.updateCheckItem(item);
|
if (i < 1) {
|
checkStandardService.insertCheckItem(item);
|
}
|
}
|
return result;
|
}
|
|
/************省质检报告检验项**************/
|
|
/**
|
* 大豆
|
* @param param
|
* @return
|
*/
|
public List<CheckItemDd> findDataDd(Map<String, Object> param){
|
String hql = " from " + CheckItemDd.class.getName()
|
+ " where 1 =1";
|
|
Map<String,Object> args = new HashMap<String,Object>();
|
if(null != param){
|
String str = (String) param.get("qlyOrgReportId");
|
if (StringUtils.isNotEmpty(str)) {
|
hql += " and qlyOrgReportId =:qlyOrgReportId";
|
args.put("qlyOrgReportId", str);
|
}
|
}
|
hql += " order by qlyOrgReportSoybeanId";
|
return this.query(hql, args);
|
}
|
|
/**
|
* 大米
|
* @param param
|
* @return
|
*/
|
public List<CheckItemDm> findDataDm(Map<String, Object> param){
|
String hql = " from " + CheckItemDm.class.getName()
|
+ " where 1 =1";
|
|
Map<String,Object> args = new HashMap<String,Object>();
|
if(null != param){
|
String str = (String) param.get("qlyOrgReportId");
|
if (StringUtils.isNotEmpty(str)) {
|
hql += " and qlyOrgReportId =:qlyOrgReportId";
|
args.put("qlyOrgReportId", str);
|
}
|
}
|
hql += " order by qlyOrgReportRiceId";
|
return this.query(hql, args);
|
}
|
|
/**
|
* 大米
|
* @param param
|
* @return
|
*/
|
public List<CheckItemXmf> findDataXmf(Map<String, Object> param){
|
String hql = " from " + CheckItemXmf.class.getName()
|
+ " where 1 =1";
|
|
Map<String,Object> args = new HashMap<String,Object>();
|
if(null != param){
|
String str = (String) param.get("qlyOrgReportId");
|
if (StringUtils.isNotEmpty(str)) {
|
hql += " and qlyOrgReportId =:qlyOrgReportId";
|
args.put("qlyOrgReportId", str);
|
}
|
}
|
hql += " order by qlyOrgReportNoodlesId";
|
return this.query(hql, args);
|
}
|
|
/**
|
* 大米
|
* @param param
|
* @return
|
*/
|
public List<CheckItemSyy> findDataSyy(Map<String, Object> param){
|
String hql = " from " + CheckItemSyy.class.getName()
|
+ " where 1 =1";
|
|
Map<String,Object> args = new HashMap<String,Object>();
|
if(null != param){
|
String str = (String) param.get("qlyOrgReportId");
|
if (StringUtils.isNotEmpty(str)) {
|
hql += " and qlyOrgReportId =:qlyOrgReportId";
|
args.put("qlyOrgReportId", str);
|
}
|
}
|
hql += " order by qlyOrgReportOilId";
|
return this.query(hql, args);
|
}
|
|
}
|
