| | 22 | |
| | 23 | DECLARE @invoiceId INT |
| | 24 | DECLARE @sellDate DATETIME |
| | 25 | DECLARE @currentIssueDate DATETIME |
| | 26 | DECLARE @newIssueDate DATETIME |
| | 27 | DECLARE @adName VARCHAR(20) |
| | 28 | |
| | 29 | SELECT @invoiceId=F.Id_Faktury, |
| | 30 | @sellDate=F.Data_Sprzedazy, |
| | 31 | @currentIssueDate = N.Data_W, |
| | 32 | @newIssueDate=N1.data_w, |
| | 33 | @adName=R.[Id Reklamy] |
| | 34 | FROM dbo.[Uka¿e siê w Nr] U |
| | 35 | INNER JOIN Reklama R ON U.ReklamaId=R.ReklamaId |
| | 36 | INNER JOIN Nr N ON N.Tyt=R.[tytu³] AND N.Nrw=U.[Nr Wydania] |
| | 37 | INNER JOIN Faktury F ON F.id_Faktury=U.idFaktury |
| | 38 | INNER JOIN Nr N1 ON N1.Tyt=R.[tytu³] AND N1.Nrw=@newIssueNumber |
| | 39 | WHERE U.id=@issueId |
| | 40 | |
| | 41 | IF @invoiceId IS NULL GOTO END_PROC |
| | 42 | |
| | 43 | IF (MONTH(@sellDate)=MONTH(GETDATE()) AND YEAR(@sellDate)=YEAR(GETDATE())) |
| | 44 | AND |
| | 45 | ( |
| | 46 | (MONTH(@currentIssueDate)=MONTH(GETDATE()) AND YEAR(@currentIssueDate)=YEAR(GETDATE())) |
| | 47 | OR |
| | 48 | (MONTH(@newIssueDate)=MONTH(GETDATE()) AND YEAR(@newIssueDate)=YEAR(GETDATE())) |
| | 49 | ) |
| | 50 | BEGIN |
| | 51 | |
| | 52 | UPDATE dbo.Faktury |
| | 53 | SET ZmianaEmisji=1 |
| | 54 | WHERE id_faktury=@invoiceId |
| | 55 | |
| | 56 | UPDATE dbo.Faktura_Details |
| | 57 | SET Rok=YEAR(@newIssueDate), Miesiac=MONTH(@newIssueDate), |
| | 58 | Nazwa_Uslugi=@adName + ' | ' + CAST(@newIssueNumber AS VARCHAR), |
| | 59 | Nr_Wydania=@newIssueNumber |
| | 60 | WHERE id_faktury=@invoiceId AND Nr_Wydania=@currentIssueNumer |
| | 61 | |
| | 62 | |
| | 63 | GOTO END_PROC |
| | 64 | END |
| | 65 | |
