Homepage of Timotheus Pokorra

I am very glad for the hosted apps that Sourceforge provides. It is excellent to have only one login, and not to need to worry about updating the apps.

I wondered what the easiest way was to create reports.
I looked into PM Report 4.1 by Zeke Walker, but did not think it would be what I needed.

So this is what I did:
edit the Peer class of your table, and add a function that will return the data that you will need in the report:
lib/model/MyTablePeer.php

static function getAllRowsWithBlabla()
{
  $con = Propel::getConnection(self::DATABASE_NAME);
  $sql = 'SELECT * FROM '.self::TABLE_NAME.' WHERE a=1 ORDER BY nachname, vorname';
  $stmt = $con->prepareStatement($sql);
  $rs = $stmt->executeQuery(ResultSet::FETCHMODE_NUM);
  return BasePatePeer::populateObjects($rs);
}

Then in apps/myapp/modules/mytable/actions/actions.class.php add an action for the report:

public function executeReportVereinsmitglieder()
{
 $this->items = MyTablePeer::getAllRowsWithBlabla();
}

Finally, create a success page:
apps/myapp/modules/mytable/templates/reportBlablaSuccess.php

Date created: 
    



   Print this report


My blabla report






  if ($item->getSomeCondition())
  {
   if ($first)
   {
     $first = false;
   }
   else
   {
     echo ', ';
   }
   echo $item->getMyValue();
  }

?>

To disable some items for printing, I changed the css styles
in file apps/myapp/templates/layout.php:

see http://www.symfony-project.com/book/1_0/13-I18n-and-L10n

I have changed the default_culture in myapp/config/i18n.yml

Based on this blog entry with german translations I have created my own version:
save it as apps/mybackend/messages.de.xml

I enjoy using the symfony Web PHP Framework for a database/web application.

To make it run on a Debian Virtual Private Server:
add to file /etc/apt/sources.list this line:

deb http://www.symfony-project.com/get debian/

Then install the required packages:

apt-get install php-pear php5-symfony php5-mysql php5-xsl

See the “My First Project”-Tutorial for initialising your project.

The goal is, that users are only registered on phpNuke, and can use the same username on MediaWiki, without logging in twice.

Readme.txt, Download, Auth_phpnuke.php, authphpnuke.php, modules/MediaWiki/index.php.