Distribution editor for Erupe 9.3

[Noiregya]

Fix distributions for the upcoming Erupe version 9.3

Because of a change in data model for distributions in Erupe 9.3, the distribution editor is no longer compatible and have been updated.

Changelog

• Edited the DistributionItem class, renamed to DistributionItems to match the new table name and is now managed with Doctrine
• HR requirements are now nullable as a null attribute means no requirement in Erupe 9.3
• A new method based on the csv one was put in place to export data as Json to be able to store multiple tables in a single file, this method is reusable like the old one was
• Importations with the new json-based system will no longer let postgres create new indexes, which means when you import, the IDs the items had at the time of export will stay the same, this is done to support the dependencies between the two tables

Additionnal notes

• If you just updated and import doesn't work, clean your cache
• Previous distribution exports will no longer be usable
• This will BREAK support for distributions for Erupe 9.2 and older as the new system is too incompatible with the old one

ETA

Initial testing is done and passing, but more tests should be realized by more people soon.

---

Hi, how is it going? I love this tool so I've made this, hope you like it! I've done that in my free time as someone with no prior PHP knowledge, so don't hesitate to be critical if you think something could be improved.

Have a great day!

[Noiregya]

New discoveries after user testing:

• 2 new fields have been added to distributions, rights and selection, they need to be added to the UI, i'll try to do it soon.
• Some users of the beta version depending on the version of the upgrade script they have may have a non nullable "data" column in the distribution table. Dropping it will fix the tool.
• I forgot to change the UI element that says to put HR requirements to 65535 to mean no requirement, this is no longer true, the field needs to be left blank now

[Noiregya]

Two new values have been added to erupe

• The patch scripts need to be installed up to 23-rework-distributions-2.sql.
• If your server was created a long time ago, an oversight may prevent you from saving edits, execute this on the database to fix the issue:
• ALTER TABLE IF EXISTS public.distribution ATER COLUMN data DROP NOT NULL;

At the moment, the check for courses in game needs to be tested.

[Noiregya]

It's assist not assit...

[Noiregya]

New features tested successfully @Chakratos I recommand merging when erupe 9.3 comes out of beta, or merge into a new branch.

[Chakratos]

Thank you very much for your work, i really like it! I will do as you suggest and wait until Erupe 9.3 is released before merging :)