pathCast
Log in

Difference between revisions of "pathCast"

From pathCast
(9 intermediate revisions by the same user not shown)
Line 12: Line 12:
 
,pathCast.title
 
,pathCast.title
 
,pathCastFiles._pageTitle
 
,pathCastFiles._pageTitle
|where=pathCast.date='{{#expr:{{#timel: Y-m-d|now + 1 day}}}}' AND hide=0 AND pathCastFiles.filetype='banner'  
+
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0 AND pathCastFiles.filetype='banner'  
 
|order by=pathCast.date ASC
 
|order by=pathCast.date ASC
 
|limit=1
 
|limit=1
Line 29: Line 29:
 
|format=dynamic table
 
|format=dynamic table
 
|where=MONTH(date)={{#timel: n|now}} AND YEAR(date)={{#timel: Y|now}}
 
|where=MONTH(date)={{#timel: n|now}} AND YEAR(date)={{#timel: Y|now}}
|}}
+
|default=''Check later for the {{#timel: F Y|now + 0 month}} lecture schedule''}}
 
<br>
 
<br>
 
{{text|'''{{#timel: F Y|now + 1 month}}'''|||6|}}<br><br>
 
{{text|'''{{#timel: F Y|now + 1 month}}'''|||6|}}<br><br>
Line 38: Line 38:
 
|format=dynamic table
 
|format=dynamic table
 
|where=MONTH(date)={{#timel: n|now + 1 month}} AND YEAR(date)={{#timel: Y|now + 1 month}}
 
|where=MONTH(date)={{#timel: n|now + 1 month}} AND YEAR(date)={{#timel: Y|now + 1 month}}
|}}
+
|default=''Check later for the {{#timel: F Y|now + 1 month}} lecture schedule''}}
 
<td>
 
<td>
 
</tr>
 
</tr>
Line 64: Line 64:
 
,pathCast.title
 
,pathCast.title
 
,pathCastFiles._pageTitle
 
,pathCastFiles._pageTitle
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0 AND pathCastFiles.filetype='banner'
+
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0 AND pathCastFiles.filetype='banner'  
 
|order by=pathCast.date ASC
 
|order by=pathCast.date ASC
 
|limit=1
 
|limit=1
 
|more results text=
 
|more results text=
|format=template|template=homeupcoming|}}
+
|format=template|template=homeupcoming|default=[[Image:pathCastTBD.jpg|class=halfwidth]]}}
 
<br><br><br>
 
<br><br><br>
{{text|'''{{#time: F Y|now}}'''|||6|}}
+
{{text|'''{{#timel: F Y|now + 0 month}}'''|||6|}}<br><br>
 +
{{#cargo_query:
 +
tables=pathCast,subspecialty
 +
|join on=pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=pathCast.date=Date,pathCast._pageName=Lecture
 +
|format=dynamic table
 +
|where=MONTH(date)={{#timel: n|now}} AND YEAR(date)={{#timel: Y|now}}
 +
|default=''Check later for the {{#timel: F Y|now + 0 month}} lecture schedule''}}
 +
<br>
 +
{{text|'''{{#timel: F Y|now + 1 month}}'''|||6|}}<br><br>
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=pathCast,subspecialty
 
tables=pathCast,subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
|fields=CONCAT('[[',pathCast._pageName,'|',subspecialty.hashtag,' - ',pathCast.title,']] - ',pathCast.date)
+
|fields=pathCast.date=Date,pathCast._pageName=Lecture
|format=ol
+
|format=dynamic table
|where=MONTH(date)={{#time: n|now}} AND YEAR(date)={{#time: Y|now}}
+
|where=MONTH(date)={{#timel: n|now + 1 month}} AND YEAR(date)={{#timel: Y|now + 1 month}}
|order by=date ASC
+
|default=''Check later for the {{#timel: F Y|now + 1 month}} lecture schedule''}}
|}}
 
 
<br><br>
 
<br><br>
 
{{text|'''Browse lectures by subspecialty'''|||6|}}<br><br>
 
{{text|'''Browse lectures by subspecialty'''|||6|}}<br><br>

Revision as of 10:41, 3 January 2021