<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class BillingAddPaymentDue extends AbstractMigration
{
    public function up(): void
    {
        if($this->getEnvironment() == "thetool") {

            $billing = $this->table("Billing");
            $billing->addColumn("fibu_payment_due", "integer", ["null" => true, "default" => null, "after" => "fibu_account_number"]);
            $billing->addColumn("fibu_payment_skonto", "integer", ["null" => false, "default" => 0, "after" => "fibu_payment_due"]);
            $billing->addColumn("fibu_payment_skonto_rate", "integer", ["null" => false, "default" => 0, "after" => "fibu_payment_skonto"]);
            $billing->addIndex("invoice_id");
            $billing->addIndex("contract_id");
            $billing->addIndex("start_date");
            $billing->addIndex("end_date");
            $billing->update();

            $bv = $this->table("BillingVoicenumber");
            $bv->addIndex("contract_id");
            $bv->addIndex("voicenumber");
            $bv->addIndex("start_date");
            $bv->addIndex("end_date");
            $bv->update();

            $invoice = $this->table("Invoice");
            $invoice->addIndex("invoice_number");
            $invoice->addIndex("invoice_date");
            $invoice->addIndex("owner_id");
            $invoice->addIndex("billingaddress_id");
            $invoice->addIndex("customer_number");
            $invoice->save();
          
        }
        
        if($this->getEnvironment() == "addressdb") {
          
        }
    }

    public function down(): void
    {
        if($this->getEnvironment() == "thetool") {
            $this->table("Billing")
                ->removeColumn("fibu_payment_skonto_rate")
                ->removeColumn("fibu_payment_skonto")
                ->removeColumn("fibu_payment_due")
                ->removeIndex("end_date")
                ->removeIndex("start_date")
                ->removeIndex("contract_id")
                ->removeIndex("invoice_id")
                ->update();

            $this->table("BillingVoicenumber")
                ->removeIndex("end_date")
                ->removeIndex("start_date")
                ->removeIndex("voicenumber")
                ->removeIndex("contract_id")
                ->update();

            $this->table("Invoice")
                ->removeIndex("customer_number")
                ->removeIndex("billingaddress_id")
                ->removeIndex("owner_id")
                ->removeIndex("invoice_date")
                ->removeIndex("invoice_number")
                ->update();
        }
        
        if($this->getEnvironment() == "addressdb") {
          
        }
    }
}