Claude Sonnet 4.6
feat: GASใใฉใผใ ๅฏพๅฟใปCSVใใผใตใผใๆฐๆงใใฉใผใใใ่ชๅๅคๅฅใซๆดๆฐ
4a4580d Download scripts/ShiftFormGenerator.gs from sdu-shift/app: direct link, hf CLI and curl.
- Browser
- Download file 10.3 kB
-
https://huggingface.co/spaces/sdu-shift/app/resolve/main/scripts/ShiftFormGenerator.gs
- Command line
-
hf download hf://spaces/sdu-shift/app/scripts/ShiftFormGenerator.gs
-
curl -L -o ShiftFormGenerator.gs https://huggingface.co/spaces/sdu-shift/app/resolve/main/scripts/ShiftFormGenerator.gs
10.3 kB
| /** | |
| * ============================================================ | |
| * ๅบๅคๅธๆใใฉใผใ ่ชๅ็ๆในใฏใชใใ (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; | |
| } | |