add apiParse for generating common search conditions

1 files changed, 42 insertions, 0 deletions

diff --git a/scripts/apiParse.js b/scripts/apiParse.js
new file mode 100644
index 00000000..427f34cd
--- /dev/null
+++ b/scripts/apiParse.js
@@ -0,0 +1,42 @@
+var debug = require('debug')('debug')
+
+const addUserSearch = async function (input) {
+  debug('add User Search')
+  var {search, starts_with, contains} = input
+
+  // if (since) cmd = cmd.havingRaw('invoices + payments + deposits + orders > ?', [0])
+
+  if (search) {
+    if (starts_with) {
+      search = search + '%'
+    } else if (contains) {
+      search = '%' + search + '%'
+    }
+
+    var condition = "(Users.email like '" + search + " OR Users.username like '" + search + "'"
+
+    debug('condition: ' + condition)
+    return condition
+  } else {
+    return ''
+  }
+}
+
+const addTimeSearch = async function (input, field) {
+  debug('add time Search')
+  if (!field) { field = 'updatedAt' }
+  
+  var {since} = input
+  if (since) {
+  
+    condition = "WHERE " + field + " >= " + since
+    debug('condition: ' + condition)
+
+    return condition
+  } else {
+    return ''
+  }
+}
+
+module.exports = {addUserSearch: addUserSearch, addTimeSearch: addTimeSearch}
+