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
|
/** Récupération de l'index des Spinner **/
int Month_Selected = Spinner_Month.getSelectedItemPosition();
int Year_Selected = (Integer) Spinner_Year.getSelectedItem();
int Categorie_Selected = Spinner_cat.getSelectedItemPosition();
//Toast.makeText(getBaseContext(),"text : "+ Spinner_Year.getSelectedItem(), Toast.LENGTH_SHORT).show();
/** MAJ des dates **/
calendar.set(Calendar.DAY_OF_MONTH, 1);
calendar.set(Calendar.MONTH, Month_Selected);
calendar.set(Calendar.YEAR, Year_Selected);
/** Retour de la Date **/
String Date_selected = sdf.format(calendar.getTime());
Toast.makeText(getBaseContext(),"Date : "+ Date_selected, Toast.LENGTH_SHORT).show();
/** Convertion en Millisecondes **/
Millisecondes = calendar.getTimeInMillis();
Toast.makeText(getBaseContext(),"Millisecondes : "+ Millisecondes, Toast.LENGTH_SHORT).show();
/** Max de jours dans un mois **/
Month_Year.add(Calendar.JANUARY);
Month_Year.add(Calendar.FEBRUARY);
Month_Year.add(Calendar.MARCH);
Month_Year.add(Calendar.APRIL);
Month_Year.add(Calendar.MAY);
Month_Year.add(Calendar.JUNE);
Month_Year.add(Calendar.JULY);
Month_Year.add(Calendar.AUGUST);
Month_Year.add(Calendar.SEPTEMBER);
Month_Year.add(Calendar.OCTOBER);
Month_Year.add(Calendar.NOVEMBER);
Month_Year.add(Calendar.DECEMBER);
/** Nbre de jours dans un mois **/
mycal = new GregorianCalendar(Year_Selected, Month_Year.get(Month_Selected), 1);
int daysInMonth = mycal.getActualMaximum(Calendar.DAY_OF_MONTH);
Toast.makeText(getBaseContext(),"daysInMonth : "+ daysInMonth, Toast.LENGTH_SHORT).show();
/** MAJ des dates Max**/
calendar2.set(Calendar.DAY_OF_MONTH, daysInMonth);
calendar2.set(Calendar.MONTH, Month_Selected);
calendar2.set(Calendar.YEAR, Year_Selected);
//Toast.makeText(getBaseContext(),"daysInMonth : "+ daysInMonth, Toast.LENGTH_SHORT).show();
/** Convertion en Millisecondes MAX **/
String Date_selected_Max = sdf.format(calendar2.getTime());
Toast.makeText(getBaseContext(),"Date_selected_Max : "+ Date_selected_Max, Toast.LENGTH_SHORT).show();
Millisecondes_Max = calendar2.getTimeInMillis();
/** Instancier XML Listview **/
listContent = (ListView)findViewById(R.id.list);
/** ecrire dans la table **/
MetierDAO MetierDAOS = new MetierDAO(this);
MetierDAOS.open();
/** Requête : Extraction des dépenses **/
cursor = MetierDAOS.mDb.rawQuery("SELECT id as _id,"+
FluxDAO.FLUX_NAME + "," +
FluxDAO.FLUX_DATE1 + "," +
FluxDAO.FLUX_MONEY +
" FROM " + FluxDAO.FLUX_TABLE_NAME +
" WHERE " + FluxDAO.FLUX_DATE1 + " >= " + Millisecondes +
" AND " + FluxDAO.FLUX_DATE1 + " <= " + Millisecondes_Max, null); |
Partager