
ãPHPå ¥éç·šã#7 ãšã³ãžãã¢ãã¬ãŒãã³ã°ç ä¿®ïŒVisual Studio CodeãGASïŒ
ååãWeek6ã§ã¯ããPHPå ¥éç·šã#6 ãšã³ãžãã¢ãã¬ãŒãã³ã°ç ä¿®ïŒæ²ç€ºæ¿å¶äœäœéšïŒããšé¡ããŠãäž»ã«ãWebã¢ããªéçºå ¥é PHP+MySQLç·š1: æ²ç€ºæ¿ãäœãããã®ããã°ã©ãã³ã°ã®åŠç¿å å®¹ãæŽçããŠã¢ãŠããããããŸããð»
ä»åã¯ããPHPå ¥éç·šã#7 ãšã³ãžãã¢ãã¬ãŒãã³ã°ç ä¿®ïŒVisual Studio CodeïŒãšé¡ããŠãäž»ã«VSCïŒHTMLïŒCSSïŒãçšããåºç€çãªã³ãŒãã£ã³ã°ãGASïŒGoogle Apps ScriptïŒã«ã€ããŠç°¡åã«æŽçããŠã¢ãŠããããããŠãããŸãð»
Visual Studio Codeãšã¯ïŒVSC)
Visual Studio CodeïŒããžã¥ã¢ã«ã»ã¹ã¿ãžãªã»ã³ãŒããéç§°ãVS CodeãïŒã¯ãMicrosoftãéçºããç¡æã®ã³ãŒããšãã£ã¿ïŒããã°ã©ãã³ã°çšã®é«æ©èœãªã¡ã¢åž³ïŒã§ãã
çŸåšãäžçäžã®Webãã¶ã€ããŒãããŒã±ã¿ãŒãããã°ã©ãã³ã°åŠç¿è ããããã®ãšã³ãžãã¢ãŸã§ãå§åçãªã·ã§ã¢ãèªã倧人æ°ããŒã«ã§ãã
è·æ¥èšç·Žã®Webãã¶ã€ã³ãããã°ã©ãã³ã°ïŒIfæãforæãªã©ã®ã³ãŒãã£ã³ã°ïŒã®è¬çŸ©ã§ããæåã®æé ãšããŠãã®VS Codeãã€ã³ã¹ããŒã«ããããšãéåžžã«å€ãã§ãã
ð¶Webãµã€ãã®æ§é ãVSCïŒHTML/CSSïŒã䜿ã£ãŠåçŸããæŒç¿
以äžð»ã®å³ãåèã«VSCã䜿çšããŠåçŸããåŠç¿ã«åãçµã¿ãŸããã

Let`s Tryãšããããšã§ããŸãã¯HTMLã§ãïŒããã¿ã³ãã¯ãªãã¯ãã
ïŒheadïŒã¿ã°ã®äžã«ïŒlinkïŒã¿ã°ïŒïŒlink rel="stylesheet" href="style_1.css"ïŒãæ¿å
¥ããŠCSSãšãªã³ã¯ããªããã°ãªããŸããã
ïŒbodyïŒã¿ã°ã®äžã«ïŒdivïŒèŠçŽ ãšããŠboxãçšæããŸãã
æåã«box1-box4ãŸã§äžŠã¹ãæã«ã©ãæ ãã®ã詊ããŠã¿ãŸããð¡ð»

CSSã§ã¯ä»¥äžð»ã®ããã«èšè¿°
èæ¯bodyã¯çœãboxã®åã«ã.ããã€ãå¿ãããšåå¿ããŸããã现ããªäœæ¥ã«ãªããŸããå¹
ïŒwidthïŒãšé«ãïŒheightïŒã®æå®ãšãbackground-colorã§ã¯é
è²ã®æå®ãå¯èœã§ãã

VSCã®å³äžã«ãããGO LIVEããã¿ã³ãã¯ãªãã¯ãããšèšè¿°ããã³ãŒãããµã€ããžåæ ãããŸãð»
以äžã®ããã«åæ ãããŸããããªãã»ã©ð¡
äžããäžãžããã¯ã¹ã®åœ¢ãè²ãªã©ãåæ ãããŠããããšãåãããŸãã

ä¿®æ£ïŒïŒãBoxãæŽãã
ãããšåæã«ã©ããã£ããªã¬ã³ãžboxãšã€ãšããŒboxãæšªäžŠã³ã«ãªãã®ãèããããããŸãð
詊è¡é¯èª€ãç¹°ãè¿ããªãã以äžã®ããã«ä¿®æ£èšè¿°ãããŠã¿ãŸããð»
<div class = "box2">ã®äžã«<div class = "box3">ãæ ŒçŽããŠ</div>ã§éããŠèšè¿°

CSSã以äžã®ããã«ä¿®æ£ð»
.box2ã®èšè¿°ãdisplay: flex; ãšæšªäžŠã³ã«ãªããã©ããããšwidthã§æšªå¹
ãåºããŠã¿ãŸãã

ãããšã以äžð»ã®ããã«åæ ãããŸãã
å°ããã€è¿ã¥ããŠããŸããð¡äºæ®µç®ã®è²ãå察ã«ãªããŸãããåœ¢ã¯æŽã£ãŠããŸãã

box2ãšbox3ã®è²ãå察ã«ããŠèšè¿°ä¿®æ£ãããšä»¥äžð»ã®ããã«åæ ãããŸãã
è¥å¹²å¹
ã®éããè²ãæ¿ãç®ã«ãªããŸããããåèå³éãã®æ§å³ã«ãªããŸããð¡

ä¿®æ£ïŒïŒãBoxãæšªäžŠã³ã«ä¿®æ£
ããã«ä¿®æ£ãå ããŸããæåã远å ããªããšãããŸããã
<div class = "wrapper">ã远å ããbox2ãšbox3ãæšªäžŠã³ã«æŽçããããã§ãããããŠãbox2ãšbox3ã®äžã«<p>ã¿ã°ã远å ãããsidebarããmaincontentããæåã远å ããŸãð»

CSSã远å ãä¿®æ£ãå ããŸãð»
box1-4ãŸã§ã®å¹
ãšé«ããåãããããæ°åãä¿®æ£ãã
.wrapper { display: flex }ã远å ããŠbox2ãšbox3ãæšªäžŠã³æå®ããŸã

ãããšç»é¢äžã«åèå³ã®ãããªã¬ã€ã¢ãŠããåæ ããããšãåºæ¥ãŸããð¡

ä¿®æ£ïŒïŒãæåäœçœ®ã®ä¿®æ£
æåŸã®èª¿æŽãè¡ããŸãã<p>ã¿ã°ã«ããæåããclass=ãã远å ããŠCSSã§åå¥ã«æåè²ãªã©ã®èª¿æŽãå¯èœã«ããŸãð»
<p class ="sidebar">sidebar</p>
<p class = "maincontent">maincontent</p>

CSSã§ã¯ã.maincontentãã.sidebarããšåããŠèª¿æŽããŸãããäžèº«ã¯äžç·ã«ããŠããŸãð»

ãããšç»é¢äžã«ã¯æåã®äœçœ®ãè²ãããŒãžã³ãããã£ã³ã°ãªã©ãåæ ããŠèŠæ ããè¯ããªããŸããð¡ð»

ãã®æ¥ã®è¬çŸ©ãããŸã§ã§ãããHTML/CSSã®åºç€ãæããããšã«ãã£ãŠããŒã ããŒãžã®æ§æèŠçŽ ãæ§ç¯ã§ããããšãçè§£ã§ããŸããð§ð
ð¶GASïŒGoogle Apps ScriptïŒ
GASã«ã€ããŠãåŠç¿ããŸããð»
GASïŒGoogle Apps ScriptïŒã°ãŒã°ã«ã»ã¢ããã¹ã»ã¹ã¯ãªããïŒãšã¯ãGoogleãæäŸããŠããåçš®ãµãŒãã¹ïŒã¹ãã¬ããã·ãŒããGmailããã©ã€ããã«ã¬ã³ããŒãªã©ïŒãèªååãããã飿ºããããã§ããããã°ã©ãã³ã°ç°å¢ã®ããšã§ãã
課é¡ïŒãç¿æ¥ã®Googleã«ã¬ã³ããŒã®äºå®ãèªåã«ã¡ãŒã«ã§éç¥ããåŠçãGASã§äœæããŠãã ãããã
ãŸãã¯èªåã§æ€çŽ¢ãAIã䜿ããªããæ§ç¯ããäœæ¥ãããŠã¿ãŸããã
ã»ã©ãããå§ããïŒ
äžçªç°¡åãªå§ãæ¹ã¯ãGoogleã¹ãã¬ããã·ãŒããéãããšã§ãã
ã¹ãã¬ããã·ãŒãã®ã¡ãã¥ãŒããŒã«ãããæ¡åŒµæ©èœããã¯ãªãã¯
ãApps Scriptããéžæ
ããã ãã§ãã³ãŒããå
¥åããå°çšã®ç»é¢ããã©ãŠã¶å
ã«éããŸãã
ãããšä»¥äžã®ããã«è¡šç€ºãããŸãð»

Webãã¶ã€ã³ãããŒã±ãã£ã³ã°ã®ã¹ãã«ã«å ããŠããã®ãGASã«ããèªååã»æ¥åå¹çåãã®ã¹ãã«ãå°ãã§ããããšãçŸå Žã§ã®äœæ¥ã¹ããŒããåçã«äžãããŸãããéå®ãããããšééããªãã®ããŒã«ã§ãã
â GASã«è²Œãä»ããã³ãŒã
IfæãforæïŒãŸãã¯forEachïŒãšãã£ãåºæ¬çãªæ§æã䜿ã£ãŠãã«ã¬ã³ããŒã®ããŒã¿ã1ã€ãã€åãåºããŠã¡ãŒã«ã®æç« ãäœæããŠãããŸãã
Geminiå çã«ããã³ãããå®è¡ããŠããã以äžã®ããã«ãã³ãã¬ãŒããæºåããŠããããŸããð»


ã»åãã®è§£èª¬
CalendarApp.getDefaultCalendar(): ããªãã®ãã©ã€ããŒãïŒã¡ã€ã³ïŒã®Googleã«ã¬ã³ããŒãèªåçã«æå®ããŸãã
if (events.length === 0): ç¿æ¥ã«äºå®ãã0ä»¶ãã ã£ãå Žåã®åŠçãIfæã§åããŠããŸãã
events.forEach(...): äºå®ãè€æ°ããå Žåãforæãšåãããã«1ä»¶ãã€ã¿ã€ãã«ãæéãåãåºããŠãã¡ãŒã«ã®æç« ïŒmailBodyïŒã«ã¬ããã£ã³ã³ãšçµåããŠãããŸãã
ã»èšå®ãšèªååã®æé
ã³ãŒãã貌ãä»ãããããæ¯ææ±ºãŸã£ãæéã«åæã«å®è¡ããããããã«ã¿ã€ããŒïŒããªã¬ãŒïŒãèšå®ããŸãã
ã¹ããã AïŒãã¹ãå®è¡ãšæš©éã®æ¿èªð»
GASç»é¢ã®äžéšã«ãããä¿åã¢ã€ã³ã³ïŒãããããŒãã£ã¹ã¯ã®ããŒã¯ïŒããæŒããŠä¿åããŸãã
å®è¡ãã颿°ã sendTomorrowCalendar ã«ãªã£ãŠããããšã確èªãããå®è¡ããã¿ã³ãæŒããŸãã
ååå®è¡æã®ã¿ããæ¿èªãå¿ èŠã§ãããšãããããã¢ãããåºãŸãã
ç»é¢ã®æç€ºã«åŸããèªåã®Googleã¢ã«ãŠã³ããéžã³ãã詳现ãâãïŒå®å šã§ã¯ãªãããŒãžïŒã«ç§»åããã¯ãªãã¯ããæåŸã«ãèš±å¯ããæŒããŸãã (â»èªåã§äœã£ãããã°ã©ã ãªã®ã§å®å šã§ã)
å®è¡ãå®äºããèªåã®Gmailã«ç¿æ¥ã®äºå®ïŒãŸãã¯äºå®ãªãã®éç¥ïŒãå±ãã確èªããŠãã ããã




ã¹ããã BïŒæ¯æèªåã§åãã¿ã€ããŒèšå®ïŒããªã¬ãŒïŒ
ããœã³ã³ãéããŠããŠããæ¯ææ±ºãŸã£ãæéã«ãã®ããã°ã©ã ãåãããã«ããŸãã
GASç»é¢ã®å·ŠåŽã«ããæèšã®ã¢ã€ã³ã³ïŒããªã¬ãŒïŒãã¯ãªãã¯ããŸãã
ç»é¢å³äžã«ãããããªã¬ãŒã远å ããã¿ã³ãæŒããŸãã
以äžã®ããã«èšå®ã倿ŽããŸãã
å®è¡ãã颿°ãéžæ: sendTomorrowCalendar
ã€ãã³ãã®ãœãŒã¹ãéžæ: ãæéäž»å°åã
æéããŒã¹ã®ããªã¬ãŒã®ã¿ã€ããéžæ: ãæ¥ä»ããŒã¹ã®ã¿ã€ããŒã
æå»ãéžæ: ãåå 6æïœ7æãïŒâ»ã奜ã¿ã®æé垯ã§OKã§ãïŒ
å³äžã®ãä¿åããæŒããŸãã
ããã§èšå®ã¯ãã¹ãŠå®äºã§ãïŒ
ã¹ãããBã¯èšå®ããŸããã§ããããä»åŸèªåãå¿
èŠã«å¿ããŠèšå®ããŠããããã®ããŒã«ãšããŠäœ¿ã£ãŠãããã§ããð¡
â ãææ¬¡ãµããªãã·ãŒããã¡ãŒã«ã§èªåã«éç¥ããGASäœæ
ã¹ãã¬ããã·ãŒãã«ããææ¬¡ãµããªïŒå£²äžéé¡ïŒãã¡ãŒã«ã§èªåã«éç¥ããGASäœæã®èª²é¡ã«ãåãçµã¿ãŸããã

å¿è«ãçžæ£ã¯Geminiæ§ã§ãã
Geminiæ§ã«ããã³ãããæã¡èŸŒã¿ãŸããð»
äžèšã¹ãã¬ããã·ãŒãã®ãææ¬¡ãµããªãã·ãŒãã®E1ã»ã«ã®å€ã«ä»æã®å£²äžéé¡ãèšå ¥ãããŠããŸãã
ãã®éé¡ãèªåã«ã¡ãŒã«ã§éç¥ããGASã®ã³ãŒããäœæããŠãã ããã
ïŒåæç¥èããªãåïŒäŒç€Ÿã«æå±ããŠæ¥åã§äœ¿çšããéã«ã¯æ
éã«æ±ãã¹ãã ãšæããŸãããå人ã§äœ¿ãåã«ã¯å¹çåã®æå³åãã§äŸ¿å©ã§ãð»

ã«ã¬ã³ããŒã®éç¥ã§ãè¡ã£ãããã«CopyïŒPasteã§å®è¡ããŠã¿ãŸããð»


ã»ã³ãŒãã®ãã€ã³ã
SpreadsheetApp.openById(): ã¹ãã¬ããã·ãŒãã®URLã«å«ãŸããŠããåºæã®IDã䜿ã£ãŠãçŽæ¥ãã¡ã€ã«ãéããŸããããã§ã¹ãã¬ããã·ãŒãã«çŽã¥ããŠããªããç¬ç«ããGASïŒã¹ã¿ã³ãã¢ãã³ïŒãããã§ãå®è¡å¯èœã§ãã
revenue.toLocaleString(): ååŸããæ°å€ãã1500000ãã ã£ãå Žåãã¡ãŒã«ã§èŠãããããã«ãÂ¥1,500,000ããšèªåã§ã«ã³ãåºåãã®åœ¢ã«æŽããåŠçãå ¥ããŠããŸãã
ã»èšå®ã®æé
ãã¹ãå®è¡: ã³ãŒããä¿åããäžéšã®ãå®è¡ããã¿ã³ãæŒããŸããååã¯ã¹ãã¬ããã·ãŒããžã®ã¢ã¯ã»ã¹ãšã¡ãŒã«éä¿¡ã®æš©éã®æ¿èªïŒã詳现ãâããã«ç§»åãâãèš±å¯ãïŒãæ±ããããŸãã®ã§ãç»é¢ã®æç€ºã«åŸã£ãŠæ¿èªããŠãã ããã
ããªã¬ãŒïŒèªååïŒã®èšå®: æ¯æ1åããããã¯æ¯æ¥æ±ºãŸã£ãæéã«ãã®éé¡ããã§ãã¯ããŠã¡ãŒã«ã欲ããå Žåã¯ãå·ŠåŽã®æèšããŒã¯ïŒããªã¬ãŒïŒãã以äžã®ããã«èšå®ããŠãã ããã
æ¯æ1åïŒææ«ãæåãªã©ïŒã«éç¥ãããå Žå:
ã€ãã³ãã®ãœãŒã¹:ãæéäž»å°åã
ããªã¬ãŒã®ã¿ã€ã:ãæããŒã¹ã®ã¿ã€ããŒã
æ¥ã«ã¡ã»æå»: ã奜ã¿ã®ã¿ã€ãã³ã°ãæå®
æ¯æ¥æ±ºãŸã£ãæéã«éç¥ãããå Žå:
ã€ãã³ãã®ãœãŒã¹:ãæéäž»å°åã
ããªã¬ãŒã®ã¿ã€ã:ãæ¥ä»ããŒã¹ã®ã¿ã€ããŒã
æå»:ãååŸ 6æã7æããªã©æ¥åçµäºã®ã¿ã€ãã³ã°
ããã§ãã¹ãã¬ããã·ãŒãã®ææ°ã®å£²äžç¶æ³ãèªåã§ã¡ãŒã«ããã¯ã¹ã«å±ãããã«ãªããŸãã
èªåãã¡ã§äœ¿ãåã«ã¯ã©ãã©ã䜿ããæ©èœãããã®ã§ãããäŒç€Ÿã§æ±ãå Žåãªã©ãå人æ
å ±æŒæŽ©ããªã©æ°ãã€ããªããã°ãªããŸããã
ð¶ãšã³ãžãã¢ç ä¿®æçµæ¥
VSCã䜿ã£ãŠãµã€ãå¶äœïŒæ§é ïŒæŒç¿ãšããŠèªåã§HTML/CSSã®ã³ãŒããæžããŠç°¡åãªãµã€ãæ§é å¶äœäœéšããŸããð»



以äžðºã®ããã«ã³ãŒããæžããŠå®è£ ãããšä»¥äžð»ã®ããã«ç»é¢äžã«è¡šç€ºãããŸããâª

以äžã§PHPïŒãšã³ãžãã¢ãã¬ãŒãã³ã°ç ä¿®ïŒã®åŠç¿ãçµäºãšãªããŸããâ
Week1-7ãéããŠãç°¡åãªããŒã ããŒãžå¶äœãè¡ãäžã§ã®åºç€ç¥èãããŒã¿ããŒã¹ãåãæ±ãéã®å¹çåãªã©ãå€å²ã«æž¡ã£ãŠç¥èãåŸãããšãåºæ¥ãŸããã
ãã®åŠãã ç¥èãããŒã¹ã«æ¬¡ã©ã掻ãããã¯èªå次第ã ãšèããŠããŸãð

ä»åãèªãã§ããã ããããããšãããããŸããðââïž
#ãšã³ãžãã¢ãã¬ãŒãã³ã°
#vsc
#visualstudiocode
#gas
#Google
#googleappscript
#ãªã¹ããªã³ã°