File size: 10,342 Bytes
4a4580d | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 | /**
* ============================================================
* ๅบๅคๅธๆใใฉใผใ ่ชๅ็ๆในใฏใชใใ (Google Apps Script)
* ============================================================
*
* ใไฝฟใๆนใ
* 1. Google ในใใฌใใใทใผใใๆฐ่ฆไฝๆ
* 2. ๆกๅผตๆฉ่ฝ > Apps Script ใงใใฎใณใผใใ่ฒผใไปใ
* 3. CONFIG ใ็ทจ้๏ผๆ้ใปในใฟใใๅใปใทใใใใฟใผใณ๏ผ
* 4. createShiftForm() ใๅฎ่ก โ ่ช่จผใ่จฑๅฏ
* 5. ใญใฐใซ่กจ็คบใใใใ้
ๅธURLใใในใฟใใใซๅ
ฑๆ
*
* ใใใฉใผใ ใฎๆตใใ
* Q1 : ใๅๅ๏ผใใซใใฆใณใปๅฟ
้ ๏ผ
* โ ๆฅไปใใจใซ็นฐใ่ฟใ๏ผๆฅๆฐๅใฎใปใฏใทใงใณ๏ผ
* Q2n: Xๆฅ๏ผๆ๏ผใฏๅบๅคใงใใพใใ๏ผ๏ผใฉใธใชใปไปปๆ๏ผ
* โโ ๆ้ฃใฎใฟ โ ๆ้ฃใทใใ้ธๆใปใฏใทใงใณใธ
* โโ ใใฃใใผใฎใฟ โ ใใฃใใผใทใใ้ธๆใปใฏใทใงใณใธ
* โโ ใใใซ(ไธกๆน) โ ๆฌกใฎๆฅใธ๏ผใใใซใทใใ็ขบๅฎใปๆ้ๆๅฎใชใ๏ผ
* โโ ไผใฟ โ ๆฌกใฎๆฅใธ๏ผในใญใใ๏ผ
* Q3n: ๆ้ฃ / ใใฃใใผ ใฎๅธๆใทใใใใใซใใฆใณใง้ธๆ
* โ
* Q4 : ๅ่ๆฌ๏ผ่จ่ฟฐๅผใปไปปๆ๏ผ
*
* ใCSV ใคใณใใผใๆใฎๆณจๆใ
* ๅ็ญๅ้ๅพใในใใฌใใใทใผใใฎ
* ใใใกใคใซ > ใใฆใณใญใผใ > CSVใใงใจใฏในใใผใใใ
* ใทใใ็ฎก็ใขใใชใฎใGoogle Forms CSV ใใคใณใใผใใใใ่ชญใฟ่พผใใงใใ ใใใ
* ============================================================
*/
// ============================================================
// โ
ใใใๆฏๆ็ทจ้ใใฆใใ ใใ
// ============================================================
const CONFIG = {
PERIOD_START : '2025-04-01', // ใทใใๆ้้ๅง (YYYY-MM-DD)
PERIOD_END : '2025-04-14', // ใทใใๆ้็ตไบ (YYYY-MM-DD)
FORM_TITLE : '4ๆ ๅบๅคๅธๆใใฉใผใ ',
FORM_DESC : [
'ใๅ็ญๆ้ใโฏๆโฏๆฅ๏ผโฏ๏ผ23:59 ใพใงใซๅ็ญใใฆใใ ใใใ',
'',
'ใๆณจๆไบ้
ใ',
'ใปใๅๅใฏใชในใใใๆญฃ็ขบใซ้ธใใงใใ ใใ',
'ใปๆฅไปใใจใซๅบๅคใฎๅฏๅฆใจๅธๆใทใใๆ้ใๅ
ฅๅใใพใ',
'ใปใใใซใฏๆ้ฃใปใใฃใใผไธกๆนใใซๅบๅค๏ผๆ้ๅธฏใฏ็ขบๅฎ๏ผ',
'ใปใชในใใซใชใๆ้ๅธฏใฏใใใฎไปใใ้ธๆใใฆๅ่ๆฌใซ่จๅ
ฅ',
].join('\n'),
// โโ ็ป้ฒในใฟใใๅ๏ผใขใใชใฎ็ป้ฒๅใจๅฎๅ
จไธ่ดใใใใใจ๏ผโโ
EMPLOYEES: [
'็ฐไธญ ๅคช้',
'ๅฑฑ็ฐ ่ฑๅญ',
'ไฝ่ค ๆฌก้',
'้ดๆจ ็พๅฒ',
'ไผ่ค ๅฅๅคช',
],
// โโ ๆ้ฃใทใใใฎ้ธๆ่ข๏ผใขใใชใฎใใใฟใผใณใฉใใซใใจไธ่ดใใใใใจ๏ผโโ
BREAKFAST_PATTERNS: [
'ๆ้ฃ็ญ็ช (6:00ใ10:00)',
'ๆ้ฃ (6:30ใ11:30)',
'ๆ้ฃใญใณใฐ (5:45ใ14:45)',
'ๅๅๅๆฅ (6:30ใ15:30)',
'ใใฎไป๏ผๅ่ๆฌใซๆๅปใ่จๅ
ฅ๏ผ',
],
// โโ ใใฃใใผใทใใใฎ้ธๆ่ข โโ
DINNER_PATTERNS: [
'้ใๆฉ็ช (13:00ใ22:30)',
'้ใ้
็ช (14:00ใ23:00)',
'ใใฃใใผ (17:00ใ22:30)',
'ใใฃใใผ (17:30ใ23:00)',
'ใใฃใใผ (18:00ใ23:00)',
'ใใฃใใผๅๅ (17:00ใ21:00)',
'ใใฃใใผๅๅ (17:30ใ21:30)',
'ใใฃใใผ็ญ็ช (18:00ใ22:00)',
'ใใฎไป๏ผๅ่ๆฌใซๆๅปใ่จๅ
ฅ๏ผ',
],
};
// ============================================================
// ใใซใใผ
// ============================================================
const _DOW_JA = ['ๆฅ', 'ๆ', '็ซ', 'ๆฐด', 'ๆจ', '้', 'ๅ'];
/** YYYY-MM-DD โ Date ใชใใธใงใฏใใฎ้
ๅ๏ผใฟใคใ ใพใผใณใใใ้ฒใใใใญใผใซใซ่งฃ้๏ผ */
function _getDates(startStr, endStr) {
const [sy, sm, sd] = startStr.split('-').map(Number);
const [ey, em, ed] = endStr.split('-').map(Number);
const dates = [];
let d = new Date(sy, sm - 1, sd);
const end = new Date(ey, em - 1, ed);
while (d <= end) {
dates.push(new Date(d));
d.setDate(d.getDate() + 1);
}
return dates;
}
/** Date โ ใ4ๆ1ๆฅ๏ผๆ๏ผใๅฝขๅผ */
function _label(d) {
return `${d.getMonth() + 1}ๆ${d.getDate()}ๆฅ๏ผ${_DOW_JA[d.getDay()]}๏ผ`;
}
// ============================================================
// ใกใคใณ: ใใฉใผใ ใ็ๆ
// ============================================================
function createShiftForm() {
const dates = _getDates(CONFIG.PERIOD_START, CONFIG.PERIOD_END);
const form = FormApp.create(CONFIG.FORM_TITLE);
form.setDescription(CONFIG.FORM_DESC);
form.setCollectEmail(false);
form.setAllowResponseEdits(true); // ๅ็ญๅพใฎ็ทจ้ใ่จฑๅฏ
// โโ Q1: ใๅๅ๏ผใใซใใฆใณใปๅฟ
้ ๏ผโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
form.addListItem()
.setTitle('ใๅๅ')
.setHelpText('ใชในใใใ่ชๅใฎๅๅใ้ธๆใใฆใใ ใใใ')
.setRequired(true)
.setChoiceValues(CONFIG.EMPLOYEES);
// โโ ๅๆฅใฎใใผใธใ้ ็ชใซไฝๆ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
// ใซใผใใฃใณใฐ่จญๅฎใฎใใใซใใผใธๅ็
งใป่ณชๅๅ็
งใไฟๆใใ
const availPages = []; // ๅบๅคๅฏๅฆใใผใธ๏ผๅๆฅ1ใค๏ผ
const bPages = []; // ๆ้ฃใทใใ้ธๆใใผใธ๏ผๅๆฅ1ใค๏ผ
const dPages = []; // ใใฃใใผใทใใ้ธๆใใผใธ๏ผๅๆฅ1ใค๏ผ
const availItems = []; // ๅบๅคๅฏๅฆใฉใธใชใฎ่ณชๅใขใคใใ
for (let i = 0; i < dates.length; i++) {
const dl = _label(dates[i]);
// โโ ๅบๅคๅฏๅฆใปใฏใทใงใณ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
availPages.push(
form.addPageBreakItem().setTitle(`${dl} ใฎๅบๅคๅธๆ`)
);
availItems.push(
form.addMultipleChoiceItem()
.setTitle(`${dl} ใฏๅบๅคใงใใพใใ๏ผ`)
.setRequired(false) // โฃ ๆชๅ็ญ = ในใญใใ
);
// โโ ๆ้ฃใทใใ้ธๆใปใฏใทใงใณ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
bPages.push(
form.addPageBreakItem().setTitle(`${dl} ๆ้ฃ โ ๅธๆใทใใ`)
);
form.addListItem()
.setTitle(`${dl} ๆ้ฃใฎๅธๆใทใใใ้ธใใงใใ ใใ`)
.setHelpText('ใชในใใซใชใๅ ดๅใฏใใใฎไปใใ้ธๆใใๆๅพใฎๅ่ๆฌใซๆๅปใ่จๅ
ฅใใฆใใ ใใใ')
.setRequired(false)
.setChoiceValues(CONFIG.BREAKFAST_PATTERNS);
// โโ ใใฃใใผใทใใ้ธๆใปใฏใทใงใณ โโโโโโโโโโโโโโโโโโโโโโโโโโโโ
dPages.push(
form.addPageBreakItem().setTitle(`${dl} ใใฃใใผ โ ๅธๆใทใใ`)
);
form.addListItem()
.setTitle(`${dl} ใใฃใใผใฎๅธๆใทใใใ้ธใใงใใ ใใ`)
.setHelpText('ใชในใใซใชใๅ ดๅใฏใใใฎไปใใ้ธๆใใๆๅพใฎๅ่ๆฌใซๆๅปใ่จๅ
ฅใใฆใใ ใใใ')
.setRequired(false)
.setChoiceValues(CONFIG.DINNER_PATTERNS);
}
// โโ ๅ่ใปใฏใทใงใณ๏ผๆ็ตใใผใธ๏ผโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
const finalPage = form.addPageBreakItem().setTitle('ๅ่');
form.addParagraphTextItem()
.setTitle('ใใฎไปใใทใใใซ้ขใใ้ฃ็ตกไบ้
ใใใใฐ่จๅ
ฅใใฆใใ ใใ')
.setHelpText('ใใใฎไปใใ้ธใใ ๆฅใฎๆๅปใ้
ๅปใปๆฉ้ใฎๅฏ่ฝๆงใชใฉ\nไพ: 4/3 ๆ้ฃ 8:00ใ12:00ใ4/10 18:00ไปฅ้ใฏๆฉ้ๅธๆ')
.setRequired(false);
// โโ ๆกไปถๅๅฒ๏ผใใผใธใซใผใใฃใณใฐ๏ผใฎ่จญๅฎ โโโโโโโโโโโโโโโโโโโโโโโโ
for (let i = 0; i < dates.length; i++) {
// ๆฌกใซ้ฒใในใใใผใธ๏ผๆ็ตๆฅใชใๅ่ใใผใธ๏ผ
const nextPage = (i + 1 < dates.length) ? availPages[i + 1] : finalPage;
// ๆ้ฃใปใใฃใใผใใผใธใฎ็ตไบๅพใฏๆฌกใฎๆฅ๏ผใพใใฏๅ่ใใผใธ๏ผใธ
bPages[i].setGoToPage(nextPage);
dPages[i].setGoToPage(nextPage);
// ๅบๅคๅฏๅฆใฎ้ธๆ่ขใใจใฎใซใผใใฃใณใฐ
const aq = availItems[i];
aq.setChoices([
aq.createChoice(
'ๆ้ฃใฎใฟ',
FormApp.PageNavigationType.GO_TO_PAGE,
bPages[i] // ๆ้ฃใทใใ้ธๆใธ
),
aq.createChoice(
'ใใฃใใผใฎใฟ',
FormApp.PageNavigationType.GO_TO_PAGE,
dPages[i] // ใใฃใใผใทใใ้ธๆใธ
),
aq.createChoice(
'ใใใซ๏ผๆ้ฃ๏ผใใฃใใผไธกๆน๏ผ',
FormApp.PageNavigationType.GO_TO_PAGE,
nextPage // ๆฌกใฎๆฅใธ๏ผใใใซใทใใ็ขบๅฎ๏ผ
),
aq.createChoice(
'ไผใฟ',
FormApp.PageNavigationType.GO_TO_PAGE,
nextPage // ๆฌกใฎๆฅใธ๏ผในใญใใ๏ผ
),
]);
}
// โโ ใญใฐๅบๅ โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
const editUrl = form.getEditUrl();
const pubUrl = form.getPublishedUrl();
const shortUrl = form.shortenFormUrl(pubUrl);
Logger.log('โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ');
Logger.log(`โ
็ๆๅฎไบ: ${CONFIG.FORM_TITLE}`);
Logger.log(`๐ ็ทจ้URL (็ฎก็่
): ${editUrl}`);
Logger.log(`๐ ้
ๅธURL (ในใฟใใ): ${shortUrl}`);
Logger.log('โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ');
// ในใใฌใใใทใผใใ็ดไปใใฆใใๅ ดๅใฏAๅใซURLใ่จ้ฒ
try {
SpreadsheetApp.getActiveSpreadsheet()
.getActiveSheet()
.getRange('A1:B3')
.setValues([
['็ๆๆฅๆ', new Date().toLocaleString('ja-JP')],
['็ทจ้URL๏ผ็ฎก็่
๏ผ', editUrl],
['้
ๅธURL๏ผในใฟใใ๏ผ', shortUrl],
]);
} catch (e) { /* ในใฟใณใใขใญใณในใฏใชใใใฎๅ ดๅใฏ็ก่ฆ */ }
return shortUrl;
}
|