Jørn Wildt

Hi!

I just developed some enhancement for pagesetter (because I needed this features desperatly):

You can maintain 1Xn and nXm-Relations via pagesetter! To get this working without changing the pagesetter code itself, I developed the following:

guppy/plugins/input.publication.php: Input Plugin for the Pagesetter forms, displays a combo-box with the actual publications for a given type. nothing further is needed to esablish 1Xn-Relations

pnrelationsapi.php: additional API functions to get and set nXm-Relations to a certain publication.this one creates the needed tables on demand.

guppy/plugins/input.relation.php: Input plugin for Pagesetter-forms, displays a selection-list to select the related publications of a given type.

workflows/custom/operations/updateRelations.php: a workflow operation to call the API-Functions after selecting the related publications in a form.

pntemplates/plugins/function.pagesetter_inlineRelatedPubList.php: a smarty plugin which enhances the functionality of inlineRelatedPubList towards the display of the related publications

I used this for work, where I set up the new website. We have different departments and people who can work in these departments. The persons can work in more than one department at once. To accomblish this task, you need a additional table, which holds the relations between pid1 and pid2. This is done via the stuff I wrote.

If someone is interested in this stuff, I will set up a demo site and explain the functionality in detail.



edited by: casi, Sep 25, 2005 - 02:16 PM

sounds pretty interesting.
maybe this can even be integrated into the offical version?

casl:

This is great. I am definately interested and have the same need as you. I have a modified pnuserapi for listing related pub types (similar to your function.pagesetter_inlineRelatedPubList.php plugin). It looks like you took things even further. Please post your code and discussion.


Thanks,
--Joe

@Andreas:
I already thought about that. That would make thinks even easier, because you would not need the additional workflow operation for example.
This would be integrated into the function "getPubList" and just had to enhance the generated sql-statement with a few "FROM", "ON" and "WHERE" statements.
I would do this, but I have to discuss it with Jorn, because I would need some extra functionality to integrate this feature fully into pagesetter.

The advantage of my current approach is that no core pagesetter files are changed, even the needed tables are generated on demand (when you call the "setRelations" API-function).

@jyanni:
I have to put some explaining comments into the code and remove some debugging "echos" before. I'm a bit involved in putting the new site online until tuesday, but then I will immediatly set up a demo and download site. You will be also able to see the functionality on a live site!

This sounds like a nice killer improvement :-)
Hopefully J?rn is going to integrate this into the Pagesetter core.

I am very interested...I am writing templates on pagesetter.org and could use this functionality a lot.

Thanx

This sounds *very* promissing! Could you please mail me the files (jln at fjeldgruppen dot dk)? Then I'll see if we can get it integrated. If it looks good you could also get CVS write access to add the features.

Casi,

Would you be so kind as to post the link to your documentation and code for this?


Thanks,
--Joe

Just for the record: I got in contact with casi and will try to get in into the core. Will take some time.

Sounds great, I've been considering starting such a mod myself!

Just one comment. After selecting the related pub type the page will need to be refreshed in order to populate the pub select list. This seems like a great place to implement some AJAX functionality so a refresh is not required.

Comments?

@jyanni: I sent the code to J?rn. I think, the best is to use the functionality as it is integrated into pagesetter, for my approach is a kind of workaround. If you like, you can test it (send a mail to: mail at ckollmeier dot de), but before setting up a life-website with this feature it will be better to wait for it to be integrated into pagesetter.

@J?rn: You got mail :-)
I would like to help integrating this feature directly into pagesetter. (For I already have some ideas where to place it)





edited by: casi, Sep 30, 2005 - 01:54 AM

Hi casi and everyone else,

Just wanted to post a quick message to say that I would be very interested in seeing a demo site when you get the time. Sounds very interesting!

I am only just getting started with Postnuke and Pagesetter and themes etc... You guys are WAY ahead of me in the whole scheme of things but I di hope to catch up at some stage.

Best wishes,

Mark Bowen

Hi!

Ok, here is some demo site running:
http://cms.fb12…nd.de/fb12test

This is a actual copy of the site I'm working on. The advantage is that there is already some data, whereby the disadvantage is that the site is in german language.

I made use of several "relations"-related functions on this site.

In "Organisation" I display the institutes and departments of the faculty I'm working for. If you choose a department (pubtype: Einrichtung), you get a list of tasks(pubtype: Aufgabe) related to this department and for each task the persons(pubtype: Mitarbeiter) which are assigned to this task and to the actual department.
The assignment of tasks/departments, task/person and person/department is done via nXm-relations, the display is done via a set of nested templates/inlineRelatedPubList statements.

A more familiar use of relations (1Xm) is the generation of "nested" publications: In the left block you see a menu. This is just a list of publications in a block. But in the publication-definition i have a field "parent", which uses the input-plugin "publications", where I can choose which publication this belongs to. While they are of the same type, I get a nested structure. Whith the help of a bit filtering (parent:eq:$core.pid), nested inlinePubList statements and javascript, I get a nested menu!

You can log in at the site (admin:admin) and try it. You will have full admin rights! But please don't mess it up to much, for other people may want to test it too.

I hope this explanation is useful and the demosite is also useful for non-germanspeaking ppl (I doubt it). Perhaps I will find the time to set up a more useful demo site...



edited by: casi, Oct 12, 2005 - 05:00 PM

I guess this is exactly what I need for my application!!!
Can somebody confirm this, related on this topic posted by me: http://www.elfi…tart=0#pid9988

When this will be really available and documented as well? because I am pretty new to pagesetter and smarty.

thanks
bernie

please delete! doubleposting!



edited by: hardtoneselector, Dec 06, 2005 - 10:23 PM