// This array holds all table data       |
// index      field info                 |
//   0        table logical name         |
//   1        table physical name        |
//   2        table comment              |
//   3        check                      |
//   4        company                    |
//   5        extender type              |
//   6        array of all fields        |
//      |~>                              |
//         1       field name            |
//         0       field description     |
//         2       field type            |
//         3       field len             |
//         4       field dec             |
//         5       extender type         |
//   7        array of all relation      |
//         0       Description           |
//         1       Linked Field          |
//         2       Linked Table          |
//         3       Linked Table Field    |
//         4       Join Type             |
//         5       Relation Type         |
//         6       extender type         |
//   8        array of all indexes       |
//         0       index expression      |
//         1       unique                |
//         2       extender type         |
//   9        external table             |
var allTables = new Array();

// This array holds all table data       |
// index      field info                 |
//   0        table logical name         |
//   1        table physical name        |
//   2        extender type              |
//   3        check                      |
//   4        company                    |
//   5        table date                 |
//   6        array of extender fields   |
//      0        field name              |
//      1        field type              |
//      2        field len               |
//      3        field dec               |
//      4        field comment           |
//      5        field check             |
//      6        field default           |
//      7        field not null          |
//      8        field key           |
//   7        array of extender relations|
//         0       Description           |
//         1       Linked Field          |
//         2       Linked Table          |
//         3       Linked Table Field    |
//         4       Join Type             |
//         5       Relation Type         |
//   8        array of extender indexes  |
//      0        expression              |
//      1        unique                  |
//   9        external table             |
//   10       server esterno             |
var extendedItems;
//var extendedTables=",";

var m_bUpdated;             //Lo stato della query: modificato o meno
var m_cAction="";
var associateServer=false;
var tempFilename = "";      //Il nome del file selezionato
var CSV_SEP = "#!$";
var selectedItem;
var m_cProgName="spadministration_table_extender";

function DoLoad(){
  GetTables(); //Richiede la lista delle tabelle al server e li salva nell'array "allTables"
  OpenExtenderXDC(); //Carica i dati dell'estensione

  for (var i=0; i<allTables.length; i++){
    DrawDictTablesRow(allTables[i][2], allTables[i][1], allTables[i][5]);
  }
  SelectDictionaryTable(QueryString('table'))
  m_bUpdated = false;
}

function OpenExtenderXDC(){
  var addedXDC = new JSURL("../servlet/SPXDCProxy?action=extender_data", true);
  addedXDC = addedXDC.Response();
  LoadExtenderTables(addedXDC);
}

function SaveExtenderXDC(admin) {
  if(admin){
    m_cAction="save_admin";
    associateServer=true;
  }
  else m_cAction="save";

  if(m_bUpdated || admin){
    SavingAlert(true);
    document.getElementById("FormSender").src="save_xdc.htm";
  }
}

function NotifySave(result) {
  switch(result) {
    case 'ok':
    case 'admin_ok':
      m_bUpdated=false;
      SavingAlert(false);
      break;
    case 'error':
      SavingAlert(false);
      alert("Error: unable to save file.");
      break;
    case 'admin_error':
      SavingAlert(false);
      alert("Error: unable to apply changes to database.");
      break;
    case 'admin_not_installed':
    case 'admin_generic_error':
      SavingAlert(false);
      alert("Error: please check log for more information.");
      break;
  }
}

function SavingAlert(show){
  document.getElementById("saving").style.display=(show?"block":"none");
  var leftPosition=(document.body.offsetWidth)?(document.body.offsetWidth-document.getElementById("saving").offsetWidth)/2:10;
  var topPosition=50;//(document.body.offsetHeight)?(document.body.offsetHeight-document.getElementById("saving").offsetHeight)/2:10;
  document.getElementById("saving").style.left=leftPosition;
  document.getElementById("saving").style.top=topPosition;
}

function GetTables(){
  var tables_prop = new JSURL("../servlet/SPXDCProxy?action=tables_prop", true);
  tables_prop = tables_prop.Response();

  //Se mancano le librerie sul server
  if (At("ACCESS DENIED", tables_prop)>0){
    alert("Access Denied.");
  }
  else if (At("ClassNotFoundException: SPXDCProxy", tables_prop)>0){
    alert("Installation incomplete: PortalStudio required to use SitePainter Extender.");
  } else {
    var l_oXdc = new TrsJavascript();
    l_oXdc.reset();
    l_oXdc.SetRow(0);
    l_oXdc.BuildProperties(tables_prop);
    var numTables = GetProperty(l_oXdc,'Rows','N');

    for(var i=0;i<numTables;i++){
      l_oXdc.SetRow(i);
      allTables[i] = new Array(GetProperty(l_oXdc,'lName','C'),
                               GetProperty(l_oXdc,'pName','C'),
                               GetProperty(l_oXdc,'comment','C'),
                               GetProperty(l_oXdc,'check','C'),
                               GetProperty(l_oXdc,'company','L'),
                               GetProperty(l_oXdc,'extender','C'),
                               null,null,null,
                               GetProperty(l_oXdc,'external','L'));
    }
    allTables.sort(TablesSortFunc);
  }
}

function DrawDictTablesRow(tDesc, tName, extending_table){
  var mytable = document.getElementById("dictTables");
  var newRow = mytable.insertRow(mytable.rows.length);
  //Table Description
  newCell = newRow.insertCell(newRow.cells.length);
  newCell.innerHTML = tDesc;
  newCell.width = "60%";
  if(extending_table) {
    newCell.className='extended';
  }
  //Table PName
  newCell = newRow.insertCell(newRow.cells.length);
  if (!tName) tName="";
  newCell.innerHTML = tName;
  newCell.style.borderLeft = "1 solid black";
  if(extending_table) {
    newCell.className='extended';
  }
}

function TablesSortFunc(a, b){
  var aa = a[1].toLowerCase();
  var bb = b[1].toLowerCase();
  if (aa > bb) return 1;
  if (aa < bb) return -1;
  return 0;
}

function SelectDictionaryTable(table){
  for (var i=0;i<allTables.length;i++){
    if(allTables[i][1]==table){
      o_dictTables.setItemSelected(o_dictTables.getItem(i), true);
    }
  }
}

function UpdateFields(){
  if (parseInt(o_dictTables.getSelectedIndexes())>-1){
    document.getElementById("lbl_fields").innerHTML = "Fields of " + "<span>" + allTables[parseInt(o_dictTables.getSelectedIndexes())][2] + "</span>";
    document.getElementById("lbl_indexes").innerHTML = "Indexes of " + "<span>" + allTables[parseInt(o_dictTables.getSelectedIndexes())][2] + "</span>";
    document.getElementById("lbl_relations").innerHTML = "Relations of " + "<span>" + allTables[parseInt(o_dictTables.getSelectedIndexes())][2] + "</span>";
    GetFieldsIndexesRelations(parseInt(o_dictTables.getSelectedIndexes()));
  }
}

function GetFieldsIndexesRelations(ofTable){
  FetchData(ofTable);
  var mytable = document.getElementById("dictFields");
  var numRows = mytable.rows.length;
  for(var i=0; i<numRows; i++){
    mytable.deleteRow(0);
  }

  for (var i=0; i<allTables[ofTable][6].length; i++){
    UpDownMove="";
    newRow = mytable.insertRow(mytable.rows.length);

    //Field Description
    newCell = newRow.insertCell(newRow.cells.length);
    newCell.innerHTML = allTables[ofTable][6][i][1];
    newCell.width = "55%";
    if(allTables[ofTable][6][i][5]=="C") {
      newCell.className='extended';
    }
    else if(allTables[ofTable][6][i][5]=="M") {
      newCell.style.color = "blue";
      newCell.style.fontWeight = "bold";
    }

    //Field Name
    newCell = newRow.insertCell(newRow.cells.length);
    newCell.innerHTML = allTables[ofTable][6][i][0];
    newCell.style.borderLeft = "1 solid black";
    if(allTables[ofTable][6][i][5]=="C") {
      newCell.className='extended';
    }
    if(allTables[ofTable][6][i][5]=="M") {
      newCell.style.color = "blue";
      newCell.style.fontWeight = "bold";
    }
  }

  mytable = document.getElementById("dictIndexes");
  numRows = mytable.rows.length;
  for (var i=0; i<numRows; i++){
    mytable.deleteRow(0);
  }

  for (var i=0; i<allTables[ofTable][8].length; i++){
    newRow = mytable.insertRow(mytable.rows.length);
    newCell = newRow.insertCell(newRow.cells.length);
    newCell.width = "75%";
    newCell.innerHTML = allTables[ofTable][8][i][0];
    if(allTables[ofTable][8][i][2]=="C") {
      newCell.className='extended';
    }
    if(allTables[ofTable][8][i][2]=="M") {
      newCell.style.color = "blue";
      newCell.style.fontWeight = "bold";
    }

    newCell = newRow.insertCell(newRow.cells.length);
    newCell.innerHTML = allTables[ofTable][8][i][1] ? "UNIQUE" : "";
    if(allTables[ofTable][8][i][2]=="C") {
      newCell.className='extended';
    }
    if(allTables[ofTable][8][i][2]=="M") {
      newCell.style.color = "blue";
      newCell.style.fontWeight = "bold";
    }
  }

  mytable = document.getElementById("dictRelations");
  numRows = mytable.rows.length;
  for (var i=0; i<numRows; i++){
    mytable.deleteRow(0);
  }

  for (var i=0; i<allTables[ofTable][7].length; i++){
    newRow = mytable.insertRow(mytable.rows.length);

    newCell = newRow.insertCell(newRow.cells.length);
    newCell.innerHTML = allTables[ofTable][7][i][0];
    if(allTables[ofTable][7][i][6]=="C") {
      newCell.className='extended';
    }
    if(allTables[ofTable][7][i][6]=="M") {
      newCell.style.color = "blue";
      newCell.style.fontWeight = "bold";
    }
  }
}

/* Carica le propriet� della tabella dal server se � la prima volta che viene selezionata */
function FetchData(ofTable){
  var response;

  if (ofTable>-1 && allTables[ofTable][6]==null){
    var oField;

    //Fields
    response = new JSURL("../servlet/SPXDCProxy?action=fields&table=" + allTables[ofTable][0], true);
    response = response.Response();

    oFields = response.split(CSV_SEP);
    allTables[ofTable][6] = new Array();

    if (oFields[0]=="* --- Visual Query Fields 1.0 ---*") {
      for (var i=1; i<oFields.length; i++){
        if(!Empty(oFields[i])){
          oField = oFields[i].split("|");
          allTables[ofTable][6][i-1] = new Array(oField[0],oField[2],oField[1],oField[3],oField[4],oField[5]);
        }
      }
    }
    else {
      allTables[ofTable][6][0] = new Array("Server Error","Server Error","","","","");
    }

    //Indexes
    response = new JSURL("../servlet/SPXDCProxy?action=indexes&table=" + allTables[ofTable][0], true);
    response = response.Response();

    oIndexes = response.split(CSV_SEP);
    allTables[ofTable][8] = new Array();
    allIndexes = allTables[ofTable][8];

    if (oIndexes[0]=="* --- Visual Query Indexes 1.0 ---*") {
      var unique;
      for (var i=1; i<oIndexes.length && Len(response)>0; i++){
        oIndex = oIndexes[i].split("|");
        unique = (Lower(Left(oIndex[0],6))=="unique" ? true : false);
        allIndexes[i-1] = new Array ((unique ? Substr(oIndex[0], 8) : oIndex[0]), unique, oIndex[1]);
      }
    }
    else {
      allIndexes[0] = new Array("Server Error","","");
    }

    //Relations
    response = new JSURL("../servlet/SPXDCProxy?action=relations&table=" + allTables[ofTable][0], true);
    response = response.Response();

    oRelations = response.split(CSV_SEP);
    allTables[ofTable][7] = new Array();
    allRelations = allTables[ofTable][7];

    if (oRelations[0]=="* --- Visual Query Relations 1.0 ---*") {
      for (var i=1; i<oRelations.length && Len(response)>0; i++){
        oRelation = oRelations[i].split("|");
        allRelations[i-1] = new Array (oRelation[0],oRelation[1],oRelation[2],oRelation[3],oRelation[4],oRelation[5],oRelation[6]);
      }
    }
    else {
      allRelations[0] = new Array("Server Error","","","","","","");
    }
  }
}

function MoveUpDownDictTables(){
  var keyCode = GetKeyCode((IsIE())?event:e);
  if (keyCode==38 || keyCode==40){
    var currentPos = parseInt(o_dictTables.getSelectedIndexes());
    moveOffset=0;
    if (keyCode==38){
      if (currentPos>0)
        moveOffset=-1; //UP
    }
    else if (keyCode==40){
      if (currentPos+1<document.getElementById("dictTables").rows.length)
        moveOffset=1; //Down
    }
    if (currentPos>-1 && moveOffset!=0)
      o_dictTables.setItemSelected(o_dictTables.getItem(currentPos+moveOffset), true);
  }
  else if (keyCode==35){ //End = 35
    o_dictTables.setItemSelected(o_dictTables.getItem(document.getElementById("dictTables").rows.length-1), true);
  }
  else if (keyCode==36){ //Home = 36
    o_dictTables.setItemSelected(o_dictTables.getItem(0), true);
  }
}

function MoveUpDownDictFields(){
  var keyCode = GetKeyCode((IsIE())?event:e);
  if (keyCode==38 || keyCode==40){
    var currentPos = parseInt(o_dictFields.getSelectedIndexes());
    moveOffset=0;
    if (keyCode==38){
      if (currentPos>0)
        moveOffset=-1; //UP
    }
    else if (keyCode==40){
      if (currentPos+1<document.getElementById("dictFields").rows.length)
        moveOffset=1; //Down
    }
    if (currentPos>-1 && moveOffset!=0)
      o_dictFields.setItemSelected(o_dictFields.getItem(currentPos+moveOffset), true);
  }
  else if (keyCode==35){ //End=35
    o_dictFields.setItemSelected(o_dictFields.getItem(document.getElementById("dictFields").rows.length-1), true);
  }
  else if (keyCode==36){ //Home=36
    o_dictFields.setItemSelected(o_dictFields.getItem(0), true);
  }
  else if (keyCode==13){
    EditField();
  }
}

function MoveUpDownDictIndexes(){
  var keyCode = GetKeyCode((IsIE())?event:e);
  if (keyCode==38 || keyCode==40){
    var currentPos = parseInt(o_dictIndexes.getSelectedIndexes());
    moveOffset=0;
    if (keyCode==38){
      if (currentPos>0)
        moveOffset=-1; //UP
    }
    else if (keyCode==40){
      if (currentPos+1<document.getElementById("dictIndexes").rows.length)
        moveOffset=1; //Down
    }
    if (currentPos>-1 && moveOffset!=0)
      o_dictIndexes.setItemSelected(o_dictIndexes.getItem(currentPos+moveOffset), true);
  }
  else if (keyCode==35){ //End=35
    o_dictIndexes.setItemSelected(o_dictIndexes.getItem(document.getElementById("dictIndexes").rows.length-1), true);
  }
  else if (keyCode==36){ //Home=36
    o_dictIndexes.setItemSelected(o_dictIndexes.getItem(0), true);
  }
  else if (keyCode==13){
    EditField();
  }
}

function MoveUpDownDictRelations(){
  var keyCode = GetKeyCode((IsIE())?event:e);
  if (keyCode==38 || keyCode==40){
    var currentPos = parseInt(o_dictRelations.getSelectedIndexes());
    moveOffset=0;
    if (keyCode==38){
      if (currentPos>0)
        moveOffset=-1; //UP
    }
    else if (keyCode==40){
      if (currentPos+1<document.getElementById("dictRelations").rows.length)
        moveOffset=1; //Down
    }
    if (currentPos>-1 && moveOffset!=0)
      o_dictRelations.setItemSelected(o_dictRelations.getItem(currentPos+moveOffset), true);
  }
  else if (keyCode==35){ //End=35
    o_dictRelations.setItemSelected(o_dictRelations.getItem(document.getElementById("dictRelations").rows.length-1), true);
  }
  else if (keyCode==36){ //Home=36
    o_dictRelations.setItemSelected(o_dictRelations.getItem(0), true);
  }
  else if (keyCode==13){
    EditField();
  }
}

function LoadExtenderTables(prop){
  var numTables, numFields, numIndexes, numRelations, idx;

  var l_oXdc = new TrsJavascript();
  l_oXdc.reset();
  l_oXdc.SetRow(0);
  var l_oFields = new TrsJavascript();
  l_oFields.reset();
  l_oFields.SetRow(0);
  var l_oIndexes = new TrsJavascript();
  l_oIndexes.reset();
  l_oIndexes.SetRow(0);
  var l_oRelations = new TrsJavascript();
  l_oRelations.reset();
  l_oRelations.SetRow(0);

  extendedItems = new Array();
  l_oXdc.BuildProperties(prop);
  numTables = GetProperty(l_oXdc,'Rows','N');

  for (var i=0; i<numTables; i++){
    l_oXdc.SetRow(i);
    extendedItems.push(new Array(GetProperty(l_oXdc,'lName','C'),
                                 GetProperty(l_oXdc,'pName','C'),
                                 GetProperty(l_oXdc,'extending_table','L'),
                                 GetProperty(l_oXdc,'check','C'),
                                 GetProperty(l_oXdc,'company','L'),
                                 GetProperty(l_oXdc,'modifyDate','C'),
                                 new Array(), new Array(), new Array(),
                                 GetProperty(l_oXdc,'external','L'),
                                 ""));

    //extendedTables+=GetProperty(l_oXdc,'lName','C')+",";

    l_oFields.BuildProperties(GetProperty(l_oXdc,'fields','C'));
    l_oFields.SetRow(0);
    numFields = GetProperty(l_oFields,'Rows','N');
    for (var j=0; j<numFields; j++){
      l_oFields.SetRow(j);
      extendedItems[i][6][j]=new Array(GetProperty(l_oFields,'name','C'),
                                       GetProperty(l_oFields,'type','C'),
                                       GetProperty(l_oFields,'len','C'),
                                       GetProperty(l_oFields,'dec','C'),
                                       GetProperty(l_oFields,'desc','C'),
                                       GetProperty(l_oFields,'check','C'),
                                       GetProperty(l_oFields,'defa','C'),
                                       GetProperty(l_oFields,'noNull','C'),
                                       GetProperty(l_oFields,'index','C'));
    }

    l_oIndexes.BuildProperties(GetProperty(l_oXdc,'indexes','C'));
    l_oIndexes.SetRow(0);
    numIndexes = GetProperty(l_oIndexes,'Rows','N');
    for (var j=0; j<numIndexes; j++){
      l_oIndexes.SetRow(j);
      extendedItems[i][8][j]=new Array(GetProperty(l_oIndexes,'expression','C'),
                                       GetProperty(l_oIndexes,'unique','L'));
    }

    l_oRelations.BuildProperties(GetProperty(l_oXdc,'relations','C'));
    l_oRelations.SetRow(0);
    numRelations = GetProperty(l_oRelations,'Rows','N');
    for (var j=0; j<numRelations; j++){
      l_oRelations.SetRow(j);

      extendedItems[i][7][j]=new Array(GetProperty(l_oRelations,'desc','C'),
                                       GetProperty(l_oRelations,'field','C'),
                                       GetProperty(l_oRelations,'table','C'),
                                       GetProperty(l_oRelations,'fKey','C'),
                                       GetProperty(l_oRelations,'type','C'));
    }
  }
  //alert(extendedItems)
}

function GetExtenderTablesAsProperties(){
  var l_oFields = new TrsJavascript();
  var l_oIndexes = new TrsJavascript();
  var l_oRelations = new TrsJavascript();
  var l_oXdc = new TrsJavascript();
  l_oXdc.reset();
  l_oXdc.SetRow(0);
  for (var i=0; i<extendedItems.length; i++){
    l_oXdc.setValue('lName', WtA(extendedItems[i][0],'C'));
    l_oXdc.setValue('modifyDate', WtA(extendedItems[i][5],'C'));
    if(extendedItems[i][2]==true){
      l_oXdc.setValue('pName', WtA(extendedItems[i][1],'C'));
      l_oXdc.setValue('check', WtA(extendedItems[i][3],'C'));
      l_oXdc.setValue('company', WtA(extendedItems[i][4],'L'));
      l_oXdc.setValue('external', WtA(extendedItems[i][9],'L'));
      l_oXdc.setValue('serverAssociated', WtA(extendedItems[i][10],'C'));
    }

    l_oFields.reset();
    l_oFields.SetRow(0);
    for (var j=0; j<extendedItems[i][6].length; j++){
      l_oFields.setValue('name', WtA(extendedItems[i][6][j][0],'C'));
      l_oFields.setValue('type', WtA(extendedItems[i][6][j][1],'C'));
      l_oFields.setValue('len', WtA(extendedItems[i][6][j][2],'N'));
      l_oFields.setValue('dec', WtA(extendedItems[i][6][j][3],'N'));
      l_oFields.setValue('desc', WtA(extendedItems[i][6][j][4],'C'));
      l_oFields.setValue('check', WtA(extendedItems[i][6][j][5],'C'));
      l_oFields.setValue('defa', WtA(extendedItems[i][6][j][6],'C'));
      l_oFields.setValue('noNull', WtA(CharToBool(extendedItems[i][6][j][7]),'L'));
      l_oFields.setValue('index', WtA(extendedItems[i][6][j][8],'N'));
      l_oFields.SetRow(j+1);
    }
    l_oXdc.setValue('fields', l_oFields.asString());

    l_oIndexes.reset();
    l_oIndexes.SetRow(0);
    for (var j=0; j<extendedItems[i][8].length; j++){
      l_oIndexes.setValue('expression', WtA(extendedItems[i][8][j][0],'C'));
      l_oIndexes.setValue('unique', WtA(extendedItems[i][8][j][1],'L'));
      l_oIndexes.SetRow(j+1);
    }
    l_oXdc.setValue('indexes', l_oIndexes.asString());

    l_oRelations.reset();
    l_oRelations.SetRow(0);
    for (var j=0; j<extendedItems[i][7].length; j++){
      l_oRelations.setValue('table', WtA(extendedItems[i][7][j][2],'C'));
      l_oRelations.setValue('type', WtA(extendedItems[i][7][j][4],'N'));
      l_oRelations.setValue('fKey', WtA(extendedItems[i][7][j][3],'C'));
      l_oRelations.setValue('field', WtA(extendedItems[i][7][j][1],'C'));
      l_oRelations.SetRow(j+1);
    }
    l_oXdc.setValue('relations', l_oRelations.asString());

    l_oXdc.SetRow(i+1);
  }
  return l_oXdc.asString();
}

function AddTable() {
  TableProperties("add");
}

function AddTableFrom(){
  AddFrom("table")
}

function AddFieldFrom(){
  var tblIdx = parseInt(o_dictTables.getSelectedIndexes()); //Indice della tabella selezionata
  if(tblIdx>-1) {
    var tableName = allTables[tblIdx][0];
    var eTblIdx=-1;
    var stop = false;
    for (var i=0; i<extendedItems.length && !stop; i++){
      if(extendedItems[i][0]==tableName) {
        eTblIdx = i;
        stop = true;
      }
    }
    AddFrom("field",eTblIdx, -1, tblIdx, -1);
  }
  else {
    alert("Select a table.");
  }

}

function AddFrom(action,etIdx,efIdx,tIdx,fIdx){
  var height = 290;
  var width = 430;

  windowLeft = (screen.width)?(screen.width-width)/2:100;
  windowTop = (screen.height)?(screen.height-height-(height/4))/2:100;
  var url = "table_from.htm?action="+action+(action=='field'?"&et="+etIdx+"&t="+tIdx:'');
  window.layerOpenForeground(url,"ExtenderAddFrom",'width=330,height=350',330,350,true,1);
  // window.open("table_from.htm?action="+action+(action=='field'?"&et="+etIdx+"&t="+tIdx:''),"table", "height="+height+",width="+width+",left="+windowLeft+",top="+windowTop);


}

function AddField() {
  var tblIdx = parseInt(o_dictTables.getSelectedIndexes()); //Indice della tabella selezionata
  if(tblIdx>-1) {
    var tableName = allTables[tblIdx][0];
    var eTblIdx=-1, eFldIdx=-1;
    var stop = false;

    for (var i=0; i<extendedItems.length && !stop; i++){
      if(extendedItems[i][0]==tableName) {
        eTblIdx = i;
        stop = true;
      }
    }
    FieldProperties("add", eTblIdx, -1, tblIdx, -1);
  }
  else {
    alert("Select a table.");
  }
}

function AddIndex() {
  var tblIdx = parseInt(o_dictTables.getSelectedIndexes()); //Indice della tabella selezionata
  if(tblIdx>-1) {
    var tableName = allTables[tblIdx][0];
    var eTblIdx=-1, eIdxIdx=-1;
    var stop = false;

    for (var i=0; i<extendedItems.length && !stop; i++){
      if(extendedItems[i][0]==tableName) {
        eTblIdx = i;
        stop = true;
      }
    }
    IndexProperties("add", eTblIdx, -1, tblIdx, -1);
  }
  else {
    alert("Select a table.");
  }
}

function AddRelation() {
  var tblIdx = parseInt(o_dictTables.getSelectedIndexes()); //Indice della tabella selezionata
  if(tblIdx>-1) {
    var tableName = allTables[tblIdx][0];
    var eTblIdx=-1, eIdxIdx=-1;
    var stop = false;

    for (var i=0; i<extendedItems.length && !stop; i++){
      if(extendedItems[i][0]==tableName) {
        eTblIdx = i;
        stop = true;
      }
    }
    RelationProperties("add", eTblIdx, -1, tblIdx, -1);
  }
  else {
    alert("Select a table.");
  }
}

function ItemAction(action) {
  var tblIdx = o_dictTables.getSelectedIndexes(); //Indice della tabella selezionata

  if(tblIdx!="" && selectedItem!=null) {
    tblIdx = parseInt(tblIdx);

    switch(selectedItem.id) {
      case "dictTables":
        var stop = false;
        var eTblIdx;

        if(allTables[tblIdx][5]=="C") {
          for (var i=0; i<extendedItems.length && !stop; i++){
            if(extendedItems[i][0]==allTables[tblIdx][0]) {
              eTblIdx=i;
              stop=true;
            }
          }
          if (action=="edit")
            TableProperties("edit", eTblIdx, tblIdx);
          else if (action=="delete") {
            if((window.WindowConfirm||window.confirm)("Are you sure you want to delete the selected extender table?")==1) {
              DeleteElement("table", eTblIdx, null, tblIdx, null);
            }
          }
        }
        else {
          alert("Select extender table.");
        }
        break;

      case "dictFields":
        var fldIdx = parseInt(o_dictFields.getSelectedIndexes()); //Indice del campo selezionato
        if(fldIdx>-1) {
          var tableName = allTables[tblIdx][0];
          var fieldName = allTables[tblIdx][6][fldIdx][0];
          var stop = false;
          var eTblIdx, eFldIdx;

          if(FieldIsExtender(tableName, fieldName)) {
            for (var i=0; i<extendedItems.length && !stop; i++){
              if(extendedItems[i][0]==tableName) {
                eTblIdx=i;
                for (var j=0; j<extendedItems[i][6].length && !stop; j++){
                  if(extendedItems[i][6][j][0]==fieldName) {
                    eFldIdx=j;
                    stop=true;
                  }
                }
              }
            }
            if (action=="edit")
              FieldProperties("edit", eTblIdx, eFldIdx, tblIdx, fldIdx);
            else if (action=="delete") {
              if((window.WindowConfirm||window.confirm)("Are you sure you want to delete the selected extender field?")==1) {
                DeleteElement("field", eTblIdx, eFldIdx, tblIdx, fldIdx);
              }
            }
          }
          else {
            alert("Select extender field.");
          }
        }
        else {
          alert("Select a field.");
        }
        break;

      case "dictIndexes":
        var indexIdx = parseInt(o_dictIndexes.getSelectedIndexes()); //Indice del indice selezionato
        if(indexIdx>-1) {
          var tableName = allTables[tblIdx][0];
          var indexExp = allTables[tblIdx][8][indexIdx][0];
          var stop = false;
          var eTblIdx, eIndexIdx;

          if(IndexIsExtender(tableName, indexExp)) {
            for (var i=0; i<extendedItems.length && !stop; i++){
              if(extendedItems[i][0]==tableName) {
                eTblIdx=i;
                for (var j=0; j<extendedItems[i][8].length && !stop; j++){
                  if(extendedItems[i][8][j][0]==indexExp) {
                    eIndexIdx=j;
                    stop=true;
                  }
                }
              }
            }
            if (action=="edit")
              IndexProperties("edit", eTblIdx, eIndexIdx, tblIdx, indexIdx);
            else if (action=="delete") {
              if((window.WindowConfirm||window.confirm)("Are you sure you want to delete the selected extender index?")==1) {
                DeleteElement("index", eTblIdx, eIndexIdx, tblIdx, indexIdx);
              }
            }
          }
          else {
            alert("Select extender index.");
          }
        }
        else {
          alert("Select an index.");
        }
        break;

      case "dictRelations":
        var relationIdx = parseInt(o_dictRelations.getSelectedIndexes()); //Indice della relazione selezionata
        if(relationIdx>-1) {
          var tableName = allTables[tblIdx][0];
          var relDesc = allTables[tblIdx][7][relationIdx][0];
          var stop = false;
          var eTblIdx, eRelationIdx;

          if(RelationIsExtender(tableName, relDesc)) {
            for (var i=0; i<extendedItems.length && !stop; i++){
              if(extendedItems[i][0]==tableName) {
                eTblIdx=i;
                for (var j=0; j<extendedItems[i][7].length && !stop; j++){
                  if(extendedItems[i][7][j][0]==relDesc) {
                    eRelationIdx=j;
                    stop=true;
                  }
                }
              }
            }
            if (action=="edit")
              RelationProperties("edit", eTblIdx, eRelationIdx, tblIdx, relationIdx);
            else if (action=="delete") {
              if((window.WindowConfirm||window.confirm)("Are you sure you want to delete the selected extender relation?")==1) {
                DeleteElement("relation", eTblIdx, eRelationIdx, tblIdx, relationIdx);
              }
            }
          }
          else {
            alert("Select extender relation.");
          }
        }
        else {
          alert("Select a relation.");
        }
        break;
    }
  }
  else if (tblIdx==""){
    alert("Select a table.");
  }
  else if (selectedItem==null){
    alert("Select an item.");
  }
}

function TableProperties(action, etIdx, tIdx) {
  var height = 150;
  var width = 430;

  windowLeft = (screen.width)?(screen.width-width)/2:100;
  windowTop = (screen.height)?(screen.height-height-(height/4))/2:100;

  if (IsNetscape() || IsMozilla()) {
    width+=5; //Per Netscape e Mozilla, il width e height sono leggermente diversi
    height+=4;
  }
  var url = "table_prop.htm?action="+action+"&et="+etIdx+"&t="+tIdx;
  window.layerOpenForeground(url,"ExtenderTableProperties",'width=300,height=350',300,350,true,1);
  // win = window.open("table_prop.htm?action="+action+"&et="+etIdx+"&t="+tIdx, "table", "height="+height+",width="+width+",left="+windowLeft+",top="+windowTop);
}

function FieldProperties(action, etIdx, efIdx, tIdx, fIdx) {
  var height = 242;
  var width = 480;

  windowLeft = (screen.width)?(screen.width-width)/2:100;
  windowTop = (screen.height)?(screen.height-height-(height/4))/2:100;

  if (IsNetscape() || IsMozilla()) {
    width+=5; //Per Netscape e Mozilla, il width e height sono leggermente diversi
    height+=4;
  }
  var url = "field_prop.htm?action="+action+"&et="+etIdx+"&ef="+efIdx+"&t="+tIdx+"&f="+fIdx;
  window.layerOpenForeground(url,"ExtenderFieldProperties",'width=300,height=300',300,300,true,1);
  // win = window.open("field_prop.htm?action="+action+"&et="+etIdx+"&ef="+efIdx+"&t="+tIdx+"&f="+fIdx, "field", "height="+height+",width="+width+",left="+windowLeft+",top="+windowTop);
}

function IndexProperties(action, etIdx, efIdx, tIdx, fIdx) {
  var height = 282;
  var width = 480;

  windowLeft = (screen.width)?(screen.width-width)/2:100;
  windowTop = (screen.height)?(screen.height-height-(height/4))/2:100;

  if (IsNetscape() || IsMozilla()) {
    width+=5; //Per Netscape e Mozilla, il width e height sono leggermente diversi
    height+=4;
  }
  var url = "index_prop.htm?action="+action+"&et="+etIdx+"&ef="+efIdx+"&t="+tIdx+"&f="+fIdx;
  window.layerOpenForeground(url,"ExtenderIndexProperties",'width=300,height=350',300,350,true,1);
  // win = window.open("index_prop.htm?action="+action+"&et="+etIdx+"&ef="+efIdx+"&t="+tIdx+"&f="+fIdx, "index", "height="+height+",width="+width+",left="+windowLeft+",top="+windowTop);
}

function RelationProperties(action, etIdx, erIdx, tIdx, rIdx) {
  var height = 282;
  var width = 480;

  windowLeft = (screen.width)?(screen.width-width)/2:100;
  windowTop = (screen.height)?(screen.height-height-(height/4))/2:100;

  if (IsNetscape() || IsMozilla()) {
    width+=5; //Per Netscape e Mozilla, il width e height sono leggermente diversi
    height+=4;
  }
  var url = "relation_prop.htm?action="+action+"&et="+etIdx+"&er="+erIdx+"&t="+tIdx+"&r="+rIdx;
  window.layerOpenForeground(url,"ExtenderRelationProperties",'width=300,height=350',300,350,true,1);
  // win = window.open("relation_prop.htm?action="+action+"&et="+etIdx+"&er="+erIdx+"&t="+tIdx+"&r="+rIdx, "relation", "height="+height+",width="+width+",left="+windowLeft+",top="+windowTop);
}

function UpdateTable(table, action, et, t) {
  if(action=="edit") {
    extendedItems[et][0]=table[0];
    extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server
    extendedItems[et][1]=table[1];
    extendedItems[et][3]=table[3];
    extendedItems[et][4]=table[2];
    extendedItems[et][9]=table[4];

    allTables[t][0]=table[0];
    allTables[t][1]=table[1];
    allTables[t][3]=table[3];
    allTables[t][4]=table[2];
    allTables[t][9]=table[4];
  }
  else if(action=="add"){
    et=AddEmptyExtentionTable();
    t=allTables.length;

    extendedItems[et][0]=table[0];
    extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server
    extendedItems[et][1]=table[1];
    extendedItems[et][3]=table[3];
    extendedItems[et][4]=table[2];
    extendedItems[et][9]=table[4];
    extendedItems[et][10]=table[5]||"";
    extendedItems[et][2]=true;

    allTables[t]=new Array(table[0],table[1],table[0],table[3],table[2],"C", null,null,null,table[4]);
    DrawDictTablesRow(table[0], table[1], true);
  }
  m_bUpdated=true;
}

function UpdateField(field, action, et, ef, t, f) {
  if (action=="edit") {
    extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server

    for(var i=0;i<extendedItems[et][6][ef].length;i++) {
      extendedItems[et][6][ef][i]=field[i];
    }
    allTables[t][6][f][0]=field[0]; //Aggiorno il nome del campo nella tabella allTables
    allTables[t][6][f][1]=field[4]; //Aggiorno il nome del campo nella tabella allTables
  }
  else if (action=="add"){
    if (et==-1) {
      et=AddEmptyExtentionTable();
    }

    ef=extendedItems[et][6].length;
    extendedItems[et][0]=allTables[t][0];
    extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server
    extendedItems[et][6][ef]=new Array();

    for(var i=0;i<field.length;i++) {
      extendedItems[et][6][ef][i]=field[i];
    }
    f=allTables[t][6].length;
    allTables[t][6][f]=new Array(field[0], field[4], field[1], field[2], field[3], "C");
  }

  UpdateFields();
  m_bUpdated=true;
}

function MergeFields(fields, et, ef, t, f){
  if (et==-1) {
    et=AddEmptyExtentionTable();
  }
  ef=extendedItems[et][6].length;
  extendedItems[et][0]=allTables[t][0];
  extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server
  for (var i=0; i<ef; i++){
    var idx=-1;
    for (var j=0; j<fields.length && idx==-1; j++){
      if (Lower(extendedItems[et][6][i][0])==Lower(fields[j][0])){
        idx=j;
      }
    }
    if (idx!=-1){
      if (FieldIsExtender(extendedItems[et][0], extendedItems[et][6][i][0])){ // se il campo � esteso faccio il merge altrimenti non si pu� modificare e quindi tengo quello che c'� gi�
        for (var j=1; j<fields[idx].length; j++){
          if (!Empty(fields[idx][j])){
            extendedItems[et][6][i][j]=fields[idx][j]
          }
        }
        var fldIdx=-1
        for (var j=0; j<allTables[et][6].length && fldIdx==-1; j++){
          if (extendedItems[et][6][j][0]==fieldName)
            fldIdx=j;
        }
        allTables[t][6][fldx]=new Array(extendedItems[et][6][i][0], extendedItems[et][6][i][4], extendedItems[et][6][i][1], extendedItems[et][6][i][2], extendedItems[et][6][i][3], "C");
      }
      fields.splice(idx,1)
    }
  }
  for (var i=0; i<fields.length; i++){
    extendedItems[et][6][ef+i]=new Array();
    for(var j=0;j<fields[i].length;j++) {
      extendedItems[et][6][ef+i][j]=fields[i][j];
    }
    f=allTables[t][6].length;
    allTables[t][6][f]=new Array(fields[i][0], fields[i][4], fields[i][1], fields[i][2], fields[i][3], "C");
  }
  UpdateFields();
  m_bUpdated=true;
}

function ReplaceFields(fields, et, ef, t, f){
  if (et==-1) {
    et=AddEmptyExtentionTable();
  }
  if(allTables[t][5]=="C") { // tabella estesa
    extendedItems[et][6]=new Array()
    allTables[t][6]=new Array();
    extendedItems[et][0]=allTables[t][0];
    extendedItems[et][5]=DateTimeToChar(DateTime())

    for (var i=0; i<fields.length; i++){
      extendedItems[et][6][i]=new Array();
      for (var j=0; j<fields[i].length; j++){
        extendedItems[et][6][i][j]=fields[i][j];
      }
      allTables[t][6][i]=new Array(fields[i][0], fields[i][4], fields[i][1], fields[i][2], fields[i][3], "C");
    }
    UpdateFields();
    m_bUpdated=true;
  }
  else {
    var tableName=allTables[t][0];
    //elimino tutti i campi estesi
    var idx=0, eFldIdx=-1;
    while (idx<allTables[t][6].length){
      var fieldName=allTables[t][6][idx][0];
      if(FieldIsExtender(tableName, fieldName)) {
        for (var i=0; i<extendedItems[et][6].length && eFldIdx==-1; i++){
          if (extendedItems[et][6][i][0]==fieldName)
            eFldIdx=i;
        }
        allTables[t][6].splice(idx,1);
        if (eFldIdx>-1)
          extendedItems[et][6].splice(eFldIdx,1);
      }
      else idx++;
    }
    // posso fare il merge
    MergeFields(fields, et, ef, t, f)
  }


}

function UpdateIndex(action, exp, unique, et, eidx, t, idx) {
  if (action=="edit") {
    extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server
    allTables[t][8][idx][0]=extendedItems[et][8][eidx][0]=exp;
    allTables[t][8][idx][1]=extendedItems[et][8][eidx][1]=unique;
  }
  else if (action=="add"){
    if (et==-1) {
      et=AddEmptyExtentionTable();
    }

    idx=allTables[t][8].length;
    allTables[t][8][idx]=new Array();

    eidx=extendedItems[et][8].length;
    extendedItems[et][0]=allTables[t][0];
    extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server
    extendedItems[et][8][eidx]=new Array();

    allTables[t][8][idx][0]=extendedItems[et][8][eidx][0]=exp;
    allTables[t][8][idx][1]=extendedItems[et][8][eidx][1]=unique;
    allTables[t][8][idx][2]="C";
  }
  UpdateFields();
  m_bUpdated=true;
}

function UpdateRelation(action, linkedTable, linkedTableDesc, fieldString, fkFieldString, fieldDescString, et, er, t, r) {
  if (action=="edit") {
    extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server
    allTables[t][7][r][0]=extendedItems[et][7][er][0]=linkedTableDesc+"("+fieldDescString+")";
    allTables[t][7][r][1]=extendedItems[et][7][er][1]=fieldString;
    allTables[t][7][r][2]=extendedItems[et][7][er][2]=linkedTable;
    allTables[t][7][r][3]=extendedItems[et][7][er][3]=fkFieldString;
    allTables[t][7][r][4]=extendedItems[et][7][er][4]=1;
  }
  else if (action=="add"){
    if (et==-1) {
      et=AddEmptyExtentionTable();
    }

    r=allTables[t][7].length;
    allTables[t][7][r]=new Array();

    er=extendedItems[et][7].length;
    extendedItems[et][0]=allTables[t][0];
    extendedItems[et][5]=DateTimeToChar(DateTime()); //Bisogna mettere qui la data del server
    extendedItems[et][7][er]=new Array();

    allTables[t][7][r][0]=extendedItems[et][7][er][0]=linkedTableDesc+"("+fieldDescString+")";
    allTables[t][7][r][1]=extendedItems[et][7][er][1]=fieldString;
    allTables[t][7][r][2]=extendedItems[et][7][er][2]=linkedTable;
    allTables[t][7][r][3]=extendedItems[et][7][er][3]=fkFieldString;
    allTables[t][7][r][4]=extendedItems[et][7][er][4]=1;
    allTables[t][7][r][6]="C";
  }
  UpdateFields();
  m_bUpdated=true;
}

function AddEmptyExtentionTable(){
  var et=extendedItems.length;
  extendedItems[et]=new Array();
  extendedItems[et][6]=new Array();
  extendedItems[et][7]=new Array();
  extendedItems[et][8]=new Array();
  return et;
}

function DeleteElement(type, et, eElm, t, elm) {
  switch(type) {
    case "table":
      allTables.splice(t,1);
      extendedItems.splice(et,1);
      break;
    case "field":
      allTables[t][6].splice(elm,1);
      extendedItems[et][6].splice(eElm,1);
      break;
    case "index":
      allTables[t][8].splice(elm,1);
      extendedItems[et][8].splice(eElm,1);
      break;
    case "relation":
      allTables[t][7].splice(elm,1);
      extendedItems[et][7].splice(eElm,1);
      break;
  }
  if(eElm==null){
    document.getElementById("dictTables").deleteRow(t);
    if(t>0) o_dictTables.setItemSelected(o_dictTables.getItem(t-1), true);
  }
  else {
    if(extendedItems[et][6].length==0 && extendedItems[et][8].length==0 && extendedItems[et][7].length==0) {
      extendedItems.splice(et, 1);
    }
  }
  UpdateFields();
  m_bUpdated=true;
}

function FieldIsExtender(t,f) {
  var result=false;
  for (var i=0; i<extendedItems.length && !result; i++){
    if(extendedItems[i][0]==t) {
      for (var j=0; j<extendedItems[i][6].length && !result; j++){
        if(extendedItems[i][6][j][0]==f) {
          result=true;
        }
      }
    }
  }
  return result;
}
function IndexIsExtender(t,i) {
  var result=false;
  for (var k=0; k<extendedItems.length && !result; k++){
    if(extendedItems[k][0]==t) {
      for (var j=0; j<extendedItems[k][8].length && !result; j++){
        if(extendedItems[k][8][j][0]==i) {
          result=true;
        }
      }
    }
  }
  return result;
}
function RelationIsExtender(t,r) {
  var result=false;
  for (var i=0; i<extendedItems.length && !result; i++){
    if(extendedItems[i][0]==t) {
      for (var j=0; j<extendedItems[i][7].length && !result; j++){
        if(extendedItems[i][7][j][0]==r) {
          result=true;
        }
      }
    }
  }
  return result;
}

function UnSelectOthers(obj) {
  selectedItem = obj;

  switch(obj.id) {
    case "dictFields":
      if(o_dictIndexes.getSelectedIndexes()!="")
        o_dictIndexes.setItemSelected(o_dictIndexes.getItem(o_dictIndexes.getSelectedIndexes()), false);
      if(o_dictRelations.getSelectedIndexes()!="")
        o_dictRelations.setItemSelected(o_dictRelations.getItem(o_dictRelations.getSelectedIndexes()), false);
      break;
    case "dictIndexes":
      if(o_dictFields.getSelectedIndexes()!="")
        o_dictFields.setItemSelected(o_dictFields.getItem(o_dictFields.getSelectedIndexes()), false);
      if(o_dictRelations.getSelectedIndexes()!="")
        o_dictRelations.setItemSelected(o_dictRelations.getItem(o_dictRelations.getSelectedIndexes()), false);
      break;
    case "dictRelations":
      if(o_dictFields.getSelectedIndexes()!="")
        o_dictFields.setItemSelected(o_dictFields.getItem(o_dictFields.getSelectedIndexes()), false);
      if(o_dictIndexes.getSelectedIndexes()!="")
        o_dictIndexes.setItemSelected(o_dictIndexes.getItem(o_dictIndexes.getSelectedIndexes()), false);
      break;
  }
}

function selectTable(index){
  var td=document.getElementById("dictTables").getElementsByTagName('tr')[index].getElementsByTagName('td')[0];
  o_dictTables.click({target:td})
}