antissoft / lvqianmeiye_ERP

- 登录页设为启动页并统一 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>

移除扫码入职的入职/用工填报改由人事审核填写，修复退卡/客户导出筛选与 H5 构建同步，新增小程序更新提示与金三角绑定兜底，并补充 2026-07-29 更新说明。

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(.cursor): 更新数据库连接配置并添加业务操作日志规范

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

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.

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

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

- Added a new endpoint to fix duplicate inventory usage records by merging entries based on UsageBatchId, ProductId, and StoreId.
- Implemented logic to retain the earliest record while summing quantities and amounts, marking others as invalid.
- Enhanced the service to log the repair process and provide feedback on the number of processed and invalidated records.

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

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

- Updated the file upload process to include image moderation before uploading to OSS.
- Added configuration options for enabling/disabling image moderation and specifying the moderation service endpoint.
- Enhanced the FileService to handle local file storage and moderation logic, ensuring compliance with content policies.
- Updated .env and appsettings.json to reflect new configuration settings for the image moderation feature.

- 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逻辑：先获取拓客会员列表（去重），再统计有到店记录的会员数

1. 工资查询接口优化：
   - 修改所有9个薪酬服务的员工工资查询接口
   - 只能查询已锁定且未确认的工资（IsLocked=1 && EmployeeConfirmStatus!=1）
   - 员工确认工资后无法再次查看
   - 更新接口注释说明新的查询逻辑

2. 用户列表接口增强：
   - 添加门店ID（mdid）搜索功能
   - 添加岗位（gw）搜索功能
   - 添加启用状态（enabledMark）筛选功能
   - 支持组合搜索（门店ID+岗位+状态）

3. 文档和测试：
   - 新增员工工资查询接口逻辑梳理文档
   - 新增用户列表搜索功能测试脚本

- 修改店长工资计算：产品物料基于领取时间，只统计已领取记录
- 修改主任工资计算：产品物料基于领取时间，只统计已领取记录
- 修改事业部总经理/经理工资计算：产品物料基于领取时间，只统计已领取记录
- 修改门店股份统计：产品成本和福田成本基于领取时间，只统计已领取记录
- 新增数据核对报告和SQL更新脚本

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