我在Django中有两个模型类:
class Notification(models.Model):
receiver = models.ForeignKey(User, null=True, blank=True)
content = models.CharField(max_length=500)
object_id = models.IntegerField(blank=True, null=True)
type = models.TextField(max_length=200, blank=True, null=True)类通知存储有关用户活动的通知。“内容”字段类似于:“欢迎您成功注册商科课程”,或"5ASC为您的代金券代码“。字段类型存储对象的类型:课程、促销。
class PaymentTransaction(models.Model):
course = models.ForeignKey(Course)
student = models.ForeignKey(User)
PAYMENT_STATUS = ( SUCCESS, FAILURE, PROCESSING)
payment_status = models.CharField(max_length=50, choices=PAYMENT_STATUS, default=PROCESSING)在弹出通知中,当他点击付费课程然后进入课程详情页面并开始学习时,当他点击付费课程然后进入课程注册页面时,当他点击推广代码然后进入推广代码页面时
如何让QuerySet返回Notification和PaymentTransaction表的所有字段,条件是Notification.receiver_id = PaymentTransaction.student_id。对于每个课程通知,我想要获取课程支付状态。我做到了:
user = request.user p_list = PaymentTransaction.objects.filter(student=user) n_list = Notification.objects.filter(receiver=user).intersection(p_list)
但它并没有起作用
发布于 2017-05-31 10:34:28
我不明白你为什么要创建这样的模型,但是:我认为它应该是:
class Book:
title = models.CharField(max_length=500)
price = models.FloatField()
class User:
name= models.CharField(max_length=500)
something = models.CharField()
class Book_User:
user = models.ForeignKey(User)
book = models.ForeignKey(User)
detail = models.CharField()noti是用来做什么的?只是显示列表而已?~>它应该是user ~> Book_User页面中的问题解决列表
https://stackoverflow.com/questions/44266544
复制相似问题