แสดงข้อมูล ลบ เพิ่ม อัปเดท

kodular + Sheet + AppScript

function doGet(e) { 
    return ManageSheet(e);
}

function doPost(e) { 
    return ManageSheet(e);
}

function ManageSheet(e) {
   
    //เพิ่มข้อมูลใหม่ 
   if ( e.parameter.func == "Create") {
   var ss = SpreadsheetApp.getActive();
   var sh = ss.getSheets()[0];
   var data = [e.parameter.id,e.parameter.name, e.parameter.nickname, "'"+e.parameter.phone];
   sh.appendRow(data);
   return ContentService.createTextOutput("Success");
   }

   //อ่านข้อมูลทั้งหมด
    else if ( e.parameter.func == "ReadAll") {
    var ss = SpreadsheetApp.getActive();
    var sh = ss.getSheets()[0]; 
    var rg = sh.getDataRange().getValues(); 
    var outString = '';
      for(var row=0 ; row<rg.length ; ++row){
        outString += rg[row].join(',') + '\n';  
      }
    return ContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);
  }

   //ลบข้อมูล
   else if (e.parameter.func == "Delete") {
    var record = e.parameter.id;
    var ss = SpreadsheetApp.getActive();
    var sh = ss.getSheets()[0];
    sh.deleteRow(parseInt(record) + 1);  //makes the correct row to delete
    return ContentService.createTextOutput("Success, requested action completed");  
} 
  //เลือกข้อมูล
   else if ( e.parameter.func == "ReadRecord") {
    var ss = SpreadsheetApp.getActive();
    var sh = ss.getSheets()[0];
    var rg = sh.getDataRange().getValues();
    var outString = '';
    outString += rg[parseInt(e.parameter.id)].join(',');
    return ContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);
  } 
  
  //อัปเดตข้อมูล 
   else if ( e.parameter.func == "Update") {
   var ss = SpreadsheetApp.getActive();
   var sh = ss.getSheets()[0];
   var data = [[e.parameter.name, e.parameter.nickname, "'"+e.parameter.phone ]];
   sh.getRange("B"+(parseInt(e.parameter.id)+1)+":D"+(parseInt(e.parameter.id)+1)).setValues(data);
   return ContentService.createTextOutput("Success");
   }

}

function doGet(e) {
return ManageSheet(e);
}

function doPost(e) {
return ManageSheet(e);
}

function ManageSheet(e) {

//เพิ่มข้อมูลใหม่ 

if ( e.parameter.func == "Create") {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var data = [e.parameter.id,e.parameter.name, e.parameter.nickname, "'"+e.parameter.phone];
sh.appendRow(data);
return ContentService.createTextOutput("Success");
}

//อ่านข้อมูลทั้งหมด
else if ( e.parameter.func == "ReadAll") {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var rg = sh.getDataRange().getValues();
var outString = '';
for(var row=0 ; row<rg.length ; ++row){
outString += rg[row].join(',') + '\n';
}
return ContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);
}

//ลบข้อมูล
else if (e.parameter.func == "Delete") {
var record = e.parameter.id;
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
sh.deleteRow(parseInt(record) + 1); //makes the correct row to delete
return ContentService.createTextOutput("Success, requested action completed");
}
//เลือกข้อมูล
else if ( e.parameter.func == "ReadRecord") {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var rg = sh.getDataRange().getValues();
var outString = '';
outString += rg[parseInt(e.parameter.id)].join(',');
return ContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);
}

//อัปเดตข้อมูล
else if ( e.parameter.func == "Update") {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var data = [[e.parameter.name, e.parameter.nickname, "'"+e.parameter.phone ]];
sh.getRange("B"+(parseInt(e.parameter.id)+1)+":D"+(parseInt(e.parameter.id)+1)).setValues(data);
return ContentService.createTextOutput("Success");
}