# DataWasher **Repository Path**: mmxx0212/data-washer ## Basic Information - **Project Name**: DataWasher - **Description**: No description available - **Primary Language**: C# - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 2 - **Created**: 2024-12-11 - **Last Updated**: 2024-12-11 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # DataWasher #### 介绍 该解决方案包含两个webapi:DataWasher.WebApi和Report.WebApi。 1.DataWasher.WebApi 主要用于数据的抽取，支持不同的datasource:sqlserver,storage,mysql.抽取后的数据经过初步的整合以json格式存储到storage中作为rawdata,为下一步整合提供元数据。 2.Report.WebApi 主要用于读取第二步整合后的数据。根据前段不同报表模块的请求，读取相应的数据返回。 #### 软件架构 软件架构说明 1. DataWasher.WebApi 1.1 Interfaces 文件夹中包含不同的datasource的操作接口(sersqlserver,storage,mysql)、Logger的处理接口、Service的接口以及DatasourceProvider的接口。Services中是业务逻辑处理层。 1.2 Controller中是不同接口的处理入口。 1.3 相应功能处理模块需要继续添加--TBD 2. Report.WebApi 2.1 Interfaces文件夹中包含不同service的业务逻辑以及Logger的处理接口。 2.2 Controller中是不同接口的处理入口。 2.3 相应功能处理模块需要继续添加--TBD #### 使用说明 TBD #### 参与贡献 1. Fork 本仓库 2. 新建 Feat_xxx 分支 3. 提交代码 4. 新建 Pull Request #### Report.WebApi 接口契约 1. 完成率 **数据类型**：比率 **Method**:HttpGet **Url** :api/completerate/dealerCode/datefilter **Response**:{"status":200,"res":{"dealercode":"供应商1","datefilter":"2021-03-31","rate":0.84},"msg":""} 2. 返修率 **数据类型**：比率 **Method**:HttpGet **Url** :api/rework/dealerCode/datefilter **Response**:{"status":200,"res":{"dealercode":"供应商1","datefilter":"2021-03-31","rate":0.84},"msg":""} 3. 返修申请量同比增长率 **数据类型**：同比 **Method**:HttpGet **Url** :api/reworkupgrowth/dealerCode/datefilter **Response**:{"status":200,"res":{"dealercode":"供应商1","datefilter":"2021-03-31","rate":0.84},"msg":""} 4. 申请项 **数据类型**：计数 **Method**:HttpGet **Url** :api/applyitems/area/store/datefilter/maintenance **Response**:{"status":200,"res":{"area":"东区","datefilter":"2021-03-31","count":0.84,"maintenance":["维修项一","维修项二"]},"msg":""} 5. 申请项同比增长 **数据类型**：同比 **Method**:HttpGet **Url** :api/applyitemsupgrowth/area/store/datefilter/maintenance **Response**:{"status":200,"res":{"area":"东区","datefilter":"2021-03-31","rate":0.84,"maintenance":["维修项一","维修项二"]},"msg":""} 6. 申请项环比增长 **数据类型**：环比 **Method**:HttpGet **Url** :api/applyitemschiangrowth/area/store/datefilter/maintenance **Response**:{"status":200,"res":{"area":"东区","datefilter":"2021-03-31","rate":0.84,"maintenance":["维修项一","维修项二"]},"msg":""} 7. 店平均申请项 **数据类型**：平均 **Method**:HttpGet **Url** :api/storeavg/datefilter **Response**:{"status":200,"res":{"avg":3.2,"datefilter":"2021-03-31"},"msg":""} 8. 维修问题申请项(按维修类别) **数据类型**：计数 **Method**:HttpGet **Url** :api/Maintenanceissues/datefilter **Response**:{"status":200,"res":{"count":3.2,"datefilter":"2021-03-31"},"msg":""} 9. 维修问题申请比例(按维修类别) **数据类型**：比例 **Method**:HttpGet **Url** :api/Maintenanceissuesrate/datefilter **Response**:{"status":200,"res":{"rate":0.2,"datefilter":"2021-03-31"},"msg":""} 10. 门店验收时长 **数据类型**：分布数据 **Method**:HttpGet **Url** :api/Acceptance **Response**:{"status":200,"res":{"acceptanceTime":2(天)},"msg":""} 11. 维修成本 **数据类型**：计数 **Method**:HttpGet **Url** :api/maintenancecost/area/dealercode/store/maintenance **Response**:{"status":200,"res":{"count":3,"area":"东区","dealercode":"供应商1","store":"店铺1","maintenance":["维修项1"]},"msg":""} 12. 维修成本同比增长率 **数据类型**：同比 **Method**:HttpGet **Url** :api/maintenancecostupgrowth/area/dealercode/store/maintenance **Response**:{"status":200,"res":{"rate":0.3,"area":"东区","dealercode":"供应商1","store":"店铺1","maintenance":["维修项1"]},"msg":""} 13. 维修成本环比增长率 **数据类型**：环比 **Method**:HttpGet **Url** :api/maintenancecostchiangrowth/area/dealercode/store/maintenance **Response**:{"status":200,"res":{"rate":0.3,"area":"东区","dealercode":"供应商1","store":"店铺1","maintenance":["维修项1"]},"msg":""} 14. 店平均维修成本 **数据类型**：平均数 **Method**:HttpGet **Url** :api/maintenancecostavg/datefilter **Response**:{"status":200,"res":{"avg":0.3},"msg":""} 15. 维修成本分布比例(按维修类别) **数据类型**：比例 **Method**:HttpGet **Url** :api/maintenancecostrate/datefilter **Response**:{"status":200,"res":{"rate":0.3},"msg":""} 16. 审批时长 **数据类型**：分布数据 **Method**:HttpGet **Url** :api/approvetime **Response**:{"status":200,"res":{"period":2(天)},"msg":""} 17. 接单量 **数据类型**：计数 **Method**:HttpGet **Url** :api/receivecount/dealercode **Response**:{"status":200,"res":{"count":200},"msg":""} 18. 服务种类 **数据类型**：计数 **Method**:HttpGet **Url** :api/servicecategory/dealercode **Response**:{"status":200,"res":{"count":200},"msg":""} 19. 接单量同比增长率 **数据类型**：同比 **Method**:HttpGet **Url** :api/receiveupgrowth/area/store/datefilter/maintenance **Response**:{"status":200,"res":{"rate":200},"msg":""} 20. 维修申请接收总量环比增长率 **数据类型**：环比 **Method**:HttpGet **Url** :api/maintanceapplychiangrowth/area/store/datefilter/maintenance **Response**:{"status":200,"res":{"rate":200},"msg":""} 21. 供应商派工时长 **数据类型**：分布数据 **Method**:HttpGet **Url** :api/sendticket/avg/dealercode **Response**:{"status":200,"res":{"duration":20(min)},"msg":""} 22. 单据完成时间 **数据类型**：分布数据 **Method**:HttpGet **Url** :api/Completiontime/dealercode **Response**:{"status":200,"res":{"duration":20(min)},"msg":""} 23. 维修申请完成量 **数据类型**：计数 **Method**:HttpGet **Url** :api/maintanceCompletion/dealercode **Response**:{"status":200,"res":{"count":20},"msg":""} 24. 维修申请完成量 **数据类型**：计数 **Method**:HttpGet **Url** :api/maintanceCompletion/dealercode **Response**:{"status":200,"res":{"count":20},"msg":""} 25. 返修申请量环比增长率 **数据类型**：环比 **Method**:HttpGet **Url** :api/reworkapplychiangrowth/area/store/datefilter/maintenance **Response**:{"status":200,"res":{"rate":0.8},"msg":""} 26. 超期率 **数据类型**：比率 **Method**:HttpGet **Url** :api/overduerate/area/dealercode **Response**:{"status":200,"res":{"rate":0.8},"msg":""} 27. 超期申请量 **数据类型**：计数 **Method**:HttpGet **Url** :api/overduecount/area/dealercode **Response**:{"status":200,"res":{"count":8},"msg":""} 28. 超期申请量同比增长率 **数据类型**：同比 **Method**:HttpGet **Url** :api/overdueupgrowth/area/dealercode **Response**:{"status":200,"res":{"rate":0.8},"msg":""} 29. 超期申请量环比增长率 **数据类型**：环比 **Method**:HttpGet **Url** :api/overduechiangrowth/area/dealercode **Response**:{"status":200,"res":{"rate":0.8},"msg":""} 30. 维修质量平均分 **数据类型**：平均数 **Method**:HttpGet **Url** :api/maintancequitry/avg/dealercode **Response**:{"status":200,"res":{"score":0.8},"msg":""} 31. 维修速度平均分 **数据类型**：平均数 **Method**:HttpGet **Url** :api/maintancespeed/avg/dealercode **Response**:{"status":200,"res":{"score":0.8},"msg":""} 32. 服务态度平均分 **数据类型**：平均数 **Method**:HttpGet **Url** :api/serviceattitude/avg/dealercode **Response**:{"status":200,"res":{"score":0.8},"msg":""} 33. 服务质量综合得分 **数据类型**：平均数 **Method**:HttpGet **Url** :api/serviceaquitry/avg/dealercode **Response**:{"status":200,"res":{"score":0.8},"msg":""}