def restart_program(self):
total, items = fetch_items()
print(items)
self.clearLayout(self.v_box)
item, value = search_request(self.sample_name)
self.message2.setText("STUDENT NAME: " + str(item))
f = self.message2.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.message2.setFont(f)
def restart_program(self):
total, items = fetch_items()
self.clearLayout(self.v_box)
for item in items:
value = str(item[2])
if int(value) == 0:
value = ''
item = str(item[0]) + ' - ' + str(item[1]) + ' - ' + value + 'x'
self.b3 = QtWidgets.QPushButton(item)
self.b3.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.v_box.addWidget(self.b3)
self.b3.clicked.connect(self.btn_click1)
curr_budget = fetch_budget()
curr_budget = curr_budget[0]
self.message2.setText("Total: " + str(total))
f = self.message2.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.message2.setFont(f)
self.budget_status.setText("Budget: " + str(curr_budget))
f = self.budget_status.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.budget_status.setFont(f)
self.message3 = QtWidgets.QLabel()
self.message3.setText("Budget Remaining: " +
str(curr_budget - total).replace('-', ''))
if total > (curr_budget * 70) / 100:
if total > curr_budget:
status = "You are over budget!"
QtWidgets.QMessageBox.about(self, "Warning!!",
"You are over budget!")
else:
status = "You are close to over budgeting!"
QtWidgets.QMessageBox.about(
self, "Caution!!", "You are close to over budgeting! ")
else:
status = "Still in budget!"
def btn_click3(self):
text = 'Items:\n\n'
total, items = fetch_items()
self.lst = []
self.lst.append(text)
for item in items:
value = str(item[2])
item = str(item[0]) + ' - ' + str(item[1]) + ' - ' + value + 'x'
self.lst.append(item)
text += item + '\n'
text = '\n\nTotal: ' + str(total)
self.lst.append(text)
result = ScrollMessageBox(self.lst, None)
result.exec_()
clear_scan()
update_budget(0)
self.restart_program()
def __init__(self):
super(window, self).__init__()
centwid = QtWidgets.QWidget()
self.mylineEdit = QtWidgets.QLineEdit()
self.mylineEdit2 = QtWidgets.QLineEdit()
self.mylineEdit3 = QtWidgets.QLineEdit()
self.mylineEdit4 = QtWidgets.QLineEdit()
self.mylineEdit5 = QtWidgets.QLineEdit()
self.startNew = 1
#initialise to empty string on start up
self.mylineEdit.setText(' ')
#barcode scans here and then a returnPressed is registered
self.mylineEdit.hide()
self.mylineEdit3.hide()
self.mylineEdit4.hide()
self.mylineEdit5.hide()
total, items = fetch_items()
print(str(total))
message = QtWidgets.QLabel(centwid)
message.setText("Options")
# Create widget
self.label = QtWidgets.QLabel(self)
pixmap = QPixmap('logo.jpg')
self.label.setPixmap(pixmap)
self.title = QtWidgets.QLabel(centwid)
self.title.setText("Student Adding")
self.title.setAlignment(Qt.AlignCenter)
self.title.hide()
self.additem = QtWidgets.QLabel(centwid)
self.additem.setText("RFID Number")
self.additem.hide()
self.entername = QtWidgets.QLabel(centwid)
self.entername.setText("Enter Name")
self.entername.hide()
self.enterprice = QtWidgets.QLabel(centwid)
self.enterprice.setText("ID Number")
self.enterprice.hide()
self.enterquantity = QtWidgets.QLabel(centwid)
self.enterquantity.setText(
"Pre-enrollment Attendance?(Enter 1 if None)")
self.enterquantity.hide()
self.insert_item = QtWidgets.QLabel(centwid)
self.insert_item.setText(" ")
total, items = fetch_items()
item_name = []
prices_ = []
item_values = []
item_barcode = []
items1 = fetch_items1()
for item in items1:
item_name.append(str(item[0]))
prices_.append(str(item[1]))
item_values.append(str(item[2]))
item_barcode.append(str(item[2]))
print(item_name)
print(prices_)
self.tableWidget = QTableWidget()
# set row count
self.tableWidget.setObjectName("tableStudents")
self.tableWidget.setRowCount(len(items1))
# set column count
self.tableWidget.setColumnCount(4)
self.tableWidget.setHorizontalHeaderLabels(
['Name', 'Attendance Count', 'ID', 'RFID'])
pc = int(len(item_name)) - 1
i = 0
while i <= pc:
self.tableWidget.insertRow(i)
self.tableWidget.setItem(i, 0, QTableWidgetItem(item_name[i]))
self.tableWidget.setItem(i, 1, QTableWidgetItem(prices_[i]))
self.tableWidget.setItem(i, 2, QTableWidgetItem(item_values[i]))
self.tableWidget.setItem(i, 3, QTableWidgetItem(item_barcode[i]))
i += 1
self.tableWidget.hide()
self.b3 = QtWidgets.QPushButton('Add Student')
self.b3.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.b3.clicked.connect(self.btn_click1)
self.b4 = QtWidgets.QPushButton('Studentbase')
self.b4.clicked.connect(self.btn_click2)
self.b4.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.b5 = QtWidgets.QPushButton('Export Data')
self.b5.clicked.connect(self.btn_click3)
self.b5.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.submititem = QtWidgets.QPushButton('Submit')
self.submititem.clicked.connect(self.btn_submititem)
self.submititem.hide()
v_box = QtWidgets.QVBoxLayout()
v_box.addWidget(message)
v_box.addWidget(self.b3)
v_box.addWidget(self.b4)
v_box.addWidget(self.b5)
v_box.addStretch()
v_box.addStretch()
v_box.addStretch()
curr_budget = fetch_budget()
curr_budget = curr_budget[0]
v_box1 = QtWidgets.QVBoxLayout()
v_box1.addWidget(self.title)
v_box1.addWidget(self.label)
v_box1.addWidget(self.additem)
v_box1.addWidget(self.mylineEdit)
v_box1.addWidget(self.entername)
v_box1.addWidget(self.mylineEdit5)
v_box1.addWidget(self.enterprice)
v_box1.addWidget(self.mylineEdit3)
v_box1.addWidget(self.enterquantity)
v_box1.addWidget(self.mylineEdit4)
v_box1.addWidget(self.submititem)
v_box1.addWidget(self.insert_item)
v_box1.addWidget(self.tableWidget)
v_box1.addStretch()
lay = QtWidgets.QHBoxLayout()
lay.addLayout(v_box1)
lay.addLayout(v_box)
centwid.setLayout(lay)
self.setCentralWidget(centwid)
self.show()
def __init__(self):
super(window, self).__init__()
centwid = QtWidgets.QWidget()
scroll = QtWidgets.QScrollArea()
self.mylineEdit = QtWidgets.QLineEdit()
f = self.mylineEdit.font()
f.setPointSize(24) # sets the size to 27
self.mylineEdit.setFont(f)
self.mylineEdit2 = QtWidgets.QLineEdit()
self.startNew = 1
#initialise to empty string on start up
self.mylineEdit.setText(' ')
self.toggle = False
#barcode scans here and then a returnPressed is registered
#connect to a function
self.mylineEdit.returnPressed.connect(
self.set_sample_name
) #here is where I want to delete the previous entry without backspacing by hand
self.mylineEdit.textChanged.connect(self.delete_previous)
total, items = fetch_items()
print(str(total))
self.v_box = QtWidgets.QVBoxLayout()
message = QtWidgets.QLabel(centwid)
message.setText("Items Scanned")
f = message.font()
f.setPointSize(7) # sets the size to 27
f.setBold(True)
message.setFont(f)
self.v_box.addWidget(message)
self.v_box.addStretch()
self.v_box.addStretch()
self.v_box.addStretch()
curr_budget = fetch_budget()
curr_budget = curr_budget[0]
self.welcome = QtWidgets.QLabel(centwid)
self.welcome.setText("ENJOY YOUR SHOPPING!")
f = self.welcome.font()
f.setPointSize(24) # sets the size to 27
f.setBold(True)
self.welcome.setFont(f)
self.le = QtWidgets.QLineEdit()
g = self.le.font()
g.setPointSize(24) # sets the size to 27
self.le.setFont(g)
self.budget = QtWidgets.QPushButton('Enter Budget')
self.budget.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.done = QtWidgets.QPushButton('Done Shopping')
self.done.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.budget_status = QtWidgets.QLabel(centwid)
self.budget_status.setText("Budget: " + str(curr_budget))
f = self.budget_status.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.budget_status.setFont(f)
self.message1 = QtWidgets.QLabel(centwid)
self.message1.setText("Scan an item: ")
f = self.message1.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.message1.setFont(f)
self.message2 = QtWidgets.QLabel(centwid)
self.message2.setText("Total: " + str(total))
f = self.message2.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.message2.setFont(f)
self.message3 = QtWidgets.QLabel(centwid)
self.message3.setText("Budget Remaining: " +
str(curr_budget - total).replace('-', ''))
self.message4 = QtWidgets.QLabel(centwid)
self.message4.setText(" ")
self.budget_message = QtWidgets.QLabel(centwid)
if total > (curr_budget * 70) / 100:
if total > curr_budget:
status = "You are over budget!"
QtWidgets.QMessageBox.about(self, "Warning!!",
"You are over budget!")
else:
status = "You are close to over budgeting!"
QtWidgets.QMessageBox.about(
self, "Caution!!", "You are close to over budgeting!")
else:
status = "Still in budget!"
self.budget_message.setText("Budget Status: " + str(status))
f = self.budget_message.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.budget_message.setFont(f)
self.v_box1 = QtWidgets.QVBoxLayout()
self.v_box1.addWidget(self.welcome)
self.v_box1.addWidget(self.le)
self.v_box1.addWidget(self.budget)
self.v_box1.addWidget(self.budget_message)
self.v_box1.addWidget(self.budget_status)
self.v_box1.addStretch()
self.v_box1.addWidget(self.message1)
self.v_box1.addWidget(self.message2)
self.v_box1.addWidget(self.message3)
self.v_box1.addWidget(self.mylineEdit)
self.v_box1.addWidget(self.done)
self.v_box1.addStretch()
self.v_box1.addStretch()
lay = QtWidgets.QHBoxLayout()
lay.addLayout(self.v_box1)
lay.addLayout(self.v_box)
centwid.setLayout(lay)
self.budget.clicked.connect(self.btn_click)
self.done.clicked.connect(self.btn_click3)
scroll.setWidget(centwid)
scroll.setWidgetResizable(True)
self.setCentralWidget(scroll)
self.show()
def __init__(self):
super(window, self).__init__()
centwid = QtWidgets.QWidget()
self.mylineEdit = QtWidgets.QLineEdit()
f = self.mylineEdit.font()
f.setPointSize(24) # sets the size to 27
self.mylineEdit.setFont(f)
self.mylineEdit2 = QtWidgets.QLineEdit()
self.startNew = 1
#initialise to empty string on start up
self.mylineEdit.setText(' ')
self.toggle = False
#barcode scans here and then a returnPressed is registered
#connect to a function
self.mylineEdit.returnPressed.connect(
self.set_sample_name
) #here is where I want to delete the previous entry without backspacing by hand
self.mylineEdit.textChanged.connect(self.delete_previous)
total, items = fetch_items()
print(str(total))
self.v_box = QtWidgets.QVBoxLayout()
message = QtWidgets.QLabel(centwid)
f = message.font()
f.setPointSize(7) # sets the size to 27
f.setBold(True)
message.setFont(f)
self.v_box.addWidget(message)
self.v_box.addStretch()
self.v_box.addStretch()
self.v_box.addStretch()
curr_budget = fetch_budget()
curr_budget = curr_budget[0]
self.welcome = QtWidgets.QLabel(centwid)
self.welcome.setText("CCS ATTENDANCE")
f = self.welcome.font()
f.setPointSize(24) # sets the size to 27
f.setBold(True)
self.welcome.setFont(f)
self.le = QtWidgets.QLineEdit()
g = self.le.font()
g.setPointSize(24) # sets the size to 27
self.le.setFont(g)
self.budget = QtWidgets.QPushButton('Create/Update Event')
self.budget.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.done = QtWidgets.QPushButton('Exit')
self.done.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.budget_status = QtWidgets.QLabel(centwid)
self.budget_status.setText("EVENT: ")
f = self.budget_status.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.budget_status.setFont(f)
self.message1 = QtWidgets.QLabel(centwid)
self.message1.setText("ID NUMBER: ")
f = self.message1.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.message1.setFont(f)
self.message2 = QtWidgets.QLabel(centwid)
self.message2.setText("STUDENT NAME: ")
f = self.message2.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.message2.setFont(f)
self.date = datetime.datetime.now().strftime("%Y-%m-%d %H:%M")
self.message3 = QtWidgets.QLabel(centwid)
self.message3.setText(" ")
self.message4 = QtWidgets.QLabel(centwid)
self.message4.setText("DATE: " + str(self.date))
f = self.message4.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.message4.setFont(f)
self.budget_message = QtWidgets.QLabel(centwid)
# self.budget_message.setText("Budget Status: " + str(status))
f = self.budget_message.font()
f.setPointSize(10) # sets the size to 27
f.setBold(True)
self.budget_message.setFont(f)
self.v_box1 = QtWidgets.QVBoxLayout()
# Create widget
self.label = QtWidgets.QLabel(self)
pixmap = QPixmap('logo.jpg')
self.label.setPixmap(pixmap)
self.v_box1.addWidget(self.welcome)
self.v_box1.addWidget(self.label)
self.v_box1.addWidget(self.le)
self.v_box1.addWidget(self.budget)
# # self.v_box1.addWidget(self.budget_message)
self.v_box1.addWidget(self.message4)
self.v_box1.addWidget(self.budget_status)
self.v_box1.addWidget(self.message1)
self.v_box1.addWidget(self.message2)
self.v_box1.addWidget(self.mylineEdit)
self.v_box1.addWidget(self.message3)
self.v_box1.addWidget(self.done)
self.v_box1.addStretch()
self.v_box1.addStretch()
lay = QtWidgets.QHBoxLayout()
lay.addLayout(self.v_box1)
lay.addLayout(self.v_box)
centwid.setLayout(lay)
self.budget.clicked.connect(self.btn_click)
self.done.clicked.connect(self.btn_click3)
self.setCentralWidget(centwid)
self.show()
def __init__(self):
super(window, self).__init__()
centwid = QtWidgets.QWidget()
self.mylineEdit = QtWidgets.QLineEdit()
self.mylineEdit2 = QtWidgets.QLineEdit()
self.mylineEdit3 = QtWidgets.QLineEdit()
self.mylineEdit4 = QtWidgets.QLineEdit()
self.mylineEdit5 = QtWidgets.QLineEdit()
self.startNew = 1
#initialise to empty string on start up
self.mylineEdit.setText(' ')
#barcode scans here and then a returnPressed is registered
self.mylineEdit.hide()
self.mylineEdit3.hide()
self.mylineEdit4.hide()
self.mylineEdit5.hide()
total, items = fetch_items()
print(str(total))
message = QtWidgets.QLabel(centwid)
message.setText("Options")
self.title = QtWidgets.QLabel(centwid)
self.title.setText("Products Adding")
self.title.setAlignment(Qt.AlignCenter)
self.title.hide()
self.additem = QtWidgets.QLabel(centwid)
self.additem.setText("Scan Number")
self.additem.hide()
self.entername = QtWidgets.QLabel(centwid)
self.entername.setText("Enter Name")
self.entername.hide()
self.enterprice = QtWidgets.QLabel(centwid)
self.enterprice.setText("Enter Price")
self.enterprice.hide()
self.enterquantity = QtWidgets.QLabel(centwid)
self.enterquantity.setText("Enter Quantity")
self.enterquantity.hide()
self.insert_item = QtWidgets.QLabel(centwid)
self.insert_item.setText(" ")
total, items = fetch_items()
item_name = []
prices_ = []
item_values = []
item_barcode = []
items1 = fetch_items1()
for item in items1:
item_name.append(str(item[0]))
prices_.append(str(item[1]))
item_values.append(str(item[2]))
item_barcode.append(str(item[2]))
print(item_name)
print(prices_)
self.tableWidget = QTableWidget()
# set row count
self.tableWidget.setRowCount(len(items1))
# set column count
self.tableWidget.setColumnCount(4)
pc = int(len(item_name)) - 1
i = 0
while i <= pc:
self.tableWidget.insertRow(i)
self.tableWidget.setItem(i, 0, QTableWidgetItem(item_name[i]))
self.tableWidget.setItem(i, 1, QTableWidgetItem(prices_[i]))
self.tableWidget.setItem(i, 2, QTableWidgetItem(item_values[i]))
self.tableWidget.setItem(i, 3, QTableWidgetItem(item_barcode[i]))
i += 1
self.tableWidget.hide()
self.b3 = QtWidgets.QPushButton('Add Item')
self.b3.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.b3.clicked.connect(self.btn_click1)
self.b4 = QtWidgets.QPushButton('Inventory')
self.b4.clicked.connect(self.btn_click2)
self.b4.setSizePolicy(QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Expanding)
self.submititem = QtWidgets.QPushButton('Submit')
self.submititem.clicked.connect(self.btn_submititem)
self.submititem.hide()
v_box = QtWidgets.QVBoxLayout()
v_box.addWidget(message)
v_box.addWidget(self.b3)
v_box.addWidget(self.b4)
v_box.addStretch()
v_box.addStretch()
v_box.addStretch()
curr_budget = fetch_budget()
curr_budget = curr_budget[0]
v_box1 = QtWidgets.QVBoxLayout()
v_box1.addWidget(self.title)
v_box1.addWidget(self.additem)
v_box1.addWidget(self.mylineEdit)
v_box1.addWidget(self.entername)
v_box1.addWidget(self.mylineEdit5)
v_box1.addWidget(self.enterprice)
v_box1.addWidget(self.mylineEdit3)
v_box1.addWidget(self.enterquantity)
v_box1.addWidget(self.mylineEdit4)
v_box1.addWidget(self.submititem)
v_box1.addWidget(self.insert_item)
v_box1.addWidget(self.tableWidget)
v_box1.addStretch()
lay = QtWidgets.QHBoxLayout()
lay.addLayout(v_box1)
lay.addLayout(v_box)
centwid.setLayout(lay)
self.setCentralWidget(centwid)
self.show()