CREATE PROC [dbo].[SIPARIS_SATIRLARI_DURUM_GUNCELLEME]
(@DURUM VARCHAR(100), @RF INT)
AS
BEGIN
DECLARE @DURUMID INT
DECLARE @FISID INT
DECLARE @KONTROL INT
SET @DURUMID = ISNULL((SELECT [REF] FROM [IHR].[dbo].[ORDER_STATUS] WHERE [DURUM]=@DURUM), 0)
UPDATE [IHR].[dbo].[FICHE_LINES] SET [STATUS]=@DURUMID WHERE [REF]=@RF
IF @DURUM = 'TAMAMLANDI' OR @DURUM = 'IPTAL EDILDI'
BEGIN
SET @FISID = ISNULL((SELECT FICHEREF FROM [IHR].[dbo].[FICHE_LINES] WHERE [REF]=@RF),0)
IF @FISID<>0
BEGIN
SET @KONTROL = ISNULL((SELECT COUNT(*) FROM [IHR].[dbo].[FICHE_LINES] WHERE [STATUS]<>1 AND [STATUS]<>2 AND FICHEREF=@FISID),0)
IF @KONTROL = 0
BEGIN
UPDATE [IHR].[dbo].[FICHES] SET [STATUS]=3 WHERE [REF]=@FISID
END
END
END
END