-
- 新增BillingProjectCount和ConsumeProjectCount字段到EmployeePerformanceStatisticsOutput - 新增GetBillingProjectCount方法统计开单项目数 - 新增GetConsumeProjectCount方法统计消耗项目数 - 通过项目编号(px)去重统计项目数 - 更新API注释,添加新字段说明
-
主要变更: 1. 修复人次统计逻辑,改为使用客户ID和日期的组合去重(COUNT(DISTINCT CONCAT(hy, '-', DATE(hksj)))) 2. 新增员工业绩统计接口GetEmployeePerformanceStatistics,支持查询员工在指定月份的完整业绩数据 3. 修复品项统计的门店过滤问题,使用SqlFunc.Subqueryable避免别名冲突 4. 修复门店顾客详情SQL字段错误(F_Status改为yysj,F_CreateTime改为kdrq/hksj) 5. 新增员工业绩统计输入输出DTO类 功能特性: - 支持查询员工的拓客、邀约、预约、开单、消耗、退卡、人头、人次等完整统计 - 所有SQL改为字符串拼接方式,确保参数正确传递 - 分步统计设计,便于维护和优化
-
- Added refund performance and count fields to personal and store total performance statistics. - Introduced actual performance calculations that account for refunds. - Updated relevant DTOs and entity classes to include new fields. - Improved front-end tables to display refund-related data in performance statistics views.
-
- 新增 BillingRecordSummaryQueryInput 查询参数类 - 新增 LqKdKdjlbUpdateAmountInput 修改金额输入类 - 完善 GetBillingRecordSummaryByStoreId 方法,支持按来源类型分类品项明细 - 优化 LqXmzlService 字段去重查询功能 - 完善 LqPackageInfoService 营销活动品项详情查询 - 更新相关实体和DTO字段映射
-
- 在LqKdKdjlbService中添加逻辑以批量查询开单记录的品项明细 - 为每个开单记录分配对应的品项明细,确保数据完整性 - 更新LqKdKdjlbListOutput DTO以包含品项明细列表 - 优化前端Vue组件以展示新增的品项明细信息
-
- 修复LqZjlMdsmxszService.GetPageList接口的排序规则冲突 - 修复LqStatisticsService中工资统计相关的排序规则冲突 - 在涉及lq_kd_kdjlb表的JOIN操作中添加COLLATE子句 - 更新UpdateSalaryStatisticsFromOtherTables方法中的COLLATE子句 - 创建修复排序规则冲突的精简版SQL脚本
-
…d completion statistics. Introduce new LqStatisticsService methods for saving and querying technology department performance statistics. Update LqTkjlbService to associate member information with store IDs. Refactor LqKdKdjlbStringGenerator for cleaner output formatting.
-
…trieval endpoints, enhancing performance with database aggregation. Introduce personal performance statistics handling, including saving and querying capabilities. Update LqYcsdJsjService to temporarily disable T area creation logic pending business confirmation.
-
…es; add manual time field settings to preserve time accuracy; implement GetEventTypes endpoint to retrieve event type enumeration; update LqTkjlb DTO to include eventId and eventName for better tracking of related events.
-
…thods in LqStatisticsService to enhance accessibility for API endpoints.
-
…和科技部老师业绩统计功能,优化查询逻辑和代码结构,确保代码整洁性和功能完整性。