def purseentry_edit_batch_save(request):
id_list = request.POST.get('id_list')
id_list = id_list.split(',')
with transaction.atomic():
for billentry_id in id_list:
form = PurseEntryEditBatchForm(request.POST)
if not form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(form)})
material = form.data.get('material')
amount = form.data.get('amount')
if amount.strip() == '':
amount = 0
qty = form.data.get('qty')
if qty.strip() == '':
qty = 0
material_id = None
try:
material_id = Materiel.objects.filter(bur_num=material)[0].bur_id
except:
pass
bill_date = form.data.get('bill_date')
with transaction.atomic():
PurseEntry.objects.filter(pk=billentry_id).update(
material_id=material_id,
amount=amount,
qty=qty,
)
purse_service.markedit_by_bill_entry_id(billentry_id)
purse_service.update_bill_date(bill_entry_id=billentry_id, bill_date=bill_date)
return JsonResponse({'success': True, 'message': '保存成功！'})
def purseentry_copy_save(request):
billentry_id = request.POST.get('entry_id')
form = PurseEntryEditForm(request.POST)
if not form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(form)})
material = form.data.get('material')
amount = form.data.get('amount')
if amount.strip() == '':
amount = 0
qty = form.data.get('qty')
if qty.strip() == '':
qty = 0
material_id = None
try:
material_id = Materiel.objects.filter(bur_num=material)[0].bur_id
except:
pass
bill_date = form.data.get('bill_date')
with transaction.atomic():
purse_service.copy_bill_entry(
bill_entry_id=billentry_id,
material=material_id,
amount=amount,
qty=qty,
bill_date=bill_date,
)
return JsonResponse({'success': True, 'message': '复制并保存成功！'})
def user_save(request):
try:
user_id = request.POST.get('id')
is_create = user_id is None or user_id == '' or user_id == '0'
if is_create:
user_form = UserDetailForm(request.POST)
else:
user = User.objects.get(pk=user_id)
user_form = UserDetailForm(request.POST, instance=user)
if not user_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(user_form)})
user = user_form.save(commit=False)
if is_create: # 新建用户时加密密码
# user.password = make_password(user.password, None, 'pbkdf2_sha256')
user.password = login_service.encrypt_password(user.password)
else: # 如果新密码存在于表单，就加密保存，如果不存在就不更新密码(取表单上的值)
new_password = user_form.data.get('new_password').strip()
if new_password != '':
# user.password = make_password(new_password, None, 'pbkdf2_sha256')
user.password = login_service.encrypt_password(new_password)
user.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
except Exception as exp:
logger.exception(exp)
return JsonResponse({'success': False, 'message': '保存失败！详细：%s' % exp})
def sync_pursedata(request):
sync_billdata_form = SyncBillDataForm(request.POST)
if not sync_billdata_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(sync_billdata_form)})
begin_date = sync_billdata_form.data.get('begin_date')
end_date = sync_billdata_form.data.get('end_date')
datasync_service.sync_pursedata(begin_date, end_date)
return JsonResponse({'success': True, 'message': '同步成功！'})
def stock_copy_save(request):
stock_form = StockCopyForm(request.POST)
if not stock_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(stock_form)})
stock = stock_form.save(commit=False)
stock.bur_id = stock_service.get_next_stock_id()
stock.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def customer_copy_save(request):
customer_form = CustomerCopyForm(request.POST)
customer_form.bur_id = request.POST.get('bur_id')
if not customer_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(customer_form)})
with transaction.atomic():
customer_service.copy(customer_form)
return JsonResponse({'success': True, 'message': '复制并保存成功！'})
def retailbillentry_edit_batch_save(request):
id_list = request.POST.get('id_list')
id_list = id_list.split(',')
with transaction.atomic():
for billentry_id in id_list:
form = RetailBillEntryEditBatchForm(request.POST)
if not form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(form)})
material = form.data.get('material')
amount = form.data.get('amount')
if amount.strip() == '':
amount = 0
qty = form.data.get('qty')
if qty.strip() == '':
qty = 0
material_id = None
try:
material_id = Materiel.objects.filter(bur_num=material)[0].bur_id
except:
pass
sc_stock_code = form.data.get('sc_stock')
dc_stock_code = form.data.get('dc_stock')
sc_stock = None
try:
sc_stock = Stock.objects.filter(bur_num=sc_stock_code)[0]
except:
pass
sc_stock_num = None
if sc_stock is not None:
sc_stock_num = sc_stock.bur_id
dc_stock = None
try:
dc_stock = Stock.objects.filter(bur_num=dc_stock_code)[0]
except:
pass
dc_stock_num = None
if dc_stock is not None:
dc_stock_num = dc_stock.bur_id
bill_date = form.data.get('bill_date')
with transaction.atomic():
get_retailbillentry_query_objects().filter(pk=billentry_id).update(
material_id=material_id,
amount=amount,
qty=qty,
sc_stock=sc_stock_num,
dc_stock=dc_stock_num,
)
stockbill_service.markedit_by_bill_entry_id(billentry_id)
stockbill_service.update_bill_date(bill_entry_id=billentry_id, bill_date=bill_date)
return JsonResponse({'success': True, 'message': '保存成功！'})
def retailbillentry_save(request):
retailbillentry_id = request.POST.get('entry_id')
if is_empty_id(retailbillentry_id):
retailbillentry_form = RetailBillEntryDetailForm(request.POST)
else:
retailbillentry = get_retailbillentry_query_objects().get(pk=retailbillentry_id)
retailbillentry_form = RetailBillEntryDetailForm(request.POST, instance=retailbillentry)
if not retailbillentry_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(retailbillentry_form)})
retailbillentry_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def purseentry_save(request):
purseentry_id = request.POST.get('entry_id')
if is_empty_id(purseentry_id):
purseentry_form = PurseEntryDetailForm(request.POST)
else:
purseentry = PurseEntry.objects.get(pk=purseentry_id)
purseentry_form = PurseEntryDetailForm(request.POST, instance=purseentry)
if not purseentry_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(purseentry_form)})
purseentry_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def profile_save(request):
profile_form = ProfileForm(request.POST)
if not profile_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(profile_form)})
password = profile_form.data.get('password')
if password is not None and password.strip() != '':
user_id = login_service.get_login_user(request).user_id
user = User.objects.get(pk=user_id)
user.password = login_service.encrypt_password(password)
user.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def stock_save(request):
bur_id = request.POST.get('bur_id')
is_create = request.POST.get('is_create')
if is_create is not None:
stock_form = StockDetailForm(request.POST)
else:
stock = Stock.objects.get(pk=bur_id)
stock_form = StockDetailForm(request.POST, instance=stock)
if not stock_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(stock_form)})
stock_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def retailbill_save(request):
fid = request.POST.get('fid')
is_create = request.POST.get('is_create')
if is_create is not None:
retailbill_form = RetailBillDetailForm(request.POST)
else:
stockbill = get_retailbill_query_objects().get(pk=fid)
retailbill_form = RetailBillDetailForm(request.POST, instance=stockbill)
if not retailbill_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(retailbill_form)})
retailbill_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def retailbillentry_copy_save(request):
billentry_id = request.POST.get('entry_id')
form = RetailBillEntryEditForm(request.POST)
if not form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(form)})
material = form.data.get('material')
amount = form.data.get('amount')
if amount.strip() == '':
amount = 0
qty = form.data.get('qty')
if qty.strip() == '':
qty = 0
material_id = None
try:
material_id = Materiel.objects.filter(bur_num=material)[0].bur_id
except:
pass
sc_stock_code = form.data.get('sc_stock')
dc_stock_code = form.data.get('dc_stock')
sc_stock = None
try:
sc_stock = Stock.objects.filter(bur_num=sc_stock_code)[0]
except:
pass
sc_stock_num = None
if sc_stock is not None:
sc_stock_num = sc_stock.bur_id
dc_stock = None
try:
dc_stock = Stock.objects.filter(bur_num=dc_stock_code)[0]
except:
pass
dc_stock_num = None
if dc_stock is not None:
dc_stock_num = dc_stock.bur_id
bill_date = form.data.get('bill_date')
with transaction.atomic():
stockbill_service.copy_bill_entry(
bill_entry_id=billentry_id,
material=material_id,
amount=amount,
qty=qty,
sc_stock_num=sc_stock_num,
dc_stock_num=dc_stock_num,
bill_date=bill_date,
)
return JsonResponse({'success': True, 'message': '复制并保存成功！'})
def materiel_save(request):
bur_id = request.POST.get('bur_id')
is_create = request.POST.get('is_create')
if is_create is not None:
materiel_form = MaterielDetailForm(request.POST)
else:
materiel = Materiel.objects.get(pk=bur_id)
materiel_form = MaterielDetailForm(request.POST, instance=materiel)
if not materiel_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(materiel_form)})
materiel_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def purse_save(request):
inter_id = request.POST.get('inter_id')
is_create = request.POST.get('is_create')
if is_create is not None:
purse_form = PurseDetailForm(request.POST)
else:
purse = Purse.objects.get(pk=inter_id)
purse_form = PurseDetailForm(request.POST, instance=purse)
if not purse_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(purse_form)})
purse_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def customer_save(request):
bur_id = request.POST.get('bur_id')
is_create = request.POST.get('is_create')
if is_create is not None:
customer_form = CustomerDetailForm(request.POST)
else:
customer = Customer.objects.get(pk=bur_id)
customer_form = CustomerDetailForm(request.POST, instance=customer)
if not customer_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(customer_form)})
customer_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def app_save(request):
try:
app_id = request.POST.get("id")
if app_id is None or app_id == "" or app_id == "0":
app_form = AppDetailForm(request.POST)
else:
app = App.objects.get(pk=app_id)
app_form = AppDetailForm(request.POST, instance=app)
if not app_form.is_valid():
return JsonResponse({"success": False, "message": "验证失败！" + get_form_error_msg(app_form)})
app_form.save()
return JsonResponse({"success": True, "message": "保存成功！"})
except Exception as exp:
logger.exception(exp)
return JsonResponse({"success": False, "message": "保存失败！详细：%s" % exp})
def resource_save(request):
try:
resource_id = request.POST.get('id')
if resource_id is None or resource_id == '' or resource_id == '0':
resource_form = ResourceDetailForm(request.POST)
else:
resource = Resource.objects.get(pk=resource_id)
resource_form = ResourceDetailForm(request.POST, instance=resource)
if not resource_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(resource_form)})
resource_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
except Exception as exp:
logger.exception(exp)
return JsonResponse({'success': False, 'message': '保存失败！详细：%s' % exp})
def profile_user_detail_save(request):
try:
user_id = login_service.get_login_user(request).user_id
user = User.objects.get(pk=user_id)
user_form = UserDetailForm(request.POST, instance=user)
if not user_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(user_form)})
user = user_form.save(commit=False)
# 如果新密码存在于表单，就加密保存，如果不存在就不更新密码(取表单上的值)
new_password = user_form.data.get('new_password').strip()
if new_password != '':
user.password = login_service.encrypt_password(new_password)
user.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
except Exception as exp:
logger.exception(exp)
return JsonResponse({'success': False, 'message': '保存失败！详细：%s' % exp})
def admin_save(request):
try:
admin_id = request.POST.get('id')
if admin_id.strip() == '':
admin_form = AdminDetailForm(request.POST)
else:
admin = Admin.objects.get(pk=admin_id)
admin_form = AdminDetailForm(request.POST, instance=admin)
if not admin_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(admin_form)})
admin_form.save()
# admin = admin_form.save(commit=False)
# setup foreign key fields etc
# admin.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
except Exception as exp:
logger.exception(exp)
return JsonResponse({'success': False, 'message': '保存失败！详细：%s' % exp})
def warehouse_save(request):
try:
warehouse_id = request.POST.get('id')
if warehouse_id.strip() == '':
warehouse_form = WarehouseDetailForm(request.POST)
else:
warehouse = Warehouse.objects.get(pk=warehouse_id)
warehouse_form = WarehouseDetailForm(request.POST, instance=warehouse)
if not warehouse_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(warehouse_form)})
warehouse_form.save()
# warehouse = warehouse_form.save(commit=False)
# setup foreign key fields etc
# warehouse.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
except Exception as exp:
logger.exception(exp)
return JsonResponse({'success': False, 'message': '保存失败！详细：%s' % exp})
def dept_save(request):
try:
dept_id = request.POST.get('id')
if dept_id == '':
dept_form = DepartmentDetailForm(request.POST)
else:
dept = Department.objects.get(pk=dept_id)
dept_form = DepartmentDetailForm(request.POST, instance=dept)
if not dept_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(dept_form)})
dept = dept_form.save(commit=False)
parent_id = request.POST.get('parent__id')
if parent_id is not None and parent_id.strip() != '' and parent_id != '0':
# dept.parent = Department.objects.get(pk=parent_id)
dept.parent_id = parent_id
dept.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
except Exception as exp:
logger.exception(exp)
return JsonResponse({'success': False, 'message': '保存失败！详细：%s' % exp})
def group_save(request):
try:
group_id = request.POST.get("id")
if group_id is None or group_id == "" or group_id == "0":
group_form = GroupDetailForm(request.POST)
else:
group = Group.objects.get(pk=group_id)
group_form = GroupDetailForm(request.POST, instance=group)
if not group_form.is_valid():
return JsonResponse({"success": False, "message": "验证失败！" + get_form_error_msg(group_form)})
group = group_form.save(commit=False)
app_id = request.POST.get("app_id")
if app_id is not None and app_id.strip() != "" and app_id != "0":
# group.app = App.objects.get(pk=app_id)
group.app_id = app_id
group.save()
return JsonResponse({"success": True, "message": "保存成功！"})
except Exception as exp:
logger.exception(exp)
return JsonResponse({"success": False, "message": "保存失败！详细：%s" % exp})
def login_login(request):
if request.method == 'GET':
return render(request, 'auth/login/login.html')
elif request.method == 'POST':
login_form = LoginForm(request.POST)
if login_form.is_valid():
login_name = login_form.data.get('login_name')
password = login_form.data.get('password')
login_service = LoginService()
success, message, user = login_service.user_password_matched(login_name, password)
if not success:
return JsonResponse({'success': False, 'message': '登录失败！详情：' + message})
login_user = LoginUser()
login_user.user_id = user.id
login_user.login_name = user.login_name
login_user.nick_name = user.nick_name
login_service.set_login_user(request, login_user)
return JsonResponse({'success': True, 'message': '登录成功！'})
else:
return JsonResponse({'success': False, 'message': '登录失败！详情：' + get_form_error_msg(login_form)})
def stockbillentry_edit_save(request):
billentry_id = request.POST.get('entry_id')
form = StockBillEntryEditForm(request.POST)
if not form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(form)})
material = form.data.get('material')
amount = form.data.get('amount')
if amount.strip() == '':
amount = 0
consign_amount = form.data.get('consign_amount')
if consign_amount.strip() == '':
consign_amount = 0
qty = form.data.get('qty')
if qty.strip() == '':
qty = 0
material_id = None
try:
material_id = Materiel.objects.filter(bur_num=material)[0].bur_id
except:
pass
sc_stock_code = form.data.get('sc_stock')
dc_stock_code = form.data.get('dc_stock')
sc_stock = None
try:
sc_stock = Stock.objects.filter(bur_num=sc_stock_code)[0]
except:
pass
sc_stock_num = None
if sc_stock is not None:
sc_stock_num = sc_stock.bur_id
dc_stock = None
try:
dc_stock = Stock.objects.filter(bur_num=dc_stock_code)[0]
except:
pass
dc_stock_num = None
if dc_stock is not None:
dc_stock_num = dc_stock.bur_id
bill_date = form.data.get('bill_date')
price = 0
if qty != 0:
price = float(amount) / float(qty)
consign_price = 0
if qty != 0:
consign_price = float(consign_amount) / float(qty)
with transaction.atomic():
get_stockbillentry_query_objects().filter(pk=billentry_id).update(
material_id=material_id,
amount=amount,
consign_amount=consign_amount,
qty=qty,
price=price,
consign_price=consign_price,
sc_stock=sc_stock_num,
dc_stock=dc_stock_num,
)
stockbill_service.markedit_by_bill_entry_id(billentry_id)
stockbill_service.update_bill_date(bill_entry_id=billentry_id, bill_date=bill_date)
return JsonResponse({'success': True, 'message': '保存成功！'})
def retailbill_copy_save(request):
retailbill_form = RetailBillDetailForm(request.POST)
if not retailbill_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(retailbill_form)})
retailbill_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})
def purse_copy_save(request):
purse_form = PurseDetailForm(request.POST)
if not purse_form.is_valid():
return JsonResponse({'success': False, 'message': '验证失败！' + get_form_error_msg(purse_form)})
purse_form.save()
return JsonResponse({'success': True, 'message': '保存成功！'})