Hi Monks

At the moment I'm developing a billing application which wil interface with authorize.net, due to the way I am encrypting the credit card details I will be logging into the system and running the transaction due to the fact I wont be storing the encrypt/decrypt key on the server, so I will need to enter it when a run is initiated. Account are re-billed so unfortunately cc storage is essential

The only hurdle I am facing is how to schedule which accounts are to be billed, I would really like some feedback on the best approach to doing this and would be very greatfull for any suggestions, here are my thoughts in doing this:

Have a time(); stamp, and compare it with the transaction last run, if it was > 2592000 ago (a month) run the new one (problem here being that it may also have annual billing so the numbers could get very large, and the different lengths of the months may pose a problem)

Use a simple date in the form of next-bill: 22-02-2002 - when the billing run is started it will just compare todays date with that of the next-run column, if a match is made the transaction will be processed. (problem here, is that if the billing isnt run for that day, the transactions will be missed)

Sorry for the lengthy post, any thoughts would be appreciated

In reply to Credit Card Billing by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.