INSERT INTO `bills` (`id`, `code`, `customer_id`, `user_id`, `branch_id`, `volume`, `paid`, `is_debit`, `status`, `note`, `trash`, `created`, `updated`) VALUES
(1, 'HD00001', 1, 1, 1, 687500, 687500, 0, 1, '', 0, '2013-09-26 10:11:30', '2013-09-26 10:11:30'),
(2, 'HD00002', 1, 1, 1, 110000, 110000, 0, 1, '', 0, '2013-09-26 18:09:01', '2013-09-26 18:09:01'),
(3, 'HD00003', 1, 1, 1, 577500, 577500, 0, 2, '', 0, '2013-09-26 18:13:02', '2013-09-26 18:13:02'),
(4, 'HD00004', 2, 1, 1, 577500, 0, 1, 1, '', 0, '2013-09-26 18:19:57', '2013-09-26 18:19:57');

INSERT INTO `bill_details` (`id`, `bill_id`, `product_id`, `product_code`, `product_name`, `product_quantity`, `product_rate`, `product_price`, `import_price`, `product_return`, `product_vat`, `created`, `updated`) VALUES
(1, 1, 1, 'SP00001', 'Quần Jean', 1, 0, 100000, 50000, 0, 10, '2013-09-26 10:11:30', '2013-09-26 10:11:30'),
(2, 1, 2, 'SP00002', 'Áo thun Hàn Quốc', 1, 0, 200000, 100000, 0, 5, '2013-09-26 10:11:30', '2013-09-26 10:11:30'),
(3, 1, 3, 'SP00003', 'Quần Jean cao cấp', 1, 0, 350000, 200000, 0, 5, '2013-09-26 10:11:30', '2013-09-26 10:11:30'),
(4, 2, 1, 'SP00001', 'Quần Jean', 1, 0, 100000, 50000, 0, 10, '2013-09-26 18:09:02', '2013-09-26 18:09:02'),
(5, 3, 2, 'SP00002', 'Áo thun Hàn Quốc', 1, 0, 200000, 100000, 0, 5, '2013-09-26 18:13:02', '2013-09-26 18:13:02'),
(6, 3, 3, 'SP00003', 'Quần Jean cao cấp', 1, 0, 350000, 200000, 0, 5, '2013-09-26 18:13:02', '2013-09-26 18:13:02'),
(7, 4, 2, 'SP00002', 'Áo thun Hàn Quốc', 1, 0, 200000, 100000, 0, 5, '2013-09-26 18:19:57', '2013-09-26 18:19:57'),
(8, 4, 3, 'SP00003', 'Quần Jean cao cấp', 1, 0, 350000, 200000, 0, 5, '2013-09-26 18:19:57', '2013-09-26 18:19:57');

INSERT INTO `branches` (`id`, `name`, `address`, `email`, `phone`, `created`, `updated`) VALUES
(2, 'Chi nhánh quận 10', '235A Nguyễn Tri Phương, Quận 10, Tp.HCM', NULL, '08.368657', '2013-08-20 14:28:37', '2013-08-20 14:28:37');

INSERT INTO `customers` (`id`, `code`, `branch_id`, `name`, `email`, `phone`, `address`, `note`, `left`, `trash`, `created`, `updated`) VALUES
(2, 'KH00002', 1, 'Nguyễn Hữu Thuận', 'huuthuan90@gmail.com', '0988210532', '252A Nguyễn Sơn, Tân Thành, Tân Phú', '', 577000, 0, '2013-09-26 09:40:51', '2013-09-26 18:21:23'),
(3, 'KH00003', 1, 'Nguyễn Thị Thu', '', '01679977090', '205 Nguyễn Công Trứ, Bảo Lộc, Lâm Đồng', '', 0, 0, '2013-09-26 09:41:16', '2013-09-26 09:41:16');

INSERT INTO `imports` (`id`, `code`, `supplier_id`, `user_id`, `branch_id`, `volume`, `paid`, `is_debit`, `status`, `note`, `trash`, `created`, `updated`) VALUES
(1, 'PN00001', 1, 1, 1, 1210000, 1210000, 0, 1, '', 0, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(2, 'PN00002', 1, 1, 2, 101000, 101000, 0, 1, '', 0, '2013-09-26 11:18:56', '2013-09-26 11:18:56'),
(3, 'PN00003', 1, 1, 2, 150000, 150000, 0, 1, '', 0, '2013-09-26 14:40:34', '2013-09-26 14:40:34');

INSERT INTO `import_details` (`id`, `import_id`, `product_id`, `product_code`, `product_name`, `product_quantity`, `product_rate`, `product_price`, `product_sell`, `product_discount`, `product_vat`, `created`, `updated`) VALUES
(1, 1, 1, 'SP00001', 'Quần Jean', 3, 10000, 50000, 100000, NULL, NULL, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(2, 1, 2, 'SP00002', 'Áo thun Hàn Quốc', 3, 20000, 100000, 200000, NULL, NULL, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(3, 1, 3, 'SP00003', 'Quần Jean cao cấp', 5, 30000, 200000, 350000, NULL, NULL, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(4, 2, 1, 'SP00001', 'Quần Jean', 1, 1000, 41000, 100000, NULL, NULL, '2013-09-26 11:18:56', '2013-09-26 11:18:56'),
(5, 2, 2, 'SP00002', 'Áo thun Hàn Quốc', 1, 2000, 19000, 200000, NULL, NULL, '2013-09-26 11:18:56', '2013-09-26 11:18:56'),
(6, 2, 3, 'SP00003', 'Quần Jean cao cấp', 1, 5000, 49000, 350000, NULL, NULL, '2013-09-26 11:18:56', '2013-09-26 11:18:56'),
(7, 3, 2, 'SP00002', 'Áo thun Hàn Quốc', 1, 0, 100000, 200000, NULL, NULL, '2013-09-26 14:40:34', '2013-09-26 14:40:34'),
(8, 3, 3, 'SP00003', 'Quần Jean cao cấp', 1, 0, 50000, 350000, NULL, NULL, '2013-09-26 14:40:34', '2013-09-26 14:40:34');

INSERT INTO `products` (`id`, `code`, `name`, `price`, `vat`, `note`, `thumb`, `trash`, `is_like`, `created`, `updated`) VALUES
(1, 'SP00001', 'Quần Jean', 100000, 10, '', '', 0, 0, '2013-09-26 09:34:47', '2013-09-26 09:34:47'),
(2, 'SP00002', 'Áo thun Hàn Quốc', 200000, 5, '', '', 0, 1, '2013-09-26 09:36:12', '2013-09-26 18:25:11'),
(3, 'SP00003', 'Quần Jean cao cấp', 350000, 5, '', '', 0, 0, '2013-09-26 09:37:15', '2013-09-26 09:37:15');

INSERT INTO `products_catalogs` (`id`, `catalog_id`, `product_id`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3);

INSERT INTO `reserves` (`id`, `product_id`, `branch_id`, `left`, `created`, `updated`) VALUES
(1, 1, 1, 2, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(2, 2, 1, 2, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(3, 3, 1, 4, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(4, 1, 2, 1, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(5, 2, 2, 2, '2013-09-26 10:09:09', '2013-09-26 10:09:09'),
(6, 3, 2, 2, '2013-09-26 10:09:09', '2013-09-26 10:09:09');

INSERT INTO `suppliers` (`id`, `code`, `name`, `address`, `email`, `phone`, `contact_name`, `website`, `note`, `left`, `trash`, `created`, `updated`) VALUES
(3, 'NCC00003', 'Công Ty TNHH Tân Phạm Gia', 'C9/5 Tổ 19, Khu Phố 1, P. Tân Thới Hiệp, Q. 12, Tp. Hồ Chí Minh (TPHCM)', 'thanh.pham@tanphamgia.com.vn', '(08 ) 37159101', '', 'www.happyhoop.com.vn', '', 1447000, 0, '2013-08-28 09:37:06', '2013-09-18 10:28:22'),
(5, 'NCC00005', 'Công Ty TNHH Thương Mại Thời Trang An Dương', 'Phòng 106, C4 Khu Đô Thị Mới Đại Kim,Q. Hoàng Mai, Hà Nội', 'info@thoitranganduong.vn', '(04 ) 36415898', '', 'www.thoitranganduong.vn', '', 500000, 0, '2013-08-28 10:18:25', '2013-08-28 10:18:25'),
(6, 'NCC00006', 'Công Ty TNHH Thời Trang Minh Thư', '129 Đề Thám, P. Cô Giang, Q. 1, Tp. Hồ Chí Minh (TPHCM)', 'aodaiminhthu@yahoo.com', '(08 ) 38361947', '', 'www.aodaiminhthu.com', '', 0, 0, '2013-08-28 10:19:12', '2013-08-28 10:19:12'),
(7, 'NCC00007', 'Doanh Nghiệp Tư Nhân Thuận Kiều Vải', '297 ấp Voi Lá,Quốc Lộ 1A, H. Bến Lức, Long An', '', '(072 ) 3633283', '', 'www.tkvtextile.com', '', 0, 1, '2013-08-28 10:20:05', '2013-09-23 16:53:49'),
(9, 'NCC00009', 'Việt Mạnh Trung - Công Ty TNHH Việt Mạnh Trung', '201-203-248 Đường Số 11, P. Phước Bình, Q. 9, Tp. Hồ Chí Minh (TPHCM)', 'thanhtrungvmt@gmail.com', '(08 ) 66579867', '', 'www.hibe.com.vn', '', 0, 0, '2013-09-16 14:48:18', '2013-09-16 14:48:18');

INSERT INTO `tickets` (`id`, `code`, `foreign_id`, `type`, `volume`, `left`, `note`, `created`) VALUES
(1, 'PTT00001', 2, 1, 500, 577000, '', '2013-09-26 18:21:23');