# dbb-sjg

**Repository Path**: dbb/dbb-sjg

## Basic Information

- **Project Name**: dbb-sjg
- **Description**: 通用手机柜功能
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-02-25
- **Last Updated**: 2026-06-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## 手机柜3.0

### 🎉 新增功能: 嵌入式 ActiveMQ 消息队列集成 (v3.1.6.2+)

项目已集成**嵌入式 ActiveMQ**，无需单独安装 ActiveMQ 服务器！

#### ⚡ 零配置快速开始
```bash
# 直接启动即可，嵌入式 ActiveMQ 自动运行
gradlew.bat bootRun

# 访问测试页面
http://localhost:9005/jmsTest/index
```

#### 主要特性
- ✅ **嵌入式 Broker** - 无需单独安装 ActiveMQ
- ✅ 队列消息 (Queue)
- ✅ 主题消息 (Topic)  
- ✅ 延迟消息
- ✅ 消息持久化（可选）
- ✅ 连接池
- ✅ 错误处理
- ✅ 健康检查

#### 文档
- 嵌入式指南: `docs/EMBEDDED_ACTIVEMQ_GUIDE.md` ⭐
- 快速开始: `docs/ACTIVEMQ_QUICKSTART.md`
- 完整文档: `docs/ACTIVEMQ_INTEGRATION.md`
- 集成总结: `docs/ACTIVEMQ_INTEGRATION_SUMMARY.md`

#### API 端点
- 测试页面: `/jmsTest/index`
- 健康检查: `/jmsHealth/check`
- 服务信息: `/jmsHealth/info`

---

### 版本历史 3.1.6.2
#### 事由保存类型异常

### 版本历史 3.1.6
#### 判断NA为抽查未交

### 版本历史 3.1.5
#### 修正抽查已交，抽查未交异常

//dbm用法
默认都是dev环境
//生成脚本
grails dbm-generate-gorm-changelog changelog.groovy
//初始化数据库
grails dbm-update
//比较gorm 和数据库差异
grails dbm-gorm-diff changelog.groovy
//生成数据库脚本
grails dbm-update-sql updatesql.sql

select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 09:03:48.000', '2024-07-18 11:34:50.000')  and Str_CardNo = '6015'

select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:50:40.000', '2024-07-18 15:02:04.000') and str_cardno='6015'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:59:18.000', '2024-07-18 15:00:33.000') and str_cardno='6009'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:54:33.000', '2024-07-18 15:03:25.000') and str_cardno='6013'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:28:21.000', '2024-07-18 15:03:15.000') and str_cardno='6004'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:33:35.000', '2024-07-18 15:00:33.000') and str_cardno='6002'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:58:58.000', '2024-07-18 15:06:07.000') and str_cardno='6020'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:59:38.000', '2024-07-18 15:00:33.000') and str_cardno='6014'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:59:59.000', '2024-07-18 15:01:54.000') and str_cardno='6006'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:48:08.000', '2024-07-18 15:04:16.000') and str_cardno='6010'
select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('2024-07-18 12:59:59.000', '2024-07-18 15:02:04.000') and str_cardno='6016'

select * FROM [SJG].[dbo].[lz_OpenLog] where Str_date in ('', '2024-07-18 15:04:16.000') and str_cardno='6005'

aa	bb	(无列名)	Str_CardNo

aa	bb	(无列名)	Str_CardNo

2024-07-18 12:50:40.000	2024-07-18 15:02:04.000	1262	6015
2024-07-18 12:59:18.000	2024-07-18 15:00:33.000	1160	6009
2024-07-18 12:54:33.000	2024-07-18 15:03:25.000	1216	6013
2024-07-18 12:28:21.000	2024-07-18 15:03:15.000	1526	6004
2024-07-18 12:33:35.000	2024-07-18 15:00:33.000	1464	6002
2024-07-18 12:58:58.000	2024-07-18 15:06:07.000	1164	6020
2024-07-18 12:59:38.000	2024-07-18 15:00:33.000	1156	6014
2024-07-18 12:59:59.000	2024-07-18 15:01:54.000	1152	6006
2024-07-18 12:48:08.000	2024-07-18 15:04:16.000	1292	6010
2024-07-18 12:59:59.000	2024-07-18 15:02:04.000	1152	6016

version=3.1.12-bn
    provided "cn.jh-dev:dbb-ui:1.5.42"
    provided "cn.jh-dev:dbb-security:1.5.32"
    provided "cn.jh-dev:dbb-sjg:3.1.29"

version=ct-3.1.10
    compile "cn.jh-dev:dbb-core:1.5.21"
    compile "cn.jh-dev:dbb-ui:1.5.28"
    compile "cn.jh-dev:dbb-security:1.5.21"
    compile "cn.jh-dev:dbb-sjg:3.1.21"

version=3.0.44-dbjj
    provided "cn.jh-dev:dbb-ui:1.6.6"
    provided "cn.jh-dev:dbb-security:1.6.6"
    provided "cn.jh-dev:dbb-dbtool:1.6.0"
    compile "cn.jh-dev:dbb-sjg:3.6.3"

version=3.0.4-gfjj
    compile "cn.jh-dev:dbb-core:1.5.21"
    compile "cn.jh-dev:dbb-ui:1.5.28"
    compile "cn.jh-dev:dbb-security:1.5.25"
    compile "cn.jh-dev:dbb-sjg:3.1.21"

version=huatai-3.1.15
    compile "cn.jh-dev:dbb-core:1.5.21"
    compile "cn.jh-dev:dbb-security:1.5.21"
    compile "cn.jh-dev:dbb-ui:1.5.40"
    compile "cn.jh-dev:dbb-sjg:3.1.21.2"

version=swhy-3.0.3
    compile "cn.jh-dev:dbb-core:1.5.23"
    compile "cn.jh-dev:dbb-ui:1.5.41"
    compile "cn.jh-dev:dbb-security:1.5.32"
    compile "cn.jh-dev:dbb-sjg:3.1.28"

version=tk-3.0.67-test
    compile "cn.jh-dev:dbb-core:1.5.23"
    compile "cn.jh-dev:dbb-ui:1.5.38"
    compile "cn.jh-dev:dbb-security:1.5.22"
    compile "cn.jh-dev:dbb-dbtool:1.5.18"
    compile "cn.jh-dev:dbb-sjg:3.1.29-tk"

version=yxyf-3.1.27
    provided "cn.jh-dev:dbb-core:1.5.23"
    provided "cn.jh-dev:dbb-ui:1.5.41"
    provided "cn.jh-dev:dbb-security:1.5.32"
    compile "cn.jh-dev:dbb-sjg:3.1.27.3"

version=zszq-3.1.15
    compile "cn.jh-dev:dbb-core:1.5.21"
    compile "cn.jh-dev:dbb-ui:1.5.32"
    compile "cn.jh-dev:dbb-security:1.5.21"
    compile "cn.jh-dev:dbb-sjg:3.1.21.2"

    compile "cn.jh-dev:dbb-sjg:3.1.1-yfd"
    compile "cn.jh-dev:dbb-sjg:3.1.21"
    compile "cn.jh-dev:dbb-sjg:3.1.21.2"

    compile "cn.jh-dev:dbb-sjg:3.1.27.3"
    compile "cn.jh-dev:dbb-sjg:3.1.28"
    compile "cn.jh-dev:dbb-sjg:3.1.29-tk"
    compile "cn.jh-dev:dbb-sjg:3.6.3"
    provided "cn.jh-dev:dbb-sjg:3.6.6"

公司体量：

业务类型：
1.AI方向
2.外包

企业、

运营商、系统集成商、

产业大脑：
数据接口、权限控制、大屏展示、



13010220120912189X
Gcj@2012

Shedu@12189x


13010220120912189X
Shedu@12189X