def insertRows_vendor_part(self, details):
row_count = len(self.user_data)
self.beginInsertRows(QtCore.QModelIndex(), row_count, row_count)
empty_data = []
if len(details) == 1: #Vendor
for key in self.columns:
if not key == 'id_':
if key == "Vendor Name":
empty_data.append(str(details[0]))
else:
empty_data.append("")
print(empty_data)
document_id = databaseOperations.insert_data(
empty_data, self.column_names, self.table_name)
else:
for key in self.columns:
if not key == 'id_':
if key == "Part Name":
empty_data.append(str(details[0]))
elif key == "Vehicle Type":
empty_data.append(str(details[1]))
else:
empty_data.append("")
document_id = databaseOperations.insert_data(
empty_data, self.column_names, self.table_name)
row_count += 1
new_data = databaseOperations.get_single_data(row_count,
self.table_name)
self.user_data = databaseOperations.get_multiple_data(self.table_name)
self.endInsertRows()
return True
def insertRows(self):
row_count = len(self.customer_data)
self.beginInsertRows(QtCore.QModelIndex(), row_count, row_count)
empty_data = {key: None for key in self.columns if not key == '_id'}
document_id = databaseOperations.insert_data(empty_data)
new_data = databaseOperations.get_single_data(document_id)
self.customer_data.append(new_data)
row_count += 1
self.endInsertRows()
return True
def sell_finishBtn_clicked(self):
if self.sell_model.rowCount() == 0:
return
for row in range(self.sell_model.rowCount()):
role = Qt.DisplayRole
vol = self.sell_model.data(self.sell_model.index(row, 5), role)
vendor = self.sell_model.data(self.sell_model.index(row, 7), role)
part = self.sell_model.data(self.sell_model.index(row, 2), role)
vehicle = self.sell_model.data(self.sell_model.index(row, 3), role)
# databaseOperations.update_existing_stock(vol,vendor,part,vehicle)
databaseOperations.update_existing_Threshold(
days_passed_global, vol, part, vehicle)
self.sell_model = CustomModel.CustomTableModelUserData([], [
"id_", "Invoice No.", "Part Name", "Vehicle Type", "Price",
"Volume", "Amount", "Vendor Name", "Cost Price"
], [
"invoice_number", "part_name", "vehicle_type", "price", "volume",
"amount", "vendor_name", "cp"
], "Invoice")
self.sell_delegate = CustomModel.InLineEditDelegate()
self.ui.sell_Table.setModel(self.sell_model)
self.ui.sell_Table.setItemDelegate(self.sell_delegate)
self.ui.sell_Table.verticalHeader().setDefaultSectionSize(50)
self.ui.sell_Table.setColumnWidth(0, 30)
self.ui.sell_Table.hideColumn(0)
self.ui.sell_Table.hideColumn(8)
self.ui.sell_Table.setSelectionBehavior(QTableView.SelectRows)
self.ui.sell_Table.horizontalHeader().setSectionResizeMode(
QtWidgets.QHeaderView.Stretch)
databaseOperations.insert_data(
[days_passed_global, invoice_number_global],
["Date", "invoice_number"], "Sales")
update_invoice_number()
def insertRows(self):
row_count = len(self.user_data)
self.beginInsertRows(QtCore.QModelIndex(), row_count, row_count)
empty_data = []
for key in self.columns:
if not key == 'id_':
empty_data.append("")
document_id = databaseOperations.insert_data(empty_data,
self.column_names,
self.table_name)
row_count += 1
new_data = databaseOperations.get_single_data(row_count,
self.table_name)
self.user_data = databaseOperations.get_multiple_data(self.table_name)
self.endInsertRows()
return True
def sell_select_addBtn_clicked(self):
if self.ui.sell_select_Table.selectionModel().selectedRows() == None:
return
data = []
data.append(invoice_number_global)
# for i in range (5):
# print(self.ui.sell_select_Table.selectedIndexes()[i].data())
data.append(self.ui.sell_select_Table.selectedIndexes()[1].data())
data.append(self.ui.sell_select_Table.selectedIndexes()[2].data())
if self.ui.sell_select_priceEdit.text() != "":
if float(self.ui.sell_select_priceEdit.text()) >= 0:
data.append(float(self.ui.sell_select_priceEdit.text()))
else:
data.append(-1 * float(self.ui.sell_select_priceEdit.text()))
self.ui.sell_select_priceEdit.setText(
str(-1 * float(self.ui.sell_select_priceEdit.text())))
else:
self.ui.sell_select_priceEdit.setText("0")
data.append(0)
if int(self.ui.sell_select_volEdit.text()
) <= self.ui.sell_select_Table.selectedIndexes()[3].data():
data.append(int(self.ui.sell_select_volEdit.text()))
else:
self.ui.sell_select_volEdit.setText(
str(self.ui.sell_select_Table.selectedIndexes()[3].data()))
data.append(self.ui.sell_select_Table.selectedIndexes()[3].data())
data.append(
float(self.ui.sell_select_priceEdit.text()) *
int(self.ui.sell_select_volEdit.text()))
data.append(self.ui.sell_select_Table.selectedIndexes()[0].data())
data.append(self.ui.sell_select_Table.selectedIndexes()[4].data())
databaseOperations.insert_data(data, [
"invoice_number", "part_name", "vehicle_type", "price", "volume",
"amount", "vendor_name", "cp"
], "Invoice")
self.sell_model = CustomModel.CustomTableModelUserData(
databaseOperations.get_multiple_data_invoice(
invoice_number_global, "Invoice"), [
"id_", "Invoice No.", "Part Name", "Vehicle Type", "Price",
"Volume", "Amount", "Vendor Name", "Cost Price"
], [
"invoice_number", "part_name", "vehicle_type", "price",
"volume", "amount", "vendor_name", "cp"
], "Invoice")
self.ui.sell_Table.setModel(self.sell_model)
self.ui.sell_Table.verticalHeader().setDefaultSectionSize(50)
self.ui.sell_Table.setColumnWidth(0, 30)
self.ui.sell_Table.hideColumn(0)
self.ui.sell_Table.hideColumn(8)
self.ui.sell_Table.setSelectionBehavior(QTableView.SelectRows)
self.ui.sell_Table.horizontalHeader().setSectionResizeMode(
QtWidgets.QHeaderView.Stretch)
databaseOperations.update_existing_stock(data[4], data[6], data[1],
data[2])
self.sell_addBtn_clicked()