· 7 years ago · Jan 22, 2019, 10:48 AM
1import android.app.Activity;
2import android.app.Dialog;
3import android.content.Intent;
4import android.os.Bundle;
5import android.view.KeyEvent;
6import android.view.View;
7import android.view.View.OnClickListener;
8import android.view.ViewGroup.LayoutParams;
9import android.widget.Button;
10import android.widget.CheckBox;
11import android.widget.EditText;
12import android.widget.ImageButton;
13import android.widget.LinearLayout;
14import android.widget.RelativeLayout;
15import android.widget.TextView;
16
17public class StartMoving extends Activity implements OnClickListener {
18
19 Button managemove, returnBack, manageroom, settings, kitchen, addmove;
20 ImageButton add1;
21 EditText newMove;
22 TextView roomName, listMove, roomContent, itemValue;
23 CheckBox cbox1;
24 Dialog d;
25 LinearLayout roomButtons, addRooms;
26 RelativeLayout main, merge;
27 int check = 0;
28 int inc = 1;
29 String currentMove = null;
30 String currentRoom = null;
31 String currentItem = null;
32 String currentItemValue = null;
33 int itemval = 1;
34 boolean notavailroom = true;
35
36 @Override
37 protected void onCreate(Bundle savedInstanceState) {
38 // TODO Auto-generated method stub
39 super.onCreate(savedInstanceState);
40 setContentView(R.layout.start_moving);
41
42 roomName = (TextView) findViewById(R.id.tvRoomName);
43
44 managemove = (Button) findViewById(R.id.bManageMove);
45
46 manageroom = (Button) findViewById(R.id.bManageRooms);
47
48 merge = (RelativeLayout) findViewById(R.id.rlmanagemove);
49
50 main = (RelativeLayout) findViewById(R.id.rlmain);
51
52 add1 = (ImageButton) findViewById(R.id.bAddDish);
53
54 roomButtons = (LinearLayout) findViewById(R.id.llButtonRooms);
55
56 kitchen = (Button) findViewById(R.id.bKitchen);
57
58 roomContent = (TextView) findViewById(R.id.tvRoomContent);
59
60 itemValue = (TextView) findViewById(R.id.tvItemValue);
61
62 addRooms = (LinearLayout) findViewById(R.id.llhsvLayout);
63 addRooms.setOrientation(LinearLayout.HORIZONTAL);
64
65 managemove.setOnClickListener(this);
66 manageroom.setOnClickListener(this);
67 add1.setOnClickListener(this);
68 kitchen.setOnClickListener(this);
69
70 Intent i = getIntent();
71 currentMove = i.getStringExtra("moveName");
72
73 }
74
75 public void onClick(View v) {
76 // TODO Auto-generated method stub
77 switch (v.getId()) {
78 case R.id.bManageMove:
79 merge.setVisibility(View.VISIBLE);
80 main.setVisibility(View.INVISIBLE);
81 check = 1;
82 break;
83
84 case R.id.bManageRooms:
85 roomButtons.setVisibility(View.VISIBLE);
86 main.setVisibility(View.INVISIBLE);
87 // LinearLayout laddbuttons = (LinearLayout) findViewById(R.id.llhsvLayout);
88 // laddbuttons.setOrientation(LinearLayout.HORIZONTAL);
89 //
90 // for (int i = 0; i < 3; i++) {
91 // LinearLayout row = new LinearLayout(this);
92 // row.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));
93 //
94 // for (int j = 0; j < 4; j++) {
95 // Button btnTag = new Button(this);
96 // btnTag.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));
97 // btnTag.setText("Button " + (j + 1 + (i * 4)));
98 // btnTag.setId(j + 1 + (i * 4));
99 // row.addView(btnTag);
100 // }
101 //
102 // laddbuttons.addView(row);
103 // }
104 check = 2;
105 break;
106
107 case R.id.bAddDish:
108 currentItem = currentItem + "nDishwahser";
109 currentItemValue = "" + itemval + "n";
110 itemval++;
111
112 roomContent.setText(currentItem);
113 itemValue.setText(currentItemValue);
114 break;
115
116 case R.id.bKitchen:
117 LinearLayout row = new LinearLayout(this);
118 row.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));
119
120 try {
121 SQLHandler kitchen = new SQLHandler(StartMoving.this);
122 currentRoom = "Kitchen" + inc;
123 kitchen.open();
124 String returnedRoom = kitchen.getRoom(currentRoom);
125
126 while (notavailroom) {
127 if (returnedRoom.equals(currentRoom)) {
128 inc++;
129 returnedRoom = kitchen.getRoom(currentRoom);
130 }else{
131 notavailroom = false;
132 kitchen.addRooms(currentMove, currentRoom);
133 roomName.setText(currentRoom);
134 Button b = new Button(StartMoving.this);
135 b.setText(currentRoom);
136 row.addView(b);
137 b.setOnClickListener(new OnClickListener() {
138
139 public void onClick(View v) {
140 // TODO Auto-generated method stub
141
142 }
143 });
144 addRooms.addView(row);
145 main.setVisibility(View.VISIBLE);
146 roomButtons.setVisibility(View.INVISIBLE);
147 }
148 }
149 kitchen.close();
150 } catch (Exception e) {
151 // TODO Auto-generated catch block
152 SQLHandler kitchen = new SQLHandler(StartMoving.this);
153 currentRoom = "Kitchen" + inc;
154 kitchen.open();
155 kitchen.addRooms(currentMove, currentRoom);
156 roomName.setText(currentRoom);
157 Button b = new Button(StartMoving.this);
158 b.setText(currentRoom);
159 row.addView(b);
160 b.setOnClickListener(new OnClickListener() {
161
162 public void onClick(View v) {
163 // TODO Auto-generated method stub
164
165 }
166 });
167 addRooms.addView(row);
168 main.setVisibility(View.VISIBLE);
169 roomButtons.setVisibility(View.INVISIBLE);
170 kitchen.close();
171 }
172
173 break;
174
175 default:
176 break;
177 }
178 }
179
180 @Override
181 protected void onDestroy() {
182 // TODO Auto-generated method stub
183 super.onDestroy();
184 }
185
186 @Override
187 protected void onPause() {
188 // TODO Auto-generated method stub
189 super.onPause();
190 }
191
192 @Override
193 protected void onResume() {
194 // TODO Auto-generated method stub
195 super.onResume();
196 }
197
198 @Override
199 protected void onSaveInstanceState(Bundle outState) {
200 // TODO Auto-generated method stub
201 super.onSaveInstanceState(outState);
202 }
203
204 @Override
205 protected void onRestoreInstanceState(Bundle savedInstanceState) {
206 // TODO Auto-generated method stub
207 super.onRestoreInstanceState(savedInstanceState);
208
209 roomName.setText("Hello world");
210 }
211
212 public void onBackPressed(){
213 super.onBackPressed();
214
215 }
216
217 @Override
218 public boolean onKeyDown(int keyCode, KeyEvent event) {
219 if (keyCode == KeyEvent.KEYCODE_BACK && event.getRepeatCount() == 0) {
220 // do something on back.
221 if (check == 1) {
222 merge.setVisibility(View.INVISIBLE);
223 main.setVisibility(View.VISIBLE);
224 check = 0;
225 }else if (check == 2) {
226 main.setVisibility(View.VISIBLE);
227 roomButtons.setVisibility(View.INVISIBLE);
228 check = 0;
229 }else {
230 // this.finish();
231 Intent i = new Intent(StartMoving.this, ListMovingNames.class);
232 startActivity(i);
233 }
234 return true;
235 }
236
237 return super.onKeyDown(keyCode, event);
238 }
239}
240
241case R.id.bKitchen:
242 LinearLayout row = new LinearLayout(this);
243 row.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));
244
245 try {
246 SQLHandler kitchen = new SQLHandler(StartMoving.this);
247 currentRoom = "Kitchen" + inc;
248 kitchen.open();
249 String returnedRoom = kitchen.getRoom(currentRoom);
250
251 while (notavailroom) {
252 if (returnedRoom.equals(currentRoom)) {
253 inc++;
254 returnedRoom = kitchen.getRoom(currentRoom);
255 }else{
256 notavailroom = false;
257 kitchen.addRooms(currentMove, currentRoom);
258 roomName.setText(currentRoom);
259 Button b = new Button(StartMoving.this);
260 b.setText(currentRoom);
261 row.addView(b);
262 b.setOnClickListener(new OnClickListener() {
263
264 public void onClick(View v) {
265 // TODO Auto-generated method stub
266
267 }
268 });
269 addRooms.addView(row);
270 main.setVisibility(View.VISIBLE);
271 roomButtons.setVisibility(View.INVISIBLE);
272 }
273 }
274 kitchen.close();
275 } catch (Exception e) {
276 // TODO Auto-generated catch block
277 SQLHandler kitchen = new SQLHandler(StartMoving.this);
278 currentRoom = "Kitchen" + inc;
279 kitchen.open();
280 kitchen.addRooms(currentMove, currentRoom);
281 roomName.setText(currentRoom);
282 Button b = new Button(StartMoving.this);
283 b.setText(currentRoom);
284 row.addView(b);
285 b.setOnClickListener(new OnClickListener() {
286
287 public void onClick(View v) {
288 // TODO Auto-generated method stub
289
290 }
291 });
292 addRooms.addView(row);
293 main.setVisibility(View.VISIBLE);
294 roomButtons.setVisibility(View.INVISIBLE);
295 kitchen.close();
296 }
297
298 break;
299
300import android.content.ContentValues;
301import android.content.Context;
302import android.database.Cursor;
303import android.database.SQLException;
304import android.database.sqlite.SQLiteDatabase;
305import android.database.sqlite.SQLiteOpenHelper;
306
307public class SQLHandler {
308 public static final String KEY_ROOMMOVEHOLDER = "roommoveholder";
309 public static final String KEY_ROOM = "room";
310
311 public static final String KEY_ITEMMOVEHOLDER = "itemmoveholder";
312 public static final String KEY_ITEMNAME = "itemname";
313 public static final String KEY_ITEMVALUE = "itemvalue";
314 public static final String KEY_ROOMHOLDER = "roomholder";
315
316 public static final String KEY_MOVENAME = "movename";
317 public static final String KEY_ID1 = "_id";
318 public static final String KEY_ID2 = "_id";
319 public static final String KEY_ID3 = "_id";
320 public static final String KEY_ID4 = "_id";
321 public static final String KEY_MOVEDATE = "movedate";
322
323 private static final String DATABASE_NAME = "mymovingfriend";
324 private static final int DATABASE_VERSION = 1;
325
326 public static final String KEY_TODOMOVE = "todomove";
327 public static final String KEY_SORTANDPURGE = "sortandpurge";
328 public static final String KEY_RESEARCH = "research";
329 public static final String KEY_CREATEMOVINGBINDER = "createmovingbinder";
330 public static final String KEY_ORDERSUPPLIES = "ordersupplies";
331 public static final String KEY_USEITORLOSEIT = "useitorloseit";
332 public static final String KEY_TAKEMEASUREMENTS = "takemeasurements";
333 public static final String KEY_CHOOSEMOVER = "choosemover";
334 public static final String KEY_BEGINPACKING = "beginpacking";
335 public static final String KEY_LABEL = "label";
336 public static final String KEY_SEPARATEVALUES = "separatevalues";
337 public static final String KEY_DOACHANGEOFADDRESS = "doachangeofaddress";
338 public static final String KEY_NOTIFYIMPORTANTPARTIES = "notifyimportantparties";
339
340 private static final String DATABASE_TABLE1 = "movingname";
341 private static final String DATABASE_TABLE2 = "movingrooms";
342 private static final String DATABASE_TABLE3 = "movingitems";
343 private static final String DATABASE_TABLE4 = "todolist";
344
345 public static final String CREATE_TABLE_1 = "CREATE TABLE " + DATABASE_TABLE1 + " (" +
346 KEY_ID1 + " INTEGER PRIMARY KEY AUTOINCREMENT," +
347 KEY_MOVEDATE + " TEXT NOT NULL, " +
348 KEY_MOVENAME + " TEXT NOT NULL);";
349
350 public static final String CREATE_TABLE_2 = "CREATE TABLE " + DATABASE_TABLE2 + " (" +
351 KEY_ID2 + " INTEGER PRIMARY KEY AUTOINCREMENT," +
352 KEY_ROOMMOVEHOLDER + " TEXT NOT NULL, " +
353 KEY_ROOM + " TEXT NOT NULL);";
354
355 public static final String CREATE_TABLE_3 = "CREATE TABLE " + DATABASE_TABLE3 + " (" +
356 KEY_ID3 + " INTEGER PRIMARY KEY AUTOINCREMENT," +
357 KEY_ITEMNAME + " TEXT NOT NULL, " +
358 KEY_ITEMVALUE + " TEXT NOT NULL, " +
359 KEY_ROOMHOLDER + " TEXT NOT NULL, " +
360 KEY_ITEMMOVEHOLDER + " TEXT NOT NULL);";
361
362 public static final String CREATE_TABLE_4 = "CREATE TABLE " + DATABASE_TABLE4 + " (" +
363 KEY_ID4 + " INTEGER PRIMARY KEY AUTOINCREMENT," +
364 KEY_TODOMOVE + " TEXT NOT NULL, " +
365 KEY_SORTANDPURGE + " TEXT NOT NULL, " +
366 KEY_RESEARCH + " INTEGER NOT NULL, " +
367 KEY_CREATEMOVINGBINDER + " TEXT NOT NULL, " +
368 KEY_ORDERSUPPLIES + " TEXT NOT NULL, " +
369 KEY_USEITORLOSEIT + " TEXT NOT NULL, " +
370 KEY_TAKEMEASUREMENTS + " TEXT NOT NULL, " +
371 KEY_CHOOSEMOVER + " TEXT NOT NULL, " +
372 KEY_BEGINPACKING + " TEXT NOT NULL, " +
373 KEY_LABEL + " TEXT NOT NULL, " +
374 KEY_SEPARATEVALUES + " TEXT NOT NULL, " +
375 KEY_DOACHANGEOFADDRESS + " TEXT NOT NULL, " +
376 KEY_NOTIFYIMPORTANTPARTIES + " TEXT NOT NULL);";
377
378 private DbHelper ourHelper;
379 private final Context ourContext;
380 private SQLiteDatabase ourDatabase;
381
382 private static class DbHelper extends SQLiteOpenHelper{
383
384 public DbHelper(Context context) {
385 super(context, DATABASE_NAME, null, DATABASE_VERSION);
386 // TODO Auto-generated constructor stub
387 }
388
389 @Override
390 public void onCreate(SQLiteDatabase db) {
391 // TODO Auto-generated method stub
392 db.execSQL(CREATE_TABLE_1);
393 db.execSQL(CREATE_TABLE_2);
394 db.execSQL(CREATE_TABLE_3);
395 db.execSQL(CREATE_TABLE_4);
396 }
397
398 @Override
399 public void onUpgrade(SQLiteDatabase db, int oldversion, int newversion) {
400 // TODO Auto-generated method stub
401 db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE1);
402 db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE2);
403 db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE3);
404 db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE4);
405 onCreate(db);
406 }
407 }
408
409 public SQLHandler(Context c){
410 ourContext = c;
411 }
412
413 public SQLHandler open() throws SQLException{
414 ourHelper = new DbHelper(ourContext);
415 ourDatabase = ourHelper.getWritableDatabase();
416 return this;
417 }
418
419 public void close(){
420 ourHelper.close();
421 }
422
423 public long createMove(String smovename){
424 ContentValues cv = new ContentValues();
425 cv.put(KEY_MOVENAME, smovename);
426 cv.put(KEY_MOVEDATE, "Not yet set");
427 return ourDatabase.insert(DATABASE_TABLE1, null, cv);
428 }
429
430 public long addRooms(String sroommoveholder, String sroom){
431 ContentValues cv = new ContentValues();
432 cv.put(KEY_ROOMMOVEHOLDER, sroommoveholder);
433 cv.put(KEY_ROOM, sroom);
434 return ourDatabase.insert(DATABASE_TABLE2, null, cv);
435 }
436
437 public long addItems(String sitemmoveholder, String sroomholder, String sitemname, String sitemvalue){
438 ContentValues cv = new ContentValues();
439 cv.put(KEY_ITEMMOVEHOLDER, sitemmoveholder);
440 cv.put(KEY_ROOMHOLDER, sroomholder);
441 cv.put(KEY_ITEMNAME, sitemname);
442 cv.put(KEY_ITEMVALUE, sitemvalue);
443 return ourDatabase.insert(DATABASE_TABLE3, null, cv);
444 }
445
446 public long todoList(String todoitem){
447 ContentValues cv = new ContentValues();
448 cv.put(todoitem, "Done");
449 return ourDatabase.insert(DATABASE_TABLE4, null, cv);
450 }
451
452 public Cursor getMove(){
453 String[] columns = new String[]{KEY_ID1, KEY_MOVENAME};
454 Cursor cursor = ourDatabase.query(DATABASE_TABLE1, columns, null, null, null, null, null);
455 return cursor;
456 }
457
458 public String getRoom(String r) throws SQLException{
459 String[] columns = new String[]{KEY_ID2, KEY_ROOMMOVEHOLDER, KEY_ROOM};
460 Cursor c = ourDatabase.query(DATABASE_TABLE2, columns, KEY_ROOM + "= '" + r + "'" , null, null, null, null);
461
462 if (c != null) {
463 c.moveToFirst();
464 String roomName = c.getString(2);
465 return roomName;
466 }
467 return null;
468
469 }
470
471}
472
473if (returnedRoom.equals(currentRoom)) {
474 inc++;
475 returnedRoom = kitchen.getRoom(currentRoom);
476}
477
478if (returnedRoom.equals(currentRoom)) {
479 currentRoom = "Kitchen" + ++inc;
480 returnedRoom = kitchen.getRoom(currentRoom);
481}