One of the tricks of the trade in doing maths and physics questions at
school was that they never provided any information you didn't need. Real
life isn't like that, and as far as I can see the first file is a red
herring, it's not needed and it's only there to confuse us.
If $psr is the <project_staff_roles> element and $pid is the project id,
then the project staff are:
<people>
<xsl:copy-of select=$psr/project_staff_role[(_at_)project_id=$pid]/staff"/>
</people>
and the non-project staff are:
<people>
<xsl:copy-of select=$psr/project_staff_role[(_at_)project_id!=$pid]/staff"/>
</people>
Or have I overlooked something?
Regards,
Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay
-----Original Message-----
From: Joelle Tegwen [mailto:tegwe002(_at_)umn(_dot_)edu]
Sent: 03 June 2009 22:33
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Joining xml documents on the fly
Ok, I'm in totally over my head here. I'm hoping someone can
help me out.
I've got 2 external (reference) documents I'm including into
my stylesheet.
One is a list of staff. It looks like this (edited for brevity):
<people>
<staff staff_id="123456789" alpha_key="A" sort_key="AberyBrian">
<display_name>Brian H Abery</display_name>
</staff>
<staff staff_id="987654321" alpha_key="A" sort_key="AlbusDeb">
<display_name>Deb Albus</display_name>
</staff>
<staff staff_id="456321789" alpha_key="A" sort_key="AltmanJason">
<display_name>Jason R Altman</display_name>
</staff>
</people>
And the other is the three way join between staff, projects
and roles <project_staff_roles>
<project_staff_role project_id="1" staff_id="123456789"
role_id="staff">
<staff staff_id="123456789" alpha_key="A"
sort_key="AberyBrian">
<display_name>Brian H Abery</display_name>
</staff>
</project_staff_role>
<project_staff_role project_id="1" staff_id="123456789"
role_id="director">
<staff staff_id="123456789" alpha_key="A"
sort_key="AberyBrian">
<display_name>Brian H Abery</display_name>
</staff>
</project_staff_role>
<project_staff_role project_id="2" staff_id="987654321"
role_id="staff">
<staff staff_id="987654321" alpha_key="A" sort_key="AlbusDeb">
<display_name>Deb Albus</display_name>
</staff>
</project_staff_role>
</project_staff_roles>
I want to break this into two groups based on the current project_id.
So if I'm viewing project_id=1
I want two groups of people
Project Staff:
<people>
<staff staff_id="123456789" alpha_key="A" sort_key="AberyBrian">
<display_name>Brian H Abery</display_name>
</staff>
</people>
Non-Project-Staff
<people>
<staff staff_id="987654321" alpha_key="A" sort_key="AlbusDeb">
<display_name>Deb Albus</display_name>
</staff>
<staff staff_id="456321789" alpha_key="A" sort_key="AltmanJason">
<display_name>Jason R Altman</display_name>
</staff>
</people>
I've got the following variables in my document:
<xsl:variable name="staff" select="document($ref_staff)/people"/>
<xsl:variable name="staff_roles"
select="document($ref_project_staff_role)/project_staff_roles/
project_staff_role[(_at_)role_id='staff']"/>
<xsl:variable name="project_staff"
select="$staff_roles[(_at_)project_id=$[project_id]/staff"/>
<xsl:variable name="non_project_staff" select="?????"/>
How do I even go about thinking about this? I've tried
googling it but I have no idea what to search on. I've tried
various iterations of keys, etc but I just can't get it.
The final xslt that gives the desired output is:
<xsl:if test="count($project_staff) > 0">
<fieldset class="span-18 last col-wrap">
<legend class="quiet">
<xsl:value-of
select="ancestor::project/associates/associate/title"/>
People</legend>
<xsl:call-template name="layout_3column">
<xsl:with-param name="objects"
select="$project_staff"/>
</xsl:call-template>
</fieldset>
</xsl:if>
<xsl:if test="count($non_project_staff) > 0">
<fieldset class="span-18 last col-wrap">
<legend class="quiet">All Other People</legend>
<div id="tabs">
<ul>
<xsl:for-each
select="$staff/staff/@alpha_key[generate-id()=generate-id(key('alpha',
.))]">
<xsl:if
test="count($non_project_staff[(_at_)alpha_key = current()]) > 0">
<xsl:call-template name="tab_link">
<xsl:with-param
name="alpha_string"
select="."/>
</xsl:call-template>
</xsl:if>
</xsl:for-each>
</ul>
<xsl:for-each
select="$staff/staff/@alpha_key[generate-id()=generate-id(key('alpha',
.))]">
<xsl:if
test="count($non_project_staff[(_at_)alpha_key = current()]) > 0">
<xsl:call-template name="tab_data">
<xsl:with-param name="alpha_string"
select="."/>
<xsl:with-param name="objects"
select="$non_project_staff[(_at_)alpha_key = current()]"/>
</xsl:call-template>
</xsl:if>
</xsl:for-each>
</div>
</fieldset>
</xsl:if>
I hope this is clear. Any help would be much appreciated.
Thanks in advance.
Joelle
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--