Trying to work this out in my head isn't helping,
This is a specific function that is unlikly to have any design, rather than the function of seeing what jobs have come in and been sent out in the fact of royalities.
This is going to be showing a lot of information... Previous sales, as well as those that have yet to be paid.
select * from cp_royal where paid = 1
select * from cp_royal wehere paid = 0
iinsert into cp_royal set id = NULL, date = '$sub_date', quantity = '$sub_quantity', .. how do we work out the total to be paid,
if paid = 0 then find out the royality payment for the book, this also needs to go against the author, so there almost needs to be a three stage process - > book -> author -> payments...
could create an array that adds it all in, though we do not know what ones have been paid of not and I do not want to make the tick go on automagically. As there could be a slip up, do I get staff to enter a verification code when payments are made, or is this too much
One thing I would like to see is a template on how this works. Possible to do one on paper and check that all the requirements will be meet.