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

Laravel Meetup宮崎
登壇枠で使用

参考URL
https://re-build.connpass.com/event/129466/

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
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 rintaro@okarin.com,"Ԭ෦ ྙଠ࿠" mayuri@okarin.com,"௣໊ ·ΏΓ" itaru@okarin.com,"ڮా ࢸ" // ϑΝΠϧ໊Λࢦఆͯ͠μ΢ϯϩʔυ͢Δ $csvExporter->download('users.csv');
10. ྑ͍ͱࢥͬͨͱ͜Ζ
11. ϦϨʔγϣϯ΋औಘ͢Δ // Ϟσϧʹఆٛ͞Ε͍ͯΔϦϨʔγϣϯΛࢦఆ͢Δ͚ͩ $csvExporter->build(Users::get(), ['email', 'name', ‘department.name’]);
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. ࣮຿Ͱͷ࢖͍ॴ͸ʁ
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ΛͲ͏ͧ