| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- <?php
- use Illuminate\Database\Migrations\Migration;
- use Illuminate\Database\Schema\Blueprint;
- use Illuminate\Support\Facades\Schema;
- class ChangeOrderIssue extends Migration
- {
- /**
- * Run the migrations.
- *
- * @return void
- */
- public function up()
- {
- Schema::table('order_issues',function (Blueprint $table) {
- $table->string('logistic_number_return')->nullable()->index()->after('order_id');
- });
- $orderIssues = \App\OrderIssue::query()
- ->with('rejectedBill')
- ->get();
- foreach ($orderIssues as $orderIssue) {
- $orderIssue->update(['logistic_number_return'=>$orderIssue->rejectedBill->logistic_number_return ?? null]);
- }
- // Schema::table('order_issues',function (Blueprint $table) {
- // $table->dropColumn('rejected_bill_id');
- // });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- //
- Schema::table('order_issues',function (Blueprint $table) {
- $table->integer('rejected_bill_id')->index()->nullable()->comment('退回单')->after('order_id');
- });
- $orderIssues = \App\OrderIssue::query()
- ->with('rejectedBill')
- ->get();
- foreach ($orderIssues as $orderIssue) {
- $orderIssue->update(['rejected_bill_id'=>$orderIssue['rejectedBill']['id'] ?? null]);
- }
- // Schema::table('order_issues',function (Blueprint $table) {
- // $table->dropColumn('logistic_number_return');
- // });
- }
- }
|