-- MySQL dump 10.13  Distrib 5.7.33, for Linux (i686)
--
-- Host: localhost    Database: galaview
-- ------------------------------------------------------
-- Server version	5.7.33-0ubuntu0.16.04.1

/*!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 utf8 */;
/*!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 `app_settings`
--

DROP TABLE IF EXISTS `app_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `app_settings` (
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`setting_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `app_settings`
--

LOCK TABLES `app_settings` WRITE;
/*!40000 ALTER TABLE `app_settings` DISABLE KEYS */;
INSERT INTO `app_settings` VALUES ('hide_credit_line','1','2026-03-21 07:40:55'),('hide_zero_commission_vendors','1','2026-03-21 07:40:55'),('hide_zero_commission_vendors_filters','1','2026-03-21 07:40:55');
/*!40000 ALTER TABLE `app_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `app_users`
--

DROP TABLE IF EXISTS `app_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `app_users` (
  `employee_id` int(10) unsigned NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `permissions_json` longtext,
  `last_login_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `app_users`
--

LOCK TABLES `app_users` WRITE;
/*!40000 ALTER TABLE `app_users` DISABLE KEYS */;
INSERT INTO `app_users` VALUES (1,'admin','Peter Abboud',1,0,'{\"dashboard.view\":1,\"dashboard.box_sales_count\":1,\"dashboard.box_sales_total\":1,\"dashboard.box_payments_total\":1,\"dashboard.box_outstanding_balance\":1,\"dashboard.box_outstanding_invoices\":1,\"dashboard.box_customers_with_balance\":1,\"dashboard.box_average_invoice\":1,\"dashboard.box_vendors_count\":1,\"dashboard.box_pending_verification\":1,\"dashboard.box_pending_commission\":1,\"dashboard.box_movements_link\":1,\"dashboard.vendor_movements_list\":1,\"usuarios.view\":1,\"vendedores.view\":1,\"vendedores.dashboard.view\":1,\"vendedores.comisiones.view\":1,\"vendedores.pagos.view\":1,\"vendedores.pagos_comision.view\":1,\"vendedores.pagos_comision.verify_button\":1,\"vendedores.facturas_pendientes.view\":1,\"vendedores.facturas_pendientes.action_button\":1,\"vendedores.facturas_pendientes.ignored_section\":1,\"vendedores.movimientos.view\":1,\"vendedores.movimientos.ignore_button\":1,\"vendedores.movimientos.add_advance_button\":1,\"vendedores.movimientos.edit_advance_button\":1,\"vendedores.movimientos.delete_advance_button\":1,\"vendedores.movimientos.close_period_button\":1,\"configuracion.view\":1,\"configuracion.app.view\":1,\"configuracion.comisiones.view\":1,\"configuracion.usuarios.view\":1,\"configuracion.migracion.view\":0}','2026-04-18 14:20:33','2026-04-18 18:20:33'),(2,'buceina','Buceina Abboud',1,0,'{\"dashboard.view\":1,\"dashboard.box_sales_count\":1,\"dashboard.box_sales_total\":1,\"dashboard.box_payments_total\":1,\"dashboard.box_outstanding_balance\":1,\"dashboard.box_outstanding_invoices\":1,\"dashboard.box_customers_with_balance\":1,\"dashboard.box_average_invoice\":1,\"dashboard.box_vendors_count\":1,\"dashboard.box_pending_verification\":1,\"dashboard.box_pending_commission\":1,\"dashboard.box_movements_link\":1,\"dashboard.vendor_movements_list\":1,\"usuarios.view\":1,\"vendedores.view\":1,\"vendedores.dashboard.view\":1,\"vendedores.comisiones.view\":1,\"vendedores.pagos.view\":1,\"vendedores.pagos_comision.view\":1,\"vendedores.pagos_comision.verify_button\":0,\"vendedores.facturas_pendientes.view\":1,\"vendedores.facturas_pendientes.action_button\":0,\"vendedores.facturas_pendientes.ignored_section\":0,\"vendedores.movimientos.view\":1,\"vendedores.movimientos.ignore_button\":0,\"vendedores.movimientos.add_advance_button\":0,\"vendedores.movimientos.edit_advance_button\":0,\"vendedores.movimientos.delete_advance_button\":0,\"vendedores.movimientos.close_period_button\":0,\"configuracion.view\":1,\"configuracion.app.view\":0,\"configuracion.comisiones.view\":1,\"configuracion.usuarios.view\":0,\"configuracion.migracion.view\":0}',NULL,'2026-03-21 18:14:55'),(7,'jose','Jose Manuel Reyes',0,0,NULL,NULL,'2026-03-21 18:14:55'),(32,'qwe','Jesus Marcano Abu tannous',0,0,NULL,NULL,'2026-03-21 18:14:55'),(74,'nicole','Nicole Alfonzo',1,0,'{\"dashboard.view\":0,\"dashboard.box_sales_count\":0,\"dashboard.box_sales_total\":0,\"dashboard.box_payments_total\":0,\"dashboard.box_outstanding_balance\":0,\"dashboard.box_outstanding_invoices\":0,\"dashboard.box_customers_with_balance\":0,\"dashboard.box_average_invoice\":0,\"dashboard.box_vendors_count\":0,\"dashboard.box_pending_verification\":0,\"dashboard.box_pending_commission\":0,\"dashboard.box_movements_link\":0,\"dashboard.vendor_movements_list\":0,\"usuarios.view\":0,\"vendedores.view\":1,\"vendedores.dashboard.view\":0,\"vendedores.comisiones.view\":0,\"vendedores.pagos.view\":0,\"vendedores.pagos_comision.view\":0,\"vendedores.pagos_comision.verify_button\":0,\"vendedores.facturas_pendientes.view\":1,\"vendedores.facturas_pendientes.action_button\":0,\"vendedores.facturas_pendientes.ignored_section\":0,\"vendedores.movimientos.view\":0,\"vendedores.movimientos.ignore_button\":0,\"vendedores.movimientos.add_advance_button\":0,\"vendedores.movimientos.edit_advance_button\":0,\"vendedores.movimientos.delete_advance_button\":0,\"vendedores.movimientos.close_period_button\":0,\"configuracion.view\":0,\"configuracion.app.view\":0,\"configuracion.comisiones.view\":0,\"configuracion.usuarios.view\":0,\"configuracion.migracion.view\":0}','2026-04-11 11:43:15','2026-04-11 15:43:15'),(78,'fsdghsfd','Jorge Savedra',0,0,NULL,NULL,'2026-03-21 18:14:55'),(80,'fdtgh','Julio Cesar Torres',0,0,NULL,NULL,'2026-03-21 18:14:55'),(91,'luis','Luis Rujano',0,0,NULL,NULL,'2026-03-21 18:14:55');
/*!40000 ALTER TABLE `app_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `commission_payment_states`
--

DROP TABLE IF EXISTS `commission_payment_states`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `commission_payment_states` (
  `payment_id` int(10) unsigned NOT NULL,
  `vendor_id` int(10) unsigned DEFAULT NULL,
  `sale_id` int(10) unsigned DEFAULT NULL,
  `payment_amount` decimal(15,2) DEFAULT NULL,
  `is_verified` tinyint(1) NOT NULL DEFAULT '0',
  `is_paid` tinyint(1) NOT NULL DEFAULT '0',
  `is_ignored` tinyint(1) NOT NULL DEFAULT '0',
  `closed_period_id` int(10) unsigned DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `commission_payment_states`
--

LOCK TABLES `commission_payment_states` WRITE;
/*!40000 ALTER TABLE `commission_payment_states` DISABLE KEYS */;
INSERT INTO `commission_payment_states` VALUES (13,7,18,400.00,1,1,0,2,'2026-03-21 17:01:13'),(14,7,18,71.00,1,1,0,2,'2026-03-21 17:01:13'),(17,7,21,404.00,1,1,0,2,'2026-03-21 17:01:13'),(18,7,22,440.00,1,1,0,2,'2026-03-21 17:01:13'),(19,7,23,218.00,1,1,0,2,'2026-03-21 17:01:13'),(20,7,24,175.00,1,1,0,2,'2026-03-21 17:01:13'),(21,7,25,350.00,1,1,0,2,'2026-03-21 17:01:13'),(22,7,26,183.00,1,1,0,2,'2026-03-21 17:01:13'),(23,7,27,400.00,1,1,0,2,'2026-03-21 17:01:13'),(24,7,28,100.00,1,1,0,2,'2026-03-21 17:01:13'),(25,7,29,251.00,1,1,0,2,'2026-03-21 17:01:13'),(27,7,31,168.00,1,1,0,2,'2026-03-21 17:01:13'),(28,7,32,625.00,1,1,0,2,'2026-03-21 17:01:13'),(29,7,33,195.00,1,1,0,2,'2026-03-21 17:01:13'),(34,7,38,200.00,1,1,0,2,'2026-03-21 17:01:13'),(35,7,39,285.00,1,1,0,2,'2026-03-21 17:01:13'),(36,7,40,470.00,1,1,0,2,'2026-03-21 17:01:13'),(37,7,41,230.00,1,1,0,2,'2026-03-21 17:01:13'),(39,7,43,8.00,1,1,0,2,'2026-03-21 17:01:13'),(40,7,44,500.00,1,1,0,2,'2026-03-21 17:01:13'),(47,7,50,300.00,1,1,0,2,'2026-03-21 17:01:13'),(48,7,51,270.00,1,1,0,2,'2026-03-21 17:01:13'),(49,7,52,55.00,1,1,0,2,'2026-03-21 17:01:13'),(55,7,57,100.00,1,1,0,2,'2026-03-21 17:01:13'),(64,7,64,60.00,1,1,0,2,'2026-03-21 17:01:13'),(66,7,66,60.00,1,1,0,2,'2026-03-21 17:01:13'),(67,7,67,400.00,1,1,0,2,'2026-03-21 17:01:13'),(68,7,67,40.00,1,1,0,2,'2026-03-21 17:01:13'),(69,7,68,440.00,1,1,0,2,'2026-03-21 17:01:13'),(70,7,69,350.00,1,1,0,2,'2026-03-21 17:01:13'),(73,7,72,342.00,1,1,0,4,'2026-03-21 18:49:45'),(74,7,73,1000.00,1,1,0,4,'2026-03-21 18:49:45'),(75,7,74,110.00,1,1,0,4,'2026-03-21 18:49:45'),(76,7,75,415.00,1,1,0,4,'2026-03-21 18:49:45'),(77,7,75,47.00,1,1,0,4,'2026-03-21 18:49:45'),(78,7,76,288.00,1,1,0,4,'2026-03-21 18:49:45'),(79,7,77,270.00,1,1,0,2,'2026-03-21 17:01:13'),(80,7,78,300.00,1,1,0,2,'2026-03-21 17:01:13'),(81,7,79,220.00,1,1,0,2,'2026-03-21 17:01:13'),(84,7,82,173.00,1,1,0,4,'2026-03-21 18:49:45'),(85,7,83,188.00,1,1,0,4,'2026-03-21 18:49:45'),(86,7,84,105.00,1,1,0,4,'2026-03-21 18:49:45'),(92,7,90,324.00,1,1,0,4,'2026-03-21 18:49:45'),(93,7,90,36.00,1,1,0,4,'2026-03-21 18:49:45'),(107,1,105,100.00,0,0,0,NULL,'2026-03-21 17:02:02'),(108,1,106,320.00,0,0,0,NULL,'2026-03-21 17:02:00'),(109,1,106,52.00,0,0,0,NULL,'2026-03-21 17:01:59'),(110,7,107,200.00,1,1,0,4,'2026-03-21 18:49:45'),(111,1,108,1320.00,0,0,0,NULL,'2026-03-21 17:02:01'),(112,7,109,160.00,1,1,0,4,'2026-03-21 18:49:45'),(119,1,115,300.00,0,0,0,NULL,'2026-03-21 17:01:55'),(120,1,116,400.00,0,0,0,NULL,'2026-03-21 17:01:55'),(121,1,117,200.00,0,0,0,NULL,'2026-03-21 17:01:54'),(131,32,127,50.00,1,1,0,1,'2026-03-21 16:55:32'),(132,7,128,160.00,1,1,0,4,'2026-03-21 18:49:45'),(140,7,137,270.00,1,1,0,4,'2026-03-21 18:49:45'),(141,32,138,180.00,1,1,0,1,'2026-03-21 16:55:32'),(143,7,140,366.00,1,1,0,4,'2026-03-21 18:49:45'),(144,7,140,65.00,1,1,0,4,'2026-03-21 18:49:45'),(145,7,141,800.00,1,1,0,4,'2026-03-21 18:49:45'),(146,7,142,78.00,1,1,0,4,'2026-03-21 18:49:45'),(150,7,146,100.00,1,1,0,4,'2026-03-21 18:49:45'),(151,7,147,203.00,1,1,0,4,'2026-03-21 18:49:45'),(152,7,148,240.50,1,1,0,4,'2026-03-21 18:49:45'),(157,7,153,600.00,1,1,0,4,'2026-03-21 18:49:45'),(158,7,154,150.00,1,1,0,4,'2026-03-21 18:49:45'),(159,32,155,100.00,1,1,0,1,'2026-03-21 16:55:32'),(160,32,156,34.00,1,1,0,1,'2026-03-21 16:55:32'),(161,32,157,116.00,1,1,0,1,'2026-03-21 16:55:32'),(162,32,158,50.00,1,1,0,1,'2026-03-21 16:55:32'),(163,32,159,50.00,1,1,0,1,'2026-03-21 16:55:32'),(164,32,160,40.00,1,1,0,1,'2026-03-21 16:55:32'),(165,7,161,240.00,1,1,0,4,'2026-03-21 18:49:45'),(166,7,162,100.00,1,1,0,4,'2026-03-21 18:49:45'),(167,7,163,120.00,1,1,0,4,'2026-03-21 18:49:45'),(169,7,165,150.00,1,1,0,4,'2026-03-21 18:49:45'),(170,7,165,5.00,1,1,0,4,'2026-03-21 18:49:45'),(172,7,167,703.00,1,1,0,4,'2026-03-21 18:49:45'),(173,7,167,79.00,1,1,0,4,'2026-03-21 18:49:45'),(180,7,174,100.00,1,1,0,4,'2026-03-21 18:49:45'),(181,7,174,403.00,1,1,0,4,'2026-03-21 18:49:45'),(184,7,177,-80.00,1,1,0,4,'2026-03-21 18:49:45'),(186,32,179,75.00,1,1,0,1,'2026-03-21 16:55:32'),(187,7,180,225.00,1,1,0,4,'2026-03-21 18:49:45'),(188,7,181,105.50,1,1,0,4,'2026-03-21 18:49:45'),(189,7,182,300.00,1,1,0,4,'2026-03-21 18:49:45'),(190,7,183,274.50,1,1,0,4,'2026-03-21 18:49:45'),(191,7,184,160.50,1,1,0,4,'2026-03-21 18:49:45'),(192,7,185,65.00,1,1,0,4,'2026-03-21 18:49:45'),(193,7,186,210.00,1,1,0,4,'2026-03-21 18:49:45'),(194,7,187,235.00,1,1,0,4,'2026-03-21 18:49:45'),(196,32,189,260.00,1,1,0,1,'2026-03-21 16:55:32'),(197,7,190,32.00,1,1,0,4,'2026-03-21 18:49:45'),(198,7,191,168.00,1,1,0,4,'2026-03-21 18:49:45'),(199,7,191,493.50,1,1,0,4,'2026-03-21 18:49:45'),(206,1,198,297.00,0,0,0,NULL,'2026-03-21 17:01:57'),(207,1,198,33.00,0,0,0,NULL,'2026-03-21 17:01:58'),(230,7,219,208.00,1,1,0,4,'2026-03-21 18:49:45'),(231,7,220,275.00,1,1,0,4,'2026-03-21 18:49:45'),(238,7,227,318.00,1,1,0,4,'2026-03-21 18:49:45'),(239,7,227,36.00,1,1,0,4,'2026-03-21 18:49:45'),(270,7,236,200.00,1,1,0,4,'2026-03-21 18:49:45'),(273,7,239,76.00,1,1,0,4,'2026-03-21 18:49:45'),(274,7,239,120.00,1,1,0,4,'2026-03-21 18:49:45'),(277,7,242,275.00,1,1,0,4,'2026-03-21 18:49:45'),(278,7,243,350.00,1,1,0,4,'2026-03-21 18:49:45'),(279,7,244,300.00,1,1,0,4,'2026-03-21 18:49:45'),(284,7,249,135.00,1,1,0,4,'2026-03-21 18:49:45'),(294,32,259,300.00,1,1,0,1,'2026-03-21 16:55:32'),(295,32,260,180.00,1,1,0,1,'2026-03-21 16:55:32'),(296,32,261,956.00,1,1,0,1,'2026-03-21 16:55:32'),(297,32,261,106.00,1,1,0,1,'2026-03-21 16:55:32'),(298,7,262,-300.00,1,1,0,4,'2026-03-21 18:49:45'),(299,32,263,300.00,1,1,0,1,'2026-03-21 16:55:32'),(300,32,264,400.00,1,1,0,1,'2026-03-21 16:55:32'),(311,7,274,1116.00,1,1,0,4,'2026-03-21 18:49:45'),(312,7,274,124.00,1,1,0,4,'2026-03-21 18:49:45'),(313,7,275,150.00,1,1,0,4,'2026-03-21 18:49:45'),(314,7,275,30.00,1,1,0,4,'2026-03-21 18:49:45'),(315,7,276,723.00,1,1,0,4,'2026-03-21 18:49:45'),(316,7,276,81.00,1,1,0,4,'2026-03-21 18:49:45'),(317,7,277,200.00,1,1,0,4,'2026-03-21 18:49:45'),(318,7,278,297.43,1,1,0,4,'2026-03-21 18:49:45'),(319,32,279,75.00,1,1,0,1,'2026-03-21 16:55:32'),(320,7,280,25.07,1,1,0,4,'2026-03-21 18:49:45'),(321,32,281,272.00,1,1,0,1,'2026-03-21 16:55:32'),(328,7,286,296.00,1,1,0,4,'2026-03-21 18:49:45'),(331,32,292,38.00,1,1,0,1,'2026-03-21 16:55:32'),(334,7,295,200.00,1,1,0,4,'2026-03-21 18:49:45'),(335,7,296,200.00,1,1,0,4,'2026-03-21 18:49:45'),(336,7,297,300.00,1,1,0,4,'2026-03-21 18:49:45'),(337,7,298,200.00,1,1,0,4,'2026-03-21 18:49:45'),(338,7,299,312.00,1,1,0,4,'2026-03-21 18:49:45'),(339,32,300,100.00,1,1,0,1,'2026-03-21 16:55:32'),(340,32,301,100.00,1,1,0,1,'2026-03-21 16:55:32'),(344,7,304,860.00,1,1,0,4,'2026-03-21 18:49:45'),(345,7,304,153.00,1,1,0,4,'2026-03-21 18:49:45'),(347,7,306,1272.00,1,1,0,4,'2026-03-21 18:49:45'),(348,7,307,90.50,1,1,0,4,'2026-03-21 18:49:45'),(349,7,308,100.00,1,1,0,4,'2026-03-21 18:49:45'),(350,7,309,328.00,1,1,0,4,'2026-03-21 18:49:45'),(351,7,310,311.00,1,1,0,4,'2026-03-21 18:49:45'),(352,32,311,100.00,1,1,0,1,'2026-03-21 16:55:32'),(358,32,317,-74.00,1,1,0,1,'2026-03-21 16:55:32'),(359,32,318,148.00,1,1,0,1,'2026-03-21 16:55:32'),(360,7,320,280.00,1,1,0,4,'2026-03-21 18:49:45'),(361,7,320,32.00,1,1,0,4,'2026-03-21 18:49:45'),(362,7,321,100.00,1,1,0,4,'2026-03-21 18:49:45'),(363,7,322,210.00,1,1,0,4,'2026-03-21 18:49:45'),(364,7,323,180.00,1,1,0,4,'2026-03-21 18:49:45'),(365,7,324,250.00,1,1,0,4,'2026-03-21 18:49:45'),(366,7,325,561.00,1,1,0,4,'2026-03-21 18:49:45'),(367,7,325,63.00,1,1,0,4,'2026-03-21 18:49:45'),(368,7,326,17.50,1,1,0,4,'2026-03-21 18:49:45'),(376,7,332,216.00,1,1,0,4,'2026-03-21 18:49:45'),(378,32,334,247.00,1,1,0,1,'2026-03-21 16:55:32'),(379,7,335,581.40,1,1,0,4,'2026-03-21 18:49:45'),(380,7,335,64.60,1,1,0,4,'2026-03-21 18:49:45'),(382,7,337,240.00,1,1,0,4,'2026-03-21 18:49:45'),(384,7,339,930.00,1,1,0,4,'2026-03-21 18:49:45'),(385,7,340,662.00,1,1,0,4,'2026-03-21 18:49:45'),(386,7,341,200.00,1,1,0,4,'2026-03-21 18:49:45'),(387,7,342,742.00,1,1,0,4,'2026-03-21 18:49:45'),(388,7,343,700.00,1,1,0,4,'2026-03-21 18:49:45'),(389,7,344,108.00,1,1,0,4,'2026-03-21 18:49:45'),(390,7,345,224.00,1,1,0,4,'2026-03-21 18:49:45'),(391,7,346,200.00,1,1,0,4,'2026-03-21 18:49:45'),(392,32,347,384.00,1,1,0,1,'2026-03-21 16:55:32'),(393,7,348,478.00,1,1,0,4,'2026-03-21 18:49:45'),(394,7,349,540.00,1,1,0,4,'2026-03-21 18:49:45'),(395,7,350,465.00,1,1,0,4,'2026-03-21 18:49:45'),(396,7,351,317.00,1,1,0,4,'2026-03-21 18:49:45'),(397,7,351,35.00,1,1,0,4,'2026-03-21 18:49:45'),(398,7,352,200.00,1,1,0,4,'2026-03-21 18:49:45'),(399,7,353,468.00,1,1,0,4,'2026-03-21 18:49:45'),(400,7,354,288.00,1,1,0,4,'2026-03-21 18:49:45'),(401,7,354,44.00,1,1,0,4,'2026-03-21 18:49:45'),(402,7,355,136.00,1,1,0,4,'2026-03-21 18:49:45'),(403,7,356,486.00,1,1,0,4,'2026-03-21 18:49:45'),(404,7,357,38.00,1,1,0,4,'2026-03-21 18:49:45'),(405,7,358,340.00,1,1,0,4,'2026-03-21 18:49:45'),(406,7,359,384.00,1,1,0,4,'2026-03-21 18:49:45'),(407,7,360,120.00,1,1,0,4,'2026-03-21 18:49:45'),(408,7,361,401.00,1,0,0,NULL,'2026-03-21 18:50:10'),(409,7,362,700.00,1,0,0,NULL,'2026-03-21 18:50:09'),(410,32,363,611.62,1,1,0,1,'2026-03-21 16:55:32'),(411,32,364,694.87,1,0,0,NULL,'2026-03-21 16:57:06'),(412,32,365,88.72,1,0,0,NULL,'2026-03-21 16:57:06'),(413,7,368,100.00,1,0,0,NULL,'2026-03-21 18:50:10'),(415,32,371,900.00,1,0,0,NULL,'2026-03-21 16:57:07'),(416,32,371,18.00,1,0,0,NULL,'2026-03-21 16:57:07'),(417,32,372,20.00,1,0,0,NULL,'2026-03-21 16:57:08'),(418,32,373,241.13,1,0,0,NULL,'2026-03-21 16:57:09'),(419,7,377,300.00,1,0,0,NULL,'2026-03-21 18:50:11'),(423,7,380,489.00,1,0,0,NULL,'2026-03-21 18:50:11'),(424,7,380,87.00,1,0,0,NULL,'2026-03-21 18:50:12'),(425,7,381,526.00,1,0,0,NULL,'2026-03-21 18:50:12'),(426,7,382,300.00,1,0,0,NULL,'2026-03-21 18:50:12'),(429,7,385,76.00,1,0,0,NULL,'2026-03-21 18:50:13'),(430,7,386,72.00,1,0,0,NULL,'2026-03-21 18:50:13'),(432,7,388,120.00,1,0,0,NULL,'2026-03-21 18:50:14'),(436,7,393,196.00,1,0,0,NULL,'2026-03-21 18:50:14'),(437,7,394,197.16,1,0,0,NULL,'2026-03-21 18:50:14'),(438,7,395,110.63,1,0,0,NULL,'2026-03-21 18:50:16'),(439,7,396,172.30,1,0,0,NULL,'2026-03-21 18:50:16'),(440,7,397,200.00,1,0,0,NULL,'2026-03-21 18:50:15'),(441,7,398,1206.00,1,0,0,NULL,'2026-03-21 18:50:17'),(442,7,398,134.00,1,0,0,NULL,'2026-03-21 18:50:17'),(443,7,399,340.00,1,0,0,NULL,'2026-03-21 18:50:18'),(444,7,399,62.00,1,0,0,NULL,'2026-03-21 18:50:18'),(450,32,401,230.00,1,0,0,NULL,'2026-03-21 16:57:16'),(453,7,407,100.00,1,0,0,NULL,'2026-03-21 18:50:19'),(454,7,408,37.50,1,0,0,NULL,'2026-03-21 18:50:19'),(458,7,416,100.00,1,0,0,NULL,'2026-03-21 18:50:20'),(461,32,419,200.00,1,0,0,NULL,'2026-03-21 16:57:17'),(465,32,423,216.00,1,0,0,NULL,'2026-03-21 16:57:18'),(466,7,424,90.37,1,0,0,NULL,'2026-03-21 18:50:22'),(467,7,425,10.63,1,0,0,NULL,'2026-03-21 18:50:20'),(470,7,430,100.00,1,0,0,NULL,'2026-03-21 18:50:22'),(471,32,431,154.92,1,0,0,NULL,'2026-03-21 16:57:18'),(476,32,440,193.61,1,0,0,NULL,'2026-03-21 16:57:19'),(480,7,443,255.98,1,0,0,NULL,'2026-03-21 18:50:22'),(481,32,444,206.39,1,0,0,NULL,'2026-03-21 16:57:19'),(482,7,446,288.00,1,0,0,NULL,'2026-03-21 18:50:23'),(484,7,450,100.00,1,0,0,NULL,'2026-03-21 18:50:23'),(485,7,453,280.00,1,0,0,NULL,'2026-03-21 18:50:24'),(486,32,454,231.68,1,0,0,NULL,'2026-03-21 16:57:20'),(490,7,456,100.00,1,0,0,NULL,'2026-03-21 18:50:24'),(491,7,457,252.00,1,0,0,NULL,'2026-03-21 18:50:24'),(492,7,463,396.00,1,0,0,NULL,'2026-03-21 18:50:26'),(493,7,464,200.00,1,0,0,NULL,'2026-03-21 18:50:26'),(494,7,466,123.00,1,0,0,NULL,'2026-03-21 18:50:27'),(495,32,467,200.00,1,0,0,NULL,'2026-03-21 16:57:21'),(496,7,468,100.00,1,0,0,NULL,'2026-03-21 18:50:26'),(497,7,469,176.50,1,0,0,NULL,'2026-03-21 18:50:27'),(523,80,474,404.00,1,0,0,NULL,'2026-03-21 16:58:50'),(524,7,475,250.00,1,0,0,NULL,'2026-03-21 18:50:27'),(525,7,477,405.00,1,0,0,NULL,'2026-03-21 18:50:28'),(526,80,478,417.00,1,0,0,NULL,'2026-03-21 16:58:51'),(527,80,479,622.00,1,0,0,NULL,'2026-03-21 16:58:52'),(528,80,480,32.00,1,0,0,NULL,'2026-03-21 16:58:51'),(529,7,482,100.00,1,0,0,NULL,'2026-03-21 18:50:28'),(530,32,483,240.00,1,0,0,NULL,'2026-03-21 16:57:22'),(531,32,484,277.00,1,0,0,NULL,'2026-03-21 16:57:22'),(532,32,485,130.00,1,1,0,1,'2026-03-21 16:55:32'),(533,32,486,40.00,1,0,0,NULL,'2026-03-21 16:57:23'),(536,32,490,200.00,1,0,0,NULL,'2026-03-21 16:57:23'),(537,7,491,270.00,1,0,0,NULL,'2026-03-21 18:50:28'),(538,7,492,250.00,1,0,0,NULL,'2026-03-21 18:50:29'),(540,80,495,400.00,1,0,0,NULL,'2026-03-21 16:58:52'),(541,7,496,135.00,1,0,0,NULL,'2026-03-21 18:50:30'),(542,7,496,15.00,1,0,0,NULL,'2026-03-21 18:50:31'),(543,7,497,60.00,1,0,0,NULL,'2026-03-21 18:50:31'),(544,7,501,500.00,1,0,0,NULL,'2026-03-21 18:50:32'),(545,7,502,54.00,1,0,0,NULL,'2026-03-21 18:50:31'),(550,32,505,240.00,1,0,0,NULL,'2026-03-21 16:57:24'),(551,80,506,200.00,1,0,0,NULL,'2026-03-21 16:58:53'),(552,7,507,723.35,1,0,0,NULL,'2026-03-21 18:50:32'),(553,80,512,200.00,1,0,0,NULL,'2026-03-21 16:58:54'),(554,7,513,349.00,1,0,0,NULL,'2026-03-21 18:50:32'),(558,7,516,1023.00,1,0,0,NULL,'2026-03-21 18:50:33'),(559,7,517,681.00,1,0,0,NULL,'2026-03-21 18:50:34'),(560,32,518,100.00,1,0,0,NULL,'2026-03-21 16:57:25'),(561,7,519,62.75,1,0,0,NULL,'2026-03-21 18:50:34'),(562,7,520,7.25,1,0,0,NULL,'2026-03-21 18:50:35'),(565,7,523,204.00,1,0,0,NULL,'2026-03-21 18:50:35'),(566,7,524,224.00,1,0,0,NULL,'2026-03-21 18:50:35'),(567,80,525,200.00,1,0,0,NULL,'2026-03-21 16:58:54'),(568,80,526,200.00,1,0,0,NULL,'2026-03-21 16:58:55'),(574,7,532,284.67,1,0,0,NULL,'2026-03-21 18:50:37'),(575,7,533,250.00,1,0,0,NULL,'2026-03-21 18:50:39'),(576,7,534,47.57,1,0,0,NULL,'2026-03-21 18:50:39'),(577,7,535,2.43,1,0,0,NULL,'2026-03-21 18:50:39'),(578,7,536,48.50,1,0,0,NULL,'2026-03-21 18:50:36'),(579,7,537,1.50,1,0,0,NULL,'2026-03-21 18:50:37'),(580,78,538,226.00,1,0,0,NULL,'2026-03-21 16:59:22'),(581,7,539,50.00,1,0,0,NULL,'2026-03-21 18:50:40'),(582,7,540,50.00,1,0,0,NULL,'2026-03-21 18:50:41'),(583,7,541,333.00,1,0,0,NULL,'2026-03-21 18:50:40'),(584,80,542,430.00,1,0,0,NULL,'2026-03-21 16:58:55'),(587,32,545,220.00,1,0,0,NULL,'2026-03-21 16:57:27'),(589,7,547,160.00,1,0,0,NULL,'2026-03-21 18:50:41'),(592,7,550,68.69,1,0,0,NULL,'2026-03-21 18:50:41'),(593,7,551,1.31,1,0,0,NULL,'2026-03-21 18:50:42'),(594,80,552,383.00,1,0,0,NULL,'2026-03-21 16:58:57'),(596,80,555,117.00,1,0,0,NULL,'2026-03-21 16:58:58'),(600,7,560,93.98,1,0,0,NULL,'2026-03-21 18:50:42'),(602,7,562,297.63,1,0,0,NULL,'2026-03-21 18:50:42'),(603,7,563,871.85,1,0,0,NULL,'2026-03-21 18:50:44'),(604,7,564,1500.00,1,0,0,NULL,'2026-03-21 18:50:49'),(607,7,567,335.50,1,0,0,NULL,'2026-03-21 18:50:44'),(608,7,568,198.00,1,0,0,NULL,'2026-03-21 18:50:44'),(609,7,569,720.00,1,0,0,NULL,'2026-03-21 18:50:45'),(610,32,570,60.00,1,0,0,NULL,'2026-03-21 16:57:28'),(611,80,571,500.00,1,0,0,NULL,'2026-03-21 16:58:59'),(612,7,572,86.73,1,0,0,NULL,'2026-03-21 18:50:47'),(613,7,573,185.42,1,0,0,NULL,'2026-03-21 18:50:46'),(620,7,582,345.00,1,0,0,NULL,'2026-03-21 18:50:47'),(627,7,589,284.00,1,0,0,NULL,'2026-03-21 18:50:48'),(628,32,590,12.00,1,0,0,NULL,'2026-03-21 16:57:28'),(630,7,592,100.00,1,0,0,NULL,'2026-03-21 18:50:50'),(631,7,594,500.00,1,0,0,NULL,'2026-03-21 18:50:48'),(634,7,598,540.00,1,0,0,NULL,'2026-03-21 18:50:50'),(642,7,608,231.00,1,0,0,NULL,'2026-03-21 18:50:52'),(643,7,608,99.00,1,0,0,NULL,'2026-03-21 18:50:52'),(644,80,609,210.00,1,0,0,NULL,'2026-03-21 16:58:55'),(645,7,610,358.00,1,0,0,NULL,'2026-03-21 18:50:51'),(646,7,611,80.00,1,0,0,NULL,'2026-03-21 18:50:51'),(647,32,612,100.00,1,0,0,NULL,'2026-03-21 16:57:29'),(648,7,613,80.37,1,0,0,NULL,'2026-03-21 18:50:51'),(653,7,618,188.00,1,0,0,NULL,'2026-03-21 18:50:52'),(657,7,623,500.00,1,0,0,NULL,'2026-03-21 18:50:54'),(658,7,624,100.00,1,0,0,NULL,'2026-03-21 18:50:53'),(660,7,626,596.00,1,0,0,NULL,'2026-03-21 18:50:54'),(662,32,628,242.03,1,0,0,NULL,'2026-03-21 16:57:30'),(663,32,629,141.00,1,0,0,NULL,'2026-03-21 16:57:31'),(664,78,630,240.00,1,0,0,NULL,'2026-03-21 16:59:24'),(668,32,634,126.00,1,0,0,NULL,'2026-03-21 16:57:31'),(669,7,635,362.50,1,0,0,NULL,'2026-03-21 18:50:55'),(670,91,637,676.00,1,1,0,3,'2026-03-21 18:45:52'),(671,7,638,804.00,1,0,0,NULL,'2026-03-21 18:50:55'),(672,80,639,109.00,1,0,0,NULL,'2026-03-21 16:58:59'),(673,32,640,50.00,1,0,0,NULL,'2026-03-21 16:57:31'),(674,32,641,100.00,1,0,0,NULL,'2026-03-21 16:57:33'),(677,7,644,307.33,1,0,0,NULL,'2026-03-21 18:50:55'),(678,7,645,143.08,1,0,0,NULL,'2026-03-21 18:50:56'),(679,7,646,501.00,1,0,0,NULL,'2026-03-21 18:50:56'),(680,32,647,50.00,1,0,0,NULL,'2026-03-21 16:57:32'),(681,32,648,75.00,1,0,0,NULL,'2026-03-21 16:57:34'),(682,80,649,30.37,1,0,0,NULL,'2026-03-21 16:59:00'),(683,78,650,640.00,1,0,0,NULL,'2026-03-21 16:59:25'),(684,7,651,308.00,1,0,0,NULL,'2026-03-21 18:50:57'),(685,7,652,831.00,1,0,0,NULL,'2026-03-21 18:50:57'),(686,7,654,297.00,1,0,0,NULL,'2026-03-21 18:50:56'),(687,78,655,84.00,1,0,0,NULL,'2026-03-21 16:59:25'),(688,32,656,75.00,1,0,0,NULL,'2026-03-21 16:57:34'),(690,7,659,448.00,1,0,0,NULL,'2026-03-21 18:51:00'),(691,7,660,352.00,1,0,0,NULL,'2026-03-21 18:50:59'),(692,7,661,496.00,1,0,0,NULL,'2026-03-21 18:50:59'),(693,7,662,511.00,1,0,0,NULL,'2026-03-21 18:50:57'),(694,7,663,685.52,1,0,0,NULL,'2026-03-21 18:51:00'),(695,7,664,400.00,1,0,0,NULL,'2026-03-21 19:29:28'),(696,32,665,70.00,0,0,0,NULL,'2026-03-21 19:29:39'),(697,32,666,70.00,1,0,0,NULL,'2026-03-21 16:57:35'),(698,32,667,123.55,1,0,0,NULL,'2026-03-21 18:46:27'),(699,7,668,450.00,1,0,0,NULL,'2026-03-21 19:29:53'),(702,7,671,1000.00,1,0,0,NULL,'2026-03-21 19:29:54'),(704,7,673,707.00,1,0,0,NULL,'2026-03-21 19:29:54'),(710,7,679,400.00,1,0,0,NULL,'2026-03-21 19:29:55'),(714,32,683,54.00,1,0,0,NULL,'2026-03-21 18:46:28'),(715,32,684,254.40,1,0,0,NULL,'2026-03-21 18:46:29'),(722,80,691,100.70,0,0,0,NULL,'2026-03-21 16:54:31'),(725,74,694,16.80,0,0,0,NULL,'2026-03-21 16:54:30'),(726,74,695,151.20,0,0,0,NULL,'2026-03-21 16:54:29'),(727,80,696,100.00,0,0,0,NULL,'2026-03-21 16:54:28'),(728,7,697,269.00,1,0,0,NULL,'2026-03-21 19:29:55'),(751,7,716,85.37,1,0,0,NULL,'2026-04-08 21:58:39'),(757,7,722,480.00,1,0,0,NULL,'2026-04-08 21:58:40');
/*!40000 ALTER TABLE `commission_payment_states` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee_commissions`
--

DROP TABLE IF EXISTS `employee_commissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee_commissions` (
  `employee_id` int(10) unsigned NOT NULL,
  `commission_percent` decimal(5,2) NOT NULL DEFAULT '0.00',
  `updated_at` timestamp NULL DEFAULT NULL,
  `show_in_reports` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee_commissions`
--

LOCK TABLES `employee_commissions` WRITE;
/*!40000 ALTER TABLE `employee_commissions` DISABLE KEYS */;
INSERT INTO `employee_commissions` VALUES (1,0.00,'2026-03-21 14:43:45',0),(2,0.00,'2026-03-21 14:43:45',0),(7,10.00,'2026-03-21 14:43:45',1),(32,10.00,'2026-03-21 14:43:45',1),(74,0.00,'2026-03-21 14:43:45',1),(78,10.00,'2026-03-21 14:43:45',1),(80,10.00,'2026-03-21 14:43:45',1),(91,10.00,'2026-03-21 14:43:45',1);
/*!40000 ALTER TABLE `employee_commissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pending_invoice_states`
--

DROP TABLE IF EXISTS `pending_invoice_states`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pending_invoice_states` (
  `sale_id` int(10) unsigned NOT NULL,
  `vendor_id` int(10) unsigned DEFAULT NULL,
  `assigned_vendor_id` int(10) unsigned DEFAULT NULL,
  `is_ignored` tinyint(1) NOT NULL DEFAULT '0',
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sale_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pending_invoice_states`
--

LOCK TABLES `pending_invoice_states` WRITE;
/*!40000 ALTER TABLE `pending_invoice_states` DISABLE KEYS */;
INSERT INTO `pending_invoice_states` VALUES (674,NULL,78,0,'2026-04-08 23:00:15');
/*!40000 ALTER TABLE `pending_invoice_states` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor_advances`
--

DROP TABLE IF EXISTS `vendor_advances`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vendor_advances` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` int(10) unsigned NOT NULL,
  `advance_date` date NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL,
  `settled_period_id` int(10) unsigned DEFAULT NULL,
  `is_carry_over` tinyint(1) NOT NULL DEFAULT '0',
  `created_from_period_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendor_advances`
--

LOCK TABLES `vendor_advances` WRITE;
/*!40000 ALTER TABLE `vendor_advances` DISABLE KEYS */;
INSERT INTO `vendor_advances` VALUES (3,32,'2025-04-12','PM',50.00,NULL,0,NULL,'2026-03-21 18:37:00','2026-03-21 18:37:00'),(4,32,'2025-05-18','PM',50.00,NULL,0,NULL,'2026-03-21 18:40:05','2026-03-21 18:40:05'),(5,32,'2025-06-27','PM',100.00,NULL,0,NULL,'2026-03-21 18:40:38','2026-03-21 18:40:38'),(6,32,'2025-10-23','PM',100.00,NULL,0,NULL,'2026-03-21 18:41:06','2026-03-21 18:41:06'),(7,32,'2025-10-23','DIVISA',100.00,NULL,0,NULL,'2026-03-21 18:41:37','2026-03-21 18:41:37'),(8,32,'2025-11-17','PM',100.00,NULL,0,NULL,'2026-03-21 18:42:03','2026-03-21 18:42:03'),(9,32,'2025-12-19','PM',100.00,NULL,0,NULL,'2026-03-21 18:42:26','2026-03-21 18:42:26'),(10,32,'2026-02-03','PM',50.00,NULL,0,NULL,'2026-03-21 18:47:15','2026-03-21 18:47:15'),(11,32,'2026-03-05','PM',50.00,NULL,0,NULL,'2026-03-21 18:47:33','2026-03-21 18:47:33'),(12,32,'2026-03-21','DIVISA',50.00,NULL,0,NULL,'2026-03-21 18:47:52','2026-03-21 18:47:52'),(13,7,'2025-01-13','PM',300.00,NULL,0,NULL,'2026-03-21 19:20:25','2026-03-21 19:20:25'),(14,7,'2025-01-17','PM',120.00,NULL,0,NULL,'2026-03-21 19:21:08','2026-03-21 19:21:08'),(16,7,'2025-01-29','PM',200.00,NULL,0,NULL,'2026-03-21 19:22:00','2026-03-21 19:22:00'),(17,7,'2025-02-19','ZELLE',50.00,NULL,0,NULL,'2026-03-21 19:22:34','2026-03-21 19:22:34'),(19,7,'2025-03-11','PM',150.00,NULL,0,NULL,'2026-03-21 19:23:26','2026-03-21 19:23:26'),(20,7,'2025-03-13','PM',150.00,NULL,0,NULL,'2026-03-21 19:23:57','2026-03-21 19:23:57'),(21,7,'2025-03-18','PM',140.00,NULL,0,NULL,'2026-03-21 19:24:18','2026-03-21 19:24:18'),(22,7,'2025-03-21','PM',100.00,NULL,0,NULL,'2026-03-21 19:24:46','2026-03-21 19:24:46'),(23,7,'2025-03-29','PM',100.00,NULL,0,NULL,'2026-03-21 19:25:15','2026-03-21 19:25:15'),(24,7,'2025-04-12','PM',160.00,NULL,0,NULL,'2026-03-21 19:25:35','2026-03-21 19:25:35'),(25,7,'2025-05-28','PM',500.00,NULL,0,NULL,'2026-03-21 19:26:00','2026-03-21 19:26:38'),(26,7,'2025-06-04','PM',500.00,NULL,0,NULL,'2026-03-21 19:26:56','2026-03-21 19:26:56'),(27,7,'2025-06-24','PM',150.00,NULL,0,NULL,'2026-03-21 19:27:25','2026-03-21 19:27:25'),(28,7,'2025-10-11','PM',700.00,NULL,0,NULL,'2026-03-21 19:28:02','2026-03-21 19:28:02'),(29,7,'2025-12-13','PM',100.00,NULL,0,NULL,'2026-03-21 19:28:20','2026-03-21 19:28:20'),(30,7,'2025-12-16','PM',200.00,NULL,0,NULL,'2026-03-21 19:28:43','2026-03-21 19:28:43'),(37,7,'2026-04-08','jose manuel cobro una factura y lo gasto',360.00,NULL,0,NULL,'2026-04-08 22:43:40','2026-04-08 22:43:40');
/*!40000 ALTER TABLE `vendor_advances` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor_period_closures`
--

DROP TABLE IF EXISTS `vendor_period_closures`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vendor_period_closures` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` int(10) unsigned NOT NULL,
  `period_start_date` date NOT NULL,
  `period_end_date` date NOT NULL,
  `payout_date` date DEFAULT NULL,
  `payments_count` int(10) unsigned NOT NULL DEFAULT '0',
  `payments_total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `commission_percent` decimal(5,2) NOT NULL DEFAULT '0.00',
  `commission_total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `advances_total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `paid_total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `carry_over_total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `closure_note` text,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendor_period_closures`
--

LOCK TABLES `vendor_period_closures` WRITE;
/*!40000 ALTER TABLE `vendor_period_closures` DISABLE KEYS */;
INSERT INTO `vendor_period_closures` VALUES (1,32,'2024-06-14','2024-12-30','2024-12-31',28,5328.62,10.00,532.86,0.00,532.86,0.00,'todo loviejo','2026-03-21 16:55:32'),(2,7,'2023-07-31','2023-12-27','2026-03-21',33,8538.00,10.00,853.80,0.00,853.80,0.00,'','2026-03-21 17:01:13'),(3,91,'2025-12-12','2025-12-12','2026-03-21',1,676.00,10.00,67.60,0.00,67.60,0.00,'Ya pagado','2026-03-21 18:45:52'),(4,7,'2024-01-02','2024-12-30','2026-03-21',115,30772.00,10.00,3077.20,0.00,3077.20,0.00,'Pagos viejos 2024','2026-03-21 18:49:45');
/*!40000 ALTER TABLE `vendor_period_closures` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'galaview'
--

--
-- Dumping routines for database 'galaview'
--
/*!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-04-22  0:00:22
