On Wed, Aug 18, 2010 at 5:06 PM, Phoenix <[email protected]> wrote: > Good day. I'm creating a dashboard with cakephp 1.3 that displays all > job line items. I am having trouble displaying the rep name instead > of the id. I don't know if I need a custom query instead or if I can > still use the find function. Here is the table structure: > > *job_line_items > |---id > | *vendors > |---vendor_id-----> |---------id > | *processes > |---process_id---> |---------id > | *jobs > |---job_id----------> |---------id *reps > |---------rep_id------> |-- id > |--name > > Here are my dashboard controller and view file. > > //dashboards_controller.php > class DashboardsController extends AppController { > > var $name = 'Dashboards'; > var $uses = array(); > > function index() { > $job_line_items = > ClassRegistry::init('JobLineItem')->find('all'); > $this->set(compact('job_line_items')); > } > > } > > //index.ctp > <table cellpadding="0" cellspacing="0"> > <?php > $i = 0; > foreach ($job_line_items as $jobLineItem): > $class = null; > if ($i++ % 2 == 0) { > $class = ' class="altrow"'; > } > ?> > <tr<?php echo $class;?>> > <td><?php echo $jobLineItem['Job']['rep_id']; ?> </ > td> // I would like NAME to be displayed here instead > <td><?php echo $jobLineItem['Job']['job_number']; ?></td> > <td><?php echo $jobLineItem['Vendor']['name']; ?></td> > <td><?php echo $jobLineItem['Process']['name']; ?></ > td> > </tr> > <?php endforeach; ?> > </table> > > All I can retrieve is the rep_id. Do I need to have a custom query or > join? Can cakephp natively handle the results I want with find?
Use $jobLineItem['Rep']['name'] but you'll need to set recursive to 2, I think, to get Rep in the array. I recommend you take a look at ContainableBehavior, which makes this sort of thing a snap. > Can anyone comment on the efficiency of the dashboard controller? Is > there something I can change to make things more efficient? Thank you. Use a lot of caching. I can't say, though, what the best practice is for a dashboard approach. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
