New column name

I add an additional column in lead entity in migration script as in document

PHP

I add an additional column in lead entity in migration script as in document PHP use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; class AddCollectorToLead implements Migration { public function up(Schema $schema, QueryBag $queries) { $table = $schema->getTable('orocrm_sales_lead'); $table->addColumn( 'collector', 'boolean', [ 'oro_options' => [ 'extend' => ['is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => 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

I add an additional column in lead entity in migration script as in document   PHP   use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag;   class AddCollectorToLead implements Migration {     public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->getTable('orocrm_sales_lead');         $table->addColumn(             'collector',             'boolean',             [                 'oro_options' => [                     'extend'    => ['is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM],                     'datagrid'  => ['is_visible' => false],                 ],             ]         );     } }

But on the view and update page , the column name is shown as Oro.Sales.Lead.Collector.Label, not collector. Is the any configuration I forgot to do?

Topic

[mmiasnikovParticipant]

Hello, @jaime.du!

The labels for extended entity’s fields are translatable strings with predefined translation keys (as you can see in your example). So, you have to create file Resources/translations/messages.en.yml in your bundle and put translation for oro.sales.lead.collector.label key to it:

YAML

oro: sales: lead: collector: label: Collector

1 2 3 4 5

oro:     sales:         lead:             collector:                 label: Collector

and after that perform the console command

Shell

php app/console oro:translation:load --rebuild-cache --timeout=900

1	php app/console oro:translation:load --rebuild-cache --timeout=900

Therefore you’ll get English translation for oro.sales.lead.collector.label string and an ability to add other languages translations for this string and modify them using System > Localization > Translations UI.

[jaime.duParticipant]

Hi mmiasnikov
Thank you very much for your reply. It’s working. Sorry for asking another question. How do I change the field type of the form on update page. Now it’s set as a selection by default. I want to make it a checkbox. Thank you.

[Yurii MuratovParticipant]

Hello, @jaime.du!

You can change the form type for your field with the form section in oro_options array in your migration. Here is an example of your migration with checkbox form type for your field:

PHP

class AddCollectorToLead implements Migration { public function up(Schema $schema, QueryBag $queries) { $table = $schema->getTable('orocrm_sales_lead'); $table->addColumn( 'collector', 'boolean', [ 'oro_options' => [ 'extend' => ['is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => false], 'form' => [ 'is_enabled' => true, 'form_type' => 'checkbox', 'form_options' => [ 'tooltip' => 'some tooltip' ] ], ], ] ); } }

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

class AddCollectorToLead implements Migration {     public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->getTable('orocrm_sales_lead');         $table->addColumn(             'collector',             'boolean',             [                 'oro_options' => [                     'extend'    => ['is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM],                     'datagrid'  => ['is_visible' => false],                     'form' => [                         'is_enabled' => true,                         'form_type' => 'checkbox',                         'form_options' => [                             'tooltip' => 'some tooltip'                         ]                     ],                 ],             ]         );     } }

[jaime.duParticipant]

Hello @Yurii Muratov

Thank you and @mmiasnikov for your help. You guys saved my day, actually two days. By the way, it there any documentation that has illumination about similar deep customization. I have read through the developer guide, oro book and oro cook book but didn’t find enough information or maybe I’m just too careless and missed it. Thank you.

[Yurii MuratovParticipant]

Hello, @jaime.du.

I’m afraid we have no such documentation for now.

[jaime.duParticipant]

Thanks

[Author]

Replies