pathCast
Log in

Difference between revisions of "pathCast"

From pathCast
Line 46: Line 46:
 
{{text|'''Upcoming lecture'''|||6|}}<br><br>
 
{{text|'''Upcoming lecture'''|||6|}}<br><br>
 
{{#cargo_query:
 
{{#cargo_query:
tables=pathCast,faculty,subspecialty
+
tables=pathCast,pathCastBanners
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
+
|join on=pathCast._pageName=pathCastBanners.pathCast
 
|fields=
 
|fields=
 
,pathCast._pageName
 
,pathCast._pageName
 
,pathCast.title
 
,pathCast.title
,pathCast.presenter2
+
,pathCastBanners._pageTitle
,faculty._pageTitle
+
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0  
,faculty.namefirstlast
 
,faculty.degree
 
,faculty.position
 
,faculty.institution
 
,pathCast.urlyt
 
,pathCast.series
 
,pathCast.date
 
,subspecialty.hashtag
 
|where=DATEDIFF(pathCast.date,NOW()) >= -0 AND hide=0
 
 
|order by=pathCast.date ASC
 
|order by=pathCast.date ASC
 
|limit=1
 
|limit=1
Line 67: Line 58:
 
|format=template|template=homeupcoming|}}
 
|format=template|template=homeupcoming|}}
 
<br><br><br>
 
<br><br><br>
{{text|'''{{#time: F Y|now}}'''|||6|}}
+
{{text|'''Current week'''|||6|}}
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=pathCast,subspecialty
 
tables=pathCast,subspecialty
Line 74: Line 65:
 
|format=calendar
 
|format=calendar
 
|where=MONTH(date)={{#time: n|now}}
 
|where=MONTH(date)={{#time: n|now}}
|view=month
+
|view=week
 
|}}
 
|}}
 
<br><br><br>
 
<br><br><br>

Revision as of 21:50, 8 September 2020