* other free or open source software licenses.
* See /administrator/components/com_virtuemart/COPYRIGHT.php for copyright notices and details.
*
* http://virtuemart.net
*/
mm_showMyFileName(__FILE__);
?>
<h3><?php
echo $VM_LANG->_('VM_AFFILIATE_ORDERSUMMARY_LBL') . ' ' . strftime('%B %Y', $date);
?>
</h3>
<table class="adminlist">
<tr valign="top">
<td align="left" width="90%"><?php
$ps_affiliate = new ps_affiliate();
$affiliate = $ps_affiliate->get_affiliate_details(0, isset($affiliate_id) ? $affiliate_id : "");
echo $affiliate["company"];
?>
</td>
<td width="10%" align="right"> </td>
</tr>
<tr>
<td colspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<th width="22%"><?php
echo $VM_LANG->_('VM_AFFILIATE_ORDERLIST_ORDERREF');
?>
</th>
<th width="19%"><?php
* @copyright Copyright (C) 2004-2007 soeren - All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* VirtueMart is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See /administrator/components/com_virtuemart/COPYRIGHT.php for copyright notices and details.
*
* http://virtuemart.net
*/
mm_showMyFileName(__FILE__);
require_once CLASSPATH . "pageNavigation.class.php";
require_once CLASSPATH . "htmlTools.class.php";
$start_date = mktime(0, 0, 0, date("n"), 1, date("Y"));
$end_date = mktime(24, 0, 0, date("n") + 1, 0, date("Y"));
$ps_affiliate = new ps_affiliate();
$affiliate = $ps_affiliate->get_affiliate_details($auth["user_id"]);
$q = "select * from #__{vm}_orders,#__{vm}_affiliate_sale";
$q .= " where #__{vm}_orders.order_id = #__{vm}_affiliate_sale.order_id";
$q .= " and #__{vm}_affiliate_sale.affiliate_id = '" . $affiliate["id"] . "'";
$q .= " AND cdate BETWEEN {$start_date} AND {$end_date} ";
$q .= " LIMIT {$limitstart}, {$limit}";
$db->query($q);
$num_rows = $db->num_rows();
// Create the Page Navigation
$pageNav = new vmPageNav($num_rows, $limitstart, $limit);
// Create the List Object with page navigation
$listObj = new listFactory($pageNav);
// print out the search field and a list heading
$listObj->writeSearchHeader($VM_LANG->_('VM_AFFILIATE_ORDERSUMMARY_LBL') . ' ' . strftime('%b %Y', $date), "", "affiliate", "affiliate_orders_list");
echo $affiliate["company"];
