|

樓主 |
發表於 2019-10-3 22:43:27
|
顯示全部樓層
那是因為輸入的數量是文字,沒有轉型別所造成,只要過經四則運算就會變成數字。
- function autoSendmail(data) {
- var subject = "Apu・手作烘焙・網路訂購單 費用繳款通知", // 信件標題
- emailTitle = "電子郵件地址", // 表單中收件者 email 這個項目的標題
- namedValues = data.namedValues,
- values=data.values,
- notifyEmail = namedValues[emailTitle] ? namedValues[emailTitle][0]:"" ,
- html = "";
-
- //設定產品價格
- var price={"《酸酸檸檬派 - 3.5吋》請填寫欲訂購的數量":120,"《布魯派 - 3.5吋》請填寫欲訂購的數量":160,"《林果派 - 3.5吋》請填寫欲訂購的數量":120,"《堅果派 - 3.5吋》請填寫欲訂購的數量":140,"《酸酸檸檬派 - 6吋》請填寫欲訂購的數量":360,"《布魯派 - 6吋》請填寫欲訂購的數量":600,"《林果派 - 6吋》請填寫欲訂購的數量":420,"《堅果派 - 6吋》請填寫欲訂購的數量":420};
- var money=0;
-
- var freight_all=0; //總運費
-
- var n=data.values.length;
-
- var fields="";
-
- var field=["時間戳記","電子郵件地址","《酸酸檸檬派 - 3.5吋》請填寫欲訂購的數量","《布魯派 - 3.5吋》請填寫欲訂購的數量","《林果派 - 3.5吋》請填寫欲訂購的數量","《堅果派 - 3.5吋》請填寫欲訂購的數量","《酸酸檸檬派 - 6吋》請填寫欲訂購的數量","《布魯派 - 6吋》請填寫欲訂購的數量","《林果派 - 6吋》請填寫欲訂購的數量","《堅果派 - 6吋》請填寫欲訂購的數量","請選擇您的取貨方式","取貨人姓名","取貨人電話","取貨日期","取貨時間","收件人姓名","收件人電話","收件人地址","指定到貨日期","指定到貨時段(實際依黑貓送貨情況)"]
- var buy_amount=0;//購買數量
-
- var i,j;
-
- //顯示欄位名稱
- show_field(namedValues);
-
- for (i = 0; i < n; i++) {
- v= namedValues[field[i]] ? namedValues[field[i]][0]:"" ;
- if(v!="")//有輸入的資料才顯示
- {
- html+=field[i]+":"+v+"<br/>";
- if(price[field[i]]!=undefined) //有價格才計算
- {
- money+=price[field[i]]*v;
- //判斷數量是1/4或是1
- if(field[i].indexOf("3.5吋")>0) //若是3.5吋則算1/4數量
- buy_amount+=v/4;
- else
- buy_amount+=v*1;
-
- }
- }
- }
-
-
- html+="您訂購派品金額為"+money+"元<br/>";
- {
-
- //計算個別運費
-
- if(buy_amount>=1 && buy_amount<=2)//1-2盒
- {
- freight_all=160;
- }
- else if(buy_amount>=3 && buy_amount<=6)//3-6盒
- {
- freight_all=225;
- }
- else if(buy_amount>=7 && buy_amount<=16)//7-16盒
- {
- freight_all=290;
- }
- else //其它運費
- {
- freight_all=500;
- }
- }
- money+=freight_all;
- html+="運費:"+freight_all+"元<br/>";
-
-
- html+="總費用為"+money+"元<br/>";
-
-
- html+="------轉帳匯款資訊------<br/>";
- html+="銀行名稱:台灣銀行(代碼:004)<br/>";
- html+="戶名:xxx<br/>";
- html+="帳號:xxx-xxxx-xxxx<br/>";
- html+="------請務必於2天內完成匯款轉帳,超過2天則視同棄單喔!------<br/>";
- html+="------完成轉帳後請以此封mail回覆帳號後5碼,以利我們快速對帳,將您的訂單安排製作喔!------<br/>";
-
- MailApp.sendEmail({
- to: notifyEmail,
- bcc:"xxxx@gmail.com", //副件附本寄給您的email
- subject: subject,
- htmlBody: html
- });
-
- }
- function test()
- {
- var sheet =SpreadsheetApp.getActiveSheet();
-
- Logger.log(sheet.getSheetValues(1,1,1,1));
-
- }
- function show_field(namedValues)
- {
- fields="";
- Object.keys(namedValues).forEach(function(key) {
- if(namedValues[key]!="")//有輸入的資料才顯示
- {
- fields+="["+key+"]:["+namedValues[key]+"]\n";
- }
-
- });
- Logger.log(fields);
-
- }
複製代碼
|
|