Wiki source code of Supplier & Contract Overview
Last modified by Lee Pedley on 2026/09/23 10:35
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
| |
1.1 | 1 | {{velocity}} |
| 2 | #set($supplierDocs=$services.query.xwql("from doc.object('Suppliers and Third Parties.Code.Suppliers and Third PartiesClass') as obj").setLimit(3000).execute()) | ||
| 3 | #set($contractDocs=$services.query.xwql("from doc.object('Supplier Contracts.Code.Supplier ContractsClass') as obj").setLimit(5000).execute()) | ||
| 4 | #set($activeSuppliers=0)#set($criticalSuppliers=0)#set($reviewDue=0)#set($activeContracts=0)#set($expiring90=0)#set($expired=0)#set($contractReviews=0)#set($alerts=[]) | ||
| 5 | #foreach($ref in $supplierDocs)#set($d=$xwiki.getDocument($ref))#set($o=$d.getObject('Suppliers and Third Parties.Code.Suppliers and Third PartiesClass'))#if($o)#set($st=$o.getProperty('status').getValue())#set($crit=$o.getProperty('criticality').getValue())#set($due=$o.getProperty('nextReviewDate').getValue())#if($st=='Active')#set($activeSuppliers=$activeSuppliers+1)#end#if($st=='Active' && $crit=='Critical')#set($criticalSuppliers=$criticalSuppliers+1)#end#if($due && $st!='Terminated' && $datetool.whenIs($due).days<=30)#set($reviewDue=$reviewDue+1)#set($x=$alerts.add(['Supplier review',$ref,$d.displayTitle,$xwiki.formatDate($due)]))#end#end#end | ||
| 6 | #foreach($ref in $contractDocs)#set($d=$xwiki.getDocument($ref))#set($o=$d.getObject('Supplier Contracts.Code.Supplier ContractsClass'))#if($o)#set($st=$o.getProperty('status').getValue())#set($expiry=$o.getProperty('expiryDate').getValue())#set($review=$o.getProperty('nextReviewDate').getValue())#if($st=='Active'||$st=='Expiring')#set($activeContracts=$activeContracts+1)#end#if($expiry && $st!='Terminated' && $st!='Superseded')#set($days=$datetool.whenIs($expiry).days)#if($days<0)#set($expired=$expired+1)#set($x=$alerts.add(['Contract expiry passed',$ref,$d.displayTitle,$xwiki.formatDate($expiry)]))#elseif($days<=90)#set($expiring90=$expiring90+1)#set($x=$alerts.add(['Contract expires within 90 days',$ref,$d.displayTitle,$xwiki.formatDate($expiry)]))#end#end#if($review && $st!='Terminated' && $st!='Superseded' && $datetool.whenIs($review).days<=30)#set($contractReviews=$contractReviews+1)#set($x=$alerts.add(['Contract review',$ref,$d.displayTitle,$xwiki.formatDate($review)]))#end#end#end | ||
| 7 | {{html wiki="true" clean="false"}} | ||
| 8 | <style>.sup-kpis{display:grid;grid-template-columns:repeat(auto-fit,minmax(180px,1fr));gap:12px;margin:14px 0 24px}.sup-kpi{border:1px solid #d9dfe5;border-radius:8px;padding:14px;background:#fff}.sup-num{font-size:2em;font-weight:700}.sup-actions{display:flex;gap:7px;flex-wrap:wrap;margin:12px 0 20px}.sup-table{width:100%;border-collapse:collapse}.sup-table th,.sup-table td{padding:8px;border-bottom:1px solid #e1e5e9;text-align:left;vertical-align:top}</style> | ||
| 9 | <div class="box infomessage"><strong>Supplier & Contract Overview</strong><br/>Third-party governance, supplier review and contract renewal/expiry oversight. The 90-day contract-expiry warning is a management default for planning, not an ISO requirement.</div> | ||
| 10 | <div class="sup-actions"><form action="$xwiki.getURL('Suppliers and Third Parties.WebHome','create')" method="get"><input type="hidden" name="templateprovider" value="Suppliers and Third Parties.Code.Suppliers and Third PartiesTemplateProvider"/><button class="btn btn-primary" type="submit">Add Supplier</button></form><form action="$xwiki.getURL('Supplier Contracts.WebHome','create')" method="get"><input type="hidden" name="templateprovider" value="Supplier Contracts.Code.Supplier ContractsTemplateProvider"/><button class="btn btn-primary" type="submit">Add Contract</button></form><a class="btn btn-default" href="$xwiki.getURL('Suppliers and Third Parties.WebHome','view')">Supplier Register</a><a class="btn btn-default" href="$xwiki.getURL('Supplier Contracts.WebHome','view')">Contract Register</a></div> | ||
| 11 | <div class="sup-kpis"><div class="sup-kpi"><div class="sup-num">$activeSuppliers</div><strong>Active suppliers</strong></div><div class="sup-kpi"><div class="sup-num">$criticalSuppliers</div><strong>Critical suppliers</strong></div><div class="sup-kpi"><div class="sup-num">$reviewDue</div><strong>Supplier reviews due / overdue (30 days)</strong></div><div class="sup-kpi"><div class="sup-num">$activeContracts</div><strong>Active contracts</strong></div><div class="sup-kpi"><div class="sup-num">$expiring90</div><strong>Contracts expiring within 90 days</strong></div><div class="sup-kpi"><div class="sup-num">$expired</div><strong>Contracts past expiry</strong></div><div class="sup-kpi"><div class="sup-num">$contractReviews</div><strong>Contract reviews due / overdue (30 days)</strong></div></div> | ||
| 12 | <h2>Attention queue</h2> | ||
| 13 | #if($alerts.isEmpty())<div class="box successmessage">No supplier reviews or contract review/expiry items fall within the current attention windows.</div>#else<table class="sup-table"><thead><tr><th>Attention</th><th>Record</th><th>Date</th></tr></thead><tbody>#foreach($a in $alerts)<tr><td>$escapetool.xml($a.get(0))</td><td><a href="$xwiki.getURL($a.get(1),'view')">$escapetool.xml($a.get(2))</a></td><td>$escapetool.xml($a.get(3))</td></tr>#end</tbody></table>#end | ||
| 14 | <div class="box warningmessage" style="margin-top:20px">Commercial contracts may contain sensitive pricing, legal or personal information. Configure XWiki access permissions appropriately before wider rollout.</div> | ||
| 15 | {{/html}} | ||
| 16 | {{/velocity}} |