from django.db import models

class Tickets (models.Model) :
    flight = models.CharField(max_length=10)
    start_point = models.CharField(max_length=20)
    final_point = models.CharField(max_length=20)
    starting_time = models.DateTimeField()
    final_time = models.DateTimeField()
    F_price = models.DecimalField(max_digits=8,decimal_places=2)
    F_quantity = models.IntegerField()
    F_discount = models.DecimalField(max_digits=5,decimal_places=2)
    F_real_price = models.DecimalField(max_digits=8,decimal_places=2)
    C_price = models.DecimalField(max_digits=8, decimal_places=2)
    C_quantity = models.IntegerField()
    C_discount = models.DecimalField(max_digits=5,decimal_places=2)
    C_real_price = models.DecimalField(max_digits=8, decimal_places=2)
    Y_price = models.DecimalField(max_digits=8, decimal_places=2)
    Y_quantity = models.IntegerField()
    Y_discount = models.DecimalField(max_digits=5,decimal_places=2)
    Y_real_price = models.DecimalField(max_digits=8, decimal_places=2)
    Type = models.IntegerField()
    # 1为国内航班，2为国际航班
    flight_id = models.IntegerField()
    stopover_point = models.CharField(max_length=20,default='无')
    stopover_hour = models.IntegerField(default=0)
    stopover_minute = models.IntegerField(default=0)
    tye = models.CharField(max_length=5,default='0')

class Flight (models.Model) :
    number = models.CharField(max_length=10)
    F_seat_num = models.IntegerField()
    C_seat_num = models.IntegerField()
    Y_seat_num = models.IntegerField()
    sta_point = models.CharField(max_length=20)
    stopover_point = models.CharField(max_length=20,default='无')
    stopover_hour = models.IntegerField(default=0)
    stopover_minute = models.IntegerField(default=0)
    fin_point = models.CharField(max_length=20)
    Type = models.IntegerField()
    # 1为国内航班，2为国际航班
    income = models.DecimalField(max_digits=15, decimal_places=2, default=0)
    status = models.CharField(max_length=10, default='未起飞')
    add_time = models.DateTimeField(auto_now_add=True)
    tye = models.CharField(max_length=5)
    # 0直飞，1经停，2中转

class Order (models.Model) :
    flight = models.CharField(max_length=10)
    start_point = models.CharField(max_length=20)
    final_point = models.CharField(max_length=20)
    tye = models.CharField(max_length=5,default='0')
    stopover_point = models.CharField(max_length=20,default='无')
    stopover_hour = models.IntegerField(default=0)
    stopover_minute = models.IntegerField(default=0)
    starting_time = models.DateTimeField()
    final_time = models.DateTimeField()
    be_price = models.DecimalField(max_digits=8, decimal_places=2)
    # 原价
    discount = models.DecimalField(max_digits=5,decimal_places=2)
    true_price = models.DecimalField(max_digits=8, decimal_places=2)
    # 实付款
    berth = models.CharField(max_length=10)
    # 舱位
    Type = models.IntegerField()
    # 1为国内航班，2为国际航班
    add_time = models.DateTimeField(auto_now_add=True)
    status = models.CharField(max_length=10)
    ticket_id = models.IntegerField()
    user_id = models.IntegerField()
    new_ticket_id = models.IntegerField(default=0)
    # 改签审核时，暂存目标机票的机票号
    new_berth = models.CharField(max_length=10, default='经济舱')
    refund_precent = models.IntegerField(default=0)
    change_percent = models.IntegerField(default=0)
    # 提交退改时保存手续费百分比

class Message (models.Model) :
    content = models.CharField(max_length=500)
    from_id = models.IntegerField()
    to_id = models.IntegerField()
    # 为0代表管理员
    status = models.IntegerField()
    # 如果是发给管理员的消息，0代表未读，1代表已读
    add_time = models.DateTimeField(auto_now_add=True)

# Create your models here.