How to set reorder level

Post Reply
User avatar
viddz
Sergeant Major
Sergeant Major
Posts: 45
Joined: Fri Aug 26, 2011 6:06 am
Location: Colombo

How to set reorder level

Post by viddz » Wed Feb 15, 2012 6:15 pm

I wanna set reorder level to stock table when quantity is @ 11kg in mysql , php database ? pls help me
User avatar
Saman
Lieutenant Colonel
Lieutenant Colonel
Posts: 828
Joined: Fri Jul 31, 2009 10:32 pm
Location: Mount Lavinia

Re: How to set reorder level

Post by Saman » Wed Feb 15, 2012 10:57 pm

I wanna set reorder level to stock table when quantity is @ 11kg in mysql , php database ? pls help me
First of Welcome to ROBOT.LK !!!

This is really simple. Say you have items stored in a table named as 'item_table' with two fields as 'quantity' and ' reorder_level'. The you can program reorder level for each and every item on the database.

For example:

Code: Select all

item_id     item_desc                  quantity         reorder_level
A00001     Anchor butter 200g            10                 5
A00002     Sugar                          1000.5          11
I have taken your example to sugar. Current sugar quantity in-stock is 1000.5 Kg and the reorder level is set to 11 Kg.

You need to execute an SQL command as below to get the list of items which reached reorder level.

Code: Select all

SELECT * FROM item_table WHERE quantity <= reorder_level
Good luck!
User avatar
viddz
Sergeant Major
Sergeant Major
Posts: 45
Joined: Fri Aug 26, 2011 6:06 am
Location: Colombo

Re: How to set reorder level

Post by viddz » Wed Feb 29, 2012 10:30 am

Thanku very much saman. :D :D :D It is very useful.
Can u pls xplain according to ur example how we can just update table by amount like 10kg , 20kg like wise then i want to take the whole amount of stock. eg previous stock 1000kg , now um adding 10kg so the system should show 1010kg. Pls help me. Iam new to Php n mySql n um doing my first project these days. Thnks in advance
User avatar
Saman
Lieutenant Colonel
Lieutenant Colonel
Posts: 828
Joined: Fri Jul 31, 2009 10:32 pm
Location: Mount Lavinia

Re: How to set reorder level

Post by Saman » Wed Feb 29, 2012 3:17 pm

Code: Select all

UPDATE item_table SET quantity=quantity+10 WHERE item_id=A00001
User avatar
viddz
Sergeant Major
Sergeant Major
Posts: 45
Joined: Fri Aug 26, 2011 6:06 am
Location: Colombo

Re: How to set reorder level

Post by viddz » Wed Feb 29, 2012 9:34 pm

thank u very much :D . I never thought dat is so simple as u mentioned. :o.
Post Reply

Return to “PHP & MySQL”