I have an input field in a form called transaction_amount and a select field
called transaction_type and a select field called tenant. What I would like
to do is populate the transaction_amount field with the most recent
transaction entry (transaction_date) for the selected tenant where the
transaction_type = 1 or transaction_type = 2. In this scenario, I want the
transaction_amount to be repopulated each time the tenant is changed and
each time the transaction_type is changed between 1 and 2.
Form View:
<tr><th><?php __('Tenant');?></th><td><?php echo
$form->input('tenant_id',array('label'=>''));?></td></tr>
<tr><th><?php __('Transaction Type');?></th><td><?php echo
$form->input('transaction_type_id',array('label'=>''));?></td></tr>
<tr><th><?php __('Transaction Date');?></th><td><?php echo
$form->input('transaction_date',array('label'=>''));?></td></tr>
<tr><th><?php __('Amount');?></th><td><?php echo
$form->input('transaction_amount',array('label'=>'','class'=>'textsmall'));?>
In the transaction controller, I have a function to find the transaction
amount:
function getAmount()
{
$tenant_id = $this->data['Transaction']['tenant_id'];
$transaction_type = $this->data['Transaction']['transaction_type'];
$result = $this->Transaction->query("select transaction_amount from
transactions WHERE transaction_date =
(SELECT MAX(transaction_date) FROM transactions WHERE tenant_id =
\"$tenant_id\" and transaction_type = $transaction_type)");
$this->set('transaction_amount',$result);
}
Is this the right way to approach this problem? All of the examples on the
internet assume I am populating a select box. Any help would be appreciated.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
