· 6 years ago · Oct 08, 2019, 02:48 AM
1-- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `cart`;
9CREATE TABLE `cart` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `id_produk` int(11) NOT NULL,
12 `harga` decimal(18,2) NOT NULL,
13 `jumlah` int(11) NOT NULL,
14 `sub_total` decimal(18,2) NOT NULL,
15 `diskon` decimal(18,2) NOT NULL,
16 `total` decimal(18,2) NOT NULL,
17 `id_member` int(11) NOT NULL,
18 `keterangan` text NOT NULL,
19 `tanggal` date NOT NULL,
20 `jam` text NOT NULL,
21 PRIMARY KEY (`id`),
22 KEY `id_produk` (`id_produk`),
23 KEY `id_member` (`id_member`),
24 CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`id_produk`) REFERENCES `produk` (`id`),
25 CONSTRAINT `cart_ibfk_2` FOREIGN KEY (`id_member`) REFERENCES `member` (`id`)
26) ENGINE=InnoDB DEFAULT CHARSET=latin1;
27
28INSERT INTO `cart` (`id`, `id_produk`, `harga`, `jumlah`, `sub_total`, `diskon`, `total`, `id_member`, `keterangan`, `tanggal`, `jam`) VALUES
29(10, 2, 60000.00, 2, 120000.00, 0.00, 120000.00, 3, '', '2019-09-14', '20::45:13'),
30(12, 2, 60000.00, 1, 60000.00, 0.00, 60000.00, 2, '', '2019-09-21', '22::11:57');
31
32DROP TABLE IF EXISTS `copy_writing`;
33CREATE TABLE `copy_writing` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `id_produk` int(11) NOT NULL,
36 `judul` text NOT NULL,
37 `isi_content` text NOT NULL,
38 `tanggal` date NOT NULL,
39 `status` text NOT NULL,
40 PRIMARY KEY (`id`)
41) ENGINE=InnoDB DEFAULT CHARSET=latin1;
42
43INSERT INTO `copy_writing` (`id`, `id_produk`, `judul`, `isi_content`, `tanggal`, `status`) VALUES
44(1, 2, 'NUTRISIO', 'NEO BRAIN adalah Superdrink ( jamu tetes konsentrasi tinggi ) dari formulasi 25 ekstrak herbal murni yang terstandar untuk terapi sel – sel otak dan gangguan kesehatan yang berkaitan dengan syaraf otak tepi.\r\n\r\nNEO BRAIN merupakan inovasi formulasi herbal yang diramu secara fungsional dan rasional-medik dengan mengacu teknologi biomolekuler untuk optimalisasi bioavailabilitas.\r\n\r\nDengan memadukan kehebatan kearifan lokal (local genius) – pusaka ramuan jamu nusantara yang telah teruji manfaatnya selama ratusan tahun – menjadi karya formula unik NEO BRAIN yang berkasiat dan mengagumkan.\r\n\r\nManfaat NEO BRAIN Untuk Anak:\r\n- Meningkatkan Daya Ingat, Daya Konsentrasi, dan Kecerdasan.\r\n- Meningkatkan Imunitas.\r\n- Menigkatkan Mood.\r\n- Mencegah Step (Convulsion).\r\n- Meringankan Epilepsi.\r\n- Meringankan Diare, Thypus, DBD (Demam Berdarah)\r\n- Meringankan Autis, ADHD (Attention Defisit Hypheractivity Disorder).\r\n- Mencegah dari bahaya Radiasi (Hp, Laptop, TV, Dll).\r\n- Dll\r\n\r\nManfaat NEO BRAIN untuk Dewasa:\r\n- Mencegah Hipertensi, Stroke, Jantung Koroner, Alzaemer, Depresi, Stress.\r\n- Meringankan Epilepsi, Kejang-Kejang, Vertigo, dan Migrain.\r\n- Meningkatkan Daya Konsentrasi, Relaksasi, dan lain sebagainya.\r\n- Mencegah Kepikunan Dini.\r\n- Membantu Mengendalikan Psoriasis.\r\n- Memulihkan Ingatan.\r\n- Mencegah dari bahaya Radiasi (Hp, Laptop, TV, Dll).\r\n- Dll', '2019-08-28', 'AKTIF');
45
46DROP TABLE IF EXISTS `detail_transaksi`;
47CREATE TABLE `detail_transaksi` (
48 `id` int(11) NOT NULL AUTO_INCREMENT,
49 `id_transaksi` int(11) NOT NULL,
50 `id_produk` int(11) NOT NULL,
51 `jumlah` int(11) NOT NULL,
52 `harga` decimal(10,0) NOT NULL,
53 `diskon` decimal(10,0) NOT NULL,
54 `cashback` decimal(10,0) NOT NULL,
55 `total` decimal(10,0) NOT NULL,
56 PRIMARY KEY (`id`),
57 KEY `id_penjualan` (`id_transaksi`),
58 KEY `id_produk` (`id_produk`),
59 CONSTRAINT `detail_transaksi_ibfk_2` FOREIGN KEY (`id_produk`) REFERENCES `produk` (`id`),
60 CONSTRAINT `detail_transaksi_ibfk_3` FOREIGN KEY (`id_transaksi`) REFERENCES `transaksi` (`id`)
61) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62
63INSERT INTO `detail_transaksi` (`id`, `id_transaksi`, `id_produk`, `jumlah`, `harga`, `diskon`, `cashback`, `total`) VALUES
64(1, 4, 2, 1, 40000, 0, 0, 40000),
65(59, 44, 2, 2, 60000, 0, 0, 120000),
66(60, 44, 3, 1, 350000, 0, 0, 350000),
67(61, 47, 3, 1, 350000, 0, 0, 350000),
68(62, 50, 2, 1, 60000, 0, 0, 60000),
69(63, 50, 3, 1, 350000, 0, 0, 350000),
70(64, 51, 2, 1, 60000, 0, 0, 60000),
71(65, 74, 2, 2, 60000, 0, 0, 120000),
72(66, 74, 3, 4, 350000, 0, 0, 1400000);
73
74DROP TABLE IF EXISTS `funnel`;
75CREATE TABLE `funnel` (
76 `id` int(11) NOT NULL AUTO_INCREMENT,
77 `nama_funnel` text NOT NULL,
78 `jumlah_trafic` int(11) NOT NULL,
79 `link` text NOT NULL,
80 `status` text NOT NULL,
81 PRIMARY KEY (`id`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83
84INSERT INTO `funnel` (`id`, `nama_funnel`, `jumlah_trafic`, `link`, `status`) VALUES
85(1, 'Ground', 29, 'https://akademibisnis.id/ground', 'AKTIF'),
86(2, 'Starter', 1, 'https://akademibisnis.id/starter', 'AKTIF'),
87(3, 'Red Nutrisio', 0, 'https://akademibisnis.id/rednutrisio', 'AKTIF'),
88(4, 'Green Nutrisio', 0, 'https://akademibisnis.id/greennutrisio', 'AKTIF');
89
90DROP TABLE IF EXISTS `galeri`;
91CREATE TABLE `galeri` (
92 `id` int(11) NOT NULL AUTO_INCREMENT,
93 `tanggal` date NOT NULL,
94 `gambar` text NOT NULL,
95 `id_admin` text NOT NULL,
96 PRIMARY KEY (`id`)
97) ENGINE=InnoDB DEFAULT CHARSET=latin1;
98
99INSERT INTO `galeri` (`id`, `tanggal`, `gambar`, `id_admin`) VALUES
100(2, '2019-03-23', 'upload/a33229ce956c6a5b64376288a9a5a629628fe4896137d3f4d288c559dd2cb517.jpg', '');
101
102DROP TABLE IF EXISTS `komisi`;
103CREATE TABLE `komisi` (
104 `id` int(11) NOT NULL AUTO_INCREMENT,
105 `id_transaksi` int(11) NOT NULL,
106 `komisi` decimal(10,0) NOT NULL,
107 `jenis_komisi` text NOT NULL,
108 `id_member` text NOT NULL,
109 `tanggal` date NOT NULL,
110 PRIMARY KEY (`id`),
111 KEY `id_penjualan` (`id_transaksi`),
112 CONSTRAINT `komisi_ibfk_1` FOREIGN KEY (`id_transaksi`) REFERENCES `transaksi` (`id`)
113) ENGINE=InnoDB DEFAULT CHARSET=latin1;
114
115INSERT INTO `komisi` (`id`, `id_transaksi`, `komisi`, `jenis_komisi`, `id_member`, `tanggal`) VALUES
116(2, 5, 100000, 'PENDAFTARAN', '6', '2019-09-02'),
117(5, 4, 0, 'PENJUALAN', '5', '2019-09-02'),
118(6, 4, 4000, 'PENJUALAN', '4', '2019-09-02'),
119(7, 4, 3000, 'PENJUALAN', '3', '2019-09-02'),
120(8, 6, 500000, 'UPGRADE LISENSI AGEN', '4', '2019-09-03'),
121(9, 6, 375000, 'UPGRADE LISENSI AGEN', '3', '2019-09-03'),
122(10, 44, 30000, 'PENJUALAN', '0', '2019-09-11'),
123(11, 44, 23000, 'PENJUALAN', '0', '2019-09-11'),
124(12, 47, 20000, 'PENJUALAN', '2', '2019-09-11'),
125(13, 47, 15000, 'PENJUALAN', '0', '2019-09-11'),
126(14, 48, 100000, 'PENDAFTARAN', '3', '2019-09-11'),
127(15, 48, 100000, 'PENDAFTARAN', '3', '2019-08-11'),
128(16, 72, 100000, 'PENDAFTARAN', '3', '2019-09-14');
129
130DROP TABLE IF EXISTS `log_alamat`;
131CREATE TABLE `log_alamat` (
132 `id` int(11) NOT NULL AUTO_INCREMENT,
133 `nama_history` text NOT NULL,
134 `id_member` int(11) NOT NULL,
135 `alamat` text NOT NULL,
136 `kecamatan` text NOT NULL,
137 `kota` text NOT NULL,
138 `provinsi` text NOT NULL,
139 `kode_pos` text NOT NULL,
140 PRIMARY KEY (`id`),
141 KEY `id_member` (`id_member`)
142) ENGINE=InnoDB DEFAULT CHARSET=latin1;
143
144INSERT INTO `log_alamat` (`id`, `nama_history`, `id_member`, `alamat`, `kecamatan`, `kota`, `provinsi`, `kode_pos`) VALUES
145(1, 'Rumah Sendiri', 3, 'jln raya nanjung,Cibodas 02', 'Cimahi Selatan', '107', '9', '0'),
146(3, 'Rumah Saya', 3, 'Pantek', 'Pandeglang Selatan', '331', '3', ''),
147(4, 'RUMAH SENDIRI', 2, '335355', 'Bandung Barat', '28', '2', '');
148
149DROP TABLE IF EXISTS `member`;
150CREATE TABLE `member` (
151 `id` int(11) NOT NULL AUTO_INCREMENT,
152 `nama` text NOT NULL,
153 `username` text NOT NULL,
154 `email` text NOT NULL,
155 `alamat` text NOT NULL,
156 `nomor_telepon` text NOT NULL,
157 `nama_bank` text NOT NULL,
158 `nomor_rekening` text NOT NULL,
159 `nama_rekening` text NOT NULL,
160 `upline_level_1` text NOT NULL,
161 `upline_level_2` text NOT NULL,
162 `upline_level_3` text NOT NULL,
163 `upline_level_4` text NOT NULL,
164 `tanggal_join` date NOT NULL,
165 `komisi` decimal(10,0) NOT NULL,
166 `jumlah_transaksi` int(11) NOT NULL,
167 `jumlah_barang` int(11) NOT NULL,
168 `lisensi` text NOT NULL COMMENT 'CALON MEMBER, BASIC, AGEN, STOKIS',
169 PRIMARY KEY (`id`)
170) ENGINE=InnoDB DEFAULT CHARSET=latin1;
171
172INSERT INTO `member` (`id`, `nama`, `username`, `email`, `alamat`, `nomor_telepon`, `nama_bank`, `nomor_rekening`, `nama_rekening`, `upline_level_1`, `upline_level_2`, `upline_level_3`, `upline_level_4`, `tanggal_join`, `komisi`, `jumlah_transaksi`, `jumlah_barang`, `lisensi`) VALUES
173(2, 'Dzakir Harist Abdullah', 'dzakir3628', 'dzakirharista@gmail.com', 'Jl Junaedi no 6 Kota Bandung', '081223744803', 'BCA Syariah', '0350042248', 'Dzakir', '0', '0', '0', '0', '2019-03-14', 5000, 0, 0, 'BASIC'),
174(3, 'Ananda Mahdar', 'ananda2376', 'anandamahdar@gmail.com', 'Jl Cibodas No.1', '081223744803', 'Bank RIBA', '0213219312', '', '2', '0', '0', '0', '2019-03-18', 70000, 0, 0, 'AGEN'),
175(4, 'Andy ABa', 'andy2376', 'andy@gmail.com', 'Surapati Core', '081223744803', 'Bank RIBA', '0213219312', 'Andy', '3', '2', '0', '0', '2019-03-18', 70000, 0, 0, 'AGEN'),
176(5, 'Julius', 'julius2376', 'julius@gmail.com', 'Setia Budi', '081223744803', 'Bank RIBA', '0213219312', 'Julius', '4', '3', '2', '0', '2019-03-18', 75000, 0, 0, 'AGEN'),
177(6, 'Syifa', 'syifa2376', 'syifa@gmail.com', 'Dago', '081223744803', 'Bank RIBA', '0213219312', 'Syifa', '5', '4', '3', '2', '2019-03-18', 230000, 0, 0, 'AGEN'),
178(8, 'Dini Yuliani', 'dini2376', 'dini@gmail.com', '', '0826966779', '', '', '', '6', '5', '4', '3', '2019-08-31', 0, 0, 0, 'BASIC'),
179(9, 'rahmat', 'rahmat2535', 'rahmat.ecoracing@gmail.com', 'q', 'q', 'q', 'q', 'q', '3', '2', '0', '0', '2019-09-11', 0, 0, 0, 'BASIC'),
180(10, 'Jakir Kentud', 'kentud72', 'kentud@gmail.com', '', '', '', '', '', '3', '2', '0', '0', '2019-09-14', 0, 0, 0, 'BASIC');
181
182DROP TABLE IF EXISTS `news`;
183CREATE TABLE `news` (
184 `id` int(11) NOT NULL AUTO_INCREMENT,
185 `judul` text NOT NULL,
186 `source_video` text NOT NULL,
187 `isi_content` longtext NOT NULL,
188 `kategori` text NOT NULL,
189 `tanggal` date NOT NULL,
190 `jam` text NOT NULL,
191 `status` text NOT NULL,
192 PRIMARY KEY (`id`)
193) ENGINE=InnoDB DEFAULT CHARSET=latin1;
194
195INSERT INTO `news` (`id`, `judul`, `source_video`, `isi_content`, `kategori`, `tanggal`, `jam`, `status`) VALUES
196(3, 'Dashboard Content', 'https://d2zihajmogu5jn.cloudfront.net/elephantsdream/ed_hd.mp4', 'PGRpdiBjbGFzcz0icWwtZWRpdG9yIiBkYXRhLWdyYW1tPSJmYWxzZSIgY29udGVudGVkaXRhYmxlPSJ0cnVlIiBkYXRhLXBsYWNlaG9sZGVyPSJDb21wb3NlIGFuIGVwaWMuLi4iPjxoNT5QZW1iYWdpYW4gVW1yb2ggTW90b3IgTGFwdG9wIEhQIHwgUmVrb3IgQm9udXMgVGVyYmVzYXIgfCBQZW1haGFtYW4g', 'DASHBOARD', '2019-09-08', '16:29:28', 'AKTIF'),
197(4, 'Trafic ', 'https://youtu.be/hxmRle2prh8', 'PGRpdiBjbGFzcz0icWwtZWRpdG9yIHFsLWJsYW5rIiBkYXRhLWdyYW1tPSJmYWxzZSIgY29udGVudGVkaXRhYmxlPSJ0cnVlIiBkYXRhLXBsYWNlaG9sZGVyPSJDb21wb3NlIGFuIGVwaWMuLi4iPjxwPjxicj48L3A+PC9kaXY+PGRpdiBjbGFzcz0icWwtY2xpcGJvYXJkIiBjb250ZW50ZWRpdGFibGU9InRydWUiIHRhYmluZGV4PSItMSI+PC9kaXY+PGRpdiBjbGFzcz0icWwtdG9vbHRpcCBxbC1oaWRkZW4iPjxhIGNsYXNzPSJxbC1wcmV2aWV3IiB0YXJnZXQ9Il9ibGFuayIgaHJlZj0iYWJvdXQ6YmxhbmsiPjwvYT48aW5wdXQgdHlwZT0idGV4dCIgZGF0YS1mb3JtdWxhPSJlPW1jXjIiIGRhdGEtbGluaz0iaHR0cHM6Ly9xdWlsbGpzLmNvbSIgZGF0YS12aWRlbz0iRW1iZWQgVVJMIj48YSBjbGFzcz0icWwtYWN0aW9uIj48L2E+PGEgY2xhc3M9InFsLXJlbW92ZSI+PC9hPjwvZGl2Pg==', 'TRAFIC / LEADS', '2019-09-08', '16:32:18', 'AKTIF'),
198(5, 'Funnel', 'https://www.youtube.com/watch?v=AyTNwlWHsZU&feature=youtu.be', 'PGRpdiBjbGFzcz0icWwtZWRpdG9yIiBkYXRhLWdyYW1tPSJmYWxzZSIgY29udGVudGVkaXRhYmxlPSJ0cnVlIiBkYXRhLXBsYWNlaG9sZGVyPSJDb21wb3NlIGFuIGVwaWMuLi4iPjxwPkJhZ2FpbWFuYSBDYXJhIE1lbmdndW5ha2FuIA==', 'FUNNEL', '2019-09-08', '17:06:58', 'AKTIF'),
199(6, 'Copy Writing', 'https://www.youtube.com/watch?v=AyTNwlWHsZU&feature=youtu.be', 'PGRpdiBjbGFzcz0icWwtZWRpdG9yIiBkYXRhLWdyYW1tPSJmYWxzZSIgY29udGVudGVkaXRhYmxlPSJ0cnVlIiBkYXRhLXBsYWNlaG9sZGVyPSJDb21wb3NlIGFuIGVwaWMuLi4iPjxwPlBhc3Rpa2FuIEFuZGEgbWVub250b24gdmlkZW8gZGkgYXRhcyBkZW5nYW4gbGVuZ2thcCwgYWdhciBBbmRhIHRhdSA=', 'COPYWRITING', '2019-09-08', '17:09:09', 'AKTIF');
200
201DROP TABLE IF EXISTS `omset`;
202CREATE TABLE `omset` (
203 `id` int(11) NOT NULL AUTO_INCREMENT,
204 `tahun` char(4) NOT NULL,
205 `bulan` char(2) NOT NULL,
206 `id_member` int(11) NOT NULL,
207 `jenis_omset` text NOT NULL,
208 `total` decimal(10,0) NOT NULL,
209 PRIMARY KEY (`id`),
210 KEY `id_member` (`id_member`),
211 CONSTRAINT `omset_ibfk_1` FOREIGN KEY (`id_member`) REFERENCES `member` (`id`)
212) ENGINE=InnoDB DEFAULT CHARSET=latin1;
213
214
215DROP TABLE IF EXISTS `pembayaran_komisi`;
216CREATE TABLE `pembayaran_komisi` (
217 `id` int(11) NOT NULL AUTO_INCREMENT,
218 `id_member` int(11) NOT NULL,
219 `tanggal` date NOT NULL,
220 `jumlah` decimal(10,0) NOT NULL,
221 `bukti_transfer` text NOT NULL,
222 PRIMARY KEY (`id`),
223 KEY `id_member` (`id_member`),
224 CONSTRAINT `pembayaran_komisi_ibfk_1` FOREIGN KEY (`id_member`) REFERENCES `member` (`id`)
225) ENGINE=InnoDB DEFAULT CHARSET=latin1;
226
227INSERT INTO `pembayaran_komisi` (`id`, `id_member`, `tanggal`, `jumlah`, `bukti_transfer`) VALUES
228(2, 2, '2019-03-28', 5000, '');
229
230DROP TABLE IF EXISTS `produk`;
231CREATE TABLE `produk` (
232 `id` int(11) NOT NULL AUTO_INCREMENT,
233 `nama_produk` text NOT NULL,
234 `harga` decimal(10,0) NOT NULL,
235 `harga_member` decimal(10,0) NOT NULL,
236 `deskripsi` longtext NOT NULL,
237 `promo` longtext NOT NULL,
238 `komisi` text NOT NULL,
239 `media` longtext NOT NULL,
240 `berat` int(11) NOT NULL,
241 `kategori` text NOT NULL,
242 `diskon` text NOT NULL,
243 `nama_diskon` text NOT NULL,
244 `cashback` text NOT NULL COMMENT 'isi json / lisensi',
245 `create_date` text NOT NULL COMMENT 'dd:mm:yyyy hh:ii:ss',
246 `create_by` text NOT NULL COMMENT 'user id',
247 `last_update` text NOT NULL COMMENT 'dd:mm:yyyy hh:ii:ss',
248 `status` text NOT NULL,
249 PRIMARY KEY (`id`)
250) ENGINE=InnoDB DEFAULT CHARSET=latin1;
251
252INSERT INTO `produk` (`id`, `nama_produk`, `harga`, `harga_member`, `deskripsi`, `promo`, `komisi`, `media`, `berat`, `kategori`, `diskon`, `nama_diskon`, `cashback`, `create_date`, `create_by`, `last_update`, `status`) VALUES
253(2, 'Red Nutrisio', 60000, 40000, 'TWFuZmFhdCBOZW8gQnJhaW4gdW50dWsgQW5hayA6Ck1lbmluZ2thdGthbiBEYXlhIEluZ2F0LCBEYXlhIEtvbnNlbnRyYXNpLCBkYW4gS2VjZXJkYXNhbi4KTWVuaW5na2F0a2FuIEltdW5pdGFzCk1lbmlna2F0a2FuIE1vb2QKTWVuY2VnYWggU3RlcCAoQ29udnVsc2lvbikKTWVyaW5nYW5rYW4gRXBpbGVwc2kKTWVyaW5nYW5rYW4gRGlhcmUsIFRoeXB1cywgREJEIChEZW1hbSBCZXJkYXJhaCkKTWVyaW5nYW5rYW4gQXV0aXMsIEFESEQgKEF0dGVudGlvbiBEZWZpc2l0IEh5cGhlcmFjdGl2aXR5IERpc29yZGVyKSwgZGxsCk1hbmZhYXQgTmVvIEJyYWluIHVudHVrIFJlbWFqYS9EZXdhc2EgOgpNZW5jZWdhaCBIaXBlcnRlbnNpLCBTdHJva2UsIEphbnR1bmcgS29yb25lciwgQWx6YWVtZXIsIERlcHJlc2ksIFN0cmVzcwpNZXJpbmdhbmthbiBFcGlsZXBzaSwgS2VqYW5nLUtlamFuZywgVmVydGlnbywgZGFuIE1pZ3JhaW4KTWVuaW5na2F0a2FuIERheWEgS29uc2VudHJhc2ksIFJlbGFrc2FzaSwgZGFuIGxhaW4gc2ViYWdhaW55YQpNZW5jZWdhaCBLZXBpa3VuYW4gRGluaQpNZW1iYW50dSBNZW5nZW5kYWxpa2FuIFBzb3JpYXNpcwpNZW11bGloa2FuIEluZ2F0YW4sIGRsbA==', '', '[\"5000\",\"4000\",\"3000\",\"2000\"]', '[{\"sourceMedia\":\"https://s4.bukalapak.com/img/4924111638/w-1000/data.png\",\"type\":\"GAMBAR\"},{\"sourceMedia\":\"https://2.bp.blogspot.com/-ETKvk7l4Oh0/XNpope_9ZZI/AAAAAAAABpw/lfp9ZU2L65sFF6NrziRRoUByx6VmmHu5QCLcBGAs/s1600/P_20190513_093622%255B1%255D.jpg\",\"type\":\"GAMBAR\"},\r\n{\"sourceMedia\":\"https://nutrisio.net/wp-content/uploads/2019/01/IMG_20190106_103405.jpg\",\"type\":\"GAMBAR\"}]\r\n\r\n\r\n', 250, '1', '0', '', '', '', '', '', 'AKTIF'),
254(3, 'Green Nutrisio', 350000, 250000, 'TWFuZmFhdCBOZW8gQnJhaW4gdW50dWsgQW5hayA6IE1lbmluZ2thdGthbiBEYXlhIEluZ2F0LCBEYXlhIEtvbnNlbnRyYXNpLCBkYW4gS2VjZXJkYXNhbi4gTWVuaW5na2F0a2FuIEltdW5pdGFzIE1lbmlna2F0a2FuIE1vb2QgTWVuY2VnYWggU3RlcCAoQ29udnVsc2lvbikgTWVyaW5nYW5rYW4gRXBpbGVwc2kgTWVyaW5nYW5rYW4gRGlhcmUsIFRoeXB1cywgREJEIChEZW1hbSBCZXJkYXJhaCkgTWVyaW5nYW5rYW4gQXV0aXMsIEFESEQgKEF0dGVudGlvbiBEZWZpc2l0IEh5cGhlcmFjdGl2aXR5IERpc29yZGVyKSwgZGxsIE1hbmZhYXQgTmVvIEJyYWluIHVudHVrIFJlbWFqYS9EZXdhc2EgOiBNZW5jZWdhaCBIaXBlcnRlbnNpLCBTdHJva2UsIEphbnR1bmcgS29yb25lciwgQWx6YWVtZXIsIERlcHJlc2ksIFN0cmVzcyBNZXJpbmdhbmthbiBFcGlsZXBzaSwgS2VqYW5nLUtlamFuZywgVmVydGlnbywgZGFuIE1pZ3JhaW4gTWVuaW5na2F0a2FuIERheWEgS29uc2VudHJhc2ksIFJlbGFrc2FzaSwgZGFuIGxhaW4gc2ViYWdhaW55YSBNZW5jZWdhaCBLZXBpa3VuYW4gRGluaSBNZW1iYW50dSBNZW5nZW5kYWxpa2FuIFBzb3JpYXNpcyBNZW11bGloa2FuIEluZ2F0YW4sIGRsbA', '', '[\"20000\",\"15000\",\"10000\",null]', '[{\"sourceMedia\":\"http://akademibisnis.id/videoplayback.mp4\",\"type\":\"VIDEO\"},{\"sourceMedia\":\"https://nutrisio.co.id/frontend/images/products/green_nutrio_leaf.png\",\"type\":\"GAMBAR\"},{\"sourceMedia\":\"https://s1.bukalapak.com/img/68803188611/original/65293372_344829332873666_1764031088835749626_n.jpg\",\"type\":\"GAMBAR\"}]', 200, '1', '0', '-', '', '', '', '', 'AKTIF');
255
256DROP TABLE IF EXISTS `ref_kategori`;
257CREATE TABLE `ref_kategori` (
258 `id` int(11) NOT NULL AUTO_INCREMENT,
259 `nama_kategori` text NOT NULL,
260 `gambar` text NOT NULL,
261 PRIMARY KEY (`id`)
262) ENGINE=InnoDB DEFAULT CHARSET=latin1;
263
264INSERT INTO `ref_kategori` (`id`, `nama_kategori`, `gambar`) VALUES
265(1, 'NUTRISIO', 'https://lh3.googleusercontent.com/Tw9lRs1v4AlucRHK0-ZJb7Hdy7iTqa_E9I5kF8tUGWSxN5EAAorxMT5LUY2yYYPUOtM0f-oK=w1080-h608-p-no-v0'),
266(2, 'SINERGY', 'https://s3-ap-southeast-1.amazonaws.com/prelo/images/resized/512x512/products/5cef6361259af40823a8edb8/essenzo-essential-oil-clove-bud-ea0597d1ec9d-7663lN-2-1559192417748.jpg'),
267(3, 'MERCHANDISE', 'https://www.deherba.com/wp-content/uploads/2015/08/5d6b6306cfec933ce38306cd828210d5.jpg'),
268(4, 'EVENT', 'https://cdn1-production-images-kly.akamaized.net/wAY_FJ3RPRZcTZQkBNyUCPNY4fE=/680x383/smart/filters:quality(75):strip_icc():format(jpeg)/kly-media-production/medias/2570058/original/076603100_1546466009-beberapa-herbal-terbaik-untuk-menyeimbangkan-hormon-anda.jpg');
269
270DROP TABLE IF EXISTS `rekap_transaksi`;
271CREATE TABLE `rekap_transaksi` (
272 `id` int(11) NOT NULL AUTO_INCREMENT,
273 `id_member` int(11) NOT NULL,
274 `komisi` decimal(10,0) NOT NULL,
275 `jumlah_penjualan` int(11) NOT NULL,
276 `jumlah_barang` int(11) NOT NULL,
277 `periode` text NOT NULL,
278 PRIMARY KEY (`id`)
279) ENGINE=InnoDB DEFAULT CHARSET=latin1;
280
281INSERT INTO `rekap_transaksi` (`id`, `id_member`, `komisi`, `jumlah_penjualan`, `jumlah_barang`, `periode`) VALUES
282(1, 16, 100000, 2, 9, '2019-04');
283
284DROP TABLE IF EXISTS `setting`;
285CREATE TABLE `setting` (
286 `id` int(11) NOT NULL AUTO_INCREMENT,
287 `nama` text NOT NULL,
288 `isi` text NOT NULL,
289 PRIMARY KEY (`id`)
290) ENGINE=InnoDB DEFAULT CHARSET=latin1;
291
292INSERT INTO `setting` (`id`, `nama`, `isi`) VALUES
293(1, 'URL_GAMBAR', 'https://admin.nutrisio.rm-rf.studio/'),
294(2, 'KOMISI PENDAFTARAN', '100000'),
295(3, 'KOMISI UPGRADE', '20;15;10'),
296(4, 'LISENSI AGEN', '2500000'),
297(5, 'LISENSI STOKIS', '5000000');
298
299DROP TABLE IF EXISTS `temp_media_produk`;
300CREATE TABLE `temp_media_produk` (
301 `id` int(11) NOT NULL AUTO_INCREMENT,
302 `username` text NOT NULL,
303 `media` longtext NOT NULL,
304 `id_produk` int(11) NOT NULL,
305 `type` text NOT NULL,
306 PRIMARY KEY (`id`)
307) ENGINE=InnoDB DEFAULT CHARSET=latin1;
308
309INSERT INTO `temp_media_produk` (`id`, `username`, `media`, `id_produk`, `type`) VALUES
310(49, 'kszxpo', 'http://akademibisnis.id/videoplayback.mp4', 0, 'VIDEO'),
311(50, 'kszxpo', 'https://nutrisio.co.id/frontend/images/products/green_nutrio_leaf.png', 0, 'GAMBAR'),
312(51, 'kszxpo', 'https://s1.bukalapak.com/img/68803188611/original/65293372_344829332873666_1764031088835749626_n.jpg', 0, 'GAMBAR');
313
314DROP TABLE IF EXISTS `trafic`;
315CREATE TABLE `trafic` (
316 `id` int(11) NOT NULL AUTO_INCREMENT,
317 `id_member` int(11) NOT NULL,
318 `unique_id` longtext NOT NULL,
319 `id_funnel` text NOT NULL,
320 `tanggal` date NOT NULL,
321 `jam` text NOT NULL,
322 `ip_address` text NOT NULL,
323 `lokasi` text NOT NULL,
324 `user_agent` text NOT NULL,
325 `pixel` text NOT NULL,
326 PRIMARY KEY (`id`),
327 KEY `id_member` (`id_member`)
328) ENGINE=InnoDB DEFAULT CHARSET=latin1;
329
330INSERT INTO `trafic` (`id`, `id_member`, `unique_id`, `id_funnel`, `tanggal`, `jam`, `ip_address`, `lokasi`, `user_agent`, `pixel`) VALUES
331(1, 6, 'GA1.2.1762263390.1552573313', '1', '2019-03-14', '07:00', '123.231.253.230', 'Bandung', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.157 Safari/537.36', 'FACEBOOK'),
332(2, 2, 'r0bejk4a593c177r8euhgr9u96e0dln6', '1', '2019-09-06', '12:18:47', '192.168.7.93', 'UNKNOWN', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'Facebook'),
333(5, 2, '051k506ql1g0o4djjj82017tgq9bhhp5', '1', '2019-09-08', '08:12:20', '103.78.218.150', 'UNKNOWN', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:65.0) Gecko/20100101 Firefox/65.0', 'Posster'),
334(7, 2, '8hfuoo9aemi091pg72jnjdi8jejbgjs8', '1', '2019-09-08', '08:15:50', '140.213.52.121', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'udin'),
335(8, 2, 'fjddoivrt2781g5s6874tr703c1o5st4', '2', '2019-09-08', '08:17:50', '103.78.218.150', 'UNKNOWN', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'PIXEL'),
336(9, 2, 'fjcbp9nl5u5qkhbcrcgcmu2tc90bgods', '1', '2019-09-08', '22:42:40', '103.78.218.150', 'UNKNOWN', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:65.0) Gecko/20100101 Firefox/65.0', 'TestFireFox'),
337(10, 2, 'a0v1rqifa22ddufikojri60vtvdv9ivo', '1', '2019-09-09', '17:28:34', '192.168.7.75', 'UNKNOWN', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36', 'Boniw'),
338(11, 2, '98nhoodknafvq4rl2etogffvo7am5dhj', '1', '2019-09-09', '17:28:49', '192.168.7.75', 'UNKNOWN', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36', 'Boniw'),
339(12, 3, 'blc96ufnk4q5b4me60r6kq8eb4316u61', '1', '2019-09-11', '21:33:42', '36.71.234.224', 'UNKNOWN', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'FaceBook'),
340(13, 3, '8hfuoo9aemi091pg72jnjdi8jejbgjs8', '1', '2019-09-11', '21:40:15', '140.213.26.48', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'IG'),
341(14, 3, 'qg7ekaj9sgkuk510vlmfm9erfab25oa6', '1', '2019-09-11', '21:45:53', '140.213.26.48', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'IG90'),
342(15, 3, 'ha4v0eea0pc1i3c2nea58h3ld19l8iv1', '1', '2019-09-11', '21:46:59', '140.213.26.48', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'IG69'),
343(16, 3, 'lsthotcj75qqmtib1ro694a5jbue8os6', '1', '2019-09-11', '21:50:05', '140.213.26.48', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'IG98'),
344(17, 2, '4tupi5qlct4shheeun3gobevmg48k1c8', '1', '2019-09-11', '21:56:14', '140.213.26.48', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'PIXEL'),
345(18, 3, '4tupi5qlct4shheeun3gobevmg48k1c8', '1', '2019-09-11', '21:57:06', '140.213.26.48', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'PIXEL'),
346(19, 3, 'r0bejk4a593c177r8euhgr9u96e0dln6', '1', '2019-09-11', '22:03:23', '36.71.234.224', 'UNKNOWN', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'PIXEL'),
347(20, 3, '1r3ttphdlpqou0g7iqrql08fs9b5obaf', '1', '2019-09-11', '22:34:10', '36.71.232.136', 'UNKNOWN', 'Mozilla/5.0 (Linux; Android 7.1.2; Redmi 4A Build/N2G47H) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.158 Mobile Safari/537.36', 'PIXEL'),
348(28, 3, '', '1', '2019-09-14', '16:42:26', '103.78.219.225', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'makan'),
349(29, 3, '', '1', '2019-09-14', '16:52:03', '103.78.219.225', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'makan'),
350(30, 3, '', '1', '2019-09-14', '17:00:28', '103.78.219.225', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'makan'),
351(31, 3, '', '1', '2019-09-14', '17:05:09', '103.78.219.225', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'makan'),
352(32, 3, '', '1', '2019-09-14', '17:05:24', '103.78.219.225', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'makan'),
353(33, 3, '', '1', '2019-09-14', '17:08:21', '103.78.219.225', 'UNKNOWN', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36', 'makan');
354
355DROP TABLE IF EXISTS `training`;
356CREATE TABLE `training` (
357 `id` int(11) NOT NULL AUTO_INCREMENT,
358 `judul_materi` text NOT NULL,
359 `deskripsi_materi` longtext NOT NULL,
360 `video_souce` text NOT NULL,
361 `thumbnail` text NOT NULL,
362 `kategori` text NOT NULL,
363 `wajib_tonton` text NOT NULL,
364 `urutan` int(11) NOT NULL,
365 `tanggal_update` date NOT NULL,
366 `jam_update` text NOT NULL,
367 `status` text NOT NULL,
368 `durasi_video` text NOT NULL,
369 PRIMARY KEY (`id`)
370) ENGINE=InnoDB DEFAULT CHARSET=latin1;
371
372INSERT INTO `training` (`id`, `judul_materi`, `deskripsi_materi`, `video_souce`, `thumbnail`, `kategori`, `wajib_tonton`, `urutan`, `tanggal_update`, `jam_update`, `status`, `durasi_video`) VALUES
373(1, 'Pengenalan Surya duta', 'QmFnYWltYW5hIENhcmEgTWVtYmFuZ3VuIEJpc25pcyBEaWdpdGFsIERlbmdhbiBUZXBhdCBTZWhpbmdnYSBTZWdlcmEgUHJvZml0LCBXYWxhdXB1biBHYXB0ZWsgLyBCZWx1bSBQdW55YSBQZW5nYWxhbWFuPwooQUJEaSBha2FuIG1lbWJlcmlrYW4gU0VNVUEgeWFuZyBBbmRhIGJ1dHVoa2FuIHVudHVrIGJpc2EgbWVuZ2hhc2lsa2FuIGRhcmkgZHVuaWEgZGlnaXRhbCBzZWphayBCVUxBTiBQRVJUQU1BKQoKbWVuZ3Vhc2FpIGRpZ2l0YWwgbWFya2V0aW5nIGl0dSBwZW50aW5nIA==', 'http://iandevlin.github.io/mdn/video-player/video/tears-of-steel-battle-clip-medium.mp4', 'https://sproutingphotographer.com/wp-content/uploads/2018/02/Business-of-Photography-Hero-Image-0113.jpg', 'MATERI TRAINING', 'WAJIB', 1, '2019-08-20', '00:00', 'AKTIF', '00:01:10'),
374(2, 'Bagi Hasil Surya Duta', 'PGRpdiBjbGFzcz0iY29sLW1kLTEyIj48cD48aDU+TGF1bmNoaW5nIFByb2R1ayBCYXJ1IEFCRGkgKyBIYWRpYWggVG90YWwgNTAgSnV0YSBSdXBpYWghISE8L2g1PjxoNT48YnI+PC9oNT48aDU+QWtoaXJueWEgeWFuZyBkaXR1bmdndS10dW5nZ3UgZGF0YW5nIGp1Z2EsIFByb2R1ayBCYXJ1IGRhcmkgQUJEaSB5YW5nIGZva3VzIGJlcnR1anVhbiB1bnR1ayBtZW1iYW50dSBBbmRhIGhpZHVwIGxlYmloIHNlaGF0ICZhbXA7IG1lbXBlcmJlc2FyIHBlbmdoYXNpbGFuIEFuZGEuIEFhbWlpbiA6KTxicj48YnI+QUJEaSBzZWRhbmcgc2FuZ2F0IGZva3VzIGtlIGluZHVzdHJpIGluaSBrYXJlbmEgc2VsYWluIGluZHVzdHJpbnlhIHlhbmcgc2FuZ2F0IGJlc2FyIChUL3RhaHVuKSwgdGVybnlhdGEga2VzZW1wYXRhbiB1bnR1ayBtZW5qYWRpIGJhZ2lhbiBiZXNhciBpbmR1c3RyaSBpbmkgVEVSQlVLQSBTQU5HQVQgTEVCQVIgYXNhbCB0YXUgdHJpayAmYW1wOyBzdHJhdGVnaW55YS4gRGFuIGJlcnVudHVuZ255YSwgc2VtdWEgeWFuZyBBQkRpIGxha3VrYW4gc2VsYW1hIGluaSwgbWVuZ2FyYWgga2UgaGFsIHlhbmcgdGVwYXQgdW50dWsgYmlzYSBtZW5qYWRpIGJhZ2lhbiBiZXNhciBkaSBpbmR1c3RyaSBpbmkuJm5ic3A7PC9oNT48aDU+U2FuZ2F0IGFtYXQgc2F5YW5nIHNla2FsaSBiaWxhIEFuZGEgdGlkYWsgaWt1dCBtZW5nYW1iaWwgYmFnaWFuIGRhcmkga2V1bnR1bmdhbiBiZXNhciBpbmkuPC9oNT48aDU+VGFucGEgYmFueWFrIGJhc2EtYmFzaSBsYWdpLCBzZWdlcmEgdG9udG9uIERFTkdBTiBMRU5HS0FQIGRhcmkgYXdhbCBzYW1wYWkgYWtoaXIgeWFhLCBqYWRpbGFoIG9yYW5nIGF3YWwgeWFuZyB0YXUgaWxtdW55YSwgdGF1IHByb21vbnlhICZhbXA7IG1lbWFuZmF0a2FuIHNlbXVhIGtldW50dW5nYW5ueWEuPC9oNT48aDU+PGJyPjxicj4qbW9ob24gZGlwYWhhbWksIHNhYXQgbGF1bmNoaW5nIHByb2R1ayB5YW5nIGR1bHUtZHVsdSwga2FtaSBtZWxha3VrYW4gUmUtU3RvY2sgc2FhdCBzdWRhaCBoYWJpcy4gTmFtdW4ga2FsaSBpbmkga2FtaSBha2FuIGJ1YXQgdGVyYmF0YXMgZGFuIHRpZGFrIGFrYW4gZGkgUmUtU3RvY2sgYmlsYSBzdWRhaCBoYWJpcy48YnI+PGJyPjwvaDU+PHA+PHN0cm9uZz5TaWxhaGthbiB0YW55YSBrZXBhZGEgYWRtaW4gYmlsYSBhZGEgeWFuZyBiZWx1bSBqZWxhcyA6IDA4MTIxOTk4Njg3NiAoVGVsZWdyYW0pPC9zdHJvbmc+PC9wPjxwPjxzdHJvbmc+RGFuIGphbmdhbiBsdXBhIHVudHVrIG1hc3VrIGtlIENoYW5uZWwgVGVsZWdyYW0gUmVzbWkgQUJEaSAmYW1wOyBDaGFubmVsIFRlbGVncmFtIEJhbmsgRGF0YSBBQkRpLiAoVG9tYm9sIHVudHVrIGxhbmdzdW5nIGJlcmdhYnVuZyBrZSBDaGFubmVsIFRlbGVncmFtIEFCRGkgYWRhIGRpIGF0YXMgdHVsaXNhbiBpbmksIHNpbGFoa2FuIGtsaWspPC9zdHJvbmc+PC9wPjxwPjxicj48L3A+PHA+PHN0cm9uZz5UZXJpbWEga2FzaWggOik8L3N0cm9uZz48L3A+PC9wPjwvZGl2Pg==', 'http://iandevlin.github.io/mdn/video-player/video/tears-of-steel-battle-clip-medium.mp4', 'http://sdlawtimmins.com/wp-content/uploads/2017/10/business-purchase-img.jpg', 'TRAINING', 'WAJIB', 2, '2019-08-28', '10:45:39', 'AKTIF', '00:01:10');
375
376DROP TABLE IF EXISTS `transaksi`;
377CREATE TABLE `transaksi` (
378 `id` int(11) NOT NULL AUTO_INCREMENT,
379 `id_member` int(11) NOT NULL,
380 `nama_pembeli` text NOT NULL,
381 `email_pembeli` text NOT NULL,
382 `nomor_telepon` text NOT NULL,
383 `alamat_pengiriman` text NOT NULL,
384 `kecamatan_pengiriman` text NOT NULL,
385 `kota_pengiriman` text NOT NULL,
386 `provinsi_pengiriman` text NOT NULL,
387 `kode_pos_pengiriman` text NOT NULL,
388 `tanggal` date NOT NULL,
389 `sub_total` decimal(10,0) NOT NULL,
390 `ongkir` decimal(10,0) NOT NULL,
391 `total` decimal(10,0) NOT NULL,
392 `diskon` decimal(10,0) NOT NULL,
393 `cashback` decimal(10,0) NOT NULL,
394 `status` text NOT NULL,
395 `id_trafic` int(11) NOT NULL,
396 `service_pengiriman` text NOT NULL,
397 `nomor_resi` text NOT NULL,
398 `keterangan` text NOT NULL,
399 `jenis_transaksi` text NOT NULL,
400 `kode_unik` varchar(11) NOT NULL,
401 `update_time` datetime NOT NULL,
402 `url_funnel` text NOT NULL,
403 PRIMARY KEY (`id`)
404) ENGINE=InnoDB DEFAULT CHARSET=latin1;
405
406INSERT INTO `transaksi` (`id`, `id_member`, `nama_pembeli`, `email_pembeli`, `nomor_telepon`, `alamat_pengiriman`, `kecamatan_pengiriman`, `kota_pengiriman`, `provinsi_pengiriman`, `kode_pos_pengiriman`, `tanggal`, `sub_total`, `ongkir`, `total`, `diskon`, `cashback`, `status`, `id_trafic`, `service_pengiriman`, `nomor_resi`, `keterangan`, `jenis_transaksi`, `kode_unik`, `update_time`, `url_funnel`) VALUES
407(4, 6, '2', 'nunu@gmail.com', '0812645786', 'Jl. Ir. H. Juanda No.348, Dago', 'Coblong', 'Kota Bandung', 'Jawa Barat ', '40135', '2019-09-02', 40000, 11000, 51235, 0, 0, 'TERKONFIRMASI', 0, 'JNE OKE', '', '', 'PENJUALAN', '235', '2019-08-31 04:19:54', ''),
408(5, 6, 'Dini Yuliani', 'dini@gmail.com', '0826966779', '-', '-', '-', '-', '-', '2019-09-02', 0, 0, 500123, 0, 0, 'TERKONFIRMASI', 1, '-', '', '', 'PENDAFTARAN MEMBER (BASIC)', '123', '2019-08-31 03:37:56', ''),
409(6, 5, 'Julius', 'julius@gmail.com', '', '', '', '', '', '', '2019-09-03', 0, 0, 2500005, 0, 0, 'TERKONFIRMASI', 0, '', '', '', 'UPGRADE LISENSI AGEN', '5', '2019-09-03 21:47:13', ''),
410(8, 2, 'asada', 'asada@gmail.com', '', '', '', '', '', '', '2019-09-08', 0, 0, 0, 0, 0, '', 7, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '0', '2019-09-08 22:42:25', ''),
411(9, 2, 'Imam Mutaqien', 'devops@rm-rf.studio', '', '', '', '', '', '', '2019-09-08', 0, 0, 0, 0, 0, '', 9, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '0', '2019-09-08 22:43:32', ''),
412(10, 2, 'ucad', 'ucad@pilar.web.id', '', '', '', '', '', '', '2019-09-09', 0, 0, 0, 0, 0, '', 11, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '0', '2019-09-09 17:29:12', ''),
413(11, 2, 'JAKIR HORAS', 'Jakir@tuyul.online', '089124124124', 'Batu Berbaris', 'Bandung Barat', '17', '1', '0', '2019-09-11', 0, 26000, 0, 0, 0, 'MENUNGGU KONFIRMASI', 0, '0', '', '', 'PENJUALAN', '0', '2019-09-11 15:37:35', ''),
414(12, 2, 'Test a', 'test', '084213123', 'qweqwewqe', 'test', '232', '3', '0', '2019-09-11', 0, 15000, 0, 0, 0, 'MENUNGGU KONFIRMASI', 0, '0', '', '', 'PENJUALAN', '0', '2019-09-11 16:40:00', ''),
415(13, 2, 'Boniw', 'boniw@gmail.com', '0812312321', 'test', 'test', '24', '9', '0', '2019-09-11', 0, 8000, 0, 0, 0, 'MENUNGGU KONFIRMASI', 0, '0', '', '', 'PENJUALAN', '0', '2019-09-11 16:42:33', ''),
416(14, 2, 'Nunu NUNU', 'nunu@gmail.com', '08912838123812', 'Jalan junaedi no 7', '', 'Bandung', 'Jawa Barat', '0', '2019-09-11', 1060000, 10000, 1050000, 0, 0, 'MENUNGGU KONFIRMASI', 0, '1', '', '', 'PENJUALAN', '0', '2019-09-11 16:44:53', ''),
417(44, 2, 'DINDA', 'Dinda@tuyul.online', '089124124124', 'CIBODAS', '', 'Bangli', 'Bali', '0', '2019-09-11', 496000, 26000, 470000, 0, 0, 'TERKONFIRMASI', 0, 'JNE OKE', '', '', 'PENJUALAN', '4', '2019-09-11 21:05:52', ''),
418(45, 3, 'melissa evans', 'melissa.evans@broshegroup.com', '', '', '', '', '', '', '2019-09-11', 0, 0, 0, 0, 0, '', 12, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '0', '2019-09-11 21:50:21', ''),
419(46, 2, '', '', '', '', '', '', '', '', '2019-09-11', 0, 0, 0, 0, 0, '', 2, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '0', '2019-09-11 22:03:52', ''),
420(47, 3, 'Fajar', 'fajar', '0894947474', 'tdtr4f\ntg\ntg', '', 'Bangka Barat', 'Bangka Belitung', '0', '2019-09-11', 392000, 42000, 350000, 0, 0, 'TERKONFIRMASI', 0, '1', '', '', 'PENJUALAN', '4', '2019-09-11 21:13:03', ''),
421(48, 3, 'rahmat', 'rahmat.ecoracing@gmail.com', '', '', '', '', '', '', '2019-09-11', 0, 0, 0, 0, 0, 'TERKONFIRMASI', 20, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '0', '2019-09-11 21:37:40', ''),
422(49, 9, 'rahmat', 'rahmat.ecoracing@gmail.com', '', '', '', '', '', '', '2019-09-11', 0, 0, 48, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'UPGRADE LISENSI STOKIS', '048', '0000-00-00 00:00:00', ''),
423(50, 2, 'TAYO', 'tayo@gmail.com', '089122131', 'jln gunung bohong', 'Bandung Barat', 'Badung', 'Bali', '0', '2019-09-13', 436000, 26000, 410000, 0, 0, 'BELUM BAYAR', 0, '0', '', '', 'PENJUALAN', '004', '2019-09-13 22:22:34', ''),
424(51, 2, 'Lany', 'lany@gmail.com', '08912219242', 'Test', 'Bandung Barat', 'Cilegon', 'Banten', '0', '2019-09-13', 72000, 12000, 60000, 0, 0, 'MENUNGGU KONFIRMASI', 0, 'Ongkos Kirim Ekonomis', '', '', 'PENJUALAN', '050', '2019-09-13 22:59:48', ''),
425(59, 2, '', '', '', '', '', '', '', '', '2019-09-14', 2500000, 0, 2500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'UPGRADE LISENSI AGEN', '051', '2019-09-14 10:47:40', ''),
426(60, 3, '', '', '', '', '', '', '', '', '2019-09-14', 5000000, 0, 5000000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'UPGRADE LISENSI STOKIS', '059', '2019-09-14 12:47:12', ''),
427(67, 3, 'Textlin', 'Testil@gmail.com', '', '', '', '', '', '', '2019-09-14', 500000, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '060', '2019-09-14 17:09:48', 'http://suryaduta.fujindev.online/ground/ananda2376/makan'),
428(70, 0, 'SPX', 'SPX@GMAIL.COM', '', '', '', '', '', '', '2019-09-14', 500000, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '067', '2019-09-14 17:52:49', 'http://suryaduta.fujindev.online'),
429(71, 3, 'Jakir Palkon', 'jakirPalkon@gmail.com', '', '', '', '', '', '', '2019-09-14', 500000, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '059', '2019-09-14 20:39:06', 'http://suryaduta.fujindev.online/direct/ananda2376/Direct'),
430(72, 3, 'Jakir Kentud', 'kentud@gmail.com', '', '', '', '', '', '', '2019-09-14', 500000, 0, 500000, 0, 0, 'TERKONFIRMASI', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '059', '2019-09-14 22:18:14', 'http://suryaduta.fujindev.online/direct/ananda2376/Direct'),
431(73, 2, 'test uddim', 'test@udin.com', '', '', '', '', '', '', '2019-09-19', 500000, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '059', '2019-09-19 05:11:38', 'http://suryaduta.fujindev.online/direct/dzakir3628/Direct'),
432(74, 2, 'test', 'ttest', 'test', 'test', 'test', 'Buleleng', 'Bali', '0', '2019-09-21', 1432000, 32000, 1400000, 0, 0, 'BELUM BAYAR', 0, 'Ongkos Kirim Ekonomis', '', '', 'PENJUALAN', '073', '2019-09-21 22:11:49', ''),
433(75, 2, 'wetadaz', 'wetadaz@getnada.com', '', '', '', '', '', '', '2019-10-01', 500074, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '074', '2019-10-01 22:10:35', 'https://akademibisnis.id/direct/dzakir3628/Direct'),
434(76, 2, 'Taufan', 'taufantritama69@gmail.com', '', '', '', '', '', '', '2019-10-02', 500075, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '075', '2019-10-02 22:41:35', 'https://akademibisnis.id/direct/dzakir3628/Direct'),
435(77, 2, 'Taufan', 'taufantritama69@gmail.com', '', '', '', '', '', '', '2019-10-02', 500076, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '076', '2019-10-02 23:50:39', 'https://akademibisnis.id/direct/dzakir3628/Direct'),
436(78, 2, 'Taufan', 'taufantritama69@gmail.com', '', '', '', '', '', '', '2019-10-02', 500076, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '076', '2019-10-02 23:51:49', 'https://akademibisnis.id/direct/dzakir3628/Direct'),
437(79, 2, 'taufan', 'taufantritama69@gmail.com', '', '', '', '', '', '', '2019-10-02', 500076, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '076', '2019-10-02 23:53:42', 'https://akademibisnis.id/direct/dzakir3628/Direct'),
438(80, 2, 'taufan', 'taufantritama69@gmail.com', '', '', '', '', '', '', '2019-10-02', 500076, 0, 500000, 0, 0, 'BELUM BAYAR', 0, '', '', '', 'PENDAFTARAN MEMBER (BASIC)', '076', '2019-10-02 23:54:17', 'https://akademibisnis.id/direct/dzakir3628/Direct');
439
440DROP TABLE IF EXISTS `users`;
441CREATE TABLE `users` (
442 `id` int(11) NOT NULL AUTO_INCREMENT,
443 `id_member` int(11) NOT NULL,
444 `email` text NOT NULL,
445 `password` text NOT NULL,
446 `status` text NOT NULL,
447 `hak_akses` text NOT NULL COMMENT 'MEMBER;PRODUK;BILLING',
448 `create_date` text NOT NULL COMMENT 'dd:mm:yyyy hh:ii:ss',
449 `last_update` text NOT NULL COMMENT 'dd:mm:yyyy hh:ii:ss',
450 `online` int(11) NOT NULL,
451 `sesino` text NOT NULL,
452 `lastaktif` text NOT NULL,
453 `ipaddr` text NOT NULL,
454 PRIMARY KEY (`id`),
455 KEY `id_member` (`id_member`)
456) ENGINE=InnoDB DEFAULT CHARSET=latin1;
457
458INSERT INTO `users` (`id`, `id_member`, `email`, `password`, `status`, `hak_akses`, `create_date`, `last_update`, `online`, `sesino`, `lastaktif`, `ipaddr`) VALUES
459(2, 0, 'vulnwalker@pilar.web.id', 'a61d31eebabb9247ff6abdd62c8361aa', 'AKTIF', 'ALL MODUL', '', '', 1, '698298589', '2019-08-21 14:17:33', '103.84.140.49'),
460(3, 0, 'taufantritama69@gmail.com', '202CB962AC59075B964B07152D234B70', 'AKTIF', 'ALL MODUL', '', '', 1, '1016405044', '2019-08-18 20:38:36', '103.23.35.117'),
461(4, 0, 'kszxpo', 'a3bf5a28aef3c4d7d3d3417d7b41f023', 'AKTIF', 'ADMIN', '', '', 1, '417465083', '2019-10-04 22:58:50', '180.253.218.181'),
462(5, 2, 'jakir@test.com', '202cb962ac59075b964b07152d234b70', 'AKTIF', 'ADMIN', '', '', 1, '195565726', '2019-08-28 20:50:50', '103.84.141.102'),
463(6, 3, 'anandamahdar@gmail.com', '202cb962ac59075b964b07152d234b70', 'AKTIF', 'MEMBER', '', '', 1, '195565726', '2019-08-28 20:50:50', '103.84.141.102'),
464(7, 9, 'rahmat.ecoracing@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'AKTIF', 'MEMBER', '', '', 0, '', '', ''),
465(8, 10, 'kentud@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'AKTIF', 'MEMBER', '', '', 0, '', '', ''),
466(9, 0, 'vanheis@pilar.web.id', '4297f44b13955235245b2497399d7a93', 'AKTIF', 'ALL MODUL', '', '', 1, '698298589', '2019-08-21 14:17:33', '103.66.140.49');
467
468DROP VIEW IF EXISTS `view_rekap_komisi`;
469CREATE TABLE `view_rekap_komisi` (`id_member` int(11), `komisi` decimal(32,0), `totalPenjualan` bigint(21), `tanggal` date);
470
471
472DROP VIEW IF EXISTS `view_rekap_komisi_backup`;
473CREATE TABLE `view_rekap_komisi_backup` ();
474
475
476DROP TABLE IF EXISTS `watched_training`;
477CREATE TABLE `watched_training` (
478 `id` int(11) NOT NULL AUTO_INCREMENT,
479 `id_member` int(11) NOT NULL,
480 `tanggal` date NOT NULL,
481 `jam` text NOT NULL,
482 `id_training` int(11) NOT NULL,
483 `status` text NOT NULL,
484 PRIMARY KEY (`id`),
485 KEY `id_member` (`id_member`),
486 KEY `id_training` (`id_training`),
487 CONSTRAINT `watched_training_ibfk_1` FOREIGN KEY (`id_member`) REFERENCES `member` (`id`),
488 CONSTRAINT `watched_training_ibfk_2` FOREIGN KEY (`id_training`) REFERENCES `training` (`id`)
489) ENGINE=InnoDB DEFAULT CHARSET=latin1;
490
491INSERT INTO `watched_training` (`id`, `id_member`, `tanggal`, `jam`, `id_training`, `status`) VALUES
492(33, 2, '2019-10-01', '00:00:12', 1, 'BELAJAR');
493
494DROP TABLE IF EXISTS `view_rekap_komisi`;
495CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `view_rekap_komisi` AS select `member`.`id` AS `id_member`,sum(`komisi`.`komisi`) AS `komisi`,(select count(`komisi`.`id`) from `komisi` where ((`komisi`.`jenis_komisi` = 'PENJUALAN') and (`komisi`.`id_member` = `member`.`id`))) AS `totalPenjualan`,`komisi`.`tanggal` AS `tanggal` from (`komisi` left join `member` on((`member`.`id` = `komisi`.`id_member`))) where (`komisi`.`komisi` > 0) group by `member`.`id`;
496
497DROP TABLE IF EXISTS `view_rekap_komisi_backup`;
498CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `view_rekap_komisi_backup` AS select `komisi`.`id` AS `id`,`komisi`.`id_penjualan` AS `id_penjualan`,`komisi`.`komisi` AS `komisi`,`komisi`.`jenis_komisi` AS `jenis_komisi`,`komisi`.`id_member` AS `id_member`,`komisi`.`tanggal` AS `tanggal` from `komisi` group by `komisi`.`id_member`;
499
500-- 2019-10-08 02:44:31