Package org.diabetestechnology.drh.service.http.hub.prime.ux

Class TabularRowsControllerCustom

java.lang.Object

org.diabetestechnology.drh.service.http.hub.prime.ux.TabularRowsControllerCustom

@Controller
public class TabularRowsControllerCustom
extends Object

Constructor Summary

Constructors

Constructor	Description
TabularRowsControllerCustom(UdiSecondaryDbConfig udiPrimeDbConfig, AuditService auditService, org.springframework.cache.CacheManager cacheManager, UserNameService userNameService, PartyService partyService, Presentation presentation)

Method Summary

Modifier and Type	Method	Description
TabularRowsResponse<?>	customAllStudyDashboardTabularRows(TabularRowsRequest payload, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	customPopulationTabularRows(TabularRowsRequest payload, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	customStudyTabularRows(TabularRowsRequest payload, String schemaName, String masterTableNameOrViewName, String notEqColumnName, String notEqColumnValue, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	distinctFileInteractionRows(TabularRowsRequest payload, String schemaName, String columns, String viewName, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	distinctTabularAuditRows(TabularRowsRequest payload, String schemaName, String columns, String masterTableNameOrViewName, String notEqColumnName, String notEqColumnValue, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	distinctTabularFileIntractionRowstRows(TabularRowsRequest payload, String schemaName, String columns, String masterTableNameOrViewName, String notEqColumnName, String notEqColumnValue, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	fetchParticipantData(String studyId, TabularRowsRequest payload, String schemaName, String viewName, String columns, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
Object	filterByStudyDisplayId(String schemaName, String masterTableNameOrViewName, String studyDisplayId)
String	getMethodName()
Object	getSubFileGridData(String schemaName, String viewName, String fileCategory, String studyId)
Object	tabularColumnCustom(String schemaName, String columns, String masterTableNameOrViewName, String columnName, String columnValue)
Object	tabularRowsCustom(String schemaName, String masterTableNameOrViewName, String columnName, String columnValue, String columnName1, String columnValue1)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

TabularRowsControllerCustom

public TabularRowsControllerCustom(UdiSecondaryDbConfig udiPrimeDbConfig,
 AuditService auditService,
 org.springframework.cache.CacheManager cacheManager,
 UserNameService userNameService,
 PartyService partyService,
 Presentation presentation)

Method Details

tabularRowsCustom

@GetMapping({"/api/ux/tabular/jooq/{schemaName}/{masterTableNameOrViewName}/{columnName}/{columnValue}.json","/api/ux/tabular/jooq/{schemaName}/{masterTableNameOrViewName}/{columnName}/{columnValue}/{columnName1}/{columnValue1}.json"})
@ResponseBody
public Object tabularRowsCustom(@PathVariable(required=false)
 String schemaName,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable
 String columnName,
 @PathVariable
 String columnValue,
 @PathVariable
 String columnName1,
 @PathVariable
 String columnValue1)

filterByStudyDisplayId

@GetMapping("/api/ux/tabular/jooq/{schemaName}/{masterTableNameOrViewName}/study_display_id/{studyDisplayId}.json")
@ResponseBody
public Object filterByStudyDisplayId(@PathVariable
 String schemaName,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable
 String studyDisplayId)

distinctTabularAuditRows

@PostMapping(value="/api/ux/tabular/jooq/distinct/audit/{schemaName}/{masterTableNameOrViewName}.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> distinctTabularAuditRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @PathVariable(required=false)
 String schemaName,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable(required=false)
 String notEqColumnName,
 @PathVariable(required=false)
 String notEqColumnValue,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

tabularColumnCustom

@GetMapping("/api/ux/tabular/jooq/column/{schemaName}/{masterTableNameOrViewName}/{columnName}/{columnValue}.json")
@ResponseBody
public Object tabularColumnCustom(@PathVariable(required=false)
 String schemaName,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable
 String columnName,
 @PathVariable
 String columnValue)

customStudyTabularRows

@PostMapping(value="/api/ux/tabular/jooq/study/{masterTableNameOrViewName}.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> customStudyTabularRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @PathVariable(required=false)
 String schemaName,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable(required=false)
 String notEqColumnName,
 @PathVariable(required=false)
 String notEqColumnValue,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

fetchParticipantData

@PostMapping(value="/api/ux/tabular/jooq/participant/{schemaName}/{viewName}.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> fetchParticipantData(@RequestParam(name="studyId")
 String studyId,
 @RequestBody @Nonnull
 TabularRowsRequest payload,
 @PathVariable
 String schemaName,
 @PathVariable
 String viewName,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

getMethodName

@GetMapping("/cache")
@ResponseBody
public String getMethodName()

customPopulationTabularRows

@PostMapping(value="/api/ux/tabular/jooq/study/population/dashboard_all_research_study_view.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> customPopulationTabularRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

customAllStudyDashboardTabularRows

@PostMapping(value="/api/ux/tabular/jooq/research-study/dashboard/custom_dashboard_all_research_study_view.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> customAllStudyDashboardTabularRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

distinctFileInteractionRows

@PostMapping(value="/api/ux/tabular/jooq/distinct/file_interaction/{schemaName}/{viewName}.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> distinctFileInteractionRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @PathVariable
 String schemaName,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @PathVariable
 String viewName,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

distinctTabularFileIntractionRowstRows

@PostMapping(value="/api/ux/tabular/jooq/distinct/db/file/{schemaName}/{masterTableNameOrViewName}.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> distinctTabularFileIntractionRowstRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @PathVariable(required=false)
 String schemaName,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable(required=false)
 String notEqColumnName,
 @PathVariable(required=false)
 String notEqColumnValue,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

getSubFileGridData

@GetMapping("/api/ux/tabular/jooq/{schemaName}/{viewName}/{file_category}/{fileCategory}/study_id/{studyId}.json")
@ResponseBody
public Object getSubFileGridData(@PathVariable
 String schemaName,
 @PathVariable
 String viewName,
 @PathVariable
 String fileCategory,
 @PathVariable
 String studyId)