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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/91c89922-4f75-41aa-b706-56804cc01dd8n%40googlegroups.com.
