1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
|
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main_tuto);
/** Shared preferences to get account Id and Name **/
SharedPreferences preferences = getSharedPreferences("filePrefName", MODE_PRIVATE);
String accountId = preferences.getString("accountId", "");
String accountName = preferences.getString("accountName", "");
compteId = Integer.parseInt(accountId);//Convert to integer for BDD
compteName = accountName;
/** Spinner get year and month **/
spinnerYear = (Spinner) findViewById(R.id.yearsss);
final Spinner spinnerMonth = (Spinner) findViewById(R.id.month);
Calendar spinCal = Calendar.getInstance(Locale.getDefault());
int intYearNow = spinCal.get(Calendar.YEAR);
int intMonthNow = spinCal.get(Calendar.MONTH);
spinnerArrayYear = new ArrayAdapter<String>(this,android.R.layout.simple_spinner_item);
spinnerArrayYear.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
ArrayAdapter<String> spinnerArrayMonth = new ArrayAdapter<String>(this,android.R.layout.simple_spinner_item);
spinnerArrayMonth.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
FluxDAO FluxDAOdate = new FluxDAO(this);
FluxDAOdate.open();
Cursor cursorDate = FluxDAOdate.mDb.rawQuery("SELECT DISTINCT compteid, IFNULL(MIN(date1), -1) FROM " + FluxDAO.FLUX_TABLE_NAME + " WHERE " + FluxDAO.FLUX_COMPTE_ID + " == " + compteId, null);
startManagingCursor(cursorDate);
if (!cursorDate.moveToFirst() || cursorDate.moveToFirst() && cursorDate.getLong(1) == -1){
String strYear = String.valueOf(spinCal.get(Calendar.YEAR));
String hhh = sdf.format(spinCal.get(Calendar.MONTH));
spinnerArrayYear.add(strYear);
spinnerArrayMonth.add(hhh);
Toast.makeText(getBaseContext(),"Pas de Résultat ! dates en cours", Toast.LENGTH_SHORT).show();
}
else {
for(cursorDate.moveToFirst(); !cursorDate.isAfterLast(); cursorDate.moveToNext()) {
String dateMinStr = cursorDate.getString(1);
Long dateMinLong = Long.valueOf(dateMinStr);
Calendar calendarMin = Calendar.getInstance(Locale.getDefault());
calendarMin.setTimeInMillis(dateMinLong);
int intYearMin = calendarMin.get(Calendar.YEAR);
int intMonthMin = calendarMin.get(Calendar.MONTH);
for(int i=intYearNow; i>=intYearMin; i--){
String Strval = String.valueOf(i);
spinnerArrayYear.add(Strval);
if(spinnerYear.getSelectedItem() == null){
Toast.makeText(this,"Spinner NULL", Toast.LENGTH_SHORT).show();
}
//String gggg = spinnerYear.getSelectedItem().toString();
//Toast.makeText(this," aff :" + yearstr, Toast.LENGTH_SHORT).show();
}
// utiliser between 01/2014 au 12/2014
/** Le 01/01/N -> N = Spinner selected **/
Calendar calendarMinDateYear = Calendar.getInstance();
//String yearstr = spinnerYear.getSelectedItem().toString();
//Toast.makeText(this," aff :" + yearstr, Toast.LENGTH_SHORT).show();
//int yearInt = Integer.valueOf(yearstr);
/*calendarMinDateYear.set(Calendar.YEAR, year);
calendarMinDateYear.set(Calendar.MONTH, Calendar.JANUARY);
calendarMinDateYear.set(Calendar.DAY_OF_MONTH, 1);
calendarMinDateYear.set(Calendar.HOUR_OF_DAY, 0);
calendarMinDateYear.set(Calendar.MINUTE, 0);
calendarMinDateYear.set(Calendar.SECOND, 0);
Date minDate = calendarMinDateYear.getTime();
/** Le 31/12/N N = Spinner selected **/
/*calendarMinDateYear.set(Calendar.MONTH, Calendar.DECEMBER);
calendarMinDateYear.set(Calendar.DAY_OF_MONTH, 31);
Date maxDate = calendarMinDateYear.getTime();*/
/*Cursor cursorMonthMin = FluxDAOdate.mDb.rawQuery("SELECT DISTINCT compteid, MIN(date1)" +
" FROM " + FluxDAO.FLUX_TABLE_NAME +
" WHERE " + FluxDAO.FLUX_COMPTE_ID + " == " + compteId +
" AND " + FluxDAO.FLUX_DATE1 + " >= ? " +
" AND " + FluxDAO.FLUX_DATE1 + " <= ? "
, new String[] { Long.toString(minDate.getTime()), Long.toString(maxDate.getTime()) });
startManagingCursor(cursorMonthMin);*/
//Toast.makeText(this," aff :" + String.valueOf(year), Toast.LENGTH_SHORT).show();
}
}
FluxDAOdate.close();
cursorDate.close();
spinnerYear.setAdapter(spinnerArrayYear); |
Partager