package com.product.base.service;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
import com.product.admin.service.CodeService;
|
import com.product.admin.service.PublicService;
|
import com.product.base.config.CmnConst;
|
import com.product.base.util.UnUnitCodeUtil;
|
import com.product.core.dao.BaseDao;
|
import com.product.core.entity.DataTableEntity;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.core.spring.context.SpringMVCContextHolder;
|
import com.product.module.sys.entity.SystemUser;
|
import com.product.util.BaseUtil;
|
|
|
@Component
|
public class BaseItemizeService extends AbstractBaseService{
|
|
@Autowired
|
BaseDao baseDao;
|
|
@Autowired
|
CodeService codeService;
|
|
@Autowired
|
PublicService publicService;
|
|
/**
|
* 分页获取项目分类
|
* @param fse
|
* @return
|
*/
|
public DataTableEntity listProjectType(FieldSetEntity fse) {
|
return baseDao.listTable(CmnConst.PRODUCT_PROJECT_BASE_PROJECT_TYPE, null, null, null, null, fse.getInteger(CmnConst.PAGESIZE), fse.getInteger(CmnConst.CPAGE));
|
}
|
|
/**
|
* 获取项目分类
|
* @param uuid
|
* @return
|
*/
|
public FieldSetEntity getProjectType(String uuid) {
|
return baseDao.getFieldSet(CmnConst.PRODUCT_PROJECT_BASE_PROJECT_TYPE, uuid, false);
|
}
|
|
/**
|
* 保存项目分类
|
* @param fse
|
* @return
|
*/
|
public boolean saveProjectType(FieldSetEntity fse) {
|
fse.setTableName(CmnConst.PRODUCT_PROJECT_BASE_PROJECT_TYPE);
|
SystemUser user = SpringMVCContextHolder.getCurrentUser();
|
if(BaseUtil.strIsNull(fse.getUUID())) {
|
BaseUtil.createCreatorAndCreationTime(user, fse);
|
}else {
|
BaseUtil.updatedRegeneratorAndUpdateTime(user, fse);
|
}
|
return baseDao.saveFieldSetEntity(fse);
|
}
|
|
/**
|
* 获取项目分项树
|
* @param uuid
|
* @return
|
*/
|
public DataTableEntity listProjectItemTree(String uuid) {
|
DataTableEntity dtProjectItem = baseDao.listTable("SELECT uuid,itemize,itemize_code,itemize_parent_code,itemize_type FROM product_project_base_project_item WHERE itemize_type=?", new Object[] {uuid});
|
if (!BaseUtil.dataTableIsEmpty(dtProjectItem)) {
|
baseDao.loadPromptData(dtProjectItem);
|
return BaseUtil.dataTableToTreeTable(dtProjectItem, CmnConst.ITEMIZE_CODE, CmnConst.ITEMIZW_PARENT_CODE, null);
|
}
|
return null;
|
}
|
|
/**
|
* 获取单个项目分项信息
|
* @param uuid
|
* @return
|
*/
|
public FieldSetEntity getProjectItem(String uuid) {
|
return baseDao.getFieldSet(CmnConst.PRODUCT_PROJECT_BASE_PROJECT_ITEM, uuid, false);
|
}
|
|
/**
|
* 保存项目分项信息
|
* @param fse
|
* @return
|
*/
|
public boolean saveProjectItem(FieldSetEntity fse) {
|
SystemUser user = SpringMVCContextHolder.getCurrentUser();
|
if(BaseUtil.strIsNull(fse.getUUID())) {
|
//生成创建人和创建时间
|
BaseUtil.createCreatorAndCreationTime(user, fse);
|
//获取父级编码
|
String parentCode = fse.getString(CmnConst.ITEMIZW_PARENT_CODE);
|
|
//获取同类型同上级分项最大编码
|
FieldSetEntity fseMaxCodeData;
|
String currentCode;
|
if (BaseUtil.strIsNull(parentCode)) {
|
fseMaxCodeData = baseDao.getFieldSetBySQL("SELECT MAX(itemize_code)itemize_code FROM product_project_base_project_item WHERE itemize_type = ? AND itemize_parent_code IS null", new Object[] {fse.getString(CmnConst.ITEMIZE_TYPE)}, false);
|
if (fseMaxCodeData != null && !BaseUtil.strIsNull(fseMaxCodeData.getString(CmnConst.ITEMIZE_CODE))) {
|
currentCode = UnUnitCodeUtil.autoCreateCode(fseMaxCodeData.getString(CmnConst.ITEMIZE_CODE));
|
}else {
|
currentCode = "001";
|
}
|
}else {
|
fseMaxCodeData = baseDao.getFieldSetBySQL("SELECT MAX(itemize_code)itemize_code FROM product_project_base_project_item WHERE itemize_type = ? AND itemize_parent_code = ?", new Object[] {fse.getString(CmnConst.ITEMIZE_TYPE), parentCode}, false);
|
if (fseMaxCodeData != null && !BaseUtil.strIsNull(fseMaxCodeData.getString(CmnConst.ITEMIZE_CODE))) {
|
currentCode = UnUnitCodeUtil.autoCreateCode(fseMaxCodeData.getString(CmnConst.ITEMIZE_CODE));
|
}else {
|
currentCode = parentCode+"-001";
|
}
|
}
|
fse.setValue(CmnConst.ITEMIZE_CODE, currentCode);
|
|
}else {
|
BaseUtil.updatedRegeneratorAndUpdateTime(user, fse);
|
}
|
return baseDao.saveFieldSetEntity(fse);
|
}
|
|
|
/**
|
* 删除项目分项信息(验证是否包含子项)
|
* @param uuid
|
* @return
|
*/
|
public boolean deleteProjectItem(String uuid) {
|
FieldSetEntity fse = baseDao.getFieldSet(CmnConst.PRODUCT_PROJECT_BASE_PROJECT_ITEM, uuid, false);
|
if (fse != null) {
|
String itemCode = fse.getString(CmnConst.ITEMIZE_CODE);
|
return baseDao.delete(CmnConst.PRODUCT_PROJECT_BASE_PROJECT_ITEM, "itemize_code like ?", new Object[] {itemCode+"%"});
|
}
|
return true;
|
}
|
}
|
