def do_delete(self): code = self.codeled.text() if select_tools_by_gen_code(code): rawMat = select_tools_by_gen_code(code) reply = QMessageBox.question( QMessageBox(), "OOP'S", 'Are you sure to delete ?\n Tool \n System Code : {}'.format( rawMat.gen_code) + '\n Name : {}'.format(rawMat.name) + '\n This Action Cant Undo', QMessageBox.Yes | QMessageBox.No) if reply == QMessageBox.Yes: delete_tools(rawMat.id)
def Clicked(self, item): self.addbtn.setEnabled(True) code = before(item.text(), '-') if select_tools_by_gen_code(code): rawMat = select_tools_by_gen_code(code) if rawMat.back == 0: self.spnameled.setText(rawMat.name + "/ Not Backable") if rawMat.back == 1: self.spnameled.setText(rawMat.name) self.spinqtyled.setText(str(rawMat.inv_qty)) self.spgencodeled.setText(rawMat.gen_code) return rawMat
def Clicked(self, item): role = getLoginDataPKL()['role'] if int(role) == 1 or int(role) == 2: self.deletebtn.setEnabled(False) self.editbtn.setEnabled(True) self.deletebtn.setEnabled(True) gencode = before(item.text(), ' -') if select_tools_by_gen_code(gencode): spart = select_tools_by_gen_code(gencode) print(gencode) self.nameled.setText(spart.name) self.unitled.setText(spart.unit) self.codeled.setText(spart.gen_code) self.costled.setText(str(spart.price)) self.invQtyled.setText(str(spart.inv_qty)) self.miniQtyled.setText(str(spart.mini_qty)) if not select_all_outbound() == []: for item in select_all_outbound(): if item.tools_id == spart.id: self.deletebtn.setEnabled(False) return spart
def Clicked(self, item): self.dataupdatebtn.setEnabled(True) self.updatecostbtn.setEnabled(True) self.updateqtybtn.setEnabled(True) self.minupdateqtybtn.setEnabled(True) role = getLoginDataPKL()['role'] if int(role) == 2: self.updatecostbtn.setEnabled(False) self.updateqtybtn.setEnabled(False) self.dataupdatebtn.setEnabled(False) if int(role) == 3: self.updatecostbtn.setEnabled(False) self.updateqtybtn.setEnabled(True) self.dataupdatebtn.setEnabled(True) if int(role) == 1: self.updatecostbtn.setEnabled(True) self.updateqtybtn.setEnabled(False) self.dataupdatebtn.setEnabled(False) gencode = before(item.text(), '-') if select_tools_by_gen_code(gencode): tool = select_tools_by_gen_code(gencode) print(tool) self.tonamelbl.setText(tool.name) self.tounitlbl.setText(tool.unit) self.togencodelbl.setText(tool.gen_code) self.tocostlbl.setText(str(tool.price)) self.toinvqtylbl.setText(str(tool.inv_qty)) self.miniqtylbl.setText(str(tool.mini_qty)) self.miniled.setText(str(tool.mini_qty)) self.tonameled.setText(tool.name) self.unitcomboBox.setCurrentIndex(self.unitdict[tool.unit]) ## old (cost and inv_qty) self.oldcostlbl.setText(str(tool.price)) self.oldqtylbl.setText(str(tool.inv_qty)) return tool
def do_add(self): datetimestr = datetime.now() timestampstr = datetimestr.strftime('%Y-%m-%d %H:%M:%S') code = self.spgencodeled.text() rawmat = select_tools_by_gen_code(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, None, None, rawmat.id, None, qty, 1) if type(self.obj) == Customers: add_outbound(OutBCode(), timestampstr, reas, self.obj.id, None, None, None, rawmat.id, None, qty, 1) decreaseToolsInvQty(rawmat, int(qty)) self.close()
def minupdate_inv(self): if self.minnewqtySpinBox_2.value() == 0: self.statulbl.setText("New Quantity 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.togencodelbl.text() upsp = select_tools_by_gen_code(id_code) n_inv = self.minnewqtySpinBox_2.value() if reply == QMessageBox.Yes: decreaseToolsInvQty(upsp, 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('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.togencodelbl.text() upsp = select_tools_by_gen_code(id_code) n_cost = self.newcostled.text() if n_cost == '': n_cost = upsp.price if reply == QMessageBox.Yes: updateToolsCost(upsp, n_cost) self.statulbl.setText("Data updated successfully") else: self.statulbl.setText("Data not updated ")
def update_data(self): id_code = self.togencodelbl.text() upsp = select_tools_by_gen_code(id_code) xname = self.tonameled.text() idx = self.unitcomboBox.currentIndex() xunit = list(self.unitdict.keys())[list( self.unitdict.values()).index(idx)] # # spesial case xcost = upsp.price xinv_qty = upsp.inv_qty xgen_code = upsp.gen_code xmini = self.miniled.text() # if xname == '': xname = upsp.name if xunit == upsp.unit: xunit = upsp.unit update_tools(upsp.id, xname, xcost, xinv_qty, xunit, xgen_code, xmini) self.statulbl.setText("Data updated successfully")
def do_edit(self): from uiview.ui_updatereNewTO import Ui_editTODialog spp = select_tools_by_gen_code(self.codeled.text()) self.dd = Ui_editTODialog(spp) self.dd.exec_()