def retrieve(self, obj):
model = mUser.mUser()
datenya = datetime.datetime.today() + datetime.timedelta(30)
data = model.getData("stnk", "where masa_berlaku < '%s'" % datenya)
msg = QtWidgets.QMessageBox()
if len(data) > 0:
hps = QMessageBox.question(
self, 'Message', "Terdapat STNK yang akan expired. \n Lihat?",
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if (hps == QMessageBox.Yes):
self.menuListExpired()
def retrieve(self, obj):
self.idRole = obj.value
model = mUser.mUser()
data = model.getData("setup_role", "WHERE id_role = %s" % (obj.value))
key_data = list(data.keys())
#print(key_data)
len_data = len(data[key_data[0]])
data_return = []
for row in range(len_data):
print(data["nama_role"][row])
self.namaRole.setText(data["nama_role"][row])
def hapusData(self, obj):
model = mUser.mUser()
data = model.deleteData("log_user", "WHERE id_log = %s" % (obj.value))
msg = QMessageBox()
if (data):
msg.about(obj, "Success", "Berhasil Menghapus Data")
else:
msg.about(obj, "Fail", "Gagal Menghapus Data")
dash = Loguser.logUserUI(obj)
obj.hide()
dash.show()
def load_data(self):
model = mUser()
data = model.getData("log_user", "ORDER BY tanggal_login")
key_data = list(data.keys())
len_data = len(data[key_data[0]])
data_return = []
for row in range(len_data):
for col in range(len(key_data)):
value = QTableWidgetItem(str(data[key_data[col]][row]))
data_return.append((row, col, value))
return data_return
def retrieve(self, obj):
self.id_stnk = obj.value
model= mUser.mUser()
data = model.getData("stnk", "WHERE id_stnk = %s"%(obj.value))
key_data = list(data.keys())
#print(key_data)
len_data = len(data[key_data[0]])
data_return = []
for row in range(len_data):
self.nomorRegis.setText(data["nomor_registrasi"][row])
self.namaPemilik.setText(data["nama_pemilik"][row])
self.masaBerlaku.setText(data["masa_berlaku"][row].strftime('%Y-%m-%d'))
def hapusData(self, obj):
model = mUser.mUser()
data = model.deleteData("stnk", "WHERE id_stnk = %s" % (obj.value))
msg = QMessageBox()
if (data):
msg.about(obj, "Success", "Berhasil Menghapus Data")
else:
msg.about(obj, "Fail", "Gagal Menghapus Data")
dash = ListSTNK.listStnkUI(obj)
obj.hide()
dash.show()
def load_data(self):
model = mUser()
datenya = datetime.datetime.today() + datetime.timedelta(30)
data = model.getData("stnk", "where masa_berlaku < '%s'" % datenya)
key_data = list(data.keys())
len_data = len(data[key_data[0]])
data_return = []
for row in range(len_data):
for col in range(len(key_data)):
value = QTableWidgetItem(str(data[key_data[col]][row]))
data_return.append((row, col, value))
return data_return
def update(self, obj):
model = mUser.mUser()
nama_role = obj.namaRole.text()
id_role = obj.idRole
data = [id_role, nama_role, id_role]
res = model.updateRoleData('setup_role', data)
msg = QMessageBox()
if (res):
msg.about(obj, "Success", "Berhasil Menginput Data")
else:
msg.about(obj, "Fail", "Gagal Menginput Data")
print(res)
ui = ListRole.listRoleUI(obj)
obj.hide()
ui.show()
def buatAdmin(self, obj=None):
role = obj.namaRole.text()
data = role
print(data)
model = mUser.mUser()
res = model.insertUserData('setup_role',data)
msg = QMessageBox()
if(res):
msg.about(obj, "Success", "Berhasil Menginput Data")
else:
msg.about(obj, "Fail", "Gagal Menginput Data")
print(res)
ui = dashboard.dashboardUI(obj)
obj.hide()
ui.show()
def getDataRole(self):
model = mUser.mUser()
data = model.getData("setup_role", "ORDER BY id_role")
key_data = list(data.keys())
#print(key_data)
len_data = len(data[key_data[0]])
data_return = []
for row in range(len_data):
nama = str(data["nama_role"][row])
value = str(data["id_role"][row])
#print(value)
data_return.append((nama, value))
return data_return
def simpanData(self, obj):
model = mUser.mUser()
nomor = obj.nomorRegis.text()
nama = obj.namaPemilik.text()
masa = obj.masaBerlaku.text()
data = ['', nomor, nama, masa]
res = model.insertStnkData(data)
msg = QMessageBox()
if (res):
msg.about(obj, "Success", "Berhasil Menginput Data")
else:
msg.about(obj, "Fail", "Gagal Menginput Data")
#print(res)
ui = dashboard.dashboardUI(obj)
obj.hide()
ui.show()
def retrieve(self, obj):
self.idUser = obj.value
model = mUser.mUser()
data = model.getData("setup_admin",
"WHERE id_admin = %s" % (obj.value))
key_data = list(data.keys())
#print(key_data)
len_data = len(data[key_data[0]])
data_return = []
for row in range(len_data):
print(data["nama_pengguna"][row])
self.namaPengguna.setText(data["nama_pengguna"][row])
self.namaLengkap.setText(data["nama_lengkap"][row])
self.kataSandi.setText(data["kata_sandi"][row])
index = self.combo.findData(int(data["id_role"][row]))
print(index)
if (index != -1):
self.combo.setCurrentIndex(index)
def insert(self,obj):
model= mUser.mUser()
index = obj.combo.currentIndex()
role = obj.combo.itemData(index)
user = obj.namaPengguna.text()
nama = obj.namaLengkap.text()
sandi = obj.kataSandi.text()
data = ['',role,user,sandi,nama,1,'2020-04-03']
res = model.insertAdminData('setup_admin',data)
msg = QMessageBox()
if(res):
msg.about(obj, "Success", "Berhasil Menginput Data")
else:
msg.about(obj, "Fail", "Gagal Menginput Data")
print(res)
ui = dashboard.dashboardUI(obj)
obj.hide()
ui.show()
def update(self, obj):
model = mUser.mUser()
index = obj.combo.currentIndex()
role = obj.combo.itemData(index)
user = obj.namaPengguna.text()
nama = obj.namaLengkap.text()
sandi = obj.kataSandi.text()
id_admin = obj.idUser
data = [id_admin, role, user, sandi, nama, 1, '2020-04-03', id_admin]
res = model.updateAdminData('setup_admin', data)
msg = QMessageBox()
if (res):
msg.about(obj, "Success", "Berhasil Menginput Data")
else:
msg.about(obj, "Fail", "Gagal Menginput Data")
print(res)
ui = ListAdmin.listAdminUI(obj)
obj.hide()
ui.show()
def __init__(self, UIgenerate=False):
if not UIgenerate:
self.model = mUser()
if UIgenerate:
self.generateUI()
