def onFileRead(self, filePath):
if filePath:
try:
lines = DailyDataDAL.readAll(filePath)
dailyData = DailyDataDAL.parse(lines, TimeUtil.getToday())
DailyDataDAL.persistAll(dailyData)
newDailyData = DailyDataDAL.fetchAllByDate(TimeUtil.getToday())
self.buyerPanel.updateGrid(newDailyData.toStringList())
wx.MessageBox("导入数据成功", "导入数据", style=wx.OK | wx.ICON_EXCLAMATION)
except:
wx.MessageBox("导入数据失败，请检测数据格式", "导入数据", style=wx.OK | wx.ICON_EXCLAMATION)
def setupDateInput(self):
sizer = wx.GridBagSizer(4, 4)
dateText = wx.StaticText(self, label='日期')
sizer.Add(dateText, pos=(0, 0), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
self.dateInput = wx.TextCtrl(self, value=TimeUtil.getToday(), style=wx.TE_PROCESS_ENTER)
self.Bind(wx.EVT_TEXT_ENTER, self.onSearchDate, self.dateInput)
sizer.Add(self.dateInput, pos=(0, 1),
flag=wx.TOP | wx.LEFT, border=12)
self.calculateButton = wx.Button(self, label='计算一天战况', size=(100, 30))
sizer.Add(self.calculateButton, pos=(0, 2), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=12)
self.calculateButton.Enable(True)
self.Bind(wx.EVT_TEXT, self.OnEnter, self.dateInput)
self.Bind(wx.EVT_BUTTON, self.onSearchDate, self.calculateButton)
self.warnMsg = wx.StaticText(self, label='非法日期，请重新输入')
self.warnMsg.SetForegroundColour('red')
sizer.Add(self.warnMsg, pos=(0, 3), flag=wx.TOP | wx.LEFT, border=15)
self.warnMsg.Hide()
scoreText = wx.StaticText(self, label='盈亏')
sizer.Add(scoreText, pos=(1, 0), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
self.score = wx.StaticText(self, label='0')
sizer.Add(self.score, pos=(1, 1), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
self.vBox.Add(sizer, flag=wx.ALIGN_TOP, border=10)
def displayTodayData(self):
sizer = wx.GridBagSizer(4, 4)
today = TimeUtil.getToday()
# Load buyer data
dailyData = DailyDataDAL.fetchAllByDate(today)
# set data into data grid
self.data = UserGridData()
self.data.InsertRows(dailyData.toStringList())
self.grid = wx.grid.Grid(self, size=(500, 300))
self.grid.SetTable(self.data)
self.grid.AutoSize()
sizer.Add(self.grid, pos=(1, 1), span=(3, 3), flag=wx.EXPAND | wx.TOP, border=5)
searchText = wx.StaticText(self, label='名称')
sizer.Add(searchText, pos=(4, 1), flag=wx.EXPAND, border=5)
self.searchInput = wx.TextCtrl(self, style=wx.TE_PROCESS_ENTER)
self.Bind(wx.EVT_TEXT_ENTER, self.onSearchName, self.searchInput)
sizer.Add(self.searchInput, pos=(4, 2),
flag=wx.EXPAND | wx.LEFT | wx.RIGHT, border=5)
self.searchBtn = wx.Button(self, label='查找', size=(100, 20))
sizer.Add(self.searchBtn, pos=(4, 3))
self.searchBtn.Enable(True)
self.Bind(wx.EVT_BUTTON, self.onSearchName, self.searchBtn)
sizer.AddGrowableRow(1)
self.vBox.Add(sizer, wx.ALIGN_BOTTOM, 10)
def __init__(self, parent):
scrolled.ScrolledPanel.__init__(self, parent)
self.selectedScheduleInput = list()
self.scheduledInput = list()
self.scheduledStartDate = TimeUtil.getToday()
self.exportData = list()
self.displayWeeklyReport = True
self.initUI()
self.Show(True)
def validate():
if Constants.LICENSE_PURCHASED:
return True
conn = sqlite3.connect(Constants.DATABASE_ROOT_PATH +
LicenseValidateUtil.LICENSE_TABLE_NAME + '.db')
c = conn.cursor()
c.execute("CREATE TABLE IF NOT EXISTS " + LicenseValidateUtil.LICENSE_TABLE_NAME +
"(startDate VARCHAR[10], version VARCHAR[10])")
c.execute("SELECT startDate FROM " + LicenseValidateUtil.LICENSE_TABLE_NAME + " WHERE version=" + Constants.APPLICATION_VERSION)
startDate = c.fetchone()
if startDate == None:
c.execute("INSERT INTO " + LicenseValidateUtil.LICENSE_TABLE_NAME +
" VALUES ('" + TimeUtil.getToday() + "','" + Constants.APPLICATION_VERSION + "')")
conn.commit()
conn.close()
return True
else:
conn.close()
return TimeUtil.getDayLength(startDate[0], TimeUtil.getToday()) < Constants.MAX_FREE_TRIAL_DAY
def setupDateInput(self):
optionSizer = wx.GridBagSizer(4, 4)
optionOuterSizer = wx.StaticBoxSizer(wx.HORIZONTAL, self, label=u'选项')
userGroupText = wx.StaticText(self, label=u'排班班组')
optionSizer.Add(userGroupText, pos=(0, 0), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
self.userGroupDropDown = wx.ListBox(self, style=wx.LB_MULTIPLE, choices=self.loadGroupList(), size=(100, 50))
self.userGroupDropDown.Bind(wx.EVT_LISTBOX, self.onSelection)
optionSizer.Add(self.userGroupDropDown, pos=(0, 1), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
minWorkDays = wx.StaticText(self, label=u'最大连续休息天数')
optionSizer.Add(minWorkDays, pos=(1, 0), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
self.maxRestDaysInput = wx.TextCtrl(self, value='3', style=wx.TE_PROCESS_ENTER)
optionSizer.Add(self.maxRestDaysInput, pos=(1, 1),
flag=wx.TOP | wx.LEFT, border=12)
maxWorkDaysText = wx.StaticText(self, label=u'最大连续工作天数')
optionSizer.Add(maxWorkDaysText, pos=(1, 2), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
self.maxWorkDaysInput = wx.TextCtrl(self, value='6', style=wx.TE_PROCESS_ENTER)
optionSizer.Add(self.maxWorkDaysInput, pos=(1, 3),
flag=wx.TOP | wx.LEFT, border=12)
startDate = wx.StaticText(self, label=u'开始日期')
optionSizer.Add(startDate, pos=(2, 0), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
self.startDateInput = wx.TextCtrl(self, value=TimeUtil.getMonday(TimeUtil.getToday()),
style=wx.TE_PROCESS_ENTER)
self.Bind(wx.EVT_TEXT, self.OnEnterDate, self.startDateInput)
optionSizer.Add(self.startDateInput, pos=(2, 1),
flag=wx.TOP | wx.LEFT, border=12)
endDate = wx.StaticText(self, label=u'结束日期')
optionSizer.Add(endDate, pos=(2, 2), flag=wx.EXPAND | wx.TOP | wx.LEFT, border=15)
self.endDateInput = wx.TextCtrl(self,
value=TimeUtil.getSunday(
TimeUtil.getFormatedDate(self.startDateInput.GetValue(), 55)),
style=wx.TE_PROCESS_ENTER)
self.Bind(wx.EVT_TEXT, self.OnEnterDate, self.endDateInput)
optionSizer.Add(self.endDateInput, pos=(2, 3),
flag=wx.TOP | wx.LEFT, border=12)
blankMsg = wx.StaticText(self, label=u' ')
optionSizer.Add(blankMsg, pos=(3, 0), flag=wx.TOP | wx.LEFT, border=15)
self.warnMsg = wx.StaticText(self, label=u'非法日期，请重新输入')
self.warnMsg.SetForegroundColour('red')
optionSizer.Add(self.warnMsg, pos=(3, 1), span=(1, 3), flag=wx.TOP | wx.LEFT, border=15)
self.warnMsg.Hide()
optionOuterSizer.Add(optionSizer)
fontBtn = wx.Font(13, wx.FONTFAMILY_MODERN, wx.NORMAL, wx.FONTWEIGHT_BOLD)
btnOuterSizer = wx.StaticBoxSizer(wx.VERTICAL, self, u'操作')
btnSizer = wx.GridBagSizer(4, 4)
self.scheduleBtn = wx.Button(self, label=u'开始\n排班', size=(80, 66))
self.scheduleBtn.SetFont(fontBtn)
btnSizer.Add(self.scheduleBtn, pos=(0, 0), flag=wx.LEFT | wx.RIGHT, border=12)
self.scheduleBtn.Enable(False)
self.Bind(wx.EVT_BUTTON, self.onSchedule, self.scheduleBtn)
self.exportBtn = wx.Button(self, label=u'导出\n排班', size=(80, 66))
self.exportBtn.SetFont(fontBtn)
btnSizer.Add(self.exportBtn, pos=(1, 0), flag=wx.BOTTOM | wx.LEFT | wx.RIGHT, border=12)
self.exportBtn.Enable(False)
self.Bind(wx.EVT_BUTTON, self.onExport, self.exportBtn)
self.convertDisplayBtn = wx.Button(self, label=u'切换\n排班\n格式', size=(80, 66))
self.convertDisplayBtn.SetFont(fontBtn)
btnSizer.Add(self.convertDisplayBtn, pos=(0, 2), span=(0, 1), flag=wx.BOTTOM | wx.LEFT | wx.RIGHT, border=12)
self.Bind(wx.EVT_BUTTON, self.onConvertDisplay, self.convertDisplayBtn)
self.saveBtn = wx.Button(self, label=u'保存\n排班', size=(80, 66))
self.saveBtn.SetFont(fontBtn)
btnSizer.Add(self.saveBtn, pos=(0, 1), flag=wx.BOTTOM | wx.LEFT | wx.RIGHT, border=12)
self.saveBtn.Enable(False)
self.Bind(wx.EVT_BUTTON, self.onSaveCalendar, self.saveBtn)
self.loadBtn = wx.Button(self, label=u'加载\n排班', size=(80, 66))
self.loadBtn.SetFont(fontBtn)
btnSizer.Add(self.loadBtn, pos=(1, 1), flag=wx.BOTTOM | wx.LEFT | wx.RIGHT, border=12)
self.Bind(wx.EVT_BUTTON, self.onLoadCalendar, self.loadBtn)
self.deleteBtn = wx.Button(self, label=u'删除\n排班', size=(80, 66))
self.deleteBtn.SetFont(fontBtn)
btnSizer.Add(self.deleteBtn, pos=(1, 2), flag=wx.BOTTOM | wx.LEFT | wx.RIGHT, border=12)
self.Bind(wx.EVT_BUTTON, self.onDeleteCalendar, self.deleteBtn)
btnOuterSizer.Add(btnSizer)
outerSizer = wx.BoxSizer(orient=wx.HORIZONTAL)
outerSizer.Add(optionOuterSizer)
outerSizer.AddSpacer(15)
outerSizer.Add(btnOuterSizer)
self.vBox.Add(outerSizer, wx.ALIGN_TOP | wx.ALIGN_LEFT, 10)