def test13(self):
queryCustomer = CustomerDao()
result = queryCustomer.query_byId(
"031f50f8-7691-33b0-9281-cafeba075c90")
print(len(result))
print(result[0][1])
print(result)
def test15(self):
query = SellDao()
queryCustomer = CustomerDao()
queryGoods = GoodsDao()
companyId = "5"
customerId = "201353eb-4f3b-3992-bdae-347841dc304d"
result = queryCustomer.query_byId(customerId)
if len(result) == 1:
customerName = result[0][1]
else:
customerName = ""
sumprice = 22.5
date = "2019-7-12"
id = str(uuid.uuid3(uuid.NAMESPACE_OID, date))
goodsId = "e7f00942-5aad-3df5-90d1-c850b0839ff2"
number = 5
goodsResult = queryGoods.query_byId(goodsId)
if len(goodsResult) == 1:
goodsName = goodsResult[0][1]
else:
goodsName = ""
row = query.add(id, customerId, goodsId, companyId, number, sumprice,
date, customerName, goodsName)
if row == 1:
return json.dumps(return_success("Yes!"))
else:
return json.dumps(return_unsuccess('Error: Add failed'))
def test7(self):
queryAllsup = CustomerDao()
supresult = queryAllsup.query_byCompanyId("5")
size = len(supresult)
print(supresult)
supresu_json = json.dumps(CustomerDao.to_dict(supresult),
ensure_ascii=False)
print(supresu_json)
def queryAllCustomer():
queryAllCus = CustomerDao()
_json = request.json
companyId = _json['companyId']
Cusresult = queryAllCus.query_byCompanyId(companyId)
size = len(Cusresult)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(CustomerDao.to_dict(Cusresult)),
ensure_ascii=False)
def test6(self):
companyId = "4"
name = "张嘉吉"
ID = str(uuid.uuid3(uuid.NAMESPACE_OID, name))
phone = "173"
bankAccount = "411"
bankname = "珞珈山银行"
credit = "优秀"
addCustomer = CustomerDao()
row = addCustomer.add(ID, name, phone, credit, companyId, bankname,
bankAccount)
print(row)
def queryCustomerById():
query = CustomerDao()
_json = request.json
id = _json.get('id')
result = query.query_byId(id)
size = len(result)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(CustomerDao.to_dict(result)),
ensure_ascii=False,
cls=DecimalEncoder)
def addCustomer():
_json = request.json
companyId = _json['companyId']
name = _json['name']
ID = str(uuid.uuid3(uuid.NAMESPACE_OID, name))
phone = _json['phone']
bankAccount = _json['bankAccount']
bankname = _json['bankname']
credit = "良好"
addCustomer = CustomerDao()
row = addCustomer.add(ID, name, phone, credit, companyId, bankname,
bankAccount)
if row == 1:
return json.dumps(return_success(ID))
else:
return json.dumps(return_unsuccess('Error: Add failed'))
def queryCustomerByName():
_json = request.json
query = CustomerDao()
name = _json.get('name')
companyId = _json.get('companyId')
print(name, companyId)
result = query.queryCustomerByName(companyId, name)
print(result)
size = len(result)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(CustomerDao.to_dict(result)),
ensure_ascii=False,
cls=DecimalEncoder)
def addSell():
conn = MyHelper()
queryCustomer = CustomerDao()
queryGoods = GoodsDao()
_json = request.json
params = []
sqls = []
companyId = _json.get('companyId')
customerId = _json.get('customerId')
result = queryCustomer.query_byId(customerId)
if len(result) == 1:
customerName = result[0][1]
else:
customerName = ""
date = _json.get('date')
goodsList = _json.get('goodsList')
id = str(uuid.uuid3(uuid.NAMESPACE_OID, str(time.time())))
# print(goodsList)
for puchase in goodsList:
sumprice = puchase['sumprice']
goodsId = puchase['goodsId']
number = puchase['number']
goodsResult = queryGoods.query_byId(goodsId)
if len(goodsResult) == 1:
goodsName = goodsResult[0][1]
goodsUnit = goodsResult[0][5]
else:
goodsName = ""
params.append([
id, customerId, goodsId, companyId, number, sumprice, date,
customerName, goodsName, goodsUnit
])
sqls.append(
"insert into Sell (id,customerId, goodsId, companyId, number, sumprice,date,customerName,goodsName,unitInfo) "
"values (%s, %s, %s, %s, %s,%s, %s, %s, %s, %s)")
rows = conn.executeUpdateTransaction(sqls=sqls, params=params)
if rows:
return json.dumps(return_success(id))
else:
return json.dumps(return_unsuccess('Error: Add failed'))
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 queryCustomer():
query = CustomerDao()
_json = request.json
companyId = _json['companyId']
if _json.get('name') == None:
if _json.get('phone') == None:
Cusresult = query.query_byCompanyId(companyId)
size = len(Cusresult)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(
CustomerDao.to_dict(Cusresult)),
ensure_ascii=False)
else:
phone = _json['phone']
newphone = '%' + phone + '%'
Cusresult = query.query_by_phone(companyId, newphone)
size = len(Cusresult)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(
CustomerDao.to_dict(Cusresult)),
ensure_ascii=False)
else:
name = _json['name']
newname = '%' + name + '%'
print(name)
Cusresult = query.queryCustomerByName(companyId, newname)
size = len(Cusresult)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(CustomerDao.to_dict(Cusresult)),
ensure_ascii=False)
def test4(self):
queryAllsup = CustomerDao()
supresult = queryAllsup.queryAll()
print(
json.dumps(return_success(CustomerDao.to_dict(supresult)),
ensure_ascii=False))