This implementation seems to be different from what I thought we were
talking about.
You're using the click on the header to change the SQL orderby clause,
what I thought you originally described was a method of reordering the
resultset of the current page.
Which of these is it that you wanted?
If it's the former, then that's trivial, and you should be able to
work it out pretty easily. It's the latter that I've been talking
about. They're complete separate (and unrelated) problems.
On 12 Jan 2009, at 08:34, Adrian Gould wrote:
>
> Thanks Lee
>
> Ok - I have stage one working - the click on a header gives the sort
> order.
>
> I'll be going onto stage two which will be storing the sort state -
> possibly using a "session" variable to do that... ?
>
> Ady
>
> //
> --------------------------------------------------------------------------------------------
> /* frontend/modules/unit/actions/actions.class.php
> * snipped down for simplicity
> */
>
> class unitActions extends sfActions
> {
> // used to get the sort order for the Unit table
> protected function getSortOrder($sortBy) {
> $sortCol = UnitPeer::ID;
> if ($sortBy=='state') {
> $sortCol = UnitPeer::STATE_CODE;
> } elseif ($sortBy=='national') {
> $sortCol = UnitPeer::NATIONAL_CODE;
> } elseif ($sortBy=='name') {
> $sortCol = UnitPeer::NAME;
> } elseif ($sortBy=='hours') {
> $sortCol = UnitPeer::NOMINAL_HOURS;
> }
> return $sortCol;
> }
>
> // generates the default of all records listed in units table
> public function executeIndex(sfWebRequest $request)
> {
> $sortBy='';
> if ($request->hasParameter('sortby')) {
> $sortBy = $request->getParameter('sortby');
> }
> $this->sortby = $sortBy;
> $c = new Criteria();
> $c->addAscendingOrderByColumn($this->getSortOrder($sortBy));
> $this->unit_list = UnitPeer::doSelect($c);
> }
>
> // generates a paged set of results from the units table
> public function executeList(sfWebRequest $request)
> {
> $sortBy='';
> if ($request->hasParameter('sortby')) {
> $sortBy = $request->getParameter('sortby');
> }
> $this->sortby = $sortBy;
>
> $c = new Criteria();
> $c->addAscendingOrderByColumn($this->getSortOrder($sortBy));
> $pager = new sfPropelPager('Unit', 10);
> $pager->setCriteria($c);
> $pager->setPage($this->getRequestParameter('page', 1));
> $pager->init();
> $this->unit_list = $pager;
> }
>
> }
>
> //
> --------------------------------------------------------------------------------------------
>
> /* frontend/modules/unit/templates/_list.php
> */
>
> <table>
> <thead>
> <tr>
> <th> <?php echo link_to( 'State code', 'unit/index?
> sortby=state' ) ?></th>
> <th> <?php echo link_to( 'National code', 'unit/index?
> sortby=national') ?></th>
> <th> <?php echo link_to( 'Name', 'unit/index?sortby=name') ?></
> th>
> <th> <?php echo link_to( 'Nominal Hours', 'unit/index?
> sortby=hours') ?></th>
> </tr>
> </thead>
> <tbody>
> <?php $i=0;
> foreach ($unit_list as $unit): ?>
> <tr class="<?php echo ($i=($i==0?1:0)) ? 'even' : 'odd' ?>">
> <td><?php echo $unit->getStateCode() ?></td>
> <td><?php echo $unit->getNationalCode() ?></td>
> <td><a href="<?php echo url_for('unit/show?id='.$unit-
>> getId()) ?>"><?php echo $unit->getName() ?></td>
> <td><?php echo $unit->getNominalHours() ?></td>
> </tr>
> <?php endforeach; ?>
> </tbody>
> </table>
>
>
> //
> --------------------------------------------------------------------------------------------
>
> /* frontend/modules/unit/templates/indexSuccess.php
> */
>
> <h1>Unit List</h1>
>
> <?php include_partial('unit/list', array('unit_list' =>
> $unit_list)) ?>
>
> <a href="<?php echo url_for('unit/new') ?>">New</a>
>
>
>
> //
> --------------------------------------------------------------------------------------------
> # frontend/config/routing.yml
>
> unit_sort:
> url: /unit/:sortby/
> param: { module: unit, action: list }
>
> #catch the use of plural units and modules
> units:
> url: /units/:sortby/
> param: { module: unit, action: list }
>
> modules:
> url: /modules/:sortby/
> param: { module: unit, action: list }
>
>
> >
Lee Bolding
[email protected]
"a successful framework finds users and sucks and diddles their
genitalia, it doesnt bend them over and make them squeel like stuck
pigs." Hani Suleiman, The Bile Blog
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
