def single_pay(self):
buy_id = table_utils.get_table_current_index_info(
self.detail_table, 10)
if not buy_id:
QMessageBox.information(self.single_button, '提示', '请选择一条明细！')
return
buy_info = BuyInfo()
buy_info.buy_id(int(buy_id))
unpaid = Decimal(
table_utils.get_table_current_index_info(self.detail_table, 9))
paid = Decimal(
table_utils.get_table_current_index_info(self.detail_table, 8))
supplier_id = self._get_supplier_id()
buy_info.paid(paid)
buy_info.unpaid(unpaid)
buy_info.note(self.supplier_name)
buy_info.supplier_id(supplier_id)
dialog = PayOffArrearsDialog(buy_info)
dialog.exec()
self._init_table()
def show_detail(self, index: QModelIndex):
if index.column() != 14:
return
self.sale_id = table_utils.get_table_cell(self.write_off_table,
index.row(), 0)
self.stock_id = table_utils.get_table_current_index_info(
self.write_off_table, 9)
self.brand_id = table_utils.get_table_current_index_info(
self.write_off_table, 7)
self.model_id = table_utils.get_table_current_index_info(
self.write_off_table, 8)
self.buy_date.setDateTime(
QDateTime.fromString(time_utils.get_now(), 'yyyy-MM-dd hh:mm:ss'))
self.brand.setText(
table_utils.get_table_current_index_info(self.write_off_table, 2))
self.model.setText(
table_utils.get_table_current_index_info(self.write_off_table, 3))
self.sale_number.setText(
table_utils.get_table_current_index_info(self.write_off_table, 4))
balance = int(
table_utils.get_table_current_index_info(self.write_off_table, 5))
self.buy_number.setValue(abs(balance))
self.unit.setText(
table_utils.get_table_current_index_info(self.write_off_table, 6))
self.service.setText(
table_utils.get_table_current_index_info(self.write_off_table,
10) + '-' +
table_utils.get_table_current_index_info(self.write_off_table, 12))
self.price.setText('0.0')
self.total.setText('0.0')
self.paid.setText('0.0')
self.unpaid.setText('0.0')
self.balance = balance
def _remove_second_service(self):
service_id = get_table_current_index_info(self.second_service_table, 2)
if service_id:
service_name = get_table_current_index_info(
self.second_service_table, 3)
reply = QtWidgets.QMessageBox.question(
self.remove_second_service, 'Message',
"是否删除此服务项目：" + service_name + "？", QtWidgets.QMessageBox.Yes,
QtWidgets.QMessageBox.No)
if reply == QtWidgets.QMessageBox.Yes:
stock_num = stock_handler.get_count_by_service(service_id)
if stock_num and stock_num[0]:
QtWidgets.QMessageBox.information(
self.remove_second_service, "提示", "该服务项目存在库存信息，不允许删除！")
return
else:
try:
db_transaction_util.begin()
service_handler.delete_service_all_attribute(
service_id)
service_handler.delete_service(service_id)
db_transaction_util.commit()
QtWidgets.QMessageBox.information(
self.remove_second_service, "提示", "删除成功！")
self._refresh_second_service()
except Exception as e:
print(e)
db_transaction_util.rollback()
QtWidgets.QMessageBox.information(
self.remove_second_service, "提示", "删除失败，请重试！")
else:
QtWidgets.QMessageBox.information(self.remove_second_service, "提示",
"请选择二级服务项目")
def do_remove(self):
attr_id = table_utils.get_table_current_index_info(self.tableView, 0)
message = QMessageBox.information(self.remove, '提示', '是否要删除该属性？',
QMessageBox.Yes | QMessageBox.No,
QMessageBox.Yes)
if message == QMessageBox.No:
return
if not attr_id:
QMessageBox.information(self.remove, '提示', '请选择一条属性进行修改！')
return
is_required = int(
table_utils.get_table_current_index_info(self.tableView, 3))
if is_required:
QMessageBox.information(self.remove, '提示', '必填属性不允许删除！')
return
service_count = service_handler.get_count_by_attribute(attr_id)
if service_count and service_count[0]:
QMessageBox.information(self.remove, '提示', '该属性已经关联到服务项目上，不允许删除！')
return
try:
attribute_handler.delete_attribute_logical(int(attr_id))
QMessageBox.information(self.remove, '提示', '删除成功')
self._init_table()
except Exception as e:
print(e)
QMessageBox.information(self.remove, '提示', '该属性删除失败，请重新尝试！')
def _update_first_service(self):
service_id = get_table_current_index_info(self.first_service_table, 0)
if not service_id:
QtWidgets.QMessageBox.information(self.update_first_service, "提示",
"请选择一级服务项目")
return
service_name = get_table_current_index_info(self.first_service_table,
1)
service = FirstLevelServiceInfo('修改一级服务项目',
service_id=service_id,
service_name=service_name)
service.exec()
self._refresh_all_table()
def do_update(self):
attr_id = table_utils.get_table_current_index_info(self.tableView, 0)
if not attr_id:
QMessageBox.information(self.add, '提示', '请选择一条属性进行修改！')
return
attr_id = int(attr_id)
old_attr_name = table_utils.get_table_current_index_info(
self.tableView, 1)
new_attr_name, ok = QInputDialog.getText(self.edit, '修改属性', '请修改属性名称',
QLineEdit.Normal,
old_attr_name)
if new_attr_name and ok:
exists_info = attribute_handler.get_count_by_name(new_attr_name)
if exists_info:
if not exists_info[1]:
QMessageBox.information(self.edit, '提示', '该属性已经存在，请重新输入')
return
else:
try:
db_transaction_util.begin()
# 将原来的属性对应的销售信息更新到当前的属性ID上
sale_item_handler.update_item_id(
exists_info[2], attr_id)
# 物理删除原来的属性
attribute_handler.delete_attribute_physical(
exists_info[2])
# 修改新的属性名称
attribute_handler.update_attribute(
attr_id, new_attr_name)
db_transaction_util.commit()
except Exception as e:
print(e)
db_transaction_util.rollback()
QMessageBox.information(self.edit, '提示',
'该属性名称修改失败，请重新提交！')
else:
try:
attribute_handler.update_attribute(attr_id, new_attr_name)
QMessageBox.information(self.edit, '提示', '新增成功')
self._init_table()
except Exception as e:
print(e)
QMessageBox.information(self.edit, '提示',
'该属性名称修改失败，请重新提交！')
def _return_visit_process(self):
record_id = get_table_current_index_info(self.return_visit_table, 0)
if record_id:
username = get_table_current_index_info(self.return_visit_table, 1)
car_id = get_table_current_index_info(self.return_visit_table, 2)
car_phone = get_table_current_index_info(self.return_visit_table,
3)
return_visit_date = get_table_current_index_info(
self.return_visit_table, 4)
ui = ReturnVisitSetting(return_visit_date, record_id, car_phone,
car_id, username)
ui.exec_()
self._init_table_title()
else:
QtWidgets.QMessageBox.information(self.return_visit_button, "提示",
"请选择未回访记录")
def _update_staff(self):
record_id = get_table_current_index_info(self.staff_table, 0)
staff_name = get_table_current_index_info(self.staff_table, 1)
sex = get_table_current_index_info(self.staff_table, 2)
id_card_no = get_table_current_index_info(self.staff_table, 3)
if record_id:
staff = StaffInfo(staff_table=self.staff_table,
window_title="修改员工信息",
table_tile=self.table_title,
staff_id=record_id,
name=staff_name,
id_card_no=id_card_no,
sex=sex)
staff.exec()
else:
QtWidgets.QMessageBox.information(self.update_staff, "提示", "请选择员工")
def _stop(self):
device_id = get_table_current_index_info(self.device_table, 0)
if not device_id:
QtWidgets.QMessageBox.information(self.stop, "提示", "请选择设备")
else:
update_device_state(device_id, self.stop_state)
QtWidgets.QMessageBox.information(self.stop, "提示", "设备已禁用")
self._update_device_table()
def _refresh_detail_table(self, index):
second_srv_id = table_utils.get_table_current_index_info(
self.summary_table, 1)
if second_srv_id:
record = buy_handler.get_detail_info(second_srv_id,
self.start_time_str,
self.end_time_str)
self._init_detail_table(record)
def do_review(self):
review_id = table_utils.get_table_current_index_info(self.tableView, 0)
if not review_id:
QMessageBox.information(self.reviewButton, '提示', '请选择待审核的库存校准数据！')
return
stock_id = int(
table_utils.get_table_current_index_info(self.tableView, 1))
stock_detail = stock_detail_handler.get_calibration_detail_by_buy_id(
review_id)
changed_type = stock_detail['type']
answer = QMessageBox.information(
self.reviewButton, '校准审核', '是否审核通过该项库存校准？',
QMessageBox.Yes | QMessageBox.No | QMessageBox.Cancel,
QMessageBox.Yes)
try:
db_transaction_util.begin()
if answer == QMessageBox.Yes:
changed_cost = Decimal(
table_utils.get_table_current_index_info(
self.tableView, 9))
changed_number = int(
table_utils.get_table_current_index_info(
self.tableView, 7))
if changed_type == StockDetail.by_decreased():
buy_service.decrease_buy_left(stock_id,
abs(changed_number))
else:
buy_service.increase_buy_left(stock_id,
abs(changed_number))
stock_handler.update_stock_balance(stock_id, changed_number,
changed_cost)
buy_handler.update_buy_state(review_id, BuyInfo.normal())
elif answer == QMessageBox.No:
buy_handler.update_buy_state(review_id, BuyInfo.rejected())
db_transaction_util.commit()
self._init_table()
except Exception as e:
db_transaction_util.rollback()
logger.error(e)
logger.error('traceback.format_exc():\n{}'.format(
traceback.format_exc()))
def _change_sys_user(self):
user_id = get_table_current_index_info(self.sys_user_table, 0)
if user_id:
sys_user = ChangePassword(user_id)
sys_user.exec()
else:
QtWidgets.QMessageBox.information(self.change_sys_user, "提示",
"请选择管理员")
def _get_supplier_id(self):
supplier_id = table_utils.get_table_current_index_info(
self.summary_table, 0)
if not supplier_id:
supplier_id = int(
table_utils.get_table_cell(self.summary_table, 0, 0))
else:
supplier_id = int(supplier_id)
return supplier_id
def _add_second_service(self):
father_id = get_table_current_index_info(self.first_service_table, 0)
if not father_id:
QtWidgets.QMessageBox.information(self.add_second_service, "提示",
"请选择一级服务项目")
else:
service = SecondServiceInfo('新增二级服务项目', father_id=father_id)
service.exec()
self._refresh_second_service()
def _update_second_service(self):
service_id = get_table_current_index_info(self.second_service_table, 2)
if not service_id:
QtWidgets.QMessageBox.information(self.add_second_service, "提示",
"请选择二级服务项目")
else:
father_id = get_table_current_index_info(self.second_service_table,
0)
service_name = get_table_current_index_info(
self.second_service_table, 3)
service = SecondServiceInfo('修改二级服务项目',
service_id=service_id,
father_id=father_id,
service_name=service_name)
service.exec()
self._refresh_second_service()
self.attribute_table.model().removeRows(
0,
self.attribute_table.model().rowCount())
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)
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 _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 _remove_first_service(self):
service_id = get_table_current_index_info(self.first_service_table, 0)
if service_id:
service_name = get_table_current_index_info(
self.first_service_table, 1)
reply = QtWidgets.QMessageBox.question(
self.remove_first_service, 'Message',
"是否删除此服务项目：" + service_name + "？", QtWidgets.QMessageBox.Yes,
QtWidgets.QMessageBox.No)
if reply == QtWidgets.QMessageBox.Yes:
if not service_handler.get_second_service_count_by_father(
service_id)[0]:
service_handler.delete_service(service_id)
QtWidgets.QMessageBox.information(
self.remove_first_service, "提示", "删除成功！")
self._refresh_all_table()
else:
QtWidgets.QMessageBox.information(
self.remove_first_service, "提示",
"该一级服务项目下存在二级服务项目，不能删除！")
else:
QtWidgets.QMessageBox.information(self.remove_first_service, "提示",
"请选择一级服务项目")
def _clear_detail(self):
self.buy_date.setDateTime(
QDateTime.fromString(time_utils.get_now(), 'yyyy-MM-dd hh:mm:ss'))
self.brand.clear()
self.model.clear()
self.sale_number.clear()
self.buy_number.setValue(
abs(
int(
table_utils.get_table_current_index_info(
self.write_off_table, 5))))
self.unit.clear()
self.service.clear()
self.price.setText('0.0')
self.total.setText('0.0')
self.paid.setText('0.0')
self.unpaid.setText('0.0')
self.sale_id = 0
self.stock_id = 0
self.brand_id = 0
self.model_id = 0
self.balance = 0
def _get_attribute_list(self):
service_id = get_table_current_index_info(self.second_service_table, 2)
attribute = service_handler.get_attribute_by_service(service_id)
return attribute
def _refresh_compare_table(self, index: int):
model_id = table_utils.get_table_current_index_info(
self.history_table, 0)
if model_id:
record = buy_handler.get_compare_info(model_id)
self._init_compare_table(record)