search for: cweek

I have a class Day with field date that represents a my sql date type, YYYY-MM-DD. The Ruby type Date class has method, cweek, that returns the calendar week that corresponds to a particular date. Ruby knows cweek, but MySQL has no knowledge of this value. How do I run a find on class Day, (Day.find :all ... ) with condition [date.cweek = ?, week]? This is not a sql search but a Ruby search of all Day objects and th...

So, I have a "schedules" table and a "hours" table, joined by a "hours_schedules" table. Think of the hours table as a category for when people will schedule themselves to work, which happens in weekly increments. At any given hour, there will be X number of people working. I need to represent each worker with an asterisk symbol in the weekly view. For example,