def Clicked(self, item): # role handel role = getLoginDataPKL()['role'] if int(role) == 1 or int(role) == 2: self.deletebtn.setEnabled(False) self.editbtn.setEnabled(True) self.deletebtn.setEnabled(True) code = before(item.text(), '-') if select_row_material_bycode(code): rawMat = select_row_material_bycode(code) self.codeled.setText(rawMat.code) self.nameled.setText(rawMat.name) self.unitled.setText(rawMat.unit) self.numsizeled.setText(str(rawMat.default_size)) self.strsizeled.setText(rawMat.string_size) self.costled.setText(str(rawMat.cost_per_default_size)) self.invQtyled.setText(str(rawMat.inv_qty)) self.miniled.setText(str(rawMat.mini_qty)) if not select_all_bill_of_material_item( ) == [] and not select_all_outbound() == []: for item in select_all_bill_of_material_item(): if item.raw_material_id == rawMat.id: self.deletebtn.setEnabled(False) for item in select_all_outbound(): if item.raw_material_id == rawMat.id: self.deletebtn.setEnabled(False) return rawMat
def Clicked(self, item): self.addbtn.setEnabled(True) code = before(item.text(), '-') if select_row_material_bycode(code): rawMat = select_row_material_bycode(code) self.rmcodeled.setText(rawMat.code) self.rmnameled.setText(rawMat.name) self.rmdefaultsizeled.setText(str(rawMat.default_size)) self.rminqtyled.setText(str(rawMat.inv_qty)) return rawMat
def do_delete(self): code = self.codeled.text() if not code == '': if select_row_material_bycode(code): rawMat = select_row_material_bycode(code) reply = QMessageBox.question( QMessageBox(), "OOP'S", 'Are you sure to delete ?\n Raw ' 'Material \n Code : {}'.format(rawMat.code) + '\n Name : {}'.format(rawMat.name) + '\n This Action Cant Undo', QMessageBox.Yes | QMessageBox.No) if reply == QMessageBox.Yes: delete_raw_material(rawMat.id) self.deletebtn.setEnabled(False) self.editbtn.setEnabled(False)
def update_data(self): id_code = self.rwcodelbl.text() uprm = select_row_material_bycode(id_code) xname = self.rwnameled.text() idx = self.unitcomboBox.currentIndex() xunit = list(self.unitdict.keys())[list( self.unitdict.values()).index(idx)] xdefault_size = self.defaultsizSpinBox.value() xstr_size = self.strsizeled.text() xminiqty = self.miniqtySpinBox.value() # # spesial case xcode = uprm.code xcost = uprm.cost_per_default_size xinv_qty = uprm.inv_qty # if xname == '': xname = uprm.name if xunit == uprm.unit: xunit = uprm.unit if xdefault_size == uprm.default_size: xdefault_size = uprm.default_size if xstr_size == '': xstr_size = uprm.string_size update_raw_material(uprm.id, xcode, xname, xdefault_size, xstr_size, xunit, xcost, xinv_qty, xminiqty) self.statulbl.setText("Data updated successfully")
def do_add(self): code = self.rmcodeled.text() rawmat = select_row_material_bycode(code) qty = self.reqqtyled_2.text() if not qty == '': # print(self.bomObj) self.close() createNewBOMItem(self.bomObj.id, rawmat.id, None, int(qty)) else: self.statulbl.setText("You must enter quantity you want")
def Clicked(self, item): self.dataupdatebtn.setEnabled(True) self.updatecostbtn.setEnabled(True) self.updateqtybtn.setEnabled(True) self.updateqtybtn_2.setEnabled(True) role = getLoginDataPKL()['role'] if int(role) == 2: self.updatecostbtn.setEnabled(False) self.updateqtybtn.setEnabled(False) self.updateqtybtn_2.setEnabled(False) self.dataupdatebtn.setEnabled(False) if int(role) == 3: self.dataupdatebtn.setEnabled(True) self.updatecostbtn.setEnabled(False) self.updateqtybtn_2.setEnabled(True) self.updateqtybtn.setEnabled(True) if int(role) == 1: self.updatecostbtn.setEnabled(True) self.updateqtybtn.setEnabled(False) self.updateqtybtn_2.setEnabled(False) self.dataupdatebtn.setEnabled(False) code = before(item.text(), '-') if select_row_material_bycode(code): rawMat = select_row_material_bycode(code) self.rwcodelbl.setText(rawMat.code) self.rwnamelbl.setText(rawMat.name) self.rwunitlbl.setText(rawMat.unit) self.rwdefaultsize.setText(str(rawMat.default_size)) self.rwstrsize.setText(rawMat.string_size) self.rwcostlbl.setText(str(rawMat.cost_per_default_size)) self.rwinvqtylbl.setText(str(rawMat.inv_qty)) self.minilbl.setText(str(rawMat.mini_qty)) self.rwnameled.setText(rawMat.name) self.unitcomboBox.setCurrentIndex(self.unitdict[rawMat.unit]) self.defaultsizSpinBox.setValue(rawMat.default_size) self.strsizeled.setText(rawMat.string_size) self.miniqtySpinBox.setValue(rawMat.mini_qty) ## old (cost and inv_qty) self.oldcostlbl.setText(str(rawMat.cost_per_default_size)) self.oldqtylbl.setText(str(rawMat.inv_qty)) return rawMat
def do_add(self): datetimestr = datetime.now() timestampstr = datetimestr.strftime('%Y-%m-%d %H:%M:%S') code = self.rmcodeled.text() rawmat = select_row_material_bycode(code) qty = self.reqqtyled_2.text() reas = self.reasonled.text() if qty != '' or reas != '': if type(self.obj) == Employees: add_outbound(OutBCode(), timestampstr, reas, None, self.obj.id, rawmat.id, None, None, None, qty, 1) if type(self.obj) == Customers: add_outbound(OutBCode(), timestampstr, reas, self.obj.id, None, rawmat.id, None, None, None, qty, 1) decreaseRawMaterialInvQty(rawmat, int(qty)) self.do_close()
def minupdate_inv(self): if self.newqtySpinBox_2.value() == 0: self.statulbl.setText('New Quantity is required ') else: reply = QMessageBox.question( QMessageBox(), 'Delete', "Are you sure to update " "inventory quantity ?\n" "This action you can't undo", QMessageBox.Yes | QMessageBox.No) id_code = self.rwcodelbl.text() uprm = select_row_material_bycode(id_code) n_inv = self.newqtySpinBox_2.value() if reply == QMessageBox.Yes: decreaseRawMaterialInvQty(uprm, n_inv) self.statulbl.setText("Data updated successfully") else: self.statulbl.setText("Data not updated ")
def update_cost(self): if self.newcostled.text() == '': self.statulbl.setText('The New Cost is Required') else: reply = QMessageBox.question( QMessageBox(), 'Delete', "Are you sure to update cost ?\n" "This action you can't undo", QMessageBox.Yes | QMessageBox.No) id_code = self.rwcodelbl.text() uprm = select_row_material_bycode(id_code) n_cost = self.newcostled.text() if n_cost == '': n_cost = uprm.cost_per_default_size if reply == QMessageBox.Yes: upRawMaterialCost(uprm, n_cost) self.statulbl.setText("Data updated successfully") else: self.statulbl.setText("Data not updated ")
def do_edit(self): from uiview.ui_updatereNewRM import Ui_editRWDialog spp = select_row_material_bycode(self.codeled.text()) self.dd = Ui_editRWDialog(spp) self.dd.exec_()