Akelos Framework v1 forum archive. This forum is no longer maintained. To report bugs please visit https://github.com/akelos/akelos/issues
    • CommentAuthorraviepic3
     
    Hello all,

    Am new to akelos and MVC, i finished the author,book management tutorial, am looking for a deeper one which can make me learn things out, so you experienced people out there please let me know where i can find any guidance to achieve it.
    • CommentAuthorsuthern
     

    Well, you could just sit down and design your own database, then try to implement it.

    Here is a medium complex database you could try designing: Inventory control

    Table of Items, table of bins, table of warehouses, table of bin_items, table of transfers

    Rules

    • Each item can exist in multiple bins
    • Each bin can contain multiple items
    • Each warehouse has multiple bins
    • Each transfer can only transfer items out of the source bin that are actually IN the source bin.

    Schemes

    • Items: ID, NAME, DESCRIPTION
    • Bin_items: ID, ITEM_ID, BIN_ID, QTY
    • Bins: ID, LOCATION_CODE, WAREHOUSE_ID
    • Warehouses: ID, NAME, ADDRESS, PHONE_NUMBER
    • Transfers: ID, SRC_BIN_ID, DST_BIN_ID, ITEM_ID, COMPLETE (BOOLEAN)

    Views

    • See all items, with their qtys, wherever they are
    • See only a certain item, wherever it is
    • See all items in a certain bin
    • See all items in a certain warehouse
    • See all transfers for a certain item
    • See all transfers within the past week
    • See all transfers per warehouse
    • See all transfers per bin

    Actions

    The user should be able to:

    • Add / Edit / Deactivate Items
    • Add / Edit Bins
    • Add / Edit Warehouses
    • Easily add items to a bin from nowhere (inventory receiving)
    • Create transfers for items from one bin to another
    • Complete the transfers (modify/add the 'complete' checkbox for the transfer). This action should fire UPDATE events which update the corresponding bins.

    And that took me 10 min to think up and type. I'm certain you could come up with a lot more. :)

    [and no, this is not a request for code. We have a way better inventory control program already.]

    Have fun!

    • CommentAuthorsuthern
     

    <edit integrated with previous comment>