package com.lf.server.controller.data; import com.lf.server.annotation.SysLog; import com.lf.server.controller.all.BaseUploadController; import com.lf.server.entity.all.ResponseMsg; import com.lf.server.entity.ctrl.TabEntity; import com.lf.server.entity.ctrl.TabMapperEntity; import com.lf.server.entity.ctrl.UploadEntity; import com.lf.server.entity.data.MetaEntity; import com.lf.server.entity.sys.UserEntity; import com.lf.server.helper.StringHelper; import com.lf.server.helper.WebHelper; import com.lf.server.service.all.BaseQueryService; import com.lf.server.service.data.DataLoaderService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import java.util.Date; import java.util.List; /** * 数据入库 * @author WWW */ @Api(tags = "数据管理\\数据入库") @RestController @RequestMapping("/dataLoader") public class DataLoaderController extends BaseUploadController { @Autowired BaseQueryService baseQueryService; @Autowired DataLoaderService dataLoaderService; @SysLog() @ApiOperation(value = "查询所有表") @GetMapping(value = "/selectTabs") public ResponseMsg> selectTabs() { try { List list = baseQueryService.selectTabs(); return success(list); } catch (Exception ex) { return fail(ex.getMessage(), null); } } @SysLog() @ApiOperation(value = "查询映射") @ApiImplicitParams({ @ApiImplicitParam(name = "path", value = "路径", dataType = "String", paramType = "query") }) @GetMapping(value = "/selectMappers") public ResponseMsg> selectMappers(String path) { try { List list = dataLoaderService.selectMappers(path); return success(list); } catch (Exception ex) { return fail(ex.getMessage(), null); } } @SysLog() @ApiOperation(value = "插入文件") @ApiImplicitParams({ @ApiImplicitParam(name = "entity", value = "上传实体类", dataType = "UploadEntity", paramType = "body") }) @ResponseBody @PostMapping(value = "/insertFiles") public ResponseMsg insertFiles(@RequestBody UploadEntity entity, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue == null) { return fail("用户未登录", null); } if (null == entity || null == entity.getMetaEntity()) { return fail("元数据信息为空", null); } if (null == entity.getFileEntities() || entity.getFileEntities().isEmpty()) { return fail("没有找到上传文件", null); } MetaEntity me = entity.getMetaEntity(); me.setCreateTime(WebHelper.getCurrentTimestamp()); me.setBatch(StringHelper.YMDHMS_FORMAT.format(new Date(me.getCreateTime().getTime()))); me.setCreateUser(ue.getId()); dataLoaderService.insertFiles(me, entity.getFileEntities(), entity.getTabEntities()); return success("成功", entity.getTabEntities()); } catch (Exception ex) { return fail(ex.getMessage(), null); } } }