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

Transcript

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

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

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

4. LaraCSV

5. None

6. ࢖͍ํ

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

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

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

9. CSVͷμ΢ϯϩʔυ // μ΢ϯϩʔυ͢Δ $csvExporter->download(); email,name [email protected],"Ԭ෦ ྙଠ࿠" [email protected],"௣໊ ·ΏΓ" [email protected],"ڮా

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

10. ྑ͍ͱࢥͬͨͱ͜Ζ

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

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

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

13. ࣮຿Ͱͷ࢖͍ॴ͸ʁ

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

15. CSVϥΠϒϥϦͷൺֱ

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

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

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

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

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

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

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

22. ·ͱΊ

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