php - Inventory with multi - unit support feature -

-

i have been developing inventory system (php codeigniter & mysql), have setup except 1 feature 1 of clients wants implement system - multi - unit support feature system.

currently system supports single unit per item per transaction:

item_desc: item1 default_unit: pc reorder: 1 in_stock: 25 remain: 25

in multi - unit feature, become:

item_desc: item1 default_unit: pc big_unit: pack pack_size: 50 reorder: 1 in_stock: 25 pack remain: 24 pack 5 pc

can give me hint on easy way implement this? want know start on thing. appreciate if share idea regarding on 1 :)

we launched v2 of our website , i've gone through 8 months of kinds of questions myself. best way separate tables products, inventory , listings.

products holds product specific information only, things never change. inventory holds information current inventory only, ie quantity on hand, backorder, location in warehouse etc. listings how handle multi item support. table hold listing information , draw other 2 tables product , quantity data. you'd have basic table structure this

products

  • productid
  • productname
  • productmodel
  • productdescription

inventory

  • inventoryid
  • productid
  • quantityonhand
  • location

listings

  • listingid
  • inventoryid
  • quantityinlisting
  • numberoflistings
  • price

our company sells lot of preowned things listings change regularly, set listings auto-populate based on inventory if you're selling new things restock. doing way means don't end ton of data duplication if created products multiples. allows sell item in quantity , set prices quantities manually.


Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

jquery - Clone last and append item to closest class -

-
this bare-bones code on page: <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <di
Read more

c - Unrecognised emulation mode: elf_i386 on MinGW32 -

-
i'm trying make kernel, , cannot link c output assembly. ld . i'm getting error: unrecognized emulation mode: elf_i386 i'm using windows 10 professional mingw32 , msys. code using: link.ld /* * link.ld */ output_format(elf32-i386) entry(start) sections { . = 0x100000; .text : { *(.text) } .data : { *(.data) } .bss : { *(.bss) } } kernel.c /* * kernel.c */ void kmain(void) { const char *str = "my first kernel"; char *vidptr = (char*)0xb8000; //video mem begins here. unsigned int = 0; unsigned int j = 0; /* loops clears screen * there 25 lines each of 80 columns; each element takes 2 bytes */ while(j < 80 * 25 * 2) { /* blank character */ vidptr[j] = ' '; /* attribute-byte - light grey on black screen */ vidptr[j+1] = 0x07; j = j + 2; } j = 0; /* loop writes string video memory */ while(str[j] != '\0') { /
Read more