Pessoa to familia

src/libs/routes/SMPPIR/eixo_3.js

@@ -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({
     name: 'uf',
     table: 'quilombola_eixo_3_ag',
@@ -159,7 +171,7 @@ rqf.addField({
 
 cad_unico_count.get('/', rqf.parse(), rqf.build(), (req, res, next) => {
     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');
     next();
 }, query, response('cad_unico'));