SMRIS00102_과제이력관리.xfdl 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRIS00102" position="absolute 0 0 1192 768" titletext="과제이력관리" onload="SMRIS00102_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="cap_title" class="tit_1" position="absolute 0 0 126 26" style="" text="과제입력관리"/>
  8. <Div id="grp_projhist" position="absolute 0 65 1192 768" style="" anchor="all">
  9. <Layouts>
  10. <Layout>
  11. <Grid id="grd_projhist" binddataset="ds_main_result_projhistinfo_projhistlist" class="datagrid2" position="absolute 0 28 1192 703" style="" onaftersort="grp_projhist_grd_projhist_onaftersort" ontextchanged="grp_projhist_grd_projhist_ontextchanged" onkeypress="grp_projhist_grd_projhist_onkeypress" anchor="all" cellmovingtype="col" selecttype="multirow" onexpanddown="grp_projhist_grd_projhist_onexpanddown" cellclickbound="control" autoenter="select" onenterdown="grp_projhist_grd_projhist_onenterdown" autoupdatetype="none">
  12. <Formats>
  13. <Format id="default">
  14. <Columns>
  15. <Column size="25"/>
  16. <Column size="138"/>
  17. <Column size="419"/>
  18. <Column size="32"/>
  19. <Column size="74"/>
  20. <Column size="68"/>
  21. <Column size="100"/>
  22. <Column size="98"/>
  23. <Column size="100"/>
  24. <Column size="100"/>
  25. <Column size="100"/>
  26. <Column size="82"/>
  27. <Column size="100"/>
  28. <Column size="60"/>
  29. <Column size="70"/>
  30. <Column size="100"/>
  31. <Column size="100"/>
  32. <Column size="100"/>
  33. <Column size="100"/>
  34. <Column size="100"/>
  35. <Column size="100"/>
  36. <Column size="100"/>
  37. <Column size="100"/>
  38. <Column size="100"/>
  39. <Column size="100"/>
  40. <Column size="100"/>
  41. <Column size="0"/>
  42. <Column size="0"/>
  43. </Columns>
  44. <Rows>
  45. <Row size="24" band="head"/>
  46. <Row size="24"/>
  47. </Rows>
  48. <Band id="head">
  49. <Cell/>
  50. <Cell col="1" text="과제번호"/>
  51. <Cell col="2" text="과제명"/>
  52. <Cell col="3" text="이력&#10;No"/>
  53. <Cell col="4" colspan="2" text="책임연구원" taborder="undefined"/>
  54. <Cell col="6" text="승인일"/>
  55. <Cell col="7" text="총연구비"/>
  56. <Cell col="8" text="연구시작일"/>
  57. <Cell col="9" text="연구종료일"/>
  58. <Cell col="10" text="단계"/>
  59. <Cell col="11" text="접수번호"/>
  60. <Cell col="12" text="식약청승인일"/>
  61. <Cell col="13" text="국가구분"/>
  62. <Cell col="14" text="기관구분"/>
  63. <Cell col="15" text="승인유효일"/>
  64. <Cell col="16" text="의약품명칭"/>
  65. <Cell col="17" text="의뢰기관"/>
  66. <Cell col="18" text="대행기관"/>
  67. <Cell col="19" text="계약일"/>
  68. <Cell col="20" text="상세설명"/>
  69. <Cell col="21" text="심사"/>
  70. <Cell col="22" text="심의종류"/>
  71. <Cell col="23" text="심의결과"/>
  72. <Cell col="24" text="최초승인일"/>
  73. <Cell col="25" text="증례수"/>
  74. <Cell col="26" text="과제코드"/>
  75. <Cell col="27" text="기관코드"/>
  76. </Band>
  77. <Band id="body">
  78. <Cell celltype="head"/>
  79. <Cell col="1" displaytype="text" edittype="expr:getRowType(currow) == 2 ? 'text' : 'readonly'" style="align:center;background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:studycd" editautoselect="true"/>
  80. <Cell col="2" displaytype="text" edittype="textarea" style="align:left top;background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:projnm" wordwrap="word" editautoselect="true"/>
  81. <Cell col="3" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:seqno" editautoselect="true"/>
  82. <Cell col="4" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:rshid" editautoselect="true" expandshow="show"/>
  83. <Cell col="5" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:rshnm" editautoselect="true"/>
  84. <Cell col="6" displaytype="date" edittype="date" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:cnfmdd" editautoselect="true" calendardisplay="display"/>
  85. <Cell col="7" displaytype="number" edittype="masknumber" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:projamt" editautoselect="true"/>
  86. <Cell col="8" displaytype="date" edittype="date" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:fromdd" editautoselect="true" calendardisplay="display"/>
  87. <Cell col="9" displaytype="date" edittype="date" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:todd" editautoselect="true" calendardisplay="display"/>
  88. <Cell col="10" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:stage" editautoselect="true"/>
  89. <Cell col="11" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:projtype" editautoselect="true"/>
  90. <Cell col="12" displaytype="date" edittype="date" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:fcnfmdd" editautoselect="true" calendardisplay="display"/>
  91. <Cell col="13" displaytype="text" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:nflag" editautoselect="true"/>
  92. <Cell col="14" displaytype="text" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:oflag" editautoselect="true"/>
  93. <Cell col="15" displaytype="date" edittype="date" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:cnfmvalidd" editautoselect="true" calendardisplay="display"/>
  94. <Cell col="16" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:drugnm" editautoselect="true"/>
  95. <Cell col="17" displaytype="text" edittype="text" style="align:left;background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:reqfirm" editautoselect="true"/>
  96. <Cell col="18" displaytype="text" edittype="text" style="align:left;background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:agent" editautoselect="true"/>
  97. <Cell col="19" displaytype="date" edittype="date" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:cntrdd" editautoselect="true" calendardisplay="display"/>
  98. <Cell col="20" displaytype="text" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:projspec" editautoselect="true"/>
  99. <Cell col="21" displaytype="text" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:simsa" editautoselect="true"/>
  100. <Cell col="22" displaytype="text" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:simsakind" editautoselect="true"/>
  101. <Cell col="23" displaytype="text" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:simsarslt" editautoselect="true"/>
  102. <Cell col="24" displaytype="date" edittype="date" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:fstcnfmdd" editautoselect="true" calendardisplay="display"/>
  103. <Cell col="25" displaytype="text" edittype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:samplecnt" editautoselect="true"/>
  104. <Cell col="26" style="background:transparent;background2:transparent;" text="bind:projcd" editautoselect="true"/>
  105. <Cell col="27" style="background:transparent;background2:transparent;" text="bind:instcd" editautoselect="true"/>
  106. <Cell col="28" text="bind:isyn"/>
  107. </Band>
  108. </Format>
  109. </Formats>
  110. </Grid>
  111. <Static id="caption15" class="tit_2" position="absolute 0 10 128 29" style="" text="과제이력LIST" anchor="default"/>
  112. <Button id="btn_add" class="btn2" position="absolute 941 7 994 26" style="" text="행추가" onclick="grp_projhist_btn_add_onclick" anchor="top right"/>
  113. <Button id="btn_del" class="btn2" position="absolute 995 7 1048 26" style="" text="행삭제" onclick="grp_projhist_btn_del_onclick" anchor="top right"/>
  114. <Button id="btn_excel" class="btn5" position="absolute 1049 7 1113 26" style="" text="엑셀입력" onclick="grp_projhist_btn_excel_onclick" anchor="top right"/>
  115. <Button id="btn_save" class="btn7" taborder="26" position="absolute 1114 7 1192 26" style="" text="엑셀저장" onclick="grp_projhist_btn_save_onclick" anchor="top right"/>
  116. </Layout>
  117. </Layouts>
  118. </Div>
  119. <Div id="group3" position="absolute 0 26 1192 66" style="align: top;" class="div_SA" anchor="left top right">
  120. <Layouts>
  121. <Layout>
  122. <Button id="btn_search" class="btn1" position="absolute 1104 8 1160 30" style="" text="조회" onclick="group3_btn_search_onclick" anchor="top right"/>
  123. <Static id="caption3" class="search_name" position="absolute 24 10 115 27" style="" text="과제번호 :" anchor="left top"/>
  124. <Edit id="ipt_studycd" position="absolute 115 10 260 29" style="" anchor="left top" onkeypress="group3_ipt_studycd_onkeypress" onkeydown="group3_ipt_studycd_onkeydown"/>
  125. <Shape id="line30" class="line_4" linetype="vertical" position="absolute 1070 9 1073 30" style="" anchor="top right"/>
  126. </Layout>
  127. </Layouts>
  128. </Div>
  129. <Button id="button1" class="btn4" taborder="26" position="absolute 1136 1 1192 23" style="" text="저장" onclick="button1_onclick" anchor="top right"/>
  130. <Button id="button2" class="btn2" taborder="26" position="absolute 1067 1 1135 23" style="" text="초기화" onclick="button2_onclick" anchor="top right"/>
  131. </Layout>
  132. </Layouts>
  133. <Objects>
  134. <Dataset id="ds_send_req" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  135. <ColumnInfo>
  136. <Column id="studycd" type="STRING" size="256"/>
  137. <Column id="srchflag" type="STRING" size="256"/>
  138. </ColumnInfo>
  139. <Rows>
  140. <Row>
  141. <Col id="studycd"/>
  142. <Col id="srchflag"/>
  143. </Row>
  144. </Rows>
  145. </Dataset>
  146. <Dataset id="ds_result" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  147. <ColumnInfo>
  148. <Column id="projhistinfo" type="STRING" size="256"/>
  149. </ColumnInfo>
  150. </Dataset>
  151. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  152. <ColumnInfo>
  153. <Column id="hidden" type="STRING" size="256"/>
  154. </ColumnInfo>
  155. <Rows>
  156. <Row>
  157. <Col id="hidden"/>
  158. </Row>
  159. </Rows>
  160. </Dataset>
  161. <Dataset id="ds_init_baseinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  162. <ColumnInfo/>
  163. </Dataset>
  164. <Dataset id="ds_init_baseinfo_instinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  165. <ColumnInfo>
  166. <Column id="instcd" type="STRING" size="256"/>
  167. <Column id="hospnm" type="STRING" size="256"/>
  168. </ColumnInfo>
  169. <Rows>
  170. <Row>
  171. <Col id="instcd"/>
  172. <Col id="hospnm"/>
  173. </Row>
  174. </Rows>
  175. </Dataset>
  176. <Dataset id="ds_result_projhistdetlinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  177. <ColumnInfo/>
  178. </Dataset>
  179. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  180. <ColumnInfo>
  181. <Column id="stage" type="STRING" size="256"/>
  182. <Column id="kind" type="STRING" size="256"/>
  183. <Column id="status" type="STRING" size="256"/>
  184. </ColumnInfo>
  185. </Dataset>
  186. <Dataset id="ds_send_srch" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  187. <ColumnInfo>
  188. <Column id="searchcondition" type="STRING" size="256"/>
  189. <Column id="searchterm" type="STRING" size="256"/>
  190. <Column id="dutinstcd" type="STRING" size="256"/>
  191. <Column id="dutunitcd" type="STRING" size="256"/>
  192. </ColumnInfo>
  193. <Rows>
  194. <Row>
  195. <Col id="searchcondition"/>
  196. <Col id="searchterm"/>
  197. <Col id="dutinstcd"/>
  198. <Col id="dutunitcd"/>
  199. </Row>
  200. </Rows>
  201. </Dataset>
  202. <Dataset id="ds_main_col" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  203. <ColumnInfo>
  204. <Column id="projhistinfo" type="STRING" size="256"/>
  205. </ColumnInfo>
  206. <Rows>
  207. <Row>
  208. <Col id="projhistinfo"/>
  209. </Row>
  210. </Rows>
  211. </Dataset>
  212. <Dataset id="ds_result_studyprojlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  213. <ColumnInfo>
  214. <Column id="projcd" type="STRING" size="256"/>
  215. <Column id="studycd" type="STRING" size="256"/>
  216. <Column id="projnm" type="STRING" size="256"/>
  217. <Column id="status" type="STRING" size="256"/>
  218. <Column id="reqfirm" type="STRING" size="256"/>
  219. <Column id="kind" type="STRING" size="256"/>
  220. <Column id="rshid" type="STRING" size="256"/>
  221. <Column id="rshnm" type="STRING" size="256"/>
  222. <Column id="cnfmdd" type="STRING" size="256"/>
  223. <Column id="cntrdd" type="STRING" size="256"/>
  224. <Column id="fromdd" type="STRING" size="256"/>
  225. <Column id="todd" type="STRING" size="256"/>
  226. <Column id="cntramt" type="STRING" size="256"/>
  227. <Column id="stage" type="STRING" size="256"/>
  228. <Column id="projspec" type="STRING" size="256"/>
  229. <Column id="fstrgstrnm" type="STRING" size="256"/>
  230. <Column id="fstrgstdt" type="STRING" size="256"/>
  231. <Column id="lastupdnm" type="STRING" size="256"/>
  232. <Column id="lastupdtdt" type="STRING" size="256"/>
  233. <Column id="instcd" type="STRING" size="256"/>
  234. <Column id="projamt" type="STRING" size="256"/>
  235. <Column id="custnm" type="STRING" size="256"/>
  236. </ColumnInfo>
  237. <Rows>
  238. <Row>
  239. <Col id="projcd"/>
  240. <Col id="studycd"/>
  241. <Col id="projnm"/>
  242. <Col id="status"/>
  243. <Col id="reqfirm"/>
  244. <Col id="kind"/>
  245. <Col id="rshid"/>
  246. <Col id="rshnm"/>
  247. <Col id="cnfmdd"/>
  248. <Col id="cntrdd"/>
  249. <Col id="fromdd"/>
  250. <Col id="todd"/>
  251. <Col id="cntramt"/>
  252. <Col id="stage"/>
  253. <Col id="projspec"/>
  254. <Col id="fstrgstrnm"/>
  255. <Col id="fstrgstdt"/>
  256. <Col id="lastupdnm"/>
  257. <Col id="lastupdtdt"/>
  258. <Col id="instcd"/>
  259. <Col id="projamt"/>
  260. <Col id="custnm"/>
  261. </Row>
  262. </Rows>
  263. </Dataset>
  264. <Dataset id="ds_main_result" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  265. <ColumnInfo/>
  266. </Dataset>
  267. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  268. <ColumnInfo/>
  269. </Dataset>
  270. <Dataset id="ds_send_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  271. <ColumnInfo>
  272. <Column id="pid" type="STRING" size="256"/>
  273. <Column id="instcd" type="STRING" size="256"/>
  274. <Column id="hngnm" type="STRING" size="256"/>
  275. <Column id="grdpid" type="STRING" size="256"/>
  276. <Column id="grdhngnm" type="STRING" size="256"/>
  277. </ColumnInfo>
  278. <Rows>
  279. <Row>
  280. <Col id="pid"/>
  281. <Col id="instcd"/>
  282. <Col id="hngnm"/>
  283. <Col id="grdpid"/>
  284. <Col id="grdhngnm"/>
  285. </Row>
  286. </Rows>
  287. </Dataset>
  288. <Dataset id="ds_main_result_projhistinfo_projhistlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  289. <ColumnInfo>
  290. <Column id="status" type="STRING" size="256" sumtext="상태"/>
  291. <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
  292. <Column id="backinstcd" type="STRING" size="256" sumtext="기관코드"/>
  293. <Column id="studycd" type="STRING" size="256" sumtext="과제번호"/>
  294. <Column id="projcd" type="STRING" size="256" sumtext="과제코드"/>
  295. <Column id="seqno" type="STRING" size="256" sumtext="일련번호"/>
  296. <Column id="projnm" type="STRING" size="256" sumtext="과제명"/>
  297. <Column id="rshid" type="STRING" size="256" sumtext="책임연구원"/>
  298. <Column id="rshnm" type="STRING" size="256" sumtext="책임연구원"/>
  299. <Column id="cnfmdd" type="STRING" size="256" sumtext="승인일"/>
  300. <Column id="stage" type="STRING" size="256" sumtext="단계(1,2,3,4,PMS,기타,SIT,학술)"/>
  301. <Column id="projtype" type="STRING" size="256" sumtext="접수번호"/>
  302. <Column id="fcnfmdd" type="STRING" size="256" sumtext="식약청승인일"/>
  303. <Column id="nflag" type="STRING" size="256" sumtext="나라구분"/>
  304. <Column id="oflag" type="STRING" size="256" sumtext="기관구분"/>
  305. <Column id="cnfmvalidd" type="STRING" size="256" sumtext="승인유효일"/>
  306. <Column id="drugnm" type="STRING" size="256" sumtext="의약품명칭"/>
  307. <Column id="reqfirm" type="STRING" size="256" sumtext="의뢰회사 재무와 연결"/>
  308. <Column id="agent" type="STRING" size="256" sumtext="대행기관"/>
  309. <Column id="projamt" type="STRING" size="256" sumtext="총연구비"/>
  310. <Column id="cntrdd" type="STRING" size="256" sumtext="계약일"/>
  311. <Column id="fromdd" type="STRING" size="256" sumtext="연구시작일"/>
  312. <Column id="todd" type="STRING" size="256" sumtext="연구종료일"/>
  313. <Column id="projspec" type="STRING" size="256" sumtext="과제상세내역"/>
  314. <Column id="simsa" type="STRING" size="256" sumtext="심사"/>
  315. <Column id="simsakind" type="STRING" size="256" sumtext="심의종류"/>
  316. <Column id="simsarslt" type="STRING" size="256" sumtext="심의결과"/>
  317. <Column id="fstcnfmdd" type="STRING" size="256" sumtext="최초승인일"/>
  318. <Column id="samplecnt" type="STRING" size="256" sumtext="증례수"/>
  319. <Column id="isyn" type="STRING" size="256"/>
  320. <Column id="bgcolor" type="STRING" size="256"/>
  321. </ColumnInfo>
  322. </Dataset>
  323. <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  324. <ColumnInfo>
  325. <Column id="temp" type="STRING" size="256"/>
  326. </ColumnInfo>
  327. <Rows>
  328. <Row>
  329. <Col id="temp"/>
  330. </Row>
  331. </Rows>
  332. </Dataset>
  333. <Dataset id="ds_newprojcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  334. <ColumnInfo>
  335. <Column id="newprojcd" type="STRING" size="256"/>
  336. </ColumnInfo>
  337. </Dataset>
  338. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  339. <ColumnInfo>
  340. <Column id="savedata" type="STRING" size="256"/>
  341. <Column id="userinfo" type="STRING" size="256"/>
  342. </ColumnInfo>
  343. </Dataset>
  344. <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  345. <ColumnInfo>
  346. <Column id="studycd" type="STRING" size="256"/>
  347. <Column id="srchflag" type="STRING" size="256"/>
  348. <Column id="totstudycd" type="STRING" size="256"/>
  349. </ColumnInfo>
  350. <Rows>
  351. <Row>
  352. <Col id="studycd"/>
  353. <Col id="srchflag"/>
  354. <Col id="totstudycd"/>
  355. </Row>
  356. </Rows>
  357. </Dataset>
  358. <Dataset id="ds_main_list_userlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  359. <Dataset id="ds_projhistlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  360. <ColumnInfo>
  361. <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
  362. <Column id="studycd" type="STRING" size="256" sumtext="과제번호"/>
  363. <Column id="projcd" type="STRING" size="256" sumtext="과제코드"/>
  364. <Column id="seqno" type="STRING" size="256" sumtext="일련번호"/>
  365. <Column id="projnm" type="STRING" size="256" sumtext="과제명"/>
  366. <Column id="rshid" type="STRING" size="256" sumtext="책임연구원"/>
  367. <Column id="rshnm" type="STRING" size="256" sumtext="책임연구원"/>
  368. <Column id="cnfmdd" type="STRING" size="256" sumtext="승인일"/>
  369. <Column id="stage" type="STRING" size="256" sumtext="단계(1,2,3,4,PMS,기타,SIT,학술)"/>
  370. <Column id="projtype" type="STRING" size="256" sumtext="접수번호"/>
  371. <Column id="fcnfmdd" type="STRING" size="256" sumtext="식약청승인일"/>
  372. <Column id="nflag" type="STRING" size="256" sumtext="나라구분"/>
  373. <Column id="oflag" type="STRING" size="256" sumtext="기관구분"/>
  374. <Column id="cnfmvalidd" type="STRING" size="256" sumtext="승인유효일"/>
  375. <Column id="drugnm" type="STRING" size="256" sumtext="의약품명칭"/>
  376. <Column id="reqfirm" type="STRING" size="256" sumtext="의뢰회사 재무와 연결"/>
  377. <Column id="agent" type="STRING" size="256" sumtext="대행기관"/>
  378. <Column id="projamt" type="STRING" size="256" sumtext="총연구비"/>
  379. <Column id="cntrdd" type="STRING" size="256" sumtext="계약일"/>
  380. <Column id="fromdd" type="STRING" size="256" sumtext="연구시작일"/>
  381. <Column id="todd" type="STRING" size="256" sumtext="연구종료일"/>
  382. <Column id="projspec" type="STRING" size="256" sumtext="과제상세내역"/>
  383. <Column id="simsa" type="STRING" size="256" sumtext="심사"/>
  384. <Column id="simsakind" type="STRING" size="256" sumtext="심의종류"/>
  385. <Column id="simsarslt" type="STRING" size="256" sumtext="심의결과"/>
  386. <Column id="fstcnfmdd" type="STRING" size="256" sumtext="최초승인일"/>
  387. <Column id="samplecnt" type="STRING" size="256" sumtext="증례수"/>
  388. <Column id="isyn" type="STRING" size="256" sumtext="증례수"/>
  389. </ColumnInfo>
  390. </Dataset>
  391. <Dataset id="ds_checklist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  392. </Objects>
  393. <Bind>
  394. <BindItem id="item0" compid="group3.ipt_studycd" propid="value" datasetid="ds_send_req" columnid="studycd"/>
  395. </Bind>
  396. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  397. * System Name :
  398. * Job Name :
  399. * Creator :
  400. * Make Date : 2017-01-10
  401. * Description :
  402. *---------------------------------------------------------------------------------------
  403. * Modify Date Modifier Modify Description
  404. *---------------------------------------------------------------------------------------
  405. * 2018-01-10 Live Converter TF->XP
  406. *
  407. *---------------------------------------------------------------------------------------
  408. ****************************************************************************************/
  409. include "com_commonxp::comm_main.xjs";
  410. function SMRIS00102_onload(obj:Form, e:LoadEventInfo) {
  411. frmf_initForm(obj);
  412. grdf_initGrid(grp_projhist.grd_projhist);
  413. //grdf_setGridSort(grd_XXX);
  414. grdf_setRowTypeIcon(grp_projhist.grd_projhist, 0);
  415. fInit();
  416. }
  417. function fInit(){
  418. ds_main_result_projhistinfo_projhistlist.clearData();
  419. ds_send_req.setColumn( 0, "studycd" , "");
  420. }
  421. function fSearch(){
  422. group3.btn_search.setFocus();
  423. ds_send_req.setColumn( 0, "srchflag", "1");
  424. var oParam = {};
  425. oParam.id = "TRRIS00203";
  426. oParam.service = "ctmsapp.StudyProjMngt";
  427. oParam.method = "reqGetProjHistExcel";
  428. oParam.inds = "req=ds_send_req";
  429. oParam.outds = "ds_main_result_projhistinfo_projhistlist=projhistlist";
  430. oParam.async = false;
  431. tranf_submit(oParam);
  432. //grp_projhist.grd_projhist.colDisabled(1) = true;
  433. }
  434. function fSetUserSearch(flag){
  435. var rtn = appf_openUserInfoList("usernm");
  436. var userinfo = rtn.userInfo;
  437. if (!utlf_isNull(userinfo)) {
  438. userinfo = userinfo.split("|");
  439. var rshid = userinfo[2];
  440. var rshnm = userinfo[3];
  441. if( flag == 1 ){
  442. ds_send.setColumn( 0, "rshid", rshid);
  443. ds_send.setColumn( 0, "rshnm", rshnm);
  444. } else {
  445. var row = ds_result_projhistdetlinfo_projhistdetllist.rowposition;
  446. ds_result_projhistdetlinfo_projhistdetllist.setColumn(row,"rshid",rshid);
  447. ds_result_projhistdetlinfo_projhistdetllist.setColumn(row,"rshnm",rshnm);
  448. }
  449. }
  450. }
  451. function fCheckSaveData(){
  452. for( var i = 0; i <= ds_main_result_projhistinfo_projhistlist.rowcount; i++ ){
  453. if( ds_main_result_projhistinfo_projhistlist.getRowType(i) > 1 ){
  454. if( ds_main_result_projhistinfo_projhistlist.getColumn(i, "isyn") != "Y" || utlf_isNull(ds_main_result_projhistinfo_projhistlist.getColumn(i, "projcd"))){
  455. sysf_messageBox(i + 1 + "번째 행의 과제번호는 존재하지 않는 과제입니다. 【 " + ds_main_result_projhistinfo_projhistlist.getColumn(i, "studycd") + " 】" ,"C999");
  456. grp_projhist.grd_projhist.vscrollbar.pos = i;
  457. return false;
  458. }
  459. if( utlf_isNull(ds_main_result_projhistinfo_projhistlist.getColumn(i, "studycd") ) ){
  460. sysf_messageBox(i + 1 + "번째 행의 【 과제번호 】를" ,"C002");
  461. grp_projhist.grd_projhist.vscrollbar.pos = i;
  462. return false;
  463. }
  464. if( utlf_isNull(ds_main_result_projhistinfo_projhistlist.getColumn(i, "rshid") ) ){
  465. sysf_messageBox(i + 1 + "번째 행의 【 책임연구원 】을" ,"C002");
  466. grp_projhist.grd_projhist.vscrollbar.pos = i;
  467. return false;
  468. }
  469. if( utlf_isNull(ds_main_result_projhistinfo_projhistlist.getColumn(i, "cnfmdd") ) ){
  470. sysf_messageBox(i + 1 + "번째 행의 【 승 인 일 】을" ,"C002");
  471. grp_projhist.grd_projhist.vscrollbar.pos = i;
  472. return false;
  473. }
  474. if( utlf_isNull(ds_main_result_projhistinfo_projhistlist.getColumn(i, "projamt") ) ){
  475. sysf_messageBox(i + 1 + "번째 행의 【 총연구비 】를" ,"C002");
  476. grp_projhist.grd_projhist.vscrollbar.pos = i;
  477. return false;
  478. }
  479. if( utlf_isNull(ds_main_result_projhistinfo_projhistlist.getColumn(i, "fromdd") ) ){
  480. sysf_messageBox(i + "번째 행의 【 연구시작일 】을" ,"C002");
  481. grp_projhist.grd_projhist.topRow = i;
  482. return false;
  483. }
  484. if( utlf_isNull(ds_main_result_projhistinfo_projhistlist.getColumn(i, "todd") ) ){
  485. sysf_messageBox(i + 1 + "번째 행의 【 연구종료일 】을" ,"C002");
  486. grp_projhist.grd_projhist.topRow = i;
  487. return false;
  488. }
  489. }
  490. }
  491. return true;
  492. }
  493. function fSave(){
  494. if( fCheckSaveData() == false ) {
  495. return;
  496. }
  497. var updtdata = grdf_getGridUpdateData(grp_projhist.grd_projhist);
  498. if (updtdata.rowcount == 0 ) {
  499. sysf_messageBox("변경된 데이터가","I004");
  500. return;
  501. }
  502. var oParam = {};
  503. oParam.id = "TXRIS00206";
  504. oParam.service = "ctmsapp.StudyProjMngt";
  505. oParam.method = "reqExeProjHistMngt";
  506. oParam.inds = "req="+updtdata.name+":U";
  507. oParam.outds = "ds_=spcnt";
  508. oParam.async = false;
  509. //oParam.callback = "cf_TXRIS00206";
  510. tranf_submit(oParam);
  511. fSearch();
  512. }
  513. function grp_projhist_grd_projhist_ontextchanged(obj:Grid, e:GridEditTextChangedEventInfo) {
  514. }
  515. function grp_projhist_grd_projhist_onkeydown(obj:Grid, e:KeyEventInfo) {
  516. }
  517. function grp_projhist_btn_add_onclick(obj:Button, e:ClickEventInfo) {
  518. var row = ds_main_result_projhistinfo_projhistlist.addRow();
  519. ds_main_result_projhistinfo_projhistlist.setColumn(row, "instcd", sysf_getUserInfo("dutplceinstcd"));
  520. grp_projhist.grd_projhist.vscrollbar.pos = row;
  521. }
  522. function grp_projhist_btn_del_onclick(obj:Button, e:ClickEventInfo) {
  523. var nodeList = grdf_getSelectedRows(grp_projhist.grd_projhist);
  524. for (var j = nodeList.length-1; j >= 0; j--)
  525. {
  526. var rowStatus = ds_main_result_projhistinfo_projhistlist.getRowType(nodeList[j]);
  527. if (rowStatus != 2) {
  528. ds_main_result_projhistinfo_projhistlist.updatecontrol = false;
  529. ds_main_result_projhistinfo_projhistlist.setRowType(nodeList[j], 'd');
  530. ds_main_result_projhistinfo_projhistlist.updatecontrol = true;
  531. } else {
  532. ds_main_result_projhistinfo_projhistlist.deleteRow(nodeList[j]);
  533. }
  534. }
  535. }
  536. function grp_projhist_btn_excel_onclick(obj:Button, e:ClickEventInfo) {
  537. fInit();
  538. grdf_ImportExcel("ds_main_result_projhistinfo_projhistlist", 0, grp_projhist.grd_projhist, 0);
  539. var cnt = ds_main_result_projhistinfo_projhistlist.rowcount;
  540. var totstudycd = "";
  541. var ali = "'";
  542. var dot = ",";
  543. if( cnt > 0 ){
  544. for(var a = 0; a <= cnt -1; a++){
  545. if( !utlf_isNull(ds_main_result_projhistinfo_projhistlist.getColumn(a, "studycd"))){
  546. if( a < cnt -1 ){
  547. totstudycd = totstudycd + ali + ds_main_result_projhistinfo_projhistlist.getColumn(a, "studycd") + ali + dot;
  548. }else{
  549. totstudycd = totstudycd + ali + ds_main_result_projhistinfo_projhistlist.getColumn(a, "studycd") + ali;
  550. }
  551. }
  552. }
  553. }
  554. ds_send_reqdata.setColumn( 0, "totstudycd", totstudycd );
  555. var totCnt = 0;
  556. var oParam = {};
  557. oParam.id = "TRRIS00205";
  558. oParam.service = "ctmsapp.StudyProjMngt";
  559. oParam.method = "reqGetProjHistInsertCheck";
  560. oParam.inds = "req=ds_send_reqdata";
  561. oParam.outds = "ds_checklist=checklist";
  562. oParam.async = false;
  563. tranf_submit(oParam);
  564. for(var b = 0; b <=cnt-1 ; b++){
  565. for(var c = 0; c <=cnt-1 ; c++){
  566. if( ds_main_result_projhistinfo_projhistlist.getColumn(b, "studycd") == ds_checklist.getColumn(c, "studycd") ){
  567. ds_main_result_projhistinfo_projhistlist.setColumn( b , "isyn", "Y");
  568. ds_main_result_projhistinfo_projhistlist.setColumn( b , "projcd", ds_checklist.getColumn(c, "projcd") );
  569. }
  570. }
  571. }
  572. for( var i = 0 ; i < cnt ; i++ ){
  573. if( ds_main_result_projhistinfo_projhistlist.getColumn(i, "isyn") != "Y"){
  574. ds_main_result_projhistinfo_projhistlist.setColumn(i, "bgcolor", "#999999");
  575. }
  576. }
  577. }
  578. function grp_projhist_btn_save_onclick(obj:Button, e:ClickEventInfo) {
  579. var sTitleTmp = "과제이력_"+utlf_getCurrentDate();
  580. grdf_exportExcel(grp_projhist.grd_projhist, sTitleTmp, sTitleTmp);
  581. }
  582. function group3_btn_search_onclick(obj:Button, e:ClickEventInfo) {
  583. fSearch();
  584. }
  585. function group3_ipt_studycd_onkeydown(obj:Edit, e:KeyEventInfo) {
  586. if(e.keycode == "13") {
  587. group3.btn_search.click();
  588. }
  589. }
  590. function button1_onclick(obj:Button, e:ClickEventInfo) {
  591. fSave();
  592. }
  593. function button2_onclick(obj:Button, e:ClickEventInfo) {
  594. fInit();
  595. }
  596. function grp_projhist_grd_projhist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
  597. {
  598. if( obj.getBindCellIndex("body","rshid") == e.col ){
  599. fSetUserSearch(2);
  600. }
  601. }
  602. function grp_projhist_grd_projhist_onenterdown(obj:Grid, e:GridEditEventInfo)
  603. {
  604. if( obj.getBindCellIndex("body","rshid") == e.col ){
  605. ds_send_srch.setColumn( 0, "searchcondition", "userid");
  606. ds_send_srch.setColumn( 0, "searchterm", e.value);
  607. if(ds_main_result_projhistinfo_projhistlist.getColumn(grp_projhist.grd_projhist.row, "rshid") != "" ){
  608. // if( submit("TRZSU10103") ){
  609. var oParam = {};
  610. oParam.id = "TRZSU10103";
  611. oParam.service = "userdeptinfoapp.UserDeptInfoAdmin";
  612. oParam.method = "reqGetUserInfoList";
  613. oParam.inds = "req=ds_send_srch";
  614. oParam.outds = "ds_main_list_userlist=userlist";
  615. oParam.async = false;
  616. //oParam.callback = "cf_TRZSU10103";
  617. tranf_submit(oParam);
  618. ds_main_result_projhistinfo_projhistlist.setColumn( e.row , "rshnm" , ds_main_list_userlist.getColumn(0, "usernm"));
  619. }
  620. } else if ( ds_main_result_projhistinfo_projhistlist.getRowType(e.row) == 2 && obj.getBindCellIndex("body","studycd") == e.col) {
  621. ds_send_reqdata.setColumn( 0, "srchflag", "2");
  622. ds_send_reqdata.setColumn( 0, "studycd", e.value );
  623. ds_projhistlist.clearData();
  624. var oParam = {};
  625. oParam.id = "TRRIS00204";
  626. oParam.service = "ctmsapp.StudyProjMngt";
  627. oParam.method = "reqGetProjHistExcel";
  628. oParam.inds = "req=ds_send_reqdata";
  629. oParam.outds = "ds_projhistlist=projhistlist";
  630. oParam.async = false;
  631. //oParam.callback = "cf_TRRIS00204";
  632. tranf_submit(oParam);
  633. if( !utlf_isNull(ds_projhistlist.getColumn(0, "projcd"))){
  634. ds_main_result_projhistinfo_projhistlist.copyRow(e.row, ds_projhistlist, 0);
  635. ds_main_result_projhistinfo_projhistlist.setColumn(e.row, "isyn", "Y");
  636. ds_main_result_projhistinfo_projhistlist.setColumn(e.row, "seqno", "");
  637. }else{
  638. sysf_messageBox("해당 연구는 존재하지 않습니다." ,"C999");
  639. ds_projhistlist.addRow();
  640. ds_main_result_projhistinfo_projhistlist.copyRow(e.row, ds_projhistlist, 0);
  641. return;
  642. }
  643. }
  644. }
  645. ]]></Script>
  646. </Form>
  647. </FDL>