antissoft / lvqianmeiye_ERP

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

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

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

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

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

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

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.

- Swapped the API base URL in the development environment to use localhost for local testing.
- Enhanced the member portrait dialog with improved layout and additional member attributes, including age and birthday type.
- Added birthday type filtering options in the birthday view, allowing users to display members with solar and lunar birthdays.
- Updated the backend to support querying members based on specified date ranges and birthday types.
- Introduced new performance metrics in the personal performance statistics view, categorizing performance by various service types.

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

- Introduced a dropdown for column settings in list view, allowing users to customize visible columns and their order via drag-and-drop.
- Updated table columns to dynamically render based on user-selected visibility, improving the overall user experience.
- Enhanced the display of customer information, including merging customer name and ID, and added tooltips for better clarity.
- Refactored existing table columns to utilize a more flexible structure for rendering based on visibility settings.

- Introduced a new filter for remaining rights range in the member portrait dialog and query input DTO.
- Implemented a resetData method to clear all data when switching members to prevent displaying stale information.
- Updated the fetchData method to clear lists upon member change.
- Enhanced the LqKhxxService to handle remaining rights range in queries.
- Improved the layout of the search form in the lqKhxx view for better usability.

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

- Refactored multiple worker scripts (css.worker.js, editor.worker.js, html.worker.js, json.worker.js, ts.worker.js) to improve code structure and maintainability.
- Removed the unused CSS file (app.26c706cb.css) to clean up the project and reduce bundle size.
- Ensured all worker scripts are optimized for better performance.