<?php

namespace Mrgig\MV\Model\CustomerInvoice;

use Mrgig\MV\Helper\Data as DataHelper;
use Magento\Framework\App\ResourceConnection;

class Line
{
private const SALES_ORDER_TAX_TABLE = 'sales_order_tax';
protected $container = [];

public function __construct(
DataHelper $dataHelper,
ResourceConnection $resourceConnection
) {
$this->dataHelper = $dataHelper;
$this->resourceConnection = $resourceConnection;
}

public function invoiceLine($invoice, $countryId, $taxId)
{
$order = $invoice->getOrder();
$vatId = $this->getVatId($order);
if(!empty($vatId)) {
$accountCode = '820100';
} else {
$accountCode = $this->dataHelper->getAccountCodeArrayMapping($countryId);
}

$total = $this->getTotal($invoice);
$taxAmount = $this->getTaxAmount($invoice);
$this->container['accountId'] = $accountCode;
$this->container['creditAmount'] = $total;
$this->container['creditAmountCur'] = $total;
$this->container['transactionDate'] = $this->getInvoiceDate($invoice->getCreatedAt());
$this->container['vatAmount'] = $taxAmount;
$this->container['vatAmountCur'] = $taxAmount;
$this->container['vatCodeId'] = $taxId;
$this->container['vatType'] = 0;
return [$this->container];
}

public function getVatId($order)
{
$shippingAddress = $order->getShippingAddress();
if(empty($shippingAddress)) {
$shippingAddress = $order->getBillingAddress();
}
$vatId = null;
if($shippingAddress->getCountryId() != 'NL') {
$vatId = $shippingAddress->getVatId();
}
return $vatId;
}

public function getInvoiceDate($date)
{
return date('d-m-Y', strtotime($date));
}

public function getTotal($invoice)
{
$discountAmount = $invoice->getBaseDiscountAmount();
if (strpos($invoice->getBaseDiscountAmount(), '-') !== false) {
$discountAmount = str_replace('-', '', $invoice->getBaseDiscountAmount());
}

$total = $invoice->getBaseSubtotal() + $invoice->getShippingAmount();

if($discountAmount > 0) {
$taxPercent = $this->getTaxPercent($invoice->getOrder()->getId());
if(!empty($taxPercent) && $taxPercent > 0) {
$getTaxAmount = $invoice->getBaseGrandTotal() * $taxPercent / (100 + $taxPercent);
$total = $invoice->getBaseGrandTotal() - $getTaxAmount;
$total = number_format((float)$total, 2, '.', '');
}
}
return $total;
}


public function getTaxAmount($invoice)
{
$discountAmount = $invoice->getBaseDiscountAmount();
if (strpos($invoice->getBaseDiscountAmount(), '-') !== false) {
$discountAmount = str_replace('-', '', $invoice->getBaseDiscountAmount());
}
$taxAmount = $invoice->getTaxAmount();
if($discountAmount > 0) {
$taxPercent = $this->getTaxPercent($invoice->getOrder()->getId());
if(!empty($taxPercent) && $taxPercent > 0) {
$taxAmount = $invoice->getBaseGrandTotal() * $taxPercent / (100 + $taxPercent);
$taxAmount = number_format((float)$taxAmount, 2, '.', '');
}
}
return $taxAmount;
}

public function getTaxPercent(int $orderId): float
{
$table = $this->resourceConnection->getTableName(self::SALES_ORDER_TAX_TABLE);
$connection = $this->resourceConnection->getConnection();
$select = $connection->select();
$select->from(['order_tax' => $table], ['percent' => 'order_tax.percent']);
$select->where('order_tax.order_id = ?', $orderId);
$percent = (float) $connection->fetchOne($select);

return $percent;
}
}