package com.moon.server.controller.data; import com.moon.server.annotation.SysLog; import com.moon.server.controller.all.BaseController; import com.moon.server.entity.all.ResponseMsg; import com.moon.server.entity.ctrl.PubEntity; import com.moon.server.entity.data.MetaEntity; import com.moon.server.entity.data.PublishEntity; import com.moon.server.entity.sys.UserEntity; import com.moon.server.helper.StringHelper; import com.moon.server.service.all.PermsService; import com.moon.server.service.data.PublishService; import com.moon.server.service.data.ShuJianService; import com.moon.server.service.sys.TokenService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.List; /** * 数据发布 * @author WWW */ @Api(tags = "数据管理\\发布管理") @RestController @RequestMapping("/publish") public class PublishController extends BaseController { @Resource PublishService publishService; @Resource TokenService tokenService; @Resource PermsService permsService; @Resource ShuJianService shuJianService; @SysLog() @ApiOperation(value = "分页查询元数据") @ApiImplicitParams({ @ApiImplicitParam(name = "depcode", value = "单位编码", dataType = "String", paramType = "query", example = "00"), @ApiImplicitParam(name = "dircode", value = "目录编码", dataType = "String", paramType = "query", example = "01"), @ApiImplicitParam(name = "verid", value = "版本ID", dataType = "Integer", paramType = "query", example = "0"), @ApiImplicitParam(name = "type", value = "类别", dataType = "String", paramType = "query", example = "DOM"), @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = ""), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectMetasByPage") public ResponseMsg selectMetasByPage(String depcode, String dircode, Integer verid, String type, String name, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } if (StringHelper.isEmpty(type)) { return fail("数据类别为空", null); } String types = getType(type); int count = publishService.selectMetasByCount(depcode, dircode, verid, types, name); if (count == 0) { return success(0, null); } List rs = publishService.selectMetasByPage(depcode, dircode, verid, types, name, pageSize, pageSize * (pageIndex - 1)); return success(count, rs); } catch (Exception ex) { return fail(ex.getMessage(), null); } } /** * 获取类型 */ private String getType(String type) throws Exception { switch (type) { case "DOM": return "type in ('tif', 'tiff', 'img', 'jp2', 'jpg') and mata_type in (1, 3, 4, 5)"; case "DEM": return "type in ('tif', 'tiff', 'dem') and mata_type = 2"; case "Vector": return "type in ('shp', 'gdb') and mata_type = 6"; case "Model": return "type in ('ifc', 'gdb') and mata_type = 7"; default: throw new Exception("数据类型不匹配"); } } @SysLog() @ApiOperation(value = "分页查询并返回记录数") @ApiImplicitParams({ @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = ""), @ApiImplicitParam(name = "dircode", value = "目录", dataType = "String", paramType = "query", example = ""), @ApiImplicitParam(name = "type", value = "类别", dataType = "String", paramType = "query", example = ""), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectByPageAndCount") public ResponseMsg> selectByPageAndCount(String name, String dircode, String type, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } type = getPubType(type); int count = publishService.selectCount(name, dircode, type); if (count == 0) { return success(0, null); } List rs = publishService.selectByPage(name, dircode, type, pageSize, pageSize * (pageIndex - 1)); return success(count, rs); } catch (Exception ex) { return fail(ex.getMessage(), null); } } /** * 获取发布类型 */ private String getPubType(String type) throws Exception { if (StringHelper.isEmpty(type)) { return null; } switch (type) { case "DOM": return "type = 'DOM'"; case "DEM": return "type = 'DEM'"; case "Vector": return "type = 'Vector'"; case "Model": return "type = 'Model'"; default: throw new Exception("数据类型不匹配"); } } @SysLog() @ApiOperation(value = "根据ID查询") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "ID", dataType = "int", paramType = "query", example = "1") }) @GetMapping(value = "/selectById") public ResponseMsg selectById(int id) { try { PublishEntity entity = publishService.selectById(id); return success(entity); } catch (Exception ex) { return fail(ex.getMessage(), null); } } @SysLog() @ApiOperation(value = "分页查询数简的颜色表") @ApiImplicitParams({ @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "int", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "int", paramType = "query", example = "1") }) @GetMapping(value = "/selectSjColorTables") public void selectSjColorTables(int pageSize, int pageIndex, HttpServletRequest req, HttpServletResponse res) { pageIndex = Math.max(pageIndex, 1); pageSize = Math.max(pageSize, 5); shuJianService.selectSjColorTables(pageSize, pageIndex, req, res); } @SysLog() @ApiOperation(value = "插入数简服务") @ApiImplicitParams({ @ApiImplicitParam(name = "entity", value = "实体类", dataType = "PubEntity", paramType = "body") }) @ResponseBody @PostMapping(value = "/insertSjService", produces = "application/json; charset=UTF-8") public ResponseMsg insertSjService(@RequestBody PubEntity entity, HttpServletRequest req, HttpServletResponse res) { try { if (null == entity || null == entity.getIds() || entity.getIds().isEmpty()) { return fail("实体类为空或找不到元数据ID", 0); } if (StringHelper.isEmpty(entity.getType())) { return fail("发布类别为空", null); } if (!ShuJianService.TYPES.contains(entity.getType())) { return fail("发布类别不支持", null); } UserEntity ue = tokenService.getCurrentUser(req); if (null != ue) { entity.setUserId(ue.getId()); entity.setDepcode(ue.getDepcode()); } permsService.clearPermsCache(); Integer rows = shuJianService.insertSjService(entity); return success(rows); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } @SysLog() @ApiOperation(value = "更新数简服务") @ApiImplicitParams({ @ApiImplicitParam(name = "entity", value = "实体类", dataType = "PubEntity", paramType = "body") }) @ResponseBody @PostMapping(value = "/updateSjService", produces = "application/json; charset=UTF-8") public ResponseMsg updateSjService(@RequestBody PubEntity entity, HttpServletRequest req, HttpServletResponse res) { try { if (null == entity || null == entity.getPubid()) { return fail("实体类为空或发布ID为空", 0); } if (StringHelper.isEmpty(entity.getType())) { return fail("发布类别为空", null); } UserEntity ue = tokenService.getCurrentUser(req); if (null != ue) { entity.setUserId(ue.getId()); entity.setDepcode(ue.getDepcode()); } permsService.clearPermsCache(); Integer rows = shuJianService.updateSjService(entity, req, res); return success(rows); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } @SysLog() @ApiOperation(value = "删除数简服务") @ApiImplicitParams({ @ApiImplicitParam(name = "ids", value = "ID数组", dataType = "Integer", paramType = "query", allowMultiple = true, example = "1") }) @GetMapping(value = "/deletes") public ResponseMsg deletesSjServices(@RequestParam List ids) { try { if (null == ids || ids.isEmpty()) { return fail("id数组不能为空", -1); } permsService.clearPermsCache(); int count = shuJianService.deletesSjServices(ids); return success(count); } catch (Exception ex) { return fail(ex.getMessage(), -1); } } }