views.py 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976
  1. from rest_framework import viewsets
  2. from utils.page import MyPageNumberPagination
  3. from utils.datasolve import sumOfList, transportation_calculate
  4. from utils.md5 import Md5
  5. from rest_framework.filters import OrderingFilter
  6. from django_filters.rest_framework import DjangoFilterBackend
  7. from django.db import transaction
  8. from rest_framework.response import Response
  9. from rest_framework.exceptions import APIException
  10. from django.utils import timezone
  11. from django.db.models import Sum
  12. from .models import BoundListModel, BoundDetailModel,BoundBatchModel, BatchLogModel, OutBatchModel,OutBoundDetailModel,MaterialStatistics,OutBoundDemandModel
  13. # from .files import FileListRenderCN, FileDetailRenderCN
  14. from .serializers import BoundListGetSerializer,BoundListPostSerializer,BoundBatchGetSerializer,BoundBatchPostSerializer,BoundDetailGetSerializer,BoundDetailPostSerializer
  15. from .serializers import OutBoundDetailGetSerializer,OutBoundDetailPostSerializer,OutBatchGetSerializer,OutBatchPostSerializer,BatchLogGetSerializer
  16. from .serializers import MaterialStatisticsSerializer,MaterialStatisticsSerializer_items
  17. from .serializers import OutBoundDemandModelSerializer
  18. from .filter import BoundListFilter, BoundDetailFilter,BoundBatchFilter
  19. from .filter import OutBatchFilter,OutBoundDetailFilter,BatchlogFilter
  20. from .filter import MaterialStatisticsFilter
  21. from .filter import OutBoundDemandFilter
  22. # 以后添加模块检验
  23. from warehouse.models import ListModel as warehouse
  24. from staff.models import ListModel as staff
  25. from rest_framework.permissions import AllowAny
  26. from rest_framework.views import APIView
  27. # 出库需求视图类
  28. class OutBoundDemandViewSet(viewsets.ModelViewSet):
  29. """
  30. retrieve:
  31. Response a data list(get)
  32. list:
  33. Response a data list(all)
  34. create:
  35. Create a data line(post)
  36. delete:
  37. Delete a data line(delete)
  38. """
  39. # authentication_classes = [] # 禁用所有认证类
  40. # permission_classes = [AllowAny] # 允许任意访问
  41. pagination_class = MyPageNumberPagination
  42. filter_backends = [DjangoFilterBackend, OrderingFilter, ]
  43. ordering_fields = ['id', "create_time", "update_time", ]
  44. filter_class = OutBoundDemandFilter
  45. def get_project(self):
  46. try:
  47. id = self.kwargs.get('pk')
  48. return id
  49. except:
  50. return None
  51. def get_queryset(self):
  52. id = self.get_project()
  53. if self.request.user:
  54. if id is None:
  55. return OutBoundDemandModel.objects.filter( is_delete=False)
  56. else:
  57. return OutBoundDemandModel.objects.filter( id=id, is_delete=False)
  58. else:
  59. return OutBoundDemandModel.objects.none()
  60. def get_serializer_class(self):
  61. if self.action in ['list' ]:
  62. return OutBoundDemandModelSerializer
  63. else:
  64. return OutBoundDemandModelSerializer
  65. def batch_list(self, request):
  66. data =self.request.data
  67. OutBoundDemand_all = OutBoundDemandModel.objects.filter(bound_list_id=data['bound_list_id'], is_delete=False).all()
  68. data = OutBoundDemandModelSerializer(OutBoundDemand_all, many=True).data
  69. return_data ={
  70. "code": 200,
  71. "msg": "Success Create",
  72. "data": data
  73. }
  74. return Response(return_data,status=200,headers={})
  75. def create(self, request, *args, **kwargs):
  76. data = self.request.data
  77. data['openid'] = self.request.auth.openid
  78. data['create_time'] = str(timezone.now().strftime('%Y-%m-%d %H:%M:%S'))
  79. data['update_time'] = str(timezone.now().strftime('%Y-%m-%d %H:%M:%S'))
  80. data['working'] = True
  81. bound_list_obj = BoundListModel.objects.get(id=data['bound_list_id'])
  82. OutBoundDemand_obj =OutBoundDemandModel.objects.create(
  83. bound_list=bound_list_obj,
  84. goods_code=data['goods_code'],
  85. goods_desc=data['goods_desc'],
  86. goods_std=data['goods_std'],
  87. goods_unit=data['goods_unit'],
  88. goods_qty=data['goods_out_qty'],
  89. out_type = data['out_type'],
  90. creater=data['creater'],
  91. create_time=data['create_time'],
  92. update_time=data['update_time'],
  93. working=data['working']
  94. )
  95. return_data = OutBoundDemandModelSerializer(OutBoundDemand_obj).data
  96. headers = self.get_success_headers(return_data)
  97. return Response(return_data, status=200, headers=headers)
  98. def batch_demanded_list(self, request):
  99. data =self.request.data
  100. OutBoundDemand_all = OutBatchModel.objects.filter(bound_list_id=data['bound_list_id'], is_delete=False).all()
  101. data = OutBatchGetSerializer(OutBoundDemand_all, many=True).data
  102. return_data = {
  103. "code": 200,
  104. "msg": "Success Create",
  105. "data": data
  106. }
  107. return Response(return_data,status=200,headers={})
  108. def distribute(self, request):
  109. """主分配入口"""
  110. try:
  111. with transaction.atomic():
  112. bound_list_id, demands,out_type, creater= self.validate_distribute_request(request)
  113. if OutBatchModel.objects.filter(bound_list_id=bound_list_id, is_delete=False).exists():
  114. return_data = {
  115. "code": 200,
  116. "msg": "Success Create",
  117. "data": {
  118. "msg": "该订单已分配,请勿重复分配"
  119. }
  120. }
  121. return Response(return_data, status=200, headers={})
  122. aggregated_demands = self.aggregate_demands(demands)
  123. result = self.process_all_goods(aggregated_demands, request, out_type, creater,bound_list_id)
  124. return self.build_success_response(result)
  125. except APIException as e:
  126. return self.build_error_response(e.detail, 200)
  127. except Exception as e:
  128. return self.build_error_response(str(e), 200)
  129. # 验证层方法
  130. def validate_distribute_request(self, request):
  131. """验证请求参数"""
  132. bound_list_id = request.data.get('bound_list_id')
  133. if not bound_list_id:
  134. raise APIException({"detail": "Missing bound_list_id"})
  135. demands = OutBoundDemandModel.objects.filter(
  136. bound_list_id=bound_list_id,
  137. is_delete=False
  138. )
  139. if not demands.exists():
  140. raise APIException({"detail": "No demands found"})
  141. base_info = OutBoundDemandModel.objects.filter(
  142. bound_list_id=bound_list_id,
  143. is_delete=False
  144. ).first()
  145. out_type = base_info.out_type
  146. creater = base_info.creater
  147. return bound_list_id, demands, out_type, creater
  148. # 数据处理层方法
  149. def aggregate_demands(self, demands):
  150. """合并相同物料需求"""
  151. return demands.values('goods_code').annotate(
  152. total_demand=Sum('goods_qty')
  153. )
  154. # 核心分配逻辑
  155. def process_all_goods(self, aggregated_demands, request, out_type, creater,bound_list_id):
  156. """处理所有物料分配"""
  157. return [
  158. self.process_single_goods(
  159. goods_code=item['goods_code'],
  160. total_demand=item['total_demand'],
  161. request=request,
  162. out_type=out_type,
  163. creater=creater,
  164. bound_list_id=bound_list_id
  165. )
  166. for item in aggregated_demands
  167. ]
  168. def process_single_goods(self, goods_code, total_demand, request,out_type, creater,bound_list_id):
  169. """处理单个物料分配"""
  170. batches = self.get_available_batches(goods_code)
  171. remaining, allocations = self.allocate_batches(total_demand, batches, request,out_type, creater,bound_list_id)
  172. if remaining > 0:
  173. raise APIException({
  174. "detail": f"Insufficient stock for {goods_code}",
  175. "required": total_demand,
  176. "allocated": total_demand - remaining
  177. })
  178. return {
  179. "goods_code": goods_code,
  180. "total_demand": total_demand,
  181. "allocations": allocations
  182. }
  183. def get_available_batches(self, goods_code):
  184. """获取可用入库批次"""
  185. return BoundBatchModel.objects.filter(
  186. goods_code=goods_code,
  187. is_delete=False
  188. ).order_by('bound_batch_order')
  189. # 批次分配逻辑
  190. def allocate_batches(self, total_demand, batches, request,out_type, creater,bound_list_id):
  191. """分配具体批次"""
  192. remaining = total_demand
  193. allocations = []
  194. for batch in batches:
  195. if remaining <= 0:
  196. break
  197. allocated = self.allocate_single_batch(
  198. batch=batch,
  199. remaining=remaining,
  200. request=request,
  201. out_type=out_type,
  202. creater=creater,
  203. bound_list_id=bound_list_id
  204. )
  205. if allocated == 0:
  206. continue
  207. allocations.append(allocated)
  208. remaining -= allocated['allocated']
  209. return remaining, allocations
  210. def allocate_single_batch(self, batch, remaining, request,out_type, creater,bound_list_id):
  211. """单个批次分配逻辑"""
  212. available = batch.goods_in_location_qty - batch.goods_out_qty
  213. if available <= 0:
  214. return 0
  215. allocate_qty = min(remaining, available)
  216. self.update_batch_status(batch, allocate_qty)
  217. out_batch = self.create_out_batch(batch, allocate_qty, request,out_type, creater,bound_list_id)
  218. return {
  219. "batch": batch.bound_number,
  220. "allocated": allocate_qty,
  221. "out_batch": out_batch.out_number
  222. }
  223. # 数据操作层方法
  224. def update_batch_status(self, batch, allocate_qty):
  225. """更新批次状态和数量"""
  226. batch.goods_out_qty += allocate_qty
  227. if batch.goods_out_qty == batch.goods_in_location_qty:
  228. batch.status = 6 # 已出库
  229. elif batch.goods_out_qty > 0:
  230. batch.status = 5 # 部分出库
  231. batch.save()
  232. def create_out_batch(self, batch, allocate_qty, request,out_type, creater,bound_list_id):
  233. """创建出库记录"""
  234. out_data = {
  235. 'bound_list': bound_list_id,
  236. 'out_number': self.generate_out_number(batch.goods_code),
  237. 'batch_number': batch.id,
  238. 'out_date': timezone.now(),
  239. 'warehouse_code': batch.warehouse_code,
  240. 'warehouse_name': batch.warehouse_name,
  241. 'goods_code': batch.goods_code,
  242. 'goods_desc': batch.goods_desc,
  243. 'goods_out_qty': allocate_qty,
  244. 'status': 0,
  245. 'openid': request.auth.openid,
  246. 'out_type': out_type,
  247. 'creater': creater,
  248. }
  249. serializer = OutBatchPostSerializer(data=out_data)
  250. if not serializer.is_valid():
  251. raise APIException({
  252. "detail": f"Serialization error for {batch.goods_code}",
  253. "errors": serializer.errors
  254. })
  255. return serializer.save()
  256. # 工具方法
  257. def generate_out_number(self, goods_code):
  258. """生成唯一出库单号"""
  259. timestamp = timezone.now().strftime("%Y%m%d%H%M%S")
  260. import uuid
  261. return f"OUT-{goods_code}-{timestamp}-{uuid.uuid4().hex[:6]}"
  262. def build_success_response(self, data):
  263. """构建成功响应"""
  264. return Response({
  265. "code": 200,
  266. "msg": "Distribution completed",
  267. "data": data
  268. })
  269. def build_error_response(self, error, status_code):
  270. """构建错误响应"""
  271. return Response({
  272. "code": status_code,
  273. "msg": "Distribution failed" if status_code == 400 else "Server error",
  274. "error": error
  275. }, status=status_code)
  276. # 物料统计视图类
  277. class MaterialStatisticsViewSet(viewsets.ModelViewSet):
  278. """
  279. retrieve:
  280. Response a data list(get)
  281. list:
  282. Response a data list(all)
  283. create:
  284. Create a data line(post)
  285. delete:
  286. Delete a data line(delete)
  287. """
  288. # authentication_classes = [] # 禁用所有认证类
  289. # permission_classes = [AllowAny] # 允许任意访问
  290. pagination_class = MyPageNumberPagination
  291. filter_backends = [DjangoFilterBackend, OrderingFilter, ]
  292. ordering_fields = ['id', "create_time", "update_time", ]
  293. filter_class = MaterialStatisticsFilter
  294. def get_project(self):
  295. try:
  296. id = self.kwargs.get('pk')
  297. return id
  298. except:
  299. return None
  300. def get_queryset(self):
  301. id = self.get_project()
  302. if self.request.user:
  303. if id is None:
  304. return MaterialStatistics.objects.filter()
  305. else:
  306. return MaterialStatistics.objects.filter(id=id)
  307. else:
  308. return MaterialStatistics.objects.none()
  309. def get_serializer_class(self):
  310. if self.action in ['list' ]:
  311. return MaterialStatisticsSerializer
  312. elif self.action in ['retrieve']:
  313. return MaterialStatisticsSerializer_items
  314. else:
  315. return self.http_method_not_allowed(request=self.request)
  316. # 汇报单类视图
  317. class BoundListViewSet(viewsets.ModelViewSet):
  318. """
  319. retrieve:
  320. Response a data list(get)
  321. list:
  322. Response a data list(all)
  323. create:
  324. Create a data line(post)
  325. delete:
  326. Delete a data line(delete)
  327. """
  328. # authentication_classes = [] # 禁用所有认证类
  329. # permission_classes = [AllowAny] # 允许任意访问
  330. pagination_class = MyPageNumberPagination
  331. filter_backends = [DjangoFilterBackend, OrderingFilter, ]
  332. ordering_fields = ['id', "create_time", "update_time", ]
  333. filter_class = BoundListFilter
  334. def get_project(self):
  335. try:
  336. id = self.kwargs.get('pk')
  337. return id
  338. except:
  339. return None
  340. def get_queryset(self):
  341. id = self.get_project()
  342. if self.request.user:
  343. if id is None:
  344. return BoundListModel.objects.filter( is_delete=False)
  345. else:
  346. return BoundListModel.objects.filter( id=id, is_delete=False)
  347. else:
  348. return BoundListModel.objects.none()
  349. def get_serializer_class(self):
  350. if self.action in ['list', 'destroy','retrieve']:
  351. return BoundListGetSerializer
  352. elif self.action in ['create', 'update']:
  353. return BoundListPostSerializer
  354. else:
  355. return self.http_method_not_allowed(request=self.request)
  356. def create(self, request, *args, **kwargs):
  357. data = self.request.data
  358. # if BoundListModel.objects.filter(code=data['code'], is_delete=False).exists():
  359. # raise APIException({"detail": "Data exists"})
  360. # else:
  361. data['openid'] = self.request.auth.openid
  362. data['bound_date'] =str(timezone.now().strftime('%Y-%m-%d'))
  363. order_day=str(timezone.now().strftime('%Y-%m-'))
  364. data['bound_month'] =str(timezone.now().strftime('%Y%m'))
  365. if data['bound_type'] == 'in':
  366. data['bound_status'] = '100'
  367. else:
  368. data['bound_status'] = '200'
  369. qs_set = BoundListModel.objects.filter(bound_month=data['bound_month'], bound_code_type=data['bound_code_type'], is_delete=False)
  370. print('qs_set是:', len(qs_set))
  371. if len(qs_set) > 0:
  372. bound_last_code = qs_set.order_by('-id').first().bound_code
  373. data['bound_code'] = data['bound_code_type'] +'-'+ order_day + str(int(bound_last_code.split('-')[-1])+1).zfill(4)
  374. else:
  375. data['bound_code'] = data['bound_code_type'] +'-'+ order_day + '0001'
  376. serializer = self.get_serializer(data=data)
  377. serializer.is_valid(raise_exception=True)
  378. serializer.save()
  379. headers = self.get_success_headers(serializer.data)
  380. return Response(serializer.data, status=200, headers=headers)
  381. def update(self, request, pk):
  382. qs = self.get_object()
  383. data = self.request.data
  384. serializer = self.get_serializer(qs, data=data)
  385. serializer.is_valid(raise_exception=True)
  386. serializer.save()
  387. headers = self.get_success_headers(serializer.data)
  388. return Response(serializer.data, status=200, headers=headers)
  389. def destroy(self, request, pk):
  390. qs = self.get_object()
  391. # if qs.openid != self.request.auth.openid:
  392. # raise APIException({"detail": "该入库非您所属,禁止删除,您可以进行编辑"})
  393. # else:
  394. qs.is_delete = True
  395. qs.bound_code =qs.bound_code+'-delete'+str(timezone.now().strftime('%Y%m%d%H%M%S'))
  396. qs.save()
  397. if qs.bound_type == 'in':
  398. BoundDetailModel.objects.filter(bound_list=qs.id).update(is_delete=True)
  399. if qs.relate_bill:
  400. qs.relate_bill.bound_status = 0
  401. qs.relate_bill.save()
  402. else:
  403. OutBoundDemandModel.objects.filter(bound_list=qs.id).update(is_delete=True)
  404. if qs.relate_out_bill:
  405. qs.relate_out_bill.bound_status = 0
  406. qs.relate_out_bill.save()
  407. serializer = self.get_serializer(qs, many=False)
  408. headers = self.get_success_headers(serializer.data)
  409. return Response(serializer.data, status=200, headers=headers)
  410. # 入库批次类视图
  411. class BoundBatchViewSet(viewsets.ModelViewSet):
  412. """
  413. retrieve:
  414. Response a data list(get)
  415. list:
  416. Response a data list(all)
  417. create:
  418. Create a data line(post)
  419. delete:
  420. Delete a data line(delete)
  421. """
  422. # authentication_classes = [] # 禁用所有认证类
  423. # permission_classes = [AllowAny] # 允许任意访问
  424. pagination_class = MyPageNumberPagination
  425. filter_backends = [DjangoFilterBackend, OrderingFilter, ]
  426. ordering_fields = ['id', "create_time", "update_time", ]
  427. filter_class = BoundBatchFilter
  428. def get_project(self):
  429. try:
  430. id = self.kwargs.get('pk')
  431. return id
  432. except:
  433. return None
  434. def get_queryset(self):
  435. id = self.get_project()
  436. if self.request.user:
  437. if id is None:
  438. return BoundBatchModel.objects.filter( is_delete=False)
  439. else:
  440. return BoundBatchModel.objects.filter( id=id, is_delete=False)
  441. else:
  442. return BoundBatchModel.objects.none()
  443. def get_serializer_class(self):
  444. if self.action in ['list', 'destroy','retrieve']:
  445. return BoundBatchGetSerializer
  446. elif self.action in ['create', 'update']:
  447. return BoundBatchPostSerializer
  448. else:
  449. return self.http_method_not_allowed(request=self.request)
  450. def create(self, request, *args, **kwargs):
  451. data = self.request.data
  452. try:
  453. data['openid'] = self.request.auth.openid
  454. data['goods_total_weight'] = data['goods_weight']*data['goods_qty']
  455. order_day=str(timezone.now().strftime('-%Y%m'))
  456. order_month=str(timezone.now().strftime('%Y%m'))
  457. data['bound_month'] =str(timezone.now().strftime('%Y%m'))
  458. print(data['order'])
  459. if data['order'] == 'true':
  460. qs_set = BoundBatchModel.objects.filter( goods_code=data['goods_code'], bound_month=order_month, is_delete=False)
  461. print('qs_set是:', len(qs_set))
  462. if len(qs_set) > 0:
  463. bound_last_code = qs_set.order_by('-bound_batch_order').first().bound_number
  464. data['bound_batch_order'] = int(bound_last_code.split('-')[-1])+1
  465. data['bound_number'] = data['goods_code'] + '-' + str(int(bound_last_code.split('-')[-1])+1)
  466. else:
  467. data['bound_batch_order'] = int(order_day.split('-')[-1])*1000 +1
  468. data['bound_number'] = data['goods_code'] + order_day + '001'
  469. else:
  470. data['bound_number'] = data['goods_code'] + '-' + str(data['bound_batch_order'])
  471. serializer = self.get_serializer(data=data)
  472. serializer.is_valid(raise_exception=True)
  473. serializer.save()
  474. headers = self.get_success_headers(serializer.data)
  475. self.add_batch_log(serializer.data, 0, data['goods_qty'])
  476. return Response(serializer.data, status=200, headers=headers)
  477. except Exception as e:
  478. print(e)
  479. raise APIException({"detail": "{}".format(e)})
  480. def add_batch_log(self, data, log_type, goods_qty):
  481. choices_dict = dict(BatchLogModel.BATCH_LOG_TYPE)
  482. log_type_name = choices_dict.get(log_type, "未知类型")
  483. try:
  484. # 获取 BoundBatchModel 实例
  485. batch_obj = BoundBatchModel.objects.get(id=data['id'])
  486. except BoundBatchModel.DoesNotExist:
  487. return False
  488. log_data = {
  489. 'batch_id': batch_obj,
  490. 'log_type': log_type,
  491. 'log_date': timezone.now().strftime('%Y-%m-%d-%H:%M'), # 直接格式化时间,无需转字符串
  492. 'goods_code': data['goods_code'],
  493. 'goods_desc': data['goods_desc'],
  494. 'goods_qty': data['goods_qty'],
  495. 'log_content': f"{log_type_name} {data['goods_qty']}件",
  496. 'creater': data['creater'],
  497. 'openid': data['openid'],
  498. 'is_delete': False,
  499. }
  500. # 创建日志记录
  501. BatchLogModel.objects.create(**log_data)
  502. return True
  503. def update(self, request, pk):
  504. qs = self.get_object()
  505. data = self.request.data
  506. serializer = self.get_serializer(qs, data=data)
  507. serializer.is_valid(raise_exception=True)
  508. serializer.save()
  509. headers = self.get_success_headers(serializer.data)
  510. return Response(serializer.data, status=200, headers=headers)
  511. def destroy(self, request, pk):
  512. qs = self.get_object()
  513. if qs.openid != self.request.auth.openid:
  514. raise APIException({"detail": "该入库非您所属,禁止删除,您可以进行编辑"})
  515. else:
  516. qs.is_delete = True
  517. qs.save()
  518. serializer = self.get_serializer(qs, many=False)
  519. headers = self.get_success_headers(serializer.data)
  520. return Response(serializer.data, status=200, headers=headers)
  521. # 入库明细类视图
  522. class BoundDetailViewSet(viewsets.ModelViewSet):
  523. """
  524. retrieve:
  525. Response a data list(get)
  526. list:
  527. Response a data list(all)
  528. create:
  529. Create a data line(post)
  530. delete:
  531. Delete a data line(delete)
  532. """
  533. # authentication_classes = [] # 禁用所有认证类
  534. # permission_classes = [AllowAny] # 允许任意访问
  535. pagination_class = MyPageNumberPagination
  536. filter_backends = [DjangoFilterBackend, OrderingFilter, ]
  537. ordering_fields = ['id', "create_time", "update_time", ]
  538. filter_class = BoundDetailFilter
  539. def get_project(self):
  540. try:
  541. id = self.kwargs.get('pk')
  542. return id
  543. except:
  544. return None
  545. def get_queryset(self):
  546. id = self.get_project()
  547. if self.request.user:
  548. if id is None:
  549. return BoundDetailModel.objects.filter( is_delete=False)
  550. else:
  551. return BoundDetailModel.objects.filter( id=id, is_delete=False)
  552. else:
  553. return BoundDetailModel.objects.none()
  554. def get_serializer_class(self):
  555. if self.action in ['list', 'destroy','retrieve']:
  556. return BoundDetailGetSerializer
  557. elif self.action in ['create', 'update']:
  558. return BoundDetailPostSerializer
  559. else:
  560. return self.http_method_not_allowed(request=self.request)
  561. def create(self, request, *args, **kwargs):
  562. data = self.request.data
  563. data['openid'] = self.request.auth.openid
  564. data.setdefault('is_delete', False)
  565. # 验证并保存数据
  566. data['detail_code'] = f"DC-{data['bound_list']:02}{data['bound_batch']:02}"
  567. print(data['detail_code'])
  568. if BoundDetailModel.objects.filter(detail_code=data['detail_code'], is_delete=False).exists():
  569. raise APIException({"detail": "Data exists"})
  570. else:
  571. serializer = self.get_serializer(data=data)
  572. serializer.is_valid(raise_exception=True)
  573. serializer.save()
  574. # 返回响应
  575. headers = self.get_success_headers(serializer.data)
  576. return Response(serializer.data, status=200, headers=headers)
  577. def update(self, request, pk):
  578. qs = self.get_object()
  579. data = self.request.data
  580. serializer = self.get_serializer(qs, data=data)
  581. serializer.is_valid(raise_exception=True)
  582. serializer.save()
  583. headers = self.get_success_headers(serializer.data)
  584. return Response(serializer.data, status=200, headers=headers)
  585. def destroy(self, request, pk):
  586. qs = self.get_object()
  587. if qs.openid != self.request.auth.openid:
  588. raise APIException({"detail": "该入库非您所属,禁止删除,您可以进行编辑"})
  589. else:
  590. qs.is_delete = True
  591. qs.save()
  592. serializer = self.get_serializer(qs, many=False)
  593. headers = self.get_success_headers(serializer.data)
  594. return Response(serializer.data, status=200, headers=headers)
  595. # 出库明细类视图
  596. class OutBoundDetailViewSet(viewsets.ModelViewSet):
  597. """
  598. retrieve:
  599. Response a data list(get)
  600. list: Response a data list(all)
  601. create:
  602. Create a data line(post)
  603. delete:
  604. Delete a data line(delete)
  605. """
  606. # authentication_classes = [] # 禁用所有认证类
  607. # permission_classes = [AllowAny] # 允许任意访问
  608. pagination_class = MyPageNumberPagination
  609. filter_backends = [DjangoFilterBackend, OrderingFilter, ]
  610. ordering_fields = ['id', "create_time", "update_time", ]
  611. filter_class = OutBoundDetailFilter
  612. def get_project(self):
  613. try:
  614. id = self.kwargs.get('pk')
  615. return id
  616. except:
  617. return None
  618. def get_queryset(self):
  619. id = self.get_project()
  620. if self.request.user:
  621. if id is None:
  622. return OutBoundDetailModel.objects.filter( is_delete=False)
  623. else:
  624. return OutBoundDetailModel.objects.filter( id=id, is_delete=False)
  625. else:
  626. return OutBoundDetailModel.objects.none()
  627. def get_serializer_class(self):
  628. if self.action in ['list', 'destroy','retrieve']:
  629. return OutBoundDetailGetSerializer
  630. elif self.action in ['create', 'update']:
  631. return OutBoundDetailPostSerializer
  632. else:
  633. return self.http_method_not_allowed(request=self.request)
  634. def create(self, request, *args, **kwargs):
  635. data = self.request.data
  636. data['openid'] = self.request.auth.openid
  637. data.setdefault('is_delete', False)
  638. data['bound_batch_number'] = OutBatchModel.objects.get(id=data['bound_batch']).batch_number.id
  639. # 验证并保存数据
  640. data['detail_code'] = f"DC-{data['bound_list']:02}{data['bound_batch']:02}"
  641. print(data['detail_code'])
  642. if OutBoundDetailModel.objects.filter(detail_code=data['detail_code'], is_delete=False).exists():
  643. raise APIException({"detail": "Data exists"})
  644. else:
  645. serializer = self.get_serializer(data=data)
  646. serializer.is_valid(raise_exception=True)
  647. serializer.save()
  648. # 返回响应
  649. headers = self.get_success_headers(serializer.data)
  650. return Response(serializer.data, status=200, headers=headers)
  651. def update(self, request, pk):
  652. qs = self.get_object()
  653. data = self.request.data
  654. serializer = self.get_serializer(qs, data=data)
  655. serializer.is_valid(raise_exception=True)
  656. serializer.save()
  657. headers = self.get_success_headers(serializer.data)
  658. return Response(serializer.data, status=200, headers=headers)
  659. def destroy(self, request, pk):
  660. qs = self.get_object()
  661. if qs.openid != self.request.auth.openid:
  662. raise APIException({"detail": "该入库非您所属,禁止删除,您可以进行编辑"})
  663. else:
  664. qs.is_delete = True
  665. qs.save()
  666. serializer = self.get_serializer(qs, many=False)
  667. headers = self.get_success_headers(serializer.data)
  668. return Response(serializer.data, status=200, headers=headers)
  669. # 出库批次类视图
  670. class OutBoundBatchViewSet(viewsets.ModelViewSet):
  671. """
  672. retrieve:
  673. Response a data list(get)
  674. list:
  675. Response a data list(all)
  676. create:
  677. Create a data line(post)
  678. delete:
  679. Delete a data line(delete)
  680. """
  681. # authentication_classes = [] # 禁用所有认证类
  682. # permission_classes = [AllowAny] # 允许任意访问
  683. pagination_class = MyPageNumberPagination
  684. filter_backends = [DjangoFilterBackend, OrderingFilter, ]
  685. ordering_fields = ['id', "create_time", "update_time", ]
  686. filter_class = OutBatchFilter
  687. def get_project(self):
  688. try:
  689. id = self.kwargs.get('pk')
  690. return id
  691. except:
  692. return None
  693. def get_queryset(self):
  694. id = self.get_project()
  695. if self.request.user:
  696. if id is None:
  697. return OutBatchModel.objects.filter( is_delete=False)
  698. else:
  699. return OutBatchModel.objects.filter( id=id, is_delete=False)
  700. else:
  701. return OutBatchModel.objects.none()
  702. def get_serializer_class(self):
  703. if self.action in ['list', 'destroy','retrieve']:
  704. return OutBatchGetSerializer
  705. elif self.action in ['create', 'update']:
  706. return OutBatchPostSerializer
  707. else:
  708. return self.http_method_not_allowed(request=self.request)
  709. def create(self, request, *args, **kwargs):
  710. data = self.request.data
  711. batch_obj = BoundBatchModel.objects.get(bound_number=data['out_number'])
  712. if batch_obj is None:
  713. raise APIException({"detail": "批次不存在"})
  714. bound_obj = BoundListModel.objects.get(id=data['bound_list_id'])
  715. data['bound_list'] = bound_obj.id
  716. data['batch_number'] = batch_obj.id
  717. data['out_date'] = str(timezone.now().strftime('%Y-%m-%d %H:%M:%S'))
  718. data['openid'] = self.request.auth.openid
  719. data.setdefault('is_delete', False)
  720. data['goods_total_weight'] = data['goods_weight']*data['goods_out_qty']
  721. data['goods_qty'] = batch_obj.goods_qty -batch_obj.goods_reserve_qty - data['goods_out_qty']
  722. data['status'] = 0 #现在处于出库申请状态
  723. serializer = self.get_serializer(data=data)
  724. serializer.is_valid(raise_exception=True)
  725. serializer.save()
  726. headers = self.get_success_headers(serializer.data)
  727. self.add_batch_log(serializer.data, 1, data['goods_out_qty'])
  728. return Response(serializer.data, status=200, headers=headers)
  729. def update(self, request, pk):
  730. qs = self.get_object()
  731. data = self.request.data
  732. data['openid'] = self.request.auth.openid
  733. data.setdefault('is_delete', False)
  734. data['goods_total_weight'] = data['goods_weight']*data['goods_qty']
  735. serializer = self.get_serializer(qs, data=data)
  736. serializer.is_valid(raise_exception=True)
  737. serializer.save()
  738. headers = self.get_success_headers(serializer.data)
  739. self.add_batch_log(serializer.data, 1, data['goods_qty'])
  740. return Response(serializer.data, status=200, headers=headers)
  741. def destroy(self, request, pk):
  742. qs = self.get_object()
  743. if qs.openid != self.request.auth.openid:
  744. raise APIException({"detail": "该出库非您所属,禁止删除,您可以进行编辑"})
  745. else:
  746. qs.is_delete = True
  747. qs.save()
  748. serializer = self.get_serializer(qs, many=False)
  749. headers = self.get_success_headers(serializer.data)
  750. return Response(serializer.data, status=200, headers=headers)
  751. def add_batch_log(self, data, log_type, goods_qty):
  752. choices_dict = dict(BatchLogModel.BATCH_LOG_TYPE)
  753. log_type_name = choices_dict.get(log_type, "未知类型")
  754. try:
  755. # 获取 BoundBatchModel 实例
  756. batch_obj = BoundBatchModel.objects.get(id=data['batch_number'])
  757. except BoundBatchModel.DoesNotExist:
  758. # 处理批次不存在的情况(如记录日志或抛出异常)
  759. return False
  760. log_data = {
  761. 'batch_id': batch_obj, # 关键修复:传入实例对象,而不是 batch_obj.id
  762. 'log_type': log_type,
  763. 'log_date': timezone.now().strftime('%Y-%m-%d-%H:%M'), # 直接格式化时间,无需转字符串
  764. 'goods_code': data['goods_code'],
  765. 'goods_desc': data['goods_desc'],
  766. 'goods_qty': data['goods_qty'],
  767. 'log_content': f"{log_type_name} {goods_qty}件",
  768. 'creater': data['creater'],
  769. 'openid': data['openid'],
  770. 'is_delete': False,
  771. # 注意:create_time 和 update_time 由模型的 auto_now_add 和 auto_now 自动处理,无需手动赋值
  772. }
  773. # 创建日志记录
  774. BatchLogModel.objects.create(**log_data)
  775. return True
  776. # 批次操作日志类视图
  777. class BoundBatchLogViewSet(viewsets.ModelViewSet):
  778. """
  779. retrieve:
  780. Response a data list(get)
  781. list:
  782. Response a data list(all)
  783. delete:
  784. Delete a data line(delete)
  785. """
  786. # authentication_classes = [] # 禁用所有认证类
  787. # permission_classes = [AllowAny] # 允许任意访问
  788. pagination_class = MyPageNumberPagination
  789. filter_backends = [DjangoFilterBackend, OrderingFilter, ]
  790. ordering_fields = ['id', "create_time", "update_time", ]
  791. filter_class = BatchlogFilter
  792. def get_queryset(self):
  793. return BatchLogModel.objects.filter( is_delete=False)
  794. def get_serializer_class(self):
  795. if self.action in ['list', 'destroy','retrieve']:
  796. return BatchLogGetSerializer
  797. else:
  798. return self.http_method_not_allowed(request=self.request)
  799. def destroy(self, request, pk):
  800. qs = self.get_object()
  801. qs.is_delete = True
  802. qs.save()
  803. serializer = self.get_serializer(qs, many=False)
  804. headers = self.get_success_headers(serializer.data)
  805. return Response(serializer.data, status=200, headers=headers)
  806. # 托盘类视图
  807. class BatchContainerAPIView(APIView):
  808. """
  809. post:
  810. 返回批次对应的container列表
  811. """
  812. # authentication_classes = [] # 禁用所有认证类
  813. # permission_classes = [AllowAny] # 允许任意访问
  814. def post(self, request):
  815. data = request.data
  816. batch_id = data.get('batch_id')
  817. from container.models import ContainerDetailModel
  818. container_detail_all = ContainerDetailModel.objects.filter(batch_id=batch_id, is_delete=False).exclude(status=3).all()
  819. container_dict = {}
  820. for container_detail in container_detail_all:
  821. container_id = container_detail.container_id
  822. if container_id not in container_dict:
  823. container_dict[container_id] = {
  824. 'id': container_id,
  825. 'goods_code': container_detail.goods_code,
  826. 'goods_desc': container_detail.goods_desc,
  827. 'container_code': container_detail.container.container_code,
  828. 'current_location': container_detail.container.current_location,
  829. 'goods_qty': container_detail.goods_qty-container_detail.goods_out_qty,
  830. 'class':container_detail.goods_class
  831. }
  832. else:
  833. container_dict[container_id]['goods_qty'] += container_detail.goods_qty-container_detail.goods_out_qty
  834. container_dict = list(container_dict.values())
  835. return_data = {'code': 200,'msg': 'Success Create', 'data': container_dict}
  836. return Response(return_data)