similar to: very odd controller spec problem

Each Timesheet has an employee. An employee has a division and a location. I want to find all the timesheets with a status of 2. I then iterate over the timesheet collection and print the timesheet name, employee name, employee divison name, and employee location name. Like so: for t in Timesheet.find(:all,:conditions=>"status=2",:include=>:employee) puts timesheet.date

This is my first rails program and I?m having trouble figuring out how to show rows on the page when there may not be rows in the database. There are 3 tables, employees, cost_codes and timesheet, I will simplify them when describing them later on. When an employee logs in, I would like to pull up their timesheet, which should consist of one row per cost code. So timesheet would look a

The below query fails: Timesheet.joins(:time_entries).select("timesheets.*, sum(time_entries.worktime) as total").group("timesheets.start_date") The models have the following relations: Timesheet < AR has_many :activities, dependent: :destroy, inverse_of: :timesheet has_many :time_entries, through: :activities accepts_nested_attributes_for :activities,

I have a "Users" object and a "Timesheets" object. Each timesheet entry belongs to a User, which is selected from a drop-down list. The timesheet has a user_id field. (The user needs to have an option to select a different user due to the way our system works.) If i use the "select" object, which is bound to the Timesheet model, using this code: &lt;%= select

I''ve created the following function, and for testing have hardcoded the following values: def addNewRow @timesheet = Timesheet.find(:employee_id => ''1'', :cost_code_id => ''14'', :dept => ''007'', :ending_date =>

I have 2 models Timesheet and TimeEntry: class Timesheet < ActiveRecord::Base attr_accessible :status, :user_id, :time_entries_attributes has_many :time_entries, dependent: :destroy accepts_nested_attributes_for :time_entries, :reject_if => proc { |attributes| attributes[''worktime''].blank? } end class TimeEntry < ActiveRecord::Base attr_accessible :task_id,

I''m using accepts_nested_attributes as follows: class Timesheet < ActiveRecord::Base attr_accessible :status, :user_id, :start_date, :end_date, :activities_attributes has_many :activities, dependent: :destroy has_many :time_entries, through: :activities accepts_nested_attributes_for :activities, allow_destroy: true end class Activity < ActiveRecord::Base attr_accessible

I am trying to do things the proper rails way and use the auto generated id to refernce other tables. Now I''ve hit a wall in trying to write a query. timesheets: id, employee_id, code_id, ... values codes: id, job_number, code How can I show just the timesheets that belong to a specific job? I would need to check the codes table and look at the jobs, so I was thinking of something

lets say i have the following SQL in my database editor : When i paste it into rad rails i have to add quotes and the ''+'' symbol to the end of each line. It is very tedious. What is the best method? select timesheets.employee, sum(items.hours) as hours, sum(items.hours*timesheets.cost) as cost, sum(items.hours*timesheets.charge*decode(activities.chargetype,0,1,0)) as charge,

I want to use onsubmit for a form validation using javascript on remote_form_for for this i am doing something like this <% remote_form_for :timesheet, @timesheet, :url =>{:action => ''report_user''}, :html => {:onsubmit=>"return ValidateDate();" } do |f| %> // Form elements here <% end %> but it not works well. if condition return false

Hi, i''m writing a timesheet application in which i need to know when the holidays are, (bank holidays, etc) Is there a very clever way of getting this info that wouldnt require me to manually add it to my database?? Thanks Chris -- Posted via http://www.ruby-forum.com/.

Guys, We''re embarking on a new dev project, and I''m curious....why would one choose markaby over erb? I for one am no fan of the erb syntax, but aside from that it''s similar to other technologies I''ve used in the past: PHP, JSP, ASP, etc. Why would one choose markaby over erb? What are the benefits? What are the drawbacks? Is there anything remarkable

Hello all! I have two views (list_1 and list_2) that show a list of users in two different ways. In the views for these actions there is a link to edit a specific user properties (edit_user). That works fine, except that when I change the user I want to go back to the view that originated the request and not to the default list (list_1). Can anyone help me? Best regards, Hugo -- Posted via

Hi all, I am looking for some time tracking software for our small company. Does anyone knows if such project on rails exists? I need simple functionality such as recording spent time for employees and managing projects or tasks. Ideally, it would be possible to integrate it into Instiki and to some existing database. There are some other solutions, but it seems to me that RoR would be ideal

# File app/models/timesheet.rb, line 27 27: def totals 28: totals = Hash.new 29: totals["Monday"] = totals["Tuesday"] = totals["Wednesday"] = totals["Thursday"] = totals["Friday"] = totals["Saturday"] = totals["Sunday"] = totals["Totals"]=0 #initialise all to zero 31: 32: for item in

I have a list of TimeSheet objects from an ealier AR query, which I can sort by the full name of the user like so: @time_sheet_entries.sort! { |a,b| a.user.full_name <=> b.user.full_name } I can sort by the started time like so: @time_sheet_entries.sort! { |a,b| a.start_time <=> b.start_time } My question is how do I do a sort so that the list is sorted primarily by user.full_name

I''m working with a couple of slider objects on one page. I''m using onChange to do a couple of things. onChange passes the new value of the slider, but not the slider object itself. Has anybody found a way to get the object? More details: A simple example would be to do the following: Put multiple sliders on a page. Now, when a slider is moved, change it''s track

I can''t figure out how to pass a value from the following object build in the controller: class TimesheetsController < AC ... def new @timesheet = current_user.timesheets.new now = Date.today #generating 7 time entries: monday through sunday (now.beginning_of_week..now.end_of_week).step { |date| @timesheet.time_entries.build(:workdate; date) end end ... In the

How can I retrieve the values in my controller for the text field below? The "35" is the id of the item I want to update. <input type="text" id="timesheet_item_35_work_category" name="timesheet_item[35][work_category]" value="PROJECTS" /> My controller is: def update @timesheet = Timesheet.find(params[:id])

HI All, I need some open source timesheet management system for my company.Anybody knows some rails open source timesheet and project mgmt softwares? If so pls tell me. I really need them.Thanks in Advance. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to