SMRAT00110_세금계산서합계표관리.xrw 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
  3. <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
  4. <xhtml:head>
  5. <xhtml:title>DTI-NU 중복 Mapping 검증</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <taxsum>
  11. <taxsumlist/>
  12. </taxsum>
  13. </main>
  14. <send>
  15. <condition>
  16. <instcd/>
  17. <yyyy/>
  18. <taxbillkind>4</taxbillkind>
  19. <taxbillflag>1</taxbillflag>
  20. <reptkind/>
  21. <entrregno/>
  22. <custnm/>
  23. <isscust/>
  24. <ntsappryn/>
  25. </condition>
  26. <taxsum>
  27. <taxsumlist/>
  28. </taxsum>
  29. </send>
  30. <init>
  31. <init_taxbillkind>
  32. <item>
  33. <label>세금계산서</label>
  34. <value>4</value>
  35. </item>
  36. <item>
  37. <label>계산서</label>
  38. <value>5</value>
  39. </item>
  40. </init_taxbillkind>
  41. <init_taxbillflag>
  42. <item>
  43. <label>매입</label>
  44. <value>1</value>
  45. </item>
  46. <item>
  47. <label>매출</label>
  48. <value>2</value>
  49. </item>
  50. </init_taxbillflag>
  51. <init_reptkind>
  52. <item>
  53. <label>1기예정</label>
  54. <value>1</value>
  55. </item>
  56. <item>
  57. <label>1기확정</label>
  58. <value>2</value>
  59. </item>
  60. <item>
  61. <label>2기예정</label>
  62. <value>3</value>
  63. </item>
  64. <item>
  65. <label>2기확정</label>
  66. <value>4</value>
  67. </item>
  68. </init_reptkind>
  69. </init>
  70. <temp/>
  71. <hidden>
  72. </hidden>
  73. </root>
  74. </instance>
  75. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  76. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  77. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  78. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  79. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  80. <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
  81. <script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
  82. <script type="javascript" ev:event="xforms-ready">
  83. <![CDATA[
  84. fInitialize();
  85. ]]>
  86. </script>
  87. <script type="javascript">
  88. <![CDATA[
  89. function fInitialize()
  90. {
  91. model.removeNodeset(grd_taxsumlist.nodeset);
  92. model.setValue("/root/send/condition/instcd", getUserInfo("dutplceinstcd"));
  93. grd_taxsumlist.rowHeight(0) = 35;
  94. model.setValue(ipt_yyyy.attribute("ref"), getCurrentDate().substr(0, 4));
  95. fSetReptKind();
  96. model.refresh();
  97. }
  98. function fSetReptKind()
  99. {
  100. var sMonth = getCurrentDate().substr(4, 2);
  101. if(sMonth == "01" || sMonth == "02" || sMonth == "03")
  102. {
  103. model.setValue(rdo_reptkind.attribute("ref"), "1");
  104. }
  105. else if(sMonth == "04" || sMonth == "05" || sMonth == "06")
  106. {
  107. model.setValue(rdo_reptkind.attribute("ref"), "2");
  108. }
  109. else if(sMonth == "07" || sMonth == "08" || sMonth == "09")
  110. {
  111. model.setValue(rdo_reptkind.attribute("ref"), "3");
  112. }
  113. else if(sMonth == "10" || sMonth == "11" || sMonth == "12")
  114. {
  115. model.setValue(rdo_reptkind.attribute("ref"), "4");
  116. }
  117. model.refresh();
  118. }
  119. function fInputExcel(pGrid)
  120. {
  121. var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  122. if(fileName != "") {
  123. pGrid.loadExcel(fileName, 1, true);
  124. pGrid.deleteRow(1);
  125. pGrid.rebuild();
  126. return true;
  127. }
  128. return false;
  129. }
  130. function fAutoSearch(vRow, SearchFlag)
  131. {
  132. if(SearchFlag == "Y")
  133. {
  134. if(model.getValue("/root/hidden/condition/autodate") == "Y")
  135. {
  136. model.setValue(ipt_fromdd_1.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("makedd")));
  137. model.setValue(ipt_todd_1.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("makedd")));
  138. }
  139. model.setValue(ipt_entrregno.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("custcd")));
  140. model.setValue(ipt_custnm.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("custnm")));
  141. model.setValue(rdo_taxbillflag.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("etaxbillflag")));
  142. model.refresh();
  143. btn_search_1.dispatch("DOMActivate");
  144. }
  145. for(var i = grd_connectablelist.fixedRows ; i < grd_connectablelist.rows ; i++)
  146. {//alert(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("suplamt")));
  147. //alert(grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("suplamt")));
  148. if( grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("custcd")) == grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("entrregno"))
  149. && grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("suplamt")) == grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("suplamt"))
  150. && grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("valaddtax")) == grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("valaddtax"))
  151. && grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("amt")) == grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("amt")))
  152. { //alert();
  153. grd_connectablelist.rowstyle(i, "data", "background-color") = "#ffff00";
  154. grd_disconnectedlist.rowstyle(vRow, "data", "background-color") = "#ffff00";
  155. }
  156. }
  157. model.refresh();
  158. }
  159. ]]>
  160. </script>
  161. <bind id="bindSecPageCnt" ref="/root/send/printparams/secPageCnt" calculate="count(/root/main/printlist/secpage)"/>
  162. <bind id="bindAllEtcProf" ref="/root/send/printparams/allEtcProf" calculate="count(/root/main/list/etcproflist)"/>
  163. <bind id="bindAllCount" ref="/root/send/printparams/allCount" calculate="sum(/root/main/list/etcproflist/cnt)"/>
  164. <bind id="bindPayTotAmt" ref="/root/send/printparams/payTotAmt" calculate="sum(/root/main/list/etcproflist/paytotamt)"/>
  165. <bind id="bindProfTax" ref="/root/send/printparams/profTax" calculate="sum(/root/main/list/etcproflist/proftax)"/>
  166. <bind id="bindIncmTax" ref="/root/send/printparams/incmTax" calculate="sum(/root/main/list/etcproflist/incmtax)"/>
  167. <bind id="bindResdnTax" ref="/root/send/printparams/resdnTax" calculate="sum(/root/main/list/etcproflist/resdntax)"/>
  168. <bind id="bindSumAmt" ref="/root/send/printparams/sumAmt" calculate="sum(/root/main/list/etcproflist/sumamt)"/>
  169. <bind id="bindPayAmt" ref="/root/send/printparams/payAmt" calculate="sum(/root/main/list/etcproflist/payamt)"/>
  170. <bind id="bindChkCnt" ref="/root/hidden/checkedcnt" calculate="count(/root/main/list/etcproflist[chk='Y']/chk)"/>
  171. <submission id="TRRAT00312" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition2" resultref="/root/main/connectable"/>
  172. <submission id="TXRAT00312" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/connectable/connectablelist" resultref="/root/temp"/>
  173. <submission id="TXRAT00313" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition1" resultref="/root/temp"/>
  174. <submission id="TXRAT00314" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/disconnected/disconnectedlist" resultref="/root/temp"/>
  175. <submission id="TRRAT00111" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/taxsum"/>
  176. <submission id="TXRAT00111" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/taxsum/taxsumlist" resultref="/root/temp"/>
  177. </model>
  178. </xhtml:head>
  179. <xhtml:body pagewidth="1211" pageheight="784" guideline="1,1193;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  180. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  181. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">세금계산서 합계표 관리</caption>
  182. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  183. </group>
  184. <group id="group3" scroll="auto" style="left:0px; top:13px; width:1195px; height:762px; ">
  185. <group id="grp_sea" style="left:0px; top:30px; width:1193px; height:65px; vertical-align:top; ">
  186. <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:65px; background-color:#fffbf2; border-color:#ffd799; "/>
  187. <line id="line5" class="line_4" style="x1:1099px; y1:19px; x2:1099px; y2:42px; border-color:#ffe4bb; border-left-style:solid; "/>
  188. <caption id="caption1" class="search_name" style="left:505px; top:10px; width:105px; height:17px; ">조 회 일 자 :</caption>
  189. <button id="btn_search" class="btn1_letter2" navindex="4" style="left:1115px; top:20px; width:56px; height:22px; text-align:left; ">
  190. <caption>조회</caption>
  191. <script type="javascript" ev:event="DOMActivate">
  192. <![CDATA[
  193. model.removeNodeset(grd_taxsumlist.nodeset);
  194. grd_taxsumlist.refresh();
  195. submit("TRRAT00111");
  196. for(var i = grd_taxsumlist.fixedRows ; i < grd_taxsumlist.rows ; i++)
  197. {
  198. if(grd_taxsumlist.valueMatrix(i, grd_taxsumlist.colRef("custnm")) == "")
  199. {
  200. grd_taxsumlist.cellStyle("background-color", i, grd_taxsumlist.colRef("custcd")) = "#ff6600";
  201. }
  202. }
  203. model.refresh();
  204. ]]>
  205. </script>
  206. </button>
  207. <select1 id="rdo_billflag" ref="/root/send/condition/taxbillflag" class="radio_search" disabled="false" navindex="4" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:330px; top:34px; width:165px; height:20px; vertical-align:middle; border-style:none; ">
  208. <choices>
  209. <itemset nodeset="/root/init/init_taxbillflag/item">
  210. <label ref="label"/>
  211. <value ref="value"/>
  212. </itemset>
  213. </choices>
  214. <script type="javascript" ev:event="xforms-value-changed">
  215. <![CDATA[
  216. model.setValue(rdo_billflag.attribute("ref"), model.getValue(rdo_billflag.attribute("ref")));
  217. rdo_billflag.refresh();
  218. ]]>
  219. </script>
  220. </select1>
  221. <caption id="caption8" class="search_name" style="left:225px; top:35px; width:109px; height:17px; ">계산서구분 :</caption>
  222. <caption id="caption3" class="search_name" style="left:505px; top:35px; width:104px; height:17px; ">사업자번호 :</caption>
  223. <input id="ipt_regnm" ref="/root/send/condition/custnm" navindex="6" imemode="hangul" style="left:727px; top:34px; width:148px; height:19px; ">
  224. <script type="javascript" ev:event="onkeypress">
  225. <![CDATA[
  226. if(event.keyCode == 13)
  227. {
  228. racfCustValidCheck("entrregno,custnm", "name");
  229. }
  230. ]]>
  231. </script>
  232. <script type="javascript" ev:event="xforms-value-changed">
  233. <![CDATA[
  234. racfCustValidCheck("entrregno,custnm", "name");
  235. ]]>
  236. </script>
  237. </input>
  238. <button id="btn_entregnohelp" class="icon_search" style="left:709px; top:34px; width:16px; height:16px; ">
  239. <caption/>
  240. <script type="javascript" ev:event="DOMActivate">
  241. <![CDATA[
  242. misfOpenPopUpList("14", ipt_regno, "", "entrregno,custnm");
  243. model.refresh();
  244. ]]>
  245. </script>
  246. </button>
  247. <input id="ipt_regno" ref="/root/send/condition/entrregno" navindex="5" format="999-99-99999" style="left:610px; top:34px; width:95px; height:19px; text-align:center; ">
  248. <script type="javascript" ev:event="onkeypress">
  249. <![CDATA[
  250. if(event.keyCode == 13)
  251. {
  252. racfCustValidCheck("entrregno,custnm", "code");
  253. }
  254. ]]>
  255. </script>
  256. <script type="javascript" ev:event="xforms-value-changed">
  257. <![CDATA[
  258. racfCustValidCheck("entrregno,custnm", "code");
  259. ]]>
  260. </script>
  261. </input>
  262. <select1 id="rdo_reptkind" ref="/root/send/condition/reptkind" class="radio_search" navindex="2" overflow="visible" appearance="full" cellspacing="10" cols="4" style="left:610px; top:10px; width:275px; height:20px; vertical-align:middle; border-style:none; ">
  263. <choices>
  264. <itemset nodeset="/root/init/init_reptkind/item">
  265. <label ref="label"/>
  266. <value ref="value"/>
  267. </itemset>
  268. </choices>
  269. </select1>
  270. <button id="button5" class="icon_next" navindex="-1" style="left:195px; top:11px; width:13px; height:15px; ">
  271. <caption/>
  272. <script type="javascript" ev:event="DOMActivate">
  273. <![CDATA[
  274. var vYYYY = model.getValue(ipt_yyyy.attribute("ref"));
  275. var vNum = parseInt(vYYYY, 10);
  276. if (vNum != 1)
  277. {
  278. vNum++;
  279. }
  280. else
  281. {
  282. return;
  283. }
  284. model.setValue(ipt_yyyy.attribute("ref"), vNum);
  285. ipt_yyyy.refresh();
  286. rdo_reptkind.dispatch("xforms-value-changed");
  287. ]]>
  288. </script>
  289. </button>
  290. <caption id="caption11" class="search_name" style="left:5px; top:10px; width:101px; height:17px; ">년 도 :</caption>
  291. <input id="ipt_yyyy" ref="/root/send/condition/yyyy" class="input_s_essential" navindex="1" maxlength="4" style="left:125px; top:10px; width:68px; height:19px; text-align:center; ">
  292. <script type="javascript" ev:event="xforms-value-changed">
  293. <![CDATA[
  294. rdo_reptkind.dispatch("xforms-value-changed");
  295. ]]>
  296. </script>
  297. </input>
  298. <button id="btn_pre" class="icon_pre" navindex="-1" style="left:110px; top:11px; width:13px; height:15px; ">
  299. <caption/>
  300. <script type="javascript" ev:event="DOMActivate">
  301. <![CDATA[
  302. var vYYYY = model.getValue(ipt_yyyy.attribute("ref"));
  303. var vNum = parseInt(vYYYY, 10);
  304. if (vNum != 1)
  305. {
  306. vNum--;
  307. }
  308. else
  309. {
  310. return;
  311. }
  312. model.setValue(ipt_yyyy.attribute("ref"), vNum);
  313. ipt_yyyy.refresh();
  314. rdo_reptkind.dispatch("xforms-value-changed");
  315. ]]>
  316. </script>
  317. </button>
  318. <caption id="caption2" class="search_name" style="left:225px; top:10px; width:99px; height:17px; ">계산서종류 :</caption>
  319. <select1 id="rdo_billkind" ref="/root/send/condition/taxbillkind" class="radio_search" navindex="3" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:330px; top:10px; width:165px; height:20px; vertical-align:middle; border-style:none; ">
  320. <choices>
  321. <itemset nodeset="/root/init/init_taxbillkind/item">
  322. <label ref="label"/>
  323. <value ref="value"/>
  324. </itemset>
  325. </choices>
  326. </select1>
  327. <select1 id="cmb_isscust" ref="/root/send/condition/isscust" class="combo_essential" navindex="4" appearance="minimal" style="left:985px; top:35px; width:110px; height:19px; ">
  328. <choices>
  329. <item>
  330. <label>전체</label>
  331. <value/>
  332. </item>
  333. <item>
  334. <label>매출자발행</label>
  335. <value>01</value>
  336. </item>
  337. <item>
  338. <label>매입자발행</label>
  339. <value>02</value>
  340. </item>
  341. </choices>
  342. </select1>
  343. <select1 id="cmb_ntsappryn" ref="/root/send/condition/ntsappryn" class="combo_essential" navindex="4" appearance="minimal" style="left:985px; top:10px; width:110px; height:19px; ">
  344. <choices>
  345. <item>
  346. <label>전체</label>
  347. <value/>
  348. </item>
  349. <item>
  350. <label>국세청승인</label>
  351. <value>Y</value>
  352. </item>
  353. <item>
  354. <label>국세청미승인</label>
  355. <value>N</value>
  356. </item>
  357. </choices>
  358. </select1>
  359. <caption id="caption20" class="search_name" style="left:895px; top:35px; width:125px; height:17px; ">발급구분 :</caption>
  360. <caption id="caption19" class="search_name" style="left:895px; top:10px; width:125px; height:17px; ">승인여부 :</caption>
  361. </group>
  362. <line id="line3" class="line_1" style="x1:0px; y1:120px; x2:1193px; y2:120px; "/>
  363. <datagrid id="grd_taxsumlist" nodeset="/root/main/taxsum/taxsumlist" backcoloralternate="#ffffff" caption="기관코드^국세청구분^신고년도^신고기간^계산서종류^계산서구분^발급구분^사업자등록번호^거래처명^공급가액^부가세액^합계^매수" colsep="^" colwidth="0, 100, 70, 60, 0, 0, 150, 100, 270, 100, 100, 100, 50" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:0px; top:125px; width:1193px; height:630px; ">
  364. <col ref="instcd"/>
  365. <col checkvalue="Y,N" ref="ntsflag" type="checkbox"/>
  366. <col ref="addtaxyy" style="text-align:left; "/>
  367. <col ref="addtaxpnt" type="combo" style="text-align:center; ">
  368. <choices>
  369. <itemset nodeset="/root/init/init_reptkind/item">
  370. <label ref="label"/>
  371. <value ref="value"/>
  372. </itemset>
  373. </choices>
  374. </col>
  375. <col ref="taxbillkind" type="combo">
  376. <choices>
  377. <itemset nodeset="/root/init/init_taxbillkind/item">
  378. <label ref="label"/>
  379. <value ref="value"/>
  380. </itemset>
  381. </choices>
  382. </col>
  383. <col ref="taxbillflag" type="combo">
  384. <choices>
  385. <itemset nodeset="/root/init/init_taxbillflag/item">
  386. <label ref="label"/>
  387. <value ref="value"/>
  388. </itemset>
  389. </choices>
  390. </col>
  391. <col ref="isskind" type="combo" style="text-align:center; ">
  392. <choices>
  393. <item>
  394. <label>사업자등록번호발행분</label>
  395. <value>01</value>
  396. </item>
  397. <item>
  398. <label>주민등록번호발행분</label>
  399. <value>02</value>
  400. </item>
  401. </choices>
  402. </col>
  403. <col ref="entrregno" style="text-align:center; "/>
  404. <col ref="custnm"/>
  405. <col ref="suplamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  406. <col ref="valaddtax" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  407. <col ref="amt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  408. <col ref="cnt"/>
  409. <script type="javascript" ev:event="ondblclick">
  410. <![CDATA[
  411. if(grd_disconnectedlist.col == grd_disconnectedlist.colRef("custcd"))
  412. {
  413. model.setValue(ipt_regno.attribute("ref"), grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("custcd")));
  414. model.setValue(ipt_regnm.attribute("ref"), grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("custnm")));
  415. ipt_regno.refresh();
  416. ipt_regnm.refresh();
  417. }
  418. else
  419. {
  420. fAutoSearch(grd_disconnectedlist.row, "Y");
  421. }
  422. ]]>
  423. </script>
  424. <script type="javascript" ev:event="xforms-value-changed">
  425. <![CDATA[
  426. if(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("custregflag")) == "N")
  427. {
  428. messageBox("거래처가 등록되어 있지 않습니다.", "I000");
  429. grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")) = "";
  430. grd_disconnectedlist.rowStatus(grd_disconnectedlist.row) = 0;
  431. return false;
  432. }
  433. //alert(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")));
  434. if(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")) == "Y")
  435. {
  436. //alert(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")));
  437. grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("instaxknd")) = "01";
  438. grd_disconnectedlist.isReadOnly(grd_disconnectedlist.row, grd_disconnectedlist.colRef("instaxknd")) = false;
  439. }
  440. else
  441. {
  442. //alert(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")));
  443. grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("instaxknd")) = "";
  444. grd_disconnectedlist.isReadOnly(grd_disconnectedlist.row, grd_disconnectedlist.colRef("instaxknd")) = true;
  445. grd_disconnectedlist.removeStatus(grd_disconnectedlist.row, "update");
  446. }
  447. grd_disconnectedlist.refresh();
  448. ]]>
  449. </script>
  450. <script type="javascript" ev:event="onaftersort">
  451. <![CDATA[
  452. grd_disconnectedlist.gridToInstance();
  453. ]]>
  454. </script>
  455. </datagrid>
  456. <caption id="caption21" class="tit_2" style="left:5px; top:102px; width:310px; height:13px; ">세금계산서 합계표 목록</caption>
  457. <group id="group2" scroll="auto" style="left:0px; top:0px; width:1195px; height:27px; ">
  458. <line id="line1" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  459. <button id="btn_print" class="btn4_letter2" visibility="hidden" style="left:5px; top:3px; width:56px; height:22px; ">
  460. <caption>출력</caption>
  461. <script type="javascript" ev:event="DOMActivate">
  462. <![CDATA[
  463. ]]>
  464. </script>
  465. </button>
  466. <button id="btn_save" class="btn4_letter2" style="left:1137px; top:3px; width:56px; height:22px; ">
  467. <caption>저장</caption>
  468. <script type="javascript" ev:event="DOMActivate">
  469. <![CDATA[
  470. fSave();
  471. fRetrieve();
  472. ]]>
  473. </script>
  474. </button>
  475. </group>
  476. <button id="btn_excel" class="btn2_letter4" style="left:1062px; top:98px; width:64px; height:19px; text-align:left; ">
  477. <caption>엑셀출력</caption>
  478. <script type="javascript" ev:event="DOMActivate">
  479. <![CDATA[
  480. var sTitle = "세금계산서 합계표 " + model.getValue(ipt_yyyy.attribute("ref")) + " 년 " + rdo_reptkind.label;
  481. grd_taxsumlist.rebuild();
  482. misfSaveExcel(grd_taxsumlist, sTitle);
  483. ]]>
  484. </script>
  485. </button>
  486. <button id="btn_excelupload" class="btn2_letter4" style="left:995px; top:98px; width:64px; height:19px; text-align:left; ">
  487. <caption>엑셀입력</caption>
  488. <script type="javascript" ev:event="DOMActivate">
  489. <![CDATA[
  490. model.removeNodeset(grd_taxsumlist.nodeset);
  491. grd_taxsumlist.refresh();
  492. if(fInputExcel(grd_taxsumlist))
  493. {
  494. if(grd_taxsumlist.rows > grd_taxsumlist.fixedRows)
  495. {
  496. for(var i = grd_taxsumlist.fixedRows ; i < grd_taxsumlist.rows ; i++)
  497. {
  498. grd_taxsumlist.rowStatus(i) = 1;
  499. grd_taxsumlist.valueMatrix(i, grd_taxsumlist.colRef("taxbillkind")) = model.getValue(rdo_billkind.attribute("ref"));
  500. grd_taxsumlist.valueMatrix(i, grd_taxsumlist.colRef("taxbillflag")) = model.getValue(rdo_billflag.attribute("ref"));
  501. grd_taxsumlist.valueMatrix(i, grd_taxsumlist.colRef("instcd")) = model.getValue("/root/send/condition/instcd");
  502. }
  503. model.setValue("/root/send/taxsum/taxsumlist", grd_taxsumlist.getUpdateData());
  504. submit("TXRAT00111");
  505. }
  506. }
  507. btn_search.dispatch("DOMActivate");
  508. ]]>
  509. </script>
  510. </button>
  511. <button id="btn_delrow" class="btn2_letter3" disabled="false" navindex="9" visibility="visible" style="left:1140px; top:98px; width:53px; height:19px; text-align:left; ">
  512. <caption>행삭제</caption>
  513. <script type="javascript" ev:event="DOMActivate">
  514. <![CDATA[
  515. if( ((grd_taxbilllist.valueMatrix(grd_taxbilllist.row, grd_taxbilllist.colRef("isscust")) == "01" && grd_taxbilllist.valueMatrix(grd_taxbilllist.row, grd_taxbilllist.colRef("taxbillflag")) == "2")
  516. || (grd_taxbilllist.valueMatrix(grd_taxbilllist.row, grd_taxbilllist.colRef("isscust")) == "02" && grd_taxbilllist.valueMatrix(grd_taxbilllist.row, grd_taxbilllist.colRef("taxbillflag")) == "1"))
  517. && (grd_taxbilllist.valueMatrix(grd_taxbilllist.row, grd_taxbilllist.colRef("inv_no")) != ""))// 발신 데이터 이면서 매핑자료일때는 지울수 없다.
  518. {
  519. return false;
  520. }
  521. if(grd_taxbilllist.valueMatrix(grd_taxbilllist.row, grd_taxbilllist.colRef("unsldd")) == "")
  522. {
  523. fAddDelRow("D");
  524. }
  525. ]]>
  526. </script>
  527. </button>
  528. </group>
  529. </xhtml:body>
  530. </xhtml:html>