def search(self):
state = self.second_srv_combo.currentData()
record = stock_handler.get_calibration(state)
table_utils.set_table_content(self.tableView, record, self.table_title)
self.tableView.resizeColumnsToContents()
def _init_inventory_table(self):
inventorywaringtableView = self.inventorywaringtableView
# 填充数据
set_table_content(
inventorywaringtableView,
stock_unsalable_warning_handler.get_unsalable_warning(),
self.table_title)
def _submit(self):
name = self.staff_name.text()
sex = self.gender.text()
id_card_no = self.id_card_no.text()
submit_staff_info(name, sex, id_card_no, self.staff_id)
QMessageBox.information(self.submit, "提示", "提交成功")
self.close()
set_table_content(self.staff_table, get_all_staff(), self.table_title)
def _init_write_off_table(self):
write_off_date = stock_detail_handler.get_negative_on_hand()
table_utils.set_table_content(self.write_off_table, write_off_date,
self.table_title)
self.write_off_table.setColumnHidden(7, True)
self.write_off_table.setColumnHidden(8, True)
self.write_off_table.setColumnHidden(9, True)
self.write_off_table.setColumnHidden(11, True)
self.write_off_table.setColumnHidden(13, True)
self.write_off_table.horizontalHeader().setStretchLastSection(True)
def _delete_staff(self):
staff_id = get_table_current_index_info(self.staff_table, 0)
if staff_id:
reply = QtWidgets.QMessageBox.question(self.delete_staff, 'Message',
"是否删除此员工?", QtWidgets.QMessageBox.Yes, QtWidgets.QMessageBox.No)
if reply == QtWidgets.QMessageBox.Yes:
delete_staff_by_id(staff_id)
set_table_content(self.staff_table, get_all_staff(), self.table_title)
else:
QtWidgets.QMessageBox.information(self.delete_staff, "提示", "请选择员工")
def _init_ui(self):
table_utils.set_table_content(self.tableView, (), self.table_title)
time_now = time_utils.get_now()
self.start_date.setDateTime(
QDateTime.fromString(time_now, 'yyyy-MM-dd hh:mm:ss'))
self.end_date.setDateTime(
QDateTime.fromString(time_now, 'yyyy-MM-dd hh:mm:ss'))
self._init_brand_and_model()
self._init_first_srv()
def _init_ui(self):
record = stock_handler.get_calibrationAll()
table_utils.set_table_content(self.tableView, record, self.table_title)
# time_now = time_utils.get_now()
# self.start_date.setDateTime(QDateTime.fromString(time_now, 'yyyy-MM-dd hh:mm:ss'))
# self.end_date.setDateTime(QDateTime.fromString(time_now, 'yyyy-MM-dd hh:mm:ss'))
# self._init_brand_and_model()
# self._init_first_srv()
self.second_srv_combo.addItem("未审核", "0")
self.second_srv_combo.addItem("已审核", "1")
def _refresh_second_service(self):
father_id = get_table_current_index_info(self.first_service_table, 0)
if not father_id:
return
set_table_content(self.second_service_table, service_handler.get_second_service_by_father(father_id),
self.second_service_title)
self.second_service_table.setColumnHidden(0, True)
self.second_service_table.setColumnHidden(1, True)
self.second_service_table.setColumnHidden(2, True)
self.second_service_table.setColumnHidden(4, True)
self.second_service_table.setColumnHidden(5, True)
def __init__(self):
super(Staff, self).__init__()
self.setupUi(self)
self.setWindowTitle('门店人员管理')
self.staff_table.horizontalHeader().setDefaultAlignment(Qt.AlignCenter)
self.table_title = ("ID", '姓名', '性别', '身份证号码', '创建时间')
self._init_signal_and_slot()
set_table_content(self.staff_table, get_all_staff(), self.table_title)
def _submit(self):
name = self.username.text()
pwd = self.password.text() + 'udontknowwhy'
pwd = md5(pwd)
insert_sys_user_info(name, pwd)
QMessageBox.information(self.submit, "提示", "提交成功")
self.close()
# 刷新页面显示内容
set_table_content(self.sys_user_table, get_all_sys_user(),
self.table_title)
def _remove_sys_user(self):
id = get_table_current_index_info(self.sys_user_table, 0)
if id:
reply = QtWidgets.QMessageBox.question(self.remove_sys_user,
'Message', "是否删除此管理员?",
QtWidgets.QMessageBox.Yes,
QtWidgets.QMessageBox.No)
if reply == QtWidgets.QMessageBox.Yes:
delete_sys_user_by_id(id)
set_table_content(self.sys_user_table, get_all_sys_user(),
self.table_title)
else:
QtWidgets.QMessageBox.information(self.remove_sys_user, "提示",
"请选择一条记录")
def __init__(self):
super(SystemUser, self).__init__()
self.setupUi(self)
self.setWindowTitle('系统人员管理')
self.sys_user_table.horizontalHeader().setDefaultAlignment(
Qt.AlignCenter)
self.table_title = ("ID", '用户名', '密码', '创建时间')
self._init_signal_and_slot()
set_table_content(self.sys_user_table, get_all_sys_user(),
self.table_title)
def _refresh_history_table(self, record):
table_utils.set_table_content(self.history_table, record,
self.history_table_title)
def _update_device_table(self):
set_table_content(self.device_table, get_all_device(),
self.table_title)
def _refresh_first_service(self):
set_table_content(self.first_service_table, service_handler.get_all_first_level_service(),
self.first_service_title)
self.first_service_table.setColumnHidden(0, True)
def _init_table(self):
record = attribute_handler.get_all_attributes()
table_utils.set_table_content(self.tableView, record, self.table_title)
self.tableView.setColumnHidden(0, True)
self.tableView.setColumnHidden(3, True)
def _init_detail_table(self, record):
table_utils.set_table_content(self.detail_table, record, self.detail_table_title)
self.detail_table.setColumnHidden(0, True)
self.detail_table.setColumnHidden(8, True)
self.detail_table.setColumnHidden(14, True)
self.detail_table.resizeColumnsToContents()
def _init_table(self):
table_utils.set_table_content(self.sales_details_result_table, [],
self.table_title)
def _init_compare_table(self, record):
table_utils.set_table_content(self.compare_table, record,
self.compare_table_title)
def _init_summary_table(self):
record = payment_handler.get_all_arrears_info()
table_utils.set_table_content(self.summary_table, record, self.summary_table_title)
self.summary_table.setColumnHidden(0, True)
self.summary_table.resizeColumnsToContents()
def _refresh_summary_table(self, record):
table_utils.set_table_content(self.summary_table, record, self.summary_table_title)
self.summary_table.setColumnHidden(0, True)
self.summary_table.setColumnHidden(1, True)