2. PHPRunner General questions
  3. [SOLVED]  Looking for code for a Inventory System
This topic is locked
[SOLVED]

 Looking for code for a Inventory System

 		8/8/2019 11:22:34 AM
PHPRunner General questions
K
 Kay author

Hi Guys,
i am looking for asolution for an inventory system.
My plan ist a system for inventory with a table for imported orders and a "ready_to pick_queue" table.

First i want to save some articles or material in a table (maybe a pseudo warehouse: hall 1, shelf 1-4, column 1-4, boxes 1-4)

So i make a stock. (incoming items from suppliers, outgoing items to customer)
If the order is now set to the status "activate_pick", the stock for this order should be deducted directly from the stock.

Once the order has been collected, the order should be sent to a ready to package status.
How can i solute that?

Any information was helpful. Thank you !
with regards

Kay
lefty 8/8/2019



Hi Guys,
i am looking for asolution for an inventory system.
My plan ist a system for inventory with a table for imported orders and a "ready_to pick_queue" table.

First i want to save some articles or material in a table (maybe a pseudo warehouse: hall 1, shelf 1-4, column 1-4, boxes 1-4)

So i make a stock. (incoming items from suppliers, outgoing items to customer)
If the order is now set to the status "activate_pick", the stock for this order should be deducted directly from the stock.

Once the order has been collected, the order should be sent to a ready to package status.
How can i solute that?

Any information was helpful. Thank you !
with regards

Kay


At first note contact xlinesoft directly for some support hours . If that don't help , I do write inventory systems. Here is a sample . See Video .
K
 		Kay author 8/10/2019

first- my english is not so good ^..^ <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=88464&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
If you have already a inventory system, maybe it can be useful - but what i want is:

  1. table customer - every order need a customer what this order is for
  2. table orders - to save the orders with the status: new, ready to pick (now this order was viewed in a picking table), picked (this status comes from the picking table), packed, shipped (+date as option)
  3. picking table - (maybe a view from a order table) with a list for the ordered items and status ready to pick (when a worker set the status to ready to pick a the order goes to this queue, i want that

    the programm deducted the items from the stock in the inventory table. / status: picked. Every item that he must pick - must be confirmed as picked by a worker.
  4. inventory table: item_id, name, location (the locations can be at more than one position, think that was an extra table), stock.
  5. locations table for the items: loc_id, item_id, hall, sheft, boxes.
    The important step in this logic was that the ordered items goes deducted from the inventory stock, if i put the pick_status into ready_to_pick and "put" it into the picking queue.

    Also it make a sense, because the ordered item are reserved now for this order - the office can buy new items - if the stock has a minimium stock.
    Can you do it? I want it as a project file for PHPRunner. I use the version 10.2 (build 33460 x64).
    Thank you!
    EDIT (and marked as Solved):
    put this at the EventPage -> important: to the table tbl_transactions, Add page & Edit Page -> both the same code -> After record added:

IF($values["general_status"] == "ready_to_pick")

{

CustomQuery("update tbl_products set stock = stock -".$values["quantity"]." where product_id=".$values["product_id"]);

}


The item are deducted, if you add a new "order" with the status "ready_to_pick".

The item are deducted, if you edit a new order status from "new" to "ready_to_pick".

So: just when you set the order as "ready_to_pick" the item are deducted from the stock of items.
The Table tbl_products are:

id, product_id (INT), stock (INT), name.
The Table tbl_transactions:

id, product_id (INT), quantity (INT), general_status (lookupwizard with values: new, ready_to_pick)
Hope you can understand it. Ask me for questions.

Nice Afternoon!
C
 		Corrie 9/21/2019

This might help. Its very basic, but you can build onto it.
https://www.youtube.com/watch?v=9oKo_pIxV_4&list=PLCLr0ZOSLTPB3BV0a7a-OOvHKecCagBDE