def searchCustomer(self):
mob_num = self.searchled.text()
if mob_num == '':
self.statuslbl.setText('Must enter mobilephone to start search')
elif select_customer_by_mob_num(mob_num):
selectedCust = select_customer_by_mob_num(mob_num)
self.renamelbl.setText(selectedCust.name)
self.remobilenumlbl.setText(selectedCust.mobile_number)
self.remobilenumlbl1.setText(selectedCust.mobile_number_1)
self.remobilenumlbl2.setText(selectedCust.mobile_number_2)
self.remobilenumlbl3.setText(selectedCust.mobile_number_3)
self.remobilenumlbl4.setText(selectedCust.mobile_number_4)
city_name = select_city_by_id(selectedCust.city_id).name
self.recitylbl.setText(city_name)
self.reagelbl.setText(str(selectedCust.age))
self.regenderlbl.setText(selectedCust.gender.capitalize())
self.statuslbl.setText('')
self.detailsbtn.setEnabled(True)
# role handel
role = getLoginDataPKL()['role']
if int(role) == 1 or int(role) == 2 or int(role) == 3:
self.updatebtn.setEnabled(False)
else:
self.updatebtn.setEnabled(True)
if select_maintenance_customer(selectedCust.id):
self.statuslbl.setText(
"Can't delete, this customer have maintenance")
else:
return False
else:
self.statuslbl.setText("Can't found customer")
def updateCustomer(self):
if select_customer_by_mob_num(self.searchled.text()) and self.mobcustled.text() != '' or \
self.remobilenumlbl.text() != '':
selectedCust = select_customer_by_mob_num(self.searchled.text())
custname = self.custnameled.text()
custmobnum = self.mobcustled.text()
custmobnum1 = self.mobcustled91.text()
custmobnum2 = self.mobcustled92.text()
custmobnum3 = self.mobcustled93.text()
custmobnum4 = self.mobcustled94.text()
custcity_id = self.citycmbx.currentIndex()
custage = self.agespin.text()
if self.malebtn.isChecked():
gndr = 'male'
elif self.femalerbtn.isChecked():
gndr = 'female'
if custname:
custname = self.renamelbl.text()
if not custmobnum:
custmobnum = self.remobilenumlbl.text()
if self.citycmbx.currentIndex() == 0:
custcity_id = selectedCust.city_id
if self.agespin.value() == 0:
custage = self.reagelbl.text()
if not self.malebtn.isChecked() | self.femalerbtn.isChecked():
gndr = self.regenderlbl.text()
update_customer(selectedCust.id, custname, custmobnum, custmobnum1,
custmobnum2, custmobnum3, custmobnum4, gndr,
custage, custcity_id)
self.close()
else:
self.statuslbl.setText("No Customer To Update")
def searchCustomer(self):
mob_num = self.searchled.text()
if mob_num == '':
self.statuslbl.setText('Must enter mobilephone to start search')
elif select_customer_by_mob_num(mob_num):
selectedCust = select_customer_by_mob_num(mob_num)
self.renamelbl.setText(selectedCust.name)
self.custnameled.setText(selectedCust.name)
self.remobilenumlbl.setText(selectedCust.mobile_number)
self.remobilenumlbl91.setText(selectedCust.mobile_number_1)
self.remobilenumlbl92.setText(selectedCust.mobile_number_2)
self.remobilenumlbl93.setText(selectedCust.mobile_number_3)
self.remobilenumlbl94.setText(selectedCust.mobile_number_4)
self.mobcustled.setText(selectedCust.mobile_number)
self.mobcustled91.setText(selectedCust.mobile_number_1)
self.mobcustled92.setText(selectedCust.mobile_number_2)
self.mobcustled93.setText(selectedCust.mobile_number_3)
self.mobcustled94.setText(selectedCust.mobile_number_4)
city = select_city_by_id(selectedCust.city_id)
self.recitylbl.setText(city.name)
self.citycmbx.setCurrentText(city.name)
self.reagelbl.setText(str(selectedCust.age))
self.agespin.setValue(selectedCust.age)
self.regenderlbl.setText(selectedCust.gender.capitalize())
if selectedCust.gender == 'male':
self.malebtn.setChecked(True)
else:
self.femalerbtn.setChecked(True)
self.statuslbl.setText('')
else:
self.statuslbl.setText("Can't found customer")
def valiedDeleteCustomer(mobNum):
if customersModel.select_customer_by_mob_num(mobNum):
selectedCust = customersModel.select_customer_by_mob_num(mobNum)
if not maintenanceModel.select_maintenance_customer(
selectedCust.customers_id):
customersModel.delete_customer(selectedCust.id)
else:
return False
def do_createNewCustomer(self):
if not self.custnameled.text() or \
not self.mobcustled.text() or \
self.citycmbx.currentIndex() == 0 or \
self.agespin.value() == 0 or \
not self.malebtn.isChecked() and \
not self.femalerbtn.isChecked():
self.statuslbl.setText('All fields is required ')
else:
if not customersModel.select_customer_by_mob_num(self.mobcustled.text()):
name = self.custnameled.text()
mobileNumber = self.mobcustled.text()
mobileNumber_1 = self.mobcustled_1.text()
mobileNumber_2 = self.mobcustled_2.text()
mobileNumber_3 = self.mobcustled_3.text()
mobileNumber_4 = self.mobcustled_4.text()
if self.malebtn.isChecked():
gndr = 'male'
elif self.femalerbtn.isChecked():
gndr = 'female'
age = self.agespin.text()
city_id = self.citycmbx.currentIndex()
mainte = creatMaintenanceWithNewCustomer(name, mobileNumber, mobileNumber_1, mobileNumber_2,
mobileNumber_3, mobileNumber_4, gndr, age, city_id)
self.statuslbl.setText('A new customer added successfully ')
# print(mainte)
from uiview.ui_createBOM import Ui_createBOMDialog
self.b = Ui_createBOMDialog(mainte)
self.b.exec_()
self.close()
else:
self.statuslbl.setText('This customer is already exists ')
def tableDataShow(self):
mylist = []
if self.reqTypecomboBox.currentIndex() == 1:
mylist = getOutbounEmployeeRow()
self.tableData = OutboundTableModel()
self.protableView.setModel(self.tableData)
if self.reqTypecomboBox.currentIndex() == 2:
cust = select_customer_by_mob_num(self.mobnumled.text())
mylist = getOutbounOneCustomerRow(cust)
self.tableData = OutboundTableModel()
self.protableView.setModel(self.tableData)
self.protableView.setColumnWidth(0, 100)
self.protableView.setColumnWidth(1, 130)
self.protableView.setColumnWidth(2, 132)
self.protableView.setColumnWidth(3, 70)
self.protableView.setColumnWidth(4, 40)
for idx, val in enumerate(mylist):
self.tableData.addItems(
Outbound(
val.code,
None,
None,
val.customer_id,
val.employee_id,
val.raw_material_id, # raw
val.spare_part_id, # spare
val.tools_id, # tools
val.product_id, # product
val.req_qty, # qty
None))
def do_maint(self):
indexes = self.tableView.selectionModel().selectedRows(1)
for ind in sorted(indexes):
cst = select_customer_by_mob_num(ind.data())
maint = creatMaintenanceExtCustomer(cst)
from uiview.ui_createBOM import Ui_createBOMDialog
self.cbom = Ui_createBOMDialog(maint)
self.cbom.exec_()
def validCustomer(name, mobNum, mobile_number_1, mobile_number_2,
mobile_number_3, mobile_number_4, gender, age, city_id):
if not customersModel.select_customer_by_mob_num(mobNum):
customersModel.add_customer(name, mobNum, mobile_number_1,
mobile_number_2, mobile_number_3,
mobile_number_4, gender, age, city_id)
return True
else:
return False
def Clicked(self, item):
indexes = self.tableView.selectionModel().selectedRows(1)
for ind in sorted(indexes):
cst = select_customer_by_mob_num(ind.data())
self.customerNamelbl.setText(cst.name)
self.customerMobilelbl.setText(cst.mobile_number)
self.customerAgelbl.setText(str(cst.age))
cty = select_city_by_id(cst.city_id)
self.customerCitylbl.setText(cty.name)
self.createbtn.setEnabled(True)
def deleteCustomer(self):
mob_num = self.searchled.text()
selectedCust = select_customer_by_mob_num(mob_num)
if select_maintenance_customer(selectedCust.id):
self.statuslbl.setText("Can't delete customer")
else:
reply = QMessageBox.question(
QMessageBox(), 'Delete',
"Are you sure to delete this customer ?\n"
"This action you can't undo", QMessageBox.Yes | QMessageBox.No)
if reply == QMessageBox.Yes:
delete_customer(selectedCust.id)
self.close()
def openOutReport(self):
if self.reqTypecomboBox.currentIndex() == 1:
CreateOutboundReport().create_pdf()
mylist = getOutbounEmployeeRow()
for idx, val in enumerate(mylist):
if val.tools:
if val.tools.back == 1:
increaseToolsInvQty(val.tools, val.req_qty)
update_oubound_status(val.id, 0)
if self.reqTypecomboBox.currentIndex() == 2:
cust = select_customer_by_mob_num(self.mobnumled.text())
CreateOutboundCustReport(cust).create_pdf()
mylist = getOutbounOneCustomerRow(cust)
for idx, val in enumerate(mylist):
if val.tools:
if val.tools.back == 1:
increaseToolsInvQty(val.tools, val.req_qty)
update_oubound_status(val.id, 0)
def openHistory(self):
from uiview.ui_customerHistory import Ui_historyDialog
mob_num = self.searchled.text()
selectedCust = select_customer_by_mob_num(mob_num)
self.hd = Ui_historyDialog(selectedCust)
self.hd.exec_()