var request;
var objJSON;
var id_mongo;
const xhr = new XMLHttpRequest();
// URL zgony z Państwa serwisem 
var url = "http://orion.fis.agh.edu.pl/~n2nazwisko/bd01/";


// Lista rekordow w bazie
function _list() {    
   var url_list = url + "book.php?action=read" ;
   xhr.open("GET", url_list, true);   
   xhr.responseType = 'html';
   xhr.addEventListener("load", e => {
      if (xhr.status == 200)    {
		 res = xhr.response ;
		 document.getElementById('data').innerHTML = '';
         document.getElementById('result').innerHTML = res;
      }
   })
   xhr.send(null);
}

// Wstawianie rekordow do bazy
function _ins_form() {
   var form1 = "<form name='add'><table>" ;
   form1    += "<tr><td>ISBN</td><td><input type='text' id='isbn' placeholder='isbn' ></input></td></tr>";
   form1    += "<tr><td>Tytul</td><td><input type='text' id='tytul' placeholder='tytul' ></input></td></tr>";
   form1    += "<tr><td>Autor</td><td><input type='text' id='autor' placeholder='autor' ></input></td></tr>";  
   form1    += "<tr><td>Rok wydania</td><td><input type='text' id='rok_wydania' placeholder='rok_wydania' ></input></td></tr>";
   form1    += "<tr><td>Wydawnictwo</td><td><input type='text' id='wydawnictwo' placeholder='wydawnictwo' ></input></td></tr>";
   form1    += "<tr><td>Cena</td><td><input type='text' id='cena' placeholder='cena' ></input></td></tr>";    
   form1    += "<tr><td></td><td><input type='button' value='wyslij' onclick='_insert(this.form)' ></input></td></tr>";
   form1    += "</table></form>";
   document.getElementById('data').innerHTML = form1;
   document.getElementById('result').innerHTML = ''; 
}

function _insert(form)  {
  var isbn         = document.getElementById('isbn').value ;    
  var tytul        = document.getElementById('tytul').value ; 
  var autor        = document.getElementById('autor').value ; 
  var rok_wydania  = document.getElementById('rok_wydania').value ;    
  var wydawnictwo  = document.getElementById('wydawnictwo').value ; 
  var cena         = document.getElementById('cena').value ;  
  var url_insert   = url + "book.php?action=insert" ;
  var data = encodeURI("isbn="+isbn + "&tytul="+tytul + "&autor="+autor + "&rok_wydania="+rok_wydania + "&wydawnictwo="+wydawnictwo + "&cena="+cena) ;
 
  xhr.open("POST", url_insert, true);
  xhr.responseType = 'html';
  xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
  xhr.addEventListener("load", e => {
    if ( xhr.status == 200 )  {
         res = xhr.response;
		 document.getElementById('data').innerHTML = '';
         document.getElementById('result').innerHTML = res;
    }
  })
  xhr.send(data); 
}

// Usuwanie rekordow z bazy danych
function _del_list() {    
   var url_action = url + "book.php?action=delete" ;
   xhr.open("GET", url_action, true);   
   xhr.responseType = 'html';
   xhr.addEventListener("load", e => {
      if (xhr.status == 200)    {
		  res = xhr.response ;
		  document.getElementById('data').innerHTML = '';
          document.getElementById('result').innerHTML = res;
      }
   })
   xhr.send(null);
}

function _delete(form) {
   var url_action = url + "book.php?action=delete" ;	
   var rec = form.del.selectedIndex;
   var id = document.getElementsByTagName('option')[rec].value;   
   var data = encodeURI("record="+id);
   xhr.open("POST", url_action, true);
   xhr.responseType = 'html';
   xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");   
   xhr.addEventListener( "load", e => {
      if (xhr.status  == 200 )    {
		  res = xhr.response ;
		  document.getElementById('data').innerHTML = '';
          document.getElementById('result').innerHTML = JSON.stringify(xhr.response);
      }
   }) 
   xhr.send(data);
}

// Poprawa rekordow w bazie danych
function _upd_list() { 
   var url_action = url + "book.php?action=update" ;
   xhr.open("GET", url_action, true);   
   xhr.responseType = 'html';
   xhr.addEventListener("load", e => {
      if (xhr.status == 200)    {
		  res = xhr.response ;
		  document.getElementById('data').innerHTML = '';
          document.getElementById('result').innerHTML = res;
      }
   })
   xhr.send(null);
  }

function _upd_form(form) {
   var url_action = url + "book.php?action=update" ;	
   var rec = form.upd.selectedIndex;
   var id = document.getElementsByTagName('option')[rec].value;   
   var data = encodeURI("record="+id+'&form=set');
   xhr.open("POST", url_action, true);
   xhr.responseType = 'html';
   xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");   
   xhr.addEventListener( "load", e => {
      if (xhr.status  == 200 )    {
		  res = xhr.response ;
		  document.getElementById('data').innerHTML = '';
          document.getElementById('result').innerHTML = res ;
      }
   }) 
   xhr.send(data);
}


function _update(form) {
    var url_action = url + "book.php?action=update" ;
    isbn        = form.isbn.value;
    autor       = form.autor.value;
    tytul       = form.tytul.value;
    rok         = form.rok.value;
    wydawnictwo = form.wydawnictwo.value;
    cena        = form.cena.value;
	var data = encodeURI("record="+isbn+'&autor='+autor+'&tytul='+tytul+'&rok='+rok+'&wyd='+wydawnictwo+'&cena='+cena);
    xhr.open("POST", url_action, true);
    xhr.responseType = 'html';
    xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");   
    xhr.addEventListener( "load", e => {
       if (xhr.status  == 200 )    {
	 	  res = xhr.response ;
		  document.getElementById('data').innerHTML = '';
          document.getElementById('result').innerHTML = res ;
      }
    }) 
    xhr.send(data);
}