migrate_water_enterprise_employee_count.php 908 B

1234567891011121314151617
  1. <?php
  2. /** Add headcount for platform replenishment estimates; never infer existing company sizes. */
  3. require dirname(__DIR__).'/vendor/autoload.php';
  4. \Dotenv\Dotenv::createUnsafeMutable(dirname(__DIR__))->load();
  5. \support\App::loadAllConfig(['route']);
  6. use plugin\saiadmin\app\model\water\WaterEnterprise;
  7. $schema=(new WaterEnterprise())->getConnection()->getSchemaBuilder();
  8. if (!in_array('--apply',$argv,true)) {
  9. echo "Plan: add nullable employee_count; existing enterprise headcounts remain unknown.\n";
  10. exit;
  11. }
  12. if (!$schema->hasColumn('sa_water_enterprise','employee_count')) {
  13. $schema->table('sa_water_enterprise',function (\Illuminate\Database\Schema\Blueprint $table) {
  14. $table->unsignedInteger('employee_count')->nullable()->comment('公司人数,NULL为未登记');
  15. });
  16. }
  17. echo "Applied: enterprise employee_count available; stock, entitlements and deliveries preserved.\n";