我目前有3張表goods、category and brand,在sonata後台中,我希望可以把類別名稱和品牌名稱全部顯示在貨品列表,有詳細的資訊:
從可以看出,iphone6plus的類別是mobile,這裡我在yml檔案中定義了many-to-one的關係,這裡顯示是正確的,但是brand.name很明顯錯了,iphone6plus的品牌應該是apple,這裡我有疑問,我我在 goods.yml 檔案中定義了兩次many-to-one關係,第二次定義的是goods與brand表,並沒有正確顯示。
我想更便捷地管理貨品資訊,在同一頁面,瀏覽商品類別和品牌,在編輯頁面同理,我應該如何?呢?下面是My Code塊:
brand.orm.yml
Application\Sonata\MallBundle\Entity\Brand: type: entity table: brand ...oneToMany: goods: targetEntity: Goods mappedBy: brandlifecycleCallbacks: { }
goods.orm.yml
Application\Sonata\MallBundle\Entity\Goods:type: entitytable: goodsrepositoryClass: Application\Sonata\MallBundle\Repository\GoodsRepository...manyToOne: category: targetEntity: Category inverseBy: goods joinColumn: name: category_id referencedColumnName: idmanyToOne: brand: targetEntity: Brand inverseBy: goods joinColumn: name: brand_id referencedColumnName: idlifecycleCallbacks: { }
category.orm.yml
Application\Sonata\MallBundle\Entity\Category:type: entitytable: categoryrepositoryClass: Application\Sonata\MallBundle\Repository\CategoryRepository...oneToMany: goods: targetEntity: Goods mappedBy: categorylifecycleCallbacks: { }
您的建議,對我來說是莫大的協助。
回複內容:
我目前有3張表goods、category and brand,在sonata後台中,我希望可以把類別名稱和品牌名稱全部顯示在貨品列表,有詳細的資訊:
從可以看出,iphone6plus的類別是mobile,這裡我在yml檔案中定義了many-to-one的關係,這裡顯示是正確的,但是brand.name很明顯錯了,iphone6plus的品牌應該是apple,這裡我有疑問,我我在 goods.yml 檔案中定義了兩次many-to-one關係,第二次定義的是goods與brand表,並沒有正確顯示。
我想更便捷地管理貨品資訊,在同一頁面,瀏覽商品類別和品牌,在編輯頁面同理,我應該如何?呢?下面是My Code塊:
brand.orm.yml
Application\Sonata\MallBundle\Entity\Brand: type: entity table: brand ...oneToMany: goods: targetEntity: Goods mappedBy: brandlifecycleCallbacks: { }
goods.orm.yml
Application\Sonata\MallBundle\Entity\Goods:type: entitytable: goodsrepositoryClass: Application\Sonata\MallBundle\Repository\GoodsRepository...manyToOne: category: targetEntity: Category inverseBy: goods joinColumn: name: category_id referencedColumnName: idmanyToOne: brand: targetEntity: Brand inverseBy: goods joinColumn: name: brand_id referencedColumnName: idlifecycleCallbacks: { }
category.orm.yml
Application\Sonata\MallBundle\Entity\Category:type: entitytable: categoryrepositoryClass: Application\Sonata\MallBundle\Repository\CategoryRepository...oneToMany: goods: targetEntity: Goods mappedBy: categorylifecycleCallbacks: { }
您的建議,對我來說是莫大的協助。