def run(self): super(DueQuery, self).run() self._filters.append(OR(Task.q.status == "new", Task.q.status == "started")) self._filters.append(Task.q.dueDate != None) tasks = Task.select(AND(*self._filters)) lst = [] for task in tasks: item = Item(task) item.grp1 = task.dueDate.date() item.grp2 = task.project.name lst.append(item) fmt1 = formatDate return dict(lst=lst, fmt1=fmt1)
def run(self): super(ProjectQuery, self).run() self._filters.append(OR(Task.q.status == "new", Task.q.status == "started")) tasks = Task.select(AND(*self._filters)) lst = [] for task in tasks: item = Item(task) item.grp1 = task.project.name item.grp2 = "" lst.append(item) # Show notes at the end lst.sort(key=attrgetter("isNote")) fmt1 = lambda x: x return dict(lst=lst, fmt1=fmt1)
def run(self): super(DoneQuery, self).run() self._filters.append(Task.q.status == "done") if self.minDate is not None: self._filters.append(Task.q.doneDate >= self.minDate) if self.maxDate is not None: self._filters.append(Task.q.doneDate < self.maxDate) if self.minDate is None and self.maxDate is None: self._filters.append(Task.q.doneDate != None) tasks = Task.select(AND(*self._filters)) lst = [] for task in tasks: item = Item(task) item.grp1 = task.doneDate.date() item.grp2 = task.project.name lst.append(item) fmt1 = formatDate return dict(lst=lst, fmt1=fmt1)
def updateView(self): filters = [] queryType = self.ui.queryListWidget.currentRow() # Project wantedProject = self.ui.projectLineEdit.text() if not wantedProject.isEmpty(): filters.append( IN( Task.q.project, Select(Project.q.id, LIKE(Project.q.name, "%" + unicode(wantedProject) + "%")) )) # Status statusFilters = [] if queryType == QUERY_DONE: minDate = datetimeFromQDate(self.ui.fromDateEdit.date()) maxDate = datetimeFromQDate(self.ui.toDateEdit.date()) if maxDate < minDate: minDate, maxDate = maxDate, minDate maxDate += timedelta(1) doneFilter = AND( \ Task.q.status == "done", \ Task.q.doneDate >= minDate, \ Task.q.doneDate < maxDate \ ) statusFilters.append(doneFilter) else: statusFilters.append(Task.q.status == "new") statusFilters.append(Task.q.status == "started") filters.append(OR(*statusFilters)) # Due date if queryType == QUERY_DUE: dueDate = datetimeFromQDate(self.ui.dueDateEdit.date()) + timedelta(1) filters.append(Task.q.dueDate < dueDate) tasks = Task.select(AND(*filters)) lst = [] class Item(object): __slots__ = ["task", "grp1", "grp2"] for task in tasks: item = Item() item.task = task if queryType == QUERY_DUE: item.grp1 = task.dueDate.date() item.grp2 = task.project.name elif queryType == QUERY_PROJECT: item.grp1 = task.project.name item.grp2 = "" elif queryType == QUERY_DONE: item.grp1 = task.doneDate.date() item.grp2 = task.project.name else: raise Exception() lst.append(item) if queryType == QUERY_DUE: fmt1 = formatDate elif queryType == QUERY_PROJECT: fmt1 = lambda x: x elif queryType == QUERY_DONE: fmt1 = formatDate else: raise Exception() tmpl = self.jinjaEnv.get_template("index.html") html = tmpl.render(lst=lst, fmt1=fmt1) baseUrl = QUrl.fromLocalFile(os.path.join(self.dataDir, "static/")) self.ui.webView.setHtml(html, baseUrl) self.ui.webView.page().mainFrame().addToJavaScriptWindowObject("qtWindow", self)