Please enable JavaScript.

Coggle requires JavaScript to display documents.

Beräkning & Betalning (Beräkningsgrupp (Prislista volymbelopp)…

- - - - KJGVAA3BRS
        SELECT FROM KJGVAA3BRS
        WHERE SKOLFORM = 'GY' AND BELOPPSGRUPP = 'FRISTÅENDE-SKOLOR' AND BERAKNINGSTYP='ERS_EXTERN'
        AND '20170210' BETWEEN FROMDAT AND TOMDAT
        AND '20170210' BETWEEN SKOLFROMDAT AND SKOLTOMDAT
        AND '20170210' BETWEEN BEL_FROMDAT AND BEL_TOMDAT
        AND ((FROMDAT_ERS = ' ' AND TOMDAT_ERS = ' ' AND INGEN_ERS = '0')
        OR ('20170210' NOT BETWEEN FROMDAT_ERS AND TOMDAT_ERS AND INGEN_ERS = '1')
        OR ('20170210' BETWEEN FROMDAT_ERS AND TOMDAT_ERS AND INGEN_ERS = '0'))
        AND UTB_ANORDNARE = 'FS' AND SKOLENHET = 'ATLE' AND HEMKOMMUN = '0180'
        select from kjgv0bkd where skolform='gy' and KODTYP='BELOPP_GRUPP'
        select from kjgv0bkd where skolform='gy' and KODTYP='BERÄKNINGSTYP'
  - - - KJGVAA10BRS
        SELECT * FROM KJGVAA10BRS
        WHERE SKOLFORM = 'GY' AND BELOPPSGRUPP = 'IKE-IN-EJKSL' AND BERAKNINGSTYP='IKE-IN-EJKSL'
        AND '20170518' BETWEEN FROMDAT AND TOMDAT
        AND '20170518' BETWEEN SKOLFROMDAT AND SKOLTOMDAT
        AND '20170518' BETWEEN BEL_FROMDAT AND BEL_TOMDAT
        AND ((FROMDAT_ERS = ' ' AND TOMDAT_ERS = ' ' AND INGEN_ERS = '0')
        OR ('20170518' NOT BETWEEN FROMDAT_ERS AND TOMDAT_ERS AND INGEN_ERS = '1')
        OR ('20170518' BETWEEN FROMDAT_ERS AND TOMDAT_ERS AND INGEN_ERS = '0'))
        AND UTB_ANORDNARE = 'K' AND SKOLENHET = 'BER5'
        
        groups.Any() ? resultsIkeInOutsideMunicipality.Where(x => !groups.Contains(x.HomeMunicipalityCode) && !string.IsNullOrEmpty(x.HomeMunicipalityCode)).ToList() : resultsIkeInOutsideMunicipality; //HomeMunicipalityCode
  - - - KJGVAA10BRS
        SELECT BRS., ANO.LEVNR
        FROM KJGVAA3BRS BRS
        JOIN KJGV0KUN KUN ON KUN.AVSER = 'GENERELL' and KUN.KOMMUNKOD <> BRS.HEMKOMMUN
        JOIN KJGV0SKO SKO ON BRS.SKOLENHET = SKO.SKOLENHET AND SKO.KOMMUN = KUN.KOMMUNKOD
        AND BRS.HEMKOMMUN IN (SELECT KOD FROM KJGV0BKD WHERE KODTYP='KOMMUNGRUPP' AND SKOLFORM=BRS.SKOLFORM)
        LEFT OUTER JOIN KJ1V0ANO ANO ON ANO.KOMMUN = BRS.HEMKOMMUN
        AND ANO.BOLAGSFORMID IN (SELECT KOD FROM KJ1P0KOD WHERE KODTYP = 'BOLAGSFORM' AND XTRAINFO = 'KOMMUN')
        groups.Any() ? resultsIkeInInsideMunicipality.Where(x => groups.Contains(x.HomeMunicipalityCode)) : resultsIkeInInsideMunicipality; //HomeMunicipalityCode
  - - - KJGVAA8BRS
        SELECT BRS., ANO.LEVNR
        FROM KJGVAA3BRS_IKEUT BRS
        JOIN KJGV0KUN KUN ON KUN.AVSER = 'GENERELL' and KUN.KOMMUNKOD = BRS.HEMKOMMUN
        JOIN KJGV0SKO SKO ON BRS.SKOLENHET = SKO.SKOLENHET AND SKO.KOMMUN <> KUN.KOMMUNKOD
        AND SKO.KOMMUN IN (SELECT KOD FROM KJGV0BKD WHERE KODTYP='KOMMUNGRUPP' AND SKOLFORM=BRS.SKOLFORM)
        LEFT OUTER JOIN KJ1V0ANO ANO ON ANO.KOMMUN = SKO.KOMMUN
        AND ANO.BOLAGSFORMID IN (SELECT KOD FROM KJ1P0KOD WHERE KODTYP = 'BOLAGSFORM' AND XTRAINFO = 'KOMMUN')
        
        groups.Any() ? resultsIkeUtOutsideMunicipality.Where(x => groups.Contains(x.SchoolMunicipalityCode)) : resultsIkeUtOutsideMunicipality; //SchoolMunicipalityCode
  - - - KJGVAA8BRS (IKE-UT EJKSL)
        return groups.Any() ? resultsIkeUtInsideMunicipality.Where(x => !groups.Contains(x.SchoolMunicipalityCode) && !string.IsNullOrEmpty(x.SchoolMunicipalityCode)) : resultsIkeUtInsideMunicipality; //SchoolMunicipalityCode