var __doc=document;function $(A){return __doc.getElementById(A)}function node(A){return __doc.createElement(A)}function evalJS(e){eval(e.responseText)}function getHTTPObject(){var A=false;if(window.XMLHttpRequest){try{A=new XMLHttpRequest()}catch(B){A=false}}else{if(window.ActiveXObject){try{A=new ActiveXObject("Msxml2.XMLHTTP")}catch(B){try{A=new ActiveXObject("Microsoft.XMLHTTP")}catch(B){A=false}}}}return A}function rm(A){while(A&&A.childNodes.length>0){A.removeChild(A.firstChild)}}function read(D,B,C){var A=getHTTPObject();try{A.open("GET",B,!C);if(!C){A.onreadystatechange=function(){if(A.readyState==4){if(A.status!=200){readRetry(D,B,C);return false}if(D){D(A)}}}}A.send(null);if(C){if(A.status!=200){readRetry(D,B,C);return false}if(D){D(A)}}return true}catch(E){readRetry(D,B,C,E.message);return false}}function readRetry(E,C,D,B){var A=$("retryRead");if(A){if(B){A.em=B}else{A.em="No Error"}A.style.display=""}}var floatingWinUrlFunc;function floatTinyWin(A,B){if(!B){return }$("floatingTinyWin").style.display="";$("floatingTinyWinContent").innerHTML=B;if(A){$("floatingTinyWin").onclick=A}}function closeGalleryIntro(){$("desc").style.display="";$("floatingTinyWin").style.display="none"}function floatWin(A,B){ctrl.outOfNUI=true;if(B){$("floatingWin").style.display="";$("floatingWinContent").innerHTML=B;if(A){A()}return }if(A){floatingWinUrlFunc=A}$("floatingWinContent").innerHTML="Loading...";$("floatingWin").style.display="";read(function(C){$("floatingWinContent").innerHTML=C.responseText},floatingWinUrlFunc())}function dropWin(D,C,B,A){if(C.style.display==""){C.style.display="none";return }C.style.display="";var E=findPos(D);C.style.top=E[1]+D.offsetHeight;if(A){C.style.left=E[0]-C.offsetWidth+D.offsetWidth}else{C.style.left=E[0]}floatingPanels.push(C);ctrl.dropWin=true}function loadRightsSetting(){saveRightsSetting("EVERYONE",builder.rights.EVERYONE);saveRightsSetting("MANAGER",builder.rights.MANAGER);saveRightsSetting("USER",builder.rights.USER)}function saveRightsSetting(A,B){if(!A){return }if(!B){B=0}B=parseInt(B);builder.setRights(A,B);if($("rights_desc_"+A)){$("rights_desc_"+A).innerHTML=$("rights_"+B).innerHTML}$("dropdown").style.display="none"}function saveBuilderMode(B,A){var C=nui;if(!B){B=builder.defaultMode}builder.mode=B;if(A){builder.defaultMode=B;C._focus(C.fcol,C.frow)}$("builderMode_desc").innerHTML=$("builderMode"+B).innerHTML;$("builderModes").style.display="none"}function indexOf(C,B){if(!B||!C){return -1}var A=0;for(;B&&A<B.length;A++){if(B[A]==C){return A}}return -1}function getCookie(D){var B=document.cookie.split("; ");for(var C=0;C<B.length;C++){var A=B[C].split("=");if(D==A[0]){return unescape(A[1])}}return null}function removeCookie(A){document.cookie=A+"=; expires=0"}function setCookie(C,D,B){var A;if(B){A=new Date((new Date()).getTime()+B)}else{A=new Date((new Date()).getTime()+10*365*24*3600*1000)}document.cookie=C+"="+escape(D)+"; path=/ ; expires="+A.toGMTString()+";"}function formatCurrency(A){A=A.toString().replace(/\$|\,/g,"");if(isNaN(A)){A="0"}sign=(A==(A=Math.abs(A)));A=Math.floor(A*100+0.50000000001);cents=A%100;A=Math.floor(A/100).toString();if(cents<10){cents="0"+cents}for(var B=0;B<Math.floor((A.length-(1+B))/3);B++){A=A.substring(0,A.length-(4*B+3))+","+A.substring(A.length-(4*B+3))}return(((sign)?"":"-")+A+"."+cents)}function noUnit(A){if(!A){return""}return A.substring(0,A.length-2)}function dummy(A){}function buttover(A){if(!A){return }A.style.backgroundImage="url(/sims/img/buttonBack.png)"}function buttout(A){if(!A){return }A.style.backgroundImage=""}function panelover(A){if(!A){return }A.style.backgroundColor="#AAAAAA"}function panelout(A){if(!A){return }A.style.backgroundColor=""}function rightMenuOver(A){if(!A){return }A.style.backgroundColor="#CCCCCC";A.style.border="1px solid #AAA"}function rightMenuOut(A){if(!A){return }A.style.backgroundColor="";A.style.border="1px solid #E5E5E5"}function __setBorderClasswebby(K,L,A){if(!K){return }var G=parseInt(K.id.split("_")[1]);var F=parseInt(K.id.split("_")[2]);var I=nui;if(L){K.style.backgroundColor="#E0E7EF"}K.style.paddingLeft="3px";if(ctrl.isIE8){K.style.borderTop="1px solid #ccc";var H=I._getcell(G,F+1);var J=I._getcell(G+1,F);if(H){H.style.borderTop="1px solid #ccc"}if(A){var E=parseInt(A),D;for(D=1;D<E;D++){H=I._getcell(G+D,F+1);if(H){H.style.borderTop="1px solid #ccc"}}}}else{K.style.borderBottom="1px solid #ccc";var C=I._getcell(G,F-1);var B=I._getcell(G-1,F);if(C){C.style.borderBottom="1px solid #ccc"}if(A){var E=parseInt(A),D;for(D=1;D<E;D++){C=I._getcell(G+D,F-1);if(C){C.style.borderBottom="1px solid #ccc"}}}}}function __setBorderClassdefault(K,L,A){if(!K){return }var G=parseInt(K.id.split("_")[1]);var F=parseInt(K.id.split("_")[2]);var I=nui;if(L){K.style.backgroundColor="#d6e3ff";K.style.backgroundImage=L;K.style.backgroundRepeat="repeat-x"}K.style.paddingLeft="3px";if(ctrl.isIE8){K.style.borderTop="1px solid #999";K.style.borderLeft="1px solid #999";var H=I._getcell(G,F+1);var J=I._getcell(G+1,F);if(H){H.style.borderTop="1px solid #999"}if(J){J.style.borderLeft="1px solid #999"}if(A){var E=parseInt(A),D;for(D=1;D<E;D++){H=I._getcell(G+D,F+1);if(H){H.style.borderTop="1px solid #999"}}}}else{K.style.borderBottom="1px solid #999";K.style.borderRight="1px solid #999";var C=I._getcell(G,F-1);var B=I._getcell(G-1,F);if(C){C.style.borderBottom="1px solid #999"}if(B){B.style.borderRight="1px solid #999"}if(A){var E=parseInt(A),D;for(D=1;D<E;D++){C=I._getcell(G+D,F-1);if(C){C.style.borderBottom="1px solid #999"}}}}}function removeBorderClass(C,E){var B=parseInt(C.id.split("_")[1]);var H=parseInt(C.id.split("_")[2]);C.style.backgroundImage="";C.style.backgroundColor="";C.className=E;if(ctrl.isIE8){C.style.borderTop="1px solid #EEE";C.style.borderLeft="1px solid #EEE";var G=nui._getcell(B,H+1);var D=nui._getcell(B+1,H);if(G){G.style.borderBottom="1px solid #EEE"}if(D){D.style.borderRight="1px solid #EEE"}}else{C.style.borderBottom="1px solid #EEE";C.style.borderRight="1px solid #EEE";var A=nui._getcell(B,H-1);var F=nui._getcell(B-1,H);if(A){A.style.borderBottom="1px solid #EEE"}if(F){F.style.borderRight="1px solid #EEE"}}}function newSheet(){var B=node("a");var F=node("div");B.appendChild(F);$("footer").insertBefore(B,$("newSheet"));var C=0;var E=1;for(;C<sheetNameList.length;C++){var D=sheetNameList[C].split("_");if(parseInt(D[0])>E){E=parseInt(D[0])}}E++;var A=E+"_Sheet "+E;B.href="#"+A;B.sheetName=A;B.onclick=function(){if(mode!=BUILDER){changeSheet(this.sheetName);modeBrowse()}return false};F.className="tabbelow";F.id=A;F.innerHTML="Sheet "+E;sheetNameList.push(A);changeSheet(A)}function newFolder(){var A=prompt("Enter the name of your new folder.","New Folder");if(!A){return }if(A.length<3){floatWin(null,"Your folder name is too short.");return }if(indexOf(A,folderNameList)!=-1){floatWin(null,"Your folder name exists.");return }if(A.indexOf("/")!=-1||A.indexOf("\\")!=-1||A.indexOf("..")!=-1){floatWin(null,"Your folder name is illegal.");return }read(null,"/sims/folder.jsp?a="+ap+"&p="+path+"&f="+encodeURIComponent(A),true);window.location.reload()}function renameSheet(id){if(!owner){return }var split=id.split("_");var newName=prompt("Please enter the new name of this sheet.",decodeURIComponent(split[1]).replace(/\+/g," "));if(!newName){return }if(newName.indexOf("_")!=-1){floatWin(null,'You sheet name cannot contain the character "_".');return }if(newName&&newName!=""){read(function(o){eval(o.responseText)},"/sims/sheet.jsp?act=mv&a="+ap+"&fn="+id+"&n="+encodeURIComponent(newName)+"&p="+encodeURIComponent(path))}}function refreshSheet(id){read(function(o){eval(o.responseText)},"/sims/sheet.jsp?act=rl&a="+ap+"&fn="+id+"&p="+encodeURIComponent(path))}function deleteSheet(id){if(confirm("Are you sure you want to delete this sheet?")){read(function(o){eval(o.responseText)},"/sims/sheet.jsp?act=rm&a="+ap+"&fn="+id+"&p="+encodeURIComponent(path))}}function changeSheet(D){nuiController.resetBrowseLeft();if(D){var B=indexOf(D,sheetNameList);if(B!=-1){sheet=D}}else{if(defaultSheet){var B=indexOf(defaultSheet,sheetNameList);if(B==-1){defaultSheet=null}}}if(!D){var A=window.location.toString();if(defaultSheet){sheet=defaultSheet}else{sheet=sheetNameList[0]}}for(B=0;B<sheetNameList.length;B++){var C=sheetNameList[B];var E=$(C);if(!E){continue}if(sheet==C){E.className="tabbelowOn"}else{E.className="tabbelow"}}$("filterIcons").innerHTML=""}function hideEditElements(){var A=$("hin"),B=A.style;B.left=5;B.top=-20;B.width="5000px";B.height="20px";B.zIndex=0}function changeLang(A){setCookie("lang",A.options[A.selectedIndex].value);location.reload()}function processDefaultValue(A){if(!A){return }var B=A.attr.dv;if(!B){if(A.attr.em&&user){return user}else{return B}}if(B.substr(0,1)=="$"){var D=new Date();if(B=="$DATE"){B=D.getFullYear()+"/"+(D.getMonth()+1)+"/"+D.getDate()}else{if(B=="$TIME"){B=D.getHours()+":"+D.getMinutes()+":"+D.getSeconds()}else{if(B=="$DATETIME"){B=D.getFullYear()+"/"+(D.getMonth()+1)+"/"+D.getDate()+" "+D.getHours()+":"+D.getMinutes()+":"+D.getSeconds()}else{if(B=="$USERID"){B=(user?user:"Guest")}else{if(B=="$USERNAME"){B=(userName?userName:"Guest")}else{if(B=="$SEQ"){try{var F=biffdata.findBiff(A.domainId,parseInt(A.y)-1);var E=parseInt(F.value)+1;if(E&&!isNaN(E)){B=E}}catch(C){}B=A.ip.domainNodeSeq+1}}}}}}}return B}function disableSelection(A){if(!A){return }if(typeof A.onselectstart!="undefined"){A.onselectstart=function(C){if(!C){C=window.event}var B;if(C.target){B=C.target}else{if(C.srcElement){B=C.srcElement}}if(B.nodeType==3){B=B.parentNode}if(B.id=="hin"){return true}return false}}if(typeof A.style.MozUserSelect!="undefined"){A.style.MozUserSelect="none"}else{}A.style.cursor="default"}function enableSelection(A){if(!A){return }if(typeof A.onselectstart!="undefined"){A.onselectstart=null}else{if(typeof A.style.MozUserSelect!="undefined"){A.style.MozUserSelect=null}else{A.onmousedown=null}}A.style.cursor=""}function switchTab(A){$("AccountInfo").style.display="";$("bPassword").className="tabClose";$("bInvite").className="tabClose";A.className="tabOpen"}function switchTabDesign(A){$("DesignerInfo").style.display="";$("bPackage").className="tabClose";$("bRights").className="tabClose";A.className="tabOpen"}function switchTabAcc(A){$("accMngt").style.display="";$("bAccountStatus").className="tabClose";$("bAccList").className="tabClose";A.className="tabOpen"}function pwdcheck(){if($("pwd").value.length<6){floatWin(null,"You password is too short.");return false}else{if($("pwd").value!=$("cpwd").value){floatWin(null,"You passwords does not match");return false}}return true}function showRightKeyMenu(C){if(!C){return false}var B;if(C.target){B=C.target}else{if(C.srcElement){B=C.srcElement}}if(B.nodeType==3){B=B.parentNode}if(mode==BUILDER&&checkParentClass(B,["nui"])){builderRKeyMenu(C,B)}else{if(owner&&checkParentClass(B,["tabbelow","tabbelowOn"])){sheetRKeyMenu(C,B)}else{if(checkParentClass(B,["frontIcon"])){frontRKeyMenu(C,B)}else{if(mode==UPDATE&&!isNaN(A)&&!isNaN(D)){var A=parseInt(B.id.split("_")[1]);var D=parseInt(B.id.split("_")[2]);nui._focus(A,D)}}}}return false}function checkParentClass(D,B){var A=D,C=0;while(A&&C<20){if(indexOf(A.className,B)!=-1){return true}else{A=A.parentNode}C++}return false}function sheetRKeyMenu(C,B){var A=0;var D=0;if(C.pageX||C.pageY){A=C.pageX;D=C.pageY}else{if(C.clientX||C.clientY){A=C.clientX+document.body.scrollLeft+document.documentElement.scrollLeft;D=C.clientY+document.body.scrollTop+document.documentElement.scrollTop}}$("rightKeyFloatSheet").style.display="";$("rightKeyFloatSheet").style.left=A;$("rightKeyFloatSheet").style.top=D-$("rightKeyFloatSheet").offsetHeight;$("bRenameSheet").onclick=function(){renameSheet(B.id)};$("bDeleteSheet").onclick=function(){deleteSheet(B.id)};$("bRefreshSheet").onclick=function(){refreshSheet(B.id)};floatingPanels.push($("rightKeyFloatSheet"))}function frontRKeyMenu(C,B){var A=0;var D=0;if(C.pageX||C.pageY){A=C.pageX;D=C.pageY}else{if(C.clientX||C.clientY){A=C.clientX+document.body.scrollLeft+document.documentElement.scrollLeft;D=C.clientY+document.body.scrollTop+document.documentElement.scrollTop}}$("rightKeyFloat2").style.display="";$("rightKeyFloat2").style.left=A;$("rightKeyFloat2").style.top=D;if(owner){$("bEditFrontIcon").className="rightKeyChoice";$("bDeleteFrontIcon").className="rightKeyChoice"}$("bOpenFrontIcon").onclick=function(){location=B.parentNode.parentNode.href};$("bEditFrontIcon").onclick=function(){setCookie("builder","1");location=B.parentNode.parentNode.href};$("bDeleteFrontIcon").onclick=function(){if(confirm("Are you sure you would like to delete this application?")){read(function(){window.location.reload()},"/sims/deleteAp.jsp?a="+ap+"&d="+B.parentNode.id)}};floatingPanels.push($("rightKeyFloat2"))}function builderRKeyMenu(E,C){var B=parseInt(C.id.split("_")[1]);var G=parseInt(C.id.split("_")[2]);var D=false;$("bInsertRow").className="rightKeyChoice";$("bInsertCol").className="rightKeyChoice";$("bInsertLocalCol").className="rightKeyChoice";D=true;ctrl.rightClickRow=G;ctrl.rightClickCol=B;if(B==0){$("bInsertCol").className="rightKeyChoice";$("bInsertLocalCol").className="rightKeyChoice"}if(G==0){$("bInsertRow").className="rightKeyChoice";$("bInsertLocalCol").className="rightKeyChoice"}if(!D){return }var A=0;var F=0;if(E.pageX||E.pageY){A=E.pageX;F=E.pageY}else{if(E.clientX||E.clientY){A=E.clientX+document.body.scrollLeft+document.documentElement.scrollLeft;F=E.clientY+document.body.scrollTop+document.documentElement.scrollTop}}$("rightKeyFloat").style.display="";$("rightKeyFloat").style.left=A;$("rightKeyFloat").style.top=F}function textFilter(A){var B=prompt("Enter the text that you would like to search for");if(B){nuiController.load("","&tf="+encodeURIComponent(B)+"&fd="+A.parentNode.domainId,function(){if(mode==BROWSE){browse._init()}browse._focus()})}}function clearFilter(A){nuiController.load("","&cl="+A.parentNode.domainId,function(){if(mode==BROWSE){browse._init()}browse._focus()})}function showFilterIcons(){var A=biffdata.filteredDomains;if(!A){return }for(i=0;i<A.length;i++){if(A[i]&&!isNaN(A[i])&&$("arrow"+A[i])){$("arrow"+A[i]).src="/sims/img/filter.png"}}}function positionFilterIcons(){if(biffdata.formType!="2"){return }var F=$("filterIcons"),C;F.style.display="";var E=nui.main_outer,B=nui.main;for(C=0;C<F.childNodes.length;C++){var D=F.childNodes[C];var A=D.poscell;D.style.top=A.offsetTop+ctrl.ctrlHeight-B.scrollTop+2;if(parseInt(D.style.top)<80){D.style.display="none"}else{D.style.display=""}D.style.left=A.offsetLeft+A.offsetWidth-B.scrollLeft-13}}function toggle(A){if(A.style.display!="none"){A.style.display="none"}else{A.style.display=""}}function createNewEnv(){var A=prompt("Please enter new environment name:");if(!A||A.length==0){return }read(function(B){$("accountInfoContent").innerHTML=B.responseText},"/sims/dataman.jsp?a="+ap+"&e="+encodeURIComponent(A)+"&s="+encodeURIComponent(env))}function delenv(A){read(function(B){$("accountInfoContent").innerHTML=B.responseText},"/sims/dataman.jsp?a="+ap+"&d="+encodeURIComponent(A))}function backToBrowse(){if(path=="/designer"){location="/"+ap}else{if(confirm(lm.away)){modeBrowse()}}}function dropShadow(A){var B=node("div");B.style.position="absolute";B.style.top=A.offsetTop+9;B.style.left=A.offsetLeft+9;B.style.width=A.offsetWidth;B.style.height=A.offsetHeight;B.style.background="url(/sims/img/shadowAlpha.png) no-repeat bottom right";document.body.appendChild(B)}function addEvent(C,B,A){if(C.addEventListener){C.addEventListener(B,A,false);EventCache.add(C,B,A)}else{if(C.attachEvent){C["e"+B+A]=A;C[B+A]=function(){C["e"+B+A](window.event)};C.attachEvent("on"+B,C[B+A]);EventCache.add(C,B,A)}else{C["on"+B]=C["e"+B+A]}}}var EventCache=function(){var A=[];return{listEvents:A,add:function(B,D,C){A.push(arguments)},flush:function(){var B,C;for(B=A.length-1;B>=0;B=B-1){C=A[B];if(C[0].removeEventListener){C[0].removeEventListener(C[1],C[2],C[3])}if(C[1].substring(0,2)!="on"){C[1]="on"+C[1]}if(C[0].detachEvent){C[0].detachEvent(C[1],C[2])}C[0][C[1]]=null}}}}();addEvent(window,"unload",EventCache.flush);function findPos(A){var B=curtop=0;if(A.offsetParent){do{B+=A.offsetLeft;curtop+=A.offsetTop}while(A=A.offsetParent);return[B,curtop]}return[A.offsetLeft,A.offsetTop]}var pickedHeader=0;function pickExcelHeader(A){$("headerRow"+pickedHeader).className="";$("headerRow"+A).className="pickedRow";$("pickHeader"+pickedHeader).checked=false;$("pickHeader"+A).checked=true;pickedHeader=A}function pickExcelCell(A){if(A==-1){return }if($("pickCell"+A).checked){$("headerCell"+A).className="";$("pickCell"+A).checked=false}else{$("headerCell"+A).className="pickedCell";$("pickCell"+A).checked=true}}function deleteEntry(A,B){if(confirm("Delete this item?")){read(null,"/sims/del.jsp?a="+encodeURIComponent(ap)+"&d="+A+"&n="+B,true);nuiController.resetBrowseLeft();nuiController.load("","",null)}}function validateAll(){var D=biffdata.biffs;var B="";for(i=0;i<D.length;i++){var A=D[i];var C=A.ip;if(C&&C.validate&&A.attr&&A.attr.va){if(!C.validate(true)){C.cell.style.backgroundColor="#FFEFEF";B+=C.value+" "}}}return B}function submitNUIForm(){var A=validateAll();if(A.length>0){floatWin(null,"Your value format is not correct for: "+A);return }$("nuiform").submit()}function updateShortcut(B,C,A){if($("newInstUrl").value==""||$("newInstName").value==""){alert("Please enter database name and URL.");return false}else{if(A){progressBar();read(evalJS,"/sims/copyAp.jsp?a="+B+"&i="+A+"&nn="+encodeURIComponent($("newInstName").value)+"&iu="+encodeURIComponent($("newInstUrl").value))}else{nui._blur();builder.saveServer(true);read(evalJS,"/sims/saveShortcut.jsp?a="+B+"&nn="+encodeURIComponent($("newInstName").value)+"&p="+encodeURIComponent($("newInstUrl").value)+C)}}}function calculateCost(){var C=$("numOfLicense");var D=$("monthOfExtension");var B=parseInt(C.options[C.selectedIndex].value);var A=parseInt(D.options[D.selectedIndex].value);var F=25*B;if(B>1000){F=2499}else{if(B>150){F=999}else{if(B>23){F=599}}}var E=F*A;$("cost1").value=E;$("cost2").innerHTML=E}function motd(){if(!ctrl.isIE){return }var A=getCookie("motd");if(!A){floatWin(null,"<div style='float:left;width:360px'>"+lm.motd+"</div><a href='http://www.mozilla.com/en-US/firefox/firefox.html' style='float:right' target=_blank><img src='/sims/img/firefox.png'></img></a>");setCookie("motd","1",3*24*3600*1000)}}function mmailLoadEmail(E){var C=E.split("\n"),B;var A="";for(B=0;B<C.length;B++){var D=C[B].split("|");if(D.length<2){continue}A+='<a href="javascript:void(0);">'+D[1]+"</a>&nbsp;"}return A}function setCaretTo(B,C){if(B.createTextRange){var A=B.createTextRange();A.move("character",C);A.select()}else{B.focus();B.setSelectionRange(C,C)}}function browseNextPage(){nuiController.load("","&pd=1",function(){if(mode==BROWSE){browse._init();browse._focus()}})}function browsePrevPage(){nuiController.load("","&pd=-1",function(){if(mode==BROWSE){browse._init();browse._focus()}})}function browseBack(){nui.main.scrollTop=0;if(biffdata.formType=="2"){return }nuiController.load("&gb","",function(){browse._trav(false)},nuiController.LEFT)}function browseForward(){var C=browse._getCell();if(!C){return }var B=browse._getCell().ip;if(!B){return }nui.main.scrollTop=0;var A="&dm="+(biffdata.formType==2?"index":B.domainId)+"&des="+B.domainNodeSeq+"&dnpd="+B.parentDomainId+"&dnpn="+B.parentNodeId;nuiController.load(A,"",function(){browse._trav(true)},nuiController.RIGHT)}function newData(){nui.main.scrollTop=0;if(biffdata.formType=="2"){var A="&dm=index&ft=f&dnpd=-1&dnpn=-1";nuiController.load(A,"",function(){browse._trav(true);modeUpdate()},nuiController.RIGHT)}else{nuiController.load("","&pd=new",function(){modeUpdate()})}}function BiffData(){var A=this;A.biffs=new Array();A.rootDomainId=-1;A.rootNodeId=-1;A.rights="R";A.notify=new Array();A.selections=new Array();A.formulaMap=new Object();A.domainIdCellMapping=new Object();A.existingCellCords=new Array()}BiffData.prototype.debug=function(){var C,B="";for(C=0;C<this.biffs.length;C++){var A=this.biffs[C];if(A.sec[0]=="L"||A.sec[0]=="D"||A.sec[0]=="U"||A.sec[0]=="G"||A.sec[0]=="M"){B+=A.sec+"\n"}}return B};BiffData.prototype.readline=function(I,H){if(!I){return false}var D=I.split(",");if(D.length<2){return false}if(D[0]=="W"){this.widthCommand=D[1];this.heightCommand=D[2];return false}else{if(D[0]=="A"&&H==DATA){this.rights=D[1];if(this.rights=="R"){$("bEdit").style.display="none"}else{$("bEdit").style.display=""}this.prevButton=D[2];this.nextButton=D[3];var J=D[4].split("|"),C;this.filteredDomains=J;return false}else{if(D[0]=="A"&&H==HEADER){var F=D[1].split("=");saveRightsSetting(F[0],F[1]);if(mode==BROWSE){if(F[1]=="2"||F[1]=="0"){$("bNewData").style.display="none"}else{$("bNewData").style.display=""}}var A=parseInt(D[2]),B="&nbsp;";switch(A){case 0:B=lm.myPrivMsg0;break;case 1:B=lm.myPrivMsg1;break;case 2:B=lm.myPrivMsg2;break;case 3:B=lm.myPrivMsg3;break;case 6:B=lm.myPrivMsg6;break;default:B=lm.myPrivMsg0;break}$("privdesc").innerHTML=B;if(D.length>3){this.formType=D[3]}return false}else{if(D[0]=="S"&&H==DATA){this.selections.push(D);return true}}}}var G=new Biff(D,H);if(this.rootDomainId==-1&&H==DATA){if(G.domainId){this.rootDomainId=G.domainId}if(G.nodeId){this.rootNodeId=G.nodeId}}if(H==HEADER){this.domainIdCellMapping[G.domainId]=colNames[G.x]+G.y}G.index=this.biffs.length;if(indexOf(G.x+","+G.y+","+G.domainId,this.existingCellCords)!=-1){var E=this.findBiff(G.domainId,G.y);E.value=G.value;G.updatedCell=true}else{this.biffs.push(G);this.existingCellCords.push(G.x+","+G.y+","+G.domainId)}return G};BiffData.prototype.findBiff=function(D,E){var C,B=this;for(C=0;C<B.biffs.length;C++){var A=B.biffs[C];if(A.domainId==D&&A.y==E&&A.dataType==DATA){return A}}for(C=0;C<B.biffs.length;C++){var A=B.biffs[C];if(A.domainId==D&&A.dataType==DATA){return A}}return null};BiffData.prototype.ifRight=function(B,F){var E,D=this;var C=false;for(E=0;E<D.biffs.length;E++){var A=D.biffs[E];if(A.x==B+1&&A.y==F){C=true}}return C};BiffData.prototype.ifTableHeaderRest=function(B,F){var D,C=this;var E=false;for(D=0;D<C.biffs.length;D++){var A=C.biffs[D];if(A.x==B-1&&A.y==F&&A.dataType==HEADER){E=true}}return E};BiffData.prototype.ifAdjacent=function(B,H,F){var E,D=this;var G=false;var C=false;for(E=0;E<D.biffs.length;E++){var A=D.biffs[E];if(A.x==B+1&&A.y==H&&A.dataType==DATA){C=true}else{if(A.x==B-1&&A.y==H&&A.dataType==DATA){G=true}}}if(F){return F(C,G)}else{return C&&!G}};BiffData.prototype.loadHeader=function(C){this.rootDomainId=-1;var D=C.responseText?C.responseText:C;var A=D.split("\n"),B;for(B=0;B<A.length;B++){biffdata.readline(A[B],HEADER)}};BiffData.prototype.loadData=function(X){this.rootDomainId=-1;var W=X.responseText?X.responseText:X;var B=W.split("\n"),K,J;var T=false;var F=biffdata;var M=new Array();var C=new Array();var E=new Array();var U=new Object();for(K=0;K<B.length;K++){var V=F.readline(B[K],DATA);if(V){T=true;F.anydata=true}}try{for(K=0;K<F.biffs.length;K++){var G=F.biffs[K];if(G.dataType==HEADER){if(F.ifTableHeaderRest(G.x,G.y)){var I=M.length-1;var R=M[I];U[G.domainId]=I;R.push(G)}else{var P=new Array();P.push(G);var I=M.length;M.push(P);U[G.domainId]=I;C.push(G.y)}}else{var I=U[G.domainId];var N=M[I];N.push(G);var A=C[I];var S=G.y-A;if(S>3){if(!E[I]){E[I]=S-3}else{E[I]=Math.max(E[I],S-3)}}}}}catch(O){}for(K=0;K<M.length;K++){var L=0;for(J=0;J<M.length;J++){if(C[J]<C[K]){if(E[J]){L+=E[J]}}}var D=M[K];for(J=0;J<D.length;J++){var H=D[J];H.y+=L;H.sec[2]=H.y}}var Q=null;for(K=0;K<F.biffs.length;K++){var G=F.biffs[K];if(G.y>50){Q=G.y}}if(Q){this.maxY=Q}for(K=0;K<E.length;K++){if(E[K]){shiftWidth(false,C[K],E[K])}}if(T||!F.anydata){displayData();if(ctrl.isFF){nuiController.resize()}}else{if(loadingBox){loadingBox.style.display="none"}}if($("floatingWin").style.display==""){floatWin()}};BiffData.prototype.reset=function(){var A=this;A.biffs=new Array();A.notify=new Array();A.selections=new Array();A.filteredDomains=new Array();A.anydata=false;A.existingCellCords=new Array();A.formulaMap=new Object();A.domainIdCellMapping=new Object();if(loadingBox){loadingBox.style.display=""}};function calShift(D,B){var C,A=0;for(C=0;C<D.length;C++){if(C<=B&&D[C]){A++}}return A}function Biff(C,A){var B=this;B.dataType=A;B.sec=C;B.IPType=C[0];if(B.IPType==SELECTION){return }B.x=parseInt(C[1]);B.y=parseInt(C[2]);if(B.IPType==FREE){B.action=C[3]}else{B.domainId=parseInt(C[3])}B.nodeId=A==HEADER?null:C[4];B.originalNodeId=B.nodeId;B.value=A==HEADER?parseHeaderValue(C[4]):C[8];B.attr=A==HEADER?parseAttributes(C[5]):parseAttributes(C[7]);if(A==HEADER&&B.attr){if(B.attr.l){biffdata.notify.push(B.attr.l)}else{if(B.attr.ln){biffdata.notify.push(B.attr.ln)}}}B.value=loadTextProcess(B.value);B.parentDomainId=A==HEADER?null:parseInt(C[5]);B.parentNodeId=A==HEADER?null:parseInt(C[6])}Biff.prototype.ifCreateInsertRow=function(){var C=this;var B=C.x,H=C.y,F=nui,D=C.domainId;var A=F._getcell(B,H-1);var G=F._getcell(B,H+1);var E=F._getcell(B-1,H);return A&&A.ip&&A.ip.biff.domainId==D&&(!G||!G.ip||G.ip.biff.domainId!=D)};function parseHeaderValue(E){if(!E){return E}var B=E.split("|");if(B.length==1){return E}else{var D=lang;var A=0;for(;A<B.length;A++){var C=B[A].split("=");if(D==C[0]){return C[1]}}return B[0]}}function parseAttributes(B){if(!B||B.length==0){return null}var D=B.split("&"),C;var A=new Object();for(C=0;C<D.length;C++){var E=D[C].split("=");if(E.length<2){continue}A[E[0]]=E[1].replace(/`/gim,",")}return A}var browse={bcells:new Array(),focusbcell:-1,focusbcellList:[0],_trav:function(B){var A=this;if(B){A.focusbcellList.push(A.focusbcell);A.focusbcell=0}else{if(A.focusbcellList.length>0){A.focusbcell=A.focusbcellList.pop()}}A._init()},checkClickable:function(){var E=browse;var C=E.bcells[E.focusbcell];var F=C&&C.length>1;var B=C&&C[0].ip.biff;var D=B&&B.attr&&B.attr.s;var A=C&&C.length==1&&(C[0].ip.biff.IPType==SELECTOR||C[0].ip.biff.IPType==MSELECTOR)&&owner;return !D&&(F||A)},_init:function(){var M=this,N,G,E;M.bcells=new Array();var H=new Array();var D=new Array();for(E=0;E<biffdata.biffs.length;E++){var J=biffdata.biffs[E];if(!J||J.IPType==SELECTION||J.dataType==HEADER){continue}var K=J.x;var I=J.y;var A=parseInt(J.domainId);var B=parseInt(J.nodeId);var L=nui._getcell(K,I);if(!L){continue}if(H[I]&&H[I]+1==K){var F=D[I];L.browseIndex=F;M.bcells[F].push(L)}else{var C=new Array();L.browseIndex=M.bcells.length;D[I]=M.bcells.length;C.push(L);M.bcells.push(C)}H[I]=K}M._focus()},_move:function(A){var B=this;B.focusbcell+=A;if(B.focusbcell<0){B.focusbcell=0}if(B.focusbcell>=B.bcells.length){B.focusbcell=B.bcells.length-1}if(isNaN(B.focusbcell)){B.focusbcell=0}B._focus()},_focus:function(){var B,A=this,C=A.bcells[A.focusbcell];A._nofocus();if(!C){return }for(B=0;B<C.length;B++){if(!C[B]||C[B].browseFocus){continue}C[B].oldBackgroundColor=C[B].style.backgroundColor;C[B].style.backgroundColor="#FFF8AF";C[B].style.cursor="pointer";C[B].browseFocus=true}A.lastFocus=C},_nofocus:function(){var B,A=this,C=A.bcells[A.focusbcell];for(B=0;A.lastFocus&&B<A.lastFocus.length;B++){if(!A.lastFocus[B]){continue}A.lastFocus[B].style.backgroundColor=A.lastFocus[B].oldBackgroundColor;A.lastFocus[B].browseFocus=false}},_getCell:function(){var A=this,B=A.bcells[A.focusbcell];if(!B){return null}else{return B[0]}}};function showAllTooltip(){if(!$("tooltips")||getCookie("tooltip")&&userValid){return }$("tooltips").innerHTML="";$("tooltips").style.display="";if($("bNewData").style.display!="none"){showTooltip($("bNewData"),lm.tt_bNewData)}else{if($("bBack").style.display!="none"){showTooltip($("bBack"),lm.tt_bBack)}else{if($("bEdit").style.display!="none"){showTooltip($("bEdit"),lm.tt_bEdit)}else{if($("bBrowse").style.display!="none"){showTooltip($("bBrowse"),lm.tt_bBrowse)}}}}if($("filterIcons").style.display!="none"&&$("filterIcons").lastChild){showTooltip($("filterIcons").lastChild,lm.tt_filter,false,true)}if($("bNextPage").style.display!="none"){showTooltip($("bNextPage"),lm.tt_bNextPage,true)}else{if($("bDesign").style.display!="none"){showTooltip($("bDesign"),lm.tt_bDesign,true)}}}function clearTooltip(){var A=$("tooltips");if(!A||A.style.display=="none"){return }$("tooltips").style.display="none";setCookie("tooltip",true)}function showTooltip(D,I,H,A){var G=node("div");G.className="tooltip";var F=findPos(D);if(A){G.style.top=F[1]+D.clientHeight-5}else{G.style.top=F[1]+D.clientHeight-10}if(H){G.style.left=F[0]-223+42}else{if(A){G.style.left=F[0]-25}else{G.style.left=F[0]}}var C=node("div");C.className=(H?"tooltipUpRight":"tooltipUp");G.appendChild(C);var E=node("div");E.className="tooltipIn";G.appendChild(E);var B=node("div");B.className="tooltipDn";G.appendChild(B);E.innerHTML=I;$("tooltips").appendChild(G)}var BUILDER=1,UPDATE=2,BROWSE=5;var HEADER=1,DATA=2;var mode=UPDATE;var ctrl={_init:function(){var K=this,H=document,I=window,G=navigator,B=G.userAgent,F,A,E,D,C,J;K.isOpera=I.opera&&opera.buildNumber;K.isWebKit=/WebKit/.test(B);K.isOldWebKit=K.isWebKit&&!I.getSelection().getRangeAt;K.isIE=!K.isWebKit&&!K.isOpera&&(/MSIE/gi).test(B)&&(/Explorer/gi).test(G.appName);K.isIE6=K.isIE&&/MSIE [56]/.test(B);K.isIE7=K.isIE&&/MSIE [7]/.test(B);K.isIE8=K.isIE&&/MSIE [8]/.test(B);K.isGecko=!K.isWebKit&&/Gecko/.test(B);K.isMac=B.indexOf("Mac")!=-1;K.isAir=/adobeair/i.test(B);K.isChrome=B.toLowerCase().indexOf("chrome")>-1;if($("nui_outer")){ctrl.ctrlHeight=$("nui_outer").offsetTop}if(K.isIE8){K.focusWidth=2;K.focusHeight=2;K.focusTop=-1;K.focusLeft=-1;K.dropdownTop=50}else{if(K.isIE){K.focusWidth=2;K.focusHeight=2;K.focusTop=0;K.focusLeft=0;K.dropdownTop=50}else{if(K.isChrome){K.focusWidth=-2;K.focusHeight=-2;K.focusTop=0;K.focusLeft=0;K.dropdownTop=50}else{K.isFF=true;K.focusWidth=-2;K.focusHeight=-2;K.focusTop=-1;K.focusLeft=-1;K.dropdownTop=30}}}K.updateCellIds=new Array();K.updateCellIndex=0;K.dragging=false;K.propoffset=20;K.multiSelected=new Array();K.NUIRowNum=50;K.NUIRowExtendedNum=50;K.NUIColNum=16;K.TABLE_DEF_ROWS=3;K.dropWin=false;K.nuiLock=false},setWidth:function(G,A,H,C){var B=new Object();if(H){var I=H.split("&"),D;for(D=0;D<I.length;D++){var F=I[D].split("=");if(F.length<2){continue}B[F[0]]=F[1]}}if(B[G]){B[G]=parseInt(B[G])+A}else{B[G]=A}var K="",E=true;for(var J in B){if(!E){K+="&"}K+=J+"="+B[J];if(E){E=false}}C(K)}};ctrl._init();var colNames=["0","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"];function NUI(){var A=this;A.frow=1;A.fcol=1;A.focusChanged=new Array();A.dcelldiv=node("div");A.dcelldivAdded=false;A.dwcells=new Array("");A.dhcells=new Array("");A.highCellRows=new Array();A.main=node("div");A.main.className="nui";A.main_outer=$("nui_outer");A.main.style.width=A.main_outer.clientWidth;A.main.style.height=A.main_outer.clientHeight-(ctrl.isIE?210:90);A.focus=$("focus")}NUI.prototype.init=function(F){var D=this,C=0,B=0,F,A,E;nui._updateFocus();document.body.appendChild(D.dcelldiv);D.main.innerHTML=getDefaultNUIString(F);addEvent(D.main,"scroll",function(G){nui._updateFocus();positionFilterIcons()});addEvent(D.main_outer,"scroll",function(G){nui._updateFocus();positionFilterIcons()});browse.lastFocus=null;if($("nui_outer")){ctrl.ctrlHeight=$("nui_outer").offsetTop}};var defaultNUIString=new Object();function getDefaultNUIString(C){if(defaultNUIString[mode]&&!C){return defaultNUIString[mode]}var B=new Array();var D=C?C:ctrl.NUIRowNum;B.push("<table>");for(i=0;i<=D;i++){B.push("<tr>");for(j=0;j<=ctrl.NUIColNum;j++){B.push("<td id='_"+j+"_"+i+"' ");var A="";if(i!=0&&j!=0){B.push('onclick="cellClick(this);"');B.push('onmousedown="cellMouseDown(this);"');B.push('onmouseover="cellMouseover(this);" ');B.push('ondblclick="cellDblclick(this);" ')}if(j==0&&i==0){B.push('class="sideCell" style="width:50px" ')}else{if(j==0&&i>0){if(theme=="default"||mode==BUILDER){A=i}B.push('class="sideCellLeft" onmouseover="dvcellMouseover(this);" ')}else{if(i==0&&j>0){if(theme=="default"||mode==BUILDER){A=colNames[j]}B.push('class="sideCell" onmouseover="dhcellMouseover(this);" ')}else{if(mode==BUILDER){B.push('class="builderEmpty" ')}else{B.push(" ")}}}}B.push(">"+A+"</td>")}B.push("</tr>")}B.push("</table>");if(C){return B.join("")}defaultNUIString[mode]=B.join("");return defaultNUIString[mode]}NUI.prototype.setScrolling=function(G){var I=this,B=I.main,D=I.main_outer;var H=B.scrollLeft-(document.body.clientLeft?(D.scrollLeft%document.body.clientLeft):0);var F=G.offsetLeft;var E=G.offsetTop;var C=D.offsetHeight-150;var A=D.offsetWidth*(mode==BUILDER?0.7:1)-200;if(F>A+B.scrollLeft){B.scrollLeft=F-A}else{if(F<A){B.scrollLeft=0}else{if(F<B.scrollLeft){B.scrollLeft=F-200}}}if(E>C+B.scrollTop){B.scrollTop=E-C}else{if(E<B.scrollTop){B.scrollTop=E<40?0:E-20}}};NUI.prototype._focus=function(M,L){var P=this;var F=P.main;P._getcell(0,P.frow).className="sideCellLeft";P._getcell(P.fcol,0).className="sideCell";P._blur();P._getcell(0,L).className="sideCellOn";P._getcell(M,0).className="sideCellOn";var I=P.focus,H=I.style,J=P._getcell(M,L),G;I.innerHTML="";I.cell=J;P.fcol=M;P.frow=L;if(J.ip){I.onclick=function(){if(this.cell.ip){this.cell.ip.click()}};I.ondblclick=function(){if(this.cell.ip){this.cell.ip.dblclick()}};J.ip.focus()}else{I.onclick=null}if(mode==BUILDER){if(builder.cellData[M+","+L]){saveBuilderMode(BUILDER_FIELDS)}else{if(builder.freeData[M+","+L]){saveBuilderMode(BUILDER_TEXT)}else{saveBuilderMode()}}if(builder.mode==BUILDER_FIELDS){var D=nui._getcell(M-1,L);var N=nui._getcell(M+1,L);if(J.className!="builderFocusRight"){if(D.builderField){var K=true;for(G=1;G<=ctrl.TABLE_DEF_ROWS;G++){var B=nui._getcell(M,L+G);if(B.className!="builderEmpty"){K=false;break}}if(J.builderField){K=true}if(K){J.oldClassName=J.className;J.className="builderFocus";P.focusChanged.push(J);for(G=1;G<=ctrl.TABLE_DEF_ROWS;G++){var B=nui._getcell(M,L+G);B.oldClassName=B.className;B.className="builderFocusRight";P.focusChanged.push(B)}}}else{if(N&&!N.builderField){J.oldClassName=J.className;J.className="builderFocus";N.oldClassName=N.className;N.className="builderFocusRight";P.focusChanged.push(J);P.focusChanged.push(N)}}}else{var O=nui._getcell(M-2,L);if(D.builderField&&(!O||!O.builderField)){var K=true;for(G=1;G<=ctrl.TABLE_DEF_ROWS;G++){var C=nui._getcell(M,L+G);var A=nui._getcell(M-1,L+G);if(C.className!="builderEmpty"){K=false}if(A.className!="builderEmpty"){K=false}}if(K){J.oldClassName=J.className;J.className="builderFocus";P.focusChanged.push(J);for(G=1;G<=ctrl.TABLE_DEF_ROWS;G++){var C=nui._getcell(M,L+G);var A=nui._getcell(M-1,L+G);C.oldClassName=C.className;C.className="builderFocusRight";A.oldClassName=A.className;A.className="builderFocusRight";P.focusChanged.push(C);P.focusChanged.push(A)}}}}if(propOn){setPropertyTable(J)}}if(builder.mode==BUILDER_TEXT){setStylePane(builder.freeData[M+","+L])}}P.setScrolling(J);P._updateFocus();var E=$("hin");if(J.ip){E.value=J.ip.type==SELECTOR?J.ip.userInput:J.ip.value;E.oldValue=J.ip.type==SELECTOR?J.ip.userInput:J.ip.value}else{E.value=""}E.focus();E.select();return true};NUI.prototype._blur=function(){var C=this,F=C._curcell(),B;if(F.ip&&F.className=="builderFocusRight"){F.ip=null}if(F.ip){F.ip.blur()}if(mode==BUILDER){var E=F.ip;if(E&&E.type==TYPER&&E.changed){E.changed=false;builder.setContent(nui.fcol,nui.frow,E.value?E.value:"");var D=C._getcell(C.fcol-1,C.frow);var A=C._getcell(C.fcol+1,C.frow);if(F.ip.value==""){if(D.builderField&&A.builderField){nui.init();shiftData(C.fcol,-1,true,C.frow);builder.renderAll()}if(D&&D.ip&&D.ip.biff){D.ip.biff.unrender();D.ip.biff.render()}C._setFocusColorBack(true)}else{if(builder.mode==BUILDER_FIELDS){setBorderClass(F,"url(/sims/img/header.png)");C.focusChanged=new Array()}}if(D.builderField){builder.cellData[C.fcol-1+","+C.frow].render()}}else{C._setFocusColorBack()}}};NUI.prototype._updateFocus=function(){var C=this;if(mode==BROWSE){C.focus.style.display="none";return }var B=C.main,F=C.main_outer;var H=C._getcell(C.fcol,C.frow);if(!H){return }var E=C.focus,A=E.style;var D=B.scrollLeft;var G=D?D-(D%document.body.clientWidth):0;A.display="";A.width=H.clientWidth+ctrl.focusWidth;A.height=H.clientHeight+ctrl.focusHeight;A.top=H.offsetTop-B.scrollTop+ctrl.ctrlHeight+ctrl.focusTop;A.left=H.offsetLeft-B.scrollLeft+ctrl.focusLeft;E.cell=H;if(H.ip){H.ip.render()}};NUI.prototype._move=function(A,C){var B=this;B._focus(Math.min(Math.max(1,B.fcol+A),ctrl.NUIColNum),Math.min(Math.max(1,B.frow+C),ctrl.NUIRowNum))};NUI.prototype.moveInit=function(){ctrl.updateCellIndex=0;this.hmove(0)};NUI.prototype.hmove=function(A){var C=this;ctrl.updateCellIndex+=A;if(ctrl.updateCellIndex<0){ctrl.updateCellIndex=0}if(ctrl.updateCellIndex>=ctrl.updateCellIds.length){ctrl.updateCellIndex=ctrl.updateCellIds.length-1}var D=ctrl.updateCellIds[ctrl.updateCellIndex];if(!D){return }var B=D.split("_");C._focus(parseInt(B[1]),parseInt(B[2]))};NUI.prototype.vmove=function(B){var E=this;var A=E.frow;var D=0;var H=null;var G=null;var F=20;while(!H&&F>0){if(D<=0){A+=B;D=E.fcol}else{D--}G="_"+D+"_"+A;var C=E._getcell(D,A);H=C?C.ip:null;F--}if(F==0){return }E._focus(D,A);ctrl.updateCellIndex=indexOf(G,ctrl.updateCellIds)};NUI.prototype.keyUp=function(E){if(!E){return }var H=this._curcell(),I=this;var D=false;var G=E.keyCode;var B=nui._getcell(I.fcol-1,I.frow);var C=H&&H.oldClassName=="builderFocusRight"&&B.builderField;if(mode==BUILDER&&H&&!H.ip&&$("hin").value.length>0&&(H.oldClassName=="builderEmpty"||C||builder.mode==BUILDER_TEXT)){if(builder.mode==BUILDER_FIELDS&&C){var A=builder.cellData[I.fcol-1+","+I.frow].IPType;if(A==SELECTOR||A==MSELECTOR){floatWin(null,"A select field can not be the first field of a table.<br/>Please add a text field instead.\nYou can set the default value to $SEQ for auto sequence defaulting.");return }}H.ip=new Typer();H.ip.cell=H;H.ip.focused=true;H.ip.inputBox=node("input");H.ip.loadValue("")}if(G==27&&(!H||!H.ip||!H.ip.typing)){window.setTimeout("nui._blur();backToBrowse();",500)}else{if((G==13&&H.ip.type==TYPER&&!nui._atHighRow())&&(H&&H.ip&&!H.ip.typingLock)){var F=$("hin").value;H.ip.loadValue(F);H.ip.render();return false}else{if((G>=37&&G<=40)&&(H&&H.ip&&!H.ip.typingLock&&!H.ip.typing)){$("hin").focus();$("hin").select()}else{if(H&&H.ip){if(H.ip.keyUp(E)){D=true}}}}}};NUI.prototype.keyDown=function(G){if(!G){return false}var F=G.altKey;var E=G.ctrlKey;var B=G.shiftKey;var D=this,A=D._curcell();var C=false;if(A&&A.ip){if(!A.ip.keyDown(G)){C=true}}if(!C&&mode!=BROWSE){if(!G){G=window.event}var H=G.keyCode;switch(H){case 13:if(mode==BUILDER){nui._move(0,1)}else{nui.vmove(1)}return 123;break;case 9:if(mode==BUILDER){nui._move(1,0)}else{nui.hmove(1)}return 123;break;case 83:if(F||E){if(mode==UPDATE){submitNUIForm();return 123}else{if(mode==BUILDER){saveBuilder();return 123}}}break}if(A&&A.ip&&A.ip.typingLock){return true}switch(H){case 37:if(mode==BUILDER){nui._move(-1,0)}else{nui.hmove(-1)}break;case 39:if(mode==BUILDER){nui._move(1,0)}else{nui.hmove(1)}break;case 38:if(mode==BUILDER){nui._move(0,-1)}else{nui.vmove(-1)}break;case 40:if(mode==BUILDER){nui._move(0,1)}else{nui.vmove(1)}break;default:return true}return false}};NUI.prototype._getcell=function(A,D){var C=this.main;if(!C||D<0){return null}var B=C.firstChild.rows[D];if(!B||!B.cells||A<0){return null}return B.cells[A]};NUI.prototype._removecell=function(A,D){var C=this.main;if(!C||D<0){return }var B=C.firstChild.rows[D];if(!B||!B.cells||A<0||!B.cells[A]){return }B.cells[A].style.display="none"};NUI.prototype._curcell=function(){var A=this;return A._getcell(A.fcol,A.frow)};NUI.prototype._setFocusColorBack=function(A){var C=this,B;if(C.focusChanged.length>0){for(B=0;B<C.focusChanged.length;B++){if(A){C.focusChanged[B].innerHTML="";removeBorderClass(C.focusChanged[B],"builderEmpty")}else{C.focusChanged[B].className=C.focusChanged[B].oldClassName}}}C.focusChanged=new Array()};NUI.prototype.resetWidth=function(){biffdata.widthCommand=null;biffdata.heightCommand=null;var C=1,D=this,B,A=D.main;var E=D._getcell(0,C);while(E){if(embed){E.style.width=70}else{E.style.width=100}C++;E=D._getcell(0,C)}C=1;E=D._getcell(0,C);while(E){if(embed){E.style.height=12}else{E.style.height=16}C++;E=D._getcell(0,C)}};NUI.prototype.addWidth=function(C,F,H){var E=this,B=E._getcell(C,0),D,A=E.main;if(!B){return }var G=parseInt(B.clientWidth)+H;if(G>0){B.style.width=parseInt(B.clientWidth)+H;if(F){F.style.left=parseInt(F.offsetLeft)+H;if(F.dWidth){F.dWidth+=H}else{F.dWidth=H}}}};NUI.prototype.addHeight=function(F,E,G){if(isNaN(F)){return }var I=this,H=I._getcell(0,F),D,B=I.main;var A=parseInt(H.offsetHeight)+G;if(A>0){H.style.height=A;if(E){E.style.top=E.offsetTop+G}if(E){if(E.dHeight){E.dHeight+=G}else{E.dHeight=G}}if(noUnit(H.style.height)>40){var J=nui.main.firstChild.rows[F],C;for(C=0;C<J.cells.length;C++){J.cells[C].style.whiteSpace="normal"}if(indexOf(F,I.highCellRows)==-1){I.highCellRows.push(F)}}}};NUI.prototype._atHighRow=function(){return indexOf(this.frow,this.highCellRows)!=-1};function processWidth(D,A){if(!D){D=""}if(!A){A=""}var E=D.split("&");var F=A.split("&");var C;for(C=0;C<E.length;C++){var B=E[C].split("=");if(B.length<2){continue}nui.addWidth(parseInt(B[0]),null,parseInt(B[1]),true)}for(C=0;C<F.length;C++){var B=F[C].split("=");if(B.length<2){continue}nui.addHeight(parseInt(B[0]),null,parseInt(B[1]),true)}}addEvent(window,"beforeunload",eventWindowBeforeUnload);function eventWindowBeforeUnload(A){if(mode&&mode==UPDATE||(mode==BUILDER&&builder.unsave)){return lm.away}}document.onkeydown=function(B){if(ctrl.outOfNUI||!nui){return }if(!B){B=window.event}var C=B.keyCode;if(ctrl.outOfNUI||!nui){return }if(!ctrl.outOfNUI&&$("hin")){$("hin").focus()}switch(mode){case BROWSE:switch(C){case 33:browsePrevPage();break;case 34:if(!ctrl.pureInsert){browseNextPage()}break;case 38:browse._move(-1);break;case 9:case 40:browse._move(1);break;case 8:case 37:browseBack();break;case 13:case 39:browseForward();break}break;case UPDATE:if(!nui){break}var A=nui.keyDown(B)==123;if(A){return false}break;case BUILDER:if(!nui){break}var A=nui.keyDown(B)==123;if(A){return false}break}};document.body.onmousewheel=function(B){if(!B){B=window.event}var A=B.ctrlKey;if(A&&A.isIE7){return false}};document.onkeyup=function(A){if(ctrl.outOfNUI||!nui){return }if(!A){A=window.event}var B=A.keyCode;switch(mode){case BROWSE:switch(B){case 78:newData();break;case 69:modeUpdate();break;case 68:modeBuilder();break}break;case UPDATE:return nui.keyUp(A);break;case BUILDER:return nui.keyUp(A);break}};window.onresize=eventWindowResize;function eventWindowResize(){if(nui){nui._focus(nui.fcol,nui.frow)}nuiController.resize()}var floatingPanels=new Array();function clearDropWin(){if(!ctrl.dropWin){var A;for(A=0;A<floatingPanels.length;A++){floatingPanels[A].style.display="none"}floatingPanels=new Array()}else{ctrl.dropWin=false}}document.onmousedown=function(A){if(!A){A=window.event}clearMultiSelect()};document.onclick=function(B){if(!B){B=window.event}clearDropWin();clearTooltip();if($("rightKeyFloat")){$("rightKeyFloat").style.display="none"}var A;if(B.which){A=(B.which==3)}else{if(B.button){A=(B.button==2)}}if(A){return showRightKeyMenu(B)}};document.oncontextmenu=function(){return showRightKeyMenu(window.event)};addEvent(document,"mouseup",eventDocumentOnmouseup);function eventDocumentOnmouseup(B){if(!B){B=window.event}var A=ctrl.dragging;endMultiSelect(B);endBuilderMove(B);if(mode==BUILDER&&A){if(A.dWidth){ctrl.setWidth(A.index,A.dWidth,biffdata.widthCommand,function(C){biffdata.widthCommand=C})}else{if(A.dHeight){ctrl.setWidth(A.index,A.dHeight,biffdata.heightCommand,function(C){biffdata.heightCommand=C})}}}if(A){A.dWidth=0;A.dHeight=0;rm(nui.dcelldiv);ctrl.dragging=null}}function endMultiSelect(A){ctrl.multiSelect=null}function clearMultiSelect(){var B;for(B=0;B<ctrl.multiSelected.length;B++){var A=ctrl.multiSelected[B];A.style.backgroundColor=A.tempOldBackgroundColor}ctrl.multiSelected=new Array()}function processMultiSelect(){if(ctrl.multiSelect&&ctrl.multiSelectEnd){browse.focusbcell=-1;browse._focus();clearMultiSelect();var B=ctrl.multiSelect.id;var I=parseInt(B.split("_")[1]);var G=parseInt(B.split("_")[2]);var A=ctrl.multiSelectEnd.id;var J=parseInt(A.split("_")[1]);var H=parseInt(A.split("_")[2]);var M;if(I>J){M=I;I=J;J=M}if(G>H){M=G;G=H;H=M}var L=nui,F,E;var D="";for(E=G;E<=H;E++){var C=true;for(F=I;F<=J;F++){var K=L._getcell(F,E);K.tempOldBackgroundColor=K.style.backgroundColor;K.style.backgroundColor="#FFDDDD";ctrl.multiSelected.push(K);if(!C){D+="\t"}if(K.ip&&K.ip.biff){D+=K.ip.biff.value}else{if(K.biff){D+=K.biff.value}}C=false}D+="\n"}$("hin").value=D;$("hin").focus();$("hin").select()}}addEvent(document,"mousemove",eventDocumentOnmousemove);function eventDocumentOnmousemove(C){if(!C){C=window.event}var A=ctrl.dragging;if(ctrl.builderMoveStart){updateBuilderMove(C)}if(A&&A.className=="dwcell"){var B=parseInt(C.clientX)-noUnit(A.style.left);nui.addWidth(A.index,A,B);nui._updateFocus();positionFilterIcons()}else{if(A&&A.className=="dhcell"){var B=parseInt(C.clientY)-noUnit(A.style.top);nui.addHeight(A.index,A,B);nui._updateFocus()}}}function cellClick(B){if(ctrl.cellClickBlocked){ctrl.cellClickBlocked=false;return }var A=parseInt(B.id.split("_")[1]);var C=parseInt(B.id.split("_")[2]);if(mode==BUILDER){if(!nui._focus(A,C)&&B.ip){B.ip.click()}}else{if(mode==UPDATE){if(B.ip){ctrl.updateCellIndex=indexOf("_"+A+"_"+C,ctrl.updateCellIds)}if(!nui._focus(A,C)&&B.ip){B.ip.click()}}else{if(mode==BROWSE){if(browse.checkClickable()&&!ctrl.dropWin&&ctrl.multiSelected.length==0){browseForward()}}}}}function cellDblclick(B){if(B.ip){var A=parseInt(B.id.split("_")[1]);var C=parseInt(B.id.split("_")[2]);B.ip.dblclick()}}function cellMouseDown(A){if(mode==BUILDER){ctrl.builderMoveStart=A}else{ctrl.multiSelect=A}}function cellMouseover(C){if(ctrl.multiSelect){ctrl.multiSelectEnd=C}else{if(ctrl.builderMoveStart){var B=parseInt(C.id.split("_")[1]);var D=parseInt(C.id.split("_")[2]);if(nui._getcell(B,D).className=="builderFocusRight"){return }ctrl.builderMoveEnd=C;if(ctrl.builderMoveCellMouseover){ctrl.builderMoveCellMouseover.style.backgroundColor=ctrl.builderMoveCellMouseover.tempOldBackgroundColor}C.tempOldBackgroundColor=C.style.backgroundColor;C.style.backgroundColor="#FFDDDD";ctrl.builderMoveCellMouseover=C}else{if(mode==BROWSE&&ctrl.multiSelected.length==0){var A=browse;A.focusbcell=C.browseIndex;A._focus()}}}processMultiSelect()}function cellOnpaste(){var A=nui._curcell();if(A){var B=A.ip;if(B&&B.onpaste){B.onpaste()}}}function processPaste(){var F=$("hin").value,H=nui;while(F.charAt(F.length-1)=="\n"){F=F.substr(0,F.length-1)}$("hin").value=F;if(!nui._atHighRow()){var B,A,D=F.split("\n");var I=H._curcell();var G=parseInt(I.id.split("_")[1]);var E=parseInt(I.id.split("_")[2]);for(B=0;B<D.length;B++){var C=D[B].split("\t");for(A=0;A<C.length;A++){if(B==0&&A==0){$("hin").value=C[A]}else{var J=H._getcell(G+A,E+B);if(J&&J.ip){J.ip.loadValue(C[A]);J.ip.render()}}}}}else{var I=H._curcell();if(I&&I.ip){I.ip.loadValue(F);I.ip.typing=true;I.ip.typingLock=true;I.ip.render();nui._updateFocus()}}}function dvcellMouseover(C){var B=C.id.split("_")[2];if(B!=1){var D=node("div");D.className="dhcell";D.style.top=C.offsetTop+ctrl.ctrlHeight-nui.main.scrollTop-3;D.style.left=C.offsetLeft-nui.main.scrollLeft;D.style.height=6;D.style.width=C.offsetWidth;D.index=B-1;D.onmousedown=function(){ctrl.dragging=this};nui.dcelldiv.appendChild(D)}var A=node("div");A.className="dhcell";A.style.top=C.offsetTop+C.offsetHeight+ctrl.ctrlHeight-nui.main.scrollTop-3;A.style.left=C.offsetLeft-nui.main.scrollLeft;A.style.height=6;A.style.width=C.offsetWidth;A.index=B;A.onmousedown=function(){ctrl.dragging=this};nui.dcelldiv.appendChild(A)}function dhcellMouseover(C){var B=C.id.split("_")[1];if(B!=1){var D=node("div");D.className="dwcell";D.style.top=C.offsetTop+ctrl.ctrlHeight;D.style.left=C.offsetLeft-nui.main.scrollLeft-3;D.style.height=C.offsetHeight;D.style.width=6;D.index=B-1;D.onmousedown=function(){ctrl.dragging=this};nui.dcelldiv.appendChild(D)}var A=node("div");A.className="dwcell";A.style.top=C.offsetTop+ctrl.ctrlHeight;A.style.left=C.offsetLeft+C.offsetWidth-nui.main.scrollLeft-3;A.style.height=C.offsetHeight;A.style.width=6;A.index=B;A.onmousedown=function(){ctrl.dragging=this};nui.dcelldiv.appendChild(A)}function modeBuilder(){if(!owner){return }mode=BUILDER;nui.init();showProp();$("filterIcons").style.display="none";$("bDoneBuild").style.display="";$("bBrowse").style.display="none";$("bEdit").style.display="none";$("bSave").style.display="none";$("bBack").style.display="none";$("bNewData").style.display="none";$("bDeleteEntry").style.display="none";$("bInfo").style.display="none";$("bBuilderSave").style.display="";$("bRichText").style.display="";$("bBuilderMode").style.display="";$("bBuilderSetting").style.display="";$("bDesign").style.display="none";$("bExcel").style.display="none";$("modedesc").innerHTML=lm.builderMode;$("menu").style.backgroundColor="#E6FFBF";adjustPrevNext();read(builder.load,"/sims/form_builder.jsp?a="+encodeURIComponent(ap)+"&p="+encodeURIComponent(path)+"&fn="+encodeURIComponent(sheet),true);nui._focus(1,1);if(biffdata.formType==2){floatWin(null,"This is a <b>listing</b> automatically generated by Ragic. You can remove fields that you do not want, and add descriptions to the form. It is generally not suggested to add fields here.")}}function modeUpdate(){if(biffdata.rights!="W"){floatWin(null,"You don't have access right to enter data here.");return }if(mode==UPDATE){return }mode=UPDATE;displayData();$("bDoneBuild").style.display="none";$("bBrowse").style.display="";$("bEdit").style.display="none";$("bSave").style.display="";$("bBack").style.display="none";$("bNewData").style.display="none";$("bDeleteEntry").style.display="none";$("bInfo").style.display="";$("bBuilderSave").style.display="none";$("bRichText").style.display="none";$("bBuilderMode").style.display="none";$("bBuilderSetting").style.display="none";if(owner){$("bDesign").style.display=""}$("bExcel").style.display="";$("modedesc").innerHTML=lm.editMode;$("menu").style.backgroundColor="#FFCFCF";adjustPrevNext();browse._nofocus();nui.moveInit()}function modeBrowse(){mode=BROWSE;$("nui").style.width=30000;$("nui").style.height=30000;$("propDiv").style.display="none";$("bDoneBuild").style.display="none";$("bBrowse").style.display="none";$("bEdit").style.display="";$("bSave").style.display="none";$("bBack").style.display="";$("bNewData").style.display="";if(owner){$("bDeleteEntry").style.display=""}$("bInfo").style.display="";$("bBuilderSave").style.display="none";$("bRichText").style.display="none";$("bBuilderMode").style.display="none";$("bBuilderSetting").style.display="none";if(owner){$("bDesign").style.display=""}$("bExcel").style.display="";$("modedesc").innerHTML=lm.browseMode;$("menu").style.backgroundColor="";hideEditElements();if(nui){nui.init()}nuiController.load("","&pd=0",function(){browse._init();browse._focus();if(biffdata.formType=="2"){$("bBack").style.display="none";$("bNewData").style.display="";$("bDeleteEntry").style.display="none";$("bEdit").style.display="none"}else{$("bBack").style.display="";$("bNewData").style.display="none";if(owner){$("bDeleteEntry").style.display=""}$("bEdit").style.display=""}adjustPrevNext()})}function setBuilderSelectBox(A){var C=node("div");C.style.cssFloat="left";C.style.display="inline";C.innerHTML="<font color=#CCCCCC>List of Value</font>";A.appendChild(C);var B=node("span");B.className="selbut";B.innerHTML='<p style="line-height:14px">▼</p>';A.appendChild(B)}function shift(B,A,E,C,D){if(!B){return }if(D&&(C&&D!=B.y||!C&&D!=B.x)){return }if(!C&&B.y>A){B.y+=E}else{if(C&&B.x>A){B.x+=E}}}function shiftData(C,B,D,G){var I=shift,A,J=new Object(),F=new Object();if(mode==BUILDER){for(var H in builder.cellData){var E=builder.cellData[H];if(!E){continue}I(E,C,B,D,G);J[E.x+","+E.y]=E}builder.cellData=J;for(var H in builder.freeData){var E=builder.freeData[H];if(!E){continue}I(E,C,B,D,G);F[E.x+","+E.y]=E}builder.freeData=F}else{for(A=0;A<biffdata.biffs.length;A++){I(biffdata.biffs[A],C,B,D,G)}}shiftWidth(D,C,B)}function shiftWidth(C,A,F){var E,D;if(C&&biffdata.widthCommand){E=biffdata.widthCommand.split("&")}else{if(biffdata.heightCommand){E=biffdata.heightCommand.split("&")}}for(D=0;E&&D<E.length;D++){var G=E[D].split("=");if(G.length<2){continue}var B=parseInt(G[0]);if(B>A){G[0]=B+F;E[D]=G[0]+"="+G[1]}}if(C&&biffdata.widthCommand){biffdata.widthCommand=E.join("&")}else{if(biffdata.heightCommand){biffdata.heightCommand=E.join("&")}}}function copyDataY(B){var D;for(i=0;i<biffdata.biffs.length;i++){var A=biffdata.biffs[i];if(!A||A.IPType==SELECTION){continue}if(A.y==B){var C=new Biff(A.sec,A.dataType);C.y++;C.sec[2]=C.y;C.nodeId=--ctrl.minNodeId;C.value="";if(!D){D=C}else{C.parentDomainId=D.domainId;C.parentNodeId=D.nodeId}biffdata.biffs.push(C)}}}function displayData(){var X=$("nuiform");var B=biffdata;rm(X);var s=node("input");s.type="hidden";s.value=path;s.name="P_path";var c=node("input");c.type="hidden";c.value=sheet;c.name="P_sheet";X.appendChild(s);X.appendChild(c);nui.init(B.maxY);ctrl.updateCellIds=new Array();var N=new Object();var P=true;ctrl.pureInsert=false;var G=node;var o=ctrl;var u=nui;var Y=setBorderClass;var l=B.biffs;var D=X.appendChild;var q=cellRender;var g=parseInt;var m=indexOf;var r,p;for(r=0;r<B.selections.length;r++){var a=B.selections[r],H=new SelectList();for(p=3;p<a.length;p++){var d=a[p].split("|");H.nodeIds.push(d[0]);H.options.push(d[1])}selpro.domains[a[1]]=H;H.init()}adjustPrevNext();processWidth(B.widthCommand,B.heightCommand);if(biffdata.formType=="2"){$("filterIcons").innerHTML=""}for(r=0;r<l.length;r++){var t=l[r];if(!t){continue}var F=t.dataType;var Z=t.IPType;var n=""+t.nodeId;var T=n?n.split("\\|")[0]:null;var K=t.originalNodeId?""+t.originalNodeId.split("\\|")[0]:null;var J=t.domainId;var h=t.x;var f=t.y;if(P&&F==DATA){if(T<0){o.pureInsert=true}P=false}if(F==HEADER){var U=u._getcell(h,f);if(!U){continue}if(Z=="F"){for(var O in t.attr){if(!O||!t.attr[O]){continue}U.style[O]=t.attr[O]}if(t.action){U.action=t.action;U.style.cursor="pointer";var e;if(U.action.indexOf("?")!=-1){e="&"}else{e="?"}U.onclick=function(){open(this.action+e+"dd="+B.rootDomainId+"&dni="+B.rootNodeId)};U.onmouseover=function(){this.style.opacity=0.7};U.onmouseout=function(){this.style.opacity=1}}q(U,t.value)}else{if(Z=="D"||Z=="L"||Z=="U"||Z=="G"||Z=="M"){Y(U,"url(/sims/img/header.png)");U.biff=t;U.innerHTML=cellTextProcess(t.value);var C=u._getcell(h-1,f);if(C){C.style.overflowX="hidden"}if(B.formType=="2"){U.domainId=t.domainId;U.showFilterPanel=showFilterPanel;var V=node("img");V.src="/sims/img/drop.png";var E=$("filterIcons");E.appendChild(V);V.poscell=U;addEvent(V,"click",function(){this.poscell.showFilterPanel()});V.style.cursor="pointer";V.style.position="absolute";V.id="arrow"+t.domainId;E.style.display="none"}}}}else{if(Z=="D"||Z=="L"||Z=="U"||Z=="G"||Z=="M"){var U=u._getcell(h,f);if(!U){continue}o.updateCellIds.push(U.id);Y(U);var C=u._getcell(h-1,f);var k=u._getcell(h+1,f);if(C){C.style.overflowX="hidden"}var S;if(t.ip){S=t.ip;if(Z=="L"||Z=="M"){if(t.attr&&t.attr.ln){var L=t.attr.ln;var W=B.findBiff(L,t.y);S.selectList=selpro.getSelectList(J,L,W.nodeId)}else{S.selectList=selpro.getSelectList(J)}if(S.listdiv){S.listdiv=null}}}else{if(Z=="D"){S=new Typer()}else{if(Z=="L"){if(t.attr&&t.attr.ln){var L=t.attr.ln;var W=B.findBiff(L,t.y);S=new Selector(J,L,W.nodeId)}else{S=new Selector(J)}}else{if(Z=="M"){S=new MSelector()}else{if(Z=="U"||Z=="G"){S=new Uploader(Z)}}}}}t.ip=S;U.ip=S;U.ip.cell=U;S.biff=t;if(!N[J]){N[J]=0}S.domainNodeSeq=N[J]++;var M=t.value?t.value:(t.attr&&(t.attr.dv||t.attr.em)?processDefaultValue(t):"");S.loadValue(M,Z=="L");S.domainId=g(J);S.nodeId=n;o.minNodeId=o.minNodeId?Math.min(o.minNodeId,S.nodeId):S.nodeId;S.parentDomainId=g(t.parentDomainId);S.parentNodeId=g(t.parentNodeId);if(t.attr){S.readOnly=t.attr.ro;if(t.attr.cs){U.colSpan=t.attr.cs;var Q=parseInt(t.attr.cs),p;setBorderClass(U,"",Q);for(p=(ctrl.isIE8?2:1);p<Q;p++){u._removecell(h+p,f)}}if(m(J,B.notify)!=-1){S.notify=true}if(t.attr.f){formulaBuilder.add(biffdata.domainIdCellMapping[t.domainId],S,t.attr.f)}}S.render();var R=createControlBitString(t);if(Z=="L"){var A;A=G("textarea");A.style.display="none";A.id="IX"+h+"Y"+f;S.inputBox=A;A.name="L_"+R+"_"+t.parentDomainId+"_"+J+"_"+t.parentNodeId;A.value=parseInt(T);var I=G("textarea");I.style.display="none";I.id="IX"+h+"Y"+f;I.name="U_"+R+"_"+t.parentDomainId+"_"+J+"_"+t.parentNodeId;I.value=parseInt(K);if(o.isIE){D(I);D(A)}else{X.appendChild(I);X.appendChild(A)}if(Z=="L"){S.loadValue(S._getSuggest(),true)}}else{if(Z=="M"){}else{S.nodeId=g(T);var A;if(Z=="U"||Z=="G"){A=S.createUploadInputElement();M=""}else{A=G("textarea");A.style.display="none";A.id="IX"+h+"Y"+f}S.inputBox=A;if(T<0||(t.attr&&t.attr.im)){A.name="I_"+R+"_"+J+"_"+T+"_"+t.parentDomainId+"_"+t.parentNodeId;A.value=M;if(t.attr&&t.attr.ag){A.value=t.attr.ag;S.loadValue(t.attr.ag,lm.AutoGen);S.readOnly=true;S.render()}}else{A.name="M_"+R+"_"+J+"_"+T;A.value=M}if(Z!="U"&&Z!="G"){if(o.isIE){D(A)}else{X.appendChild(A)}}}}}}}if(mode!=BUILDER){showFilterIcons()}nui._updateFocus();positionFilterIcons();if(loadingBox){loadingBox.style.display="none"}}function createControlBitString(A){if(!A||!A.attr){return"00000"}var B=new String("1");var C=new String("0");return(A.attr.ag?B:C)+(A.attr.dv?B:C)+(A.attr.im?B:C)+(A.attr.em?B:C)+(biffdata.rootDomainId==A.domainId?B:C)}function showFilterPanel(){var B=$("filterPanel");if(B.style.display==""){B.style.display="none";return }B.style.top=this.offsetTop+this.clientHeight+ctrl.ctrlHeight-nui.main.scrollTop;B.style.left=this.offsetLeft-nui.main.scrollLeft;B.style.width=this.clientWidth;B.style.display="";B.domainId=this.domainId;floatingPanels.push(B);ctrl.dropWin=true;var A=$("filterOptions");A.domainId=this.domainId;A.innerHTML="";if(this.biff.IPType!=SELECTOR){return }read(function(G){var D=G.responseText.split("\n"),C;for(C=0;C<D.length;C++){var F=D[C].split("|");if(F.length<2){continue}var E=node("div");E.style.border="1px solid #e5e5e5";E.domainId=A.domainId;E.nodeId=F[0];addEvent(E,"click",filterOptionClick);addEvent(E,"mouseover",function(){this.style.backgroundColor="#F6F6F6";this.style.border="1px solid #AAA"});addEvent(E,"mouseout",function(){this.style.backgroundColor="";this.style.border="1px solid #E5E5E5"});E.innerHTML=F[1];A.appendChild(E)}},"/sims/options.jsp?a="+ap+"&d="+this.domainId)}function filterOptionClick(){nuiController.load("","&fni="+this.nodeId+"&fd="+this.domainId,function(){if(mode==BROWSE){browse._init()}browse._focus()})}function cellRender(A,C,D){if(!A||!C){return }if(D){if(ctrl.isIE&&C.toString().indexOf("\n")!=-1){A.style.width="100%";var B=node("div");B.innerHTML=cellTextProcess(C);A.appendChild(B);A.style.height=B.offsetHeight}else{A.innerHTML=cellTextProcess(C)}return }if(ctrl.isIE){var E=node("div");E.style.overflow="visible";E.innerHTML=cellTextProcess(C);E.noWrap=true;E.style.zIndex=999;E.style.position="absolute";E.style.top=A.offsetTop+3;E.style.left=A.offsetLeft+3;A.appendChild(E)}else{A.style.overflow="visible";A.style.whiteSpace="noWrap";A.innerHTML=cellTextProcess(C)}}function adjustPrevNext(){if(mode!=BROWSE){$("bPrevPage").style.display="none";$("bPrevPageD").style.display="none";$("bNextPage").style.display="none";$("bNextPageD").style.display="none";showAllTooltip();return }if(biffdata.prevButton=="F"){$("bPrevPage").style.display="none";$("bPrevPageD").style.display=""}else{$("bPrevPage").style.display="";$("bPrevPageD").style.display="none"}if(biffdata.nextButton=="F"){$("bNextPage").style.display="none";$("bNextPageD").style.display=""}else{$("bNextPage").style.display="";$("bNextPageD").style.display="none"}showAllTooltip()}var selpro={domains:new Object(),getSelectList:function(D,C,B){var A;if(C&&B){A=this.domains[D+"_"+C+"_"+B]}else{A=this.domains[D]}if(!A){A=new SelectList();A.init()}return A}};function SelectList(){var A=this;A.options=new Array();A.nodeIds=new Array();A.match=new Array();A.matchNodeIds=new Array();A.container=node("div");A.highlighted=-1;A.init=function(){var C,B=this,D=B.container;D.className="selector";D.style.display="none";D.selector=this;document.body.appendChild(D)};A.remove=function(){document.body.removeChild(this.container)};A.place=function(D){if(!D){return }var E=this,C=D.cell,F=E.container.style;var B=nui.main;F.top=C.offsetTop+C.clientHeight+ctrl.ctrlHeight-B.scrollTop;F.left=C.offsetLeft-B.scrollLeft;F.width=C.clientWidth;F.display="";floatingPanels.push(E.container);this.selector=D};A.listMulti=function(B,F,M,G){var N=node("table");N.className="selector";var L=new Array();N.opdivArray=L;var O=N.insertRow(0),H;var K=G.toString().split("|");for(i=0;i<A.options.length;i++){if(!A.options[i]||!A.nodeIds[i]){continue}if(!H||H.childNodes.length%20==0){H=O.insertCell(O.cells.length);H.style.verticalAlign="top"}var E=node("div");E.noWrap=true;E.className="selItemOff";E.table=N;addEvent(E,"mouseover",function(){this.className="selItemOn"});addEvent(E,"mouseout",function(){this.className="selItemOff"});addEvent(E,"click",function(){this.childNodes[0].checked=!this.childNodes[0].checked;var Q,S=this.table.opdivArray,P="";for(Q=0;Q<S.length;Q++){if(!S[Q]){continue}var R=S[Q];if(R.firstChild.checked){if(P.length>0){P+="|"+R.value}else{P+=R.value}}}this.table.ip.loadValue(P);this.table.ip.render();ctrl.dropWin=true});var C="L_"+createControlBitString()+"_"+F+"_"+B+"_"+M;var D=A.options[i];var J="U_"+createControlBitString()+"_"+F+"_"+B+"_"+M;var I=indexOf(A.nodeIds[i],K)!=-1;E.value=D;E.innerHTML='<input type=checkbox name="'+C+'" value="'+A.nodeIds[i]+'" '+(I?'checked="checked"':"")+' onclick="this.checked=!this.checked" />&nbsp;&nbsp;'+D+(I?'<input type=hidden name="'+J+'" value="'+A.nodeIds[i]+'" />':"");H.appendChild(E);N.opdivArray.push(E)}if(A.options.length==0){H=O.insertCell(0);H.innerHTML="<font color=#AAAAAA>No Value</font>"}return N};A.listAll=function(){var C=this,B,F=C.container;rm(F);for(B=0;B<C.options.length;B++){if(!C.options[B]||!C.nodeIds[B]){continue}var E=node("div");E.noWrap=true;E.className="selItemOff";var D=C.options[B];addEvent(E,"mouseover",function(){this.className="selItemOn"});addEvent(E,"mouseout",function(){this.className="selItemOff"});E.option=D;E.nodeId=C.nodeIds[B];E.container=F;E.selector=C.selector;E.onclick=opdivclick;E.innerHTML=D;F.appendChild(E)}if(C.options.length==0){F.innerHTML="<font color=#AAAAAA>No Value</font>"}C.highlighted=0};A.listMatch=function(D){var C=this,B,I=C.container;var G=new Array();var E=new Array();for(B=0;B<C.options.length;B++){if(!C.options[B]||!C.nodeIds[B]){continue}if(C.options[B].substr(0,D.length).toUpperCase()==D.toUpperCase()){G.push(C.options[B]);E.push(C.nodeIds[B])}}if(G.length==0){return false}C.match=G;C.matchNodeIds=E;rm(I);for(B=0;B<C.match.length;B++){var H=node("div");H.noWrap=true;H.className="selItemOff";var F=C.match[B];addEvent(H,"mouseover",function(){this.className="selItemOn"});addEvent(H,"mouseout",function(){this.className="selItemOff"});H.option=F;H.nodeId=C.matchNodeIds[B];H.selector=C.selector;H.onclick=opdivclick;H.innerHTML="<b>"+F.substr(0,D.length)+"</b>"+F.substring(D.length,F.length);I.appendChild(H)}C.highlighted=-1;return true};A.moveop=function(C){var D=this,E=D.container;if(D.highlighted>=0&&D.highlighted<E.childNodes.length){E.childNodes[D.highlighted].className="selItemOff"}D.highlighted+=C;if(D.highlighted<0){D.highlighted=0}else{if(D.highlighted>=E.childNodes.length){D.highlighted=E.childNodes.length-1}}var B=E.childNodes[D.highlighted];B.className="selItemOn";this.selector.userInput=B.option}}function getInput(){var A=$("hin").value;if(A=="\n"&&!nui._atHighRow()){return""}$("hin").value="";return A}function opdivclick(){if(mode!=UPDATE){floatWin(null,"You can only make modifications in editing mode.");return }var A=this.selector;if(A){A.loadValue(this.option);A.highlight=true;A.render()}if(this.container){this.container.style.display="none"}$("hin").focus()}var SELECTOR="L",TYPER="D",SELECTION="S",UPLOADER="U",GRAPHICS="G",MSELECTOR="M",FREE="F";function Selector(C,B,A){this.type=SELECTOR;this.domainId=C;this.userInput="";this.highlight=false;this.selectList=selpro.getSelectList(C,B,A)}Selector.prototype.keyDown=function(B){if(this.readOnly){return true}var C=B.keyCode;var A=B.shiftKey;switch(C){case 8:this._backspace(1);break;case 46:this._backspace();break;case 38:if(this.selectList.container.style.display!="none"){this.selectList.moveop(-1);return false}case 40:if(this.selectList.container.style.display!="none"){this.selectList.moveop(1);return false}}return true};Selector.prototype.keyUp=function(A){if(this.readOnly){return false}var B=getInput();if(B&&B.length>0){this._write(B)}return true};Selector.prototype._backspace=function(A){if(this.highlight||!A){this.userInput=""}else{this.userInput=this.userInput.substr(0,this.userInput.length-A)}this.highlight=false;this.selectList.place(this);this.render()};Selector.prototype._write=function(B){var A=this.userInput;if(this.highlight){A=B}else{A+=B}this.highlight=false;if(this.selectList.listMatch(A)){this.userInput=A;this.selectList.place(this);this.render()}else{if(this.userInput==""){this.selectList.listAll();this.selectList.place(this);this.render()}}};Selector.prototype.click=function(){};Selector.prototype.dblclick=function(){};Selector.prototype.focus=function(){this.highlight=true;nui.focus.onclick=selectorClick};Selector.prototype.blur=function(){var A=this;A.highlight=false;nui.focus.onclick=null;A.loadValue(A._getSuggest());A.render();clearDropWin()};Selector.prototype.loadValue=function(E,B){var D=this;D.userInput=E;if(D.biff&&D.inputBox){var F=D._getSuggest();var C=D._getSuggestNodeId();D.biff.value=F;D.biff.nodeId=C;D.inputBox.value=C;if(D.notify&&D.oldSuggest!=F&&!B){var A=D.biff;D.oldSuggest=F;if(C&&C.length>0){read(biffdata.loadData,"/sims/form_subform.jsp?a="+ap+"&p="+encodeURIComponent(path)+"&fn="+encodeURIComponent(sheet)+"&x="+A.x+"&y="+A.y+"&d="+A.domainId+"&n="+C,true)}}}if(mode==UPDATE&&!B&&D.biff&&D.biff.ifCreateInsertRow()&&E&&E.length>0&&(D.biff.attr&&E!=D.biff.attr.dv)){shiftData(this.biff.y,1);copyDataY(this.biff.y);displayData()}};Selector.prototype.render=function(){var G=this.cell;if(this.readOnly){G.style.backgroundColor="#F6F6F6"}var I=nui.focus;G.style.width="100%";G.innerHTML="";var C=node("div"),H=this;G.appendChild(C);var F=node("span");F.className="selbut";F.innerHTML="&nbsp;";F.cell=G;F.onmouseover=function(){this.className="selbutOn"};F.onmouseout=function(){this.className="selbut"};F.onclick=selectorClick;G.appendChild(F);var D=H._getSuggest(true);var E=H.emptyValue&&H.userInput=="";var B=node("span");B.className=H.highlight&&!E?"cellSuggest":"cellText";var A=node("span");A.className="cellSuggest";C.appendChild(B);C.appendChild(A);if(E){B.innerHTML=H.emptyValue}else{B.innerHTML=H.userInput}A.innerHTML=D.substring(H.userInput.length,D.length);if(A.innerHTML.length==0){A.style.backgroundColor="white"}};Selector.prototype._getSuggest=function(B){this.selectList.listMatch(this.userInput);if(this.userInput==""){return""}var A=this.selectList.highlighted;var C;if(A>=0){C=A}else{C=indexOf(this.userInput,this.selectList.match);if(!B&&C==-1){C=0}}var D=this.selectList.match[C];if(C==-1){return""}else{if(D){return D}else{return""}}};Selector.prototype._getSuggestNodeId=function(){if(this.userInput==""){return""}var A=this.selectList.matchNodeIds[0];if(A){return A}else{return""}};Selector.prototype.clear=function(){this.userInput="";this.render()};function selectorClick(){var B=this.cell.ip;if(B.readOnly){return }if(B.selectList.container.style.display!="none"){B.selectList.container.style.display="none"}else{var A=parseInt(this.cell.id.split("_")[1]);var C=parseInt(this.cell.id.split("_")[2]);nui._focus(A,C);ctrl.cellClickBlocked=true;clearDropWin();B.selectList.place(B);B.selectList.listAll()}ctrl.dropWin=true}function Typer(){this.type=TYPER;this.typing=false;this.focused=false}Typer.prototype.keyDown=function(D){if(this.readOnly){return true}var F=D.keyCode,I=this;var C=D.altKey;switch(F){case 46:if(!I.typing){var B=nui._getcell(nui.fcol-1,nui.frow);var G=B&&B.ip;var H=nui._getcell(nui.fcol+1,nui.frow);var J=H&&H.ip;var A=!G&&J;if(A&&mode==UPDATE){deleteEntry(this.domainId,this.nodeId)}else{I.clear();I.typing=true;I.render()}}break;case 8:if(!I.typing){I.clear();I.typing=true;I.render()}break}var E=F==13&&(C||nui._atHighRow());return !E};Typer.prototype.keyUp=function(F){if(this.readOnly){return true}var D=$("hin");var A=this.cell;var H=F.keyCode;var E=F.altKey;var G=H==13&&(E||nui._atHighRow());if(!this.typing&&D.value!=D.oldValue){this.typing=true;if(mode==UPDATE&&this.biff&&this.biff.ifCreateInsertRow()){shiftData(this.biff.y,1);copyDataY(this.biff.y);biffdata.debug();displayData()}}if(G){if(E){$("hin").value+="\n"}if(ctrl.isIE){var C=$("hin").createTextRange();C.move("character",$("hin").value.length);C.select()}}if(H==27&&$("hin").oldValue&&this.typing){this.loadValue($("hin").oldValue);$("hin").value=$("hin").oldValue;$("hin").oldValue="";A.ip.typing=false;return true}var B=$("hin").value;this.loadValue(B);this.render();return !G};Typer.prototype.onpaste=function(){window.setTimeout(processPaste,100)};Typer.prototype.click=function(){if(this.typing){this.typingLock=true}};Typer.prototype.dblclick=function(){var A=this;if(!A.typing){$("hin").value=this.value;setCaretTo($("hin"),this.value.length);this.typing=true;this.render();this.typingLock=true}};Typer.prototype.focus=function(){this.focused=true};Typer.prototype.blur=function(){var A=this;A.validate();A.typing=false;A.typingLock=false;A.render();A.focused=false};Typer.prototype.validate=function(C){var A=this;if(A.biff&&A.biff.attr&&A.biff.attr.va){var B=new RegExp(A.biff.attr.va);if(!B.test(A.value)){if(!C){floatWin(null,"Your value format is not correct.")}return false}}return true};Typer.prototype.loadValue=function(E,C){var B=this,A=B.biff;if(E!=B.oldValue){B.changed=true}B.value=E;B.oldValue=E;B.displayValue=C;if(B.inputBox){B.inputBox.value=E}if(A){A.value=E}if(mode!=BUILDER){var D=biffdata.domainIdCellMapping[A.domainId];if(!biffdata.formulaMap[D]){biffdata.formulaMap[D]=new Object()}biffdata.formulaMap[D][A.y]=A.value;formulaBuilder.update(D,A)}};Typer.prototype._renderFocus=function(A){var B=this;if(B.typing){var C=$("hin"),D=C.style;D.width=A.offsetWidth;D.height=A.offsetHeight;D.top=A.offsetTop;D.left=A.offsetLeft;D.display=""}else{hideEditElements()}};Typer.prototype._renderCell=function(A){var B=this;if(B.readOnly){A.style.backgroundColor="#F6F6F6"}else{if(mode!=BUILDER){A.style.backgroundColor=""}}cellRender(A,B.displayValue?B.displayValue:B.value,true)};Typer.prototype.render=function(){var A=nui.focus,B=this;B.cell.style.width="100%";if(!B.typing){B._renderCell(B.cell)}if(B.focused){B._renderFocus(A)}};Typer.prototype.clear=function(){$("hin").value=""};function cellTextProcess(B){if(!B){return B}B=B.toString();var A=/\r\n/gim;B=B.replace(A,"<br/>");A=/\n/gim;B=B.replace(A,"<br/>");A=/(^|[^=\[\]"'])http:\/\/([^\s><]+)/gim;B=B.replace(A,"$1<a href='http://$2' target=_blank>http://$2</a>");A=/([^=\[\]"'])https:\/\/([^\s><]+)/gim;B=B.replace(A,"$1<a href='https://$2' target=_blank>https://$2</a>");A=/\[img\][\s]*([^\[]+)\[\/img\]/gim;B=B.replace(A,"<img class=nuiImg src='$1' />");A=/[ ]{2}/gim;B=B.replace(A,"&nbsp;&nbsp;");A=/[\t]/gim;B=B.replace(A,"&nbsp;&nbsp;&nbsp;&nbsp;");return B}function loadTextProcess(A){if(!A){return A}A=A.replace(/<br\/>/gim,"\n");A=A.replace(/&#44;/gim,",");return A}var currentBiff;var propOptions;var propOptionIds;var choicesDomainId;function setPropertyTable(C){if(!C||!C.biff){$("prop").innerHTML="";return }else{resetPropertyTable()}var B=C.biff;currentBiff=B;$("at_name").innerHTML=B.value;$("at_spid").innerHTML="_ragic_"+B.domainId+"_?";$("f_ag").style.display="none";if(B.IPType==SELECTOR||B.IPType==MSELECTOR){$("f_ch").style.display="";if(B.IPType==SELECTOR){$("at_it").selectedIndex=1}else{if(B.IPType==MSELECTOR){$("at_it").selectedIndex=4}}choicesDomainId=B.domainId;initChoices()}else{if(B.IPType==UPLOADER){$("at_it").selectedIndex=2}else{if(B.IPType==GRAPHICS){$("at_it").selectedIndex=3}else{$("f_ag").style.display=""}}$("f_ch").style.display="none"}if(!B.attr){B.attr=new Object()}if(B.attr){var A=$("at_l").options[$("at_l").selectedIndex].value;for(var F in B.attr){var H=F;var G=B.attr[F];if(F=="vd"||F=="vdn"){H="s"}if(F=="ln"){H="l"}if(F=="rf"){G=B.domainId}var D=$("at_"+H);if(!D){continue}if(D.tagName.toUpperCase()=="SELECT"){var E;for(E=0;E<D.options.length;E++){if(D.options[E].value==G){D.selectedIndex=E}}}else{if(D.tagName.toUpperCase()=="INPUT"){D.value=G}}}}return true}var numOfChoices;function initChoices(){propOptions=new Array();propOptionIds=new Array();rm($("f_ch"));$("f_ch").innerHTML='Choices: <input type=button value=+  onclick="createOption();"><br/>';if(!choicesDomainId){return }read(function(E){var C=E.responseText.split("\n"),B;for(B=0;B<C.length;B++){var D=C[B].split("|");if(D.length<2){continue}propOptionIds.push(D[0]);propOptions.push(D[1])}for(numOfChoices=0;numOfChoices<propOptions.length;numOfChoices++){var A=createOption();A.value=propOptions[numOfChoices];A.oldValue=propOptions[numOfChoices];A.nodeId=propOptionIds[numOfChoices]}for(;numOfChoices<3;numOfChoices++){createOption()}},"/sims/options.jsp?a="+ap+"&d="+choicesDomainId)}function createOption(){var C=node("input");C.type="text";C.id="choice_insert_"+numOfChoices;C.onfocus=optionFocus;C.onblur=inputBlur;var B=node("a");B.innerHTML="x";B.href="javascript:void(0);";B.input=C;B.onclick=function(){if(!this.input.nodeId){this.input.style.display="none";this.br.style.display="none";this.style.display="none";return }else{if(confirm("Delete this item?")){read(null,"/sims/del.jsp?a="+encodeURIComponent(ap)+"&d="+choicesDomainId+"&n="+this.input.nodeId,true);initChoices()}}};B.br=node("br");var A=$("f_ch");if(A){A.appendChild(C);A.appendChild(B);A.appendChild(B.br)}return C}function inputBlur(){ctrl.outOfNUI=false;if(this.value!=this.oldValue){if(choicesDomainId){read(function(o){eval(o.responseText)},"/sims/options_save.jsp?a="+encodeURIComponent(ap)+"&d="+choicesDomainId+"&v="+encodeURIComponent(this.value)+"&i="+this.id+(this.nodeId?"&n="+this.nodeId:""),true);this.oldValue=this.value}}}var proptableHTML;function resetPropertyTable(){if(!proptableHTML){read(function(A){proptableHTML=A.responseText},"/sims/prop.jsp",true)}$("prop").innerHTML=proptableHTML;addDomainOptions($("at_s"));addDomainOptions($("at_l"),true);addDomainOptions($("at_rf"),true)}function addDomainOptions(D,C){var A,B=node("option");D.appendChild(B);if(!C){B=node("option");B.value=4;B.innerHTML="User Name";D.appendChild(B)}for(A=0;A<ptable.domainIdList.length;A++){B=node("option");B.value=ptable.domainIdList[A];B.innerHTML=ptable.domainNameList[A];D.appendChild(B)}}function showProp(){ptable.init();$("propDiv").style.display="";$("propDiv").style.right=-1*$("propDiv").offsetWidth+$("propTab").offsetWidth;$("propDiv").style.top=ctrl.ctrlHeight+ctrl.focusTop+20;$("prop").style.height=450}var propOn=false;function toggleProp(){var A=$("propDiv");if(propOn){A.style.right=-1*A.offsetWidth+$("propTab").offsetWidth;propOn=false}else{A.style.right=ctrl.isIE?-10:10;setPropertyTable(nui._curcell());propOn=true}}function textFocus(){ctrl.outOfNUI=true}function optionFocus(){if(choicesDomainId){ctrl.outOfNUI=true}else{floatWin(null,"You need to save the form before you can enter any options.");this.blur()}}function textBlur(B){ctrl.outOfNUI=false;if(mode==BUILDER){var A=currentBiff;if(A){builder.setAttribute(A.x,A.y,B.name,B.value)}}}function selChange(C){var A=currentBiff;var B=C.options[C.selectedIndex].value;builder.setAttribute(A.x,A.y,C.name,B);if(C.id=="at_it"){setPropertyTable(nui._curcell())}return true}var colorPickerBG=false;function clr(A){if(colorPickerBG){builder.setStyle(nui.fcol,nui.frow,"backgroundColor",A)}else{builder.setStyle(nui.fcol,nui.frow,"color",A)}}function setStylePane(A){resetStylePane();if(!A||!A.styling){return }if(A.styling.fontWeight=="bold"){buttover($("bBold"))}if(A.styling.fontStyle=="italic"){buttover($("bItalic"))}if(A.styling.textDecoration=="underline"){buttover($("bUnder"))}if(A.styling.textAlign=="left"){buttover($("bAlignL"))}if(A.styling.textAlign=="center"){buttover($("bAlignM"))}if(A.styling.textAlign=="right"){buttover($("bAlignR"))}if(A.styling.fontFamily){var B,C=$("bFamily");for(B=0;B<C.options.length;B++){if(C.options[B].value==A.styling.fontFamily){C.selectedIndex=B}}}if(A.styling.fontSize){var B,C=$("bFontSize");for(B=0;B<C.options.length;B++){if(C.options[B].value==A.styling.fontSize){C.selectedIndex=B}}}}function resetStylePane(){buttout($("bBold"));buttout($("bItalic"));buttout($("bUnder"));buttout($("bAlignL"));buttout($("bAlignM"));buttout($("bAlignR"));$("bFamily").selectedIndex=0;$("bFontSize").selectedIndex=0}var ptable={init:function(){this.domainIdList=new Array();this.domainNameList=new Array();read(function(text){eval(text.responseText)},"/sims/domains.jsp?a="+encodeURIComponent(ap),true)}};var macrolines,macrolineNum=0;var macroword,macrowordNum=0;var macroOn=false;function macroRunner(A){var B=A.responseText;macrolines=B.split("\n");macroLine()}function macroLine(){if(!macroOn){macroOn=true;read(macroRunner,"/sims/macro/customer_"+lang+".txt",true);return }$("tutorialNext").style.display="none";$("tutorialReplay").style.display="none";if(!macrolines||macrolineNum>=macrolines.length){macrolineNum=0;builder.saveServer();return }var A=macrolines[macrolineNum];var B=A.split(" ");if(B[0].toLowerCase()=="move"){nui._focus(parseInt(B[1]),parseInt(B[2]));window.setTimeout("macroLine();",500)}else{if(B[0].toLowerCase()=="type"){macroword=A.substring(5).replace(/\r/,"");macrowordNum=0;macroWord()}else{if(B[0].toLowerCase()=="location"){setCookie("macroLineNum",macrolineNum);location=A.substring(9)}else{if(B[0].toLowerCase()=="prompt"){$("tutorialDesc").innerHTML=A.substring(7);$("tutorialNext").style.display=""}else{if(B[0].toLowerCase()=="end"){$("tutorialDesc").innerHTML=A.substring(4);$("tutorialReplay").style.display=""}else{if(B[0].toLowerCase()=="mode"){modeBuilder();window.setTimeout("macroLine();",1000)}else{if(B[0].toLowerCase()=="sheet"){newSheet();window.setTimeout("macroLine();",1000)}else{if(B[0].toLowerCase()=="pause"){window.setTimeout("macroLine();",parseInt(B[1]))}else{window.setTimeout("macroLine();",1000)}}}}}}}}macrolineNum++}function macroWord(){if(macrowordNum>=macroword.length){window.setTimeout("macroLine();",200);return }var A=macroword.charAt(macrowordNum);var B=new Object();B.keyCode=A.charCodeAt(macrowordNum);nui.keyDown(B);$("hin").value+=A;nui.keyUp(B);macrowordNum++;window.setTimeout("macroWord();",60)}var BUILDER_FIELDS=1,BUILDER_TEXT=2,BUILDER_NOOP=0;var builder={cellData:new Object(),freeData:new Object(),rights:new Object(),unsave:false,mode:BUILDER_NOOP,defaultMode:BUILDER_FIELDS,setContent:function(B,G,F){this.unsave=true;if(this.mode==BUILDER_FIELDS){var E=this.cellData[B+","+G];if(!F&&E){if(E.tableFirst==2){var D=nui._getcell(B,G).ip;D.loadValue("--Deleted--");D.render();floatWin(null,"You're deleting a first column of a table, which is highly not recommended especially if you have already entered some data to this table. It will make the table unable to load correctly. If you really want to delete this field, you can do it again.");E.tableFirst=1;return }if(E.tableFirst==1){floatWin(null,"I warned you, the field will be deleted now. You can still leave design mode now without saving.")}E.unrender();this.cellData[B+","+G]=null}else{if(E){setObjectHeaderValue(E,F);E.render()}else{var A=new BuilderObject(B,G,F,TYPER);this.cellData[B+","+G]=A;this.freeData[B+","+G]=null;A.render()}}}else{if(this.mode==BUILDER_TEXT){var C=this.freeData[B+","+G];if(!F&&C){C.unrender();nui._getcell(B,G).style.backgroundColor="";this.freeData[B+","+G]=null}else{if(C){C.value=F;C.render()}else{var A=new FreeObject(B,G,F);this.cellData[B+","+G]=null;this.freeData[B+","+G]=A;A.render()}}}}},setAction:function(A,E){this.unsave=true;var B=this.freeData[A+","+E];if(B){var C=B.action?B.action:"";var D=prompt("Please enter the URL that you would like this to link to:",C);B.action=D}},setStyle:function(B,G,F,D){this.unsave=true;ctrl.dropWin=true;var E=nui._curcell().ip;var C=$("hin");if(E.typing){builder.setContent(B,G,C.value);E.typing=false;E.changed=true;E.render()}var A=this.freeData[B+","+G];if(!A){return }if(A.styling[F]==D){A.styling[F]=null}else{A.styling[F]=D}A.render();nui._updateFocus()},setAttribute:function(B,E,D,C){this.unsave=true;var A=this.cellData[B+","+E];if(D=="it"){A.IPType=C}else{if(D=="rf"){if(C&&C.length>0){A.attr.rf=A.domainId;A.domainId=C}else{A.domainId=A.attr.rf;A.attr.rf=null}}else{if(D=="s"){A.attr.s=C;A.attr.vd=C;A.attr.vdn=C}else{if(D=="l"){A.attr.l=C;A.attr.ln=C}else{A.attr[D]=C}}}}A.adjustAttributes();A.render()},setRights:function(A,B){if(B==0){B="0"}this.unsave=true;this.rights[A]=B},load:function(H){this.unsave=false;var N=builder;N.cellData=new Object();N.rights=new Object();N.rights.EVERYONE="0";N.rights.USER=3;N.rights.MANAGER=6;N.freeData=new Object();biffdata=new BiffData();biffdata.widthCommand=null;biffdata.heightCommand=null;loadRightsSetting();var L=H.responseText;var O=L.split("\n"),C;for(C=0;C<O.length;C++){var D=O[C].split(",");if(D[0]=="W"){if(D.length>1){biffdata.widthCommand=D[1]}if(D.length>2){biffdata.heightCommand=D[2]}}else{if(D[0]=="A"){var A=D[1].split("&"),B;for(B=0;B<A.length;B++){var F=A[B].split("=");saveRightsSetting(F[0],F[1])}}else{if(D[0]=="F"){var G=O[C].split(",",6);var K=D[1],J=D[2];var I=new FreeObject(K,J,D[4]);var A=D[5].split("&"),B;I.action=D[3];for(B=0;B<A.length;B++){var M=A[B].split("=");I.styling[M[0]]=M[1]}N.freeData[K+","+J]=I}else{if(D[0]=="D"||D[0]=="L"||D[0]=="U"||D[0]=="G"||D[0]=="M"){var I=new BuilderObject(D[1],D[2],D[4],D[0]);I.domainId=D[3];var A=D[5].split("&"),B;for(B=0;B<A.length;B++){var M=A[B].split("=");var E;I.attr[M[0]]=M[1]}N.cellData[D[1]+","+D[2]]=I}}}}}N.renderAll();if(loadingBox){loadingBox.style.display="none"}},renderAll:function(){var E=builder.cellData,C=builder.freeData;for(var D in E){if(!E||!E[D]){continue}E[D].render();var B=D.split(",");var A=B[0],F=B[1];if(E[(parseInt(A)+1)+","+parseInt(F)]&&!E[(parseInt(A)-1)+","+parseInt(F)]){E[D].tableFirst=2}}for(var D in C){if(!C||!C[D]){continue}C[D].render()}processWidth(biffdata.widthCommand,biffdata.heightCommand)},saveServer:function(B){this.unsave=false;if(loadingBox){loadingBox.style.display=""}var G=this.cellData,A=builder.freeData;var F="A,",E=true;for(var D in this.rights){if(!E){F+="&"}F+=D+"="+this.rights[D];if(E){E=false}}if(E){F+="EVERYONE=3"}F+="\n";F+="W,"+(biffdata.widthCommand?biffdata.widthCommand:"")+","+(biffdata.heightCommand?biffdata.heightCommand:"")+"\n";var C=0;for(var D in G){if(!G[D]){continue}F+=G[D].outputLine();C++}for(var D in A){if(!A[D]){continue}F+=A[D].outputLine()}var H=getHTTPObject();H.open("POST","/sims/save_builder.jsp?a="+ap+"&p="+encodeURIComponent(path)+"&fn="+encodeURIComponent(sheet)+(B?"&mo=true":""),true);H.setRequestHeader("Content-type","application/x-www-form-urlencoded");H.setRequestHeader("Content-length",F.length);H.setRequestHeader("Connection","close");H.onreadystatechange=function(){if(H.readyState==4){modeBuilder()}};H.send("c="+encodeURIComponent(F))},ifAdjacent:function(A,B){return this.cellData[(A+1)+","+B]||this.cellData[(A-1)+","+B]},moveHeader:function(H,F,I,G){if(!H||!F||!I||!G){return }var C=H+","+F;var B=I+","+G;var J=this.cellData[C];if(!J){return }if(this.ifAdjacent(H,F)&&F==G&&H!=I){this.cellData[C]=null;var E=H-I>0;var D=H;while(D!=I){var K=E?D-1:D+1;var A=this.cellData[K+","+F];this.cellData[D+","+F]=A;A.x=D;D=K;if(K==I){this.cellData[K+","+F]=J;J.x=I;break}}}else{if(!this.cellData[B]){this.cellData[B]=J;this.cellData[C]=null;J.x=I;J.y=G}}nui.init();this.renderAll()}};function checkSave(){if(path=="/designer"){$("bPackage").onclick();return false}return true}function setObjectHeaderValue(G,F){if(!G||!F){return }else{if(!G.value||(G.value.indexOf("|")==-1&&G.value.indexOf("=")==-1)){G.value=F;return }}var B=G.value.split("|");if(B.length==1){G.value=F}else{var E=lang;var A=0;var D=false;for(;A<B.length;A++){var C=B[A].split("=");if(E==C[0]){C[1]=F;D=true}B[A]=C.join("=")}if(!D){B[0]=F}G.value=B.join("|")}}function FreeObject(A,C,B){this.x=parseInt(A);this.y=parseInt(C);this.styling=new Object();this.value=B}FreeObject.prototype.render=function(){var B=this;var A=nui._getcell(B.x,B.y);A.noWrap=true;A.innerHTML=cellTextProcess(B.value);A.ip=new Typer();A.ip.loadValue(parseHeaderValue(B.value));A.ip.cell=A;A.ip.biff=B;A.biff=B;for(var C in A.style){if(!C||!A.style[C]){continue}try{A.style[C]=null}catch(D){}}for(var C in B.styling){if(!C||!B.styling[C]){continue}A.style[C]=B.styling[C]}};FreeObject.prototype.unrender=function(){};FreeObject.prototype.outputLine=function(){var C=this,B="",D=true;for(var A in C.styling){if(!A){continue}if(!C.styling[A]){continue}if(!D){B+="&"}B+=A+"="+C.styling[A];if(D){D=false}}return"F,"+C.x+","+C.y+","+(C.action?C.action:"")+","+C.value.replace(/,/g,"&#44;")+","+B+"\n"};function BuilderObject(A,D,C,B){this.x=parseInt(A);this.y=parseInt(D);this.value=C;this.IPType=B;this.attr=new Object()}BuilderObject.prototype.outputLine=function(){var C=this,D=C.domainId,B="",E=true;for(var A in C.attr){if(!A){continue}if(!C.attr[A]){continue}if(!E){B+="&"}B+=A+"="+C.attr[A].replace(/,/gim,"`");if(E){E=false}}return C.IPType+","+C.x+","+C.y+","+(D?D:"")+","+this.value+","+B+"\n"};BuilderObject.prototype.unrender=function(){var A=this,D=nui._getcell(A.x,A.y),C;removeBorderClass(D,"builderEmpty");D.builderField=false;D.innerHTML="";for(C=0;C<A.coloring.length;C++){var B=A.coloring[C];removeBorderClass(B,"builderEmpty");B.builderField=false;B.innerHTML=""}};BuilderObject.prototype.adjustAttributes=function(){var A=this;var D=A.IPType==SELECTOR,C=false;for(var B in A.attr){if(!A.attr[B]){continue}if(B=="l"||B=="ln"){C=true;break}}for(var B in A.attr){if(!A.attr[B]){continue}if(B=="l"||B=="ln"){if(D){A.attr.ln=A.attr[B];A.attr.l=null}else{A.attr.l=A.attr[B];A.attr.ln=null}}else{if(B=="s"||B=="vd"||B=="vdn"){if(C){if(D){A.attr.vdn=A.attr[B];A.attr.vd=null;A.attr.s=null}else{A.attr.vd=A.attr[B];A.attr.vdn=null;A.attr.s=null}}else{A.attr.s=A.attr[B];A.attr.vd=null;A.attr.vdn=null}}}}};BuilderObject.prototype.render=function(){var C=this,F=nui;C.coloring=new Array();var D=builder.ifAdjacent(C.x,C.y);var B=F._getcell(C.x,C.y),A;if(!B){return }rm(B);setBorderClass(B,"url(/sims/img/header.png)");B.builderField=true;B.ip=new Typer();B.ip.loadValue(parseHeaderValue(C.value));B.ip.cell=B;B.biff=C;B.ip.render();B.ip.inputBox=node("input");if(D){for(E=1;E<=ctrl.TABLE_DEF_ROWS;E++){A=F._getcell(C.x,C.y+E);if(!A){continue}rm(A);A.className="builderFocusRight";setBuilderCellContent(A,C.IPType);this.coloring.push(A)}}else{A=F._getcell(C.x+1,C.y);if(A){rm(A);A.className="builderFocusRight";setBuilderCellContent(A,C.IPType);this.coloring.push(A);var E,G=C.attr&&C.attr.cs?parseInt(parseInt(C.attr.cs)):1;A.colSpan=G;setBorderClass(A,"",G);for(E=1;E<G;E++){F._removecell(C.x+E+1,C.y)}}}};function setBuilderCellContent(A,B){if(B==SELECTOR||B==MSELECTOR){setBuilderSelectBox(A)}else{if(B=="U"){A.innerHTML="<font color=#CCCCCC>Upload File</font>"}else{if(B=="G"){A.innerHTML="<font color=#CCCCCC>Upload Graphic</font>"}else{A.innerHTML="<font color=#CCCCCC>Free Text</font>"}}}}function saveBuilder(){if(checkSave()){nui._blur();builder.saveServer()}}function updateBuilderMove(A){if(!ctrl.builderMovePrompt){ctrl.builderMovePrompt=node("div");ctrl.builderMovePrompt.style.position="absolute";ctrl.builderMovePrompt.innerHTML=ctrl.builderMoveStart.innerHTML;ctrl.builderMovePrompt.style.backgroundColor=ctrl.builderMoveStart.style.backgroundColor;ctrl.builderMovePrompt.style.fontSize="12px";ctrl.builderMovePrompt.style.width=ctrl.builderMoveStart.offsetWidth;ctrl.builderMovePrompt.style.height=ctrl.builderMoveStart.offsetHeight;document.body.appendChild(ctrl.builderMovePrompt)}ctrl.builderMovePrompt.style.top=0;ctrl.builderMovePrompt.style.left=0;ctrl.builderMovePrompt.style.top=A.clientY;ctrl.builderMovePrompt.style.left=A.clientX}function endBuilderMove(C){if(ctrl.builderMovePrompt){document.body.removeChild(ctrl.builderMovePrompt);ctrl.builderMovePrompt=null}var G,E,F,D;if(ctrl.builderMoveStart){var B=ctrl.builderMoveStart.id;G=parseInt(B.split("_")[1]);E=parseInt(B.split("_")[2]);ctrl.builderMoveStart=null}if(ctrl.builderMoveEnd){var A=ctrl.builderMoveEnd.id;F=parseInt(A.split("_")[1]);D=parseInt(A.split("_")[2]);ctrl.builderMoveEnd=null}if(!G||!E||!F||!D){return }if(G==F&&E==D){return }builder.moveHeader(G,E,F,D)}function Uploader(B){var A=this;A.type=UPLOADER;A.IPType=B}Uploader.prototype.keyDown=function(A){return true};Uploader.prototype.keyUp=function(A){return true};Uploader.prototype.onpaste=function(){};Uploader.prototype.click=function(){this.uploadDiv.style.display=""};Uploader.prototype.dblclick=function(){};Uploader.prototype.focus=function(){};Uploader.prototype.blur=function(){};Uploader.prototype.loadValue=function(B,A){this.biff.value=B;this.render()};Uploader.prototype.render=function(){if(mode==BROWSE){if(this.IPType=="G"){this.cell.style.verticalAlign="top";if(this.biff.value){this.cell.innerHTML='<a target=_blank href="/sims/file.jsp?a='+ap+"&f="+encodeURIComponent(this.biff.value)+'"><img src="/sims/file.jsp?a='+ap+"&f="+this.biff.value+'" /></a>'}}else{this.cell.innerHTML='<a target=_blank href="/sims/file.jsp?a='+ap+"&f="+encodeURIComponent(this.biff.value)+'">'+this.biff.value+"</a>"}}else{if(mode==UPDATE){this.cell.ip=this;if(this.biff.value){this.cell.innerHTML="<a href='javascript:void(0);' onclick='this.parentNode.ip.click()'>"+this.biff.value+"</a>"}else{this.cell.innerHTML="<a href='javascript:void(0);' onclick='this.parentNode.ip.click()'>Upload</a>"}}}};Uploader.prototype.clear=function(){};Uploader.prototype.createUploadInputElement=function(){var A=this;A.uploadDiv=node("div");A.uploadDiv.id="floatingUpload";A.uploadDiv.className="floatingWin";A.uploadDiv.style.display="none";A.uploadDiv.ip=this;$("nuiform").appendChild(A.uploadDiv);A.uploadDiv.innerHTML='<div class="close" onclick="this.parentNode.style.display=\'none\';this.parentNode.ip.loadValue(this.parentNode.childNodes[1].value);"><img src="/sims/img/close.png" alt="close" /></div><input type=file style=\'margin:30 0 0 0;\' /><input type=button onclick="this.parentNode.style.display=\'none\';this.parentNode.ip.loadValue(this.parentNode.childNodes[1].value);" value=OK />';A.inputBox=A.uploadDiv.childNodes[1];return A.inputBox};function MSelector(){var A=this;A.type=MSELECTOR}MSelector.prototype.keyDown=function(A){return true};MSelector.prototype.keyUp=function(A){return true};MSelector.prototype.onpaste=function(){};MSelector.prototype.click=function(){this.render()};MSelector.prototype.dblclick=function(){};MSelector.prototype.focus=function(){nui.focus.onclick=mselectorClick};MSelector.prototype.blur=function(){};MSelector.prototype.loadValue=function(B,A){this.value=B;this.valueList=B.split("|")};MSelector.prototype.render=function(){rm(this.cell);var B=node("span");B.innerHTML=this.valueList.join(",");B.style.cssFloat="left";this.cell.style.width="100%";this.cell.appendChild(B);var A=node("span");A.className="selbut";A.innerHTML="&nbsp;";A.cell=this.cell;A.onmouseover=function(){this.className="selbutOn"};A.onmouseout=function(){this.className="selbut"};A.onclick=mselectorClick;this.cell.appendChild(A)};MSelector.prototype.clear=function(){};function mselectorClick(){if(mode!=UPDATE){floatWin(null,"You can only make modifications in editing mode.");ctrl.dropWin=true;return }var B=this.cell.ip,A=this.cell;if(!B.listdiv){B.selectList=selpro.getSelectList(B.domainId);B.listdiv=B.selectList.listMulti(B.domainId,B.parentDomainId,B.parentNodeId,B.nodeId);B.listdiv.ip=B;B.listdiv.style.top=A.offsetTop+A.clientHeight+ctrl.ctrlHeight;B.listdiv.style.left=A.offsetLeft;$("nuiform").appendChild(B.listdiv);floatingPanels.push(B.listdiv);ctrl.dropWin=true}else{if(B.listdiv.style.display=="none"){B.listdiv.style.top=A.offsetTop+A.clientHeight+ctrl.ctrlHeight;B.listdiv.style.left=A.offsetLeft;B.listdiv.style.display="";floatingPanels.push(B.listdiv);ctrl.dropWin=true}else{B.listdiv.style.display="none"}}}var formulaBuilder={listenMapping:new Object(),update:function(C,E){var G=this.listenMapping[C],B,A;if(!G){return }for(B=0;B<G.length;B++){var F=G[B];var D=F.listeningIPs[E.y];var H=false;if(!D){D=F.listeningIPs[0];H=true}if(!D){continue}var I=resolveFormula(F.formula,H?0:E.y);if(!isNaN(I)&&I!=null){D.loadValue(I)}else{D.loadValue("")}D.render()}},delimiters:["+","-","*","/","(",")"],_findChangeCellNames:function(E){var G=new Array();var C,J=this;var H=indexOf;var D="";for(C=0;C<E.length;C++){var A=E.charAt(C);if(H(A,J.delimiters)!=-1){G.push(D);D=""}else{D+=A}}if(D.length>0){G.push(D)}var L=new Array();for(C=0;C<G.length;C++){var B=G[C];var K=B.charCodeAt(0);var I=B.charCodeAt(1);if(K>=65&&K<=90&&(I<65||I>90)){var F=B.split(".",2);if(F.length>1){L.push(F[0])}else{L.push(B)}}}return L},add:function(D,E,F){var C,B=this;var A=B._findChangeCellNames(F);for(C=0;C<A.length;C++){B._add(A[C],D,E,F)}},_add:function(C,A,E,F){var H=this.listenMapping[C],B;if(!H){H=new Array();this.listenMapping[C]=H}var G=null;for(B=0;B<H.length;B++){var D=H[B];if(D.affectedCellName==A){G=D}}if(!G){G=new FormulaListener(A,F);H.push(G)}var I=!biffdata.ifAdjacent(E.biff.x,E.biff.y,function(K,J){return K||J});G.listeningIPs[(I?0:E.biff.y)]=E}};function showFormulaMapValues(){var D=biffdata.formulaMap;var A="";for(var E in D){var C=D[E];A+=E+":";for(var B in C){A+=" "+C[B]+"("+B+") "}A+="\n"}alert(A)}function FormulaListener(A,B){this.affectedCellName=A;this.formula=B;this.listeningIPs=new Object()}function resolveFormula(formula,y){var formulaMap=biffdata.formulaMap;var replaceTargets=formulaBuilder._findChangeCellNames(formula);for(var key in formulaMap){if(!key||indexOf(key,replaceTargets)==-1){continue}if(y){var total=0;for(var k in formulaMap[key]){var value=formulaMap[key][k];if(!value||isNaN(value)||parseInt(k)>y){continue}total+=parseFloat(value)}var temp=formula.replace(new RegExp(key+"\\.ACC","g"),total);formula=temp;formula=formula.replace(new RegExp(key,"gi"),formulaMap[key][y])}else{var total=0,count=0;for(var k in formulaMap[key]){count++;var value=formulaMap[key][k];if(!value||isNaN(value)){continue}total+=parseFloat(value)}formula=formula.replace(new RegExp(key+"\\.COUNT","gi"),count);formula=formula.replace(new RegExp(key,"gi"),total)}}if(print){}var result="";try{formula=formula.replace(new RegExp("--","gi"),"+");result=eval(formula);if(result==0){result="0"}}catch(e){}if(!result||result.length==0||isNaN(result)){return null}else{result=Math.round(result*100)/100;return result}}var ani_obj,ani_rx,ani_xy,ani_speed=10;function animate(D,E,C,B){ani_obj=D;ani_xy=B;if(!ani_obj.rx){var A=B?ani_obj.style.top:ani_obj.style.right;ani_obj.rx=parseInt(A.substring(0,A.length-2))}if(Math.abs(ani_obj.rx-E)<10){ani_rx=C}else{ani_rx=E}_animate()}function _animate(){if(!ani_obj||Math.abs(ani_obj.rx-ani_rx)==0){return }var A=ani_speed;if(A>Math.abs(ani_obj.rx-ani_rx)){if(A/4>Math.abs(ani_obj.rx-ani_rx)){A=Math.abs(ani_obj.rx-ani_rx)}else{if(A/2>Math.abs(ani_obj.rx-ani_rx)){A=A/4}else{A=A/2}}}if(A>Math.abs(ani_obj.rx-ani_rx)){A=Math.abs(ani_obj.rx-ani_rx)}if(ani_obj.rx>ani_rx){ani_obj.rx-=A}else{if(ani_obj.rx<ani_rx){ani_obj.rx+=A}}if(ani_xy){ani_obj.style.top=ani_obj.rx+"px"}else{ani_obj.style.right=ani_obj.rx+"px"}window.setTimeout(_animate,10)}var scrollAmount,scrollTimer,scrollCallback;function animateScroll(A,B){nui.main_outer.scrollTop=0;if(A){scrollAmount=A}scrollCallback=B;_animateScroll()}function _animateScroll(){var A=ctrl.isIE?360:200;if(A>Math.abs(scrollAmount)){A=Math.abs(scrollAmount)}if(scrollAmount>0){$("nui_outer").scrollLeft+=A;scrollAmount-=A}else{if(scrollAmount<0){$("nui_outer").scrollLeft-=A;scrollAmount+=A}}if(scrollAmount==0){window.clearInterval(scrollTimer);nuiController._load();if(biffdata.formType=="2"){$("filterIcons").style.display="";$("bNewData").style.display="";$("bDeleteEntry").style.display="none";$("bEdit").style.display="none";$("bBack").style.display="none"}else{$("filterIcons").style.display="none";$("bNewData").style.display="none";if(owner){$("bDeleteEntry").style.display=""}$("bEdit").style.display="";$("bBack").style.display=""}if(scrollCallback){scrollCallback()}}else{window.setTimeout(_animateScroll,20)}}var nui=null,biffdata=null;var nuiController={NONE:0,LEFT:1,RIGHT:2,DOWN:3,UP:5,nuichain:new Array(),biffchain:new Array(),nui:$("nui"),load:function(C,A,E,F){var B=this;B.headerQS=C;B.dataQS=A;B.callBack=E;var D=B.nui.childNodes;B.ifNullResponse=false;switch(F){case B.LEFT:if(D.length>1){B.nuichain.pop();B.biffchain.pop();nui=B.nuichain[B.nuichain.length-1];biffdata=B.biffchain[B.biffchain.length-1];B.ifNullResponse=true}else{nui=new NUI();nui.init();biffdata=new BiffData();B.nuichain=[nui];B.biffchain=[biffdata];B.nui.insertBefore(nui.main,D[0]);$("nui_outer").scrollLeft=document.body.clientWidth}animateScroll(document.body.clientWidth*-1,function(){var G=nuiController;G.nui.removeChild(G.nui.childNodes[G.nui.childNodes.length-1]);adjustPrevNext();browse._trav(false)});break;case B.RIGHT:nui=new NUI();nui.init();biffdata=new BiffData();B.nuichain.push(nui);B.biffchain.push(biffdata);B.nui.appendChild(nui.main);animateScroll(document.body.clientWidth);break;default:if(!nui){nui=new NUI();nui.init();biffdata=new BiffData();B.nuichain.push(nui);B.biffchain.push(biffdata);B.nui.appendChild(nui.main)}else{biffdata.reset()}B._load();break}},_load:function(){if(ctrl.semaphore){return }ctrl.semaphore=true;formulaBuilder.listenMapping=new Object();var A=this;if(A.ifNullResponse){read(function(){ctrl.semaphore=false},"/sims/form_headers.jsp?a="+encodeURIComponent(ap)+"&p="+encodeURIComponent(path)+"&fn="+encodeURIComponent(sheet)+A.headerQS);return }if(!initDataLoaded){biffdata.loadHeader($("formHeaders").innerHTML.replace(/\r/g,"").replace(/&amp;/g,"&"));biffdata.loadData($("formData").innerHTML.replace(/\r/g,"").replace(/&amp;/g,"&"));if(nuiController.callBack){nuiController.callBack()}ctrl.semaphore=false;initDataLoaded=true}else{read(biffdata.loadHeader,"/sims/form_headers.jsp?a="+encodeURIComponent(ap)+"&p="+encodeURIComponent(path)+"&fn="+encodeURIComponent(sheet)+A.headerQS,true);read(function(B){biffdata.loadData(B);if(nuiController.callBack){nuiController.callBack()}ctrl.semaphore=false},"/sims/form_update.jsp?a="+encodeURIComponent(ap)+"&p="+encodeURIComponent(path)+"&fn="+encodeURIComponent(sheet)+A.dataQS)}},resetBrowseLeft:function(){var B=this,C=B.nui,A;try{var E=true;for(A=C.childNodes.length-1;A>=0;A--){if(C.childNodes[A].nodeType!=1){continue}if(E){E=false;continue}else{B.nui.removeChild(C.childNodes[A])}}for(A=0;A<B.nuichain.length-1;A++){B.nuichain.splice(A,1)}for(A=0;A<B.biffchain.length-1;A++){B.biffchain.splice(A,1)}}catch(D){alert(D)}$("nui_outer").scrollLeft=0},resize:function(){var B=this,A=0;for(A=0;A<B.nuichain.length;A++){B.nuichain[A].main.style.width=document.body.clientWidth}if(B.nuichain&&B.nuichain.length>0){$("nui_outer").scrollLeft=(B.nuichain.length-1)*B.nuichain[0].main.offsetWidth}}};var chart=new Chart();function Chart(){}Chart.prototype.trigger=function(A){if(this.on){this.on=false}else{if(!this.ready){$("chartMain").style.display="";$("charts").style.right=$("chartMain").clientWidth*-1;this.prepareOptions();this.loadChart();this.ready=true}this.on=true}ani_speed=120;animate(A.parentNode,-1*A.nextSibling.offsetWidth,0)};Chart.prototype.prepareOptions=function(){this.linkDomains=$("linkDomains"),i,_biffs=biffdata.biffs;for(i=0;i<_biffs.length;i++){var A=_biffs[i];if(i==0){this.rootDomainId=A.domainId}if(A.dataType==1&&A.IPType=="L"){var B=node("option");B.innerHTML=A.value;B.value=A.domainId;linkDomains.appendChild(B)}}};Chart.prototype.loadChart=function(){var A=this,B=$("theChart");if(!A.linkDomains||A.linkDomains.options.length==0){B.innerHTML='<p style="padding:10px;">No chart available.</p>';return }B.innerHTML='<img src="/sims/'+ap+".chart?a="+ap+"&p="+path+"&rd="+this.rootDomainId+"&cd="+this.linkDomains.options[this.linkDomains.selectedIndex].value+"&t="+new Date().getTime()+'"/>'};
var lm=new Object();
lm['away']="Are you sure you want to navigate away from this page?";
lm['AutoGen']="Auto Generate";
lm['tutorial1']=" ? ";
lm['tutorial2']=" ? ";
lm['tutorial3']=" ? ";
lm['tutorial4']=" ? ";
lm['checkRegistered']=" ? ";
lm['myPrivMsg0']="You don't have any access to this form.";
lm['myPrivMsg1']="You can create and view your own entries.";
lm['myPrivMsg2']="You can view all entries.";
lm['myPrivMsg3']="You can create entries, and view all entries.";
lm['myPrivMsg6']="You can create, modify, delete all entries.";
lm['browseMode']="<b>Browsing Mode</b> - Click on the Edit Data button to modify data on the form below.";
lm['editMode']="<b>Editing Mode</b> - Edit the data like any spreadsheet, click Save when you're done, click Back Browse if you would like to discard changes.";
lm['builderMode']="<b>Design Mode</b> - You can change the design of the form for users to enter different data.";
lm['motd']="Oh! I see you're using the Internet Explorer(IE). We recommend that you use the fast and secure <a href='http://www.mozilla.com/en-US/firefox/firefox.html' target=_blank>Firefox browser</a>. <b>Ragic runs 3 to 5 times quicker in Firefox than IE</b>!<br/><br/><a href='http://www.mozilla.com/en-US/firefox/firefox.html' target=_blank>Click here to install Firefox</a>";
lm['tt_noShow']="Don't show the tooltips in the future?";
lm['tt_bNewData']="Click here to create a new entry!";
lm['tt_bEdit']="Click here to modify the entry!";
lm['tt_bNextPage']="Click here to see the next page of entries!";
lm['tt_bDesign']="Click here to enter design mode!";
lm['tt_bBack']="Click here to see listing of entries";
lm['tt_bBrowse']="Click here to exit without saving";
lm['tt_filter']="Click to query for the entries you want";

var theme='webby';
var setBorderClass=__setBorderClasswebby;