Changeset c9dd3b4 in observatorio for simulacion/ModuloDinamico

Timestamp:

Jan 20, 2015, 5:39:07 PM (9 years ago)

Author:

Alejandro <amujica@…>

Branches:

simulacion

Children:

a0523b8

Parents:

d7bfb1f

Message:

Funcionalidad para que cuando no haya declaracion de empleados de una empresa menor o igual al ano en estudio, tome en cuenta el proxino ano superior

File:

• simulacion/ModuloDinamico/queries.C (modified) (1 diff)

simulacion/ModuloDinamico/queries.C

@@ -698 +698 @@
 
   if (not query.next())
-    return std::tuple<real, real, real>(0.0, 0.0, 0.0);
+    {
+      query.clear();
+      str_query.clear();
+
+      str_query.addSelect(DB::ADMINISTRATIVE);
+      str_query.addSelect(DB::OPERATING);
+      str_query.addSelect(DB::WORKDAY);
+
+      str_query.addFrom(DB::COMPANY_OCCUPANCY_TABLE_NAME);
+
+      str_query.addWhere(op(DB::COMPANY_RIF, single_quote(rif)));
+      str_query.addWhere(op(DB::ACTIVE, "TRUE"));
+      str_query.addWhere(op(DB::INSERTION_DATE, single_quote(max_date), ">"));
+
+      str_query.addOrderBy(DB::INSERTION_DATE);
+
+      str_query.setOrderByOption("ASC");
+
+      if (not query.exec(str_query))
+        {
+          std::string msg = "Cannot execute query: " + std::string(str_query);
+          throw std::logic_error(msg);
+        }
+
+      if (not query.next())
+        return std::tuple<real, real, real>(0.0, 0.0, 0.0);
+    }
 
   real administrative = std::atof(query.getValue(0));