# JSON global para el control de cobranza 
## `aún en implementacion 2/5/2024`
{
    "transaccion":"",
    "freporte":"",
    "casegurado":"",
    "mpago":"",
    "mpagoext":"",
    "ptasamon":"",
    "cprog":"",
    "ifuente":"",
    "iestado":"",
    "cusuario":"",
    "positiveBalance": false,
    "diference": false,
    "reciboConDiferencia":{          //objet Admin
        "mdiferencia":"",
        "mdiferenciaext":"",
        "xobservacion":"",
        "casegurado":"",
        "fingreso":"",
        "iestado":"",
        "crecibo":"",
        "freporte":"",
        "idiferencia":"",
        "cmoneda":""
    },
    "balancePositivo":{          //objet Admin
        "cmoneda_dif":"",
        "msaldodif":"",
        "idiferencia":""
    },
    "recibo":[
        {
            "cnpoliza": "",
            "cnrecibo": "",
            "crecibo": "",
            "cpoliza": "",
            "fanopol": "",
            "fmespol": ""  ,
            "cramo": "",
            "cmoneda": "",
            "fdesde_pol": "",
            "fhasta_pol": "",
            "fdesde_rec": "",
            "fhasta_rec": "",
            "mprimabruta": ""  ,
            "mprimabrutaext": "",
            "cproductor": "",
            "cuotas": "",
            "asegurado": ""
        }
    ],
    "soporte":[
        {
       "npago" : "",
       "cmoneda" : "",
       "cbanco" : "",
       "cbanco_destino" : "",
       "ctipopago" : "",
       "mpago" : "",
       "mpagoext" : "",
       "mpagoigtf" : "",
       "mpagoigtfext" : "",
       "mtotal" : "",
       "mtotalext" : "",
       "ptasaref" : "",
       "xreferencia" : "",
       "ximage" : ""
        }
    ]
    
}


# JSON cotizacion/emision automovil
{
  "cpais": 58,
  "cusuario": 355,
  "tasa" : 36.50,
  "cprog" : "Emi_Auto",
  "ifuente" : "WebSys",
  "csucur" : 1,
  "cramo" : 18,
  "persona": {
    "icedula": "V",
    "cci_rif":442,
    "xrif_cliente": 7198451,
    "xnombre": "JOSE",
    "xapellido": "BETANCOURT",
    "fnacimiento": "1961-09-08T00:00:00.000Z",
    "xtelefono_emp": "0424-3380979",
    "email": "betancourt_seguros@hotmail.com",
    "cestado": { "id": 5, "nombre": "Aragua" },
    "cciudad": { "id": 887, "nombre": "Girardot (Marac" },
    "iestado_civil": "D",
    "isexo": "M",
    "xdireccion": "CALLE CALLEJON FERNANDO OYOLA"
  },
  "vehiculo": {
    "ccotizacion": "",
    "cinspeccion": "",
    "xplaca": "ty4jkty",
    "xmarca": { "id": 75, "nombre": "PEUGEOT" },
    "xmodelo": { "id": 3, "nombre": "PARTNER" },
    "xversion": {
      "id": 0,
      "nombre": "Panel - Sincronico",
      "npasajero": 2,
      "cclasificacion": "K ",
      "id_inma": 62200,
      "msum": 9909.38,
      "xtipovehiculo": null,
      "ctarifa_exceso": null,
      "xuso": null,
      "npesovacio": 1055,
      "ncapcarga": 800
    },
    "fano": 2018,
    "xtipovehiculo": "",
    "xcolor": { "id": 4, "nombre": "VERDE" },
    "xserialcarroceria": "8yt4k8yt4k564ytk",
    "xserialmotor": "rt4j5tj45rtj4",
    "ctarifa_exceso": { "id": "1", "nombre": "Hasta 800 kg. de peso" },
    "cuso": "",
    "cusoVeh": "",
    "xuso": { "nombre": "PARTICULAR" },
    "precargo": { "id": 4, "nombre": "PARTICULARES" },
    "ctipovehiculo": { "id": 4, "nombre": "PARTICULARES" },
    "cclase": "",
    "id_inma": 62200,
    "npesovacio": 1055,
    "ncapcarga": 800
  },
  "plan": {
    "cplan": { "id": "Auto", "nombre": "Plan 5.000$ (RCV,EL,DP,APOV, CLUB PLUS)" , "cmoneda" : "$" },
    "msuma_aseg": 9909.38,
    "pdescuento": 0,
    "precarga": 0,
    "mcatastrofico": 9.90938,
    "mmotin": 87.202544,
    "msuma_blindaje": 9909.38,
    "msuma_aseg_acce": 0,
    "paditamento": null,
    "msuma_aditamento": 0,
    "mprima_aditamento": 0,
    "xcobertura": "Cobertura Amplia",
    "ctarifa" : "5",
    "ccober" : "6"
  },
  "recibo": {
    "xpago": "",
    "femision": "",
    "fdesde": "2024-06-19",
    "fhasta": "2025-06-19",
    "cmetodologiapago": { "id": 5, "nombre": "ANUAL" },
    "ctipopago": "",
    "fcobro": "",
    "mprima_pagada": "",
    "mprima_accesorio": "",
    "irecibo": "",
    "ccorredor": { "id": 0, "nombre": "LA MUNDIAL DE SEGUROS" },
    "xcorredor": "",
    "ctomador": { "id": 26, "nombre": "servimex aduana c.a." },
    "xtomador": "",
    "icedula_tomador": "",
    "xrif_tomador": "",
    "cestado_tomador": "",
    "cciudad_tomador": "",
    "xemail_tomador": "",
    "xdireccion_tomador": "",
    "xzona_postal_tomador": "",
    "xtelefono_tomador": ""
  }
}

//objeto de codigos 
{
  cpoliza: '1800000000001790',
  cnpoliza: '18-1-100000515',
  crecibo: '1800000000003074',
  cproces: '202400004267'
}


# Comando para generar los modelos 
sequelize-auto -o "./src/model" -c 'sequelize-auto-config.cjs'

# Archivo .cjs
const SequelizeAuto = require('sequelize-auto');

const auto = new SequelizeAuto(process.env.NAME_BD', process.env.USER_BD, process.env.PASSWORD_BD, {
    host: process.env.SERVER_BD,
    dialect:'mssql',
    dialectOptions: {
        options: {
            encrypt: true,
            trustServerCertificate: true
        }
    }
})

auto.run();