package com.product.badge.service;
|
|
import com.product.admin.service.PublicService;
|
import com.product.badge.config.CmnConst;
|
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.service.support.AbstractBaseService;
|
import com.product.core.service.support.QueryFilterService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
/**
|
* Copyright © 6c
|
*
|
* @Date: 2021-06-29 16:30
|
* @Author: 6c
|
* @Description:
|
*/
|
@Service
|
public class BadgeService extends AbstractBaseService {
|
@Autowired
|
public BaseDao baseDao;
|
@Autowired
|
public QueryFilterService queryFilterService;
|
@Autowired
|
public PublicService publicService;
|
|
/**
|
* 列表台账
|
* @param fse
|
* @return
|
*/
|
public DataTableEntity listTable(FieldSetEntity fse) {
|
StringBuilder sql = new StringBuilder(512);
|
sql.append("select * from (");
|
sql.append("\nselect d.uuid,org_level_uuid,badge_name,badge_level,holder,badge_type,ifnull(badge_status,'未借出') badge_status,borrow_by,borrow_time,return_date,flow_flag");
|
sql.append("\nfrom ").append(fse.getTableName()).append(" d");
|
sql.append("\nleft join ( ");
|
sql.append("\n select b.* from ( ");
|
sql.append("\n select s.uuid,m.created_by borrow_by,m.created_utc_datetime borrow_time,s.return_by,s.return_date,badge_uuid, ");
|
sql.append("\n case when s.return_by is null or s.return_by='' then '借出' else '归还' END badge_status ");
|
sql.append("\n from product_oa_badge_borrow_record m ");
|
sql.append("\n left join product_oa_badge_borrow_detail s ");
|
sql.append("\n on m.uuid=s.record_uuid ");
|
sql.append("\n ) b ");
|
sql.append("\n inner join ( ");
|
sql.append("\n select uuid,max(created_utc_datetime) last_borrow_time ");
|
sql.append("\n from ( ");
|
sql.append("\n select s.uuid,m.created_utc_datetime ");
|
sql.append("\n from product_oa_badge_borrow_record m ");
|
sql.append("\n left join product_oa_badge_borrow_detail s ");
|
sql.append("\n on m.uuid=s.record_uuid ");
|
sql.append("\n ) b ");
|
sql.append("\n group by uuid ");
|
sql.append("\n ) t ");
|
sql.append("\n on b.uuid=t.uuid and b.borrow_time=t.last_borrow_time ");
|
sql.append("\n) b ");
|
sql.append("\non d.uuid=b.badge_uuid ");
|
sql.append("\n) a ");
|
|
|
String filter = publicService.getListFilter(fse, 0);
|
|
if (!StringUtils.isEmpty(filter)) {
|
sql.append(" where ").append(filter);
|
}
|
int pageSize = fse.getInteger(CmnConst.PAGE_SIZE) == null ? Integer.MAX_VALUE : fse.getInteger(CmnConst.PAGE_SIZE);
|
int curPage = fse.getInteger(CmnConst.CUR_PAGE) == null ? 1 : fse.getInteger(CmnConst.CUR_PAGE);
|
DataTableEntity dte = baseDao.listTable(sql.toString(), new Object[]{}, pageSize, curPage);
|
dte.getMeta().addAliasTable(fse.getTableName(),"d");
|
baseDao.loadPromptData(dte);
|
return dte;
|
}
|
}
|
