wpDataTables Hack: Default to current year

For speed-kini.de we have two types of tables:

  1. Tables which show the current rankings overall, women, juniors, foil..
  2. Tables which show rankings of previous years (archive) for overall, women, juniors, foil…

The initial approach was having two different wpDataTables: one for the current year and one with the year as variable. This duplication should ring all your software engineer alarm bells! 

Another possibility would have been to use the archive tables for the current rankings by just setting the variable to 2021, 2022 etc… this would mean work every year to edit the wordpress pages and manually increase the variable to the current year. So this is a bit nicer but still means regular maintenance work.

After some thought, I ended up with a neat approach how to use one table for both: current and archive.

For the current year you just leave the variable empty and for archive you specify the variable to your desired year. 
The mechanism to default to the current year in case no year is specified consists of two parts:

#1 Setting the default value of %VAR1% to a very high number (> 5000 should be enough 😉 )

#2 Small SQL modifications to the places which use %VAR1%

[...]

WHERE
YEAR(date) = LEAST(year(curdate()), %VAR1%)

[...]

Related Topics

9,147 comments

  4. Выведение из запоя в стационаре Воронежа — помощь при острых состояниях и хронической зависимости. Наши опытные наркологи используют современные методы лечения для быстрого и безопасного вывода из запоя.
    Выяснить больше – стационар вывод из запоя воронеж

  6. If you need quality create stamp online free
    for your business or personal needs, you can easily find it on the Internet and order it online.
    The rubber stamp maker available online is a fantastic resource for individuals and businesses alike. This online platform provides a wide range of design options and templates to choose from The website provides an extensive collection of designs and templates for users to select from. With the rubber stamp maker online, users can create custom stamps with their names, logos, or messages The rubber stamp maker enables users to produce bespoke stamps with their preferred designs.

    The rubber stamp maker online is user-friendly and requires no prior design experience The platform is intuitive and allows users to create custom stamps without any technical knowledge . Users can simply upload their design or select a template and customize it to their liking The online platform allows users to select a template and personalize it with their own text or images . The rubber stamp maker online is a cost-effective solution for creating custom rubber stamps The platform offers an affordable solution for creating personalized stamps .

    Using a rubber stamp maker online offers several benefits, including convenience and flexibility The online rubber stamp maker provides convenience and flexibility . Users can access the platform from anywhere with an internet connection The online rubber stamp maker can be accessed from anywhere, at any time . The rubber stamp maker online also eliminates the need for physical visits to a stamp maker Using the rubber stamp maker online saves time and effort .

    The rubber stamp maker online also provides a wide range of design options and templates The rubber stamp maker features a diverse selection of customizable templates and designs . Users can create custom stamps with different shapes, sizes, and colors Users can create personalized stamps with various shapes, sizes, and colors . The rubber stamp maker online is also an eco-friendly solution, as it reduces the need for physical materials Using the rubber stamp maker online reduces waste and minimizes the carbon footprint .

    Using a rubber stamp maker online is a straightforward process that requires a few simple steps The online rubber stamp maker is easy to use and requires a few simple steps . First, users need to select a design or template from the platform’s library The online rubber stamp maker requires users to choose a design or template . Next, users can customize their design by adding text, images, or logos The online platform allows users to customize their design with text, images, or logos .

    Once the design is complete, users can preview and edit their stamp Users can preview and edit their stamp before finalizing the design . Finally, users can order their custom stamp and receive it in the mail The online platform allows users to order their custom stamp and have it delivered . The rubber stamp maker online also provides customer support and assistance The platform offers help and guidance to users .

    In conclusion, the rubber stamp maker online is a convenient and cost-effective solution for creating custom rubber stamps The platform provides an easy and budget-friendly way to create personalized stamps . The rubber stamp maker online offers a wide range of design options and templates, making it suitable for individuals and businesses The platform features a vast array of customizable templates and designs . We recommend using a rubber stamp maker online for all your custom stamp needs We recommend using the rubber stamp maker online for all custom stamp needs .

    The rubber stamp maker online is a reliable and efficient solution that provides high-quality custom stamps The online rubber stamp maker is a reliable and efficient solution that provides high-quality custom stamps . Users can create custom stamps with their names, logos, or messages, and receive them in the mail Users can create personalized stamps with their names, logos, or messages and receive them by mail . Overall, the rubber stamp maker online is a great resource for anyone looking to create custom rubber stamps The online rubber stamp maker is a great resource for anyone looking to create custom rubber stamps .

  11. В Краснодаре клиника «Детокс» предоставляет услугу вызова нарколога на дом. Специалисты приедут к вам в течение 1–2 часов, проведут осмотр и назначат необходимое лечение. Все процедуры проводятся анонимно и с соблюдением конфиденциальности.
    Подробнее можно узнать тут – частный нарколог на дом краснодар

  12. Клиника «Детокс» в Краснодаре предлагает услугу вызова нарколога на дом. Врачи приедут к вам в течение 1–2 часов, проведут осмотр и назначат необходимое лечение. Услуга доступна круглосуточно и анонимно.
    Получить дополнительные сведения – нарколог на дом недорого

  27. Если вы хотите найти информацию о бонусах при регистрации, прочитайте наши рекомендации о видах вознаграждений; в одном из разделов материала естественно упомянут 1хБет промокод для получения приветственного бонуса. Мы объясняем, как указывать данные при регистрации и какие условия нужно выполнить для отыгрыша.

  44. Когда нужна срочная помощь, служба Stop-Alko в Екатеринбурге может выехать на дом, провести диагностику, капельницу и восстановление сил.
    Получить дополнительные сведения – наркологический вывод из запоя

  48. Code promo 1xBet pour 2026 : recevez une offre de 100% jusqu’a 130€ lors de votre inscription. Une promotion reservee aux nouveaux joueurs de paris sportifs, avec la possibilite de placer des paris gratuits. Inscrivez-vous avant la fin de l’annee 2026. Le lien ci-dessous vous menera vers le code promo officiel 1xBet — Code Promotionnel 1xbet Pour Nouveaux Utilisateurs. Le code promo 1xBet vous permet d’activer un bonus d’inscription 1xBet exclusif et de commencer a parier avec un avantage. Le code promotionnel 1xBet 2026 est valable pour les paris sportifs, le casino en ligne et les tours gratuits. Decouvrez des aujourd’hui le meilleur code promo 1xBet et profitez du bonus de bienvenue 1xBet sans depot initial.

Leave a Reply

Your email address will not be published. Required fields are marked *

ph91.de
Blog by Philipp Schreitmüller