Pseudocode For Inserting Repeating Invoices

• Tweet
• 

        This is far closer to a suggested solution than actual usable code.

For all in Template
        i = int((date()-Template.lastbilldate)/Frequency.everyxdays)
        while i > 0
                Addbill(Template.templateID)
        end
End

Function Addbill(int Template.templateID)
        Insert into Bill(Amount.AmountID, Date(), "Membership Fees", Template.memberID
End

Tags:
• pseudocode
• SQL