def __find_sale(self):
pdt = ProductDao()
selectionIdxs = self.ui.tableWidget_2.selectedIndexes()[0]
code = self.ui.tableWidget_2.item(selectionIdxs.row(), 1).text()
res = pdt.select(code)
find_res = str(res[0][1])
QMessageBox.information(self, '검색완료', find_res, QMessageBox.Ok)
def init_item(self):
pdt = ProductDao()
res = pdt.select()
self.ui.le_code.clear()
self.ui.le_name.clear()
row_res = self.ui.tableWidget.rowCount()
[self.ui.tableWidget.removeRow(i) for i in reversed(range(row_res))]
self.load_data(res)
def __init__(self):
super().__init__()
pf = Product_form()
sf = Sale_form()
pdt = ProductDao()
sdt = SaleDao()
sdd = Sale_Detail_Dao()
self.ui = uic.loadUi("ui/application.ui")
# create table
self.table = create_table(table=self.ui.tableWidget,
data=['code', 'name'])
self.table_sale = create_table(
table=self.ui.tableWidget_2,
data=['no', 'code', 'price', 'saleCnt', 'marginRate'])
self.table_sdd = create_table(
table=self.ui.table_sd,
data=['no', 'sale_price', 'addTax', 'supply_price', 'marginPrice'])
self.table_sdd_proc = create_table(table=self.ui.table_proc,
data=[
'rank', 'code', 'name', 'price',
'saleCnt', 'supply_price',
'addTax', 'sale_price',
'marginRate', 'marginPrice'
])
# select data
res = pdt.select()
res2 = sdt.select_item()
res3 = sdd.select_item()
self.load_data(res)
self.load_data_sale(res2)
self.load_data_sale_detail(res3)
# product 버튼 연결
self.ui.btn_insert.clicked.connect(self.add_item)
self.ui.btn_update.clicked.connect(self.update_item)
self.ui.btn_delete.clicked.connect(self.del_item)
self.ui.btn_init.clicked.connect(self.init_item)
self.ui.btn_pd_explain.clicked.connect(self.explain_pd)
# sale 버튼 연결
self.ui.btn_insert_2.clicked.connect(self.add_item_sale)
self.ui.btn_update_2.clicked.connect(self.update_item_sale)
self.ui.btn_delete_2.clicked.connect(self.del_item_sale)
self.ui.btn_init_2.clicked.connect(self.init_item_sale)
self.ui.btn_explain.clicked.connect(self.explain_sale)
# sale_detail_proc 버튼 연결
self.ui.rdbtn_sp.clicked.connect(self.call_proc_sp)
self.ui.rdbtn_mp.clicked.connect(self.call_proc_mp)
# 마우스 우클릭시 메뉴
pf.set_context_menu(self.ui.tableWidget, self.__update, self.__delete,
self.__find)
sf.set_context_menu_sale(self.ui.tableWidget_2, self.__update_sale,
self.__delete_sale, self.__find_sale)
self.ui.show()
