package com.product.project.management.service;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
import com.product.core.config.CoreConst;
|
import com.product.core.dao.BaseDao;
|
import com.product.core.entity.DataTableEntity;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.exception.BaseException;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.project.management.config.Cmnconst;
|
import com.product.project.management.config.SystemCode;
|
import com.product.project.management.util.ProjectItemUtil;
|
import com.product.util.BaseUtil;
|
|
@Component
|
public class ProjectItemizeService extends AbstractBaseService{
|
|
@Autowired
|
BaseDao baseDao;
|
|
|
/**
|
* 项目分项-项目树（主子项目）
|
* @param projectUUID 项目UUID
|
* @return
|
*/
|
public DataTableEntity getProjectTree(String projectUUID) {
|
FieldSetEntity fseProjectInfo = baseDao.getFieldSetEntity(Cmnconst.PRODUCT_PROJECT_QXLW, projectUUID, false);
|
if (fseProjectInfo == null) {
|
return null;
|
}
|
DataTableEntity dtProjectItemize = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_ITEM, "project_uuid=?", new Object[]{projectUUID}, new Object[]{CoreConst.UUID, Cmnconst.ITEMIZE, Cmnconst.ITEMIZE_CODE, Cmnconst.ITEMIZE_PARENT_CODE});
|
if (!BaseUtil.dataTableIsEmpty(dtProjectItemize)) {
|
DataTableEntity newDtProjectItem = BaseUtil.dataTableToTreeTable(dtProjectItemize, Cmnconst.ITEMIZE_CODE, Cmnconst.ITEMIZE_PARENT_CODE, null);
|
return newDtProjectItem;
|
}
|
return null;
|
}
|
|
/**
|
* 项目分项-列表（展示选中分项的下一级列表）
|
* @param projectUUID
|
* @param itemizeCode
|
* @param capge
|
* @param pageSize
|
* @return
|
*/
|
public DataTableEntity listProjectItem(String projectUUID, String itemizeCode, Integer capge, Integer pageSize) {
|
DataTableEntity dtItemizeBudget;
|
if(BaseUtil.strIsNull(itemizeCode) || "000".equals(itemizeCode)) {
|
dtItemizeBudget = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_ITEM, "project_uuid=? AND itemize_parent_code IS NULL", new Object[] {projectUUID}, null, null, pageSize, capge);
|
}else {
|
dtItemizeBudget = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_ITEM, "project_uuid=? AND itemize_parent_code=?", new Object[] {projectUUID,itemizeCode}, null, null, pageSize, capge);
|
}
|
|
//查询选中节点下所有项目分项
|
if (!BaseUtil.dataTableIsEmpty(dtItemizeBudget)) {
|
baseDao.loadPromptData(dtItemizeBudget);
|
}
|
return dtItemizeBudget;
|
}
|
|
/**
|
* 保存项目分项
|
* @param fse
|
* @return
|
*/
|
public FieldSetEntity saveProjectItem(FieldSetEntity fse) {
|
//判断是否是新增
|
if (BaseUtil.strIsNull(fse.getUUID())) {
|
String projectUUID = fse.getString(Cmnconst.PROJECT_UUID);
|
FieldSetEntity fseMaxProjectItem;
|
String itemizeCode;
|
String itemizeFullName = null;
|
//判断是否有上级
|
if (BaseUtil.strIsNull(fse.getString(Cmnconst.ITEMIZE_PARENT_CODE))) {
|
fseMaxProjectItem = baseDao.getFieldSetEntityByFilter(Cmnconst.PRODUCT_PROJECT_ITEM, new String[] {"Max(itemize_code)itemize_code"}, "project_uuid = ? AND itemize_parent_code IS NULL", new Object[] {projectUUID}, false, null);
|
if (fseMaxProjectItem==null || BaseUtil.strIsNull(fseMaxProjectItem.getString(Cmnconst.ITEMIZE_CODE))) {
|
itemizeCode = "001";
|
}else {
|
itemizeCode = ProjectItemUtil.autoAddOneCode(fseMaxProjectItem.getString(Cmnconst.ITEMIZE_CODE));
|
}
|
itemizeFullName = fse.getString(Cmnconst.ITEMIZE);
|
}else {
|
fseMaxProjectItem = baseDao.getFieldSetEntityByFilter(Cmnconst.PRODUCT_PROJECT_ITEM, new String[] {"Max(itemize_code)itemize_code"}, "project_uuid = ? AND itemize_parent_code = ?", new Object[] {projectUUID, fse.getString(Cmnconst.ITEMIZE_PARENT_CODE)}, false, null);
|
if (fseMaxProjectItem==null || BaseUtil.strIsNull(fseMaxProjectItem.getString(Cmnconst.ITEMIZE_CODE))) {
|
itemizeCode = ProjectItemUtil.autoCreateCode(fse.getString(Cmnconst.ITEMIZE_PARENT_CODE));
|
}else {
|
itemizeCode = ProjectItemUtil.autoAddOneCode(fseMaxProjectItem.getString(Cmnconst.ITEMIZE_CODE));
|
}
|
FieldSetEntity itemizeParent = baseDao.getFieldSetEntityByFilter(Cmnconst.PRODUCT_PROJECT_ITEM, "project_uuid =? AND itemize_code=?", new Object[] {projectUUID, fse.getString(Cmnconst.ITEMIZE_PARENT_CODE)}, false);
|
if (itemizeParent!=null) {
|
itemizeFullName = itemizeParent.getString(Cmnconst.ITEMIZE_FULL_NAME) + "/" + fse.getString(Cmnconst.ITEMIZE);
|
}
|
}
|
fse.setValue(Cmnconst.ITEMIZE_CODE, itemizeCode);
|
fse.setValue(Cmnconst.ITEMIZE_FULL_NAME, itemizeFullName);
|
}
|
baseDao.saveFieldSetEntity(fse);
|
return fse;
|
}
|
|
/**
|
* 删除项目分项
|
* @param uuids
|
* @return
|
*/
|
public boolean deleteProjectItem(String uuids, String projectUUID) {
|
//验证是否生成预算
|
StringBuilder sbValidate = new StringBuilder(128);
|
sbValidate.append(" SELECT * FROM product_project_budget ")
|
.append(" WHERE project_itemize_uuid IN( ")
|
.append(" select uuid from product_project_item ")
|
.append(" WHERE project_uuid = ? AND itemize_code REGEXP ( ")
|
.append(" SELECT CONCAT('^',GROUP_CONCAT(itemize_code SEPARATOR '|^')) FROM product_project_item ")
|
.append(" WHERE ")
|
.append(BaseUtil.buildQuestionMarkFilter(Cmnconst.UUID, uuids.split(","), true))
|
.append(" ) ")
|
.append(" ) ");
|
DataTableEntity dtBudget = baseDao.listTable(sbValidate.toString(), new Object[] {projectUUID});
|
if (!BaseUtil.dataTableIsEmpty(dtBudget)) {
|
throw new BaseException(SystemCode.PROJECT_ITEMIZE_DEL_FAIL_HAS_BUDGET.getText(), SystemCode.PROJECT_ITEMIZE_DEL_FAIL_HAS_BUDGET.getValue());
|
}
|
//删除
|
StringBuilder sbDelete = new StringBuilder(128);
|
sbDelete.append(" DELETE from product_project_item ")
|
.append(" WHERE uuid IN( ")
|
.append(" SELECT * FROM( ")
|
.append(" SELECT uuid FROM product_project_item ")
|
.append(" WHERE project_uuid = ? AND itemize_code REGEXP ( ")
|
.append(" SELECT CONCAT('^',GROUP_CONCAT(itemize_code SEPARATOR '|^')) FROM product_project_item ")
|
.append(" WHERE ")
|
.append(BaseUtil.buildQuestionMarkFilter(Cmnconst.UUID, uuids.split(","), true))
|
.append(" ) ")
|
.append(" )A ")
|
.append(" ) ");
|
|
return baseDao.executeUpdate(sbDelete.toString(), new Object[] {projectUUID});
|
}
|
}
|
