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()