import uuid
from django.db import models
from datetime import datetime
from django.utils.translation import ugettext_lazy as _

FlightType = (
    (1, 'One Way'),
    (2, 'Round Way')
)


class Currency(models.Model):
    class Meta:
        verbose_name_plural = "Currency"

    Name = models.CharField(max_length=200, verbose_name=_('Title'))
    CreatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False, verbose_name=_('Created Date'))
    UpdatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False)
    IsActive = models.BooleanField(default=True, verbose_name=_('Status'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return self.Name


class Supplier(models.Model):
    class Meta:
        verbose_name_plural = "Supplier"

    Name = models.CharField(max_length=200, verbose_name=_('Title'))
    CreatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False, verbose_name=_('Created Date'))
    UpdatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False)
    IsActive = models.BooleanField(default=True, verbose_name=_('Status'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return self.Name


MarkupType = (
    (1, 'Fixed'),
    (2, '%')
)


class AirLines(models.Model):
    class Meta:
        verbose_name_plural = "Air Lines"

    Name = models.CharField(max_length=200, verbose_name=_('Title'))
    CreatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False, verbose_name=_('Created Date'))
    UpdatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False)
    IsActive = models.BooleanField(default=True, verbose_name=_('Status'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return self.Name


class FlightCode(models.Model):
    class Meta:
        verbose_name_plural = "Flight Code"

    Name = models.CharField(max_length=200, verbose_name=_('Title'))
    CreatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False, verbose_name=_('Created Date'))
    UpdatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False)
    IsActive = models.BooleanField(default=True, verbose_name=_('Status'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return self.Name


class Stops(models.Model):
    class Meta:
        verbose_name_plural = "Stops"

    Name = models.CharField(max_length=200, verbose_name=_('Title'))
    CreatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False, verbose_name=_('Created Date'))
    UpdatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False)
    IsActive = models.BooleanField(default=True, verbose_name=_('Status'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return self.Name


class FlightInventory(models.Model):
    Title = models.CharField(max_length=255, null=True, blank=True, verbose_name=_('Title'))
    SecurityKey = models.CharField(default='', max_length=200, verbose_name=_('Security Key'))
    FlightType = models.IntegerField(choices=FlightType, default=1, verbose_name=_('Flight Type'))
    Supplier = models.IntegerField(null=True, blank=True, verbose_name=_('Supplier'))
    Currency = models.CharField(max_length=4, default='', verbose_name=_('Currency'))
    CheckInLuggage = models.CharField(max_length=200, default='', verbose_name=_('Check In Luggage'))
    InCabinLuggage = models.CharField(max_length=200, default='', verbose_name=_('In Cabin Luggage'))
    Fare = models.TextField(null=True, blank=True, default='',  verbose_name=_('Fare Rules'))
    CancellationPolicy = models.TextField(null=True, blank=True, default='', verbose_name=_('Cancellation Policy'))
    InternalRemarks = models.TextField(null=True, blank=True, default='',  verbose_name=_('Internal Remarks'))
    Currency = models.CharField(max_length=4, default='', verbose_name=_('Currency'))
    CreatedBy = models.IntegerField(null=True, blank=True, verbose_name=_('Created By'))
    CreatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False, verbose_name=_('Created Date'))
    UpdatedOn = models.DateTimeField(default=datetime.now, blank=True, editable=False)
    OnwardFromAirportCode = models.CharField(default='', blank=True, max_length=8,
                                             verbose_name=_('Onward From Airport Code'))
    OnwardToAirportCode = models.CharField(default='', blank=True, max_length=8,
                                           verbose_name=_('Onward To Airport Code'))
    InwardFromAirportCode = models.CharField(default='', blank=True, max_length=8,
                                             verbose_name=_('Inward From Airport Code'))
    InwardToAirportCode = models.CharField(default='', blank=True, max_length=8,
                                           verbose_name=_('Inward To Airport Code'))
    IsActive = models.BooleanField(default=True, verbose_name=_('Status'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return str(self.id)

    class Meta:
        verbose_name_plural = "Inventory"


SubFlightType = (
    (1, 'Onword'),
    (2, 'Inword')
)


class AirLineInventory(models.Model):
    FlightInventory = models.ForeignKey(FlightInventory, related_name='airlineinventories', on_delete=models.CASCADE,
                                        verbose_name=_('Flight Inventory'))
    FlightType = models.IntegerField(choices=SubFlightType, default=2, verbose_name=_('Flight Type'))
    AirLines = models.CharField(max_length=32, default='', verbose_name=_('Air Lines'))
    FlightNumber = models.CharField(max_length=16, default='', verbose_name=_('Flight Number'))
    FromCityCode = models.CharField(max_length=8, default='', verbose_name=_('From Airport Code'))
    FromTerminal = models.CharField(max_length=255, null=True, blank=True, verbose_name=_('From Terminal'))
    ToCityCode = models.CharField(max_length=8, default='', verbose_name=_('To Airport Code'))
    ToTerminal = models.CharField(max_length=255, null=True, blank=True, verbose_name=_('To Terminal'))
    Stops = models.IntegerField(default=0, verbose_name=_('Stops'))
    EstimateHours = models.CharField(max_length=16, default='', verbose_name=_('Estimate Hours'))
    DepartureTime = models.TimeField(default=datetime.now, verbose_name=_('Departure Time'))
    ArrivalTime = models.TimeField(default=datetime.now, verbose_name=_('Arrival Time'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return str(self.id)


class AirLinePrice(models.Model):
    id = models.BigAutoField(db_column='id', primary_key=True)
    #uid = models.UUIDField(default=uuid.uuid4, editable=True)
    FlightInventory = models.ForeignKey(FlightInventory, related_name='airlineprices', on_delete=models.CASCADE,
                                        verbose_name=_('Flight Inventory'))
    FromDate = models.DateField(default=datetime.now, verbose_name=_('Onward Date'))
    OnwardGroupPNR = models.CharField(max_length=16, blank=True, default='', verbose_name=_('Onward Group PNR'))
    OnwardAutoTicket = models.BooleanField(default=True, verbose_name=_('Onward Auto Ticket'))
    InDate = models.DateField(default=datetime.now, blank=True, verbose_name=_('Inward Date'))
    InwardGroupPNR = models.CharField(max_length=16, blank=True, default='', verbose_name=_('Inward Group PNR'))
    InwardAutoTicket = models.BooleanField(default=True, verbose_name=_('Inward Auto Ticket'))
    IsRefundable = models.BooleanField(default=False, verbose_name=_('Is Refundable'))
    Seats = models.IntegerField(verbose_name=_('Seats'), default=0)
    Sold = models.IntegerField(verbose_name=_('Sold'), default=0)
    Hold = models.IntegerField(verbose_name=_('Hold'), default=0)
    CurrentSeat = models.IntegerField(verbose_name=_('CurrentSeat'), default=0)
    MinimumBooking = models.IntegerField(verbose_name=_('Minimum Booking'), default=0)
    CutOffDate = models.DateTimeField(default=datetime.now, verbose_name=_('Cut Off Date'))
    Fare = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Fare'))
    Taxes = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Taxes'))
    MarkupType = models.IntegerField(choices=MarkupType, default=2, verbose_name=_('Markup Type'))
    B2CMarkup = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('B2C Mark Up'), default=0)
    Markup = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Mark Up'))
    InfantFare = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Infant Fare'), default=0)
    InfantMarkup = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Infant Fixed Markup'), default=0)
    IsActive = models.BooleanField(default=True, verbose_name=_('Status'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return str(self.id)


class AirLinePriceUpdateHistory(models.Model):
    AirLinePrice = models.ForeignKey(AirLinePrice, related_name='airline_price_update_history',
                                     on_delete=models.CASCADE, verbose_name=_('AirLine Price'))
    PSeat = models.IntegerField(verbose_name=_('PSeat'), default=0)
    PHold = models.IntegerField(verbose_name=_('PHold'), default=0)
    PSold = models.IntegerField(verbose_name=_('PSold'), default=0)
    PCurrent = models.IntegerField(verbose_name=_('PCurrent'), default=0)
    AvailableSeat = models.IntegerField(verbose_name=_('AvailableSeat'), default=0)
    CreatedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Created Date'))
    UpdatedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Updated Date'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return str(self.id)


class AirLinePriceHistory(models.Model):
    HistoryId = models.CharField(default='', max_length=200, verbose_name=_('History ID'))
    AirLinePrice = models.ForeignKey(AirLinePrice, related_name='airline_price_history', on_delete=models.CASCADE,
                                     verbose_name=_('AirLine Price'))
    ReferenceNo = models.IntegerField(verbose_name=_('Reference No.'), default=0)
    Adult = models.IntegerField(verbose_name=_('Adult'), default=0)
    Child = models.IntegerField(verbose_name=_('Child'), default=0)
    Infant = models.IntegerField(verbose_name=_('Infant'), default=0)
    Inventory = models.IntegerField(verbose_name=_('Inventory'), default=0)
    InventoryStatus = models.IntegerField(verbose_name=_('InventoryStatus'), default=0)
    TotalCost = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Total Cost'), default=0)
    TotalMarkup = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Total Markup'), default=0)
    TotalInfantCost = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Total Infant Cost'), default=0)
    TotalInfantMarkup = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Total Infant Markup'), default=0)
    IsCancel = models.BooleanField(default=False, editable=True)
    CAdult = models.IntegerField(verbose_name=_('Cancel Adult'), default=0)
    CChild = models.IntegerField(verbose_name=_('Cancel Child'), default=0)
    CInfant = models.IntegerField(verbose_name=_('Cancel Infant'), default=0)
    TotalCancelCostAdult = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('TotalCancelCostAdult'), default=0)
    TotalCancelCostInfant = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('Total Cancel Cost Infant'), default=0)
    CreatedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Created Date'))
    UpdatedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Updated Date'))
    ReleasedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Released Date'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return str(self.id)


class CancellationHistory(models.Model):
    HistoryId = models.CharField(default='', max_length=200, verbose_name=_('History ID'))
    AirLinePriceHistory = models.ForeignKey(AirLinePriceHistory, related_name='cancellation_history',
                                            on_delete=models.CASCADE,
                                            verbose_name=_('Cancellation History'))
    Adult = models.IntegerField(verbose_name=_('Adult'), default=0)
    Child = models.IntegerField(verbose_name=_('Child'), default=0)
    Infant = models.IntegerField(verbose_name=_('Infant'), default=0)
    IsCancel = models.BooleanField(default=False, editable=True)
    TotalCancelCostAdult = models.DecimalField(max_digits=18, decimal_places=2, verbose_name=_('TotalCancelCostAdult'),
                                               default=0)
    TotalCancelCostInfant = models.DecimalField(max_digits=18, decimal_places=2,
                                                verbose_name=_('Total Cancel Cost Infant'), default=0)
    CreatedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Created Date'))
    UpdatedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Updated Date'))
    ReleasedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Released Date'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return str(self.id)


class CancellationRules(models.Model):
    SecurityKey = models.CharField(default='', max_length=200, verbose_name=_('Security Key'))
    AirLinePrice = models.ForeignKey(AirLinePrice, null=True, blank=True, related_name='airline_cancellation_rules',
                                     on_delete=models.CASCADE,
                                     verbose_name=_('AirLine Price'))
    Days = models.IntegerField(verbose_name=_('Days'), default=0)
    PercentageValue = models.IntegerField(verbose_name=_('PercentageValue'), default=0)
    FixedVal = models.IntegerField(verbose_name=_('FixedVal'), default=0)
    IsMaster = models.BooleanField(default=False, editable=True)
    CreatedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Created Date'))
    UpdatedDate = models.DateTimeField(default=datetime.now, verbose_name=_('Updated Date'))
    IsMarkForDelete = models.BooleanField(default=False, editable=False)

    def __str__(self):
        return str(self.id)


class agencyToAgencyMapping(models.Model):
    SecurityKey = models.CharField(default='', max_length=200, verbose_name=_('Security Key'))
    MasterSecurityKey = models.CharField(default='', max_length=200, verbose_name=_('Master Security Key'))

    def __str__(self):
        return str(self.id)