fervisa

# All users (count)
# ======================
SELECT COUNT(DISTINCT "users"."id") FROM "users" LEFT OUTER JOIN "ole_core"."logins" ON "ole_core"."logins"."id" = "users"."login_id" LEFT OUTER JOIN "ole_core"."taggings" ON "ole_core"."taggings"."taggable_id" = "ole_core"."logins"."id" AND ole_core.taggings.context = ('udfs') AND "ole_core"."taggings"."taggable_type" = 'OleCore::Login' LEFT OUTER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE (logins.account_id = 5359 and (logins.id = 59251 or logins.role >= 6) and users.status != 'Retired' and users.deleted_at is null)

# Filtered users (count)
# ======================
SELECT COUNT(DISTINCT "users"."id") FROM "users" LEFT OUTER JOIN "ole_core"."logins" ON "ole_core"."logins"."id" = "users"."login_id" LEFT OUTER JOIN "ole_core"."taggings" ON "ole_core"."taggings"."taggable_id" = "ole_core"."logins"."id" AND ole_core.taggings.context = ('udfs') AND "ole_core"."taggings"."taggable_type" = 'OleCore::Login' LEFT OUTER JOIN "ol

fervisa

# All users (count)
# ======================
SELECT COUNT(DISTINCT "users"."id") FROM "users" LEFT OUTER JOIN "ole_core"."logins" ON "ole_core"."logins"."id" = "users"."login_id" LEFT OUTER JOIN "ole_core"."taggings" ON "ole_core"."taggings"."taggable_id" = "ole_core"."logins"."id" AND ole_core.taggings.context = ('udfs') AND "ole_core"."taggings"."taggable_type" = 'OleCore::Login' LEFT OUTER JOIN "ole_core"."tags" ON "ole_core"."tags"."id" = "ole_core"."taggings"."tag_id" WHERE (logins.account_id = 5359 and (logins.id = 59251 or logins.role >= 6) and users.status != 'Retired' and users.deleted_at is null)

# current subscription x5
# ======================
SELECT "ole_core"."subscriptions".* FROM "ole_core"."subscriptions" WHERE "ole_core"."subscriptions"."deleted_at" IS NULL AND "ole_core"."subscriptions"."account_id" = 5359 LIMIT 

# subscription plan
# ======================

fervisa

require 'rubygems'
require 'sanitize'
require 'nokogiri-styles'

no_whitespaces = lambda {|env|
  node = env[:node]
  return unless node.elem?

  unless node.children.any?{|c| !c.text? || c.content.strip.length > 0 }
    node.unlink

fervisa

gray_title = lambda do |env|
  node = env[:node]
  return if !node.elem? or !['p'].member? node.name or !['#D9D9D9', '#E0E0E0'].member? node.styles['background']
  node.name = 'h1'
  node['class'] = 'gray-title'
  node.delete 'style'
  node.parent.replace node
  return {:node_whitelist => [node]}
end

fervisa

mkdir -p ~/.vim/autoload ~/.vim/bundle; \
curl -Sso ~/.vim/autoload/pathogen.vim \
    https://raw.github.com/tpope/vim-pathogen/master/autoload/pathogen.vim

set nocompatible
execute pathogen#infect()
syntax on

fervisa

#= require application
#= require angular-mocks
#= require support/sinon
#= require support/jasmine-sinon

beforeEach(module('demoApp'))

beforeEach inject (_$httpBackend_, _$compile_, $rootScope, $controller, $location, $injector, $timeout) ->
  @scope = $rootScope.$new()
  @http = _$httpBackend_

fervisa

demoApp.config ($httpProvider) ->
  authToken = $("meta[name=\"csrf-token\"]").attr("content")
  $httpProvider.defaults.headers.common["X-CSRF-TOKEN"] = authToken

fervisa

ready = ->
  $('[ng-app]').each ->
    module = $(this).attr('ng-app')
    angular.bootstrap(this, [module])

$(document).on 'page:load', ready

fervisa

angular.module('demoApp')
  .filter 'productName', ['$filter', ($filter) ->
    (id, collection) ->
      objects = $filter('filter')(collection, { id: parseInt(id) }, true)
      if objetos.length then objects[0].name else ''
  ]

# in view
{{ evento.producto_id | productName:products }}

fervisa

set exrc            " habilita archivos .vimrc por directorio
set secure          " deshabilita comandos inseguros en archivos .vimrc locales