how to show month fields with order serializer.py
class SalesmanSepOctCommissionSerializer(serializers.Serializer):
Salesmen_id = serializers.SerializerMethodField(read_only=True)
september_october_commission = serializers.FloatField(read_only=True)
order_date__month = serializers.SerializerMethodField(read_only=True)
def get_Salesmen_id(self, obj):
query = Salesman.objects.get(pk=obj['Salesmen_id'])
qs = SalesmanCustomSerializer(many=True, read_only=True, instance=[query]).data
return obj['Salesmen_id'], qs
def get_order_date__month(self, obj):
query = Order.objects.filter(order_date=obj['order_date__month'])
print('date', query.values())
qs = OrderCustomSerializer(many=True, read_only=True, instance=[query]).data
return qs
I have view class given view.py
class SalesmanSepOctCommission(generics.ListAPIView):
"""
API endpoint that allows groups to be viewed or edited.
"""
queryset = Order.objects.filter(Q(order_date__month='9') | Q(order_date__month='10')).values(
'Salesmen_id').annotate(
september_october_commission=Sum(F('products__price') * F('quantity') * F('Salesmen__commission')) / 100)
serializer_class = SalesmanSepOctCommissionSerializer
error error display
