def fillAllWorkerTable(self):
self.workerTable.setRowCount(0)
proc_args = [self.comboBox.currentText()]
workers = call_saved_procedure(self.db, 'worker_by_depart',proc_args)
for worker in workers:
self._addSingleWorker_dict(self.workerTable, worker)
zp = call_saved_procedure(self.db,'summa_zp_otdela',[self.comboBox.currentText()])[0]['sum']
self.zp.setText(str(zp))
self.fillAllGoodsTable()
def upload2db_refresh(self):
self.getFieldsData()
if not (self.agentClientName and self.agentClientAddress
and self.checkingAccount and self.inn):
print("Error in fields")
return
proc_args = [
self.agentClientName, self.agentClientAddress,
self.checkingAccount, self.inn
]
call_saved_procedure(self.db, self.upload_proc_name, proc_args)
self.fillTable()
def uploadGoodsRecordsToContract(self, contract_id):
selectedProdTable = self.AddedProductWithQuantityTableWidget
goods_cnt = selectedProdTable.rowCount()
for row in range(goods_cnt):
good_name = selectedProdTable.item(row, 0).text()
good_quantity = selectedProdTable.item(
row,
selectedProdTable.columnCount() - 1).text()
print(good_name, good_quantity)
good_id = call_saved_procedure(self.db, 'goodid_by_name',
[good_name])
good_id = good_id[0]['idТовар']
proc_args = [contract_id, good_id, good_quantity]
call_saved_procedure(self.db, 'add_contract_good_record',
proc_args)
def upload2db(self):
self.getFieldsData()
if (self.delivery_agent is not None) and (not self.delivery_agent):
#print("Incorrect delivery agent!")
return
if not (self.contract_number and self.date_start and self.end_date
and self.customer_name):
#print("Some fields empty!!")
return
id_buyer = call_saved_procedure(self.db, 'buyerid_by_name',
[self.customer_name])
if not len(id_buyer):
print("Incorrect buyer credentials!")
return
id_buyer = id_buyer[0]['idПокупатель']
id_deliver = call_saved_procedure(self.db, 'deliverid_by_name',
[self.delivery_agent])
if (self.delivery_agent is not None) and (not len(id_deliver)):
print("Incorrect delivery agent credentials!")
return
print([self.contract_number, self.date_start, self.end_date, id_buyer])
try:
call_saved_procedure(self.db, 'add_contract', [
self.contract_number, self.date_start, self.end_date, id_buyer
])
except Exception as e:
print(e)
contract_id = call_saved_procedure(self.db, 'contractid_by_number',
[self.contract_number])
contract_id = contract_id[0]['idДоговор']
self.uploadGoodsRecordsToContract(contract_id)
if self.delivery_agent is not None:
id_deliver = id_deliver[0]['idПеревозчик']
call_saved_procedure(self.db, 'add_contract_delivery_record',
[contract_id, id_deliver])
def upload2db(self):
self.getFieldsData()
proc_args = [self.mat_name, self.mat_cost, self.mat_unit]
call_saved_procedure(self.db, 'add_mat', proc_args)
self.fillAllMatTable()
def fillAllGoodsTable(self):
self.goodsTable.setRowCount(0)
dept = self.comboBox.currentText()
dpt_goods = call_saved_procedure(self.db, 'tovary_y_otdela', [dept])
for good in dpt_goods:
self._addSingleGood_dict(self.goodsTable, good)
def upload2db(self):
self.getFieldsData()
proc_args = [self.doc_type, self.doc_name]
call_saved_procedure(self.db, 'add_regul_doc', proc_args)
self.fillAllMatTable()