$limit = $limit ? $limit : 15;
if ($total <= $limit) {
$limitstart = 0;
}
//require_once( $GLOBALS['mosConfig_absolute_path'] . '/includes/pageNavigation.php' );
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
//$pageNav = new mosPageNav( $total, $limitstart, $limit );
//$link = "index.php?option=com_docmanpaypal&Itemid=$Itemid";
$link = "index.php?option=com_docmanpaypal";
$database->setQuery("SELECT o. * , sum( downloads ) AS downloads\nFROM `#__docmanpaypalorders` o\nJOIN #__docmanpaypaldownloads ON ( o.order_id = #__docmanpaypaldownloads.order_id )\nWHERE completed =1\nGROUP BY order_id order by order_id desc", $limitstart, $limit);
//die($database->getQuery());
$result = $database->loadAssocList();
foreach ($result as $row) {
$currency_symbol = !empty($currency_symbols[$row['mc_currency']]) ? $currency_symbols[$row['mc_currency']] : $row['mc_currency'];
echo "<tr>\n\t\t\t\t<td>{$row['order_id']}</td>\n\t\t\t\t<td>{$row['item_name']} (" . $dm->formatTransactionLink($row['transaction']) . ")</td>\n\t\t\t\t<td>{$row['merchant']}</td>\n\t\t\t\t<td>{$row['first_name']} {$row['last_name']}</td>\n\t\t\t\t<td>{$row['address']}, {$row['city']},<br />{$row['zip']}, {$row['country']}</td>\n\t\t\t\t<td>{$row['datetime']}</td>\n\t\t\t\t<td>{$row['email']}</td>\n\t\t\t\t<td>{$currency_symbol} " . number_format($row['price'], 2) . "</td>\n\t\t\t\t<td>{$row['downloads']}</td>\n\t\t\t\t</tr>";
}
?>
<tfoot>
<tr>
<td colspan="9"><?php
echo $pageNav->getListFooter();
?>
</td>
</tr>
</tfoot>
</tbody>
</table>
<input type="hidden" name="option" id="option" value="com_docmanpaypal" />
<input type="hidden" name="task" id="task" value="mySales" />
