code Clique para ver o JSON completo
25 KB
{
"table-id": "membros",
"data-table-ondevou": "membros",
"data-table-auditor": "auditor_membros",
"data-table-getdata": "sim",
"table-class": "highlight",
"putdata": {
"trigger": "setTableFromPutData()"
},
"controls": [
"add",
"copy",
"edit",
"save",
"key",
"login",
"link",
"delete",
"remove"
],
"html": {
"div": {
"before": "",
"after": ""
}
},
"routines": {
"view": "165",
"add": "56",
"edit": "81"
},
"headers": {
"Id": {
"width": "7%"
},
"E-mail": {
"width": "25%"
},
"Nome": {
"width": "25%"
},
"CPF": {
"width": "10%"
},
"Nova senha": {
"type": "hidden",
"width": "20%"
},
"Confirme a senha": {
"type": "hidden",
"width": "20%"
},
"Cep": {
"width": "80px"
},
"Rua": {
"width": "250px"
},
"Número": {
"width": "70px"
},
"Complemento": {
"width": "120px"
},
"Bairro": {
"width": "150px"
},
"Cidade": {
"width": "150px"
},
"UF": {
"width": "40px"
},
"Telefone": {
"width": "8%"
},
"Whatsapp": {
"width": "8%"
},
"Facebook": {
"width": "10%"
},
"Twitter": {
"width": "10%"
},
"Instagram": {
"width": "10%"
},
"Youtube": {
"width": "10%"
},
"Site": {
"width": "10%"
},
"Confirmado": {
"type": "hidden"
},
"Membro movimentado": {
"type": "hidden"
}
},
"columns": {
"Id": {
"input": {
"readonly": "readonly",
"data-type-ondevou": "number",
"autocomplete": "off",
"data-field-ondevou": "id",
"data-field-alias-ondevou": "id_membro",
"data-table-ondevou": "membros,auditor_membros",
"controls-acao": {
"link": {
"acao": "getMembrosParticipantes",
"messagem": "Vínculos"
}
},
"formsearch": {
"required": ""
}
}
},
"E-mail": {
"input": {
"required": "required",
"readonly": "readonly",
"data-type-ondevou": "text",
"data-field-ondevou": "email",
"data-field-getdata": "email_membro",
"data-field-alias-ondevou": "email_membro",
"autocomplete": "username",
"onkeyup": "setInputFormatEmail(this)",
"data-table-ondevou": "membros",
"formsearch": {
"required": ""
}
}
},
"Nome": {
"input": {
"required": "required",
"data-type-ondevou": "text",
"data-field-ondevou": "nome",
"data-field-alias-ondevou": "nome_membro",
"data-table-ondevou": "membros",
"formsearch": {
"required": ""
}
}
},
"CPF": {
"input": {
"required": "required",
"data-type-ondevou": "text",
"data-field-ondevou": "cpf",
"data-field-getdata": "cpf",
"data-field-alias-ondevou": "cpf_membro",
"maxlength": "14",
"minlength": "14",
"onkeypress": "return SomenteNumero(event)",
"onkeyup": "setInputFormatCpf(this)",
"data-table-ondevou": "membros"
}
},
"Nova senha": {
"input": {
"type": "password",
"data-type-ondevou": "text",
"data-field-ondevou": "nova_senha",
"autocomplete": "new-password",
"data-table-ondevou": "membros"
}
},
"Confirme a senha": {
"input": {
"type": "password",
"data-type-ondevou": "text",
"data-field-ondevou": "confirme_senha",
"autocomplete": "new-password",
"data-table-ondevou": "membros"
}
},
"Cep": {
"input": {
"required": "required",
"data-type-ondevou": "number",
"data-id-field-ondevou": "id_cep",
"maxlength": "8",
"minlength": "8",
"data-field-ondevou": "cep",
"data-table-ondevou": "membros",
"onkeypress": "return SomenteNumero(event)",
"onkeyup": "setInputFormatApenasNumeros(this)",
"onpaste": "setInputFormatApenasNumeros(this)",
"getdata": "{\"view\":\"view_ruas\",\"data\":\"view_ruas\",\"campo-data-id\":\"id_cep\",\"campo-data-value-input\":\"cep\",\"campo-data-input-select-view\":\"cep,nome_rua,nome_bairro,nome_cidade,sigla_uf\",\"query\":{\"select\":\"* from view_ruas\",\"where\":{\"and\":{\"texto_digitado\":{\"left\":\"(unaccent(LOWER(cep)) ilike `\",\"right\":\"%`)\"}}}}}",
"getmodal": "{\"icon\":\"add_box\",\"title\":\"Criar endereço\",\"modal\":\"\",\"table-add\":\"addTableRuas\",\"table-setups\":\"{\\\"search\\\":\\\"nao\\\",\\\"html\\\":\\\"sim\\\",\\\"table-rows-limit\\\":\\\"1\\\",\\\"data-view\\\":\\\"form\\\",\\\"controls\\\":[\\\"info\\\",\\\"add\\\",\\\"map\\\",\\\"save\\\"]}\"}"
}
},
"Rua": {
"input": {
"readonly": "readonly",
"data-type-ondevou": "number",
"data-id-field-ondevou": "id_rua",
"data-field-ondevou": "nome_rua",
"data-field-erplinux": "endereco",
"data-table-ondevou": "membros"
}
},
"Número": {
"input": {
"required": "required",
"data-type-ondevou": "text",
"data-field-ondevou": "numero",
"data-field-erplinux": "numero",
"data-field-alias-ondevou": "numero_membro",
"onkeypress": "return SomenteNumero(event)",
"data-table-ondevou": "membros"
}
},
"Complemento": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "complemento",
"data-field-erplinux": "compl_e1",
"data-field-alias-ondevou": "complemento_membro",
"data-table-ondevou": "membros"
}
},
"Bairro": {
"input": {
"readonly": "readonly",
"data-type-ondevou": "number",
"data-id-field-ondevou": "id_bairro",
"data-field-ondevou": "nome_bairro",
"data-field-erplinux": "bairro",
"data-table-ondevou": "view_membros"
}
},
"Cidade": {
"input": {
"readonly": "readonly",
"data-type-ondevou": "number",
"data-id-field-ondevou": "id_cidade",
"data-field-ondevou": "nome_cidade",
"data-field-getdata": "id_cidade",
"data-field-erplinux": "cidade",
"data-table-ondevou": "view_membros"
}
},
"UF": {
"input": {
"readonly": "readonly",
"data-type-ondevou": "number",
"data-id-field-ondevou": "id_uf",
"data-field-ondevou": "sigla_uf",
"data-field-erplinux": "estado",
"data-table-ondevou": "view_membros"
}
},
"Telefone": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "telefone",
"data-field-alias-ondevou": "telefone_membro",
"onkeypress": "return SomenteNumero(event)",
"onkeyup": "setInputFormatTelefone(this)",
"data-table-ondevou": "membros"
}
},
"Whatsapp": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "whatsapp",
"data-field-alias-ondevou": "whatsapp_membro",
"onkeypress": "return SomenteNumero(event)",
"onkeyup": "setInputFormatTelefone(this)",
"data-table-ondevou": "membros"
}
},
"Facebook": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "facebook",
"data-field-alias-ondevou": "facebook_membro",
"data-table-ondevou": "membros"
}
},
"Twitter": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "twitter",
"data-field-alias-ondevou": "twitter_membro",
"data-table-ondevou": "membros"
}
},
"Instagram": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "instagram",
"data-field-alias-ondevou": "instagram_membro",
"data-table-ondevou": "membros"
}
},
"Youtube": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "youtube",
"data-field-alias-ondevou": "youtube_membro",
"data-table-ondevou": "membros"
}
},
"Site": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "site",
"data-field-alias-ondevou": "site_membro",
"data-table-ondevou": "membros"
}
},
"Confirmado": {
"input": {
"data-type-ondevou": "text",
"data-field-ondevou": "email_confirmado",
"data-table-ondevou": "membros"
}
},
"Membro movimentado": {
"input": {
"readonly": "readonly",
"data-type-ondevou": "number",
"data-field-ondevou": "id_membro_movimentado",
"data-field-alias-ondevou": "id_membro",
"data-table-ondevou": "membros_membros,auditor_membros"
}
}
},
"formsearch": {
"data-table-ondevou": "view_membros",
"data-view-ondevou": "view_membros",
"data-where-order": "order by id_membro desc",
"input": {}
},
"dashboard": {
"enabled": true,
"theme": "modern",
"layout": "free",
"auto_refresh": false,
"header": {
"logo": {
"src": "img/ondevou_plataforma.png",
"alt": "OndeVou Plataforma",
"class": "dashboard-logo-img"
},
"title": "MEMBROS",
"subtitle": "Cadastro de Membros da Plataforma",
"filters_area": {
"container_id": "dashboard-filters-area",
"empty_message": "Sem filtros"
},
"actions": [
{
"type": "button",
"container_id": "dashboard-atualizar-dados",
"class": "dashboard-btn dashboard-btn-sm dashboard-btn-primary",
"icon": "fas fa-sync-alt",
"text": "Atualizar",
"action": "dashboard_refreshData",
"title": "Atualizar Dados"
},
{
"type": "button",
"container_id": "dashboard-voltar-dados",
"class": "dashboard-btn dashboard-btn-sm dashboard-btn-outline",
"icon": "fas fa-table",
"text": "Voltar para dados",
"action": "voltarParaDadosFromDashboard",
"title": "Voltar para dados"
},
{
"type": "button",
"container_id": "dashboard-auto-refresh",
"class": "dashboard-btn dashboard-btn-sm dashboard-btn-info",
"icon": "fas fa-clock",
"text": "Auto-Refresh",
"action": "dashboard_toggleAutoRefresh",
"title": "Alternar escuta automática de dados"
}
]
},
"sections": {
"bloco1_resumo_executivo": {
"type": "summary_cards_full",
"title": "RESUMO EXECUTIVO - MEMBROS",
"class": "dashboard-section dashboard-section-full-width",
"icon": "👤",
"config": {
"container_id": "cards-resumo-executivo",
"size": "full",
"cards": [
{
"title": "TOTAL DE MEMBROS",
"value": "COUNT:id_membro",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "👤",
"color": "#2c3e50"
},
{
"title": "COM TELEFONE",
"value": "COUNT:id_membro",
"filters": "telefone_membro IS NOT NULL AND telefone_membro != \"\"",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "📞",
"color": "#3498db"
},
{
"title": "TAXA DE TELEFONE",
"value": "CALC:(COUNT(id_membro where telefone_membro IS NOT NULL AND telefone_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "📊",
"color": "#3498db"
},
{
"title": "COM WHATSAPP",
"value": "COUNT:id_membro",
"filters": "whatsapp_membro IS NOT NULL AND whatsapp_membro != \"\"",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "💬",
"color": "#27ae60"
},
{
"title": "TAXA DE WHATSAPP",
"value": "CALC:(COUNT(id_membro where whatsapp_membro IS NOT NULL AND whatsapp_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "📊",
"color": "#27ae60"
},
{
"title": "COM ENDEREÇO COMPLETO",
"value": "COUNT:id_membro",
"filters": "id_rua IS NOT NULL AND id_rua != \"\" AND numero_membro IS NOT NULL AND numero_membro != \"\"",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "📍",
"color": "#8e44ad"
},
{
"title": "TAXA DE ENDEREÇO",
"value": "CALC:(COUNT(id_membro where id_rua IS NOT NULL AND id_rua != \"\" AND numero_membro IS NOT NULL AND numero_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "📊",
"color": "#8e44ad"
},
{
"title": "COM REDES SOCIAIS",
"value": "COUNT:id_membro",
"filters": "facebook_membro IS NOT NULL AND facebook_membro != \"\" OR instagram_membro IS NOT NULL AND instagram_membro != \"\"",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "📱",
"color": "#f39c12"
}
]
}
},
"bloco2_metricas_detalhadas": {
"type": "summary_cards_grid",
"title": "MÉTRICAS DETALHADAS",
"class": "dashboard-section dashboard-section-full-width",
"icon": "🔢",
"config": {
"container_id": "cards-metricas-detalhadas",
"size": "full",
"sections": [
{
"title": "📍 DISTRIBUIÇÃO GEOGRÁFICA",
"cards": [
{
"title": "UFs ATENDIDAS",
"value": "COUNT_DISTINCT:sigla_uf",
"filters": "sigla_uf IS NOT NULL AND sigla_uf != \"\"",
"format": "numero",
"decimals": 0,
"icon": "🗺️",
"color": "#3498db"
},
{
"title": "CIDADES ATENDIDAS",
"value": "COUNT_DISTINCT:nome_cidade",
"filters": "nome_cidade IS NOT NULL AND nome_cidade != \"\"",
"format": "numero",
"decimals": 0,
"icon": "🏙️",
"color": "#27ae60"
},
{
"title": "UF MAIS ATENDIDA",
"group_by": "sigla_uf",
"value": "METRICA_AGRUPAMENTO:moda",
"filters": "sigla_uf IS NOT NULL AND sigla_uf != \"\"",
"format": "texto",
"icon": "🥇",
"color": "#f1c40f"
},
{
"title": "CIDADE MAIS ATENDIDA",
"group_by": "nome_cidade",
"value": "METRICA_AGRUPAMENTO:moda",
"filters": "nome_cidade IS NOT NULL AND nome_cidade != \"\"",
"format": "texto",
"icon": "🏙️",
"color": "#f39c12"
}
]
},
{
"title": "📱 PRESENÇA DIGITAL",
"cards": [
{
"title": "COM FACEBOOK",
"value": "COUNT:id_membro",
"filters": "facebook_membro IS NOT NULL AND facebook_membro != \"\"",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "📘",
"color": "#3b5998"
},
{
"title": "COM INSTAGRAM",
"value": "COUNT:id_membro",
"filters": "instagram_membro IS NOT NULL AND instagram_membro != \"\"",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "📷",
"color": "#e4405f"
},
{
"title": "COM SITE",
"value": "COUNT:id_membro",
"filters": "site_membro IS NOT NULL AND site_membro != \"\"",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "🌐",
"color": "#1abc9c"
},
{
"title": "COM YOUTUBE",
"value": "COUNT:id_membro",
"filters": "youtube_membro IS NOT NULL AND youtube_membro != \"\"",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"icon": "▶️",
"color": "#ff0000"
}
]
}
]
}
},
"bloco3_distribuicao_uf": {
"type": "charts_grid_section",
"title": "DISTRIBUIÇÃO POR UF",
"class": "dashboard-section dashboard-section-full-width",
"grid_class": "dashboard-section-grid-2",
"icon": "🗺️",
"config": {
"container_id": "distribuicao-uf",
"charts": [
{
"type": "chart_pie",
"config": {
"container_id": "graf-uf-pizza",
"data_config": {
"group_by": "sigla_uf",
"operation": "COUNT:id_membro",
"filters": "sigla_uf IS NOT NULL AND sigla_uf != \"\""
},
"display_config": {
"title": "MEMBROS POR UF",
"donut": true,
"show_percentages": true,
"show_values": true,
"format": "numero",
"decimals": 0,
"suffix": " membros",
"height": "350px"
}
}
},
{
"type": "chart_bar_aggregated",
"config": {
"container_id": "graf-uf-ranking",
"data_config": {
"group_by": "sigla_uf",
"operation": "COUNT:id_membro",
"filters": "sigla_uf IS NOT NULL AND sigla_uf != \"\""
},
"display_config": {
"title": "RANKING POR UF",
"layout": "ranking",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"height": "350px",
"sort_by": "value",
"sort_order": "DESC"
}
}
}
]
}
},
"bloco4_distribuicao_cidade": {
"type": "charts_grid_section",
"title": "DISTRIBUIÇÃO POR CIDADE",
"class": "dashboard-section dashboard-section-full-width",
"grid_class": "dashboard-section-grid-2",
"icon": "🏙️",
"config": {
"container_id": "distribuicao-cidade",
"charts": [
{
"type": "chart_pie",
"config": {
"container_id": "graf-cidade-pizza",
"data_config": {
"group_by": "nome_cidade",
"operation": "COUNT:id_membro",
"filters": "nome_cidade IS NOT NULL AND nome_cidade != \"\""
},
"display_config": {
"title": "TOP CIDADES",
"donut": true,
"show_percentages": true,
"show_values": true,
"format": "numero",
"decimals": 0,
"suffix": " membros",
"height": "350px",
"limit": 10
}
}
},
{
"type": "chart_bar_aggregated",
"config": {
"container_id": "graf-cidade-ranking",
"data_config": {
"group_by": "nome_cidade",
"operation": "COUNT:id_membro",
"filters": "nome_cidade IS NOT NULL AND nome_cidade != \"\""
},
"display_config": {
"title": "TODAS AS CIDADES",
"layout": "ranking",
"format": "numero",
"decimals": 0,
"suffix": " membros",
"height": "400px",
"sort_by": "value",
"sort_order": "DESC"
}
}
}
]
}
},
"bloco5_qualidade_cadastro": {
"type": "summary_cards_grid",
"title": "QUALIDADE DO CADASTRO",
"class": "dashboard-section dashboard-section-full-width",
"icon": "✅",
"config": {
"container_id": "cards-qualidade-cadastro",
"size": "full",
"sections": [
{
"title": "📊 COMPLETUDE DOS DADOS",
"cards": [
{
"title": "TAXA DE CPF",
"value": "CALC:(COUNT(id_membro where cpf_membro IS NOT NULL AND cpf_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "🆔",
"color": "#3498db"
},
{
"title": "TAXA DE TELEFONE",
"value": "CALC:(COUNT(id_membro where telefone_membro IS NOT NULL AND telefone_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "📞",
"color": "#27ae60"
},
{
"title": "TAXA DE WHATSAPP",
"value": "CALC:(COUNT(id_membro where whatsapp_membro IS NOT NULL AND whatsapp_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "💬",
"color": "#f39c12"
},
{
"title": "TAXA DE ENDEREÇO",
"value": "CALC:(COUNT(id_membro where id_rua IS NOT NULL AND id_rua != \"\" AND numero_membro IS NOT NULL AND numero_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "📍",
"color": "#8e44ad"
},
{
"title": "TAXA DE SITE",
"value": "CALC:(COUNT(id_membro where site_membro IS NOT NULL AND site_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "🌐",
"color": "#1abc9c"
},
{
"title": "TAXA DE REDES SOCIAIS",
"value": "CALC:(COUNT(id_membro where facebook_membro IS NOT NULL AND facebook_membro != \"\" OR instagram_membro IS NOT NULL AND instagram_membro != \"\")/COUNT(id_membro))*100",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "📱",
"color": "#9b59b6"
}
]
},
{
"title": "📊 ÍNDICE DE COMPLETUDE (MÉDIA)",
"cards": [
{
"title": "COMPLETUDE MÉDIA",
"value": "CALC:((COUNT(id_membro where cpf_membro IS NOT NULL AND cpf_membro != \"\")/COUNT(id_membro))*100 + (COUNT(id_membro where telefone_membro IS NOT NULL AND telefone_membro != \"\")/COUNT(id_membro))*100 + (COUNT(id_membro where id_rua IS NOT NULL AND id_rua != \"\" AND numero_membro IS NOT NULL AND numero_membro != \"\")/COUNT(id_membro))*100)/3",
"format": "numero",
"decimals": 1,
"suffix": "%",
"icon": "📊",
"color": "#2c3e50"
},
{
"title": "NÍVEL DE COMPLETUDE",
"value": "CALC:round((((COUNT(id_membro where cpf_membro IS NOT NULL AND cpf_membro != \"\")/COUNT(id_membro))*100 + (COUNT(id_membro where telefone_membro IS NOT NULL AND telefone_membro != \"\")/COUNT(id_membro))*100 + (COUNT(id_membro where id_rua IS NOT NULL AND id_rua != \"\" AND numero_membro IS NOT NULL AND numero_membro != \"\")/COUNT(id_membro))*100)/3))",
"format": "texto",
"icon": "🏆",
"color": "#f1c40f"
}
]
}
]
}
}
}
},
"url_documentacao": "/docs/ondevou-db-membros.html",
"nome_tabela": "membros"
}
