Beginners question about adjusting views

Hi all,

I'm kind of new to CakePHP and currently learning the system. So far
I've been able to find answers to my questions via internet and in
this group, but this time I have a problem where I can't find the
answer to, also because it's a bit hard to describe.

I'm building an application to store information about companies. Each
company can have several share capitals and each share capital belongs
to a class of shares (ie: ordinary, preferent, etc).

For this I made some tables:

The table 'contacts', which has a field capital_id to link it to the
table capitals
The table 'capitals', which has a field capitalclass_id to link to the
table capitalclasses
The table 'capitalclasses', which just has two fields 'id' and 'name'.

A contact (company) can have several capitals. Each capital only
belongs to one capitalclass.

The relationship between tables in the code works very well, I used
cake bake to make the controller and views. When I view a contact all
data is displayed well.

Also on the bottom the 'baked' code will display the capital details,
now it's being displayed as:

Capitalclass_id - Amount - Value
1 - 100 - 1

Of course I don't want the capitalclass_id to be displayed, I want the
name of the capitalclass to be displayed (in this case 'ordinary' for
ordinary shares).

As this is the view of a contact and contact has no direct link with
capitalclass, but only via capital, how can I accomplish this?

The code of contacts/view.ctp to display the capital data:

<?php if (!empty($contact['Contact']['companyname']) &&
$contact['Status']['status'] == 'ACTIVE'):?>
<div class="related">
<h3><?php __('Capital');?></h3>
<?php if (!empty($contact['Capital'])):?>
<table cellpadding = "0" cellspacing = "0">
<tr>
<th><?php __('Capitalclass Id'); ?></th>
<th><?php __('Currency Id'); ?></th>
<th><?php __('Amount'); ?></th>
<th><?php __('Value'); ?></th>
<th class="actions"><?php __('Actions');?></th>
</tr>
<?php
$i = 0;
foreach ($contact['Capital'] as $capital):
$class = null;
if ($i++ % 2 == 0) {
$class = ' class="altrow"';
}
?>
<tr<?php echo $class;?>>
<td><?php echo $capital['capitalclass_id'];?></td> // Here
should capitalclass.name be displayed instead.
<td><?php echo $capital['currency_id'];?></td>
<td><?php echo $capital['amount'];?></td>
<td><?php echo $capital['value'];?></td>
<td class="actions">
<?php echo $html->link(__('View', true), array('controller' =>
'capitals', 'action' => 'view', $capital['id'])); ?>
<?php echo $html->link(__('Edit', true), array('controller' =>
'capitals', 'action' => 'edit', $capital['id'])); ?>
<?php echo $html->link(__('Delete', true), array('controller'
=> 'capitals', 'action' => 'delete', $capital['id']), null,
sprintf(__('Are you sure you want to delete # %s?', true),
$capital['id'])); ?>
</td>
</tr>
<?php endforeach; ?>
</table>
<?php endif; ?>

<div class="actions">
<ul>
<li><?php echo $html->link(__('New Capital', true),
array('controller' => 'capitals', 'action' => 'add'));?> </li>
</ul>
</div>
</div>

I hope it's clear what I mean as it's a bit hard for me to describe
the problem.

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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en