Template:Loadpersonaldata: Difference between revisions

From Dharmaraja College Archives
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
 
{{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}}
 
{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}}
{{#vardefine:Year|{{#expr: {{#sub:{{PAGENAME}}|-4|4}} }} }}
{{#vardefine:FindSNo|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}}
{{#vardefine:From|'{{#var:Year}}/01/01'}}
{{#vardefine:To|'{{#var:Year}}/12/31'}}
 
{{#get_db_data:
|server=drck-db
|from=wikiaffilations
|where=(AffiliationGroupID='1') and (AffilatedFrom>={{#var:From}} ) and (AffilatedFrom<={{#var:To}})
|order by=LastName ASC
|data=SNo=SNo,LastName=LastName,Initials=Initials, Photo=Photo,FirstName=FirstName, ID=ID, Title=Title, Photo=Photo, AffilatedFrom=AffilatedFrom,AffilationTo=AffilationTo
}}
 
{| class="wikitable"
! Name
! Admitted On
! Photo{{#for_external_table:<nowiki/>
{{!}}-
{{!}} [[{{{LastName}}} {{{Initials}}} (SNo:{{{SNo}}})|{{{Title}}} {{{LastName}}} {{{Initials}}} ( {{{FirstName}}})]]
{{!}} {{{AffilatedFrom}}}
{{!}} {{{Photo}}}
}}
|}

Revision as of 07:16, 9 December 2023