* 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 echo $VM_LANG->_('VM_AFFILIATE_ORDERLIST_DATEORDERED');
* @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"]; // start the list table