[
{
"operation": "modify-overwrite-beta",
"spec": {
"items": {
"*": {
"CEMcodigoNcm_": 100,
"idExterno": "=concatsplit('pdvsync-piscofins-\\.', @(1,codTribPisCofins),'-', @(1,dtUltAlt))",
/* JOLT não possui uma função nativa para multiplicar valores. */
/* mas tem como multiplicar usando dessa forma: */
codigoNcm))",
/* https://intercom.help/godigibee/en/articles/4239806-transformations-with-jolt */
"valorInverso"codigo_Ncm": "=dividejoin(1'', @(1,CEMcodigoNcm_))",
"aliquotaPisPercentualidExterno": "=divideAndRound(4concat('pdvsync-ncm-', @(1,aliquotaPisid),'-', @(1,valorInversodataUltimaAtualizacao))",
"aliquotaCofinsPercentualaliquotaImportada": "=divideAndRound(4, @(1,aliquotaCofins), @(1,valorInverso))",
/* Percentuais para string */"aliquotaMunicipal": "",
"aliquotaPisPercentualStrchave": "=toString(@(1,aliquotaPisPercentual))"null,
"aliquotaCofinsPercentualStrfonte": "=toString(@(1,aliquotaCofinsPercentual))"null,
/* Separar as casas decimais pelo o '.' para remover o ponto*/"situacao": 1
}
}
}
},
{
"aliquotaPisPercentualArroperation": "=split('\\.',@(1,aliquotaPisPercentualStr))shift",
"spec": {
"aliquotaCofinsPercentualArritems": "=split('\\.',@(1,aliquotaCofinsPercentualStr))",{
/*Juntar as casas decimais usando virgula*/"*": {
"aliquotaPisidExterno": "=join(',', @(1,aliquotaPisPercentualArr))idExterno[&1]",
"aliquotaCofinsid": "=join(',', @(1,aliquotaCofinsPercentualArr))"items[&1].[0].idRetaguarda",
}
}
"codigo_Ncm": "items[&1].[0].codigoNcm",
}
},
{
"operationcodigoExcecao": "shiftitems[&1].[0].codigoExcecao",
"spec": {
"aliquotaNacional": "items": {
[&1].[0].aliquotaNacional",
"*aliquotaEstadual": {"items[&1].[0].aliquotaEstadual",
"idExternocodigoCest": "idExternoitems[&1].[0].codigoCest",
"cstaliquotaImportada": ["items[&1].[0].cstPisaliquotaImportada",
"aliquotaMunicipal": "items[&1].[0].cstCofinsaliquotaMunicipal"],
"aliquotaPischave": "items[&1].[0].aliquotaPischave",
"aliquotaCofinsfonte": "items[&1].[0].aliquotaCofinsfonte",
"codTribPisCofinssituacao": "items[&1].[0].idRetaguardasituacao"
}
}
}
},
{
"operation": "default",
"spec": {
"_attr_access": "items",
"items[]": {
"*[]": {
"*": {
"idInquilino": "{{ID_INQUILINO}}",
"idProprietario": "{{MASTER_ID_PROPRIETARIO}}",
"loteOrigem": "{{LOTE_ORIGEM}}",
"situacao": 1
}
}
}
}
}
] |