Skip to content

Instantly share code, notes, and snippets.

View sauloarruda's full-sized avatar

Saulo Arruda sauloarruda

View GitHub Profile
@sauloarruda
sauloarruda / profile.sql
Created January 29, 2018 12:31
Profile SQL
select
a.id as course_application_id, a.student_id, s.person_id, u.id user_id, u.email, p.name, pi.`nickname`, p.phone, a.status,
pi.birthdate_on, pi.gender, pi.has_disabilities, pi.`disabilities_description`, ad.`zip_code`, ad.neighborhood, ad.city, ad.state,
ps.linkedin_url, ps.facebook_url, c.`portfolio_url`,
c.years_of_experience, c.is_employed,
c.expected_pay, c.last_pay, pi.`family_income`,
c.experience_expectations, c.`experience_expectations_other`,
c.`entrepreneurship`, fd.`process_score`, fd.`system_score`, fd.`observations`,
fs.reached_xp_through, fs.`reached_xp_through_other`, fs.`reached_xp_through_alumni`,
(select count(id) from rp_higher_education where student_id = s.id and kind="graduation" and status="completed") as qt_graduation_completed,
{
"user": {}
"roles": [
"entity": {},
"policy": {}
],
"subscriptions": [
{
"description": "Pré-venda VDRocket",
"product": "urocket",
{
"jwtToken": {
"user": {
"uuid": "70da8606-39a0-11ed-a261-0242ac120002",
"name": "Saulo Arruda",
"whatsapp": "5511929381231"
},
"entity": {
"uuid": "a0310736-39a0-11ed-a261-0242ac120002",
"whitelabel": "vesti",
{
"grid_size": {
"name: "P-M-G",
"reference": "002",
"items_csv": "P,M,G"
}
}
params.require('grid_size').permit(:name, :reference, :integration_id, :items_csv)
{
"product": {
"grid_size_name": "P-M-G",
"batch_products": {
"batch_name": "PRODUÇÃO",
"variants": [
{
"sku": "002",
"sizes": [
{
---
filters:
- name: batch_id
label: Selecione os disparos
type: multi-select
collection:
- url: https://api.urocket.app/v1/batches
label: name
id: id
widgets: