Can you market books very well?

Categories:
1. Secondary schools
2. Higher institutions

Email me: peaceogbemudia@gmail.com

airsaylongcon:


Is your HMS for ambulatory care?

Didn't include it, but I always can if you want it...

airsaylongcon:
I CANNOT believe that coders are expending energy rebuilding the wheel! This is a basic point of sale solution that has been built times without number in PHP. Op, there's a plethora of readily available solution. In Java try Unicenta opos, PHP try OSPOS (open source POS). If it's purely for inventory management, hit me up for solutions

PS: Those things you referred to as 'qualities' are properly called Unit of Measure (UOM)

You just need to exercise yourself and create some things from scratch by yourself - you get to learn more and have the advantage.

I've completed the Hospital Management Software successfully... just a little playing with if/else!

Duchman67:
You will need to sit down with the pharm and get the least saleable unit per drug and use that to build the database structure. Stock page and sales should mirror each other in the aspect of unit per drug.

The stock update on the database is an insert statement and the sales update is an insert statement but with negative quantity column insert. So both stock statement and sales must be of the same unit type for maximum accuracy. Any thing outside this will introduce extensive inaccuracy on column sum statement. On the database structure it can not be dynamic as far as i can see(though a more informed mind can prove otherwise)

Good point about having same unit of measurement accross... Any conversions I'll make will probably be on a pre and post basis i.e. before and after insertion/update.

I'm already doing something; inserting sales and purchases with units and quantity descriptions, and immediately updating stock table with + for purchase and - for sales... Once I sort out the dynamic conversions of the units of measurements just for user flexibility - it's done!

Thanks for the insights...

Duchman67:
My design will convert both stock purchases and sales to the common unit. So the pharm buying a carton of panadol will be listed in stock database as 300 packets of panadol.

Sales input into the database will be an insert statement where the quantity is multiplied by -1 to get a negative quantity value. Stock purchases input into the database will be an insert statement with no quanttity multiplication by -1

So a sum column statement shows no stock if result less than 1.
You can have a cron job run the sum column statement on each drug and email/sms you when the result of that mysql query hits a certain threshold/number.

The sales may not only be packets, maybe in sachets as well (there may be more than one sachet in a packet depending on the drug package structure). Numbers of packets per carton will certainly differ with drugs, and sachets per packets - we are not only dealing with panadol in which its unit structure we can just assign as static variables. So, we have to keep things dynamic and allow them use the software flexibly...

I need insight on going about the dynamic conversions, and probably the database structure...

elninosft:


Do you want it done for you or you need the script?

I'll appreciate the script sir.

I'm trying to code a software for a pharmacy that will allow them to manage their sales, purchases and stock.

For every stock they purchase; they'll be able to add 'item name', indicate quantity by description e.g. 'sachet, packet or carton' of drugs with a dropdown, and indicate quantity in units of '1, 2, 3 etc'. Eg. a purchase of item 'panadol', '3(units)' of 'cartons' and /or item 'paracetamol', '5(units)' of 'packets'.

Now, I'm trying to convert dynamically the relationship between the qualities sachet, packet, carton and possibly other quantities they'll enter in the qualities table...

So that in the end, when they make sales of 5 packets of panadol a day, the system will automatically calculate the balance stock from 3 cartons based on the quantity relationship between sachets, packets and cartons...

jento:


If you want the PRO, then call the number below so that all your Laravel and web development problems will disappear.

R Programming
Python Programming
PHP Programming
JavaScript Programming
HTML
CSS
SASS, LESS or STYLUS

09031649887

I'm talking about collaborating on a project together...

I need to meet with some Laravel developers within Benin City fr a project...
Let's signal our presence.