timetable.rb

#timetable_controller.rb
class TimetableController < ApplicationController

  before_filter :login_required

  before_filter :protect_other_student_data

  filter_access_to :all

  

  def generate

    @batches = Batch.active

    if request.post?

      @batch = Batch.find params[:timetable][:batch_id]

      @config = Configuration.find_by_config_key('StudentAttendanceType')

      @start_date = @batch.start_date.to_date

      @end_date = @batch.end_date.to_date

      holiday = []

      @holiday = Weekday.find_all_by_batch_id(@batch.id)

      @holiday = Weekday.default if @holiday.empty?

      flash[:notice] = 'You have set the weekdays!' if @holiday.empty?

      @holiday.each do |h|

        holiday.push h.weekday

      end

      set = 0

      (@start_date..@end_date).each do |d|

        w = d.wday.to_s

        @period = PeriodEntry.find_all_by_month_date_and_batch_id(d,@batch.id)

        if @period.empty?

          unless Event.is_a_holiday?(d)

            if holiday.include? w

              unless @config.config_value == 'Daily'

                @timetable = TimetableEntry.find_all_by_batch_id_and_week_day_id(@batch.id, d.wday)

                @timetable.each do |t|

                  PeriodEntry.create(:month_date=> d, :batch_id => @batch.id, :subject_id => t.subject_id, :class_timing_id => t.class_timing_id, :employee_id => t.employee_id)

                  set = 2

                end

              else

                PeriodEntry.create(:month_date=> d, :batch_id => @batch.id)

                set = 2

              end

            end

          end

        else

          unless @config.config_value == 'Daily'

            if d >= Date.today

              @timetable = TimetableEntry.find_all_by_batch_id_and_week_day_id(@batch.id, d.wday)

              @period.each do |p|

                @timetable.each do |t|

                  if t.class_timing_id == p.class_timing_id

                    unless t.subject_id == p.subject_id

                      PeriodEntry.update(p.id, :month_date=> d, :batch_id => @batch.id, :subject_id => t.subject_id, :class_timing_id => t.class_timing_id, :employee_id => t.employee_id)

                      set = 1

                      



                    end

                  end

                end



              end

            end

          end

        end

          

        if set == 0

          flash[:notice] = 'Timetable has already been published'

        elsif set == 1

          flash[:notice] = 'Timetable updated'

        else

          flash[:notice] = 'Timetable created successfully'

        end

      end

    

      @config = Configuration.available_modules

      if @config.include?('HR')

        redirect_to :action=>"edit2", :id => @batch.id

      else

        redirect_to :action=>"edit", :id => @batch.id

      end

    end

  end



  def extra_class

    @config = Configuration.available_modules

    unless   params[:extra_class].nil?

      @date = params[:extra_class][:date].to_date

      @batch = Batch.find(params[:extra_class][:batch_id])

      @period_entry = PeriodEntry.find_all_by_batch_id_and_month_date(@batch.id, @date)

      render (:update) do |page|

        page.replace_html 'extra-class-form', :partial => "extra_class_form"

      end

    end

      

  end

  def extra_class_edit

    @config = Configuration.available_modules

    @period_id = params[:id]

    @period_entry = PeriodEntry.find(@period_id)

    @subjects = Subject.find_all_by_batch_id(@period_entry.batch_id,:conditions=>'is_deleted=false')

    @employee = EmployeesSubject.find_all_by_subject_id(@period_entry.subject_id)

  end

  def list_employee_by_subject

    @period_id = params[:period_id]

    @subject = Subject.find(params[:subject_id])

    @employee = EmployeesSubject.find_all_by_subject_id(@subject.id)

    render (:update) do |page|

      page.replace_html "employee-update-#{@period_id}", :partial => "list_employee_by_subject"

    end

  end

  def save_extra_class

    @period = PeriodEntry.find(params[:period_entry][:period_id])

    PeriodEntry.update(@period.id, :subject_id => params[:period_entry][:subject_id], :employee_id => params[:period_entry][:employee_id])

    @period = PeriodEntry.find(params[:period_entry][:period_id])

    render (:update) do |page|

      page.replace_html "tr-extra-class-#{@period.id}", :partial => 'extra_class_update'

    end

  end



  def timetable

    @config = Configuration.available_modules

    @batches = Batch.active

    unless params[:next].nil?

      @today = params[:next].to_date

      render (:update) do |page|

        page.replace_html "timetable", :partial => 'table'

      end

    else

      @today = Date.today

    end

  end



  def delete_subject

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    @errors = {"messages" => []}

    tte = TimetableEntry.update(params[:id], :subject_id => nil)

    @timetable = TimetableEntry.find_all_by_batch_id(tte.batch_id)

    render :partial => "edit_tt_multiple", :with => @timetable

  end



  def edit

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    @errors = {"messages" => []}

    @batch = Batch.find(params[:id])

    @timetable = TimetableEntry.find_all_by_batch_id(params[:id])

    @class_timing = ClassTiming.find_all_by_batch_id(@batch.id, :conditions => "is_break = false")

    if @class_timing.empty?

      @class_timing = ClassTiming.default

    end

    @day = Weekday.find_all_by_batch_id(@batch.id)

    if @day.empty?

      @day = Weekday.default

    end

    @subjects = Subject.find_all_by_batch_id(@batch.id, :conditions=>["elective_group_id IS NULL AND is_deleted = false"])

  end



  def select_class

    @batches = Batch.active

    if request.post?

      unless params[:timetable_entry][:batch_id].empty?

        @batch = Batch.find(params[:timetable_entry][:batch_id])

        @class_timings = ClassTiming.find_all_by_batch_id(@batch.id)

        if @class_timings.empty?

          @class_timings = ClassTiming.default

        end

        @days = Weekday.find_all_by_batch_id(@batch.id)

        if @days.empty?

          @days = Weekday.default

        end

        @days.each do |d|

          @class_timings.each do |p|

            TimetableEntry.create(:batch_id=>@batch.id, :week_day_id => d.weekday, :class_timing_id => p.id) \

              if TimetableEntry.find_by_batch_id_and_week_day_id_and_class_timing_id(@batch.id, d.weekday, p.id).nil?

          end

        end



        redirect_to :action => "edit", :id => @batch.id

      else

        flash[:notice]="Select a batch to continue"

        redirect_to :action => "select_class"

      end

    end

  end



  def weekdays

    @batches = Batch.active

  end



  def tt_entry_update

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    @errors = {"messages" => []}

    subject = Subject.find(params[:sub_id])

    TimetableEntry.update(params[:tte_id], :subject_id => params[:sub_id])

    @timetable = TimetableEntry.find_all_by_batch_id(subject.batch_id)

    render :partial => "edit_tt_multiple", :with => @timetable

  end



  def tt_entry_noupdate

    render :update => "error_div_#{params[:tte_id]}", :text => "Cancelled."

  end



  def update_multiple_timetable_entries

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    subject = Subject.find(params[:subject_id])

    tte_ids = params[:tte_ids].split(",").each {|x| x.to_i}

    course = subject.batch

    @validation_problems = {}



    tte_ids.each do |tte_id|

      errors = { "info" => {"sub_id" => subject.id, "tte_id" => tte_id},

        "messages" => [] }



      # check for weekly subject limit.

      errors["messages"] << "Weekly subject limit reached." \

        if subject.max_weekly_classes <= TimetableEntry.count(:conditions => "subject_id = #{subject.id}")



      if errors["messages"].empty?

        TimetableEntry.update(tte_id, :subject_id => subject.id)

      else

        @validation_problems[tte_id] = errors

      end

    end



    @timetable = TimetableEntry.find_all_by_batch_id(course.id)

    render :partial => "edit_tt_multiple", :with => @timetable

  end



  def view

    @courses = Batch.active

  end



  def student_view

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    student = Student.find(params[:id])

    @batch = student.batch

    @timetable = TimetableEntry.find_all_by_batch_id(@batch.id)

    @class_timing = ClassTiming.find_all_by_batch_id(@batch.id, :conditions => "is_break = false")

    if @class_timing.empty?

      @class_timing = ClassTiming.default

    end

    @day = Weekday.find_all_by_batch_id(@batch.id)

    if @day.empty?

      @day = Weekday.default

    end

    @subjects = Subject.find_all_by_batch_id(@batch.id)

  end



  def update_timetable_view

    if params[:course_id] == ""

      render :update do |page|

        page.replace_html "timetable_view", :text => ""

      end

      return

    end

    @batch = Batch.find(params[:course_id])

    @timetable = TimetableEntry.find_all_by_batch_id(@batch.id)

    @class_timing = ClassTiming.find_all_by_batch_id(@batch.id, :conditions => "is_break = false")

    if @class_timing.empty?

      @class_timing = ClassTiming.default

    end

    @day = Weekday.find_all_by_batch_id(@batch.id)

    if @day.empty?

      @day = Weekday.default

    end



    @subjects = Subject.find_all_by_batch_id(@batch.id)

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    render :update do |page|

      page.replace_html "timetable_view", :partial => "view_timetable"

    end

  end



  #methods given below are for timetable with HR module connected



  def select_class2

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    @batches = Batch.active

    if request.post?

      unless params[:timetable_entry][:batch_id].empty?

        @batch = Batch.find(params[:timetable_entry][:batch_id])

        @class_timings = ClassTiming.find_all_by_batch_id(@batch.id, :conditions => "is_break = false")

        if @class_timings.empty?

          @class_timings = ClassTiming.default

        end

        @day = Weekday.find_all_by_batch_id(@batch.id)

        if @day.empty?

          @day = Weekday.default

        end

        @day.each do |d|

          @class_timings.each do |p|

            TimetableEntry.create(:batch_id=>@batch.id, :week_day_id => d.weekday, :class_timing_id => p.id) \

              if TimetableEntry.find_by_batch_id_and_week_day_id_and_class_timing_id(@batch.id, d.weekday, p.id).nil?

          end

        end

        redirect_to :action => "edit2", :id => @batch.id

      else

        flash[:notice]="Select a batch to continue"

        redirect_to :action => "select_class2"

      end

    end

  end



  def edit2

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    @errors = {"messages" => []}

    @batch = Batch.find(params[:id])

    @timetable = TimetableEntry.find_all_by_batch_id(params[:id])

    @class_timing = ClassTiming.find_all_by_batch_id(@batch.id, :conditions => "is_break = false")

    if @class_timing.empty?

      @class_timing = ClassTiming.default

    end

    @day = Weekday.find_all_by_batch_id(@batch.id)

    if @day.empty?

      @day = Weekday.default

    end

    @subjects = Subject.find_all_by_batch_id(@batch.id)

  end



  def update_employees

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    if params[:subject_id] == ""

      render :text => ""

      return

    end

    @employees_subject = EmployeesSubject.find_all_by_subject_id(params[:subject_id])

    render :partial=>"employee_list"

  end



  def update_multiple_timetable_entries2

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    employees_subject = EmployeesSubject.find(params[:emp_sub_id])

    tte_ids = params[:tte_ids].split(",").each {|x| x.to_i}

    @batch = employees_subject.subject.batch

    subject = employees_subject.subject

    employee = employees_subject.employee

    @validation_problems = {}



    tte_ids.each do |tte_id|

      tte = TimetableEntry.find(tte_id)

      errors = { "info" => {"sub_id" => employees_subject.subject_id, "emp_id"=> employees_subject.employee_id,"tte_id" => tte_id},

        "messages" => [] }



      # check for weekly subject limit.

      errors["messages"] << "Weekly subject limit reached." \

        if subject.max_weekly_classes <= TimetableEntry.count(:conditions => "subject_id = #{subject.id}")



      #check for overlapping classes

      errors["messages"] << "Class overlap occured." \

        unless TimetableEntry.find(:first,

        :conditions => "week_day_id = #{tte.week_day_id} AND

                                               class_timing_id = #{tte.class_timing_id} AND

                                               employee_id = #{employee.id}").nil?



      # check for max_hour_day exceeded

      errors["messages"] << "Max hours per day exceeded." \

        if employee.max_hours_per_day <= TimetableEntry.count(:conditions => "employee_id = #{employee.id} AND week_day_id = #{tte.week_day_id}")



      # check for max hours per week

      errors["messages"] << "Max hours per week exceeded." \

        if employee.max_hours_per_week <= TimetableEntry.count(:conditions => "employee_id = #{employee.id}")



      if errors["messages"].empty?

        TimetableEntry.update(tte_id, :subject_id => subject.id, :employee_id=>employee.id)

      else

        @validation_problems[tte_id] = errors

      end

    end



    @timetable = TimetableEntry.find_all_by_batch_id(@batch.id)

    render :partial => "edit_tt_multiple2"

  end



  def delete_employee2

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    @errors = {"messages" => []}

    tte=TimetableEntry.update(params[:id], :subject_id => nil, :employee_id => nil)

    @timetable = TimetableEntry.find_all_by_batch_id(tte.batch_id)

    render :partial => "edit_tt_multiple2", :with => @timetable

  end



  def tt_entry_update2

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    @errors = {"messages" => []}

    subject = Subject.find(params[:sub_id])

    tte = TimetableEntry.find(params[:tte_id])

    overlapped_tte = TimetableEntry.find_by_week_day_id_and_class_timing_id_and_employee_id(tte.week_day_id,tte.class_timing_id,params[:emp_id])

    if overlapped_tte.nil?

      TimetableEntry.update(params[:tte_id], :subject_id => params[:sub_id], :employee_id => params[:emp_id])

    else

      TimetableEntry.update(overlapped_tte.id,:subject_id => nil, :employee_id => nil )

      TimetableEntry.update(params[:tte_id], :subject_id => params[:sub_id], :employee_id => params[:emp_id])

    end

    @timetable = TimetableEntry.find_all_by_batch_id(subject.batch_id)

    render :partial => "edit_tt_multiple2", :with => @timetable

  end



  def tt_entry_noupdate2

    render :update => "error_div_#{params[:tte_id]}", :text => "Cancelled."

  end

  #PDF Reports

  def timetable_pdf

    @batch = Batch.find(params[:course_id])

    @timetable = TimetableEntry.find_all_by_batch_id(@batch.id)

    @class_timing = ClassTiming.find_all_by_batch_id(@batch.id, :conditions => "is_break = false")

    if @class_timing.empty?

      @class_timing = ClassTiming.default

    end

    @day = Weekday.find_all_by_batch_id(@batch.id)

    if @day.empty?

      @day = Weekday.default

    end

    @subjects = Subject.find_all_by_batch_id(@batch.id)

    @weekday = ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]

    respond_to do |format|

      format.pdf { render :layout => false }

    end

  end

end

#error
undefined method `<=' for nil:NilClass
/var/lib/gems/1.8/gems/activesupport-2.3.5/lib/active_support/whiny_nil.rb:52:in `method_missing'
/var/www/admin/app/controllers/timetable_controller.rb:350:in `update_multiple_timetable_entries2'
/var/www/admin/app/controllers/timetable_controller.rb:332:in `each'
/var/www/admin/app/controllers/timetable_controller.rb:332:in `update_multiple_timetable_entries2'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/base.rb:1331:in `send'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/base.rb:1331:in `perform_action_without_filters'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/filters.rb:617:in `call_filters'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/var/lib/gems/1.8/gems/activesupport-2.3.5/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/var/lib/gems/1.8/gems/activesupport-2.3.5/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/flash.rb:146:in `perform_action'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/base.rb:532:in `send'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/base.rb:532:in `process_without_filters'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/filters.rb:606:in `process'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/base.rb:391:in `process'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/base.rb:386:in `call'
/var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/routing/route_set.rb:437:in `call'