-- Table structure for table `order_m`
--

CREATE TABLE `order_m` (
  `ord_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `ord_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ord_date2` datetime DEFAULT NULL,
  `mb_no` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `mb_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `jit_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tel_send` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `send_method` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `add_send` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `pv_month` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `pv_month2` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `remark` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `io_kind` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `order_kind` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `week_no` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `jit_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `currency` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `country_id` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `sn` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `order_pv` double DEFAULT NULL,
  `order_money` double DEFAULT NULL,
  `total_pv` double DEFAULT NULL,
  `total_money` double DEFAULT NULL,
  `total_paid_money` double DEFAULT NULL,
  `invoice_no` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `invoice_date` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `update_user` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `data_timestamp` int DEFAULT NULL,
  `send_money` double DEFAULT '0',
  `update_state` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `reserve` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `reserve_unit` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `reserve_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ord_m_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `reason` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ps` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `deduct` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `memo` text CHARACTER SET utf8 COLLATE utf8_bin,
  `memo2` text CHARACTER SET utf8 COLLATE utf8_bin,
  `ord_state` smallint DEFAULT '0',
  `boss_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `service_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT 'TWS001',
  `chk_yn` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT 'n',
  `name_send` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '收貨人',
  `verify` int DEFAULT '1' COMMENT '0-未核單1-已核單',
  `verify_date` datetime DEFAULT NULL,
  `confirm` float DEFAULT '1' COMMENT '訂單確認',
  `mail_send` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '收件人的email',
  `sub_no` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '業績歸屬(站長編號)',
  `sub_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '業績歸屬(站長姓名)',
  `b_tax_oym` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '營業稅-發票開立年月',
  `b_tax_oform` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '-1' COMMENT '營業稅-發票格式',
  `b_tax_okind` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '-1' COMMENT '營業稅-課稅別',
  `b_tax_omoney` double DEFAULT '0' COMMENT '營業稅-銷售金額',
  `b_tax_otax` double DEFAULT '0' COMMENT '營業稅-營業稅額',
  `b_tax_ocf` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '營業稅-其他憑證',
  `ensure` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `create_date` datetime DEFAULT NULL,
  `create_user` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `outmode` int DEFAULT '0',
  `send_time` int DEFAULT '0',
  PRIMARY KEY (`ord_no`),
  KEY `Inx_mb_no` (`mb_no`),
  KEY `pv_month` (`pv_month`),
  KEY `Inx_io_kind` (`io_kind`) /*!80000 INVISIBLE */,
  KEY `Inx_ord_date` (`ord_date`),
  KEY `Inx_country_id` (`country_id`),
  KEY `Inx_jit_no` (`jit_no`),
  KEY `inx_crtUsr` (`create_user`) /*!80000 INVISIBLE */
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `order_m`
--
-- WHERE:  ord_date2>='2025-01-21' and mb_no like 'V%'

INSERT INTO `order_m` VALUES ('20250121V0014','1737388800','2025-01-21 00:00:00','V8808920','NGUYEN THI HA   阮氏霞','V01','0869780179','1','DAK RU - DAK RLAP - DAK NONG .','202501',NULL,NULL,'1','4','','V01',NULL,'V','',100,3700000,100,3700000,3700000,'','','Caiyu',1737434893,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA MUA HANG ( 1 BO FIT AUTOSHIP) L3K4 HOA','',0,'245467788','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:42:02','Caiyu',1,0),('20250121V0024','1737388800','2025-01-21 00:00:00','V8809731','PHẠM THẾ DUYỆT 范世阅','V01','0902693799','1','20 LÔ F ,T XÁ -NHỊ THIÊN DƯƠNG,P5 QUÂN 8,TP HỒ CHÍ MINH ','202501',NULL,NULL,'1','2','','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Caiyu',1737439761,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA MUA HANG ( 1 SET DAM 6 2   DAU TAY TRANG) HOA','',0,'025918250','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 14:07:01','Caiyu',1,0),('20250121V0005','1737388800','2025-01-21 00:00:00','V8812041','HOÀNG SỸ THÙY 皇士垂','V01','0913293008','1','39 CỬA TẢ - P BA ĐÌNH - TP THANH HÓA - THANH HÓA','202501',NULL,NULL,'1','2','','V01',NULL,'V','',180,13524000,180,13524000,13524000,'','','Caiyu',1737429339,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'','',0,'172583237','TWS001','n','HA THI DUYEN',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 11:15:39','Caiyu',1,0),('20250121V0003','1737388800','2025-01-21 00:00:00','V8812067','KHUẤT THỊ LÝ 屈氏李','V01','0936405999','1','LÔ 24, MAI XUÂN DƯƠNG, P.ĐÔNG THỌ, TP THANH HÓA, THANH HÓA','202501',NULL,NULL,'1','2','','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Caiyu',1737437303,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 THANH HOA- HA THI DUYEN DA MUA HANG ( 1 SET DAM 6 2   TINH DAU 30ML SO 1) HOA','',0,'171608182','TWS001','n','HA THI DUYEN',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 11:10:06','Caiyu',1,0),('20250121V0010','1737388800','2025-01-21 00:00:00','V8814891','VŨ VĂN TỊNH 舞文靜','V01','0915219889','1','21-B3 T.THỂ KHƯƠNG THƯỢNG, TRUNG TỰ, ĐỐNG ĐA, HÀ NỘI','202501',NULL,NULL,'1','2','202501','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Caiyu',1737433491,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA MUA HANG ( 1 SET DAM 6 2   DAU TAY TRANG) HOA','',0,'033076001267','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:23:41','Caiyu',1,0),('20250121V0023','1737388800','2025-01-21 00:00:00','V8817079','LÊ THỊ XUÂN 李氏群','V01','0928720248','1','246 DÃ TƯỢNG, ĐÔNG HẢI, TP THANH HÓA, THANH HÓA','202501',NULL,NULL,'1','4','','V01',NULL,'V','',120,5910000,120,5910000,5910000,'','','Caiyu',1737435736,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA MUA HANG ( 3 ĐẠM) HOA','',0,'197184499','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 13:01:48','Caiyu',1,0),('20250121V0008','1737388800','2025-01-21 00:00:00','V8817473','TRẦN HUY CƯỜNG 陳輝強','V01','0908725978','1','B6, NGUYỄN THẦN HIẾN, PHƯỜNG 18, QUẬN 4, HỒ CHÍ MINH','202501',NULL,NULL,'1','2','','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Caiyu',1737440310,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - TRAN VAN HIEP DA MUA HANG ( 1 SET DAM 6 2   DAU TAY TRANG) HOA','',0,'079070015492','TWS001','n','TRAN VAN HIEP',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 11:36:08','Caiyu',1,0),('20250121V0009','1737388800','2025-01-21 00:00:00','V8818751','TRẦN THỊ MINH PHƯƠNG-陳氏明芳','V01','0584613100','1','KP BÌNH THIỆN, TÂN THIỆN, TP ĐỒNG XOÀI, BÌNH PHƯỚC','202501',NULL,NULL,'1','2','','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Caiyu',1737433484,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA MUA HANG ( 1 SET DAM 6 2   DAU TAY TRANG) HOA','',0,'070190002280','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:22:30','Caiyu',1,0),('20250121V0001','1737388800','2025-01-21 00:00:00','V8819393','VŨ THỊ LAN 武氏蘭','V01','0981801559','1','TỔ 1, ẤP THANH AN, THANH LƯƠNG, THỊ XÃ BÌNH LONG, BÌNH PHƯỚC','202501',NULL,NULL,'1','2','202501','V01',NULL,'V','',720,35460000,720,35460000,35460000,'','','Caiyu',1737437342,0,'2','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 THANH HOA- HA THI DUYEN DA MUA HANG (3 SET DAM 6 2   3 TINH DAU 30ML SO 1) HOA','',0,'03017501311','TWS001','n','HA THI DUYEN',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 11:00:57','Caiyu',1,0),('20250121V0004','1737388800','2025-01-21 00:00:00','V8910387','NGUYỄN THẢO NGUYÊN 阮桃原','V01','0974364183','1','P 710 NHÀ A6, TT GIẢNG VÕ, GIẢNG VÕ, BA ĐÌNH, HÀ NỘI','202501',NULL,NULL,'1','4','','V01',NULL,'V','',500,22200000,500,22200000,22200000,'','','Caiyu',1737437209,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 THANH HOA- HA THI DUYEN DA MUA HANG ( 1 SET FIT 6 1) HOA','',0,'001304023385','TWS001','n','HA THI DUYEN',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 11:11:16','Caiyu',1,0),('20250121V0006','1737388800','2025-01-21 00:00:00','V8910546','NGUYỄN THỊ NGỌC TUYẾT 阮氏玉雪','V01','0989641874','1','TDP 8, ĐÌNH THÔN, MỸ ĐÌNH 1, NAM TỪ LIÊM, HÀ NỘI','202501',NULL,NULL,'1','2','','V01',NULL,'V','',180,13524000,180,13524000,13524000,'','','Caiyu',1737444812,0,'2','n',NULL,NULL,NULL,NULL,NULL,NULL,'','',0,'001162000071','TWS001','n','HA THI DUYEN',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 11:17:00','Caiyu',1,0),('20250121V0025','1737388800','2025-01-21 00:00:00','V8910552','NGUYỄN THỊ KIM 阮氏金','V01','0988888805','1','21/9 ĐƯỜNG SỐ 3, AN KHÁNH, TP. THỦ ĐỨC, TP. HỒ CHÍ MINH','202501',NULL,NULL,'1','4','202501','V01',NULL,'V','',500,22200000,500,22200000,22200000,'','','Caiyu',1737440260,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA MUA HANG ( 1 SET FIT 6 1) HOA','',0,'038164002806','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 14:13:13','Caiyu',1,0),('20250121V0031','1737388800','2025-01-21 00:00:00','V8910820','LỮ THỊ NHÀN 呂氏蕑','V01','0523862575','1','87/5 KỲ ĐỒNG ,QUẬN 3 ,TPHCM','202501',NULL,NULL,'1','4','202501','V01',NULL,'V','',500,22200000,500,22200000,22200000,'','','Caiyu',1737447202,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'','',0,'040302008986','TWS001','n','THIEU HIEN NHI',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 16:13:22','Caiyu',1,0),('20250121V0012','1737388800','2025-01-21 00:00:00','V8910918','PHẠM THỊ THÚY  范氏水','V01','0852342538','1','43 LÝ THƯỜNG KIỆT ,TÂN PHÚ ,TP .ĐỒNG XOÀI ,BÌNH PHƯỚC .','202501',NULL,NULL,'1','4','','V01',NULL,'V','',100,3700000,100,3700000,3700000,'','','Caiyu',1737434880,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA MUA HANG ( 1 BO FIT AUTOSHIP) L1K2 HOA','',0,'044178005389','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:40:26','Caiyu',1,0),('20250121V0013','1737388800','2025-01-21 00:00:00','V8910918','PHẠM THỊ THÚY  范氏水','V01','0852342538','1','43 LÝ THƯỜNG KIỆT ,TÂN PHÚ ,TP .ĐỒNG XOÀI ,BÌNH PHƯỚC .','202501',NULL,NULL,'1','2','','V01',NULL,'V','',0,0,0,0,0,'','','Caiyu',1737434914,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA DOI QUA ( 1 NHA) 20250121V0012  HOA','',0,'044178005389','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:41:13','Caiyu',1,0),('20250121V0007','1737388800','2025-01-21 00:00:00','V8910989','TRẦN THỊ TÍA 陳氏爹','V01','0334128325','1','P.ĐÔNG THỌ ,TP THANH HÓA ,THANH HÓA.','202501',NULL,NULL,'1','2','','V01',NULL,'V','',180,13524000,180,13524000,13524000,'','','Caiyu',1737429470,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'','',0,'030158017992','TWS001','n','HA THI DUYEN',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 11:17:50','Caiyu',1,0),('20250121V0030','1737388800','2025-01-21 00:00:00','V8911057','NGÔ VĂN TẤN 吳文俊','V01','0912152452','1','71 VỌNG HÀ, CHƯƠNG DƯƠNG, HOÀN KIẾM, HÀ NỘI','202501',NULL,NULL,'1','2','','V01',NULL,'V','',200,6939000,200,6939000,6939000,'','','Caiyu',1737445747,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'','',0,'033066002165','TWS001','n','NGO THI THANH DUNG',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 15:49:07','Caiyu',1,0),('20250121V0002','1737388800','2025-01-21 00:00:00','V8911114','NGUYỄN THỊ PHƯƠNG  阮氏芳','V01','0338290809','1','86A ,LÊ LAI , P.TÂY SƠN , TP PLEIKU ,T.GIA LAI .','202501',NULL,NULL,'1','2','','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Caiyu',1737437317,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 THANH HOA- HA THI DUYEN DA MUA HANG ( 1 SET DAM 6 2   TINH DAU 30ML SO 1) HOA','',0,'037175003964','TWS001','n','HA THI DUYEN',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 11:09:18','Caiyu',1,0),('20250121V0026','1737388800','2025-01-21 00:00:00','V8911121','TRỊNH THỊ CÚC 鄭氏菊','V01','0934107040','1','266/10/7A LÊ TRỌNG TẤN, TÂY THẠNH, TÂN PHÚ, TPHCM','202501',NULL,NULL,'1','4','202501','V01',NULL,'V','',100,3700000,100,3700000,3700000,'','','Lisa',1737444689,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025-01-21 HCM HUYNH THI BICH THAO DA NHAN HANG (AUTOSHIP 1 BỘ FIT )L1 K1 HO','',0,'079169015869','TWS001','n','HUYNH THI BICH THAO',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 15:29:50','Lisa',1,0),('20250121V0011','1737388800','2025-01-21 00:00:00','V8911138','NGUYỄN TẤN DŨNG 阮俊勇','V01','0344619701','1','CỤM 7, VĨNH NINH, VĨNH QUỲNH, THANH TRÌ, HÀ NỘI','202501',NULL,NULL,'1','2','','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Caiyu',1737433788,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - PHAM THI BE MUOI MOT DA MUA HANG ( 1 SET DAM 6 2   DAU TAY TRANG) HOA','',0,'010201000024','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:29:33','Caiyu',1,0),('20250121V0022','1737388800','2025-01-21 00:00:00','V8911141','NGUYỄN THỊ PHƯƠNG LAN 阮氏芳蘭','V01','0987142757','1','168B AN ĐÀ, ĐẰNG GIANG, NGÔ QUYỀN, HẢI PHÒNG','202501',NULL,NULL,'1','4','','V01',NULL,'V','',500,22200000,500,22200000,22200000,'','','Caiyu',1737435226,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM -PHAM THI BE MUOI MOT DA MUA HANG ( 1 SET FIT 6 1) HOA','',0,'001176056140','TWS001','n','PHAM THI BE MUOI MOT ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:53:24','Caiyu',1,0),('20250121V0015','1737388800','2025-01-21 00:00:00','V8911143','TRẦN THỊ DUNG 陳氏蓉','V01','0857979678','1','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','202501',NULL,NULL,'1','4','202501','V01',NULL,'V','',0,22200000,0,22200000,22200000,'','','Caiyu',1737435526,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025/01/21 HCM - TRAN VAN HIEP DA MUA HANG ( 1 SET FIT  6 1) HOA','',0,'052170005408','TWS001','n','TRAN VAN HIEP ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:51:26','Caiyu',1,0),('20250121V0016','1737388800','2025-01-21 00:00:00','V8911143','TRẦN THỊ DUNG 陳氏蓉','V01','0857979678','1','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','202501',NULL,'20250121V0015','1','4','202501','V01',NULL,'V','',100,0,100,0,0,'','','Caiyu',1737435087,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'*20250121V0015-1','',0,'052170005408','TWS001','n','TRAN VAN HIEP ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:51:26','Caiyu',1,0),('20250121V0017','1737388800','2025-01-21 00:00:00','V8911143','TRẦN THỊ DUNG 陳氏蓉','V01','0857979678','1','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','202502',NULL,'20250121V0015','1','4','202501','V01',NULL,'V','',100,0,100,0,0,'','','Caiyu',1737435087,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'*20250121V0015-2','',0,'052170005408','TWS001','n','TRAN VAN HIEP ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:51:26','Caiyu',1,0),('20250121V0018','1737388800','2025-01-21 00:00:00','V8911143','TRẦN THỊ DUNG 陳氏蓉','V01','0857979678','1','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','202503',NULL,'20250121V0015','1','4','202501','V01',NULL,'V','',100,0,100,0,0,'','','Caiyu',1737435087,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'*20250121V0015-3','',0,'052170005408','TWS001','n','TRAN VAN HIEP ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:51:26','Caiyu',1,0),('20250121V0019','1737388800','2025-01-21 00:00:00','V8911143','TRẦN THỊ DUNG 陳氏蓉','V01','0857979678','1','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','202504',NULL,'20250121V0015','1','4','202501','V01',NULL,'V','',100,0,100,0,0,'','','Caiyu',1737435087,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'*20250121V0015-4','',0,'052170005408','TWS001','n','TRAN VAN HIEP ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:51:26','Caiyu',1,0),('20250121V0020','1737388800','2025-01-21 00:00:00','V8911143','TRẦN THỊ DUNG 陳氏蓉','V01','0857979678','1','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','202505',NULL,'20250121V0015','1','4','202501','V01',NULL,'V','',100,0,100,0,0,'','','Caiyu',1737435087,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'*20250121V0015-5','',0,'052170005408','TWS001','n','TRAN VAN HIEP ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:51:26','Caiyu',1,0),('20250121V0021','1737388800','2025-01-21 00:00:00','V8911143','TRẦN THỊ DUNG 陳氏蓉','V01','0857979678','1','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','202506',NULL,'20250121V0015','1','4','202501','V01',NULL,'V','',100,0,100,0,0,'','','Caiyu',1737435087,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'*20250121V0015-6','',0,'052170005408','TWS001','n','TRAN VAN HIEP ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 12:51:26','Caiyu',1,0),('20250121V0027','1737388800','2025-01-21 00:00:00','V8911144','HUỲNH ANH TUẤN 黃英俊','V01','0938255067','1','266/10/7A LÊ TRỌNG TẤN, TÂY THẠNH, TÂN PHÚ, TPHCM ','202501',NULL,NULL,'1','2','202501','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Lisa',1737444957,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025-01-21 HCM HUYNH THI BICH THAO DA MUA HANG ( 1SET DAM 6 2, 1 DAU TAY TRANG ) HO','',0,'079201025228','TWS001','n','HUYNH THI BICH THAO',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 15:35:57','Lisa',1,0),('20250121V0029','1737388800','2025-01-21 00:00:00','V8911145','PHAN MỸ LINH 潘美玲','V01','0908271363','1','453/70/42 LÊ VĂN KHƯƠNG, KP5, HIỆP THÀNH, QUẬN 12, TPHCM','202501',NULL,NULL,'1','2','202501','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Lisa',1737445279,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025-01-21 HCM DA MUA HANG ( 1SET DAM 6 2 1 TAY TRANG ) HO','',0,'052300014003','TWS001','n','HUYNH THI BICH THAO',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 15:41:19','Lisa',1,0),('20250121V0028','1737388800','2025-01-21 00:00:00','V8911146','PHAN NGỌC HOÀNG 潘玉皇','V01','0816000777','1','2.24 LÔ D, CC LẠC LONG QUÂN, PHƯỜNG 05, QUẬN 11, TPHCM','202501',NULL,NULL,'1','2','202501','V01',NULL,'V','',240,11820000,240,11820000,11820000,'','','Lisa',1737445125,0,'1','n',NULL,NULL,NULL,NULL,NULL,NULL,'2025-01-21 HCM HUYNH THI BICH THAO DA MUA HANG ( 1SET DAM 6 2 1 TAY TRANG ) HO','',0,'066079000018','TWS001','n','HUYNH THI BICH THAO ',1,NULL,1,NULL,NULL,NULL,'','-1','-1',0,0,NULL,'0','2025-01-21 15:38:45','Lisa',1,0);


--
-- Host: 192.168.0.6    Database: eh
-- ------------------------------------------------------


--
-- Table structure for table `order_d`
--

CREATE TABLE `order_d` (
  `d_no` int NOT NULL AUTO_INCREMENT,
  `ord_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `prod_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `seq_no` int DEFAULT NULL,
  `price` double DEFAULT NULL,
  `qty` int DEFAULT NULL,
  `qty_old` int DEFAULT NULL,
  `out_qty` int DEFAULT '0',
  `unit_pv` double DEFAULT NULL,
  `sub_pv` double DEFAULT NULL,
  `sub_money` double DEFAULT NULL,
  `update_user` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `data_timestamp` int DEFAULT NULL,
  `update_state` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `barcode` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `real_money` double DEFAULT NULL,
  PRIMARY KEY (`d_no`),
  KEY `Index_1` (`ord_no`,`prod_no`),
  KEY `Inx_prod_no` (`prod_no`)
) ENGINE=InnoDB AUTO_INCREMENT=7248317 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `order_d`
--
-- WHERE:  ord_no in(select ord_no from order_m where ord_date2>='2025-01-21' and mb_no like 'V%')

INSERT INTO `order_d` VALUES (7247569,'20250121V0014','V003003',1,3700000,1,1,0,100,100,3700000,'Caiyu',1737434522,'1','33',NULL),(7247934,'20250121V0024','V0P120252',1,11820000,1,1,0,240,240,11820000,'Caiyu',1737439621,'1','',NULL),(7247126,'20250121V0005','V0P28201',1,13524000,1,1,0,180,180,13524000,'Caiyu',1737429339,'1','',NULL),(7247104,'20250121V0003','V0P120252',1,11820000,1,1,0,240,240,11820000,'Caiyu',1737429006,'1','',NULL),(7247510,'20250121V0010','V0P120252',1,11820000,1,1,0,240,240,11820000,'Caiyu',1737433421,'1','',NULL),(7247634,'20250121V0023','V003025',1,5910000,1,1,0,120,120,5910000,'Caiyu',1737435708,'1','',NULL),(7247245,'20250121V0008','V0P120252',1,11820000,1,1,0,240,240,11820000,'Caiyu',1737430568,'1','',NULL),(7247502,'20250121V0009','V0P120252',1,11820000,1,1,0,240,240,11820000,'Caiyu',1737433350,'1','',NULL),(7247071,'20250121V0001','V0P120252',1,11820000,3,3,0,240,720,35460000,'Caiyu',1737428914,'2','',NULL),(7247106,'20250121V0004','V004011',1,22200000,1,1,0,500,500,22200000,'Caiyu',1737429076,'1','48',NULL),(7247130,'20250121V0006','V0P28201',1,13524000,1,1,0,180,180,13524000,'Caiyu',1737429420,'1','',NULL),(7247947,'20250121V0025','V004011',1,22200000,1,1,0,500,500,22200000,'Caiyu',1737439993,'1','48',NULL),(7248311,'20250121V0031','V004011',1,22200000,1,1,0,500,500,22200000,'Caiyu',1737447202,'1','48',NULL),(7247565,'20250121V0012','V003003',1,3700000,1,1,0,100,100,3700000,'Caiyu',1737434426,'1','33',NULL),(7247567,'20250121V0013','V13504',1,0,1,1,0,0,0,0,'Caiyu',1737434473,'1','',NULL),(7247132,'20250121V0007','V0P28201',1,13524000,1,1,0,180,180,13524000,'Caiyu',1737429470,'1','',NULL),(7248228,'20250121V0030','V51001',1,1269000,1,1,0,35,35,1269000,'Caiyu',1737445747,'1','',NULL),(7248229,'20250121V0030','V51103',2,1890000,1,1,0,55,55,1890000,'Caiyu',1737445747,'1','',NULL),(7248231,'20250121V0030','V51104',4,1890000,1,1,0,55,55,1890000,'Caiyu',1737445747,'1','',NULL),(7248230,'20250121V0030','V51105',3,1890000,1,1,0,55,55,1890000,'Caiyu',1737445747,'1','',NULL),(7247095,'20250121V0002','V0P120252',1,11820000,1,1,0,240,240,11820000,'Caiyu',1737428958,'1','',NULL),(7248158,'20250121V0026','V003003',1,3700000,1,1,0,100,100,3700000,'Lisa',1737444590,'1','33',NULL),(7247531,'20250121V0011','V0P120252',1,11820000,1,1,0,240,240,11820000,'Caiyu',1737433773,'1','',NULL),(7247617,'20250121V0022','V004011',1,22200000,1,1,0,500,500,22200000,'Caiyu',1737435204,'1','48',NULL),(7247609,'20250121V0015','V004006',1,22200000,1,1,0,0,0,22200000,'Caiyu',1737435086,'1','46',NULL),(7247610,'20250121V0016','V004005',1,0,1,1,0,100,100,0,'System',1737435087,'1',NULL,NULL),(7247611,'20250121V0017','V004005',1,0,1,1,0,100,100,0,'System',1737435087,'1',NULL,NULL),(7247612,'20250121V0018','V004005',1,0,1,1,0,100,100,0,'System',1737435087,'1',NULL,NULL),(7247613,'20250121V0019','V004005',1,0,1,1,0,100,100,0,'System',1737435087,'1',NULL,NULL),(7247614,'20250121V0020','V004005',1,0,1,1,0,100,100,0,'System',1737435087,'1',NULL,NULL),(7247615,'20250121V0021','V004005',1,0,1,1,0,100,100,0,'System',1737435087,'1',NULL,NULL),(7248183,'20250121V0027','V0P120252',1,11820000,1,1,0,240,240,11820000,'Lisa',1737444957,'1','',NULL),(7248210,'20250121V0029','V0P120252',1,11820000,1,1,0,240,240,11820000,'Lisa',1737445279,'1','',NULL),(7248198,'20250121V0028','V0P120252',1,11820000,1,1,0,240,240,11820000,'Lisa',1737445125,'1','',NULL);


--
-- Host: 192.168.0.6    Database: eh
-- ------------------------------------------------------


--
-- Table structure for table `order_dd`
--

CREATE TABLE `order_dd` (
  `ord_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `seq_no` int DEFAULT NULL,
  `prod_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `detail_prod_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `qty` int DEFAULT NULL,
  `out_qty` int DEFAULT '0',
  `prod_kind` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `prod_unit` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `remark` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `update_user` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `data_timestamp` int DEFAULT NULL,
  `update_state` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  KEY `ord_no` (`ord_no`) /*!80000 INVISIBLE */,
  KEY `detail_prod_no` (`detail_prod_no`),
  KEY `ord_prod` (`ord_no`,`prod_no`,`detail_prod_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `order_dd`
--
-- WHERE:  ord_no in(select ord_no from order_m where ord_date2>='2025-01-21' and mb_no like 'V%')

INSERT INTO `order_dd` VALUES ('20250121V0014',1,'V12001','V12001',1,1,'1',NULL,'','Caiyu',1737434885,'1'),('20250121V0014',2,'V12002','V12002',1,1,'1',NULL,'','Caiyu',1737434885,'1'),('20250121V0014',3,'V12003','V12003',1,1,'1',NULL,'','Caiyu',1737434885,'1'),('20250121V0024',1,'V12025','V12025',6,6,'1',NULL,'','Caiyu',1737439735,'1'),('20250121V0005',1,'V28002','V28002',8,0,'1',NULL,'','Caiyu',1737429339,'1'),('20250121V0003',1,'V12025','V12025',6,6,'1',NULL,'','Caiyu',1737437271,'1'),('20250121V0010',1,'V12025','V12025',6,6,'1',NULL,'','Caiyu',1737433489,'1'),('20250121V0023',1,'V12025','V12025',3,3,'1',NULL,'','Caiyu',1737435714,'1'),('20250121V0008',1,'V12025','V12025',6,6,'1',NULL,'','Caiyu',1737440267,'1'),('20250121V0009',1,'V12025','V12025',6,6,'1',NULL,'','Caiyu',1737433460,'1'),('20250121V0001',1,'V12025','V12025',18,18,'1',NULL,'','Caiyu',1737437328,'2'),('20250121V0004',1,'V12001','V12001',6,6,'1',NULL,'','Caiyu',1737437191,'1'),('20250121V0004',2,'V12002','V12002',6,6,'1',NULL,'','Caiyu',1737437191,'1'),('20250121V0004',3,'V12003','V12003',6,6,'1',NULL,'','Caiyu',1737437191,'1'),('20250121V0006',1,'V28002','V28002',8,0,'1',NULL,'','Caiyu',1737444812,'2'),('20250121V0025',1,'V12001','V12001',6,6,'1',NULL,'','Caiyu',1737440239,'1'),('20250121V0025',2,'V12002','V12002',6,6,'1',NULL,'','Caiyu',1737440239,'1'),('20250121V0025',3,'V12003','V12003',6,6,'1',NULL,'','Caiyu',1737440239,'1'),('20250121V0031',1,'V12001','V12001',6,0,'1',NULL,'','Caiyu',1737447202,'1'),('20250121V0031',2,'V12002','V12002',6,0,'1',NULL,'','Caiyu',1737447202,'1'),('20250121V0031',3,'V12003','V12003',6,0,'1',NULL,'','Caiyu',1737447202,'1'),('20250121V0012',1,'V12001','V12001',1,1,'1',NULL,'','Caiyu',1737434843,'1'),('20250121V0012',2,'V12002','V12002',1,1,'1',NULL,'','Caiyu',1737434843,'1'),('20250121V0012',3,'V12003','V12003',1,1,'1',NULL,'','Caiyu',1737434843,'1'),('20250121V0013',1,'V13504','V13504',1,1,'1',NULL,'','Caiyu',1737434899,'1'),('20250121V0007',1,'V28002','V28002',8,0,'1',NULL,'','Caiyu',1737429470,'1'),('20250121V0030',1,'V51001','V51001',1,1,'1',NULL,'','Caiyu',1737445755,'1'),('20250121V0030',2,'V51103','V51103',1,1,'1',NULL,'','Caiyu',1737445755,'1'),('20250121V0030',3,'V51104','V51104',1,1,'1',NULL,'','Caiyu',1737445755,'1'),('20250121V0030',4,'V51105','V51105',1,1,'1',NULL,'','Caiyu',1737445755,'1'),('20250121V0002',1,'V12025','V12025',6,6,'1',NULL,'','Caiyu',1737437314,'1'),('20250121V0026',1,'V12001','V12001',1,1,'1',NULL,'','Lisa',1737444698,'1'),('20250121V0026',2,'V12002','V12002',1,1,'1',NULL,'','Lisa',1737444698,'1'),('20250121V0026',3,'V12003','V12003',1,1,'1',NULL,'','Lisa',1737444698,'1'),('20250121V0011',1,'V12025','V12025',6,6,'1',NULL,'','Caiyu',1737433778,'1'),('20250121V0022',1,'V12001','V12001',6,6,'1',NULL,'','Caiyu',1737435211,'1'),('20250121V0022',2,'V12002','V12002',6,6,'1',NULL,'','Caiyu',1737435211,'1'),('20250121V0022',3,'V12003','V12003',6,6,'1',NULL,'','Caiyu',1737435211,'1'),('20250121V0015',1,'V12001','V12001',6,6,'1',NULL,'','Caiyu',1737435497,'1'),('20250121V0015',2,'V12002','V12002',6,6,'1',NULL,'','Caiyu',1737435497,'1'),('20250121V0015',3,'V12003','V12003',6,6,'1',NULL,'','Caiyu',1737435497,'1'),('20250121V0016',1,'V004005','V004005',1,0,'1',NULL,NULL,'System',1737435087,'1'),('20250121V0017',1,'V004005','V004005',1,0,'1',NULL,NULL,'System',1737435087,'1'),('20250121V0018',1,'V004005','V004005',1,0,'1',NULL,NULL,'System',1737435087,'1'),('20250121V0019',1,'V004005','V004005',1,0,'1',NULL,NULL,'System',1737435087,'1'),('20250121V0020',1,'V004005','V004005',1,0,'1',NULL,NULL,'System',1737435087,'1'),('20250121V0021',1,'V004005','V004005',1,0,'1',NULL,NULL,'System',1737435087,'1'),('20250121V0027',1,'V12025','V12025',6,6,'1',NULL,'','Lisa',1737445002,'1'),('20250121V0029',1,'V12025','V12025',6,6,'1',NULL,'','Lisa',1737445320,'1'),('20250121V0028',1,'V12025','V12025',6,6,'1',NULL,'','Lisa',1737445142,'1');


--
-- Host: 192.168.0.6    Database: eh
-- ------------------------------------------------------


--
-- Table structure for table `order_gift`
--

CREATE TABLE `order_gift` (
  `g_no` int NOT NULL AUTO_INCREMENT,
  `ord_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `seq_no` int DEFAULT NULL,
  `gift_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `prod_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `prod_unit` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `qty` float DEFAULT NULL,
  `out_qty` float DEFAULT '0',
  `prod_kind` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `update_user` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `data_timestamp` int DEFAULT NULL,
  `update_state` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`g_no`),
  KEY `Inx_ord_no` (`ord_no`),
  KEY `Inx_prod_no` (`prod_no`),
  KEY `Inx_gift_no` (`gift_no`,`prod_no`) /*!80000 INVISIBLE */,
  KEY `ord_prod` (`ord_no`,`gift_no`,`prod_no`)
) ENGINE=InnoDB AUTO_INCREMENT=3862268 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `order_gift`
--
-- WHERE:  ord_no in(select ord_no from order_m where ord_date2>='2025-01-21' and mb_no like 'V%')

INSERT INTO `order_gift` VALUES (3861810,'20250121V0014',1,'V14005','V14005','個',1,1,'1','Caiyu',1737434885,'1'),(3862036,'20250121V0024',1,'V12025','V12025','罐',2,2,'1','Caiyu',1737439735,'1'),(3862037,'20250121V0024',2,'V14004','V14004','個',1,1,'1','Caiyu',1737439735,'1'),(3862038,'20250121V0024',3,'','V23002','瓶',1,1,'1','Caiyu',1737439735,'1'),(3861582,'20250121V0005',1,'','V14005','個',1,0,'1','Caiyu',1737429339,'1'),(3861583,'20250121V0005',2,'','V52001','瓶',1,1,'1','Caiyu',1737437395,'1'),(3861556,'20250121V0003',1,'V12025','V12025','罐',2,2,'1','Caiyu',1737437271,'1'),(3861557,'20250121V0003',2,'V14004','V14004','個',1,1,'1','Caiyu',1737437271,'1'),(3861558,'20250121V0003',3,'','V52001','瓶',1,1,'1','Caiyu',1737437271,'1'),(3861780,'20250121V0010',1,'V12025','V12025','罐',2,2,'1','Caiyu',1737433489,'1'),(3861781,'20250121V0010',2,'V14004','V14004','個',1,1,'1','Caiyu',1737433489,'1'),(3861782,'20250121V0010',3,'','V23002','瓶',1,1,'1','Caiyu',1737433489,'1'),(3861856,'20250121V0023',1,'V14005','V14005','個',1,1,'1','Caiyu',1737435714,'1'),(3861656,'20250121V0008',1,'V12025','V12025','罐',2,2,'1','Caiyu',1737440267,'1'),(3861657,'20250121V0008',2,'V14004','V14004','個',1,1,'1','Caiyu',1737440267,'1'),(3861658,'20250121V0008',3,'','V23002','瓶',1,1,'1','Caiyu',1737440267,'1'),(3861776,'20250121V0009',1,'V12025','V12025','罐',2,2,'1','Caiyu',1737433460,'1'),(3861777,'20250121V0009',2,'V14004','V14004','個',1,1,'1','Caiyu',1737433460,'1'),(3861778,'20250121V0009',3,'','V23002','瓶',1,1,'1','Caiyu',1737433460,'1'),(3861531,'20250121V0001',1,'V12025','V12025','罐',2,2,'1','Caiyu',1737437328,'2'),(3861532,'20250121V0001',2,'V14004','V14004','個',1,1,'1','Caiyu',1737437328,'2'),(3861533,'20250121V0001',3,'','V52001','瓶',3,3,'1','Caiyu',1737437328,'2'),(3861562,'20250121V0004',1,'V12001','V12001','罐',1,1,'1','Caiyu',1737437191,'1'),(3861563,'20250121V0004',2,'V12002','V12002','罐',1,1,'1','Caiyu',1737437191,'1'),(3861564,'20250121V0004',3,'V12003','V12003','罐',1,1,'1','Caiyu',1737437191,'1'),(3861565,'20250121V0004',4,'V14004','V14004','個',1,1,'1','Caiyu',1737437191,'1'),(3861566,'20250121V0004',5,'V14005','V14005','個',3,3,'1','Caiyu',1737437191,'1'),(3861586,'20250121V0006',1,'','V14005','個',1,0,'1','Caiyu',1737444807,'2'),(3861587,'20250121V0006',2,'','V52002','瓶',1,1,'1','Caiyu',1737437408,'1'),(3862050,'20250121V0025',1,'V12001','V12001','罐',1,1,'1','Caiyu',1737440239,'1'),(3862051,'20250121V0025',2,'V12002','V12002','罐',1,1,'1','Caiyu',1737440239,'1'),(3862052,'20250121V0025',3,'V12003','V12003','罐',1,1,'1','Caiyu',1737440239,'1'),(3862053,'20250121V0025',4,'V14004','V14004','個',1,1,'1','Caiyu',1737440239,'1'),(3862054,'20250121V0025',5,'V14005','V14005','個',3,3,'1','Caiyu',1737440239,'1'),(3862259,'20250121V0031',1,'V12001','V12001','罐',1,0,'1','Caiyu',1737447202,'1'),(3862260,'20250121V0031',2,'V12002','V12002','罐',1,0,'1','Caiyu',1737447202,'1'),(3862261,'20250121V0031',3,'V12003','V12003','罐',1,0,'1','Caiyu',1737447202,'1'),(3862262,'20250121V0031',4,'V14004','V14004','個',1,0,'1','Caiyu',1737447202,'1'),(3862263,'20250121V0031',5,'V14005','V14005','個',3,0,'1','Caiyu',1737447202,'1'),(3861808,'20250121V0012',1,'V14005','V14005','個',1,1,'1','Caiyu',1737434843,'1'),(3861589,'20250121V0007',1,'','V14005','個',1,0,'1','Caiyu',1737429470,'1'),(3861590,'20250121V0007',2,'','V52002','瓶',1,1,'1','Caiyu',1737437418,'1'),(3861547,'20250121V0002',1,'V12025','V12025','罐',2,2,'1','Caiyu',1737437314,'1'),(3861548,'20250121V0002',2,'V14004','V14004','個',1,1,'1','Caiyu',1737437314,'1'),(3861549,'20250121V0002',3,'','V52001','瓶',1,1,'1','Caiyu',1737437314,'1'),(3862168,'20250121V0026',1,'V14005','V14005','個',1,1,'1','Lisa',1737444698,'1'),(3861788,'20250121V0011',1,'V12025','V12025','罐',2,2,'1','Caiyu',1737433778,'1'),(3861789,'20250121V0011',2,'V14004','V14004','個',1,1,'1','Caiyu',1737433778,'1'),(3861790,'20250121V0011',3,'','V23002','瓶',1,1,'1','Caiyu',1737433778,'1'),(3861838,'20250121V0022',1,'V12001','V12001','罐',1,1,'1','Caiyu',1737435211,'1'),(3861839,'20250121V0022',2,'V12002','V12002','罐',1,1,'1','Caiyu',1737435211,'1'),(3861840,'20250121V0022',3,'V12003','V12003','罐',1,1,'1','Caiyu',1737435211,'1'),(3861841,'20250121V0022',4,'V14004','V14004','個',1,1,'1','Caiyu',1737435211,'1'),(3861842,'20250121V0022',5,'V14005','V14005','個',3,3,'1','Caiyu',1737435211,'1'),(3861833,'20250121V0015',1,'V12001','V12001','罐',1,1,'1','Caiyu',1737435497,'1'),(3861834,'20250121V0015',2,'V12002','V12002','罐',1,1,'1','Caiyu',1737435497,'1'),(3861835,'20250121V0015',3,'V12003','V12003','罐',1,1,'1','Caiyu',1737435497,'1'),(3861836,'20250121V0015',4,'V14004','V14004','個',1,1,'1','Caiyu',1737435497,'1'),(3861837,'20250121V0015',5,'V14005','V14005','個',3,3,'1','Caiyu',1737435497,'1'),(3862184,'20250121V0027',1,'V12025','V12025','罐',2,2,'1','Lisa',1737445002,'1'),(3862185,'20250121V0027',2,'V14004','V14004','個',1,1,'1','Lisa',1737445002,'1'),(3862186,'20250121V0027',3,'','V23002','瓶',1,1,'1','Lisa',1737445002,'1'),(3862211,'20250121V0029',1,'V12025','V12025','罐',2,2,'1','Lisa',1737445320,'1'),(3862212,'20250121V0029',2,'V14004','V14004','個',1,1,'1','Lisa',1737445320,'1'),(3862213,'20250121V0029',3,'','V23002','瓶',1,1,'1','Lisa',1737445320,'1'),(3862193,'20250121V0028',1,'V12025','V12025','罐',2,2,'1','Lisa',1737445142,'1'),(3862194,'20250121V0028',2,'V14004','V14004','個',1,1,'1','Lisa',1737445142,'1'),(3862195,'20250121V0028',3,'','V23002','瓶',1,1,'1','Lisa',1737445142,'1');


--
-- Host: 192.168.0.6    Database: eh
-- ------------------------------------------------------


--
-- Table structure for table `paid`
--

CREATE TABLE `paid` (
  `p_no` int NOT NULL AUTO_INCREMENT,
  `ord_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `seq_no` int DEFAULT NULL,
  `pdate` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `paid_way` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `mb_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `paid_money` double DEFAULT '0',
  `remark` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `update_user` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `data_timestamp` int DEFAULT NULL,
  `update_state` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ticket_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '票據號碼',
  `money_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '票據到期日',
  `give_method` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '銀行',
  `bank_ac` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '帳號',
  `real_money` double DEFAULT '0',
  `auth_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `auth_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`p_no`),
  KEY `Index_1` (`ord_no`)
) ENGINE=InnoDB AUTO_INCREMENT=5251379 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `paid`
--
-- WHERE:  ord_no in(select ord_no from order_m where ord_date2>='2025-01-21' and mb_no like 'V%')

INSERT INTO `paid` VALUES (5250746,'20250121V0014',1,'2025-01-21','2','V8808920',3700000,'0907666763','Caiyu',1737434522,'1','539756896404026','10/28','','PHAM THI BE MUOI MOT',0,'262386',''),(5251068,'20250121V0024',1,'2025-01-21','2','V8809731',3020000,'0888867171','Caiyu',1737439621,'1','4032801001506901','11/28','','PHAM VIET TOAN',0,'371079',''),(5251069,'20250121V0024',2,'2025-01-21','2','V8809731',8800000,'0907666763','Caiyu',1737439621,'1','5239756896404026','10/28','','PHAM THI BE MUOI MOT',0,'262389',''),(5250447,'20250121V0005',1,'2025-01-21','1','V8812041',13524000,'0918667311','Caiyu',1737429339,'1','','','','HA THI DUYEN',0,'',''),(5250426,'20250121V0003',1,'2025-01-21','3','V8812067',11820000,'0918667311','Caiyu',1737429006,'1','','','','HA THI DUYEN',0,'',''),(5250701,'20250121V0010',1,'2025-01-21','2','V8814891',11820000,'0907666763','Caiyu',1737433421,'1','4381038829394221','08/29','','PHAM THI BE MUOI MOT',0,'577293',''),(5250811,'20250121V0023',1,'2025-01-21','2','V8817079',5910000,'0907666763','Caiyu',1737435708,'1','5239756896404026','10/28','','PHAM THI BE MUOI MOT',0,'262388',''),(5250540,'20250121V0008',1,'2025-01-21','3','V8817473',11820000,'0935123405','Caiyu',1737430568,'1','','','','TRAN VAN HIEP',0,'',''),(5250693,'20250121V0009',1,'2025-01-21','2','V8818751',11820000,'0907666763','Caiyu',1737433350,'1','4381038829394221','08/29','','PHAM THI BE MUOI MOT',0,'577293',''),(5250399,'20250121V0001',1,'2025-01-21','3','V8819393',35460000,'0918667311','Caiyu',1737428914,'2','','','','HA THI DUYEN',0,'',''),(5250427,'20250121V0004',1,'2025-01-21','3','V8910387',22200000,'0918667311','Caiyu',1737429076,'1','','','','HA THI DUYEN',0,'',''),(5250451,'20250121V0006',1,'2025-01-21','3','V8910546',13524000,'0918667311','Caiyu',1737429420,'1','','','','HA THI DUYEN',0,'',''),(5251079,'20250121V0025',1,'2025-01-21','2','V8910552',22200000,'0888867171','Caiyu',1737439993,'1','4032801001506901','11/28','','PHAM VIET TOAN',0,'250080',''),(5251374,'20250121V0031',1,'2025-01-21','2','V8910820',22200000,'0913170733','Caiyu',1737447202,'1','5239756894711448','10/27','','THIEU HIEN NHI',0,'276485',''),(5250743,'20250121V0012',1,'2025-01-21','2','V8910918',3700000,'0907666763','Caiyu',1737434426,'1','539756896404026','10/28','','PHAM THI BE MUOI MOT',0,'262386',''),(5250744,'20250121V0013',1,'2025-01-21','2','V8910918',0,'0907666763','Caiyu',1737434473,'1','539756896404026','10/28','','PHAM THI BE MUOI MOT',0,'262386',''),(5250453,'20250121V0007',1,'2025-01-21','1','V8910989',13524000,'0918667311','Caiyu',1737429470,'1','','','','HA THI DUYEN',0,'',''),(5251299,'20250121V0030',1,'2025-01-21','3','V8911057',6939000,'0904556224','Caiyu',1737445747,'1','','','','NGO THI THANH DUNG',0,'',''),(5250417,'20250121V0002',1,'2025-01-21','3','V8911114',11820000,'0918667311','Caiyu',1737428958,'1','','','','HA THI DUYEN',0,'',''),(5251236,'20250121V0026',1,'2025-01-21','2','V8911121',3700000,'0939161659','Lisa',1737444590,'1','5268873000452355','01/26','','HUYNH THI BICH THAO',0,'276123',''),(5250716,'20250121V0011',1,'2025-01-21','2','V8911138',11820000,'0907666763','Caiyu',1737433773,'1','5239756896404026','10/28','','PHAM THI BE MUOI MOT',0,'262385',''),(5250794,'20250121V0022',1,'2025-01-21','2','V8911141',22200000,'0907666763','Caiyu',1737435204,'1','539756896404026 ','10/28','','PHAM THI BE MUOI MOT',0,'262387',''),(5250786,'20250121V0015',1,'2025-01-21','3','V8911143',22200000,'0935123405','Caiyu',1737435086,'1','','','','TRAN VAN HIEP ',0,'',''),(5250787,'20250121V0016',1,'2025-01-21','3','V8911143',0,'','Caiyu',1737435087,'1','','','','',0,'',''),(5250788,'20250121V0017',1,'2025-01-21','3','V8911143',0,'','Caiyu',1737435087,'1','','','','',0,'',''),(5250789,'20250121V0018',1,'2025-01-21','3','V8911143',0,'','Caiyu',1737435087,'1','','','','',0,'',''),(5250790,'20250121V0019',1,'2025-01-21','3','V8911143',0,'','Caiyu',1737435087,'1','','','','',0,'',''),(5250791,'20250121V0020',1,'2025-01-21','3','V8911143',0,'','Caiyu',1737435087,'1','','','','',0,'',''),(5250792,'20250121V0021',1,'2025-01-21','3','V8911143',0,'','Caiyu',1737435087,'1','','','','',0,'',''),(5251258,'20250121V0027',1,'2025-01-21','2','V8911144',11820000,'0939161659','Lisa',1737444957,'1','5268873000452355','01/26','','HUYNH THI BICH THAO',0,'293749',''),(5251284,'20250121V0029',1,'2025-01-21','2','V8911145',11820000,'0939161659','Lisa',1737445279,'1','5268873000452355','01/26 ','','HUYNH THI BICH THAO ',0,'289394',''),(5251272,'20250121V0028',1,'2025-01-21','2','V8911146',11820000,'0939161659','Lisa',1737445125,'1','5268873000452355','01/26','','HUYNH THI BICH THAO',0,'2082937','');


--
-- Host: 192.168.0.6    Database: eh
-- ------------------------------------------------------


--
-- Table structure for table `mbst`
--

CREATE TABLE `mbst` (
  `mb_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `boss_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `mb_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `mb_pwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `sex` int DEFAULT '0',
  `country` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `birthday` int DEFAULT '0',
  `birthday2` datetime DEFAULT NULL,
  `pg_date` int DEFAULT '0',
  `pg_date2` datetime DEFAULT NULL,
  `pg_yymm` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `pg_week_no` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tel1` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tel2` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tel3` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `post_no1` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `address1` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `post_no2` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `address2` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `post_no3` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `address3` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `true_intro_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `true_intro_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `intro_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `intro_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `bank_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `give_method` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ac_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `bank_ac` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ac_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `mb_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `id_kind` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `grade_class` smallint DEFAULT '0',
  `bgrade_class` smallint DEFAULT '0',
  `his_grade_class` smallint DEFAULT '0',
  `max_grade_class` smallint DEFAULT NULL,
  `level_no` smallint DEFAULT '0',
  `orgseq_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `level_no1` smallint DEFAULT '0',
  `orgseq_no1` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `line_kind` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `service_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `levellineflag` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ps` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `per_m` double DEFAULT '0',
  `per_sum` double DEFAULT NULL,
  `sorg_m` double DEFAULT '0',
  `org_sum` double DEFAULT '0',
  `org_m` double DEFAULT '0',
  `zip_pv` double DEFAULT '0',
  `update_user` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `data_timestamp` int DEFAULT NULL,
  `ok_g5_flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `out_side_givemoney` double DEFAULT NULL,
  `inside_givemoney` double DEFAULT NULL,
  `outside_tax` double DEFAULT NULL,
  `update_state` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `memo` text CHARACTER SET utf8 COLLATE utf8_bin,
  `memo2` text CHARACTER SET utf8 COLLATE utf8_bin,
  `chg_from_mb_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `chg_to_mb_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `intro_money` double DEFAULT NULL,
  `yymm` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `subtotal` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `tax2` double DEFAULT NULL,
  `givemoney` double DEFAULT '0',
  `per_subtotal` double DEFAULT NULL COMMENT '個人業務所得加總',
  `per_tax` double DEFAULT NULL,
  `per_givemoney` double DEFAULT NULL,
  `other_subtotal` double DEFAULT NULL,
  `other_tax` double DEFAULT NULL,
  `other_givemoney` double DEFAULT NULL,
  `g1_line_num` smallint DEFAULT NULL,
  `g2_line_num` smallint DEFAULT NULL,
  `g3_line_num` smallint DEFAULT NULL,
  `g4_line_num` smallint DEFAULT NULL,
  `g5_line_num` smallint DEFAULT NULL,
  `g6_line_num` smallint DEFAULT NULL,
  `g7_line_num` smallint DEFAULT NULL,
  `g8_line_num` smallint DEFAULT NULL,
  `g9_line_num` smallint DEFAULT NULL,
  `g10_line_num` smallint DEFAULT NULL,
  `g1_sorg_m` double DEFAULT NULL,
  `g2_sorg_m` double DEFAULT NULL,
  `g3_sorg_m` double DEFAULT NULL,
  `g4_sorg_m` double DEFAULT NULL,
  `g5_sorg_m` double DEFAULT NULL,
  `g6_sorg_m` double DEFAULT NULL,
  `g7_sorg_m` double DEFAULT NULL,
  `g8_sorg_m` double DEFAULT NULL,
  `g9_sorg_m` double DEFAULT NULL,
  `g10_sorg_m` double DEFAULT NULL,
  `area_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `rescission_date` int DEFAULT NULL,
  `levellineflag1` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `verify` int DEFAULT '0' COMMENT '0-未核單1-已核單',
  `verify_date` datetime DEFAULT NULL,
  `invoice_flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `pay_flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `remark_str` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `a_line_subs` int DEFAULT '0',
  `b_line_subs` int DEFAULT '0',
  `a_line_subs_old` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `b_line_subs_old` int DEFAULT '0',
  `per_m_new` double DEFAULT '0',
  `per_m_rebuy` double DEFAULT '0',
  `per_m_over` double DEFAULT '0',
  `per_m_new_sum` double DEFAULT '0',
  `week_no` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `ab_money` double DEFAULT '0',
  `lead_money` double DEFAULT '0',
  `red_money` double DEFAULT '0',
  `red3_money` double DEFAULT '0',
  `red7_money` double DEFAULT '0',
  `true_a_line_subs` int DEFAULT '0',
  `true_b_line_subs` int DEFAULT '0',
  `ab_k_val` float DEFAULT '0',
  `lead_k_val` float DEFAULT '0',
  `circle_plus` double DEFAULT '0',
  `circle_minus` double DEFAULT '0',
  `circle_bottom` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `intro_sum` smallint DEFAULT '0',
  `ok_give_money_flag` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `org_money` double DEFAULT '0',
  `red1_money` double DEFAULT '0',
  `red2_money` double DEFAULT '0',
  `turn_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `turn_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `a_intro_new` smallint DEFAULT '0',
  `b_intro_new` smallint DEFAULT '0',
  `c_intro_new` smallint DEFAULT '0',
  `a_intro_sum` smallint DEFAULT '0',
  `b_intro_sum` smallint DEFAULT '0',
  `c_intro_sum` smallint DEFAULT '0',
  `a_line_m` double DEFAULT '0',
  `b_line_m` double DEFAULT '0',
  `c_line_m` double DEFAULT '0',
  `a_line_sum` double DEFAULT '0',
  `b_line_sum` double DEFAULT '0',
  `c_line_sum` double DEFAULT '0',
  `change_tax` double DEFAULT '1',
  `pg_yymm2` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `data_ok_flag` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `remit_day` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `remit_yymm` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `nopay_money` double DEFAULT '0',
  `net_cost` double DEFAULT '0',
  `net_yymm` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `true_pay_money` double DEFAULT '0',
  `invoice_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `show_date` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `intro_num` smallint DEFAULT '0',
  `passlv5_week` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `passlv6_week` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `passlv7_week` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `passlv8_week` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `under_m` double DEFAULT '0',
  `under_m2` double DEFAULT '0',
  `chk_week` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `city1` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `area1` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `add1` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `full_add1` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `city2` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `area2` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `add2` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `full_add2` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `city3` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `area3` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `add3` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `full_add3` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `auto_send` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `auto_paid` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `auto_order` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `active_ball` int DEFAULT '1',
  `active_no` int DEFAULT '1',
  `sub_web` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT '啟動子網',
  `sub_start_date` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '子網開通日',
  `sub_end_date` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '子網到期日',
  `ord_moneys` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `dealer` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `manager` smallint DEFAULT '0',
  `auto_sum` int DEFAULT '0',
  `org_order` double DEFAULT '0',
  `new_add` int DEFAULT '0',
  `org_num` int DEFAULT '0',
  `qu_num` int DEFAULT '0',
  `org_six` double DEFAULT '0',
  `euro` double DEFAULT '0',
  `calc` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `gold_money` double DEFAULT '0',
  `red_org_m` double DEFAULT '0',
  `retain_money` double DEFAULT '0',
  `retain_yymm` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `last_per_m` double DEFAULT '0',
  `this_per_m` double DEFAULT '0',
  `up_to_intro` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0',
  `gold_per_m` double DEFAULT '0',
  `org_count` int DEFAULT '0',
  `reserve` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `car_check` int DEFAULT '0',
  `appoint` int DEFAULT '0',
  `boss_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `mb_name2` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `notice_memo` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `join_date` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `create_date` datetime DEFAULT NULL,
  `create_user` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `nhisp` int DEFAULT NULL,
  `boss_name_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `stop_date` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `bank_branch_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`mb_no`),
  KEY `Inx_mb_name` (`mb_name`),
  KEY `Inx_boss_id` (`boss_id`),
  KEY `Inx_country` (`country`),
  KEY `Inx_tel1` (`tel1`),
  KEY `Inx_tel2` (`tel2`),
  KEY `Inx_tel3` (`tel3`),
  KEY `Inx_orgseq_no1` (`orgseq_no1`),
  KEY `Inx_true_intro_no` (`true_intro_no`),
  KEY `Inx_mb_status` (`mb_status`),
  KEY `Inx_level_no1` (`level_no1`) /*!80000 INVISIBLE */,
  KEY `Inx_mb_ture` (`mb_no`,`true_intro_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `mbst`
--
-- WHERE:  pg_date2>='2025-01-21' and mb_no like 'V%'

INSERT INTO `mbst` VALUES ('V8911140','022176007245','PHẠM THANH MIỀN  范青綿','19760430',0,'V',199641600,'1976-04-30 00:00:00',1737426829,'2025-01-21 00:00:00','202501','202501','','','','0915255265 ',NULL,NULL,NULL,NULL,NULL,NULL,'V8911034','NGUYỄN THỊ HOÀI 阮氏懷',NULL,'','','VPBKVNVX','PHẠM THANH MIỀN - CN HÀ NỘI','222705185','022176007245','1','1',0,0,0,NULL,0,NULL,17,'010606230635014107050106150101010901','',NULL,NULL,NULL,0,NULL,0,0,0,0,'Lisa',1737426829,NULL,NULL,NULL,NULL,'1','',NULL,NULL,NULL,NULL,'202501',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'└',0,NULL,NULL,NULL,NULL,0,0,NULL,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0,0,'',0,NULL,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,1,NULL,'0',NULL,NULL,0,0,'0',0,'',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'191 LÒ ĐỨC , ĐÔNG MÁC , HAI BÀ TRƯNG , HÀ NỘI. ','191 LÒ ĐỨC , ĐÔNG MÁC , HAI BÀ TRƯNG , HÀ NỘI. ',NULL,NULL,'191 LÒ ĐỨC , ĐÔNG MÁC , HAI BÀ TRƯNG , HÀ NỘI. ','191 LÒ ĐỨC , ĐÔNG MÁC , HAI BÀ TRƯNG , HÀ NỘI. ',NULL,NULL,'191 LÒ ĐỨC , ĐÔNG MÁC , HAI BÀ TRƯNG , HÀ NỘI. ','191 LÒ ĐỨC , ĐÔNG MÁC , HAI BÀ TRƯNG , HÀ NỘI. ',NULL,NULL,'0',1,1,'0',NULL,NULL,NULL,'0',0,0,0,0,0,0,0,0,'0',0,0,0,NULL,0,0,'0',0,0,'',0,0,'','10/07/2021 CTCCSQLHCVTTXH','','2025-01-21','2025-01-21 10:33:49','Lisa',NULL,'','',NULL),('V8911141','001176056140','NGUYỄN THỊ PHƯƠNG LAN 阮氏芳蘭','19760820',0,'V',209318400,'1976-08-20 00:00:00',1737431226,'2025-01-21 00:00:00','202501','202501','','','','0987142757',NULL,NULL,NULL,NULL,NULL,NULL,'V8911137','LÊ THỊ THU HÀ 黎氏秋霞',NULL,'','','VTCBVNVX','NGUYỄN THỊ PHƯƠNG LAN - CN HAI PHONG','19128644309999','001176056140','1','1',1,0,0,NULL,0,NULL,11,'010606232201220405030501','',NULL,NULL,NULL,500,NULL,0,0,0,0,'Caiyu',1737431226,NULL,NULL,NULL,NULL,'1','',NULL,NULL,NULL,NULL,'202501',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'└',0,NULL,NULL,NULL,NULL,0,0,NULL,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0,0,'',0,NULL,0,0,0,NULL,NULL,1,0,0,0,0,0,1,0,0,500,0,0,1,NULL,'0',NULL,NULL,0,0,'0',0,'',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'168B AN ĐÀ, ĐẰNG GIANG, NGÔ QUYỀN, HẢI PHÒNG','168B AN ĐÀ, ĐẰNG GIANG, NGÔ QUYỀN, HẢI PHÒNG',NULL,NULL,'168B AN ĐÀ, ĐẰNG GIANG, NGÔ QUYỀN, HẢI PHÒNG','168B AN ĐÀ, ĐẰNG GIANG, NGÔ QUYỀN, HẢI PHÒNG',NULL,NULL,'168B AN ĐÀ, ĐẰNG GIANG, NGÔ QUYỀN, HẢI PHÒNG','168B AN ĐÀ, ĐẰNG GIANG, NGÔ QUYỀN, HẢI PHÒNG',NULL,NULL,'0',1,1,'0',NULL,NULL,NULL,'0',0,0,0,0,0,0,0,0,'0',0,0,0,NULL,0,500,'0',0,0,'',0,0,'','28/04/2022 CCSQLHCVTTXH','','2025-01-21','2025-01-21 11:47:06','Caiyu',NULL,'','',NULL),('V8911142','038186029133','LÊ NGỌC ANH  黎玉英','19861008',0,'V',529084800,'1986-10-08 00:00:00',1737432062,'2025-01-21 00:00:00','202501','202501','','','','0915393375',NULL,NULL,NULL,NULL,NULL,NULL,'V8910489','NGUYỄN THỊ QUÝ 阮氏貴',NULL,'','','SHBVNVX','LÊ NGỌC ANH - CN THANH HOA','0915393375','038186029133','1','1',0,0,0,NULL,0,NULL,11,'010606232201190301400102','',NULL,NULL,NULL,0,NULL,0,0,0,0,'Caiyu',1737432062,NULL,NULL,NULL,NULL,'1','',NULL,NULL,NULL,NULL,'202501',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'└',0,NULL,NULL,NULL,NULL,0,0,NULL,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0,0,'',0,NULL,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,1,NULL,'0',NULL,NULL,0,0,'0',0,'',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'114 TỪ ĐẠO HẠNH, ĐÔNG THỌ, TP THANH HÓA, THANH HÓA','114 TỪ ĐẠO HẠNH, ĐÔNG THỌ, TP THANH HÓA, THANH HÓA',NULL,NULL,'114 TỪ ĐẠO HẠNH, ĐÔNG THỌ, TP THANH HÓA, THANH HÓA','114 TỪ ĐẠO HẠNH, ĐÔNG THỌ, TP THANH HÓA, THANH HÓA',NULL,NULL,'114 TỪ ĐẠO HẠNH, ĐÔNG THỌ, TP THANH HÓA, THANH HÓA','114 TỪ ĐẠO HẠNH, ĐÔNG THỌ, TP THANH HÓA, THANH HÓA',NULL,NULL,'0',1,1,'0',NULL,NULL,NULL,'0',0,0,0,0,0,0,0,0,'0',0,0,0,NULL,0,0,'0',0,0,'',0,0,'','02/08/2024 CCSQLHCVTTXH','','2025-01-21','2025-01-21 12:01:02','Caiyu',NULL,'','',NULL),('V8911143','052170005408','TRẦN THỊ DUNG 陳氏蓉','19700412',0,'V',8697600,'1970-04-12 00:00:00',1737434218,'2025-01-21 00:00:00','202501','202501','','','','0857979678',NULL,NULL,NULL,NULL,NULL,NULL,'V8910553','NGUYỄN THỊ HIỀN 阮氏賢',NULL,'','','ASCBVNVX','TRẦN THỊ DUNG - CN BINH PHUOC','252168749','052170005408','1','1',0,0,0,NULL,0,NULL,13,'0106062306350141030102050502','',NULL,NULL,NULL,100,NULL,0,0,0,0,'Caiyu',1737434218,NULL,NULL,NULL,NULL,'1','',NULL,NULL,NULL,NULL,'202501',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'└',0,NULL,NULL,NULL,NULL,0,0,NULL,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0,0,'',0,NULL,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,100,0,0,1,NULL,'0',NULL,NULL,0,0,'0',0,'',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC',NULL,NULL,'KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC',NULL,NULL,'KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC','KP TÂN BÌNH, TÂN BÌNH, THÀNH PHỐ ĐỒNG XOÀI, BÌNH PHƯỚC',NULL,NULL,'0',1,1,'0',NULL,NULL,NULL,'0',0,0,0,0,0,0,0,0,'0',0,0,0,NULL,0,100,'0',0,0,'',0,0,'','02/07/2021 CCSQLHCVTTXH','','2025-01-21','2025-01-21 12:36:58','Caiyu',NULL,'','',NULL),('V8911144','079201025228','HUỲNH ANH TUẤN 黃英俊','20010203',1,'V',981129600,'2001-02-03 00:00:00',1737435899,'2025-01-21 00:00:00','202501','202501','','','','0938255067',NULL,NULL,NULL,NULL,NULL,NULL,'V8911121','TRỊNH THỊ CÚC 鄭氏菊',NULL,'','','BFTVVNVX','HUỲNH ANH TUẤN - CN HCM','1012332091','079201025228','1','1',0,0,0,NULL,0,NULL,15,'01060623063501410301020501020201','',NULL,NULL,NULL,240,NULL,0,0,0,0,'Caiyu',1737435899,NULL,NULL,NULL,NULL,'1','',NULL,NULL,NULL,NULL,'202501',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0,0,'',0,NULL,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,240,0,0,1,NULL,'0',NULL,NULL,0,0,'0',0,'',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'266/10/7A LÊ TRỌNG TẤN, TÂY THẠNH, TÂN PHÚ, TPHCM ','266/10/7A LÊ TRỌNG TẤN, TÂY THẠNH, TÂN PHÚ, TPHCM ',NULL,NULL,'266/10/7A LÊ TRỌNG TẤN, TÂY THẠNH, TÂN PHÚ, TPHCM ','266/10/7A LÊ TRỌNG TẤN, TÂY THẠNH, TÂN PHÚ, TPHCM ',NULL,NULL,'266/10/7A LÊ TRỌNG TẤN, TÂY THẠNH, TÂN PHÚ, TPHCM ','266/10/7A LÊ TRỌNG TẤN, TÂY THẠNH, TÂN PHÚ, TPHCM ',NULL,NULL,'0',1,1,'0',NULL,NULL,NULL,'0',0,0,0,0,0,0,0,0,'0',0,0,0,NULL,0,240,'0',0,0,'',0,0,'','12/01/2022 CCSQLHCVTTXH','','2025-01-21','2025-01-21 13:04:59','Caiyu',NULL,'','',NULL),('V8911145','052300014003','PHAN MỸ LINH 潘美玲','20000917',0,'V',969120000,'2000-09-17 00:00:00',1737436141,'2025-01-21 00:00:00','202501','202501','','','','0908271363',NULL,NULL,NULL,NULL,NULL,NULL,'V8911121','TRỊNH THỊ CÚC 鄭氏菊',NULL,'','','MSCBVNVX','PHAN MỸ LINH - CN HCM','0984478115','052300014003','1','1',0,0,0,NULL,0,NULL,15,'01060623063501410301020501020202','',NULL,NULL,NULL,240,NULL,0,0,0,0,'Caiyu',1737436141,NULL,NULL,NULL,NULL,'1','',NULL,NULL,NULL,NULL,'202501',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0,0,'',0,NULL,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,240,0,0,1,NULL,'0',NULL,NULL,0,0,'0',0,'',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'453/70/42 LÊ VĂN KHƯƠNG, KP5, HIỆP THÀNH, QUẬN 12, TPHCM','453/70/42 LÊ VĂN KHƯƠNG, KP5, HIỆP THÀNH, QUẬN 12, TPHCM',NULL,NULL,'453/70/42 LÊ VĂN KHƯƠNG, KP5, HIỆP THÀNH, QUẬN 12, TPHCM','453/70/42 LÊ VĂN KHƯƠNG, KP5, HIỆP THÀNH, QUẬN 12, TPHCM',NULL,NULL,'453/70/42 LÊ VĂN KHƯƠNG, KP5, HIỆP THÀNH, QUẬN 12, TPHCM','453/70/42 LÊ VĂN KHƯƠNG, KP5, HIỆP THÀNH, QUẬN 12, TPHCM',NULL,NULL,'0',1,1,'0',NULL,NULL,NULL,'0',0,0,0,0,0,0,0,0,'0',0,0,0,NULL,0,240,'0',0,0,'',0,0,'','22/11/2021 CCSQLHCVTTXH','','2025-01-21','2025-01-21 13:09:01','Caiyu',NULL,'','',NULL),('V8911146','066079000018','PHAN NGỌC HOÀNG 潘玉皇','19790203',1,'V',286819200,'1979-02-03 00:00:00',1737436398,'2025-01-21 00:00:00','202501','202501','','','','0816000777',NULL,NULL,NULL,NULL,NULL,NULL,'V8911121','TRỊNH THỊ CÚC 鄭氏菊',NULL,'','','MSCBVNVX','PHAN NGỌC HOÀNG - CN HCM','0916000777','066079000018','1','1',0,0,0,NULL,0,NULL,15,'01060623063501410301020501020203','',NULL,NULL,NULL,240,NULL,0,0,0,0,'Caiyu',1737436398,NULL,NULL,NULL,NULL,'1','',NULL,NULL,NULL,NULL,'202501',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'└',0,NULL,NULL,NULL,NULL,0,0,NULL,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0,0,'',0,NULL,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,240,0,0,1,NULL,'0',NULL,NULL,0,0,'0',0,'',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'2.24 LÔ D, CC LẠC LONG QUÂN, PHƯỜNG 05, QUẬN 11, TPHCM','2.24 LÔ D, CC LẠC LONG QUÂN, PHƯỜNG 05, QUẬN 11, TPHCM',NULL,NULL,'2.24 LÔ D, CC LẠC LONG QUÂN, PHƯỜNG 05, QUẬN 11, TPHCM','2.24 LÔ D, CC LẠC LONG QUÂN, PHƯỜNG 05, QUẬN 11, TPHCM',NULL,NULL,'2.24 LÔ D, CC LẠC LONG QUÂN, PHƯỜNG 05, QUẬN 11, TPHCM','2.24 LÔ D, CC LẠC LONG QUÂN, PHƯỜNG 05, QUẬN 11, TPHCM',NULL,NULL,'0',1,1,'0',NULL,NULL,NULL,'0',0,0,0,0,0,0,0,0,'0',0,0,0,NULL,0,240,'0',0,0,'',0,0,'','07/06/2022 CCSQLHCVTTXH','','2025-01-21','2025-01-21 13:13:18','Caiyu',NULL,'','',NULL),('V8911147','049187002065','TRẦN THỊ THANH SANG 陳氏清商','19870707',0,'V',552585600,'1987-07-07 00:00:00',1737437041,'2025-01-21 00:00:00','202501','202501','','','','0931180189',NULL,NULL,NULL,NULL,NULL,NULL,'V8911105','TRẦN NGỌC TRIỆU 陳玉赵',NULL,'','','MSCBVNVX','TRẦN THỊ THANH SANG 陳氏清商','0931180189','049187002065','1','1',0,0,0,NULL,0,NULL,13,'0106062322011902090301500101','',NULL,NULL,NULL,0,NULL,0,0,0,0,'Lisa',1737437041,NULL,NULL,NULL,NULL,'1','',NULL,NULL,NULL,NULL,'202501',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'└',0,NULL,NULL,NULL,NULL,0,0,NULL,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,0,0,0,'',0,NULL,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,1,NULL,'0',NULL,NULL,0,0,'0',0,'',NULL,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'47 LÝ TỰ TRỌNG , THỐNG NHẤT ,THÀNH PHỐ KON TUM, KON TUM .','47 LÝ TỰ TRỌNG , THỐNG NHẤT ,THÀNH PHỐ KON TUM, KON TUM .',NULL,NULL,'86 LÊ LAI, P. TÂY SƠN ,TP PLEIKU , T. GIA LAI ','86 LÊ LAI, P. TÂY SƠN ,TP PLEIKU , T. GIA LAI ',NULL,NULL,'86 LÊ LAI, P. TÂY SƠN ,TP PLEIKU , T. GIA LAI ','86 LÊ LAI, P. TÂY SƠN ,TP PLEIKU , T. GIA LAI ',NULL,NULL,'0',1,1,'0',NULL,NULL,NULL,'0',0,0,0,0,0,0,0,0,'0',0,0,0,NULL,0,0,'0',0,0,'',0,0,'','27/06/2021 CTCCSQLHCVTTXH','','2025-01-21','2025-01-21 13:24:01','Lisa',NULL,'','',NULL);


--
-- Host: 192.168.0.6    Database: eh
-- ------------------------------------------------------


--
-- Table structure for table `date_tb`
--

CREATE TABLE `date_tb` (
  `id` smallint NOT NULL AUTO_INCREMENT,
  `week_no` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `yymm` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `start_date` datetime NOT NULL,
  `cut_date` datetime NOT NULL,
  `show` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT 'N',
  `show_week` char(1) COLLATE utf8_bin DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=786 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `date_tb`
--
-- WHERE:  1=1

INSERT INTO `date_tb` VALUES (570,'201001','201001','2010-01-01 00:00:00','2010-01-31 00:00:00','Y','N'),(571,'201002','201002','2010-02-01 00:00:00','2010-02-28 00:00:00','Y','N'),(572,'201003','201003','2010-03-01 00:00:00','2010-03-31 00:00:00','Y','N'),(573,'201004','201004','2010-04-01 00:00:00','2010-04-30 00:00:00','Y','N'),(574,'201005','201005','2010-05-01 00:00:00','2010-05-31 00:00:00','Y','N'),(575,'201006','201006','2010-06-01 00:00:00','2010-06-30 00:00:00','Y','N'),(576,'201007','201007','2010-07-01 00:00:00','2010-07-31 00:00:00','Y','N'),(577,'201008','201008','2010-08-01 00:00:00','2010-08-31 00:00:00','Y','N'),(578,'201009','201009','2010-09-01 00:00:00','2010-09-30 00:00:00','Y','N'),(579,'201010','201010','2010-10-01 00:00:00','2010-10-31 00:00:00','Y','N'),(580,'201011','201011','2010-11-01 00:00:00','2010-11-30 00:00:00','Y','N'),(581,'201012','201012','2010-12-01 00:00:00','2010-12-31 00:00:00','Y','N'),(582,'201101','201101','2011-01-01 00:00:00','2011-01-31 00:00:00','Y','N'),(583,'201102','201102','2011-02-01 00:00:00','2011-02-28 00:00:00','Y','N'),(584,'201103','201103','2011-03-01 00:00:00','2011-03-31 00:00:00','Y','N'),(585,'201104','201104','2011-04-01 00:00:00','2011-04-30 00:00:00','Y','N'),(586,'201105','201105','2011-05-01 00:00:00','2011-05-31 00:00:00','Y','N'),(587,'201106','201106','2011-06-01 00:00:00','2011-06-30 00:00:00','Y','N'),(588,'201107','201107','2011-07-01 00:00:00','2011-07-31 00:00:00','Y','N'),(589,'201108','201108','2011-08-01 00:00:00','2011-08-31 00:00:00','Y','N'),(590,'201109','201109','2011-09-01 00:00:00','2011-09-30 00:00:00','Y','N'),(591,'201110','201110','2011-10-01 00:00:00','2011-10-31 00:00:00','Y','N'),(592,'201111','201111','2011-11-01 00:00:00','2011-11-30 00:00:00','Y','N'),(593,'201112','201112','2011-12-01 00:00:00','2011-12-31 00:00:00','Y','N'),(594,'201201','201201','2012-01-01 00:00:00','2012-01-31 00:00:00','Y','N'),(595,'201202','201202','2012-02-01 00:00:00','2012-02-29 00:00:00','Y','N'),(596,'201203','201203','2012-03-01 00:00:00','2012-03-31 00:00:00','Y','N'),(597,'201204','201204','2012-04-01 00:00:00','2012-04-30 00:00:00','Y','N'),(598,'201205','201205','2012-05-01 00:00:00','2012-05-31 00:00:00','Y','N'),(599,'201206','201206','2012-06-01 00:00:00','2012-06-30 00:00:00','Y','N'),(600,'201207','201207','2012-07-01 00:00:00','2012-07-31 00:00:00','Y','N'),(601,'201208','201208','2012-08-01 00:00:00','2012-08-31 00:00:00','Y','N'),(602,'201209','201209','2012-09-01 00:00:00','2012-09-30 00:00:00','Y','N'),(603,'201210','201210','2012-10-01 00:00:00','2012-10-31 00:00:00','Y','N'),(604,'201211','201211','2012-11-01 00:00:00','2012-11-30 00:00:00','Y','N'),(605,'201212','201212','2012-12-01 00:00:00','2012-12-31 00:00:00','Y','N'),(606,'201301','201301','2013-01-01 00:00:00','2013-01-31 00:00:00','Y','N'),(607,'201302','201302','2013-02-01 00:00:00','2013-02-28 00:00:00','Y','N'),(608,'201303','201303','2013-03-01 00:00:00','2013-03-31 00:00:00','Y','N'),(609,'201304','201304','2013-04-01 00:00:00','2013-04-30 00:00:00','Y','N'),(610,'201305','201305','2013-05-01 00:00:00','2013-05-31 00:00:00','Y','N'),(611,'201306','201306','2013-06-01 00:00:00','2013-06-30 00:00:00','Y','N'),(612,'201307','201307','2013-07-01 00:00:00','2013-07-31 00:00:00','Y','N'),(613,'201308','201308','2013-08-01 00:00:00','2013-08-31 00:00:00','Y','N'),(614,'201309','201309','2013-09-01 00:00:00','2013-09-30 00:00:00','Y','N'),(615,'201310','201310','2013-10-01 00:00:00','2013-10-31 00:00:00','Y','N'),(616,'201311','201311','2013-11-01 00:00:00','2013-11-30 00:00:00','Y','N'),(617,'201312','201312','2013-12-01 00:00:00','2013-12-31 00:00:00','Y','N'),(618,'201401','201401','2014-01-01 00:00:00','2014-01-31 00:00:00','Y','N'),(619,'201402','201402','2014-02-01 00:00:00','2014-02-28 00:00:00','Y','N'),(620,'201403','201403','2014-03-01 00:00:00','2014-03-31 00:00:00','Y','N'),(621,'201404','201404','2014-04-01 00:00:00','2014-04-30 00:00:00','Y','N'),(622,'201405','201405','2014-05-01 00:00:00','2014-05-31 00:00:00','Y','N'),(623,'201406','201406','2014-06-01 00:00:00','2014-06-30 00:00:00','Y','N'),(624,'201407','201407','2014-07-01 00:00:00','2014-07-31 00:00:00','Y','N'),(625,'201408','201408','2014-08-01 00:00:00','2014-08-31 00:00:00','Y','N'),(626,'201409','201409','2014-09-01 00:00:00','2014-09-30 00:00:00','Y','N'),(627,'201410','201410','2014-10-01 00:00:00','2014-10-31 00:00:00','Y','N'),(628,'201411','201411','2014-11-01 00:00:00','2014-11-30 00:00:00','Y','N'),(629,'201412','201412','2014-12-01 00:00:00','2014-12-31 00:00:00','Y','N'),(630,'201501','201501','2015-01-01 00:00:00','2015-01-31 00:00:00','Y','N'),(631,'201502','201502','2015-02-01 00:00:00','2015-02-28 00:00:00','Y','N'),(632,'201503','201503','2015-03-01 00:00:00','2015-03-31 00:00:00','Y','N'),(633,'201504','201504','2015-04-01 00:00:00','2015-04-30 00:00:00','Y','N'),(634,'201505','201505','2015-05-01 00:00:00','2015-05-31 00:00:00','Y','N'),(635,'201506','201506','2015-06-01 00:00:00','2015-06-30 00:00:00','Y','N'),(636,'201507','201507','2015-07-01 00:00:00','2015-07-31 00:00:00','Y','N'),(637,'201508','201508','2015-08-01 00:00:00','2015-08-31 00:00:00','Y','N'),(638,'201509','201509','2015-09-01 00:00:00','2015-09-30 00:00:00','Y','N'),(639,'201510','201510','2015-10-01 00:00:00','2015-10-31 00:00:00','Y','N'),(640,'201511','201511','2015-11-01 00:00:00','2015-11-30 00:00:00','Y','N'),(641,'201512','201512','2015-12-01 00:00:00','2015-12-31 00:00:00','Y','N'),(642,'201601','201601','2016-01-01 00:00:00','2016-01-31 00:00:00','Y','N'),(643,'201602','201602','2016-02-01 00:00:00','2016-02-29 00:00:00','Y','N'),(644,'201603','201603','2016-03-01 00:00:00','2016-03-31 00:00:00','Y','N'),(645,'201604','201604','2016-04-01 00:00:00','2016-04-30 00:00:00','Y','N'),(646,'201605','201605','2016-05-01 00:00:00','2016-05-31 00:00:00','Y','N'),(647,'201606','201606','2016-06-01 00:00:00','2016-06-30 00:00:00','Y','N'),(648,'201607','201607','2016-07-01 00:00:00','2016-07-31 00:00:00','Y','N'),(649,'201608','201608','2016-08-01 00:00:00','2016-08-31 00:00:00','Y','N'),(650,'201609','201609','2016-09-01 00:00:00','2016-09-30 00:00:00','Y','N'),(651,'201610','201610','2016-10-01 00:00:00','2016-10-31 00:00:00','Y','N'),(652,'201611','201611','2016-11-01 00:00:00','2016-11-30 00:00:00','Y','N'),(653,'201612','201612','2016-12-01 00:00:00','2016-12-31 00:00:00','Y','N'),(654,'201701','201701','2017-01-01 00:00:00','2017-01-31 00:00:00','Y','N'),(655,'201702','201702','2017-02-01 00:00:00','2017-02-28 00:00:00','Y','N'),(656,'201703','201703','2017-03-01 00:00:00','2017-03-31 00:00:00','Y','N'),(657,'201704','201704','2017-04-01 00:00:00','2017-04-30 00:00:00','Y','N'),(658,'201705','201705','2017-05-01 00:00:00','2017-05-31 00:00:00','Y','N'),(659,'201706','201706','2017-06-01 00:00:00','2017-06-30 00:00:00','Y','N'),(660,'201707','201707','2017-07-01 00:00:00','2017-07-31 00:00:00','Y','N'),(661,'201708','201708','2017-08-01 00:00:00','2017-08-31 00:00:00','Y','N'),(662,'201709','201709','2017-09-01 00:00:00','2017-09-30 00:00:00','Y','N'),(663,'201710','201710','2017-10-01 00:00:00','2017-10-31 00:00:00','Y','N'),(664,'201711','201711','2017-11-01 00:00:00','2017-11-30 00:00:00','Y','N'),(665,'201712','201712','2017-12-01 00:00:00','2017-12-31 00:00:00','Y','N'),(690,'201801','201801','2018-01-01 00:00:00','2018-01-31 00:00:00','Y','N'),(691,'201802','201802','2018-02-01 00:00:00','2018-02-28 00:00:00','Y','N'),(692,'201803','201803','2018-03-01 00:00:00','2018-03-31 00:00:00','Y','N'),(693,'201804','201804','2018-04-01 00:00:00','2018-04-30 00:00:00','Y','N'),(694,'201805','201805','2018-05-01 00:00:00','2018-05-31 00:00:00','Y','N'),(695,'201806','201806','2018-06-01 00:00:00','2018-06-30 00:00:00','Y','N'),(696,'201807','201807','2018-07-01 00:00:00','2018-07-31 00:00:00','Y','N'),(697,'201808','201808','2018-08-01 00:00:00','2018-08-31 00:00:00','Y','N'),(698,'201809','201809','2018-09-01 00:00:00','2018-09-30 00:00:00','Y','N'),(699,'201810','201810','2018-10-01 00:00:00','2018-10-31 00:00:00','Y','N'),(700,'201811','201811','2018-11-01 00:00:00','2018-11-30 00:00:00','Y','N'),(701,'201812','201812','2018-12-01 00:00:00','2018-12-31 00:00:00','Y','N'),(702,'201901','201901','2019-01-01 00:00:00','2019-01-31 00:00:00','Y','N'),(703,'201902','201902','2019-02-01 00:00:00','2019-02-28 00:00:00','Y','N'),(704,'201903','201903','2019-03-01 00:00:00','2019-03-31 00:00:00','Y','N'),(705,'201904','201904','2019-04-01 00:00:00','2019-04-30 00:00:00','Y','N'),(706,'201905','201905','2019-05-01 00:00:00','2019-05-31 00:00:00','Y','N'),(707,'201906','201906','2019-06-01 00:00:00','2019-06-30 00:00:00','Y','N'),(708,'201907','201907','2019-07-01 00:00:00','2019-07-31 00:00:00','Y','N'),(709,'201908','201908','2019-08-01 00:00:00','2019-08-31 00:00:00','Y','N'),(710,'201909','201909','2019-09-01 00:00:00','2019-09-30 00:00:00','Y','N'),(711,'201910','201910','2019-10-01 00:00:00','2019-10-31 00:00:00','Y','N'),(712,'201911','201911','2019-11-01 00:00:00','2019-11-30 00:00:00','Y','N'),(713,'201912','201912','2019-12-01 00:00:00','2019-12-31 00:00:00','Y','N'),(714,'202001','202001','2020-01-01 00:00:00','2020-01-31 00:00:00','Y','N'),(715,'202002','202002','2020-02-01 00:00:00','2020-02-29 00:00:00','Y','N'),(716,'202003','202003','2020-03-01 00:00:00','2020-03-31 00:00:00','Y','N'),(717,'202004','202004','2020-04-01 00:00:00','2020-04-30 00:00:00','Y','N'),(718,'202005','202005','2020-05-01 00:00:00','2020-05-31 00:00:00','Y','N'),(719,'202006','202006','2020-06-01 00:00:00','2020-06-30 00:00:00','Y','N'),(720,'202007','202007','2020-07-01 00:00:00','2020-07-31 00:00:00','Y','N'),(721,'202008','202008','2020-08-01 00:00:00','2020-08-31 00:00:00','Y','N'),(722,'202009','202009','2020-09-01 00:00:00','2020-09-30 00:00:00','Y','N'),(723,'202010','202010','2020-10-01 00:00:00','2020-10-31 00:00:00','Y','N'),(724,'202011','202011','2020-11-01 00:00:00','2020-11-30 00:00:00','Y','N'),(725,'202012','202012','2020-12-01 00:00:00','2020-12-31 00:00:00','Y','N'),(726,'202101','202101','2021-01-01 00:00:00','2021-01-31 00:00:00','Y','N'),(727,'202102','202102','2021-02-01 00:00:00','2021-02-28 00:00:00','Y','N'),(728,'202103','202103','2021-03-01 00:00:00','2021-03-31 00:00:00','Y','N'),(729,'202104','202104','2021-04-01 00:00:00','2021-04-30 00:00:00','Y','N'),(730,'202105','202105','2021-05-01 00:00:00','2021-05-31 00:00:00','Y','N'),(731,'202106','202106','2021-06-01 00:00:00','2021-06-30 00:00:00','Y','N'),(732,'202107','202107','2021-07-01 00:00:00','2021-07-31 00:00:00','Y','N'),(733,'202108','202108','2021-08-01 00:00:00','2021-08-31 00:00:00','Y','N'),(734,'202109','202109','2021-09-01 00:00:00','2021-09-30 00:00:00','Y','N'),(735,'202110','202110','2021-10-01 00:00:00','2021-10-31 00:00:00','Y','N'),(736,'202111','202111','2021-11-01 00:00:00','2021-11-30 00:00:00','Y','N'),(737,'202112','202112','2021-12-01 00:00:00','2021-12-31 00:00:00','Y','N'),(738,'202201','202201','2022-01-01 00:00:00','2022-01-31 00:00:00','Y','N'),(739,'202202','202202','2022-02-01 00:00:00','2022-02-28 00:00:00','Y','N'),(740,'202203','202203','2022-03-01 00:00:00','2022-03-31 00:00:00','Y','N'),(741,'202204','202204','2022-04-01 00:00:00','2022-04-30 00:00:00','Y','N'),(742,'202205','202205','2022-05-01 00:00:00','2022-05-31 00:00:00','Y','N'),(743,'202206','202206','2022-06-01 00:00:00','2022-06-30 00:00:00','Y','N'),(744,'202207','202207','2022-07-01 00:00:00','2022-07-31 00:00:00','Y','N'),(745,'202208','202208','2022-08-01 00:00:00','2022-08-31 00:00:00','Y','N'),(746,'202209','202209','2022-09-01 00:00:00','2022-09-30 00:00:00','Y','N'),(747,'202210','202210','2022-10-01 00:00:00','2022-10-31 00:00:00','Y','N'),(748,'202211','202211','2022-11-01 00:00:00','2022-11-30 00:00:00','Y','N'),(749,'202212','202212','2022-12-01 00:00:00','2022-12-31 00:00:00','Y','N'),(750,'202301','202301','2023-01-01 00:00:00','2023-01-31 00:00:00','Y','N'),(751,'202302','202302','2023-02-01 00:00:00','2023-02-28 00:00:00','Y','N'),(752,'202303','202303','2023-03-01 00:00:00','2023-03-31 00:00:00','Y','N'),(753,'202304','202304','2023-04-01 00:00:00','2023-04-30 00:00:00','Y','N'),(754,'202305','202305','2023-05-01 00:00:00','2023-05-31 00:00:00','Y','N'),(755,'202306','202306','2023-06-01 00:00:00','2023-06-30 00:00:00','Y','N'),(756,'202307','202307','2023-07-01 00:00:00','2023-07-31 00:00:00','Y','N'),(757,'202308','202308','2023-08-01 00:00:00','2023-08-31 00:00:00','Y','N'),(758,'202309','202309','2023-09-01 00:00:00','2023-09-30 00:00:00','Y','N'),(759,'202310','202310','2023-10-01 00:00:00','2023-10-31 00:00:00','Y','N'),(760,'202311','202311','2023-11-01 00:00:00','2023-11-30 00:00:00','Y','N'),(761,'202312','202312','2023-12-01 00:00:00','2023-12-31 00:00:00','Y','N'),(762,'202401','202401','2024-01-01 00:00:00','2024-01-31 00:00:00','Y','N'),(763,'202402','202402','2024-02-01 00:00:00','2024-02-29 00:00:00','Y','N'),(764,'202403','202403','2024-03-01 00:00:00','2024-03-31 00:00:00','Y','N'),(765,'202404','202404','2024-04-01 00:00:00','2024-04-30 00:00:00','Y','N'),(766,'202405','202405','2024-05-01 00:00:00','2024-05-31 00:00:00','Y','N'),(767,'202406','202406','2024-06-01 00:00:00','2024-06-30 00:00:00','Y','N'),(768,'202407','202407','2024-07-01 00:00:00','2024-07-31 00:00:00','Y','N'),(769,'202408','202408','2024-08-01 00:00:00','2024-08-31 00:00:00','Y','N'),(770,'202409','202409','2024-09-01 00:00:00','2024-09-30 00:00:00','Y','N'),(771,'202410','202410','2024-10-01 00:00:00','2024-10-31 00:00:00','Y','N'),(772,'202411','202411','2024-11-01 00:00:00','2024-11-30 00:00:00','Y','N'),(773,'202412','202412','2024-12-01 00:00:00','2024-12-31 00:00:00','Y','N'),(774,'202501','202501','2025-01-01 00:00:00','2025-01-31 00:00:00','N','Y'),(775,'202502','202502','2025-02-01 00:00:00','2025-02-28 00:00:00','N','N'),(776,'202503','202503','2025-03-01 00:00:00','2025-03-31 00:00:00','N','N'),(777,'202504','202504','2025-04-01 00:00:00','2025-04-30 00:00:00','N','N'),(778,'202505','202505','2025-05-01 00:00:00','2025-05-31 00:00:00','N','N'),(779,'202506','202506','2025-06-01 00:00:00','2025-06-30 00:00:00','N','N'),(780,'202507','202507','2025-07-01 00:00:00','2025-07-31 00:00:00','N','N'),(781,'202508','202508','2025-08-01 00:00:00','2025-08-31 00:00:00','N','N'),(782,'202509','202509','2025-09-01 00:00:00','2025-09-30 00:00:00','N','N'),(783,'202510','202510','2025-10-01 00:00:00','2025-10-31 00:00:00','N','N'),(784,'202511','202511','2025-11-01 00:00:00','2025-11-30 00:00:00','N','N'),(785,'202512','202512','2025-12-01 00:00:00','2025-12-31 00:00:00','N','N');


