<?php

namespace LivraisonParSecteurs;

use LivraisonParSecteurs\Model\LpsAreaCityQuery;
use LivraisonParSecteurs\Model\LpsAreaQuery;
use Propel\Runtime\Connection\ConnectionInterface;
use Propel\Runtime\Propel;
use Thelia\Core\Translation\Translator;
use Thelia\Install\Database;
use Thelia\Model\AddressQuery;
use Thelia\Model\Country;
use Thelia\Model\OrderPostage;
use Thelia\Module\AbstractDeliveryModule;
use Thelia\Module\Exception\DeliveryException;


class LivraisonParSecteurs extends AbstractDeliveryModule
{
    /** @var string */
    const DOMAIN_NAME = 'livraisonparsecteurs';
    const MESSAGE_DOMAIN = 'livraisonparsecteurs';
    const SECTEUR_ACTIF = 1;


    /**
     * @param ConnectionInterface|null $con
     */
    public function postActivation(ConnectionInterface $con = null)
    {
        $database = new Database($con->getWrappedConnection());
        $database->insertSql(null, array(__DIR__ . '/Config/thelia.sql'));
        $database->insertSql(null, array(__DIR__ . '/Config/insert.sql'));
    }

    /**
     * This method is called by the Delivery  loop, to check if the current module has to be displayed to the customer.
     * Override it to implements your delivery rules/
     *
     * If you return true, the delivery method will de displayed to the customer
     * If you return false, the delivery method will not be displayed
     *
     * @param Country $country the country to deliver to.
     *
     * @return boolean
     */
    public function isValidDelivery(Country $country)
    {
        $isValid = false;
        $con = Propel::getConnection();

        $currentAddressId = $this->getRequest()->getSession()->getOrder()->getChoosenDeliveryAddress();
        if (!empty($currentAddressId)) {
            $zipcode = AddressQuery::create()->filterById($currentAddressId)->findOne($con)->getZipcode();

            // Condition 1 : le client doit être situé dans un secteur couvert par la livraison à domicile.
            if (null !== $areaFromZipcode = LpsAreaCityQuery::create()->filterByZipcode($zipcode)->findOne($con)) {
                $areaId = $areaFromZipcode->getIdArea();
                $area = LpsAreaQuery::create()->findOneById($areaId);

                // Condition 2 : le secteur doit être actif à date.
                if (null !== $area && $area->getActive() === self::SECTEUR_ACTIF)
                    $isValid = true;
            }
        }
        return $isValid;
    }


    /**
     * Calculate and return delivery price in the shop's default currency
     *
     * @param Country $country the country to deliver to.
     *
     * @return OrderPostage|float             the delivery price
     * @throws DeliveryException if the postage price cannot be calculated.
     */
    public function getPostage(Country $country)
    {
        if (! $this->isValidDelivery($country)) {
            throw new DeliveryException(
                Translator::getInstance()->trans("This module cannot be used on the current cart.")
            );
        }

        $price = 0;
        $con = Propel::getConnection();
        $currentAddressId = $this->getRequest()->getSession()->getOrder()->getChoosenDeliveryAddress();
        if (!empty($currentAddressId)) {
            $zipcode = AddressQuery::create()->filterById($currentAddressId)->findOne($con)->getZipcode();
            $areaId = LpsAreaCityQuery::create()->findOneByZipcode($zipcode)->getIdArea();
            $price = LpsAreaQuery::create()->findOneById($areaId)->getPrice();
        }

        return $price;
    }

}