from datetime import datetime
from django.conf import settings
from django.db import models


if not settings.configured:
    settings.configure()
# Create your models here.


class User(models.Model):
    def __str__(self):
        return 'Login: ' + str(self.login) + " ID : " + str(self.id)
    id = models.AutoField(primary_key=True, serialize=True,default = None)
    login = models.CharField(max_length=25)
    password = models.CharField(max_length=12)
    email = models.CharField(max_length=35)
    surname = models.CharField(max_length=20)
    name = models.CharField(max_length=11)
    date_of_birth = models.DateField('date of birth', default = datetime.today)
    last_activity = models.DateField('date of last actity', default = datetime.today)
    banned = models.BooleanField(default = False)
    class Meta:
        verbose_name_plural = 'User'


class Petrol_dictionary(models.Model):

    id = models.AutoField(primary_key=True, serialize=True,default = None)
    company = models.CharField(max_length=10)
    logo = models.ImageField(upload_to='photos/%Y/%m/%d', default = None)
    def __str__(self):
        return 'Company : ' + str(self.company) + "   ID :  " + str(self.id)
    class Meta:
        verbose_name_plural = 'Petrol_dictionary'


class Car(models.Model):

    id = models.AutoField(primary_key=True, serialize=True,default = None)
    user_id = models.ForeignKey('User', on_delete=models.PROTECT)
    model = models.CharField(max_length=10)
    mark = models.CharField(max_length=10)
    FUEL_TYPE_CHOICES = (
        ('LNG','LNG'),
        ('ON','ON'),
        ('PB98','PB98'),
        ('PB95','PB95'),
        ('Electric','Electric'),
    )
    fuel_type = models.CharField(max_length= 8,choices=FUEL_TYPE_CHOICES, default = "rodzaj paliwa")
    main_car = models.BooleanField(default=False)
    def __str__(self):
        return 'User : ' + str(self.user_id) + " || Car ID : " + str(self.id)
    class Meta:
        verbose_name_plural = 'Car'


class Petrol_station(models.Model):

    id = models.AutoField(primary_key=True, serialize=True,default = None)
    company_ID = models.ForeignKey('Petrol_dictionary', on_delete=models.PROTECT)
    name = models.CharField(max_length=20)
    active = models.BooleanField(default=True)
    x_coordinate = models.DecimalField(max_digits=20, decimal_places=17)
    y_coordinate = models.DecimalField(max_digits=20, decimal_places=17)
    PB95_price = models.DecimalField(max_digits=3, decimal_places=2)
    PB98_price = models.DecimalField(max_digits=3, decimal_places=2)
    ON_price = models.DecimalField(max_digits=3, decimal_places=2)
    LNG_price = models.DecimalField(max_digits=3, decimal_places=2)
    PB95_updateDate =  models.DateField('date of price update', default = datetime.today)
    PB98_updateDate = models.DateField('date of price update', default=datetime.today)
    ON_updateDate = models.DateField('date of price update', default=datetime.today)
    LNG_updateDate = models.DateField('date of price update', default=datetime.today)
    def __str__(self):
        return str(self.company_ID) + "  Petrol ID : " + str(self.id)
    class Meta:
        verbose_name_plural = 'Petrol_station'


class Price_History(models.Model):

    id = models.AutoField(primary_key=True, serialize=True,default = None)
    petrol_ID = models.ForeignKey('Petrol_station', on_delete=models.PROTECT)
    user_login = models.ForeignKey('User', on_delete=models.PROTECT)
    update_date = models.DateField(default = datetime.today)
    FUEL_TYPE_CHOICES = (
        ('LNG', 'LNG'),
        ('ON', 'ON'),
        ('PB 98', 'PB 98'),
        ('PB 95', 'PB 95'),
        ('Electric', 'Electric'),
    )
    type = models.CharField(max_length= 8,choices=FUEL_TYPE_CHOICES, default = "rodzaj paliwa")
    price = models.DecimalField(max_digits=3, decimal_places=2)
    def __str__(self):
        return 'User : ' + str(self.user_login) + ' ||  ' +  str(self.petrol_ID) + " || ID : " + str(self.id)
    class Meta:
        verbose_name_plural = 'Price_History'


class Refueling_history(models.Model):

    id = models.AutoField(primary_key=True, serialize=True,default = None)
    user_id = models.ForeignKey('User', on_delete=models.PROTECT)
    petrol_ID = models.ForeignKey('Petrol_station', on_delete=models.PROTECT)
    refueling_date = models.DateField(default = datetime.today)
    FUEL_TYPE_CHOICES = (
        ('LNG', 'LNG'),
        ('ON', 'ON'),
        ('PB 98', 'PB 98'),
        ('PB 95', 'PB 95'),
        ('Electric', 'Electric'),
    )
    fuel_type = models.CharField(max_length= 8,choices=FUEL_TYPE_CHOICES, default = "rodzaj paliwa")
    fuel_price = models.DecimalField(max_digits=3, decimal_places=2)
    ammount_of_fuel = models.PositiveSmallIntegerField(default='0')
    def __str__(self):
        return 'User : ' + str(self.user_id) + ' || ' + str(self.petrol_ID) + " || ID : " + str(self.id)
    class Meta:
        verbose_name_plural = 'Refueling_history '


class Charge_station(models.Model):

    id = models.AutoField(primary_key=True, serialize=True,default = None)
    company_ID = models.ForeignKey('Petrol_dictionary', on_delete=models.PROTECT)
    x_coordinate = models.DecimalField(max_digits=20, decimal_places=17)
    y_coordinate = models.DecimalField(max_digits=20, decimal_places=17)
    busy = models.BooleanField(default=False)
    CHARGE_TYPE = (
        ('Typ 1', 'Typ 1'),
        ('Typ 2', 'Typ 2'),
        ('Typ 3', 'Typ 3'),
    )
    type = models.CharField(max_length=20,choices = CHARGE_TYPE,default = "Electric car type")
    def __str__(self):
        return str(self.company_ID) + " || Charge_station ID : " + str(self.id)
    class Meta:
        verbose_name_plural = 'Charge_station'


class Charging(models.Model):

    id = models.AutoField(primary_key=True, serialize=True,default = None)
    charge_ID = models.ForeignKey('Charge_station', on_delete=models.PROTECT)
    user_login = models.ForeignKey('User', on_delete=models.PROTECT)
    update_date = models.DateField(default = datetime.today)
    quantity = models.PositiveSmallIntegerField(default='0')
    power = models.PositiveSmallIntegerField(default='0')
    status = models.BooleanField(default='0')                               #STATUS JEST DO USUNIECIA
    def __str__(self):
        return 'User : ' + str(self.user_login) + ' ||  ' + str(self.charge_ID) + " || Charging ID : " + str(self.id)
    class Meta:
        verbose_name_plural = 'Charging'

class Last_PetrolStations(models.Model):
    id = models.AutoField(primary_key=True,serialize=True,default=None)
    user_id = models.ForeignKey('User', on_delete=models.PROTECT)
    station_id = models.ForeignKey('Petrol_station', on_delete=models.PROTECT)
    date = models.DateField(default = datetime.today)
    name = models.CharField(max_length=20, default=None)
    def __str__(self):
       return 'User : ' + str(self.user_id) + " || Station ID : " + str(self.station_id)
    class Meta:
       verbose_name_plural = 'Last Petrol Station'

class Last_ChargeStations(models.Model):
    id = models.AutoField(primary_key=True,serialize=True,default=None)
    user_id = models.ForeignKey('User', on_delete=models.PROTECT)
    station_id = models.ForeignKey('Charge_station', on_delete=models.PROTECT)
    date = models.DateField(default = datetime.today)
    name = models.CharField(max_length=20, default=None)
    def __str__(self):
       return 'User : ' + str(self.user_id) + " || Station ID : " + str(self.station_id)
    class Meta:
       verbose_name_plural = 'Last Charge Station'