· 6 years ago · Sep 12, 2019, 03:07 AM
1package com.jti.ph.ticketing_pos_pick_and_drop_android.DatabaseUtils;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7public class DBHelper extends SQLiteOpenHelper {
8
9 // Database Information
10 public static final String DB_NAME = "TICKETKO_DB";
11
12 // database version
13 private static final int DB_VERSION = 1;
14
15 //<editor-fold desc = "database tables">
16 public static final String ACTIVATION = "activation";
17 public static final String DEV_INFO = "dev_info";
18 public static final String DEVICE_SETTINGS = "device_settings";
19 public static final String SUBCOMPANIES = "subcompanies";
20 public static final String USERS = "users";
21 public static final String ROUTES = "routes";
22 public static final String VEHICLES = "vehicles";
23 public static final String VIOLATION_LISTS = "violation_lists";
24 public static final String EXPENSE_LISTS = "expense_lists";
25 public static final String TERMINALS = "terminals";
26 public static final String STATIONS = "stations";
27 public static final String MANUAL_TYPES = "manual_types";
28 public static final String KMPOSTS = "kmposts";
29
30 public static final String SETTINGS = "settings";
31
32 public static final String REMITTANCE = "remittance";
33 public static final String DISPATCHING = "dispatching";
34 public static final String ARRIVAL = "arrival";
35 public static final String TICKETS = "tickets";
36 public static final String REFUND = "refund";
37 public static final String INSPECTION = "inspection";
38 public static final String TRANSFER = "transfer";
39 public static final String RECEIVE = "receive";
40 public static final String VIOLATION = "violation";
41 public static final String PARTIAL = "partial";
42 public static final String MANUAL = "manual";
43 public static final String EXPENSE = "expense";
44 public static final String SPECIAL_TRIP = "special_trip";
45 public static final String REMITTANCE_INPUT = "remittance_input";
46 public static final String FUEL_LOAD = "fuel_load";
47 public static final String DEVICE_LOGS = "device_logs";
48
49 //</editor-fold>
50
51 //<editor-fold desc ="REMITTANCE_INPUT">
52 public static final String REMITTANCE_INPUT_AUTO_ID = "_id";
53 public static final String REMITTANCE_INPUT_REMITTANCE_ID = "remittance_id";
54 public static final String REMITTANCE_INPUT_GENERATED_REMITTANCE_ID = "generated_id";
55 public static final String REMITTANCE_INPUT_CONTROL_NO = "control_no";
56 public static final String REMITTANCE_INPUT_DEVICE_REVENUE = "device_revenue";
57 public static final String REMITTANCE_INPUT_GROSS_COLLECTION = "gross_collection";
58 public static final String REMITTANCE_INPUT_REFUND_AMOUNT = "refund_amount";
59 public static final String REMITTANCE_INPUT_TRANSFER_AMOUNT = "transfer_amount";
60 public static final String REMITTANCE_INPUT_RECEIVED_AMOUNT = "received_amount";
61 public static final String REMITTANCE_INPUT_MANUAL_AMOUNT = "manual_amount";
62 public static final String REMITTANCE_INPUT_GROSS_COMM_DRIVER = "gross_comm_driver";
63 public static final String REMITTANCE_INPUT_GROSS_COMM_CONDUCTOR = "gross_comm_conductor";
64 public static final String REMITTANCE_INPUT_SCHEME_DRIVER = "scheme_driver";
65 public static final String REMITTANCE_INPUT_SCHEME_CONDUCTOR = "scheme_conductor";
66 public static final String REMITTANCE_INPUT_SP_COMM_DRIVER = "sp_comm_driver";
67 public static final String REMITTANCE_INPUT_SP_COMM_CONDUCTOR = "sp_comm_conductor";
68 public static final String REMITTANCE_INPUT_TAKE_HOME_DRIVER = "take_home_driver";
69 public static final String REMITTANCE_INPUT_TAKE_HOME_CONDUCTOR = "take_home_conductor";
70 public static final String REMITTANCE_INPUT_TOTAL_TAKE_HOME = "total_take_home";
71 public static final String REMITTANCE_INPUT_EXPENSE_TOLL_FEE = "expense_toll_fee";
72 public static final String REMITTANCE_INPUT_EXPENSE_TOWING = "expense_towing";
73 public static final String REMITTANCE_INPUT_EXPENSE_PARKING = "expense_parking";
74 public static final String REMITTANCE_INPUT_EXPENSE_INSURANCE = "expense_insurance";
75 public static final String REMITTANCE_INPUT_EXPENSE_VULCANIZE = "expense_vulcanize";
76 public static final String REMITTANCE_INPUT_EXPENSE_REPRESENTATION = "expense_representation";
77 public static final String REMITTANCE_INPUT_EXPENSE_LUBRICANT = "expense_lubricant";
78 public static final String REMITTANCE_INPUT_EXPENSE_REPAIR_MAINT = "expense_repair_maint";
79 public static final String REMITTANCE_INPUT_EXPENSE_DIESEL = "expense_diesel";
80 public static final String REMITTANCE_INPUT_EXPENSE_SUB_TOTAL = "expense_sub_total";
81 public static final String REMITTANCE_INPUT_EXPENSE_NON_CASH_PARKING = "non_cash_parking";
82 public static final String REMITTANCE_INPUT_EXPENSE_NON_CASH_TOLL_FEE = "non_cash_toll_fee";
83 public static final String REMITTANCE_INPUT_EXPENSE_NON_CASH_SUB_TOTAL = "non_cash_sub_total";
84 public static final String REMITTANCE_INPUT_EXPENSE_OUTSIDE_AMOUNT = "outside_amount";
85 public static final String REMITTANCE_INPUT_EXPENSE_OUTSIDE_LITERS = "outside_liters";
86 public static final String REMITTANCE_INPUT_EXPENSE_INHOUSE_LITERS = "inhouse_liters";
87 public static final String REMITTANCE_INPUT_EXPENSE_TOTAL_CONSUMPTION_LITERS = "total_consumption_liters";
88 public static final String REMITTANCE_INPUT_EXPENSE_TOTAL_CONSUMPTION_AMOUNT = "total_consumption_amount";
89 public static final String REMITTANCE_INPUT_EXPENSE_DAMAGE_AMOUNT = "damage_amount";
90 public static final String REMITTANCE_INPUT_EXPENSE_PARTIAL_AMOUNT = "partial_amount";
91 public static final String REMITTANCE_INPUT_EXPENSE_PAYMENT_DRIVER = "payment_driver";
92 public static final String REMITTANCE_INPUT_EXPENSE_PAYMENT_CONUCTOR = "payment_conductor";
93 public static final String REMITTANCE_INPUT_EXPENSE_VALE_DRIVER = "vale_driver";
94 public static final String REMITTANCE_INPUT_EXPENSE_VALE_CONDUCTOR = "vale_conductor";
95 public static final String REMITTANCE_INPUT_EXPENSE_BAGGAGE_AMOUNT = "baggage_amount";
96 public static final String REMITTANCE_INPUT_EXPENSE_SP_TRIP_AMOUNT = "sp_trip_amount";
97 public static final String REMITTANCE_INPUT_EXPENSE_FERRY_AMOUNT = "ferry_amount";
98 public static final String REMITTANCE_INPUT_EXPENSE_TALAO_AMOUNT = "talao_amount";
99 public static final String REMITTANCE_INPUT_EXPENSE_TWO_GO_AMOUNT = "two_go_amount";
100 public static final String REMITTANCE_INPUT_EXPENSE_OTHER_INCOME_SUB_TOTAL = "other_income_sub_total";
101 public static final String REMITTANCE_INPUT_EXPENSE_NET_REMITTANCE = "net_remittance";
102 public static final String REMITTANCE_INPUT_EXPENSE_SHORT_OVER = "short_over";
103 public static final String REMITTANCE_INPUT_EXPENSE_CASH_RECEIVED = "cash_received";
104
105 //</editor-fold>
106
107 //<editor-fold desc = "TABLE SPECIAL TRIP">
108 public static final String SPECIAL_TRIP_AUTO_ID = "_id";
109 public static final String SPECIAL_TRIP_GENERATED_ID = "generated_id";
110 public static final String SPECIAL_TRIP_COMPANY_ID = "company_id";
111 public static final String SPECIAL_TRIP_SUBCOMPANY_ID = "subcompany_id";
112 public static final String SPECIAL_TRIP_REMITTANCE_ID = "remittance_id";
113 public static final String SPECIAL_TRIP_DISPATCH_ID = "dispatch_id";
114 public static final String SPECIAL_TRIP_VEHICLE_ID = "vehicle_id";
115 public static final String SPECIAL_TRIP_VEHICLE_NO = "vehicle_no";
116 public static final String SPECIAL_TRIP_PLATE_NO = "plate_no";
117 public static final String SPECIAL_TRIP_ROUTE_ID = "route_id";
118 public static final String SPECIAL_TRIP_ROUTE_NAME = "route_name";
119 public static final String SPECIAL_TRIP_ROUTE_CODE = "route_code";
120 public static final String SPECIAL_TRIP_ORIGIN = "origin";
121 public static final String SPECIAL_TRIP_DESTINATION = "destination";
122 public static final String SPECIAL_TRIP_CONTROL_NO = "control_no";
123 public static final String SPECIAL_TRIP_TRIP_NO = "trip_no";
124 public static final String SPECIAL_TRIP_NO_OF_TRIPS = "no_of_trips";
125 public static final String SPECIAL_TRIP_ACCOUNT_NAME = "account_name";
126 public static final String SPECIAL_TRIP_DATETIME_RELEASE = "datetime_release";
127 public static final String SPECIAL_TRIP_DATETIME_RETURN = "datetime_return";
128 public static final String SPECIAL_TRIP_KMRUN = "kmrun";
129 public static final String SPECIAL_TRIP_RUNNING_TIME = "running_time";
130 public static final String SPECIAL_TRIP_DISPATCHER_ID = "dispatcher_id";
131 public static final String SPECIAL_TRIP_CONDUCTOR_ID = "conductor_id";
132 public static final String SPECIAL_TRIP_DRIVER_ID = "driver_id";
133 public static final String SPECIAL_TRIP_DRIVER2_ID = "driver2_id";
134 public static final String SPECIAL_TRIP_TYPE = "type";
135 public static final String SPECIAL_TRIP_LONG = "long";
136 public static final String SPECIAL_TRIP_LAT = "lat";
137 public static final String SPECIAL_TRIP_DATETIMESTAMP = "datetimestamp";
138 //</editor-fold>
139
140 //<editor-fold desc = "TABLE MANUAL">
141 public static final String MANUAL_AUTO_ID = "_id";
142 public static final String MANUAL_GENERATED_ID = "generated_id";
143 public static final String MANUAL_REMITTANCE_ID = "remittance_id";
144 public static final String MANUAL_DISPATCH_ID = "dispatch_id";
145 public static final String MANUAL_CONTROL_NO = "control_no";
146 public static final String MANUAL_TRIP_NO = "trip_no";
147 public static final String MANUAL_M_CONTROL_NO = "manual_control_no";
148 public static final String MANUAL_NO_OF_TICKETS = "no_of_tickets";
149 public static final String MANUAL_AMOUNT = "amount";
150 public static final String MANUAL_TYPE = "type";
151 public static final String MANUAL_EMP_ID = "emp_id";
152 public static final String MANUAL_EMP_NAME = "emp_name";
153 public static final String MANUAL_LONG = "long";
154 public static final String MANUAL_LAT = "lat";
155 public static final String MANUAL_DATETIMESTAMP = "datetimestamp";
156 //</editor-fold>
157
158 //<editor-fold desc = "TABLE PARTIAL">
159 public static final String PARTIAL_AUTO_ID = "_id";
160 public static final String PARTIAL_GENERATED_ID = "generated_id";
161 public static final String PARTIAL_REMITTANCE_ID = "remittance_id";
162 public static final String PARTIAL_DISPATCH_ID = "dispatch_id";
163 public static final String PARTIAL_ROUTE_ID = "route_id";
164 public static final String PARTIAL_CONTROL_NO = "control_no";
165 public static final String PARTIAL_TRIP_NO = "trip_no";
166 public static final String PARTIAL_TERMINAL_ID = "terminal_id";
167 public static final String PARTIAL_TERMINAL_NAME = "terminal_name";
168 public static final String PARTIAL_AMOUNT = "amount";
169 public static final String PARTIAL_REMARKS = "remarks";
170 public static final String PARTIAL_EMP_ID = "emp_id";
171 public static final String PARTIAL_EMP_NAME = "emp_name";
172 public static final String PARTIAL_LONG = "long";
173 public static final String PARTIAL_LAT = "lat";
174 public static final String PARTIAL_DATETIMESTAMP = "datetimestamp";
175 //</editor-fold>
176
177 //<editor-fold desc="TABLE VIOLATION">
178 public static final String VIOLATION_AUTO_ID = "_id";
179 public static final String VIOLATION_GENERATED_ID = "generated_id_id";
180 public static final String VIOLATION_DISPATCH_ID = "dispatch_id";
181 public static final String VIOLATION_ROUTE_ID = "route_id";
182 public static final String VIOLATION_CONTROL_NO = "control_no";
183 public static final String VIOLATION_TRIP_NO = "trip_no";
184 public static final String VIOLATION_GIVEN_BY = "given_by";
185 public static final String VIOLATION_EMP_ID = "emp_id";
186 public static final String VIOLATION_EMP_NAME = "emp_name";
187 public static final String VIOLATION_VIOLATION = "violation";
188 public static final String VIOLATION_LONG = "long";
189 public static final String VIOLATION_LAT = "lat";
190 public static final String VIOLATION_IS_ACCEPTED = "is_accepted";
191 public static final String VIOLATION_DATETIMESTAMP = "datetimestamp";
192 //</editor-fold>
193
194 //<editor-fold desc="TABLE TRANSFER">
195 public static final String TRANSFER_AUTO_ID = "_id";
196 public static final String TRANSFER_DISPATCH_ID = "dispatch_id";
197 public static final String TRANSFER_ROUTE_ID = "route_id";
198 public static final String TRANSFER_GENERATED_ID = "generated_id";
199 public static final String TRANSFER_CONTROL_NO = "control_no";
200 public static final String TRANSFER_TRIP_NO = "trip_no";
201 public static final String TRANSFER_TICKET_NO = "ticket_no";
202 public static final String TRANSFER_AMOUNT = "amount";
203 public static final String TRANSFER_KM_FROM = "km_from";
204 public static final String TRANSFER_KM_TO = "km_to";
205 public static final String TRANSFER_TICKET_DATETIME = "ticket_datetime";
206 public static final String TRANSFER_EMP_ID = "emp_id";
207 public static final String TRANSFER_EMP_NAME = "emp_name";
208 public static final String TRANSFER_STATUS = "status";
209 public static final String TRANSFER_PASSENGER_TYPE = "passenger_type";
210 public static final String TRANSFER_LONG = "long";
211 public static final String TRANSFER_LAT = "lat";
212 public static final String TRANSFER_DATEIMESTAMP = "datetimestamp";
213 //</editor-fold>
214
215 //<editor-fold desc = "TABLE INSPECTION">
216 public static final String INSPECTION_AUTO_ID = "_id";
217 public static final String INSPECTION_DISPATCH_ID = "dispatch_id";
218 public static final String INSPECTION_ROUTE_ID = "route_id";
219 public static final String INSPECTION_GENERATED_ID = "generated_id";
220 public static final String INSPECTION_CONTROL_NO = "control_no";
221 public static final String INSPECTION_TRIP_NO = "trip_no";
222 public static final String INSPECTION_TIME_ON = "time_on";
223 public static final String INSPECTION_TIME_OFF = "time_off";
224 public static final String INSPECTION_PLACE_ON = "place_on";
225 public static final String INSPECTION_POSITION = "position";
226 public static final String INSPECTION_EMP_ID = "emp_id";
227 public static final String INSPECTION_EMP_COMP_ID = "emp_comp_id";
228 public static final String INSPECTION_EMP_NAME = "emp_name";
229 public static final String INSPECTION_PASSENGER_COUNT = "passenger_count";
230 public static final String INSPECTION_HEAD_COUNT = "head_count";
231 public static final String INSPECTION_BAGGAGE_COUNT = "baggage_count";
232 public static final String INSPECTION_KMRUN = "km_run";
233 public static final String INSPECTION_REMARKS = "remarks";
234 public static final String INSPECTION_LONG = "long";
235 public static final String INSPECTION_LAT = "lat";
236 public static final String INSPECTION_DATETIMESTAMP = "datetimestamp";
237 //</editor-fold>
238
239 //<editor-fold desc = "TABLE REFUND">
240 public static final String REFUND_AUTO_ID = "_id";
241 public static final String REFUND_DISPATCH_ID = "dispatch_id";
242 public static final String REFUND_ROUTE_ID = "route_id";
243 public static final String REFUND_GENERATED_ID = "generated_id";
244 public static final String REFUND_CONTROL_NO = "control_no";
245 public static final String REFUND_TRIP_NO = "trip_no";
246 public static final String REFUND_TICKET_NO = "ticket_no";
247 public static final String REFUND_PLACE_FROM = "place_from";
248 public static final String REFUND_PLACE_TO = "place_to";
249 public static final String REFUND_TICKET_DATETIME = "ticket_datetime";
250 public static final String REFUND_AMOUNT = "amount";
251 public static final String REFUND_PASSENGER_TYPE = "passenger_type";
252 public static final String REFUND_PASSENGER_CODE = "passenger_code";
253 public static final String REFUND_LONG = "long";
254 public static final String REFUND_LAT = "lat";
255 public static final String REFUND_CONDUCTOR_ID = "conductor_id";
256 public static final String REFUND_CONDUCTOR_NAME = "conductor_name";
257 public static final String REFUND_EMP_ID = "emp_id";
258 public static final String REFUND_EMP_NAME = "emp_name";
259 public static final String REFUND_DATETIMESTAMP = "datetimestamp";
260 //</editor-fold>
261
262 //<editor-fold desc = "TABLE RECEIVE">
263 public static final String RECEIVE_AUTO_ID = "_id";
264 public static final String RECEIVE_DISPATCH_ID = "dispatch_id";
265 public static final String RECEIVE_ROUTE_ID = "route_id";
266 public static final String RECEIVE_GENERATED_ID = "generated_id";
267 public static final String RECEIVE_CONTROL_NO = "control_no";
268 public static final String RECEIVE_TRIP_NO = "trip_no";
269 public static final String RECEIVE_PASSENGER_COUNT = "passenger_count";
270 public static final String RECEIVE_TOTAL_AMOUNT = "total_amount";
271 public static final String RECEIVE_INCOME_TYPE = "income_type";
272 public static final String RECEIVE_EMP_ID = "emp_id";
273 public static final String RECEIVE_EMP_NAME = "emp_name";
274 public static final String RECEIVE_LONG = "long";
275 public static final String RECEIVE_LAT = "lat";
276 public static final String RECEIVE_DATETIMESTAMP = "datetimestamp";
277 //</editor-fold>
278
279 //<editor-fold desc = "TABLE ACTIVATION">
280 public static final String ACTIVATION_AUTO_ID = "_id";
281 public static final String ACTIVATION_SIM_SERIAL = "sim_serial";
282 public static final String ACTIVATION_SAM_SERIAL = "sam_serial";
283 public static final String ACTIVATION_SD_SERIAL = "sd_serial";
284 public static final String ACTIVATION_DEVICE_SERIAL = "device_serial";
285 public static final String ACTIVATION_CONNECTION = "connection";
286 //</editor-fold>
287
288 //<editor-fold desc = "TABLE DEVICE INFO">
289 public static final String DEV_INFO_AUTO_ID = "_id";
290 public static final String DEV_INFO_COMPANY_ID = "company_id";
291 public static final String DEV_INFO_SUBCOMPANY_ID = "subcompany_id";
292 public static final String DEV_INFO_COMPANY_NAME = "company_name";
293 public static final String DEV_INFO_SUBCOMPANY_NAME = "subcompany_name";
294 public static final String DEV_INFO_TERMINAL = "terminal";
295 public static final String DEV_INFO_VEHICLE_ID = "vehicle_id";
296 public static final String DEV_INFO_STATUS = "status";
297 public static final String DEV_INFO_TYPE = "type";
298 //</editor-fold>
299
300 //<editor-fold desc= "TABLE USERS">
301 public static final String USER_AUTO_ID = "_id";
302 public static final String USER_ID = "user_id";
303 public static final String USER_COMPANY_ID = "company_id";
304 public static final String USER_SUBCOMPANY_ID = "subcompany_id";
305 public static final String USER_EMP_ID = "emp_id";
306 public static final String USER_NAME = "user_name";
307 public static final String USER_CARD_ID = "user_card_id";
308 public static final String USER_POSITION = "position";
309 public static final String USER_FUND_RATE = "fund_rate";
310 public static final String USER_COMM_RATE = "commission_rate";
311 public static final String USER_BONUS_RATE = "bonus_rate";
312 public static final String USER_SURETY_FUND = "surety_fund";
313 public static final String USER_ALLOWANCE = "allowance";
314 //</editor-fold>
315
316 //<editor-fold desc= "TABLE ROUTES">
317 public static final String ROUTE_AUTO_ID = "_id";
318 public static final String ROUTE_COMPANY_ID = "company_id";
319 public static final String ROUTE_ID = "route_id";
320 public static final String ROUTE_NAME = "name";
321 public static final String ROUTE_MIN_KM = "min_km";
322 public static final String ROUTE_MIN_FARE = "min_fare";
323 public static final String ROUTE_FARE_RATE = "fare_rate";
324 public static final String ROUTE_CODE = "code";
325 public static final String ROUTE_QUOTA_1 = "quota_1";
326 public static final String ROUTE_QUOTA_2 = "quota_2";
327 public static final String ROUTE_BOUND = "bound";
328 public static final String ROUTE_KMRUN = "kmrun";
329 public static final String ROUTE_HOUR = "hour";
330 public static final String ROUTE_GROUP = "_group";
331 //</editor-fold>
332
333 //<editor-fold desc= "TABLE SUBCOMPANIES">
334 public static final String SUBCOMPANIES_AUTO_ID = "_id";
335 public static final String SUBCOMPANIES_ID = "subcompany_id";
336 public static final String SUBCOMPANIES_NAME = "name";
337 public static final String SUBCOMPANIES_DRIVER_SCHEME = "driver_scheme";
338 public static final String SUBCOMPANIES_CONDUCTOR_SCHEME = "conductor_scheme";
339 //</editor-fold>
340
341 //<editor-fold desc= "TABLE VEHICLES">
342 public static final String VEHICLES_AUTO_ID = "_id";
343 public static final String VEHICLES_ID = "vehicle_id";
344 public static final String VEHICLES_COMPANY_ID = "company_id";
345 public static final String VEHICLES_BUS_NO = "bus_no";
346 public static final String VEHICLES_PLATE_NO = "plate_no";
347 public static final String VEHICLES_SOFTWARE_SERIAL_NO = "software_serial_no";
348 public static final String VEHICLES_PERMIT_TO_USE = "permit_to_use";
349 public static final String VEHICLES_TIN = "tin";
350 public static final String VEHICLES_ACCRE = "accre";
351 public static final String VEHICLES_MIN = "min";
352 //</editor-fold>
353
354 //<editor-fold desc= "TABLE VIOLATION_LISTS">
355 public static final String VIOLATION_LIST_AUTO_ID = "_id";
356 public static final String VIOLATION_LIST_COMPANY_ID = "company_id";
357 public static final String VIOLATION_LIST_NAME = "name";
358 public static final String VIOLATION_LIST_EMP_TYPE = "employee_type";
359 //</editor-fold>
360
361 //<editor-fold desc= "TABLE EXPENSE_LISTS">
362 public static final String EXPENSE_LIST_AUTO_ID = "_id";
363 public static final String EXPENSE_LIST_ID = "expense_list_id";
364 public static final String EXPENSE_LIST_NAME = "expense_list_name";
365 //</editor-fold>
366
367 //<editor-fold desc= "TABLE TERMINALS">
368 public static final String TERMINAL_AUTO_ID = "_id";
369 public static final String TERMINAL_ID = "terminal_id";
370 public static final String TERMINAL_NAME = "terminal_name";
371 //</editor-fold>
372
373 //<editor-fold desc= "TABLE STATIONS">
374 public static final String STATION_AUTO_ID = "_id";
375 public static final String STATION_ID = "station_id";
376 public static final String STATION_COMPANY_ID = "company_id";
377 public static final String STATION_SUBCOMPANY_ID = "subcompany_id";
378 public static final String STATION_STATION = "station";
379 public static final String STATION_STATUS = "status";
380 //</editor-fold>
381
382 //<editor-fold desc= "TABLE MANUAL TYPES">
383 public static final String MANUAL_TYPE_AUTO_ID = "_id";
384 public static final String MANUAL_TYPE_ID = "manual_type_id";
385 public static final String MANUAL_TYPE_NAME = "name";
386 //</editor-fold>
387
388 //<editor-fold desc= "TABLE KMPOSTS">
389 public static final String KMPOST_AUTO_ID = "_id";
390 public static final String KMPOST_ID = "kmpost_id";
391 public static final String KMPOST_ROUTE_NAME = "route_name";
392 public static final String KMPOST_NAME = "name";
393 public static final String KMPOST_POST = "post";
394 public static final String KMPOST_PRICE = "price";
395 public static final String KMPOST_DISC_PRICE = "discounted_price";
396 public static final String KMPOST_PRICE2 = "price_2";
397 public static final String KMPOST_DISC_PRICE2 = "discounted_price_2";
398 public static final String KMPOST_PRICE3 = "price_3";
399 public static final String KMPOST_DISC_PRICE3 = "discounted_price_3";
400 public static final String KMPOST_SPECIAL_FARE = "special_fare";
401 public static final String KMPOST_SPECIAL_FARE_DISC = "special_fare_discounted";
402 //</editor-fold>
403
404 //<editor-fold desc= "TABLE SETTINGS">
405 public static final String SETTINGS_AUTO_ID = "_id";
406 public static final String SETTINGS_REMITTANCE_ID = "remittance_id";
407 public static final String SETTINGS_DISPATCH_ID = "dispatch_id";
408 public static final String SETTINGS_CONTROL_NO = "control_no";
409 public static final String SETTINGS_TRIP_NO = "trip_no";
410 public static final String SETTINGS_VEHICLE_ID = "vehicle_id";
411 public static final String SETTINGS_VEHICLE_NO = "vehicle_no";
412 public static final String SETTINGS_PLATE_NO = "plate_no";
413 public static final String SETTINGS_IS_DISPATCHED = "is_dispatched";
414 public static final String SETTINGS_IS_ARRIVED = "is_arrived";
415 public static final String SETTINGS_IS_CLOSED = "is_closed";
416 public static final String SETTINGS_IS_SYNCED = "is_synced";
417 public static final String SETTINGS_DRIVER_ID = "driver_id";
418 public static final String SETTINGS_DRIVER_CARD_ID = "driver_card_id";
419 public static final String SETTINGS_DRIVER_NAME = "driver_name";
420 public static final String SETTINGS_DRIVER_EMP_ID = "driver_emp_id";
421 public static final String SETTINGS_CONDUCTOR_ID = "conductor_id";
422 public static final String SETTINGS_CONDUCTOR_CARD_ID = "conductor_card_id";
423 public static final String SETTINGS_CONDUCTOR_NAME = "conductor_name";
424 public static final String SETTINGS_CONDUCTOR_EMP_ID = "conductor_emp_id";
425 public static final String SETTINGS_DISPATCHER_ID = "dispatcher_id";
426 public static final String SETTINGS_DISPATCHER_NAME = "dispatcher_name";
427 public static final String SETTINGS_ROUTE_ID = "route_id";
428 public static final String SETTINGS_ROUTE_NAME = "route_name";
429 ;
430 public static final String SETTINGS_ROUTE_CODE = "route_code";
431 public static final String SETTINGS_ROUTE_BOUND = "route_bound";
432 public static final String SETTINGS_TRIP_TYPE = "trip_type";
433 public static final String SETTINGS_SOFTWARE_SERIAL_NO = "software_serial_no";
434 public static final String SETTINGS_TICKETING_KMPOST = "ticketing_kmpost";
435 public static final String SETTINGS_INSPECTION_KMPOST = "inspection_kmpost";
436 public static final String SETTINGS_KMRUN = "kmrun";
437 public static final String SETTINGS_RUNNING_TIME = "running_time";
438 public static final String SETTINGS_DISPATCHED_DATE = "dispatched_date";
439 public static final String SETTINGS_DISPATCHED_TIME = "dispatched_time";
440 public static final String SETTINGS_LAST_TICKET_NO = "last_ticket_no";
441 //</editor-fold>
442
443 //<editor-fold desc= "TABLE REMITTANCE">
444 public static final String REMITTANCE_AUTO_ID = "_id";
445 public static final String REMITTANCE_COMPANY_ID = "company_id";
446 public static final String REMITTANCE_SUBCOMPANY_ID = "subcompany_id";
447 public static final String REMITTANCE_ID = "remittance_id";
448 public static final String REMITTANCE_VEHICLE_ID = "vehicle_id";
449 public static final String REMITTANCE_CONTROL_NO = "control_no";
450 public static final String REMITTANCE_DRIVER_ID = "driver_id";
451 public static final String REMITTANCE_DRIVER_NAME = "driver_name";
452 public static final String REMITTANCE_CONDUCTOR_ID = "conductor_id";
453 public static final String REMITTANCE_CONDUCTOR_NAME = "conductor_name";
454 public static final String REMITTANCE_CASHIER_ID = "cashier_id";
455 public static final String REMITTANCE_CASHIER_NAME = "cashier_name";
456 public static final String REMITTANCE_TOTAL_TRANSFERED_AMOUNT = "total_transfered_amount";
457 public static final String REMITTANCE_TOTAL_RECEIVED_AMOUNT = "total_received_amount";
458 public static final String REMITTANCE_TOTAL_REFUNDED_AMOUNT = "total_refunded_amount";
459 public static final String REMITTANCE_TICKET_GROSS = "ticket_gross";
460 public static final String REMITTANCE_TICKET_COUNT = "ticket_count";
461 public static final String REMITTANCE_TOTAL_BAGGAGE_GROSS = "total_baggage_gross";
462 public static final String REMITTANCE_TOTAL_PASSES_AMOUNT = "total_passes_amount";
463 public static final String REMITTANCE_TOTAL_PARTIAL = "total_partial";
464 public static final String REMITTANCE_TOTAL_EXPENSE = "total_expense";
465 public static final String REMITTANCE_TOTAL_FUEL_LITERS = "total_fuel_liters";
466 public static final String REMITTANCE_DATETIMESTAMP = "datetimestamp";
467 public static final String REMITTANCE_IS_SEND = "is_send";
468 //</editor-fold>
469
470 //<editor-fold desc= "TABLE DISPATCHING">
471 public static final String DISPATCHING_AUTO_ID = "_id";
472 public static final String DISPATCHING_ID = "dispatching_id";
473 public static final String DISPATCHING_REMITTANCE_ID = "remittance_id";
474 public static final String DISPATCHING_CONTROL_NO = "control_no";
475 public static final String DISPATCHING_TRIP_NO = "trip_no";
476 public static final String DISPATCHING_VEHICLE_NO = "vehicle_no";
477 public static final String DISPATCHING_VEHICLE_PLATE_NO = "vehicle_plate_no";
478 public static final String DISPATCHING_ROUTE_ID = "route_id";
479 public static final String DISPATCHING_ROUTE_NAME = "route_name";
480 public static final String DISPATCHING_ROUTE_CODE = "route_code";
481 public static final String DISPATCHING_ROUTE_BOUND = "route_bound";
482 public static final String DISPATCHING_DRIVER_ID = "driver_id";
483 public static final String DISPATCHING_DRIVER_NAME = "driver_name";
484 public static final String DISPATCHING_CONDUCTOR_ID = "conductor_id";
485 public static final String DISPATCHING_CONDUCTOR_NAME = "conductor_name";
486 public static final String DISPATCHING_DISPATCHER_ID = "dispatcher_id";
487 public static final String DISPATCHING_DISPATCHER_NAME = "dispatcher_name";
488 public static final String DISPATCHING_TRIP_TYPE = "trip_type";
489 public static final String DISPATCHING_PASSENGER_COUNT = "passenger_count";
490 public static final String DISPATCHING_OPENING_TICKET = "opening_ticket";
491 public static final String DISPATCHING_BACKUP_DRIVER_ID = "backup_driver_id";
492 public static final String DISPATCHING_BACKUP_DRIVER_NAME = "backup_driver_name";
493 public static final String DISPATCHING_KM_RUN = "kmrun";
494 public static final String DISPATCHING_HOUR = "hour";
495 public static final String DISPATCHING_LONG = "long";
496 public static final String DISPATCHING_LAT = "lat";
497 public static final String DISPATCHING_DATETIMESTAMP = "datetimestamp";
498 public static final String DISPATCHING_IS_SEND = "is_send";
499 //</editor-fold>
500
501 //<editor-fold desc= "TABLE ARRIVAL">
502 public static final String ARRIVAL_AUTO_ID = "_id";
503 public static final String ARRIVAL_REMITTANCE_ID = "remittance_id";
504 public static final String ARRIVAL_DISPATCH_ID = "dispatch_id";
505 public static final String ARRIVAL_GENERATED_ID = "generated_id";
506 public static final String ARRIVAL_CONTROL_NO = "control_no";
507 public static final String ARRIVAL_TRIP_NO = "trip_no";
508 public static final String ARRIVAL_VEHICLE_NO = "vehicle_no";
509 public static final String ARRIVAL_VEHICLE_PLATE_NO = "plate_no";
510 public static final String ARRIVAL_DRIVER_ID = "driver_id";
511 public static final String ARRIVAL_DRIVER_EMP_ID = "driver_emp_id";
512 public static final String ARRIVAL_DRIVER_NAME = "driver_name";
513 public static final String ARRIVAL_CONDUCTOR_ID = "conductor_id";
514 public static final String ARRIVAL_CONDUCTOR_EMP_ID = "conductor_emp_id";
515 public static final String ARRIVAL_CONDUCTOR_NAME = "conductor_name";
516 public static final String ARRIVAL_DISPATCHER_ID = "dispatcher_id";
517 public static final String ARRIVAL_DISPATCHER_EMP_ID = "dispatcher_emp_id";
518 public static final String ARRIVAL_DISPATCHER_NAME = "dispatcher_name";
519 public static final String ARRIVAL_BACKUP_DRIVER_ID = "backup_driver_id";
520 public static final String ARRIVAL_BACKUP_DRIVER_NAME = "backup_driver_name";
521 public static final String ARRIVAL_ROUTE_ID = "route_id";
522 public static final String ARRIVAL_ROUTE_NAME = "route_name";
523 public static final String ARRIVAL_ROUTE_BOUND = "route_bound";
524 public static final String ARRIVAL_ROUTE_CODE = "route_code";
525 public static final String ARRIVAL_OPENING_TICKET = "opening_ticket";
526 public static final String ARRIVAL_CLOSING_TICKET = "closing_ticket";
527 public static final String ARRIVAL_PASSENGER_COUNT = "passenger_count";
528 public static final String ARRIVAL_BAGGAGE_COUNT = "baggage_count";
529 public static final String ARRIVAL_PASSENGER_GROSS = "passenger_gross";
530 public static final String ARRIVAL_BAGGAGE_GROSS = "baggage_gross";
531 public static final String ARRIVAL_REFUND_GROSS = "refund_gross";
532 public static final String ARRIVAL_TRANSFER_GROSS = "transfer_gross";
533 public static final String ARRIVAL_RECEIVED_GROSS = "received_gross";
534 public static final String ARRIVAL_LONG = "long";
535 public static final String ARRIVAL_LAT = "lat";
536 public static final String ARRIVAL_KMRUN = "kmrun";
537 public static final String ARRIVAL_RUNNING_TIME = "running_time";
538 public static final String ARRIVAL_COUNT_REGULAR = "count_regular";
539 public static final String ARRIVAL_COUNT_STUDENT = "count_student";
540 public static final String ARRIVAL_COUNT_SENIOR = "count_senior";
541 public static final String ARRIVAL_COUNT_PWD = "count_pwd";
542 public static final String ARRIVAL_COUNT_PREPAID = "count_prepaid";
543 public static final String ARRIVAL_COUNT_PASSES = "count_passes";
544 public static final String ARRIVAL_DISPATCHED_TIME = "dispatched_time";
545 public static final String ARRIVAL_TIME = "arrival_time";
546 public static final String ARRIVAL_DATETIMESTAMP = "datetimestamp";
547 public static final String ARRIVAL_IS_SEND = "is_send";
548 //</editor-fold>
549
550 //<editor-fold desc= "TABLE DEVICE SETTINGS">
551 public static final String DEVICE_SETTINGS_AUTO_ID = "_id";
552 public static final String DEVICE_SETTINGS_CONTROL_NO = "control_no";
553 public static final String DEVICE_SETTINGS_TRIP_NO = "trip_no";
554 public static final String DEVICE_SETTINGS_TRANSACTION_NO = "transaction_no";
555 //</editor-fold>
556
557 //<editor-fold desc= "TABLE TICKET">
558 public static final String TICKET_AUTO_ID = "_id";
559 public static final String TICKET_DISPATCH_ID = "dispatch_id";
560 public static final String TICKET_ROUTE_ID = "route_id";
561 public static final String TICKET_GENERATED_ID = "generated_id";
562 public static final String TICKET_OR_NO = "or_no";
563 public static final String TICKET_NO = "ticket_no";
564 public static final String TICKET_CONTROL_NO = "control_no";
565 public static final String TICKET_TRIP_NO = "trip_no";
566 public static final String TICKET_VEHICLE_ID = "vehicle_id";
567 public static final String TICKET_VEHICLE_NO = "vehicle_no";
568 public static final String TICKET_PLACE_FROM = "place_from";
569 public static final String TICKET_PLACE_TO = "place_to";
570 public static final String TICKET_KM_FROM = "km_from";
571 public static final String TICKET_KM_TO = "km_to";
572 public static final String TICKET_AMOUNT = "amount";
573 public static final String TICKET_PASSENGER_TYPE = "passenger_type";
574 public static final String TICKET_PASSENGER_CODE = "passenger_code";
575 public static final String TICKET_LONG = "long";
576 public static final String TICKET_LAT = "lat";
577 public static final String TICKET_TRANSACTION_TYPE = "transaction_type";
578 public static final String TICKET_DEVICE_SERIAL = "device_serial";
579 public static final String TICKET_DATETIMESTAMP = "datetimestamp";
580 public static final String TICKET_PREVIOUS_BALANCE = "previous_balance";
581 public static final String TICKET_CURRENT_BALANCE = "current_balance";
582 public static final String TICKET_CARD_NO = "card_no";
583 public static final String TICKET_STATUS = "status";
584 public static final String TICKET_IS_SEND = "is_send";
585 //</editor-fold>
586
587 //<editor-fold desc="TABLE EXPENSE">
588 public static final String EXPENSE_AUTO_ID = "_id";
589 public static final String EXPENSE_REMITTANCE_ID = "remittance_id";
590 public static final String EXPENSE_GENERATED_ID = "generated_id";
591 public static final String EXPENSE_CONTROL_NO = "control_no";
592 public static final String EXPENSE_TRIP_NO = "trip_no";
593 public static final String EXPENSE_NAME = "expense_name";
594 public static final String EXPENSE_AMOUNT = "amount";
595 public static final String EXPENSE_EMP_ID = "emp_id";
596 public static final String EXPENSE_EMP_NAME = "exp_name";
597 public static final String EXPENSE_LONG = "long";
598 public static final String EXPENSE_LAT = "lat";
599 public static final String EXPENSE_DATETIMESTAMP = "datetimestamp";
600 //</editor-fold>
601
602 //<editor-fold desc="TABLE FUEL_LOAD">
603 public static final String FUEL_LOAD_AUTO_ID = "_id";
604 public static final String FUEL_LOAD_REMITTANCE_ID = "remittance_id";
605 public static final String FUEL_LOAD_GENERATED_ID = "generated_id";
606 public static final String FUEL_LOAD_CONTROL_NO = "control_no";
607 public static final String FUEL_LOAD_TRIP_NO = "trip_no";
608 public static final String FUEL_LOAD_DRIVER_ID = "driver_id";
609 public static final String FUEL_LOAD_DRIVER_NAME = "driver_name";
610 public static final String FUEL_LOAD_CONDUCTOR_ID = "conductor_id";
611 public static final String FUEL_LOAD_CONDUCTOR_NAME = "conductor_name";
612 public static final String FUEL_LOAD_EMP_ID = "emp_id";
613 public static final String FUEL_LOAD_EMP_NAME = "emp_name";
614 public static final String FUEL_LOAD_LITERS = "liters";
615 public static final String FUEL_LOAD_LONG = "long";
616 public static final String FUEL_LOAD_LAT = "lat";
617 public static final String FUEL_LOAD_DATETIMESTAMP = "datetimestamp";
618 //</editor-fold>
619
620 //<editor-fold desc = "TABLE LOGS">
621 public static final String DEVICE_LOGS_ID = "_id";
622 public static final String DEVICE_LOGS_EOD_ID = "eod_id";
623 public static final String DEVICE_LOGS_GENEARTED_ID = "generated_id";
624 public static final String DEVICE_LOGS_CONTROL_NO = "control_no";
625 public static final String DEVICE_LOGS_TRIP_NO = "trip_no";
626 public static final String DEVICE_LOGS_EMPLOYEE_ID = "employee_id";
627 public static final String DEVICE_LOGS_MODULE = "module";
628 public static final String DEVICE_LOGS_ACTION = "action_taken";
629 public static final String DEVICE_LOGS_LONG = "long";
630 public static final String DEVICE_LOGS_LAT = "lat";
631 public static final String DEVICE_LOGS_DATETIME = "datetimestamp";
632 public static final String DEVICE_LOGS_IS_SEND = "is_send";
633 //</editor-fold>
634
635 //<editor-fold desc = "CREATE FUEL LOAD QUERY">
636 private static final String CREATE_FUEL_LOAD = "CREATE TABLE IF NOT EXISTS " + FUEL_LOAD + "("
637 + FUEL_LOAD_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
638 + FUEL_LOAD_REMITTANCE_ID + " VARCHAR,"
639 + FUEL_LOAD_GENERATED_ID + " VARCHAR,"
640 + FUEL_LOAD_CONTROL_NO + " VARCHAR,"
641 + FUEL_LOAD_TRIP_NO + " VARCHAR,"
642 + FUEL_LOAD_DRIVER_ID + " VARCHAR,"
643 + FUEL_LOAD_DRIVER_NAME + " VARCHAR,"
644 + FUEL_LOAD_CONDUCTOR_ID + " VARCHAR,"
645 + FUEL_LOAD_CONDUCTOR_NAME + " VARCHAR,"
646 + FUEL_LOAD_EMP_ID + " VARCHAR,"
647 + FUEL_LOAD_EMP_NAME + " VARCHAR,"
648 + FUEL_LOAD_LITERS + " VARCHAR,"
649 + FUEL_LOAD_LONG + " VARCHAR,"
650 + FUEL_LOAD_LAT + " VARCHAR,"
651 + FUEL_LOAD_DATETIMESTAMP + " VARCHAR)";
652 //</editor-fold>
653
654 //<editor-fold desc = "CREATE EXPENSE QUERY">
655 private static final String CREATE_EXPENSE = "CREATE TABLE IF NOT EXISTS " + EXPENSE + "("
656 + EXPENSE_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
657 + EXPENSE_REMITTANCE_ID + " VARCHAR,"
658 + EXPENSE_GENERATED_ID + " VARCHAR,"
659 + EXPENSE_CONTROL_NO + " VARCHAR,"
660 + EXPENSE_TRIP_NO + " VARCHAR,"
661 + EXPENSE_NAME + " VARCHAR,"
662 + EXPENSE_AMOUNT + " VARCHAR,"
663 + EXPENSE_EMP_ID + " VARCHAR,"
664 + EXPENSE_EMP_NAME + " VARCHAR,"
665 + EXPENSE_LONG + " VARCHAR,"
666 + EXPENSE_LAT + " VARCHAR,"
667 + EXPENSE_DATETIMESTAMP + " VARCHAR)";
668 //</editor-fold>
669
670 //<editor-fold desc = "CREATE REMITTANCE_INPUT QUERY">
671 private static final String CREATE_REMITTANCE_INPUT = "CREATE TABLE IF NOT EXISTS " + REMITTANCE_INPUT + "("
672 + REMITTANCE_INPUT_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
673 + REMITTANCE_INPUT_REMITTANCE_ID + " VARCHAR,"
674 + REMITTANCE_INPUT_GENERATED_REMITTANCE_ID + " VARCHAR,"
675 + REMITTANCE_INPUT_CONTROL_NO + " VARCHAR,"
676 + REMITTANCE_INPUT_DEVICE_REVENUE + " VARCHAR,"
677 + REMITTANCE_INPUT_GROSS_COLLECTION + " VARCHAR,"
678 + REMITTANCE_INPUT_REFUND_AMOUNT + " VARCHAR,"
679 + REMITTANCE_INPUT_TRANSFER_AMOUNT + " VARCHAR,"
680 + REMITTANCE_INPUT_RECEIVED_AMOUNT + " VARCHAR,"
681 + REMITTANCE_INPUT_MANUAL_AMOUNT + " VARCHAR,"
682 + REMITTANCE_INPUT_GROSS_COMM_DRIVER + " VARCHAR,"
683 + REMITTANCE_INPUT_GROSS_COMM_CONDUCTOR + " VARCHAR,"
684 + REMITTANCE_INPUT_SCHEME_DRIVER + " VARCHAR,"
685 + REMITTANCE_INPUT_SCHEME_CONDUCTOR + " VARCHAR,"
686 + REMITTANCE_INPUT_SP_COMM_DRIVER + " VARCHAR,"
687 + REMITTANCE_INPUT_SP_COMM_CONDUCTOR + " VARCHAR,"
688 + REMITTANCE_INPUT_TAKE_HOME_DRIVER + " VARCHAR,"
689 + REMITTANCE_INPUT_TAKE_HOME_CONDUCTOR + " VARCHAR,"
690 + REMITTANCE_INPUT_TOTAL_TAKE_HOME + " VARCHAR,"
691 + REMITTANCE_INPUT_EXPENSE_TOLL_FEE + " VARCHAR,"
692 + REMITTANCE_INPUT_EXPENSE_TOWING + " VARCHAR,"
693 + REMITTANCE_INPUT_EXPENSE_PARKING + " VARCHAR,"
694 + REMITTANCE_INPUT_EXPENSE_INSURANCE + " VARCHAR,"
695 + REMITTANCE_INPUT_EXPENSE_VULCANIZE + " VARCHAR,"
696 + REMITTANCE_INPUT_EXPENSE_REPRESENTATION + " VARCHAR,"
697 + REMITTANCE_INPUT_EXPENSE_LUBRICANT + " VARCHAR,"
698 + REMITTANCE_INPUT_EXPENSE_REPAIR_MAINT + " VARCHAR,"
699 + REMITTANCE_INPUT_EXPENSE_DIESEL + " VARCHAR,"
700 + REMITTANCE_INPUT_EXPENSE_SUB_TOTAL + " VARCHAR,"
701 + REMITTANCE_INPUT_EXPENSE_NON_CASH_PARKING + " VARCHAR,"
702 + REMITTANCE_INPUT_EXPENSE_NON_CASH_TOLL_FEE + " VARCHAR,"
703 + REMITTANCE_INPUT_EXPENSE_NON_CASH_SUB_TOTAL + " VARCHAR,"
704 + REMITTANCE_INPUT_EXPENSE_OUTSIDE_AMOUNT + " VARCHAR,"
705 + REMITTANCE_INPUT_EXPENSE_OUTSIDE_LITERS + " VARCHAR,"
706 + REMITTANCE_INPUT_EXPENSE_INHOUSE_LITERS + " VARCHAR,"
707 + REMITTANCE_INPUT_EXPENSE_TOTAL_CONSUMPTION_LITERS + " VARCHAR,"
708 + REMITTANCE_INPUT_EXPENSE_TOTAL_CONSUMPTION_AMOUNT + " VARCHAR,"
709 + REMITTANCE_INPUT_EXPENSE_DAMAGE_AMOUNT + " VARCHAR,"
710 + REMITTANCE_INPUT_EXPENSE_PARTIAL_AMOUNT + " VARCHAR,"
711 + REMITTANCE_INPUT_EXPENSE_PAYMENT_DRIVER + " VARCHAR,"
712 + REMITTANCE_INPUT_EXPENSE_PAYMENT_CONUCTOR + " VARCHAR,"
713 + REMITTANCE_INPUT_EXPENSE_VALE_DRIVER + " VARCHAR,"
714 + REMITTANCE_INPUT_EXPENSE_VALE_CONDUCTOR + " VARCHAR,"
715 + REMITTANCE_INPUT_EXPENSE_BAGGAGE_AMOUNT + " VARCHAR,"
716 + REMITTANCE_INPUT_EXPENSE_SP_TRIP_AMOUNT + " VARCHAR,"
717 + REMITTANCE_INPUT_EXPENSE_FERRY_AMOUNT + " VARCHAR,"
718 + REMITTANCE_INPUT_EXPENSE_TALAO_AMOUNT + " VARCHAR,"
719 + REMITTANCE_INPUT_EXPENSE_TWO_GO_AMOUNT + " VARCHAR,"
720 + REMITTANCE_INPUT_EXPENSE_OTHER_INCOME_SUB_TOTAL + " VARCHAR,"
721 + REMITTANCE_INPUT_EXPENSE_NET_REMITTANCE + " VARCHAR,"
722 + REMITTANCE_INPUT_EXPENSE_SHORT_OVER + " VARCHAR,"
723 + REMITTANCE_INPUT_EXPENSE_CASH_RECEIVED + " VARCHAR)";
724 //</editor-fold>
725
726
727 //<editor-fold desc = "CREATE MANUAL TABLE">
728 private static final String CREATE_MANUAL = "CREATE TABLE IF NOT EXISTS " + MANUAL + "("
729 + MANUAL_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
730 + MANUAL_REMITTANCE_ID + " VARCHAR,"
731 + MANUAL_DISPATCH_ID + " VARCHAR,"
732 + MANUAL_GENERATED_ID + " VARCHAR,"
733 + MANUAL_CONTROL_NO + " VARCHAR,"
734 + MANUAL_TRIP_NO + " VARCHAR,"
735 + MANUAL_M_CONTROL_NO + " VARCHAR,"
736 + MANUAL_NO_OF_TICKETS + " VARCHAR,"
737 + MANUAL_AMOUNT + " VARCHAR,"
738 + MANUAL_TYPE + " VARCHAR,"
739 + MANUAL_EMP_ID + " VARCHAR,"
740 + MANUAL_EMP_NAME + " VARCHAR,"
741 + MANUAL_LONG + " VARCHAR,"
742 + MANUAL_LAT + " VARCHAR,"
743 + MANUAL_DATETIMESTAMP + " VARCHAR)";
744 //</editor-fold>
745
746 //<editor-fold desc = "CREATE PARTIAL TABLE">
747 private static final String CREATE_PARTIAL = "CREATE TABLE IF NOT EXISTS " + PARTIAL + "("
748 + PARTIAL_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
749 + PARTIAL_REMITTANCE_ID + " VARCHAR,"
750 + PARTIAL_DISPATCH_ID + " VARCHAR,"
751 + PARTIAL_ROUTE_ID + " VARCHAR,"
752 + PARTIAL_GENERATED_ID + " VARCHAR,"
753 + PARTIAL_CONTROL_NO + " VARCHAR,"
754 + PARTIAL_TRIP_NO + " VARCHAR,"
755 + PARTIAL_TERMINAL_ID + " VARCHAR,"
756 + PARTIAL_TERMINAL_NAME + " VARCHAR,"
757 + PARTIAL_AMOUNT + " VARCHAR,"
758 + PARTIAL_REMARKS + " VARCHAR,"
759 + PARTIAL_EMP_ID + " VARCHAR,"
760 + PARTIAL_EMP_NAME + " VARCHAR,"
761 + PARTIAL_LONG + " VARCHAR,"
762 + PARTIAL_LAT + " VARCHAR,"
763 + PARTIAL_DATETIMESTAMP + " VARCHAR)";
764 //</editor-fold>
765
766 //<editor-fold desc = "CREATE VIOLATION TABLE">
767 private static final String CREATE_VIOLATION = "CREATE TABLE IF NOT EXISTS " + VIOLATION + "("
768 + VIOLATION_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
769 + VIOLATION_DISPATCH_ID + " VARCHAR,"
770 + VIOLATION_ROUTE_ID + " VARCHAR,"
771 + VIOLATION_GENERATED_ID + " VARCHAR,"
772 + VIOLATION_CONTROL_NO + " VARCHAR,"
773 + VIOLATION_TRIP_NO + " VARCHAR,"
774 + VIOLATION_GIVEN_BY + " VARCHAR,"
775 + VIOLATION_VIOLATION + " VARCHAR,"
776 + VIOLATION_EMP_ID + " VARCHAR,"
777 + VIOLATION_EMP_NAME + " VARCHAR,"
778 + VIOLATION_LONG + " VARCHAR,"
779 + VIOLATION_LAT + " VARCHAR,"
780 + VIOLATION_IS_ACCEPTED + " VARCHAR,"
781 + VIOLATION_DATETIMESTAMP + " VARCHAR)";
782 //</editor-fold>
783
784 //<editor-fold desc = "CREATE TRANSFER TABLE">
785 private static final String CREATE_TRANSFER = "CREATE TABLE IF NOT EXISTS " + TRANSFER + "("
786 + TRANSFER_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
787 + TRANSFER_DISPATCH_ID + " VARCHAR,"
788 + TRANSFER_ROUTE_ID + " VARCHAR,"
789 + TRANSFER_GENERATED_ID + " VARCHAR,"
790 + TRANSFER_CONTROL_NO + " VARCHAR,"
791 + TRANSFER_TRIP_NO + " VARCHAR,"
792 + TRANSFER_TICKET_NO + " VARCHAR,"
793 + TRANSFER_AMOUNT + " VARCHAR,"
794 + TRANSFER_KM_FROM + " VARCHAR,"
795 + TRANSFER_KM_TO + " VARCHAR,"
796 + TRANSFER_TICKET_DATETIME + " VARCHAR,"
797 + TRANSFER_EMP_ID + " VARCHAR,"
798 + TRANSFER_EMP_NAME + " VARCHAR,"
799 + TRANSFER_STATUS + " VARCHAR,"
800 + TRANSFER_PASSENGER_TYPE + " VARCHAR,"
801 + TRANSFER_LONG + " VARCHAR,"
802 + TRANSFER_LAT + " VARCHAR,"
803 + TRANSFER_DATEIMESTAMP + " VARCHAR)";
804//</editor-fold>
805
806 //<editor-fold desc = "CREATE RECEIVE TABLE">
807 private static final String CREATE_RECEIVE = "CREATE TABLE IF NOT EXISTS " + RECEIVE + "("
808 + RECEIVE_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
809 + RECEIVE_DISPATCH_ID + " VARCHAR,"
810 + RECEIVE_ROUTE_ID + " VARCHAR,"
811 + RECEIVE_GENERATED_ID + " VARCHAR,"
812 + RECEIVE_CONTROL_NO + " VARCHAR,"
813 + RECEIVE_TRIP_NO + " VARCHAR,"
814 + RECEIVE_PASSENGER_COUNT + " VARCHAR,"
815 + RECEIVE_TOTAL_AMOUNT + " VARCHAR,"
816 + RECEIVE_INCOME_TYPE + " VARCHAR,"
817 + RECEIVE_EMP_ID + " VARCHAR,"
818 + RECEIVE_EMP_NAME + " VARCHAR,"
819 + RECEIVE_LONG + " VARCHAR,"
820 + RECEIVE_LAT + " VARCHAR,"
821 + RECEIVE_DATETIMESTAMP + " VARCHAR)";
822 //</editor-fold>
823
824 //<editor-fold desc = "CREATE REFUND TABLE">
825 private static final String CREATE_REFUND = "CREATE TABLE IF NOT EXISTS " + REFUND + "("
826 + REFUND_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
827 + REFUND_DISPATCH_ID + " VARCHAR,"
828 + REFUND_ROUTE_ID + " VARCHAR,"
829 + REFUND_GENERATED_ID + " VARCHAR,"
830 + REFUND_CONTROL_NO + " VARCHAR,"
831 + REFUND_TRIP_NO + " VARCHAR,"
832 + REFUND_TICKET_NO + " VARCHAR,"
833 + REFUND_PLACE_FROM + " VARCHAR,"
834 + REFUND_PLACE_TO + " VARCHAR,"
835 + REFUND_TICKET_DATETIME + " VARCHAR,"
836 + REFUND_AMOUNT + " VARCHAR,"
837 + REFUND_PASSENGER_TYPE + " VARCHAR,"
838 + REFUND_PASSENGER_CODE + " VARCHAR,"
839 + REFUND_LONG + " VARCHAR,"
840 + REFUND_LAT + " VARCHAR,"
841 + REFUND_CONDUCTOR_ID + " VARCHAR,"
842 + REFUND_CONDUCTOR_NAME + " VARCHAR,"
843 + REFUND_EMP_ID + " VARCHAR,"
844 + REFUND_EMP_NAME + " VARCHAR,"
845 + REFUND_DATETIMESTAMP + " VARCHAR)";
846//</editor-fold>
847
848 //<editor-fold desc="CREATE TABLE SPECIAL TRIP TABLE">
849 private static final String CREATE_SPECIAL_TRIP = "CREATE TABLE IF NOT EXISTS " + SPECIAL_TRIP + "("
850 + SPECIAL_TRIP_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
851 + SPECIAL_TRIP_COMPANY_ID + " VARCHAR,"
852 + SPECIAL_TRIP_SUBCOMPANY_ID + " VARCHAR,"
853 + SPECIAL_TRIP_GENERATED_ID + " VARCHAR,"
854 + SPECIAL_TRIP_REMITTANCE_ID + " VARCHAR,"
855 + SPECIAL_TRIP_DISPATCH_ID + " VARCHAR,"
856 + SPECIAL_TRIP_VEHICLE_ID + " VARCHAR,"
857 + SPECIAL_TRIP_VEHICLE_NO + " VARCHAR,"
858 + SPECIAL_TRIP_PLATE_NO + " VARCHAR,"
859 + SPECIAL_TRIP_ROUTE_ID + " VARCHAR,"
860 + SPECIAL_TRIP_ROUTE_NAME + " VARCHAR,"
861 + SPECIAL_TRIP_ROUTE_CODE + " VARCHAR,"
862 + SPECIAL_TRIP_ORIGIN + " VARCHAR,"
863 + SPECIAL_TRIP_DESTINATION + " VARCHAR,"
864 + SPECIAL_TRIP_CONTROL_NO + " VARCHAR,"
865 + SPECIAL_TRIP_TRIP_NO + " VARCHAR,"
866 + SPECIAL_TRIP_NO_OF_TRIPS + " VARCHAR,"
867 + SPECIAL_TRIP_ACCOUNT_NAME + " VARCHAR,"
868 + SPECIAL_TRIP_DATETIME_RELEASE + " VARCHAR,"
869 + SPECIAL_TRIP_DATETIME_RETURN + " VARCHAR,"
870 + SPECIAL_TRIP_KMRUN + " VARCHAR,"
871 + SPECIAL_TRIP_RUNNING_TIME + " VARCHAR,"
872 + SPECIAL_TRIP_DISPATCHER_ID + " VARCHAR,"
873 + SPECIAL_TRIP_CONDUCTOR_ID + " VARCHAR,"
874 + SPECIAL_TRIP_DRIVER_ID + " VARCHAR,"
875 + SPECIAL_TRIP_DRIVER2_ID + " VARCHAR,"
876 + SPECIAL_TRIP_TYPE + " VARCHAR,"
877 + SPECIAL_TRIP_LONG + " VARCHAR,"
878 + SPECIAL_TRIP_LAT + " VARCHAR,"
879 + SPECIAL_TRIP_DATETIMESTAMP + " VARCHAR)";
880 //</editor-fold
881
882 //<editor-fold desc = "CREATE INSPECTION TABLE">
883 private static final String CREATE_INSPECTION = "CREATE TABLE IF NOT EXISTS " + INSPECTION + "("
884 + INSPECTION_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
885 + INSPECTION_DISPATCH_ID + " VARCHAR,"
886 + INSPECTION_ROUTE_ID + " VARCHAR,"
887 + INSPECTION_GENERATED_ID + " VARCHAR,"
888 + INSPECTION_CONTROL_NO + " VARCHAR,"
889 + INSPECTION_TRIP_NO + " VARCHAR,"
890 + INSPECTION_TIME_ON + " VARCHAR,"
891 + INSPECTION_TIME_OFF + " VARCHAR,"
892 + INSPECTION_PLACE_ON + " VARCHAR,"
893 + INSPECTION_POSITION + " VARCHAR,"
894 + INSPECTION_EMP_ID + " VARCHAR,"
895 + INSPECTION_EMP_COMP_ID + " VARCHAR,"
896 + INSPECTION_EMP_NAME + " VARCHAR,"
897 + INSPECTION_PASSENGER_COUNT + " VARCHAR,"
898 + INSPECTION_HEAD_COUNT + " VARCHAR,"
899 + INSPECTION_BAGGAGE_COUNT + " VARCHAR,"
900 + INSPECTION_KMRUN + " VARCHAR,"
901 + INSPECTION_REMARKS + " VARCHAR,"
902 + INSPECTION_LONG + " VARCHAR,"
903 + INSPECTION_LAT + " VARCHAR,"
904 + INSPECTION_DATETIMESTAMP + " VARCHAR)";
905 //</editor-fold>
906
907 //<editor-fold desc = "CREATE REMITTANCE TABLE">
908 private static final String CREATE_REMITTANCE = "CREATE TABLE IF NOT EXISTS " + REMITTANCE + "("
909 + REMITTANCE_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
910 + REMITTANCE_COMPANY_ID + " VARCHAR,"
911 + REMITTANCE_SUBCOMPANY_ID + " VARCHAR,"
912 + REMITTANCE_ID + " VARCHAR,"
913 + REMITTANCE_VEHICLE_ID + " VARCHAR,"
914 + REMITTANCE_CONTROL_NO + " VARCHAR,"
915 + REMITTANCE_DRIVER_ID + " VARCHAR,"
916 + REMITTANCE_DRIVER_NAME + " VARCHAR,"
917 + REMITTANCE_CONDUCTOR_ID + " VARCHAR,"
918 + REMITTANCE_CONDUCTOR_NAME + " VARCHAR,"
919 + REMITTANCE_CASHIER_ID + " VARCHAR,"
920 + REMITTANCE_CASHIER_NAME + " VARCHAR,"
921 + REMITTANCE_TOTAL_TRANSFERED_AMOUNT + " VARCHAR,"
922 + REMITTANCE_TOTAL_RECEIVED_AMOUNT + " VARCHAR,"
923 + REMITTANCE_TOTAL_REFUNDED_AMOUNT + " VARCHAR,"
924 + REMITTANCE_TICKET_GROSS + " VARCHAR,"
925 + REMITTANCE_TICKET_COUNT + " VARCHAR,"
926 + REMITTANCE_TOTAL_BAGGAGE_GROSS + " VARCHAR,"
927 + REMITTANCE_TOTAL_PASSES_AMOUNT + " VARCHAR,"
928 + REMITTANCE_TOTAL_PARTIAL + " VARCHAR,"
929 + REMITTANCE_TOTAL_EXPENSE + " VARCHAR,"
930 + REMITTANCE_TOTAL_FUEL_LITERS + " VARCHAR,"
931 + REMITTANCE_DATETIMESTAMP + " VARCHAR,"
932 + REMITTANCE_IS_SEND + " VARCHAR)";
933 //</editor-fold>
934
935 //<editor-fold desc = "CREATE TICKETS TABLE">
936 private static final String CREATE_TICKETS = "CREATE TABLE IF NOT EXISTS " + TICKETS + "("
937 + TICKET_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
938 + TICKET_DISPATCH_ID + " VARCHAR,"
939 + TICKET_ROUTE_ID + " VARCHAR,"
940 + TICKET_GENERATED_ID + " VARCHAR,"
941 + TICKET_OR_NO + " VARCHAR,"
942 + TICKET_NO + " VARCHAR,"
943 + TICKET_CONTROL_NO + " VARCHAR,"
944 + TICKET_TRIP_NO + " VARCHAR,"
945 + TICKET_VEHICLE_ID + " VARCHAR,"
946 + TICKET_VEHICLE_NO + " VARCHAR,"
947 + TICKET_PLACE_FROM + " VARCHAR,"
948 + TICKET_PLACE_TO + " VARCHAR,"
949 + TICKET_KM_FROM + " VARCHAR,"
950 + TICKET_KM_TO + " VARCHAR,"
951 + TICKET_AMOUNT + " VARCHAR,"
952 + TICKET_PASSENGER_TYPE + " VARCHAR,"
953 + TICKET_PASSENGER_CODE + " VARCHAR,"
954 + TICKET_LONG + " VARCHAR,"
955 + TICKET_LAT + " VARCHAR,"
956 + TICKET_TRANSACTION_TYPE + " VARCHAR,"
957 + TICKET_DEVICE_SERIAL + " VARCHAR,"
958 + TICKET_DATETIMESTAMP + " VARCHAR,"
959 + TICKET_PREVIOUS_BALANCE + " VARCHAR,"
960 + TICKET_CURRENT_BALANCE + " VARCHAR,"
961 + TICKET_CARD_NO + " VARCHAR,"
962 + TICKET_STATUS + " VARCHAR,"
963 + TICKET_IS_SEND + " VARCHAR)";
964 //</editor-fold>
965
966 //<editor-fold desc = "CREATE DEVICE SETTINGS TABLE">
967 private static final String CREATE_DEVICE_SETTINGS = "CREATE TABLE IF NOT EXISTS " + DEVICE_SETTINGS + "("
968 + DEVICE_SETTINGS_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
969 + DEVICE_SETTINGS_CONTROL_NO + " VARCHAR,"
970 + DEVICE_SETTINGS_TRIP_NO + " VARCHAR,"
971 + DEVICE_SETTINGS_TRANSACTION_NO + " VARCHAR)";
972 //</editor-fold>
973
974 //<editor-fold desc = "CREATE ARRIVAL TABLE">
975 private static final String CREATE_ARRIVAL = "CREATE TABLE IF NOT EXISTS " + ARRIVAL + "("
976 + ARRIVAL_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
977 + ARRIVAL_REMITTANCE_ID + " VARCHAR,"
978 + ARRIVAL_DISPATCH_ID + " VARCHAR,"
979 + ARRIVAL_GENERATED_ID + " VARCHAR,"
980 + ARRIVAL_CONTROL_NO + " VARCHAR,"
981 + ARRIVAL_TRIP_NO + " VARCHAR,"
982 + ARRIVAL_VEHICLE_NO + " VARCHAR,"
983 + ARRIVAL_VEHICLE_PLATE_NO + " VARCHAR,"
984 + ARRIVAL_DRIVER_ID + " VARCHAR,"
985 + ARRIVAL_DRIVER_EMP_ID + " VARCHAR,"
986 + ARRIVAL_DRIVER_NAME + " VARCHAR,"
987 + ARRIVAL_CONDUCTOR_ID + " VARCHAR,"
988 + ARRIVAL_CONDUCTOR_EMP_ID + " VARCHAR,"
989 + ARRIVAL_CONDUCTOR_NAME + " VARCHAR,"
990 + ARRIVAL_DISPATCHER_ID + " VARCHAR,"
991 + ARRIVAL_DISPATCHER_EMP_ID + " VARCHAR,"
992 + ARRIVAL_DISPATCHER_NAME + " VARCHAR,"
993 + ARRIVAL_BACKUP_DRIVER_ID + " VARCHAR,"
994 + ARRIVAL_BACKUP_DRIVER_NAME + " VARCHAR,"
995 + ARRIVAL_ROUTE_ID + " VARCHAR,"
996 + ARRIVAL_ROUTE_NAME + " VARCHAR,"
997 + ARRIVAL_ROUTE_BOUND + " VARCHAR,"
998 + ARRIVAL_ROUTE_CODE + " VARCHAR,"
999 + ARRIVAL_OPENING_TICKET + " VARCHAR,"
1000 + ARRIVAL_CLOSING_TICKET + " VARCHAR,"
1001 + ARRIVAL_PASSENGER_COUNT + " VARCHAR,"
1002 + ARRIVAL_BAGGAGE_COUNT + " VARCHAR,"
1003 + ARRIVAL_PASSENGER_GROSS + " VARCHAR,"
1004 + ARRIVAL_BAGGAGE_GROSS + " VARCHAR,"
1005 + ARRIVAL_REFUND_GROSS + " VARCHAR,"
1006 + ARRIVAL_TRANSFER_GROSS + " VARCHAR,"
1007 + ARRIVAL_RECEIVED_GROSS + " VARCHAR,"
1008 + ARRIVAL_LONG + " VARCHAR,"
1009 + ARRIVAL_LAT + " VARCHAR,"
1010 + ARRIVAL_KMRUN + " VARCHAR,"
1011 + ARRIVAL_RUNNING_TIME + " VARCHAR,"
1012 + ARRIVAL_COUNT_REGULAR + " VARCHAR,"
1013 + ARRIVAL_COUNT_STUDENT + " VARCHAR,"
1014 + ARRIVAL_COUNT_SENIOR + " VARCHAR,"
1015 + ARRIVAL_COUNT_PWD + " VARCHAR,"
1016 + ARRIVAL_COUNT_PREPAID + " VARCHAR,"
1017 + ARRIVAL_COUNT_PASSES + " VARCHAR,"
1018 + ARRIVAL_DISPATCHED_TIME + " VARCHAR,"
1019 + ARRIVAL_TIME + " VARCHAR,"
1020 + ARRIVAL_DATETIMESTAMP + " VARCHAR,"
1021 + ARRIVAL_IS_SEND + " VARCHAR)";
1022 //</editor-fold>
1023
1024 //<editor-fold desc = "CREATE DISPATCHING TABLE">
1025 private static final String CREATE_DISPATCHING = "CREATE TABLE IF NOT EXISTS " + DISPATCHING + "("
1026 + DISPATCHING_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1027 + DISPATCHING_ID + " VARCHAR,"
1028 + DISPATCHING_REMITTANCE_ID + " VARCHAR,"
1029 + DISPATCHING_CONTROL_NO + " VARCHAR,"
1030 + DISPATCHING_TRIP_NO + " VARCHAR,"
1031 + DISPATCHING_VEHICLE_NO + " VARCHAR,"
1032 + DISPATCHING_VEHICLE_PLATE_NO + " VARCHAR,"
1033 + DISPATCHING_ROUTE_ID + " VARCHAR,"
1034 + DISPATCHING_ROUTE_NAME + " VARCHAR,"
1035 + DISPATCHING_ROUTE_CODE + " VARCHAR,"
1036 + DISPATCHING_ROUTE_BOUND + " VARCHAR,"
1037 + DISPATCHING_DRIVER_ID + " VARCHAR,"
1038 + DISPATCHING_DRIVER_NAME + " VARCHAR,"
1039 + DISPATCHING_CONDUCTOR_ID + " VARCHAR,"
1040 + DISPATCHING_CONDUCTOR_NAME + " VARCHAR,"
1041 + DISPATCHING_DISPATCHER_ID + " VARCHAR,"
1042 + DISPATCHING_DISPATCHER_NAME + " VARCHAR,"
1043 + DISPATCHING_TRIP_TYPE + " VARCHAR,"
1044 + DISPATCHING_PASSENGER_COUNT + " VARCHAR,"
1045 + DISPATCHING_OPENING_TICKET + " VARCHAR,"
1046 + DISPATCHING_BACKUP_DRIVER_ID + " VARCHAR,"
1047 + DISPATCHING_BACKUP_DRIVER_NAME + " VARCHAR,"
1048 + DISPATCHING_KM_RUN + " VARCHAR,"
1049 + DISPATCHING_HOUR + " VARCHAR,"
1050 + DISPATCHING_LONG + " VARCHAR,"
1051 + DISPATCHING_LAT + " VARCHAR,"
1052 + DISPATCHING_DATETIMESTAMP + " VARCHAR,"
1053 + DISPATCHING_IS_SEND + " VARCHAR)";
1054 //</editor-fold>
1055
1056 //<editor-fold desc = "CREATE SETTINGS TABLE">
1057 private static final String CREATE_SETTINGS = "CREATE TABLE IF NOT EXISTS " + SETTINGS + "("
1058 + SETTINGS_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1059 + SETTINGS_REMITTANCE_ID + " VARCHAR,"
1060 + SETTINGS_DISPATCH_ID + " VARCHAR,"
1061 + SETTINGS_CONTROL_NO + " VARCHAR,"
1062 + SETTINGS_TRIP_NO + " VARCHAR,"
1063 + SETTINGS_VEHICLE_ID + " VARCHAR,"
1064 + SETTINGS_VEHICLE_NO + " VARCHAR,"
1065 + SETTINGS_PLATE_NO + " VARCHAR,"
1066 + SETTINGS_IS_DISPATCHED + " VARCHAR,"
1067 + SETTINGS_IS_ARRIVED + " VARCHAR,"
1068 + SETTINGS_IS_CLOSED + " VARCHAR,"
1069 + SETTINGS_IS_SYNCED + " VARCHAR,"
1070 + SETTINGS_DRIVER_ID + " VARCHAR,"
1071 + SETTINGS_DRIVER_CARD_ID + " VARCHAR,"
1072 + SETTINGS_DRIVER_NAME + " VARCHAR,"
1073 + SETTINGS_DRIVER_EMP_ID + " VARCHAR,"
1074 + SETTINGS_CONDUCTOR_ID + " VARCHAR,"
1075 + SETTINGS_CONDUCTOR_CARD_ID + " VARCHAR,"
1076 + SETTINGS_CONDUCTOR_NAME + " VARCHAR,"
1077 + SETTINGS_CONDUCTOR_EMP_ID + " VARCHAR,"
1078 + SETTINGS_DISPATCHER_ID + " VARCHAR,"
1079 + SETTINGS_DISPATCHER_NAME + " VARCHAR,"
1080 + SETTINGS_ROUTE_ID + " VARCHAR,"
1081 + SETTINGS_ROUTE_NAME + " VARCHAR,"
1082 + SETTINGS_ROUTE_CODE + " VARCHAR,"
1083 + SETTINGS_ROUTE_BOUND + " VARCHAR,"
1084 + SETTINGS_TRIP_TYPE + " VARCHAR,"
1085 + SETTINGS_SOFTWARE_SERIAL_NO + " VARCHAR,"
1086 + SETTINGS_TICKETING_KMPOST + " VARCHAR,"
1087 + SETTINGS_INSPECTION_KMPOST + " VARCHAR,"
1088 + SETTINGS_KMRUN + " VARCHAR,"
1089 + SETTINGS_RUNNING_TIME + " VARCHAR,"
1090 + SETTINGS_DISPATCHED_DATE + " VARCHAR,"
1091 + SETTINGS_DISPATCHED_TIME + " VARCHAR,"
1092 + SETTINGS_LAST_TICKET_NO + " VARCHAR)";
1093 //</editor-fold>
1094
1095 //<editor-fold desc = "CREATE STATIONS TABLE">
1096 private static final String CREATE_KMPOSTS = "CREATE TABLE IF NOT EXISTS " + KMPOSTS + "("
1097 + KMPOST_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1098 + KMPOST_ID + " VARCHAR,"
1099 + KMPOST_ROUTE_NAME + " VARCHAR,"
1100 + KMPOST_NAME + " VARCHAR,"
1101 + KMPOST_POST + " VARCHAR,"
1102 + KMPOST_PRICE + " VARCHAR,"
1103 + KMPOST_DISC_PRICE + " VARCHAR,"
1104 + KMPOST_PRICE2 + " VARCHAR,"
1105 + KMPOST_DISC_PRICE2 + " VARCHAR,"
1106 + KMPOST_PRICE3 + " VARCHAR,"
1107 + KMPOST_DISC_PRICE3 + " VARCHAR,"
1108 + KMPOST_SPECIAL_FARE + " VARCHAR,"
1109 + KMPOST_SPECIAL_FARE_DISC + " VARCHAR)";
1110 //</editor-fold>
1111
1112 //<editor-fold desc = "CREATE MANUAL_TYPES TABLE">
1113 private static final String CREATE_MANUAL_TYPES = "CREATE TABLE IF NOT EXISTS " + MANUAL_TYPES + "("
1114 + MANUAL_TYPE_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1115 + MANUAL_TYPE_ID + " VARCHAR,"
1116 + MANUAL_TYPE_NAME + " VARCHAR)";
1117 //</editor-fold>
1118
1119 //<editor-fold desc = "CREATE STATIONS TABLE">
1120 private static final String CREATE_STATIONS = "CREATE TABLE IF NOT EXISTS " + STATIONS + "("
1121 + STATION_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1122 + STATION_ID + " VARCHAR,"
1123 + STATION_COMPANY_ID + " VARCHAR,"
1124 + STATION_SUBCOMPANY_ID + " VARCHAR,"
1125 + STATION_STATION + " VARCHAR,"
1126 + STATION_STATUS + " VARCHAR)";
1127 //</editor-fold>
1128
1129 //<editor-fold desc = "CREATE TERMINALS TABLE">
1130 private static final String CREATE_TERMINALS = "CREATE TABLE IF NOT EXISTS " + TERMINALS + "("
1131 + TERMINAL_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1132 + TERMINAL_ID + " VARCHAR,"
1133 + TERMINAL_NAME + " VARCHAR)";
1134 //</editor-fold>
1135
1136 //<editor-fold desc = "CREATE EXPENSE_LISTS TABLE">
1137 private static final String CREATE_EXPENSE_LISTS = "CREATE TABLE IF NOT EXISTS " + EXPENSE_LISTS + "("
1138 + EXPENSE_LIST_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1139 + EXPENSE_LIST_ID + " VARCHAR,"
1140 + EXPENSE_LIST_NAME + " VARCHAR)";
1141 //</editor-fold>
1142
1143 //<editor-fold desc = "CREATE VIOLATION LIST TABLE">
1144 private static final String CREATE_VIOLATION_LISTS = "CREATE TABLE IF NOT EXISTS " + VIOLATION_LISTS + "("
1145 + VIOLATION_LIST_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1146 + VIOLATION_LIST_COMPANY_ID + " VARCHAR,"
1147 + VIOLATION_LIST_NAME + " VARCHAR,"
1148 + VIOLATION_LIST_EMP_TYPE + " VARCHAR)";
1149 //</editor-fold>
1150
1151 //<editor-fold desc = "CREATE VEHICLES TABLE">
1152 private static final String CREATE_VEHICLES = "CREATE TABLE IF NOT EXISTS " + VEHICLES + "("
1153 + VEHICLES_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1154 + VEHICLES_ID + " VARCHAR,"
1155 + VEHICLES_COMPANY_ID + " VARCHAR,"
1156 + VEHICLES_BUS_NO + " VARCHAR,"
1157 + VEHICLES_PLATE_NO + " VARCHAR,"
1158 + VEHICLES_SOFTWARE_SERIAL_NO + " VARCHAR,"
1159 + VEHICLES_PERMIT_TO_USE + " VARCHAR,"
1160 + VEHICLES_TIN + " VARCHAR,"
1161 + VEHICLES_ACCRE + " VARCHAR,"
1162 + VEHICLES_MIN + " VARCHAR)";
1163 //</editor-fold>
1164
1165 //<editor-fold desc = "CREATE SUBCOMPANIES TABLE">
1166 private static final String CREATE_SUBCOMPANIES = "CREATE TABLE IF NOT EXISTS " + SUBCOMPANIES + "("
1167 + SUBCOMPANIES_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1168 + SUBCOMPANIES_ID + " VARCHAR,"
1169 + SUBCOMPANIES_NAME + " VARCHAR,"
1170 + SUBCOMPANIES_DRIVER_SCHEME + " VARCHAR,"
1171 + SUBCOMPANIES_CONDUCTOR_SCHEME + " VARCHAR)";
1172 //</editor-fold>
1173
1174 //<editor-fold desc = "CREATE ROUTES TABLE">
1175 private static final String CREATE_ROUTES = "CREATE TABLE IF NOT EXISTS " + ROUTES + "("
1176 + ROUTE_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1177 + ROUTE_COMPANY_ID + " VARCHAR,"
1178 + ROUTE_ID + " VARCHAR,"
1179 + ROUTE_NAME + " VARCHAR,"
1180 + ROUTE_MIN_KM + " VARCHAR,"
1181 + ROUTE_MIN_FARE + " VARCHAR,"
1182 + ROUTE_FARE_RATE + " VARCHAR,"
1183 + ROUTE_CODE + " VARCHAR,"
1184 + ROUTE_QUOTA_1 + " VARCHAR,"
1185 + ROUTE_QUOTA_2 + " VARCHAR,"
1186 + ROUTE_BOUND + " VARCHAR,"
1187 + ROUTE_KMRUN + " VARCHAR,"
1188 + ROUTE_HOUR + " VARCHAR,"
1189 + ROUTE_GROUP + " VARCHAR)";
1190 //</editor-fold>
1191
1192 //<editor-fold desc = "CREATE USERS TABLE">
1193 private static final String CREATE_USERS = "CREATE TABLE IF NOT EXISTS " + USERS + "("
1194 + USER_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1195 + USER_ID + " VARCHAR,"
1196 + USER_COMPANY_ID + " VARCHAR,"
1197 + USER_SUBCOMPANY_ID + " VARCHAR,"
1198 + USER_EMP_ID + " VARCHAR,"
1199 + USER_NAME + " VARCHAR,"
1200 + USER_CARD_ID + " VARCHAR,"
1201 + USER_POSITION + " VARCHAR,"
1202 + USER_FUND_RATE + " VARCHAR,"
1203 + USER_COMM_RATE + " VARCHAR,"
1204 + USER_BONUS_RATE + " VARCHAR,"
1205 + USER_SURETY_FUND + " VARCHAR,"
1206 + USER_ALLOWANCE + " VARCHAR)";
1207 //</editor-fold>
1208
1209 //<editor-fold desc = "CREATE DEVICE INFO">
1210 private static final String CREATE_DEV_INFO = "CREATE TABLE IF NOT EXISTS " + DEV_INFO + "("
1211 + DEV_INFO_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1212 + DEV_INFO_COMPANY_ID + " VARCHAR,"
1213 + DEV_INFO_SUBCOMPANY_ID + " VARCHAR,"
1214 + DEV_INFO_COMPANY_NAME + " VARCHAR,"
1215 + DEV_INFO_SUBCOMPANY_NAME + " VARCHAR,"
1216 + DEV_INFO_TERMINAL + " VARCHAR,"
1217 + DEV_INFO_VEHICLE_ID + " VARCHAR,"
1218 + DEV_INFO_STATUS + " VARCHAR,"
1219 + DEV_INFO_TYPE + " VARCHAR)";
1220 //</editor-fold>
1221
1222 //<editor-fold desc = "CREATE ACTIVATION TABLE">
1223 private static final String CREATE_ACTIVATION = "CREATE TABLE IF NOT EXISTS " + ACTIVATION + "("
1224 + ACTIVATION_AUTO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1225 + ACTIVATION_SIM_SERIAL + " VARCHAR,"
1226 + ACTIVATION_SAM_SERIAL + " VARCHAR,"
1227 + ACTIVATION_SD_SERIAL + " VARCHAR,"
1228 + ACTIVATION_DEVICE_SERIAL + " VARCHAR,"
1229 + ACTIVATION_CONNECTION + " VARCHAR)";
1230 //</editor-fold>
1231
1232 //<editor-fold desc = "CREATE_DEVICE_LOGS QUERY">
1233 private static final String CREATE_DEVICE_LOGS = "CREATE TABLE IF NOT EXISTS " + DEVICE_LOGS + "("
1234 + DEVICE_LOGS_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
1235 + DEVICE_LOGS_EOD_ID + " VARCHAR,"
1236 + DEVICE_LOGS_GENEARTED_ID + " VARCHAR,"
1237 + DEVICE_LOGS_CONTROL_NO + " VARCHAR,"
1238 + DEVICE_LOGS_TRIP_NO + " VARCHAR,"
1239 + DEVICE_LOGS_EMPLOYEE_ID + " VARCHAR,"
1240 + DEVICE_LOGS_MODULE + " VARCHAR,"
1241 + DEVICE_LOGS_ACTION + " VARCHAR,"
1242 + DEVICE_LOGS_LONG + " VARCHAR,"
1243 + DEVICE_LOGS_LAT + " VARCHAR,"
1244 + DEVICE_LOGS_DATETIME + " VARCHAR,"
1245 + DEVICE_LOGS_IS_SEND + " VARCHAR)";
1246 //</editor-fold>
1247
1248
1249 public DBHelper(Context context) {
1250 super(context, DB_NAME, null, DB_VERSION);
1251 }
1252
1253 @Override
1254 public void onCreate(SQLiteDatabase db) {
1255 db.execSQL(CREATE_ACTIVATION);
1256 db.execSQL(CREATE_DEV_INFO);
1257 db.execSQL(CREATE_USERS);
1258 db.execSQL(CREATE_ROUTES);
1259 db.execSQL(CREATE_SUBCOMPANIES);
1260 db.execSQL(CREATE_VEHICLES);
1261 db.execSQL(CREATE_VIOLATION_LISTS);
1262 db.execSQL(CREATE_EXPENSE_LISTS);
1263 db.execSQL(CREATE_TERMINALS);
1264 db.execSQL(CREATE_STATIONS);
1265 db.execSQL(CREATE_MANUAL_TYPES);
1266 db.execSQL(CREATE_KMPOSTS);
1267 db.execSQL(CREATE_SETTINGS);
1268 db.execSQL(CREATE_DISPATCHING);
1269 db.execSQL(CREATE_ARRIVAL);
1270 db.execSQL(CREATE_DEVICE_SETTINGS);
1271 db.execSQL(CREATE_TICKETS);
1272 db.execSQL(CREATE_REMITTANCE);
1273 db.execSQL(CREATE_REMITTANCE_INPUT);
1274 db.execSQL(CREATE_REFUND);
1275 db.execSQL(CREATE_RECEIVE);
1276 db.execSQL(CREATE_INSPECTION);
1277 db.execSQL(CREATE_TRANSFER);
1278 db.execSQL(CREATE_VIOLATION);
1279 db.execSQL(CREATE_PARTIAL);
1280 db.execSQL(CREATE_MANUAL);
1281 db.execSQL(CREATE_SPECIAL_TRIP);
1282 db.execSQL(CREATE_EXPENSE);
1283 db.execSQL(CREATE_FUEL_LOAD);
1284 db.execSQL(CREATE_DEVICE_LOGS);
1285
1286 }
1287
1288 @Override
1289 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
1290 onCreate(db);
1291 }
1292}