private function createPaymentStatuses() { $statuses = [['id' => '1', 'name' => 'Pending'], ['id' => '2', 'name' => 'Voided'], ['id' => '3', 'name' => 'Failed'], ['id' => '4', 'name' => 'Completed'], ['id' => '5', 'name' => 'Partially Refunded'], ['id' => '6', 'name' => 'Refunded']]; foreach ($statuses as $status) { $record = PaymentStatus::find($status['id']); if ($record) { $record->name = $status['name']; $record->save(); } else { PaymentStatus::create($status); } } }
/** * Run the migrations. * * @return void */ public function up() { Schema::dropIfExists('payment_statuses'); Schema::create('payment_statuses', function ($table) { $table->increments('id'); $table->string('name'); }); $statuses = [['id' => '1', 'name' => 'Pending'], ['id' => '2', 'name' => 'Voided'], ['id' => '3', 'name' => 'Failed'], ['id' => '4', 'name' => 'Completed'], ['id' => '5', 'name' => 'Partially Refunded'], ['id' => '6', 'name' => 'Refunded']]; Eloquent::unguard(); foreach ($statuses as $status) { $record = PaymentStatus::find($status['id']); if ($record) { $record->name = $status['name']; $record->save(); } else { PaymentStatus::create($status); } } Eloquent::reguard(); Schema::dropIfExists('payment_methods'); Schema::create('payment_methods', function ($table) { $table->increments('id'); $table->unsignedInteger('account_id'); $table->unsignedInteger('user_id'); $table->unsignedInteger('contact_id')->nullable(); $table->unsignedInteger('account_gateway_token_id'); $table->unsignedInteger('payment_type_id'); $table->string('source_reference'); $table->unsignedInteger('routing_number')->nullable(); $table->smallInteger('last4')->unsigned()->nullable(); $table->date('expiration')->nullable(); $table->string('email')->nullable(); $table->unsignedInteger('currency_id')->nullable(); $table->string('status')->nullable(); $table->timestamps(); $table->softDeletes(); $table->foreign('account_id')->references('id')->on('accounts')->onDelete('cascade'); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->foreign('contact_id')->references('id')->on('contacts')->onDelete('cascade'); $table->foreign('account_gateway_token_id')->references('id')->on('account_gateway_tokens'); $table->foreign('payment_type_id')->references('id')->on('payment_types'); $table->foreign('currency_id')->references('id')->on('currencies'); $table->unsignedInteger('public_id')->index(); $table->unique(array('account_id', 'public_id')); }); Schema::table('payments', function ($table) { $table->decimal('refunded', 13, 2); $table->unsignedInteger('payment_status_id')->default(PAYMENT_STATUS_COMPLETED); $table->unsignedInteger('routing_number')->nullable(); $table->smallInteger('last4')->unsigned()->nullable(); $table->date('expiration')->nullable(); $table->text('gateway_error')->nullable(); $table->string('email')->nullable(); $table->unsignedInteger('payment_method_id')->nullable(); }); Schema::table('payments', function ($table) { $table->foreign('payment_status_id')->references('id')->on('payment_statuses'); $table->foreign('payment_method_id')->references('id')->on('payment_methods'); }); Schema::table('invoices', function ($table) { $table->boolean('client_enable_auto_bill')->default(false); }); \DB::table('invoices')->where('auto_bill', '=', 1)->update(array('client_enable_auto_bill' => 1, 'auto_bill' => AUTO_BILL_OPT_OUT)); \DB::table('invoices')->where('auto_bill', '=', 0)->where('is_recurring', '=', 1)->update(array('auto_bill' => AUTO_BILL_OFF)); Schema::table('account_gateway_tokens', function ($table) { $table->unsignedInteger('default_payment_method_id')->nullable(); }); Schema::table('account_gateway_tokens', function ($table) { $table->foreign('default_payment_method_id')->references('id')->on('payment_methods'); }); }