var qb_tables = new Array(); 
 var qb_conditions = new Array(); 
  
function qb_saveQuery(pType){
  var s_title = html_GetElement("P1002_QUERY_NAME").value;
  if (isEmpty("P1002_QUERY_NAME")) {
	  html_GetElement("P1002_QUERY_NAME").value = '';
	  html_GetElement("P1002_QUERY_NAME").focus();
	  return;
  }
  // test to be sure name is unique
  var sId = html_GetElement("P1002_QUERY_ID").value;
  if (sId == null || sId == '') {
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=266120031373725934',0);    
    get.add('P1002_QUERY_NAME',s_title);
    var isUniq = get.get();
    if (isUniq != '0') {
      html_GetElement("htmldbMessageHolder").innerHTML = isUniq;
      return;
    }
  }
  qb_tables = new Array(); 
  qb_conditions = new Array(); 
  var lRet = qb_getQueryAttribs(pType);
  if (lRet) {
    qb_hidePopup();
    html_GetElement("htmldbMessageHolder").innerHTML = '';
    html_enableBase();
//    html_GetElement("P1002_DIS_NAME").innerHTML = html_GetElement("P1002_QUERY_NAME").value;
    html_TabClick(html_GetElement("SavedSql_tab"),'SavedSQLHolder');
//    gQbFind = html_GetElement("P1002_QUERY_NAME").value;
    qb_getSavedSQL();
  }
}
    
function qb_saveTable(oid,cnt,top,left,tname) {
	qb_tables.push(this);
	this.object_id = oid;
	this.count = cnt;
	this.top = top;
	this.left = left;
	this.table = tname;
}    

function qb_saveConditions(c,a,fv,fp,o,st,so,g,con) {
    qb_conditions.push(this);
    this.col = c;
    this.alias = a;
    this.func_value = fv;
    this.func_paren = fp;
    this.out = o;
    this.sort_type = st;
    this.sort_order = so;
    this.group_by = g;
    this.condition = con;
 }    


function qb_getQueryAttribs(pType) {
  var tableDiv = document.getElementById("qbTableHolder");   
  var t = tableDiv.getElementsByTagName('DIV');
  for(var i=0;i<t.length;i++){
        if ( t[i].id.substring(t[i].id.length-6) == '_thold') {
        	var oid = t[i].getAttribute("htmldb:id");
        	var cnt = t[i].getAttribute("htmldb:cnt");
        	var tname = t[i].getAttribute("htmldb:name");
        	var top = t[i].parentNode.style.top;
        	var left = t[i].parentNode.style.left;
        	var x = new qb_saveTable(oid,cnt,top,left,tname);
        }
  }
  if (qb_tables.length == 0) { 
    var pMessage = '<div class="htmldbNotification"><ul><li>';
    pMessage = pMessage+l_noSave;
    pMessage = pMessage+'</li></ul></div>';
    html_GetElement("htmldbMessageHolder").innerHTML = pMessage;
  	return false;
  }
  var d=document.getElementsByTagName('INPUT');
  for(var i=0;i<d.length;i++){
        if ( d[i].out) {
          var col = d[i].col;
          var a = html_GetElement(d[i].col+"_alias");
          var alias = a.value;
          var f = html_GetElement(d[i].col+"_fun");
          var func_value = f.value == '' ? null : f.value;
          var func_paren = f.paren; 
          var o = html_GetElement(d[i].col+"_out");
          var out = o.checked;
          var st = html_GetElement(d[i].col+"_st");
          var sort_type = st.value;
          var so = html_GetElement(d[i].col+"_so");
          var sort_order = so.value == '' ? null : so.value;
  		  var g = html_GetElement(d[i].col+"_grp"); 
  	      var group_by = g.checked;
  		  var con = html_GetElement(d[i].col+"_con");       
          var condition = con.value == '' ? null : con.value;
          var y = new qb_saveConditions(col,alias,func_value,func_paren,out,sort_type,sort_order,group_by,condition);
        }  
  }

   var sql   = html_GetElement("P1002_QUERY").value;
  var s_title = html_GetElement("P1002_QUERY_NAME").value;
  //var s_type  = html_GetElement("P1002_QUERY_TYPE").value;
  var s_desc  = html_GetElement("P1002_QUERY_DESC").value;
  var s_id   = html_GetElement("P1002_QUERY_ID").value;
  var s_tabs = qb_tables;
  var s_cons = qb_conditions;
  var s_lnks = qb_links;
  
  var get = new htmldb_Get(null,4500,'SAVE_QUERY',1002,null,'wwv_flow.accept');
    
  for(var i=0;i<s_tabs.length;i++){
        get.addParam('f01',s_tabs[i].object_id);
        get.addParam('f02',s_tabs[i].count);
        get.addParam('f03',s_tabs[i].top);
        get.addParam('f04',s_tabs[i].left);
        get.addParam('f05',s_tabs[i].table);
  }
  
  for(var i=0;i<s_cons.length;i++){
    get.addParam('f06',s_cons[i].col);
    get.addParam('f07',s_cons[i].alias);
    get.addParam('f08',s_cons[i].func_value);
    get.addParam('f09',s_cons[i].func_paren);
    get.addParam('f10',s_cons[i].out);
    get.addParam('f11',s_cons[i].sort_type);
    get.addParam('f12',s_cons[i].sort_order);
    get.addParam('f13',s_cons[i].group_by);
    get.addParam('f14',s_cons[i].condition);
  }
  
  for(var i=0;i<s_lnks.length;i++){
    get.addParam('f15',s_lnks[i].field1.id);
    get.addParam('f16',s_lnks[i].field2.id);
    get.addParam('f17',s_lnks[i].condition);
  }

    get.addParam('f18', html_GetElement('P1002_SCHEMA').value);
    get.addParam('f19', html_GetElement('P1002_QUERY_NAME').value);
    //get.addParam('f20', html_GetElement('P1002_QUERY_TYPE').value);
    get.addParam('f21', html_GetElement('P1002_QUERY_DESC').value);
    if (pType == 'SAVE')
      get.addParam('f22', html_GetElement('P1002_QUERY_ID').value);
    get.addParam('f23', html_GetElement('P1002_QUERY').value);

  cDebug(get.url());
  var q = get.get('FULL');
   get = null;
  cDebug(q);
  if ( q.indexOf('Foo') == -1) {
    html_GetElement("P1002_QUERY_ID").value = q;
    html_GetElement("P1002_OWNER").value = fUser;
  }
  return true;
}