// Script to test the security/access rules of your Mendix application. It shows all the data that the user has access to.
// If the user is allowed to modify the data, the background is green. White for read-only.
function addCellText(p_document,p_row,p_text,p_head,p_readonly)
{
var l_cell=p_row.insertCell();
l_cell.appendChild(p_document.createTextNode(p_text));
l_cell.style.border='solid 1px #000';
if(p_head) l_cell.style.backgroundColor='#ddd';
if(!p_readonly) l_cell.style.backgroundColor='#00ff00';
}


var l_window=window.open();  
var l_map=mx.meta.getMap();
var l_document=l_window.document;
var l_parent=l_document.body;
var l_select=l_document.createElement("select");
var l_option;
var l_options=[];
var l_key;
var l_cnt;
l_parent.appendChild(l_select);
l_option=document.createElement("option");
l_option.value="";
l_option.text="";
l_select.add(l_option);
for(l_key in l_map) l_options.push(l_key);
l_options.sort();

for(l_cnt=0;l_cnt<l_options.length;l_cnt++){
l_option=document.createElement("option");
l_option.value=l_options[l_cnt];
l_option.text=l_options[l_cnt];
l_select.add(l_option);
}
l_select.onchange=function()
{
  var l_name=this.value;
mx.data.get({
 xpath:"//"+this.value,
 filter: {
  offset: 0,
  amount: 500
 },
 callback:function(p_data)
 {
  var l_tab=l_document.getElementById("tab");
  var l_cols;
  var l_key;
  var l_row;
  var l_cell
  var l_value;
  var l_readonly;
  var l_rc;
  var l_colName;
     
  if(l_tab) l_tab.parentNode.removeChild(l_tab);

  if(p_data.length>0) {
   l_att=mx.meta.getEntity(l_name).getAttributes();
     l_tab=l_document.createElement("table");
     l_tab.id='tab';
     l_tab.style.borderCollapse="collapse";
     l_parent.appendChild(l_tab);
     l_row=l_tab.insertRow();
     l_cols=p_data[0].jsonData.attributes;
   addCellText(l_document,l_row,"guid",true,true);
   var collie="";
   for(l_key=0;l_key<l_att.length;l_key++){
      if (l_key==0){ collie = '"'+l_att[l_key]+'"'; }
      else { collie = collie+'~"'+l_att[l_key]+'"'; }
     }
     console.log(collie);
     for(l_rc=0;l_rc<p_data.length;l_rc++){
      l_row=l_tab.insertRow();
      var row="";
      l_cols=p_data[l_rc].jsonData.attributes;
       console.log(p_data[l_rc].jsonData.guid );

       for(l_key=0;l_key<l_att.length;l_key++){
      l_colName=l_att[l_key];
      l_value="";  
      if(l_colName in l_cols){
        if("value" in l_cols[l_colName]){
         l_value=l_cols[l_colName].value;
        }
        l_readonly=("readonly" in l_cols[l_colName] && l_cols[l_colName].readonly);
      }
      addCellText(l_document,l_row,l_value,false,l_readonly);
         
      if (l_key==0){ row = '"'+l_value+'"'; }
      else { row = row+'~"'+l_value+'"'; }
     
     
       }
   
        console.log(row);
     
     }
  }
  else {
   var l_div=l_document.createElement('div');
   l_div.id='tab';
   l_div.appendChild(l_document.createTextNode('No data found'));
  }
 }
}
)
}