Commit02f70b4

committed

Member count report

1 parentfc6706c commit02f70b4Copy full SHA for 02f70b4

File tree

+50

-0

lines changed

+50

-0

lines changed

Lines changed: 5 additions & 0 deletions

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,6 +5,7 @@ import { AuthMiddleware } from "./auth/auth.middleware";`
`5`	`5`	`import{HealthModule}from"./health/health.module";`
`6`	`6`
`7`	`7`	`import{TopgearReportsModule}from"./reports/topgear/topgear-reports.module";`
	`8`	`+import{TopcoderReportsModule}from"./reports/topcoder/topcoder-reports.module";`
`8`	`9`	`import{StatisticsModule}from"./statistics/statistics.module";`
`9`	`10`	`import{SfdcReportsModule}from"./reports/sfdc/sfdc-reports.module";`
`10`	`11`	`import{ChallengesReportsModule}from"./reports/challenges/challenges-reports.module";`
`@@ -14,6 +15,7 @@ import { ChallengesReportsModule } from "./reports/challenges/challenges-reports`
`14`	`15`	`ConfigModule.forRoot({isGlobal:true}),`
`15`	`16`	`DbModule,`
`16`	`17`	`TopgearReportsModule,`
	`18`	`+TopcoderReportsModule,`
`17`	`19`	`StatisticsModule,`
`18`	`20`	`SfdcReportsModule,`
`19`	`21`	`ChallengesReportsModule,`

Lines changed: 15 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,15 @@`
	`1`	`+import{Controller,Get}from"@nestjs/common";`
	`2`	`+import{ApiOperation,ApiTags}from"@nestjs/swagger";`
	`3`	`+import{TopcoderReportsService}from"./topcoder-reports.service";`
	`4`	`+`
	`5`	`+@ApiTags("Topcoder Reports")`
	`6`	`+@Controller("/topcoder")`
	`7`	`+exportclassTopcoderReportsController{`
	`8`	`+constructor(privatereadonlyreports:TopcoderReportsService){}`
	`9`	`+`
	`10`	`+ @Get("/member-count")`
	`11`	`+ @ApiOperation({summary:"Total number of active members"})`
	`12`	`+getMemberCount(){`
	`13`	`+returnthis.reports.getMemberCount();`
	`14`	`+}`
	`15`	`+}`

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,10 @@`
	`1`	`+import{Module}from"@nestjs/common";`
	`2`	`+import{TopcoderReportsController}from"./topcoder-reports.controller";`
	`3`	`+import{TopcoderReportsService}from"./topcoder-reports.service";`
	`4`	`+import{SqlLoaderService}from"../../common/sql-loader.service";`
	`5`	`+`
	`6`	`+@Module({`
	`7`	`+controllers:[TopcoderReportsController],`
	`8`	`+providers:[TopcoderReportsService,SqlLoaderService],`
	`9`	`+})`
	`10`	`+exportclassTopcoderReportsModule{}`

Lines changed: 18 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,18 @@`
	`1`	`+import{Injectable}from"@nestjs/common";`
	`2`	`+import{DbService}from"../../db/db.service";`
	`3`	`+import{SqlLoaderService}from"../../common/sql-loader.service";`
	`4`	`+`
	`5`	`+@Injectable()`
	`6`	`+exportclassTopcoderReportsService{`
	`7`	`+constructor(`
	`8`	`+privatereadonlydb:DbService,`
	`9`	`+privatereadonlysql:SqlLoaderService,`
	`10`	`+){}`
	`11`	`+`
	`12`	`+asyncgetMemberCount(){`
	`13`	`+constquery=this.sql.load("reports/topcoder/member-count.sql");`
	`14`	`+constrows=awaitthis.db.query<{"user.count":string\|number}>(query);`
	`15`	`+constvalue=rows?.[0]?.["user.count"];`
	`16`	`+return{"user.count":Number(value??0)};`
	`17`	`+}`
	`18`	`+}`

Comments

(0)