If $staff is all the <staff> elements in the staff file, and $psr is all the
<project_staff_role> elements, then the $staff who are not in the selected
project are:
$staff[not(@staff_id = $psr[(_at_)project_id=$pid]/staff/@staff_id)]
Regards,
Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay
-----Original Message-----
From: Joelle Tegwen [mailto:tegwe002(_at_)umn(_dot_)edu]
Sent: 04 June 2009 16:12
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Joining xml documents on the fly
Ah! Yes. it is there for a reason. I tried what you did
thinking "Oh, this is so simple." But it is not that way,
because I need to include
*all* of the staff, even those that have not yet been added
to projects.
So there is Jason Altman, he is not in the
project_staff_roles document, but I still need to include him
in the non-project staff.
Sorry I was not clearer about pointing that out. I was a
little fuzzy in the head yesterday.
Thanks,
Joelle
Michael Kay wrote:
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>
--~--
--~------------------------------------------------------------------
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>
--~--