Detailed analysis of jqgrid editing and adding functions_jquery

ColModel is the most important property in jqGrid, which sets the properties of table columns.

Usage:

Java code:

Copy code The code is as follows:

jQuery("#gridid" ).jqGrid({
...
colModel: [ {name:'name1', index:'index1'...}, {...}, ... ],
..
});

Properties Data Type Remarks Default Value
align string Define cell alignment; optional value ：left, center, right. left
classes string Set the css of the column. Separate multiple classes with spaces, such as: 'class1 class2'. The default css attribute of the table is ui-ellipsis empty string
datefmt string to format the date column. "/", "-", and "." are all valid date separators. y,Y,yyyy year YY, yy month m,mm for monthsd,dd day. ISO Date (Y-m-d)
defval string Query the default value of the field Empty
editable boolean Whether the cell is editable false
editoptions array Some attributes set when editing columns empty array
editrules array Some additional attribute settings for editable cells empty array
edittype string The type that can be edited. Optional values: text, textarea, select, checkbox, password, button, image and file. text
fixed boolean Whether the column width should be fixed and immutable false
formoptions array Attribute settings when editing the form empty
formatoptions array Settings for formatting certain columns none
formatter mixed Function name or type set when formatting columns none
hidedlg boolean Whether to display or hide this column false
hidden boolean During initialization Whether to hide this column when forming a table false
index string Defines the index of the sort field name when sorting, the parameter name is sidx empty string
jsonmap string defines the returned json data mapping none
key boolean When from the server When there is no id in the data returned by the client, use this as the only rowid. By default, there can only be one id attribute false
label string If colNames is empty, use this value as the display name of the column. If neither is set, use name value none
name string Required, table column name, all keywords, reserved words cannot be used as names including subgrid, cb and rn. Required
resizable boolean Whether it can be resizable true
search boolean In search mode, define whether this column can be used as a search column true
searchoptions array Set search parameters empty
sortable boolean Whether it can be sorted true
sorttype string Used when the datatype is local, define the search column Type, optional value: int/integer - Sort integer float/number/currency - Sort numbers date - Sort date text - Sort text text
stype string Define the type of search element text
surl string When searching for data url empty string
width number Default column width, which can only be pixel values, not percentages 150
xmlmap string Define the mapping relationship between the current column and the returned xml data none
unformat function 'unformat 'Cell value null

Add

to the source code. Copy the code . The code is as follows:

editurl:'index.php?do=do_edit',
addurl:'index.php?do=do_add',
datatype: 'xml',
mtype: 'GET' ,
colNames:['ID', 'Task name', 'Class'
colModel:[
:100,align:'center ',searchoptions:{sopt:['eq','ne','lt','le','gt','ge']}},
{name:'taskname', index:'taskname' , width:100, align:'center',editable:true},
{name:'classid', index:'classid', width:100, align:'center',editable:true,edittype:'select ',editoptions: {
value: '1: Transaction; 2: Non-transaction'},editselected:'classid' },

                                                                                                                                                                                                                                                                                     ],

Search

eq is equal to ( = )
ne is not equal to ( <> )lt is less than ( < )
le is less than or equal to ( <= )
gt is greater than ( > )
ge is greater than or equal to ( >= )
bw starts with ( LIKE val% )
bn does not start with ( not like val%)
in is included ( in ())
ni not in ( not in ())
ew ends with (LIKE %val )
en does not end with
cn contains (LIKE %val% )
nc Does not contain