[Summary view] [Print] [Text view]

   1  <table border="0" width="100%" cellspacing="0" cellpadding="0">
   2        <tr>
   3          <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
   4            <tr>
   5              <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
   6              <td align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_specials.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
   7            </tr>
   8          </table></td>
   9        </tr>
  10        <tr>
  11          <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  12        </tr>
  13        <tr>
  14          <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
  15            <tr>
  16              <td class="main" colspan="5"><?php echo TEXT_AFFILIATE_HEADER . ' ' . tep_db_num_rows(tep_db_query($affiliate_sales_raw)); ?></td>
  17            </tr>
  18            <tr>
  19              <td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  20            </tr>
  21            <tr>
  22              <td class="infoBoxHeading" align="center"><?php echo TABLE_HEADING_DATE; ?></td>
  23              <td class="infoBoxHeading" align="right"><?php echo TABLE_HEADING_VALUE; ?></td>
  24              <td class="infoBoxHeading" align="right"><?php echo TABLE_HEADING_PERCENTAGE; ?></td>
  25              <td class="infoBoxHeading" align="right"><?php echo TABLE_HEADING_SALES; ?></td>
  26              <td class="infoBoxHeading" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
  27            </tr>
  28  <?php
  29    if ($affiliate_sales_split->number_of_rows > 0) {
  30      $affiliate_sales_values = tep_db_query($affiliate_sales_split->sql_query);
  31      $number_of_sales = 0;
  32      $sum_of_earnings = 0;
  33      while ($affiliate_sales = tep_db_fetch_array($affiliate_sales_values)) {
  34        $number_of_sales++;
  35        if ($affiliate_sales['orders_status_id'] >= AFFILIATE_PAYMENT_ORDER_MIN_STATUS) $sum_of_earnings += $affiliate_sales['affiliate_payment'];
  36        if (($number_of_sales / 2) == floor($number_of_sales / 2)) {
  37          echo '          <tr class="productListing-even">';
  38        } else {
  39          echo '          <tr class="productListing-odd">';
  40        }
  41  ?>
  42              <td class="smallText" align="center"><?php echo tep_date_short($affiliate_sales['affiliate_date']); ?></td>
  43              <td class="smallText" align="right"><?php echo $currencies->display_price($affiliate_sales['affiliate_value'], ''); ?></td>
  44              <td class="smallText" align="right"><?php echo $affiliate_sales['affiliate_percent'] . " %"; ?></td>
  45              <td class="smallText" align="right"><?php echo $currencies->display_price($affiliate_sales['affiliate_payment'], ''); ?></td>
  46              <td class="smallText" align="right"><?php if ($affiliate_sales['orders_status']) echo $affiliate_sales['orders_status']; else echo TEXT_DELETED_ORDER_BY_ADMIN; ?></td>
  47            </tr>
  48  <?php
  49      }
  50    } else {
  51  ?>
  52            <tr class="productListing-odd">
  53              <td class="main" colspan="5"><?php echo TEXT_NO_SALES; ?></td>
  54            </tr>
  55  <?php
  56    }
  57  ?>
  58            <tr>
  59              <td colspan="5"><?php echo tep_draw_separator(); ?></td>
  60            </tr>
  61  <?php 
  62    if ($affiliate_sales_split->number_of_rows > 0) {
  63  ?>
  64            <tr>
  65              <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">
  66                <tr>
  67                  <td class="smallText"><?php echo $affiliate_sales_split->display_count(TEXT_DISPLAY_NUMBER_OF_SALES); ?></td>
  68                  <td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE; ?> <?php echo $affiliate_sales_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
  69                </tr>
  70              </table></td>
  71            </tr>
  72            <tr>
  73  <?php
  74    }
  75  ?>
  76              <td class="main" colspan="5"><br><?php echo TEXT_INFORMATION_SALES_TOTAL . ' ' .  $currencies->display_price($sum_of_earnings,'') . TEXT_INFORMATION_SALES_TOTAL2; ?></td>
  77            </tr>
  78          </table></td>
  79        </tr>
  80      </table>