Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- OrderID = Ordre.IdBaksystem,
- MainOrderID = Ordre.Hovedordre,
- HSOrderID = Ordre.IdOrdre,
- CustomerID = Kunde.IdBaksystem,
- HSCustomerID = Kunde.KundeNr,
- HSChecklistTypeID = Sluttkontrolltype.ID_Sluttkontrolltype,
- HSChecklistID = SluttKtrlreg.ID_SluttktrlReg,
- ChecklistTypeVersion = Sluttkontrolltype.Versjon,
- ChecklistTypeName = Sluttkontrolltype.Navn,
- ChecklistName = SluttKtrlreg.Navn,
- ChecklistComment = SluttKtrlreg.SluttKomm,
- SluttKtrlreg.Ferdig AS Finished,
- EmployeeNo = Ansatte.AnsNavn,
- SignatureDateUser = SluttktrlReg.SignDato,
- SignatureDateCustomer = SluttktrlReg.SignDatoKunde,
- SignatureNameCustomer = SluttktrlReg.SignaturNavnKunde,
- 'PDF' as PDF,
- PrintDate = SluttktrlReg.UtskriftDato,
- DocumentLink = CASE
- WHEN UtskriftOppsett.KopiKatalog <> '' AND SluttKtrlReg.Ferdig = 1
- THEN 'CH_' + CAST(Ordre.IdBaksystem AS VARCHAR) + '_' + CAST(ID_SluttKtrlReg AS VARCHAR) + '.PDF'
- ELSE ''
- END,
- --SluttKtrlreg.*,
- --SluttKtrlreg.FR_ansatt,
- Ansatte.AnsNavn,
- ordre.FR_Avdeling
- FROM Handyman.dbo.SluttKtrlreg
- JOIN Handyman.dbo.Sluttkontrolltype ON Sluttkontrolltype.ID_Sluttkontrolltype = SluttKtrlreg.FR_Sluttkontrolltype
- JOIN Handyman.dbo.Ordre ON Ordre.IdOrdre = SluttKtrlreg.FR_Ordre
- JOIN Handyman.dbo.Kunde ON Kunde.KundeNr = Ordre.KundeNr
- LEFT JOIN Handyman.dbo.DepartmentReportTypeSetting ON DepartmentReportTypeSetting.FR_Avdeling = Ordre.FR_Avdeling
- LEFT JOIN Handyman.dbo.ReportType ON ReportType.ID_ReportType = DepartmentReportTypeSetting.FR_ReportType
- LEFT JOIN Handyman.dbo.UtskriftOppsett ON UtskriftOppsett.FR_DepartmentReportTypeSetting = DepartmentReportTypeSetting.ID_DepartmentReportTypeSetting
- LEFT JOIN Handyman.dbo.Ansatte ON Ansatte.ID_Ansatt = SluttktrlReg.FR_Ansatt
- WHERE ReportType.ID_ReportType = 'CB2AF1C3-373E-450E-9970-E6D636AD90E7' -- checklists
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement