【丽水】getDeptRanking 增加OrgId

陈昶聿

2 天以前 14f2352da6fc317cd0d5fad85f2d146fc1b6bc64

【丽水】getDeptRanking 增加OrgId

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedInhospController.java

@@ -196,6 +196,7 @@
     * @return
     */
    @ApiOperation("各科室服务人次")
    @AddOrgId(field = "orgid", paramIndex = 0, campusField = "campusid")
    @PostMapping("/getDeptRanking")
    public TableDataInfo getDeptRanking(@RequestBody PatMedReq patMedReq) {
        return getDataTable(patMedInhospService.getDeptRanking(patMedReq));

 smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml

@@ -1894,6 +1894,9 @@
        FROM service_subtask
        WHERE DATE_FORMAT(finishtime, '%Y-%m-%d') >= #{startDate}
          AND DATE_FORMAT(finishtime, '%Y-%m-%d') <= #{endDate}
        <if test="orgid != null">
            AND orgid = #{orgid}
        </if>
        GROUP BY deptname
    </select>