antissoft / lvqianmeiye_ERP

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.

- Added new settings in project.config.json for improved build options.
- Enhanced salary calculation services to include conditions for user eligibility based on entry and leave dates across multiple service files.
- Updated various UI components to improve user experience and added new options in member source selections.

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.

…bility. Update leave application UI components for better user experience, including renaming titles and restructuring layout for clarity. Introduce new methods for quota summary extraction and normalization in the quota summary service.

…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

…es under a unified directory. Update references to documentation and scripts to reflect new paths. Remove outdated documents related to billing discrepancies and image upload processes to streamline project resources.

…date input model to include new fields for min/max billing amounts and actual billing amounts. Refactor search and sorting logic in LqStatisticsService for enhanced data retrieval.

…port both member ID and archive number for improved data retrieval. Implement billing, consumption, and refund statistics aggregation to avoid N+1 issues, ensuring accurate financial summaries for members.

… for local testing. Adjusted CSS worker files and added new app styles for improved layout and user experience.

…ll data is exported without pagination. Enhance error handling for total amount validation to support negative values and various formats. Add a new method for parsing decimal values, accommodating accounting formats. Update documentation for clarity on export parameters and import requirements.