Join 2 Unrelated Objects for PageBlockTable

Question

I have a requirement to be able to display Financial Year/Weeks/Periods for a number of dates in different objects. In our old Sql system we had a calendar table that was simply a long list of dates along with the FY/Period/Week data and i could just join any date to it as and when. My current thinking is store the same calendar table in custom settings and then create wrapper classes to display the data in VF, however im struggling with this...

As an example i need to display a pageBlockTable showing certain info from the Site object plus the Fiancial Year/Week and Period that the record was added.

So, is the above approach sensible, if so any idea how i should go about it? if not any suggestions of the best way of achieving the desired results?

Thanks for any suggestions. Paul

Answer 1

In these situations, if I understand the issue correctly, I usually create an wrapper class that I can use to marry the data together. Within a Controller, I'd do this in an inner class like so...

public Class MyController {

  // this is used for the data table
  public List<MyWrapper> myWrappers {get; set}

  // query and join your objects in the constructor
  public MyController() {

    myWrappers = new List<MyWrapper>();

    MyObject1__c o1 = [SELECT.......];  
    MyObject2__c o2 = [SELECT.......]; 

    MyWrapper wrap = new MyWrapper()
    wrap.obj1 = o1;
    wrap.obj2 = o2; 

    myWrappers.add(wrap);

  }

  public Class MyWrapper {
    public MyObject1__c obj1 {get; set}
    public MyObject2__c obj2 {get; set}
  }

}

For the dates that you are looking to track, I would probably do those in a custom object.