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