$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" />