1

13693261870

2023-03-03 cc3d237b380bc30be21f7cb5d8c6fb9b3d617fe3

1

 src/main/java/com/lf/server/controller/all/BaseQueryController.java

@@ -19,6 +19,7 @@
import com.lf.server.mapper.all.BasicMapper;
import com.lf.server.mapper.all.GeomBaseMapper;
import com.lf.server.service.all.BaseQueryService;
import com.lf.server.service.data.DictService;
import com.lf.server.service.data.DirService;
import com.lf.server.service.data.DownloadService;
import com.lf.server.service.data.MetaService;
@@ -64,6 +65,9 @@

    @Autowired
    BaseQueryService baseQueryService;

    @Autowired
    DictService dictService;

    @SysLog()
    @ApiOperation(value = "查询记录数")
@@ -266,10 +270,13 @@

    @SysLog()
    @ApiOperation(value = "查询所有表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = "点")
    })
    @GetMapping(value = "/selectTabs")
    public ResponseMsg<List<TabEntity>> selectTabs() {
    public ResponseMsg<List<TabEntity>> selectTabs(String name) {
        try {
            List<TabEntity> list = baseQueryService.selectTabs();
            List<TabEntity> list = dictService.selectDictTab(name);

            return success(list);
        } catch (Exception ex) {

 src/main/java/com/lf/server/controller/data/upload/QueryController.java

@@ -53,6 +53,9 @@
    @Autowired
    protected BaseQueryService baseQueryService;

    @Autowired
    DictService dictService;

    @SysLog()
    @ApiOperation(value = "根据父ID分页查询并返回记录数")
    @ApiImplicitParams({
@@ -164,10 +167,13 @@

    @SysLog()
    @ApiOperation(value = "查询所有表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = "点")
    })
    @GetMapping(value = "/selectTabs")
    public ResponseMsg<List<TabEntity>> selectTabs() {
    public ResponseMsg<List<TabEntity>> selectTabs(String name) {
        try {
            List<TabEntity> list = baseQueryService.selectTabs();
            List<TabEntity> list = dictService.selectDictTab(name);

            return success(list);
        } catch (Exception ex) {

 src/main/java/com/lf/server/mapper/all/BaseQueryMapper.java

@@ -34,13 +34,6 @@
    public List<IdNameEntity> selectDepFuzzy(String name);

    /**
     * 查询所有表
     *
     * @return
     */
    public List<TabEntity> selectTabs();

    /**
     * 根据表名查询记录数
     *
     * @param tab 表名

 src/main/java/com/lf/server/service/all/BaseQueryService.java

@@ -223,11 +223,6 @@
    }

    @Override
    public List<TabEntity> selectTabs() {
        return baseQueryMapper.selectTabs();
    }

    @Override
    public Integer selectTabsForCount(String tab) {
        tab = StringHelper.getLikeStr(tab);


 src/main/resources/mapper/all/BaseQueryMapper.xml

@@ -21,10 +21,6 @@
        order by order_num limit 10
    </select>

    <select id="selectTabs" resultType="com.lf.server.entity.ctrl.TabEntity">
      select distinct ns,tab,fn_get_entity(tab) entity,tab_desc,tableType from lf.sys_dict order by tab
    </select>

    <select id="selectTabsForCount" resultType="java.lang.Integer">
        select count(distinct tab) from lf.sys_dict
        <where>

 src/main/resources/mapper/data/DictMapper.xml

@@ -38,7 +38,7 @@
    </select>

    <select id="selectDictTab" resultType="com.lf.server.entity.ctrl.TabEntity">
        select ns, tab, tab_desc, fn_get_entity(tab) entity, bak
        select ns, tab, tab_desc, fn_get_entity(tab) entity, tableType, bak
        from lf.sys_dict
        <where>
            field = 'gid' and status = 0