The new album by John Tesh. In Stores Now

> Dust, Lust and Bacon

Hmm as the first suggested ART criteria, this one is a front-runner for the first $100!

I must say, though, that my preferences run more toward Dust, Lust, and Blinkin Lights

Or some such

Keep those criteria suggestions coming!

I smell talent!

I say we give one grant to lintymint

one to simran

and the third to someone that you pick

hows that harriet? that work for you?

import java.sql.ResultSet;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Vector;
import javax.servlet.http.HttpServletRequest;

public class Monthly extends Super {

public static final int tableIndex = tableIndex (L.Monthly);

public static final String day (int factor) {
SimpleDateFormat df = new SimpleDateFormat (S.dateFormat);
Calendar cdate = Calendar.getInstance();
String startdate = S.today (S.dateFormat);
try {
cdate.setTime (df.parse (startdate));
} catch (ParseException pe) {
// Error.logError (pe);
}
cdate.add (Calendar.DAY_OF_MONTH, (factor));
return (df.format (cdate.getTime()));
}
private static final String dayOfWeek ( ) {
SimpleDateFormat df = new SimpleDateFormat ("EEE");
Calendar today = Calendar.getInstance();
return (df.format (today.getTime()));
}
private static final Monthly dbprep (Monthly m) {
if (S.isnull (m.start)) {
m.start = S.zero;
}
if (S.isnull (m.a_id)) {
m.a_id = S.zero;
}
if (S.isnull (m.instance)) {
m.instance = S.zero;
}
if (S.isnull (m.finish)) {
m.finish = S.False;
}
if (S.datenull (m.date)) {
m.date = S.today();
} else if (m.date.length() == 5) {
m.date += "-2006";
}
if (S.datenull (m.hours)) {
m.hours = L.nul;
} else {
if (m.hours.length() == 5) {
m.hours += ":00";
}
}
m.month = H.removeLines (m.month);
return (m);
}
public static final Monthly displayprep (Monthly m) {
m.file = H.displayprep (m.file);
m.instance = H.displayprep (m.instance);
m.status = H.displayprep (m.status);
m.staff = H.displayprep (m.staff);
m.hours = H.displayprep (m.hours);
return (m);
}
public static String formcgi (Param pa, HttpServletRequest req) {
Monthly m = new Monthly();
m.date = Param.check (req, L.date);
m.hours = Param.check (req, L.hours);
m.archive = Param.check (req, L.archive);
m.month = Param.check (req, L.month);
m.status = Param.check (req, L.status);
m.start = Param.check (req, L.start);
m.instance = Param.check (req, L.instance);
m.finish = Param.check (req, L.finish);
if (pa.function.equals (L.Addcgi)) {
if (S.notnull (pa.rtype) && pa.rtype.equals (L.ref)) {
m.instance = Subcode.reference;
}
}
if (S.isnull (pa.error)) {
if (pa.function.equals (L.Editcgi)) {
pa.error = update (pa, m);
} else {
pa.error = insert (pa, m);
}
}
return (pa.error);
}
public static final String formdata (Param pa, HttpServletRequest req, User u) {
Monthly m = getItem (pa.idvalue);
String form = "";
String date = req.getParameter (L.date);
if (!S.datenull (date)) {
m.date = date;
} else {
form = H.edit (L.date, m.date, 12);
}
Param x = new Param();
form += H.edit (L.hours, m.hours, 12);
x = Param.init (Subcode.tableIndex);
x.rtype = L.location;
x.idvalue = m.instance;
form += select (x);
x = Param.init (Location.tableIndex);
x.rtype = L.cron;
x.idvalue = m.start;
form +=
select (x) +
H.editText (L.month, m.month) +
H.edit (L.status, m.status, 60);
if (S.isnull (m.m_id)) {
m.finish = S.False;
}
form +=
H.boolChoice (L.finish, m.finish);
if (S.notnull (m.m_id)) {
form += H.archive (m.archive);
}
form += H.hidden (L.rtype, pa.rtype);
return (form);
}
public static final String getdate (int factor) {
return (getdate (null, null, factor));
}
public static final String getdate (String startdate, String format, int factor) {
if (S.isnull (format)) {
format = S.dateFormat;
}
SimpleDateFormat df = new SimpleDateFormat (format);
Calendar cdate = Calendar.getInstance();
if (S.datenull (startdate)) {
startdate = S.today (format);
}
try {
cdate.setTime (df.parse (startdate));
} catch (ParseException pe) {
// Error.logError (pe);
}
cdate.add (Calendar.DAY_OF_MONTH, (factor));
return (df.format (cdate.getTime()));
}
public static final Monthly getfields (ResultSet rs) {
Monthly m = new Monthly();
try {
m.m_id = rs.getString (L.m_id);
m.month = rs.getString (L.month);
m.date = rs.getString (L.date);
m.staff = rs.getString (L.staff);
m.status = rs.getString (L.status);
m.instance = rs.getString (L.instance);
m.archive = rs.getString (L.archive);
m.a_id = rs.getString (L.a_id);
m.finish = rs.getString (L.finish);
m.hours = rs.getString (L.hours);

} catch (Exception e) {
// Error.logError (e);
}
return (m);
}
public static final Monthly getItem (String idvalue) {
Monthly m = new Monthly();
if (S.notnull (idvalue)) {
try {
ResultSet rs = Query.getRs (Query.getItem (tableIndex, idvalue));
rs.next();
m = getfields (rs);
rs.close();
} catch (Exception e) {
// Error.logError (e);
}
}
return (m);
}
private static final String insert (Param pa, Monthly m) {
//insert into table monthly (m_id, month, sequence, a_id, instance, function, file, status, date, logdate, start,
// finish, hours, staff, archive) values (3,5,3,"AccuTraq ","CA1 ","Import "," ","Done "," "," "," "," "
m = dbprep (m);
String values =
S.tdelim (m.month) +
S.delim (m.sequence) +
S.delim (m.a_id) +
S.tdelim (m.instance) +
S.tdelim (m.function) +
S.tdelim (m.file) +
S.tdelim (m.status) +
S.tdelim (S.date (m.date)) +
S.tdelim (S.today()) +
S.tdelim (m.start) +
S.tdelim (S.date (m.hours)) +
S.tdelim (m.staff);
S.text (S.False);
pa.error = insert (tableIndex, values);
return (pa.error);
}
private static final String util (Param pa, String values) {
//insert into table monthly (m_id, month, sequence, a_id, instance, function, file, status, date, logdate, start,
// finish, hours, staff, archive) values (3,5,3,"AccuTraq ","CA1 ","Import "," ","Done "," "," "," "," "
pa.error = insert (tableIndex, values);
return (pa.error);
}
public static final String list (Param pa, User u) {
Monthly m = new Monthly();
Query q = Query.setup (tableIndex);
String links[] = new String[7];
links[0] = H.resort (pa, L.month);
links[1] = H.resort (pa, L.a_id);
links[2] = H.resort (pa, L.date);
links[3] = H.resort (pa, L.staff);
links[4] = H.resort (pa, L.file);
links[5] = H.resort (pa, L.status);
links[6] = H.resort (pa, L.hours);
if (S.isnull (pa.sort) || pa.sort.equals (L.month)) {
links[0] = L.month;
q.sortfield = L.month;
} else if (pa.sort.equals (L.a_id)){
links[1] = L.a_id;
q.sortfield = L.a_id;
} else if (pa.sort.equals (L.date)) {
links[2] = L.date;
q.sortfield = S.desc (L.date);
} else if (pa.sort.equals (L.staff)) {
links[3] = L.staff;
q.sortfield = L.staff;
} else if (pa.sort.equals (L.file)) {
links[4] = L.file;
q.sortfield = L.file;
} else if (pa.sort.equals (L.status)){
links[5] = L.status;
q.sortfield = L.status;
} else if (pa.sort.equals (L.hours)) {
links[6] = L.hours;
q.sortfield = L.hours;
}
Vector v = getVector (pa, q);
int vsize = v.size();
StringBuffer buff = new StringBuffer (H.tablehead (links));
for (int j=0; j < vsize; j++) {
m = (Monthly) v.elementAt (j);
m = displayprep (m);
pa.idvalue = m.m_id;
buff.append (H.row +
H.cell (m.month + Param.editTag (pa)) +
H.cell (m.a_id) +
H.cell (m.date) +
H.cell (m.staff) +
H.cell (m.file) +
H.cell (m.status) +
H.cell (m.hours) +
H.rclose);
}
buff.append (H.tclose);
return (buff.toString());
}
private static final String printBrowse (Param pa, Vector v) {
StringBuffer buff = new StringBuffer();
int vsize = v.size();
String date = "";
String month = "";
Monthly m = new Monthly();
for (int j=0; j < vsize; j++) {
m = (Monthly) v.elementAt (j);
if (!S.datenull (m.date)) {
date = m.date.substring (5,7) + "/" + m.date.substring(8,10);
if (!S.datenull (m.hours)) {
date += " " + m.hours.substring (0,5);
}
date += " " + H.bold ("|") + " ";
} else date = "";
month = date + m.month;
if (S.notnull (m.start) && !m.start.equals (S.zero)) {
Location l = Location.getItem (m.start);
month += " " + l.location;
month = S.concat (month, l.contact, S.comma);
month = S.concat (month, l.addr1, S.comma);
month = S.concat (month, l.phone, S.comma);
}
pa.idvalue = m.m_id;
month += Param.editTag (pa);
if (S.notnull (m.status)) {
month += " " + H.makelink ("more", m.status);
}
buff.append (month + H.para);
}
return (buff.toString());
}
public static final Query setup (Param pa, String adjust) {
Query q = Query.setup (pa.tableIndex);
int iadj = 0;
if (S.notnull (adjust)) {
iadj = Integer.parseInt (adjust);
}
q.date1 = getdate (pa.start, null, iadj);
if (iadj != 0) {
q.date2 = getdate (pa.start, null, iadj + 28);
}
else {
q.date2 = getdate (pa.start, null, 365);
}
q.andClause = S.ne (L.instance, Subcode.christmas);
q.sortfield = S.delim (L.date) + L.hours;
return (q);
}
public static final Query setup (String rtype) {
Query q = Query.setup (tableIndex);
if (rtype.equals (L.interest)) {
q.joinClause = S.ijoin (L.Subcode, L.instance, L.Monthly);
q.whereClause = "(" + S.eq (S.qual (L.Monthly, L.instance), Subcode.music) + " or " +
S.eq (S.qual (L.Monthly, L.instance), Subcode.reading) + ")" +
" and " + S.qual (L.Monthly, L.date) + " is null ";
q.sortfield = S.delim (S.qual (L.Monthly, L.instance)) + L.month;
} else if (rtype.equals (L.ref)) {
q.joinClause = S.ijoin (L.Subcode, L.instance, L.Monthly);
q.whereClause = S.eq (S.qual (L.Monthly, L.instance), Subcode.reference);
q.sortfield = S.desc (S.qual (L.Monthly, L.date));
} else if (rtype.equals (L.idea)) {
q.joinClause = S.ijoin (L.Subcode, L.instance, L.Monthly);
q.whereClause = S.eq (S.qual (L.Monthly, L.instance), Subcode.idea);
q.sortfield = L.month;
} else {
q.sortfield = L.date;
}
return (q);
}
public static final String util (Param pa) {
pa.error = insert (pa, m);
}
public static final String weeks (Param pa, HttpServletRequest req, User u) {
String adjust = req.getParameter (L.adjust);
int iadj = 0;
if (adjust != null) {
iadj = Integer.parseInt (adjust);
}
int daysback = 0;
String day = dayOfWeek();
if (day.equals ("Sun")) {
daysback = -8;
}
else if (day.equals ("Mon")) {
daysback = -9;
}
else if (day.equals ("Tue")) {
daysback = -10;
}
else if (day.equals ("Wed")) {
daysback = -11;
}
else if (day.equals ("Thu")) {
daysback = -12;
}
else if (day.equals ("Fri")) {
daysback = -13;
}
else {
daysback = -14;
}
daysback += iadj;
Monthly m = new Monthly();
int count = 0;
Image i = new Image();
String cdate = "";
String oneday = "";
String datetext = "";
StringBuffer buff = new StringBuffer(
H.report +
H.row +
H.cell ("Sunday") +
H.cell ("Monday") +
H.cell ("Tuesday") +
H.cell ("Wednesday") +
H.cell ("Thursday") +
H.cell ("Friday") +
H.cell ("Saturday") +
H.rclose);
Vector vi = Image.randomSet (pa, L.block, 28);
int j = 0;
for (int week=0; week < 6; week++) {
buff.append (H.row);
for (int thisday=0; thisday < 7; thisday++) {
daysback += 1;
cdate = getdate (daysback);
Query q = Query.setup (tableIndex);
q.whereClause = S.eqt (L.date, cdate) + " and not " + L.finish;
q.sortfield = L.hours;
Vector v = getVector (pa, q);
int vsize = v.size();
datetext = getdate (null, "MM/dd", daysback);
if (u.admin || u.demo) {
datetext = H.servlet (datetext,
Param.function (L.Add) +
Param.table (tableIndex) +
Param.rtype (L.Weeks) +
Param.paramtag (L.date, cdate));
}
for (j=0; j < vsize; j++) {
m = (Monthly) v.elementAt (j);
if (S.isnull (m.hours)) {
m.hours = H.bullet + " ";
} else {
m.hours = m.hours.substring (0,5) + " ";
}
if (m.hours.equals ("00:00")) {
m.hours = H.bullet + " ";
}
if (m.month.length() > 30) {
m.month = m.month.substring (0, 30);
}
oneday += m.hours + m.month + H.br;
}
if (S.isnull (oneday)) {
if (week < 4) {
i = (Image) vi.elementAt (count);
oneday = Image.display (i, u);
count += 1;
}
}
buff.append (H.cell (datetext + H.br + oneday));
oneday = "";
j = 0;
}
buff.append (H.rclose);
}
buff.append (H.tclose);
String prev = H.servlet (L.prev, Param.function (L.Weeks) + Param.table (tableIndex) + Param.paramtag (L.adjust, -14 + iadj));
String next = H.servlet (L.next, Param.function (L.Weeks) + Param.table (tableIndex) + Param.paramtag (L.adjust, 14 + iadj));
pa.links = prev + next;
pa.noheader = true;
return (H.form (pa, u, H.grid (buff.toString())));
}
private static final String update (Param pa, Monthly m) {
m = dbprep (m);
String fieldlist =
S.delim (L.start, m.start) +
S.delim (L.instance, m.instance) +
S.delim (L.a_id, m.a_id) +
S.delim (S.eqd (L.date, m.date)) +
S.delim (S.eqd (L.hours, m.hours)) +
S.tdelim (L.status, m.status) +
S.tdelim (L.month, m.month) +
S.tdelim (L.archive, m.archive) +
S.eqt (L.finish, m.finish);
pa.error = Query.update (pa, fieldlist);
return (pa.error);
}
String m_id = "";
String month = "";
String sequence = "";
String a_id = "";
String instance = "";
String function = "";
String file = "";
String status = "";
String date = "";
String logdate = "";
String start = "";
String finish = "";
String hours = "";
String staff = "";
String archive = "";
}