Get a Freelance Job

Hello,

a client wants to know whether it would be possible for an sms to add data to a database and how it would be set up re script and hardware.

Currently we have a usb modem with a sim card in. We also have an online shop (OScommerce or Virtuemart for instance)

Each time an sms is sent to the sim (this will need to be scalable to allow several modems to be used) the sms contents can be read and used to update the database.

The application would be for the Safaricom Mpesa money transfer system used in Kenya. The client wants to be able to take live payments.

NB The actual money is being sent elsewhere, the sms is only notification (with info of name, phone number, amount, transaction number, account info (could be anything – username, invoice number etc)). There would probably have to some kind of callback confirmation to ensure the details are correct.

What we need to know is how the hardware would be set up and how the script would interact with the database, security and procedure etc.

This is quite a big leap for us and we need to discuss this (where should the server be, how it all connects up etc). I have attached a zip of the software that is loaded with the usb modem. It might give you some idea of how the information is read (for instance, if an sms is sent to the modem sim while it is connected to a pc the message is shown immediately on the PC s we are part way there already – but obviously you will need to look more closely at the details.)

This will need more discussion I am sure so please PMB

I am looking for some answers and then a quote.

Thanks

current work order script needs the following upgrades.

1 – current page needs to be put in template format like other pages..

2 – in the product name just type 999999 and put 1 in the qty and hit get details and you will see that it acts like it’s pulling up data for product 999999 but there isn’t a product named that. So i’d like if we type a wrong name or sku that it says Product Not Found or something to that effect.

3 – In the near future we cannot choose the qty we make up of a product. It has to already be determined by the master_batch.theoretical_yield. So instead of the qty field that we can type any number in we now need to change that to be a drop down box containing the theoretical_yeild(s) for that product. For example 89101 Lower Bowel Caps has 2 theoretical yield 10000 and 5000. So if i typed in Lower Bowel and clicked on 89101 then the drop down box should change to have 10000 and underneath 5000. So sorted largest to smallest.

4 – on the product name ajax field it would be nice to not have to start at the beginning of the sku or name. So if we started typing osmething in the middle of the name it would try and find it.

5 – Duplicate completed work order section (on work_order.php) for new Cancelled Work Order section. So work orders that have the work_order_time.status = CANCELLED would show up in this section and they would no longer show in the completed work order section. I’ve made 2 have the status of cancelled right now for testing purposes.