Tweet
Tweet

Slide 1

Slide 1 text

Sheetsu #symfony_meetup 2017.08.27 @ttskch

Slide 2

Slide 2 text

@ttskchʢ͖ͨͭͪʣ • ໊ݹ԰͔Βདྷ·ͨ͠ • ΧϧςοτίϛϡχέʔγϣϯζCTO • PHPྺ5.5೥ɺSymfonyྺ3೥ʢROMઐʣ • গ͚͓ͩ͠ख఻͍͠·ͨ͠

Slide 3

Slide 3 text

Χϧςοτίϛϡχέʔγϣϯζ • ઈࢍPHPerେืूதʂ • ϦεςΟϯά޿ࠂӡ༻πʔϧʮLisketʯΛఏڙ • ࣌୅ΛઌऔΔϗϫΠτاۀͰ͢

Slide 4

Slide 4 text

ΤϯδχΞͷಇ͖΍͢͞௒େࣄʹͯ͠·͢ Χϧςοτίϛϡχέʔγϣϯζ

Slide 5

Slide 5 text

SNS͔ϝʔϧͰ͓ؾܰʹ͝࿈བྷ͍ͩ͘͞✨ Χϧςοτίϛϡχέʔγϣϯζ

Slide 6

Slide 6 text

Sheetsu #symfony_meetup 2017.08.27 @ttskch

Slide 7

Slide 7 text

sheetsu.com

Slide 8

Slide 8 text

sheetsu.com

Slide 9

Slide 9 text

sheetsu.com

Slide 10

Slide 10 text

sheetsu.com

Slide 11

Slide 11 text

sheetsu.com

Slide 12

Slide 12 text

$client = new \GuzzleHttp\Client(); $client ->post('https://sheetsu.com/apis/v1.0/xxxxxxxxxxxx', [ 'json' => [ 'id' => 6, 'name' => 'ttskch', 'score' => 100, ], ]); sheetsu.com

Slide 13

Slide 13 text

sheetsu.com

Slide 14

Slide 14 text

ʘศརʂʂʂʗ

Slide 15

Slide 15 text

ͱ͜Ζ͕͋Δ೔

Slide 16

Slide 16 text

402 Payment Required

Slide 17

Slide 17 text

͑ͬ

Slide 18

Slide 18 text

No content

Slide 19

Slide 19 text

͑ͬ

Slide 20

Slide 20 text

No content

Slide 21

Slide 21 text

ͳΜ͔ແྉϓϥϯ͕ ͠Εͬͱͳ͘ͳͬͯͨ ʘ(^o^)ʗ

Slide 22

Slide 22 text

ͱ͍͏Θ͚Ͱ

Slide 23

Slide 23 text

ttskch/pheetsu

Slide 24

Slide 24 text

ͷɺ࿩Λ͔ͨͬͨ͠ͷͰ͕͢

Slide 25

Slide 25 text

ͷɺ࿩Λ͔ͨͬͨ͠ͷͰ͕͢

Slide 26

Slide 26 text

ͷɺ࿩Λ͔ͨͬͨ͠ͷͰ͕͢

Slide 27

Slide 27 text

ؒʹ߹͍·ͤΜͰͨ͠ ʘ(^o^)ʗ

Slide 28

Slide 28 text

$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ʢ༧ఆʣ

Slide 29

Slide 29 text

σϞ͸ಈ͖·͢ʂʢreadͷΈʣ https://github.com/ttskch/pheetsu/tree/master/demo

Slide 30

Slide 30 text

׬੒ͨ͠Β ࢖ͬͯΈ͍ͯͩ͘͞

Slide 31

Slide 31 text

͓·͚

Slide 32

Slide 32 text

ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠ • ྫɿ3→Cɺ30→AD • ͸͍͸͍ɺ26ਐ਺Ͷ • ͭ

Slide 33

Slide 33 text

$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; ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠

Slide 34

Slide 34 text

$number = 3; // -> C ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠

Slide 35

Slide 35 text

$number = 3; // -> C $number = 30; // -> AD ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠

Slide 36

Slide 36 text

$number = 3; // -> C $number = 30; // -> AD $number = 26; // -> A0 ͑ͬ ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠

Slide 37

Slide 37 text

$number = 3; // -> C $number = 30; // -> AD $number = 26; // -> A0 ͑ͬ // Z ʹͳͬͯ΄͔ͬͨ͠ͷʹ… ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠

Slide 38

Slide 38 text

$from = '0123456789abcdefghijklmnop'; $to = '0ABCDEFGHIJKLMNOPQRSTUVWXY'; ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠

Slide 39

Slide 39 text

$from = '0123456789abcdefghijklmnop'; $to = '0ABCDEFGHIJKLMNOPQRSTUVWXY'; ͋ͬɾɾɾʢ࡯͠ʣ ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠

Slide 40

Slide 40 text

Α͔ͬͨΒ಄ͷମૢʹ ղ͍ͯΈ͍ͯͩ͘͞

Slide 41

Slide 41 text

࣮૷ྫ https://github.com/ttskch/pheetsu/blob/ master/src/Service/ColumnNameResolver.php ΋ͬͱΤϨΨϯτͳղ๏͋ͬͨΒڭ͍͑ͯͩ͘͞

Slide 42

Slide 42 text

Thanks :)