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');
});
}
