source: observatorio/simulacion/SimEscenariosEconomicos/common.C

/*
  Copyright (C) 2012
  Alejandro Mujica (amujica@cenditel.gob.ve)
  Erwin Paredes (eparedes@cenditel.gob.ve)
  José Ruiz (jruiz@cenditel.gob.ve)
  Rodolfo Rangel (rrangel@cenditel.gob.ve)
  Julie Vera (jvera@cenditel.gob.ve)
 
  CENDITEL Fundación Centro Nacional de Desarrollo e Investigación en
  Tecnologías Libres
 
  Este programa es software libre; Usted puede usarlo bajo los términos de la
  licencia de software GPL versión 2.0 de la Free Software Foundation.
 
  Este programa se distribuye con la esperanza de que sea útil, pero SIN
  NINGUNA GARANTÍA; tampoco las implícitas garantías de MERCANTILIDAD o
  ADECUACIÓN A UN PROPÓSITO PARTICULAR.
  Consulte la licencia GPL para más detalles. Usted debe recibir una copia
  de la GPL junto con este programa; si no, escriba a la Free Software
  Foundation Inc. 51 Franklin Street,5 Piso, Boston, MA 02110-1301, USA.
*/

/*
  Autor:             Alejandro J. Mujica
  Fecha de creación: 22/07/2013
  Este archivo contiene asignaciones de valores a constantes e implementación
  de funciones y algunos tipos de datos utilitarios.
*/

# include <ctime>
# include <cassert>
# include <cstring>

# include <common.H>
# include <queries.H>

const std::string DB::PRODUCT_TABLE_NAME = "produccion_producto";

const std::string DB::INPUT_TABLE_NAME = "produccion_insumo";

const std::string DB::PLANT_TABLE_NAME = "unidadecon_subunidad_economica";

const std::string DB::COMPANY_TABLE_NAME = "unidadecon_unidad_economica";

const std::string DB::COMPANY_ACTIVITY_CIIU_TABLE_NAME =
    "unidadecon_actividad_ciiu";

const std::string DB::PRODUCT_INPUT_TABLE_NAME = "produccion_producto_t_insumo";

const std::string DB::MEASUREMENT_UNIT_TABLE_NAME = "comun_unida_medida";

const std::string DB::INPUT_SUPPLIER_TABLE_NAME =
    "cmproveedores_proveedorinsumo";

const std::string DB::SUPPLIER_TABLE_NAME = "cmproveedores_proveedor";

const std::string DB::PRODUCTION_QUANTITIES_TABLE_NAME =
    "produccion_produccion_precios_r";

const std::string DB::ACQ_PRICE_TABLE_NAME = "produccion_consumo_precios_r";

const std::string DB::COUNTRY_TABLE_NAME = "comun_pais";

 const std::string DB::PARISH_TABLE_NAME = "comun_parroquia";

const std::string DB::TOWN_TABLE_NAME = "comun_municipio";

const std::string DB::STATE_TABLE_NAME = "comun_entidad";

const std::string DB::COMPANY_OCCUPANCY_TABLE_NAME =
    "unidadecon_personal_ocupado";

const std::string DB::ID = "id";

const std::string DB::NAME = "nombre";

const std::string DB::COMPANY_NAME = "razon_social";

const std::string DB::TECHNICAL_SPECIFICATION = "esp_tec";

const std::string DB::TARIFF_CODE = "codigo_aran_id";

const std::string DB::MEASUREMENT_UNIT_ID = "unidad_medida_id";

const std::string DB::TRADEMARK = "marca";

const std::string DB::PLANT_ID = "planta_id_id";

const std::string DB::CODE = "codigo";

const std::string DB::PARISH_CODE = "parroquia_codigo";

const std::string DB::TOWN_CODE = "municipio_codigo";

const std::string DB::STATE_CODE = "entidad_codigo";

const std::string DB::COMPANY_RIF = "unidad_economica_rif";

const std::string DB::UE_RIF = "ue_rif";

const std::string DB::RIF = "rif";

const std::string DB::NATIONALITY = "nacional";

const std::string DB::ACQ_PRICE = "cost_adq";

const std::string DB::NAC_ACQ_PRICE = "prec_adq_nac";

const std::string DB::CIIU_ID = "ciiu_id";

const std::string DB::ACTIVE = "activo";

const std::string DB::MAIN = "principal";

const std::string DB::INPUT_ID = "insumo_id_id";

const std::string DB::PRODUCT_ID = "producto_id_id";

const std::string DB::SUPPLIER_ID = "proveedor_id_id";

const std::string DB::PRODUCED_QUANTITY = "cant_producido";

const std::string DB::PRICE = "precio_venta";

const std::string DB::BOUGHT_QUANTITY = "cantidad_comprada_r";

const std::string DB::QUANTITY = "cantidad";

const std::string DB::ORIG_COUNTRY_ID= "pais_origen_id";

const std::string DB::PROC_COUNTRY_ID = "pais_procedencia_id";

const std::string DB::YEAR_R = "anho_r";

const std::string DB::YEAR = "anho";

const std::string DB::USED_CAPACITY = "capacidad_utilizada";

const std::string DB::INSERTION_DATE = "fecha_insercion";

const std::string DB::OPERATING = "operativo";

const std::string DotColor::COLORS[] = {
    "black",
    "blue",
    "darkolivegreen",
    "blueviolet",
    "brown",
    "indigo",
    "orangered",
    "steelblue",
    "seagreen",
    "hotpink",
    "magenta",
    "purple",
    "red",
    "darkslategray",
    "midnightblue"
};

const std::string & DotColor::operator () (const size_t & i) {
    if (i >= DotColor::NUM_COLORS)
        throw std::overflow_error("i is greater than num_colors");

    return DotColor::COLORS[i];
}

ProductInfo::ProductInfo()
    : plantId(-1), plantName("NULL"), usedCapacity(0), INIT_COMPANY_ATTRS,
      productId(-1), INIT_GOOD_ATTRS {

    // Empty
}

InputInfo::InputInfo()
    : INIT_COMPANY_ATTRS, id(-1), INIT_GOOD_ATTRS {
    // Empty
}

ProductInfo inputToProduct(const InputInfo & input) {
    ProductInfo product;

    product.name = input.name;
    product.technicalSpecifications = input.technicalSpecifications;
    product.tariffCode = input.tariffCode;
    product.measurementUnit = input.measurementUnit;
    product.trademark = input.trademark;
    product.companyRif = input.companyRif;
    product.companyName = input.companyName;
    product.quantity = input.quantity;
    product.totalQuantity = input.totalQuantity;
    product.nationality = input.nationality;
    product.origCountry = input.origCountry;
    product.procCountry = input.procCountry;

//    product.origCountry = getOrigCountry(product.companyRif);
//    product.procCountry = getProcCountry(product.companyRif);

    return product;
}

AlterInfo::AlterInfo()
    : numNode(-1), value(0) {

    // Empty
}

PlantLocation::PlantLocation()
    : parish(""), town(""), state("") {

    // Empty
}

std::string numtostrRec(const long long & num, const char & thousandSep) {

    if (num < 1000) {

        std::stringstream sstr;

        sstr << num;

        return sstr.str();
    }

    real aux = real(num) / 1000.0;

    long long intPart = (long long) aux;

    aux -= intPart;

    long long extract = aux * 1000;

    std::stringstream sstr;

    sstr << extract;

    std::string str = sstr.str();

    if (extract < 100.0L) {
        str = "0" + str;
    }

    if (extract < 10.0L) {
        str = "0" + str;
    }

    return numtostrRec(intPart, thousandSep) + thousandSep + str;
}

std::string numtostr(const real & _num, const int & numDec,
                     const char & thousandSep, const char & decSep) {

    std::string sign = _num < 0.0L ? "-" : "";

    real num = std::fabs(_num);

    real numRound = std::pow(10, numDec);

    num *= numRound;

    num = std::round(num);

    num /= numRound;

    long long intPart = (long long) num;

    real dec = num - intPart;

    if (dec < 1e-5)
        dec = 0;

    char buffer[256];

    sprintf(buffer, "%g", dec);

    std::string strDec = buffer;

    std::string ret = numtostrRec(intPart, thousandSep);

    if (strDec.size() > 2)
        ret += decSep +  strDec.substr(2, strDec.size() - 2);

    return sign + ret;
}

void modStr(std::string & str) {

    size_t pos;

    while ((pos = str.find('<')) != std::string::npos)
        str.replace(pos, 1, "&lt;");

    while ((pos = str.find('>')) != std::string::npos)
        str.replace(pos, 1, "&gt;");

    for (size_t i = 0; i < str.size(); ++i) {

        if (str[i] == '\"') {
            str.replace(i, 1, "\\\"");
            ++i;
        }
        else if (str[i] == '\n') {
            str.replace(i, 1, "\\n");
            ++i;
        }
    }
}

std::string currentTime()
{
  time_t now = time(0);

  struct tm * st_now = localtime(&now);

  std::stringstream sstr;

  sstr << st_now->tm_mday << "/" << st_now->tm_mon + 1 << "/"
       << st_now->tm_year + 1900 << " " << st_now->tm_hour << ":"
       << st_now->tm_min << ":" << st_now->tm_sec;

  return sstr.str();
}