/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.15-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: italvettools_bdcrm
-- ------------------------------------------------------
-- Server version	10.11.15-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `audit_logs`
--

DROP TABLE IF EXISTS `audit_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `audit_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `action` varchar(100) NOT NULL,
  `entity_type` varchar(100) NOT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)),
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)),
  `ip_address` varchar(45) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_audit_logs_entity` (`entity_type`,`entity_id`),
  KEY `idx_audit_logs_user_id` (`user_id`),
  KEY `idx_audit_logs_created_at` (`created_at`),
  CONSTRAINT `audit_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `audit_logs`
--

LOCK TABLES `audit_logs` WRITE;
/*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */;
INSERT INTO `audit_logs` VALUES
(1,1,'update','lead',28,'{\"id\":\"28\",\"event_id\":null,\"first_name\":\"Bryan Angel\",\"last_name\":\"De La Cruz Soto\",\"email\":\"bdelacruz654@gmail.com\",\"phone\":\"+51912538004\",\"company\":\"Next Boost Per\\u00fa\",\"position\":\"\",\"city\":\"Sunampe\",\"region\":\"Ica\",\"client_type\":[\"Distribuidor\",\"Veterinario\"],\"industry\":[\"Nutrici\\u00f3n Animal\",\"Sanidad Animal\"],\"classification\":\"tibio\",\"observations\":\"\",\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"1\",\"duplicate_of\":\"23\",\"created_by\":\"1\",\"updated_by\":\"1\",\"created_at\":\"2026-06-24 13:34:39\",\"updated_at\":\"2026-06-24 15:17:16\",\"created_by_name\":\"Super Administrador\",\"technical_profile\":{\"id\":\"3\",\"lead_id\":\"28\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-06-24 13:34:39\",\"updated_at\":\"2026-06-24 13:34:39\"}}','{\"id\":\"28\",\"event_id\":null,\"first_name\":\"Bryan Angel\",\"last_name\":\"De La Cruz Soto\",\"email\":\"bdelacruz654@gmail.com\",\"phone\":\"+51912538004\",\"company\":\"Next Boost Per\\u00fa\",\"position\":\"\",\"city\":\"Sunampe\",\"region\":\"Ica\",\"client_type\":[\"Distribuidor\",\"Veterinario\"],\"industry\":[\"Nutrici\\u00f3n Animal\",\"Sanidad Animal\"],\"classification\":\"frio\",\"observations\":\"\",\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"1\",\"duplicate_of\":\"23\",\"created_by\":\"1\",\"updated_by\":\"1\",\"created_at\":\"2026-06-24 13:34:39\",\"updated_at\":\"2026-06-24 15:29:03\",\"created_by_name\":\"Super Administrador\",\"technical_profile\":{\"id\":\"3\",\"lead_id\":\"28\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-06-24 13:34:39\",\"updated_at\":\"2026-06-24 13:34:39\"},\"status_history\":[],\"timeline\":[],\"products\":[]}','132.184.130.146','2026-06-24 19:29:03'),
(2,1,'login','user',1,NULL,NULL,'132.184.130.146','2026-06-24 19:48:51'),
(3,1,'login','user',1,NULL,NULL,'132.184.130.146','2026-06-24 19:53:00'),
(4,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-06-24 19:53:11'),
(5,NULL,'login','user',4,NULL,NULL,'132.184.130.146','2026-06-24 19:53:29'),
(6,1,'login','user',1,NULL,NULL,'132.184.130.146','2026-06-24 20:02:49'),
(7,1,'update','lead',23,'{\"id\":\"23\",\"event_id\":\"7\",\"first_name\":\"Bryan\",\"last_name\":\"De la cruz\",\"email\":\"bdelacruz654@gmail.com\",\"phone\":\"+51947394676\",\"company\":\"Agromex\",\"position\":\"Gerente\",\"city\":\"chincha\",\"region\":\"Ica\",\"client_type\":[\"Distribuidor\"],\"industry\":[\"Nutrici\\u00f3n Animal\"],\"classification\":\"caliente\",\"observations\":\"ssssssssss\",\"source\":\"manual\",\"status\":\"contactado\",\"loss_reason_id\":null,\"is_duplicate\":\"1\",\"duplicate_of\":null,\"created_by\":\"4\",\"updated_by\":\"1\",\"created_at\":\"2026-06-22 23:43:40\",\"updated_at\":\"2026-06-24 12:53:06\",\"created_by_name\":\"Carlos Vendedor\",\"technical_profile\":{\"id\":\"2\",\"lead_id\":\"23\",\"animal_type\":\"Prueba\",\"herd_size\":\"100\",\"current_supplier\":\"Prueba\",\"interest_area\":\"Prueba\",\"additional_data\":null,\"created_at\":\"2026-06-22 23:43:40\",\"updated_at\":\"2026-06-23 00:44:20\"}}','{\"id\":\"23\",\"event_id\":\"7\",\"first_name\":\"Bryan\",\"last_name\":\"De la cruz\",\"email\":\"bdelacruz654@gmail.com\",\"phone\":\"+51947394676\",\"company\":\"Agromex\",\"position\":\"Gerente\",\"city\":\"chincha\",\"region\":\"Ica\",\"client_type\":[\"Distribuidor\"],\"industry\":[\"Nutrici\\u00f3n Animal\"],\"classification\":\"caliente\",\"observations\":\"12\\/05 \",\"source\":\"manual\",\"status\":\"contactado\",\"loss_reason_id\":null,\"is_duplicate\":\"1\",\"duplicate_of\":null,\"created_by\":\"4\",\"updated_by\":\"1\",\"created_at\":\"2026-06-22 23:43:40\",\"updated_at\":\"2026-06-24 16:07:30\",\"created_by_name\":\"Carlos Vendedor\",\"technical_profile\":{\"id\":\"2\",\"lead_id\":\"23\",\"animal_type\":\"Prueba\",\"herd_size\":\"100\",\"current_supplier\":\"Prueba\",\"interest_area\":\"Prueba\",\"additional_data\":null,\"created_at\":\"2026-06-22 23:43:40\",\"updated_at\":\"2026-06-23 00:44:20\"},\"status_history\":[{\"id\":\"9\",\"lead_id\":\"23\",\"previous_status\":\"nuevo\",\"new_status\":\"contactado\",\"loss_reason_id\":null,\"notes\":null,\"changed_by\":\"4\",\"created_at\":\"2026-06-23 00:37:21\",\"changed_by_name\":\"Carlos Vendedor\"}],\"timeline\":[{\"type\":\"status_change\",\"date\":\"2026-06-23 00:37:21\",\"data\":{\"from\":\"nuevo\",\"to\":\"contactado\",\"notes\":null,\"changed_by\":\"Carlos Vendedor\"}}],\"products\":[]}','179.6.14.40','2026-06-24 20:07:30'),
(8,NULL,'create','lead',29,NULL,NULL,'132.184.130.146','2026-06-24 20:27:39'),
(9,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-06-24 20:37:17'),
(10,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-06-24 20:38:03'),
(11,NULL,'login','user',4,NULL,NULL,'132.184.130.146','2026-06-24 20:41:51'),
(12,NULL,'login','user',4,NULL,NULL,'179.6.14.40','2026-06-24 20:53:13'),
(13,NULL,'login','user',4,NULL,NULL,'179.6.14.40','2026-06-24 20:55:00'),
(14,NULL,'login','user',4,NULL,NULL,'179.6.14.40','2026-06-24 21:33:07'),
(15,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-06-24 21:41:16'),
(16,NULL,'login','user',4,NULL,NULL,'190.236.89.137','2026-06-24 22:00:33'),
(17,NULL,'update','lead',29,NULL,'{\"status\":\"calificado\"}','190.236.89.137','2026-06-24 22:01:15'),
(18,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-06-25 14:53:39'),
(19,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-06-25 15:19:51'),
(20,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-06-25 15:56:59'),
(21,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-06-25 16:58:24'),
(22,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-06-25 17:13:00'),
(23,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-06-25 18:08:59'),
(24,NULL,'login','user',4,NULL,NULL,'190.236.89.176','2026-06-25 19:31:47'),
(25,NULL,'login','user',4,NULL,NULL,'179.6.14.40','2026-06-25 21:24:39'),
(26,NULL,'login','user',4,NULL,NULL,'132.184.130.146','2026-06-25 22:13:02'),
(27,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-06-26 14:42:36'),
(28,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-07-01 20:27:45'),
(29,NULL,'login','user',4,NULL,NULL,'38.43.143.171','2026-07-01 20:28:42'),
(30,NULL,'login','user',4,NULL,NULL,'38.43.143.171','2026-07-01 20:29:43'),
(31,NULL,'create','lead',30,NULL,NULL,'38.43.143.171','2026-07-01 20:47:30'),
(32,1,'login','user',1,NULL,NULL,'38.43.143.171','2026-07-01 21:11:05'),
(33,NULL,'login','user',4,NULL,NULL,'179.6.14.40','2026-07-01 21:45:34'),
(34,NULL,'update','lead',29,NULL,'{\"status\":\"contactado\"}','179.6.14.40','2026-07-01 21:47:10'),
(35,NULL,'update','lead',29,NULL,'{\"status\":\"propuesta\"}','179.6.14.40','2026-07-01 21:47:11'),
(36,NULL,'login','user',4,NULL,NULL,'179.6.14.40','2026-07-01 23:45:22'),
(37,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-07-03 17:47:22'),
(38,NULL,'login','user',4,NULL,NULL,'38.43.143.171','2026-07-03 19:11:47'),
(39,NULL,'login','user',3,NULL,NULL,'38.43.143.171','2026-07-04 02:47:05'),
(40,NULL,'login','user',3,NULL,NULL,'181.67.176.175','2026-07-07 13:59:15'),
(41,1,'login','user',1,NULL,NULL,'181.67.176.175','2026-07-08 15:05:39'),
(42,NULL,'login','user',4,NULL,NULL,'179.6.14.40','2026-07-08 15:32:27'),
(43,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-07-08 15:42:52'),
(44,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-07-08 16:24:40'),
(45,1,'login','user',1,NULL,NULL,'181.67.176.175','2026-07-08 16:41:05'),
(46,NULL,'login','user',4,NULL,NULL,'181.67.176.175','2026-07-08 17:11:47'),
(47,NULL,'update','lead',30,'{\"id\":\"30\",\"event_id\":\"7\",\"first_name\":\"Bryan Angel\",\"last_name\":\"De La Cruz Soto\",\"email\":\"bdelacruz654@gmail.com\",\"phone\":\"+51912538004\",\"company\":\"ITALVET S.A.C.\",\"position\":\"Prueba\",\"city\":\"Prueba\",\"region\":\"Prueba\",\"ruc\":\"20513909382\",\"business_name\":\"ITALVET S.A.C.\",\"address\":\"MZ. H LT. 17 PRO VIV AYACUCHO\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":[\"Nutrici\\u00f3n Animal\"],\"classification\":\"caliente\",\"observations\":\"Prueba\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"1\",\"duplicate_of\":\"23\",\"created_by\":\"4\",\"updated_by\":null,\"created_at\":\"2026-07-01 16:47:30\",\"updated_at\":\"2026-07-01 16:47:30\",\"created_by_name\":\"Carlos Vendedor\",\"technical_profile\":{\"id\":\"5\",\"lead_id\":\"30\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-01 16:47:30\",\"updated_at\":\"2026-07-01 16:47:30\"},\"representatives\":[]}','{\"id\":\"30\",\"event_id\":\"7\",\"first_name\":\"Bryan Angel\",\"last_name\":\"De La Cruz Soto\",\"email\":\"bdelacruz654@gmail.com\",\"phone\":\"+51912538004\",\"company\":\"ITALVET S.A.C.\",\"position\":\"Prueba\",\"city\":\"Prueba\",\"region\":\"Prueba\",\"ruc\":\"20513909382\",\"business_name\":\"ITALVET S.A.C.\",\"address\":\"MZ. H LT. 17 PRO VIV AYACUCHO\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":[\"Nutrici\\u00f3n Animal\"],\"classification\":\"caliente\",\"observations\":\"Prueba\",\"lat\":\"-13.4031555\",\"lng\":\"-76.1476170\",\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"1\",\"duplicate_of\":\"23\",\"created_by\":\"4\",\"updated_by\":\"4\",\"created_at\":\"2026-07-01 16:47:30\",\"updated_at\":\"2026-07-08 13:15:24\",\"created_by_name\":\"Carlos Vendedor\",\"technical_profile\":{\"id\":\"5\",\"lead_id\":\"30\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-01 16:47:30\",\"updated_at\":\"2026-07-01 16:47:30\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[{\"id\":\"1\",\"name\":\"v2\",\"description\":\"Upd\",\"category\":\"Nutricion\",\"status\":\"active\",\"created_at\":\"2026-06-16 23:14:40\",\"updated_at\":\"2026-06-16 23:14:48\"}]}','181.67.176.175','2026-07-08 17:15:24'),
(48,1,'login','user',1,NULL,NULL,'38.43.143.171','2026-07-08 19:20:40'),
(49,1,'login','user',1,NULL,NULL,'38.43.143.171','2026-07-08 19:33:50'),
(50,NULL,'login','user',4,NULL,NULL,'38.43.143.171','2026-07-08 20:20:37'),
(51,NULL,'login','user',4,NULL,NULL,'179.6.14.40','2026-07-09 17:46:18'),
(52,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-07-09 18:17:50'),
(53,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-07-09 21:31:09'),
(54,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-07-09 21:57:35'),
(55,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-07-09 22:33:48'),
(56,1,'login','user',1,NULL,NULL,'181.67.176.175','2026-07-10 17:47:01'),
(57,1,'login','user',1,NULL,NULL,'201.240.171.184','2026-07-11 14:50:11'),
(58,NULL,'login','user',10,NULL,NULL,'201.240.171.184','2026-07-11 14:59:40'),
(59,1,'delete','lead',30,NULL,NULL,'201.240.171.184','2026-07-11 15:04:30'),
(60,1,'delete','lead',29,NULL,NULL,'201.240.171.184','2026-07-11 15:04:34'),
(61,1,'delete','lead',28,NULL,NULL,'201.240.171.184','2026-07-11 15:04:38'),
(62,1,'delete','lead',20,NULL,NULL,'201.240.171.184','2026-07-11 15:04:43'),
(63,1,'delete','lead',10,NULL,NULL,'201.240.171.184','2026-07-11 15:04:47'),
(64,1,'delete','lead',12,NULL,NULL,'201.240.171.184','2026-07-11 15:04:49'),
(65,1,'delete','lead',13,NULL,NULL,'201.240.171.184','2026-07-11 15:04:53'),
(66,1,'delete','lead',15,NULL,NULL,'201.240.171.184','2026-07-11 15:04:55'),
(67,1,'delete','lead',14,NULL,NULL,'201.240.171.184','2026-07-11 15:04:59'),
(68,1,'delete','lead',22,NULL,NULL,'201.240.171.184','2026-07-11 15:05:02'),
(69,1,'delete','lead',23,NULL,NULL,'201.240.171.184','2026-07-11 15:05:14'),
(70,1,'delete','lead',19,NULL,NULL,'201.240.171.184','2026-07-11 15:05:17'),
(71,1,'delete','lead',18,NULL,NULL,'201.240.171.184','2026-07-11 15:05:19'),
(72,1,'delete','lead',17,NULL,NULL,'201.240.171.184','2026-07-11 15:05:21'),
(73,1,'delete','lead',16,NULL,NULL,'201.240.171.184','2026-07-11 15:05:24'),
(74,1,'delete','lead',11,NULL,NULL,'201.240.171.184','2026-07-11 15:05:26'),
(75,1,'login','user',1,NULL,NULL,'201.240.171.184','2026-07-11 15:14:59'),
(76,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-07-14 15:03:11'),
(77,1,'create','event',10,NULL,NULL,'179.6.14.40','2026-07-14 15:11:58'),
(78,1,'create','lead',31,NULL,NULL,'179.6.14.40','2026-07-14 15:18:58'),
(79,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-14 15:22:00'),
(80,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-07-14 15:24:06'),
(81,1,'update','lead',31,'{\"id\":\"31\",\"event_id\":null,\"first_name\":\"Liliana \",\"last_name\":\"admin\",\"email\":\"lilianamkt@italvetsac.com\",\"phone\":\"\",\"company\":\"\",\"position\":\"\",\"city\":\"\",\"region\":\"\",\"ruc\":null,\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[],\"industry\":[],\"classification\":\"\",\"observations\":\"lead de prueba\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"1\",\"updated_by\":null,\"created_at\":\"2026-07-14 11:18:58\",\"updated_at\":\"2026-07-14 11:18:58\",\"created_by_name\":\"Super Administrador\",\"technical_profile\":null,\"representatives\":[]}','{\"id\":\"31\",\"event_id\":null,\"first_name\":\"Liliana \",\"last_name\":\"admin\",\"email\":\"lilianamkt@italvetsac.com\",\"phone\":\"\",\"company\":\"\",\"position\":\"\",\"city\":\"\",\"region\":\"\",\"ruc\":null,\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[],\"industry\":[],\"classification\":\"\",\"observations\":\"lead de prueba\\n14\\/07 no funciona notificacion  de tarea a correo\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"1\",\"updated_by\":\"1\",\"created_at\":\"2026-07-14 11:18:58\",\"updated_at\":\"2026-07-14 11:26:43\",\"created_by_name\":\"Super Administrador\",\"technical_profile\":null,\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-07-14 15:26:43'),
(82,1,'update','lead',31,NULL,'{\"status\":\"propuesta\"}','179.6.14.40','2026-07-14 15:27:24'),
(83,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-14 15:28:37'),
(84,11,'create','lead',32,NULL,NULL,'179.6.14.40','2026-07-14 15:41:28'),
(85,11,'update','lead',32,'{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":null,\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"updated_by\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[]}','{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":null,\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":null,\"lat\":\"-12.0833218\",\"lng\":\"-77.0904169\",\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:43:18\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-07-14 15:43:18'),
(86,11,'update','lead',32,'{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":null,\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":null,\"lat\":\"-12.0833218\",\"lng\":\"-77.0904169\",\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:43:18\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[]}','{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":null,\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:43:57\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-07-14 15:43:57'),
(87,11,'update','lead',32,'{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":null,\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:43:57\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[]}','{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:44:33\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-07-14 15:44:33'),
(88,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-14 15:51:15'),
(89,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-14 15:53:37'),
(90,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-14 15:55:31'),
(91,13,'create','lead',33,NULL,NULL,'181.67.122.207','2026-07-14 15:57:20'),
(92,11,'update','lead',32,'{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:44:33\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[]}','{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":\"\",\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":\"\",\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":[],\"classification\":\"tibio\",\"observations\":\"Contacto de Zamora?\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 12:06:22\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-07-14 16:06:22'),
(93,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-14 16:35:47'),
(94,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-14 16:36:58'),
(95,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-07-14 16:41:07'),
(96,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-14 16:45:37'),
(97,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 16:48:43'),
(98,14,'delete','lead',31,NULL,NULL,'179.6.14.40','2026-07-14 16:49:09'),
(99,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-14 16:51:13'),
(100,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-14 16:57:28'),
(101,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 16:57:49'),
(102,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-14 17:07:07'),
(103,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 17:17:31'),
(104,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-14 17:21:26'),
(105,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 17:21:54'),
(106,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 17:25:10'),
(107,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-14 17:43:08'),
(108,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-14 17:53:03'),
(109,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 17:55:27'),
(110,13,'login','user',13,NULL,NULL,'201.240.171.184','2026-07-14 19:33:43'),
(111,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 20:24:06'),
(112,1,'login','user',1,NULL,NULL,'201.240.171.184','2026-07-14 20:33:32'),
(113,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 21:33:34'),
(114,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 21:33:43'),
(115,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-14 21:55:57'),
(116,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 21:58:13'),
(117,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-14 21:59:43'),
(118,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 22:20:23'),
(119,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-14 22:33:30'),
(120,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 22:43:51'),
(121,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-14 23:01:36'),
(122,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-15 00:01:53'),
(123,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-15 14:28:08'),
(124,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-15 14:35:05'),
(125,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-15 14:53:05'),
(126,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-15 15:59:28'),
(127,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-15 16:03:09'),
(128,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-15 16:08:29'),
(129,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-15 16:09:27'),
(130,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-15 16:27:06'),
(131,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-15 16:28:07'),
(132,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-15 16:46:04'),
(133,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-15 17:02:30'),
(134,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-15 17:29:56'),
(135,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-15 21:01:52'),
(136,13,'login','user',13,NULL,NULL,'201.230.249.52','2026-07-15 22:18:27'),
(137,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-15 22:48:15'),
(138,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-16 14:40:28'),
(139,11,'login','user',11,NULL,NULL,'190.235.44.104','2026-07-16 15:17:35'),
(140,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-16 15:30:19'),
(141,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-16 21:42:12'),
(142,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-17 23:12:43'),
(143,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-20 17:25:56'),
(144,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-20 17:28:41'),
(145,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-20 17:39:54'),
(146,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-20 17:44:30'),
(147,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-20 17:46:29'),
(148,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-20 17:48:01'),
(149,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-07-22 17:51:16'),
(150,1,'login','user',1,NULL,NULL,'201.240.171.184','2026-07-22 20:25:56'),
(151,1,'login','user',1,NULL,NULL,'201.240.171.184','2026-07-22 20:28:56'),
(152,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-24 17:35:18'),
(153,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-24 17:44:04'),
(154,11,'update','lead',32,'{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":\"\",\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":\"\",\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":[],\"classification\":\"tibio\",\"observations\":\"Contacto de Zamora?\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 12:06:22\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[]}','{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":\"\",\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":\"\",\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":[],\"classification\":\"tibio\",\"observations\":\"Contacto de Zamora?\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 12:06:22\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[{\"id\":\"6\",\"name\":\"ADDIKAL pmx\",\"description\":\"Se constituye como la mejor alternativa para la obtenci\\u00f3n de energ\\u00eda a trav\\u00e9s de la ruta metab\\u00f3lica conocida como \\ngluconeog\\u00e9nesis, lo cual resulta econ\\u00f3micamente beneficioso para la industria pecuaria.   \",\"category\":\"[\\\"Nutrici\\u00f3n, Sanidad, \\\"]\",\"species\":\"[\\\"Pollo de carne\\\",\\\"Postura\\\",\\\"Reproductoras\\\",\\\"Cerdos\\\",\\\"Pavos\\\",\\\"Patos\\\"]\",\"status\":\"active\",\"created_at\":\"2026-07-14 12:59:31\",\"updated_at\":\"2026-07-15 13:20:32\"},{\"id\":\"4\",\"name\":\"HEPATOX 10\",\"description\":\"Nutraceutico de gran potencia para el manejo de factores t\\u00f3xicos en el organismo animal. \\nFormulaci\\u00f3n dise\\u00f1ada para contrarrestar el da\\u00f1o que ocasionan los desaf\\u00edos t\\u00f3xicos en los animales \",\"category\":\"Nutrici\\u00f3n, Sanidad, (HEPATOPROTECTOR, REGENERADOR DE HIGADO)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 12:43:57\",\"updated_at\":\"2026-07-14 12:43:57\"},{\"id\":\"5\",\"name\":\"HEPATOX pmx\",\"description\":\"Nutrace\\u00fatico de gran potencia para el manejo de factores t\\u00f3xicos en el organismo animal. \\nFormulaci\\u00f3n dise\\u00f1ada para contrarrestar el da\\u00f1o que ocasionan los desaf\\u00edos t\\u00f3xicos en los animales\",\"category\":\"Nutrici\\u00f3n, Sanidad, Hepatoprotector y regenerador del h\\u00edgado (Polvo)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 12:54:58\",\"updated_at\":\"2026-07-14 13:02:15\"},{\"id\":\"23\",\"name\":\"LISINA\",\"description\":\"\",\"category\":\"[\\\"SRS\\\",\\\"ADITIVOS\\\",\\\"ZOOTECNICOS\\\"]\",\"species\":null,\"status\":\"inactive\",\"created_at\":\"2026-07-14 17:59:24\",\"updated_at\":\"2026-07-14 20:04:42\"}]}','179.6.14.40','2026-07-24 17:49:00'),
(155,11,'update','lead',32,NULL,'{\"status\":\"contactado\"}','179.6.14.40','2026-07-24 18:19:15'),
(156,11,'update','lead',32,'{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":\"\",\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":\"\",\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":[],\"classification\":\"tibio\",\"observations\":\"Contacto de Zamora?\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"contactado\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-24 14:19:15\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[]}','{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":\"Contacto de Zamora?\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"contactado\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-24 14:20:31\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[],\"status_history\":[{\"id\":\"14\",\"lead_id\":\"32\",\"previous_status\":\"nuevo\",\"new_status\":\"contactado\",\"loss_reason_id\":null,\"notes\":null,\"changed_by\":\"11\",\"created_at\":\"2026-07-24 14:19:15\",\"changed_by_name\":\"ESTEBAN RIVERA\"}],\"timeline\":[{\"type\":\"status_change\",\"date\":\"2026-07-24 14:19:15\",\"data\":{\"from\":\"nuevo\",\"to\":\"contactado\",\"notes\":null,\"changed_by\":\"ESTEBAN RIVERA\"}}],\"products\":[{\"id\":\"6\",\"name\":\"ADDIKAL pmx\",\"description\":\"Se constituye como la mejor alternativa para la obtenci\\u00f3n de energ\\u00eda a trav\\u00e9s de la ruta metab\\u00f3lica conocida como \\ngluconeog\\u00e9nesis, lo cual resulta econ\\u00f3micamente beneficioso para la industria pecuaria.   \",\"category\":\"[\\\"Nutrici\\u00f3n, Sanidad, \\\"]\",\"species\":\"[\\\"Pollo de carne\\\",\\\"Postura\\\",\\\"Reproductoras\\\",\\\"Cerdos\\\",\\\"Pavos\\\",\\\"Patos\\\"]\",\"status\":\"active\",\"created_at\":\"2026-07-14 12:59:31\",\"updated_at\":\"2026-07-15 13:20:32\"},{\"id\":\"3\",\"name\":\"BIOCID A\",\"description\":\"Antifungico, Antibacteriano, altamente efectivo contra hongos y bacterias enteropat\\u00f3genas, incluida Salmonella.  \\nEs una mezcla de \\u00e1cidos org\\u00e1nicos y sus sales en \\nuna concentraci\\u00f3n, apta para la conservaci\\u00f3n de subproductos animales, vegetales y alimento balanceado. \",\"category\":\"Sanidad (antif\\u00fangico, antibacteriano, va al alimento)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-09 17:33:14\",\"updated_at\":\"2026-07-09 17:33:14\"},{\"id\":\"7\",\"name\":\"CIPROFOX ps\",\"description\":\"Combinaci\\u00f3n de principios activos de acci\\u00f3n bactericida. La fosfomicina inhibe la formaci\\u00f3n de la pared celular bacteriana y la ciprofloxacina sinergia su acci\\u00f3n bactericida. \",\"category\":\"Sanidad\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 13:11:30\",\"updated_at\":\"2026-07-14 13:11:30\"},{\"id\":\"8\",\"name\":\"COCCIPLUS\",\"description\":\"Anticoccidial qu\\u00edmico indicado en el control de protozoarios del g\\u00e9nero Eimeria en aves j\\u00f3venes. Sus componentes (Clopidol y Etopabato) tienen un efecto sin\\u00e9rgico, \\u00fatil en programas de limpieza ya que reduce r\\u00e1pida y sustancialmente la cantidad de ooquistes en el ambiente. \",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":\"[\\\"Pollo de carne\\\",\\\"Postura\\\",\\\"Reproductoras\\\"]\",\"status\":\"active\",\"created_at\":\"2026-07-14 13:15:18\",\"updated_at\":\"2026-07-15 13:20:55\"},{\"id\":\"10\",\"name\":\"DECABION ST\",\"description\":\"Indicado para controlar infecciones provocadas por g\\u00e9rmenes sensibles a la combinaci\\u00f3n Sulfa +Trimetoprim; \\nbacterias Gram + y Gram - \",\"category\":\"Sanidad\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 13:44:27\",\"updated_at\":\"2026-07-14 13:44:27\"},{\"id\":\"4\",\"name\":\"HEPATOX 10\",\"description\":\"Nutraceutico de gran potencia para el manejo de factores t\\u00f3xicos en el organismo animal. \\nFormulaci\\u00f3n dise\\u00f1ada para contrarrestar el da\\u00f1o que ocasionan los desaf\\u00edos t\\u00f3xicos en los animales \",\"category\":\"Nutrici\\u00f3n, Sanidad, (HEPATOPROTECTOR, REGENERADOR DE HIGADO)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 12:43:57\",\"updated_at\":\"2026-07-14 12:43:57\"},{\"id\":\"5\",\"name\":\"HEPATOX pmx\",\"description\":\"Nutrace\\u00fatico de gran potencia para el manejo de factores t\\u00f3xicos en el organismo animal. \\nFormulaci\\u00f3n dise\\u00f1ada para contrarrestar el da\\u00f1o que ocasionan los desaf\\u00edos t\\u00f3xicos en los animales\",\"category\":\"Nutrici\\u00f3n, Sanidad, Hepatoprotector y regenerador del h\\u00edgado (Polvo)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 12:54:58\",\"updated_at\":\"2026-07-14 13:02:15\"},{\"id\":\"17\",\"name\":\"LEVONEOSIN\\u00ae \",\"description\":\"Soluci\\u00f3n Oral. Est\\u00e1 indicado para el tratamiento y \\ncontrol de problemas infecciosos causados por \\ng\\u00e9rmenes sensibles a la  Levofloxacina, bacterias \\nGram positivas y Gram negativas, as\\u00ed como \\nMicoplasmas.\",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 17:06:12\",\"updated_at\":\"2026-07-14 17:06:12\"},{\"id\":\"18\",\"name\":\"LEVOSEPT PS ps\",\"description\":\"est\\u00e1 indicado para controlar \\nproblemas infecciosos causados por g\\u00e9rmenes \\nsensibles a la  Levofloxacina y Neomicina, bacterias \\nGram positivas y Gram negativas, as\\u00ed como \\nMicoplasmas.\",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 17:09:14\",\"updated_at\":\"2026-07-14 17:09:14\"},{\"id\":\"23\",\"name\":\"LISINA\",\"description\":\"\",\"category\":\"[\\\"SRS\\\",\\\"ADITIVOS\\\",\\\"ZOOTECNICOS\\\"]\",\"species\":null,\"status\":\"inactive\",\"created_at\":\"2026-07-14 17:59:24\",\"updated_at\":\"2026-07-14 20:04:42\"},{\"id\":\"19\",\"name\":\"MEGADOX ps\",\"description\":\"MEGADOX polvo soluble, contiene una \\nasociaci\\u00f3n sin\\u00e9rgica de dos potentes agentes \\nantibacterianos y un eficiente fluidificador de \\nmucus que permiten un tratamiento eficaz \\ncontra mycoplasma.\",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 17:15:17\",\"updated_at\":\"2026-07-14 17:15:17\"},{\"id\":\"21\",\"name\":\"PLEUROFOS ORAL T ps\",\"description\":\"PLEUROFOS ORAL \\u2013 T.- est\\u00e1 indicado para el \\ntratamiento de infecciones sist\\u00e9micas en los siguientes \\ncasos: \\nEn Aves: Colibacilosis, enteritis, salpingitis, septicemia, \\nsalmonelosis, s\\u00edndrome de cabeza hinchada, coriza \\ninfecciosa, c\\u00f3lera aviar e infecciones por Staphylococcus \\nsp. y en casos de enfermedad respiratoria cr\\u00f3nica \\ncausada por micoplasma. \\nEn cerdos: Micoplasmosis, salmonelosis, colibacilosis, \\ncolienterotoxemia, \\ndiarreas \\nbacterianas, \\nbronconeumon\\u00eda, neumon\\u00eda ezootica, erisipela, cistitis, \\npielonefritis, rinitis atr\\u00f3fica y complejo MMA. \",\"category\":\"[\\\"SANIDAD\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 17:34:46\",\"updated_at\":\"2026-07-14 17:34:46\"},{\"id\":\"24\",\"name\":\"RESPIFREE AE\",\"description\":\"Soporte respiratorio para \\nsituaciones de estr\\u00e9s o riesgo de enfermedades \\nrespiratorias en los animales. Gracias a sus \\naceites esenciales que poseen acci\\u00f3n \\nexpectorante y descongestionante de las v\\u00edas \\na\\u00e9reas, efecto refrescante o de enfriamiento que \\nayuda a aliviar el estr\\u00e9s por calor (heat stress, y \\nun efecto calmante del tracto respiratorio que \\nmitiga las reacciones post-vacunales.\",\"category\":\"[\\\"SOPORTE RESPIRATORIO\\\",\\\"Aditivo Zoot\\u00e9cnico\\\",\\\"Estres por calor\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 18:48:27\",\"updated_at\":\"2026-07-14 18:48:27\"},{\"id\":\"26\",\"name\":\"SPEKTOR\",\"description\":\"SPEKTOR. Coadyuvante en todas las \\nenfermedades respiratorias, severas, agudas o \\ncr\\u00f3nicas, que cursen con secreci\\u00f3n de moco y \\ncon aumento de su viscosidad. \",\"category\":\"[\\\"Sanidad\\\",\\\"Espectorante\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 19:35:37\",\"updated_at\":\"2026-07-14 19:36:02\"},{\"id\":\"28\",\"name\":\"TILVASAN ps\",\"description\":\"TILVASAN con su potente efecto, logra su acci\\u00f3n bactericida \\nen una m\\u00ednima concentraci\\u00f3n y en un periodo menor de tiempo. \\nPosee un potente efecto micoplasmicida, el cual es 10 veces mayor al de la Tilosina. \",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 19:51:14\",\"updated_at\":\"2026-07-14 19:51:14\"},{\"id\":\"29\",\"name\":\"TYLVASAN 5% pmx\",\"description\":\"TILVASAN 5% pmx con su potente efecto, \\nlogra su acci\\u00f3n bactericida en una m\\u00ednima \\nconcentraci\\u00f3n y en un periodo menor de tiempo. \\nPosee un potente efecto antibacteriano, el cual \\nes 10 veces mayor al de la Tilosina. \",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 19:54:28\",\"updated_at\":\"2026-07-14 19:54:28\"}]}','179.6.14.40','2026-07-24 18:20:31'),
(157,11,'create','lead',35,NULL,NULL,'179.6.14.40','2026-07-24 23:13:56'),
(158,11,'update','lead',35,'{\"id\":\"35\",\"event_id\":null,\"first_name\":\"RUTH BERTHA\",\"last_name\":\" FUENTES VILLAR\",\"email\":null,\"phone\":\"961908466\",\"company\":\"INVERSIONES COCOROCO S.A.\",\"position\":\"DUE\\u00d1A\",\"city\":\"PUCALLPA\",\"region\":null,\"ruc\":\"20393719100\",\"business_name\":\"INVERSIONES COCOROCO S.A.\",\"address\":\"CAR. FEDERICO BASADRE  KM. 10\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Productor\"],\"industry\":[\"Postura\",\"Pollo de carne\",\"Cerdos\"],\"classification\":\"caliente\",\"observations\":\"Asesor: Dr Lucio Icumina 961599422\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":null,\"created_at\":\"2026-07-24 19:13:56\",\"updated_at\":\"2026-07-24 19:13:56\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"8\",\"lead_id\":\"35\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-24 19:13:56\",\"updated_at\":\"2026-07-24 19:13:56\"},\"representatives\":[]}','{\"id\":\"35\",\"event_id\":null,\"first_name\":\"RUTH BERTHA\",\"last_name\":\" FUENTES VILLAR\",\"email\":\"\",\"phone\":\"961908466\",\"company\":\"INVERSIONES COCOROCO S.A.\",\"position\":\"DUE\\u00d1A\",\"city\":\"PUCALLPA\",\"region\":\"\",\"ruc\":\"20393719100\",\"business_name\":\"INVERSIONES COCOROCO S.A.\",\"address\":\"CAR. FEDERICO BASADRE  KM. 10\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Productor\"],\"industry\":[\"Postura\",\"Pollo de carne\",\"Cerdos\"],\"classification\":\"caliente\",\"observations\":\"Asesor: Dr Lucio Icumina 961599422\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-24 19:13:56\",\"updated_at\":\"2026-07-24 19:14:31\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"8\",\"lead_id\":\"35\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-24 19:13:56\",\"updated_at\":\"2026-07-24 19:13:56\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-07-24 23:14:31'),
(159,11,'update','lead',35,NULL,'{\"status\":\"contactado\"}','179.6.14.40','2026-07-24 23:16:17'),
(160,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-25 01:00:23'),
(161,11,'login','user',11,NULL,NULL,'181.65.1.59','2026-07-26 05:12:32'),
(162,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-27 14:33:37'),
(163,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-07-27 23:19:59'),
(164,1,'login','user',1,NULL,NULL,'201.240.171.12','2026-07-30 14:12:44'),
(165,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-30 14:19:14'),
(166,13,'login','user',13,NULL,NULL,'201.240.171.12','2026-07-30 14:46:19'),
(167,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-30 22:20:15'),
(168,13,'login','user',13,NULL,NULL,'132.157.130.190','2026-07-30 22:24:44'),
(169,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-30 22:25:45'),
(170,1,'login','user',1,NULL,NULL,'132.157.130.190','2026-07-30 22:46:10'),
(171,13,'login','user',13,NULL,NULL,'132.157.130.190','2026-07-30 22:47:30'),
(172,1,'login','user',1,NULL,NULL,'132.157.130.190','2026-07-30 22:57:49'),
(173,13,'login','user',13,NULL,NULL,'132.157.130.190','2026-07-30 22:58:05'),
(174,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-31 16:15:50'),
(175,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-31 16:47:22'),
(176,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-31 17:22:42'),
(177,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-31 17:48:25'),
(178,14,'delete','lead',34,NULL,NULL,'179.6.14.40','2026-07-31 17:49:03'),
(179,14,'delete','lead',33,NULL,NULL,'179.6.14.40','2026-07-31 17:49:08'),
(180,14,'delete','lead',36,NULL,NULL,'179.6.14.40','2026-07-31 18:07:16'),
(181,14,'delete','lead',37,NULL,NULL,'179.6.14.40','2026-07-31 18:23:50'),
(182,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-31 18:24:18'),
(183,11,'update','lead',35,'{\"id\":\"35\",\"event_id\":null,\"first_name\":\"RUTH BERTHA\",\"last_name\":\" FUENTES VILLAR\",\"email\":\"\",\"phone\":\"961908466\",\"company\":\"INVERSIONES COCOROCO S.A.\",\"position\":\"DUE\\u00d1A\",\"city\":\"PUCALLPA\",\"region\":\"\",\"ruc\":\"20393719100\",\"business_name\":\"INVERSIONES COCOROCO S.A.\",\"address\":\"CAR. FEDERICO BASADRE  KM. 10\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Productor\"],\"industry\":[\"Postura\",\"Pollo de carne\",\"Cerdos\"],\"classification\":\"caliente\",\"observations\":\"Asesor: Dr Lucio Icumina 961599422\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"contactado\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-24 19:13:56\",\"updated_at\":\"2026-07-24 19:16:17\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"8\",\"lead_id\":\"35\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-24 19:13:56\",\"updated_at\":\"2026-07-24 19:13:56\"},\"representatives\":[]}','{\"id\":\"35\",\"event_id\":null,\"first_name\":\"RUTH BERTHA\",\"last_name\":\" FUENTES VILLAR\",\"email\":null,\"phone\":\"961908466\",\"company\":\"INVERSIONES COCOROCO S.A.\",\"position\":\"DUE\\u00d1A\",\"city\":\"PUCALLPA\",\"region\":null,\"ruc\":\"20393719100\",\"business_name\":\"INVERSIONES COCOROCO S.A.\",\"address\":\"CAR. FEDERICO BASADRE  KM. 10\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Productor\"],\"industry\":[\"Postura\",\"Pollo de carne\",\"Cerdos\"],\"classification\":\"caliente\",\"observations\":\"Asesor: Dr Lucio Icumina 961599422\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"contactado\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-24 19:13:56\",\"updated_at\":\"2026-07-31 14:42:02\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"8\",\"lead_id\":\"35\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-24 19:13:56\",\"updated_at\":\"2026-07-24 19:13:56\"},\"representatives\":[],\"status_history\":[{\"id\":\"15\",\"lead_id\":\"35\",\"previous_status\":\"nuevo\",\"new_status\":\"contactado\",\"loss_reason_id\":null,\"notes\":null,\"changed_by\":\"11\",\"created_at\":\"2026-07-24 19:16:17\",\"changed_by_name\":\"ESTEBAN RIVERA\"}],\"timeline\":[{\"type\":\"status_change\",\"date\":\"2026-07-24 19:16:17\",\"data\":{\"from\":\"nuevo\",\"to\":\"contactado\",\"notes\":null,\"changed_by\":\"ESTEBAN RIVERA\"}}],\"products\":[{\"id\":\"6\",\"name\":\"ADDIKAL pmx\",\"description\":\"Se constituye como la mejor alternativa para la obtenci\\u00f3n de energ\\u00eda a trav\\u00e9s de la ruta metab\\u00f3lica conocida como \\ngluconeog\\u00e9nesis, lo cual resulta econ\\u00f3micamente beneficioso para la industria pecuaria.   \",\"category\":\"[\\\"Nutrici\\u00f3n, Sanidad, \\\"]\",\"species\":\"[\\\"Pollo de carne\\\",\\\"Postura\\\",\\\"Reproductoras\\\",\\\"Cerdos\\\",\\\"Pavos\\\",\\\"Patos\\\"]\",\"status\":\"active\",\"created_at\":\"2026-07-14 12:59:31\",\"updated_at\":\"2026-07-15 13:20:32\"},{\"id\":\"3\",\"name\":\"BIOCID A\",\"description\":\"Antifungico, Antibacteriano, altamente efectivo contra hongos y bacterias enteropat\\u00f3genas, incluida Salmonella.  \\nEs una mezcla de \\u00e1cidos org\\u00e1nicos y sus sales en \\nuna concentraci\\u00f3n, apta para la conservaci\\u00f3n de subproductos animales, vegetales y alimento balanceado. \",\"category\":\"Sanidad (antif\\u00fangico, antibacteriano, va al alimento)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-09 17:33:14\",\"updated_at\":\"2026-07-09 17:33:14\"},{\"id\":\"5\",\"name\":\"HEPATOX pmx\",\"description\":\"Nutrace\\u00fatico de gran potencia para el manejo de factores t\\u00f3xicos en el organismo animal. \\nFormulaci\\u00f3n dise\\u00f1ada para contrarrestar el da\\u00f1o que ocasionan los desaf\\u00edos t\\u00f3xicos en los animales\",\"category\":\"Nutrici\\u00f3n, Sanidad, Hepatoprotector y regenerador del h\\u00edgado (Polvo)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 12:54:58\",\"updated_at\":\"2026-07-14 13:02:15\"},{\"id\":\"24\",\"name\":\"RESPIFREE AE\",\"description\":\"Soporte respiratorio para \\nsituaciones de estr\\u00e9s o riesgo de enfermedades \\nrespiratorias en los animales. Gracias a sus \\naceites esenciales que poseen acci\\u00f3n \\nexpectorante y descongestionante de las v\\u00edas \\na\\u00e9reas, efecto refrescante o de enfriamiento que \\nayuda a aliviar el estr\\u00e9s por calor (heat stress, y \\nun efecto calmante del tracto respiratorio que \\nmitiga las reacciones post-vacunales.\",\"category\":\"[\\\"SOPORTE RESPIRATORIO\\\",\\\"Aditivo Zoot\\u00e9cnico\\\",\\\"Estres por calor\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 18:48:27\",\"updated_at\":\"2026-07-14 18:48:27\"},{\"id\":\"28\",\"name\":\"TILVASAN ps\",\"description\":\"TILVASAN con su potente efecto, logra su acci\\u00f3n bactericida \\nen una m\\u00ednima concentraci\\u00f3n y en un periodo menor de tiempo. \\nPosee un potente efecto micoplasmicida, el cual es 10 veces mayor al de la Tilosina. \",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 19:51:14\",\"updated_at\":\"2026-07-14 19:51:14\"}]}','179.6.14.40','2026-07-31 18:42:02'),
(184,1,'login','user',1,NULL,NULL,'201.240.171.12','2026-07-31 20:52:39'),
(185,1,'login','user',1,NULL,NULL,'201.240.171.12','2026-07-31 21:05:14'),
(186,13,'login','user',13,NULL,NULL,'201.240.171.12','2026-07-31 21:23:55'),
(187,13,'create','lead',38,NULL,NULL,'201.240.171.12','2026-07-31 21:24:26'),
(188,13,'update','lead',38,NULL,'{\"status\":\"contactado\"}','201.240.171.12','2026-07-31 21:24:37'),
(189,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-31 21:43:02'),
(190,11,'update','lead',35,NULL,'{\"status\":\"negociacion\"}','179.6.14.40','2026-07-31 22:12:55'),
(191,13,'login','user',13,NULL,NULL,'190.236.89.176','2026-07-31 23:11:16'),
(192,13,'login','user',13,NULL,NULL,'190.236.89.176','2026-07-31 23:15:43'),
(193,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-31 23:17:04'),
(194,11,'create','lead',39,NULL,NULL,'179.6.14.40','2026-07-31 23:24:46'),
(195,1,'login','user',1,NULL,NULL,'190.236.89.176','2026-07-31 23:26:30'),
(196,13,'login','user',13,NULL,NULL,'190.236.89.176','2026-07-31 23:28:43'),
(197,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-31 23:44:21'),
(198,1,'login','user',1,NULL,NULL,'190.236.89.176','2026-07-31 23:57:57'),
(199,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-07-31 23:58:10'),
(200,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-07-31 23:59:08'),
(201,1,'delete','lead',38,NULL,NULL,'190.236.89.176','2026-07-31 23:59:43'),
(202,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-01 00:22:20'),
(203,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-01 14:58:38'),
(204,11,'create','lead',60,NULL,NULL,'179.6.14.40','2026-08-01 14:59:29'),
(205,11,'delete','lead',60,NULL,NULL,'179.6.14.40','2026-08-01 15:06:55'),
(206,11,'create','lead',61,NULL,NULL,'179.6.14.40','2026-08-01 15:09:10'),
(207,11,'update','lead',61,'{\"id\":\"61\",\"event_id\":null,\"first_name\":\"Jorge\",\"last_name\":\"Zamora\",\"email\":null,\"phone\":null,\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":null,\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":null,\"industry\":null,\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"32\",\"lead_id\":\"61\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\"},\"representatives\":[]}','{\"id\":\"61\",\"event_id\":null,\"first_name\":\"Jorge\",\"last_name\":\"Zamora\",\"email\":null,\"phone\":null,\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":\"20614301369\",\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":null,\"industry\":null,\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:12:03\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"32\",\"lead_id\":\"61\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-08-01 15:12:03'),
(208,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-08-01 15:20:21'),
(209,13,'create','lead',62,NULL,NULL,'181.67.122.207','2026-08-01 15:20:51'),
(210,13,'delete','lead',62,NULL,NULL,'181.67.122.207','2026-08-01 15:21:12'),
(211,13,'create','lead',66,NULL,NULL,'181.67.122.207','2026-08-01 15:27:15'),
(212,13,'delete','lead',66,NULL,NULL,'181.67.122.207','2026-08-01 15:27:23'),
(213,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-08-01 15:29:21'),
(214,13,'login','user',13,NULL,NULL,'181.67.122.207','2026-08-01 15:33:29'),
(215,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-01 15:33:48'),
(216,13,'create','lead',67,NULL,NULL,'181.67.122.207','2026-08-01 15:33:48'),
(217,11,'update','lead',61,'{\"id\":\"61\",\"event_id\":null,\"first_name\":\"Jorge\",\"last_name\":\"Zamora\",\"email\":null,\"phone\":null,\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":\"20614301369\",\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":null,\"industry\":null,\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:12:03\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"32\",\"lead_id\":\"61\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\"},\"representatives\":[]}','{\"id\":\"61\",\"event_id\":null,\"first_name\":\"Jorge\",\"last_name\":\"Zamora\",\"email\":null,\"phone\":\"987 500 848\",\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":\"20614301369\",\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Asesor veterinario\",\"Distribuidor\"],\"industry\":null,\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:35:31\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"32\",\"lead_id\":\"61\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-08-01 15:35:31'),
(218,1,'login','user',1,NULL,NULL,'179.6.14.40','2026-08-01 15:49:23'),
(219,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-01 15:58:39'),
(220,11,'update','lead',39,'{\"id\":\"39\",\"event_id\":null,\"first_name\":\"MANOLO \",\"last_name\":\"VASQUEZ OLIVARES\",\"email\":null,\"phone\":null,\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":null,\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":[\"Ganado vacuno\"],\"classification\":\"tibio\",\"observations\":\"Dr. Manolo (Gerente de l\\u00ednea vet para cerdos y ganaderia para todo el pero de MSD) que trabaja en MSD interesado en productos para ganader\\u00eda - Addikal\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":null,\"created_at\":\"2026-07-31 19:24:46\",\"updated_at\":\"2026-07-31 19:24:46\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"10\",\"lead_id\":\"39\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-31 19:24:46\",\"updated_at\":\"2026-07-31 19:24:46\"},\"representatives\":[]}','{\"id\":\"39\",\"event_id\":null,\"first_name\":\"MANOLO \",\"last_name\":\"VASQUEZ OLIVARES\",\"email\":null,\"phone\":\"913318028\",\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":null,\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":[\"Ganado vacuno\"],\"classification\":\"tibio\",\"observations\":\"Dr. Manolo (Gerente de l\\u00ednea vet para cerdos y ganaderia para todo el pero de MSD) que trabaja en MSD interesado en productos para ganader\\u00eda - Addikal\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-31 19:24:46\",\"updated_at\":\"2026-08-01 12:07:16\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"10\",\"lead_id\":\"39\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-31 19:24:46\",\"updated_at\":\"2026-07-31 19:24:46\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-08-01 16:07:16'),
(221,11,'update','lead',39,NULL,'{\"status\":\"contactado\"}','179.6.14.40','2026-08-01 16:07:33'),
(222,11,'update','lead',61,'{\"id\":\"61\",\"event_id\":null,\"first_name\":\"Jorge\",\"last_name\":\"Zamora\",\"email\":null,\"phone\":\"987 500 848\",\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":\"20614301369\",\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Asesor veterinario\",\"Distribuidor\"],\"industry\":null,\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:35:31\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"32\",\"lead_id\":\"61\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\"},\"representatives\":[]}','{\"id\":\"61\",\"event_id\":null,\"first_name\":\"Jorge\",\"last_name\":\"Zamora\",\"email\":null,\"phone\":\"987 500 848\",\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":\"20614301369\",\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Asesor veterinario\",\"Distribuidor\"],\"industry\":null,\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:35:31\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"32\",\"lead_id\":\"61\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-08-01 16:08:10'),
(223,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-01 16:09:33'),
(224,11,'update','lead',61,'{\"id\":\"61\",\"event_id\":null,\"first_name\":\"Jorge\",\"last_name\":\"Zamora\",\"email\":null,\"phone\":\"987 500 848\",\"company\":null,\"position\":null,\"city\":null,\"region\":null,\"ruc\":\"20614301369\",\"business_name\":null,\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Asesor veterinario\",\"Distribuidor\"],\"industry\":null,\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:35:31\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"32\",\"lead_id\":\"61\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\"},\"representatives\":[]}','{\"id\":\"61\",\"event_id\":null,\"first_name\":\"Jorge\",\"last_name\":\"Zamora\",\"email\":null,\"phone\":\"987 500 848\",\"company\":\"VENTREPCO S.A.C.\",\"position\":\"Gerente Comercial\",\"city\":\"Trujillo\",\"region\":null,\"ruc\":\"20614301369\",\"business_name\":\"VENTREPCO S.A.C.\",\"address\":\"AV. JOSE GABRIEL CONDORCANQUI MZ. 11 LT. 24 URB. MANUEL AREVALO II ETAPA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Asesor veterinario\",\"Distribuidor\"],\"industry\":null,\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 12:11:16\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"32\",\"lead_id\":\"61\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-01 11:09:10\",\"updated_at\":\"2026-08-01 11:09:10\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','179.6.14.40','2026-08-01 16:11:16'),
(225,11,'update','lead',32,'{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":null,\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":\"Contacto de Zamora?\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"contactado\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-24 14:20:31\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[]}','{\"id\":\"32\",\"event_id\":\"6\",\"first_name\":\"ABRAHAM ROBERTH\",\"last_name\":\"HINOSTROZA HENRIQUEZ\",\"email\":null,\"phone\":\"+51 994 052 741\",\"company\":\"INVET PERU E.I.R.L.\",\"position\":\"Due\\u00f1o\",\"city\":\"Trujillo\",\"region\":\"Huanchaco \\/ Trujillo\",\"ruc\":\"20601433584\",\"business_name\":\"INVET PERU E.I.R.L.\",\"address\":\"MZ. E LT. 01 SEC. VALDIVIA BAJA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Distribuidor\"],\"industry\":null,\"classification\":\"tibio\",\"observations\":\"Contacto de Zamora\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"contactado\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"11\",\"assigned_to\":null,\"updated_by\":\"11\",\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-08-01 12:16:24\",\"created_by_name\":\"ESTEBAN RIVERA\",\"technical_profile\":{\"id\":\"6\",\"lead_id\":\"32\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-07-14 11:41:28\",\"updated_at\":\"2026-07-14 11:41:28\"},\"representatives\":[],\"status_history\":[{\"id\":\"14\",\"lead_id\":\"32\",\"previous_status\":\"nuevo\",\"new_status\":\"contactado\",\"loss_reason_id\":null,\"notes\":null,\"changed_by\":\"11\",\"created_at\":\"2026-07-24 14:19:15\",\"changed_by_name\":\"ESTEBAN RIVERA\"}],\"timeline\":[{\"type\":\"status_change\",\"date\":\"2026-07-24 14:19:15\",\"data\":{\"from\":\"nuevo\",\"to\":\"contactado\",\"notes\":null,\"changed_by\":\"ESTEBAN RIVERA\"}}],\"products\":[{\"id\":\"6\",\"name\":\"ADDIKAL pmx\",\"description\":\"Se constituye como la mejor alternativa para la obtenci\\u00f3n de energ\\u00eda a trav\\u00e9s de la ruta metab\\u00f3lica conocida como \\ngluconeog\\u00e9nesis, lo cual resulta econ\\u00f3micamente beneficioso para la industria pecuaria.   \",\"category\":\"[\\\"Nutrici\\u00f3n, Sanidad, \\\"]\",\"species\":\"[\\\"Pollo de carne\\\",\\\"Postura\\\",\\\"Reproductoras\\\",\\\"Cerdos\\\",\\\"Pavos\\\",\\\"Patos\\\"]\",\"status\":\"active\",\"created_at\":\"2026-07-14 12:59:31\",\"updated_at\":\"2026-07-15 13:20:32\"},{\"id\":\"3\",\"name\":\"BIOCID A\",\"description\":\"Antifungico, Antibacteriano, altamente efectivo contra hongos y bacterias enteropat\\u00f3genas, incluida Salmonella.  \\nEs una mezcla de \\u00e1cidos org\\u00e1nicos y sus sales en \\nuna concentraci\\u00f3n, apta para la conservaci\\u00f3n de subproductos animales, vegetales y alimento balanceado. \",\"category\":\"Sanidad (antif\\u00fangico, antibacteriano, va al alimento)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-09 17:33:14\",\"updated_at\":\"2026-07-09 17:33:14\"},{\"id\":\"7\",\"name\":\"CIPROFOX ps\",\"description\":\"Combinaci\\u00f3n de principios activos de acci\\u00f3n bactericida. La fosfomicina inhibe la formaci\\u00f3n de la pared celular bacteriana y la ciprofloxacina sinergia su acci\\u00f3n bactericida. \",\"category\":\"Sanidad\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 13:11:30\",\"updated_at\":\"2026-07-14 13:11:30\"},{\"id\":\"8\",\"name\":\"COCCIPLUS\",\"description\":\"Anticoccidial qu\\u00edmico indicado en el control de protozoarios del g\\u00e9nero Eimeria en aves j\\u00f3venes. Sus componentes (Clopidol y Etopabato) tienen un efecto sin\\u00e9rgico, \\u00fatil en programas de limpieza ya que reduce r\\u00e1pida y sustancialmente la cantidad de ooquistes en el ambiente. \",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":\"[\\\"Pollo de carne\\\",\\\"Postura\\\",\\\"Reproductoras\\\"]\",\"status\":\"active\",\"created_at\":\"2026-07-14 13:15:18\",\"updated_at\":\"2026-07-15 13:20:55\"},{\"id\":\"10\",\"name\":\"DECABION ST\",\"description\":\"Indicado para controlar infecciones provocadas por g\\u00e9rmenes sensibles a la combinaci\\u00f3n Sulfa +Trimetoprim; \\nbacterias Gram + y Gram - \",\"category\":\"Sanidad\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 13:44:27\",\"updated_at\":\"2026-07-14 13:44:27\"},{\"id\":\"4\",\"name\":\"HEPATOX 10\",\"description\":\"Nutraceutico de gran potencia para el manejo de factores t\\u00f3xicos en el organismo animal. \\nFormulaci\\u00f3n dise\\u00f1ada para contrarrestar el da\\u00f1o que ocasionan los desaf\\u00edos t\\u00f3xicos en los animales \",\"category\":\"Nutrici\\u00f3n, Sanidad, (HEPATOPROTECTOR, REGENERADOR DE HIGADO)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 12:43:57\",\"updated_at\":\"2026-07-14 12:43:57\"},{\"id\":\"5\",\"name\":\"HEPATOX pmx\",\"description\":\"Nutrace\\u00fatico de gran potencia para el manejo de factores t\\u00f3xicos en el organismo animal. \\nFormulaci\\u00f3n dise\\u00f1ada para contrarrestar el da\\u00f1o que ocasionan los desaf\\u00edos t\\u00f3xicos en los animales\",\"category\":\"Nutrici\\u00f3n, Sanidad, Hepatoprotector y regenerador del h\\u00edgado (Polvo)\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 12:54:58\",\"updated_at\":\"2026-07-14 13:02:15\"},{\"id\":\"17\",\"name\":\"LEVONEOSIN\\u00ae \",\"description\":\"Soluci\\u00f3n Oral. Est\\u00e1 indicado para el tratamiento y \\ncontrol de problemas infecciosos causados por \\ng\\u00e9rmenes sensibles a la  Levofloxacina, bacterias \\nGram positivas y Gram negativas, as\\u00ed como \\nMicoplasmas.\",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 17:06:12\",\"updated_at\":\"2026-07-14 17:06:12\"},{\"id\":\"18\",\"name\":\"LEVOSEPT PS ps\",\"description\":\"est\\u00e1 indicado para controlar \\nproblemas infecciosos causados por g\\u00e9rmenes \\nsensibles a la  Levofloxacina y Neomicina, bacterias \\nGram positivas y Gram negativas, as\\u00ed como \\nMicoplasmas.\",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 17:09:14\",\"updated_at\":\"2026-07-14 17:09:14\"},{\"id\":\"23\",\"name\":\"LISINA\",\"description\":\"\",\"category\":\"[\\\"SRS\\\",\\\"ADITIVOS\\\",\\\"ZOOTECNICOS\\\"]\",\"species\":null,\"status\":\"inactive\",\"created_at\":\"2026-07-14 17:59:24\",\"updated_at\":\"2026-07-14 20:04:42\"},{\"id\":\"19\",\"name\":\"MEGADOX ps\",\"description\":\"MEGADOX polvo soluble, contiene una \\nasociaci\\u00f3n sin\\u00e9rgica de dos potentes agentes \\nantibacterianos y un eficiente fluidificador de \\nmucus que permiten un tratamiento eficaz \\ncontra mycoplasma.\",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 17:15:17\",\"updated_at\":\"2026-07-14 17:15:17\"},{\"id\":\"21\",\"name\":\"PLEUROFOS ORAL T ps\",\"description\":\"PLEUROFOS ORAL \\u2013 T.- est\\u00e1 indicado para el \\ntratamiento de infecciones sist\\u00e9micas en los siguientes \\ncasos: \\nEn Aves: Colibacilosis, enteritis, salpingitis, septicemia, \\nsalmonelosis, s\\u00edndrome de cabeza hinchada, coriza \\ninfecciosa, c\\u00f3lera aviar e infecciones por Staphylococcus \\nsp. y en casos de enfermedad respiratoria cr\\u00f3nica \\ncausada por micoplasma. \\nEn cerdos: Micoplasmosis, salmonelosis, colibacilosis, \\ncolienterotoxemia, \\ndiarreas \\nbacterianas, \\nbronconeumon\\u00eda, neumon\\u00eda ezootica, erisipela, cistitis, \\npielonefritis, rinitis atr\\u00f3fica y complejo MMA. \",\"category\":\"[\\\"SANIDAD\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 17:34:46\",\"updated_at\":\"2026-07-14 17:34:46\"},{\"id\":\"24\",\"name\":\"RESPIFREE AE\",\"description\":\"Soporte respiratorio para \\nsituaciones de estr\\u00e9s o riesgo de enfermedades \\nrespiratorias en los animales. Gracias a sus \\naceites esenciales que poseen acci\\u00f3n \\nexpectorante y descongestionante de las v\\u00edas \\na\\u00e9reas, efecto refrescante o de enfriamiento que \\nayuda a aliviar el estr\\u00e9s por calor (heat stress, y \\nun efecto calmante del tracto respiratorio que \\nmitiga las reacciones post-vacunales.\",\"category\":\"[\\\"SOPORTE RESPIRATORIO\\\",\\\"Aditivo Zoot\\u00e9cnico\\\",\\\"Estres por calor\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 18:48:27\",\"updated_at\":\"2026-07-14 18:48:27\"},{\"id\":\"26\",\"name\":\"SPEKTOR\",\"description\":\"SPEKTOR. Coadyuvante en todas las \\nenfermedades respiratorias, severas, agudas o \\ncr\\u00f3nicas, que cursen con secreci\\u00f3n de moco y \\ncon aumento de su viscosidad. \",\"category\":\"[\\\"Sanidad\\\",\\\"Espectorante\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 19:35:37\",\"updated_at\":\"2026-07-14 19:36:02\"},{\"id\":\"28\",\"name\":\"TILVASAN ps\",\"description\":\"TILVASAN con su potente efecto, logra su acci\\u00f3n bactericida \\nen una m\\u00ednima concentraci\\u00f3n y en un periodo menor de tiempo. \\nPosee un potente efecto micoplasmicida, el cual es 10 veces mayor al de la Tilosina. \",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 19:51:14\",\"updated_at\":\"2026-07-14 19:51:14\"},{\"id\":\"29\",\"name\":\"TYLVASAN 5% pmx\",\"description\":\"TILVASAN 5% pmx con su potente efecto, \\nlogra su acci\\u00f3n bactericida en una m\\u00ednima \\nconcentraci\\u00f3n y en un periodo menor de tiempo. \\nPosee un potente efecto antibacteriano, el cual \\nes 10 veces mayor al de la Tilosina. \",\"category\":\"[\\\"Sanidad\\\"]\",\"species\":null,\"status\":\"active\",\"created_at\":\"2026-07-14 19:54:28\",\"updated_at\":\"2026-07-14 19:54:28\"}]}','179.6.14.40','2026-08-01 16:16:24'),
(226,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-01 17:57:44'),
(227,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-03 17:04:48'),
(228,1,'login','user',1,NULL,NULL,'181.67.122.207','2026-08-03 21:14:59'),
(229,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-03 21:40:43'),
(230,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-04 14:45:16'),
(231,15,'login','user',15,NULL,NULL,'45.230.198.34','2026-08-04 14:59:26'),
(232,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-04 15:35:18'),
(233,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-04 15:46:06'),
(234,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-04 15:48:24'),
(235,11,'create','lead',69,NULL,NULL,'179.6.14.40','2026-08-04 15:51:44'),
(236,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-04 15:57:18'),
(237,14,'delete','lead',68,NULL,NULL,'179.6.14.40','2026-08-04 15:57:36'),
(238,15,'create','lead',70,NULL,NULL,'45.230.198.34','2026-08-04 17:46:49'),
(239,15,'create','lead',71,NULL,NULL,'45.230.198.34','2026-08-04 19:06:42'),
(240,15,'create','lead',72,NULL,NULL,'45.230.198.34','2026-08-04 19:55:24'),
(241,15,'create','lead',73,NULL,NULL,'45.230.198.34','2026-08-04 20:03:56'),
(242,15,'create','lead',74,NULL,NULL,'45.230.198.34','2026-08-04 20:11:38'),
(243,15,'create','lead',75,NULL,NULL,'45.230.198.34','2026-08-04 20:34:00'),
(244,15,'create','lead',76,NULL,NULL,'45.230.198.34','2026-08-04 21:22:43'),
(245,15,'update','lead',76,'{\"id\":\"76\",\"event_id\":\"10\",\"first_name\":\"SOFIA\",\"last_name\":\"PALOMARES LLANOS\",\"email\":\"hpalomares8825@gmail.com\",\"phone\":\"951448323\",\"company\":\"INVERSIONES Y COMERCIALIZADORA SANTA ROSA S.A.C.\",\"position\":\"SOCIA \",\"city\":\"CHANCAY\",\"region\":\"LIMA\",\"ruc\":\"20608735110\",\"business_name\":\"INVERSIONES Y COMERCIALIZADORA SANTA ROSA S.A.C.\",\"address\":\"PRO. SANTA ROSA MZ. B LT. 2 FND. GALLEGOS\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":null,\"industry\":[\"Cerdos\",\"Postura\",\"Reproductoras\",\"Pollo de carne\"],\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"15\",\"assigned_to\":null,\"updated_by\":null,\"created_at\":\"2026-08-04 17:22:43\",\"updated_at\":\"2026-08-04 17:22:43\",\"created_by_name\":\"SUSAN POZO\",\"technical_profile\":{\"id\":\"46\",\"lead_id\":\"76\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-04 17:22:43\",\"updated_at\":\"2026-08-04 17:22:43\"},\"representatives\":[{\"id\":\"8\",\"lead_id\":\"76\",\"tipo_documento\":\"DNI\",\"numero_documento\":\"45464206\",\"nombre\":\"PALOMARES LLANOS HENRY JULIAN\",\"cargo\":\"GERENTE GENERAL\",\"fecha_desde\":\"2021-10-19\",\"created_at\":\"2026-08-04 17:22:43\"}]}','{\"id\":\"76\",\"event_id\":\"10\",\"first_name\":\"SOFIA\",\"last_name\":\"PALOMARES LLANOS\",\"email\":\"hpalomares8825@gmail.com\",\"phone\":\"951448323\",\"company\":\"INVERSIONES Y COMERCIALIZADORA SANTA ROSA S.A.C.\",\"position\":\"SOCIA \",\"city\":\"CHANCAY\",\"region\":\"LIMA\",\"ruc\":\"20608735110\",\"business_name\":\"INVERSIONES Y COMERCIALIZADORA SANTA ROSA S.A.C.\",\"address\":\"PRO. SANTA ROSA MZ. B LT. 2 FND. GALLEGOS\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[],\"industry\":[\"Cerdos\",\"Postura\",\"Reproductoras\",\"Pollo de carne\"],\"classification\":\"tibio\",\"observations\":\"\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"15\",\"assigned_to\":null,\"updated_by\":\"15\",\"created_at\":\"2026-08-04 17:22:43\",\"updated_at\":\"2026-08-04 17:23:23\",\"created_by_name\":\"SUSAN POZO\",\"technical_profile\":{\"id\":\"46\",\"lead_id\":\"76\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-04 17:22:43\",\"updated_at\":\"2026-08-04 17:22:43\"},\"representatives\":[{\"id\":\"8\",\"lead_id\":\"76\",\"tipo_documento\":\"DNI\",\"numero_documento\":\"45464206\",\"nombre\":\"PALOMARES LLANOS HENRY JULIAN\",\"cargo\":\"GERENTE GENERAL\",\"fecha_desde\":\"2021-10-19\",\"created_at\":\"2026-08-04 17:22:43\"}],\"status_history\":[],\"timeline\":[],\"products\":[]}','45.230.198.34','2026-08-04 21:23:23'),
(246,15,'update','lead',75,'{\"id\":\"75\",\"event_id\":\"10\",\"first_name\":\"JUAN EDUARDO \",\"last_name\":\"AGUILAR GERVACIO\",\"email\":\"eduaguilar.311295@gmail.com\",\"phone\":\"954 383 548\",\"company\":\"AGUILAR GERVACIO JUAN EDUARDO\",\"position\":\"SOCIO \",\"city\":\"CHANCAY\",\"region\":\"LIMA\",\"ruc\":\"10716361085\",\"business_name\":\"AGUILAR GERVACIO JUAN EDUARDO\",\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Molino\"],\"industry\":[\"Cerdos\"],\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"15\",\"assigned_to\":null,\"updated_by\":null,\"created_at\":\"2026-08-04 16:34:00\",\"updated_at\":\"2026-08-04 16:34:00\",\"created_by_name\":\"SUSAN POZO\",\"technical_profile\":{\"id\":\"45\",\"lead_id\":\"75\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-04 16:34:00\",\"updated_at\":\"2026-08-04 16:34:00\"},\"representatives\":[]}','{\"id\":\"75\",\"event_id\":\"10\",\"first_name\":\"JUAN EDUARDO \",\"last_name\":\"AGUILAR GERVACIO\",\"email\":\"eduaguilar.311295@gmail.com\",\"phone\":\"954 383 548\",\"company\":\"AGUILAR GERVACIO JUAN EDUARDO\",\"position\":\"SOCIO \",\"city\":\"CHANCAY\",\"region\":\"LIMA\",\"ruc\":\"10716361085\",\"business_name\":\"AGUILAR GERVACIO JUAN EDUARDO\",\"address\":null,\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Molino\"],\"industry\":[\"Cerdos\"],\"classification\":\"caliente\",\"observations\":\"\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"0\",\"duplicate_of\":null,\"created_by\":\"15\",\"assigned_to\":null,\"updated_by\":\"15\",\"created_at\":\"2026-08-04 16:34:00\",\"updated_at\":\"2026-08-04 17:23:45\",\"created_by_name\":\"SUSAN POZO\",\"technical_profile\":{\"id\":\"45\",\"lead_id\":\"75\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-04 16:34:00\",\"updated_at\":\"2026-08-04 16:34:00\"},\"representatives\":[],\"status_history\":[],\"timeline\":[],\"products\":[]}','45.230.198.34','2026-08-04 21:23:45'),
(247,15,'update','lead',74,'{\"id\":\"74\",\"event_id\":\"10\",\"first_name\":\"ALEJANDRA\",\"last_name\":\"CARDENAS MALASQUEZ\",\"email\":\"infofatimasac@gmail.com\",\"phone\":\"993811624\",\"company\":\"INSUMOS Y FORRAJES VIRGEN DE FATIMA S.A.C.\",\"position\":\"ASISTENTE ADMINISTRATIVO \",\"city\":\"HUARAL\",\"region\":\"LIMA\",\"ruc\":\"20571510724\",\"business_name\":\"INSUMOS Y FORRAJES VIRGEN DE FATIMA S.A.C.\",\"address\":\"OTR. MZ G LOTE 12 URB. LOTIZAC MZ. G LT. 12 LOT. PARCELACI\\u00d3N DEL FUNDO CHA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Productor\"],\"industry\":[\"Pollo de carne\",\"Ganado vacuno\"],\"classification\":null,\"observations\":null,\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"1\",\"duplicate_of\":\"73\",\"created_by\":\"15\",\"assigned_to\":null,\"updated_by\":null,\"created_at\":\"2026-08-04 16:11:38\",\"updated_at\":\"2026-08-04 16:11:38\",\"created_by_name\":\"SUSAN POZO\",\"technical_profile\":{\"id\":\"44\",\"lead_id\":\"74\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-04 16:11:38\",\"updated_at\":\"2026-08-04 16:11:38\"},\"representatives\":[{\"id\":\"7\",\"lead_id\":\"74\",\"tipo_documento\":\"DNI\",\"numero_documento\":\"15972973\",\"nombre\":\"GOMEZ CAMPOS JOSE ALBERTO\",\"cargo\":\"GERENTE GENERAL\",\"fecha_desde\":\"2023-10-27\",\"created_at\":\"2026-08-04 16:11:38\"}]}','{\"id\":\"74\",\"event_id\":\"10\",\"first_name\":\"ALEJANDRA\",\"last_name\":\"CARDENAS MALASQUEZ\",\"email\":\"infofatimasac@gmail.com\",\"phone\":\"993811624\",\"company\":\"INSUMOS Y FORRAJES VIRGEN DE FATIMA S.A.C.\",\"position\":\"ASISTENTE ADMINISTRATIVO \",\"city\":\"HUARAL\",\"region\":\"LIMA\",\"ruc\":\"20571510724\",\"business_name\":\"INSUMOS Y FORRAJES VIRGEN DE FATIMA S.A.C.\",\"address\":\"OTR. MZ G LOTE 12 URB. LOTIZAC MZ. G LT. 12 LOT. PARCELACI\\u00d3N DEL FUNDO CHA\",\"audio_file_path\":null,\"photo_file_path\":null,\"client_type\":[\"Productor\"],\"industry\":[\"Pollo de carne\",\"Ganado vacuno\"],\"classification\":\"caliente\",\"observations\":\"\",\"lat\":null,\"lng\":null,\"source\":\"manual\",\"status\":\"nuevo\",\"loss_reason_id\":null,\"is_duplicate\":\"1\",\"duplicate_of\":\"73\",\"created_by\":\"15\",\"assigned_to\":null,\"updated_by\":\"15\",\"created_at\":\"2026-08-04 16:11:38\",\"updated_at\":\"2026-08-04 17:24:01\",\"created_by_name\":\"SUSAN POZO\",\"technical_profile\":{\"id\":\"44\",\"lead_id\":\"74\",\"animal_type\":null,\"herd_size\":null,\"current_supplier\":null,\"interest_area\":null,\"additional_data\":null,\"created_at\":\"2026-08-04 16:11:38\",\"updated_at\":\"2026-08-04 16:11:38\"},\"representatives\":[{\"id\":\"7\",\"lead_id\":\"74\",\"tipo_documento\":\"DNI\",\"numero_documento\":\"15972973\",\"nombre\":\"GOMEZ CAMPOS JOSE ALBERTO\",\"cargo\":\"GERENTE GENERAL\",\"fecha_desde\":\"2023-10-27\",\"created_at\":\"2026-08-04 16:11:38\"}],\"status_history\":[],\"timeline\":[],\"products\":[]}','45.230.198.34','2026-08-04 21:24:01'),
(248,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-05 21:59:58'),
(249,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-05 22:20:01'),
(250,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-07 20:57:12'),
(251,13,'login','user',13,NULL,NULL,'201.240.171.12','2026-08-08 16:49:34'),
(252,13,'login','user',13,NULL,NULL,'201.240.171.12','2026-08-08 16:50:38'),
(253,14,'login','user',14,NULL,NULL,'181.65.1.59','2026-08-08 20:11:57'),
(254,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-10 21:32:40'),
(255,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-10 21:35:22'),
(256,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-11 14:35:33'),
(257,11,'create','lead',77,NULL,NULL,'179.6.14.40','2026-08-11 14:47:51'),
(258,11,'update','lead',61,NULL,'{\"status\":\"contactado\"}','179.6.14.40','2026-08-11 14:53:17'),
(259,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-11 15:06:31'),
(260,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-11 15:21:21'),
(261,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-12 15:29:05'),
(262,11,'create','lead',78,NULL,NULL,'179.6.14.40','2026-08-12 15:47:14'),
(263,11,'update','lead',78,NULL,'{\"status\":\"contactado\"}','179.6.14.40','2026-08-12 15:50:25'),
(264,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-12 16:37:32'),
(265,11,'login','user',11,NULL,NULL,'179.6.14.40','2026-08-13 14:05:31'),
(266,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-17 18:19:37'),
(267,14,'delete','lead',79,NULL,NULL,'179.6.14.40','2026-08-17 18:22:55'),
(268,14,'login','user',14,NULL,NULL,'179.6.14.40','2026-08-20 15:43:37'),
(269,14,'delete','lead',82,NULL,NULL,'179.6.14.40','2026-08-20 20:45:46'),
(270,14,'delete','lead',81,NULL,NULL,'179.6.14.40','2026-08-20 20:45:51'),
(271,14,'delete','lead',80,NULL,NULL,'179.6.14.40','2026-08-20 20:45:55'),
(272,14,'delete','lead',87,NULL,NULL,'179.6.14.40','2026-08-20 20:46:34'),
(273,14,'delete','lead',86,NULL,NULL,'179.6.14.40','2026-08-20 20:46:38'),
(274,14,'delete','lead',85,NULL,NULL,'179.6.14.40','2026-08-20 20:46:42'),
(275,14,'delete','lead',84,NULL,NULL,'179.6.14.40','2026-08-20 20:46:46'),
(276,14,'delete','lead',83,NULL,NULL,'179.6.14.40','2026-08-20 20:46:50');
/*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backups`
--

DROP TABLE IF EXISTS `backups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `backups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(300) NOT NULL,
  `file_path` varchar(500) NOT NULL,
  `type` enum('completo','parcial') NOT NULL DEFAULT 'completo',
  `size_bytes` bigint(20) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `backups_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backups`
--

LOCK TABLES `backups` WRITE;
/*!40000 ALTER TABLE `backups` DISABLE KEYS */;
INSERT INTO `backups` VALUES
(1,'backup_20260624_092138.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260624_092138.sql','completo',33103,1,'2026-06-24 15:21:40'),
(2,'backup_20260624_093213.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260624_093213.sql','completo',33310,1,'2026-06-24 15:32:14'),
(3,'backup_20260624_104312.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260624_104312.sql','completo',33729,1,'2026-06-24 16:43:14'),
(4,'backup_20260624_104318.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260624_104318.sql','completo',33890,1,'2026-06-24 16:43:18'),
(5,'backup_20260624_123502.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260624_123502.sql','completo',35104,1,'2026-06-24 18:35:03'),
(6,'backup_20260624_123750.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260624_123750.sql','completo',35265,1,'2026-06-24 18:37:50'),
(7,'backup_20260624_132930.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260624_132930.sql','completo',37632,1,'2026-06-24 19:29:31'),
(8,'backup_20260627_174023.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260627_174023.sql','completo',41777,1,'2026-06-27 23:40:23'),
(9,'backup_20260708_091149.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260708_091149.sql','completo',49207,1,'2026-07-08 15:11:49'),
(10,'backup_20260723_053518.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260723_053518.sql','completo',111347,1,'2026-07-23 10:35:18'),
(11,'backup_20260812_013659.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260812_013659.sql','completo',185581,1,'2026-08-12 06:36:59'),
(12,'backup_20260812_225436.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260812_225436.sql','completo',187059,1,'2026-08-13 03:54:36'),
(13,'backup_20260817_034800.sql','/home/italvettools/back.italvettools.com/storage/backups/backup_20260817_034800.sql','completo',188393,1,'2026-08-17 08:48:01');
/*!40000 ALTER TABLE `backups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_category_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES
(1,'Prueba','2026-07-15 14:42:24','2026-07-15 14:42:24'),
(2,'SRS','2026-07-15 16:51:24','2026-07-15 16:51:24'),
(3,'Sanidad','2026-07-15 17:05:50','2026-07-15 17:05:50'),
(4,'Nutrición','2026-07-15 17:06:00','2026-07-15 17:06:00');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `configurations`
--

DROP TABLE IF EXISTS `configurations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `configurations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(100) NOT NULL,
  `value` text DEFAULT NULL,
  `description` varchar(300) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `configurations`
--

LOCK TABLES `configurations` WRITE;
/*!40000 ALTER TABLE `configurations` DISABLE KEYS */;
INSERT INTO `configurations` VALUES
(3,'google_vision_key','qa-123',NULL,1,'2026-06-18 04:01:22'),
(4,'nueva_key','val',NULL,1,'2026-06-18 04:01:26');
/*!40000 ALTER TABLE `configurations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `event_users`
--

DROP TABLE IF EXISTS `event_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `event_users` (
  `event_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`event_id`,`user_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `event_users_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE,
  CONSTRAINT `event_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `event_users`
--

LOCK TABLES `event_users` WRITE;
/*!40000 ALTER TABLE `event_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `event_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` text DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `location` varchar(300) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events`
--

LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
INSERT INTO `events` VALUES
(6,'CIPORC 2026','','2026-07-08','2026-07-10','LIMA / CCLIMA','active','2026-06-18 04:15:25','2026-07-09 18:19:45'),
(10,'APROHPERU 2026','','2026-09-16','2026-09-18','Pisco','active','2026-07-14 15:11:58','2026-07-14 15:11:58');
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lead_products`
--

DROP TABLE IF EXISTS `lead_products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_products` (
  `lead_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`lead_id`,`product_id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `lead_products_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lead_products_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lead_products`
--

LOCK TABLES `lead_products` WRITE;
/*!40000 ALTER TABLE `lead_products` DISABLE KEYS */;
INSERT INTO `lead_products` VALUES
(32,3,'2026-07-24 18:19:41'),
(32,4,'2026-07-14 21:56:45'),
(32,5,'2026-07-14 21:56:46'),
(32,6,'2026-07-14 21:57:09'),
(32,7,'2026-07-24 18:19:43'),
(32,8,'2026-07-24 18:19:45'),
(32,10,'2026-07-24 18:19:46'),
(32,17,'2026-07-24 18:19:48'),
(32,18,'2026-07-24 18:19:50'),
(32,19,'2026-07-24 18:19:51'),
(32,21,'2026-07-24 18:19:54'),
(32,23,'2026-07-14 22:00:06'),
(32,24,'2026-07-24 18:19:56'),
(32,26,'2026-07-24 18:19:58'),
(32,28,'2026-07-24 18:20:01'),
(32,29,'2026-07-24 18:20:02'),
(35,3,'2026-07-24 23:15:26'),
(35,5,'2026-07-24 23:15:29'),
(35,6,'2026-07-24 23:15:34'),
(35,13,'2026-07-31 22:12:16'),
(35,24,'2026-07-24 23:21:55'),
(35,28,'2026-07-24 23:15:43'),
(69,29,'2026-08-04 15:53:45');
/*!40000 ALTER TABLE `lead_products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lead_representatives`
--

DROP TABLE IF EXISTS `lead_representatives`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_representatives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` int(11) NOT NULL,
  `tipo_documento` varchar(20) DEFAULT NULL,
  `numero_documento` varchar(20) DEFAULT NULL,
  `nombre` varchar(250) NOT NULL,
  `cargo` varchar(200) DEFAULT NULL,
  `fecha_desde` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_lead_representatives_lead_id` (`lead_id`),
  CONSTRAINT `lead_representatives_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lead_representatives`
--

LOCK TABLES `lead_representatives` WRITE;
/*!40000 ALTER TABLE `lead_representatives` DISABLE KEYS */;
INSERT INTO `lead_representatives` VALUES
(2,69,'DNI','01068574','BUSTAMANTE LLAMO CANDELARIA','GERENTE GENERAL','2020-12-29','2026-08-04 15:51:44'),
(3,69,'DNI','71697194','UYEJARA BUSTAMANTE ANNIE AIMY','SUB GERENTE','2024-04-03','2026-08-04 15:51:44'),
(4,70,'DNI','15982667','CHACON RUIZ LUIS AUGUSTO','TITULAR-GERENTE','2024-09-17','2026-08-04 17:46:49'),
(5,72,'DNI','15972973','GOMEZ CAMPOS JOSE ALBERTO','GERENTE GENERAL','2003-02-28','2026-08-04 19:55:24'),
(6,73,'DNI','15972973','GOMEZ CAMPOS JOSE ALBERTO','GERENTE GENERAL','2025-08-28','2026-08-04 20:03:56'),
(7,74,'DNI','15972973','GOMEZ CAMPOS JOSE ALBERTO','GERENTE GENERAL','2023-10-27','2026-08-04 20:11:38'),
(8,76,'DNI','45464206','PALOMARES LLANOS HENRY JULIAN','GERENTE GENERAL','2021-10-19','2026-08-04 21:22:43'),
(9,78,'DNI','21884526','GIRIBALDI TOLMOS ATILIO GERMAN','GERENTE GENERAL','2010-06-30','2026-08-12 15:47:14');
/*!40000 ALTER TABLE `lead_representatives` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lead_status_history`
--

DROP TABLE IF EXISTS `lead_status_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_status_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` int(11) NOT NULL,
  `previous_status` varchar(30) DEFAULT NULL,
  `new_status` varchar(30) NOT NULL,
  `loss_reason_id` int(11) DEFAULT NULL,
  `notes` varchar(500) DEFAULT NULL,
  `changed_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `lead_id` (`lead_id`),
  KEY `loss_reason_id` (`loss_reason_id`),
  KEY `changed_by` (`changed_by`),
  CONSTRAINT `lead_status_history_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lead_status_history_ibfk_2` FOREIGN KEY (`loss_reason_id`) REFERENCES `loss_reasons` (`id`) ON DELETE SET NULL,
  CONSTRAINT `lead_status_history_ibfk_3` FOREIGN KEY (`changed_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lead_status_history`
--

LOCK TABLES `lead_status_history` WRITE;
/*!40000 ALTER TABLE `lead_status_history` DISABLE KEYS */;
INSERT INTO `lead_status_history` VALUES
(14,32,'nuevo','contactado',NULL,NULL,11,'2026-07-24 18:19:15'),
(15,35,'nuevo','contactado',NULL,NULL,11,'2026-07-24 23:16:17'),
(17,35,'contactado','negociacion',NULL,NULL,11,'2026-07-31 22:12:55'),
(18,39,'nuevo','contactado',NULL,NULL,11,'2026-08-01 16:07:33'),
(19,61,'nuevo','contactado',NULL,NULL,11,'2026-08-11 14:53:17'),
(20,78,'nuevo','contactado',NULL,NULL,11,'2026-08-12 15:50:25');
/*!40000 ALTER TABLE `lead_status_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lead_technical_problems`
--

DROP TABLE IF EXISTS `lead_technical_problems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_technical_problems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `status` enum('pendiente','resuelto') NOT NULL DEFAULT 'pendiente',
  `resolved_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `idx_lead_tech_problems_lead_id` (`lead_id`),
  CONSTRAINT `lead_technical_problems_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lead_technical_problems_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lead_technical_problems`
--

LOCK TABLES `lead_technical_problems` WRITE;
/*!40000 ALTER TABLE `lead_technical_problems` DISABLE KEYS */;
/*!40000 ALTER TABLE `lead_technical_problems` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lead_technical_profiles`
--

DROP TABLE IF EXISTS `lead_technical_profiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_technical_profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` int(11) NOT NULL,
  `animal_type` varchar(100) DEFAULT NULL,
  `herd_size` varchar(100) DEFAULT NULL,
  `current_supplier` varchar(200) DEFAULT NULL,
  `interest_area` varchar(200) DEFAULT NULL,
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional_data`)),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `lead_id` (`lead_id`),
  CONSTRAINT `lead_technical_profiles_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lead_technical_profiles`
--

LOCK TABLES `lead_technical_profiles` WRITE;
/*!40000 ALTER TABLE `lead_technical_profiles` DISABLE KEYS */;
INSERT INTO `lead_technical_profiles` VALUES
(6,32,NULL,NULL,NULL,NULL,NULL,'2026-07-14 15:41:28','2026-07-14 15:41:28'),
(8,35,NULL,NULL,NULL,NULL,NULL,'2026-07-24 23:13:56','2026-07-24 23:13:56'),
(10,39,NULL,NULL,NULL,NULL,NULL,'2026-07-31 23:24:46','2026-07-31 23:24:46'),
(32,61,NULL,NULL,NULL,NULL,NULL,'2026-08-01 15:09:10','2026-08-01 15:09:10'),
(38,67,NULL,NULL,NULL,NULL,NULL,'2026-08-01 15:33:48','2026-08-01 15:33:48'),
(39,69,NULL,NULL,NULL,NULL,NULL,'2026-08-04 15:51:44','2026-08-04 15:51:44'),
(40,70,NULL,NULL,NULL,NULL,NULL,'2026-08-04 17:46:49','2026-08-04 17:46:49'),
(41,71,NULL,NULL,NULL,NULL,NULL,'2026-08-04 19:06:42','2026-08-04 19:06:42'),
(42,72,NULL,NULL,NULL,NULL,NULL,'2026-08-04 19:55:24','2026-08-04 19:55:24'),
(43,73,NULL,NULL,NULL,NULL,NULL,'2026-08-04 20:03:56','2026-08-04 20:03:56'),
(44,74,NULL,NULL,NULL,NULL,NULL,'2026-08-04 20:11:38','2026-08-04 20:11:38'),
(45,75,NULL,NULL,NULL,NULL,NULL,'2026-08-04 20:34:00','2026-08-04 20:34:00'),
(46,76,NULL,NULL,NULL,NULL,NULL,'2026-08-04 21:22:43','2026-08-04 21:22:43'),
(47,77,NULL,NULL,NULL,NULL,NULL,'2026-08-11 14:47:51','2026-08-11 14:47:51'),
(48,78,NULL,NULL,NULL,NULL,NULL,'2026-08-12 15:47:14','2026-08-12 15:47:14');
/*!40000 ALTER TABLE `lead_technical_profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leads`
--

DROP TABLE IF EXISTS `leads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `company` varchar(200) DEFAULT NULL,
  `position` varchar(200) DEFAULT NULL,
  `city` varchar(150) DEFAULT NULL,
  `region` varchar(150) DEFAULT NULL,
  `ruc` varchar(11) DEFAULT NULL,
  `business_name` varchar(250) DEFAULT NULL,
  `address` varchar(300) DEFAULT NULL,
  `audio_file_path` varchar(500) DEFAULT NULL,
  `photo_file_path` varchar(500) DEFAULT NULL,
  `client_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`client_type`)),
  `industry` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`industry`)),
  `classification` varchar(20) DEFAULT NULL,
  `observations` text DEFAULT NULL,
  `lat` decimal(10,7) DEFAULT NULL,
  `lng` decimal(10,7) DEFAULT NULL,
  `source` enum('manual','scan','voice','qr') NOT NULL DEFAULT 'manual',
  `status` enum('nuevo','contactado','calificado','propuesta','negociacion','ganado','perdido') NOT NULL DEFAULT 'nuevo',
  `loss_reason_id` int(11) DEFAULT NULL,
  `is_duplicate` tinyint(1) NOT NULL DEFAULT 0,
  `duplicate_of` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `loss_reason_id` (`loss_reason_id`),
  KEY `duplicate_of` (`duplicate_of`),
  KEY `updated_by` (`updated_by`),
  KEY `idx_leads_event_id` (`event_id`),
  KEY `idx_leads_status` (`status`),
  KEY `idx_leads_created_by` (`created_by`),
  KEY `idx_leads_email` (`email`),
  KEY `idx_leads_phone` (`phone`),
  KEY `idx_leads_ruc` (`ruc`),
  KEY `assigned_to` (`assigned_to`),
  CONSTRAINT `leads_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE,
  CONSTRAINT `leads_ibfk_2` FOREIGN KEY (`loss_reason_id`) REFERENCES `loss_reasons` (`id`) ON DELETE SET NULL,
  CONSTRAINT `leads_ibfk_3` FOREIGN KEY (`duplicate_of`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `leads_ibfk_4` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `leads_ibfk_5` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `leads_ibfk_6` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leads`
--

LOCK TABLES `leads` WRITE;
/*!40000 ALTER TABLE `leads` DISABLE KEYS */;
INSERT INTO `leads` VALUES
(32,6,'ABRAHAM ROBERTH','HINOSTROZA HENRIQUEZ',NULL,'+51 994 052 741','INVET PERU E.I.R.L.','Dueño','Trujillo','Huanchaco / Trujillo','20601433584','INVET PERU E.I.R.L.','MZ. E LT. 01 SEC. VALDIVIA BAJA',NULL,NULL,'[\"Distribuidor\"]','null','tibio','Contacto de Zamora',NULL,NULL,'manual','contactado',NULL,0,NULL,11,NULL,11,'2026-07-14 15:41:28','2026-08-01 16:16:24'),
(35,NULL,'RUTH BERTHA',' FUENTES VILLAR',NULL,'961908466','INVERSIONES COCOROCO S.A.','DUEÑA','PUCALLPA',NULL,'20393719100','INVERSIONES COCOROCO S.A.','CAR. FEDERICO BASADRE  KM. 10',NULL,NULL,'[\"Productor\"]','[\"Postura\",\"Pollo de carne\",\"Cerdos\"]','caliente','Asesor: Dr Lucio Icumina 961599422',NULL,NULL,'manual','negociacion',NULL,0,NULL,11,NULL,11,'2026-07-24 23:13:56','2026-07-31 22:12:55'),
(39,NULL,'MANOLO ','VASQUEZ OLIVARES',NULL,'913318028',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[\"Distribuidor\"]','[\"Ganado vacuno\"]','tibio','Dr. Manolo (Gerente de línea vet para cerdos y ganaderia para todo el pero de MSD) que trabaja en MSD interesado en productos para ganadería - Addikal',NULL,NULL,'manual','contactado',NULL,0,NULL,11,NULL,11,'2026-07-31 23:24:46','2026-08-01 16:07:33'),
(61,NULL,'Jorge','Zamora',NULL,'987 500 848','VENTREPCO S.A.C.','Gerente Comercial','Trujillo',NULL,'20614301369','VENTREPCO S.A.C.','AV. JOSE GABRIEL CONDORCANQUI MZ. 11 LT. 24 URB. MANUEL AREVALO II ETAPA',NULL,NULL,'[\"Asesor veterinario\",\"Distribuidor\"]','null',NULL,NULL,NULL,NULL,'manual','contactado',NULL,0,NULL,11,NULL,11,'2026-08-01 15:09:10','2026-08-11 14:53:17'),
(67,NULL,'Bryan Angel','De La Cruz Soto',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Carr. de Sunampe',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'manual','nuevo',NULL,0,NULL,13,NULL,NULL,'2026-08-01 15:33:48','2026-08-01 15:33:48'),
(69,NULL,'BLUDITH','VALLES PINEDO','vallespb@gmail.com','949364438','AGROPECUARIA RIO S.A.C.','JEFE DE LOGISTICA','TARAPOTO','TARAPOTO','20607517747','AGROPECUARIA RIO S.A.C.','CAR. MARGINAL NORTE  KM. 3',NULL,NULL,'[\"Integraci\\u00f3n\"]','[\"Reproductoras\",\"Pollo de carne\",\"Postura\"]','caliente',NULL,NULL,NULL,'manual','nuevo',NULL,0,NULL,11,NULL,NULL,'2026-08-04 15:51:44','2026-08-04 15:51:44'),
(70,10,'JORGE','CHACON HUERTAS','jorgechacon28@hotmail.com','998239510','DON LUCHO NUTRICION ANIMAL E.I.R.L.','Gerente ','CHANCAY ','LIMA','20613180100','DON LUCHO NUTRICION ANIMAL E.I.R.L.','CAL. LAS FLORES NRO. 194 URB. ALDEA CAMPESINA',NULL,NULL,'[\"Molino\"]','[\"Cerdos\",\"Pollo de carne\",\"Postura\",\"Reproductoras\"]','caliente',NULL,NULL,NULL,'manual','nuevo',NULL,0,NULL,15,NULL,NULL,'2026-08-04 17:46:49','2026-08-04 17:46:49'),
(71,10,'JAVIER','ROSARIO ',NULL,'945451476','ROSARIO RAMOS JAVIER JACINTO','DUEÑO ','CHANCAY','LIMA','10100682091','ROSARIO RAMOS JAVIER JACINTO',NULL,NULL,NULL,'[\"Productor\"]','[\"Pollo de carne\"]','caliente',NULL,NULL,NULL,'manual','nuevo',NULL,0,NULL,15,NULL,NULL,'2026-08-04 19:06:42','2026-08-04 19:06:42'),
(72,10,'ALEJANDRA','CARDENAS MALASQUEZ','agromacathon@gmail.com','941595403','AGRO MACATHON S.A.C.','ASISTENTE ADMINISTRATIVO ','CHANCAY','LIMA','20530716431','AGRO MACATHON S.A.C.','OTR. OTR. MZ G LOTE 12 URB. LO MZ. G LT. 12 LOT. LOT. PARCELACIÓN DEL FUND',NULL,NULL,'[\"Productor\"]','[\"Pollo de carne\",\"Ganado vacuno\"]','caliente',NULL,NULL,NULL,'manual','nuevo',NULL,0,NULL,15,NULL,NULL,'2026-08-04 19:55:24','2026-08-04 19:55:24'),
(73,10,'ALEJANDRA','CARDENAS MALASQUEZ','ciclodevidaavicolasac@gmail.com','993811624','CICLO DE VIDA AVICOLA S.A.C.','ASISTENTE ADMINISTRATIVO ','CHANCAY','LIMA','20614737493','CICLO DE VIDA AVICOLA S.A.C.','CAL. RAYMUNDO CARCAMO NRO. 1058 INT. A URB. SANTA CATALINA DPTO. 703',NULL,NULL,'[\"Productor\"]','[\"Pollo de carne\",\"Ganado vacuno\"]','caliente',NULL,NULL,NULL,'manual','nuevo',NULL,0,NULL,15,NULL,NULL,'2026-08-04 20:03:56','2026-08-04 20:03:56'),
(74,10,'ALEJANDRA','CARDENAS MALASQUEZ','infofatimasac@gmail.com','993811624','INSUMOS Y FORRAJES VIRGEN DE FATIMA S.A.C.','ASISTENTE ADMINISTRATIVO ','HUARAL','LIMA','20571510724','INSUMOS Y FORRAJES VIRGEN DE FATIMA S.A.C.','OTR. MZ G LOTE 12 URB. LOTIZAC MZ. G LT. 12 LOT. PARCELACIÓN DEL FUNDO CHA',NULL,NULL,'[\"Productor\"]','[\"Pollo de carne\",\"Ganado vacuno\"]','caliente','',NULL,NULL,'manual','nuevo',NULL,1,73,15,NULL,15,'2026-08-04 20:11:38','2026-08-04 21:24:01'),
(75,10,'JUAN EDUARDO ','AGUILAR GERVACIO','eduaguilar.311295@gmail.com','954 383 548','AGUILAR GERVACIO JUAN EDUARDO','SOCIO ','CHANCAY','LIMA','10716361085','AGUILAR GERVACIO JUAN EDUARDO',NULL,NULL,NULL,'[\"Molino\"]','[\"Cerdos\"]','caliente','',NULL,NULL,'manual','nuevo',NULL,0,NULL,15,NULL,15,'2026-08-04 20:34:00','2026-08-04 21:23:45'),
(76,10,'SOFIA','PALOMARES LLANOS','hpalomares8825@gmail.com','951448323','INVERSIONES Y COMERCIALIZADORA SANTA ROSA S.A.C.','SOCIA ','CHANCAY','LIMA','20608735110','INVERSIONES Y COMERCIALIZADORA SANTA ROSA S.A.C.','PRO. SANTA ROSA MZ. B LT. 2 FND. GALLEGOS',NULL,NULL,'[]','[\"Cerdos\",\"Postura\",\"Reproductoras\",\"Pollo de carne\"]','tibio','',NULL,NULL,'manual','nuevo',NULL,0,NULL,15,NULL,15,'2026-08-04 21:22:43','2026-08-04 21:23:23'),
(77,NULL,'HUGO','FLORES',NULL,'983620166','41955687','dueño','Abancay','Apurimac',NULL,NULL,'AV. MALVINAS MZ. A LOTE. 7 URB. SAN MARTIN DE PORRAS (CSTADO EXFABRICA SUPERCOLA) - ABANCAY - ABANCAY - APURIMAC',NULL,NULL,'[\"Productor\"]','[\"Pollo de carne\"]','tibio',NULL,NULL,NULL,'manual','nuevo',NULL,0,NULL,11,NULL,NULL,'2026-08-11 14:47:51','2026-08-11 14:47:51'),
(78,NULL,'LUIS ','REYES','logistica1@dm.pe','989 227 483','DM AVICOLA  S.A.C','LOGISTICA','CHINCHA','ICA','20495005217','DM AVICOLA  S.A.C','CAL. AYABACA MZ. B LT. 6 URB. INDUSTRIAL',NULL,NULL,'[\"Integraci\\u00f3n\"]','[\"Postura\"]','frio',NULL,NULL,NULL,'manual','contactado',NULL,0,NULL,11,NULL,11,'2026-08-12 15:47:14','2026-08-12 15:50:25'),
(88,10,'Esteban','Rivera Ortiz','erivera@italvetsac.com','970733765','Zetbios lab sac','Gerente comercial',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'qr','nuevo',NULL,0,NULL,1,NULL,NULL,'2026-08-20 23:11:24','2026-08-20 23:11:24');
/*!40000 ALTER TABLE `leads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loss_reasons`
--

DROP TABLE IF EXISTS `loss_reasons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `loss_reasons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `description` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loss_reasons`
--

LOCK TABLES `loss_reasons` WRITE;
/*!40000 ALTER TABLE `loss_reasons` DISABLE KEYS */;
INSERT INTO `loss_reasons` VALUES
(1,'Precio','El lead considero que el precio era muy alto','active','2026-06-17 03:03:47'),
(2,'Competencia','El lead eligio un competidor','active','2026-06-17 03:03:47'),
(3,'Sin interes','El lead perdio interes','active','2026-06-17 03:03:47'),
(4,'No contactable','No fue posible contactar al lead','active','2026-06-17 03:03:47'),
(5,'Presupuesto','El lead no cuenta con presupuesto','active','2026-06-17 03:03:47'),
(6,'Otro','Otro motivo no especificado','active','2026-06-17 03:03:47'),
(7,'Precio','El lead consideró que el precio era muy alto','active','2026-06-24 15:17:26'),
(8,'Competencia','El lead eligió un competidor','active','2026-06-24 15:17:26'),
(9,'Sin interés','El lead perdió interés en el producto/servicio','active','2026-06-24 15:17:26'),
(10,'No contactable','No fue posible contactar al lead','active','2026-06-24 15:17:26'),
(11,'Presupuesto','El lead no cuenta con presupuesto','active','2026-06-24 15:17:26'),
(12,'Otro','Otro motivo no especificado','active','2026-06-24 15:17:26');
/*!40000 ALTER TABLE `loss_reasons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `material_categories`
--

DROP TABLE IF EXISTS `material_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `material_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `description` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `material_categories`
--

LOCK TABLES `material_categories` WRITE;
/*!40000 ALTER TABLE `material_categories` DISABLE KEYS */;
INSERT INTO `material_categories` VALUES
(1,'Prueba','','active','2026-07-08 16:43:34','2026-07-08 16:43:34'),
(4,'BIOCID A','','active','2026-07-09 21:42:01','2026-07-09 21:42:01'),
(5,'HEPATOX 10','Nutraceutico de gran potencia para el manejo de factores tóxicos en el organismo animal. \nFormulación diseñada para contrarrestar el daño que ocasionan los desafíos tóxicos en los animales. REGENERADOR Y HEPATOPROTECTOR','active','2026-07-14 16:45:48','2026-07-14 16:45:48'),
(6,'HEPATOX PMX','Nutraceútico de gran potencia para el manejo de factores tóxicos en el organismo animal. \nFormulación diseñada para contrarrestar el daño que ocasionan los desafíos tóxicos en los animales','active','2026-07-14 16:55:48','2026-07-14 16:55:48'),
(7,'ADDIKAL pmx','Se constituye como la mejor alternativa para la obtención de energía a través de la ruta metabólica conocida como \ngluconeogénesis, lo cual resulta económicamente beneficioso para la industria pecuaria.   ','active','2026-07-14 17:00:34','2026-07-14 17:00:34'),
(8,'CIPROFOX ps','Combinación de principios activos de acción bactericida. La fosfomicina inhibe la formación de la pared celular bacteriana y la ciprofloxacina sinergia su acción bactericida.','active','2026-07-14 17:12:31','2026-07-14 17:12:31'),
(9,'COCCIPLUS pmx','Anticoccidial químico indicado en el control de protozoarios del género Eimeria en aves jóvenes. Sus componentes (Clopidol y Etopabato) tienen un efecto sinérgico, útil en programas de limpieza ya que reduce rápida y sustancialmente la cantidad de ooquistes en el ambiente.','active','2026-07-14 17:16:29','2026-07-14 17:16:29'),
(10,'DECABION MT','Fórmula antimicrobiana gran actividad bactericida y baja toxicidad que combina la acción de la Sulfamonometoxina con el Trimetoprim, constituyendo un efecto sinérgico \nde alta biodisponibilidad. ','active','2026-07-14 17:35:24','2026-07-14 17:35:24'),
(11,'DECABION ST','Indicado para controlar infecciones provocadas por gérmenes sensibles a la combinación Sulfa +Trimetoprim; bacterias Gram + y Gram -','active','2026-07-14 17:45:11','2026-07-14 17:45:11'),
(12,'ITALVIT B','','active','2026-07-14 20:41:54','2026-07-14 20:41:54'),
(13,'FLORFENICOL 8% pmx','premezcla compuesta de Florfenicol, \nantibiótico sintético de amplio espectro, \nderivado del Tianfenicol. ','active','2026-07-14 20:48:58','2026-07-14 20:48:58'),
(14,'FLORFENIGAN® 20','Poderoso \nantibiótico semisintético de amplio espectro \nútil en el tratamiento de infecciones de vías \nrespiratorias, digestivas y genitourinarias. \nEfectivo contra la mayoría de bacterias Gram \npositivas y Gr','active','2026-07-14 20:54:58','2026-07-14 20:54:58'),
(15,'FLORFENIGAN 25 ps','Polvo Soluble Oral, es la \nmezcla de un antibiótico semisintético de amplio \nespectro útil en el tratamiento de infecciones de \nvías respiratorias, digestivas y genitourinarias; \ncon un mucolítico expectorante como la \nBromhexina, coadyuvante ideal en el tratamiento \nde procesos respiratorios. ','active','2026-07-14 20:57:28','2026-07-14 20:57:28'),
(16,'GANAFUNG®','Es una mezcla de principios activos en una \nconcentración ideal para la conservación de \nalimento balanceado y materias primas. ','active','2026-07-14 21:01:34','2026-07-14 21:01:34'),
(17,'LEVONEOSIN®',' Está indicado para el tratamiento y \ncontrol de problemas infecciosos causados por \ngérmenes sensibles a la  Levofloxacina, bacterias \nGram positivas y Gram negativas, así como \nMicoplasmas.','active','2026-07-14 21:06:49','2026-07-14 21:06:49'),
(18,'LEVOSEPT PS ps','está indicado para controlar \nproblemas infecciosos causados por gérmenes \nsensibles a la  Levofloxacina y Neomicina, bacterias \nGram positivas y Gram negativas, así como \nMicoplasmas.','active','2026-07-14 21:09:39','2026-07-14 21:09:39'),
(19,'MEGADOX ps','MEGADOX polvo soluble, contiene una \nasociación sinérgica de dos potentes agentes \nantibacterianos y un eficiente fluidificador de \nmucus que permiten un tratamiento eficaz \ncontra mycoplasma.','active','2026-07-14 21:15:41','2026-07-14 21:15:41'),
(20,'NEOPLUS 50 ps','NEOPLUS polvo soluble, contiene uno de los \nantibióticos de elección con mayor frecuencia \nde uso y con excelentes resultados en \ntratamiento y control de desafíos de campo que \ncomprometen el sistema digestivo. ','active','2026-07-14 21:21:12','2026-07-14 21:21:12'),
(21,'PLEUROFOS ORAL T','PLEUROFOS ORAL – T.- está indicado para el \ntratamiento de infecciones sistémicas en los siguientes \ncasos: \nEn Aves: Colibacilosis, enteritis, salpingitis, septicemia, \nsalmonelosis, síndrome de cabeza hinchada, coriza \ninfecciosa, cólera aviar e infecciones por Staphylococcus \nsp. y en casos de enfermedad respiratoria crónica \ncausada por micoplasma. \nEn cerdos: Micoplasmosis, salmonelosis, colibacilosis, \ncolienterotoxemia, \ndiarreas \nbacterianas, \nbronconeumonía, neumonía ezootica, erisipela, cistitis, \npielonefritis, rinitis atrófica y complejo MMA. ','active','2026-07-14 21:43:48','2026-07-14 21:43:48'),
(22,'PLEUROFOS ORAL','PLEUROFOS está indicado para controlar \ninfecciones \nprovocadas \npor \ngérmenes \nsensibles a la Fosfomicina sódica.  \nLa fosfomicina actúa inhibiendo uno de los \nprimeros pasos en la síntesis de precursores de \npeptidoglucanos, componente principal de la \npared celular bacteriana. El trimetoprim es un \nantagonista sintético del ácido fólico que inhibe \nla síntesis de timidina, bloquea la conversión de \nácido dihidrofólico. ','active','2026-07-14 21:50:47','2026-07-14 21:50:47'),
(23,'RESPIFREE AE','Soporte respiratorio para \nsituaciones de estrés o riesgo de enfermedades \nrespiratorias en los animales. Gracias a sus \naceites esenciales que poseen acción \nexpectorante y descongestionante de las vías \naéreas, efecto refrescante o de enfriamiento que \nayuda a aliviar el estrés por calor (heat stress, y \nun efecto calmante del tracto respiratorio que \nmitiga las reacciones post-vacunales.','active','2026-07-14 22:49:06','2026-07-14 22:49:06'),
(24,'SPEKTOR B','SPEKTOR B - coadyuvante en todas las \nenfermedades respiratorias, severas, agudas o \ncrónicas, que cursen con secreción de moco y \ncon aumento de su viscosidad. ','active','2026-07-14 23:14:31','2026-07-14 23:14:31'),
(25,'SPEKTOR','Coadyuvante en todas las \nenfermedades respiratorias, severas, agudas o \ncrónicas, que cursen con secreción de moco y \ncon aumento de su viscosidad. ','active','2026-07-14 23:36:30','2026-07-14 23:36:30'),
(26,'SULFIKAR®','Antibiótico indicado para \ntratar infecciones complejas, por su combinación \núnica \nde Sulfametoxazol, Trimetoprim, y \nNorfloxacina, se obtiene un efecto sinérgico de gran \nalcance, cuya biodisponibilidad y alta eficacia están \ngarantizadas. Esta formulación exhibe propiedades \nbactericidas con mínima toxicidad, de tal manera \nque se logra una acción rápida y eficaz. ','active','2026-07-14 23:40:52','2026-07-14 23:40:52'),
(27,'TILVASAN ps','TILVASAN con su potente efecto, logra su acción bactericida \nen una mínima concentración y en un periodo menor de tiempo. \nPosee un potente efecto micoplasmicida, el cual es 10 veces mayor al de la Tilosina. ','active','2026-07-14 23:52:36','2026-07-14 23:52:36'),
(28,'TYLVASAN 5% pmx','TILVASAN 5% pmx con su potente efecto, \nlogra su acción bactericida en una mínima \nconcentración y en un periodo menor de tiempo. \nPosee un potente efecto antibacteriano, el cual \nes 10 veces mayor al de la Tilosina. ','active','2026-07-14 23:55:07','2026-07-14 23:55:07'),
(29,'AVIMOX-NOR 15 ps','AVIMOX-NOR Polvo Soluble Oral,  \nRecomendado para tratar enfermedad respiratoria \ncrónica (ERC), micoplasmosis, colibacilosis, \nsalmonelosis o coriza entre otras. Cerdos con \nneumonía enzoótica, rinitis atrófica y otros procesos \nrespiratorios-digestivos. Su fórmula une amoxicilina \ntrihidrato (penicilina de amplio espectro y alta \nbiodisponibilidad) con norfloxacina nicotinato \n(fluoroquinolona que bloquea la ADN-girasa \nbacteriana), ofreciendo una acción antibacteriana','active','2026-07-14 23:59:17','2026-07-14 23:59:17'),
(30,'AVIMOX-NOR ps','AVIMOX-NOR Polvo Soluble Oral,  \nRecomendado para tratar enfermedad respiratoria \ncrónica (ERC), micoplasmosis, colibacilosis, \nsalmonelosis o coriza entre otras. Cerdos con \nneumonía enzoótica, rinitis atrófica y otros procesos \nrespiratorios-digestivos. Su fórmula une amoxicilina \ntrihidrato (penicilina de amplio espectro y alta \nbiodisponibilidad) con norfloxacina nicotinato \n(fluoroquinolona que bloquea la ADN-girrasa \nbacteriana), ofreciendo una acción antibacteriana ','active','2026-07-15 00:03:16','2026-07-15 00:03:16');
/*!40000 ALTER TABLE `material_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notes`
--

DROP TABLE IF EXISTS `notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` int(11) NOT NULL,
  `type` enum('texto','audio') NOT NULL DEFAULT 'texto',
  `content` text DEFAULT NULL,
  `audio_file_path` varchar(500) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `lead_id` (`lead_id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `notes_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notes_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notes`
--

LOCK TABLES `notes` WRITE;
/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notifications`
--

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `type` enum('tarea_proxima','tarea_vencida','nuevo_lead','invitacion','actividad','nueva_tarea') NOT NULL,
  `title` varchar(200) NOT NULL,
  `message` text DEFAULT NULL,
  `reference_type` varchar(100) DEFAULT NULL,
  `reference_id` int(11) DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_notifications_user` (`user_id`,`is_read`),
  CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notifications`
--

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
INSERT INTO `notifications` VALUES
(36,11,'tarea_vencida','Tarea vencida: Otro','La tarea \'Otro\' para ABRAHAM ROBERTH HINOSTROZA HENRIQUEZ del 2026-07-14 está vencida','task',12,1,'2026-07-14 19:00:04'),
(40,13,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para swsssss ssssssss del 2026-07-14 está vencida','task',27,1,'2026-07-14 20:00:05'),
(44,13,'tarea_proxima','Tarea próxima: Llamar cliente','Tarea \'Llamar cliente\' para swsssss ssssssss a las 15:56:00','task',28,1,'2026-07-14 20:22:03'),
(45,13,'tarea_proxima','Tarea próxima: Llamar cliente','Tarea \'Llamar cliente\' para swsssss ssssssss a las 15:25:00','task',32,1,'2026-07-14 20:23:04'),
(46,13,'tarea_proxima','Tarea próxima: Enviar cotización','Tarea \'Enviar cotización\' para swsssss ssssssss a las 15:25:00','task',33,1,'2026-07-14 20:23:04'),
(47,13,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-07-14 a las 15:28','task',34,1,'2026-07-14 20:26:28'),
(48,13,'tarea_proxima','Tarea próxima: Llamar cliente','Tarea \'Llamar cliente\' para swsssss ssssssss a las 15:28:00','task',34,1,'2026-07-14 20:27:03'),
(49,14,'tarea_vencida','Tarea vencida: Seguimiento','La tarea \'Seguimiento\' para   del 2026-07-14 está vencida','task',23,0,'2026-07-14 21:00:05'),
(50,13,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para swsssss ssssssss del 2026-07-14 está vencida','task',31,1,'2026-07-14 21:00:05'),
(51,13,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para swsssss ssssssss del 2026-07-14 está vencida','task',34,1,'2026-07-14 21:00:05'),
(52,14,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-07-14 a las 18:15','task',35,0,'2026-07-14 23:10:33'),
(53,14,'tarea_proxima','Tarea próxima: Llamar cliente','Tarea \'Llamar cliente\' para   a las 18:15:00','task',35,0,'2026-07-14 23:11:03'),
(54,14,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para   del 2026-07-14 está vencida','task',35,0,'2026-07-15 00:00:04'),
(55,1,'tarea_vencida','Tarea vencida: Prueba','La tarea \'Prueba\' para   del 2026-07-14 está vencida','task',21,0,'2026-07-15 05:00:04'),
(56,11,'tarea_proxima','Tarea próxima: Otro','Tarea \'Otro\' para ABRAHAM ROBERTH HINOSTROZA HENRIQUEZ a las 09:30:00','task',12,1,'2026-07-15 13:30:04'),
(57,13,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-07-22','task',36,1,'2026-07-22 17:53:31'),
(58,13,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para swsssss ssssssss del 2026-07-22 está vencida','task',36,1,'2026-07-23 05:00:03'),
(59,11,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-07-24 a las 10:45','task',37,1,'2026-07-24 18:04:56'),
(60,11,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para ABRAHAM ROBERTH HINOSTROZA HENRIQUEZ del 2026-07-24 está vencida','task',37,1,'2026-07-24 19:00:04'),
(61,11,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-08-03 a las 10:30','task',38,0,'2026-07-24 23:33:37'),
(62,11,'tarea_proxima','Tarea próxima: Llamar cliente','Tarea \'Llamar cliente\' para ABRAHAM ROBERTH HINOSTROZA HENRIQUEZ a las 10:45:00','task',37,0,'2026-07-30 15:22:02'),
(63,13,'tarea_proxima','Tarea próxima: Llamar cliente','Tarea \'Llamar cliente\' para swsssss ssssssss a las 15:19:00','task',31,1,'2026-07-30 19:19:02'),
(64,13,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-07-30','task',39,1,'2026-07-30 22:47:55'),
(65,13,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-07-30','task',40,1,'2026-07-30 22:48:38'),
(66,13,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-07-30','task',41,1,'2026-07-30 23:23:43'),
(67,13,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para swsssss ssssssss del 2026-07-30 está vencida','task',41,1,'2026-07-31 05:00:04'),
(68,11,'nueva_tarea','Nueva tarea: Visita tecnica','Tarea programada para el 2026-08-10 a las 10:05','task',42,0,'2026-07-31 17:07:09'),
(69,13,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-07-31','task',43,0,'2026-07-31 23:11:38'),
(70,11,'nueva_tarea','Nueva tarea: WhatsApp','Tarea programada para el 2026-08-03 a las 07:50','task',44,0,'2026-07-31 23:27:03'),
(71,13,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para   del 2026-07-31 está vencida','task',43,0,'2026-08-01 00:00:03'),
(72,11,'nueva_tarea','Nueva tarea: Enviar cotizacion','Tarea programada para el 2026-08-01 a las 10:05','task',45,0,'2026-08-01 00:17:57'),
(73,11,'nueva_tarea','Nueva tarea: Enviar cotizacion','Tarea programada para el 2026-08-01 a las 11:30','task',46,0,'2026-08-01 00:21:34'),
(74,11,'tarea_proxima','Tarea próxima: Enviar cotización','Tarea \'Enviar cotización\' para ABRAHAM ROBERTH HINOSTROZA HENRIQUEZ a las 11:30:00','task',46,0,'2026-08-01 15:30:03'),
(75,11,'tarea_vencida','Tarea vencida: Enviar cotización','La tarea \'Enviar cotización\' para ABRAHAM ROBERTH HINOSTROZA HENRIQUEZ del 2026-08-01 está vencida','task',46,0,'2026-08-01 17:00:03'),
(76,11,'tarea_proxima','Tarea próxima: WhatsApp','Tarea \'WhatsApp\' para MANOLO  VASQUEZ OLIVARES a las 07:50:00','task',44,0,'2026-08-03 11:50:02'),
(77,11,'tarea_vencida','Tarea vencida: WhatsApp','La tarea \'WhatsApp\' para MANOLO  VASQUEZ OLIVARES del 2026-08-03 está vencida','task',44,0,'2026-08-03 13:00:03'),
(78,11,'tarea_proxima','Tarea próxima: Visita técnica','Tarea \'Visita técnica\' para RUTH BERTHA  FUENTES VILLAR a las 09:30:00','task',42,0,'2026-08-03 13:30:03'),
(79,11,'tarea_vencida','Tarea vencida: Visita técnica','La tarea \'Visita técnica\' para RUTH BERTHA  FUENTES VILLAR del 2026-08-03 está vencida','task',42,0,'2026-08-03 15:00:03'),
(80,11,'nueva_tarea','Nueva tarea: Seguimiento','Tarea programada para el 2026-08-04 a las 10:00','task',47,0,'2026-08-04 15:56:36'),
(81,11,'tarea_vencida','Tarea vencida: Seguimiento','La tarea \'Seguimiento\' para BLUDITH VALLES PINEDO del 2026-08-04 está vencida','task',47,0,'2026-08-04 16:00:05'),
(82,11,'tarea_proxima','Tarea próxima: Seguimiento','Tarea \'Seguimiento\' para BLUDITH VALLES PINEDO a las 10:00:00','task',47,0,'2026-08-07 14:00:03'),
(83,11,'nueva_tarea','Nueva tarea: Llamar cliente','Tarea programada para el 2026-08-11','task',48,0,'2026-08-11 14:51:30'),
(84,11,'nueva_tarea','Nueva tarea: Seguimiento','Tarea programada para el 2026-08-13 a las 09:00','task',49,0,'2026-08-12 15:50:17'),
(85,11,'tarea_proxima','Tarea próxima: Seguimiento','Tarea \'Seguimiento\' para LUIS  REYES a las 09:00:00','task',49,0,'2026-08-13 13:00:05'),
(86,11,'tarea_vencida','Tarea vencida: Seguimiento','La tarea \'Seguimiento\' para LUIS  REYES del 2026-08-13 está vencida','task',49,0,'2026-08-13 14:00:03'),
(87,11,'tarea_proxima','Tarea próxima: Llamar cliente','Tarea \'Llamar cliente\' para HUGO FLORES a las 11:52:00','task',48,0,'2026-08-13 15:52:03'),
(88,11,'tarea_vencida','Tarea vencida: Llamar cliente','La tarea \'Llamar cliente\' para HUGO FLORES del 2026-08-13 está vencida','task',48,0,'2026-08-13 17:00:03');
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `expires_at` timestamp NOT NULL,
  `used` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `password_resets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` VALUES
(1,1,'6f0cfaa28cc61fce548e6b46e7d9829f1ea3f1940d5994c28af44bfa6efb3ead','2026-06-24 00:42:37',1,'2026-06-23 23:42:37'),
(2,1,'d51a388dec1bd9194132eea1151c387c38fdf4d2b3d78c04b4d7eaa9817dd714','2026-06-24 00:42:38',1,'2026-06-23 23:42:38'),
(3,1,'7885e3af013f75501dbd4b1f69e6f50cd7dd27e37de41ae4d1af12d5a4ecee2a','2026-06-24 00:42:39',1,'2026-06-23 23:42:39'),
(4,1,'e982ea8f42745c4c45550a82a3a38c88f2e1f7d6473e7aaf589526f5a438bef7','2026-06-24 00:46:22',1,'2026-06-23 23:46:22'),
(5,1,'c63ba429baf6de0011ab5fe54e99c044f2261cd0e317a95f34763ffbc576a3b0','2026-06-24 00:46:23',1,'2026-06-23 23:46:23'),
(6,1,'8a1e0e03295f78a7198458c54934e7484f875a65cb93f64157d4681106ef1134','2026-06-24 00:46:24',1,'2026-06-23 23:46:24'),
(7,15,'e833b721c5800acfcd11716c955d13867742beaa13fdd3510d0b603e00a3a48a','2026-08-04 22:55:13',1,'2026-08-04 14:55:13');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` text DEFAULT NULL,
  `category` text DEFAULT NULL,
  `species` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES
(3,'BIOCID A','Antifungico, Antibacteriano, altamente efectivo contra hongos y bacterias enteropatógenas, incluida Salmonella.  \nEs una mezcla de ácidos orgánicos y sus sales en \nuna concentración, apta para la conservación de subproductos animales, vegetales y alimento balanceado. ','Sanidad (antifúngico, antibacteriano, va al alimento)',NULL,'active','2026-07-09 21:33:14','2026-07-09 21:33:14'),
(4,'HEPATOX 10','Nutraceutico de gran potencia para el manejo de factores tóxicos en el organismo animal. \nFormulación diseñada para contrarrestar el daño que ocasionan los desafíos tóxicos en los animales ','Nutrición, Sanidad, (HEPATOPROTECTOR, REGENERADOR DE HIGADO)',NULL,'active','2026-07-14 16:43:57','2026-07-14 16:43:57'),
(5,'HEPATOX pmx','Nutraceútico de gran potencia para el manejo de factores tóxicos en el organismo animal. \nFormulación diseñada para contrarrestar el daño que ocasionan los desafíos tóxicos en los animales','Nutrición, Sanidad, Hepatoprotector y regenerador del hígado (Polvo)',NULL,'active','2026-07-14 16:54:58','2026-07-14 17:02:15'),
(6,'ADDIKAL pmx','Se constituye como la mejor alternativa para la obtención de energía a través de la ruta metabólica conocida como \ngluconeogénesis, lo cual resulta económicamente beneficioso para la industria pecuaria.   ','[\"Nutrición, Sanidad, \"]','[\"Pollo de carne\",\"Postura\",\"Reproductoras\",\"Cerdos\",\"Pavos\",\"Patos\"]','active','2026-07-14 16:59:31','2026-07-15 17:20:32'),
(7,'CIPROFOX ps','Combinación de principios activos de acción bactericida. La fosfomicina inhibe la formación de la pared celular bacteriana y la ciprofloxacina sinergia su acción bactericida. ','Sanidad',NULL,'active','2026-07-14 17:11:30','2026-07-14 17:11:30'),
(8,'COCCIPLUS','Anticoccidial químico indicado en el control de protozoarios del género Eimeria en aves jóvenes. Sus componentes (Clopidol y Etopabato) tienen un efecto sinérgico, útil en programas de limpieza ya que reduce rápida y sustancialmente la cantidad de ooquistes en el ambiente. ','[\"Sanidad\"]','[\"Pollo de carne\",\"Postura\",\"Reproductoras\"]','active','2026-07-14 17:15:18','2026-07-15 17:20:55'),
(9,'DECABION MT','es una fórmula antimicrobiana de gran actividad bactericida y baja toxicidad que combina la acción de la Sulfamonometoxina con el Trimetoprim, constituyendo un efecto sinérgico de alta biodisponibilidad. ','[\"SRS\",\"Sanidad\"]',NULL,'inactive','2026-07-14 17:34:31','2026-07-15 00:04:03'),
(10,'DECABION ST','Indicado para controlar infecciones provocadas por gérmenes sensibles a la combinación Sulfa +Trimetoprim; \nbacterias Gram + y Gram - ','Sanidad',NULL,'active','2026-07-14 17:44:27','2026-07-14 17:44:27'),
(11,'ITALVIT B','Multivitamínico reconstituyente y de soporte en cuadros de micotoxicosis, hepatitis, dermatitis, trastornos \ndigestivos, estrés, desintoxicaciones, trastornos \nen el crecimiento. Asimismo, mejora la productividad y calidad de huevos, aumenta la fertilidad e incubabilidad, mejora el emplume y estimula el apetito en estados de convalecencia. \nAdemás, actúa como coadyuvante en el tratamiento de hígado graso y en terapias prolongadas con antibióticos.','[\"SRS\",\"Sanidad\"]',NULL,'inactive','2026-07-14 18:01:56','2026-07-15 00:04:38'),
(13,'FLORFENICOL 8% pmx','Premezcla compuesta de Florfenicol, antibiótico sintético de amplio espectro, derivado del Tianfenicol. ','[\"SRS\",\"Sanidad\"]',NULL,'active','2026-07-14 20:47:47','2026-07-31 22:11:10'),
(14,'FLORFENIGAN® 20 pmx','Premix, es un poderoso \nantibiótico semisintético de amplio espectro \nútil en el tratamiento de infecciones de vías \nrespiratorias, digestivas y genitourinarias. \nEfectivo contra la mayoría de bacterias Gram \npositivas y Gram negativas e incluso contra \nanaerobio.','[\"SRS\",\"Sanidad\"]',NULL,'inactive','2026-07-14 20:53:19','2026-07-15 00:04:16'),
(15,'FLORFENIGAN® 25 ps','Polvo Soluble Oral, es la \nmezcla de un antibiótico semisintético de amplio \nespectro útil en el tratamiento de infecciones de \nvías respiratorias, digestivas y genitourinarias; \ncon un mucolítico expectorante como la \nBromhexina, coadyuvante ideal en el tratamiento \nde procesos respiratorios. ','[\"SRS\",\"Sanidad\"]',NULL,'inactive','2026-07-14 20:56:42','2026-07-15 00:04:22'),
(16,'GANAFUNG®','Es una mezcla de principios activos en una \nconcentración ideal para la conservación de \nalimento balanceado y materias primas. ','[\"SRS\",\"Sanidad (antifúngico, antibacteriano, va al alimento)\"]',NULL,'inactive','2026-07-14 21:00:16','2026-07-15 00:04:27'),
(17,'LEVONEOSIN® ','Solución Oral. Está indicado para el tratamiento y \ncontrol de problemas infecciosos causados por \ngérmenes sensibles a la  Levofloxacina, bacterias \nGram positivas y Gram negativas, así como \nMicoplasmas.','[\"Sanidad\"]',NULL,'active','2026-07-14 21:06:12','2026-07-14 21:06:12'),
(18,'LEVOSEPT PS ps','está indicado para controlar \nproblemas infecciosos causados por gérmenes \nsensibles a la  Levofloxacina y Neomicina, bacterias \nGram positivas y Gram negativas, así como \nMicoplasmas.','[\"Sanidad\"]',NULL,'active','2026-07-14 21:09:14','2026-07-14 21:09:14'),
(19,'MEGADOX ps','MEGADOX polvo soluble, contiene una \nasociación sinérgica de dos potentes agentes \nantibacterianos y un eficiente fluidificador de \nmucus que permiten un tratamiento eficaz \ncontra mycoplasma.','[\"Sanidad\"]',NULL,'active','2026-07-14 21:15:17','2026-07-14 21:15:17'),
(20,'NEOPLUS 50 ps','NEOPLUS polvo soluble, contiene uno de los \nantibióticos de elección con mayor frecuencia \nde uso y con excelentes resultados en \ntratamiento y control de desafíos de campo que \ncomprometen el sistema digestivo. ','[\"SRS\",\"Sanidad\"]',NULL,'inactive','2026-07-14 21:19:11','2026-07-15 00:04:49'),
(21,'PLEUROFOS ORAL T ps','PLEUROFOS ORAL – T.- está indicado para el \ntratamiento de infecciones sistémicas en los siguientes \ncasos: \nEn Aves: Colibacilosis, enteritis, salpingitis, septicemia, \nsalmonelosis, síndrome de cabeza hinchada, coriza \ninfecciosa, cólera aviar e infecciones por Staphylococcus \nsp. y en casos de enfermedad respiratoria crónica \ncausada por micoplasma. \nEn cerdos: Micoplasmosis, salmonelosis, colibacilosis, \ncolienterotoxemia, \ndiarreas \nbacterianas, \nbronconeumonía, neumonía ezootica, erisipela, cistitis, \npielonefritis, rinitis atrófica y complejo MMA. ','[\"SANIDAD\"]',NULL,'active','2026-07-14 21:34:46','2026-07-14 21:34:46'),
(22,'PLEUROFOS ORAL','PLEUROFOS está indicado para controlar \ninfecciones provocadas por gérmenes sensibles a la Fosfomicina sódica.  \nLa fosfomicina actúa inhibiendo uno de los \nprimeros pasos en la síntesis de precursores de \npeptidoglucanos, componente principal de la \npared celular bacteriana. El trimetoprim es un \nantagonista sintético del ácido fólico que inhibe \nla síntesis de timidina, bloquea la conversión de \nácido dihidrofólico. ','[\"Sanidad\"]',NULL,'active','2026-07-14 21:50:02','2026-07-14 21:50:02'),
(23,'LISINA','','[\"SRS\",\"ADITIVOS\",\"ZOOTECNICOS\"]',NULL,'inactive','2026-07-14 21:59:24','2026-07-15 00:04:42'),
(24,'RESPIFREE AE','Soporte respiratorio para \nsituaciones de estrés o riesgo de enfermedades \nrespiratorias en los animales. Gracias a sus \naceites esenciales que poseen acción \nexpectorante y descongestionante de las vías \naéreas, efecto refrescante o de enfriamiento que \nayuda a aliviar el estrés por calor (heat stress, y \nun efecto calmante del tracto respiratorio que \nmitiga las reacciones post-vacunales.','[\"SOPORTE RESPIRATORIO\",\"Aditivo Zootécnico\",\"Estres por calor\"]',NULL,'active','2026-07-14 22:48:27','2026-07-14 22:48:27'),
(25,'SPEKTOR B','SPEKTOR B - coadyuvante en todas las \nenfermedades respiratorias, severas, agudas o \ncrónicas, que cursen con secreción de moco y \ncon aumento de su viscosidad. ','[\"SRS\",\"SANIDAD\"]',NULL,'inactive','2026-07-14 23:13:56','2026-07-15 00:04:59'),
(26,'SPEKTOR','SPEKTOR. Coadyuvante en todas las \nenfermedades respiratorias, severas, agudas o \ncrónicas, que cursen con secreción de moco y \ncon aumento de su viscosidad. ','[\"Sanidad\",\"Espectorante\"]',NULL,'active','2026-07-14 23:35:37','2026-07-14 23:36:02'),
(27,'SULFIKAR® ps','Antibiótico indicado para tratar infecciones complejas, por su combinación única de Sulfametoxazol, Trimetoprim, y \nNorfloxacina, se obtiene un efecto sinérgico de gran \nalcance, cuya biodisponibilidad y alta eficacia están \ngarantizadas. Esta formulación exhibe propiedades \nbactericidas con mínima toxicidad, de tal manera \nque se logra una acción rápida y eficaz. ','[\"Sanidad\"]',NULL,'active','2026-07-14 23:39:54','2026-07-14 23:39:54'),
(28,'TILVASAN ps','TILVASAN con su potente efecto, logra su acción bactericida \nen una mínima concentración y en un periodo menor de tiempo. \nPosee un potente efecto micoplasmicida, el cual es 10 veces mayor al de la Tilosina. ','[\"Sanidad\"]',NULL,'active','2026-07-14 23:51:14','2026-07-14 23:51:14'),
(29,'TYLVASAN 5% pmx','TILVASAN 5% pmx con su potente efecto, \nlogra su acción bactericida en una mínima \nconcentración y en un periodo menor de tiempo. \nPosee un potente efecto antibacteriano, el cual \nes 10 veces mayor al de la Tilosina. ','[\"Sanidad\"]',NULL,'active','2026-07-14 23:54:28','2026-07-14 23:54:28'),
(30,'AVIMOX-NOR 15 ps','AVIMOX-NOR Polvo Soluble Oral,  \nRecomendado para tratar enfermedad respiratoria \ncrónica (ERC), micoplasmosis, colibacilosis, \nsalmonelosis o coriza entre otras. Cerdos con \nneumonía enzoótica, rinitis atrófica y otros procesos \nrespiratorios-digestivos. Su fórmula une amoxicilina \ntrihidrato (penicilina de amplio espectro y alta \nbiodisponibilidad) con norfloxacina nicotinato \n(fluoroquinolona que bloquea la ADN-girasa \nbacteriana), ofreciendo una acción antibacteriana','[\"SRS\",\"Sanidad\"]',NULL,'inactive','2026-07-14 23:58:35','2026-07-15 00:03:55'),
(31,'AVIMOX-NOR ps','AVIMOX-NOR Polvo Soluble Oral,  \nRecomendado para tratar enfermedad respiratoria \ncrónica (ERC), micoplasmosis, colibacilosis, \nsalmonelosis o coriza entre otras. Cerdos con \nneumonía enzoótica, rinitis atrófica y otros procesos \nrespiratorios-digestivos. Su fórmula une amoxicilina \ntrihidrato (penicilina de amplio espectro y alta \nbiodisponibilidad) con norfloxacina nicotinato \n(fluoroquinolona que bloquea la ADN-girrasa \nbacteriana), ofreciendo una acción antibacteriana ','[\"SRS\",\"Sanidad\"]',NULL,'inactive','2026-07-15 00:02:52','2026-07-15 00:03:58');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `token` varchar(500) NOT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `expires_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`),
  KEY `idx_sessions_user_id` (`user_id`),
  KEY `idx_sessions_expires_at` (`expires_at`),
  CONSTRAINT `sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `species`
--

DROP TABLE IF EXISTS `species`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `species` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_species_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `species`
--

LOCK TABLES `species` WRITE;
/*!40000 ALTER TABLE `species` DISABLE KEYS */;
INSERT INTO `species` VALUES
(1,'Pollo de carne','2026-07-14 21:19:58','2026-07-14 21:19:58'),
(2,'Postura','2026-07-14 21:19:58','2026-07-14 21:19:58'),
(3,'Reproductoras','2026-07-14 21:19:58','2026-07-14 21:19:58'),
(4,'Pavos','2026-07-14 21:19:58','2026-07-14 21:19:58'),
(5,'Cerdos','2026-07-14 21:19:58','2026-07-14 21:19:58'),
(6,'Patos','2026-07-14 21:19:58','2026-07-14 21:19:58'),
(7,'Cuyes','2026-07-14 21:19:58','2026-07-14 21:19:58'),
(8,'Ganado vacuno','2026-07-14 21:19:58','2026-07-14 21:19:58');
/*!40000 ALTER TABLE `species` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `task_attachments`
--

DROP TABLE IF EXISTS `task_attachments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `task_attachments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `task_id` (`task_id`),
  CONSTRAINT `task_attachments_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `task_attachments`
--

LOCK TABLES `task_attachments` WRITE;
/*!40000 ALTER TABLE `task_attachments` DISABLE KEYS */;
INSERT INTO `task_attachments` VALUES
(9,42,'task_6a6cd63d253e3.jpg','17855174905467513204345393783199.jpg','2026-07-31 17:07:09'),
(10,42,'task_6a6cdeaa4b015.docx','CONSOLIDADO JUNIO JULIO 2026.docx','2026-07-31 17:43:06'),
(11,43,'task_6a6d2baabdd61.png','Gemini_Generated_Image_k3efkdk3efkdk3ef.png','2026-07-31 23:11:38'),
(12,43,'task_6a6d2fd25b1a4.png','ChatGPT Image 1 jul 2026, 03_00_05.png','2026-07-31 23:29:22'),
(13,47,'task_6a73b359cbed4.jpg','17859673758408246731640141909912.jpg','2026-08-05 22:04:09'),
(15,48,'task_6a7b3730de551.pdf','GR N° EG07-00000363.pdf','2026-08-11 14:52:32');
/*!40000 ALTER TABLE `task_attachments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tasks`
--

DROP TABLE IF EXISTS `tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` int(11) DEFAULT NULL,
  `type` varchar(100) NOT NULL,
  `scheduled_date` date NOT NULL,
  `scheduled_time` time DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `farm_lat` decimal(10,7) DEFAULT NULL,
  `farm_lng` decimal(10,7) DEFAULT NULL,
  `assigned_to` int(11) NOT NULL,
  `status` enum('pendiente','completada','cancelada') NOT NULL DEFAULT 'pendiente',
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `lead_id` (`lead_id`),
  KEY `created_by` (`created_by`),
  KEY `idx_tasks_assigned_to` (`assigned_to`),
  KEY `idx_tasks_scheduled_date` (`scheduled_date`),
  KEY `idx_tasks_status` (`status`),
  CONSTRAINT `tasks_ibfk_2` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`),
  CONSTRAINT `tasks_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tasks_lead_id_fk` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tasks`
--

LOCK TABLES `tasks` WRITE;
/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
INSERT INTO `tasks` VALUES
(12,32,'otro','2026-07-15','09:30:00','14/07  según conversación de hoy, se quedó en visita a Trujillo para ordenar las visitas a clientes, evitando interferencias y cruces que ocasionan nulidad de ventas, días de atención: Miércoles, Jueves o viernes. coordinar para reunirse con Dr Zamora allá en Trujillo',NULL,NULL,11,'completada','2026-07-24 16:54:53',11,'2026-07-14 15:58:30','2026-07-24 17:54:53'),
(37,32,'llamada','2026-07-31','12:46:00','Cotizacion\r\nBonos para vendedores\r\nComision para Zamora',NULL,NULL,11,'completada','2026-07-31 23:19:44',11,'2026-07-24 18:04:56','2026-08-01 00:19:44'),
(42,35,'reunion','2026-08-13','09:30:00','12/08 Cita jueves 13/set a las 9 am \r\n10/08 hoy se compró pasajes del 12 al 14 ago.\r\nProgramar visita para el 12 13 14 de agosto, CONFIRMÓ FECHAS, comprar pasajes\r\n',NULL,NULL,11,'pendiente',NULL,11,'2026-07-31 17:07:09','2026-08-12 16:41:28'),
(43,NULL,'llamada','2026-07-31','15:20:00',NULL,NULL,NULL,13,'pendiente',NULL,13,'2026-07-31 23:11:38','2026-07-31 23:29:06'),
(44,39,'whatsapp','2026-08-13','11:00:00','Mandarle un mensaje a Manolo sobre Addikal, le preguntará al Dr. Jorge Del Campo (conoce gluconeogenico) como se llama ese gluconeogenico.  (para investigarlo nosotros) y Dr. Roberto Evaristo. (asesor)...y el jueves 6 como a las 10 llamarlo para ver que averiguó.',NULL,NULL,11,'pendiente',NULL,11,'2026-07-31 23:27:03','2026-08-12 15:51:28'),
(46,32,'correo','2026-08-13','09:00:00','3/8 zamora dice Robert no le conesta, ver pasarlo directamente\r\n10/10 Roberth ya recibió precios, nos debe OC de paquete',NULL,NULL,11,'pendiente',NULL,11,'2026-08-01 00:21:34','2026-08-12 15:51:45'),
(47,69,'seguimiento','2026-08-17','10:00:00','4/08 Se le cotizó TILVASAN 5% $ 5.80 + IGV/ kg\r\n5/8 SE COTIZO enro cipro y oxitetra y amoxi, esperamos oc\r\n10/08 se le hizo seguimiento x wsp, se espera rpta\r\n11/08 hablé con Bludith aun no hay compra, llamar luego',NULL,NULL,11,'pendiente',NULL,11,'2026-08-04 15:56:36','2026-08-11 15:03:47'),
(48,77,'llamada','2026-08-13','11:52:00','en julio compró 60 \r\nL de Spektor',NULL,NULL,11,'pendiente',NULL,11,'2026-08-11 14:51:30','2026-08-11 14:52:32'),
(49,78,'seguimiento','2026-08-13','09:00:00','12/08 se cotizó respuesta DECABION MT Precio $ 43.25 + igv / kg, esperar respuesta',NULL,NULL,11,'pendiente',NULL,11,'2026-08-12 15:50:17','2026-08-12 15:50:17');
/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `technical_materials`
--

DROP TABLE IF EXISTS `technical_materials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `technical_materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `description` text DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `type` enum('pdf','video') NOT NULL,
  `file_path` varchar(500) DEFAULT NULL,
  `external_url` varchar(500) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `public_token` varchar(36) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `public_token` (`public_token`),
  KEY `created_by` (`created_by`),
  KEY `idx_materials_category` (`category_id`),
  KEY `idx_materials_public_token` (`public_token`),
  CONSTRAINT `technical_materials_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `technical_materials_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `material_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `technical_materials`
--

LOCK TABLES `technical_materials` WRITE;
/*!40000 ALTER TABLE `technical_materials` DISABLE KEYS */;
INSERT INTO `technical_materials` VALUES
(4,'FICHA TECNICA BIOCID A','Antifungico, Antibacteriano, \naltamente efectivo contra hongos y bacterias \nenteropatógenas, incluida Salmonella.  \nEs una mezcla de ácidos orgánicos y sus sales \nen una concentración, apta para la \nconservación de subproductos animales, \nvegetales y alimento balanceado.  ',4,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a5015d0c4ad6.pdf','','active','d44bee-bbe9fa-b086a572',1,'2026-07-09 21:42:40','2026-07-14 17:32:12'),
(5,'FICHA TECNICA HEPATOX 10','Nutraceutico de gran potencia \r\npara el manejo de factores tóxicos en el \r\norganismo animal. \r\nFormulación diseñada para contrarrestar el \r\ndaño que ocasionan los desafíos tóxicos en los \r\nanimales ',5,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a5667ef8b3d3.pdf','','active','73c43f-9b1afb-3ffcb291',1,'2026-07-14 16:46:39','2026-07-14 17:32:02'),
(6,'FICHA TECNICA HEPATOX pmx','Nutraceútico de gran potencia para el manejo de factores tóxicos en el organismo animal. \r\nFormulación diseñada para contrarrestar el daño que ocasionan los desafíos tóxicos en los animales',6,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a566a40df6c1.pdf','','active','84cb18-3a9d59-bc6ba1b9',14,'2026-07-14 16:56:32','2026-07-14 17:31:45'),
(7,'FICHA TECNICA ADDIKAL','Se constituye como la \r\nmejor alternativa para la obtención de energía a \r\ntravés de la ruta metabólica conocida como \r\ngluconeogénesis, lo cual resulta económicamente beneficioso para la industria pecuaria.   ',7,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a5ab742c6667.pdf','','active','59e897-5ff833-b55ab713',14,'2026-07-14 17:01:24','2026-07-17 23:14:10'),
(8,'FICHA TECNICA CIPROFOX','Combinación de principios activos de acción bactericida. La fosfomicina inhibe la formación de la pared celular bacteriana y la ciprofloxacina sinergia su acción bactericida.',8,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a566e3089ab2.pdf','','active','55519e-bd5639-80ce98d2',14,'2026-07-14 17:13:20','2026-07-14 17:31:25'),
(9,'FICHA TECNICA COCCIPLUS','Anticoccidial químico indicado en el control de protozoarios del género Eimeria en aves jóvenes. Sus componentes (Clopidol y Etopabato) tienen un efecto sinérgico, útil en programas de limpieza ya que reduce rápida y sustancialmente la cantidad de ooquistes en el ambiente.',9,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a566f0652f87.pdf','','active','848625-85463e-2a14d430',14,'2026-07-14 17:16:54','2026-07-14 17:31:12'),
(10,'FICHA TECNICA DECABION MT','Fórmula antimicrobiana gran actividad bactericida y baja toxicidad que combina la acción de la Sulfamonometoxina con el Trimetoprim, constituyendo un efecto sinérgico \r\nde alta biodisponibilidad. ',10,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56737e53909.pdf',NULL,'active','4ce49d-6bb782-ae361074',14,'2026-07-14 17:35:58','2026-07-14 17:35:58'),
(11,'FICHA TECNICA DECABION ST','Indicado para controlar infecciones provocadas por gérmenes sensibles a la combinación Sulfa +Trimetoprim; bacterias Gram + y Gram -',11,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a5675c14f290.pdf',NULL,'active','6c3e31-67936a-008ea193',14,'2026-07-14 17:45:37','2026-07-14 17:45:37'),
(12,'FICHA TECNICA ITALVIT B','Multivitamínico reconstituyente y de soporte en cuadros de micotoxicosis, hepatitis, dermatitis, trastornos digestivos, estrés, desintoxicaciones, trastornos en el crecimiento. Asimismo, mejora la productividad y calidad de huevos, aumenta la fertilidad e incubabilidad, mejora el emplume y estimula el apetito en estados de convalecencia. Además, actúa como coadyuvante en el tratamiento de hígado graso y en terapias prolongadas con antibióticos.',12,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a569f6b71ac7.pdf',NULL,'active','36b28c-e747f6-e3d2a95b',14,'2026-07-14 20:43:23','2026-07-14 20:43:23'),
(13,'FICHA TECNICA FLORFENICOL 8','premezcla compuesta de Florfenicol, \r\nantibiótico sintético de amplio espectro, \r\nderivado del Tianfenicol. ',13,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56a0df68a6a.pdf',NULL,'active','f921ae-617dee-f65835e9',14,'2026-07-14 20:49:35','2026-07-14 20:49:35'),
(14,'FICHA TECNICA FLORFENIGAN 20 pmx','poderoso \r\nantibiótico semisintético de amplio espectro \r\nútil en el tratamiento de infecciones de vías \r\nrespiratorias, digestivas y genitourinarias. \r\nEfectivo contra la mayoría de bacterias Gram \r\npositivas y Gr',14,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56a2491421d.pdf',NULL,'active','750f6e-ced4d4-63fa3677',14,'2026-07-14 20:55:37','2026-07-14 20:55:37'),
(15,'FICHA TECNICA FLORFENIGAN® 25 ps','FLORFENIGAN® 25 Polvo Soluble Oral, es la \r\nmezcla de un antibiótico semisintético de amplio \r\nespectro útil en el tratamiento de infecciones de \r\nvías respiratorias, digestivas y genitourinarias; \r\ncon un mucolítico expectorante como la \r\nBromhexina, coadyuvante ideal en el tratamiento \r\nde procesos respiratorios. ',15,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56a2f58ef0e.pdf',NULL,'active','a0106a-720386-3e7e5aff',14,'2026-07-14 20:58:29','2026-07-14 20:58:29'),
(16,'FICHA TECNICA GANAFUNG','Es una mezcla de principios activos en una \r\nconcentración ideal para la conservación de \r\nalimento balanceado y materias primas. ',16,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56a3d3d603d.pdf',NULL,'active','a250cf-45fb14-6f2846bf',14,'2026-07-14 21:02:11','2026-07-14 21:02:11'),
(17,'FICHA TECNICA LEVONEOSIN®',' Está indicado para el tratamiento y \r\ncontrol de problemas infecciosos causados por \r\ngérmenes sensibles a la  Levofloxacina, bacterias \r\nGram positivas y Gram negativas, así como \r\nMicoplasmas.',17,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56a50c64423.pdf',NULL,'active','e274d0-480d15-c5e92539',14,'2026-07-14 21:07:24','2026-07-14 21:07:24'),
(18,'FICHA TECNICA LEVOSEPT PS','está indicado para controlar \r\nproblemas infecciosos causados por gérmenes \r\nsensibles a la  Levofloxacina y Neomicina, bacterias \r\nGram positivas y Gram negativas, así como \r\nMicoplasmas.',18,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56a5bb2eee5.pdf',NULL,'active','fc92f6-684867-2dca5a31',14,'2026-07-14 21:10:19','2026-07-14 21:10:19'),
(19,'FICHA TECNICA MEGADOX ps','MEGADOX polvo soluble, contiene una \r\nasociación sinérgica de dos potentes agentes \r\nantibacterianos y un eficiente fluidificador de \r\nmucus que permiten un tratamiento eficaz \r\ncontra mycoplasma.',19,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56a718c86c1.pdf',NULL,'active','45b1e6-a08a8f-f1164dcd',14,'2026-07-14 21:16:08','2026-07-14 21:16:08'),
(20,'FICHA TECNICA NEOPLUS 50 ps','NEOPLUS polvo soluble, contiene uno de los \r\nantibióticos de elección con mayor frecuencia \r\nde uso y con excelentes resultados en \r\ntratamiento y control de desafíos de campo que \r\ncomprometen el sistema digestivo. ',20,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56a863d3d4f.pdf',NULL,'active','3aaab4-1cbe86-68cadc04',14,'2026-07-14 21:21:39','2026-07-14 21:21:39'),
(21,'FICHA TECNICA PLEUROFOS ORAL- T','PLEUROFOS ORAL – T.- está indicado para el \r\ntratamiento de infecciones sistémicas en los siguientes \r\ncasos: \r\nEn Aves: Colibacilosis, enteritis, salpingitis, septicemia, \r\nsalmonelosis, síndrome de cabeza hinchada, coriza \r\ninfecciosa, cólera aviar e infecciones por Staphylococcus \r\nsp. y en casos de enfermedad respiratoria crónica \r\ncausada por micoplasma. \r\nEn cerdos: Micoplasmosis, salmonelosis, colibacilosis, \r\ncolienterotoxemia, \r\ndiarreas \r\nbacterianas, \r\nbronconeumonía, neumonía ezootica, erisipela, cistitis, \r\npielonefritis, rinitis atrófica y complejo MMA. ',21,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56adb415d9c.pdf','','active','c49259-8f062d-eb8965bf',14,'2026-07-14 21:44:20','2026-07-14 21:53:47'),
(22,'FICHA TECNICA PLEUROFOS ORAL','PLEUROFOS está indicado para controlar \r\ninfecciones \r\nprovocadas \r\npor \r\ngérmenes \r\nsensibles a la Fosfomicina sódica.  \r\nLa fosfomicina actúa inhibiendo uno de los \r\nprimeros pasos en la síntesis de precursores de \r\npeptidoglucanos, componente principal de la \r\npared celular bacteriana. El trimetoprim es un \r\nantagonista sintético del ácido fólico que inhibe \r\nla síntesis de timidina, bloquea la conversión de \r\nácido dihidrofólico. ',22,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56af50d4cf5.pdf',NULL,'active','36a021-d744c3-ccb483e3',14,'2026-07-14 21:51:12','2026-07-14 21:51:12'),
(23,'FICHA TECNICA RESPIFREE AE','Soporte respiratorio para \r\nsituaciones de estrés o riesgo de enfermedades \r\nrespiratorias en los animales. Gracias a sus \r\naceites esenciales que poseen acción \r\nexpectorante y descongestionante de las vías \r\naéreas, efecto refrescante o de enfriamiento que \r\nayuda a aliviar el estrés por calor (heat stress, y \r\nun efecto calmante del tracto respiratorio que \r\nmitiga las reacciones post-vacunales.',23,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56bd0ccc353.pdf','','active','27d67f-e0678f-38bd56d3',14,'2026-07-14 22:49:48','2026-07-14 23:19:23'),
(26,'FICHA TECNICA SPEKTOR B','SPEKTOR B - coadyuvante en todas las \r\nenfermedades respiratorias, severas, agudas o \r\ncrónicas, que cursen con secreción de moco y \r\ncon aumento de su viscosidad. ',24,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56c2fb41c27.pdf','','active','2082dc-12e4f5-effaf5f5',14,'2026-07-14 23:15:07','2026-07-14 23:16:57'),
(28,'FICHA TECNICA SPEKTOR','Coadyuvante en todas las \r\nenfermedades respiratorias, severas, agudas o \r\ncrónicas, que cursen con secreción de moco y \r\ncon aumento de su viscosidad. ',25,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56c8252cd0a.pdf',NULL,'active','4255eb-993c76-194c26aa',14,'2026-07-14 23:37:09','2026-07-14 23:37:09'),
(29,'FICHA TECNICA SULFIKAR ps','Antibiótico indicado para \r\ntratar infecciones complejas, por su combinación \r\núnica \r\nde Sulfametoxazol, Trimetoprim, y \r\nNorfloxacina, se obtiene un efecto sinérgico de gran \r\nalcance, cuya biodisponibilidad y alta eficacia están \r\ngarantizadas. Esta formulación exhibe propiedades \r\nbactericidas con mínima toxicidad, de tal manera \r\nque se logra una acción rápida y eficaz. ',26,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56c925522d2.pdf',NULL,'active','dbc7af-a8de5d-6792fb64',14,'2026-07-14 23:41:25','2026-07-14 23:41:25'),
(30,'TILVASAN ps','TILVASAN con su potente efecto, logra su acción bactericida \r\nen una mínima concentración y en un periodo menor de tiempo. \r\nPosee un potente efecto micoplasmicida, el cual es 10 veces mayor al de la Tilosina. ',27,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56cbe38ebf6.pdf',NULL,'active','0c1250-d8a852-cdfb6450',14,'2026-07-14 23:53:07','2026-07-14 23:53:07'),
(31,'FICHA TECNICA TYLVASAN 5% pmx','TILVASAN 5% pmx con su potente efecto, \r\nlogra su acción bactericida en una mínima \r\nconcentración y en un periodo menor de tiempo. \r\nPosee un potente efecto antibacteriano, el cual \r\nes 10 veces mayor al de la Tilosina. ',28,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56cc7c60da8.pdf',NULL,'active','0e8208-504a27-901d9db8',14,'2026-07-14 23:55:40','2026-07-14 23:55:40'),
(32,'FICHA TECNICA AVIMOX-NOR 15 ps','AVIMOX-NOR Polvo Soluble Oral,  \r\nRecomendado para tratar enfermedad respiratoria \r\ncrónica (ERC), micoplasmosis, colibacilosis, \r\nsalmonelosis o coriza entre otras. Cerdos con \r\nneumonía enzoótica, rinitis atrófica y otros procesos \r\nrespiratorios-digestivos. Su fórmula une amoxicilina \r\ntrihidrato (penicilina de amplio espectro y alta \r\nbiodisponibilidad) con norfloxacina nicotinato \r\n(fluoroquinolona que bloquea la ADN-girasa \r\nbacteriana), ofreciendo una acción antibacteriana',29,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56cd8c5d99a.pdf',NULL,'active','624a01-85472b-11990813',14,'2026-07-15 00:00:12','2026-07-15 00:00:12'),
(33,'FICHA TECNICA AVIMOX-NOR ps','AVIMOX-NOR Polvo Soluble Oral,  \r\nRecomendado para tratar enfermedad respiratoria \r\ncrónica (ERC), micoplasmosis, colibacilosis, \r\nsalmonelosis o coriza entre otras. Cerdos con \r\nneumonía enzoótica, rinitis atrófica y otros procesos \r\nrespiratorios-digestivos. Su fórmula une amoxicilina \r\ntrihidrato (penicilina de amplio espectro y alta \r\nbiodisponibilidad) con norfloxacina nicotinato \r\n(fluoroquinolona que bloquea la ADN-girrasa \r\nbacteriana), ofreciendo una acción antibacteriana ',30,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a56ce61698a6.pdf',NULL,'active','4bf6e6-782ee9-8622d24f',14,'2026-07-15 00:03:45','2026-07-15 00:03:45'),
(37,'RESPIFREE BROSHURE TECNICO','RESPIFREE   AE SUPLEMENTO RESPIRATORIO INDICADO PARA PROBLEMAS RESPIRATORIOS, SOPORTE POSTVACUNACIÓN Y ESTRÉS CALÓRICO.',23,'pdf','/home/italvettools/back.italvettools.com/storage/materials/material_pdf_6a5e5e3a7be2c.pdf','','active','32fe64-9e915e-1af15473',14,'2026-07-20 17:43:23','2026-07-20 17:47:36');
/*!40000 ALTER TABLE `technical_materials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_invitations`
--

DROP TABLE IF EXISTS `user_invitations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_invitations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(200) NOT NULL,
  `token` varchar(255) NOT NULL,
  `role` enum('super_admin','comercial_manager') NOT NULL,
  `invited_by` int(11) NOT NULL,
  `status` enum('pendiente','aceptada','expirada') NOT NULL DEFAULT 'pendiente',
  `expires_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`),
  KEY `invited_by` (`invited_by`),
  CONSTRAINT `user_invitations_ibfk_1` FOREIGN KEY (`invited_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_invitations`
--

LOCK TABLES `user_invitations` WRITE;
/*!40000 ALTER TABLE `user_invitations` DISABLE KEYS */;
INSERT INTO `user_invitations` VALUES
(1,'nextboost53@gmail.com','233fbef04cd9358751a6d870c960855d0f6b9ef99cb4ebb9a8d8db2743ba1939','comercial_manager',1,'expirada','2026-07-09 19:38:29','2026-07-08 19:38:29'),
(2,'nextboost53@gmail.com','89a4948ab10bfb5e6dc1d5889a46382d44607ba1a8424d8482933b93d1dd2a9b','comercial_manager',1,'expirada','2026-07-09 20:10:02','2026-07-08 20:10:02'),
(3,'erivera@italvetsac.com','e77503e02061a289650e195572aea63bc5b28bb478c2993ebdd4da0ecb73665f','comercial_manager',1,'expirada','2026-07-10 18:23:40','2026-07-09 18:23:40'),
(4,'erivera@italvetsac.com','f49a78d3f7273c90ddd5cd386f6376822f5b71b5b3898419e94ae944e1291d74','comercial_manager',1,'expirada','2026-07-11 18:08:50','2026-07-10 18:08:50'),
(5,'nextboost53@gmail.com','baa7857fe7661e57d6d5dde0c51fbd3485beceda0250f8456ba097e6a94e0626','comercial_manager',1,'expirada','2026-07-11 18:09:18','2026-07-10 18:09:18'),
(6,'nextboost53@gmail.com','2a96478de25d267374ed4cb814281e3cc26e51e3097a2ac28f1baa452238402e','comercial_manager',1,'expirada','2026-07-11 18:10:18','2026-07-10 18:10:18'),
(7,'nextboost53@gmail.com','fce9c493b9f9f69e1c6c1243fe6f829ee5373dc12f9d1682ea4687ff98691a84','comercial_manager',1,'expirada','2026-07-11 18:10:21','2026-07-10 18:10:21'),
(8,'nextboost53@gmail.com','8a2c88776bcefadceb97a9731dc0a697ba2d57899bcf45aa36832837ac780e49','comercial_manager',1,'expirada','2026-07-11 18:10:50','2026-07-10 18:10:50'),
(9,'nextboost53@gmail.com','e2b10dbe723e489f99aa1fa6d723e6f92373bbc171671b1554c76fa7dd130082','comercial_manager',1,'expirada','2026-07-12 14:50:54','2026-07-11 14:50:54'),
(10,'nextboost53@gmail.com','2eeca4151271e3271e037e973f600bd04af24fec2043ad4204c3c0dee9d8baa7','comercial_manager',1,'expirada','2026-07-12 14:51:33','2026-07-11 14:51:33'),
(11,'nextboost53@gmail.com','a7ff1841e273d0a3e4b7150e03113c2b030b34b31bc94a27d097672c73d18b77','comercial_manager',1,'expirada','2026-07-12 14:53:12','2026-07-11 14:53:12'),
(12,'nextboost53@gmail.com','9901b1703bf2586ac0f6723a58381d624dd1ae9ecbad18caa4e2262acd9d3bb8','comercial_manager',1,'expirada','2026-07-12 14:58:25','2026-07-11 14:58:25'),
(13,'erivera@italvetsac.com','5d2b57dbb3b63ea6b8b7172bc8abc9963434228c4df9c8c92ccfe33cb5feff73','comercial_manager',1,'expirada','2026-07-15 15:08:20','2026-07-14 15:08:20'),
(14,'erivera@italvetsac.com','3724c718bad3dbed6abd947ed33632570f522a1793225e809616f82cbd96be1e','comercial_manager',1,'expirada','2026-07-15 15:08:27','2026-07-14 15:08:27'),
(15,'s.pozo.ventas@italvetsac.com','defd2a21e032169d350cd0ffc4041d0a8ad15289f826afc74526958973e477f0','comercial_manager',1,'expirada','2026-07-15 15:09:43','2026-07-14 15:09:43'),
(16,'s.pozo.ventas@italvetsac.com','1da7cc8d7ef2b7844fbf58ad89ecdaddabd9dbbd9c3ea9a41f63c2a1482d3558','comercial_manager',1,'expirada','2026-07-15 15:09:48','2026-07-14 15:09:48'),
(17,'bdelacruz654@gmail.com','a322aec295a5424c0b8d1399c4b5ce6f9b6eb0112d3590186ebedb4529efa2a1','comercial_manager',1,'expirada','2026-07-15 15:54:51','2026-07-14 15:54:51'),
(18,'lilianamkt@italvetsac.com','87518c229f0addc7b3c8a37c43975fac06d71c338452808277339b5e2c4afeaa','super_admin',1,'expirada','2026-07-15 16:46:04','2026-07-14 16:46:04'),
(19,'s.pozo.ventas@italvetsac.com','0036e93d923325b9e1466f2651429abf27003138db2ac2c14435e576e5f69ad7','comercial_manager',14,'expirada','2026-08-04 21:40:52','2026-08-03 21:40:52'),
(20,'s.pozo.ventas@italvetsac.com','4ea18bf5dca1d700d32556a1bbb2229da46eb199bdbc70385e896127076bee64','comercial_manager',14,'expirada','2026-08-05 14:47:15','2026-08-04 14:47:15'),
(21,'s.pozo.ventas@italvetsac.com','9360b8d9672076a1b4a40095c30ebbfaf567120b13d8ce4b5191967e55d38342','comercial_manager',14,'expirada','2026-08-05 14:47:20','2026-08-04 14:47:20');
/*!40000 ALTER TABLE `user_invitations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `email` varchar(200) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('super_admin','comercial_manager') NOT NULL DEFAULT 'comercial_manager',
  `status` enum('pending_activation','active','inactive') NOT NULL DEFAULT 'pending_activation',
  `current_event_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'Super Administrador','admin@italvet.com','$2y$10$XTmLzR1.cSKQp0mOFH7gLOTSsQHF2BlMYZGaWst608rjvPMGEf0NG','super_admin','active',NULL,'2026-06-16 05:28:14','2026-06-24 20:02:49'),
(11,'ESTEBAN RIVERA','erivera@italvetsac.com','$2y$10$TJkCNuB3Y4DducHXCYqP.OrbZzkZmxEW1B7gyHapiItWsH.PtalAO','comercial_manager','active',NULL,'2026-07-14 15:08:20','2026-07-14 22:18:51'),
(13,'Bryan de la cruz','bdelacruz654@gmail.com','$2y$10$aJECqzPk8OKMcjjhHYa3wuRsl.PjkJXGyjBLHfhvEHCzEI0sNsic.','comercial_manager','active',NULL,'2026-07-14 15:54:51','2026-07-30 22:58:05'),
(14,'Liliana','lilianamkt@italvetsac.com','$2y$10$9S/yPjYQvV/ony3faDOKyeNOSUkUVOr8dpGqKn2NVtb0M7QADireC','super_admin','active',NULL,'2026-07-14 16:46:04','2026-07-14 16:47:51'),
(15,'SUSAN POZO','s.pozo.ventas@italvetsac.com','$2y$10$qF6Cn/Cc96erd18HeDG/A.sBerJgqY7XegbSSF9li6OBmEyCfwClS','comercial_manager','active',10,'2026-08-04 14:47:15','2026-08-04 16:35:05');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `whatsapp_templates`
--

DROP TABLE IF EXISTS `whatsapp_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `whatsapp_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `variables` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`variables`)),
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `whatsapp_templates_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `whatsapp_templates`
--

LOCK TABLES `whatsapp_templates` WRITE;
/*!40000 ALTER TABLE `whatsapp_templates` DISABLE KEYS */;
INSERT INTO `whatsapp_templates` VALUES
(1,'Saludo v2','Hola {nombre}!','[\"nombre\"]','active',1,'2026-06-17 04:36:04','2026-06-17 04:36:08'),
(3,'Saludo Profesional','Hola {nombre}, un gusto saludarte. Soy {asesor} de Italvet. Gracias por visitarnos en {evento}. Quedo atento para ayudarte con una recomendacion para {producto}.','[\"nombre\", \"asesor\", \"evento\", \"producto\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(4,'Seguimiento 24 Horas','Hola {nombre}, ayer conversamos sobre {producto}. Te comparto esta opcion para tu negocio en {empresa}. Si deseas, hoy coordinamos una llamada de 10 minutos.','[\"nombre\", \"producto\", \"empresa\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(5,'Envio de Cotizacion','Estimado/a {nombre}, adjunto la cotizacion de {producto} solicitada para {empresa}. Cualquier ajuste de volumen o presentacion lo revisamos de inmediato.','[\"nombre\", \"producto\", \"empresa\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(6,'Recordatorio de Reunion','Hola {nombre}, te recuerdo nuestra reunion de hoy a las {hora}. Revisaremos {tema} para avanzar con la propuesta de {empresa}.','[\"nombre\", \"hora\", \"tema\", \"empresa\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(7,'Reactivacion Lead Frio','Hola {nombre}, espero que estes muy bien. Retomo contacto porque tenemos una nueva alternativa de {producto} que podria ayudarte en {empresa}. Te cuento en breve si gustas.','[\"nombre\", \"producto\", \"empresa\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(8,'Confirmacion de Pedido','Perfecto {nombre}, confirmamos tu pedido de {producto} para {empresa}. Fecha estimada de entrega: {fecha_entrega}. Te mantengo informado del despacho.','[\"nombre\", \"producto\", \"empresa\", \"fecha_entrega\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(9,'Post Venta','Hola {nombre}, queria validar como te fue con {producto}. Tu feedback nos ayuda a recomendarte el siguiente paso para mejorar resultados en {empresa}.','[\"nombre\", \"producto\", \"empresa\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(10,'Invitacion a Capacitacion','Hola {nombre}, te invitamos a nuestra capacitacion de {tema} el {fecha}. Sera una excelente oportunidad para optimizar el uso de {producto}. Te reservo un cupo?','[\"nombre\", \"tema\", \"fecha\", \"producto\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(11,'Promocion Vigente','Hola {nombre}, te comparto una promocion vigente de {producto} para clientes de {empresa} hasta el {fecha_fin}. Si deseas, te envio el detalle ahora mismo.','[\"nombre\", \"producto\", \"empresa\", \"fecha_fin\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56'),
(12,'Cierre Amable','Gracias por tu tiempo, {nombre}. Quedo atento a cualquier consulta sobre {producto}. Cuando te convenga, retomamos para cerrar la mejor opcion para {empresa}.','[\"nombre\", \"producto\", \"empresa\"]','active',1,'2026-07-08 15:55:56','2026-07-08 15:55:56');
/*!40000 ALTER TABLE `whatsapp_templates` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-24 10:57:46