antissoft / lvqianmeiye_ERP

- 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>

- 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

…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.

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

…. 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.

…etter user experience, added map location feature with longitude and latitude inputs, and improved fence status display. Adjusted dialog width for improved visibility.

…ns for management backend and store PC applications, updated environment variables for local development, and removed unused CSS and JS files to optimize the build.

…application size and improve load times. This includes several chunk files and the main app script.

- 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.