我無法在我的 django 專案中編輯資料
設定.py
Django settings for superAdmin project.
Generated by 'django-admin startproject' using Django 4.0.4.
import os
from pathlib import Path
# Build paths inside the project like this: BASE_DIR / 'subdir'.
BASE_DIR = Path(__file__).resolve().parent.parent
TEMPLATE_DIR =os.path.join(BASE_DIR,'templates')
STATIC_DIR = os.path.join(BASE_DIR,'static')
SECRET_KEY = 'django-insecure-pqeid(n@vcuz-nj_ qphdlmcabz58w7cb#h3)hidden'
# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = True
ALLOWED_HOSTS = []
# Application definition
INSTALLED_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'sa',
]
MIDDLEWARE = [
'django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
]
ROOT_URLCONF = 'superAdmin.urls'
TEMPLATES = [
{
'BACKEND': 'django.template.backends.django.DjangoTemplates',
'DIRS': [TEMPLATE_DIR],
'APP_DIRS': True,
'OPTIONS': {
'context_processors': [
'django.template.context_processors.debug',
'django.template.context_processors.request',
'django.contrib.auth.context_processors.auth',
'django.contrib.messages.context_processors.messages',
],
},
},
]
WSGI_APPLICATION = 'superAdmin.wsgi.application'
# Database
# https://docs.djangoproject.com/en/4.0/ref/settings/#databases
DATABASES = {
'default': {
'ENGINE':'django.db.backends.mysql',
'NAME': 'super',
'USER' : 'root',
'PASSWORD': '',
'HOST':'localhost',
'PORT':'3306'
},
'sales': {
'ENGINE':'django.db.backends.mysql',
'NAME': 'salesteam',
'USER' : 'root',
'PASSWORD': '',
'HOST':'localhost',
'PORT':'3306'
},
'client': {
'ENGINE':'django.db.backends.mysql',
'NAME': 'django',
'USER' : 'root',
'PASSWORD': '',
'HOST':'localhost',
'PORT':'3306'
}
}
# Password validation
# https://docs.djangoproject.com/en/4.0/ref/settings/#auth-password-validators
AUTH_PASSWORD_VALIDATORS = [
{
'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',
},
{
'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',
},
{
'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',
},
{
'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',
},
]
# Internationalization
# https://docs.djangoproject.com/en/4.0/topics/i18n/
LANGUAGE_CODE = 'en-us'
TIME_ZONE = 'UTC'
USE_I18N = True
USE_TZ = True
# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/4.0/howto/static-files/
STATIC_URL = 'static/'
STATICFILES_DIRS =[STATIC_DIR,]
MEDIA_ROOT ='/media/'
MEDIA_ROOT =os.path.join(BASE_DIR,'media')
STATICFILES_DIRS =(
os.path.join(BASE_DIR,'static'),
)
# Default primary key field type
# https://docs.djangoproject.com/en/4.0/ref/settings/#default-auto-field
DEFAULT_AUTO_FIELD = 'django.db.models.BigAutoField'
# EMAIL CONFIGURATION
EMAIL_HOST = 'smtp.gmail.com'
EMAIL_HOST_USER = 'rafiurrahmanrafit@gmail.com'
EMAIL_HOST_PASSWORD = 'ixwxkfeunbdrabfj' #past the key or password app here
EMAIL_PORT = 587
EMAIL_USE_TLS = True
模型.py
from django.db import models
class sa_storesheet(models.Model):
id=models.IntegerField(max_length=100, primary_key=True)
store_name=models.CharField(max_length=100)
date=models.DateField(max_length=100)
product_name=models.CharField(max_length=100)
qty=models.IntegerField(max_length=100)
product_cost=models.FloatField(max_length=100)
sale_price_shipping=models.FloatField(max_length=100)
cogs = models.FloatField(max_length=100)
gross_profit = models.FloatField(max_length=100)
amazon_fee= models.FloatField(max_length=100)
supplier_tax= models.FloatField(max_length=100)
supplier_shipping_cost= models.FloatField(max_length=100)
amazon_administrative = models.FloatField(max_length=100)
net_profit=models.FloatField(max_length=100)
befrugal = models.FloatField(max_length=100)
cash_back_profit = models.FloatField(max_length=100)
total_profit = models.FloatField(max_length=100)
shipping_status = models.CharField(max_length=100)
ordered_status = models.CharField(max_length=100)
after_delivery_status = models.CharField(max_length=100)
supplier_name = models.CharField(max_length=100)
customer_name = models.CharField(max_length=100)
customer_mobile=models.CharField(max_length=100)
customer_address=models.CharField(max_length=100)
purchase_order_id = models.CharField(max_length=100)
amazon_order_id = models.CharField(max_length=100)
amazon_tax = models.FloatField(max_length=100)
tracking_number = models.CharField(max_length=100)
o_a_email_address = models.CharField(max_length=100)
notes = models.CharField(max_length=200)
editor = models.CharField(max_length=100)
class Meta:
managed = False
db_table="all_store"
sa_storesheet.objects = sa_storesheet.objects.using('sales')
視圖.py
import datetime
from django.shortcuts import render
from django.shortcuts import redirect
from django.contrib.auth import authenticate, login ,logout
from django.contrib.auth.models import User
from sa.models import sa_storesheet
from django.contrib import messages
from django.core.mail import send_mail
from django.conf import settings
from django.template.loader import render_to_string
from sa.models import client_info,sales_store_name,client_store_name,sales_info
import uuid,re
def sa_search(request):
if request.user.is_authenticated:
username = request.user.username
if request.method=="POST":
result1=client_store_name.objects.using('client').all()
o_id = request.POST.get('search','')
result2 =sa_storesheet.objects.using('sales').all().filter(amazon_order_id=o_id).values()
return render(request,'search.html',{'sa_storesheet':result2 })
if request.method=="POST":
product_name=request.POST.get('pro_na')
product_cost=float(request.POST.get('pro_cost'))
quantity= eval(request.POST.get('qty'))
sps = eval(request.POST.get('sps'))
cogs = float(request.POST.get('cogs'))
gp = float(request.POST.get('gp'))
amazon_fee = float(request.POST.get('af'))
supp_tax = eval(request.POST.get('st'))
ssc = eval(request.POST.get('ssc'))
aaf = eval(request.POST.get('aaf'))
net_profit =float(request.POST.get('nf'))
total_cogs = cogs supp_tax ssc
order_s = request.POST.get('order_sta')
ship = request.POST.get('shipped_sta')
supplier_n = request.POST.get('supplier')
customer_n = request.POST.get('customer')
order_id = request.POST.get('orderID')
A_order_id = request.POST.get('aoi')
amazon_tax = eval(request.POST.get('ama_tax'))
customer_mobile =request.POST.get('mobile')
customer_add = request.POST.get('address')
notes = request.POST.get('note')
date = "2020-06-11"
bef =0
store_na ='bclawx'
cash = 0
total_p=15
after = "null"
saverecord3 = sa_storesheet.objects.using('sales').get(amazon_order_id=request.POST.get('aoi'))
saverecord3.store_name = store_na
saverecord3.date = date
saverecord3.product_name = product_name
saverecord3.qty =quantity
saverecord3.product_cost = product_cost
saverecord3.sale_price_shipping =sps
saverecord3.cogs = cogs
saverecord3.gross_profit = gp
saverecord3.amazon_fee =amazon_fee
saverecord3.supplier_tax =supp_tax
saverecord3.supplier_shipping_cost =ssc
saverecord3.amazon_administrative =aaf
saverecord3.net_profit =net_profit
saverecord3.befrugal = bef
saverecord3.cash_back_profit =cash
saverecord3.total_profit = total_p
saverecord3.shipping_status =ship
saverecord3.ordered_status =order_s
saverecord3.after_delivery_status = 'null'
saverecord3.supplier_name =supplier_n
saverecord3.customer_name =customer_n
saverecord3.customer_mobile = customer_mobile
saverecord3.customer_address =customer_add
saverecord3.purchase_order_id =order_id
saverecord3.amazon_order_id =A_order_id
saverecord3.amazon_tax =amazon_tax
saverecord3.tracking_number ="null"
saverecord3.o_a_email_address = "null"
saverecord3.notes = notes
saverecord3.editor = "ADMIN"
saverecord3.save()
return render(request,'search.html')
else:
return render(request,'search.html')
else:
return redirect('/superlogin')
在 def_sa_search 中，我在輸入框中搜索產品 ID，當我按 Enter 時，它會加載資料并放在 html 頁面上，但是當我更改值并點擊更新資料按鈕時。它不會改變
這是我的搜索面板
這里輸入框中顯示的產品資訊
當我單擊更新資料輸入型別按鈕時..它不會改變
這是我的視頻鏈接：點擊
<!DOCTYPE html>
{% load static %}
<html class="loading" lang="en" data-textdirection="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0, minimal-ui">
<meta name="description" content="Chameleon Admin is a modern Bootstrap 4 webapp & admin dashboard html template with a large number of components, elegant design, clean and organized code.">
<meta name="keywords" content="admin template, Chameleon admin template, dashboard template, gradient admin template, responsive admin template, webapp, eCommerce dashboard, analytic dashboard">
<meta name="author" content="ThemeSelect">
<title>BR WORK ADMIN TEAM</title>
</head>
<body class="vertical-layout vertical-menu 2-columns menu-expanded fixed-navbar" data-open="click" data-menu="vertical-menu" data-color="bg-gradient-x-purple-blue" data-col="2-columns">
<!-- fixed-top-->
<div class="main-menu menu-fixed menu-light menu-accordion menu-shadow " data-scroll-to-active="true" data-img="{% static 'common/theme-assets/images/backgrounds/02.jpg' %}">
<div class="navbar-header">
<ul class="nav navbar-nav flex-row">
<li class="nav-item mr-auto"><a class="navbar-brand" href="index.html">
<h3 class="brand-text">Sales Team BR</h3></a></li>
<li class="nav-item d-md-none"><a class="nav-link close-navbar"><i class="ft-x"></i></a></li>
</ul>
</div>
<div class="main-menu-content">
<ul class="navigation navigation-main" id="main-menu-navigation" data-menu="menu-navigation">
<li class="nav-item"><a href="/superdashboard"><i class="ft-home"></i><span class="menu-title" data-i18n="">Sales Sheets</span></a>
</li>
<li class=" active"><a href="/supersearch"><i class="ft-pie-chart"></i><span class="menu-title" data-i18n="">Search</span></a>
</li>
</ul>
</div><a class="btn btn-danger btn-block btn-glow btn-upgrade-pro mx-1" href="/supersignout" >Logout</a>
<div class="navigation-background"></div>
</div>
<div class="app-content content">
<div class="content-wrapper">
<form method="post">
{% csrf_token %}
<label> <p>Search Product By ID</p></label>
<input type="text" name="search" class="form-control-a"/>
<button class="a" type ="submit" > Submit </button>
{% comment %} <button class="a" type ="submit" > Submit </button> {% endcomment %}
{% if messages %}
{% for message in messages %}
<h2> {{message}} </h2>
{% endfor %}
{% endif %}
</form>
<form method="post">
{% csrf_token %}
{% for result2 in sa_storesheet %}
<label> Product Name </label>
<input type="text" name="pro_na" value="{{result2.product_name}}" autocomplete="off" class="form-control"/>
<label> Date </label>
<input type="text" name="date" value="{{result2.date}}" autocomplete="off" class="form-control"/>
<label> Product Cost </label>
<input type="text" name="pro_cost" value="{{result2.product_cost}}" autocomplete="off" class="form-control"/>
<label> Quantity </label>
<input type="number" name="qty" value="{{result2.qty}}" autocomplete="off" class="form-control"/>
<label> Sale Price Shipping </label>
<input type="number" name="sps" value="{{result2.sale_price_shipping}}" autocomplete="off" class="form-control"/>
<label> COGS </label>
<input type="number" name="cogs" value="{{result2.cogs}}" autocomplete="off" class="form-control"/>
<label> Gross Profit </label>
<input type="number" name="gp" value="{{result2.gross_profit}}" autocomplete="off" class="form-control"/>
<label> Amazon Fee </label>
<input type="number" name="af" value="{{result2.amazon_fee}}" autocomplete="off" class="form-control"/>
<label> Supplier Tax </label>
<input type="number" name="sup_tax" value="{{result2.supplier_tax}}" autocomplete="off" class="form-control" />
<label> Supplier Shipping Cost </label>
<input type="number" name="ssc" value="{{result2.supplier_shipping_cost}}" autocomplete="off" class="form-control"/>
<label> Amazon Administrative Fee </label>
<input type="number" name="aaf" value="{{result2.amazon_administrative}}" autocomplete="off" class="form-control"/>
<label> Net Profit </label>
<input type="number" name="nf" value="{{result2.net_profit}}" autocomplete="off" class="form-control"/>
<label> Befrugal </label>
<input type="number" name="bf" value="{{result2.befrugal}}" autocomplete="off" class="form-control"/>
<label> Cash Back Profit </label>
<input type="number" name="cbp" value="{{result2.cash_back_profit}}" autocomplete="off" class="form-control"/>
<label> Total Profit </label>
<input type="number" name="tp" value="{{result2.total_profit}}" autocomplete="off" class="form-control"/>
<label> Ordered </label>
<select name="order_sta">
<option disabled="true" selected>{{result2.ordered_status}}</option>
<option value ="On Process">On Process</option>
<option value ="Delivered">Delivered</option>
<option value ="Cancel">Delivered</option>
</select>
<label> Shipped </label>
<select name="shipped_sta">
<option disabled="true" selected>{{result2.shipping_status}}</option>
<option value ="On Process">On Process</option>
<option value ="Delivered">Delivered</option>
<option value ="Cancel">Delivered</option>
</select>
<label> Supplier </label>
<select name="supplier">
<option disabled="true" selected>{{result2.supplier_name}}</option>
<option value ="Amazon">Amazon</option>
<option value ="Wallmart">Wallmart</option>
<option value ="Etsy">Etsy</option>
<option value ="Ebay">Ebay</option>
<option value ="Facebook">Facebook</option>
</select><br>
<label> Customer Name </label>
<input type="text" name="customer" value="{{result2.customer_name}}" autocomplete="off" class="form-control" />
<label> Customer Mobile </label>
<input type="text" name="mobile" value="{{result2.customer_mobile}}" autocomplete="off" class="form-control" />
<label> Customer Address </label>
<input type="text" name="address" value="{{result2.customer_address}}" autocomplete="off" class="form-control" />
<label> Customer Email Address </label>
<input type="text" name="email" value="{{result2.o_a_email_address}}" autocomplete="off" class="form-control" />
<label> Order ID </label>
<input type="text" name="orderID" value="{{result2.purchase_order_id}}" autocomplete="off" class="form-control" />
<label> Amazon Order ID </label>
<input type="text" name="aoi" value="{{result2.amazon_order_id}}" autocomplete="off" class="form-control" />
<label> Amazon Tax </label>
<input type="number" name="ama_tax" value="{{result2.amazon_tax}}" autocomplete="off" class="form-control" />
<label> Note </label>
<input type="text" name="note" value="{{result2.notes}}" autocomplete="off" class="form-control" />
<label> Editor </label>
<input type="text" name="editor" value="{{result2.editor}}" autocomplete="off" class="form-control" />
<div class="form-group">
<input type="submit" name="submit" id="submit" class="form-submit" value="Update Data"/>
</div>
{% endfor %}
</form>
</div>
</div>
</div>
</div>
</div>
</body>
</html>uj5u.com熱心網友回復：
如果用戶通過身份驗證，編譯器會檢查請求方法是否為 POST，并且您的更新請求方法始終為 POST。因此，編譯器總是先進入 if 并回傳渲染。如果請求是搜索或更新，它總是從第一個 if 陳述句回傳，它不會輸入你的第二個 if（更新代碼）。
所以你必須先改變條件。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/492260.html