-- phpMyAdmin SQL Dump -- version 2.10.3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Mar 20, 2018 at 06:21 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `banthuocla` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `user` varchar(20) NOT NULL, `pass` varchar(200) NOT NULL, `Ten` varchar(50) NOT NULL, `ck` varchar(10) NOT NULL, PRIMARY KEY (`user`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `admin` -- INSERT INTO `admin` VALUES ('admin', 'e10adc3949ba59abbe56e057f20f883e', 'Vũ Tuyết Ninh', '1'); INSERT INTO `admin` VALUES ('leloi', 'e10adc3949ba59abbe56e057f20f883e', 'Lê Cao Lợi', '1'); -- -------------------------------------------------------- -- -- Table structure for table `alert` -- CREATE TABLE `alert` ( `Ton` varchar(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `alert` -- INSERT INTO `alert` VALUES ('50'); -- -------------------------------------------------------- -- -- Table structure for table `bill` -- CREATE TABLE `bill` ( `Mabill` varchar(100) NOT NULL, `user` varchar(50) NOT NULL, `NgayBan` datetime NOT NULL, `TenKH` varchar(100) NOT NULL, `LoaiKH` varchar(10) NOT NULL, `Tamthu` varchar(100) NOT NULL, `Trangthai` varchar(200) NOT NULL, PRIMARY KEY (`Mabill`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `bill` -- INSERT INTO `bill` VALUES ('QL4', 'admin', '2018-03-14 07:10:15', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL3', 'admin', '2018-03-14 01:51:40', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL1', 'admin', '2018-03-14 01:23:45', 'C VAN', '0', '4266000', '1'); INSERT INTO `bill` VALUES ('QL2', 'admin', '2018-03-14 01:45:47', 'chu hiep', '1', '0', '0'); INSERT INTO `bill` VALUES ('QL5', 'admin', '2018-03-15 04:45:10', 'chu hiep', '1', '0', '0'); INSERT INTO `bill` VALUES ('QL6', 'admin', '2018-03-15 04:50:07', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL7', 'admin', '2018-03-15 04:52:56', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL8', 'admin', '2018-03-15 04:58:16', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL9', 'admin', '2018-03-15 05:47:34', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL14', 'admin', '2018-03-17 04:55:02', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL11', 'admin', '2018-03-16 05:21:52', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL13', 'admin', '2018-03-16 06:34:41', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL12', 'admin', '2018-03-16 07:09:05', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL15', 'admin', '2018-03-17 04:57:58', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL16', 'admin', '2018-03-17 05:06:28', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL17', 'admin', '2018-03-17 05:07:33', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL18', 'admin', '2018-03-17 05:14:32', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL19', 'admin', '2018-03-17 05:35:02', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL20', 'admin', '2018-03-17 05:50:17', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL21', 'admin', '2018-03-18 01:38:23', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL22', 'admin', '2018-03-18 01:41:04', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL27', 'admin', '2018-03-20 03:13:28', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL24', 'admin', '2018-03-18 01:53:13', 'chu hiep', '1', '0', '0'); INSERT INTO `bill` VALUES ('QL25', 'admin', '2018-03-18 02:04:54', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL28', 'admin', '2018-03-19 05:12:26', '', '0', '0', '0'); INSERT INTO `bill` VALUES ('QL29', 'admin', '2018-03-19 05:24:49', '', '0', '2187000', '1'); INSERT INTO `bill` VALUES ('QL30', 'admin', '2018-03-19 05:28:29', 'chu hiep', '1', '2868000', '2'); -- -------------------------------------------------------- -- -- Table structure for table `chitiet_bill` -- CREATE TABLE `chitiet_bill` ( `Mact` varchar(100) NOT NULL, `Madh` varchar(100) NOT NULL, `SL` varchar(20) NOT NULL, `TenSP` varchar(255) NOT NULL, `GB` varchar(20) NOT NULL, `Tong` varchar(20) NOT NULL, `MALOAI` varchar(100) NOT NULL, `DVT` varchar(50) NOT NULL, PRIMARY KEY (`Mact`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `chitiet_bill` -- INSERT INTO `chitiet_bill` VALUES ('77-20180314-014027pm-scmx9q9', 'QL1', '4', 'Craven Demi', '106000', '424000', 'SP_QL6', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-014055pm-sko6x9a', 'QL1', '5', 'Bastos xanh', '70000', '350000', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-012520pm-mfjj6l8', 'QL1', '2', 'Hòa Bình Mềm', '88000', '176000', 'SP_QL42', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-012623pm-gv8xxe7', 'QL1', '2', 'SG Vàng BC', '88000', '176000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-012715pm-kyunbjt', 'QL1', '10', 'Trị an mềm', '45500', '455000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-012757pm-9ycbpkd', 'QL1', '10', 'SG Bạc BC', '89000', '890000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-012919pm-fbk8rym', 'QL1', '5', 'Bastos đỏ', '100000', '500000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-012951pm-evp7m6y', 'QL1', '5', '555 Gold', '259000', '1295000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-014616pm-txig8dl', 'QL2', '22', 'SG Bạc BC', '88600', '1949200', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-014701pm-inbfk67', 'QL2', '5', 'Bastos đỏ', '99600', '498000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-014740pm-g7et86x', 'QL2', '6', 'Bastos xanh', '69600', '417600', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-014809pm-vankmyx', 'QL2', '1', 'Young Star Trắng', '90000', '90000', 'SP_QL56', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-014830pm-sgriq6s', 'QL2', '1', 'Melia (Hộp) ', '60000', '60000', 'SP_QL44', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-014920pm-el9cppx', 'QL2', '3', 'SG Vàng BC', '87000', '261000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-014947pm-8zt8xxf', 'QL2', '10', 'Trị an mềm', '45500', '455000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-015032pm-yqldo8p', 'QL2', '10', 'Craven 20s', '178500', '1785000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-015217pm-aagzbkm', 'QL3', '2', 'Dona gold', '56000', '112000', 'SP_QL16', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-015320pm-le6vmdr', 'QL3', '1', 'Kent (Đen)', '230000', '230000', 'SP_QL8', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-015355pm-xnlcda9', 'QL3', '5', 'SG Bạc BC', '89000', '445000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-015420pm-poekxns', 'QL3', '1', 'Trị an mềm', '47000', '47000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-015445pm-ay67898', 'QL3', '2', '555 Gold', '259000', '518000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-015508pm-tfcmyqu', 'QL3', '1', 'Dona gold', '56000', '56000', 'SP_QL16', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-015621pm-uzr7ccn', 'QL3', '2', 'Trị an mềm', '47000', '94000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180314-071129pm-sglvrcf', 'QL4', '1', '555 Silver (Bạc)', '220000', '220000', 'SP_QL2', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-044549pm-ndfhrjs', 'QL5', '10', 'Trị an mềm', '45500', '455000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-044617pm-ikmhvqs', 'QL5', '10', 'Craven 20s', '178500', '1785000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-044637pm-zxdhqd6', 'QL5', '3', 'SG Vàng BC', '87000', '261000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-044709pm-6zbk9eb', 'QL5', '15', 'SG Bạc BC', '88600', '1329000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-044936pm-l86ftcz', 'QL5', '5', 'Bastos xanh', '69600', '348000', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-044832pm-ksoaamr', 'QL5', '5', 'Bastos đỏ', '99600', '498000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-044903pm-dvypgyh', 'QL5', '1', 'Ngựa trắng', '196000', '196000', 'SP_QL25', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045036pm-bge7val', 'QL6', '1', '555 Gold', '260000', '260000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045104pm-i8ildfg', 'QL6', '2', 'Trị an mềm', '46000', '92000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045129pm-dyirusy', 'QL6', '1', 'Bastos đỏ', '100000', '100000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045142pm-msx8ltg', 'QL6', '1', 'Bastos xanh', '70000', '70000', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045158pm-ehmidm9', 'QL6', '2', 'Cotab BC', '92000', '184000', 'SP_QL59', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045358pm-lxu6kei', 'QL7', '1', 'Melia (Hộp) ', '61000', '61000', 'SP_QL44', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045433pm-vvgk8de', 'QL7', '1', 'Yett (Trắng)', '70000', '70000', 'SP_QL26', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045505pm-dj8t9a9', 'QL7', '1', 'Cotab BC', '92000', '92000', 'SP_QL59', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045534pm-ssapslj', 'QL7', '1', 'Young Star Trắng', '90000', '90000', 'SP_QL56', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045603pm-fihzaft', 'QL7', '1', 'Dunhill ', '280000', '280000', 'SP_QL7', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045648pm-hmkiefl', 'QL7', '3', 'Bastos xanh', '70000', '210000', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045718pm-glma6f8', 'QL7', '2', 'Trị an mềm', '46000', '92000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045750pm-melgxu8', 'QL7', '2', 'Craven 20s', '180000', '360000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045856pm-hzlfaxy', 'QL8', '3', 'Bastos đỏ', '100000', '300000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-045922pm-8jrx8rx', 'QL8', '1', 'Ngựa trắng', '197000', '197000', 'SP_QL25', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-050000pm-tzjkrxh', 'QL8', '1', '555 Silver (Bạc)', '220000', '220000', 'SP_QL2', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180315-054834pm-nohqebt', 'QL9', '1', '555 Gold', '260000', '260000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062908pm-dlpvjdh', 'QL11', '2', 'Bastos đỏ', '100000', '200000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062420pm-9bujblq', 'QL11', '2', 'SG Vàng BC', '87000', '174000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062502pm-cnfrltp', 'QL11', '5', '555 Gold', '259000', '1295000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062530pm-obupxva', 'QL11', '20', 'SG Bạc BC', '88600', '1772000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062555pm-pq9iuti', 'QL11', '12', 'Trị an mềm', '45500', '546000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062644pm-yg7f8js', 'QL11', '6', 'Bastos xanh', '69600', '417600', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062711pm-fsis7sf', 'QL11', '1', 'Marlboro Trắng ', '239000', '239000', 'SP_QL32', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062730pm-sghrjgr', 'QL11', '2', 'Hòa Bình Mềm', '88000', '176000', 'SP_QL42', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-062800pm-6lzkxgl', 'QL11', '1', 'SG Xanh Mềm', '112000', '112000', 'SP_QL51', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-063215pm-7ljnjbe', 'QL11', '2', 'Dona gold', '56000', '112000', 'SP_QL16', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-063459pm-i8auivp', 'QL13', '1', '555 Gold', '260000', '260000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180316-070948pm-a7z8cdg', 'QL12', '1', '555 Gold', '260000', '260000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-045628pm-jcqsvft', 'QL14', '1', 'Craven 20s', '180000', '180000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-045700pm-l9u7lvo', 'QL14', '1', 'Trị an mềm', '46000', '46000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-045736pm-9kseq98', 'QL14', '2', 'SG Bạc BC', '90000', '180000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-045904pm-tjougsh', 'QL15', '10', 'Craven 20s', '178500', '1785000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-050722pm-8qljrqs', 'QL16', '10', '555 Gold', '259000', '2590000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-050810pm-djyd6ke', 'QL17', '15', 'SG Bạc BC', '88600', '1329000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-050909pm-h8xmiit', 'QL17', '5', 'Bastos đỏ', '99600', '498000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-050955pm-smevu6x', 'QL17', '12', 'Trị an mềm', '45500', '546000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-051024pm-pgmudpi', 'QL17', '1', 'Melia (Hộp) ', '60000', '60000', 'SP_QL44', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-051105pm-k6rxm7e', 'QL17', '4', 'SG Vàng BC', '87000', '348000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-051132pm-e9t9z7j', 'QL17', '3', '555 Gold', '259000', '777000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-051246pm-a6zfznj', 'QL17', '2', 'Craven Demi', '106000', '212000', 'SP_QL6', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-051416pm-dszfaju', 'QL17', '10', 'Craven 20s', '178500', '1785000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-051505pm-ohgofur', 'QL18', '2', 'Trị an hộp', '56000', '112000', 'SP_QL18', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-051532pm-tzunskf', 'QL18', '10', 'Cotab BC', '91500', '915000', 'SP_QL59', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-053541pm-l7dufyv', 'QL19', '2', 'Ngựa Nâu ', '62000', '124000', 'SP_QL23', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-053600pm-6irpfjs', 'QL19', '1', 'Craven (Bấm)', '180000', '180000', 'SP_QL5', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-055048pm-9ysgbob', 'QL20', '15', 'SG Bạc BC', '88800', '1332000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-055124pm-ksxb8ry', 'QL20', '1', 'Yett (Trắng)', '70000', '70000', 'SP_QL26', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180317-055234pm-yhd7yzb', 'QL20', '5', 'SG Vàng BC', '87000', '435000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-013912pm-bylodl7', 'QL21', '3', 'SG Xanh Mềm', '112000', '336000', 'SP_QL51', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-013941pm-8vdyesf', 'QL21', '2', '555 Gold', '260000', '520000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-014028pm-nots6uf', 'QL21', '2', 'Bastos xanh', '70000', '140000', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-014053pm-qooof8a', 'QL21', '5', 'SG Bạc BC', '89000', '445000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-014128pm-qtmyfqa', 'QL22', '5', 'SG Bạc BC', '89000', '445000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-014156pm-kqemtrv', 'QL22', '1', 'Craven Demi', '106000', '106000', 'SP_QL6', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-014223pm-7xxsmre', 'QL22', '2', 'Bastos đỏ', '100000', '200000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-014302pm-unsceqv', 'QL22', '1', 'SG Vàng BC', '88000', '88000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-014441pm-vfdcm9j', 'QL22', '1', 'Craven 20s', '180000', '180000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-015342pm-6ihj6ql', 'QL24', '10', 'SG Bạc BC', '88600', '886000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-015756pm-ixggf8v', 'QL24', '1', 'Trị an hộp', '56000', '56000', 'SP_QL18', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-015818pm-lut7fqs', 'QL24', '1', 'Melia (Hộp) ', '60000', '60000', 'SP_QL44', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-015854pm-hg79jft', 'QL24', '3', 'SG Vàng BC', '87000', '261000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-015921pm-gl76ov9', 'QL24', '5', 'Bastos xanh', '69600', '348000', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-015947pm-xkdr8y9', 'QL24', '5', 'Bastos đỏ', '99600', '498000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020012pm-ufelo7j', 'QL24', '10', 'Craven 20s', '178500', '1785000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020038pm-rxyaaoi', 'QL24', '3', 'Hòa Bình Mềm', '88000', '264000', 'SP_QL42', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020110pm-s7ixxch', 'QL24', '15', 'Trị an mềm', '45500', '682500', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020150pm-kgtqcut', 'QL24', '3', '555 Gold', '259000', '777000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020526pm-v8fqjvx', 'QL25', '10', 'Craven 20s', '178500', '1785000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020555pm-uyllgic', 'QL25', '5', 'Craven Demi', '106000', '530000', 'SP_QL6', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020730pm-9vjnopd', 'QL25', '5', '555 Gold', '259400', '1297000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020810pm-nmpaopa', 'QL25', '3', 'SG Slim BC', '90000', '270000', 'SP_QL53', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020829pm-avnnzn8', 'QL25', '1', 'Young Star Trắng', '90000', '90000', 'SP_QL56', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020851pm-iycns7h', 'QL25', '1', '555 Silver (Bạc)', '220000', '220000', 'SP_QL2', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180318-020909pm-6hjtvj8', 'QL25', '1', 'Hòa Bình Hộp', '88000', '88000', 'SP_QL43', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-051248pm-o8duojl', 'QL28', '1', 'Hòa Bình Mềm', '88000', '88000', 'SP_QL42', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-051344pm-j77albm', 'QL28', '1', 'Dona gold', '56000', '56000', 'SP_QL16', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-051420pm-xhigzyj', 'QL28', '1', 'Trị an hộp', '56000', '56000', 'SP_QL18', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-051447pm-zb9ikqr', 'QL28', '1', 'Cotab BC', '92000', '92000', 'SP_QL59', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052256pm-98lr6as', 'QL28', '1', 'Bastos xanh', '70000', '70000', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052319pm-hcqgp6l', 'QL28', '1', 'Bastos đỏ', '100000', '100000', 'SP_QL12', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052426pm-h8xmiit', 'QL28', '2', '555 Silver (Bạc)', '220000', '440000', 'SP_QL2', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052530pm-eodlvpm', 'QL29', '10', 'Trị an mềm', '45800', '458000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052557pm-rjldito', 'QL29', '5', 'SG Bạc BC', '89000', '445000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052616pm-jqidtti', 'QL29', '3', 'Hòa Bình Mềm', '88000', '264000', 'SP_QL42', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052643pm-icicsy9', 'QL29', '2', '555 Gold', '260000', '520000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052705pm-aynuuda', 'QL29', '2', 'Craven 20s', '180000', '360000', 'SP_QL3', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052732pm-dmmcpx7', 'QL29', '2', 'Bastos xanh', '70000', '140000', 'SP_QL11', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052850pm-svppss6', 'QL30', '10', 'Trị an mềm', '45500', '455000', 'SP_QL19', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052908pm-hv86p9c', 'QL30', '1', 'Melia (Hộp) ', '60000', '60000', 'SP_QL44', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052923pm-ahmml7s', 'QL30', '1', 'Trị an hộp', '56000', '56000', 'SP_QL18', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-052946pm-v8zsmgh', 'QL30', '3', 'SG Vàng BC', '87000', '261000', 'SP_QL50', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-053011pm-nnrqput', 'QL30', '20', 'SG Bạc BC', '88600', '1772000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180319-053036pm-o8duojl', 'QL30', '3', 'Hòa Bình Mềm', '88000', '264000', 'SP_QL42', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180320-031417pm-zg7vek8', 'QL27', '1', 'SG Bạc BC', '90000', '90000', 'SP_QL48', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180320-031540pm-dhom9zc', 'QL27', '1', 'Craven Demi', '106000', '106000', 'SP_QL6', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180320-031615pm-aagzbkm', 'QL27', '4', '555 Gold', '260000', '1040000', 'SP_QL1', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180320-031643pm-c9cg7he', 'QL27', '5', 'Hòa Bình Mềm', '88000', '440000', 'SP_QL42', 'Cây'); INSERT INTO `chitiet_bill` VALUES ('77-20180320-032926pm-bge7val', 'QL27', '10', 'SG Bạc BC', '89000', '890000', 'SP_QL48', 'Cây'); -- -------------------------------------------------------- -- -- Table structure for table `chitiet_kho` -- CREATE TABLE `chitiet_kho` ( `Manhap` varchar(100) NOT NULL, `Ngaynhap` datetime NOT NULL, `Masp` varchar(100) NOT NULL, `Soluong` varchar(100) NOT NULL, `Gianhap` varchar(100) NOT NULL, PRIMARY KEY (`Manhap`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `chitiet_kho` -- INSERT INTO `chitiet_kho` VALUES ('77-20180225-014422pm-zoilfto', '2018-02-25 01:44:22', 'SP_QL1', '5100', '20000'); INSERT INTO `chitiet_kho` VALUES ('77-20180225-013643pm-n7if8ou', '2018-02-25 01:36:43', 'SP_QL1', '', '20000'); INSERT INTO `chitiet_kho` VALUES ('77-20180225-010518pm-nuyoof9', '2018-02-25 01:05:18', 'SP_QL60', '', '20000'); INSERT INTO `chitiet_kho` VALUES ('77-20180225-125849pm-gh7oqga', '2018-02-25 12:58:49', 'SP_QL60', '', '20000'); INSERT INTO `chitiet_kho` VALUES ('77-20180225-114236am-e8csskq', '2018-02-25 11:42:36', 'SP_QL1', '50050', ''); INSERT INTO `chitiet_kho` VALUES ('77-20180225-114241am-dbboegt', '2018-02-25 11:42:41', 'SP_QL2', '50050', ''); INSERT INTO `chitiet_kho` VALUES ('77-20180301-054648pm-dpyoecp', '2018-03-01 05:46:48', 'SP_QL1', '', '25700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-084940pm-vvbdqap', '2018-03-13 08:49:40', 'SP_QL1', '', '26000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085017pm-egzgouk', '2018-03-13 08:50:17', 'SP_QL2', '', '22000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085100pm-a7m7ctm', '2018-03-13 08:51:00', 'SP_QL3', '', '18000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085136pm-ftj8hru', '2018-03-13 08:51:36', 'SP_QL5', '', '18000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085158pm-6zuy6k7', '2018-03-13 08:51:58', 'SP_QL6', '', '10600'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085227pm-gnzb9qf', '2018-03-13 08:52:27', 'SP_QL7', '', '28000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085244pm-qtccidc', '2018-03-13 08:52:44', 'SP_QL8', '', '23000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085326pm-oc9mhlj', '2018-03-13 08:53:26', 'SP_QL9', '', '23000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085346pm-98tr9gx', '2018-03-13 08:53:46', 'SP_QL10', '', '23000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-085953pm-lz6jevu', '2018-03-13 08:59:53', 'SP_QL11', '', '9900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090037pm-iugtvju', '2018-03-13 09:00:37', 'SP_QL1', '', '25900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090107pm-x8mvgji', '2018-03-13 09:01:07', 'SP_QL1', '', '25900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090141pm-ordy8sx', '2018-03-13 09:01:41', 'SP_QL2', '', '21900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090157pm-dpbuiny', '2018-03-13 09:01:57', 'SP_QL3', '', '17900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090230pm-ekbgioq', '2018-03-13 09:02:30', 'SP_QL5', '', '17900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090251pm-8hi7jlo', '2018-03-13 09:02:51', 'SP_QL6', '', '10400'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090313pm-udz6f8b', '2018-03-13 09:03:13', 'SP_QL7', '', '28000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090405pm-jgurasa', '2018-03-13 09:04:05', 'SP_QL11', '', '6920'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090431pm-xkibcu8', '2018-03-13 09:04:31', 'SP_QL12', '', '9920'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090445pm-njub9z7', '2018-03-13 09:04:45', 'SP_QL11', '', '6920'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090530pm-txelcui', '2018-03-13 09:05:30', 'SP_QL13', '', '7700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090616pm-j67tre6', '2018-03-13 09:06:16', 'SP_QL14', '', '8400'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090645pm-eb6jyej', '2018-03-13 09:06:45', 'SP_QL15', '', '8400'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090726pm-i8ofupp', '2018-03-13 09:07:26', 'SP_QL16', '', '5570'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090801pm-tvb9yuh', '2018-03-13 09:08:01', 'SP_QL17', '', '8400'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090823pm-nzsmin7', '2018-03-13 09:08:23', 'SP_QL18', '', '5570'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090855pm-ruzi9l6', '2018-03-13 09:08:55', 'SP_QL19', '', '4570'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-090916pm-hgxgahj', '2018-03-13 09:09:16', 'SP_QL20', '', '20400'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091009pm-j6edhxz', '2018-03-13 09:10:09', 'SP_QL21', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091023pm-9do7pcz', '2018-03-13 09:10:23', 'SP_QL22', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091050pm-oamzq8i', '2018-03-13 09:10:50', 'SP_QL23', '', '6100'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091109pm-xdszcnx', '2018-03-13 09:11:09', 'SP_QL24', '', '6100'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091152pm-zokehnn', '2018-03-13 09:11:52', 'SP_QL25', '', '19550'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091215pm-efo9oxu', '2018-03-13 09:12:15', 'SP_QL26', '', '6900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091227pm-imbrinf', '2018-03-13 09:12:27', 'SP_QL27', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091243pm-kxk6kps', '2018-03-13 09:12:43', 'SP_QL28', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091304pm-8vdjp6x', '2018-03-13 09:13:04', 'SP_QL29', '', '6200'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091319pm-7ymhc6e', '2018-03-13 09:13:19', 'SP_QL29', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091330pm-xcmeoq9', '2018-03-13 09:13:30', 'SP_QL30', '', '6200'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091340pm-crjpzmt', '2018-03-13 09:13:40', 'SP_QL31', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091404pm-pm79deh', '2018-03-13 09:14:04', 'SP_QL32', '', '23700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091421pm-cfqpay8', '2018-03-13 09:14:21', 'SP_QL33', '', '23700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091438pm-mapq8lb', '2018-03-13 09:14:38', 'SP_QL34', '', '23700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091453pm-jlib7kg', '2018-03-13 09:14:53', 'SP_QL37', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091516pm-plzlaec', '2018-03-13 09:15:16', 'SP_QL38', '', '5600'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091547pm-laddzyv', '2018-03-13 09:15:47', 'SP_QL35', '', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091601pm-tczi7zs', '2018-03-13 09:16:01', 'SP_QL36', '', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091611pm-smdctrq', '2018-03-13 09:16:11', 'SP_QL39', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091623pm-kujctfk', '2018-03-13 09:16:23', 'SP_QL40', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091638pm-opndubl', '2018-03-13 09:16:38', 'SP_QL41', '', '5600'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091704pm-qv6i7vz', '2018-03-13 09:17:04', 'SP_QL42', '', '8700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091717pm-gbvacrj', '2018-03-13 09:17:17', 'SP_QL43', '', '8700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091737pm-hjjcsuj', '2018-03-13 09:17:37', 'SP_QL44', '', '6000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091752pm-dpugj6b', '2018-03-13 09:17:52', 'SP_QL45', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091804pm-9litxhz', '2018-03-13 09:18:04', 'SP_QL46', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091825pm-9f7f7th', '2018-03-13 09:18:25', 'SP_QL48', '', '8800'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091844pm-p6aisjh', '2018-03-13 09:18:44', 'SP_QL49', '', '10300'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091901pm-bqeyute', '2018-03-13 09:19:01', 'SP_QL50', '', '8700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-091945pm-nduudlc', '2018-03-13 09:19:45', 'SP_QL51', '', '11100'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-092002pm-vudfmgf', '2018-03-13 09:20:02', 'SP_QL52', '', '11100'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-092031pm-greq7u7', '2018-03-13 09:20:31', 'SP_QL53', '', '8900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-092050pm-pscflcn', '2018-03-13 09:20:50', 'SP_QL54', '', '8800'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-092148pm-posbn6i', '2018-03-13 09:21:48', 'SP_QL55', '', '16800'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-092219pm-9ghyp8v', '2018-03-13 09:22:19', 'SP_QL56', '', '8800'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-092233pm-enoktlt', '2018-03-13 09:22:33', 'SP_QL57', '', '8800'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-092244pm-omk7gst', '2018-03-13 09:22:44', 'SP_QL58', '', '0'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-092300pm-v9ibr7u', '2018-03-13 09:23:00', 'SP_QL59', '', '9100'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-093300pm-ybignor', '2018-03-13 09:33:00', 'SP_QL2', '', '21900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-093322pm-djkbshl', '2018-03-13 09:33:22', 'SP_QL3', '', '17900'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-093426pm-7edbuac', '2018-03-13 09:34:26', 'SP_QL7', '', '28000'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-093522pm-xn6tgzk', '2018-03-13 09:35:22', 'SP_QL11', '', '6920'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-093641pm-vfinilf', '2018-03-13 09:36:41', 'SP_QL32', '', '23700'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-093752pm-iydibm8', '2018-03-13 09:37:52', 'SP_QL48', '', '8800'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-093809pm-uhcvzt9', '2018-03-13 09:38:09', 'SP_QL48', '', '8800'); INSERT INTO `chitiet_kho` VALUES ('77-20180313-093854pm-umd6jpt', '2018-03-13 09:38:54', 'SP_QL50', '', '8650'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-013442pm-vkr8kpe', '2018-03-14 01:34:42', 'SP_QL6', '100', '10400'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-013535pm-gtt7vke', '2018-03-14 01:35:35', 'SP_QL1', '100', '25900'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-013610pm-6gmblpq', '2018-03-14 01:36:10', 'SP_QL16', '50', '5520'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-013649pm-kvykucr', '2018-03-14 01:36:49', 'SP_QL16', '0', '5570'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-013719pm-j8vjvbc', '2018-03-14 01:37:19', 'SP_QL42', '100', '8700'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-013804pm-ll8qvrr', '2018-03-14 01:38:04', 'SP_QL51', '50', '11100'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-013829pm-6nx8sbk', '2018-03-14 01:38:29', 'SP_QL50', '100', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-013908pm-vfvkz8m', '2018-03-14 01:39:08', 'SP_QL48', '500', '8800'); INSERT INTO `chitiet_kho` VALUES ('77-20180314-014450pm-ucy8ukt', '2018-03-14 01:44:50', 'SP_QL6', '36', '10400'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-044036pm-rgegkhr', '2018-03-15 04:40:36', 'SP_QL3', '500', '17850'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-044128pm-66hkcb7', '2018-03-15 04:41:28', 'SP_QL12', '500', '9920'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-044205pm-glmfmvd', '2018-03-15 04:42:05', 'SP_QL19', '500', '4550'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-044238pm-fyh9mgx', '2018-03-15 04:42:38', 'SP_QL50', '100', '8700'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-044305pm-vd8lj79', '2018-03-15 04:43:05', 'SP_QL48', '500', '8800'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-044323pm-k86zdes', '2018-03-15 04:43:23', 'SP_QL7', '20', '28000'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-044402pm-smihhtm', '2018-03-15 04:44:02', 'SP_QL56', '50', '8900'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-063807pm-tzesro9', '2018-03-15 06:38:07', 'SP_QL35', '400', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-063829pm-zp6tnoy', '2018-03-15 06:38:29', 'SP_QL35', '40', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-063928pm-amrs6ei', '2018-03-15 06:39:28', 'SP_QL35', '300', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-064124pm-b7j9esh', '2018-03-15 06:41:24', 'SP_QL35', '', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-064157pm-plzlaec', '2018-03-15 06:41:57', 'SP_QL35', '', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-064209pm-mplmkgo', '2018-03-15 06:42:09', 'SP_QL35', '', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-064225pm-9ip7dtp', '2018-03-15 06:42:25', 'SP_QL36', '', '8600'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-065400pm-risflrx', '2018-03-15 06:54:00', 'SP_QL59', '', '7800'); INSERT INTO `chitiet_kho` VALUES ('77-20180315-065558pm-uihynnh', '2018-03-15 06:55:58', 'SP_QL59', '', ''); INSERT INTO `chitiet_kho` VALUES ('77-20180317-050352pm-mo66ax9', '2018-03-17 05:03:52', 'SP_QL1', '200', '259000'); INSERT INTO `chitiet_kho` VALUES ('77-20180317-050539pm-mhzxzqm', '2018-03-17 05:05:39', 'SP_QL59', '100', '92000'); INSERT INTO `chitiet_kho` VALUES ('77-20180317-051748pm-c8dacyz', '2018-03-17 05:17:48', 'SP_QL48', '500', '88600'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050037pm-ez9hjop', '2018-03-19 05:00:37', 'SP_QL1', '100', '259000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050142pm-b6utm7o', '2018-03-19 05:01:42', 'SP_QL2', '50', '219000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050253pm-zbfrbsh', '2018-03-19 05:02:53', 'SP_QL6', '100', '106000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050440pm-pjtbz6i', '2018-03-19 05:04:40', 'SP_QL18', '50', '55000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050523pm-en6rury', '2018-03-19 05:05:23', 'SP_QL19', '500', '45500'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050623pm-thve9v9', '2018-03-19 05:06:23', 'SP_QL23', '', '61000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050707pm-pvlqhsi', '2018-03-19 05:07:07', 'SP_QL42', '50', '87000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050735pm-xuqkhch', '2018-03-19 05:07:35', 'SP_QL43', '50', '87000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050814pm-t6lsvbh', '2018-03-19 05:08:14', 'SP_QL44', '50', '60000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-050937pm-cyir6yk', '2018-03-19 05:09:37', 'SP_QL48', '500', '88600'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-051024pm-zrezogl', '2018-03-19 05:10:24', 'SP_QL50', '150', '87000'); INSERT INTO `chitiet_kho` VALUES ('77-20180319-051109pm-7ymtony', '2018-03-19 05:11:09', 'SP_QL51', '50', '11100'); -- -------------------------------------------------------- -- -- Table structure for table `chmod` -- CREATE TABLE `chmod` ( `user` varchar(20) NOT NULL, `keypm` varchar(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `chmod` -- INSERT INTO `chmod` VALUES ('admin', '1'); INSERT INTO `chmod` VALUES ('leloi', '1'); INSERT INTO `chmod` VALUES ('admin', '2'); INSERT INTO `chmod` VALUES ('leloi', '2'); INSERT INTO `chmod` VALUES ('admin', '3'); -- -------------------------------------------------------- -- -- Table structure for table `danhmuc_ncc` -- CREATE TABLE `danhmuc_ncc` ( `MANCC` varchar(100) NOT NULL, `TENNCC` varchar(100) NOT NULL, `DIACHI` varchar(255) NOT NULL, `SODTNCC` varchar(20) NOT NULL, PRIMARY KEY (`MANCC`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `danhmuc_ncc` -- INSERT INTO `danhmuc_ncc` VALUES ('NCC1', 'British American Tobacco (BAT)', 'Kumho Asiana Plaza, 39 Lê Duẩn, Bến Nghé, Quận 1, Hồ Chí Minh', '838219888'); INSERT INTO `danhmuc_ncc` VALUES ('NCC2', 'Công ty Thuốc lá Đồng Nai (DOFICO)', 'Số 833A, Xa lộ Hà Nội, Khu Phố 1, Phường Long Bình Tân, Thành Phố Biên Hòa, Tỉnh Đồng Nai.', '0251.3836110'); INSERT INTO `danhmuc_ncc` VALUES ('NCC3', 'Nhà máy Thuốc lá Khánh Hòa (Khatoco)', 'KCN Bình Tân - P. Vĩnh Trường - TP. Nha Trang - Khánh Hòa', '0583.881110'); INSERT INTO `danhmuc_ncc` VALUES ('NCC4', 'Nhà Máy Thuốc Lá Khánh Hội (KHÁNH HỘI)', 'Lô 26, đường số 3, KCN Tân Tạo, Bình Tân, Tp HCM', '08 37507282'); INSERT INTO `danhmuc_ncc` VALUES ('NCC5', 'MARLBORO-CHAMPION', '', ''); INSERT INTO `danhmuc_ncc` VALUES ('NCC6', 'CÔNG TY THUỐC LÁ SÀI GÒN (VINATABA SAI GON)', 'Khu công nghiệp Vĩnh Lộc, Xã Vĩnh Lộc A, Huyện Bình Chánh, Thành Phố Hồ Chí Minh', '028.37657878'); INSERT INTO `danhmuc_ncc` VALUES ('NCC7', 'NM Thuốc Lá Thăng Long', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `danhmuc_sp` -- CREATE TABLE `danhmuc_sp` ( `MALOAI` varchar(100) NOT NULL, `MANCC` varchar(100) NOT NULL, `TEN_LOAI` varchar(255) NOT NULL, `IM` varchar(100) NOT NULL, `Soluong` varchar(100) NOT NULL, `Gianhap` varchar(100) NOT NULL, PRIMARY KEY (`MALOAI`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `danhmuc_sp` -- INSERT INTO `danhmuc_sp` VALUES ('SP_QL1', 'NCC1', '555 Gold', 'SP_QL1SE555_gold_20S.jpg', '82', '259000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL2', 'NCC1', '555 Silver (Bạc)', '', '90', '219000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL3', 'NCC1', 'Craven 20s', '', '10', '17850'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL5', 'NCC1', 'Craven (Bấm)', '', '40', '17900'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL6', 'NCC1', 'Craven Demi', '', '110', '106000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL7', 'NCC1', 'Dunhill ', '', '30', '28000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL8', 'NCC1', 'Kent (Đen)', '', '20', '23000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL9', 'NCC1', 'Kent (Bạc)', '', '10', '23000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL10', 'NCC1', 'Kent (Xanh)', '', '0', '23000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL11', 'NCC2', 'Bastos xanh', '', '505', '6920'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL12', 'NCC2', 'Bastos đỏ', '', '902', '9920'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL13', 'NCC2', 'Bastos the', '', '0', '7700'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL14', 'NCC2', 'Bastos bạc đỏ (nhỏ)', '', '40', '8400'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL15', 'NCC2', 'Bastos bạc xanh (nhỏ)', '', '10', '8400'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL16', 'NCC2', 'Dona gold', '', '90', '5570'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL17', 'NCC2', 'Dona gold 999 (Bạc)', '', '0', '8400'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL18', 'NCC2', 'Trị an hộp', '', '110', '55000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL19', 'NCC2', 'Trị an mềm', '', '800', '45500'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL20', 'NCC3', 'Núi', '', '40', '20400'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL21', 'NCC3', 'Prince ', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL22', 'NCC3', 'Cò vàng', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL23', 'NCC3', 'Ngựa Nâu ', '', '50', '61000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL24', 'NCC3', 'Ngựa Đỏ', '', '0', '6100'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL25', 'NCC3', 'Ngựa trắng', '', '50', '19550'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL26', 'NCC3', 'Yett (Trắng)', '', '60', '6900'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL27', 'NCC3', 'Yett Gold (Vàng)', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL28', 'NCC3', 'Yett Silver (Bạc)', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL29', 'NCC4', 'Khánh Hội Hộp', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL30', 'NCC4', 'Khánh Hội Đồng tiền', '', '0', '6200'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL31', 'NCC7', 'Thăng Long', '', '80', '7800'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL32', 'NCC5', 'Marlboro Trắng ', '', '80', '23700'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL33', 'NCC5', 'Marlboro Đỏ ', '', '40', '23700'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL34', 'NCC5', 'Marlboro Xanh', '', '40', '23700'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL35', 'NCC5', 'Champion Slim Bạc', '', '40', '8600'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL36', 'NCC5', 'Champion Slim Xanh', '', '30', '8600'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL37', 'NCC6', 'Du lịch đỏ BM', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL38', 'NCC6', 'Era Đỏ BC ', '', '0', '5600'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL39', 'NCC6', 'Era the BC ', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL40', 'NCC6', 'Era Cọp BC ', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL41', 'NCC6', 'Fasol nâu BC', '', '0', '5600'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL42', 'NCC6', 'Hòa Bình Mềm', '', '40', '87000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL43', 'NCC6', 'Hòa Bình Hộp', '', '70', '87000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL44', 'NCC6', 'Melia (Hộp) ', '', '100', '60000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL45', 'NCC6', 'Melia (Mềm)', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL46', 'NCC6', 'Đà Lạt', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL48', 'NCC6', 'SG Bạc BC', '', '580', '88600'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL49', 'NCC6', 'SG Classic Đỏ', '', '50', '10300'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL50', 'NCC6', 'SG Vàng BC', '', '122', '87000'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL51', 'NCC6', 'SG Xanh Mềm', '', '90', '11100'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL52', 'NCC6', 'SG Xanh Hộp', '', '30', '11100'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL53', 'NCC6', 'SG Slim BC', '', '70', '8900'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL54', 'NCC6', 'SG Special Trắng', '', '0', '8800'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL55', 'NCC6', 'SG Virginia BC', '', '20', '16800'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL56', 'NCC6', 'Young Star Trắng', '', '60', '8900'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL57', 'NCC6', 'Young Star The', '', '30', '8800'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL58', 'NCC6', 'Young Star Vàng', '', '0', '0'); INSERT INTO `danhmuc_sp` VALUES ('SP_QL59', 'NCC6', 'Cotab BC', '', '50', '92000'); -- -------------------------------------------------------- -- -- Table structure for table `dm_pm` -- CREATE TABLE `dm_pm` ( `Key_pm` varchar(10) NOT NULL, `TenPM` varchar(200) NOT NULL, `Ghichu` varchar(200) NOT NULL, PRIMARY KEY (`Key_pm`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `dm_pm` -- INSERT INTO `dm_pm` VALUES ('1', 'Bán Hàng', 'Chức năng tạo Bill bán hàng'); INSERT INTO `dm_pm` VALUES ('2', 'Quản lý kho', 'Nhập tồn, báo cáo'); INSERT INTO `dm_pm` VALUES ('3', 'Báo cáo', 'Báo cáo bán hàng'); -- -------------------------------------------------------- -- -- Table structure for table `dvt` -- CREATE TABLE `dvt` ( `Madvt` varchar(10) NOT NULL, `TenDVT` varchar(50) NOT NULL, `Goi` varchar(50) NOT NULL, PRIMARY KEY (`Madvt`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `dvt` -- INSERT INTO `dvt` VALUES ('1', 'Cây', '10'); INSERT INTO `dvt` VALUES ('2', 'Thùng', '500'); INSERT INTO `dvt` VALUES ('3', 'Gói', '1'); -- -------------------------------------------------------- -- -- Table structure for table `khachhang` -- CREATE TABLE `khachhang` ( `Makh` varchar(100) NOT NULL, `TenKH` varchar(100) NOT NULL, `DT` varchar(30) NOT NULL, PRIMARY KEY (`Makh`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `khachhang` -- INSERT INTO `khachhang` VALUES ('COl5hgOURFv4QaFodjZfqdGtrsvpJ9ETgTPhxKhotlIBzKlJNzU8CTBEZj9DoW', 'Nguyễn Xuân Tiến', ''); INSERT INTO `khachhang` VALUES ('9F6RlQFjGZBh05wuEzv8uq9XQ8y9zEjt0rv7ZuJNRf6KuHbGbi5OP1pSJke4Kc', 'Vũ Thị Mỹ Linh', ''); INSERT INTO `khachhang` VALUES ('wZdut45ajjCStO3rX95derW2eglgtJwJSpaMWpwfDkivqfHmgLtbDYOOvtszll', 'Hồ Ngọc Hải', ''); INSERT INTO `khachhang` VALUES ('dkMxNugsqzswjnlibgnTf5xTfbipnnB1m3XOq1iphD6T9JlPLFuljiv1xVRXEq', 'Lê Cao Lợi', ''); INSERT INTO `khachhang` VALUES ('aALWOqCADMkZQvQKaWDWNVGauNrxrqSCn8uwvLcQyFwFKGoBNaiIVWcCQmzpMh', '', ''); INSERT INTO `khachhang` VALUES ('jdFLTAl23MxBv7GxtrLsF5grjV758hPul0lfFr8riqbFZiW2WVn7SDZ10gHl3a', 'Nguyễn Xuân Tiến', ''); INSERT INTO `khachhang` VALUES ('1afbT6iFNdqrH7lR4UhMSaWxAZzYaZRp5e2JkkOgkmqP6WAO49v1fAUP3k03vZ', 'Nguyễn Xuân Tiến', ''); INSERT INTO `khachhang` VALUES ('ta81oEwA0agouyj3A88EvMINYOvyc5tyVX6Rkem5aiIkEY79tB3GS2uuADSGNc', 'Trần Văn A', ''); INSERT INTO `khachhang` VALUES ('Wa0FjLK7pco8tkUjcsLKOsW12GTf4WA1FBvp1vC2RZmYpUKOmAdFXTK8V9Ohsd', '', ''); INSERT INTO `khachhang` VALUES ('uKB9DoktGiEiSjwdVMql3zkfYZH1UUvizFd7c5N6txImERWsrnXu3XI4cWHh79', '', ''); INSERT INTO `khachhang` VALUES ('RHwWGsDa779aEMjMf3Pmn1VJZgjfATdL6vmB2aWDkvHatBQ5q26HFVFS8QiWlT', '', ''); INSERT INTO `khachhang` VALUES ('bKdF3Dgg7sqg7yaMfLuoeqPcioaM90Yg16ddD3mJbFnppiKkwOp7fwRQNh46Tr', '', ''); INSERT INTO `khachhang` VALUES ('2aWDkvHatBQ5q26HFVFS8QiWlTbKdF3Dgg7sqg7yaMfLuoeqPcioaM90Yg16dd', 'Chi Dung ', ''); INSERT INTO `khachhang` VALUES ('mIhqTxCClkc9dbdRsHp5xZZGqBGZBGHR0NLB9156YZoGWLUb2XkYJFTRYskdgs', '', ''); INSERT INTO `khachhang` VALUES ('t0KQ575Pkz7fdUAqbgGede8ZMSayPOvgR7lXPppZbMWcVNDWvzI2THUQzhqcuS', '', ''); INSERT INTO `khachhang` VALUES ('Ys7COrr5CwUmCxv3yOHgCcryx3e3xd0kl1fu9jV7GrvkbfYHl4LjoLSM3ELcxB', '', ''); INSERT INTO `khachhang` VALUES ('D3mJbFnppiKkwOp7fwRQNh46Trt0KQ575Pkz7fdUAqbgGede8ZMSayPOvgR7lX', '', ''); INSERT INTO `khachhang` VALUES ('3E49OYvW0CuZeimKBfZcGbGNAjkwUnePJzfHFCIBMJvvGFVStBQGJgBoyS1Yya', '', ''); INSERT INTO `khachhang` VALUES ('tTNlN8T8j9VJTUvTSTIO539dSSTj6jyQ6Qe0IruwiysCFbH0bLkUHiW2xdBDzw', '', ''); INSERT INTO `khachhang` VALUES ('4FFfr1bsa3SbKPXh9X95OwFrJ8eHmS3HGkRMaCSMLjN4WvRsHONjtiNsfAAgvK', '', ''); INSERT INTO `khachhang` VALUES ('UefQj3AxQq05OPCI6e1816jzrp4JHCoQCHTDz7DjoReBpmMHuDQmX6yMGLuGY5', '', ''); INSERT INTO `khachhang` VALUES ('8hP5EeQWyouxHKmDrLyqBoEDx6Kt5TsGBcRtU0xxnMB8OuEXBBLey6xG2q3vTz', '', ''); INSERT INTO `khachhang` VALUES ('bU0WQrvqWK6UFGKZKyWKofCOl5hgOURFv4QaFodjZfqdGtrsvpJ9ETgTPhxKho', '', ''); INSERT INTO `khachhang` VALUES ('S3Zq0MRzfBiNmTLeyuesxJayxsx7g1OgWgXzixr7xEexnZOT3o8MhaFifco2IO', 'C VAN', ''); INSERT INTO `khachhang` VALUES ('JQuq9y9m3RsCFApMG4rWlbxImg9aX8hVQ9m3fao9SvOkY2Cae5gKSuIHCBr4Hh', '', ''); INSERT INTO `khachhang` VALUES ('BMrLQLzwfJ4NDDyjlV6hfBjpF7hVssAyW3lvZU9vVu4LCKI1n9bs4H4P2Osk7v', 'chu hiep', ''); INSERT INTO `khachhang` VALUES ('WHFeC8vW5mZ7rCYJgANgEwhEc7No1CarFILghDpPp6rCbkIBb2zeusRuIiVPWL', '', ''); INSERT INTO `khachhang` VALUES ('quPQ73d9vkAx2p9RHVEsXWhaL3LkBlkNrrGUKp3wuRaX8Sd4F3WdwuydHMMqE0', '', ''); INSERT INTO `khachhang` VALUES ('j2GuW0dMdJZgIXmowR99fcHZYbSTjv1kkpXgEC2akk600hwfJG6R8fdjhcGzNg', '', ''); INSERT INTO `khachhang` VALUES ('C6TmkNQ9sp3w6aosPMbqLshouW0P5rfG9FjsNQ36BHO5ErrozNhspXaiOGskPa', 'chu hiep', ''); INSERT INTO `khachhang` VALUES ('Gz5CPgkL8BAfGQI26H3CrmrWlAeuRzgdB2SAFcUBDMIHC09QcAxxtKII2c3RYa', '', ''); INSERT INTO `khachhang` VALUES ('nXTm2rS0RjwPe0V2WwGlnkSZmm6Gf7tDRzyyzatHcTMK6cBW75xZBZE7nTy2Og', '', ''); INSERT INTO `khachhang` VALUES ('lYI3BDtLqfUlqxmhFIFvLvcwN7MhngKgAbXq1ALfLGZGqdZd6nBOmTaWkZxyzn', '', ''); INSERT INTO `khachhang` VALUES ('39dhzFOpqBu0rTOLZ2UUTZl9veeJGH9mKUcfyMY7sPzbhZAbmJ5jz2HieovmcJ', '', ''); INSERT INTO `khachhang` VALUES ('9iqbhhwrJPSJehXaZsIjJJChGVFFyoiyyYtxp0HImlUG5lAxPPHRj8JKK7CNQ8', '', ''); INSERT INTO `khachhang` VALUES ('xv3WwtKVjucrETSALyIXlMeDDsmflSzQHWR3pWFXGLY8gIfHmFsfGW4Rsp47oo', '', ''); INSERT INTO `khachhang` VALUES ('roaucKBaeGyYnbBEYIQpTeSWreMvtFaNmZ72UcfXuKCLVCPazf0phDHbnf2JI1', '', ''); INSERT INTO `khachhang` VALUES ('whX9oauO2PFVzwkuAWPWai0hUldWUghVKNyHxaScR4BWPJzQ0T7qvJ5BU0QTkV', '', ''); INSERT INTO `khachhang` VALUES ('ShvJNgXSfNNek5TLDRzXglFMNexGlM1EuFt9k8I9rT76Xbv0qGdjYE7ZbMxv9i', '', ''); INSERT INTO `khachhang` VALUES ('kPsVOrdTRi1SORW9u7Bogx4QX4WcVckI0SO4xBvvnjYKSujZQ78YFDwT915vFL', '', ''); INSERT INTO `khachhang` VALUES ('TZ3Oy5DD90hditj03HAY3qsBmPJRAFNdP9tCEY6ybnxZZ58nbiHIlKBsAEHztI', '', ''); INSERT INTO `khachhang` VALUES ('N6hWglg41Kezi883OQqBMK6OUaCMqXX53ryQ0upE0qZzg7fdwSEGXzczkxjXPC', '', ''); INSERT INTO `khachhang` VALUES ('0rcaJ7D0rARuCW7teL5iL91M9HCiTw7FWadgLM8UkUBW7GPd6Gx4JZXmZdNqkr', '', ''); INSERT INTO `khachhang` VALUES ('g6Jh6JFNva6CdKvOqkQYSeAcMjH6QVEKiTqLRAscLOKGHWLiTOsD4LjNsEhmLO', '', ''); INSERT INTO `khachhang` VALUES ('Qrc4YCvN7YSPh83vTaeGXG9GUL1mK0y3UuZCoQ1oF8SeGXhsUpsUj66Xo6sr40', '', ''); INSERT INTO `khachhang` VALUES ('eGRVDyHrpn4EKZW9oLM2xwyTVCJOLThoMGGJaQSqFImyv86Jnsx2vvG3DEXTXJ', '', ''); INSERT INTO `khachhang` VALUES ('n9c4nVzwWMOrwP7E7GewaomSFBd44m1VkiuOWtRzRvPxzuCy10YXG94CxwFQ2c', '', ''); INSERT INTO `khachhang` VALUES ('XvaNFWop0ZFCI0tv0OMHzM4gFJhOZ0TqLtSGIsHI2Nl5uRgUfsrM3YjL8dTtcx', '', ''); INSERT INTO `khachhang` VALUES ('6YilWjSHCHcAPuJ6OvsQh7QUraQT1YWSfo6sPMMJZYYhri7epCc9BhH8g7yM4t', '', ''); INSERT INTO `khachhang` VALUES ('FM6bN3rzsjIVlUolFGrqbYkg4D2s5015pVfLMJcyqiP52WCqRvwbBl2sui5OdI', '', ''); INSERT INTO `khachhang` VALUES ('bm2rhIDNPVgEPDClITVIukT6B0Lm1xeOd1xka2nflGYoGy48HJRikP4e2WVMPE', '', ''); INSERT INTO `khachhang` VALUES ('7h82UBWJZ3INzvqQoixWFf2I7JmfWAv7T8Vr9fANtfYi2Z3vBPgxmACY2ByVRK', 'chu hiep', ''); INSERT INTO `khachhang` VALUES ('3YwmAdhg7fPO6anRxyGJSvVh5CPRDZDiud2X7nhEv43K7pB5UXD1lQmmpDvuzq', '', ''); INSERT INTO `khachhang` VALUES ('gbhcMVBCz7fBCmVunIS7OOOOqIWr82ZlsRbnkMeQeUmD8Oh3vAdYjQTJ1Gv9BF', '', ''); INSERT INTO `khachhang` VALUES ('jCaPMb24GM5nUmVuLqEB7UQsjjCgbAxK4cJ6P7L4MOJSNgfddVokRMLU6iscLq', '', ''); INSERT INTO `khachhang` VALUES ('Fb6HXgD0JWPDd2Ea7UyIEowRxQ1H061PMuYk3SSNzBblwuRyEUnwbHHQOcjBLe', '', ''); INSERT INTO `khachhang` VALUES ('aoLbJj1RZYgDprIkWk5i4IAnLcWUtSnLblCfnGReZvQ2vUMxUsn2DgRqGVX0vw', '', ''); INSERT INTO `khachhang` VALUES ('SE5FlGSrAXRqiPuKI7JYxa5c1Qu1QuqygVRmXvgya4AICZkXw4rRAGpv3EavCk', 'chu hiep', ''); INSERT INTO `khachhang` VALUES ('dXvzvrrHw3DzdoPw3xdp27vyBbXPImfySJDA1SNgEVZqHqUqFvL6uKjOFfJn9A', '', ''); INSERT INTO `khachhang` VALUES ('0vxuWja2AQNGmbCghWl6Mce3QyYtW7Mb1soyAG0pznm6tEFse4EQlLv6LiZzYL', '', ''); INSERT INTO `khachhang` VALUES ('X6zoYZZnS35o6m5gEwGmYC6u3g42lwNOP11aXPVXHygwyieHsCzPTEtLPXGQJE', 'chu hiep', ''); INSERT INTO `khachhang` VALUES ('VAqAYsJwkbDFtQnSm2EtsSHjKWdJGjrAgB6dUTnrDM1ESnfDDfLNluMVZJ3o21', 'chu hiep', ''); INSERT INTO `khachhang` VALUES ('L2tZDdJHUKOLiZagZMMOKt6uKU6TKqg7WSyK4AqSjqR7qIkyCjNLBxJRBh6rkQ', '', ''); INSERT INTO `khachhang` VALUES ('oVzjlkN3KUprj1SBgu86kFG3Jpt2a2Z9RpbZxRwDqf0IeT4haFGXYTlPQqZtwB', '', ''); INSERT INTO `khachhang` VALUES ('mz05vSml0rBtNQrOnc7cH5kZeBj0XlMClpWFlowtrnKTBXkhheuttMWNCJU7HE', '', ''); INSERT INTO `khachhang` VALUES ('6McDLC3hzYLGMHhq674CK67RqZSdnCjjjjVdrWDxuQXmGSPhJlJpR8DjMy05It', '', ''); INSERT INTO `khachhang` VALUES ('L8wQJyDpr61IOno6mtYq0Zs1gZ5J46ATVp8mLvvt4tS5OVYwsW2DY7LMPynM0Q', '', ''); INSERT INTO `khachhang` VALUES ('rhH2vBqzLRhvWoIXg2Ivr8KfGxLMJBgcN8c5Aw1xkzJ9JEM12A8KWJhpGWaBXx', '', ''); INSERT INTO `khachhang` VALUES ('jHpNb1R5k4Z7rdhXLhGd0DGYo5fQC0QTWdqK35usarYF1DnqPuEmjngxF8bzD6', '', ''); INSERT INTO `khachhang` VALUES ('gr0nyuxNvSLE49pgJsHvrllHHVyHrO4Q936ZNhmsRA46hxXhygeOCkB3ZPjQAn', '', ''); INSERT INTO `khachhang` VALUES ('3xU34YVs4u5FgWmjnEfrDuGGKM96VmBkUBxqUlUZDTb8k8krFpO0UxBpLSbLqg', '', ''); INSERT INTO `khachhang` VALUES ('vEE33aD4MU5G9YgIaXQxfV4XpvEl6MNwhlgRqidbwcqQ0b4GSQT2zf6L5ZpbSb', '', ''); INSERT INTO `khachhang` VALUES ('3aVqJ3GMGF8SCnJMK0s6OULV0VEQ3pyXbcsS6COE2xCUHhkKjIUJBaQYMu44z0', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `lic_file` -- CREATE TABLE `lic_file` ( `TenCTY` varchar(200) NOT NULL, `Diachi` varchar(255) NOT NULL, `Phone` varchar(20) NOT NULL, `CK` varchar(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `lic_file` -- INSERT INTO `lic_file` VALUES ('CÔNG TY TNHH NGUYỄN QUỲNH LAN', 'P Trung Dũng, TP Biên Hoà, Đồng Nai', '02513825857', 'QL');