export 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 ''
  }
}

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

    return condition
  } else {
    return ''
  }
}