public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->string('name'); $t->unsignedInteger('hospital_id'); $t->unsignedInteger('department_id'); $t->integer('cust_id')->unsigned()->unique(); $t->string('title'); $t->integer('level'); $t->text('memo')->nullable(); $t->string('wechat_id')->nullable(); $t->string('phone')->nullable(); $t->string('email')->nullable(); $t->smallInteger('gender')->nullable()->default(1); $t->smallInteger('status')->default(1); $t->softDeletes(); $t->timestamps(); $t->foreign('hospital_id')->references('id')->on('i_hospital')->onDelete('cascade'); $t->foreign('department_id')->references('id')->on('i_department')->onDelete('cascade'); }); $count = 1000; for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['name' => str_random(2) . ' ' . str_random(2), 'department_id' => rand(1, 400), 'hospital_id' => rand(1, 400), 'cust_id' => 1000000 + $i, 'title' => str_random(10), 'level' => rand(1, 5), 'phone' => rand(13000000000.0, 13999999999.0), 'email' => str_random(3) . '@' . str_random(2) . '.com', 'status' => rand(1, 3), 'memo' => str_random(200)]); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->text('name'); $t->text('name_in_charge'); $t->integer('city_id')->unsigned(); $t->integer('province_id')->unsigned(); $t->text('location_detail'); $t->string('username')->unique(); $t->string('password'); $t->string('phone')->nullable(); $t->string('email')->nullable(); $t->date('started_at')->nullable(); $t->date('ended_at')->nullable(); $t->smallInteger('status')->default(1); // 0为冻结账户 $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); }); $count = 1000; db_c($this->ins_name, 'i', ['id' => 1, 'name' => '自营', 'name_in_charge' => str_random(2) . ' ' . str_random(2), 'location_detail' => str_random(100), 'started_at' => date("Y-m-d H:i:s", 1440560208), 'ended_at' => date("Y-m-d H:i:s", 1840560208), 'city_id' => rand(36, 398), 'province_id' => rand(2, 35), 'username' => $this->ins_name . 'self', 'password' => hash_password($this->ins_name . 'self'), 'phone' => rand(13000000000.0, 13999999999.0), 'email' => str_random(3) . '@' . str_random(3) . '.com', 'memo' => str_random(200), 'status' => rand(0, 1)]); for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['name' => str_random(2) . '集团', 'name_in_charge' => str_random(2) . ' ' . str_random(2), 'location_detail' => str_random(100), 'started_at' => date("Y-m-d H:i:s", mt_rand(1161302400, 1440560208)), 'ended_at' => date("Y-m-d H:i:s", mt_rand(1161302400, 1440560208) + rand(1000000, 999999999)), 'city_id' => rand(36, 398), 'province_id' => rand(2, 35), 'username' => $this->ins_name . $i, 'password' => hash_password($this->ins_name . $i), 'phone' => rand(13000000000.0, 13999999999.0), 'email' => str_random(3) . '@' . str_random(3) . '.com', 'memo' => str_random(200), 'status' => rand(0, 1)]); } }
public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->string('cust_id')->unique(); $t->smallInteger('status')->default(1); $t->smallInteger('sold')->default(0); $t->unsignedInteger('replacement_id')->nullable(); $t->unsignedInteger('doctor_id')->nullable(); $t->unsignedInteger('agency_id'); $t->unsignedInteger('hospital_id')->nullable(); $t->unsignedInteger('robot_id')->nullable(); $t->string('surgery_type')->nullable(); $t->dateTime('surgery_at')->nullable(); $t->unsignedInteger('patient_id')->nullable(); $t->dateTime('sold_at')->nullable(); $t->dateTime('used_at')->nullable(); $t->dateTime('damaged_at')->nullable(); $t->dateTime('archive_at')->nullable(); $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); //$t->foreign('replacement_id')->references('id')->on('i_mark'); $t->foreign('doctor_id')->references('id')->on('i_doctor')->onDelete('cascade'); $t->foreign('agency_id')->references('id')->on('i_agency')->onDelete('cascade'); $t->foreign('hospital_id')->references('id')->on('i_hospital')->onDelete('cascade'); $t->foreign('robot_id')->references('id')->on('i_robot')->onDelete('cascade'); }); $count = 3000; $d = []; function sold_at($used_at) { if ($used_at) { return date("Y-m-d H:i:s", mt_rand(1161302400, 1440560208)); } return null; } //function replacement_id() //{ // if ( ! empty($d['damaged_at'])) // { // $rand_id = [null, rand(1, 3000)]; // return $rand_id[rand(0, count($rand_id) - 1)]; // } // return null; //} for ($i = 0; $i < $count; $i++) { $status_set = [-1, 2, 3, 4]; $sold_set = [0, 1]; $rand_date = [null, date("Y-m-d H:i:s", mt_rand(1161302400, 1440560208))]; //$sold_date = date("Y-m-d H:i:s", mt_rand(1161302400, 1440560208)); //$damaged_at = [null, date($sold_date + rand(190000, 390000))]; $d = ['cust_id' => uniqid(), 'status' => rand(1, 4), 'replacement_id' => rand(1, 3000), 'used_at' => $used_at = $rand_date[rand(0, count($rand_date) - 1)], 'sold_at' => sold_at($used_at), 'damaged_at' => $rand_date[rand(0, count($rand_date) - 1)], 'robot_id' => rand(1, 1000), 'agency_id' => rand(1, 1000), 'doctor_id' => rand(1, 500), 'hospital_id' => rand(1, 400), 'memo' => str_random(500)]; db_c($this->ins_name, 'i', $d); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->string('cust_id')->unique(); $t->dateTime('production_date'); $t->unsignedInteger('employee_id'); $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); $t->foreign('employee_id')->references('id')->on('i_employee')->onDelete('cascade'); }); $count = 1000; for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['production_date' => \Carbon\Carbon::now(), 'cust_id' => uniqid(), 'employee_id' => rand(1, 100), 'memo' => str_random(500)]); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->dateTime('at'); $t->unsignedInteger('action_type_id'); $t->unsignedInteger('ins_type_id'); $t->unsignedInteger('related_id'); $t->unsignedInteger('operator_type'); $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); }); $count = 1000; for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['at' => date("Y-m-d H:i:s", mt_rand(1161302400, 1440560208)), 'action_type_id' => rand(1, 10), 'ins_type_id' => rand(1, 10), 'related_id' => rand(1, 1000), 'operator_type' => rand(1, 5), 'memo' => str_random(500)]); } }
public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->string('name'); $t->string('username')->unique(); $t->string('password'); $t->integer('hospital_id')->unsigned(); $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); $t->foreign('hospital_id')->references('id')->on('i_hospital')->onDelete('cascade'); }); $count = 400; for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['name' => str_random(2) . $i . '科', 'username' => 'department' . $i, 'password' => hash_password('department' . $i), 'hospital_id' => rand(1, 400), 'memo' => str_random(200)]); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->integer('action_type_id')->default(1); $t->unsignedInteger('robot_id'); $t->unsignedInteger('employee_id'); $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); $t->foreign('robot_id')->references('id')->on('i_robot')->onDelete('cascade'); $t->foreign('employee_id')->references('id')->on('i_employee')->onDelete('cascade'); }); $count = 1000; for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['employee_id' => rand(1, 100), 'robot_id' => rand(1, 1000), 'action_type_id' => rand(1, 3), 'memo' => str_random(500)]); } }
public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->text('name'); $t->integer('city_id')->unsigned(); $t->integer('province_id')->unsigned(); $t->text('location_detail'); $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); }); db_c($this->ins_name, 'i', ['name' => '自有', 'city_id' => rand(36, 398), 'province_id' => rand(2, 35), 'location_detail' => str_random(100), 'memo' => str_random(500)]); $count = 400; for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['name' => str_random(2) . '第' . $i . '医院', 'city_id' => rand(36, 398), 'province_id' => rand(2, 35), 'location_detail' => str_random(100), 'memo' => str_random(500)]); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->string('name'); $t->string('username')->unique(); $t->string('password'); $t->string('phone')->nullable(); $t->string('email')->nullable(); $t->smallInteger('status')->default(1); $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); }); db_c($this->ins_name, 'i', ['name' => str_random(2) . ' ' . str_random(2), 'username' => 'admin', 'password' => hash_password('admin'), 'phone' => rand(13000000000.0, 13999999999.0), 'email' => str_random(3) . '@' . str_random(3) . '.com', 'memo' => str_random(200)]); $count = 100; for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['name' => str_random(2) . ' ' . str_random(2), 'username' => $this->ins_name . $i, 'password' => hash_password($this->ins_name . $i), 'phone' => rand(13000000000.0, 13999999999.0), 'email' => str_random(3) . '@' . str_random(3) . '.com', 'memo' => str_random(200)]); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('i_' . $this->ins_name, function (Blueprint $t) { $t->engine = 'InnoDB'; $t->increments('id'); $t->integer('lease_type_id')->default(1); $t->dateTime('lease_started_at'); $t->dateTime('lease_ended_at'); $t->unsignedInteger('robot_id'); $t->unsignedInteger('agency_id'); $t->unsignedInteger('hospital_id'); $t->text('memo')->nullable(); $t->softDeletes(); $t->timestamps(); $t->foreign('robot_id')->references('id')->on('i_robot')->onDelete('cascade'); $t->foreign('agency_id')->references('id')->on('i_agency')->onDelete('cascade'); $t->foreign('hospital_id')->references('id')->on('i_hospital')->onDelete('cascade'); }); $count = 5000; for ($i = 0; $i < $count; $i++) { db_c($this->ins_name, 'i', ['lease_type_id' => rand(1, 4), 'lease_started_at' => date("Y-m-d H:i:s", mt_rand(1161302400, 1440560208)), 'lease_ended_at' => date("Y-m-d H:i:s", mt_rand(1440560208, 1640560208) + rand(190000, 390000)), 'hospital_id' => rand(1, 400), 'robot_id' => rand(1, 1000), 'agency_id' => rand(1, 1000), 'memo' => str_random(500)]); } }