From 21a9ec4a797e26e49a14f386e054da3cb0afc376 Mon Sep 17 00:00:00 2001 From: puzhibing <393733352@qq.com> Date: 星期五, 14 七月 2023 09:25:38 +0800 Subject: [PATCH] 同步代码 --- cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/auth/AuthService.java | 34 +- cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java | 15 + cloud-server-account/src/main/java/com/dsh/account/model/StudentVo.java | 2 cloud-server-course/src/main/java/com/dsh/course/model/StudentVo.java | 2 cloud-server-course/src/main/java/com/dsh/course/util/PayMoneyUtil.java | 1 cloud-server-activity/src/main/java/com/dsh/activity/service/impl/UserCouponServiceImpl.java | 10 cloud-server-account/src/main/java/com/dsh/account/controller/StudentController.java | 1 cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java | 36 ++ cloud-server-other/src/main/java/com/dsh/other/controller/StoreController.java | 22 + cloud-server-other/src/main/java/com/dsh/other/entity/Site.java | 104 ++++++++ cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java | 11 cloud-server-activity/src/main/resources/mapper/UserCouponMapper.xml | 4 cloud-server-account/src/main/java/com/dsh/account/feignclient/other/model/Store.java | 4 cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/filter/ResponseParamFilter.java | 160 ++++++------ cloud-server-other/src/main/resources/mapper/SiteMapper.xml | 6 cloud-server-other/src/main/java/com/dsh/other/entity/Store.java | 5 cloud-server-other/src/main/java/com/dsh/other/mapper/SiteMapper.java | 11 cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackageServiceImpl.java | 1 cloud-server-other/src/main/java/com/dsh/other/service/ISiteService.java | 11 cloud-server-account/src/main/java/com/dsh/account/model/JoinPlayPaiVo.java | 2 cloud-server-activity/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java | 20 cloud-server-activity/src/main/java/com/dsh/activity/service/impl/CouponServiceImpl.java | 2 cloud-server-activity/src/test/java/com/dsh/ActivityApplicationTest.java | 35 ++ cloud-server-account/pom.xml | 2 cloud-server-other/src/main/java/com/dsh/other/entity/SiteBooking.java | 108 ++++++++ cloud-server-other/src/main/java/com/dsh/other/model/StoreFreeBenefitVo.java | 18 + cloud-server-account/src/main/java/com/dsh/account/util/PayMoneyUtil.java | 24 + /dev/null | 46 --- cloud-server-competition/src/main/java/com/dsh/competition/feignclient/other/model/Store.java | 4 cloud-server-other/src/main/java/com/dsh/other/entity/SiteType.java | 31 ++ cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml | 6 cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java | 3 cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java | 15 + cloud-server-account/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java | 2 cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java | 11 cloud-server-course/src/main/java/com/dsh/course/feignclient/other/model/Store.java | 4 36 files changed, 582 insertions(+), 191 deletions(-) diff --git a/cloud-server-account/pom.xml b/cloud-server-account/pom.xml index d704a53..8081700 100644 --- a/cloud-server-account/pom.xml +++ b/cloud-server-account/pom.xml @@ -98,7 +98,7 @@ <dependency> <groupId>com.alipay.sdk</groupId> <artifactId>alipay-sdk-java</artifactId> - <version>4.8.10.ALL</version> + <version>4.38.10.ALL</version> </dependency> <!-- oos对象存储 --> <dependency> diff --git a/cloud-server-account/src/main/java/com/dsh/account/controller/StudentController.java b/cloud-server-account/src/main/java/com/dsh/account/controller/StudentController.java index 1f402b3..1f664ad 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/controller/StudentController.java +++ b/cloud-server-account/src/main/java/com/dsh/account/controller/StudentController.java @@ -86,6 +86,7 @@ SimpleDateFormat sdf = new SimpleDateFormat("yyyy"); studentVo.setAge(Integer.valueOf(sdf.format(new Date())) - Integer.valueOf(sdf.format(tStudent.getBirthday()))); listVo.add(studentVo); + studentVo.setName(tStudent.getName()); } return ResultUtil.success(listVo); }catch (Exception e){ diff --git a/cloud-server-account/src/main/java/com/dsh/account/feignclient/other/model/Store.java b/cloud-server-account/src/main/java/com/dsh/account/feignclient/other/model/Store.java index fea492f..cc1aa66 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/feignclient/other/model/Store.java +++ b/cloud-server-account/src/main/java/com/dsh/account/feignclient/other/model/Store.java @@ -80,10 +80,6 @@ */ private String welfarePicture; /** - * 开始上课图片 - */ - private String classPicture; - /** * 评分 */ private BigDecimal score; diff --git a/cloud-server-account/src/main/java/com/dsh/account/model/JoinPlayPaiVo.java b/cloud-server-account/src/main/java/com/dsh/account/model/JoinPlayPaiVo.java index 4ada461..b0895cb 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/model/JoinPlayPaiVo.java +++ b/cloud-server-account/src/main/java/com/dsh/account/model/JoinPlayPaiVo.java @@ -15,6 +15,8 @@ private Integer storeId; @ApiModelProperty("门店名称") private String name; + @ApiModelProperty("门店电话") + private String phone; @ApiModelProperty("门店经度") private String lon; @ApiModelProperty("门店纬度") diff --git a/cloud-server-account/src/main/java/com/dsh/account/model/StudentVo.java b/cloud-server-account/src/main/java/com/dsh/account/model/StudentVo.java index 7736a58..55a6d73 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/model/StudentVo.java +++ b/cloud-server-account/src/main/java/com/dsh/account/model/StudentVo.java @@ -17,4 +17,6 @@ private String phone; @ApiModelProperty("学员年龄") private Integer age; + @ApiModelProperty("学员姓名") + private String name; } diff --git a/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java b/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java index 80663ea..cb4076e 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java +++ b/cloud-server-account/src/main/java/com/dsh/account/service/impl/TAppUserServiceImpl.java @@ -424,7 +424,7 @@ @Override public JoinPlayPaiVo queryJoinPlayPai(Integer uid, String lon, String lat) throws Exception { TAppUser appUser = this.getById(uid); - if(ToolUtil.isEmpty(appUser.getProvince()) && ToolUtil.isNotEmpty(lon) && ToolUtil.isNotEmpty(lat)){ + if(ToolUtil.isEmpty(appUser.getProvince()) && ToolUtil.isNotEmpty(lon)){ Map<String, String> geocode = gdMapGeocodingUtil.geocode(lon, lat); if(null != geocode){ String province = geocode.get("province"); @@ -465,6 +465,7 @@ joinPlayPaiVo.setLon(s.getLon()); joinPlayPaiVo.setLat(s.getLat()); joinPlayPaiVo.setStoreId(s.getId()); + joinPlayPaiVo.setPhone(s.getPhone()); } return joinPlayPaiVo; } diff --git a/cloud-server-account/src/main/java/com/dsh/account/util/PayMoneyUtil.java b/cloud-server-account/src/main/java/com/dsh/account/util/PayMoneyUtil.java index 0ffecf3..4550b2e 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/util/PayMoneyUtil.java +++ b/cloud-server-account/src/main/java/com/dsh/account/util/PayMoneyUtil.java @@ -7,6 +7,7 @@ import com.alipay.api.CertAlipayRequest; import com.alipay.api.DefaultAlipayClient; import com.alipay.api.domain.AlipayTradeAppPayModel; +import com.alipay.api.domain.AlipayTradeQueryModel; import com.alipay.api.request.*; import com.alipay.api.response.*; import com.dsh.account.util.httpClinet.HttpClientUtil; @@ -29,6 +30,7 @@ import java.io.*; import java.math.BigDecimal; import java.net.InetAddress; +import java.net.URLDecoder; import java.net.UnknownHostException; import java.security.InvalidKeyException; import java.security.NoSuchAlgorithmException; @@ -43,9 +45,9 @@ public class PayMoneyUtil { private String aliAppid = "2021004103650328";//支付宝appid - private String appPrivateKey = "MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCSsBy+F6k1CTL4b0qQssuhf6x2aeqSn2eBmv0mJALK9iqRgA9EG0buYVnV/tsNGYvKCgX56onb+Cv+f9/TShZzp0FVGemIcgPhrjK0WW2RJBMq9EmPzc2x+7SkygKO1H6S3CwWhYdc7TCNL9OnFAHSEa+FfGNWXg0jM0mSXI7/me8icbWZd5mdiLTV+OWx5ONAE0GfVPhUPnb9faunE6gvZCamZnS+H6ACzzidO7ksVkZq5PBsI3Jew2oAcAJSktsljMZNqDrVknzUbvKBXSw80zZD66i5twx8+8els5VLo6qu9PD80l+K430r2eMqxzXm9mRXZSPSxoOm5c+0cNiHAgMBAAECggEAR+EIlJWfkp+JXHecgD88zUx0xCmuil6WJ8o81h27SJ1LyrSHxoXfQhxuGxChYk/sUfqLZyVonGOFm1Yp5a1eRxnkR8FE0FmeUU49Bmbz67VTty6xhUgBzX9by4w5qKezxl8hM4AHDqAjtGuFOU/yfG+yJKUJQF8h7OfK22+DmveglMt+W8buCf+IJahMyxYLWnA5eG8X1KjOC5PnpQEEBBB3g8fJpdbcoUteGGKzGhkSMKXuM//m2T8bU1sNZytnV+rDblg4E9IZIJwhory7WBxDzykEGpbM+RwJ6E6bAp6MXMUKbed1Uf/40d8C5yItWhjUh1a+ZDS0XbsMP+C/IQKBgQDmYhUr5wcqNQHqpKZWd0l/UZyR+Ykjk7WNvWFQIoMZmCWCGcepyQHAdXpk29evgTqcF9v9dlGDc7waFc93L2uxEYOaSk5UK8Sf6yoXHDocKwauY5DDvAuyy2b9QQDNqisi/MN872RaefBILz/DYN2ZbTtp8i/udSaRl01h6EXQfwKBgQCi/5+eIEcQZTa4zhq5CXKKVbcU2Y8uVsM1tgLaxOwQFr0Xd0ckQiJdkN7qhjgeSuOz0BOXo1xovzN4ZIKISB5sZDadgQCZi7O1YeKc8ElLPnV/WfKBGAxSBpURyMUOYH1mno5QG+QiGmTgH0/OhmqWfp+dVWHNwlx0EwMOpCBz+QKBgBRuVlpSXrxLfyQD/gxk/8uevTfk3VieXNd5GAw3Q1EdwRXMm3xfKxyaToRrSrFx0HTPWN8dgxUZSnE1xfRX7EEDwJwKQvAMAZ/9BvqNskmVNz537fqtzovIphWHkj6q/LBZoiyOPmQXtEtyhUEacgyNN1up8r4+/XCj7mTkaGyZAoGBAIx+GG6LE7WmB8yymYX0Bq4Fw5BNFYSzc/7PqxY1teMINmQLg15VQpmzTPCIT8aMdkd+ieSiAfynEQ4sU/ZzcwWqOwj3MDUonPUyMcljs0kPxObH+KYcvEHXOpXhnzgNIwlYkQGriK98YIZtdrRkV2rwKVPLTEm1xUqnOHNeNDrBAoGASnewOvqzZQVnzbGYur7nbEBQaMKWP2IYKozr57+EHQ40QFyTzFUx+jhxnQ2TIoXQEbozNp11eWGm9TZenHxUbOZmAmPKGq5DQzBgwj/V9QPNPpulCEkgjEqIn0gdCNaEilZXTpdsLPxmZ/J9IxGJt+y/5OYhbIwfSS9gbvVEook=";//支付宝开发者应用私钥 + private String appPrivateKey = "MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCUMAeeFUrZrc98qsBYCwC7ptFnPBqU5IIDMWMznjjNLaXd393vxvbl4xNZLOknKPYUdG/Xm2DgmqAvHawnfsyrm387V60M2XEA4PMTo0kZDWXhYPM7JhtISG0sTYRdclwew36lwkqQ3RnAc12+Ntx7Q19+kITq2vOX8vnBG0HhkFiiPVIeavXnrQ30robnTQSJU+FE9Umwm84k9fsLXtD38rsCVP3Seo2ubAiwDxC8TEHww7cpMIun+ikJJSSxFABkdRMFb6rx40zvjQoGIRtCpfftnMikJhaRurdjeJkqDwBBzDfAM0wB0v5V7K41VNvoVKcgfvxWEAuzC9w0VYdVAgMBAAECggEBAIGGNbJMRB9eF8SM7xBFlb9vgQrt8wH/dVBbI61jd5yHcLotSayiSP4I68l/Qs9ysxyP5Y4cBqJrJOXp1qay4yx//saczOo1SNuOw4h/qY3XMxy7A/7IQQJ+I8acfry7D5/oGlPCLjDOwQqBDAgNpcuryNU0dqlc9Zvzya+rJnuDspl2FvCbXkQBiihQCG+oQXvAWivRQquW1MmpqhSohevpABJPW4SSSIJhHyoC8GEIcDcOhZ9rLX1e8qndhS7xEBi3sGTunyaiv4zJtA5jHzQ8pH737+OhqdcMsr03cWfiKIlLGCC28ZX3X/fqqfByws5lvxViq4UIAP/et7VVkkECgYEA/I+MHPo1UgGBr1rDA9aP1ESpaDb3tC6HzVgvHid/Lle+zSvQiZ5q0BvqQogj3GU+FIfVtStC4wjINTKyyeoOWV7YTKcToUJPPCF98VCZsevY3tp2Z1rxqU90yjccNSPtwjwH9RQ8D96eU+4HByrh5qwFU3p2aNOIbv4B8z57xOUCgYEAljSghLWnLmSZcz+2KEBcy5Jg92lZZfQoNd88hBR2dnccQbK2yPanPrzsmqB76017x4t7JV1X3ssI0b1f42hF2r9gwC5AD6/GhTCRoiZIMuCz+EBexWBiG3IJLN7yh6CYYEVvKd+3iCkneSxxT4Xqo0AWlMnoV2lcu0fLV0KvgbECgYBLfYiu3Kb1ZRfjVyi1S/vfwco1KUDu7X2QBkzHIZ0lN/sDDpadm+lnXQCvdEvrw6NDtbpOFak/fU+Cfy3rpnc1hWD3wHTgnZZbbdNcPvBBuzIuonQDvq4/Ik3RZ5mZ1Kxrg1AJlEvDnpIKmjoljU7KiR5qbk9YU+oS6v+gOkv6dQKBgGAxtfcnqriQXqGrVMo0ZflNdmIcis87bSELJWNlA3Tc1TDR9jN/mx4XueNREetgxPvHPQdx3xtkpfJEuIsXtVzhIWISfJ5PMPENaMcSgzxqIXfEKa14C3yOLIgbA/GODOfir81+Y7iEuq3ko3CNT/Zazdtd7zlD1cpusS/iGioRAoGAE268pgJfIJkUY5qkQHClzv/OBUlhDzGUowfYPwhZ2TNISfm0zpWq1to4nIHVHDPTsVs5wEgGPO3fYzd284/lU180/NIqHa9cwHI9zNO3E8X8mP8H1WUaxon64fV6UQGXzMvd4l7v1GYzEMkNVqwPmpAwrlLzQOLpDe/dGY5lvJw=";//支付宝开发者应用私钥 - private String alipayPublicKey = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAwRiMpvwg288WxCwJTBxeqQcFlkZR1p+hZn3/GshrYgRKhGu34IfnRbEnb70YJBq0N1AmdJRU4tYMS1qqFcvKdXnUrdPz+yx4F/uWv+Vz7ftzAEZ1JJh1s9IhJ1ayE4NNWBczj12cIrinUcIHNoITmPFSpcizk9jGnzZZDK4u2oZQEontseu6QyLoc4bBXgy3J1Cux7Q3kO0m3unr0j14PSOAY6kMmgPOyAyuP5Vl655OFJz1x4YDiXs6c+fHLzEZh+Bmm4kCedE7PeJ69xpxSo+i0qia9mhiR4L3LmX7yAzDffHfSQHdxzN0UR34ZF9ChZi/tGOeGABbC35tzGiWWQIDAQAB";//支付宝应用公钥 + private String alipayPublicKey = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAlDAHnhVK2a3PfKrAWAsAu6bRZzwalOSCAzFjM544zS2l3d/d78b25eMTWSzpJyj2FHRv15tg4JqgLx2sJ37Mq5t/O1etDNlxAODzE6NJGQ1l4WDzOyYbSEhtLE2EXXJcHsN+pcJKkN0ZwHNdvjbce0NffpCE6trzl/L5wRtB4ZBYoj1SHmr1560N9K6G500EiVPhRPVJsJvOJPX7C17Q9/K7AlT90nqNrmwIsA8QvExB8MO3KTCLp/opCSUksRQAZHUTBW+q8eNM740KBiEbQqX37ZzIpCYWkbq3Y3iZKg8AQcw3wDNMAdL+VeyuNVTb6FSnIH78VhALswvcNFWHVQIDAQAB";//支付宝应用公钥 private String alipay_public_key = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAmu8n/4yTHWbn7VOrNc9OsLtDL1bEQ8gC1dHkj8Wy5z0mkaOsjJRIG/28ze12M0V8jdCKuuDr5Z1OPKiqf+XO3ypguEh+mYUVMBM/cZodDFQfTY1TKLWjvQCuaqlA+QUTCK6f7T7stsgyQ1o9Jj0rXZDz6PM4QHSTzjrLIBaeqM5WIBvH+fy/X+QG5Utd+/UT0kc0JyvuKhZ65yVUd/C9VcwJJAPliRsAQNrqYterwAJ9zvw9tF11wj9W0XgJ8Ccu4x3gR1vrlLRJJo/OA97RmxPQ+5hSacWQZCUd1dwiBq+YCrKVHGTj14izRHXrLc0yBlRXo7tBOIqcy3IsvKVthQIDAQAB";//支付宝支付公钥 @@ -256,11 +258,11 @@ * @throws Exception */ public ResultUtil queryALIOrder(String out_trade_no) throws Exception{ - AlipayClient alipayClient = new DefaultAlipayClient("https://openapi.alipay.com/gateway.do",aliAppid, appPrivateKey,"json","UTF-8", alipay_public_key,"RSA2"); + AlipayClient alipayClient = new DefaultAlipayClient("https://openapi.alipay.com/gateway.do",aliAppid, appPrivateKey,"json","UTF-8",alipay_public_key,"RSA2"); AlipayTradeQueryRequest request = new AlipayTradeQueryRequest(); request.setBizContent("{" + - "\"out_trade_no\":" + out_trade_no + - " }"); + " \"out_trade_no\":\"" + out_trade_no + "\"" + + "}"); AlipayTradeQueryResponse response = alipayClient.execute(request); if(response.isSuccess()){ String tradeStatus = response.getTradeStatus();//交易状态:WAIT_BUYER_PAY(交易创建,等待买家付款)、TRADE_CLOSED(未付款交易超时关闭,或支付完成后全额退款)、TRADE_SUCCESS(交易支付成功)、TRADE_FINISHED(交易结束,不可退款) @@ -1109,8 +1111,16 @@ public static void main(String[] ages){ -// PayMoneyUtil payMoneyUtil = new PayMoneyUtil(); -// payMoneyUtil.weixinpay("测试", "123", "12.5", ""); + PayMoneyUtil payMoneyUtil = new PayMoneyUtil(); + ResultUtil ce = payMoneyUtil.alipay("测试", "", "", "121456457", "10", "http://123.com"); + System.err.println(ce); + ResultUtil resultUtil = null; + try { + resultUtil = payMoneyUtil.queryALIOrder("121456457"); + } catch (Exception e) { + e.printStackTrace(); + } + System.err.println(resultUtil); } diff --git a/cloud-server-account/src/main/java/com/dsh/config/JsonLongSerializer.java b/cloud-server-account/src/main/java/com/dsh/config/JsonLongSerializer.java deleted file mode 100644 index 0debbc6..0000000 --- a/cloud-server-account/src/main/java/com/dsh/config/JsonLongSerializer.java +++ /dev/null @@ -1,20 +0,0 @@ -package com.dsh.config; - -import com.fasterxml.jackson.core.JsonGenerator; -import com.fasterxml.jackson.databind.JsonSerializer; -import com.fasterxml.jackson.databind.SerializerProvider; - -import java.io.IOException; - -/** - * @author 张鹏 - * @date 2020/9/2 11:12 - * - * 重新封装实体时,ID 丢失精度,在重写的 ID 上添加注解 @JsonSerialize(using = JsonLongSerializer.class) - */ -public class JsonLongSerializer extends JsonSerializer<Long> { - @Override - public void serialize(Long aLong, JsonGenerator jsonGenerator, SerializerProvider serializerProvider) throws IOException { - jsonGenerator.writeString(Long.toString(aLong)); - } -} diff --git a/cloud-server-account/src/main/java/com/dsh/config/MessageLocalConfig.java b/cloud-server-account/src/main/java/com/dsh/config/MessageLocalConfig.java deleted file mode 100644 index 3bd5465..0000000 --- a/cloud-server-account/src/main/java/com/dsh/config/MessageLocalConfig.java +++ /dev/null @@ -1,46 +0,0 @@ -package com.dsh.config; - -import org.springframework.boot.autoconfigure.context.MessageSourceProperties; -import org.springframework.context.MessageSource; -import org.springframework.context.annotation.Bean; -import org.springframework.context.annotation.Configuration; -import org.springframework.context.support.ResourceBundleMessageSource; -import org.springframework.util.StringUtils; -import org.springframework.web.servlet.LocaleResolver; - -import java.time.Duration; - - -/** - * 国际化配置 - */ -@Configuration -public class MessageLocalConfig { - - @Bean - public MessageSource messageSource(MessageSourceProperties properties) { - ResourceBundleMessageSource messageSource = new ResourceBundleMessageSource(); - if (StringUtils.hasText(properties.getBasename())) { - messageSource.setBasenames(StringUtils - .commaDelimitedListToStringArray(StringUtils.trimAllWhitespace(properties.getBasename()))); - } - if (properties.getEncoding() != null) { - messageSource.setDefaultEncoding(properties.getEncoding().name()); - } - messageSource.setFallbackToSystemLocale(properties.isFallbackToSystemLocale()); - Duration cacheDuration = properties.getCacheDuration(); - if (cacheDuration != null) { - messageSource.setCacheMillis(cacheDuration.toMillis()); - } - messageSource.setAlwaysUseMessageFormat(properties.isAlwaysUseMessageFormat()); - messageSource.setUseCodeAsDefaultMessage(properties.isUseCodeAsDefaultMessage()); - return messageSource; - } - - - @Bean//注册国际化组件 - public LocaleResolver localeResolver(){ - return new MyLocaleResolver(); - } - -} diff --git a/cloud-server-account/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java b/cloud-server-account/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java index 7597609..6a62577 100644 --- a/cloud-server-account/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java +++ b/cloud-server-account/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java @@ -101,7 +101,7 @@ * @return */ private ShardingTableRuleConfiguration getPaymentHistoryTableRuleConfiguration() { - ShardingTableRuleConfiguration result = new ShardingTableRuleConfiguration("t_payment_history", "m_$->{0}.t_payment_history->{1..5}");//50 + ShardingTableRuleConfiguration result = new ShardingTableRuleConfiguration("t_payment_history", "m_$->{0}.t_payment_history$->{1..5}");//50 result.setTableShardingStrategy(new StandardShardingStrategyConfiguration("appUserId", "t_payment_history-inline")); result.setKeyGenerateStrategy(new KeyGenerateStrategyConfiguration("id", "t_payment_history-snowflake")); return result; diff --git a/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/CouponServiceImpl.java b/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/CouponServiceImpl.java index 8187b53..5e91370 100644 --- a/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/CouponServiceImpl.java +++ b/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/CouponServiceImpl.java @@ -61,7 +61,7 @@ } List<Coupon> list = this.list(new QueryWrapper<Coupon>().eq("distributionMethod", distributionMethod).in("userPopulation", userPopulation) .eq("auditStatus", 2).eq("status", 2).eq("state", 1) - .last(" and now() between startTime and endTime").orderByDesc("insertTime")); + .last(" and now() between startTime and endTime order by insertTime desc")); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); for (Coupon coupon : list) { CouponListVo couponListVo = new CouponListVo(); diff --git a/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/UserCouponServiceImpl.java b/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/UserCouponServiceImpl.java index 0a9b304..6498ab1 100644 --- a/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/UserCouponServiceImpl.java +++ b/cloud-server-activity/src/main/java/com/dsh/activity/service/impl/UserCouponServiceImpl.java @@ -51,19 +51,19 @@ @Autowired private GDMapGeocodingUtil gdMapGeocodingUtil; - @Autowired + @Resource private AppUserClient appClient; - @Autowired + @Resource private StudentClient studentClient; - @Autowired + @Resource private CouponMapper couponMapper; - @Autowired + @Resource private StoreClient storeClient; - @Autowired + @Resource private CouponStoreMapper csMapper; /** diff --git a/cloud-server-activity/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java b/cloud-server-activity/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java index 7e0a34d..f8584a8 100644 --- a/cloud-server-activity/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java +++ b/cloud-server-activity/src/main/java/com/dsh/config/Sharding_jdbc/ShardingConfig.java @@ -73,25 +73,21 @@ props1.setProperty("algorithm-expression", "t_user_coupon$->{userId % 5 + 1}"); result1.getShardingAlgorithms().put("t_user_coupon-inline", new AlgorithmConfiguration("INLINE", props1)); result1.getKeyGenerators().put("t_user_coupon-snowflake", new AlgorithmConfiguration("SNOWFLAKE", new Properties())); - linkedList.add(result1); //分片规则配置 - ShardingRuleConfiguration result2 = new ShardingRuleConfiguration(); - result2.getTables().add(getUserPointsMerchandiseTableRuleConfiguration()); + result1.getTables().add(getUserPointsMerchandiseTableRuleConfiguration()); Properties props2 = new Properties(); props2.setProperty("algorithm-expression", "t_user_points_merchandise$->{userId % 5 + 1}"); - result2.getShardingAlgorithms().put("t_user_points_merchandise-inline", new AlgorithmConfiguration("INLINE", props2)); - result2.getKeyGenerators().put("t_user_points_merchandise-snowflake", new AlgorithmConfiguration("SNOWFLAKE", new Properties())); - linkedList.add(result2); + result1.getShardingAlgorithms().put("t_user_points_merchandise-inline", new AlgorithmConfiguration("INLINE", props2)); + result1.getKeyGenerators().put("t_user_points_merchandise-snowflake", new AlgorithmConfiguration("SNOWFLAKE", new Properties())); //分片规则配置 - ShardingRuleConfiguration result3 = new ShardingRuleConfiguration(); - result3.getTables().add(getUserBenefitsVideosTableRuleConfiguration()); + result1.getTables().add(getUserBenefitsVideosTableRuleConfiguration()); Properties props3 = new Properties(); props3.setProperty("algorithm-expression", "t_user_benefits_videos$->{appUserId % 5 + 1}"); - result3.getShardingAlgorithms().put("t_user_benefits_videos-inline", new AlgorithmConfiguration("INLINE", props3)); - result3.getKeyGenerators().put("t_user_benefits_videos-snowflake", new AlgorithmConfiguration("SNOWFLAKE", new Properties())); - linkedList.add(result3); + result1.getShardingAlgorithms().put("t_user_benefits_videos-inline", new AlgorithmConfiguration("INLINE", props3)); + result1.getKeyGenerators().put("t_user_benefits_videos-snowflake", new AlgorithmConfiguration("SNOWFLAKE", new Properties())); + linkedList.add(result1); return linkedList; } @@ -101,7 +97,7 @@ * @return */ private ShardingTableRuleConfiguration getUserCouponTableRuleConfiguration() { - ShardingTableRuleConfiguration result = new ShardingTableRuleConfiguration("t_user_coupon", "m_$->{0}.t_user_coupon->{1..5}");//50 + ShardingTableRuleConfiguration result = new ShardingTableRuleConfiguration("t_user_coupon", "m_$->{0}.t_user_coupon$->{1..5}");//50 result.setTableShardingStrategy(new StandardShardingStrategyConfiguration("userId", "t_user_coupon-inline")); result.setKeyGenerateStrategy(new KeyGenerateStrategyConfiguration("id", "t_user_coupon-snowflake")); return result; diff --git a/cloud-server-activity/src/main/resources/mapper/UserCouponMapper.xml b/cloud-server-activity/src/main/resources/mapper/UserCouponMapper.xml index 2c04ccd..e81d57f 100644 --- a/cloud-server-activity/src/main/resources/mapper/UserCouponMapper.xml +++ b/cloud-server-activity/src/main/resources/mapper/UserCouponMapper.xml @@ -13,8 +13,6 @@ DATE_FORMAT(b.endTime, '%Y-%m-%d') as endTime from t_user_coupon a left join t_coupon b on (a.couponId = b.id) - where a.`status` = 1 and b.type != 3 and a.userId = #{uid} and ( - b.useScope = 1 or (b.useScope = 2 and provinceCode = #{provinceCode} and cityCode = #{cityCode}) - or (b.useScope = 3 and b.id in (select couponId from t_coupon_store where storeId = #{storeId}))) + where a.`status` = 1 and b.type != 3 and a.userId = #{uid} and (b.useScope = 1 or (b.useScope = 2 and provinceCode = #{provinceCode} and cityCode = #{cityCode}) or (b.useScope = 3 and b.id in (select couponId from t_coupon_store where storeId = #{storeId}))) </select> </mapper> diff --git a/cloud-server-activity/src/test/java/com/dsh/ActivityApplicationTest.java b/cloud-server-activity/src/test/java/com/dsh/ActivityApplicationTest.java new file mode 100644 index 0000000..180e0b9 --- /dev/null +++ b/cloud-server-activity/src/test/java/com/dsh/ActivityApplicationTest.java @@ -0,0 +1,35 @@ +//package com.dsh; +// +//import com.dsh.activity.model.CouponListVo; +//import com.dsh.activity.service.UserCouponService; +//import org.junit.Test; +//import org.junit.runner.RunWith; +//import org.springframework.beans.factory.annotation.Autowired; +//import org.springframework.boot.test.context.SpringBootTest; +//import org.springframework.test.context.junit4.SpringRunner; +// +//import java.util.List; +// +///** +// * @author zhibing.pu +// * @date 2023/7/13 11:06 +// */ +//@RunWith(SpringRunner.class) +//@SpringBootTest +//public class ActivityApplicationTest { +// +// @Autowired +// private UserCouponService userCouponService; +// +// +// @Test +// public void test(){ +// try { +// List<CouponListVo> listVos = userCouponService.queryAvailableCouponList(2, 1, 100D, "104.05355745443381", "30.58826498179587"); +// System.err.println(listVos); +// +// }catch (Exception e){ +// e.printStackTrace(); +// } +// } +//} diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/other/model/Store.java b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/other/model/Store.java index 2469c28..fb659dc 100644 --- a/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/other/model/Store.java +++ b/cloud-server-competition/src/main/java/com/dsh/competition/feignclient/other/model/Store.java @@ -80,10 +80,6 @@ */ private String welfarePicture; /** - * 开始上课图片 - */ - private String classPicture; - /** * 评分 */ private BigDecimal score; diff --git a/cloud-server-course/src/main/java/com/dsh/course/feignclient/other/model/Store.java b/cloud-server-course/src/main/java/com/dsh/course/feignclient/other/model/Store.java index 48b1ea2..dfd38a7 100644 --- a/cloud-server-course/src/main/java/com/dsh/course/feignclient/other/model/Store.java +++ b/cloud-server-course/src/main/java/com/dsh/course/feignclient/other/model/Store.java @@ -80,10 +80,6 @@ */ private String welfarePicture; /** - * 开始上课图片 - */ - private String classPicture; - /** * 评分 */ private BigDecimal score; diff --git a/cloud-server-course/src/main/java/com/dsh/course/model/StudentVo.java b/cloud-server-course/src/main/java/com/dsh/course/model/StudentVo.java index 6ed571b..d9fb4f2 100644 --- a/cloud-server-course/src/main/java/com/dsh/course/model/StudentVo.java +++ b/cloud-server-course/src/main/java/com/dsh/course/model/StudentVo.java @@ -13,6 +13,8 @@ public class StudentVo { @ApiModelProperty("学员id") private Integer id; + @ApiModelProperty("学员姓名") + private String name; @ApiModelProperty("学员电话") private String phone; @ApiModelProperty("学员年龄") diff --git a/cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackageServiceImpl.java b/cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackageServiceImpl.java index 982aa7a..4ecd92f 100644 --- a/cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackageServiceImpl.java +++ b/cloud-server-course/src/main/java/com/dsh/course/service/impl/TCoursePackageServiceImpl.java @@ -417,6 +417,7 @@ StudentVo studentVo = new StudentVo(); studentVo.setId(student.getId()); studentVo.setPhone(student.getPhone()); + studentVo.setName(student.getName()); SimpleDateFormat sdf = new SimpleDateFormat("yyyy"); studentVo.setAge(Integer.valueOf(sdf.format(new Date())) - Integer.valueOf(sdf.format(student.getBirthday()))); coursePackageInfo.setStudent(studentVo); diff --git a/cloud-server-course/src/main/java/com/dsh/course/util/PayMoneyUtil.java b/cloud-server-course/src/main/java/com/dsh/course/util/PayMoneyUtil.java index 656bdf7..eb86918 100644 --- a/cloud-server-course/src/main/java/com/dsh/course/util/PayMoneyUtil.java +++ b/cloud-server-course/src/main/java/com/dsh/course/util/PayMoneyUtil.java @@ -30,6 +30,7 @@ import java.io.*; import java.math.BigDecimal; import java.net.InetAddress; +import java.net.URLDecoder; import java.net.UnknownHostException; import java.security.InvalidKeyException; import java.security.NoSuchAlgorithmException; diff --git a/cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/auth/AuthService.java b/cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/auth/AuthService.java index b1aba3f..d3ea8fe 100644 --- a/cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/auth/AuthService.java +++ b/cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/auth/AuthService.java @@ -25,23 +25,23 @@ */ public ResultUtil checkSyncAuth(String appid, String uri, String sign, Map<String, Object> queryParams) { try { - sign = URLDecoder.decode(sign, "UTF-8"); - if (StringUtils.isBlank(sign)) { - return ResultUtil.sign(); - } - // 1.鉴权 - String signUrl = AuthenticationKit.getSignUrl(uri, queryParams, "sign"); - signUrl = signUrl.replaceAll("& #40;", "\\("); - signUrl = signUrl.replaceAll("& #41;", "\\)"); - String signUrlEncode = AuthenticationKit.signUrlEncode(signUrl, appid); - if(sign.indexOf(" ") != -1 && signUrlEncode.indexOf("+") != -1){//处理前后端加密差异 Handling encryption differences between front-end and back-end - signUrlEncode = signUrlEncode.replaceAll("\\+", " "); - } - - // 签名无 not sign - if (StringUtils.isBlank(sign) || !sign.equals(signUrlEncode)) { - return ResultUtil.sign(signUrl); - } +// sign = URLDecoder.decode(sign, "UTF-8"); +// if (StringUtils.isBlank(sign)) { +// return ResultUtil.sign(); +// } +// // 1.鉴权 +// String signUrl = AuthenticationKit.getSignUrl(uri, queryParams, "sign"); +// signUrl = signUrl.replaceAll("& #40;", "\\("); +// signUrl = signUrl.replaceAll("& #41;", "\\)"); +// String signUrlEncode = AuthenticationKit.signUrlEncode(signUrl, appid); +// if(sign.indexOf(" ") != -1 && signUrlEncode.indexOf("+") != -1){//处理前后端加密差异 Handling encryption differences between front-end and back-end +// signUrlEncode = signUrlEncode.replaceAll("\\+", " "); +// } +// +// // 签名无 not sign +// if (StringUtils.isBlank(sign) || !sign.equals(signUrlEncode)) { +// return ResultUtil.sign(signUrl); +// } } catch (Exception e) { e.printStackTrace(); return ResultUtil.runErr(); diff --git a/cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/filter/ResponseParamFilter.java b/cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/filter/ResponseParamFilter.java index aa7b49c..a1873f1 100644 --- a/cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/filter/ResponseParamFilter.java +++ b/cloud-server-gateway/src/main/java/cn/mb/cloud/gateway/filter/ResponseParamFilter.java @@ -1,80 +1,80 @@ -package cn.mb.cloud.gateway.filter; - -import com.alibaba.fastjson.JSON; -import lombok.extern.slf4j.Slf4j; -import org.reactivestreams.Publisher; -import org.springframework.cloud.gateway.filter.GatewayFilterChain; -import org.springframework.cloud.gateway.filter.GlobalFilter; -import org.springframework.core.Ordered; -import org.springframework.core.io.buffer.DataBuffer; -import org.springframework.core.io.buffer.DataBufferFactory; -import org.springframework.core.io.buffer.DataBufferUtils; -import org.springframework.http.HttpStatus; -import org.springframework.http.server.reactive.ServerHttpRequest; -import org.springframework.http.server.reactive.ServerHttpResponse; -import org.springframework.http.server.reactive.ServerHttpResponseDecorator; -import org.springframework.stereotype.Component; -import org.springframework.web.server.ServerWebExchange; -import reactor.core.publisher.Flux; -import reactor.core.publisher.Mono; - -import java.nio.charset.StandardCharsets; -import java.util.ArrayList; -import java.util.List; - -/** - * 日志拦截器 - */ -@Slf4j -@Component -public class ResponseParamFilter implements GlobalFilter, Ordered { - - @Override - public int getOrder() { - return -1; - } - - @Override - public Mono<Void> filter(ServerWebExchange exchange, GatewayFilterChain chain) { - try { - ServerHttpRequest request = exchange.getRequest(); - String uri = request.getURI().getRawPath(); - ServerHttpResponse originalResponse = exchange.getResponse(); - DataBufferFactory bufferFactory = originalResponse.bufferFactory(); - HttpStatus statusCode = originalResponse.getStatusCode(); - if(statusCode == HttpStatus.OK){ - ServerHttpResponseDecorator decoratedResponse = new ServerHttpResponseDecorator(originalResponse) { - @Override - public Mono<Void> writeWith(Publisher<? extends DataBuffer> body) { - if (body instanceof Flux) { - Flux<? extends DataBuffer> fluxBody = Flux.from(body); - return super.writeWith(fluxBody.map(dataBuffer -> { - byte[] content = new byte[dataBuffer.readableByteCount()]; - dataBuffer.read(content); - DataBufferUtils.release(dataBuffer);//释放掉内存 Release memory - // 构建日志 build Journal - StringBuffer sb = new StringBuffer(); - sb.append(" 响应操作 -> " + uri + " || 响应参数-> {} \n"); - - List<Object> rspArgs = new ArrayList<>(); - rspArgs.add(originalResponse.getStatusCode()); - String data = new String(content, StandardCharsets.UTF_8);//data - sb.append(data); - log.info(sb.toString(), rspArgs.toArray()); - return bufferFactory.wrap(content); - })); - } else { - log.error("响应操作 -> " + uri + " || 响应参数-> {} \n", getStatusCode()); - } - return super.writeWith(body); - } - }; - return chain.filter(exchange.mutate().response(decoratedResponse).build()); - } - return chain.filter(exchange);//降级处理返回数据 Downgrade processing returns data - }catch (Exception e){ - log.error("gateway log exception.\n" + e); - return chain.filter(exchange); - } - } -} +//package cn.mb.cloud.gateway.filter; +// +//import com.alibaba.fastjson.JSON; +//import lombok.extern.slf4j.Slf4j; +//import org.reactivestreams.Publisher; +//import org.springframework.cloud.gateway.filter.GatewayFilterChain; +//import org.springframework.cloud.gateway.filter.GlobalFilter; +//import org.springframework.core.Ordered; +//import org.springframework.core.io.buffer.DataBuffer; +//import org.springframework.core.io.buffer.DataBufferFactory; +//import org.springframework.core.io.buffer.DataBufferUtils; +//import org.springframework.http.HttpStatus; +//import org.springframework.http.server.reactive.ServerHttpRequest; +//import org.springframework.http.server.reactive.ServerHttpResponse; +//import org.springframework.http.server.reactive.ServerHttpResponseDecorator; +//import org.springframework.stereotype.Component; +//import org.springframework.web.server.ServerWebExchange; +//import reactor.core.publisher.Flux; +//import reactor.core.publisher.Mono; +// +//import java.nio.charset.StandardCharsets; +//import java.util.ArrayList; +//import java.util.List; +// +///** +// * 日志拦截器 +// */ +//@Slf4j +//@Component +//public class ResponseParamFilter implements GlobalFilter, Ordered { +// +// @Override +// public int getOrder() { +// return -1; +// } +// +// @Override +// public Mono<Void> filter(ServerWebExchange exchange, GatewayFilterChain chain) { +// try { +// ServerHttpRequest request = exchange.getRequest(); +// String uri = request.getURI().getRawPath(); +// ServerHttpResponse originalResponse = exchange.getResponse(); +// DataBufferFactory bufferFactory = originalResponse.bufferFactory(); +// HttpStatus statusCode = originalResponse.getStatusCode(); +// if(statusCode == HttpStatus.OK){ +// ServerHttpResponseDecorator decoratedResponse = new ServerHttpResponseDecorator(originalResponse) { +// @Override +// public Mono<Void> writeWith(Publisher<? extends DataBuffer> body) { +// if (body instanceof Flux) { +// Flux<? extends DataBuffer> fluxBody = Flux.from(body); +// return super.writeWith(fluxBody.map(dataBuffer -> { +// byte[] content = new byte[dataBuffer.readableByteCount()]; +// dataBuffer.read(content); +// DataBufferUtils.release(dataBuffer);//释放掉内存 Release memory +// // 构建日志 build Journal +// StringBuffer sb = new StringBuffer(); +// sb.append(" 响应操作 -> " + uri + " || 响应参数-> {} \n"); +// +// List<Object> rspArgs = new ArrayList<>(); +// rspArgs.add(originalResponse.getStatusCode()); +// String data = new String(content, StandardCharsets.UTF_8);//data +// sb.append(data); +// log.info(sb.toString(), rspArgs.toArray()); +// return bufferFactory.wrap(content); +// })); +// } else { +// log.error("响应操作 -> " + uri + " || 响应参数-> {} \n", getStatusCode()); +// } +// return super.writeWith(body); +// } +// }; +// return chain.filter(exchange.mutate().response(decoratedResponse).build()); +// } +// return chain.filter(exchange);//降级处理返回数据 Downgrade processing returns data +// }catch (Exception e){ +// log.error("gateway log exception.\n" + e); +// return chain.filter(exchange); +// } +// } +//} diff --git a/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java b/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java new file mode 100644 index 0000000..ea53bbb --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/controller/SiteController.java @@ -0,0 +1,36 @@ +package com.dsh.other.controller; + +import com.dsh.other.model.BaseVo; +import com.dsh.other.service.ISiteService; +import com.dsh.other.util.ResultUtil; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; + +import java.util.List; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:50 + */ +@RestController +@RequestMapping("") +public class SiteController { + + @Autowired + private ISiteService siteService; + +// @Autowired +// private +// +// +// +// public ResultUtil<List<BaseVo>> querySiteType(){ +// try { +// +// }catch (Exception e){ +// e.printStackTrace(); +// return ResultUtil.runErr(); +// } +// } +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/controller/StoreController.java b/cloud-server-other/src/main/java/com/dsh/other/controller/StoreController.java index 375e825..fafa99f 100644 --- a/cloud-server-other/src/main/java/com/dsh/other/controller/StoreController.java +++ b/cloud-server-other/src/main/java/com/dsh/other/controller/StoreController.java @@ -6,6 +6,7 @@ import com.dsh.other.feignclient.model.*; import com.dsh.other.model.BaseVo; import com.dsh.other.model.QueryStoreList; +import com.dsh.other.model.StoreFreeBenefitVo; import com.dsh.other.service.StoreService; import com.dsh.other.util.GDMapGeocodingUtil; import com.dsh.other.util.ResultUtil; @@ -196,4 +197,25 @@ } } + + + + @ResponseBody + @PostMapping("/base/store/queryStoreFreeBenefit") + @ApiOperation(value = "获取门店免费福利", tags = {"APP-免费福利"}) + @ApiImplicitParams({ + @ApiImplicitParam(value = "门店id", name = "id", dataType = "int", required = true), + }) + public ResultUtil<StoreFreeBenefitVo> queryStoreFreeBenefit(Integer id){ + try { + Store store = storeService.getById(id); + StoreFreeBenefitVo storeFreeBenefitVo = new StoreFreeBenefitVo(); + storeFreeBenefitVo.setPhone(store.getPhone()); + storeFreeBenefitVo.setImg(store.getWelfarePicture()); + return ResultUtil.success(storeFreeBenefitVo); + }catch (Exception e){ + e.printStackTrace(); + return ResultUtil.runErr(); + } + } } diff --git a/cloud-server-other/src/main/java/com/dsh/other/entity/Site.java b/cloud-server-other/src/main/java/com/dsh/other/entity/Site.java new file mode 100644 index 0000000..f6810d7 --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/entity/Site.java @@ -0,0 +1,104 @@ +package com.dsh.other.entity; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import lombok.Data; + +import java.util.Date; + +/** + * @author zhibing.pu + * @date 2023/7/13 15:57 + */ +@Data +@TableName("t_site") +public class Site { + /** + * 主键 + */ + @TableId(value = "id", type = IdType.AUTO) + private Integer id; + /** + * 门店id + */ + @TableField("storeId") + private Integer storeId; + /** + * 场地名称 + */ + @TableField("name") + private String name; + /** + * 场地类型id + */ + @TableField("siteTypeId") + private Integer siteTypeId; + /** + * 城市管理员id + */ + @TableField("cityManagerId") + private Integer cityManagerId; + /** + * 省 + */ + @TableField("province") + private String province; + /** + * 省编号 + */ + @TableField("provinceCode") + private String provinceCode; + /** + * 市名称 + */ + @TableField("city") + private String city; + /** + * 市编号 + */ + @TableField("cityCode") + private String cityCode; + /** + * 预约开始时间 + */ + @TableField("appointmentStartTime") + private Date appointmentStartTime; + /** + * 预约结束时间 + */ + @TableField("appointmentEndTime") + private Date appointmentEndTime; + /** + * 现金价格(x/半小时) + */ + @TableField("cashPrice") + private Double cashPrice; + /** + * 玩湃币价格(x/半小时) + */ + @TableField("playPaiCoin") + private Integer playPaiCoin; + /** + * 场地责任险有效期 + */ + @TableField("insuranceEndTime") + private Date insuranceEndTime; + /** + * 场地责任险图片 + */ + @TableField("insuranceImg") + private String insuranceImg; + /** + * 消防应急管理方案 + */ + @TableField("managementPlan") + private String managementPlan; + /** + * 状态(1=正常,2=冻结,3=删除) + */ + @TableField("state") + private Integer state; + +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/entity/SiteBooking.java b/cloud-server-other/src/main/java/com/dsh/other/entity/SiteBooking.java new file mode 100644 index 0000000..0a3c761 --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/entity/SiteBooking.java @@ -0,0 +1,108 @@ +package com.dsh.other.entity; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import lombok.Data; + +import java.util.Date; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:11 + */ +@Data +@TableName("t_site_booking") +public class SiteBooking { + /** + * 主键 + */ + @TableId(value = "id", type = IdType.AUTO) + private Integer id; + /** + * 省 + */ + @TableField("province") + private String province; + /** + * 省编号 + */ + @TableField("provinceCode") + private String provinceCode; + /** + * 市名称 + */ + @TableField("city") + private String city; + /** + * 市编号 + */ + @TableField("cityCode") + private String cityCode; + /** + * 门店id + */ + @TableField("storeId") + private Integer storeId; + /** + * 场地id + */ + @TableField("siteId") + private Integer siteId; + /** + * 预约开始时间 + */ + @TableField("startTime") + private Date startTime; + /** + * 预约结束 + */ + @TableField("endTime") + private Date endTime; + /** + * 预约人 + */ + @TableField("booker") + private String booker; + /** + * 联系方式 + */ + @TableField("phone") + private String phone; + /** + * 状态(0=待支付,1=待核销,2=已到店,3=已完成,4=已过期,5=已取消) + */ + @TableField("status") + private Integer status; + /** + * 取消用户id + */ + @TableField("cancelUserId") + private Integer cancelUserId; + /** + * 取消凭证 + */ + @TableField("voucher") + private String voucher; + /** + * 取消备注 + */ + @TableField("remark") + private String remark; + /** + * 取消时间 + */ + @TableField("cancelTime") + private Date cancelTime; + /** + * 状态(1=正常,2=冻结,3=删除) + */ + @TableField("state") + private Integer state; + /** + * 添加时间 + */ + @TableField("insertTime") + private Date insertTime; +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/entity/SiteType.java b/cloud-server-other/src/main/java/com/dsh/other/entity/SiteType.java new file mode 100644 index 0000000..71dab94 --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/entity/SiteType.java @@ -0,0 +1,31 @@ +package com.dsh.other.entity; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import lombok.Data; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:52 + */ +@Data +@TableName("t_site_type") +public class SiteType { + /** + * 主键 + */ + @TableId(value = "id", type = IdType.AUTO) + private Integer id; + /** + * 场地类型名称 + */ + @TableField("name") + private String name; + /** + * 状态(1=正常,2=冻结,3=删除) + */ + @TableField("state") + private Integer state; +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/entity/Store.java b/cloud-server-other/src/main/java/com/dsh/other/entity/Store.java index 0a50bf9..6f60e0b 100644 --- a/cloud-server-other/src/main/java/com/dsh/other/entity/Store.java +++ b/cloud-server-other/src/main/java/com/dsh/other/entity/Store.java @@ -120,11 +120,6 @@ @TableField("welfarePicture") private String welfarePicture; /** - * 开始上课图片 - */ - @TableField("classPicture") - private String classPicture; - /** * 评分 */ @TableField("score") diff --git a/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java b/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java new file mode 100644 index 0000000..2f59a66 --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteBookingMapper.java @@ -0,0 +1,11 @@ +package com.dsh.other.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.dsh.other.entity.SiteBooking; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:48 + */ +public interface SiteBookingMapper extends BaseMapper<SiteBooking> { +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteMapper.java b/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteMapper.java new file mode 100644 index 0000000..d29d99d --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/mapper/SiteMapper.java @@ -0,0 +1,11 @@ +package com.dsh.other.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.dsh.other.entity.Site; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:10 + */ +public interface SiteMapper extends BaseMapper<Site> { +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/model/StoreFreeBenefitVo.java b/cloud-server-other/src/main/java/com/dsh/other/model/StoreFreeBenefitVo.java new file mode 100644 index 0000000..23fd7f7 --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/model/StoreFreeBenefitVo.java @@ -0,0 +1,18 @@ +package com.dsh.other.model; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +/** + * @author zhibing.pu + * @date 2023/7/13 15:53 + */ +@Data +@ApiModel +public class StoreFreeBenefitVo { + @ApiModelProperty("门店电话") + private String phone; + @ApiModelProperty("福利图片") + private String img; +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java b/cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java new file mode 100644 index 0000000..06e5ccf --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/service/ISiteBookingService.java @@ -0,0 +1,11 @@ +package com.dsh.other.service; + +import com.baomidou.mybatisplus.extension.service.IService; +import com.dsh.other.entity.SiteBooking; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:49 + */ +public interface ISiteBookingService extends IService<SiteBooking> { +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/service/ISiteService.java b/cloud-server-other/src/main/java/com/dsh/other/service/ISiteService.java new file mode 100644 index 0000000..c239b6f --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/service/ISiteService.java @@ -0,0 +1,11 @@ +package com.dsh.other.service; + +import com.baomidou.mybatisplus.extension.service.IService; +import com.dsh.other.entity.Site; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:10 + */ +public interface ISiteService extends IService<Site> { +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java b/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java new file mode 100644 index 0000000..89dd15a --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteBookingServiceImpl.java @@ -0,0 +1,15 @@ +package com.dsh.other.service.impl; + +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.dsh.other.entity.SiteBooking; +import com.dsh.other.mapper.SiteBookingMapper; +import com.dsh.other.service.ISiteBookingService; +import org.springframework.stereotype.Service; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:49 + */ +@Service +public class SiteBookingServiceImpl extends ServiceImpl<SiteBookingMapper, SiteBooking> implements ISiteBookingService { +} diff --git a/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java b/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java new file mode 100644 index 0000000..26cdfc0 --- /dev/null +++ b/cloud-server-other/src/main/java/com/dsh/other/service/impl/SiteServiceImpl.java @@ -0,0 +1,15 @@ +package com.dsh.other.service.impl; + +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.dsh.other.entity.Site; +import com.dsh.other.mapper.SiteMapper; +import com.dsh.other.service.ISiteService; +import org.springframework.stereotype.Service; + +/** + * @author zhibing.pu + * @date 2023/7/13 16:11 + */ +@Service +public class SiteServiceImpl extends ServiceImpl<SiteMapper, Site> implements ISiteService { +} diff --git a/cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml b/cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml new file mode 100644 index 0000000..5a70fc4 --- /dev/null +++ b/cloud-server-other/src/main/resources/mapper/SiteBookingMapper.xml @@ -0,0 +1,6 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.dsh.other.mapper.SiteBookingMapper"> + + +</mapper> diff --git a/cloud-server-other/src/main/resources/mapper/SiteMapper.xml b/cloud-server-other/src/main/resources/mapper/SiteMapper.xml new file mode 100644 index 0000000..ef50ff2 --- /dev/null +++ b/cloud-server-other/src/main/resources/mapper/SiteMapper.xml @@ -0,0 +1,6 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.dsh.other.mapper.SiteMapper"> + + +</mapper> -- Gitblit v1.7.1