On Tue, 1 Oct 2002, Marvin Pascual wrote: > [NOTE: Cross-posted to PLUG and PLUG Newbie Mailing Lists.] > > Hello all, > > I need some inputs and/or advice regarding Postfix. My boss include me in a > project of the "E-mail Confirmation System" which will provide additional > service to all taxpayers who paid their taxes. In this process, the > taxpayers will receive an e-mail confirming that their payment was recieved > by the BIR with the following contents/information: > > - name of taxpayer > - taxpayer's TIN > - amount recieved > - date > - branch office/bank > - collecting officer's name/ID > - etc. > > My idea on this is to create a small database for e-mails to suffice the > need for the said project. This database will have at least two columns and > that would be the [1]e-mail address and the [2]TIN. When our Bank and > Reconcialiation System receives the payment from a certain taxpayer, it will > send the above information to the e-mail database that we will create and > will send automatically a confirmation e-mail to the taxpayer that BIR has > received their payment. > > Now my question is, how can I tell our e-mail database to tell our Postfix > to send a confirmation e-mail to the taxpayer's e-mail with the above > information? My idea on this is that the trigger column will be the TIN. > > My second and last question is, how can I filter the received e-mails from > the taxpayers and from bounced e-mails (considering the e-mail address is > wrong or doesn't exists) to the taxpayer's respective BIR regional and > district office? There is only one e-mail address/account (probably it > would be [EMAIL PROTECTED]) for the outgoing e-mails but if the > [EMAIL PROTECTED] receives e-mail from the taxpayers or receives bounced > e-mails, it will be forwarded to the taxpayers' respective BIR > regional/district offices' e-mail address/account to answer if there's an > inquiry or to call the attention of the taxpayer if it was a bounced e-mail > to provide the correct e-mail address.
I'm assuming you are using oracle. If your dba can create a table in oracle, for_notification, which contains: transaction_id, tin, email address, date payment was received, amount received, receiving branch, status and for each transaction received, insert a row with the columns of the table filled up, it's a simple perl script using DBI::Oracle running on a linux box that grabs all rows with 'status = 0' (0 = pending, 1 = sent), and create a form letter, fill in the information from the row, and send it off via Mail::Sender. This doesn't even need postfix, although if you want to keep the TIN/EMAIL address lookup db in a separate database, you can store it on a mysql or pgsql db, and have postfix access it directly as an alias map. > > Please forgive my ignorance, I just don't have any idea with Postfix and MTA > in general. Please give me some advice. > > Thank you very much in advance. > > God bless... > > --- > MARVIN T. PASCUAL > E-Mail: [EMAIL PROTECTED] > Tel. #: (+63-2) 925-2053/981-7068 > Mobile #: (+62-919) 314-1254 > Linux User No. 247147 > _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
