ÀλçÁ¶°Ç°Ë»ö

= = AND AND OR OR ÀλçÁ¶°Ç°Ë»ö ÃʱâÈ­ Ç׸ñ±¸ºÐ <textarea id="txt_fromqry" ref="/root/init/fromqry" visibility="hidden" style="left:132px; top:440px; width:110px; height:130px; "/> <textarea id="txt_whereqry" ref="/root/init/whereqry" visibility="hidden" style="left:244px; top:440px; width:95px; height:130px; "/> </group> <group id="group2" style="left:355px; top:0px; width:835px; height:300px; "> <datagrid id="grd_where" nodeset="/root/main/list/tablewhere/tablewherelist" caption="Ç׸ñ^¿¬»êÀÚ^Á¶°Ç°ª^Á¶°Ç°ª2^¿¬°á" colsep="^" colwidth="193, 83, 338, 141, 54, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:2px; top:31px; width:831px; height:250px; "> <col ref="itemnm" type="inputbutton" _key="true"/> <col ref="operator" type="combo" _key="true"> <choices> <itemset nodeset="/root/init/operator"> <label ref="code"/> <value ref="cdnm"/> </itemset> </choices> </col> <col ref="condvalu1nm" _key="true"/> <col ref="condvalu2nm"/> <col ref="conector" type="combo" _key="true"> <choices> <itemset nodeset="/root/init/conector"> <label ref="cdnm"/> <value ref="code"/> </itemset> </choices> </col> <col ref="condvalu1" visibility="hidden"/> <col ref="condvalu2" visibility="hidden"/> <col ref="itemcls" visibility="hidden"/> <col ref="itemseq" visibility="hidden"/> <col ref="itemflag" visibility="hidden"/> <col ref="itemkind" visibility="hidden"/> <col ref="tblschema" visibility="hidden"/> <col ref="tablenm" visibility="hidden"/> <col ref="colnm" visibility="hidden"/> <col ref="cdtblschema" visibility="hidden"/> <col ref="cdtblnm" visibility="hidden"/> <col ref="codeflag" visibility="hidden"/> <col ref="tblalias" visibility="hidden"/> <col ref="fixtypenm" visibility="hidden"/> <col ref="conditemflag" visibility="hidden"/> <script type="javascript" ev:event="onbuttonclick"> <![CDATA[ if(grd_where.col == grd_where.colRef("itemnm")){ var itemkind = grd_where.valueMatrix(grd_where.row, grd_where.colRef("itemkind")); model.removenode("/root/copynode"); model.makeNode("/root/copynode"); var CSV; if(itemkind == "CODE" || itemkind == "YN"){ model.removenode(gvParamPath +"/SMRPB01702_/SMRPB01702_value"); rpbfOpenPopUpList("SMRPB01702",grd_where,"operator,conector,condvalu1,condvalu1nm,condvalu2,condvalu2nm,itemnm,itemkind,cdtblnm,codeflag,colnm","operator,conector,condvalu1,condvalu1nm,condvalu2,condvalu2nm,itemnm,itemkind,cdtblnm,codeflag,colnm"); CSV = model.getValue(gvParamPath +"/SMRPB01702_/SMRPB01702_value"); } else{ model.removenode(gvParamPath +"/SMRPB01701_/SMRPB01701_value"); rpbfOpenPopUpList("SMRPB01701",grd_where,"operator,conector,condvalu1,condvalu2,itemnm,itemkind","operator,conector,condvalu1,condvalu2,itemnm,itemkind"); CSV = model.getValue(gvParamPath +"/SMRPB01701_/SMRPB01701_value"); } setCSVToNode("/root/copynode", CSV, "itemlist"); var codynode = instance1.selectNodes("/root/copynode" + "/*"); if(codynode.length == 0)return; var operator = model.getValue("/root/copynode/itemlist/operator"); var conector = model.getValue("/root/copynode/itemlist/conector"); var condvalu1 = model.getValue("/root/copynode/itemlist/condvalu1"); var condvalu2 = model.getValue("/root/copynode/itemlist/condvalu2"); var condvalu1nm = ""; var condvalu2nm = ""; if(itemkind == "CODE" || itemkind == "YN"){ condvalu1nm = model.getValue("/root/copynode/itemlist/condvalu1nm"); condvalu2nm = model.getValue("/root/copynode/itemlist/condvalu2nm"); } else{ condvalu1nm = condvalu1; condvalu2nm = condvalu2; } model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/operator", operator); if(grd_where.valueMatrix(grd_where.row, grd_where.colRef("tablenm")) == "RWPDYMPY" && grd_where.valueMatrix(grd_where.row, grd_where.colRef("colnm")) == "PAYYM" ){ model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/conector", "AND"); } else{ model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/conector", conector); } model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu1", condvalu1); model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu2", condvalu2); model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu1nm", condvalu1nm); model.setValue(grd_where.attribute("nodeset")+"["+(grd_where.row - grd_where.fixedRows + 1)+"]/condvalu2nm", condvalu2nm); } ]]> </script> <script type="javascript" ev:event="onentercell"> <![CDATA[ if(grd_where.col == grd_where.colRef("conector")) { if(grd_where.valueMatrix(grd_where.row, grd_where.colRef("tablenm")) == "RWPDYMPY" && grd_where.valueMatrix(grd_where.row, grd_where.colRef("colnm")) == "PAYYM" ){ messageBox("±Þ¿©³â¿ùÀº AND¸¸ °¡´ÉÇÕ´Ï´Ù.º¯°æ","E001"); return; } } ]]> </script> </datagrid> <button id="btn_wheredelete" class="btn2_letter4" style="left:67px; top:5px; width:64px; height:19px; "> <caption>Á¶°Ç»èÁ¦</caption> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ if (model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd") == "3040200000" && grd_where.valueMatrix(grd_where.row, grd_where.colRef("tblschema")) == "MIS" && grd_where.valueMatrix(grd_where.row, grd_where.colRef("tablenm")) == "RPBVEMPC" && grd_where.valueMatrix(grd_where.row, grd_where.colRef("colnm")) == "DEPTCD" && grd_where.valueMatrix(grd_where.row, grd_where.colRef("condvalu1")) == model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd")) { messageBox("»èÁ¦ ÇÒ¼ö ¾ø´Â Á¶°Ç ÀÔ´Ï´Ù.",""); return; } misfGridIUD(grd_where, "D"); ]]> </script> </button> <button id="btn_whereinsert" class="btn2_letter4" style="left:2px; top:5px; width:64px; height:19px; "> <caption>Á¶°ÇÃß°¡</caption> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ if(grd_tblcode.rows-grd_tblcode.fixedRows == 0)return; if(!fAddWhereColumn())return; grd_where.col = grd_where.colRef("itemnm"); grd_where.dispatch("onbuttonclick"); grd_where.row= grd_where.rows- grd_where.fixedRows; ]]> </script> </button> <line id="line2" class="line_1" style="x1:2px; y1:26px; x2:833px; y2:26px; "/> <caption id="caption7" class="tit_2" style="left:764px; top:10px; width:70px; height:13px; vertical-align:middle; ">Á¶°ÇÇ׸ñ</caption> <datagrid id="grd_query" nodeset="/root/main/list/query/querylist" visibility="hidden" caption="caption1" colsep="^" colwidth="100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:215px; top:115px; width:225px; height:95px; "> <col ref="strqry"/> <col ref="title"/> <col ref="titlecnt"/> <col ref="titlenm"/> <col ref="coltype"/> </datagrid> <datagrid id="grd_docufix" nodeset="/root/main/list/fixdocu/fixdoculist" visibility="hidden" caption="caption1^caption2^caption3" colsep="^" mergecellsfixedrows="bycolrec" rowsep="|" style="left:510px; top:115px; width:225px; height:95px; "> <col ref="itemcls"/> <col ref="itemclsnm"/> <col ref="fixtypenm"/> <col ref="conditemflag"/> <col ref="itemseq"/> <col ref="itemnm"/> <col ref="itemkind"/> <col ref="tblschema"/> <col ref="tablenm"/> <col ref="colnm"/> <col ref="cdtblschema"/> <col ref="cdtblnm"/> <col ref="codeflag"/> <col ref="operator"/> <col ref="conector"/> <col ref="condvalu1"/> <col ref="condvalu2"/> <col ref="condvalu1nm"/> <col ref="condvalu2nm"/> <col ref="nursedeptflag"/> </datagrid> <input id="ipt_mplemplno" ref="/root/init/mplemplno" visibility="hidden" style="left:215px; top:5px; width:100px; height:19px; "/> </group> <group id="group6" style="left:355px; top:298px; width:606px; height:440px; "> <line id="line3" class="line_1" style="x1:2px; y1:24px; x2:605px; y2:24px; "/> <caption id="caption2" class="tit_2" style="left:528px; top:8px; width:75px; height:13px; vertical-align:middle; ">°Ë»öÇ׸ñ</caption> <datagrid id="grd_select" nodeset="/root/main/list/tableselect/tableselectlist" caption="Ç׸ñ±¸ºÐ^Ç׸ñ¸í" colsep="^" colwidth="239, 345, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:2px; top:30px; width:603px; height:400px; "> <col ref="itemclsnm" _key="true"/> <col ref="itemnm" _key="true"/> <col ref="itemcls" visibility="hidden"/> <col ref="itemseq" visibility="hidden"/> <col ref="itemflag" visibility="hidden"/> <col ref="itemkind" visibility="hidden"/> <col ref="tblschema" visibility="hidden"/> <col ref="tablenm" visibility="hidden"/> <col ref="colnm" visibility="hidden"/> <col ref="cdtblschema" visibility="hidden"/> <col ref="cdtblnm" visibility="hidden"/> <col ref="codeflag" visibility="hidden"/> <col ref="sortkey" visibility="hidden"/> <col ref="fixtypenm" visibility="hidden"/> <col ref="conditemflag" visibility="hidden"/> </datagrid> <button id="btnselectdown" class="icon_bottom" style="left:160px; top:4px; width:26px; height:19px; "> <caption/> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ fSelectSortKey("D"); ]]> </script> </button> <button id="btnselectup" class="icon_top" style="left:133px; top:4px; width:26px; height:19px; "> <caption/> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ fSelectSortKey("U"); ]]> </script> </button> <button id="grd_selectdelete" class="btn2_letter4" style="left:68px; top:4px; width:64px; height:19px; "> <caption>Ç׸ñ»èÁ¦</caption> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ misfGridIUD(grd_select, "D"); ]]> </script> </button> <button id="grd_selectinsert" class="btn2_letter4" style="left:3px; top:4px; width:64px; height:19px; "> <caption>Ç׸ñÃß°¡</caption> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ grd_tblcode.refresh(); if(grd_tblcode.rows-grd_tblcode.fixedRows == 0)return; fAddSelectColumn(); ]]> </script> </button> </group> <group id="group7" style="left:961px; top:298px; width:229px; height:440px; "> <line id="line4" class="line_1" style="x1:1px; y1:24px; x2:227px; y2:24px; "/> <datagrid id="grd_fixitem" nodeset="/root/main/list/fixitem/fixitemlist" caption="¼­½Ä¸í^°£È£ºÎ¿©ºÎ" colsep="^" colwidth="207, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:1px; top:30px; width:226px; height:375px; "> <col ref="fixtypenm"/> <col ref="nursedeptflag" visibility="hidden"/> </datagrid> <input id="ipt_fixdoucnm" ref="/root/init/fixdoucnm" style="left:1px; top:411px; width:146px; height:19px; "/> <button id="btn_docusave" class="btn4_letter4" style="left:148px; top:410px; width:80px; height:22px; "> <caption>¼­½Ä»ý¼º</caption> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ var fixdocu = ipt_fixdoucnm.value; for (var i = grd_fixitem.fixedRows; i < grd_fixitem.rows; i++) { if (fixdocu == grd_fixitem.valueMatrix(i, grd_fixitem.colRef("fixtypenm")) ) { messageBox("ÀÌ¹Ì Á¸Àç ÇÏ´Â ¼­½Ä¸í ÀÔ´Ï´Ù.","I003"); return; } } fCreateFixDocu(model.getValue(ipt_fixdoucnm.attribute("ref"))); ]]> </script> </button> <button id="btn_docudelete" class="btn4_letter2" style="left:170px; top:1px; width:56px; height:22px; "> <caption>»èÁ¦</caption> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ var fixtypenm = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("fixtypenm")); if(fixtypenm.length == 0){ messageBox("¼­½Ä¸íĪÀ»","C002"); return; } var save_val = messageBox(fixtypenm +" ¼­½Ä³»¿ªÀ»", "Q001"); if (save_val != "6")return; model.setValue("/root/send/fixdocu/fixtypenm", fixtypenm); model.setValue("/root/send/fixdocu/nursedeptflag", nursedeptflag); submit("TXRTH01102"); if (model.getValue(gvErrorMsgPath + "/type") != "error") { submit("TRRTH01103"); } ]]> </script> </button> <button id="btn_docuselect" class="btn4_letter4" style="left:34px; top:1px; width:80px; height:22px; "> <caption>°¡Á®¿À±â</caption> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ var fixtypenm = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("fixtypenm")); if(fixtypenm.length == 0){ messageBox("¼­½Ä¸íĪÀ»","C002"); return; } model.setValue("/root/send/fixdocu/fixtypenm", fixtypenm); model.setValue("/root/send/fixdocu/nursedeptflag", nursedeptflag); submit("TRRTH01104"); if(grd_docufix.rows - grd_docufix.fixedRows == 0){ messageBox("ÀúÀåµÈ ¼­½Ä³»¿ªÀÌ","I004"); return; } misfGridInit(grd_select); misfGridInit(grd_where); var addRow; for(var row = grd_docufix.fixedRows; row < grd_docufix.rows; row++){ if(grd_docufix.valueMatrix(row , grd_docufix.colRef("conditemflag")) == "1"){ misfGridIUD(grd_select, "A","N"); addRow = grd_select.rows - grd_select.fixedRows; model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemcls"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemclsnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemclsnm"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/fixtypenm", model.getValue(ipt_fixdoucnm.attribute("ref"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/conditemflag", "1"); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemcls"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemnm"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/itemkind", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemkind"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/tblschema", grd_docufix.valueMatrix(row , grd_docufix.colRef("tblschema"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/tablenm", grd_docufix.valueMatrix(row , grd_docufix.colRef("tablenm"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/colnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("colnm"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/cdtblschema", grd_docufix.valueMatrix(row , grd_docufix.colRef("cdtblschema"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/cdtblnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("cdtblnm"))); model.setValue(grd_select.attribute("nodeset")+"["+(addRow)+"]/codeflag", grd_docufix.valueMatrix(row , grd_docufix.colRef("codeflag"))); } } for(var row = grd_docufix.fixedRows; row < grd_docufix.rows; row++){ if(grd_docufix.valueMatrix(row , grd_docufix.colRef("conditemflag")) == "2"){ misfGridIUD(grd_where, "A","N"); addRow = grd_where.rows - grd_where.fixedRows; model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemcls"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/fixtypenm",model.getValue(ipt_fixdoucnm.attribute("ref"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/conditemflag", "2"); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/itemcls", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemcls"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/itemnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemnm"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/itemkind", grd_docufix.valueMatrix(row , grd_docufix.colRef("itemkind"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/tblschema", grd_docufix.valueMatrix(row , grd_docufix.colRef("tblschema"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/tablenm", grd_docufix.valueMatrix(row , grd_docufix.colRef("tablenm"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/colnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("colnm"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/cdtblschema", grd_docufix.valueMatrix(row , grd_docufix.colRef("cdtblschema"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/cdtblnm", grd_docufix.valueMatrix(row , grd_docufix.colRef("cdtblnm"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/codeflag", grd_docufix.valueMatrix(row , grd_docufix.colRef("codeflag"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/operator", grd_docufix.valueMatrix(row , grd_docufix.colRef("operator"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/conector", grd_docufix.valueMatrix(row , grd_docufix.colRef("conector"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/condvalu1", grd_docufix.valueMatrix(row , grd_docufix.colRef("condvalu1"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/condvalu2", grd_docufix.valueMatrix(row , grd_docufix.colRef("condvalu2"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/condvalu1nm", grd_docufix.valueMatrix(row , grd_docufix.colRef("condvalu1nm"))); model.setValue(grd_where.attribute("nodeset")+"["+(addRow)+"]/condvalu2nm", grd_docufix.valueMatrix(row , grd_docufix.colRef("condvalu2nm"))); } } for (var z = grd_where.fixedRows; z < grd_where.rows; z++) { if (nursedeptflag == "Y" && grd_where.valueMatrix(z, grd_where.colRef("tblschema")) == "MIS" && grd_where.valueMatrix(z, grd_where.colRef("tablenm")) == "RPBVEMPC" && grd_where.valueMatrix(z, grd_where.colRef("colnm")) == "DEPTCD" && grd_where.valueMatrix(z, grd_where.colRef("condvalu1")) == model.getValue("/root/main/list/fixitem/emplnodeptlist/deptcd")) { grd_where.cellAttribute("disabled",z, grd_where.colRef("itemnm")) = "true"; grd_where.cellAttribute("disabled",z, grd_where.colRef("operator")) = "true"; grd_where.cellAttribute("disabled",z, grd_where.colRef("conector")) = "true"; grd_where.cellStyle("color", z, grd_where.colRef("itemnm")) = "#ff0000"; grd_where.cellStyle("color", z, grd_where.colRef("operator")) = "#ff0000"; grd_where.cellStyle("color", z, grd_where.colRef("condvalu1nm")) = "#ff0000"; grd_where.cellStyle("color", z, grd_where.colRef("condvalu2nm")) = "#ff0000"; grd_where.cellStyle("color", z, grd_where.colRef("conector")) = "#ff0000"; } else { grd_where.cellAttribute("disabled",z, grd_where.colRef("itemnm")) = "false"; grd_where.cellAttribute("disabled",z, grd_where.colRef("operator")) = "false"; grd_where.cellAttribute("disabled",z, grd_where.colRef("conector")) = "false"; grd_where.cellStyle("color", z, grd_where.colRef("itemnm")) = ""; grd_where.cellStyle("color", z, grd_where.colRef("operator")) = ""; grd_where.cellStyle("color", z, grd_where.colRef("condvalu1nm")) = ""; grd_where.cellStyle("color", z, grd_where.colRef("condvalu2nm")) = ""; grd_where.cellStyle("color", z, grd_where.colRef("conector")) = ""; } } ]]> </script> </button> <button id="button1" class="btn4_letter2" style="left:114px; top:1px; width:56px; height:22px; "> <caption>¼öÁ¤</caption> <script type="javascript" ev:event="DOMActivate"> <![CDATA[ var fixtypenm = grd_fixitem.valueMatrix(grd_fixitem.row, grd_fixitem.colRef("fixtypenm")); if(fixtypenm.length == 0){ messageBox("¼­½Ä¸íĪÀ»","C002"); return; } if(grd_where.rows - grd_where.fixedRows == 0){ messageBox("Á¶°ÇÇ׸ñÀÌ ÀԷµÇÁö ¾Ê¾Ò½À´Ï´Ù. ¼öÁ¤","E001"); return; } if(grd_select.rows - grd_select.fixedRows == 0){ messageBox("°Ë»öÇ׸ñÀÌ ÀԷµÇÁö ¾Ê¾Ò½À´Ï´Ù. ¼öÁ¤","E001"); return; } model.setValue("/root/send/fixdocu/fixtypenm", fixtypenm); model.setValue("/root/send/fixdocu/nursedeptflag", nursedeptflag); submit("TXRTH01102"); fCreateFixDocu(fixtypenm); ]]> </script> </button> </group> </group> </xhtml:body> </xhtml:html>