SPSTP02100_통합환자집계.xfdl 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPSTP02100" position="absolute 0 0 1203 781" titletext="환자집계" oninit="SPSTP02100_oninit" onload="SPSTP02100_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div id="Div00" taborder="4" position="absolute 0 24 1195 64" class="div_SA" anchor="left top right"/>
  8. <Shape position="absolute 1113 30 1119 57" linetype="vertical" id="line13" anchor="top right"/>
  9. <Static text="조회기간 :" position="absolute 12 36 98 53" id="caption21" class="search_name"/>
  10. <Button position="absolute 1130 34 1186 54" id="btn_search" class="btn1" taborder="3" text="조회" anchor="top right" onclick="btn_search_onclick"/>
  11. <Button position="absolute 1145 74 1195 93" id="btn_excel" class="btn7" text="엑셀" anchor="top right" onclick="btn_excel_onclick"/>
  12. <Static text="환자집계" position="absolute 0 0 120 24" align="align:center middle;" id="cap_title" class="tit_1"/>
  13. <Static text="~" position="absolute 206 38 221 53" id="caption6"/>
  14. <Calendar position="absolute 99 35 202 54" align="align:center middle;" id="ipt_fromdd" class="input_search" taborder="1" autoselect="true" autoskip="true"/>
  15. <Calendar position="absolute 219 35 322 54" align="align:center middle;" id="ipt_todd" class="input_search" taborder="2" autoselect="true"/>
  16. <Static text="조회 결과" position="absolute 0 77 90 99" id="caption1" class="tit_2"/>
  17. <Shape position="absolute 0 93 1195 99" linetype="horizontal" id="line1" class="line_10" anchor="left top right"/>
  18. <Grid position="absolute 0 98 1195 773" id="grd_main" autoenter="select" cellsizingtype="col" anchor="all" binddataset="ds_main_gridlist_gridinfo">
  19. <Formats>
  20. <Format id="default">
  21. <Columns/>
  22. <Band id="head"/>
  23. <Band id="body"/>
  24. </Format>
  25. </Formats>
  26. </Grid>
  27. <CheckBox position="absolute 535 32 620 52" id="chk_sumflag" visible="false" text="누적값 조회" truevalue="Y"/>
  28. <Static text="일자기준 :" position="absolute 345 37 440 54" id="cap_genrflag" class="search_name" visible="false"/>
  29. <Radio position="absolute 435 34 601 57" id="rdo_genrflag" visible="false" columncount="2" codecolumn="codecolumn" datacolumn="datacolumn">
  30. <Dataset id="innerdataset">
  31. <ColumnInfo>
  32. <Column id="codecolumn"/>
  33. <Column id="datacolumn"/>
  34. </ColumnInfo>
  35. <Rows>
  36. <Row>
  37. <Col id="codecolumn">G</Col>
  38. <Col id="datacolumn">정산요청일</Col>
  39. </Row>
  40. <Row>
  41. <Col id="codecolumn">O</Col>
  42. <Col id="datacolumn">진료일</Col>
  43. </Row>
  44. </Rows>
  45. </Dataset>
  46. </Radio>
  47. <Static text="입원/외래 :" position="absolute 345 36 440 53" id="cap_brate" class="search_name" visible="false"/>
  48. <Combo position="absolute 445 34 505 53" id="cmb_brate" class="input_search" visible="false" codecolumn="codecolumn" datacolumn="datacolumn" onitemchanged="cmb_brate_onitemchanged">
  49. <Dataset id="innerdataset">
  50. <ColumnInfo>
  51. <Column id="codecolumn"/>
  52. <Column id="datacolumn"/>
  53. </ColumnInfo>
  54. <Rows>
  55. <Row>
  56. <Col id="codecolumn">T</Col>
  57. <Col id="datacolumn">전체</Col>
  58. </Row>
  59. <Row>
  60. <Col id="codecolumn">I</Col>
  61. <Col id="datacolumn">입원</Col>
  62. </Row>
  63. <Row>
  64. <Col id="codecolumn">O</Col>
  65. <Col id="datacolumn">외래</Col>
  66. </Row>
  67. </Rows>
  68. </Dataset>
  69. </Combo>
  70. <Button position="absolute 940 33 1020 55" id="btn_file" class="btn4" text="파일생성" anchor="top right" onclick="btn_file_onclick"/>
  71. <Button position="absolute 1025 33 1105 55" id="btn_log" class="btn4" text="생성로그" anchor="top right" onclick="btn_log_onclick"/>
  72. <Static text="진료구분 :" position="absolute 345 36 431 53" id="cap_ordflag" class="search_name" visible="false"/>
  73. <cp_checkboxList id="chk_ordflag" titletext="CheckBox List" taborder="5" scrollbars="none" position="absolute 432 33 621 61" style="background:transparent; " col="1" row="1" cellspacing="2" vcellspacing="0" itemWidth="100" itemHeight="20" overflow="visible" visible="false"/>
  74. </Layout>
  75. </Layouts>
  76. <Objects>
  77. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  78. <ColumnInfo>
  79. <Column id="fromdd" type="STRING" size="256"/>
  80. <Column id="todd" type="STRING" size="256"/>
  81. <Column id="srchflag" type="STRING" size="256"/>
  82. <Column id="dayflag" type="STRING" size="256"/>
  83. <Column id="brateflag" type="STRING" size="256"/>
  84. <Column id="accflag" type="STRING" size="256"/>
  85. <Column id="genrflag" type="STRING" size="256"/>
  86. <Column id="batchflag" type="STRING" size="256"/>
  87. <Column id="ordflag" type="STRING" size="256"/>
  88. </ColumnInfo>
  89. <Rows>
  90. <Row>
  91. <Col id="fromdd"/>
  92. <Col id="todd"/>
  93. <Col id="srchflag"/>
  94. <Col id="dayflag"/>
  95. <Col id="brateflag">T</Col>
  96. <Col id="accflag">N</Col>
  97. <Col id="genrflag">G</Col>
  98. <Col id="batchflag">P</Col>
  99. <Col id="ordflag">I O S</Col>
  100. </Row>
  101. </Rows>
  102. </Dataset>
  103. <Dataset id="ds_main_gridlist_gridinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  104. <Dataset id="ds_chk_ordflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  105. <ColumnInfo>
  106. <Column id="label" type="STRING" size="256"/>
  107. <Column id="value" type="STRING" size="256"/>
  108. </ColumnInfo>
  109. <Rows>
  110. <Row>
  111. <Col id="label">입원</Col>
  112. <Col id="value">I</Col>
  113. </Row>
  114. <Row>
  115. <Col id="label">외래</Col>
  116. <Col id="value">O</Col>
  117. </Row>
  118. <Row>
  119. <Col id="label">건진</Col>
  120. <Col id="value">S</Col>
  121. </Row>
  122. </Rows>
  123. </Dataset>
  124. <Dataset id="ds_temp_header" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  125. <Dataset id="ds_temp_gridlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  126. </Objects>
  127. <Bind>
  128. <BindItem id="item0" compid="ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
  129. <BindItem id="item1" compid="ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
  130. <BindItem id="item2" compid="cmb_brate" propid="value" datasetid="ds_send" columnid="brateflag"/>
  131. <BindItem id="item3" compid="rdo_genrflag" propid="value" datasetid="ds_send" columnid="genrflag"/>
  132. <BindItem id="item4" compid="chk_sumflag" propid="value" datasetid="ds_send" columnid="accflag"/>
  133. </Bind>
  134. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  135. * System Name :
  136. * Job Name :
  137. * Creator :
  138. * Make Date : 2016-05-24
  139. * Description :
  140. *---------------------------------------------------------------------------------------
  141. * Modify Date Modifier Modify Description
  142. *---------------------------------------------------------------------------------------
  143. * 2016-05-24 Live Converter TF->XP
  144. *
  145. *---------------------------------------------------------------------------------------
  146. ****************************************************************************************/
  147. include "com_commonxp::comm_main.xjs";
  148. var arErrorCode = new HashArray();
  149. var FLAG = "";
  150. var FLAGNM = "";
  151. function SPSTP02100_oninit(obj:Form, e:InitEventInfo)
  152. {
  153. frmf_initForm(obj);
  154. }
  155. function SPSTP02100_onload(obj:Form, e:LoadEventInfo)
  156. {
  157. var sProp="col=3,row=1,cellspacing=4,vcellspacing=0,itemWidth=-1,itemHeight=20,overflow='visible'";
  158. chk_ordflag.setInitComp(sProp, ds_chk_ordflag,"value","label","fn_cmpEvent");
  159. ds_send.setColumn(0, "fromdd", utlf_getCurrentDate().toDate().getAddDate(-1).getDateFormat());
  160. ds_send.setColumn(0, "todd", utlf_getCurrentDate().toDate().getAddDate(-1).getDateFormat());
  161. //defalut 전체 선택
  162. chk_ordflag.setCheckAll(true);
  163. FLAG = frmf_getMenuParam();
  164. ds_send.setColumn(0, "srchflag", FLAG);
  165. var titlesize = 120;
  166. if (FLAG == "00")
  167. {
  168. FLAGNM = "과별 환자수 및 수익 집계";
  169. titlesize = 200;
  170. }
  171. else if (FLAG == "030101_O")
  172. {
  173. FLAGNM = "외래 처방 선수금 환자 집계";
  174. titlesize = 200;
  175. }
  176. else if (FLAG == "030101_I")
  177. {
  178. FLAGNM = "입원 선수금 환자 집계";
  179. titlesize = 200;
  180. }
  181. else if (FLAG == "030102_O")
  182. {
  183. FLAGNM = "외래 선수금 환자 집계";
  184. titlesize = 200;
  185. }
  186. else if (FLAG == "030102_I")
  187. {
  188. FLAGNM = "보관 퇴원금 환자 집계";
  189. titlesize = 200;
  190. }
  191. else if (FLAG == "040101")
  192. {
  193. FLAGNM = "감면 내역 환자 집계";
  194. titlesize = 200;
  195. cap_ordflag.position.top = 32;
  196. chk_ordflag.position.top = 32;
  197. cap_ordflag.visible = true;
  198. chk_ordflag.visible = true;
  199. }
  200. else if (FLAG == "0201_0203")
  201. {
  202. FLAGNM = "본인 부담 미수 환자 집계";
  203. titlesize = 200;
  204. cap_brate.visible = true;
  205. cmb_brate.visible = true;
  206. }
  207. else if (FLAG == "recalc")
  208. {
  209. FLAGNM = "환불 재정산 대상 환자 조회";
  210. titlesize = 200;
  211. cap_genrflag.position.top = 32;
  212. rdo_genrflag.position.top = 32;
  213. cap_genrflag.visible = true;
  214. rdo_genrflag.visible = true;
  215. }
  216. else if (FLAG == "fore")
  217. {
  218. FLAGNM = "외국인 환자 수납 내역 조회";
  219. titlesize = 200;
  220. cap_ordflag.position.top = 32;
  221. chk_ordflag.position.top = 32;
  222. cap_ordflag.visible = true;
  223. chk_ordflag.visible = true;
  224. }
  225. else if (FLAG == "tax")
  226. {
  227. FLAGNM = "부가세 내역 조회";
  228. titlesize = 200;
  229. }
  230. cap_title.text = FLAGNM;
  231. cap_title.position.width = titlesize;
  232. }
  233. function fn_cmpEvent()
  234. {
  235. var rtn = chk_ordflag.getData();
  236. ds_send.setColumn(0, "ordflag", rtn);
  237. }
  238. function btn_search_onclick(obj:Button, e:ClickEventInfo)
  239. {
  240. if (String(FLAG).length < 1)
  241. {
  242. return;
  243. }
  244. if (chk_ordflag.visible && utlf_isNull(ds_send.getColumn(0, "ordflag")))
  245. {
  246. sysf_messageBox("진료구분은 적어도 하나 이상 선택해야 합니다.", "E999");
  247. return;
  248. }
  249. ds_send.setColumn(0, "dayflag", (ds_send.getColumn(0, "fromdd") == ds_send.getColumn(0, "todd")) ? "Y" : "N");
  250. fSetDynamicGrid(grd_main, "ds_main_gridlist_gridinfo", "TRSTP02101");
  251. var cnt = ds_main_gridlist_gridinfo.rowcount;
  252. var color = "transparent";
  253. for (var i = 0; i < cnt; i++)
  254. {
  255. var sflag = ds_main_gridlist_gridinfo.getColumn(i, "sumflag");
  256. if (sflag == "S")
  257. {
  258. color = "#ffffc8";
  259. dsf_makeValue(ds_main_gridlist_gridinfo, "bgColor", "string", color, i);
  260. dsf_makeValue(ds_main_gridlist_gridinfo, "fontStyle", "string", "arial,9,bold", i);
  261. }
  262. else if (sflag == "T")
  263. {
  264. color = "#ffffa0";
  265. dsf_makeValue(ds_main_gridlist_gridinfo, "bgColor", "string", color, i);
  266. dsf_makeValue(ds_main_gridlist_gridinfo, "fontStyle", "string", "arial,9,bold", i);
  267. }
  268. }
  269. }
  270. function fSetDynamicGrid(grd, ref, sid)
  271. {
  272. ds_temp_header.clearData();
  273. ds_temp_gridlist.clearData();
  274. eval(ref).clearData();
  275. var cols = grd.getFormatColCount();
  276. for (var i = cols; i >= 0; i--)
  277. {
  278. grd.deleteContentsCol(i);
  279. }
  280. var oParam = {};
  281. oParam.id = "TRSTP02101";
  282. oParam.service = "stspamapp.StsPam";
  283. oParam.method = "reqGetPtMagm";
  284. oParam.inds = "req=ds_send";
  285. oParam.outds = "ds_temp_header=header ds_temp_gridlist=gridinfo";
  286. oParam.async = false;
  287. //oParam.callback = "cf_TRSTP02101";
  288. tranf_submit(oParam);
  289. var attr = ds_temp_header.getColumn(0, "attr");
  290. if (utlf_isNull(attr) || String(attr).length < 1)
  291. {
  292. if(grd.getCellCount("Head")>0)
  293. {
  294. grd.setCellProperty("Head", 0, "text", "");
  295. }
  296. return;
  297. }
  298. var gridCaption = ds_temp_header.getColumn(0, "caption");
  299. var titleArr = gridCaption.split("|"); // '|'로 입력된 Head값 처리를 위해 변경함 kimdo3, 2017-03-25
  300. var refarr = new Array();
  301. var k = 0;
  302. for(var i = 0; i < titleArr.length; i++)
  303. {
  304. grd.appendContentsRow("head");
  305. var s_titleArr = titleArr[i].split("^");
  306. for(var j = 0; j < s_titleArr.length; j++)
  307. {
  308. // 0 번째 컬럼은 이미 생성, 하나 줄여서 컬럼 생성해야하므로 j > 0 보다 큰 조건을 줌
  309. if(i == 0 && j > 0)
  310. {
  311. grd.appendContentsCol();
  312. }
  313. refarr[k] = s_titleArr[j];
  314. k++;
  315. }
  316. }
  317. // head Text 지정
  318. for(var i = 0; i < refarr.length; i++)
  319. {
  320. grd.setCellProperty("head", i, "text", refarr[i]);
  321. }
  322. grd.appendContentsRow("body");
  323. // Column Bind setting
  324. var attrArr = String(attr).split("^");
  325. var col = "";
  326. var type = "";
  327. var font = "";
  328. var align = "";
  329. var chk_Font = new Array();
  330. var cnt = 0;
  331. for(var i = 0; i < attrArr.length; i++)
  332. {
  333. var dataType = String(attrArr[i]).replace("; ", ",");
  334. var s_dataType = dataType.split(",");
  335. for(var j = 0; j < s_dataType.length; j++)
  336. {
  337. if(String(s_dataType[j]).indexOf("ref") == 0)
  338. {
  339. col = String(s_dataType[j]).replace("ref:", "");
  340. grd.setCellProperty("Body", i, "text", "bind:"+col);
  341. }
  342. if(String(s_dataType[j]).indexOf("type") == 0)
  343. {
  344. type = String(s_dataType[j]).replace("type:", "");
  345. if(type == "Number")
  346. {
  347. grd.setCellProperty("Body", i, "displaytype", "number");
  348. }
  349. else
  350. {
  351. grd.setCellProperty("Body", i, "displaytype", "normal");
  352. }
  353. }
  354. if(String(s_dataType[j]).indexOf("visibility") == 0)
  355. {
  356. visibility = String(s_dataType[j]).replace("visibility:", "");
  357. if(visibility == "hidden")
  358. {
  359. grd.setCellProperty("Head", i, "size", 0);
  360. }
  361. }
  362. if(String(s_dataType[j]).indexOf("text-align") == 0)
  363. {
  364. align = String(s_dataType[j]).replace("text-align:", "");
  365. grd.setCellProperty("Body", i, "align", align+" middle");
  366. }
  367. //Grid Background Setting
  368. grd.setCellProperty("Body", i, "background", "BIND(bgColor)");
  369. grd.setCellProperty("Body", i, "background2", "BIND(bgColor)");
  370. if(String(s_dataType[j]).indexOf("font-weight") == 0)
  371. {
  372. chk_Font[cnt] = i;
  373. cnt++;
  374. }
  375. }
  376. }
  377. var width = ds_temp_header.getColumn(0, "width");
  378. var widthArr = String(width).split("^");
  379. // 컬럼 사이즈 조절을 위한 for문
  380. for(var i = 0; i < widthArr.length; i++)
  381. {
  382. grd.setFormatColProperty(i, "size", widthArr[i]);
  383. }
  384. //Grid Font Setting
  385. cnt = 0;
  386. for(var k = 0; k < grd_main.getCellCount("body"); k++)
  387. {
  388. if(k == chk_Font[cnt])
  389. {
  390. grd.setCellProperty("Body", k, "font", "arial,9,bold");
  391. cnt++;
  392. }
  393. else
  394. {
  395. grd.setCellProperty("Body", k, "font", "BIND(fontStyle)");
  396. }
  397. }
  398. //Grid Merge Setting
  399. grdTitleMerge(grd);
  400. eval(ref).copyData(ds_temp_gridlist);
  401. }
  402. function grdTitleMerge(grid)
  403. {
  404. var headCols = grid.getCellCount("body");
  405. var headCells = grid.getCellCount("head");
  406. var headArrR1 = new Array();
  407. var headArrR2 = new Array();
  408. var headArrR3 = new Array();
  409. var headArrR2No = new Array();
  410. var headArrR3No = new Array();
  411. var headArrR2NoIdx = 0;
  412. var headArrR3NoIdx = 0;
  413. var headArrMer12No = "";
  414. var headArrMer13No = "";
  415. var headArrMer12NoIdx = 0;
  416. var headArrMer13NoIdx = 0;
  417. var mergeScol = 0;
  418. var mergeEcol = 0;
  419. var index = 0;
  420. var calindex = 0;
  421. var calindex1 = 0;
  422. var calindex11 = 0;
  423. grid.splitContentsCell("head",0,0,3,headCols,true);
  424. for(var i=0; i<headCells;i++)
  425. {
  426. if( parseInt(i/headCols)==0 )
  427. {
  428. headArrR1[i%headCols] = grid.getCellText(-1,i);
  429. }
  430. if( parseInt(i/headCols)==1 )
  431. {
  432. headArrR2[i%headCols] = grid.getCellText(-1,i);
  433. }
  434. if( parseInt(i/headCols)==2 )
  435. {
  436. headArrR3[i%headCols] = grid.getCellText(-1,i);
  437. }
  438. }//for(var i=0; i<headCells;i++) 끝
  439. //로우 병합
  440. for(var i = 0; i < headCols; i++)
  441. {
  442. if(headArrR1[i]==headArrR2[i])
  443. {
  444. index = i;
  445. calindex++;
  446. grid.mergeContentsCell("head",0,i,1,i,index,false);
  447. headArrMer12No+=i+"^";
  448. headArrMer12NoIdx++;
  449. }
  450. else
  451. {
  452. headArrR2No[headArrR2NoIdx]=i;
  453. headArrR2NoIdx++;
  454. }
  455. if(headArrR2[i]==headArrR3[i])
  456. {
  457. index = eval(i)+eval(headCols)-calindex;
  458. grid.mergeContentsCell("head",1,i,2,i,index,false);
  459. calindex1++;
  460. if(headArrR2[i]==headArrR1[i])
  461. {
  462. index = eval(i)+eval(headCols)-calindex;
  463. grid.mergeContentsCell("head",0,i,2,i,i,false);
  464. calindex11++;
  465. headArrMer13No+=i+"^";
  466. headArrMer13NoIdx++;
  467. }
  468. }
  469. else
  470. {
  471. headArrR3No[headArrR3NoIdx]=i;
  472. headArrR3NoIdx++;
  473. }
  474. }//for(var i=0; i<headCols; i++) 끝
  475. //배치가 바뀌어 재분배
  476. var headCells2 = grid.getCellCount("head");
  477. var headArr1 = new Array();
  478. var headArr2 = new Array();
  479. var headArr3 = new Array();
  480. var headArr3idx = 0;
  481. var headArr2idx = 0;
  482. for(var i=0; i<headCells2;i++)
  483. {
  484. if( parseInt(i/headCols)==0 )
  485. {
  486. headArr1[i%headCols] = grid.getCellText(-1,i);
  487. }
  488. else if( eval(i)< headCols*2-eval(calindex))
  489. {
  490. headArr2[headArr2idx] = grid.getCellText(-1,i);
  491. headArr2idx++;
  492. }
  493. else
  494. {
  495. headArr3[headArr3idx] = grid.getCellText(-1,i);
  496. headArr3idx++;
  497. }
  498. }//for(var i=0; i<headCells;i++) 끝
  499. //컬럼 병합
  500. var tmp1 = "";
  501. var tmp1idx = 0;
  502. var tmp2 = "";
  503. var tmp2idx = 0;
  504. var col = 0;
  505. var index = 0;
  506. var calcolindex = 0;
  507. for(var i=0; i<headArr1.length;i++)
  508. {
  509. if(i==0)
  510. {
  511. tmp1 = headArr1[0];
  512. tmp1idx = 0;
  513. }
  514. else
  515. {
  516. tmp2 = headArr1[i];
  517. tmp2idx = i;
  518. }
  519. idx = i-calcolindex-1;
  520. if(tmp1==tmp2)
  521. {
  522. grid.mergeContentsCell("head",0,tmp1idx,0,tmp2idx,idx,false);
  523. calcolindex++;
  524. }
  525. else
  526. {
  527. tmp1 = headArr1[i];
  528. tmp1idx = i;
  529. }
  530. }//for(var i=0; headArr1.legnth();i++) 끝
  531. var tmp1 = "!";
  532. var tmp2 = "!";
  533. var tmp2idx = 0;
  534. var calcolindex1 = 0;
  535. var idx = 0;
  536. for(var i=0; i<headArr2.length;i++)
  537. {
  538. if(i==0)
  539. {
  540. tmp1 = headArr2[0];
  541. tmp1idx = 0;
  542. }
  543. else
  544. {
  545. tmp2 = headArr2[i];
  546. tmp2idx = headArrR2No[i];
  547. }
  548. var cnt12R = biggerCnt(headArrR2No[i],headArrMer12No);
  549. idx = (headCols+headArrR2No[i]) - calcolindex - eval(calindex) + cnt12R - eval(calcolindex1)-1;
  550. if(tmp1==tmp2)
  551. {
  552. grid.mergeContentsCell("head",1,tmp1idx,1,tmp2idx,idx,false);
  553. calcolindex1++;
  554. }
  555. else
  556. {
  557. tmp1 = headArr2[i];
  558. tmp1idx = headArrR2No[i];
  559. }
  560. }//for(var i=0; headArr2.legnth();i++) 끝
  561. var tmp1 = "!";
  562. var tmp2 = "!";
  563. var tmp2idx = 0;
  564. var calcolindex11 = 0;
  565. for(var i=0; i<headArr3.length; i++)
  566. {
  567. if(i==0)
  568. {
  569. tmp1 = headArr3[0];
  570. tmp1idx = 0;
  571. }
  572. else
  573. {
  574. tmp2 = headArr3[i];
  575. tmp2idx = headArrR3No[i];
  576. }
  577. var cnt13R = biggerCnt(headArrR3No[i],headArrMer13No);
  578. idx = (headCols*2+headArrR3No[i]) - calcolindex - calcolindex1 - calcolindex11 - calindex - calindex1 + cnt13R;
  579. if(tmp1==tmp2)
  580. {
  581. grid.mergeContentsCell("head",2,tmp1idx,2,tmp2idx,idx,false);
  582. calcolindex11++;
  583. }
  584. else
  585. {
  586. tmp1 = headArr3[i];
  587. tmp1idx = headArrR3No[i];
  588. }
  589. }
  590. }
  591. function biggerCnt(num,idxArr)
  592. {
  593. var rtn=0;
  594. var arr = new Array();
  595. var idxA = new String(idxArr);
  596. arr = idxA.substr(0,idxA.length-1).split("^");
  597. for(var i=0; i<arr.length; i++)
  598. {
  599. if(num<arr[i])
  600. {
  601. rtn++;
  602. }
  603. }
  604. return rtn;
  605. }
  606. function cmb_brate_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  607. {
  608. ds_send.setColumn(0, "accflag", obj.value);
  609. }
  610. function btn_file_onclick(obj:Button, e:ClickEventInfo)
  611. {
  612. ds_send.setColumn(0, "dayflag", (ds_send.getColumn(0, "fromdd") == ds_send.getColumn(0, "todd")) ? "Y" : "N");
  613. var oParam = {};
  614. oParam.id = "TXSTP01804";
  615. oParam.service = "stspamapp.StsPam";
  616. oParam.method = "reqExePamFileBatch";
  617. oParam.inds = "req=ds_send";
  618. oParam.async = false;
  619. //oParam.callback = "cf_TXSTP01804";
  620. tranf_submit(oParam);
  621. btn_log.click();
  622. }
  623. function btn_log_onclick(obj:Button, e:ClickEventInfo)
  624. {
  625. var todd = utlf_getCurrentDate();
  626. todd = todd.toDate().getAddDate(1, "D").getDateFormat();
  627. var objArg = new Object();
  628. objArg.todd = todd;
  629. objArg.execrid = sysf_getUserId();
  630. objArg.prgmid = "StsPamFileBatch";
  631. frmf_open("SPZSB00301", "SPZSB00301", objArg, "","","","","","","","","","M");
  632. }
  633. function btn_excel_onclick(obj:Button, e:ClickEventInfo)
  634. {
  635. var day = ds_send.getColumn(0, "fromdd") + "-" + ds_send.getColumn(0, "todd")
  636. grdf_exportExcel(grd_main, cap_title.text + "_" + day, FLAGNM, "true", "", "");
  637. sysf_messageBox("엑셀 저장이 완료되었습니다.", "I999");
  638. }
  639. ]]></Script>
  640. </Form>
  641. </FDL>