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