From dfafe88917bd344d570277f14b7ea7bf03fa93d4 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期三, 19 二月 2025 18:33:41 +0800
Subject: [PATCH] jtt808初始化

---
 server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java |  266 +++++++++++++++++++++++++++++++++++------------------
 1 files changed, 175 insertions(+), 91 deletions(-)

diff --git a/server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java
index 081c45e..3dff2f5 100644
--- a/server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java
+++ b/server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java
@@ -13,6 +13,8 @@
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
 import com.doumee.core.utils.DateUtil;
+import com.doumee.core.utils.HttpsUtil;
+import com.doumee.core.utils.StringTools;
 import com.doumee.core.utils.Utils;
 import com.doumee.dao.business.ActionLogMapper;
 import com.doumee.dao.business.BikesMapper;
@@ -40,9 +42,11 @@
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.CollectionUtils;
+import org.springframework.util.ConcurrentReferenceHashMap;
 
 import java.math.BigDecimal;
 import java.util.*;
+import java.util.concurrent.ConcurrentMap;
 import java.util.stream.Collectors;
 
 /**
@@ -242,6 +246,8 @@
                 Arrays.asList(Constants.MEMBER_RIDES_STATUS.RIDES_RUNNING.getKey(),Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey()));
         queryWrapper
                 .selectAs(MemberRides::getId,MemberRidesDTO::getId)
+                .selectAs(MemberRides::getDiscountPrice,MemberRidesDTO::getDiscountPrice)
+                .selectAs(MemberRides::getType,MemberRidesDTO::getType)
                 .selectAs(Member::getOpenid,MemberRidesDTO::getOpenid)
                 .selectAs(MemberRides::getBikeCode,MemberRidesDTO::getBikeCode)
                 .selectAs(MemberRides::getCloseStatus,MemberRidesDTO::getCloseStatus)
@@ -367,8 +373,33 @@
         update.setBackUserid(user.getId());
         update.setBackType(Constants.ONE);
         update.setStatus(Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey());
-        update.setBackSiteId(collect.get(Constants.FORCE_BACK_SITE).getCode());
-        update.setBackLockId(Constants.formatIntegerFromStr(collect.get(Constants.FORCE_BACK_LOCK).getCode()));
+        String logInfo = null;
+        Bikes bike =null;
+        if(Constants.equalsInteger(model.getType(),Constants.ZERO)){
+            //濡傛灉鏄嚜琛岃溅锛岀粦瀹氬埌铏氭嫙绔欑偣鍜岄攣澶�
+            update.setBackSiteId(collect.get(Constants.FORCE_BACK_SITE).getCode());
+            update.setBackLockId(Constants.formatIntegerFromStr(collect.get(Constants.FORCE_BACK_LOCK).getCode()));
+            //鎻掑叆铏氭嫙閿佸ご鍜岀珯鐐逛笂-------
+            bike = new Bikes();
+            bike.setIsdeleted(Constants.ZERO);
+            bike.setCode(model.getBikeCode());
+            bike.setType(model.getType());
+            bike.setSiteId(update.getBackSiteId());
+            bike.setLockId(update.getBackLockId());
+            if(bikesMapper.selectCount(new QueryWrapper<>(bike)) == 0){
+                bike.setId(Constants.getUUID());
+                bike.setParamId(model.getParamId());
+                bike.setLastBackDate(model.getRentDate());
+                bike.setStatus(Constants.ZERO);
+                bike.setType(Constants.ZERO);
+                bike.setForceBackInfo("寮哄埗杩樿溅缁戝畾");
+                bikesMapper.insert(bike);
+            }
+        }else{
+            //濡傛灉鏄數杞︼紝璇锋眰web绔帴鍙e叧闂溅杈嗕俊鎭�
+            bike =   sendCloseElecBikeRequest(memberRides.getBikeCode(),Constants.ONE);
+        }
+        logInfo = bike!=null?bike.getForceBackInfo():null;
         Integer freeRentTime = Integer.valueOf(collect.get(Constants.FREE_RENT_TIME).getCode());
         Integer rideTime = DateUtil.betweenMin(model.getRentDate(), update.getBackDate());
         //璁$畻楠戣璁¤垂鏃堕暱
@@ -379,21 +410,6 @@
         String beforeContent = JSONObject.toJSONString(model);
         //淇敼鍚�
         String after = JSONObject.toJSONString(update);
-
-        //鎻掑叆铏氭嫙閿佸ご鍜岀珯鐐逛笂-------
-        Bikes bike = new Bikes();
-        bike.setIsdeleted(Constants.ZERO);
-        bike.setCode(model.getBikeCode());
-        bike.setSiteId(update.getBackSiteId());
-        bike.setLockId(update.getBackLockId());
-        if(bikesMapper.selectCount(new QueryWrapper<>(bike)) == 0){
-            bike.setId(Constants.getUUID());
-            bike.setParamId(model.getParamId());
-            bike.setLastBackDate(model.getRentDate());
-            bike.setStatus(Constants.ZERO);
-            bike.setInfo("寮哄埗杩樿溅缁戝畾");
-            bikesMapper.insert(bike);
-        }
 
         ActionLog log = new ActionLog();
         log.setId(Constants.getUUID());
@@ -408,6 +424,7 @@
         log.setObjType(Constants.ActionLogObjType.memberrides);
         log.setResult(Constants.ZERO);
         log.setObjId(model.getId());
+        log.setInfo(logInfo);
         log.setType(Constants.ACTIONLOG_TYPE.FORCE_BACK.getKey());
         log.setContent(Constants.ACTIONLOG_TYPE.FORCE_BACK.getInfo());
         log.setTitle(Constants.ACTIONLOG_TYPE.FORCE_BACK.getName());
@@ -417,84 +434,146 @@
         actionLogMapper.insert(log);
 
     }
+    /**
+     *  濡傛灉鏄數杞︼紝璇锋眰web绔帴鍙e叧闂溅杈嗕俊鎭�
+     */
+    private Bikes sendCloseElecBikeRequest(String bikeCode,int type) {
+        Bikes  bike = bikesMapper.selectOne(new QueryWrapper<Bikes>().lambda()
+                .eq(Bikes::getType,Constants.ONE)
+                .eq(Bikes::getIsdeleted,Constants.ZERO)
+                .eq(Bikes::getCode,bikeCode)
+        );
+        if(bike == null){
+            return null;
+        }
+        bike.setForceBackInfo("寮哄埗杩樿溅鍏抽棴杞﹂攣澶辫触锛�");
+        if(StringUtils.isNotBlank(bike.getDeviceSn())){
+            try {
+                //璇锋眰鍦板潃
+                String url = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.ELEC_BIKE_CONTRIL_API_URL).getCode();
+                JSONObject param = new JSONObject();
+                param.put("clientId",StringTools.leftTrip(bike.getDeviceSn(),'0'));
+                param.put("type",type);//0寮�閿� 1鍏抽攣
+                String res = HttpsUtil.postJsonString(url,param.toJSONString());
+                JSONObject json = JSONObject.parseObject(res);
+                if(json.get("code").equals("200")){
+                    //鍙戣捣鎸囦护鎴愬姛
+                    bike.setForceBackInfo("寮哄埗杩樿溅鍏抽棴杞﹂攣鎴愬姛锛�");
+                }else{
+                    bike.setForceBackInfo("寮哄埗杩樿溅鍏抽棴杞﹂攣澶辫触锛�"+json.get("msg"));
+                }
+            }catch (Exception e){
+                e.printStackTrace();
+            }
+        }else{
+            bike.setForceBackInfo("寮哄埗杩樿溅鍏抽棴杞﹂攣澶辫触,鏈粦瀹氭帶鍒跺櫒sn锛�");
+        }
+        bikesMapper.updateById(bike);
+        return bike;
+    }
 
+    public static void main(String[] args) {
+        String url = "http://localhost:10025/jtt808/device/8500";
+        JSONObject param = new JSONObject();
+        param.put("clientId",StringTools.leftTrip("0067244400211",'0'));
+        param.put("type",0);//0寮�閿� 1鍏抽攣
+        String res = HttpsUtil.postJsonString(url,param.toJSONString());
+        System.out.println(res);
+    }
+    public ConcurrentMap<String,Integer> cacheOpenLock = new ConcurrentReferenceHashMap<>();
 
     @Override
     public MemberRidesDetailResponse openLock(String code,String memberId) {
-        if(StringUtils.isBlank(code) ||  code.split("/").length != 2){
-            throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝璇ョ珯鐐圭紪鍙蜂笉瀛樺湪锛岃灏濊瘯鏇存崲杞﹁締锛�");
+        if(Constants.formatIntegerNum(cacheOpenLock.get(code)) == 1){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ヨ溅杈嗗凡琚攣瀹氬�熺敤锛岃灏濊瘯鏇存崲鍏朵粬杞﹁締锛�");
         }
-        //鍒ゆ柇褰撳墠鏄惁宸叉敮浠樻娂閲�
-        Goodsorder goodsorder = goodsorderService.findOneByWrapper(new QueryWrapper<Goodsorder>()
-                .eq("isdeleted", Constants.ZERO)
-                .eq("status", Constants.goodsorderStatus.pay)
-                .eq("member_id", memberId)
-                .orderByDesc("create_date")
-                .last("limit 1"));
-        if (Objects.isNull(goodsorder)) {
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "鏈敮浠樻娂閲戯紝鏃犳硶杩涜璇ユ搷浣滐紒");
-        }
-        //鍒ゆ柇褰撳墠鎶奸噾璁㈠崟鏄惁涓轰粖鏃ユ娂閲�
-        if (!DateUtil.DateToStr(goodsorder.getPayDate(), "yyyy-MM-dd").equals(DateUtil.getDate(new Date(), "yyyy-MM-dd"))) {
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "闈炰粖鏃ユ娂閲戣鍗曪紝璇风粨绠楀悗閲嶆柊鏀粯锛�");
-        }
-        //鍒ゆ柇鏄惁澶勪簬钀ヤ笟鏃堕棿
-        goodsorderService.checkBusiness();
-        //鏌ヨ鏄惁澶勪簬楠戣涓�
-        if (memberRidesMapper.selectCount(new QueryWrapper<MemberRides>().eq("member_id", memberId).in("status", 0, 1)) > Constants.ZERO) {
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀛樺湪楠戣涓溅杈嗭紝鏃犳硶鎵爜");
-        }
-        String[] codes = code.split("/");
-        Locks locks = locksMapper.selectOne(new QueryWrapper<Locks>()
-                .lambda().eq(Locks::getCode, codes[1])
-                .eq(Locks::getSiteId, codes[0])
-                .eq(Locks::getIsdeleted, Constants.ZERO)
-                .last("limit 1"));
-        if (Objects.isNull(locks)) {
+        cacheOpenLock.put(code, 1);
+        try {
+            if(StringUtils.isBlank(code) ||  code.split("/").length != 2){
+                throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝璇ョ珯鐐圭紪鍙蜂笉瀛樺湪锛岃灏濊瘯鏇存崲杞﹁締锛�");
+            }
+            //鍒ゆ柇褰撳墠鏄惁宸叉敮浠樻娂閲�
+            Goodsorder goodsorder = goodsorderService.findOneByWrapper(new QueryWrapper<Goodsorder>()
+                    .eq("isdeleted", Constants.ZERO)
+                    .eq("status", Constants.goodsorderStatus.pay)
+                    .eq("member_id", memberId)
+                    .orderByDesc("create_date")
+                    .last("limit 1"));
+            if (Objects.isNull(goodsorder)) {
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "鏈敮浠樻娂閲戯紝鏃犳硶杩涜璇ユ搷浣滐紒");
+            }
+            //鍒ゆ柇褰撳墠鎶奸噾璁㈠崟鏄惁涓轰粖鏃ユ娂閲�
+            if (!DateUtil.DateToStr(goodsorder.getPayDate(), "yyyy-MM-dd").equals(DateUtil.getDate(new Date(), "yyyy-MM-dd"))) {
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "闈炰粖鏃ユ娂閲戣鍗曪紝璇风粨绠楀悗閲嶆柊鏀粯锛�");
+            }
+            //鍒ゆ柇鏄惁澶勪簬钀ヤ笟鏃堕棿
+            goodsorderService.checkBusiness();
+            //鏌ヨ鏄惁澶勪簬楠戣涓�
+            if (memberRidesMapper.selectCount(new QueryWrapper<MemberRides>().eq("member_id", memberId).in("status", 0, 1)) > Constants.ZERO) {
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀛樺湪楠戣涓溅杈嗭紝鏃犳硶鎵爜");
+            }
+            String[] codes = code.split("/");
+            Locks locks = locksMapper.selectOne(new QueryWrapper<Locks>()
+                    .lambda().eq(Locks::getCode, codes[1])
+                    .eq(Locks::getSiteId, codes[0])
+                    .eq(Locks::getIsdeleted, Constants.ZERO)
+                    .last("limit 1"));
+            if (Objects.isNull(locks)) {
 //            locks =new Locks();
 //            locks.setCode(codes[1]);
 //            locks.setSiteId(codes[0]);
 //            deviceService.getLockInfo(locks);
-            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "鎵爜鏃犳晥锛岃绔欑偣閿佸ご鏆備笉鏀寔鍊熷嚭涓氬姟鍝︼紒");
+                throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "鎵爜鏃犳晥锛岃绔欑偣閿佸ご鏆備笉鏀寔鍊熷嚭涓氬姟鍝︼紒");
+            }
+            //鏌ヨ閿佸ご鏄惁瀛樺湪杞﹁締 浠ュ強鏄惁姝e父
+            if (Constants.formatIntegerNum(locks.getStatus())!=Constants.ZERO) {
+                locks =new Locks();
+                locks.setCode(Constants.formatIntegerFromStr(codes[1]));
+                locks.setSiteId(codes[0]);
+                deviceService.getLockInfo(locks);
+                throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "褰撳墠杞﹁締鏆傛椂鏃犳硶浣跨敤锛岃绋嶅悗閲嶈瘯鎴栨洿鎹㈠叾瀹冭溅杈唦");
+            }
+            if (StringUtils.isBlank(locks.getBikeCode())) {
+                locks =new Locks();
+                locks.setCode(Constants.formatIntegerFromStr(codes[1]));
+                locks.setSiteId(codes[0]);
+                locks.setId(codes[1]);
+                deviceService.getLockInfo(locks);
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "褰撳墠杞﹁締鏆傛椂鏃犳硶浣跨敤锛岃绋嶅悗閲嶈瘯鎴栨洿鎹㈠叾瀹冭溅杈嗭紒");
+            }
+            MemberRides memberRides = new MemberRides();
+            //鏍规嵁杞﹀瀷鏌ヨ璁′环鏂规
+            isValidePricingType(locks,memberRides) ;
+            MqttLog flag = deviceService.openLock(locks);
+            MemberRidesDetailResponse memberRidesDetailResponse = new MemberRidesDetailResponse();
+            if (flag.getResult() == 0) {
+                //瀛樺偍楠戣璁板綍
+                memberRides.setId(Constants.getUUID());
+                memberRides.setIsdeleted(Constants.ZERO);
+                memberRides.setMemberId(memberId);
+                memberRides.setCreateDate(new Date());
+                memberRides.setRentSiteId(locks.getSiteId());
+                memberRides.setRentLockId(locks.getCode());
+                memberRides.setOrdreId(goodsorder.getId());
+                memberRides.setRentDate(new Date());
+                memberRides.setType(Constants.ZERO);
+                memberRides.setBalance(new BigDecimal(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.RENT_DEPOSIT).getCode()));
+                memberRides.setStatus(Constants.MEMBER_RIDES_STATUS.LOCKING.getKey());
+                memberRides.setCloseStatus(Constants.ZERO);
+                memberRidesMapper.insert(memberRides);
+                BeanUtils.copyProperties(memberRides, memberRidesDetailResponse);
+            }else{
+                throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "褰撳墠杞﹁締鏆傛椂鏃犳硶浣跨敤锛岃绋嶅悗閲嶈瘯鎴栨洿鎹㈠叾瀹冭溅杈唦");
+            }
+            return memberRidesDetailResponse;
+        }catch (BusinessException biz){
+            throw  biz;
+        }catch (Exception biz){
+            throw  new BusinessException(ResponseStatus.SERVER_ERROR);
+        }finally {
+            cacheOpenLock.remove(code);
         }
-        //鏌ヨ閿佸ご鏄惁瀛樺湪杞﹁締 浠ュ強鏄惁姝e父
-        if (Constants.formatIntegerNum(locks.getStatus())!=Constants.ZERO) {
-            locks =new Locks();
-            locks.setCode(Constants.formatIntegerFromStr(codes[1]));
-            locks.setSiteId(codes[0]);
-            deviceService.getLockInfo(locks);
-            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "褰撳墠杞﹁締鏆傛椂鏃犳硶浣跨敤锛岃绋嶅悗閲嶈瘯鎴栨洿鎹㈠叾瀹冭溅杈唦");
-        }
-        if (StringUtils.isBlank(locks.getBikeCode())) {
-            locks =new Locks();
-            locks.setCode(Constants.formatIntegerFromStr(codes[1]));
-            locks.setSiteId(codes[0]);
-            deviceService.getLockInfo(locks);
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "褰撳墠杞﹁締鏆傛椂鏃犳硶浣跨敤锛岃绋嶅悗閲嶈瘯鎴栨洿鎹㈠叾瀹冭溅杈嗭紒");
-        }
-        MemberRides memberRides = new MemberRides();
-        //鏍规嵁杞﹀瀷鏌ヨ璁′环鏂规
-        isValidePricingType(locks,memberRides) ;
-        MqttLog flag = deviceService.openLock(locks);
-        MemberRidesDetailResponse memberRidesDetailResponse = new MemberRidesDetailResponse();
-        if (flag.getResult() == 0) {
-            //瀛樺偍楠戣璁板綍
-            memberRides.setId(Constants.getUUID());
-            memberRides.setIsdeleted(Constants.ZERO);
-            memberRides.setMemberId(memberId);
-            memberRides.setCreateDate(new Date());
-            memberRides.setRentSiteId(locks.getSiteId());
-            memberRides.setRentLockId(locks.getCode());
-            memberRides.setOrdreId(goodsorder.getId());
-            memberRides.setRentDate(new Date());
-            memberRides.setBalance(new BigDecimal(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.RENT_DEPOSIT).getCode()));
-            memberRides.setStatus(Constants.MEMBER_RIDES_STATUS.LOCKING.getKey());
-            memberRides.setCloseStatus(Constants.ZERO);
 
-            memberRidesMapper.insert(memberRides);
-            BeanUtils.copyProperties(memberRides, memberRidesDetailResponse);
-        }
-        return memberRidesDetailResponse;
     }
 
     private boolean isValidePricingType(Locks locks,MemberRides memberRides ) {
@@ -586,7 +665,7 @@
         //杞﹁締璁板綍
         Bikes bikes = dealBikesByParam(model);
         //鐘舵�侊紝0闂悎, 1鎵撳紑锛�2杩愯涓�, 3寮傚父
-        if(locks.getStatus() == Constants.LockStatus.open){
+        if(Constants.formatIntegerNum(locks.getStatus()) == Constants.LockStatus.open){
             //濡傛灉鏄紑閿佷笟鍔★紝鍒ゆ柇鏄惁鏈夊紑閿佷腑鐨勪俊鎭�
             MemberRides memberRides = new MemberRides();
             memberRides.setStatus(Constants.MEMBER_RIDES_STATUS.LOCKING.getKey());
@@ -603,7 +682,7 @@
             update.setId(memberRides.getId());
             //锛堟洿鏂拌姹傚紑閿佷腑鐨勯攣澶村叧鑱旂殑楠戣璁板綍锛�
             memberRidesMapper.updateById( update);
-        }else   if(locks.getStatus() == Constants.LockStatus.closed ){
+        }else   if(Constants.formatIntegerNum(locks.getStatus())  == Constants.LockStatus.closed ){
             //濡傛灉鏄叧閿佷笟鍔★紝鍒ゆ柇瑙﹀彂杩樿溅
             if(StringUtils.isNotBlank(locks.getBikeCode())){
                 MemberRides mbikes = new MemberRides();
@@ -639,6 +718,10 @@
 
     @Override
     public void autoRefreshLockStatus() {
+//        memberRidesMapper.update(null,new UpdateWrapper<MemberRides>().lambda()
+//                        .eq(MemberRides::getStatus,Constants.MEMBER_RIDES_STATUS.LOCKING.getKey())
+//                .apply(""  )
+//                .set(MemberRides::getStatus, Constants.MEMBER_RIDES_STATUS.LOCKING_DEFEAT.getKey()))
 
         QueryWrapper<MemberRides> wrapper = new QueryWrapper<>();
         wrapper.lambda()
@@ -647,10 +730,10 @@
         List<MemberRides> memberRides = memberRidesMapper.selectList(wrapper);
         if (!CollectionUtils.isEmpty(memberRides)){
             memberRides.forEach(s->{
-                Integer between = DateUtil.between(s.getCreateDate(), new Date());
-                // 澶т簬闃堝��
-                if (between > 2){
-                    s.setStatus(Constants.MEMBER_RIDES_STATUS.LOCKING_DEFEAT.getKey());
+                Integer between = DateUtil.betweenSeconds(s.getCreateDate(), new Date());
+                // 澶т簬闃堝��,鑷姩璁句负寮�閿佹垚鍔燂紙濡傚疄闄呮湭寮�閿侊紝鑱旂郴绔欑偣绠$悊鍛樺悗鍙拌繘琛屽己鍒惰繕杞︽搷浣滐級
+                if (between >= 20){
+                    s.setStatus(Constants.MEMBER_RIDES_STATUS.RIDES_RUNNING.getKey());
                     s.setEditDate(new Date());
                     memberRidesMapper.updateById(s);
                 }
@@ -694,6 +777,7 @@
             bikes.setEditDate(bikes.getCreateDate());
             bikes.setSiteId(model.getSiteId());
             bikes.setLockId(model.getCode());
+            bikes.setType(Constants.ZERO);
             bikes.setCode(model.getBikeCode());
             bikes.setParamId(getBileTypeByCode(model.getBikeCode()));
             bikesMapper.insert(bikes);
@@ -774,7 +858,7 @@
             if(Objects.nonNull(sites)){
                 Sites sites1 = new Sites();
                 sites1.setId(sites.getId());
-                sites1.setLockNum(sites.getLockNum()+1);
+                sites1.setLockNum(Constants.formatIntegerNum(sites.getLockNum())+1);
                 sitesMapper.updateById(sites1);
             }
         }else{

--
Gitblit v1.9.3