This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO AccountingBalanceSheet(id_balanco_contabil, id_empresa, tipo_balanco, dt_saldo, stat_fechamento, stat_primeira_abertura, stat_abertura_provisoria, stat) SELECT id_balanco, id_empresa, CASE tipo_balanco WHEN '0' then 'A' WHEN '1' then 'E' WHEN '2' then 'N' END AS tipo_balanco, dt_saldo, IF(status_fechamento = 1, '1', '0'), IF(primeiro_lancamento = 1, '1', '0'), IF(provisoria = 1, '1', '0'), stat FROM con_balanco; | |
INSERT INTO AccountingBalanceSheetAccountBalance(id_balanco_contabil_conta_contabil_saldo, id_balanco_contabil, id_conta_contabil, id_conta_contabil_funcao, conta_saldo, stat) SELECT id_balanco_saldo, id_balanco, id_conta_interno, null, saldo_conta, stat FROM con_balanco_saldo WHERE id_conta_interno > 2078; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO AccountingBalanceSheetTechnicalEntity(des, stat) SELECT des, stat FROM con_entidade_tecnica; | |
INSERT INTO `AccountingBalanceSheetSubscriberQualification` (cod, des, stat) VALUES | |
(203,'DIRETOR',1), | |
(204,'CONSELHEIRO DE ADMINISTRACAO',1), | |
(205,'ADMINISTRADOR',1), | |
(206,'ADMINISTRADOR DO GRUPO',1), | |
(207,'ADMINISTRADOR DE SOCIEDADE FILIADA',1), | |
(220,'ADMINISTRADOR JUDICIAL - PESSOA FISICA', 1), | |
(222,'ADMINISTRADOR JUDICIAL - PESSOA JURIDICA - PROFISSIONAL RESPONSAVEL',1), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO `AccountingTransactionDescriptionProfile`(`id_descricao_transacao_contabil`,`id_perfil`) | |
VALUES ((SELECT 1 FROM AccountingTransactionDescription where des = 'MIGRACAO DE DADOS'),117); | |
INSERT INTO AccountingTransactionDescriptionEnvironment(id_descricao_transacao_contabil, id_empresa) SELECT | |
id_descricao_transacao_contabil , | |
id_empresa | |
FROM | |
AccountingTransactionDescription | |
LEFT JOIN erp_empresa e ON 1 = 1 | |
WHERE e.stat <> 0; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELETE FROM AccountingTransactionDescriptionProfile; | |
INSERT INTO AccountingTransactionDescriptionProfile (id_descricao_transacao_contabil, id_perfil) SELECT | |
id_descricao_transacao_contabil, p.id_perfil | |
FROM | |
AccountingTransactionDescription | |
LEFT JOIN | |
erp_perfil p ON 1 = 1 | |
WHERE | |
p.id_perfil IN (62 , 146, 120, 117); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELETE FROM AccountingTransactionItem | |
WHERE | |
id_transacao_contabil IN (SELECT | |
id_transacao_contabil | |
FROM | |
dev_gestorfox.AccountingTransaction | |
WHERE | |
id_descricao_transacao_contabil = 79); | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE AccountingTransactionDescriptionMainData SET stat = 2 where des = 'ENCERRAMENTO ANUAL'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO Tag | |
( | |
id_tabela_sistema_tabela_sistema_tag, | |
id_registro_tabela_sistema_aplicacao, | |
id_registro_tabela_sistema_tag | |
) | |
SELECT | |
stst.id_tabela_sistema_id_tabela_sistema_tag, | |
act.id_transacao_contabil, | |
act.id_parceiro_principal |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO Tag | |
( | |
id_tabela_sistema_tabela_sistema_tag, | |
id_registro_tabela_sistema_aplicacao, | |
id_registro_tabela_sistema_tag | |
) | |
SELECT | |
stst.id_tabela_sistema_id_tabela_sistema_tag, | |
act.id_transacao_contabil, | |
act.id_parceiro_operacional |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Culpa da Suellyn | |
tmpfs /dev devtmpfs,tmpfs mode=0755,size=9G 0 0 | |
tmpfs /dev/shm devtmpfs,tmpfs mode=0755,size=13G 0 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ORDER BY i.dt_inicial DESC, (i.id_usuario_qualidade_documento_previsto = 123) DESC, (i.id_usuario_qualidade_pesquisa_previsto = 123) DESC |
OlderNewer