antissoft / lvqianmeiye_ERP

- 将硬编码的文件路径和月份改为可配置参数
- 添加命令行参数解析功能，支持自定义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.

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

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

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

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

- Updated the SaaS documentation to clarify the separation of core business modules.
- Enhanced the ImageModerationService for better error handling and configuration management.
- Improved code readability by removing unnecessary whitespace and optimizing LINQ queries in various services.
- Adjusted performance metrics calculations in the LqStoreDashboardService for accuracy in reporting.
- Updated DTOs to reflect changes in performance metrics definitions.

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

- Updated file upload methods to first save files locally before uploading to OSS.
- Added new methods for handling Base64 image uploads with local storage and OSS integration.
- Improved error handling and logging for file upload processes.
- Updated appsettings.json to include LocalFileBaseUrl for local file access.

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

- 修复科技部总经理工资计算中Cell金额计算逻辑
- 更新主任工资相关服务和前端页面
- 优化科技部老师工资计算逻辑
- 更新客户信息服务和报销申请服务
- 修复系统映射器和权限模型
- 完善工资管理前端页面显示

- 在IAuthorizeService接口中添加GetCurrentUserAppModuleAuthorize方法
- 在AuthorizeService中实现根据用户角色获取App权限的逻辑
- 在UsersCurrentService中添加GetAppAuthorize接口（GET /api/permission/Users/Current/AppAuthorize）
- 权限获取逻辑：根据用户角色从权限表中获取Category为'App'的模块权限
- 管理员返回所有App权限，普通用户返回角色权限
- 返回树形结构的App权限列表

其他修改：
- 更新门店看板相关功能
- 更新会员相关功能
- 更新样式文件

- 更新LqXhHyhkService服务
- 更新ConsumeItemDetailListOutput DTO
- 更新开发环境配置

…der person count and conversion rate metrics. Added logic to deduplicate order statistics by teacher ID, order date, and member ID, improving performance and data accuracy.

- 更新工资服务类和相关DTO输出类
- 涉及店助、总监、事业部经理、大项目总监、大项目老师、健康师、门店、技术总经理、科学老师等工资相关服务

- 将remarks中的```json代码块改为<code>标签（XML注释中不能使用```）
- 为所有缺少注释的接口添加了完整的summary和remarks
- 统一了所有9个工资服务确认接口的注释格式
- 包含示例请求、参数说明、注意事项等完整信息

修复的接口：
1. LqSalaryService (健康师)
2. LqTechTeacherSalaryService (科技部老师)
3. LqAssistantSalaryService (店助)
4. LqStoreManagerSalaryService (店长)
5. LqDirectorSalaryService (主任)
6. LqMajorProjectTeacherSalaryService (大项目老师)
7. LqMajorProjectDirectorSalaryService (大项目主管)
8. LqTechGeneralManagerSalaryService (科技部总经理)
9. LqBusinessUnitManagerSalaryService (事业部总经理)

- 在多个薪酬统计实体中新增员工确认状态、确认时间和确认备注字段
- 这些字段用于记录员工对薪酬数据的确认情况，提升数据管理的准确性和可追溯性
- 涉及的实体包括：LqAssistantSalaryStatisticsEntity, LqBusinessUnitManagerSalaryStatisticsEntity, LqDirectorSalaryStatisticsEntity, LqMajorProjectDirectorSalaryStatisticsEntity, LqMajorProjectTeacherSalaryStatisticsEntity, LqSalaryStatisticsEntity, LqStoreManagerSalaryStatisticsEntity, LqTechGeneralManagerSalaryStatisticsEntity, LqTechTeacherSalaryStatisticsEntity

- 新增事业部驾驶舱后端服务（LqBusinessUnitDashboardService）
- 实现15个事业部驾驶舱API接口（统计、趋势、排行榜等）
- 新增集团驾驶舱移动端页面（dashboard.vue）
- 集成图表功能（Canvas绘制趋势图）
- 优化页面样式设计（现代化UI、玻璃拟态效果）
- 完善KPI指标展示、会员统计、排行榜等功能
- 添加API模块（report.js）用于集团驾驶舱数据接口