| | |
| | | <project xmlns="http://maven.apache.org/POM/4.0.0" |
| | | xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" |
| | | xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> |
| | | <modelVersion>4.0.0</modelVersion> |
| | | <parent> |
| | | <groupId>com.lx</groupId> |
| | | <artifactId>product-server</artifactId> |
| | | <groupId>com.lx</groupId> |
| | | <version>1.0.0-SNAPSHOT</version> |
| | | </parent> |
| | | <artifactId>product-server-seal</artifactId> |
| | | <name>product-server-seal</name> |
| | | <description>product-server-seal</description> |
| | | <modelVersion>4.0.0</modelVersion> |
| | | |
| | | <artifactId>product-server-badge</artifactId> |
| | | <name>product-server-badge</name> |
| | | <url>http://maven.apache.org</url> |
| | | <properties> |
| | | <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> |
| | | </properties> |
| | | <dependencies> |
| | | <dependency> |
| | | <groupId>com.lx</groupId> |
| | |
| | | </dependency> |
| | | <dependency> |
| | | <groupId>com.lx</groupId> |
| | | <artifactId>product-server-core</artifactId> |
| | | <version>1.0.0-releases</version> |
| | | <artifactId>product-server-admin</artifactId> |
| | | <version>1.0.0-SNAPSHOT</version> |
| | | </dependency> |
| | | <dependency> |
| | | <groupId>org.spring</groupId> |
| | | <artifactId>spring-server-master</artifactId> |
| | | <version>1.2.6.6</version> |
| | | </dependency> |
| | | </dependencies> |
| | | <build> |
| | | <plugins> |
| | | <!-- æJARå
--> |
| | | |
| | | <plugin> |
| | | <groupId>org.apache.maven.plugins</groupId> |
| | | <artifactId>maven-jar-plugin</artifactId> |
| | | <configuration> |
| | | <!-- 䏿å
èµæºæä»¶ï¼é
ç½®æä»¶åä¾èµå
åå¼ï¼ --> |
| | | <excludes> |
| | | <exclude>*.properties</exclude> |
| | | <exclude>*.xml</exclude> |
| | | </excludes> |
| | | <archive> |
| | | <manifest> |
| | | <addClasspath>true</addClasspath> |
| | | <!-- MANIFEST.MF ä¸ Class-Path å å
¥åç¼ --> |
| | | <classpathPrefix>lib/</classpathPrefix> |
| | | <!-- jarå
ä¸å
å«å¯ä¸çæ¬æ è¯ --> |
| | | <useUniqueVersions>true</useUniqueVersions> |
| | | <!--æå®å
¥å£ç±» --> |
| | | <mainClass>com.product.Application</mainClass> |
| | | </manifest> |
| | | <manifestEntries> |
| | | <!--MANIFEST.MF ä¸ Class-Path å å
¥èµæºæä»¶ç®å½ --> |
| | | <Class-Path>./resources/</Class-Path> |
| | | </manifestEntries> |
| | | |
| | | </archive> |
| | | <outputDirectory>${project.build.directory}</outputDirectory> |
| | | </configuration> |
| | | </plugin> |
| | | <!-- æ·è´æä»¶ --> |
| | | <plugin> |
| | | <artifactId>maven-antrun-plugin</artifactId> |
| | | <executions> |
| | | <execution> |
| | | <id>copy</id> |
| | | <phase>package</phase> |
| | | <configuration> |
| | | <tasks> |
| | | <copy file="${project.build.directory}/product-server-seal-1.0.0-SNAPSHOT.jar" |
| | | tofile="D:/product/workspace/product-server-install/resources/product-server/product-server-web-1.0.0-SNAPSHOT.jar" |
| | | overwrite="true"/> |
| | | </tasks> |
| | | |
| | | </configuration> |
| | | <goals> |
| | | <goal>run</goal> |
| | | </goals> |
| | | </execution> |
| | | </executions> |
| | | </plugin> |
| | | |
| | | </plugins> |
| | | </build> |
| | | </project> |
| | | </project> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge.config; |
| | | |
| | | import com.product.common.enums.IEnum; |
| | | import com.product.common.enums.ModuleEnum; |
| | | |
| | | /** |
| | | * Copyright © 6c |
| | | * |
| | | * @Date: 2021-06-01 09:54 |
| | | * @Author: 6c |
| | | * @Description: |
| | | */ |
| | | public enum BadgeCode implements IEnum { |
| | | BADGE_OPERATION_SUCCESS("æå", "200"), |
| | | |
| | | BADGE_SAVE_FAIL("è¯ç« ä¿å失败", ModuleEnum.BADGE.getValue() + "001"), |
| | | BADGE_DELETE_FAIL("è¯ç« å é¤å¤±è´¥", ModuleEnum.BADGE.getValue() + "002"), |
| | | BADGE_GET_LIST_FAIL("è¯ç« å表è·å失败", ModuleEnum.BADGE.getValue() + "003"), |
| | | BADGE_GET_INFO_FAIL("è¯ç« ä¿¡æ¯è·å失败", ModuleEnum.BADGE.getValue() + "004"), |
| | | |
| | | BADGE_USE_SAVE_FAIL("å°ç« 使ç¨è®°å½ä¿å失败", ModuleEnum.BADGE.getValue() + "021"), |
| | | BADGE_USE_DELETE_FAIL("å°ç« 使ç¨è®°å½å é¤å¤±è´¥", ModuleEnum.BADGE.getValue() + "022"), |
| | | BADGE_USE_GET_LIST_FAIL("å°ç« 使ç¨è®°å½å表è·å失败", ModuleEnum.BADGE.getValue() + "023"), |
| | | BADGE_USE_GET_INFO_FAIL("å°ç« 使ç¨è®°å½ä¿¡æ¯è·å失败", ModuleEnum.BADGE.getValue() + "024"), |
| | | |
| | | BADGE_BORROW_SAVE_FAIL("è¯ç« åç¨ä¿å失败", ModuleEnum.BADGE.getValue() + "031"), |
| | | BADGE_BORROW_GET_LIST_FAIL("è·åè¯ç« åç¨å表失败", ModuleEnum.BADGE.getValue() + "032"), |
| | | BADGE_BORROW_BOARD_FAIL("è·åè¯ç« åç¨çæ¿å¤±è´¥", ModuleEnum.BADGE.getValue() + "033"), |
| | | GET_BADGE_BORROW_AND_RETURN_RECORD_FAIL("è·åè¯ç« åè¿è®°å½å¤±è´¥", ModuleEnum.BADGE.getValue() + "034"), |
| | | BADGE_GET_GIVE_BACK_INFO_FAIL("è·åè¯ç« 详æ
失败", ModuleEnum.BADGE.getValue() + "035"), |
| | | BADGE_GIVE_BACK_FAIL("è¯ç« å½è¿å¤±è´¥", ModuleEnum.BADGE.getValue() + "036"), |
| | | BADGE_GIVE_BACK_GET_LIST_FAIL("è·åè¯ç« å½è¿å表失败", ModuleEnum.BADGE.getValue() + "037"), |
| | | BADGE_GIVE_BACK_GET_INFO_FAIL("è·ååç¨å表详æ
失败", ModuleEnum.BADGE.getValue() + "038"), |
| | | BADGE_GET_BORROW_AND_RETURN_TABLE_NAME_FAIL("è·åè¯ç« åè¿è®°å½è¡¨å失败", ModuleEnum.BADGE.getValue() + "039"), |
| | | |
| | | |
| | | SYSTEM_FORM_NODATA("请æ±è¡¨ååæ°ä¸ºç©º", ModuleEnum.BADGE.getValue() + "100"), |
| | | SYSTEM_TABLE_NODATA("请æ±åæ°è¡¨å为空", ModuleEnum.BADGE.getValue() + "101"), |
| | | |
| | | ; |
| | | private String text; |
| | | private String value; |
| | | |
| | | private BadgeCode(String text, String value) { |
| | | this.text = text; |
| | | this.value = value; |
| | | } |
| | | public String getText() { |
| | | return text; |
| | | } |
| | | public String getValue() { |
| | | return value; |
| | | } |
| | | |
| | | @Override |
| | | public String toString() { |
| | | return value + ": " + text; |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge.config; |
| | | |
| | | /** |
| | | * Copyright © 6c |
| | | * |
| | | * @Date: 2021-03-19 08:45 |
| | | * @Author: 6c |
| | | * @Description: |
| | | */ |
| | | public class CmnConst { |
| | | private CmnConst() {} |
| | | |
| | | // 表å |
| | | public static final String TABLE_PRODUCT_OA_BADGE_COMPANY = "product_oa_badge_company";// å
¬å¸è¯ç« |
| | | public static final String TABLE_PRODUCT_OA_BADGE_COMPANY_CERTIFICATE_CHANGE = "product_oa_badge_company_certificate_change";// å
¬å¸è¯ä¹¦åå¨ |
| | | public static final String TABLE_PRODUCT_OA_BADGE_COMPANY_QUALIFICATION = "product_oa_badge_company_qualification";// å
¬å¸èµè´¨è¯ç« |
| | | public static final String TABLE_PRODUCT_OA_BADGE_CONSTRUCTOR = "product_oa_badge_constructor";// 建é å¸è¯ç« |
| | | public static final String TABLE_PRODUCT_OA_BADGE_COST_OFFICER = "product_oa_badge_cost_officer";// é 价人å |
| | | public static final String TABLE_PRODUCT_OA_BADGE_SAFETY_OFFICER = "product_oa_badge_safety_officer";// å®å
¨äººå |
| | | public static final String TABLE_PRODUCT_OA_BADGE_SCENE_MANAGE = "product_oa_badge_scene_manage";// ç°åºç®¡ç |
| | | public static final String TABLE_PRODUCT_OA_BADGE_SCENE_OFFICER = "product_oa_badge_scene_officer";// ç°åºå·¥äºº |
| | | public static final String TABLE_PRODUCT_OA_BADGE_MANAGER = "product_oa_badge_manager";// 管ç人å |
| | | public static final String TABLE_PRODUCT_OA_BADGE_FINANCE_MANAGE = "product_oa_badge_finance_manage";// è´¢å¡ç®¡ç |
| | | public static final String TABLE_PRODUCT_OA_BADGE_AWARDS = "product_oa_badge_awards";// è·å¥ä¿¡æ¯ |
| | | public static final String TABLE_PRODUCT_OA_BADGE_USE_RECORD = "product_oa_badge_use_record";// å°ç« ä½¿ç¨ |
| | | public static final String TABLE_PRODUCT_OA_BADGE_BORROW_RECORD = "product_oa_badge_borrow_record";// è¯ç« åç¨ç»è®° |
| | | public static final String TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL = "product_oa_badge_borrow_detail";// è¯ç« åç¨æç» |
| | | public static final String TABLE_PRODUCT_OA_BADGE_BORROW_V = "product_oa_badge_borrow_v";// è¯ç« åç¨è§å¾ |
| | | |
| | | // å页常éå®ä¹ |
| | | public static final String CUR_PAGE = "cpage"; // é¡µæ° |
| | | public static final String PAGE_SIZE = "pagesize"; // æ¯é¡µæ¡æ° |
| | | |
| | | // åæ®µ-éç¨ |
| | | public static final String FIELD_ID = "id"; |
| | | public static final String FIELD_UUID = "uuid"; |
| | | public static final String FIELD_TABLE_NAME = "table_name"; |
| | | public static final String FIELD_TABLE_UUID = "table_uuid"; |
| | | public static final String FIELD_ORDER_BY = "order_by"; |
| | | public static final String FIELD_CREATED_BY = "created_by"; |
| | | public static final String FIELD_CREATED_UTC_DATETIME = "created_utc_datetime"; |
| | | public static final String FIELD_UPDATED_BY = "updated_by"; |
| | | public static final String FIELD_UPDATED_UTC_DATETIME = "updated_utc_datetime"; |
| | | public static final String FIELD_BADGE_LEVEL = "badge_level"; |
| | | public static final String FIELD_BADGE_TYPE = "badge_type"; |
| | | public static final String FIELD_IS_VALID = "is_valid"; |
| | | public static final String FIELD_BADGE_UUID = "badge_uuid"; |
| | | public static final String FIELD_ORG_LEVEL_UUID = "org_level_uuid"; |
| | | public static final String FIELD_DEPT_UUID = "dept_uuid"; |
| | | |
| | | |
| | | // åæ®µ-è¯ç« åç¨ |
| | | public static final String FIELD_BADGE_BORROW_REASON = "borrow_reason"; |
| | | public static final String FIELD_BADGE_BORROW_RETURN_DATE = "return_date"; |
| | | public static final String FIELD_BADGE_BORROW_RETURN_BY = "return_by"; |
| | | |
| | | // ç¼å |
| | | public static final String CACHE_TABLE = "ææè¡¨ä¿¡æ¯(uuid)"; |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge.controller; |
| | | |
| | | import com.product.admin.service.PublicService; |
| | | import com.product.admin.service.idel.IPublicService; |
| | | import com.product.badge.config.BadgeCode; |
| | | import com.product.badge.config.CmnConst; |
| | | import com.product.badge.service.BadgeBorrowService; |
| | | import com.product.badge.service.idel.IBadgeBorrowService; |
| | | import com.product.common.lang.StringUtils; |
| | | import com.product.core.config.CoreConst; |
| | | import com.product.core.controller.support.AbstractBaseController; |
| | | import com.product.core.entity.FieldSetEntity; |
| | | import com.product.core.entity.RequestParameterEntity; |
| | | import com.product.core.exception.BaseException; |
| | | import com.product.core.spring.context.SpringMVCContextHolder; |
| | | import com.product.module.sys.version.ApiVersion; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RequestMethod; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | |
| | | /** |
| | | * @Date: 2021-06-03 09:09 |
| | | * @Description: è¯ç« åç¨ |
| | | */ |
| | | @RestController |
| | | @RequestMapping("/api/badge-borrow") |
| | | public class BadgeBorrowController extends AbstractBaseController { |
| | | |
| | | private Logger logger = LoggerFactory.getLogger(BadgeBorrowController.class); |
| | | @Autowired |
| | | private BadgeBorrowService service; |
| | | @Autowired |
| | | public PublicService publicService; |
| | | |
| | | /** |
| | | * åç¨ |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/borrow/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String borrow(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | IBadgeBorrowService iBadgeBorrowService = (IBadgeBorrowService) getProxyInstance(service); |
| | | String uuid = iBadgeBorrowService.borrow(fse); |
| | | return OK_Add(uuid); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_BORROW_SAVE_FAIL.getValue(), BadgeCode.BADGE_BORROW_SAVE_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * åç¨å表å±ç¤º |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/list/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String list(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return OK_List(publicService.listTable(fse)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_BORROW_GET_LIST_FAIL.getValue(), BadgeCode.BADGE_BORROW_GET_LIST_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * å é¤ |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/delete/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String delete(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | IPublicService iPublicService = (IPublicService) getProxyInstance(publicService); |
| | | iPublicService.delete(fse); |
| | | return OK(); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_DELETE_FAIL.getValue(), BadgeCode.BADGE_DELETE_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * åç¨-è·ååç¨è¯¦æ
|
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/find-badge-borrow-info/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String findBadgeBorrowInfo(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return OK_List(service.findBadgeBorrowInfo(fse)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_GET_GIVE_BACK_INFO_FAIL.getValue(), BadgeCode.BADGE_GET_GIVE_BACK_INFO_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * å½è¿-å表 |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/get-give-back-list/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String getGiveBackList(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return OK_List(service.getGiveBackList(fse)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_GIVE_BACK_GET_LIST_FAIL.getValue(), BadgeCode.BADGE_GIVE_BACK_GET_LIST_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * é¨åå½è¿-è·ååç¨å表详æ
|
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/part-give-back-find/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String partGiveBackFind(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return OK_List(service.partGiveBackFind(fse)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_GIVE_BACK_GET_INFO_FAIL.getValue(), BadgeCode.BADGE_GIVE_BACK_GET_INFO_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * å½è¿ |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/give-back/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String giveBack(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || (!CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL.equals(fse.getTableName()) && !CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equals(fse.getTableName()))) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | service.giveBack(fse); |
| | | return OK(); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_GIVE_BACK_FAIL.getValue(), BadgeCode.BADGE_GIVE_BACK_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * è¯ç« åç¨çæ¿ |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/borrow-board/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String borrowBoard(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return OK_List(service.borrowBoard(fse)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_BORROW_GET_LIST_FAIL.getValue(), BadgeCode.BADGE_BORROW_GET_LIST_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * è¯ç« åè¿è®°å½ |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/get-badge-borrow-and-return-record/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String getBadgeBorrowAndReturnRecord(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | return OK_List(service.getBadgeBorrowAndReturnRecord(fse)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.GET_BADGE_BORROW_AND_RETURN_RECORD_FAIL.getValue(), BadgeCode.GET_BADGE_BORROW_AND_RETURN_RECORD_FAIL.getText()); |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge.controller; |
| | | |
| | | import com.product.admin.service.PublicService; |
| | | import com.product.admin.service.idel.IPublicService; |
| | | import com.product.badge.config.BadgeCode; |
| | | import com.product.badge.config.CmnConst; |
| | | import com.product.badge.service.BadgeService; |
| | | import com.product.core.config.CoreConst; |
| | | import com.product.core.controller.support.AbstractBaseController; |
| | | import com.product.core.entity.DataTableEntity; |
| | | import com.product.core.entity.FieldSetEntity; |
| | | import com.product.core.entity.RequestParameterEntity; |
| | | import com.product.core.exception.BaseException; |
| | | import com.product.core.spring.context.SpringMVCContextHolder; |
| | | import com.product.module.sys.version.ApiVersion; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RequestMethod; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | |
| | | /** |
| | | * Copyright © 6c |
| | | * |
| | | * @Date: 2021-06-01 09:52 |
| | | * @Author: 6c |
| | | * @Description: å
¬å¸è¯ç« |
| | | */ |
| | | @RestController |
| | | @RequestMapping("/api/badge") |
| | | public class BadgeController extends AbstractBaseController { |
| | | |
| | | private Logger logger = LoggerFactory.getLogger(BadgeController.class); |
| | | @Autowired |
| | | private BadgeService badgeService; |
| | | @Autowired |
| | | private PublicService publicService; |
| | | |
| | | /** |
| | | * å表è·å |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/list/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String list(HttpServletRequest request) { |
| | | String tableName = ""; |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | tableName = fse.getTableName(); |
| | | DataTableEntity dte; |
| | | if (CmnConst.TABLE_PRODUCT_OA_BADGE_COMPANY_CERTIFICATE_CHANGE.equals(tableName)) { |
| | | dte = publicService.listTable(fse); |
| | | } else { |
| | | dte = badgeService.listTable(fse); |
| | | } |
| | | return OK_List(dte); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_GET_LIST_FAIL.getValue(), BadgeCode.BADGE_GET_LIST_FAIL.getText() + ": " + tableName); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * ä¿å |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/save/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String save(HttpServletRequest request) { |
| | | String tableName = ""; |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | tableName = fse.getTableName(); |
| | | IPublicService iPublicService = (IPublicService) getProxyInstance(publicService); |
| | | String uuid = iPublicService.saveFieldSetEntity(fse); |
| | | return OK_Add(uuid); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_SAVE_FAIL.getValue(), BadgeCode.BADGE_SAVE_FAIL.getText() + ": " + tableName); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * æ¥è¯¢ |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/find/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String find(HttpServletRequest request) { |
| | | String tableName = ""; |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | tableName = fse.getTableName(); |
| | | return OK_List(publicService.getFieldSetEntity(fse, false)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_GET_INFO_FAIL.getValue(), BadgeCode.BADGE_GET_INFO_FAIL.getText() + ": " + tableName); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * å é¤ |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/delete/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String delete(HttpServletRequest request) { |
| | | String tableName = ""; |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | tableName = fse.getTableName(); |
| | | return publicService.delete(fse) ? OK() : error(BadgeCode.BADGE_DELETE_FAIL.getValue(), BadgeCode.BADGE_DELETE_FAIL.getText() + ": " + tableName); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_DELETE_FAIL.getValue(), BadgeCode.BADGE_DELETE_FAIL.getText() + ": " + tableName); |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge.controller; |
| | | |
| | | import com.product.admin.service.PublicService; |
| | | import com.product.badge.config.BadgeCode; |
| | | import com.product.badge.config.CmnConst; |
| | | import com.product.core.config.CoreConst; |
| | | import com.product.core.controller.support.AbstractBaseController; |
| | | import com.product.core.entity.FieldSetEntity; |
| | | import com.product.core.entity.RequestParameterEntity; |
| | | import com.product.core.exception.BaseException; |
| | | import com.product.core.spring.context.SpringMVCContextHolder; |
| | | import com.product.module.sys.version.ApiVersion; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RequestMethod; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | |
| | | /** |
| | | * @Date: 2021-06-03 09:09 |
| | | * @Description: å°ç« 使ç¨è®°å½ |
| | | */ |
| | | @RestController |
| | | @RequestMapping("/api/badge-use") |
| | | public class BadgeUseController extends AbstractBaseController { |
| | | |
| | | private Logger logger = LoggerFactory.getLogger(BadgeUseController.class); |
| | | @Autowired |
| | | public PublicService publicService; |
| | | |
| | | /** |
| | | * å表è·å |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/list/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String list(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_USE_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return OK_List(publicService.listTable(fse)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_USE_GET_LIST_FAIL.getValue(), BadgeCode.BADGE_USE_GET_LIST_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * ä¿å |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/save/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String save(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_USE_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return OK_Add(publicService.saveFieldSetEntity(fse)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_USE_SAVE_FAIL.getValue(), BadgeCode.BADGE_USE_SAVE_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * å é¤ |
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/delete/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String delete(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_USE_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return publicService.delete(fse) ? OK() : error(BadgeCode.BADGE_USE_DELETE_FAIL.getValue(), BadgeCode.BADGE_USE_DELETE_FAIL.getText()); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_USE_DELETE_FAIL.getValue(), BadgeCode.BADGE_USE_DELETE_FAIL.getText()); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * æ¥è¯¢è¯¦æ
|
| | | * @param request |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/find/{version}", method = RequestMethod.POST) |
| | | @ApiVersion(1) |
| | | public String find(HttpServletRequest request) { |
| | | try { |
| | | FieldSetEntity fse = null; |
| | | Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA); |
| | | if (bean != null) { |
| | | RequestParameterEntity reqp = (RequestParameterEntity) bean; |
| | | fse = reqp.getFormData(); |
| | | } |
| | | if (bean == null || fse == null) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_FORM_NODATA.getValue(), BadgeCode.SYSTEM_FORM_NODATA.getText()); |
| | | } |
| | | if (fse.getTableName() == null || !CmnConst.TABLE_PRODUCT_OA_BADGE_USE_RECORD.equals(fse.getTableName())) { |
| | | SpringMVCContextHolder.getSystemLogger().error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | return this.error(BadgeCode.SYSTEM_TABLE_NODATA.getValue(), BadgeCode.SYSTEM_TABLE_NODATA.getText()); |
| | | } |
| | | return OK_List(publicService.getFieldSetEntity(fse, false)); |
| | | } catch (BaseException e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | return this.error(e.getCode(), e.getMessageInfo()); |
| | | } catch (Exception e) { |
| | | SpringMVCContextHolder.getSystemLogger().error(e); |
| | | e.printStackTrace(); |
| | | return error(BadgeCode.BADGE_USE_GET_INFO_FAIL.getValue(), BadgeCode.BADGE_USE_GET_INFO_FAIL.getText()); |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge.service; |
| | | |
| | | import com.product.badge.config.BadgeCode; |
| | | import com.product.badge.config.CmnConst; |
| | | import com.product.badge.service.idel.IBadgeBorrowService; |
| | | import com.product.common.lang.StringUtils; |
| | | import com.product.core.cache.DataPoolCacheImpl; |
| | | import com.product.core.dao.BaseDao; |
| | | import com.product.core.entity.DataTableEntity; |
| | | import com.product.core.entity.FieldSetEntity; |
| | | import com.product.core.exception.BaseException; |
| | | import com.product.core.service.support.AbstractBaseService; |
| | | import com.product.core.service.support.QueryFilterService; |
| | | import com.product.core.spring.context.SpringMVCContextHolder; |
| | | import com.product.core.transfer.Transactional; |
| | | import com.product.module.sys.entity.SystemUser; |
| | | import com.product.util.BaseUtil; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @Date: 2021-06-03 08:37 |
| | | * @Description: è¯ç« åç¨ |
| | | */ |
| | | @Service |
| | | public class BadgeBorrowService extends AbstractBaseService implements IBadgeBorrowService { |
| | | @Autowired |
| | | public BaseDao baseDao; |
| | | @Autowired |
| | | public QueryFilterService queryFilterService; |
| | | |
| | | /** |
| | | * åç¨ |
| | | * @param fse |
| | | * @return |
| | | */ |
| | | @Transactional |
| | | @Override |
| | | public String borrow(FieldSetEntity fse) { |
| | | SystemUser curUser = SpringMVCContextHolder.getCurrentUser(); |
| | | if (StringUtils.isEmpty(fse.getUUID())) { |
| | | // æ°å¢ |
| | | BaseUtil.createCreatorAndCreationTime(curUser, fse); |
| | | } else { |
| | | // ä¿®æ¹ |
| | | BaseUtil.updatedRegeneratorAndUpdateTime(curUser, fse); |
| | | } |
| | | fse.setValue(CmnConst.FIELD_ORG_LEVEL_UUID, SpringMVCContextHolder.getCurrentUser().getOrg_level_uuid()); |
| | | fse.setValue(CmnConst.FIELD_DEPT_UUID, SpringMVCContextHolder.getCurrentUser().getDept_uuid()); |
| | | FieldSetEntity tempFse; |
| | | DataTableEntity dte = fse.getSubDataTable(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL); |
| | | fse.removeSubData(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL); |
| | | DataTableEntity subDte = new DataTableEntity(); |
| | | FieldSetEntity subFse; |
| | | String[] arr; |
| | | for (int i = 0;i < dte.getRows();i++) { |
| | | tempFse = dte.getFieldSetEntity(i); |
| | | arr = tempFse.getString(CmnConst.FIELD_BADGE_UUID).split(","); |
| | | for (String badgeUUID : arr) { |
| | | subFse = tempFse.clones(); |
| | | subFse.setValue(CmnConst.FIELD_BADGE_UUID, badgeUUID); |
| | | subDte.addFieldSetEntity(subFse); |
| | | } |
| | | } |
| | | fse.addSubDataTable(subDte); |
| | | baseDao.saveFieldSetEntity(fse); |
| | | return fse.getUUID(); |
| | | } |
| | | |
| | | /** |
| | | * åç¨-è·ååç¨è¯¦æ
|
| | | * @param fse |
| | | * @return |
| | | */ |
| | | public FieldSetEntity findBadgeBorrowInfo(FieldSetEntity fse) { |
| | | FieldSetEntity recordFse = baseDao.getFieldSetEntity(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD, fse.getUUID(), false); |
| | | StringBuilder sql = new StringBuilder(128); |
| | | sql.append("select badge_level,badge_type,GROUP_CONCAT(badge_uuid) badge_uuid") |
| | | .append("\nfrom product_oa_badge_borrow_detail") |
| | | .append("\nwhere record_uuid=?") |
| | | .append("\ngroup by badge_level,badge_type"); |
| | | DataTableEntity detailDte = baseDao.listTable(sql.toString(), new Object[]{fse.getUUID()}); |
| | | recordFse.addSubDataTable(detailDte); |
| | | return recordFse; |
| | | } |
| | | |
| | | /** |
| | | * å½è¿-å表 |
| | | * @param fse |
| | | * @return |
| | | */ |
| | | public DataTableEntity getGiveBackList(FieldSetEntity fse) { |
| | | StringBuilder sql = new StringBuilder(128); |
| | | sql.append("select * from product_oa_badge_borrow_record r") |
| | | .append("\ninner join (") |
| | | .append("\n select distinct record_uuid from product_oa_badge_borrow_detail") |
| | | .append("\n where return_date is null") |
| | | .append("\n) d on r.uuid=d.record_uuid"); |
| | | int pageSize = fse.getInteger(CmnConst.PAGE_SIZE) == null ? Integer.MAX_VALUE : fse.getInteger(CmnConst.PAGE_SIZE); |
| | | int curPage = fse.getInteger(CmnConst.CUR_PAGE) == null ? 1 : fse.getInteger(CmnConst.CUR_PAGE); |
| | | DataTableEntity dte = baseDao.listTable(sql.toString(), new Object[]{}, pageSize, curPage); |
| | | baseDao.loadPromptData(dte); |
| | | return dte; |
| | | } |
| | | |
| | | /** |
| | | * å½è¿-é¨åå½è¿-è·ååç¨å表详æ
|
| | | * @param fse |
| | | * @return |
| | | */ |
| | | public FieldSetEntity partGiveBackFind(FieldSetEntity fse) { |
| | | String recordUUID = fse.getUUID(); |
| | | DataTableEntity detailDte = baseDao.listTable(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL, "return_date is null and record_uuid=?", new Object[]{recordUUID}); |
| | | baseDao.loadPromptData(detailDte); |
| | | FieldSetEntity recordFse = baseDao.getFieldSetEntity(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD, recordUUID, false); |
| | | baseDao.loadPromptData(recordFse); |
| | | recordFse.addSubDataTable(detailDte); |
| | | return recordFse; |
| | | } |
| | | |
| | | /** |
| | | * å½è¿ |
| | | * @param fse |
| | | */ |
| | | public void giveBack(FieldSetEntity fse) { |
| | | String uuids = fse.getUUID(); |
| | | if (StringUtils.isEmpty(uuids)) { |
| | | return; |
| | | } |
| | | SystemUser curUser = SpringMVCContextHolder.getCurrentUser(); |
| | | String tableName = fse.getTableName(); |
| | | DataTableEntity dte = null; |
| | | if (CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD.equalsIgnoreCase(tableName)) { |
| | | // å½è¿ææ |
| | | dte = baseDao.listTable(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL, "record_uuid=? and return_date is null", new Object[]{uuids}); |
| | | } |
| | | if (CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL.equalsIgnoreCase(tableName)) { |
| | | // é¨åå½è¿ |
| | | String[] uuidArr = uuids.split(","); |
| | | String filter = BaseUtil.buildQuestionMarkFilter(CmnConst.FIELD_UUID, uuidArr.length, true); |
| | | dte = baseDao.listTable(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL, filter, uuidArr); |
| | | } |
| | | if (!BaseUtil.dataTableIsEmpty(dte)) { |
| | | FieldSetEntity tempFse; |
| | | for (int i = 0; i < dte.getRows(); i++) { |
| | | tempFse = dte.getFieldSetEntity(i); |
| | | tempFse.setValue(CmnConst.FIELD_BADGE_BORROW_RETURN_DATE, new Date()); |
| | | tempFse.setValue(CmnConst.FIELD_BADGE_BORROW_RETURN_BY, curUser.getUser_id()); |
| | | baseDao.saveFieldSetEntity(tempFse); |
| | | } |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * è¯ç« åç¨çæ¿ |
| | | * @param fse |
| | | * @return |
| | | */ |
| | | public DataTableEntity borrowBoard(FieldSetEntity fse) { |
| | | StringBuilder sql = new StringBuilder(); |
| | | sql.append("\nselect d.table_uuid,d.uuid,table_name,c.org_level_name org_level_uuid,badge_name,type_name,cp.dict_label badge_type,holder,ifnull(badge_status,'æªååº') badge_status,borrow_by,borrow_time,return_date,useful_life "); |
| | | sql.append("\nfrom ( "); |
| | | sql.append("\n select '725928d8-a0ed-4f68-9e1d-87f66d899df0' table_uuid,'product_oa_badge_awards' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'è·å¥ä¿¡æ¯è¯ç« ' type_name,holder,'æ°¸ä¹
' useful_life from product_oa_badge_awards "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select '66d5e271-41bc-48c3-a0f5-6d696c70a036' table_uuid,'product_oa_badge_company' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'å
¬å¸è¯ç« ' type_name,holder,'æ°¸ä¹
' useful_life from product_oa_badge_company "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select '6468cd40-c9c9-41ff-b819-d670e3af9cee' table_uuid,'product_oa_badge_company_qualification' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'å
¬å¸èµè´¨è¯ç« ' type_name,holder,useful_life from product_oa_badge_company_qualification "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select 'a743e548-7b49-4f45-a072-acc03b873bdd' table_uuid,'product_oa_badge_constructor' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'建é å¸è¯ç« ' type_name,holder,'æ°¸ä¹
' useful_life from product_oa_badge_constructor "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select 'c07d0bcd-3e2d-43b9-9df0-ae60c6d57577' table_uuid,'product_oa_badge_cost_officer' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'é 价人åè¯ç« ' type_name,holder,useful_life from product_oa_badge_cost_officer "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select '3d6d8e93-f347-4a07-abb0-c6ec7ccf907b' table_uuid,'product_oa_badge_finance_manage' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'è´¢å¡ç®¡çè¯ç« ' type_name,holder,'æ°¸ä¹
' useful_life from product_oa_badge_finance_manage "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select '4cca65f6-dc58-443a-abb1-222524930d4c' table_uuid,'product_oa_badge_manager' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'管ç人åè¯ç« ' type_name,holder,useful_life from product_oa_badge_manager "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select 'a980ba45-e286-4e5d-ba39-a28d7a0de3dc' table_uuid,'product_oa_badge_safety_officer' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'å®å
¨äººåè¯ç« ' type_name,holder,'æ°¸ä¹
' useful_life from product_oa_badge_safety_officer "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select '53dc61c1-70d3-493b-b271-b886f723e50d' table_uuid,'product_oa_badge_scene_manage' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'ç°åºç®¡çè¯ç« ' type_name,holder,'æ°¸ä¹
' useful_life from product_oa_badge_scene_manage "); |
| | | sql.append("\n union all "); |
| | | sql.append("\n select '0761488e-d10f-4c25-8b57-469114d9b7b4' table_uuid,'product_oa_badge_scene_officer' table_name,org_level_uuid,badge_level,badge_type,badge_name,uuid,'ç°åºå·¥äººè¯ç« ' type_name,holder,'æ°¸ä¹
' useful_life from product_oa_badge_scene_officer "); |
| | | sql.append("\n) d "); |
| | | sql.append("\nleft join ( "); |
| | | sql.append("\n select b.* from ( "); |
| | | sql.append("\n select s.uuid,u.user_name borrow_by,m.created_utc_datetime borrow_time,s.return_by,s.return_date,badge_uuid, "); |
| | | sql.append("\n case when s.return_by is null or s.return_by='' then 'ååº' else 'å½è¿' END badge_status "); |
| | | sql.append("\n from product_oa_badge_borrow_record m "); |
| | | sql.append("\n left join product_oa_badge_borrow_detail s on m.uuid=s.record_uuid "); |
| | | sql.append("\n inner join product_sys_users u on u.user_id=m.created_by "); |
| | | sql.append("\n ) b "); |
| | | sql.append("\n inner join ( "); |
| | | sql.append("\n select uuid,max(created_utc_datetime) last_borrow_time "); |
| | | sql.append("\n from ( "); |
| | | sql.append("\n select s.uuid,m.created_utc_datetime "); |
| | | sql.append("\n from product_oa_badge_borrow_record m "); |
| | | sql.append("\n left join product_oa_badge_borrow_detail s "); |
| | | sql.append("\n on m.uuid=s.record_uuid "); |
| | | sql.append("\n ) b "); |
| | | sql.append("\n group by uuid "); |
| | | sql.append("\n ) t "); |
| | | sql.append("\n on b.uuid=t.uuid and b.borrow_time=t.last_borrow_time "); |
| | | sql.append("\n) b "); |
| | | sql.append("\non d.uuid=b.badge_uuid "); |
| | | sql.append("\ninner join ( "); |
| | | sql.append("\n select * FROM product_sys_dict where dict_name='badge_common_type' "); |
| | | sql.append("\n) cp on d.badge_type=cp.dict_value "); |
| | | sql.append("\ninner join product_sys_org_levels c on c.uuid=d.org_level_uuid "); |
| | | |
| | | String queryFilter = queryFilterService.getQueryFilter(fse); |
| | | if (!StringUtils.isEmpty(queryFilter)) { |
| | | sql.append("\nwhere ").append(queryFilter); |
| | | } |
| | | |
| | | int pageSize = fse.getInteger(CmnConst.PAGE_SIZE) == null ? Integer.MAX_VALUE : fse.getInteger(CmnConst.PAGE_SIZE); |
| | | int curPage = fse.getInteger(CmnConst.CUR_PAGE) == null ? 1 : fse.getInteger(CmnConst.CUR_PAGE); |
| | | DataTableEntity dte = baseDao.listTable(sql.toString(), new Object[]{}, pageSize, curPage); |
| | | dte.getMeta().addAliasTable(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD,"m"); |
| | | dte.getMeta().addAliasTable(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL, "s"); |
| | | dte.getMeta().addAliasField(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD + ".created_utc_datetime","borrow_time"); |
| | | baseDao.loadPromptData(dte); |
| | | return dte; |
| | | } |
| | | |
| | | /** |
| | | * è¯ç« åè¿è®°å½ |
| | | * @param fse |
| | | * @return |
| | | */ |
| | | public DataTableEntity getBadgeBorrowAndReturnRecord(FieldSetEntity fse) { |
| | | String tableUUID = fse.getString(CmnConst.FIELD_TABLE_UUID); |
| | | DataTableEntity tableCacheDte = DataPoolCacheImpl.getInstance().getCacheData(CmnConst.CACHE_TABLE, new String[]{tableUUID}); |
| | | if (BaseUtil.dataTableIsEmpty(tableCacheDte)) { |
| | | throw new BaseException(BadgeCode.BADGE_GET_BORROW_AND_RETURN_TABLE_NAME_FAIL.getValue(), BadgeCode.BADGE_GET_BORROW_AND_RETURN_TABLE_NAME_FAIL.getText()); |
| | | } |
| | | FieldSetEntity tableCacheFse = tableCacheDte.getFieldSetEntity(0); |
| | | String tableName = tableCacheFse.getString(CmnConst.FIELD_TABLE_NAME); |
| | | String badgeUUID = fse.getUUID(); |
| | | StringBuilder sql = new StringBuilder(512); |
| | | sql.append("\nselect b.*,org_level_uuid,badge_name,badge_level,badge_type,holder from ( "); |
| | | sql.append("\n select s.uuid,m.created_by borrow_by,m.created_utc_datetime borrow_time,s.return_by,s.return_date,badge_uuid "); |
| | | sql.append("\n from product_oa_badge_borrow_record m "); |
| | | sql.append("\n left join product_oa_badge_borrow_detail s "); |
| | | sql.append("\n on m.uuid=s.record_uuid "); |
| | | sql.append("\n) b "); |
| | | sql.append("\ninner join ").append(tableName).append(" d "); |
| | | sql.append("\non b.badge_uuid=d.uuid "); |
| | | sql.append("\nwhere d.uuid=?"); |
| | | |
| | | int pageSize = fse.getInteger(CmnConst.PAGE_SIZE) == null ? Integer.MAX_VALUE : fse.getInteger(CmnConst.PAGE_SIZE); |
| | | int curPage = fse.getInteger(CmnConst.CUR_PAGE) == null ? 1 : fse.getInteger(CmnConst.CUR_PAGE); |
| | | DataTableEntity dte = baseDao.listTable(sql.toString(), new Object[]{badgeUUID}, pageSize, curPage); |
| | | dte.getMeta().addAliasTable(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD, "m"); |
| | | dte.getMeta().addAliasTable(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_DETAIL, "s"); |
| | | dte.getMeta().addAliasField(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD + ".created_by","borrow_by"); |
| | | dte.getMeta().addAliasField(CmnConst.TABLE_PRODUCT_OA_BADGE_BORROW_RECORD + ".created_utc_datetime","borrow_time"); |
| | | baseDao.loadPromptData(dte); |
| | | return dte; |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge.service; |
| | | |
| | | import com.product.admin.service.PublicService; |
| | | import com.product.badge.config.CmnConst; |
| | | import com.product.common.lang.StringUtils; |
| | | import com.product.core.dao.BaseDao; |
| | | import com.product.core.entity.DataTableEntity; |
| | | import com.product.core.entity.FieldSetEntity; |
| | | import com.product.core.service.support.AbstractBaseService; |
| | | import com.product.core.service.support.QueryFilterService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * Copyright © 6c |
| | | * |
| | | * @Date: 2021-06-29 16:30 |
| | | * @Author: 6c |
| | | * @Description: |
| | | */ |
| | | @Service |
| | | public class BadgeService extends AbstractBaseService { |
| | | @Autowired |
| | | public BaseDao baseDao; |
| | | @Autowired |
| | | public QueryFilterService queryFilterService; |
| | | @Autowired |
| | | public PublicService publicService; |
| | | |
| | | /** |
| | | * å表å°è´¦ |
| | | * @param fse |
| | | * @return |
| | | */ |
| | | public DataTableEntity listTable(FieldSetEntity fse) { |
| | | StringBuilder sql = new StringBuilder(512); |
| | | sql.append("select * from ("); |
| | | sql.append("\nselect d.uuid,org_level_uuid,badge_name,badge_level,holder,badge_type,ifnull(badge_status,'æªååº') badge_status,borrow_by,borrow_time,return_date,flow_flag"); |
| | | sql.append("\nfrom ").append(fse.getTableName()).append(" d"); |
| | | sql.append("\nleft join ( "); |
| | | sql.append("\n select b.* from ( "); |
| | | sql.append("\n select s.uuid,m.created_by borrow_by,m.created_utc_datetime borrow_time,s.return_by,s.return_date,badge_uuid, "); |
| | | sql.append("\n case when s.return_by is null or s.return_by='' then 'ååº' else 'å½è¿' END badge_status "); |
| | | sql.append("\n from product_oa_badge_borrow_record m "); |
| | | sql.append("\n left join product_oa_badge_borrow_detail s "); |
| | | sql.append("\n on m.uuid=s.record_uuid "); |
| | | sql.append("\n ) b "); |
| | | sql.append("\n inner join ( "); |
| | | sql.append("\n select uuid,max(created_utc_datetime) last_borrow_time "); |
| | | sql.append("\n from ( "); |
| | | sql.append("\n select s.uuid,m.created_utc_datetime "); |
| | | sql.append("\n from product_oa_badge_borrow_record m "); |
| | | sql.append("\n left join product_oa_badge_borrow_detail s "); |
| | | sql.append("\n on m.uuid=s.record_uuid "); |
| | | sql.append("\n ) b "); |
| | | sql.append("\n group by uuid "); |
| | | sql.append("\n ) t "); |
| | | sql.append("\n on b.uuid=t.uuid and b.borrow_time=t.last_borrow_time "); |
| | | sql.append("\n) b "); |
| | | sql.append("\non d.uuid=b.badge_uuid "); |
| | | sql.append("\n) a "); |
| | | |
| | | |
| | | String filter = publicService.getListFilter(fse, 0); |
| | | |
| | | if (!StringUtils.isEmpty(filter)) { |
| | | sql.append(" where ").append(filter); |
| | | } |
| | | int pageSize = fse.getInteger(CmnConst.PAGE_SIZE) == null ? Integer.MAX_VALUE : fse.getInteger(CmnConst.PAGE_SIZE); |
| | | int curPage = fse.getInteger(CmnConst.CUR_PAGE) == null ? 1 : fse.getInteger(CmnConst.CUR_PAGE); |
| | | DataTableEntity dte = baseDao.listTable(sql.toString(), new Object[]{}, pageSize, curPage); |
| | | dte.getMeta().addAliasTable(fse.getTableName(),"d"); |
| | | baseDao.loadPromptData(dte); |
| | | return dte; |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge.service.idel; |
| | | |
| | | import com.product.core.entity.FieldSetEntity; |
| | | |
| | | /** |
| | | * Copyright © 6c |
| | | * |
| | | * @Date: 2021-06-03 11:54 |
| | | * @Author: 6c |
| | | * @Description: |
| | | */ |
| | | public interface IBadgeBorrowService { |
| | | String borrow(FieldSetEntity fse); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.product.badge; |
| | | |
| | | import com.google.common.collect.Maps; |
| | | import com.product.common.utils.HttpTest; |
| | | import org.assertj.core.util.Lists; |
| | | import org.junit.Test; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * Copyright © 6c |
| | | * |
| | | * @Date: 2021-06-02 11:31 |
| | | * @Author: 6c |
| | | * @Description: |
| | | */ |
| | | public class BadgeTest { |
| | | @Test |
| | | public void testList(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("url/api", "/api/badge/list/v1"); |
| | | m.put("~table~", "product_oa_badge_company_certificate_change"); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | @Test |
| | | public void testSave(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("url/api", "/api/badge/save/v1"); |
| | | // å
¬å¸è¯ä¹¦åå¨ |
| | | // m.put("~table~", "product_oa_badge_company_certificate_change"); |
| | | // m.put("org_level_uuid", "6c-test-org_level_uuid"); |
| | | // m.put("certificate_name", "èå©ä¹è¯"); |
| | | // m.put("certificate_type", "0"); |
| | | // m.put("certificate_level", "0"); |
| | | // m.put("change_type", "1"); |
| | | |
| | | // è·å¥ä¿¡æ¯ |
| | | // m.put("~table~", "product_oa_badge_awards"); |
| | | // m.put("org_level_uuid", "6c-test-org_level_uuid"); |
| | | // m.put("is_valid", "1"); |
| | | // m.put("prizewinner", "å¼ ä¸"); |
| | | // m.put("badge_name", "äºæéå¹´"); |
| | | // m.put("holder", "å¼ ä¸"); |
| | | // m.put("badge_level", "0"); |
| | | // m.put("badge_type", "0"); |
| | | // m.put("certificate_authority", "æ¸
åé年宫"); |
| | | // m.put("awards_show", "æäºå®"); |
| | | |
| | | // é 价人åè¯ç« |
| | | m.put("~table~", "product_oa_badge_cost_officer"); |
| | | m.put("is_valid", "1"); |
| | | m.put("open_date", new Date()); |
| | | m.put("badge_name", "åä½³éå¹´"); |
| | | m.put("holder", "æç¦"); |
| | | m.put("badge_level", "0"); |
| | | m.put("badge_type", "0"); |
| | | m.put("useful_life", new Date()); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | @Test |
| | | public void testDelete(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("url/api", "/api/badge/delete/v1"); |
| | | m.put("~table~", "product_oa_badge_company_certificate_change"); |
| | | m.put("uuid", "e7bc1ac1-f6c4-4610-8340-dbf0f348ef23"); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | /** |
| | | * åç¨-ä¿å |
| | | */ |
| | | @Test |
| | | public void testBadgeBorrowSave(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("~table~", "product_oa_badge_borrow_record"); |
| | | m.put("url/api", "/api/badge-borrow/borrow/v1"); |
| | | m.put("borrow_reason", "å忥çå"); |
| | | |
| | | // ----------å表-------------- |
| | | List<Map<String, Object>> languageValuesList = Lists.newArrayList(); |
| | | // Map<String, Object> languageValue1 = Maps.newHashMap(); |
| | | // languageValue1.put("badge_level", "0"); |
| | | // languageValue1.put("badge_type", "0"); |
| | | // languageValue1.put("badge_uuid", "c3595c5a-a607-4806-ab90-69b1f552438d,23c10c4b-2852-49c9-9ed1-952f6326fc92"); |
| | | // languageValuesList.add(languageValue1); |
| | | |
| | | // Map<String, Object> languageValue2 = Maps.newHashMap(); |
| | | // languageValue2.put("badge_level", "0"); |
| | | // languageValue2.put("badge_type", "0"); |
| | | // languageValue2.put("badge_uuid", "bf8abe73-99f9-4cc5-b8bb-a9b21877d479,9fa3c9ee-309e-4cbb-9fdb-b71a24a53882"); |
| | | // languageValuesList.add(languageValue2); |
| | | |
| | | Map<String, Object> languageValue3 = Maps.newHashMap(); |
| | | languageValue3.put("badge_level", "0"); |
| | | languageValue3.put("badge_type", "0"); |
| | | languageValue3.put("badge_uuid", "23c10c4b-2852-49c9-9ed1-952f6326fc92"); |
| | | languageValuesList.add(languageValue3); |
| | | |
| | | m.put("product_oa_badge_borrow_detail",languageValuesList); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | /** |
| | | * åç¨-å表å±ç¤º |
| | | */ |
| | | @Test |
| | | public void testBadgeBorrowList(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("~table~", "product_oa_badge_borrow_record"); |
| | | m.put("url/api", "/api/badge-borrow/list/v1"); |
| | | m.put("cpage", 1); |
| | | m.put("pagesize", 20); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | /** |
| | | * åç¨-å é¤ |
| | | */ |
| | | @Test |
| | | public void testBadgeBorrowDelete(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("~table~", "product_oa_badge_borrow_record"); |
| | | m.put("url/api", "/api/badge-borrow/delete/v1"); |
| | | m.put("uuid", "7334fdef-617b-410e-8480-1e5eb1ee0591"); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | /** |
| | | * åç¨-è·ååç¨è¯¦æ
|
| | | */ |
| | | @Test |
| | | public void testBadgeBorrowFind(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("~table~", "product_oa_badge_borrow_record"); |
| | | m.put("url/api", "/api/badge-borrow/find-badge-borrow-info/v1"); |
| | | m.put("uuid", "02f9df91-023d-40de-9baa-5682f8d90219"); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | /** |
| | | * é¨åå½è¿-è·ååç¨å表详æ
|
| | | */ |
| | | @Test |
| | | public void testPartGiveBackFind(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("~table~", "product_oa_badge_borrow_record"); |
| | | m.put("url/api", "/api/badge-borrow/part-give-back-find/v1"); |
| | | m.put("uuid", "02f9df91-023d-40de-9baa-5682f8d90219"); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | /** |
| | | * åç¨-å½è¿ |
| | | */ |
| | | @Test |
| | | public void testBadgeBorrowGiveBack(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("url/api", "/api/badge-borrow/give-back/v1"); |
| | | // m.put("~table~", "product_oa_badge_borrow_detail"); |
| | | // m.put("uuid", "d427516d-8791-48ff-9db4-2c89d97347b1"); |
| | | |
| | | m.put("~table~", "product_oa_badge_borrow_record"); |
| | | m.put("uuid", "02f9df91-023d-40de-9baa-5682f8d90219"); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | /** |
| | | * åç¨-è¯ç« åç¨çæ¿ |
| | | */ |
| | | @Test |
| | | public void testBadgeBorrowBoard(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("~table~", "product_oa_badge_borrow_record"); |
| | | m.put("url/api", "/api/badge-borrow/borrow-board/v1"); |
| | | m.put("pagesize", 20); |
| | | m.put("cpage", 1); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | |
| | | /** |
| | | * åç¨-è¯ç« åè¿è®°å½ |
| | | */ |
| | | @Test |
| | | public void testGetBadgeBorrowAndReturnRecord(){ |
| | | Map<String, Object> m = Maps.newHashMap(); |
| | | m.put("~table~", "product_oa_badge_cost_officer"); |
| | | m.put("url/api", "/api/badge-borrow/get-badge-borrow-and-return-record/v1"); |
| | | m.put("uuid", "23c10c4b-2852-49c9-9ed1-952f6326fc92"); |
| | | m.put("pagesize", 20); |
| | | m.put("cpage", 1); |
| | | |
| | | HttpTest.testPost(m); |
| | | } |
| | | } |