List resources alphabetically

[wingoo]

The resources appear to list in order of creation in the schedules and resources lists. Is it possible to list them alphabetically by resource name?

Also, it would be handy to have the resource image appear on the reservation screen to ensure the right resource is being booked.

Otherwise working great now.

Thank you for all the hard work you put into version 2 Nick.

[funkeirox]

I have same problem wingoo with resource names i looked in template file but can't change this thing, we have to edit some function i just dont know where.

[Nick]

I'm fixing this for 2.1.

The changes are in lib/Database/Commands/DataConstant.php

Code:

const GET_ALL_RESOURCES =
            'SELECT *
FROM resources r
ORDER BY r.name';

Code:

const GET_SCHEDULE_RESOURCES =
            'SELECT
*
FROM
resources r
WHERE
r.schedule_id = @scheduleid AND
r.isactive = 1
ORDER BY r.name';

[wingoo]

Thank you Nick, it is now alphabetic

[funkeirox]

Thank you for the help nick

[IflyGC]

Nick,

Thanks for posting that.  I just had to go in and put it back to sorting by resource_id and couldn't figure out why it had changed.  :-)

Great program by the way!

Dave