from django.db import models

class Luckydraw (models.Model):
    ID = models.AutoField(primary_key=True)
    c_ID = models.IntegerField()  # checkIn的ID
    o_ID = models.IntegerField()  # Organizor的ID
    content = models.TextField()
    #confirmation = models.IntegerField()  # 0不需要确认，10需要但是未确认, 11需要并且确认
    createTime = models.DateTimeField(auto_now_add=True)
    result = models.CharField(null=True, blank=True, max_length=256)  # 奖的名字
    order = models.FloatField(null=True)  # 生成随机数，用于抽奖
    
    def createNew(self):
        Luckydraw.objects.create(c_ID=self.c_ID, o_ID=self.o_ID, content=self.content, order=self.order )

    def getContentList(self):
        result = Luckydraw.objects.filter(c_ID=self.c_ID).values('content')
        return result

    def getList(self):
        result = Luckydraw.objects.filter(c_ID=self.c_ID).values()
        return result

    def getUnluckyList(self):
        result = Luckydraw.objects.filter(c_ID=self.c_ID, result=None).values()
        return result

    def getLuckyList(self):
        result = Luckydraw.objects.filter(c_ID=self.c_ID).exclude(result=None).values()
        return result

    def getAwardList(self):
        result = Luckydraw.objects.filter(c_ID=self.c_ID, result=self.result).values()
        return result

    def searchByC_ID(self):
        result = Luckydraw.objects.filter(c_ID=self.c_ID)
        return result

    def existingInContent(self):
        result = Luckydraw.objects.filter(content__contains=self.content)
        return result

    def getContentQty(self):
        result = Luckydraw.objects.filter(c_ID=self.c_ID).count()
        return result
    
    def uniqueCheck(self):
        resultQty = Luckydraw.objects.filter(content__contains=self.content).count()
        if resultQty == 0:
            return True
        else:
            return False

    def clearByC_ID(self):
        try:
            Luckydraw.objects.filter(c_ID=self.c_ID).delete()
            return True
        except:
            return False