Mercurial > hg > syntilista

changeset 16:8765397e45f4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Cleanups.
author Matti Hamalainen <ccr@tnsp.org>
date Thu, 30 Mar 2017 18:15:09 +0300
parents 466417b7a1e4
children d40345d63733
files main.cpp
diffstat 1 files changed, 7 insertions(+), 8 deletions(-) [+]
line wrap: on
line diff
--- a/main.cpp	Thu Mar 30 17:10:22 2017 +0300
+++ b/main.cpp	Thu Mar 30 18:15:09 2017 +0300
@@ -10,12 +10,6 @@
 #include "ui_mainwindow.h"
 #include "ui_editperson.h"
 
-static QString query_Person =
-    "SELECT id,last_name,first_name,"
-    "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
-    "updated FROM people";
-
-
 
 void errorMsg(QString title, QString msg)
 {
@@ -412,6 +406,11 @@
 //
 void SyntilistaMainWindow::updatePersonList()
 {
+    static QString queryBase =
+        "SELECT id,last_name,first_name,"
+        "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
+        "updated FROM people";
+
     QSqlQuery query;
     QString queryOrderDir, queryOrderBy;
 
@@ -446,7 +445,7 @@
     {
         // Filter by name(s)
         QString tmp = "%"+ peopleFilter +"%";
-        query.prepare(query_Person +" WHERE first_name LIKE ? OR last_name LIKE ?" + queryOrderBy);
+        query.prepare(queryBase +" WHERE first_name LIKE ? OR last_name LIKE ?" + queryOrderBy);
 
         query.addBindValue(tmp);
         query.addBindValue(tmp);
@@ -454,7 +453,7 @@
     else
     {
         // No filter
-        query.prepare(query_Person + queryOrderBy);
+        query.prepare(queryBase + queryOrderBy);
     }
 
     // Execute the query and update model