یادآور در اندروید

[ehsan1222]

سلام

من یک آموزش در خصوص ساختن یادآور در سایتی دیدم و یه قسمتش رو متوجه نشدم. قسمت مورد نظر:

if (!"0".equals(tokens[1])) {
cal.set(Calendar.DAY_OF_WEEK, Integer.parseInt(tokens[1]));
interval = "0 0 7 0 0"; //week++;
}
ممنون




public class DbHelper extends SQLiteOpenHelper {

// private static final String TAG = "DbHelper";

public static final String DB_NAME = "remindme.db";
public static final int DB_VERSION = 1;

public static final SimpleDateFormat sdf = new SimpleDateFormat(RemindMe.DEFAULT_DATE_FORMAT);

public DbHelper(Context context) {
super(context, DB_NAME, null, DB_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(Alarm.getSql());
db.execSQL(AlarmTime.getSql());
db.execSQL(AlarmMsg.getSql());
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + Alarm.TABLE_NAME);
db.execSQL("DROP TABLE IF EXISTS " + AlarmTime.TABLE_NAME);
db.execSQL("DROP TABLE IF EXISTS " + AlarmMsg.TABLE_NAME);

onCreate(db);
}

public void shred(SQLiteDatabase db) {
db.delete(AlarmMsg.TABLE_NAME, AlarmMsg.COL_STATUS+" = ?", new String[]{AlarmMsg.CANCELLED});
}

private final String populateSQL = Util.concat("SELECT ",
"a."+Alarm.COL_FROMDATE+", ",
"a."+Alarm.COL_TODATE+", ",
"a."+Alarm.COL_RULE+", ",
"a."+Alarm.COL_INTERVAL+", ",
"at."+AlarmTime.COL_AT,
" FROM "+Alarm.TABLE_NAME+" AS a",
" JOIN "+AlarmTime.TABLE_NAME+" AS at",
" ON a."+Alarm.COL_ID+" = at."+AlarmTime.COL_ALARMID,
" WHERE a."+Alarm.COL_ID+" = ?");

public void populate(long alarmId, SQLiteDatabase db) {

String[] selectionArgs = {String.valueOf(alarmId)};
Cursor c = db.rawQuery(populateSQL, selectionArgs);

if (c.moveToFirst()) {
Calendar cal = Calendar.getInstance();
AlarmMsg alarmMsg = new AlarmMsg();
long now = System.currentTimeMillis();
db.beginTransaction();
try {
do {
Date fromDate = sdf.parse(c.getString(0)); //yyyy-M-d
cal.setTime(fromDate);

//at
String[] tokens = c.getString(4).split(":"); //hh:mm
cal.set(Calendar.HOUR_OF_DAY, Integer.parseInt(tokens[0]));
cal.set(Calendar.MINUTE, Integer.parseInt(tokens[1]));
cal.set(Calendar.SECOND, 0);
cal.set(Calendar.MILLISECOND, 0);

String rule = c.getString(2); //every day month
String interval = c.getString(3); //mm hh dd MM yy

if (rule == null && interval == null) {//one time
alarmMsg.reset();
alarmMsg.setAlarmId(alarmId);
alarmMsg.setDateTime(cal.getTimeInMillis());
if (alarmMsg.getDateTime() < now-Util.MIN)
alarmMsg.setStatus(AlarmMsg.EXPIRED);
alarmMsg.save(db);

} else {//repeating
if (rule != null) {
tokens = rule.split(" ");
interval = "0 0 1 0 0"; //date++;

//Day
if (!"0".equals(tokens[1])) {
cal.set(Calendar.DAY_OF_WEEK, Integer.parseInt(tokens[1]));
interval = "0 0 7 0 0"; //week++;
}
//Every
if (!"0".equals(tokens[0]) && "0".equals(tokens[1])) {
cal.set(Calendar.DATE, Integer.parseInt(tokens[0]));
interval = "0 0 0 1 0"; //month++;
}
//Month
if (!"0".equals(tokens[2])) {
cal.set(Calendar.MONTH, Integer.parseInt(tokens[2])-1);
interval = "0 0 0 0 1"; //year++;
}

while(cal.getTime().before(fromDate)) {
nextDate(cal, interval);
}
}

Date toDate = sdf.parse(c.getString(1));
toDate.setHours(0);
toDate.setMinutes(0);
toDate.setSeconds(0);
toDate.setDate(toDate.getDate()+1);
while(cal.getTime().before(toDate)) {
alarmMsg.reset();
alarmMsg.setAlarmId(alarmId);
alarmMsg.setDateTime(cal.getTimeInMillis());
if (alarmMsg.getDateTime() < now-Util.MIN)
alarmMsg.setStatus(AlarmMsg.EXPIRED);
alarmMsg.save(db);
nextDate(cal, interval);
}
}

} while(c.moveToNext());

db.setTransactionSuccessful();
} catch (Exception e) {
// Log.e(TAG, e.getMessage(), e);
} finally {
db.endTransaction();
}
}
c.close();
}
}