Class SupabaseInspectionStatsRepository

Implements

InspectionStatsRepository

Constructors

constructor

new SupabaseInspectionStatsRepository(
db: PostgresJsDatabase<packages/db/src/schema> & {},
): SupabaseInspectionStatsRepository
Generated
Executes constructor.
Parameters
- db: PostgresJsDatabase<packages/db/src/schema> & {}
  The db value.
Returns SupabaseInspectionStatsRepository
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run constructor.

Behavior: accepts db; returns a value.
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:156

Properties

`Private`db

db: PostgresJsDatabase<packages/db/src/schema> & {}

The db value.

Methods

actionsByStatus

actionsByStatus(
tenantId: string,
filter?: HierarchyFilter,
): Promise<Record<string, number>>
Generated
Executes actionsByStatus.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<Record<string, number>>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run actionsByStatus.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ id: inspectionFindings.id }) .from(inspect.
Implementation of InspectionStatsRepository.actionsByStatus
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:470

averageScore

averageScore(tenantId: string, filter?: HierarchyFilter): Promise<number | null>
Generated
Executes averageScore.
Parameters
- tenantId: string
- Optionalfilter: HierarchyFilter
Returns Promise<number | null>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run averageScore.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ avg: sql<number | null>avg(${inspections.. @param tenantId The tenantIdvalue. @param filter Thefilter` value.
Implementation of InspectionStatsRepository.averageScore
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:201

averageScorePeriod

averageScorePeriod(
    tenantId: string,
    startDate: Date,
    endDate: Date,
    filter?: HierarchyFilter,
): Promise<number | null>
Generated
Executes averageScorePeriod.
Parameters
- tenantId: string
- startDate: Date
- endDate: Date
- Optionalfilter: HierarchyFilter
Returns Promise<number | null>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run averageScorePeriod.

Behavior: Async; accepts tenantId and startDate and endDate and filter; returns a value; invokes this.db .select({ avg: sql<number | null>avg(${inspections.. @param tenantId The tenantIdvalue. @param startDate ThestartDatevalue. @param endDate TheendDatevalue. @param filter Thefilter` value.
Implementation of InspectionStatsRepository.averageScorePeriod
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:797

countActions

countActions(
    tenantId: string,
    filter?: HierarchyFilter,
    overdueGroups?: OverdueGroups,
): Promise<
    { completed: number; overdue: number; pending: number; total: number },
>
Generated
Executes countActions.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
- OptionaloverdueGroups: OverdueGroups
  The overdueGroups value.
Returns Promise<{ completed: number; overdue: number; pending: number; total: number }>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countActions.

Behavior: Async; accepts tenantId and filter and overdueGroups; returns a value; invokes overdueExprActions.
Implementation of InspectionStatsRepository.countActions
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:256

countActionsPeriod

countActionsPeriod(
    tenantId: string,
    startDate: Date,
    endDate: Date,
    filter?: HierarchyFilter,
    overdueGroups?: OverdueGroups,
): Promise<{ completed: number; overdue: number; total: number }>
Generated
Executes countActionsPeriod.
Parameters
- tenantId: string
  The tenantId value.
- startDate: Date
  The startDate value.
- endDate: Date
  The endDate value.
- Optionalfilter: HierarchyFilter
  The filter value.
- OptionaloverdueGroups: OverdueGroups
  The overdueGroups value.
Returns Promise<{ completed: number; overdue: number; total: number }>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countActionsPeriod.

Behavior: Async; accepts tenantId and startDate and endDate and filter and overdueGroups; returns a value; invokes overdueExprActions.
Implementation of InspectionStatsRepository.countActionsPeriod
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:750

countAssets

countAssets(tenantId: string, filter?: HierarchyFilter): Promise<number>
Generated
Executes countAssets.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<number>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countAssets.

Behavior: Async; accepts tenantId and filter; returns a value; invokes eq.
Implementation of InspectionStatsRepository.countAssets
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:341

countEffectiveness

countEffectiveness(
    tenantId: string,
    filter?: HierarchyFilter,
): Promise<
    {
        effective: number;
        ineffective: number;
        partiallyEffective: number;
        pendingActions: number;
        totalVerifications: number;
    },
>
Generated
Executes countEffectiveness.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<
    {
        effective: number;
        ineffective: number;
        partiallyEffective: number;
        pendingActions: number;
        totalVerifications: number;
    },
>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countEffectiveness.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ id: inspectionFindings.id }) .from(inspect.
Implementation of InspectionStatsRepository.countEffectiveness
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:927

countEfficacyPeriod

countEfficacyPeriod(
    tenantId: string,
    startDate: Date,
    endDate: Date,
    filter?: HierarchyFilter,
): Promise<
    {
        avgTreatmentDays: number;
        effective: number;
        totalActions: number;
        verified: number;
    },
>
Generated
Executes countEfficacyPeriod.
Parameters
- tenantId: string
  The tenantId value.
- startDate: Date
  The startDate value.
- endDate: Date
  The endDate value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<
    {
        avgTreatmentDays: number;
        effective: number;
        totalActions: number;
        verified: number;
    },
>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countEfficacyPeriod.

Behavior: Async; accepts tenantId and startDate and endDate and filter; returns a value; invokes eq.
Implementation of InspectionStatsRepository.countEfficacyPeriod
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:826

countEscalatedFindings

countEscalatedFindings(
tenantId: string,
filter?: HierarchyFilter,
): Promise<number>
Generated
Executes countEscalatedFindings.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<number>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countEscalatedFindings.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ count: sql<number>count(*) }) .from(insp.
Implementation of InspectionStatsRepository.countEscalatedFindings
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:590

countFindings

countFindings(
    tenantId: string,
    filter?: HierarchyFilter,
    overdueGroups?: OverdueGroups,
): Promise<
    { critical: number; open: number; overdue: number; total: number },
>
Generated
Executes countFindings.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
- OptionaloverdueGroups: OverdueGroups
  The overdueGroups value.
Returns Promise<{ critical: number; open: number; overdue: number; total: number }>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countFindings.

Behavior: Async; accepts tenantId and filter and overdueGroups; returns a value; invokes overdueExprFindings.
Implementation of InspectionStatsRepository.countFindings
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:223

countFindingsPeriod

countFindingsPeriod(
    tenantId: string,
    startDate: Date,
    endDate: Date,
    filter?: HierarchyFilter,
    overdueGroups?: OverdueGroups,
): Promise<
    { critical: number; open: number; overdue: number; total: number },
>
Generated
Executes countFindingsPeriod.
Parameters
- tenantId: string
  The tenantId value.
- startDate: Date
  The startDate value.
- endDate: Date
  The endDate value.
- Optionalfilter: HierarchyFilter
  The filter value.
- OptionaloverdueGroups: OverdueGroups
  The overdueGroups value.
Returns Promise<{ critical: number; open: number; overdue: number; total: number }>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countFindingsPeriod.

Behavior: Async; accepts tenantId and startDate and endDate and filter and overdueGroups; returns a value; invokes overdueExprFindings.
Implementation of InspectionStatsRepository.countFindingsPeriod
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:710

countInspections

countInspections(
    tenantId: string,
    filter?: HierarchyFilter,
): Promise<
    {
        completed: number;
        inProgress: number;
        scheduled: number;
        total: number;
    },
>
Generated
Executes countInspections.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<
    {
        completed: number;
        inProgress: number;
        scheduled: number;
        total: number;
    },
>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countInspections.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ total: sql<number>count(*), completed: s.
Implementation of InspectionStatsRepository.countInspections
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:170

countInspectionsFull

countInspectionsFull(
    tenantId: string,
    filter?: HierarchyFilter,
): Promise<
    {
        cancelled: number;
        completed: number;
        inProgress: number;
        scheduled: number;
        total: number;
        underReview: number;
    },
>
Generated
Executes countInspectionsFull.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<
    {
        cancelled: number;
        completed: number;
        inProgress: number;
        scheduled: number;
        total: number;
        underReview: number;
    },
>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countInspectionsFull.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ total: sql<number>count(*), completed: s.
Implementation of InspectionStatsRepository.countInspectionsFull
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:892

countInspectionsPeriod

countInspectionsPeriod(
    tenantId: string,
    startDate: Date,
    endDate: Date,
    filter?: HierarchyFilter,
): Promise<{ completed: number; total: number }>
Generated
Executes countInspectionsPeriod.
Parameters
- tenantId: string
  The tenantId value.
- startDate: Date
  The startDate value.
- endDate: Date
  The endDate value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<{ completed: number; total: number }>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countInspectionsPeriod.

Behavior: Async; accepts tenantId and startDate and endDate and filter; returns a value; invokes this.db .select({ total: sql<number>count(*), completed: s.
Implementation of InspectionStatsRepository.countInspectionsPeriod
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:678

countPgrLinkage

countPgrLinkage(
tenantId: string,
filter?: HierarchyFilter,
): Promise<{ linked: number; total: number; unlinked: number }>
Generated
Executes countPgrLinkage.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<{ linked: number; total: number; unlinked: number }>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countPgrLinkage.

Behavior: Async; accepts tenantId and filter; returns a value; invokes eq.
Implementation of InspectionStatsRepository.countPgrLinkage
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:1069

countPrograms

countPrograms(tenantId: string): Promise<{ active: number; total: number }>
Generated
Executes countPrograms.
Parameters
- tenantId: string
  The tenantId value.
Returns Promise<{ active: number; total: number }>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countPrograms.

Behavior: Async; accepts tenantId; returns a value; invokes this.db .select({ total: sql<number>count(*), active: sql<.
Implementation of InspectionStatsRepository.countPrograms
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:317

countRiskEvolution

countRiskEvolution(
    tenantId: string,
    filter?: HierarchyFilter,
): Promise<
    {
        increased: number;
        notComparable: number;
        pendingPostControl: number;
        reduced: number;
        totalAssessed: number;
        unchanged: number;
    },
>
Generated
Executes countRiskEvolution.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<
    {
        increased: number;
        notComparable: number;
        pendingPostControl: number;
        reduced: number;
        totalAssessed: number;
        unchanged: number;
    },
>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countRiskEvolution.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db.execute.
Implementation of InspectionStatsRepository.countRiskEvolution
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:1004

countTemplates

countTemplates(tenantId: string): Promise<{ published: number; total: number }>
Generated
Executes countTemplates.
Parameters
- tenantId: string
  The tenantId value.
Returns Promise<{ published: number; total: number }>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run countTemplates.

Behavior: Async; accepts tenantId; returns a value; invokes this.db .select({ total: sql<number>count(*), published: s.
Implementation of InspectionStatsRepository.countTemplates
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:368

findingsByClassification7020

findingsByClassification7020(
tenantId: string,
filter?: HierarchyFilter,
): Promise<Record<string, number>>
Generated
Executes findingsByClassification7020.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<Record<string, number>>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run findingsByClassification7020.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ classification: inspectionFindings.classif.
Implementation of InspectionStatsRepository.findingsByClassification7020
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:564

findingsByCriticality

findingsByCriticality(
tenantId: string,
filter?: HierarchyFilter,
): Promise<Record<string, number>>
Generated
Executes findingsByCriticality.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<Record<string, number>>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run findingsByCriticality.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ criticality: inspectionFindings.criticalit.
Implementation of InspectionStatsRepository.findingsByCriticality
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:392

findingsByStatus

findingsByStatus(
tenantId: string,
filter?: HierarchyFilter,
): Promise<Record<string, number>>
Generated
Executes findingsByStatus.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<Record<string, number>>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run findingsByStatus.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ status: inspectionFindings.status, count: .
Implementation of InspectionStatsRepository.findingsByStatus
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:444

findingsByType

findingsByType(
tenantId: string,
filter?: HierarchyFilter,
): Promise<Record<string, number>>
Generated
Executes findingsByType.
Parameters
- tenantId: string
  The tenantId value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<Record<string, number>>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run findingsByType.

Behavior: Async; accepts tenantId and filter; returns a value; invokes this.db .select({ findingType: inspectionFindings.findingTyp.
Implementation of InspectionStatsRepository.findingsByType
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:418

inspectionsByMonth

inspectionsByMonth(
    tenantId: string,
    months: number,
    filter?: HierarchyFilter,
): Promise<{ avgScore: number | null; count: number; month: string }[]>
Generated
Executes inspectionsByMonth.
Parameters
- tenantId: string
  The tenantId value.
- months: number
  The months value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<{ avgScore: number | null; count: number; month: string }[]>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run inspectionsByMonth.

Behavior: Async; accepts tenantId and months and filter; returns a value; invokes cutoff.setMonth.
Implementation of InspectionStatsRepository.inspectionsByMonth
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:521

recurrenceAnalysis

recurrenceAnalysis(
    tenantId: string,
    limit?: number,
    filter?: HierarchyFilter,
): Promise<RecurrenceAnalysis[]>
Generated
Executes recurrenceAnalysis.
Parameters
- tenantId: string
  The tenantId value.
- limit: number = 10
  The limit value.
- Optionalfilter: HierarchyFilter
  The filter value.
Returns Promise<RecurrenceAnalysis[]>
The function result.

Remarks
Objective: In module packages/db/src/repositories/inspection-stats.repository.ts, run recurrenceAnalysis.

Behavior: Async; accepts tenantId and limit and filter; returns a value; invokes this.db .select({ entityId: inspectionFindings.assetId, find.
Implementation of InspectionStatsRepository.recurrenceAnalysis
- Defined in packages/db/src/repositories/inspection-stats.repository.ts:616

Class SupabaseInspectionStatsRepository

Implements

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns SupabaseInspectionStatsRepository

Remarks

Properties

Privatedb

Methods

actionsByStatus

Parameters

Returns Promise<Record<string, number>>

Remarks

averageScore

Parameters

Returns Promise<number | null>

Remarks

averageScorePeriod

Parameters

Returns Promise<number | null>

Remarks

countActions

Parameters

Returns Promise<{ completed: number; overdue: number; pending: number; total: number }>

Remarks

countActionsPeriod

Parameters

Returns Promise<{ completed: number; overdue: number; total: number }>

Remarks

countAssets

Parameters

Returns Promise<number>

Remarks

countEffectiveness

Parameters

Returns Promise< { effective: number; ineffective: number; partiallyEffective: number; pendingActions: number; totalVerifications: number; },>

Remarks

countEfficacyPeriod

Parameters

Returns Promise< { avgTreatmentDays: number; effective: number; totalActions: number; verified: number; },>

Remarks

countEscalatedFindings

Parameters

Returns Promise<number>

Remarks

countFindings

Parameters

Returns Promise<{ critical: number; open: number; overdue: number; total: number }>

Remarks

countFindingsPeriod

Parameters

Returns Promise<{ critical: number; open: number; overdue: number; total: number }>

Remarks

countInspections

Parameters

Returns Promise< { completed: number; inProgress: number; scheduled: number; total: number; },>

Remarks

countInspectionsFull

Parameters

Returns Promise< { cancelled: number; completed: number; inProgress: number; scheduled: number; total: number; underReview: number; },>

Remarks

countInspectionsPeriod

Parameters

Returns Promise<{ completed: number; total: number }>

Remarks

countPgrLinkage

Parameters

Returns Promise<{ linked: number; total: number; unlinked: number }>

Remarks

countPrograms

Parameters

Returns Promise<{ active: number; total: number }>

Remarks

countRiskEvolution

Parameters

`Private`db

Returns Promise<
{
effective: number;
ineffective: number;
partiallyEffective: number;
pendingActions: number;
totalVerifications: number;
},
>

Returns Promise<
{
avgTreatmentDays: number;
effective: number;
totalActions: number;
verified: number;
},
>

Returns Promise<
{
completed: number;
inProgress: number;
scheduled: number;
total: number;
},
>

Returns Promise<
{
cancelled: number;
completed: number;
inProgress: number;
scheduled: number;
total: number;
underReview: number;
},
>

Returns Promise<
{
increased: number;
notComparable: number;
pendingPostControl: number;
reduced: number;
totalAssessed: number;
unchanged: number;
},
>