BackupData.sql

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE IF NOT EXISTS `yeumeent_LoremIpsumDolar` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;
USE `yeumeent_LoremIpsumDolar`;

CREATE TABLE IF NOT EXISTS `Admins` (
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_vietnamese_ci NOT NULL,
  `password` varchar(50) NOT NULL,
  `Role` char(50) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO `Admins` (`username`, `password`, `Role`) VALUES
	('a', 'PBf0OvbZztazdQfPuQ2eMrBzJUnlYaPUzWtWu8++jZw=', 'Staff'),
	('b', '7Pt1G0oYwma/VJeCQMnJJgkbDolxS9LvaJY1i2pthy0=', 'Admin'),
	('c', 'k66aSWCHZLB+Kgv7poYEz/e08dhzlr8Lb86zY/704Ls=', 'User'),
	('congdanh', 'rWsAOyZVMYqqrU2/VTOcJXQ8RgTBtGZZYFm8jW++Cq4=', 'Staff'),
	('duycuong', 'tWiCrxwXdxC14xJ/dWw6ti0stUuDkHXIw6AZAkrXMNY=', 'Staff'),
	('phuc', 'qpO+prOeiBzsxu+5JSznZA3bxGDwdfp0O/OW5ybib/o=', 'Staff'),
	('thientq8', 'w5lWlrhMPRMSQ6IYCP94sisjs15zBfnHLQNUVBNmt14=', 'Admin'),
	('tribui106', 'Jdjm+gwoDUZ09if+6krb45FP2aeZwCEddNkZN4fSrm8=', 'Admin'),
	('vuhau', 'zV/cBFssESnR4N9719a8bO34MP+/DCdBeEv3depHfx8=', 'Admin'),
	('zenng', 'JoJprB5mdhGmmC2CsXpTX0/91Sj4cpaDB8bFpY4otf8=', 'Admin');

CREATE TABLE IF NOT EXISTS `ChiTietPhieuNhap` (
  `maPhieu` varchar(50) NOT NULL,
  `maMay` char(50) NOT NULL DEFAULT '',
  `soLuong` int(11) DEFAULT NULL,
  `donGia` double DEFAULT NULL,
  `tongTien` double DEFAULT NULL,
  PRIMARY KEY (`maPhieu`,`maMay`) USING BTREE,
  KEY `FK_ChiTietPhieuNhap_MayTinh` (`maMay`),
  CONSTRAINT `FK_ChiTietPhieuNhap_MayTinh` FOREIGN KEY (`maMay`) REFERENCES `MayTinh` (`maMay`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_ChiTietPhieuNhap_PhieuNhap` FOREIGN KEY (`maPhieu`) REFERENCES `PhieuNhap` (`maPhieu`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_vietnamese_ci;

INSERT INTO `ChiTietPhieuNhap` (`maPhieu`, `maMay`, `soLuong`, `donGia`, `tongTien`) VALUES
	('PN01', 'ace005', 5, 25999990, 129999950),
	('PN03', 'hp_002', 2, 18999990, 37999980),
	('PN04', 'mac008', 4, 24999990, 99999960),
	('PN05', 'msi002', 6, 17999990, 107999940),
	('PN06', 'mac004', 7, 24999990, 174999930),
	('PN07', 'asu005', 2, 25999990, 51999980),
	('PN08', 'hp_003', 5, 18999990, 94999950),
	('PN09', 'mac009', 3, 24999990, 74999970),
	('PN10', 'msi004', 4, 17999990, 71999960),
	('PN11', 'mac007', 6, 24999990, 149999940),
	('PN12', 'asu006', 1, 25999990, 25999990),
	('PN13', 'hp_004', 3, 18999990, 56999970),
	('PN14', 'mac002', 5, 24999990, 124999950),
	('PN15', 'msi003', 7, 17999990, 125999930),
	('PN16', 'mac004', 2, 24999990, 49999980),
	('PN17', 'asu002', 4, 25999990, 103999960),
	('PN18', 'hp_005', 6, 18999990, 113999940),
	('PN19', 'mac006', 8, 24999990, 199999920),
	('PN20', 'msi007', 3, 17999990, 53999970),
	('PN40', 'ace003', 23, 18999990, 436999770),
	('PN40', 'ace009', 25, 20999990, 524999750),
	('PN40', 'ace010', 17, 14999990, 254999830),
	('PN41', 'ace007', 25, 23999990, 599999750),
	('PN41', 'ace012', 30, 16990000, 509700000),
	('PN42', 'ace004', 11, 39999990, 439999890),
	('PN42', 'ace005', 35, 7999990, 279999650),
	('PN42', 'ace007', 12, 23999990, 287999880),
	('PN42', 'ace013', 36, 28990000, 1043640000),
	('PN43', 'ace021', 25, 25990000, 649750000),
	('PN43', 'ace028', 100, 6490000, 649000000),
	('PN43', 'ace029', 35, 25990000, 909650000),
	('PN43', 'ace030', 25, 63990000, 1599750000),
	('PN44', 'ace019', 250, 20990000, 5247500000),
	('PN45', 'ace011', 25, 18990000, 474750000),
	('PN45', 'ace012', 53, 16990000, 900470000),
	('PN46', 'ace007', 23, 23999990, 551999770),
	('PN46', 'ace024', 54, 7990000, 431460000),
	('PN47', 'ace002', 25, 25999990, 649999750),
	('PN48', 'ace025', 12, 15990000, 191880000),
	('PN48', 'ace026', 22, 23990000, 527780000),
	('PN48', 'ace028', 35, 6490000, 227150000),
	('PN49', 'ace007', 10, 23999990, 239999900),
	('PN49', 'ace009', 35, 20999990, 734999650),
	('PN49', 'ace011', 25, 18990000, 474750000),
	('PN50', 'ace028', 25, 6490000, 162250000),
	('PN51', 'ace006', 25, 16999990, 424999750),
	('PN51', 'ace014', 125, 14990000, 1873750000),
	('PN52', 'ace009', 124, 20999990, 2603998760),
	('PN53', 'ace008', 25, 32999990, 824999750),
	('PN54', 'ace024', 25, 7990000, 199750000),
	('PN55', 'ace021', 25, 25990000, 649750000),
	('PN55', 'ace023', 235, 23990000, 5637650000),
	('PN55', 'ace026', 12, 23990000, 287880000),
	('PN56', 'ace009', 2, 20999990, 41999980),
	('PN57', 'ace003', 25, 18999990, 474999750),
	('PN57', 'ace012', 15, 16990000, 254850000),
	('PN57', 'ace028', 62, 6490000, 402380000),
	('PN57', 'ace044', 100, 45000000, 4500000000),
	('PN58', 'ace013', 121, 28990000, 3507790000),
	('PN58', 'ace020', 25, 59990000, 1499750000),
	('PN58', 'ace035', 100, 45990000, 4599000000),
	('PN58', 'ace044', 25, 45000000, 1125000000),
	('PN59', 'ace031', 25, 15990000, 399750000),
	('PN59', 'ace032', 15, 26990000, 404850000),
	('PN59', 'ace034', 422, 12990000, 5481780000),
	('PN59', 'ace041', 223, 47000000, 10481000000),
	('PN59', 'ace042', 52, 38000000, 1976000000),
	('PN59', 'ace043', 63, 12000000, 756000000),
	('PN60', 'ace009', 25, 20999990, 524999750),
	('PN60', 'ace012', 148, 16990000, 2514520000),
	('PN60', 'ace013', 12, 28990000, 347880000),
	('PN60', 'ace026', 100, 23990000, 2399000000),
	('PN61', 'ace012', 253, 16990000, 4298470000),
	('PN62', 'ace010', 2, 14999990, 29999980),
	('PN63', 'ace007', 31, 23999990, 743999690),
	('PN64', 'ace012', 25, 16990000, 424750000),
	('PN65', 'ace002', 25, 25999990, 649999750),
	('PN67', 'ace008', 25, 32999990, 824999750),
	('PN68', 'ace009', 11, 20999990, 230999890),
	('PN69', 'ace007', 201, 23999990, 4823997990),
	('PN70', 'ace005', 41, 7999990, 327999590),
	('PN70', 'ace028', 22, 6490000, 142780000),
	('PN70', 'ace042', 52, 38000000, 1976000000),
	('PN70', 'ace054', 80, 55000000, 4400000000),
	('PN71', 'mac001', 300, 29999990, 8999997000),
	('PN72', 'ace003', 59, 18999990, 1120999410),
	('PN72', 'ace008', 211, 32999990, 6962997890),
	('PN73', 'del030', 10, 23990000, 239900000),
	('PN74', 'del030', 40, 23990000, 959600000),
	('PN75', 'del030', 50, 23990000, 1199500000),
	('PN76', 'ace007', 1, 23999990, 23999990),
	('PN77', 'ace008', 1, 32999990, 32999990),
	('PN77', 'ace014', 1, 14990000, 14990000),
	('PN77', 'ace015', 5, 33990000, 169950000),
	('PN77', 'ace016', 1, 12990000, 12990000),
	('PN77', 'ace017', 2, 34990000, 69980000),
	('PN77', 'ace018', 1, 15990000, 15990000),
	('PN77', 'ace019', 13, 20990000, 272870000),
	('PN77', 'ace030', 4, 63990000, 255960000),
	('PN77', 'ace041', 1, 47000000, 47000000),
	('PN77', 'ace043', 2, 12000000, 24000000),
	('PN77', 'ace044', 2, 45000000, 90000000),
	('PN78', 'ace001', 5, 24999990, 124999950),
	('PN78', 'ace010', 10, 14999990, 149999900),
	('PN79', 'ace001', 100, 24999990, 2499999000);

CREATE TABLE IF NOT EXISTS `ChiTietPhieuXuat` (
  `maPhieu` varchar(50) NOT NULL,
  `maMay` varchar(10) NOT NULL,
  `soLuong` int(11) DEFAULT NULL,
  `donGia` double DEFAULT NULL,
  `tongTien` double DEFAULT NULL,
  PRIMARY KEY (`maPhieu`,`maMay`) USING BTREE,
  KEY `FK_ChiTietPhieuXuat_MayTinh` (`maMay`),
  CONSTRAINT `FK_ChiTietPhieuXuat_MayTinh` FOREIGN KEY (`maMay`) REFERENCES `MayTinh` (`maMay`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_ChiTietPhieuXuat_PhieuXuat` FOREIGN KEY (`maPhieu`) REFERENCES `PhieuXuat` (`maPhieu`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_vietnamese_ci;

INSERT INTO `ChiTietPhieuXuat` (`maPhieu`, `maMay`, `soLuong`, `donGia`, `tongTien`) VALUES
	('PX01', 'asu007', 4, 29999988, 119999952),
	('PX02', 'asu005', 2, 27999988, 55999976),
	('PX03', 'hp_002', 1, 20519988, 20519988),
	('PX04', 'mac008', 3, 26999988, 80999964),
	('PX05', 'msi002', 5, 19439988, 97199940),
	('PX06', 'mac004', 6, 26999988, 161999928),
	('PX07', 'asu005', 1, 27999988, 27999988),
	('PX08', 'hp_003', 4, 20519988, 82079952),
	('PX09', 'mac009', 2, 26999988, 53999976),
	('PX10', 'msi004', 3, 19439988, 58319964),
	('PX12', 'asu006', 1, 27999988, 27999988),
	('PX13', 'hp_004', 3, 20519988, 61559964),
	('PX14', 'mac002', 5, 26999988, 134999940),
	('PX15', 'msi003', 6, 19439988, 116639928),
	('PX16', 'mac004', 2, 26999988, 53999976),
	('PX17', 'asu002', 4, 27999988, 111999952),
	('PX18', 'hp_005', 5, 20519988, 102599940),
	('PX19', 'mac006', 7, 26999988, 188999916),
	('PX20', 'msi007', 3, 19439988, 58319964),
	('PX27', 'ace001', 10, 24999990, 249999900),
	('PX28', 'ace002', 25, 25999990, 649999750),
	('PX28', 'ace007', 35, 23999990, 839999650),
	('PX28', 'ace016', 64, 12990000, 831360000),
	('PX29', 'ace002', 25, 25999990, 649999750),
	('PX30', 'ace011', 5, 18990000, 94950000),
	('PX31', 'ace001', 5, 24999990, 124999950),
	('PX31', 'ace005', 5, 7999990, 39999950),
	('PX33', 'ace005', 1, 7999990, 7999990),
	('PX33', 'ace006', 25, 16999990, 424999750),
	('PX35', 'ace009', 10, 20999990, 209999900),
	('PX37', 'ace003', 2, 18999990, 37999980),
	('PX37', 'ace012', 16, 16990000, 271840000),
	('PX38', 'ace012', 25, 16990000, 424750000),
	('PX39', 'ace013', 31, 28990000, 898690000),
	('PX40', 'ace012', 35, 16990000, 594650000),
	('PX45', 'ace013', 40, 28990000, 1159600000),
	('PX46', 'ace005', 25, 7999990, 199999750),
	('PX46', 'ace011', 75, 18990000, 1424250000),
	('PX46', 'ace013', 30, 28990000, 869700000),
	('PX47', 'ace013', 30, 28990000, 869700000),
	('PX47', 'ace014', 100, 14990000, 1499000000),
	('PX48', 'ace011', 25, 18990000, 474750000),
	('PX48', 'ace020', 25, 59990000, 1499750000),
	('PX48', 'ace024', 35, 7990000, 279650000),
	('PX48', 'ace025', 88, 15990000, 1407120000),
	('PX48', 'ace027', 50, 59990000, 2999500000),
	('PX48', 'ace029', 65, 25990000, 1689350000),
	('PX49', 'ace002', 50, 25999990, 1299999500),
	('PX49', 'ace003', 50, 18999990, 949999500),
	('PX50', 'len002', 100, 36990000, 3699000000),
	('PX51', 'del030', 200, 23990000, 4798000000),
	('PX52', 'ace066', 57, 25000000, 1425000000),
	('PX52', 'ace068', 56, 20000000, 1120000000),
	('PX52', 'ace073', 106, 12000000, 1272000000),
	('PX52', 'ace074', 100, 45000000, 4500000000),
	('PX52', 'ace075', 50, 38000000, 1900000000),
	('PX52', 'ace076', 56, 18000000, 1008000000),
	('PX53', 'ace005', 25, 7999990, 199999750),
	('PX53', 'ace008', 11, 32999990, 362999890),
	('PX53', 'ace011', 11, 18990000, 208890000),
	('PX53', 'ace013', 8, 28990000, 231920000),
	('PX54', 'asu051', 6, 45000000, 270000000),
	('PX55', 'ace009', 320, 20999990, 6719996800),
	('PX55', 'ace011', 20, 18990000, 379800000),
	('PX55', 'ace074', 20, 45000000, 900000000),
	('PX55', 'asu054', 20, 20000000, 400000000);

DELIMITER //
CREATE PROCEDURE `GetAllMaMay`()
BEGIN
SELECT DISTINCT SUBSTRING_INDEX(tenMay, ' ', 1) AS maMay
    FROM MayTinh;
END//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `getCTPN`(IN maPhieuInput VARCHAR(50))
BEGIN
    -- Tính tổng tiền từ ChiTietPhieuNhap
    SELECT
        ctn.maMay,
        mt.tenMay,
        ctn.soLuong,
        ctn.donGia,
        (ctn.soLuong * ctn.donGia) AS tongTien
    FROM
        ChiTietPhieuNhap ctn
    JOIN
        MayTinh mt ON ctn.maMay = mt.maMay
    WHERE
        ctn.maPhieu = maPhieuInput;
END//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `getCTPX`(IN maPhieuInput VARCHAR(50))
BEGIN
    -- Tính tổng tiền từ ChiTietPhieuXuat
    SELECT 
        cpx.maMay, 
        mt.tenMay, 
        cpx.soLuong, 
        cpx.donGia,
        (cpx.soLuong * cpx.donGia) AS tongTien
    FROM 
        ChiTietPhieuXuat cpx
    JOIN 
        MayTinh mt ON cpx.maMay = mt.maMay
    WHERE 
        cpx.maPhieu = maPhieuInput;
END//
DELIMITER ;

DELIMITER //
CREATE FUNCTION `getMaxMaMay`(`maMayInput` CHAR(50)
) RETURNS int(11)
BEGIN
	RETURN (
	SELECT CAST(RIGHT(maMay, 3) AS UNSIGNED) AS maxMaMay
   FROM MayTinh
   WHERE maMay COLLATE utf8mb4_general_ci LIKE CONCAT(LEFT(maMayInput, 3), '%')
   ORDER BY maxMaMay DESC
   LIMIT 1 );
END//
DELIMITER ;

DELIMITER //
CREATE FUNCTION `getNewMaPhieu`() RETURNS varchar(10) CHARSET latin1 COLLATE latin1_swedish_ci
    DETERMINISTIC
BEGIN
    DECLARE newMaPhieu VARCHAR(10);

    SELECT CONCAT('PN', CAST(SUBSTRING(maPhieu, 3) AS UNSIGNED) + 1)
    INTO newMaPhieu
    FROM PhieuNhap
    ORDER BY maPhieu DESC
    LIMIT 1;

    RETURN newMaPhieu;
END//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `getSortedPN_byDate`(IN startDate date, IN endDate date)
BEGIN
    SELECT
        maPhieu,
        maNhaCungCap,
        nguoiTao,
        thoiGianTao,
        tongTien
    FROM
        PhieuNhap
    WHERE
        thoiGianTao >= startDate AND thoiGianTao <= endDate
    ORDER BY
        thoiGianTao ASC;
END//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `getSortedPN_byPrice`(
	IN `fromPrice` DOUBLE,
	IN `toPrice` DOUBLE
)
BEGIN
    SELECT
        maPhieu,
		  maNhaCungCap,
        nguoiTao,
        thoiGianTao,
        tongTien
    FROM
        PhieuNhap
    WHERE
        tongTien >= fromPrice AND tongTien <= toPrice
    ORDER BY
        tongTien ASC;
END//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `getSortedPX_byDate`(IN startDate date, IN endDate date)
BEGIN
    SELECT
        maPhieu,
        nguoiTao,
        thoiGianTao,
        tongTien
    FROM
        PhieuXuat
    WHERE
        thoiGianTao >= startDate AND thoiGianTao <= endDate
    ORDER BY
        thoiGianTao ASC;
END//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `getSortedPX_byPrice`(
	IN `fromPrice` DOUBLE,
	IN `toPrice` DOUBLE
)
begin
    SELECT
        maPhieu,
        nguoiTao,
        thoiGianTao,
        tongTien
    FROM
        PhieuXuat
    WHERE
        tongTien >= fromPrice AND tongTien <= toPrice
    ORDER BY
        tongTien ASC;
end//
DELIMITER ;

CREATE TABLE `get_all_pn_px` (
	`maPhieu` VARCHAR(1) NOT NULL COLLATE 'utf8mb4_vietnamese_ci',
	`nguoiTao` VARCHAR(1) NULL COLLATE 'utf8mb4_vietnamese_ci',
	`thoiGianTao` TIMESTAMP NOT NULL,
	`tongTien` DOUBLE NULL
) ENGINE=MyISAM;

DELIMITER //
CREATE FUNCTION `get_PN_thoiGianTao`(`maPN` VARCHAR(50)
) RETURNS timestamp
BEGIN
	DECLARE result DATE;
   SELECT DATE(thoiGianTao) INTO result FROM PhieuNhap WHERE maPhieu = maPN;
   RETURN result;
END//
DELIMITER ;

CREATE TABLE IF NOT EXISTS `MayTinh` (
  `maMay` char(10) NOT NULL,
  `tenMay` varchar(50) DEFAULT NULL,
  `soLuong` int(11) DEFAULT NULL,
  `tenCPU` varchar(50) DEFAULT NULL,
  `tsRam` varchar(50) DEFAULT NULL,
  `cardManHinh` varchar(50) DEFAULT 'Integrated',
  `giaTien` decimal(15,2) DEFAULT NULL,
  `mainBoard` varchar(50) DEFAULT NULL,
  `oCung` float DEFAULT NULL,
  `sizeMay` float DEFAULT NULL,
  `xuatSu` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`maMay`),
  KEY `id_maMay` (`maMay`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_vietnamese_ci;

INSERT INTO `MayTinh` (`maMay`, `tenMay`, `soLuong`, `tenCPU`, `tsRam`, `cardManHinh`, `giaTien`, `mainBoard`, `oCung`, `sizeMay`, `xuatSu`) VALUES
	('ace001', 'Acer Nitro 5', 305, 'Intel Core i5-11400H', '8GB', 'NVIDIA GTX 1650', 24999990.00, NULL, 512, 15.6, 'Taiwan'),
	('ace002', 'Acer Aspire 7', 400, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1650', 25999990.00, NULL, 1024, 17.3, 'Taiwan'),
	('ace003', 'Acer Swift 3', 359, 'AMD Ryzen 5 4500U', '16GB', 'Integrated', 18999990.00, NULL, 256, 14, 'Taiwan'),
	('ace004', 'Acer Predator Helios 300', 200, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3060', 39999990.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace005', 'Acer Chromebook 314', 750, 'Intel Celeron N4000', '4GB', 'Integrated', 7999990.00, NULL, 64, 14, 'Taiwan'),
	('ace006', 'Acer Aspire 5', 550, 'Intel Core i5-1135G7', '8GB', 'Integrated', 16999990.00, NULL, 512, 15.6, 'Taiwan'),
	('ace007', 'Acer Spin 5', 401, 'Intel Core i7-1065G7', '16GB', 'Integrated', 23999990.00, NULL, 512, 13.5, 'Taiwan'),
	('ace008', 'Acer ConceptD 3', 401, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1650', 32999990.00, NULL, 1024, 14, 'Taiwan'),
	('ace009', 'Acer Enduro Urban N3', 170, 'Intel Core i5-1035G1', '8GB', 'Integrated', 20999990.00, NULL, 512, 14, 'Taiwan'),
	('ace010', 'Acer TravelMate P2', 410, 'Intel Core i3-10110U', '8GB', 'Integrated', 14999990.00, NULL, 256, 15.6, 'Taiwan'),
	('ace011', 'Acer Nitro 5 AN515-45-R6EV', 669, 'AMD Ryzen 5 5600H', '8GB', 'NVIDIA GTX 1650', 18990000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace012', 'Acer Aspire 7 A715-42G', 100, 'AMD Ryzen 5 5500U', '8GB', 'NVIDIA GTX 1650', 16990000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace013', 'Acer Swift X SFX14-41G', 192, 'AMD Ryzen 7 5800U', '16GB', 'NVIDIA RTX 3050', 28990000.00, NULL, 1024, 14, 'Taiwan'),
	('ace014', 'Acer TravelMate P2 TMP215-54', 601, 'Intel Core i5-1135G7', '8GB', 'Integrated', 14990000.00, NULL, 256, 15.6, 'Taiwan'),
	('ace015', 'Acer ConceptD 3 Ezel CC315-72', 305, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1650', 33990000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace016', 'Acer Chromebook Spin 713 CP713-3W', 601, 'Intel Core i5-10210U', '8GB', 'Integrated', 12990000.00, NULL, 128, 13.3, 'Taiwan'),
	('ace017', 'Acer Predator Helios 300 PH315-54', 402, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3060', 34990000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace018', 'Acer Aspire Vero AV15-51', 901, 'Intel Core i5-1155G7', '8GB', 'Integrated', 15990000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace019', 'Acer Enduro Urban N3 EUN314A-51W', 363, 'Intel Core i7-1165G7', '16GB', 'Integrated', 20990000.00, NULL, 512, 14, 'Taiwan'),
	('ace020', 'Acer Predator Triton 500 PT515-52', 250, 'Intel Core i7-10875H', '32GB', 'NVIDIA RTX 2080 Super', 59990000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace021', 'Acer Spin 5 SP513-55N', 450, 'Intel Core i7-1165G7', '16GB', 'Integrated', 25990000.00, NULL, 512, 13.5, 'Taiwan'),
	('ace022', 'Acer Aspire 5 A515-56-50RS', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated', 14990000.00, NULL, 256, 15.6, 'Taiwan'),
	('ace023', 'Acer Nitro 7 AN715-51', 165, 'Intel Core i7-9750H', '16GB', 'NVIDIA GTX 1660 Ti', 23990000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace024', 'Acer Chromebook 315 CB315-3HT', 600, 'Intel Celeron N4020', '4GB', 'Integrated', 7990000.00, NULL, 64, 15.6, 'Taiwan'),
	('ace025', 'Acer Aspire C24-1651 All-in-One', 600, 'Intel Core i5-1135G7', '8GB', 'Integrated', 15990000.00, NULL, 512, 23.8, 'Taiwan'),
	('ace026', 'Acer Swift 5 SF514-55T', 366, 'Intel Core i5-1135G7', '8GB', 'Integrated', 23990000.00, NULL, 512, 14, 'Taiwan'),
	('ace027', 'Acer Predator Helios 500 PH517-52', 250, 'Intel Core i9-11980HK', '32GB', 'NVIDIA RTX 3080', 59990000.00, NULL, 2048, 17.3, 'Taiwan'),
	('ace028', 'Acer Aspire 3 A314-35', 600, 'Intel Celeron N4500', '4GB', 'Integrated', 6490000.00, NULL, 128, 14, 'Taiwan'),
	('ace029', 'Acer Nitro AN515-57-71VV', 600, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3050', 25990000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace030', 'Acer ConceptD 7 CN715-71', 179, 'Intel Core i9-9980HK', '32GB', 'NVIDIA RTX 2080', 63990000.00, NULL, 2048, 15.6, 'Taiwan'),
	('ace031', 'Acer Aspire 5 A514-54', 875, 'Intel Core i5-1135G7', '8GB', 'Integrated', 15990000.00, NULL, 256, 14, 'Taiwan'),
	('ace032', 'Acer Swift 3 SF314-511', 585, 'Intel Core i7-1165G7', '16GB', 'Integrated', 26990000.00, NULL, 1024, 14, 'Taiwan'),
	('ace033', 'Acer Chromebook 514 CB514-1W', 500, 'Intel Pentium Silver N5030', '4GB', 'Integrated', 9990000.00, NULL, 64, 14, 'Taiwan'),
	('ace034', 'Acer Aspire XC-895 Desktop', 378, 'Intel Core i3-10100', '4GB', 'Integrated', 12990000.00, NULL, 256, 19.5, 'Taiwan'),
	('ace035', 'Acer Predator Orion 3000 PO3-630', 200, 'Intel Core i7-11700F', '16GB', 'NVIDIA RTX 3070', 45990000.00, NULL, 1024, 23.8, 'Taiwan'),
	('ace041', 'Acer Nitro 5', 578, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce RTX 3060', 47000000.00, NULL, 2048, 17.3, 'Taiwan'),
	('ace042', 'Acer Spin 5', 100, 'Intel Core i7-1165G7', '16GB', 'Integrated', 38000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('ace043', 'Acer Chromebook 14', 139, 'Intel Core i3-8130U', '4GB', 'Integrated', 12000000.00, NULL, 256, 14, 'Taiwan'),
	('ace044', 'Acer Swift 5', 577, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 45000000.00, NULL, 1024, 14, 'Taiwan'),
	('ace045', 'Acer TravelMate', 150, 'AMD Ryzen 7 5700U', '16GB', 'Integrated', 38000000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace046', 'Acer Aspire 3', 100, 'Intel Core i3-1115G4', '8GB', 'Integrated', 18000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace047', 'Acer Nitro 7', 120, 'Intel Core i9-10980HK', '32GB', 'NVIDIA GeForce RTX 3070', 60000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('ace048', 'Acer Swift 7', 800, 'Intel Core i5-1060G7', '8GB', 'Integrated', 22000000.00, NULL, 512, 13.3, 'Taiwan'),
	('ace049', 'Acer Aspire 1', 250, 'Intel Celeron N4020', '4GB', 'Integrated', 10000000.00, NULL, 256, 14, 'Taiwan'),
	('ace050', 'Acer Chromebook Spin', 500, 'Intel Core i5-8250U', '8GB', 'Integrated', 23000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('ace051', 'Acer Aspire 5', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated', 25000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace052', 'Acer Predator Helios', 500, 'Intel Core i7-11800H', '16GB', 'NVIDIA GeForce RTX 3060', 45000000.00, NULL, 2048, 17.3, 'Taiwan'),
	('ace053', 'Acer Swift 3', 150, 'AMD Ryzen 5 5500U', '8GB', 'Integrated', 20000000.00, NULL, 512, 14, 'Taiwan'),
	('ace054', 'Acer ConceptD 7', 200, 'Intel Core i7-10875H', '16GB', 'NVIDIA GeForce RTX 2080', 55000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('ace055', 'Acer Aspire 7', 100, 'Intel Core i5-10300H', '8GB', 'NVIDIA GTX 1650', 22000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace056', 'Acer Nitro 5', 800, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce RTX 3060', 47000000.00, NULL, 2048, 17.3, 'Taiwan'),
	('ace057', 'Acer Spin 5', 100, 'Intel Core i7-1165G7', '16GB', 'Integrated', 38000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('ace058', 'Acer Chromebook 14', 200, 'Intel Core i3-8130U', '4GB', 'Integrated', 12000000.00, NULL, 256, 14, 'Taiwan'),
	('ace059', 'Acer Swift 5', 700, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 45000000.00, NULL, 1024, 14, 'Taiwan'),
	('ace060', 'Acer TravelMate', 150, 'AMD Ryzen 7 5700U', '16GB', 'Integrated', 38000000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace061', 'Acer Aspire 3', 100, 'Intel Core i3-1115G4', '8GB', 'Integrated', 18000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace062', 'Acer Nitro 7', 120, 'Intel Core i9-10980HK', '32GB', 'NVIDIA GeForce RTX 3070', 60000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('ace063', 'Acer Swift 7', 800, 'Intel Core i5-1060G7', '8GB', 'Integrated', 22000000.00, NULL, 512, 13.3, 'Taiwan'),
	('ace064', 'Acer Aspire 1', 250, 'Intel Celeron N4020', '4GB', 'Integrated', 10000000.00, NULL, 256, 14, 'Taiwan'),
	('ace065', 'Acer Chromebook Spin', 500, 'Intel Core i5-8250U', '8GB', 'Integrated', 23000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('ace066', 'Acer Aspire 5', 43, 'Intel Core i5-1135G7', '8GB', 'Integrated', 25000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace067', 'Acer Predator Helios', 500, 'Intel Core i7-11800H', '16GB', 'NVIDIA GeForce RTX 3060', 45000000.00, NULL, 2048, 17.3, 'Taiwan'),
	('ace068', 'Acer Swift 3', 94, 'AMD Ryzen 5 5500U', '8GB', 'Integrated', 20000000.00, NULL, 512, 14, 'Taiwan'),
	('ace069', 'Acer ConceptD 7', 120, 'Intel Core i7-10875H', '16GB', 'NVIDIA GeForce RTX 2080', 55000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('ace070', 'Acer Aspire 7', 100, 'Intel Core i5-10300H', '8GB', 'NVIDIA GTX 1650', 22000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace071', 'Acer Nitro 5', 800, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce RTX 3060', 47000000.00, NULL, 2048, 17.3, 'Taiwan'),
	('ace072', 'Acer Spin 5', 100, 'Intel Core i7-1165G7', '16GB', 'Integrated', 38000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('ace073', 'Acer Chromebook 14', 94, 'Intel Core i3-8130U', '4GB', 'Integrated', 12000000.00, NULL, 256, 14, 'Taiwan'),
	('ace074', 'Acer Swift 5', 580, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 45000000.00, NULL, 1024, 14, 'Taiwan'),
	('ace075', 'Acer TravelMate', 100, 'AMD Ryzen 7 5700U', '16GB', 'Integrated', 38000000.00, NULL, 512, 15.6, 'Taiwan'),
	('ace076', 'Acer Aspire 3', 44, 'Intel Core i3-1115G4', '8GB', 'Integrated', 18000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace077', 'Acer Nitro 7', 120, 'Intel Core i9-10980HK', '32GB', 'NVIDIA GeForce RTX 3070', 60000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('ace078', 'Acer Swift 7', 800, 'Intel Core i5-1060G7', '8GB', 'Integrated', 22000000.00, NULL, 512, 13.3, 'Taiwan'),
	('ace079', 'Acer Aspire 1', 250, 'Intel Celeron N4020', '4GB', 'Integrated', 10000000.00, NULL, 256, 14, 'Taiwan'),
	('ace080', 'Acer Chromebook Spin', 500, 'Intel Core i5-8250U', '8GB', 'Integrated', 23000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('ace081', 'Acer Aspire 5', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated', 25000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('ace082', 'Acer Predator Helios', 500, 'Intel Core i7-11800H', '16GB', 'NVIDIA GeForce RTX 3060', 45000000.00, NULL, 2048, 17.3, 'Taiwan'),
	('asu001', 'Asus VivoBook 15', 800, 'Intel Core i5-1135G7', '8GB', 'Integrated', 21999990.00, NULL, 256, 15.6, 'Taiwan'),
	('asu002', 'Asus ROG Zephyrus G14', 600, 'AMD Ryzen 9', '16GB', 'NVIDIA GTX 1650', 32999990.00, NULL, 512, 14, 'Taiwan'),
	('asu003', 'Asus ZenBook 14', 400, 'Intel Core i7-1165G7', '16GB', 'Integrated', 28999990.00, NULL, 512, 14, 'Taiwan'),
	('asu004', 'Asus TUF Gaming A15', 300, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA RTX 3060', 35999990.00, NULL, 1024, 15.6, 'Taiwan'),
	('asu005', 'Asus VivoBook S14', 500, 'Intel Core i5-10210U', '8GB', 'Integrated', 17999990.00, NULL, 512, 14, 'Taiwan'),
	('asu006', 'Asus ROG Strix G15', 300, 'AMD Ryzen 9 5900HX', '32GB', 'NVIDIA RTX 3070', 42999990.00, NULL, 1024, 15.6, 'Taiwan'),
	('asu007', 'Asus ExpertBook B9', 400, 'Intel Core i7-10510U', '16GB', 'Integrated', 25999990.00, NULL, 512, 14, 'Taiwan'),
	('asu008', 'Asus ProArt StudioBook', 200, 'Intel Core i9-10980HK', '64GB', 'NVIDIA RTX 2060', 65999990.00, NULL, 2048, 17, 'Taiwan'),
	('asu009', 'Asus Chromebook Flip', 700, 'Intel Core m3-8100Y', '4GB', 'Integrated', 9999990.00, NULL, 64, 12.5, 'Taiwan'),
	('asu010', 'Asus VivoBook Flip 14', 500, 'Intel Pentium Silver N5030', '4GB', 'Integrated', 12999990.00, NULL, 128, 14, 'Taiwan'),
	('asu025', 'Asus TUF Gaming A15 FA506IHR', 100, 'AMD Ryzen 7 4800H', '16GB', 'NVIDIA GTX 1650', 19990000.00, NULL, 512, 15.6, 'Vietnam'),
	('asu026', 'Asus ROG Zephyrus G14 GA401QM', 500, 'AMD Ryzen 9 5900HS', '16GB', 'NVIDIA RTX 3060', 36990000.00, NULL, 1024, 14, 'Vietnam'),
	('asu027', 'Asus Vivobook Pro 14 OLED M3401QC', 800, 'AMD Ryzen 5 5600H', '8GB', 'NVIDIA GTX 1650', 18990000.00, NULL, 512, 14, 'Vietnam'),
	('asu028', 'Asus Zenbook 14X UX5401EA', 600, 'Intel Core i7-1165G7', '16GB', 'Integrated', 25990000.00, NULL, 1024, 14, 'Vietnam'),
	('asu029', 'Asus ExpertBook B1 B1500CEAE', 700, 'Intel Core i5-1135G7', '8GB', 'Integrated', 17990000.00, NULL, 512, 15.6, 'Vietnam'),
	('asu030', 'Asus ROG Strix G15 G513QM', 400, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA RTX 3060', 32990000.00, NULL, 1024, 15.6, 'Vietnam'),
	('asu031', 'Asus VivoBook 15 A515EA', 900, 'Intel Core i3-1115G4', '8GB', 'Integrated', 13990000.00, NULL, 256, 15.6, 'Vietnam'),
	('asu032', 'Asus ZenBook Pro Duo UX582LR', 200, 'Intel Core i9-10980HK', '32GB', 'NVIDIA RTX 3070', 72990000.00, NULL, 1024, 15.6, 'Vietnam'),
	('asu033', 'Asus Chromebook Flip C436FA', 500, 'Intel Core i5-10210U', '8GB', 'Integrated', 15990000.00, NULL, 256, 14, 'Vietnam'),
	('asu034', 'Asus ProArt Studiobook 16 H7600ZW', 300, 'Intel Core i7-12700H', '32GB', 'NVIDIA RTX 3070', 52990000.00, NULL, 1024, 16, 'Vietnam'),
	('asu035', 'Asus TUF Dash F15 FX516PE', 600, 'Intel Core i5-11300H', '8GB', 'NVIDIA RTX 3050 Ti', 19990000.00, NULL, 512, 15.6, 'Vietnam'),
	('asu036', 'Asus ROG Flow X13 GV301QE', 300, 'AMD Ryzen 9 5980HS', '16GB', 'NVIDIA RTX 3050 Ti', 35990000.00, NULL, 1024, 13.4, 'Vietnam'),
	('asu037', 'Asus VivoBook Flip 14 TM420IA', 800, 'AMD Ryzen 5 4500U', '8GB', 'Integrated', 15990000.00, NULL, 512, 14, 'Vietnam'),
	('asu038', 'Asus Zenbook 13 OLED UX325EA', 600, 'Intel Core i5-1135G7', '8GB', 'Integrated', 19990000.00, NULL, 512, 13.3, 'Vietnam'),
	('asu039', 'Asus ROG Zephyrus S GX701LXS', 300, 'Intel Core i7-10750H', '32GB', 'NVIDIA RTX 2080 Super', 64990000.00, NULL, 1024, 17.3, 'Vietnam'),
	('asu040', 'Asus Vivobook S14 M433IA', 700, 'AMD Ryzen 7 4700U', '8GB', 'Integrated', 18990000.00, NULL, 512, 14, 'Vietnam'),
	('asu041', 'Asus Chromebook C523NA', 100, 'Intel Celeron N3350', '4GB', 'Integrated', 7990000.00, NULL, 64, 15.6, 'Vietnam'),
	('asu042', 'Asus VivoBook Pro 15 OLED K3500PH', 500, 'Intel Core i5-11300H', '16GB', 'NVIDIA GTX 1650', 24990000.00, NULL, 512, 15.6, 'Vietnam'),
	('asu043', 'Asus TUF Gaming F15 FX506LU', 400, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1660 Ti', 23990000.00, NULL, 512, 15.6, 'Vietnam'),
	('asu044', 'Asus ROG Strix SCAR 17 G733QS', 300, 'AMD Ryzen 9 5900HX', '32GB', 'NVIDIA RTX 3080', 64990000.00, NULL, 2048, 17.3, 'Vietnam'),
	('asu045', 'Asus ExpertBook B9 B9400CEAE', 700, 'Intel Core i7-1165G7', '16GB', 'Integrated', 28990000.00, NULL, 512, 14, 'Vietnam'),
	('asu046', 'Asus ROG Zephyrus Duo 15 GX550LXS', 200, 'Intel Core i9-10980HK', '32GB', 'NVIDIA RTX 2080 Super', 79990000.00, NULL, 1024, 15.6, 'Vietnam'),
	('asu047', 'Asus VivoBook Go 14 E410MA', 100, 'Intel Celeron N4020', '4GB', 'Integrated', 6990000.00, NULL, 64, 14, 'Vietnam'),
	('asu048', 'Asus VivoBook 16X M1603QA', 600, 'AMD Ryzen 5 5600H', '8GB', 'Integrated', 17990000.00, NULL, 512, 16, 'Vietnam'),
	('asu049', 'Asus Zenbook 17 Fold OLED UX9702AA', 200, 'Intel Core i7-1250U', '16GB', 'Integrated', 79990000.00, NULL, 1024, 17, 'Vietnam'),
	('asu050', 'Asus ZenBook 14', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated', 23000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu051', 'Asus TUF Gaming A15', 494, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA GeForce RTX 3070', 45000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu052', 'Asus VivoBook 15', 150, 'Intel Core i3-1115G4', '8GB', 'Integrated', 15000000.00, NULL, 512, 15.6, 'Taiwan'),
	('asu053', 'Asus ROG Zephyrus G14', 120, 'AMD Ryzen 9 5900HS', '16GB', 'NVIDIA GeForce RTX 3060', 55000000.00, NULL, 2048, 14, 'Taiwan'),
	('asu054', 'Asus VivoBook 14', 80, 'Intel Core i5-1135G7', '8GB', 'Integrated', 20000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu055', 'Asus ROG Strix G15', 800, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce GTX 1660 Ti', 35000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu056', 'Asus Chromebook Flip', 100, 'Intel Core i5-8250U', '8GB', 'Integrated', 22000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu057', 'Asus ZenBook Flip 14', 700, 'Intel Core i7-1165G7', '16GB', 'Integrated', 40000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu058', 'Asus TUF Gaming F15', 200, 'Intel Core i5-10300H', '8GB', 'NVIDIA GTX 1650', 28000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('asu059', 'Asus VivoBook S15', 100, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 15.6, 'Taiwan'),
	('asu060', 'Asus ROG Flow Z13', 800, 'Intel Core i9-12900H', '32GB', 'NVIDIA GeForce RTX 3050', 60000000.00, NULL, 2048, 13.4, 'Taiwan'),
	('asu061', 'Asus ZenBook 13', 100, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('asu062', 'Asus TUF Dash F15', 150, 'Intel Core i7-12700H', '16GB', 'NVIDIA GeForce RTX 3070', 50000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu063', 'Asus VivoBook 15', 200, 'Intel Core i5-1135G7', '8GB', 'Integrated', 20000000.00, NULL, 512, 15.6, 'Taiwan'),
	('asu064', 'Asus ZenBook Pro Duo', 500, 'Intel Core i9-11900H', '32GB', 'NVIDIA GeForce RTX 3070', 85000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu065', 'Asus ExpertBook P1', 100, 'Intel Core i3-1115G4', '4GB', 'Integrated', 12000000.00, NULL, 256, 15.6, 'Taiwan'),
	('asu066', 'Asus ROG Zephyrus M16', 700, 'Intel Core i9-11900H', '32GB', 'NVIDIA GeForce RTX 3060', 70000000.00, NULL, 2048, 16, 'Taiwan'),
	('asu067', 'Asus VivoBook 14', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated', 20000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu068', 'Asus ZenBook 14', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated', 23000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu069', 'Asus TUF Gaming A15', 500, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA GeForce RTX 3070', 45000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu070', 'Asus VivoBook 15', 150, 'Intel Core i3-1115G4', '8GB', 'Integrated', 15000000.00, NULL, 512, 15.6, 'Taiwan'),
	('asu071', 'Asus ROG Zephyrus G14', 120, 'AMD Ryzen 9 5900HS', '16GB', 'NVIDIA GeForce RTX 3060', 55000000.00, NULL, 2048, 14, 'Taiwan'),
	('asu072', 'Asus VivoBook 14', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated', 20000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu073', 'Asus ROG Strix G15', 800, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce GTX 1660 Ti', 35000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu074', 'Asus Chromebook Flip', 100, 'Intel Core i5-8250U', '8GB', 'Integrated', 22000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu075', 'Asus ZenBook Flip 14', 700, 'Intel Core i7-1165G7', '16GB', 'Integrated', 40000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu076', 'Asus TUF Gaming F15', 200, 'Intel Core i5-10300H', '8GB', 'NVIDIA GTX 1650', 28000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('asu077', 'Asus VivoBook S15', 100, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 15.6, 'Taiwan'),
	('asu078', 'Asus ROG Flow Z13', 800, 'Intel Core i9-12900H', '32GB', 'NVIDIA GeForce RTX 3050', 60000000.00, NULL, 2048, 13.4, 'Taiwan'),
	('asu079', 'Asus ZenBook 13', 100, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('asu080', 'Asus TUF Dash F15', 150, 'Intel Core i7-12700H', '16GB', 'NVIDIA GeForce RTX 3070', 50000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu081', 'Asus VivoBook 15', 200, 'Intel Core i5-1135G7', '8GB', 'Integrated', 20000000.00, NULL, 512, 15.6, 'Taiwan'),
	('asu082', 'Asus ZenBook Pro Duo', 500, 'Intel Core i9-11900H', '32GB', 'NVIDIA GeForce RTX 3070', 85000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu083', 'Asus VivoBook 14', 800, 'Intel Core i5-1135G7', '8GB', 'Integrated', 22000000.00, NULL, 512, 14, 'Taiwan'),
	('asu084', 'Asus TUF Gaming A15', 120, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA GeForce RTX 3070', 45000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu085', 'Asus ZenBook 15', 500, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce GTX 1650 Ti', 40000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('asu086', 'Asus ROG Zephyrus G15', 600, 'AMD Ryzen 9 5900HS', '16GB', 'NVIDIA GeForce RTX 3070', 58000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu087', 'Asus VivoBook S14', 700, 'Intel Core i5-1135G7', '8GB', 'Integrated', 22000000.00, NULL, 512, 14, 'Taiwan'),
	('asu088', 'Asus ROG Strix G17', 100, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce GTX 1660 Ti', 45000000.00, NULL, 2048, 17.3, 'Taiwan'),
	('asu089', 'Asus ZenBook Pro 15', 300, 'Intel Core i9-11900H', '32GB', 'NVIDIA GeForce RTX 3060', 75000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu090', 'Asus TUF Gaming F17', 900, 'Intel Core i7-10300H', '16GB', 'NVIDIA GTX 1650 Ti', 38000000.00, NULL, 2048, 17.3, 'Taiwan'),
	('asu091', 'Asus VivoBook 15', 140, 'Intel Core i3-1115G4', '8GB', 'Integrated', 17000000.00, NULL, 512, 15.6, 'Taiwan'),
	('asu092', 'Asus ZenBook Flip 13', 500, 'Intel Core i7-1165G7', '16GB', 'Integrated', 45000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('asu093', 'Asus TUF Gaming F15', 100, 'Intel Core i5-10300H', '8GB', 'NVIDIA GTX 1650 Ti', 33000000.00, NULL, 1024, 15.6, 'Taiwan'),
	('asu094', 'Asus VivoBook 14', 600, 'Intel Core i3-1115G4', '4GB', 'Integrated', 12000000.00, NULL, 256, 14, 'Taiwan'),
	('asu095', 'Asus ZenBook 14', 800, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 1024, 14, 'Taiwan'),
	('asu096', 'Asus TUF Gaming A15', 400, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA GeForce RTX 3070', 46000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu097', 'Asus VivoBook 14', 120, 'Intel Core i5-1135G7', '8GB', 'Integrated', 21000000.00, NULL, 512, 14, 'Taiwan'),
	('asu098', 'Asus ROG Strix Scar 15', 200, 'Intel Core i9-11900H', '32GB', 'NVIDIA GeForce RTX 3080', 95000000.00, NULL, 2048, 15.6, 'Taiwan'),
	('asu099', 'Asus ZenBook 13', 700, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 1024, 13.3, 'Taiwan'),
	('del025', 'Dell XPS 13 9310', 600, 'Intel Core i7-1185G7', '16GB', 'Integrated', 35990000.00, NULL, 1024, 13.4, 'USA'),
	('del026', 'Dell Inspiron 15 5515', 800, 'AMD Ryzen 5 5500U', '8GB', 'Integrated', 19990000.00, NULL, 512, 15.6, 'USA'),
	('del027', 'Dell Alienware M15 R6', 300, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3060', 44990000.00, NULL, 1024, 15.6, 'USA'),
	('del028', 'Dell Vostro 3401', 100, 'Intel Core i3-1005G1', '4GB', 'Integrated', 11990000.00, NULL, 256, 14, 'USA'),
	('del029', 'Dell Latitude 7420', 400, 'Intel Core i5-1135G7', '16GB', 'Integrated', 25990000.00, NULL, 512, 14, 'USA'),
	('del030', 'Dell G15 5511', 600, 'Intel Core i5-11400H', '8GB', 'NVIDIA RTX 3050', 23990000.00, NULL, 512, 15.6, 'USA'),
	('del031', 'Dell Precision 5560', 200, 'Intel Core i9-11950H', '32GB', 'NVIDIA RTX A2000', 71990000.00, NULL, 1024, 15.6, 'USA'),
	('del032', 'Dell XPS 15 9510', 500, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3050 Ti', 52990000.00, NULL, 1024, 15.6, 'USA'),
	('del033', 'Dell Inspiron 14 5415', 800, 'AMD Ryzen 7 5700U', '8GB', 'Integrated', 18990000.00, NULL, 512, 14, 'USA'),
	('del034', 'Dell Alienware X17 R1', 300, 'Intel Core i9-11980HK', '32GB', 'NVIDIA RTX 3080', 92990000.00, NULL, 2048, 17.3, 'USA'),
	('del035', 'Dell G3 15 3500', 600, 'Intel Core i5-10300H', '8GB', 'NVIDIA GTX 1650 Ti', 20990000.00, NULL, 512, 15.6, 'USA'),
	('del036', 'Dell Latitude 5520', 500, 'Intel Core i5-1145G7', '16GB', 'Integrated', 28990000.00, NULL, 512, 15.6, 'USA'),
	('del037', 'Dell Inspiron 13 5310', 700, 'Intel Core i7-11390H', '16GB', 'Integrated', 23990000.00, NULL, 512, 13.3, 'USA'),
	('del038', 'Dell Precision 7560', 200, 'Intel Core i9-11950H', '32GB', 'NVIDIA RTX A4000', 94990000.00, NULL, 1024, 15.6, 'USA'),
	('del039', 'Dell XPS 17 9710', 400, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3060', 65990000.00, NULL, 1024, 17, 'USA'),
	('del040', 'Dell Vostro 7500', 300, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1650 Ti', 29990000.00, NULL, 512, 15.6, 'USA'),
	('del041', 'Dell G5 SE 5505', 700, 'AMD Ryzen 7 4800H', '16GB', 'AMD Radeon RX 5600M', 24990000.00, NULL, 512, 15.6, 'USA'),
	('del042', 'Dell Inspiron 16 Plus 7610', 500, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3050', 31990000.00, NULL, 1024, 16, 'USA'),
	('del043', 'Dell Latitude 7320 Detachable', 300, 'Intel Core i5-1140G7', '16GB', 'Integrated', 34990000.00, NULL, 512, 13, 'USA'),
	('del044', 'Dell Inspiron 14 7415 2-in-1', 800, 'AMD Ryzen 5 5500U', '8GB', 'Integrated', 20990000.00, NULL, 512, 14, 'USA'),
	('del045', 'Dell Alienware Aurora R12', 200, 'Intel Core i9-11900KF', '32GB', 'NVIDIA RTX 3080', 94990000.00, NULL, 2048, 0, 'USA'),
	('del046', 'Dell Precision 3561', 400, 'Intel Core i7-11850H', '16GB', 'NVIDIA T600', 39990000.00, NULL, 512, 15.6, 'USA'),
	('del047', 'Dell XPS 13 Plus 9320', 600, 'Intel Core i7-1260P', '16GB', 'Integrated', 38990000.00, NULL, 1024, 13.4, 'USA'),
	('del048', 'Dell Inspiron 15 3520', 100, 'Intel Core i3-1215U', '8GB', 'Integrated', 13990000.00, NULL, 256, 15.6, 'USA'),
	('del049', 'Dell Alienware Area-51m R2', 100, 'Intel Core i9-10900K', '64GB', 'NVIDIA RTX 2080 Super', 109990000.00, NULL, 2048, 17.3, 'USA'),
	('hp_001', 'HP Envy X360', 700, 'Intel Core i7-1165G7', '16GB', 'NVIDIA GTX 1650', 31999990.00, NULL, 1024, 15.6, 'USA'),
	('hp_002', 'HP Spectre x360', 500, 'Intel Core i5-1135G7', '8GB', 'Integrated', 29999990.00, NULL, 512, 14, 'USA'),
	('hp_003', 'HP Pavilion 15', 400, 'AMD Ryzen 7 5700U', '8GB', 'Integrated', 19999990.00, NULL, 512, 15.6, 'USA'),
	('hp_004', 'HP Elite Dragonfly', 200, 'Intel Core i7-8565U', '16GB', 'Integrated', 42999990.00, NULL, 512, 13.3, 'USA'),
	('hp_005', 'HP Omen 15', 300, 'Intel Core i7-10750H', '16GB', 'NVIDIA RTX 2060', 36999990.00, NULL, 1024, 15.6, 'USA'),
	('hp_006', 'HP Envy 13', 600, 'Intel Core i5-10210U', '8GB', 'Integrated', 20999990.00, NULL, 256, 13.3, 'USA'),
	('hp_007', 'HP ZBook Firefly', 200, 'Intel Core i5-10310U', '8GB', 'Integrated', 27999990.00, NULL, 512, 14, 'USA'),
	('hp_008', 'HP Pavilion x360', 500, 'Intel Core i3-1125G4', '4GB', 'Integrated', 15999990.00, NULL, 256, 14, 'USA'),
	('hp_009', 'HP Spectre x360 15', 300, 'Intel Core i7-10510U', '16GB', 'NVIDIA MX250', 33999990.00, NULL, 512, 15.6, 'USA'),
	('hp_010', 'HP EliteBook 840', 400, 'Intel Core i5-8265U', '8GB', 'Integrated', 26999990.00, NULL, 256, 14, 'USA'),
	('hp_011', 'HP Spectre x360 14', 800, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 45000000.00, NULL, 1024, 13.5, 'USA'),
	('hp_012', 'HP Omen 15', 120, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce GTX 1660 Ti', 47000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_013', 'HP Envy 14', 600, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 1024, 14, 'USA'),
	('hp_014', 'HP Pavilion x360', 100, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 29000000.00, NULL, 512, 14, 'USA'),
	('hp_015', 'HP Elite Dragonfly', 700, 'Intel Core i5-8350U', '16GB', 'Intel UHD Graphics 620', 60000000.00, NULL, 512, 13.3, 'USA'),
	('hp_016', 'HP Omen 17', 500, 'Intel Core i9-11900H', '32GB', 'NVIDIA GeForce RTX 3080', 98000000.00, NULL, 2048, 17.3, 'USA'),
	('hp_017', 'HP Spectre x360 13', 800, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 38000000.00, NULL, 512, 13.3, 'USA'),
	('hp_018', 'HP Pavilion 14', 120, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 1024, 14, 'USA'),
	('hp_019', 'HP Envy 15', 600, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce GTX 1650 Ti', 45000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_020', 'HP EliteBook 840', 900, 'Intel Core i5-10210U', '8GB', 'Intel UHD Graphics 620', 33000000.00, NULL, 512, 14, 'USA'),
	('hp_021', 'HP Pavilion 13', 700, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 41000000.00, NULL, 1024, 13.3, 'USA'),
	('hp_022', 'HP Omen 15', 110, 'Intel Core i7-10750H', '16GB', 'NVIDIA GeForce GTX 1660 Ti', 48000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_023', 'HP Spectre x360 13', 400, 'Intel Core i5-1035G4', '8GB', 'Intel UHD Graphics', 35000000.00, NULL, 512, 13.3, 'USA'),
	('hp_024', 'HP Envy 13', 100, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 39000000.00, NULL, 1024, 13.3, 'USA'),
	('hp_025', 'HP Pavilion x360', 120, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 29000000.00, NULL, 512, 14, 'USA'),
	('hp_026', 'HP Elite Dragonfly', 500, 'Intel Core i7-8665U', '16GB', 'Intel UHD Graphics 620', 63000000.00, NULL, 512, 13.3, 'USA'),
	('hp_027', 'HP Omen 17', 800, 'Intel Core i7-11800H', '16GB', 'NVIDIA GeForce RTX 3070', 75000000.00, NULL, 2048, 17.3, 'USA'),
	('hp_028', 'HP Spectre x360 14', 100, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 46000000.00, NULL, 1024, 14, 'USA'),
	('hp_029', 'HP Envy 14', 900, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 43000000.00, NULL, 1024, 14, 'USA'),
	('hp_030', 'HP Pavilion 15', 600, 'Intel Core i5-1135G7', '8GB', 'Integrated', 28000000.00, NULL, 512, 15.6, 'USA'),
	('hp_031', 'HP EliteBook 840', 700, 'Intel Core i5-10210U', '8GB', 'Intel UHD Graphics 620', 34000000.00, NULL, 512, 14, 'USA'),
	('hp_032', 'HP Pavilion x360', 500, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 41000000.00, NULL, 1024, 14, 'USA'),
	('hp_033', 'HP Omen 15', 600, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1650 Ti', 44000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_034', 'HP Spectre x360 13', 100, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 40000000.00, NULL, 1024, 13.3, 'USA'),
	('hp_035', 'HP Pavilion 14', 700, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 1024, 14, 'USA'),
	('hp_036', 'HP Elite Dragonfly', 400, 'Intel Core i7-8665U', '16GB', 'Intel UHD Graphics 620', 64000000.00, NULL, 512, 13.3, 'USA'),
	('hp_037', 'HP Omen 17', 800, 'Intel Core i7-11800H', '32GB', 'NVIDIA GeForce RTX 3080', 95000000.00, NULL, 2048, 17.3, 'USA'),
	('hp_038', 'HP Spectre x360 14', 900, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 46000000.00, NULL, 1024, 14, 'USA'),
	('hp_039', 'HP Envy 15', 110, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1650 Ti', 46000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_040', 'HP Pavilion 13', 800, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 31000000.00, NULL, 512, 13.3, 'USA'),
	('hp_041', 'HP Pavilion x360', 900, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 29000000.00, NULL, 512, 14, 'USA'),
	('hp_042', 'HP EliteBook 840', 120, 'Intel Core i5-10210U', '8GB', 'Intel UHD Graphics 620', 35000000.00, NULL, 512, 14, 'USA'),
	('hp_043', 'HP Envy 14', 100, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 43000000.00, NULL, 1024, 14, 'USA'),
	('hp_044', 'HP Pavilion 15', 500, 'Intel Core i5-1135G7', '8GB', 'Integrated', 27000000.00, NULL, 512, 15.6, 'USA'),
	('hp_045', 'HP Elite Dragonfly', 300, 'Intel Core i7-8665U', '16GB', 'Intel UHD Graphics 620', 65000000.00, NULL, 512, 13.3, 'USA'),
	('hp_046', 'HP Omen 15', 700, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1660 Ti', 48000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_047', 'HP Spectre x360 13', 110, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 39000000.00, NULL, 1024, 13.3, 'USA'),
	('hp_048', 'HP Pavilion 14', 100, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 1024, 14, 'USA'),
	('hp_049', 'HP EliteBook 840', 600, 'Intel Core i5-10210U', '8GB', 'Intel UHD Graphics 620', 34000000.00, NULL, 512, 14, 'USA'),
	('hp_050', 'HP Pavilion 15', 700, 'Intel Core i5-1135G7', '8GB', 'Integrated', 28000000.00, NULL, 512, 15.6, 'USA'),
	('hp_051', 'HP Spectre x360 13', 500, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 39000000.00, NULL, 1024, 13.3, 'USA'),
	('hp_052', 'HP Pavilion 14', 700, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 31000000.00, NULL, 512, 14, 'USA'),
	('hp_053', 'HP EliteBook 840', 600, 'Intel Core i5-10210U', '8GB', 'Intel UHD Graphics 620', 34000000.00, NULL, 512, 14, 'USA'),
	('hp_054', 'HP Pavilion x360', 900, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 41000000.00, NULL, 1024, 14, 'USA'),
	('hp_055', 'HP Omen 15', 600, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1660 Ti', 44000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_056', 'HP Spectre x360 13', 100, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 40000000.00, NULL, 1024, 13.3, 'USA'),
	('hp_057', 'HP Pavilion 14', 700, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 1024, 14, 'USA'),
	('hp_058', 'HP Elite Dragonfly', 400, 'Intel Core i7-8665U', '16GB', 'Intel UHD Graphics 620', 63000000.00, NULL, 512, 13.3, 'USA'),
	('hp_059', 'HP Omen 17', 800, 'Intel Core i7-11800H', '32GB', 'NVIDIA GeForce RTX 3080', 95000000.00, NULL, 2048, 17.3, 'USA'),
	('hp_060', 'HP Pavilion x360', 600, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 30000000.00, NULL, 512, 14, 'USA'),
	('hp_061', 'HP Spectre x360 14', 900, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 46000000.00, NULL, 1024, 14, 'USA'),
	('hp_062', 'HP Envy 15', 700, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1650 Ti', 46000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_063', 'HP Pavilion 13', 500, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 29000000.00, NULL, 512, 13.3, 'USA'),
	('hp_064', 'HP EliteBook 840', 800, 'Intel Core i5-10210U', '8GB', 'Intel UHD Graphics 620', 35000000.00, NULL, 512, 14, 'USA'),
	('hp_065', 'HP Omen 15', 700, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1660 Ti', 45000000.00, NULL, 1024, 15.6, 'USA'),
	('hp_066', 'HP Spectre x360 13', 600, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 39000000.00, NULL, 1024, 13.3, 'USA'),
	('hp_067', 'HP Pavilion 14', 100, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 43000000.00, NULL, 1024, 14, 'USA'),
	('hp_068', 'HP Elite Dragonfly', 500, 'Intel Core i7-8665U', '16GB', 'Intel UHD Graphics 620', 65000000.00, NULL, 512, 13.3, 'USA'),
	('hp_069', 'HP Omen 17', 900, 'Intel Core i7-11800H', '32GB', 'NVIDIA GeForce RTX 3080', 97000000.00, NULL, 2048, 17.3, 'USA'),
	('hp_070', 'HP Spectre x360 14', 800, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 46000000.00, NULL, 1024, 14, 'USA'),
	('len001', 'Lenovo ThinkPad X1 Carbon Gen 11', 150, 'Intel Core i7-1260P', '16GB', 'Integrated Intel Iris Xe', 32990000.00, NULL, 512, 14, 'China'),
	('len002', 'Lenovo Legion 5 Pro 16', 0, 'AMD Ryzen 7 6800H', '16GB', 'NVIDIA RTX 3060', 36990000.00, NULL, 1024, 16, 'China'),
	('len003', 'Lenovo IdeaPad 3 15ADA6', 250, 'AMD Ryzen 5 5500U', '8GB', 'Integrated AMD Radeon', 13990000.00, NULL, 256, 15.6, 'China'),
	('len004', 'Lenovo Yoga Slim 7i Pro', 800, 'Intel Core i5-1135G7', '16GB', 'Integrated Intel Iris Xe', 19990000.00, NULL, 512, 14, 'China'),
	('len005', 'Lenovo ThinkPad E14 Gen 4', 120, 'Intel Core i5-1235U', '16GB', 'Integrated Intel Iris Xe', 23990000.00, NULL, 512, 14, 'China'),
	('len006', 'Lenovo IdeaPad Gaming 3', 180, 'AMD Ryzen 5 6600H', '16GB', 'NVIDIA RTX 3050', 23990000.00, NULL, 512, 15.6, 'China'),
	('len007', 'Lenovo ThinkPad T14 Gen 3', 500, 'AMD Ryzen 7 PRO 6850U', '32GB', 'Integrated AMD Radeon', 42990000.00, NULL, 1024, 14, 'China'),
	('len008', 'Lenovo Legion 7 Gen 7', 400, 'AMD Ryzen 9 6900HX', '32GB', 'NVIDIA RTX 3070 Ti', 54990000.00, NULL, 1024, 16, 'China'),
	('len009', 'Lenovo Yoga 9i', 700, 'Intel Core i7-1260P', '16GB', 'Integrated Intel Iris Xe', 42990000.00, NULL, 1024, 14, 'China'),
	('len010', 'Lenovo IdeaPad 5 Pro 14', 200, 'AMD Ryzen 5 5600U', '8GB', 'Integrated AMD Radeon', 15990000.00, NULL, 512, 14, 'China'),
	('len011', 'Lenovo ThinkPad P1 Gen 5', 300, 'Intel Core i9-12900H', '64GB', 'NVIDIA RTX A3000', 85990000.00, NULL, 2048, 16, 'China'),
	('len012', 'Lenovo Legion Slim 7', 600, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA RTX 3060', 39990000.00, NULL, 1024, 15.6, 'China'),
	('len013', 'Lenovo IdeaPad Flex 5', 180, 'Intel Core i5-1240P', '16GB', 'Integrated Intel Iris Xe', 18990000.00, NULL, 512, 14, 'China'),
	('len014', 'Lenovo ThinkBook 15 Gen 4', 900, 'Intel Core i5-1240P', '16GB', 'Integrated Intel Iris Xe', 20990000.00, NULL, 512, 15.6, 'China'),
	('len015', 'Lenovo ThinkPad X13 Gen 3', 500, 'AMD Ryzen 7 PRO 6850U', '16GB', 'Integrated AMD Radeon', 37990000.00, NULL, 512, 13.3, 'China'),
	('len016', 'Lenovo Yoga Slim 7 Carbon', 100, 'AMD Ryzen 7 5800U', '16GB', 'Integrated AMD Radeon', 28990000.00, NULL, 512, 14, 'China'),
	('len017', 'Lenovo IdeaPad 1 14ADA7', 300, 'AMD Ryzen 3 7320U', '8GB', 'Integrated AMD Radeon', 9990000.00, NULL, 256, 14, 'China'),
	('len018', 'Lenovo Legion 5 Gen 7', 800, 'AMD Ryzen 7 6800H', '16GB', 'NVIDIA RTX 3070', 43990000.00, NULL, 1024, 15.6, 'China'),
	('len019', 'Lenovo ThinkPad E15 Gen 4', 120, 'Intel Core i5-1235U', '16GB', 'Integrated Intel Iris Xe', 22990000.00, NULL, 512, 15.6, 'China'),
	('len020', 'Lenovo IdeaPad Slim 5', 150, 'AMD Ryzen 7 5825U', '16GB', 'Integrated AMD Radeon', 17990000.00, NULL, 512, 15.6, 'China'),
	('len021', 'Lenovo Legion 5i Pro', 100, 'Intel Core i7-12700H', '16GB', 'NVIDIA RTX 3060', 37990000.00, NULL, 1024, 16, 'China'),
	('len022', 'Lenovo Yoga Duet 7i', 800, 'Intel Core i7-1255U', '16GB', 'Integrated Intel Iris Xe', 32990000.00, NULL, 1024, 13.3, 'China'),
	('len023', 'Lenovo ThinkPad L14 Gen 3', 140, 'AMD Ryzen 5 PRO 5675U', '8GB', 'Integrated AMD Radeon', 17990000.00, NULL, 256, 14, 'China'),
	('len024', 'Lenovo IdeaPad 5 Gaming', 200, 'Intel Core i5-12450H', '16GB', 'NVIDIA GTX 1650', 20990000.00, NULL, 512, 15.6, 'China'),
	('len025', 'Lenovo Yoga Slim 6', 700, 'AMD Ryzen 5 5600U', '16GB', 'Integrated AMD Radeon', 18990000.00, NULL, 512, 14, 'China'),
	('len026', 'Lenovo ThinkPad P16s', 600, 'Intel Core i7-1270P', '32GB', 'NVIDIA T550', 54990000.00, NULL, 1024, 16, 'China'),
	('len027', 'Lenovo Legion Y540', 500, 'Intel Core i7-9750H', '16GB', 'NVIDIA GTX 1660 Ti', 25990000.00, NULL, 1024, 15.6, 'China'),
	('len028', 'Lenovo IdeaPad 3 17ADA6', 800, 'AMD Ryzen 7 5700U', '16GB', 'Integrated AMD Radeon', 17990000.00, NULL, 512, 17.3, 'China'),
	('len029', 'Lenovo Yoga Slim 7 Pro X', 120, 'Intel Core i7-12700H', '16GB', 'Integrated Intel Iris Xe', 35990000.00, NULL, 1024, 14.5, 'China'),
	('len030', 'Lenovo IdeaPad Duet 5 Chromebook', 150, 'Qualcomm Snapdragon 7c Gen 2', '8GB', 'Integrated', 14990000.00, NULL, 128, 13.3, 'China'),
	('len031', 'Lenovo ThinkBook 13s G4+', 900, 'Intel Core i5-1235U', '16GB', 'Integrated Intel Iris Xe', 20990000.00, NULL, 512, 13.3, 'China'),
	('len032', 'Lenovo Legion 7 Slim', 500, 'AMD Ryzen 9 5900HX', '32GB', 'NVIDIA RTX 3080', 59990000.00, NULL, 1024, 15.6, 'China'),
	('len033', 'Lenovo IdeaPad Slim 7 Pro', 700, 'Intel Core i7-1260P', '16GB', 'Integrated Intel Iris Xe', 27990000.00, NULL, 1024, 14, 'China'),
	('len034', 'Lenovo Yoga Slim 9i', 400, 'Intel Core i7-1280P', '32GB', 'Integrated Intel Iris Xe', 49990000.00, NULL, 1024, 14, 'China'),
	('len035', 'Lenovo ThinkPad P14s Gen 3', 100, 'Intel Core i7-1255U', '16GB', 'NVIDIA T550', 36990000.00, NULL, 512, 14, 'China'),
	('len036', 'Lenovo IdeaPad Gaming 3i', 120, 'Intel Core i5-12500H', '16GB', 'NVIDIA RTX 3050 Ti', 24990000.00, NULL, 512, 15.6, 'China'),
	('len037', 'Lenovo Yoga 6', 150, 'AMD Ryzen 5 5600U', '8GB', 'Integrated AMD Radeon', 16990000.00, NULL, 512, 13.3, 'China'),
	('len038', 'Lenovo ThinkPad L15 Gen 3', 900, 'AMD Ryzen 7 PRO 5875U', '16GB', 'Integrated AMD Radeon', 21990000.00, NULL, 512, 15.6, 'China'),
	('len039', 'Lenovo Legion 5 Gen 5', 800, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1660 Ti', 23990000.00, NULL, 1024, 15.6, 'China'),
	('len040', 'Lenovo Yoga Book 9i', 300, 'Intel Core i7-1255U', '16GB', 'Integrated Intel Iris Xe', 49990000.00, NULL, 1024, 13.3, 'China'),
	('len041', 'Lenovo IdeaPad 5 14ITL6', 140, 'Intel Core i3-1115G4', '8GB', 'Integrated Intel UHD', 12990000.00, NULL, 256, 14, 'China'),
	('len042', 'Lenovo ThinkPad T15p', 600, 'Intel Core i7-10850H', '32GB', 'NVIDIA Quadro T1000', 41990000.00, NULL, 1024, 15.6, 'China'),
	('len043', 'Lenovo Yoga C940', 500, 'Intel Core i7-10510U', '16GB', 'Integrated Intel UHD', 25990000.00, NULL, 1024, 14, 'China'),
	('len044', 'Lenovo IdeaPad 5 15ARE05', 800, 'AMD Ryzen 7 4700U', '16GB', 'Integrated AMD Radeon', 19990000.00, NULL, 512, 15.6, 'China'),
	('len045', 'Lenovo ThinkPad X280', 400, 'Intel Core i5-8350U', '8GB', 'Integrated Intel UHD', 14990000.00, NULL, 256, 12.5, 'China'),
	('len046', 'Lenovo Legion Y7000', 600, 'Intel Core i7-8750H', '16GB', 'NVIDIA GTX 1050 Ti', 22990000.00, NULL, 512, 15.6, 'China'),
	('len047', 'Lenovo IdeaPad 3 14ADA6', 250, 'AMD Ryzen 3 5300U', '8GB', 'Integrated AMD Radeon', 11990000.00, NULL, 256, 14, 'China'),
	('len048', 'Lenovo Yoga Slim 7 Pro', 800, 'AMD Ryzen 5 5600U', '16GB', 'Integrated AMD Radeon', 21990000.00, NULL, 512, 14, 'China'),
	('len049', 'Lenovo ThinkBook 14s Yoga ITL', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated Intel Iris Xe', 17990000.00, NULL, 512, 14, 'China'),
	('len050', 'Lenovo Legion Slim 7 Gen 6', 600, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA RTX 3060', 38990000.00, NULL, 1024, 15.6, 'China'),
	('len051', 'Lenovo IdeaPad 1 15ADA7', 300, 'AMD Ryzen 3 7320U', '8GB', 'Integrated AMD Radeon', 9990000.00, NULL, 256, 15.6, 'China'),
	('len052', 'Lenovo Legion 5 Pro', 700, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA RTX 3060', 34990000.00, NULL, 1024, 16, 'China'),
	('len053', 'Lenovo Yoga C740', 800, 'Intel Core i5-10210U', '8GB', 'Integrated Intel UHD', 16990000.00, NULL, 512, 14, 'China'),
	('len054', 'Lenovo ThinkPad E480', 100, 'Intel Core i5-8250U', '8GB', 'Integrated Intel UHD', 12990000.00, NULL, 256, 14, 'China'),
	('len055', 'Lenovo IdeaPad Slim 3', 200, 'Intel Core i3-1115G4', '8GB', 'Integrated Intel UHD', 10990000.00, NULL, 256, 14, 'China'),
	('len056', 'Lenovo Yoga S730', 120, 'Intel Core i7-8565U', '16GB', 'Integrated Intel UHD', 20990000.00, NULL, 512, 13.3, 'China'),
	('len057', 'Lenovo ThinkBook 15 G2 ITL', 100, 'Intel Core i5-1135G7', '8GB', 'Integrated Intel Iris Xe', 15990000.00, NULL, 512, 15.6, 'China'),
	('len058', 'Lenovo Legion Y740', 500, 'Intel Core i7-8750H', '16GB', 'NVIDIA RTX 2060', 29990000.00, NULL, 1024, 15.6, 'China'),
	('len059', 'Lenovo IdeaPad 5 15IIL05', 900, 'Intel Core i7-1065G7', '16GB', 'Integrated Intel Iris Plus', 18990000.00, NULL, 512, 15.6, 'China'),
	('len060', 'Lenovo Yoga Slim 9i', 600, 'Intel Core i7-1165G7', '16GB', 'Integrated Intel Iris Xe', 27990000.00, NULL, 512, 14, 'China'),
	('len061', 'Lenovo ThinkBook 14 G2 ARE', 800, 'AMD Ryzen 5 4500U', '8GB', 'Integrated AMD Radeon', 14990000.00, NULL, 512, 14, 'China'),
	('len062', 'Lenovo IdeaPad 5 15ARE05', 100, 'AMD Ryzen 5 4500U', '16GB', 'Integrated AMD Radeon', 15990000.00, NULL, 512, 15.6, 'China'),
	('len063', 'Lenovo ThinkPad X12 Detachable', 500, 'Intel Core i5-1130G7', '16GB', 'Integrated Intel Iris Xe', 26990000.00, NULL, 512, 12.3, 'China'),
	('len064', 'Lenovo IdeaPad 3 15ITL6', 200, 'Intel Core i5-1135G7', '8GB', 'Integrated Intel Iris Xe', 13990000.00, NULL, 256, 15.6, 'China'),
	('len065', 'Lenovo Legion Slim 5', 800, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA RTX 3060', 36990000.00, NULL, 1024, 15.6, 'China'),
	('len066', 'Lenovo ThinkPad E14 Gen 2', 120, 'Intel Core i5-10210U', '8GB', 'Integrated Intel UHD', 15990000.00, NULL, 256, 14, 'China'),
	('len067', 'Lenovo Yoga Slim 7 Pro', 700, 'Intel Core i5-1135G7', '16GB', 'Integrated Intel Iris Xe', 20990000.00, NULL, 512, 14, 'China'),
	('len100', 'Lenovo ThinkPad X1 Nano', 500, 'Intel Core i7-1160G7', '16GB', 'Intel Iris Xe', 54000000.00, NULL, 1024, 13, 'China'),
	('len101', 'bibi', 120, 'àefafaf', '64 Gb', 'Integrated', 1249929.00, NULL, 1024, NULL, NULL),
	('len68', 'Lenovo ThinkPad X1 Carbon', 500, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 38000000.00, NULL, 1024, 14, 'China'),
	('len69', 'Lenovo Yoga 7i', 600, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 1024, 14, 'China'),
	('len70', 'Lenovo Legion 5 Pro', 400, 'AMD Ryzen 7 5800H', '16GB', 'NVIDIA RTX 3060', 51000000.00, NULL, 1024, 15.6, 'China'),
	('len71', 'Lenovo IdeaPad 5', 800, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 32000000.00, NULL, 512, 14, 'China'),
	('len72', 'Lenovo ThinkPad E14', 700, 'Intel Core i5-10210U', '8GB', 'Intel UHD Graphics', 28000000.00, NULL, 512, 14, 'China'),
	('len73', 'Lenovo Yoga C740', 500, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 40000000.00, NULL, 1024, 14, 'China'),
	('len74', 'Lenovo ThinkPad T14s', 900, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 46000000.00, NULL, 1024, 14, 'China'),
	('len75', 'Lenovo Legion 5', 600, 'AMD Ryzen 5 5600H', '8GB', 'NVIDIA GTX 1650', 35000000.00, NULL, 512, 15.6, 'China'),
	('len76', 'Lenovo IdeaPad 3', 700, 'Intel Core i3-1005G1', '4GB', 'Intel UHD Graphics', 22000000.00, NULL, 256, 14, 'China'),
	('len77', 'Lenovo ThinkPad X1 Yoga', 400, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 48000000.00, NULL, 1024, 13.3, 'China'),
	('len78', 'Lenovo ThinkPad L14', 600, 'Intel Core i5-1035G1', '8GB', 'Intel UHD Graphics', 29000000.00, NULL, 512, 14, 'China'),
	('len79', 'Lenovo Legion Y540', 400, 'Intel Core i7-9750H', '16GB', 'NVIDIA GTX 1650', 36000000.00, NULL, 1024, 15.6, 'China'),
	('len80', 'Lenovo ThinkPad T14', 700, 'Intel Core i7-10850H', '16GB', 'Intel UHD Graphics', 42000000.00, NULL, 1024, 14, 'China'),
	('len81', 'Lenovo ThinkPad X1 Extreme', 300, 'Intel Core i9-10885H', '32GB', 'NVIDIA GTX 1650 Ti', 65000000.00, NULL, 1024, 15.6, 'China'),
	('len82', 'Lenovo Yoga 9i', 800, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 45000000.00, NULL, 1024, 14, 'China'),
	('len83', 'Lenovo ThinkPad X13', 500, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 47000000.00, NULL, 1024, 13.3, 'China'),
	('len84', 'Lenovo IdeaPad Flex 5', 600, 'AMD Ryzen 5 4500U', '8GB', 'AMD Radeon', 35000000.00, NULL, 512, 14, 'China'),
	('len85', 'Lenovo ThinkPad E15', 100, 'Intel Core i5-10210U', '8GB', 'Intel UHD Graphics', 30000000.00, NULL, 512, 15.6, 'China'),
	('len86', 'Lenovo Legion 7i', 400, 'Intel Core i7-10750H', '16GB', 'NVIDIA RTX 2070', 55000000.00, NULL, 1024, 15.6, 'China'),
	('len87', 'Lenovo IdeaPad Slim 5', 700, 'AMD Ryzen 5 5500U', '8GB', 'AMD Radeon', 37000000.00, NULL, 512, 14, 'China'),
	('len88', 'Lenovo ThinkPad P15s', 600, 'Intel Core i7-10810U', '16GB', 'Intel UHD Graphics', 48000000.00, NULL, 1024, 15.6, 'China'),
	('len89', 'Lenovo ThinkPad X1 Carbon Gen 9', 900, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 52000000.00, NULL, 1024, 14, 'China'),
	('len90', 'Lenovo ThinkPad T15', 500, 'Intel Core i7-10510U', '8GB', 'Intel UHD Graphics', 36000000.00, NULL, 512, 15.6, 'China'),
	('len91', 'Lenovo ThinkPad X1 Yoga Gen 6', 600, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 53000000.00, NULL, 1024, 14, 'China'),
	('len92', 'Lenovo Yoga 6', 700, 'AMD Ryzen 7 5700U', '16GB', 'AMD Radeon', 46000000.00, NULL, 1024, 13.3, 'China'),
	('len93', 'Lenovo Legion 5i', 400, 'Intel Core i7-10750H', '16GB', 'NVIDIA RTX 2060', 50000000.00, NULL, 1024, 15.6, 'China'),
	('len94', 'Lenovo ThinkPad L15', 600, 'Intel Core i5-1035G1', '8GB', 'Intel UHD Graphics', 27000000.00, NULL, 512, 15.6, 'China'),
	('len95', 'Lenovo ThinkPad X12', 500, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 12.3, 'China'),
	('len96', 'Lenovo Legion Y7000', 300, 'Intel Core i7-8750H', '16GB', 'NVIDIA GTX 1060', 46000000.00, NULL, 1024, 15.6, 'China'),
	('len97', 'Lenovo ThinkPad P14s', 600, 'Intel Core i7-10510U', '8GB', 'Intel UHD Graphics', 47000000.00, NULL, 1024, 14, 'China'),
	('len98', 'Lenovo Legion 5 Pro Gen 6', 400, 'AMD Ryzen 9 5900HX', '32GB', 'NVIDIA RTX 3070', 65000000.00, NULL, 1024, 16, 'China'),
	('len99', 'Lenovo ThinkPad L14 Gen 2', 800, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 1024, 14, 'China'),
	('mac001', 'MacBook Air M2', 900, 'Apple M2', '8GB', 'Integrated', 29999990.00, NULL, 512, 13.3, 'USA'),
	('mac002', 'MacBook Pro M1', 300, 'Apple M1', '16GB', 'Integrated', 37999990.00, NULL, 1024, 14, 'USA'),
	('mac003', 'MacBook Pro M2', 200, 'Apple M2', '16GB', 'Integrated', 41999990.00, NULL, 1024, 16, 'USA'),
	('mac004', 'MacBook Air 13-inch', 600, 'Intel Core i5', '8GB', 'Intel Iris Plus', 25999990.00, NULL, 256, 13.3, 'USA'),
	('mac005', 'MacBook Pro 16-inch', 400, 'Intel Core i9', '32GB', 'AMD Radeon Pro 5500M', 56999990.00, NULL, 2048, 16, 'USA'),
	('mac006', 'MacBook Air 15-inch M2', 300, 'Apple M2', '8GB', 'Integrated', 33999990.00, NULL, 512, 15, 'USA'),
	('mac007', 'MacBook Pro M2 Pro', 200, 'Apple M2 Pro', '32GB', 'Integrated', 55999990.00, NULL, 1024, 14, 'USA'),
	('mac008', 'MacBook Pro 15-inch', 100, 'Intel Core i7', '16GB', 'Intel UHD Graphics 630', 38999990.00, NULL, 512, 15, 'USA'),
	('mac009', 'MacBook Air M1', 500, 'Apple M1', '8GB', 'Integrated', 22999990.00, NULL, 256, 13.3, 'USA'),
	('mac010', 'MacBook Pro M1 Max', 200, 'Apple M1 Max', '64GB', 'Integrated', 72999990.00, NULL, 4096, 16, 'USA'),
	('mac015', 'Macbook Pro M3 Max', 120, 'M3 Max', '64 Gb', 'Integrated', 89000000.00, NULL, 1024, NULL, NULL),
	('mac025', 'MacBook Pro 16 M2 Max', 300, 'Apple M2 Max', '32GB', 'Integrated', 89990000.00, NULL, 2048, 16.2, 'USA'),
	('mac026', 'MacBook Air M2', 100, 'Apple M2', '8GB', 'Integrated', 25990000.00, NULL, 512, 13.6, 'USA'),
	('mac027', 'MacBook Pro 14 M2 Pro', 600, 'Apple M2 Pro', '16GB', 'Integrated', 57990000.00, NULL, 1024, 14.2, 'USA'),
	('mac028', 'MacBook Air M1', 150, 'Apple M1', '8GB', 'Integrated', 19990000.00, NULL, 256, 13.3, 'USA'),
	('mac029', 'MacBook Pro 13 M2', 800, 'Apple M2', '8GB', 'Integrated', 29990000.00, NULL, 512, 13.3, 'USA'),
	('mac030', 'MacBook Pro 16 M1 Max', 200, 'Apple M1 Max', '32GB', 'Integrated', 79990000.00, NULL, 1024, 16.2, 'USA'),
	('mac031', 'MacBook Pro 14 M1 Pro', 500, 'Apple M1 Pro', '16GB', 'Integrated', 48990000.00, NULL, 512, 14.2, 'USA'),
	('mac032', 'MacBook Pro 13 M1', 120, 'Apple M1', '8GB', 'Integrated', 24990000.00, NULL, 256, 13.3, 'USA'),
	('mac033', 'MacBook Air M2 512GB', 700, 'Apple M2', '8GB', 'Integrated', 29990000.00, NULL, 512, 13.6, 'USA'),
	('mac034', 'MacBook Pro 16-inch Intel i9', 300, 'Intel Core i9', '16GB', 'AMD Radeon Pro 5500M', 52990000.00, NULL, 1024, 16, 'USA'),
	('mac035', 'MacBook Pro 14 M2 Max', 400, 'Apple M2 Max', '32GB', 'Integrated', 73990000.00, NULL, 1024, 14.2, 'USA'),
	('mac036', 'MacBook Air M2 16GB', 900, 'Apple M2', '16GB', 'Integrated', 30990000.00, NULL, 512, 13.6, 'USA'),
	('mac037', 'MacBook Pro 13 M1 512GB', 100, 'Apple M1', '8GB', 'Integrated', 26990000.00, NULL, 512, 13.3, 'USA'),
	('mac038', 'MacBook Pro 16 M1 Pro', 300, 'Apple M1 Pro', '16GB', 'Integrated', 51990000.00, NULL, 1024, 16.2, 'USA'),
	('mac039', 'MacBook Air 15-inch M2', 600, 'Apple M2', '8GB', 'Integrated', 32990000.00, NULL, 512, 15.3, 'USA'),
	('mac040', 'MacBook Pro 13 M2 1TB', 400, 'Apple M2', '8GB', 'Integrated', 34990000.00, NULL, 1024, 13.3, 'USA'),
	('mac041', 'MacBook Air M1 512GB', 800, 'Apple M1', '8GB', 'Integrated', 23990000.00, NULL, 512, 13.3, 'USA'),
	('mac042', 'MacBook Pro 16 M2 Pro', 500, 'Apple M2 Pro', '16GB', 'Integrated', 65990000.00, NULL, 1024, 16.2, 'USA'),
	('mac043', 'MacBook Pro 13 Intel i5', 400, 'Intel Core i5', '8GB', 'Integrated', 19990000.00, NULL, 256, 13.3, 'USA'),
	('mac044', 'MacBook Air 15-inch M2 1TB', 300, 'Apple M2', '16GB', 'Integrated', 38990000.00, NULL, 1024, 15.3, 'USA'),
	('mac045', 'MacBook Pro 14 M1 Max', 200, 'Apple M1 Max', '32GB', 'Integrated', 75990000.00, NULL, 1024, 14.2, 'USA'),
	('mac046', 'MacBook Pro 13 Intel i7', 500, 'Intel Core i7', '16GB', 'Integrated', 27990000.00, NULL, 512, 13.3, 'USA'),
	('mac047', 'MacBook Air M2 8-Core GPU', 700, 'Apple M2', '8GB', 'Integrated', 27990000.00, NULL, 512, 13.6, 'USA'),
	('mac048', 'MacBook Pro 16 Intel i7', 300, 'Intel Core i7', '16GB', 'AMD Radeon Pro 5300M', 49990000.00, NULL, 1024, 16, 'USA'),
	('mac049', 'MacBook Air M1 7-Core GPU', 120, 'Apple M1', '8GB', 'Integrated', 18990000.00, NULL, 256, 13.3, 'USA'),
	('mac050', 'Macbook Pro M3 Max Maxxxx', 120, 'M3 Max', '64 Gb', NULL, 89000000.00, NULL, 1024, NULL, NULL),
	('mac100', 'MacBook Air M1 2021', 600, 'Apple M1', '16GB', 'Apple GPU', 46000000.00, NULL, 512, 13.3, 'USA'),
	('mac101', 'MacBook Air M2', 120, 'Apple M2', '8GB', 'Integrated', 32000000.00, NULL, 512, 13.6, 'USA'),
	('mac102', 'MacBook Pro 13 M1', 800, 'Apple M1', '8GB', 'Integrated', 35000000.00, NULL, 256, 13.3, 'USA'),
	('mac103', 'MacBook Pro 13 M2', 600, 'Apple M2', '8GB', 'Integrated', 38000000.00, NULL, 512, 13.3, 'USA'),
	('mac104', 'MacBook Pro 14', 700, 'Apple M1 Pro', '16GB', 'Integrated', 45000000.00, NULL, 512, 14.2, 'USA'),
	('mac105', 'MacBook Pro 16', 900, 'Apple M1 Pro', '16GB', 'Integrated', 55000000.00, NULL, 1024, 16.2, 'USA'),
	('mac106', 'MacBook Air M1', 500, 'Apple M1', '16GB', 'Integrated', 30000000.00, NULL, 512, 13.3, 'USA'),
	('mac107', 'MacBook Pro 14', 100, 'Apple M2 Pro', '16GB', 'Integrated', 48000000.00, NULL, 1024, 14.2, 'USA'),
	('mac108', 'MacBook Pro 16', 700, 'Apple M2 Pro', '32GB', 'Integrated', 60000000.00, NULL, 1024, 16.2, 'USA'),
	('mac109', 'MacBook Air M2', 800, 'Apple M2', '8GB', 'Integrated', 34000000.00, NULL, 512, 13.6, 'USA'),
	('mac110', 'MacBook Pro 13 M1', 120, 'Apple M1', '8GB', 'Integrated', 36000000.00, NULL, 512, 13.3, 'USA'),
	('mac111', 'MacBook Air M1', 600, 'Apple M1', '8GB', 'Integrated', 29000000.00, NULL, 256, 13.3, 'USA'),
	('mac112', 'MacBook Pro 14', 110, 'Apple M1 Pro', '16GB', 'Integrated', 46000000.00, NULL, 512, 14.2, 'USA'),
	('mac113', 'MacBook Pro 16', 800, 'Apple M1 Pro', '16GB', 'Integrated', 53000000.00, NULL, 1024, 16.2, 'USA'),
	('mac114', 'MacBook Air M2', 900, 'Apple M2', '16GB', 'Integrated', 33000000.00, NULL, 512, 13.6, 'USA'),
	('mac115', 'MacBook Pro 13 M2', 700, 'Apple M2', '16GB', 'Integrated', 40000000.00, NULL, 512, 13.3, 'USA'),
	('mac116', 'MacBook Pro 16', 100, 'Apple M2 Pro', '32GB', 'Integrated', 62000000.00, NULL, 2048, 16.2, 'USA'),
	('mac117', 'MacBook Air M1', 800, 'Apple M1', '8GB', 'Integrated', 31000000.00, NULL, 512, 13.3, 'USA'),
	('mac118', 'MacBook Pro 14', 600, 'Apple M1 Pro', '32GB', 'Integrated', 50000000.00, NULL, 1024, 14.2, 'USA'),
	('mac119', 'MacBook Pro 13 M1', 100, 'Apple M1', '8GB', 'Integrated', 33000000.00, NULL, 256, 13.3, 'USA'),
	('mac120', 'MacBook Pro 16', 500, 'Apple M1 Pro', '16GB', 'Integrated', 52000000.00, NULL, 1024, 16.2, 'USA'),
	('mac121', 'MacBook Air M2', 120, 'Apple M2', '8GB', 'Integrated', 34000000.00, NULL, 512, 13.6, 'USA'),
	('mac122', 'MacBook Pro 13 M2', 800, 'Apple M2', '8GB', 'Integrated', 37000000.00, NULL, 256, 13.3, 'USA'),
	('mac123', 'MacBook Air M1', 100, 'Apple M1', '16GB', 'Integrated', 32000000.00, NULL, 512, 13.3, 'USA'),
	('mac124', 'MacBook Pro 14', 700, 'Apple M1 Pro', '16GB', 'Integrated', 46000000.00, NULL, 512, 14.2, 'USA'),
	('mac125', 'MacBook Pro 16', 500, 'Apple M1 Pro', '16GB', 'Integrated', 55000000.00, NULL, 1024, 16.2, 'USA'),
	('mac126', 'MacBook Air M2', 110, 'Apple M2', '16GB', 'Integrated', 35000000.00, NULL, 512, 13.6, 'USA'),
	('mac127', 'MacBook Pro 13 M1', 900, 'Apple M1', '8GB', 'Integrated', 33000000.00, NULL, 512, 13.3, 'USA'),
	('mac128', 'MacBook Pro 16', 800, 'Apple M1 Pro', '32GB', 'Integrated', 60000000.00, NULL, 2048, 16.2, 'USA'),
	('mac129', 'MacBook Air M1', 700, 'Apple M1', '16GB', 'Integrated', 31000000.00, NULL, 512, 13.3, 'USA'),
	('mac130', 'MacBook Pro 14', 120, 'Apple M2 Pro', '16GB', 'Integrated', 48000000.00, NULL, 1024, 14.2, 'USA'),
	('mac131', 'MacBook Pro 13 M2', 600, 'Apple M2', '8GB', 'Integrated', 38000000.00, NULL, 512, 13.3, 'USA'),
	('mac132', 'MacBook Air M2', 900, 'Apple M2', '16GB', 'Integrated', 34000000.00, NULL, 512, 13.6, 'USA'),
	('mac133', 'MacBook Pro 14', 800, 'Apple M2 Pro', '16GB', 'Integrated', 49000000.00, NULL, 1024, 14.2, 'USA'),
	('mac134', 'MacBook Pro 16', 700, 'Apple M2 Pro', '32GB', 'Integrated', 62000000.00, NULL, 2048, 16.2, 'USA'),
	('mac135', 'MacBook Air M1', 800, 'Apple M1', '8GB', 'Integrated', 30000000.00, NULL, 512, 13.3, 'USA'),
	('mac136', 'MacBook Pro 13 M1', 100, 'Apple M1', '16GB', 'Integrated', 35000000.00, NULL, 512, 13.3, 'USA'),
	('mac137', 'MacBook Air M2', 800, 'Apple M2', '8GB', 'Integrated', 32000000.00, NULL, 512, 13.6, 'USA'),
	('mac138', 'MacBook Pro 14', 110, 'Apple M2 Pro', '16GB', 'Integrated', 47000000.00, NULL, 1024, 14.2, 'USA'),
	('mac139', 'MacBook Pro 16', 600, 'Apple M2 Pro', '16GB', 'Integrated', 57000000.00, NULL, 1024, 16.2, 'USA'),
	('mac140', 'MacBook Air M1', 900, 'Apple M1', '16GB', 'Integrated', 31000000.00, NULL, 512, 13.3, 'USA'),
	('mac141', 'MacBook Pro 13 M2', 800, 'Apple M2', '8GB', 'Integrated', 38000000.00, NULL, 512, 13.3, 'USA'),
	('mac142', 'MacBook Air M2', 100, 'Apple M2', '16GB', 'Integrated', 33000000.00, NULL, 512, 13.6, 'USA'),
	('mac143', 'MacBook Pro 14', 900, 'Apple M2 Pro', '16GB', 'Integrated', 49000000.00, NULL, 1024, 14.2, 'USA'),
	('mac144', 'MacBook Pro 16', 500, 'Apple M2 Pro', '32GB', 'Integrated', 64000000.00, NULL, 2048, 16.2, 'USA'),
	('mac145', 'MacBook Pro 13 M2', 700, 'Apple M2', '8GB', 'Integrated', 38000000.00, NULL, 512, 13.3, 'USA'),
	('mac51', 'MacBook Air M1', 600, 'Apple M1', '8GB', 'Apple GPU', 35000000.00, NULL, 512, 13.3, 'USA'),
	('mac52', 'MacBook Pro 13 M1', 800, 'Apple M1', '16GB', 'Apple GPU', 45000000.00, NULL, 512, 13.3, 'USA'),
	('mac53', 'MacBook Pro 16', 500, 'Intel Core i9-9980HK', '16GB', 'AMD Radeon Pro 5500M', 65000000.00, NULL, 1024, 16, 'USA'),
	('mac54', 'MacBook Air 2020', 700, 'Intel Core i5-1030NG7', '8GB', 'Intel Iris Plus', 40000000.00, NULL, 512, 13.3, 'USA'),
	('mac55', 'MacBook Pro 15', 300, 'Intel Core i7-9750H', '16GB', 'AMD Radeon Pro 5300M', 70000000.00, NULL, 1024, 15.4, 'USA'),
	('mac56', 'MacBook Pro 13 2020', 400, 'Intel Core i5-1038NG7', '8GB', 'Intel Iris Plus', 42000000.00, NULL, 512, 13.3, 'USA'),
	('mac57', 'MacBook Air 2021', 600, 'Apple M1', '8GB', 'Apple GPU', 38000000.00, NULL, 512, 13.3, 'USA'),
	('mac58', 'MacBook Pro 14', 700, 'Apple M1 Pro', '16GB', 'Apple GPU', 52000000.00, NULL, 512, 14, 'USA'),
	('mac59', 'MacBook Pro 16 M1', 500, 'Apple M1 Pro', '32GB', 'Apple GPU', 75000000.00, NULL, 1024, 16, 'USA'),
	('mac60', 'MacBook Pro 13 Touch Bar', 400, 'Intel Core i7-8559U', '16GB', 'Intel Iris Plus', 55000000.00, NULL, 1024, 13.3, 'USA'),
	('mac61', 'MacBook Air 2020 Retina', 600, 'Intel Core i3-1000NG4', '8GB', 'Intel Iris Plus', 38000000.00, NULL, 512, 13.3, 'USA'),
	('mac62', 'MacBook Pro 13 Touch Bar 2018', 700, 'Intel Core i5-8279U', '8GB', 'Intel Iris Plus', 46000000.00, NULL, 512, 13.3, 'USA'),
	('mac63', 'MacBook Air M2', 800, 'Apple M2', '8GB', 'Apple GPU', 40000000.00, NULL, 512, 13.6, 'USA'),
	('mac64', 'MacBook Pro 13 2019', 600, 'Intel Core i5-8365U', '8GB', 'Intel Iris Plus', 47000000.00, NULL, 512, 13.3, 'USA'),
	('mac65', 'MacBook Pro 14 2021', 500, 'Apple M1 Pro', '16GB', 'Apple GPU', 52000000.00, NULL, 512, 14, 'USA'),
	('mac66', 'MacBook Pro 16 2021', 400, 'Apple M1 Max', '32GB', 'Apple GPU', 90000000.00, NULL, 1024, 16.2, 'USA'),
	('mac67', 'MacBook Air 2022', 600, 'Apple M2', '8GB', 'Apple GPU', 42000000.00, NULL, 512, 13.6, 'USA'),
	('mac68', 'MacBook Pro 16 M2', 300, 'Apple M2 Max', '32GB', 'Apple GPU', 95000000.00, NULL, 1024, 16.2, 'USA'),
	('mac69', 'MacBook Pro 15 Retina', 700, 'Intel Core i7-6820HQ', '16GB', 'AMD Radeon R9 M370X', 68000000.00, NULL, 1024, 15.4, 'USA'),
	('mac70', 'MacBook Air 2019', 600, 'Intel Core i5-8210Y', '8GB', 'Intel UHD Graphics 617', 42000000.00, NULL, 512, 13.3, 'USA'),
	('mac71', 'MacBook Pro 13 M2', 500, 'Apple M2', '16GB', 'Apple GPU', 48000000.00, NULL, 512, 13.3, 'USA'),
	('mac72', 'MacBook Pro 13 2021', 400, 'Apple M1 Pro', '16GB', 'Apple GPU', 55000000.00, NULL, 512, 13.3, 'USA'),
	('mac73', 'MacBook Pro 14 2020', 500, 'Intel Core i5-10210U', '8GB', 'Intel Iris Plus', 49000000.00, NULL, 512, 14, 'USA'),
	('mac74', 'MacBook Air 2020', 600, 'Intel Core i7-1060NG7', '16GB', 'Intel Iris Plus', 47000000.00, NULL, 512, 13.3, 'USA'),
	('mac75', 'MacBook Pro 16 Retina', 300, 'Intel Core i9-9980HK', '32GB', 'AMD Radeon Pro 560X', 72000000.00, NULL, 1024, 15.4, 'USA'),
	('mac76', 'MacBook Pro 15 2017', 400, 'Intel Core i7-7700HQ', '16GB', 'AMD Radeon Pro 560', 65000000.00, NULL, 1024, 15.4, 'USA'),
	('mac77', 'MacBook Pro 13 2020', 700, 'Intel Core i5-1038NG7', '8GB', 'Intel Iris Plus', 46000000.00, NULL, 512, 13.3, 'USA'),
	('mac78', 'MacBook Pro 16 Touch Bar', 500, 'Intel Core i7-9750H', '16GB', 'AMD Radeon Pro 5300M', 68000000.00, NULL, 1024, 16, 'USA'),
	('mac79', 'MacBook Pro 15 2018', 300, 'Intel Core i7-8750H', '16GB', 'AMD Radeon Pro 560X', 65000000.00, NULL, 1024, 15.4, 'USA'),
	('mac80', 'MacBook Pro 13 2021 M1', 600, 'Apple M1', '8GB', 'Apple GPU', 45000000.00, NULL, 512, 13.3, 'USA'),
	('mac81', 'MacBook Pro 16 2022', 400, 'Apple M1 Max', '32GB', 'Apple GPU', 85000000.00, NULL, 1024, 16.2, 'USA'),
	('mac82', 'MacBook Pro 14 M1', 500, 'Apple M1 Pro', '16GB', 'Apple GPU', 51000000.00, NULL, 512, 14, 'USA'),
	('mac83', 'MacBook Air 2021 M1', 600, 'Apple M1', '8GB', 'Apple GPU', 40000000.00, NULL, 512, 13.3, 'USA'),
	('mac84', 'MacBook Pro 15 Retina 2017', 500, 'Intel Core i7-7820HQ', '16GB', 'AMD Radeon Pro 560', 69000000.00, NULL, 1024, 15.4, 'USA'),
	('mac85', 'MacBook Pro 13 2019', 300, 'Intel Core i5-8365U', '8GB', 'Intel UHD Graphics 620', 46000000.00, NULL, 512, 13.3, 'USA'),
	('mac86', 'MacBook Pro 13 2021', 400, 'Apple M1 Pro', '16GB', 'Apple GPU', 50000000.00, NULL, 512, 13.3, 'USA'),
	('mac87', 'MacBook Pro 16 2021 M1', 500, 'Apple M1 Pro', '32GB', 'Apple GPU', 72000000.00, NULL, 1024, 16, 'USA'),
	('mac88', 'MacBook Air M1 2021', 600, 'Apple M1', '8GB', 'Apple GPU', 40000000.00, NULL, 512, 13.3, 'USA'),
	('mac89', 'MacBook Pro 16 2022 M1 Max', 500, 'Apple M1 Max', '32GB', 'Apple GPU', 85000000.00, NULL, 1024, 16.2, 'USA'),
	('mac90', 'MacBook Pro 13 Touch Bar 2020', 300, 'Intel Core i5-1038NG7', '8GB', 'Intel Iris Plus', 46000000.00, NULL, 512, 13.3, 'USA'),
	('mac91', 'MacBook Pro 16 2019', 600, 'Intel Core i9-9980HK', '32GB', 'AMD Radeon Pro 5500M', 72000000.00, NULL, 1024, 16, 'USA'),
	('mac92', 'MacBook Air M2 2022', 600, 'Apple M2', '8GB', 'Apple GPU', 45000000.00, NULL, 512, 13.6, 'USA'),
	('mac93', 'MacBook Pro 14 M2', 400, 'Apple M2 Pro', '16GB', 'Apple GPU', 53000000.00, NULL, 512, 14, 'USA'),
	('mac94', 'MacBook Pro 15 2016', 300, 'Intel Core i7-6820HQ', '16GB', 'AMD Radeon Pro 460', 67000000.00, NULL, 1024, 15.4, 'USA'),
	('mac95', 'MacBook Air 2021 M2', 700, 'Apple M2', '8GB', 'Apple GPU', 46000000.00, NULL, 512, 13.6, 'USA'),
	('mac96', 'MacBook Pro 13 2018 M1', 500, 'Apple M1', '8GB', 'Apple GPU', 47000000.00, NULL, 512, 13.3, 'USA'),
	('mac97', 'MacBook Air M2 2022', 600, 'Apple M2', '16GB', 'Apple GPU', 48000000.00, NULL, 512, 13.6, 'USA'),
	('mac98', 'MacBook Pro 16 M1 Pro', 400, 'Apple M1 Pro', '16GB', 'Apple GPU', 74000000.00, NULL, 1024, 16, 'USA'),
	('mac99', 'MacBook Pro 13 M2 2022', 500, 'Apple M2', '16GB', 'Apple GPU', 52000000.00, NULL, 512, 13.3, 'USA'),
	('mic001', 'Microsoft Surface Pro 8', 500, 'Intel Core i5-1135G7', '8GB', 'Integrated', 28999990.00, NULL, 256, 13, 'USA'),
	('mic002', 'Microsoft Surface Laptop 4', 600, 'AMD Ryzen 5', '8GB', 'Integrated', 25999990.00, NULL, 512, 13.5, 'USA'),
	('mic003', 'Microsoft Surface Pro 7+', 300, 'Intel Core i7-1165G7', '16GB', 'Integrated', 30999990.00, NULL, 512, 12.3, 'USA'),
	('mic004', 'Microsoft Surface Book 3', 200, 'Intel Core i7-1065G7', '16GB', 'NVIDIA GTX 1660', 49999990.00, NULL, 1024, 15, 'USA'),
	('mic005', 'Microsoft Surface Go 3', 700, 'Intel Core i3-10100Y', '4GB', 'Integrated', 10999990.00, NULL, 64, 10.5, 'USA'),
	('mic006', 'Microsoft Surface Laptop Studio', 200, 'Intel Core i7-11370H', '16GB', 'NVIDIA GTX 3050 Ti', 65999990.00, NULL, 512, 14.4, 'USA'),
	('mic007', 'Microsoft Surface Pro XV', 300, 'Microsoft SQ2', '16GB', 'Integrated', 32999990.00, NULL, 256, 13, 'USA'),
	('mic008', 'Microsoft Surface Laptop Go', 500, 'Intel Core i5-1035G1', '8GB', 'Integrated', 18999990.00, NULL, 128, 12.4, 'USA'),
	('mic009', 'Microsoft Surface Laptop 5', 400, 'Intel Core i5-1245U', '8GB', 'Integrated', 31999990.00, NULL, 512, 13.5, 'USA'),
	('mic010', 'Microsoft Surface Go 2', 600, 'Intel Pentium Gold 4425Y', '4GB', 'Integrated', 7999990.00, NULL, 64, 10.5, 'USA'),
	('mic011', 'Surface', 120, 'Intel', '24 Gb', 'Integrated', 299999999.00, NULL, 1024, NULL, NULL),
	('msi001', 'MSI GE76 Raider', 400, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3070', 43999990.00, NULL, 1024, 17.3, 'China'),
	('msi002', 'MSI GS66 Stealth', 500, 'Intel Core i7-10750H', '16GB', 'NVIDIA RTX 2060', 35999990.00, NULL, 512, 15.6, 'China'),
	('msi003', 'MSI GF63 Thin', 600, 'Intel Core i5-10300H', '8GB', 'NVIDIA GTX 1650', 19999990.00, NULL, 512, 15.6, 'China'),
	('msi004', 'MSI Creator Z16', 300, 'Intel Core i9-11900H', '32GB', 'NVIDIA RTX 3060', 56999990.00, NULL, 1024, 16, 'China'),
	('msi005', 'MSI Pulse GL66', 700, 'Intel Core i7-12700H', '16GB', 'NVIDIA RTX 3060', 31999990.00, NULL, 512, 15.6, 'China'),
	('msi006', 'MSI Summit E13', 400, 'Intel Core i7-1165G7', '16GB', 'Integrated', 24999990.00, NULL, 512, 13.4, 'China'),
	('msi007', 'MSI Bravo 15', 500, 'AMD Ryzen 7 5800H', '16GB', 'Radeon RX 5500M', 23999990.00, NULL, 512, 15.6, 'China'),
	('msi008', 'MSI Modern 14', 600, 'Intel Core i5-1135G7', '8GB', 'Integrated', 17999990.00, NULL, 512, 14, 'China'),
	('msi009', 'MSI Alpha 15', 400, 'AMD Ryzen 7 4800H', '16GB', 'Radeon RX 5600M', 21999990.00, NULL, 512, 15.6, 'China'),
	('msi010', 'MSI Stealth 15M', 300, 'Intel Core i7-11375H', '16GB', 'NVIDIA RTX 3060', 29999990.00, NULL, 512, 15.6, 'China'),
	('msi011', 'MSI Laptop 1', 100, 'Intel Core i5-10210U', '8GB', 'Integrated', 15000000.00, NULL, 512, 15.6, 'China'),
	('msi012', 'MSI Laptop 2', 120, 'Intel Core i7-10710U', '16GB', 'NVIDIA GTX 1650', 25000000.00, NULL, 1024, 15.6, 'China'),
	('msi013', 'MSI Laptop 3', 150, 'AMD Ryzen 5 3600U', '8GB', 'Integrated', 16000000.00, NULL, 256, 14, 'China'),
	('msi014', 'MSI Laptop 4', 200, 'Intel Core i7-1065G7', '8GB', 'NVIDIA GTX 1660', 28000000.00, NULL, 512, 15.6, 'China'),
	('msi015', 'MSI Laptop 5', 800, 'Intel Core i5-11400H', '16GB', 'NVIDIA GeForce RTX 2060', 35000000.00, NULL, 2048, 17.3, 'China'),
	('msi016', 'MSI Laptop 6', 180, 'Intel Core i7-1185G7', '16GB', 'NVIDIA RTX 3060', 38000000.00, NULL, 512, 15.6, 'China'),
	('msi017', 'MSI Laptop 7', 100, 'Intel Core i5-10300H', '8GB', 'Integrated', 17000000.00, NULL, 256, 14, 'China'),
	('msi018', 'MSI Laptop 8', 250, 'AMD Ryzen 7 3800X', '16GB', 'NVIDIA RTX 3070', 42000000.00, NULL, 1024, 15.6, 'China'),
	('msi019', 'MSI Laptop 9', 220, 'Intel Core i7-1165G7', '8GB', 'Integrated', 23000000.00, NULL, 512, 14, 'China'),
	('msi020', 'MSI Laptop 10', 300, 'Intel Core i7-1195G7', '16GB', 'NVIDIA RTX 3050', 29000000.00, NULL, 2048, 16, 'China'),
	('msi021', 'MSI Laptop 11', 140, 'Intel Core i9-11900K', '32GB', 'NVIDIA RTX 3080', 50000000.00, NULL, 512, 15.6, 'China'),
	('msi022', 'MSI Laptop 12', 200, 'AMD Ryzen 9 5900HS', '32GB', 'NVIDIA GTX 1650', 45000000.00, NULL, 1024, 15.6, 'China'),
	('msi023', 'MSI Laptop 13', 250, 'Intel Core i5-1135G7', '8GB', 'Integrated', 20000000.00, NULL, 256, 14, 'China'),
	('msi024', 'MSI Laptop 14', 120, 'Intel Core i7-10700K', '16GB', 'NVIDIA RTX 3070', 48000000.00, NULL, 512, 15.6, 'China'),
	('msi025', 'MSI Laptop 15', 180, 'AMD Ryzen 5 3500U', '8GB', 'Integrated', 17000000.00, NULL, 256, 14, 'China'),
	('msi026', 'MSI Laptop 16', 150, 'Intel Core i9-11980HK', '32GB', 'NVIDIA RTX 3090', 60000000.00, NULL, 2048, 17.3, 'China'),
	('msi027', 'MSI Laptop 17', 220, 'Intel Core i5-11400H', '8GB', 'Integrated', 21000000.00, NULL, 512, 14, 'China'),
	('msi028', 'MSI Laptop 18', 200, 'Intel Core i7-11650U', '16GB', 'NVIDIA GTX 1650', 26000000.00, NULL, 1024, 15.6, 'China'),
	('msi029', 'MSI Laptop 19', 250, 'AMD Ryzen 7 5800X', '16GB', 'NVIDIA RTX 3080', 53000000.00, NULL, 2048, 16, 'China'),
	('msi030', 'MSI Laptop 20', 180, 'Intel Core i5-11300H', '8GB', 'Integrated', 19000000.00, NULL, 512, 14, 'China'),
	('msi031', 'MSI Laptop 21', 100, 'Intel Core i5-10300U', '8GB', 'Integrated', 16000000.00, NULL, 256, 14, 'China'),
	('msi032', 'MSI Laptop 22', 800, 'Intel Core i7-10750H', '16GB', 'NVIDIA GTX 1650', 22000000.00, NULL, 1024, 15.6, 'China'),
	('msi033', 'MSI Laptop 23', 250, 'Intel Core i7-11800H', '32GB', 'NVIDIA RTX 3060', 38000000.00, NULL, 512, 15.6, 'China'),
	('msi034', 'MSI Laptop 24', 120, 'Intel Core i9-10980XE', '32GB', 'NVIDIA RTX 3090', 60000000.00, NULL, 1024, 15.6, 'China'),
	('msi035', 'MSI Laptop 25', 180, 'Intel Core i7-11370H', '16GB', 'NVIDIA RTX 3070', 46000000.00, NULL, 512, 16, 'China'),
	('msi036', 'MSI Laptop 26', 220, 'Intel Core i5-11400H', '8GB', 'Integrated', 20000000.00, NULL, 256, 14, 'China'),
	('msi037', 'MSI Laptop 27', 300, 'AMD Ryzen 9 5900HX', '16GB', 'NVIDIA RTX 3080', 57000000.00, NULL, 2048, 17.3, 'China'),
	('msi038', 'MSI Laptop 28', 150, 'Intel Core i7-10650H', '16GB', 'NVIDIA GTX 1660', 30000000.00, NULL, 512, 15.6, 'China'),
	('msi039', 'MSI Laptop 29', 100, 'Intel Core i9-11900K', '32GB', 'NVIDIA RTX 3090', 60000000.00, NULL, 1024, 15.6, 'China'),
	('msi040', 'MSI Laptop 30', 220, 'Intel Core i5-10310U', '8GB', 'Integrated', 17000000.00, NULL, 256, 14, 'China'),
	('msi041', 'MSI Laptop 31', 180, 'Intel Core i7-1165G7', '16GB', 'Integrated', 24000000.00, NULL, 512, 14, 'China'),
	('msi042', 'MSI Laptop 32', 250, 'AMD Ryzen 5 5600X', '16GB', 'NVIDIA RTX 3060', 40000000.00, NULL, 1024, 15.6, 'China'),
	('msi043', 'MSI Laptop 33', 120, 'Intel Core i7-11650U', '8GB', 'NVIDIA GTX 1650', 22000000.00, NULL, 512, 14, 'China'),
	('msi044', 'MSI Laptop 34', 100, 'Intel Core i5-11300H', '16GB', 'NVIDIA GTX 1650', 23000000.00, NULL, 256, 14, 'China'),
	('msi045', 'MSI Laptop 35', 180, 'Intel Core i5-10600U', '8GB', 'Integrated', 18000000.00, NULL, 512, 15.6, 'China'),
	('msi046', 'MSI Laptop 36', 220, 'Intel Core i7-1190H', '16GB', 'NVIDIA RTX 3080', 52000000.00, NULL, 1024, 17.3, 'China'),
	('msi047', 'MSI Laptop 37', 800, 'Intel Core i5-10310H', '8GB', 'NVIDIA GTX 1650', 19000000.00, NULL, 256, 14, 'China'),
	('msi048', 'MSI Laptop 38', 250, 'Intel Core i9-10980XE', '32GB', 'NVIDIA RTX 3090', 65000000.00, NULL, 2048, 17.3, 'China'),
	('msi049', 'MSI Laptop 39', 150, 'AMD Ryzen 9 5900HX', '16GB', 'NVIDIA RTX 3080', 55000000.00, NULL, 1024, 15.6, 'China'),
	('msi050', 'MSI Laptop 40', 200, 'Intel Core i7-11850H', '8GB', 'NVIDIA GTX 1650', 21000000.00, NULL, 512, 14, 'China'),
	('msi051', 'MSI Laptop 41', 200, 'Intel Core i7-10610U', '8GB', 'NVIDIA GTX 1650', 21000000.00, NULL, 512, 14, 'China'),
	('msi052', 'MSI Laptop 42', 180, 'AMD Ryzen 5 3500U', '16GB', 'Integrated', 22000000.00, NULL, 256, 14, 'China'),
	('msi053', 'MSI Laptop 43', 120, 'Intel Core i5-11300H', '8GB', 'NVIDIA RTX 3060', 25000000.00, NULL, 1024, 15.6, 'China'),
	('msi054', 'MSI Laptop 44', 250, 'Intel Core i7-1165G7', '8GB', 'Integrated', 24000000.00, NULL, 512, 15.6, 'China'),
	('msi055', 'MSI Laptop 45', 220, 'Intel Core i9-11980HK', '32GB', 'NVIDIA RTX 3090', 65000000.00, NULL, 2048, 17.3, 'China'),
	('msi056', 'MSI Laptop 46', 150, 'Intel Core i5-10210U', '8GB', 'Integrated', 20000000.00, NULL, 256, 14, 'China'),
	('msi057', 'MSI Laptop 47', 100, 'Intel Core i7-10710U', '16GB', 'NVIDIA RTX 3070', 39000000.00, NULL, 512, 15.6, 'China'),
	('msi058', 'MSI Laptop 48', 200, 'Intel Core i7-1165G7', '8GB', 'NVIDIA GTX 1650', 23000000.00, NULL, 1024, 14, 'China'),
	('msi059', 'MSI Laptop 49', 180, 'Intel Core i7-1185G7', '16GB', 'NVIDIA RTX 3050', 27000000.00, NULL, 512, 15.6, 'China'),
	('msi060', 'MSI Laptop 50', 250, 'Intel Core i5-1135G7', '8GB', 'NVIDIA GTX 1650', 22000000.00, NULL, 256, 14, 'China'),
	('msi061', 'MSI Laptop 51', 220, 'Intel Core i7-10750H', '16GB', 'NVIDIA RTX 3070', 38000000.00, NULL, 1024, 15.6, 'China'),
	('msi062', 'MSI Laptop 52', 200, 'Intel Core i9-10980HK', '32GB', 'NVIDIA RTX 3080', 58000000.00, NULL, 2048, 17.3, 'China'),
	('msi063', 'MSI Laptop 53', 150, 'AMD Ryzen 5 5500U', '8GB', 'NVIDIA RTX 3060', 28000000.00, NULL, 512, 15.6, 'China'),
	('msi064', 'MSI Laptop 54', 180, 'Intel Core i7-1065G7', '16GB', 'NVIDIA GTX 1660', 32000000.00, NULL, 1024, 15.6, 'China'),
	('msi065', 'MSI Laptop 55', 220, 'Intel Core i5-10600U', '8GB', 'Integrated', 19000000.00, NULL, 256, 14, 'China'),
	('msi066', 'MSI Laptop 56', 250, 'Intel Core i7-11370H', '16GB', 'NVIDIA RTX 3080', 52000000.00, NULL, 1024, 15.6, 'China'),
	('msi067', 'MSI Laptop 57', 100, 'Intel Core i5-10300U', '8GB', 'NVIDIA GTX 1650', 20000000.00, NULL, 512, 14, 'China'),
	('msi068', 'MSI Laptop 58', 120, 'Intel Core i7-10700K', '16GB', 'NVIDIA RTX 3070', 42000000.00, NULL, 2048, 15.6, 'China'),
	('msi069', 'MSI Laptop 59', 180, 'AMD Ryzen 9 5900HX', '16GB', 'NVIDIA RTX 3080', 55000000.00, NULL, 512, 17.3, 'China'),
	('msi070', 'MSI Laptop 60', 250, 'Intel Core i9-10980XE', '32GB', 'NVIDIA RTX 3090', 65000000.00, NULL, 2048, 17.3, 'China'),
	('msi071', 'MSI Laptop 61', 200, 'Intel Core i7-11800H', '16GB', 'NVIDIA RTX 3070', 42000000.00, NULL, 1024, 15.6, 'China'),
	('msi072', 'MSI Laptop 62', 220, 'Intel Core i5-11400H', '8GB', 'NVIDIA GTX 1650', 21000000.00, NULL, 512, 14, 'China'),
	('msi073', 'MSI Laptop 63', 180, 'Intel Core i9-10900K', '32GB', 'NVIDIA RTX 3080', 60000000.00, NULL, 1024, 15.6, 'China'),
	('msi074', 'MSI Laptop 64', 120, 'AMD Ryzen 5 3600X', '16GB', 'NVIDIA RTX 3070', 45000000.00, NULL, 512, 15.6, 'China'),
	('msi075', 'MSI Laptop 65', 800, 'Intel Core i7-11850H', '32GB', 'NVIDIA RTX 3090', 65000000.00, NULL, 2048, 17.3, 'China'),
	('msi076', 'MSI Laptop 66', 150, 'Intel Core i9-10850K', '16GB', 'NVIDIA RTX 3060', 40000000.00, NULL, 1024, 15.6, 'China'),
	('msi077', 'MSI Laptop 67', 180, 'Intel Core i5-11300H', '8GB', 'NVIDIA GTX 1650', 19000000.00, NULL, 256, 14, 'China'),
	('msi078', 'MSI Laptop 68', 250, 'Intel Core i7-1065G7', '16GB', 'Integrated', 24000000.00, NULL, 512, 14, 'China'),
	('msi079', 'MSI Laptop 69', 120, 'Intel Core i9-11900K', '32GB', 'NVIDIA RTX 3070', 55000000.00, NULL, 2048, 15.6, 'China'),
	('msi080', 'MSI Laptop 70', 200, 'AMD Ryzen 9 5900HX', '16GB', 'NVIDIA RTX 3080', 53000000.00, NULL, 1024, 16, 'China'),
	('msi081', 'MSI Laptop 71', 220, 'Intel Core i7-1165G7', '8GB', 'NVIDIA GTX 1650', 21000000.00, NULL, 512, 14, 'China'),
	('msi082', 'MSI Laptop 72', 100, 'Intel Core i5-10400H', '8GB', 'Integrated', 17000000.00, NULL, 256, 14, 'China'),
	('msi083', 'MSI Laptop 73', 180, 'Intel Core i9-10850K', '16GB', 'NVIDIA RTX 3060', 38000000.00, NULL, 1024, 15.6, 'China'),
	('msi084', 'MSI Laptop 74', 250, 'Intel Core i7-11370H', '8GB', 'NVIDIA RTX 3070', 42000000.00, NULL, 512, 15.6, 'China'),
	('msi085', 'MSI Laptop 75', 200, 'Intel Core i5-11500H', '16GB', 'NVIDIA GTX 1660', 33000000.00, NULL, 1024, 15.6, 'China'),
	('msi086', 'MSI Laptop 76', 100, 'Intel Core i9-10980HK', '32GB', 'NVIDIA RTX 3090', 64000000.00, NULL, 2048, 17.3, 'China'),
	('msi087', 'MSI Laptop 77', 180, 'Intel Core i5-11400H', '8GB', 'NVIDIA GTX 1650', 22000000.00, NULL, 512, 14, 'China'),
	('msi088', 'MSI Laptop 78', 220, 'Intel Core i7-11650H', '16GB', 'NVIDIA RTX 3080', 50000000.00, NULL, 1024, 15.6, 'China'),
	('msi089', 'MSI Laptop 79', 150, 'AMD Ryzen 7 5800X', '32GB', 'NVIDIA RTX 3080', 55000000.00, NULL, 2048, 17.3, 'China'),
	('msi090', 'MSI Laptop 80', 120, 'Intel Core i5-10400U', '8GB', 'NVIDIA GTX 1650', 21000000.00, NULL, 512, 14, 'China'),
	('msi091', 'MSI Laptop 81', 200, 'Intel Core i9-11900K', '16GB', 'NVIDIA RTX 3070', 49000000.00, NULL, 1024, 15.6, 'China'),
	('msi092', 'MSI Laptop 82', 220, 'Intel Core i7-10700K', '32GB', 'NVIDIA RTX 3080', 60000000.00, NULL, 2048, 17.3, 'China'),
	('msi093', 'MSI Laptop 83', 180, 'Intel Core i5-10600U', '16GB', 'Integrated', 26000000.00, NULL, 512, 15.6, 'China'),
	('msi094', 'MSI Laptop 84', 120, 'Intel Core i7-11600K', '8GB', 'NVIDIA GTX 1660', 32000000.00, NULL, 1024, 15.6, 'China'),
	('msi095', 'MSI Laptop 85', 200, 'AMD Ryzen 5 3500X', '8GB', 'NVIDIA GTX 1650', 23000000.00, NULL, 512, 14, 'China'),
	('msi096', 'MSI Laptop 86', 250, 'Intel Core i7-10750H', '16GB', 'NVIDIA RTX 3070', 41000000.00, NULL, 1024, 15.6, 'China'),
	('msi097', 'MSI Laptop 87', 150, 'Intel Core i9-11980H', '8GB', 'NVIDIA RTX 3080', 60000000.00, NULL, 2048, 17.3, 'China'),
	('msi098', 'MSI Laptop 88', 200, 'Intel Core i7-11800H', '32GB', 'NVIDIA RTX 3070', 48000000.00, NULL, 1024, 15.6, 'China'),
	('msi099', 'MSI Laptop 89', 120, 'Intel Core i5-10600U', '8GB', 'NVIDIA GTX 1650', 19000000.00, NULL, 512, 14, 'China'),
	('msi100', 'MSI Laptop 90', 100, 'Intel Core i9-10850K', '16GB', 'NVIDIA RTX 3090', 65000000.00, NULL, 2048, 17.3, 'China'),
	('sur011', 'Surface Pro 7', 100, 'Intel Core i5-1035G4', '8GB', 'Integrated', 20000000.00, NULL, 128, 12.3, 'USA'),
	('sur012', 'Surface Laptop 3', 800, 'AMD Ryzen 5 3580U', '8GB', 'Integrated', 22000000.00, NULL, 256, 13.5, 'USA'),
	('sur013', 'Surface Book 3', 500, 'Intel Core i7-1065G7', '16GB', 'NVIDIA GeForce GTX 1650', 35000000.00, NULL, 512, 15, 'USA'),
	('sur014', 'Surface Go 2', 120, 'Intel Pentium Gold 4425Y', '4GB', 'Integrated', 12000000.00, NULL, 64, 10.5, 'USA'),
	('sur015', 'Surface Pro X', 700, 'Microsoft SQ1', '8GB', 'Integrated', 25000000.00, NULL, 128, 13, 'USA'),
	('sur016', 'Surface Laptop Go', 150, 'Intel Core i5-1035G1', '8GB', 'Integrated', 18000000.00, NULL, 128, 12.4, 'USA'),
	('sur017', 'Surface Laptop 4', 900, 'Intel Core i7-1185G7', '16GB', 'Integrated', 30000000.00, NULL, 512, 13.5, 'USA'),
	('sur018', 'Surface Pro 8', 600, 'Intel Core i5-1135G7', '8GB', 'Integrated', 24000000.00, NULL, 256, 13, 'USA'),
	('sur019', 'Surface Go 3', 140, 'Intel Pentium Gold 6500Y', '4GB', 'Integrated', 13000000.00, NULL, 64, 10.5, 'USA'),
	('sur020', 'Surface Laptop Studio', 400, 'Intel Core i7-11370H', '16GB', 'NVIDIA GeForce RTX 3050 Ti', 40000000.00, NULL, 512, 14.4, 'USA'),
	('sur021', 'Surface Pro 9', 100, 'Intel Core i5-1235U', '8GB', 'Integrated', 26000000.00, NULL, 256, 13, 'USA'),
	('sur022', 'Surface Laptop 5', 800, 'Intel Core i7-1265U', '16GB', 'Integrated', 32000000.00, NULL, 512, 13.5, 'USA'),
	('sur023', 'Surface Go 4', 120, 'Intel Pentium Gold 8500Y', '4GB', 'Integrated', 14000000.00, NULL, 64, 10.5, 'USA'),
	('sur024', 'Surface Pro X2', 700, 'Microsoft SQ2', '8GB', 'Integrated', 27000000.00, NULL, 128, 13, 'USA'),
	('sur025', 'Surface Laptop Go 2', 150, 'Intel Core i5-1135G7', '8GB', 'Integrated', 19000000.00, NULL, 128, 12.4, 'USA'),
	('sur026', 'Surface Book 4', 500, 'Intel Core i7-1165G7', '16GB', 'NVIDIA GeForce GTX 1660', 36000000.00, NULL, 512, 15, 'USA'),
	('sur027', 'Surface Laptop Studio 2', 400, 'Intel Core i7-11375H', '16GB', 'NVIDIA GeForce RTX 3060', 41000000.00, NULL, 512, 14.4, 'USA'),
	('sur028', 'Surface Pro 10', 600, 'Intel Core i5-1255U', '8GB', 'Integrated', 25000000.00, NULL, 256, 13, 'USA'),
	('sur029', 'Surface Laptop 6', 900, 'Intel Core i7-1275U', '16GB', 'Integrated', 33000000.00, NULL, 512, 13.5, 'USA'),
	('sur030', 'Surface Go 5', 140, 'Intel Pentium Gold 9500Y', '4GB', 'Integrated', 15000000.00, NULL, 64, 10.5, 'USA'),
	('sur031', 'Surface Laptop 31', 100, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 22000000.00, NULL, 256, 13.5, 'USA'),
	('sur032', 'Surface Laptop 32', 150, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur033', 'Surface Laptop 33', 180, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 256, 13.5, 'USA'),
	('sur034', 'Surface Laptop 34', 220, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur035', 'Surface Laptop 35', 120, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur036', 'Surface Laptop 36', 200, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 36000000.00, NULL, 512, 13.5, 'USA'),
	('sur037', 'Surface Laptop 37', 180, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 27000000.00, NULL, 512, 13.5, 'USA'),
	('sur038', 'Surface Laptop 38', 220, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 13.5, 'USA'),
	('sur039', 'Surface Laptop 39', 250, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur040', 'Surface Laptop 40', 100, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 256, 13.5, 'USA'),
	('sur041', 'Surface Laptop 41', 120, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur042', 'Surface Laptop 42', 150, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 22000000.00, NULL, 256, 13.5, 'USA'),
	('sur043', 'Surface Laptop 43', 180, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 13.5, 'USA'),
	('sur044', 'Surface Laptop 44', 200, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 256, 13.5, 'USA'),
	('sur045', 'Surface Laptop 45', 250, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 36000000.00, NULL, 512, 13.5, 'USA'),
	('sur046', 'Surface Laptop 46', 220, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur047', 'Surface Laptop 47', 150, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur048', 'Surface Laptop 48', 120, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur049', 'Surface Laptop 49', 180, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 512, 13.5, 'USA'),
	('sur050', 'Surface Laptop 50', 200, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur051', 'Surface Laptop 51', 100, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur052', 'Surface Laptop 52', 150, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur053', 'Surface Laptop 53', 180, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 22000000.00, NULL, 256, 13.5, 'USA'),
	('sur054', 'Surface Laptop 54', 220, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur055', 'Surface Laptop 55', 120, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 256, 13.5, 'USA'),
	('sur056', 'Surface Laptop 56', 150, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur057', 'Surface Laptop 57', 100, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur058', 'Surface Laptop 58', 180, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 512, 13.5, 'USA'),
	('sur059', 'Surface Laptop 59', 220, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur060', 'Surface Laptop 60', 250, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur061', 'Surface Laptop 61', 120, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 256, 13.5, 'USA'),
	('sur062', 'Surface Laptop 62', 150, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur063', 'Surface Laptop 63', 200, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur064', 'Surface Laptop 64', 100, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 13.5, 'USA'),
	('sur065', 'Surface Laptop 65', 180, 'Intel Core i5-1065G7', '8GB', 'Intel Iris Plus', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur066', 'Surface Laptop 66', 150, 'Intel Core i7-1135G7', '16GB', 'Intel Iris Xe', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur067', 'Surface Laptop 67', 200, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 26000000.00, NULL, 256, 13.5, 'USA'),
	('sur068', 'Surface Laptop 68', 120, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 36000000.00, NULL, 512, 13.5, 'USA'),
	('sur069', 'Surface Laptop 69', 250, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur070', 'Surface Laptop 70', 220, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 512, 13.5, 'USA'),
	('sur071', 'Surface Laptop 71', 180, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur072', 'Surface Laptop 72', 100, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur073', 'Surface Laptop 73', 150, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur074', 'Surface Laptop 74', 180, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur075', 'Surface Laptop 75', 200, 'Intel Core i5-1065G7', '8GB', 'Intel Iris Plus', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur076', 'Surface Laptop 76', 100, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 13.5, 'USA'),
	('sur077', 'Surface Laptop 77', 180, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 256, 13.5, 'USA'),
	('sur078', 'Surface Laptop 78', 150, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur079', 'Surface Laptop 79', 220, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 26000000.00, NULL, 256, 13.5, 'USA'),
	('sur080', 'Surface Laptop 80', 120, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur081', 'Surface Laptop 81', 250, 'Intel Core i5-1065G7', '8GB', 'Intel Iris Plus', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur082', 'Surface Laptop 82', 180, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 512, 13.5, 'USA'),
	('sur083', 'Surface Laptop 83', 220, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur084', 'Surface Laptop 84', 200, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur085', 'Surface Laptop 85', 120, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur086', 'Surface Laptop 86', 150, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur087', 'Surface Laptop 87', 180, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 26000000.00, NULL, 256, 13.5, 'USA'),
	('sur088', 'Surface Laptop 88', 220, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 42000000.00, NULL, 512, 13.5, 'USA'),
	('sur089', 'Surface Laptop 89', 200, 'Intel Core i5-1065G7', '8GB', 'Intel Iris Plus', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur090', 'Surface Laptop 90', 150, 'Intel Core i7-1165G7', '16GB', 'Intel Iris Xe', 38000000.00, NULL, 512, 13.5, 'USA'),
	('sur091', 'Surface Laptop 91', 100, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 24000000.00, NULL, 256, 13.5, 'USA'),
	('sur092', 'Surface Laptop 92', 180, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur093', 'Surface Laptop 93', 250, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur094', 'Surface Laptop 94', 220, 'Intel Core i7-1135G7', '16GB', 'Intel Iris Xe', 36000000.00, NULL, 512, 13.5, 'USA'),
	('sur095', 'Surface Laptop 95', 100, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 13.5, 'USA'),
	('sur096', 'Surface Laptop 96', 120, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 256, 13.5, 'USA'),
	('sur097', 'Surface Laptop 97', 180, 'Intel Core i7-1065G7', '16GB', 'Intel Iris Plus', 35000000.00, NULL, 512, 13.5, 'USA'),
	('sur098', 'Surface Laptop 98', 250, 'Intel Core i5-10210U', '8GB', 'Intel UHD', 23000000.00, NULL, 256, 13.5, 'USA'),
	('sur099', 'Surface Laptop 99', 150, 'Intel Core i7-1185G7', '16GB', 'Intel Iris Xe', 40000000.00, NULL, 512, 13.5, 'USA'),
	('sur100', 'Surface Laptop 100', 120, 'Intel Core i5-1135G7', '8GB', 'Intel Iris Xe', 25000000.00, NULL, 256, 13.5, 'USA');

CREATE TABLE IF NOT EXISTS `NhaCungCap` (
  `MaNCC` varchar(50) NOT NULL,
  `TenNCC` varchar(50) DEFAULT NULL,
  `SDT` varchar(11) DEFAULT NULL,
  `diaChi` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`MaNCC`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_vietnamese_ci;

INSERT INTO `NhaCungCap` (`MaNCC`, `TenNCC`, `SDT`, `diaChi`) VALUES
	('ANPHAT', 'CTy TNHH Điều Khiển Tự Động An Phát', '0283510973', '86/21 Phan Tây Hồ, P. 7, Q. Phú Nhuận TP. Hồ Chí Minh'),
	('CODO', 'CTy TNHH Thương Mại Dịch Vụ Hoàng Cố Đô', '0283811534', '622/16/5 Cộng Hòa, Phường 13, Quận Tân Bình, TP HCM		'),
	('FPT', 'CTy Cổ Phần Bán Lẻ Kỹ Thuật Số FPT', '0287302345', '261 - 263 Khánh Hội, P2, Q4, TP. Hồ Chí Minh'),
	('HACOM', 'CTy Cổ phần đầu tư công nghệ HACOM', '1900 1903', 'Số 129 - 131, phố Lê Thanh Nghị, Phường Đồng Tâm, Quận Hai Bà Trưng, Hà Nội'),
	('HOANGPHAT', 'CTy TNHH Thương Mại Hoàng Phát Hải Phòng', '0225325088', 'Số 4, Lô 2A Lê Hồng Phong, Ngô Quyền, Tp. Hải Phòng'),
	('NGUYENTAN', 'CTy TNHH MÁY TÍNH NGUYỄN TÂN', '0903602240', '1/29 Vũ Hồng Phô, Phường Bình Đa, Biên Hòa - Đồng Nai'),
	('PHONGVU', 'CTy cổ phần dịch vụ - thương mại Phong Vũ', '0967567567', 'Tầng 5, Số 117-119-121 Nguyễn Du, Phường Bến Thành, Quận 1, Thành Phố Hồ Chí Minh'),
	('TGDĐ', 'CTy cổ phần Thế Giới Di Động', '0283812590', '128 Trần Quang Khải, P. Tân Định, Q.1, TP.Hồ Chí Minh'),
	('VIETSTARS', 'CTy CP Công nghệ Thương mại Dịch vụ Vietstars', '0904690209', ' Số 109 Lê Thanh Nghị  TP Hải dương');

CREATE TABLE IF NOT EXISTS `PhieuNhap` (
  `maPhieu` varchar(50) NOT NULL,
  `thoiGianTao` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `nguoiTao` varchar(50) DEFAULT NULL,
  `maNhaCungCap` varchar(50) NOT NULL,
  `tongTien` double DEFAULT NULL,
  PRIMARY KEY (`maPhieu`),
  KEY `FK_PhieuNhap_NhaCungCap` (`maNhaCungCap`),
  KEY `FK_PhieuNhap_Admins` (`nguoiTao`),
  CONSTRAINT `FK_PhieuNhap_Admins` FOREIGN KEY (`nguoiTao`) REFERENCES `Admins` (`username`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_PhieuNhap_NhaCungCap` FOREIGN KEY (`maNhaCungCap`) REFERENCES `NhaCungCap` (`MaNCC`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_vietnamese_ci;

INSERT INTO `PhieuNhap` (`maPhieu`, `thoiGianTao`, `nguoiTao`, `maNhaCungCap`, `tongTien`) VALUES
	('PN01', '2024-09-24 19:10:12', 'tribui106', 'FPT', 129999950),
	('PN02', '2024-09-24 17:00:00', 'a', 'FPT', 10000000000000),
	('PN03', '2024-09-24 19:10:12', 'tribui106', 'FPT', 37999980),
	('PN04', '2024-09-24 19:10:12', 'tribui106', 'TGDĐ', 99999960),
	('PN05', '2024-09-24 19:10:12', 'tribui106', 'FPT', 107999940),
	('PN06', '2024-09-24 17:00:00', 'congdanh', 'FPT', 17400000000),
	('PN07', '2024-09-24 19:10:12', 'tribui106', 'PHONGVU', 51999980),
	('PN08', '2024-09-24 19:10:12', 'tribui106', 'FPT', 94999950),
	('PN09', '2024-09-24 19:10:12', 'tribui106', 'FPT', 74999970),
	('PN10', '2024-09-24 19:10:12', 'tribui106', 'HOANGPHAT', 71999960),
	('PN11', '2024-09-24 19:10:12', 'tribui106', 'FPT', 149999940),
	('PN12', '2024-09-24 19:10:12', 'tribui106', 'HACOM', 25999990),
	('PN13', '2024-09-24 19:10:12', 'tribui106', 'PHONGVU', 56999970),
	('PN14', '2024-09-24 19:10:12', 'tribui106', 'FPT', 124999950),
	('PN15', '2024-09-24 19:10:12', 'tribui106', 'FPT', 125999930),
	('PN16', '2024-09-24 19:10:12', 'tribui106', 'HOANGPHAT', 49999980),
	('PN17', '2024-09-24 19:10:12', 'tribui106', 'FPT', 103999960),
	('PN18', '2024-09-24 19:10:12', 'tribui106', 'FPT', 113999940),
	('PN19', '2024-09-24 19:10:12', 'tribui106', 'PHONGVU', 199999920),
	('PN20', '2024-09-24 19:10:12', 'tribui106', 'PHONGVU', 53999970),
	('PN21', '2024-09-24 19:10:12', 'tribui106', 'PHONGVU', NULL),
	('PN22', '2024-09-24 19:10:12', 'tribui106', 'FPT', NULL),
	('PN23', '2024-09-24 19:10:12', 'tribui106', 'FPT', NULL),
	('PN24', '2024-09-24 19:10:12', 'tribui106', 'FPT', NULL),
	('PN25', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN26', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN27', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN28', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN29', '2024-09-24 19:10:12', 'tribui106', 'CODO', NULL),
	('PN30', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN31', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN32', '2024-09-24 19:10:12', 'tribui106', 'HOANGPHAT', NULL),
	('PN33', '2024-09-24 19:10:12', 'tribui106', 'VIETSTARS', NULL),
	('PN34', '2024-09-24 19:10:12', 'tribui106', 'HOANGPHAT', NULL),
	('PN35', '2024-09-24 19:10:12', 'tribui106', 'HOANGPHAT', NULL),
	('PN36', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN37', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN38', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', NULL),
	('PN39', '2024-09-24 19:10:12', 'tribui106', 'FPT', NULL),
	('PN40', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', 1216999350),
	('PN41', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', 1109699750),
	('PN42', '2024-09-24 19:10:12', 'tribui106', 'TGDĐ', 2051639420),
	('PN43', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', 3808150000),
	('PN44', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', 5247500000),
	('PN45', '2024-09-24 19:10:12', 'tribui106', 'ANPHAT', 1375220000),
	('PN46', '2024-09-30 19:10:12', 'tribui106', 'ANPHAT', 983459770),
	('PN47', '2024-09-30 19:10:12', 'tribui106', 'ANPHAT', 649999750),
	('PN48', '2024-09-30 19:10:12', 'vuhau', 'ANPHAT', 946810000),
	('PN49', '2024-09-30 19:10:12', 'vuhau', 'ANPHAT', 1449749550),
	('PN50', '2024-09-30 19:10:12', 'vuhau', 'ANPHAT', 162250000),
	('PN51', '2024-09-30 19:10:12', 'vuhau', 'ANPHAT', 2298749750),
	('PN52', '2024-09-30 19:10:12', 'vuhau', 'ANPHAT', 2603998760),
	('PN53', '2024-11-29 19:24:24', 'vuhau', 'ANPHAT', 824999750),
	('PN54', '2024-11-29 19:24:25', 'vuhau', 'ANPHAT', 199750000),
	('PN55', '2024-11-29 19:24:23', 'vuhau', 'ANPHAT', 6575280000),
	('PN56', '2024-11-29 19:24:31', 'tribui106', 'ANPHAT', 41999980),
	('PN57', '2024-11-29 19:24:31', 'tribui106', 'ANPHAT', 5632229750),
	('PN58', '2024-11-29 19:24:30', 'tribui106', 'ANPHAT', 10731540000),
	('PN59', '2024-11-29 19:16:33', 'tribui106', 'ANPHAT', 19499380000),
	('PN60', '2024-11-29 19:14:39', 'tribui106', 'ANPHAT', 1491432454),
	('PN61', '2024-11-29 19:24:10', 'thientq8', 'ANPHAT', 4298470000),
	('PN62', '2024-12-01 14:23:19', 'a', 'ANPHAT', 29999980),
	('PN63', '2024-12-01 17:35:57', 'tribui106', 'ANPHAT', 743999690),
	('PN64', '2024-12-01 17:43:56', 'tribui106', 'ANPHAT', 424750000),
	('PN65', '2024-12-01 17:44:19', 'tribui106', 'ANPHAT', 649999750),
	('PN66', '2024-12-01 17:49:26', 'tribui106', 'FPT', NULL),
	('PN67', '2024-12-01 17:52:30', 'tribui106', 'ANPHAT', 824999750),
	('PN68', '2024-12-01 17:56:29', 'tribui106', 'ANPHAT', 230999890),
	('PN69', '2024-12-05 01:28:15', 'tribui106', 'ANPHAT', 4823997990),
	('PN70', '2024-12-05 01:29:09', 'tribui106', 'ANPHAT', 6846779590),
	('PN71', '2024-12-11 02:22:14', 'vuhau', 'ANPHAT', 8999997000),
	('PN72', '2024-12-11 04:05:00', 'tribui106', 'ANPHAT', 8083997300),
	('PN73', '2024-12-11 04:05:32', 'tribui106', 'ANPHAT', 239900000),
	('PN74', '2024-12-11 04:07:16', 'tribui106', 'ANPHAT', 959600000),
	('PN75', '2024-12-11 04:07:49', 'tribui106', 'ANPHAT', 1199500000),
	('PN76', '2025-01-10 03:03:41', 'duycuong', 'FPT', 23999990),
	('PN77', '2025-01-10 03:04:22', 'duycuong', 'FPT', 1006729990),
	('PN78', '2025-03-05 02:55:19', 'zenng', 'ANPHAT', 274999850),
	('PN79', '2025-03-05 02:56:21', 'zenng', 'ANPHAT', 2499999000);

CREATE TABLE IF NOT EXISTS `PhieuXuat` (
  `maPhieu` varchar(50) NOT NULL,
  `thoiGianTao` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `nguoiTao` varchar(50) DEFAULT NULL,
  `tongTien` double DEFAULT NULL,
  PRIMARY KEY (`maPhieu`),
  KEY `FK_PhieuXuat_Admins` (`nguoiTao`),
  CONSTRAINT `FK_PhieuXuat_Admins` FOREIGN KEY (`nguoiTao`) REFERENCES `Admins` (`username`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_vietnamese_ci;

INSERT INTO `PhieuXuat` (`maPhieu`, `thoiGianTao`, `nguoiTao`, `tongTien`) VALUES
	('PX01', '2024-11-05 17:00:00', 'tribui106', 291860000),
	('PX02', '2024-11-06 11:02:21', 'tribui106', 70660000),
	('PX03', '2024-11-06 11:02:25', 'tribui106', 89350000),
	('PX04', '2024-11-06 11:02:27', 'tribui106', 58170000),
	('PX05', '2024-11-06 11:02:30', 'tribui106', 85250000),
	('PX06', '2024-11-06 11:02:34', 'tribui106', 71460000),
	('PX07', '2024-11-06 11:02:36', 'tribui106', 52370000),
	('PX08', '2024-11-06 11:02:38', 'tribui106', 39880000),
	('PX09', '2024-11-06 11:02:41', 'tribui106', 36680000),
	('PX10', '2024-11-06 10:59:00', 'tribui106', 57160000),
	('PX12', '2024-11-06 10:59:00', 'tribui106', 45370000),
	('PX13', '2024-11-06 10:59:00', 'tribui106', 109420000),
	('PX14', '2024-11-06 10:59:00', 'tribui106', 78650000),
	('PX15', '2024-11-06 10:59:00', 'tribui106', 86850000),
	('PX16', '2024-11-06 10:59:00', 'tribui106', 136740000),
	('PX17', '2024-11-06 10:59:00', 'tribui106', 51980000),
	('PX18', '2024-11-06 10:59:00', 'tribui106', 151730000),
	('PX19', '2024-11-06 10:59:00', 'tribui106', 59360000),
	('PX20', '2024-11-06 10:59:00', 'tribui106', 79140000),
	('PX21', '2024-11-06 10:59:00', 'tribui106', 60850000),
	('PX22', '2024-11-06 10:59:00', 'tribui106', 35780000),
	('PX23', '2024-11-06 10:59:00', 'tribui106', 41460000),
	('PX24', '2024-11-06 10:59:00', 'tribui106', 63360000),
	('PX25', '2024-11-06 10:59:00', 'tribui106', 92550000),
	('PX26', '2024-11-06 10:59:00', 'tribui106', 94760000),
	('PX27', '2024-12-01 02:24:45', 'congdanh', 249999900),
	('PX28', '2024-12-01 17:32:59', 'tribui106', 2321359400),
	('PX29', '2024-12-01 17:33:35', 'tribui106', 649999750),
	('PX30', '2024-12-01 17:00:00', 'a', 94950000),
	('PX31', '2024-12-02 16:51:04', 'a', 164999900),
	('PX32', '2024-12-02 16:51:06', 'a', 0),
	('PX33', '2024-12-03 00:47:14', 'a', 432999740),
	('PX34', '2024-12-03 00:47:15', 'a', 0),
	('PX35', '2024-12-03 00:49:52', 'a', 209999900),
	('PX36', '2024-12-03 00:49:54', 'a', 0),
	('PX37', '2024-12-03 00:56:28', 'congdanh', 309839980),
	('PX38', '2024-12-04 11:56:10', 'tribui106', 424750000),
	('PX39', '2024-12-04 12:14:50', 'tribui106', 898690000),
	('PX40', '2024-12-04 12:16:41', 'tribui106', 594650000),
	('PX41', '2024-12-10 09:31:58', 'a', 1845619540),
	('PX42', '2024-12-10 09:33:36', 'a', 1109749590),
	('PX43', '2024-12-09 17:00:00', 'a', 0),
	('PX44', '2024-12-10 11:51:51', 'a', 579999810),
	('PX45', '2024-12-10 17:48:49', 'a', 1159600000),
	('PX46', '2024-12-10 17:50:01', 'a', 2493949750),
	('PX47', '2024-12-10 17:50:49', 'tribui106', 2368700000),
	('PX48', '2024-12-10 17:52:01', 'tribui106', 8350120000),
	('PX49', '2024-12-11 02:10:07', 'a', 2249999000),
	('PX50', '2024-12-11 03:02:47', 'vuhau', 3699000000),
	('PX51', '2024-12-11 04:04:12', 'tribui106', 4798000000),
	('PX52', '2024-12-11 19:44:20', 'a', 11225000000),
	('PX53', '2024-12-13 07:07:25', 'tribui106', 1003809640),
	('PX54', '2025-03-05 03:52:22', 'b', 270000000),
	('PX55', '2025-04-01 16:50:07', 'tribui106', 8399796800);

DELIMITER //
CREATE PROCEDURE `search_ThongKe_MayTinh`(
	IN `input` VARCHAR(100)
)
BEGIN
	SELECT 
        mt.maMay, 
        mt.tenMay, 
        COUNT(ctpn.maMay) AS SoLuongNhap, 
        COUNT(ctpx.maMay) AS SoLuongXuat
    FROM MayTinh mt
    LEFT JOIN ChiTietPhieuNhap ctpn ON mt.maMay = ctpn.maMay
    LEFT JOIN ChiTietPhieuXuat ctpx ON mt.maMay = ctpx.maMay
    WHERE mt.maMay LIKE CONCAT('%', input, '%') 
       OR mt.tenMay LIKE CONCAT('%', input, '%')
    GROUP BY mt.maMay, mt.tenMay;
END//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `set_tt_PN_equals_sumCTPN`(
	IN `maPhieuInput` VARCHAR(50)
)
BEGIN
	UPDATE PhieuNhap
    SET tongTien = (
        SELECT SUM(tongTien)
        FROM ChiTietPhieuNhap
        WHERE maPhieu = maPhieuInput
    )
    WHERE maPhieu = maPhieuInput;
END//
DELIMITER ;

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='';
DELIMITER //
CREATE TRIGGER `CTPN_Insert` BEFORE INSERT ON `ChiTietPhieuNhap` FOR EACH ROW BEGIN
   SET NEW.tongTien = NEW.soLuong * NEW.donGia;
   UPDATE MayTinh
   SET soLuong = soLuong + NEW.soLuong
   WHERE maMay = NEW.maMay;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='';
DELIMITER //
CREATE TRIGGER `CTPX_Insert` BEFORE INSERT ON `ChiTietPhieuXuat` FOR EACH ROW 
BEGIN
   SET NEW.tongTien = NEW.soLuong * NEW.donGia;
   UPDATE MayTinh
   SET soLuong = soLuong - NEW.soLuong
   WHERE maMay = NEW.maMay;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='IGNORE_SPACE';
DELIMITER //
CREATE TRIGGER `deletePhieuNhap`
    BEFORE DELETE
    ON PhieuNhap
    FOR EACH ROW
BEGIN
    DELETE FROM ChiTietPhieuNhap
    WHERE old.maPhieu = ChiTietPhieuNhap.maPhieu;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='IGNORE_SPACE';
DELIMITER //
CREATE TRIGGER `deletePhieuXuat`
    BEFORE DELETE
    ON PhieuXuat
    FOR EACH ROW
BEGIN
    DELETE FROM ChiTietPhieuXuat
    WHERE old.maPhieu = ChiTietPhieuXuat.maPhieu;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

DROP TABLE IF EXISTS `get_all_pn_px`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `get_all_pn_px` AS select `PhieuNhap`.`maPhieu` AS `maPhieu`,`PhieuNhap`.`nguoiTao` AS `nguoiTao`,`PhieuNhap`.`thoiGianTao` AS `thoiGianTao`,`PhieuNhap`.`tongTien` AS `tongTien` from `PhieuNhap` union select `PhieuXuat`.`maPhieu` AS `maPhieu`,`PhieuXuat`.`nguoiTao` AS `nguoiTao`,`PhieuXuat`.`thoiGianTao` AS `thoiGianTao`,`PhieuXuat`.`tongTien` AS `tongTien` from `PhieuXuat`
;

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;