Multiple waiting lists

[bobintetley]

While the waiting list's original intent was for people surrendering animals, there are shelters in places where the demand for animals outstrips the supply. People sometimes use it as a waiting list for adopters.

Occasionally, we get a customer who wants to do both. Allow multiple waiting lists, requires a new lookup table lkwaitinglisttype - this will be a dropdown on the waiting list screen so that each list can be chosen. lkwaitinglisttype will have one default entry for "Surrenders". More types can be added under the lookup screen for Adopters or whatever someone might want to do.

animalwaitinglist will need a new column WaitingListTypeID

Rank needs to be calculated for each waiting list type.

[mgharvey2]

At our shelter we keep a waiting list for owner surrenders, and a list of people using the food bank. The owner surrenders need to sort by longest to shortest elapsed time. The food bank list need to show elapsed time greater than or less than 30 days.

[bobintetley]

Thanks for the feedback, sounds like this would be a useful feature for us to prioritise. I think #874 is related and should be done at the same time.