<?php
/*
  www.oscGold.com (C) Kamelia-Net Jacek Krysiak
  modul oscGold wer 4.0
*/
?>
<!-- downloads //-->
<?php
if (!strstr($PHP_SELF, FILENAME_ACCOUNT_HISTORY_INFO)) {
  // Get last order id for checkout_success
  $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$customer_id . "' order by orders_id desc limit 1");
  $orders = tep_db_fetch_array($orders_query);
  $last_order = $orders['orders_id'];
} else {
  $last_order = $HTTP_GET_VARS['order_id'];
}

// Now get all downloadable products in that order
// BOF: WebMakers.com Added: Downloads Controller
// DEFINE WHICH ORDERS_STATUS TO USE IN downloads_controller.php
// USE last_modified instead of date_purchased
$downloads_query = tep_db_query("select o.orders_status, date_format(o.last_modified, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . (int)$customer_id . "' and o.orders_status >= '" . DOWNLOADS_CONTROLLER_ORDERS_STATUS . "' and o.orders_id = '" . (int)$last_order . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ''");

if (tep_db_num_rows($downloads_query) > 0) {
  ?>
    <tr>
      <td>
        <fieldset>
        <legend><?php echo HEADING_DOWNLOAD; ?></legend>
          <table border="0" width="100%" cellspacing="0" cellpadding="0">
            <tr>
              <td class="main" align="center">
                <table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
                  <!-- list of products -->
                  <?php
                  while ($downloads = tep_db_fetch_array($downloads_query)) {
                    // MySQL 3.22 does not have INTERVAL
                    list($dt_year, $dt_month, $dt_day) = explode('-', $downloads['date_purchased_day']);
                    $download_timestamp = mktime(23, 59, 59, $dt_month, $dt_day + $downloads['download_maxdays'], $dt_year);
                    $download_expiry = date('Y-m-d H:i:s', $download_timestamp);
                    ?>
                    <tr class="infoBoxContents">
                      <!-- left box -->
                      <?php
                      // The link will appear only if:
                      // - Download remaining count is > 0, AND
                      // - The file is present in the DOWNLOAD directory, AND EITHER
                      // - No expiry date is enforced (maxdays == 0), OR
                      // - The expiry date is not reached
                      if ( ($downloads['download_count'] > 0) && (file_exists(DIR_FS_DOWNLOAD . $downloads['orders_products_filename'])) && ( ($downloads['download_maxdays'] == 0) || ($download_timestamp > time())) ) {
                         // WebMakers.com Added: Downloads Controller Show Button
                        echo '<td align="center"><a href="' . tep_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads['orders_products_download_id']) . '">' . tep_image(DIR_WS_TEMPLATES . 'images/misc/icons/downloads.gif', $downloads['products_name']) . '</a></td><td class="main" align="center"><a href="' . tep_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads['orders_products_download_id']) . '">' . $downloads['products_name'] . '</a></td>' . "\n";
                      } else {
                        echo '<td class="main">' . $downloads['products_name'] . '</td>' . "\n";
                      }
                      ?>
                      <!-- right box -->
                      <?php
                      // BOF: WebMakers.com Added: Downloads Controller
                      echo '<td class="main">' . TABLE_HEADING_DOWNLOAD_DATE . ': ' . tep_date_long($download_expiry) . '</td>' . "\n" .
                           '<td class="main" align="right">' . $downloads['download_count'] . TABLE_HEADING_DOWNLOAD_COUNT . '</td>' . "\n" .
                               '</tr>' . "\n";
                          // EOF: WebMakers.com Added: Downloads Controller
                    }
                  ?>
                </table>
              </td>
            </tr>
          </table>
        </fieldset>
      </td>
    </tr>
    <?php
    if (!strstr($PHP_SELF, FILENAME_ACCOUNT_HISTORY_INFO)) {
      ?>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td class="smalltext" colspan="4" align="center"><?php printf(FOOTER_DOWNLOAD, '<a href="' . tep_href_link(FILENAME_ACCOUNT, '', 'SSL') . '">' . HEADER_TITLE_MY_ACCOUNT . '</a>'); ?></td>
      </tr>
      <?php
    }
}
?>

<?php
// BOF: WebMakers.com Added: Downloads Controller
// If there is a download in the order and they cannot get it, tell customer about download rules
$downloads_check_query = tep_db_query("select o.orders_id, opd.orders_products_download_id from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.orders_id = opd.orders_id and o.orders_id = '" . (int)$last_order . "' and opd.orders_products_filename != ''");

if (tep_db_num_rows($downloads_check_query) > 0 and tep_db_num_rows($downloads_query) < 1) {
  ?>
  <?php echo DOWNLOADS_CONTROLLER_ON_HOLD_MSG ?>
  <?php
}
// EOF: WebMakers.com Added: Downloads Controller
?>
<!-- downloads_eof //-->
