Hangi İtemler Al Sat Bugu Kontrol Query:
1-Kontrol Query
[HIDE]
2-Bug Fix Query
3-Bug 2. Yöntem Fix Query
[/HIDE]
1-Kontrol Query
[HIDE]
Kod:
USE SRO_VT_SHARD
select RefPackageItemCodeName,Cost,SellPrice from _RefPricePolicyOfItem
inner join _RefObjCommon
on Cost < SellPrice and RefPackageItemCodeName= 'PACKAGE_' + CodeName128
where PaymentDevice = 1
Kod:
use SRO_VT_SHARD
update _RefObjCommon set SellPrice=1 where CodeName128 in(select refitemcodename from _RefScrapOfPackageItem
where RefPackageItemCodeName in(select RefPackageItemCodeName from _RefPricePolicyOfItem where PaymentDevice=1 and Cost=1
)) and SellPrice>1
Kod:
USE SRO_VT_SHARD
update _RefPricePolicyOfItem set Cost = SellPrice from _RefPricePolicyOfItem
inner join _RefObjCommon
on Cost < SellPrice and RefPackageItemCodeName= 'PACKAGE_' + CodeName128
where PaymentDevice = 1
