Ceeb toom: qhov no yog thawj zaug muab lo rau tom www.endusersharepoint.com ntawm no: http://www.endusersharepoint.com/ 2009/11/02/comparing-dates-in-a-data-view-web-part-to-build-a-wss-kpi-in-sharepoint/.
Qhov no yog ib qho uas tsis tau blog lwm rooj vag rau muab piv rau hnub ua XSL nyob rau hauv ib cov ntaub ntawv saib web tshooj nyob rau hauv SharePoint.
Qhov no yog kuv scenario:
- Kuv muaj ib daim ntawv teev kev cai.
- Lub hom phiaj ua lag luam ntawm daim ntawv no mus txhawb rau lub tswv yim ntawm ib tug neeg ua hauj lwm tshiab thiab cov kev pab raws qib uas nws yuav ua kom tiav tsis pub dhau 7 hnub pib txoj hauj lwm.
- Lawv nyob rau hauv lub "ceeb toom zoo noj" tom qab 4 hnub yog hais tias lawv tsis tiav cov paub tab.
- Kuv xav kom koj tsim ib dashboard yooj yim uas pom tias yog ntsuab thaum lawv yog kawm ua hauj lwm los sis yog hais tias lawv muaj ntau tshaj 4 hnub ua kom tiav rau nws.
- Kuv xav kom lub dashboard qhia daj yog hais tias lawv nyob rau hauv daim ntawv ceeb toom tsam.
- Kuv xav kom pom kev liab yog hais tias lawv muaj tsis tiav rau neeg ua hauj lwm tom qab lub hnub.
Kuv los borrowed cov tshooj no Thaum Marc Anderson Blog (http://mdasblog.wordpress.com/2008/02/19/comparing-dates-in-sharepoint-using-xsl/) kom tau txais cov kev sib piv logic thiab cov tshooj no Thaum www.endusersharepoint.com rau cov tswv yim yooj yim qab tus dashboard (http://www.endusersharepoint.com/2008/12/09/visual-indicators-for-the-masses-kpis-in-wss/) sau los ntawm Toni Frankola.
Koj yuav tsum nyeem cov txhawb blogs, tab sis qhov yuav siv mus li no:
- Tsim ib cov hom (txhua + I)
- Tsim kev cai sau thiab cov nyob qib qub nrog rau cov hom.
- Tsim ib daim nplooj web Tshooj.
- Ntxiv rau cov kev cai teev rau cov nplooj ntawv Web site qhov.
- Qhib tau cov nplooj ntawv hauv SPD.
- Hloov daim ntawv mus rau ib DVWP.
- Hloov cov XSL rau Meskas lub dashboard khoom.
Kuv muaj sijhawm ob: ib hnub tim ceeb toom thiab ib hnub. Piv lub hnub, Kuv xsl puas muaj cov nram qab no:
<xsl:xaiv> <!-- Thaum cov phau ntawv thiab txoj cai uas kos npe, peb yeej tsis hais hnub ntsuab. -->
<xsl:Thauj tw ntsuam xyuas="@Employee_x0020_Handbook_x003F_ = 1 thiab @Security_x0020_Policies = 1"> <img src= "/ _layouts/dluab/KPIDefault-0.GIF" kev= "Tsis muaj teeb meem"/> <ib tug href= "/ HumanResources/npe/tshiab ua hauj lwm Checklist/EditForm.aspx?ID ={@ID}&Qhov = / HumanResources/qhia tawm cov ntaub ntawv/tshiab ntiav Dashboard.aspx"> [Kho kom raug]</ib tug> </xsl:Thauj tw> <!-- Qhov taw qhia qhia tias amber yog tag lawm yav tas los hnub tim ceeb toom. -->
<xsl:Thauj tw ntsuam xyuas= "ddwrt:FormatDateTime(hlua(ddwrt:Hnub no()), 1033, 'yyyyMMdd') >= ddwrt:FormatDateTime(hlua(@TaskDueDate), 1033, 'yyyyMMdd')"> <img src="/_layouts/images/KPIDefault-2.GIF" kev= "Dlau caij lawm"/> <ib tug style"border =: 0px" href= "/ HumanResources/npe/tshiab ua hauj lwm Checklist/EditForm.aspx?ID ={@ID}&Qhov = / HumanResources/qhia tawm cov ntaub ntawv/tshiab ntiav Dashboard.aspx"> [Kho kom raug]</ib tug> </xsl:Thauj tw> <!-- Qhia liab qhov taw qhia tau tias peb nyob nraum lub hnub. -->
<xsl:Thauj tw ntsuam xyuas= "ddwrt:FormatDateTime(hlua(ddwrt:Hnub no()), 1033, 'yyyyMMdd') >= ddwrt:FormatDateTime(hlua(@Warning_x0020_Date), 1033, 'yyyyMMdd')"> <img src="/_layouts/images/KPIDefault-1.GIF" kev= "Ceeb toom"/> <ib tug href= "/ HumanResources/npe/tshiab ua hauj lwm Checklist/EditForm.aspx?ID ={@ID}&Qhov = / HumanResources/qhia tawm cov ntaub ntawv/tshiab ntiav Dashboard.aspx"> [Kho kom raug]</ib tug> </xsl:Thauj tw> <!-- Yog hais tias peb tau nyob ntawm no, tag lawm yav dhau hnub tim ceeb toom, yog li tag lawm ntsuab. -->
<xsl:txwv tsis pub> <img src= "/ _layouts/dluab/KPIDefault-0.GIF" kev= "Tsis muaj teeb meem"/> <ib tug href= "/ HumanResources/npe/tshiab ua hauj lwm Checklist/EditForm.aspx?ID ={@ID}&Qhov = / HumanResources/qhia tawm cov ntaub ntawv/tshiab ntiav Dashboard.aspx"> [Kho kom raug]</ib tug> </xsl:txwv tsis pub> </xsl:xaiv> |
Ob peb tseem ceeb uas los saum toj no:
- Kuv sim mus piv rau hnub uas tsis tas siv cov ddwrt functionality thiab poob nowhere. Kuv tseem tsis tau taub tias. Lawv tso tawm kom pom looj hnub, tiam sis ob">"thiab"<"counselor yeej ua tsis tau tejyam. Thaum kawg, ddwrt tuaj kuv cawm (tsaug, dua, Marc).
- Kuv tabtom kuj displaying ib [Kho kom raug] txuas rau qhov khoom. Kuv mas ua qhov no kom kuv tau yooj yim yuav kuaj no tawm. Qhov link xwb tej zaum yuav pab tau rau lwm tus neeg rau nws paub tseeb.
- Qhov no yog DVR hauv SharePoint hauv internet thiab xwb nicely.
- Cov dluab kuv siv nyob rau hauv lub _layouts directory (/_layouts/dluab/KPI...) yog muaj nyob rau hauv lub thawv nyob rau hauv kuv lub chaw ces lawv yeej muaj tej zaum koj yuav zoo li.
Ntawm no yog ib qho screen txhaj ntawm seb nws zoo li rau kuv:
</kawg>
Raws li kuv nyob Twitter tom http://www.twitter.com/pagalvin