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))