2020_06_12_135840_create_custom_fields_table.php 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. use App\CustomField;
  3. use Illuminate\Database\Migrations\Migration;
  4. use Illuminate\Database\Schema\Blueprint;
  5. use Illuminate\Support\Facades\Schema;
  6. class CreateCustomFieldsTable extends Migration
  7. {
  8. /**
  9. * Run the migrations.
  10. *
  11. * @return void
  12. */
  13. public function up()
  14. {
  15. Schema::create('custom_fields', function (Blueprint $table) {
  16. $table->id();
  17. $table->string('table')->index()->comment('定义目标的表');
  18. $table->string('field')->index()->comment('定义目标表的字段');
  19. $table->string('present_name')->index()->comment('所呈现的字段名');
  20. $table->string('authority_id')->comment('对应的权限');
  21. $table->string('condition_field')->nullable()->comment('条件字段,用来作为定义该字段权限和显示名的依据');
  22. $table->string('condition_value')->nullable()->comment('条件字段值,用来作为定义该字段权限和显示名的依据');
  23. $table->timestamps();
  24. });
  25. CustomField::create(['table'=>'rejected_bills','field'=>'common_01','present_name'=>'寄件方省','authority_id'=>$authority['id'],'condition_field'=>'id_owner','condition_value'=>'66']);
  26. CustomField::create(['table'=>'rejected_bills','field'=>'common_02','present_name'=>'退件重量','authority_id'=>$authority['id'],'condition_field'=>'id_owner','condition_value'=>'66']);
  27. }
  28. /**
  29. * Reverse the migrations.
  30. *
  31. * @return void
  32. */
  33. public function down()
  34. {
  35. Schema::dropIfExists('custom_fields');
  36. }
  37. }