Skip to content
Snippets Groups Projects

Pessoa to familia

Merged Rafael S Castilho requested to merge pessoa_to_familia into development
1 file
+ 13
1
Compare changes
  • Side-by-side
  • Inline
@@ -131,6 +131,18 @@ rqf.addField({
@@ -131,6 +131,18 @@ rqf.addField({
},
},
})
})
 
.addValue({
 
name:'cod_local_home',
 
table:'quilombola_eixo_3_ag',
 
tableField:'cod_local_domicilio',
 
resultField:'cod_local_domic_fam',
 
where: {
 
relation:'=',
 
type:'string',
 
field:'cod_local_domicilio',
 
},
 
})
 
.addValue({
.addValue({
name: 'uf',
name: 'uf',
table: 'quilombola_eixo_3_ag',
table: 'quilombola_eixo_3_ag',
@@ -159,7 +171,7 @@ rqf.addField({
@@ -159,7 +171,7 @@ rqf.addField({
cad_unico_count.get('/', rqf.parse(), rqf.build(), (req, res, next) => {
cad_unico_count.get('/', rqf.parse(), rqf.build(), (req, res, next) => {
console.log(req.sql.toString());
console.log(req.sql.toString());
req.sql.field('SUM(total) AS Total')
req.sql.field('COUNT(distinct id_familia) AS Total')
.from('quilombola_eixo_3_ag');
.from('quilombola_eixo_3_ag');
next();
next();
}, query, response('cad_unico'));
}, query, response('cad_unico'));
Loading