Forums

I created this program to help the Italian government to publish their administrative acts on the web. This is required by a new law since 01/01/2011.

The application Albo Pretorio On Line V3 beta 6 (documents manager) was created with the help of the Italian community of joomla. This discussion into forum http://forum.joomla.it/index.php/topic,92012.0.html

The application form consists of 18 forms and 11 connectivity. Were created on two sides, private side and public side. This is the link of the demo http://valesweb.altervista.org/albo-pretorio-demo.html. Here download http://www.joomla.it/download-della-community/item/60-albo-pretorio-on-line-30-by-vales.html

To enter the private side must be logged in with username guest and password guest.

The application is entirely self installing, it automatically creates forms and connections (this was a great job). You should only make the link in the menu and configure the application in private side.

It works with some files and chronoforms chronoconnectivity modified for W3C validation. Here the link to download http://www.joomla.it/download-della-community/item/110-patch-validazione-w3c-componenti-chronoengine.html

Chronoconnectivity was amended for the management of the query field WHERE multitable. Here the link to download http://www.joomla.it/download-della-community/item/40-chronoconnectivity-multitabelle.html. The new component is independent and will have the name chronoconnectivity2.

Hi Vales,

A very nice application. Well done.

I have copied your post into the new ChronoConnectivity ShowCase forum too.

Bob

Hi Bob,

Many thanks,

Vales

bob,

You tested this?
I try it and I didn't see multi-table chooser .
I tried with the cmd key in the dropdownlist "TableName(s)" and it didn't work.

Any idea?

I was interesting in these solution because I would like to display the complete records of flexicontent item and for that I need to have access to different tables to retrieve all the fields of the record.

regards,

Fabian

Hi Fabian,

No I haven't tried it I'm afraid.

It is possible to get ChronoConnectivity to read more that one table in a few different ways - none of them very good :-(

Bob

Hi Fabian,

Substantial changes were made to the file in its original version is in this position components/com_chronoconnectivity/libraries/connection.php. The changes are as follows.

The 198 line has been commented and replaced where it was taken off the table given in reference to the single connection configuration

//$query = "SELECT * FROM ".$MyConnection->connectionrow->tablenames;
$query = "SELECT * FROM ";

Line 214 was included in the global statement, the variable $ total, which represents the number of records found by the query. This will have the variable $ total in the fields of the connection header, footer and body not to insert new code for calculating the record that is already done by the component.

global $mainframe, $total;

229 line has been commented and replaced where it was taken off the table given in reference to the single connection configuration

//$database->setQuery( "SELECT count(*) FROM ".$MyConnection->connectionrow->tablenames." ".trim($WHERE) );
$database->setQuery( "SELECT count(*) FROM "." ".trim($WHERE) );

Other changes concern the amendment of all references to chronconnectivity that have been replaced with chronoconnectivity2 in all files of the original extension in order to give full autonomy in the new joomla.

These changes will now allow you to insert in SQL WHERE conditions not only WHERE but the inclusion of all the tables you want in the query definition. Virtually everything in the query is normally after FROM . This is evident if we look at the modified rows. Practically can now be placed not only WHERE but any control is necessary to define the query. So the field name WHERE SQL connection must be understood in this new meaning.

thanks for your comments.

but i finished to develop the report with the traditional version, I could try the next time :?