-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdata_DienThoai.txt
144 lines (128 loc) · 8.5 KB
/
data_DienThoai.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
INSERT INTO staff_login (LoginUserName, LoginPassword, LoginStatus) VALUES
('user1', '123456789', '1'),
( 'user2', '123456781', '1'),
( 'user3', '123456773', '1'),
( 'user4', '123456765', '1'),
( 'user5', '123456757', '1'),
('user6', '123456749', '1'),
( 'user7', '123456741', '1'),
( 'user8', '123456733', '1'),
( 'user9', '123456725', '1'),
( 'user10', '123456717', '1'),
( 'user11', '123456709', '1'),
( 'user12', '123456701', '1'),
( 'user13', '123456693', '1'),
( 'user14', '123456685', '1'),
( 'user15', '123456677', '1'),
( 'user16', '123456709', '1'),
( 'user17', '123456701', '1'),
( 'user18', '123456693', '1'),
( 'user19', '123456685', '1'),
('user20', '123456677', '1');
INSERT INTO staff ( staName, staBirthday, staAddress, staImg, staPhone, staSex, staDescription, staStatus, staSalary, staPosition, LoginID) VALUES
( N'Nguyễn Minh Hiếu', '09/28/2001', 'Kiên Giang', NULL, '374422286', 1, NULL, '1', 8000000, N'Giám đốc', 1),
(N'Trần Đức Hiếu', '09/29/2001', N'Kiên Gang', NULL, '374422287', 1, NULL, '1', 9000000, N'Nhân Viên', 2),
(N'Dương Nghĩa Hiệp', '2001-09-30', N'Kiên Giang', NULL, '374422288',1, NULL, '1', 10000000, N'Nhân Viên', 3),
(N'Nguyễn Công Chính', '2001-10-01', N'Gò Vấp', NULL, '374422289', 1, NULL, '1', 11000000, N'Nhân Viên', 4),
( N'Nguyễn Nhan Gia Bảo', '2001-10-02', N'Q5', NULL, '374422290', 1, NULL, '1', 12000000, N'Nhân Viên', 5),
(N'Trần Dương Trí Hiếu', '2001-10-03', N'Bình Chánh ', NULL, '374422291', 1, NULL, '1', 13000000, N'Nhân Viên', 6),
( N'Nguyễn Đình Thủ', '2001-10-04', N'Tân Phú', NULL, '374422292', 1, NULL, '1', 14000000, N'Nhân Viên', 7),
(N'Nguyễn Hiếu', '2001-10-05', N'Tân Bình', NULL, '374422293',1, NULL, '1', 15000000, N'Nhân Viên', 8),
(N'Trần Hiếu', '2001-10-06', N'Kiên Giang', NULL, '374422294', 1, NULL, '1', 16000000, N'Nhân Viên', 9),
( N'Dương Thu', '2001-10-07', N'Kiên Gang', NULL, '374422295', 0, NULL, '1', 17000000, N'Nhân Viên', 10),
( N'Nguyễn Hồng', '2001-10-08', N'Kiên Giang', NULL, '374422296', 0, NULL, '1', 18000000, N'Nhân Viên', 11),
(N'Nguyễn Thảo', '2001-10-09', N'Gò Vấp', NULL, '374422297', 0, NULL, '1', 19000000, N'Nhân Viên', 12),
( N'Trần Hạnh', '2001-10-10', N'Q5', NULL, '374422298', 0, NULL, '1', 20000000, N'Nhân Viên', 13),
( N'Nguyễn Minh', '2001-10-11', N'Bình Chánh ', NULL, '374422299',0, NULL, '1', 21000000, N'Nhân Viên', 14),
(N'Nguyễn Trân', '2001-10-12',N'Tân Phú', NULL, '374422300', 0, NULL, '1', 22000000, N'Nhân Viên', 15);
INSERT INTO client ( cliName, cliAddress, cliCountry, cliPostOfficeCode, cliPhone, cliStatus , cliUser, cliPass) VALUES
( N'Nguyễn Thị Hồng Hạnh', '', N'TH HCM', '12345', '0799501324', '1','user1','123'),
(N'Nguyễn Gia Hòa', '', N'TH HCM', '12346', '0799501325', '1','user2','123'),
( N'Nguyễn Nhan Gia Bảo', '', N'TH HCM', '12347', '0799501326', '1', 'user3','123'),
( N'Nguyễn Công Chính', '', 'NTH HCM', '12348', '0799501327', '1', 'user4','123'),
( N'Dương Nghĩa Hiệp', '', N'TH HCM', '12349', '0799501328', '1', 'user5','123');
INSERT INTO category ( catName, catDescription, catStatus) VALUES
(N'Điện thoại Phím', 'NULL', '1'),
(N'Điện thoại Cảm ứng', 'NULL', '1'),
(N'Điện thoại Gaming', 'NULL', '1');
INSERT INTO provided ( provFullName, provName, provAddress,provPostOfficeCode, provCountry, provPhone, provDescription, provStatus) VALUES
( NULL, N'Xiaomi Inc', N'116 Nguyễn Du, Q.1, Tp. Hồ Chí Minh', '12345',N'TP HCM', '0799501324', NULL, '1'),
( NULL, N'Apple Inc', N'246 Nguyễn Hồng Đào, Q.Tân Bình, Tp. Hồ Chí Minh', '12346', 'TP HCM', '0799501325', NULL, '1'),
( NULL, N'Samsung Inc', N'718bis Kinh Dương Vương, Q.6, Tp. Hồ Chí Minh', '12347', 'TP HCM', '0799501326', NULL, '1'),
(NULL, N'Huawei Inc', N'Lầu 304A Quang Trung, P.11, Q. Gò Vấp, Tp. Hồ Chí Minh', '12348', 'TP HCM', '0799501327', NULL, '1'),
(NULL, N'Oppo Inc', N'Tầng 10, CT Plaza, 60A Trường Sơn, P.2, Q. Tân Bình, Tp. Hồ Chí Minh', '12349', 'TP HCM', '0799501328', NULL, '1'),
(NULL, N'Vivo Inc', N'Tầng 7, Hùng Vương Plaza, 126 Hùng Vương, Q.5, Tp. Hồ Chí Minh', '12350', 'TP HCM', '0799501329', NULL, '1'),
(NULL, N'Sony Inc', N'Lầu 3, Aeon Mall 30 Bờ Bao Tân Thắng, P. Sơn Kỳ, Q. Tân Phú, Tp. Hồ Chí Minh', '12351', 'TP HCM', '0799501330', NULL, '1'),
(NULL, N'Lenovo Inc', N'Tầng 2, Thảo Điền Mall, 12 Quốc Hương, P. Thảo Điền, Q.2, Tp. Hồ Chí Minh', '12352', 'TP HCM', '0799501331', NULL, '1'),
(NULL, N'Vismart Inc', N'Tầng 5, TTTM Vincom Thủ Đức, 216 Võ Văn Ngân, P. Bình Thọ, Q. Thủ Đức, Tp. Hồ Chí Minh', '12353', 'TP HCM', '0799501332', NULL, '1'),
(NULL, N'OnePlus Inc ', N'Tầng 5 TTTM Vincom Plaza Gò Vấp, 12 Phan Văn Trị, P.7, Q. Gò Vấp, Tp. Hồ Chí Minh', '12354', 'TP HCM', '0799501333', NULL, '1'),
(NULL, N'SmartPhone Inc', N'Lầu 3 & 4, TTTM ICON 68, 2 Hải Triều, Q.1, Tp. Hồ Chí Minh', '12355', 'TP HCM', '0799501334', NULL, '1'),
(NULL, N'Bphone Inc', N'52 Lê Văn Việt, Quận 9, Tp. Hồ Chí Minh', '12356', 'TP HCM', '0799501335', NULL, '1'),
(NULL, N'Tencent Inc', N'Tầng 3, Lotte Mart, 469 Nguyễn Hữu Thọ, P. Tân Hưng, Q.7, Tp. Hồ Chí Minh', '12357', 'TP HCM', '0799501336', NULL, '1'),
(NULL, N'SuperPhone Inc', N'Tầng 4, Pico Plaza, 20 Cộng Hòa, P.12, Q. Tân Bình, Tp. Hồ Chí Minh', '12358', 'TP HCM', '0799501337', NULL, '1'),
(NULL, N'Cphone', N'Tầng 4 Lotte Mart Phú Thọ, ngã tư 3/2 và Lê Đại Hành, Q.11, Tp. Hồ Chí Minh', '12359', 'TP HCM', '0799501338', NULL, '1');
INSERT INTO product ( prodName, prodPrice, prodSL, prodInit, prodReleaseYear, prodDescription, prodStatus, provID, catID) VALUES
( N'Xiaomi 1280', 45000, 100, N'đ', 2001, NULL, '1', 1, 1),
( N'Apple 1280', 45000, NULL, N'đ', 2002, 'NULL', '1', 2, 1),
( N'Samsung 1280', 45000, NULL, N'đ', 2003, NULL, '1', 3, 1),
( N'Huawei 1280', 45000, NULL, N'đ', 2004, NULL, '1', 4, 1),
( N'Oppo Phone', 45000, NULL, N'đ', 2005, NULL, '1', 5, 2),
( N'Vivo Phone', 45000, NULL, N'đ', 2006, NULL, '1', 6, 2),
( N'Sony phone', 45000, NULL, N'đ', 2007, NULL, '1', 7, 2),
( N'Lenovo Gaming', 45000, NULL, N'đ', 2015,NULL, '1', 15, 3),
( N'Vismart Phone', 45000, NULL, N'đ', 2008, NULL, '1', 8, 2),
( N'OnePlus Phone', 45000, NULL, N'đ', 2009, NULL, '1', 9, 2),
(N'SmartPhone Gaming', 45000, NULL, N'đ', 2010, NULL, '1', 10, 3),
( N'Bphone gaming', 45000, NULL, N'đ', 2011, NULL, '1', 11, 3),
( N'Tencent ganing', 45000, NULL, N'đ', 2012,NULL, '1', 12, 3),
(N'Super Gaimg', 45000, NULL, N'đ', 2013,NULL, '1', 13, 3),
( N'CPhone Gaming', 45000, NULL, N'đ', 2014,NULL, '1', 14, 3);
;
INSERT INTO images (prodID, img1, img2, img3, img4) VALUES
(1, 'hinh1.1', 'hinh1.2', 'hinh1.3', 'hinh1.4'),
(2, 'hinh2.1', 'hinh2.2', 'hinh2.3', 'hinh2.4'),
(3, 'hinh3.1', 'hinh3.2', 'hinh3.3', 'hinh3.4'),
(4, 'hinh4.1', 'hinh4.2', 'hinh4.3', 'hinh4.4'),
(5, 'hinh5.1', 'hinh5.2', 'hinh5.3', 'hinh5.4'),
(6, 'hinh6.1', 'hinh6.2', 'hinh6.3', 'hinh6.4'),
(7, 'hinh7.1', 'hinh7.2', 'hinh7.3', 'hinh7.4'),
(8, 'hinh8.1', 'hinh8.2', 'hinh8.3', 'hinh8.4'),
(9, 'hinh9.1', 'hinh9.2', 'hinh9.3', 'hinh9.4'),
(10, 'hinh10.1', 'hinh10.2', 'hinh10.3', 'hinh10.4'),
(11, 'hinh11.1', 'hinh11.2', 'hinh11.3', 'hinh11.4'),
(12, 'hinh12.1', 'hinh12.2', 'hinh12.3', 'hinh12.4'),
(13, 'hinh13.1', 'hinh13.2', 'hinh13.3', 'hinh13.4'),
(14, 'hinh14.1', 'hinh14.2', 'hinh14.3', 'hinh14.4'),
(15, 'hinh15.1', 'hinh15.2', 'hinh15.3', 'hinh15.4');
INSERT INTO orderr ( ordDate, ordDescription, ordBill, ordStatus, cliID, staID) VALUES
( '2021-09-29', NULL, 1, '1', 1, 1),
( '2021-09-30', NULL, 1, '1', 2, 2),
( '2021-10-01', NULL, 1, '1', 3, 3),
( '2021-10-02', NULL, 1, '1', 4, 4),
( '2021-10-03', NULL, 1, '1', 5, 5),
( '2021-10-04', NULL,1, '1', 1, 6),
( '2021-10-05', NULL, 1, '1', 2, 7),
( '2021-10-06', NULL, 0, '1', 3, 8),
('2021-10-07', NULL, 0, '1', 4, 9),
( '2021-10-08', NULL, 0, '1', 5, 10),
( '2021-10-09', NULL, 0, '1', 1, 11),
( '2021-10-10', NULL, 0, '1', 2, 12),
('2021-10-11', NULL, 0, '1', 3, 13),
('2021-10-12', NULL, 0, '1', 4, 14),
('2021-10-13', NULL, 0, '1', 5, 15);
INSERT INTO information_order (ordID, prodID, infoOrderSL, infoOrderPrice, infoStatus) VALUES
( 1, 1, 4, 180000, '1'),
( 2, 2, 5, 225000, '1'),
( 3, 3, 6, 270000, '1'),
( 4, 4, 7, 315000, '1'),
( 5, 5, 8, 360000, '1'),
( 6, 6, 9, 405000, '1'),
( 7, 7, 10, 450000, '1'),
( 8, 8, 11, 495000, '1'),
( 9, 9, 12, 540000, '1'),
( 10, 10, 13, 585000, '1'),
( 11, 11, 14, 630000, '1'),
(12, 12, 15, 675000, '1'),
( 13, 13, 16, 720000, '1'),
(14, 14, 17, 765000, '1'),
(15, 15, 20, 810000, '1');