var num=0;var pk=0;var f=0;var pf=-1;var f0=0;var rc=0;var i=0;var j=0;var kmax=1;var sa=0;var hP;function pdata(n){if(n==0)document.getElementById('btn').value="txt";if(n==1)document.getElementById('btn').value="csv";if(n==2)document.getElementById('btn').value="xls";if(n==3)document.getElementById('btn').value="pdf";snd();var dta=document.getElementById('dta').value;if(dta!="")document.forms['frm'].submit();}function dwn(){p=1;f=0;document.getElementById("d").value="";document.getElementById("dta").value="";document.getElementById('dis0').innerHTML=document.getElementById('t').rows.length;}window.onload=dwn;function selall(){var x = document.getElementById('t');var rc = x.rows.length;if(rc>0)sa=1;for(var i=0; i<rc; i++) {var cb = x.rows[i].cells[0].childNodes[0]; cb.checked=true;}}function selnone(){var x = document.getElementById('t');var rc = x.rows.length;sa=0;for(var i=0; i<rc; i++){var cb = x.rows[i].cells[0].childNodes[0]; cb.checked=false;}}function snd(){var dta="";for(i=0;i<document.getElementById('t').rows.length;i++){var cd=document.getElementById('t').rows[i].cells;for(j=1;j<cd.length-1;j++)dta += cd[j].innerHTML+",";dta+=cd[cd.length-1].innerHTML+'\n';}document.getElementById('dta').value=dta;}function del(n){var input_box=true;var x = document.getElementById('t');var rc = x.rows.length;var gd=0;kmax=1;var dc="";if(n==null){for(i=0;i<rc;i++)if(x.rows[i].cells[0].childNodes[0].checked){gd++;dc=dc+";"+i;}} else {gd=1;dc=n;}if(gd>0){var input_box=confirm("Are you sure you want to delete?");if(input_box==true){pf=-1;f=0;document.getElementById('d').value="";for(i=0;i<rc;i++){var cb = x.rows[i].cells[0].childNodes[0];if((cb!=null)&&cb.checked){x.deleteRow(i);rc--;i--;}}document.getElementById('dta').value=dc;document.getElementById('d').value="";f=0;document.getElementById('dis0').innerHTML=document.getElementById('t').rows.length;document.getElementById('d').focus();snd();populate();}}}function populate(){var dta=document.getElementById('dta').value;var x = document.getElementById('t');var rc = x.rows.length;for(i=0;i<rc;i++){x.deleteRow(i);i--;rc--;}kmax=1;var yy=dta.split('\n');var ky=yy.length;var y="";document.getElementById('dis0').innerHTML=ky-1;for(j=0;j<ky;j++){while (yy[j] != (yy[j] = yy[j].replace(/(,-)$/,""))); y=yy[j].split(',');if(y.length>kmax)kmax=y.length;}num=0;y="";for(j=0;j<ky-1;j++){var x = document.getElementById('t').insertRow(j);x.id=(num++);var ys=yy[j].split(/,/);var z = x.insertCell(0);var e0 = document.createElement('input');e0.type="checkbox";e0.id= "cb"+(num-1);z.appendChild(e0);z.style.backgroundColor="#fafafa";z.style.width="15px";for(i=1;i<kmax+1;i++){var z=x.insertCell(i);if(ys[i-1]=="")ys[i-1]="-";if(ys[i-1]!=null) z.innerHTML=ys[i-1]; else z.innerHTML="-";z.id="r"+(num-1);z.onclick=function(){click(this.id);};}}}function click(n){for(rc=0;rc<document.getElementById('t').rows.length;rc++)if(("r"+(document.getElementById('t').rows[rc].id))==n)break;var cd=document.getElementById('t').rows[rc].cells;s0="";for(j=1;j<cd.length;j++)s0 += cd[j].innerHTML+";";s0=s0.replace(/;$/,"");document.getElementById('d').value=s0;document.getElementById('d').focus();for(j=1;j<cd.length;j++)	document.getElementById('t').rows[rc].cells[j].style.backgroundColor="#a0a0a0";if(f){var cd=document.getElementById('t').rows[pf].cells;for(j=1;j<cd.length;j++)document.getElementById('t').rows[pf].cells[j].style.backgroundColor="#fafafa";}if(rc==pf){pf=-1;f=0;document.getElementById('d').value="";}else{pf=rc;f=1;}}function kp(e) {var keynum=0;var e=e||window.event;if(window.event)keynum = e.keyCode; else if(e.which)keynum = e.which;if((keynum==13)||((keynum==59)&&(pk==59))||((keynum==186)&&(pk==186))){f0=0;var kk=0;var y=document.getElementById('d').value;if((f==1)&&(y.length==0)){document.getElementById('t').deleteRow(rc);f=0;}else{if(y==";;"){keynum=0; document.getElementById('d').value="";}else{y=y.replace(/,/,";");y=y.replace(/;;$/,"");y=y.replace(/^;/,"");y=y.replace(/;$/,"");if(f){document.getElementById('t').deleteRow(rc);if(y.length>0){f0=1; var x=document.getElementById('t').insertRow(rc);}}else{if(y.length>0){f0=1;var x=document.getElementById('t').insertRow(document.getElementById('t').rows.length);}}if(f0){keynum=0;x.id=(num++);var ys=y.split(/;|,/);var k=ys.length;if(k!=kmax)kk=-1;if(k>kmax)kmax=k;var z = x.insertCell(0);var e0 = document.createElement('input');e0.type="checkbox";e0.id= "cb"+(num-1);z.appendChild(e0);z.style.backgroundColor="#fafafa";z.style.width="15px";for(i=1;i<kmax+1;i++){var z=x.insertCell(i);if(ys[i-1]=="")ys[i-1]="-";if(ys[i-1]!=null) z.innerHTML=ys[i-1]; else  z.innerHTML="-";z.id="r"+(num-1);z.onclick=function(){click(this.id);};}document.getElementById('dta').value=y;document.getElementById('dis0').innerHTML=document.getElementById('t').rows.length;f=0;pf=-1;}document.getElementById('d').value="";document.getElementById('d').focus();}}if(kk<0){snd();populate();}}pk=keynum;}