[eluser]Bob Puzld[/eluser]
Ok. Here is the code from the page that is not functioning properly...
Code:
<h1>Payments Requested (<?=$payouts->num_rows()?>)</h1>
<?php
echo "<pre>";
var_dump ($payouts->result_array());
echo "</pre>";
?>
<? if($payouts->num_rows() != 0): ?>
<?=form_open('users/payment_requests_process')?>
<table id="report" cellspacing="0">
<tr><th>Account Number</th><th>Name</th><th>Address</th><th>Balance</th><th>Amount Requested</th></tr>
<? $i = 1;
foreach($payouts->result() as $row): ?>
<tr <?= alternator('',' class="altrow"') ?>>
<td><?=$row->id?><input type="hidden" name="payout<?=$i?>" value="<?=$row->payout_id?>" /></td>
<td><?=$row->fname.' '.$row->lname?></td>
<td><?= $row->address.'<br />'.$row->city.', '.$row->state.' '.$row->zip?></td>
<td><?=$row->balance?></td>
<td><?=$row->amount?></td>
</tr>
<? ++$i;
endforeach; ?>
</table>
<input type="hidden" name="num_payouts" value="<?= $payouts->num_rows() ?>" />
<p><input type="submit" value="Pay Requests" /></p>
<?=form_close()?>
<? else: ?>
No pending payouts.
<? endif; ?>
Here is the code from the page that is functioning properly...
Code:
<style type="text/css">
/*<![CDATA[*/
.total {
background-color: #FFFF99;
border: 1px solid #FFFF33;
}
.number {
background-color: #FFFF99;
font-size: 20px;
}
.datatable {
width: 100%;
border: 1px solid #000000;
border-collapse: collapse;
}
.datatable td, .datatable th {
border: 1px solid #999999;
padding: 3px;
}
.datatable td.title {
background-color: #999999;
font-weight: bold;
/*padding: 3px;*/
font-size: 14px;
}
.datatable th {
font-weight: bold;
text-align: left;
color: #000000;
background-color: #F0F0F0;
}
#booster_total {
background-color: #000000;
color: #FFFFFF;
text-align: center;
padding: 5px;
}
/*]]>*/
</style>
<div id="booster_total"><?=$booster_total?></div>
<h1>Account Status</h1>
<p><span class="number">Balance: $ <?= number_format($aUser->balance, 2, '.', ''); ?></span>
<? if($aUser->balance >= $this->config->item('MIN_PAYOUT_AMT')): ?>
<a >config->item('base_url')?>users/payout_req/<?= $aUser->id ?>/<?= $aUser->district_id ?>">Request a Payout</a>
<? endif; ?>
</p>
<table width="100%" cellpadding="3" cellspacing="0">
<tr><td width="20%"><strong>Account Number:</strong></td><td><?= $aUser->id; ?></td></tr>
<tr><td><strong>Name:</strong></td><td><?= $aUser->fname. ' '.$aUser->lname; ?></td><td> </td><td><strong>Username:</strong></td><td><?= $aUser->username; ?></td></tr>
<tr><td><strong>Address:</strong></td><td><?= $aUser->street.' '.$aUser->address.'<br />'.$aUser->city.', '.$aUser->state.' '.$aUser->zip; ?></td><td> </td><td><strong>Password:</strong></td><td><?= $aUser->password; ?></td></tr>
</table>
<p> </p>
<h1>Income</h1>
<table class="datatable">
<tr><th>Date</th><th>Number of Cans</th><th>Redemption Value</th><th>Total Account Value</th><th>Total Booster Contributions</th></tr>
<? if($collections->num_rows() != 0): ?>
<? $account_total = 0;
$booster_total = 0;
foreach($collections->result() as $row):
$account_total = ($row->num_cans*$this->config->item('AMT_PER_CAN')) + $account_total;
$booster_total = ($row->num_cans*$this->config->item('BOOSTER_CONTRIB')) + $booster_total; ?>
<tr <?= alternator('',' class="altrow"') ?>>
<td><?= date('m/d/Y',$row->date) ?></td>
<td><?= $row->num_cans ?></td>
<td>$ <?= $row->num_cans*$this->config->item('AMT_PER_CAN') ?></td>
<td>$ <?= number_format($account_total, 2, '.', '') ?></td>
<td>$ <?= number_format($booster_total, 3, '.', '') ?></td>
</tr>
<? endforeach; ?>
<? else: ?>
<tr><td colspan="5">No cans have been collected yet.</td></tr>
<? endif; ?>
</table>
<h1>Payouts</h1>
<table class="datatable">
<tr><th>Status</th><th>Date Requested</th><th>Date Paid</th><th>Recipient</th><th>Amount</th></tr>
<? if($payouts->num_rows() != 0): ?>
<? foreach($payouts->result() as $row):
if($row->organization_id != 0) {
$status = '-';
$data_paid = '-';
}
elseif($row->date_paid == 0) {
$status = '<strong style="color: #CC0000;">Pending</strong>';
$date_paid = '-';
}
else {
$status = '<strong style="color: #66CC33;">Paid</strong>';
$date_paid = mysql_to_human($row->date_paid);
}
if($row->organization_id == 0)
$recipient = $aUser->fname.' '.$aUser->lname;
else {
$this->db->select('name');
$this->db->from('organization');
$this->db->where('id',$row->organization_id);
$query = $this->db->get();
$org = $query->row();
$recipient = $org->name;
}?>
<tr <?= alternator('',' class="altrow"') ?>>
<td><?= $status ?></td>
<td><?= mysql_to_human($row->date_requested) ?></td>
<td><?= $date_paid ?></td>
<td><?= $recipient ?></td>
<td>$ <?= number_format($row->amount, 2, '.', '') ?></td>
</tr>
<? endforeach; ?>
<? else: ?>
<tr><td colspan="5">No payouts have been requested yet.</td></tr>
<? endif; ?>
</table>
Hope this helps...