/**
* @param fullId
* @param productIdSet
* @return
*/
private double sumOutForceBackValue(String fullId, Set<String> productIdSet) {
ConditionParse con = new ConditionParse();
con.addWhereStr();
con.addCondition("OutBean.refOutFullId", "=", fullId);
con.addIntCondition("OutBean.type", "=", OutConstant.OUT_TYPE_INBILL);
con.addCondition("and OutBean.status in (3, 4)");
con.addIntCondition("OutBean.outType", "=", OutConstant.OUTTYPE_IN_OTHER);
// con.addCondition("OutBean.reserve8", "<>", "1");
List<OutBean> refList = outDAO.queryEntityBeansByCondition(con);
double backTotal = 0.0d;
for (OutBean outBean : refList) {
backTotal += outBean.getTotal();
}
double excepTotal = getExceptProductValue(productIdSet, refList);
return backTotal - excepTotal;
}
/*
* (non-Javadoc)
*
* @see com.china.center.oa.product.listener.DepotListener#onDeleteDepot(com.center.china.osgi.publics.User,
* com.china.center.oa.product.bean.DepotBean)
*/
public void onDeleteDepot(User user, DepotBean bean) throws MYException {
ConditionParse con = new ConditionParse();
con.addWhereStr();
con.addCondition("OutBean.location", "=", bean.getId());
if (outDAO.countByCondition(con.toString()) > 0) {
throw new MYException("仓库已经被使用不能删除");
}
}
/** 区别销售与委托代销模式 */
private void processStatsBlackOutDetail() {
blackOutDetailDAO.deleteAllEntityBean();
List<BlackOutBean> outList = blackOutDAO.queryEntityBeansByCondition("where type = 2");
for (BlackOutBean each : outList) {
String outId = each.getOutId();
OutBean out = outDAO.find(outId);
if (out.getPay() == OutConstant.PAY_YES) {
continue;
}
List<BaseBean> baseList = baseDAO.queryEntityBeansByFK(outId);
if (out.getOutType() == OutConstant.OUTTYPE_OUT_CONSIGN) {
// 1.未结算部分
List<OutBalanceBean> obList1 =
outBalanceDAO.queryEntityBeansByCondition(
"where outid = ? and type = 0 and status = 1", outId);
List<OutBalanceBean> obList2 =
outBalanceDAO.queryEntityBeansByCondition(
"where outid = ? and type = 1 and status = 99", outId);
obList2.addAll(obList1);
for (BaseBean base : baseList) {
for (OutBalanceBean balance : obList2) {
List<BaseBalanceBean> bList = baseBalanceDAO.queryEntityBeansByFK(balance.getId());
for (BaseBalanceBean bb : bList) {
if (base.getId().equals(bb.getBaseId())) {
base.setAmount(base.getAmount() - bb.getAmount());
}
}
}
// 将结果写入明细表
saveOutDetail(base);
}
// 2.结算未回款部分
for (OutBalanceBean balance : obList1) {
if (balance.getPayMoney() > 0) continue;
List<BaseBalanceBean> bbList = baseBalanceDAO.queryEntityBeansByFK(balance.getId());
for (BaseBalanceBean eachbb : bbList) {
List<OutBalanceBean> refBalanceList =
outBalanceDAO.queryEntityBeansByCondition(
"where refOutBalanceId = ? and status = 99", balance.getId());
for (OutBalanceBean refb : refBalanceList) {
List<BaseBalanceBean> refbbList = baseBalanceDAO.queryEntityBeansByFK(refb.getId());
for (BaseBalanceBean refbb : refbbList) {
if (eachbb.getBaseId().equals(refbb.getBaseId())) {
eachbb.setAmount(eachbb.getAmount() - refbb.getAmount());
}
}
}
if (eachbb.getAmount() > 0) {
BaseBean base = baseDAO.find(eachbb.getBaseId());
BlackOutDetailBean bod = new BlackOutDetailBean();
bod.setProductId(base.getProductId());
bod.setPrice(eachbb.getSailPrice());
bod.setAmount(eachbb.getAmount());
bod.setOutId(base.getOutId());
bod.setOutBalanceId(eachbb.getParentId());
bod.setCostPrice(base.getCostPrice());
blackOutDetailDAO.saveEntityBean(bod);
}
}
}
} else {
// 减去退货部分
List<BaseBean> refBaseList = new ArrayList<BaseBean>();
ConditionParse con = new ConditionParse();
con.addWhereStr();
con.addCondition("OutBean.refOutFullId", "=", outId);
con.addIntCondition("OutBean.type", "=", OutConstant.OUT_TYPE_INBILL);
con.addCondition("and OutBean.status in (3, 4)");
// 销售退库 & 领样退库
con.addCondition("and OutBean.outType in (4, 5)");
List<OutBean> refList = outDAO.queryEntityBeansByCondition(con);
// 领样对冲单
con.clear();
con.addWhereStr();
con.addCondition("OutBean.refOutFullId", "=", outId);
con.addIntCondition("OutBean.type", "=", OutConstant.OUT_TYPE_INBILL);
con.addCondition("and OutBean.status in (3, 4)");
con.addIntCondition("OutBean.outType", "=", OutConstant.OUTTYPE_IN_OTHER);
refList.addAll(outDAO.queryEntityBeansByCondition(con));
for (OutBean eachOut : refList) {
refBaseList.addAll(baseDAO.queryEntityBeansByFK(eachOut.getFullId()));
}
for (BaseBean base : baseList) {
for (BaseBean refBase : refBaseList) {
if (base.equals(refBase)) {
base.setAmount(base.getAmount() - refBase.getAmount());
}
}
saveOutDetail(base);
}
}
}
}
@SuppressWarnings("unused")
@Deprecated
private void processStatsBlackWhenOutPayChanged() {
// 获取实时已付款的数据，如果数据量大，要限制每次获取的条数
List<OutPayChangedBean> list = outPayChangedDAO.listEntityBeans();
if (ListTools.isEmptyOrNull(list)) return;
Set<String> idSet = new HashSet<String>();
for (OutPayChangedBean each : list) {
idSet.clear();
double backValue = 0.0d;
String outId = each.getOutId();
OutBean outBean = outDAO.find(outId);
if (null == outBean) {
outPayChangedDAO.deleteEntityBean(each.getId());
continue;
}
String stafferId = outBean.getStafferId();
BlackBean blackBean = blackDAO.findByUnique(stafferId);
if (null == blackBean) {
outPayChangedDAO.deleteEntityBean(each.getId());
continue;
}
String refId = blackBean.getId();
BlackOutBean boBean = blackOutDAO.findByRefIdAndTypeAndOutId(refId, 0, outId);
if (null == boBean) {
outPayChangedDAO.deleteEntityBean(each.getId());
continue;
}
idSet.add(boBean.getId());
BlackOutBean bo1Bean = blackOutDAO.findByRefIdAndTypeAndOutId(refId, 1, outId);
if (null != bo1Bean) {
idSet.add(bo1Bean.getId());
}
_logger.info(stafferId + " " + backValue + " " + refId + "==" + idSet);
processOutPayChangedWithoutTransaction(stafferId, blackBean, backValue, refId, idSet);
// 用完就删掉
outPayChangedDAO.deleteEntityBean(each.getId());
}
}
private void processStatsBlack(String statsDate, int type) {
final String beginDate = "2011-03-01";
// 例外规则
List<BlackRuleBean> ruleList = getBlackRuleForBlack();
List<String> stafferList = outDAO.queryDistinctStafferId(beginDate, statsDate, type);
ConditionParse condition = new ConditionParse();
triggerLog.info("**processStatsBlack with staffer size***" + stafferList.size());
for (String each : stafferList) {
try {
String stafferId = each;
setStatsBlackCondition(statsDate, stafferId, condition);
List<OutBean> outList = outDAO.queryEntityBeansByCondition(condition);
triggerLog.info(each + "***processStatsBlack out size:" + outList.size());
double outValue = 0.0d;
double allOutValue = 0.0d;
int maxReDate = 0;
List<BlackOutWrap> outWrapList = new ArrayList<BlackOutWrap>();
List<BlackOutWrap> allOutWrapList = new ArrayList<BlackOutWrap>();
List<BlackOutWrap> reDateOutWrapList = new ArrayList<BlackOutWrap>();
boolean exceptStaffer = false;
for (OutBean outBean : outList) {
boolean exceptOut = false;
double perOutValue = 0.0d;
int reDate = 0;
String outId = outBean.getFullId();
List<BaseBean> baseList = baseDAO.queryEntityBeansByFK(outId);
Set<String> productIdSet = new HashSet<String>();
// 刨去例外逻辑，涉及到 事业部，具体单号，销售时间，人员（这些在单据头中），具体商品,品类要涉及到单据行项目
if (!ListTools.isEmptyOrNull(ruleList)) {
triggerLog.info("***black rule size***" + ruleList.size());
for (BlackRuleBean eachRuleBean : ruleList) {
triggerLog.info(outBean + "*** out vs rule ***" + eachRuleBean);
if (TimeTools.cdate(outBean.getOutTime(), eachRuleBean.getBeginOutTime()) >= 0
&& TimeTools.cdate(outBean.getOutTime(), eachRuleBean.getEndOutTime()) <= 0) {
String ruleId = eachRuleBean.getId();
String industryId = outBean.getIndustryId();
String industryIds = eachRuleBean.getIndustryId();
String outIds = eachRuleBean.getOutId();
// 事业部
if (industryIds.indexOf(industryId) != -1) {
exceptStaffer = true;
}
// 单号
if (outIds.indexOf(outId) != -1) {
exceptOut = true;
break;
}
// 人员
boolean stafferInBlackRule = stafferIdInBlackRule(stafferId, ruleId);
if (stafferInBlackRule) {
exceptStaffer = true;
}
// 检查品类、单品， 品类 包含单品
List<BlackRuleProductBean> ruleProductList =
blackRuleProductDAO.queryEntityBeansByFK(ruleId);
if (StringTools.isNullOrNone(eachRuleBean.getProductType())
&& ListTools.isEmptyOrNull(ruleProductList)) {
continue;
} else {
getExceptProduct(outId, productIdSet, eachRuleBean, ruleProductList, baseList);
}
} else {
continue;
}
}
}
// 整笔是例外，直接进入下一个
if (exceptOut) {
continue;
}
// ProductIdSet 中是要刨去的商品
double excepTotal = 0.0d;
double total = 0.0d;
if (!productIdSet.isEmpty()) {
for (BaseBean eachBase : baseList) {
String productId = eachBase.getProductId();
for (String eachItem : productIdSet) {
if (eachItem.equals(productId)) {
excepTotal += eachBase.getValue();
}
}
}
}
total = outBean.getTotal() - excepTotal;
// 非委托代销
double outBackValue = sumOutBackValue(outId, productIdSet);
// 委托代销
double balanceBackValue = 0.0d;
if (outBean.getOutType() == OutConstant.OUTTYPE_OUT_CONSIGN) {
List<OutBalanceBean> balanceList = outBalanceDAO.queryExcludeSettleBack(outId, 0);
for (OutBalanceBean eachBalance : balanceList) {
if (eachBalance.getStatus() == 99) balanceBackValue += eachBalance.getTotal();
}
}
// 其它入库中关联了销售单的
double outForceBackValue = sumOutForceBackValue(outId, productIdSet);
// 本单应收款 = 总金额 - 退货 - 坏账 - 折扣 - 已付款
perOutValue =
total
- outBackValue
- balanceBackValue
- outForceBackValue
- outBean.getBadDebts()
- outBean.getPromValue()
- outBean.getHadPay();
triggerLog.info("***perOutValue***" + perOutValue);
try {
reDate = TimeTools.cdate(statsDate, outBean.getRedate());
} catch (Exception e) {
_logger.error("Catch you!", e);
}
// 超期
if (reDate > 0) {
outValue += perOutValue;
BlackOutWrap outWrap = new BlackOutWrap();
outWrap.setOutId(outId);
outWrap.setDays(reDate);
outWrap.setMoney(perOutValue);
outWrap.setCustomerName(outBean.getCustomerName());
outWrapList.add(outWrap);
if (reDate >= maxReDate) {
if (reDate > maxReDate) reDateOutWrapList.clear();
BlackOutWrap reDateOutWrap = new BlackOutWrap();
reDateOutWrap.setOutId(outId);
reDateOutWrap.setDays(reDate);
reDateOutWrap.setMoney(perOutValue);
reDateOutWrap.setCustomerName(outBean.getCustomerName());
reDateOutWrapList.add(reDateOutWrap);
maxReDate = reDate;
}
}
// 所有应收款
allOutValue += perOutValue;
BlackOutWrap allOutWrap = new BlackOutWrap();
allOutWrap.setOutId(outId);
allOutWrap.setDays(reDate);
allOutWrap.setMoney(perOutValue);
allOutWrap.setCustomerName(outBean.getCustomerName());
allOutWrapList.add(allOutWrap);
}
int blackType = processBlackTypeInner(stafferId, outValue, maxReDate, exceptStaffer);
BlackBean blackBean = blackDAO.findByUnique(stafferId);
StafferBean sb = stafferDAO.find(stafferId);
if (null == blackBean) {
String id = commonDAO.getSquenceString20();
BlackBean bean = new BlackBean();
bean.setId(id);
bean.setLogDate(statsDate);
bean.setStafferId(stafferId);
if (null != sb) {
bean.setIndustryId(sb.getIndustryId());
}
bean.setMoney(outValue);
bean.setDays(maxReDate);
bean.setAllMoneys(allOutValue);
bean.setCredit(blackType);
if (blackType != StafferConstant.BLACK_NO) {
bean.setEntryDate(TimeTools.now_short());
}
blackDAO.saveEntityBean(bean);
saveBlackOutInner(outWrapList, allOutWrapList, reDateOutWrapList, id);
} else {
String id = blackBean.getId();
blackBean.setLogDate(statsDate);
blackBean.setMoney(outValue);
blackBean.setDays(maxReDate);
blackBean.setAllMoneys(allOutValue);
if (blackBean.getCredit() == StafferConstant.BLACK_NO
&& blackType != StafferConstant.BLACK_NO) {
blackBean.setEntryDate(TimeTools.now_short());
blackBean.setRemoveDate("");
} else if (blackBean.getCredit() != StafferConstant.BLACK_NO
&& blackType == StafferConstant.BLACK_NO) {
blackBean.setRemoveDate(TimeTools.now_short());
}
blackBean.setCredit(blackType);
if (null != sb) {
blackBean.setIndustryId(sb.getIndustryId());
}
// 先删
blackDAO.deleteEntityBean(id);
blackDAO.saveEntityBean(blackBean);
blackOutDAO.deleteEntityBeansByFK(id);
saveBlackOutInner(outWrapList, allOutWrapList, reDateOutWrapList, id);
}
_logger.info("***finish processStatsBlack:" + stafferId);
} catch (Exception e) {
_logger.error("Exception when processStatsBlack:", e);
}
}
// delete logDate 不是statsDate，人员信息更新为正常
List<BlackBean> needDelBlackList = blackDAO.queryByLogDate(statsDate);
for (BlackBean eachd : needDelBlackList) {
blackDAO.deleteEntityBean(eachd.getId());
blackOutDAO.deleteEntityBeansByFK(eachd.getId());
stafferDAO.updateBlack(eachd.getStafferId(), StafferConstant.BLACK_NO);
}
}