def delete(self, request, *args, **kwargs):
vip_id = Users.objects.filter(appid=request.user.appid,
developer=1,
is_delete=0).first().vip
vip_check = VipCheck.VipCheck(vip_id)
if vip_check == "N":
return Response(FBMsg.wms_vip())
elif vip_check == "Y":
data = DataSolve.datasolve(request)
for i in range(len(data)):
if ListModel.objects.filter(appid=request.user.appid,
t_code=str(data[i]['t_code']),
is_delete=0).exists():
pass
else:
ret = FBMsg.wms_err()
ret['data'] = data
return Response(ret)
for j in range(len(data)):
delete_data = ListModel.objects.filter(
appid=request.user.appid,
t_code=str(data[j]['t_code']),
is_delete=0).first()
delete_data.is_delete = 1
delete_data.save()
ip = request.META.get('HTTP_X_FORWARDED_FOR') if request.META.get(
'HTTP_X_FORWARDED_FOR') else request.META.get('REMOTE_ADDR')
ret = FBMsg.wms_ret()
ret['ip'] = ip
ret['data'] = data
return Response(ret)
else:
return Response(FBMsg.wms_vip())
def patch(self, request, *args, **kwargs):
vip_id = Users.objects.filter(appid=request.user.appid, developer=1, is_delete=0).first().vip
vip_check = VipCheck.VipCheck(vip_id)
if vip_check == "N":
return Response(FBMsg.wms_vip())
elif vip_check == "Y":
data = DataSolve.datasolve(request)
try:
if data['code'] == "1031":
return Response(FBMsg.err_bad())
except:
if ListModel.objects.filter(appid=request.user.appid, t_code=str(data['t_code']), is_delete=0).exists():
patch_name = ListModel.objects.get(t_code=str(data['t_code'])).name
if patch_name != str(data['name']):
if ListModel.objects.filter(appid=request.user.appid, name=str(data['name']), is_delete=0).exists():
ret = FBMsg.wms_same()
ret['data'] = data
return Response(ret)
patch_data = ListModel.objects.filter(appid=request.user.appid, t_code=str(data['t_code']), is_delete=0).first()
if 'name' in data:
patch_data.name = str(data['name'])
patch_data.save()
ip = request.META.get('HTTP_X_FORWARDED_FOR') if request.META.get(
'HTTP_X_FORWARDED_FOR') else request.META.get('REMOTE_ADDR')
ret = FBMsg.wms_ret()
ret['ip'] = ip
ret['data'] = data
return Response(ret)
else:
ret = FBMsg.wms_err()
ret['data'] = data
return Response(ret)
else:
return Response(FBMsg.wms_vip())
def delete(self, request, *args, **kwargs):
vip_id = Users.objects.filter(appid=request.user.appid, developer=1, is_delete=0).first().vip
vip_check = VipCheck.VipCheck(vip_id)
if vip_check == "N":
return Response(FBMsg.wms_vip())
elif vip_check == "Y":
data = DataSolve.datasolve(request)
for i in range(len(data)):
if Users.objects.filter(appid=request.user.appid, transaction_code=data[i]['transaction_code'], is_delete=0).exists():
user = Users.objects.get(transaction_code=data[i]['transaction_code'])
if user.developer == 1:
ret = FBMsg.wms_dev()
ret['data'] = data
return Response(ret)
if user.name == Users.objects.get(openid=request.auth, appid=request.user.appid, is_delete=0).name:
ret = FBMsg.wms_user_owner()
ret['data'] = data
return Response(ret)
else:
ret = FBMsg.wms_err()
ret['data'] = data
return Response(ret)
for j in range(len(data)):
delete_data = Users.objects.filter(appid=request.user.appid, transaction_code=data[j]['transaction_code'], is_delete=0).first()
delete_data.is_delete = 1
delete_data.save()
ip = request.META.get('HTTP_X_FORWARDED_FOR') if request.META.get(
'HTTP_X_FORWARDED_FOR') else request.META.get('REMOTE_ADDR')
ret = FBMsg.wms_ret()
ret['ip'] = ip
ret['data'] = data
return Response(ret)
else:
return Response(FBMsg.wms_vip())
def patch(self, request, *args, **kwargs):
vip_id = Users.objects.filter(appid=request.user.appid,
developer=1,
is_delete=0).first().vip
vip_check = VipCheck.VipCheck(vip_id)
if vip_check == "N":
return Response(FBMsg.wms_vip())
elif vip_check == "Y":
data = DataSolve.datasolve(request)
try:
if data['code'] == "1031":
return Response(FBMsg.err_bad())
except:
if UserAuth.objects.filter(appid=request.user.appid,
t_code=data['t_code'],
is_delete=0).exists():
patch_name = UserAuth.objects.get(
t_code=data['t_code']).name
if patch_name != data['name']:
if UserAuth.objects.filter(appid=request.user.appid,
name=data['name'],
is_delete=0).exists():
ret = FBMsg.wms_same()
ret['data'] = data
return Response(ret)
patch_data = UserAuth.objects.filter(
appid=request.user.appid,
t_code=data['t_code'],
is_delete=0).first()
if 'name' in data:
patch_data.name = data['name']
if 'aut1' in data:
if str(data['aut1']) == "1":
patch_data.aut1 = int(data['aut1'])
elif str(data['aut1']) == "0":
patch_data.aut1 = int(data['aut1'])
if 'aut2' in data:
if str(data['aut2']) == "1":
patch_data.aut2 = int(data['aut2'])
elif str(data['aut2']) == "0":
patch_data.aut2 = int(data['aut2'])
if 'aut3' in data:
if str(data['aut3']) == "1":
patch_data.aut3 = int(data['aut3'])
elif str(data['aut3']) == "0":
patch_data.aut3 = int(data['aut3'])
if 'aut4' in data:
if str(data['aut4']) == "1":
patch_data.aut4 = int(data['aut4'])
elif str(data['aut4']) == "0":
patch_data.aut4 = int(data['aut4'])
if 'aut5' in data:
if str(data['aut5']) == "1":
patch_data.aut5 = int(data['aut5'])
elif str(data['aut5']) == "0":
patch_data.aut5 = int(data['aut5'])
if 'aut6' in data:
if str(data['aut6']) == "1":
patch_data.aut6 = int(data['aut6'])
elif str(data['aut6']) == "0":
patch_data.aut6 = int(data['aut6'])
if 'aut7' in data:
if str(data['aut7']) == "1":
patch_data.aut7 = int(data['aut7'])
elif str(data['aut7']) == "0":
patch_data.aut7 = int(data['aut7'])
if 'aut8' in data:
if str(data['aut8']) == "1":
patch_data.aut8 = int(data['aut8'])
elif str(data['aut8']) == "0":
patch_data.aut8 = int(data['aut8'])
if 'aut9' in data:
if str(data['aut9']) == "1":
patch_data.aut9 = int(data['aut9'])
elif str(data['aut9']) == "0":
patch_data.aut9 = int(data['aut9'])
if 'aut10' in data:
if str(data['aut10']) == "1":
patch_data.aut10 = int(data['aut10'])
elif str(data['aut10']) == "0":
patch_data.aut10 = int(data['aut10'])
if 'aut11' in data:
if str(data['aut11']) == "1":
patch_data.aut11 = int(data['aut11'])
elif str(data['aut11']) == "0":
patch_data.aut11 = int(data['aut11'])
if 'aut12' in data:
if str(data['aut12']) == "1":
patch_data.aut12 = int(data['aut12'])
elif str(data['aut12']) == "0":
patch_data.aut12 = int(data['aut12'])
if 'aut13' in data:
if str(data['aut13']) == "1":
patch_data.aut13 = int(data['aut13'])
elif str(data['aut13']) == "0":
patch_data.aut13 = int(data['aut13'])
if 'aut14' in data:
if str(data['aut14']) == "1":
patch_data.aut14 = int(data['aut14'])
elif str(data['aut14']) == "0":
patch_data.aut14 = int(data['aut14'])
if 'aut15' in data:
if str(data['aut15']) == "1":
patch_data.aut15 = int(data['aut15'])
elif str(data['aut15']) == "0":
patch_data.aut15 = int(data['aut15'])
if 'aut15' in data:
if str(data['aut15']) == "1":
patch_data.aut15 = int(data['aut15'])
elif str(data['aut15']) == "0":
patch_data.aut15 = int(data['aut15'])
if 'aut15' in data:
if str(data['aut15']) == "1":
patch_data.aut15 = int(data['aut15'])
elif str(data['aut15']) == "0":
patch_data.aut15 = int(data['aut15'])
if 'aut16' in data:
if str(data['aut16']) == "1":
patch_data.aut16 = int(data['aut16'])
elif str(data['aut16']) == "0":
patch_data.aut16 = int(data['aut16'])
if 'aut17' in data:
if str(data['aut17']) == "1":
patch_data.aut17 = int(data['aut17'])
elif str(data['aut17']) == "0":
patch_data.aut17 = int(data['aut17'])
if 'aut18' in data:
if str(data['aut18']) == "1":
patch_data.aut18 = int(data['aut18'])
elif str(data['aut18']) == "0":
patch_data.aut18 = int(data['aut18'])
if 'aut19' in data:
if str(data['aut19']) == "1":
patch_data.aut19 = int(data['aut19'])
elif str(data['aut19']) == "0":
patch_data.aut19 = int(data['aut19'])
if 'aut20' in data:
if str(data['aut20']) == "1":
patch_data.aut20 = int(data['aut20'])
elif str(data['aut20']) == "0":
patch_data.aut20 = int(data['aut20'])
patch_data.save()
ip = request.META.get(
'HTTP_X_FORWARDED_FOR') if request.META.get(
'HTTP_X_FORWARDED_FOR') else request.META.get(
'REMOTE_ADDR')
ret = FBMsg.wms_ret()
ret['ip'] = ip
ret['data'] = data
return Response(ret)
else:
ret = FBMsg.wms_err()
ret['data'] = data
return Response(ret)
else:
return Response(FBMsg.wms_vip())
def put(self, request, format=None):
global cyclecount_number
file_obj = request.data['file']
vip_id = Users.objects.filter(appid=request.user.appid,
developer=1,
is_delete=0).first().vip
file_check = FileVipCheck.FileVipCheck(file_obj.size, vip_id)
if file_check == "N":
return Response(FBMsg.err_data())
elif file_check == "Y":
if os.path.exists(
os.path.join(settings.BASE_DIR,
'media/upload/' + pathlink)):
pass
else:
os.makedirs(
os.path.join(settings.BASE_DIR,
'media/upload/' + pathlink))
if file_obj.name.endswith('.xlsx'):
filename = os.path.join(
settings.BASE_DIR, 'media/upload/' + pathlink + '/' +
request.user.appid + '.xlsx')
elif file_obj.name.endswith('.xls'):
filename = os.path.join(
settings.BASE_DIR, 'media/upload/' + pathlink + '/' +
request.user.appid + '.xls')
else:
return Response(FBMsg.err_data())
with open(filename, 'wb+') as f:
for chunk in file_obj.chunks():
f.write(chunk)
f.close()
df = pd.read_excel(filename)
if ListModel.objects.filter(appid=request.user.appid).exists():
upload_data = ListModel.objects.filter(
appid=request.user.appid)
for i in range(len(upload_data)):
upload_data[i].delete()
for index, row in df.iterrows():
if str(row[pathname]) == '':
pass
else:
if goodslist.models.ListModel.objects.filter(
appid=request.user.appid,
name=str(row['商品编码']),
is_delete=0).exists():
pass
else:
ret = FBMsg.wms_err()
ret['data'] = {"商品编码不存在": str(row['商品编码'])}
return Response(ret)
if binset.models.ListModel.objects.filter(
appid=request.user.appid,
name=str(row[pathname]),
is_delete=0).exists():
pass
else:
ret = FBMsg.wms_err()
ret['data'] = {"库位不存在": str(row[pathname])}
return Response(ret)
if Users.objects.filter(appid=request.user.appid,
name=str(row['盘点用户名']),
is_delete=0).exists():
pass
else:
ret = FBMsg.wms_err()
ret['data'] = {"用户不存在": str(row['盘点用户名'])}
return Response(ret)
if stockbinlist.models.ListModel.objects.filter(
appid=request.user.appid,
t_code=str(row['数据标识']),
is_delete=0).exists():
cycle_count_data = stockbinlist.models.ListModel.objects.filter(
appid=request.user.appid,
t_code=str(row['数据标识']),
is_delete=0).first()
ListModel.objects.create(
appid=request.user.appid,
name=str(row[pathname]),
goods_code=str(row['商品编码']),
goods_name=str(row['商品描述']),
cycle_count_balance=0 - cycle_count_data.goods_qty,
staff=str(row['盘点用户名']),
inbound_time=cycle_count_data.create_time,
t_code=Md5.md5(str(row[pathname])))
else:
ret = FBMsg.wms_err()
ret['data'] = {"数据不存在": str(row[pathname])}
return Response(ret)
os.remove(filename)
ip = request.META.get('HTTP_X_FORWARDED_FOR') if request.META.get(
'HTTP_X_FORWARDED_FOR') else request.META.get('REMOTE_ADDR')
ret = FBMsg.wms_ret()
ret['ip'] = ip
return Response(ret)
else:
return Response(FBMsg.err_data())
def post(self, request, *args, **kwargs):
vip_id = Users.objects.filter(appid=request.user.appid,
developer=1,
is_delete=0).first().vip
vip_check = VipCheck.VipCheck(vip_id)
if vip_check == "N":
return Response(FBMsg.wms_vip())
elif vip_check == "Y":
data = DataSolve.datasolve(request)
try:
if data['code'] == "1031":
return Response(FBMsg.err_bad())
except:
if 'changedata' in data:
if str(data['changedata']) == '1':
if ListModel.objects.filter(
appid=request.user.appid,
t_code=str(data['t_code'])).exists():
patch_data = ListModel.objects.filter(
appid=request.user.appid,
t_code=str(data['t_code'])).first()
if 'goods_qty' in data:
patch_data.goods_qty = patch_data.goods_qty + int(
data['goods_qty'])
patch_data.cycle_count_balance = patch_data.cycle_count_balance + int(
data['goods_qty'])
patch_data.save()
ip = request.META.get(
'HTTP_X_FORWARDED_FOR') if request.META.get(
'HTTP_X_FORWARDED_FOR'
) else request.META.get('REMOTE_ADDR')
ret = FBMsg.wms_ret()
ret['ip'] = ip
ret['data'] = data
return Response(ret)
else:
ret = FBMsg.wms_err()
ret['data'] = data
return Response(ret)
if 'postdata' in data:
if str(data['postdata']) == '1':
if binset.models.ListModel.objects.filter(
appid=request.user.appid,
name=str(data['name']),
is_delete=0).exists():
if goodslist.models.ListModel.objects.filter(
appid=request.user.appid,
name=str(data['goods_code']),
is_delete=0).exists():
goods_name = goodslist.models.ListModel.objects.filter(
appid=request.user.appid,
name=str(data['goods_code']),
is_delete=0).first().goods_name
else:
goods_name = ''
ListModel.objects.create(
appid=request.user.appid,
name=str(data['name']),
goods_code=str(data['goods_code']),
goods_name=goods_name,
goods_qty=int(data['goods_qty']),
inbound_time=datetime.datetime.now(),
staff=str(data['staff']),
cycle_count_balance=int(data['goods_qty']),
t_code=Md5.md5(str(data['name'])))
ip = request.META.get(
'HTTP_X_FORWARDED_FOR') if request.META.get(
'HTTP_X_FORWARDED_FOR'
) else request.META.get('REMOTE_ADDR')
ret = FBMsg.wms_ret()
ret['ip'] = ip
ret['data'] = data
return Response(ret)
else:
ret = FBMsg.wms_err()
ret['data'] = {"库位不存在": str(data['name'])}
return Response(ret)
else:
return Response(FBMsg.wms_vip())
