function doGet(e) {
return Datasheet(e);
}
function doPost(e) {
return Datasheet(e);
}
function Datasheet(e){
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName(e.parameter.SH);
//------------------- SIMPAN RECORD -------------------
if (e.parameter.func == "Simpan") {
var nama = e.parameter.NAMA;
var email = e.parameter.EMAIL;
var pass = e.parameter.PASSWORD;
var data=false;
var lr= sh.getLastRow();
for(var row=1;row<=lr;row++){
var data_email = sh.getRange(row, 2).getValue();
if(data_email==email){
data=true;
}
}
if (data){
var hasil= "email Sudah ada";
}else{
var rowData = sh.appendRow([nama,email,pass]);
var hasil="Registrasi Sukses";
}
return ContentService.createTextOutput(hasil).setMimeType(ContentService.MimeType.TEXT);
}
//------------------ LOGIN ------------------
if (e.parameter.func == "LOGIN") {
var username = e.parameter.USERNAME;
var password = e.parameter.PASSWORD;
var data='NOTFOUND';
var lr= sh.getLastRow();
for(var row=1;row<=lr;row++){
var data_username = sh.getRange(row, 1).getValue();
var data_password = sh.getRange(row, 3).getValue();
if((data_username==username) && (data_password==password)) {
data='SUKSES';
//var hasil = sh.getRange(row, 1).getValue()+"|"+sh.getRange(row, 2).getValue()+"|"+sh.getRange(row, 3).getValue()+"|"+sh.getRange(row, 4).getValue();
}
}
return ContentService.createTextOutput(data);
}
}