Pastable version of iCal subscription

<pre class='prettyprint' language='ruby'>class IcalController &lt; ApplicationController
  
  ##
  # Build the iCal subscription fom the given first_letters for the user
  # If none first_letters given than build the complete subscription for all users.
  ##
  def subscribe

require &quot;icalendar&quot;

first_letters = params[:id]

#build time frame
    start_at = Time.now.beginning_of_day - 14.days # Kijk 14 dagen in het verleden
    end_at   = Time.now.end_of_day + 13.months     # Kijk 13 maanden in de toekomst

if !first_letters.nil?
      user      = User.find_by_jobfunction(first_letters, :select =&gt; [&quot;Username, id&quot;]) # Initials saved in jobfunction database field!!
      plannings = Planning.find_active_plannings_for_user_between(user.id,start_at, end_at)
    else
      plannings = Planning.find_active_plannings_between(start_at, end_at)
    end

#pp plannings

calendar = Icalendar::Calendar.new
    calendar.custom_property(&quot;METHOD&quot;, &quot;PUBLISH&quot;)
    plannings.each do |planning|
      begin
        company = Company.find(planning.company_id, :select =&gt; [&quot;id, strCompanyName, strPhone, strOfficeStreet, strOfficeZip, strOfficeCity&quot;])
        planning.description = &quot;&quot; if planning.description.nil?

body = &quot;&quot;
        body &lt;&lt; company.strCompanyName
        body &lt;&lt; &quot; &quot;
        body &lt;&lt; company.strPhone if not company.strPhone.nil?
        body &lt;&lt; &quot;tel onbekend&quot; if company.strPhone.nil?
        body &lt;&lt; &quot; &quot;
        body &lt;&lt; User.find(planning.user_id).Username if user.nil?
        body &lt;&lt; user.Username if not user.nil?
        body &lt;&lt; &quot;&quot;

event = Icalendar::Event.new
        event.klass       &quot;Public&quot;
        event.dtstart     icaldate(planning.start_at)
        event.dtend       icaldate(planning.end_at)
        event.summary     &quot;&quot; &lt;&lt; body
        event.description &quot;&quot; &lt;&lt; planning.description
        event.location    &quot;&quot; + company.strOfficeStreet + &quot; - &quot; + company.strOfficeZip + &quot; - &quot; + company.strOfficeCity
        event.dtstamp     DateTime.now.to_datetime
        event.uid         &quot;event-#{planning.id.to_s}&quot;
        event.priority    3
        event.sequence    0

calendar.add_event(event)

rescue Exception =&gt; error
        puts &quot;Dat ging fout: #{error.message}&quot;
      end
    end

respond_to do |format|
      format.ics {render :text =&gt; calendar.to_ical}
      format.html {render :text =&gt; calendar.to_ical}
    end

end
end

class Planning &lt; ActiveRecord::Base

belongs_to :user, :select =&gt; [&quot;Username, id, jobfunction&quot;]
  belongs_to :company, :select =&gt; [&quot;id, strCompanyName, strPhone, strOfficeStreet, strOfficeZip, strOfficeCity&quot;]

def self.find_active_plannings_for_user_between(user, start_date, end_date)
    plannings = self.find(:all, :conditions =&gt; [&quot;bitDeleted = 0 AND user_id = ? AND start_at BETWEEN ? AND ?&quot;, user, start_date, end_date],
                          :select =&gt; [&quot;start_at, end_at, description, id&quot;], :include =&gt; [:user, :company])
    return plannings
  end

def self.find_active_plannings_between(start_date, end_date)
    plannings = self.find(:all, :conditions =&gt; [&quot;bitDeleted = 0 AND start_at BETWEEN ? AND ?&quot;, start_date, end_date],
                          :select =&gt; [&quot;start_at, end_at, description, id&quot;])
    return plannings
  end

end

class Company &lt; ActiveRecord::Base

has_many :contacts,
           :select =&gt; [&quot;id, strContactName, strLastName, strMiddleName, strFirstName, strPhone, strEmail, strMobile&quot;],
           :conditions =&gt; [&quot;bitDeleted &lt; 1&quot;]

end

class User &lt; ActiveRecord::Base

has_many :plannings

end</pre>
<a href="http://www.refactormycode.com/codes/1307-ical-subscription" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of iCal subscription