Jump to:

7938 Posts in 1541 Topics by 945 members

DataObjectManager Module

SilverStripe Forums » DataObjectManager Module » Help with pagination in DataObject

Discuss the DataObjectManager module, and the related ImageGallery module.

Moderators: martimiz, UncleCheese, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 635 Views
  • Mauro74
    Avatar
    Community Member
    30 Posts

    Help with pagination in DataObject Link to this post

    Hi all,

    I'm pretty new to Silverstripe and PHP in general, so I'm learning by tutorials. In the well known website ssbits.com I found a very useful tutorial called 'DataObject as pages' (http://www.ssbits.com/tutorials/2010/dataobjects-as-pages-part-1-keeping-it-simple/). The tutorial is great, it shows how to create a list of staff members without using pages and using the DataObjectManager in the CMS.

    I used the tutorial to implement a list of events, but now I'm stuck finding a way to paginate the list! Anyone could help me please?
    here's my controller:

    class GigPage_Controller extends Page_Controller
    {
    //Allow our 'show' function as a URL action
    static $allowed_actions = array('show');

    //Get the current gig detail from the URL, if any
    public function getGigDetail()
    {
    $Params = $this->getURLParams();

    if(is_numeric($Params['ID']) && $GigDetail = DataObject::get_by_id('GigDetail', (int)$Params['ID']))
    {
    return $GigDetail;
    }
    }

    //Displays the gig detail detail page, using GigPage_show.ss template
    function show()
    {
    if($GigDetail = $this->getGigDetail())
    {
    $Data = array(
    'GigDetail' => $GigDetail
    );

    //return our $Data array to use on the page
    return $this->Customise($Data);
    }
    else
    {
    //Gig not found
    return $this->httpError(404, 'Sorry that member of staff could not be found');
    }
    }

    //Return our custom breadcrumbs
    public function Breadcrumbs() {

    //Get the default breadcrumbs
    $Breadcrumbs = parent::Breadcrumbs();

    if($GigDetail = $this->getGigDetail())
    {
    //Explode them into their individual parts
    $Parts = explode(SiteTree::$breadcrumbs_delimiter, $Breadcrumbs);

    //Count the parts
    $NumOfParts = count($Parts);

    //Change the last item to a link instead of just text
    $Parts[$NumOfParts-1] = ('<a href="' . $this->Link() . '">' . $Parts[$NumOfParts-1] . '</a>');

    //Add our extra piece on the end
    $Parts[$NumOfParts] = $GigDetail->Place .' - '. $GigDetail->Date;

    //Return the imploded array
    $Breadcrumbs = implode(SiteTree::$breadcrumbs_delimiter, $Parts);
    }

    return $Breadcrumbs;
    }

    }

    here's my template:

    <div class="typography">
    <% if GigDetails %>
    <div id="gig-list">
    <% control GigDetails %>
    <div class="gig">
    <h3>$Place</h3>
    <p>$Date.Nice - on stage at $Time</p>
    <p>Address: $Address</p>
    <p><a href="$Link">see map &raquo;</a></p>
    </div>
    <% end_control %>
    </div>
    <% end_if %>
    </div>

    Thanks in advance!

    Mauro

  • UncleCheese
    Avatar
    4085 Posts

    Re: Help with pagination in DataObject Link to this post

    I don't see anything in your code that returns a DataObjectSet. On your controller, you have <% control GigDetails %>, which I assume returns a DOS, but that function isn't anywhere in your code.

    --------------------
    SilverStripe tips, tutorials, screencasts and more: http://www.leftandmain.com

  • Mauro74
    Avatar
    Community Member
    30 Posts

    Re: Help with pagination in DataObject Link to this post

    Hi UncleCheese, you're right I cannot see the function that return a DOS neither, so I'm posting the entire code here so you can have a better understanding of what's going on, because I don't!

    GigPage.php:

    class GigPage extends Page
    {
    static $has_many = array(
    'GigDetails' => 'GigDetail'
    );

    public function getCMSFields()
    {
    $fields = parent::getCMSFields();

    $manager = new DataObjectManager(
    $this,
    'GigDetails',
    'GigDetail'
    );
    $fields->addFieldToTab("Root.Content.GigDetails", $manager);

    return $fields;
    }
    }

    class GigPage_Controller extends Page_Controller
    {
    //Allow our 'show' function as a URL action
    static $allowed_actions = array('show');

    //Get the current gig detail from the URL, if any
    public function getGigDetail()
    {
    $Params = $this->getURLParams();

    if(is_numeric($Params['ID']) && $GigDetail = DataObject::get_by_id('GigDetail', (int)$Params['ID']))
    {
    return $GigDetail;
    }
    }

    //Displays the gig detail detail page, using GigPage_show.ss template
    function show()
    {
    if($GigDetail = $this->getGigDetail())
    {
    $Data = array(
    'GigDetail' => $GigDetail
    );

    //return our $Data array to use on the page
    return $this->Customise($Data);
    }
    else
    {
    //Gig not found
    return $this->httpError(404, 'Sorry that member of staff could not be found');
    }
    }

    //Return our custom breadcrumbs
    public function Breadcrumbs() {

    //Get the default breadcrumbs
    $Breadcrumbs = parent::Breadcrumbs();

    if($GigDetail = $this->getGigDetail())
    {
    //Explode them into their individual parts
    $Parts = explode(SiteTree::$breadcrumbs_delimiter, $Breadcrumbs);

    //Count the parts
    $NumOfParts = count($Parts);

    //Change the last item to a link instead of just text
    $Parts[$NumOfParts-1] = ('<a href="' . $this->Link() . '">' . $Parts[$NumOfParts-1] . '</a>');

    //Add our extra piece on the end
    $Parts[$NumOfParts] = $GigDetail->Place .' - '. $GigDetail->Date;

    //Return the imploded array
    $Breadcrumbs = implode(SiteTree::$breadcrumbs_delimiter, $Parts);
    }

    return $Breadcrumbs;
    }

    }

    GigDetail.php:

    class GigDetail extends DataObject
    {
    //db fields
    static $db = array (
    'Place' => 'Varchar(255)',
    'Date' => 'Date',
    'Time' => 'Varchar(50)',
    'Address' => 'Varchar(255)',
    //'Address' => 'HTMLText', to return HTML content
    'Postcode' => 'Varchar(50)',
    );

    //Relations
    static $has_one = array (
    'GigPage' => 'GigPage',
    );

    //Fields to show in the DOM table
    static $summary_fields = array(
    'Place' => 'Place',
    'Date' => 'Date',
    'Time' => 'Time',
    'Address' => 'Address'
    );

    //Fields for the DOM Popup
    public function getCMSFields()
    {
    return new FieldSet(
    new TextField('Place'),
    new DatePickerField('Date','Gig Date (for example: 20/12/2010)'),
    new TextField('Time', 'Time (for example: 20.30)'),
    new TextareaField('Address', 'Address'),
    //new SimpleTinyMCEField('Address', 'Address'), to use HTML editor
    new TextField('Postcode', 'Postcode')
    );
    }

    //Return the link to view this gig detail
    public function Link()
    {
    if($GigPage = $this->GigPage())
    {
    $Action = 'show/' . $this->ID;
    return $GigPage->Link($Action);
    }
    }
    }

    GigPage.ss:

    <div class="typography">
    <% if GigDetails %>
    <div id="gig-list">
    <% control GigDetails %>
    <div class="gig">
    <h3>$Place</h3>
    <p>$Date.Nice - on stage at $Time</p>
    <p>Address: $Address</p>
    <p><a href="$Link">see map &raquo;</a></p>
    </div>
    <% end_control %>
    </div>
    <% end_if %>
    </div>

    GigPage_show.ss

    <div class="breadcrumbs">
    <p>$Breadcrumbs</p>
    </div>
    <div class="typography">
    <h2>Gig Detail</h2>
    <% control GigDetail %>
    <h3>$Place</h3>
    <p>$Date.Nice - on stage at $Time</p>
    <p>Address: $Address</p>
    </div>
    <% end_control %>
    </div>

    Thanks very much for your help!
    Mauro

    635 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.