| | |
| | | * @return 溢出的单位ID |
| | | */ |
| | | @Select("<script>" + |
| | | " select depid from ${tab} where depid > 0 and depid != ALL(fn_rec_array(#{depid}, 'dep'))" + |
| | | " select depid from ${tab} where depid is not null and depid not like '${depid}%'" + |
| | | " <if test='geoFilter != null'>" + |
| | | " and ${geoFilter}" + |
| | | " </if>" + |
| | | " group by depid" + |
| | | "</script>") |
| | | public List<Integer> selectDbOverflowDep(@Param("tab") String tab, @Param("depid") Integer depid, @Param("geoFilter") String geoFilter); |
| | | public List<Integer> selectDbOverflowDep(@Param("tab") String tab, @Param("depid") String depid, @Param("geoFilter") String geoFilter); |
| | | |
| | | /** |
| | | * 更新空间位置 |