antissoft / lvqianmeiye_ERP

门店目标保存/同步上月时归一化事业部等归属字段为组织ID，列表不再把ID转成名称；日报事业部与四大天王兼容历史名称关联；转卡品项按开单日期兜底 yjsj；补充相关 SQL 与前端编辑防呆。

Co-authored-by: Cursor <cursoragent@cursor.com>

- 登录页设为启动页并统一 redirectToLogin，避免多接口 600 连续 reLaunch
- 小程序耗卡可编辑天数/跨月策略与后台配置对齐
- 开单 gjlx 自动补全与台账顾客类型展示兜底
- 系统配置页拆分面板、短信日志抽屉样式优化

Co-authored-by: Cursor <cursoragent@cursor.com>

- 会员自定义标签三端维护与标签库管理
- 监控中心大客卡金异常列表及阈值配置
- 重复充值提醒按开单/耗卡分类型校验
- 科技部驾驶舱纳入 Slim 并修复排行分布接口
- 培训签到 H5、入职公开填报、考勤半天时段等
- 小程序 pagesB 分包与驾驶舱入口调整
- 补充 V2.0.2 更新说明与部署 SQL

Co-authored-by: Cursor <cursoragent@cursor.com>

报销列表与导出展示业务编号，申请时间零点补时分秒；退卡明细支持类型筛选与按健康师拆行导出；上传记录可按人员筛选；同步入职资料字段与更新说明草稿。

Co-authored-by: Cursor <cursoragent@cursor.com>

补齐事业部三美占比、五项排名、服务日志与重复充值审计；大项目医美频次/分层/应收等能力；手机端金三角业绩与隐私政策；考勤补卡全勤口径及系统更新说明。

Co-authored-by: Cursor <cursoragent@cursor.com>

统一 Vben5 暗色布局与列表样式，接入短信模板/发送日志及门店祝福发送，并支持手机号隐私脱敏开关。

Co-authored-by: Cursor <cursoragent@cursor.com>

- Added a new column `F_APPLYDEPTID` to the `wform_leaveapply` table to store the organization ID of the applying department.
- Updated historical data to populate `F_APPLYDEPTID` for entries where the department name is '事业部' by joining with the `BASE_ORGANIZE` table.

feat: 添加系统更新日志功能和沉睡会员提醒功能

- 在导航栏右侧添加更新日志图标，点击可查看系统更新日志
- 实现更新日志弹窗组件，支持分页加载和分类展示
- 新增沉睡会员提醒配置项，可在系统配置中设置沉睡天数
- 实现门店PC端沉睡会员列表查询功能，按最后消费时间排序
- 优化上传记录页面，添加来源模块标签和时间格式化显示
- 修复农历生日计算中的边界问题和异常处理
- 调整文件上传大小限制从10MB提升至20MB
- 添加mysql2依赖包以支持数据库相关功能
```

feat(.cursor): 更新数据库连接配置并添加业务操作日志规范

更新 MCP 数据库连接字符串，将生产环境连接改为开发环境连接；
在项目规则中添加业务操作日志要求，规定删除、修改、作废、导出
等写操作必须记录业务日志到 lq_business_operation_log 表；
同时在 AGENTS 和 CLAUDE 配置中添加业务操作日志相关的技能引用。
```

feat(config): 更新生产环境API配置

启用正式环境的API接口配置，禁用202605备份环境配置，
确保生产环境使用正确的后端服务地址。
```

feat(env): 添加202605备份环境配置

新增202605备份环境的API和WebSocket连接地址，
用于支持备份环境的部署和测试需求。
```

chore(config): 切换数据库连接配置从开发环境到生产环境

切换MCP配置中的数据库连接字符串，将默认连接从lqerp_dev开发库更改为lqerp生产库，
同时注释掉原来的开发环境配置以备后续使用
```

- 将硬编码的文件路径和月份改为可配置参数
- 添加命令行参数解析功能，支持自定义JSON输入、输出文件、统计月份和SQL引用
- 更新脚本文档字符串，提供使用示例和参数说明
- 修改Excel底部说明中的动态月份和SQL文件引用
- 更新SQL模板注释，说明多月份支持

fix(config): 切换MCP配置到开发环境数据库连接

Co-authored-by: Cursor <cursoragent@cursor.com>

```
chore(config): 更新配置文件

移除不必要的配置项，优化项目设置。
```

注意：由于未提供具体的代码差异信息，以上为示例格式。请提供实际的代码变更内容以生成准确的提交信息。

- Updated the .env.production file to set the base API and WebSocket URLs for the testing environment.
- Commented out the production URLs for clarity and future reference.
- Removed the deprecated CSS file from the dist directory to clean up the project structure.

Made-with: Cursor

…ew mode for weekly and monthly attendance, updating UI components for better user experience, and implementing Wi-Fi and geofencing options for attendance verification. Refactor backend services to support new attendance data structures and improve query efficiency for eligible users.

…ew API endpoints for canceling workflow supplements and backfilling attendance statuses. Enhance UI components for leave applications and attendance records to support new functionalities and improve user experience.

…nts for fetching candidates for leave cancellation and punch applications. Update UI components to include navigation for these new features. Enhance backend services to support workflow synchronization for leave cancellation and punch applications.

…ave and sick statuses. Refactor logic to determine related workflows and update UI components for better clarity. Introduce new methods for handling workflow data in the backend.

…uction environment, while commenting out the previous development URL for clarity.

…late and early leave. Update UI components for better user experience, including improved layout and data binding. Refactor related services to accommodate new features and ensure data integrity.

…tSystemFormView method. Update main.js and related component files to correct import paths for lf-pickup-code and lf-pickup-complete components. Add new attendance-related pages and update app configuration for improved functiona

…accurate computation based on 健康师's original labor costs. Added refund achievement tracking in daily report statistics for comprehensive performance analysis.

…. Added address input for store location retrieval, integrated Tencent Maps API for geolocation, and updated form fields to include longitude, latitude, and fence polygons. Adjusted dialog and layout for better usability.

…al chunk files and the main app script, to optimize application size and improve load times.

- Refactored multiple worker scripts (css.worker.js, editor.worker.js, html.worker.js, json.worker.js, ts.worker.js) for improved performance and maintainability.
- Removed the unused CSS file (app.26c706cb.css) to streamline the project structure and reduce unnecessary file bloat.

- Deleted an obsolete SQL file related to member information table modifications.
- Removed a hidden character from the ExcelImportHelper.cs file for cleaner code.

- Added functionality to convert solar birthdays to lunar format and display the corresponding lunar birthday in the customer detail dialog.
- Introduced a new dropdown for selecting lunar month and day in the customer form, allowing users to input lunar birthdays easily.
- Updated the customer service to handle birthday type differentiation (solar vs lunar) and ensure proper data handling.
- Enhanced the UI for better clarity and usability, including improved dialog styling and form section titles.
- Refactored related DTOs to accommodate the new birthday type and format changes.

- LqReportService: 门店基础信息/数据分析/对比分析 科技部归属及同组织门店改为 lq_md_target
- LqTechGeneralManagerSalaryService: 科技部总经理管理门店改为 lq_md_target 按统计月
- LqShareStatisticsTechDeptService: 科技部股份统计收入成本按 lq_md_target 取科技部门店
- LqZjlMdsmxszService: GetManagedStores 科技一部/二部门店改为 lq_md_target 按当前月
- LqAnnualSummaryService: 移除对 Kjb 的 Select 依赖
- 新增接口测试脚本 test-kjb-removal-apis.sh
- 新增 SQL: 根据产品平均单价更新库存领取金额

- Redesigned the welcome page layout with a new hero section and action cards for quick access to features.
- Added a feature list in the welcome component to dynamically render action cards.
- Updated the tech department dashboard to improve table display by reducing max height and ensuring proper pagination.
- Enhanced inventory service documentation for clarity on stock update processes.
- Introduced teacher performance metrics in the billing service for better reporting accuracy.

- 修复全员战报明细到店数统计问题：确保到店数不超过拓客数，同一会员多次到店只统计一次
- 修复全部门店开单记录汇总导出接口返回格式：使用统一的响应格式（code, msg, data）
- 添加 lq_xh_hyhk 表备注字段功能：支持备注字段的创建、更新、查询和导出
- 优化到店数统计SQL逻辑：先获取拓客会员列表（去重），再统计有到店记录的会员数