[步骤]
[结果]
[期望]
补充内容，完善数据重现步骤
历史记录
- 2024-12-11 20:30:41, 由 马建利 创建。
-
2024-12-12 10:09:39, 由 吴茵杰 解决，方案为 程序BUG 。
修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决日期，旧值为 ""，新值为 "2024-12-12 10:09:10"。
修改了 指派给 ，旧值为 "wuyinjie"，新值为 "majianli"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "wuyinjie"。
-
2024-12-16 21:15:42, 由 马建利 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "majianli"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "majianli"。
修改了 关闭日期，旧值为 ""，新值为 "2024-12-16 21:15:42"。
| 由谁创建 | 马建利 于 2024-12-11 20:30:40 |
|---|---|
| 影响环境 |
测试环境-测试反馈 |
| 由谁解决 | 吴茵杰 于 2024-12-12 10:09:10 |
| 解决版本 | |
| 解决方案 | 程序BUG |
| 由谁关闭 | 马建利 于 2024-12-16 21:15:42 |
| 最后修改 | 马建利 于 2024-12-16 21:15:42 |
| 相关Bug |
|---|
SELECT
ID,
CustomerID,
WareHouseID,
Transport_API_ID,
TransportName,
IsRegistered,
OrderCount,
DeclarationPriceRate,
SortBy,
IsActive,
AddTime,
CASE TransportType
WHEN 0 THEN '空运'
WHEN 1 THEN '海运'
WHEN 2 THEN '陆运'
WHEN 4 THEN '快递'
WHEN 5 THEN '邮政小包'
WHEN 6 THEN '专线小包'
END AS TransportType,
ChuKouYiType,
DefaultSupplierID,
TransportNameEn,
TheWareHouseID,
IsPrintDeclare,
AliExpressTransport,
SVCountry,
WareHouseAddress,
IsPrepayTariff,
DHGgateTransport,
OverseaDeliveryWay,
OverseaDeliveryWayText,
OverseaDeliveryInsure,
IsOverseaHasNum,
IsInptutVolumeWeight,
AliExpressTransportURL,
CarrierName,
WishTransport,
WareHouseIDs,
AmazonCarrier,
AmazonTransport,
TwoSortingExportNum,
IsDeclarationPriceRate,
IsFixedPrice,
FixedDeclarationPrice,
TransitType,
IncomeType,
PMSTransport,
TransportState,
FloatingDeclarationPriceState,
FloatingDeclarationPriceMax,
FloatingDeclarationPriceMin,
UpdateTime,
TransferType,
ApiServiceState,
DeclareRuleID,
PrintType,
InvoiceType,
TransferAttribute,
HasUseNewServer,
PrintSpec,
ApiPrintCode,
Templable,
Tempdeclare,
TempInvoice,
ApiServiceCode,
TrackingNumberValidDays,
AllowPrint,
AllowLogistPrint,
ClearService,
EnableWeightSize,
LengthSize,
WidthSize,
HightSize,
PerimeterSize,
WeightSize,
TemplateLableType,
DeclareLableType,
E_TransportID,
DefaultLableID,
InvoiceLabelID,
IsPrintPickingOrder,
CASE PreferenceType
WHEN 1 THEN '国内直发优选'
WHEN 2 THEN '备货头程优选'
WHEN 3 THEN '直发和备货优选'
END AS PreferenceType,
SettlementSupplierID,
CustomLength,
CustomWidth,
CustomHeight,
CASE OverseaLogisticsType
WHEN 1 THEN '物流方式'
WHEN 2 THEN '自提方式'
END AS OverseaLogisticsType,
IsSpecifyArrivalTime,
DeliverCostWeightLimit,
IsAutoCalcTax,
AutoCalcTaxPercent,
OutStockWaitDays,
TrackNumbersIsNaturalDay,
OutStockIsNaturalDay,
DeliverBoxWeightLimit,
IsGetTransferNumber,
IsSplitLable,
TaxRateDeclareRuleID,
AllowTurnPrint,
CASE TransferTypeExpand
WHEN 1 THEN '海运_普船'
WHEN 2 THEN '陆运_卡航'
WHEN 3 THEN '陆运_铁路'
WHEN 7 THEN '海运_快船'
END AS TransferTypeExpand,
CASE IsTaxIncluded
WHEN 1 THEN '包'
WHEN 0 THEN '否'
END IsTaxIncluded,
StarRocksUpdateTime
FROM rb_transport