Symfony Meetup #17 LT 資料 https://symfony.connpass.com/event/63659/
Sheetsu#symfony_meetup 2017.08.27 @ttskch
View Slide
@ttskchʢ͖ͨͭͪʣ• ໊ݹ͔Βདྷ·ͨ͠• ΧϧςοτίϛϡχέʔγϣϯζCTO• PHPྺ5.5ɺSymfonyྺ3ʢROMઐʣ• গ͚͓ͩ͠ख͍͠·ͨ͠
Χϧςοτίϛϡχέʔγϣϯζ• ઈࢍPHPerେืूதʂ• ϦεςΟϯάࠂӡ༻πʔϧʮLisketʯΛఏڙ• ࣌ΛઌऔΔϗϫΠτاۀͰ͢
ΤϯδχΞͷಇ͖͢͞େࣄʹͯ͠·͢Χϧςοτίϛϡχέʔγϣϯζ
SNS͔ϝʔϧͰ͓ؾܰʹ͝࿈བྷ͍ͩ͘͞✨Χϧςοτίϛϡχέʔγϣϯζ
sheetsu.com
$client = new \GuzzleHttp\Client();$client->post('https://sheetsu.com/apis/v1.0/xxxxxxxxxxxx', ['json' => ['id' => 6,'name' => 'ttskch','score' => 100,],]);sheetsu.com
ʘศརʂʂʂʗ
ͱ͜Ζ͕͋Δ
402 Payment Required
͑ͬ
ͳΜ͔ແྉϓϥϯ͕͠Εͬͱͳ͘ͳͬͯͨʘ(^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 :)
ttskch
ivargrimstad
miciek
kishida
morikann
zakky21
takefumiyoshii
sanfrecce_osaka
yuhei_fujita
ivanova1991
rmatsuoka
palkan
.png){kind=avatar}
melonattacker
philhawksworth
jmmastey
addyosmani
lauravandoore
destraynor
jeffersonlam
marcduiker
iamctodd
yeseniaperezcruz
jensimmons
dougneiner