|
Wednesday, 08 July 2009 15:13 |
|
Please bid only if you have experience with Drupal 6.x, PHP and MS SQL.
My external (non-Drupal) MS SQL database has payment ledgers associated with customer accounts. I want the Drupal user to be able to access their own ledger in this database through their Drupal account.
The first time th user logs in, they need to establish a link between their Drupal account and their ledger in the MS SQL database by comparing their registered Drupal email with those in the database [EmailAddress]. Once their account in the database has been located, a permanent association should be made with their Drupal account and their user ID in the database [Tenant_ID] and corresponding lease ID [Lease_ID]. The Drupal user should then be able to view the entire payment ledger in the database.
My apologies that this description is not more technical.
Please, ask all the questions you'd like in order to make an educated bid. A sample of the MS SQL database is attached.
I would like this project to start as soon as possible.
Required:
Drupal 6.x
MS SQL
PHP
Views 2 module suggested, but alternatives will happily be considered
|
