doctrine2 - Symfony Doctrine ManyToMany add custom join field -

-

i have 2 entites : cart , item, relation configured manytomany because cart can have multiple items, , items can in multiple carts.

so have link table item_cart item_id , cart_id.

how can work quantity ? example if need add 800 items id = 2 cart id = 5 ?

is possible add field quantity in link table ?

thanks help.

you can making relationship entity. entity called cartitem or cartitemlink.

the association changes manytomany between cart , item 2 associations manytoone , onetomany:

cart - manytoone - cartitem - onetomany - item

now can add additional fields cartitem, $quantity field mentioned in question.

so this:

the cartitem:

class cartitem {      /** many-to-one bidirectional, owning side      * @var cart      * @orm\manytoone(targetentity="application\entity\cart", inversedby="cartitems")      * @orm\joincolumn(name="cart_id", referencedcolumnname="id")      */     private $cart;      /** many-to-one bidirectional, owning side      * @var item      * @orm\manytoone(targetentity="application\entity\item", inversedby="cartitems")      * @orm\joincolumn(name="item_id", referencedcolumnname="id")      */     private $item;      /**      * @var int      * @orm\column(type="integer", nullable=false)      */     private $quantity;      //.. setters + getters }

the cart:

class cart {      /**      * @var integer      * @orm\id      * @orm\column(type="integer", nullable=false)      * @orm\generatedvalue(strategy="auto")      */     private $id;      /** one-to-many bidirectional, inverse side      * @var arraycollection      * @orm\onetomany(targetentity="application\entity\cartitem", mappedby="cart")      */     private $cartitems;      //.. setters + getters }

the item:

class item {      /**      * @var integer      * @orm\id      * @orm\column(type="integer", nullable=false)      * @orm\generatedvalue(strategy="auto")      */     private $id;      /** one-to-many bidirectional, inverse side      * @var arraycollection      * @orm\onetomany(targetentity="application\entity\cartitem", mappedby="item")      */     private $cartitems;      //.. setters + getters }

i didn't add id cartitem because can have either composite key ($item_id + $cart_id) or natural key , leave you.

don't forget initialize $cartitems arraycollection inside constructor of item , cart.


Comments

Post a Comment

Popular posts from this blog

Capture and play voice with Asterisk ARI -

-
there channel ari demo in wich can control channel state: ring, answer, play silence, play tone or audio-file ( https://github.com/asterisk/ari-examples/tree/master/channel-state , https://wiki.asterisk.org/wiki/display/ast/ari+and+channels%3a+manipulating+channel+state ) possible receive chunks (parts, buffers, etc.) of call voice (which created remote subscriber) or write chunks of voice, example array of bytes (not file) in audio format (alaw, ulow etc). you can use asterisk eagi interface voice data. other option use record or mixmonitor app record channel(channel have put stasis allow dialplan control ari) "write chunks of voice" can done application playback also can create own application using c/c++, compile asterisk , result want. no, can't redirect voice directly using ari.
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

magic numbers - Java's checkstyle, MagicNumberCheck -

-
i using checkstyle reportings source-code. question magicnumbercheck . i using date/(org.joda.)datetime in source code this: datetime datetime = new datetime(2013, 2, 27, 23, 0): datetime.plushours(57); is there way suppress magicnumbercheck notifications if magic number within date or datetime? you can use suppressioncommentfilter check this. configure properties values (in checkstyle configuration file) <module name="suppressioncommentfilter"> <property name="offcommentformat" value="check\:off\: ([\w\|]+)"/> <property name="oncommentformat" value="check\:on\: ([\w\|]+)"/> <property name="checkformat" value="$1"/> </module> now required lines, can like //check:off: magicnumber datetime datetime = new datetime(2013, 2, 27, 23, 0): datetime.plushours(57); //check:on: magicnumber this suppress magicnumber checks , rest checks work here. you can su...
Read more