<?php

namespace Give\FormMigration\Actions;

use Give\DonationForms\ValueObjects\DonationFormStatus;
use Give\Framework\Database\DB;

class TransferDonations
{
    protected $sourceId;

    public function __construct($sourceId)
    {
        $this->sourceId = $sourceId;
    }

    public static function from($sourceId): self
    {
        return new TransferDonations($sourceId);
    }

    public function to($destinationId): void
    {
        $this->__invoke($destinationId);
    }

    public function __invoke($destinationId)
    {
        DB::transaction(function() use ($destinationId) {

            // Mark the v2 form as "upgraded".
            DB::table('posts')
                ->where('ID', $this->sourceId)
                ->update(['post_status' => DonationFormStatus::UPGRADED]);

            DB::table('give_donationmeta')
                ->where('meta_key', '_give_payment_form_id')
                ->where('meta_value', $this->sourceId)
                ->update(['meta_value' => $destinationId]);

            DB::table('give_revenue')
                ->where('form_id', $this->sourceId)
                ->update(['form_id' => $destinationId]);

            // Update subscriptions to use v3 form ID
            DB::table('give_subscriptions')
                ->where('product_id', $this->sourceId)
                ->update(['product_id' => $destinationId]);

            give_update_meta(
                $destinationId,
                '_give_form_sales',
                (int)give_get_meta($this->sourceId, '_give_form_sales', true)
            );
            give_update_meta($this->sourceId, '_give_form_sales', 0);

            give_update_meta(
                $destinationId,
                '_give_form_earnings',
                (float)give_get_meta($this->sourceId, '_give_form_earnings', true)
            );
            give_update_meta($this->sourceId, '_give_form_earnings', 0);

        });
    }
}
