function setupApp(){
/*script id*/
var SCPID = ScriptApp.getScriptId();
var file = DriveApp.getFileById(SCPID);
var folders = file.getParents();
while (folders.hasNext()){
FOLID=folders.next().getId();
}
FOLDER = DriveApp.getFolderById(FOLID);
var d = new Date();
var t = d.getTime();
var NEWSST = SpreadsheetApp.create("_appdata-102-"+t);
var TEMP = DriveApp.getFileById(NEWSST.getId());
FOLDER.addFile(TEMP);
DriveApp.getRootFolder().removeFile(TEMP);
var scriptProperties = PropertiesService.getScriptProperties();
scriptProperties.setProperties({
scpid:SCPID,
folid:FOLID,
sstid:NEWSST.getId()
});
/*record headers*/
var arrRecordTitles=["admin","user"];
var arrRecordHeaders=[
["tid","timestamp","name","gmail"],
["tid","timestamp","name","gmail","pincode"]
];
for (i in arrRecordTitles){
var Sheet = NEWSST.getSheetByName(arrRecordTitles[i]);
if (Sheet != null) {
NEWSST.setActiveSheet(NEWSST.getSheetByName(arrRecordTitles[i]));
NEWSST.deleteActiveSheet();
}
NewSheet = NEWSST.insertSheet();
NewSheet.setName(arrRecordTitles[i]);
NewSheet.appendRow(arrRecordHeaders[i]);
NewSheet.getRange("A2:A").setNumberFormat('@STRING@');
}
}
/*https://coderwall.com/p/_g3x9q/how-to-check-if-javascript-object-is-empty*/
function isObjectEmpty(r){for(var n in r)if(r.hasOwnProperty(n))return!1;return!0}
/*http://www.deluge.co/?q=javascript-int-hex-universal-base-converter*/
function baseToBase(fromBase,toBase,value){;if(value=="") value=0;value=parseInt(value,fromBase);return Number(value).toString(toBase).toUpperCase();}
/*http://www.webtoolkit.info/javascript-base64.html#.WapakHcjGL9*/
var Base64={_keyStr:"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=",encode:function(input){var output="";var chr1,chr2,chr3,enc1,enc2,enc3,enc4;var i=0;input=Base64._utf8_encode(input);while(i<input.length){chr1=input.charCodeAt(i++);chr2=input.charCodeAt(i++);chr3=input.charCodeAt(i++);enc1=chr1>>2;enc2=((chr1&3)<<4)|(chr2>>4);enc3=((chr2&15)<<2)|(chr3>>6);enc4=chr3&63;if(isNaN(chr2)){enc3=enc4=64;}else if(isNaN(chr3)){enc4=64;} output=output+ this._keyStr.charAt(enc1)+this._keyStr.charAt(enc2)+ this._keyStr.charAt(enc3)+this._keyStr.charAt(enc4);} return output;},decode:function(input){var output="";var chr1,chr2,chr3;var enc1,enc2,enc3,enc4;var i=0;input=input.replace(/[^A-Za-z0-9+/=]/g,"");while(i<input.length){enc1=this._keyStr.indexOf(input.charAt(i++));enc2=this._keyStr.indexOf(input.charAt(i++));enc3=this._keyStr.indexOf(input.charAt(i++));enc4=this._keyStr.indexOf(input.charAt(i++));chr1=(enc1<<2)|(enc2>>4);chr2=((enc2&15)<<4)|(enc3>>2);chr3=((enc3&3)<<6)|enc4;output=output+String.fromCharCode(chr1);if(enc3!=64){output=output+String.fromCharCode(chr2);} if(enc4!=64){output=output+String.fromCharCode(chr3);}} output=Base64._utf8_decode(output);return output;},_utf8_encode:function(string){string=string.replace(/rn/g,"n");var utftext="";for(var n=0;n<string.length;n++){var c=string.charCodeAt(n);if(c<128){utftext+=String.fromCharCode(c);} else if((c>127)&&(c<2048)){utftext+=String.fromCharCode((c>>6)|192);utftext+=String.fromCharCode((c&63)|128);} else{utftext+=String.fromCharCode((c>>12)|224);utftext+=String.fromCharCode(((c>>6)&63)|128);utftext+=String.fromCharCode((c&63)|128);}} return utftext;},_utf8_decode:function(utftext){var string="";var i=0;var c=c1=c2=0;while(i<utftext.length){c=utftext.charCodeAt(i);if(c<128){string+=String.fromCharCode(c);i++;} else if((c>191)&&(c<224)){c2=utftext.charCodeAt(i+1);string+=String.fromCharCode(((c&31)<<6)|(c2&63));i+=2;} else{c2=utftext.charCodeAt(i+1);c3=utftext.charCodeAt(i+2);string+=String.fromCharCode(((c&15)<<12)|((c2&63)<<6)|(c3&63));i+=3;}} return string;}}
function initApp(){
SCRIPTPROP = PropertiesService.getScriptProperties();
if (isObjectEmpty(SCRIPTPROP.getProperties())){
setupApp();
SCRIPTPROP = PropertiesService.getScriptProperties();
}
Logger.log(SCRIPTPROP.getProperties());
/* projectkey=MJMF2lqsgWV-I-dlyqJN6OrljYCrJdQKl */
DB1 = objDB.open(SCRIPTPROP.getProperty("sstid"));
}
/* web request listeners */
function doGet(e) {
return handleResponse(e);
}
function doPost(e) {
return handleResponse(e);
}
/* handle action request */
function handleResponse(e) {
var lock = LockService.getPublicLock();
lock.waitLock(30000); // wait 30 seconds before conceding defeat.
try {
var cmd = e.parameter.cmd;
var output = [];
if (cmd == "app") {
output = taskManager("app", e);
} else if (cmd == "getuser") {
output = taskManager("getuser", e);
} else if (cmd == "reguser") {
output = taskManager("reguser", e);
} else if (cmd == "setuser") {
output = taskManager("setuser", e);
} else if (cmd == "deluser") {
output = taskManager("deluser", e);
} else if (cmd == "chkuser") {
output = taskManager("chkuser", e);
}
return ContentService.createTextOutput(JSON.stringify({
"result": "success",
"data": output
})).setMimeType(ContentService.MimeType.JSON);
//return output
} catch (e) { /*if error return this*/
return ContentService.createTextOutput(JSON.stringify({
"result": "error",
"error": e
})).setMimeType(ContentService.MimeType.JSON);
} finally { /*release lock*/
lock.releaseLock();
}
}
/*taskManager*/
function taskManager(cmd, e) {
initApp();
var output = "";
switch (cmd) {
case "app":
/*test with a call to get rows from admin sheet*/
output=objDB.getRows( DB1, 'admin' );
return output;
break;
case "getuser":
var tid = e.parameter["tid"] || "";
if(tid!=""){output=objDB.getRows(DB1,'user',[],{tid:tid});}
else{output=objDB.getRows( DB1, 'user' );}
return output;
break;
case "reguser":
var objRecord={tid:0,timestamp:"",name:"",gmail:"",pincode:""};
for(var key in objRecord) {objRecord[key]=e.parameter[key];}
var d = new Date();
objRecord.timestamp = d;
objRecord.tid = d.getTime();
objRecord.pincode=baseToBase(10,16,objRecord.tid);
var newrecord=objDB.insertRow( DB1, 'user',objRecord );
Logger.log(newrecord);
/* https://developers.google.com/apps-script/reference/mail */
var link=ScriptApp.getService().getUrl();
MailApp.sendEmail({
name: "App Team",
to: objRecord.gmail,
subject: "App Registration",
htmlBody: "Dear " + objRecord.name + ",<br/> " +
"Your app registration has been successful. <br/> " +
"Your pincode is... <h1>" + objRecord.pincode +"</h1>"+
"<a href='" + link + "?cmd=chkuser&uc="+ Base64.encode(objRecord.name) + "&pc="+ objRecord.pincode + "'>" +
"Click here to test your pincode<br/>" +
"</a>"+
"<br/>"+
"Thank you.<br/>" +
"<br/>"+
"(From App Team)"
});
var g = {parameter:{tid:objRecord.tid}};
output= taskManager("getuser",g);
return output;
break;
case "chkuser":
var objCheck={uc:"",pc:""};
var objRecord={name:"",pincode:""};
for(var key in objCheck) {objCheck[key]=e.parameter[key];}
if(objCheck.uc!="" && objCheck.pc!=""){
objRecord.name=Base64.decode(objCheck.uc);
objRecord.pincode=objCheck.pc;
output=objDB.getRows(DB1,'user',["name"],objRecord);
}
return output;
break;
case "setuser":
var objRecord={tid:0,timestamp:"",name:"",gmail:"",fileid:""};
for(var key in objRecord) {objRecord[key]=e.parameter[key];}
var d = new Date();
objRecord.timestamp = d;
var newrecord=objDB.updateRow( DB1, 'user',objRecord,{tid:objRecord.tid} );
Logger.log(newrecord);
if (newrecord==1){
var f = {parameter:{tid:objRecord.tid}};
output= taskManager("getuser",f);
}
return output;
break;
case "deluser":
var objRecord={tid:0,timestamp:"",name:"",gmail:""};
for(var key in objRecord) {objRecord[key]=e.parameter[key];}
var delrecord=objDB.deleteRow(DB1, 'user', {tid:objRecord.tid} );
Logger.log(delrecord);
if (delrecord==1) {output= [{tid:0}];}
else {output= [];}
return output;
break;
}/*swith*/
}
function test(){
Logger.log(taskManager("app")) ;
}
function testGetUsers() {
var e = {parameter: {cmd: "getuser"}};Logger.log(taskManager("getuser",e));
}
function testGetUser() {
var e = {parameter: {cmd: "getuser",tid:"123"}};Logger.log(taskManager("getuser",e));
}
function testRegUser() {
var e = {parameter: {cmd: "adduser",name: "aba",gmail: "notarazi.com@gmail.com"}};Logger.log(taskManager("reguser",e));
}
function testSetUser() {
var e = {parameter: {cmd: "setuser",tid:123,name: "vivi",gmail: "vovoi@gmail.com"}};Logger.log(taskManager("setuser",e));
}
function testDelUser() {
var e = {parameter: {cmd: "deluser",tid: "789"}};Logger.log(taskManager("deluser",e));
}
| 
