Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How to reload the current page when form was sent?
Hey, after the form was sent the page needs to be automatically reloaded / refreshed. Either just the current page is going to be reloaded or the variable slug_title (which would be part of the current page url) needs to be passed into the (' ') from HttpResponseRedirect. Do you have any suggestions? I would really appreciate it. :) views.py def posts(request, slug_titel): post = get_object_or_404(Thread, slug_titel=slug_titel) form = ThreadForm() if request.method == "POST": form = PostForm(request.POST) if form.is_valid(): form.save() return HttpResponseRedirect(' ') # <- here I need to put in slug_title from above -
How to add multiple values to checkbox field? Django
I am have a form with a checkbox field and hidden price field inside for loop like this: {% for item in inventory %} <input type="checkbox" name="item_name" id="{{forloop.counter}}" value="{{item.name}}"> <input type="hidden" name="item_price" value="{{item.price}}"> {% endfor %} But I also want to add item.price of the selected item to it. Basically I would like to get the data from views like this: item_name = request.POST.getlist('item_name') price = request.POST.getlist('price') Which would both have a list of chosen items. ['item name 1', 'item name 2'] ['item price 1', 'item price 2'] or together [['item name 1', 'item price 1']['item name 2', 'item price 2']] The second option would be better but I have no clue how to do that. Also I would like to add more values to it in the future. How do to do that? -
Listing objects field instead of Object in Django Rest Framework
I've got a model class Like(models.Model): product = models.ForeignKey('ProductInStore', on_delete=models.PROTECT) user = models.ForeignKey('users.CustomUser', on_delete=models.PROTECT) class Meta: unique_together = ('product', 'user',) and a serializer class LikeSerializer(serializers.ModelSerializer): user = serializers.PrimaryKeyRelatedField(read_only=True, default=serializers.CurrentUserDefault()) product = serializers.PrimaryKeyRelatedField(read_only=True) class Meta: model = Like fields = ('user', 'product',) class UserLikedProductsApiList(generics.ListAPIView): queryset = Like.objects.all() serializer_class = LikeSerializer And so if someone likes a product, adds it to favourites, it creates an Like object in database. And i want to create an endpoint users/me/likedProducts so that i can list all the products that self.user.request has liked. Meaning all the Like instances but instead of Like instances i want to show only Like.product instances. Lets say a person x has liked 4 items, and i want to show only 4 items in that list. Do you have any idea how to get around that in Django Rest Framework? -
how to change an object when creating another object in django?
I am writing a financial accounting application. I am using drf. I can not figure out how to change the account when creating the "expense" object Models count = models.DecimalField(max_digits=7, decimal_places=2, verbose_name='Расход') date = models.DateField(blank=True, verbose_name='Дата', null=True) account = models.ForeignKey(Cash, on_delete=models.CASCADE, verbose_name='Счёт', default=DEFAULT_CHECK_ID) category = models.ForeignKey(Categories, on_delete=models.SET_NULL, null=True, blank=True, verbose_name='Категория') place = models.ForeignKey(Places, on_delete=models.SET_NULL, null=True, blank=True, verbose_name='Место платежа') comment = models.CharField(max_length=150, blank=True, verbose_name='Комментарий') is_income = models.BooleanField(verbose_name='Доход') Serializer class CountSerializer(serializers.ModelSerializer): category = serializers.CharField() place = serializers.CharField() account = serializers.CharField() Views class CountViewSet(ModelViewSet): queryset = Count.objects.all() serializer_class = CountSerializer filter_backends = [DjangoFilterBackend, SearchFilter] permission_classes = [IsAuthenticated] filter_fields = ['category', 'place'] search_fields = ['count'] def create(self, request): count = self for i in count: if i.is_income: account_id = i.account.id result = i.account.balance + i.count return Cash.objects.filter(id=account_id).update(balance=result) -
Django apostrophe escaping change
While upgrading Django I noticed that the html escape function used to translate an apostrophe into &#39; whereas it now translates it into &#x27;. I understand the old value is the HTML code and the new value is the hex code. The change seems to have come about because Django used to do the translation itself but now hands it off to python's html module. My question is, are these functionally equivalent? Are there any case where I would need to worry about this change? Also, in case I am not asking the right questions, can anyone direct me to what I should read to understand why these 2 types of codes exist and how they are used? -
How to add another model inside of first model with @property? django
I have Slot model, and OutletToSlot model. In OutletToSlot i can get Slot, but in slot i can't do it. So, I want to add second model inside my first model, why my solve doesn't work? class Slot(models.Model): owner = models.ForeignKey(Profile, null=True, blank=True, on_delete=models.CASCADE) outletsSlotInventory = models.ForeignKey(OutletsSlotInventory, on_delete=models.CASCADE) id = models.UUIDField(default=uuid.uuid4, unique=True, primary_key=True, editable=False) class Meta: unique_together = [['owner', 'outletsSlotInventory']] @property def outletToSlot(self): outletToSlots = self.outletToSlot_set.all() myOutletsToSlots = outletToSlots.filter(owner.id=id); return myOutletsToSlots def __str__(self) -> str: return str(id) class OutletToSlot(models.Model): outletToSlotId = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False) expireTime = models.DateTimeField(blank=True) outlet = models.ForeignKey(Outlet, null=True, blank=True, on_delete=models.CASCADE, default=0) slot = models.OneToOneField(Slot, null=True, blank=True, on_delete=models.CASCADE) def __str__(self) -> str: return "{0} - {1}".format(self.outlet.label, self.slot) -
Create AutoCAD with Python
Is it possible to create an application like AutoCAD, 3D-Max, SketchUp with python and make it online? I mean creating a similar app from scratch, not using APIs! -
Django Image upload issue Cloundinary
i'm learning Django at present and just about getting to the deployment stage at hit a problem serving static/media with Cloudinary, following guides how to do this, it seems straight forward enough. I've checked the Cloudinary support but I can't find anything to help, just wondering if anyone has any input. The problem I have is that I am using Exiffield (to get image info) and ImageSpecField from ImageKit to resize the images for thumbnails and I think this is giving me problems with Cloudinary. Firstly I can't upload images from Admin, I get a Exception Value:Empty file error. Secondly I get 400 Client Error: Bad Request for url: https://res.cloudinary.com/ **path to file*** when trying to open my site (which is being served locally and in development This is using ImageField as upload. I would change it to CloudinaryField but my model heavily relies on ExifField which wont read from it. Model below. image = models.ImageField(upload_to='images') mid_thumbnail = ImageSpecField(source='image', processors=[ResizeToFit(220, 150)], format='JPEG', options={'quality': 100}) gallery_thumbnail = ImageSpecField(source='image', processors=[ResizeToFit(300, 250)], format='JPEG', options={'quality': 100}) gallery_detail = ImageSpecField(source='image', processors=[ResizeToFit(1000, 850)], format='JPEG', options={'quality': 100}) title = models.CharField(max_length=100) albums = models.ManyToManyField(Album, blank=True, related_name='photos') feature_image = models.BooleanField(default=False) description = models.CharField(editable=False, max_length=150, blank=True) posts = models.ManyToManyField(Post, blank=True, … -
Django - Paypal Cancel Suscription
I recently used the django-paypal library in my project. All is working fine, the only problem I'm facing is that I don't find the way to implement a cancel button (to cancel a suscription) or an upgrade button (to change the suscription plan). There is no mention of those buttons in the documentation, so I guess I'm asking this question here to confirm that it can't be achieved with the django-paypal library -
Django IndexError: list index out of range error
I am trying out this code i found online. When i tried commands like runserver, migrate and make migrations. All of them showed this error Traceback (most recent call last): File "C:\Django\OLD\ToDo_Application-master\ToDo_Application-master\todos\views.py", line 129, in check_time task() File "C:\Django\OLD\ToDo_Application-master\ToDo_Application-master\todos\views.py", line 155, in is_expired if splited_notification_time[1] == "minutes": IndexError: list index out of range CODE OF is_expired : def is_expired(): connection = sqlite3.connect('db.sqlite3') cursor = connection.cursor() cursor.execute( " SELECT * FROM todos_todo where email_notification != '' AND notification_time != 'None' AND sent_reminder == 'False' ") rows = cursor.fetchall() todo_notify_time = 0 for row in rows: todo_item_id = row[0] due_date_in_ms = int(datetime.fromisoformat(row[3]).timestamp() * 1000) current_date = int(datetime.now().timestamp() * 1000) splited_notification_time = str(row[6]).split(" ") receiver_email = row[5] sent_reminder = row[7] date_in_pst = due_date_in_ms - (7 * 60 * 60 * 1000) time_remaining = date_in_pst - current_date if splited_notification_time[0] != "None": if splited_notification_time[1] == "minutes": todo_notify_time = int( (splited_notification_time[0])) * 60 * 1000 elif splited_notification_time[1] == "hours": todo_notify_time = int( (splited_notification_time[0])) * 60 * 60 * 1000 elif splited_notification_time[1] == "day": todo_notify_time = int( (splited_notification_time[0])) * 60 * 60 * 24 * 1000 if time_remaining <= todo_notify_time: todo_item_expire = "Your todo_item name - " + \ str(row[1]) + " will expire in " + … -
Make select field toggle another field using Django Forms WITHOUT jQuery
How can I create a toggling behavior using Django form fields such as shown in the gif purely using Django? In the example below the user is prompted to choose only a Division or Center, if the division is chosen, center will automatically be prompted to None and vice versa. In order to create the effect shown, I am using jQuery and some beginner Django code: <div class="col-md-5"> <label>Division </label> <select id="division" name="division" class="form-control select2"> {%for division, name in divisions%} <option value="{{ division }}">{{ name }}</option> {% endfor %} </select> </div> <div class="col"> <h3><strong>OR</strong></h3> </div> <div class="col-md-5"> <label>Center</label> <select id="center" name="center" class="form-control select2"> {%for center, name in centers%} <option value="{{ center }}">{{ name }}</option> {% endfor %} </select> </div> $(document).ready(function () { // Set option selected onchange $("#center").change(function () { // Set selected if ($("#division").val() != "None" && $("#center").val() != "None") { $("#division").val("None"); $("#division").select2().trigger("change"); } return; }); $("#division").change(function () { // Set selected if ($("#division").val() != "None" && $("#center").val() != "None") { $("#center").val("None"); $("#center").select2().trigger("change"); } return; }); }); However the rest of my fields are declared using django forms: class NewTitlesForm07(forms.Form): def __init__(self, *args, **kwargs): super(NewTitlesForm07, self).__init__(*args, **kwargs) self.fields['start_month'] = forms.ChoiceField(choices=MONTH_CHOICES, widget=forms.Select(attrs={'class': 'select2 form-control'})) self.fields['start_year'] = forms.ChoiceField(choices=YEAR_CHOICES_07, widget=forms.Select(attrs={'class': 'select2 form-control'})) … -
Set value of GeoDjango map widget in change form based on other field using jQuery
I'm working on a project that uses GeoDjango and django-cities. I have one model: class Site(models.Model): name = models.CharField(max_length=60) assigned_to = models.ForeignKey( to=User, on_delete=models.PROTECT, null=True, blank=True ) country = models.ForeignKey( to=Country, on_delete=models.PROTECT, null=True, blank=True ) # Region selection should be limited to country region = ChainedForeignKey( to=Region, chained_field="country", chained_model_field="country", on_delete=models.PROTECT, null=True, blank=True, ) # City selection should be limited to region city = ChainedForeignKey( to=City, chained_field="region", chained_model_field="region", on_delete=models.PROTECT, null=True, blank=True, ) location = PointField(null=True, blank=True) This is the planned workflow: User sets the country of the site User sets the region of the site (selection is limited by country) User sets the city of the site (selection is limited by region) When the city changes, the point on the map widget for the location field jumps to the location of the city The user then fine-tunes the location manually and saves In order to achieve this, I have added this js file using the Media class in SiteAdmin: $(document).ready(function() { $("select[name='city']").change(function(e) { const cityId = e.target.value geodjango_location.clearFeatures() // Get the location of the selected city $.ajax({ "type" : "GET", "url" : `/sites/admin/city-location/${cityId}/`, "dataType" : "json", "cache" : false, "success" : function(json) { // Use the city's location as the value … -
Processing a Django form
I have a problem using Django forms while learning Django and adapting code from a variety of online courses and examples. As a result, the code may be “messy” – but if I can get it to work the way I need, I can improve my coding style later. I wish to display a template that contains a form. Some of the data displayed in the page rendered in the template is read from one table/model, polls_CC_Questions, and I wish to write data input in the page into a related table, polls_CC_Resp_NoFK. The models used are: class CC_Questions(models.Model): q_text = models.CharField('Question text', max_length=200) C1_Type = models.CharField('Choice 1 Type', max_length=2) Choice1_text = models.CharField('Choice 1 text', max_length=100) C2_Type = models.CharField('Choice 2 Type', max_length=2) Choice2_text = models.CharField('Choice 2 text', max_length=100) # def __str__(self): return self.q_text[:20] class CC_Resp_NoFK(models.Model): Person_ID = models.IntegerField() Test_date = models.DateTimeField('date test taken') Q_ID = models.IntegerField() Response_value = models.IntegerField(default=0, validators=[MaxValueValidator(100), MinValueValidator(-100)]) # def __str__(self): return self.Person_ID Now I can display the template containing valid data when I enter the url: http://localhost:8000/polls/p2vote/4/ This is processed in urls.py app_name = 'polls' urlpatterns = [ ….. …… # ex: /polls/p2vote/<q_id> path('p2vote/<int:q_id>/', p2_views.p2vote, name='p2vote'), ….. The views.py entry that is used: def p2vote(request,q_id): #next line … -
How to check if the Django-background process is running in server?
The command to start the background process is, nohup python manage.py process_tasks & Similarly in Linux which is the command used to check running status? -
Django static file images not displayed on IBM Cloud Foundry
I've read some other threads, googled, and tried reading docs but can't find what I'm looking for. I am new to playing with Django, fyi. This same code runs alright on my local and also on pythonanywhere.com My web app displays a list of 'interests', 'images', and a 'urls'. The 'image' is actually a path to the local image file. The app deploys fine to IBM Cloud Foundry and works, except that the images in static files do not display only the broken image icon displays. When I deploy, I see in the logs the message "153 static files copied to '/tmp/app/static'" which leads me to believe the collectstatic ran without issue. from models.py: class Interest(models.Model): interest = models.CharField(max_length=100) **image = models.ImageField(upload_to='interest/images')** url = models.URLField(blank=True) def __str__(self): return self.interest From the html template: {% extends 'portfolio/base.html' %} {% block about-class %} about-color-class {% endblock %} {% block content %} {% load static %} <!-- Interests --> <section class="interests"> <div class="container"> <div class="row"> <h1>Some of my interests...</h1> </div> <div class="row-images"> {% for interest in interests %} <div class="col-lg-1 col-md-1 col-xs-1"> <a href="{{ interest.url }}"><**img src="{{ interest.image.url }}" alt=""**></a> </div> {% endfor %} </div> </div> </section> <!-- Interests End --> From settings.py: … -
Django REST framework - How i can unittest model serializer?
can anybody help. I really can't figure out how to test my model seriazlier. I'm using ModelViewSet. Cant find any information in google. tests where i'm trying to test serializer def test_company_serializer(self): self.user1 = User.objects.create_user( username='user1', password='password', ) self.user2 = User.objects.create_user( username='user2', password='password', ) serializer_data = CompanySerializer(self.company1, self.company2, many=True).data expected_data = [ {'name': 'test_company1', 'owner': 'user1'}, {'name': 'test_company2', 'owner': 'user2'}, ] self.assertEqual(serializer_data, expected_data) asserterror looks like this AssertionError: When a serializer is passed a `data` keyword argument you must call `.is_valid()` before attempting to access the serialized `.data` representation. You should either call `.is_valid()` first, or access `.initial_data` instead. models.py class Company(models.Model): name = models.CharField(max_length=255, unique=True, help_text='Название') owner = models.OneToOneField(User, on_delete=models.CASCADE, help_text='Владелец') created = models.DateTimeField(auto_now_add=True, help_text='дата регистрации компании') slug = models.SlugField( max_length=255, unique_for_date='created', blank=True, validators=[validate_slug] ) class Meta: ordering = ['-created'] verbose_name_plural = 'Companies' def __str__(self): return self.name def save(self, *args, **kwargs): self.slug = slugify(self.name) super(Company, self).save(*args, **kwargs) serializers.py class CompanySerializer(serializers.ModelSerializer): medicines = serializers.HyperlinkedRelatedField( many=True, read_only=True, view_name='medicine-detail', ) owner = serializers.ReadOnlyField(source='owner.username') class Meta: model = Company fields = ( 'url', 'pk', 'name', 'owner', 'created', 'medicines', ) -
Python/Django json.loads() error when loading JSON File
In my Django project I have the following directory structure: project/build/contracts/MyFile.json And I am writing code in the following directory project/homeapp/views.py In my views.py I have the following code: with open("../build/contracts/MyFile.json", "r") as f: data = json.loads(f.read()) abi = data["abi"] When I try to python manage.py runserver I get the following error: The strange part is that I couldn't figure out what was wrong so I made a viewstest.py and placed the exact same code in it. When I run it with python .\viewstest.py and print the JSON to console, it works perfectly fine. I even tried importing the abi variable from viewstest.py to views.py but got the same error. So I assume that it is an error relating to Django, but I can't seem to figure it out. Thanks! -
Is Django a good framework for microservice?
Microservices architecture has multiple microservices running. Is Django a good choice for implementing a microservice? I am not concerned about how microservices will talk to each other. I am just concerned about the choice of framework for implementing a microservice. -
Postgres data base engine value
Hi there is a full full traceback error that told to supply engine value to postgres data base main() File "manage.py", line 18, in main execute_from_command_line(sys.argv) File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line utility.execute() File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/core/management/__init__.py", line 413, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/core/management/base.py", line 354, in run_from_argv self.execute(*args, **cmd_options) File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/core/management/base.py", line 398, in execute output = self.handle(*args, **options) File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/core/management/base.py", line 89, in wrapped res = handle_func(*args, **kwargs) File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/core/management/commands/migrate.py", line 92, in handle executor = MigrationExecutor(connection, self.migration_progress_callback) File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 18, in __init__ self.loader = MigrationLoader(self.connection) File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/db/migrations/loader.py", line 53, in __init__ self.build_graph() File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/db/migrations/loader.py", line 220, in build_graph self.applied_migrations = recorder.applied_migrations() File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/db/migrations/recorder.py", line 77, in applied_migrations if self.has_table(): File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/db/migrations/recorder.py", line 55, in has_table with self.connection.cursor() as cursor: File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/db/backends/base/base.py", line 259, in cursor return self._cursor() File "/Users/dmitry_tok/Desktop/Projects/foodgram-project-react/venv/lib/python3.8/site-packages/django/db/backends/dummy/base.py", line 20, in complain raise ImproperlyConfigured("settings.DATABASES is improperly configured. " django.core.exceptions.ImproperlyConfigured: settings.DATABASES is improperly configured. Please supply the ENGINE value. Check settings documentation for more details. Im try to switch my SQlite3 data base to postgres There is a settings.py: 'default': { 'ENGINE': os.getenv('DB_ENGINE'), 'NAME': os.getenv('DB_NAME'), 'USER': os.getenv('POSTGRES_USER'), 'PASSWORD': os.getenv('POSTGRES_PASSWORD'), 'HOST': os.getenv('DB_HOST'), 'PORT': os.getenv('DB_PORT') } } the .env file: DB_ENGINE=django.db.backends.postgresql … -
cudart64_110.dll Loading Multiple Times
I am working on a Django Web Application that uses Tensorflow for some image processing on the backend. As such I have installed CUDA and when I run the web application initially it loads the cudart64_110.dll and provides the following message, which is fine. tensorflow/stream_executor/platform/default/dso_loader.cc:53] Successfully opened dynamic library cudart64_110.dll Within my application I have a Pool.map function for multiprocessing (which is not related to the tensorflow processing, but only to generate some jpegs) as below: pool = Pool(4) pool.map(func_star, zip(index_arr, nrrd_path_arr, user_path_arr, g_img_arr, g_contour_arr, itertools.repeat(results))) The issue I am facing is that whenever this function runs, it also loads the cudart64_110.dll corresponding to the number of processes that I specify in the Pool(x). In the above instance it loads the .dll 4 times as below: This leads to memory issues and crashes the app. I am not entirely sure why this is happening or how can I approach about solving this issue. Any help on how can I avoid this issue would be really appreciated! -
How to make post form like twitter in django?
It is very simple to create a post form which takes text, images and gif, but I need to make it dynamic like twitter. twitter can take number of images at once and can display them line by line as the user posted them (ordered). -
KeyError at /report_save django
I have an issue when trying to save data to model I have a code that seperate number by comma. If I type number < 1000, I can save data and type of the field is int. If the number >=1000, I cannot save data to model and the error appears the error This is my code in my views: form=AddReportForm(request.POST) if form.is_valid(): so_tien=form.cleaned_data["so_tien"] dien_thoai=form.cleaned_data["dien_thoai"] daily_report=report(so_tien=so_tien,dien_thoai=dien_thoai) daily_report.save() return HttpResponseRedirect(reverse('chi_tiet_hop_dong', kwargs={'so_hd': so_hd})) my js code to seperate number in my template: <script language="JavaScript"> function numberWithCommas(){ var input = document.getElementById('{{ form.so_tien.id_for_label}}'); input.value = parseInt(input.value).toLocaleString() } </script> my template: <div class="form-group row"> <div class="col-md-4">Số tiền</div> <div class="col-md-4">{{ form.so_tien }}</div> </div> my form: so_tien=forms.IntegerField(label="Số tiền",widget=forms.TextInput(attrs={"class":"form-control", 'onfocusout': 'numberWithCommas()',}),required=False) dien_thoai=forms.CharField(label="Điện thoại",max_length=12, widget=forms.TextInput(attrs={"class":"form-control"})) Please help me solve the issue -
How to render python dictionary values in Javascript Fetch API (forEach)?
I am trying to render python dictionary values inside a Javascript Fetch API. I tried various ways to do so such as serializing values and using dictionary keys to access the dictionary values. I got no error message but the values I rendered are all "undefined" on my webpage. Python def portfolio_position(request): positions = Portfolio.objects.filter(owner=request.user, off_portfolio=False).order_by('-symbol').values() return JsonResponse([position for position in positions], safe=False) Javascript function load_portfolio_position() { fetch('/portfolio_position') .then(response => response.json()) .then(positions => { console.log(positions); var table = document.getElementById("portfolio-table"); positions.forEach(position => { var row = table.insertRow(1); row.id = `row_${position.symbol}`; var symbol = row.insertCell(0); var price = row.insertCell(1); var change = row.insertCell(2); var average_cost = row.insertCell(3); var position = row.insertCell(4); var pnl = row.insertCell(5); var pnl_percent = row.insertCell(6); symbol.innerHTML = `${position.symbol}`; price.innerHTML = `${position.price}`; change.innerHTML = `${position.change}`; var avc = parseFloat(position.cost).toFixed(3); average_cost.innerHTML = `${avc}`; position.innerHTML = `${position.position}`; pnl.innerHTML = `${position.pnl}`; pnl_percent.innerHTML = `${position.pnl_percent}`; }); }) } This is the dictionary with values from console log This is the undefined result I got in my webpage Appreciate your help! -
How to sum queryset elements in forloop in django template
I have a problem inside a django template. Basically, what I'd like to achieve is this kind of table: Below each column where there is Absent or present I'd like to sum the duration. The total duration is on the rightmost column but I'd like to have filtered, student per student, each duration. To better explain myself, Student A and Student D, in this example, should have printed 5:00. I post some code here: models.py class Attendance(models.Model): course = models.ForeignKey( TheoryCourse, on_delete=models.DO_NOTHING, null=True, blank=True) instructor = models.ForeignKey( Instructor, on_delete=models.DO_NOTHING, null=True, blank=True) subject = models.ForeignKey( Subject, on_delete=models.DO_NOTHING, null=True, blank=True) date = models.DateField(blank=True, null=True) start_time = models.TimeField(blank=True, null=True) end_time = models.TimeField(blank=True, null=True) learning_objectives = models.TextField(null=True, blank=True) duration = models.TimeField(blank=True, null=True) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) class AttendanceReport(models.Model): attendance = models.ForeignKey(Attendance, on_delete=models.CASCADE) presence = models.CharField(max_length=100, null=True, blank=True) student = models.ForeignKey(Student, on_delete=models.DO_NOTHING) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) class Student(models.Model): user = models.OneToOneField(CustomUser, on_delete=models.CASCADE) first_name = models.CharField(max_length=200) last_name = models.CharField(max_length=200) date_of_birth = models.DateField() fiscal_code = models.CharField(max_length=50) phone = models.CharField(max_length=50) license = models.ForeignKey( License, on_delete=models.PROTECT, blank=True, null=True) picture = models.ImageField( blank=True, null=True, default='default.png') id_card = models.ForeignKey( IDCard, on_delete=models.PROTECT, blank=True, null=True) address = models.CharField(max_length=100) cap = models.CharField(max_length=10) city = models.CharField(max_length=100) province = models.CharField(max_length=100) country = … -
Django-Import-Export Customize admin import forms
I want to add an additional field to my Import-Form on the Admin page. I did everything the Docs say but when the entered values for year and calender_week wont show up. resources.py class ForecastListResource(resources.ModelResource): year = fields.Field(column_name="Jahr", attribute="year") calender_week = fields.Field(column_name="Kalenderwoche", attribute="calender_week") brand = fields.Field(column_name="Marke", attribute="brand") material = fields.Field(column_name="Material", attribute="material") material_short_text = fields.Field(column_name="Materialkurztext", attribute="material_short_text") gmc = fields.Field(column_name="GMC", attribute="gmc") gmc_text = fields.Field(column_name="GMC Text", attribute="gmc_text") bed_date = fields.Field(column_name="BedTermin", attribute="bed_date") bed_amount = fields.Field(column_name="BedMenge", attribute="bed_amount") bed_week = fields.Field(column_name="BedWoche", attribute="bed_week") code_last_bed_week = fields.Field(column_name="Code letzte KW", attribute="code_last_bed_week") fabric_number = fields.Field(column_name="Stoffnummer", attribute="fabric_number") print_stage_3 = fields.Field(column_name="Druckstufe 3", attribute="print_stage_3") average_filling = fields.Field(column_name="Mittelwert Abfüllung", attribute="average_filling") net = fields.Field(column_name="Netto", attribute="net") class Meta: model = ForeCastList use_bulk = True skip_unchanged = True forms.py class ForecastDoDImportFormMixin(forms.Form): calender_week = forms.IntegerField(label="Kalenderwoche", required=True) year = forms.IntegerField(label="Jahr", required=True) class ForecastDoDImportForm(ForecastDoDImportFormMixin, ImportForm): pass class ForecastDoDConfirmImportForm(ForecastDoDImportFormMixin, ConfirmImportForm): pass admin.py @admin.register(ForeCastList) class ForeCastList(ImportExportModelAdmin): resource_class = ForecastListResource def get_import_form(self): return ForecastDoDImportForm def get_confirm_import_form(self): return ForecastDoDConfirmImportForm def get_form_kwargs(self, form, *args, **kwargs): if isinstance(form, ForecastDoDImportForm): if form.is_valid(): kwargs.update({"calender_week": form.cleaned_data["calender_week"], "year": form.cleaned_data["year"]}) return kwargs def get_import_data_kwargs(self, request, *args, **kwargs): print(kwargs) return super().get_import_data_kwargs(request, *args, **kwargs) Import-Form Result -> related Part from the Doc´s: https://django-import-export.readthedocs.io/en/latest/getting_started.html#customize-admin-import-forms
