List of usage examples for java.util Calendar SUNDAY
int SUNDAY
To view the source code for java.util Calendar SUNDAY.
Click Source Link
From source file:org.apache.logging.log4j.core.util.datetime.FastDateParserTest.java
@Test public void testDayNumberOfWeek() throws ParseException { final DateParser parser = getInstance("u"); final Calendar calendar = Calendar.getInstance(); calendar.setTime(parser.parse("1")); Assert.assertEquals(Calendar.MONDAY, calendar.get(Calendar.DAY_OF_WEEK)); calendar.setTime(parser.parse("6")); Assert.assertEquals(Calendar.SATURDAY, calendar.get(Calendar.DAY_OF_WEEK)); calendar.setTime(parser.parse("7")); Assert.assertEquals(Calendar.SUNDAY, calendar.get(Calendar.DAY_OF_WEEK)); }
From source file:de.ribeiro.android.gso.dataclasses.Pager.java
/** * fgt der Liste der Pages und Headlines den bergebenen TimeTable hinzu * * @param weekData//from w ww .j av a 2s. c o m * @param ctxt * @author Tobias Janssen */ public void appendTimeTableToPager(WeekData weekData, MyContext ctxt) { // eine Kopie des Stundenplan-Datums erstellen Calendar currentDay = new GregorianCalendar(); currentDay = (Calendar) weekData.date.clone(); // den aktuellen Wochentag abrufen int currentDayOfWeek = currentDay.get(Calendar.DAY_OF_WEEK); if (currentDayOfWeek == Calendar.SUNDAY) { // 1000*60*60*24 = 1 Tag! currentDay.setTimeInMillis(currentDay.getTimeInMillis() + (1000 * 60 * 60 * 24)); } // den currentDay auf Montag setzten if (currentDayOfWeek > Calendar.MONDAY) { // 1000*60*60*24 = 1 Tag! currentDay .setTimeInMillis(currentDay.getTimeInMillis() - (1000 * 60 * 60 * 24 * (currentDayOfWeek - 2))); } if (context.getResources() .getConfiguration().orientation == android.content.res.Configuration.ORIENTATION_LANDSCAPE) { View page = createWeekPage(weekData); insertWeekPage(currentDay, page, createWeekHeader(weekData, currentDay), 0, ctxt.pager.pageIndex.size()); // currentDay.roll(Calendar.WEEK_OF_YEAR,true); currentDay.setTimeInMillis(currentDay.getTimeInMillis() + 86400000); } else { // alle Tage der Woche hinzufgen for (int x = Calendar.MONDAY; x < Calendar.SATURDAY; x++) { // eine Tagesansicht erstellen List<TimetableViewObject> list = createTimetableDayViewObject(weekData, currentDay); View page = createPage(weekData, list); insertDayPage(currentDay, page, createDayHeader(weekData, currentDay), 0, ctxt.pager.pageIndex.size()); // currentDay.roll(Calendar.DAY_OF_YEAR,1); // einen tag weiter vor currentDay.setTimeInMillis(currentDay.getTimeInMillis() + 86400000); } } }
From source file:com.panet.imeta.trans.steps.scriptvalues_mod.ScriptValuesAddedFunctions.java
public static Object getNextWorkingDay(Context actualContext, Scriptable actualObject, Object[] ArgList, Function FunctionContext) { //(Date dIn){ if (ArgList.length == 1) { try {/*from w w w . j a v a2 s. c o m*/ if (isNull(ArgList[0])) return null; else if (isUndefined(ArgList[0])) return Context.getUndefinedValue(); java.util.Date dIn = (java.util.Date) Context.jsToJava(ArgList[0], java.util.Date.class); Calendar startDate = Calendar.getInstance(); startDate.setTime(dIn); startDate.add(Calendar.DATE, 1); while (startDate.get(Calendar.DAY_OF_WEEK) == Calendar.SATURDAY || startDate.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) { startDate.add(Calendar.DATE, 1); } return startDate.getTime(); } catch (Exception e) { throw Context.reportRuntimeError(e.toString()); } } else { throw Context.reportRuntimeError("The function call getNextWorkingDay requires 1 argument."); } }
From source file:com.virtusa.akura.reporting.controller.GenarateTeacherWisePresentAndAbsentDaysReportController.java
/** * Check the given date is a holiday or not. * * @param holidayList - list consits of Holidays for the given time period. * @param currentDate - currentDate// ww w.j av a 2 s. c o m * @param start - Calender object * @return boolean */ public boolean isHoliday(List<Holiday> holidayList, Date currentDate, Calendar start) { boolean flag = false; int dayOfWeek = start.get(Calendar.DAY_OF_WEEK); for (Holiday tempHoliday : holidayList) { if ((currentDate.after(tempHoliday.getStartDate()) && currentDate.before(tempHoliday.getEndDate())) || currentDate.equals(tempHoliday.getStartDate()) || currentDate.equals(tempHoliday.getEndDate()) || Calendar.SATURDAY == dayOfWeek || Calendar.SUNDAY == dayOfWeek) { flag = true; break; } } return flag; }
From source file:org.pentaho.di.trans.steps.script.ScriptAddedFunctions.java
public static Object dateAdd(ScriptEngine actualContext, Bindings actualObject, Object[] ArgList, Object FunctionContext) { if (ArgList.length == 3) { try {/*ww w . j ava2s . co m*/ if (isNull(ArgList, new int[] { 0, 1, 2 })) { return null; } else if (isUndefined(ArgList, new int[] { 0, 1, 2 })) { return undefinedValue; } java.util.Date dIn = (java.util.Date) ArgList[0]; String strType = ((String) ArgList[1]).toLowerCase(); int iValue = (Integer) ArgList[2]; Calendar cal = Calendar.getInstance(); cal.setTime(dIn); if (strType.equals("y")) { cal.add(Calendar.YEAR, iValue); } else if (strType.equals("m")) { cal.add(Calendar.MONTH, iValue); } else if (strType.equals("d")) { cal.add(Calendar.DATE, iValue); } else if (strType.equals("w")) { cal.add(Calendar.WEEK_OF_YEAR, iValue); } else if (strType.equals("wd")) { int iOffset = 0; while (iOffset < iValue) { int day = cal.get(Calendar.DAY_OF_WEEK); cal.add(Calendar.DATE, 1); if ((day != Calendar.SATURDAY) && (day != Calendar.SUNDAY)) { iOffset++; } } } else if (strType.equals("hh")) { cal.add(Calendar.HOUR, iValue); } else if (strType.equals("mi")) { cal.add(Calendar.MINUTE, iValue); } else if (strType.equals("ss")) { cal.add(Calendar.SECOND, iValue); } return cal.getTime(); } catch (Exception e) { throw new RuntimeException(e.toString()); } } else { throw new RuntimeException("The function call dateAdd requires 3 arguments."); } }
From source file:com.saulcintero.moveon.fragments.Statistics.java
private void paintData(int sql_option, int activity) { boolean isMetric = FunctionUtils.checkIfUnitsAreMetric(mContext); sum_distance = 0;//from ww w . j a va 2s . co m sum_kcal = 0; sum_time = 0; sum_up_accum_altitude = 0; sum_down_accum_altitude = 0; sum_avg_speed = 0; sum_steps = 0; sum_avg_hr = 0; practices_counter = 0; hr_practices_counter = 0; int[] colors = { Color.rgb(111, 183, 217), Color.rgb(54, 165, 54), Color.rgb(246, 103, 88), Color.rgb(234, 206, 74), Color.rgb(246, 164, 83), Color.LTGRAY, Color.rgb(35, 142, 36), Color.rgb(0, 129, 125), Color.rgb(0, 0, 220), Color.rgb(255, 255, 0), Color.rgb(255, 215, 0), Color.rgb(184, 134, 11), Color.rgb(245, 245, 220), Color.rgb(139, 137, 137), Color.rgb(96, 57, 138), Color.rgb(176, 0, 103), Color.rgb(77, 19, 106), Color.rgb(218, 0, 0), Color.rgb(252, 115, 0), Color.rgb(243, 42, 0), Color.rgb(255, 202, 44), Color.rgb(176, 214, 7), Color.rgb(255, 235, 44), Color.rgb(255, 255, 255), Color.rgb(186, 29, 29), Color.rgb(146, 436, 20), Color.rgb(245, 175, 209), Color.rgb(29, 91, 139), Color.rgb(128, 128, 0), Color.rgb(128, 0, 128), Color.rgb(0, 128, 128), Color.rgb(246, 233, 207), Color.rgb(231, 56, 142), Color.rgb(173, 141, 193), Color.rgb(191, 199, 32), Color.rgb(0, 128, 0), Color.rgb(4, 136, 125), Color.rgb(140, 0, 255), Color.rgb(135, 0, 118), Color.rgb(2, 132, 132), Color.rgb(0, 127, 204), Color.rgb(128, 250, 255), Color.rgb(192, 192, 192), Color.rgb(207, 94, 97), Color.rgb(137, 189, 199), Color.rgb(138, 168, 161), Color.rgb(171, 166, 191), Color.rgb(199, 153, 125) }; DBManager = null; cursor = null; distance_distribution = null; kcal_distribution = null; time_distribution = null; DBManager = new DataManager(mContext); DBManager.Open(); cursor = DBManager.CustomQuery(getString(R.string.checking_routes), "SELECT * FROM routes"); cursor.moveToFirst(); if (cursor.getCount() > 0) { between_dates_query_part = ""; DatesTypes whichDate = DatesTypes.values()[sql_option]; switch (whichDate) { case ALL_DATES: removeCustomDataValues(); if (activity > 0) { cursor = DBManager.CustomQuery( getString(R.string.selecting_all_routes) + " " + getString(R.string.filter_by_activity) + " " + getString(R.string.and) + " " + getString(R.string.group_by_activities), "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE category_id = '" + activity + "' " + "GROUP BY category_id"); } else { cursor = DBManager.CustomQuery( getString(R.string.selecting_all_routes) + " " + getString(R.string.group_by_activities), "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes GROUP BY category_id"); } break; case THIS_YEAR: removeCustomDataValues(); if (activity > 0) { cursor = DBManager.CustomQuery( getString(R.string.selecting_this_year_routes) + " " + getString(R.string.filter_by_activity) + " " + getString(R.string.and) + " " + getString(R.string.group_by_activities), "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE substr(date,7) = '" + Calendar.getInstance().get(Calendar.YEAR) + "' " + "AND category_id = '" + activity + "' " + "GROUP BY category_id"); } else { cursor = DBManager.CustomQuery( getString(R.string.selecting_this_year_routes) + " " + getString(R.string.group_by_activities), "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE substr(date,7) = '" + Calendar.getInstance().get(Calendar.YEAR) + "' " + "GROUP BY category_id"); } between_dates_query_part = "substr(date,7) = '" + Calendar.getInstance().get(Calendar.YEAR) + "' "; break; case THIS_MONTH: removeCustomDataValues(); int month = Calendar.getInstance().get(Calendar.MONTH) + 1; String sMonth = String.valueOf(month); if (month < 10) sMonth = "0" + sMonth; if (activity > 0) { cursor = DBManager.CustomQuery( getString(R.string.selecting_this_month_routes) + " " + getString(R.string.filter_by_activity) + " " + getString(R.string.and) + " " + getString(R.string.group_by_activities), "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE substr(date,4,2) = '" + sMonth + "' " + "AND substr(date,7) = '" + Calendar.getInstance().get(Calendar.YEAR) + "' " + "AND category_id = '" + activity + "' " + "GROUP BY category_id"); } else { cursor = DBManager.CustomQuery( getString(R.string.selecting_this_month_routes) + " " + getString(R.string.group_by_activities), "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE substr(date,4,2) = '" + sMonth + "' " + "AND substr(date,7) = '" + Calendar.getInstance().get(Calendar.YEAR) + "' " + "GROUP BY category_id"); } between_dates_query_part = "substr(date,4,2) = '" + sMonth + "' AND substr(date,7) = '" + Calendar.getInstance().get(Calendar.YEAR) + "' "; break; case THIS_WEAK: removeCustomDataValues(); Calendar c1 = Calendar.getInstance(); c1.setFirstDayOfWeek(Calendar.MONDAY); c1.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY); int y = c1.get(Calendar.YEAR); int m = c1.get(Calendar.MONTH) + 1; int d = c1.get(Calendar.DAY_OF_MONTH); String sYear1 = String.valueOf(y); String sMonth1 = String.valueOf(m); if (m < 10) sMonth1 = "0" + sMonth1; String sDay1 = String.valueOf(d); if (d < 10) sDay1 = "0" + sDay1; c1.set(Calendar.DAY_OF_WEEK, Calendar.SUNDAY); int y2 = c1.get(Calendar.YEAR); int m2 = c1.get(Calendar.MONTH) + 1; int d2 = c1.get(Calendar.DAY_OF_MONTH); String sYear2 = String.valueOf(y2); String sMonth2 = String.valueOf(m2); if (m2 < 10) sMonth2 = "0" + sMonth2; String sDay2 = String.valueOf(d2); if (d2 < 10) sDay2 = "0" + sDay2; if (activity > 0) { cursor = DBManager.CustomQuery( getString(R.string.selecting_this_weak_routes) + " " + getString(R.string.filter_by_activity) + " " + getString(R.string.and) + " " + getString(R.string.group_by_activities), "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE substr(date,7)||substr(date,4,2)||substr(date,1,2) " + "BETWEEN '" + sYear1 + sMonth1 + sDay1 + "' AND '" + sYear2 + sMonth2 + sDay2 + "' " + "AND category_id = '" + activity + "' " + "GROUP BY category_id"); } else { cursor = DBManager.CustomQuery( getString(R.string.selecting_this_weak_routes) + " " + getString(R.string.group_by_activities), "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE substr(date,7)||substr(date,4,2)||substr(date,1,2) " + "BETWEEN '" + sYear1 + sMonth1 + sDay1 + "' AND '" + sYear2 + sMonth2 + sDay2 + "' " + "GROUP BY category_id"); } between_dates_query_part = "substr(date,7)||substr(date,4,2)||substr(date,1,2) " + "BETWEEN '" + sYear1 + sMonth1 + sDay1 + "' AND '" + sYear2 + sMonth2 + sDay2 + "' "; break; case BETWEEN_TWO_DATES: String mYear1 = String.valueOf(year1); String mMonth1 = String.valueOf(month1); if (month1 < 10) mMonth1 = "0" + mMonth1; String mDay1 = String.valueOf(day1); if (day1 < 10) mDay1 = "0" + mDay1; String mYear2 = String.valueOf(year2); String mMonth2 = String.valueOf(month2); if (month2 < 10) mMonth2 = "0" + mMonth2; String mDay2 = String.valueOf(day2); if (day2 < 10) mDay2 = "0" + mDay2; customDay1 = mDay1; customDay2 = mDay2; customMonth1 = mMonth1; customMonth2 = mMonth2; customYear1 = mYear1; customYear2 = mYear2; if (activity > 0) { cursor = DBManager.CustomQuery("Seleccionando las rutas de este mes agrupadas por actividad", "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE substr(date,7)||substr(date,4,2)||substr(date,1,2) " + "BETWEEN '" + customYear1 + customMonth1 + customDay1 + "' AND '" + customYear2 + customMonth2 + customDay2 + "' " + "AND category_id = '" + activity + "' " + "GROUP BY category_id"); } else { cursor = DBManager.CustomQuery("Seleccionando las rutas de este mes agrupadas por actividad", "SELECT category_id, COUNT(*) AS count_practices, SUM(distance) AS sum_distance, " + "SUM(kcal) AS sum_kcal, SUM(time) AS sum_time, SUM(avg_speed) AS sum_avg_speed, " + "SUM(up_accum_altitude) AS sum_up_accum_altitude, " + "SUM(down_accum_altitude) AS sum_down_accum_altitude, " + "SUM(steps) AS sum_steps " + "FROM routes " + "WHERE substr(date,7)||substr(date,4,2)||substr(date,1,2) " + "BETWEEN '" + customYear1 + customMonth1 + customDay1 + "' AND '" + customYear2 + customMonth2 + customDay2 + "' " + "GROUP BY category_id"); } between_dates_query_part = "substr(date,7)||substr(date,4,2)||substr(date,1,2) " + "BETWEEN '" + customYear1 + customMonth1 + customDay1 + "' AND '" + customYear2 + customMonth2 + customDay2 + "' "; break; } cursor.moveToFirst(); base_layout.setVisibility(View.VISIBLE); scrollView.setVisibility(View.VISIBLE); layout1.setVisibility(View.VISIBLE); layout2.setVisibility(View.VISIBLE); layout3.setVisibility(View.VISIBLE); layout4.setVisibility(View.VISIBLE); distance_distribution = new float[cursor.getCount()]; kcal_distribution = new int[cursor.getCount()]; time_distribution = new int[cursor.getCount()]; int i = 0; mTableLayout.removeAllViews(); while (!cursor.isAfterLast()) { TextView color = new TextView(mContext); TextView label = new TextView(mContext); TextView value = new TextView(mContext); LinearLayout.LayoutParams colorLayoutParams = new LinearLayout.LayoutParams( new LayoutParams(FunctionUtils.calculateDpFromPx(mContext, 20), FunctionUtils.calculateDpFromPx(mContext, 20))); colorLayoutParams.setMargins(0, 1, 5, 1); color.setLayoutParams(colorLayoutParams); label.setLayoutParams( new LayoutParams(FunctionUtils.calculateDpFromPx(mContext, 95), LayoutParams.WRAP_CONTENT)); label.setTypeface(null, Typeface.BOLD); label.setTextColor(Color.parseColor("#b5b5b5")); value.setLayoutParams(new LayoutParams(LayoutParams.MATCH_PARENT, LayoutParams.WRAP_CONTENT)); value.setTextColor(res.getColor(R.color.white)); color.setBackgroundColor(colors[i]); label.setText(activities[cursor.getInt(cursor.getColumnIndex("category_id")) - 1] + ":"); value.setText((isMetric ? String.valueOf(cursor.getFloat(cursor.getColumnIndex("sum_distance"))) + " " + getString(R.string.long_unit1_detail_1) + ", " : String.valueOf(FunctionUtils.customizedRound( ((cursor.getFloat(cursor.getColumnIndex("sum_distance")) * 1000f) / 1609f), 2)) + " " + getString(R.string.long_unit2_detail_1) + ", ") + String.valueOf((int) cursor.getFloat(cursor.getColumnIndex("sum_kcal"))) + " " + getString(R.string.tell_calories_setting_details) + ", " + String.valueOf(FunctionUtils.statisticsFormatTime(mContext, (long) cursor.getFloat(cursor.getColumnIndex("sum_time"))))); LinearLayout mLinearLayout = new LinearLayout(mContext); mLinearLayout .setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT)); mLinearLayout.setOrientation(0); mLinearLayout.addView(color); mLinearLayout.addView(label); mLinearLayout.addView(value); mTableLayout.addView(mLinearLayout); sum_distance = sum_distance + cursor.getFloat(cursor.getColumnIndex("sum_distance")); sum_kcal = sum_kcal + cursor.getInt(cursor.getColumnIndex("sum_kcal")); sum_time = sum_time + cursor.getInt(cursor.getColumnIndex("sum_time")); sum_up_accum_altitude = sum_up_accum_altitude + cursor.getInt(cursor.getColumnIndex("sum_up_accum_altitude")); sum_down_accum_altitude = sum_down_accum_altitude + cursor.getInt(cursor.getColumnIndex("sum_down_accum_altitude")); sum_avg_speed = sum_avg_speed + cursor.getFloat(cursor.getColumnIndex("sum_avg_speed")); sum_steps = sum_steps + cursor.getInt(cursor.getColumnIndex("sum_steps")); distance_distribution[i] = cursor.getFloat(cursor.getColumnIndex("sum_distance")); kcal_distribution[i] = cursor.getInt(cursor.getColumnIndex("sum_kcal")); time_distribution[i] = cursor.getInt(cursor.getColumnIndex("sum_time")); practices_counter = practices_counter + (int) cursor.getFloat(cursor.getColumnIndex("count_practices")); i++; cursor.moveToNext(); } String activity_query_part = ""; if (activity > 0) activity_query_part = " AND category_id = '" + activity + "'"; if (between_dates_query_part.length() > 0) { cursor = DBManager.CustomQuery(getString(R.string.routes_with_hr), "SELECT avg_hr FROM routes WHERE avg_hr > 0 AND " + between_dates_query_part + activity_query_part); } else { cursor = DBManager.CustomQuery(getString(R.string.routes_with_hr), "SELECT avg_hr FROM routes WHERE avg_hr > 0" + activity_query_part); } cursor.moveToFirst(); if (cursor.getCount() > 0) { while (!cursor.isAfterLast()) { sum_avg_hr = sum_avg_hr + cursor.getInt(cursor.getColumnIndex("avg_hr")); hr_practices_counter += 1; cursor.moveToNext(); } } text8.setText(""); if (between_dates_query_part.length() > 0) { if (activity > 0) activity_query_part = " AND category_id = '" + activity + "' "; cursor = DBManager.CustomQuery(getString(R.string.selecting_most_used_shoes), "SELECT shoe_id, COUNT(shoe_id) AS count_shoes " + "FROM routes " + "WHERE " + between_dates_query_part + activity_query_part + "GROUP BY shoe_id " + "ORDER BY count_shoes DESC"); } else { if (activity > 0) activity_query_part = "WHERE category_id = '" + activity + "' "; cursor = DBManager.CustomQuery(getString(R.string.selecting_most_used_shoes_in_data_range), "SELECT shoe_id, COUNT(shoe_id) AS count_shoes " + "FROM routes " + activity_query_part + "GROUP BY shoe_id " + "ORDER BY count_shoes DESC"); } cursor.moveToFirst(); if (cursor.getCount() > 0) { int shoe = cursor.getInt(cursor.getColumnIndex("shoe_id")); if (cursor.getCount() > 1) { int[] shoes = new int[cursor.getCount()]; int m = 0; while (!cursor.isAfterLast()) { shoes[m] = cursor.getInt(cursor.getColumnIndex("shoe_id")); m++; cursor.moveToNext(); } if (shoe == 0 && shoes.length > 1) shoe = shoes[1]; } if (shoe > 0) { cursor = DBManager.CustomQuery(getString(R.string.shoe_name), "SELECT name FROM shoes WHERE _id = '" + shoe + "'"); cursor.moveToFirst(); text8.setText(cursor.getString(cursor.getColumnIndex("name"))); } } text1.setText(String.valueOf(practices_counter)); text2.setText(String.valueOf(FunctionUtils.statisticsFormatTime(mContext, (long) sum_time))); text3.setText(isMetric ? String.valueOf(FunctionUtils.customizedRound(sum_distance, 2)) + " " + getString(R.string.long_unit1_detail_1) : String.valueOf(FunctionUtils.customizedRound(((sum_distance * 1000f) / 1609f), 2)) + " " + getString(R.string.long_unit2_detail_1)); text4.setText( isMetric ? String.valueOf(sum_up_accum_altitude) + " " + getString(R.string.long_unit1_detail_4) : String.valueOf((int) (sum_up_accum_altitude * 1.0936f)) + " " + getString(R.string.long_unit2_detail_4)); text5.setText(isMetric ? String.valueOf(sum_down_accum_altitude) + " " + getString(R.string.long_unit1_detail_4) : String.valueOf((int) (sum_down_accum_altitude * 1.0936f)) + " " + getString(R.string.long_unit2_detail_4)); if ((sum_avg_speed > 0) && (practices_counter > 0)) { text6.setText((isMetric ? String.valueOf(FunctionUtils.customizedRound((sum_avg_speed / practices_counter), 2)) + " " + getString(R.string.long_unit1_detail_2) : String.valueOf(FunctionUtils .customizedRound((((sum_avg_speed * 1000f) / 1609f) / practices_counter), 2)) + " " + getString(R.string.long_unit2_detail_2))); } else { text6.setText( getString(R.string.zero_value) + " " + (isMetric ? getString(R.string.long_unit1_detail_2) : mContext.getString(R.string.long_unit2_detail_2))); } text7.setText(String.valueOf( FunctionUtils.calculateRitm(mContext, sum_time, String.valueOf(sum_distance), isMetric, false)) + " " + (isMetric ? getString(R.string.long_unit1_detail_3) : mContext.getString(R.string.long_unit2_detail_3))); text9.setText(String.valueOf(sum_kcal) + " " + getString(R.string.tell_calories_setting_details)); text10.setText(String.valueOf(sum_steps)); if ((sum_avg_hr > 0) && (hr_practices_counter > 0)) { text11.setText(String.valueOf(sum_avg_hr / hr_practices_counter) + " " + getString(R.string.beats_per_minute)); } else { text11.setText(getString(R.string.zero_value) + " " + getString(R.string.beats_per_minute)); } if (sum_kcal > 0) { text12.setText(String.valueOf(sum_kcal / Constants.CHEESE_BURGER)); } else { text12.setText(getString(R.string.zero_value)); } if (sum_distance > 0) { text13.setText(String.valueOf( FunctionUtils.customizedRound((sum_distance / Constants.ALL_THE_WAY_AROUND_THE_WORLD), 3))); } else { text13.setText(getString(R.string.zero_with_three_decimal_places_value)); } if (sum_distance > 0) { double moon_distance = ((double) sum_distance) / ((double) Constants.TO_THE_MOON); text14.setText(String.valueOf( FunctionUtils.customizedRound(Float.parseFloat(String.valueOf(moon_distance)), 1))); } else { text14.setText(getString(R.string.zero_with_one_decimal_place_value)); } layout1.removeAllViews(); layout2.removeAllViews(); layout3.removeAllViews(); mChartView1 = null; mChartView2 = null; mChartView3 = null; for (int h = 0; h < distance_distribution.length; h++) { float percent = 0; if (distance_distribution[h] > 0) percent = (distance_distribution[h] * 100) / sum_distance; if (sum_distance == 0) percent = 100 / distance_distribution.length; distance_distribution[h] = percent; } for (int b = 0; b < kcal_distribution.length; b++) { int percent = 0; if (sum_kcal > 0) percent = (kcal_distribution[b] * 100) / sum_kcal; if (sum_kcal == 0) percent = 100 / kcal_distribution.length; kcal_distribution[b] = percent; } final CategorySeries distance_distributionSeries = new CategorySeries(""); for (int g = 0; g < distance_distribution.length; g++) { if (distance_distribution.length == 1) { distance_distributionSeries.add("", 100); } else { distance_distributionSeries.add("", distance_distribution[g]); } } final CategorySeries kcal_distributionSeries = new CategorySeries(""); for (int p = 0; p < kcal_distribution.length; p++) { if (kcal_distribution.length == 1) { kcal_distributionSeries.add("", 100); } else { kcal_distributionSeries.add("", kcal_distribution[p]); } } final CategorySeries time_distributionSeries = new CategorySeries(""); for (int l = 0; l < time_distribution.length; l++) { if (time_distribution.length == 1) { time_distributionSeries.add("", 100); } else { time_distributionSeries.add("", time_distribution[l]); } } DefaultRenderer defaultRenderer = new DefaultRenderer(); DefaultRenderer defaultRenderer2 = new DefaultRenderer(); DefaultRenderer defaultRenderer3 = new DefaultRenderer(); defaultRenderer.setShowLabels(false); defaultRenderer.setZoomButtonsVisible(false); defaultRenderer.setStartAngle(180); defaultRenderer.setDisplayValues(false); defaultRenderer.setClickEnabled(true); defaultRenderer.setInScroll(true); defaultRenderer.setShowLegend(false); defaultRenderer2.setShowLabels(false); defaultRenderer2.setZoomButtonsVisible(false); defaultRenderer2.setStartAngle(180); defaultRenderer2.setDisplayValues(false); defaultRenderer2.setClickEnabled(true); defaultRenderer2.setInScroll(true); defaultRenderer2.setShowLegend(false); defaultRenderer3.setShowLabels(false); defaultRenderer3.setZoomButtonsVisible(false); defaultRenderer3.setStartAngle(180); defaultRenderer3.setDisplayValues(false); defaultRenderer3.setClickEnabled(true); defaultRenderer3.setInScroll(true); defaultRenderer3.setShowLegend(false); for (int u = 0; u < distance_distribution.length; u++) { SimpleSeriesRenderer seriesRenderer = new SimpleSeriesRenderer(); seriesRenderer.setColor(colors[u]); seriesRenderer.setDisplayChartValues(true); seriesRenderer.setHighlighted(false); defaultRenderer.addSeriesRenderer(seriesRenderer); } for (int p = 0; p < kcal_distribution.length; p++) { SimpleSeriesRenderer seriesRenderer2 = new SimpleSeriesRenderer(); seriesRenderer2.setColor(colors[p]); seriesRenderer2.setDisplayChartValues(true); seriesRenderer2.setHighlighted(false); defaultRenderer2.addSeriesRenderer(seriesRenderer2); } for (int o = 0; o < distance_distribution.length; o++) { SimpleSeriesRenderer seriesRenderer3 = new SimpleSeriesRenderer(); seriesRenderer3.setColor(colors[o]); seriesRenderer3.setDisplayChartValues(true); seriesRenderer3.setHighlighted(false); defaultRenderer3.addSeriesRenderer(seriesRenderer3); } mChartView1 = ChartFactory.getPieChartView(mContext, distance_distributionSeries, defaultRenderer); mChartView2 = ChartFactory.getPieChartView(mContext, kcal_distributionSeries, defaultRenderer2); mChartView3 = ChartFactory.getPieChartView(mContext, time_distributionSeries, defaultRenderer3); layout1.addView(mChartView1); layout2.addView(mChartView2); layout3.addView(mChartView3); } else { base_layout.setVisibility(View.INVISIBLE); scrollView.setVisibility(View.INVISIBLE); layout1.setVisibility(View.INVISIBLE); layout2.setVisibility(View.INVISIBLE); layout3.setVisibility(View.INVISIBLE); layout4.setVisibility(View.INVISIBLE); } cursor.close(); DBManager.Close(); }
From source file:org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesAddedFunctions.java
public static Object getNextWorkingDay(Context actualContext, Scriptable actualObject, Object[] ArgList, Function FunctionContext) { // (Date dIn){ if (ArgList.length == 1) { try {//w ww .j a va2 s. c om if (isNull(ArgList[0])) { return null; } else if (isUndefined(ArgList[0])) { return Context.getUndefinedValue(); } java.util.Date dIn = (java.util.Date) Context.jsToJava(ArgList[0], java.util.Date.class); Calendar startDate = Calendar.getInstance(); startDate.setTime(dIn); startDate.add(Calendar.DATE, 1); while (startDate.get(Calendar.DAY_OF_WEEK) == Calendar.SATURDAY || startDate.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) { startDate.add(Calendar.DATE, 1); } return startDate.getTime(); } catch (Exception e) { throw Context.reportRuntimeError(e.toString()); } } else { throw Context.reportRuntimeError("The function call getNextWorkingDay requires 1 argument."); } }
From source file:net.chaosserver.timelord.data.ExcelDataReaderWriter.java
/** * Converts a given date to the date that marks the start of a week. * This is 12:00am on Monday./*from ww w. j a v a 2 s . c o m*/ * * @param inputDate the date to find the start of week for * @return 12:00am on Monday the week of the input */ protected Date convertToWeekStart(Date inputDate) { Calendar weekStartCalendar = Calendar.getInstance(); weekStartCalendar.setTime(inputDate); weekStartCalendar.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY); weekStartCalendar.set(Calendar.HOUR_OF_DAY, 0); weekStartCalendar.set(Calendar.MINUTE, 0); weekStartCalendar.set(Calendar.SECOND, 0); weekStartCalendar.set(Calendar.MILLISECOND, 0); // Since the day of week has changed from Monday it no // longer matches Java's natural interpretation. So if // the date is a Monday, than it's important to roll back // the week start by a week Calendar inputCalendar = Calendar.getInstance(); inputCalendar.setTime(inputDate); if (inputCalendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) { weekStartCalendar.add(Calendar.WEEK_OF_YEAR, -1); } return weekStartCalendar.getTime(); }
From source file:com.akretion.kettle.steps.terminatooor.ScriptValuesAddedFunctions.java
public static Object dateAdd(ScriptEngine actualContext, Bindings actualObject, Object[] ArgList, Object FunctionContext) { if (ArgList.length == 3) { try {//from w w w . j av a 2s. c om if (isNull(ArgList, new int[] { 0, 1, 2 })) return null; else if (isUndefined(ArgList, new int[] { 0, 1, 2 })) return undefinedValue; java.util.Date dIn = (java.util.Date) ArgList[0]; String strType = (String) ArgList[1]; int iValue = (int) (Integer) ArgList[2]; Calendar cal = Calendar.getInstance(); cal.setTime(dIn); if (strType.toLowerCase().equals("y")) cal.add(Calendar.YEAR, iValue); else if (strType.toLowerCase().equals("m")) cal.add(Calendar.MONTH, iValue); else if (strType.toLowerCase().equals("d")) cal.add(Calendar.DATE, iValue); else if (strType.toLowerCase().equals("w")) cal.add(Calendar.WEEK_OF_YEAR, iValue); else if (strType.toLowerCase().equals("wd")) { int iOffset = 0; while (iOffset < iValue) { int day = cal.get(Calendar.DAY_OF_WEEK); cal.add(Calendar.DATE, 1); if ((day != Calendar.SATURDAY) && (day != Calendar.SUNDAY)) iOffset++; } } else if (strType.toLowerCase().equals("hh")) cal.add(Calendar.HOUR, iValue); else if (strType.toLowerCase().equals("mi")) cal.add(Calendar.MINUTE, iValue); else if (strType.toLowerCase().equals("ss")) cal.add(Calendar.SECOND, iValue); return cal.getTime(); } catch (Exception e) { throw new RuntimeException(e.toString()); } } else { throw new RuntimeException("The function call dateAdd requires 3 arguments."); } }
From source file:com.aurel.track.move.ItemMoveBL.java
public static Integer getNumberOfSundaysFromInterval(Date startDateParam, Date endDateParam) { Calendar calendar = Calendar.getInstance(); calendar.setTime(startDateParam);// w w w . j a va 2 s. c om int numOfSunday = 0; while (DateTimeUtils.less(calendar.getTime(), endDateParam)) { if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) { numOfSunday++; } calendar.add(Calendar.DAY_OF_YEAR, 1); } return numOfSunday; }