Página Principal Explorar Ajuda
Registe-se Iniciar Sessão
dbs289
/
fatimaConsentApi
1
0
Fork 0
Ficheiros Problemas 0 Pull Requests 0 Wiki
Árvore: 71996536b8
Ramos Etiquetas
fatimaConsen...
/
CLIP.e-Form.Consent.Dfh.Web
/
Logs
/
eFormServer.iBATIS.log_2016-10-20

eFormServer.iBATIS.log_2016-10-20 17 KB
Histórico Em bruto

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 
  1. 

  2. [Logging Date Time: 2016-10-20 11:20:03,441] =====================================================================================
    3. 

  3. SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ('UNFINISHED','TEMP','ELECTR_CMP')]
    4. 

  4. 

  5. [Logging Date Time: 2016-10-20 11:20:03,441] =====================================================================================
    6. 

  6. SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ('UNFINISHED','TEMP','ELECTR_CMP')]
    7. 

  7. 

  8. [Logging Date Time: 2016-10-20 11:20:03,544] =====================================================================================
    9. 

  9. SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796]]
    10. 

  10. 

  11. [Logging Date Time: 2016-10-20 11:20:03,544] =====================================================================================
    12. 

  12. SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796]]
    13. 

  13. 

  14. [Logging Date Time: 2016-10-20 11:20:03,544] =====================================================================================
    15. 

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

  16. 

  17. [Logging Date Time: 2016-10-20 11:20:03,544] =====================================================================================
    18. 

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

  19. 

  20. [Logging Date Time: 2016-10-20 13:24:28,711] =====================================================================================
    21. 

  21. SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ('UNFINISHED','TEMP','ELECTR_CMP')]
    22. 

  22. 

  23. [Logging Date Time: 2016-10-20 13:24:28,711] =====================================================================================
    24. 

  24. SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ('UNFINISHED','TEMP','ELECTR_CMP')]
    25. 

  25. 

  26. [Logging Date Time: 2016-10-20 13:24:28,805] =====================================================================================
    27. 

  27. SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796]]
    28. 

  28. 

  29. [Logging Date Time: 2016-10-20 13:24:28,805] =====================================================================================
    30. 

  30. SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796]]
    31. 

  31. 

  32. [Logging Date Time: 2016-10-20 13:24:28,805] =====================================================================================
    33. 

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

  34. 

  35. [Logging Date Time: 2016-10-20 13:24:28,805] =====================================================================================
    36. 

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

  37. 

  38. [Logging Date Time: 2016-10-20 20:58:57,674] =====================================================================================
    39. 

  39. SQL Command - Statement Id: [getErPatList] PreparedStatement : [SELECT inpt.pid                                                                  as pid,                  substr(inpt.indd,1,4) || '/' || substr(inpt.indd,5,2) || '/' || substr(inpt.indd,7,2)   as indd,                  inpt.cretno                                                               as cretno,                  inpt.seqno                                                               as seqno,                  inpt.instcd                                                               as instcd,                  ptbs.hngnm                                                                as hngnm,             inpt.fsexamflag                                                           as fsexamflag,                  inpt.orddeptcd                                                            as orddeptcd,                  inpt.medispclid                                                           as doctorid,             0                                                                         as hd,                  TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000', :param0 , 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000', :param0 , 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                  dept.depthngnm                                                            as deptnm,             dept.deptengabbr                                                          as deptengabbr,                  usrb.usernm                                                               AS doctornm,                  dept1.depthngnm                                                           as erorddeptnm,                  usrb1.usernm                                                              AS ermedispclnm,                  inpt.erorddeptcd                                                          as erorddeptcd,                  inpt.ermedispclid                                                         as ermedispclid,             'N'                                                                       as diagnm,             'N'                                                                       as dschnoti,                inpt.roomcd                                                               as roomcd,             'N'                                                                       as cnst,                  inpt.ordtype                                                              as ordtype,                  (SELECT z.cdnm                   FROM   com.zbcmcode z                   WHERE  inpt.insukind = z.cdid                   AND    z.cdgrupid = 'P0008'                   AND    inpt.indd BETWEEN z.valifromdd AND z.valitodd)                    AS bostyle             FROM pam.pmihinpt inpt                  LEFT OUTER JOIN com.zsumusrb usrb                                 ON inpt.medispclid = usrb.userid                              AND  :param0  >= usrb.userfromdd                              AND  :param0  <= usrb.usertodd                  LEFT OUTER JOIN com.zsdddept dept                                ON inpt.orddeptcd = dept.deptcd                              AND  :param0  >= dept.valifromdd                              AND  :param0  <= dept.valitodd                              AND inpt.instcd = dept.instcd                  LEFT OUTER JOIN com.zsumusrb usrb1                                 ON inpt.ermedispclid = usrb1.userid                              AND  :param0  >= usrb1.userfromdd                              AND  :param0  <= usrb1.usertodd                  LEFT OUTER JOIN com.zsdddept dept1                                ON inpt.erorddeptcd = dept1.deptcd                              AND  :param0  >= dept1.valifromdd                              AND  :param0  <= dept1.valitodd                              AND inpt.instcd = dept1.instcd,                  pam.pmihicdr icdr,                  pam.pmcmptbs ptbs            WHERE inpt.histstat = 'Y'              AND inpt.mskind = 'M'              AND inpt.indd <=  :param0               AND inpt.instcd = '111'              AND icdr.ordtype = 'E'              AND inpt.pid = icdr.pid              AND inpt.indd = icdr.indd              AND inpt.cretno = icdr.cretno              AND inpt.instcd = icdr.instcd              AND inpt.histstat = icdr.histstat              AND  :param0  >= icdr.fromdd              AND  :param0  <= icdr.todd              AND inpt.pid = ptbs.pid              AND inpt.instcd = ptbs.instcd                                 AND inpt.erorddeptcd =  :param1                                 and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = inpt.instcd                               and mst.visit_type = inpt.ordtype                               and mst.pid = inpt.pid             and mst.cretno = inpt.cretno                               and mst.consent_state in ('UNFINISHED')             and mst.use_yn = 'Y')                                              order by inpt.indd desc]
    40. 

  40. 

  41. [Logging Date Time: 2016-10-20 20:58:57,674] =====================================================================================
    42. 

  42. SQL Command - Statement Id: [getErPatList] PreparedStatement : [SELECT inpt.pid                                                                  as pid,                  substr(inpt.indd,1,4) || '/' || substr(inpt.indd,5,2) || '/' || substr(inpt.indd,7,2)   as indd,                  inpt.cretno                                                               as cretno,                  inpt.seqno                                                               as seqno,                  inpt.instcd                                                               as instcd,                  ptbs.hngnm                                                                as hngnm,             inpt.fsexamflag                                                           as fsexamflag,                  inpt.orddeptcd                                                            as orddeptcd,                  inpt.medispclid                                                           as doctorid,             0                                                                         as hd,                  TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000', :param0 , 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000', :param0 , 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                  dept.depthngnm                                                            as deptnm,             dept.deptengabbr                                                          as deptengabbr,                  usrb.usernm                                                               AS doctornm,                  dept1.depthngnm                                                           as erorddeptnm,                  usrb1.usernm                                                              AS ermedispclnm,                  inpt.erorddeptcd                                                          as erorddeptcd,                  inpt.ermedispclid                                                         as ermedispclid,             'N'                                                                       as diagnm,             'N'                                                                       as dschnoti,                inpt.roomcd                                                               as roomcd,             'N'                                                                       as cnst,                  inpt.ordtype                                                              as ordtype,                  (SELECT z.cdnm                   FROM   com.zbcmcode z                   WHERE  inpt.insukind = z.cdid                   AND    z.cdgrupid = 'P0008'                   AND    inpt.indd BETWEEN z.valifromdd AND z.valitodd)                    AS bostyle             FROM pam.pmihinpt inpt                  LEFT OUTER JOIN com.zsumusrb usrb                                 ON inpt.medispclid = usrb.userid                              AND  :param0  >= usrb.userfromdd                              AND  :param0  <= usrb.usertodd                  LEFT OUTER JOIN com.zsdddept dept                                ON inpt.orddeptcd = dept.deptcd                              AND  :param0  >= dept.valifromdd                              AND  :param0  <= dept.valitodd                              AND inpt.instcd = dept.instcd                  LEFT OUTER JOIN com.zsumusrb usrb1                                 ON inpt.ermedispclid = usrb1.userid                              AND  :param0  >= usrb1.userfromdd                              AND  :param0  <= usrb1.usertodd                  LEFT OUTER JOIN com.zsdddept dept1                                ON inpt.erorddeptcd = dept1.deptcd                              AND  :param0  >= dept1.valifromdd                              AND  :param0  <= dept1.valitodd                              AND inpt.instcd = dept1.instcd,                  pam.pmihicdr icdr,                  pam.pmcmptbs ptbs            WHERE inpt.histstat = 'Y'              AND inpt.mskind = 'M'              AND inpt.indd <=  :param0               AND inpt.instcd = '111'              AND icdr.ordtype = 'E'              AND inpt.pid = icdr.pid              AND inpt.indd = icdr.indd              AND inpt.cretno = icdr.cretno              AND inpt.instcd = icdr.instcd              AND inpt.histstat = icdr.histstat              AND  :param0  >= icdr.fromdd              AND  :param0  <= icdr.todd              AND inpt.pid = ptbs.pid              AND inpt.instcd = ptbs.instcd                                 AND inpt.erorddeptcd =  :param1                                 and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = inpt.instcd                               and mst.visit_type = inpt.ordtype                               and mst.pid = inpt.pid             and mst.cretno = inpt.cretno                               and mst.consent_state in ('UNFINISHED')             and mst.use_yn = 'Y')                                              order by inpt.indd desc]
    43. 

  43. 

  44. [Logging Date Time: 2016-10-20 20:58:57,780] =====================================================================================
    45. 

  45. SQL Command - Statement Id: [getErPatList] Parameters: [param0=[srchdd,20161020], param1=[orddeptcd,2280000000]]
    46. 

  46. 

  47. [Logging Date Time: 2016-10-20 20:58:57,780] =====================================================================================
    48. 

  48. SQL Command - Statement Id: [getErPatList] Parameters: [param0=[srchdd,20161020], param1=[orddeptcd,2280000000]]
    49. 

  49. 

  50. [Logging Date Time: 2016-10-20 20:58:57,781] =====================================================================================
    51. 

  51. SQL Command - Statement Id: [getErPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]
    52. 

  52. 

  53. [Logging Date Time: 2016-10-20 20:58:57,781] =====================================================================================
    54. 

  54. SQL Command - Statement Id: [getErPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]
    55.