class UserGroupPermission(models.Model):
user = models.ForeignKey(User, blank=True, default='1')
group = models.ForeignKey(UserGroupList, blank=True, default='')
groupadmin = models.CharField(max_length=45, default='1')
limit = models.CharField(max_length=45, default='')
# userip = models.CharField(max_length=45, default='')
staus = models.CharField(max_length=45, default='1')
def __str__(self):
return "grouppermission"
class UserLog(models.Model):
todaydate = models.DateTimeField(auto_now_add=True)
ugroup = models.ForeignKey(UserGroupList, blank=True, default=1)
user = models.ForeignKey(User)
logintime = models.DateTimeField(auto_now_add=True)
logouttime = models.DateTimeField(auto_now_add=True)
ip = models.CharField(max_length=255)
urlreq = models.IntegerField(default=0)
def __str__(self):
return self.ip
class Post(models.Model):
posturl = models.CharField(max_length=255, default='')
company = models.CharField(max_length=45)
status_id = models.CharField(db_index=True, max_length=45)
status_message = models.TextField(blank=True, null=True)
status_published = models.DateTimeField(auto_now_add=True, blank=True)
num_reactions = models.IntegerField()
num_comments = models.IntegerField()
num_shares = models.IntegerField()
num_likes = models.IntegerField()
num_loves = models.IntegerField()
num_wows = models.IntegerField()
num_hahas = models.IntegerField()
num_sads = models.IntegerField()
num_angrys = models.IntegerField()
status = models.IntegerField(default=1)
fans_comments = models.IntegerField(default=1)
author_comments = models.IntegerField(default=1)
total_comments = models.IntegerField(default=1)
user = models.ForeignKey(User, blank=True)
postimg = models.TextField(blank=True, null=True, default='')
post_status = models.IntegerField(default=0)
def __str__(self):
return self.status_id
class Userdetails(models.Model):
user = models.ForeignKey(User, default=1)
phone = models.CharField(max_length=45)
address = models.CharField(max_length=45)
profilepic = models.ImageField(upload_to='pic_folder/',
default='pic_folder/None/no-img.jpg')
def __str__(self):
return self.address
class NewUrl(models.Model):
url = models.CharField(max_length=255)
user = models.CharField(max_length=45)
comName = models.CharField(max_length=45, default='', blank=True)
urltime = models.DateTimeField(blank=True, auto_now=True)
statusid = models.CharField(max_length=45)
ugroup = models.ForeignKey(UserGroupList, blank=True, default=1)
def __str__(self):
return self.url
class PostLog(models.Model):
user = models.ForeignKey(User, blank=True, default='')
post = models.CharField(max_length=45, blank=True, default='')
def __str__(self):
return self.post
class MisClassifiedDataStore(models.Model):
comment_ref = models.ForeignKey(Comment, blank=True, default='')
def __str__(self):
return self.comment_ref
class KeywordAnalysis(models.Model):
company = models.CharField(max_length=45)
daterange = models.CharField(max_length=45)
keyword = models.TextField(blank=True, null=True)
post_user = models.ForeignKey(User, blank=True)
response_ration = models.IntegerField(blank=True, default=0)
negative = models.IntegerField(blank=True, default=0)
positive = models.IntegerField(blank=True, default=0)
neutral = models.IntegerField(blank=True, default=0)
ratiopos = models.IntegerField(blank=True, default=0)
rationeg = models.IntegerField(blank=True, default=0)
rationeu = models.IntegerField(blank=True, default=0)
query = models.IntegerField(blank=True, default=0)
complain = models.IntegerField(blank=True, default=0)
appreciation = models.IntegerField(blank=True, default=0)
feedback = models.IntegerField(blank=True, default=0)
feedbackneg = models.IntegerField(blank=True, default=0)
feedbackpos = models.IntegerField(blank=True, default=0)
spam = models.IntegerField(blank=True, default=0)
wom = models.IntegerField(blank=True, default=0)
query_percentage = models.IntegerField(blank=True, default=0)
complain_percentage = models.IntegerField(blank=True, default=0)
appreciation_percentage = models.IntegerField(blank=True, default=0)
feedback_percentage = models.IntegerField(blank=True, default=0)
spam_percentage = models.IntegerField(blank=True, default=0)
wom_percentage = models.IntegerField(blank=True, default=0)
pi = models.IntegerField(blank=True, default=0)
npi = models.IntegerField(blank=True, default=0)
notpi = models.IntegerField(blank=True, default=0)
pi_percentage = models.IntegerField(blank=True, default=0)
product_service = models.IntegerField(blank=True, default=0)
after_sales = models.IntegerField(blank=True, default=0)
campaign_offers = models.IntegerField(blank=True, default=0)
others = models.IntegerField(blank=True, default=0)
product_service_percentage = models.IntegerField(blank=True, default=0)
after_sales_percentage = models.IntegerField(blank=True, default=0)
campaign_offers_percentage = models.IntegerField(blank=True, default=0)
others_percentage = models.IntegerField(blank=True, default=0)
dropout_percentage = models.IntegerField(blank=True, default=0)
comment_likes = models.IntegerField(blank=True, default=0)
count = models.IntegerField(blank=True, default=0)
ps_pos = models.IntegerField(blank=True, default=0)
ps_neg = models.IntegerField(blank=True, default=0)
ps_neu = models.IntegerField(blank=True, default=0)
ps_query = models.IntegerField(blank=True, default=0)
ps_complain = models.IntegerField(blank=True, default=0)
ps_appreciation = models.IntegerField(blank=True, default=0)
ps_neg_fed = models.IntegerField(blank=True, default=0)
ps_pos_fed = models.IntegerField(blank=True, default=0)
total_ps = models.IntegerField(blank=True, default=0)
as_pos = models.IntegerField(blank=True, default=0)
as_neg = models.IntegerField(blank=True, default=0)
as_neu = models.IntegerField(blank=True, default=0)
as_query = models.IntegerField(blank=True, default=0)
as_complain = models.IntegerField(blank=True, default=0)
as_appreciation = models.IntegerField(blank=True, default=0)
as_neg_fed = models.IntegerField(blank=True, default=0)
as_pos_fed = models.IntegerField(blank=True, default=0)
total_as = models.IntegerField(blank=True, default=0)
cf_pos = models.IntegerField(blank=True, default=0)
cf_neg = models.IntegerField(blank=True, default=0)
cf_neu = models.IntegerField(blank=True, default=0)
co_query = models.IntegerField(blank=True, default=0)
co_complain = models.IntegerField(blank=True, default=0)
co_appreciation = models.IntegerField(blank=True, default=0)
co_neg_fed = models.IntegerField(blank=True, default=0)
co_pos_fed = models.IntegerField(blank=True, default=0)
total_co = models.IntegerField(blank=True, default=0)
ot_pos = models.IntegerField(blank=True, default=0)
ot_neg = models.IntegerField(blank=True, default=0)
ot_neu = models.IntegerField(blank=True, default=0)
ot_query = models.IntegerField(blank=True, default=0)
ot_complain = models.IntegerField(blank=True, default=0)
ot_appreciation = models.IntegerField(blank=True, default=0)
ot_neg_fed = models.IntegerField(blank=True, default=0)
ot_pos_fed = models.IntegerField(blank=True, default=0)
total_ot = models.IntegerField(blank=True, default=0)
total_comments = models.IntegerField(blank=True, default=0)
def __str__(self):
return self.daterange
class CampaignAnalysisDateRange(models.Model):
company = models.CharField(max_length=45)
daterange = models.CharField(max_length=45)
num_reactions = models.IntegerField()
num_comments = models.IntegerField()
num_shares = models.IntegerField()
num_likes = models.IntegerField()
num_loves = models.IntegerField()
num_wows = models.IntegerField()
num_hahas = models.IntegerField()
num_sads = models.IntegerField()
num_angrys = models.IntegerField()
fans_comments = models.IntegerField(default=1)
author_comments = models.IntegerField(default=1)
total_comments = models.IntegerField(default=1)
response_ration = models.FloatField(default=1)
negative = models.IntegerField(default=1)
positive = models.IntegerField(default=1)
neutral = models.IntegerField(default=1)
ratiopos = models.FloatField(default=1)
rationeg = models.FloatField(default=1)
rationeu = models.FloatField(default=1)
query = models.IntegerField(default=1)
complain = models.IntegerField(default=1)
appreciation = models.IntegerField(default=1)
feedback = models.IntegerField(default=0)
spam = models.IntegerField(default=1)
wom = models.IntegerField(default=1)
query_percentage = models.FloatField(default=1)
complain_percentage = models.FloatField(default=1)
appreciation_percentage = models.FloatField(default=1)
feedback_percentage = models.FloatField(default=0)
spam_percentage = models.FloatField(default=1)
wom_percentage = models.FloatField(default=1)
pi = models.IntegerField(default=1)
pi_percentage = models.FloatField(default=0)
npi = models.IntegerField(default=0)
product_service = models.IntegerField(default=1)
after_sales = models.IntegerField(default=1)
campaign_offers = models.IntegerField(default=1)
others = models.IntegerField(default=1)
product_service_percentage = models.FloatField(default=1)
after_sales_percentage = models.FloatField(default=1)
campaign_offers_percentage = models.FloatField(default=1)
others_percentage = models.FloatField(default=1)
dropout_percentage = models.FloatField(default=0)
post_user = models.ForeignKey(User, blank=True)
postimg = models.TextField(blank=True, null=True, default='')
ps_pos = models.IntegerField(default=0)
ps_neg = models.IntegerField(default=0)
ps_neu = models.IntegerField(default=0)
ps_query = models.IntegerField(default=0)
ps_complain = models.IntegerField(default=0)
ps_appreciation = models.IntegerField(default=0)
ps_neg_fed = models.IntegerField(default=0)
ps_pos_fed = models.IntegerField(default=0)
total_ps = models.IntegerField(default=0)
as_pos = models.IntegerField(default=0)
as_neg = models.IntegerField(default=0)
as_neu = models.IntegerField(default=0)
as_query = models.IntegerField(default=0)
as_complain = models.IntegerField(default=0)
as_appreciation = models.IntegerField(default=0)
as_neg_fed = models.IntegerField(default=0)
as_pos_fed = models.IntegerField(default=0)
total_as = models.IntegerField(default=0)
cf_pos = models.IntegerField(default=0)
cf_neg = models.IntegerField(default=0)
cf_neu = models.IntegerField(default=0)
co_query = models.IntegerField(default=0)
co_complain = models.IntegerField(default=0)
co_appreciation = models.IntegerField(default=0)
co_neg_fed = models.IntegerField(default=0)
co_pos_fed = models.IntegerField(default=0)
total_co = models.IntegerField(default=0)
ot_pos = models.IntegerField(default=0)
ot_neg = models.IntegerField(default=0)
ot_neu = models.IntegerField(default=0)
ot_query = models.IntegerField(default=0)
ot_complain = models.IntegerField(default=0)
ot_appreciation = models.IntegerField(default=0)
ot_neg_fed = models.IntegerField(default=0)
ot_pos_fed = models.IntegerField(default=0)
total_ot = models.IntegerField(default=0)
daterange_status = models.IntegerField(default=0)
def __str__(self):
return self.company