himiklab / jqgrid-bundle
Symfony bundle for a powerful ajax-enabled grid - jqGrid or free jqGrid.
Installs: 79
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 1
Forks: 0
Open Issues: 0
Type:symfony-bundle
Requires
Requires (Dev)
This package is auto-updated.
Last update: 2022-01-12 15:39:42 UTC
README
Symfony bundle for a powerful ajax-enabled grid - jqGrid or free jqGrid.
Installation
The preferred way to install this extension is through composer.
- Either run
php composer.phar require --prefer-dist "himiklab/jqgrid-bundle" "*"
or add
"himiklab/jqgrid-bundle" : "*"
to the require section of your application's composer.json
file. And registered HimiklabJqGridBundle
in you application config.
- Assets
reqired: jqgrid
or free-jqgrid
with jquery
of course
optional: @fortawesome/fontawesome-free
or jquery-ui
, bootstrap
- Template
{% block stylesheets %} {{ encore_entry_link_tags('jqgrid') }} {% endblock %} {% block body %} <table id="jqGrid-grid"></table> <div id="jqGrid-pager"></div> {% endblock %} {% block javascripts %} {{ encore_entry_script_tags('jqgrid') }} <script> $(document).ready(function () { $("#jqGrid-grid").jqGrid({ //"guiStyle": "bootstrap4", "url": "{{ path('customer_jqgrid_read') }}", "datatype": "json", "mtype": "post", "pager": "#jqGrid-pager", "colNames": ["ID", "Name", "Surname", "Birthplace", "Birthdate"], "colModel": [ {{ jqgrid_colmodel(columns, columnsIsVisible, columnsIsEditable)|raw }} ], "rowNum": 30, "rowList": [30, 60], "multiselect": true, "multiSort": true, "viewrecords": true //"iconSet": "fontAwesomeSolid" }) .navGrid('#jqGrid-pager', { "edit": true, "add": true, "del": true, "search": true, "view": true }, { "url": "{{ path('customer_jqgrid_update') }}", "afterSubmit": function (response) { return [response.responseText === "", response.responseText, null]; } }, { "url": "{{ path('customer_jqgrid_create') }}", "afterSubmit": function (response) { return [response.responseText === "", response.responseText, null]; } }, {"url": "{{ path('customer_jqgrid_delete') }}"}, { "multipleSearch": true, "multipleGroup": true, "closeAfterSearch": true, "showQuery": true, }, {} ) .filterToolbar({"stringResult": true}); }); </script> {% endblock %}
- Controller
use himiklab\JqGridBundle\JqGrid; class CustomerController extends AbstractController { private $jqgrid; public function __construct(JqGrid $jqgrid) { $this->jqgrid = $jqgrid ->setEntityName(Customer::class); } /** * @Route("/jqgrid", methods={"GET"}) */ public function index(): Response { $columns = [ 'id' => ['type' => 'int',], 'fullName.name', 'fullName.surname', 'birthplace', 'birthdate' => ['type' => 'date'] ]; $columnsIsVisible = ['id', 'fullName.name', 'fullName.surname', 'birthplace', 'birthdate']; $columnsIsEditable = ['fullName.name', 'fullName.surname', 'birthplace', 'birthdate']; return $this->render( 'incoming/index.html.twig', ['columns' => $columns, 'columnsIsVisible' => $columnsIsVisible, 'columnsIsEditable' => $columnsIsEditable] ); } /** * @Route("/jqgrid/read", methods={"POST"}, name="customer_jqgrid_read") */ public function read(Request $request): Response { return $this->jqgrid->handleRead($request); } /** * @Route("/jqgrid/create", methods={"POST"}, name="customer_jqgrid_create") */ public function create(Request $request): Response { return $this->jqgrid->handleCreate($request) ?: new Response(); } /** * @Route("/jqgrid/update", methods={"POST"}, name="customer_jqgrid_update") */ public function update(Request $request): Response { return $this->jqgrid->handleUpdate($request) ?: new Response(); } /** * @Route("/jqgrid/delete", methods={"POST"}, name="customer_jqgrid_delete") */ public function delete(Request $request): Response { $this->jqgrid->handleDelete($request); return new Response(); } }