Price List Extension

Hi guys! How things?

I want to extend Price Lists in order to change the ownership of thus.

The goal is about that an user of a Business Unit could view and manage Price Lists owned by his BU, and restrict viewing and editing Price Lists of others Business Units.

In addition I want to be able to create ACLs through Roles, to do this dinamically.

Could you please give some orientation about this?

Thanks in advance.

H4

Topic

[fer_palaciosParticipant]

Hi guys!

I was trying to extend Price list so that they can manage the business unit, I tried different types of relationships, like being many to one, many to many etc.
But I only manage to generate the necessary tables and fields, but I can not show the owner of a price list in the UI.
Could anyone help me please

Thanks in advance.

[fer_palaciosParticipant]

I share the code of different types of approach

[fer_palaciosParticipant]

PHP

ENTITY /** * PriceList * * @ORM\Table(name="oro_price_list") * @ORM\Entity * @Config */ class PriceList extends ExtendPriceList { /** * @var integer * * @ORM\Id * @ORM\Column(type="integer") * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; protected $owner; /** * @return int */ public function getId() { return $this->id; } /** * @return Owner */ public function getOwner() { return $this->owner; } /** * @param Owner $owner * * @return $this */ public function setOwner(Owner $owner = null) { $this->owner = $owner; return $this; } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

ENTITY   /** * PriceList * * @ORM\Table(name="oro_price_list") * @ORM\Entity * @Config */ class PriceList extends ExtendPriceList {     /**      * @var integer      *      * @ORM\Id      * @ORM\Column(type="integer")      * @ORM\GeneratedValue(strategy="AUTO")      */     protected $id;       protected $owner;       /**      * @return int      */     public function getId()     {         return $this->id;     }       /**      * @return Owner      */     public function getOwner()     {         return $this->owner;     }       /**      * @param Owner $owner      *      * @return $this      */     public function setOwner(Owner $owner = null)     {         $this->owner = $owner;           return $this;     } }

[fer_palaciosParticipant]

PHP

Migrations -> Extension (PriceListExtension.php) use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\EntityExtendBundle\Migration\OroOptions; use Oro\Bundle\EntityExtendBundle\Tools\ExtendHelper; /* * @Configurable( * defaultValues={ * "entity"={"label"="User", "plural_label"="Users"}, * "ownership"={ * "owner_type"="BUSINESS_UNIT", * "owner_field_name"="owner", * "owner_column_name"="business_unit_owner_id" * } * } * ) */ class PriceListExtension implements ExtendExtensionAwareInterface { const PRICE_LIST_TABLE_NAME = 'oro_price_list'; /** @var ExtendExtension */ protected $extendExtension; /** * {@inheritdoc} */ public function setExtendExtension(ExtendExtension $extendExtension) { $this->extendExtension = $extendExtension; } /** * Adds the association between the target table and the note table * * @param Schema $schema * @param string $targetTableName Target entity table name * @param string $targetColumnName A column name is used to show related entity */ public function addPriceListAssociation( Schema $schema, $targetTableName, $targetColumnName = null ) { $pricelist = $schema->getTable(self::PRICE_LIST_TABLE_NAME); $targetTable = $schema->getTable($targetTableName); if (empty($targetColumnName)) { $primaryKeyColumns = $targetTable->getPrimaryKeyColumns(); $targetColumnName = array_shift($primaryKeyColumns); } $options = new OroOptions(); $options->set('pricelist', 'enabled', true); $targetTable->addOption(OroOptions::KEY, $options); $associationName = ExtendHelper::buildAssociationName( $this->extendExtension->getEntityClassByTableName($targetTableName) ); $this->extendExtension->addManyToOneRelation( $schema, $pricelist, $associationName, $targetTable, $targetColumnName ); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72

Migrations -> Extension (PriceListExtension.php)     use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\EntityExtendBundle\Migration\OroOptions; use Oro\Bundle\EntityExtendBundle\Tools\ExtendHelper; /* * @Configurable( *  defaultValues={ *      "entity"={"label"="User", "plural_label"="Users"}, *      "ownership"={ *          "owner_type"="BUSINESS_UNIT", *          "owner_field_name"="owner", *          "owner_column_name"="business_unit_owner_id" *      } *  } * ) */ class PriceListExtension implements ExtendExtensionAwareInterface {     const PRICE_LIST_TABLE_NAME = 'oro_price_list';       /** @var ExtendExtension */     protected $extendExtension;       /**      * {@inheritdoc}      */     public function setExtendExtension(ExtendExtension $extendExtension)     {         $this->extendExtension = $extendExtension;     }       /**      * Adds the association between the target table and the note table      *      * @param Schema $schema      * @param string $targetTableName  Target entity table name      * @param string $targetColumnName A column name is used to show related entity      */     public function addPriceListAssociation(          Schema $schema,          $targetTableName,          $targetColumnName = null     ) {         $pricelist   = $schema->getTable(self::PRICE_LIST_TABLE_NAME);         $targetTable = $schema->getTable($targetTableName);           if (empty($targetColumnName)) {             $primaryKeyColumns = $targetTable->getPrimaryKeyColumns();             $targetColumnName  = array_shift($primaryKeyColumns);         }           $options = new OroOptions();         $options->set('pricelist', 'enabled', true);         $targetTable->addOption(OroOptions::KEY, $options);           $associationName = ExtendHelper::buildAssociationName(             $this->extendExtension->getEntityClassByTableName($targetTableName)         );           $this->extendExtension->addManyToOneRelation(             $schema,             $pricelist,             $associationName,             $targetTable,             $targetColumnName         );     } }

[fer_palaciosParticipant]

PHP

Migrations -> Schema -> v1_0 use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope; class ZymoPriceListBundle implements Migration, ExtendExtensionAwareInterface { protected $extendExtension; public function setExtendExtension(ExtendExtension $extendExtension) { $this->extendExtension = $extendExtension; } public function up(Schema $schema, QueryBag $queries) { $table = $schema->getTable('oro_price_list'); $this->extendExtension->addManyToOneRelation( $schema, $table, 'id', 'oro_business_unit', 'owner', [ 'extend' => ['owner' => ExtendScope::OWNER_CUSTOM] ] ); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

Migrations -> Schema -> v1_0   use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope;   class ZymoPriceListBundle implements Migration, ExtendExtensionAwareInterface {     protected $extendExtension;       public function setExtendExtension(ExtendExtension $extendExtension)     {         $this->extendExtension = $extendExtension;     }       public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->getTable('oro_price_list');         $this->extendExtension->addManyToOneRelation(             $schema,             $table,             'id',             'oro_business_unit',             'owner',             [                 'extend' => ['owner' => ExtendScope::OWNER_CUSTOM]             ]         );     } }

[fer_palaciosParticipant]

PHP

PriceListBundle -> Model class ExtendPriceList { /** * Constructor * * The real implementation of this method is auto generated. * * IMPORTANT: If the derived class has own constructor it must call parent constructor. */ public function __construct() { } public function supportTarget($targetClass) { return false; } public function getTarget() { return null; } public function setTarget($target) { return $this; } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

PriceListBundle -> Model   class ExtendPriceList {     /**      * Constructor      *      * The real implementation of this method is auto generated.      *      * IMPORTANT: If the derived class has own constructor it must call parent constructor.      */     public function __construct()     {     }           public function supportTarget($targetClass)     {         return false;     }       public function getTarget()     {         return null;     }       public function setTarget($target)     {         return $this;     }     }

[fer_palaciosParticipant]

YAML

Entity_config.yml entity_config: pricelist: entity: items: # indicates whether the entity can have notes or not enabled: # boolean options: require_schema_update: true priority: 250 default_value: false form: type: oro_entity_extend_association_choice options: block: associations required: true label: zymo.pricelist.enabled association_class: 'ZymoPriceListBundle:PriceList' # this attribute can be used to prohibit changing the note association state (no matter whether # it is enabled or not) for the entity # if TRUE than the current state cannot be changed immutable: # boolean options: auditable: false

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

Entity_config.yml   entity_config:     pricelist:         entity:             items:                 # indicates whether the entity can have notes or not                 enabled: # boolean                     options:                         require_schema_update: true                         priority:           250                         default_value:      false                     form:                         type:               oro_entity_extend_association_choice                         options:                             block:          associations                             required:       true                             label:          zymo.pricelist.enabled                             association_class: 'ZymoPriceListBundle:PriceList'                   # this attribute can be used to prohibit changing the note association state (no matter whether                 # it is enabled or not) for the entity                 # if TRUE than the current state cannot be changed                 immutable: # boolean                     options:                         auditable:          false

[fer_palaciosParticipant]

PHP

PriceListEntityConfigDumperExtension.php class PriceListEntityConfigDumperExtension extends AssociationEntityConfigDumperExtension { /** * {@inheritdoc} */ protected function getAssociationEntityClass() { return PriceList::ENTITY_NAME; } /** * {@inheritdoc} */ protected function getAssociationScope() { return 'pricelist'; } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

PriceListEntityConfigDumperExtension.php   class PriceListEntityConfigDumperExtension extends AssociationEntityConfigDumperExtension {     /**      * {@inheritdoc}      */     protected function getAssociationEntityClass()     {         return PriceList::ENTITY_NAME;     }       /**      * {@inheritdoc}      */     protected function getAssociationScope()     {         return 'pricelist';     } }

[fer_palaciosParticipant]

PHP

PriceListEntityGeneratorExtension.php class PriceListEntityGeneratorExtension extends AbstractAssociationEntityGeneratorExtension { /** * {@inheritdoc} */ public function supports(array $schema) { return $schema['class'] === PriceList::ENTITY_NAME && parent::supports($schema); } }

1 2 3 4 5 6 7 8 9 10 11 12

PriceListEntityGeneratorExtension.php   class PriceListEntityGeneratorExtension extends AbstractAssociationEntityGeneratorExtension {     /**      * {@inheritdoc}      */     public function supports(array $schema)     {         return $schema['class'] === PriceList::ENTITY_NAME && parent::supports($schema);     } }

[fer_palaciosParticipant]

Second approach.

[fer_palaciosParticipant]

PHP

PriceListBundle -> Entity /** * PriceList * * @ORM\Table(name="oro_price_list") * @ORM\Entity * @Config */ class PriceList extends ExtendPriceList { /** * @var integer * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /** * @var integer * * @ORM\Column(name="owner", type="integer") */ private $owner; /** * @var integer * * @ORM\Column(name="organization", type="integer") */ private $organization; /** * Get id * * @return integer */ public function getId() { return $this->id; } /** * Set owner * * @param integer $owner * * @return PriceList */ public function setOwner($owner) { $this->owner = $owner; return $this; } /** * Get owner * * @return integer */ public function getOwner() { return $this->owner; } /** * Set organization * * @param integer $organization * * @return PriceList */ public function setOrganization($organization) { $this->organization = $organization; return $this; } /** * Get organization * * @return integer */ public function getOrganization() { return $this->organization; } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93

PriceListBundle -> Entity   /** * PriceList * * @ORM\Table(name="oro_price_list") * @ORM\Entity * @Config */ class PriceList extends ExtendPriceList { /** * @var integer * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /** * @var integer * * @ORM\Column(name="owner", type="integer") */ private $owner; /** * @var integer * * @ORM\Column(name="organization", type="integer") */ private $organization; /** * Get id * * @return integer */ public function getId() { return $this->id; } /** * Set owner * * @param integer $owner * * @return PriceList */ public function setOwner($owner) { $this->owner = $owner; return $this; } /** * Get owner * * @return integer */ public function getOwner() { return $this->owner; } /** * Set organization * * @param integer $organization * * @return PriceList */ public function setOrganization($organization) { $this->organization = $organization; return $this; } /** * Get organization * * @return integer */ public function getOrganization() { return $this->organization; } }

[fer_palaciosParticipant]

PHP

Migrations -> Extension PriceListExtension.php /* * @Configurable( * defaultValues={ * "entity"={"label"="User", "plural_label"="Users"}, * "ownership"={ * "owner_type"="BUSINESS_UNIT", * "owner_field_name"="owner", * "owner_column_name"="business_unit_owner_id" * } * } * ) */ class PriceListExtension implements ExtendExtensionAwareInterface { const PRICE_LIST_TABLE_NAME = 'oro_price_list'; /** @var ExtendExtension */ protected $extendExtension; /** * {@inheritdoc} */ public function setExtendExtension(ExtendExtension $extendExtension) { $this->extendExtension = $extendExtension; } /** * Adds the association between the target table and the note table * * @param Schema $schema * @param string $targetTableName Target entity table name * @param string $targetColumnName A column name is used to show related entity */ public function addPriceListAssociation( Schema $schema, $targetTableName, $targetColumnName = null ) { $pricelist = $schema->getTable(self::PRICE_LIST_TABLE_NAME); $targetTable = $schema->getTable($targetTableName); if (empty($targetColumnName)) { $primaryKeyColumns = $targetTable->getPrimaryKeyColumns(); $targetColumnName = array_shift($primaryKeyColumns); } $options = new OroOptions(); $options->set('pricelist', 'enabled', true); $targetTable->addOption(OroOptions::KEY, $options); $associationName = ExtendHelper::buildAssociationName( $this->extendExtension->getEntityClassByTableName($targetTableName) ); $this->extendExtension->addManyToOneRelation( $schema, $pricelist, $associationName, $targetTable, $targetColumnName ); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68

Migrations -> Extension   PriceListExtension.php   /* * @Configurable( *  defaultValues={ *      "entity"={"label"="User", "plural_label"="Users"}, *      "ownership"={ *          "owner_type"="BUSINESS_UNIT", *          "owner_field_name"="owner", *          "owner_column_name"="business_unit_owner_id" *      } *  } * ) */ class PriceListExtension implements ExtendExtensionAwareInterface {     const PRICE_LIST_TABLE_NAME = 'oro_price_list';       /** @var ExtendExtension */     protected $extendExtension;       /**      * {@inheritdoc}      */     public function setExtendExtension(ExtendExtension $extendExtension)     {         $this->extendExtension = $extendExtension;     }       /**      * Adds the association between the target table and the note table      *      * @param Schema $schema      * @param string $targetTableName  Target entity table name      * @param string $targetColumnName A column name is used to show related entity      */     public function addPriceListAssociation(          Schema $schema,          $targetTableName,          $targetColumnName = null     ) {         $pricelist   = $schema->getTable(self::PRICE_LIST_TABLE_NAME);         $targetTable = $schema->getTable($targetTableName);           if (empty($targetColumnName)) {             $primaryKeyColumns = $targetTable->getPrimaryKeyColumns();             $targetColumnName  = array_shift($primaryKeyColumns);         }           $options = new OroOptions();         $options->set('pricelist', 'enabled', true);         $targetTable->addOption(OroOptions::KEY, $options);           $associationName = ExtendHelper::buildAssociationName(             $this->extendExtension->getEntityClassByTableName($targetTableName)         );           $this->extendExtension->addManyToOneRelation(             $schema,             $pricelist,             $associationName,             $targetTable,             $targetColumnName         );     } }

[fer_palaciosParticipant]

PHP

Migrations -> Schema -> v1_0 class ZymoPriceListBundle implements Migration, ExtendExtensionAwareInterface { protected $extendExtension; public function setExtendExtension(ExtendExtension $extendExtension) { $this->extendExtension = $extendExtension; } public function up(Schema $schema, QueryBag $queries) { $table = $schema->getTable('oro_price_list'); $this->extendExtension->addManyToOneRelation( $schema, $table, 'id', 'oro_business_unit', 'owner', [ 'extend' => ['owner' => ExtendScope::OWNER_CUSTOM] ] ); $table = $schema->getTable('oro_price_list'); $this->extendExtension->addManyToOneRelation( $schema, $table, 'id', 'oro_organization', 'organization', [ 'extend' => ['organization' => ExtendScope::OWNER_CUSTOM] ] ); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

Migrations -> Schema -> v1_0 class ZymoPriceListBundle implements Migration, ExtendExtensionAwareInterface {     protected $extendExtension;       public function setExtendExtension(ExtendExtension $extendExtension)     {         $this->extendExtension = $extendExtension;     }       public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->getTable('oro_price_list');         $this->extendExtension->addManyToOneRelation(             $schema,             $table,             'id',             'oro_business_unit',             'owner',             [                 'extend' => ['owner' => ExtendScope::OWNER_CUSTOM]             ]         );                  $table = $schema->getTable('oro_price_list');         $this->extendExtension->addManyToOneRelation(          $schema,          $table,          'id',          'oro_organization',          'organization',          [          'extend' => ['organization' => ExtendScope::OWNER_CUSTOM]          ]         );     } }

[fer_palaciosParticipant]

PHP

PriceListBundle - >Model class ExtendPriceList { /** * Constructor * * The real implementation of this method is auto generated. * * IMPORTANT: If the derived class has own constructor it must call parent constructor. */ public function __construct() { } public function supportTarget($targetClass) { return false; } public function getTarget() { return null; } public function setTarget($target) { return $this; } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

PriceListBundle - >Model class ExtendPriceList {     /**      * Constructor      *      * The real implementation of this method is auto generated.      *      * IMPORTANT: If the derived class has own constructor it must call parent constructor.      */     public function __construct()     {     }           public function supportTarget($targetClass)     {         return false;     }       public function getTarget()     {         return null;     }       public function setTarget($target)     {         return $this;     }     }

[fer_palaciosParticipant]

Third approach.

[Author]

Replies