package com.ivalentin.margolariak; import android.graphics.Bitmap; import android.graphics.BitmapFactory; import android.util.Log; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Date; import java.util.Locale; /** * Final class that contains useful static values to be used across the app. * * @author Iñigo Valentin * */ final class GM { final class DB { final class QUERY { final class CREATE { static final String ACTIVITY = "CREATE TABLE IF NOT EXISTS activity (id INT, permalink VARCHAR, date DATETIME, city VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, after_es VARCHAR, after_en VARCHAR, after_eu VARCHAR, price INT, inscription INT, max_people INT, album INT, dtime DATETIME, comments INT);"; static final String ACTIVITY_COMMENT = "CREATE TABLE IF NOT EXISTS activity_comment (id INT, activity INT, text VARCHAR, dtime DATETIME, username VARCHAR, lang VARCHAR);"; static final String ACTIVITY_IMAGE = "CREATE TABLE IF NOT EXISTS activity_image (id INT, activity INT, image VARCHAR, idx INT);"; static final String ACTIVITY_ITINERARY = "CREATE TABLE IF NOT EXISTS activity_itinerary (id INT, activity INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, start DATETIME, end DATETIME, place INT);"; static final String ACTIVITY_TAG = "CREATE TABLE IF NOT EXISTS activity_tag (activity INT, tag VARCHAR);"; static final String ALBUM = "CREATE TABLE IF NOT EXISTS album (id INT, permalink VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, open INT, time DATETIME);"; static final String FESTIVAL = "CREATE TABLE IF NOT EXISTS festival (id INT, year INT, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, summary_es VARCHAR, summary_en VARCHAR, summary_eu VARCHAR, img VARCHAR);"; static final String FESTIVAL_DAY = "CREATE TABLE IF NOT EXISTS festival_day (id INT, date DATETIME, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, price INT);"; static final String FESTIVAL_EVENT = "CREATE TABLE IF NOT EXISTS festival_event (id INT, gm INT, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, host INT, place INT, start DATETIME, end DATETIME);"; static final String FESTIVAL_EVENT_IMAGE = "CREATE TABLE IF NOT EXISTS festival_event_image (id INT, event INT, image VARCHAR, idx INT);"; static final String FESTIVAL_OFFER = "CREATE TABLE IF NOT EXISTS festival_offer (id INT, year INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, days INT, price INT);"; static final String LOCATION = "CREATE TABLE IF NOT EXISTS location (id INT, dtime DATETIME, lat FLOAT, lon FLOAT, manual INT);"; static final String NOTIFICATION = "CREATE TABLE IF NOT EXISTS notification (id INT, dtime DATETIME, duration INT, action VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, internal INT);"; static final String PEOPLE = "CREATE TABLE IF NOT EXISTS people (id INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, link VARCHAR);"; static final String PHOTO = "CREATE TABLE IF NOT EXISTS photo (id INT, file VARCHAR, permalink VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, dtime DATETIME, uploaded DATETIME, place INT, width INT, height INT, size INT, username VARCHAR);"; static final String PHOTO_ALBUM = "CREATE TABLE IF NOT EXISTS photo_album (photo INT, album INT);"; static final String PHOTO_COMMENT = "CREATE TABLE IF NOT EXISTS photo_comment (id INT, photo INT, text VARCHAR, dtime DATETIME, username VARCHAR, lang VARCHAR);"; static final String PLACE = "CREATE TABLE IF NOT EXISTS place (id INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, address_es VARCHAR, address_en VARCHAR, address_eu VARCHAR, cp VARCHAR, lat FLOAT, lon FLOAT);"; static final String POST = "CREATE TABLE IF NOT EXISTS post (id INT, permalink VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, dtime DATETIME, comments INT, username VARCHAR);"; static final String POST_COMMENT = "CREATE TABLE IF NOT EXISTS post_comment (id INT, post INT, text VARCHAR, dtime DATETIME, username VARCHAR, lang VARCHAR);"; static final String POST_IMAGE = "CREATE TABLE IF NOT EXISTS post_image (id INT, post INT, image VARCHAR, idx INT);"; static final String POST_TAG = "CREATE TABLE IF NOT EXISTS post_tag (post INT, tag VARCHAR);"; static final String SETTINGS = "CREATE TABLE IF NOT EXISTS settings (name VARCHAR, value VARCHAR);"; static final String SPONSOR = "CREATE TABLE IF NOT EXISTS sponsor (id INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, image VARCHAR, address_es VARCHAR, address_en VARCHAR, address_eu VARCHAR, link VARCHAR, lat FLOAT, lon FLOAT);"; static final String VERSION = "CREATE TABLE IF NOT EXISTS version (section VARCHAR, version INT);"; } final class DROP { static final String ACTIVITY = "DROP TABLE activity;"; static final String ACTIVITY_COMMENT = "DROP TABLE activity_comment;"; static final String ACTIVITY_IMAGE = "DROP TABLE activity_image;"; static final String ACTIVITY_ITINERARY = "DROP TABLE activity_itinerary;"; static final String ACTIVITY_TAG = "DROP TABLE activity_tag;"; static final String ALBUM = "DROP TABLE album;"; static final String FESTIVAL = "DROP TABLE festival;"; static final String FESTIVAL_DAY = "DROP TABLE festival_day;"; static final String FESTIVAL_EVENT = "DROP TABLE festival_event;"; static final String FESTIVAL_EVENT_IMAGE = "DROP TABLE festival_event_image;"; static final String FESTIVAL_OFFER = "DROP TABLE festival_offer;"; static final String LOCATION = "DROP TABLE location;"; static final String NOTIFICATION = "DROP TABLE notification;"; static final String PEOPLE = "DROP TABLE people;"; static final String PHOTO = "DROP TABLE photo;"; static final String PHOTO_ALBUM = "DROP TABLE photo_album;"; static final String PHOTO_COMMENT = "DROP TABLE photo_comment;"; static final String PLACE = "DROP TABLE place;"; static final String POST = "DROP TABLE post;"; static final String POST_COMMENT = "DROP TABLE post_comment;"; static final String POST_IMAGE = "DROP TABLE post_image;"; static final String POST_TAG = "DROP TABLE post_tag;"; static final String SETTINGS = "DROP TABLE settings;"; static final String SPONSOR = "DROP TABLE sponsor;"; static final String VERSION = "DROP TABLE version;"; } final class RECREATE { static final String ACTIVITY = GM.DB.QUERY.DROP.ACTIVITY + GM.DB.QUERY.CREATE.ACTIVITY; static final String ACTIVITY_COMMENT = GM.DB.QUERY.DROP.ACTIVITY_COMMENT + GM.DB.QUERY.CREATE.ACTIVITY_COMMENT; static final String ACTIVITY_IMAGE = GM.DB.QUERY.DROP.ACTIVITY_IMAGE + GM.DB.QUERY.CREATE.ACTIVITY_IMAGE; static final String ACTIVITY_ITINERARY = GM.DB.QUERY.DROP.ACTIVITY_ITINERARY + GM.DB.QUERY.CREATE.ACTIVITY_ITINERARY; static final String ACTIVITY_TAG = GM.DB.QUERY.DROP.ACTIVITY_TAG + GM.DB.QUERY.CREATE.ACTIVITY_TAG; static final String ALBUM = GM.DB.QUERY.DROP.ALBUM + GM.DB.QUERY.CREATE.ALBUM; static final String FESTIVAL = GM.DB.QUERY.DROP.FESTIVAL + GM.DB.QUERY.CREATE.FESTIVAL; static final String FESTIVAL_DAY = GM.DB.QUERY.DROP.FESTIVAL_DAY + GM.DB.QUERY.CREATE.FESTIVAL_DAY; static final String FESTIVAL_EVENT = GM.DB.QUERY.DROP.FESTIVAL_EVENT + GM.DB.QUERY.CREATE.FESTIVAL_EVENT; static final String FESTIVAL_EVENT_IMAGE = GM.DB.QUERY.DROP.FESTIVAL_EVENT_IMAGE + GM.DB.QUERY.CREATE.FESTIVAL_EVENT_IMAGE; static final String FESTIVAL_OFFER = GM.DB.QUERY.DROP.FESTIVAL_OFFER + GM.DB.QUERY.CREATE.FESTIVAL_OFFER; static final String LOCATION = GM.DB.QUERY.DROP.LOCATION + GM.DB.QUERY.CREATE.LOCATION; static final String NOTIFICATION = GM.DB.QUERY.DROP.NOTIFICATION + GM.DB.QUERY.CREATE.NOTIFICATION; static final String PEOPLE = GM.DB.QUERY.DROP.PEOPLE + GM.DB.QUERY.CREATE.PEOPLE; static final String PHOTO = GM.DB.QUERY.DROP.PHOTO + GM.DB.QUERY.CREATE.PHOTO; static final String PHOTO_ALBUM = GM.DB.QUERY.DROP.PHOTO_ALBUM + GM.DB.QUERY.CREATE.PHOTO_ALBUM; static final String PHOTO_COMMENT = GM.DB.QUERY.DROP.PHOTO_COMMENT + GM.DB.QUERY.CREATE.PHOTO_COMMENT; static final String PLACE = GM.DB.QUERY.DROP.PLACE + GM.DB.QUERY.CREATE.PLACE; static final String POST = GM.DB.QUERY.DROP.POST + GM.DB.QUERY.CREATE.POST; static final String POST_COMMENT = GM.DB.QUERY.DROP.POST_COMMENT + GM.DB.QUERY.CREATE.POST_COMMENT; static final String POST_IMAGE = GM.DB.QUERY.DROP.POST_IMAGE + GM.DB.QUERY.CREATE.POST_IMAGE; static final String POST_TAG = GM.DB.QUERY.DROP.POST_TAG + GM.DB.QUERY.CREATE.POST_TAG; static final String SETTINGS = GM.DB.QUERY.DROP.SETTINGS + GM.DB.QUERY.CREATE.SETTINGS; static final String SPONSOR = GM.DB.QUERY.DROP.SPONSOR + GM.DB.QUERY.CREATE.SPONSOR; static final String VERSION = GM.DB.QUERY.DROP.VERSION + GM.DB.QUERY.CREATE.VERSION; } } } static final String CLIENT = "com.ivalentin.margolariak"; /** * Address where the web server is */ static final String SERVER = "http://margolariak.com"; static final String SERVER_SYNC = "/API/v1/sync.php"; static final String SERVER_SYNC_KEY_CLIENT = "client"; static final String SERVER_SYNC_KEY_USER = "user"; static final String SERVER_SYNC_KEY_ACTION = "action"; static final String SERVER_SYNC_KEY_SECTION = "section"; static final String SERVER_SYNC_KEY_VERSION = "version"; static final String SERVER_SYNC_KEY_FOREGROUND = "foreground"; static final String SERVER_SYNC_KEY_FORMAT = "format"; static final String SERVER_SYNC_KEY_LANG = "lang"; static final String SERVER_SYNC_VALUE_ACTION = "sync"; static final String SERVER_SYNC_VALUE_SECTION = "all"; static final String SERVER_SYNC_VALUE_FORMAT = "json"; /** * Code for the location permission request */ static final int PERMISSION_LOCATION = 1; /** * Period of time (in seconds) at the end of witch the app will perform a sync. */ static final int PERIOD_SYNC = 20 * 60 * 1000; /** * Name of the preference to store the user code with. */ static final String USER_CODE = "prefcode"; /** * Constant to diferentiate schedules". */ static final String SCHEDULE = "schedule"; /** * Constant to set extras on the main intent. */ static final String EXTRA_TITLE = "title"; /** * Constant to set extras on the main intent. */ static final String EXTRA_TEXT = "text"; /** * Constant to set extras on the main intent. */ static final String EXTRA_ACTION = "action"; /** * Value for {@see GM.EXTRA_ACTION} that opens the lablanca section. */ static final String EXTRA_ACTION_LABLANCA = "lablanca"; /** * Value for {@see GM.EXTRA_ACTION} that opens the official schedule. */ static final String EXTRA_ACTION_CITYSCHEDULE = "cityschedule"; /** * Value for {@see GM.EXTRA_ACTION} that opens the GM schedule. */ static final String EXTRA_ACTION_GMSCHEDULE = "gmschedule"; /** * Value for {@see GM.EXTRA_ACTION} that opens the location secton. */ static final String EXTRA_ACTION_LOCATION = "location"; /** * Value for {@see GM.EXTRA_ACTION} that opens the blog. */ static final String EXTRA_ACTION_BLOG = "blog"; /** * Value for {@see GM.EXTRA_ACTION} that opens the activities section. */ static final String EXTRA_ACTION_ACTIVITIES = "activities"; /** * Value for {@see GM.EXTRA_ACTION} that opens the gallery section. */ static final String EXTRA_ACTION_GALLERY = "gallery"; /** * Constant for section "Home". */ static final byte SECTION_HOME = 0; /** * Constant for La Blanca section "Location". */ static final byte SECTION_LOCATION = 1; /** * Constant for section "La Blanca". */ static final byte SECTION_LABLANCA = 2; /** * Constant for La Blanca section "Festival schedule". */ static final byte SECTION_LABLANCA_SCHEDULE = 20; /** * Constant for La Blanca section "Gasteizko Margolariak Schedule". */ static final byte SECTION_LABLANCA_GM_SCHEDULE = 21; /** * Constant for section "Activities". */ static final byte SECTION_ACTIVITIES = 3; /** * Constant for section "Blog". */ static final byte SECTION_BLOG = 4; /** * Constant for section "Gallery". */ static final byte SECTION_GALLERY = 5; /** * Name of the preference group for the app. */ static final String PREF = "gmpreferences"; /** * Name of the preference to store the database version with. */ static final String PREF_DB_VERSION = "prefDbVersion"; /** * Name of the preference to store the setting that allows user to upload comments. */ static final String PREF_DB_PHOTOS = "prefDbPhotos"; /** * Name of the preference that indicates if we are on festivals. */ static final String PREF_DB_FESTIVALS = "prefDbFestivals"; /** * Name of the preference indicating if the user wants to to receive notifications intended for the general public. */ static final String PREF_NOTIFICATION = "prefNotification"; /** * Default value of the preference indicating if the user wants to to receive notifications intended for the general public. */ static final int DEFAULT_PREF_NOTIFICATION = 1; /** * Header of a preference to indicate received notifications. */ static final String NOTIFICATION_SEEN_ ="notificationSeen"; /** * Default value for the {//@link GM.PREF_DB_VERSION} preference */ static final int DEFAULT_PREF_DB_VERSION = -2; /** * Name of the preference to store GM location's latitude. */ static final String PREF_GM_LATITUDE = "gmlat"; /** * Name of the preference to store GM location's longitude. */ static final String PREF_GM_LONGITUDE = "gmlon"; /** * Name of the preference to store GM last location timestamp. */ static final String PREF_GM_LOCATION = "gmlocationtime"; /** * Name of the preference to store GM last location timestamp. */ static final String DEFAULT_PREF_GM_LOCATION = "19700101000000"; /** * Name of the preference indicating if the user wants to perform background syncs. */ static final String PREFERENCE_SYNC_SYNC = "pref_sync_sync"; /** * Default value for PREFERENCE_SYNC_SYNC. */ static final boolean DEFAULT_PREFERENCE_SYNC_SYNC = true; /** * Name of the preference indicating if the user wants to to receive notifications intended for the general public. */ static final String PREFERENCE_SYNC_NOTIFICATIONS = "pref_sync_notifications"; /** * Default value for PREFERENCE_SYNC_NOTIFICATIONS. */ static final boolean DEFAULT_PREFERENCE_SYNC_NOTIFICATIONS = true; /** * Name of the SharedPreference that stores how many kb have been sent in the foreground. */ static final String STORAGE_TRAFFIC_FG_SENT = "storage_traffic_fg_sent"; /** * Name of the SharedPreference that stores how many kb have been received in the foreground. */ static final String STORAGE_TRAFFIC_FG_RECEIVED = "storage_traffic_fg_received"; /** * Name of the SharedPreference that stores how many kb have been sent in the background. */ static final String STORAGE_TRAFFIC_BG_SENT = "storage_traffic_bg_received"; /** * Name of the SharedPreference that stores how many kb have been received in the background. */ static final String STORAGE_TRAFFIC_BG_RECEIVED = "storage_traffic_bg_received"; static final String KEY_PREFERENCE_SYNC = "preference_key_sync"; static final String KEY_PREFERENCE_NOTIFICATION = "preference_key_notification"; static final String KEY_PREFERENCE_DATA = "preference_key_data"; static final String KEY_PREFERENCE_VERSION = "preference_key_version"; static final String KEY_PREFERENCE_SOURCE = "preference_key_source"; static final String KEY_PREFERENCE_FEEDBACK = "preference_key_feedback"; static final int INTERVAL_LOCATION = 240000; //4 min static final int INTERVAL_SYNC_FESTIVALS = 600000; //10 min static final int INTERVAL_SYNC_NO_FESTIVALS = 3600000; //60 min /** * Name of the database */ static final String DB_NAME = "gm"; /** * The desired accuracy of the GPS coordinates, used to provide location updates, in meters. */ static final int LOCATION_ACCURACY_SPACE = 10; /** * The desired accuracy of the GPS coordinates, used to provide location updates, in milliseconds. */ static final int LOCATION_ACCURACY_TIME = 10000; /** * Dimensions of the images in the database. */ static final int IMG_MINIATURE = 340; static final int IMG_PREVIEW = 600; static final int IMG_THUMB = 180; static final int IMG_VIEW = 800; /** * Gets the language code for sql queries. * Only three values can be returned: es, eu, en. * Defaults to es. * * @return Language two-letter code */ public static String getLang(){ String currLang = Locale.getDefault().getISO3Language();//getDisplayLanguage(); switch (currLang){ case "eng": currLang = "en"; break; case "eus": currLang = "eu"; break; default: currLang = "es"; } return currLang; } /** * Formats a datetime format strings and returns a human readable date, depending on the language * * @param dateString String in a datetime format * @param lang Language (es, en, eu) * @param includeTime Also returns the hour and minutes * * @return The fragment view * * @see android.support.v4.app.Fragment#onCreateView(android.view.LayoutInflater, android.view.ViewGroup, android.os.Bundle) */ public static String formatDate(String dateString, String lang, boolean includeTime){ String output = ""; String dayNameEs[] = {"dummy", "Domingo", "Lunes", "Martes", "Miércoles", "Jueves", "Viernes", "Sábado"}; String dayNameEn[] = {"dummy", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"}; String dayNameEu[] = {"dummy", "igandea", "astelehena", "asteartea", "asteazkena", "osteguna", "ostirala", "larumbata"}; String monthNameEs[] = {"enero", " febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre"}; String monthNameEn[] = {"January", "February", "March", "April", "May", "June", "July", "Augost", "September", "Octuber", "November", "December"}; String monthNameEu[] = {"urtarrilaren", "otsailaren", "martxoaren", "apirilaren", "maiatzaren", "ekainaren", "uztailaren", "abuztuaren", "irailaren", "urriaren", "azaroaren", "abenduaren"}; if (!lang.equals("es") && !lang.equals("eu")){ lang = "en"; } DateFormat format = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss", Locale.ENGLISH); SimpleDateFormat df; Date date; try{ date = format.parse(dateString); df = new SimpleDateFormat("yyyy", Locale.US); String year = df.format(date); df = new SimpleDateFormat("hh:mm", Locale.US); String time = df.format(date); String dayName, monthName; Calendar calendar = Calendar.getInstance(); calendar.setTime(date); int dayNumber = calendar.get(Calendar.DAY_OF_WEEK); int day = calendar.get(Calendar.DAY_OF_MONTH); int monthNumber = calendar.get(Calendar.MONTH); switch (lang){ case "es": dayName = dayNameEs[dayNumber]; monthName = monthNameEs[monthNumber]; output = dayName + ", " + day + " de " + monthName + " de " + year; if (includeTime){ output = output + " a las " + time; } break; case "eu": dayName = dayNameEu[dayNumber]; monthName = monthNameEu[monthNumber]; output = year + "ko" + monthName + " " + day + "an, " + dayName; if (includeTime){ output = output + " " + time + "etan"; } break; default: dayName = dayNameEn[dayNumber]; monthName = monthNameEn[monthNumber]; output = dayName + ", " + monthName + " " + day + ", " + year; if (includeTime){ output = output + " " + time; } break; } } catch(Exception ex){ Log.e("Date format error", ex.toString()); } return output; } public static Bitmap decodeSampledBitmapFromFile(String path, int size) { // BEST QUALITY MATCH // First decode with inJustDecodeBounds=true to check dimensions final BitmapFactory.Options options = new BitmapFactory.Options(); options.inJustDecodeBounds = true; BitmapFactory.decodeFile(path, options); // Calculate inSampleSize // Raw height and width of image final int height = options.outHeight; final int width = options.outWidth; options.inPreferredConfig = Bitmap.Config.RGB_565; int inSampleSize = 1; if (height > size) { inSampleSize = Math.round((float)height / (float)size); } int expectedWidth = width / inSampleSize; if (expectedWidth > size) { //if(Math.round((float)width / (float)reqWidth) > inSampleSize) // If bigger SampSize.. inSampleSize = Math.round((float)width / (float)size); } options.inSampleSize = inSampleSize; // Decode bitmap with inSampleSize set options.inJustDecodeBounds = false; return BitmapFactory.decodeFile(path, options); } }