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_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_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_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_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_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_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_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_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_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 topUp(self):
n = int(input('masukan jumlah saldo yang ingin anda tambahkan : '))
self.user_balance += n
sql = 'UPDATE user_balances SET amount = %s WHERE id_user = %s'
v = (
self.user_balance,
self.user_id,
)
cursor.execute(sql, v)
mConnection.db.commit()
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 initiate_userBalance(self):
read = 'SELECT id_user FROM users WHERE username = %s AND password = %s'
v = (self.temp_variable1, self.temp_variable2)
cursor.execute(read, v)
a = cursor.fetchone()
iduser = a[0]
sql = 'INSERT INTO user_balances (id_balance, id_user, amount) VALUES (NULL, %s, 0)'
v = (iduser, )
cursor.execute(sql, v)
mConnection.db.commit()
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_amount(self, balances):
print(balances)
idBalance = int(input("Masukkan ID saldo yang ingin ditambahkan : "))
banyakSaldo = int(
input("Masukkan total saldo yang ingin ditambahkan : "))
read = 'SELECT amount FROM user_balances WHERE id_balance =%s'
v = (idBalance, )
cursor.execute(read, v)
a = cursor.fetchone()
self.user_balance = a[0]
total = self.user_balance + banyakSaldo
sql = 'UPDATE user_balances SET amount = %s WHERE id_balance = %s'
v = (
total,
idBalance,
)
execute = (sql, v)
return execute
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
def ubahData(self, ubah, konfirm):
inputan = None
if ubah == 'password':
konfirmator = input('masukan password lama : ')
if konfirmator == konfirm:
inputan = input('masukan password baru : ')
else:
print('\npassword yang anda masukan salah')
else:
inputan = input('masukan ' + ubah + ' baru yang anda inginkan :')
if inputan != None:
sql = 'UPDATE users SET {} = %s WHERE id_user = %s'.format(ubah)
val = (
inputan,
self.user_id,
)
cursor.execute(sql, val)
mConnection.db.commit()
print('\n berhasil mengubah data')
else:
print('\nanda belum melakukan input data')
def set_userBalance(self):
read = 'SELECT amount FROM user_balances WHERE id_user =%s'
v = (self.user_id, )
cursor.execute(read, v)
a = cursor.fetchone()
self.user_balance = a[0]
def boking(self, schedule_now):
hargaTotal = 40000
print(schedule_now)
getStudio = ''
kodeTransact = mRandomCode.randomTransaction(5)
kodeTicket = mRandomCode.randomTransaction(5)
dateNow = date.today().strftime("%d/%m/%Y")
toppingID = 0
permit = modelPermission.permission(0)
toping = modelPermission.permission(0)
print("Kode Transaksi\t : TR-", kodeTransact)
print("Kode Tiket\t : TK-", kodeTicket)
print("Tanggal Order\t :", dateNow)
print("ID Customer\t :", cusLog[0])
print("Nama Customer\t :", cusLog[1])
scheduleID = int(input("Masukkan ID Jadwal : "))
for i in range(len(permit.temporary_data)):
for getStudd in permit.temporary_data[i]:
if (scheduleID in permit.temporary_data[i]):
getStudio = permit.temporary_data[i][5]
print(toping.get_topping_data())
toppingID = int(input("Masukkan ID Topping :"))
topping_harga = toping.temporary_data[0][2]
print(topping_harga)
hargaTotal += int(topping_harga)
print(hargaTotal)
print(permit.get_chairs_free(getStudio))
chairID = int(input("Masukkan ID Pilihan Kursi :"))
#konfirmasi pembelian
konfirmasiPembelian = input(
'apakah anda yakin ingin melanjutkan proses transaksi (y/n) : '
).upper()
if konfirmasiPembelian == 'Y':
if self.user_balance < hargaTotal:
print('saldo user tidak mencukupi untuk melakukan transaksi')
else:
#=============================================================
self.user_balance -= hargaTotal
sql = 'UPDATE user_balances SET amount = %s WHERE id_user = %s'
v = (
self.user_balance,
self.user_id,
)
cursor.execute(sql, v)
mConnection.db.commit()
# ============================================================
cmdInsert = '''INSERT INTO transactions (code_transaction, order_date, operator_id, customer_id, ticket_code, topping_id, schedule_id) VALUES (%s, NOW(), %s, %s, %s, %s, %s)'''
valInsert = (kodeTransact, '', cusLog[0], kodeTicket,
toppingID, scheduleID)
cursor.execute(cmdInsert, valInsert)
mConnection.db.commit()
# ============================================================
cmdInserts = '''INSERT INTO tickets (code_ticket, chair_id, price) VALUES (%s,%s,%s)'''
valInserts = (kodeTicket, chairID, hargaTotal)
cursor.execute(cmdInserts, valInserts)
mConnection.db.commit()
# ============================================================
cmdUpdate = '''UPDATE chairs SET status = 1 WHERE id_chair = %s'''
valUpdate = (chairID, )
executed = (cmdUpdate, valUpdate)
kodeTransact = mRandomCode.randomTransaction(10)
kodeTicket = mRandomCode.randomTransaction(10)
return executed
elif konfirmasiPembelian == 'N':
print('transaksi dibatalkan')
def set_userID(self):
read = 'SELECT id_user FROM users WHERE username = %s AND password = %s'
v = (self.username, self.password)
cursor.execute(read, v)
a = cursor.fetchone()
self.user_id = a[0]
