def __init__(self, parent):
	
		sds.PageAResult.__init__(self, parent)
		self.parent = parent
		self.SetSize((1000, 800))
		self.Centre()
		self.Maximize(True)
		
		try :
			self.sumriasec = self.parent.sumscoresR + self.parent.sumscoresI + self.parent.sumscoresA\
							+self.parent.sumscoresE + self.parent.sumscoresC

		except :
			self.sumriasec = 0

		if self.sumriasec == 0 or self.parent.sum == 0:
			self.m_staticA.SetLabel("___")		
			self.m_staticA2.SetLabel("___")		
			self.m_staticA3.SetLabel("___")		
			self.m_staticA4.SetLabel("___")		
			self.m_staticA5.SetLabel("___")		
			self.m_staticA6.SetLabel("___")		

		else :
			self.m_staticA.SetLabel(self.parent.listpermut[0])		
			self.m_staticA2.SetLabel(self.parent.listpermut[1])		
			self.m_staticA3.SetLabel(self.parent.listpermut[2])		
			self.m_staticA4.SetLabel(self.parent.listpermut[3])		
			self.m_staticA5.SetLabel(self.parent.listpermut[4])		
			self.m_staticA6.SetLabel(self.parent.listpermut[5])		
					
			from AppsSDS.db import db
	
			self.buka = db.QueryList()
	
			self.buka1, self.buka2 = self.buka.CheckQuery(None, self.parent.listpermut[0])
			if list(self.buka2.keys()) == []:
				self.buka2["Kosong"] = "Kosong"
				print ("hello")
			self.m_listBoxA1.InsertItems(list(self.buka2.keys()), 0)
		
			self.buka1, self.buka2 = self.buka.CheckQuery(None, self.parent.listpermut[1])
			if list(self.buka2.keys()) == []:
				self.buka2["Kosong"] = "Kosong"
				print ("hello")
			self.m_listBoxA2.InsertItems(list(self.buka2.keys()), 0)
	
			self.buka1, self.buka2 = self.buka.CheckQuery(None, self.parent.listpermut[2])
			if list(self.buka2.keys()) == []:
				self.buka2["Kosong"] = "Kosong"
				print ("hello")
			self.m_listBoxA3.InsertItems(list(self.buka2.keys()), 0)
			
			self.buka1, self.buka2 = self.buka.CheckQuery(None, self.parent.listpermut[3])
			if list(self.buka2.keys()) == []:
				self.buka2["Kosong"] = "Kosong"
				print ("hello")
			self.m_listBoxA4.InsertItems(list(self.buka2.keys()), 0)
	
			self.buka1, self.buka2 = self.buka.CheckQuery(None, self.parent.listpermut[4])
			if list(self.buka2.keys()) == []:
				self.buka2["Kosong"] = "Kosong"
				print ("hello")
			self.m_listBoxA5.InsertItems(list(self.buka2.keys()), 0)
			
			self.buka1, self.buka2 = self.buka.CheckQuery(None, self.parent.listpermut[5])
			if list(self.buka2.keys()) == []:
				self.buka2["Kosong"] = "Kosong"
				print ("hello")
			self.m_listBoxA6.InsertItems(list(self.buka2.keys()), 0)
		
		self.Refresh()
		self.Layout()
Exemple #2
0
	def __init__(self, parent):
		wx.Frame.__init__ (self, parent, id=wx.ID_ANY, title=u"Cari Pekerjaan", pos=wx.DefaultPosition, size=wx.Size(500, 300), style=wx.DEFAULT_FRAME_STYLE | wx.TAB_TRAVERSAL)

		self.SetSizeHints(wx.DefaultSize, wx.DefaultSize)

		bSizer1 = wx.BoxSizer(wx.VERTICAL)

		self.m_panel1 = wx.Panel(self, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, wx.TAB_TRAVERSAL)
		self.m_panel1.SetFont(wx.Font(14, wx.FONTFAMILY_DEFAULT, wx.FONTSTYLE_NORMAL, wx.FONTWEIGHT_NORMAL, False, "Tw Cen MT"))

		bSizer5 = wx.BoxSizer(wx.VERTICAL)

		bSizer2 = wx.BoxSizer(wx.HORIZONTAL)

		bSizer2.Add((0, 0), 1, wx.EXPAND, 5)

		self.m_staticText1 = wx.StaticText(self.m_panel1, wx.ID_ANY, u"Nama Pekerjaan", wx.DefaultPosition, wx.DefaultSize, 0)
		self.m_staticText1.Wrap(-1)

		bSizer2.Add(self.m_staticText1, 0, wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

		self.m_textCtrl1 = wx.TextCtrl(self.m_panel1, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0)
		self.m_textCtrl1.SetFont(wx.Font(14, wx.FONTFAMILY_DEFAULT, wx.FONTSTYLE_NORMAL, wx.FONTWEIGHT_NORMAL, False, "Tw Cen MT"))

		bSizer2.Add(self.m_textCtrl1, 1, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

		self.m_button3 = wx.TextCtrl(self.m_panel1, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0)
		self.m_button3.SetFont(wx.Font(14, wx.FONTFAMILY_DEFAULT, wx.FONTSTYLE_NORMAL, wx.FONTWEIGHT_NORMAL, False, "Tw Cen MT"))

		self.m_staticTextKode = wx.StaticText(self.m_panel1, wx.ID_ANY, label="Cari Dalam Bahasa Inggris")
		self.m_staticTextKode.SetFont(wx.Font(14, wx.FONTFAMILY_DEFAULT, wx.FONTSTYLE_NORMAL, wx.FONTWEIGHT_NORMAL, False, "Tw Cen MT"))
		self.m_staticTextKode.Wrap(-1)

		# self.m_button3 = wx.Button( self.m_panel1, wx.ID_ANY, wx.EmptyString, wx.DefaultPosition, wx.DefaultSize, 0 )
		# self.m_button3.SetBitmap( wx.NullBitmap )

		bSizer2.Add(self.m_staticTextKode, 0, wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

		bSizer2.Add(self.m_button3, 1, wx.ALL | wx.ALIGN_CENTER_HORIZONTAL | wx.ALIGN_CENTER_VERTICAL, 5)

		bSizer5.Add(bSizer2, 0, wx.EXPAND, 5)

		from AppsSDS.db import db
		self.listprofesiona = db.QueryList()
		print (self.listprofesiona.query2())
		# print (list(self.listprofesiona.query().keys()))
		# m_listBox1Choices = list(self.listprofesiona.query().keys())
		m_listBox1Choices = list(self.listprofesiona.query2())

		print(type(m_listBox1Choices))
		# self.m_listBox1 = wx.ListBox( self, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, m_listBox1Choices, wx.LB_NEEDED_SB|wx.LB_SORT )
		# bSizer5.Add( self.m_listBox1, 1, wx.ALL|wx.EXPAND, 5 )
		# self.m_listBox1.Hide()

		self.m_listCtrl1 = wx.ListCtrl(self.m_panel1, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, wx.LC_EDIT_LABELS | wx.LC_REPORT)
		bSizer5.Add(self.m_listCtrl1, 1, wx.ALL | wx.EXPAND, 5)

		self.m_listCtrl1.InsertColumn(0, "Nama Pekerjaan", width=450, format=wx.LIST_FORMAT_LEFT)
		self.m_listCtrl1.InsertColumn(1, "Kode", width=75, format=wx.LIST_FORMAT_LEFT)
		self.m_listCtrl1.InsertColumn(2, "Pekerjaan Bahasa Indonesia", width=450, format=wx.LIST_FORMAT_LEFT)
		
		# print (m_listBox1Choices)
		for listdatabaseimport in range(len(m_listBox1Choices)) :
			print (listdatabaseimport)
			self.m_listCtrl1.InsertItem(listdatabaseimport, m_listBox1Choices[listdatabaseimport][0])
			self.m_listCtrl1.SetItem(listdatabaseimport, 1, m_listBox1Choices[listdatabaseimport][1])
			self.m_listCtrl1.SetItem(listdatabaseimport, 2, m_listBox1Choices[listdatabaseimport][2])

		fgSizer1 = wx.FlexGridSizer(0, 2, 0, 0)
		fgSizer1.AddGrowableCol(0)
		fgSizer1.AddGrowableCol(1)
		fgSizer1.AddGrowableRow(0)
		fgSizer1.SetFlexibleDirection(wx.BOTH)
		fgSizer1.SetNonFlexibleGrowMode(wx.FLEX_GROWMODE_SPECIFIED)

		self.cancel = wx.Button(self.m_panel1, wx.ID_ANY, u"Cancel", wx.DefaultPosition, wx.DefaultSize, 0)
		fgSizer1.Add(self.cancel, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL | wx.ALIGN_RIGHT, 5)

		self.ok = wx.Button(self.m_panel1, wx.ID_ANY, u"Ok", wx.DefaultPosition, wx.DefaultSize, 0)
		fgSizer1.Add(self.ok, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 5)

		bSizer5.Add(fgSizer1, 0, wx.EXPAND | wx.ALIGN_RIGHT, 5)

		self.m_panel1.SetSizer(bSizer5)
		self.m_panel1.Layout()
		bSizer5.Fit(self.m_panel1)
		bSizer1.Add(self.m_panel1, 1, wx.EXPAND | wx.ALL, 5)

		self.SetSizer(bSizer1)
		self.Layout()

		self.Centre(wx.BOTH)

		# Connect Events
		self.m_textCtrl1.Bind(wx.EVT_TEXT, self.m_textCtrl_listOnText)
		# self.m_button3.Bind( wx.EVT_BUTTON, self.m_button3_cariOnButtonClick )
		self.m_staticTextKode.Bind(wx.EVT_TEXT, self.m_textCtrlKode_listOnText)

		import os
		import pathlib
		pathf = pathlib.Path.cwd() / "images/symbol/search.jpg"
		self.image = wx.Image(str(pathf))
		self.re_image = self.image.Rescale(40, 20)
		# self.m_button3.SetBitmap( wx.Bitmap( self.re_image ) )

		self.m_button3.Refresh()
		self.m_button3.Layout()
		self.SetSizer(bSizer1)
		self.Refresh()
		self.Layout()
		self.SetSize(800, 600)
		self.Centre(wx.BOTH)

		# Connect Events
		self.m_textCtrl1.Bind(wx.EVT_TEXT, self.m_textCtrl_listOnText)
		self.m_button3.Bind(wx.EVT_TEXT, self.m_button3_cariOnButtonClick)

		# Connect Events
		self.cancel.Bind(wx.EVT_BUTTON, self.m_tombolcancel_lb)
		self.ok.Bind(wx.EVT_BUTTON, self.tombolok_lb)
		# self.m_listBox1.Bind( wx.EVT_LISTBOX_DCLICK, self.m_listboxselect )
		self.m_textCtrl1.Bind(wx.EVT_TEXT, self.m_textCtrl_listOnText)
		# self.m_button3.Bind( wx.EVT_BUTTON, self.m_button3_cariOnButtonClick )
		self.m_listCtrl1.Bind(wx.EVT_LEFT_DCLICK, self.m_listCtrl1OnLeftDClick)