ProveedorVirtual, Clients management, PHP+Mysql+Curl Software.

This proyect needs to be done on PHP/MySQL … as it should work online on a server (linux w/cpanel) we have.

The system should be in SPANISH, but its okey, if its on english if it have a lang file to translate.

Basically… it relies on a transactional software that is already built… its a platform for giving credit to pre-paid cellphones, the platform actually does everything, but we basically need to capture information from it, as well as do some tasks without get in the website, login, etc.

As the provider does not provide an API, we need to say… navigate the site from a php software, capture and send information, like if we were doing it in the site. (like with curl+php, etc)

Basically we need :

1) Capture information from this system, most of this can be acquired from the "Informes" (with the buttons), it gives a html, or a .XLS file that we can use. Now we do this manually, so we need to automatize the Receipt printing, etc.

There are many different XLS we can get there, we basically in the start, needs to be able to get actual client lists, and then capture movements on the accounts that is on another XLS file obtained there. All clients have a unique ID already, etc.

2) Be able to also put data in the system (inter actuate with this system to be able to at least deposit money on a client account from our system

3) Then, build a system with all this information… that will include client information, and history of client purchases, like a CREDIT/DEBIT and amount unpaid, etc. That will also allow us to generate a sale manually on client accounts from our system, and generate a receipt of the sale.

How it works?…

Client calls and asks "please, put 300 on my account".

We manually login to the system, search for client, get in the option to put 300 on this account.

Client can pay this at the moment of sale, or can pay this later. (many clients pays 3 or 5 sales, later together).

We also manually generate receipts login to the system, downloading 2 XLS files, building a 3rd XLS file, then opening with WORD to fill receipts semi-automatically, and print them, order them by client, and then go to client with 1 - 5 receipts so client pay them.

What we need is to automatize this…. we also need to automatize sales to some clients, like we need a cron on the server that checks how much client have, and if they have "automatic" enabled, the system should GIVE clients a defined amount when they reach a minimum level. (Ie. when $client_money < $minimun_amount … add them $defined_automatic_amount …. and this should also generate a receipt to charge client later.

We also need to know what receipts are paid, and which ones not…

Ideally, this can be done with a barcode reader… (I see this working this way)… but not sure how this and/or if this works with PHP/mysql, or needs some kind of external software (we use MAC and PC, and some times Cellphones to access the system, so thats why a php/mysql is what I think is better).

So thats why we need a system…. our systems needs to have basically all our clients, and how much money they bought, and how much they paid, have the receipts of each sale, which one is paid and which one not, and also allow us to make sales from our system and print receipts automatically. (or better… generate the receipts… that can be printed at end of the day with "print unprinted receipts button" or something like this.

If it have a barcode… barcode needs to have some code of the receipt, as well as amount, or so, this way, when we give someone the receipts to go to the clients to charge them, and he cames back with the money, we can just barcode "pip" pip pip, each receipt and get the total amount he should have in hand. This can also be in the system, know what receipts I give to the guy "XXXX", to know they came back with the same amount of receipts paid and the money. Like we should have "collectors" … we print receipts and "load" them on some collector, to know later when he cames back.

I can provide a login/password to the main system, if someone wants to take a look at the code to fine tune, his quote. There you can see how it works, as it used ajax to navigate the site, and is a .jsp based site, I was able to login simple with a php/curl to the site, but of course, I don't know how to go further.
So for any developer really interested in the proyect, I can provide a login/password now, so they can look at your quotes, or answer any question you may have. You can also get helped from our Professional Web Designer (html/css/images) on what you may need.

MySQL PHP Software Architecture

Project ID: #5144975

About the project