SPADC62700_NSTEN엑셀데이타관리.xfdl 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPADC62700" position="absolute 0 0 1194 725" titletext="NST - EN 세부엑셀저장" oninit="SPADC62700_oninit" onload="SPADC62700_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption12" text="NST - EN 세부엑셀저장" class="tit_1" position="absolute 0 0 178 25"/>
  8. <Div id="grp_sea" taborder="1" style="align:center top;" class="div_SA" position="absolute 0 25 1193 65" anchor="left top right">
  9. <Layouts>
  10. <Layout>
  11. <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1110 7 1116 35" anchor="top right"/>
  12. <Combo id="combo10" taborder="1" innerdataset="@ds_init_ward" codecolumn="deptcd" datacolumn="deptnm" class="combo_search" position="absolute 604 10 750 31" columncount="2" anchor="default"/>
  13. <Static id="caption5" text="병 동 :" class="search_name" position="absolute 546 13 601 30" anchor="default"/>
  14. <Combo id="combo1" taborder="2" innerdataset="@ds_init_deptlist" codecolumn="deptcd" datacolumn="deptnm" class="combo_search" position="absolute 390 10 534 31" anchor="default"/>
  15. <Button id="btn_sea" taborder="3" text="조회" class="btn1" position="absolute 1125 9 1181 31" anchor="top right" onclick="grp_sea_btn_sea_onclick"/>
  16. <Static id="caption9" text="등록번호 :" class="search_name" position="absolute 762 14 833 31" anchor="default"/>
  17. <Edit id="input1" taborder="4" class="input_search" position="absolute 835 11 924 32" anchor="default" onkeydown="grp_sea_input1_onkeydown" autoselect="true"/>
  18. <Static id="caption10" text="의 뢰 과 :" class="search_name" position="absolute 319 13 387 30" anchor="default"/>
  19. <Static id="caption2" class="search_name" position="absolute 15 13 21 30" anchor="default"/>
  20. <Calendar id="ipt_srchdd1" taborder="5" class="input_search" position="absolute 124 11 211 32" anchor="default" autoselect="true"/>
  21. <Calendar id="ipt_srchdd2" taborder="6" class="input_search" position="absolute 223 11 310 32" anchor="default" autoselect="true"/>
  22. <Static id="caption13" text="~" position="absolute 211 14 226 34" anchor="default"/>
  23. <Static id="caption4" text="의뢰약품:" class="search_name" visible="false" position="absolute 932 14 998 31" anchor="default"/>
  24. <Edit id="input5" taborder="7" class="input_search" visible="false" position="absolute 1001 11 1098 32" anchor="default" onkeydown="grp_sea_input5_onkeydown" autoselect="true"/>
  25. <Combo id="combo2" taborder="8" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_search" position="absolute 26 11 106 32" anchor="default">
  26. <Dataset id="innerdataset">
  27. <ColumnInfo>
  28. <Column id="codecolumn"/>
  29. <Column id="datacolumn"/>
  30. </ColumnInfo>
  31. <Rows>
  32. <Row>
  33. <Col id="codecolumn">R</Col>
  34. <Col id="datacolumn">의뢰일자</Col>
  35. </Row>
  36. <Row>
  37. <Col id="codecolumn">Q</Col>
  38. <Col id="datacolumn">회신일자</Col>
  39. </Row>
  40. </Rows>
  41. </Dataset>
  42. </Combo>
  43. <Static id="caption1" text=":" position="absolute 114 12 129 32" anchor="default"/>
  44. </Layout>
  45. </Layouts>
  46. </Div>
  47. <Grid id="grd_nstmngt" taborder="2" binddataset="ds_grd_nstmngt" useinputpanel="false" position="absolute 0 98 1193 723" anchor="all" extendsizetype="row" cellsizingtype="both">
  48. <Formats>
  49. <Format id="default">
  50. <Columns>
  51. <Column size="25" band="left"/>
  52. <Column size="83"/>
  53. <Column size="109"/>
  54. <Column size="64"/>
  55. <Column size="100"/>
  56. <Column size="87"/>
  57. <Column size="73"/>
  58. <Column size="33"/>
  59. <Column size="34"/>
  60. <Column size="84"/>
  61. <Column size="86"/>
  62. <Column size="81"/>
  63. <Column size="91"/>
  64. <Column size="85"/>
  65. <Column size="90"/>
  66. <Column size="46"/>
  67. <Column size="62"/>
  68. <Column size="135"/>
  69. <Column size="140"/>
  70. <Column size="100"/>
  71. <Column size="100"/>
  72. <Column size="116"/>
  73. <Column size="0"/>
  74. <Column size="100"/>
  75. <Column size="0"/>
  76. <Column size="100"/>
  77. <Column size="66"/>
  78. <Column size="69"/>
  79. <Column size="72"/>
  80. <Column size="83"/>
  81. <Column size="100"/>
  82. <Column size="33"/>
  83. <Column size="37"/>
  84. <Column size="47"/>
  85. <Column size="43"/>
  86. <Column size="43"/>
  87. <Column size="48"/>
  88. <Column size="100"/>
  89. <Column size="100"/>
  90. <Column size="100"/>
  91. <Column size="48"/>
  92. <Column size="44"/>
  93. <Column size="52"/>
  94. <Column size="49"/>
  95. <Column size="46"/>
  96. <Column size="46"/>
  97. <Column size="35"/>
  98. <Column size="38"/>
  99. <Column size="35"/>
  100. <Column size="47"/>
  101. <Column size="46"/>
  102. <Column size="55"/>
  103. <Column size="38"/>
  104. <Column size="42"/>
  105. <Column size="36"/>
  106. <Column size="38"/>
  107. <Column size="81"/>
  108. <Column size="148"/>
  109. <Column size="100"/>
  110. <Column size="100"/>
  111. <Column size="100"/>
  112. <Column size="100"/>
  113. <Column size="100"/>
  114. <Column size="100"/>
  115. <Column size="100"/>
  116. <Column size="100"/>
  117. <Column size="198"/>
  118. <Column size="173"/>
  119. <Column size="0"/>
  120. <Column size="123"/>
  121. </Columns>
  122. <Rows>
  123. <Row size="24" band="head"/>
  124. <Row size="24"/>
  125. </Rows>
  126. <Band id="head">
  127. <Cell/>
  128. <Cell col="1" text="상태"/>
  129. <Cell col="2" text="구분"/>
  130. <Cell col="3" text="병실/외래"/>
  131. <Cell col="4" text="진료과"/>
  132. <Cell col="5" text="등록번호"/>
  133. <Cell col="6" text="환자명"/>
  134. <Cell col="7" text="Sex"/>
  135. <Cell col="8" text="Age"/>
  136. <Cell col="9" text="주치의"/>
  137. <Cell col="10" text="의뢰일"/>
  138. <Cell col="11" text="회신일"/>
  139. <Cell col="12" text="진료/입원일"/>
  140. <Cell col="13" text="퇴원일"/>
  141. <Cell col="14" text="퇴원예고/퇴원"/>
  142. <Cell col="15" text="HD"/>
  143. <Cell col="16" text="POD"/>
  144. <Cell col="17" text="진단명"/>
  145. <Cell col="18" text="수술명"/>
  146. <Cell col="19" text="식사처방정보"/>
  147. <Cell col="20" text="약제정보"/>
  148. <Cell col="21" text="영양관련문제점"/>
  149. <Cell col="22" text="기타-영양관련문제점"/>
  150. <Cell col="23" text="활동정보"/>
  151. <Cell col="24" text="기타-활동정보"/>
  152. <Cell col="25" text="투여경로"/>
  153. <Cell col="26" text="경구영양"/>
  154. <Cell col="27" text="경관영양"/>
  155. <Cell col="28" text="정맥영양"/>
  156. <Cell col="29" text="총섭취열량"/>
  157. <Cell col="30" text="총섭취단백질량"/>
  158. <Cell col="31" text="Ht"/>
  159. <Cell col="32" text="Wt"/>
  160. <Cell col="33" text="UBW"/>
  161. <Cell col="34" text="IBW"/>
  162. <Cell col="35" text="PIBW"/>
  163. <Cell col="36" text="ABW"/>
  164. <Cell col="37" text="Wt change(kg)"/>
  165. <Cell col="38" text="wt change(%)"/>
  166. <Cell col="39" text="wt change(개월)"/>
  167. <Cell col="40" text="alb"/>
  168. <Cell col="41" text="TLC"/>
  169. <Cell col="42" text="Hb"/>
  170. <Cell col="43" text="Hct"/>
  171. <Cell col="44" text="TRF"/>
  172. <Cell col="45" text="RBP"/>
  173. <Cell col="46" text="Na"/>
  174. <Cell col="47" text="K"/>
  175. <Cell col="48" text="CI"/>
  176. <Cell col="49" text="BUN"/>
  177. <Cell col="50" text="Cr"/>
  178. <Cell col="51" text="Chol"/>
  179. <Cell col="52" text="TG"/>
  180. <Cell col="53" text="Ca"/>
  181. <Cell col="54" text="P"/>
  182. <Cell col="55" text="Mg"/>
  183. <Cell col="56" text="N-Balance"/>
  184. <Cell col="57" text="영양상태판정"/>
  185. <Cell col="58" text="기초대사량"/>
  186. <Cell col="59" text="필요열량"/>
  187. <Cell col="60" text="단백질요구량"/>
  188. <Cell col="61" text="주입속도(초기)"/>
  189. <Cell col="62" text="주입속도(목표)"/>
  190. <Cell col="63" text="주입방법"/>
  191. <Cell col="64" text="관의위치"/>
  192. <Cell col="65" text="공급영양액"/>
  193. <Cell col="66" text="영양교육내용"/>
  194. <Cell col="67" text="영양사의견"/>
  195. <Cell col="68" text="basewt"/>
  196. <Cell col="69" text="의뢰번호"/>
  197. </Band>
  198. <Band id="body">
  199. <Cell celltype="head" text="expr:currow+1"/>
  200. <Cell col="1" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:cnststat"/>
  201. <Cell col="2" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:epgubun"/>
  202. <Cell col="3" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:roomcd"/>
  203. <Cell col="4" style="align:left;padding:0 0 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:orddeptnm"/>
  204. <Cell col="5" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:pid"/>
  205. <Cell col="6" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:hngnm"/>
  206. <Cell col="7" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:sex"/>
  207. <Cell col="8" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:age"/>
  208. <Cell col="9" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:orddrnm"/>
  209. <Cell col="10" displaytype="expr:utlf_isNull(reqdd) ? 'normal' :'date'" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:reqdd"/>
  210. <Cell col="11" displaytype="expr:utlf_isNull(repldd) ? 'normal' :'date'" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:repldd"/>
  211. <Cell col="12" displaytype="expr:utlf_isNull(orddd) ? 'normal' :'date'" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:orddd"/>
  212. <Cell col="13" displaytype="expr:utlf_isNull(dschdd) ? 'normal' :'date'" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:dschdd"/>
  213. <Cell col="14" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:dschyn"/>
  214. <Cell col="15" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:hd"/>
  215. <Cell col="16" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:pod"/>
  216. <Cell col="17" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:diagnm" wordwrap="char"/>
  217. <Cell col="18" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:opdnm" wordwrap="char"/>
  218. <Cell col="19" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:dietnm" wordwrap="char"/>
  219. <Cell col="20" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:drugnm" wordwrap="char"/>
  220. <Cell col="21" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:nutrprob" wordwrap="char"/>
  221. <Cell col="22" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:nutrprobetc" wordwrap="char"/>
  222. <Cell col="23" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:actgrde" wordwrap="char"/>
  223. <Cell col="24" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:actgrdeetc" wordwrap="char"/>
  224. <Cell col="25" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:drugpath" wordwrap="char"/>
  225. <Cell col="26" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:etrlfd"/>
  226. <Cell col="27" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:tubfd"/>
  227. <Cell col="28" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:itvnfd"/>
  228. <Cell col="29" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:totintkcalr"/>
  229. <Cell col="30" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:totintkprot"/>
  230. <Cell col="31" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:ht"/>
  231. <Cell col="32" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:wt"/>
  232. <Cell col="33" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:ubw"/>
  233. <Cell col="34" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:ibw"/>
  234. <Cell col="35" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:pibw"/>
  235. <Cell col="36" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:abw"/>
  236. <Cell col="37" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:wtchngkg"/>
  237. <Cell col="38" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:wtchngperc"/>
  238. <Cell col="39" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:wtchngmm"/>
  239. <Cell col="40" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:alb"/>
  240. <Cell col="41" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:tlc"/>
  241. <Cell col="42" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:hb"/>
  242. <Cell col="43" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:hct"/>
  243. <Cell col="44" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:trf"/>
  244. <Cell col="45" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:rbp"/>
  245. <Cell col="46" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:na"/>
  246. <Cell col="47" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:k"/>
  247. <Cell col="48" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:cl"/>
  248. <Cell col="49" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:bun"/>
  249. <Cell col="50" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:cr"/>
  250. <Cell col="51" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:tg"/>
  251. <Cell col="52" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:chol"/>
  252. <Cell col="53" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:ca"/>
  253. <Cell col="54" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:p"/>
  254. <Cell col="55" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:mg"/>
  255. <Cell col="56" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:nbcalval"/>
  256. <Cell col="57" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:nutrjudg"/>
  257. <Cell col="58" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:basembolcalc"/>
  258. <Cell col="59" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:corrcalr" mask="#,###.#"/>
  259. <Cell col="60" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:protcalc" mask="#,###.##"/>
  260. <Cell col="61" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:infsinitspd" mask="#,###.##"/>
  261. <Cell col="62" style="align:right;padding:0 2 0 0;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:infsaftspd"/>
  262. <Cell col="63" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:infsmthd" wordwrap="char"/>
  263. <Cell col="64" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:tubepos" wordwrap="char"/>
  264. <Cell col="65" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:suplnutr" wordwrap="char"/>
  265. <Cell col="66" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:dietedurslt" wordwrap="char"/>
  266. <Cell col="67" style="align:left top;padding:4 2 0 2;background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:dieteroffr" wordwrap="char"/>
  267. <Cell col="68" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:basewt"/>
  268. <Cell col="69" displaytype="text" style="background:EXPR(dschyn=='Y'?'#ffe79d':'');background2:EXPR(dschyn=='Y'?'#ffe79d':'');" text="bind:formrecseq"/>
  269. </Band>
  270. </Format>
  271. </Formats>
  272. </Grid>
  273. <Shape id="line2" class="line_1" position="absolute 0 94 1193 100" anchor="left top right"/>
  274. <Button id="button51" taborder="3" text="엑셀저장" onclick="group3_button51_onclick" class="btn7" position="absolute 1117 71 1193 93" anchor="top right"/>
  275. <Shape id="line00" class="line_1" position="absolute 0 93 1193 99" anchor="left top right"/>
  276. <Shape id="line01" class="line_1" position="absolute 0 92 1193 98" anchor="left top right"/>
  277. </Layout>
  278. </Layouts>
  279. <Objects>
  280. <Dataset id="ds_grd_nstmngt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  281. <ColumnInfo>
  282. <Column id="cnststat" type="STRING"/>
  283. <Column id="epgubun" type="STRING"/>
  284. <Column id="roomcd" type="STRING"/>
  285. <Column id="orddeptnm" type="STRING"/>
  286. <Column id="pid" type="STRING"/>
  287. <Column id="hngnm" type="STRING"/>
  288. <Column id="sex" type="STRING"/>
  289. <Column id="age" type="STRING"/>
  290. <Column id="orddrnm" type="STRING"/>
  291. <Column id="reqdd" type="STRING"/>
  292. <Column id="repldd" type="STRING"/>
  293. <Column id="orddd" type="STRING"/>
  294. <Column id="dschdd" type="STRING"/>
  295. <Column id="dschyn" type="STRING"/>
  296. <Column id="hd" type="STRING"/>
  297. <Column id="pod" type="STRING"/>
  298. <Column id="diagnm" type="STRING"/>
  299. <Column id="opdnm" type="STRING"/>
  300. <Column id="dietnm" type="STRING"/>
  301. <Column id="drugnm" type="STRING"/>
  302. <Column id="nutrprob" type="STRING"/>
  303. <Column id="nutrprobetc" type="STRING"/>
  304. <Column id="actgrde" type="STRING"/>
  305. <Column id="actgrdeetc" type="STRING"/>
  306. <Column id="drugpath" type="STRING"/>
  307. <Column id="etrlfd" type="STRING"/>
  308. <Column id="tubfd" type="STRING"/>
  309. <Column id="itvnfd" type="STRING"/>
  310. <Column id="totintkcalr" type="STRING"/>
  311. <Column id="totintkprot" type="STRING"/>
  312. <Column id="ht" type="STRING"/>
  313. <Column id="wt" type="STRING"/>
  314. <Column id="ubw" type="STRING"/>
  315. <Column id="ibw" type="STRING"/>
  316. <Column id="pibw" type="STRING"/>
  317. <Column id="abw" type="STRING"/>
  318. <Column id="wtchngkg" type="STRING"/>
  319. <Column id="wtchngperc" type="STRING"/>
  320. <Column id="wtchngmm" type="STRING"/>
  321. <Column id="alb" type="STRING"/>
  322. <Column id="tlc" type="STRING"/>
  323. <Column id="hb" type="STRING"/>
  324. <Column id="hct" type="STRING"/>
  325. <Column id="trf" type="STRING"/>
  326. <Column id="rbp" type="STRING"/>
  327. <Column id="na" type="STRING"/>
  328. <Column id="k" type="STRING"/>
  329. <Column id="cl" type="STRING"/>
  330. <Column id="bun" type="STRING"/>
  331. <Column id="cr" type="STRING"/>
  332. <Column id="tg" type="STRING"/>
  333. <Column id="chol" type="STRING"/>
  334. <Column id="ca" type="STRING"/>
  335. <Column id="p" type="STRING"/>
  336. <Column id="mg" type="STRING"/>
  337. <Column id="nbcalval" type="STRING"/>
  338. <Column id="nutrjudg" type="STRING"/>
  339. <Column id="basembolcalc" type="STRING"/>
  340. <Column id="corrcalr" type="STRING"/>
  341. <Column id="protcalc" type="STRING"/>
  342. <Column id="infsinitspd" type="STRING"/>
  343. <Column id="infsaftspd" type="STRING"/>
  344. <Column id="infsmthd" type="STRING"/>
  345. <Column id="tubepos" type="STRING"/>
  346. <Column id="suplnutr" type="STRING"/>
  347. <Column id="dietedurslt" type="STRING"/>
  348. <Column id="dieteroffr" type="STRING"/>
  349. <Column id="basewt" type="STRING"/>
  350. <Column id="formrecseq" type="STRING"/>
  351. </ColumnInfo>
  352. <Rows>
  353. <Row/>
  354. </Rows>
  355. </Dataset>
  356. <Dataset id="ds_init_ward" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  357. <ColumnInfo>
  358. <Column id="deptcd" type="STRING"/>
  359. <Column id="deptnm" type="STRING"/>
  360. </ColumnInfo>
  361. </Dataset>
  362. <Dataset id="ds_init_deptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  363. <ColumnInfo>
  364. <Column id="deptnm" type="STRING"/>
  365. <Column id="deptcd" type="STRING"/>
  366. </ColumnInfo>
  367. </Dataset>
  368. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  369. <ColumnInfo>
  370. <Column id="srchdd1" type="STRING" size="256"/>
  371. <Column id="srchdd2" type="STRING" size="256"/>
  372. <Column id="reqdrugcd" type="STRING" size="256"/>
  373. <Column id="pid" type="STRING" size="256"/>
  374. <Column id="orddeptcd" type="STRING" size="256"/>
  375. <Column id="wardcd" type="STRING" size="256"/>
  376. <Column id="deptflag" type="STRING" size="256"/>
  377. <Column id="dateflag" type="STRING" size="256"/>
  378. </ColumnInfo>
  379. <Rows>
  380. <Row>
  381. <Col id="srchdd1"/>
  382. <Col id="srchdd2"/>
  383. <Col id="reqdrugcd"/>
  384. <Col id="pid"/>
  385. <Col id="orddeptcd"/>
  386. <Col id="wardcd"/>
  387. <Col id="deptflag"/>
  388. <Col id="dateflag">R</Col>
  389. </Row>
  390. </Rows>
  391. </Dataset>
  392. <Dataset id="ds_deptinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  393. <ColumnInfo>
  394. <Column id="deptflag" type="STRING" size="256"/>
  395. </ColumnInfo>
  396. <Rows>
  397. <Row/>
  398. </Rows>
  399. </Dataset>
  400. </Objects>
  401. <Bind>
  402. <BindItem id="item0" compid="grp_sea.combo2" propid="value" datasetid="ds_send" columnid="dateflag"/>
  403. <BindItem id="item1" compid="grp_sea.ipt_srchdd1" propid="value" datasetid="ds_send" columnid="srchdd1"/>
  404. <BindItem id="item2" compid="grp_sea.ipt_srchdd2" propid="value" datasetid="ds_send" columnid="srchdd2"/>
  405. <BindItem id="item3" compid="grp_sea.combo1" propid="value" datasetid="ds_send" columnid="orddeptcd"/>
  406. <BindItem id="item4" compid="grp_sea.combo10" propid="value" datasetid="ds_send" columnid="wardcd"/>
  407. <BindItem id="item5" compid="grp_sea.input1" propid="value" datasetid="ds_send" columnid="pid"/>
  408. <BindItem id="item6" compid="grp_sea.input5" propid="value" datasetid="ds_send" columnid="reqdrugcd"/>
  409. </Bind>
  410. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  411. * System Name :
  412. * Job Name :
  413. * Creator :
  414. * Make Date : 2015-11-13
  415. * Description :
  416. *---------------------------------------------------------------------------------------
  417. * Modify Date Modifier Modify Description
  418. *---------------------------------------------------------------------------------------
  419. * 2015-11-13 Live Converter TF->XP
  420. *
  421. *---------------------------------------------------------------------------------------
  422. ****************************************************************************************/
  423. include "com_commonxp::comm_main.xjs";
  424. /******************************************************************
  425. * Argument :
  426. * Description : 초기화
  427. ******************************************************************/
  428. function SPADC62700_oninit(obj:Form, e:InitEventInfo)
  429. {
  430. frmf_initForm(obj);
  431. }
  432. function SPADC62700_onload(obj:Form, e:LoadEventInfo)
  433. {
  434. ds_send.setColumn(0, "srchdd1", utlf_getCurrentDate());
  435. ds_send.setColumn(0, "srchdd2", utlf_getCurrentDate());
  436. var oParam = {};
  437. oParam.id = "TRADC00101";
  438. oParam.service = "pharmacyconsultapp.ReqMngt";
  439. oParam.method = "reqGetDeptList";
  440. oParam.inds = "req=ds_deptinfo";
  441. oParam.outds = "ds_init_deptlist=dept ds_init_ward=ward";
  442. oParam.async = false;
  443. //oParam.callback = "cf_TRADC00101";
  444. tranf_submit(oParam);
  445. dsf_addDsItem(ds_init_deptlist, "deptcd", "deptnm", "", "", "above");
  446. dsf_addDsItem(ds_init_ward, "deptcd", "deptnm", "", "", "above");
  447. var getDeptcd = ds_init_deptlist.getColumn(0, "deptcd");
  448. var getWardcd = ds_init_deptlist.getColumn(0, "deptcd");
  449. if( getDeptcd == "-" ) ds_init_deptlist.setColumn(0, "deptcd", "");
  450. if( getWardcd == "-" ) ds_init_ward.setColumn(0, "deptcd", "");
  451. }
  452. /******************************************************************
  453. * Argument :
  454. * Description : 조회 Button Event
  455. ******************************************************************/
  456. function grp_sea_btn_sea_onclick(obj:Button, e:ClickEventInfo)
  457. {
  458. var getReqdrugcd = "";
  459. getReqdrugcd = ds_send.getColumn(0, "reqdrugcd");
  460. ds_send.setColumn(0, "reqdrugcd", getReqdrugcd); //2008-11-01 의뢰약품 대문자 처리
  461. dsf_setDefaultVal(ds_send, "dateflag:R");
  462. var oParam = {};
  463. oParam.id = "TRADC62701";
  464. oParam.service = "pharmacyconsultapp.TDMMngt";
  465. oParam.method = "reqGetNSTEnExcelDownList";
  466. oParam.inds = "req=ds_send";
  467. oParam.outds = "ds_grd_nstmngt=mainlist";
  468. oParam.async = false;
  469. //oParam.callback = "cf_TRADC62701";
  470. tranf_submit(oParam);
  471. fCnstResn();
  472. //그리드 특정 컬럼값을 비교하여 로우 백컬러 변경
  473. // grdf_setRowStyle(grd_nstmngt, "1", "Y", "dschyn", "equal");
  474. }
  475. //등록번호 조회 Enter
  476. function grp_sea_input1_onkeydown(obj:Edit, e:KeyEventInfo)
  477. {
  478. if( e.keycode == 13 ){
  479. obj.updateToDataset();
  480. grp_sea_btn_sea_onclick();
  481. }
  482. }
  483. //의뢰약품조회 Enter
  484. function grp_sea_input5_onkeydown(obj:Edit, e:KeyEventInfo)
  485. {
  486. if( e.keycode == 13 ){
  487. obj.updateToDataset();
  488. grp_sea_btn_sea_onclick();
  489. }
  490. }
  491. /******************************************************************
  492. * Argument :
  493. * Description : 조회 Button Event
  494. ******************************************************************/
  495. function group3_button51_onclick(obj:Button, e:ClickEventInfo)
  496. {
  497. if( ds_grd_nstmngt.rowcount > 0 ){
  498. grdf_exportExcel(grd_nstmngt, "NST - EN 세부내용", "NST - EN 세부내용", false, "", "user", false);
  499. } else {
  500. sysf_messageBox("조회된 데이터가 ", "I004");
  501. }
  502. }
  503. //코드명으로 나열하기
  504. function fCnstResn() {
  505. var rowcount = ds_grd_nstmngt.rowcount;
  506. for ( var k = 0 ; k < rowcount; k++) {
  507. //영양관련문제점
  508. var nutrprob = utlf_transNullToEmpty(ds_grd_nstmngt.getColumn(k,"nutrprob"));
  509. var nutrprobetc = ds_grd_nstmngt.getColumn(k,"nutrprobetc");
  510. var nutrprob_temp = "";
  511. var nutrprobData = nutrprob.split(" ");
  512. if ( !utlf_isNull(nutrprob) ) {
  513. for(var i = 0; i < nutrprobData.length; i++) {
  514. if (nutrprobData[i] == "1") nutrprob_temp += "메스꺼움";
  515. else if (nutrprobData[i] == "2") nutrprob_temp += "식욕부진";
  516. else if (nutrprobData[i] == "3") nutrprob_temp += "구토";
  517. else if (nutrprobData[i] == "4") nutrprob_temp += "설사";
  518. else if (nutrprobData[i] == "5") nutrprob_temp += "변비";
  519. else if (nutrprobData[i] == "6") nutrprob_temp += "소화불량";
  520. else if (nutrprobData[i] == "7") nutrprob_temp += "고열";
  521. else if (nutrprobData[i] == "8") nutrprob_temp += "욕창";
  522. else if (nutrprobData[i] == "9") nutrprob_temp += "인공호흡기";
  523. else if (nutrprobData[i] == "10") nutrprob_temp += nutrprobetc ;
  524. if ( (i+1) < nutrprobData.length ) nutrprob_temp += ", ";
  525. }
  526. ds_grd_nstmngt.setColumn(k,"nutrprob", nutrprob_temp);
  527. }
  528. //활동정도
  529. var actgrde = utlf_transNullToEmpty(ds_grd_nstmngt.getColumn(k,"actgrde"));
  530. /// 쿼리가 잘못된듯 하다.. nutrprob는 중복으로 가져와 actgrde 와 같은값이 들어와 버리고 정작 actgrdeetc라는 컬럼은 있지도 않다.
  531. //var actgrdeetc = ds_grd_nstmngt.getColumn(k,"actgrdeetc");
  532. var actgrdeetc = ds_grd_nstmngt.getColumn(k,"nutrprobetc");
  533. var actgrde_temp = "";
  534. var actgrdeData = actgrde.split("|");
  535. if ( !utlf_isNull(actgrde) ) {
  536. for(var i = 0; i < actgrdeData.length; i++) {
  537. if (actgrdeData[i] == "1") actgrde_temp += "bed ridden";
  538. else if (actgrdeData[i] == "2") actgrde_temp += "wheel chair";
  539. else if (actgrdeData[i] == "3") actgrde_temp += "bed side PT";
  540. else if (actgrdeData[i] == "4") actgrde_temp += "PT";
  541. else if (actgrdeData[i] == "5") actgrde_temp += "light ambulation";
  542. else if (actgrdeData[i] == "6") actgrde_temp += actgrdeetc;
  543. if ( (i+1) < actgrdeData.length ) actgrde_temp += ", ";
  544. }
  545. ds_grd_nstmngt.setColumn(k,"actgrde", actgrde_temp );
  546. }
  547. //투여경로
  548. var drugpath = utlf_transNullToEmpty(ds_grd_nstmngt.getColumn(k,"drugpath"));
  549. var drugpath_temp = "";
  550. var drugpathData = drugpath.split(" ");
  551. if ( !utlf_isNull(drugpath) ) {
  552. for(var i = 0; i < drugpathData.length; i++) {
  553. if (drugpathData[i] == "1") drugpath_temp += "EN(Tube Feeding)";
  554. else if (drugpathData[i] == "2") drugpath_temp += "TPN(Central)";
  555. else if (drugpathData[i] == "3") drugpath_temp += "PPN(Peripheral)";
  556. else if (drugpathData[i] == "4") drugpath_temp += "EN + TPN";
  557. else if (drugpathData[i] == "5") drugpath_temp += "EN + PPN";
  558. if ( (i+1) < drugpathData.length ) drugpath_temp += ", ";
  559. }
  560. ds_grd_nstmngt.setColumn(k,"drugpath", drugpath_temp );
  561. }
  562. //영양상태판정
  563. var nutrjudg = utlf_transNullToEmpty(ds_grd_nstmngt.getColumn(k,"nutrjudg"));
  564. var nutrjudg_temp = "";
  565. var nutrjudgData = nutrjudg.split("|");
  566. if ( !utlf_isNull(nutrjudg) ) {
  567. for(var i = 0; i < nutrjudgData.length; i++) {
  568. if (nutrjudgData[i] == "1") nutrjudg_temp += "No malnutrition present ";
  569. else if (nutrjudgData[i] == "2") nutrjudg_temp += "Mild malnutrition";
  570. else if (nutrjudgData[i] == "3") nutrjudg_temp += "Moderate malnutrition";
  571. else if (nutrjudgData[i] == "4") nutrjudg_temp += "Severe Protein Energy malnutrition";
  572. else if (nutrjudgData[i] == "5") nutrjudg_temp += "Energy malnutrition";
  573. else if (nutrjudgData[i] == "6") nutrjudg_temp += "Protein malnutrition";
  574. if ( (i+1) < nutrjudgData.length ) nutrjudg_temp += ", ";
  575. }
  576. ds_grd_nstmngt.setColumn(k,"nutrjudg", nutrjudg_temp );
  577. }
  578. //기초대사량
  579. var basembolcalc;
  580. var wt = ds_grd_nstmngt.getColumn(k,"basewt");
  581. var ht = ds_grd_nstmngt.getColumn(k,"ht");
  582. var sex = ds_grd_nstmngt.getColumn(k,"sex");
  583. var age = ds_grd_nstmngt.getColumn(k,"age");
  584. if (sex == "M" ) {
  585. basembolcalc = ( 66.5 + (13.7 * wt) + (5 * ht) - (6.8 * age) ).toString().getRound( -2,"HALF_UP");
  586. }else{
  587. basembolcalc = ( 655 + (9.6 * wt) + (1.9 * ht) - (4.7 * age) ).toString().getRound( -2,"HALF_UP");
  588. }
  589. ds_grd_nstmngt.setColumn(k,"basembolcalc", basembolcalc );
  590. }
  591. }]]></Script>
  592. </Form>
  593. </FDL>