[
{
"operation": "modify-overwrite-beta",
"spec": {
"items": {
"*": {
"codigoNcm_": "=split('\\.', @(1,codigoNcm))",
"codigo_Ncm": "=join('', @(1,codigoNcm_))",
"CEMcodigo_Ncm2": 100"=substring(@(1,codigo_Ncm),0,8)",
"idExterno": "=concat('pdvsync-piscofinsncm-', @(1,codTribPisCofinsid),'-', @(1,dtUltAltdataUltimaAtualizacao))",
/* JOLT não possui uma função nativa para multiplicar valores. */
"chave": null,
"fonte": null,
/* mas tem como multiplicar usando dessa forma: */ "situacao": 1,
/* https://intercom.help/godigibee/en/articles/4239806-transformations-with-jolt Nacional*/
"valorInversoaliquotaNacional_str": "=dividetoString(1, @(1,CEMaliquotaNacional))",
"aliquotaPisPercentualaliquotaNacional_arr": "=divideAndRound(4, split('\\.',@(1,aliquotaPis), @(1,valorInversoaliquotaNacional_str))",
"aliquotaCofinsPercentualaliquotaNacional": "=divideAndRoundjoin(4, @(1,aliquotaCofins), ',',@(1,valorInversoaliquotaNacional_arr))",
/*Estadual* Percentuais para string *//
"aliquotaEstadual_str": "=toString(@(1,aliquotaEstadual))",
"aliquotaPisPercentualStraliquotaEstadual_arr": "=toString(split('\\.',@(1,aliquotaPisPercentualaliquotaEstadual_str))",
"aliquotaCofinsPercentualStraliquotaEstadual": "=toStringjoin(',',@(1,aliquotaCofinsPercentualaliquotaEstadual_arr))",
/*Importada*/
Separar as casas decimais pelo o '.' para remover o ponto*/ "aliquotaImportada_str": "=toString(@(1,aliquotaImportada))",
"aliquotaPisPercentualArraliquotaImportada_arr": "=split('\\.',@(1,aliquotaPisPercentualStraliquotaImportada_str))",
"aliquotaCofinsPercentualArraliquotaImportada": "=splitjoin('\\.,',@(1,aliquotaCofinsPercentualStraliquotaImportada_arr))",
/*Juntar as casas decimais usando virgula*/*Municipal*/
"aliquotaMunicipal_str": "=toString(@(1,aliquotaMunicipal))",
"aliquotaPisaliquotaMunicipal_arr": "=joinsplit(',\\.', @(1,aliquotaPisPercentualArraliquotaMunicipal_str))",
"aliquotaCofinsaliquotaMunicipal": "=join(',', @(1,aliquotaCofinsPercentualArraliquotaMunicipal_arr))"
}
}
}
},
{
"operation": "shift",
"spec": {
"items": {
"*": {
"idExterno": "idExterno[&1]",
"cstid": "items[&1].idRetaguarda",
"codigo_Ncm2": "items[&1].[0].cstPis",codigoNcm",
"codigoExcecao": "items[&1].codigoExcecao",
"aliquotaNacional": "items[&1].[0].cstCofins"]aliquotaNacional",
"aliquotaEstadual": "items[&1].aliquotaEstadual",
"aliquotaPiscodigoCest": "items[&1].[0].aliquotaPiscodigoCest",
"aliquotaImportada": "items[&1].aliquotaImportada",
"aliquotaCofinsaliquotaMunicipal": "items[&1].[0].aliquotaCofinsaliquotaMunicipal",
"chave": "items[&1].chave",
"codTribPisCofinsfonte": "items[&1].[0].idRetaguardafonte",
"situacao": "items[&1].situacao"
}
}
}
},
{
"operation": "default",
"spec": {
"_attr_access": "items",
"items[]": {
"*[]": {
"*": {
"idInquilino": "{{ID_INQUILINO}}",
"idProprietario": "{{MASTER_ID_PROPRIETARIO}}",
"loteOrigem": "{{LOTE_ORIGEM}}",
"situacao": 1
}
}
}
}
}
] |