|
Server : LiteSpeed System : Linux srv104790275 5.15.0-161-generic #171-Ubuntu SMP Sat Oct 11 08:17:01 UTC 2025 x86_64 User : dewac4139 ( 1077) PHP Version : 8.0.30 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory : /usr/local/CyberCP/emailMarketing/ |
Upload File : |
# -*- coding: utf-8 -*-
from django.db import models
from websiteFunctions.models import Websites
from loginSystem.models import Administrator
# Create your models here.
class EmailMarketing(models.Model):
userName = models.CharField(max_length=50, unique=True)
class EmailLists(models.Model):
owner = models.ForeignKey(Websites, on_delete=models.PROTECT)
listName = models.CharField(max_length=50, unique=True)
dateCreated = models.CharField(max_length=200)
verified = models.IntegerField(default=0)
notVerified = models.IntegerField(default=0)
class EmailsInList(models.Model):
owner = models.ForeignKey(EmailLists, on_delete=models.CASCADE)
email = models.CharField(max_length=50)
firstName = models.CharField(max_length=20, default='')
lastName = models.CharField(max_length=20, default='')
verificationStatus = models.CharField(max_length=100)
dateCreated = models.CharField(max_length=200)
class SMTPHosts(models.Model):
owner = models.ForeignKey(Administrator, on_delete=models.CASCADE)
host = models.CharField(max_length=150, unique= True)
port = models.CharField(max_length=10)
userName = models.CharField(max_length=200)
password = models.CharField(max_length=200)
class EmailTemplate(models.Model):
owner = models.ForeignKey(Administrator, on_delete=models.CASCADE)
name = models.CharField(unique=True, max_length=100)
subject = models.CharField(max_length=1000)
fromName = models.CharField(max_length=100)
fromEmail = models.CharField(max_length=150)
replyTo = models.CharField(max_length=150)
emailMessage = models.TextField(max_length=65532)
class EmailJobs(models.Model):
owner = models.ForeignKey(EmailTemplate, on_delete=models.CASCADE)
date = models.CharField(max_length=200)
host = models.CharField(max_length=1000)
totalEmails = models.IntegerField()
sent = models.IntegerField()
failed = models.IntegerField()
class ValidationLog(models.Model):
owner = models.ForeignKey(EmailLists, on_delete=models.CASCADE)
status = models.IntegerField()
message = models.TextField()