Jqgrid_utils

Convenient Functions for free jqGrid

How to install:

   npm install jqgrid_utils 

Usage:

  <script src="../node_modules/jqgrid_utils/dist/jqgrid_utils.js"></script>

Example:

  let jqu = new Jqgrid_utils();

Source: https://github.com/myridia/jqgrid_utils/actions

Jqgrid_utils

A module for Jqgrid_utils

• Jqgrid_utils
  • module.exports#gridratio_on() ⏏
  • module.exports#grid_ratio_on(grid, fraction_col, denominator_col, ratio_col) ⏏
  • module.exports#gridsum_on() ⏏
  • module.exports#grid_sum_on(grid, fields) ⏏
  • module.exports#gridavg_on() ⏏
  • module.exports#grid_avg_on(grid, fields) ⏏
  • module.exports#gridpercent_on() ⏏
  • module.exports#grid_percent_on(grid, obj) ⏏
  • module.exports#update_row_to_api(_self, api, _ids, row) ⏏
  • module.exports#delete_row_to_api(_self, api, rowid, _ids, data) ⏏
  • module.exports#append_seperator_link_column(col_model, url, field_value, base, attr, keys) ⏏
  • module.exports#add_edit(col_model) ⏏
  • module.exports#add_textarea(col_model, edit_field) ⏏
  • module.exports#get_col_model_from_data(obj, data, exclude, col_model) ⇒ array ⏏
  • module.exports#binary_replace(cell_value, a, b) ⏏
  • module.exports#date112to_DMY(cell_value, seperator) ⏏
  • module.exports#date112_to_DMY(col_model, edit_field, seperator) ⏏
  • module.exports#add_formatter(col_model, edit_field, formatter) ⏏
  • module.exports#natural_sort(col_model, column_name) ⇒ array ⏏
  • module.exports#add_html_formatter(col_model, edit_field, html) ⇒ array ⏏
  • module.exports#add_ok_button(col_model, fields) ⇒ array ⏏
  • module.exports#get_filled_cell_table_data(_grid, fields) ⇒ array ⏏
  • module.exports#get_filled_cell_data(_grid, fields) ⇒ object ⏏
  • module.exports#set_link(col_model, edit_field, url) ⇒ object ⏏
  • module.exports#hide_all_columns_except(col_model, fields) ⇒ object ⏏
  • module.exports#hide_column(col_model, field) ⇒ object ⏏
  • module.exports#s_grid_set_caption(_grid, data) ⏏
  • module.exports#grid_set_caption(_grid, data) ⏏
  • module.exports#s_resize_saved_cell_width(col_model, page, grid) ⏏
  • module.exports#resize_saved_cell_width(col_model, page, grid) ⏏
  • module.exports#resize_cell(the, column, not) ⏏
  • module.exports#upsert_row(row, url, req) ⇒ object ⏏
  • module.exports#insert_row(row, url) ⇒ object ⏏
  • module.exports#update_row(row, url, req) ⇒ object ⏏
  • module.exports#delete_row(_id, url) ⇒ object ⏏
  • module.exports#adelete_api(url, json) ⇒ object ⏏
  • module.exports#post_json(url, data) ⇒ object ⏏
  • module.exports#put_json(url, data) ⇒ object ⏏
  • module.exports#s_hide_del_icon() ⏏
  • module.exports#hide_del_icon() ⏏
  • module.exports#add_link_details_csv(col_model, url, edit_field, attr, keys, format, seperator) ⏏
  • module.exports#compare(obj, column1, column2, style) ⏏
  • module.exports#set_styles(obj, style_column) ⏏
  • module.exports#add_link_details(col_model, url, edit_field, attr, keys) ⏏
  • module.exports#add_link_details_separator(col_model, url, edit_field, attr, keys) ⏏
  • module.exports#add_link_separator(col_model, url, edit_field, fields) ⏏
  • module.exports#_cellformat() ⏏
  • module.exports#subgrid(id, id, url, colmodel, caption) ⏏
  • module.exports#add_image(col_model, edit_field, size, link) ⏏
  • module.exports#set_filter(grid, data, fx, append_to) ⏏
  • module.exports#_filter() ⏏

module.exports#_grid_ratio_on() ⏏

Syncron Alias grid_ratio_on

Kind: Exported function

module.exports#grid_ratio_on(grid, fraction_col, denominator_col, ratio_col) ⏏

Get the ratio the columns values together

Kind: Exported function

Example

var jqu = new Jqgrid_utils({page:page});
      gridComplete: function()
      {
           jqu._grid_ratio_on(this, 'actual_days', 'plan_days', 'qc_eta_ratio');
      },

module.exports#_grid_sum_on() ⏏

Syncron Alias grid_sum_on

Kind: Exported function

module.exports#grid_sum_on(grid, fields) ⏏

Sum the columns values together

Kind: Exported function

Example

var jqu = new Jqgrid_utils({page:page});
gridComplete: function () {
        jqu._jqu._grid_sum_on(this, [
          "qty_icollect",
          "qty_ordered",
          "need_for_qty_ordered",
          "wait_icollect",
        ]);
      },

module.exports#_grid_avg_on() ⏏

Syncron Alias grid_avg_on

Kind: Exported function

module.exports#grid_avg_on(grid, fields) ⏏

Average the column values together

Kind: Exported function

Example

var jqu = new Jqgrid_utils({page:page});

   gridComplete: function()
      {
    jqu._grid_avg_on(this, ['diff_plan_to_actual', 'days_early', 'days_late']);
      },

module.exports#_grid_percent_on() ⏏

Syncron Alias grid_percent_on

Kind: Exported function

module.exports#grid_percent_on(grid, obj) ⏏

Percent the columns values together

Kind: Exported function

Example

var jqu = new Jqgrid_utils({page:page});
gridComplete: function () {
        jqu._jqu._grid_sum_on(this, [
          "qty_icollect",
          "qty_ordered",
          "need_for_qty_ordered",
          "wait_icollect",
        ]);
      },

module.exports#update_row_to_api(_self, api, _ids, row) ⏏

Takes the updated columns data and send it to your API post server loadComplete: async function() for the old record needs to be called, see example !

Kind: Exported function

Example

var jqu = new Jqgrid_utils({page:page});

....},
    loadComplete: async function()
    {
       $grid.jqGrid('setGridParam',{record_data:$grid.jqGrid("getGridParam").data});
    },
      afterSetRow: async function(row)
      {
        const _api = await get_api_url('sapir');
        const api = _api + '/column2';
        let info = {"msg":"failed"};
        var jqu = new Jqgrid_utils();
        info = await jqu.update_row_to_api($grid, api,['id'],row,{server : '232',db : 'sl_h',table : 'kpi',});
        for(let i in info)
        {
          log.info(info[i]);
        }
      },

module.exports#delete_row_to_api(_self, api, rowid, _ids, data) ⏏

After Delete a Grid Row send to and DELETE REST Request You need to define loadComplete and afterDelRow The Grid data needs to be saved as record within loadComplete

Kind: Exported function

Example

loadComplete: async function()
    {
       $grid.jqGrid('setGridParam',{record_data:$grid.jqGrid("getGridParam").data});
    },
      afterDelRow: async function(rowid)
      {
        const _api = await get_api_url('sapir');
        const api = _api + '/column2';
        let info = {"msg":"failed"};
          var jqu = new Jqgrid_utils();

          info = await jqu.delete_row_to_api($grid,api,rowid,['id'],{
              server : '232',
              db : 'sl_h',
              table : 'kpi',
              operator: 'delete',
        });
        log.info(JSON.parse(info).msg);
      },

module.exports#append_seperator_link_column(col_model, url, field_value, base, attr, keys) ⏏

Append and sperator based link column to the end of a row

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.append_seperator_link_column(col_model, 'http://wiki.foo.com/index.php' ,'Wiki',{"name":'wiki','label':"Wiki","width":"65px","align":"center"} ,'target="_blank"',{"report_central":"name"});

module.exports#add_edit(col_model) ⏏

add textarea

Kind: Exported function

Example

let col_model = JSON.parse(await aget_api(url + "/model"));
col_model = await jqu.add_edit(col_model, 'mon',{ edittype:'textarea', editoptions:{rows:6,cols:100} });
see for other inputfields: 
http://www.trirand.com/blog/phpjqgrid/doc/_2v80w6oam.htm

module.exports#add_textarea(col_model, edit_field) ⏏

add textarea

Kind: Exported function

Example

let col_model = JSON.parse(await aget_api(url + "/model"));
col_model = await jqu.add_textarea(col_model, 'worker','style="width:100%;height:100px"');

module.exports#get_col_model_from_data(obj, data, exclude, col_model) ⇒ array ⏏

Get basic colModel data from raw data

Kind: Exported function
Returns: array - - col_model

Example

var jqu = new Jqgrid_utils();
,loadComplete: async function(data)
{
  let col_model = jQuery(this).jqGrid('getGridParam',"colModel");
  const new_col_model= await update_col_model(this, data, ['id','cust_qty','waiting_supplier_orders','waiting_assemblies','pending_components','pending_customer_order',col_model);
  jQuery(this).jqGrid('setGridParam',{colModel:new_col_model});
},

module.exports#binary_replace(cell_value, a, b) ⏏

Replace a Binaery 0 or 1 to other given value

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
let _data = jqu.binery_replace(0,'zero','one');
or for column formatter
download_formatter:"var jqu = new Jqgrid_utils();jqu.binary_replace({0},'zero','one')"});

module.exports#_date112_to_DMY(cell_value, seperator) ⏏

Convert a 112 date string to a DMY format with sepertaor - sync function

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
let _data = jqu._date112_to_DMY('20220104','/');
console.log(_data);

module.exports#date112_to_DMY(col_model, edit_field, seperator) ⏏

Convert a 112 date to a DMY format with sepertaor

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
let _data = await jqu.date112_to_DMY(this,'field','/');
console.log(_data);

module.exports#add_formatter(col_model, edit_field, formatter) ⏏

Add Formatter

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.add_formatter(col_model,'select',{ formatter: "select", formatoptions: {value: "1:ok;0:fail", defaultValue: "1" }})

module.exports#natural_sort(col_model, column_name) ⇒ array ⏏

Natural Sort Column

Kind: Exported function
Returns: array - - col_model

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.natural_sort(col_model,'colunmename');

module.exports#add_html_formatter(col_model, edit_field, html) ⇒ array ⏏

Add HTML Formatter

Kind: Exported function
Returns: array - - col_model

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.add_html_formatter(col_model,'process',"<button tabindex='0' class='cellbtn' type='button'>Process</button>");

module.exports#add_ok_button(col_model, fields) ⇒ array ⏏

Add an OK Button

Kind: Exported function
Returns: array - - col_model

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.add_ok_button(col_model, ['checked']);

module.exports#get_filled_cell_table_data(_grid, fields) ⇒ array ⏏

Get the filled cell data

Kind: Exported function
Returns: array - - table array

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.get_filled_cell_table_dat("#gridname","fieldname");

module.exports#get_filled_cell_data(_grid, fields) ⇒ object ⏏

Get the filled cell data

Kind: Exported function
Returns: object - - json object of the colleted fields

Example

var jqu = new Jqgrid_utils();
let _data = await jqu.get_filled_cell_data(this,["P-","bulk","wholesale"]);

module.exports#set_link(col_model, edit_field, url) ⇒ object ⏏

Add an URL from the data to a specific cell/column

Kind: Exported function
Returns: object - https://foo.bar.com/av0_code/bar

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.set_link(col_model,'field_get_url','field_with_the_url','target="blank"');
console.log(_data);

module.exports#hide_all_columns_except(col_model, fields) ⇒ object ⏏

Hide all columns execpt column

Kind: Exported function
Returns: object - col_model

Example

col_model = await jqu.hide_all_columns_except(col_model,['supplier','customer']);

module.exports#hide_column(col_model, field) ⇒ object ⏏

Hide a col_model column before load the grid

Kind: Exported function
Returns: object - col_model

Example

col_model = await jqu.hide_column(col_model,'wholesale');
  col_model = await jqu.hide_column(col_model,'wholesale_formula');

module.exports#s_grid_set_caption(_grid, data) ⏏

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
loadComplete: function(){
  jqu.grid_set_caption(this);
},

module.exports#grid_set_caption(_grid, data) ⏏

Adding the row count number to the caption

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
loadComplete: function(){
  await jqu.grid_set_caption(this);
},

module.exports#s_resize_saved_cell_width(col_model, page, grid) ⏏

Kind: Exported function

Example

col_model = await jqu.resize_saved_cell_width(col_model);

module.exports#resize_saved_cell_width(col_model, page, grid) ⏏

Kind: Exported function

Example

col_model = await jqu.resize_saved_cell_width(col_model);

module.exports#resize_cell(the, column, not) ⏏

Kind: Exported function

Example

var jqu = new Jqgrid_utils({page:'mypage'});
resizeStop: jqu.resize_cell,

module.exports#upsert_row(row, url, req) ⇒ object ⏏

Upsert(insert or update) from the grid to an API

Kind: Exported function
Returns: object - {update: 'ok'} or {update: 'failed'}

Example

var jqu = new Jqgrid_utils();
afterSetRow: async function(row)
{
  let r = await jqu.upsert_row(row, 'http://api.com',{'key':'value'});
  console.log(r);
},

module.exports#insert_row(row, url) ⇒ object ⏏

Insert from the grid to an API used by the upsert_row function

Kind: Exported function
Returns: object - Object from the the API like {update: 'ok'} or {update: 'failed'}

Example

var jqu = new Jqgrid_utils();
afterSetRow: async function(row)
{
  let r = await jqu.insert_row(row, 'http://api.com');
  console.log(r);
},

module.exports#update_row(row, url, req) ⇒ object ⏏

Update from the grid to an API used by the upsert_row function

Kind: Exported function
Returns: object - Object from the the API like {update: 'ok'} or {update: 'failed'}

Example

var jqu = new Jqgrid_utils();
afterSetRow: async function(row)
{
  let r = await jqu.update_row(row, 'http://api.com',{'key':value});
  console.log(r);
},

module.exports#delete_row(_id, url) ⇒ object ⏏

Delete from the grid to an API

Kind: Exported function
Returns: object - @returns {object} Object from the the API like {delete: 'ok'} or {delete: 'failed'}

Example

var jqu = new Jqgrid_utils();
afterDelRow: async function(row)
{
  const r = await jqu.delete_row('id', 'http://api.com');
  console.log(r + ' : ' + row + ' - from API');
},

module.exports#adelete_api(url, json) ⇒ object ⏏

Async Delete request used by function delete_row

Kind: Exported function
Returns: object - @returns {object} Object from the the API like {delete: 'ok'} or {delete: 'failed'}

Example

var jqu = new Jqgrid_utils();
afterDelRow: async function(row)
{
  ret = JSON.parse(await jqu.adelete_api(url));
},

module.exports#post_json(url, data) ⇒ object ⏏

Async Post request used by the update_row function

Kind: Exported function
Returns: object - @returns {object} Object from the the API like {update: 'ok'} or {update: 'failed'}

Example

var jqu = new Jqgrid_utils();
ret = JSON.parse(await jqu.post_json(url,{'key':value,'key2':'value'}));

module.exports#put_json(url, data) ⇒ object ⏏

Async Put request used by the insert_row function

Kind: Exported function
Returns: object - @returns {object} Object from the the API like {insert: 'ok'} or {insert: 'failed'}

Example

var jqu = new Jqgrid_utils();
ret = JSON.parse(await jqu.put_json(url,{'key':value,'key2':'value2'}));

module.exports#s_hide_del_icon() ⏏

Hide the del iconf rom the grid

Kind: Exported function
Example

var jqu = new Jqgrid_utils();
jqu.hide_del_icon();

module.exports#hide_del_icon() ⏏

Hide the del iconf rom the grid

Kind: Exported function
Example

var jqu = new Jqgrid_utils();
await jqu.hide_del_icon();

module.exports#add_link_details_csv(col_model, url, edit_field, attr, keys, format, seperator) ⏏

Convert a cell into a link/url with data from another cell and spit the value by comma - CSV

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.add_link_details_csv(col_model, host + '/html/report.html' , 'tags','target="_blank"',{"tags":"tags"},',');

module.exports#compare(obj, column1, column2, style) ⏏

Compare 2 columns and give them a style class when they have different content http://www.trirand.com/jqgridwiki/doku.php?id=wiki:methods

Kind: Exported function

Example

loadComplete: async function()
{
  await jqu.compare(this,'value','value_report','greenlight');
  }

module.exports#set_styles(obj, style_column) ⏏

Set styles to individual cells, what are defined in a dedicated column

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
       loadComplete: async function() {
        await jqu.set_styles(this);
        },

module.exports#add_link_details(col_model, url, edit_field, attr, keys) ⏏

Convert a cell into a link/url with data from another cell

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.add_link_details(col_model,'http://foo.bar' , 'style','target="_blank"',{'key':'style'});
col_model = await jqu.add_link_details(col_model, host + '/html/table_size.html' , 'database','target="_blank"',{"database":"database","server":"server"});

module.exports#add_link_details_separator(col_model, url, edit_field, attr, keys) ⏏

Convert a cell into seperated based link/url like https://foo.bar.com/field/value/field/value

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
col_model = await jqu.add_link_details_separator(col_model, url1 , 'style','target="_blank"',{"pricelist":"pricelist","style":"style"});                                         
col_model = await jqu.add_link_details_separator(col_model, 'https://foo.com' , 'target_column','target="_blank"',{"mykey":"myval"});

module.exports#add_link_separator(col_model, url, edit_field, fields) ⏏

Convert a cell into seperated based link/url include parameter based url like https://foo.bar.com/field.html?k=v

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
  col_model = await jqu.add_link_separator(col_model, host + '/html' , 'style',[
        {
            'field':'pricelist',
            'extension':'.html',
            'fields':{'style':'style'}
        }
    ]);
 //other example
 col_model = await jqu.add_link_separator(col_model, 'https://wiki.salamander-jewelry.net/index.php/grid_loss' , 'e',[{'field':'e'}],'target="_blank"');

module.exports#__cell_format() ⏏

Private Function

Kind: Exported function

module.exports#subgrid(id, id, url, colmodel, caption) ⏏

Kind: Exported function

Example

subGrid: true,
,subGridRowExpanded: async function(_id, id) {
let data_url2 = api + '/process_locations?f=data&process=';
let col_model_url2 = api + '/process_locations?f=col_model';
let col_model2 = JSON.parse(await vwu.aget_api(col_model_url2));
await jqu.subgrid(_id, id, data_url2, col_model2,'Locations for Process');

let data_url = api + '/process_styles?f=data&process=';
let col_model_url = api + '/process_styles?f=col_model';
let col_model = JSON.parse(await vwu.aget_api(col_model_url));
 await jqu.subgrid(_id, id, data_url, col_model,'Styles for Process');
},

or

subGrid: true,
subGridRowExpanded: async function(_id, id) {
let row_data = jQuery(this).jqGrid ('getRowData', id);
let param={f:'data','style':row_data['style'],pricelist:'P-TENENGR1'};
let data_url = api + '/order_ln';
data_url = await add_parameters(data_url, param);
let col_model_url2 = api + '/order_ln?f=col_model';
let col_model2 = JSON.parse(await vwu.aget_api(col_model_url2));
await jqu.subgrid(_id, false, data_url, col_model2,'Order Lines for ' + row_data['style']);
},

module.exports#add_image(col_model, edit_field, size, link) ⏏

Kind: Exported function

Example

col_model = await jqu.add_image(col_model, image_field, 60, false);

module.exports#set_filter(grid, data, fx, append_to) ⏏

Add a filter to the website beside the grid

Kind: Exported function

Example

var jqu = new Jqgrid_utils();
var run_me_once = true;
gridComplete: async function(){
        if(run_me_once)
        {
          await jqu.set_filter(this, data, {material:[],section:[]}, '#filter');
          run_me_once = false;
        }
      },

module.exports#_filter() ⏏

private function of set_filter

Kind: Exported function