Ability to Edit Joomdle_purchased_courses table

Concerning the Parent / Child feature with Joomdle -> Configuration -> Shop Integration -> Buy courses for children set to "Yes":

Once an order is confirmed in the "Shop", it sets a quantity of courses in the Joomdle_purchased_courses table. If later on the order is changed after the order is confirmed but before the courses are assigned - this quantity of courses will remain assigned to the user. This sometime happens when the user changes courses due to schedule changes, etc. Currently, the only way to remove this order is to edit the database table directly. Request is for a Joomdle Component tab for "Parent/Child" (or Admin/Student) that would show these orders in queue with the ability to delete and/or modify the quantity of the order. Would also be good to have a filter set so that the admin could look at all orders, only the ones that have yet to be assigned, or filter by date.

Thanks!

Hi there.

Going through your parent-related suggestions, I am not sure if I understand this one.

> If later on the order is changed after the order is confirmed but before the courses are assigned - this quantity of courses will remain assigned to the user.

How do you change the order? In VM as a normal user? (I never tried that feature)

So, you are asking for a screen in backend, to list and edit purchased courses table, right?

Antonio - The shop that we use (Hikashop) allows you to modify the order as an admin. I believe the other shops have a similar feature. When an order is updated (i.e. change order in Hikashop to move student to a different course due that course not meeting the minimum # of students enroll, etc.), the order will be out of sync with the Joomdle purchased courses table.

Process as follows:

1. Parent selects courses for students. This order is entered into the shop with "created" status.
2. Admin accepts payment and order status is changed to "confirmed". Joomdle table is updated with course info and quantity ordered. Note: Parents have not yet "assigned" courses to students and triggered Moodle enrollment.
3. Parent / Admin decide to move student to different course. Order is updated - still in confirmed status.
4. Once all orders are confirmed and we are ready to populate Moodle enrollments, we turn on the ability to assign students to courses.
5. Parents will then assign students to courses and Moodle will be populated with proper student enrollments.

It would be great to see:

1. Screen in backend to list and edit entries in joomdle purchased courses table. Would also like to give admin the ability to assign courses to students for each order instead of parent only. Today only parents can assign students to courses within an order. With some families, we have to get parent log in info to properly assign which is complicates registration. Many times the admin knows which courses go to each student.
2. Cron job that could be periodically run to resync joomdle purchased courses table with current outstanding orders that have not yet been assigned to students.

Thanks!
Ron