Not able to show all service entity list (CRUD operation Not working)

//orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Controller/ServiceController.php

namespace Oro\Bundle\EntityConfigBundle\Controller;

use Doctrine\ORM\QueryBuilder;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\Component\HttpFoundation\RedirectResponse;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;

use Oro\Bundle\SecurityBundle\Annotation\Acl;
use Oro\Bundle\BatchBundle\ORM\Query\QueryCountCalculator;
use Oro\Bundle\EntityBundle\Tools\EntityRoutingHelper;
use Oro\Bundle\EntityBundle\Provider\EntityFieldProvider;
use Oro\Bundle\EntityConfigBundle\Config\ConfigManager;
use Oro\Bundle\EntityConfigBundle\Provider\ConfigProvider;
use Oro\Bundle\EntityConfigBundle\Provider\PropertyConfigContainer;
use Oro\Bundle\EntityConfigBundle\Tools\ConfigHelper;
use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope;
use Oro\Bundle\EntityConfigBundle\Helper\EntityConfigProviderHelper;
use Doctrine\ORM\Query\AST\Functions\ConcatFunction;

use Oro\Bundle\EntityConfigBundle\Entity\Services;

class ServiceController extends Controller
{

	/**
	 * @Route(name="oro_service_index")
	 * @Template
	 */
	public function indexAction()
	{

		return $this-&gt;render(
				'OroEntityConfigBundle:Service:index.html.twig'
				);
	}
	
	
	

	/**
	 * @Route("/create", name="oro_service_create")
	 * @Template("InventoryBundle:Vehicle:update.html.twig")
	 * @Acl(
	 *     id="oro_service_create",
	 *     type="entity",
	 *     class="OroEntityConfigBundle:Services",
	 *     permission="CREATE"
	 * )
	 */
	public function createAction(Request $request)
	{
		return $this-&gt;update(new Services(), $request);
	}
	
	/**
	 * @Route("/update/{id}", name="oro_service_update", requirements={"id":"\d+"}, defaults={"id":0})
	 * @Template()
	 * @Acl(
	 *     id="oro_service_update",
	 *     type="entity",
	 *     class="OroEntityConfigBundle:Services",
	 *     permission="EDIT"
	 * )
	 */
	public function updateAction(Services $service, Request $request)
	{
		return $this-&gt;update($service, $request);
	}
	
	
	public function update(Services $service, Request $request)
	{
		$form = $this-&gt;get('form.factory')-&gt;create('service_name', $service);
		$form-&gt;handleRequest($request);
	
		if ($form-&gt;isSubmitted() &amp;&amp; $form-&gt;isValid()) {
			$entityManager = $this-&gt;getDoctrine()-&gt;getManager();
			$entityManager-&gt;persist($service);
			$entityManager-&gt;flush();
	
			return $this-&gt;get('oro_ui.router')-&gt;redirectAfterSave(
					array(
							'route' =&gt; 'oro_service_update',
							'parameters' =&gt; array('id' =&gt; $service-&gt;getId()),
					),
					array('route' =&gt; 'oro_service_index'),
					$service
					);
		}
	
		return array(
				'entity' =&gt; $service,
				'form' =&gt; $form-&gt;createView(),
		);
	}
	
	
	
	
	
	
	
	
		
	
}

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

//orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Controller/ServiceController.php

namespace Oro\Bundle\EntityConfigBundle\Controller;

use Doctrine\ORM\QueryBuilder;

use Symfony\Bundle\FrameworkBundle\Controller\Controller;

use Symfony\Component\HttpFoundation\RedirectResponse;

use Symfony\Component\HttpFoundation\Request;

use Symfony\Component\HttpFoundation\Response;

use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;

use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;

use Oro\Bundle\SecurityBundle\Annotation\Acl;

use Oro\Bundle\BatchBundle\ORM\Query\QueryCountCalculator;

use Oro\Bundle\EntityBundle\Tools\EntityRoutingHelper;

use Oro\Bundle\EntityBundle\Provider\EntityFieldProvider;

use Oro\Bundle\EntityConfigBundle\Config\ConfigManager;

use Oro\Bundle\EntityConfigBundle\Provider\ConfigProvider;

use Oro\Bundle\EntityConfigBundle\Provider\PropertyConfigContainer;

use Oro\Bundle\EntityConfigBundle\Tools\ConfigHelper;

use Oro\Bundle\EntityExtendBundle\EntityConfig\ExtendScope;

use Oro\Bundle\EntityConfigBundle\Helper\EntityConfigProviderHelper;

use Doctrine\ORM\Query\AST\Functions\ConcatFunction;

use Oro\Bundle\EntityConfigBundle\Entity\Services;

class ServiceController extends Controller

{

/**

* @Route(name="oro_service_index")

* @Template

*/

public function indexAction()

{

return $this->render(

'OroEntityConfigBundle:Service:index.html.twig'

);

}

/**

* @Route("/create", name="oro_service_create")

* @Template("InventoryBundle:Vehicle:update.html.twig")

* @Acl(

* id="oro_service_create",

* type="entity",

* class="OroEntityConfigBundle:Services",

* permission="CREATE"

* )

*/

public function createAction(Request $request)

{

return $this->update(new Services(), $request);

}

/**

* @Route("/update/{id}", name="oro_service_update", requirements={"id":"\d+"}, defaults={"id":0})

* @Template()

* @Acl(

* id="oro_service_update",

* type="entity",

* class="OroEntityConfigBundle:Services",

* permission="EDIT"

* )

*/

public function updateAction(Services $service, Request $request)

{

return $this->update($service, $request);

}

public function update(Services $service, Request $request)

{

$form = $this->get('form.factory')->create('service_name', $service);

$form->handleRequest($request);

if ($form->isSubmitted() && $form->isValid()) {

$entityManager = $this->getDoctrine()->getManager();

$entityManager->persist($service);

$entityManager->flush();

return $this->get('oro_ui.router')->redirectAfterSave(

array(

'route' => 'oro_service_update',

'parameters' => array('id' => $service->getId()),

),

array('route' => 'oro_service_index'),

$service

);

}

return array(

'entity' => $service,

'form' => $form->createView(),

);

}

//orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Resources/views/Service/index.html.twig 

{% extends 'OroUIBundle:actions:index.html.twig' %}
{% import 'OroUIBundle::macros.html.twig' as UI %}

{% set gridName = 'services-grid' %}
{% set pageTitle = 'Services' %}


{% block navButtons %}
    {% if resource_granted('oro_service_create') %}
        {{ UI.addButton({
            'path': path('oro_service_create'),
            'entity_label': 'Service'
        }) }}
    {% endif %}
{% endblock %}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

//orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Resources/views/Service/index.html.twig

{% extends 'OroUIBundle:actions:index.html.twig' %}

{% import 'OroUIBundle::macros.html.twig' as UI %}

{% set gridName = 'services-grid' %}

{% set pageTitle = 'Services' %}

{% block navButtons %}

{% if resource_granted('oro_service_create') %}

{{ UI.addButton({

'path': path('oro_service_create'),

'entity_label': 'Service'

}) }}

{% endif %}

{% endblock %}

//vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Resources/views/Service/update.html.twig

{% extends 'OroUIBundle:actions:update.html.twig' %}
{% import 'OroUIBundle::macros.html.twig' as UI %}
{% form_theme form with 'OroFormBundle:Form:fields.html.twig' %}

{% if form.vars.value.id %}
    {% set formAction = path('oro_service_update', { 'id': form.vars.value.id }) %}
{% else %}
    {% set formAction = path('oro_service_create') %}
{% endif %}

{% block navButtons %}
    {% if form.vars.value.id and resource_granted('DELETE', form.vars.value) %}
        {{ UI.deleteButton({
            'dataUrl': path('oro_delete_service', {'id': form.vars.value.id}),
            'dataRedirect': path('oro_service_index'),
            'aCss': 'no-hash remove-button',
            'id': 'btn-remove-tag',
            'dataId': form.vars.value.id,
            'entity_label': 'Service'
        }) }}
        {{ UI.buttonSeparator() }}
    {% endif %}
    {{ UI.cancelButton(path('oro_service_index')) }}
    {% set html = UI.saveAndCloseButton() %}
    {% if resource_granted('oro_service_update') %}
        {% set html = html ~ UI.saveAndStayButton() %}
    {% endif %}
    {{ UI.dropdownSaveButton({ 'html': html }) }}
{% endblock navButtons %}

{% block pageHeader %}
    {% if form.vars.value.id %}
        {% set breadcrumbs = {
            'entity':      form.vars.value,
            'indexPath':   path('oro_service_index'),
            'indexLabel': 'Service',
            'entityTitle': 'Service Name'
        } %}
        {{ parent() }}
    {% else %}
        {% set title = 'oro.ui.create_entity'|trans({'%entityName%': 'Service'}) %}
        {% include 'OroUIBundle::page_title_block.html.twig' with { title: title } %}
    {% endif %}
{% endblock pageHeader %}

{% block content_data %}
    {% set id = 'Service-edit' %}

    {% set dataBlocks = [{
            'title': 'General'|trans,
            'class': 'active',
            'subblocks': [{
                'title': '',
                'data': [
                    form_row(form.name),
                ]
            }]
        }]
    %}
    {% set data = {
        'formErrors': form_errors(form)? form_errors(form) : null,
        'dataBlocks': dataBlocks,
    } %}
    {{ parent() }}
{% endblock content_data %}

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

//vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Resources/views/Service/update.html.twig

{% extends 'OroUIBundle:actions:update.html.twig' %}

{% import 'OroUIBundle::macros.html.twig' as UI %}

{% form_theme form with 'OroFormBundle:Form:fields.html.twig' %}

{% if form.vars.value.id %}

{% set formAction = path('oro_service_update', { 'id': form.vars.value.id }) %}

{% else %}

{% set formAction = path('oro_service_create') %}

{% endif %}

{% block navButtons %}

{% if form.vars.value.id and resource_granted('DELETE', form.vars.value) %}

{{ UI.deleteButton({

'dataUrl': path('oro_delete_service', {'id': form.vars.value.id}),

'dataRedirect': path('oro_service_index'),

'aCss': 'no-hash remove-button',

'id': 'btn-remove-tag',

'dataId': form.vars.value.id,

'entity_label': 'Service'

}) }}

{% endif %}

{% set html = UI.saveAndCloseButton() %}

{% if resource_granted('oro_service_update') %}

{% set html = html ~ UI.saveAndStayButton() %}

{% endif %}

{{ UI.dropdownSaveButton({ 'html': html }) }}

{% endblock navButtons %}

{% block pageHeader %}

{% if form.vars.value.id %}

{% set breadcrumbs = {

'entity': form.vars.value,

'indexPath': path('oro_service_index'),

'indexLabel': 'Service',

'entityTitle': 'Service Name'

} %}

{% else %}

{% set title = 'oro.ui.create_entity'|trans({'%entityName%': 'Service'}) %}

{% include 'OroUIBundle::page_title_block.html.twig' with { title: title } %}

{% endif %}

{% endblock pageHeader %}

{% block content_data %}

{% set id = 'Service-edit' %}

{% set dataBlocks = [{

'title': 'General'|trans,

'class': 'active',

'subblocks': [{

'title': '',

'data': [

form_row(form.name),

]

}]

%}

{% set data = {

'formErrors': form_errors(form)? form_errors(form) : null,

'dataBlocks': dataBlocks,

} %}

{% endblock content_data %}

//orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Form/Type/ServiceType.php

namespace Oro\Bundle\EntityConfigBundle\Form\Type;

use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\OptionsResolver\OptionsResolverInterface;

class ServiceType extends AbstractType
{
	public function buildForm(FormBuilderInterface $builder, array $options)
	{
		$builder
		-&gt;add('name')
		;
	}

	public function configureOptions(OptionsResolver $resolver)
	{
		$resolver-&gt;setDefaults(array(
				'data_class' =&gt; 'EntityConfigBundle\Entity\Services',
		));
	}

	public function getName()
	{
		return 'service_name';
	}
}

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

//orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Form/Type/ServiceType.php

namespace Oro\Bundle\EntityConfigBundle\Form\Type;

use Symfony\Component\Form\AbstractType;

use Symfony\Component\Form\FormBuilderInterface;

use Symfony\Component\OptionsResolver\OptionsResolverInterface;

class ServiceType extends AbstractType

{

public function buildForm(FormBuilderInterface $builder, array $options)

{

$builder

->add('name')

;

}

public function configureOptions(OptionsResolver $resolver)

{

$resolver->setDefaults(array(

'data_class' => 'EntityConfigBundle\Entity\Services',

));

}

public function getName()

{

return 'service_name';

}

//orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Resources/config/oro/datagrids.yml 

# Services config entities grid
    services-grid:
        acl_resource: oro_service_index
        options:
            entityHint: entity
            toolbarOptions:
                pageSize:
                    default_per_page: 100
        source:
            type: orm
            query:
                select:
                    - srs.id
                    - srs.name
                from:
                    - { table: OroEntityConfigBundle:Services, alias: srs }
                
        columns:
            id:
                label: id
                frontend_type: integer
            name:
                label: Name
                frontend_type: string
                 
        
        sorters:
            columns:
                id:
                    data_name: srs.id
                name:
                    data_name: srs.name
            
        
        filters:
            columns:
                id:
                    type: number
                    data_name: srs.id
                name:
                    type: string
                    data_name: srs.name
                    
        properties:
            id: ~
            
            
            
            update_link:
                type:       url
                route:      oro_service_update
                params:     [ id ]
           
            
            delete_link:
                type:       url
                route:      oro_delete_service
                params:     [ id ]
        
        actions:
            
            update:
                type:          navigate
                acl_resource:  oro_service_update
                label:         oro.grid.action.update
                icon:          edit
                link:          update_link
                rowAction:     true
            
           
            delete:
                type:          navigate
                acl_resource:  oro_delete_service
                label:         oro.grid.action.delete
                icon:          trash
                link:          delete_link
        options:
            entity_pagination: true
            contexts:
                enabled: true

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

//orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Resources/config/oro/datagrids.yml

# Services config entities grid

services-grid:

acl_resource: oro_service_index

options:

entityHint: entity

toolbarOptions:

pageSize:

default_per_page: 100

source:

type: orm

query:

select:

- srs.id

- srs.name

from:

- { table: OroEntityConfigBundle:Services, alias: srs }

columns:

id:

label: id

frontend_type: integer

name:

label: Name

frontend_type: string

sorters:

columns:

id:

data_name: srs.id

name:

data_name: srs.name

filters:

columns:

id:

type: number

data_name: srs.id

name:

type: string

data_name: srs.name

properties:

id: ~

update_link:

type: url

route: oro_service_update

params: [ id ]

delete_link:

type: url

route: oro_delete_service

params: [ id ]

actions:

update:

type: navigate

acl_resource: oro_service_update

label: oro.grid.action.update

icon: edit

link: update_link

rowAction: true

delete:

type: navigate

acl_resource: oro_delete_service

label: oro.grid.action.delete

icon: trash

link: delete_link

options:

entity_pagination: true

contexts:

enabled: true

/orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Entity/Services.php

<?php

namespace Oro\Bundle\EntityConfigBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="services")
 */

class Services 
{
	/**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;
    
    /**
     * @var string
     *
     * @ORM\Column(name="name",type="string", length=255)
     */
    protected $name;

    /**
     * @return int
     */
    public function getId()
    {
    	return $this->id;
    }
    
    /**
     * @param  int     $id
     * @return Account
     */
    public function setId($id)
    {
    	$this->id = $id;
    
    	return $this;
    }
    
   
    
    /**
     * @return string
     */
    public function getName()
    {
    	return $this->name;
    }
    
    /**
     * @param string $name
     */
    public function setName($name)
    {
    	
    	$this->name = $name;
    	
    	return $this;
    }
}

?>

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

/orocrm/vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Entity/Services.php

<?php

namespace Oro\Bundle\EntityConfigBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**

* @ORM\Entity

* @ORM\Table(name="services")

*/

class Services

{

/**

* @ORM\Id

* @ORM\Column(type="integer")

* @ORM\GeneratedValue(strategy="AUTO")

*/

protected $id;

/**

* @var string

*

* @ORM\Column(name="name",type="string", length=255)

*/

protected $name;

/**

* @return int

*/

public function getId()

{

return $this->id;

}

/**

* @param int $id

* @return Account

*/

public function setId($id)

{

$this->id = $id;

return $this;

}

/**

* @return string

*/

public function getName()

{

return $this->name;

}

/**

* @param string $name

*/

public function setName($name)

{

$this->name = $name;

return $this;

}

?>

OroCRM Forums