def goods_upload(request,store_id):
goods_1_type = GoodsType.objects.filter(parent__isnull=True)
store = Store.objects.get(pk=store_id)
if request.method == 'GET':
return render(request,'goods/goods_upload.html',{'store':store,'goods_1_type':goods_1_type})
elif request.method == 'POST':
name = request.POST['name']
price = request.POST['price']
stock = request.POST['stock']
intro = request.POST['intro'].strip()
imgpath = request.FILES.get('imgpath')
if name == "" or price == "" or stock == "" or intro == "" or imgpath == None:
return render(request,'goods/goods_upload.html',{'store':store,'goods_1_type':goods_1_type,'error_msg':'字段不能为空！'})
# 其他数据
type_id = request.POST['type2']
goodstype = GoodsType.objects.get(pk=type_id)
_store = Store.objects.get(pk=store_id)
# 创建商品对象，完成上传操作
try:
goods = Goods(name=name,price=price,stock=stock,intro=intro,goodstype=goodstype,store=_store)
goods.save()
except:
return render(request, 'goods/goods_upload.html',
{'store': store, 'goods_1_type': goods_1_type, 'error_msg': '上传字段有误'})
# 创建商品图片对象，保存商品图片
goods_image = GoodsImage(path=imgpath,goods=goods)
goods_image.save()
# 使用redirect 传递参数
return redirect(reverse('goods:goods_detail',args={store_id}))
def addgoods(self):
for books_cate in book_data:
category = GoodsCategory.objects.filter(pk=books_cate["category"])
if category:
for book in books_cate["books"]:
goods = Goods()
goods.category = category[0]
goods.name = book["name"]
goods.goods_sn = book["ISBN"]
goods.author = book["author"]
goods.click_num = goods.sold_num = goods.fav_num = 0
goods.goods_num = 200
goods.shop_price = book["shop_price"]
goods.market_price = goods.shop_price * 1.25
goods.bid = goods.shop_price * 0.8
goods.goods_brief = book["goods_brief"]
goods.goods_desc = book["goods_desc"]
goods.goods_front_image = book["images"][0]
goods.is_hot = goods.is_new = False
goods.save()
book_image_list = []
for book_image in book["images"]:
book_image_instance = GoodsImage()
book_image_instance.image = book_image
book_image_instance.goods = goods
book_image_list.append(book_image_instance)
GoodsImage.objects.bulk_create(book_image_list)
def goods_editor(request,goods_id):
"""
编辑店铺商品
:param request:
:param goods_id:
:return:
"""
goods_1_type = GoodsType.objects.filter(parent__isnull=True)
good = Goods.objects.get(pk=goods_id)
store = Store.objects.get(pk=good.store_id)
if request.method == 'GET':
gooditem = {
'good': good,
'goods_1_type':goods_1_type,
'store':store
}
return render(request, 'goods/goods_editor.html', gooditem)
elif request.method == 'POST':
name = request.POST['name']
price = request.POST['price']
stock = request.POST['stock']
intro = request.POST['intro'].strip()
imgpath = request.FILES.get('imgpath')
if name == "" or price == "" or stock == "" or intro == "" or imgpath == None:
repon = {
'good': good,
'store': store,
'goods_1_type': goods_1_type,
'error_msg': '字段不能为空！'}
return render(request, 'goods/goods_editor.html',repon)
# 其他数据
type_id = request.POST['type2']
goodstype = GoodsType.objects.get(pk=type_id)
# 更新商品数据
nowgood = Goods.objects.get(pk=goods_id)
nowgood.name =name
nowgood.price =price
nowgood.stock =stock
nowgood.intro =intro
nowgood.goodstype =goodstype
nowgood.save()
# 创建商品图片对象，保存商品图片
goods_image = GoodsImage(path=imgpath, goods=nowgood)
goods_image.save()
# 使用redirect 传递参数
return redirect(reverse('goods:goods_detail', args={store.id}))
def deal_product(data):
for goods_detail in data:
goods = Goods()
goods.name = goods_detail["name"]
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").replace("元",
"")))
goods.shop_price = float(
int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detail["desc"] if goods_detail[
"desc"] is not None else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] is not None else ""
goods.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
category_name = goods_detail["categorys"][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail["images"]:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
def import_goods_data():
from goods.models import Goods, GoodsCategory, GoodsImage
with open('data/product_data.json', 'r', encoding='utf8') as f:
row_data = json.loads(f.read())
for goods_detail in row_data:
goods = Goods()
goods.name = goods_detail["name"]
goods.market_price = float(int(goods_detail["market_price"].replace("￥", "").replace("元", "")))
goods.shop_price = float(int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detail["desc"] if goods_detail["desc"] is not None else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail["goods_desc"] is not None else ""
goods.goods_front_image = goods_detail["images"][0] if goods_detail["images"] else ""
category_name = goods_detail["categorys"][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail["images"]:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
def import_product_data(self, datas):
from goods.models import Goods
from goods.models import GoodsCategory
from goods.models import GoodsImage
for data in datas:
good = Goods()
good.name = data['name']
# 商品类别为外键
# 通过名称筛选出类别再赋值
category = data['categorys'][-1]
good_category = GoodsCategory.objects.filter(name=category)
if category:
good.category = good_category[0]
good.market_price = float(data['market_price'].replace('￥', '').replace('元', ''))
good.shop_price = float(data['sale_price'].replace('￥', '').replace('元', ''))
good.goods_brief = data['desc'] if data['desc'] is not None else ''
good.goods_front_image = data['images'][0] if data['images'] is not None else ''
good.goods_desc = data['goods_desc'] if data['goods_desc'] is not None else ''
good.save()
if data['images'] is not None:
for image in data['images']:
good_image = GoodsImage()
good_image.goods = good
good_image.image = image
good_image.save()
def post(self, request):
goodsTitle = request.POST.get("goodsTitle")
price = request.POST.get("price")
oprice = request.POST.get("oprice")
category = int(request.POST.get("category"))
address = request.POST.get("address")
phone = request.POST.get("phone")
description = request.POST.get("description")
img1 = request.FILES.get("img1")
img2 = request.FILES.get("img2")
img3 = request.FILES.get("img3")
img4 = request.FILES.get("img4")
print category
images = []
for img in [img1, img2, img3, img4]:
if img is not None:
images.append(img)
if goodsTitle and price and address and phone and description and len(
images) > 0:
goods = Goods.objects.create(user=request.user,
goods_title=goodsTitle,
price=price,
oprice=oprice,
address=address,
phone=phone,
description=description,
add_time=datetime.now(),
category=category)
goods.save()
else:
return render(request, "pubsuccess.html", {
"status": 0,
"msg": "发布失败！请按要求填写完整基本信息"
})
for img in images:
goodsImg = GoodsImage()
goodsImg.goods = goods
goodsImg.image = img
goodsImg.add_time = datetime.now()
goodsImg.save()
return render(request, "pubsuccess.html", {
"status": 1,
"msg": "发布成功！"
})
def import_goods(apps, schema_editor):
from goods.models import Goods, GoodsCategory, GoodsImage
for goods_detail in product_data.row_data:
goods = Goods()
goods.name = goods_detail['name']
goods.market_price = float(goods_detail['market_price'].replace('￥', '').replace('元', ''))
goods.shop_price = float(goods_detail['sale_price'].replace('￥', '').replace('元', ''))
goods.goods_brief = goods_detail['desc'] if goods_detail['desc'] is not None else ''
goods.goods_desc = goods_detail['goods_desc'] if goods_detail['goods_desc'] is not None else ''
goods.goods_front_image = goods_detail['images'][0] if goods_detail['images'] else ''
category_name = goods_detail['categorys'][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail['images']:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
#商户的描述对应goods_detail中的goods_desc内容，如果goods_detail中的goods_desc内容不为空，就设置为空串
goods.goods_desc = goods_detail["goods_desc"] if goods_detail["goods_desc"] is not None else ""
#商品的封面图等于goods_detail中images中的第一张图，如果没有这么多图片，则设置为空串
goods.goods_front_image = goods_detail["images"][0] if goods_detail["images"] else ""
#商品类别的名字等于goods_detail中categorys中的倒数第一个
category_name = goods_detail['categorys'][-1]
#有了商品的名字
#此处用filter()，不用get(),是因为filter()获取不到数据的时候，返回的是一个空的数组，不会抛异常，
#如果用get()，情况一：数据库里没有；情况二:数据库里查到两条；这两种情况下都是会抛异常的，
#用get()的话，外面必须加一个try catch,用filter()就不用加try catch
category = GoodsCategory.objects.filter(name=category_name)
if category: #如果查到
goods.category = category[0] #商品的类别选搜索到的category的第一个
goods.save() #保存
#图片有轮播图，现在将图片保存起来
for goods_image in goods_detail["images"]:
goods_image_instance = GoodsImage() #实例化
goods_image_instance.image = goods_image #实例化对象中的image字段（图片路径）等于goods_image
goods_image_instance.goods = goods #实例化对象中的goods字段等于上述的goods
goods_image_instance.save() #保存实例化对象
import django
pwd=os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd+"../")
#django初始化
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "Shop.settings")
django.setup()
from goods.models import Goods,GoodsCategory,GoodsImage#必须在django初始化之后才能引入
from db_tools.data.product_data import row_data
for goods_detail in row_data:
goods=Goods()
goods.name=goods_detail["name"]
goods.market_price=float(int(goods_detail["market_price"].replace("￥","").replace("元","")))
goods.shop_price=float(int(goods_detail["sale_price"].replace("￥","").replace("元","")))
goods.goods_brief=goods_detail['desc'] if goods_detail['desc'] is not None else ""
goods.desc=goods_detail['goods_desc'] if goods_detail['goods_desc'] is not None else ""
goods.goods_front_image=goods_detail['images'][0] if goods_detail['images'] else ""
category_name=goods_detail['categorys'][-1]
category=GoodsCategory.objects.filter(name=category_name)
if category:
goods.category=category[0]
goods.save()
for goods_image in goods_detail['images']:
goods_image_obj=GoodsImage()
goods_image_obj.goods=goods
goods_image_obj.image=goods_image
goods_image_obj.save()
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "gulishop.settings")
import django
django.setup()
from db_tools.data.product_data import row_data
from goods.models import Goods, GoodsCategory, GoodsImage
for item in row_data:
goods = Goods()
goods.name = item['name']
goods.goods_brief = item['desc'] if item['desc'] else ''
goods.goods_desc = item['goods_desc'] if item['goods_desc'] else ''
goods.market_price = item['market_price'].replace('￥', '').replace('元', '')
goods.shop_price = item['sale_price'].replace('￥', '').replace('元', '')
goods.goods_front_image = item['images'][0] if item['images'] else ''
category_name = item['categorys'][-1]
category_list = GoodsCategory.objects.filter(name=category_name)
if category_list:
goods.category = category_list[0]
goods.save()
for image in item['images']:
goods_image = GoodsImage()
goods_image.goods = goods
goods_image.image = image
goods_image.save()
django.setup()
from db_tools.data.product_data import row_data
from goods.models import Goods, GoodsCategory, GoodsImage
for goods_detils in row_data:
goods = Goods()
goods.name = goods_detils['name']
goods.goods_brief = goods_detils['desc'] if goods_detils[
'desc'] is not None else ""
goods.goods_desc = goods_detils['goods_desc'] if goods_detils[
'goods_desc'] is not None else ""
goods.market_price = float(
int(goods_detils['market_price'].replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(goods_detils["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_front_image = goods_detils['images'][0] if goods_detils[
'images'] else ""
category_name = goods_detils['categorys'][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for image_detail in goods_detils['images']:
image = GoodsImage()
image.image = image_detail
image.goods = goods
image.save()
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "daydayfresh.settings")
import django
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for goods_detail in row_data:
goods = Goods()
goods.name = goods_detail['name']
goods.market_price = float(int(goods_detail['market_price'].replace('￥', '').replace('元', '')))
goods.shop_price = float(int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detail["desc"] if goods_detail["desc"] is not None else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail["goods_desc"] is not None else ""
goods.goods_front_image = goods_detail["images"][0] if goods_detail["images"] else ""
category_name = goods_detail['categorys'][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail['images']:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for import_good_data in row_data:
db_good = Goods()
db_good.name = import_good_data["name"]
# 首页图片路径保存为字符串即可
db_good.goods_front_image = import_good_data["images"][0] if import_good_data["images"] else ''
db_good.market_price = float(int(import_good_data["market_price"].replace("￥", "").replace("元", "")))
db_good.shop_price = float(int(import_good_data["sale_price"].replace("￥", "").replace("元", "")))
db_good.goods_brief = import_good_data["desc"] if import_good_data["desc"] is not None else ""
db_good.goods_desc = import_good_data["goods_desc"] if import_good_data["goods_desc"] is not None else ""
# 取出最后一个根茎类字符串就可以了
category_name = import_good_data["categorys"][-1]
# 为什么使用filter不使用get因为使用django的get方法是从数据库的取得一个匹配的结果，返回一个对象，如果记录不存在的话，它会报错,
# 而且记录多于两条也会报错,而使用filter会返回结果的一个数组,当没有查询到结果时返回空数组。
goods_category = GoodsCategory.objects.filter(name=category_name)
if goods_category:
db_good.category = goods_category[0]
db_good.save()
# 把每个图片保存为对象
if import_good_data["images"]:
for image in import_good_data["images"]:
goods_image = GoodsImage()
goods_image.image = image
goods_image.goods = db_good
goods_image.save()
goods.name = goods_detail["name"]
# replace("￥", "")把￥替换成 ""
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
# 如果内容不为None传递给goods_brief ,否则: else(为None) 把None转换为""，传递给goods_brief
goods.goods_brief = goods_detail["desc"] if goods_detail[
"desc"] is not None else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] is not None else ""
# 取第一张作为封面图 [如果有就传递值，如果没有（else）传递""。image在数据库默认为str ]
goods.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
# 取第三级分类，作为商品的分类
category_name = goods_detail["categorys"][-1]
# 选用filter不用get。因为filter没有匹配的返回空字符串，不会抛异常，get会抛异常（只能传外键给goods.category,直接传str会出错）
category = GoodsCategory.objects.filter(name=category_name)
print(category[0]) # category是一个对象，goods.category需要字符串，category[0]返回对象的字符串
if category:
goods.category = category[0] # 当前数据的商品的分类
goods.save()
# 商品的图片
for good_image in goods_detail["images"]:
goods_image_instance = GoodsImage()
goods_image_instance.image = good_image
goods_image_instance.goods = goods # 上面有遍历每一个goods
goods_image_instance.save()
#商品详细介绍
instance.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] else ""
#商品的封面
instance.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
#设置商品属于哪个商品类别
categorys_name = goods_detail["categorys"][-1] #'根茎类',或者
#查询数据库看看根茎类，是否存在
categorys = GoodsCategory.objects.filter(name=categorys_name) #返回的是列
if categorys:
#商品数据哪个类目
instance.category = categorys[0]
#保存商品数据
instance.save()
#保存商品轮播图
for image in goods_detail["images"]:
print(image)
goods_image = GoodsImage()
#商品--商品轮播图和商品建立关系
goods_image.goods = instance
#图片
goods_image.image = image
#保存商品轮播图
goods_image.save()
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "MxShop.settings")
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
for goods_detail in row_data:
goods_install = Goods()
goods_install.name = goods_detail['name']
goods_install.market_price = float(int(goods_detail['market_price'].replace("￥", "").replace("元", "")))
goods_install.shop_price = float(int(goods_detail['sale_price'].replace("￥", "").replace("元", "")))
goods_install.goods_brief = goods_detail['desc'] and goods_detail['desc'] or ''
goods_install.goods_desc = goods_detail['goods_desc'] and goods_detail['goods_desc'] or ''
goods_install.goods_front_image = goods_detail['images'][0] if goods_detail['images'] else ""
categorys_name = goods_detail['categorys'][-1]
category = GoodsCategory.objects.filter(name=categorys_name)
if category:
goods_install.category = category[0]
goods_install.save()
for goods_image in goods_detail['images']:
goods_image_instace = GoodsImage()
goods_image_instace.image = goods_image
goods_image_instace.goods = goods_install
goods_image_instace.save()
from db_tools.data.product_data import row_data
from django.utils import timezone
for goods_detail in row_data:
goods = Goods()
goods.name = goods_detail["name"]
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detail["desc"] if goods_detail[
"desc"] is not None else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] is not None else ""
goods.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
goods.add_time = timezone.now()
category_name = goods_detail["categorys"][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail["images"]:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.add_time = timezone.now()
goods_image_instance.save()
for product in row_data:
goods = Goods()
goods.name = product.get('name')
goods.market_price = float(
int(product.get('market_price').replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(product.get('sale_price').replace("￥", "").replace("元", "")))
goods.goods_brief = product.get('desc') if product.get(
'desc') is not None else ""
goods.goods_desc = product.get('goods_desc') if product.get(
'goods_desc') is not None else ""
goods.goods_front_image = product.get('images')[0] if product.get(
'images') else ""
goodsImages = product.get('images')
category_name = product.get('categorys')[-1]
# objects.filter会获取一个集合
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
print(goods)
goods.save()
print('-------images------')
for imgUrl in product.get('images'):
image = GoodsImage()
image.goods = goods
image.image = imgUrl
print(image.image)
image.save()
from goods.models import GoodCategory as GoodsCategory
from goods.models import GoodImage as GoodsImage
from db_tools.data.product_data import row_data
for goods_detail in row_data:
goods = Goods()
goods.name = goods_detail["name"]
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detail["desc"] if goods_detail[
"desc"] is not None else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] is not None else ""
goods.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
category_name = goods_detail["categorys"][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail["images"]:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for goods_detail in row_data:
goods = Goods()
goods.name = goods_detail["name"]
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detail["desc"] if goods_detail[
"desc"] is not None else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] is not None else ""
goods.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
category_name = goods_detail["categorys"][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail["images"]:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
'''
if __name__ == "__main__":
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for g in row_data:
g_instance = Goods()
g_instance.name = g['name']
g_instance.market_price = float(
int(g["sale_price"].replace("￥", "").replace("元", "")))
g_instance.shop_price = float(
int(g["sale_price"].replace("￥", "").replace("元", "")))
g_instance.goods_brief = g['desc'] if g['desc'] is not None else ''
g_instance.goods_desc = g['goods_desc'] if g[
'goods_desc'] is not None else ''
g_instance.goods_front_image = g['images'][0] if g['images'] else ''
# 类别
category = GoodsCategory.objects.filter(name=g['categorys'][-1])
if category:
g_instance.category = category[0]
g_instance.save()
# goodsimage
for img in g['images']:
good_img_instane = GoodsImage()
good_img_instane.goods = g_instance
good_img_instane.image = img
good_img_instane.save()
