Posts Tagged ‘报表’

openx2.6.2生成excel表格时遇到乱码的修改方法

April 14th, 2010

我使用的版本是openx-2.6.2。在导出excel表格时遇到乱码,现把自己想到解决方法记录一下:

1、文件名:lib/pear/Spreadsheet/Excel/Writer.php文件的function send($filename)函数,第67行加上$filename = iconv(“utf-8″, “gb2312″, $filename);文件名由CA3Q2D77.变成广告分析报告 From Beginning 到 27-03-2009.xls。

2、excel文件内容:lib/pear/Spreadsheet/Excel/Writer/Worksheet.php文件的Writerfunction write($row, $col, $token, $format = 0)函数,第1166行替换为return $this->writeString($row, $col, iconv(“utf-8″, “gb2312″, $token), $format);

3、工作表名称:lib/pear/Spreadsheet/Excel/Writer/Workbook.php文件的function &addWorksheet($name = ”)函数,第318行加上$name = iconv(“utf-8″, “gb2312″, $name);

图形化统计报表插件更新

December 31st, 2009

英文原文地址:http://www.adserverplugins.com/blog/2009/12/openx-statistics-as-graphs-plugin-updated/

新功能

在Beta版本中只提供全局历史表图形化的基础上,新版可以针对OpenX几乎所有的统计图形化:

  • 广告主
  • 广告项目
  • 广告创意
  • 网站
  • 广告位

图表在所有用户类型下均有效(管理员、客户经理、广告主、媒体所有者)

Every graph has buttons to navigate to the previous and next month, or to go up a level to show the current year’s statistics. Clicking a bar will drill down into the underlying statistics, down to a day graph with an hourly break down.

Graphs will show the actual numbers for every bar and dot by positioning the mouse over them.

Improvements

The graphs are now displayed using the open source product “Open Flash Chart 2“, which comes bundled with the plugin. To speed up the display of the graphs, the initial time frame is always the current month.

图表式报告插件V1.0 - 统计报表图形化插件。安装时注意不要修改安装包的名称,OpenX会按照安装包的名称来检查安装包是否可用。 - (2009-12-31)
马上下载

在报表界面中加入分国家的数据统计

July 31st, 2009

看到的一个应用案例,源自:http://xclose.de/wordpress/115/openx-country-stats-into-the-ui

OpenX Country Stats into the UI

17.06.09 (Allgemein)

Recently I finished a new module to add informations about country (where does my users come from) into the statistics. Althrough OpenX 2.8 has a plugin openXDeliveryLogCountry which collects the country statistics, the part to integrate this data into the UI is still missing.

The Impressions column gets a new details link The Impressions column gets a new details link 

My new country-stats module fills the missing gap. With a simple click to the impressions column you get the country details of the current row – this works within all levels of the statistics.

Country statistics in detail Country statistics in detail 

The modul is available for OpenX 2.8 and 2.6 – unfortunately it require still some patching of codebase.

To get the files and instructions for OpenX 2.8 please download here: stats_country_2.8.zip. For OpenX 2.6 please contact me.
本地下载:
分国家统计报表源代码 - 基于Openx V2.8的区分国家统计报表源代码。 - (2009-08-02)
马上下载