class ParametrizacaoDaDespesa < ActiveRecord::Migration[4.2] def change sempre_despesa_pessoal = ['31204100','31204300','31209200','31220400','31221100','31221300', '31221600','31229200','31229600','31304100','31304300','31309200','31320400','31320500', '31320700','31321100','31321300','31321600','31329200','31329600','31404100','31404300', '31409200','31420400','31420500','31420700','31421100','31421300','31421600','31429200', '31429600','31504100','31504300','31509200','31704100','31704300','31709200','31717000', '31719200','31720400','31720500','31720700','31721100','31721300','31721600','31729200', '31729600','31737000','31739200','31747000','31749200','31754100','31754300','31759200', '31764100','31764300','31769200','31800400','31804100','31809200','31900100','31900300', '31900400','31900500','31900700','31901100','31901300','31901600','31904700','31906700', '31909100','31909200', '31909600''31910400','31911300','31919100','31919200','31919600', '31950400','31950700','31951100','31951300','31951600','31959100','31959200','31959600', '31960400','31960700','31961100','31961300','31961600','31966700','31969100','31969200', '31969600'] geralmente_sim_despesa_pessoal = [ '33223400', '33323400', '33423400','33723400', '33803400', '33903400','33953400','33963400'] geralmente_nao_despesa_pessoal = ['33200100','33200300','33209200','33220400','33220800', '33221300','33221400','33224600','33224700','33224900','33229200','33309200','33319200', '33320400','33320800','33321300','33321400','33324600','33324700','33324900','33329200', '33359200','33409200','33419200','33420400','33420800','33421300','33421400','33421900', '33424600','33424700','33424900','33429200','33459200','33469200','33501400','33504700', '33509200','33609200','33709200','33719200','33720400','33720800','33721300','33721400', '33724600','33724700','33724900','33729200','33739200','33749200','33759200','33769200', '33800400','33801400','33809200','33900100','33900300','33900400','33900800','33901300', '33901400','33901900','33904600','33904700','33904900','33905900','33906700','33909100', '33909200','33910400','33911300','33914700','33919200','33939200','33949200','33950400', '33950800','33951300','33951400','33951900','33954600','33954700','33954900','33956700', '33959200','33960400','33960800','33961300','33961400','33961900','33964600','33964700', '33964900','33966700','33969200'] sempre_despesa_financeira = ['32717000','32719200','32737000','32739200','32747000','32749200', '32902100','32902200','32902300','32902400','32902500','32902700','32909100','32909200', '32909300','32912100','32912200','32919100','32919200','32919300','32952100','32952200', '32959200','32962100','32962200','32969200','33902800','33902900','45426400','45426600', '45506600','45726400','45726500','45726600','45906300','45906400','45906500','45906600', '45906700','45907100','45916300','45916400','45916500','45916600','45917100','46717000', '46719200','46737000','46739200','46747000','46749200','46907100','46907200','46907300', '46907400','46907500','46907600','46907700','46909100','46909200','46909300','46917100', '46917300','46919100','46919200','46919300','46957100','46957300','46957400','46957500', '46957600','46957700','46959100','46959200','46959300','46967100','46967200','46967300', '46967400','46967500','46967600','46967700','46969100','46969200','46969300'] sempre_compoe_obras = [ '44225100','44325100','44425100','44725100','44905100','44915100', '44935100','44945100','44955100','44965100'] geralmente_sim_compoe_obras = [ '44229200','44329200','44429200','44729200','44919200', '44939200','44949200','44959200','44969200'] sempre_deducao_despesa_pessoal = [ '31209200','31229200','31309200','31329200','31409200', '31429200','31509200','31709200','31719200','31729200','31739200','31749200','31759200', '31769200','31809200','31909100','31909200','31909400','31909600','31919100','31919200', '31919400','31959100','31959200','31959400','32739200','31969100','31969200','31969400', '32749200','32909100','32909200','32919100','32919200','32959200','32969200','33209200', '33229200','33309200','33319200','33329200','33409100','33409200','33419200','33429200', '33459100','33459200','33469100','33469200','33509200','33609200','33709200','33719200', '33729200','33739200','33759200','33769200','33809200','33909100','33909200','33919100', '33919200','33939200','33949200','33959100','33959200','33969100','33969200'] sempre_folha_de_pagamento = [ '31900100','31901100','31901600','31910400','31951100','31951600', '31960400','31961100','31961600','33901600','33910400','33950400'] geralmente_sim_folha_de_pagamento = ['31900400','31950400','44950400'] geralmente_nao_folha_de_pagamento = ['31909600','31919600','31959600','31969600','33909600', '33959600','33969600'] sempre_despesa_magistrado = ['31320400'] geralmente_sim_despesa_magistrado = ['31204100','31204300','31209200','31220400','31220500', '31220700','31221100','31221300','31221600','31229200','31229600','31304100','31304300', '31309200','31320500','31320700','31321100','31321300','31321600','31329200','31329600', '31404100','31404300','31409200','31420400','31420500','31420700','31421100','31421300', '31421600','31429200','31429600','31504100','31504300','31509200','31704100','31704300', '31709200','31717000','31719200','31720400','31720500','31720700','31721100','31721300', '31721600','31729200','31729600','31800400','31804100','31809200','31900400','31900500', '31900700','31901100','31901300','31901600','31909100','31909200','31910400','31911300', '31919100','31919200','31919600','33221300', '33223400''33229600','33321300','33323400', '33329600','33421300','33421400','33423400','33429600','33723400','33729600','33803400', '33900500','33900700','33901300','33901600','33903400','33909600','33911300','33919600'] geralmente_nao_despesa_magistrado = ['33209200','33220400','33220800','33221400','33224600', '33224900','33229200','33309200','33319200','33320400','33320800','33321400','33324600', '33324900','33329200','33409100','33409200','33419200','33420400','33420800','33421900', '33424600','33424900','33429200','33501400','33509200','33609200','33709200','33719200', '33720400','33720800','33721300','33721400','33721900','33724600','33724900','33729200', '33800400','33801400','33809200','33900800','33901400','33901900','33904600','33904900', '33909200','33910400','33919100','33919200'] sempre_transferencia_intraorcamentaria = ['31919100','31919200','31919400','31919600','32912100', '32912200','32919100','32919200','32919300','33910400','33911300','33912800','33912900', '33913000','33913200','33913500','33913900','33914700','33916200','33919100','33919200', '33919300','33919600','33919700','44913000','44913500','44913900','44914700','44915100', '44915200','44916100','44919100','44919200','44919300','45914700','45916100','45916200', '45916300','45916400','45916500','45916600','45917100','45919100','45919200','45919300', '46917100','46917300','46919100','46919200','46919300'] sempre_deducao_pasep = ['31904700','33204700','33224700','33324700','33424700','33504700', '33724700','33904700','33914700','33954700','33964700','44224700','44424700','44724700', '44904700','44914700','45224700','45324700','45424700','45724700','45914700'] sempre_contabil_obrigatorio = ['31906700','31909100','31909400','31919100','31956700','31959100', '31959400','31966700','31969100','31969400','32909100','32909300','32919100','32919300', '33209300','33309300','33329300','33409100','33409300','33429300','33459100','33469100', '33906700','33909100','33909300','33916200','33919100','33919300','33939300','33949300', '33956700','33959100','33959300','33966700','33969100','33969300','44225100','44225200', '44229300','44325100','44325200','44329300','44425100','44425200','44725100','44725200', '44729300','44905100','44905200','44906100','44909100','44915100','44915200','44916100', '44919100','44919300','44935100','44935200','44936100','44939300','44945100','44945200', '44946100','44949300','44955100','44955200','44956100','44959100','44959300','44965100', '44965200','44966100','44969100','44969300','45326100','45326500','45326600','45426400', '45506600','45726100','45726400','45726500','45726600','45906100','45906200','45906300', '45906400','45906500','45906600','45906700','45907100','45909100','45909300','45916100', '45916200','45916300','45916400','45916500','45916600','45917100','45919100','45919300', '45956100','45956700','45959100','45959300','45966100','45966700','45969100','45969300', '46907100','46907200','46907600','46907700','46909100','46909300','46917100','46919100', '46919300','46957100','46957600','46957700','46959100','46959300','46967100','46967200', '46967600','46967700','46969100','46969300'] Base::ElementoDeDespesa.all.each do |elemento| if sempre_despesa_pessoal.include?(elemento.codigo) elemento.despesa_pessoal = 1 end if geralmente_sim_despesa_pessoal.include?(elemento.codigo) elemento.despesa_pessoal = 3 end if geralmente_nao_despesa_pessoal.include?(elemento.codigo) elemento.despesa_pessoal = 2 end if sempre_despesa_financeira.include?(elemento.codigo) elemento.despesa_financeira = 1 end if sempre_compoe_obras.include?(elemento.codigo) elemento.compoe_obras = 1 end if geralmente_sim_compoe_obras.include?(elemento.codigo) elemento.compoe_obras = 3 end if sempre_deducao_despesa_pessoal.include?(elemento.codigo) elemento.deducao_despesa_pessoal = 1 end if sempre_folha_de_pagamento.include?(elemento.codigo) elemento.folha_de_pagamento = 1 end if geralmente_sim_folha_de_pagamento.include?(elemento.codigo) elemento.folha_de_pagamento = 3 end if geralmente_nao_folha_de_pagamento.include?(elemento.codigo) elemento.folha_de_pagamento = 2 end if sempre_despesa_magistrado.include?(elemento.codigo) elemento.despesa_da_educacao = 1 end if geralmente_sim_despesa_magistrado.include?(elemento.codigo) elemento.despesa_da_educacao = 3 end if geralmente_nao_despesa_magistrado.include?(elemento.codigo) elemento.despesa_da_educacao = 2 end if sempre_transferencia_intraorcamentaria.include?(elemento.codigo) elemento.despesa_pessoal = 1 end if sempre_deducao_pasep.include?(elemento.codigo) elemento.deducao_pasep = 1 end if sempre_contabil_obrigatorio.include?(elemento.codigo) elemento.contabil_obrigatorio = 1 end elemento.save(validate: false) end end end