Chapter 7. HTML Table grid

Table of Contents

jqGrid language files

The display data in the table is one of the most common ways to be found in commercial systems, regardless of the market segment. The tables or grids possess a fundamental role in applications that need an organised list of data (rows and columns). The user is probably very familiar with information displayed in such tables although nowadays the use of div's is becoming more common.

The development of JQuery provides the ability to use it on one (or more) table (s) to display the search result for the user, where it can sometimes select rows records and perform operations such as editing and deleting records.

This is very useful in situations where there is the need to allow the user to edit data directly in the table by changing the value of each cell without having to use another page or a separate form. In order to satisfy such situations. There are several possible ways in which one could implement this ability which includes using available commercial or public domain 'grid' software or even rolling our own.

However there is also a need to consider the use of CSS to control the display of the table data, which serve to complicate any work which one might encounter in developing our own solution.

We looked extensively around to see what was freely available on the web and tried using a few. One we particularly liked was named jsgrid. This was very easy to use but unfortunately was not really suitable for our editing purpose. Whilst investigating we also found another also named jsgrid, This confused us for a while until we realised that this was a name clash and it was a fork of a product named Guriddo jsGrid (http://guriddo.net/). This is currently a commercial component which although it has a 'free' version, did not have a free license that we felt we could use. Prior to becoming commercial it was distributed under the MIT (GPL) licence and hence the forked version that we discovered. There was also another fork of the product at the same time named https://www.nuget.org/packages/free-jqGrid and this version appears to be more actively being developed hence we have decided to use this for our timesheet component.

This 'free-jqgrid' has extensive documentation, mainly the same documentation as for the commercial 'jqGrid' but also a lot of examples and a lot of active articles on the web, which are applicable to both the commercial and forked version.

jqGrid language files

There are a number of different language files available for jqGrid and these are specified using the i18n format, which basically means they use a two character code for the language rather than the tradition double code as used by Joomla.

i.e. Joomla default code: en-GB i18n code: en

There are a few double codes for languages such as Portuguese Brazilian. i.e. pt_br

At the time of writing this document the following language files for jqgrid exist. Note that this list is not necessarily definitive, just the best that we have currently determined. Hence it may be subject to change and/or correction.

Table 7.1. Table of available jqgrid languages

Nearest Joomla equivalent

Language

Filename

ar-AA (?)

Arabic

free-jqgrid/4.12.3/js/i18n/grid.locale-ar.min.js

bg-BG

Bulgarian

free-jqgrid/4.12.3/js/i18n/grid.locale-bg.min.js

ca-ES

Catalan

free-jqgrid/4.12.3/js/i18n/grid.locale-ca.min.js

zh-CN (?)

China

free-jqgrid/4.12.3/js/i18n/grid.locale-cn.min.js

cs-CZ

Czech

free-jqgrid/4.12.3/js/i18n/grid.locale-cs.min.js

da-DK

Danish

free-jqgrid/4.12.3/js/i18n/grid.locale-da.min.js

de-DE

German

free-jqgrid/4.12.3/js/i18n/grid.locale-de.min.js

el-GR

Greek

free-jqgrid/4.12.3/js/i18n/grid.locale-el.min.js

en-GB

English

free-jqgrid/4.12.3/js/i18n/grid.locale-en.min.js

es-ES

Spanish

free-jqgrid/4.12.3/js/i18n/grid.locale-es.min.js

fa-IR (?)

Persian (?)

free-jqgrid/4.12.3/js/i18n/grid.locale-fa.min.js

fi-FI

Finnish

free-jqgrid/4.12.3/js/i18n/grid.locale-fi.min.js

fr-FR

French

free-jqgrid/4.12.3/js/i18n/grid.locale-fr.min.js

gl-ES

Galacian

free-jqgrid/4.12.3/js/i18n/grid.locale-gl.min.js

he-IL

Hebrew (?)

free-jqgrid/4.12.3/js/i18n/grid.locale-he.min.js

hr-HR

Croatian

free-jqgrid/4.12.3/js/i18n/grid.locale-hr.min.js

hu-HU

Hungarian

free-jqgrid/4.12.3/js/i18n/grid.locale-hu.min.js

id-ID

Indonesia

free-jqgrid/4.12.3/js/i18n/grid.locale-id.min.js

(?)

Icelandic

free-jqgrid/4.12.3/js/i18n/grid.locale-is.min.js

it-IT

Italian

free-jqgrid/4.12.3/js/i18n/grid.locale-it.min.js

ja-JP

Japanese

free-jqgrid/4.12.3/js/i18n/grid.locale-ja.min.js

ko-KR

Korea

free-jqgrid/4.12.3/js/i18n/grid.locale-kr.min.js

(?)

Lithuanian

free-jqgrid/4.12.3/js/i18n/grid.locale-lt.min.js

srp-ME (?)

Montenegro (?)

free-jqgrid/4.12.3/js/i18n/grid.locale-me.min.js

nl-NL

Dutch (Netherlands)

free-jqgrid/4.12.3/js/i18n/grid.locale-nl.min.js

nb-NO (?)

Norwegian

free-jqgrid/4.12.3/js/i18n/grid.locale-no.min.js

pl-PL

Polish

free-jqgrid/4.12.3/js/i18n/grid.locale-pl.min.js

pt-BR

Portuguese Brazilian

free-jqgrid/4.12.3/js/i18n/grid.locale-pt-br.min.js

pt-PT

Portuguese

free-jqgrid/4.12.3/js/i18n/grid.locale-pt.min.js

ro-RO

Romanian

free-jqgrid/4.12.3/js/i18n/grid.locale-ro.min.js

ru-RU

Russian

free-jqgrid/4.12.3/js/i18n/grid.locale-ru.min.js

sk-SK

Slovak

free-jqgrid/4.12.3/js/i18n/grid.locale-sk.min.js

sr-YU (?)

Serbian

free-jqgrid/4.12.3/js/i18n/grid.locale-sr.min.js

sv-SE

Swedish

free-jqgrid/4.12.3/js/i18n/grid.locale-sv.min.js

th-TH

Thailand

free-jqgrid/4.12.3/js/i18n/grid.locale-th.min.js

tr-TR

Turkish

free-jqgrid/4.12.3/js/i18n/grid.locale-tr.min.js

(?)

Taiwan

free-jqgrid/4.12.3/js/i18n/grid.locale-tw.min.js

en-US (?)

United States

free-jqgrid/4.12.3/js/i18n/grid.locale-ua.min.js

vi-VN

Virgin Islands

free-jqgrid/4.12.3/js/i18n/grid.locale-vi.min.js


Precede each entry with the name of the desired CDN site that you are using. Several are available.

One thing worthy of note is that the grid is entirely responsive.

Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries