package com.home.xining.service;
|
|
import com.home.xining.config.CmnConst;
|
import com.home.xining.service.idel.IAdvanceNoticeService;
|
import com.home.xining.service.idel.IOfficeExpensesService;
|
import com.product.common.lang.StringUtils;
|
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.permission.PermissionService;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.core.service.support.QueryFilterService;
|
import com.product.core.transfer.Transactional;
|
import com.product.util.BaseUtil;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
import org.springframework.stereotype.Service;
|
|
import java.text.DecimalFormat;
|
import java.text.Format;
|
import java.text.ParseException;
|
|
/**
|
* @ClassName: AdvanceNoticeService
|
* @Author:
|
* @Date: 2022/1/11 17:16
|
* @Description: 行政处罚事先告知书Service
|
*/
|
@Service
|
public class AdvanceNoticeService extends AbstractBaseService implements IAdvanceNoticeService {
|
|
@Autowired
|
public BaseDao baseDao;
|
@Autowired
|
PermissionService permissionService;
|
@Autowired
|
QueryFilterService queryFilterService;
|
|
@Override
|
public DataTableEntity listAdvanceNoticeg(FieldSetEntity fs) throws BaseException {
|
String filter = fs.getString("filter");
|
String dataFilter = permissionService.getDataFilter(fs.getTableName(), CmnConst.NO18);
|
|
if (!StringUtils.isEmpty(dataFilter)) {
|
if (!StringUtils.isEmpty(filter)) {
|
filter += " and " + dataFilter;
|
} else {
|
filter = dataFilter;
|
}
|
}
|
if (!BaseUtil.dataTableIsEmpty(fs.getSubDataTable("systemSeniorQueryString"))) {
|
filter = filter + " and " + queryFilterService.getQueryFilter(fs);
|
}
|
// fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE)
|
DataTableEntity dt = baseDao.listTable(CmnConst.APP_NOTICE_PUNISHMENT, filter, null, null, " no00 desc", fs.getInteger(CmnConst.PAGESIZE), fs.getInteger(CmnConst.CPAGE));
|
baseDao.loadPromptData(dt);
|
return dt;
|
}
|
|
@Override
|
public FieldSetEntity getAdvanceNotice(FieldSetEntity fs) {
|
return baseDao.getFieldSet(CmnConst.APP_NOTICE_PUNISHMENT, fs.getUUID(), false);
|
}
|
|
@Override
|
@Transactional
|
public String saveAdvanceNotice(FieldSetEntity fs) throws BaseException {
|
String fsUUID = fs.getUUID();
|
if (BaseUtil.strIsNull(fsUUID)) {
|
fsUUID = baseDao.add(fs);
|
} else {
|
baseDao.update(fs);
|
}
|
return fsUUID;
|
}
|
|
@Override
|
@Transactional
|
public String deleteAdvanceNotice(FieldSetEntity fs) throws BaseException {
|
String uuids = fs.getString(CmnConst.UUID);
|
String[] uuid = uuids.split(",");
|
baseDao.delete(CmnConst.APP_NOTICE_PUNISHMENT, uuid);
|
return uuids;
|
}
|
|
@Override
|
@Transactional
|
public void addTypeSize(FieldSetEntity fs) throws BaseException {
|
String tableName = fs.getTableName();
|
String yearNo = fs.getString("no01");
|
|
//查询同字数据中最大的号
|
FieldSetEntity fseMax = baseDao.getFieldSetEntityBySQL("SELECT CONVERT(IFNULL(MAX(no02),0)+1,UNSIGNED INT ) no02 FROM " + tableName + " WHERE no01=?", new Object[]{yearNo}, false);
|
if (fseMax != null) {
|
Integer maxNo = fseMax.getInteger("no02");
|
|
//格式化号
|
Format format = new DecimalFormat("000");
|
String finalNo = format.format(maxNo);
|
|
//修改数据
|
baseDao.executeUpdate("UPDATE " + tableName + " SET no02 =? WHERE uuid=?", new Object[]{finalNo, fs.getUUID()});
|
fs.setValue("no02", finalNo);
|
}
|
}
|
}
|
