RMScontroller.java 67 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236
  1. package com.steerinfo.dil.controller;
  2. import com.alibaba.fastjson.JSONObject;
  3. import com.steerinfo.dil.annotaion.LogAround;
  4. import com.steerinfo.dil.annotaion.RequestLimit;
  5. import com.steerinfo.dil.feign.RmsFeign;
  6. import com.steerinfo.dil.util.BaseRESTfulController;
  7. import com.steerinfo.dil.util.ExcelToolUtils;
  8. import com.steerinfo.dil.util.PageListAdd;
  9. import com.steerinfo.framework.controller.BaseController;
  10. import com.steerinfo.framework.controller.RESTfulResult;
  11. import com.steerinfo.framework.service.pagehelper.PageHelper;
  12. import io.swagger.annotations.ApiImplicitParam;
  13. import io.swagger.annotations.ApiImplicitParams;
  14. import io.swagger.annotations.ApiOperation;
  15. import lombok.extern.java.Log;
  16. import oracle.jdbc.proxy.annotation.Post;
  17. import org.springframework.beans.factory.annotation.Autowired;
  18. import org.springframework.web.bind.annotation.*;
  19. import org.springframework.web.multipart.MultipartFile;
  20. import java.io.File;
  21. import java.io.FileInputStream;
  22. import java.math.BigDecimal;
  23. import java.text.ParseException;
  24. import java.text.SimpleDateFormat;
  25. import java.util.*;
  26. @RestController
  27. @RequestMapping("${api.version}/rms")
  28. public class RMScontroller extends BaseRESTfulController {
  29. @Autowired
  30. RmsFeign rmsFeign;
  31. @ApiOperation(value = "查询所有作业环节")
  32. @PostMapping("/getStepTypeList")
  33. public Map<String, Object> getStepTypeList() {
  34. return rmsFeign.getStepTypeList();
  35. }
  36. @ApiOperation(value = "查询运输路线")
  37. @ApiImplicitParams({
  38. @ApiImplicitParam(name = "apiId", value = "249", required = false, dataType = "Integer"),
  39. })
  40. @PostMapping(value = "/getLineList")
  41. public Map<String, Object> getLineList(@RequestBody(required = false) Map<String, Object> mapValue,
  42. Integer pageNum,
  43. Integer pageSize,
  44. Integer apiId) {
  45. return rmsFeign.getLineList(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId);
  46. }
  47. @ApiOperation(value = "新增运输路线")
  48. @ApiImplicitParams({
  49. @ApiImplicitParam(name = "mapValue", value = "运输路线", required = false, dataType = "Map"),
  50. })
  51. @PostMapping("/insertLine")
  52. @LogAround(foreignKeys = {"lineId"}, foreignKeyTypes = {"运输路线"})
  53. public Map<String, Object> insertLine(@RequestBody(required = false) Map<String, Object> mapVal) {
  54. return rmsFeign.insertLine(mapVal);
  55. }
  56. @ApiOperation(value = "删除运输路线")
  57. @ApiImplicitParams({
  58. @ApiImplicitParam(name = "mapValue", value = "运输路线", required = false, dataType = "Map"),
  59. })
  60. @PostMapping("/deleteLine")
  61. @LogAround(foreignKeys = {"lineId"}, foreignKeyTypes = {"运输路线"})
  62. public Map<String, Object> deleteLine(@RequestBody(required = false) Map<String, Object> mapVal) {
  63. return rmsFeign.deleteLine(mapVal);
  64. }
  65. @ApiOperation(value = "根据id查询线路详情", notes = "")
  66. @ApiImplicitParam(name = "rmsLineStep", value = "rmsLineStep", required = true, dataType = "rmsLineStep")
  67. @PostMapping(value = "/getRmsLineStep/{id}")
  68. public Map<String, Object> getRmsLineStep(@PathVariable("id") BigDecimal id) {
  69. return rmsFeign.getRmsLineStep(id);
  70. }
  71. //================物资类型
  72. @PostMapping("/getMaterialTypeList")
  73. @ApiOperation(value = "查询物资种类列表")
  74. public Map<String, Object> getMaterialTypeList(@RequestBody(required = false) Map<String, Object> mapValue,
  75. Integer pageNum,
  76. Integer pageSize,
  77. Integer apiId,
  78. String con) {
  79. return rmsFeign.getMaterialTypeList(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId, con);
  80. }
  81. @ApiOperation("新增物资类型")
  82. @PostMapping("/insertMaterialType")
  83. @LogAround(foreignKeys = {"materialTypeId"}, foreignKeyTypes = "物资类型", description = "新增物资类型")
  84. public RESTfulResult insertMaterialType(@RequestBody(required = false) Map<String, Object> map) {
  85. return rmsFeign.insertMaterialType(map);
  86. }
  87. @ApiOperation("导入物资类型")
  88. @PostMapping("/importMaterialType")
  89. public RESTfulResult insertMaterialTypeExcel(@RequestBody MultipartFile file,
  90. String remark,
  91. String userId,
  92. String userName) throws Exception {
  93. Map<String, Object> map = new HashMap<>();
  94. //获取Excel中包含的对象数组
  95. List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
  96. map.put("list", list);
  97. Set<String> materialTypeSet = new HashSet<>();
  98. for (Map<String, Object> item : list) {
  99. //校验行
  100. if(
  101. item.get("名称")==null || item.get("名称").equals("")
  102. ){
  103. throw new Exception("单元格数据异常(名称),请检查模板或数据是否正确!");
  104. }
  105. materialTypeSet.add(item.get("名称").toString());
  106. }
  107. //去重
  108. String[] materialTypes = materialTypeSet.toArray(new String[0]);
  109. if (materialTypes.length != list.size()) {
  110. throw new Exception("名称不允许重复!");
  111. }
  112. map.put("materialTypes",materialTypes);
  113. map.put("userId",userId);
  114. map.put("userName",userName);
  115. map.put("remark",remark);
  116. return rmsFeign.importMaterialType(map);
  117. }
  118. @ApiOperation(value = "删除物资类型")
  119. @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
  120. @PostMapping(value = "/deleteMaterialType")
  121. @LogAround(foreignKeys = {"materialTypeId"}, foreignKeyTypes = "物资类型", description = "删除物资类型")
  122. public RESTfulResult deleteMaterialType(@RequestBody(required = false) Map<String, Object> map) {
  123. return rmsFeign.deleteMaterialType(map);
  124. }
  125. @ApiOperation(value = "同步物资类型")
  126. @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
  127. @PostMapping(value = "/syncMaterialType")
  128. @LogAround(foreignKeys = {"materialTypeId"}, foreignKeyTypes = "物资类型", description = "修改物资类型")
  129. public Map<String, Object> syncMaterialType(@RequestBody(required = false) Map<String, Object> map) {
  130. return rmsFeign.syncMaterialType(map);
  131. }
  132. @ApiOperation(value = "更新物资类型")
  133. @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
  134. @PostMapping(value = "/updateMaterialType")
  135. @LogAround(foreignKeys = {"materialTypeId"}, foreignKeyTypes = "物资类型", description = "修改物资类型")
  136. public Map<String, Object> updateMaterialType(@RequestBody(required = false) Map<String, Object> map) {
  137. return rmsFeign.updateMaterialType(map);
  138. }
  139. @ApiOperation(value = "根据id查询物资类型信息", notes = "")
  140. @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
  141. @PostMapping(value = "/getMaterialTypeById/{id}")
  142. public Map<String, Object> getMaterialTypeById(@PathVariable("id") BigDecimal id) {
  143. return rmsFeign.getMaterialTypeById(id);
  144. }
  145. //====================物资
  146. @ApiOperation(value = "获取物资列表")
  147. @ApiImplicitParams({
  148. @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
  149. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  150. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  151. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  152. @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
  153. })
  154. @PostMapping("/getMaterialList")
  155. public Map<String, Object> getMaterialList(@RequestBody(required = false) Map<String, Object> mapValue,
  156. Integer apiId,
  157. Integer pageNum,
  158. Integer pageSize
  159. ) {
  160. return rmsFeign.getMaterialList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize);
  161. }
  162. @ApiOperation(value = "新增物资", notes = "根据rmsMaterial对象创建")
  163. @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
  164. @PostMapping(value = "/insertMaterial")
  165. @LogAround(foreignKeys = {"materialId"}, foreignKeyTypes = {"物资"}, description = "新增物资")
  166. public Map<String, Object> insertMaterial(@RequestBody(required = false) Map<String, Object> map) {
  167. return rmsFeign.insertMaterial(map);
  168. }
  169. @ApiOperation(value = "删除", notes = "根据rmsCarrier对象创建")
  170. @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
  171. @PostMapping(value = "/deleteMaterial")
  172. @LogAround(foreignKeys = {"materialId"}, foreignKeyTypes = {"物资"}, description = "删除物资")
  173. public Map<String, Object> deleteMaterial(@RequestBody(required = false) Map<String, Object> map) {
  174. return rmsFeign.deleteMaterial(map);
  175. }
  176. @ApiOperation(value = "更新物资", notes = "根据rmsMaterial对象创建")
  177. @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
  178. @PostMapping(value = "/updateMaterial")
  179. @LogAround(foreignKeys = {"materialId"}, foreignKeyTypes = {"物资"}, description = "修改物资")
  180. public Map<String, Object> updateMaterial(@RequestBody(required = false) Map<String, Object> map) {
  181. return rmsFeign.updateMaterial(map);
  182. }
  183. @ApiOperation(value = "根据id查询原料信息", notes = "根据rmsCarrier对象创建")
  184. @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
  185. @PostMapping(value = "/getMaterialById/{id}")
  186. public Map<String, Object> getMaterialById(@PathVariable("id") BigDecimal id) {
  187. return rmsFeign.getMaterialById(id);
  188. }
  189. @ApiOperation(value = "同步物资", notes = "根据rmsMaterial对象创建")
  190. @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
  191. @PostMapping(value = "/syncMaterial")
  192. @LogAround(foreignKeys = {"materialId"}, foreignKeyTypes = {"物资"}, description = "同步物资")
  193. public Map<String, Object> syncMaterial(@RequestBody(required = false) Map<String, Object> map) {
  194. return rmsFeign.syncMaterial(map);
  195. }
  196. //====================作业点
  197. @ApiOperation(value = "获取作业点列表")
  198. @ApiImplicitParams({
  199. @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
  200. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  201. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  202. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  203. @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
  204. })
  205. @PostMapping("/getOperationPointList")
  206. public Map<String, Object> getOperationPointList(@RequestBody(required = false) Map<String, Object> mapValue,
  207. Integer apiId,
  208. Integer pageNum,
  209. Integer pageSize
  210. ) {
  211. return rmsFeign.getOperationPointList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize);
  212. }
  213. @ApiOperation(value = "新增作业点", notes = "根据rmsOperationPoint对象创建")
  214. @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
  215. @PostMapping(value = "/insertOperationPoint")
  216. @LogAround(foreignKeys = {"operationPointId"}, foreignKeyTypes = {"作业点"}, description = "新增作业点")
  217. public Map<String, Object> insertOperationPoint(@RequestBody(required = false) Map<String, Object> map) {
  218. return rmsFeign.insertOperationPoint(map);
  219. }
  220. @ApiOperation(value = "删除", notes = "根据rmsCarrier对象创建")
  221. @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
  222. @PostMapping(value = "/deleteOperationPoint")
  223. @LogAround(foreignKeys = {"operationPointId"}, foreignKeyTypes = {"作业点"}, description = "删除作业点")
  224. public Map<String, Object> deleteOperationPoint(@RequestBody(required = false) Map<String, Object> map) {
  225. return rmsFeign.deleteOperationPoint(map);
  226. }
  227. @ApiOperation(value = "更新作业点", notes = "根据rmsOperationPoint对象创建")
  228. @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
  229. @PostMapping(value = "/updateOperationPoint")
  230. @LogAround(foreignKeys = {"operationPointId"}, foreignKeyTypes = {"作业点"}, description = "修改作业点")
  231. public Map<String, Object> updateOperationPoint(@RequestBody(required = false) Map<String, Object> map) {
  232. return rmsFeign.updateOperationPoint(map);
  233. }
  234. @ApiOperation("导入作业点")
  235. @PostMapping("/importOperationPoint")
  236. public RESTfulResult importOperationPoint(@RequestBody MultipartFile file,
  237. String userId,
  238. String userName) throws Exception {
  239. Map<String, Object> map = new HashMap<>();
  240. //获取Excel中包含的对象数组
  241. List<Map<String, Object>> excelList = ExcelToolUtils.getExcelList(file, 0);
  242. map.put("list", excelList);
  243. Set<String> set = new HashSet<>();
  244. for (Map<String, Object> item : excelList) {
  245. //校验行
  246. if(
  247. item.get("作业点名称")==null || item.get("作业点名称").equals("")
  248. || item.get("作业点类型")==null || item.get("作业点类型").equals("")
  249. || item.get("作业点状态")==null || item.get("作业点状态").equals("")
  250. || item.get("环保标准")==null || item.get("环保标准").equals("")
  251. || item.get("所属单位")==null || item.get("所属单位").equals("")
  252. ){
  253. throw new Exception("单元格数据异常(作业点名称/作业点类型/作业点状态/环保标准/所属单位),请检查模板或数据是否正确!");
  254. }
  255. //隔开用于查询是否数据库存在
  256. set.add(item.get("作业点名称").toString());
  257. //key-value结构方便数据库去重后获取值
  258. map.put(item.get("作业点名称").toString(),item);
  259. }
  260. //去重
  261. String[] list = set.toArray(new String[0]);
  262. if (list.length != excelList.size()) {
  263. throw new Exception("手机号不允许重复!");
  264. }
  265. map.put("list",list);
  266. map.put("userId",userId);
  267. map.put("userName",userName);
  268. return rmsFeign.importOperationPoint(map);
  269. }
  270. @ApiOperation(value = "根据id查询原料信息", notes = "根据rmsCarrier对象创建")
  271. @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
  272. @PostMapping(value = "/getOperationPointById/{id}")
  273. public Map<String, Object> getOperationPointById(@PathVariable("id") BigDecimal id) {
  274. return rmsFeign.getOperationPointById(id);
  275. }
  276. @ApiOperation(value = "更新作业点同步作业点", notes = "根据rmsOperationPoint对象创建")
  277. @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
  278. @PostMapping(value = "/syncOperationPoint")
  279. @LogAround(foreignKeys = {"operationPointId"}, foreignKeyTypes = {"作业点"}, description = "同步作业点")
  280. public Map<String, Object> syncOperationPoint(@RequestBody(required = false) Map<String, Object> map) {
  281. return rmsFeign.syncOperationPoint(map);
  282. }
  283. //============人员信息
  284. @ApiOperation(value = "获取人员信息列表")
  285. @ApiImplicitParams({
  286. @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
  287. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  288. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  289. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  290. @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
  291. })
  292. @PostMapping("/getPersonnelList")
  293. public Map<String, Object> getPersonnelList(@RequestBody(required = false) Map<String, Object> mapVal,
  294. Integer apiId,
  295. Integer pageNum,
  296. Integer pageSize,
  297. String con
  298. ) {
  299. return rmsFeign.getPersonnelList(mapVal == null ? new HashMap<>() : mapVal, apiId, pageNum, pageSize, con);
  300. }
  301. @ApiOperation(value = "新增人员信息", notes = "根据rmsMaterial对象创建")
  302. @ApiImplicitParam(name = "rmsPersonnel", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
  303. @PostMapping(value = "/insertPersonnel")
  304. @LogAround(foreignKeys = {"personnelId"}, foreignKeyTypes = {"人员"})
  305. public Map<String, Object> insertPersonnel(@RequestBody(required = false) Map<String, Object> map) {
  306. return rmsFeign.insertPersonnel(map);
  307. }
  308. @ApiOperation(value = "删除", notes = "根据rmsPersonnel对象创建")
  309. @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
  310. @PostMapping(value = "/deletePersonnel")
  311. @LogAround(foreignKeys = {"personnelId"}, foreignKeyTypes = {"人员"})
  312. public Map<String, Object> deletePersonnel(@RequestBody(required = false) Map<String, Object> map) {
  313. return rmsFeign.deletePersonnel(map);
  314. }
  315. @ApiOperation(value = "更新人员信息", notes = "根据rmsMaterial对象创建")
  316. @ApiImplicitParam(name = "rmsPersonnel", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
  317. @PostMapping(value = "/updatePersonnel")
  318. @LogAround(foreignKeys = {"personnelId"}, foreignKeyTypes = {"人员"})
  319. public Map<String, Object> updatePersonnel(@RequestBody(required = false) Map<String, Object> map) {
  320. return rmsFeign.updatePersonnel(map);
  321. }
  322. @ApiOperation(value = "根据id更新详细人员信息", notes = "根据rmsPersonnel对象创建")
  323. @ApiImplicitParam(name = "rmsPersonnel", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
  324. @PostMapping(value = "/getPersonnelById")
  325. public Map<String, Object> getPersonnelById(@RequestBody(required = false) Map<String, Object> map) {
  326. return rmsFeign.getPersonnelById(map);
  327. }
  328. @ApiOperation(value = "根据id更新详细人员信息", notes = "根据rmsPersonnel对象创建")
  329. @ApiImplicitParam(name = "rmsPersonnel", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
  330. @PostMapping(value = "/syncPersonnel")
  331. @LogAround(foreignKeys = {"personnelId"}, foreignKeyTypes = {"人员"})
  332. public Map<String, Object> syncPersonnel(@RequestBody(required = false) Map<String, Object> map) {
  333. return rmsFeign.syncPersonnel(map);
  334. }
  335. @ApiOperation("导入人员信息")
  336. @PostMapping("/importPersonnel")
  337. public RESTfulResult importPersonnel(@RequestBody MultipartFile file,
  338. String userId,
  339. String userName) throws Exception {
  340. Map<String, Object> map = new HashMap<>();
  341. //获取Excel中包含的对象数组
  342. List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
  343. Set<String> set = new HashSet<>();
  344. for (Map<String, Object> item : list) {
  345. //校验行
  346. if(
  347. item.get("姓名")==null || item.get("姓名").equals("")
  348. || item.get("岗位")==null || item.get("岗位").equals("")
  349. || item.get("联系电话")==null || item.get("联系电话").equals("")
  350. || item.get("身份证号码")==null || item.get("身份证号码").equals("")
  351. || item.get("所属单位")==null || item.get("所属单位").equals("")
  352. || item.get("授权角色")==null || item.get("授权角色").equals("")
  353. ){
  354. throw new Exception("单元格数据异常(姓名/岗位/联系电话/身份证号码/所属单位/授权角色),请检查模板或数据是否正确!");
  355. }
  356. //隔开用于查询是否数据库存在
  357. set.add(item.get("联系电话").toString() +"-"+item.get("所属单位").toString());
  358. }
  359. //去重
  360. String[] array = set.toArray(new String[0]);
  361. if (array.length != list.size()) {
  362. throw new Exception("手机号-所属单位不允许重复!");
  363. }
  364. map.put("list", list);
  365. map.put("userId",userId);
  366. map.put("userName",userName);
  367. return rmsFeign.importPersonnel(map);
  368. }
  369. //================公司
  370. @ApiOperation(value = "展示公司信息")
  371. @ApiImplicitParams({
  372. @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
  373. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  374. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  375. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  376. @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
  377. })
  378. @PostMapping("/getCompanyList")
  379. public Map<String, Object> getCompanyList(@RequestBody(required = false) Map<String, Object> mapValue,
  380. Integer apiId,
  381. Integer pageNum,
  382. Integer pageSize
  383. ) {
  384. return rmsFeign.getCompanyList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize);
  385. }
  386. @ApiOperation(value = "新增公司信息", notes = "根据rmsCompany对象创建")
  387. @ApiImplicitParam(name = "rmsCompany", value = "详细实体rmsCompany", required = true, dataType = "rmsCompany")
  388. @PostMapping(value = "/insertCompany")
  389. @LogAround(foreignKeys = {"companyId"}, foreignKeyTypes = "公司", description = "新增公司单位")
  390. public Map<String, Object> insertCompany(@RequestBody(required = false) Map<String, Object> map) {
  391. return rmsFeign.insertCompany(map);
  392. }
  393. @ApiOperation(value = "删除")
  394. @ApiImplicitParam(name = "公司id", value = "id", required = true, dataType = "int")
  395. @PostMapping(value = "/deleteCompany")
  396. @LogAround(foreignKeys = {"companyId"}, foreignKeyTypes = "公司", description = "删除公司单位")
  397. public Map<String, Object> deleteCompany(@RequestBody Map<String, Object> map) {
  398. return rmsFeign.deleteCompany(map);
  399. }
  400. @ApiOperation(value = "更新公司信息", notes = "根据rmsCompany对象创建")
  401. @ApiImplicitParam(name = "rmsCompany", value = "详细实体rmsCompany", required = true, dataType = "rmsCompany")
  402. @PostMapping(value = "/updateCompany")
  403. @LogAround(foreignKeys = {"companyId"}, foreignKeyTypes = "公司", description = "修改公司单位")
  404. public Map<String, Object> updateCompany(@RequestBody(required = false) Map<String, Object> map) {
  405. return rmsFeign.updateCompany(map);
  406. }
  407. @ApiOperation(value = "根据id查询公司信息", notes = "根据rmsCompany对象创建")
  408. @ApiImplicitParam(name = "公司id", value = "id", required = true, dataType = "int")
  409. @PostMapping(value = "/getCompanyById/{id}")
  410. public Map<String, Object> getCompanyById(@PathVariable("id") BigDecimal id) {
  411. return rmsFeign.getCompanyById(id);
  412. }
  413. @ApiOperation(value = "同步公司", notes = "根据rmsCompany对象创建")
  414. @ApiImplicitParam(name = "rmsCompany", value = "详细实体rmsCompany", required = true, dataType = "rmsCompany")
  415. @PostMapping(value = "/syncCompany")
  416. @LogAround(foreignKeys = {"companyId"}, foreignKeyTypes = {"公司"}, description = "同步公司")
  417. public Map<String, Object> syncCompany(@RequestBody(required = false) Map<String, Object> map) {
  418. return rmsFeign.syncCompany(map);
  419. }
  420. //运力
  421. @ApiOperation(value = "新增运力信息", notes = "根据rmsCapacity对象创建")
  422. @ApiImplicitParam(name = "rmsCapacity", value = "详细实体rmsCapacity", required = true, dataType = "rmsCapacity")
  423. @PostMapping(value = "/insertCapacity")
  424. @LogAround(foreignKeys = {"capacityId"}, foreignKeyTypes = {"运力"})
  425. public Map<String, Object> insertCapacity(@RequestBody(required = false) Map<String, Object> map) {
  426. return rmsFeign.insertCapacity(map);
  427. }
  428. @ApiOperation(value = "删除", notes = "根据rmsCarrier对象创建")
  429. @ApiImplicitParam(name = "运力id", value = "id", required = true, dataType = "int")
  430. @PostMapping(value = "/deleteCapacity")
  431. @LogAround(foreignKeys = {"capacityId"}, foreignKeyTypes = {"运力"})
  432. public Map<String, Object> deleteCapacity(@RequestBody(required = false) Map<String, Object> map) {
  433. return rmsFeign.deleteCapacity(map);
  434. }
  435. @ApiOperation(value = "获取运力详细信息", notes = "根据url的id来获取详细信息")
  436. @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal")
  437. @PostMapping(value = "/getCapacityById")
  438. public Map<String, Object> getCapacityById(@RequestBody Map<String, Object> map) {
  439. return rmsFeign.getCapacityById(map);
  440. }
  441. @ApiOperation(value = "更新详细信息", notes = "根据url的id来指定更新对象,并根据传过来的rmsCapacity信息来更新详细信息")
  442. @ApiImplicitParams({
  443. @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "Short"),
  444. @ApiImplicitParam(name = "rmsCapacity", value = "详细实体rmsCapacity", required = true, dataType = "RmsCapacity")
  445. })
  446. @PostMapping(value = "/updateCapacity", produces = "application/json;charset=UTF-8")
  447. @LogAround(foreignKeys = {"capacityId"}, foreignKeyTypes = {"运力"})
  448. public Map<String, Object> updateCapacity(@RequestBody Map<String, Object> map) {
  449. return rmsFeign.updateCapacity(map);
  450. }
  451. @PostMapping("/getCapacityList")
  452. @ApiOperation(value = "模糊查询运力")
  453. public Map<String, Object> getCapacityList(@RequestBody(required = false) Map<String, Object> mapValue,
  454. Integer pageNum,
  455. Integer pageSize,
  456. Integer apiId,
  457. String con,
  458. String carrierSSOId) {
  459. return rmsFeign.getCapacityList(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId, con, carrierSSOId);
  460. }
  461. @ApiOperation(value = "删除", notes = "根据rmsCarrier对象创建")
  462. @ApiImplicitParam(name = "仓库id", value = "id", required = true, dataType = "int")
  463. @PostMapping(value = "/deleteWarehouse/{id}")
  464. public Map<String, Object> deleteWarehouse(@PathVariable("id") BigDecimal id) {
  465. return rmsFeign.deleteWarehouse(id);
  466. }
  467. @ApiOperation(value = "更新详细信息", notes = "根据url的id来指定更新对象,并根据传过来的rmsCarDriver信息来更新详细信息")
  468. @ApiImplicitParams({
  469. @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal"),
  470. @ApiImplicitParam(name = "rmsWarehouse", value = "详细实体rmsWarehouse", required = true, dataType = "RmsWarehouse")
  471. })
  472. @PostMapping(value = "/updateWarehouse", produces = "application/json;charset=UTF-8")
  473. public Map<String, Object> updateWarehouse(@RequestBody Map<String, Object> map) {
  474. return rmsFeign.updateWarehouse(map);
  475. }
  476. @ApiOperation(value = "获取详细信息", notes = "根据url的id来获取详细信息")
  477. @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal")
  478. @PostMapping(value = "/getWarehouseById/{id}")
  479. public Map<String, Object> getWarehouseById(@PathVariable("id") BigDecimal id) {
  480. return rmsFeign.getWarehouseById(id);
  481. }
  482. @PostMapping("/getWarehouseList")
  483. @ApiOperation(value = "模糊查询原料仓库")
  484. public Map<String, Object> getWarehouseList(@RequestBody(required = false) Map<String, Object> mapValue,
  485. Integer pageNum,
  486. Integer pageSize,
  487. Integer apiId,
  488. String con) {
  489. return rmsFeign.getWarehouseList(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId, con);
  490. }
  491. @ApiOperation(value = "展示司机排班信息", notes = "分页查询")
  492. @ApiImplicitParams({
  493. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  494. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  495. @ApiImplicitParam(name = "apiId", value = "196", required = false, dataType = "BigDecimal"),
  496. })
  497. @PostMapping(value = "/getCapacityDriverList")
  498. public Map<String, Object> getCapacityDriverList(@RequestBody(required = false) Map<String, Object> mapValue,
  499. Integer pageNum,
  500. Integer pageSize,
  501. Integer apiId) {
  502. return rmsFeign.getCapacityDriverList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize);
  503. }
  504. @ApiOperation(value = "创建", notes = "根据RmsDriverCapacity对象创建")
  505. @ApiImplicitParam(name = "rmsCapacityDriver", value = "详细实体rmsDriverCapacity", required = true, dataType = "RmsDriverCapacity")
  506. @PostMapping(value = "/insertCapacityDriver")
  507. @LogAround(foreignKeys = {"capacityDriverId"},foreignKeyTypes = {"司机排班"})
  508. public Map<String, Object> insertCapacityDriver(@RequestBody(required = false) Map<String, Object> map) {
  509. return rmsFeign.insertCapacityDriver(map);
  510. }
  511. @ApiOperation(value = "创建", notes = "根据RmsDriverCapacity对象创建")
  512. @ApiImplicitParam(name = "rmsCapacityDriver", value = "详细实体rmsDriverCapacity", required = true, dataType = "RmsDriverCapacity")
  513. @PostMapping(value = "/deleteCapacityDriver")
  514. @LogAround(foreignKeys = {"capacityDriverId"},foreignKeyTypes = {"司机排班"})
  515. public Map<String, Object> deleteCapacityDriver(@RequestBody(required = false) Map<String, Object> map) {
  516. return rmsFeign.deleteCapacityDriver(map);
  517. }
  518. @ApiOperation(value = "展示门岗信息")
  519. @ApiImplicitParams({
  520. @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
  521. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  522. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  523. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  524. @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
  525. })
  526. @PostMapping("/getGatepostList")
  527. public Map<String, Object> getGatepostList(@RequestBody(required = false) Map<String, Object> mapValue,
  528. Integer apiId,
  529. Integer pageNum,
  530. Integer pageSize,
  531. String con
  532. ) {
  533. return rmsFeign.getGatepostList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize, con);
  534. }
  535. @ApiOperation(value = "新增门岗信息", notes = "根据rmsGatepost对象创建")
  536. @ApiImplicitParam(name = "rmsGatepost", value = "详细实体rmsGatepost", required = true, dataType = "rmsGatepost")
  537. @PostMapping(value = "/insertGatepost")
  538. public Map<String, Object> insertGatepost(@RequestBody(required = false) Map<String, Object> map) {
  539. return rmsFeign.insertGatepost(map);
  540. }
  541. @ApiOperation(value = "删除", notes = "根据rmsGatepost对象创建")
  542. @ApiImplicitParam(name = "门岗id", value = "id", required = true, dataType = "int")
  543. @PostMapping(value = "/deleteGatepost/{id}")
  544. public Map<String, Object> deleteGatepost(@PathVariable("id") BigDecimal id) {
  545. return rmsFeign.deleteGatepost(id);
  546. }
  547. @ApiOperation(value = "更新门岗信息", notes = "根据rmsGatepost对象创建")
  548. @ApiImplicitParam(name = "rmsGatepost", value = "详细实体rmsGatepost", required = true, dataType = "rmsGatepost")
  549. @PostMapping(value = "/updateGatepost")
  550. public Map<String, Object> updateGatepost(@RequestBody(required = false) Map<String, Object> map) {
  551. return rmsFeign.updateGatepost(map);
  552. }
  553. @ApiOperation(value = "根据id查询门岗信息", notes = "根据rmsGatepost对象创建")
  554. @ApiImplicitParam(name = "门岗id", value = "id", required = true, dataType = "int")
  555. @PostMapping(value = "/getGatepostById/{id}")
  556. public Map<String, Object> getGatepostById(@PathVariable("id") BigDecimal id) {
  557. return rmsFeign.getGatepostById(id);
  558. }
  559. @ApiOperation(value = "根据id查询门岗规则信息", notes = "根据rmsGatepost对象创建")
  560. @ApiImplicitParams({
  561. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  562. @ApiImplicitParam(name = "门岗id", value = "id", required = true, dataType = "int")
  563. })
  564. @PostMapping(value = "/getGatepostRulesById/{id}")
  565. public Map<String, Object> getGatepostRulesById(@PathVariable("id") BigDecimal id,
  566. Integer apiId) {
  567. return rmsFeign.getGatepostRulesById(id, apiId);
  568. }
  569. @ApiOperation(value = "展示门岗规则信息")
  570. @ApiImplicitParams({
  571. @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
  572. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  573. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  574. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  575. @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
  576. })
  577. @PostMapping("/getGatepostRulesList")
  578. public Map<String, Object> getGatepostRulesList(@RequestBody(required = false) Map<String, Object> mapValue,
  579. Integer apiId,
  580. Integer pageNum,
  581. Integer pageSize,
  582. String con
  583. ) {
  584. return rmsFeign.getGatepostRulesList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize, con);
  585. }
  586. @ApiOperation(value = "删除", notes = "根据rulesId删除")
  587. @ApiImplicitParam(name = "门岗规则id", value = "rulesId", required = true, dataType = "int")
  588. @PostMapping(value = "/deleteGatepostRules/{rulesId}")
  589. public Map<String, Object> deleteGatepostRules(@PathVariable("rulesId") BigDecimal rulesId) {
  590. return rmsFeign.deleteGatepostRules(rulesId);
  591. }
  592. @ApiOperation(value = "新增门岗规则")
  593. @ApiImplicitParams({
  594. @ApiImplicitParam(name = "mapValue", value = "门岗规则", required = false, dataType = "Map"),
  595. })
  596. @PostMapping("/insertGatepostRule")
  597. public Map<String, Object> insertGatepostRule(@RequestBody(required = false) Map<String, Object> mapValue) {
  598. return rmsFeign.insertGatepostRule(mapValue);
  599. }
  600. @ApiOperation(value = "获取门岗名")
  601. @ApiImplicitParams({
  602. @ApiImplicitParam(name = "门岗id", value = "gatepostId", required = true, dataType = "int")
  603. })
  604. @PostMapping("/getGatepostName/{gatepostId}")
  605. public Map<String, Object> getGatepostName(@PathVariable("gatepostId") BigDecimal gatepostId) {
  606. return rmsFeign.getGatepostName(gatepostId);
  607. }
  608. //*******************************下拉框************************
  609. @GetMapping("getCapacityTypeId")
  610. @ApiOperation(value = "得到下拉运力id")
  611. public Map<String, Object> getCapacityTypeId() {
  612. return rmsFeign.getCapacityTypeId();
  613. }
  614. @GetMapping("getMaterialTypeId")
  615. @ApiOperation(value = "得到下拉物资类型id")
  616. public Map<String, Object> getMaterialTypeId() {
  617. return rmsFeign.getMaterialTypeId();
  618. }
  619. @GetMapping("getTransportTypeId")
  620. @ApiOperation(value = "运输类型下拉")
  621. public Map<String, Object> getTransportTypeId() {
  622. return rmsFeign.getTransportTypeId();
  623. }
  624. @PostMapping(value = "/getNoticeList")
  625. public Map<String, Object> getNoticeList(@RequestBody(required = false) Map<String, Object> mapValue,
  626. Integer apiId,
  627. Integer pageNum,
  628. Integer pageSize,
  629. String con
  630. ) {
  631. if (mapValue == null) {
  632. mapValue = new HashMap<>();
  633. }
  634. return rmsFeign.getNoticeList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize, con);
  635. }
  636. @ApiOperation(value = "新增公告信息", notes = "根据DilNotice对象创建")
  637. @ApiImplicitParam(name = "dilNotice", value = "详细实体dilNotice", required = true, dataType = "DilNotice")
  638. @PostMapping(value = "/insertNotice")
  639. public Map<String, Object> insertNotice(@RequestBody(required = false) Map<String, Object> map) {
  640. return rmsFeign.insertNotice(map);
  641. }
  642. @ApiOperation(value = "更新公告信息", notes = "根据dilNotice对象创建")
  643. @ApiImplicitParam(name = "dilNotice", value = "详细实体dilNotice", required = true, dataType = "dilNotice")
  644. @PostMapping(value = "/updateNotice", produces = "application/json;charset=UTF-8")
  645. public Map<String, Object> updateNotice(@RequestBody(required = false) Map<String, Object> map) {
  646. return rmsFeign.updateNotice(map);
  647. }
  648. @ApiOperation(value = "删除", notes = "根据url的id来指定删除对象")
  649. @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal")
  650. @PostMapping(value = "/deleteNotice/{id}")//BigDecimal
  651. public Map<String, Object> deleteNotice(@PathVariable("id") BigDecimal id) {
  652. return rmsFeign.deleteNotice(id);
  653. }
  654. @ApiOperation(value = "获取详细信息", notes = "根据url的id来获取详细信息")
  655. @ApiImplicitParam(paramType = "path", name = "公告id", value = "ID", required = true, dataType = "BigDecimal")
  656. @PostMapping(value = "/getNoticeById/{id}")
  657. public Map<String, Object> getNoticeById(@PathVariable("id") BigDecimal id) {
  658. return rmsFeign.getNoticeById(id);
  659. }
  660. //油价
  661. @ApiOperation(value = "获取油价信息", notes = "分页查询")
  662. @ApiImplicitParams({
  663. @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
  664. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  665. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  666. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  667. @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
  668. })
  669. @PostMapping(value = "/getOilPriceResultList")
  670. public Map<String, Object> getOilPriceResultList(@RequestBody(required = false) Map<String, Object> mapValue,
  671. Integer apiId,
  672. Integer pageNum,
  673. Integer pageSize,
  674. String con
  675. ) {
  676. if (mapValue == null) {
  677. mapValue = new HashMap<>();
  678. }
  679. return rmsFeign.getOilPriceResultList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize, con);
  680. }
  681. @ApiOperation(value = "新增油价信息", notes = "根据DilNotice对象创建")
  682. @ApiImplicitParam(name = "addOilPrice", value = "详细实体dilNotice", required = true, dataType = "DilNotice")
  683. @PostMapping(value = "/insertOilPrice")
  684. public Map<String, Object> insertOilPrice(@RequestBody(required = false) Map<String, Object> map) {
  685. return rmsFeign.insertOilPrice(map);
  686. }
  687. @ApiOperation(value = "更新油价信息", notes = "根据油价ID来更新油价")
  688. @PostMapping(value = "/updateOilPrice")
  689. public Map<String, Object> updateOilPrice(@RequestBody(required = false) Map<String, Object> mapValue) {
  690. return rmsFeign.updateOilPrice(mapValue);
  691. }
  692. @ApiOperation(value = "删除", notes = "根据url的id来指定删除对象")
  693. @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal")
  694. @PostMapping(value = "/deleteOilPrice/{id}")//BigDecimal
  695. public Map<String, Object> deleteOilPrice(@PathVariable("id") BigDecimal id) {
  696. return rmsFeign.deleteOilPrice(id);
  697. }
  698. @ApiOperation(value = "获取详细信息", notes = "根据url的id来获取详细信息")
  699. @ApiImplicitParam(paramType = "path", name = "公告id", value = "ID", required = true, dataType = "BigDecimal")
  700. @PostMapping(value = "/getOilPriceById/{id}")
  701. public Map<String, Object> getOilPriceById(@PathVariable("id") BigDecimal id) {
  702. return rmsFeign.getOilPriceById(id);
  703. }
  704. //根据运力id查询公司
  705. @PostMapping(value = "getCarrierNameById/{id}")
  706. public Map<String, Object> getCarrierNameById(@PathVariable("id") BigDecimal id) {
  707. return rmsFeign.getCarrierNameById(id);
  708. }
  709. //根据司机id查询公司
  710. @PostMapping(value = "getCarrierNameByDriverId/{id}")
  711. public Map<String, Object> getCarrierNameByDriverId(@PathVariable("id") BigDecimal id) {
  712. return rmsFeign.getCarrierNameByDriverId(id);
  713. }
  714. @ApiOperation(value = "创建", notes = "添加油品名称")
  715. @ApiImplicitParam(name = "oilTypeName", value = "油品名称", required = true, dataType = "String")
  716. @PostMapping(value = "/addOilType")
  717. public Map<String, Object> addOilType(String oilTypeName) {
  718. return rmsFeign.addOilType(oilTypeName);
  719. }
  720. @ApiOperation(value = "创建", notes = "查询油品名称")
  721. @PostMapping(value = "/oilNameSelect")
  722. public Map<String, Object> oilNameSelect() {
  723. return rmsFeign.oilNameSelect();
  724. }
  725. @ApiOperation("解除公司和车辆的绑定关系")
  726. @PostMapping("/deleteCapacityCarrier")
  727. public RESTfulResult deleteCapacityCarrier(@RequestBody(required = false) Map<String, Object> map) {
  728. return rmsFeign.deleteCapacityCarrier(map != null ? map : new HashMap<>());
  729. }
  730. @ApiOperation("渲染运力修改数据")
  731. @PostMapping("/getCapacityInfoById/{id}")
  732. public Map<String, Object> getCapacityInfoById(@PathVariable("id") Integer id) {
  733. return rmsFeign.getCapacityInfoById(id);
  734. }
  735. @ApiOperation(value = "查询运力类型")
  736. @PostMapping("/getCapacityType")
  737. public Map<String, Object> getCapacityType(@RequestBody(required = false) Map<String, Object> map,
  738. Integer apiId,
  739. Integer pageNum,
  740. Integer pageSize) {
  741. if (map == null) {
  742. map = new HashMap<>();
  743. }
  744. return rmsFeign.getCapacityType(map, apiId, pageNum, pageSize);
  745. }
  746. @ApiOperation(value = "新增运力类型")
  747. @PostMapping(value = "/insertCapacityType")
  748. @LogAround(foreignKeys = {"capacityTypeId"}, foreignKeyTypes = {"运力类型"})
  749. public Map<String, Object> insertCapacityType(@RequestBody(required = false) Map<String, Object> map) {
  750. return rmsFeign.insertCapacityType(map);
  751. }
  752. @ApiOperation(value = "删除运力类型")
  753. @PostMapping(value = "/deleteCapacityType")
  754. @LogAround(foreignKeys = {"capacityTypeId"}, foreignKeyTypes = {"运力类型"})
  755. public Map<String, Object> deleteCapacityType(@RequestBody(required = false) Map<String, Object> map) {
  756. return rmsFeign.deleteCapacityType(map);
  757. }
  758. @ApiOperation(value = "查询运输范围")
  759. @PostMapping("/getTransRangeList")
  760. public Map<String, Object> getTransRangeList(@RequestBody(required = false) Map<String, Object> map,
  761. Integer apiId,
  762. Integer pageNum,
  763. Integer pageSize) {
  764. if (map == null) {
  765. map = new HashMap<>();
  766. }
  767. return rmsFeign.getTransRangeList(map, apiId, pageNum, pageSize);
  768. }
  769. @ApiOperation(value = "新增运输范围")
  770. @PostMapping(value = "/insertTransRange")
  771. @LogAround(foreignKeys = {"transRangeId"}, foreignKeyTypes = "运输范围")
  772. public Map<String, Object> insertTransRange(@RequestBody(required = false) Map<String, Object> map) {
  773. return rmsFeign.insertTransRange(map);
  774. }
  775. @ApiOperation(value = "删除运输范围")
  776. @PostMapping(value = "/deleteTransRange")
  777. @LogAround(foreignKeys = {"transRangeId"}, foreignKeyTypes = "运输范围")
  778. public Map<String, Object> deleteTransRange(@RequestBody(required = false) Map<String, Object> map) {
  779. return rmsFeign.deleteTransRange(map);
  780. }
  781. @ApiOperation("导入运输范围")
  782. @PostMapping("/importTransRange")
  783. public RESTfulResult importTransRange(@RequestBody MultipartFile file,
  784. String userId,
  785. String userName) throws Exception {
  786. Map<String, Object> map = new HashMap<>();
  787. //获取Excel中包含的对象数组
  788. List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
  789. map.put("list", list);
  790. Set<String> set = new HashSet<>();
  791. for (Map<String, Object> item : list) {
  792. //校验行
  793. if(
  794. item.get("起点")==null || item.get("起点").equals("")
  795. || item.get("终点")==null || item.get("终点").equals("")
  796. ){
  797. throw new Exception("单元格数据异常(起点/终点),请检查模板或数据是否正确!");
  798. }
  799. //隔开用于查询是否数据库存在
  800. set.add(item.get("起点").toString() + "," + item.get("终点").toString());
  801. }
  802. //去重
  803. String[] transRanges = set.toArray(new String[0]);
  804. if (transRanges.length != list.size()) {
  805. throw new Exception("不允许重复!");
  806. }
  807. map.put("list",transRanges);
  808. map.put("userId",userId);
  809. map.put("userName",userName);
  810. return rmsFeign.importTransRange(map);
  811. }
  812. @ApiOperation(value = "新增集装箱数据")
  813. @PostMapping("insetShipContainer")
  814. public Map<String, Object> insetShipContainer(@RequestBody(required = false) Map<String, Object> map) {
  815. return rmsFeign.insetShipContainer(map);
  816. }
  817. @ApiOperation(value = "修改集装箱数据")
  818. @PostMapping("updateShipContainer")
  819. public Map<String, Object> updateShipContainer(@RequestBody List<Map<String, Object>> mapList) {
  820. return rmsFeign.updateShipContainer(mapList);
  821. }
  822. @ApiOperation("查询集装箱数据")
  823. @PostMapping("getShippingContainer")
  824. public Map<String, Object> getShippingContainer(@RequestBody(required = false) Map<String, Object> map,
  825. @RequestParam(required = false) Integer apiId,
  826. @RequestParam(required = false) Integer pageNum,
  827. @RequestParam(required = false) Integer pageSize) {
  828. if (map == null) {
  829. map = new HashMap<>();
  830. }
  831. return rmsFeign.getShippingContainer(map, apiId, pageNum, pageSize);
  832. }
  833. // ========================= 岗位信息维护
  834. @ApiOperation(value = "岗位信息")
  835. @ApiImplicitParams({
  836. @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
  837. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  838. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  839. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  840. })
  841. @PostMapping(value = "/getrmsrmsjobinfos")
  842. public Map<String, Object> getAmsTransPriceList(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
  843. Integer pageNum,
  844. Integer pageSize) {
  845. return rmsFeign.list(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
  846. }
  847. @ApiOperation(value="新增岗位信息")
  848. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  849. @LogAround(foreignKeys = {"jobId"},foreignKeyTypes = {"岗位信息"})
  850. @PostMapping("/add")
  851. public Map<String, Object> insertTransPrice(@RequestBody(required = false) Map<String, Object> map) {
  852. map.put("insertUsername", map.get("userName").toString());
  853. return rmsFeign.add(map);
  854. }
  855. @ApiOperation(value="修改岗位信息")
  856. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  857. @PutMapping(value = "/{id}")
  858. @LogAround(foreignKeys = {"jobId"},foreignKeyTypes = {"岗位信息"})
  859. public Map<String, Object> purchaseOrderUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
  860. map.put("updateUsername", map.get("userName").toString());
  861. return rmsFeign.update(id,map);
  862. }
  863. @ApiOperation(value="岗位信息逻辑删除")
  864. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  865. @PutMapping(value = "/logicdelete")
  866. @LogAround(foreignKeys = {"jobId"},foreignKeyTypes = {"岗位信息"})
  867. public Map<String, Object> purchaseOrderLogicDelete(@RequestBody(required = false) Map<String, Object> map){
  868. return rmsFeign.logicdelete(map);
  869. }
  870. @PostMapping(value = "/readExcel")
  871. public RESTfulResult readExcel(MultipartFile file){
  872. return rmsFeign.readExcel(file);
  873. }
  874. // ========================= 提取比例维护
  875. @ApiOperation(value = "提取比例")
  876. @ApiImplicitParams({
  877. @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
  878. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  879. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  880. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  881. })
  882. @PostMapping(value = "/getrmsextractscales")
  883. public Map<String, Object> getextractscalelist(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
  884. Integer pageNum,
  885. Integer pageSize) {
  886. return rmsFeign.extractscalelist(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
  887. }
  888. @ApiOperation(value="新增提取比例")
  889. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  890. @LogAround(foreignKeys = {"scaleId"},foreignKeyTypes = {"提取比例"})
  891. @PostMapping("/addextractscale")
  892. public Map<String, Object> insertExtractscale(@RequestBody(required = false) Map<String, Object> map) {
  893. map.put("insertUsername", map.get("userName").toString());
  894. return rmsFeign.addExtractscale(map);
  895. }
  896. @ApiOperation(value="提取比例逻辑删除")
  897. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  898. @PutMapping(value = "/extractscalelogicdelete")
  899. @LogAround(foreignKeys = {"scaleId"},foreignKeyTypes = {"提取比例"})
  900. public Map<String, Object> ExtractscaleLogicDelete(@RequestBody(required = false) Map<String, Object> map){
  901. return rmsFeign.Extractscalelogicdelete(map);
  902. }
  903. @ApiOperation(value="修改提取比例")
  904. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  905. @PutMapping(value = "/extractscale/{id}")
  906. @LogAround(foreignKeys = {"scaleId"},foreignKeyTypes = {"提取比例"})
  907. public Map<String, Object> ExtractscaleUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
  908. map.put("updateUsername", map.get("userName").toString());
  909. return rmsFeign.Extractscaleupdate(id,map);
  910. }
  911. // ========================= 计算公式
  912. @ApiOperation(value = "计算公式")
  913. @ApiImplicitParams({
  914. @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
  915. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  916. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  917. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  918. })
  919. @PostMapping(value = "/getformula")
  920. public Map<String, Object> geteformulalist(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
  921. Integer pageNum,
  922. Integer pageSize) {
  923. return rmsFeign.FormulaList(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
  924. }
  925. @ApiOperation(value="新增计算公式")
  926. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  927. @LogAround(foreignKeys = {"formulaId"},foreignKeyTypes = {"计算公式"})
  928. @PostMapping("/addformula")
  929. public Map<String, Object> insertformula(@RequestBody(required = false) Map<String, Object> map) {
  930. map.put("insertUsername", map.get("userName").toString());
  931. return rmsFeign.addFormula(map);
  932. }
  933. @ApiOperation(value="计算公式逻辑删除")
  934. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  935. @PutMapping(value = "/formulalogicdelete")
  936. @LogAround(foreignKeys = {"formulaId"},foreignKeyTypes = {"计算公式"})
  937. public Map<String, Object> formulaLogicDelete(@RequestBody(required = false) Map<String, Object> map){
  938. return rmsFeign.Formulalogicdelete(map);
  939. }
  940. @ApiOperation(value="修改计算公式")
  941. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  942. @PutMapping(value = "/formulaupadete/{id}")
  943. @LogAround(foreignKeys = {"formulaId"},foreignKeyTypes = {"计算公式"})
  944. public Map<String, Object> formulaUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
  945. map.put("updateUsername", map.get("userName").toString());
  946. return rmsFeign.Formulaupdate(id,map);
  947. }
  948. // ========================= 需求快捷匹配
  949. @ApiOperation(value = "需求快捷匹配")
  950. @ApiImplicitParams({
  951. @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
  952. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  953. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  954. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  955. })
  956. @PostMapping(value = "/getrmsdemandruless")
  957. public Map<String, Object> getrmsdemandrulesslist(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
  958. Integer pageNum,
  959. Integer pageSize) {
  960. return rmsFeign.rmsdemandrulesslist(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
  961. }
  962. @ApiOperation(value="新增需求快捷匹配")
  963. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  964. @LogAround(foreignKeys = {"rulesId"},foreignKeyTypes = {"计算公式"})
  965. @PostMapping("/addrmsdemandruless")
  966. public Map<String, Object> insertrmsdemandruless(@RequestBody(required = false) Map<String, Object> map) {
  967. map.put("insertUsername", map.get("userName").toString());
  968. return rmsFeign.addrmsdemandruless(map);
  969. }
  970. @ApiOperation(value="修改需求快捷匹配")
  971. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  972. @PutMapping(value = "/rmsdemandrulessUpdate/{id}")
  973. @LogAround(foreignKeys = {"rulesId"},foreignKeyTypes = {"需求快捷匹配"})
  974. public Map<String, Object> rmsdemandrulessUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
  975. map.put("updateUsername", map.get("userName").toString());
  976. return rmsFeign.rmsdemandrulessupdate(id,map);
  977. }
  978. // ========================= 费用类别
  979. @ApiOperation(value = "费用类别")
  980. @ApiImplicitParams({
  981. @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
  982. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  983. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  984. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  985. })
  986. @PostMapping(value = "/rmsexpansecategorysList")
  987. public Map<String, Object> getrmsexpansecategorys(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
  988. Integer pageNum,
  989. Integer pageSize) {
  990. return rmsFeign.rmsexpansecategorysList(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
  991. }
  992. @ApiOperation(value="新增费用类别")
  993. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  994. @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"费用类别"})
  995. @PostMapping("/rmsexpansecategorysInsert")
  996. public Map<String, Object> insertrmsexpansecategorys(@RequestBody(required = false) Map<String, Object> map) {
  997. map.put("insertUsername", map.get("userName").toString());
  998. return rmsFeign.addrmsexpansecategorys(map);
  999. }
  1000. @ApiOperation(value="费用类别删除")
  1001. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  1002. @PutMapping(value = "/rmsexpansecategorysDelete")
  1003. @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"费用类别"})
  1004. public Map<String, Object> rmsexpansecategorysDelete(@RequestBody(required = false) Map<String, Object> map){
  1005. return rmsFeign.rmsexpansecategorysdelete(map);
  1006. }
  1007. @ApiOperation(value="修改费用类别")
  1008. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  1009. @PutMapping(value = "/rmsexpansecategorysUpdate/{id}")
  1010. @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"费用类别"})
  1011. public Map<String, Object> rmsexpansecategorysUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
  1012. map.put("updateUsername", map.get("userName").toString());
  1013. return rmsFeign.rmsexpansecategorysupdate(id,map);
  1014. }
  1015. @ApiOperation(value = "业务类型")
  1016. @ApiImplicitParams({
  1017. @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
  1018. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  1019. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  1020. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  1021. })
  1022. @PostMapping(value = "/getBusinessType")
  1023. public Map<String, Object> getBusinessType(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
  1024. Integer pageNum,
  1025. Integer pageSize) {
  1026. return rmsFeign.getBusinessType(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
  1027. }
  1028. @ApiOperation(value="新增业务类型")
  1029. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  1030. @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"业务类型"})
  1031. @PostMapping("/insertBusinessType")
  1032. public Map<String, Object> insertBusinessType(@RequestBody(required = false) Map<String, Object> map) {
  1033. map.put("insertUsername", map.get("userName").toString());
  1034. return rmsFeign.insertBusinessType(map);
  1035. }
  1036. @ApiOperation(value = "审批流程")
  1037. @ApiImplicitParams({
  1038. @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
  1039. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  1040. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  1041. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  1042. })
  1043. @PostMapping(value = "/getapprovelines")
  1044. public Map<String, Object> getrmsapprovelines(@RequestBody(required = false) Map<String, Object> mapValue,
  1045. Integer pageNum,
  1046. Integer pageSize,
  1047. Integer apiId) {
  1048. return rmsFeign.getrmsapprovelines(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId);
  1049. }
  1050. @ApiOperation(value="新增审批流程")
  1051. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  1052. @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"业务类型"})
  1053. @PostMapping("/addapprovelines")
  1054. public Map<String, Object> addapprovelines(@RequestBody(required = false) Map<String, Object> map) {
  1055. return rmsFeign.addapprovelines(map);
  1056. }
  1057. @ApiOperation(value="更新审批流程")
  1058. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  1059. @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"业务类型"})
  1060. @PostMapping("/updateapprovelines")
  1061. public Map<String, Object> updateapprovelines(@RequestBody(required = false) Map<String, Object> map) {
  1062. return rmsFeign.updateapprovelines(map);
  1063. }
  1064. @ApiOperation(value="删除审批流程")
  1065. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  1066. @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"业务类型"})
  1067. @PostMapping("/approvelinesdelete")
  1068. public Map<String, Object> approvelinesdelete(@RequestBody(required = false) Map<String, Object> map) {
  1069. return rmsFeign.approvelinesdelete(map);
  1070. }
  1071. @ApiOperation(value = "燃料类型")
  1072. @ApiImplicitParams({
  1073. @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
  1074. @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
  1075. @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
  1076. @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
  1077. })
  1078. @PostMapping("/getFuelTypeList")
  1079. public Map<String, Object> getFuelTypeList(@RequestBody(required = false) Map<String,Object> map,
  1080. @RequestParam("apiId") Integer apiId,
  1081. @RequestParam("pageNum") Integer pageNum,
  1082. @RequestParam("pageSize") Integer pageSize) {
  1083. return rmsFeign.getFuelTypeList(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
  1084. }
  1085. @ApiOperation(value="新增燃料类型")
  1086. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  1087. @LogAround(foreignKeys = {"fuelTypeId"},foreignKeyTypes = {"燃料类型"})
  1088. @PostMapping("/insertFuelType")
  1089. public Map<String, Object> insertFuelType(@RequestBody(required = false)Map<String, Object> map){
  1090. return rmsFeign.insertFuelType(map);
  1091. }
  1092. @ApiOperation(value="删除燃料类型")
  1093. @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
  1094. @LogAround(foreignKeys = {"fuelTypeId"},foreignKeyTypes = {"燃料类型"})
  1095. @PostMapping("/deleteFuelType")
  1096. public Map<String, Object> deleteFuelType(@RequestBody(required = false) Map<String, Object> map) {
  1097. return rmsFeign.deleteFuelType(map);
  1098. }
  1099. }