from django.db import models

# Create your models here.

class EndUser(models.Model):
	name = models.CharField(max_length=244,default='')
	email = models.EmailField(max_length=100,default='',null=True)
	email_verification_otp = models.IntegerField(null=True)
	email_verified = models.BooleanField(default=False)
	phone_number = models.CharField(max_length=20, default='',null=True)
	phone_number_otp = models.CharField(max_length=20, default='',null=True)
	phone_number_verified = models.BooleanField(default=False)
	password = models.CharField(max_length=250,default='',null=True)
	forgot_password_otp = models.IntegerField(null=True)
	image = models.TextField(null=True)
	is_profile_completed = models.BooleanField(default=False)
	status =  models.BooleanField(default=True)
	account_deleted = models.BooleanField(default=False)
	is_password_reset = models.BooleanField(default=False)
	deleted_reason = models.TextField(null=True)
	created_at = models.DateTimeField(auto_now_add=True)
	last_login = models.DateTimeField(null=True)
	updated_at = models.DateTimeField(auto_now=True)
	end_date = models.DateTimeField(null=True)
	password_changed = models.BooleanField(default=False)

	class Meta:
		db_table = 'end_user'

class ProjectModule(models.Model):
	user = models.ForeignKey(EndUser, on_delete=models.CASCADE,null=True, blank=True, related_name='project_module')
	deliverabes_list = models.CharField(max_length=255,default='',null=True)
	format_specs = models.CharField(max_length=255,default='',null=True)
	resolution_aspect_ratio = models.CharField(max_length=255,default='',null=True)
	notes_spec_req = models.CharField(max_length=255,default='',null=True)
	initial_bid_budget = models.CharField(max_length=255,default='',null=True)
	deposite_percentage = models.CharField(max_length=255,default='',null=True)
	deposite_value = models.CharField(max_length=255,default='',null=True)
	payment_structure = models.CharField(max_length=255,default='',null=True)
	producer = models.CharField(max_length=255,default='',null=True)
	executive_producer_supervisor = models.CharField(max_length=255,default='',null=True)
	start_date = models.CharField(max_length=255,default='',null=True)
	end_date = models.CharField(max_length=255,default='',null=True)
	key_milestones = models.CharField(max_length=255,default='',null=True)
	google_drive_folder_id = models.CharField(max_length=255, null=True, blank=True)
	project_title = models.CharField(max_length=255,default='',null=True)
	client_name = models.CharField(max_length=255,default='',null=True)
	project_type = models.CharField(max_length=255,default='',null=True)
	client_initials = models.CharField(max_length=255,default='',null=True)
	is_archived = models.BooleanField(default=False) 
	project_status = models.CharField(max_length=255,default='Pending',null=True)
	created_at = models.DateTimeField(auto_now_add=True)

	class Meta:
		db_table = 'project_module'

class EndUserNotifications(models.Model):
	user = models.ForeignKey(EndUser, on_delete=models.CASCADE)
	message = models.TextField(null=True)
	is_read = models.BooleanField(default=False,null=True)
	type = models.CharField(max_length=100,null=True)
	start_date = models.DateTimeField(auto_now_add=True,null=False)
	end_date = models.DateTimeField(null=True)

	class Meta:
		db_table = "enduser_notifications"