ERP系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
xinyb
2024-07-18 80430d52f7716e3eb3e517dc96f94c4a6f9657bf 
 src/com/yc/sdk/shopping/service/SettingImpl.java


@@ -1,14 +1,13 @@


package com.yc.sdk.shopping.service;




import java.io.File;


import java.io.IOException;


import java.io.InputStream;


import java.sql.ResultSet;


import java.sql.SQLException;


import java.util.List;


import java.util.Map;


import java.util.UUID;




import com.yc.action.grid.GridUtils;


import com.yc.sdk.shopping.entity.ReferrerRewardEntity;


import com.yc.sdk.shopping.entity.SettingEntity;


import com.yc.sdk.shopping.entity.SettingFileEntity;


import com.yc.sdk.shopping.entity.ShoppingImageEntity;


import com.yc.sdk.shopping.util.BlobToFile;


import com.yc.sdk.shopping.util.SettingKey;


import com.yc.service.BaseService;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.context.annotation.Scope;


import org.springframework.dao.DataAccessException;


@@ -18,12 +17,16 @@


import org.springframework.jdbc.support.lob.DefaultLobHandler;


import org.springframework.stereotype.Service;




import com.yc.sdk.shopping.entity.ReferrerRewardEntity;


import com.yc.sdk.shopping.entity.SettingEntity;


import com.yc.sdk.shopping.entity.SettingFileEntity;


import com.yc.sdk.shopping.entity.ShoppingImageEntity;


import com.yc.sdk.shopping.util.BlobToFile;


import com.yc.service.BaseService;


import javax.servlet.http.HttpServletRequest;


import javax.servlet.http.HttpSession;


import java.io.File;


import java.io.IOException;


import java.io.InputStream;


import java.sql.ResultSet;


import java.sql.SQLException;


import java.util.List;


import java.util.Map;


import java.util.UUID;




@Service("SettingImpl")


@Scope("prototype")


@@ -36,13 +39,13 @@


   @Override


   public ReferrerRewardEntity getReferrerRewardEntity(String shopCcCode) {


      String sql = " set nocount on ;  \n"


            + " declare @ShopCcCode varchar(50) = ? \n"


            + " declare @ShopCcCode varchar(50) = "+GridUtils.prossSqlParm(shopCcCode)+" \n"


            + " select top 1 ShopCcCode,ReferrerReward from t714012 a \n"


            + " where ((isnull(@ShopCcCode,'') = '' and  isnull(a.ShopCcCode,'') = '') \n"


            + "  or (isnull(@ShopCcCode,'') <> '' and  isnull(a.ShopCcCode,'') = isnull(@ShopCcCode,'')) )\n";


      Map<String,Object> map = null ;


      try {


         map = this.jdbcTemplate.queryForMap(sql,shopCcCode) ;


         map = this.jdbcTemplate.queryForMap(sql) ;


         ReferrerRewardEntity referrerRewardEntity = new ReferrerRewardEntity() ;


         if (map != null) {


            referrerRewardEntity.setShopCcCode(map.get("ShopCcCode")==null?"":(String)map.get("ShopCcCode"));


@@ -140,7 +143,8 @@


            + " a.isShowLiveBannerPhotoOnHomePage,a.LiveBannerPhoto,a.isShowBannerPhotoOnHomePageForLiveUser, \n"


            + " a.isStartupPriceSubsystem,a.PriceSubsystemMemberLevels,a.isStartupBalancePay,\n"


            + " a.isShowBuyingButton,a.isShowElectronicVoucherButton,a.PersonalAuthenticationAmount,a.PaymentCountdown, \n"


            + " a.FeeRateForWxPay,a.PlatformOperatorCommissionRatio,a.WithdrawalExpiryHours \n"


            + " a.FeeRateForWxPay,a.PlatformOperatorCommissionRatio,a.WithdrawalExpiryHours,a.HelpUrl,a.isShowPreSendDate,a.ShowKeFuTelephone, \n"


            + " a.isShowSurvey,a.isShowRepairRequest,a.isShowFeedBack,a.isShowInstallationService,a.isShowReplacementService \n"


            + " from t714001 a left join t110601 b on a.DefaultShopCcCode = b.CcCode  \n"


            + " left join t714030 c on a.CountryId = c.CountryId \n"


            + " left join t110202 d on a.ProvinceZoneId = d.ZoneId \n" 


@@ -266,7 +270,8 @@


         set.setLowOrderFeeTotal(map.get("LowOrderFeeTotal") == null ? null:Double.parseDouble(map.get("LowOrderFeeTotal").toString()));


         set.setLowOrderFeeFee(map.get("LowOrderFeeFee") == null ? null: Double.parseDouble(map.get("LowOrderFeeFee").toString()));


         set.setLowOrderFeeSortOrder(map.get("LowOrderFeeSortOrder") == null ? null: (Integer)map.get("LowOrderFeeSortOrder"));


         set.setRewardStatus(map.get("RewardStatus") == null || (Integer)map.get("RewardStatus") == 0 ? false : true);


//         set.setRewardStatus(map.get("RewardStatus") == null || (Integer)map.get("RewardStatus") == 0 ? false : true);


         set.setRewardStatus(map.get("RewardStatus") == null ? 0:(Integer)map.get("RewardStatus"));//改成输出实际值 xin 2024-7-18 10:37:37


         set.setRewardSortOrder(map.get("RewardSortOrder") == null ? null :(Integer)map.get("RewardSortOrder"));


         set.setShippingEstimator(map.get("ShippingEstimator") == null || (Integer)map.get("ShippingEstimator") == 0 ? false : true);


         set.setShippingStatus(map.get("ShippingStatus") == null || (Integer)map.get("ShippingStatus") == 0 ? false : true);


@@ -423,6 +428,14 @@


         set.setFeeRateForWxPay(map.get("FeeRateForWxPay") == null ? 0:  Double.parseDouble(map.get("FeeRateForWxPay").toString()));


         set.setPlatformOperatorCommissionRatio(map.get("PlatformOperatorCommissionRatio") == null ? 0:  Double.parseDouble(map.get("PlatformOperatorCommissionRatio").toString()));


         set.setWithdrawalExpiryHours(map.get("WithdrawalExpiryHours") == null ? 0:  (Integer)map.get("WithdrawalExpiryHours"));


         set.setHelpUrl(map.get("HelpUrl") == null ? "":  (String)map.get("HelpUrl"));


         set.setShowPreSendDate(map.get("isShowPreSendDate") != null &&map.get("isShowPreSendDate").equals(1)?true:false );


         set.setShowKeFuTelephone(map.get("ShowKeFuTelephone") == null ? 1:  (Integer)map.get("ShowKeFuTelephone"));


         set.setShowSurvey(map.get("isShowSurvey") == null||((Integer)map.get("isShowSurvey")).equals(0)  ? false :true);


         set.setShowRepairRequest(map.get("isShowRepairRequest") == null||((Integer)map.get("isShowRepairRequest")).equals(0)  ? false :true);


         set.setShowFeedBack(map.get("isShowFeedBack") == null||((Integer)map.get("isShowFeedBack")).equals(0)  ? false :true);


         set.setShowInstallationService(map.get("isShowInstallationService") == null||((Integer)map.get("isShowInstallationService")).equals(0)  ? false :true);


         set.setShowReplacementService(map.get("isShowReplacementService") == null||((Integer)map.get("isShowReplacementService")).equals(0)  ? false :true);




         //取小程序订单提醒消息


         sql = " set nocount on \n"


@@ -546,7 +559,7 @@


   public SettingFileEntity getCpUserHeadImageFile(String userCode) {


      settingFileEntity.setImage(null);


      String sql = " set nocount on ;  \n"


            + " declare @UserCode varchar(50) = ? ;\n"


            + " declare @UserCode varchar(50) = "+GridUtils.prossSqlParm(userCode)+" ;\n"


            + " declare @Image varchar(50) ,@ImageThumbWidth int, @ImageThumbHeight int ; \n"


            + "  select @Image = WeiXinAvatarUnid from _sys_LoginUser a where UserCode = @UserCode ; \n"


            + "  if isnull( @Image,'') = '' return ;  \n"


@@ -616,7 +629,7 @@


   public SettingFileEntity getMpUserHeadImageFile(String openId) {


      settingFileEntity.setImage(null);


      String sql = " set nocount on ;  \n"


            + " declare @OpenId varchar(50) = ? ;\n"


            + " declare @OpenId varchar(50) = "+GridUtils.prossSqlParm(openId)+" ;\n"


            + " declare @Image varchar(50) ,@ImageThumbWidth int, @ImageThumbHeight int ; \n"


            + "  select @Image = WeiXinAvatarUnid from t720102 a where OpenId = @OpenId ; \n"


            + "  if isnull( @Image,'') = '' return ;  \n"


@@ -681,6 +694,19 @@


      }


      


   }




   @Override


   public SettingEntity getSettingEntity(HttpServletRequest request) {


      HttpSession session=request.getSession();


      //从会话取 settingEntity 


      SettingEntity settingEntity = (SettingEntity) session.getAttribute(SettingKey.settingEntity) ;


      if (settingEntity == null) {


         settingEntity = this.getSettingEntity();


         //保存到会话


         session.setAttribute(SettingKey.settingEntity,settingEntity);  


      }


      return settingEntity;


   }


   




}