線上書籍

Home

用QRCODE打造自動化環境

一、修改內容
  1. 修正管理員權限錯誤
  2. prog_global.gs
二、升級方式
  1. 重新建立副本：如此部署網址會變動，LineBot、表單都需重建
  2. 手動升級：將下列程式碼複製，至目前版本，覆蓋
  3. 記得重新部署(選建立新版本)
  4. prog_global.gs /*============================================ 得到 全域變數 結構 ============================================*/ function get_stru_global(){ let stru = [ { title: '網站標題', name: 'web_title', sort: 1, kind: '簡答', type: '文字', option: '', validate: '必填', form_width: 8, default: 'XXX', readme: '', fun: '', list_show: '', list_sort: '', list_align: '', list_width: '' }, { title: '螢幕寬度', name: 'width', sort: 2, kind: '下拉選單', type: '文字', option: 'container,container-fluid', validate: '', form_width: 2, default: 'container', readme: '', fun: '', list_show: '', list_sort: '', list_align: '', list_width: '' }, { title: '記錄LineBot', name: 'record_line_bot', sort: 9, kind: '下拉選單', type: '文字', option: ',是', validate: '', form_width: 2, default: '', readme: '', fun: '', list_show: '', list_sort: '', list_align: '', list_width: '' }, { title: 'CHANNEL_ACCESS_TOKEN', name: 'CHANNEL_ACCESS_TOKEN', sort: 3, kind: '段落', type: '文字', option: '', validate: '', form_width: 12, default: '', readme: '', fun: '', list_show: '', list_sort: '', list_align: '', list_width: '' }, { title: '首頁內容', name: 'index_content', sort: 25, kind: '網頁編輯器', type: '文字', option: '', validate: '', form_width: 12, default: '', readme: '', fun: '', list_show: '', list_sort: '', list_align: '', list_width: '' }]; //console.log(stru); return stru; } /*============================================ 建立 全域變數 create_global(); ============================================*/ function create_global(sheet="全域變數"){ let ws = Sheet.getWs(sheet); let rowIndex,global; let stru = get_stru_global(); if(ws === null){ //建立工作表 Sheet.createSheet(sheet); //取得工作表 ws = Sheet.getWs(sheet); for(let i in stru){ rowIndex = parseInt(i) + 1; Sheet.setCellData(sheet,rowIndex,1,stru[i]['title'],'文字'); Sheet.setCellData(sheet,rowIndex,2,stru[i]['default'],stru[i]['type']); } }else{ global = get_global(); for(let i in stru){ rowIndex = parseInt(i) + 1; if(global[stru[i]['title']] === null){ Sheet.setCellData(sheet,rowIndex,1,stru[i]['title'],'文字'); Sheet.setCellData(sheet,rowIndex,2,stru[i]['default'],stru[i]['type'][i]); }else{ Sheet.setCellData(sheet,rowIndex,1,stru[i]['title'],'文字'); Sheet.setCellData(sheet,rowIndex,2,global[stru[i]['title']],stru[i]['type'][i]); } } } } /*====================================== 取得全域變數 ======================================*/ function get_global(){ let stru = get_stru_global(); let global = {}; let rowIndex,range; let ws = Sheet.getWs('全域變數'); for(let i in stru){ rowIndex = parseInt(i) + 1; range_title = ws.getRange(rowIndex, 1); range = ws.getRange(rowIndex, 2); if(range_title.getValue()){ global[stru[i]['title']] = range.getValue(); }else{ global[stru[i]['title']] = null; } } global['網站標題'] = global['網站標題'] ?　global['網站標題'] : '請設立網站標題'; global['url'] = ScriptApp.getService().getUrl();//取得網頁應用程式網址 let isAdmin = JSON.parse(SCRIPT_PROP.getProperty("adminEmail")); global['adminEmail'] = isAdmin[0];//Session.getActiveUser().getEmail(); global['userEmail'] = Session.getActiveUser().getEmail(); global['isAdmin'] = isAdmin.indexOf(global['userEmail']) != -1 ? true : false;// global['emailQuota'] = MailApp.getRemainingDailyQuota(); global['CHANNEL_ACCESS_TOKEN'] = global['CHANNEL_ACCESS_TOKEN'] ? global['CHANNEL_ACCESS_TOKEN'].trim() : ''; if(SCRIPT_PROP.getProperty("LINE") === null){ global['LINE'] = { userId:'', //機器人的用戶 ID basicId:'', //機器人的基本ID displayName:'', //機器人的顯示名稱 pictureUrl:'', //個人資料圖片網址 chatMode:'', //聊天模式 chat：響應模式設置為“聊天”。 bot：響應模式設置為“Bot”。 markAsReadMode:'' //標記為已讀模式 auto：啟用自動讀取設置。 manual：禁用自動讀取設置。 }; }else{ global['LINE'] = JSON.parse(SCRIPT_PROP.getProperty("LINE")); } //global['LINE'] = JSON.parse(SCRIPT_PROP.getProperty("LINE")); //console.log(global['LINE']); global['op'] = ''; return global; } /*============================================ 得到 全域變數 資料 ============================================*/ function get_row_global(sheet="全域變數"){ let ws = Sheet.getWs(sheet); let range = ws.getRange(1, 2, ws.getLastRow()); let row = range.getValues().map(function(r){ return r[0]; }); return row; } /* ========================== 全域變數 表單函式 ============================*/ function form_global(e) { //-------------------------------------------- 取得 global結構 let stru = get_stru_global();//取得 全域變數 結構 let row = get_row_global();//取得 全域變數 資料 //-------------------------------------------- 取得必填欄位，過濾「required」有值 var validate = stru.filter(function(r){ return r['validate'] !== ""; }); //將規則轉成文字 let rules = validate.map(function(r){ if(r['validate'] == "email"){ return "'" + r['name'] +"': { required: true, email : true}" ; } else{ return "'" + r['name'] +"': { required: true }" ; } }).join(","); //將訊息轉成文字 let messages = validate.map(function(r){ if(r['validate'] == "email"){ return "'" + r['name'] +"': { required: '必填', email : 'email格式不正確'}" ; } else{ return "'" + r['name'] +"': { required: '必填' }" ; } }).join(","); global['formTitle'] = '全域變數'; //-------------------------------------------- 表單 let content = Sheet.render("form_global", {global: global, stru: stru, row: row, rules: rules, messages: messages}); //-------------------------------------------- 渲染網頁 return Sheet.render('index', {global: global, menu: menu, content: content}, global['formTitle']); } /* ========================== 寫入試算表 ============================*/ function insert_global(formData){ //-------------------------------------------------------- 取得全域變數 let global = get_global();//取得全域變數 let sheet = "全域變數"; //--------------------------------------------- 設定工作表 let ws = Sheet.getWs(sheet); //檢查 接收工作表 if(ws == null){ //檢查 全域變數 create_global(); ws = Sheet.getWs(sheet); } //-------------------------------------------------------- 取得限制條件 //-------------------------------------------------------- 取得 全域變數 let stru = get_stru_global(); //-------------------------------------------------------- 寫入資料 let rowIndex; for(let i in stru){ rowIndex = parseInt(i) + 1; Sheet.setCellData(sheet, rowIndex, 2, formData[stru[i]['name']], stru[i]['type']); } //----------------------------------------將「CHANNEL_ACCESS_TOKEN」寫入 指令碼屬性 SCRIPT_PROP.setProperty("CHANNEL_ACCESS_TOKEN", formData['CHANNEL_ACCESS_TOKEN']); //----------------------------------------將「LineBot Info」寫入 指令碼屬性 SCRIPT_PROP.setProperty("LINE", JSON.stringify(getLineUserInfo(formData['CHANNEL_ACCESS_TOKEN']))); //-------------------------------------取得全域變數 global = get_global(); //-------------------------------------menu子樣板 menu = Sheet.render('menu', {global: global}); let button = Sheet.render("button", {bg: 'btn-success',title: '全域變數', url: global.url+'?op=form_global',target:'' }); return Sheet.render('show_message', {global: global, title: '全域變數 資料寫入成功', message: button, bg: 'bg-primary'}); }