| Server IP : 74.208.127.88 / Your IP : 3.17.191.196 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/muebles/ |
Upload File : |
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 27-05-2024 a las 20:45:03
-- Versión del servidor: 10.4.21-MariaDB
-- Versión de PHP: 7.3.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!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 */;
--
-- Base de datos: `victoria`
--
DELIMITER $$
--
-- Procedimientos
--
CREATE DEFINER=`root`@`::1` PROCEDURE `deleteBarang` (`idbarang` VARCHAR(6)) BEGIN
delete from m_barang where id_barang = idbarang;
delete from m_barang_detail where id_barang = idbarang;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteSale` (`x_sale_id` VARCHAR(10), `cnote` TEXT) BEGIN
CALL restore_stock_sale(x_sale_id);
UPDATE t_sale SET sts = 0,note = cnote WHERE sale_id= x_sale_id;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `prcDeleteRoute` (`_sessionID` VARCHAR(50)) BEGIN
DELETE FROM gpslocations
WHERE sessionID = _sessionID;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `prcGetAllRoutesForMap` () BEGIN
SELECT sessionId, gpsTime, CONCAT('{ "latitude":"', CAST(latitude AS CHAR),'", "longitude":"', CAST(longitude AS CHAR), '", "speed":"', CAST(speed AS CHAR), '", "direction":"', CAST(direction AS CHAR), '", "distance":"', CAST(distance AS CHAR), '", "locationMethod":"', locationMethod, '", "gpsTime":"', DATE_FORMAT(gpsTime, '%b %e %Y %h:%i%p'), '", "userName":"', userName, '", "phoneNumber":"', phoneNumber, '", "sessionID":"', CAST(sessionID AS CHAR), '", "accuracy":"', CAST(accuracy AS CHAR), '", "extraInfo":"', extraInfo, '" }') json
FROM (SELECT MAX(GPSLocationID) ID
FROM gpslocations
WHERE sessionID != '0' && CHAR_LENGTH(sessionID) != 0 && gpstime != '0000-00-00 00:00:00'
GROUP BY sessionID) AS MaxID
JOIN gpslocations ON gpslocations.GPSLocationID = MaxID.ID
ORDER BY gpsTime;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `prcGetRouteForMap` (`_sessionID` VARCHAR(50)) BEGIN
SELECT CONCAT('{ "latitude":"', CAST(latitude AS CHAR),'", "longitude":"', CAST(longitude AS CHAR), '", "speed":"', CAST(speed AS CHAR), '", "direction":"', CAST(direction AS CHAR), '", "distance":"', CAST(distance AS CHAR), '", "locationMethod":"', locationMethod, '", "gpsTime":"', DATE_FORMAT(gpsTime, '%b %e %Y %h:%i%p'), '", "userName":"', userName, '", "phoneNumber":"', phoneNumber, '", "sessionID":"', CAST(sessionID AS CHAR), '", "accuracy":"', CAST(accuracy AS CHAR), '", "extraInfo":"', extraInfo, '" }') json
FROM gpslocations
WHERE sessionID = _sessionID
ORDER BY lastupdate;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `prcGetRoutes` () BEGIN
CREATE TEMPORARY TABLE tempRoutes (
sessionID VARCHAR(50),
userName VARCHAR(50),
startTime DATETIME,
endTime DATETIME)
ENGINE = MEMORY;
INSERT INTO tempRoutes (sessionID, userName)
SELECT DISTINCT sessionID, userName
FROM gpslocations;
UPDATE tempRoutes tr
SET startTime = (SELECT MIN(gpsTime) FROM gpslocations gl
WHERE gl.sessionID = tr.sessionID
AND gl.userName = tr.userName);
UPDATE tempRoutes tr
SET endTime = (SELECT MAX(gpsTime) FROM gpslocations gl
WHERE gl.sessionID = tr.sessionID
AND gl.userName = tr.userName);
SELECT
CONCAT('{ "sessionID": "', CAST(sessionID AS CHAR), '", "userName": "', userName, '", "times": "(', DATE_FORMAT(startTime, '%b %e %Y %h:%i%p'), ' - ', DATE_FORMAT(endTime, '%b %e %Y %h:%i%p'), ')" }') json
FROM tempRoutes
ORDER BY startTime DESC;
DROP TABLE tempRoutes;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `prcSaveGPSLocation` (`_latitude` DECIMAL(10,7), `_longitude` DECIMAL(10,7), `_speed` INT(10), `_direction` INT(10), `_distance` DECIMAL(10,1), `_date` TIMESTAMP, `_locationMethod` VARCHAR(50), `_userName` VARCHAR(50), `_phoneNumber` VARCHAR(50), `_sessionID` VARCHAR(50), `_accuracy` INT(10), `_extraInfo` VARCHAR(255), `_eventType` VARCHAR(50)) BEGIN
INSERT INTO gpslocations (latitude, longitude, speed, direction, distance, gpsTime, locationMethod, userName, phoneNumber, sessionID, accuracy, extraInfo, eventType)
VALUES (_latitude, _longitude, _speed, _direction, _distance, _date, _locationMethod, _userName, _phoneNumber, _sessionID, _accuracy, _extraInfo, _eventType);
SELECT NOW();
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `restore_stock_sale` (`var_sale_id` VARCHAR(10)) BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
DECLARE cid_item VARCHAR(6);
DECLARE cqty INT;
DECLARE deletesale CURSOR FOR SELECT id_item,qty FROM t_sale_detail WHERE sale_id = var_sale_id ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
OPEN deletesale;
get_deletesale: LOOP
FETCH deletesale INTO cid_item,cqty;
IF v_finished = 1 THEN
LEAVE get_deletesale;
END IF;
UPDATE m_item SET stock = stock + cqty WHERE id_item = cid_item;
END LOOP get_deletesale;
CLOSE deletesale;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveClient` (IN `var_name` VARCHAR(40), IN `var_contrato` VARCHAR(20), IN `var_id_collector` INT(11), IN `var_conyugue` VARCHAR(100), IN `var_direccion` VARCHAR(100), IN `var_come` VARCHAR(100), IN `var_credito` VARCHAR(10), IN `var_poblacion` VARCHAR(40), IN `var_phone` CHAR(35)) BEGIN
INSERT INTO customer(name, contract,colector_id, conyugue, direccion, come_in, credito, poblacion, phone)
VALUES(var_name,var_contrato,var_id_collector,var_conyugue,var_direccion,var_come,var_credito,var_poblacion, var_phone);
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveItem` (IN `var_barcode` VARCHAR(100), IN `var_item_name` VARCHAR(100), IN `var_unit` VARCHAR(4), IN `var_stock` INT, IN `var_price` INT, IN `var_note` TEXT, IN `var_category_id` INT(2)) BEGIN
DECLARE newnumber,newiditem VARCHAR(6);
DECLARE countitem INT;
SELECT COUNT(id_item) FROM m_item INTO countitem;
IF(countitem = 0 ) THEN
SET newnumber = '1';
ELSE
SELECT TRIM(CAST((CAST(SUBSTR(id_item,3,6) AS UNSIGNED)+1) AS CHAR(4)))
FROM m_item
ORDER BY id_item DESC LIMIT 1 INTO newnumber;
END IF;
IF (LENGTH(newnumber) = 1) THEN
SET newiditem=CONCAT('PB000',newnumber);
ELSE
IF (LENGTH(newnumber) = 2) THEN
SET newiditem=CONCAT('PB00',newnumber);
ELSE
IF (LENGTH(newnumber) = 3) THEN
SET newiditem=CONCAT('PB0',newnumber);
ELSE
SET newiditem=CONCAT('PB',newnumber);
END IF ;
END IF ;
END IF ;
INSERT INTO m_item(id_item,barcode,item_name,unit,stock,price,note,category_id)
VALUES(newiditem,var_barcode,var_item_name,var_unit,var_stock,var_price,var_note,var_category_id);
select newiditem as id_item;
INSERT INTO product(barcode,name,description,inventary_min,price_in,price_out,unit,user_id,is_service,is_active)
VALUES(var_barcode,var_item_name,var_note,5,var_price,var_price,var_unit,1,0,1);
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveJob` (IN `var_name` VARCHAR(100), IN `var_contrato` VARCHAR(20), IN `var_laborOld` INT(2), IN `var_salary` DECIMAL(10,2), IN `var_payment_frequency` VARCHAR(15), IN `var_endorsenments1` INT(11), IN `var_endorsenments2` INT(11), IN `var_user` INT(11), IN `var_created_at` DATE) BEGIN
INSERT INTO jobok(name, contract,laborOld, salary,payment_frequency, endorsenments1, endorsenments2, id_user,created_at)
VALUES(var_name,var_contrato,var_laborOld,var_salary,var_payment_frequency,var_endorsenments1,var_endorsenments2,var_user,var_created_at);
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveSale` (IN `pre_sale_id` VARCHAR(7), IN `var_sale_date` DATE, IN `var_total` DECIMAL(10,2), IN `var_paid` DECIMAL(10,2), IN `discprcn` DECIMAL(10,2), IN `discrp` INT, IN `var_unique` VARCHAR(13), IN `iduser` INT, IN `var_note` TEXT, IN `var_fpago1` INT, IN `var_fpago2` INT, IN `var_idSeller` INT, IN `var_idPerson` INT(11)) BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
declare next_sale_id,next_value varchar(10);
declare count_of_sale int;
declare cid_item varchar(6);
declare cbarcode varchar(50);
declare cname varchar(100);
declare cqty,cdiscrp,cprice decimal(10,2);
declare cunit varchar(4);
declare cdiscprc decimal(10,2);
DEClARE tempsale CURSOR FOR SELECT id_item,barcode,item_name,qty,unit,price,discprc,discrp FROM temp_sale where uniqid = var_unique and id_user = iduser ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
SELECT COUNT(sale_id) FROM t_sale WHERE SUBSTR(sale_id,1,7) = pre_sale_id INTO count_of_sale;
IF count_of_sale = 0 THEN
SET next_value = '1';
ELSE
SELECT TRIM(CAST((CAST(SUBSTR(sale_id,8,3) AS UNSIGNED)+1) AS CHAR(3)))
FROM t_sale
WHERE SUBSTR(sale_id,1,7) = pre_sale_id
ORDER BY sale_id DESC LIMIT 1 INTO next_value;
END IF;
IF (LENGTH(next_value) = 1) THEN
SET next_sale_id=CONCAT(pre_sale_id,'00',next_value);
ELSE
IF (LENGTH(next_value) = 2) THEN
SET next_sale_id=CONCAT(pre_sale_id,'0',next_value);
ELSE
SET next_sale_id=CONCAT(pre_sale_id,next_value);
END IF ;
END IF ;
INSERT INTO t_sale(sale_id,id_user,id_seller,sale_date,total,paid,disc_prcn,disc_rp,sts,note,f_pago1,f_pago2) VALUES
(next_sale_id,iduser,var_idSeller,var_sale_date,var_total,var_paid,discprcn,discrp,1,var_note,var_fpago1,var_fpago2);
INSERT INTO sell (sale_id,person_id,id_seller,operation_type_id,p_id,d_id,total,cash,discount,stock_to_id,sale_date)
VALUES (next_sale_id,var_idPerson,var_idSeller,2,1,1,var_total,var_paid,discprcn,discrp,var_sale_date);
OPEN tempsale;
get_tempsale: LOOP
FETCH tempsale INTO cid_item,cbarcode,cname,cqty,cunit,cprice,cdiscprc,cdiscrp;
IF v_finished = 1 THEN
LEAVE get_tempsale;
END IF;
insert into t_sale_detail(sale_id,id_item,barcode,item_name,qty,unit,price,disc_prc,disc_rp) values
(next_sale_id,cid_item,cbarcode,cname,cqty,cunit,cprice,cdiscprc,cdiscrp);
update m_item set stock = stock - cqty where id_item = cid_item;
END LOOP get_tempsale;
CLOSE tempsale;
select next_sale_id;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveSale2` (IN `pre_sale_id` VARCHAR(7), IN `var_sale_date` DATE, IN `var_total` DECIMAL(15,2), IN `var_client` INT(11), IN `var_paid` INT, IN `discprcn` DECIMAL(15,2), IN `discrp` INT, IN `var_unique` VARCHAR(13), IN `iduser` INT, IN `var_note` TEXT, IN `var_credit_amount` DECIMAL(15,2)) BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
declare next_sale_id,next_value varchar(10);
declare count_of_sale int;
declare cid_item varchar(6);
declare cname varchar(100);
declare cqty,cdiscrp,cprice decimal(15,2);
declare cunit varchar(4);
declare cdiscprc decimal(15,2);
DEClARE tempsale CURSOR FOR SELECT id_item,item_name,qty,unit,price,discprc,discrp FROM temp_sale where uniqid = var_unique and id_user = iduser ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
SELECT COUNT(sale_id) FROM t_sale WHERE SUBSTR(sale_id,1,7) = pre_sale_id INTO count_of_sale;
IF count_of_sale = 0 THEN
SET next_value = '1';
ELSE
SELECT TRIM(CAST((CAST(SUBSTR(sale_id,8,3) AS UNSIGNED)+1) AS CHAR(3)))
FROM t_sale
WHERE SUBSTR(sale_id,1,7) = pre_sale_id
ORDER BY sale_id DESC LIMIT 1 INTO next_value;
END IF;
IF (LENGTH(next_value) = 1) THEN
SET next_sale_id=CONCAT(pre_sale_id,'00',next_value);
ELSE
IF (LENGTH(next_value) = 2) THEN
SET next_sale_id=CONCAT(pre_sale_id,'0',next_value);
ELSE
SET next_sale_id=CONCAT(pre_sale_id,next_value);
END IF ;
END IF ;
INSERT INTO t_sale(sale_id,id_user,sale_date,total,id_client,paid,disc_prcn,disc_rp,sts,note,is_credit,credit_amount) VALUES
(next_sale_id,iduser,var_sale_date,var_total,var_client,var_paid,discprcn,discrp,1,var_note,1,var_credit_amount);
INSERT INTO sell (sale_id,person_id,operation_type_id,p_id,d_id,total,cash,discount,stock_to_id,sale_date)
VALUES (next_sale_id,var_client,2,4,1,var_total,var_paid,var_credit_amount,1,var_sale_date);
OPEN tempsale;
get_tempsale: LOOP
FETCH tempsale INTO cid_item,cname,cqty,cunit,cprice,cdiscprc,cdiscrp;
IF v_finished = 1 THEN
LEAVE get_tempsale;
END IF;
insert into t_sale_detail(sale_id,id_item,item_name,qty,unit,price,disc_prc,disc_rp) values
(next_sale_id,cid_item,cname,cqty,cunit,cprice,cdiscprc,cdiscrp);
update m_item set stock = stock - cqty where id_item = cid_item;
END LOOP get_tempsale;
CLOSE tempsale;
select next_sale_id;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveSale3` (IN `pre_sale_id` VARCHAR(7), IN `var_sale_date` DATE, IN `var_total` DECIMAL(10,2), IN `var_client` INT(11), IN `var_paid` INT, IN `discprcn` DECIMAL(10,2), IN `discrp` INT, IN `var_unique` VARCHAR(13), IN `iduser` INT, IN `var_note` TEXT, IN `var_credit_amount` DECIMAL(10,2)) BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
declare next_sale_id,next_value varchar(10);
declare count_of_sale int;
declare cid_item varchar(6);
declare cname varchar(100);
declare cqty,cdiscrp,cprice decimal(15,2);
declare cunit varchar(4);
declare cdiscprc decimal(15,2);
DEClARE tempsale CURSOR FOR SELECT id_item,item_name,qty,unit,price,discprc,discrp FROM temp_sale where uniqid = var_unique and id_user = iduser ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
SELECT COUNT(sale_id) FROM t_sale WHERE SUBSTR(sale_id,1,7) = pre_sale_id INTO count_of_sale;
IF count_of_sale = 0 THEN
SET next_value = '1';
ELSE
SELECT TRIM(CAST((CAST(SUBSTR(sale_id,8,3) AS UNSIGNED)+1) AS CHAR(3)))
FROM t_sale
WHERE SUBSTR(sale_id,1,7) = pre_sale_id
ORDER BY sale_id DESC LIMIT 1 INTO next_value;
END IF;
IF (LENGTH(next_value) = 1) THEN
SET next_sale_id=CONCAT(pre_sale_id,'00',next_value);
ELSE
IF (LENGTH(next_value) = 2) THEN
SET next_sale_id=CONCAT(pre_sale_id,'0',next_value);
ELSE
SET next_sale_id=CONCAT(pre_sale_id,next_value);
END IF ;
END IF ;
INSERT INTO t_sale(sale_id,id_user,sale_date,total,id_client,paid,disc_prcn,disc_rp,sts,note,is_credit,credit_amount) VALUES
(next_sale_id,iduser,var_sale_date,var_total,var_client,var_paid,discprcn,discrp,2,var_note,0,var_credit_amount);
INSERT INTO sell (sale_id,person_id,operation_type_id,p_id,d_id,total,cash,discount,is_draft,stock_to_id,sale_date)
VALUES (next_sale_id,var_client,4,2,2,var_total,var_paid,var_credit_amount,1,1,var_sale_date);
OPEN tempsale;
get_tempsale: LOOP
FETCH tempsale INTO cid_item,cname,cqty,cunit,cprice,cdiscprc,cdiscrp;
IF v_finished = 1 THEN
LEAVE get_tempsale;
END IF;
insert into t_sale_detail(sale_id,id_item,item_name,qty,unit,price,disc_prc,disc_rp,is_draft) values
(next_sale_id,cid_item,cname,cqty,cunit,cprice,cdiscprc,cdiscrp,1);
update m_item set stock = stock where id_item = cid_item;
END LOOP get_tempsale;
CLOSE tempsale;
select next_sale_id;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveSale4` (IN `var_re_id` INT(11), IN `var_sale_date` DATE, IN `var_total` DECIMAL(10,2), IN `var_client` INT(11), IN `var_paid` INT, IN `discprcn` DECIMAL(10,2), IN `discrp` INT, IN `var_unique` VARCHAR(13), IN `iduser` INT, IN `var_note` TEXT, IN `var_credit_amount` DECIMAL(10,2)) BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
declare next_sale_id,next_value varchar(10);
declare count_of_re int;
declare cid_item varchar(6);
declare cbarcode varchar(50);
declare cname varchar(100);
declare cqty,cdiscrp,cprice decimal(15,2);
declare cunit varchar(4);
declare cdiscprc decimal(15,2);
DEClARE tempsale CURSOR FOR SELECT id_item,barcode,item_name,qty,unit,price,discprc,discrp FROM purchase_order where uniqid != var_unique and id_user = iduser ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
UPDATE re SET `is_draft` = '6' WHERE id = var_re_id;
OPEN tempsale;
get_tempsale: LOOP
FETCH tempsale INTO cid_item,cbarcode,cname,cqty,cunit,cprice,cdiscprc,cdiscrp;
IF v_finished = 1 THEN
LEAVE get_tempsale;
END IF;
insert into operation2(barcode,stock_id,q,price_in,price_out,operation_type_id,re_id,is_draft) values
(cbarcode,1,cqty,cprice,cprice,1,var_re_id,1);
update operation2 SET `is_draft` = '1' WHERE re_id = var_re_id AND barcode=cbarcode;
update m_item set price = cprice, stock = stock + cqty where id_item = cid_item;
update product set price_out = cprice where barcode = cbarcode;
update product set price_in = cdiscprc where barcode = cbarcode;
END LOOP get_tempsale;
CLOSE tempsale;
select next_sale_id;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `savesale5` (IN `re_id` INT(11), IN `var_sale_date` DATE, IN `var_total` DECIMAL(10,2), IN `var_client` INT(11), IN `var_paid` INT, IN `discprcn` DECIMAL(10,2), IN `discrp` INT, IN `var_unique` VARCHAR(13), IN `iduser` INT, IN `var_note` TEXT, IN `var_credit_amount` DECIMAL(10,2)) BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
declare next_sale_id,next_value varchar(10);
declare count_of_re int;
declare cid_item varchar(6);
declare cbarcode varchar(50);
declare cname varchar(100);
declare cqty,cdiscrp,cprice decimal(15,2);
declare cunit varchar(4);
declare cdiscprc decimal(15,2);
DEClARE tempsale CURSOR FOR SELECT id_item,barcode,item_name,qty,unit,price,discprc,discrp FROM purchase_order where uniqid != var_unique and id_user = iduser ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
INSERT INTO re (employee_id,operation_type_id,p_id,d_id,total,cash,discount,is_draft,stock_to_id,created_at)
VALUES (var_client,2,1,2,var_total,var_paid,var_credit_amount,5,1,var_sale_date);
OPEN tempsale;
get_tempsale: LOOP
FETCH tempsale INTO cid_item,cbarcode,cname,cqty,cunit,cprice,cdiscprc,cdiscrp;
IF v_finished = 1 THEN
LEAVE get_tempsale;
END IF;
update m_item set price = cprice where id_item = cid_item;
insert into operation2(barcode,stock_id,q,price_in,price_out,operation_type_id,re_id,is_draft) values
(cbarcode,1,cqty,cprice,cprice,2,re_id,0);
update m_item set price = cprice , stock = stock - cqty where id_item = cid_item;
update product set price_out = cprice where barcode = cbarcode;
update product set price_in = cdiscprc where barcode = cbarcode;
END LOOP get_tempsale;
CLOSE tempsale;
select next_sale_id;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveSaleCredit` (IN `pre_sale_id` VARCHAR(7), IN `var_sale_date` DATE, IN `var_total` DECIMAL(10,2), IN `var_paid` DECIMAL(10,2), IN `discprcn` DECIMAL(10,2), IN `discrp` INT, IN `var_unique` INT(13), IN `iduser` INT, IN `var_note` TEXT, IN `var_fpago1` INT, IN `var_fpago2` INT, IN `var_idSeller` INT, IN `var_idPerson` INT(11), IN `var_collector` INT(11), IN `var_re_id` INT(11)) BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
declare next_sale_id,next_value varchar(10);
declare count_of_sale int;
declare cid_item varchar(6);
declare cbarcode varchar(50);
declare cname varchar(100);
declare cqty,cdiscrp,cprice decimal(10,2);
declare cunit varchar(4);
declare cdiscprc decimal(10,2);
DEClARE tempsale CURSOR FOR SELECT id_item,barcode,item_name,qty,unit,price,discprc,discrp FROM temp_sale where uniqid = var_unique and id_user = iduser ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
SELECT COUNT(sale_id) FROM t_sale WHERE SUBSTR(sale_id,1,7) = pre_sale_id INTO count_of_sale;
IF count_of_sale = 0 THEN
SET next_value = '1';
ELSE
SELECT TRIM(CAST((CAST(SUBSTR(sale_id,8,3) AS UNSIGNED)+1) AS CHAR(3)))
FROM t_sale
WHERE SUBSTR(sale_id,1,7) = pre_sale_id
ORDER BY sale_id DESC LIMIT 1 INTO next_value;
END IF;
IF (LENGTH(next_value) = 1) THEN
SET next_sale_id=CONCAT(pre_sale_id,'00',next_value);
ELSE
IF (LENGTH(next_value) = 2) THEN
SET next_sale_id=CONCAT(pre_sale_id,'0',next_value);
ELSE
SET next_sale_id=CONCAT(pre_sale_id,next_value);
END IF ;
END IF ;
INSERT INTO t_sale(sale_id,re_id,id_user,id_client,id_seller,id_collector,sale_date,total,paid,disc_prcn,disc_rp,sts,is_credit,note,f_pago1,f_pago2) VALUES
(next_sale_id,var_re_id,iduser,var_idPerson,var_idSeller,var_collector,var_sale_date,var_total,var_paid,discprcn,discrp,1,1,var_note,var_fpago1,var_fpago2);
INSERT INTO sell (sale_id,person_id,id_seller,operation_type_id,p_id,d_id,total,cash,discount,enganche,sale_date)
VALUES (next_sale_id,var_idPerson,var_idSeller,2,4,1,var_total,var_paid,discprcn,discrp,var_sale_date);
insert into payment(payment_type_id, sale_id, person_id, val) values
(1,next_sale_id,var_idPerson,discrp);
OPEN tempsale;
get_tempsale: LOOP
FETCH tempsale INTO cid_item,cbarcode,cname,cqty,cunit,cprice,cdiscprc,cdiscrp;
IF v_finished = 1 THEN
LEAVE get_tempsale;
END IF;
insert into t_sale_detail(sale_id,id_item,barcode,item_name,qty,unit,price,disc_prc,disc_rp,re_id) values
(next_sale_id,cid_item,cbarcode,cname,cqty,cunit,cprice,cdiscprc,cdiscrp,var_re_id);
UPDATE operation2 set sell_id = var_idPerson WHERE barcode = cbarcode and re_id =var_re_id;
update m_item set stock = stock - cqty where id_item = cid_item;
END LOOP get_tempsale;
CLOSE tempsale;
select next_sale_id;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `saveSaleS` (IN `pre_sale_id` VARCHAR(7), IN `var_sale_date` DATE, IN `var_total` DECIMAL(10,2), IN `var_paid` DECIMAL(10,2), IN `discprcn` DECIMAL(10,2), IN `discrp` INT, IN `var_unique` VARCHAR(13), IN `iduser` INT, IN `var_note` TEXT, IN `var_fpago1` INT, IN `var_fpago2` INT, IN `var_idSeller` INT, IN `var_idPerson` INT(11), IN `var_stock` INT(1)) BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
declare next_sale_id,next_value varchar(10);
declare count_of_sale int;
declare cid_item varchar(6);
declare cbarcode varchar(50);
declare cname varchar(100);
declare cqty,cdiscrp,cprice decimal(10,2);
declare cunit varchar(4);
declare cdiscprc decimal(10,2);
DEClARE tempsale CURSOR FOR SELECT id_item,barcode,item_name,qty,unit,price,discprc,discrp FROM temp_sale where uniqid = var_unique and id_user = iduser ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1;
SELECT COUNT(sale_id) FROM t_sale WHERE SUBSTR(sale_id,1,7) = pre_sale_id INTO count_of_sale;
IF count_of_sale = 0 THEN
SET next_value = '1';
ELSE
SELECT TRIM(CAST((CAST(SUBSTR(sale_id,8,3) AS UNSIGNED)+1) AS CHAR(3)))
FROM t_sale
WHERE SUBSTR(sale_id,1,7) = pre_sale_id
ORDER BY sale_id DESC LIMIT 1 INTO next_value;
END IF;
IF (LENGTH(next_value) = 1) THEN
SET next_sale_id=CONCAT(pre_sale_id,'00',next_value);
ELSE
IF (LENGTH(next_value) = 2) THEN
SET next_sale_id=CONCAT(pre_sale_id,'0',next_value);
ELSE
SET next_sale_id=CONCAT(pre_sale_id,next_value);
END IF ;
END IF ;
INSERT INTO t_sale(sale_id,id_user,id_seller,sale_date,total,paid,disc_prcn,disc_rp,sts,note,f_pago1,f_pago2) VALUES
(next_sale_id,iduser,var_idSeller,var_sale_date,var_total,var_paid,discprcn,discrp,1,var_note,var_fpago1,var_fpago2);
INSERT INTO sell (sale_id,person_id,id_seller,operation_type_id,p_id,d_id,total,cash,discount,stock_to_id,sale_date)
VALUES (next_sale_id,var_idPerson,var_idSeller,2,1,1,var_total,var_paid,discprcn,var_stock,var_sale_date);
OPEN tempsale;
get_tempsale: LOOP
FETCH tempsale INTO cid_item,cbarcode,cname,cqty,cunit,cprice,cdiscprc,cdiscrp;
IF v_finished = 1 THEN
LEAVE get_tempsale;
END IF;
insert into t_sale_detail(sale_id,id_item,barcode,item_name,qty,unit,price,disc_prc,disc_rp) values
(next_sale_id,cid_item,cbarcode,cname,cqty,cunit,cprice,cdiscprc,cdiscrp);
update m_item set stock = stock - cqty where id_item = cid_item;
END LOOP get_tempsale;
CLOSE tempsale;
select next_sale_id;
END$$
DELIMITER ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `accounts`
--
CREATE TABLE `accounts` (
`id` int(11) NOT NULL,
`week` int(11) NOT NULL,
`CuentasxCobrar` decimal(15,2) NOT NULL,
`PendienteCobrar` decimal(15,2) DEFAULT NULL,
`SaldoCobrado` decimal(15,2) DEFAULT NULL,
`dif` decimal(15,2) DEFAULT NULL,
`txtdatein` date NOT NULL,
`txtdateout` date NOT NULL,
`update_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`created_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `accounts`
--
INSERT INTO `accounts` (`id`, `week`, `CuentasxCobrar`, `PendienteCobrar`, `SaldoCobrado`, `dif`, `txtdatein`, `txtdateout`, `update_date`, `created_at`) VALUES
(116, 42, '0.00', '0.00', NULL, NULL, '2023-10-14', '2023-10-19', '2023-10-18 18:58:03', '2023-10-18 12:58:03'),
(117, 43, '0.00', '0.00', NULL, NULL, '2023-10-21', '2023-10-26', '2023-10-19 14:43:11', '2023-10-19 08:43:11'),
(118, 45, '30850.00', '600.00', NULL, NULL, '2023-11-04', '2023-11-09', '2023-11-04 03:11:31', '2023-11-03 21:11:31'),
(119, 13, '0.00', '0.00', NULL, NULL, '2024-03-23', '2024-03-28', '2024-03-24 00:46:35', '2024-03-23 18:46:35'),
(120, 16, '0.00', '0.00', NULL, NULL, '2024-04-13', '2024-04-18', '2024-04-15 22:36:13', '2024-04-15 16:36:13'),
(121, 17, '0.00', '0.00', NULL, NULL, '2024-04-01', '2024-04-23', '2024-04-24 04:46:51', '2024-04-23 22:46:51'),
(122, 17, '12870.00', '250.00', NULL, NULL, '2024-04-20', '2024-04-25', '2024-04-24 05:09:40', '2024-04-23 23:09:40'),
(123, 18, '12870.00', '450.00', NULL, NULL, '2024-04-27', '2024-05-02', '2024-04-24 05:16:03', '2024-04-23 23:16:03'),
(124, 18, '12870.00', '250.00', NULL, NULL, '2024-04-27', '2024-04-29', '2024-04-30 02:01:01', '2024-04-29 20:01:01');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `ajust`
--
CREATE TABLE `ajust` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `ajust`
--
INSERT INTO `ajust` (`id`, `name`) VALUES
(1, 'salida-ajuste'),
(2, 'perdida-ajuste'),
(3, 'robo-ajuste'),
(4, 'cancelacion'),
(5, 'desperdicio');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `box`
--
CREATE TABLE `box` (
`id` int(11) NOT NULL,
`stock_id` int(11) NOT NULL,
`total` decimal(10,2) DEFAULT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `box`
--
INSERT INTO `box` (`id`, `stock_id`, `total`, `created_at`) VALUES
(224, 1, NULL, '2021-09-19 21:30:58');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `category`
--
CREATE TABLE `category` (
`id` int(11) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`name` varchar(50) NOT NULL,
`description` text DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `category`
--
INSERT INTO `category` (`id`, `image`, `name`, `description`, `status`, `created_at`) VALUES
(1, NULL, 'SARTENES,VAJILLAS,ALUMINIO', '', 1, '2020-05-30 23:58:12'),
(2, NULL, 'BLANCOS Y COBERTORES,', '', 1, '2020-05-30 23:58:25'),
(3, NULL, 'MUEBLES DE MADERA', '', 1, '2020-05-30 23:58:37'),
(4, NULL, 'BASES Y COLCHONES', '', 1, '2020-07-23 10:02:06'),
(5, NULL, 'RECAMARAS DE MADERA Y MDF', '', 1, '2020-08-21 16:35:53'),
(6, NULL, 'COSINAS Y COMEDORES', '', 1, '2020-08-21 16:36:13'),
(7, NULL, 'ELECTRONICA Y ELECTRODOMESTICOS', '', 1, '2020-12-01 05:22:43'),
(8, NULL, 'LINEA BLANCA', '', 1, '2021-01-16 00:51:49'),
(9, NULL, 'MINISPLIT ,AIRES Y ABANICOS', '', 1, '2021-09-19 13:59:37'),
(10, NULL, 'MUEBLES TUBULARES Y DE FIERRO', NULL, 1, '2021-09-28 02:37:53'),
(11, NULL, 'JUEGOS DE JARDIN Y MESEDORAS', NULL, 1, '2021-09-28 12:02:23'),
(12, NULL, 'SALAS DE TELA ', NULL, 1, '2021-09-28 12:08:30'),
(21, NULL, 'ARTICULOS VARIOS', NULL, 1, '2023-10-14 00:00:00');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `collection_data`
--
CREATE TABLE `collection_data` (
`id_cust` int(11) NOT NULL,
`id_client` int(11) NOT NULL,
`contract` int(11) NOT NULL,
`payday` varchar(11) DEFAULT NULL COMMENT '1-lunes, 2-martes...7-domingo\r\n',
`txtpayment_period` int(11) NOT NULL,
`min_pay` decimal(15,0) NOT NULL DEFAULT 1000,
`paydate` date NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `collection_data`
--
INSERT INTO `collection_data` (`id_cust`, `id_client`, `contract`, `payday`, `txtpayment_period`, `min_pay`, `paydate`, `created_at`) VALUES
(96, 164, 27345, '7', 1, '200', '2023-03-18', '2024-05-17 01:54:44'),
(97, 165, 25044, '6', 1, '150', '2023-12-14', '2024-05-18 20:09:28'),
(98, 166, 27919, '1', 1, '100', '2024-05-25', '2024-05-18 21:52:22'),
(99, 167, 27362, '7', 1, '200', '2024-05-24', '2024-05-20 20:32:55'),
(100, 168, 26436, '4', 4, '830', '2022-10-07', '2024-05-20 21:53:00'),
(101, 169, 26288, '0', 3, '300', '2022-08-01', '2024-05-21 00:34:12');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `comprobantesfiscales`
--
CREATE TABLE `comprobantesfiscales` (
`id` int(11) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`name` varchar(50) NOT NULL,
`description` text NOT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `comprobantesfiscales`
--
INSERT INTO `comprobantesfiscales` (`id`, `image`, `name`, `description`, `created_at`) VALUES
(1, NULL, 'G01', 'Adquision de mercancia', '2019-10-31 00:40:55');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `configuration`
--
CREATE TABLE `configuration` (
`id` int(11) NOT NULL,
`short` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
`kind` int(11) DEFAULT NULL,
`val` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `configuration`
--
INSERT INTO `configuration` (`id`, `short`, `name`, `kind`, `val`) VALUES
(1, 'company_name', 'Nombre de la empresa', 2, 'MUEBLERIA VICTORIA'),
(2, 'title', 'Titulo del Sistema', 2, 'SOFTWARE VICTORIA 3.0'),
(3, 'admin_email', 'CORREO', 2, 'syusa19802017@gmail.com'),
(4, 'report_image', 'Imagen en Reportes', 4, 'logo_victoria_1.png'),
(5, 'imp-name', 'Nombre Impuesto', 2, 'IVA'),
(6, 'imp-val', 'Valor Impuesto (%)', 2, '16'),
(7, 'currency', 'Simbolo de Moneda', 2, '$'),
(8, 'rfc_val', 'RFC', 2, 'HOGF-870809-RK5'),
(9, 'name_val', 'NOMBRE', 2, 'PEDRO P. DE HOYOS GUERRA'),
(10, 'add_val', 'CALLE', 2, 'JAVIER MINA '),
(11, 'no_int', 'NUMERO INT', 2, 'NO. 1002'),
(12, 'no_ext', 'NUMERO EXT', 2, ''),
(13, 'col_val', 'COLONIA', 2, 'COL. CENTRO '),
(14, 'ciudad_val', 'CIUDAD', 2, 'ALLENDE'),
(15, 'est_val', 'ESTADO', 2, 'COAHUILA'),
(16, 'cp_val', 'CODIGO POSTAL', 2, '26530'),
(17, 'Serie_val', 'SerieFacturas', 2, 'A'),
(18, 'descuento_val', 'DESCUENTO GENERAL EN %', 2, '0'),
(19, 'activardescuento_val', 'ACTIVAR DESCUENTO GENERAL (SI/NO)', 2, 'SI'),
(20, 'cambiarprecio_val', 'CAMBIAR PRECIO POR ARTICULO (SI/NO)', 2, 'SI'),
(21, 'ventarapida_val', 'VENTA RAPIDA (SI/NO)', 2, 'NO'),
(22, 'descuentoenventa_val', 'BLOQUEAR DESCUENTO EN VENTA (SI/NO)', 2, 'SI'),
(23, 'capturarcantidad_val', 'CAPTURAR CANTIDAD (SI/NO)', 2, 'SI'),
(24, 'Sat_val', 'Codigo Sat Generico', 2, '14111514'),
(25, 'Sat_val_Unidad', 'Unidad de Medida Sat Generica', 2, 'H87'),
(26, 'Sat_val_Medida', 'Tipo de Unidad de medida', 2, 'Multiplos / Fracciones / Decimales'),
(27, 'Meta_Ventas', 'Meta de Ventas diarias $', 2, '450'),
(28, 'Suc_No', 'Numero y Nombre Sucursal', 2, '01 Viñedos'),
(29, 'Suc_Dir', 'Direccion Sucursal', 2, 'GALERIAS'),
(30, 'Suc_Tel', 'Telefono Sucursal', 2, '8711446289'),
(31, 'archivo_cer', 'Archivo sat *.cer\r\n', 5, '00001000000504003296.cer'),
(32, 'archivo_key', 'Archivo sat *.key\r\n', 6, 'CSD_FACTURACION_GAOF830617NI0_20200519_134506.key'),
(33, 'Pass_Sat', 'password SAT FIEL\r\n', 2, '******'),
(34, 'Usuario_Factura', 'Usuario_Facturacion Yusa\r\n\r\n\r\n\r\n', 2, 'GAOF830617N34'),
(35, 'pass_fac', 'password Facturacion Yusa\r\n', 2, 'GAOF830617N34'),
(36, 'Regimen_sat', 'Regimen Fiscal SAT(MX)', 2, '621'),
(37, 'archivo_cer_demo', 'Archivo sat *.cer_demo\r\n', 5, 'XIA190128J61.cer'),
(38, 'archivo_key_demo', 'Archivo sat *.key_demo\r\n', 6, 'XIA190128J61.key'),
(39, 'Pass_Sat_demo', 'password SAT FIEL_demo\r\n', 2, '12345678a'),
(40, 'Usuario_Factura_demo', 'Usuario_Facturacion Yusa_demo\r\n\r\n\r\n\r\n', 2, 'DEMO700101XXX'),
(41, 'pass_fac_demo', 'password Facturacion Yusa_demo\r\n', 2, 'DEMO700101XXX'),
(42, 'Regimen_sat_demo', 'Regimen Fiscal SAT(MX)_demo', 2, '601'),
(43, 'Cliente_Frecuente', 'Cliente de Mostrador Ventas Generales', 2, 'Cliente Mostrador'),
(44, 'Saldo-Fact', 'Saldo Multifacturas', 5, '5'),
(45, 'Act_Vend', 'Activar Ingresar Vendedores', 2, 'SI'),
(46, 'Vasc_Config', 'Configuracion de Bascula', 2, '2,6,4,1');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `customer`
--
CREATE TABLE `customer` (
`id_cust` int(11) NOT NULL,
`name` varchar(40) NOT NULL,
`contract` varchar(20) DEFAULT NULL,
`colector_id` int(11) DEFAULT NULL,
`conyugue` varchar(100) DEFAULT NULL,
`direccion` varchar(100) DEFAULT NULL,
`come_in` varchar(100) DEFAULT NULL,
`credito` varchar(10) DEFAULT NULL,
`poblacion` varchar(40) DEFAULT NULL,
`phone` char(35) DEFAULT NULL,
`status` int(2) DEFAULT NULL,
`date_up` date DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `customer`
--
INSERT INTO `customer` (`id_cust`, `name`, `contract`, `colector_id`, `conyugue`, `direccion`, `come_in`, `credito`, `poblacion`, `phone`, `status`, `date_up`, `created_at`) VALUES
(164, 'MARIA DE LA ROSA MEDINA', '27345', 73, 'JOSE GONZALEZ AVILEZ', 'CALLE 5 106', 'NAVA Y IGNACIO ALLENDE', 'SI', 'ALLENDE COAH', '8621237519', NULL, NULL, '2024-05-17 01:51:21'),
(165, 'FERNANDA RODRIGUEZ QUIROZ', '25044', 71, 'ALEJANDRO LOPEZ BENAVENTE', 'LEONA VICARIO 611 SUR', 'FCO I MADERO Y COLEGIO MILITAR', 'SI', 'ALLENDE COAH', '8621108047', NULL, NULL, '2024-05-18 20:06:08'),
(166, 'ESTHER ROSALEZ GARCIA', '27919', 71, 'JOSE ANGEL TORREZ HERNANDEZ', 'TUEQUEZA 1430', 'MUTUALISMO Y ESMERALDA', 'SI', 'ALLENDE COAH', '8621107955', NULL, NULL, '2024-05-18 21:48:30'),
(167, 'MELIZA CRUZ REYES', '27362', 86, 'VIUDA', 'SINALOA S/N', 'JOSE TREVIÑA Y CARRETERA 57', '', 'RIO BRAVO ', '8621247045', NULL, NULL, '2024-05-20 20:32:12'),
(168, 'SAN JUANA MEJIA ZAPATA', '26436', 71, 'SOLTERA', 'NOGUERAL 1503', 'NOGAL Y ENCINO', 'SI', 'ALLENDE COAH', '8621102148', NULL, NULL, '2024-05-20 21:28:04'),
(169, 'GLENDA YESENIA HERNANDEZ CERVANTES', '26288', 71, 'HECTOR RAUL MARTINEZ AGUILAR', 'CENTRAL 491', 'CARRANZA', 'SI', 'ALLENDE COAH', '8621095771', NULL, NULL, '2024-05-21 00:30:41');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `customer_terminated`
--
CREATE TABLE `customer_terminated` (
`id` int(11) NOT NULL,
`contract` int(11) NOT NULL,
`reason` varchar(250) NOT NULL,
`created_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `customer_terminated`
--
INSERT INTO `customer_terminated` (`id`, `contract`, `reason`, `created_at`) VALUES
(1, 27011, 'MERCANCIA', '2024-04-01');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `d`
--
CREATE TABLE `d` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `d`
--
INSERT INTO `d` (`id`, `name`) VALUES
(1, 'Entregado'),
(2, 'Pendiente'),
(3, 'Cancelado'),
(4, 'Entregado'),
(5, 'Pendiente'),
(6, 'Cancelado');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `data`
--
CREATE TABLE `data` (
`data_id` int(11) NOT NULL,
`data_date` timestamp NOT NULL DEFAULT current_timestamp(),
`data_temp` float(4,2) NOT NULL,
`data_hum` int(3) NOT NULL,
`data_device_sn` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `dev`
--
CREATE TABLE `dev` (
`person_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`operation_type_id` int(11) DEFAULT 2,
`box_id` int(11) DEFAULT NULL,
`p_id` int(11) DEFAULT NULL,
`d_id` int(11) DEFAULT NULL,
`total` double DEFAULT NULL,
`cash` double DEFAULT NULL,
`iva` double DEFAULT NULL,
`discount` double DEFAULT NULL,
`is_draft` tinyint(1) NOT NULL DEFAULT 0,
`stock_to_id` int(11) DEFAULT NULL,
`stock_from_id` int(11) DEFAULT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `dev`
--
INSERT INTO `dev` (`person_id`, `user_id`, `operation_type_id`, `box_id`, `p_id`, `d_id`, `total`, `cash`, `iva`, `discount`, `is_draft`, `stock_to_id`, `stock_from_id`, `created_at`) VALUES
(NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '2017-05-29 18:35:44'),
(NULL, 4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '2020-05-27 21:19:36');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `dev1`
--
CREATE TABLE `dev1` (
`id` int(11) NOT NULL,
`person_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`operation_type_id` int(11) DEFAULT 2,
`box_id` int(11) DEFAULT NULL,
`p_id` int(11) DEFAULT NULL,
`d_id` int(11) DEFAULT NULL,
`total` decimal(10,2) DEFAULT NULL,
`cash` decimal(10,2) DEFAULT NULL,
`iva` decimal(10,2) DEFAULT NULL,
`discount` decimal(10,2) DEFAULT NULL,
`is_draft` tinyint(1) NOT NULL DEFAULT 0,
`stock_to_id` int(11) DEFAULT NULL,
`stock_from_id` int(11) DEFAULT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `dev1`
--
INSERT INTO `dev1` (`id`, `person_id`, `user_id`, `operation_type_id`, `box_id`, `p_id`, `d_id`, `total`, `cash`, `iva`, `discount`, `is_draft`, `stock_to_id`, `stock_from_id`, `created_at`) VALUES
(1, NULL, 6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '2021-01-07 08:46:41'),
(6, NULL, 6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '2021-05-03 18:28:14');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `devices`
--
CREATE TABLE `devices` (
`device_id` int(7) UNSIGNED NOT NULL,
`device_user_id` int(7) DEFAULT NULL,
`device_date` timestamp NULL DEFAULT current_timestamp(),
`device_alias` varchar(50) DEFAULT '',
`device_sn` int(7) DEFAULT NULL,
`device_topic` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `devices`
--
INSERT INTO `devices` (`device_id`, `device_user_id`, `device_date`, `device_alias`, `device_sn`, `device_topic`) VALUES
(1, 3, '2021-01-12 07:11:15', 'torrreon', 12345, 'JxKhHlLJdG');
-- --------------------------------------------------------
--
-- Estructura Stand-in para la vista `devices_full`
-- (Véase abajo para la vista actual)
--
CREATE TABLE `devices_full` (
`data_id` int(11)
,`data_date` timestamp
,`data_temp` float(4,2)
,`data_hum` int(3)
,`data_device_sn` varchar(10)
,`device_id` int(7) unsigned
);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `employee`
--
CREATE TABLE `employee` (
`id_cust` int(11) NOT NULL,
`name` varchar(40) NOT NULL,
`contract` int(11) NOT NULL,
`Sueldo` decimal(14,2) DEFAULT NULL,
`direccion` varchar(250) DEFAULT NULL,
`come_in` varchar(200) DEFAULT NULL,
`id_ruta` int(11) DEFAULT 2,
`route_id` int(11) DEFAULT NULL,
`poblacion` varchar(40) DEFAULT NULL,
`phone` char(35) DEFAULT NULL,
`id_puesto` int(11) NOT NULL DEFAULT 1,
`status` int(11) DEFAULT 1,
`dateUp` date DEFAULT NULL,
`dateBaja` date DEFAULT NULL,
`dateReUp` date DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`date_emp` date DEFAULT '2022-07-01'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `employee`
--
INSERT INTO `employee` (`id_cust`, `name`, `contract`, `Sueldo`, `direccion`, `come_in`, `id_ruta`, `route_id`, `poblacion`, `phone`, `id_puesto`, `status`, `dateUp`, `dateBaja`, `dateReUp`, `created_at`, `date_emp`) VALUES
(53, 'PEDRO PLACIDO DE HOYOS GUERRA', 1, NULL, NULL, NULL, 6, 11, 'javier mina', '8621090747', 1, 1, '2011-05-09', NULL, NULL, '2024-03-22 04:40:08', '2024-03-16'),
(54, 'OLGA LETICIA CARDONA RAMIREZ', 2, NULL, NULL, NULL, 1, NULL, 'JAVIER MINA', '8621272786', 1, 1, '2011-05-09', NULL, NULL, '2024-03-16 06:05:01', '2024-03-04'),
(55, 'FRANCISCO J. DE HOYOS GUERRA ', 3, NULL, NULL, NULL, 6, NULL, 'ALLENDE COAH ', '8661325345', 1, 1, '2012-08-09', NULL, NULL, '2024-03-16 06:43:02', '2024-03-14'),
(57, 'MARIA DE LA LUZ MARTINEZ SALAZAR ', 5, NULL, NULL, NULL, 1, NULL, 'ALLENDE COAH ', '8626294228', 1, 1, '2014-09-04', NULL, NULL, '2024-03-16 06:25:57', '2023-10-11'),
(58, 'JUAN PABLO FUENTES ENRIQUEZ', 6, NULL, NULL, NULL, 2, NULL, 'ALLENDE COAH ', '8621207841', 2, 1, '2016-10-01', NULL, NULL, '2024-03-16 06:43:10', '2024-03-13'),
(59, 'LEONEL S. HERNANDEZ SANCHEZ', 7, NULL, NULL, NULL, 4, NULL, 'ALLENDE COAH ', '8621245936', 3, 1, '2019-08-26', NULL, NULL, '2024-03-15 03:03:03', '2024-03-14'),
(61, 'RICARDO A. ARENAS DE HOYOS', 9, NULL, NULL, NULL, 2, 1, 'ALLENDE COAH ', '8781398278', 2, 1, '2023-01-21', NULL, NULL, '2024-03-20 16:56:02', '2024-03-14'),
(62, 'JOSE JAVIER ROSAS HUERTA ', 10, NULL, NULL, NULL, 3, NULL, 'NAVA COAH', '8132334000', 3, 1, '2023-07-01', NULL, NULL, '2024-04-15 18:12:41', '2024-04-15'),
(63, 'JOSE AGUSTIN CRUZ BARRIENTOS', 11, NULL, NULL, NULL, 2, 5, 'ZARAGOZA ', '8782108758', 2, 1, '2023-05-23', NULL, NULL, '2024-03-18 19:17:24', '2023-10-28'),
(64, 'ALONDRA M. MARTINEZ HERNANDEZ', 12, NULL, NULL, NULL, 3, NULL, 'ALLENDE COAH ', '8621113185', 3, 1, '2023-09-20', NULL, NULL, '2024-03-15 03:04:32', '2024-03-14'),
(67, 'MARIELA G. MEDINA JUAREZ', 15, NULL, NULL, NULL, NULL, NULL, 'ALLENDE COAH ', '8626282293', 2, 0, '2023-11-17', '2024-03-21', NULL, '2024-04-11 01:08:12', '2024-04-10'),
(71, 'JORGE ARMANDO RIOJAS MENDOZA', 17, NULL, NULL, NULL, 2, 2, 'ZARAGOZA 63', '8781369579', 2, 1, '2024-01-17', NULL, NULL, '2024-03-18 19:12:31', '2024-02-19'),
(73, 'ALFONSO NICANOR MORENO ORTIZ', 21, NULL, NULL, NULL, 2, 12, 'ALLENDE COAH ', '8626294583', 2, 1, '2024-02-07', NULL, NULL, '2024-04-16 15:48:26', '2024-03-22'),
(74, 'PEDRO P.DE HOYOS CARDONA', 4, NULL, NULL, NULL, 5, 6, 'MINA 1102 PONT.', '8621099114', 1, 1, '2013-05-09', NULL, NULL, '2024-05-08 01:14:50', '2024-03-14'),
(83, 'FRANCISCO SANCHEZ PEREZ ', 22, NULL, NULL, NULL, NULL, NULL, 'OCAMPO 112', '8621107185', 2, 0, '2023-11-15', '2024-03-23', NULL, '2024-04-11 01:02:27', '2024-04-10'),
(86, 'ZARAGOZA GALAVIZ TORREZ', 23, NULL, NULL, NULL, 2, 4, 'NAVA 48 ', '8626288051', 2, 1, '2024-03-02', NULL, NULL, '2024-04-16 15:48:01', '2024-04-15'),
(87, 'JOSE ALFREDO LARA DOMINGUEZ', 24, NULL, NULL, NULL, NULL, NULL, 'DORA E, GARCIA ', '8781350193', 2, 0, '2024-04-10', '2024-04-21', NULL, '2024-05-08 01:11:20', '2024-05-07');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `employee_terminated`
--
CREATE TABLE `employee_terminated` (
`id` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`id_puesto` int(11) NOT NULL,
`reason` varchar(200) NOT NULL,
`created_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `employee_terminated`
--
INSERT INTO `employee_terminated` (`id`, `name`, `id_puesto`, `reason`, `created_at`) VALUES
(34, 'FRANCISCO SANCHEZ PEREZ ', 2, 'ABANDONO DE TRABAJO', '2024-03-23'),
(35, 'MARIELA G. MEDINA JUAREZ', 2, 'ABANDONO DE TRABAJO', '2024-03-21'),
(36, 'JOSE ALFREDO LARA DOMINGUEZ', 2, 'RENUNCIA', '2024-04-21');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `endorsement`
--
CREATE TABLE `endorsement` (
`id` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`relationship` varchar(15) DEFAULT NULL,
`colonia` varchar(20) DEFAULT NULL,
`direction` varchar(100) DEFAULT NULL,
`customer_id` int(11) NOT NULL,
`contract` int(11) DEFAULT NULL,
`country` varchar(100) DEFAULT NULL,
`phone` char(20) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `endorsement`
--
INSERT INTO `endorsement` (`id`, `name`, `relationship`, `colonia`, `direction`, `customer_id`, `contract`, `country`, `phone`, `created_at`) VALUES
(176, 'LAURA MEDINA SANDOVAL', 'MAMA', 'IGNACIO ALLENDE', 'COAHUILA 82', 0, 27345, 'ALLENDE', '8621254785', '2024-05-17 00:56:35'),
(177, 'FRANCISCA MEDINA ONOFRE', 'COMADRE', 'MANANTIAL', 'ALAMO', 0, 27345, 'ALLENDE', '8621254788', '2024-05-17 00:57:35'),
(178, 'NORMA PATRICIA ORTIZ', 'MAMA', 'PRINCIPAL', 'ALAMEDA 109', 161, 28307, 'ZARAGOZA COAH', '8626288474', '2024-05-17 01:10:20'),
(179, 'EFRAIN ORTIZ AGUILERA', 'TIO', 'PRINCIPAL', 'ALAMEDA 111', 161, 28307, 'ZARAGOZA COAH', '8621018905', '2024-05-17 01:12:56'),
(180, 'NORMA AGUILERA ORTIZ', 'MAMA', 'PRINCIPAL', 'ALAMEDA 107', 0, 28307, 'ZARAGOZA COAH', '8626287484', '2024-05-17 01:38:51'),
(181, 'EFRAIN ORTIZ AGUILERA', 'TIO', 'PRINCIPAL', 'ALAMEDA 111', 0, 28307, 'ZARAGOZA COAH', '8621018905', '2024-05-17 01:39:49'),
(182, 'LAURA MEDINA SANDOVAL', 'MAMA', 'AMP IGNACIO ALLENDE', 'COAHUILA 82', 163, 27345, 'ALLENDE,COAHUILA', '86271454584', '2024-05-17 01:52:57'),
(183, 'PETRA DE LA ROSA ', 'HERMANA ', 'IGNACIO ALLENDE', 'NAVA 85', 163, 27345, 'ALLENDE,COAHUILA', '8627458745', '2024-05-17 01:53:54'),
(184, 'PRICIA QUIROZ TELLEZ', 'MAMA', 'CENTRO', 'FCO I MADERO 512', 164, 25044, 'ALLENDE COAH', '8621107943', '2024-05-18 20:07:42'),
(185, 'VANESA QUIROZ TORREZ', 'TIA', 'CENTRO', 'ESCOBEDO Y CARRANZA', 164, 25044, 'ALLENDE COAH', '8621113550', '2024-05-18 20:08:33'),
(186, 'ESTHER GARCIA FRANCO', 'MAMA', 'CENTRO', 'MINA Y GOMEZ FARIAS', 165, 27919, 'ALLENDE COAH', '8626214381', '2024-05-18 21:49:58'),
(187, 'CONSUELO GARCIA FRANCO', 'TIA', 'CENTRO', 'MINA s/n', 165, 27919, 'ALLENDE COAH', '862623796', '2024-05-18 21:51:13'),
(188, 'SAN JUANA REYES RODRIGUEZ', 'MAMA', 'CENTRO', 'SINALOA S/N', 166, 27362, 'RIO BRAVO', '8621102372', '2024-05-18 22:01:56'),
(189, 'PABLO REYES RODRIGUEZ', 'HERMANO', 'CENTRO ', 'RIO BRAVO', 166, 27362, 'RIO BRAVO', '8621047842', '2024-05-20 20:28:55'),
(190, 'MANUEL PEREZ FLOREZ', 'PAPA', 'NOGALAR', 'NOGALERA 1501', 167, 26436, 'ALLENDE COAH', '8621091248', '2024-05-20 21:29:32'),
(191, 'MARTHA ZAPATA ARELLANO', 'MAMA', 'SAN TITO', 'ALLENDE COAH', 167, 26436, 'ALLENDE COAH', '8621452114', '2024-05-20 21:39:18'),
(192, 'NATALY ASENET TORREZ', 'HIJA', 'GRANJAS', 'SALTILLO 210', 168, 26288, 'ALLENDE COAH', '8621026332', '2024-05-21 00:32:27'),
(193, 'CONSUELO CERVANTES MORENO', 'MADRE', 'CENTRO', 'JAVIER MINA 305 PNT', 168, 26288, 'ALLENDE COAH', '9626213121', '2024-05-21 00:33:29');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `facturaok`
--
CREATE TABLE `facturaok` (
`id` int(11) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`barcode` varchar(50) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`name` varchar(50) NOT NULL,
`description` text NOT NULL,
`sell_id` int(11) NOT NULL,
`sale_id` char(10) NOT NULL,
`box_id` int(11) DEFAULT NULL,
`price_out` decimal(10,2) DEFAULT 0.00,
`iva` int(11) DEFAULT NULL,
`unit` varchar(255) NOT NULL,
`category_id` int(11) DEFAULT NULL,
`inventary_min` int(11) DEFAULT NULL,
`presentation` varchar(255) NOT NULL,
`user_id` int(11) NOT NULL,
`is_service` tinyint(1) NOT NULL DEFAULT 0,
`created_at` datetime NOT NULL,
`finish_at` datetime DEFAULT NULL,
`is_active` tinyint(1) DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `facturaok`
--
INSERT INTO `facturaok` (`id`, `image`, `barcode`, `person_id`, `name`, `description`, `sell_id`, `sale_id`, `box_id`, `price_out`, `iva`, `unit`, `category_id`, `inventary_min`, `presentation`, `user_id`, `is_service`, `created_at`, `finish_at`, `is_active`) VALUES
(1, 'bhereur@gmail.com', '1', NULL, 'ad778c5c-7cbd-4914-8992-827178eb7368', 'AAAI800508K2A', 5371, 'J210112007', NULL, '32.00', 16, '1', NULL, 0, 'ISRAEL ALVARADO AGUILAR', 6, 1, '2021-01-13 07:00:14', NULL, 1),
(6, 'syusa19802017@gmail.com', '1', NULL, 'e1ac8b53-0912-4dce-ad9d-289ccb8884f6', 'AAAI800508K2A', 5531, 'J210921003', NULL, '20.00', 16, '1', NULL, 0, 'ISRAEL ALVARADO AGUILAR', 6, 1, '2021-09-20 15:04:06', NULL, 1);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `formapago`
--
CREATE TABLE `formapago` (
`id` int(11) NOT NULL,
`def` varchar(5) NOT NULL,
`name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `formapago`
--
INSERT INTO `formapago` (`id`, `def`, `name`) VALUES
(1, '01', 'EFECTIVO'),
(2, '02', 'CHEQUE'),
(3, '03', 'TRANSFERENCIA ELECTRONICA'),
(4, '04', 'CREDITO');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `gpslocations`
--
CREATE TABLE `gpslocations` (
`GPSLocationID` int(10) UNSIGNED NOT NULL,
`lastUpdate` timestamp NOT NULL DEFAULT current_timestamp(),
`latitude` decimal(10,7) NOT NULL DEFAULT 0.0000000,
`longitude` decimal(10,7) NOT NULL DEFAULT 0.0000000,
`phoneNumber` varchar(50) NOT NULL DEFAULT '',
`userName` varchar(50) NOT NULL DEFAULT '',
`sessionID` varchar(50) NOT NULL DEFAULT '',
`speed` int(10) UNSIGNED NOT NULL DEFAULT 0,
`direction` int(10) UNSIGNED NOT NULL DEFAULT 0,
`distance` decimal(10,1) NOT NULL DEFAULT 0.0,
`gpsTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`locationMethod` varchar(50) NOT NULL DEFAULT '',
`accuracy` int(10) UNSIGNED NOT NULL DEFAULT 0,
`extraInfo` varchar(255) NOT NULL DEFAULT '',
`eventType` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `gpslocations`
--
INSERT INTO `gpslocations` (`GPSLocationID`, `lastUpdate`, `latitude`, `longitude`, `phoneNumber`, `userName`, `sessionID`, `speed`, `direction`, `distance`, `gpsTime`, `locationMethod`, `accuracy`, `extraInfo`, `eventType`) VALUES
(1, '2007-01-03 19:37:00', '47.6273270', '-122.3256910', 'gpsTracker3', 'gpsTracker3', '8BA21D90-3F90-407F-BAAE-800B04B1F5EB', 0, 0, '0.0', '2007-01-03 19:37:00', 'na', 137, 'na', 'gpsTracker'),
(2, '2007-01-03 19:38:00', '47.6072580', '-122.3300770', 'gpsTracker3', 'gpsTracker3', '8BA21D90-3F90-407F-BAAE-800B04B1F5EB', 0, 0, '0.0', '2007-01-03 19:38:00', 'na', 137, 'na', 'gpsTracker'),
(3, '2007-01-03 19:39:00', '47.6017030', '-122.3246700', 'gpsTracker3', 'gpsTracker3', '8BA21D90-3F90-407F-BAAE-800B04B1F5EB', 0, 0, '0.0', '2007-01-03 19:39:00', 'na', 137, 'na', 'gpsTracker'),
(4, '0000-00-00 00:00:00', '47.5937570', '-122.1950740', 'gpsTracker2', 'gpsTracker2', '8BA21D90-3F90-407F-BAAE-800B04B1F5EC', 0, 0, '0.0', '2007-01-03 19:40:00', 'na', 137, 'na', 'gpsTracker'),
(5, '2007-01-03 19:41:00', '47.6013970', '-122.1903530', 'gpsTracker2', 'gpsTracker2', '8BA21D90-3F90-407F-BAAE-800B04B1F5EC', 0, 0, '0.0', '2007-01-03 19:41:00', 'na', 137, 'na', 'gpsTracker'),
(6, '2007-01-03 19:42:00', '47.6100200', '-122.1906970', 'gpsTracker2', 'gpsTracker2', '8BA21D90-3F90-407F-BAAE-800B04B1F5EC', 0, 0, '0.0', '2007-01-03 19:42:00', 'na', 137, 'na', 'gpsTracker'),
(7, '2007-01-03 19:43:00', '47.6366310', '-122.2145580', 'gpsTracker1', 'gpsTracker1', '8BA21D90-3F90-407F-BAAE-800B04B1F5ED', 0, 0, '0.0', '2007-01-03 19:43:00', 'na', 137, 'na', 'gpsTracker'),
(8, '2007-01-03 19:44:00', '47.6379610', '-122.2017690', 'gpsTracker1', 'gpsTracker1', '8BA21D90-3F90-407F-BAAE-800B04B1F5ED', 0, 0, '0.0', '2007-01-03 19:44:00', 'na', 137, 'na', 'gpsTracker'),
(9, '2007-01-03 19:45:00', '47.6429350', '-122.2095790', 'gpsTracker1', 'gpsTracker1', '8BA21D90-3F90-407F-BAAE-800B04B1F5ED', 0, 0, '0.0', '2007-01-03 19:45:00', 'na', 137, 'na', 'gpsTracker');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `job1`
--
CREATE TABLE `job1` (
`id` int(11) NOT NULL,
`name_job` varchar(20) NOT NULL,
`laborOld` int(2) NOT NULL,
`salary` decimal(10,2) NOT NULL,
`endorsements_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`id_client` int(11) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `jobok`
--
CREATE TABLE `jobok` (
`id_cust` int(11) NOT NULL,
`name` varchar(40) NOT NULL,
`contract` varchar(20) NOT NULL,
`laborOld` int(2) DEFAULT NULL,
`laborOld_periodicity` int(11) DEFAULT NULL,
`salary` decimal(10,2) NOT NULL,
`payment_frequency` varchar(15) DEFAULT 'semanal' COMMENT '0=semanal\r\n1=catorcena\r\n2=quincena\r\n3=mensual',
`endorsenments1` int(11) NOT NULL,
`endorsenments2` int(11) NOT NULL,
`id_user` int(11) DEFAULT NULL,
`created_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `jobok`
--
INSERT INTO `jobok` (`id_cust`, `name`, `contract`, `laborOld`, `laborOld_periodicity`, `salary`, `payment_frequency`, `endorsenments1`, `endorsenments2`, `id_user`, `created_at`) VALUES
(87, 'FABRICA', '27345', 2, NULL, '2000.00', '1', 0, 0, 6, '2024-05-16'),
(88, 'FERROMEX', '25044', 1, NULL, '9000.00', '3', 0, 0, 6, '2024-05-18'),
(89, 'ALBAÑIL', '27919', 10, NULL, '2000.00', '1', 0, 0, 6, '2024-05-18'),
(90, 'PENCIONDA', '27362', 10, 0, '4500.00', '4', 0, 0, 6, '2024-05-18'),
(91, 'ALKOSA', '26436', 2, 0, '2000.00', '1', 0, 0, 6, '2024-05-20'),
(92, 'FABRICA', '26288', 3, NULL, '6000.00', '3', 0, 0, 6, '2024-05-20');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `listprice`
--
CREATE TABLE `listprice` (
`id` int(11) NOT NULL,
`productName` varchar(50) NOT NULL,
`id_prod` int(11) DEFAULT NULL,
`barcode` varchar(50) DEFAULT NULL,
`price_min` float NOT NULL,
`price_1` float DEFAULT NULL,
`price_2` float DEFAULT NULL,
`price_3` float DEFAULT NULL,
`price_4` float DEFAULT NULL,
`increment` decimal(3,2) DEFAULT NULL,
`description` text NOT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `listprice`
--
INSERT INTO `listprice` (`id`, `productName`, `id_prod`, `barcode`, `price_min`, `price_1`, `price_2`, `price_3`, `price_4`, `increment`, `description`, `created_at`) VALUES
(5, 'SACACORCHOS KITCHEN TOOL INCLUIDO ABRELATAS PICO M', 2527, 'S202', 24, 30, 20, 21, 22, NULL, '', '2020-08-19 01:55:01'),
(23, 'pulpa pulpa', 5424, '02', 96, 102, 78, 68, 90, NULL, '', '2021-05-08 17:31:11');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `message`
--
CREATE TABLE `message` (
`id` int(11) NOT NULL,
`code` varchar(255) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`user_from` int(11) NOT NULL,
`user_to` int(11) NOT NULL,
`is_read` tinyint(1) NOT NULL DEFAULT 0,
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `message`
--
INSERT INTO `message` (`id`, `code`, `message`, `user_from`, `user_to`, `is_read`, `created_at`) VALUES
(1, 'tzE0rTJVDydUho5', 'Hola que pasó con el inventario', 4, 2, 0, '2020-05-31 14:46:46'),
(2, 'sdaUPmZPB6IaaXr', 'addffadfadfafddaf', 4, 2, 0, '2020-07-16 04:54:17'),
(3, 'sdaUPmZPB6IaaXr', 'dsssdsdsf', 4, 2, 0, '2020-07-16 04:54:49'),
(4, 's46i3p9zg79naoY', 'holaaaaaaa', 4, 5, 0, '2020-12-28 22:57:44'),
(5, 'jGOp7aGvm6hsvCQ', 'HOLA\r\n', 6, 2, 0, '2021-01-26 11:33:02'),
(6, 'kYf7MTZmFY6fKz3', 'hola hay qye decir que hacer la nomina de edta semana de sept 21', 6, 1, 0, '2021-09-17 14:17:11');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_item`
--
CREATE TABLE `m_item` (
`id_item` varchar(6) NOT NULL,
`item_name` varchar(100) DEFAULT NULL,
`barcode` varchar(50) DEFAULT NULL,
`note` decimal(14,2) NOT NULL,
`stock` decimal(10,0) DEFAULT 0,
`price` decimal(10,2) NOT NULL DEFAULT 0.00,
`fixed_cost` decimal(10,2) NOT NULL DEFAULT 30.00,
`unit` varchar(4) DEFAULT 'PCS',
`status` int(11) DEFAULT NULL,
`category_id` int(2) DEFAULT 1,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`date_down` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `m_item`
--
INSERT INTO `m_item` (`id_item`, `item_name`, `barcode`, `note`, `stock`, `price`, `fixed_cost`, `unit`, `status`, `category_id`, `created_at`, `date_down`) VALUES
('PB0009', 'JUEGO DE SABANAS MATRIMONIAL', 'JUSAM', '708.50', '99', '1090.00', '30.00', 'PZA', NULL, 2, '2024-05-07 20:20:08', NULL),
('PB0008', 'LICUADORA HAMILTON', 'LIHA', '1423.50', '100', '2190.00', '30.00', 'PZA', NULL, 7, '2023-10-14 18:26:43', NULL),
('PB0007', 'CAZO GUINDO 45', 'CAG45', '1163.50', '150', '1790.00', '30.00', 'PZA', NULL, 1, '2023-10-14 18:25:20', NULL),
('PB0006', 'VAPORERA 90', 'VA90', '1287.00', '150', '1980.00', '30.00', 'PZA', NULL, 1, '2023-10-14 18:24:05', NULL),
('PB0005', 'VAPORERA 70', 'VA70', '1358.50', '150', '2090.00', '30.00', 'PZA', NULL, 1, '2023-11-05 18:04:12', NULL),
('PB0004', 'VAPORERA 45', 'VA45', '708.50', '149', '1090.00', '30.00', 'PZA', NULL, 1, '2024-05-03 21:35:26', NULL),
('PB0003', 'JUEGO DE MAYA GUINDO 45', 'JUMAG', '2392.00', '100', '3680.00', '30.00', 'JGO', NULL, 1, '2023-10-14 18:18:01', NULL),
('PB0002', 'JUEGO DE VAPORERAS GUINDO 34', 'JUVAMG', '1937.00', '100', '2980.00', '30.00', 'JGO', NULL, 1, '2023-10-14 21:12:16', NULL),
('PB0001', 'JGO DE SARTENES KUN FU MASTHER', 'JUSAKM', '1878.50', '0', '2890.00', '30.00', 'JGO', NULL, 1, '2024-05-18 21:53:30', NULL),
('PB0010', 'JUEGO DE SABANAS KZ', 'JUSAK', '838.50', '100', '1290.00', '30.00', 'PZA', NULL, 2, '2023-10-14 18:29:52', NULL),
('PB0011', 'JUEGO DE CORTINAS DE ORGANZA', 'JUCOO', '448.50', '100', '690.00', '30.00', 'PZA', NULL, 2, '2023-10-14 18:30:50', NULL),
('PB0012', 'JUEGO DE CORTINAS DE ENCAJE', 'JUCOE', '383.50', '100', '590.00', '30.00', 'PZA', NULL, 2, '2023-10-14 18:31:45', NULL),
('PB0013', 'JUEGO CORTINAS BLAK AUT', 'JUCOB', '708.50', '100', '1090.00', '30.00', 'PZA', NULL, 2, '2023-10-14 18:32:43', NULL),
('PB0014', 'JUEGO CORTINAS JACKARD', 'JUCOJ', '383.50', '100', '590.00', '30.00', 'PZA', NULL, 2, '2023-10-14 18:34:08', NULL),
('PB0015', 'CORTINAS DE COSINA', 'CODC', '253.50', '50', '390.00', '30.00', 'PZA', NULL, 2, '2023-10-14 18:34:56', NULL),
('PB0016', 'COBERTOR CUNERO PROVIDENCIA', 'COCUP', '578.50', '99', '890.00', '30.00', 'PZA', NULL, 2, '2023-11-03 17:15:47', NULL),
('PB0017', 'COBERTOR INDIVIDUAL PROVIDENCIA', 'COINP', '773.50', '198', '1190.00', '30.00', 'PZA', NULL, 2, '2024-05-03 21:38:24', NULL),
('PB0018', 'COBERTOR MATRIMONIAL PROVIDENCIA', 'COMAP', '1157.00', '199', '1780.00', '30.00', 'PZA', NULL, 2, '2024-05-08 13:19:59', NULL),
('PB0019', 'COBERTOR KING SIZE PROVIDENCIA', 'COKIP', '1488.50', '250', '2290.00', '30.00', 'PZA', NULL, 2, '2023-10-14 18:40:33', NULL),
('PB0020', 'COBERTOR KING SIZE MONARCA', 'COKIM', '1488.50', '143', '2290.00', '30.00', 'PZA', NULL, 2, '2024-05-17 01:41:46', NULL),
('PB0021', 'CLOSET HERCULES', 'CLOHE', '14618.50', '31', '22490.00', '30.00', 'PZA', NULL, 3, '2024-05-21 00:22:51', NULL),
('PB0022', 'CLOSET KING KON', 'CLOKIK', '12337.00', '50', '18980.00', '30.00', 'PZA', NULL, 3, '2023-10-14 18:46:12', NULL),
('PB0023', 'CLOSET NAPOLES MIEL', 'CLONAM', '9477.00', '170', '14580.00', '30.00', 'PZA', NULL, 3, '2024-05-21 00:18:36', NULL),
('PB0024', 'CLOSET NAPOLES CHOCO', 'CLONACH', '9737.00', '148', '14980.00', '30.00', 'PZA', NULL, 3, '2023-11-21 06:12:05', NULL),
('PB0025', 'CLOSET PUERTAS CORREDIZAS', 'CLOPUC', '7338.50', '50', '11290.00', '30.00', 'PZA', NULL, 3, '2023-10-14 18:49:16', NULL),
('PB0026', 'ROPERO TORREON MIEL', 'ROTOM', '6428.50', '31', '9890.00', '30.00', 'PZA', NULL, 3, '2024-04-02 21:25:58', NULL),
('PB0027', 'ROPERO TORREON CHOCO', 'ROTOCH', '6428.50', '20', '9890.00', '30.00', 'PZA', NULL, 3, '2024-05-21 00:08:42', NULL),
('PB0028', 'CAJONERA ELISA 6 CAJONES', 'CAEL6', '5583.50', '52', '8590.00', '30.00', 'PZA', NULL, 3, '2024-05-21 00:22:04', NULL),
('PB0029', 'CAJONERA INFANTIL EVELIN NIÑO', 'CAINEN', '4998.50', '50', '7690.00', '30.00', 'PZA', NULL, 3, '2023-10-14 18:55:07', NULL),
('PB0030', 'CAJONERA INFANTIL EVELIN NIÑA', 'CAIEÑ', '4998.50', '50', '7690.00', '30.00', 'PZA', NULL, 3, '2023-10-14 21:08:13', NULL),
('PB0031', 'COMODA INGLATERRA', 'COIN', '5648.50', '49', '8690.00', '30.00', 'PZA', NULL, 3, '2024-05-08 13:20:00', NULL),
('PB0032', 'ALACENA CHICA MIEL', 'ALCHM', '5453.50', '100', '8390.00', '30.00', 'PZA', NULL, 3, '2023-10-14 18:57:43', NULL),
('PB0033', 'ALACENA CHICA CHOCO', 'ALCHCH', '5518.50', '100', '8490.00', '30.00', 'PZA', NULL, 3, '2023-10-14 18:58:37', NULL),
('PB0034', 'ALACENA ANDREA', 'ALAN', '7338.50', '48', '11290.00', '30.00', 'PZA', NULL, 3, '2024-05-20 21:20:33', NULL),
('PB0035', 'ALACENA ANDREA DOBLE', 'ALAND', '9542.00', '30', '14680.00', '30.00', 'PZA', NULL, 3, '2024-03-27 06:19:22', NULL),
('PB0036', 'VITRINA CHICA MIEL', 'VICHM', '5778.50', '50', '8890.00', '30.00', 'PZA', NULL, 3, '2023-10-14 19:00:50', NULL),
('PB0037', 'PORTAMICRO MIEL', 'POMIE', '5128.50', '150', '7890.00', '30.00', 'PZA', NULL, 0, '2023-10-21 22:17:45', NULL),
('PB0038', 'PORTAMICRO CHOCO', 'POCH', '5317.00', '47', '8180.00', '30.00', 'PZA', NULL, 0, '2024-05-18 20:11:26', NULL),
('PB0039', 'COSINETA MIEL ', 'COMI', '4868.50', '100', '7490.00', '30.00', 'PZA', NULL, 3, '2023-10-14 19:03:54', NULL),
('PB0040', 'COSINETA CHOCO', 'COCH', '5063.50', '149', '7790.00', '30.00', 'PZA', NULL, 3, '2024-05-07 18:51:17', NULL),
('PB0041', 'CENTRO SUIZA', 'CESU', '2268.50', '100', '3490.00', '30.00', 'PZA', NULL, 3, '2023-10-14 19:05:20', NULL),
('PB0042', 'ESPEJO HOLIWOD', 'ESHW', '5187.00', '150', '7980.00', '30.00', 'PZA', NULL, 3, '2023-10-14 19:06:09', NULL),
('PB0043', 'ESPEJO HOLANDA', 'ESHO', '4862.00', '149', '7480.00', '30.00', 'PZA', NULL, 3, '2024-05-21 00:37:30', NULL),
('PB0044', 'PEINADOR FAVY', 'PEFA', '4927.00', '99', '7580.00', '30.00', 'PZA', NULL, 3, '2024-05-09 01:39:45', NULL),
('PB0045', 'VANYTY CHICO', 'VACH', '5583.50', '19', '8590.00', '30.00', 'PZA', NULL, 3, '2024-05-03 17:33:15', NULL),
('PB0046', 'VANYTY GRANDE', 'VAGR', '6558.50', '20', '10090.00', '30.00', 'PZA', NULL, 3, '2023-10-14 19:09:21', NULL),
('PB0047', 'ESPEJO ZAPATERO HOLIWOD', 'ESZAH', '6292.00', '100', '9680.00', '30.00', 'PZA', NULL, 3, '2023-10-14 19:10:29', NULL),
('PB0048', 'COLCHON INDIVIDUAL SENCILLO HOTELERO', 'COINS', '3692.00', '150', '5680.00', '30.00', 'PZA', NULL, 4, '2023-10-14 19:16:51', NULL),
('PB0049', 'COLCHO MATRIMONIAL SENCILLO HOTELERO', 'COMAS', '4992.00', '200', '7680.00', '30.00', 'PZA', NULL, 4, '2023-10-14 19:17:44', NULL),
('PB0050', 'COLCHON INDIVIDUAL 2 COLCH MILAN', 'COIN2M', '4862.00', '200', '7480.00', '30.00', 'PZA', NULL, 4, '2023-10-14 19:19:20', NULL),
('PB0051', 'COLCHO MATRIMONIAL 2 COLCHMILAN', 'COMA2M', '6487.00', '195', '9980.00', '30.00', 'PZA', NULL, 4, '2024-05-18 22:05:33', NULL),
('PB0052', 'COLCHON QUEEN 2 COLCH MILAN ', 'COQ2M', '7137.00', '150', '10980.00', '30.00', 'PZA', NULL, 4, '2023-10-14 19:21:51', NULL),
('PB0053', 'COLCHON KING SIZE 2 COLCH MILAN', 'COKI2M', '9737.00', '200', '14980.00', '30.00', 'PZA', NULL, 4, '2023-10-14 19:23:13', NULL),
('PB0054', 'BASE INDIVIDUAL', 'BAIN', '3048.50', '100', '4690.00', '30.00', 'PZA', NULL, 4, '2023-10-14 20:05:47', NULL),
('PB0055', 'BASE MATRIMONIAL', 'BAMA', '3243.50', '200', '4990.00', '30.00', 'PZA', NULL, 4, '2023-10-14 20:06:36', NULL),
('PB0056', 'BASE QUEEN', 'BAQU', '3503.50', '150', '5390.00', '30.00', 'PZA', NULL, 4, '2023-10-14 20:07:12', NULL),
('PB0057', 'JGO DE BASES KING SIZE', 'JUBAK', '6363.50', '150', '9790.00', '30.00', 'JGO', NULL, 4, '2023-10-14 20:08:16', NULL),
('PB0058', 'BASE CANGURO MATRIMONIAL', 'BACAM', '8307.00', '20', '12780.00', '30.00', 'PZA', NULL, 4, '2023-10-14 20:09:32', NULL),
('PB0059', 'BASE CANGURO INDIVIDUAL', 'BACAI', '7137.00', '20', '10980.00', '30.00', 'PZA', NULL, 4, '2023-10-14 20:10:33', NULL),
('PB0060', 'SALA LORENA', 'SAL', '8963.50', '50', '13790.00', '30.00', 'PZA', NULL, 12, '2023-11-05 18:01:36', NULL),
('PB0061', 'SALA VICTORIA', 'SAV', '7468.50', '28', '11490.00', '30.00', 'JGO', NULL, 12, '2024-05-17 01:58:00', NULL),
('PB0062', 'SALA ESTEFANIA', 'SAES', '8508.50', '18', '13090.00', '30.00', 'JGO', NULL, 12, '2024-05-07 20:17:03', NULL),
('PB0063', 'SALA IRIS 321', 'SAI3', '14358.50', '29', '22090.00', '30.00', 'JGO', NULL, 12, '2023-11-05 18:01:17', NULL),
('PB0064', 'COMEDOR MADERA 6 SILLAS', 'COMA6', '12337.00', '30', '18980.00', '30.00', 'JGO', NULL, 6, '2023-10-14 20:27:05', NULL),
('PB0065', 'COMEDOR MADERA 4 SILLAS', 'COMA4', '10198.50', '30', '15690.00', '30.00', 'JGO', NULL, 6, '2023-10-14 20:23:53', NULL),
('PB0066', 'BOSINA QFX 8', 'BOQ8', '1287.00', '120', '1980.00', '30.00', 'PZA', NULL, 7, '2024-05-21 00:19:16', NULL),
('PB0067', 'BOSINA QFX 12', 'BOQ12', '2983.50', '70', '4290.00', '30.00', 'PZA', NULL, 7, '2024-05-21 00:21:28', NULL),
('PB0068', 'BOSINA QFX 15', 'BOQ15', '4868.50', '160', '7980.00', '30.00', 'PZA', NULL, 7, '2024-05-21 00:18:02', NULL),
('PB0069', 'BOILER DE PASO CINSA', 'BODPC', '1878.50', '48', '2890.00', '30.00', 'PZA', NULL, 8, '2024-04-01 22:54:19', NULL),
('PB0070', 'BOILER GUARDIAN 40L', 'BOGU', '4478.50', '50', '6890.00', '30.00', 'PZA', NULL, 8, '2023-10-14 20:34:26', NULL),
('PB0071', 'MINISPLIT PRIME 110 2 TIEMPOS', 'MIP22', '10387.00', '50', '15980.00', '30.00', 'PZA', NULL, 9, '2024-05-09 18:08:45', NULL),
('PB0072', 'ABANICO DE PEDESTAL DE FIERRO', 'ABDP', '1813.50', '59', '2790.00', '30.00', 'PZA', NULL, 9, '2024-05-21 00:20:08', NULL),
('PB0073', 'ABANICO DE PISO MAN', 'ABDPM', '1683.50', '195', '2590.00', '30.00', 'PZA', NULL, 9, '2024-05-20 21:07:27', NULL),
('PB0074', 'MESA XTAGARAFON', 'MEXGA', '1547.00', '100', '2380.00', '30.00', 'PZA', NULL, 10, '2023-10-14 21:16:14', NULL),
('PB0075', 'MESA MULTUSOS ', 'MEMU', '1553.50', '150', '2390.00', '30.00', 'PZA', NULL, 10, '2023-10-14 20:41:20', NULL),
('PB0076', 'MUEBLE PARA BAÑO', 'MUPB', '1228.50', '200', '1890.00', '30.00', 'PZA', NULL, 10, '2023-10-14 20:42:07', NULL),
('PB0077', 'MUEBLE P/BAÑO BOTIQUIN', 'MUPBO', '1807.00', '100', '2780.00', '30.00', 'PZA', NULL, 10, '2023-10-14 20:44:26', NULL),
('PB0078', 'JGO DE BANCOS ', 'JUBA', '1748.50', '30', '2690.00', '30.00', 'JGO', NULL, 10, '2023-10-14 20:45:47', NULL),
('PB0079', 'FRUTERO', 'FRUT', '1813.50', '100', '2790.00', '30.00', 'PZA', NULL, 10, '2023-10-14 20:46:28', NULL),
('PB0080', 'JGO DE MESEDORAS MAYA', 'JUMEM', '2528.50', '299', '3890.00', '30.00', 'JGO', NULL, 11, '2024-04-02 03:40:17', NULL),
('PB0081', 'BANCA MAYA ', 'BAM', '1228.50', '50', '1890.00', '30.00', 'PZA', NULL, 11, '2023-10-14 20:48:43', NULL),
('PB0082', 'MESA DE JARDIN MAYA ', 'MEDJM', '1228.50', '100', '1890.00', '30.00', 'PZA', NULL, 11, '2023-10-14 20:49:40', NULL),
('PB0083', 'JGO DE JARDIN MAYA', 'JUJAM', '3757.00', '100', '5780.00', '30.00', 'JGO', NULL, 11, '2023-10-14 20:50:54', NULL),
('PB0084', 'JGO DE MESEDORA ROYAL ', 'JUMR', '3172.00', '30', '4880.00', '30.00', 'JGO', NULL, 11, '2023-10-14 20:51:57', NULL),
('PB0085', 'JGO DE MESDORA INFANTIL ', 'JUMEI', '1683.50', '50', '2590.00', '30.00', 'JGO', NULL, 11, '2023-10-14 20:53:18', NULL),
('PB0086', 'BAÑERA CHICA', 'BACH', '838.50', '50', '1290.00', '30.00', 'PZA', NULL, 21, '2023-11-05 04:44:24', NULL),
('PB0087', 'BAÑERA GRANDE', 'BAGR', '2073.50', '150', '3190.00', '30.00', 'PZA', NULL, 21, '2023-11-05 04:44:43', NULL),
('PB0088', 'ARROCERA 30', 'AR30', '767.00', '20', '1180.00', '30.00', 'PZA', NULL, 1, '2023-10-14 20:55:45', NULL),
('PB0089', 'ARROCERA 34', 'AR34', '1092.00', '20', '1680.00', '30.00', 'PZA', NULL, 1, '2023-10-14 20:56:24', NULL),
('PB0090', 'ARROCERA 40', 'AR40', '1157.00', '30', '1780.00', '30.00', 'PZA', NULL, 1, '2023-10-14 20:56:58', NULL),
('PB0091', 'ARROCERA 50', 'AR50', '2073.50', '30', '3190.00', '30.00', 'PZA', NULL, 1, '2023-10-14 20:57:49', NULL),
('PB0092', 'BAUL INFANTIL', 'BAINF', '1358.50', '30', '2090.00', '30.00', 'PZA', NULL, 21, '2023-11-05 04:42:45', NULL),
('PB0093', 'PLASMA HEISEN 32', 'PLH32', '5837.00', '40', '8290.00', '30.00', 'PZA', NULL, 7, '2024-05-21 00:23:26', NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `m_user`
--
CREATE TABLE `m_user` (
`id_user` int(11) NOT NULL,
`username` varchar(20) NOT NULL,
`pass_user` char(50) NOT NULL,
`h_menu` varchar(254) DEFAULT NULL,
`uniq_login` varchar(15) DEFAULT NULL,
`stock_id` int(11) NOT NULL DEFAULT 1,
`employee_id` int(11) DEFAULT NULL,
`kind` int(11) DEFAULT NULL COMMENT '1-gerencia\r\n2-supvervisor de ventas\r\n3-cobrador\r\n4-secretaria\r\n5-ventas\r\n'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `m_user`
--
INSERT INTO `m_user` (`id_user`, `username`, `pass_user`, `h_menu`, `uniq_login`, `stock_id`, `employee_id`, `kind`) VALUES
(2, 'PABLO23', '827ccb0eea8a706c4c34a16891f84e7b', '7,2,6', NULL, 1, 58, 3),
(6, 'PEDRO74', '202cb962ac59075b964b07152d234b70', '4,1,7,2,5,3,6,8,9,10', '58f72048cc33114', 1, 53, 1),
(8, 'RICARDO23', '202cb962ac59075b964b07152d234b70', '4,1,7,2,5,3,6', NULL, 2, 61, 3),
(9, 'cobrador2', '202cb962ac59075b964b07152d234b70', '4,1,7,2,5,6,8', NULL, 3, NULL, 3),
(10, 'cobrador3', '202cb962ac59075b964b07152d234b70', '7,2', NULL, 4, NULL, 3),
(11, 'ARMANDO', 'e10adc3949ba59abbe56e057f20f883e', '7,9', NULL, 1, NULL, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `operation`
--
CREATE TABLE `operation` (
`id` int(11) NOT NULL,
`sale_id` varchar(10) DEFAULT NULL,
`product_id` int(11) NOT NULL,
`barcode` varchar(50) DEFAULT NULL,
`stock_id` int(11) NOT NULL,
`stock_destination_id` int(11) DEFAULT NULL,
`q` float NOT NULL,
`price_in` double DEFAULT NULL,
`price_out` double DEFAULT NULL,
`operation_type_id` int(11) NOT NULL,
`descX1` double DEFAULT NULL,
`sell_id` int(11) DEFAULT NULL,
`dev_id` int(11) DEFAULT NULL,
`is_draft` tinyint(1) NOT NULL DEFAULT 0,
`name_ajuste` varchar(20) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `operation2`
--
CREATE TABLE `operation2` (
`id` int(11) NOT NULL,
`product_id` int(11) DEFAULT NULL,
`barcode` varchar(50) DEFAULT NULL,
`stock_id` int(11) NOT NULL,
`stock_destination_id` int(11) DEFAULT NULL,
`q` float NOT NULL,
`price_in` double DEFAULT NULL,
`price_out` double DEFAULT NULL,
`operation_type_id` int(11) NOT NULL,
`sell_id` int(11) DEFAULT NULL,
`re_id` int(11) DEFAULT NULL,
`is_draft` tinyint(1) NOT NULL DEFAULT 0,
`name_ajuste` varchar(20) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `operation_type`
--
CREATE TABLE `operation_type` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `operation_type`
--
INSERT INTO `operation_type` (`id`, `name`) VALUES
(1, 'entrada'),
(2, 'salida'),
(3, 'entrada-pendiente'),
(4, 'salida-pendiente'),
(5, 'devolucion'),
(6, 'traspaso'),
(7, 'inventario inicial'),
(8, 'entrada-reparto'),
(9, 'salida-reparto'),
(10, 'entrada-pendiente'),
(11, 'salida-pendiente'),
(12, 'devolucion-reparto'),
(13, 'traspaso-reparto');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `p`
--
CREATE TABLE `p` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `p`
--
INSERT INTO `p` (`id`, `name`) VALUES
(1, 'Pagado'),
(2, 'Pendiente'),
(3, 'Cancelado'),
(4, 'Credito'),
(5, 'Pagado'),
(6, 'Pendiente'),
(7, 'Cancelado'),
(8, 'Credito');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `payment`
--
CREATE TABLE `payment` (
`id` int(11) NOT NULL,
`payment_type_id` int(11) NOT NULL,
`sale_id` char(11) DEFAULT NULL,
`person_id` int(11) NOT NULL,
`week` int(3) DEFAULT NULL,
`val` double DEFAULT NULL,
`pay_date` datetime DEFAULT NULL,
`id_collector` int(11) DEFAULT NULL,
`programmed` tinyint(1) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `payment`
--
INSERT INTO `payment` (`id`, `payment_type_id`, `sale_id`, `person_id`, `week`, `val`, `pay_date`, `id_collector`, `programmed`, `created_at`) VALUES
(108, 1, 'J231207001', 25044, NULL, 400, NULL, NULL, 1, '2024-05-20 15:54:53'),
(110, 1, 'J240518001', 27919, NULL, 150, NULL, NULL, NULL, '2024-05-18 21:53:30'),
(112, 1, 'J240517001', 27362, NULL, 250, NULL, NULL, 1, '2024-05-20 15:55:43'),
(113, 2, NULL, 27919, NULL, -100, '2024-05-20 00:00:00', 0, NULL, '2024-05-20 04:56:35'),
(119, 2, NULL, 25044, NULL, 560, '2023-12-28 00:00:00', NULL, 1, '2024-05-20 21:19:46'),
(120, 1, 'J231207002', 25044, NULL, 560, NULL, NULL, NULL, '2024-05-20 21:20:33'),
(122, 2, NULL, 27919, NULL, -100, '2024-05-20 00:00:00', 0, NULL, '2024-05-20 21:48:13'),
(123, 1, 'J221007001', 26436, NULL, 450, NULL, NULL, NULL, '2024-05-21 00:08:42'),
(124, 2, NULL, 26288, NULL, 300, '2022-05-01 00:00:00', NULL, 1, '2024-05-21 01:39:56'),
(125, 2, NULL, 26288, NULL, 300, '2022-08-01 00:00:00', NULL, 1, '2024-05-21 01:39:52'),
(126, 2, 'J220719001', 26288, NULL, 300, NULL, NULL, 1, '2024-05-21 01:39:27'),
(127, 2, NULL, 27919, NULL, -200, '2024-05-21 00:00:00', 0, NULL, '2024-05-21 00:49:35'),
(128, 2, NULL, 27919, NULL, -100, '2024-05-21 00:00:00', 0, NULL, '2024-05-21 01:55:50'),
(129, 2, NULL, 27919, NULL, -100, '2024-05-21 00:00:00', 0, NULL, '2024-05-21 02:05:34'),
(130, 2, NULL, 25044, NULL, -150, '2024-05-23 00:00:00', 0, NULL, '2024-05-23 05:33:35'),
(131, 2, NULL, 25044, NULL, -150, '2024-05-23 00:00:00', 0, NULL, '2024-05-23 05:59:04'),
(132, 2, NULL, 25044, NULL, -150, '2024-05-23 00:00:00', 0, NULL, '2024-05-23 06:00:36'),
(133, 2, NULL, 25044, NULL, -150, '2024-05-23 00:00:00', 0, NULL, '2024-05-23 06:01:17'),
(134, 2, NULL, 25044, NULL, -150, '2024-05-23 00:00:00', 0, NULL, '2024-05-23 06:10:56'),
(135, 2, NULL, 25044, NULL, -150, '2024-05-23 00:00:00', 0, NULL, '2024-05-23 15:21:53'),
(136, 2, NULL, 25044, NULL, -150, '2024-05-23 00:00:00', 0, NULL, '2024-05-23 20:13:10'),
(137, 2, NULL, 25044, NULL, -150, '2024-05-23 00:00:00', 0, NULL, '2024-05-24 00:38:16'),
(138, 2, NULL, 25044, NULL, -150, '2024-05-24 00:00:00', 0, NULL, '2024-05-24 14:00:35'),
(139, 2, NULL, 25044, NULL, -150, '2024-05-24 00:00:00', 0, NULL, '2024-05-24 15:07:20'),
(140, 2, NULL, 25044, NULL, -150, '2024-05-24 00:00:00', 0, NULL, '2024-05-24 15:17:40'),
(141, 2, NULL, 25044, NULL, -200, '2024-05-24 00:00:00', 0, NULL, '2024-05-24 15:22:50'),
(142, 2, NULL, 25044, NULL, -200, '2024-05-24 00:00:00', 0, NULL, '2024-05-24 15:23:26'),
(143, 2, NULL, 25044, NULL, -200, '2024-05-24 00:00:00', 0, NULL, '2024-05-24 22:13:57'),
(144, 2, NULL, 25044, NULL, -150, '2024-05-25 00:00:00', 0, NULL, '2024-05-25 18:57:33'),
(145, 2, NULL, 25044, NULL, -200, '2024-05-26 00:00:00', 0, NULL, '2024-05-25 22:18:26'),
(146, 2, NULL, 25044, NULL, -200, '2024-05-26 00:00:00', 0, NULL, '2024-05-25 22:19:24'),
(147, 2, NULL, 25044, NULL, -150, '2024-05-26 00:00:00', 0, NULL, '2024-05-26 02:43:13'),
(148, 2, NULL, 25044, NULL, -150, '2024-05-26 00:00:00', 0, NULL, '2024-05-26 02:43:41');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `payment_type`
--
CREATE TABLE `payment_type` (
`id` int(11) NOT NULL,
`name` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `payment_type`
--
INSERT INTO `payment_type` (`id`, `name`) VALUES
(1, 'Cargo'),
(2, 'Abono');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `pending_route`
--
CREATE TABLE `pending_route` (
`id` int(11) NOT NULL,
`sale_id` varchar(15) CHARACTER SET latin1 NOT NULL,
`contract` varchar(20) CHARACTER SET latin1 NOT NULL,
`date_sale` date NOT NULL,
`total` decimal(15,2) NOT NULL,
`pay_min` decimal(10,2) NOT NULL,
`pay_period` varchar(1) CHARACTER SET latin1 NOT NULL,
`balance` decimal(15,2) NOT NULL,
`enganche` decimal(15,2) NOT NULL,
`date_pay1` date NOT NULL,
`payday` varchar(10) CHARACTER SET latin1 NOT NULL,
`NumberDay` int(2) NOT NULL DEFAULT 28,
`collector_id` int(11) NOT NULL,
`status` int(1) NOT NULL,
`created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `pending_route`
--
INSERT INTO `pending_route` (`id`, `sale_id`, `contract`, `date_sale`, `total`, `pay_min`, `pay_period`, `balance`, `enganche`, `date_pay1`, `payday`, `NumberDay`, `collector_id`, `status`, `created_at`) VALUES
(17, 'J231013002', '3434534', '2023-10-13', '2890.00', '123.00', 'M', '2590.00', '300.00', '2023-10-13', '3/M', 28, 58, 2, NULL),
(11, 'J231014002', '28228', '2023-10-13', '8340.00', '150.00', 'S', '8340.00', '250.00', '2023-10-07', '4', 28, 58, 0, NULL),
(12, 'J231012004', '1234909', '2023-10-09', '2890.00', '230.00', 'Q', '2590.00', '300.00', '2023-10-09', '1/16', 28, 58, 2, NULL),
(13, 'J231012008', '3434534', '2023-10-12', '2890.00', '123.00', 'M', '2645.00', '245.00', '2023-10-12', '3/M', 28, 58, 2, NULL),
(14, 'J231012009', '121212', '2023-10-19', '5780.00', '260.00', 'M', '5180.00', '600.00', '2023-10-19', '4/M', 28, 58, 2, NULL),
(15, 'J231012011', '23123', '2023-10-18', '2890.00', '200.00', 'M', '2390.00', '500.00', '2023-10-18', '1/M', 28, 58, 2, NULL),
(16, 'J231013001', '1234909', '2023-10-13', '2890.00', '230.00', 'Q', '2290.00', '600.00', '2023-10-13', '1/16', 28, 58, 2, NULL),
(18, 'J231016001', '909068', '2023-10-16', '22090.00', '200.00', 'S', '21590.00', '500.00', '2023-10-16', 'Lunes', 28, 61, 2, NULL),
(19, 'J231012004', '1234909', '2023-10-09', '2890.00', '230.00', 'Q', '2590.00', '300.00', '2023-10-09', '1/16', 28, 58, 2, NULL),
(20, 'J231012008', '121212', '2023-10-12', '2890.00', '260.00', 'M', '2145.00', '245.00', '2023-10-12', '4/M', 28, 58, 2, NULL),
(21, 'J231012011', '23123', '2023-10-18', '2890.00', '200.00', 'M', '2390.00', '500.00', '2023-10-18', '1/M', 28, 58, 2, NULL),
(22, 'J231013001', '1234909', '2023-10-13', '2890.00', '230.00', 'Q', '2290.00', '600.00', '2023-10-13', '1/16', 28, 58, 2, NULL),
(23, 'J231013002', '3434534', '2023-10-13', '2890.00', '123.00', 'M', '2590.00', '300.00', '2023-10-13', '3/M', 28, 58, 2, NULL),
(24, 'J231012004', '1234909', '2023-10-09', '2890.00', '230.00', 'Q', '2590.00', '300.00', '2023-10-09', '1/16', 28, 0, 2, NULL),
(25, 'J231012008', '121212', '2023-10-12', '2890.00', '260.00', 'M', '2145.00', '245.00', '2023-10-12', '4/M', 28, 0, 2, NULL),
(26, 'J231012009', '121213', '2023-10-19', '5780.00', '0.00', 'S', '5180.00', '600.00', '2023-10-19', '0', 28, 0, 2, NULL),
(27, 'J231012011', '23123', '2023-10-18', '2890.00', '200.00', 'M', '2390.00', '500.00', '2023-10-18', '1/M', 28, 0, 2, NULL),
(28, 'J231013001', '1234909', '2023-10-13', '2890.00', '230.00', 'Q', '2290.00', '600.00', '2023-10-13', '1/16', 28, 0, 2, NULL),
(29, 'J231013002', '3434534', '2023-10-13', '2890.00', '123.00', 'M', '2590.00', '300.00', '2023-10-13', '3/M', 28, 0, 2, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `person`
--
CREATE TABLE `person` (
`id` int(11) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`no` varchar(255) DEFAULT NULL,
`rfc` varchar(20) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`lastname` varchar(50) NOT NULL,
`gender` enum('SI','NO','AP','NA') DEFAULT NULL,
`company` varchar(50) DEFAULT NULL,
`address1` varchar(50) DEFAULT NULL,
`no_int` varchar(5) NOT NULL,
`no_ext` varchar(5) NOT NULL,
`colonia` varchar(50) NOT NULL,
`localidad` varchar(50) NOT NULL,
`city` varchar(50) NOT NULL,
`state` varchar(50) NOT NULL,
`cp` varchar(20) DEFAULT NULL,
`country` varchar(40) DEFAULT NULL,
`address2` varchar(50) DEFAULT NULL,
`phone` char(30) DEFAULT NULL,
`phone1` varchar(50) DEFAULT NULL,
`phone2` varchar(50) DEFAULT NULL,
`email1` varchar(50) DEFAULT NULL,
`email2` varchar(50) DEFAULT NULL,
`is_active_access` tinyint(1) NOT NULL DEFAULT 0,
`has_credit` tinyint(1) NOT NULL DEFAULT 0,
`credit_limit` decimal(14,2) DEFAULT NULL,
`password` varchar(60) DEFAULT NULL,
`kind` int(11) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `person`
--
INSERT INTO `person` (`id`, `image`, `no`, `rfc`, `name`, `lastname`, `gender`, `company`, `address1`, `no_int`, `no_ext`, `colonia`, `localidad`, `city`, `state`, `cp`, `country`, `address2`, `phone`, `phone1`, `phone2`, `email1`, `email2`, `is_active_access`, `has_credit`, `credit_limit`, `password`, `kind`, `created_at`) VALUES
(1, '', 'CT', '', 'CT INTERNACIONAL DEL NORESTE', 'RAYITO ', 'SI', '', 'juan pablos centro', '', '', '', '', '', '', '', 'Torreon', '', '8717938929', '7938929', '', 'syussa@ctin.mx', '', 0, 0, NULL, NULL, NULL, '2020-05-28 03:23:35'),
(2, '', 'AAAI800508K2A', '', 'ISRAEL ', 'ALVARADO AGUILAR', 'SI', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'syussa@ctin.mx', '20', 0, 1, '20000.00', '67a74306b06d0c01624fe0d0249a570f4d093747', NULL, '2020-05-29 09:34:08'),
(3, '', '', '', 'JOSE LUIS DE LA ROSA', '', 'SI', '', '', '', '', '', '', '', '', '', 'GOMEZ PALACIO', '', '98456789', '', '', '', '', 0, 0, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(4, '', '', '', 'Israel Alvarado Aguilar', '', 'SI', '', '', '', '', '', '', '', '', '', 'Torreón', '', '3838473727272', '', '', '', '', 0, 0, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(5, '', '', '', 'ISRAEL ALVARADO AGUILAR', '3265190', 'SI', '', 'Cerrada Zapotes 2A', '', '', '', '', '', '', '', '', '', '', '8711446289', '', 'AAAI800508K2A', '', 0, 0, NULL, NULL, 3, '2020-06-02 07:11:34'),
(6, '', '', '', 'Salvador amaya', 'Na', 'SI', '', 'Ejido el águila coahuila', '', '', '', '', '', '', '', '', '', '', ' 871 383 4721', '', 'Na', '', 0, 0, NULL, NULL, 3, '2020-06-02 22:33:03'),
(7, '', '', '', 'juan pedro almaraz', '', 'SI', '', '', '', '', '', '', '', '', '', 'TORREON', '', '989839489834', '', '', '', '', 0, 0, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(8, '', '', '', 'ALMA CANTU', '', 'NO', '', '', '', '', '', '', '', '', '', 'TORREON', '', '8711748156', '', '', '', '', 0, 0, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(9, '', '', '', 'ALLENDE TORTILLERIA', '', 'NO', '', '', '', '', '', '', '', '', '', 'TORREON', '', '0000000', '', '', '', '', 0, 0, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(10, '', '', '', 'CTE POLLOS CHAPALA', '', 'NO', '', '', '', '', '', '', '', '', '', 'GOMEZ PALACIO', '', '8714101690', '', '', '', '', 0, 0, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(11, '', '', '', 'saenz contador', '', 'NO', '', '', '', '', '', '', '', '', '', 'gomez', '', '87333444444', '', '', '', '', 0, 0, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(13, '', '', '', 'berenice torres gonzalez', 'na', 'SI', '', 'torreon', '', '', '', '', '', '', '', '', '', '', '8712770964', '', 'na', '', 0, 0, NULL, NULL, 3, '2020-07-11 05:34:56'),
(14, '', 'AAAI800508K2A', '', 'TORREON 2000 SA DE CV', 'NA', 'SI', '', 'CENTRO DE GOMEZ', '', '', '', '', '', '', '', 'torreon', '', '8711446289', '5545567889', '', 'syussa@ctin.mx', '', 0, 0, NULL, NULL, NULL, '0000-00-00 00:00:00'),
(15, '', 'NA', '', 'CVA CAMARAS', 'LILIA', 'SI', '', 'COLONIA EL TAJITO', '', '', '', '', '', '', '', '', '', '', '872387238723', '', 'NA', '', 0, 0, NULL, NULL, NULL, '2020-08-22 02:55:13'),
(17, '', '', NULL, 'disa muebleros', '', 'SI', '', NULL, '', '', '', '', '', '', NULL, 'saltillo coahuila', NULL, '4144950', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, '0000-00-00 00:00:00'),
(18, '', '', NULL, 'muebles garcia', '', 'SI', '', NULL, '', '', '', '', '', '', NULL, 'monterrey ', NULL, '8182530694', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, '0000-00-00 00:00:00'),
(19, '', '', NULL, 'DISEÑO EN MUEBLES TORREON', '', 'SI', '', NULL, '', '', '', '', '', '', NULL, 'TORREON', NULL, '872323232', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, '0000-00-00 00:00:00'),
(20, NULL, NULL, NULL, 'MUEBLERIA AMERICA DISTRIBUCIONES', '', 'SI', NULL, NULL, '', '', '', '', '', '', NULL, 'MTY', NULL, '567565656', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, '2021-10-01 20:24:52');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `product`
--
CREATE TABLE `product` (
`id` int(11) NOT NULL,
`image` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`barcode` varchar(50) COLLATE latin1_bin NOT NULL,
`name` varchar(50) COLLATE latin1_bin NOT NULL,
`description` text COLLATE latin1_bin NOT NULL,
`inventary_min` int(11) NOT NULL DEFAULT 10,
`price_in` decimal(14,2) NOT NULL,
`price_out` decimal(14,2) DEFAULT NULL,
`iva` int(11) DEFAULT NULL,
`unit` varchar(255) COLLATE latin1_bin NOT NULL,
`presentation` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`user_id` int(11) NOT NULL,
`listprice_id` int(11) DEFAULT NULL,
`is_service` tinyint(1) NOT NULL DEFAULT 0,
`category_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`finish_at` datetime DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
--
-- Volcado de datos para la tabla `product`
--
INSERT INTO `product` (`id`, `image`, `barcode`, `name`, `description`, `inventary_min`, `price_in`, `price_out`, `iva`, `unit`, `presentation`, `user_id`, `listprice_id`, `is_service`, `category_id`, `created_at`, `finish_at`, `is_active`) VALUES
(2, NULL, 'A01', 'ALCANCIA DE PLASTICO DE COCHINO GRANDE', 'DE PLASTICO', 30, '9.40', '28.00', 0, 'PZA', '', 1, NULL, 0, NULL, '2017-04-12 15:13:06', '0000-00-00 00:00:00', 1),
(5427, NULL, '7506185923545', 'CEPILLOS ODONTOLOGICOS', '', 5, '1.00', '302.00', 16, 'ACT', '', 6, NULL, 1, 1, '2021-09-17 09:16:02', NULL, 1),
(5428, NULL, '0240046', 'Abatelenguas ambiderm de madera para adulto c/100', '', 5, '23.95', '54.00', 16, 'ACT', 'M1/SA/E1', 6, NULL, 1, 5, '2021-09-19 13:03:02', NULL, 1),
(5429, NULL, '09700003', 'TRUBASE BASE P/ PLACAS SUPERIOR C/5', '', 5, '117.72', '175.00', 16, 'ACT', 'M1/SA/E2', 6, NULL, 1, 7, '2021-09-19 13:07:59', NULL, 1),
(5430, NULL, '02400046', 'ABATELENGUAS AMBIDERM C/100', 'ABATELENGUAS DE MADERA C/100 AMBIDERM CAJA', 5, '23.95', '54.00', 16, 'ACT', 'M1/SA/E1', 6, NULL, 1, 5, '2021-09-19 13:19:31', NULL, 1),
(5431, NULL, '870970202', 'TRUBASE INFERIOR C/5 PZAS DENTSPLY', 'TRUBASE BASE PARA PLACA INFERIOR C/5 DENSTPLY', 5, '117.72', '175.00', 16, 'ACT', 'M1/SA/E3', 6, NULL, 1, 3, '2021-09-19 13:50:45', NULL, 1),
(5432, NULL, '7506185924139', 'CAJAS ORTODONTICAS BORGATTA C/10 PZAS VIVA COLORS', 'CAJAS PARA GUARDA BORGATTA C/10 PIEZAS', 5, '62.12', '119.00', 16, 'ACT', 'M1/SA/E4', 6, NULL, 1, 1, '2021-09-19 13:58:13', NULL, 1),
(5433, NULL, '1632114265', 'DIQUE DE HULE NIC TONE 5X5 AZUL', 'DIQUE HULE CAJA C/36 PZAS 5X5 COLOR AZUL', 5, '165.00', '253.00', 16, 'ACT', 'M1/SB/E3', 6, NULL, 1, 4, '2021-09-19 14:16:40', NULL, 0),
(5434, NULL, '57500177', 'DIQUE DE HULE NIC TONE 5X5 AZUL', 'DIQUE DE HULE C/36 PZAS. NIC TONE AZUL 5X5', 5, '165.00', '253.00', 16, 'ACT', 'M1/SB/E3', 6, NULL, 1, 4, '2021-09-19 14:23:51', NULL, 1),
(5435, NULL, '27033511', 'RADIOGRAFIA CARESTREAM INFANTIL C/100 PZAS', 'RADIOGRAFIA INFANTIL C/100 PZAS. CARESTREAM', 2, '700.00', '1038.00', 16, 'ACT', 'M1/SA/E9', 6, NULL, 1, 3, '2021-09-19 14:31:24', NULL, 1),
(5436, NULL, '27035930', 'RADIOGRAFIA E-SPEED C/150 ADULTO', 'RADIOGRAFIA ADULTO No.2 CAJA C/150 PZAS. CARESTREAM', 3, '726.00', '1084.00', 16, 'ACT', 'M1/SA/E10', 6, NULL, 1, 3, '2021-09-19 14:34:34', NULL, 1),
(5437, NULL, '7506185924115', 'CAJAS ORTODONTICAS BORGATTA C/10 PZAS NEON COLORS', 'CAJA DE ORTODONCIA BORGATTA NEON COLORS C/10 PZAS', 5, '62.12', '119.00', 16, 'ACT', 'M1/SA/E6', 6, NULL, 1, 1, '2021-09-19 14:46:53', NULL, 1),
(5438, NULL, '7506185924092', 'CAJAS ORTODONTICAS BORGATTA C/10 PZAS PASTEL COLOR', 'CAJA DE ORTODONCIA BORGATTA C/10 PZAS. PASTEL COLORS', 5, '62.12', '119.00', 16, 'ACT', 'M1/SA/E7', 6, NULL, 1, 1, '2021-09-19 14:45:13', NULL, 1),
(5439, NULL, '50500022', 'RADIOGRAFIA PANORAMICA TMG 15X30 C/50', 'RADIOGRAFIA PANORAMICA C/50 PZAS.CARESTREAM TMG', 1, '994.28', '1527.00', 16, 'ACT', 'M1/SA/E11', 6, NULL, 1, 3, '2021-09-19 14:48:44', NULL, 1),
(5440, NULL, '86700057', 'HIPOCLORITO DE SODIO VIARZONI-T AL 5.25% 250 ml.', 'HIPOCLORITO DE SODIO VIARZONI-T AL 5.25% 250 ml.', 2, '40.00', '68.00', 16, 'ACT', 'M1/SB/E1', 6, NULL, 1, 3, '2021-09-19 14:51:47', NULL, 1),
(5441, NULL, '1A00020494', 'ENDO ICE SPRAY C/6 ONZAS', 'ENDO ICE SPRAY C/6 ONZAS', 1, '345.86', '544.00', 16, 'ACT', 'M1/SB/E2', 6, NULL, 1, 2, '2021-09-19 14:57:52', NULL, 1),
(5442, NULL, '57500072', 'DIQUE DE HULE NIC TONE 6X6 AZUL', 'DIQUE DE HULE NIC TONE 6X6 AZUL C/36 PZAS.', 5, '165.00', '253.00', 16, 'ACT', 'M1/SB/E4', 6, NULL, 1, 4, '2021-09-19 14:59:52', NULL, 1),
(5443, NULL, '1632120568', 'AMALGAMA TYTIN CAPSULAS C/10 PZAS.', 'AMALGAMA TYTIN CAPSULAS C/10 PZAS. BOLSA', 5, '181.20', '317.00', 16, 'ACT', 'M1/SB/E5', 6, NULL, 1, 4, '2021-09-19 15:14:10', NULL, 1),
(5444, NULL, '1632127656', 'RADIOGRAFIA E-SPEED BOLSA C/10 PZAS.', 'RADIOGRAFIA E-SPEED BOLSA C/10 PZAS. BOLSA', 5, '49.63', '105.00', 16, 'ACT', 'M1/SA/E12', 6, NULL, 1, 3, '2021-09-19 16:16:09', NULL, 1),
(5445, NULL, '36000025', 'CERA TODA ESTACION ', 'CERA ROSA TODA ESTACION FILENES CAJA C/225 grs.', 5, '69.00', '115.00', 16, 'ACT', 'M1/SB/E7', 6, NULL, 1, 9, '2021-09-19 16:25:49', NULL, 1),
(5446, NULL, '19000187', 'AMALGA TABLETAS TUBO', '1/2 ONZA DE AMALGAMA DISPERSALLOY TABLETAS FASE DISPERSA', 2, '406.50', '646.00', 16, 'ACT', 'M1/SB/E7', 6, NULL, 1, 4, '2021-09-19 16:29:27', NULL, 1),
(5447, NULL, '1632131189', 'MICRO APLICADOR 901-T AZUL', 'MICRO APLICADOR 901-T AZUL', 5, '27.25', '90.00', 16, 'ACT', '', 6, NULL, 1, 3, '2021-09-19 16:42:04', NULL, 1),
(5448, NULL, '1632124690', 'APLICADOR BIOBRUSH MONITEX', 'APLICADOR BIOBRUSH MONITEX FINO AMARILLO C/100 PZAS', 3, '27.75', '92.00', 16, 'ACT', 'M1/SB/E9', 6, NULL, 1, 3, '2021-09-19 16:44:49', NULL, 1),
(5449, NULL, '1632127196', 'APLICADOR BIOBRUSH MONITEX AZUL', 'APLICADOR BIOBRUSH MONITEX AZUL C/100 PZAS', 3, '27.75', '92.00', 16, 'ACT', 'M1/SB/E9', 6, NULL, 1, 3, '2021-09-19 16:49:53', NULL, 1),
(5450, NULL, '62100005', 'APLIC BIOBRUSH MICRO SF MONITEX', 'APLICADOR BIOBRUSH BLANCO SUPER FINO C/100 PZAS.', 3, '29.00', '96.00', 16, 'ACT', 'M1/SA/E10', 6, NULL, 1, 3, '2021-09-19 16:52:09', NULL, 1),
(5451, NULL, '61300030', 'MICROBRUSH ORIGINAL Y7 AZ', 'MICROBRUSH ORIGINAL REGULAR AZUL C/100 PZAS Y7', 5, '71.00', '131.00', 16, 'ACT', 'M1/SB/E1|1', 6, NULL, 1, 3, '2021-09-19 16:54:31', NULL, 1),
(5452, NULL, '61300031', 'MICROBRUSH ORIGINAL Y7 VERDE', 'MICROBRUSH ORIGINAL Y7 VERDE EST C/100 PZAS.', 5, '71.00', '131.00', 16, 'ACT', 'M1/SB/E12', 6, NULL, 1, 3, '2021-09-19 16:56:08', NULL, 1),
(5453, NULL, '61300029', 'MICROBRUSH ORIGINAL Y7 ROSA', 'MICROBRUSH ORIGINAL Y7 ROSA EST. C/100 PZAS. TAMAÑO FINO', 5, '71.00', '131.00', 16, 'ACT', 'M1/SB/E13', 6, NULL, 1, 3, '2021-09-19 16:57:43', NULL, 1),
(5454, NULL, '1632127228', 'ULTRABRUSH FINO NARANJA', 'ULTRABRUSH PLUS COLOR NARANJA FINO C/100 PZAS.', 3, '234.50', '373.00', 16, 'ACT', 'M1/SB/E14', 6, NULL, 1, 3, '2021-09-19 17:05:14', NULL, 1),
(5455, NULL, '61300026', 'ULTRABRUSH REGULAR AZUL', 'ULTRABRUSH REGULAR AZUL C/100 PZAS', 5, '234.50', '373.00', 16, 'ACT', 'M1/SA/E15', 6, NULL, 1, 3, '2021-09-19 17:07:05', NULL, 1),
(5456, NULL, '12900064', 'SPEEDEX MASA SIN ACTIVADOR', 'TARRO DE SPEEDEX MASA SIN ACTIVADOR COLTENE 910 ml.', 5, '587.00', '891.00', 16, 'ACT', 'M1/SC/E1', 6, NULL, 1, 3, '2021-09-19 17:12:21', NULL, 1),
(5457, NULL, '12900070', 'SPEEDEX LIGTH BODY ', 'SPEDDEX LIGHT BODY FLUIDO TUBO C/140 ml. COLTENE', 5, '292.21', '419.00', 16, 'ACT', 'M1/SC/E2', 6, NULL, 1, 3, '2021-09-19 17:15:14', NULL, 1),
(5458, NULL, '12900032', 'SPEEDEX ACTIVADOR UNIV.', 'SPEEDEX ACTIVADOR UNIV. TUBO C/60 ml.', 5, '296.00', '434.00', 16, 'ACT', 'M1/SC/E3', 6, NULL, 1, 3, '2021-09-19 17:17:45', NULL, 1),
(5459, NULL, '12900086', 'SPEEDEX JUEGO INTRO.', 'SPEEDEX JUEGO INTRODUCTORIO COLTENE', 5, '402.00', '639.00', 16, 'ACT', 'M1/SC/E4', 6, NULL, 1, 3, '2021-09-19 17:20:09', NULL, 1),
(5460, NULL, '1632130542', 'GUARDA SUAVE .060 C/9 PZAS', 'ACETATO PARA GUARDA HARD AND SOFT SUAVE .60 C/9 PZAS.', 1, '141.75', '330.00', 16, 'ACT', '', 6, NULL, 1, 7, '2021-09-19 17:36:13', NULL, 1),
(5461, NULL, '7506185912853', 'ACETATO RIGIDO .040 BORGAT.', 'ACETATO RIGIDO .040 BORGATTA C/10 PIEZAS', 5, '101.76', '288.00', 16, 'ACT', 'M1/SC/E5', 6, NULL, 1, 3, '2021-09-19 17:42:01', NULL, 1),
(5462, NULL, '7506185901802', 'ACETATO BLANDO .060 BORGAT.', 'ACETATO BLANDO .060 BORGATTA C/10 PIEZAS', 5, '187.50', '399.00', 16, 'ACT', 'M1/SC/E8', 6, NULL, 1, 3, '2021-09-19 17:44:04', NULL, 1),
(5463, NULL, '85300284', 'OPALESCENCE BOOST', 'OPALESCENCE BOOST BLANQUEAMIENTO ESTUCHE PARA CONSULTORIO', 5, '535.00', '935.00', 16, 'ACT', 'M1/SC/E9', 6, NULL, 1, 3, '2021-09-19 17:47:28', NULL, 1),
(5464, NULL, '', '', 'NADA', 5, '1.00', '20.00', 16, 'ACT', 'M35 F34 23', 6, NULL, 1, 8, '2021-09-19 18:48:23', NULL, 1),
(5465, NULL, '78500043', 'POLA OFFICE 35% 1 PAC.', 'POLA OFFICE 35% 1 PACIENTE JUEGO', 5, '500.00', '902.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:05:03', NULL, 1),
(5466, NULL, '78500047', 'POLA OFFICE 37.5% 1 PAC.', 'POLA OFFICE 37.5% 1 PACIENTE JUEGO', 5, '596.67', '948.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:06:54', NULL, 1),
(5467, NULL, '7501258222204', 'SUTURA 4-0 SURGEASY', 'SUTURA 4-0 SURGEASY SEDA NEGRA', 5, '19.00', '55.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:11:33', NULL, 1),
(5468, NULL, '7501258222198', 'SUTURA 3-0 SURGEASY', 'SUTURA 3-0 SURGEASY SEDA NEGRA', 5, '19.00', '55.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:13:49', NULL, 1),
(5469, NULL, '48500049', 'SEDA.SILK 3-0 SUTURA', 'SEDA.SILK 3-0 SUTURA SUTURA ETHICON PIEZA', 5, '32.28', '55.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:15:50', NULL, 1),
(5470, NULL, '18100011', 'CATGUT 4-0', 'SUTURA CATGUT DEMETECH 4-0', 5, '45.25', '72.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:21:07', NULL, 1),
(5471, NULL, '1632139308', 'HOJA BISTURI No.15', 'HOJA PARA BISTURI No.15 AMBIDERM', 50, '1.49', '18.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:24:19', NULL, 1),
(5472, NULL, '81600020', 'CANULAS SUCCION C/25 PZAS.', 'CANULAS DE SUCCION ALTO VACIO C/25 PZAS. SUNSET', 5, '197.00', '324.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:26:36', NULL, 1),
(5473, NULL, '31300022', 'EYECTOR SALIVA LILA', 'EYECTOR SALIVA LILA EURONDA BOLSA C/100 PZAS.', 5, '58.00', '98.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:28:41', NULL, 1),
(5474, NULL, '31300017', 'EYECTOR SALIVA TRANS.', 'EYECTOR DE SALIVA TRANSPARENTE EURONDA BOLSA C/100 PZAS.', 5, '58.00', '98.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:33:09', NULL, 1),
(5475, NULL, '31300020', 'EYECTOR SALIVA VERDE', 'EYECTOR DE SALIVA VERDE EURONDA BOLSA C/100 PZAS.', 5, '58.00', '98.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:34:14', NULL, 1),
(5476, NULL, '31300019', 'EYECTOR SALIVA AZUL', 'EYECTOR DE SALIVA AZUL EURONDA BOLSA C/100 PIEZAS.', 5, '58.00', '98.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:35:25', NULL, 1),
(5477, NULL, '31300026', 'EYECTOR SALIVA ROSA', 'EYECTOR DE SALIVA ROSA EURONDA BOLSA C/100 PIEZAS.', 5, '58.00', '98.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:36:43', NULL, 1),
(5478, NULL, '7506203600397', 'CERA ORTODONCIA STYLUS', 'CERA DE ORTODONCIA CON AROMA STYLUS BOLSA C/10 PIEZAS.', 5, '89.79', '166.00', 16, 'ACT', 'M1', 6, NULL, 1, 1, '2021-09-19 19:41:44', NULL, 1),
(5479, NULL, '76800003', 'ROLLO ALGODON C/4 RICH.', 'ROLLO DE ALGODON RICHMOND PAQUETE C/4 PZAS.', 5, '53.80', '98.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:46:45', NULL, 1),
(5480, NULL, '6952367900001', 'ROLLO ALGODON C/4 DOCHEM', 'ROLLO DE ALGODON C/4 PZAS. DOCHEM', 5, '33.36', '67.00', 16, 'ACT', 'M1', 6, NULL, 1, 3, '2021-09-19 19:48:56', NULL, 1),
(5481, NULL, 'C16767', 'PRUDCUTO ALTERNO 78', 'NA\r\n', 5, '2.00', '20.00', 16, 'ACT', '', 6, NULL, 1, 7, '2021-09-19 20:21:03', NULL, 1),
(5482, NULL, '1632231962', 'CAJA REVELADO ZEYCO', 'CAJA DE REVELADO ZEYCO CON ACCESORIOS', 5, '707.45', '1281.00', 16, 'ACT', 'M2', 6, NULL, 1, 5, '2021-09-20 21:23:05', NULL, 1),
(5483, NULL, '7501091719510', 'RECOLECTOR PUNZOCOR. 7.57 L', 'BOTE RECOLECTOR PUNZOCORTANTES 7.57 L', 1, '132.00', '210.00', 16, 'ACT', 'M2', 6, NULL, 1, 5, '2021-09-20 21:25:40', NULL, 1),
(5484, NULL, '792604000486', 'RECOLECTOR PUNZOCOR. 8.5 L', 'BOTE RECOLECTOR PUNZOCORTANTES 8.5 L', 1, '74.00', '125.00', 16, 'ACT', 'M2', 6, NULL, 1, 5, '2021-09-20 21:29:44', NULL, 1),
(5485, NULL, '792604000349', 'RECOLECTOR PUNZOCOR. 4 L', 'BOTE RECOLECTOR PUNZOCOR. 4 L', 1, '48.00', '81.00', 16, 'ACT', 'M2', 6, NULL, 1, 5, '2021-09-20 21:31:23', NULL, 1),
(5486, NULL, '1632225030', 'KARETA FPK', 'CARETA DE PROTECCION FPKARETA CON 1 REPUESTO', 2, '301.74', '544.00', 16, 'ACT', 'M2-V6', 6, NULL, 1, 3, '2021-09-20 21:50:15', NULL, 1),
(5487, NULL, '1632237824', 'PORTA CAMPOS', 'PORTA CAMPOS DE ACRILICO', 1, '150.00', '319.00', 16, 'ACT', 'M2', 6, NULL, 1, 5, '2021-09-20 21:56:32', NULL, 1),
(5488, NULL, '96000087', 'ZETAPLUS MASILLA ', 'ZATAPLUS MASILLA TARRO 900 ml.', 1, '473.00', '752.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 22:01:23', NULL, 1),
(5489, NULL, '96000086', 'ORANWASH L SILICON', 'ORANWASH L SILICONA CONDENSACION LIGERO TUBO 140 ml. ZHERMACK', 1, '270.00', '429.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 22:03:40', NULL, 1),
(5490, NULL, '96000085', 'INDURENT GEL', 'INDURENT GEL ACTIVADOR SILICONA CONDENSABLE ZHERMACK', 1, '185.00', '294.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 22:05:23', NULL, 1),
(5491, NULL, '96000028', 'ELITE HD +', 'ELITE HD + LIGHT BODY NORMAL SET ZHERMACK', 1, '823.00', '1264.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 22:07:02', NULL, 1),
(5492, NULL, '96000056', 'HYDRORISE PUTTY', 'HYDRORISE PUTTY NORMAL SET TARRO C/ 300 ml.ZHERMACK', 1, '1318.00', '2024.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 22:09:10', NULL, 1),
(5493, NULL, '96000092', 'ZETALABOR MASILLA 900ML', 'ZETALABOR SIL CONDEN MASILLA TARRO C/900ML ZHERMACK', 2, '347.00', '552.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 22:30:59', NULL, 1),
(5494, NULL, '77000078', 'EXPRESS MASA 305ML', 'EXPRESS HIDROF MASA PESADA 305 ML', 3, '811.00', '1289.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 22:41:58', NULL, 1),
(5495, NULL, '77000290', 'IMPRINT II 3M C/4', 'IMPRINT II GARANT 3M C/4', 3, '1366.00', '2171.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 22:59:18', NULL, 1),
(5496, NULL, '77000353', 'IMPRINT II LIGERO C/4 3M', 'IMPRINT II GARANT LIGERO C/4 3M', 2, '1174.00', '2018.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 23:04:53', NULL, 1),
(5497, NULL, '7506338300209', 'EDGE LIGHT', 'LIGHT BODY EDGE C/2', 7, '306.04', '552.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 23:11:50', NULL, 1),
(5498, NULL, '', 'NA', 'EDGE REGULAR BODY C/2 CARTUCHOS', 5, '539.00', '973.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 23:17:48', NULL, 1),
(5499, NULL, '1632241320', ' EDGE REGULAR C/2 C.', '', 5, '973.00', '973.00', NULL, 'PZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5500, NULL, '7506338300193', 'EDGE BITE C/2 C.', 'EDGE BITE REGISTRATION C/2 CARTUCHOS MDC', 2, '301.72', '544.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-20 23:39:27', NULL, 1),
(5501, NULL, '1234567890', 'PRODUCTO VC', '', 5, '1.00', '20.00', 16, 'ACT', '', 6, NULL, 1, 7, '2021-09-21 00:39:45', NULL, 1),
(5502, NULL, '7502224240284', 'GUANTE CONFORT GDE C/100', 'GUANTE AMBIDERM CONFORT GDE. C/100', 20, '210.00', '379.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-21 01:14:40', NULL, 1),
(5503, NULL, '7502236492329', 'GUANTE NITR UNIS. GDE', 'GUANTE NITRILO UNISEAL GDE C/100 COLOR NATURAL', 3, '382.00', '599.00', 16, 'ACT', 'M2', 6, NULL, 1, 3, '2021-09-21 01:33:17', NULL, 1),
(5504, NULL, 'SA0001', 'JGO DE SATENES BUENOS AIRES', 'CREDITO $1590', 5, '5000.00', '1050.00', NULL, 'PZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5505, NULL, 'CO0001', 'COLCHON IDIVIDUAL SENCILLO', 'CREDITO $5690', 5, '123.00', '2345.00', NULL, 'PZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5506, NULL, '2323', 'papel de bao', 'na', 5, '200.00', '200.00', NULL, 'pz', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5507, NULL, 'E01', 'BOCINA DE 8\"', '1350', 5, '1350.00', '1560.00', NULL, 'PZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5508, NULL, 'S01', 'JUEGO DE SARTENES KUNG FU MASTER', '1744', 5, '2690.00', '2690.00', NULL, 'JUEG', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5509, NULL, 'JUSV', 'JUEGO DE SARTENES VASCONIA', '1264', 5, '1890.00', '1890.00', NULL, 'pz', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5510, NULL, 'M01', 'CLOSET NAPOLES COLOR MIEL', '8850', 5, '12390.00', '12390.00', NULL, 'PZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5511, NULL, 'SA0110', 'SALA 101', '1428.57', 5, '2000.00', '2000.00', NULL, 'PZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5512, NULL, 'ROTO', 'ROPERO TORREON', '7128.57', 5, '9980.00', '9980.00', NULL, 'PIEZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5513, NULL, 'COMO', 'COBERTOR MONARCA', '1707.14', 5, '2390.00', '2390.00', NULL, 'PIEZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5514, NULL, 'JUSAKM', 'JGO DE SARTENES KUN FU MASTHER', '1878.50', 5, '2890.00', '2890.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5515, NULL, 'juvamg', 'vaporera juego de maya guindo 34', '1937.00', 5, '2980.00', '2980.00', NULL, 'jgo', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5516, NULL, 'JUMAG', 'JUEGO DE MAYA GUINDO 45', '2392.00', 5, '3680.00', '3680.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5517, NULL, 'VA45', 'VAPORERA 45', '708.50', 5, '1090.00', '1090.00', NULL, 'PIEZ', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5518, NULL, 'VA70}', 'VAPORERA 70', '1358.50', 5, '2090.00', '2090.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5519, NULL, 'VA90', 'VAPORERA 90', '1287.00', 5, '1980.00', '1980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5520, NULL, 'CAG45', 'CAZO GUINDO 45', '1163.50', 5, '1790.00', '1790.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5521, NULL, 'LIHA', 'LICUADORA HAMILTON', '1423.50', 5, '2190.00', '2190.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5522, NULL, 'JUSAM', 'JUEGO DE SABANAS MATRIMONIAL', '708.50', 5, '1090.00', '1090.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5523, NULL, 'JUSAK', 'JUEGO DE SABANAS KZ', '838.50', 5, '1290.00', '1290.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5524, NULL, 'JUCOO', 'JUEGO DE CORTINAS DE ORGANZA', '448.50', 5, '690.00', '690.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5525, NULL, 'JUCOE', 'JUEGO DE CORTINAS DE ENCAJE', '383.50', 5, '590.00', '590.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5526, NULL, 'JUCOB', 'JUEGO CORTINAS BLAK AUT', '708.50', 5, '1090.00', '1090.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5527, NULL, 'JUCOJ', 'JUEGO CORTINAS JACKARD', '383.50', 5, '590.00', '590.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5528, NULL, 'CODC', 'CORTINAS DE COSINA', '253.50', 5, '390.00', '390.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5529, NULL, 'COCUP', 'COBERTOR CUNERO PROVIDENCIA', '578.50', 5, '890.00', '890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5530, NULL, 'COINP', 'COBERTOR INDIVIDUAL PROVIDENCIA', '773.50', 5, '1190.00', '1190.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5531, NULL, 'COMAP', 'COBERTOR MATRIMONIAL PROVIDENCIA', '1157.00', 5, '1780.00', '1780.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5532, NULL, 'COKIP', 'COBERTOR KING SIZE PROVIDENCIA', '1488.50', 5, '2290.00', '2290.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5533, NULL, 'COKIM', 'COBERTOR KING SIZE MONARCA', '1488.50', 5, '2290.00', '2290.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5534, NULL, 'CLOHE', 'CLOSET HERCULES', '14618.50', 5, '22490.00', '30.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5535, NULL, 'CLOKIK', 'CLOSET KING KON', '12337.00', 5, '18980.00', '18980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5536, NULL, 'CLONAM', 'CLOSET NAPOLES MIEL', '9477.00', 5, '14580.00', '150.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5537, NULL, 'CLONACH', 'CLOSET NAPOLES CHOCO', '9737.00', 5, '14980.00', '14980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5538, NULL, 'CLOPUC', 'CLOSET PUERTAS CORREDIZAS', '7338.50', 5, '11290.00', '11290.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5539, NULL, 'ROTOM', 'ROPERO TORREON MIEL', '6357.00', 5, '9780.00', '9890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5540, NULL, 'ROTOCH', 'ROPERO TORREON CHOCO', '6487.00', 5, '9980.00', '20.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5541, NULL, 'CAEL6', 'CAJONERA ELISA 6 CAJONES', '5583.50', 5, '8590.00', '48.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5542, NULL, 'CAINEN', 'CAJONERA INFANTIL EVELIN NIÑO', '4998.50', 5, '7690.00', '7690.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5543, NULL, 'CAIEÑ', 'CAJONERA INFANTIL EVELIN NIÑA', '4998.50', 5, '7690.00', '7690.00', NULL, 'ZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5544, NULL, 'COIN', 'COMODA INGLATERRA', '5648.50', 5, '8690.00', '8690.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5545, NULL, 'ALCHM', 'ALACENA CHICA MIEL', '5453.50', 5, '8390.00', '8390.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5546, NULL, 'ALCHCH', 'ALACENA CHICA CHOCO', '5518.50', 5, '8490.00', '8490.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5547, NULL, 'ALAN', 'ALACENA ANDREA', '7338.50', 5, '11290.00', '11290.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5548, NULL, 'ALAND5', 'ALACENA ANDREA DOBLE', '9542.00', 5, '14680.00', '14680.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5549, NULL, 'VICHM', 'VITRINA CHICA MIEL', '5778.50', 5, '8890.00', '8890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5550, NULL, 'POMI', 'PORTAMICRO MIEL', '5128.50', 5, '7890.00', '7890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5551, NULL, 'POCH1', 'PORTAMICRO CHOCO', '5317.00', 5, '8180.00', '8180.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5552, NULL, 'COMI', 'COSINETA MIEL ', '4868.50', 5, '7490.00', '7490.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5553, NULL, 'COCH', 'COSINETA CHOCO', '5063.50', 5, '7790.00', '7790.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5554, NULL, 'CESU', 'CENTRO SUIZA', '2268.50', 5, '3490.00', '3490.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5555, NULL, 'ESHW', 'ESPEJO HOLIWOD', '5187.00', 5, '7980.00', '7980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5556, NULL, 'ESHO', 'ESPEJO HOLANDA', '4862.00', 5, '7480.00', '7480.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5557, NULL, 'PEFA', 'PEINADOR FAVY', '4927.00', 5, '7580.00', '7580.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5558, NULL, 'VACH', 'VANYTY CHICO', '5583.50', 5, '8590.00', '8590.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5559, NULL, 'VAGR', 'VANYTY GRANDE', '6558.50', 5, '10090.00', '10090.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5560, NULL, 'ESZAH', 'ESPEJO ZAPATERO HOLIWOD', '6292.00', 5, '9680.00', '9680.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5561, NULL, 'COINS', 'COLCHON INDIVIDUAL SENCILLO HOTELERO', '3692.00', 5, '5680.00', '5680.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5562, NULL, 'COMAS', 'COLCHO MATRIMONIAL SENCILLO HOTELERO', '4992.00', 5, '7680.00', '7680.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5563, NULL, 'COIN2M', 'COLCHON INDIVIDUAL 2 COLCH MILAN', '4862.00', 5, '7480.00', '7480.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5564, NULL, 'COMA2M', 'COLCHO MATRIMONIAL 2 COLCHMILAN', '6487.00', 5, '9980.00', '9980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5565, NULL, 'COQ2M', 'COLCHON QUEEN 2 COLCH MILAN ', '7137.00', 5, '10980.00', '10980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5566, NULL, 'COKI2M', 'COLCHON KING SIZE 2 COLCH MILAN', '9737.00', 5, '14980.00', '14980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5567, NULL, 'BAIN', 'BASE INDIVIDUAL', '3048.50', 5, '4690.00', '4690.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5568, NULL, 'BAMA', 'BASE MATRIMONIAL', '3243.50', 5, '4990.00', '4990.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5569, NULL, 'BAQU', 'BASE QUEEN', '3503.50', 5, '5390.00', '5390.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5570, NULL, 'JUBAK', 'JGO DE BASES KING SIZE', '6363.50', 5, '9790.00', '9790.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5571, NULL, 'BACAM', 'BASE CANGURO MATRIMONIAL', '8307.00', 5, '12780.00', '12780.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5572, NULL, 'BACAI', 'BASE CANGURO INDIVIDUAL', '7137.00', 5, '10980.00', '10980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5573, NULL, 'SAL', 'SALA LORENA', '8963.50', 5, '13790.00', '13790.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5574, NULL, 'SAV', 'SALA VICTORIA', '7468.50', 5, '11490.00', '11490.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5575, NULL, 'SAES', 'SALA ESTEFANIA', '8508.50', 5, '13090.00', '13090.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5576, NULL, 'SAI3', 'SALA IRIS 321', '14358.50', 5, '22090.00', '22090.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5577, NULL, 'COMA6', 'COMEDOR MADERA 6 SILLAS', '12337.00', 5, '18980.00', '18980.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5578, NULL, 'COMA4', 'COMEDOR MADERA 4 SILLAS', '10198.50', 5, '15690.00', '15690.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5579, NULL, 'BOQ', 'BOSINA QFX', '1287.00', 5, '1980.00', '1980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5580, NULL, 'BOQ12', 'BOSINA QFX 12', '2983.50', 5, '4590.00', '60.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5581, NULL, 'BOQ15', 'BOSINA QFX 15', '4868.50', 5, '7490.00', '150.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5582, NULL, 'BODPC', 'BOILER DE PASO CINSA', '1878.50', 5, '2890.00', '2890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5583, NULL, 'BOGU', 'BOILER GUARDIAN 40L', '4478.50', 5, '6890.00', '6890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5584, NULL, 'MIP22', 'MINISPLIT PRIME 220 2 TIEMPOS', '10387.00', 5, '15980.00', '15980.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5585, NULL, 'ABDP', 'ABANICO DE PEDESTAL DE FIERRO', '1683.50', 5, '2590.00', '75.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5586, NULL, 'ABDPM', 'ABANICO DE PISO MAN', '1683.50', 5, '2590.00', '2590.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5587, NULL, 'MEXF', 'MESA XTAGARAFON', '1547.00', 5, '2380.00', '2380.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5588, NULL, 'MEMU', 'MESA MULTUSOS ', '1553.50', 5, '2390.00', '2390.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5589, NULL, 'MUPB', 'MUEBLE PARA BAÑO', '1228.50', 5, '1890.00', '1890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5590, NULL, 'MUPBO', 'MUEBLE P/BAÑO BOTIQUIN', '1807.00', 5, '2780.00', '2780.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5591, NULL, 'JUBA', 'JGO DE BANCOS ', '1748.50', 5, '2690.00', '2690.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5592, NULL, 'FRUT', 'FRUTERO', '1813.50', 5, '2790.00', '2790.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5593, NULL, 'JUMEM', 'JGO DE MESEDORAS MAYA', '2528.50', 5, '3890.00', '3890.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5594, NULL, 'BAM', 'BANCA MAYA ', '1228.50', 5, '1890.00', '1890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5595, NULL, 'MEDJM', 'MESA DE JARDIN MAYA ', '1228.50', 5, '1890.00', '1890.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5596, NULL, 'JUJAM', 'JGO DE JARDIN MAYA', '3757.00', 5, '5780.00', '5780.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5597, NULL, 'JUMR', 'JGO DE MESEDORA ROYAL ', '3172.00', 5, '4880.00', '4880.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5598, NULL, 'JUMEI', 'JGO DE MESDORA INFANTIL ', '1683.50', 5, '2590.00', '2590.00', NULL, 'JGO', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5599, NULL, 'BACH', 'BAÑERA CHICA', '838.50', 5, '1290.00', '1290.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5600, NULL, 'BAGR', 'BAÑERA GRANDE', '2073.50', 5, '3190.00', '3190.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5601, NULL, 'AR30', 'ARROCERA 30', '767.00', 5, '1180.00', '1180.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5602, NULL, 'AR34', 'ARROCERA 34', '1092.00', 5, '1680.00', '1680.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5603, NULL, 'AR40', 'ARROCERA 40', '1157.00', 5, '1780.00', '1780.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5604, NULL, 'AR50', 'ARROCERA 50', '2073.50', 5, '3190.00', '3190.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5605, NULL, 'BAINF', 'BAUL INFANTIL', '1358.50', 5, '2090.00', '2090.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1),
(5606, NULL, 'PLH32', 'PLASMA HEISEN 32', '5837.00', 5, '8980.00', '20.00', NULL, 'PZA', NULL, 1, NULL, 0, NULL, NULL, NULL, 1);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `promotion`
--
CREATE TABLE `promotion` (
`id` int(11) NOT NULL,
`name` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`tipo` int(11) DEFAULT NULL,
`monto` decimal(10,2) DEFAULT NULL,
`product_id` varchar(20) COLLATE latin1_bin DEFAULT NULL,
`category_id` int(11) DEFAULT NULL,
`client_id` int(11) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT 0,
`created_ini` datetime DEFAULT NULL,
`created_finish` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
--
-- Volcado de datos para la tabla `promotion`
--
INSERT INTO `promotion` (`id`, `name`, `tipo`, `monto`, `product_id`, `category_id`, `client_id`, `is_active`, `created_ini`, `created_finish`, `created_at`) VALUES
(1, 'navidad 22', 0, '200.00', '2674', 1, NULL, 1, '2020-08-01 00:00:00', '2020-09-02 00:00:00', '2020-08-12 21:50:11'),
(2, 'VERANO', 0, '0.00', '0', NULL, NULL, 1, '2020-01-31 00:00:00', '2020-10-01 00:00:00', '2020-08-12 21:56:29'),
(3, 'VERANO 2', 0, '20.00', '2675', 1, NULL, 1, '2020-08-13 00:00:00', '2020-09-15 00:00:00', '2020-08-14 12:58:27'),
(4, 'PROMO 2', 1, '20.00', '0', 1, NULL, 1, '2020-09-13 00:00:00', '2021-09-15 00:00:00', '2020-08-14 13:05:36'),
(5, 'promo 34', 1, '20.00', '2711', 1, NULL, 1, '2021-09-13 00:00:00', '2021-10-15 00:00:00', '2020-08-14 13:13:16'),
(6, 'Promocion kits camaras', 1, '20.00', 'kit4_2mpx', 1, NULL, 1, '2021-09-13 00:00:00', '2021-09-15 00:00:00', '2020-08-14 13:16:29'),
(7, '2x1', 0, '2.00', '', NULL, NULL, 1, '2020-08-15 00:00:00', '2020-09-15 00:00:00', '2020-08-14 15:08:30'),
(8, 'promocion 3x2', 0, '20.00', '', NULL, NULL, 1, '2020-10-17 00:00:00', '2020-11-15 00:00:00', '2020-08-14 15:10:46'),
(9, 'dos dos', 1, '20.00', '', 1, NULL, 1, '2020-09-16 00:00:00', '2021-10-15 00:00:00', '2020-08-14 15:13:37'),
(10, 'promo 20$', 2, '20.00', '', 2, NULL, 1, '2021-09-13 00:00:00', '2021-12-15 00:00:00', '2020-08-14 15:14:30'),
(11, 'PROMO VERANO', 2, '10.00', '2424', NULL, NULL, 1, '2020-08-21 00:00:00', '2021-09-21 00:00:00', '2020-08-20 12:16:38'),
(12, 'promo navidad 2', 1, '100.00', 'T09', NULL, NULL, 1, '2020-08-21 00:00:00', '2021-09-21 00:00:00', '2020-08-20 12:18:29'),
(13, 'PROMO ENERO 21', 1, '10.00', '752216095157', 2, NULL, 1, '2021-01-25 00:00:00', '2021-02-04 00:00:00', '2021-01-27 19:01:48'),
(14, 'PROMO COMAL', 2, '10.00', 'C58', NULL, NULL, 1, '2021-04-05 00:00:00', '2021-05-02 00:00:00', '2021-04-20 01:15:25');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `promotion_type`
--
CREATE TABLE `promotion_type` (
`id` int(11) NOT NULL,
`name` varchar(255) COLLATE latin1_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
--
-- Volcado de datos para la tabla `promotion_type`
--
INSERT INTO `promotion_type` (`id`, `name`) VALUES
(1, 'procentaje'),
(2, 'cantidad');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `purchase_order`
--
CREATE TABLE `purchase_order` (
`id_user` int(11) NOT NULL,
`uniqid` varchar(13) NOT NULL,
`input_date` timestamp NOT NULL DEFAULT current_timestamp(),
`id_item` varchar(6) NOT NULL,
`barcode` varchar(50) NOT NULL,
`item_name` varchar(100) NOT NULL,
`qty` decimal(14,0) NOT NULL,
`unit` varchar(4) NOT NULL,
`price` decimal(14,0) DEFAULT NULL,
`discprc` decimal(14,2) DEFAULT NULL,
`discrp` decimal(14,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `purchase_order`
--
INSERT INTO `purchase_order` (`id_user`, `uniqid`, `input_date`, `id_item`, `barcode`, `item_name`, `qty`, `unit`, `price`, `discprc`, `discrp`) VALUES
(6, '664be6a820984', '2024-05-21 00:13:40', 'PB0072', 'ABDP', 'ABANICO DE PEDESTAL DE FIERRO', '1', 'PZA', '59', '2590.00', '-2515.00');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `re`
--
CREATE TABLE `re` (
`id` int(11) NOT NULL,
`person_id` int(11) DEFAULT NULL,
`employee_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`operation_type_id` int(11) DEFAULT 2,
`box_id` int(11) DEFAULT NULL,
`p_id` int(11) DEFAULT NULL,
`d_id` int(11) DEFAULT NULL,
`total` double DEFAULT NULL,
`cash` double DEFAULT NULL,
`iva` double DEFAULT NULL,
`discount` double DEFAULT NULL,
`is_draft` tinyint(1) NOT NULL DEFAULT 0,
`stock_to_id` int(11) DEFAULT NULL,
`stock_from_id` int(11) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `routes`
--
CREATE TABLE `routes` (
`id` int(11) NOT NULL,
`idruta` int(11) DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
`name` varchar(50) NOT NULL,
`description` text DEFAULT NULL,
`status` tinyint(1) DEFAULT NULL,
`dateB` date DEFAULT NULL,
`created_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `routes`
--
INSERT INTO `routes` (`id`, `idruta`, `image`, `name`, `description`, `status`, `dateB`, `created_at`) VALUES
(1, 1, 'VILLA UNION', 'R VU-1', 'VILLA UNION COAH.', 0, NULL, '2020-05-30'),
(2, 2, NULL, 'R ALL-2', ' ALLENDE, COAHUILA', 0, NULL, '2024-03-01'),
(4, 4, 'MORELOS', 'R MO-4', 'MORELOS COAH', 0, NULL, '2020-05-30'),
(5, 5, 'ZARAGOZA', 'R ZZA-5', 'ZARAGOZA COAH', 0, NULL, '2020-05-30'),
(6, 6, 'NAVA', 'R NVA-6', 'NAVA COAH', 0, NULL, '2020-05-30'),
(7, 7, 'NAVA 2', 'R NVA-7', 'NAVA COAH', 0, NULL, '2020-05-30'),
(8, NULL, 'SAN CARLOS', 'R SAC-9', 'SAN CARLOS COAH', 1, '2024-03-20', '2020-05-30'),
(9, NULL, 'ALLENDE OFI', 'OFICINA', 'ALLENDE COAH', 0, NULL, '2020-05-30'),
(10, NULL, NULL, 'JURIDICO', ' 5 MANANTIALES Y EJIDOS', 0, NULL, '2023-11-08'),
(11, 0, NULL, '01 juridico', ' 5 MANANTIALES', 0, NULL, '2024-03-18'),
(12, 3, NULL, ' R ALL-3', ' ALLENDE COAH', 0, NULL, '2024-03-21');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `r_menu`
--
CREATE TABLE `r_menu` (
`id_menu` int(2) NOT NULL,
`name_menu` varchar(100) DEFAULT NULL,
`menu_order` int(2) DEFAULT NULL,
`icon` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `r_menu`
--
INSERT INTO `r_menu` (`id_menu`, `name_menu`, `menu_order`, `icon`) VALUES
(1, 'Almacen', 1, ''),
(2, 'Credito', 2, ''),
(3, 'Administracion', 7, ''),
(4, 'Usuarios', 4, NULL),
(5, 'Nominas', 5, NULL),
(6, 'Cobranza', 6, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `r_menu_sub`
--
CREATE TABLE `r_menu_sub` (
`id_sub_menu` int(3) NOT NULL,
`name_sub_menu` varchar(100) DEFAULT NULL,
`id_menu` int(2) DEFAULT NULL,
`sub_menu_order` int(2) DEFAULT NULL,
`hak_akses` varchar(30) DEFAULT '4',
`url` varchar(150) DEFAULT '#',
`content_before` varchar(200) DEFAULT NULL,
`content_after` varchar(200) DEFAULT NULL,
`icon` varchar(150) DEFAULT NULL,
`title` varchar(200) DEFAULT NULL,
`target` enum('_self','_blank') DEFAULT '_self'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `r_menu_sub`
--
INSERT INTO `r_menu_sub` (`id_sub_menu`, `name_sub_menu`, `id_menu`, `sub_menu_order`, `hak_akses`, `url`, `content_before`, `content_after`, `icon`, `title`, `target`) VALUES
(1, 'Productos', 1, 2, '2', 'application/master/v_item.php', NULL, NULL, '<i class=\"fa fa-glass\"></i>', 'Inventario', '_self'),
(2, 'Ventas Contado', 2, 3, '2', 'application/sales/v_pos.php', NULL, NULL, '<i class=\"fa fa-code\"></i>', 'Ventas de Mostrador', '_self'),
(3, 'Usuarios', 4, 5, '4', 'application/utility/v_mstuser.php', NULL, NULL, '<i class=\"fa fa-key\"></i>', 'Configuracion', '_self'),
(9, 'Cobradores', 6, 1, '4', 'application/debtcollector/generic.php', NULL, NULL, '<i class=\"fa fa-bicycle\"></i>', 'Cobradores app', '_self'),
(4, 'Proveedores', 1, 1, '4', 'application/customer/v_customer.php', NULL, NULL, '<i class=\"fa fa-database\"></i>', 'Proveedores', '_self'),
(5, 'Nomina', 5, 1, '4', 'application/sales/v_pos2.php', NULL, NULL, '<i class=\"fa fa-arrow-right\"></i>', 'nomina', '_self'),
(6, 'Ventas de Credito', 2, 2, '2', 'application/salesCredit/v_pos.php', NULL, NULL, '<i class=\"fa fa-arrow-right\"></i>', 'Ventas a Credito', '_self'),
(7, 'Alta Clientes', 2, 1, '4', 'application/Client/menuClient.php', NULL, NULL, '<i class=\"fa fa-child\"></i>', 'Clientes', '_self'),
(8, 'Reportes', 3, 2, '4', 'pos11/', NULL, NULL, '<i class=\"fa fa-home\"></i>', 'Administracion', '_self'),
(10, 'Cambiar Planificacion rutas', 6, 2, '4', 'application/routes/menu.php', NULL, NULL, NULL, 'Precios', '_self'),
(11, 'Bitacora Errores', 3, 6, '4', '#', NULL, NULL, NULL, NULL, '_self');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `r_ref_system`
--
CREATE TABLE `r_ref_system` (
`id` int(1) NOT NULL DEFAULT 1,
`name_shop` text DEFAULT NULL,
`address_shop` text DEFAULT NULL,
`phone_shop` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `r_ref_system`
--
INSERT INTO `r_ref_system` (`id`, `name_shop`, `address_shop`, `phone_shop`) VALUES
(1, 'Empresa: Sistemas Yusa SA de CV', 'Cerrada Zapotes 2A Quintas Campestre Laureles', '+528711446289');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `saving`
--
CREATE TABLE `saving` (
`id` int(11) NOT NULL,
`concept` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
`amount` float DEFAULT NULL,
`date_at` date DEFAULT NULL,
`kind` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `saving`
--
INSERT INTO `saving` (`id`, `concept`, `description`, `amount`, `date_at`, `kind`, `created_at`) VALUES
(1, 'ingreso diario', '$125 carro,$10 Cumpleaños suegra, $67 pension, $50 gasolina, $34 cable, $83 israel, $133 mandado, $130 Devaluacion del carro, $135 Ahorro. $3 sobrante', 770, '2020-06-29', 1, '2020-06-29 22:40:07'),
(77, 'compra de mercancia ', 'MONITOR Y GASOLINA ', 450, '2020-07-26', 2, '2020-07-26 12:32:38');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `sell`
--
CREATE TABLE `sell` (
`id` int(11) NOT NULL,
`sale_id` char(10) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`id_seller` int(11) NOT NULL,
`operation_type_id` int(11) DEFAULT 2,
`box_id` int(11) DEFAULT NULL,
`p_id` int(11) DEFAULT NULL,
`d_id` int(11) DEFAULT NULL,
`total` decimal(15,2) DEFAULT NULL,
`cash` decimal(15,2) DEFAULT NULL,
`iva` decimal(15,2) DEFAULT NULL,
`discount` decimal(15,2) DEFAULT NULL,
`enganche` decimal(15,2) DEFAULT NULL,
`is_draft` tinyint(1) NOT NULL DEFAULT 0,
`stock_to_id` int(11) DEFAULT NULL,
`stock_from_id` int(11) DEFAULT NULL,
`sale_date` date NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `sell`
--
INSERT INTO `sell` (`id`, `sale_id`, `person_id`, `user_id`, `id_seller`, `operation_type_id`, `box_id`, `p_id`, `d_id`, `total`, `cash`, `iva`, `discount`, `enganche`, `is_draft`, `stock_to_id`, `stock_from_id`, `sale_date`, `created_at`) VALUES
(5644, 'J231207001', 25044, NULL, 59, 2, NULL, 4, 1, '8180.00', '1.00', NULL, '0.00', '0.00', 0, NULL, NULL, '0000-00-00', '2024-05-20 15:50:07'),
(5645, 'J240518001', 27919, NULL, 59, 2, NULL, 4, 1, '2740.00', '1.00', NULL, '5.19', '150.00', 0, NULL, NULL, '2024-05-18', '2024-05-18 21:53:30'),
(5646, 'J240517001', 27362, NULL, 59, 2, NULL, 4, 1, '9980.00', '1.00', NULL, '0.00', '0.00', 0, NULL, NULL, '2024-05-17', '2024-05-18 22:05:32'),
(5648, 'J231207002', 25044, NULL, 57, 2, NULL, 4, 1, '11290.00', '1.00', NULL, '0.00', '560.00', 0, NULL, NULL, '2023-12-07', '2024-05-20 21:20:33'),
(5650, 'J221007001', 26436, NULL, 55, 2, NULL, 4, 1, '9440.00', '1.00', NULL, '4.55', '450.00', 0, NULL, NULL, '2022-10-07', '2024-05-21 00:08:42'),
(5651, 'J220719001', 26288, NULL, 59, 2, NULL, 4, 1, '7480.00', '1.00', NULL, '0.00', '0.00', 0, NULL, NULL, '2022-07-19', '2024-05-21 00:37:29');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `spend`
--
CREATE TABLE `spend` (
`id_d` int(11) NOT NULL,
`q` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`price` decimal(10,2) DEFAULT NULL,
`box_id` int(11) DEFAULT NULL,
`id_dev` int(11) DEFAULT NULL,
`f_pago` int(11) DEFAULT NULL,
`id_seller` int(11) NOT NULL,
`created_at` datetime DEFAULT NULL,
`date_dev` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `spend`
--
INSERT INTO `spend` (`id_d`, `q`, `name`, `price`, `box_id`, `id_dev`, `f_pago`, `id_seller`, `created_at`, `date_dev`) VALUES
(1, 1, 'Devolucion - Venta - 1751 - MAQUINA DE SOPES', '110.00', 214, 1, 1, 0, '2017-05-29 16:35:04', '2020-12-05 04:27:07'),
(183, 1, 'Devolucion - Venta - J210503002 - FALDA Y BLUSA T', '140.00', 224, 5456, 1, 6, '2021-05-03 18:28:14', '2021-09-20 03:30:58');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `spendg`
--
CREATE TABLE `spendg` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`price` double DEFAULT NULL,
`box_id` int(11) DEFAULT NULL,
`id_dev` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`type_spend_id` int(11) DEFAULT NULL,
`spend_type_recurrent_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`input_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `spendg`
--
INSERT INTO `spendg` (`id`, `name`, `price`, `box_id`, `id_dev`, `person_id`, `type_spend_id`, `spend_type_recurrent_id`, `created_at`, `input_date`) VALUES
(1, 'GORDITAS', 65, 224, NULL, NULL, 7, NULL, '2020-06-02 12:04:44', '2021-09-20 03:30:58'),
(134, 'GASTOS CASA 26 JULIO', 213, 224, NULL, NULL, 1, NULL, '2020-07-26 12:33:37', '2021-09-20 03:30:58');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `spend_type`
--
CREATE TABLE `spend_type` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`spend_type_recurrent_id` int(11) DEFAULT NULL,
`input_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `spend_type`
--
INSERT INTO `spend_type` (`id`, `name`, `spend_type_recurrent_id`, `input_date`, `created_at`) VALUES
(1, 'Sueldos', 1, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(2, 'Costo_Operacion', 1, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(3, 'Gastos_Generales', 1, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(4, 'Gasolina', 2, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(5, 'Rentas', 4, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(6, 'Vehiculo', 1, '2020-06-02 06:56:22', '0000-00-00 00:00:00'),
(7, 'Comidas', 1, '2020-06-02 06:56:22', '0000-00-00 00:00:00'),
(8, 'Herramientas', 4, '2020-06-02 06:56:22', '0000-00-00 00:00:00'),
(20, 'CFE', 1, '2020-06-02 08:45:17', '2020-06-02 02:45:17'),
(24, 'Gasto Foraneo Extra', 1, '2020-06-02 17:57:24', '2020-06-02 11:57:24'),
(25, 'pension', 1, '2020-06-29 06:28:18', '2020-06-29 00:28:18'),
(26, 'otros gastos-desconocidos', 1, '2020-06-29 06:54:32', '2020-06-29 00:54:32'),
(27, 'gasolina viajes ', 1, '2020-07-23 05:24:03', '2020-07-22 23:24:03');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `spend_type_recurrent`
--
CREATE TABLE `spend_type_recurrent` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`unit` int(11) DEFAULT NULL,
`input_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `spend_type_recurrent`
--
INSERT INTO `spend_type_recurrent` (`id`, `name`, `unit`, `input_date`, `created_at`) VALUES
(1, 'diario', 1, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(2, 'Semanal', 6, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(3, 'Quincenal', 13, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(4, 'Mensual', 26, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(5, 'trimestral', 3, '2020-06-02 06:56:21', '0000-00-00 00:00:00'),
(6, 'Anual', 12, '2020-06-02 06:56:21', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `stock`
--
CREATE TABLE `stock` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`is_principal` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `stock`
--
INSERT INTO `stock` (`id`, `name`, `is_principal`) VALUES
(1, 'Principal', 1),
(2, 'Piedras Negras', 0),
(3, 'Acuña', 0),
(4, 'Reparto', 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `supplier`
--
CREATE TABLE `supplier` (
`id_cust` int(11) NOT NULL,
`name` varchar(40) DEFAULT NULL,
`address` varchar(20) DEFAULT NULL,
`id_ruta` int(2) DEFAULT 1,
`email1` varchar(25) NOT NULL,
`credit_limit` decimal(15,2) NOT NULL DEFAULT 1000.00,
`rfc` varchar(20) NOT NULL,
`trabajo` varchar(100) DEFAULT NULL,
`antiguedad` decimal(10,2) DEFAULT NULL,
`gender` enum('SI','NO') DEFAULT NULL,
`country` varchar(40) DEFAULT NULL,
`phone` char(35) DEFAULT NULL,
`reason` varchar(50) DEFAULT NULL,
`status` int(1) DEFAULT 1,
`date_down` date DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `supplier`
--
INSERT INTO `supplier` (`id_cust`, `name`, `address`, `id_ruta`, `email1`, `credit_limit`, `rfc`, `trabajo`, `antiguedad`, `gender`, `country`, `phone`, `reason`, `status`, `date_down`, `created_at`) VALUES
(3, 'MUEBLES GARCIA ', NULL, 1, '', '1000.00', '', NULL, NULL, 'SI', 'MONTERREY NUEVO LEON', '8119114908 2', NULL, 1, NULL, '2023-10-06 21:33:26'),
(4, 'DISTRIBUIDOR EU.', NULL, 1, '', '1000.00', '', NULL, NULL, 'SI', 'ESTADOS UNIDOS AMERICANOS 2', '018302273042', NULL, 1, NULL, '2023-10-06 16:34:18'),
(5, 'DISA MUEBLEROS', NULL, 1, '', '1000.00', '', NULL, NULL, 'SI', ' TORREON COAH', '8444144950', NULL, 1, NULL, '2023-10-11 17:04:07'),
(6, 'MUEBLES CHIHUAHUA', NULL, 1, '', '1000.00', '', NULL, NULL, 'SI', 'DELICIAS CHIHUAHUA', '6391068313', NULL, 1, NULL, '2022-06-08 01:36:06'),
(8, 'SISTEMAS YUSA 45', NULL, 1, '', '1000.00', '', NULL, NULL, 'SI', 'TORREON COAH', '8711446289', NULL, 1, NULL, '2023-10-14 23:22:11'),
(13, 'DISTRIBUIDOR MAYITO', NULL, 1, '', '1000.00', '', NULL, NULL, 'SI', 'TORREON COAH', '8727711075', NULL, 1, NULL, '2023-10-06 16:38:17'),
(14, 'SUPER COLCHONES MAXI FLON', NULL, 1, '', '1000.00', '', NULL, NULL, 'SI', 'MONTERREY NL', '8119114908', NULL, 1, NULL, '2023-10-11 17:03:16'),
(15, 'TUBULARES CHEMA', NULL, 1, '', '1000.00', '', NULL, NULL, 'SI', 'MONTERREY NL.', '811 5093236', NULL, 1, NULL, '2024-03-05 15:26:15');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `temp_exist`
--
CREATE TABLE `temp_exist` (
`id_user` int(11) NOT NULL,
`uniqid` varchar(13) NOT NULL,
`input_date` timestamp NOT NULL DEFAULT current_timestamp(),
`id_item` varchar(6) NOT NULL,
`barcode` varchar(50) NOT NULL,
`item_name` varchar(100) NOT NULL,
`price` decimal(10,2) DEFAULT NULL,
`compras` decimal(10,2) DEFAULT NULL,
`ventas` decimal(10,2) NOT NULL,
`dev` decimal(10,2) DEFAULT NULL,
`ajustes` decimal(10,2) DEFAULT NULL,
`existencia` decimal(14,2) DEFAULT NULL,
`created_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `temp_sale`
--
CREATE TABLE `temp_sale` (
`id_user` int(11) NOT NULL,
`uniqid` varchar(13) NOT NULL,
`input_date` timestamp NOT NULL DEFAULT current_timestamp(),
`id_item` varchar(6) NOT NULL,
`barcode` varchar(50) NOT NULL,
`item_name` varchar(100) NOT NULL,
`qty` decimal(12,0) DEFAULT NULL,
`unit` varchar(4) NOT NULL,
`price` decimal(10,5) DEFAULT NULL,
`discprc` decimal(5,2) DEFAULT NULL,
`discrp` int(14) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `t_sale`
--
CREATE TABLE `t_sale` (
`sale_id` char(10) NOT NULL,
`id_user` int(11) NOT NULL,
`re_id` int(11) DEFAULT NULL,
`id_client` int(11) NOT NULL,
`id_seller` int(11) NOT NULL,
`id_collector` int(11) DEFAULT 1,
`sale_date` date NOT NULL,
`input_date` timestamp NOT NULL DEFAULT current_timestamp(),
`total` decimal(10,2) NOT NULL,
`paid` decimal(10,2) DEFAULT NULL,
`disc_prcn` decimal(10,2) DEFAULT 0.00,
`disc_rp` int(14) DEFAULT 0,
`sts` int(1) NOT NULL DEFAULT 1 COMMENT '2 en transito,1 activo, 0 borrado',
`note` text DEFAULT NULL,
`is_credit` int(1) NOT NULL DEFAULT 0 COMMENT '1 credito, 0 nocredito',
`credit_amount` decimal(10,2) DEFAULT NULL,
`f_pago1` int(2) DEFAULT NULL,
`f_pago2` int(2) DEFAULT NULL,
`stock_id` tinyint(1) NOT NULL DEFAULT 1,
`deliver_date` datetime DEFAULT NULL,
`deliver_sts` int(1) NOT NULL DEFAULT 0 COMMENT '0 = sin asignar ruta/ esperando siguiente cobro , 1 = cobranza generada para antes de asignar a cobrar\r\n2=en ruta de cobro '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `t_sale`
--
INSERT INTO `t_sale` (`sale_id`, `id_user`, `re_id`, `id_client`, `id_seller`, `id_collector`, `sale_date`, `input_date`, `total`, `paid`, `disc_prcn`, `disc_rp`, `sts`, `note`, `is_credit`, `credit_amount`, `f_pago1`, `f_pago2`, `stock_id`, `deliver_date`, `deliver_sts`) VALUES
('J220719001', 6, 0, 26288, 59, 0, '2022-07-19', '2024-05-21 00:37:29', '7480.00', '1.00', '0.00', 0, 1, '', 1, NULL, 1, 4, 1, NULL, 0),
('J221007001', 6, 0, 26436, 55, 0, '2022-10-07', '2024-05-21 00:08:42', '9440.00', '1.00', '4.55', 450, 1, '', 1, NULL, 1, 4, 1, NULL, 0),
('J231207002', 6, 0, 25044, 57, 0, '2023-12-07', '2024-05-20 21:20:33', '11290.00', '1.00', '0.00', 560, 1, '', 1, NULL, 1, 4, 1, NULL, 0),
('J240517001', 6, 0, 27362, 59, 86, '2024-05-17', '2024-05-18 22:05:32', '9980.00', '1.00', '0.00', 0, 1, '', 1, NULL, 1, 4, 1, NULL, 0),
('J240518001', 6, 0, 27919, 59, 0, '2024-05-18', '2024-05-18 21:53:30', '2740.00', '1.00', '5.19', 150, 1, '', 1, NULL, 1, 4, 1, NULL, 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `t_sale_detail`
--
CREATE TABLE `t_sale_detail` (
`autoid` int(11) NOT NULL,
`sale_id` char(10) NOT NULL,
`id_item` varchar(6) NOT NULL,
`barcode` varchar(50) NOT NULL,
`item_name` varchar(150) NOT NULL,
`qty` decimal(14,0) DEFAULT NULL,
`unit` varchar(4) NOT NULL,
`price` decimal(10,2) DEFAULT NULL,
`disc_prc` decimal(10,2) DEFAULT 0.00,
`disc_rp` decimal(10,2) DEFAULT 0.00,
`is_draft` bit(1) DEFAULT b'0',
`re_id` int(11) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `t_sale_detail`
--
INSERT INTO `t_sale_detail` (`autoid`, `sale_id`, `id_item`, `barcode`, `item_name`, `qty`, `unit`, `price`, `disc_prc`, `disc_rp`, `is_draft`, `re_id`, `created_at`) VALUES
(1138, 'J1212##001', 'PB0073', 'ABDPM', 'ABANICO DE PISO MAN', '1', 'PZA', '2590.00', '0.00', '456.00', b'0', 0, '2024-05-20 21:07:27'),
(1142, 'J220719001', 'PB0043', 'ESHO', 'ESPEJO HOLANDA', '1', 'PZA', '7480.00', '0.00', '0.00', b'0', 0, '2024-05-21 00:37:30'),
(1141, 'J221007001', 'PB0027', 'ROTOCH', 'ROPERO TORREON CHOCO', '1', 'PZA', '9890.00', '0.00', '450.00', b'0', 0, '2024-05-21 00:08:42'),
(1135, 'J231207001', 'PB0038', 'POCH', 'PORTAMICRO CHOCO', '1', 'PZA', '8180.00', '0.00', '0.00', b'0', 0, '2024-05-20 15:47:58'),
(1139, 'J231207002', 'PB0034', 'ALAN', 'ALACENA ANDREA', '1', 'PZA', '11290.00', '0.00', '560.00', b'0', 0, '2024-05-20 21:20:33'),
(1137, 'J240517001', 'PB0051', 'COMA2M', 'COLCHO MATRIMONIAL 2 COLCHMILAN', '1', 'PZA', '9980.00', '0.00', '0.00', b'0', 0, '2024-05-18 22:05:33'),
(1136, 'J240518001', 'PB0001', 'JUSAKM', 'JGO DE SARTENES KUN FU MASTHER', '1', 'JGO', '2890.00', '0.00', '150.00', b'0', 0, '2024-05-18 21:53:30');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `user`
--
CREATE TABLE `user` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`lastname` varchar(50) NOT NULL,
`username` varchar(50) DEFAULT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(60) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`kind` int(11) NOT NULL DEFAULT 1,
`stock_id` int(11) DEFAULT 1,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `user`
--
INSERT INTO `user` (`id`, `name`, `lastname`, `username`, `email`, `password`, `image`, `status`, `kind`, `stock_id`, `created_at`) VALUES
(1, 'Sistemas Yusa', 'admin', 'YUSA21', 'admin2', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', NULL, 1, 1, 3, '2020-05-17 00:57:10'),
(2, 'JUAN PABLO', 'FUENTES ENRIQUEZ', 'PABLO23', 'pablo', 'adcd7048512e64b48da55b027577886ee5a36350', NULL, 1, 3, 2, '2017-04-20 16:40:03'),
(3, 'almacenista', 'AGUILAR', 'almacen', 'almacen1', '10470c3b4b1fed12c3baac014be15fac67c6e815', NULL, 1, 3, 4, '2017-04-20 16:40:30'),
(4, 'Administrador', 'admin2', 'YUSA20', 'admin3', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', NULL, 1, 1, 3, '2017-04-20 13:54:17'),
(5, 'almacen1', 'cajero1', 'cajero1', 'bhereur@gmail.com', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', NULL, 1, 1, 1, '2020-06-29 22:31:26'),
(6, 'Pedro', 'de Hoyos', 'GERENCIA', 'PEDRO74', 'adcd7048512e64b48da55b027577886ee5a36350', NULL, 1, 1, 1, '2021-01-04 23:09:52'),
(10, 'julio', 'aguilar', 'julio', 'julio', '10470c3b4b1fed12c3baac014be15fac67c6e815', NULL, 1, 1, NULL, '2021-09-20 15:51:29');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `users`
--
CREATE TABLE `users` (
`user_id` int(7) NOT NULL,
`fb_user` varchar(100) DEFAULT NULL,
`user_date` timestamp NOT NULL DEFAULT current_timestamp(),
`user_name` varchar(50) NOT NULL,
`user_email` varchar(50) NOT NULL,
`user_password` varchar(60) NOT NULL,
`user_image` varchar(200) NOT NULL DEFAULT 'https://cdn1.iconfinder.com/data/icons/avatars-vol-2/140/_robocop-512.png',
`user_selected_device` int(7) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `users`
--
INSERT INTO `users` (`user_id`, `fb_user`, `user_date`, `user_name`, `user_email`, `user_password`, `user_image`, `user_selected_device`) VALUES
(1, NULL, '2020-07-30 10:17:29', 'ISRAEL ALVARADO AGUILAR', 'syusa19802017@gmail.com', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', 'https://cdn1.iconfinder.com/data/icons/avatars-vol-2/140/_robocop-512.png', NULL),
(2, NULL, '2020-07-30 10:21:58', 'juan luis marrero', 'syusa@gmail.com', '5437a9b2bf1e9a6021f19d9e5ddcc7a6fc176531', 'https://cdn1.iconfinder.com/data/icons/avatars-vol-2/140/_robocop-512.png', NULL),
(3, NULL, '2021-01-12 06:21:24', 'Israel Alvarado aguilar', 'bomban8@hotmail.com', '2a4941c7c24121246a53f121864bfb56fc2efd3c', 'https://cdn1.iconfinder.com/data/icons/avatars-vol-2/140/_robocop-512.png', 1),
(4, NULL, '2021-02-18 06:07:48', 'ISRAEL ALVARADO AGUILAR', 'syusa19802018@gmail.com', '1ff16dd8c598aeb99c6447e16ff2daa9dda68998', 'https://cdn1.iconfinder.com/data/icons/avatars-vol-2/140/_robocop-512.png', NULL),
(5, NULL, '2021-02-18 06:10:32', 'ISRAEL ALVARADO AGUILAR', 'viridiana.mtz62@gmail.com', '2a4941c7c24121246a53f121864bfb56fc2efd3c', 'https://cdn1.iconfinder.com/data/icons/avatars-vol-2/140/_robocop-512.png', NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `valores`
--
CREATE TABLE `valores` (
`id` int(11) NOT NULL,
`valor` varchar(50) NOT NULL,
`tiempo` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`t_registro` varchar(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estructura para la vista `devices_full`
--
DROP TABLE IF EXISTS `devices_full`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `devices_full` AS SELECT `data`.`data_id` AS `data_id`, `data`.`data_date` AS `data_date`, `data`.`data_temp` AS `data_temp`, `data`.`data_hum` AS `data_hum`, `data`.`data_device_sn` AS `data_device_sn`, `devices`.`device_id` AS `device_id` FROM (`data` join `devices`) WHERE `devices`.`device_sn` = `data`.`data_device_sn` ;
--
-- Índices para tablas volcadas
--
--
-- Indices de la tabla `accounts`
--
ALTER TABLE `accounts`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `ajust`
--
ALTER TABLE `ajust`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `box`
--
ALTER TABLE `box`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `category`
--
ALTER TABLE `category`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `collection_data`
--
ALTER TABLE `collection_data`
ADD PRIMARY KEY (`id_cust`),
ADD KEY `RelacionClienteTrabajo3` (`id_client`);
--
-- Indices de la tabla `comprobantesfiscales`
--
ALTER TABLE `comprobantesfiscales`
ADD PRIMARY KEY (`id`),
ADD KEY `id` (`id`);
--
-- Indices de la tabla `configuration`
--
ALTER TABLE `configuration`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `short` (`short`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indices de la tabla `customer`
--
ALTER TABLE `customer`
ADD PRIMARY KEY (`id_cust`),
ADD UNIQUE KEY `contract` (`contract`);
--
-- Indices de la tabla `customer_terminated`
--
ALTER TABLE `customer_terminated`
ADD PRIMARY KEY (`id`),
ADD KEY `id` (`id`);
--
-- Indices de la tabla `d`
--
ALTER TABLE `d`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `data`
--
ALTER TABLE `data`
ADD PRIMARY KEY (`data_id`);
--
-- Indices de la tabla `dev1`
--
ALTER TABLE `dev1`
ADD PRIMARY KEY (`id`),
ADD KEY `p_id` (`p_id`),
ADD KEY `d_id` (`d_id`),
ADD KEY `box_id` (`box_id`),
ADD KEY `operation_type_id` (`operation_type_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `person_id` (`person_id`);
--
-- Indices de la tabla `devices`
--
ALTER TABLE `devices`
ADD PRIMARY KEY (`device_id`);
--
-- Indices de la tabla `employee`
--
ALTER TABLE `employee`
ADD PRIMARY KEY (`id_cust`),
ADD UNIQUE KEY `contract` (`contract`),
ADD UNIQUE KEY `name` (`name`),
ADD UNIQUE KEY `route_id_2` (`route_id`),
ADD KEY `id_ruta` (`id_ruta`),
ADD KEY `route_id` (`route_id`);
--
-- Indices de la tabla `employee_terminated`
--
ALTER TABLE `employee_terminated`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indices de la tabla `endorsement`
--
ALTER TABLE `endorsement`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `facturaok`
--
ALTER TABLE `facturaok`
ADD PRIMARY KEY (`id`),
ADD KEY `sell_id` (`sell_id`),
ADD KEY `sale_id` (`sale_id`),
ADD KEY `box_id` (`box_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `person_id` (`person_id`);
--
-- Indices de la tabla `formapago`
--
ALTER TABLE `formapago`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `gpslocations`
--
ALTER TABLE `gpslocations`
ADD PRIMARY KEY (`GPSLocationID`),
ADD KEY `sessionIDIndex` (`sessionID`),
ADD KEY `phoneNumberIndex` (`phoneNumber`),
ADD KEY `userNameIndex` (`userName`);
--
-- Indices de la tabla `job1`
--
ALTER TABLE `job1`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `jobok`
--
ALTER TABLE `jobok`
ADD PRIMARY KEY (`id_cust`),
ADD KEY `contract` (`contract`);
--
-- Indices de la tabla `listprice`
--
ALTER TABLE `listprice`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `id_prod_2` (`id_prod`),
ADD KEY `id_prod` (`id_prod`);
--
-- Indices de la tabla `message`
--
ALTER TABLE `message`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `m_item`
--
ALTER TABLE `m_item`
ADD PRIMARY KEY (`id_item`),
ADD UNIQUE KEY `unik` (`item_name`),
ADD UNIQUE KEY `barcode` (`barcode`);
--
-- Indices de la tabla `m_user`
--
ALTER TABLE `m_user`
ADD PRIMARY KEY (`id_user`),
ADD UNIQUE KEY `NewIndex1` (`username`);
--
-- Indices de la tabla `operation`
--
ALTER TABLE `operation`
ADD PRIMARY KEY (`id`),
ADD KEY `stock_id` (`stock_id`),
ADD KEY `stock_destination_id` (`stock_destination_id`),
ADD KEY `product_id` (`product_id`),
ADD KEY `operation_type_id` (`operation_type_id`),
ADD KEY `sell_id` (`sell_id`);
--
-- Indices de la tabla `operation2`
--
ALTER TABLE `operation2`
ADD PRIMARY KEY (`id`),
ADD KEY `stock_id` (`stock_id`),
ADD KEY `stock_destination_id` (`stock_destination_id`),
ADD KEY `product_id` (`product_id`),
ADD KEY `operation_type_id` (`operation_type_id`),
ADD KEY `re_id` (`re_id`);
--
-- Indices de la tabla `operation_type`
--
ALTER TABLE `operation_type`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `p`
--
ALTER TABLE `p`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `payment`
--
ALTER TABLE `payment`
ADD PRIMARY KEY (`id`),
ADD KEY `person_id` (`person_id`),
ADD KEY `sale_id` (`sale_id`),
ADD KEY `payment_type_id` (`payment_type_id`);
--
-- Indices de la tabla `payment_type`
--
ALTER TABLE `payment_type`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `pending_route`
--
ALTER TABLE `pending_route`
ADD PRIMARY KEY (`id`),
ADD KEY `pending_route_ibfk_1` (`collector_id`),
ADD KEY `pending_route_ibfk_2` (`contract`);
--
-- Indices de la tabla `person`
--
ALTER TABLE `person`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `product`
--
ALTER TABLE `product`
ADD PRIMARY KEY (`id`),
ADD KEY `category_id` (`category_id`),
ADD KEY `user_id` (`user_id`);
--
-- Indices de la tabla `promotion`
--
ALTER TABLE `promotion`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `promotion_type`
--
ALTER TABLE `promotion_type`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `purchase_order`
--
ALTER TABLE `purchase_order`
ADD PRIMARY KEY (`id_user`,`uniqid`,`id_item`,`item_name`,`unit`),
ADD KEY `id_item` (`id_item`),
ADD KEY `barcode` (`barcode`);
--
-- Indices de la tabla `re`
--
ALTER TABLE `re`
ADD PRIMARY KEY (`id`),
ADD KEY `p_id` (`p_id`),
ADD KEY `d_id` (`d_id`),
ADD KEY `box_id` (`box_id`),
ADD KEY `operation_type_id` (`operation_type_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `person_id` (`person_id`),
ADD KEY `employee_id` (`employee_id`);
--
-- Indices de la tabla `routes`
--
ALTER TABLE `routes`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indices de la tabla `r_menu`
--
ALTER TABLE `r_menu`
ADD PRIMARY KEY (`id_menu`);
--
-- Indices de la tabla `r_menu_sub`
--
ALTER TABLE `r_menu_sub`
ADD PRIMARY KEY (`id_sub_menu`),
ADD KEY `urutan_sub_menu_index` (`id_menu`,`sub_menu_order`);
--
-- Indices de la tabla `r_ref_system`
--
ALTER TABLE `r_ref_system`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `saving`
--
ALTER TABLE `saving`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `sell`
--
ALTER TABLE `sell`
ADD PRIMARY KEY (`id`),
ADD KEY `p_id` (`p_id`),
ADD KEY `d_id` (`d_id`),
ADD KEY `box_id` (`box_id`),
ADD KEY `operation_type_id` (`operation_type_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `sell_ibfk_6` (`person_id`);
--
-- Indices de la tabla `spend`
--
ALTER TABLE `spend`
ADD PRIMARY KEY (`id_d`),
ADD KEY `id_dev` (`id_dev`),
ADD KEY `f_pago` (`f_pago`);
--
-- Indices de la tabla `spendg`
--
ALTER TABLE `spendg`
ADD PRIMARY KEY (`id`),
ADD KEY `type_spend_id` (`type_spend_id`),
ADD KEY `spend_type_recurrent_id` (`spend_type_recurrent_id`),
ADD KEY `person_id` (`person_id`),
ADD KEY `box_id` (`box_id`);
--
-- Indices de la tabla `spend_type`
--
ALTER TABLE `spend_type`
ADD PRIMARY KEY (`id`),
ADD KEY `spend_type_recurrent_id` (`spend_type_recurrent_id`);
--
-- Indices de la tabla `spend_type_recurrent`
--
ALTER TABLE `spend_type_recurrent`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `stock`
--
ALTER TABLE `stock`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `supplier`
--
ALTER TABLE `supplier`
ADD PRIMARY KEY (`id_cust`);
--
-- Indices de la tabla `temp_exist`
--
ALTER TABLE `temp_exist`
ADD PRIMARY KEY (`id_user`,`uniqid`,`id_item`,`item_name`),
ADD KEY `id_item` (`id_item`),
ADD KEY `barcode` (`barcode`);
--
-- Indices de la tabla `temp_sale`
--
ALTER TABLE `temp_sale`
ADD PRIMARY KEY (`id_user`,`uniqid`,`id_item`,`item_name`,`unit`);
--
-- Indices de la tabla `t_sale`
--
ALTER TABLE `t_sale`
ADD PRIMARY KEY (`sale_id`),
ADD KEY `f_pago1` (`f_pago1`,`f_pago2`),
ADD KEY `f_pago2` (`f_pago2`);
--
-- Indices de la tabla `t_sale_detail`
--
ALTER TABLE `t_sale_detail`
ADD PRIMARY KEY (`sale_id`,`id_item`,`item_name`,`unit`),
ADD KEY `autoid` (`autoid`);
--
-- Indices de la tabla `user`
--
ALTER TABLE `user`
ADD PRIMARY KEY (`id`),
ADD KEY `stock_id` (`stock_id`);
--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`);
--
-- Indices de la tabla `valores`
--
ALTER TABLE `valores`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT de las tablas volcadas
--
--
-- AUTO_INCREMENT de la tabla `accounts`
--
ALTER TABLE `accounts`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;
--
-- AUTO_INCREMENT de la tabla `ajust`
--
ALTER TABLE `ajust`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT de la tabla `box`
--
ALTER TABLE `box`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=225;
--
-- AUTO_INCREMENT de la tabla `category`
--
ALTER TABLE `category`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT de la tabla `collection_data`
--
ALTER TABLE `collection_data`
MODIFY `id_cust` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;
--
-- AUTO_INCREMENT de la tabla `comprobantesfiscales`
--
ALTER TABLE `comprobantesfiscales`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `configuration`
--
ALTER TABLE `configuration`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT de la tabla `customer`
--
ALTER TABLE `customer`
MODIFY `id_cust` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=170;
--
-- AUTO_INCREMENT de la tabla `customer_terminated`
--
ALTER TABLE `customer_terminated`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `d`
--
ALTER TABLE `d`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT de la tabla `data`
--
ALTER TABLE `data`
MODIFY `data_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `dev1`
--
ALTER TABLE `dev1`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT de la tabla `devices`
--
ALTER TABLE `devices`
MODIFY `device_id` int(7) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `employee`
--
ALTER TABLE `employee`
MODIFY `id_cust` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;
--
-- AUTO_INCREMENT de la tabla `employee_terminated`
--
ALTER TABLE `employee_terminated`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT de la tabla `endorsement`
--
ALTER TABLE `endorsement`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=194;
--
-- AUTO_INCREMENT de la tabla `facturaok`
--
ALTER TABLE `facturaok`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT de la tabla `formapago`
--
ALTER TABLE `formapago`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT de la tabla `gpslocations`
--
ALTER TABLE `gpslocations`
MODIFY `GPSLocationID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT de la tabla `job1`
--
ALTER TABLE `job1`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT de la tabla `jobok`
--
ALTER TABLE `jobok`
MODIFY `id_cust` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;
--
-- AUTO_INCREMENT de la tabla `listprice`
--
ALTER TABLE `listprice`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT de la tabla `message`
--
ALTER TABLE `message`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT de la tabla `m_user`
--
ALTER TABLE `m_user`
MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT de la tabla `operation`
--
ALTER TABLE `operation`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25946;
--
-- AUTO_INCREMENT de la tabla `operation2`
--
ALTER TABLE `operation2`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10488;
--
-- AUTO_INCREMENT de la tabla `operation_type`
--
ALTER TABLE `operation_type`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT de la tabla `p`
--
ALTER TABLE `p`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT de la tabla `payment`
--
ALTER TABLE `payment`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;
--
-- AUTO_INCREMENT de la tabla `payment_type`
--
ALTER TABLE `payment_type`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `pending_route`
--
ALTER TABLE `pending_route`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT de la tabla `person`
--
ALTER TABLE `person`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT de la tabla `product`
--
ALTER TABLE `product`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5607;
--
-- AUTO_INCREMENT de la tabla `promotion`
--
ALTER TABLE `promotion`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT de la tabla `promotion_type`
--
ALTER TABLE `promotion_type`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `re`
--
ALTER TABLE `re`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6290;
--
-- AUTO_INCREMENT de la tabla `routes`
--
ALTER TABLE `routes`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
--
-- AUTO_INCREMENT de la tabla `r_menu`
--
ALTER TABLE `r_menu`
MODIFY `id_menu` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT de la tabla `r_menu_sub`
--
ALTER TABLE `r_menu_sub`
MODIFY `id_sub_menu` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;
--
-- AUTO_INCREMENT de la tabla `saving`
--
ALTER TABLE `saving`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
--
-- AUTO_INCREMENT de la tabla `sell`
--
ALTER TABLE `sell`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5652;
--
-- AUTO_INCREMENT de la tabla `spend`
--
ALTER TABLE `spend`
MODIFY `id_d` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=184;
--
-- AUTO_INCREMENT de la tabla `spendg`
--
ALTER TABLE `spendg`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135;
--
-- AUTO_INCREMENT de la tabla `spend_type`
--
ALTER TABLE `spend_type`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT de la tabla `spend_type_recurrent`
--
ALTER TABLE `spend_type_recurrent`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT de la tabla `stock`
--
ALTER TABLE `stock`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT de la tabla `supplier`
--
ALTER TABLE `supplier`
MODIFY `id_cust` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT de la tabla `t_sale_detail`
--
ALTER TABLE `t_sale_detail`
MODIFY `autoid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1143;
--
-- AUTO_INCREMENT de la tabla `user`
--
ALTER TABLE `user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
MODIFY `user_id` int(7) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT de la tabla `valores`
--
ALTER TABLE `valores`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- Restricciones para tablas volcadas
--
--
-- Filtros para la tabla `collection_data`
--
ALTER TABLE `collection_data`
ADD CONSTRAINT `collection_data_ibfk_1` FOREIGN KEY (`id_client`) REFERENCES `customer` (`id_cust`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Filtros para la tabla `dev1`
--
ALTER TABLE `dev1`
ADD CONSTRAINT `dev1_ibfk_1` FOREIGN KEY (`p_id`) REFERENCES `p` (`id`),
ADD CONSTRAINT `dev1_ibfk_2` FOREIGN KEY (`d_id`) REFERENCES `d` (`id`),
ADD CONSTRAINT `dev1_ibfk_3` FOREIGN KEY (`box_id`) REFERENCES `box` (`id`),
ADD CONSTRAINT `dev1_ibfk_4` FOREIGN KEY (`operation_type_id`) REFERENCES `operation_type` (`id`),
ADD CONSTRAINT `dev1_ibfk_5` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
ADD CONSTRAINT `dev1_ibfk_6` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`);
--
-- Filtros para la tabla `jobok`
--
ALTER TABLE `jobok`
ADD CONSTRAINT `jobok_ibfk_1` FOREIGN KEY (`contract`) REFERENCES `customer` (`contract`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Filtros para la tabla `product`
--
ALTER TABLE `product`
ADD CONSTRAINT `product_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
ADD CONSTRAINT `product_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
--
-- Filtros para la tabla `re`
--
ALTER TABLE `re`
ADD CONSTRAINT `re_ibfk_1` FOREIGN KEY (`p_id`) REFERENCES `p` (`id`),
ADD CONSTRAINT `re_ibfk_2` FOREIGN KEY (`d_id`) REFERENCES `d` (`id`),
ADD CONSTRAINT `re_ibfk_3` FOREIGN KEY (`box_id`) REFERENCES `box` (`id`),
ADD CONSTRAINT `re_ibfk_4` FOREIGN KEY (`operation_type_id`) REFERENCES `operation_type` (`id`),
ADD CONSTRAINT `re_ibfk_5` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
ADD CONSTRAINT `re_ibfk_6` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
ADD CONSTRAINT `re_ibfk_7` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`id_cust`);
--
-- Filtros para la tabla `spendg`
--
ALTER TABLE `spendg`
ADD CONSTRAINT `spendg_ibfk_1` FOREIGN KEY (`type_spend_id`) REFERENCES `spend_type` (`id`),
ADD CONSTRAINT `spendg_ibfk_2` FOREIGN KEY (`spend_type_recurrent_id`) REFERENCES `spend_type_recurrent` (`id`),
ADD CONSTRAINT `spendg_ibfk_3` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
ADD CONSTRAINT `spendg_ibfk_4` FOREIGN KEY (`box_id`) REFERENCES `box` (`id`);
--
-- Filtros para la tabla `spend_type`
--
ALTER TABLE `spend_type`
ADD CONSTRAINT `spend_type_ibfk_1` FOREIGN KEY (`spend_type_recurrent_id`) REFERENCES `spend_type_recurrent` (`id`);
--
-- Filtros para la tabla `t_sale`
--
ALTER TABLE `t_sale`
ADD CONSTRAINT `t_sale_ibfk_1` FOREIGN KEY (`f_pago1`) REFERENCES `formapago` (`id`),
ADD CONSTRAINT `t_sale_ibfk_2` FOREIGN KEY (`f_pago2`) REFERENCES `formapago` (`id`);
--
-- Filtros para la tabla `user`
--
ALTER TABLE `user`
ADD CONSTRAINT `user_ibfk_1` FOREIGN KEY (`stock_id`) REFERENCES `stock` (`id`);
COMMIT;
/*!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 */;