Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\qb\qb

Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\qb\qb_core.js

var g_object = null;
var cX =  0;
var cY = 0;
var link1=false;
var link2=false;
var qb_state=false;
//var sliding = false;
var qb_init=false;
var qb_startTime;
var qb_resultsOnClick=true;
var qb_colDrag = false;
var qb_begDrag = '';
var qb_zIndex = 100;
//var gQbFind = '';
var gSetFocus = '';

var gFirstResize = true;
function qb_initPage () {
    document.onmousedown = qb_pickIt;
    document.onmousemove = qb_dragIt;
    document.onmouseup   = qb_dropIt;
    document.onkeypress  = qb_keyHandler;
    document.onkeydown   = qb_keyHandler;
    window.onresize  = qb_Resize;
    if(gFirstResize){
		qb_Resize();
	    gFirstResize = !gFirstResize;
	}
    //init_qbRender();
}

return event.keyCode;
  }else{
    if (e.keyCode == 27) {
      qb_clearLink();
      return true;
    }
    if (e.keyCode == 13 && e.ctrlKey == true){
      qb_genSql();
      html_TabClick(html_GetElement('result_tab'),'queryResults_table');
      qb_getQueryResults();
      return true;
    }
    if (e.explicitOriginalTarget.id == 'QUERYTEXT'){
        if (e.ctrlKey == true && (e.charCode == 97 || e.charCode == 99)) {
          return e.keyCode;
        } else {
          return false;
        }
    }
      
    return  e.keyCode;
  }    
}

function qb_pickIt(evt) { 
   var evt = (evt) ? evt :((window.event) ? event : null);
   var target = evt.target ? evt.target : evt.srcElement;

if (gSetFocus != '') {
       qbSetFocus();
       return false;
    }

if (target.id == 'QUERYTEXT' || target.id == 'P1002_QUERY_DESC' || target.id == 'P1002_QUERY_NAME' ) {
    return true;
  }

if ( target.nodeName == 'scrollbar' ||
        target.nodeName == 'input' ) {
       return false;
    }

if ( target.id == 'h_slide') {
       qb_hPosition(evt);
       return false;
    }

var mousex = 0;
    var mousey = 0;
    if (evt.pageX || evt.pageY) { 
      mousex = evt.pageX - 3; 
      mousey = evt.pageY - 12;  
    } else if (evt.clientX || evt.clientY) { 
      mousex = evt.clientX + document.body.scrollLeft - 3;
      mousey = evt.clientY + document.body.scrollTop - 12;
    }

if (qb_colDrag) {
        var myobject = html_GetElement("dragimg");
        myobject.style.display="block";
        myobject.style.left = mousex;
        myobject.style.top = mousey;
		cX = mousex - myobject.offsetLeft;
		cY = mousey - myobject.offsetTop;
		qb_zIndex = qb_zIndex +1;
        myobject.style.zIndex = qb_zIndex;
        g_object = myobject;
        return false;
    }

function qb_dragIt(evt) {
    evt = (evt) ? evt : ((window.event) ? event : null);
    var target = evt.target ? evt.target : evt.srcElement;

if ( hFubar ) {
       qb_hNewPos(evt);
       return false;
    }

if (g_object) {
	  if (qb_colDrag) {
	    if ( mousex - cX > 0 )  {
		   g_object.style.left = mousex - cX + 'px';
	    } else {
	        g_object.style.left = '0px';
	    }
	    
	    if ( mousey - cY > 0 )  {
		    g_object.style.top = mousey - cY + 'px';
	    } else {
	        g_object.style.top = '0px';
	    }
		qb_redraw();
		return false;
      } else {
        var sUp = html_GetElement('qbTableHolder').scrollTop;
        var sLeft = html_GetElement('qbTableHolder').scrollLeft;
        mousex = mousex + sLeft; 
        mousey = mousey + sUp; 
	    if ( mousex - cX > 0 )  {
		   g_object.style.left = mousex - cX + 'px';
	    } else {
	        g_object.style.left = '0px';
	    }
	    
	    if ( mousey - cY > 0 )  {
		    g_object.style.top = mousey - cY + 'px';
	    } else {
	        g_object.style.top = '0px';
	    }
		qb_redraw();
		return false;
      }
	 }
	if (target.nodeName == 'INPUT' || target.id == 'QUERYTEXT') {
	  qb_redraw();
      return;
    } else {
      qb_redraw();
      return false;
    }
}

function qb_dropIt(evt) {
	
	evt = (evt) ? evt : ((window.event) ? event : null);
    var target = evt.target ? evt.target : evt.srcElement;

if ( hFubar ) {
       qb_hAction(evt); 
       return false;
    }
    
    if (qb_colDrag) {
      var mousex = 0;
      var mousey = 0;
      var sUp = html_GetElement('qbTableHolder').scrollTop;
      var sLeft = html_GetElement('qbTableHolder').scrollLeft;
      if (evt.pageX || evt.pageY) { 
        mousex = evt.pageX + sLeft; 
        mousey = evt.pageY + sUp;  
      } else if (evt.clientX || evt.clientY) { 
        mousex = evt.clientX + document.body.scrollLeft + sLeft;
        mousey = evt.clientY + document.body.scrollTop + sUp;
      }
        var obj = qb_getItem(mousex,mousey);
        if (obj) {
          qb_dragStop(obj.getAttributeNode("htmldb:col").nodeValue);
        } else {
          var img = html_GetElement("dragimg");
          img.style.display="none";
          qb_colDrag = false;
          qb_begDrag = '';
        }          
    }
    
	if (g_object) {	
		g_object = null;
	}
    return false;
}

var gTableCount = new Array();
 gTableCount[0] = new Array();

function q(pId){
  qb_addTable(pId)
}

function qb_tblCount(id) {
    if ( gTableCount[id] && gTableCount[id].length > 0) {
        return parseInt(gTableCount[id][0])+1;
    } else {
        return 0;
    }
}

function qb_redraw(){
    if ( qb_links && qb_links.length > 0 ) {
    	for (j=0;j<qb_links.length;j++) {
    	   qb_links[j].redim();
    	}
    }
}

function qb_postQUERY(sql) {
    qb_initPage();
    sql = escape(sql);
    var get = htmldb_getData(null,4500,'INTERNAL_APPLICATION_PROCESS=1504518033640244',0);
      get.add('P1002_QUERY',cwsqlid);
    var x = get.get('FULL');
      get = null;
}

function qb_escapeSQL(sql){
  var ret="";
  var c;
  for(var i=0;i<sql.length;i++){
    c = sql.charAt(i);
    if (c == "," )
       ret = ret + "^c"; 
    else if ( c == "+" )
       ret = ret + "^p"; 
    else if ( c == ":" )
       ret = ret + "^x"; 
  else
       ret = ret + c; 
  }
  return ret;
}

var qb_Open_Menu = '';

function qb_tablePopup(obj,evt,id){
    var x = html_GetElement(id+"_thold");
    var alias = qb_getAlias(x);
    var holder = html_GetElement(alias+"_tmenu");
      var tname = x.getAttribute("htmldb:name");
      var schema = html_GetElement("P1002_SCHEMA").value; 
      var get = new htmldb_Get(holder,4500,'TABLE',59);
      get.add('P59_TNAME',tname);
      get.add('P59_SCHEMA', schema);
      get.get('PPR','<htmldb:BOX_BODY>','</htmldb:BOX_BODY>');
      get = null;
      holder.closable=1;
      qb_zIndex = qb_zIndex + 1;
      holder.style.zIndex = qb_zIndex;
      holder.tableId=id;
      var evt = (evt) ? evt : ((window.event) ? event : null);
      var target_x = evt.pageX ? evt.pageX : evt.clientX ;
      var target_y = evt.pageY ? evt.pageY : evt.clientY ;
       dhtml_SingeMenuOpen(obj,holder,'Set',target_x,target_y);
    qb_redraw();
    return;
}

function qb_popup(id){
  var t = qb_cascadeUpUntil(html_GetElement(id),'TABLE');
      qb_zIndex = qb_zIndex + 1000;
      html_disableBase(qb_zIndex,"htmldbInvisDiv");
      t.closable='1';
      qb_zIndex = qb_zIndex+1;
      t.style.zIndex = qb_zIndex;
      t.style.display = "block";
      qb_Centerme(t);
	   html_GetElement('qbTableHolder').style.overflow = 'hidden';
	   html_GetElement('qbBottomHolder').style.overflow = 'hidden';
	   if(id == 'saveDialog'){html_GetElement('P1002_QUERY_NAME').focus()}
}

function qb_hidePopup(){
  var t = html_GetElement("R2310326687229087");
      t.style.display = "none";
      html_GetElement('qbTableHolder').className = 'd1';/* ff BUG https://bugzilla.mozilla.org/show_bug.cgi?id=223239 */
      html_GetElement('qbBottomHolder').className = 'd2';
	   html_GetElement('qbTableHolder').style.overflow = 'auto';
	   html_GetElement('qbBottomHolder').style.overflow = 'auto';
	   }

function qb_close(id){
  html_enableBase();
  var t = qb_cascadeUpClose(html_GetElement(id),'ANY');
  html_HideElement(t)
  toolTip_disable();
  html_GetElement("htmldbMessageHolder").innerHTML = '';
  html_GetElement('qbTableHolder').className = 'd1'; /* ff BUG https://bugzilla.mozilla.org/show_bug.cgi?id=223239 */
  html_GetElement('qbBottomHolder').className = 'd2';
  html_GetElement('qbTableHolder').style.overflow = 'auto';
  html_GetElement('qbBottomHolder').style.overflow = 'auto';
  }

function qb_Centerme(id){
     html_Centerme(id);
}

function qb_makeJoin(obj) {
    var x = obj.value;
    if ( x == 0 ) return;
    var zz = x.split('|');
    var newCount = qb_tblCount(zz[0]);
    getTable(zz[0],newCount);    
    
    var fdiv = html_CascadeUpTill(obj,'SPAN');  
    //var fdiv = html_CascadeUpTill(fdiv1,'DIV');  
    var fdiv = html_GetElement(fdiv.tableId+"_"+"thold");
    var ftab = qb_getAlias(fdiv);
    var fcol = zz[2];

var tdiv = html_GetElement(zz[0]+'_'+newCount+'_thold');
    var ttab = qb_getAlias(tdiv);
    var tcol = zz[1];

var l1 = html_GetElement(ftab+'.'+fcol); 
    var l2 = html_GetElement(ttab+'.'+tcol);

qb_linkTable(l1); 
    qb_linkTable(l2); 
    qb_genSql();
    var menu = html_GetElement(ftab +"_tmenu");
        html_HideElement(menu);
    var breaker = '';
}

function qb_newQuery() {
    var holder = html_GetElement("queryResults"); 
        holder.innerHTML="";
    var tableDiv = html_GetElement("qbTableHolder");   
    var foo = tableDiv.childNodes.length;
    for(i=0;i<=foo;i++){
      var id = tableDiv.childNodes[0].id;
      if (id) {
        qb_removeTable(id); 
      }
     }
     gTableCount = new Array;
     gTableCount[0] = new Array();
  
     html_GetElement("P1002_QUERY_NAME").value = '';
     html_GetElement("P1002_QUERY_DESC").value = '';
     html_GetElement("P1002_QUERY_ID").value = '';
     html_GetElement("P1002_OWNER").value = '';

var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=1504518033640244',0);
      get.add('P1002_QUERY_TYPE','P');
      get.add('P1002_QUERY_NAME', '');
      get.add('P1002_QUERY_DESC','');
      get.add('P1002_QUERY_ID','');
      get.add('P1002_OWNER','');
     var x = get.get('FULL');
      get = null;
   
 }

function qb_returnSQL(){
   var ret = html_GetElement("P1002_RETURN_INTO").value;
   opener.html_GetElement(ret).value =  html_GetElement("P1002_QUERY").value;
   window.close();
}

function qb_checkQuery(){
   if ( qb_resultsOnClick ) {
     qb_getQueryResults();
   }

}

function qb_dragStart(pCol) {
    qb_colDrag = true;
    qb_begDrag = pCol;
}

function qb_dragStop(pCol) {
  if (qb_begDrag != '' && pCol != '') {
    var sFrom = qb_begDrag.split('.');
    var sTo = pCol.split('.');
    if (sFrom[0] != sTo[0]) {
      var foo = new qb_link(qb_begDrag,pCol,"E");
      qb_validateLinks();
      qb_redraw();
      qb_genSql();
    }
  }

var img = html_GetElement("dragimg");
  img.style.display="none";

qb_colDrag = false;
  qb_begDrag = '';
}

function fPosY(obj)
{
	var curtop = 0;
	if (obj.offsetParent)
	{
		while (obj.offsetParent)
		{
			curtop += obj.offsetTop
			obj = obj.offsetParent;
            if (obj.className == 'qbData') {
                curtop -= obj.offsetParent.firstChild.scrollTop;
            }

}
	}
	else if (obj.y)
		curtop += obj.y;
	return curtop;
}

function qbSetFocus() {
    if (gSetFocus != '') {
     html_GetElement(gSetFocus).focus();
    }
}

var rowStyle      = new Array(10);
            var rowActive     = new Array(10);
            var rowStyleHover = new Array(10);

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de