在 symfony2 中使用 sonata-bundle,如何更加便捷地管理数据信息?
我目前有3张表goods
、category
and brand
,在sonata后台中,我希望可以把类别名称和品牌名称全部显示在货品列表,下图有详细的信息:
从上图可以看出,iphone6plus的类别是mobile,这里我在yml文件中定义了many-to-one的关系,这里显示是正确的,但是brand.name很明显错了,iphone6plus的品牌应该是apple,这里我有疑问,我我在 goods.yml 文件中定义了两次many-to-one关系,第二次定义的是goods
与brand
表,并没有正确显示。
我想更便捷地管理货品信息,在同一页面,浏览商品类别和品牌,在编辑页面同理,我应该如何实现呢?下面是我的代码块:
brand.orm.yml
Application\Sonata\MallBundle\Entity\Brand:
type: entity
table: brand
...
oneToMany:
goods:
targetEntity: Goods
mappedBy: brand
lifecycleCallbacks: { }
goods.orm.yml
Application\Sonata\MallBundle\Entity\Goods:
type: entity
table: goods
repositoryClass: Application\Sonata\MallBundle\Repository\GoodsRepository
...
manyToOne:
category:
targetEntity: Category
inverseBy: goods
joinColumn:
name: category_id
referencedColumnName: id
manyToOne:
brand:
targetEntity: Brand
inverseBy: goods
joinColumn:
name: brand_id
referencedColumnName: id
lifecycleCallbacks: { }
category.orm.yml
Application\Sonata\MallBundle\Entity\Category:
type: entity
table: category
repositoryClass: Application\Sonata\MallBundle\Repository\CategoryRepository
...
oneToMany:
goods:
targetEntity: Goods
mappedBy: category
lifecycleCallbacks: { }
您的建议,对我来说是莫大的帮助。
回复内容:
我目前有3张表goods
、category
and brand
,在sonata后台中,我希望可以把类别名称和品牌名称全部显示在货品列表,下图有详细的信息:
从上图可以看出,iphone6plus的类别是mobile,这里我在yml文件中定义了many-to-one的关系,这里显示是正确的,但是brand.name很明显错了,iphone6plus的品牌应该是apple,这里我有疑问,我我在 goods.yml 文件中定义了两次many-to-one关系,第二次定义的是goods
与brand
表,并没有正确显示。
我想更便捷地管理货品信息,在同一页面,浏览商品类别和品牌,在编辑页面同理,我应该如何实现呢?下面是我的代码块:
brand.orm.yml
Application\Sonata\MallBundle\Entity\Brand:
type: entity
table: brand
...
oneToMany:
goods:
targetEntity: Goods
mappedBy: brand
lifecycleCallbacks: { }
goods.orm.yml
Application\Sonata\MallBundle\Entity\Goods:
type: entity
table: goods
repositoryClass: Application\Sonata\MallBundle\Repository\GoodsRepository
...
manyToOne:
category:
targetEntity: Category
inverseBy: goods
joinColumn:
name: category_id
referencedColumnName: id
manyToOne:
brand:
targetEntity: Brand
inverseBy: goods
joinColumn:
name: brand_id
referencedColumnName: id
lifecycleCallbacks: { }
category.orm.yml
Application\Sonata\MallBundle\Entity\Category:
type: entity
table: category
repositoryClass: Application\Sonata\MallBundle\Repository\CategoryRepository
...
oneToMany:
goods:
targetEntity: Goods
mappedBy: category
lifecycleCallbacks: { }
您的建议,对我来说是莫大的帮助。
上一篇: php生成一个安全随机的密码程序
下一篇: 用PHP通过SMTP发送邮件