class ViewIssuedBooks(QWidget):
session=Session()
def __init__(self,id):
super().__init__()
self.id=id
self.title="Admin Panel"
self.width = 640
self.height = 400
self.top = 100
self.left = 100
self.initUI()
def initUI(self):
self.createTable()
self.setWindowTitle(self.title)
self.setGeometry(self.left, self.top, self.width, self.height)
self.layout=QVBoxLayout()
self.layout.addWidget(self.tableWidget)
self.setLayout(self.layout)
self.show()
def createTable(self):
# Create table
self.tableWidget = QTableWidget()
self.populateTable(self.tableWidget)
self.tableWidget.move(0,0)
# table selection change
#self.tableWidget.doubleClicked.connect(self.on_click)
def populateTable(self,table):
issue=self.session.query(Issue).filter(Issue.issued_to==self.id).all()
try:
table.setRowCount(len(issue)+1)
self.tableWidget.setColumnCount(3)
self.tableWidget.setItem(0,0, QTableWidgetItem("Id"))
self.tableWidget.setItem(0,1, QTableWidgetItem("Book"))
self.tableWidget.setItem(0,2, QTableWidgetItem("Author"))
for i in range(len(issue)):
table.setItem(i+1,0,QTableWidgetItem(str(issue[i].id)))
table.setItem(i+1,1,QTableWidgetItem(issue[i].book.name))
table.setItem(i+1,2,QTableWidgetItem(issue[i].book.author))
except:
print("An error has occured")
class Game(QWidget):
def __init__(self):
super().__init__()
self._flag_1 = False
self.media = QtCore.QUrl.fromLocalFile("MP3/music.mp3")
content = QtMultimedia.QMediaContent(self.media)
self.player = QtMultimedia.QMediaPlayer()
self.player.setMedia(content)
self.player.setVolume(50)
self.initUI()
def initUI(self):
self.file_number = 2
self._score = 0
self.setMouseTracking(True)
self.resize(500, 500)
self.center()
self.setWindowTitle('Игра')
self.main_pic = QLabel(self)
self.main_pic.setPixmap(
QPixmap(resource_path("PIC/running_rabbit.jpg")))
self.main_pic.resize(500, 500)
self.button_start_game = QPushButton("НАЧАТЬ ИГРУ", self)
self.button_start_game.resize(140, 50)
self.button_start_game.move(70, 300)
self.button_start_game.clicked.connect(self.start_game)
self.button_edit_map = QPushButton("СОЗДАТЬ КАРТУ", self)
self.button_edit_map.resize(140, 50)
self.button_edit_map.move(70, 360)
self.button_edit_map.clicked.connect(self.edit_map_menu)
self.button_exit = QPushButton("ЗАКОНЧИТЬ СЕАНС", self)
self.button_exit.resize(140, 50)
self.button_exit.move(70, 420)
self.button_exit.clicked.connect(self.exit)
self.timer_game = QTimer()
self.timer_game.timeout.connect(self.updateValues)
self.timer_game.start(200)
self.setFocusPolicy(Qt.StrongFocus)
self.lable_score = QLabel(self)
self.lable_score.resize(200, 35)
self.lable_score.setFont(
QFont("RetroComputer[RUS by Daymarius]", 26, QFont.Bold))
self.lable_score.setVisible(False)
self.button_menu = QPushButton("НАЗАД", self)
self.button_menu.resize(120, 40)
self.button_menu.clicked.connect(self.show_menu)
self.button_menu.setVisible(False)
self.lable_name = QLabel("ВВЕДИТЕ ВАШЕ ИМЯ:", self)
self.lable_name.sizeHint()
self.lable_name.setFont(
QFont("RetroComputer[RUS by Daymarius]", 10, QFont.Bold))
self.lable_name.move(230, 300)
self.input_name = QLineEdit("Без имени", self)
self.input_name.resize(200, 20)
self.input_name.move(230, 325)
self.table_score = QTableWidget(self)
self.table_score.resize(200, 120)
self.table_score.move(230, 350)
def bd_score(self):
con = sqlite3.connect(resource_path("DB/score.db"))
# Создание курсора
cur = con.cursor()
# Выполнение запроса и получение всех результатов
result = cur.execute(
"SELECT * FROM main ORDER BY score DESC;").fetchmany(5)
cur.execute("DROP TABLE main")
cur.execute("CREATE TABLE main (name STRING, score INTEGER)")
for item in result:
cur.execute("INSERT INTO main VALUES(?, ?)", (item[0], item[1]))
con.commit()
# Вывод результатов на экран
if result != []:
self.table_score.setColumnCount(len(result[0]))
self.table_score.setRowCount(0)
for i, row in enumerate(result):
self.table_score.setRowCount(self.table_score.rowCount() + 1)
for j, elem in enumerate(row):
item = QTableWidgetItem(str(elem))
self.table_score.setItem(i, j, item)
item.setFlags(QtCore.Qt.ItemIsEnabled)
self.table_score.setHorizontalHeaderItem(
0, QTableWidgetItem("Имя игрока"))
self.table_score.setHorizontalHeaderItem(1,
QTableWidgetItem("Счет"))
self.table_score.setColumnWidth(0, 127)
self.table_score.setColumnWidth(1, 20)
con.close()
def append_bd_score_and_name(self):
con = sqlite3.connect("DB/score.db")
# Создание курсора
cur = con.cursor()
cur.execute("INSERT INTO main VALUES(?, ?)",
(self.input_name.text(), self.get_score()))
con.commit()
self.bd_score()
con.close()
def get_score(self):
return self._score
def set_score(self, score):
self._score = score
def keyPressEvent(self, event):
if event.key() == Qt.Key_Right:
self.hero.go_right()
elif event.key() == Qt.Key_Left:
self.hero.go_left()
elif event.key() == Qt.Key_Up:
self.hero.go_up()
elif event.key() == Qt.Key_Down:
self.hero.go_down()
elif event.key() == Qt.Key_Space:
self.hero.go_dig()
def keyReleaseEvent(self, QKeyEvent):
if self._flag_1 and not QKeyEvent.isAutoRepeat():
self.hero.stop()
def edit_map_menu(self):
game.setVisible(False)
edit_map.create_map()
edit_map.show()
def exit(self):
sys.exit(app.exec())
def center(self):
qr = self.frameGeometry()
cp = QDesktopWidget().availableGeometry().center()
qr.moveCenter(cp)
self.move(qr.topLeft())
def reload_game(self):
score = self.get_score()
lifes = self.hero.get_lifes()
self.start_game()
self.set_score(score)
self.hero.set_lifes(lifes)
def start_game(self):
self.player.play()
self.set_score(0)
self.map = Map(resource_path("MAP/" + str(self.file_number) + ".map"))
for enemy in self.enemies:
enemy.create_labirint()
self.button_menu.setVisible(True)
self.button_menu.setFocusPolicy(False)
self.lable_score.setVisible(True)
self.lable_score.move(0, 0)
self.button_menu.move(self.map.get_col() * 40 - 120, 0)
self.lable_score.setText("00000")
sp_0_1 = []
for j in range(self.map.get_row()):
for i in range(self.map.get_col()):
if type(self.map.get_elem_xy(i, j)) == Empty and (
self.map.get_row() - 1 == j
or type(self.map.get_elem_xy(
i, j + 1)) in [Stairs, Brick]):
sp_0_1.append((i, j))
zerro = Zerro()
one = One()
for i in range(int(round(len(sp_0_1) * 0.2))):
t = randrange(0, len(sp_0_1))
x, y = sp_0_1[t]
self.map.set_elem_xy(x, y, choice([zerro, one]))
del sp_0_1[t]
self.hide_menu()
def show_menu(self):
self.append_bd_score_and_name()
game.player.pause()
self.hero.timer.stop()
for enemy in self.enemies:
enemy.timer.stop()
self.timer_game.stop()
self.main_pic.show()
self.table_score.show()
self.input_name.show()
self.lable_name.show()
self.button_menu.setVisible(False)
self.lable_score.setVisible(False)
self.button_edit_map.setVisible(True)
self.button_exit.setVisible(True)
self.button_start_game.setVisible(True)
self.resize(500, 500)
self.center()
self._flag_1 = False
def hide_menu(self):
game.player.play()
self.hero.timer.start(200)
for enemy in self.enemies:
enemy.timer.start(200)
game.timer_game.start(200)
self.main_pic.hide()
self.table_score.hide()
self.input_name.hide()
self.lable_name.hide()
self.button_menu.setVisible(True)
self.lable_score.setVisible(True)
self.button_edit_map.setVisible(False)
self.button_exit.setVisible(False)
self.button_start_game.setVisible(False)
self.resize(self.map.get_col() * 40, self.map.get_row() * 40 + 40)
self.center()
self._flag_1 = True
def paintEvent(self, event):
qp = QPainter()
qp.begin(self)
if self._flag_1:
for i in range(self.map.get_col()):
for j in range(self.map.get_row()):
qp.drawPixmap(
i * 40, j * 40 + 40,
self.map.get_elem_xy(
i, j).get_pic()) # рисуем картинками из elem_map
qp.drawPixmap(self.hero.get_x() * 40,
self.hero.get_y() * 40 + 40, self.hero.get_pic())
for enemy in self.enemies:
qp.drawPixmap(enemy.get_x() * 40,
enemy.get_y() * 40 + 40, enemy.get_pic())
for i in range(game.hero.get_lifes()):
qp.drawPixmap(280 + i * 40, 0,
self.hero._pic[self.hero._STOP][0])
txt = "00000" + str(self._score)
self.lable_score.setText(txt[len(txt) - 5:len(txt)])
qp.end()
def updateValues(self):
self.update()
def you_lose(self):
self.player.pause()
self.hero.timer.stop()
for enemy in self.enemies:
enemy.timer.stop()
self.timer_game.stop()
if self.hero.get_lifes() > 1:
game.player.pause()
buttonReply = QMessageBox.question(
self, 'ВЫ ПРОИГРАЛИ', "Продолжить игру?",
QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes)
if buttonReply == QMessageBox.Yes:
self.hero.set_lifes(self.hero.get_lifes() - 1)
self.reload_game()
self.timer_game.start(200)
else:
self.set_score(0)
self.show_menu()
else:
game.player.pause()
buttonReply = QMessageBox.information(self, 'ИГРА ОКОНЧЕНА',
"Вы проиграли.")
self.append_bd_score_and_name()
self.show_menu()
