<?php

namespace App\Admin\Extensions;

use Encore\Admin\Grid\Exporters\ExcelExporter;
use Maatwebsite\Excel\Concerns\WithMapping;
use App\Models\User;

class ChildrenExporter extends ExcelExporter implements WithMapping {
	protected $fileName = '学员信息.xlsx';
	protected $columns = [ 
			'realname' => '学员姓名',
			'endtime' => '到期时间',
			'sex' => '性别',
			'parent_id' => '家长姓名',
			'relation' => '家长电话'
	];
	public function map($children): array {
		return [ 
				$children->realname,
				$children->endtime,
				$children->sex == 1 ? '男' : '女',
				User::find($children->parent_id)->realname,
				User::find($children->parent_id)->mobile
		];
	}
}