31 lines
1.4 KiB
JavaScript
31 lines
1.4 KiB
JavaScript
const VER = "1.0.3";
|
||
const SHEET_ID = "1yHIRyYetq6SC3BZtGNVDzCfIJvuwcROnmdqyk9Jmyss";
|
||
|
||
// 學員進度
|
||
const SHEET_STUDENT_PROGRESS = "學員進度";
|
||
|
||
const COL_STUDENT_PROGRESS_CHINESE_NAME = "A"; //中文姓名
|
||
const COL_STUDENT_PROGRESS_ENGLISH_NAME = "B"; // 英文姓名
|
||
const COL_STUDENT_PROGRESS_COURSE_OFFERED = "C"; // 報讀課程
|
||
const COL_STUDENT_PROGRESS_COURSE_CODE = "D"; // 課程班號
|
||
const COL_STUDENT_PROGRESS_GENDER = "E"; // 性別
|
||
const COL_STUDENT_PROGRESS_PHONE_NUMBER = "F"; // 手提電話
|
||
const COL_STUDENT_PROGRESS_EMAIL_ADDRESS = "G"; // 電郵地址
|
||
const COL_STUDENT_PROGRESS_ATTENDANCE_PROGRESS = "H"; // 上堂進度
|
||
const COL_STUDENT_PROGRESS_PAYMENT_PROGRESS = "I"; // 繳費進度
|
||
const COL_STUDENT_PROGRESS_PAYMENT_LINK = "K"; // 付款連結
|
||
const COL_STUDENT_PROGRESS_NOTIFICATION_DATE = "J"; // 通知日期 (yyyy-mm-dd)
|
||
// const COL_STUDENT_PROGRESS_PAYMENT_PROOF_PROVIDED = "M"; // 已提供付款證明
|
||
const COL_STUDENT_PROGRESS_CERTIFICATE_REISSUE = "L"; // 證書補發
|
||
const COL_STUDENT_PROGRESS_CERTIFICATE_FEE_RECEIVED = "M"; // 己收補證書費用
|
||
const COL_STUDENT_PROGRESS_REMARKS = "O"; // 備註
|
||
const COL_STUDENT_PROGRESS_RESULT = "Y"; // RESULT
|
||
|
||
const CONST_NOT_NOTIFIED = "未通知";
|
||
const CONST_NOTIFIED_ALREADY = "已通知";
|
||
const EMAIL_QUOTA_USED_UP="對不起，email 配額已用完"
|
||
|
||
const ROW_START = 2;
|
||
|
||
console.log("config initialized");
|