Sheetsu

Transcript

1. 1.

   Sheetsu #symfony_meetup 2017.08.27 @ttskch

2. 2.

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

3. 3.

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

4. 4.

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

5. 5.

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

6. 6.

   Sheetsu #symfony_meetup 2017.08.27 @ttskch

7. 7.

   sheetsu.com

8. 8.

   sheetsu.com

9. 9.

   sheetsu.com

10. 10.

    sheetsu.com

11. 11.

    sheetsu.com

12. 12.

    $client = new \GuzzleHttp\Client(); $client ->post('https://sheetsu.com/apis/v1.0/xxxxxxxxxxxx', [ 'json' => [

    'id' => 6, 'name' => 'ttskch', 'score' => 100, ], ]); sheetsu.com
13. 13.

    sheetsu.com

14. 14.

    ʘศརʂʂʂʗ

15. 15.

    ͱ͜Ζ͕͋Δ೔

16. 16.

    402 Payment Required

17. 17.

    ͑ͬ

18. 18.

    None
19. 19.

    ͑ͬ

20. 20.

    None
21. 21.

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

22. 22.

    ͱ͍͏Θ͚Ͱ

23. 23.

    ttskch/pheetsu

24. 24.

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

25. 25.

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

26. 26.

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

27. 27.

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

28. 28.

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

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

30. 30.

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

31. 31.

    ͓·͚

32. 32.

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

33. 33.

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

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

35. 35.

    $number = 3; // -> C $number = 30; //

    -> AD ྻ൪߸ˠྻ໊ͷม׵͕ҙ֎ͱ೉͔ͬͨ͠
36. 36.

    $number = 3; // -> C $number = 30; //

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

    $number = 3; // -> C $number = 30; //

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

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

39. 39.

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

40. 40.

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

41. 41.

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

42. 42.

    Thanks :)