-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 8.0.30 - MySQL Community Server - GPL -- Server OS: Win64 -- HeidiSQL Version: 12.1.0.6537 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Dumping database structure for ecs CREATE DATABASE IF NOT EXISTS `ecs` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `ecs`; -- Dumping structure for table ecs.armazem_desc CREATE TABLE IF NOT EXISTS `armazem_desc` ( `id` int NOT NULL AUTO_INCREMENT, `Descrcao` varchar(50) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `Local` varchar(50) DEFAULT NULL, `Descricao` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- Dumping data for table ecs.armazem_desc: ~0 rows (approximately) INSERT INTO `armazem_desc` (`id`, `Descrcao`, `deleted_at`, `updated_at`, `created_at`, `Local`, `Descricao`) VALUES (1, 'ECS', NULL, NULL, NULL, 'ECS', 'ECS'); -- Dumping structure for table ecs.categorias CREATE TABLE IF NOT EXISTS `categorias` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `Descricao` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.categorias: ~73 rows (approximately) INSERT INTO `categorias` (`id`, `Descricao`, `deleted_at`, `created_at`, `updated_at`) VALUES (127, 'OTORINO', NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (246, 'Antbiotico', NULL, '2026-02-11 06:47:10', '2026-02-11 06:47:10'), (247, 'Antibiotico', NULL, '2026-02-11 10:54:57', '2026-02-11 10:54:57'), (248, 'Ante-Gripe', NULL, '2026-02-11 10:54:57', '2026-02-11 10:54:57'), (249, 'Multivitaminas', NULL, '2026-02-11 10:54:57', '2026-02-11 10:54:57'), (250, 'Ant-Alergico', NULL, '2026-02-11 10:54:57', '2026-02-11 10:54:57'), (251, 'Ant-Gripe', NULL, '2026-02-11 10:54:57', '2026-02-11 10:54:57'), (252, 'Ant-Inflamatorio', NULL, '2026-02-11 10:54:57', '2026-02-11 10:54:57'), (253, 'EPI', NULL, '2026-02-11 10:54:57', '2026-02-11 10:54:57'), (254, 'Testes', NULL, '2026-02-11 10:54:58', '2026-02-11 10:54:58'), (255, 'Ant-espasmodico', NULL, '2026-02-11 10:54:58', '2026-02-11 11:05:13'), (256, 'Analgesico', NULL, '2026-02-11 10:54:58', '2026-02-11 10:54:58'), (257, 'Anti-Inflamatorio', NULL, '2026-02-11 10:54:58', '2026-02-12 18:11:23'), (258, 'Genito-Urinario', NULL, '2026-02-11 10:54:58', '2026-02-11 10:54:58'), (259, 'TIG', NULL, '2026-02-11 10:54:58', '2026-02-11 10:54:58'), (260, 'Multivitamina', NULL, '2026-02-11 11:01:46', '2026-02-11 11:01:46'), (261, 'Cassete', NULL, '2026-02-11 11:01:46', '2026-02-11 11:01:46'), (262, 'Hipertensivo', NULL, '2026-02-11 11:01:46', '2026-02-11 11:01:46'), (263, 'Dermatologia', NULL, '2026-02-11 11:01:46', '2026-02-11 11:01:46'), (264, 'Diabetes', NULL, '2026-02-11 11:05:13', '2026-02-11 11:05:13'), (265, 'Lubrificanets', NULL, '2026-02-11 11:05:13', '2026-02-11 11:05:13'), (266, 'Rehidratacao', NULL, '2026-02-11 11:05:13', '2026-02-11 11:05:13'), (267, 'Anti-Gripe', NULL, '2026-02-11 11:05:13', '2026-02-12 17:36:24'), (268, 'Anti-alergico', NULL, '2026-02-11 11:08:08', '2026-02-11 11:08:08'), (269, 'Cardio Vascular', NULL, '2026-02-11 11:08:08', '2026-02-11 11:08:08'), (270, 'Anti-Diareico', NULL, '2026-02-11 11:08:08', '2026-02-11 11:08:08'), (271, 'Sangue', NULL, '2026-02-11 11:08:08', '2026-02-11 11:08:08'), (272, 'Alergias', NULL, '2026-02-11 11:08:08', '2026-02-11 11:08:08'), (273, 'Anti-Hemetico', NULL, '2026-02-11 11:08:08', '2026-02-11 11:08:08'), (274, 'Minerais', NULL, '2026-02-11 11:08:08', '2026-02-11 11:08:08'), (275, 'Sistema Nervoso', NULL, '2026-02-11 11:08:08', '2026-02-11 11:08:08'), (276, 'Anti-acido', NULL, '2026-02-11 11:08:08', '2026-02-12 17:06:59'), (277, 'Oftamologica', NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59'), (278, 'Adesivo', NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59'), (279, 'Medico Cirurgico', NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59'), (280, 'Material Cirurgico', NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59'), (281, 'Inibidoreximatico', NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59'), (282, 'Anti-Tussico', NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59'), (283, 'Antibacteriano', NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07'), (284, 'Antitussico', NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07'), (285, 'Anti-ceptico', NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07'), (286, 'Antifungico', NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07'), (287, 'Hidratante', NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07'), (288, 'Antigripe', NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07'), (289, 'Hormona', NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24'), (290, 'Esteroides', NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24'), (291, 'Corticosteroide', NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24'), (292, 'Vitamina', NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24'), (293, 'Antiemetico', NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23'), (294, 'Laxante', NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23'), (295, 'Anti-fungico', NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23'), (296, 'Atibiotico', NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23'), (297, 'Gastrointestinal', NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23'), (298, 'Desparasitante', NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23'), (299, 'Solucao Oral', NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36'), (300, 'Preservativo', NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36'), (301, 'Abortivo', NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36'), (302, 'Anestesico', NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36'), (303, 'Antimalarico', NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36'), (304, 'Colirio', NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14'), (305, 'Antiabetico', NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14'), (306, 'Contraceptivo', NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14'), (307, 'Desinfectante', NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14'), (308, 'Antihipertensivo', NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14'), (309, 'Cicatrizante', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'), (310, 'Anti-Hemoroidal', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'), (311, 'Relaxante', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'), (312, 'Hidratacao', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'), (313, 'Antiepiletico', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'), (314, 'Inibidorenzimatico', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'), (315, 'Acido', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'), (316, 'Higiene Intima', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'), (317, 'Estimulante', NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46'); -- Dumping structure for table ecs.categorias_despesa CREATE TABLE IF NOT EXISTS `categorias_despesa` ( `id` int NOT NULL AUTO_INCREMENT, `nome` varchar(50) NOT NULL, `descricao` text, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `tipo` enum('variavel','fixa') DEFAULT 'fixa', `is_active` tinyint DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `nome` (`nome`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table ecs.categorias_despesa: ~4 rows (approximately) INSERT INTO `categorias_despesa` (`id`, `nome`, `descricao`, `created_at`, `updated_at`, `tipo`, `is_active`) VALUES (2, 'Energia', 'Conta de energia elétrica', '2025-07-09 02:56:17', '2025-07-13 14:23:33', 'fixa', 1), (3, 'Água', 'Conta de água e esgoto', '2025-07-09 02:56:17', '2025-07-09 02:56:17', 'fixa', 1), (4, 'Salários', 'Pagamento de funcionários', '2025-07-09 02:56:17', '2025-07-13 14:07:57', 'fixa', 1), (5, 'Medicamento', 'Compra de produtos para estoque', '2025-07-09 02:56:17', '2025-07-13 14:08:37', 'fixa', 1); -- Dumping structure for table ecs.clientes CREATE TABLE IF NOT EXISTS `clientes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nome` varchar(255) NOT NULL, `Endereco` varchar(255) NOT NULL, `Nuit` varchar(255) NOT NULL, `contacto` varchar(255) NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- Dumping data for table ecs.clientes: ~0 rows (approximately) INSERT INTO `clientes` (`id`, `nome`, `Endereco`, `Nuit`, `contacto`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'Default', 'rua princial', '11111111111', '998898', NULL, '2021-07-03 04:20:02', '2021-07-03 04:20:02'); -- Dumping structure for table ecs.compras CREATE TABLE IF NOT EXISTS `compras` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `Fornecedor_id` bigint unsigned NOT NULL, `Codigo_Fatura` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `datacompra` date NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `outras_dispesas` decimal(10,0) DEFAULT NULL, `Transporte` decimal(10,0) DEFAULT NULL, `TipodeCompra` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `Fornecedor_id` (`Fornecedor_id`), KEY `user_id` (`user_id`), CONSTRAINT `Fornecedor_id` FOREIGN KEY (`Fornecedor_id`) REFERENCES `fornecedors` (`id`), CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.compras: ~10 rows (approximately) INSERT INTO `compras` (`id`, `user_id`, `Fornecedor_id`, `Codigo_Fatura`, `datacompra`, `deleted_at`, `created_at`, `updated_at`, `outras_dispesas`, `Transporte`, `TipodeCompra`) VALUES (21, 28, 66, '01', '2026-02-11', NULL, '2026-02-11 06:47:10', '2026-02-11 06:47:10', 0, 0, 'Orçamento'), (22, 28, 67, '01', '2026-02-11', NULL, '2026-02-11 10:54:57', '2026-02-11 10:54:57', 0, 0, 'Orçamento'), (23, 28, 69, '01', '2026-02-12', NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 0, 0, 'Orçamento'), (24, 28, 67, '02', '2026-02-12', NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 0, 0, 'Orçamento'), (25, 28, 70, '03', '2026-02-12', NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 0, 0, 'Orçamento'), (26, 28, 67, '05', '2026-02-12', NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 0, 0, 'Orçamento'), (27, 28, 67, '06', '2026-02-12', NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 0, 0, 'Orçamento'), (28, 28, 68, '07', '2026-02-12', NULL, '2026-02-12 18:42:45', '2026-02-12 18:42:45', 0, 0, 'Orçamento'), (29, 28, 68, '04', '2026-02-12', NULL, '2026-02-12 18:49:19', '2026-02-12 18:49:19', 0, 0, 'Orçamento'), (30, 28, 70, '04', '2026-02-12', NULL, '2026-02-12 18:51:22', '2026-02-12 18:51:22', 0, 0, 'Orçamento'); -- Dumping structure for table ecs.config CREATE TABLE IF NOT EXISTS `config` ( `id` int NOT NULL, `nome` varchar(50) NOT NULL, `NUit` varchar(24) NOT NULL, `Email` varchar(100) DEFAULT NULL, `Localizacao` varchar(150) DEFAULT NULL, `Contacto` varchar(24) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `avatar` varchar(45) NOT NULL, `Contacto2` varchar(45) DEFAULT NULL, `datakey` varchar(50) DEFAULT NULL, `Label` int DEFAULT NULL, `TIpoSistema` varchar(50) DEFAULT NULL, `nome_Empresa` varchar(50) DEFAULT NULL, `linkEmpresa` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `Email` (`Email`), UNIQUE KEY `Localizacao` (`Localizacao`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table ecs.config: ~0 rows (approximately) INSERT INTO `config` (`id`, `nome`, `NUit`, `Email`, `Localizacao`, `Contacto`, `created_at`, `updated_at`, `avatar`, `Contacto2`, `datakey`, `Label`, `TIpoSistema`, `nome_Empresa`, `linkEmpresa`) VALUES (1, 'SISFARM', '133381961', 'info@ecs.co.mz', 'Julius Nyerere', '848853925', '2020-10-08 12:04:32', '2026-04-20 11:21:03', 'logoTipo.png', '878853925', '1618685230', NULL, '|ECS', 'CECS', NULL); -- Dumping structure for table ecs.configlayout CREATE TABLE IF NOT EXISTS `configlayout` ( `id` int NOT NULL, `nav_header` varchar(24) NOT NULL, `brand_link` varchar(24) NOT NULL, `sider_bar` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table ecs.configlayout: ~0 rows (approximately) INSERT INTO `configlayout` (`id`, `nav_header`, `brand_link`, `sider_bar`) VALUES (1, 'bg-success', 'bg-success', 'sidebar-light-success'); -- Dumping structure for view ecs.dadosprodutoscompra -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `dadosprodutoscompra` ( `nome` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `nome_generico` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `id` INT(10) NOT NULL, `produto_id` INT(10) NOT NULL, `compra_id` INT(10) NOT NULL, `armazem_id` INT(10) NOT NULL, `preco_compra` DECIMAL(10,0) NOT NULL, `preco_compraTotal` DECIMAL(20,0) NOT NULL, `preco_venda` DECIMAL(10,0) NOT NULL, `preco_vendaTotal` DECIMAL(20,0) NOT NULL, `data_validade` DATE NOT NULL, `created_at` TIMESTAMP NOT NULL, `updated_at` TIMESTAMP NOT NULL, `codigo_barras` VARCHAR(255) NULL COLLATE 'latin1_swedish_ci', `lote` VARCHAR(24) NULL COLLATE 'latin1_swedish_ci', `Quantidade` INT(10) NOT NULL, `deleted_at` TIMESTAMP NULL, `categoria_id` BIGINT(20) UNSIGNED NOT NULL, `categoria` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `formulacao_id` INT(10) NULL, `formulacao` VARCHAR(100) NULL COLLATE 'utf8mb4_general_ci', `Concentracao` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `temperatura_Conservacao` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `user_id` BIGINT(20) UNSIGNED NULL, `Fornecedor_id` BIGINT(20) UNSIGNED NULL, `datacompra` DATE NULL, `Codigo_Fatura` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci' ) ENGINE=MyISAM; -- Dumping structure for table ecs.despesas CREATE TABLE IF NOT EXISTS `despesas` ( `id` int NOT NULL AUTO_INCREMENT, `categoria_id` int NOT NULL, `fornecedor_id` int NOT NULL, `forma_pagamento_id` int NOT NULL, `data_vencimento` date NOT NULL, `data_pagamento` date DEFAULT NULL, `valor` decimal(10,2) NOT NULL, `descricao` text, `status` enum('pendente','pago','atrasado','cancelado','rejeitado') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'pendente', `recorrente` enum('nao','diario','semanal','mensal','anual') DEFAULT 'nao', `data_fim_recorrencia` date DEFAULT NULL, `quantidade_parcelas` int DEFAULT NULL, `motivo_rejeicao` text, `comentario_aprovacao` text, `anexo` varchar(255) DEFAULT NULL, `observacoes` text, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `aprovador_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `categoria_id` (`categoria_id`), KEY `fornecedor_id` (`fornecedor_id`), KEY `forma_pagamento_id` (`forma_pagamento_id`), KEY `status` (`status`), KEY `data_vencimento` (`data_vencimento`), CONSTRAINT `despesas_ibfk_1` FOREIGN KEY (`categoria_id`) REFERENCES `categorias_despesa` (`id`), CONSTRAINT `despesas_ibfk_2` FOREIGN KEY (`fornecedor_id`) REFERENCES `fornecedores` (`id`), CONSTRAINT `despesas_ibfk_3` FOREIGN KEY (`forma_pagamento_id`) REFERENCES `formas_pagamento` (`id`), CONSTRAINT `chk_valor_positivo` CHECK ((`valor` > 0)) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table ecs.despesas: ~0 rows (approximately) -- Dumping structure for table ecs.enderecos CREATE TABLE IF NOT EXISTS `enderecos` ( `id` int NOT NULL AUTO_INCREMENT, `avenida` varchar(45) DEFAULT NULL, `Bairo` varchar(45) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updatd_at` varchar(45) DEFAULT NULL, `deleted_at` varchar(45) DEFAULT NULL, `Distrito` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- Dumping data for table ecs.enderecos: ~0 rows (approximately) INSERT INTO `enderecos` (`id`, `avenida`, `Bairo`, `created_at`, `updatd_at`, `deleted_at`, `Distrito`) VALUES (1, 'Rua Pricipal', '25 de Junho', NULL, NULL, NULL, 'ECS'); -- Dumping structure for table ecs.failed_jobs CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.failed_jobs: ~0 rows (approximately) -- Dumping structure for view ecs.farmacosexistete -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `farmacosexistete` ( `produto_id` BIGINT(20) UNSIGNED NULL, `id` BIGINT(20) UNSIGNED NULL, `nome` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `nome_generico` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `temperatura_Conservacao` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `Concentracao` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `formulcao_id` INT(10) NULL, `formulacao` VARCHAR(100) NULL COLLATE 'utf8mb4_general_ci', `categoria_id` BIGINT(20) UNSIGNED NULL, `categorias` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `preco_venda` DECIMAL(10,0) NOT NULL, `preco_compra` DECIMAL(10,0) NOT NULL, `data_validade` DATE NOT NULL, `QuantidadeArmazem` INT(10) NOT NULL, `armazem_id` INT(10) NOT NULL, `armazem` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci', `lote` VARCHAR(24) NULL COLLATE 'latin1_swedish_ci', `Codigo_Fatura` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `datacompra` DATE NULL, `loja_produto_id` BIGINT(20) UNSIGNED NULL, `Quantidadeloja` DECIMAL(10,0) NULL, `data_alocacao` DATE NULL, `loja_id` INT(10) NULL, `loja` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci' ) ENGINE=MyISAM; -- Dumping structure for view ecs.farmacosnafarmacia -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `farmacosnafarmacia` ( `id` BIGINT(20) UNSIGNED NOT NULL, `produto_id` BIGINT(20) UNSIGNED NULL, `idproduto` BIGINT(20) UNSIGNED NULL, `nome_Comercial` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `nome` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `nome_generico` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `Formulacao` VARCHAR(100) NULL COLLATE 'utf8mb4_general_ci', `Preco_Compra` DECIMAL(10,0) NULL, `preco_venda` DECIMAL(10,0) NULL, `formulacao_id` INT(10) NULL, `data_validade` DATE NULL, `LucroUnitario` DECIMAL(11,0) NULL, `precoCompraTotal` DECIMAL(20,0) NULL, `precoVendaTotal` DECIMAL(20,0) NULL, `LucroTotal` DECIMAL(21,0) NULL, `qunatidade` DECIMAL(10,0) NOT NULL, `loja_desc_id` INT(10) NULL ) ENGINE=MyISAM; -- Dumping structure for view ecs.farmacosnafarmaciaview -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `farmacosnafarmaciaview` ( `id` BIGINT(20) UNSIGNED NOT NULL, `produto_id` BIGINT(20) UNSIGNED NULL, `idproduto` BIGINT(20) UNSIGNED NULL, `nome_Comercial` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `nome` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `nome_generico` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `formulacao` VARCHAR(100) NULL COLLATE 'utf8mb4_general_ci', `Preco_Compra` DECIMAL(10,0) NULL, `preco_venda` DECIMAL(10,0) NULL, `formulacao_id` INT(10) NULL, `data_validade` DATE NULL, `LucroUnitario` DECIMAL(33,0) NULL, `precoCompraTotal` DECIMAL(42,0) NULL, `preco_compraTotal` DECIMAL(42,0) NULL, `precoVendaTotal` DECIMAL(42,0) NULL, `LucroTotal` DECIMAL(43,0) NULL, `Quantidade` DECIMAL(32,0) NULL, `qunatidade` DECIMAL(32,0) NULL, `loja_desc_id` INT(10) NULL, `dataInicial` TIMESTAMP NULL, `precoVendaTotalFiltre` DECIMAL(42,0) NULL ) ENGINE=MyISAM; -- Dumping structure for table ecs.fechamentocontas CREATE TABLE IF NOT EXISTS `fechamentocontas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `saida` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `id_user_idx` (`user_id`), CONSTRAINT `id_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table ecs.fechamentocontas: ~0 rows (approximately) -- Dumping structure for table ecs.formas_pagamento CREATE TABLE IF NOT EXISTS `formas_pagamento` ( `id` int NOT NULL AUTO_INCREMENT, `descricao` varchar(30) NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `dias_parcela` int NOT NULL DEFAULT '0' COMMENT 'Dias para pagamento após vencimento', PRIMARY KEY (`id`), UNIQUE KEY `descricao` (`descricao`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table ecs.formas_pagamento: ~7 rows (approximately) INSERT INTO `formas_pagamento` (`id`, `descricao`, `created_at`, `dias_parcela`) VALUES (1, 'Dinheiro', '2025-07-09 02:56:17', 0), (2, 'M-pesa', '2025-07-09 02:59:52', 0), (3, 'E-mola', '2025-07-09 03:01:12', 0), (4, 'Mkesh', '2025-07-09 03:01:44', 0), (6, 'Transferência', '2025-07-09 02:56:17', 0), (7, 'Cartão Débito', '2025-07-09 02:56:17', 0), (8, 'Cartão Crédito', '2025-07-09 02:56:17', 0); -- Dumping structure for table ecs.formulacao CREATE TABLE IF NOT EXISTS `formulacao` ( `id` int NOT NULL AUTO_INCREMENT, `Descricao` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- Dumping data for table ecs.formulacao: ~55 rows (approximately) INSERT INTO `formulacao` (`id`, `Descricao`, `created_at`, `updated_at`, `deleted_at`) VALUES (55, 'comprimido', '2026-02-11 06:47:10', '2026-02-11 06:47:10', NULL), (56, 'Suspencao', '2026-02-11 10:54:57', '2026-02-11 10:54:57', NULL), (57, 'Comprimidos', '2026-02-11 10:54:57', '2026-02-11 10:54:57', NULL), (58, 'Solucao Oral', '2026-02-11 10:54:57', '2026-02-11 10:54:57', NULL), (59, 'Pomada', '2026-02-11 10:54:57', '2026-02-11 10:54:57', NULL), (60, 'Injctavel', '2026-02-11 10:54:57', '2026-02-11 10:54:57', NULL), (61, 'Colirio', '2026-02-11 10:54:57', '2026-02-11 10:54:57', NULL), (62, 'Capsulas', '2026-02-11 10:54:57', '2026-02-11 10:54:57', NULL), (63, 'Epi', '2026-02-11 10:54:57', '2026-02-11 10:54:57', NULL), (64, 'Testes', '2026-02-11 10:54:58', '2026-02-11 10:54:58', NULL), (65, 'Gel', '2026-02-11 10:54:58', '2026-02-11 10:54:58', NULL), (66, 'Xarope', '2026-02-11 10:54:58', '2026-02-11 10:54:58', NULL), (67, 'Cassette', '2026-02-11 10:54:58', '2026-02-11 10:54:58', NULL), (68, 'TA', '2026-02-11 11:01:46', '2026-02-11 11:01:46', NULL), (69, 'Capsula', '2026-02-11 11:01:46', '2026-02-11 11:01:46', NULL), (70, 'Injectavel', '2026-02-11 11:01:46', '2026-02-11 11:01:46', NULL), (71, 'Cream', '2026-02-11 11:01:46', '2026-02-11 11:01:46', NULL), (72, 'Solucao', '2026-02-11 11:01:46', '2026-02-11 11:01:46', NULL), (73, 'Pastilhas', '2026-02-11 11:05:13', '2026-02-11 11:05:13', NULL), (74, 'Adesivo', '2026-02-11 11:05:13', '2026-02-11 11:05:13', NULL), (75, 'Aerosol', '2026-02-11 11:05:13', '2026-02-11 11:05:13', NULL), (76, 'Po para Solucao', '2026-02-11 11:05:13', '2026-02-11 11:05:13', NULL), (77, 'Suspncao', '2026-02-11 11:08:08', '2026-02-11 11:08:08', NULL), (78, 'Cassete', '2026-02-11 11:08:08', '2026-02-11 11:08:08', NULL), (79, 'Caps', '2026-02-11 11:08:08', '2026-02-11 11:08:08', NULL), (80, 'Multivitamina', '2026-02-11 11:11:49', '2026-02-11 11:11:49', NULL), (81, 'Compressa', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL), (82, 'N', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL), (83, 'Higienico', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL), (84, 'MM', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL), (85, 'Algodao Absorvente', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL), (86, 'Suspensao', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL), (87, 'Sabonete', '2026-02-12 17:16:07', '2026-02-12 17:16:07', NULL), (88, 'Locao', '2026-02-12 17:16:07', '2026-02-12 17:16:07', NULL), (89, 'Gota', '2026-02-12 17:16:07', '2026-02-12 17:16:07', NULL), (90, 'Liquido', '2026-02-12 17:16:07', '2026-02-12 17:16:07', NULL), (91, 'Creme', '2026-02-12 17:16:07', '2026-02-12 17:16:07', NULL), (92, 'Copressas', '2026-02-12 17:16:07', '2026-02-12 17:16:07', NULL), (93, 'Comp', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL), (94, 'Seringa Medica', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL), (95, 'Suuspensao', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL), (96, 'Sabao', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL), (97, 'TG', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL), (98, 'Vapor', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL), (99, 'Anti-ceptico', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL), (100, 'Preservativo', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL), (101, 'Ligadura', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL), (102, 'Gesso', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL), (103, 'Alcool', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL), (104, 'Gota auricular', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL), (105, 'Suporte', '2026-02-12 18:42:45', '2026-02-12 18:42:45', NULL), (106, 'Injecao', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL), (107, 'Luvas Latex', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL), (108, 'Mistura', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL), (109, 'Teste de Malaria', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL); -- Dumping structure for table ecs.fornecedores CREATE TABLE IF NOT EXISTS `fornecedores` ( `id` int NOT NULL AUTO_INCREMENT, `nome` varchar(100) NOT NULL, `cnpj_cpf` varchar(20) DEFAULT NULL, `telefone` varchar(15) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `ativo` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `cnpj_cpf` (`cnpj_cpf`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table ecs.fornecedores: ~0 rows (approximately) -- Dumping structure for table ecs.fornecedors CREATE TABLE IF NOT EXISTS `fornecedors` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nome` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Endereco` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Nuit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contacto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.fornecedors: ~16 rows (approximately) INSERT INTO `fornecedors` (`id`, `nome`, `Endereco`, `Nuit`, `contacto`, `deleted_at`, `created_at`, `updated_at`) VALUES (66, 'MDS', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (67, 'ACE', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (68, 'MEDIS', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (69, 'MOZPHARMA', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (70, 'EMS', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (71, 'OrbisPharma', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (72, 'TMI', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (73, 'SHANI', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (74, 'MEDIMPORT', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (75, 'GENERIS', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (76, 'WELLWORTH', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (77, 'AUSTRAL ', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (78, 'DKT', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (79, 'GENERICS', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (80, 'ATLANTICO', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'), (81, 'AFRIMARMACIA ', NULL, NULL, NULL, NULL, '2024-08-19 05:50:44', '2024-08-19 05:50:44'); -- Dumping structure for table ecs.funcionario CREATE TABLE IF NOT EXISTS `funcionario` ( `id` int NOT NULL AUTO_INCREMENT, `nome` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `contacto` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `sexo` enum('M,F') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `data` date NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `funcionario_ibfk_1` FOREIGN KEY (`id`) REFERENCES `tipo_d_funcionario` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- Dumping data for table ecs.funcionario: ~0 rows (approximately) -- Dumping structure for procedure ecs.gerarGarafica DELIMITER // CREATE PROCEDURE `gerarGarafica`(IN `datainicial1` DATE, IN `datainicial2` DATE, IN `ano` INT) begin DECLARE contador INT DEFAULT 1; CREATE TEMPORARY TABLE IF NOT EXISTS temp_resultados ( mes INT, total_quantidade INT ); CREATE TEMPORARY TABLE IF NOT EXISTS temp_resultadosvendas ( mes INT, total_quantidade INT ); CREATE TEMPORARY TABLE IF NOT EXISTS temp_resultadosFORADOPRASO( mes INT, total_quantidade INT ); CREATE TEMPORARY TABLE IF NOT EXISTS temp_resultadosFORADOPRASOloja( mes INT, total_quantidade INT ); TRUNCATE TABLE temp_resultados; TRUNCATE TABLE temp_resultadosvendas; Truncate table temp_resultadosFORADOPRASO; Truncate table temp_resultadosFORADOPRASOloja; WHILE contador <= 12 DO -- Aqui você pode adicionar qualquer lógica que queira executar no loop INSERT INTO temp_resultados (mes, total_quantidade) SELECT contador AS mes, SUM(produtos.Quantidade) AS total_quantidade from compras join produtos on produtos.compra_id=compras.id where month(compras.datacompra ) =contador and year(compras.datacompra ) =ano and produtos.Quantidade >0; INSERT INTO temp_resultadosvendas (mes, total_quantidade) SELECT contador AS mes, SUM(produtosvendas.qunatidade) AS total_quantidade from vendas join produtosvendas on produtosvendas.venda_id=vendas.id where month(vendas.dataVenda ) =contador and year(vendas.dataVenda ) =ano and produtosvendas.qunatidade >0; INSERT INTO temp_resultadosFORADOPRASO (mes, total_quantidade) SELECT contador as mes,SUM(produtos.Quantidade) as total_quantidade FROM produtos where month(produtos.data_validade) =contador and year(produtos.data_validade ) =ano and produtos.Quantidade >0; insert into temp_resultadosFORADOPRASOloja(mes,total_quantidade) select contador as mes , sum(lojas.qunatidade) as total_quantidade from lojas join produtos on produtos.id=lojas.produto_id where month(produtos.data_validade) =contador and year(produtos.data_validade) =ano and lojas.qunatidade >0; set contador=contador+1; END WHILE; select temp_resultadosvendas.mes as mes_id, temp_resultados.total_quantidade as Armazem , temp_resultadosvendas.total_quantidade as Vendas , temp_resultadosFORADOPRASO.total_quantidade as armazemForaPrazo, temp_resultadosFORADOPRASOloja.total_quantidade as lojasForaPrazo from temp_resultados join temp_resultadosvendas on temp_resultadosvendas.mes= temp_resultados.mes join temp_resultadosFORADOPRASO on temp_resultadosFORADOPRASO.mes =temp_resultados.mes join temp_resultadosFORADOPRASOloja on temp_resultadosFORADOPRASOloja.mes =temp_resultados.mes; end// DELIMITER ; -- Dumping structure for table ecs.historico_aprovacoes CREATE TABLE IF NOT EXISTS `historico_aprovacoes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `despesa_id` bigint unsigned NOT NULL, `user_id` bigint unsigned NOT NULL COMMENT 'Aprovador', `acao` enum('aprovacao','rejeicao','cancelamento','alteracao') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `justificativa` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `dados_anteriores` json DEFAULT NULL COMMENT 'Dados antes da alteração', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `historico_aprovacoes_despesa_id_foreign` (`despesa_id`), KEY `historico_aprovacoes_user_id_foreign` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.historico_aprovacoes: ~0 rows (approximately) -- Dumping structure for table ecs.licencas CREATE TABLE IF NOT EXISTS `licencas` ( `id` int NOT NULL AUTO_INCREMENT, `chave` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `licenca` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- Dumping data for table ecs.licencas: ~3 rows (approximately) INSERT INTO `licencas` (`id`, `chave`, `licenca`) VALUES (1, '200B742DCC85', NULL), (2, 'nova-chave-valor', ''), (18, '24871-02520-0D223-BC520-7C059', 'F5380-41F19-AE251-42524-7E059'); -- Dumping structure for table ecs.lojas CREATE TABLE IF NOT EXISTS `lojas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `produto_id` bigint unsigned DEFAULT NULL, `data_alocacao` date NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `qunatidade` decimal(10,0) NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `loja_desc_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id_idxs` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- Dumping data for table ecs.lojas: ~5 rows (approximately) INSERT INTO `lojas` (`id`, `produto_id`, `data_alocacao`, `user_id`, `qunatidade`, `deleted_at`, `created_at`, `updated_at`, `loja_desc_id`) VALUES (1, 5, '2026-02-14', 28, 15, NULL, '2026-02-14 17:02:14', '2026-04-20 14:47:06', 1), (2, 4, '2026-03-26', 28, 3, NULL, '2026-02-14 17:02:14', '2026-03-26 14:34:33', 1), (3, 2, '2026-02-14', 28, 3, NULL, '2026-02-14 17:02:14', '2026-04-20 14:47:06', 1), (4, 1, '2026-02-14', 28, 1, NULL, '2026-02-14 17:02:14', '2026-02-14 17:03:03', 1), (5, 3, '2026-03-26', 28, 1, NULL, '2026-03-26 14:34:33', '2026-03-26 14:34:33', 1); -- Dumping structure for table ecs.lojas_desc CREATE TABLE IF NOT EXISTS `lojas_desc` ( `id` int NOT NULL AUTO_INCREMENT, `Descricao` varchar(50) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `enderco_id` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- Dumping data for table ecs.lojas_desc: ~0 rows (approximately) INSERT INTO `lojas_desc` (`id`, `Descricao`, `deleted_at`, `updated_at`, `created_at`, `enderco_id`) VALUES (1, 'ECS', NULL, NULL, NULL, 1); -- Dumping structure for table ecs.migrations CREATE TABLE IF NOT EXISTS `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.migrations: ~0 rows (approximately) -- Dumping structure for table ecs.notificacao CREATE TABLE IF NOT EXISTS `notificacao` ( `id` int NOT NULL AUTO_INCREMENT, `id_informacao` int NOT NULL, `id_funcionario` int NOT NULL, `data` datetime NOT NULL, PRIMARY KEY (`id`), KEY `id_funcionario` (`id_funcionario`), KEY `notificacao_ibfk_1` (`id_informacao`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- Dumping data for table ecs.notificacao: ~0 rows (approximately) -- Dumping structure for table ecs.notifications CREATE TABLE IF NOT EXISTS `notifications` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_id` bigint unsigned NOT NULL, `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.notifications: ~0 rows (approximately) -- Dumping structure for table ecs.orcamentos CREATE TABLE IF NOT EXISTS `orcamentos` ( `id` int NOT NULL AUTO_INCREMENT, `categoria_id` int NOT NULL, `mes_ano` date NOT NULL, `valor_previsto` decimal(10,2) NOT NULL, `valor_realizado` decimal(10,2) DEFAULT '0.00', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `categoria_id` (`categoria_id`,`mes_ano`), CONSTRAINT `orcamentos_ibfk_1` FOREIGN KEY (`categoria_id`) REFERENCES `categorias_despesa` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table ecs.orcamentos: ~0 rows (approximately) -- Dumping structure for table ecs.parcelas CREATE TABLE IF NOT EXISTS `parcelas` ( `id` int NOT NULL AUTO_INCREMENT, `despesa_id` int NOT NULL, `numero` int NOT NULL, `valor` decimal(10,2) NOT NULL, `data_vencimento` date NOT NULL, `data_pagamento` date DEFAULT NULL, `status` enum('pendente','pago','atrasado') DEFAULT 'pendente', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `despesa_id` (`despesa_id`), KEY `status` (`status`), KEY `data_vencimento` (`data_vencimento`), CONSTRAINT `parcelas_ibfk_1` FOREIGN KEY (`despesa_id`) REFERENCES `despesas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table ecs.parcelas: ~0 rows (approximately) -- Dumping structure for table ecs.password_resets CREATE TABLE IF NOT EXISTS `password_resets` ( `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.password_resets: ~0 rows (approximately) -- Dumping structure for table ecs.permissions CREATE TABLE IF NOT EXISTS `permissions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `label` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.permissions: ~25 rows (approximately) INSERT INTO `permissions` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES (27, 'Visualizar-relatorio', 'Visualizar relatorio ', NULL, NULL), (29, 'Efectuar-vendas', 'Efectuar vendas', NULL, NULL), (31, 'visualizar-vendas', 'visualizar vendas', NULL, NULL), (32, 'Adicionar-Farmacia', 'Adicionar a Farmácia', NULL, NULL), (33, 'Previlegios-Sistema', 'Privilégios dos Sistema ', NULL, NULL), (34, 'Lista-Usuarios', 'Lista de Usuarios', NULL, NULL), (35, 'Registar-usuarios', 'Registo de Usuarios', NULL, NULL), (36, 'Configuracoes-Sisitema', 'Configurações Sistema ', NULL, NULL), (37, 'Configuracoes-licenca', 'Configurações licença', NULL, NULL), (41, 'farmacos-adicionar', 'Adicionar Compra ', NULL, NULL), (42, 'Visualizar-Farmacos', 'Visualizar Farmacos', NULL, NULL), (43, 'visualizar-Compras', 'Visualizar Compras', NULL, NULL), (44, 'Edit_user', 'Atualizar dados dos usuarios', NULL, NULL), (45, 'Delete-User', 'Apagar usuarios', NULL, NULL), (46, 'Atualizar-Compra', 'Atualizar dados da compra', NULL, NULL), (47, 'Atualizar-farmaco', 'Atualizar dados do Farmaco ', NULL, NULL), (48, 'Apagar-farmaco', 'Apagar farmaco', NULL, NULL), (49, 'apagar-compra', 'Apagar compra', NULL, NULL), (50, 'Visualizar-relatorio', 'Visualizar Relatorio', NULL, NULL), (51, 'VisualizarDiarias-vendas', 'Visualizar vendas Diarias', NULL, NULL), (52, 'devolver-Armazem', 'Devolver-Arnazem', NULL, NULL), (53, 'cancelar-vendas', 'Cancelar Venda', NULL, NULL), (54, 'Contente', 'Farmacia Contente', NULL, NULL), (56, 'Contente', 'Armazem Contente', NULL, NULL), (58, 'Verificar-todasDiarias', 'Verificar Todas as Vendas Diarias', NULL, NULL); -- Dumping structure for table ecs.permission_role CREATE TABLE IF NOT EXISTS `permission_role` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `permission_id` int unsigned NOT NULL, `role_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `permission_role_permission_id_foreign` (`permission_id`), KEY `permission_role_role_id_foreign` (`role_id`), CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=704 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.permission_role: ~29 rows (approximately) INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (553, 29, 23, NULL, NULL), (554, 31, 23, NULL, NULL), (555, 51, 23, NULL, NULL), (616, 27, 21, NULL, NULL), (617, 29, 21, NULL, NULL), (618, 31, 21, NULL, NULL), (619, 32, 21, NULL, NULL), (620, 41, 21, NULL, NULL), (621, 42, 21, NULL, NULL), (622, 43, 21, NULL, NULL), (623, 46, 21, NULL, NULL), (624, 47, 21, NULL, NULL), (625, 51, 21, NULL, NULL), (626, 53, 21, NULL, NULL), (627, 56, 21, NULL, NULL), (639, 29, 24, NULL, NULL), (640, 31, 24, NULL, NULL), (641, 51, 24, NULL, NULL), (642, 55, 24, NULL, NULL), (694, 27, 19, NULL, NULL), (695, 29, 19, NULL, NULL), (696, 31, 19, NULL, NULL), (697, 42, 19, NULL, NULL), (698, 43, 19, NULL, NULL), (699, 50, 19, NULL, NULL), (700, 51, 19, NULL, NULL), (701, 54, 19, NULL, NULL), (702, 56, 19, NULL, NULL), (703, 58, 19, NULL, NULL); -- Dumping structure for procedure ecs.proc_quantidade_por_local_dinamico DELIMITER // CREATE PROCEDURE `proc_quantidade_por_local_dinamico`() BEGIN -- Etapa 1: Monta dinamicamente as colunas das lojas SET @sql = ( SELECT GROUP_CONCAT( DISTINCT CONCAT( 'SUM(CASE WHEN ld.id = ', ld.id, ' THEN l.qunatidade ELSE 0 END) AS `Loja_', ld.Descricao, '`' ) ) FROM lojas_desc ld ); -- Etapa 2: Acrescenta colunas dinâmicas dos armazéns SET @sql2 = ( SELECT GROUP_CONCAT( DISTINCT CONCAT( 'SUM(CASE WHEN ad.id = ', ad.id, ' THEN pc.Quantidade ELSE 0 END) AS `Armazem_', ad.Descricao, '`' ) ) FROM armazem_desc ad ); -- Etapa 3: Junta tudo na query final SET @final_sql = CONCAT( 'SELECT p.id AS ProdutoID, p.nome AS Produto, ', @sql, ', ', @sql2, ' FROM produtos p ', 'LEFT JOIN lojas l ON l.produto_id = p.id ', 'LEFT JOIN lojas_desc ld ON l.loja_desc_id = ld.id ', 'LEFT JOIN produto_compra pc ON pc.produto_id = p.id ', 'LEFT JOIN armazem_desc ad ON pc.armazem_id = ad.id ', 'GROUP BY p.id, p.nome ', 'ORDER BY p.nome ASC;' ); -- Etapa 4: Prepara e executa a query PREPARE stmt FROM @final_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; END// DELIMITER ; -- Dumping structure for table ecs.produtos CREATE TABLE IF NOT EXISTS `produtos` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nome` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `nome_generico` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `temperatura_Conservacao` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Concentracao` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `categoria_id` bigint unsigned NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `formulacao_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `produtos_categoria_id_foreign` (`categoria_id`), CONSTRAINT `produtos_categoria_id_foreign` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.produtos: ~213 rows (approximately) INSERT INTO `produtos` (`id`, `nome`, `nome_generico`, `temperatura_Conservacao`, `Concentracao`, `categoria_id`, `deleted_at`, `created_at`, `updated_at`, `formulacao_id`) VALUES (1, 'ACE Forte Plus', 'Ibuprofeno+Paracetaml+Cafeina', '30*', '765mg', 256, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (2, 'ACECARB 200mg', 'Carbamazepina', '30*', '200mg', 275, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (3, 'Ace-Cycline', 'Tetraciclina P.Oftalmica', '30*', '0.01', 277, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 59), (4, 'Ace-Dox', 'Doxycicline', '30*', '100mg', 247, NULL, '2026-02-12 17:06:59', '2026-02-22 04:10:48', 69), (5, 'ACEFIRST', 'Penso Rapido', '30*', 'N', 278, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 81), (6, 'ACEJET', 'Seringa', '30*', '5ml', 279, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 82), (7, 'Acemol', 'Paracetamol Cp', '30*', '500mg', 256, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (8, 'Acenac-SR 100', 'Diclofenac 100', '30*', '100mg', 247, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (9, 'ACEPEN 500', 'Fenoximetilpenicilina', '30*', '500mg', 247, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (10, 'ACERID', 'Amilorido', '30*', '5mg', 269, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (11, 'ACERID-H', 'Amilorido+Hidroclortiazid', '30*', '55mg', 269, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (12, 'Acetrip', 'Amitriplina', '30*', '10mg', 275, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (13, 'Adesivo de Oxido de Zinco', 'Adesivo', '30*', '7.5cmX5m', 280, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 83), (14, 'Adesivo de Oxido de Zinco', 'Adesivo', '30*', '5cmX5m', 280, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 83), (15, 'Algalia', 'Algalia', '30*', '1x10', 280, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 84), (16, 'Algodao Absorvente', 'Algodao', '30*', '100gms', 280, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 85), (17, 'Aliviador', 'Paracetamol+Diclofenac', '30*', '550mg', 257, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (18, 'Alopron', 'Alopurinol', '30*', '100ml', 281, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (19, 'Alugen', 'Hidroxido de Aluminio', '30*', '500mg', 276, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (20, 'Amboten', 'Ambroxol', '30*', '15mg', 282, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 86), (21, 'Amilotix 10', 'Amilodipina', '30*', '10mg', 275, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 55), (22, 'Amox - 500', 'Amoxicilina 500mg', '30*', '500mg', 247, NULL, '2026-02-12 17:06:59', '2026-02-12 17:06:59', 69), (23, 'Ampicilina Sodica', 'Ampicilina', '30*', '1g', 247, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 70), (24, 'Angilong 100', 'Atenolol 100', '30*', '100mg', 269, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 55), (25, 'AntiAcne', 'AntiAcne Sabonete', '30*', '100g', 283, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 87), (26, 'Apetimax Syrup', 'Apetimax', '30*', '432mg', 260, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 66), (27, 'ASP', 'Acido Acelilico', '30*', '100mg', 247, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 55), (28, 'AziTab - 500', 'Azitromicina', '30*', '500mg', 247, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 55), (29, 'Benylin 4flu liquid', 'Paracetamol xarope+Pseudop+difenid', '30*', '1070 g', 284, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 66), (30, 'Benylin Codeina', 'Difenidramina + Codeina+Amonium', '30*', '150mg', 284, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 66), (31, 'Bezosol', 'Benzil Benzoato', '30*', '0.25', 285, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 88), (32, 'Bromovan', 'Bromexina', '30*', '4mg', 282, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 86), (33, 'Brugen 200', 'Ibuprofeno', '30*', '200mg', 247, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 55), (34, 'Candifen Vag', 'Clotrima+Ornidazol', '30*', '30g', 247, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 71), (35, 'Ceftriaxona Sodica 1G', 'Ceftriaxona Inj WFI', '30*', '1G', 247, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 70), (36, 'Clogen', 'Clotrimazol', '30*', '0.01', 286, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 59), (37, 'Clorafenicol', 'Clorafenicol', '30*', '10ml', 277, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 89), (38, 'Cloreto de Sodio', 'Colreto de Sodio', '30*', '500ml', 287, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 90), (39, 'Clovirex', 'Aciclovir', '30*', '0.05', 286, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 91), (40, 'Coflix', 'Coflix Syrup', '30*', '658mg', 251, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 66), (41, 'Coldaflu Plus', 'Coldaflu', '30*', '535mg', 267, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 55), (42, 'Coldril Criança', 'Paracet+clorf+Pseudoeph', '30*', '131mg', 288, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 66), (43, 'Complexo B', 'Vitamina B', '30*', '100ml', 260, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 66), (44, 'Contrigen', 'Cotrimoxazol', '30*', '480mg', 247, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 55), (45, 'Copressas de Gaze Parafinada', 'Copressas', '30*', '10cmX10cm', 280, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 92), (46, 'Cotrigen S', 'Cotrimoxazol', '30*', '100ml', 247, NULL, '2026-02-12 17:16:07', '2026-02-12 17:16:07', 86), (47, 'COTRIMEX-480', 'Cotrimoxazole cp', '30*', '480mg', 247, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (48, 'Curamol', 'Paracetamol', '30*', '120mg', 256, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 86), (49, 'Cyclovax 400', 'Aciclovir 400 mg', '30*', '400mg', 286, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (50, 'Cyproplex', 'Cyproheptadina', '30*', '225mg', 274, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 66), (51, 'Cyproplex', 'Cyproplex Cp', '30*', '546mg', 274, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 80), (52, 'Davistin Oral', 'Nistantina S', '30*', '1500UI', 247, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 56), (53, 'Dazol-200', 'Danazol 200mg caps', '30*', '200mg', 289, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 93), (54, 'Dermatrix', 'Betametasona BP', '30*', '0.01', 290, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 59), (55, 'Dermatrix CG', 'Betametasona+Clotri+Gent', '30', '0.01', 291, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 71), (56, 'Dermazine', 'Sulfadiazina de Prata', '30*', '0.01', 286, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 71), (57, 'Diclofenac Azevedo', 'Diclofenac Gel', '30*', '10mg', 247, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 65), (58, 'Disposable Syringe', 'Seringa', '30*', '10ml', 279, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 94), (59, 'Dorgel', 'Dorgel', '30*', '0.25', 256, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 59), (60, 'DYNAPAR', 'Diclofenac', '30*', '100mg', 256, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (61, 'Ela', 'Pilula de Emergencia 1,5mg', '30*', '1,5mg', 258, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 57), (62, 'Erythrogen', 'Erythrimycin', '30*', '250mg', 247, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 86), (63, 'ERYTHROMEX 500mg', 'Eritromicina 500mg', '30*', '500mg', 247, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (64, 'Estetescopio', 'Estetescopio', '30*', 'M', 279, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 84), (65, 'Fastrim Kit', 'Azitrom-Secnid+Flucon', '30*', '153mg', 247, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (66, 'Febrex Plus', 'Par+cloridatoclorifenamina', '30*', '100ml', 267, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 66), (67, 'Fem-Red XT', 'Salferoz+Acido Folico', '30*', '101mg', 260, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (68, 'FERYCAL', 'Ferro+Zinco com Vitamina B', '30*', '200ml', 292, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 90), (69, 'Fesate', 'Salferroso 200 mg', '30*', '200 mg', 292, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (70, 'Flugen', 'Par+Cafeina+Clorfe+Fenil', '30*', '538mg', 267, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (71, 'Flugen S', 'Par+Cafeina+fenilefrina+Clore', '30*', '100ml', 267, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 86), (72, 'Fluscot', 'Par+Cafeina+Clorfe+Fenil', '30*', '542mg', 267, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (73, 'Forache', 'Solucao para dor de Dente', '30*', '5ml', 256, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 72), (74, 'Formimet 500', 'Metformina Cp', '30*', '500mg', 271, NULL, '2026-02-12 17:36:24', '2026-02-12 17:36:24', 55), (75, 'FRUSELION', 'Furosemide', '30*', '40mg', 269, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (76, 'Frusemix', 'Furosemida Cp', '30*', '40mg', 269, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (77, 'Furmida', 'Furosemida', '30*', '40g', 269, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (78, 'Galentic', 'Diclofenac Gel', '30*', '0.01', 257, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 65), (79, 'Gasidone', 'Domperidona', '30*', '10mg', 293, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (80, 'Gen C', 'Acido ascorbico', '30*', '500 mg', 292, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (81, 'GENCEF S', 'Cefixima', '30*', '18g', 247, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 95), (82, 'Gencitrin', 'Centrizina', '30*', '10mg', 268, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 57), (83, 'Gencodyl', 'Bisacodil', '30*', '5mg', 294, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (84, 'Gencol', 'Clorafenicol', '30*', '250mg', 295, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 69), (85, 'Genform 500', 'Metformina Cp', '30*', '500mg', 264, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (86, 'Genfulvin', 'Griseofulvina Cp', '30*', '500mg', 247, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (87, 'Genlon', 'Sabonete', '30*', '100g', 283, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 96), (88, 'Genmox', 'Amoxicilina', '30*', '250mg', 247, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 86), (89, 'Genmox', 'Amoxicilina', '30*', '500mg', 296, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (90, 'Genprazol', 'Omeprazol', '30*', '20mg', 297, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 69), (91, 'Gensone 20', 'Prednisolona 20mg', '30*', '20mg', 272, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (92, 'Gensone 5', 'Prednisolona 5mg', '30*', '5mg', 272, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (93, 'Gentosse', 'Dextromet+Bromex+Cler de Amon', '30*', '100ml', 284, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 66), (94, 'Genvir - 200', 'Aciclovir cp 200 mg', '30*', '200 mg', 286, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (95, 'Genvir - 400', 'Aciclovir cp 400mg', '30*', '400mg', 247, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (96, 'Glicose Infusao', 'Glicose', '30*', '500ml', 287, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 90), (97, 'Glycogen', 'Glycogen', '30*', '100ml', 247, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 66), (98, 'Grip Water - ACE', 'Gripe Water', '30*', '135ml', 251, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 58), (99, 'G-ZOLE', 'Albendazol 400mg', '30*', '400 mg', 298, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 55), (100, 'HCG', 'Teste de Gravidez', '30*', 'N', 259, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 97), (101, 'Healthease', 'Clotrmazol Vaginal', '30*', '0.02', 283, NULL, '2026-02-12 18:11:23', '2026-02-12 18:11:23', 91), (102, 'Hemovit Syrup', 'Hemovit Syrup', '30*', '225ml', 260, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 66), (103, 'Herbals KAP KAP', 'Vapors', '30*', '10g', 251, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 59), (104, 'Herbals ScarFree', 'Vapors ScarFree', '30*', '20g', 251, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 91), (105, 'Herbals Vapors Inhaler', 'Vapors Inalar', '30*', '1', 251, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 98), (106, 'Herbals Vapors Rub', 'Vapors', '30*', '50ml', 251, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 59), (107, 'Histagen-P', 'Clorfeniramina', '30*', '2g', 299, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 86), (108, 'Ibugen', 'Par+Ibup+Cafeina', '30*', '565mg', 256, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (109, 'Ibuprofeno Azevedos', 'Ibuprofeno', '30*', '600mg', 256, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (110, 'Ibuprofeno Azevedos', 'Ibuprofeno', '30*', '400mg', 256, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (111, 'Ibuwin 100', 'Ibuprofen', '30*', '100ml', 247, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 86), (112, 'Inbugesic-400', 'Ibuprofeno cp', '30*', '400mg', 256, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (113, 'Instalone', 'Savulon', '30*', '100ml', 285, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 99), (114, 'Instalone', 'Savulon', '30*', '50ml', 285, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 99), (115, 'IPRED', 'Prednisolona', '30*', '0.01', 277, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 61), (116, 'Kamasutra', 'Preservativo', '30*', 'N', 300, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 100), (117, 'Koflyn Ananas', 'KOFLYN', '30*', '100ml', 267, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 66), (118, 'Koflyn Morango', 'KOFLYN', '30*', '100ml', 267, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 66), (119, 'KOMFORT', 'KONFORT SYRUP', '30*', '120ml', 282, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 66), (120, 'Kontrac 200', 'Misoprostol', '30*', '200mg', 301, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (121, 'Kromo Vision', 'Cromoglicato de Sodio', '30*', '0.02', 268, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 61), (122, 'Latato de Sodio', 'Latato de Sodio', '30*', '500ml', 287, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 90), (123, 'Laxaque', 'Bisacodil', '30*', '5mg', 294, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (124, 'L-Ben', 'Albendazol', '30*', '400mg', 298, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (125, 'L-Ben - S', 'Albendazol Suspencao', '30*', '200mg', 247, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 56), (126, 'L-Genta', 'Gentamicina', '30*', '10ml', 277, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 89), (127, 'Lidocaina', 'Lidocaija Injactavel', '30*', '0.02', 302, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 70), (128, 'Ligadura de Gaze', 'Ligadura de Gaze', '30*', '10cmX3m', 279, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 101), (129, 'Ligadura de Gesso Pop', 'Ligadura de Gesso', '30*', '15cmX3m', 280, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 102), (130, 'Ligadura de Gesso Pop', 'Ligadura de Gesso', '30*', '10cmX3m', 280, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 102), (131, 'Ligadura Elastica', 'Ligadura', '30*', '7.5cmX4.5m', 280, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 101), (132, 'Logout', 'Alopurinol', '30*', '100mg', 281, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (133, 'Lorgen', 'Lorantidina', '30*', '10mg', 268, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (134, 'LUMITER', 'Artemter+Lumefantrine', '30*', '140mg', 303, NULL, '2026-02-12 18:24:36', '2026-02-12 18:24:36', 55), (135, 'Mascara KN95', 'Mascara KN95', '30*', 'KN95', 279, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 63), (136, 'Mascara Medical', 'Mascara cirrurgica', '30*', '1G', 279, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 63), (137, 'MBEN', 'Mebendazol', '30*', '100mg', 298, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (138, 'MBEN Susp', 'Mebendazol', '30*', '200mg', 298, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 86), (139, 'Menthosil', 'Pastilha para Tosse', '30*', '25mg', 282, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 73), (140, 'Merigenta', 'Gentamicina', '30*', '10ml', 304, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 89), (141, 'Metacain', 'Lidocaina', '30*', '30gm', 283, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 91), (142, 'Metformina Azevedo', 'Metformina 500mg', '30*', '500mg', 305, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (143, 'Metoclorpramida Cp', 'Metoclorpramida 5mg', '30*', '5mg', 273, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (144, 'Metoprix Comp', 'Metoclorpramida 10mg', '30*', '10mg', 273, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (145, 'Metrogen', 'Metronidazole', '30*', '250mg', 247, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 57), (146, 'Metronidazole Injectavel', 'Metronizador', '30*', '100ml', 298, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 70), (147, 'MetroSYN', 'Metronidazole', '30*', '250mg', 247, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (148, 'Microlenyn Intimo', 'Levonor+Etinilestradiol', '30*', '0.01', 306, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (149, 'MIM Capsula', 'Ferro e Minerais', '30*', '275mg', 260, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (150, 'Mirolex', 'Cloridrato de Amilorida', '30*', '55mg', 285, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (151, 'Mucoclear', 'Ambroxol', '30*', '0.3', 284, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (152, 'Mucoclear Adulto', 'Ambroxol', '30*', '30 mg', 284, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 66), (153, 'Mucolyn', 'Mucolyn Adulto', '30*', '100ml', 267, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 66), (154, 'Mucolyn', 'Mucolyn para Crianca', '30*', '100ml', 267, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 66), (155, 'Multigen-S', 'Multivitamina', '30*', '100ml', 260, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 66), (156, 'Nathura', 'Alcool Etilico', '30*', '250ml', 307, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 103), (157, 'Naycold', 'Par+Fenil+Clorofelamina', '30*', '542mg', 256, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (158, 'Neobendex', 'Menbendazol cp', '30*', '100mg', 247, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 57), (159, 'Neoclarity Tabs', 'Claritromicina cp', '30*', '250mg', 250, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 57), (160, 'Neodopa', 'Metildopa', '30*', '250mg', 308, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (161, 'Nicof', 'Nicof Expectorante', '30*', '100ml', 247, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 86), (162, 'Normnil', 'Albendazol', '30*', '200mg', 247, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 86), (163, 'Nygen V', 'Nistantina Vaginal', '30*', '1UI', 286, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 55), (164, 'Nystagen S', 'Nistantina susp', '30*', '30ml', 286, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 86), (165, 'Ofrivid', 'Ofloxacina', '30*', '0.01', 277, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 61), (166, 'Oto-4', 'Ofloxacina + Beclomet+Clotr+Lidoc', '30*', '0.04', 247, NULL, '2026-02-12 18:32:14', '2026-02-12 18:32:14', 104), (167, 'PAlM SUPPORT', 'Suporte', '30*', 'Cm', 279, NULL, '2026-02-12 18:42:45', '2026-02-12 18:42:45', 105), (168, 'Panado', 'Panado Paracetamol 500mg', '30*', '500mg', 256, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (169, 'Pelmel', 'Pelmel', '30*', '30g', 309, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 91), (170, 'PEN-G 125', 'Fenoximetilpenicilina', '30*', '100ml', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 86), (171, 'Penicilina Bezantinica', 'Bezantinica', '30*', '2.4m', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 106), (172, 'Penicilina Procaina', 'Procaina', '30*', '3UI', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 70), (173, 'Phenirex 4mg', 'Clorfeniramina Cp 4mg', '30*', '4mg', 272, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (174, 'Piroxigen', 'Piroxicam', '30*', '20mg', 256, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 69), (175, 'Prednace inj', 'Prednisolona 50mg inj', '30*', '50mg', 272, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 70), (176, 'Preservtvo Prudence', 'Nice', '30*', '3000mm', 253, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 63), (177, 'Preservtvo Prudence', 'Morango', '30*', '3000mm', 253, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 63), (178, 'Primecip- 500', 'Ciprofloxacina', '30*', '500mg', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (179, 'Progen SG 200', 'Progesterona', '30*', '200mg', 289, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (180, 'Prsrvtvo Boa Noite Menta', 'Boa Noite', '30*', '3000mm', 253, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 63), (181, 'Prsrvtvo Boa Noite Retardante', 'Boa Noite', '30*', '3000mm', 253, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 63), (182, 'Pyloocain', 'Pyloocain', '30*', '27mg', 310, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 59), (183, 'RELAX', 'Bisacodil', '30*', '5mg', 311, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (184, 'Sabusol', 'Sabonete de Enxofre', '30*', '100g', 286, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 96), (185, 'Sabutar', 'Sabonete de Alcatrao', '30*', '100g', 286, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 96), (186, 'Saco Colector de Urina', 'Saco de Urina', '30*', '2L', 280, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 84), (187, 'Scotrizol', 'Cotrimoxazol', '30*', '100ml', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 86), (188, 'Sefimex DS', 'Cefixima', '30*', '100mg', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 86), (189, 'Sefimex DT', 'Cefixima cp 400mg', '30*', '400mg', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (190, 'Seguro Intimo', 'Misoprostol + Mifeprostona', '30*', '400mg', 301, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (191, 'SILAGEL', 'Sildenafil', '30*', '100mg', 258, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 65), (192, 'Sirugical Gloves', 'Luva Surgica', '30*', '7.5', 280, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 107), (193, 'Sistema de Soro', 'Sistema de Soro', '30*', '4m', 280, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 84), (194, 'Spasgen', 'Butilescopolamina', '30*', '10mg', 256, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (195, 'Spirolon 25', 'Espironolactona cp', '30*', '25 mg', 269, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (196, 'Spirostal', 'Spironolactone', '30*', '25mg', 269, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (197, 'SRO', 'Sais de Rehidratacao Oral', '30*', '22g', 312, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 108), (198, 'Star', 'Pomada para pele', '30*', '0.25', 263, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 59), (199, 'STERON', 'Noretisterona', '30*', '5mg', 289, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (200, 'Surgical Blades', 'Lamina de bisturil', '30*', '100PC', 279, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 63), (201, 'Teste Malaria (Just Check)', 'Teste rapido Maaria', '30*', '0.02', 279, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 109), (202, 'Theoclav', 'Amox+Clavulanato Potasio', '30*', '625mg', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (203, 'Topgyl - S 125', 'Metronidazol Suspencao', '30*', '125mg', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 56), (204, 'Tossil Jar', 'Laranja', '30*', '5mg', 267, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 73), (205, 'Tossil Jar', 'Lemon', '30*', '5mg', 267, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 73), (206, 'Tossil Jar', 'Menta', '30*', '5mg', 267, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 73), (207, 'Umitol-200', 'Carbamazepina 200 mg', '30*', '200mg', 313, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (208, 'Uriprim', 'Alopurinol', '30*', '100 mg', 314, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (209, 'Vitacee 500', 'Acido ascorbico', '30*', '500mg', 315, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (210, 'Vivasol', 'Vivasol', '30*', '100ml', 316, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 65), (211, 'Whitfield', 'Acido Salicil+A.Benzoico', '30*', '25g', 247, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 59), (212, 'XTR-ON 100', 'Sildenafil 100mg', '30*', '100mg', 317, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 55), (213, 'Zudic Creme', 'Acido Fusidico', '30*', '15g', 286, NULL, '2026-02-12 18:42:46', '2026-02-12 18:42:46', 91); -- Dumping structure for procedure ecs.produtosExistentes DELIMITER // CREATE PROCEDURE `produtosExistentes`() BEGIN DECLARE produtos_existentes_sql TEXT; -- Define a query como texto SET produtos_existentes_sql = ' SELECT DISTINCT dadosprodutoscompra.produto_id, dadosprodutoscompra.nome_generico, dadosprodutoscompra.nome FROM dadosprodutoscompra '; -- Copia para uma variável de sessão (necessária para PREPARE) SET @sql_stmt = produtos_existentes_sql; -- Executa a query dinâmica PREPARE stmt FROM @sql_stmt; EXECUTE stmt; DEALLOCATE PREPARE stmt; END// DELIMITER ; -- Dumping structure for table ecs.produtosvendas CREATE TABLE IF NOT EXISTS `produtosvendas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `produto_id` bigint unsigned NOT NULL, `qunatidade` decimal(10,0) NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `venda_id` bigint unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- Dumping data for table ecs.produtosvendas: ~5 rows (approximately) INSERT INTO `produtosvendas` (`id`, `produto_id`, `qunatidade`, `deleted_at`, `created_at`, `updated_at`, `venda_id`) VALUES (1, 4, 1, NULL, '2026-02-14 17:03:02', '2026-02-14 17:03:02', 2), (2, 1, 1, NULL, '2026-02-14 17:03:52', '2026-02-14 17:03:52', 3), (3, 2, 1, NULL, '2026-02-22 04:10:19', '2026-02-22 04:10:19', 4), (4, 1, 1, NULL, '2026-04-20 14:47:06', '2026-04-20 14:47:06', 5), (5, 3, 1, NULL, '2026-04-20 14:47:06', '2026-04-20 14:47:06', 5); -- Dumping structure for view ecs.produtosvendidosview -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `produtosvendidosview` ( `id` BIGINT(20) UNSIGNED NOT NULL, `produto_id` BIGINT(20) UNSIGNED NOT NULL, `idproduto` BIGINT(20) UNSIGNED NOT NULL, `nome_Comercial` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `nome` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `nome_generico` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `Formulacao` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_general_ci', `Preco_Compra` DECIMAL(10,0) NOT NULL, `preco_venda` DECIMAL(10,0) NOT NULL, `formulacao_id` INT(10) NULL, `LucroUnitario` DECIMAL(11,0) NOT NULL, `precoCompraTotal` DECIMAL(20,0) NOT NULL, `precoVendaTotal` DECIMAL(20,0) NOT NULL, `LucroTotal` DECIMAL(21,0) NOT NULL, `qunatidade` DECIMAL(10,0) NOT NULL, `TipodeVenda` VARCHAR(45) NOT NULL COLLATE 'latin1_swedish_ci', `dataVenda` DATE NULL, `venda_id` BIGINT(20) UNSIGNED NOT NULL, `clientNome` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci', `loja_desc_id` INT(10) NULL, `user_id` BIGINT(20) UNSIGNED NOT NULL, `usuario_mome` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci' ) ENGINE=MyISAM; -- Dumping structure for view ecs.produtosview -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `produtosview` ( `id` INT(10) NOT NULL, `nome` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `nome_generico` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `temperatura_Conservacao` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `formulacao_id` INT(10) NULL, `formulacao` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_general_ci', `Concentracao` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `categoria_id` BIGINT(20) UNSIGNED NOT NULL, `categorias` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `Quantidade` INT(10) NOT NULL, `preco_compra` DECIMAL(10,0) NOT NULL, `preco_venda` DECIMAL(10,0) NOT NULL, `data_validade` DATE NOT NULL, `lote` VARCHAR(24) NULL COLLATE 'latin1_swedish_ci', `deleted_at` TIMESTAMP NULL, `compra_id` INT(10) NOT NULL, `codigo_barras` VARCHAR(255) NULL COLLATE 'latin1_swedish_ci' ) ENGINE=MyISAM; -- Dumping structure for view ecs.produtovisalgeral -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `produtovisalgeral` ( `produto_id` BIGINT(20) UNSIGNED NOT NULL, `produto_compra_id` INT(10) NOT NULL, `nome_comercial` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `nome_generico` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `Concentracao` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci', `formulacao_id` INT(10) NOT NULL, `formulacao` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_general_ci', `datacompra` DATE NOT NULL, `dataVenda` DATE NULL, `preco_compra` DECIMAL(10,0) NOT NULL, `preco_venda` DECIMAL(10,0) NOT NULL, `QuantidadeVendica` DECIMAL(10,0) NULL, `QuantidadeNaloja` DECIMAL(10,0) NULL, `QuantidadeNoArmazem` INT(10) NOT NULL, `Armazem` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci', `armazem_id` INT(10) NOT NULL, `codigo_barras` VARCHAR(255) NULL COLLATE 'latin1_swedish_ci', `categoria` VARCHAR(255) NULL COLLATE 'utf8mb4_unicode_ci', `categoria_id` BIGINT(20) UNSIGNED NOT NULL, `lote` VARCHAR(24) NULL COLLATE 'latin1_swedish_ci', `compra_id` INT(10) NOT NULL, `venda_id` BIGINT(20) UNSIGNED NULL, `data_validade` DATE NOT NULL, `valor_total_venda` DECIMAL(20,0) NULL, `valor_total_compra` DECIMAL(20,0) NULL, `valor_total_venda_no_armazem` DECIMAL(20,0) NOT NULL, `valor_total_compra_no_armazem` DECIMAL(20,0) NOT NULL, `valor_total_venda_na_loja` DECIMAL(20,0) NULL, `valor_total_compra_na_loja` DECIMAL(20,0) NULL ) ENGINE=MyISAM; -- Dumping structure for table ecs.produto_compra CREATE TABLE IF NOT EXISTS `produto_compra` ( `id` int NOT NULL AUTO_INCREMENT, `produto_id` int NOT NULL, `compra_id` int NOT NULL, `armazem_id` int NOT NULL, `preco_compra` decimal(10,0) NOT NULL, `preco_venda` decimal(10,0) NOT NULL, `data_validade` date NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `codigo_barras` varchar(255) DEFAULT NULL, `lote` varchar(24) DEFAULT NULL, `Quantidade` int NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `codigo_barras_UNIQUE` (`codigo_barras`), UNIQUE KEY `codigo_barras` (`codigo_barras`), UNIQUE KEY `codigo_barras_2` (`codigo_barras`) ) ENGINE=InnoDB AUTO_INCREMENT=238 DEFAULT CHARSET=latin1; -- Dumping data for table ecs.produto_compra: ~213 rows (approximately) INSERT INTO `produto_compra` (`id`, `produto_id`, `compra_id`, `armazem_id`, `preco_compra`, `preco_venda`, `data_validade`, `created_at`, `updated_at`, `codigo_barras`, `lote`, `Quantidade`, `deleted_at`) VALUES (1, 1, 23, 1, 36, 75, '2028-02-28', '2026-02-12 17:06:59', '2026-02-14 17:02:14', NULL, 'N', 0, NULL), (2, 2, 23, 1, 32, 75, '2028-05-31', '2026-02-12 17:06:59', '2026-02-14 17:02:14', NULL, 'N', 10, NULL), (3, 3, 23, 1, 25, 70, '2026-06-30', '2026-02-12 17:06:59', '2026-03-26 14:34:33', NULL, 'N', 38, NULL), (4, 4, 23, 1, 25, 50, '2028-08-31', '2026-02-12 17:06:59', '2026-03-26 14:34:33', NULL, 'N', 5, NULL), (5, 5, 23, 1, 2, 5, '2030-02-28', '2026-02-12 17:06:59', '2026-02-14 17:02:14', NULL, 'N', 21, NULL), (6, 6, 23, 1, 4, 15, '2028-08-31', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 70, NULL), (7, 7, 23, 1, 4, 10, '2027-11-30', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 460, NULL), (8, 8, 23, 1, 22, 50, '2026-08-31', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 97, NULL), (9, 9, 23, 1, 42, 75, '2027-01-31', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 67, NULL), (10, 10, 23, 1, 9, 35, '2026-05-31', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 26, NULL), (11, 11, 23, 1, 18, 50, '2027-08-31', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 66, NULL), (12, 12, 23, 1, 10, 30, '2027-12-31', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 6, NULL), (13, 13, 23, 1, 90, 175, '2027-02-28', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 7, NULL), (14, 14, 23, 1, 80, 140, '2027-02-28', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 13, NULL), (15, 15, 23, 1, 30, 95, '2026-11-30', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 8, NULL), (16, 16, 23, 1, 80, 150, '2029-02-28', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 2, NULL), (17, 17, 23, 1, 6, 20, '2028-03-31', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 320, NULL), (18, 18, 23, 1, 50, 100, '2028-02-29', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 1, NULL), (19, 19, 23, 1, 9, 35, '2028-03-30', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 36, NULL), (20, 20, 23, 1, 98, 175, '2028-02-28', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 10, NULL), (21, 21, 23, 1, 18, 50, '2026-02-28', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 17, NULL), (22, 22, 23, 1, 22, 60, '2027-05-31', '2026-02-12 17:06:59', '2026-02-12 17:06:59', NULL, 'N', 10, NULL), (47, 47, 25, 1, 17, 30, '2026-12-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 20, NULL), (48, 48, 25, 1, 44, 100, '2027-02-28', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 34, NULL), (49, 49, 25, 1, 370, 560, '2029-04-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 5, NULL), (50, 50, 25, 1, 100, 200, '2027-03-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 8, NULL), (51, 51, 25, 1, 27, 65, '2926-10-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 28, NULL), (52, 52, 25, 1, 65, 150, '2027-06-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 7, NULL), (53, 53, 25, 1, 233, 400, '2027-01-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 12, NULL), (54, 54, 25, 1, 41, 130, '2027-06-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 53, NULL), (55, 55, 25, 1, 54, 100, '2028-04-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 15, NULL), (56, 56, 25, 1, 70, 120, '2027-09-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 3, NULL), (57, 57, 25, 1, 400, 575, '2027-07-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 3, NULL), (58, 58, 25, 1, 6, 15, '2030-03-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 16, NULL), (59, 59, 25, 1, 80, 180, '2028-03-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 18, NULL), (60, 60, 25, 1, 25, 50, '2028-06-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 51, NULL), (61, 61, 25, 1, 69, 120, '2028-04-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 18, NULL), (62, 62, 25, 1, 100, 175, '2028-05-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 2, NULL), (63, 63, 25, 1, 66, 125, '2026-12-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 19, NULL), (64, 64, 25, 1, 550, 850, '2030-01-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 3, NULL), (65, 65, 25, 1, 200, 300, '2027-06-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 1, NULL), (66, 66, 25, 1, 90, 175, '2026-07-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 4, NULL), (67, 67, 25, 1, 90, 175, '2028-08-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 3, NULL), (68, 68, 25, 1, 70, 130, '2026-09-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 6, NULL), (69, 69, 25, 1, 10, 30, '2026-02-28', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 54, NULL), (70, 70, 25, 1, 10, 30, '2027-07-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 20, NULL), (71, 71, 25, 1, 60, 150, '2027-04-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 4, NULL), (72, 72, 25, 1, 25, 50, '2027-01-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 9, NULL), (73, 73, 25, 1, 79, 150, '2028-12-31', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 17, NULL), (74, 74, 25, 1, 15, 40, '2028-04-30', '2026-02-12 17:36:24', '2026-02-12 17:36:24', NULL, 'N', 20, NULL), (75, 75, 24, 1, 12, 40, '2026-11-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 19, NULL), (76, 76, 24, 1, 9, 40, '2027-11-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 20, NULL), (77, 77, 24, 1, 10, 40, '2027-06-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 37, NULL), (78, 78, 24, 1, 35, 100, '2028-03-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 15, NULL), (79, 79, 24, 1, 12, 40, '2027-12-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 8, NULL), (80, 80, 24, 1, 15, 75, '2027-07-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 10, NULL), (81, 81, 24, 1, 90, 160, '2027-02-28', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 4, NULL), (82, 82, 24, 1, 11, 35, '2027-10-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 57, NULL), (83, 83, 24, 1, 9, 30, '2026-11-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 5, NULL), (84, 84, 24, 1, 32, 75, '2027-10-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 9, NULL), (85, 85, 24, 1, 15, 40, '2027-04-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 9, NULL), (86, 86, 24, 1, 70, 120, '2028-05-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 19, NULL), (87, 87, 24, 1, 90, 150, '2028-05-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 8, NULL), (88, 88, 24, 1, 65, 120, '2028-03-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 12, NULL), (89, 89, 24, 1, 25, 60, '2028-04-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 70, NULL), (90, 90, 24, 1, 20, 40, '2026-04-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 15, NULL), (91, 91, 24, 1, 41, 75, '2027-10-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 20, NULL), (92, 92, 24, 1, 9, 35, '2027-10-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 64, NULL), (93, 93, 24, 1, 70, 150, '2026-11-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 6, NULL), (94, 94, 24, 1, 33, 75, '2027-04-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 9, NULL), (95, 95, 24, 1, 53, 100, '2027-06-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 16, NULL), (96, 96, 24, 1, 147, 175, '2028-08-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 10, NULL), (97, 97, 24, 1, 65, 150, '2026-05-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 13, NULL), (98, 98, 24, 1, 80, 150, '2028-02-28', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 4, NULL), (99, 99, 24, 1, 10, 30, '2027-04-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 31, NULL), (100, 100, 24, 1, 6, 100, '2027-05-31', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 254, NULL), (101, 101, 24, 1, 49, 175, '2028-06-30', '2026-02-12 18:11:23', '2026-02-12 18:11:23', NULL, 'N', 5, NULL), (102, 102, 26, 1, 145, 220, '2028-09-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 8, NULL), (103, 103, 26, 1, 42, 90, '2028-07-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 16, NULL), (104, 104, 26, 1, 57, 150, '2028-07-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 10, NULL), (105, 105, 26, 1, 58, 75, '2028-07-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 4, NULL), (106, 106, 26, 1, 30, 50, '2027-04-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 14, NULL), (107, 107, 26, 1, 70, 140, '2027-09-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 10, NULL), (108, 108, 26, 1, 16, 35, '2027-08-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 59, NULL), (109, 109, 26, 1, 71, 120, '2027-09-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 6, NULL), (110, 110, 26, 1, 35, 75, '2027-09-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 5, NULL), (111, 111, 26, 1, 80, 150, '2027-02-28', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 3, NULL), (112, 112, 26, 1, 14, 25, '2028-02-28', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 80, NULL), (113, 113, 26, 1, 75, 125, '2027-10-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 4, NULL), (114, 114, 26, 1, 40, 80, '2027-10-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 10, NULL), (115, 115, 26, 1, 75, 150, '2027-09-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 25, NULL), (116, 116, 26, 1, 35, 85, '2030-01-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 9, NULL), (117, 117, 26, 1, 104, 175, '2027-08-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 2, NULL), (118, 118, 26, 1, 104, 175, '2027-08-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 1, NULL), (119, 119, 26, 1, 50, 120, '2026-12-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 4, NULL), (120, 120, 26, 1, 35, 400, '2026-07-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 5, NULL), (121, 121, 26, 1, 110, 175, '2026-11-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 4, NULL), (122, 122, 26, 1, 118, 150, '2027-07-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 10, NULL), (123, 123, 26, 1, 10, 30, '2027-11-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 32, NULL), (124, 124, 26, 1, 9, 30, '2027-11-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 26, NULL), (125, 125, 26, 1, 32, 75, '2027-11-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 9, NULL), (126, 126, 26, 1, 60, 150, '2027-11-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 4, NULL), (127, 127, 26, 1, 130, 220, '2028-02-29', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 2, NULL), (128, 128, 26, 1, 8, 25, '2029-03-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 17, NULL), (129, 129, 26, 1, 75, 150, '2030-05-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 9, NULL), (130, 130, 26, 1, 50, 120, '2030-05-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 12, NULL), (131, 131, 26, 1, 40, 100, '2029-08-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 9, NULL), (132, 132, 26, 1, 11, 50, '2027-10-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 27, NULL), (133, 133, 26, 1, 11, 40, '2027-09-30', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 85, NULL), (134, 134, 26, 1, 120, 220, '2028-03-31', '2026-02-12 18:24:36', '2026-02-12 18:24:36', NULL, 'N', 12, NULL), (135, 135, 27, 1, 20, 35, '2029-02-28', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 9, NULL), (136, 136, 27, 1, 3, 5, '2027-12-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 27, NULL), (137, 137, 27, 1, 10, 25, '2028-02-28', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 92, NULL), (138, 138, 27, 1, 45, 75, '2027-03-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 9, NULL), (139, 139, 27, 1, 19, 35, '2026-12-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 20, NULL), (140, 140, 27, 1, 60, 150, '2027-10-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 6, NULL), (141, 141, 27, 1, 90, 150, '2026-11-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 6, NULL), (142, 142, 27, 1, 58, 90, '2027-06-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 2, NULL), (143, 143, 27, 1, 9, 30, '2027-01-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 17, NULL), (144, 144, 27, 1, 10, 30, '2028-04-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 26, NULL), (145, 145, 27, 1, 9, 30, '2027-09-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 30, NULL), (146, 146, 27, 1, 140, 240, '2027-08-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 2, NULL), (147, 147, 27, 1, 9, 30, '2027-10-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 50, NULL), (148, 148, 27, 1, 30, 75, '2030-04-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 30, NULL), (149, 149, 27, 1, 12, 45, '2027-04-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 28, NULL), (150, 150, 27, 1, 132, 215, '2030-04-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 5, NULL), (151, 151, 27, 1, 17, 30, '2026-05-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 6, NULL), (152, 152, 27, 1, 92, 150, '2027-10-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 3, NULL), (153, 153, 27, 1, 125, 200, '2027-07-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 4, NULL), (154, 154, 27, 1, 125, 200, '2027-07-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 7, NULL), (155, 155, 27, 1, 45, 120, '2027-02-28', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 17, NULL), (156, 156, 27, 1, 169, 275, '2027-12-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 3, NULL), (157, 157, 27, 1, 13, 30, '2027-12-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 6, NULL), (158, 158, 27, 1, 9, 30, '2027-09-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 39, NULL), (159, 159, 27, 1, 72, 120, '2027-06-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 7, NULL), (160, 160, 27, 1, 43, 85, '2026-08-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 69, NULL), (161, 161, 27, 1, 52, 150, '2027-08-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 27, NULL), (162, 162, 27, 1, 25, 75, '2027-09-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 7, NULL), (163, 163, 27, 1, 69, 150, '2027-09-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 10, NULL), (164, 164, 27, 1, 99, 20, '2027-08-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 1, NULL), (165, 165, 27, 1, 60, 150, '2027-04-30', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 10, NULL), (166, 166, 27, 1, 52, 150, '2027-12-31', '2026-02-12 18:32:14', '2026-02-12 18:32:14', NULL, 'N', 7, NULL), (167, 167, 28, 1, 125, 200, '2030-03-31', '2026-02-12 18:42:45', '2026-02-12 18:42:45', NULL, 'N', 3, NULL), (168, 168, 28, 1, 70, 130, '2028-02-28', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 7, NULL), (169, 169, 28, 1, 65, 150, '2028-05-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 9, NULL), (170, 170, 28, 1, 45, 110, '2027-06-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 13, NULL), (171, 171, 28, 1, 75, 155, '2027-05-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 7, NULL), (172, 172, 28, 1, 65, 150, '2028-04-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 18, NULL), (173, 173, 28, 1, 5, 20, '2027-09-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 63, NULL), (174, 174, 28, 1, 16, 40, '2028-03-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 10, NULL), (175, 175, 28, 1, 200, 350, '2027-10-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 10, NULL), (176, 176, 28, 1, 14, 25, '2028-08-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 24, NULL), (177, 177, 28, 1, 14, 25, '2028-08-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 24, NULL), (178, 178, 28, 1, 33, 75, '2027-05-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 20, NULL), (179, 179, 28, 1, 200, 450, '2027-04-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 3, NULL), (180, 180, 28, 1, 19, 35, '2029-01-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 5, NULL), (181, 181, 28, 1, 19, 35, '2028-06-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 7, NULL), (182, 182, 28, 1, 75, 150, '2026-11-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 14, NULL), (183, 183, 28, 1, 7, 30, '2026-12-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 4, NULL), (184, 184, 28, 1, 60, 150, '2028-05-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 8, NULL), (185, 185, 28, 1, 104, 175, '2027-02-28', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 8, NULL), (186, 186, 28, 1, 40, 75, '2027-02-28', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 10, NULL), (187, 187, 28, 1, 95, 175, '2027-08-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 3, NULL), (188, 188, 28, 1, 245, 375, '2026-06-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 4, NULL), (189, 189, 28, 1, 192, 300, '2026-06-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 4, NULL), (190, 190, 28, 1, 250, 750, '2026-10-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 29, NULL), (191, 191, 28, 1, 15, 50, '2028-05-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 105, NULL), (192, 192, 28, 1, 10, 20, '2027-06-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 34, NULL), (193, 193, 28, 1, 40, 75, '2028-01-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 25, NULL), (194, 194, 28, 1, 44, 100, '2027-09-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 7, NULL), (195, 195, 28, 1, 98, 175, '2029-01-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 19, NULL), (196, 196, 28, 1, 35, 175, '2026-10-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 17, NULL), (197, 197, 28, 1, 12, 30, '2026-03-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 10, NULL), (198, 198, 28, 1, 30, 90, '2027-05-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 14, NULL), (199, 199, 28, 1, 104, 175, '2029-08-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 3, NULL), (200, 200, 28, 1, 15, 30, '2027-10-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 8, NULL), (201, 201, 28, 1, 95, 155, '2027-07-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 13, NULL), (202, 202, 28, 1, 123, 220, '2026-08-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 17, NULL), (203, 203, 28, 1, 50, 130, '2028-01-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 4, NULL), (204, 204, 28, 1, 2, 5, '2028-08-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 489, NULL), (205, 205, 28, 1, 2, 5, '2028-08-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 114, NULL), (206, 206, 28, 1, 2, 5, '2028-09-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 217, NULL), (207, 207, 28, 1, 32, 75, '2027-09-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 10, NULL), (208, 208, 28, 1, 50, 100, '2027-07-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 4, NULL), (209, 209, 28, 1, 38, 75, '2027-12-31', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 26, NULL), (210, 210, 28, 1, 68, 150, '2028-02-28', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 5, NULL), (211, 211, 28, 1, 55, 120, '2027-06-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 15, NULL), (212, 212, 28, 1, 45, 100, '2028-02-28', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 45, NULL), (213, 213, 28, 1, 140, 220, '2028-09-30', '2026-02-12 18:42:46', '2026-02-12 18:42:46', NULL, 'N', 2, NULL), (214, 23, 29, 1, 60, 120, '2028-04-30', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 11, NULL), (215, 24, 29, 1, 50, 60, '2028-03-31', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 6, NULL), (216, 25, 29, 1, 120, 200, '2028-05-31', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 8, NULL), (217, 26, 29, 1, 80, 150, '2028-01-31', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 13, NULL), (218, 27, 29, 1, 61, 120, '2027-12-31', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 14, NULL), (219, 28, 29, 1, 49, 150, '2027-12-31', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 10, NULL), (220, 29, 29, 1, 422, 700, '2028-02-28', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 3, NULL), (221, 30, 29, 1, 340, 550, '2027-08-31', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 3, NULL), (222, 31, 29, 1, 92, 175, '2027-10-31', '2026-02-12 18:49:19', '2026-02-12 18:49:19', NULL, 'N', 4, NULL), (223, 32, 30, 1, 42, 110, '2026-10-31', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 13, NULL), (224, 33, 30, 1, 7, 15, '2026-10-31', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 146, NULL), (225, 34, 30, 1, 70, 150, '2028-02-28', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 9, NULL), (226, 35, 30, 1, 66, 130, '2027-04-30', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 5, NULL), (227, 36, 30, 1, 45, 120, '2028-08-31', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 17, NULL), (228, 37, 30, 1, 60, 150, '2026-03-31', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 9, NULL), (229, 38, 30, 1, 147, 165, '2027-06-30', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 8, NULL), (230, 39, 30, 1, 65, 120, '2027-07-30', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 11, NULL), (231, 40, 30, 1, 86, 150, '2028-07-31', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 12, NULL), (232, 41, 30, 1, 12, 30, '2028-08-19', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 90, NULL), (233, 42, 30, 1, 160, 250, '2027-10-30', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 7, NULL), (234, 43, 30, 1, 47, 120, '2026-11-30', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 8, NULL), (235, 44, 30, 1, 12, 30, '2027-10-31', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 11, NULL), (236, 45, 30, 1, 11, 45, '2030-04-27', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 6, NULL), (237, 46, 30, 1, 55, 120, '2028-01-31', '2026-02-12 18:51:22', '2026-02-12 18:51:22', NULL, 'N', 12, NULL); -- Dumping structure for table ecs.recorrencias_despesas CREATE TABLE IF NOT EXISTS `recorrencias_despesas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `despesa_original_id` bigint unsigned NOT NULL, `proxima_ocorrencia` date NOT NULL, `frequencia` enum('diaria','semanal','mensal','anual') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `dias_mes` int DEFAULT NULL COMMENT 'Dia específico do mês para cobrança', `dias_semana` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Dias da semana (para recorrência semanal)', `finalizado` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `recorrencias_despesas_despesa_original_id_foreign` (`despesa_original_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.recorrencias_despesas: ~0 rows (approximately) -- Dumping structure for procedure ecs.RegistoUsuario DELIMITER // CREATE PROCEDURE `RegistoUsuario`(`nome` VARCHAR(200), `email` VARCHAR(200), `tipofuncionario` VARCHAR(200), `sexo` CHAR(1), `funcionario_registo` INT, `provincia` VARCHAR(40), `Distrito` VARCHAR(40)) begin end// DELIMITER ; -- Dumping structure for procedure ecs.reniciarbanco DELIMITER // CREATE PROCEDURE `reniciarbanco`() BEGIN -- Desativa verificação de chave estrangeira SET FOREIGN_KEY_CHECKS = 0; DELETE FROM produtosvendas; ALTER TABLE produtosvendas AUTO_INCREMENT = 1; DELETE FROM vendas; ALTER TABLE vendas AUTO_INCREMENT = 1; DELETE FROM lojas; ALTER TABLE lojas AUTO_INCREMENT = 1; DELETE FROM produto_compra; ALTER TABLE produto_compra AUTO_INCREMENT = 1; DELETE FROM produtos; ALTER TABLE produtos AUTO_INCREMENT = 1; DELETE FROM compras WHERE id>0; ALTER TABLE compras AUTO_INCREMENT = 1; -- Reativa verificação de chave estrangeira SET FOREIGN_KEY_CHECKS = 1; END// DELIMITER ; -- Dumping structure for table ecs.roles CREATE TABLE IF NOT EXISTS `roles` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `label` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.roles: ~3 rows (approximately) INSERT INTO `roles` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'Admin do systema', NULL, '2021-06-27 05:36:20'), (19, 'Técnico de Farmácia', 'Técnico de Farmácia', '2021-07-03 03:48:34', '2021-07-03 03:48:34'), (21, 'Tecnico', 'Gerente de Farmacia', '2024-02-24 04:37:11', '2024-02-24 04:37:11'); -- Dumping structure for table ecs.role_user CREATE TABLE IF NOT EXISTS `role_user` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `role_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `role_id` (`role_id`), KEY `user_id` (`user_id`), CONSTRAINT `role_user_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`), CONSTRAINT `role_user_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.role_user: ~5 rows (approximately) INSERT INTO `role_user` (`id`, `user_id`, `role_id`, `created_at`, `updated_at`) VALUES (1, 1, 1, NULL, '2020-08-12 15:13:16'), (49, 15, 1, NULL, NULL), (50, 24, 1, '2025-08-15 06:48:12', '2025-08-15 06:48:12'), (59, 28, 1, '2025-08-28 10:40:36', '2025-08-28 10:40:36'), (60, 29, 19, '2025-12-27 15:18:31', '2025-12-27 15:18:31'); -- Dumping structure for procedure ecs.sp_QuantidadesPorProduto DELIMITER // CREATE PROCEDURE `sp_QuantidadesPorProduto`() BEGIN SELECT p.id AS produto_id, p.nome, p.nome_generico, p.Concentracao, f.Descricao AS formulacao, c.Descricao AS categoria, -- Quantidade total por armazém ad.Descricao AS armazem, SUM(pc.Quantidade) AS total_armazem, -- Quantidade total por loja ld.Descricao AS loja, SUM(COALESCE(l.qunatidade, 0)) AS total_loja FROM produtos p LEFT JOIN produto_compra pc ON pc.produto_id = p.id LEFT JOIN armazem_desc ad ON ad.id = pc.armazem_id LEFT JOIN compras co ON co.id = pc.compra_id LEFT JOIN categorias c ON c.id = p.categoria_id LEFT JOIN formulacao f ON f.id = p.formulacao_id -- JOIN nas lojas LEFT JOIN lojas l ON l.produto_id = pc.id LEFT JOIN lojas_desc ld ON ld.id = l.loja_desc_id GROUP BY p.id, ad.id, ld.id ORDER BY p.nome ASC; END// DELIMITER ; -- Dumping structure for procedure ecs.sp_QuantidadesPorProduto2 DELIMITER // CREATE PROCEDURE `sp_QuantidadesPorProduto2`() BEGIN SELECT p.id AS produto_id, p.nome, p.nome_generico, p.Concentracao, f.Descricao AS formulacao, c.Descricao AS categoria, -- Quantidade total por armazém ad.Descricao AS armazem, SUM(pc.Quantidade) AS total_armazem, -- Quantidade total por loja ld.Descricao AS loja, SUM(COALESCE(l.qunatidade, 0)) AS total_loja FROM produtos p JOIN produto_compra pc ON pc.produto_id = p.id LEFT JOIN armazem_desc ad ON ad.id = pc.armazem_id LEFT JOIN compras co ON co.id = pc.compra_id LEFT JOIN categorias c ON c.id = p.categoria_id LEFT JOIN formulacao f ON f.id = p.formulacao_id -- JOIN nas lojas LEFT JOIN lojas l ON l.produto_id = pc.id LEFT JOIN lojas_desc ld ON ld.id = l.loja_desc_id GROUP BY p.id, ad.id, ld.id ORDER BY p.nome ASC; END// DELIMITER ; -- Dumping structure for table ecs.tabelainicial CREATE TABLE IF NOT EXISTS `tabelainicial` ( `id` int NOT NULL AUTO_INCREMENT, `NomeFarmacia` varchar(45) NOT NULL, `LogoTipo` varchar(45) NOT NULL, `LicencaTipo` varchar(45) NOT NULL, `senhaLisenca` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table ecs.tabelainicial: ~0 rows (approximately) -- Dumping structure for table ecs.tipo_d_funcionario CREATE TABLE IF NOT EXISTS `tipo_d_funcionario` ( `id` int NOT NULL AUTO_INCREMENT, `descricao` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `tipo_d_funcionario_ibfk_1` FOREIGN KEY (`id`) REFERENCES `funcionario` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- Dumping data for table ecs.tipo_d_funcionario: ~0 rows (approximately) -- Dumping structure for table ecs.users CREATE TABLE IF NOT EXISTS `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_aprovador` tinyint(1) NOT NULL DEFAULT '0', `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `codigo` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `usuario_idcadastro` bigint DEFAULT NULL, `limite_aprovacao` decimal(12,2) DEFAULT NULL COMMENT 'Limite máximo que o usuário pode aprovar', `can_approve_expenses` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ecs.users: ~3 rows (approximately) INSERT INTO `users` (`id`, `name`, `email`, `is_aprovador`, `email_verified_at`, `password`, `deleted_at`, `remember_token`, `created_at`, `updated_at`, `codigo`, `usuario_idcadastro`, `limite_aprovacao`, `can_approve_expenses`) VALUES (1, 'Dimene Luis', 'dimeneluis@gmail.com', 1, NULL, '$2y$10$fswof.C4Xg30.4/z.6p0TeIMEyFMg.TP4z/9a17y7/p1GsUas2vpe', NULL, '2qyLSzdg727F1FyLcluoeNEr4SenmOwtAPgYg6TuXB7aBJ2lR0I4aL7AvNpG', NULL, '2020-09-21 10:43:04', '34565', NULL, NULL, 0), (28, 'Ernesto Cesar Services', 'cesar@ecs.co.mz', 0, NULL, '$2y$10$QDKxuBI4wXsw8jtSOKdLUuvdXifWsPR01kyO.JvuK3Lfo/thXeK4.', NULL, 'uaeMZUiJkrg2kP1y6SIlLIDIXx520QR8e2ADsVeqoPRBdzgg65ADAYSZpF6n', '2025-08-23 17:00:02', '2025-08-28 10:41:18', '1212', NULL, NULL, 0), (29, 'Tecnico de Farmacia', 'tecnico@gmail.com', 0, NULL, '$2y$10$H9.WfOGtFschWSU/WZiS0O6M9x/jkTIR3CSS9m6OTvehFW2EESJOS', NULL, NULL, '2025-12-27 15:18:31', '2025-12-27 15:18:31', '03', NULL, NULL, 0); -- Dumping structure for table ecs.vendas CREATE TABLE IF NOT EXISTS `vendas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `TipodeVenda` varchar(45) NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dataVenda` date DEFAULT NULL, `clinete_id` bigint unsigned NOT NULL, `ValorPago` decimal(10,0) DEFAULT NULL, `TipoPagamento` int DEFAULT '1', PRIMARY KEY (`id`), KEY `clinete_id_idx` (`clinete_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- Dumping data for table ecs.vendas: ~4 rows (approximately) INSERT INTO `vendas` (`id`, `user_id`, `TipodeVenda`, `deleted_at`, `created_at`, `updated_at`, `dataVenda`, `clinete_id`, `ValorPago`, `TipoPagamento`) VALUES (1, 28, 'compra', NULL, '2026-02-14 17:02:44', '2026-02-14 17:02:44', '2026-02-14', 1, NULL, NULL), (2, 28, 'compra', NULL, '2026-02-14 17:03:02', '2026-02-14 17:03:02', '2026-02-14', 1, 100, 1), (3, 29, 'compra', NULL, '2026-02-14 17:03:52', '2026-02-14 17:03:52', '2026-02-14', 1, 10, 1), (4, 28, 'compra', NULL, '2026-02-22 04:10:19', '2026-02-22 04:10:19', '2026-02-22', 1, 100, 1), (5, 28, 'compra', NULL, '2026-04-20 14:47:06', '2026-04-20 14:47:06', '2026-04-20', 1, 100, 1); -- Dumping structure for view ecs.vendidosloja -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `vendidosloja` ( `id` BIGINT(20) UNSIGNED NOT NULL, `produto_id` BIGINT(20) UNSIGNED NOT NULL, `qunatidade` DECIMAL(10,0) NOT NULL, `deleted_at` TIMESTAMP NULL, `created_at` TIMESTAMP NULL, `updated_at` TIMESTAMP NULL, `venda_id` BIGINT(20) UNSIGNED NOT NULL, `lojas_desc_id` INT(10) NULL, `lojas` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci' ) ENGINE=MyISAM; -- Dumping structure for view ecs.dadosprodutoscompra -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `dadosprodutoscompra`; CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `dadosprodutoscompra` AS select `produtos`.`nome` AS `nome`,`produtos`.`nome_generico` AS `nome_generico`,`produto_compra`.`id` AS `id`,`produto_compra`.`produto_id` AS `produto_id`,`produto_compra`.`compra_id` AS `compra_id`,`produto_compra`.`armazem_id` AS `armazem_id`,`produto_compra`.`preco_compra` AS `preco_compra`,(`produto_compra`.`preco_compra` * `produto_compra`.`Quantidade`) AS `preco_compraTotal`,`produto_compra`.`preco_venda` AS `preco_venda`,(`produto_compra`.`preco_venda` * `produto_compra`.`Quantidade`) AS `preco_vendaTotal`,`produto_compra`.`data_validade` AS `data_validade`,`produto_compra`.`created_at` AS `created_at`,`produto_compra`.`updated_at` AS `updated_at`,`produto_compra`.`codigo_barras` AS `codigo_barras`,`produto_compra`.`lote` AS `lote`,`produto_compra`.`Quantidade` AS `Quantidade`,`produto_compra`.`deleted_at` AS `deleted_at`,`produtos`.`categoria_id` AS `categoria_id`,`categorias`.`Descricao` AS `categoria`,`produtos`.`formulacao_id` AS `formulacao_id`,`formulacao`.`Descricao` AS `formulacao`,`produtos`.`Concentracao` AS `Concentracao`,`produtos`.`temperatura_Conservacao` AS `temperatura_Conservacao`,`compras`.`user_id` AS `user_id`,`compras`.`Fornecedor_id` AS `Fornecedor_id`,`compras`.`datacompra` AS `datacompra`,`compras`.`Codigo_Fatura` AS `Codigo_Fatura` from ((((`produto_compra` join `produtos` on((`produto_compra`.`produto_id` = `produtos`.`id`))) left join `categorias` on((`categorias`.`id` = `produtos`.`categoria_id`))) left join `formulacao` on((`formulacao`.`id` = `produtos`.`formulacao_id`))) left join `compras` on((`compras`.`id` = `produto_compra`.`compra_id`))); -- Dumping structure for view ecs.farmacosexistete -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `farmacosexistete`; CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `farmacosexistete` AS select `produtos`.`id` AS `produto_id`,`produtos`.`id` AS `id`,`produtos`.`nome` AS `nome`,`produtos`.`nome_generico` AS `nome_generico`,`produtos`.`temperatura_Conservacao` AS `temperatura_Conservacao`,`produtos`.`Concentracao` AS `Concentracao`,`formulacao`.`id` AS `formulcao_id`,`formulacao`.`Descricao` AS `formulacao`,`categorias`.`id` AS `categoria_id`,`categorias`.`Descricao` AS `categorias`,`produto_compra`.`preco_venda` AS `preco_venda`,`produto_compra`.`preco_compra` AS `preco_compra`,`produto_compra`.`data_validade` AS `data_validade`,`produto_compra`.`Quantidade` AS `QuantidadeArmazem`,`produto_compra`.`armazem_id` AS `armazem_id`,`armazem_desc`.`Descrcao` AS `armazem`,`produto_compra`.`lote` AS `lote`,`compras`.`Codigo_Fatura` AS `Codigo_Fatura`,`compras`.`datacompra` AS `datacompra`,`lojas`.`id` AS `loja_produto_id`,`lojas`.`qunatidade` AS `Quantidadeloja`,`lojas`.`data_alocacao` AS `data_alocacao`,`lojas_desc`.`id` AS `loja_id`,`lojas_desc`.`Descricao` AS `loja` from (((((((`produto_compra` left join `produtos` on((`produto_compra`.`produto_id` = `produtos`.`id`))) left join `categorias` on((`categorias`.`id` = `produtos`.`categoria_id`))) left join `formulacao` on((`formulacao`.`id` = `produtos`.`formulacao_id`))) left join `lojas` on((`lojas`.`produto_id` = `produto_compra`.`id`))) left join `armazem_desc` on((`armazem_desc`.`id` = `produto_compra`.`armazem_id`))) left join `lojas_desc` on((`lojas_desc`.`id` = `lojas`.`loja_desc_id`))) left join `compras` on((`compras`.`id` = `produto_compra`.`compra_id`))); -- Dumping structure for view ecs.farmacosnafarmacia -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `farmacosnafarmacia`; CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `farmacosnafarmacia` AS select `lojas`.`id` AS `id`,`lojas`.`produto_id` AS `produto_id`,`produtos`.`id` AS `idproduto`,`produtos`.`nome` AS `nome_Comercial`,`produtos`.`nome` AS `nome`,`produtos`.`nome_generico` AS `nome_generico`,`formulacao`.`Descricao` AS `Formulacao`,`produto_compra`.`preco_compra` AS `Preco_Compra`,`produto_compra`.`preco_venda` AS `preco_venda`,`produtos`.`formulacao_id` AS `formulacao_id`,`produto_compra`.`data_validade` AS `data_validade`,(`produto_compra`.`preco_venda` - `produto_compra`.`preco_compra`) AS `LucroUnitario`,(`lojas`.`qunatidade` * `produto_compra`.`preco_compra`) AS `precoCompraTotal`,(`lojas`.`qunatidade` * `produto_compra`.`preco_venda`) AS `precoVendaTotal`,((`lojas`.`qunatidade` * `produto_compra`.`preco_venda`) - (`lojas`.`qunatidade` * `produto_compra`.`preco_compra`)) AS `LucroTotal`,`lojas`.`qunatidade` AS `qunatidade`,`lojas`.`loja_desc_id` AS `loja_desc_id` from (((((`lojas` left join `produto_compra` on((`produto_compra`.`id` = `lojas`.`produto_id`))) left join `produtos` on((`produtos`.`id` = `produto_compra`.`produto_id`))) left join `lojas_desc` on((`lojas_desc`.`id` = `lojas`.`loja_desc_id`))) left join `formulacao` on((`formulacao`.`id` = `produtos`.`formulacao_id`))) left join `categorias` on((`categorias`.`id` = `produtos`.`categoria_id`))) where (`lojas`.`qunatidade` > 0); -- Dumping structure for view ecs.farmacosnafarmaciaview -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `farmacosnafarmaciaview`; CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `farmacosnafarmaciaview` AS select `farmacosnafarmacia`.`id` AS `id`,`farmacosnafarmacia`.`produto_id` AS `produto_id`,`farmacosnafarmacia`.`idproduto` AS `idproduto`,`farmacosnafarmacia`.`nome_Comercial` AS `nome_Comercial`,`farmacosnafarmacia`.`nome` AS `nome`,`farmacosnafarmacia`.`nome_generico` AS `nome_generico`,`farmacosnafarmacia`.`Formulacao` AS `formulacao`,`farmacosnafarmacia`.`Preco_Compra` AS `Preco_Compra`,`farmacosnafarmacia`.`preco_venda` AS `preco_venda`,`farmacosnafarmacia`.`formulacao_id` AS `formulacao_id`,`farmacosnafarmacia`.`data_validade` AS `data_validade`,sum(`farmacosnafarmacia`.`LucroUnitario`) AS `LucroUnitario`,sum(`farmacosnafarmacia`.`precoCompraTotal`) AS `precoCompraTotal`,sum(`farmacosnafarmacia`.`precoCompraTotal`) AS `preco_compraTotal`,sum(`farmacosnafarmacia`.`precoVendaTotal`) AS `precoVendaTotal`,sum(`farmacosnafarmacia`.`LucroTotal`) AS `LucroTotal`,sum(`farmacosnafarmacia`.`qunatidade`) AS `Quantidade`,sum(`farmacosnafarmacia`.`qunatidade`) AS `qunatidade`,`farmacosnafarmacia`.`loja_desc_id` AS `loja_desc_id`,`produtos`.`created_at` AS `dataInicial`,sum(`farmacosnafarmacia`.`precoVendaTotal`) AS `precoVendaTotalFiltre` from (`farmacosnafarmacia` join `produtos` on((`produtos`.`id` = `farmacosnafarmacia`.`idproduto`))) group by `farmacosnafarmacia`.`id`,`farmacosnafarmacia`.`produto_id`,`farmacosnafarmacia`.`idproduto`,`farmacosnafarmacia`.`nome_Comercial`,`farmacosnafarmacia`.`nome`,`farmacosnafarmacia`.`nome_generico`,`farmacosnafarmacia`.`Formulacao`,`farmacosnafarmacia`.`Preco_Compra`,`farmacosnafarmacia`.`preco_venda`,`farmacosnafarmacia`.`formulacao_id`,`farmacosnafarmacia`.`loja_desc_id`,`produtos`.`created_at`; -- Dumping structure for view ecs.produtosvendidosview -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `produtosvendidosview`; CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `produtosvendidosview` AS select `produtosvendas`.`id` AS `id`,`produtosvendas`.`produto_id` AS `produto_id`,`produtos`.`id` AS `idproduto`,`produtos`.`nome` AS `nome_Comercial`,`produtos`.`nome` AS `nome`,`produtos`.`nome_generico` AS `nome_generico`,`formulacao`.`Descricao` AS `Formulacao`,`produto_compra`.`preco_compra` AS `Preco_Compra`,`produto_compra`.`preco_venda` AS `preco_venda`,`produtos`.`formulacao_id` AS `formulacao_id`,(`produto_compra`.`preco_venda` - `produto_compra`.`preco_compra`) AS `LucroUnitario`,(`produtosvendas`.`qunatidade` * `produto_compra`.`preco_compra`) AS `precoCompraTotal`,(`produtosvendas`.`qunatidade` * `produto_compra`.`preco_venda`) AS `precoVendaTotal`,((`produtosvendas`.`qunatidade` * `produto_compra`.`preco_venda`) - (`produtosvendas`.`qunatidade` * `produto_compra`.`preco_compra`)) AS `LucroTotal`,`produtosvendas`.`qunatidade` AS `qunatidade`,`vendas`.`TipodeVenda` AS `TipodeVenda`,`vendas`.`dataVenda` AS `dataVenda`,`produtosvendas`.`venda_id` AS `venda_id`,`clientes`.`nome` AS `clientNome`,`lojas`.`loja_desc_id` AS `loja_desc_id`,`vendas`.`user_id` AS `user_id`,`users`.`name` AS `usuario_mome` from (((((((`vendas` join `produtos`) join `formulacao`) join `produto_compra`) join `produtosvendas`) join `clientes`) join `users`) join `lojas`) where ((`produtosvendas`.`produto_id` = `lojas`.`id`) and (`lojas`.`produto_id` = `produto_compra`.`id`) and (`vendas`.`id` = `produtosvendas`.`venda_id`) and (`clientes`.`id` = `vendas`.`clinete_id`) and (`users`.`id` = `vendas`.`user_id`) and (`produto_compra`.`produto_id` = `produtos`.`id`) and (`formulacao`.`id` = `produtos`.`formulacao_id`)); -- Dumping structure for view ecs.produtosview -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `produtosview`; CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `produtosview` AS select `produto_compra`.`id` AS `id`,`produtos`.`nome` AS `nome`,`produtos`.`nome_generico` AS `nome_generico`,`produtos`.`temperatura_Conservacao` AS `temperatura_Conservacao`,`produtos`.`formulacao_id` AS `formulacao_id`,`formulacao`.`Descricao` AS `formulacao`,`produtos`.`Concentracao` AS `Concentracao`,`produtos`.`categoria_id` AS `categoria_id`,`categorias`.`Descricao` AS `categorias`,`produto_compra`.`Quantidade` AS `Quantidade`,`produto_compra`.`preco_compra` AS `preco_compra`,`produto_compra`.`preco_venda` AS `preco_venda`,`produto_compra`.`data_validade` AS `data_validade`,`produto_compra`.`lote` AS `lote`,`produto_compra`.`deleted_at` AS `deleted_at`,`produto_compra`.`compra_id` AS `compra_id`,`produto_compra`.`codigo_barras` AS `codigo_barras` from (((`produto_compra` join `produtos` on((`produtos`.`id` = `produto_compra`.`produto_id`))) join `categorias` on((`categorias`.`id` = `produtos`.`categoria_id`))) join `formulacao` on((`formulacao`.`id` = `produtos`.`formulacao_id`))); -- Dumping structure for view ecs.produtovisalgeral -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `produtovisalgeral`; CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `produtovisalgeral` AS select `produtos`.`id` AS `produto_id`,`produto_compra`.`id` AS `produto_compra_id`,`produtos`.`nome` AS `nome_comercial`,`produtos`.`nome_generico` AS `nome_generico`,`produtos`.`Concentracao` AS `Concentracao`,`formulacao`.`id` AS `formulacao_id`,`formulacao`.`Descricao` AS `formulacao`,`compras`.`datacompra` AS `datacompra`,`vendas`.`dataVenda` AS `dataVenda`,`produto_compra`.`preco_compra` AS `preco_compra`,`produto_compra`.`preco_venda` AS `preco_venda`,`produtosvendas`.`qunatidade` AS `QuantidadeVendica`,`lojas`.`qunatidade` AS `QuantidadeNaloja`,`produto_compra`.`Quantidade` AS `QuantidadeNoArmazem`,`armazem_desc`.`Descrcao` AS `Armazem`,`produto_compra`.`armazem_id` AS `armazem_id`,`produto_compra`.`codigo_barras` AS `codigo_barras`,`categorias`.`Descricao` AS `categoria`,`produtos`.`categoria_id` AS `categoria_id`,`produto_compra`.`lote` AS `lote`,`produto_compra`.`compra_id` AS `compra_id`,`produtosvendas`.`venda_id` AS `venda_id`,`produto_compra`.`data_validade` AS `data_validade`,(`produtosvendas`.`qunatidade` * `produto_compra`.`preco_venda`) AS `valor_total_venda`,(`produtosvendas`.`qunatidade` * `produto_compra`.`preco_compra`) AS `valor_total_compra`,(`produto_compra`.`Quantidade` * `produto_compra`.`preco_venda`) AS `valor_total_venda_no_armazem`,(`produto_compra`.`Quantidade` * `produto_compra`.`preco_compra`) AS `valor_total_compra_no_armazem`,(`lojas`.`qunatidade` * `produto_compra`.`preco_venda`) AS `valor_total_venda_na_loja`,(`lojas`.`qunatidade` * `produto_compra`.`preco_compra`) AS `valor_total_compra_na_loja` from ((((((((`produto_compra` join `produtos` on((`produtos`.`id` = `produto_compra`.`produto_id`))) left join `lojas` on((`lojas`.`produto_id` = `produto_compra`.`id`))) left join `produtosvendas` on((`produtosvendas`.`produto_id` = `produto_compra`.`id`))) join `formulacao` on((`formulacao`.`id` = `produtos`.`formulacao_id`))) join `compras` on((`compras`.`id` = `produto_compra`.`compra_id`))) left join `vendas` on((`vendas`.`id` = `produtosvendas`.`venda_id`))) left join `armazem_desc` on((`armazem_desc`.`id` = `produto_compra`.`armazem_id`))) left join `categorias` on((`categorias`.`id` = `produtos`.`categoria_id`))); -- Dumping structure for view ecs.vendidosloja -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `vendidosloja`; CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `vendidosloja` AS select `produtosvendas`.`id` AS `id`,`produtosvendas`.`produto_id` AS `produto_id`,`produtosvendas`.`qunatidade` AS `qunatidade`,`produtosvendas`.`deleted_at` AS `deleted_at`,`produtosvendas`.`created_at` AS `created_at`,`produtosvendas`.`updated_at` AS `updated_at`,`produtosvendas`.`venda_id` AS `venda_id`,`lojas_desc`.`id` AS `lojas_desc_id`,`lojas_desc`.`Descricao` AS `lojas` from ((`produtosvendas` join `lojas` on((`lojas`.`id` = `produtosvendas`.`produto_id`))) left join `lojas_desc` on((`lojas_desc`.`id` = `lojas`.`loja_desc_id`))); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;