<?php

namespace app\admin\controller;

use support\Db;
use support\View;
use Illuminate\Support\Collection;

class Curd extends Base
{

    protected function getHeaders($table)
    {
        $schema = Db::select("select * from information_schema.COLUMNS where table_name = '" . $table . "' order by ORDINAL_POSITION");
        $headers = [];
        foreach ($schema as $key => $value) {
            if (!empty($value->COLUMN_COMMENT)) {
                $headers[$key]['column_name'] = $value->COLUMN_NAME;
                $headers[$key]['column_comment'] = $value->COLUMN_COMMENT;
            }
        }
        View::assign([
            'headers' => json_encode($headers)
        ]);
    }

    /**
     * 选项
     * @param Collection $collection 源数据
     * @param string $label 标签
     * @param string $value 值
     * @return Collection 选项数据
     */
    protected function option(Collection $collection, $label = 'name', $value = 'id')
    {
        return $collection->map(
            fn($item) => ['label' => $item->{$label}, 'value' => $item->{$value}]
        );
    }
}