Difference between revisions of "Home/ask/assignments"
m (removed infoxbox game dependency) |
m (changed to using datediff) |
||
| Line 1: | Line 1: | ||
| − | <div class="container-pcgwikitable"><table class="pcgwikitable sortable template-infotable" id="table-availability" style="max-width: 100%; min-width: 100%; margin: 0 auto"> | + | <div class="container-pcgwikitable"> |
| + | |||
| + | <div class="month-container"> | ||
| + | <div class="month"> | ||
| + | <p>May</p></div> | ||
| + | <table class="pcgwikitable sortable template-infotable" id="table-availability" style="max-width: 100%; min-width: 100%; margin: 0 auto"> | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Assignments | tables=Assignments | ||
| − | |fields= | + | |fields=Game,Status,Release_Date |
| − | |where= | + | |where=DATEDIFF(Release_Date, '2019-04-01') >= 0 AND DATEDIFF(Release_Date, '2019-04-30') <= 0 |
|format=template | |format=template | ||
|template=:Home/ask/assignments/row | |template=:Home/ask/assignments/row | ||
|limit=10 | |limit=10 | ||
| − | |order by= | + | |order by=Release_Date DESC |
|more results text= | |more results text= | ||
}} | }} | ||
| − | </table></div> | + | </table> |
| + | </div> | ||
| + | </div> | ||
| + | |||
| + | <div class="month-container"> | ||
| + | <div class="month"> | ||
| + | <p>May</p></div> | ||
| + | <table class="pcgwikitable sortable template-infotable" id="table-availability" style="max-width: 100%; min-width: 100%; margin: 0 auto"> | ||
| + | {{#cargo_query: | ||
| + | tables=Assignments | ||
| + | |fields=Game,Status,Release_Date | ||
| + | |where=DATEDIFF(Release_Date, '2019-05-01') >= 0 AND DATEDIFF(Release_Date, '2019-05-31') <= 0 | ||
| + | |format=template | ||
| + | |template=:Home/ask/assignments/row | ||
| + | |limit=10 | ||
| + | |order by=Release_Date DESC | ||
| + | |more results text= | ||
| + | }} | ||
| + | </table> | ||
| + | </div> | ||
| + | </div> | ||
| + | |||
| + | <div class="month-container"> | ||
| + | <div class="month"> | ||
| + | <p>June</p></div> | ||
| + | <table class="pcgwikitable sortable template-infotable" id="table-availability" style="max-width: 100%; min-width: 100%; margin: 0 auto"> | ||
| + | {{#cargo_query: | ||
| + | tables=Assignments | ||
| + | |fields=Game,Status,Release_Date | ||
| + | |where=DATEDIFF(Release_Date, '2019-06-01') >= 0 AND DATEDIFF(Release_Date, '2019-06-30') <= 0 | ||
| + | |format=template | ||
| + | |template=:Home/ask/assignments/row | ||
| + | |limit=10 | ||
| + | |order by=Release_Date DESC | ||
| + | |more results text= | ||
| + | }} | ||
| + | </table> | ||
| + | </div> | ||
| + | </div> | ||
| + | |||
| + | <div> | ||