package zbooksoft.fams.dao; import com.ruili.wcp.common.IdGenerater; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Repository; import java.util.Collections; import java.util.List; import java.util.Map; /** * 标签模板、标签打印记录与标签所需资产数据的数据访问 * @author ycq * @date 2026-10-16 */ @Repository public class LabelDao { /** 标签上可展示的资产字段 */ private static final String CARD_LABEL_COLUMNS = "ID, ASSET_NO, ASSET_NAME, SPEC_MODEL, CATEGORY_NAME, DEVICE_TYPE, BRAND, FACTORY_NO, UNIT, " + "ORIGINAL_VALUE, PURCHASE_DATE, SUPPLIER, ASSET_STATE, USE_DEPT_NAME, USER_NAME, LOCATION_NAME, START_USE_DATE, " + "WARRANTY_EXPIRE_DATE, NEXT_MAINTAIN_DATE, VERIFY_EXPIRE_DATE, INSPECT_ORG, CERT_NO, SAFETY_USER_NAME, RISK_LEVEL, " + "PRINT_STATE, LAST_PRINT_TIME, REMARK"; @Autowired private JdbcTemplate jdbcTemplate; /** * 按主键查标签模板 * @param id 模板ID * @return 模板行,不存在返回null */ public Map findTemplate(Long id) { List> rows = jdbcTemplate.queryForList( "select ID, TEMPLATE_NAME, LABEL_WIDTH, LABEL_HEIGHT, LAYOUT_JSON, IS_DEFAULT, ENABLE_STATE from BUS_LABEL_TEMPLATE where ID = ?", id); return rows.isEmpty() ? null : rows.get(0); } /** * 查启用的标签模板,默认模板排前 * @return 模板列表 */ public List> findEnabledTemplates() { return jdbcTemplate.queryForList("select ID, TEMPLATE_NAME, LABEL_WIDTH, LABEL_HEIGHT, LAYOUT_JSON, IS_DEFAULT from BUS_LABEL_TEMPLATE " + "where ifnull(ENABLE_STATE, '启用') = '启用' order by case when IS_DEFAULT = '是' then 0 else 1 end, SORT_NO, CREATE_TIME"); } /** * 取消除指定模板外所有模板的默认标记 * @param id 保留默认的模板ID */ public void clearDefaultExcept(Long id) { jdbcTemplate.update("update BUS_LABEL_TEMPLATE set IS_DEFAULT = '否' where ID <> ? and IS_DEFAULT = '是'", id); } /** * 保存模板布局 * @param id 模板ID * @param layoutJson 布局JSON */ public void updateTemplateLayout(Long id, String layoutJson) { jdbcTemplate.update("update BUS_LABEL_TEMPLATE set LAYOUT_JSON = ?, MODIFY_TIME = now() where ID = ?", layoutJson, id); } /** * 按ID批量查标签所需的资产数据,按资产编号排序 * @param ids 资产ID列表 * @return 资产行 */ public List> findCardsForLabel(List ids) { if (ids.isEmpty()) { return Collections.emptyList(); } String placeholders = String.join(",", Collections.nCopies(ids.size(), "?")); return jdbcTemplate.queryForList("select " + CARD_LABEL_COLUMNS + " from BUS_ASSET_CARD where ID in (" + placeholders + ") order by ASSET_NO", ids.toArray()); } /** * 写一条标签打印记录 * @param row 打印记录字段(大写列名) */ public void insertPrintLog(Map row) { jdbcTemplate.update("insert into BUS_LABEL_PRINT_LOG (ID, ASSET_ID, ASSET_NO, ASSET_NAME, TEMPLATE_ID, TEMPLATE_NAME, " + "PRINT_USER_ID, PRINT_USER_NAME, PRINT_TIME, CREATE_USER_ID, CREATE_USER_NAME, CREATE_TIME, MODIFY_TIME) " + "values (?, ?, ?, ?, ?, ?, ?, ?, now(), ?, ?, now(), now())", IdGenerater.getId(), row.get("ASSET_ID"), row.get("ASSET_NO"), row.get("ASSET_NAME"), row.get("TEMPLATE_ID"), row.get("TEMPLATE_NAME"), row.get("PRINT_USER_ID"), row.get("PRINT_USER_NAME"), row.get("PRINT_USER_ID"), row.get("PRINT_USER_NAME")); } /** * 标记资产标签已打印 * @param ids 资产ID列表 */ public void markPrinted(List ids) { if (ids.isEmpty()) { return; } String placeholders = String.join(",", Collections.nCopies(ids.size(), "?")); jdbcTemplate.update("update BUS_ASSET_CARD set PRINT_STATE = 1, LAST_PRINT_TIME = now() where ID in (" + placeholders + ")", ids.toArray()); } }