crm/protected/include/DBTable.php

<?php
class DBTable {

    public string $name;
    public string $tableName;
    public array $columnArray;
    public string $line = '<br/>';

    const array FORM_EXCLUDE_COLUMNS = ['create_date', 'update_date', 'is_del', 'id', 'city', 'area', 'province', 'last_user_id', 'last_date'];
    const array INFO_EXCLUDE_COLUMNS = ['create_date', 'update_date', 'is_del'];
    const array TABLE_EXCLUDE_COLUMNS = ['create_date', 'update_date', 'is_del'];
    const array DETAIL_EXCLUDE_COLUMNS = ['is_del'];
    public function __construct(string $name) {
        $this->name = strtolower($name);
        $this->tableName = DB::formTableName($name);
        $sql = "show full columns from {$this->tableName }";
        $this->columnArray = \Yii::app()->db->createCommand($sql)->queryAll();
        if (!$this->columnArray) {
            Helper::error('该表不存在');
        }
    }

    public function echoEditPhp(): void
    {
        $notNullField = [];
        $allowEmptyField = [];
        echo '$data = [' . $this->line;
        foreach ($this->columnArray as $column) {
            if (in_array($column['Field'], self::FORM_EXCLUDE_COLUMNS)) {
                continue;
            }
            $name = $column['Field'];
            $tmpl = "'{$name}' => Helper::{{method}}('{$name}')," . $this->line;
            if (Helper::hasAnyString($column['Type'], ['decimal', 'double', 'float'])) {
                $method = 'getPostFloat';
            } elseif (Helper::hasAnyString($column['Type'], ['int'])) {
                $method = 'getPostInt';
            } elseif (Helper::hasAnyString($column['Type'], ['datetime'])) {
                $method = 'getPostDatetime';
            } elseif (Helper::hasAnyString($column['Type'], ['date'])) {
                $method = 'getPostDate';
            } else {
                $method = 'getPostString';
            }
            echo str_replace('{{method}}', $method, $tmpl);
            if ($column['Null'] == 'NO') {
                $notNullField[] = $name;
            }
            if ($column['Default'] != null || $method == 'getPostInt') {
                $allowEmptyField[] = $name;
            }
        }
        echo '];' . $this->line . $this->line;
        echo '$notNullField = ' . json_encode($notNullField) . ';' . $this->line;
        echo '$allowEmptyField = ' . json_encode($allowEmptyField) . ';' . $this->line;
    }

    public function editVue()
    {
        $formDefault = $this->getFormDefault(false);
        list($template, $rule) = $this->getFormAndRule();
        $editTmpl = str_replace(
            ['{{template}}', '{{table}}', '{{formDefault}}', '{{formRule}}', '{{ucTable}}'],
            [$template, $this->name, $formDefault, $rule, ucfirst($this->name)],
            file_get_contents(RUNTIME_PATH . '/edit.tmpl')
         );
        $filePath = RUNTIME_PATH . "/edit.vue";
        file_put_contents($filePath, $editTmpl);
        // 格式化代码
        echo "<h4>命令后执行下面代码</h4>";
        echo "<p style='color: red;'>npx prettier --write $filePath</p>";
    }

    public function echoDetail()
    {
        echo $this->getFormDefault();
        list($template, $rule) = $this->getFormAndRule();
    }

    /**
     * 生成ts接口
     * @return string
     */
    public function getTsInterFace(): string
    {
        $content = '';
        foreach ($this->columnArray as $column) {
            if (in_array($column['Field'], self::INFO_EXCLUDE_COLUMNS)) {
                continue;
            }
            $content.= (new DBColumn($column))->getTsDefine() . $this->line;
        }
        $template = <<<typescript
interface {$this->name} { {$this->line}
$content} {$this->line} {$this->line}
typescript;

        return $template;
    }

    /**
     * 生成form默认值
     * @return string
     */
    private function getFormDefault($withLine = true): string
    {
        $content = '';
        $line = $withLine ? $this->line : '';
        foreach ($this->columnArray as $column) {
            if (in_array($column['Field'], self::FORM_EXCLUDE_COLUMNS)) {
                continue;
            }
            $content.= (new DBColumn($column))->getDefaultValue() . $line;
        }
        return $content;
    }

    /**
     * 生成form验证规则 前后端需要保持一致
     * @return array
     */
    private function getFormAndRule(): array
    {
        $html = '';
        $ruleHtml = '';
        foreach ($this->columnArray as $column) {
            if (in_array($column['Field'], self::FORM_EXCLUDE_COLUMNS)) {
                continue;
            }
            list($template, $rule) = (new DBColumn($column))->getFormHtmlAndRule();
            $html.= $template;
            $ruleHtml.= $rule;
        }
        $content =  <<<typescript
<template>
    <ElForm ref="formRef" :model="formData" :rules="rules" label-width="auto">
    <el-row :gutter="20">
      {$html}
      <el-col :span="24">
        <ElFormItem label=" " prop="">
          <ElButton type="primary" @click="handleSubmit">提交</ElButton>
        </ElFormItem>
      </el-col>
      </el-row>
    </ElForm>
</template>
typescript;

        return [$content, $ruleHtml];
    }

    /**
     * 生成详情
     * @return array
     */
    public function getDetailHtml(): string
    {
        echo $this->getFormDefault();
        $html = '';
        foreach ($this->columnArray as $column) {
            if (in_array($column['Field'], self::DETAIL_EXCLUDE_COLUMNS)) {
                continue;
            }
            $html.= (new DBColumn($column))->getDetailHtml();
        }
        $content =  <<<typescript
<template>
  <div>
    <el-row :gutter="20" class="detail">
    {$html}
    </el-row>
  </div>
</template>
typescript;
        file_put_contents(PROJECT_PATH . "/protected/runtime/detail.vue", $content);
        return $content;
    }


    /**
     * 生成table字段配置
     * @return string
     */
    public function getTableHtml(): string
    {
        $tableContent = '';
        foreach ($this->columnArray as $column) {
            if (in_array($column['Field'], self::TABLE_EXCLUDE_COLUMNS)) {
                continue;
            }
            $arr = (new DBColumn($column))->getTableAttr();
            $tableContent.= $this->getHtmlWithJsTableArr($arr);
        }
        $template = <<<typescript
$tableContent
typescript;
        return $template;
    }

    private function getHtmlWithJsTableArr(array $arr): string
    {
        if (!$arr) {
            return '';
        }
        $str = '{';
        foreach ($arr as $k => $v) {
            $str.= " {$k}:'{$v}',";
        }
        return trim($str, ',') . ' },' . $this->line;
    }
}