def query_supplier_by_cid():
supqueryBycid = SupplierDao()
_sjson = request.json
supCid = _sjson['companyId']
supQueryresult = supqueryBycid.query_byCompanyId(supCid)
size = len(supQueryresult)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(SupplierDao.to_dict(supQueryresult)),
ensure_ascii=False)
def querySupplierById():
query = SupplierDao()
_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(SupplierDao.to_dict(result)),
ensure_ascii=False,
cls=DecimalEncoder)
def test5(self):
queryAllsup = SupplierDao()
supresult = queryAllsup.query_byCompanyId("1")
size = len(supresult)
print(supresult)
supresu_json = json.dumps(SupplierDao.to_dict(supresult),
ensure_ascii=False)
print(size)
print(supresu_json)
print(
json.dumps(return_success(SupplierDao.to_dict(supresult)),
ensure_ascii=False))
def test3(self):
supquery = SupplierDao()
supname = '街道口职业技术学院1'
supcid = "1"
supid = str(uuid.uuid3(uuid.NAMESPACE_OID, supname))
supphone = "12306"
site = "信村"
taxpayerNumber = "4000"
bankname = "花旗银行"
bankaccount = "1125"
supquery.add(supid, supname, supphone, site, taxpayerNumber,
bankaccount, bankname, supcid)
def querySupplierByName():
query = SupplierDao()
_json = request.json
name = _json.get('name')
newName = '%' + name + '%'
print(newName)
result = query.query_byName(newName)
size = len(result)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(SupplierDao.to_dict(result)),
ensure_ascii=False,
cls=DecimalEncoder)
def addSupplier():
supquery = SupplierDao()
_json = request.json
supname = _json['name']
supcid = _json['companyId']
supid = str(uuid.uuid3(uuid.NAMESPACE_OID, supname))
supphone = _json['phone']
site = _json['site']
taxpayerNumber = _json['taxpayerNumber']
bankname = _json['bankname']
bankaccount = _json['bankaccount']
row = supquery.add(supid, supname, supphone, site, taxpayerNumber,
bankaccount, bankname, supcid)
if row == 1:
return json.dumps(return_success(supid))
else:
return json.dumps(return_unsuccess('Error: Add false'))
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 queryPurchase():
query = PurchaseDao()
querySupplierName = SupplierDao()
queryGoodsPhoto = GoodsDao()
_json = request.json
companyId = _json.get('companyId')
results = []
if _json.get('id') == None:
if _json.get('date') == None:
idResult = query.queryAllId(companyId)
else:
if _json.get('start') != None:
start = _json.get('start')
end = _json.get('end')
else:
date = _json.get('date')
start = datetime.datetime.strptime(date, '%Y-%m-%d')
delta = datetime.timedelta(days=1)
n_days = start + delta
end = n_days.strftime('%Y-%m-%d %H:%M:%S')
idResult = query.query_byDate(companyId, start, end)
size = len(idResult)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
for j in range(0, len(idResult)):
result = []
id = idResult[j][0]
goodsList = []
goodsResult = query.query_byId(id)
for i in range(0, len(goodsResult)):
status = goodsResult[i][8]
supplierId = goodsResult[i][3]
PhothResult = queryGoodsPhoto.query_byId(goodsResult[i][1])
goodsPhoto = PhothResult[0][7]
NameResult = querySupplierName.query_byId(supplierId)
supplierName = NameResult[0][1]
date = goodsResult[i][7]
goods = []
goods.append(goodsResult[i][6])
goods.append(goodsResult[i][1])
goods.append(goodsPhoto)
goods.append(goodsResult[i][2])
goods.append(goodsResult[i][5])
goodsList.append(goods)
result.append(id)
result.append(status)
result.append(supplierId)
result.append(date)
result.append(supplierName)
result.append(goodsList)
results.append(result)
else:
id = _json.get('id')
result = []
goodsList = []
goodsResult = query.query_byId(id)
if len(goodsResult) >= 0:
for i in range(0, len(goodsResult)):
status = goodsResult[i][8]
supplierId = goodsResult[i][3]
PhothResult = queryGoodsPhoto.query_byId(goodsResult[i][1])
goodsPhoto = PhothResult[0][7]
NameResult = querySupplierName.query_byId(supplierId)
supplierName = NameResult[0][1]
date = goodsResult[i][7]
goods = []
goods.append(goodsResult[i][6])
goods.append(goodsResult[i][1])
goods.append(goodsPhoto)
goods.append(goodsResult[i][2])
goods.append(goodsResult[i][5])
goodsList.append(goods)
result.append(id)
result.append(status)
result.append(supplierId)
result.append(date)
result.append(supplierName)
result.append(goodsList)
results.append(result)
size = len(results)
if size == 0:
return json.dumps(return_unsuccess('Error: No data'))
else:
return json.dumps(return_success(PurchaseDao.to_dict(results)), ensure_ascii=False, cls=DecimalEncoder)
def queryAllSupplier():
queryAllsup = SupplierDao()
supresult = queryAllsup.queryAll()
return json.dumps(return_success(SupplierDao.to_dict(supresult)),
ensure_ascii=False)
def test12(self):
companyId = "5"
date1 = "2019-07-24 19:11:03"
date = "2019-07-24"
d = datetime.datetime.strptime(date1, '%Y-%m-%d %H:%M:%S')
language = ""
jieba.load_userdict("../app/utils/dict.txt")
# 去除停用词
stopwords = {}.fromkeys(['的', '包括', '等', '是', '多少', "所有", "一下"])
today = ['今天', '这一天']
yesterday = ['昨天', '上一天']
this_week = ['这周', '这一周']
last_week = ['上周', '上一周']
this_month = ['这个月']
ac_in_money = ['赚', '挣', '卖', '收入', '盈利', '进账']
ac_purchase = ['进', '买', "进了", "买了"]
ac_query = ['查', '看', '查看', "查询"]
ac_out_money = ['花', '消费', '支出']
goods = ['东西', '商品', '货', "货物"]
money = ['钱']
price = ['价格']
inPrice = ['进价']
outPrice = ['售价']
store = ['库存']
supplier = ['供货商', '供应商', '进货商']
customer = ['顾客', '客户']
tables = ['利润表', '资产负债表', '经营日报', '利润分析']
text1 = "这个月卖了什么货"
text2 = "这个月挣了多少钱"
text3 = "查一下商品可口可乐的售价"
text4 = "这个月挣了多少钱"
# 精确模式
segs = jieba.cut(text3, cut_all=False)
final = []
for seg in segs:
if seg not in stopwords:
final.append(seg)
print(final)
time = "today"
for item in final:
if time == "today":
if item in yesterday:
time = "yesterday"
if item in this_week:
time = "this_week"
if item in last_week:
time = "last_week"
if item in this_month:
time = "this_month"
if item in ac_in_money:
action = "ac_in_money"
if item in ac_purchase:
action = "ac_purchase"
if item in ac_query:
action = "ac_query"
if item in ac_out_money:
action = "ac_out_money"
if item in goods:
nouns = "goods"
if item in money:
nouns = "money"
if item in store:
nouns = "store"
if item in price:
nouns = "price"
if item in inPrice:
nouns = "inPrice"
if item in outPrice:
nouns = "outPrice"
if item in supplier:
nouns = "supplier"
if item in customer:
nouns = "customer"
if item in tables:
nouns = "tables"
print(time)
print(action)
print(nouns)
querySell = SellDao()
queryPurchase = PurchaseDao()
inputTime = datetime.datetime.strptime(date, '%Y-%m-%d')
# 对时间进行判断
if time == "today":
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 time == "yesterday":
start = d.replace(year=d.year,
month=d.month,
day=d.day - 1,
hour=0,
minute=0,
second=0)
end = d.replace(year=d.year,
month=d.month,
day=d.day,
hour=0,
minute=0,
second=0)
if time == "this_week":
newDay = d.replace(year=d.year,
month=d.month,
day=d.day,
hour=0,
minute=0,
second=0)
start = timeProcess.get_current_week(newDay)
delta = datetime.timedelta(days=7)
end = start + delta
if time == "last_week":
end = timeProcess.get_current_week(d)
delta = datetime.timedelta(days=7)
start = end - delta
if time == "this_month":
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)
print(time)
print(start)
print(end)
# token = request.headers.get('Authorization')
token = 'JWT eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE1NzI5NTkyOTgsImlhdCI6MTU2Nzc3NTI5OCwiZGF0YSI6eyJhY2NvdW50IjoiMTU4MjcxNTI2NzAiLCJsb2dpbl90aW1lIjoxNTY3Nzc1Mjk4fX0.UqCe-5K99K_HPL8UglxtYUHNLpj_f7rWC3M39SjNRfw'
headers = {'Authorization': token, 'Content-Type': 'application/json'}
# 对行为进行判断
##### 一段时期内的销售情况 #####
if action == "ac_in_money" and nouns == "goods":
data = {"start": start, "end": end, 'companyId': '5', 'date': "hh"}
data_json = json.dumps(data, cls=DecimalEncoder)
sellRecords = requests.post(url='http://127.0.0.1:5000/querySell',
data=data_json,
headers=headers)
SellResult = json.loads(sellRecords.content)
if SellResult['success'] == True:
sellResult = SellResult['result']
print(sellResult)
groups = []
goodsType = []
group = {}
activeNames = []
items = []
for sellRecord in sellResult:
item = {}
goodsList = sellRecord['goodsList']
lists = []
content = {}
for goods in goodsList:
goodsId = goods['goodsId']
queryGoodsType = GoodsDao()
goodType = queryGoodsType.queryType_byId(goodsId)
if goodType[0][0] not in goodsType:
goodsType.append(goodType[0][0])
list = {}
list['title'] = goods['goodsName']
list['value'] = goods['number']
list['label'] = goods['goodsId']
lists.append(list)
content['type'] = 'list'
content['lists'] = lists
item['title'] = sellRecord['date']
item['value'] = '顾客' + sellRecord['customerName']
item['label'] = sellRecord['id']
item['content'] = content
items.append(item)
group['activeNames'] = activeNames
group['items'] = items
groups.append(group)
sellInfo = {
'type': 'collapse-group',
'summary': '该段时间的销售信息如下：',
'groups': groups
}
print(json.dumps(sellInfo))
return json.dumps(sellInfo)
##### 某段时间内进的货物 #####
if action == "ac_purchase" and nouns == "goods":
data = {'companyId': '5', 'date': "hh", 'start': start, 'end': end}
data_json = json.dumps(data, cls=DecimalEncoder)
if time == 'this_month':
queryForPic = PurchaseDao()
PicResult = queryForPic.query_ForPic(start, end)
datas = {}
datas['type'] = 'line_chart',
for picData in PicResult:
datas[picData[1]] = picData[0]
print(datas)
purchaseRecords = requests.post(
url='http://127.0.0.1:5000/queryPurchase',
data=data_json,
headers=headers)
SellResult = json.loads(purchaseRecords.content)
print(SellResult)
if SellResult['success'] == True:
sellResult = SellResult['result']
goodsType = []
print(sellResult)
groups = []
group = {}
activeNames = []
items = []
for sellRecord in sellResult:
item = {}
goodsList = sellRecord['goodsList']
lists = []
content = {}
for goods in goodsList:
goodsId = goods['goodsId']
queryGoodsType = GoodsDao()
goodType = queryGoodsType.queryType_byId(goodsId)
if goodType[0][0] not in goodsType:
goodsType.append(goodType[0][0])
list = {}
list['title'] = goods['goodsName']
list['value'] = goods['number']
list['label'] = goods['goodsId']
lists.append(list)
content['type'] = 'list'
content['lists'] = lists
item['title'] = sellRecord['date']
item['value'] = '供货商' + sellRecord['supplierName']
item['label'] = sellRecord['id']
item['content'] = content
items.append(item)
group['activeNames'] = activeNames
group['items'] = items
groups.append(group)
sellInfo = {
'type': 'collapse-group',
'summary': '该段时间的进货信息如下：',
'groups': groups
}
print(json.dumps(sellInfo))
sumPriceByType = []
sumNumByType = []
for gType in goodsType:
sumOneType = 0
sumOneNum = 0
for sellRecord in sellResult:
goodsList = sellRecord['goodsList']
for goods in goodsList:
goodsId = goods['goodsId']
queryGoodsType = GoodsDao()
goodType = queryGoodsType.queryType_byId(goodsId)
if goodType[0][0] == gType:
sumOneType = sumOneType + goods[
'number'] * goods['price']
sumOneNum = sumOneNum + goods['number']
sumPriceByType.append(sumOneType)
sumNumByType.append(sumOneNum)
print(goodsType)
print(sumPriceByType)
print(sumNumByType)
return json.dumps(sellInfo)
###### 查商品库存#####
if action == "ac_query" and (nouns == "goods" or nouns == "store"):
queryWare = WareHouseDao()
Cusresult = queryWare.query_byCompanyId('5')
print(Cusresult)
if len(final) == 3:
if final[1] in goods:
groups = []
activeNames = []
group = {}
items = []
for cusresult in Cusresult:
item = {}
content = {}
data = {'companyId': '5', 'wareHouseId': cusresult[0]}
data_json = json.dumps(data, cls=DecimalEncoder)
goodsStore = requests.post(
url='http://127.0.0.1:5000/queryStoreGoods',
data=data_json,
headers=headers)
Goodsstore = json.loads(goodsStore.content)
if Goodsstore['success'] == True:
goodsResult = Goodsstore['result']
goodsList = goodsResult['goodsList']
lists = []
for goods in goodsList:
list = {}
list['title'] = goods['name']
list['value'] = str(
goods['amount']) + goods['unitInfo']
list['label'] = goods['id']
lists.append(list)
content['type'] = 'list'
content[lists] = lists
item['content'] = content
item['title'] = cusresult[1]
item['value'] = cusresult[2]
items.append(item)
group['items'] = items
group['activeNames'] = activeNames
groups.append(group)
print(groups)
storeInfo = {
'type': 'collapse-group',
'summary': '所有仓库的库存信息如下：',
'groups': groups
}
print(json.dumps(storeInfo))
return json.dumps(storeInfo)
else:
data = {'companyId': '5', 'name': final[1]}
data_json = json.dumps(data, cls=DecimalEncoder)
goodsStore = requests.post(
url='http://127.0.0.1:5000/queryStoreGoods',
data=data_json,
headers=headers)
Goodsstore = json.loads(goodsStore.content)
if Goodsstore['success'] == True:
goodsRecords = Goodsstore['result']
queryGoodsResult = goodsRecords['goodsList']
print(queryGoodsResult)
summary = ""
for goodResult in queryGoodsResult:
summary = summary + "商品" + goodResult['name'] + "当前库存为：" + str(int(goodResult['amount'])) + \
goodResult['unitInfo'] + '\n'
print(summary)
storeInfo = {'type': 'text', 'summary': summary}
return json.dumps(storeInfo)
else:
return None
else:
data = {'companyId': '5', 'name': final[2]}
data_json = json.dumps(data, cls=DecimalEncoder)
goodsStore = requests.post(
url='http://127.0.0.1:5000/queryStoreGoods',
data=data_json,
headers=headers)
Goodsstore = json.loads(goodsStore.content)
if Goodsstore['success'] == True:
goodsRecords = Goodsstore['result']
queryGoodsResult = goodsRecords['goodsList']
print(queryGoodsResult)
summary = ""
for goodResult in queryGoodsResult:
summary = summary + "商品" + goodResult['name'] + "当前库存为：" + str(int(goodResult['amount'])) + \
goodResult['unitInfo'] + '\n'
print(summary)
storeInfo = {'type': 'text', 'summary': summary}
return json.dumps(storeInfo)
else:
return None
# 查询商品的价格
if action == "ac_query" and (nouns == "price" or nouns == "inPrice"
or nouns == "outPrice"):
if len(final) == 3:
data = {'name': final[1]}
else:
data = {'name': final[2]}
data_json = json.dumps(data, cls=DecimalEncoder)
judge = 0
allgroups = []
averageInmoney = 0
NewInmoney = 0
averageOutmoney = 0
NewOutmoney = 0
if nouns == "price":
judge = 1
if nouns == "inPrice" or judge == 1:
_respIn = requests.post(
url='http://127.0.0.1:5000/purchasePriceByName',
data=data_json,
headers=headers)
inRecords = json.loads(_respIn.content)
if inRecords['success'] == True:
inRecord = inRecords['result']
groups = []
group = {}
items = []
count = 0
sumPrice = 0
newPrice = 0
for inGoods in inRecord:
item = {}
item['title'] = inGoods['goodName']
item['value'] = inGoods['purchasePrice']
sumPrice = sumPrice + inGoods['purchasePrice']
NewInmoney = newPrice = inGoods['purchasePrice']
count = count + 1
querySupName = SupplierDao()
supID = inGoods['supplierId']
querySupNameResult = querySupName.queryName_byId(supID)
print(querySupNameResult[0][0])
item['label'] = '供货商：' + querySupNameResult[0][0]
item['tag'] = inGoods['date']
items.append(item)
group['title'] = '商品的进价情况如下'
group['items'] = items
allgroups.append(group)
groups.append(group)
averageInmoney = round(sumPrice / count, 2)
Price = {
'type':
'list-group',
'summary':
'商品最新进价为' + str(newPrice) + "元，平均进价为" +
str(round(sumPrice / count, 2)) + "元",
'groups':
groups
}
if nouns == "outPrice" or judge == 1:
_respOut = requests.post(
url='http://127.0.0.1:5000/SellPriceByName',
data=data_json,
headers=headers)
inRecords = json.loads(_respOut.content)
if inRecords['success'] == True:
inRecord = inRecords['result']
print(inRecord)
groups = []
group = {}
items = []
count = 0
sumPrice = 0
newPrice = 0
for inGoods in inRecord:
item = {}
item['title'] = inGoods['goodsName']
item['value'] = str(
round(inGoods['sumprice'] / inGoods['number'],
2)) + "元"
sumPrice = sumPrice + inGoods['sumprice'] / inGoods[
'number']
NewOutmoney = newPrice = inGoods['sumprice'] / inGoods[
'number']
count = count + 1
item['label'] = '客户：' + inGoods['customerName']
item['tag'] = inGoods['date']
items.append(item)
group['title'] = '商品的售价情况如下'
group['items'] = items
groups.append(group)
allgroups.append(group)
averageOutmoney = round(sumPrice / count, 2)
Price = {
'type':
'list-group',
'summary':
'商品最新售价为' + str(newPrice) + "元，平均售价为" +
str(round(sumPrice / count, 2)) + "元",
'groups':
groups
}
if nouns == "price":
Price = {
'type':
'list-group',
'summary':
'商品最新售价为' + str(NewOutmoney) + "元，平均售价为" +
str(averageOutmoney) + "元 " + ' 商品最新进价为' +
str(NewInmoney) + "元，平均进价为" + str(averageInmoney) + "元",
'groups':
allgroups
}
print(Price)
return json.dumps(Price)
#### 一段时间的收入或支出####
if nouns == "money":
data = {'start': start, 'end': end}
data_json = json.dumps(data, cls=DecimalEncoder)
_respCash = requests.post(
url='http://127.0.0.1:5000/queryCashRecordByDate',
data=data_json,
headers=headers)
CashResult = json.loads(_respCash.content)
inCash = outCash = 0
if CashResult['success'] == True:
cashResult = CashResult['result']
for sinCash in cashResult:
if sinCash['variation'] > 0:
inCash = inCash + sinCash['variation']
else:
outCash = outCash + sinCash['variation']
_respBank = requests.post(
url='http://127.0.0.1:5000/queryBankRecordByDate',
data=data_json,
headers=headers)
inBank = outBank = 0
BankResult = json.loads(_respBank.content)
if BankResult['success'] == True:
bankResult = BankResult['result']
for sinBank in bankResult:
if sinBank['amount'] > 0:
inBank = inBank + sinBank['amount']
else:
outBank = outBank + sinBank['amount']
if action == "ac_in_money":
summary = '现金收入' + str(inCash) + '元，银行存款、转账等收入' + str(
inBank) + '元，共计' + str(inBank + inCash) + '元'
inMoney = {'type': 'text', 'summary': summary}
return json.dumps(inMoney)
if action == "ac_out_money":
outBank = abs(outBank)
outCash = abs(outCash)
summary = '现金支出' + str(outCash) + '元，银行存款、转账等支出' + str(
outBank) + '元，共计' + str(outCash + outCash) + '元'
outMoney = {'type': 'text', 'summary': summary}
return json.dumps(outMoney)
#####查询顾客信息#####
if action == "ac_query" and nouns == "customer":
name = ''
print(final[3])
for i in range(2, len(final) - 1):
if final[i] != '信息':
name = name + final[i]
print(name)
data = {'companyId': '5', 'name': name}
data_json = json.dumps(data, cls=DecimalEncoder)
_respCustomer = requests.post(
url='http://127.0.0.1:5000/queryCustomer',
data=data_json,
headers=headers)
CustomerDaoResult = json.loads(_respCustomer.content)
if CustomerDaoResult['success'] == True:
customerResult = CustomerDaoResult['result']
groups = []
for supplier in customerResult:
group = {}
items = []
for key in supplier:
res = {}
res['title'] = key
res['value'] = supplier[key]
items.append(res)
group['items'] = items
groups.append(group)
print(groups)
supplierInfo = {
'type': 'list-group',
'summary': '客户' + name + '的信息',
'groups': groups
}
return json.dumps(supplierInfo)
else:
return None
CusResult = _respCash.content
customerInfo = {
'type': 'list-group',
'summary': '客户' + name + '的信息'
}
print(CusResult)
#####查询供应商信息#####
if action == "ac_query" and nouns == "supplier":
name = ''
for i in range(2, len(final) - 1):
if final[i] != '信息':
name = name + final[i]
print(name)
data = {'companyId': '5', 'name': name}
data_json = json.dumps(data, cls=DecimalEncoder)
_respSupplier = requests.post(
url='http://127.0.0.1:5000/querySupplierByName',
data=data_json,
headers=headers)
SupplierResult = json.loads(_respSupplier.content)
if SupplierResult['success'] == True:
supplierResult = SupplierResult['result']
groups = []
for supplier in supplierResult:
group = {}
items = []
for key in supplier:
res = {}
res['title'] = key
res['value'] = supplier[key]
items.append(res)
group['items'] = items
groups.append(group)
print(groups)
supplierInfo = {
'type': 'list-group',
'summary': '供应商' + name + '的信息',
'groups': groups
}
return json.dumps(supplierInfo)
else:
return None
#####查询表格信息#####
if action == "ac_query" and nouns == "tables":
data = {'start': start, 'end': end}
data_json = json.dumps(data, cls=DecimalEncoder)
_respCash = requests.post(
url='http://127.0.0.1:5000/queryCashRecordByDate',
data=data_json,
headers=headers)
CashResult = _respCash.content
print(CashResult)
def test35(self):
query = SupplierDao()
result = query.query_byId('08580344-22e0-34a6-9cce-774279c9b9a8')
print(result[0][1])
def getGoodsPrice(nouns, inRecords, outRecords):
finalResult = []
judge = 0
allgroups = []
Picturedata = []
averageInmoney = 0
NewInmoney = 0
averageOutmoney = 0
NewOutmoney = 0
if nouns == "price":
judge = 1
if inRecords['success'] == True and outRecords['success'] == True:
if nouns == "inPrice" or judge == 1:
if inRecords['success'] == True:
inRecord = inRecords['result']
# 画图数据
datas1 = {}
datas1['type'] = 'line'
datas1['summary'] = '商品进价折线图'
ah = {}
# 表格数据
groups = []
group = {}
items = []
count = 0
sumPrice = 0
newPrice = 0
for inGoods in inRecord:
# data 画图数据
ah[str(inGoods['date'])] = inGoods['purchasePrice']
# item 表格数据
item = {}
item['title'] = inGoods['goodName']
item['value'] = inGoods['purchasePrice']
sumPrice = sumPrice + inGoods['purchasePrice']
NewInmoney = newPrice = inGoods['purchasePrice']
count = count + 1
querySupName = SupplierDao()
supID = inGoods['supplierId']
querySupNameResult = querySupName.queryName_byId(supID)
print(querySupNameResult[0][0])
item['label'] = '供货商：' + querySupNameResult[0][0]
item['tag'] = inGoods['date']
items.append(item)
group['title'] = '商品的进价情况'
group['items'] = items
allgroups.append(group)
datas1['diagram'] = ah
Picturedata.append(datas1)
groups.append(group)
averageInmoney = round(sumPrice / count, 2)
Price = {
'type':
'list-group',
'summary':
'商品最新进价为' + str(newPrice) + "元，平均进价为" +
str(round(sumPrice / count, 2)) + "元",
'groups':
groups
}
finalResult.append(datas1)
if nouns == "outPrice" or judge == 1:
if outRecords['success'] == True:
inRecord = outRecords['result']
datas2 = {}
datas2['type'] = 'line'
datas2['summary'] = '商品售价折线图'
print(inRecord)
groups = []
group = {}
items = []
count = 0
sumPrice = 0
newPrice = 0
ah = {}
for inGoods in inRecord:
ah[str(inGoods['date'])] = round(
inGoods['sumprice'] / inGoods['number'], 2)
item = {}
item['title'] = inGoods['goodsName']
item['value'] = str(
round(inGoods['sumprice'] / inGoods['number'],
2)) + "元"
sumPrice = sumPrice + inGoods['sumprice'] / inGoods[
'number']
NewOutmoney = newPrice = inGoods['sumprice'] / inGoods[
'number']
count = count + 1
item['label'] = '客户：' + inGoods['customerName']
item['tag'] = inGoods['date']
items.append(item)
group['title'] = '商品的售价情况'
group['items'] = items
groups.append(group)
allgroups.append(group)
averageOutmoney = round(sumPrice / count, 2)
Price = {
'type':
'list-group',
'summary':
'商品最新售价为' + str(newPrice) + "元，平均售价为" +
str(round(sumPrice / count, 2)) + "元",
'groups':
groups
}
datas2['diagram'] = ah
finalResult.append(datas2)
if nouns == "price":
Price = {
'type':
'list-group',
'summary':
'商品最新售价为' + str(NewOutmoney) + "元，平均售价为" +
str(averageOutmoney) + "元 " + ' 商品最新进价为' + str(NewInmoney) +
"元，平均进价为" + str(averageInmoney) + "元",
'groups':
allgroups
}
finalResult.append(Price)
return json.dumps(return_success(finalResult),
ensure_ascii=False,
cls=DecimalEncoder)
else:
return json.dumps(return_unsuccess('不好意思，没有查到相关数据哦'))