首頁 探索 說明
註冊 登入
dbs289
/
fatimaConsentApi
1
0
複刻 0
Files 問題管理 0 合併請求 0 Wiki
目錄樹: 71996536b8
分支列表 標籤列表
fatimaConsen...
/
CLIP.e-Form.Consent.Dfh.Web
/
Logs
/
eFormServer.iBATIS.log_2016-10-06

eFormServer.iBATIS.log_2016-10-06 15 KB
文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536 
  1. 

  2. [Logging Date Time: 2016-10-06 17:35:49,055] =====================================================================================
    3. 

  3. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '전체' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND rcptuseyn = 'Y'          ORDER BY clincdeptdispseq ASC]
    4. 

  4. 

  5. [Logging Date Time: 2016-10-06 17:35:49,055] =====================================================================================
    6. 

  6. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '전체' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND rcptuseyn = 'Y'          ORDER BY clincdeptdispseq ASC]
    7. 

  7. 

  8. [Logging Date Time: 2016-10-06 17:35:49,192] =====================================================================================
    9. 

  9. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    10. 

  10. 

  11. [Logging Date Time: 2016-10-06 17:35:49,192] =====================================================================================
    12. 

  12. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    13. 

  13. 

  14. [Logging Date Time: 2016-10-06 17:35:49,193] =====================================================================================
    15. 

  15. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    16. 

  16. 

  17. [Logging Date Time: 2016-10-06 17:35:49,193] =====================================================================================
    18. 

  18. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    19. 

  19. 

  20. [Logging Date Time: 2016-10-06 17:36:27,006] =====================================================================================
    21. 

  21. SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]
    22. 

  22. 

  23. [Logging Date Time: 2016-10-06 17:36:27,006] =====================================================================================
    24. 

  24. SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]
    25. 

  25. 

  26. [Logging Date Time: 2016-10-06 17:36:27,007] =====================================================================================
    27. 

  27. SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]
    28. 

  28. 

  29. [Logging Date Time: 2016-10-06 17:36:27,007] =====================================================================================
    30. 

  30. SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]
    31. 

  31. 

  32. [Logging Date Time: 2016-10-06 17:36:27,007] =====================================================================================
    33. 

  33. SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    34. 

  34. 

  35. [Logging Date Time: 2016-10-06 17:36:27,007] =====================================================================================
    36. 

  36. SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    37.