function c3showsub(u,e) { 
//alert("test");
             if (e) {
                 el=e;
             } else {     
                 el=event.srcElement;
             }
 
            el=html_CascadeUpTill(el,"TD");
            er=html_CascadeUpTill(el,"TR"); 
            et=html_CascadeUpTill(el,"TABLE");
			try {
              if (er.expanded&&er.expanded=="Y") {
                  c3subcollapse(er.nextSibling);
              }
            } catch(e) {
            }

              rn=er.rowIndex;
              rn++;
              nr=et.insertRow(rn);
              nc=nr.insertCell(0);
              nc.style.borderBottom="2px groove gray";
              nc.typ="subarea";
              nc.colSpan=100;
              ht=100;
//              ht="expression(c3ifrmsize(this,'h'));";
//               ht="";
              wt=et.offsetWidth;
//              wt="";
              er.expanded="Y";
              nc.innerHTML="<span id=\"spcol\" onclick=\"c3subcollapse(this.parentNode.parentNode,'')\" style=\"cursor:pointer;\"><font size=\"-2\">Loading</font></span><br><iframe id=i"+rn+"  name=i"+rn+" frameborder=0 style=\"width:"+wt+"; height:"+ht+";\" onreadystatechange=\"c3subchkstate(this,&quot;&quot;,&quot;HTML&quot;);\" onmouseover=\"c3subchkstate(this,&quot;&quot;,&quot;HTML&quot;);\" src=\""+u+"\" ></iframe><br>&nbsp";
 //            nh=document.createElement("HR");
 //            nc.appendChild(nh);
          }
 
          function c3showsub2(u,e) {        
             if (e) {
                 el=e;
             } else {                    
                 el=event.srcElement;
             }
alert(el.outerHTML);
 
            el=html_CascadeUpTill(el,"TD");            
            er=html_CascadeUpTill(el,"TR");            
            et=html_CascadeUpTill(el,"TABLE");
            
              if (er.expanded&&er.expanded=="Y") {
               try {
                  c3subcollapse(er.nextSibling);
               } catch (e) {
               }
              }
              
              rn=er.rowIndex;
              rn++;
              nr=et.insertRow(rn);
              nc=nr.insertCell(0);
             nc.style.borderBottom="2px groove gray";
              nc.typ="subarea";
              nc.colSpan=100;
              ht=100;
//              ht="expression(c3ifrmsize(this,'h'));";
//               ht="";
              wt=et.offsetWidth;
//              wt="";
              er.expanded="Y";
//              nc.innerHTML="<span id=\"spcol\" onclick=\"c3subcollapse(this.parentNode.parentNode,'')\" style=\"cursor:pointer;\"><font size=\"-2\">Loading</font></span><br><iframe id=i"+rn+"  name=i"+rn+" frameborder=0 style=\"width:"+wt+"; height:"+ht+";\" onreadystatechange=\"c3subchkstate(this,&quot;&quot;,&quot;HTML&quot;);\" onmouseover=\"c3subchkstate(this,&quot;&quot;,&quot;HTML&quot;);\" src=\""+u+"\" ></iframe><br>&nbsp";

        var get = new htmldb_Get(null,html_GetElement('pFlowId').value,'APPLICATION_PROCESS=GETURL',0);
        get.add('C3_TEMP_URL',u)

        gReturn = get.get();
        nc.innerHTML = "gReturn"+gReturn;
        nc.style.height=100;
            
 //            nh=document.createElement("HR");
 //            nc.appendChild(nh);
          }
 
          function c3subcollapse(ep,rid) {
           try {
              ep.previousSibling.expanded="N";
//              ep.removeNode(true);
           } catch(e) {
           }  
             ep.parentNode.removeChild(ep);
             
             
          }
  
          function testit(v) {
         alert(v);
        }

		
        function c3ifrmsize(iframeName) {

            var agentstr = navigator.userAgent.toLowerCase();
            var isIE      = false;
            docwt         = "100%";

            
            			
            curwt = document.body.clientWidth-20;

            if (agentstr.indexOf("msie") != -1) {
                isIE = true;
            }

             o = document.getElementById(iframeName);

             try {
               if (o&&o.contentWindow) {
                    c3stat=document.getElementById("C3ibeiStoreCustomStatus");
                    if (!c3stat) {
                     c3stat=document.createElement("DIV");
//                     document.body.appendChild(c3stat);
                     c3stat.ID="C3ibeiStoreCustomStatus";
                    }
//                  try {
                        docht = o.contentWindow.document.body.scrollHeight;
                        docwt = o.contentWindow.document.body.scrollWidth;
//                  } catch (e) {
//                      docht = 0;
//                      docwt = "100%";
//                  }

                    if (isIE) {

                    o.contentWindow.document.body.onresize="c3ifrmsize(\"" + iframeName + "\")";
                    o.contentWindow.document.body.onscroll="c3ifrmsize(\"" + iframeName + "\")";

                     window.status="stat:"+o.readyState+" "+docht+" w:"+docwt+" cw:"+curwt;
                      if(o.readyState=="complete") {  
                        c3stat.innerHTML="";
                        c3stat.style.display="none";
                      } else if(o.readyState=="loading") {  
                        o.style.width=curwt;
					  }

                    }

                    if (docht<10) {
                     if (c3stat.innerHTML=="") {
                        o.style.width=curwt;
                        c3stat.innerHTML="<img src='/i/htmldb/icons/wait.gif'/>";
                        c3stat.style.display="";
                     }
                    }

                    if (docht>=50) { 
                       o.style.height = "auto";
                        try {
                            o.style.height=docht;
                            o.style.width=docwt;

//                            if (curwt<docwt) {
//                                o.style.width=docwt;
//                            }

                        } catch(e) {
                            o.style.height=800;
                        }
                        c3stat.innerHTML="";                            

                    } 

                } else {
                   o.style.width=curwt;
				}

                } catch(e) {
                   c3stat.innerHTML="error:"+e.description;
                }                                

            if (!isIE) {
                window.setTimeout("c3ifrmsize(\"" + iframeName + "\")", 1500);
            } else  if(o.readyState!="complete") {  
                window.setTimeout("c3ifrmsize(\"" + iframeName + "\")", 1500);
            }

        }
 

         function c3subchkstate(o,rid,t) {
            try {                        
                if (!o.readyState){
                    o.previousSibling.previousSibling.innerHTML="<font size='-2'><< Collapse</font>";

                     try {
                         o.style.height=o.contentWindow.document.body.scrollHeight;
                         o.style.width=o.contentWindow.document.body.scrollWidth;
                     } catch(e) {
                        o.onreadystatechange="";
                        o.onmouseover="";
                         o.style.height=60;
                         o.style.width=80;
                    }
                 }
            } catch(e) {
             }

            try {
                window.status=o.readyState+" "+o.style.height;
                 if (o.readyState=="complete"){
                     o.previousSibling.previousSibling.innerHTML="<font size='-2'><< Collapse</font>";
                     try {
//                        if (o.style.height=="") {
//                            o.setExpression("height","this.contentWindow.document.body.scrollHeight + (this.contentWindow.document.body.offsetHeight - this.contentWindow.document.body.clientHeight)");
//                             o.setExpression("width","this.contentWindow.document.body.scrollWidth + (this.contentWindow.document.body.offsetWidth - this.contentWindow.document.body.clientWidth)");
//                        }
                     } catch(e) {
                        o.onreadystatechange="";
                        o.onmouseover="";
                         o.style.height=600;
                         o.style.width=800;
                     }
                    
                     try {
                         o.style.height=o.contentWindow.document.body.scrollHeight+17;
                         o.style.width=o.contentWindow.document.body.scrollWidth+17;
                     } catch(e) {
                        o.onreadystatechange="";
                        o.onmouseover="";
                         o.style.height=600;
                         o.style.width=800;
                    }
                 }

            } catch(e) {
                window.status="test";
             }

         }

        function c3_CascadeUpTill(pThis,pToTag,pToClass,pCount){
            try {
                var node = html_GetElement(pThis);
                if (node) {
                    var tPar = node.parentNode;
                    while(tPar.nodeName != pToTag){
                            tPar = tPar.parentNode;
                    }
                    return tPar;
                } else {
                    return null;
                }
            } catch (e) {
                return null;
            }
        }

         function c3HideDiv(d) {
          nd=document.getElementById(d);
          if (nd) {
           nd.removeNode(true);
          }
         }

         function c3NewDiv(d,h) {
          c3HideDiv(d);
          nd=document.createElement("div");
          document.body.appendChild(nd);
        if (h=="Y") {
            nd.style.display="none";
        }
          nd.id=d;
          nd.style.position="absolute";
          nd.style.top=200;
          nd.style.left=200;
          nd.style.backgroundColor="#ffffff";
          nd.style.border="3px ridge #dddddd";
          return nd;
         }
         
         function c3reload() {
          window.location.reload();
         }
         
         function c3getxml(v) {
             nx=document.createElement("XML");
             document.body.appendChild(nx);
             nx.async=false;
             nx.load("C3_HTMLDB_UTILS.GET_XML?val="+v);
             v2=nx.selectSingleNode("ROWSET/ROW/VAL").text;
             
             return(v2);
         }
 
         function c3onload() {
//            if (document.body) {
//                 document.body.oncontextmenu=c3oncontextmenu;    
//            }
              document.body.onscroll=c3freezeheader;
              c3SetDrillDowns;
         }
         
         function c3footerscript() {
		 
         }
         
        function c3oncontextmenu() {
if (1==2) {
el=event.srcElement;
//alert(el.tagName);
d=c3_CascadeUpTill(el,"TABLE");

//alert(d.outerHTML);

            nd=c3NewDiv("c3admindiv");
            nd.style.left=event.clientX;
            nd.style.top=event.clientY;
             
            nb=document.createElement("<DIV/>");
            nd.appendChild(nb);
            nb.style.backgroundColor="ddddee";
            nb.innerHTML=document.title;
     
            nb=document.createElement("<HR style=\"width:100;\" />");
            nd.appendChild(nb);

            nb=document.createElement("DIV");
            nd.appendChild(nb);
            nb.className="c3linkcell";
            nb.innerHTML="Refresh";
            nb.onclick=c3reload;

            nb=document.createElement("DIV");
             nd.appendChild(nb);
            nb.innerHTML="Edit";
            nb.className="c3linkcell";
            nb.onclick=c3editpage;
 
            nb=document.createElement("<HR style=\"width:100;\"/>");
            nd.appendChild(nb);

             nb=document.createElement("<DIV class=\"c3linkcell\" onclick=\"c3HideDiv('c3admindiv')\"/>");
            nd.appendChild(nb);
             nb.innerHTML="Cancel";



 
//             event.returnValue =false;
         }
         }
         
         function c3editpage() {
             ps=document.getElementById("pFlowStepId");
             window.open("C3_HTMLDB_UTILS.EDITPAGE?X_PAGE_ID="+ps.value);
         }
 
      function c3numberonly() {
       kv=event.keyCode;
        if ((kv>=48&&kv<=57)||(kv>=96&&kv<=105)||kv==190||kv==110||kv==9||kv==8||kv==39||kv==37) {      
        } else {
          event.returnValue=false;
        }
      }

	function fnAlphaNumeric(e,el,m){
		d=document.getElementById("d1");

		var kv=e.keyCode? e.keyCode : e.charCode
		var sh=e.shiftKey

		if (el.value.length>=m&&kv!=8) {
          event.returnValue=false;
		}		  

		if (sh) {
			return false;
		}

		if ((kv>=48&&kv<=57)||(kv>=96&&kv<=105)||(kv>=65&&kv<=90)||kv==8) {      
		} else {
          event.returnValue=false;
		}

	}

	function c3tonumber(el) {
          retval="";
	  v=el.value;
          nv="";
          for (i=0;i<v.length;i++) {
	   nv=v.substr(i,1);
	   if (!isNaN(nv)||nv==".") {
		retval=retval+nv;     
	   }
          }

	   if (isNaN(retval)) {
		retval="";
 		alert("not a valid number"); 
	   }

       el.value=retval;
	}
 
    function c3CreateForm(i,h) {
        nd=c3NewDiv("c3div"+i,h);      
        
        ni=document.createElement("<IFRAME frameborder=\"0\" id=\"c3ifrm"+i+"save\" name=\"c3ifrm"+i+"save\" ></iframe>");
        nd.appendChild(ni);
        nb=document.createElement("<BUTTON onclick=c3HideDiv(\"c3div"+i+"\")></BUTTON>");
        nb.innerHTML="OK";
        nd.appendChild(nb);

        nf=document.createElement("FORM");
        nf.id="c3form"+i;
        nf.target="c3ifrm"+i+"save";
        nd.appendChild(nf);          
           c3CreateFormItem(nf,"INPUT","SUBMIT","","Save");
        return (nf);
    }

    function c3CreateFormItem(nf,i,t,n,v) {
         ni=document.createElement(i);
        if (t!="") {
			ni.type=t;
		}
        if (n!="") {
            ni.name=n;
        }
        ni.value=v;
        nf.appendChild(ni);
    }      

	function c3posturl(purl) {
		try {
			p = new XMLHttpRequest();
		}catch(e){
			p = new ActiveXObject("Msxml2.XMLHTTP");
		}

		try {
			var startTime = new Date();

			p.open("POST", purl, false);

			if(p) {
				p.setRequestHeader('Content-Type','application/x-www-form-urlencoded');
				p.send(this.queryString == null ? this.params : this.queryString );
				return p;
			} 
		}catch(e){
			return false;
		}
	 }
 
// to use copy any report template and add id="c3FreezeHeader" to the last <TABLE> tag in the before rows section;



	function c3freezeheader() {
        freezeCol();
		nt=document.getElementById("c3FreezeHeader");
	    if (nt) {
  try {
            ncs=nt.getElementsByTagName("TH");                
            nc=ncs(0);
            nr=c3_CascadeUpTill(nc,"TR");
            nt=c3_CascadeUpTill(nc,"TABLE");

           lf=0;
           tp=0;

			
            cls=nt.className;      

			ep=nr;
			while (ep.offsetParent) {
				lf=lf+ep.offsetParent.offsetLeft;
				tp=tp+ep.offsetParent.offsetTop;
				ep=ep.offsetParent;
			}

			ntp=document.body.scrollTop-tp;

			if (ntp<=0) {
				divheader=document.getElementById("divheader");
				if (divheader) {
					divheader.removeNode(true);
				}
			} else	{
				divheader=document.getElementById("divheader");

				if (!divheader) {
					divheader=document.createElement("DIV");
					document.body.appendChild(divheader);
					divheader.id="divheader";
					divheader.style.position="absolute";

                    divheader.innerHTML="<TABLE id=\"hdrtbl\" style=\"table-layout:fixed;\" class="+cls+">"+nr.outerHTML+"</TABLE>";

                    nnt=document.getElementById("hdrtbl");
                    nnr=nnt.rows(0);
	                for (i=0;i<nnr.cells.length;i++) {
                        nc=nr.cells(i);
                        nnc=nnr.cells(i);
						nnc.width=nc.offsetWidth;
						nnc.style.width=nc.offsetWidth;
	                }
        
					divheader.style.left=lf;

				}

				divheader.style.top=document.body.scrollTop;

			}

        } catch(e) {}

	    }
	}

    function c3SetDrillDowns() {
    	arec = document.getElementsByTagName("A");
		
        window.status=arec.length;
    }

    function buildFreezeCols() {
        divColumns=document.getElementById("divColumns");

        if (!divColumns) {
        ctmp="";
        wtmp="";
        fc=0;
        nt=document.getElementById("c3FreezeHeader");
        if (nt&&nt.cols&&nt.cols>0) {

            fc=parseInt(nt.cols);
            lf=0;
            tp=0;
            ncs=nt.getElementsByTagName("TH");                
            nc=ncs(0);
            nr=c3_CascadeUpTill(nc,"TR");
            nt=c3_CascadeUpTill(nc,"TABLE");

            cls=nt.className;

            ep=nr;

            while (ep.offsetParent) {
                lf=lf+ep.offsetParent.offsetLeft;
                tp=tp+ep.offsetParent.offsetTop;
                ep=ep.offsetParent;
            }

            ntp=document.body.scrollTop-tp;
            nlf=document.body.scrollLeft-lf;



            for (r=0;r<nt.rows.length;r++) {
                tdtext="";
                cr=nt.rows(r);

                if (cr.cells.length>2) {
                         
                    wtmp=0;
                    for (c=0;c<fc;c++) {
                        cd=cr.cells(c);
                        if (cd) {
                            tdtext=tdtext+cd.outerHTML;
                            wtmp=wtmp+nc.offsetWidth;
                        }
                    }
                    tht=cr.offsetHeight;
                    ctmp=ctmp+"<tr style=\"height:"+tht+"\">"+tdtext+"</tr>";
                }
            }

            divColumns=document.createElement("DIV");
            divColumns.style.backgroundColor="ffffff";
            document.body.appendChild(divColumns);
            divColumns.id="divColumns";
            divColumns.style.position="absolute";
            divColumns.style.display="none";
            divColumns.style.width=wtmp;
            divColumns.innerHTML="<TABLE id=\"coltbl\" style=\"table-layout:fixed; border-right:1px solid grey;\" class="+cls+" cellspacing=\"0\">"+ctmp+"</TABLE>";
            nnt=document.getElementById("coltbl");

            ncs=nnt.getElementsByTagName("TH");
                
            nnc=ncs(0);

            nnr=c3_CascadeUpTill(nnc,"TR");
            cr=c3_CascadeUpTill(nc,"TR");

            for (c=0;c<fc;c++) {
                nnc=nnr.cells(c);
                cd=cr.cells(c);
                nnc.width=cd.offsetWidth;
                nnc.style.width=cd.offsetWidth;
            }

            ccs=nt.cells;

            divColumns.style.top=tp;
            divColumns.style.left=0;

        }
       }
    }


    function freezeCol() {

        ctmp="";
        wtmp="";
        fc=0;
        nt=document.getElementById("c3FreezeHeader");
        if (nt&&nt.cols&&nt.cols>0) {
            buildFreezeCols();

            ep=nt;

            while (ep.offsetParent) {
                lf=lf+ep.offsetParent.offsetLeft;
                tp=tp+ep.offsetParent.offsetTop;
                ep=ep.offsetParent;
            }

            ntp=document.body.scrollTop-tp;
            nlf=document.body.scrollLeft-lf;

            if (nlf<=0) {
                divColumns=document.getElementById("divColumns");
                if (divColumns) {
                    divColumns.style.display="none";
                }
            } else    {
                divColumns=document.getElementById("divColumns");
                if (divColumns) {
                    divColumns.style.display="";
                    divColumns.style.left=document.body.scrollLeft;
                }
            }
        }
    }