· 6 years ago · Aug 09, 2019, 07:10 AM
1public class DBHelper extends SQLiteOpenHelper {
2
3
4 // Database Information
5 public static final String DB_NAME = "TRIPKO_DB";
6
7 // database version
8 static final int DB_VERSION = 1;
9
10 //<editor-fold desc = "TABLE NAMES">
11 public static final String ACTIVATION_DETAILS = "activation_details";
12 public static final String DEVICE_INFO = "device_info";
13 public static final String USER = "users";
14 public static final String SETTINGS = "settings";
15 public static final String SHIFT = "shift";
16 public static final String REFERENCE = "reference";
17 public static final String TRANS_CARD = "trans_card";
18 public static final String TYPE = "type";
19 public static final String CONTACT_INFO = "contact_info";
20 public static final String TRANS_LOGS = "logs";
21 //</editor-fold>
22
23 //<editor-fold desc = "TABLE ACTIVATION_DETAILS">
24 public static final String ACTIVATION_AUTO_ID = "_id";
25 public static final String ACTIVATION_SIM_SERIAL = "sim_serial";
26 public static final String ACTIVATION_SAM_SERIAL = "sam_serial";
27 public static final String ACTIVATION_SD_SERIAL = "sd_serial";
28 public static final String ACTIVATION_DEVICE_SERIAL = "device_serial";
29 //</editor-fold>
30
31 //<editor-fold desc= "TABLE DEVICE_INFO">
32 public static final String DEV_AUTO_ID = "_id";
33 public static final String DEV_COMPANY_ID = "company_id";
34 public static final String DEV_COMPANY_NAME = "company_name";
35 public static final String DEV_SUBCOMPANY_ID = "subcompany_id";
36 public static final String DEV_SUBCOMPANY_NAME = "subcompany_name";
37 public static final String DEV_SUBCOMPANY_CODE = "subcompany_code";
38 public static final String DEV_TERMINAL_ID = "terminal_id";
39 public static final String DEV_TERMINAL_NAME = "terminal_name";
40 public static final String DEV_MIN = "min";
41 public static final String DEV_TIN = "tin";
42 public static final String DEV_PERMIT_TO_USE = "permit_to_use";
43 public static final String DEV_ACCREDITATION = "accreditation_no";
44 public static final String DEV_SOFTWARE_ID = "software_id";
45 public static final String DEV_SOFTWARE_SERIAL = "software_serial";
46 public static final String DEV_CONNECTIVITY_STATUS = "connectivity_status";
47 public static final String DEV_API_CONNECTION = "api_connection";
48 public static final String DEV_TOKEN = "token";
49 public static final String DEV_CONNECTED = "connected";
50 public static final String DEV_SEND_ATTEMPT = "send_attempt";
51 //</editor-fold>
52
53 //<editor-fold desc= "TABLE USERS">
54 public static final String USER_AUTO_ID = "_id";
55 public static final String USER_POSITION = "user_position";
56 public static final String USER_CARD_ID = "user_card_id";
57 public static final String USER_EMP_ID = "user_id";
58 public static final String USER_COMP_ID = "user_company_id";
59 public static final String USER_NAME = "user_name";
60 //</editor-fold>
61
62 //<editor-fold desc= "TABLE USERS">
63 public static final String TYPE_AUTO_ID = "_id";
64 public static final String TYPE_ID = "type_id";
65 public static final String TYPE_CODE = "type_code";
66 public static final String TYPE_NAME = "type_name";
67 //</editor-fold>
68
69 //<editor-fold desc= "TABLE SETTINGS">
70 public static final String SETTINGS_AUTO_ID = "_id";
71 public static final String SETTINGS_CONTROL_NO = "control_no";
72 public static final String SETTINGS_SHIFT_DEVICE_ID = "shift_device_id";
73 public static final String SETTINGS_USER_EMP_ID = "user_id";
74 public static final String SETTINGS_USER_COMP_ID = "user_comp_id";
75 public static final String SETTINGS_USER_CARD_ID = "user_card_id";
76 public static final String SETTINGS_USER_NAME = "user_name";
77 public static final String SETTINGS_IS_DISPATCHED = "is_dispatched";
78 public static final String SETTINGS_IS_ARRIVED = "is_arrived";
79 public static final String SETTINGS_IS_SYNCED = "is_synced";
80 public static final String SETTINGS_LAST_TRANSACTION_NO = "last_transaction_no";
81 //</editor-fold>
82
83 //<editor-fold desc= "TABLE REFERENCE">
84 public static final String REFERENCE_AUTO_ID = "_id";
85 public static final String REFERENCE_CONTROL_NO = "control_no";
86 public static final String REFERENCE_TRACE_NO = "trace_no";
87 //</editor-fold>
88
89 //<editor-fold desc = "TABLE TRANS_CARD">
90 public static final String TRANS_CARD_AUTO_ID = "_id";
91 public static final String TRANS_CARD_CONTROL_NO = "control_no";
92 public static final String TRANS_CARD_TRANSACTION_NO = "transaction_no";
93 public static final String TRANS_CARD_TRACE_NO = "trace_no";
94 public static final String TRANS_CARD_CARD_NO = "card_no";
95 public static final String TRANS_CARD_LAT = "latitute";
96 public static final String TRANS_CARD_LONG = "longitute";
97 public static final String TRANS_CARD_CARD_COST = "card_cost";
98 public static final String TRANS_CARD_CARD_VALUE = "card_value";
99 public static final String TRANS_CARD_CARD_AMOUNT = "card_amount";
100 public static final String TRANS_CARD_PREVIOUS_BALANCE = "previous_balance";
101 public static final String TRANS_CARD_REMAINING_BALANCE = "remaining_balance";
102 public static final String TRANS_CARD_DATETIMESTAMP = "datetimestamp";
103 public static final String TRANS_CARD_LOYALTY_POINT = "loyalty_point";
104 public static final String TRANS_CARD_SUB_COMPANY_ID = "sub_company_id";
105 public static final String TRANS_CARD_COMPANY_ID = "company_id";
106 public static final String TRANS_CARD_USER_ID = "user_id";
107 public static final String TRANS_CARD_TERMINAL_ID = "terminal_id";
108 public static final String TRANS_CARD_TRANSACTION_TYPE_ID = "transaction_type_id";
109 public static final String TRANS_CARD_SHIFT_DEVICE_ID = "shift_device_id";
110 public static final String TRANS_CARD_TRANSACTION_DEVICE_ID = "transaction_device_id";
111 public static final String TRANS_CARD_IS_SEND = "is_send";
112 //</editor-fold>
113
114 //<editor-fold desc= "TABLE SHIFT">
115 public static final String SHIFT_AUTO_ID = "_id";
116 public static final String SHIFT_DEVICE_ID = "shift_device_id";
117 public static final String SHIFT_COMPANY_ID = "company_id";
118 public static final String SHIFT_SUBCOMPANY_ID = "subcompany_id";
119 public static final String SHIFT_TERMINAL_ID = "terminal_id";
120 public static final String SHIFT_CONTROL_NO = "control_no";
121 public static final String SHIFT_OPENING_SHIFT_DATETIME = "opening_shift_datetime";
122 public static final String SHIFT_CLOSING_SHIFT_DATETIME = "closing_shift_datetime";
123 public static final String SHIFT_USER_ID = "user_id";
124 public static final String SHIFT_BALANCE_COUNT = "balance_count";
125 public static final String SHIFT_RELOAD_COUNT = "reload_count";
126 public static final String SHIFT_CREDIT_COUNT = "credit_count";
127 public static final String SHIFT_SOLD_COUNT = "sold_count";
128 public static final String SHIFT_SOLD_GROSS = "sold_gross";
129 public static final String SHIFT_RELOAD_GROSS = "reload_gross";
130 public static final String SHIFT_GROSS_REVENUE = "gross_revenue";
131 public static final String SHIFT_OPENING_TRANSACTION_NO = "opening_transaction_no";
132 public static final String SHIFT_CLOSING_TRANSACTION_NO = "closing_transaction_no";
133 public static final String SHIFT_OPENING_LAT = "opening_lat";
134 public static final String SHIFT_OPENING_LONG = "opening_long";
135 public static final String SHIFT_CLOSING_LAT = "closing_lat";
136 public static final String SHIFT_CLOSING_LONG = "closing_long";
137 public static final String SHIFT_COUNT_IS_SEND = "count_is_send";
138 public static final String SHIFT_IS_SEND = "shift_is_send";
139 //</editor-fold>
140
141
142 //<editor-fold desc = "TABLE Contact info"
143 public static final String CONTACT_INFO_ID = "_id";
144 public static final String CONTACT_INFO_TRANSACTION_ID = "transaction_id";
145 public static final String CONTACT_INFO_CARD_NO = "card_no";
146 public static final String CONTACT_INFO_CONTACT_NO = "contact_no";
147 public static final String CONTACT_INFO_IS_SEND = "is_send";
148 //</editor-fold>
149
150 //<editor-fold desc="TABLE TRANS_LOGS">
151 public static final String TRANS_LOGS_ID = "_id";
152 public static final String TRANS_LOGS_SHIFT_ID = "shift_id";
153 public static final String TRANS_LOGS_CONTROL_NO = "control_no";
154 public static final String TRANS_LOGS_EMPLOYEE_ID = "employee_id";
155 public static final String TRANS_LOGS_MODULE = "module";
156 public static final String TRANS_LOGS_ACTION = "action_taken";
157 public static final String TRANS_LOGS_LONG = "long";
158 public static final String TRANS_LOGS_LAT = "lat";
159 public static final String TRANS_LOGS_DATETIME = "datetimestamp";
160 public static final String TRANS_LOGS_IS_SEND = "is_send";
161 //</editor-fold>
162
163 //<editor-fold desc = "CREATE_CONTACT_INFO QUERY">
164 private static final String CREATE_CONTACT_INFO = "CREATE TABLE IF NOT EXISTS " + CONTACT_INFO + "("
165 + CONTACT_INFO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
166 + CONTACT_INFO_TRANSACTION_ID + " VARCHAR,"
167 + CONTACT_INFO_CARD_NO + " VARCHAR,"
168 + CONTACT_INFO_CONTACT_NO + " VARCHAR,"
169 + CONTACT_INFO_IS_SEND + " VARCHAR)";
170 //</editor-fold>
171
172 //<editor-fold desc = "CREATE DISPATCH TABLE">
173 private static final String CREATE_SHIFT_TABLE = "CREATE TABLE IF NOT EXISTS " + SHIFT + "("
174 + SHIFT_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
175 + SHIFT_DEVICE_ID + " VARCHAR,"
176 + SHIFT_COMPANY_ID + " VARCHAR,"
177 + SHIFT_SUBCOMPANY_ID + " VARCHAR,"
178 + SHIFT_TERMINAL_ID + " VARCHAR,"
179 + SHIFT_CONTROL_NO + " VARCHAR,"
180 + SHIFT_OPENING_SHIFT_DATETIME + " VARCHAR,"
181 + SHIFT_CLOSING_SHIFT_DATETIME + " VARCHAR,"
182 + SHIFT_USER_ID + " VARCHAR,"
183 + SHIFT_BALANCE_COUNT + " VARCHAR,"
184 + SHIFT_RELOAD_COUNT + " VARCHAR,"
185 + SHIFT_CREDIT_COUNT + " VARCHAR,"
186 + SHIFT_SOLD_COUNT + " VARCHAR,"
187 + SHIFT_SOLD_GROSS + " VARCHAR,"
188 + SHIFT_RELOAD_GROSS + " VARCHAR,"
189 + SHIFT_GROSS_REVENUE + " VARCHAR,"
190 + SHIFT_OPENING_TRANSACTION_NO + " VARCHAR,"
191 + SHIFT_CLOSING_TRANSACTION_NO + " VARCHAR,"
192 + SHIFT_OPENING_LAT + " VARCHAR,"
193 + SHIFT_OPENING_LONG + " VARCHAR,"
194 + SHIFT_CLOSING_LAT + " VARCHAR,"
195 + SHIFT_CLOSING_LONG + " VARCHAR,"
196 + SHIFT_IS_SEND + " VARCHAR,"
197 + SHIFT_COUNT_IS_SEND + " VARCHAR)";
198 //</editor-fold>
199
200
201 //<editor-fold desc ="">
202 private static final String CREATE_TYPE_TABLE = "CREATE TABLE IF NOT EXISTS " + TYPE + "("
203 + TYPE_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
204 + TYPE_ID + " VARCHAR,"
205 + TYPE_CODE + " VARCHAR,"
206 + TYPE_NAME + " VARCHAR)";
207 //</editor-fold>
208
209 //<editor-fold desc = "CREATE_ACTIVATION_TABLE">
210 private static final String CREATE_ACTIVATION_TABLE = "CREATE TABLE IF NOT EXISTS " + ACTIVATION_DETAILS + "("
211 + ACTIVATION_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
212 + ACTIVATION_SIM_SERIAL + " VARCHAR,"
213 + ACTIVATION_SAM_SERIAL + " VARCHAR,"
214 + ACTIVATION_SD_SERIAL + " VARCHAR,"
215 + ACTIVATION_DEVICE_SERIAL + " VARCHAR)";
216 //</editor-fold>
217
218 //<editor-fold desc = "CREATE_DEVICE_INFORMATION QUERY">
219 private static final String CREATE_DEVICE_INFORMATION = "CREATE TABLE IF NOT EXISTS " + DEVICE_INFO + "("
220 + DEV_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
221 + DEV_COMPANY_ID + " VARCHAR,"
222 + DEV_COMPANY_NAME + " VARCHAR,"
223 + DEV_SUBCOMPANY_ID + " VARCHAR,"
224 + DEV_SUBCOMPANY_NAME + " VARCHAR,"
225 + DEV_SUBCOMPANY_CODE + " VARCHAR,"
226 + DEV_TERMINAL_ID + " INTEGER,"
227 + DEV_TERMINAL_NAME + " VARCHAR,"
228 + DEV_MIN + " VARCHAR,"
229 + DEV_TIN + " VARCHAR,"
230 + DEV_PERMIT_TO_USE + " VARCHAR,"
231 + DEV_ACCREDITATION + " VARCHAR,"
232 + DEV_SOFTWARE_ID + " VARCHAR,"
233 + DEV_SOFTWARE_SERIAL + " VARCHAR,"
234 + DEV_CONNECTIVITY_STATUS + " VARCHAR,"
235 + DEV_API_CONNECTION + " VARCHAR,"
236 + DEV_TOKEN + " VARCHAR,"
237 + DEV_CONNECTED + " VARCHAR,"
238 + DEV_SEND_ATTEMPT + " VARCHAR)";
239 //</editor-fold>
240
241 //<editor-fold desc = "CREATE USERS TABLE">
242 private static final String CREATE_USERS = "CREATE TABLE IF NOT EXISTS " + USER + "("
243 + USER_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
244 + USER_POSITION + " VARCHAR,"
245 + USER_CARD_ID + " VARCHAR,"
246 + USER_COMP_ID + " VARCHAR,"
247 + USER_EMP_ID + " VARCHAR,"
248 + USER_NAME + " VARCHAR)";
249 //</editor-fold>
250
251 //<editor-fold desc = "CREATE USERS TABLE">
252 private static final String CREATE_SETTINGS = "CREATE TABLE IF NOT EXISTS " + SETTINGS + "("
253 + SETTINGS_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
254 + SETTINGS_CONTROL_NO + " VARCHAR,"
255 + SETTINGS_SHIFT_DEVICE_ID + " VARCHAR,"
256 + SETTINGS_USER_EMP_ID + " VARCHAR,"
257 + SETTINGS_USER_COMP_ID + " VARCHAR,"
258 + SETTINGS_USER_CARD_ID + " VARCHAR,"
259 + SETTINGS_USER_NAME + " VARCHAR,"
260 + SETTINGS_IS_DISPATCHED + " VARCHAR,"
261 + SETTINGS_IS_ARRIVED + " VARCHAR,"
262 + SETTINGS_IS_SYNCED + " VARCHAR,"
263 + SETTINGS_LAST_TRANSACTION_NO + " VARCHAR)";
264 //</editor-fold>
265
266 //<editor-fold desc = "CREATE_TRANS_REFERENCE QUERY">
267 private static final String CREATE_REFERENCE = "CREATE TABLE IF NOT EXISTS " + REFERENCE + "("
268 + REFERENCE_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
269 + REFERENCE_CONTROL_NO + " INTEGER,"
270 + REFERENCE_TRACE_NO + " INTEGER)";
271 //</editor-fold>
272
273 //<editor-fold desc = "CREATE_TRANS_CARD_TABLE QUERY">
274 private static final String CREATE_TRANS_CARD = "CREATE TABLE IF NOT EXISTS " + TRANS_CARD + "("
275 + TRANS_CARD_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
276 + TRANS_CARD_CONTROL_NO + " VARCHAR,"
277 + TRANS_CARD_TRANSACTION_NO + " VARCHAR,"
278 + TRANS_CARD_TRACE_NO + " VARCHAR,"
279 + TRANS_CARD_CARD_NO + " VARCHAR,"
280 + TRANS_CARD_LAT + " VARCHAR,"
281 + TRANS_CARD_LONG + " VARCHAR,"
282 + TRANS_CARD_CARD_COST + " VARCHAR,"
283 + TRANS_CARD_CARD_VALUE + " VARCHAR,"
284 + TRANS_CARD_CARD_AMOUNT + " VARCHAR,"
285 + TRANS_CARD_PREVIOUS_BALANCE + " VARCHAR,"
286 + TRANS_CARD_REMAINING_BALANCE + " VARCHAR,"
287 + TRANS_CARD_DATETIMESTAMP + " VARCHAR,"
288 + TRANS_CARD_LOYALTY_POINT + " VARCHAR,"
289 + TRANS_CARD_SUB_COMPANY_ID + " VARCHAR,"
290 + TRANS_CARD_COMPANY_ID + " VARCHAR,"
291 + TRANS_CARD_USER_ID + " VARCHAR,"
292 + TRANS_CARD_TERMINAL_ID + " VARCHAR,"
293 + TRANS_CARD_TRANSACTION_TYPE_ID + " VARCHAR,"
294 + TRANS_CARD_SHIFT_DEVICE_ID + " VARCHAR,"
295 + TRANS_CARD_TRANSACTION_DEVICE_ID + " VARCHAR,"
296 + TRANS_CARD_IS_SEND + " VARCHAR)";
297 //</editor-fold>
298
299 //<editor-fold desc = "CREATE_TRANS_LOGS QUERY">
300 public static final String CREATE_TRANS_LOGS = "CREATE TABLE IF NOT EXISTS " + TRANS_LOGS + "("
301 + TRANS_LOGS_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
302 + TRANS_LOGS_SHIFT_ID + " VARCHAR,"
303 + TRANS_LOGS_CONTROL_NO + " VARCHAR,"
304 + TRANS_LOGS_EMPLOYEE_ID + " VARCHAR,"
305 + TRANS_LOGS_MODULE + " VARCHAR,"
306 + TRANS_LOGS_ACTION + " VARCHAR,"
307 + TRANS_LOGS_LONG + " VARCHAR,"
308 + TRANS_LOGS_LAT + " VARCHAR,"
309 + TRANS_LOGS_DATETIME + " VARCHAR,"
310 + TRANS_LOGS_IS_SEND + " VARCHAR)";
311 //</editor-fold>
312
313 public DBHelper(Context context) {
314 super(context, DB_NAME, null, DB_VERSION);
315 }
316
317 @Override
318 public void onCreate(SQLiteDatabase db) {
319
320 db.execSQL(CREATE_ACTIVATION_TABLE);
321 db.execSQL(CREATE_DEVICE_INFORMATION);
322 db.execSQL(CREATE_USERS);
323 db.execSQL(CREATE_SETTINGS);
324 db.execSQL(CREATE_REFERENCE);
325 db.execSQL(CREATE_TRANS_CARD);
326 db.execSQL(CREATE_SHIFT_TABLE);
327 db.execSQL(CREATE_TYPE_TABLE);
328 db.execSQL(CREATE_CONTACT_INFO);
329
330 }
331
332 @Override
333 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
334 onCreate(db);
335 }
336
337}