123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369 |
- from rest_framework import viewsets
- from .models import ListModel
- from . import serializers
- from .page import MyPageNumberPagination
- from rest_framework.filters import OrderingFilter
- from django_filters.rest_framework import DjangoFilterBackend
- from rest_framework.response import Response
- from .filter import Filter
- from rest_framework.exceptions import APIException
- from goodsunit.models import ListModel as goods_unit
- from goodsclass.models import ListModel as goods_class
- from goodsbrand.models import ListModel as goods_brand
- from goodscolor.models import ListModel as goods_color
- from goodsshape.models import ListModel as goods_shape
- from goodsspecs.models import ListModel as goods_specs
- from goodsorigin.models import ListModel as goods_origin
- from supplier.models import ListModel as supplier
- from scanner.models import ListModel as scanner
- from utils.md5 import Md5
- from .serializers import FileRenderSerializer
- from django.http import StreamingHttpResponse
- from .files import FileRenderCN, FileRenderEN
- from rest_framework.settings import api_settings
- from asn.models import AsnDetailModel
- from django.db.models import Q
- class SannerGoodsTagView(viewsets.ModelViewSet):
- """
- retrieve:
- Response a data retrieve(get)
- """
- pagination_class = MyPageNumberPagination
- filter_backends = [DjangoFilterBackend, OrderingFilter, ]
- ordering_fields = ['id', "create_time", "update_time", ]
- filter_class = Filter
- lookup_field = 'bar_code'
- def get_project(self):
- try:
- bar_code = self.kwargs['bar_code']
- return bar_code
- except:
- return None
- def get_queryset(self):
- bar_code = self.get_project()
- if self.request.user:
- if bar_code is None:
- return ListModel.objects.filter(openid=self.request.auth.openid, is_delete=False)
- else:
- return ListModel.objects.filter(openid=self.request.auth.openid, bar_code=bar_code, is_delete=False)
- else:
- return ListModel.objects.filter().none()
- def get_serializer_class(self):
- if self.action in ['list', 'retrieve', 'destroy']:
- return serializers.GoodsGetSerializer
- elif self.action in ['create']:
- return serializers.GoodsPostSerializer
- elif self.action in ['update']:
- return serializers.GoodsUpdateSerializer
- elif self.action in ['partial_update']:
- return serializers.GoodsPartialUpdateSerializer
- else:
- return self.http_method_not_allowed(request=self.request)
- def retrieve(self, request, *args, **kwargs):
- data=self.request.GET.get('asn_code')
- instance = self.get_object()
- serializer = self.get_serializer(instance)
- good_detail=AsnDetailModel.objects.filter(asn_code=data,goods_code=serializer.data['goods_code']).first()
- if good_detail is None:
- raise APIException({"detail":"The product label does not exist"})
- else:
- context = {}
- context['goods_code'] = good_detail.goods_code
- context['goods_actual_qty'] = good_detail.goods_actual_qty
- return Response(context, status=200)
- class APIViewSet(viewsets.ModelViewSet):
- """
- retrieve:
- Response a data list(get)
- list:
- Response a data list(all)
- create:
- Create a data line(post)
- delete:
- Delete a data line(delete)
- partial_update:
- Partial_update a data(patch:partial_update)
- update:
- Update a data(put:update)
- """
- pagination_class = MyPageNumberPagination
- filter_backends = [DjangoFilterBackend, OrderingFilter, ]
- ordering_fields = ['id', "create_time", "update_time", ]
- filter_class = Filter
- def get_project(self):
- try:
- id = self.kwargs.get('pk')
- return id
- except:
- return None
- def get_queryset(self):
- id = self.get_project()
- if self.request.user:
- search_word = self.request.GET.get('search', '')
- if search_word:
- if id is None:
- data_list = ListModel.objects.filter(openid=self.request.auth.openid, is_delete=False)
- search_list = data_list.filter(Q(goods_shape=search_word) | Q(goods_specs=search_word))
- return search_list
- else:
- data_list = ListModel.objects.filter(openid=self.request.auth.openid, id=id, is_delete=False)
- search_list = data_list.filter(Q(goods_shape=search_word) | Q(goods_specs=search_word))
- return search_list
- else:
- if id is None:
- return ListModel.objects.filter(openid=self.request.auth.openid, is_delete=False)
- else:
- return ListModel.objects.filter(openid=self.request.auth.openid, id=id, is_delete=False)
- else:
- return ListModel.objects.filter().none()
- def get_serializer_class(self):
- if self.action in ['list', 'retrieve', 'destroy']:
- return serializers.GoodsGetSerializer
- elif self.action in ['create']:
- return serializers.GoodsPostSerializer
- elif self.action in ['update']:
- return serializers.GoodsUpdateSerializer
- elif self.action in ['partial_update']:
- return serializers.GoodsPartialUpdateSerializer
- else:
- return self.http_method_not_allowed(request=self.request)
- def create(self, request, *args, **kwargs):
- data = self.request.data
- data['openid'] = self.request.auth.openid
- data['unit_volume'] = round(
- (float(data['goods_w']) * float(data['goods_d']) * float(data['goods_h'])) / 1000000000, 4)
- if ListModel.objects.filter(openid=data['openid'], goods_code=data['goods_code'], is_delete=False).exists():
- raise APIException({"detail": "Data Exists"})
- else:
- if supplier.objects.filter(openid=data['openid'], supplier_name=data['goods_supplier'],
- is_delete=False).exists():
- if goods_unit.objects.filter(openid=data['openid'], goods_unit=data['goods_unit'],
- is_delete=False).exists():
- if goods_class.objects.filter(openid=data['openid'], goods_class=data['goods_class'],
- is_delete=False).exists():
- if goods_brand.objects.filter(openid=data['openid'], goods_brand=data['goods_brand'],
- is_delete=False).exists():
- if goods_color.objects.filter(openid=data['openid'], goods_color=data['goods_color'],
- is_delete=False).exists():
- if goods_shape.objects.filter(openid=data['openid'], goods_shape=data['goods_shape'],
- is_delete=False).exists():
- if goods_specs.objects.filter(openid=data['openid'],
- goods_specs=data['goods_specs'],
- is_delete=False).exists():
- if goods_origin.objects.filter(openid=data['openid'],
- goods_origin=data['goods_origin'],
- is_delete=False).exists():
- data['bar_code'] = Md5.md5(data['goods_code'])
- serializer = self.get_serializer(data=data)
- serializer.is_valid(raise_exception=True)
- serializer.save()
- scanner.objects.create(openid=self.request.auth.openid, mode="GOODS",
- code=data['goods_code'],
- bar_code=data['bar_code'])
- headers = self.get_success_headers(serializer.data)
- return Response(serializer.data, status=200, headers=headers)
- else:
- raise APIException(
- {"detail": "Goods Origin does not exists or it has been changed"})
- else:
- raise APIException(
- {"detail": "Goods Specs does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Shape does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Color does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Brand does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Class does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Unit does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Supplier does not exists or it has been changed"})
- def update(self, request, pk):
- qs = self.get_object()
- if qs.openid != self.request.auth.openid:
- raise APIException({"detail": "Cannot update data which not yours"})
- else:
- data = self.request.data
- data['unit_volume'] = round(
- (float(data['goods_w']) * float(data['goods_d']) * float(data['goods_h'])) / 1000000000, 4)
- if supplier.objects.filter(openid=self.request.auth.openid, supplier_name=data['goods_supplier'],
- is_delete=False).exists():
- if goods_unit.objects.filter(openid=self.request.auth.openid, goods_unit=data['goods_unit'],
- is_delete=False).exists():
- if goods_class.objects.filter(openid=self.request.auth.openid, goods_class=data['goods_class'],
- is_delete=False).exists():
- if goods_brand.objects.filter(openid=self.request.auth.openid, goods_brand=data['goods_brand'],
- is_delete=False).exists():
- if goods_color.objects.filter(openid=self.request.auth.openid, goods_color=data['goods_color'],
- is_delete=False).exists():
- if goods_shape.objects.filter(openid=self.request.auth.openid, goods_shape=data['goods_shape'],
- is_delete=False).exists():
- if goods_specs.objects.filter(openid=self.request.auth.openid,
- goods_specs=data['goods_specs'],
- is_delete=False).exists():
- if goods_origin.objects.filter(openid=self.request.auth.openid,
- goods_origin=data['goods_origin'],
- is_delete=False).exists():
- scanner.objects.filter(openid=self.request.auth.openid,
- mode='GOODS',
- code=qs.goods_code).update(code=str(data['goods_code']))
- serializer = self.get_serializer(qs, data=data)
- serializer.is_valid(raise_exception=True)
- serializer.save()
- headers = self.get_success_headers(serializer.data)
- return Response(serializer.data, status=200, headers=headers)
- else:
- raise APIException(
- {"detail": "Goods Origin does not exists or it has been changed"})
- else:
- raise APIException(
- {"detail": "Goods Specs does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Shape does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Color does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Brand does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Class does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Unit does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Supplier does not exists or it has been changed"})
- def partial_update(self, request, pk):
- qs = self.get_object()
- if qs.openid != self.request.auth.openid:
- raise APIException({"detail": "Cannot partial_update data which not yours"})
- else:
- data = self.request.data
- if supplier.objects.filter(openid=self.request.auth.openid, supplier_name=data['goods_supplier'],
- is_delete=False).exists():
- if goods_unit.objects.filter(openid=self.request.auth.openid, goods_unit=data['goods_unit'],
- is_delete=False).exists():
- if goods_class.objects.filter(openid=self.request.auth.openid, goods_class=data['goods_class'],
- is_delete=False).exists():
- if goods_brand.objects.filter(openid=self.request.auth.openid, goods_brand=data['goods_brand'],
- is_delete=False).exists():
- if goods_color.objects.filter(openid=self.request.auth.openid, goods_color=data['goods_color'],
- is_delete=False).exists():
- if goods_shape.objects.filter(openid=self.request.auth.openid, goods_shape=data['goods_shape'],
- is_delete=False).exists():
- if goods_specs.objects.filter(openid=self.request.auth.openid,
- goods_specs=data['goods_specs'],
- is_delete=False).exists():
- if goods_origin.objects.filter(openid=self.request.auth.openid,
- goods_origin=data['goods_origin'],
- is_delete=False).exists():
- scanner.objects.filter(openid=self.request.auth.openid,
- mode='GOODS',
- code=qs.goods_code).update(
- code=str(data['goods_code']))
- serializer = self.get_serializer(qs, data=data, partial=True)
- serializer.is_valid(raise_exception=True)
- serializer.save()
- headers = self.get_success_headers(serializer.data)
- return Response(serializer.data, status=200, headers=headers)
- else:
- raise APIException(
- {"detail": "Goods Origin does not exists or it has been changed"})
- else:
- raise APIException(
- {"detail": "Goods Specs does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Shape does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Color does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Brand does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Class does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Goods Unit does not exists or it has been changed"})
- else:
- raise APIException({"detail": "Supplier does not exists or it has been changed"})
- def destroy(self, request, pk):
- qs = self.get_object()
- if qs.openid != self.request.auth.openid:
- raise APIException({"detail": "Cannot delete data which not yours"})
- else:
- qs.is_delete = True
- qs.save()
- serializer = self.get_serializer(qs, many=False)
- headers = self.get_success_headers(serializer.data)
- return Response(serializer.data, status=200, headers=headers)
- class FileDownloadView(viewsets.ModelViewSet):
- renderer_classes = (FileRenderCN, ) + tuple(api_settings.DEFAULT_RENDERER_CLASSES)
- filter_backends = [DjangoFilterBackend, OrderingFilter, ]
- ordering_fields = ['id', "create_time", "update_time", ]
- filter_class = Filter
- def get_project(self):
- try:
- id = self.kwargs.get('pk')
- return id
- except:
- return None
- def get_queryset(self):
- id = self.get_project()
- if self.request.user:
- if id is None:
- return ListModel.objects.filter(openid=self.request.auth.openid, is_delete=False)
- else:
- return ListModel.objects.filter(openid=self.request.auth.openid, id=id, is_delete=False)
- else:
- return ListModel.objects.none()
- def get_serializer_class(self):
- if self.action in ['list']:
- return serializers.FileRenderSerializer
- else:
- return self.http_method_not_allowed(request=self.request)
- def get_lang(self, data):
- lang = self.request.META.get('HTTP_LANGUAGE')
- if lang:
- if lang == 'zh-hans':
- return FileRenderCN().render(data)
- else:
- return FileRenderEN().render(data)
- else:
- return FileRenderEN().render(data)
- def list(self, request, *args, **kwargs):
- from datetime import datetime
- dt = datetime.now()
- data = (
- FileRenderSerializer(instance).data
- for instance in self.filter_queryset(self.get_queryset())
- )
- renderer = self.get_lang(data)
- response = StreamingHttpResponse(
- renderer,
- content_type="text/csv"
- )
- response['Content-Disposition'] = "attachment; filename='goodslist_{}.csv'".format(str(dt.strftime('%Y%m%d%H%M%S%f')))
- return response
|