Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Sheetsu
Search
Takashi Kanemoto
August 27, 2017
Programming
0
450
Sheetsu
Symfony Meetup #17 LT 資料
https://symfony.connpass.com/event/63659/
Takashi Kanemoto
August 27, 2017
Tweet
Share
More Decks by Takashi Kanemoto
See All by Takashi Kanemoto
FigmaとPHPで作る1ミリたりとも表示崩れしない最強の帳票印刷ソリューション
ttskch
44
20k
データベース/SQL超入門!完全初心者向けに世界一分かりやすく解説します
ttskch
1
3.3k
Symfony UX Autocompleteとかいう 顧客が本当に必要だったもの
ttskch
0
1.4k
就活生あるいは新人エンジニアさんへのお節介なアドバイス
ttskch
0
1.3k
symfony/pantherでWordleを解いてみた
ttskch
0
200
ついに、Webアプリでの帳票印刷のベストプラクティスを編み出しました💡
ttskch
16
19k
phpenvやめました🤦♂️
ttskch
0
790
PHPでCSVのインポート/エクスポートに立ち向かう
ttskch
1
1.9k
phpenv on Mac 難しすぎワロタ
ttskch
0
490
Other Decks in Programming
See All in Programming
TypeScriptの型とパフォーマンス (TSKaigi 2024)
ypresto
14
4.5k
Native Federation: The Future of Micro Frontends in Angular
manfredsteyer
PRO
0
170
Namespace, What and Why
tagomoris
3
670
TypeScriptでもLLMアプリケーション開発 / LLM Application In Typescript
rkaga
5
1.3k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
1
130
Jetpack Composeとデザインシステム
rmakiyama
0
230
Ruby on Fails - effective error handling with Rails conventions
talyssonoc
0
300
Open standards for building event-driven applications in the cloud
meteatamel
0
230
ServerAction で Progressive Enhancement はどこまで頑張れるか? / progressive-enhancement-with-server-action
takefumiyoshii
6
510
Findy - エンジニア向け会社紹介 / Findy Letter for Engineers
findyinc
2
74k
TCAとKMPを用いた新規動画配信アプリ 「ABEMA Live」の設計
tomu28
2
140
HonoのRPCで真の型安全が欲しかった
kosei28
0
120
Featured
See All Featured
Rails Girls Zürich Keynote
gr2m
91
13k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
21
2k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
221
21k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
83
45k
Java REST API Framework Comparison - PWX 2021
mraible
PRO
18
7k
Product Roadmaps are Hard
iamctodd
45
9.8k
Bash Introduction
62gerente
605
210k
The Invisible Customer
myddelton
114
12k
A Philosophy of Restraint
colly
197
16k
The Brand Is Dead. Long Live the Brand.
mthomps
49
30k
GraphQLとの向き合い方2022年版
quramy
33
13k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
20
1.8k
Transcript
Sheetsu #symfony_meetup 2017.08.27 @ttskch
@ttskchʢ͖ͨͭͪʣ • ໊ݹ͔Βདྷ·ͨ͠ • ΧϧςοτίϛϡχέʔγϣϯζCTO • PHPྺ5.5ɺSymfonyྺ3ʢROMઐʣ • গ͚͓ͩ͠ख͍͠·ͨ͠
Χϧςοτίϛϡχέʔγϣϯζ • ઈࢍPHPerେืूதʂ • ϦεςΟϯάࠂӡ༻πʔϧʮLisketʯΛఏڙ • ࣌ΛઌऔΔϗϫΠτاۀͰ͢
ΤϯδχΞͷಇ͖͢͞େࣄʹͯ͠·͢ Χϧςοτίϛϡχέʔγϣϯζ
SNS͔ϝʔϧͰ͓ؾܰʹ͝࿈བྷ͍ͩ͘͞✨ Χϧςοτίϛϡχέʔγϣϯζ
Sheetsu #symfony_meetup 2017.08.27 @ttskch
sheetsu.com
sheetsu.com
sheetsu.com
sheetsu.com
sheetsu.com
$client = new \GuzzleHttp\Client(); $client ->post('https://sheetsu.com/apis/v1.0/xxxxxxxxxxxx', [ 'json' => [
'id' => 6, 'name' => 'ttskch', 'score' => 100, ], ]); sheetsu.com
sheetsu.com
ʘศརʂʂʂʗ
ͱ͜Ζ͕͋Δ
402 Payment Required
͑ͬ
None
͑ͬ
None
ͳΜ͔ແྉϓϥϯ͕ ͠Εͬͱͳ͘ͳͬͯͨ ʘ(^o^)ʗ
ͱ͍͏Θ͚Ͱ
ttskch/pheetsu
ͷɺΛ͔ͨͬͨ͠ͷͰ͕͢
ͷɺΛ͔ͨͬͨ͠ͷͰ͕͢
ͷɺΛ͔ͨͬͨ͠ͷͰ͕͢
ؒʹ߹͍·ͤΜͰͨ͠ ʘ(^o^)ʗ
$pheetsu = \Ttskch\Pheetsu\Factory\PheetsuFactory::create( 'google_oauth2_client_id', 'google_oauth2_client_secret', 'google_oauth2_redirect_uri', 'google_oauth2_javascript_origin', 'spreadsheet_id', 'sheet_name' );
$pheetsu->authenticate(); $pheetsu->create([ 'id' => 6, 'name' => 'ttskch', 'score' => 100, ]); Usageʢ༧ఆʣ
σϞಈ͖·͢ʂʢreadͷΈʣ https://github.com/ttskch/pheetsu/tree/master/demo
ͨ͠Β ͬͯΈ͍ͯͩ͘͞
͓·͚
ྻ൪߸ˠྻ໊ͷม͕ҙ֎ͱ͔ͬͨ͠ • ྫɿ3→Cɺ30→AD • ͍͍ɺ26ਐͶ • ͭ
$base26 = base_convert($number, 10, 26); $from = '0123456789abcdefghijklmnop'; $to =
'0ABCDEFGHIJKLMNOPQRSTUVWXY'; $name = ''; foreach (str_split($base26) as $digit) { $digit = substr($to, strpos($from, $digit), 1); $name .= $digit; } echo $name . PHP_EOL; ྻ൪߸ˠྻ໊ͷม͕ҙ֎ͱ͔ͬͨ͠
$number = 3; // -> C ྻ൪߸ˠྻ໊ͷม͕ҙ֎ͱ͔ͬͨ͠
$number = 3; // -> C $number = 30; //
-> AD ྻ൪߸ˠྻ໊ͷม͕ҙ֎ͱ͔ͬͨ͠
$number = 3; // -> C $number = 30; //
-> AD $number = 26; // -> A0 ͑ͬ ྻ൪߸ˠྻ໊ͷม͕ҙ֎ͱ͔ͬͨ͠
$number = 3; // -> C $number = 30; //
-> AD $number = 26; // -> A0 ͑ͬ // Z ʹͳͬͯ΄͔ͬͨ͠ͷʹ… ྻ൪߸ˠྻ໊ͷม͕ҙ֎ͱ͔ͬͨ͠
$from = '0123456789abcdefghijklmnop'; $to = '0ABCDEFGHIJKLMNOPQRSTUVWXY'; ྻ൪߸ˠྻ໊ͷม͕ҙ֎ͱ͔ͬͨ͠
$from = '0123456789abcdefghijklmnop'; $to = '0ABCDEFGHIJKLMNOPQRSTUVWXY'; ͋ͬɾɾɾʢ͠ʣ ྻ൪߸ˠྻ໊ͷม͕ҙ֎ͱ͔ͬͨ͠
Α͔ͬͨΒ಄ͷମૢʹ ղ͍ͯΈ͍ͯͩ͘͞
࣮ྫ https://github.com/ttskch/pheetsu/blob/ master/src/Service/ColumnNameResolver.php ͬͱΤϨΨϯτͳղ๏͋ͬͨΒڭ͍͑ͯͩ͘͞
Thanks :)