Hi
You could also look at using something a bit like the Configure
Plugin: http://bakery.cakephp.org/articles/view/configure-plugin
I'm using that but caching the data - saving on unecessary database
calls - works really well and it very easy to set up. Of course if you
just used the plugin out of the box you'd have to set the edition id
manually - but wouldn't be hard to modify or extend...
On Nov 10, 8:03 pm, brian <[EMAIL PROTECTED]> wrote:
> I'm having some difficulty figuring out how to set a variable that I'd like
> to retrieve from the DB and to make available application-wide.
>
> The site is an online journal and I need to have the latest edition ID at
> hand for pretty much every page, controller, model, etc. I thought that I
> might be able to do it from bootstrap.php but that's not looking promising.
> I've been fiddling around with app_controller with some success but have run
> into a further roadblock.
>
> Here's what I have so far:
>
> class AppController extends Controller
> {
> var $uses = array('Issue');
> var $latest_issue_id;
> ...
>
> function beforeFilter()
> {
> if (isset($this->Issue))
> {
> /* this first var is for other controllers
> */
> $latest_issue_id = $this->Issue->getLatestId();
>
> /* now set for the views
> */
> $this->set('latest_issue_id', $latest_issue_id);
> }
> }
> ...
>
> }
>
> class Issue extends AppModel
> {
> ...
> function getLatestId()
> {
> $tmp = Set::extract($this->query('SELECT MAX(id) FROM issues WHERE
> published = true'), '{n}.0.MAX(id)');
>
> return $tmp[0];
> }
>
> BTW, if anyone can point out a more elegant way of doing that, I'd
> appreciate it. I can't figure out how to make Set give me anything aside
> from an array. I also tried using the field() method without any luck. It
> seemed to me that this should work:
>
> $this->field('id', array('id' => '-!MAX(id)', 'published' => '1'));
>
> but that doesn't return anything.
>
> class IssuesController extends AppController
> {
> var $name = 'Issues';
> ...
> function view($id = null)
> {
> if (!$id)
> {
> /* no sense looking this up as it's already available
> */
> $id = $this->latest_issue_id;
> }
>
> $this->set('issue', $this->Issue->find('first',
> array(
> 'conditions' => array('Issue.id' => $id),
> 'contain' => array(
> 'Section',
> 'Contribution' => array(
> 'fields' => array('id', 'slug', 'title',
> 'section_id'),
> 'order' => 'Contribution.section_id ASC',
> 'Contributor' => array(
> 'fields' => array('first_name', 'last_name',
> 'slug')
> )
> )
> )
> )
> ));
> }
>
> Now, the above works just fine. The 'view' view for Issue includes a call
> to the toc element to display the table of contents. The element toc.php
> expects that an $issue var will be set.
>
> However, the client wants the main site page to display the same as the toc
> for the latest issue. So, I created the following route:
>
> Router::connect('/', array('controller' => 'issues', 'action' => 'view'));
>
> The fact that the $id is not set will mean that IssuesController will use
> $latest_issue_id. But this is always NULL when using the above route. What
> am I missing? How could it now be empty?
>
> And, is there a better way to do all of this? For the record, I do plan to
> keep this var in the session, once I can figure out how to set it properly.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
