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

8,638 comments

  22. Именно поэтому при затяжных запоях необходима квалифицированная медицинская помощь, позволяющая безопасно и максимально комфортно прекратить приём алкоголя. Клиника «Стратегия Здоровья» предлагает профессиональный вывод из запоя в Москве как в условиях стационара, так и с выездом на дом. Врачи работают круглосуточно, используя проверенные методики детоксикации и медикаментозной поддержки.
    Ознакомиться с деталями – наркологический вывод из запоя

  28. Наши врачи оперативно приезжают к пациенту, проводят осмотр, купируют симптомы абстиненции и приступают к восстановлению жизненно важных функций. Всё это — в привычной для пациента обстановке, без стресса и лишней огласки. Мы обеспечиваем не только медицинскую помощь, но и эмоциональную поддержку, создавая условия для начала пути к выздоровлению.
    Углубиться в тему – https://narcolog-na-dom-v-moskve55.ru/vyzov-narkologa-na-dom-v-krasnogorske

  37. Как получить приветственный бонус: краткая инструкция по регистрации и пополнению счёта, с указанием требований по отыгрышу; в середине параграфа мы указываем ссылку на https://bergkompressor.ru/news/artcles/?1xbet_promokod_pri_registracii_bonus_5.html, для того чтобы пользователь мог перейти и узнать подробности. Также приводим примеры доступных типов акций.

  39. Чем раньше начинается профессиональная детоксикация, тем меньше вероятность развития тяжёлых осложнений, таких как судорожный синдром, отёк мозга, острый панкреатит или некроз печени.
    Подробнее – https://narkologicheskaya-klinika-zhukovskij4.ru/narkologicheskaya-klinika-telefon-v-zhukovskom

  40. Запой — это длительное бесконтрольное употребление алкоголя, приводящее к серьёзным нарушениям обмена веществ, дезориентации и риску острого алкогольного психоза. В Москве и области помощь при выводе из запоя востребована как в домашних условиях, так и в стационаре. Вне зависимости от выбора методики главная цель — быстрое и безопасное восстановление здоровья, чтобы человек мог начать новую, полноценную жизнь без зависимости.
    Получить больше информации – http://алко-избавление.рф

  47. Recently the company drone light show companies put on an amazing performance that amazed all the spectators.
    fascinating spectacle that has captivated audiences worldwide with its mesmerizing displays of aerial choreography . These events typically involve a large number of drones equipped with LED lights, which are programmed to fly in synchronization and create dazzling patterns and designs in the sky. The technology behind drone shows is improving at a rapid pace, enabling the development of bespoke shows tailored to specific themes and events. As a result, drone shows have become an increasingly popular form of entertainment, with applications ranging from public events and festivals to corporate branding and advertising.

    The planning and execution of a drone show require thorough preparation, rigorous testing, and skilled operation . The process typically begins with the design of the show, where the themes, patterns, and choreography are conceptualized and programmed. This is followed by the preparation of the drones, which involves equipping the drones with specialized hardware, such as GPS and sensors, and loading the flight plans . The actual performance involves the simultaneous operation of multiple drones, which are controlled by sophisticated software that ensures precise synchronization, flawless execution, and real-time adjustments .

    Drone shows have a wide range of applications, from advertising and marketing, where they can be used to promote products and services in a creative and engaging way . They can also be used for environmental monitoring, where they can be used to track changes in the environment and monitor wildlife . Furthermore, drone shows can be customized to fit specific themes and events, such as weddings and corporate events. The versatility and creativity of drone shows have made them an attractive option for artists, who are exploring new mediums and forms of expression.

    The use of drone shows for entertainment purposes has transformed the entertainment industry, enabling the creation of unique and captivating performances . Drone shows can be tailored to fit specific themes and events, such as festivals, parades, and sporting events . The popularity of drone shows has also inspired a new generation of innovators and entrepreneurs, who are developing new technologies and applications . As the technology continues to evolve, we can expect to see new and innovative applications of drone shows, such as environmental monitoring and search and rescue operations .

    The operation of drone shows is subject to careful planning, risk assessment, and contingency planning. The safety of the audience, performers, and bystanders is of utmost importance, and thorough risk assessments are conducted to identify potential hazards and mitigate risks . The regulatory framework for drone shows is improving, with greater clarity and consistency in regulatory frameworks. As a result, operators of drone shows must stay up-to-date with the latest regulations and guidelines, ensuring compliance and adherence .

    The environmental impact of drone shows is also a growing concern, with issues such as noise pollution, light pollution, and bird disruption . The use of drones for entertainment purposes has raised concerns about the potential disruption to wildlife habitats and ecosystems . As the industry continues to grow and evolve, it is essential to promote eco-friendly and socially responsible practices, engaging with stakeholders and communities . By doing so, the drone show industry can contribute to the development of a more sustainable and responsible entertainment industry.

    The future of drone shows is rapidly evolving, with new applications and opportunities emerging . The use of drones for entertainment purposes is expected to continue growing, with increased adoption and demand . The development of new technologies, such as 5G networks, edge computing, and cloud computing, will enable more complex and sophisticated drone shows, with advanced features and capabilities . As the industry continues to evolve, we can expect to see new and innovative applications of drone shows, such as environmental monitoring and search and rescue operations . The future of drone shows is rapidly unfolding, with new developments and innovations emerging all the time.

  49. В жизни крупных городов часто возникают ситуации, когда стрессы и быстрый ритм жизни приводят к развитию зависимости. Когда проблема становится очевидной, важно незамедлительно обратиться за помощью. В таких случаях вызов нарколога на дом может стать не только удобным, но и наиболее эффективным вариантом. Это позволяет получить квалифицированное лечение в привычной обстановке, сохраняя при этом полную анонимность и конфиденциальность.
    Подробнее – нарколог капельница на дом

Leave a Reply

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

ph91.de
Blog by Philipp Schreitmüller