def __init__(self, con, cur):
super(ArchZakaz, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
headers = ('Код заказа', "Гос номер", "Статус", "Дата записи")
headers_2 = ('Услуга', "Запчасть", "Статус", "Дата записи")
self.dial_ui.zakazTable.setColumnCount(len(headers))
for i, head in enumerate(headers):
item = QtWidgets.QTableWidgetItem(head)
self.dial_ui.zakazTable.setHorizontalHeaderItem(i, item)
self.dial_ui.uslugaTable.setColumnCount(len(headers_2))
for i, head in enumerate(headers_2):
item = QtWidgets.QTableWidgetItem(head)
self.dial_ui.uslugaTable.setHorizontalHeaderItem(i, item)
self.fill_data()
self.dial_ui.pushButton.clicked.connect(self.upd_data)
self.dial_ui.zakazTable.cellClicked.connect(self.foo)
self.exec_()
def __init__(self, con, cur, type_, id_serv=int):
super(Add_usluga, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.id_serv = id_serv
self.up_st = []
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
if type_ == 'insert':
self.dial_ui.pushButton.clicked.connect(self.insert_usluga_action)
if type_ == 'update':
self.fill_data()
self.dial_ui.pushButton.clicked.connect(self.update_usluga_action)
self.exec_()
def __init__(self, con, cursor):
super(Add_Task, self).__init__()
self.db = autowork_db()
self.db.connection, self.db.cursor = con, cursor
self.id_serv = []
self.id_spec = []
self.id_empl = []
self.id_zakaz = []
self.id_time = []
self.dial_ui = Ui_Dialog()
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.dial_ui.dateEdit.setDate(datetime.now().date())
self.fill_serv()
self.fill_spec()
self.fill_empl()
self.fill_tasks()
self.fill_info()
self.dial_ui.specBox.currentIndexChanged.connect(self.fill_empl)
self.dial_ui.uslugaBox.currentTextChanged.connect(self.foo)
self.dial_ui.taskBox.currentIndexChanged.connect(self.fill_info)
self.dial_ui.taskBox.currentTextChanged.connect(self.fill_info)
self.dial_ui.pushButton.clicked.connect(self.insert_task)
self.exec_()
def __init__(self, con, cur):
super(Parts, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
headers = ('Марка', 'Модель', 'Название', 'Цена', 'Кол-во')
self.setWindowTitle('Доступные запчасти')
self.dial_ui.tableWidget.setColumnCount(5)
for i, head in enumerate(headers):
item = QtWidgets.QTableWidgetItem(head)
self.dial_ui.tableWidget.setHorizontalHeaderItem(i, item)
self.fill_data()
self.exec_()
def __init__(self, con, cur):
super(ArchEmpl, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
headers = ('Код', "ФИО", "Дата приёма на работу", "Ставка", "Телефон",
"Статус", "Дата записи")
self.dial_ui.tableWidget.setColumnCount(len(headers))
for i, head in enumerate(headers):
item = QtWidgets.QTableWidgetItem(head)
self.dial_ui.tableWidget.setHorizontalHeaderItem(i, item)
self.fill_data()
self.dial_ui.pushButton.clicked.connect(self.upd_data)
self.exec_()
def __init__(self, connection, cursor, *args, **kwargs):
super(AddAutoCust, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = connection
self.db.cursor = cursor
self.id_client, self.fio = args
self.cost = 0
self.part_cost = 0
self.duration = time(0, 0, 0)
self.duration.strftime("%H:%M:%S")
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.fill_data()
self.fill_comp()
self.fill_mark()
self.fill_usluga()
self.dial_ui.markAuto.currentTextChanged.connect(self.fill_mark)
self.dial_ui.addUsluga.clicked.connect(self.add_uslugi)
self.dial_ui.delUsluga.clicked.connect(self.del_uslugi)
self.dial_ui.pushButton.clicked.connect(self.insert_data)
self.exec_()
def __init__(self, specs, con, cur, type_, up_st=()):
super(EmpDial, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.fill_box(specs)
if type_ == 'insert':
self.dial_ui.pushButton.clicked.connect(self.insert_data)
if type_ == 'update':
self.fill_data(*up_st)
self.fio, self.rate, self.spec, self.phone = self.get_data()
self.dial_ui.pushButton.clicked.connect(self.update_data)
self.exec_()
def __init__(self):
super(ConDial, self).__init__()
self.db = autowork_db()
self.con, self.cursor = None, None
self.dial_ui = Ui_Dialog()
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.dial_ui.pushButton.clicked.connect(self.mainDial)
self.exec_()
def __init__(self, con, cur):
super(CarDial, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.dial_ui.pushButton.clicked.connect(self.insert_data)
self.exec_()
def __init__(self, con, cur, id_shedule):
super(TaskInfo, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.fill_data(id_shedule)
self.exec_()
def __init__(self, con, cur):
super(Usluga, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.fill_data()
self.exec_()
def __init__(self, con, cur, id_empl):
super(History, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.id_empl = id_empl
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.fill_data()
self.dial_ui.pushButton.clicked.connect(self.upd_data)
self.exec_()
def __init__(self, con, cursor, type_, data=str):
super(Add_specialization, self).__init__()
self.db = autowork_db()
self.db.connection, self.db.cursor = con, cursor
self.dial_ui = Ui_Dialog()
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
if type_ == 'insert':
self.dial_ui.pushButton.clicked.connect(self.insert_spec)
if type_ == 'update':
self.old_name = data
self.dial_ui.lineEdit.setText(data)
self.dial_ui.pushButton.clicked.connect(self.change_spec)
self.exec_()
def __init__(self, con, cur):
super(Cars, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
headers = ('Марка', 'Модель', 'Гос номер')
self.setWindowTitle('Автомобили в сервисе')
for i, head in enumerate(headers):
self.dial_ui.tableWidget.horizontalHeaderItem(i).setText(head)
self.fill_data()
self.exec_()
def __init__(self, con, cur, id_cust, id_z):
super(Order_status, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.id_z = id_z
self.id_cust = id_cust
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.dial_ui.delZakaz.clicked.connect(self.delete_zakaz_action)
self.dial_ui.finishZak.clicked.connect(self.finish_zakaz_action)
self.dial_ui.printButton.clicked.connect(self.print_)
self.fill_data(id_cust, id_z)
self.exec_()
def __init__(self, con, cur, type_, up_st=()):
super(CustDial, self).__init__()
self.dial_ui = Ui_Dialog()
self.db = autowork_db()
self.db.connection = con
self.db.cursor = cur
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
if type_ == "insert":
self.dial_ui.pushButton.clicked.connect(self.insert_data)
if type_ == "update":
self.fill_data(up_st)
self.fio, self.phone = self.get_form_data()
self.dial_ui.pushButton.clicked.connect(self.update_data)
self.exec_()
def __init__(self, con, cursor, mark, model, id_serv):
super(Count_Orders, self).__init__()
self.dial_ui = Ui_Dialog()
self.dial_ui.setupUi(self)
self.dial_ui.retranslateUi(self)
self.db = autowork_db()
self.db.connection, self.db.cursor = con, cursor
self.fill_zapch(mark, model)
self.value = 0
self.part_value = 0
self.part_cost = 0
self.id_serv = id_serv
self.dial_ui.pushButton.clicked.connect(self.get_number)
self.dial_ui.addZapch.clicked.connect(self.add_parts)
self.dial_ui.delZapch.clicked.connect(self.del_parts)
self.exec_()
