package com.ld.igds.warn.service;
|
|
import com.bstek.bdf2.core.orm.hibernate.HibernateDao;
|
import com.bstek.dorado.data.provider.Page;
|
import com.ld.igds.models.SecureManager;
|
import com.ld.igds.util.ContextUtil;
|
import com.ld.igds.util.DateUtil;
|
import org.apache.commons.lang3.time.DateFormatUtils;
|
import org.hibernate.Session;
|
import org.springframework.stereotype.Component;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author czt
|
* @date 2023/10/30
|
**/
|
@Component
|
public class HSecureManagerService extends HibernateDao {
|
|
|
public void listData(Page<SecureManager> page, Map<String, Object> param) throws Exception {
|
StringBuffer hql = new StringBuffer();
|
hql.append(" from " + SecureManager.class.getName() + " where companyId =:companyId and deptId =:deptId ");
|
Map<String, Object> args = new HashMap<>();
|
args.put("companyId", ContextUtil.getCompanyId());
|
args.put("deptId", ContextUtil.subDeptId(null));
|
|
String count = "select count(*) " + hql.toString();
|
hql.append(" order by updateTime desc");
|
this.pagingQuery(page, hql.toString(), count, args);
|
|
}
|
|
public void saveData(SecureManager data) {
|
data.setUpdateTime(new Date());
|
data.setDeptId(ContextUtil.subDeptId(null));
|
data.setCompanyId(ContextUtil.getCompanyId());
|
Session session = this.getSessionFactory().openSession();
|
try {
|
if (null == data.getFxdbm()) {
|
data.setFxdbm(DateFormatUtils.format(new Date(), "yyyyMMdd") + getIndex(data.getCompanyId()));
|
|
session.save(data);
|
} else {
|
session.update(data);
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
} finally {
|
session.flush();
|
session.close();
|
}
|
}
|
|
public String getIndex(String companyId) {
|
List<SecureManager> list = getDataByTime(companyId);
|
int index = 10001;
|
if (list != null && list.size() > 0) {
|
String id = list.get(0).getFxdbm().substring(8);
|
int temp = Integer.valueOf(id) + 1;
|
index += temp;
|
}
|
|
return String.valueOf(index).substring(1);
|
}
|
|
private List<SecureManager> getDataByTime(String companyId) {
|
String hql = " from " + SecureManager.class.getName()
|
+ " where companyId =:companyId ";
|
|
Map<String, Object> args = new HashMap<String, Object>();
|
args.put("companyId", companyId);
|
|
hql += " and updateTime >:startTime";
|
args.put("startTime", DateUtil.getCurZero(new Date()));
|
|
|
hql += " and updateTime <:endTime";
|
args.put("endTime", DateUtil.getNextZero(new Date()));
|
|
|
hql += " order by id desc";
|
|
return this.query(hql, args);
|
}
|
|
public void delData(SecureManager data) {
|
Session session = this.getSessionFactory().openSession();
|
try {
|
if (null != data.getFxdbm()) {
|
session.delete(data);
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
} finally {
|
session.flush();
|
session.close();
|
}
|
}
|
|
}
|
