def querySumBankAmount():
try:
query = BankStatementDao()
result = query.querySumAmount()
return json.dumps(return_success(result))
except Exception as e:
return json.dumps(return_unsuccess('Error: ' + str(e)))
def checkBankStatus():
query = BankStatementDao()
_json = request.json
voucher = _json.get('voucher')
try:
query.update(voucher)
return json.dumps(return_success("修改成功"))
except Exception as e:
return json.dumps(return_unsuccess('修改失败 ' + str(e)))
def queryAllBankRecord():
query = BankStatementDao()
result = query.queryAll()
if len(result) >= 1:
return json.dumps(return_success(BankStatementDao.to_dict(result)),
ensure_ascii=False,
cls=DecimalEncoder)
else:
return json.dumps(return_unsuccess('Sorry,no data'))
def queryBankRecordByDate():
_json = request.json
start = _json.get('start')
end = _json.get('end')
result = queryBank(start, end)
if len(result) >= 1:
return json.dumps(return_success(BankStatementDao.to_dict(result)),
ensure_ascii=False,
cls=DecimalEncoder)
else:
return json.dumps(return_unsuccess('Sorry,no data'))
def addBankRecord():
query = BankStatementDao()
queryName = CustomerDao()
querySupplierName = SupplierDao()
_json = request.json
voucher = _json.get('voucher')
bankName = _json.get('bankName')
customerId = _json.get('customerId')
amount = Decimal(_json.get('amount'))
if amount > 0:
comResult = queryName.query_byId(customerId)
companyName = comResult[0][1]
else:
supResult = querySupplierName.query_byId(customerId)
companyName = supResult[0][1]
clearForm = _json.get('clearForm')
date = _json.get('date')
status = "未核对"
bankResult = query.queryByName(bankName)
if len(bankResult) == 0:
balance = amount
else:
balance = Decimal(bankResult[0]['data']['balance']) + amount
print(voucher, bankName, companyName, clearForm, amount, date, status,
balance)
row = query.add(voucher, bankName, companyName, clearForm, amount, date,
status, balance)
changeDescription = "在 " + bankName + clearForm + str(abs(amount)) + "元 "
insertDailyRow = InsertDailyfund(date, changeDescription, amount)
if row == 1:
if insertDailyRow == 1:
return json.dumps(return_success('Add succeed！'))
else:
return json.dumps(
return_unsuccess(
'Error: Daily fund add failed,bank add succeed'))
def queryBank(start, end):
query = BankStatementDao()
result = query.query_by_date(start, end)
return result
def queryBankRecordByOption():
_json = request.json
if _json.get('start') is None:
date = _json.get('date')
option = int(_json.get('option'))
d = datetime.datetime.strptime(date, '%Y-%m-%d %H:%M:%S')
if option == 1 or option == 2 or option == 3:
if option == 1:
start = d.replace(year=d.year,
month=d.month,
day=d.day,
hour=0,
minute=0,
second=0)
end = d.replace(year=d.year,
month=d.month,
day=d.day + 1,
hour=0,
minute=0,
second=0)
if option == 2:
monday = timeProcess.get_current_week(d)
start = monday.replace(year=monday.year,
month=monday.month,
day=monday.day,
hour=0,
minute=0,
second=0)
delta = datetime.timedelta(days=7)
end = start + delta
if option == 3:
start = d.replace(year=d.year,
month=d.month,
day=1,
hour=0,
minute=0,
second=0)
end = d.replace(year=d.year,
month=d.month + 1,
day=1,
hour=0,
minute=0,
second=0)
result = queryBank(str(start), str(end))
print(start, end)
if len(result) >= 1:
return json.dumps(return_success(
BankStatementDao.to_dict(result)),
ensure_ascii=False,
cls=DecimalEncoder)
else:
return json.dumps(return_unsuccess('Sorry,no data'))
else:
return json.dumps(return_unsuccess('Error!'))
else:
start = _json.get('start')
end = _json.get('end')
result = queryBank(start, end)
print(start, end)
if len(result) >= 1:
return json.dumps(return_success(BankStatementDao.to_dict(result)),
ensure_ascii=False,
cls=DecimalEncoder)
else:
return json.dumps(return_unsuccess('Sorry,no data'))
def test19(self):
res = BankStatementDao().update("9f4bd060-85fa-3f47-b1f6-6d9e1ed1ffc9")
print(res)
def test18(self):
res = BankStatementDao().querySumAmount()
print(res)
def test17(self):
res = BankStatementDao().queryByName('珞珈山人民银行')
print(res)
def test16(self):
res = BankStatementDao().queryAll()
print(res)
def test21(self):
ad = BankStatementDao()
result = ad.queryByName('花旗银行')
a = len(result)
print(a)
print(result[0][7])