Changed website traffic view from KB to MB.

tbrehm

2010-03-08 022d53cd34251d182ff953d865dbe3ca27340e50

Changed website traffic view from KB to MB.

 interface/web/sites/templates/web_sites_stats_list.htm

@@ -1,52 +1,52 @@
<h2><tmpl_var name="list_head_txt"></h2>

<p><tmpl_var name="list_desc_txt"></p>



<div class="panel panel_list_web_sites_stats">



  <div class="pnl_listarea">

    <fieldset><legend><tmpl_var name="list_head_txt"></legend>

      <table class="list">

        <thead>

          <tr>

            <th class="tbl_col_domain" scope="col"><tmpl_var name="domain_txt"></th>

            <th class="tbl_col_this_month" scope="col"><tmpl_var name="this_month_txt"></th>

            <th class="tbl_col_last_month" scope="col"><tmpl_var name="last_month_txt"></th>

            <th class="tbl_col_this_year" scope="col"><tmpl_var name="this_year_txt"></th>

            <th class="tbl_col_last_year" scope="col"><tmpl_var name="last_year_txt"></th>

            <th class="tbl_col_buttons" scope="col">&nbsp;</th>

          </tr>

          <tr>

            <td class="tbl_col_domain"><input type="text" name="search_domain" value="{tmpl_var name='search_domain'}" /></td>

            <td class="tbl_col_this_month"></td>

            <td class="tbl_col_last_month"></td>

            <td class="tbl_col_this_year"></td>

            <td class="tbl_col_last_year"></td>

            <td class="tbl_col_buttons"><div class="buttons"><button type="button" class="icons16 icoFilter" name="Filter" id="Filter" value="{tmpl_var name="filter_txt"}" onClick="submitForm('pageForm','sites/web_sites_stats.php');"><span>{tmpl_var name="filter_txt"}</span></button></div></td>

          </tr>

        </thead>

        <tbody>

          <tmpl_loop name="records">

          <tr class="tbl_row_<tmpl_if name='__EVEN__'}even<tmpl_else>uneven</tmpl_if>">

            <td class="tbl_col_domain"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="domain"}</a></td>

            <td class="tbl_col_this_month"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="this_month"} kB</a></td>

            <td class="tbl_col_last_month"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="last_month"} kB</a></td>

            <td class="tbl_col_this_year"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="this_year"} kB</a></td>

            <td class="tbl_col_last_year"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="last_year"} kB</a></td>

            <td class="tbl_col_buttons">

              <div class="buttons icons16">    
              </div>

            </td>

          </tr>

          </tmpl_loop>

        </tbody>



        <tfoot>

          <tr>

            <td class="tbl_footer tbl_paging" colspan="6"><tmpl_var name="paging"></td>

          </tr>

        </tfoot>

      </table>

    </fieldset>

  </div>



</div>

<h2><tmpl_var name="list_head_txt"></h2>
<p><tmpl_var name="list_desc_txt"></p>

<div class="panel panel_list_web_sites_stats">

  <div class="pnl_listarea">
    <fieldset><legend><tmpl_var name="list_head_txt"></legend>
      <table class="list">
        <thead>
          <tr>
            <th class="tbl_col_domain" scope="col"><tmpl_var name="domain_txt"></th>
            <th class="tbl_col_this_month" scope="col"><tmpl_var name="this_month_txt"></th>
            <th class="tbl_col_last_month" scope="col"><tmpl_var name="last_month_txt"></th>
            <th class="tbl_col_this_year" scope="col"><tmpl_var name="this_year_txt"></th>
            <th class="tbl_col_last_year" scope="col"><tmpl_var name="last_year_txt"></th>
            <th class="tbl_col_buttons" scope="col">&nbsp;</th>
          </tr>
          <tr>
            <td class="tbl_col_domain"><input type="text" name="search_domain" value="{tmpl_var name='search_domain'}" /></td>
            <td class="tbl_col_this_month"></td>
            <td class="tbl_col_last_month"></td>
            <td class="tbl_col_this_year"></td>
            <td class="tbl_col_last_year"></td>
            <td class="tbl_col_buttons"><div class="buttons"><button type="button" class="icons16 icoFilter" name="Filter" id="Filter" value="{tmpl_var name="filter_txt"}" onClick="submitForm('pageForm','sites/web_sites_stats.php');"><span>{tmpl_var name="filter_txt"}</span></button></div></td>
          </tr>
        </thead>
        <tbody>
          <tmpl_loop name="records">
          <tr class="tbl_row_<tmpl_if name='__EVEN__'}even<tmpl_else>uneven</tmpl_if>">
            <td class="tbl_col_domain"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="domain"}</a></td>
            <td class="tbl_col_this_month"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="this_month"} MB</a></td>
            <td class="tbl_col_last_month"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="last_month"} MB</a></td>
            <td class="tbl_col_this_year"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="this_year"} MB</a></td>
            <td class="tbl_col_last_year"><a href="#" onClick="loadContent('sites/web_domain_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="last_year"} MB</a></td>
            <td class="tbl_col_buttons">
              <div class="buttons icons16">    
              </div>
            </td>
          </tr>
          </tmpl_loop>
        </tbody>

        <tfoot>
          <tr>
            <td class="tbl_footer tbl_paging" colspan="6"><tmpl_var name="paging"></td>
          </tr>
        </tfoot>
      </table>
    </fieldset>
  </div>

</div>

 interface/web/sites/web_sites_stats.php

@@ -34,22 +34,22 @@
        $tmp_year = date('Y');
        $tmp_month = date('m');
        $tmp_rec = $app->db->queryOneRecord("SELECT SUM(traffic_bytes) as t FROM web_traffic WHERE hostname = '".$rec['domain']."' AND YEAR(traffic_date) = '$tmp_year' AND MONTH(traffic_date) = '$tmp_month'");
        $rec['this_month'] = number_format($tmp_rec['t']/1024, 0, '.', ' ');
        $rec['this_month'] = number_format($tmp_rec['t']/1024/1024, 0, '.', ' ');
        
        //** Traffic of the current year
        $tmp_rec = $app->db->queryOneRecord("SELECT sum(traffic_bytes) as t FROM web_traffic WHERE hostname = '".$rec['domain']."' AND YEAR(traffic_date) = '$tmp_year'");
        $rec['this_year'] = number_format($tmp_rec['t']/1024, 0, '.', ' ');
        $rec['this_year'] = number_format($tmp_rec['t']/1024/1024, 0, '.', ' ');
        
        //** Traffic of the last month
        $tmp_year = date('Y',mktime(0, 0, 0, date("m")-1, date("d"), date("Y")));
        $tmp_month = date('m',mktime(0, 0, 0, date("m")-1, date("d"), date("Y")));
        $tmp_rec = $app->db->queryOneRecord("SELECT sum(traffic_bytes) as t FROM web_traffic WHERE hostname = '".$rec['domain']."' AND YEAR(traffic_date) = '$tmp_year' AND MONTH(traffic_date) = '$tmp_month'");
        $rec['last_month'] = number_format($tmp_rec['t']/1024, 0, '.', ' ');
        $rec['last_month'] = number_format($tmp_rec['t']/1024/1024, 0, '.', ' ');
        
        //** Traffic of the last year
        $tmp_year = date('Y',mktime(0, 0, 0, date("m"), date("d"), date("Y")-1));
        $tmp_rec = $app->db->queryOneRecord("SELECT sum(traffic_bytes) as t FROM web_traffic WHERE hostname = '".$rec['domain']."' AND YEAR(traffic_date) = '$tmp_year'");
        $rec['last_year'] = number_format($tmp_rec['t']/1024, 0, '.', ' ');
        $rec['last_year'] = number_format($tmp_rec['t']/1024/1024, 0, '.', ' ');
        
        //* The variable "id" contains always the index variable
        $rec['id'] = $rec[$this->idx_key];