Pharmaceutical system
- System sponsored by one of the biggest pharmaceutical companies to promote their products at chemists' shops and help them deliver medicines to consumers.
- Uses Perl as the underlying technology.
- A good example of our ability to work with other companies in system development, and produce large-scale systems and applications.
It must be mentioned that we cannot take full credit for the development of the system, as one of the components to be used for PDAs using PalmOS was developed by another organization.
The system is based on three dedicated servers, one of which receives requests from mobile devices and is used to synchronize mobile applications with the main system database using 'Net Update' module, developed by another company. The other two servers used for the work (a database (DB) server and HTTP server) were developed by us.
The DB server used a mySQL database to store the broad assortment of products from the pharmaceutical company. The front/back end server is an HTTP server that provides the system administrators with the ability to handle the base depot/ warehouse by keeping track of items and their assortment in the store.
We chose Perl as a platform for the back-end for two reasons:
- a) to let HTTP server communicate with the Net Update server using the same programming language, and;
- b) the loading on the server is very high and we use threads to handle clients' requests to the server.
Users of the system are authorised personnel or attorneys from the pharmaceutical company. Usually, attorneys are the owners of drug stores and are authorised to enter new attorneys in the system. Attorneys provide "floating" pharmacists access to the system to let them see medical goods available to them.
There are different types of floating pharmacists who are authorised to do different kinds of work for the system. Floating pharmacists visits patients to provide them with consultations, to sell pharmaceuticals or to provide them with nursing services. They immediately record all the services provided via the PDA application or via the back-end admin interface using a computer connected to the Internet. The floating pharmacists are able to prescribe medicines via PDA to end consumers.
Drugstores reserve required quantities of medicines. Every time the inventory falls below a specified level, the goods are replenished to the required quantity. The system also provides a credit system to let some drugstores order products using an "after sold" payment method.
Detailed reports are available to let the company keep track of key sales data and the most profitable drugstores as well as help devise strategies to incentivise drugstores.
In the subsequent phase of the project that we are working on now, the customer would like to allow the system to include multiple drug manufacturers. This is a complicated phase of the project, where we have to cater for a much higher system loading than at present. The basis for granting rights and privileges/powers for different users will also be much more complicated than it is now. Besides allowing members to work with different drug manufacturers, the latter will also be able to set their own price for the services offered by the floating pharmacists. However, the price bracket will be set by the main system administrator.
Scalable ProjectMay 2009 -
G'day Australia!
Webdevs.com's highly competitive and efficient solutions are now available to you from our Brisbane office, we look forward to pushing on with our expansion in the coming months.
March 2009 -
Our first Android project is live
On it's first day the application has been awarded multiple 5 star ratings!
PPC Editor is a downloadable application developed for the first Android phone (the G1) for managing your advertising campaigns. PPC editor allows you to pause/resume your campaigns and edit daily budget quickly from your G1 phone.
May 2008 -
WebDevs.com Now under UK Ownership
WebDevs.com provides rapid web-based development expertise to companies in the United Kingdom, western Europe and The United States that are looking for top-quality services at competitive rates.
Now under new ownership by a UK holding company, WebDevs.com is an established company with an offshore facility in the Ukraine. Expansion plans for 2008 and beyond are underway.