statistics.php

this the oscommerce 3.0 aplha 4

<?php
/*
  $Id: statistics.php 1498 2007-03-29 14:04:50Z hpdl $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2007 osCommerce

  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License v2 (1991)
  as published by the Free Software Foundation.
*/

  $type = ( isset($_GET['type']) ? $_GET['type'] : '' );

  $Qyears = $osC_Database->query('select distinct year(banners_history_date) as banner_year from :table_banners_history where banners_id = :banners_id');
  $Qyears->bindTable(':table_banners_history', TABLE_BANNERS_HISTORY);
  $Qyears->bindInt(':banners_id', $_GET['bID']);
  $Qyears->execute();

  $years_array = array();

  while ( $Qyears->next() ) {
    $years_array[] = array('id' => $Qyears->valueInt('banner_year'),
                           'text' => $Qyears->valueInt('banner_year'));
  }

  $Qyears->freeResult();

  $months_array = array();

  for ( $i = 1; $i < 13; $i++ ) {
    $months_array[] = array('id' => $i,
                            'text' => strftime('%B', mktime(0,0,0,$i)));
  }

  $type_array = array(array('id' => 'daily',
                            'text' => $osC_Language->get('section_daily')),
                      array('id' => 'monthly',
                            'text' => $osC_Language->get('section_monthly')),
                      array('id' => 'yearly',
                            'text' => $osC_Language->get('section_yearly')));

  $osC_ObjectInfo = new osC_ObjectInfo(osC_BannerManager_Admin::getData($_GET['bID']));
?>

<h1><?php echo osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule()), $osC_Template->getPageTitle()); ?></h1>

<?php
  if ( $osC_MessageStack->size($osC_Template->getModule()) > 0 ) {
    echo $osC_MessageStack->output($osC_Template->getModule());
  }
?>

<form name="type" action="<?php echo osc_href_link_admin(FILENAME_DEFAULT); ?>" method="get">
  
<?php
  echo osc_draw_hidden_field($osC_Template->getModule()) .
       osc_draw_hidden_field('page', $_GET['page']) .
       osc_draw_hidden_field('bID', $_GET['bID']) .
       osc_draw_hidden_field('action', 'statistics');
?>

<p align="right">

<?php
  echo $osC_Language->get('operation_heading_type') . ' ' . osc_draw_pull_down_menu('type', $type_array, 'daily', 'onchange="this.form.submit();"') . ' ';

  switch ( $type ) {
    case 'yearly':
      break;

    case 'monthly':
      echo $osC_Language->get('operation_heading_year') . ' ' . osc_draw_pull_down_menu('year', $years_array, date('Y'), 'onchange="this.form.submit();"');

      break;

    case 'daily':
    default:
      echo $osC_Language->get('operation_heading_month') . ' ' . osc_draw_pull_down_menu('month', $months_array, date('n'), 'onchange="this.form.submit();"') . ' ' .
           $osC_Language->get('operation_heading_year') . ' ' . osc_draw_pull_down_menu('year', $years_array, date('Y'), 'onchange="this.form.submit();"');

      break;
  }

  echo '&nbsp;<input type="button" value="' . $osC_Language->get('button_back') . '" class="operationButton" onclick="document.location.href=\'' . osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule() . '&page=' . $_GET['page'] . '&bID=' . $_GET['bID']) . '\';" />';
?>

</p>

</form>

<?php
  if ( is_dir('images/graphs') && is_writeable('images/graphs') && !empty($osC_Template->image_extension) ) {
    switch ( $type ) {
      case 'yearly':
        include('includes/graphs/banner_yearly.php');

        echo '<p align="center">' . osc_image('images/graphs/banner_yearly-' . $_GET['bID'] . '.' . $osC_Template->image_extension) . '</p>';

        break;

      case 'monthly':
        include('includes/graphs/banner_monthly.php');

        echo '<p align="center">' . osc_image('images/graphs/banner_monthly-' . $_GET['bID'] . '.' . $osC_Template->image_extension) . '</p>';

        break;

      case 'daily':
      default:
        include('includes/graphs/banner_daily.php');

        echo '<p align="center">' . osc_image('images/graphs/banner_daily-' . $_GET['bID'] . '.' . $osC_Template->image_extension) . '</p>';

        break;
    }
  }
?>

<table border="0" width="600" cellspacing="0" cellpadding="2" class="dataTable" align="center">
  <thead>
    <tr>
      <th><?php echo $osC_Language->get('table_heading_source'); ?></th>
      <th><?php echo $osC_Language->get('table_heading_views'); ?></th>
      <th><?php echo $osC_Language->get('table_heading_clicks'); ?></th>
    </tr>
  </thead>
  <tbody>

<?php
  if ( isset($stats) ) {
    for ( $i = 0, $n = sizeof($stats); $i < $n; $i++ ) {
      echo '    <tr>' .
           '      <td>' . $stats[$i][0] . '</td>' .
           '      <td>' . number_format($stats[$i][1]) . '</td>' .
           '      <td>' . number_format($stats[$i][2]) . '</td>' .
           '    </tr>';
    }
  }
?>

  </tbody>
</table>