def get_personalData(self,iduser):
read='SELECT * FROM users WHERE id_user = {}'.format(iduser)
cursor.execute(read)
a = cursor.fetchall()
self.temporary_data = a
table = PrettyTable(['id','name', 'username', 'password', ' gender', ' contact', 'address', 'role id'])
table.add_rows(a)
return table
def set_role(self):
read = '''
SELECT role_id FROM `users` WHERE username = %s && password = %s
'''
val = (self.username, self.password)
cursor.execute(read, val)
for data in cursor.fetchall():
self.role = data[0]
def get_schedules_all(self):
read = 'SELECT schedules.id_schedule, movies.title, schedules.date_schedule, schedules.start, schedules.end, studios.studio_name FROM schedules INNER JOIN movies ON schedules.film_code = movies.code_film INNER JOIN studios ON schedules.id_studio = studios.id_studio'
cursor.execute(read)
fetch = cursor.fetchall()
for data in fetch:
self.temporary_data.append(data)
table = PrettyTable(['ID Jadwal', 'Nama Film', 'Tanggal Film', 'Mulai', 'Selesai', 'Studio'])
table.add_rows(fetch)
return table
def get_topping_data(self):
self.temporary_data = []
read='SELECT * FROM toppings'
cursor.execute(read)
a = cursor.fetchall()
self.temporary_data = a
table= PrettyTable(['id', 'nama topping', 'harga'])
table.add_rows(a)
return table
def get_schedules_data(self):
read='SELECT * FROM schedules'
cursor.execute(read)
a = cursor.fetchall()
for data in a:
self.temporary_data.append(data)
table= PrettyTable(['id', 'date', 'start', 'ends', 'movie', 'studio'])
table.add_rows(a)
return table
def get_movies_data(self):
read='SELECT * FROM movies'
cursor.execute(read)
a = cursor.fetchall()
for data in a:
self.temporary_data.append(data)
table = PrettyTable(['id', 'title', 'genre', 'company'])
table.add_rows(a)
return table
def get_chairs_data(self):
read='SELECT * FROM chairs'
cursor.execute(read)
a = cursor.fetchall()
for data in a:
self.temporary_data.append(data)
table = PrettyTable(['id','number','status'])
table.add_rows(a)
return table
def get_companies_data(self):
read='SELECT * FROM companies'
cursor.execute(read)
a = cursor.fetchall()
for data in a:
self.temporary_data.append(data)
table = PrettyTable(['id','company name','address'])
table.add_rows(a)
return table
def get_users_data(self):
read='SELECT * FROM users'
cursor.execute(read)
a = cursor.fetchall()
for data in a:
self.temporary_data.append(data)
table = PrettyTable(['id','name', 'username', 'password', ' gender', ' contact', 'address', 'role id'])
table.add_rows(a)
return table
def get_roles_data(self):
read='SELECT * FROM user_roles'
cursor.execute(read)
a = cursor.fetchall()
for data in a:
self.temporary_data.append(data)
table = PrettyTable(['id','nama roles'])
table.add_rows(a)
return table
def get_studio_data(self):
read='SELECT * FROM studios'
cursor.execute(read)
a = cursor.fetchall()
for data in a:
self.temporary_data.append(data)
table= PrettyTable(['id', 'studio', 'description'])
table.add_rows(a)
return table
def get_user_balances(self):
read = 'SELECT user_balances.id_balance, users.name, user_balances.amount FROM user_balances INNER JOIN users ON user_balances.id_user = users.id_user'
cursor.execute(read)
fetch = cursor.fetchall()
for data in fetch:
self.temporary_data.append(data)
table = PrettyTable(['ID User Saldo', 'Nama', 'Saldo'])
table.add_rows(fetch)
return table
def get_ticket_done(self):
read = 'SELECT transactions.code_transaction, transactions.order_date, users.username, users.name, transactions.ticket_code, tickets.chair_id, transactions.topping_id, movies.title, schedules.date_schedule, schedules.start, schedules.end FROM transactions INNER JOIN users ON transactions.customer_id = users.id_user INNER JOIN tickets ON transactions.ticket_code = tickets.code_ticket INNER JOIN schedules ON transactions.schedule_id = schedules.id_schedule INNER JOIN movies ON schedules.film_code = movies.code_film WHERE transactions.operator_id != 0'
cursor.execute(read)
fetch = cursor.fetchall()
for data in fetch:
self.temporary_data.append(data)
table = PrettyTable(['Kode Transaksi', 'Tanggal Order', 'Username', 'Nama', 'Kode Tiket', 'Kode Kursi', 'ID Topping', 'Judul Film', 'Tanggal Film', 'Mulai', 'Selesai'])
table.add_rows(fetch)
return table
def get_user_balances_spec(self, thisAmount):
spec = thisAmount
read = 'SELECT amount FROM user_balances WHERE id_balance = %s'
cursor.execute(read, (spec, ))
fetch = cursor.fetchall()
for data in fetch:
self.temporary_data.append(data)
table = PrettyTable(['amount'])
table.add_rows(fetch)
return table
def get_chairs_free(self, thisStudio):
thisStudios = thisStudio
read = 'SELECT chairs.id_chair, chairs.chair_number, studios.studio_name FROM chairs INNER JOIN studios ON chairs.studio_id = studios.id_studio WHERE chairs.status = 0 AND studios.studio_name = %s'
cursor.execute(read, (thisStudios, ))
fetch = cursor.fetchall()
for data in fetch:
self.temporary_data.append(data)
table = PrettyTable(['ID Kursi', 'Nomor Kursi', 'Nama Studio'])
table.add_rows(fetch)
return table
def get_schedules_today(self):
dateNow = date.today().strftime("%Y/%m/%d")
sendDate = (dateNow,)
read = 'SELECT schedules.id_schedule, movies.title, schedules.date_schedule, schedules.start, schedules.end, studios.studio_name FROM schedules INNER JOIN movies ON schedules.film_code = movies.code_film INNER JOIN studios ON schedules.id_studio = studios.id_studio WHERE schedules.date_schedule = %s'
cursor.execute(read, sendDate)
fetch = cursor.fetchall()
for data in fetch:
self.temporary_data.append(data)
table = PrettyTable(['ID Jadwal', 'Nama Film', 'Tanggal Film', 'Mulai', 'Selesai', 'Studio'])
table.add_rows(fetch)
return table
def add_user(self):
ulang = True
#memasukan nama
name = input('masukan nama : ')
#memasukan email
username = input('masukan username : '******'masukan password : '******'masukan password sekali lagi : ')
if password == password_confirm:
ulang = False
self.temp_variable2 = password
ulang = True
#memasukan gender
while ulang == True:
gender = input('masukan gender (L/P) : ').upper()
if gender == 'L' or gender == 'P':
ulang = False
else:
print('masukan sesuai format')
#memasukan kontak
contact = input('masukan kontak : ')
#memasukan alamat
alamat = input('masukan alamat : ')
#masukan role
read = 'SELECT * FROM user_roles'
cursor.execute(read)
print('id\tnama roles')
for data in cursor.fetchall():
print('{}\t{}'.format(data[0], data[1]))
role_id = int(input('masukan role id : '))
sql = '''
INSERT INTO users (id_user, name, username, password, gender, contact, address, role_id) VALUES (NULL, %s, %s, %s, %s, %s, %s, %s)
'''
val = (name, username, password, gender, contact, alamat, role_id)
sqlQuery = (sql, val)
return sqlQuery
