models.py:
from django.db import models
from specie.models import Specie
from supplier.models import Supplier
class Shipment(models.Model):
supplier = models.ForeignKey(
Supplier, null=True, on_delete=models.DO_NOTHING)
created = models.DateTimeField(auto_now_add=True)
label = models.CharField(max_length=10)
specie = models.OneToOneField(Specie, on_delete=models.DO_NOTHING)
received = models.PositiveIntegerField(default=0)
bad = models.PositiveIntegerField(default=0)
non = models.PositiveIntegerField(default=0)
doa = models.PositiveIntegerField(default=0)
para = models.PositiveIntegerField(default=0)
released = models.PositiveIntegerField(blank=True)
entered = models.BooleanField(default=False)
# override save method
def save(self, *args, **kwargs):
self.bad + self.non + self.doa + self.para
self.released = self.received - \
(self.bad + self.non + self.doa + self.para)
super().save(*args, **kwargs)
def date_trunc_field(self):
return self.created.date()
def __str__(self):
return f"{str(self.supplier)} - {self.label} -
{self.specie.scientific_name} - {self.created.strftime('%Y-%m-%d')}"
class Meta:
ordering = ["label"]
views.py
form = ShipmentSearchForm(request.POST or None)
if request.method == 'POST':
date_from = request.POST.get('date_from')
date_to = request.POST.get('date_to')
chart_type = request.POST.get('chart_type')
print(date_from, date_to, chart_type)
qs = pd.DataFrame(Shipment.objects.all().values())
print(qs)
qs1 = pd.DataFrame(Shipment.objects.filter(created__date=date_from))
print(qs1)
context = {
'form': form,
}
termial:
print(date_from, date_to, chart_type)
2022-02-01 2022-03-14 #1
qs = pd.DataFrame(Shipment.objects.all().values())
print(qs)
id supplier_id created label specie_id
received bad non doa para released entered
0 5 2 2022-03-08 14:59:25.956019+00:00 33-33 14
30 2 4 0 0 24 False
1 2 7 2022-02-18 15:16:22.168860+00:00 64-15 27
20 1 0 0 0 19 True
2 3 7 2022-02-18 16:14:43+00:00 64-15 32
25 2 1 0 0 22 True
3 6 4 2022-03-10 00:00:00+00:00 66-66 59
40 0 0 5 0 35 False
qs1 = pd.DataFrame(Shipment.objects.filter(created__date=date_from))
print(qs1)
Empty DataFrame
Columns: []
Index: []
I cannot get any data when trying to get it using the filter. Any
suggestions would be appreciated.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/91c89922-4f75-41aa-b706-56804cc01dd8n%40googlegroups.com.
