aboutsummaryrefslogtreecommitdiffstats
path: root/lib/createLnrpc.js
diff options
context:
space:
mode:
Diffstat (limited to 'lib/createLnrpc.js')
0 files changed, 0 insertions, 0 deletions
4 -0700 committer Ran Guin <[email protected]> 2021-07-28 22:02:24 -0700 add apiParse for generating common search conditions' href='/coinos-server.git/commit/scripts/apiParse.js?h=tickets&id=ed68ee893ae7bb3540f0731c3ccf21a26bc6ac1f'>ed68ee89 ^
038e1471 ^
ed68ee89 ^
ed68ee89 ^





038e1471 ^
ed68ee89 ^



038e1471 ^
ed68ee89 ^






038e1471 ^



ed68ee89 ^
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
                                               

                                             
                                 








                                                                                       
                                                                                                                 
 





                    
                                               



                                     
                                             






                    



                                
 
const addUserSearch = function (input, table) {
  var {search, starts_with, contains} = input

  if (!table) { table = 'users' }
  // if (since) cmd = cmd.havingRaw('invoices + payments + deposits + orders > ?', [0])

  if (search) {
    if (starts_with) {
      search = search + '%'
    } else if (contains) {
      search = '%' + search + '%'
    }

    var condition = "(" + table + ".email like '" + search + "' OR " + table + ".username like '" + search + "')"

    return condition
  } else {
    return ''
  }
}

const addTimeSearch = function (input, field) {
  if (!field) { field = 'updatedAt' }
  
  var {since} = input
  if (since) {
    condition = field + " >= '" + since + "'"

    return condition
  } else {
    return ''
  }
}

module.exports = {
  addUserSearch: addUserSearch, 
  addTimeSearch: addTimeSearch,
}