change views for custom entities created from UI

Hello,

Thanks for a great CRM Application.

I am facing some difficulties where I have to change the way the detail views look for custom entities created from the UI. Now for the bundles created within the application I can see that there are views folder under Resources/config folder. But for the custom entities created from the UI I don’t see any kind of folder structure in the application. All the files are generated within the Cache folder. The class file is also auto generated within the cache folder based on the information in the database tables.

All the fields that I created from the UI are coming in a single column format. I need to change it to two column format or some other format. How can I do it for these custom entities created from the UI?

I also need to create some complex reports for these custom entities. How can I create them? In which folder should I keep them? The documentation says that I have to create a Datagrid.yml style file in my bundle. But I don’t have a bundle. The custom entity has been created from the UI.

Please help.

Thanks.
Madhur.

Topic

[Artem LiubeznyiSpectator]

Hi Madhur,

To create complex behavior for a custom entity you have to create your own bundle, then move entity class files from Cache, and finally create the datagrid and the custom views & forms you want.

Please refer to the Oro Cookbook for further details.

[MadhurParticipant]

Hi Artem,

Thanks for the reply.

I have started working on the same. For a person coming from a Microsoft background it becomes a little difficult to understand at first go, but I am getting the hang of it.

Thanks again.

Madhur

[MadhurParticipant]

Hi Artem,

I created a bundle and the entity as given in the documentation.

The bundle works perfectly for Admin user. When a user with Sales Manager role logs in, he is not able to view the datagrid. My custom entity ownership is Organization. I have given all the permissions for the custom entity to the Sales Manager role. Inspite of that the user is not able to view the records.

The logs show one thing:
[2016-01-07 17:59:18] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
[2016-01-07 17:59:18] security.DEBUG: ACL found, no ACE applicable. Voting to deny access. [] []

When I check in the profiler, the sql statement that is executed has one “AND (1 = 0)” condition added to it. Now I dont know from where this “And” condition is being appended.

Let me show you the code:

PHP

class PartIndexController extends Controller { /** * @Route("/", name="partindex.partindex_index") * @Template("PGAPartIndexBundle:PartIndex:index.html.twig") * @Acl( * id="partindex.partindex_index", * type="entity", * class="PGAPartIndexBundle:PartIndex", * permission="VIEW" * ) */ public function indexAction() { return array('gridName' => 'partindex-grid'); }

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

class PartIndexController extends Controller {      /**      * @Route("/", name="partindex.partindex_index")      * @Template("PGAPartIndexBundle:PartIndex:index.html.twig")      * @Acl(      *     id="partindex.partindex_index",      *     type="entity",      *     class="PGAPartIndexBundle:PartIndex",      *     permission="VIEW"      * )      */     public function indexAction()     {         return array('gridName' => 'partindex-grid');     }

and the datagrid.yml is

YAML

datagrid: partindex-grid: source: acl_resource: partindex.partindex_index type: orm query: select: - v.id - v.partindexcode - v.partindexlabel - vo.name from: - { table: PGAPartIndexBundle:PartIndex, alias: v } join: inner: - { join: v.owner, alias:vo } columns: partindexcode: label: Code partindexlabel: label: 'Label' name: label: 'Organization'

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

datagrid:     partindex-grid:         source:             acl_resource: partindex.partindex_index             type: orm             query:                 select:                     - v.id                     - v.partindexcode                     - v.partindexlabel                     - vo.name                 from:                     - { table: PGAPartIndexBundle:PartIndex, alias: v }                 join:                     inner:                         - { join: v.owner, alias:vo }         columns:             partindexcode:                 label: Code             partindexlabel:                 label: 'Label'             name:                 label: 'Organization'

So what is wrong? What is ACE?

The Sales Manager user is able to view the detail view, able to create and also delete the record. But the datagrid is giving problems.

Thanks and Regards,
Madhur

[MadhurParticipant]

Hi,

Please, any help regarding this?

Thanks.

Regards,
Madhur

[Yurii MuratovParticipant]

Hi, @mhalapeti.

Your grid is empty because your user have not access to Organization entity.

You can change inner join to left. In this case, for this user you should see the records and empty ‘Organization’ column.

So, your grid definition will be:

YAML

datagrid: partindex-grid: source: acl_resource: partindex.partindex_index type: orm query: select: - v.id - v.partindexcode - v.partindexlabel - vo.name from: - { table: PGAPartIndexBundle:PartIndex, alias: v } join: left: - { join: v.owner, alias:vo } columns: partindexcode: label: Code partindexlabel: label: 'Label' name: label: 'Organization'

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

datagrid:     partindex-grid:         source:             acl_resource: partindex.partindex_index             type: orm             query:                 select:                     - v.id                     - v.partindexcode                     - v.partindexlabel                     - vo.name                 from:                     - { table: PGAPartIndexBundle:PartIndex, alias: v }                 join:                     left:                         - { join: v.owner, alias:vo }         columns:             partindexcode:                 label: Code             partindexlabel:                 label: 'Label'             name:                 label: 'Organization'

[MadhurParticipant]

Thanks Yurii,

It works!!

Thanks and regards,
Madhur

[Author]

Replies