// CodeThatGrid PRO
// Version: 2.2.8 (02.22.06.1)
// IT IS ILLEGAL TO USE UNREGISTERED VERSION OF THE SCRIPT. WE PERFORM
// MONITORING OF THE SITES THAT USE SCRIPT USING GOOGLE AND SPECIAL WORDS
// INCLUDED INTO THE SCRIPT. WE WILL INITIATE LEGAL ACTIONS AGAINST THE
// PARTIES THAT VIOLATE LICENSE AGREEMENT. PLEASE REGISTER THE SCRIPT.
// Copyright (c) 2003-2006 by CodeThat.Com
// http://www.codethat.com/

function CCodeThatGrid(name,r,c){var t=this,i,s;r=parseInt(r);c=parseInt(c);t.def={datatype:0,data:[]};t.name=name;CodeThatGrids[name]=t;t.rows=[];t.cols=[];t.cells=[];t.rowCount=(isNaN(r)||r<=0)?20:r;t.colCount=(isNaN(c)||c<=0)?5:c;t.rIdx=[];t.vr=[];t.cIdx=[];t.sortCol=-1;t.sortType=1;t.multiSortCol=[];t.multiSortType=[];t.useMultiSort=1;t.searchValue="";t.clip="";t.msg="";t.useProgress=1;t.winProgress=null;t.useRCID=1;t.useExportBar=0;t.useColTitle=1;t.curCell=null;t.amountPerPage=20;t.pageCount=1;t.page=1;t.isInit=0;t.markType=0;t.markRange=[];t.userFunction=null;t.tableStyle={tableClass:{borderwidth:1,borderstyle:"solid",bordercolor:"#D4D0C8"},thClass:dfp,tdClass:dfp,bgcolor:"#ffffff",x:10,y:10,width:480,height:480,position:0,overflow:"auto"};t.rowStyle={defaultClass:merge([dfp,crp,{backgroundcolor:"#D4D0C8"}]),markClass:merge([dfp,crp,{backgroundcolor:"#ccccff"}]),resizeClass:{cursor:"row-resize",borderwidth:"0"},dragClass:{cursor:"move",borderwidth:"0"},width:40,height:22};t.colStyle={defaultClass:merge([dfp,crp,{backgroundcolor:"#D4D0C8"}]),markClass:merge([dfp,crp,{backgroundcolor:"#ccccff"}]),resizeClass:{cursor:"col-resize",borderwidth:"0"},dragClass:{cursor:"move",borderwidth:"0"},width:80,height:22};t.cellStyle={defaultClass:merge([dfp,clp,{backgroundcolor:"#ffffff",bordercolor:"#cccccc",borderwidth:1}]),markClass:merge([dfp,clp,{backgroundcolor:"#ccccff",bordercolor:"#cccccc",borderwidth:1}]),currClass:merge([dfp,clp,{backgroundcolor:"#effffe",bordercolor:"#000000",borderwidth:2}])};t.toolBar={height:29,bgcolor:"#D4D0C8",defaultClass:merge([dfp,dbp]),buttons:[],searchControl:null};t.statusBar={height:18,bgcolor:"#D4D0C8",defaultClass:dbp,messageClass:dbp,fieldText:"Field",valueText:"Value"};t.pageTurnBar={defaultClass:{backgroundcolor:"#ffffff",fontsize:"12px",fontfamily:"Verdana,Arial"},activeClass:{backgroundcolor:"#D4D0C8",fontsize:"12px",fontfamily:"Verdana,Arial"},img_on:{src:"img/t_on.gif"},img_off:{src:"img/t_off.gif"},text:"Page",width:65,height:14};var btn=["addrowto","addrowafter","delrow","addcolto","addcolafter","delcol","sortasc","sortdesc","multisortasc","multisortdesc","resetsort","copy","paste","formatbold","formatitalic","formatunderline","alignleft","aligncenter","alignright","setsearch","resetsearch","setamount"],btntx=["Add row before current one","Add row after current one","Delete row","Add column before current one","Add column after current one","Delete column","Sort in ascending order","Sort in descending order","Multi Sort in ascending order","Multi Sort in descending order","Reset sort","Copy","Paste","Format bold","Format italic","Format underline","Align left","Align center","Align right","Search","Reset search","Set amount"],b=t.toolBar.buttons;for(i=0;i<btn.length;i++){b[i]={};b[i].name=btn[i];b[i].text=btntx[i];b[i].img_on={src:"img/"+btn[i]+".gif",width:16,height:16};b[i].img_off={src:"img/"+btn[i]+"_off.gif",width:16,height:16};};ua.oldB=ua.oldOpera||ua.nn4;};{var CGp=CCodeThatGrid.prototype;CGp.setFocus=function(rOffset,cOffset){var t=this,cl=t.curCell,c,r,s,f,o,i;if(Undef(cl))
return;r=(!t.vr.length)?t.rIdx.indexOf(cl.row._id):t.vr.indexOf(cl.row._id);c=t.cIdx.indexOf(cl.col._id);s=(t.page-1)*t.amountPerPage;f=(t.page*t.amountPerPage>t.rows.length)?t.rows.length:t.page*t.amountPerPage;if(rOffset+r<s){r=f+(rOffset+r);}else{if(rOffset+r<f)r=rOffset+r;else r=f-(rOffset+r);};if(cOffset+c<0){c=t.cols.length+(cOffset+c);}else{if(cOffset+c<t.cols.length)c=cOffset+c;else c=t.cols.length-cOffset-c;};if(cOffset>=0){while(c<t.colCount&&!t.cols[c].isVisible)c++;if(c==t.colCount)c=0;while(c<t.colCount&&!t.cols[c].isVisible)c++;if(c==t.colCount){alert("All columns are hidden!");
return;}}else{while(c>-1&&!t.cols[c].isVisible)c--;if(c==-1)c=t.colCount-1;while(c>-1&&!t.cols[c].isVisible)c--;if(c==-1){alert("All columns are hidden!");
return;}};r=(!t.vr.length)?t.rIdx[r]:t.vr[r];c=t.cIdx[c];if(r>-1&&c>-1)t.setCurCell(t.cells[r][c]);};CGp.onKeyPress=function(e){var t=this,cl=t.curCell,o,r,c;if(Undef(cl))
return;switch(e._e.keyCode){case 57387:case 37:if(cl.state!=2)t.setFocus(0,-1);break;case 57385:case 38:if(cl.state!=2)t.setFocus(-1,0);break;case 57388:case 39:if(cl.state!=2)t.setFocus(0,1);break;case 57386:case 40:if(cl.state!=2)t.setFocus(1,0);break;case 9:if(isShift)if(t.cIdx.indexOf(t.cols[cl.col._id])==0)t.setFocus(-1,-1);else t.setFocus(0,-1);else if(t.cIdx.indexOf(t.cols[cl.col._id])==t.cIdx.length-1)t.setFocus(1,1);else t.setFocus(0,1);if(ua.ie){o=CT_fe(t.curCell.getID());o.focus();};break;case 13:if(cl.state!=2){cl.setState(2);
return false;}else{o=CT_fe("cell");if(Def(o)&&o.type.toLowerCase()!='textarea')t.setFocus(0,1);};break;case 57346:case 113:if(cl.state!=2)cl.setState(2);break;case 27:if(cl.state==2){o=CT_fe("cell");if(Def(o))o.value=cl.getDataForEdit();}cl.setState(1);break;case 57383:case 33:if(cl.state!=2){r=t.rIdx[(t.page-1)*t.amountPerPage];t.setCurCell(t.cells[r][cl.col._id]);};break;case 57384:case 34:if(cl.state!=2){if(t.page*t.amountPerPage-1>=t.rIdx.length)r=t.rIdx[t.rIdx.length-1];else r=t.rIdx[t.page*t.amountPerPage-1];t.setCurCell(t.cells[r][cl.col._id]);};break;case 57382:case 35:if(cl.state!=2){c=t.cIdx[t.cIdx.length-1];t.setCurCell(t.cells[cl.row._id][c]);};break;case 57381:case 36:if(cl.state!=2){c=t.cIdx[0];t.setCurCell(t.cells[cl.row._id][c]);};break;case 67:if(cl.state==2)break;t.copy();break;case 86:if(cl.state==2)break;t.paste();break;};};CGp.makeStyle=function(obj,param,cssName){var css;if(Def(css=makeCssClass(obj[param]))){cssName=makeNameUnique(cssName);obj[param]=cssName;css="\n."+cssName+"{"+css+"}";};
return css;};CGp.setMarkRange=function(markRange,markType){var t=this,m=t.markRange,idx,i,j,p=(!ua.opera);if(Def(t.curCell)&&markType<3)t.setCurCell(null);t.clearMarkRange(markType);switch(markType){case 1:case 2:t.markType=markType;idx=m.indexOf(markRange);if(isShift){if(m.length>0)idx=m[m.length-1];else idx=markRange;if(m.length>0)m.length--;if(t.markType==1){idx=t.cIdx.indexOf(idx);markRange=t.cIdx.indexOf(markRange);}else{idx=t.rIdx.indexOf(idx);markRange=t.rIdx.indexOf(markRange);};if(idx>markRange){i=idx;idx=markRange;markRange=i;};for(i=idx;i<=markRange;i++){m[m.length]=((t.markType==1)?t.cols[t.cIdx[i]]._id:t.rows[t.rIdx[i]]._id);};}else{if(idx==-1)m[m.length]=markRange;};for(i=0;i<m.length;i++)if(t.markType==1)t.cols[m[i]].setMark(1,null,null,p);else t.rows[m[i]].setMark(1,null,null,p);break;case 3:m=markRange;for(i=0;i<m.length;i++)m[i]=m[i]-0;if(m[0]-m[2]==0&&m[1]-m[3]==0)
return;t.markType=markType;t.markRange=markRange;if(t.rIdx.indexOf(m[0])>t.rIdx.indexOf(m[2])){idx=m[0];m[0]=m[2];m[2]=idx;}if(t.cIdx.indexOf(m[1])>t.rIdx.indexOf(m[3])){idx=m[1];m[1]=m[3];m[3]=idx;}for(i=t.rIdx.indexOf(m[0]);i<=t.rIdx.indexOf(m[2]);i++)t.rows[t.rIdx[i]].setMark(1,t.cIdx.indexOf(m[1]),t.cIdx.indexOf(m[3])+1,p);break;};if(!p)t.paint();};CGp.clearMarkRange=function(markType){var t=this,i,m=t.markRange,p=(!ua.opera);if(t.markType==0)
return;if(t.markType==markType&&(isCtrl||isShift))
return;switch(t.markType){case 1:case 2:for(i=0;i<m.length;i++)if(t.markType==1)t.cols[m[i]].setMark(0,null,null,p);else t.rows[m[i]].setMark(0,null,null,p);break;case 3:if(Undef(m)||m.constructor!=Array||m.length==0)
return;for(i=t.rIdx.indexOf(m[0]);i<=t.rIdx.indexOf(m[2]);i++)t.rows[t.rIdx[i]].setMark(0,t.cIdx.indexOf(m[1]),t.cIdx.indexOf(m[3])+1,p);break;};t.markType=0;t.markRange.length=0;if(!p)t.paint();};CGp.init=function(gridDef){var t=this,d=new Date(),i,j,style="",imgs=[],c,data;if(Def(gridDef))t.def=gridDef;for(i in t){if((i.indexOf("Style")>-1||i.indexOf("Bar")>-1)&&t[i].constructor==Object){if(Def(t.def[i]))t[i]=t.def[i];for(j in t[i]){if(j.indexOf("Class")>-1)style+=t.makeStyle(t[i],j,'');};};if(i.indexOf("use")==0&&Def(t.def[i]))eval("t."+i+"="+t.def[i]);};t.showProgress("Get appearance parameters");if(Undef(t.tableStyle.overflow))t.tableStyle.overflow='auto';if(ua.moz&&t.tableStyle.overflow=="visible")t.tableStyle.overflow='auto';if(Def(style))dw("<style>"+style+"</style>");b=t.toolBar.buttons;for(i=0;Def(b)&&i<b.length;i++)for(j in b[i])if(j.indexOf("img")>-1&&Def(b[i][j]))imgs[imgs.length]=b[i][j].src;b=t.pageTurnBar;for(i in b)if(i.indexOf("img")>-1&&Def(b[i]))imgs[imgs.length]=b[i].src;for(i=0;i<imgs.length;i++)CodeThat.preload(imgs[i]);c=parseInt(t.def.amountPerPage);if(!isNaN(c)&&c>0)t.amountPerPage=c;t.userFunction=t.def.userFunction;t.writeProgress("Init grid "+t.rowCount+"x"+t.colCount);for(i=0;i<t.rowCount;i++){t.rows[i]=new CGRow(i,t);t.rIdx[i]=i;t.cells[i]=[];for(j=0;j<t.colCount;j++){c=(Def(t.def.colDef)&&(t.def.colDef.length>j)&&Def(t.def.colDef[j]))?t.def.colDef[j]:DEFAULT_COLDEF;if(i==0){t.cols[j]=new CGCol(j,t,c);t.cIdx[j]=j;}t.cells[i][j]=new CGCell(t.rows[i],t.cols[j],'');};};t.loadData(t.def.datatype,t.def.data);t.isInit=1;};CGp.toCSV=function(spt,isRng,change,lessreadonly){var t=this,s="",m,i,j,re,ri=(!t.vr.length)?t.rIdx:t.vr;if(Undef(spt))spt=";";if(Undef(isRng))isRng=0;if(Undef(change))change=0;if(Undef(lessreadonly))lessreadonly=0;re=new RegExp(spt+"+$");if(!isRng){for(i=0;i<t.rowCount;i++){if((change&&!t.rows[t.rIdx[i]].change)||(lessreadonly&&t.rows[t.rIdx[i]].isReadOnly))continue;for(j=0;j<t.colCount;j++){s+=t.cells[t.rIdx[i]][t.cIdx[j]].getDataForEdit().replace(/\r?\n/g,'\\n')+spt;}s=s.replace(re,'')+'\n';};}else{m=t.markRange;switch(t.markType){case 1:for(i=0;i<t.rowCount;i++){for(j=0;j<m.length;j++)s+=t.cells[t.rIdx[i]][m[j]].getDataForEdit().replace(/\r?\n/g,'\\n')+spt;s=s.replace(re,'')+'\n';};break;case 2:for(i=0;i<m.length;i++){for(j=0;j<t.colCount;j++)s+=t.cells[m[i]][t.cIdx[j]].getDataForEdit().replace(/\r?\n/g,'\\n')+spt;s=s.replace(re,'')+'\n';};break;case 3:for(i=ri.indexOf(m[0]);i<=ri.indexOf(m[2]);i++){for(j=t.cIdx.indexOf(m[1]);j<=t.cIdx.indexOf(m[3]);j++)s+=t.cells[ri[i]][t.cIdx[j]].getDataForEdit().replace(/\r?\n/g,'\\n')+spt;s=s.replace(re,'')+'\n';};break;};};s=s.replace(/\n+$/,'');
return s;};CGp.toCSVFile=function(change){
return '<?xml version="1.0" standalone="yes"?><data table="'+this.name+'">'+this.toCSV(';',0,change)+'</data>';};CGp.fromCSV=function(s,spt){var t=this,d,i;if(Undef(spt))spt=";";if(ua.oldB)d=s.split("\n");else d=s.split(/\n/);for(i=0;i<d.length;i++){d[i]=d[i].split(spt);};
return d;};CGp.fromCSVFile=function(s,spt){var t=this,d=[],doc=null,r,i,c;if(ua.oldB||Undef(s))
return d;if(window.ActiveXObject){doc=new ActiveXObject("Microsoft.XMLDOM");doc.async=0;doc.load(s);doc=doc.documentElement.text;};if(window.XMLHttpRequest){r=new XMLHttpRequest;r.open("GET",s,0);if(Def(r.overrideMimeType))r.overrideMimeType("text/xml");r.send(null);if(!r.responseXML)
return d;doc=r.responseXML.documentElement.firstChild.nodeValue;};if(Def(w)&&Def(w.document)&&w.document.readyState=='complete'){doc=w.document.getElementsByTagName("data")[0].firstChild.nodeValue;};if(Def(doc)){d=this.fromCSV(doc,spt);if(Def(w)&&!w.closed){w.close();w=null;curId=0;}
return d;};if(Undef(w)){w=window.open(s);window.focus();};if(curId<10)window.setTimeout(t.name+".loadData(3, '"+s+"', null)",1000);else{if(confirm(curId+" tries to access to file "+s+". \nDo you wish try again?")){curId=0;window.setTimeout(t.name+".loadData(3, '"+s+"', null)",1000);}else{alert("Can't load data from file "+s+"!");if(Def(w)&&!w.closed){w.close();w=null;curId=0;};};};curId++;
return d;};CGp.fromXML=function(x){var t=this,d=[];if(Undef(x)||x.indexOf("<?")==-1)
return d;var xml=new CXMLTree(x),i,j,f,k,b,p=["bold","italic","underline"];xml=xml.toObject();xml=xml.data;if(Def(xml.row)){xml=xml.row;if(Undef(xml))
return d;if(xml.constructor!=Array)xml=[xml];for(i=0;i<xml.length;i++){d[i]=[];f=xml[i].field;if(Undef(f))continue;if(f.constructor!=Array)f=[f];for(j=0;j<f.length;j++){for(k=0;k<p.length;k++){eval("b="+f[j][p[k]]);f[j][p[k]]=b;};if(Undef(f[j].align))f[j].align="";d[i][j]=(Undef(f[j].__value))?"":f[j];};};}else{for(i in xml)if(i.indexOf("value")>-1&&Def(xml[i]))x=xml[i];d=t.fromCSV(x);};
return d;};CGp.fromXMLField=function(f){var e=new Object(),p=["bold","italic","underline"],i;for(i=0;i<p.length;i++)e[p[i]]=(f.getAttribute(p[i])=="true")?1:0;e.align=f.getAttribute("align");if(Undef(e.align)||e.align=='undefined')e.align="";if(ua.ie)e.__value=(Def(f.text))?f.text:"";else e.__value=(Def(f.firstChild))?f.firstChild.nodeValue:"";if(Undef(e.__value))e="";
return e;};CGp.fromXMLFile=function(x){var t=this,d=[],doc=null,row,r,i,j;if(ua.oldB||Undef(x))
return d;if(window.ActiveXObject){doc=new ActiveXObject("Microsoft.XMLDOM");doc.async=0;doc.load(x);};if(window.XMLHttpRequest){r=new XMLHttpRequest;r.open("GET",x,0);if(Def(r.overrideMimeType))r.overrideMimeType("text/xml");r.send(null);if(!r.responseXML)
return d;doc=r.responseXML.documentElement;};if(ua.opera7&&Def(w)&&Def(w.document)&&w.document.readyState=='complete'){doc=w.document;};if(Def(doc)){for(i=0;i<doc.getElementsByTagName("row").length;i++){d[d.length]=[];row=doc.getElementsByTagName("row")[i];for(j=0;j<row.getElementsByTagName("field").length;j++)d[i][j]=t.fromXMLField((ua.moz)?row.getElementsByTagName("field")[j]:row.getElementsByTagName("field").item(j));};if(Def(w)&&!w.closed){w.close();w=null;curId=0;}
return d;};if(Undef(w)){w=window.open(x);window.focus();};if(curId<10)window.setTimeout(t.name+".loadData(2, '"+x+"', null)",1000);else{if(confirm(curId+" tries to access to file "+x+". \nDo you wish try again?")){curId=0;window.setTimeout(t.name+".loadData(2, '"+x+"', null)",1000);}else{alert("Can't load data from file "+x+"!");if(Def(w)&&!w.closed){w.close();w=null;curId=0;};};};curId++;
return d;};CGp.toXML=function(change,lessreadonly){if(Undef(change))change=0;if(Undef(lessreadonly))lessreadonly=0;var t=this,x='<?xml version="1.0" standalone="yes"?><data table="'+t.name+'">',i,j,c,n,s,x1;for(i=0;i<t.rowCount;i++){if((change&&!t.rows[t.rIdx[i]].change)||(lessreadonly&&t.rows[t.rIdx[i]].isReadOnly))continue;s="";x1="";for(j=0;j<t.colCount;j++){c=t.cells[t.rIdx[i]][t.cIdx[j]];n=t.cols[t.cIdx[j]].title;n=(Def(n)&&n.search(/[^a-z0-9_]/ig)==-1)?n:t.cols[0].getName(j);x1+='\n\t<field fieldname="'+n+'" bold="'+(Def(c.b))+'" italic="'+(Def(c.i))+'" underline="'+(Def(c.u))+'" align="'+c.alignment+'">'+c.getDataForEdit()+'</field>';s+=c.getDataForEdit()+";";};if(Def(s.replace(/;+$/,'')))x+='\n<row id="'+t.rows[t.rIdx[i]]._id+'">'+x1+'\n</row>';};x+='\n</data>';
return x;};CGp.loadData=function(datatype,data,cell){if(Undef(data))
return;if(Undef(datatype))datatype=0;var t=this,r=0,c=0,rc=t.rowCount,cc=t.colCount,ri,ci,i,j,e,d;if(Def(cell)){r=cell.row._id;c=cell.col._id;}r=t.rIdx.indexOf(r);c=t.cIdx.indexOf(c);t.writeProgress("Read data from source");switch(parseInt(datatype)){case 0:break;case 1:data=t.fromCSV(data);break;case 2:data=t.fromXMLFile(data);break;case 3:if(data.constructor==Array)data=data[1];data=t.fromCSVFile(data);break;case 4:data=t.fromXML(data);break;default:
return;};if(data.constructor!=Array||!data.length)
return;e=data[0];if(e.constructor!=Array){e=e.data;}if(e.constructor!=Array)
return;t.writeProgress("Load data into grid");if(data.length>rc-r)for(i=rc;i<r+data.length;i++)t.addRow(i,0,0);if(e.length>cc-c)for(i=cc;i<c+e.length;i++){d=(Def(t.def.colDef)&&(t.def.colDef.length>i)&&Def(t.def.colDef[i]))?t.def.colDef[i]:DEFAULT_COLDEF;t.addCol(i,0,0,d);};rc=t.rowCount;cc=t.colCount;for(i=r;i<r+data.length;i++){ri=t.rIdx[i];if(t.isInit)t.rows[ri].change=1;e=data[i-r];if(Undef(e))continue;if(e.constructor!=Array){t.rows[ri].userFunction=e.userFunction;e=e.data;}for(j=c;j<c+e.length;j++){ci=t.cIdx[j];t.cols[ci].index.length=0;t.cols[ci].filter.length=0;if(Def(e[j-c])&&e[j-c].constructor==Object&&Def(e[j-c].__value)){t.cells[ri][ci].b=(e[j-c].bold)?"bold":"";t.cells[ri][ci].i=(e[j-c].italic)?"italic":"";t.cells[ri][ci].u=(e[j-c].underline)?"underline":"";t.cells[ri][ci].alignment=e[j-c].align;t.cells[ri][ci].setData(e[j-c].__value);}else t.cells[ri][ci].setData(e[j-c]);};};if(t.isInit)t.paint();};CGp.useFilter=function(set){var t=this,i,use=0;for(i=0;i<t.colCount&&!use;i++)if(Def(set))use=use||(t.cols[i].useAutoFilter&&t.cols[i].filterValue!="");else use=use||t.cols[i].useAutoFilter;
return use;};CGp.toHTML=function(inDIV){var t=this,h,hi="",ht="",hf="",he="",i,j,r,c,b,cl,s,f,a=t.amountPerPage,ts=t.tableStyle,w=0,w1=0,w2=t.rowStyle.width,cmc,rmc,cdc,rdc=t.rowStyle.defaultClass,cd,rd;t.writeProgress("Create HTML content");if(t.useRCID)he="<th "+re+rdc+" width="+w2+"><img src='img/spacer.gif' border=0 width="+w2+" height=1></th>";for(i=0;i<t.colCount;i++){c=t.cIdx[i];if(!t.cols[c].isVisible)continue;b=(Def(t.curCell)&&t.curCell.col._id==t.cols[c]._id);cdc=t.cols[c].defaultClass;cmc=t.cols[c].markClass;cd=(ua.ie)?"<img src='img/spacer.gif' border=1 width=5 height=10 "+re+t.cols[c].dragClass+" style='position:relative;left:5;' id='_ID_'>":"";if(t.useRCID)hi+="<th id='"+t.cols[c].getID('col')+"' "+t.cols[c].width+" "+re+((t.cols[c].isMark||b)?cmc:cdc)+">"+cd.replace(/_ID_/,t.cols[c].getID("cold"))+t.cols[c].getName(i)+"</th>";ht+="<th id='"+t.cols[c].getID('title')+"' "+re+t.cols[c].titleClass+" "+t.cols[c].width+">"+t.cols[c].title+"</th>";if(t.cols[c].useAutoIndex&&!t.cols[c].index.length)t.setIndex(c);if(!t.cols[c].filter.length)t.cols[c].setFilter();hf+="<th "+re+t.cols[c].titleClass+">"+t.cols[c].filterToHTML()+"</th>";w1=t.cols[c].width;if(w1.constructor!=String)w1+="";w1=w1.replace(/[^0-9]/ig,'')*1;w+=(w1>0)?w1:t.colStyle.width;};h="<table cellpadding=0 cellspacing=0 border=1 width="+w+">"+"<tr>"+he+hi+"</tr>"+((t.useColTitle)?"<tr>"+he+ht+"</tr>":"")+((t.useFilter()&&!ua.oldB)?"<tr>"+he+hf+"</tr>":"");if(!t.vr.length){t.writeProgress("Hide invisible rows");for(i=0;i<t.rIdx.length;i++)if(t.rows[t.rIdx[i]].isVisible)t.vr[t.vr.length]=t.rIdx[i];}t.pageCount=((t.vr.length%a==0)?(t.vr.length/a):(Math.floor(t.vr.length/a)+1));s=(t.page-1)*a;f=(t.page*a<t.vr.length)?t.page*a:t.vr.length;for(i=s;i<f;i++){r=t.vr[i];b=(Def(t.curCell)&&t.curCell.row._id==t.rows[r]._id);rdc=t.rows[r].defaultClass;rmc=t.rows[r].markClass;rd=(ua.ie)?"<img src='img/spacer.gif' border=1 width=5 height=10 "+re+t.rows[r].dragClass+" style='position:relative;left:5;' id='_ID_'>":"";if(t.useRCID)h+="<tr "+t.rows[r].height+"><th nowrap width='"+w2+"' id='"+t.rows[r].getID('row')+"' "+re+((t.rows[r].isMark||b)?rmc:rdc)+">"+rd.replace(/_ID_/,t.rows[r].getID("rowd"))+t.rows[r].getName(i)+"</th>";for(j=0;j<t.colCount;j++){c=t.cIdx[j];if(!t.cols[c].isVisible)continue;cl=t.cells[r][c];h+="<td "+t.cols[c].alignment+t.cols[c].width+" id='"+cl.getID()+"' "+re+((cl==t.curCell)?cl.currClass:((cl.isMark)?cl.markClass:cl.defaultClass))+" "+cl.getStyle()+">"+cl.getData()+"</td>";};h+="</tr>";};h+="</table>";if(inDIV)if(ua.moz)h="<div id='"+t.getID("cnt")+"' style='background-color:"+ts.bgcolor+";top:"+ts.y+";left: "+ts.x+";width:"+(ts.width-4)+";height:"+ts.height+";overflow:hidden;' "+re+ts.tableClass+"><div id='"+t.name+"' style='height:100%;width:100%;overflow:"+ts.overflow+";'>"+h+"</div></div>";else if(!ua.oldB)h="<div id='"+t.name+"' style='background-color:"+ts.bgcolor+";top:"+ts.y+";left: "+ts.x+";width:"+ts.width+";height:"+ts.height+";overflow:"+ts.overflow+";' "+re+ts.tableClass+">"+h+"</div>";
return h;};CGp.paint=function(){var t=this,o=CT_fe(t.name);if(Def(o)){CT_HTML(t.name,t.toHTML());t.paintBar("sb");t.paintBar("pt");}else{if(!ua.oldB)dw("<style>.separator{background-color: #ffffff;height: 22px; border-left: 1px inset;width: 2px;}\n#cell{font-size:11px;}</style>");dw(t.tbToHTML()+t.sbToHTML(1)+t.toHTML(1)+t.ptToHTML(1));if(!ua.oldB)CT_regEvents(t.name,t.getID("pt"));if(t.useExportBar)dw(t.ebToHTML());};t.hideProgress();};CGp.doAction=function(datatype,data){var t=this;if(Def(datatype)&&Def(data)){t.isInit=0;t.loadData(datatype,data,null);t.isInit=1;};if(ua.oldB){var l=window.location.href,i;if(l.indexOf("?")>-1){l=l.slice(l.indexOf("?")+1);l=l.split("&");for(i=0;i<l.length;i++)if(Def(l[i]))eval(t.name+"."+l[i]);};};t.paint();};CGp.getID=function(prx){
return prx+this.name;};CGp.paintBar=function(bar){if(ua.oldB)
return;var t=this,h=eval(t.name+"."+bar+"ToHTML()");if(Def(h))CT_HTML(t.getID(bar),h);};CGp.sbToHTML=function(inDIV){var t=this,sb=t.statusBar;if(ua.oldB||sb.height==0)
return "";var h,cl=t.curCell,f="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;",v="",m=t.msg;if(Def(cl)){f=cl.col.getName(t.cIdx.indexOf(cl.col._id))+cl.row.getName(t.rIdx.indexOf(cl.row._id))+"&nbsp;";v=cl.getData();};if(t.searchValue!="")m="Current search: "+t.searchValue+"&nbsp;"+t.msg;h="<table width=100% cellpadding=0 cellspacing=0 border=0 "+re+sb.defaultClass+"><tr><td>"+sb.fieldText+": </td><td>"+f+"</td><td>"+sb.valueText+":</td><td nowrap>"+v+"</td><td align=right "+re+sb.messageClass+" nowrap width=80%>"+m+"&nbsp;</td></tr></table>";if(inDIV)h="<div id='"+t.getID("sb")+"' style='width:"+t.tableStyle.width+";height:"+sb.height+";overflow:hidden;background-color:"+sb.bgcolor+"'>"+h+"</div>";
return h;};CGp.ptToHTML=function(inDIV){var t=this,i,h,s,c=t.pageCount,a=t.amountPerPage,pb=t.pageTurnBar,w=0,w1=t.tableStyle.width,w2=pb.width;w1=(isNaN(w1)||ua.oldB)?DEFAULT_COLDEF.width*t.colCount:w1;if(c==1)h="&nbsp;";else{h="<table border=0 cellpadding=0 cellspacing=1><tr>";for(i=1;i<=c;i++){s=(i==t.page)?((Def(pb.img_on))?pb.img_on.src:""):((Def(pb.img_off))?pb.img_off.src:"");if(Def(s))s="style='background-image:url("+s+");background-repeat:no-repeat;background-position:center'";h+="<th id='"+t.getID("pt"+i)+"'"+s+" "+re+((i==t.page)?pb.activeClass:pb.defaultClass)+" width="+w2+" height="+pb.height+">"+((i==t.page)?pb.text+" "+i:"<a href='javascript:"+t.name+".setPage("+i+")' style='text-decoration:none'>"+pb.text+" "+i+"</a>")+"</th>";w+=w2;if(w1>0&&(w+w2)>w1){w=0;h+="</tr><tr>";}}h+="</tr></table>";};if(inDIV)h="<div id='"+t.getID("pt")+"'>"+h+"</div>";
return h;};CGp.tbToHTML=function(){var t=this,tb=t.toolBar;if(ua.oldB||tb.height==0)
return "";var b=tb.buttons,i,ion,iof,href,k,k1,s=tb.searchControl,h="<div id='"+t.getID("tb")+"' "+re+tb.defaultClass+" style='width:"+t.tableStyle.width+";height:"+tb.height+";overflow:hidden;background-color:"+tb.bgcolor+"''><table cellpadding=1 cellspacing=1 border=0><tr>";if(Def(s)){b[b.length]={name:"setsearch",mg_on:s.img_on,text:s.text_on};b[b.length]={name:"resetsearch",img_on:s.img_off,text:s.text_off};};k=0;k1=0;for(i=0;i<b.length&&!k;i++){if(b[i].name=='setamount')k=1;if(b[i].name=='resetsort')k1=1;};if(!k)b[b.length]={name:"setamount",text:"Amount"};if(!k1)b[b.length]={name:"resetsort",text:"Reset sort"};for(i=0;i<b.length;i++){href="";if(Undef(b[i].name))h+="<th><span class=separator></span></th>";else{switch(b[i].name){case "addrowto":href=t.name+".addRow(null, -1)";break;case "addrowafter":href=t.name+".addRow(null, 1)";break;case "delrow":href=t.name+".delRows()";break;case "addcolto":href=t.name+".addCol(null, -1)";break;case "addcolafter":href=t.name+".addCol(null, 1)";break;case "delcol":href=t.name+".delCols()";break;case "sortasc":href=t.name+".setSort(null, 1)";break;case "sortdesc":href=t.name+".setSort(null, -1)";break;case "multisortasc":if(!t.useMultiSort)continue;href=t.name+".setMultiSort(null, 1)";break;case "multisortdesc":if(!t.useMultiSort)continue;href=t.name+".setMultiSort(null, -1)";break;case "resetsort":href=t.name+".resetSort()";break;case "copy":case "paste":href=t.name+"."+b[i].name+"()";break;case "formatbold":href=t.name+".setCellStyle(\"b\")";break;case "formatitalic":href=t.name+".setCellStyle(\"i\")";break;case "formatunderline":href=t.name+".setCellStyle(\"u\")";break;case "alignleft":href=t.name+".setCellStyle(\"alignment\", \"left\")";break;case "aligncenter":href=t.name+".setCellStyle(\"alignment\", \"center\")";break;case "alignright":href=t.name+".setCellStyle(\"alignment\", \"right\")";break;case "setsearch":href=t.name+".setSearch()";break;case "resetsearch":href=t.name+".resetSearch()";break;case "setamount":href=t.name+".setAmountPerPage()";break;};if(href=="")continue;if(Undef(b[i].img_off))b[i].img_off=b[i].img_on;ion=makeImgTag(b[i].img_on,b[i].name,b[i].text);iof=makeImgTag(b[i].img_off,b[i].name,b[i].text);if(Undef(ion)&&Undef(iof))ion=b[i].text;if(Def(ion)&&Def(iof)&&ion!=iof)s="onMouseOver='document.images[\""+b[i].name+"\"].src=\""+b[i].img_on.src+"\";' onMouseOut='document.images[\""+b[i].name+"\"].src=\""+b[i].img_off.src+"\";'";if(Undef(ion)&&Undef(iof))s="onMouseOut='this.style.borderColor=\"#000000\";' onMouseOver='this.style.borderColor=\"#cccccc\";' style='border-width:1;border-style:outset;border-color:#cccccc'";h+="<th><a href='javascript:"+href+"' "+s+" title='"+b[i].text+"'>"+iof+"</a></th>";};};h+="</tr></table></div>";
return h;};CGp.ebToHTML=function(){var t=this,h;h="<textarea  name=\"csv\" rows=5 cols=90 style=\"width:"+t.tableStyle.width+";overflow:auto;\" onSelect=\""+this.name+".clip = this.value;\"></textarea><br>"+" <br><input type=\"button\" value=\"Export to CSV String\" onClick=\"this.form.csv.value = "+this.name+".toCSV(';', 0)\">"+" <input type=\"button\" value=\"Export to CSV file\" onClick=\"this.form.csv.value = "+this.name+".toCSVFile()\">"+" <input type=\"button\" value=\"Export to XML\" onClick=\"this.form.csv.value = "+this.name+".toXML()\">";h="<div id='"+t.getID("eb")+"'><form name='"+t.getID('exportForm')+"'>"+h+"</form></div>";
return h;};CGp.resetSort=function(sortCol){var t=this,mc=t.multiSortCol,mt=t.multiSortType,i;if(t.sortCol==-1)
return;if(Undef(sortCol))sortCol=-1;t.showProgress("Reset sort");i=mc.indexOf(sortCol);if(i<1){for(i=0;i<t.rowCount;i++)t.rIdx[i]=t.rows[i]._id;t.vr.length=0;t.setPage(1);}else{mc.length=i;mt.length=i;t.setMultiSort(mc[i-1],mt[i-1]);};};CGp.setSort=function(sortCol,sortType){var t=this,i;if(Undef(sortCol)){if(Def(t.curCell))sortCol=t.curCell.col._id;else if(t.markType==1)sortCol=t.markRange[0];else sortCol=prompt("Set the column for sort as number: A, B, ... or title","A");if(isNaN(parseInt(sortCol))){sortCol=t.getColByTitle(sortCol)};if(Undef(sortCol)||sortCol==-1)
return;};if(t.markType==3)t.clearMarkRange();t.showProgress("Sort "+t.cols[sortCol].title);t.sortCol=sortCol;t.sortType=sortType;t.multiSortCol.length=0;t.multiSortType.length=0;if(!t.cols[t.sortCol].index.length)t.setIndex(t.sortCol);t.rIdx.setValue(t.cols[t.sortCol].index);if(t.sortType==-1)t.rIdx.reverse();t.vr.length=0;t.setPage(1);};CGp.setMultiSort=function(sortCol,sortType){var t=this,mc=t.multiSortCol,mt=t.multiSortType,i,j,k,left,right,rows,r1,r2;if(!t.useMultiSort)
return;if(Undef(sortCol)){if(Def(t.curCell))sortCol=t.curCell.col._id;else if(t.markType==1)sortCol=t.markRange[0];else sortCol=prompt("Set the column for sort as number: A, B, ... or title","A");if(isNaN(parseInt(sortCol))){sortCol=t.getColByTitle(sortCol);};if(Undef(sortCol)||sortCol==-1)
return;};if(t.markType==3)t.clearMarkRange();t.showProgress("Multi sort "+t.cols[sortCol].title);if(mc.length==0){if(t.sortCol==-1){t.sortCol=sortCol;t.sortType=sortType;}else{mc[mc.length]=t.sortCol;mt[mt.length]=t.sortType;}mc[mc.length]=sortCol;mt[mt.length]=sortType;}else{i=mc.indexOf(sortCol);if(i>-1){mt[i]=sortType;}else{mc[mc.length]=sortCol;mt[mt.length]=sortType;};};if(t.cols[t.sortCol].index.length==0)t.setIndex(t.sortCol);t.rIdx.setValue(t.cols[t.sortCol].index);if(t.sortType==-1)t.rIdx.reverse();t.writeProgress("Create multi index for "+t.cols[sortCol].title);for(i=1;i<mc.length;i++){for(j=1;j<t.rowCount;j++){left=right=-1;r1=t.rIdx[j-1];r2=t.rIdx[j];while(t.cells[r1][mc[i-1]].compareTo(t.cells[r2][mc[i-1]])==0){if(left==-1)left=j-1;right=j;j++;if(j<t.rowCount){r1=t.rIdx[j-1];r2=t.rIdx[j];}else break;};if(left>-1&&right>-1){rows=t.setIndex2(mc[i],left,right);if(mt[i]==-1)rows.reverse();for(k=0;k<rows.length;k++)t.rIdx[left+k]=rows[k]._id;};};};t.vr.length=0;t.setPage(1);};CGp.setIndex=function(sortCol){var t=this,i,sc=t.sortCol,rows=[];t.writeProgress("Create index for "+t.cols[sortCol].title);t.sortCol=sortCol;rows.setValue(t.rows);rows=rows.sort(t.compare);for(i=0;i<t.rowCount;i++){t.cols[t.sortCol].index[i]=rows[i]._id;};t.sortCol=sc;};CGp.setIndex2=function(sortCol,left,right){var t=this,sc=t.sortCol,rows=[],i,j;t.sortCol=sortCol;for(i=left;i<right+1;i++){j=t.rows.indexOf(t.rIdx[i]);rows[rows.length]=t.rows[j];};rows=rows.sort(t.compare);t.sortCol=sc;
return rows;};CGp.resetSearch=function(){var t=this;if(t.searchValue=="")
return;if(t.markType==3)t.clearMarkRange();t.searchValue="";t.search();};CGp.setFilter=function(filterCol,filterValue){var t=this;if(t.markType==3)t.clearMarkRange();t.showProgress("Set filter '"+filterValue+"' on "+t.cols[filterCol].title);t.cols[filterCol].filterValue=filterValue;t.search();};CGp.setSearch=function(){var t=this,searchValue=prompt("Enter your query:",t.searchValue);if(Undef(searchValue))
return;if(t.markType==3)t.clearMarkRange();t.showProgress("Search value '"+searchValue+"'");t.searchValue=searchValue;t.search();};CGp.setAmountPerPage=function(){var t=this,amount=prompt("Set count records per page",t.amountPerPage);if(!isNaN(parseInt(amount))){amount=parseInt(amount);if(amount<=0)
return;t.amountPerPage=amount;t.showProgress("Set '"+amount+"' records per page");t.setPage(1);};};CGp.search=function(){var t=this,i,f=[];t.vr=[];for(i=0;i<t.colCount;i++)if(t.cols[i].useAutoFilter&&t.cols[i].filterValue!="")f[f.length]=i;t.writeProgress("Search match rows");for(i=0;i<t.rowCount;i++)t.rows[i].isVisible=t.rows[i].search(t.searchValue,f);t.setPage(1);};CGp.compare=function(row1,row2){var g=row1.grid,c=g.sortCol,r1;
return g.cells[row1._id][c].compareTo(g.cells[row2._id][c]);};CGp.showProgress=function(m){var t=this;t.winProgress=window.document.title;t.writeProgress(m);};CGp.writeProgress=function(m){var t=this;if(!t.useProgress)
return;window.document.title=m+'...';window.status=m+'...';};CGp.hideProgress=function(){var t=this;if(!t.useProgress)
return;window.document.title=t.winProgress;window.status='';};CGp.setPage=function(page){var t=this,d=new Date(),l=window.location.href;t.page=page;if(ua.oldB){if(l.indexOf("setPage("+page+")")==-1){l=l.replace(/setPage\([0-9]+\)/,'');l=l+((l.indexOf("?")>-1)?"&":"?")+"setPage("+page+")";window.location.href=l.replace(/\?&/,'?');};}else{t.writeProgress("Set current page "+t.page+"");t.paint();};};CGp.addRow=function(idx,offset,p){var t=this,l=t.rowCount,i,cl;if(Undef(p))p=1;if(Undef(idx)){cl=t.curCell;if(Undef(cl)){if(t.markType==2)idx=t.markRange[0];else idx=0;}else idx=cl.row._id;idx=t.rIdx.indexOf(idx);if(offset>0)idx++;};if(p)t.showProgress("Create new Row "+idx);t.rows[l]=new CGRow(l,t);if(p)t.writeProgress("Create cells");t.cells[l]=new Array(t.colCount);for(i=0;i<t.colCount;i++){t.cols[i].index.length=0;t.cells[l][i]=new CGCell(t.rows[l],t.cols[i],'');if(t.cols[i].useAutoFilter&&t.isInit)t.cols[i].setFilter();};t.vr.length=0;t.rIdx.insert(l,idx);t.rowCount++;if(p)t.paint();};CGp.delRows=function(){var t=this,m=[],i,j;if(Undef(t.curCell)||t.markType==3){switch(t.markType){case 1:case 3:alert("Choose row for deleting!");
return;case 2:m.setValue(t.markRange);t.clearMarkRange();m.sort(compare);for(i=0;i<m.length;i++){t.delRow(m[i],0);for(j=i;j<m.length;j++)if(m[j]>m[i])m[j]--;};break;};}else t.delRow(null,0);t.paint();};CGp.delRow=function(idx,p){var t=this,i,cl,col=0,idx1;if(t.rowCount==1){alert("You can't delete this row!");
return;};if(Undef(p))p=1;if(Undef(idx)){cl=t.curCell;if(Undef(cl)){alert("Choose row for deleting!");
return;}else{idx=cl.row._id;col=cl.col._id;};};idx1=t.rIdx.indexOf(idx);t.showProgress("Delete row "+idx1);t.rIdx.remove(idx1);for(i=0;i<t.rIdx.length;i++){if(parseInt(t.rIdx[i])>parseInt(idx)){t.rIdx[i]--;}};t.rows.remove(idx);t.cells.remove(idx);t.rowCount--;for(i=0;i<t.colCount;i++){t.cols[i].index.length=0;if(t.cols[i].useAutoFilter)t.cols[i].setFilter();};if(Def(cl))t.setCurCell(t.cells[t.rIdx[idx1]][col]);t.vr.length=0;if(p)t.paint();};CGp.addCol=function(idx,offset,p,d){var t=this,l=t.colCount,i;if(Undef(p))p=1;if(Undef(idx)){cl=t.curCell;if(Undef(cl)){if(t.markType==1)idx=t.markRange[0];else idx=0;}else idx=cl.col._id;idx=t.cIdx.indexOf(idx);if(offset>0)idx++;};if(p)t.showProgress("Create new Column "+idx);t.cols[l]=new CGCol(l,t,d);if(p)t.writeProgress("Create cells");for(i=0;i<t.rowCount;i++){t.cells[i].insert(new CGCell(t.rows[i],t.cols[l],''),l);t.rows[i].change=1;};t.cIdx.insert(l,idx);t.colCount++;t.sortCol=-1;if(p)t.paint();};CGp.delCols=function(){var t=this,m=[],i,j;if(Undef(t.curCell)||t.markType==3){switch(t.markType){case 1:m.setValue(t.markRange);t.clearMarkRange();m.sort(compare);for(i=0;i<m.length;i++){t.delCol(m[i],0);for(j=i;j<m.length;j++)if(m[j]>m[i])m[j]--;};break;case 2:case 3:alert("Choose column for deleting!");
return;};}else t.delCol(null,0);t.paint();};CGp.delCol=function(idx,p){var t=this,i,row=0,cl,idx1;if(Undef(p))p=1;if(t.colCount==1){alert("You can't delete this column!");
return;};if(Undef(idx)){cl=t.curCell;if(Undef(cl)){alert("Choose column for deleting!");
return;}else{idx=cl.col._id;row=cl.row._id;};};idx1=t.cIdx.indexOf(idx);t.showProgress("Delete column "+t.cols[idx].title);t.cIdx.remove(idx1);for(i=0;i<t.cIdx.length;i++)if(parseInt(t.cIdx[i])>parseInt(idx))t.cIdx[i]--;t.cols.remove(idx);for(i=0;i<t.rowCount;i++){t.cells[i].remove(idx);t.rows[i].change=1;}t.colCount--;t.sortCol=-1;if(Def(cl))t.setCurCell(t.cells[row][t.cIdx[idx1]]);if(p)t.paint();};CGp.setCurCell=function(cell){var t=this;if(Def(cell))t.clearMarkRange();if(t.curCell!=cell){if(Def(t.curCell))t.curCell.setState(0);if(Def(cell)){t.curCell=cell;t.curCell.setState(1);};}else{if(Def(t.curCell)){if(t.curCell.state==2)t.curCell.setState(1);else t.curCell.setState(2);};};t.curCell=cell;rng.length=0;};CGp.setCellStyle=function(param,value,cell){var t=this,i,j,m=t.markRange;if(Undef(cell))cell=t.curCell;if(Undef(cell)){switch(t.markType){case 1:for(i=0;i<m.length;i++){for(j=0;j<t.rowCount;j++)t.cells[j][m[i]].setStyle(param,value);};break;case 2:for(i=0;i<m.length;i++)for(j=0;j<t.colCount;j++)t.cells[m[i]][j].setStyle(param,value);break;case 3:break;default:alert("Choose cell before!");
return;break;};}else cell.setStyle(param,value);};CGp.getColByTitle=function(title){var t=this,i=-1,j;if(Undef(title))
return i;else title=title.toUpperCase();for(i=0;i<t.cols.length&&Def(title);i++){j=t.cIdx.indexOf(t.cols[i]._id);if(t.cols[i].title.toUpperCase()==title||t.cols[i].getName(j)==title)
return i;};
return-1;};CGp.copy=function(){var t=this;if(Def(t.curCell)&&!t.markType)t.clip=t.curCell.getDataForEdit();else t.clip=t.toCSV(";",1)+"";t.setClipData(t.clip);};CGp.paste=function(){var t=this,d=[];if(Undef(t.curCell)){alert("Choose cell before!");
return;};t.showProgress("Pasting data");if(!ua.opera&&Def(t.getClipData()))t.clip=t.getClipData();if(t.clip.indexOf('\t')==-1)d=t.fromCSV(t.clip);else d=t.fromCSV(t.clip,'\t');t.loadData(0,d,t.curCell);};CGp.getClipData=function(){if(ua.ie)
return window.clipboardData.getData("Text");if(ua.moz){netscape.security.PrivilegeManager.enablePrivilege('UniversalXPConnect');var clip=Components.classes['@mozilla.org/widget/clipboard;1'].createInstance(Components.interfaces.nsIClipboard);if(!clip)
return;var trans=Components.classes['@mozilla.org/widget/transferable;1'].createInstance(Components.interfaces.nsITransferable);if(!trans)
return;trans.addDataFlavor('text/unicode');clip.getData(trans,clip.kGlobalClipboard);var str=new Object();var len=new Object();eval("try { trans.getTransferData('text/unicode',str,len);}catch(exception) { return;}");if(str){if(Components.interfaces.nsISupportsWString)str=str.value.QueryInterface(Components.interfaces.nsISupportsWString);else if(Components.interfaces.nsISupportsString)str=str.value.QueryInterface(Components.interfaces.nsISupportsString);else str=null;}if(str)
return(str.data.substring(0,len.value/2));};
return null;};CGp.setClipData=function(d){if(!ua.ie)
return;eval("try {window.clipboardData.setData('Text', d)}catch(e){}");};};function CGRow(id,g){var t=this,i,s;t._id=id;t.grid=g;t.isVisible=1;t.height="height="+t.grid.rowStyle.height;t.change=0;t.isMark=0;t.isReadOnly=0;t.userFunction=null;s=t.grid.rowStyle;for(i in s)if(i.indexOf("Class")>-1)t[i]=s[i];};{var CRp=CGRow.prototype;CRp.getName=function(num){if(Undef(num))num=this._id+1;num=num*1+1;
return num;};CRp.getID=function(prx){var t=this;
return t.grid.getID(prx)+t._id;};CRp.valueOf=function(){
return this._id;};CRp.search=function(s,f){var t=this,g=t.grid,i,d,find=1;for(i=0;i<f.length&&find;i++){if(g.cells[t._id][f[i]].getDataForFilter()!=g.cols[f[i]].filterValue)find=0;};if(find&&Def(s)){find=0;s=new RegExp(makeRE(s),"gi");for(i=0;i<g.colCount&&!find;i++){find=find||s.test(g.cells[t._id][i].getDataForFilter());};};
return find;};CRp.setMark=function(isMark,s,f,p){var t=this,i,g=t.grid,c=g.cells,s1=s,f1=f;if(Undef(isMark))isMark=!t.isMark;if(Undef(p))p=1;t.isMark=isMark;if(Undef(s1))s1=0;if(Undef(f1))f1=g.colCount;t.grid.writeProgress("Mark rows for current selection");for(i=s1;i<f1;i++){c[t._id][i].isMark=t.isMark;if(g.markType==3)g.cols[i].isMark=t.isMark;};if(p)t.paint(s,f);};CRp.paint=function(s,f){var t=this,i,g=t.grid,c=g.cells,o;if(Undef(s))s=0;if(Undef(f))f=g.colCount;t.grid.writeProgress("Paint rows for current selection");for(i=s;i<f;i++){c[t._id][g.cIdx[i]].paint(g.markType==3);}o=CT_fe(t.getID('row'));if(Def(o))CT_css(o,((t.isMark)?t.markClass:t.defaultClass));t.grid.hideProgress();};CRp.setHeight=function(h){var t=this,g=t.grid;if(Undef(h))h=prompt("Set height for row",t.height.replace(/[^0-9%]/g,''));if(!isNaN(parseInt(h))){t.height="height="+h;g.paint();}};CRp.callHandler=function(e){if(Def(this.handler))this.handler(e);};};function CGCol(id,g,colDef){var t=this,w,i,s;t._id=id;t.grid=g;t.index=[];t.filter=[];t.filterValue="";s=t.grid.colStyle;for(i in s)if(i.indexOf("Class")>-1)t[i]=s[i];for(i in DEFAULT_COLDEF)t[i]=DEFAULT_COLDEF[i];if(Def(colDef)){for(i in colDef){if(Def(colDef[i]))if(i.indexOf("is")>-1||i.indexOf("use")>-1||i.indexOf("Function")>-1)eval("t[i] = "+colDef[i]);else t[i]=colDef[i];};w=parseInt(colDef.width);t.width=(isNaN(w)||w>0)?" width=\""+colDef.width+"\"":"";t.alignment=(Def(colDef.alignment))?" align=\""+colDef.alignment+"\"":"";};if(Undef(t.title))t.title='Column'+t.getName(t._id);if(Undef(t.titleClass))t.titleClass=t.defaultClass;};{var CCp=CGCol.prototype;CCp.callHandler=function(e){if(Def(this.handler))this.handler(e);};CCp.getName=function(num){if(Undef(num))num=this._id;var basis=26,offset=65,order=[],name="";while(num>basis){order[order.length]=num%basis;num=num/basis;}order[order.length]=num%basis;if(order.length>1)if(order[order.length-1]>0)order[order.length-1]--;for(var z=order.length-1;z>-1;z--){name+=String.fromCharCode(order[z]*1+offset);};
return name;};CCp.setTitle=function(){var t=this,title=prompt("Set title",t.title);if(title){t.title=title;changeContent(t.getID("title"),t.title)};};CCp.getID=function(prx){var t=this;
return t.grid.getID(prx)+t._id;};CCp.valueOf=function(){
return this._id;};CCp.setFilter=function(){var t=this,g=t.grid,i,v;if(!t.useAutoFilter||!t.grid.isInit)
return;g.writeProgress("Update filter for column "+t.title);t.filter.length=0;for(i=0;i<g.rows.length;i++){v=g.cells[i][t._id].getDataForFilter();if(Def(v)&&typeof(v)!='unknown'&&t.filter.indexOf(v)==-1)t.filter[t.filter.length]=v;};if(t.filter.length&&!ua.oldB)eval("try{t.filter = t.filter.sort(compare)}catch(e){}");};CCp.filterToHTML=function(){var t=this,i,h="&nbsp;";if(!t.useAutoFilter)
return h;h="<select id='"+t.getID("filter")+"' name='"+t.getID("filter")+"' onChange='"+t.grid.name+".setFilter("+t._id+", this.value)'><option value=''>"+EMPTY_ROW+"</option>";for(i=0;i<t.filter.length;i++)h+="<option value=\""+t.filter[i]+"\""+((t.filterValue!=""&&t.filter[i].toString()==t.filterValue)?" selected":"")+">"+t.filter[i]+"</option>";h+="</select>";
return h;};CCp.setMark=function(isMark,s,f,p){var t=this,i,c=t.grid.cells,f1=f,s1=s;if(Undef(isMark))isMark=!t.isMark;if(Undef(p))p=1;t.isMark=isMark;if(Undef(s1))s1=0;if(Undef(f1))f1=t.grid.rowCount;t.grid.writeProgress("Mark columns for current selection");for(i=s1;i<f1;i++)c[i][t._id].isMark=t.isMark;if(p)t.paint(s,f);};CCp.paint=function(s,f){var t=this,i,g=t.grid,a=g.amountPerPage,c=g.cells,o;if(Undef(s))s=(g.page-1)*a;if(Undef(f))f=((g.page*a<g.vr.length)?g.page*a:g.vr.length);t.grid.writeProgress("Paint columns for current selection");for(i=s;i<f;i++){c[g.vr[i]][t._id].paint(0);}o=CT_fe(t.getID('col'));if(Def(o))CT_css(o,((t.isMark)?t.markClass:t.defaultClass));t.grid.hideProgress();};CCp.setWidth=function(w){var t=this,g=t.grid;if(Undef(w))w=prompt("Set width for column",t.width.replace(/[^0-9%]/g,''));if(!isNaN(parseInt(w))){t.width="width="+w;g.paint();}};};function CGCell(row,col,data){var t=this,s,i;t.row=row;t.col=col;t.state=0;t.isMark=0;t.isReadOnly=0;t.alignment="";t.b="";t.u="";t.i="";t.data=null;t.setData(data);s=t.row.grid.cellStyle;for(i in s)if(i.indexOf("Class")>-1)t[i]=s[i];};{var CCp=CGCell.prototype;CCp.callHandler=function(e){if(Def(this.handler))this.handler(e);};CCp.setData=function(data,isService){var t=this,f,err="",i,fa=t.col.filter,g=t.col.grid;if(Undef(isService))isService=(t.col.isReadOnly||t.row.isReadOnly);switch(t.col.type){case "Date":if(Def(data)&&parseDate(data,DATE_FORMAT)==null){err=data;data=t.data;}else data=parseDate(data,DATE_FORMAT);break;case "Image":break;case "Number":case "Currency":default:if(ua.oldB)eval("data = parse"+t.col.type+"(data)");else eval("try{eval(\"data = parse\" + t.col.type + \"(data)\");}catch(e){};");};if(Def(err))alert("Can't parse data "+err+" as "+t.col.type+"!");if(t.row.grid.isInit&&data!=t.data){t.row.change=1;t.data=data;if(!isService){if(Def(t.row.userFunction))t.row.userFunction(g,t);if(Def(t.col.userFunction))t.col.userFunction(g,t);if(Def(g.userFunction))g.userFunction(g,t);};};t.data=data;if(g.isInit&&t.col.useAutoFilter&&fa.indexOf(t.getDataForFilter())==-1&&Def(t.data)&&typeof(t.data)!='unknown'){fa=t.col.filter;fa[fa.length]=t.getDataForFilter();fa.sort(compare);f=CT_fe(t.col.getID("filter"));if(Def(f))f.outerHTML=t.col.filterToHTML();if(ua.moz){t.row.grid.paint()};};};CCp.getData=function(){var t=this,data=t.data;if(Undef(t.data))data=DEFAULT_RESULT;else switch(t.col.type){case "URL":data=formatURL(t.data,"blank");break;case "String":case "Number":case "HTML":case "Email":if(ua.oldB)eval("data = format"+t.col.type+"(t.data)");else eval("try{eval('data = format' + t.col.type + '(t.data)');}catch(e){data = t.data};");break;case "Image":if((Def(t.data)&&t.data.constructor!=Object)||ua.oldOpera)t.data=parseImage(t.data);data=formatImage(t.data);break;case "Date":case "Currency":default:if(ua.oldB)eval("data = format"+t.col.type+"(t.data, "+t.col.type.toUpperCase()+"_FORMAT)");else eval("try{eval('data = format' + t.col.type + '(t.data, ' + t.col.type.toUpperCase() + '_FORMAT)');}catch(e){data = t.data};");break;};
return data;};CCp.getDataForEdit=function(){var t=this,data=t.data;if(Undef(t.data)||t.col.type=="Image")data="";else if(t.col.type=="Date")data=formatDate(t.data,DATE_FORMAT);
return new String(data);};CCp.getDataForFilter=function(){var t=this,data=t.data;if(Undef(t.data))data="";else switch(t.col.type){case "Date":case "Currency":if(ua.oldB)eval("data = format"+t.col.type+"(t.data, "+t.col.type.toUpperCase()+"_FORMAT)");else eval("try{eval('data = format' + t.col.type + '(t.data, ' + t.col.type.toUpperCase() + '_FORMAT)');}catch(e){data = t.data};");break;case "Image":if(t.data.src.indexOf("undefined")<0){start=((t.data.src.lastIndexOf("/")<0)?t.data.src.lastIndexOf("\\"):t.data.src.lastIndexOf("/"))+1;data=t.data.src.slice(start);}else data="No image";default:data=t.data;};
return new String(data);};CCp.compareTo=function(cell){
return this.col.compareFunction(this.data,cell.data);};CCp.toString=function(){
return "Cell ["+this.row._id+"; "+this.col._id+"]";};CCp.getID=function(){var t=this;
return t.row.grid.getID("cell")+t.row._id+"_"+t.col._id;};CCp.getEditControl=function(){var t=this,h,o,v=t.getDataForEdit();if(t.isReadOnly||t.row.isReadOnly||t.col.isReadOnly||t.col.type=="Image"){t.state=1;
return t.getData();}else{switch(t.col.type){case "Date":h="<input id='cell' name='cell' type='text' style='width:100%;' value=\""+v+"\" maxlength='"+DATE_FORMAT.length+"' onblur='CodeThatGrids[\""+t.row.grid.name+"\"].curCell.setData(this.value)'>";break;case "Currency":case "Number":h="<input id='cell' name='cell' type='text' style='width:100%;' value=\""+v+"\" maxlength='10' onblur='CodeThatGrids[\""+t.row.grid.name+"\"].curCell.setData(this.value)'>";break;case "String":case "HTML":case "Email":case "URL":default:h="<textarea id='cell' name='cell' rows=1 cols=1 style='width:100%;height:100%' onblur='CodeThatGrids[\""+t.row.grid.name+"\"].curCell.setData(this.value);'>"+v+"</textarea>";break;};};
return h;};CCp.setState=function(state){var t=this,o=CT_fe("cell");rng.length=0;if(Def(o)&&t.state==2)t.setData(o.value);t.state=state;t.paint();};CCp.setMark=function(isMark){var t=this;if(Undef(isMark))isMark=!t.isMark;t.isMark=isMark;t.paint();};CCp.setStyle=function(param,value){var t=this;switch(param){case "b":if(Def(t.b))t.b="";else t.b="bold";break;case "i":if(Def(t.i))t.i="";else t.i="italic";break;case "u":if(Def(t.u))t.u="";else t.u="underline";break;case "alignment":t.alignment=value;break;};t.paint(0);};CCp.getStyle=function(){var t=this,s="";if(Def(t.b))s+="font-weight:bold;";if(Def(t.i))s+="font-style:italic;";if(Def(t.u))s+="text-decoration:underline;";if(Def(t.alignment))s+="text-align:"+t.alignment+";";if(Def(s))s="style='"+s+"'";
return s;};CCp.paint=function(p){var t=this,g=t.row.grid,o1=1,o2=1,o=CT_fe(t.getID()),rm=t.row.markClass,cm=t.col.markClass,rd=t.row.defaultClass,cd=t.col.defaultClass;if(Undef(p))p=1&&g.useRCID;if(p){o1=CT_fe(t.row.getID('row'));o2=CT_fe(t.col.getID('col'));};if(Undef(o)||Undef(o1)||Undef(o2))
return;o.style.fontWeight=t.b;o.style.fontStyle=t.i;o.style.textDecoration=t.u;o.style.textAlign=t.alignment;switch(t.state){case 0:CT_css(o,((t.isMark)?t.markClass:t.defaultClass));CT_HTML(o,t.getData());if(p){CT_css(o1,((t.isMark)?rm:rd));CT_css(o2,((t.isMark)?cm:cd));};break;case 1:CT_css(o,t.currClass);if(p){CT_css(o1,rm);CT_css(o2,cm);};CT_HTML(o,t.getData());break;case 2:CT_HTML(o,t.getEditControl());o=CT_fe("cell");if(Def(o)){if(ua.moz)o.setAttribute("autocomplete","off");o.value=t.getDataForEdit();o.focus();};break;};if(p)g.paintBar("sb");};};var isShift=0,isCtrl=0,CCG,CodeThatGrids=[],re="class=",rng=[],w=null,curId=0;var dfp={fontfamily:"Verdana, Arial",fontsize:"12px"},crp={borderwidth:"1",borderstyle:"outset",bordercolor:"#cccccc"},clp={borderstyle:"solid"},dbp={fontfamily:"Verdana, Arial",fontsize:"11px",backgroundcolor:"#D4D0C8"};function CT_fe(id){
return CodeThat.findElement(id);};function CT_reh(ev,h,o){CodeThat.regEventHandler(ev,h,o);};function CT_regEvents(name,pt){CT_reh('click',CT_onMouseEvent,CT_fe(name));CT_reh('dblclick',CT_onMouseEvent,CT_fe(name));CT_reh('keydown',CT_onKeyPress);CT_reh('selectstart',CT_onSelect,CT_fe(name));CT_reh('mousemove',CT_onMouseMove);CT_reh('mousedown',CT_onMouseEvent);CT_reh('mouseup',CT_onMouseEvent);CT_reh('dragend',CT_onDrag,CT_fe(name));CT_reh('dragover',CT_onDragOver,CT_fe(name));CT_reh('dragover',CT_onDragOver,CT_fe(pt));};function CT_onDrag(e){var src=(ua.moz)?e._e.target:e._e.srcElement;var parent,s=src.id,t=curId,si,ti;if(Undef(t)||Undef(s))
return;if(Undef(CCG)){var parent=CT_getParent(src);if(Undef(parent.id))
return;CCG=CodeThatGrids[parent.id];};if(Undef(CCG))
return;if(t.indexOf("col")>-1&&s.indexOf("col")>-1){t=t.replace(new RegExp(CCG.name),"").replace(/[^0-9]/ig,'');s=s.replace(new RegExp(CCG.name),"").replace(/[^0-9]/ig,'');si=CCG.cIdx.indexOf(s);ti=CCG.cIdx.indexOf(t);CCG.cIdx.remove(si);CCG.cIdx.insert(s,ti);};if(t.indexOf("row")>-1&&s.indexOf("row")>-1){t=t.replace(new RegExp(CCG.name),"").replace(/[^0-9]/ig,'');s=s.replace(new RegExp(CCG.name),"").replace(/[^0-9]/ig,'');si=CCG.rIdx.indexOf(s);ti=CCG.rIdx.indexOf(t);CCG.rIdx.remove(si);CCG.rIdx.insert(s,ti);CCG.vr.length=0;};if(t.indexOf("pt")>-1&&s.indexOf("row")>-1){s=s.replace(new RegExp(CCG.name),"").replace(/[^0-9]/ig,'');si=CCG.rIdx.indexOf(s);ti=(t.replace(new RegExp(CCG.name),"").replace(/[^0-9]/ig,'')-1)*CCG.amountPerPage;t=CCG.rIdx[ti];CCG.rIdx.remove(si);CCG.rIdx.insert(s,ti);CCG.vr.length=0;};curId="";CCG.paint();};function CT_onDragOver(e){var src=(ua.moz)?e._e.target:e._e.srcElement;curId=src.id;};function CT_onSelect(e){var src=(ua.moz)?e._e.target:e._e.srcElement;if(src.id!='cell')
return false;};function CT_onMouseMove(e){var src=(ua.moz)?e._e.target:e._e.srcElement;if(Undef(src.id)||Undef(CCG))
return;var name=src.id.replace(new RegExp(CCG.name),"").replace(/[^0-9_]/ig,""),r,r1,c,c1;if(Undef(name)||name.indexOf("_")==-1||rng.length<2)
return;r=name.slice(0,name.indexOf("_"));r1=rng[0];c=name.slice(name.indexOf("_")+1);c1=rng[1];r=CCG.rIdx.indexOf(r);r1=CCG.rIdx.indexOf(r1);c=CCG.cIdx.indexOf(c);c1=CCG.cIdx.indexOf(c1);CCG.msg="Selection: "+(1+Math.abs(r-r1))+"R x "+(1+Math.abs(c-c1))+"C";CCG.paintBar("sb");};function CT_onMouseEvent(e){isShift=e._e.shiftKey;isCtrl=e._e.ctrlKey;var src=(ua.moz)?e._e.target:e._e.srcElement;if(Undef(src.id)&&ua.moz)src=src.parentNode;var parent=CT_getParent(src);if(Undef(src.id)||Undef(parent.id)){rng.length=0;
return;}if(Def(CCG)&&CCG!=CodeThatGrids[parent.id]&&CCG.curCell)CCG.curCell.setState(1);CCG=CodeThatGrids[parent.id];if(Undef(CCG)){rng.length=0;
return;}var name=src.id.replace(new RegExp(CCG.name),'').replace(/[^0-9_]/ig,""),r=-1,c=-1,type=-1;if(Undef(name))
return;if(name.indexOf("_")>-1){r=name.slice(0,name.indexOf("_"));c=name.slice(name.indexOf("_")+1);type=0;}else{if(src.id.indexOf("col")>-1){c=name;type=1};if(src.id.indexOf("row")>-1){c=name;type=2};if(src.id.indexOf("title")>-1){c=name;type=4};};switch(type){case 0:e._o=CCG.cells[r][c];CCG.cells[r][c].callHandler(e);break;case 2:e._o=CCG.rows[c];CCG.rows[c].callHandler(e);break;case 1:e._o=CCG.cols[c];CCG.cols[c].callHandler(e);break;};switch(e._e.type){case "click":switch(type){case 0:break;case 1:case 2:CCG.setMarkRange(c,type);break;case 4:CCG.cols[c].setTitle();};break;case "dblclick":switch(type){case 0:CCG.setCurCell(CCG.cells[r][c]);CCG.cells[r][c].setState(2);break;case 1:CCG.cols[c].setWidth();break;case 2:CCG.rows[c].setHeight();break;};break;case "mousedown":if(type!=0)
return;CCG.setCurCell(CCG.cells[r][c]);if(CCG.cells[r][c].state!=2)rng=[r,c];break;case "mouseup":if(type!=0||rng.length<2){rng.length=0;
return;}CCG.setMarkRange(rng.concat([r,c]),3);CCG.msg="";CCG.paintBar("sb");rng.length=0;break;};};function CT_onKeyPress(e){if(Def(CCG)){CCG.onKeyPress(e);}};function CT_getParent(src){while(Def(src)&&Def(src.tagName)&&src.tagName.toLowerCase()!="div"&&src.tagName.toLowerCase()!="body"){src=((ua.ie)?src.parentElement:src.parentNode);};
return src;};{var a=Array.prototype;a.insert=function(e,i){var t=this,j;t[t.length]=e;if(i<t.length-1){for(j=t.length-1;j>i;j--)t[j]=t[j-1];t[i]=e;};};a.remove=function(i){var t=this,j;if(i<t.length-1)for(j=i;j<t.length-1;j++){t[j]=t[j*1+1];if(Def(t[j]._id))t[j]._id=j;};t.length--;};};function makeRE(text){var special=["\\","/",".","^","+","*","?","$","|","(",")","{","}"],i;for(i=0;i<special.length;i++)text=text.replace(new RegExp("\\"+special[i],"ig"),"\\"+special[i]);
return text;};function merge(aO){var i,j,o={};if(aO.constructor!=Array)aO=new Array(aO);for(i=0;i<aO.length;i++)for(j in aO[i])o[j]=aO[i][j];
return o;};