LaraCSVで手軽にCSVを出力する/Easily generate CSV by LaraCSV

Transcript

1. 1.

   LaraCSVͰ खܰʹCSVΛग़ྗ͢Δ גࣜձࣾRe:Build Յ਺ ါىʢ@kkznchʣ 2019೥5݄16೔ʢ໦ʣ Laravel Meetup Miyazaki

2. 2.

   ͚͚ͣΜ @kkznch Յ਺ ါى 1990೥ͷԭೄੜ·Ε ిྗձࣾͷITΠϯϑϥɺηΩϡϦςΟ ↓ גࣜձࣾRe:BuildͰWebΤϯδχΞ

3. 3.

   ձࣾ঺հ • גࣜձࣾRe:Buildʢ2017೥11݄ʹઃཱʣ • ݱࡏͷࣾһ਺͸໊̑ • ԭೄΛڌ఺ͱ͠ɺجຊతʹ͸Laravel΍Vue.jsΛ ࢖ͬͯडୗɾࣗࣾαʔϏε։ൃΛ͍ͯ͠Δ • ϦϞʔτϫʔΫɺࣗ༝ͳಇ͖ํΛਪ঑͍ͯ͠Δ

4. 4.

   LaraCSV

5. 5.

   None
6. 6.

   ࢖͍ํ

7. 7.

   ϥΠϒϥϦΛ௥Ճ͢Δ # terminal͔ΒԼهͷίϚϯυΛ࣮ߦ͢Δ $ composer require usmanhalalit/laracsv:^2.0

8. 8.

   CSVͷϏϧυ // ΠϯελϯεΛੜ੒͢Δ $csvExporter = new \Laracsv\Export(); // ୈҰҾ਺ʹCollectionΛɺ //

   ୈೋҾ਺ʹCSVͰग़ྗ͍ͨ͠ϞσϧͷΧϥϜ໊Λೖྗ͢Δ $csvExporter->build(Users::get(), ['email', 'name']);
9. 9.

   CSVͷμ΢ϯϩʔυ // μ΢ϯϩʔυ͢Δ $csvExporter->download(); email,name rintaro@okarin.com,"Ԭ෦ ྙଠ࿠" mayuri@okarin.com,"௣໊ ·ΏΓ" itaru@okarin.com,"ڮా

   ࢸ" // ϑΝΠϧ໊Λࢦఆͯ͠μ΢ϯϩʔυ͢Δ $csvExporter->download('users.csv');
10. 10.

    ྑ͍ͱࢥͬͨͱ͜Ζ

11. 11.

    ϦϨʔγϣϯ΋औಘ͢Δ // Ϟσϧʹఆٛ͞Ε͍ͯΔϦϨʔγϣϯΛࢦఆ͢Δ͚ͩ $csvExporter->build(Users::get(), ['email', 'name', ‘department.name’]);

12. 12.

    ஋ͷ௥Ճɾมߋ͕Ͱ͖Δ $csvExporter->beforeEach(function($user) { // طଘͷ஋Λ্ॻ͖Ͱ͖Δ $user->email = 'hoge@piyo.com'; // ଘࡏ͠ͳ͍஋Λ௥ՃͰ͖Δ

    $user->note = $user->name . 'ϝϞͰ͢'; }); $csvExporter->build(User::get(), [‘email', 'name', ‘note'])->download(); email,name,note hoge@piyo.com,"Ԭ෦ ྙଠ࿠","Ԭ෦ ྙଠ࿠ϝϞͰ͢" hoge@piyo.com,"௣໊ ·ΏΓ","௣໊ ·ΏΓϝϞͰ͢"
13. 13.

    ࣮຿Ͱͷ࢖͍ॴ͸ʁ

14. 14.

    ࢖͍ॴ • τϥϯβΫγϣϯσʔλͷCSVग़ྗ • ܭࢉ݁ՌΛ֨ೲͨ͠࿈૝഑ྻͷCSVग़ྗ ‣ ഑ྻΛCollectionܕʹม׵ͯ͠౉͢ͱಈ͘

15. 15.

    CSVϥΠϒϥϦͷൺֱ

16. 16.

    CSVϥΠϒϥϦ ͍Ζ͍Ζ͋Δ

17. 17.

    Packalyst ʢCSVϥΠϒϥϦ DL਺߱ॱʣ

18. 18.

    ৮Γͭͭ଎౓Λൺֱͯ͠Έͨ

19. 19.

    ൺֱର৅ • laracsv • excel • laravel-formatter • fast-excel

20. 20.

    ࣮ݧ • string(255)ܕΧϥϜΛ10ݸ࣋ͭςʔϒϧ • Ϩίʔυ਺͸5120݅ • ֤ϥΠϒϥϦͰCSVϑΝΠϧΛग़ྗ͢Δ·Ͱ ͷ࣌ؒΛଌఆ͢Δ

21. 21.

    ݁Ռ ࣌ؒʢඵʣ ίϝϯτ MBSBDTW  ଎౓͸஗͍͕࢖͍উख͸Α͍ FYDFM  ग़ྗ͢ΔͨΊʹ&YQPSU༻ΫϥεΛ ༻ҙ͢Δඞཁ͕͋ͬͯ໘౗͍͘͞

    MBSBWFMGPSNBUUFS  ϑΥʔϚοτͷม׵͚ͩߦΘΕΔɻ ϑΝΠϧ΁ͷॻ͖ग़͠͸ཁࣗ࡞ GBTUFYDFM  ଌఆϛεͬͨͷ͔ͳʜ
    ϫϯϥΠφʔͰ$47ര଎ग़ྗ͸૲
22. 22.

    ·ͱΊ

23. 23.

    ·ͱΊ • LaraCSVͰखܰʹCSVͷग़ྗ͕Ͱ͖Δ ‣ ग़ྗ͢ΔΧϥϜͷࢦఆ͕༰қ ‣ ϦϨʔγϣϯઌͷ஋΋ࢦఆͰ͖Δ • ଎͞Λ௥ٻ͢Δ͋ͳͨ͸fast-excelΛͲ͏ͧ