myDBR Forums » Installation

PageView Mode

(6 posts) (2 voices)

Tags:

No tags yet.

  1. ajitdixit, Member

    I want to develop a feature that if a view icon of grid record is clicked , the record is presented in pageview mode
    Can I manage this within one node without 'dbr.report' option
    My problem is that I am populating grid from processed temporary table and hence dbr.report option is not feasible

  2. myDBR Team, Key Master

    It should not make any difference if the grid is generated from a temporary table. You can open up a support ticket in support email with sample of your code.

    --
    myDBR Team

  3. ajitdixit, Member

    if object_id('DIXIT_DBR_INHTAT001','P') is not null drop procedure DIXIT_DBR_INHTAT001 go CREATE PROCEDURE [dbo].[DIXIT_DBR_INHTAT001] @OrgID int , @ForDate date, @inLogin varchar(30)

    AS BEGIN Set nocount on SET ANSI_WARNINGS OFF

    DECLARE @allowReport int = 0 SET @allowReport = dbo.DIXIT_DBR_CheckOrgRights (@inLogin , @OrgID ); IF ( @allowReport = 0 ) BEGIN Select 'YOU ARE NOT AUTHORISED TO VIEW THIS REPORT FOR SELECTED ORG. CONTACT IT' RETURN END

    SELECT OrganizationID , Name , @ForDate ForDate FROM LIMS_LIVE.DBO.Organization O (nolock) where OrganizationID = @OrgID

    CREATE TABLE #TATVISITDATE ( SrNo Int NULL , OrgId bigint NOT NULL , PatientVisitID bigINt NOT NULL , VisitNumber varchar(20) NULL , VisitDate date NULL , BarcodeNumber varchar(20) NULL , TCODE varchar(50) NULL , TNAME varchar(355) NULL , ATYPE varchar(10) NULL , VisitStatus varchar(20) NULL , Location varchar(100) NULL , PLTYPE varchar(100) NULL , PLNAME varchar(100) NULL , ReportDateTime datetime NULL , RegistrationDateTime datetime NULL , SampleReceiptDateTime datetime NULL , ResultEntryDateTime datetime NULL , ValidationDateTime datetime NULL , AuthorisationDateTime datetime NULL , PDFDateTime datetime NULL

    , MinutesSampleReceiptToResultEntry int NULL , MinutesResultEntryToValidation int NULL , MinutesValidationToAuth int NULL , MinutesAuthToPDF int NULL , MinutesSampleReceiptToPDF int NULL , IsReportinTATTime varchar(3) NULL , MinutesTATDelay int NULL

    )

    INSERT INTO #TATVISITDATE ( SrNo , OrgId , PatientVisitID , VisitNumber , VisitDate , BarcodeNumber , TCODE , TNAME , ATYPE , VisitStatus , Location , PLTYPE , PLNAME , ReportDateTime , RegistrationDateTime , SampleReceiptDateTime , ResultEntryDateTime , ValidationDateTime , AuthorisationDateTime , PDFDateTime

    , MinutesSampleReceiptToResultEntry , MinutesResultEntryToValidation , MinutesValidationToAuth , MinutesAuthToPDF , MinutesSampleReceiptToPDF , IsReportinTATTime , MinutesTATDelay ) SELECT row_number() OVER (ORDER BY VisitDate) SrNo , OrgId , PatientVisitID , VisitNumber , VisitDate , BarcodeNumber , TCODE , TNAME , ATYPE , VisitStatus , Location , PLTYPE , PLNAME , ReportDateTime , RegistrationDateTime , SampleReceiptDateTime , ResultEntryDateTime , ValidationDateTime , AuthorisationDateTime , PDFDateTime

    , MinutesSampleReceiptToResultEntry , MinutesResultEntryToValidation , MinutesValidationToAuth , MinutesAuthToPDF , MinutesSampleReceiptToPDF , IsReportinTATTime , MinutesTATDelay FROM [dbo].[FN_Get_Org_TAT_VisitDate] (@OrgID , @ForDate , @ForDate) WHERE PLTYPE = 'INHOUSE'

    select 'dbr.tab', 'Summary'; select 'dbr.tab', 'Data-InTime'; select 'dbr.tab', 'Data-Delay'; select 'dbr.tab', 'Sample Inflow';

    DECLARE @Number_Of_Inhouse_Test_Visits DECIMAL(18,0) ; DECLARE @Number_Of_Inhouse_Authorized_Test_Visits DECIMAL(18,0) ; DECLARE @Number_Of_Visits_In_Time_as_per_Report_TAT DECIMAL(18,0) DECLARE @Number_Of_Visits_Delayed_as_Per_Report_TAT DECIMAL(18,0)

    SELECT @Number_Of_Inhouse_Test_Visits = COUNT(DISTINCT VisitNumber) FROM #TATVISITDATE ; SELECT @Number_Of_Inhouse_Authorized_Test_Visits = COUNT(DISTINCT VisitNumber) FROM #TATVISITDATE WHERE VisitStatus = 'Approve' ; SELECT @Number_Of_Visits_Delayed_as_Per_Report_TAT = COUNT(DISTINCT VisitNumber) FROM #TATVISITDATE WHERE IsReportinTATTime = 'NO' AND VisitStatus = 'Approve' SELECT @Number_Of_Visits_In_Time_as_per_Report_TAT = @Number_Of_Inhouse_Authorized_Test_Visits - @Number_Of_Visits_Delayed_as_Per_Report_TAT

    select 'dbr.pageview' ; SELECT @Number_Of_Inhouse_Test_Visits [Number_Of_Inhouse_Test_Visits] , @Number_Of_Inhouse_Authorized_Test_Visits [Number_Of_Inhouse_Authorized_Test_Visits] , @Number_Of_Visits_In_Time_as_per_Report_TAT [Number_Of_Visits_In_Time_as_per_Report_TAT] , @Number_Of_Visits_Delayed_as_Per_Report_TAT [Number_Of_Visits_Delayed_as_Per_Report_TAT] , (@Number_Of_Visits_In_Time_as_per_Report_TAT/@Number_Of_Inhouse_Authorized_Test_Visits) * 100 [% Inhouse Test TAT]

    select 'dbr.tab.next'

    SELECT * , CASE WHEN DATEDIFF(minute, DATEADD(minute, DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15, 0), [SampleReceiptDateTime]) >= 14 THEN DATEADD(minute, (DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15) + 15, 0) ELSE DATEADD(minute, DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15, 0) END SampleReceiptDateTimeSlab FROM #TATVISITDATE WHERE IsReportinTATTime = 'YES'

    select 'dbr.tab.next'

    SELECT * , CASE WHEN DATEDIFF(minute, DATEADD(minute, DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15, 0), [SampleReceiptDateTime]) >= 14 THEN DATEADD(minute, (DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15) + 15, 0) ELSE DATEADD(minute, DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15, 0) END SampleReceiptDateTimeSlab FROM #TATVISITDATE WHERE IsReportinTATTime <> 'YES'

    select 'dbr.tab.next'

    SELECT 'dbr.sum' , 'NoOfTubesReceived' SELECT 'dbr.sum' , 'NoOfTubesProcessedinTATTime' SELECT 'dbr.sum' , 'NoOfTubesNotProcessedinTATTime' SELECT CASE WHEN DATEDIFF(minute, DATEADD(minute, DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15, 0), [SampleReceiptDateTime]) >= 14 THEN DATEADD(minute, (DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15) + 15, 0) ELSE DATEADD(minute, DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15, 0) END SampleReceiptDateTimeSlab , COUNT(Distinct BarcodeNumber) NoOfTubesReceived , count(distinct( case when IsReportinTATTime = 'YES' then BarcodeNumber else NULL end )) NoOfTubesProcessedinTATTime

    , count(distinct( case when IsReportinTATTime <> 'YES' then BarcodeNumber else NULL end )) NoOfTubesNotProcessedinTATTime FROM #TATVISITDATE GROUP BY CASE WHEN DATEDIFF(minute, DATEADD(minute, DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15, 0), [SampleReceiptDateTime]) >= 14 THEN DATEADD(minute, (DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15) + 15, 0) ELSE DATEADD(minute, DATEDIFF(minute, 0, [SampleReceiptDateTime]) / 15 * 15, 0) END ORDER BY 1

    select 'dbr.tab.close' DROP TABLE #TATVISITDATE

    I want a feature that if user clicks any row of table then that row opens as popup in page view mode
    Can you please have some attribute to male this possible

  4. myDBR Team, Key Master

    Why not just use the dbr.report?

    --
    myDBR Team

  5. ajitdixit, Member

    For dbr.report I must have different node with same logic and extra filter of key so that only one record is populated which is shown in pageview mode
    It will have one extra processing cycle
    Can I reuse the record to show in Pageview mode on grid click
    It is like View mode of record of Grid

  6. myDBR Team, Key Master

    The dbr.report is the way to go. You can see if the main report and the detail report can share same code to encapsulate the logic of the data generation.

    --
    myDBR Team


Reply

You must log in to post.