Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @Reason1 varchar(1024) = 'Dłużnik nie mieszka pod wskazanym adresem i brak jest możliwości ustalenia aktualnego adresu Jego pobytu bez zaangażowania relatywnie wysokich kosztów'
- declare @Reason2 varchar(1024) = 'Likwidacja, postępowanie restrukturyzacyjne lub upadłość Dłużnika'
- declare @Reason3 varchar(1024) = 'Zgon dłużnika'
- declare @Reason4 varchar(1024) = 'Wierzytelność nie rokuje na spłatę nawet przy podjęciu kolejnych czynności znacznie zwiększających koszty wykonywania zlecenia'
- declare @Reason5 varchar(1024) = 'Zmniejszenie wartości należności głównej wierzytelności do poziomu poniżej 100,00 zł'
- declare @Reason6 varchar(1024) = 'Dłużnik przebywa w zakładzie karnym'
- select distinct
- cdv.ClientCaseNumber as ID_SPRAWY,
- dd.Ident as ID_dłużnika,
- (select top 1 convert(date,docd.DemandDate,120)) as DataWymagalnosci,
- cdv.CurrentCapital as KwotaNG,
- cdv.CurrentInterestsK+cdv.CurrentInterestsU+cdv.CurrentOther+cdv.InterestsUOnImport as KwotaOdsetki,
- cdv.CurrentCapital+cdv.CurrentInterestsK+cdv.CurrentInterestsU+cdv.CurrentOther+cdv.InterestsUOnImport as KwotaKosztow,
- Reason = (
- case
- when cad.ActionStr in ('0701', '0702', '0704', '0709') and cdv.CurrentCapital >= 100 then @Reason1
- when cad.ActionStr in ('0706', '0502', '0504') and cdv.CurrentCapital >= 100 then @Reason2
- when cad.ActionStr in ('0703', '0501') and cdv.CurrentCapital >= 100 then @Reason3
- when (cad.ActionStr in ('0510') or cdv.CaseStatusId = 26) and cdv.CurrentCapital >= 100 then @Reason4
- when cdv.CurrentCapital < 100 then @Reason5
- when cad.ActionStr in ('0708', '0506') and cdv.CurrentCapital >= 100 then @Reason6
- end),
- '' as DodatkoweUwagi,
- 'Dialtone' as Kancelaria
- from
- CaseDetailsView cdv
- join CaseActionHistory cah on cah.CaseDetailId = cdv.CaseDetailsId
- join DebtorDetails dd on dd.CaseDetailsId = cdv.CaseDetailsId
- join DocumentDetails docd on docd.CaseDetailsId = cdv.CaseDetailsId
- join CaseActionDefinition cad on cad.DefinitionId = cah.CaseActionDefinitionId
- where
- cdv.ClientId = 49
- and
- cdv.CaseStatusId not in (2,6)
- and
- (cad.ActionStr in ('0701', '0702', '0704', '0709', '0706', '0502', '0504', '0703', '0501', '0510', '0708', '0506') or cdv.CurrentCapital < 100)
- and
- cah.DateAdded in (
- select
- max(cah.DateAdded)
- from
- CaseDetailsView
- join CaseActionHistory cah on cah.CaseDetailId = cdv.CaseDetailsId
- join CaseActionDefinition cad on cad.DefinitionId = cah.CaseActionDefinitionId
- where
- (cad.ActionStr in ('0701', '0702', '0704', '0709', '0706', '0502', '0504', '0703', '0501', '0510', '0708', '0506')
- or
- cdv.CurrentCapital < 100)
- )
- and
- cdv.ClientCaseNumber in (
- select distinct
- cdv.ClientCaseNumber
- from
- CaseDetailsView cdv
- join DocumentDetails docd on docd.CaseDetailsId = cdv.CaseDetailsId
- where
- docd.DemandDate in (
- select
- min(docd.DemandDate)
- from DocumentDetails docd
- )
- )
- order by
- ID_SPRAWY asc
- -- [///] ('0501', '0701', '0702', '0703', '0704', '0709')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement