Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- datagrid:
- dashboard-my-accounts-activity-grid:
- source:
- type: orm
- acl_resource: orocrm_account_view
- query:
- select:
- - a.id
- - a.name
- - defaultContactEmail.email as contactEmail
- - defaultContactPhone.phone as contactPhone
- - max(history.visitedAt) as visitDate
- from:
- - { table: %orocrm_account.account.entity.class%, alias: a }
- join:
- left:
- - { join: a.defaultContact, alias: defaultContact }
- - { join: defaultContact.emails, alias: defaultContactEmail, conditionType: 'WITH', condition: 'defaultContactEmail.primary = true' }
- - { join: defaultContact.phones, alias: defaultContactPhone, conditionType: 'WITH', condition: 'defaultContactPhone.primary = true' }
- inner:
- -
- join: Oro\Bundle\NavigationBundle\Entity\NavigationHistoryItem
- alias: history
- conditionType: WITH
- condition: "a.id=history.entityId AND history.route='orocrm_account_view'"
- where:
- and:
- - history.user = @oro_security.security_facade->getLoggedUserId
- groupBy: a.id, a.name, contactEmail, contactPhone
- orderBy:
- - column: visitDate
- dir: desc
- sorters:
- visitDate: { history.: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_DESC }
- columns:
- name:
- type: twig
- label: orocrm.account.name.label
- frontend_type: html
- template: OroCRMAccountBundle:Account:Datagrid/Property/accountName.html.twig
- contactEmail:
- label: orocrm.contact.contactemail.email.label
- contactPhone:
- label: orocrm.contact.contactphone.phone.label
- frontend_type: phone
- options:
- entityHint: account
- toolbarOptions:
- hide: true
- pageSize:
- items: [10]
- default_per_page: 10
- accounts-grid:
- extended_entity_name: %orocrm_account.account.entity.class%
- source:
- type: orm
- acl_resource: orocrm_account_view
- query:
- select:
- - a.id
- - a.mp_venue_id as venueId
- - a.name
- - a.mp_chain as chain
- - a.mp_brand as brand
- - CONCAT(areaManager.firstName, ' ', areaManager.lastName) as areaManagerName
- - CONCAT(defaultContact.firstName, ' ', defaultContact.lastName) as contactName
- - defaultContactEmail.email as contactEmail
- - defaultContactPhone.phone as contactPhone
- - CONCAT(accountOwner.firstName, ' ', accountOwner.lastName) as ownerName
- - A.active
- from:
- - { table: %orocrm_account.account.entity.class%, alias: a }
- join:
- left:
- - { join: a.defaultContact, alias: defaultContact }
- - { join: defaultContact.emails, alias: defaultContactEmail, conditionType: 'WITH', condition: 'defaultContactEmail.primary = true' }
- - { join: defaultContact.phones, alias: defaultContactPhone, conditionType: 'WITH', condition: 'defaultContactPhone.primary = true' }
- - { join: a.owner, alias: accountOwner }
- - { join: a.areaManager, alias: areaManager}
- properties:
- id: ~
- view_link:
- type: url
- route: orocrm_account_view
- params: [ id ]
- update_link:
- type: url
- route: orocrm_account_update
- params: [ id ]
- delete_link:
- type: url
- route: oro_api_delete_account
- params: [ id ]
- columns:
- venueId:
- label: orocrm.account.venueId.label
- name:
- label: orocrm.account.name.label
- chain:
- label: orocrm.account.chain.label
- brand:
- label: orocrm.account.brand.label
- areaManagerName:
- label: orocrm.account.areaManagerName.label
- contactName:
- label: orocrm.account.contact.name
- contactEmail:
- label: orocrm.account.contact.email
- contactPhone:
- label: orocrm.account.contact.phone
- frontend_type: phone
- ownerName:
- label: orocrm.account.owner.label
- active:
- label: orocrm.account.active.label
- sorters:
- columns:
- venueId:
- data_name: venueId
- name:
- data_name: a.name
- chain:
- data_name: chain
- brand:
- data_name: brand
- areaManagerName:
- data_name: areaManagerName
- contactName:
- data_name: contactName
- contactEmail:
- data_name: contactEmail
- contactPhone:
- data_name: contactPhone
- ownerName:
- data_name: ownerName
- filters:
- columns:
- venueId:
- type: number
- data_name: venueId
- name:
- type: string
- data_name: a.name
- chain:
- type: string
- data_name: chain
- brand:
- type: string
- data_name: brand
- areaManagerName:
- type: string
- data_name: areaManagerName
- contactName:
- type: string
- data_name: contactName
- contactEmail:
- type: string
- data_name: contactEmail
- contactPhone:
- type: string
- data_name: contactPhone
- ownerName:
- type: string
- data_name: ownerName
- active:
- type: number
- data_name: active
- default:
- active:
- value: 1
- actions:
- view:
- type: navigate
- acl_resource: orocrm_account_view
- label: oro.grid.action.view
- icon: eye-open
- link: view_link
- rowAction: true
- update:
- type: navigate
- acl_resource: orocrm_account_update
- label: oro.grid.action.update
- icon: edit
- link: update_link
- delete:
- type: delete
- acl_resource: orocrm_account_delete
- label: oro.grid.action.delete
- icon: trash
- link: delete_link
- mass_actions:
- task:
- type: ajax
- frontend_type: task-mass
- handler: none
- entity_name: %orocrm_account.account.entity.class%
- data_identifier: a.id
- label: orocrm.task.add_entity
- icon: tasks
- notification:
- type: ajax
- frontend_type: notification-mass
- handler: none
- entity_name: %orocrm_account.account.entity.class%
- data_identifier: a.id
- label: orocrm.notification.send
- icon: flag
- options:
- entityHint: account
- export: true
- entity_pagination: true
- base-account-contacts-grid:
- extended_entity_name: %orocrm_contact.entity.class%
- source:
- type: orm
- acl_resource: orocrm_contact_view
- query:
- select:
- - c.id
- - c.lastName
- - c.firstName
- - contactSource.label as contactSourceLabel
- - email.email as primaryEmail
- - phone.phone as primaryPhone
- - CONCAT(CASE WHEN address.regionText IS NOT NULL THEN address.regionText ELSE region.name END, '') as regionLabel
- - country.name as countryName
- - address.postalCode as addressPostalCode
- from:
- - { table: %orocrm_contact.entity.class%, alias: c }
- join:
- left:
- - { join: c.addresses, alias: address, conditionType: WITH, condition: 'address.primary = true' }
- - { join: c.emails, alias: email, conditionType: WITH, condition: 'email.primary = true' }
- - { join: c.phones, alias: phone, conditionType: WITH, condition: 'phone.primary = true' }
- - { join: c.groups, alias: contactGroup }
- - { join: c.source, alias: contactSource }
- - { join: address.country, alias: country }
- - { join: address.region, alias: region }
- sorters:
- columns:
- first_name:
- data_name: c.firstName
- last_name:
- data_name: c.lastName
- primaryEmail:
- data_name: email.email
- primaryPhone:
- data_name: phone.phone
- countryName:
- data_name: country.name
- regionLabel:
- data_name: regionLabel
- addressPostalCode:
- data_name: address.postalCode
- default:
- lastName: ASC
- options:
- entityHint: contact
- account-contacts-update-grid:
- extends: base-account-contacts-grid
- source:
- query:
- select:
- - >
- (CASE WHEN (:account IS NOT NULL) THEN
- CASE WHEN (:account MEMBER OF c.accounts OR c.id IN (:data_in)) AND c.id NOT IN (:data_not_in)
- THEN true ELSE false END
- ELSE
- CASE WHEN c.id IN (:data_in) AND c.id NOT IN (:data_not_in)
- THEN true ELSE false END
- END) as hasContact
- bind_parameters:
- -
- name: account
- default: null
- columns:
- hasContact:
- label: orocrm.account.assigned.label
- editable: true
- frontend_type: boolean
- first_name:
- label: orocrm.contact.first_name.label
- data_name: firstName
- last_name:
- label: orocrm.contact.last_name.label
- data_name: lastName
- primaryEmail:
- label: orocrm.contact.email.label
- primaryPhone:
- label: orocrm.contact.contactphone.phone.label
- frontend_type: phone
- countryName:
- label: orocrm.contact.contactaddress.country.label
- regionLabel:
- label: orocrm.contact.contactaddress.region.label
- addressPostalCode:
- label: orocrm.contact.contactaddress.postal_code.label
- properties:
- id: ~
- sorters:
- columns:
- hasContact: { data_name: hasContact }
- default:
- hasContact: DESC
- filters:
- columns:
- hasContact:
- data_name: hasContact
- type: boolean
- first_name:
- type: string
- data_name: c.firstName
- last_name:
- type: string
- data_name: c.lastName
- primaryEmail:
- type: string
- data_name: email.email
- primaryPhone:
- type: string
- data_name: phone.phone
- countryName:
- type: entity
- data_name: address.country
- enabled: false
- options:
- field_options:
- class: OroAddressBundle:Country
- property: name
- query_builder: @orocrm_contact.contact.datagrid_helper->getCountryFilterQueryBuilder
- translatable_options: false
- regionLabel:
- type: string
- data_name: regionLabel
- enabled: false
- addressPostalCode:
- type: string
- data_name: addressPostalCode
- enabled: false
- options:
- routerEnabled: false
- rowSelection:
- dataField: id
- columnName: hasContact
- selectors:
- included: '#appendContacts'
- excluded: '#removeContacts'
- accounts-select-grid:
- extended_entity_name: %orocrm_account.account.entity.class%
- source:
- type: orm
- acl_resource: orocrm_account_view
- query:
- select:
- - a.id
- - a.name
- - CONCAT(defaultContact.firstName, CONCAT(' ', defaultContact.lastName)) as contactName
- - defaultContactEmail.email as contactEmail
- - defaultContactPhone.phone as contactPhone
- - CONCAT(accountOwner.firstName, CONCAT(' ', accountOwner.lastName)) as ownerName
- from:
- - { table: %orocrm_account.account.entity.class%, alias: a }
- join:
- left:
- - { join: a.defaultContact, alias: defaultContact }
- - { join: defaultContact.emails, alias: defaultContactEmail, conditionType: 'WITH', condition: 'defaultContactEmail.primary = true' }
- - { join: defaultContact.phones, alias: defaultContactPhone, conditionType: 'WITH', condition: 'defaultContactPhone.primary = true' }
- - { join: a.owner, alias: accountOwner }
- properties:
- id: ~
- columns:
- name:
- label: orocrm.account.name.label
- contactName:
- label: orocrm.account.contact.name
- contactEmail:
- label: orocrm.account.contact.email
- contactPhone:
- label: orocrm.account.contact.phone
- frontend_type: phone
- ownerName:
- label: orocrm.account.owner.label
- sorters:
- columns:
- name:
- data_name: a.name
- contactName:
- data_name: contactName
- contactEmail:
- data_name: contactEmail
- contactPhone:
- data_name: contactPhone
- ownerName:
- data_name: ownerName
- filters:
- columns:
- name:
- type: string
- data_name: a.name
- contactName:
- type: string
- data_name: contactName
- contactEmail:
- type: string
- data_name: contactEmail
- contactPhone:
- type: string
- data_name: contactPhone
- ownerName:
- type: string
- data_name: ownerName
- options:
- entityHint: account
- accounts-for-context-grid:
- extended_entity_name: %orocrm_account.account.entity.class%
- source:
- type: orm
- acl_resource: orocrm_account_view
- query:
- select:
- - a.id
- - a.name
- - CONCAT(defaultContact.firstName, CONCAT(' ', defaultContact.lastName)) as contactName
- - defaultContactEmail.email as contactEmail
- - defaultContactPhone.phone as contactPhone
- - CONCAT(accountOwner.firstName, CONCAT(' ', accountOwner.lastName)) as ownerName
- from:
- - { table: %orocrm_account.account.entity.class%, alias: a }
- join:
- left:
- - { join: a.defaultContact, alias: defaultContact }
- - { join: defaultContact.emails, alias: defaultContactEmail, conditionType: 'WITH', condition: 'defaultContactEmail.primary = true' }
- - { join: defaultContact.phones, alias: defaultContactPhone, conditionType: 'WITH', condition: 'defaultContactPhone.primary = true' }
- - { join: a.owner, alias: accountOwner }
- columns:
- id:
- label: orocrm.account.id.label
- name:
- label: orocrm.account.name.label
- contactName:
- label: orocrm.account.contact.name
- contactEmail:
- label: orocrm.account.contact.email
- contactPhone:
- label: orocrm.account.contact.phone
- frontend_type: phone
- ownerName:
- label: orocrm.account.owner.label
- sorters:
- columns:
- name:
- data_name: a.name
- contactName:
- data_name: contactName
- contactEmail:
- data_name: contactEmail
- contactPhone:
- data_name: contactPhone
- ownerName:
- data_name: ownerName
- filters:
- columns:
- name:
- type: string
- data_name: a.name
- contactName:
- type: string
- data_name: contactName
- contactEmail:
- type: string
- data_name: contactEmail
- contactPhone:
- type: string
- data_name: contactPhone
- ownerName:
- type: string
- data_name: ownerName
- options:
- entityHint: account
- entity_pagination: true
- toolbarOptions:
- pageSize:
- default_per_page: 10
- routerEnabled: false
- </pre>
- I have also created a file bundles.yml under src/MatchPint/Bundle/DugoutBundleAccount/Resources/config/oro/ with the following content:
- <pre class="lang:php decode:true " >bundles:
- -
- name: MatchPint\Bundle\DugoutAccountBundle\MatchPintDugoutAccountBundle
- priority: 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement