02a9393ac8c0589df665445f8af101d70f259d6b.svn-base 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180
  1. package ${bussiPackage}.${entityPackage}.controller;
  2. import java.util.Arrays;
  3. import java.util.List;
  4. import java.util.Map;
  5. import java.util.stream.Collectors;
  6. import java.io.IOException;
  7. import java.io.UnsupportedEncodingException;
  8. import java.net.URLDecoder;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import org.jeecg.common.api.vo.Result;
  12. import org.jeecg.common.system.query.QueryGenerator;
  13. import org.jeecg.common.util.oConvertUtils;
  14. import ${bussiPackage}.${entityPackage}.entity.${entityName};
  15. import ${bussiPackage}.${entityPackage}.service.I${entityName}Service;
  16. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  17. import com.baomidou.mybatisplus.core.metadata.IPage;
  18. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  19. import lombok.extern.slf4j.Slf4j;
  20. import org.jeecgframework.poi.excel.ExcelImportUtil;
  21. import org.jeecgframework.poi.excel.def.NormalExcelConstants;
  22. import org.jeecgframework.poi.excel.entity.ExportParams;
  23. import org.jeecgframework.poi.excel.entity.ImportParams;
  24. import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
  25. import org.jeecg.common.system.base.controller.JeecgController;
  26. import org.springframework.beans.factory.annotation.Autowired;
  27. import org.springframework.web.bind.annotation.*;
  28. import org.springframework.web.multipart.MultipartFile;
  29. import org.springframework.web.multipart.MultipartHttpServletRequest;
  30. import org.springframework.web.servlet.ModelAndView;
  31. import com.alibaba.fastjson.JSON;
  32. import io.swagger.annotations.Api;
  33. import io.swagger.annotations.ApiOperation;
  34. import org.jeecg.common.aspect.annotation.AutoLog;
  35. <#assign bpm_flag=false>
  36. <#list originalColumns as po>
  37. <#if po.fieldDbName=='bpm_status'>
  38. <#assign bpm_flag=true>
  39. </#if>
  40. </#list>
  41. /**
  42. * @Description: ${tableVo.ftlDescription}
  43. * @Author: jeecg-boot
  44. * @Date: ${.now?string["yyyy-MM-dd"]}
  45. * @Version: V1.0
  46. */
  47. @Api(tags="${tableVo.ftlDescription}")
  48. @RestController
  49. @RequestMapping("/${entityPackage}/${entityName?uncap_first}")
  50. @Slf4j
  51. public class ${entityName}Controller extends JeecgController<${entityName}, I${entityName}Service> {
  52. @Autowired
  53. private I${entityName}Service ${entityName?uncap_first}Service;
  54. /**
  55. * 分页列表查询
  56. *
  57. * @param ${entityName?uncap_first}
  58. * @param pageNo
  59. * @param pageSize
  60. * @param req
  61. * @return
  62. */
  63. @AutoLog(value = "${tableVo.ftlDescription}-分页列表查询")
  64. @ApiOperation(value="${tableVo.ftlDescription}-分页列表查询", notes="${tableVo.ftlDescription}-分页列表查询")
  65. @GetMapping(value = "/list")
  66. public Result<?> queryPageList(${entityName} ${entityName?uncap_first},
  67. @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
  68. @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
  69. HttpServletRequest req) {
  70. QueryWrapper<${entityName}> queryWrapper = QueryGenerator.initQueryWrapper(${entityName?uncap_first}, req.getParameterMap());
  71. Page<${entityName}> page = new Page<${entityName}>(pageNo, pageSize);
  72. IPage<${entityName}> pageList = ${entityName?uncap_first}Service.page(page, queryWrapper);
  73. return Result.OK(pageList);
  74. }
  75. /**
  76. * 添加
  77. *
  78. * @param ${entityName?uncap_first}
  79. * @return
  80. */
  81. @AutoLog(value = "${tableVo.ftlDescription}-添加")
  82. @ApiOperation(value="${tableVo.ftlDescription}-添加", notes="${tableVo.ftlDescription}-添加")
  83. @PostMapping(value = "/add")
  84. public Result<?> add(@RequestBody ${entityName} ${entityName?uncap_first}) {
  85. <#if bpm_flag>
  86. ${entityName?uncap_first}.setBpmStatus("1");
  87. </#if>
  88. ${entityName?uncap_first}Service.save(${entityName?uncap_first});
  89. return Result.OK("添加成功!");
  90. }
  91. /**
  92. * 编辑
  93. *
  94. * @param ${entityName?uncap_first}
  95. * @return
  96. */
  97. @AutoLog(value = "${tableVo.ftlDescription}-编辑")
  98. @ApiOperation(value="${tableVo.ftlDescription}-编辑", notes="${tableVo.ftlDescription}-编辑")
  99. @PostMapping(value = "/edit")
  100. public Result<?> edit(@RequestBody ${entityName} ${entityName?uncap_first}) {
  101. ${entityName?uncap_first}Service.updateById(${entityName?uncap_first});
  102. return Result.OK("编辑成功!");
  103. }
  104. /**
  105. * 通过id删除
  106. *
  107. * @param id
  108. * @return
  109. */
  110. @AutoLog(value = "${tableVo.ftlDescription}-通过id删除")
  111. @ApiOperation(value="${tableVo.ftlDescription}-通过id删除", notes="${tableVo.ftlDescription}-通过id删除")
  112. @PostMapping(value = "/delete")
  113. public Result<?> delete(@RequestParam(name="id",required=true) String id) {
  114. ${entityName?uncap_first}Service.removeById(id);
  115. return Result.OK("删除成功!");
  116. }
  117. /**
  118. * 批量删除
  119. *
  120. * @param ids
  121. * @return
  122. */
  123. @AutoLog(value = "${tableVo.ftlDescription}-批量删除")
  124. @ApiOperation(value="${tableVo.ftlDescription}-批量删除", notes="${tableVo.ftlDescription}-批量删除")
  125. @PostMapping(value = "/deleteBatch")
  126. public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
  127. this.${entityName?uncap_first}Service.removeByIds(Arrays.asList(ids.split(",")));
  128. return Result.OK("批量删除成功!");
  129. }
  130. /**
  131. * 通过id查询
  132. *
  133. * @param id
  134. * @return
  135. */
  136. @AutoLog(value = "${tableVo.ftlDescription}-通过id查询")
  137. @ApiOperation(value="${tableVo.ftlDescription}-通过id查询", notes="${tableVo.ftlDescription}-通过id查询")
  138. @GetMapping(value = "/queryById")
  139. public Result<?> queryById(@RequestParam(name="id",required=true) String id) {
  140. ${entityName} ${entityName?uncap_first} = ${entityName?uncap_first}Service.getById(id);
  141. if(${entityName?uncap_first}==null) {
  142. return Result.error("未找到对应数据");
  143. }
  144. return Result.OK(${entityName?uncap_first});
  145. }
  146. /**
  147. * 导出excel
  148. *
  149. * @param request
  150. * @param ${entityName?uncap_first}
  151. */
  152. @RequestMapping(value = "/exportXls")
  153. public ModelAndView exportXls(HttpServletRequest request, ${entityName} ${entityName?uncap_first}) {
  154. return super.exportXls(request, ${entityName?uncap_first}, ${entityName}.class, "${tableVo.ftlDescription}");
  155. }
  156. /**
  157. * 通过excel导入数据
  158. *
  159. * @param request
  160. * @param response
  161. * @return
  162. */
  163. @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
  164. public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
  165. return super.importExcel(request, response, ${entityName}.class);
  166. }
  167. }