package com.yc.sdk.shopping.service;
|
|
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;
|
import org.springframework.dao.EmptyResultDataAccessException;
|
import org.springframework.jdbc.LobRetrievalFailureException;
|
import org.springframework.jdbc.core.support.AbstractLobStreamingResultSetExtractor;
|
import org.springframework.jdbc.support.lob.DefaultLobHandler;
|
import org.springframework.stereotype.Service;
|
|
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")
|
public class SettingImpl extends BaseService implements SettingIfc {
|
@Autowired
|
private DefaultLobHandler defaultLobHandler;
|
|
private final SettingFileEntity settingFileEntity = new SettingFileEntity() ;
|
|
@Override
|
public ReferrerRewardEntity getReferrerRewardEntity(String shopCcCode) {
|
String sql = " set nocount on ; \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) ;
|
ReferrerRewardEntity referrerRewardEntity = new ReferrerRewardEntity() ;
|
if (map != null) {
|
referrerRewardEntity.setShopCcCode(map.get("ShopCcCode")==null?"":(String)map.get("ShopCcCode"));
|
referrerRewardEntity.setReferrerReward(map.get("ReferrerReward") == null ? 0L : Double.parseDouble(map.get("ReferrerReward").toString()));
|
}
|
return referrerRewardEntity ;
|
}catch(DataAccessException e ) {
|
if (e instanceof EmptyResultDataAccessException){
|
return null ;
|
}else {
|
e.printStackTrace();
|
throw e;
|
}
|
}catch(Exception e){
|
e.printStackTrace();
|
throw e;
|
}
|
}
|
|
@Override
|
public SettingEntity getSettingEntity() {
|
String sql = " set nocount on ; \n"
|
+ " declare @AIMessageDefaultTemplateId varchar(80) \n"
|
+ " select @AIMessageDefaultTemplateId = AIMessageDefaultTemplateId from t730114H \n"
|
|
+ " select top 1 @AIMessageDefaultTemplateId = AIMessageDefaultTemplateId from t730114H \n"
|
+ " select top 1 a.MetaTitle,a.MetaDescription,a.MetaKeyword,a.Name,a.Owner,a.Address,\n"
|
+ " a.GeoCode, a.Longitude,a.Latitude,a.Email, \n"
|
+ " a.Telephone,a.Fax,a.Image,a.OpenDate,a.Comment, \n"
|
+ " a.Currency,a.CurrencyAuto,a.LengthClassId, \n"
|
+ " a.WeightClassId,a.LangId,a.isShowMatCode,a.isShowMatName,a.isShowSpecial,a.isShowPoints, \n"
|
+ " a.ProductCount,a.ProductLimit, \n"
|
+ " a.ProductDescriptionLength,a.ReviewStatus, \n"
|
+ " a.ReviewGuest,a.ReviewMail,a.isShowSalesCharts,a.VoucherMin,a.VoucherMax,a.Tax,\n"
|
+ " a.TaxDefault,a.TaxCustomer,a.AccountId,a.CartWeight, \n"
|
+ " a.CheckoutId,a.OrderStatusId,a.StockDisplay,a.StockWarning,a.StockCheckout,a.Logo,a.Icon, \n"
|
+ " a.ImageBrandWidth,a.ImageBrandHeight,a.isShowBrandOrgImage, \n"
|
+ " a.ImageLogoWidth,a.ImageLogoHeight,a.isShowLogoOrgImage, \n"
|
+ " a.ImageCategoryWidth,a.ImageCategoryHeight,a.isShowCategoryOrgImage, \n"
|
+ " a.ImageThumbWidth,a.ImageThumbHeight,a.isShowThumbOrgImage, \n"
|
+ " a.ImagePopupWidth,a.ImagePopupHeight,a.isShowPopupOrgImage, \n"
|
+ " a.ImageProductWidth,a.ImageProductHeight,a.isShowProductOrgImage, \n"
|
+ " a.ImageAdditionalWidth,a.ImageAdditionalHeight,a.isShowAdditionalOrgImage, \n"
|
+ " a.ImageRelatedWidth,a.ImageRelatedHeight,a.isShowRelatedOrgImage, \n"
|
+ " a.ImageCompareWidth,a.ImageCompareHeight,a.isShowCompareOrgImage, \n"
|
+ " a.ImageWishlistWidth,a.ImageWishlistHeight,a.isShowWishlistOrgImage, \n"
|
+ " a.ImageCartWidth,a.ImageCartHeight,a.isShowCartOrgImage, \n"
|
+ " a.ImageLocationWidth,a.ImageLocationHeight,a.isShowLocationOrgImage, \n"
|
+ " a.ImageBannerWidth,a.ImageBannerHeight,a.isShowBannerOrgImage , \n"
|
+ " a.ImageManufacturerWidth,a.ImageManufacturerHeight, a.isShowManufacturerOrgImage , \n"
|
+ " a.Maintenance,CouponStatus,a.CouponSortOrder,a.HandlingStatus,a.HandlingTotal,a.HandlingFee, \n"
|
+ " a.HandlingSortOrder,a.LowOrderFeeStatus,a.LowOrderFeeTotal,a.LowOrderFeeFee,a.LowOrderFeeSortOrder, \n"
|
+ " a.RewardStatus,a.RewardSortOrder,a.ShippingEstimator,a.ShippingStatus,a.ShippingSortOrder, \n"
|
+ " a.VoucherStatus,a.VoucherSortOrder, \n"
|
+ " a.isShowPrice,a.isSyncWxCpUser,a.cccode,a.WxCpQRCode,a.WxMpQRCode,a.cssCaptionHeight, \n"
|
+ " a.isShowDistributor,a.isDiscardDistributor,a.PreSendDays, \n"
|
|
|
+ " a.CountryId,a.isShowCountryId,a.isRequiredCountryId, \n"
|
+ " a.ProvinceZoneId,a.isShowProvinceZoneId,a.isRequiredProvinceZoneId, \n"
|
+ " a.CityZoneId,a.isShowCityZoneId,a.isRequiredCityZoneId, \n"
|
+ " a.CountyZoneId,a.isShowCountyZoneId,a.isRequiredCountyZoneId, \n"
|
+ " a.ReferralsType,a.isShowReferralsCode,a.isRequiredReferralsCode, \n"
|
+ " a.CltType,a.isShowCltType,a.isRequiredCltType, a.DefaultMemberLevel,\n"
|
+ " a.isShowTel,a.isRequiredTel,a.isShowFax,a.isRequiredFax,a.isShowEmail,a.isRequiredEmail, \n"
|
+ " a.isShowSourceInfo,a.isRequiredSourceInfo,a.isShowPassword,a.isRequiredPassword, \n"
|
+ " a.isShowOrganization,a.isRequiredOrganization,a.isShowAddress,a.isRequiredAddress, \n"
|
+ " a.isShowPropertyId,a.isRequiredPropertyId,a.isShowPostcode,a.isRequiredPostcode, \n"
|
+ " a.isShowImageAdditional,a.isFromCached, \n"
|
+ " a.isModifyProfile,a.isModifyPassword,a.isModifyAddress,a.isModifyDistributor, \n"
|
+ " a.isModifyWishList,a.isModifyOrder,a.isModifyReward,a.isShowBalance,a.isShowMyWallet,\n"
|
+ " a.isModifyContact,a.isModifyReturn, \n"
|
+ " a.isModifyAttention,a.isModifyBrand,a.isModifyVoucher,a.isModifySpecialoffer, \n"
|
+ " a.isModifyWxUser,a.isShowMyCustomer,a.WxPayAcctCode,a.isShowDescription, \n"
|
+ " isnull(a.ProductListStyle,0) as ProductListStyle, \n"
|
+ " isnull(a.ProductDetailStyle,0) as ProductDetailStyle ,\n"
|
+ " isnull(a.CategoryListStyle,0) as CategoryListStyle, \n"
|
+ " isnull(a.MyPageStyle,0) as MyPageStyle , \n"
|
+ " a.isShowDistributorAddress ,a.isShowCompare,a.CouponsBuyReminderTemplateId,\n"
|
+ " a.StartingPointForRedemption,a.isShowBuyButtonOnHomePage,a.isShowRatingOnHomePage,\n"
|
+ " a.DefaultShopCcCode,isnull(b.CcName,'') as DefaultShopCcName, \n"
|
+ " a.SharedPoints,a.isAllowWithdraw,a.WithdrawAmount,a.WithdrawTimes,a.WithdrawTaxRate,a.isAllowRecharge,a.WithdrawType, \n"
|
+ " a.isShowCategory,a.isShowNaviByCcCode,a.isShowMatGroupInHomePage,\n"
|
+ " a.HomePageBackgroundColor,a.SubscriptionReminderTemplateId,a.SubscriptionNotificationTemplateId, \n"
|
+ " a.isStartupMatName2,a.MatName2Label,a.isStartupMatName3,a.MatName3Label,\n"
|
+ " a.isStartupMatName4,a.MatName4Label,a.isShowBrand, \n"
|
+ " c.CountryName,d.AreaName as ProvinceName,e.AreaName as CityName,a.HomeLayoutStyle,a.CosmoHomePageImage, \n"
|
+ " a.NormalSearchKey,a.ChooseFloorId,a.isPullTelephoneWhenViewProductDetail ,a.ReceiverForSalesOrder,\n"
|
+ " a.ReceiverTemplateForSalesOrder,a.GenerateOrderProcess,a.ShoppingGroupName, \n"
|
+ " a.CouponsBuyReminderTemplateIdForMiniApp,\n"
|
+ " a.MiniProgramState,a.RemindBeforeExpiration, \n"
|
+ " @AIMessageDefaultTemplateId as AIMessageDefaultTemplateId,a.isAllowReturnOrder, \n"
|
+ " a.isStartupLeagueShopCcCode,a.DefaultSourceInfo,a.CardStyle,a.HometownGreetingsImage,a.SchoolmateGreetingsImage, \n"
|
+ " a.ParallelNumberForInnerMenuOnHomePage,a.isShowPoster,a.isAllowSelectDeliveryMethod,a.DeliveryMethod,\n"
|
+ " 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,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"
|
+ " left join t110202 e on a.CityZoneId = e.ZoneId \n" ;
|
|
Map<String,Object> map = null ;
|
try {
|
map = this.jdbcTemplate.queryForMap(sql) ;
|
SettingEntity set = new SettingEntity() ;
|
set.setMetaTitle(map.get("MetaTitle") == null ? "": (String)map.get("MetaTitle"));
|
|
set.setMetaDescription(map.get("MetaDescription") == null ? "": (String)map.get("MetaDescription"));
|
set.setMetaKeyword(map.get("MetaKeyword") == null ? "": (String)map.get("MetaKeyword"));
|
set.setName(map.get("Name") == null ? "": (String)map.get("Name"));
|
set.setOwner(map.get("Owner") == null ? "": (String)map.get("Owner"));
|
set.setAddress(map.get("Address") == null ? "": (String)map.get("Address"));
|
set.setGeoCode(map.get("GeoCode") == null ? "": (String)map.get("GeoCode"));
|
set.setLongitude(map.get("Longitude") == null ? "": (String)map.get("Longitude"));
|
set.setLatitude(map.get("Latitude") == null ? "": (String)map.get("Latitude"));
|
set.setEmail(map.get("Email") == null ? "": (String)map.get("Email"));
|
set.setTelephone(map.get("Telephone") == null ? "": (String)map.get("Telephone"));
|
set.setFax(map.get("Fax") == null ? "": (String)map.get("Fax"));
|
set.setImage(map.get("Image") == null ? "": (String)map.get("Image"));
|
set.setOpenDate(map.get("OpenDate") == null ? "": (String)map.get("OpenDate"));
|
set.setComment(map.get("Comment") == null ? "": (String)map.get("Comment"));
|
|
set.setCurrency(map.get("Currency") == null ? "": (String)map.get("Currency"));
|
set.setCurrencyAuto(map.get("CurrencyAuto") == null || (Integer)map.get("CurrencyAuto") == 0 ? false: true);
|
set.setLengthClassId(map.get("LengthClassId") == null ? "": (String)map.get("LengthClassId"));
|
set.setWeightClassId(map.get("WeightClassId") == null ? "": (String)map.get("WeightClassId"));
|
set.setLangId(map.get("LangId") == null ? null: (Integer)map.get("LangId"));
|
set.setShowMatCode(map.get("isShowMatCode") == null||((Integer)map.get("isShowMatCode")).equals(0)?false:true );
|
set.setShowMatName(map.get("isShowMatName") == null||((Integer)map.get("isShowMatName")).equals(0)?false:true );
|
set.setShowSpecial(map.get("isShowSpecial") == null||((Integer)map.get("isShowSpecial")).equals(0)?false:true );
|
set.setShowPoints(map.get("isShowPoints") == null||((Integer)map.get("isShowPoints")).equals(0)?false:true );
|
|
set.setProductCount(map.get("ProductCount") == null ||(Integer)map.get("ProductCount") == 0 ? false : true);;
|
set.setProductLimit(map.get("ProductLimit") == null ? 15: (Integer)map.get("ProductLimit"));
|
set.setProductDescriptionLength(map.get("ProductDescriptionLength") == null ? null: (Integer)map.get("ProductDescriptionLength"));
|
set.setReviewStatus(map.get("ReviewStatus") == null || (Integer)map.get("ReviewStatus") == 0 ? false:true );
|
set.setReviewGuest(map.get("ReviewGuest") == null || (Integer)map.get("ReviewGuest") == 0? false : true);
|
set.setReviewMail(map.get("ReviewMail") == null || (Integer)map.get("ReviewMail") == 0? false : true);
|
set.setShowSalesCharts(map.get("isShowSalesCharts") == null || (Integer)map.get("isShowSalesCharts") == 0? false : true);
|
set.setVoucherMin(map.get("VoucherMin") == null ? null : (Integer)map.get("ReviewGuest"));
|
set.setVoucherMax(map.get("VoucherMax") == null ? null : (Integer)map.get("VoucherMax"));
|
set.setTax(map.get("Tax") == null || (Integer)map.get("Tax") == 0? false : true);
|
set.setTaxDefault(map.get("TaxDefault") == null ? "" : (String)map.get("TaxDefault"));
|
set.setTaxCustomer(map.get("TaxCustomer") == null ? "" : (String)map.get("TaxCustomer"));
|
set.setAccountId(map.get("AccountId") == null ? "" : (String)map.get("AccountId"));
|
set.setCartWeight(map.get("CartWeight") == null || (Integer)map.get("CartWeight") == 0 ? false : true);
|
set.setCheckoutId(map.get("CheckoutId") == null ? "" : (String)map.get("CheckoutId"));
|
set.setOrderStatusId(map.get("OrderStatusId") == null ? "" : (String)map.get("OrderStatusId"));
|
set.setStockDisplay(map.get("StockDisplay") == null || (Integer)map.get("StockDisplay") == 0 ? false : true);
|
set.setStockWarning(map.get("StockWarning") == null || (Integer)map.get("StockWarning") == 0 ? false : true);
|
set.setStockCheckout(map.get("StockCheckout") == null || (Integer)map.get("StockCheckout") == 0 ? false : true);
|
|
set.setLogo(map.get("Logo") == null ? "" : (String)map.get("Logo") );
|
set.setIcon(map.get("Icon") == null ? "" : (String)map.get("Icon") );
|
set.setImageBrandWidth(map.get("ImageBrandWidth") == null ? 0 : (Integer)map.get("ImageBrandWidth"));
|
set.setImageBrandHeight(map.get("ImageBrandHeight") == null ? 0 : (Integer)map.get("ImageBrandHeight"));
|
set.setShowBrandOrgImage(map.get("isShowBrandOrgImage") == null || (Integer)map.get("isShowBrandOrgImage") == 0 ? false : true);
|
|
set.setImageLogoWidth(map.get("ImageLogoWidth") == null ? 0 : (Integer)map.get("ImageLogoWidth"));
|
set.setImageLogoHeight(map.get("ImageLogoHeight") == null ? 0 : (Integer)map.get("ImageLogoHeight"));
|
set.setShowLogoOrgImage(map.get("isShowLogoOrgImage") == null || (Integer)map.get("isShowLogoOrgImage") == 0 ? false : true);
|
|
set.setImageCategoryWidth(map.get("ImageCategoryWidth") == null ? 0 : (Integer)map.get("ImageCategoryWidth"));
|
set.setImageCategoryHeight(map.get("ImageCategoryHeight") == null ? 0 : (Integer)map.get("ImageCategoryHeight"));
|
set.setShowCategoryOrgImage(map.get("isShowCategoryOrgImage") == null || (Integer)map.get("isShowCategoryOrgImage") == 0 ? false : true);
|
|
set.setImageThumbWidth(map.get("ImageThumbWidth") == null ? 0 : (Integer)map.get("ImageThumbWidth"));
|
set.setImageThumbHeight(map.get("ImageThumbHeight") == null ? 0 : (Integer)map.get("ImageThumbHeight"));
|
set.setShowThumbOrgImage(map.get("isShowThumbOrgImage") == null || (Integer)map.get("isShowThumbOrgImage") == 0 ? false : true);
|
|
set.setImagePopupWidth(map.get("ImagePopupWidth") == null ? 0 : (Integer)map.get("ImagePopupWidth"));
|
set.setImagePopupHeight(map.get("ImagePopupHeight") == null ? 0 : (Integer)map.get("ImagePopupHeight"));
|
set.setShowPopupOrgImage(map.get("isShowPopupOrgImage") == null || (Integer)map.get("isShowPopupOrgImage") == 0 ? false : true);
|
|
set.setImageProductWidth(map.get("ImageProductWidth") == null ? 0 : (Integer)map.get("ImageProductWidth"));
|
set.setImageProductHeight(map.get("ImageProductHeight") == null ? 0 : (Integer)map.get("ImageProductHeight"));
|
set.setShowProductOrgImage(map.get("isShowProductOrgImage") == null || (Integer)map.get("isShowProductOrgImage") == 0 ? false : true);
|
|
set.setImageAdditionalWidth(map.get("ImageAdditionalWidth") == null ? 0 : (Integer)map.get("ImageAdditionalWidth"));
|
set.setImageAdditionalHeight(map.get("ImageAdditionalHeight") == null ? 0 : (Integer)map.get("ImageAdditionalHeight"));
|
set.setShowAdditionalOrgImage(map.get("isShowAdditionalOrgImage") == null || (Integer)map.get("isShowAdditionalOrgImage") == 0 ? false : true);
|
|
set.setImageRelatedWidth(map.get("ImageRelatedWidth") == null ? 0 : (Integer)map.get("ImageRelatedWidth"));
|
set.setImageRelatedHeight(map.get("ImageRelatedHeight") == null ? 0 : (Integer)map.get("ImageRelatedHeight"));
|
set.setShowRelatedOrgImage(map.get("isShowRelatedOrgImage") == null || (Integer)map.get("isShowRelatedOrgImage") == 0 ? false : true);
|
|
set.setImageCompareWidth(map.get("ImageCompareWidth") == null ? 0 : (Integer)map.get("ImageCompareWidth"));
|
set.setImageCompareHeight(map.get("ImageCompareHeight") == null ? 0 : (Integer)map.get("ImageCompareHeight"));
|
set.setShowCompareOrgImage(map.get("isShowCompareOrgImage") == null || (Integer)map.get("isShowCompareOrgImage") == 0 ? false : true);
|
|
set.setImageWishlistWidth(map.get("ImageWishlistWidth") == null ? 0 : (Integer)map.get("ImageWishlistWidth"));
|
set.setImageWishlistHeight(map.get("ImageWishlistHeight") == null ? 0 : (Integer)map.get("ImageWishlistHeight"));
|
set.setShowWishlistOrgImage(map.get("isShowWishlistOrgImage") == null || (Integer)map.get("isShowWishlistOrgImage") == 0 ? false : true);
|
|
set.setImageCartWidth(map.get("ImageCartWidth") == null ? 0 : (Integer)map.get("ImageCartWidth"));
|
set.setImageCartHeight(map.get("ImageCartHeight") == null ? 0 : (Integer)map.get("ImageCartHeight"));
|
set.setShowCartOrgImage(map.get("isShowCartOrgImage") == null || (Integer)map.get("isShowCartOrgImage") == 0 ? false : true);
|
|
set.setImageLocationWidth(map.get("ImageLocationWidth") == null ? 0 : (Integer)map.get("ImageLocationWidth"));
|
set.setImageLocationHeight(map.get("ImageLocationHeight") == null ? 0 : (Integer)map.get("ImageLocationHeight"));
|
set.setShowLocationOrgImage(map.get("isShowLocationOrgImage") == null || (Integer)map.get("isShowLocationOrgImage") == 0 ? false : true);
|
|
set.setImageBannerWidth(map.get("ImageBannerWidth") == null ? 0 : (Integer)map.get("ImageBannerWidth"));
|
set.setImageBannerHeight(map.get("ImageBannerHeight") == null ? 0 : (Integer)map.get("ImageBannerHeight"));
|
set.setShowBannerOrgImage(map.get("isShowBannerOrgImage") == null || (Integer)map.get("isShowBannerOrgImage") == 0 ? false : true);
|
|
set.setImageManufacturerWidth(map.get("ImageManufacturerWidth") == null ? 0 : (Integer)map.get("ImageManufacturerWidth"));
|
set.setImageManufacturerHeight(map.get("ImageManufacturerHeight") == null ? 0 : (Integer)map.get("ImageManufacturerHeight"));
|
set.setShowManufacturerOrgImage(map.get("isShowManufacturerOrgImage") == null || (Integer)map.get("isShowManufacturerOrgImage") == 0 ? false : true);
|
|
set.setMaintenance(map.get("Maintenance") == null || (Integer)map.get("Maintenance") == 0 ? false : true);
|
set.setCouponStatus(map.get("CouponStatus") == null || (Integer)map.get("CouponStatus") == 0 ? false : true);
|
set.setCouponSortOrder(map.get("CouponSortOrder") == null ? null : (Integer)map.get("CouponSortOrder"));
|
set.setHandlingStatus(map.get("HandlingStatus") == null || (Integer)map.get("HandlingStatus") == 0 ? false : true);
|
set.setHandlingTotal(map.get("HandlingTotal") == null ? null : Double.parseDouble(map.get("HandlingTotal").toString()));
|
set.setHandlingFee(map.get("HandlingFee") == null ? null: Double.parseDouble( map.get("HandlingFee").toString()));
|
set.setHandlingSortOrder(map.get("HandlingSortOrder") == null ? null : (Integer)map.get("HandlingSortOrder"));
|
set.setLowOrderFeeStatus(map.get("LowOrderFeeStatus") == null || (Integer)map.get("LowOrderFeeStatus") == 0 ? false : true);
|
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.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);
|
set.setShippingSortOrder(map.get("ShippingSortOrder") == null ? null :(Integer)map.get("ShippingSortOrder"));
|
set.setVoucherStatus(map.get("VoucherStatus") == null || (Integer)map.get("VoucherStatus") == 0 ? false : true);
|
set.setVoucherSortOrder(map.get("VoucherSortOrder") == null ? null :(Integer)map.get("VoucherSortOrder"));
|
|
set.setShowPrice(map.get("isShowPrice") == null||((Integer)map.get("isShowPrice")).equals(0) ? false :true);
|
set.setSyncWxCpUser(map.get("isSyncWxCpUser") == null||((Integer)map.get("isSyncWxCpUser")).equals(0) ? false :true);
|
set.setCcCode(map.get("cccode") == null ? null :(String)map.get("cccode"));
|
set.setWxCpQRCode(map.get("WxCpQRCode") == null ? null :(String)map.get("WxCpQRCode"));
|
set.setWxMpQRCode(map.get("WxMpQRCode") == null ? null :(String)map.get("WxMpQRCode"));
|
set.setCssCaptionHeight(map.get("cssCaptionHeight") == null?null: (Integer)map.get("cssCaptionHeight"));
|
|
set.setShowDistributor(map.get("isShowDistributor") == null||((Integer)map.get("isShowDistributor")).equals(0) ? false :true);
|
set.setDiscardDistributor(map.get("isDiscardDistributor") == null||((Integer)map.get("isDiscardDistributor")).equals(0) ? false :true);
|
set.setPreSendDays(map.get("PreSendDays") == null?0:(Integer)map.get("PreSendDays"));
|
|
|
set.setCountryId(map.get("CountryId") == null ? null: (Integer)map.get("CountryId"));
|
set.setShowCountryId(map.get("isShowCountryId") == null||((Integer)map.get("isShowCountryId")).equals(0) ? false :true);
|
set.setRequiredCountryId(map.get("isRequiredCountryId") == null||((Integer)map.get("isRequiredCountryId")).equals(0) ? false :true);
|
set.setProvinceZoneId(map.get("ProvinceZoneId") == null ? 0: (Integer)map.get("ProvinceZoneId"));
|
set.setShowProvinceZoneId(map.get("isShowProvinceZoneId") == null||((Integer)map.get("isShowProvinceZoneId")).equals(0) ? false :true);
|
set.setRequiredProvinceZoneId(map.get("isRequiredProvinceZoneId") == null||((Integer)map.get("isRequiredProvinceZoneId")).equals(0) ? false :true);
|
set.setCityZoneId(map.get("CityZoneId") == null ? 0: (Integer)map.get("CityZoneId"));
|
set.setShowCityZoneId(map.get("isShowCityZoneId") == null||((Integer)map.get("isShowCityZoneId")).equals(0) ? false :true);
|
set.setRequiredCityZoneId(map.get("isRequiredCityZoneId") == null||((Integer)map.get("isRequiredCityZoneId")).equals(0) ? false :true);
|
set.setCountyZoneId(map.get("CountyZoneId") == null ? 0: (Integer)map.get("CountyZoneId"));
|
set.setShowCountyZoneId(map.get("isShowCountyZoneId") == null||((Integer)map.get("isShowCountyZoneId")).equals(0) ? false :true);
|
set.setRequiredCountyZoneId(map.get("isRequiredCountyZoneId") == null||((Integer)map.get("isRequiredCountyZoneId")).equals(0) ? false :true);
|
set.setCltType(map.get("CltType") == null ? "": (String)map.get("CltType"));
|
set.setShowCltType(map.get("isShowCltType") == null||((Integer)map.get("isShowCltType")).equals(0) ? false :true);
|
set.setRequiredCltType(map.get("isRequiredCltType") == null||((Integer)map.get("isRequiredCltType")).equals(0) ? false :true);
|
set.setReferralsType(map.get("ReferralsType") == null ? "": (String)map.get("ReferralsType"));
|
set.setShowReferralsCode(map.get("isShowReferralsCode") == null||((Integer)map.get("isShowReferralsCode")).equals(0) ? false :true);
|
set.setRequiredReferralsCode(map.get("isRequiredReferralsCode") == null||((Integer)map.get("isRequiredReferralsCode")).equals(0) ? false :true);
|
set.setDefaultMemberLevel(map.get("DefaultMemberLevel") == null ? "": (String)map.get("DefaultMemberLevel"));
|
set.setShowTel(map.get("isShowTel") == null||((Integer)map.get("isShowTel")).equals(0) ? false :true);
|
set.setRequiredTel(map.get("isRequiredTel") == null||((Integer)map.get("isRequiredTel")).equals(0) ? false :true);
|
set.setShowFax(map.get("isShowFax") == null||((Integer)map.get("isShowFax")).equals(0) ? false :true);
|
set.setRequiredFax(map.get("isRequiredFax") == null||((Integer)map.get("isRequiredFax")).equals(0) ? false :true);
|
set.setShowEmail(map.get("isShowEmail") == null||((Integer)map.get("isShowEmail")).equals(0) ? false :true);
|
set.setRequiredEmail(map.get("isRequiredEmail") == null||((Integer)map.get("isRequiredEmail")).equals(0) ? false :true);
|
set.setShowSourceInfo(map.get("isShowSourceInfo") == null||((Integer)map.get("isShowSourceInfo")).equals(0) ? false :true);
|
set.setRequiredSourceInfo(map.get("isRequiredSourceInfo") == null||((Integer)map.get("isRequiredSourceInfo")).equals(0) ? false :true);
|
set.setShowPassword(map.get("isShowPassword") == null||((Integer)map.get("isShowPassword")).equals(0) ? false :true);
|
set.setRequiredPassword(map.get("isRequiredPassword") == null||((Integer)map.get("isRequiredPassword")).equals(0) ? false :true);
|
set.setShowOrganization(map.get("isShowOrganization") == null||((Integer)map.get("isShowOrganization")).equals(0) ? false :true);
|
set.setRequiredOrganization(map.get("isRequiredOrganization") == null||((Integer)map.get("isRequiredOrganization")).equals(0) ? false :true);
|
set.setShowAddress(map.get("isShowAddress") == null||((Integer)map.get("isShowAddress")).equals(0) ? false :true);
|
set.setRequiredAddress(map.get("isRequiredAddress") == null||((Integer)map.get("isRequiredAddress")).equals(0) ? false :true);
|
set.setShowPropertyId(map.get("isShowPropertyId") == null||((Integer)map.get("isShowPropertyId")).equals(0) ? false :true);
|
set.setRequiredPropertyId(map.get("isRequiredPropertyId") == null||((Integer)map.get("isRequiredPropertyId")).equals(0) ? false :true);
|
|
set.setShowPostcode(map.get("isShowPostcode") == null||((Integer)map.get("isShowPostcode")).equals(0) ? false :true);
|
set.setRequiredPostcode(map.get("isRequiredPostcode") == null||((Integer)map.get("isRequiredPostcode")).equals(0) ? false :true);
|
|
set.setShowImageAdditional(map.get("isShowImageAdditional") == null||((Integer)map.get("isShowImageAdditional")).equals(0)?false:true );
|
set.setFromCached(map.get("isFromCached") == null||((Integer)map.get("isFromCached")).equals(0)?false:true );
|
|
set.setModifyProfile(map.get("isModifyProfile") == null||((Integer)map.get("isModifyProfile")).equals(0)?false:true );
|
set.setModifyPassword(map.get("isModifyPassword") == null||((Integer)map.get("isModifyPassword")).equals(0)?false:true );
|
set.setModifyAddress(map.get("isModifyAddress") == null||((Integer)map.get("isModifyAddress")).equals(0)?false:true );
|
set.setModifyDistributor(map.get("isModifyDistributor") == null||((Integer)map.get("isModifyDistributor")).equals(0)?false:true );
|
set.setModifyWishList(map.get("isModifyWishList") == null||((Integer)map.get("isModifyWishList")).equals(0)?false:true );
|
set.setModifyOrder(map.get("isModifyOrder") == null||((Integer)map.get("isModifyOrder")).equals(0)?false:true );
|
set.setModifyReward(map.get("isModifyReward") == null||((Integer)map.get("isModifyReward")).equals(0)?false:true );
|
set.setShowBalance(map.get("isShowBalance") == null||((Integer)map.get("isShowBalance")).equals(0)?false:true );
|
set.setShowMyWallet(map.get("isShowMyWallet") == null||((Integer)map.get("isShowMyWallet")).equals(0)?false:true );
|
set.setModifyContact(map.get("isModifyContact") == null||((Integer)map.get("isModifyContact")).equals(0)?false:true );
|
set.setModifyReturn(map.get("isModifyReturn") == null||((Integer)map.get("isModifyReturn")).equals(0)?false:true );
|
set.setModifyAttention(map.get("isModifyAttention") == null||((Integer)map.get("isModifyAttention")).equals(0)?false:true );
|
set.setModifyBrand(map.get("isModifyBrand") == null||((Integer)map.get("isModifyBrand")).equals(0)?false:true );
|
set.setModifyVoucher(map.get("isModifyVoucher") == null||((Integer)map.get("isModifyVoucher")).equals(0)?false:true );
|
set.setModifySpecialoffer(map.get("isModifySpecialoffer") == null||((Integer)map.get("isModifySpecialoffer")).equals(0)?false:true );
|
set.setModifyWxUser(map.get("isModifyWxUser") == null||((Integer)map.get("isModifyWxUser")).equals(0)?false:true );
|
set.setShowMyCustomer(map.get("isShowMyCustomer") == null||((Integer)map.get("isShowMyCustomer")).equals(0)?false:true );
|
|
set.setWxPayAcctCode(map.get("WxPayAcctCode") == null ? "": (String)map.get("WxPayAcctCode"));
|
set.setShowDescription(map.get("isShowDescription") == null||((Integer)map.get("isShowDescription")).equals(0)?false:true );
|
set.setProductListStyle(map.get("ProductListStyle") == null ? 0 : (Integer)map.get("ProductListStyle"));
|
set.setProductDetailStyle(map.get("ProductDetailStyle") == null ? 0 : (Integer)map.get("ProductDetailStyle"));
|
set.setCategoryListStyle(map.get("CategoryListStyle") == null ? 0 : (Integer)map.get("CategoryListStyle"));
|
set.setMyPageStyle(map.get("MyPageStyle") == null ? 0 : (Integer)map.get("MyPageStyle"));
|
set.setShowDistributorAddress(map.get("isShowDistributorAddress") == null||((Integer)map.get("isShowDistributorAddress")).equals(0) ? false :true);
|
set.setShowCompare(map.get("isShowCompare") == null||((Integer)map.get("isShowCompare")).equals(0) ? false :true);
|
set.setCouponsBuyReminderTemplateId(map.get("CouponsBuyReminderTemplateId") == null ? "": (String)map.get("CouponsBuyReminderTemplateId"));
|
set.setStartingPointForRedemption(map.get("StartingPointForRedemption") == null ? 0 : Double.parseDouble(map.get("StartingPointForRedemption").toString()));
|
set.setShowBuyButtonOnHomePage(map.get("isShowBuyButtonOnHomePage") == null||((Integer)map.get("isShowBuyButtonOnHomePage")).equals(0) ? false :true);
|
set.setShowRatingOnHomePage(map.get("isShowRatingOnHomePage") == null||((Integer)map.get("isShowRatingOnHomePage")).equals(0) ? false :true);
|
set.setDefaultShopCcCode(map.get("DefaultShopCcCode") == null ? "": (String)map.get("DefaultShopCcCode"));
|
set.setDefaultShopCcName(map.get("DefaultShopCcName") == null ? "": (String)map.get("DefaultShopCcName"));
|
set.setWithdrawAmount(map.get("WithdrawAmount") == null ? 0L : Double.parseDouble(map.get("WithdrawAmount").toString()));
|
set.setWithdrawTimes(map.get("WithdrawTimes") == null ? 0L : Double.parseDouble(map.get("WithdrawTimes").toString()));
|
set.setWithdrawTaxRate(map.get("WithdrawTaxRate") == null ? 0L : Double.parseDouble(map.get("WithdrawTaxRate").toString()));
|
set.setSharedPoints(map.get("SharedPoints") == null ? 0L : Double.parseDouble(map.get("SharedPoints").toString()));
|
set.setAllowWithdraw(map.get("isAllowWithdraw") == null||((Integer)map.get("isAllowWithdraw")).equals(0) ? false :true);
|
set.setAllowRecharge(map.get("isAllowRecharge") == null||((Integer)map.get("isAllowRecharge")).equals(0) ? false :true);
|
set.setWithdrawType(map.get("WithdrawType") == null ? "" : (String) map.get("WithdrawType") );
|
set.setShowCategory(map.get("isShowCategory") == null||((Integer)map.get("isShowCategory")).equals(0) ? false :true);
|
set.setShowNaviByCcCode(map.get("isShowNaviByCcCode") == null||((Integer)map.get("isShowNaviByCcCode")).equals(0) ? false :true);
|
set.setShowMatGroupInHomePage(map.get("isShowMatGroupInHomePage") == null||((Integer)map.get("isShowMatGroupInHomePage")).equals(0) ? false :true);
|
set.setHomePageBackgroundColor(map.get("HomePageBackgroundColor") == null ? "": (String)map.get("HomePageBackgroundColor"));
|
set.setSubscriptionReminderTemplateId(map.get("SubscriptionReminderTemplateId") == null ? "": (String)map.get("SubscriptionReminderTemplateId"));
|
set.setSubscriptionNotificationTemplateId(map.get("SubscriptionNotificationTemplateId") == null ? "": (String)map.get("SubscriptionNotificationTemplateId"));
|
|
set.setStartupMatName2(map.get("isStartupMatName2") == null||((Integer)map.get("isStartupMatName2")).equals(0) ? false :true);
|
set.setMatName2Label(map.get("MatName2Label") == null ? "": (String)map.get("MatName2Label"));
|
set.setStartupMatName3(map.get("isStartupMatName3") == null||((Integer)map.get("isStartupMatName3")).equals(0) ? false :true);
|
set.setMatName3Label(map.get("MatName3Label") == null ? "": (String)map.get("MatName3Label"));
|
set.setStartupMatName4(map.get("isStartupMatName4") == null||((Integer)map.get("isStartupMatName4")).equals(0) ? false :true);
|
set.setMatName4Label(map.get("MatName4Label") == null ? "": (String)map.get("MatName4Label"));
|
set.setShowBrand(map.get("isShowBrand") == null||((Integer)map.get("isShowBrand")).equals(0) ? false :true);
|
|
set.setCountryName(map.get("CountryName") == null ? "": (String)map.get("CountryName"));
|
set.setCityName(map.get("CityName") == null ? "": (String)map.get("CityName"));
|
set.setCountyName(map.get("CountyName") == null ? "": (String)map.get("CountyName"));
|
set.setHomeLayoutStyle(map.get("HomeLayoutStyle") == null ? "": (String)map.get("HomeLayoutStyle"));
|
set.setCosmoHomePageImage(map.get("CosmoHomePageImage") == null ? "": (String)map.get("CosmoHomePageImage"));
|
set.setNormalSearchKey(map.get("NormalSearchKey") == null ? "": (String)map.get("NormalSearchKey"));
|
set.setChooseFloorId(map.get("ChooseFloorId") == null ? "": (String)map.get("ChooseFloorId"));
|
set.setPullTelephoneWhenViewProductDetail(map.get("isPullTelephoneWhenViewProductDetail") == null||((Integer)map.get("isPullTelephoneWhenViewProductDetail")).equals(0) ? false :true);
|
set.setReceiverForSalesOrder(map.get("ReceiverForSalesOrder") == null ? "": (String)map.get("ReceiverForSalesOrder"));
|
set.setReceiverTemplateForSalesOrder(map.get("ReceiverTemplateForSalesOrder") == null ? "": (String)map.get("ReceiverTemplateForSalesOrder"));
|
set.setGenerateOrderProcess(map.get("GenerateOrderProcess") == null ? 0 : (Integer)map.get("GenerateOrderProcess"));
|
set.setShoppingGroupName(map.get("ShoppingGroupName") == null ? "" : (String)map.get("ShoppingGroupName"));
|
//set.setSalesOrderNoticeTemplateId(map.get("SalesOrderNoticeTemplateId") == null ? "" : (String)map.get("SalesOrderNoticeTemplateId"));
|
set.setCouponsBuyReminderTemplateIdForMiniApp(map.get("CouponsBuyReminderTemplateIdForMiniApp") == null ? "" : (String)map.get("CouponsBuyReminderTemplateIdForMiniApp"));
|
set.setMiniProgramState(map.get("MiniProgramState") == null ? "" : (String)map.get("MiniProgramState"));
|
set.setRemindBeforeExpiration(map.get("RemindBeforeExpiration") == null ? 0 : (Integer)map.get("RemindBeforeExpiration"));
|
set.setAiMessageDefaultTemplateId(map.get("AIMessageDefaultTemplateId") == null ? "" : (String)map.get("AIMessageDefaultTemplateId"));
|
set.setAllowReturnOrder(map.get("isAllowReturnOrder") == null ||((Integer)map.get("isAllowReturnOrder")).equals(0) ?false:true);
|
set.setStartupLeagueShopCcCode(map.get("isStartupLeagueShopCcCode") == null ||((Integer)map.get("isStartupLeagueShopCcCode")).equals(0) ?false:true);
|
set.setCardStyle(map.get("CardStyle") == null ?0:((Integer)map.get("CardStyle")) );
|
set.setDefaultSourceInfo(map.get("DefaultSourceInfo") == null ?"":((String)map.get("DefaultSourceInfo")) );
|
set.setHometownGreetingsImage(map.get("HometownGreetingsImage") == null ?"":((String)map.get("HometownGreetingsImage")) );
|
set.setSchoolmateGreetingsImage(map.get("SchoolmateGreetingsImage") == null ?"":((String)map.get("SchoolmateGreetingsImage")) );
|
set.setParallelNumberForInnerMenuOnHomePage(map.get("ParallelNumberForInnerMenuOnHomePage") == null ?0:((Integer)map.get("ParallelNumberForInnerMenuOnHomePage")) );
|
set.setShowPoster(map.get("isShowPoster") == null ||((Integer)map.get("isShowPoster")).equals(0) ?false:true);
|
set.setAllowSelectDeliveryMethod(map.get("isAllowSelectDeliveryMethod") == null ||((Integer)map.get("isAllowSelectDeliveryMethod")).equals(0) ?false:true);
|
set.setDeliveryMethod(map.get("DeliveryMethod") == null ?"":((String)map.get("DeliveryMethod")) );
|
|
set.setShowLiveBannerPhotoOnHomePage(map.get("isShowLiveBannerPhotoOnHomePage") == null ||((Integer)map.get("isShowLiveBannerPhotoOnHomePage")).equals(0) ?false:true);
|
set.setLiveBannerPhoto(map.get("LiveBannerPhoto") == null ?"":((String)map.get("LiveBannerPhoto")) );
|
set.setShowBannerPhotoOnHomePageForLiveUser(map.get("isShowBannerPhotoOnHomePageForLiveUser") == null ||((Integer)map.get("isShowBannerPhotoOnHomePageForLiveUser")).equals(0) ?false:true);
|
set.setStartupPriceSubsystem(map.get("isStartupPriceSubsystem") == null ||((Integer)map.get("isStartupPriceSubsystem")).equals(0) ?false:true);
|
set.setPriceSubsystemMemberLevels(map.get("PriceSubsystemMemberLevels") == null ?"":((String)map.get("PriceSubsystemMemberLevels")) );
|
set.setIsStartupBalancePay(map.get("isStartupBalancePay") == null ?0:((Integer)map.get("isStartupBalancePay")) );
|
set.setShowBuyingButton(map.get("isShowBuyingButton") != null &&map.get("isShowBuyingButton").equals(1)?true:false );
|
set.setShowElectronicVoucherButton(map.get("isShowElectronicVoucherButton") != null &&map.get("isShowElectronicVoucherButton").equals(1)?true:false );
|
set.setPersonalAuthenticationAmount(map.get("PersonalAuthenticationAmount") == null ? 0L : Double.parseDouble(map.get("PersonalAuthenticationAmount").toString()));
|
set.setPaymentCountdown(map.get("PaymentCountdown") == null ? 0: (Integer)map.get("PaymentCountdown"));
|
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"
|
+ " select UseFormId,PendingReviewTemplateId ,PayableTemplateId ,TemplateId ,ShippedTemplateId, \n"
|
+ " ReturnsNoticeTemplateId,CancelOrderNoticeTemplateId \n"
|
+ " from t710166H where UseFormId in (120230,120234,120236,151702) and isnull(Status,0) = 1 \n" ;
|
List<Map<String,Object>> list = this.jdbcTemplate.queryForList(sql) ;
|
for (int i =0 ; list != null && i < list.size() ; i ++) {
|
SettingEntity.OrderNoticeTemplateId orderNoticeTemplateId = set.new OrderNoticeTemplateId() ;
|
orderNoticeTemplateId.setFormId(list.get(i).get("UseFormId") == null ? null : (Integer)list.get(i).get("UseFormId"));
|
orderNoticeTemplateId.setPendingReviewTemplateId(list.get(i).get("PendingReviewTemplateId") == null ? "" : (String)list.get(i).get("PendingReviewTemplateId"));
|
orderNoticeTemplateId.setPayableTemplateId(list.get(i).get("PayableTemplateId") == null ? "" : (String)list.get(i).get("PayableTemplateId"));
|
orderNoticeTemplateId.setTemplateId(list.get(i).get("TemplateId") == null ? "" : (String)list.get(i).get("TemplateId"));
|
orderNoticeTemplateId.setShippedTemplateId(list.get(i).get("ShippedTemplateId") == null ? "" : (String)list.get(i).get("ShippedTemplateId"));
|
orderNoticeTemplateId.setReturnsNoticeTemplateId(list.get(i).get("ReturnsNoticeTemplateId") == null ? "" : (String)list.get(i).get("ReturnsNoticeTemplateId"));
|
orderNoticeTemplateId.setCancelOrderNoticeTemplateId(list.get(i).get("CancelOrderNoticeTemplateId") == null ? "" : (String)list.get(i).get("CancelOrderNoticeTemplateId"));
|
set.addOrderNoticeTemplateId(orderNoticeTemplateId.getFormId(), orderNoticeTemplateId);
|
}
|
return set;
|
}catch(DataAccessException e ) {
|
if (e instanceof EmptyResultDataAccessException){
|
return null ;
|
}else {
|
e.printStackTrace();
|
throw e;
|
}
|
}catch(Exception e){
|
e.printStackTrace();
|
throw e;
|
}
|
|
}
|
|
|
@Override
|
@SuppressWarnings({ "unchecked", "rawtypes" })
|
public SettingFileEntity getImageFile() {
|
settingFileEntity.setImage(null);
|
String sql = " set nocount on ; \n"
|
+ " declare @Image varchar(50) ,@ImageThumbWidth int, @ImageThumbHeight int ; \n"
|
+ " declare @ImagePopupWidth int,@ImagePopupHeight int ;\n"
|
+ " select @Image = case when isnull(Image,'') <> '' then Image else Logo end , \n"
|
+ " @ImageThumbWidth = ImageThumbWidth, \n"
|
+ " @ImageThumbHeight = ImageThumbHeight, \n"
|
+ " @ImagePopupWidth = ImagePopupWidth, \n"
|
+ " @ImagePopupHeight = ImagePopupHeight \n"
|
+ " from t714001 a \n"
|
+ " if isnull( @Image,'') <> '' \n"
|
+ " begin \n"
|
+ " select OriginalPicture,FileType,@ImageThumbWidth as ImageThumbWidth, @ImageThumbHeight as ImageThumbHeight, \n"
|
+ " @ImagePopupWidth as ImagePopupWidth,@ImagePopupHeight as ImagePopupHeight \n"
|
+ " from _sys_Attachment9 b \n"
|
+ " where b.UNID = convert(uniqueidentifier,@Image) ; \n"
|
+ " end \n"
|
+ " else \n"
|
+ " begin \n"
|
+ " select OriginalPicture,FileType,@ImageThumbWidth as ImageThumbWidth,@ImageThumbHeight as ImageThumbHeight,\n"
|
+ " @ImagePopupWidth as ImagePopupWidth,@ImagePopupHeight as ImagePopupHeight \n"
|
+ " from _sys_Attachment9 b \n"
|
+ " where 1 = 0 ; \n"
|
+ " end \n";
|
try {
|
this.jdbcTemplate.query(sql,new AbstractLobStreamingResultSetExtractor(){
|
protected void handleNoRowFound() throws LobRetrievalFailureException {
|
System.out.println("请在 [维护导购系统设置] [功能号 714001]->商店设置 上传Logo图像,然后再重试此操作!");
|
settingFileEntity.setImage(null);
|
}
|
@Override
|
protected void streamData(ResultSet rs) throws SQLException, IOException, DataAccessException {
|
|
settingFileEntity.setImageThumbHeight(rs.getInt("ImageThumbHeight"));
|
settingFileEntity.setImageThumbWidth(rs.getInt("ImageThumbWidth"));
|
|
settingFileEntity.setImagePopupHeight(rs.getInt("ImagePopupHeight"));
|
settingFileEntity.setImagePopupWidth(rs.getInt("ImagePopupWidth"));
|
|
String fileExName = (rs.getString("FileType") == null?"": rs.getString("FileType")) ;
|
String uuid=UUID.randomUUID().toString().toUpperCase();//生成uuid
|
String folder=System.getProperty("java.io.tmpdir"); //临时目录
|
String newFielName = folder + File.separator + uuid +"."+ fileExName ;
|
|
InputStream is = null ;
|
byte[] bytes = null ;
|
try {
|
is = defaultLobHandler.getBlobAsBinaryStream(rs, "OriginalPicture");
|
bytes = ShoppingImageEntity.InputStreamToByte( is); //取二进制图片
|
|
File file = BlobToFile.writeBytesToFile(bytes, newFielName) ; //将流写入文件
|
if (file != null) {
|
settingFileEntity.setImage(file);
|
}
|
} catch (IOException e) {
|
e.printStackTrace();
|
} finally {
|
bytes = null ;
|
if (is != null) is.close();
|
}
|
}
|
});
|
//map = this.jdbcTemplate.queryForMap(sql) ;
|
|
|
|
return settingFileEntity;
|
}catch(DataAccessException e ) {
|
if (e instanceof EmptyResultDataAccessException){
|
return null ;
|
}else {
|
e.printStackTrace();
|
throw e;
|
}
|
}catch(Exception e){
|
e.printStackTrace();
|
throw e;
|
}
|
|
}
|
|
@Override
|
@SuppressWarnings({ "unchecked", "rawtypes" })
|
public SettingFileEntity getCpUserHeadImageFile(String userCode) {
|
settingFileEntity.setImage(null);
|
String sql = " set nocount on ; \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"
|
+ " select @ImageThumbWidth = ImageThumbWidth, \n"
|
+ " @ImageThumbHeight = ImageThumbHeight \n"
|
+ " from t714001 a \n"
|
|
+ " select OriginalPicture,FileType,@ImageThumbWidth as ImageThumbWidth, "
|
+ " @ImageThumbHeight as ImageThumbHeight \n"
|
+ " from _sys_Attachment9 b \n"
|
+ " where b.UNID = convert(uniqueidentifier,@Image) ; \n";
|
try {
|
this.jdbcTemplate.query(sql,new AbstractLobStreamingResultSetExtractor(){
|
protected void handleNoRowFound() throws LobRetrievalFailureException {
|
System.out.println("未找到微信企业号图像 ,请在功能号 700106同步用户!");
|
settingFileEntity.setImage(null);
|
}
|
@Override
|
protected void streamData(ResultSet rs) throws SQLException, IOException, DataAccessException {
|
|
settingFileEntity.setImageThumbHeight(rs.getInt("ImageThumbHeight"));
|
settingFileEntity.setImageThumbWidth(rs.getInt("ImageThumbWidth"));
|
|
String fileExName = (rs.getString("FileType") == null?"": rs.getString("FileType")) ;
|
String uuid=UUID.randomUUID().toString().toUpperCase();//生成uuid
|
String folder=System.getProperty("java.io.tmpdir"); //临时目录
|
String newFielName = folder + File.separator + uuid +"."+ fileExName ;
|
|
InputStream is = null ;
|
byte[] bytes = null ;
|
try {
|
is = defaultLobHandler.getBlobAsBinaryStream(rs, "OriginalPicture");
|
bytes = ShoppingImageEntity.InputStreamToByte( is); //取二进制图片
|
|
File file = BlobToFile.writeBytesToFile(bytes, newFielName) ; //将流写入文件
|
if (file != null) {
|
settingFileEntity.setImage(file);
|
}
|
} catch (IOException e) {
|
e.printStackTrace();
|
} finally {
|
bytes = null ;
|
if (is != null) is.close();
|
}
|
}
|
});
|
//map = this.jdbcTemplate.queryForMap(sql) ;
|
|
|
|
return settingFileEntity;
|
}catch(DataAccessException e ) {
|
if (e instanceof EmptyResultDataAccessException){
|
return null ;
|
}else {
|
e.printStackTrace();
|
throw e;
|
}
|
}catch(Exception e){
|
e.printStackTrace();
|
throw e;
|
}
|
|
}
|
@Override
|
@SuppressWarnings({ "unchecked", "rawtypes" })
|
public SettingFileEntity getMpUserHeadImageFile(String openId) {
|
settingFileEntity.setImage(null);
|
String sql = " set nocount on ; \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"
|
+ " select @ImageThumbWidth = ImageThumbWidth, \n"
|
+ " @ImageThumbHeight = ImageThumbHeight \n"
|
+ " from t714001 a \n"
|
|
+ " select OriginalPicture,FileType,@ImageThumbWidth as ImageThumbWidth, "
|
+ " @ImageThumbHeight as ImageThumbHeight \n"
|
+ " from _sys_Attachment9 b \n"
|
+ " where b.UNID = convert(uniqueidentifier,@Image) ; \n";
|
try {
|
this.jdbcTemplate.query(sql,new AbstractLobStreamingResultSetExtractor(){
|
protected void handleNoRowFound() throws LobRetrievalFailureException {
|
System.out.println("未找到微信公众号用户图像 ,请在功能号 720104中同步用户!");
|
settingFileEntity.setImage(null);
|
}
|
@Override
|
protected void streamData(ResultSet rs) throws SQLException, IOException, DataAccessException {
|
|
settingFileEntity.setImageThumbHeight(rs.getInt("ImageThumbHeight"));
|
settingFileEntity.setImageThumbWidth(rs.getInt("ImageThumbWidth"));
|
|
String fileExName = (rs.getString("FileType") == null?"": rs.getString("FileType")) ;
|
String uuid=UUID.randomUUID().toString().toUpperCase();//生成uuid
|
String folder=System.getProperty("java.io.tmpdir"); //临时目录
|
String newFielName = folder + File.separator + uuid +"."+ fileExName ;
|
|
InputStream is = null ;
|
byte[] bytes = null ;
|
try {
|
is = defaultLobHandler.getBlobAsBinaryStream(rs, "OriginalPicture");
|
bytes = ShoppingImageEntity.InputStreamToByte( is); //取二进制图片
|
|
File file = BlobToFile.writeBytesToFile(bytes, newFielName) ; //将流写入文件
|
if (file != null) {
|
settingFileEntity.setImage(file);
|
}
|
} catch (IOException e) {
|
e.printStackTrace();
|
} finally {
|
bytes = null ;
|
if (is != null) is.close();
|
}
|
}
|
});
|
//map = this.jdbcTemplate.queryForMap(sql) ;
|
|
|
|
return settingFileEntity;
|
}catch(DataAccessException e ) {
|
if (e instanceof EmptyResultDataAccessException){
|
return null ;
|
}else {
|
e.printStackTrace();
|
throw e;
|
}
|
}catch(Exception e){
|
e.printStackTrace();
|
throw e;
|
}
|
|
}
|
|
@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;
|
}
|
|
|
}
|