ThreadsExport.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. namespace App\Exports;
  3. use Maatwebsite\Excel\Concerns\FromCollection;
  4. use Maatwebsite\Excel\Concerns\WithHeadings;
  5. class ThreadsExport implements FromCollection,WithHeadings
  6. {
  7. protected $data;
  8. public function __construct($data)
  9. {
  10. $this->data = $data;
  11. }
  12. /**
  13. * @return \Illuminate\Support\Collection
  14. */
  15. public function collection()
  16. {
  17. $collection = [];
  18. foreach ($this->data as $item){
  19. $contact = $item->contact?$item->contact->phone:'暂无联系人信息';
  20. $ower_name = $item->ower->real_name;
  21. $companyName = $item->company->companyName;
  22. $companyWebsite = $item->company->website;
  23. $regCapital = $item->company->regCapital;
  24. $lastest = $item->latestProgress();
  25. $created_at = $item->created_at;
  26. $collection[] = [
  27. $contact,$ower_name, $companyName,$companyWebsite,$regCapital,$lastest,$created_at
  28. ];
  29. }
  30. return collect($collection);
  31. }
  32. public function headings(): array
  33. {
  34. return [
  35. '联系方式',
  36. '线索拥有者',
  37. '企业名字',
  38. '企业网站',
  39. '注册资本(万)',
  40. '最新跟进',
  41. '领取时间',
  42. ];
  43. }
  44. }