Hello all,
I've been tasked with producing a report showing PayPal enrollments per course over a given reporting period (probably daily).
This is needed for Accounting to be able to reconcile any monies received.
Does something like this already exist? I've been searching and searching to no avail. Maybe I'm just not using the right search terms, as I would think this would be a common necessity.
Thanks in advance,
David
This is just a basic query that could be used to do this
select u.firstname as "firstname", u.lastname as "lastname", c.fullname as "course name", p.transtime as "Transaction Time", p.payment_status as "Transaction Status" from mdl_enrol_paypal p JOIN mdl_user u ON p.userid = u.id JOIN mdl_course c ON p.courseid = c.id;
This works for me on the Command line, and I am sure it will work fine in what ever DB management software you use...although this is for a MYSQL install. If you need additional info I would be glad to add to it. Hope this helps.
select u.firstname as "firstname", u.lastname as "lastname", c.fullname as "course name", p.transtime as "Transaction Time", p.payment_status as "Transaction Status" from mdl_enrol_paypal p JOIN mdl_user u ON p.userid = u.id JOIN mdl_course c ON p.courseid = c.id;
This works for me on the Command line, and I am sure it will work fine in what ever DB management software you use...although this is for a MYSQL install. If you need additional info I would be glad to add to it. Hope this helps.
SELECT u.firstname as "firstname", u.lastname as "lastname", c.fullname as "course name", p.transtime as "Transaction Time", p.payment_status as "Transaction Status" from mdl_enrol_paypal p JOIN mdl_user u ON p.userid = u.id JOIN mdl_course c ON p.courseid = c.id GROUP BY c.id, p.transtime ORDER BY c.id, p.transtime ASC;
That will spit it out grouped by the Course name and With Ascending dates, sorry for the lack of organization on that previous post.
That will spit it out grouped by the Course name and With Ascending dates, sorry for the lack of organization on that previous post.