sendmail03線上剪貼簿-彰化一整天的blog
移到密碼輸入
function autoSendmail(data) {
var subject = "彰化一整天訂購物網 表單自動通知", // 信件標題
emailTitle = "電子郵件地址", // 表單中收件者 email 這個項目的標題
namedValues = data.namedValues,
values=data.values,
notifyEmail = namedValues[emailTitle] ? namedValues[emailTitle][0]:"" ,
html = "";
//設定產品價格
var price={"羊奶冰棒20枝(全部原味,500元含運費)":500,"羊奶冰棒20枝(全部紅豆,500元含運費)":500,"羊奶冰棒20枝(紅豆原味各半,500元含運費)":500,"雞精原味12包(1660元含運費)":1660,"雞精粉光12包(1960元含運費)":1960,"雞精12包(1960元含運費)":1960,"雞精粉光24包(3600元含運費)":3600,"雞精人參24包(3600元含運費)":3600};
var money=0;
var free_shipping_money=3000; //設定免運費金額
var freight=150;//設定運費金額
var n=data.values.length;
var fields="";
var field=["時間戳記","電子郵件地址","請問您想購買的產品","羊奶冰棒20枝(全部原味,500元含運費)","羊奶冰棒20枝(全部紅豆,500元含運費)","羊奶冰棒20枝(紅豆原味各半,500元含運費)","雞精原味12包(1660元含運費)","雞精粉光12包(1960元含運費)","雞精12包(1960元含運費)","","雞精粉光24包(3600元含運費)","雞精人參24包(3600元含運費)","指定配送時間","您的姓名","性別","聯絡電話","寄送地址","其他說明"]
var field_color={"羊奶冰棒20枝(全部原味,500元含運費)":"#ff0000","羊奶冰棒20枝(全部紅豆,500元含運費)":"#00ff00"}; //設定產品字型顏色
var d="";
var i,j;
html="<img src='http://bestdaylong.com/images/sheep_ice.jpg'><br/>"; //設定Logo圖片
for (i = 0; i < n; i++) {
v= namedValues[field[i]] ? namedValues[field[i]][0]:"" ;
if(v!="")//有輸入的資料才顯示
{
if(field_color[field[i]]!=undefined) //有顏色再設定
html+="<font color="+field_color[field[i]]+">"+field[i]+"</font>"+":"+v+"<br/>";
else
html+=field[i]+":"+v+"<br/>";
if(price[field[i]]!=undefined) //有價格才計算
money+=price[field[i]]*v;
}
}
html+="您購買"+money+"元<br/>";
if(money<free_shipping_money)
{
money+=freight
html+="運費:"+freight+"元<br/>";
}
else
{
html+="運費:免費(滿"+free_shipping_money+"元)<br/>";
}
html+="總費用為"+money+"元<br/>";
html+="-----轉帳匯款資訊------------<br/>";
html+="銀行名稱:兆豐國際商業銀行(代碼:017)<br/>";
html+="分行名稱:竹北分行<br/>";
html+="戶名:彰化一整天<br/>";
html+="帳號:000-00-000000<br/>";
MailApp.sendEmail({
to: notifyEmail,
subject: subject,
htmlBody: html
});
//將總金額回填儲存格
var sheet =SpreadsheetApp.getActiveSheet();
var LastRow=sheet.getActiveCell().getLastRow(); //取得最後一列
sheet.getRange("S"+LastRow).setValue(money);//將資料寫到S欄的最後一筆
}
function test()
{
var sheet =SpreadsheetApp.getActiveSheet();
Logger.log(sheet.getSheetValues(1,1,1,1));
sheet.getActiveCell().getLastRow();
}