[bosumfliciParticipant]

Hello,

It is a custom datagrid and it is about a custom mass action.
In select i had a NOT IN where clause, which gets an array with many ids to filter the datagrid rows. And when i call the mass action, the url get all the datagrid parameters, and also these ids and i get this error.

I changed my code to get the datagrid rows through a repository method call and skip passing those ids in the url.

Thank you!

[bosumfliciParticipant]

Sorry for late reply.

No that’s not what i meant. I create an attachment relation through migration. Later i need to drop that relation. How can i do that?

[bosumfliciParticipant]

Today i noticed a stranged behavior! When clicking the export -> csv button, sometimes works, sometimes not. No php/js or log errors found.

Any ideea why is this happening?

[bosumfliciParticipant]

My bad here, i was sending a datetime value, instead of a date.

Tnank you!

[bosumfliciParticipant]

Thanks Mike!

Giving id to the controller fixed the problem. What i’ve encountered next is that when i apply a filter to the datagrid, in a workflow step, i get:

Catchable Fatal Error: Argument 1 passed to Doctrine\DBAL\Connection::resolveParams() must be of the type array, null given, called in /var/www/html/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php on line 836 and defined in /var/www/html/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php on line 1524

Outside of the workflow datagrid filters works fine. Any idea what could cause this?

[bosumfliciParticipant]

This is my workflow config:

YAML

workflows: offer: label: 'Create new offer' entity: CB\Bundle\NewAgeBundle\Entity\Offer entity_attribute: offer attributes: offer_name: property_path: offer.name offer_start: property_path: offer.start offer_end: property_path: offer.end offer_campaign: property_path: offer.campaign offer_panel_views: label: 'Panel Views' property_path: offer.panelViews steps: started: label: 'Initiated' order: 10 allowed_transitions: - create - filters filtered: label: 'Panel Views selected' order: 20 allowed_transitions: - filters - close closed: label: 'Finished' order: 30 allowed_transitions: transitions: create: label: 'Create offer' step_to: started is_start: true is_hidden: false is_unavailable_hidden: false acl_resource: cb_newage_offer_create display_type: page frontend_options: icon: 'icon-edit' class: 'btn-primary' page: parent_route: 'cb_newage_offer_index' parent_label: cb.newage.offer.entity_plural_label form_options: attribute_fields: offer_name: form_type: text options: required: true constraints: - NotBlank: ~ offer_start: options: required: true constraints: - NotBlank: ~ offer_end: options: required: true constraints: - NotBlank: ~ offer_campaign: form_type: entity options: required: true class: CB\Bundle\NewAgeBundle\Entity\Campaign constraints: - NotBlank: ~ init_actions: - @create_date: attribute: $offer_start - @create_date: attribute: $offer_end transition_definition: create_definition filters: label: 'Select panel views' step_to: filtered is_unavailable_hidden: false acl_resource: cb_newage_offer_update display_type: page frontend_options: icon: 'icon-filter' class: 'btn-success' page: parent_route: 'cb_newage_offer_index' parent_label: cb.newage.offer.entity_plural_label form_options: attribute_fields: offer_panel_views: form_type: cb_panel_view_multiple_entity options: required: true class: 'CBNewAgeBundle:PanelView' add_acl_resource: 'cb_newage_panel_view_view' selector_window_title: 'cb.newage.offer.form.select_panel_views' selection_route: 'cb_offer_widget_panel_views_info' constraints: - NotBlank: ~ transition_definition: filters_definition close: label: 'Close' step_to: closed is_unavailable_hidden: false frontend_options: icon: 'icon-ok' transition_definition: closed_definition transition_definitions: create_definition: post_actions: - @create_related_entity: # create Offer if it not exist yet conditions: @empty: [$offer.id] parameters: ~ - @redirect: # redirect to Offer view page route: 'cb_newage_offer_view' route_parameters: id: $offer.id workflow: true filters_definition: post_actions: - @tree: - actions: - @call_method: object: $offer method: setPanelViews method_parameters: $offer.panelViews - @redirect: # redirect to Offer view page route: 'cb_newage_offer_view' route_parameters: id: $offer.id closed_definition: ~

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 133 134 135 136 137 138 139 140 141 142 143 144 145 146

workflows:     offer:         label: 'Create new offer'         entity: CB\Bundle\NewAgeBundle\Entity\Offer         entity_attribute: offer           attributes:             offer_name:                 property_path: offer.name             offer_start:                 property_path: offer.start             offer_end:                 property_path: offer.end             offer_campaign:                 property_path: offer.campaign             offer_panel_views:                 label: 'Panel Views'                 property_path: offer.panelViews           steps:             started:                 label: 'Initiated'                 order: 10                 allowed_transitions:                     - create                     - filters               filtered:                 label: 'Panel Views selected'                 order: 20                 allowed_transitions:                     - filters                     - close               closed:                 label: 'Finished'                 order: 30                 allowed_transitions:           transitions:             create:                 label: 'Create offer'                 step_to: started                 is_start: true                 is_hidden: false                 is_unavailable_hidden: false                 acl_resource: cb_newage_offer_create                 display_type: page                 frontend_options:                     icon: 'icon-edit'                     class: 'btn-primary'                     page:                         parent_route: 'cb_newage_offer_index'                         parent_label: cb.newage.offer.entity_plural_label                 form_options:                     attribute_fields:                         offer_name:                             form_type: text                             options:                                 required: true                                 constraints:                                     - NotBlank: ~                         offer_start:                             options:                                 required: true                                 constraints:                                     - NotBlank: ~                         offer_end:                             options:                                 required: true                                 constraints:                                     - NotBlank: ~                         offer_campaign:                             form_type: entity                             options:                                 required: true                                 class: CB\Bundle\NewAgeBundle\Entity\Campaign                                 constraints:                                   - NotBlank: ~                     init_actions:                         - @create_date:                             attribute: $offer_start                         - @create_date:                             attribute: $offer_end                 transition_definition: create_definition               filters:                 label: 'Select panel views'                 step_to: filtered                 is_unavailable_hidden: false                 acl_resource: cb_newage_offer_update                 display_type: page                 frontend_options:                     icon: 'icon-filter'                     class: 'btn-success'                     page:                         parent_route: 'cb_newage_offer_index'                         parent_label: cb.newage.offer.entity_plural_label                 form_options:                     attribute_fields:                         offer_panel_views:                             form_type: cb_panel_view_multiple_entity                             options:                                 required: true                                 class: 'CBNewAgeBundle:PanelView'                                 add_acl_resource: 'cb_newage_panel_view_view'                                 selector_window_title: 'cb.newage.offer.form.select_panel_views'                                 selection_route: 'cb_offer_widget_panel_views_info'                                 constraints:                                     - NotBlank: ~                 transition_definition: filters_definition               close:                 label: 'Close'                 step_to: closed                 is_unavailable_hidden: false                 frontend_options:                     icon: 'icon-ok'                 transition_definition: closed_definition             transition_definitions:             create_definition:                 post_actions:                     - @create_related_entity: # create Offer if it not exist yet                         conditions:                             @empty: [$offer.id]                         parameters: ~                     - @redirect: # redirect to Offer view page                         route: 'cb_newage_offer_view'                         route_parameters:                             id: $offer.id                             workflow: true             filters_definition:                 post_actions:                     - @tree:                         - actions:                             - @call_method:                                 object: $offer                                 method: setPanelViews                                 method_parameters: $offer.panelViews                     - @redirect: # redirect to Offer view page                         route: 'cb_newage_offer_view'                         route_parameters:                             id: $offer.id             closed_definition: ~

This is my type config:

PHP

<?php namespace CB\Bundle\NewAgeBundle\Form\Type; use Symfony\Component\Form\AbstractType; use Symfony\Component\OptionsResolver\OptionsResolverInterface; class PanelViewMultipleEntityType extends AbstractType { /** * {@inheritdoc} */ public function getParent() { return 'oro_multiple_entity'; } /** * {@inheritdoc} */ public function getName() { return 'cb_panel_view_multiple_entity'; } }

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

<?php namespace CB\Bundle\NewAgeBundle\Form\Type;   use Symfony\Component\Form\AbstractType; use Symfony\Component\OptionsResolver\OptionsResolverInterface;   class PanelViewMultipleEntityType extends AbstractType {     /**      * {@inheritdoc}      */     public function getParent()     {         return 'oro_multiple_entity';     }     /**      * {@inheritdoc}      */     public function getName()     {         return 'cb_panel_view_multiple_entity';     } }

First step in workflow is to create a new entity (offer). This is where i give a name and the time interval (start/end):

After that it redirects to the entity view:

Second step in the workflow is to select related entity records using a custom oro_multiselect_entity, with datagrid filtered by previous start and end date (datagrid config can be seen in above posts):

As you see in the picture there are no records added.

Then i press <+Add> to add records:

Here i select the first two records and add them to the form.

And finally i save them, redirect to the entity view page and can be seen in the datagrid:

The problem appears when i go back one step, where i have to select new records/deselect currently selected. Previously selected records does not appear on the form so i can remove them.

Also if i press the <+Add> button to open the grid, they do not appear as selected in the grid:

I’d appreciate if you could help me with this issue.
Thanks!

[bosumfliciParticipant]

Back :(

Can you help me setting initial_elements of the oro_multiple_entity in a workflow step? I cannot figure it out!!!

[bosumfliciParticipant]

I’ve found the missing code:

YAML

options: routerEnabled: false rowSelection: dataField: id columnName: hasContact selectors: included: '#appendPanelViews' excluded: '#removePanelViews'

1 2 3 4 5 6 7 8

options:             routerEnabled: false             rowSelection:                 dataField: id                 columnName: hasContact                 selectors:                     included: '#appendPanelViews'                     excluded: '#removePanelViews'

Thanks!

[bosumfliciParticipant]

Thanks Mike! Above i did not choose the best example to describe my problem.

I have a table with resources and a table with events related to those resources. What i need is a datagrid filled with all resources that do not have events that do not overlap with a time interval.

So, with standard select i would write:

MySQL

SELECT res.id FROM resources res WHERE res.id NOT IN ( SELECT ev.resource_id FROM events ev WHERE (ev.start >= :start AND ev.start <= :end) OR (ev.end >= :start AND ev.end <= :end) OR (ev.start >= :start AND ev.end <= :end) OR (ev.start <= :start AND ev.end >= :end) )

1 2 3 4 5 6 7 8

SELECT res.id FROM resources res WHERE res.id NOT IN (     SELECT ev.resource_id FROM events ev     WHERE (ev.start >= :start AND ev.start <= :end) OR           (ev.end >= :start AND ev.end <= :end) OR           (ev.start >= :start AND ev.end <= :end) OR           (ev.start <= :start AND ev.end >= :end) )

I did it this way:

YAML

query: select: - res.id ... join: left: - join: res.events alias: ev conditionType: WITH condition: '(ev.start >= :start AND ev.start <= :end) OR (ev.end >= :start AND ev.end <= :end) OR (ev.start >= :start AND ev.end <= :end) OR (ev.start <= :start AND ev.end >= :end)' where: and: - ev.resource IS NULL bind_parameters: - start - end

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

query:                 select:                     - res.id                     ...                 join:                     left:                         -                             join: res.events                             alias: ev                             conditionType: WITH                             condition: '(ev.start >= :start AND ev.start <= :end) OR (ev.end >= :start AND ev.end <= :end) OR (ev.start >= :start AND ev.end <= :end) OR (ev.start <= :start AND ev.end >= :end)'                 where:                     and:                         - ev.resource IS NULL             bind_parameters:                 - start                 - end

So this is DONE.

Next i implemented a workflow to select start and end dates in the first step, and in the second step i extended oro_multiple_entity to use with the above grid in the 2nd workflow transition. The problem appears after i choose the rows from datagrid widget, which have to be added to the form field after pressing the <select> button. They render fine on the view, but when i submit the form it says “This value should not be blank.”
After digging a while i figured out that it does not sets the ids to the hidden form element to be saved (oro_workflow_transition_offer_resources_added)!!!
If i press on “x” it removes those coresponding ids from the view and also sets the ids to the hidden form element to be removed after submit. (oro_workflow_transition_offer_resources_removed)

Do you have any idea why is this happening and how to fix it?!

Thanks!

[bosumfliciParticipant]

Hi,

I enabled attachments via “System -> Entities -> Entity Management -> Your Entity -> Edit -> Enable Attachments” and by migrations, on custom and system entity but same result. After i run that command, attachments disapear and i have to re-enabled them. I use:

oro/platform dev-master MIT
oro/crm dev-master OSL-3.0

Thanks!

[bosumfliciParticipant]

Thank you Mike! Indeed is a good base to start. Your code works like charm!

[bosumfliciParticipant]

To understand better i added a print screen:

Looking at this picture, i need to be able to filter calendar events when i change a filter from the grid filters.

Thanks!

[bosumfliciParticipant]

No! I have developed my own calendar bundle with my custom evenst entity. The calendar view is working good. What i need now is to add some filters for the calendar view to filter the events. I was thinking to use the filters that shows with a datagrid in a index template, but instead of filtering datagrid collection, they must filter the calenndar events collection.

[bosumfliciParticipant]

Hi

It’s not about the oro default calendar events. I’ve created my custom event entity and it has some properties which i need to filter. For example if we refer to orocalendar events i need to filter events by description containing some “text”!

Thanks

[bosumfliciParticipant]

property: fullName

[Author]

Replies