alter properties in custom entity field

Hi,
I added a field with migration to OroCalendarBundle, my problem is that initially it is not a required field but now this decision causes some problems and I would like to make this field mandatory. the problem is that it’s an enum_field (foreign keys). Can I change the field’s property in a migrationBundle and what is the syntax

Thank’s for your help

Topic

[mmiasnikovParticipant]

Hi, Fred33.

Please, provide your migration code (where you added the field in OroCalendarBundle, as you said). It lets understand what, actually, entity did you mean, etc.

Thank you.

[fred33Participant]

here,

PHP

<?php namespace CL\Bundle\ExtendCalendarBundle\Migrations\Schema\v1_20; use Doctrine\DBAL\Schema\Schema; use Doctrine\DBAL\Types\Type; use Symfony\Component\DependencyInjection\ContainerAwareInterface; use Symfony\Component\DependencyInjection\ContainerInterface; use Oro\Bundle\EntityBundle\EntityConfig\DatagridScope; use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope; use Oro\Bundle\EntityExtendBundle\Migration\ExtendOptionsManager; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\EntityExtendBundle\Migration\OroOptions; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\OrderedMigrationInterface; use Oro\Bundle\MigrationBundle\Migration\ParametrizedSqlMigrationQuery; use Oro\Bundle\MigrationBundle\Migration\QueryBag; class AddTypeEvt implements Migration, ExtendExtensionAwareInterface, ContainerAwareInterface, OrderedMigrationInterface { /** @var ContainerInterface */ protected $container; /** @var ExtendExtension */ protected $extendExtension; /** * {@inheritdoc} */ public function getOrder() { return 1; } /** * @param ExtendExtension $extendExtension */ public function setExtendExtension(ExtendExtension $extendExtension) { $this->extendExtension = $extendExtension; } /** * {@inheritdoc} */ public function setContainer(ContainerInterface $container = null) { $this->container = $container; } /** * {@inheritdoc} */ public function up(Schema $schema, QueryBag $queries) { /** @var ExtendOptionsManager $extendOptionsManager */ $extendOptionsManager = $this->container->get('oro_entity_extend.migration.options_manager'); $extendOptionsManager->removeColumnOptions('oro_calendar_event', 'typEvt'); $immutableCodes = ['Rdv', 'Catalogue', 'Rapport_de_visite', 'Autre']; self::addTypeEvtField($schema, $this->extendExtension, $immutableCodes); $types = [ 'Rdv' => 'Rdv', 'Catalogue' => 'Catalogue', 'Rapport_de_visite' => 'Rapport de visite', 'Autre' => 'Autre', ]; self::addEnumValuesTypEvt($queries, $types); } /** * @param Schema $schema * @param ExtendExtension $extendExtension * @param array $immutableCodes */ public static function addTypeEvtField(Schema $schema, ExtendExtension $extendExtension, array $immutableCodes) { $enumtable = $extendExtension->addEnumField( $schema, 'oro_calendar_event', 'typEvt', 'typEvt', false, false, [ 'extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => DatagridScope::IS_VISIBLE_TRUE], 'dataaudit' => ['auditable' => true] ] ); $options = new OroOptions(); $options->set( 'enum', 'immutable_code', $immutableCodes ); $enumtable->addOption(OroOptions::KEY, $options); } public static function addEnumValuesTypEvt(QueryBag $queries, array $types, $defaultValue = 'Magasin') { $query = 'INSERT INTO oro_enum_typEvt (id, name, priority, is_default) VALUES (:id, :name, :priority, :is_default)'; $i = 1; foreach ($types as $key => $value){ $dropFieldsQuery = new ParametrizedSqlMigrationQuery(); $dropFieldsQuery->addSql( $query, ['id' => $key, 'name' => $value, 'priority' => $i, 'is_default' => $defaultValue === $key], [ 'id' => Type::STRING, 'name' => Type::STRING, 'priority' => Type::INTEGER, 'is_default' => Type::BOOLEAN ] ); $queries->addQuery($dropFieldsQuery); $i++; } } }

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 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132

<?php   namespace CL\Bundle\ExtendCalendarBundle\Migrations\Schema\v1_20;   use Doctrine\DBAL\Schema\Schema; use Doctrine\DBAL\Types\Type; use Symfony\Component\DependencyInjection\ContainerAwareInterface; use Symfony\Component\DependencyInjection\ContainerInterface; use Oro\Bundle\EntityBundle\EntityConfig\DatagridScope; use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope; use Oro\Bundle\EntityExtendBundle\Migration\ExtendOptionsManager; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\EntityExtendBundle\Migration\OroOptions; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\OrderedMigrationInterface; use Oro\Bundle\MigrationBundle\Migration\ParametrizedSqlMigrationQuery; use Oro\Bundle\MigrationBundle\Migration\QueryBag;   class AddTypeEvt implements     Migration,     ExtendExtensionAwareInterface,     ContainerAwareInterface,     OrderedMigrationInterface {      /** @var ContainerInterface */     protected $container;     /** @var ExtendExtension */     protected $extendExtension;     /**      * {@inheritdoc}      */     public function getOrder()     {         return 1;     }     /**      * @param ExtendExtension $extendExtension      */     public function setExtendExtension(ExtendExtension $extendExtension)     {         $this->extendExtension = $extendExtension;     }     /**      * {@inheritdoc}      */     public function setContainer(ContainerInterface $container = null)     {         $this->container = $container;     }              /**    * {@inheritdoc}    */     public function up(Schema $schema, QueryBag $queries) {                  /** @var ExtendOptionsManager $extendOptionsManager */         $extendOptionsManager = $this->container->get('oro_entity_extend.migration.options_manager');         $extendOptionsManager->removeColumnOptions('oro_calendar_event', 'typEvt');                         $immutableCodes = ['Rdv', 'Catalogue', 'Rapport_de_visite', 'Autre'];                                  self::addTypeEvtField($schema, $this->extendExtension, $immutableCodes);                                  $types = [             'Rdv' => 'Rdv',             'Catalogue' => 'Catalogue',             'Rapport_de_visite' => 'Rapport de visite',             'Autre' => 'Autre',         ];                  self::addEnumValuesTypEvt($queries, $types);                }          /**      * @param Schema $schema      * @param ExtendExtension $extendExtension      * @param array $immutableCodes      */     public static function addTypeEvtField(Schema $schema, ExtendExtension $extendExtension, array $immutableCodes)     {         $enumtable = $extendExtension->addEnumField(                 $schema,                 'oro_calendar_event',                 'typEvt',                 'typEvt',                 false,                 false,                 [                     'extend' => ['owner' => ExtendScope::OWNER_CUSTOM],                     'datagrid' => ['is_visible' => DatagridScope::IS_VISIBLE_TRUE],                     'dataaudit' => ['auditable' => true]                                      ]         );         $options = new OroOptions();         $options->set(                 'enum',                 'immutable_code',                 $immutableCodes         );                  $enumtable->addOption(OroOptions::KEY, $options);     }          public static function addEnumValuesTypEvt(QueryBag $queries, array $types, $defaultValue = 'Magasin')     {         $query = 'INSERT INTO oro_enum_typEvt (id, name, priority, is_default)                   VALUES (:id, :name, :priority, :is_default)';         $i = 1;         foreach ($types as $key => $value){             $dropFieldsQuery = new ParametrizedSqlMigrationQuery();             $dropFieldsQuery->addSql(                     $query,                     ['id' => $key, 'name' => $value, 'priority' => $i, 'is_default' => $defaultValue === $key],                     [                         'id' => Type::STRING,                         'name' => Type::STRING,                         'priority' => Type::INTEGER,                         'is_default' => Type::BOOLEAN                     ]             );             $queries->addQuery($dropFieldsQuery);             $i++;                      }     } }

[fred33Participant]

I think i have found a solution. Add this code

PHP

->add( 'typEvt', 'oro_enum_select', [ 'label' => 'Type Evenement', 'enum_code' => 'typEvt', 'required' => true, 'constraints' => [new Assert\NotNull()] ] )

1 2 3 4 5 6 7 8 9 10

->add(                 'typEvt',                 'oro_enum_select',                 [                     'label' => 'Type Evenement',                     'enum_code' => 'typEvt',                     'required' => true,                     'constraints' => [new Assert\NotNull()]                 ]             )

to function builForm in CalendarEventType.php form. I tested it in the original bundle but how to extend this form

Thanks

[dnahrebeckiModerator]

Hello fred33,
there are couple of ways of how you can extend Form functionality depending on your needs and existing codebase. Please have a look at:

– https://symfony.com/doc/2.8/form/create_form_type_extension.html
– https://symfony.com/doc/2.8/form/create_custom_field_type.html
– https://symfony.com/doc/2.8/form/dynamic_form_modification.html

Regards,
Daniel Nahrebecki

[Author]

Replies